I've posted a couple times a set of collector's checklists and thought I should make it's own thread to keep updates on and take suggestions.
https://www.dropbox.com/sh/871etca36tp0agi/XQQAUDYqvu
Advantages of checklist:
- Only grab the checklists you need, each set is it's own file
- Comprehensive totals page. Keeps a running total of all sets you have cards for
- Color coded card names
- Set summary at bottom of each checklist. Contains totals for rarity and type.
- Updates are quick and easy
-------------------------------------------------------------------------------
Instructions:
To make it work, just download the checklists from the link above and place them all in the same folder. If you wish to use the totals file also that must be in the same folder as the rest of the checklists.
For every new set just add the new checklist to the same folder. The totals file will be updated every time a checklist is added or updated, just replace the old totals file with the new totals file and it will automatically update itself. Any updates to the individual checklists will require you to copy/paste your counts to the updated checklist then replace the old one in the folder.
Checklists were made in Excel 2007, if you have an older version some of the coloring might be messed up.
--------------------------------------------------------------------------------
Upcoming Additions:
-Promo sets (Wizards, Nintendo, D/P, B/W for now)
-POP Series
-Odds and Ends (random sets of cards) - no longer creating
- Color coding totals page percentages as a gradient from 0-100
- Checkboxes in Remaining cards page to turn sets on and off
- Add all 4 variations to Base Set list
-Japanese Promos - no longer creating
-Japanese Sets - no longer creating
- Errors checklist
Releases:
10/30/12
https://www.dropbox.com/sh/871etca36tp0agi/XQQAUDYqvu
Advantages of checklist:
- Only grab the checklists you need, each set is it's own file
- Comprehensive totals page. Keeps a running total of all sets you have cards for
- Color coded card names
- Set summary at bottom of each checklist. Contains totals for rarity and type.
- Updates are quick and easy
-------------------------------------------------------------------------------
Instructions:
To make it work, just download the checklists from the link above and place them all in the same folder. If you wish to use the totals file also that must be in the same folder as the rest of the checklists.
For every new set just add the new checklist to the same folder. The totals file will be updated every time a checklist is added or updated, just replace the old totals file with the new totals file and it will automatically update itself. Any updates to the individual checklists will require you to copy/paste your counts to the updated checklist then replace the old one in the folder.
Checklists were made in Excel 2007, if you have an older version some of the coloring might be messed up.
--------------------------------------------------------------------------------
Upcoming Additions:
-
-
-
- Color coding totals page percentages as a gradient from 0-100
- Checkboxes in Remaining cards page to turn sets on and off
- Add all 4 variations to Base Set list
-
-
- Errors checklist
Releases:
10/30/12
- All sets to Boundaries Crossed + totals released
- Changed rarity of Boundaries Crossed #35.
- Added new set "P1 Wizards Promos".
- Added new set "55 Plasma Storm"
- Updated "00 Totals" workbook to include Plasma Storm and to fix some small errors
- Updated all set workbooks with background items needed for other things, to change font/symbols for rarities and to remove lock on cells for cards that can't be that type (i.e. a RH EX)
- Added new "000 Remaining Cards" workbook to show which cards are remaining per set
- Updated "00 Totals" workbook to fix errors in "05 Team Rocket" pulls
- Changed link in first post to new folder for updated workbooks (https://www.dropbox.com/sh/h6gfiz7vn7n0hcn/Q-2Nhp5Mo4)
- Added 3rd and 4th edition cards to "01 Base Set" workbook
- Made correction to "000 Remaining Cards" workbook. The Jungle 1st edition column was referencing the Jungle unlimited column, giving the wrong cards remaining.
- Edited "00 Totals" workbook to fix issues with spelling of Noble Victories references
- Fixed problem with "45 Undaunted" double counting Alph Lithograph 3 in the Unlimited percentage calculation
- Added new set "56 Plasma Freeze"
- Edited "00 Totals" and "000 Remaining Cards" workbooks to include Plasma Freeze
- Corrected spelling error on "54 Boundaries Crossed"
- Corrected type error on "37 Legends Awakened"
- Added promo sets "P2 Nintendo Promos", "P3 DP Promos", "P4 HGSS Promos", "P5 BW Promos"
- Edited "P1 Wizards Promos" with new rarity font
- Added "57 Plasma Blast"
- Updated "000 Remaining Cards" and "00 Totals" to include Plasma Blast
- Updated "P5 BW Promos" to include promos through BW84
- Added "58 Legendary Treasures"
- Updated "000 Remaining Cards" and "00 Totals" to include Legendary Treasures
- Updated "P5 BW Promos" to include promos through BW100
- Removed color coding from "000 Remaining Cards"
- Added "59 XY"
- Updated "000 Remaining Cards" and "00 Totals" to include XY
- Updated "00 Totals" to have each non percentage based column be the same width
- Updated "P5 BW Promos" to include promos through BW101
- Added "P6 XY Promos". Included up to promos XY04
- Corrected "58 Legendary Treasures" - 92 Altaria is uncommon
- Corrected "14 Aquapolis" - H15 Lanturn is Electric
- Placed all promo checklists in their own "English Promos" folder
- Corrected "58 Legendary Treasures" to correctly count Radient Collection cards
- Corrected "59 XY" - 40 Frogadier is Uncommon, 41 Greninja is Holo, 42 Pikachu is Common, 60 Rhyhorn misspelling
- Reconfigured folder structure. All English sets are now in the folder "English Sets". All English black star promo checklists are in the folder "English Promos". All English checklists that don't fit one of these 2 categories are in the folder "English Other" (only includes POP Promos at this time).
- Added "60 Flashfire" to the English Sets folder
- Updated "000 Remaining Cards" and "00 Totals" to include Flashfire
- Updated "P6 XY Promos" to include promos through XY12
- Added "POP Promos" to the English Other folder
- Added "61 Furious Fists" to the English Sets folder
- Updated "000 Remaining Cards" and "00 Totals" to include Furious Fists
- Added "62 Phantom Forces" to the English Sets folder
- Updated "000 Remaining Cards" and "00 Totals" to include Phantom Forces
- Updated "P6 XY Promos" through XY33
- Added "63 Primal Clash" to the English Sets folder
- Added "64 Roaring Skies" to the English Sets folder
- Added "65 Ancient Origins" to the English Sets folder
- New Feature - Printing
- Updated "P6 XY Promos" to include revealed promos through XY136
- Added "66 Breakthrough" to the English sets folder
- Added "67 Breakpoint" to the English sets folder
- Added "68 Generations" to the English sets folder
- Added all set checklists between "69 Fates Collide" & "91 Vivid Voltage"
- Updated "P6 XY Promos" to include all promos
- Added "P7 SM Promos", includes all promos
- Added"P8 SWSH Promos", includes all revealed promos up to SWSH107
- Updated "01 Base Set" to rename variants to "Normal", "1st Edition", "Shadowless", "1999-2000"
- Updated "01 Base Set" to include totaling data for all variants for rarity and types. Also hid away data required for background use.
Last edited: