Dexcel
This is the macro-enabled Excel workbook I use to keep track of my card collecting efforts. I have provided a helpful guide on how to read the Dexcel below since there is quite a bit of color coding and internal language used. If you find anything out of place or would like to suggest enhancement ideas, please feel free to share using the Guest Book tab.
📘 Internal Definitions
Classic — Any card printed during the Pokémon's debut Generation
Prime — Classic that has been deemed the coolest and best for a given Pokémon according to Parks' objectively correct opinion
Definitive — Ability to determine a Prime for a given Pokémon; all the sets for their debut Generation have been released and a card for them exists
Placeholder — Custom card to denote any slots where a non-Definitive belongs
🎨 Color Code
Purple — Total number of cards for a given reference regardless of other factors
Gray — Cards not included in Orange counts since they either do not have a card or are non-Definitive; given Placeholders in binders
Orange — Official counts including everything that would be considered Definitive (Purple minus Gray)
Red — Pokémon from previous Generations that have yet to have a card collected for them even though cards of them do exist
Yellow — Pokémon that have a card collected for them but that card is not a Classic
Blue — Pokémon that have a Classic collected for them but not the Prime
Green — Pokémon that have the Prime collected for them (goal state)
Periwinkle — Headers, notes, and anything not directly related to a specific card
🗂️ Tabs
Totals Tab — Provides a summarized analysis of collection progression
Notes Tab — Record of all the rules, definitions, colors coding, future ideas, and miscellaneous helpful points of information
Updates Guide Tab — Standard work instructions for when a new Generation drops or when every cell is green (the latter perhaps being a little too optimistic)
PokéDex Tab — Tracker for the PokéDex section of the Taxonomic Binder
Forms Tab — Tracker for the Forms section of the Taxonomic Binder
Park's Vault Tab — Tracker for any other card I own or want
📊 The Workbook
| PokéDex and Forms | |
| Total Percent of Primes Collected | 57.4% |
| Total Percent of Classics Collected | 79.2% |
| Total Percent of Anything Collected | 100.0% |
| Total Percent Completely Missing | 0.0% |
| Total Number of Pokémon with Primes Collected | 665 |
| Total Number of Pokémon with Classics Collected | 918 |
| Total Number of Pokémon with Anything Collected | 1159 |
| Total Number of Pokémon with Nothing Collected | 0 |
| Total Number of Pokémon with Definitive Cards | 1159 |
| Total Number of Pokémon | 1504 |
| Total Number of Pokémon with No Card or Not Definitive | 345 |
12 rows · scroll sideways for more columns · colours are live from the workbook