Excel Checklist

[BasiliskFang]

Thanks to the way OPo 2.5.3 was built, I was able to quantify the molecular data on a level by which it was possible to create this.
~~~~
Notes:
If there are any missing/dupes/misnamed cards they were such in OverPowerOnline_v2.5.3.
The Marvels is included, because that's what was in that version of OPo.
Let me know if anything needs to be changed.
The set the card is from is not defined (only power cards), I probably won't do this.
There are 13 sheets at the bottom.
Each sheet is a type of card in the game.
I gave the sheets tables to the card is easier to find.
~~~~
How to use this checklist:
I will add "Doppelganger 3 rank" step by step.

1. Enable editing (Gold bar at the top) then Click the "Characters" sheet at the bottom.
2. There are many ways to find this card in excel; by power, total and so on.
3. Lets do 2 ways.

Way one: By "Clone Character", since he is a clone of Spider-Man.
4. Go to column "L" and press the dialog triangle, un-check (click) the "Select All" then find "SPIDER-MAN" and click ok.
5. See how now there are only his clones. Lets add this card.
6. Go to column "M" and change his 0 to 1. You can change column "N" to "TRUE" if you want to.

Way two: By way of total.
4. Go to column "G" and press the dialog triangle, un-check (click) the "Select All" then find "10" and click ok.
5. See how now there are only 10ers. Lets add this card.
6. Go to column "M" and change his 0 to 1. You can change column "N" to "TRUE" if you want to.

7. To see every card again, Go to column "L" and press the dialog triangle, and check the "Select All"
~~~~
Final words:
For most cards you would be able to add it to your record by finding almost any value/type/specification on the card and then be able to filter for that specific value in excel.
It is even possible to stack filters, for a special you can choose to show only AA specials THEN choose to only show specials that have a specific text.
After entering all of your cards, you can then filter by QUANTITY or OWN and see what cards you need and be able to send the excel to trade partner or post in your for BST thread.

I've even noticed you can use this in accessory with the deck builder, Say you have an all fighting team, you can organize artifacts and universe cards by fighting.
~~~~
Feedback would be appreciated.




DOWNLOAD:

1.5 Added IF function to change the "OWN" column to Yes if you change the value in the "Quantity" column.
https://docs.google.com/open?id=0B4Ie8g_kIF0QMVJJblRSZG9fcjQ

1.3 Lots of conditional formatting (might be too "loud" for some people)
https://docs.google.com/open?id=0B4Ie8g_kIF0QMkRYeTExYmxQeEk

1.2 - Changed EFSI to ENE FIG STR INT on some sheets
https://docs.google.com/open?id=0B4Ie8g_kIF0QSHRwWGJpdnlVV0U

1.1 - Normal fixes
https://docs.google.com/open?id=0B4Ie8g_kIF0QczVMTGhPWHdrT2c