|
NP Manual Calculation
Yes, manual calculation is a pain but I find it is easier by using Excel with formulars (attached below). This presumes you have Excel or a similiar spreadsheet product.
The total formulas for each contender is cut off. The complete formular for the first line #4 is: =SUM(C4*100+D4*60)+E4*40+F4*25).
As you can see for each contender the only variable is the line number.
1. The factors are still manually calculated but using the Call 1 points calulator
and Real Running Style sheets reduces the time. These are available with the
NP seminar download or CD.
2. Then the formulas kick in for the totals and percent which avoids a significant part of the manual calculations.
3. Then back to manual entries for the ranks, early, reg speeds and final EE/LL
Hope this helps.
Ernie
|