War #10 - Vault Tool Problems

[Physsion]

War #10 - Vault Tool Problems

Please post here, or send me a private message for any vault tool problems you encounter.

[Physsion]

The Deck Cost Calculator sheet in each team's secret section should now show Element percentages correctly. Thank you Jenkar for pointing out the issue.

[Jenkar]

Copy here for safekeeping (and for less history scrolling)
[12:40:02] ‹Jenkar› Upgrade calculator is bork
[12:40:21] • Jenkar makes a copy to toy around with
[12:41:59] ‹Jenkar› =if(A1="",0,sum(F7:AI7)) should be =if(A1="",0,sum(F7:BM7))
[12:43:48] ‹Jenkar› Marks are considered in element for rules purposes?
[12:44:00] ‹Jenkar› If so, right now they're considered other.
[12:44:29] ‹Jenkar› And the "Other %" cell should be =round(F10/B6*100,2)&"%" , not =round(S10/B6*100,2)&"%"
[12:44:43] ‹Jenkar› #debugging

[Jenkar]

#doublepost
SoI isn't counted in the total number of earth cards.
Which means it doesn't count towards element %. Or non-element percent, for those sillies that are not earth.

[deuce22]

Sounds exciting to see some SoI decks this war  8)

[Physsion]

Well... I've been trying my very best, but I'm no CuCN (if you're reading this, please come back) - the deck checking in the Preparations tab is working to an extent, but I haven't been able to get the in-Element upgrade checking working properly. I don't believe it checks Tinkerer decks properly, either.

I'll keep trying to get it all working, but until then, please be extra careful when submitting your decks in the vault tool - make sure your decks always contain at least 4 in-Element upgrades, and that your Tinkerer decks are legal by the updated rules: "pendulums of one target Element now count as your own Element for deckbuilding percentage and upgrade rules. You must use your own team's mark."

If you're unsure whether a deck is legal, please let mathman or I know immediately so we can check it for you. Penalties will still be applied for illegal decks.

Thanks everyone, sorry for the inconvenience and thank you for the patience.

[Jenkar]

Would :
IF(Sum(GL11:GX11)-Index(GL11:GX11,1,TeamIndex+1)>MAX(F25,DB!L37)-4,1

be what you're looking for (for the first deck, i guess you can extend it after). The max being ofc if one has relics use.
(This doesn't fix tinker)

[Jenkar]

Wow, i managed to mess up the formula above It's F26, not F25
Tinker's a little bit harder.

Hover over cards for details, click for permalink

Deck import code : [Select]

542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 5aa 5aa 5aa 5aa 5aa 5aa 75m 75m 75m 75m 75m 78q 78q 78q 8pm

Illegal bc if i choose death then i'm illegal on ups and if i choose gravy i'm illegal on in element

Hover over cards for details, click for permalink

Deck import code : [Select]

542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 5aa 5aa 5aa 5aa 5aa 5aa 75m 75m 75m 75m 78q 78q 78q 78q 8pm

Legal, i choose you death

Hover over cards for details, click for permalink

Deck import code : [Select]

4sa 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 542 8pm

Also legal same reason.

Fully updated version :
In I25 : =IF(LEN($D25)>0,(INDEX(GM25:GX25,1,TeamIndex)/F25),"")
(extend that ^down)

In J25 : =IF(LEN($D25)>0,IF(And(DB!K37 <> DB!K$32,Sum(GL11:GX11)-Index(GL11:GX11,1,TeamIndex+1)>MAX(G25,DB!L37)-4),1,IF(C25="Yes","-",IF(OR(And(I25+IF(DB!K37=DB!K$34,10%,0) <50%,Not(And(DB!K37 = DB!K$32,Sum(GZ10:HK10)+If(Index(GZ10:HK10,1,TeamIndex)=0,1,0) <> 12))),H25>B$35,AND(DB!K37=DB!K$32,NOT(RIGHT(D25,3)=INDEX(GL$1:GX$1,1,TeamIndex+1)))),1,0))),"")
extend  ^down

In GZ10 : =if(or(INDEX($GM25:$GX25,1,TeamIndex)+COUNTIF($BT25:$EB25,GM$36)+COUNTIF($BT25:$EB25,GM$37)< $F25/2,Sum($GL11:$GX11)-Index($GL11:$GX11,1,TeamIndex)-Countif($BT25:$EB25,GM$37)>MAX($G25,DB!$L37)-4),1,0)
extend ^ down AND right (to HK15)

You're welcome to send me more examples to test.

[JonathanCrazyJ]

The vaults are not updated or ready for Round 6 input, please send help arrrghhhhh

[iancudorinmarian]

The vaults are not updated or ready for Round 6 input, please send help arrrghhhhh

Same issue here.

[mathman101]

The vaults are not updated or ready for Round 6 input, please send help arrrghhhhh

Same issue here.

My apologies, I only managed to get about half of them finished last night before passing out to exhaustion. I will have the rest completed throughout the day in between classes when I get a spare minute. my apologies for all delays this may cause in deckbuilding.

[JonathanCrazyJ]

The vaults are not updated or ready for Round 6 input, please send help arrrghhhhh

Same issue here.

My apologies, I only managed to get about half of them finished last night before passing out to exhaustion. I will have the rest completed throughout the day in between classes when I get a spare minute. my apologies for all delays this may cause in deckbuilding.

No worries MrMath, was just making sure it wasn't an issue