*Author

Offline mathman101Topic starter

  • Administrator (Warblind)
  • ********
  • *
  • Posts: 2223
  • Country: ca
  • Reputation Power: 49
  • mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.
  • I like pet 'thoup!!
  • Awards: Slice of Elements 11th Birthday Cake13th Trials - Master of LifeSlice of Elements 10th Birthday CakeSlice of Elements 9th Birthday CakeBrawl #7 Winner - Green NightWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 8th Birthday CakeWeekly Tournament WinnerSlice of Elements 7th Birthday CakeSilver DonorWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 6th Birthday CakeWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 5th Birthday CakeSlice of Elements 4th Birthday Cake
War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283221#msg1283221
« on: December 12, 2018, 05:26:38 am »
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 :death
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.
« Last Edit: January 15, 2019, 03:42:15 pm by mathman101 »
something....something....something.....

Offline Aves

  • Competition Organizer
  • *****
  • *
  • Posts: 2761
  • Reputation Power: 42
  • Aves soars like the Phoenix, unable to be repressed.Aves soars like the Phoenix, unable to be repressed.Aves soars like the Phoenix, unable to be repressed.Aves soars like the Phoenix, unable to be repressed.Aves soars like the Phoenix, unable to be repressed.Aves soars like the Phoenix, unable to be repressed.Aves soars like the Phoenix, unable to be repressed.Aves soars like the Phoenix, unable to be repressed.
  • ~Lorem Ipsum Dolor Sit Amet~
  • Awards: Slice of Elements 10th Birthday CakeBest Looking Forum Profile Slice of Elements 9th Birthday CakeWeekly Tournament WinnerSlice of Elements 8th Birthday CakeForum Brawl #6 Winner - The Tentacle's GripSilver DonorBattle League 2/2016 2nd PlaceWinner of Card Design War #3Slice of Elements 7th Birthday CakeBattle League 1/2016 1st PlaceWeekly Tournament WinnerWeekly Tournament WinnerWar #9 Winner - Team DarknessWeekly Tournament WinnerSlice of Elements 5th Birthday CakeSlice of Elements 4th Birthday CakeSlice of Elements 3rd Birthday Cake
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283222#msg1283222
« Reply #1 on: December 12, 2018, 05:55:18 am »
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.
« Last Edit: December 12, 2018, 05:58:16 am by Aves »
:darkness War # 4, 9, 10
:darkness League of Shadows :darkness Brawl # 5

The Tentacle's Grip Brawl # 6

Offline rob77dp

  • Legendary Member
  • ******
  • Posts: 2826
  • Country: us
  • Reputation Power: 52
  • rob77dp brings all the vitality and activity of a Life Nymph.rob77dp brings all the vitality and activity of a Life Nymph.rob77dp brings all the vitality and activity of a Life Nymph.rob77dp brings all the vitality and activity of a Life Nymph.rob77dp brings all the vitality and activity of a Life Nymph.rob77dp brings all the vitality and activity of a Life Nymph.rob77dp brings all the vitality and activity of a Life Nymph.rob77dp brings all the vitality and activity of a Life Nymph.rob77dp brings all the vitality and activity of a Life Nymph.rob77dp brings all the vitality and activity of a Life Nymph.
  • Am I back?!? Time zone US Central -5/-6GMT
  • Awards: Slice of Elements 11th Birthday CakeSlice of Elements 10th Birthday CakeWinner of Team PvP #812th Trials - Master of DeathWinner of 12 Lives #4Slice of Elements 9th Birthday CakeSlice of Elements 8th Birthday CakeForum Brawl #6 Winner - The Tentacle's Grip10th Trials - Master of DeathWeekly Tournament WinnerSlice of Elements 7th Birthday CakeTeam Competition - The Spy Who EMed MeGold Donor9th Trials - Master of DeathSlice of Elements 6th Birthday CakeSlice of Elements 5th Birthday Cake7th Trials - Master of Death
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283223#msg1283223
« Reply #2 on: December 12, 2018, 06:42:41 am »
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. :-)
Death War #12/TBD TTG Brawl #6/1st Death War #10/9th GP Brawl #5/6th Death War #9/9th MoL Brawl #4/3rd Water War #8/7th DDD Brawl #3/3rd*Death War #7/5th*Death War #6/11th

