War #9 - Vault Tool Problems

[worldwideweb3]

This is a list of problems that have been fixed or will not be fixed in the vault tool. If you encounter a bug that is not listed here, or one that is marked as fixed, please post here or contact me by forum or chat PM.

Deck codes longer than 60 cards break the sheet-Will not be fixed. If you need more than 60 cards in any space for any reason, PM me. If you have used a code that is too long and the sheet is broken, PM me to reset it.
Cutting and pasting codes, or moving codes, causes formulas to refer to the wrong cells-Not fixable. If you want to reassign decks, use the position dropdowns.
Upgraded Fire Nymph isn't counted-Won't be fixed because of how uncommon it is. If you have problems with this, PM me.

If you need clarification on how to use the vault tool, post in this topic or in the topic in your team section.

[Coffeeditto]

Notice: If any of the generals would like the link removed from the board and/or have the GDoc require specific admittance for each person, PM both WWW3 and I with a list of your team's element and members.

[rob77dp]

Death's vault is now locked up from users not listed in the Doc's share settings.  War Masters gmail account is still with access.  WM's, please confirm this (I have already confirmed that just the doc link will not allow users in - you have to be listed for access).


Thanks.



--Rob

[Zso_Zso]

The price column in the vault tool is not locked, it is editable. I noticed it as I miss-clicked when entering the number of cards and edited the price instead of the count. Fortunately, I noticed and did a quick undo, but this can lead to some major cost miscalculation and invalid vaults if any team accidentally edits their card costs.

 

[Aves]

I second this. Would it really be that hard to protect the ranges of the things we're not supposed to modify?

[ddevans96]

I second this. Would it really be that hard to protect the ranges of the things we're not supposed to modify?

I think it would be, since I doubt locking ranges is possible. What could easily be done is hiding the columns with prices...but then you can't see them for reference. I can think of a couple other possible solutions, but they'd be a lot of additional work for WMs.

If there is an easy solution, sure, but this might be something we need to live with.

[worldwideweb3]

Isn't it easier to just not type in that coloumn and if you accidentally do it, just undo?

[Aves]

I get that the best solution would be the common sense "Don't touch that, please, and if you do, just undo." I just don't like the odds of having a person poke around on it and not notice accidentally changing some value. The chance is low, true, but I think it's still a unnecessary risk to allow for potential penalties when it could be prevented relatively easily. As for protecting/locking ranges, I think this is what we want: https://support.google.com/docs/answer/144687?hl=en

If the WMs are amenable, they could just lock the entire sheet first, and then unlock the comparatively small areas that we need access too. I'll admit it might be annoying to have to do that 12 times over, though.
Hmm, seems like that suggestion won't work. Nevermind, then. Having to do each section would be tedious in comparison.

[iancudorinmarian]

I get that the best solution would be the common sense "Don't touch that, please, and if you do, just undo." I just don't like the odds of having a person poke around on it and not notice accidentally changing some value. The chance is low, true, but I think it's still a unnecessary risk to allow for potential penalties when it could be prevented relatively easily. As for protecting/locking ranges, I think this is what we want: https://support.google.com/docs/answer/144687?hl=en

If the WMs are amenable, they could just lock the entire sheet first, and then unlock the comparatively small areas that we need access too. I'll admit it might be annoying to have to do that 12 times over, though.
Hmm, seems like that suggestion won't work. Nevermind, then. Having to do each section would be tedious in comparison.

It is 12 for each team's vault and 13 for each element in the vault, so...only 156 times...

[Zso_Zso]

One easier change that would help: move the price column to a different location, so it is not next to the card count that needs to be edited. E.g. if the price was on the left of the card name, then if you accidentally edit the card name thats much more obvious to notice (string vs number). The danger is because it is 2 narrow columns side by side, so it is easy to miss-click.

[Jen-i]

or put the actual card cost on a second sheet - which you can hide or lock.

Then have the original sheet merely display the value that's hidden on the other sheet - that way accidentaly overwriting the value on the working sheet doesn't accidentaly destroy the cost formula

[iancudorinmarian]

2 of my "Discards" codes tiles are turquoise.

You WM can check my vault and see if it affects anythin. It doesn't seem to cause any errors, it just seems weird that only 2 out of 3 are turquoise.

I also seem to miss 4 cards.

It says Vault count is 297, limit is 301, I am sure I had 311 cards at first, lost 10 this round.