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 ([DEL]Wizards, Nintendo, D/P, B/W[/DEL] for now)
- POP Series
- Odds and Ends (random sets of cards)
- 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
- Japanese Sets
- Errors checklist
Releases:
10/30/12
- All sets to Boundaries Crossed + totals released
11/8/12
- Changed rarity of Boundaries Crossed #35.
- Added new set "P1 Wizards Promos".
2/2/13
- Added new set "55 Plasma Storm"
- Updated "00 Totals" workbook to include Plasma Storm and to fix some small errors
4/18/13
- 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
5/4/13
- 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
5/12/13
- 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"
5/22/13
- Added promo sets "P2 Nintendo Promos", "P3 DP Promos", "P4 HGSS Promos", "P5 BW Promos"
- Edited "P1 Wizards Promos" with new rarity font
7/28/13
- Added "57 Plasma Blast"
- Updated "000 Remaining Cards" and "00 Totals" to include Plasma Blast
- Updated "P5 BW Promos" to include promos through BW84
11/5/13
- 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"
1/27/14
- 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
1/31/14
- 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
Please let me know if there are any additions you wish for me to include or if there is anything incorrect.