Posted By | Message |
rayfromtexas
Posts: 545
Joined: Dec 2008
|
Saturday, August 13, 2016 12:14 PM | |
Can anyone add these insert checklists for me? I am woefully inept when it comes this...I have L-TM Tommy McDonald numbered out of 45 from the Legacy insert and 125 Leonard Hankerson numbered out of 135 from the Rookie Auto Patch insert. Thanx!!
|
|
|
|
C2Cigars
Posts: 11,568
Joined: Oct 2014
|
Saturday, August 13, 2016 3:55 PM | |
Wow, this set is missing 16 inserts/parallels checklists. And the base set is missing the last 96 cards. You've stumbled upon a real project.
-------------------------------
Someday my cards may double in value and then be worth half of what I paid for them.
|
|
|
|
rayfromtexas
Posts: 545
Joined: Dec 2008
|
Wednesday, September 14, 2016 5:03 PM | |
C2C...that being said, I want to add the checklists. I understand the concept (format, etc) but not actually how to make up the checklist. Do you go to other sites that list the cards and then manually type them all into a database/spreadsheet thingy? I don't mind doing that if thats the case, cuz I have no life and am able to sit at home typing away like mad...I just want to be sure to do it correctly. Any help/suggestions/ideas is greatly appreciated!
|
|
|
|
tonym
Posts: 1,192
Joined: Jan 2012
|
Wednesday, September 14, 2016 5:49 PM | |
you can try cardboardconnection.com. you can either copy from the page there or some sets there have an excel sheet you can download- either case, you can copy off the site page or excel into a blank excel sheet and groom it there-- if you're really good w/ excel there are some other tricks you can do to make it even easier
-------------------------------
|
|
|
|
UKboogie
Posts: 774
Joined: Sep 2015
|
Wednesday, September 14, 2016 6:05 PM | |
Every now and then you get lucky and the manufacturer has an Excel version that you can download too. A lot of the time the team names don't allign with what this site uses. My least favorite is the PDF checklist for download but at least you can usually copy and paste that into Excel.
Sometimes I copy a checklist's text from a site and paste it into Notepad. With its find and replace feature you can add the commas and get it into a CardNum,Name,Team,Note format in rows and save it as a Text file. Then if you open Excel and go to File | Open | and change it all file formats in the dropdown and browse to your text file and open it. You click Next once or twice and choose Comma Delimited format. Insert two rows at the top and add your CardNum | Name | Team | Note headers and save it as an Excel file. Upload and you are done!
This might look intimidating but after you do a few it gets easy. Start with some some small sets and work your way up.
-------------------------------
|
|
|
|
vrooomed
Posts: 15,042
Joined: Dec 2012
|
Wednesday, September 14, 2016 7:34 PM | |
Just to simplify things a little more - if you're massaging data in Notepad to use in Excel:
Use TABs as your delimiter in Notepad - then COPY the text (Ctrl-A to select all, Ctrl-c or Ctrl-Insert to copy) and then paste into a blank Excel sheet. The TABs automatically put your text into the next cell. If you need to skip a cell (unknown team or something, but you know the SN), put 2 TABs in there. I've been doing that for years now. Then you don't have to worry about saving the file and opening it in Excel. A real copy/paste job.
-------------------------------
-- Dan -- Note: Please see my profile for more info regarding trading (section updated 3/4/2024). I have added a large portion of my inventory to the site, and currently have trading turned on (details are in my profile).
|
|
|
|
Lennoxmatt
Posts: 254
Joined: Oct 2015
|
Wednesday, September 14, 2016 8:33 PM | |
even if you download a pdf, plenty of sites will convert it to excel for free, takes seconds
-------------------------------
|
|
|
|
Billy Kingsley
Posts: 7,512
Joined: Aug 2011
|
Wednesday, September 14, 2016 8:36 PM | |
One thing to add: you CANNOT trust checklists you find on any other site than this one. INCUDING the checklists issued by the card companies. I am not sure on Topps or others, but Panini usually puts numbers on the checklist but the cards now have letters.
Cardboard Connection copies what the companies give them so are incorrect. Beckett usually makes up something close but not truly accurate.
It's gotten to the point where I won't post any checklists unless I actually see a card, either in hand or for sale online (Ebay, COMC, etc)
-------------------------------
VERY slow trading due to health problems. Not transferrable so safe to trade with, just moving is painful and can't always access the cards. Cardboard History My COMC New Collection Website: Cardboard History Gallery (Still under construction) Tips on how to make your scans look like the card does in hand (No more washed out, fuzzy scans!):
|
|
|
|
Lennoxmatt
Posts: 254
Joined: Oct 2015
|
Wednesday, September 14, 2016 8:41 PM | |
why would companies issue incorrect checklists?
-------------------------------
|
|
|
|
armac
Posts: 332
Joined: Oct 2014
|
Wednesday, September 14, 2016 10:14 PM | |
Who knows? I assume the first thing they do is create their internal checklists and then design the cards. When they eventually do the numbers and backs they might change it up but marketing might have their original lists to market from.
I've used Panini's website before thinking that it would be great good only to see that they had changed to a lettering scheme on the back.
|
|
|
|