Bonus Scoring

Some activities are more important than others and you may want to increase the score for those activities to recognize their increased value.

Here's how to do it:

Let's say the the activity in row 13 is a checkbox, and when you check that box you typically get 10 points (BasicScoreUnit), but because it is more important than some other activities you want to get 20 points if checked.

Do this:

1.  Double click the cell C2 to display the standard Score Formula. It will display something that looks like this:

=(

IF(and(C8>0,C8<=WakeTime),BasicScoreUnit)+

sum(C9:C31)/60*10+

C36*BasicScoreUnit+

IF(and(C33>0,C33<=BedTime),BasicScoreUnit)+

countif(C9:C44,"True")*BasicScoreUnit+

IF(and(C41>=WeightLow,C41<=WeightHigh),BasicScoreUnit)+

IF(C48>"",BasicScoreUnit)+

C37*BasicScoreUnit

)

2.  Add this line to the second line of the Score formula:

              IF(C13 = True, 10) +

This adds an additional 10 points to the 10 that will be added from the rest of the Score Formula.  But why stop at double double the score; what not make it 50 extra points, or even a thousand. This is your life, your rules, and you can keep score any way you want.

The new Score Formula should look like this:

=(

IF(C13 = True, 10) +

IF(and(C8>0,C8<=WakeTime),BasicScoreUnit)+

sum(C9:C31)/60*10+

C36*BasicScoreUnit+

IFand(C33>0,C33<=BedTime),BasicScoreUnit)+

countif(C9:C44,"True")*BasicScoreUnit+

IF(and(C41>=WeightLow,C41<=WeightHigh),BasicScoreUnit)+

IF(C48>"",BasicScoreUnit)+

C37*BasicScoreUnit

)

3.  If you want this new Score Formula to apply to all the other days, simply highlight cell C2 and drag it over the rest of the days in your checklist.  Bingo!

4.  If the activity in, say, row 13 is not a checkbox, but it tracks hours, then add a line like this:

C13*BasicScoreUnit +

and insert it into line 2 of the Score Formula, so it will look like this:

=( 

C13*BasicScoreUnit + 

IF(C13 = True, 10) +

IF(and(C8>0,C8<=WakeTime),BasicScoreUnit)+

sum(C9:C31)/60*10+

C36*BasicScoreUnit+

IFand(C33>0,C33<=BedTime),BasicScoreUnit)+

countif(C9:C44,"True")*BasicScoreUnit+

IF(and(C41>=WeightLow,C41<=WeightHigh),BasicScoreUnit)+

IF(C48>"",BasicScoreUnit)+

C37*BasicScoreUnit

)

A big Thank You to "Emily" for the suggestion to weight some activities more than others.