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
| New Generation's First Set Release Guide |
| Step 1) Add all Pokémon to the PokéDex section and Forms to the forms section from the now previous Generation (e.g. Add all Gen 9 during Gen 10) and color them Red |
| Step 2) Copy the secret ColorCount formula in the fourth column to the right of each new entry |
| Step 3) Use https://pkmncards.com to research each newly added Pokémon and Form to determine their Primes |
| Step 4) Review any cards you may already have in your collection to change their color in accordance with the Color Key |
| Step 5) Double check to make sure the counts are generating correctly (no ColorCount formula pasting errors) |
| Step 6) Review any remaining Grays to see if they received a card in the previous Generation's set or any other set that you just may have missed |
| Step 7) Any Grays that do now have a card need to have their Placeholder removed and section row updated (color Red and add follow row formatting) |
| Step 8) Use the same site to review each new set from the now previous Generation to see what should be added to Parks' Vault |
| Step 9) Repeat steps 4 and 5 for any card you would like to add to Parks' Vault |
| Step 10) Collect and have fun! |
| Everything is Green or Gray Guide |
| Step 1) Use https://pkmncards.com to review the PokéDex and Forms to ensure all the Primes are truly collected |
| Step 2) Use the same site to review all the non-current Generations' sets to ensure there is nothing cool for Parks' Vault missing |
| Step 3) Collect again if anything changes; make sure to double check it's not already in the Vault |
| Step 4) Review Parks' Vault to see how you might want to change the order/presentation |
| Step 5) Repeat this process until nothing changes then enjoy a truly completed collection until the next Generation drops |
18 rows · scroll sideways for more columns · colours are live from the workbook