Offline Jen-i

  • Hero Member
  • *****
  • Posts: 1975
  • Country: ca
  • Reputation Power: 0
  • Jen-i hides under a Cloak.
  • Death to the Ninja!
  • Awards: Weekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 10th Birthday CakeElements League 2/2018 2nd PlaceSlice of Elements 8th Birthday CakeWeekly Tournament WinnerBattle League 2/2014 3rd Place8th Trials - Master of LightWinner of SacrificeWeekly Tournament WinnerBattle League 1/2014 1st PlaceSlice of Elements 5th Birthday CakeWar #7 Winner - Team AetherWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 4th Birthday CakeBest Sportsman - War #6Weekly Tournament WinnerWinner of Team PvP #514 Club - Most Expensive Players during War AuctionWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerBrawl #1 Winner - Team Nyan SharksBeginners League 1/2012 3rd PlaceWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerChampionship League 2/2011 3rd PlaceWeekly Tournament WinnerChampionship League 1/2011 3rd PlaceWeekly Tournament WinnerWeekly Tournament Winner
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283226#msg1283226
« Reply #3 on: December 12, 2018, 04:10:35 pm »
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?
« Last Edit: December 12, 2018, 05:04:53 pm by Jen-i »
Lux Kyrie

Offline moehrpi

  • Sr. Member
  • ****
  • Posts: 518
  • Country: de
  • Reputation Power: 8
  • moehrpi is a Spark waiting for a buff.
  • Not War
  • Awards: Weekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament Winner	- March 312018 - PvP World ChampionWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament Winner April 14thWeekly Tournament WinnerElements League 3/2017 3rd PlaceWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament Winner
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283239#msg1283239
« Reply #4 on: December 13, 2018, 01:21:27 am »
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.

Offline kaempfer13

  • Legendary Member
  • ******
  • Posts: 2048
  • Country: de
  • Reputation Power: 34
  • kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.
  • Awards: Slice of Elements 11th Birthday CakeOEtG Rags to Riches WinnerWeekly Tournament WinnerElements League 3/2018 2nd PlaceWeekly Tournament WinnerWeekly Tournament WinnerThere Can Be Only One - 2018 WinnerWeekly Tournament Winner12th Trials - Master of TimeSlice of Elements 9th Birthday CakeWeekly Tournament WinnerElements League 2/2017 2nd PlaceWeekly Tournament WinnerWinner of Draft #4 - PvP EventSlice of Elements 8th Birthday CakeWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerDeckbuilding Competition: It's Greek to MeWeekly Tournament Winner
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283240#msg1283240
« Reply #5 on: December 13, 2018, 01:32:40 am »
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
:gravity War 10
:death and tied for master of STANDIN War 11
Master of :time War 12

Offline Jen-i

  • Hero Member
  • *****
  • Posts: 1975
  • Country: ca
  • Reputation Power: 0
  • Jen-i hides under a Cloak.
  • Death to the Ninja!
  • Awards: Weekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 10th Birthday CakeElements League 2/2018 2nd PlaceSlice of Elements 8th Birthday CakeWeekly Tournament WinnerBattle League 2/2014 3rd Place8th Trials - Master of LightWinner of SacrificeWeekly Tournament WinnerBattle League 1/2014 1st PlaceSlice of Elements 5th Birthday CakeWar #7 Winner - Team AetherWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 4th Birthday CakeBest Sportsman - War #6Weekly Tournament WinnerWinner of Team PvP #514 Club - Most Expensive Players during War AuctionWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerBrawl #1 Winner - Team Nyan SharksBeginners League 1/2012 3rd PlaceWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerChampionship League 2/2011 3rd PlaceWeekly Tournament WinnerChampionship League 1/2011 3rd PlaceWeekly Tournament WinnerWeekly Tournament Winner
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283348#msg1283348
« Reply #6 on: December 18, 2018, 04:37:34 pm »
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")
Lux Kyrie

Offline ddevans96

  • Legendary Member
  • ******
  • Posts: 8303
  • Country: us
  • Reputation Power: 113
  • ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.ddevans96 is a mythical and divine giver of immortality, one of the Turquoise Nymphs.
  • Frost Serpent
  • Awards: Slice of Elements 10th Birthday CakeSlice of Elements 9th Birthday CakeSlice of Elements 8th Birthday CakeSlice of Elements 7th Birthday CakeSilver Donor9th Trials - Master of WaterSlice of Elements 6th Birthday Cake8th Trials - Master of WaterSlice of Elements 4th Birthday CakeSlice of Elements 3rd Birthday CakeWinner of the Harry Potter PvP House CupSlice of Elements 2nd Birthday Cake
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283389#msg1283389
« Reply #7 on: December 19, 2018, 12:18:17 pm »
Deck cost calculator appears to still be using old market prices.
Former Master of Water - False God Enthusiast
Twitch Affiliate - Celeste Speedrunner - Discord: ddevans96#6710
Avatar: Makoto [Persona 5] by asukabaka

