{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["abc","2010","2006","2003","calculation constants","2014","Specifications","Data","Results","Summary"],"not_rendered":{"images":4,"macros":1,"external_links":1,"defined_names":19},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"abc","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"hidden":true,"flags":["formulas_cached_only"]}
["MHT",13.0449,{"v":7,"d":"7.00"},1.05,83.27]
["MSP",51.39,{"v":1.5,"d":"1.50"},1.05,{"v":22.2,"d":"22.20"}]
["MDT",12.91,{"v":4,"d":"4.00"},1.1,71.12]
["MJT",10.14,{"v":7,"d":"7.00"},1.08,{"v":96,"d":"96.00"}]
["MWT",47.8338,{"v":1.5,"d":"1.50"},1.05,{"v":25,"d":"25.00"}]
["WHT",17.5458,{"v":6,"d":"6.00"},1.05,{"v":60,"d":"60.00"}]
["WSP",56.0211,{"v":1.5,"d":"1.50"},1.05,21.45]
["WDT",12.3311,{"v":3,"d":"3.00"},1.1,73.87]
["WJT",15.9803,{"v":3.8,"d":"3.80"},1.04,{"v":80,"d":"80.00"}]
["WWT",52.143,{"v":1.5,"d":"1.50"},1.05,19.15]

{"sheet":"2010","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"hidden":true,"flags":["formulas_cached_only"]}
[null,"HT","SP","DT","JT","WT"]
["M",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"}]
["M35",{"v":1.03,"d":"1.0300"},1.0372,1.0143,1.0126,1.0203]
["M40",1.1252,1.1137,1.1014,1.0862,1.0898]
["M45",1.2397,1.2023,1.2049,1.1716,1.1697]
["M50",1.1864,1.1721,1.0218,1.2278,1.0488]
["M55",1.3145,1.2706,1.1103,{"v":1.338,"d":"1.3380"},1.1225]
["M60",1.3082,1.2482,1.0628,{"v":1.414,"d":"1.4140"},1.0424]
["M65",1.4656,1.3607,1.1637,{"v":1.562,"d":"1.5620"},1.1153]
["M70",1.5124,1.3471,1.2781,1.6801,1.1408]
["M75",1.7268,{"v":1.479,"d":"1.4790"},1.4332,1.8932,1.2286]
["M80",1.9056,{"v":1.598,"d":"1.5980"},1.6441,2.0952,1.3043]
["M85",2.2784,1.8037,1.9508,2.4378,1.4452]
["M90",2.8506,2.1123,2.4402,2.9137,1.6714]
["M95",3.8462,2.6497,3.3478,3.6206,2.1057]
["M100",6.0204,3.8476,5.6116,null,3.2456]
["W",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"}]
["W35",1.0942,1.0368,1.0368,1.0621,1.0922]
["W40",1.1763,{"v":1.11,"d":"1.1100"},1.115,1.1475,1.1852]
["W45",1.2717,1.1943,1.2058,1.2479,1.2955]
["W50",1.2838,1.2607,1.3128,1.3147,1.1822]
["W55",1.3984,1.3706,1.4407,1.4482,1.2918]
["W60",1.5353,1.5015,1.5961,1.5408,1.2108]
["W65",1.7038,{"v":1.66,"d":"1.6600"},1.7927,1.7274,{"v":1.326,"d":"1.3260"}]
["W70",{"v":1.916,"d":"1.9160"},1.8559,2.0542,1.9654,1.4667]
["W75",1.9984,1.8324,2.1546,2.2794,1.5146]
["W80",{"v":2.303,"d":"2.3030"},2.0742,2.522,2.7129,1.7006]
["W85",2.7218,2.3894,3.0404,{"v":3.35,"d":"3.3500"},1.9493]
["W90",3.3333,2.8176,3.827,4.3782,2.2716]
["W95",4.3103,3.4328,5.1626,6.3171,2.7412]
["W100",{"v":6.112,"d":"6.1120"},4.3917,7.9302,{"v":11.337,"d":"11.3370"},3.4891]

{"sheet":"2006","index":2,"n_rows":31,"n_cols":7,"rows_kept":31,"hidden":true,"flags":["formulas_cached_only"]}
[null,"HT","SP","DT","JT","WT"]
["M",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},"M"]
["M35",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},1,1.0434,1.0252,"M35"]
["M40",1.0798,1.0271,1,1.1283,1.0943,"M40"]
["M45",1.1846,1.1131,1.0499,1.2283,1.1734,"M45"]
["M50",1.1656,1.1468,1,{"v":1.279,"d":"1.2790"},1.1123,"M50"]
["M55",1.2992,1.2736,1.0984,1.4059,1.2105,"M55"]
["M60",1.4058,1.2703,1.1232,1.4804,1.1392,"M60"]
["M65",1.5853,1.4719,1.2514,1.6496,1.2615,"M65"]
["M70",1.6112,1.3017,1.4127,1.7461,1.2943,"M70"]
["M75",1.8749,1.5043,1.6217,2.0098,1.4735,"M75"]
["M80",1.9497,1.5486,1.9033,2.0612,{"v":1.573,"d":"1.5730"},"M80"]
["M85",2.4236,1.8998,2.3034,2.6164,1.8648,"M85"]
["M90",3.2031,2.4544,2.9162,3.5811,2.2895,"M90"]
["M95",4.7193,3.4663,3.9735,5.6724,2.9647,"M95"]
["M100",{"v":8.97,"d":"8.9700"},{"v":5.898,"d":"5.8980"},6.2333,13.6357,4.2049,"M100"]
["W",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},"W"]
["W35",1.1387,{"v":1.056,"d":"1.0560"},1.0288,{"v":1,"d":"1.0000"},1.2752,"W35"]
["W40",1.3007,1.1722,1.1071,1.0946,1.4014,"W40"]
["W45",1.5166,1.3173,1.1983,1.2435,1.5554,"W45"]
["W50",1.2506,1.3876,1.3059,1.3645,1.2414,"W50"]
["W55",1.3745,1.5191,1.4348,{"v":1.545,"d":"1.5450"},1.3601,"W55"]
["W60",1.5256,1.6782,1.5918,{"v":1.746,"d":"1.7460"},1.2741,"W60"]
["W65",1.7141,1.8744,1.7874,1.9559,1.4307,"W65"]
["W70",1.9557,2.1227,2.0379,2.2231,1.6312,"W70"]
["W75",2.2766,2.4468,2.37,2.5749,1.8972,"W75"]
["W80",2.7235,2.8876,2.4063,{"v":3.059,"d":"3.0590"},2.2667,"W80"]
["W85",3.3886,3.5222,2.9886,3.7672,2.8149,"W85"]
["W90",4.4837,4.5143,3.9416,4.9021,3.7131,"W90"]
["W95",6.6247,6.2845,5.7868,7.0157,5.4529,"W95"]
["W100",12.6783,10.3385,10.88,12.3333,10.2609,"W100"]

{"sheet":"2003","index":3,"n_rows":33,"n_cols":7,"rows_kept":33,"hidden":true,"flags":["formulas_cached_only"]}
[null,"HT","SP","DT","JT","WT"]
["M",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},"W"]
["M30",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},"W30"]
["M35",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},1.0434,1.0252,"W35"]
["M40",1.0798,1.0271,{"v":1,"d":"1.0000"},1.1283,1.0943,"W40"]
["M45",1.1846,1.1131,1.0499,1.2283,1.1734,"W45"]
["M50",1.1656,1.1468,{"v":1,"d":"1.0000"},{"v":1.279,"d":"1.2790"},1.1123,"W50"]
["M55",1.2992,1.2736,1.0984,1.4059,1.2105,"W55"]
["M60",1.4058,1.2703,1.1232,1.4804,1.1392,"W60"]
["M65",1.5853,1.4719,1.2514,1.6496,1.2615,"W65"]
["M70",1.6112,1.3017,1.4127,1.7461,1.2943,"W70"]
["M75",1.8749,1.5043,1.6217,2.0098,1.4735,"W75"]
["M80",2.2417,1.7816,1.9033,2.0612,{"v":1.573,"d":"1.5730"},"W80"]
["M85",{"v":2.787,"d":"2.7870"},2.1843,2.3034,2.6164,1.8648,"W85"]
["M90",3.6828,2.8222,2.9162,3.5811,2.2895,"W90"]
["M95",5.4272,3.9862,3.9735,5.6724,2.9647,"W95"]
["M100",10.3117,6.7847,6.2333,13.6357,4.2049,"W100"]
["W",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},"M"]
["W30",1.0125,{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},1.1699,"M30"]
["W35",1.1387,{"v":1.056,"d":"1.0560"},1.0288,{"v":1,"d":"1.0000"},1.2752,"M35"]
["W40",1.3007,1.1722,1.1071,1.0946,1.4014,"M40"]
["W45",1.5166,1.3173,1.1983,1.2435,1.5554,"M45"]
["W50",1.2506,1.3876,1.3059,1.3645,1.2414,"M50"]
["W55",1.3745,1.5191,1.4348,{"v":1.545,"d":"1.5450"},1.3601,"M55"]
["W60",1.5256,1.6782,1.5918,{"v":1.746,"d":"1.7460"},1.2741,"M60"]
["W65",1.7141,1.8744,1.7874,1.9559,1.4307,"M65"]
["W70",1.9557,2.1227,2.0379,2.2231,1.6312,"M70"]
["W75",2.2766,2.4468,{"v":2.37,"d":"2.3700"},2.5749,1.8972,"M75"]
["W80",2.7235,2.8876,2.8315,{"v":3.059,"d":"3.0590"},2.2667,"M80"]
["W85",3.3886,3.5222,{"v":3.516,"d":"3.5160"},3.7672,2.8149,"M85"]
["W90",4.4837,4.5143,4.6372,4.9021,3.7131,"M90"]
["W95",6.6247,6.2845,{"v":6.808,"d":"6.8080"},7.0157,5.4529,"M95"]
["W100",12.6783,10.3385,{"v":12.8,"d":"12.8000"},12.3333,10.2609,"M100"]

