|
#1
|
|||
|
|||
T206 Excel Database
Posted By: Mike Poland
I recently created a worksheet/database in Microsoft Excel that will help keep track of your T206 collection. All information is from T206museum.com. |
#2
|
|||
|
|||
T206 Excel Database
Posted By: Trae R.
Nice work! I am going to be working on an online version soon where individual users can also keep a checklist of their collection of T206's. It's kickass to have such an active community where we can share things like this! |
#3
|
|||
|
|||
T206 Excel Database
Posted By: Julie
15 minutes of work won't do it... |
#4
|
|||
|
|||
T206 Excel Database
Posted By: Richard Dwyer
Someone beat me to it. I was working on the exact same thing. I'll finish it off still, since it's done a little differently. |
#5
|
|||
|
|||
T206 Excel Database
Posted By: Mike Poland
I just noticed this thread http://www.network54.com/Forum/thread?forumid=153652&messageid=1098127806&lp=1103683319> and that others were working on something similar. I didn't mean to step on anyones toes. |
#6
|
|||
|
|||
T206 Excel Database
Posted By: Nick Martinez
This is a great tool, with John firing up my desire to put together the set your work will be a great help! |
#7
|
|||
|
|||
T206 Excel Database
Posted By: Richard Dwyer
What I hope to accomplish is an excel spreadsheet that will not only list the cards, but will calculate the value of each card based on condition, multiplier, & back type. Everything is layed out, except, I'm having trouble with the lookup tables. |
#8
|
|||
|
|||
T206 Excel Database
Posted By: Mike Poland
Hi Richard, that is pretty much what mine is doing. The only thing you have to input is a mark denoting you own the card, a number which corresponds to the type of back that card has and the condition of the card. The backing description and the total est value based on the backing and card condition is then automatically calculated. Good luck on yours! |
#9
|
|||
|
|||
T206 Excel Database
Posted By: Mike Poland
For those concerned, I have made a slight update. I fixed the back and grade multiplier formulas in order to get rid of those VALUE and NA errors. This update is reflected in the download link posted above. |
#10
|
|||
|
|||
T206 Excel Database
Posted By: Peter Thomas
Mike is the base value for the Doyle correct @ $80,000 - should it be $8,000? |
#11
|
|||
|
|||
T206 Excel Database
Posted By: Mike Poland
$80,000 does seem quite high but I took all my data from T206museum.com and that is how they have the base price listed. |
#12
|
|||
|
|||
T206 Excel Database
Posted By: Joe P.
Not to worry about the $80,000 Doyle figure. |
#13
|
|||
|
|||
T206 Excel Database
Posted By: Scot Reader (ebay: sreader3)
... and the price is right! Thanks, Mike. |
#14
|
|||
|
|||
T206 Excel Database
Posted By: Scot Reader (ebay: sreader3)
Donovan, Hofman (Solly) and O'Neil are misspelled on the T206 Museum website and the error carried over to your spreadsheet. No biggie, but it can lead to frustration when searching for these commons on ebay using the misspelled names. |
#15
|
|||
|
|||
T206 Excel Database
Posted By: Mike Poland
..for the corrections. I updated the spreadsheet and they are now reflected in the download. |
#16
|
|||
|
|||
T206 Excel Database
Posted By: Mike Poland
The T206museum has updated their price list and added grade multipliers for GAI cards and I have made this reflective in my spreadsheet which you can still download from the link above. |
#17
|
|||
|
|||
T206 Excel Database
Posted By: Trae R.
Perfect, thanks Mike! |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I am proud to present a fresh new T206 set image database | Archive | Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions | 10 | 09-22-2007 03:42 AM |
T206 Database designed by Mr. Poland | Archive | Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions | 0 | 05-19-2007 05:01 AM |
t206 database | Archive | Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions | 1 | 05-01-2007 09:21 AM |
T206 Palm Pilot Database | Archive | Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions | 2 | 05-29-2004 03:51 PM |
T206 rare back database | Archive | Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions | 3 | 10-03-2003 01:36 PM |