Offline kaempfer13

  • Legendary Member
  • ******
  • Posts: 2048
  • Country: de
  • Reputation Power: 34
  • kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.kaempfer13 is a Ghost, obsessed with their Elemental pursuits.
  • Awards: Slice of Elements 11th Birthday CakeOEtG Rags to Riches WinnerWeekly Tournament WinnerElements League 3/2018 2nd PlaceWeekly Tournament WinnerWeekly Tournament WinnerThere Can Be Only One - 2018 WinnerWeekly Tournament Winner12th Trials - Master of TimeSlice of Elements 9th Birthday CakeWeekly Tournament WinnerElements League 2/2017 2nd PlaceWeekly Tournament WinnerWinner of Draft #4 - PvP EventSlice of Elements 8th Birthday CakeWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerDeckbuilding Competition: It's Greek to MeWeekly Tournament Winner
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283390#msg1283390
« Reply #8 on: December 19, 2018, 12:40:07 pm »
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)
:gravity War 10
:death and tied for master of STANDIN War 11
Master of :time War 12

Offline Manuel

  • Hero Member
  • *****
  • Posts: 1658
  • Country: it
  • Reputation Power: 22
  • Manuel is a Mummy waiting to discover the path to glory.Manuel is a Mummy waiting to discover the path to glory.Manuel is a Mummy waiting to discover the path to glory.Manuel is a Mummy waiting to discover the path to glory.
  • Awards: Weekly Tournament WinnerWeekly Tournament Winner12th Trials - Master of AirSlice of Elements 9th Birthday CakeBrawl #7 Winner - Green NightWeekly Tournament WinnerWar #11 Winner - Team LifeCard Design Competition - Help Wanted WinnerWeekly Tournament WinnerCard Competition - ChampionSlice of Elements 8th Birthday CakeSlice of Elements 7th Birthday CakeWeekly Tournament Winner
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283391#msg1283391
« Reply #9 on: December 19, 2018, 03:17:54 pm »
but the vault has the new prices, right? is only the second sheet with the calculator to be "broken", right?

Offline Zawadx

  • Legendary Member
  • ******
  • Posts: 3196
  • Country: aq
  • Reputation Power: 53
  • Zawadx brings all the vitality and activity of a Life Nymph.Zawadx brings all the vitality and activity of a Life Nymph.Zawadx brings all the vitality and activity of a Life Nymph.Zawadx brings all the vitality and activity of a Life Nymph.Zawadx brings all the vitality and activity of a Life Nymph.Zawadx brings all the vitality and activity of a Life Nymph.Zawadx brings all the vitality and activity of a Life Nymph.Zawadx brings all the vitality and activity of a Life Nymph.Zawadx brings all the vitality and activity of a Life Nymph.Zawadx brings all the vitality and activity of a Life Nymph.
  • Officially Eisoptrophobic
  • Awards: Slice of Elements 8th Birthday CakeSlice of Elements 7th Birthday CakeWeekly Tournament WinnerCompetition - Won War as a Worthless WarriorWeekly Tournament WinnerSlice of Elements 6th Birthday CakeWar #8 Winner - Team FireBrawl #3 Winner - Divine LightSlice of Elements 5th Birthday Cake
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283411#msg1283411
« Reply #10 on: December 20, 2018, 06:26:11 am »
I'm sorry for jenkaring up all the sheets last time guys D: I promise I'll help fix it up soonTM
When you play the game of thrones, you win or you die. There is no middle ground.

Offline mathman101Topic starter

  • Administrator (Warblind)
  • ********
  • *
  • Posts: 2223
  • Country: ca
  • Reputation Power: 49
  • mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.mathman101 is towering like an Amethyst Dragon over their peers.
  • I like pet 'thoup!!
  • Awards: Slice of Elements 11th Birthday Cake13th Trials - Master of LifeSlice of Elements 10th Birthday CakeSlice of Elements 9th Birthday CakeBrawl #7 Winner - Green NightWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 8th Birthday CakeWeekly Tournament WinnerSlice of Elements 7th Birthday CakeSilver DonorWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 6th Birthday CakeWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 5th Birthday CakeSlice of Elements 4th Birthday Cake
Re: War #12 - Google Sheets Errors http://elementscommunity.org/forum/index.php?topic=66570.msg1283572#msg1283572
« Reply #11 on: December 28, 2018, 03:07:12 am »
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.
something....something....something.....

 

anything
blarg: