A
1
Welcome to the Elite Kill Team Command Roster Based Campaign Manager
2
3
4
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. Units like Crisis suits/marine Veterans/tyranid warriors will not do the color flagging. 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.
5
6
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.
7
8
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.
9
10
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).
11
12
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 a couple 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. Once you select a Unit Type, a box next to that will auto fill to indicate the maximum number of that type of unit that can be deployed in your kill team. (You can have as many as you like in the roster.) This is for your reference and is not validated at all.
13
14
Note due to the ridiculous number of potential options on things like Crisis suits and marine Veterans, the data has had to be restructured so the sheet did not take ages to function at all. (Listing every option like I had been took Adeptus Astartes from 120 lines of data to 32k!) The result of this is those units with a long list of fully optional gear will not flag red as above. Check each wargear data for any options you cannot find. A benefit to the new data format is the sheet runs much much smoother on my mobile device compared to the last version and so I've also implements a single column data card list in the Mobile Data Cards Tab.
15
16
Where an ability has text such as C121 or E96 this is a book and page number reference for the actual ability since it was too complicated for the character limit in the sheet. C121 would be Commanders book, page 121 where E96 would be Elites book page 96. Anything with p.34 notation would be from the Core rulebook page 34. 19A would indicate the 2019 Kill Team Annual.
17
18
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, no Leader or too many of a unit which has a maximum. (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) (or top to bottom in the Mobile Data Cards page).
19
20
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.
21
22
You may also enter information on the Custom Specialization sheet which appears after the Tactics pages. You can give your specialism a name and description then select abilities and tactics from the drop downs and descriptions will auto populate.
23
24
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).
25
26
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.
27
28
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!
29
30
https://paypal.me/KillTeamSheet
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
76
77
78
79
https://paypal.me/KillTeamSheet
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100