|
Post by parpar88 on Dec 31, 2010 15:42:25 GMT -5
under weapon slots whats the H and M for?
|
|
|
Post by varagon on Jan 1, 2011 16:22:13 GMT -5
Heavy and Melee. You get Rifle, Pistol, Heavy, Melee, Gear. It's a way to mark down what choices you get for each crew member. If I have an option to switch a P for an additional G choice, I simply put a small +g in the corner to denote I've got an option to switch out the pistol for a gear choice.
What do you think of the sheets in general?
|
|
|
Post by varagon on Jan 17, 2011 18:20:48 GMT -5
I'm a sucker for automating stuff so I've stood on the shoulders of the other contributions and added lookup functions and all stats, thus saving you from scribling everything manually. In no way does the sheet validate your entries. Gear traits are not added to stats automatically, but race and hero choices are. The sheets are protected for your data entry safety, but with no password. Instructions: Choose the sheet matching your crew template and select relevant values in the light blue fields starting with your faction choice. Pretty simple. That's great. Keep the improvements coming team!
|
|
|
Post by abbysdad on Jan 17, 2011 18:25:31 GMT -5
Excellent work.
|
|
|
Post by dijit80 on Jan 18, 2011 17:26:24 GMT -5
Great work! Duncan
|
|
|
Post by parpar88 on Jan 25, 2011 13:55:05 GMT -5
A little update. Added OTW19 data to the sheet. How do you switch it from 2 man teams to other crew templates?
|
|
|
Post by cosworth on Jan 26, 2011 2:08:45 GMT -5
parpar88: You just click on another sheet tab. Should be at the bottom of your screen. There's a tab for each crew template
|
|
|
Post by parpar88 on Jan 27, 2011 12:03:55 GMT -5
oh duh! I feel so stupid
|
|
|
Post by cosworth on Mar 17, 2011 8:06:02 GMT -5
Some people reported excel problems with the file, so I've run it through a compatibility check. Grab version 1.4 from THIS page V.1.3 was running just fine in openoffice.
|
|
|
Post by ibasse on Mar 17, 2011 11:28:57 GMT -5
Very nice. Chorts seem to have - 1 MA instead of + 1 MA though.
|
|
|
Post by lorka on Mar 17, 2011 12:02:09 GMT -5
Thats been fixed in the latest version
|
|
|
Post by ibasse on Mar 17, 2011 14:00:46 GMT -5
Never mind. Apparently opened the wrong file. Cheers. Again, really nice spreadsheet.
|
|
|
Post by cosworth on May 30, 2011 9:38:49 GMT -5
Spreadsheet updated to include Black Site Prison gangs etc. No beasts though Linky
|
|