![]() |
T206 Excel Database
Posted By: <b>Mike Poland</b><p>I recently created a worksheet/database in Microsoft Excel that will help keep track of your T206 collection. All information is from T206museum.com. <br /><br />Feel free to download the Excel file <a href="http://www.geocities.com/thought_criminal1979/T206Database.xls">Here!</a><br /> I also made a readme page that can be viewed <a href="http://www.geocities.com/thought_criminal1979/readme.txt">Here!</a>. I suggest reading it before you use the worksheet.<br /><br /><br />Any feedback is appreciated.
|
T206 Excel Database
Posted By: <b>Trae R.</b><p>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!
|
T206 Excel Database
Posted By: <b>Julie</b><p>15 minutes of work won't do it...
|
T206 Excel Database
Posted By: <b>Richard Dwyer</b><p>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.
|
T206 Excel Database
Posted By: <b>Mike Poland</b><p>I just noticed this thread <a href="http://www.network54.com/Forum/thread?forumid=153652&messageid=1098127806&lp=1103 683319" target=_new><a href="http://www.network54.com/Forum/thread?forumid=153652&messageid=1098127806&lp=1103 683319</a" target=_new>http://www.network54.com/Forum/thread?forumid=153652&messageid=1098127806&lp=1103 683319</a</a>> and that others were working on something similar. I didn't mean to step on anyones toes.
|
T206 Excel Database
Posted By: <b>Nick Martinez</b><p>This is a great tool, with John firing up my desire to put together the set your work will be a great help!<br /><br />Thanks,<br />Nick<br /><br><br>Please register for a free auction catalog: <a href="http://www.americanmemorabilia.com/Default.asp" target=_new>http://www.americanmemorabilia.com/Default.asp</a>
|
T206 Excel Database
Posted By: <b>Richard Dwyer</b><p>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.
|
T206 Excel Database
Posted By: <b>Mike Poland</b><p>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!
|
T206 Excel Database
Posted By: <b>Mike Poland</b><p>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.
|
T206 Excel Database
Posted By: <b>Peter Thomas</b><p>Mike is the base value for the Doyle correct @ $80,000 - should it be $8,000?
|
T206 Excel Database
Posted By: <b>Mike Poland</b><p>$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. <br /><br /><a href="http://www.t206museum.com/page/price_list1.html" target=_new>http://www.t206museum.com/page/price_list1.html</a>
|
T206 Excel Database
Posted By: <b>Joe P.</b><p>Not to worry about the $80,000 Doyle figure.<br />That's a low ball number for a card that has only four known good ones among the T206 collectors.<br />The Big One is minuscule in numbers, in comparison to each of the Big Three.<br />The bottom line is supply and demand.<br />The Doyle's toughness pales the T206 Wagner.<br /><br />Again Mike, damn good work.<br />Joe <br /><br /> <br />
|
T206 Excel Database
Posted By: <b>Scot Reader (ebay: sreader3)</b><p>... and the price is right! Thanks, Mike.
|
T206 Excel Database
Posted By: <b>Scot Reader (ebay: sreader3)</b><p>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.
|
T206 Excel Database
Posted By: <b>Mike Poland</b><p>..for the corrections. I updated the spreadsheet and they are now reflected in the download.
|
T206 Excel Database
Posted By: <b>Mike Poland</b><p>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.
|
T206 Excel Database
Posted By: <b>Trae R.</b><p>Perfect, thanks Mike!
|
All times are GMT -6. The time now is 06:38 PM. |