Net54baseball.com Forums

Net54baseball.com Forums (http://www.net54baseball.com/index.php)
-   Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions (http://www.net54baseball.com/forumdisplay.php?f=2)
-   -   T206 Excel Database (http://www.net54baseball.com/showthread.php?t=75716)

Archive 12-23-2004 01:46 PM

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.

Archive 12-23-2004 03:02 PM

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!

Archive 12-23-2004 03:31 PM

T206 Excel Database
 
Posted By: <b>Julie</b><p>15 minutes of work won't do it...

Archive 12-23-2004 05:15 PM

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.

Archive 12-23-2004 06:05 PM

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.

Archive 12-24-2004 09:03 AM

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>

Archive 12-24-2004 10:23 AM

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.

Archive 12-24-2004 11:04 AM

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!

Archive 12-28-2004 04:31 AM

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.

Archive 12-28-2004 05:27 AM

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?

Archive 12-28-2004 05:35 AM

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>

Archive 01-04-2005 10:37 PM

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

Archive 01-05-2005 02:45 PM

T206 Excel Database
 
Posted By: <b>Scot Reader (ebay: sreader3)</b><p>... and the price is right! Thanks, Mike.

Archive 01-05-2005 02:53 PM

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.

Archive 01-05-2005 04:32 PM

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.

Archive 01-06-2005 09:47 AM

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.

Archive 01-06-2005 03:31 PM

T206 Excel Database
 
Posted By: <b>Trae R.</b><p>Perfect, thanks Mike!


All times are GMT -6. The time now is 10:15 AM.