If anyone who is more fluent in gdoc stuff and is able to help us we would greatly appreciate any assistance to help reduce time trying to decipher the coding language used in the gdocs from previous WMs.
"previous WMs" hehe.
The drop down lists can be accessed by clicking their cell and then Data>Data Validation. The ones for role are in the DB sheet. Mind you, the ones for the drop down list are K3:K9, but that's after collating the role in! To edit the roles, we mustn't touch this part but look at the stuff below.
You can also edit upgrade amounts and transmute costs from DB sheet, and everything else for vault work is in the Preparation sheet. The DB sheet also has a teamindex and round number, which is useful to track stuff!
So to fix the upgrade boost, we need to:
1. Change K23 from "#2 Lieutenant" to "#2 Soldier", since Lt is no longer a must have boost
1.5 Change K29 to "lieutenant upgrades", which is a horrible name and so it'd be much easier to rename the boost in rules to "upgrades". C'mon WMs
2. Change the code for amount of upgrades in N40:N48. Currently it is "=IF(K40=K$3,15,IF(K40=K$4,12,8))+IF(M40=M$29,2,0)", a fix would be changing it to "=IF(K40=K$3,15,8+IF(M40=M$29,4,0)"
Voila!
As for implementing the Super EC bonuses, this is the perfect place to do that. Adding another if to the N40:N48 upgrade numbers adds in more ups. The other club powers are easier to implement, as salvage/discard numbers and alchemist powers were added manually.
Vault tool does not show "illegal" in the preparation section if the number of copies of a card used exceeds the number in the vault.
Ermm, this shouldn't be the case. Show me an example where this happens?
