Vaultsimulations

[kaempfer13]

aether
air
darkness
death (for training purposes)
earth
entropy
fire
gravity
life
light
time
water



How to use:
Up to date only for the elements we fight r3 (in light of results including r2) (I can and will modify the others just probably not this round).

You can (and for now I limited your rights to pretty much just that) modify our assumption of people's salvage and discards in the sheets "Presumed_Salvage" and "Presumed_Discards".
In presumed discards you can see the discardable cards of each deck that lost in column B (just the code) and F (link to deckimg). The only thing you have to do here is fill in the deck code of the cards you think they discarded from that deck in column C (and wait for me to update everything). You will be able to see the impact of that in discardsvault. Filling in nonsense in any cell in C will have nonsensical results in the vault simulation. Number of discards in D and especially E can be inaccurate, pls doublecheck them.
In Presumed_Salvage you can see code in column B, deckim in E. You can fill in the deckcode of the presumed salvage in column D. This affects both discardsvault and salvagevault (again any cell in D does, even if there is no deck next to it, so dont fuck with that).

Vault_that_has_been_shown should show the vault of the element that has been explicitly shown (assuming I updated it) and is the basis for salvagevault. For theories about them packing more of some cards then they used in any round at once, you can experiment with the sheet presumed vault (this will be abundantly clear if discardsvault contains negative cards or less then they use).

Pls report any problems you find

[kaempfer13]

Everything up to date!
remaining errors:
-vault discards are all wrong
- wm ruling of light water match is not reflected in the list affecting 1 match of all 4 sheets in the light and water vaultsimulation
- when vsing a buccaneer and losing deckdiscards are not reduced as they should be (by 2 normally, 4 if role was discard)

What has been done already:
-as of time of this writing only those discards and salvages where people had no choice in the matter (other than transmuting instead) have been completed
-revealed vaults are up to date for r3



now try filling in what you would have discarded/salvaged (perhaps use a different colored pen, so I can see that this is not guaranteed they actually did that)

for instance we know for sure that darkness salvaged pulvy from entropy.

[kaempfer13]

Added new sheet 'discardsimg'. It shows pictures of the discardable cards in decks that lost. For some reason the deckimages start with cache rather than deck if there are less than 10 cards, which is why some pictures dont show. I could work around that with an if condition, but with how little you used it so far I'm not sure its worth bothering.
This means you dont have to know card codes by heart or tediously open each link to see what cards they might have discarded.