A
1
Welcome to the Kill Team Command Roster Based Campaign Manager
2
3
4
https://docs.google.com/spreadsheets/d/18a16HpniGWm-KfNBIg-1vYA8IzX6iI5VdxLm2x7kyT0/edit?usp=sharing

A new version of the sheet exists now with all the content from the Elites expansion. Unfortunately due to having to completely restructure the data handling to accomodate the free form choices presented in elites this version would no longer work. The link above will take you to the Elites version which works basically the same way as this one. Thanks everyone who contributed to helping me keep this as up to date and accurate as possible! I will no longer be posting updates to this sheet as of today, 22 May 2019 but will leave it here as a reference and pointer to the new one.
5
6
TLDR: The only things you enter are on Command Roster and Commander Data Cards. Nothing gets entered on the Commander lines on the Command Roster page except the deploy button and kill selector. Use the Deploy button and the Order selector to generate Data Cards and Tactics. If points are 0/Red you have invalid or not enough selections for gear. After adding Commanders 2-4, Units 29 and 30 from the Command Roster no longer fit on the first page so in general if you are printing the roster only print the first sheet.
7
8
This is a Google docs spreadsheet I built to assist in managing an ongoing Campaign Command Roster for the Kill Team Skirmish Game. The original formatting which I copied was done by reddit user /u/aeglos.
9
10
To use the sheet, you must first Make a copy... from the File menu option above. You must be signed in to a Google account for this option to be available. Choose a name that will be descriptive to you. I recommend making a single copy and naming it Master Copy of... Then make another copy for each team you are building/tracking.
11
12
Once you have made a copy to your own Google drive you are ready to enter your kill team. Choose the Command Roster page below and select a Faction from the drop down menu. Give the sheet a few seconds to process (based on your internet connection and computer speed but look for All changes saved in Drive in the menu line below the sheet name).
13
14
On the Command Roster page, you can enter your name, the kill team name, the current resourses of your team, number of missions, number of victories and the names of your units (but nothing on the Commander line). If you like you may also enter the squad mission, quirk, background, and unit demeanours and ignore the drop downs (which are based on the charts from the rule books). Other than that, everything in the Command Roster is selected by drop down menus. Each choice dictates the next available ones so in general give it 3ish seconds to process after a selection before trying to make the next one. You can only choose valid equipment for units. If the points for a unit are 0/RED you have made invalid selections or not enough of them. Simply check the next available wargear selector for what option you may have missed. Optional equipment will be in the next dropdown after the last mandatory selection.
15
16
To tell the sheet what to include in the data cards, simply select a unit and click the Deploy button for that unit. Note that the Points section is XXX/YYY format. This is Points Deployed/Total Points. Similarly, the Members section is XXX/YYY (AAA/BBB SP). This is Members Deployed/Members Total (Specialists Deployed/Specialists Total). Note that if the Members block turns RED you have deployed either too many specialsts, duplicate specialisms, or no Leader. (It does not compare your Roster specialisms to Commader ones which only affects Elucia and Vulgrar). You can then set the numerical order you want the unit's card to be generated in using that dropdown. The sheet will take the choices you made and find the mandatory equipment for that unit and fill in a data card with all of that information along with the name and specialist information you entered. It will then sort the cards based on the order you select (1 being first) and build the cards starting on Data Cards (1-6) and working its way through (25-30).
17
18
On the Commander Data Cards sheets, you can enter your Commanders' information. You must select a Level for them from the dropdown as well as a Unit Type. You may enter a name and select a demeanour and specialisms on the Commander's Data Card as well as the Commander Traits. If you choose Generalist or Master Specialist as a trait this will open that option as their level 4 specialist ability and once you select that the pull out below the injuries and wargear will allow you to choose those options. All the relevant information for the Commanders will be transferred over to your roster for you where you can choose to Deploy them or not. If you click one of the injury buttons for the Commander, the stats on the card will adjust except for the flesh wound which you must manually click for yourself. Psychic Powers can be selected from Psybolt, the six general ones and any which are available to the specific commander. You pick the power and the sheet will pull up the Warp Charge (WC) value and a description.
19
20
If you encounter any bugs, try RELOADING (F5), the sheet. Make sure you are allowing enough time for the dependant dropdowns to populate. I am certain there are more efficient ways to handle the data and as I explore them to improve performance they will be implemented but in the meantime just realize it takes a couple seconds for the next option to load after you select one. If you find any ERRORS in logic, typos, points, anything PLEASE LET ME KNOW via the comment feature of the sheet or a post or direct message to me in the media you found this. I've made every effort to check my work but I'm sure there are some things that slipped though (there always are) and I greatly appreciate the help in improving this for everyone. Thanks in advance for the bug reports! Also I'm always open to suggestions for improvements or features that could be implemented so feel free to forward those along (this whole sheet arose from a suggestion on the last one I built).
21
22
If for any reason you overwrite something and can't simply Undo (CTRL Z), I recommend simply starting with a fresh copy of the sheet. In general this version (unlike the last) takes relatively little time to refill due to needing to make many many fewer selections (grenades!) and likely will be easier than trying to wade through my shoddy, inefficient, and unintuitive coding and logic. This is why the initial recommendation was to have a Master Copy saved locally. I can help with limited troubleshooting so feel free to shoot questions my way via the media you found this or the sheet comments.
23
24
Thanks for checking this out. Hopefully its not too complicated. Per suggestions I've decided to add a PURELY VOLUNTARY donation link to this sheet. If you feel like contributing to my time to maintain the sheet with factions/errata/expansions, let me THANK YOU! Ultimately it is not necessary as I intend to upkeep this for the forseeable life of the game but I do appreciate the show of support! Enjoy and maybe some day one of my (far too many) Teams will get to face one of yours!
25
26
https://paypal.me/KillTeamSheet
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
https://paypal.me/KillTeamSheet
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100