Elements the Game Forum - Free Online Fantasy Card Game

Elements the Game => Events and Competitions => War => Topic started by: mathman101 on December 12, 2018, 05:26:38 am

Title: War #12 - Google Sheets Errors
Post by: mathman101 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:
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.
Title: Re: War #12 - Google Sheets Errors
Post by: Aves 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.
Title: Re: War #12 - Google Sheets Errors
Post by: rob77dp 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. :-)
Title: Re: War #12 - Google Sheets Errors
Post by: Jen-i 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?
Title: Re: War #12 - Google Sheets Errors
Post by: moehrpi 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.
Title: Re: War #12 - Google Sheets Errors
Post by: kaempfer13 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
Title: Re: War #12 - Google Sheets Errors
Post by: Jen-i 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")
Title: Re: War #12 - Google Sheets Errors
Post by: ddevans96 on December 19, 2018, 12:18:17 pm
Deck cost calculator appears to still be using old market prices.
Title: Re: War #12 - Google Sheets Errors
Post by: kaempfer13 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)
Title: Re: War #12 - Google Sheets Errors
Post by: Manuel 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?
Title: Re: War #12 - Google Sheets Errors
Post by: Zawadx 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
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 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.
Title: Re: War #12 - Google Sheets Errors
Post by: InsignificantWeeaboo on December 28, 2018, 03:30:09 am
I'm pretty sure I should have 24,100 points, but spending that exact amount makes my vault not legal. If I put in 24,095 points worth of stuff, it's suddenly legal again. Do discounts cost 5 points or something?
Title: Re: War #12 - Google Sheets Errors
Post by: asdw152 on December 28, 2018, 03:43:58 am
I'm pretty sure I should have 24,100 points, but spending that exact amount makes my vault not legal. If I put in 24,095 points worth of stuff, it's suddenly legal again. Do discounts cost 5 points or something?

Should be fixed.
Title: Re: War #12 - Google Sheets Errors
Post by: Wyand on December 28, 2018, 11:40:35 am
The problem lied here:

=IF(OR(S47>=V47,Z59,T48<50),"No","Yes")

Remove that "=" and it should be ok. (Current solution is very funny, but creative: adding 1 point to teams. :D )
Title: Re: War #12 - Google Sheets Errors
Post by: shockcannon on January 04, 2019, 11:26:47 pm
This might be a better place to post about this. Team Fire's Google Doc still isn't quite working. Several of the cards don't add to the total which means we're getting them for free. Our discount also does not appear to be applied.

Would appreciate if someone looked into this. Please and thank you!
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 05, 2019, 04:51:24 am
This might be a better place to post about this. Team Fire's Google Doc still isn't quite working. Several of the cards don't add to the total which means we're getting them for free. Our discount also does not appear to be applied.

Would appreciate if someone looked into this. Please and thank you!

Both issues should be fixed now. Our apologies for the delay.
Title: Re: War #12 - Google Sheets Errors
Post by: TheonlyrealBeef on January 08, 2019, 06:43:38 pm
Vault Tool still shows Upgrades as a boost.
This is my favorite boost, but I do not think we are allowed to use it anymore, yes? Please remove the option from the vault sheet in this case.
Title: Re: War #12 - Google Sheets Errors
Post by: Aves on January 08, 2019, 10:03:29 pm
Vault tool does not show "illegal" in the preparation section if the number of copies of a card used exceeds the number in the vault.
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 09, 2019, 04:05:59 am
Our apologies for the delays on the gdoc fixes, we are currently doing our best to figure them out as we go. If anyone who is more fluent in gdoc stuff and is able to help us we would greatly appreciate any assistance to help reduce time trying to decipher the coding language used in the gdocs from previous WMs.



Vault Tool still shows Upgrades as a boost.
This is my favorite boost, but I do not think we are allowed to use it anymore, yes? Please remove the option from the vault sheet in this case.

I'm currently looking into this, just trying to figure out where the drop down options are stored. should hopefully have this fixed tonight or tomorrow.


Vault tool does not show "illegal" in the preparation section if the number of copies of a card used exceeds the number in the vault.
I'll try looking at this during work tomorrow on my mobile, but most likely won't have it fixed until after work when I am back on my laptop. my apologies for the delays.
Title: Re: War #12 - Google Sheets Errors
Post by: Zawadx on January 09, 2019, 03:54:49 pm
If anyone who is more fluent in gdoc stuff and is able to help us we would greatly appreciate any assistance to help reduce time trying to decipher the coding language used in the gdocs from previous WMs.

"previous WMs" hehe.

