New 09-58 Lincoln Registry Comparison Excel spreadsheet

sonofagunk · November 2, 2003 1:02AM

here

I will put up more info on how to use it shortly. Poople that rember this from last year, it is basically the same.

for a quick start:
change cells E3 or F3 to compare different sets (just do it and see)

change cell B2 to yes to highlight all of the coins in sets that are better then the set you are looking at (the set that you are "looking at" is the one that you specify in cell E3)

Dark cyan is a coin that is top pop. light cyan is one that is one grade less than top pop

To see what a set's score would be change the coin in columns M through EA. DO NOT CHANGE THE ONES IN columns E OR F
the current rank is in row 3, if you change any coins, then the newly compute rank is in row 2. My calcs of rank are a little different then PCGS's (but only VERY SLIGHTLY) because they do the math totally wrong.

as an example, go to cell N7 and delete Tom Mershon's MS67RD 1909VDB (just go to the cell and hit the delete key). See how his set's score drops to 68.10 and drops him to 5th place and everyone else moves up a spot. This is what would happen if tom decided to send me this coin for free.

Have fun
-sog

dpoole · November 2, 2003 4:23AM

SOG,

This is astoundingly cool! Wow, you went to a lot of trouble! Thanks so much!

clackamas · November 2, 2003 8:28AM

Paul,

Thanks for the great work and spreadsheet. As always very helpful.

Brian

coolkarma · November 2, 2003 8:39AM

Yes, very impressive. Much more complete and ambitious than the spreadsheets I use to track my sets (which all contain many fewer coins). Thanks for your efforts!

CoolKarma

P.S., You have a minor typo in cells i141 and i142.

Keyrock · November 2, 2003 9:55AM

SOG,

I'll open my set after this post. I was tired of looking at it while at work so I closed it up.

Rich

LincolnCentMan · November 2, 2003 10:44AM

Now everyone can see how much better their set is compaired to mine! Totally cool!

David

sonofagunk · November 2, 2003 1:24PM

Thanks Rich,
I just updated it with your set in it

-Paul

sonofagunk · November 2, 2003 10:03PM

coolkarma,
Thanks for the report, keep them coming. Also, if anyone has any requests, feel free to shoot them my way.
-sog

jacktheknife · November 3, 2003 5:56AM

Very nice and very nice of you to share it with us.

sonofagunk · November 4, 2003 8:22AM

If any of the other hidden sets would like to come out, I will add you to the spreadsheet.

mrpaseo · November 4, 2003 8:42AM

Great job old chap, I do remember your spreadsheet from afar. If my memory serves me correcly I believe there was mroe than one, did you also complete the 1959-Present set?

Thanks for sharing,
Ray

sonofagunk · November 4, 2003 9:26AM

yup I have a 1959- one too. It is actually better. It uses the pops in the sets to compile a complete pop report. Took it out of this one because with all the BN and RB (mostly from my set :&gt

it left things a little tricky. Probably be posting that one soon though.

-sog

jacktheknife · November 4, 2003 10:23AM

SOG,
How is it updated? Let's say there is a lot of activity in the registry set, do you have to manually update or is there a way to just copy and paste?

sonofagunk · November 4, 2003 11:31AM

Jack,
There is a way to have excel go out to the web and retrive data (if you are interested and know a little about excel see
data->get external data->new web query). I have a version of the excel spreadsheet that has 100-110 extra worksheets (and a few macros that generate the worksheets) in it that are used to update the data. It takes about 20 minutes for me to update the sheet with the newest data (and I could do a new registry all together in about an hour or two)

I would post the entire spreadsheet, but it would just confuse people and it is very large (8 megs or so)
-sog

KAJ1 · November 4, 2003 2:55PM

Very nice job !

DAM · November 4, 2003 9:51PM

SOG,

That is WAY

!!

It makes the spread sheet I use look like a model T in comparison.

I guess I'll have to get out the book and learn what Excel can "really" do.

Thanks for sharing. What a neat spreadsheet!

sonofagunk · November 4, 2003 11:13PM

DAM,
Not that you need it, I just put up one for the Two Cent Registry. Always been impressed by your set.

-sog

RELLA · November 5, 2003 12:09AM

SOG,

An awesome job and a great tool for Lincoln enthusiasts. As always, thanks so much for sharing.

This is also very useful to all those cowards lurking around the forums who don't have the seeds to come out in public and show others how their set compares to the rest.

I would not be confused by the entire spreadsheet; I don't think. I am amazed that it is 8 megs, though. I wouldn't mind taking a look someday if you decide to make it available. Right now I'm fighting with my own spreadsheet issues though and I'm sure I'm making a number of things more complicated than they need to be. In other words...keep a lookout for a PM or three from me.

RELLA

DAM · November 5, 2003 1:00AM

SOG,

I just looked at it. Thanks. That is really neat!

marcalan84 · November 5, 2003 3:18PM

SOG- I too like it. It saves a ton of time when wanting to see what sets have a given date, etc. I just need to figure out how we can have access to it every time it gets updated. Thanks, Marc (Kyle Patrick Collection)

sonofagunk · February 18, 2004 9:21AM

Been a long time, but I have a new version up there now

New 09-58 Lincoln Registry Comparison Excel spreadsheet

Comments