Set Weight Calculation - HELP

Popcoin

OK, I had this down at one time but lost my spreadsheet.

What is wrong with my calculation:

Grade (+ Bonus or - Deduction) x Coin Weight = Total Coin Weight

Add all "Total Coin Weights" and Divide by Total coins in set = Set Weight

I am coming up with a little less than 1/2 of what the set is weighted(132.29 vs 57.77)

Thanks for any help,

Larry

perfectstrike

Divide by the total of the Weights of the coins in the set. As an example, a set of 10 with 5 = weight of 1, and 5 = weight of 2, would be divided by 15.

perfectstrike

Popcoin

Perfectstrike,

Thanks, that worked, however, I am still coming up 1 bonus point to much in my 20th Century Major Type Set. I have checked all my grades, weights and bonus points, but I must have missed something.

Does anyone else have a spreadsheet of this set and are you calculating correctly?

Larry

Popcoin

I have checked everything multiple times and I am still coming up with a different set weight.
Can anyone help me here??

I sent the following email to CU but have no reply yet:

Could you please check out my 20th Century Type Set, Major Types, No Gold (1900-1999) "The DeVinney Collection" set.

I have a spreadsheet that calculates the set weight and I am coming up either one bonus point too many or a one point deduction that I do not have (57.79 vs 57.77)

My Calculations are:

Coin Grade (plus or minus Bonus or Deduction) times Coin Weight = Total Coin Weight

Total of all Total Coin Weights divided by Total Set Coin weights = Set Weight.

My spreadsheet has no deduction points on it and the following bonus points:

Lincoln Bronze - 2 bonus for DC
Lincoln Zinc - 2 bonus for DC
Roosevelt Silver - 2 bonus for DC
Washington Silver - 1 bonus for CA
Franklin - 1 bonus for CA

If you can help me with this I would greatly appreciate it.

Thanks,
Larry DeVinney (popcoin)

DeepCoin

Larry,

I checked the weights for this set. There is no bonus for the DC on the Lincoln Zinc cent. I redid the calcuations and it all works out with no bonus for this coin. I hope this solves your dilemna.

Popcoin

DeepCoin,

I think I looked at those bonus points so many times I kept seeing the same thing. That was my problem.

Thanks you so much for your time to do that, I thought I was going crazy and/or blind.

Again, THANKS

Larry