The drop down lists can be accessed by clicking their cell and then Data>Data Validation. The ones for role are in the DB sheet. Mind you, the ones for the drop down list are K3:K9, but that's after collating the role in! To edit the roles, we mustn't touch this part but look at the stuff below.

You can also edit upgrade amounts and transmute costs from DB sheet, and everything else for vault work is in the Preparation sheet. The DB sheet also has a teamindex and round number, which is useful to track stuff!


So to fix the upgrade boost, we need to:

1. Change K23 from "#2 Lieutenant" to "#2 Soldier", since Lt is no longer a must have boost
1.5 Change K29 to "lieutenant upgrades", which is a horrible name and so it'd be much easier to rename the boost in rules to "upgrades". C'mon WMs
2. Change the code for amount of upgrades in N40:N48. Currently it is "=IF(K40=K$3,15,IF(K40=K$4,12,8))+IF(M40=M$29,2,0)", a fix would be changing it to "=IF(K40=K$3,15,8+IF(M40=M$29,4,0)"

Voila!

As for implementing the Super EC bonuses, this is the perfect place to do that. Adding another if to the N40:N48 upgrade numbers adds in more ups. The other club powers are easier to implement, as salvage/discard numbers and alchemist powers were added manually.

Vault tool does not show "illegal" in the preparation section if the number of copies of a card used exceeds the number in the vault.

Ermm, this shouldn't be the case. Show me an example where this happens?
Title: Re: War #12 - Google Sheets Errors
Post by: rob77dp on January 11, 2019, 02:42:27 am
Sooo... .... when will the Vault GDoc be updated for proper boosts and such? I mean sure we can all manually try to make sure we comply with the RULES > old-vault-setup but honest mistakes might be made that would be avoided with properly updated Vault GDoc. Right? ... right?!

Edit: That was pretty fast- I'm already seeing this edited in the vault! :o
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 11, 2019, 03:55:44 am
Vault Tool still shows Upgrades as a boost.
This is my favorite boost, but I do not think we are allowed to use it anymore, yes? Please remove the option from the vault sheet in this case.

Sooo... .... when will the Vault GDoc be updated for proper boosts and such? I mean sure we can all manually try to make sure we comply with the RULES > old-vault-setup but honest mistakes might be made that would be avoided with properly updated Vault GDoc. Right? ... right?!

Edit: That was pretty fast- I'm already seeing this edited in the vault! :o

This is fixed now, all vaults should have the proper boosts added in each of them.
Thanks very much Zawa for explaining what to change and how to do it.
Title: Re: War #12 - Google Sheets Errors
Post by: kaempfer13 on January 11, 2019, 06:50:26 pm
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
Title: Re: War #12 - Google Sheets Errors
Post by: RavingRabbid on January 11, 2019, 07:51:27 pm
The vault is telling me incorrect number of players. I have no idea what I'm doing wrong.
Title: Re: War #12 - Google Sheets Errors
Post by: Wyand on January 11, 2019, 08:15:33 pm
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.
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 11, 2019, 09:04:26 pm
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.
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 11, 2019, 10:19:05 pm
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.

Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 11, 2019, 11:44:27 pm
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.
Title: Re: War #12 - Google Sheets Errors
Post by: Manuel on January 14, 2019, 06:51:56 pm
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?
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 14, 2019, 09:59:44 pm
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.
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 16, 2019, 05:10:17 am
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.
Title: Re: War #12 - Google Sheets Errors
Post by: Zawadx on January 18, 2019, 05:24:45 am

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:

Quote
=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:

Quote
=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.


Title: Re: War #12 - Google Sheets Errors
Post by: ARTHANASIOS on January 18, 2019, 09:30:59 am
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...
Title: Re: War #12 - Google Sheets Errors
Post by: Jen-i on January 18, 2019, 11:31:14 am
Do you remember the number of penalties handed out on a regular basis for doing it wrong?
Title: Re: War #12 - Google Sheets Errors
Post by: ARTHANASIOS on January 18, 2019, 11:56:07 am
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...
Title: Re: War #12 - Google Sheets Errors
Post by: Manuel on January 19, 2019, 07:47:23 am
16 hours left and my vault still show incorrect number of dust for transmutation
Title: Re: War #12 - Google Sheets Errors
Post by: JonathanCrazyJ on January 19, 2019, 01:05:04 pm
16 hours left and my vault still show incorrect number of dust for transmutation

I'd make a post in your secret section detailing exactly what you want to do with discards and salvage. Make sure it's right though
Title: Re: War #12 - Google Sheets Errors
Post by: Wyand on January 19, 2019, 01:45:19 pm
"WARNING: Incorrect number of players!"

