Page 7 of 7 FirstFirst ... 4567
Results 151 to 160 of 160

Thread: Pokemon Checklists - Update 3-7-16

  1. #151
    Hi SPM88.

    Thanks for the awesome lists! You are doing a great job!!
    I just have a couple of questions to the first Base Set list (01 Base Set). What are the difference between "Normal", 1st Edition, 3rd Edition and 4th Edition?

    1. I know about the 1st Edition stamp (first cards ever that was shadowless). These cards also had "1995, 96, 98, 99 Nintendo, Creatures, GAMEFREAK C 1999 Wizards" at the bottom of the cards. I have some of these and I believe it is the same as "1st Edition" in the Excel sheet?
    2. Also I know that the cards printed after this was the exact same cards, except Machamp. And these cards did not have the 1st stamp. So I guess it is the same as "Normal" in the Excel sheet?
    3. So 3rd Edition? Is this the most common ones? With shadow and printed "1995, 96, 98 Nintendo, Creatures, GAMEFREAK C 1999 Wizards" at the bottom?
    4. And 4th edition? Same as the 3rd, but a bit lighter/brighter and printed "1995, 96, 98 Nintendo, Creatures, GAMEFREAK C 1999-2000 Wizards" at the bottom?

    Anyway, thank for the lists :)

  2. #152

    Join Date
    Jan 2013
    Location
    Adelaide, South Australia
    Posts
    20
    Hey SMP,

    Just wanted to thank you for uploading Sun and Moon... And I guess wanted you to know there's still people out there using your database over others!! So would love if you could keep updating them! I've just decided to work out how to update the Totals page myself, and think I have it if you want me to update it once I'm done? But I doubt I'm gonna rack my head around the Remaining Cards sheet... Although I'm yet to give it a go!

    Thanks mate!
    Chris

  3. #153
    Hey SMP and all - I've been keeping these up to date on my own computer, including the Remaining Cards and Totals pages, along with an improvement here and there since I've gotten a little more familiar with Excel.
    I wouldn't want to steal your thunder on these wonderful lists, but to save you having to go through updating all of them (and since many others are still using them a lot) I could transfer them to you for sharing if you'd like?

  4. #154
    Quote Originally Posted by pasty2k2 View Post
    Hey SMP and all - I've been keeping these up to date on my own computer, including the Remaining Cards and Totals pages, along with an improvement here and there since I've gotten a little more familiar with Excel.
    I wouldn't want to steal your thunder on these wonderful lists, but to save you having to go through updating all of them (and since many others are still using them a lot) I could transfer them to you for sharing if you'd like?
    If you have updated Remaining Cards and Totals pages I'd be glad to replace the current versions. Those always took the longest time to update. I've been uploading new sets everytime they come out, I just haven't really posted it here. What improvements have you been able to make?

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

  5. #155
    Quote Originally Posted by SMP88 View Post
    If you have updated Remaining Cards and Totals pages I'd be glad to replace the current versions. Those always took the longest time to update. I've been uploading new sets everytime they come out, I just haven't really posted it here. What improvements have you been able to make?
    Only minor additions to be honest. I've brought Totals up to date apart from the By Type sections, I stopped as I was trying to figure out a way to speed up the process a little, but may just have to slog it. I'll admit I don't use those pages at all myself so haven't felt compelled to do it up until now!

    Otherwise I've:
    • Added set symbols to Totals - useful when sorting your cards and can't remember all 72 set names/symbols off the top of your head!
    • Created a few "card divider" and "Binder index card" templates for printing out onto card yourself - I'm not buying some plain cut-to-length plastic for Ł3!
    • Updated the promo sheets with information on specific promos as well as including different edition-cards as separate entries, for example the pre-release and "staff" pre-release cards sharing the same promo number, not to mention the World Championships. I figured since these sheets aren't in any lookups anywhere else, they don't need to be the same as the others.
    • Added what I've termed sets 53A, 58A, 63A - the Dragon Vault, Kalos Starter Set and Double Crisis mini sets/mini-expansions. Used these number/letter combinations so you know when it was released alongside the usual sets. They are collectible by the average Joe and not promos, not POP-like, so they are normal sets I say! Also added these to Totals, but not Remaining Cards yet.
    • (EDIT!) Added additional columns to Totals Summary page - Set Size, Set Symbol, # of 9-pocket pages per set, Folder number. These last two are to calculate what sets should go in what numbered Ultra Pro 3-ring binder (what I use for set/display storage). I've figured that more than 50 9-pocket pages per 3-ring binder, full of cards, is too many for this folder to hold. A formula calculates when this number is reached for n sets, and therefore when a new folder should be started. This allows you to plan your collection ahead of time and not need to shift sets around in your folders as you fill out the earlier collections, if you have a gap/stopped collecting for years, like me. It's a little bit manual to update though, uses a hidden column, conditional formatting and you'll need to merge/unmerge cells, but only needs doing once every 3 or 4 sets as you'll notice.
    • Did some colouring in - added conditional formatting to Totals so you get excited as your sets approach 100% on your collecting journey!


    Let me know what you think, this was only meant for me/personal use though so I don't know about the set symbols, since I just took those from Bulbapedia and Serebii. Am I "distributing copyrighted material" if I upload with those in there, do you think? I'll PM you a dropbox folder link if all is good.


    Cheers, Paul
    Last edited by pasty2k2; 03/03/2017 at 03:29 AM.

  6. #156
    Finally after much faffing around I've managed to semi-automate the filling out of the Totals/By Type sheet, and by extension any other Totals sheet, by way of a formula generator. Excel doesn't let me use the value of one cell as an external reference from another cell, so you have to copy/paste and F2/ENTER a bit but no more manually looking up where your summary "tables" are within the individual sets! Takes about 2 minutes to go through now as opposed to 20+.

    Waiting for your A-OK and I'll PM you a link.

  7. #157
    Sounds good. If you could send me the link that'll be great. I'll be able to take a look at it sometime next week. Thanks!

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

  8. #158
    Oh dear...

    "SMP88 has exceeded their stored private messages quota and cannot accept further messages until they clear some space."

    Oh dear oh dear oh dear...!

  9. #159
    Whoops, just cleared some space.

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

  10. #160
    In case you don't get alerts, PM sent.

Page 7 of 7 FirstFirst ... 4567

Posting Permissions

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