War #12 - Google Sheets Errors

[mathman101]

War #12 - Google Sheets Errors


If you find an error with the Vault Building Gdoc, or the Vault Gdoc, please post here and we will try our best to fix it as soon as we are able to.



List of currently found and fixed errors:

Spoiler for :

Found and not yet fixed
Sideboard not showing proper upgrade amount
Tinkerer showing incorrect in-element upgrades


Fixed

points total not calculating properly for using all points if divisible by 5.
Coupons not applied properly to market costs.
Cells not calculating total points spent in certain columns in certain elements
max limit of 9 and 24 based on wrong element
Vault sheets cannot be edited except by WMs
Upgrades boost to be removed
no illegal notification when using cards not in vault.

[Aves]

The cost calculation formulas are missing in the first and third rows for the Vault Cost Calculator. Life, Fire, Water, Light, and Air work, the rest don't.

Edit: It just so happened that all of my random value entries ended up making it look that way. All elements have rows where the formulae are missing.

[rob77dp]

The cost calculation formulas are missing in the first and third rows for the Vault Cost Calculator. Life, Fire, Water, Light, and Air work, the rest don't.

Edit: It just so happened that all of my random value entries ended up making it look that way. All elements have rows where the formulae are missing.

The Death vault doc is missing lots of various "totals"... at first I just thought we managed to find a way to build a great, cheap vault. But no Some in-element cards don't total, and lots of out-element cards are also not totaling. Thanks WM's for your hard work- and of course in advance for your attention to this hiccup too. :-)

[Jen-i]

The cost calculation formulas are missing in the first and third rows for the Vault Cost Calculator. Life, Fire, Water, Light, and Air work, the rest don't.

Edit: It just so happened that all of my random value entries ended up making it look that way. All elements have rows where the formulae are missing.

The Death vault doc is missing lots of various "totals"... at first I just thought we managed to find a way to build a great, cheap vault. But no Some in-element cards don't total, and lots of out-element cards are also not totaling. Thanks WM's for your hard work- and of course in advance for your attention to this hiccup too. :-)

Super easy fix for the WM's:
(1) For the top row of elements (Other - Earth) - the formula is missing from the top five rows of the total column
(2) For the bottow row of elements (Time - Aether) - the formula is missing from all the rows in the total column

On another note - is there a means of simulating which coupon is being used? Or does that need to be done manually?

[moehrpi]

On another note - is there a means of simulating which coupon is being used? Or does that need to be done manually?

Just a simple display of totals for perms, spells, creatures respectively would be great.

[kaempfer13]

On another note - is there a means of simulating which coupon is being used? Or does that need to be done manually?

Just a simple display of totals for perms, spells, creatures respectively would be great.

http://elementscommunity.org/forum/war/war-12-general-discussion/msg1283233/#msg1283233

[Jen-i]

I think the error check for total vault is incorrect.

It checks that the total value of the vault is less than cell V47, not less than or equal to the value of the cell.

S50:
Incorrect Formula =if(or(S47>=V47,Z59,T48<50),"No","Yes")
Correct Formula =if(or(S47>V47,Z59,T48<50),"No","Yes")

[ddevans96]

Deck cost calculator appears to still be using old market prices.

[kaempfer13]

Indeed, it looks in commonDB where the old prizes still are. really the sheets should have been updated to the point where the marketprices are in commonDB and everything else just uses vlookup to extract the marketprices from said sheet.
Also, the thing with it declaring a vault that uses exactly all points illegal is still not fixed (just like Jen-i said, simply remove the equal sign)

[Manuel]

but the vault has the new prices, right? is only the second sheet with the calculator to be "broken", right?

[Zawadx]

I'm sorry for jenkaring up all the sheets last time guys D: I promise I'll help fix it up soon^TM

[mathman101]

All Gdocs have been updated with the teams selected coupons. You can see which coupon you have selected under your element name in the doc (Q56).

As a reminder if teams would like additional security for their vaults, please pm a list of email addresses for your team and the WMs will change the sharing access to only those addresses instead of just from the link.