New 59-03 with Varieites Lincoln Registry Comparison Excel spreadsheet
sonofagunk
Posts: 1,349 ✭✭
Just like the previous version
here
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
here
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
eBay Error Sales
0