Recently, I've been made aware that Jen-i, Jenkar, Napalm and few others are working on a project to build the new vault/tools. Joining the discussion, I finally decided to reveal what I used in the previous 2 wars. So, before I forgot about this again,
HERE (
https://spreadsheets.google.com/spreadsheet/ccc?key=0ApI-50p2LmlcdHlOSy1DcWJMSjZNb2cyTGxjczNEVmc&hl=en_US) is the spreadsheet. It was in excel in war #2, and I transferred it to googlesheet in war #3.
Bear in mind this is a separate tools; not an integrated vault that SG is proposing. Also I'm saying this again, I'm still reluctant to have an integrated compulsory vault because I feel it would leads to lots of problems. Btw, the spreadsheet is still on view only because I don't want people messing with the formulas.
So, here are some details about the sheet. I'll go tab by tab (prepare for wall of text!)
A. Main PanelThis tab is open for edits.[/li]Most inputs will be entered here (apart from the initial vault and D&S)[/li]The top part (Deck verifier) is reusable - I kept it as reusable because decks' history are already kept in the forum thread. It also doesn't interfere with the vault; the sole purpose is to check the decks legality.[/li]The lower part (DSCP) is divided by rounds. Basically here is where you input the DSCP (all in deck codes format). This affect the vault, so it's pretty critical.[/li]
B. D&S OverviewThis tab is open for edits too.[/li]It's also reusable but this mainly because I hate creating duplicate tabs just for the same reason. Besides, the codes are in the Main Panel and cards should already been posted in forum threads. Also, it doesn't interfere with the vault directly.[/li]To use it; copy paste the deck codes - your own decks and your opponents deck if you won that particular match. This will give an overview of the possible DS options. After selecting the cards, two long deck codes will be generated (cell K17 & Q17). Then, copy-paste these codes to the corresponding cells in the Main Panel tab.[/li]
C. VaultThis tab will be kept for view only (locked)[/li]A proper name should be CURRENT vault as it shows the cards you currently have.[/li]Nothing much here other than the cards, your team (main element), percentage of your main element and number of players able to play.[/li]The number of players can be adjust easily (if the rules change). It points to a slightly hidden table at the bottom.[/li]
D. Deck VerifierThis tab will be kept for view only (locked).[/li]It's reusable and it depends on the input from the Main Panel.[/li]Basically this is where the formula is stored to determine the decks legality.[/li]It also served the purpose of identifying what is causing a deck to be illegal.[/li]There's few problems and limitations to this function, but I'll describe it below.[/li]
E. Disc_Salv_ConvThis tab will be kept for view only (locked).[/li]It's NOT reusable since it is keeping track of all the DSCP from the beginning. It also take the input from the Main Panel.[/li]Basically this is where the formula is stored for DSCP.[/li]This also acts as an audit trail on what goes into and out of the vault (but in a complex way).[/li]Again, there's few problems and limitations to this function, but I'll describe it below.[/li]
F. Initial VaultThis tab is open for edits too but should be locked after vault is finalized.[/li]As the tab's name, this is where you input the cards for your initial vault.[/li]To use it; select your team (main element). This will determine the 12/24 cards rule. A fail check is available next to each card.[/li]
G. SummaryThis tab is open for edits too. [/li]Not much use other than to display your current vault and the remaining cards after decks are built in a list format. Each column can be filtered or sorted accordingly.[/li]
H. Ref.This tab will be kept for view only (locked).[/li]Formula-related use only.[/li]
Problems & Limitations (that I can think of)
- General - if the war rules will be changed drastically, this will probably not applicable anymore.
- General - if haven't noticed this yet; it DOES NOT work for Team Underworld. I haven't figure out how to tweak this spreadsheet for them, but I think it probably a lot more easier and less complex if it's built separately.
- Event cards - might need manual intervention, but some (e.g. extra discards) can be put in the penalty column.
- Deck Verifier - it doesn't check the amount of upgraded cards because cards are always considered as unupgraded in vault.
- Deck Verifier - it doesn't have a much simpler way to display what's wrong with an illegal deck.
- Deck Verifier - one illegal deck due to taking more cards from the vault will cause the subsequent decks to be marked as illegal too; regardless the cards used in the subsequent decks. Thus, you have to "fix" that particular deck before moving on to the next.
- DSCP - it works until the end only if war lasted in less than 10 rounds. But, this can be remedied easily just by adding more columns/cells/etc.
- DSCP - same with deck verifier, it doesn't have a much simpler way to display an invalid DSCP.
If I have the
time, I will probably work on points 4-8 and a separate spreadsheet for Team Underworld. Nothing in mind atm, but I think points 4-8 is possible, thanks to Jenkar for discovering the Filter() function.
So, there.. end of wall of text. Honestly, I'm not sure what good would it bring by posting this, especially when the spreadsheet is open for view only
. I just hope that this would open a discussion on how the new vault/tool should be. Also, I'm not sure what exactly the direction of this project - who is officially handling it, is it final to have an integrated vault, etc (mainly everything I asked in my earlier post). I hope that once SG is back, she will provide more attention to this. I'll gladly offer my assistance if
required.
