WOO Tool - How much tickets do I have
(Edited)
I wanted to do a post about my WOO earnings tomorrow, but unfortunately due to the high traffic the website can't update the WOO amounts at the moment. We hope for a quick fix from the management, but this only shows how the popularity of WOO increases day by day.
For my post I have created a Google Sheets document to calculate the amount of my tickets. As it is available I decided to share it.
Please be aware that:
- On PC: The tool works in most popular browsers
- On Phone : You will have to download the Google Sheets application from your store
- Multiple people might use the sheet at once. Make sure, that noone else is using the sheet before you start editing.
If anyone has a better way to do this, then feel free to improve on the idea ;)
Also feel free to copy the tool or parts of it out if you need them.
The link is here:
https://docs.google.com/spreadsheets/d/1MsGklvnoxb2ELYP9geOWbrzNpk17lwulaw2rvMaWdcg/edit?usp=sharing
Usage is straight forward.
- Search for the name of your wrestler/manager
- Check how many cards you have on the WOO site depending on their type
| Type | Silver Belt | Gold Belt | Common Lore | Gold Lore |
|---|---|---|---|---|
| Card example |  |  |  |  |
- Input the values into the blue boxes:
- Check the yellow boxes for the results.
That's it. Now you know how many tickets you have! :)
That was all for today. Feel free to check out my other WOO related content.
- Introduction + FAQ : WOO
- How much does mining cost? + Overview of current card prices
- How to set up cards for Mining
- A few tips to create an entry for the WOO poster challenge + my first entry
Graphics were made available by the WOO team and I have modified them a bit to fit the content.
0
0
0.000
thanks..this is great.
!PIZZA
PIZZA Holders sent $PIZZA tips in this post's comments:
@freedomprepper(1/10) tipped @arkasz (x2)
whoswho tipped arkasz (x1)
You can now send $PIZZA tips in Discord via tip.cc!
Very cool. I did something similar with a spreadsheet, but I don't know much about functions except sums, so I did it manually :).
!PIZZA
It is really simple to add this feature, as I have only the IF function added to the mix. It works like
You can put multiple IF into each other, but I think there is a limitation in Spreadsheet to have a maximum of 10 in one cell.
So in practice it looks like this:
=IF(B6="Common",1,IF(B6="Rare",10,IF(B6="Epic",25,IF(B6="Legendary",80,IF(B6="Special",2080,"CHECK")))))
In normal language:
Check if in cell B6 is the text Common
and so on.
And then there is a simple calculations ;)
Try it out ;)
Wow, thank you so much. I'll try to implement it and report back :o).
!PIZZA
Nicely done