Page 1 of 7 1234 ... LastLast
Results 1 to 25 of 160

Thread: Pokemon Checklists - Update 3-7-16

  1. #1

    Pokemon Checklists - Update 3-7-16

    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)
    - 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

    5/9/14
    • 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

    8/12/14
    • Added "61 Furious Fists" to the English Sets folder
    • Updated "000 Remaining Cards" and "00 Totals" to include Furious Fists

    11/4/14
    • 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

    9/16/15
    • 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

    2/13/16
    • Updated "P6 XY Promos" to include revealed promos through XY136

    3/7/16
    • Added "66 Breakthrough" to the English sets folder
    • Added "67 Breakpoint" to the English sets folder
    • Added "68 Generations" to the English sets folder

    Please let me know if there are any additions you wish for me to include or if there is anything incorrect.
    Last edited by SMP88; 03/07/2016 at 08:14 PM.

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

  2. These members say thanks for this post:

    bigtukker (05/08/2015), Chibi_Fluffy (03/07/2015), FREAKAZOID175 (04/15/2016), inkypuff (05/07/2014), MrKramer (02/22/2014), Naffa (09/18/2015), samharris2011 (09/06/2015), Scizor Master CLR (11/09/2013), TuxedoBlack (08/27/2014)

  3. #2
    ottawacollector's Avatar
    Join Date
    Sep 2012
    Location
    Ottawa, Canada / FL, USA
    Posts
    566
    Images
    2
    I'd just like to comment how amazing these checklists have been for me. They've made my card management so much easier. The only thing I'd love to see is having a separate file (similar to the idea of the totals) that shows a list of all of the missing cards for each set (regular and reverse separately). Again, thanks much for sharing these!

  4. #3
    Do you mean the names of the cards or the how many cards are missing?

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

  5. #4
    ottawacollector's Avatar
    Join Date
    Sep 2012
    Location
    Ottawa, Canada / FL, USA
    Posts
    566
    Images
    2
    The number, rarity, name and type of the cards that are missing all in one place. This would be more of a "would love feature" but if you could use that aggregate spreadsheet to be able to update back to the main checklists (if items are entered in the aggregate) checklist, that would be an amazing feature.

  6. #5
    Member Services Administrator EeveeLover's Avatar
    Join Date
    Sep 2004
    Location
    Florida
    Posts
    9,156
    Blog Entries
    2
    Images
    377
    This is such a great resource, it is now stuck to the top...
    Wayne Cunningham

    '08, '09, '10, '11, '12 (HJ), '13 US Nats Judge
    '06, '08, '09 Worlds Staff / '10, '11, '12, '13 Worlds Judge
    League Owner / League Leader / Tournament Organizer / Professor / Judge


  7. #6
    Awesome, thanks!

    ottowa, I'll try to think up a way to do something like that, but I'm not sure how easily it can be done. I can do something like change the background color of a cell if there's a value, but that's not exactly what you're looking for.
    Last edited by SMP88; 10/31/2012 at 12:14 PM.

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

  8. #7
    They do not seem to work in OpenOffice. Such a shame as they look like a brilliant resource.

  9. #8
    Let me throw in my thanks as well. Your checklists have been extremely helpful on a project I've been working on. Kudos!

  10. #9
    Front Page News Editor pokemonrocks777's Avatar
    Join Date
    Sep 2008
    Location
    On a tip of Tornado Alley, TX
    Posts
    1,660
    Images
    9
    I was planning (i had already started) on making a spreadsheet doing this :(
    City Champion 2009 3-Way Tie (2-1) Tyranitar/Weavile
    Nationals 2012 : 136th/1003 (6-3) Tornadus/Terrakion/Mew2
    Texas States 2013 Player: 23rd/235 (6-2): Terrakion EX/Terrakion/Pokedex/Ether/20 Fighting
    Texas States 2014: 15th/208 (some tie system): Thunderus EX/Deoxys EX/Kyurem/Genesect/Landorus.
    Back from the Silent World

  11. #10
    Quote Originally Posted by RogueZephyr View Post
    They do not seem to work in OpenOffice. Such a shame as they look like a brilliant resource.
    What's wrong exactly when you open it in Open Office?

    Quote Originally Posted by AnUnown View Post
    Let me throw in my thanks as well. Your checklists have been extremely helpful on a project I've been working on. Kudos!
    Thanks!

    Quote Originally Posted by pokemonrocks777 View Post
    I was planning (i had already started) on making a spreadsheet doing this :(
    Glad to save you some time.

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

  12. #11
    Hey, I made a Japanese Promo checklist that would be great if you could add to this. Thanks!

  13. #12
    Quote Originally Posted by Tolan View Post
    Hey, I made a Japanese Promo checklist that would be great if you could add to this. Thanks!
    That sounds good, ill add those once I figure out the best way to include the English ones

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

  14. #13
    Apologies. It was a silly mistake on my part. It was read only, which was why it wasn't working. Seems to be doing just fine now :)

  15. #14
    Updated "Upcoming Additions".

    I'm going to make a Japanese Promo list and individual Japanese set lists once I do the English promos. I'm also going to update the Base Set list to include all 4 variations of it.

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

  16. #15
    ottawacollector's Avatar
    Join Date
    Sep 2012
    Location
    Ottawa, Canada / FL, USA
    Posts
    566
    Images
    2
    @SMP88, small update on Boundaries Crossed, 35 Golduck should be rare. Can I just repeat my thanks again for what you've created? =)

  17. #16
    Update

    11/8/12
    • Changed rarity of Boundaries Crossed #35.
    • Added new set "P1 Wizards Promos".

    Totals page does not reflect promos yet.
    All error type cards (like 1st edition Promo Pikachu #1 and error Promo Dark Persian) will be put into an errors checklist later on.
    Last edited by SMP88; 11/08/2012 at 06:35 PM.

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

  18. #17
    Hi SMP88 (and all, first post!)

    I registered merely to say THANKYOU for this! I've been trying to motivate myself to make these for years; nowhere could I find a complete, up-to-date set list with useful information, in excel, easy to use. Finally! And you've made it all available for the world!

    Can't wait for an errors list, though that's probably a bigger undertaking than what you've done so far, so all in good time! Keep it goin man, if there's anything we can do to help (not likely with those excel skillz) just holler.

    What a guy!

  19. #18
    Yo SMP88, just spotted that Metal energy 94/109 in the EX Ruby Sapphire set is rare-holo, table says just rare, FYI :) The same may be true for Miracle energy 95/109 but I don't own it so can't confirm. Darkness energy 93/109 is standard rare as table says.

    One little question, I've been trying to get excel to import all the data from your workbooks into one new filtered worksheet, just displaying all cards I don't own in first edition, normal or rev holo (all columns), either segmented per set or with another column displaying the set. I reckon it can be done, but it's proving more difficult than I thought! Is there a way to do this do you know? Would be a big list but a nice place to just have it all in one filterable table. I've tried pivot tables (worked with only one data source) and looked at SQL queries for getting row info from many external files but... yeah. Excel is finicky all around.

    Cheers dude!

  20. #19
    Quote Originally Posted by pasty2k2 View Post
    Yo SMP88, just spotted that Metal energy 94/109 in the EX Ruby Sapphire set is rare-holo, table says just rare, FYI :) The same may be true for Miracle energy 95/109 but I don't own it so can't confirm. Darkness energy 93/109 is standard rare as table says.

    One little question, I've been trying to get excel to import all the data from your workbooks into one new filtered worksheet, just displaying all cards I don't own in first edition, normal or rev holo (all columns), either segmented per set or with another column displaying the set. I reckon it can be done, but it's proving more difficult than I thought! Is there a way to do this do you know? Would be a big list but a nice place to just have it all in one filterable table. I've tried pivot tables (worked with only one data source) and looked at SQL queries for getting row info from many external files but... yeah. Excel is finicky all around.

    Cheers dude!
    You're welcome, it's been fun making these. The errors checklist probably won't be out for a couple weeks. I want to get the promo lists done first, then start the Japanese sets. I might just make a basic errors list then add to it slowly over time.

    I've looked at a couple different lists and they all show that the Metal Energy from Ruby/Sapphire is a normal rare, not holo. Miracle Energy from Neo Destiny is holo rare, the checklist shows that. If you could let me know more about where you found your info I'll look into it.

    I'm not sure exactly how I would be able to pull the data from all the sheets to determine which ones are blank. I imagine there is a way, but I'm not sure how it's done. The next best thing would be to use the filters that are on each set's page (the arrows at the top of each column header). If you click those then select "Blanks" only it'll give you the blanks cells in that column. You can use the filters to also look for individual cards. It requires you to do it for each set, and you can't do normal and RH at the same time, but it helps a little.

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

  21. #20

    Totals Spreadsheet Help

    I have the totals file in the same folder as the rest of the lists I'm working on however none of the information is updating to it. I am getting no errors when I click the update button yet nothing is happening. Any suggestions?

  22. #21
    Hey man - I have that metal energy card, that's how I know! You've got me thinking its a fake or something now, but it looks fine on inspection. I took a pic for you but can't attach it. It's not a rev holo, those are solid shiny all over, this is the cosmos shiny. Copyright is 2003, so it's the original release. Bizarre... Can anyone else confirm what this card is supposed to be (a long shot)?

    I'll take a look into the excel tricks soon, given up for now its good enough as it is . A list of everything would be rather long too.

  23. #22
    Quote Originally Posted by opmguy15 View Post
    I have the totals file in the same folder as the rest of the lists I'm working on however none of the information is updating to it. I am getting no errors when I click the update button yet nothing is happening. Any suggestions?
    Not sure. As long as everything is in the same folder it should update when you open the totals list and click "Update". Try making a copy of the totals and Base Set lists and put them into a new folder. See if it updates then.

    Quote Originally Posted by pasty2k2 View Post
    Hey man - I have that metal energy card, that's how I know! You've got me thinking its a fake or something now, but it looks fine on inspection. I took a pic for you but can't attach it. It's not a rev holo, those are solid shiny all over, this is the cosmos shiny. Copyright is 2003, so it's the original release. Bizarre... Can anyone else confirm what this card is supposed to be (a long shot)?

    I'll take a look into the excel tricks soon, given up for now its good enough as it is . A list of everything would be rather long too.
    I've looked on ebay too: Metal Energy - Ruby/Sapphire. It looks like it should be a regular rare. The only holo one I can remember is the Neo Genesis one. Try uploading the pic you have to imgur.com and post the link here.

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

  24. #23
    I have the complete set of Ruby/Sapphire and the metal and dark both come in holo and non holo.
    My Refs
    W.G.W C.G.C.
    TROLL AND TOAD IS NOT A PRICE GUIDE!!!

  25. #24
    I may be missing it but is it possible to add a POP Series list and a "pre-release" card checklist, either into each set or as its own section? Just a suggestion, other than that it looks really good, thanks!
    Last edited by Rambo; 11/26/2012 at 08:56 AM.

  26. #25
    Quote Originally Posted by evil psyduck View Post
    I have the complete set of Ruby/Sapphire and the metal and dark both come in holo and non holo.
    It still looks like the non holo version was part of the actual set. Either way, whichever one didn't come in the set had to come as a promo or league reward or something, I need to determine where it came from.

    Quote Originally Posted by Rambo View Post
    I may be missing it but is it possible to add a POP Series list and a "pre-release" card checklist, either into each set or as its own section? Just a suggestion, other than that it looks really good, thanks!
    I had those written down but forgot to put them on the thread's to-do list. I'll get the POP sheets done after I get the promos done. Prerelease cards and all the other odds and ends type of cards will be done after that.

    YouTube Channel - Casual/Tournament games from Chicago
    Collector's Checklists - Includes all sets

Page 1 of 7 1234 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •