Post by: Physsion on August 16, 2016, 05:42:20 am
Please post here, or send me a private message for any vault tool problems you encounter.
Post by: Physsion on August 17, 2016, 10:44:42 am
Post by: Jenkar on August 17, 2016, 12:32:55 pm
[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
Post by: Jenkar on August 27, 2016, 08:25:15 pm
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.
Post by: deuce22 on August 28, 2016, 03:25:41 pm
Post by: Physsion on September 01, 2016, 12:23:16 am
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.
Post by: Jenkar on September 01, 2016, 06:17:50 am
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)
Post by: Jenkar on September 03, 2016, 08:27:28 pm
Tinker's a little bit harder.
Illegal bc if i choose death then i'm illegal on ups and if i choose gravy i'm illegal on in element
Legal, i choose you death
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.
Post by: JonathanCrazyJ on October 04, 2016, 10:19:18 am
Post by: iancudorinmarian on October 04, 2016, 11:10:25 am
The vaults are not updated or ready for Round 6 input, please send help arrrghhhhh :)Same issue here.
Post by: mathman101 on October 04, 2016, 02:09:18 pm
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.
Post by: JonathanCrazyJ on October 04, 2016, 05:23:46 pm
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 :)
Post by: mathman101 on October 04, 2016, 07:29:14 pm
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.
All Vaults should be ready for Round 6 now.