War #12 - Google Sheets Errors

[ARTHANASIOS]

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.
 

[worldwideweb3]

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.

[ARTHANASIOS]

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.

[kaempfer13]

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.

[ARTHANASIOS]

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.

[TheonlyrealBeef]

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.

[mathman101]

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.

[Zawadx]

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.

[TheonlyrealBeef]

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.

[mathman101]

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.

[TheonlyrealBeef]

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.

[Kalinuial]

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!