{"sheet":"calculation constants","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"hidden":true,"merged":[[0,0,0,8],[2,0,2,9]],"flags":["formulas_cached_only"]}
["FORMULAE FOR IAAF COMBINED EVENTS SCORING SYSTEM"]
[]
["For a given performance, the point score (P) is calculated using the equation:- \nP=a*(D - b)**c where D is Distance in metres."]
["Men"]
[null,"HT",13.0449,{"v":7,"d":"7.00"},1.05]
[null,"SP",51.39,{"v":1.5,"d":"1.50"},1.05]
[null,"DT",12.91,{"v":4,"d":"4.00"},1.1]
[null,"JT",10.14,{"v":7,"d":"7.00"},1.08]
[null,"WT",47.8338,{"v":1.5,"d":"1.50"},1.05]
["Women"]
[null,"HT",17.5458,{"v":6,"d":"6.00"},1.05]
[null,"SP",56.0211,{"v":1.5,"d":"1.50"},1.05]
[null,"DT",12.3311,{"v":3,"d":"3.00"},1.1]
[null,"JT",15.9803,{"v":3.8,"d":"3.80"},1.04]
[null,"WT",52.143,{"v":1.5,"d":"1.50"},1.05]

{"sheet":"2014","index":5,"n_rows":31,"n_cols":6,"rows_kept":31,"hidden":true,"flags":["formulas_cached_only"]}
[null,"HT","SP","DT","JT","WT"]
["M",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"}]
["M35",{"v":1.03,"d":"1.0300"},1.0372,1.0143,1.0126,1.0203]
["M40",1.1252,1.1137,1.1014,1.0862,1.0898]
["M45",1.2397,1.2023,1.2049,1.1716,1.1697]
["M50",1.1864,1.1721,1.0218,1.2278,1.0488]
["M55",1.3145,1.2706,1.1103,{"v":1.338,"d":"1.3380"},1.1225]
["M60",1.3082,1.2482,1.0628,{"v":1.414,"d":"1.4140"},1.0424]
["M65",1.4656,1.3607,1.1637,{"v":1.562,"d":"1.5620"},1.1153]
["M70",1.5124,1.3471,1.2781,1.6801,1.1408]
["M75",1.7268,{"v":1.479,"d":"1.4790"},1.4332,1.8932,1.2286]
["M80",1.9056,{"v":1.598,"d":"1.5980"},1.6441,2.0952,1.3043]
["M85",2.2784,1.8037,1.9508,2.4378,1.4452]
["M90",2.8506,2.1123,2.4402,2.9137,1.6714]
["M95",3.8462,2.6497,3.3478,3.6206,2.1057]
["M100",6.0204,3.8476,5.6116,null,3.2456]
["W",{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"}]
["W35",1.0942,1.0368,1.0368,1.0621,1.0922]
["W40",1.1763,{"v":1.11,"d":"1.1100"},1.115,1.1475,1.1852]
["W45",1.2717,1.1943,1.2058,1.2479,1.2955]
["W50",1.2838,1.2607,1.3128,1.3147,1.1822]
["W55",1.3984,1.3706,1.4407,1.4482,1.2918]
["W60",1.5353,1.5015,1.5961,1.6118,1.2108]
["W65",1.7038,{"v":1.66,"d":"1.6600"},1.7927,1.8171,{"v":1.326,"d":"1.3260"}]
["W70",{"v":1.916,"d":"1.9160"},1.8559,2.0542,2.0992,1.4667]
["W75",1.9984,1.8324,2.1546,2.2794,1.5146]
["W80",{"v":2.303,"d":"2.3030"},2.0742,2.522,2.7129,1.7006]
["W85",2.7218,2.3894,3.0404,{"v":3.35,"d":"3.3500"},1.9493]
["W90",3.3333,2.8176,3.827,4.3782,2.2716]
["W95",4.3103,3.4328,5.1626,6.3171,2.7412]
["W100",{"v":6.112,"d":"6.1120"},4.3917,7.9302,{"v":11.337,"d":"11.3370"},3.4891]

{"sheet":"Specifications","index":6,"n_rows":40,"n_cols":9,"rows_kept":40,"merged":[[0,1,0,8],[3,7,3,8],[15,3,15,4],[24,1,24,9],[26,1,26,2],[26,3,26,9],[27,1,27,2],[27,3,27,9],[28,1,28,2],[28,3,28,9],[29,1,29,2],[29,3,29,9],[30,1,30,2],[30,3,30,9],[31,1,31,2],[31,3,31,9],[32,3,32,4]],"flags":["formulas_cached_only"]}
[null,"Extract from WMA Handbook  Appendix A"]
[]
[null,"Age Group Implements 2014"]
[null,null,"Age","Hammer","Shot","Discus","Javelin","Weight"]
[null,"Women","35-49","4k","4k","1k","600g","9.08k","(20lb)"]
[null,null,"50-59","3k","3k","1k","500g","7.26k ","(16lb)"]
[null,null,"60-74","3k","3k","1k","500g","5.45k","(12lb)"]
[null,null,"75 +","2k","2k","0.75k","400g","4k"]
[null,"Men","35-49","7.26k","7.26k","2k","800g","15.88k","(35lb)"]
[null,null,"50-59","6k","6k","1.5k","700g","11.34k ","(25lb)"]
[null,null,"60-69","5k","5k","1k","600g","9.08k ","(20lb)"]
[null,null,"70-79","4k","4k","1k","500g","7.26k  ","(16lb)"]
[null,null,"80+","3k","3k","1k","400g","5.45k ","(12lb)"]
[]
[null,"Hammer Specification"]
[null,null,"Minimum","Length (mm)"]
[null,null,"Weight","Min","Max"]
[null,null,"7.26k",1175,1215]
[null,null,"6ki",1175,1215]
[null,null,"5k",1165,1200]
[null,null,"4k",1160,1195]
[null,null,"3k",1160,1195]
[null,null,"2k",1160,1195]
[]
[]
[null,"Weight Specification"]
[null,"Construction",null,"The weight shall consist of three parts: a metal head, the link, and a grip."]
[null,"Head",null,"The head shall be of solid iron or other metal not softer than brass or a shell of such metal, filled with lead or other solid materials. \nIf a filling is used. this must be inserted in such manner that it is immovable. The centre of gravity of the head, "]
[null,"Link",null,"The head shall be connected to the grip by means of metal link(s). The link(s) shall be of sufficient strength to ensure that the link(s) cannot stretch appreciably while the weight is being thrown."]
[null,"Grip",null,"The grip may be either of single or double loop construction but must be rigid and without hinging joints of any kind. It must not stretch appreciably while being thrown. It must be attached to the links in such a manner that it cannot be turned within th"]
[null,"Connections",null,"The links shall be connected to the head by means of a swivel, which may be either plain or ball bearing. A swivel may not be used to connect the grip to the link(s)"]
[null,"Length",null,"The length shall not be more than 410mm measured from the inside of the grip."]
[null,null,"Minimum","Diameter"]
[null,null,"Weight","Min","Max"]
[null,null,"15.88k","145mm","165mm"]
[null,null,"11.34k","130mm","150mm"]
[null,null,"9.08k","120mm","140mm"]
[null,null,"7.26k","110mm","130mm"]
[null,null,"5.45k","100mm","120mm"]
[null,null,"4k","95mm","110mm"]

{"sheet":"Data","index":7,"n_rows":9,"n_cols":9,"rows_kept":9,"merged":[[0,0,0,4],[0,5,1,8],[1,0,1,4],[4,0,4,8],[5,0,5,2],[5,3,5,8],[6,0,6,2],[6,3,6,8],[7,0,7,2],[7,3,7,8]],"flags":["formulas_cached_only"]}
["Data Entry Sheet"]
["Enter details of the competition below."]
["To step to the next field use the enter or tab key."]
["Competitors can be in any order."]
["Events not completed can be left blank.\nTo enable the macros to work you must set macro security\nsuitably. How to do this depends on your version of Excel."]
["Competition Name : "]
["Competition Venue :"]
["Competition Date :"]
["GROUP","No","Name","Club","HT","SP","DT","JT","WT"]

{"sheet":"Results","index":8,"n_rows":7,"n_cols":25,"rows_kept":7,"hidden":true,"merged":[[0,0,0,7],[0,8,0,23],[1,0,1,2],[1,3,1,23],[2,0,2,2],[2,3,2,23],[3,0,3,2],[3,3,3,23],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,7],[4,8,4,11],[4,12,4,15],[4,16,4,19],[4,20,4,23],[4,24,5,24]],"flags":["formulas_cached_only"]}
["Weights Pentathlon Full Results ",{"$nulls":7},"2014 Tables"]
["Competition :"]
["Venue :"]
["Date :"]
["Age\nGroup","Pos","Name","Club","Hammer Throw",{"$nulls":3},"Shot Putt",{"$nulls":3},"Discus Throw",{"$nulls":3},"Javelin Throw",{"$nulls":3},"Weight Throw",{"$nulls":3},"Total\nPoints"]
[{"$nulls":4},"Actual","Graded","AGF","Points","Actual","Graded","AGF","Points","Actual","Graded","AGF","Points","Actual","Graded","AGF","Points","Actual","Graded","AGF","Points"]
["M35",1,"asas","asas",{"v":4,"d":"4.00"},4.11,{"v":1.0299999713897705,"d":"1.0300"},0,{"v":4,"d":"4.00"},4.14,{"v":1.0371999740600586,"d":"1.0372"},142,{"v":4,"d":"4.00"},4.05,{"v":1.014299988746643,"d":"1.0143"},0,{"v":4,"d":"4.00"},4.05,{"v":1.0125999450683594,"d":"1.0126"},0,{"v":4,"d":"4.00"},4.08,{"v":1.020300030708313,"d":"1.0203"},129,271]

{"sheet":"Summary","index":9,"n_rows":8,"n_cols":1,"rows_kept":8,"hidden":true,"flags":["formulas_cached_only"]}
["Weights Pentathlon Results Summary (2014 Tables)"]
["Competition: "]
["Venue: "]
["Date: "]
["A/G Pos Name (Club) Points (HT ,SP ,DT ,JT ,WT)"]
["M35 1 asas (asas) 271 (4.00, 4.00, 4.00, 4.00, 4.00)"]
["       "]
["       "]