War #12 - Google Sheets Errors

[RavingRabbid]

The vault is telling me incorrect number of players. I have no idea what I'm doing wrong.

[Wyand]

Same here. I believe it is due to the fact that most teams consist of 3 players, but there is a so-called Player 4, since there is 4 matches/round.

[mathman101]

its a bit odd that the second cell now does nothing, kind of confusing for the teams that have already put lt before the update

We apologize for the delays in getting the updates applied. For this round only if teams already had decks in place we will account for it in the confusion.

The vault is telling me incorrect number of players. I have no idea what I'm doing wrong.

Same here. I believe it is due to the fact that most teams consist of 3 players, but there is a so-called Player 4, since there is 4 matches/round.

This should be fixed for all teams now. There was an error in cell b44 for some teams not correctly reading the number of players.

[mathman101]

If you are using the current EC club bonus, chess club, the gdoc might say you have too many upgrades and mark it as illegal. We are currently looking into fixing that, but for now best advice we can offer is double and triple check the upgrade amounts. our apologies for the delays.

The chess club upgrades have been applied to all gdocs for the teams that have already selected their boost. If teams still wish to change(allowable up to deadline), please let us know if you want the chess club or are switching off of chess club so we can appropriately adjust the upgrade amounts in the gdoc.

[mathman101]

I need some assistance from someone with gdoc knowledge. (Zawa again maybe?)

I noticed that tinkerer is reporting illegal decks for not enough in-element upgrades. Looking at the decks the upgrades are on the pends which count as in-element, thus also count as in-element ups. Not sure if this could be related to the chess groups upgrade or something else.

Thanks for any advice so I can fix this properly for all teams.

[Manuel]

i can't edit most of cells for transumation/salvage, am i supposed to wait for the deadline of the matches or am i noob with gdocs?

[mathman101]

i can't edit most of cells for transumation/salvage, am i supposed to wait for the deadline of the matches or am i noob with gdocs?

These should not be editable yet. They will become editable at the end of the round once WMs edit the match results into the gdocs.

[mathman101]

Someone mentioned that the transmutations is currently showing incorrect dust amounts, we are looking into the coding for that.

Also someone mentioned that vault discards vs deck discards is not splitting properly based on the extra 1 or 2  discards for a 0-3 and 1-3 loss. We are also looking into this.


Please be aware of these issues going forward in the near future, and we will alert you when we have a fix for them.

[Zawadx]

its a bit odd that the second cell now does nothing, kind of confusing for the teams that have already put lt before the update

Second cell where?

I need some assistance from someone with gdoc knowledge. (Zawa again maybe?)

I noticed that tinkerer is reporting illegal decks for not enough in-element upgrades. Looking at the decks the upgrades are on the pends which count as in-element, thus also count as in-element ups. Not sure if this could be related to the chess groups upgrade or something else.

Thanks for any advice so I can fix this properly for all teams.

The code is there for adding in these as in-element upps, but someone wiped it from the code (who could it be?? hmm???). You can add it back in if you replace preparation with:

=IF(LEN($D35)>0,IF(C35="Yes","-",IF(OR(I35+IF(DB!M40=DB!M$34,10%,0)<50%,H35>B$45,G35-INDEX(GO11:HA11,1,TeamIndex+1)-IF(DB!M40=DB!M$32,sum(HC2:HN2)-INDEX(HC2:HN2,1,TeamIndex),0)  >G35-4,AND(DB!M40=DB!M$32,NOT(RIGHT(D35,3)=INDEX(GO$1:HA$1,1,TeamIndex+1)))),1,0)),"")

The new term is the "-IF(DB!M40=DB!M$32,sum(HC2:HN2)-INDEX(HC2:HN2,1,TeamIndex),0)", which removes the off-element pends from off-element upps if tinkerer.

Someone mentioned that the transmutations is currently showing incorrect dust amounts, we are looking into the coding for that.

This is a bit long-winded, but it's simple enough to fix.

The transmute dust costs are listed in the sheet DB, but they are pulled from a sheet titled TransmuteCosts in the vault. This sheet in turn pulls from a sheet (Copy of Cards Algo) which contains a copy of the final market prices. You also have to define a named range "Costs", which should be 'Market Prices (by Category)'!B1:D200  (needed as sheet names with spaces tends to mess up the code). The just change the sheet link like this in A1 of TransmuteCosts:

=IMPORTRANGE("Sheet_link_here","Costs")

Also someone mentioned that vault discards vs deck discards is not splitting properly based on the extra 1 or 2  discards for a 0-3 and 1-3 loss. We are also looking into this.

There are columns in the Preparation sheet, one for total discards and one for vault discards. Editing those as needed should work out here.


Also, don't forget to update the Preparation-template (and the other hidden sheets) as they will replace the main sheet when round updates. And I turned on notifications for this thread, so maybe faster updates in the future? If I can be less busy, I guess.

[ARTHANASIOS]

Sometimes I believe we should return to the old-fashioned way of War and get rid of these annoying Google Docs. Do you guys remember the days when we had to post all of our decks into our secret section and checked by ourselves if they were legal? Yeah, memories...

[Jen-i]

Do you remember the number of penalties handed out on a regular basis for doing it wrong?

[ARTHANASIOS]

Do you remember the number of penalties handed out on a regular basis for doing it wrong?

Lol, yeah. But I think we have much greater experience these days and we would avoid such issues.

On a side note, I don't try to show disrespect to WMs and all their hard work; I just personally don't like and don't trust GDocs much...