we have a Soldier(5), too...
Title: Re: War #12 - Google Sheets Errors
Post by: Manuel on January 19, 2019, 08:31:11 pm
16 hours left and my vault still show incorrect number of dust for transmutation

3 hours left and i need my beauty sleep, i submited my "sort" of vault even if the d/s/t is completely messed up and the vault show incorrect number of cards i own, i can't post my deck in the air section since at that point my other 3 soldier won't be able to check last minute fixes

i declare it now i have totally no fault if something is wrong no penalties nothing it's google fault
Title: Re: War #12 - Google Sheets Errors
Post by: worldwideweb3 on January 19, 2019, 08:34:11 pm
16 hours left and my vault still show incorrect number of dust for transmutation

3 hours left and i need my beauty sleep, i submited my "sort" of vault even if the d/s/t is completely messed up and the vault show incorrect number of cards i own, i can't post my deck in the air section since at that point my other 3 soldier won't be able to check last minute fixes

i declare it now i have totally no fault if something is wrong no penalties nothing it's google fault

You can submit your decks. Your other soldiers can make another post modifying the decks.
Title: Re: War #12 - Google Sheets Errors
Post by: Kalinuial on January 19, 2019, 09:48:33 pm
WMs:

Error in our vault - "Warning: Too many discards from vault"
Title: Re: War #12 - Google Sheets Errors
Post by: Zawadx on January 20, 2019, 02:35:00 pm
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...

It might seem simpler to you, but it wouldn't be simpler to the WMs who'd have to check 48 decks by hand and handle SDPT for another 48.
Title: Re: War #12 - Google Sheets Errors
Post by: RavingRabbid on January 23, 2019, 05:39:49 pm
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...
Ah yes the good old days when a minor mistake was noticed 3 rounds after and so resulted in a 50 card penalty. Or a 200 one.

Nah.
Title: Re: War #12 - Google Sheets Errors
Post by: ARTHANASIOS on January 23, 2019, 06:57:54 pm
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...

It might seem simpler to you, but it wouldn't be simpler to the WMs who'd have to check 48 decks by hand and handle SDPT for another 48.

I am a Brawlmaster (one of the 3 major events in the forum) and never complained about the hard work I have to do. We have to check decks there too, as well as card ideas, art, writing etc. I know war is a more complicated event, but still...

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...
Ah yes the good old days when a minor mistake was noticed 3 rounds after and so resulted in a 50 card penalty. Or a 200 one.

Nah.

