13
War Archive / Re: War #3 - Feedback
« on: May 17, 2011, 05:20:53 am »
Someone who is really smart please do the below:
Write a spreadsheet that can recognize the card codes. Make 3 tabs for each round: Vault, Used, Unused.
1. "Vault" tab will be the same as now.
2. "Used" tab will have 8 slots for your potential deck codes. Input your codes and the spreadsheet automatically generates a mini vault of "USED" cards. This is not your vault, but shows you what cards you have used.
3. "Unused" tab would be "Vault" (minus) "Used". If any of the values are negative, you know you made a mistake and are using cards that don't exist.
this would be SOOOOOOOO HELPFUL OMG!@! i mean this would not only give everyone more time to focus on deckbuilding and ease the amount of time wasted on math, but it would also prevent cheating and keep people honest. It would be REALLY easy to audit the vaults with these tabs.
I would make it myself but my only hangup is that I can't figure out how or if it is possible for a spreadsheet to read specific card codes in a string and understand them. If someone can figure out how to extract specific card codes from a deck code in a spreadsheet we are set.
Just to make it clear, we need to figure out how to take this:
4sa 4sa 4sa 4t3 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5ul 5um 5um 5um 5um 5un 5un 5un 5uo 5up 5up 5up 5uq 5us 5us 5us 61o 61o 61o 61o 61p 61q 61r 61s 8pt
put that deck code in a single cell, and then in other cells pops out:
etc.
the deck image generator already knows how to do this so I suspect it is also possible in an excel file/ google doc. Once we have that, we can make the Vault/Used/Unused system.
thanks for your time.
Write a spreadsheet that can recognize the card codes. Make 3 tabs for each round: Vault, Used, Unused.
1. "Vault" tab will be the same as now.
2. "Used" tab will have 8 slots for your potential deck codes. Input your codes and the spreadsheet automatically generates a mini vault of "USED" cards. This is not your vault, but shows you what cards you have used.
3. "Unused" tab would be "Vault" (minus) "Used". If any of the values are negative, you know you made a mistake and are using cards that don't exist.
this would be SOOOOOOOO HELPFUL OMG!@! i mean this would not only give everyone more time to focus on deckbuilding and ease the amount of time wasted on math, but it would also prevent cheating and keep people honest. It would be REALLY easy to audit the vaults with these tabs.
I would make it myself but my only hangup is that I can't figure out how or if it is possible for a spreadsheet to read specific card codes in a string and understand them. If someone can figure out how to extract specific card codes from a deck code in a spreadsheet we are set.
Just to make it clear, we need to figure out how to take this:
4sa 4sa 4sa 4t3 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5uk 5ul 5um 5um 5um 5um 5un 5un 5un 5uo 5up 5up 5up 5uq 5us 5us 5us 61o 61o 61o 61o 61p 61q 61r 61s 8pt
put that deck code in a single cell, and then in other cells pops out:
quantum pillar | 3 |
dagger | 1 |
obsidian pillar | 12 |
the deck image generator already knows how to do this so I suspect it is also possible in an excel file/ google doc. Once we have that, we can make the Vault/Used/Unused system.
thanks for your time.