Baby Pool - Points Calculations

[2709236]

OK, this one's kind of fun.

Running a baby pool at work. People guess:

a) The baby's birthdate
b) The baby's weight
c) The baby's length
d) The first letter of the baby's name

Penalty points are given for every day, ounce, inch and letter away from the actual outcome.

Is there a way that this can be calculated automatically? I'm attaching a sample guess page with hypothetical results.

[shg]

There's nowhere on your form to record the actual data or the penalty points ...

[2709236]

I'm attaching an updated form.

[shg]

If you change col C to a full date (3/3/2011) instead of just a month, then in I7 and copy down,

=ABS(C7-C$3) + ABS(16*E7+F7 - 16*E$3-F$3) + ABS(G7-G$3) + ABS(CODE(H7) - CODE(H$3))

Then you can delete col D.

[2709236]

That is incredible. Thanks so much!