Do you have any examples?
Title: Re: War #12 - Google Sheets Errors
Post by: RavingRabbid on January 23, 2019, 07:30:05 pm
18 cards for time (http://elementscommunity.org/forum/war-archive/war-3-round-4/)
48 cards for air (http://elementscommunity.org/forum/war-archive/war-3-round-5/)
42 cards for light (http://elementscommunity.org/forum/war-archive/war-3-round-7/)
54 cards for water, 120 for life (http://elementscommunity.org/forum/war-archive/war-3-round-8/)

War #4 onwards, we started using Google Docs.
Title: Re: War #12 - Google Sheets Errors
Post by: ARTHANASIOS on January 23, 2019, 07:52:44 pm
18 cards for time (http://elementscommunity.org/forum/war-archive/war-3-round-4/)
48 cards for air (http://elementscommunity.org/forum/war-archive/war-3-round-5/)
42 cards for light (http://elementscommunity.org/forum/war-archive/war-3-round-7/)
54 cards for water, 120 for life (http://elementscommunity.org/forum/war-archive/war-3-round-8/)

War #4 onwards, we started using Google Docs.

Thanks for the examples, though I still believe that now that we are fewer players and more experienced than ever before we can handle it even better without gdocs.

Btw, just to make it clear once more, I am not denying the hard work the warmasters do. I just post my opinion.
Title: Re: War #12 - Google Sheets Errors
Post by: worldwideweb3 on January 24, 2019, 12:33:14 am
Whats wrong with gdocs? they make it easier for WMs to check stuff. It doesnt mean you should rely on google docs to show a deck is legal or not. Read rules, follow rules, just like you do in any other event, and you will be fine. Simple.
Title: Re: War #12 - Google Sheets Errors
Post by: ARTHANASIOS on January 24, 2019, 08:19:50 am
Whats wrong with gdocs? they make it easier for WMs to check stuff. It doesnt mean you should rely on google docs to show a deck is legal or not. Read rules, follow rules, just like you do in any other event, and you will be fine. Simple.

 To support my point of view, I say that we put way to many trust to gdocs. I find gdocs to be quite buggy to be honest while posting to a secret section within the forums is not buggy at all. Since we have gdocs we are forced to use them; can I just post my deck to the Team Light secret section for example? I can't, because it won't even matter (it has to be in the gdocs for it to count). WMs do an excellent job trying to satisfy everyone but I honestly believe that (at least at this war) gdocs are more of a burden than of a help in many cases.

 Another reason I dislike gdocs is because of security reasons, but I will stop the discussion right here...

 Finally, aesthetically, I like the forums' secret sections much better than the gdocs but that is a completely personal taste.
 
Title: Re: War #12 - Google Sheets Errors
Post by: worldwideweb3 on January 24, 2019, 08:33:56 am
Whats wrong with gdocs? they make it easier for WMs to check stuff. It doesnt mean you should rely on google docs to show a deck is legal or not. Read rules, follow rules, just like you do in any other event, and you will be fine. Simple.

 To support my point of view, I say that we put way to many trust to gdocs. I find gdocs to be quite buggy to be honest while posting to a secret section within the forums is not buggy at all. Since we have gdocs we are forced to use them; can I just post my deck to the Team Light secret section for example? I can't, because it won't even matter (it has to be in the gdocs for it to count). WMs do an excellent job trying to satisfy everyone but I honestly believe that (at least at this war) gdocs are more of a burden than of a help in many cases.

 Another reason I dislike gdocs is because of security reasons, but I will stop the discussion right here...

 Finally, aesthetically, I like the forums' secret sections much better than the gdocs but that is a completely personal taste.

You can make gdocs private to only your team.
Title: Re: War #12 - Google Sheets Errors
Post by: ARTHANASIOS on January 24, 2019, 08:45:33 am
You can make gdocs private to only your team.

This is not what I meant with security issues; it has to do with an incident during War 8. I don't believe any more that Higs cheated back then but that incident still has marked me, so I don't trust Gdocs security anymore...

You can also make forum sections private to only your team too iirc.
Title: Re: War #12 - Google Sheets Errors
Post by: kaempfer13 on January 24, 2019, 08:50:57 am
Thats precisely what w3s point addresses. In war 8 supposedly secret sections were accessed (so thats a nono for your preference) and through it the gdoc was accessed since back then all you needed to access was the link that was in your 'secure' secret section. With email protection someone trying the same thing will just get a message that they should request access from the owners rather than see the vault.
Title: Re: War #12 - Google Sheets Errors
Post by: ARTHANASIOS on January 24, 2019, 09:00:05 am
Thats precisely what w3s point addresses. In war 8 supposedly secret sections were accessed (so thats a nono for your preference) and through it the gdoc was accessed since back then all you needed to access was the link that was in your 'secure' secret section. With email protection someone trying the same thing will just get a message that they should request access from the owners rather than see the vault.

I think I understand. Using gdocs for more security is good (though I still think there may be security issues). Thank you very much.
Title: Re: War #12 - Google Sheets Errors
Post by: TheonlyrealBeef on January 24, 2019, 08:23: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.
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 25, 2019, 04:06:43 am
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.
Title: Re: War #12 - Google Sheets Errors
Post by: Zawadx on January 26, 2019, 03:47:24 pm
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...

It might seem simpler to you, but it wouldn't be simpler to the WMs who'd have to check 48 decks by hand and handle SDPT for another 48.

I am a Brawlmaster (one of the 3 major events in the forum) and never complained about the hard work I have to do. We have to check decks there too, as well as card ideas, art, writing etc. I know war is a more complicated event, but still...

I'm not saying WMs will complain - they're great people who will cope with the workload perhaps. But the strain on them will increase, leaving less time for them to do important stuff and maybe affecting their decisions. I've served as both BM and WM and even if managing Brawl requires work, it isn't anywhere as involved as managing war.
Title: Re: War #12 - Google Sheets Errors
Post by: TheonlyrealBeef on January 26, 2019, 05:05:51 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.
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 on January 26, 2019, 05:31:02 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.
Title: Re: War #12 - Google Sheets Errors
Post by: TheonlyrealBeef on January 26, 2019, 05:47:15 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.
Works now, thanks.
Title: Re: War #12 - Google Sheets Errors
Post by: Kalinuial on January 26, 2019, 07:31:24 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!
Title: Re: War #12 - Google Sheets Errors
Post by: Wyand on January 26, 2019, 09:46:17 pm
we are having incorrect number of players again, halp
Title: Re: War #12 - Google Sheets Errors
Post by: RavingRabbid on January 26, 2019, 09:48:48 pm
we are having incorrect number of players again, halp
solution is to ff vs water
Title: Re: War #12 - Google Sheets Errors
Post by: mathman101 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.
blarg: