New Excel Checklists available; T201, T202, T205, T206

[Joshchisox08]

I think that I'm at the point that I'd like a handful of people to test out my MASTER CHECKLIST for t206.

It will have a main page as well as a Back Run, Pose, Team, Series, Player info which includes DOB, DOD, State and town born, died, buried, and All of the players statistics. And a section where you can add what you paid for a card vs what the value is. (I use t206.org)

This is an Excel file so some of the stuff has links and uses table referencing. A general knowledge of Excel would be ideal.

I know that there's bound to be some errors on my part. I'm looking for input, suggestions, comments.

I've put a LOT of time into this and when I get home from work if anyone has any interest I'll send you a copy. I'd like to just send it out to about 5 people if I have 5 people interested that is, to test it out and give me feedback. I'd appreciated feedback in this forum as well.

I'm also working on adding a picture of each card when you scroll over the players name on the first page.

Thanks and hope someones interested !

[Econteachert205]

Josh, sounds like a crazy difficult project. Just curious, how will it differ from T206 resource? Format?

[Joshchisox08]

Hey Dennis I'm relatively new to being serious about t206 and back into collecting as I haven't in about 10 years. I forgot which site but I downloaded a .pdf full of information and checklists for the series.

Referencing t206 resource there's not a whole lot of a difference. When I can manage to figure out the other half of this I may try and integrate it to the Web but that's when I fix all errors and add the photos.

[Joshchisox08]

Anyone else ??? I've only had one person interested in this. I'm looking for input and constructive criticism.

[shernan30]

You can send me a copy to go through. I only dabble in T206 currently, but I'm an Excel junkie. Shernan30@gmail.com


Sent from my iPhone using Tapatalk

[Bpm0014]

im interested, bmullen0014@aol.com thanks!

[tedzan]

A colorful EXCEL spreadsheet titled "T206 SuperSet" was created by Bill Brown in 2006.

Contact Bill (BBT206), you may like to check it out and compare it with yours.


TED Z
.

[Joshchisox08]

@ Ted booooooooooooooooo lol. I did all this work for nothing. Oh well it's kept my sanity !!!! Somewhat ............. yeah I may look into that to compare. I'll still use mine though (because of the time put into it) and maybe I'll incorporate some changes he has.

Thanks for the info !!!

[Luke]

Josh, send it to me. I'd like to check it out.

[tedzan]

Originally Posted by Joshchisox08

@ Ted booooooooooooooooo lol. I did all this work for nothing. Oh well it's kept my sanity !!!! Somewhat ............. yeah I may look into that to compare. I'll still use mine though (because of the time put into it) and maybe I'll incorporate some changes he has.

Thanks for the info !!!

Josh

Bill's spreadsheet served as an EXCEL-lent "vehicle" for establishing the front/back permutations in the T206 set from inputs from Net54 collectors of T206's.

It's been some years since it was active, so I would guess that your's is more up to date than Bill's.

Send me a copy......tedzan11@comcast.net.


Thanks,

TED Z
.

[Enfuego]

Originally Posted by Joshchisox08

I think that I'm at the point that I'd like a handful of people to test out my MASTER CHECKLIST for t206.

It will have a main page as well as a Back Run, Pose, Team, Series, Player info which includes DOB, DOD, State and town born, died, buried, and All of the players statistics. And a section where you can add what you paid for a card vs what the value is. (I use t206.org)

This is an Excel file so some of the stuff has links and uses table referencing. A general knowledge of Excel would be ideal.

I know that there's bound to be some errors on my part. I'm looking for input, suggestions, comments.

I've put a LOT of time into this and when I get home from work if anyone has any interest I'll send you a copy. I'd like to just send it out to about 5 people if I have 5 people interested that is, to test it out and give me feedback. I'd appreciated feedback in this forum as well.

I'm also working on adding a picture of each card when you scroll over the players name on the first page.

Thanks and hope someones interested !

Haven't recieved my copy yet?

j.rodriguez2001@yahoo.com

Thanks !

[Eggoman]

I'd love to check out a copy, too!

THanks,
Greg
rzayatz@roadrunner.com

[deucetwins]

Please send me a copy as well.

jstonecarp@gmail.com

Thanks,
Jeff.

[larrie804]

Please send me a copy!

larriedean@verizon.net

Thank you,
Larrie

[jimscards]

Would love to see this too... jimscards@outlook.com

Thanks!

[clydepepper]

Josh- I'm ready for an updated version - thanks

[Joshchisox08]

Originally Posted by clydepepper

Josh- I'm ready for an updated version - thanks

Ray I need your email address again. Still trying to get used to everyone on this site.

[Eggoman]

I'd like REV A, too, please!

Eggo

rzayatz@roadrunner.com

[Joshchisox08]

Originally Posted by Eggoman

I'd like REV A, too, please!

Eggo

rzayatz@roadrunner.com

Sent Greg. I spent about 5 hours today updating/adding photos to the front page when you hover over the pose. I'll resend those sometime tomorrow to everyone who wanted Rev A.

[gregr2]

Please send me the update Josh.

[Joshchisox08]

Originally Posted by gregr2

Please send me the update Josh.

Need email addresses ppl lol. I'm a drinker and only know a handful of people by name.

[ceast]

Josh,

I would love the revision when you get a chance. Thanks, Chris
ceast@knology.net

[Joshchisox08]

Rev B Is ready to be released. Per a request, I believe from Tony Davis I have left my collection out and it is starting from complete scratch.

I will continue to work on the automation process until it is fully automated.

Rev B will include the following updates:

1. Fixed some issues on the player stat page (numbers of the cards were not correct).
2. The batter and pitcher stat pages will automatically add the quantity of the card you own on that page (fully automated).
3. $$$ page has been redesigned and is fully automated by adding the quantity if you own that card. Manual input obviously for what you paid for the card still.
4. The main page drop-down menu's have been improved and are much more user friendly.
5. The individual series checklist tabs have been automated to the point that you will only have to put an "X" in the box and it will tally up everything using a simple COUNTIF statement.

This is at the point where nearly everything is automated that can be done.

PM me your email address.

P.S. as a huge favor would you please let me know if you actually use this file ???? I want to get a head count on the amount of people whom actually like this file.

Cheers !

Josh

[Jeff_cvc]

Hi Josh,

What an incredible project you've undertaken, I would be honored to get a copy.

With great appreciation,

Jeff
Jrsfbunch@aol.com

[wilkiebaby11]

Minitaber13@gmail.com
I'd like a copy!



Sent from my iPhone using Tapatalk

[Joshchisox08]

That's right read the heading:

New Checklists available; T201, T202, T205, T206

[Eggoman]

Hey Josh:

I'm interested, of course!

Greg

[Joshchisox08]

Which would you like Greg. I should have mentioned the T206 has nothing new to it. The others are all brand spanking new with player stats, info, the main page with photos of the cards, etc

I'll need your email again too you can PM me if you'd prefer to do it that way.

[familytoad]

Hey Josh,
I'm a T205 guy so I would love to see that version. :-)
It also sounds like you've got a nice project done for t206, so I'd really like to review that sheet too!

Familytoad@comcast.net

[freakhappy]

Josh...whenever you get a chance, I would love a copy of each. Great job and thanks for your generosity and effort!

Cavelyon@aol.com