Women Ultra-Weight Pentathlon Scoring Spreadsheet Rex Harvey 12Aug13
Age Factored Performance = Actual Performance times the appropriate Age Factor and then rounded down to the lower centimeter
Points = a (Age Factored Performance -b) ^ c        Women; a=52.1403, b=1.5, c=1.05
Required Entries:  Age or Age Group and performance (in meters) in each of the five proper events for that age group.
If more lines are needed just copy and paste and blank line to create as many more lines as needed.
Copy this spreadsheet and Save it as another file name for each meet.
Women Ultra-Weight Throws Pentathlon Table of Implements    
  Weight Super Weight 20# 25# 35# 44# 56# 98#  
  Open-49 20# 35# X X X
  50-59 16# 25# X X X  
  60-74 12# 20# X X X  
  75+ 4kg 16# X X X      
Be sure that each person throws the proper weights for their age group and throws them in the proper order: light to heavy.  
If more than three throws are given in a competition, only the first three count for the Pentathlon.  Anything else does not count.  
  Example:                                              
75 Jane  Doe 1937 5.80 419   0 4.00 398 3.00 347 2.50 366 2.00 407   0   0   0      
Total                
Age First Name Last Name Points 8.8# pts 12# pts 16# pts 20# pts 25# pts 35# pts 44# pts 56# pts 98# pts Date City State
71 Suzy Wojcik 3322   0 7.73 574   0 5.63 634 4.67 662 3.62 702 3.05 750   0   0 8/24/13 Seattle Wa
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0   0