WITH AGE GRADING
You'll find below a link to Excel files for calculating the score of all multiple events in athletics. For men these are: pentathlon, decathlon, double decathlon, throw pentathlon, indoor pentathlon and indoor heptathlon. For women the same plus heptathlon and double heptathlon. Age gradings for masters are included, but multiple events for children are not. (Note: the order of events of the decathlon and double decathlon for women is not the same as for men. An older version of this site did not count for that.)
Sheet one contains a vocabulary. You can change the text in the yellow cells to whatever you want. All other sheets will show the words as you have written.
Sheet two contains the age-gradings for masters. When gradings are changed you can update the spreadsheet by altering the yellow cells. All calculations on other sheets then will use the updated gradings automatically.
The spreadsheets are simple, see the example to the left. Cells within black rectangles can be changed. The first column is for minutes (distances of 800 m and longer), the second column for seconds (runs) or metres (jumps and throws).
Points of these results are shown in dark blue. For masters both points (dark blue) and result after age grading (black) are given. The final total of a multiple event is shown in light blue, horizontally and another time vertically in column C.
Download Multiple Events Women. (xls 428 K)
Download Multiple Events Men. (xls 324 K)
Weia Reinboud (weia (at-symbol) antenna (dot) nl) (See my index page in case it is not yet open.)