*Author

Offline Wyand

  • Tournament Organizer
  • *****
  • ******
  • Posts: 2281
  • Country: hu
  • Reputation Power: 37
  • Wyand is a Gargoyle, dangerous and everlasting.Wyand is a Gargoyle, dangerous and everlasting.Wyand is a Gargoyle, dangerous and everlasting.Wyand is a Gargoyle, dangerous and everlasting.Wyand is a Gargoyle, dangerous and everlasting.Wyand is a Gargoyle, dangerous and everlasting.Wyand is a Gargoyle, dangerous and everlasting.
  • Not So Young Elemental
  • Awards: Slice of Elements 15th Birthday CakeSlice of Elements 14th Birthday CakeSlice of Elements 13th Birthday CakeSlice of Elements 12th Birthday CakeWeekly Tournament Winner (2020.12.27.)Weekly Tournament Winner (2020.11.15.)Weekly Tournament Winner (2020.10.11.)Weekly Tournament Winner (2020.10.04.)Weekly Tournament Winner (2020.09.14.)Weekly Tournament Winner (2020.09.05.)Slice of Elements 11th Birthday CakeWeekly Tournament Winner 2020.1.1913th Trials - Master of EntropyWeekly Tournament WinnerWeekly Tournament WinnerWeekly Tournament WinnerElements League 2/2019 3rd PlaceWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 10th Birthday CakeWeekly Tournament WinnerArt Competition - Winter Paint With Elements WinnerTeam Deckbuilding/Writing Competition - A Matter of Logistics WinnerArt Competition - Definitely A Card Design CompetitionSlice of Elements 9th Birthday CakeWeekly Tournament Winner
Re: War #12 - Google Sheets Errors https://elementscommunity.org/forum/index.php?topic=66570.msg1284875#msg1284875
« Reply #60 on: January 26, 2019, 09:46:17 pm »
we are having incorrect number of players again, halp
<---- A nice purple pie, shiny cups and a trio of cakes on a red platter, a box of candies and an ice cream cone on chocolate! :) Bon appétit!

"It's hard to detect good luck - it looks so much like something you've earned." - Frank A. Clark

Offline RavingRabbid

  • Legendary Member
  • ******
  • Posts: 5044
  • Country: it
  • Reputation Power: 85
  • RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.
  • Lord Seagull
  • Awards: Slice of Elements 11th Birthday CakeSlice of Elements 10th Birthday CakeSlice of Elements 7th Birthday CakeDeckbuilding Competition: The Face of Mother NatureSlice of Elements 6th Birthday Cake7th Trials - Master of WaterWinner of Warrior's Preparation - PvP Event14 Club - Most Expensive Players during War AuctionWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 3rd Birthday CakeTeam PVP #1 Winner5th Trials - Master of Water3rd Trials - Master of WaterChampionship League 3/2011 WinnerWinner of 2nd Off-Topic Quiz LeagueWinner of 2nd Element Quiz LeagueWinner of 1st Off-Topic Quiz LeagueWinner of 1st Element Quiz LeagueChampionship League 2/2011 WinnerSlice of Elements 2nd Birthday Cake3-Man Team PvP #1 Winner
Re: War #12 - Google Sheets Errors https://elementscommunity.org/forum/index.php?topic=66570.msg1284876#msg1284876
« Reply #61 on: January 26, 2019, 09:48:48 pm »
we are having incorrect number of players again, halp
solution is to ff vs water
There are things worse than eating tuna directly from the tin

Offline mathman101Topic starter

  • Administrator (Warblind)
  • ********
  • ********
  • Posts: 2227
  • 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 https://elementscommunity.org/forum/index.php?topic=66570.msg1284878#msg1284878
« Reply #62 on: January 26, 2019, 10:08:37 pm »
I noticed that from the matches where we have more than 6 salvage, the cards we can transmute from does not scale? I figured that if your salvage is 9 cards, you may transmute from 9 cards.

It looks like the code is pulling off of the wrong cells. This should be fixed now.
# Transmute (B21) still shows (6 - G12) > 0 inside the formula: 6 minus the number of salvaged cards. This part likely needs to be (C12 - G12) > 0
Otherwise you are not allowed to transmute if you salvage 6 cards.
Number of transmutable cards does display correctly when salvaging less than 6 cards.


I see what you are saying now, I caught the mixup in part of the code, and missed it in another.

originally was this: =If((6-G12)>0,IF(J$11>ROW(B22)-21,6-G12,""),"")
I changed it to this: =If((6-G12)>0,IF(J$11>ROW(B22)-21,C12-G12,""),"")
but should be this: =If((C12-G12)>0,IF(J$11>ROW(B22)-21,C12-G12,""),"")

Should be fixed now, but if this still isn't working right please let me know and I'll try again.


@WMs - Team Earth's vault is experiencing a similar issue.  Please Help!

I double checked and this should be fixed on all 12 team vaults.



16 hours left and my vault still show incorrect number of dust for transmutation

All teams should have the proper dust amounts in relation to this wars market costs.


we are having incorrect number of players again, halp

I am not seeing the error on this end, even after trying to play with the player position cells. Remember to have your player positions selected from the dropdown options in cells B35 to B43. If you have a full team of 4 players selected, and the error is still popping up I will look into it. Currently I am unable to reproduce the error, sorry.
something....something....something.....

 

blarg: