*Author

Offline Wyand

  • War Planning Team
  • ***
  • *****
  • Posts: 1170
  • Country: hu
  • Reputation Power: 21
  • Wyand is a Mummy waiting to discover the path to glory.Wyand is a Mummy waiting to discover the path to glory.Wyand is a Mummy waiting to discover the path to glory.Wyand is a Mummy waiting to discover the path to glory.
  • Not So Young Elemental
  • Awards: Weekly 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 http://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
<---- 6 cups and 2 cakes on a red platter, a box of candies and an ice cream cone on chocolate! :) Bon appétit!

Offline RavingRabbid

  • Legendary Member
  • ******
  • Posts: 5038
  • 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 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 http://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
  • ********
  • *****
  • Posts: 2160
  • Country: ca
  • Reputation Power: 48
  • 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 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.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: