NonSports Forum

Net54baseball.com
Welcome to Net54baseball.com. These forums are devoted to both Pre- and Post- war baseball cards and vintage memorabilia, as well as other sports. There is a separate section for Buying, Selling and Trading - the B/S/T area!! If you write anything concerning a person or company your full name needs to be in your post or obtainable from it. . Contact the moderator at leon@net54baseball.com should you have any questions or concerns. When you click on links to eBay on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network. Enjoy!
Net54baseball.com
Net54baseball.com
ebay GSB
T206s on eBay
Babe Ruth Cards on eBay
t206 Ty Cobb on eBay
Ty Cobb Cards on eBay
Lou Gehrig Cards on eBay
Baseball T201-T217 on eBay
Baseball E90-E107 on eBay
T205 Cards on eBay
Baseball Postcards on eBay
Goudey Cards on eBay
Baseball Memorabilia on eBay
Baseball Exhibit Cards on eBay
Baseball Strip Cards on eBay
Baseball Baking Cards on eBay
Sporting News Cards on eBay
Play Ball Cards on eBay
Joe DiMaggio Cards on eBay
Mickey Mantle Cards on eBay
Bowman 1951-1955 on eBay
Football Cards on eBay

Go Back   Net54baseball.com Forums > Net54baseball Main Forum - WWII & Older Baseball Cards > Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2004, 01:46 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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.

Feel free to download the Excel file Here!
I also made a readme page that can be viewed Here!. I suggest reading it before you use the worksheet.


Any feedback is appreciated.

Reply With Quote
  #2  
Old 12-23-2004, 03:02 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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!

Reply With Quote
  #3  
Old 12-23-2004, 03:31 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default T206 Excel Database

Posted By: Julie

15 minutes of work won't do it...

Reply With Quote
  #4  
Old 12-23-2004, 05:15 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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.

Reply With Quote
  #5  
Old 12-23-2004, 06:05 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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  
Old 12-24-2004, 09:03 AM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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!

Thanks,
Nick


Please register for a free auction catalog: http://www.americanmemorabilia.com/Default.asp

Reply With Quote
  #7  
Old 12-24-2004, 10:23 AM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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.

Reply With Quote
  #8  
Old 12-24-2004, 11:04 AM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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!

Reply With Quote
  #9  
Old 12-28-2004, 04:31 AM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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.

Reply With Quote
  #10  
Old 12-28-2004, 05:27 AM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default T206 Excel Database

Posted By: Peter Thomas

Mike is the base value for the Doyle correct @ $80,000 - should it be $8,000?

Reply With Quote
  #11  
Old 12-28-2004, 05:35 AM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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.

http://www.t206museum.com/page/price_list1.html

Reply With Quote
  #12  
Old 01-04-2005, 10:37 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default T206 Excel Database

Posted By: Joe P.

Not to worry about the $80,000 Doyle figure.
That's a low ball number for a card that has only four known good ones among the T206 collectors.
The Big One is minuscule in numbers, in comparison to each of the Big Three.
The bottom line is supply and demand.
The Doyle's toughness pales the T206 Wagner.

Again Mike, damn good work.
Joe


Reply With Quote
  #13  
Old 01-05-2005, 02:45 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default T206 Excel Database

Posted By: Scot Reader (ebay: sreader3)

... and the price is right! Thanks, Mike.

Reply With Quote
  #14  
Old 01-05-2005, 02:53 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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.

Reply With Quote
  #15  
Old 01-05-2005, 04:32 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default T206 Excel Database

Posted By: Mike Poland

..for the corrections. I updated the spreadsheet and they are now reflected in the download.

Reply With Quote
  #16  
Old 01-06-2005, 09:47 AM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default 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.

Reply With Quote
  #17  
Old 01-06-2005, 03:31 PM
Archive Archive is offline
Administrator
 
Join Date: Mar 2009
Posts: 58,359
Default T206 Excel Database

Posted By: Trae R.

Perfect, thanks Mike!

Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

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


All times are GMT -6. The time now is 02:49 AM.


ebay GSB