{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Drivers","Details","Master","Dressage","RunOrder1","RunOrder2","Printing","Master_Template0","PPPenalties","ConesPenalties","ObsPenalties","Data","Master_Template1","League","Master_Template2"],"not_rendered":{"charts":0,"images":26,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Drivers","index":0,"n_rows":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Details!B1","v":"ICD  01/09/2024"}]
[]
[null,null,null,null,null,"Start:","09:00:00"]
[]
["Number","Driver","Class","Champ Class","Notes/Area","Start Time","Test (mins)"]
[1,null,null,null,null,{"$f":"G3","v":"09:00:00"},5]
[{"$f":"A6+1","v":2},null,null,null,null,{"$f":"INDIRECT(\"R[-1]C\",0)+(INDIRECT(\"R[-1]C[1]\",0)/1440)","v":"09:05:00"},5]
[{"$f":"A7+1","v":3},null,null,null,null,{"$f":"INDIRECT(\"R[-1]C\",0)+(INDIRECT(\"R[-1]C[1]\",0)/1440)","v":"09:10:00"},5]
[4,null,null,null,null,{"$f":"INDIRECT(\"R[-1]C\",0)+(INDIRECT(\"R[-1]C[1]\",0)/1440)","v":"09:15:00"},5]
[5,null,null,null,null,"09:20:00",5]
[6,null,null,null,null,"09:25:00",5]
[7,null,null,null,null,"09:30:00",5]
[8,null,null,null,null,"09:35:00",5]
[9,null,null,null,null,"09:40:00",5]
[10,null,null,null,null,"09:45:00",5]
[11,null,null,null,null,"09:50:00",5]
[12,null,null,null,null,"09:55:00",5]
[13,null,null,null,null,"10:00:00",5]
[14,null,null,null,null,"10:05:00",5]
[15,null,null,null,null,"10:10:00",5]
[16,null,null,null,null,"10:15:00",5]
[17,null,null,null,null,"10:20:00",5]
[18,null,null,null,null,"10:25:00",5]
[19,null,null,null,null,"10:30:00",5]
[20,null,null,null,null,"10:35:00",5]
[21,null,null,null,null,"10:40:00",5]
[22,null,null,null,null,"10:45:00",5]
[23,null,null,null,null,"10:50:00",5]
[24,null,null,null,null,"10:55:00",5]
[25,null,null,null,null,"11:00:00",5]
[26,null,null,null,null,"11:05:00",5]
[27,null,null,null,null,"11:10:00",5]
[28,null,null,null,null,"11:15:00",5]
[29,null,null,null,null,"11:20:00",5]
[30,null,null,null,null,"11:25:00",5]
[31,null,null,null,null,"11:30:00",5]
[32,null,null,null,null,"11:35:00",5]
[33,null,null,null,null,"11:40:00",5]
[34,null,null,null,null,"11:45:00",5]
[35,null,null,null,null,"11:50:00",5]
[36,null,null,null,null,"11:55:00",5]
[37,null,null,null,null,"12:00:00",5]
[38,null,null,null,null,"12:05:00",5]
[39,null,null,null,null,"12:10:00",5]
[40,null,null,null,null,"12:15:00",5]
[41,null,null,null,null,"12:20:00",5]
[42,null,null,null,null,"12:25:00",5]
[43,null,null,null,null,"12:30:00",5]
[44,null,null,null,null,"12:35:00",5]
[45,null,null,null,null,"12:40:00",5]
[46,null,null,null,null,"12:45:00",5]
[47,null,null,null,null,"12:50:00",5]
[48,null,null,null,null,"12:55:00",5]
[49,null,null,null,null,"13:00:00",5]
[50,null,null,null,null,"13:05:00",5]
[51,null,null,null,null,"13:10:00",5]
[52,null,null,null,null,"13:15:00",5]
[53,null,null,null,null,"13:20:00",5]
[54,null,null,null,null,"13:25:00",5]
[55,null,null,null,null,"13:30:00",5]
[56,null,null,null,null,"13:35:00",5]
[57,null,null,null,null,"13:40:00",5]
[58,null,null,null,null,"13:45:00",5]
[59,null,null,null,null,"13:50:00",5]
[60,null,null,null,null,"13:55:00",5]
[61,null,null,null,null,"14:00:00",5]
[62,null,null,null,null,"14:05:00",5]
[63,null,null,null,null,"14:10:00",5]
[64,null,null,null,null,"14:15:00",5]
[65,null,null,null,null,"14:20:00",5]
[66,null,null,null,null,"14:25:00",5]
[{"$f":"A71+1","v":67},null,null,null,null,"14:30:00",5]
[68,null,null,null,null,"14:35:00",5]

{"sheet":"Details","index":1,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[[12,2,12,4],[21,2,21,7],[22,2,22,7],[23,2,23,7],[16,2,16,4]]}
[null,{"$f":"\"ICD \" & B3 & \" \" & TEXT(B4,\"dd/mm/yyyy\")","v":"ICD  01/09/2024"}]
["Region:","Please select"]
["Venue:"]
["Date:","2024-09-01"]
[]
[]
[]
[]
[null,"You can fill in the cones details at the start or after P&P"]
[null,"Please convert to using the Scoring App - see",null," https://www.indoordriving.co.uk/organisers.php"]
[]
[null,{"$f":"B1 & \" Cones\"","v":"ICD  01/09/2024 Cones"}]
[null,null,"Pony and horse",null,null,null,null,null,null,null,null,"Cones"]
[null,"Class","m","Speed m/min","Time Allowed m:ss",null,null,null,null,null,null,1]
[null,"All",280,220,{"$f":"ROUND(C15/D15*60,0)/86400","v":"00:01:16"},null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Event format","Normal",null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,5]
[null,"How many decimal places",2,null,null,null,null,null,null,null,null,6]
[null,"for obstacles times?",null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Precision Judge",null,null,null,null,null,null,null,null,null,9]
[null,"Paces Judge",null,null,null,null,null,null,null,null,null,10]
[null,"Scorer"]
[]
[]
[]
[null,"Spreadsheet version:"]
[null,{"$f":"A35","v":"2023-12-28"}]
[null,"Mike Watts"]
["Latest:","www.indoordriving.co.uk/organisers.php"]
["Help:","mikew@innate.co.uk"]
[]
[null,"Recent changes"]
["2023-12-28","Updated Post to work to new https indoor website"]
["2022-10-13","Updated code sign certificate"]
["2022-09-01","Updated areas"]
["2021-05-08","Third event format - P&P, cones, WC"]
["2020-09-30","Option to set Event format to P&P + 2 world cup rounds"]
["2019-10-08","Untick 'Include Area' by default"]
["2019-04-12","Sign with new digital certificate 11-Apr-2019-2022 and timestamp so does not expire."]
["2018-09-10","More flexible date checking on event date"]
["2018-03-15","Auto setting implemented for live display."]
["2018-02-19","Allow date to Dec 2018. Fix download of final events of season."]
["2107-12-28","Add Dorset"]
["2017-10-22","South Scotland Region renamed. Penalties updated for 2017 rules. Fix ## for missing obs times."]
["2017-09-20","Option to get detail from internet."]
[null," Update date check to Apr 2017-June 2018, regions/venues, scorer, fixes"]
["2016-03-27","Optionally show Area. Output latest driver num for display"]
["2015-12-03","Fixes to 'Rearrange' in Drivers tab"]
["2015-11-18","Fix bug in Add late driver. Check champs class. Trim spare spaces in names."]
[null,"Update penalties to match ICD 2015 rules. Extra error checks"]
["2015-09-29","Add Champs class, picklists"]
["2015-04-03","New button Print12 = all to end obs 1 and 2"]
["2015-04-01","Staged output for Keysoe"]
["2015-03-15","Allow 0.5 in p&p"]
["2015-03-08","Fix to P&P form - ensure penalties saved"]
["2015-02-26","Uncorrected error of course included explictly in errors list"]
[null,"Improve display for Keysoe."]
["2015-01-11","Fix so E in marathon shows up in Total (bug - was blank)"]
["2014-11-21","Driver numbers easier to renumber on setup"]
[null,"New button to Add, Change Class or Delete drivers"]
[null,"Remove special symbols from driver names on post data. Handle '"]
[null,"Smart move on P&P form"]
["2014-10-02","Remove special chars from driver names on post."]
["2014-10-01","Include judges' names. Include p&p movement scores in posted results."]
[null,"Include ? button on forms to show penalties."]
["2014-04-01","Fix: ERWD form allows up to 300 drivers (was 100)"]
["2013-04-01","Fix cones rounding for people who enter whole seconds despite the instructions (col BO)"]
["2011-10-11","Bugfix "]
["2011-09-21","Show columns for obstacle penalties as well as times"]
["2011-09-13","Label shows when a screen is 'applied'."]
["2011-09-02","Update with changes from outdoor scoresheet"]
["2011-03-23","Increase max competitors from 134 to  ~ 300"]

{"sheet":"Master","index":2,"n_rows":4,"n_cols":87,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,61,2,66]]}
[{"$f":"Details!B1","v":"ICD  01/09/2024"}]
[]
[null,null,"Paces & Precision",null,null,"P&P",null,"Cones",null,null,null,"Total",null,"  Obstacles",null,null,null,null,null,null,null,"Total",null,"Notes","Elim/Ret/Wd",null,null,"Cones - details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cones",null,null,null,null,null,null,"Obstacle pens",null,null,null,"Obstacle KD",null,null,null,"Obstacle times secs",null,null,null,"Obstacle Notes"]
["#","Name","Prec ision","Paces","Pen","P&P Total","Pl","Time faults","Driving","Cones Total","Pl","Total","Pl","Obs1 secs","Obs2 secs","Obs 1&2 pens","Total after 1&2","Place","Obs3 secs","Obs4 secs","Obs 3&4 pens","TOTAL","Place Final","Notes","P&P","Cones","Marathon",1,2,3,4,5,6,7,8,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other pens","Driving pens","Time","Time allowed","Time pens","Time under if clear",1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,"Local Class","Champs Class","Area"]

{"sheet":"Dressage","index":3,"n_rows":4,"n_cols":29,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Driver num","Other pens",null,1,2,3,4,5,6,7,8,9,10,"Total","Pens",null,null,1,2,3,4,5,6,7,8,9,10,"Total","Pens"]

{"sheet":"RunOrder1","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Details!B1","v":"ICD  01/09/2024"}]
[null,"Running Order 1"]

{"sheet":"RunOrder2","index":5,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Details!B1","v":"ICD  01/09/2024"}]
[null,"Running Order 2"]
[]
["#","Name","Total WC","Place",null,"Local Class","Champs Class"]
[null,"Open Pony"]
[2,"bbbbb","","",null,"Open Pony","Open Pony"]
[1,"aaa",44.55,1,null,"Open Pony","Open Pony"]

{"sheet":"Printing","index":6,"n_rows":7,"n_cols":86,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Details!B1","v":"ICD  01/09/2024"}]
[]
[null,null,"Paces & Precision",null,null,"P&P",null,"Cones",null,null,null,"Total",null,"WC",null,null,null,null,null,null,null,"Total",null,"Notes"]
["#","Name","Prec ision","Paces","Pen","P&P Total","Pl","Time faults","Driving","Cones Total","Pl","Total","Pl","secs","Obs2 secs","pens","Total WC","Place","Obs3 secs","Obs4 secs","Obs 3&4 pens","TOTAL","Place Final","Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Class","Champs Class"]
[null,"Open Pony"]
[1,"aaa",null,null,null,"","","","","","","","","","",0,"","","","",0,"","","   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Pony","Open Pony"]
[2,"bbbbb",null,null,null,"","","","","","","","","","",0,"","","","",0,"","","   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Pony","Open Pony"]

{"sheet":"Master_Template0","index":7,"n_rows":6,"n_cols":87,"rows_kept":6,"cut":false,"hidden":true,"merged":[[2,61,2,66]]}
[{"$f":"Details!B1","v":"ICD  01/09/2024"}]
[]
[null,null,"Paces & Precision",null,null,"P&P",null,"Cones",null,null,null,"Total",null,"  Obstacles",null,null,null,null,null,null,null,"Total",null,"Notes","Elim/Ret/Wd",null,null,"Cones - details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cones",null,null,null,null,null,null,"Obstacle pens",null,null,null,"Obstacle KD",null,null,null,"Obstacle times secs",null,null,null,"Obstacle Notes"]
["#","Name","Prec ision","Paces","Pen","P&P Total","Pl","Time faults","Driving","Cones Total","Pl","Total","Pl","Obs1 secs","Obs2 secs","Obs 1&2 pens","Total after 1&2","Place","Obs3 secs","Obs4 secs","Obs 3&4 pens","TOTAL","Place Final","Notes","P&P","Cones","Marathon",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cones down","Other pens","Driving pens","Time","Time allowed","Time pens","Time under if clear",1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,"Local Class","Champs Class","Area"]
[null,"Open Pony"]
[null,null,null,null,null,{"$f":"IF(Y6<>\"\",Y6,IF(C6=\"\",\"\",C6+D6+E6))","v":""},"P",{"$f":"BO6","v":""},{"$f":"BL6","v":""},{"$f":"IF(Z6<>\"\",Z6,IF(H6=\"\",\"\",VALUE(SUBSTITUTE(H6,\"-\",\"\"))+I6))","v":""},"P",{"$f":"IF(Y6<>\"\",Y6,IF(Z6<>\"\",Z6,IF(J6=\"\",\"\",IF(F6=\"\",\"\",F6+J6))))","v":""},"P",{"$f":"IF(BY6=\"\",\"\",ROUND(BY6,2))","v":""},{"$f":"IF(BZ6=\"\",\"\",ROUND(BZ6,2))","v":""},{"$f":"BQ6+BR6 + 5 * (BU6+BV6)","v":0},{"$f":"IF(Y6<>\"\",Y6,IF(Z6<>\"\",Z6,IF(AA6<>\"\",\"\",IF(N6=\"\",\"\",IF(L6=\"\",\"\",IF(O6=\"\",\"\",L6+N6+O6 +P6))))))","v":""},"P",{"$f":"IF(CA6=\"\",\"\",ROUND(CA6,2))","v":""},{"$f":"IF(CB6=\"\",\"\",ROUND(CB6,2))","v":""},{"$f":"BS6+BT6 + 5 * (BW6+BX6)","v":0},{"$f":"IF(Y6<>\"\",Y6,IF(Z6<>\"\",Z6,IF(AA6<>\"\",AA6,IF(L6=\"\",\"\",IF(Q6=\"\",\"\",IF(S6=\"\",\"\",IF(T6=\"\",\"\",Q6+S6+T6 +U6)))))))","v":""},"P",{"$f":"CC6 & \" \" & CD6 & \" \" & CE6 & \" \" & CF6","v":"   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BM6=\"\",\"\",SUM(AB6:BI6))","v":""},null,{"$f":"IF(BM6=\"\",\"\",BJ6*5+BK6)","v":""},null,{"$f":"Details!$E$15","v":"00:01:16"},{"$f":"IF(BM6=\"\",\"\",IF(BM6-BN6>=0,ROUNDUP((BM6+0.00000001 -BN6)*86400,0),ROUNDDOWN((BN6 - BM6-0.00000001)*86400,0)) & IF((BN6 - BM6)*86400 >1,\"-\",\"\") )","v":""},{"$f":"IF(BM6=\"\",\"\",IF(BL6>0,\"\",IF(BN6-BM6>=0,(BN6-BM6)*86400,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Pony"]

{"sheet":"PPPenalties","index":8,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["P & P penalties - description","Penalties","Ref"]
["Part of the turnout leaving the arena during a movement","Mark down for inaccuracy"]
["The whole turnout leaving the arena","Elimination"]
["Driver dismounting","20 penalties","943.2.10 & Annex 98"]
["Driving without a whip in the arena","5 penalties",8.16]
["Dropping or putting down the whip.","5 penalties",8.16]
["No breeching","Elimination",6.3]
["Use of bandage or brushing boots is allowed","0 penalties","940.1.2.1"]
["Contravening the Rules on Advertising","Yellow Warning Card",941]
["Person tied to the carriage","Elimination","943.2.6"]
["If a Groom handles the reins, brake or uses the whip","20 penalties",943.2]
["Groom or passengers giving assistance, including verbal or physical directions.","20 penalties","2.4.14"]
["Physical outside assistance","Elimination",945.1]
["Groom(s) dismounting - First incident","5 penalties","945.2 943.2.11 & Annex 98"]
["Groom(s) dismounting - Second incident","10 penalties"]
["Groom(s) dismounting - Third incident","Elimination"]
["Early or late entry","Possible Elimination",952.1]
["Lame horse","Disqualification of Horse and elimination of Driver",952.3]
["Error of course: Each occasion","5 penalties","ICD"]
["Disobedience: First incident","5 penalties",956.5]
["Disobedience: Second incident","10 penalties"]
["Disobedience: Third incident","Elimination"]
["Carriage overturn","Elimination",956.6]

{"sheet":"ConesPenalties","index":9,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Cones Penalties Description","Penalties","Ref"]
["Driver  on carriage without properly secured safety hat.","Elimination","2.4.11"]
["Groom on carriage without properly secured safety hat.","Elimination","2.4.11"]
["Driving without a whip in the arena","5 penalties",8.16]
["Dropping or putting down the whip.","5 penalties",8.16]
["No breeching","Elimination",6.3]
["If a Groom handles the reins, brake or uses the whip before the Athlete has crossed the finish line.","20 penalties","943.2.5"]
["Person tied to the carriage","Elimination","943.2.6"]
["Groom or passengers sliding, lifting or moving the vehicle in any way.","20 penalties","2.4.14"]
["Illegal outside assistance.","Elimination",945.2]
["Failing to start within 45 seconds of bell ring.","Timing starts","975.1-2"]
["Starting and passing through an obstacle before the bell is rung.","10 penalties and restart.",975.2]
["Failing to pass through start or finish lines.","Elimination",975.2]
["For knocking down one or more balls in the same single obstacle or Oxer.","5 penalties",8.15]
["For knocking down an element of a Multiple obstacle.","5 penalties",8.15]
["For knocking down any part of an obstacle after it has already been driven.","5 penalties",8.1199999999999992]
["Carriage overturn","Elimination","975.2.1"]
["If any part of an obstacle in advance of the one being driven is knocked down.","5 penalties"," "]
["Taking an obstacle out of sequence (corrected).","Elimination","8.10"]
["Taking an obstacle out of sequence (un corrected).","Elimination","8.10"]
["For causing an obstacle, or part of a multiple to be rebuilt.","5 penalties"]
["Athlete dismounting","20 penalties","975.6.1"]
["Groom(s) dismounting - First incident","5 penalties",975.6]
["Groom(s) dismounting - Second incident","10 penalties"]
["Groom(s) dismounting - Third incident","Elimination"]
["Groom leading a Horse through an obstacle.","25 penalties","975.6.3"]
["Disobedience ","0 penalties","8.17"]
["Under or over the Target Time ","1 penalty per commenced second",8.15]
["Using stopwatch or other timer","Elimination","8.14"]
["Exceeding the Time Limit.","Elimination","975.9.3"]

{"sheet":"ObsPenalties","index":10,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Obstacle Penalties Definition","Penalties","Ref"]
["Groom leading a Horse through an obstacle.","25 penalties",945.3]
["Each correction of error of Course in an obstacle.","20 penalties",965.2]
["Uncorrected error of course","Elimination",965.2]
["Groom(s) dismounting in an obstacle, each occasion.","5 penalties",9.11]
["Dislodging a dislodgeable Element","5 penalties per occurrence",9.11]
["No or unsecured protective headgear","Elimination","2.4.11"]
["No breeching","Elimination",6.3]
["Groom handling reins, whip and breaks when carriage not stationary.","20 penalties","943.1 & 943.2"]
["Person tied to the carriage","Elimination","943.2.6"]
["Outside Assistance.","Elimination",945]
["Preventing a dislodgeable element from being dislodged","10 penalties","961.5.7"]
["Total time in obstacles.","1 penalties/ sec.",963.2]
["Athlete fails to stop when recalled","Elimination","963.4.3"]
["Contravening the rule on the use of the whip","20 penalites",964.1]
["Failing to pass through entry flags of an Obstacle.","Elimination",965.2]
["Failing to pass through exit flags of an obstacle within 5 minutes.","Elimination","965.7.3"]
["Passing between exit flags before completing an Obstacle.","Elimination",965.2]
["Athlete dismounting in an obstacle.","20 penalties",965.3]
["Two feet on an Element of obstacle.","10 penalties",965.3]
["Groom climbing over horse back or down the pole in an obstacle","20 penalties",965.3]
["Disconnecting and leading through an Obstacle.","Elimination",965.4]
["Failing to stop for leg over pole, lead bar or shaft.","Elimination",965.6]
["Failing to stop for leg over trace.","30 penalties",965.6]
["Carriage overturn","Elimination","964.7.4"]
["Exceeding the time limit in obstacles (5 mins)","Elimination","965.7.3"]

{"sheet":"Data","index":11,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Class","Champ Class","Regions","Venue 1","Venue 2",null,"Formats"]
[null,"Club","Please select",null,null,null,"Normal"]
["Club","Novice Pony","Test","Test EC",null,null,"P&P and 2xWorldcup"]
["Novice Pony","Intermediate Pony","Bedfordshire","Abbey Farm","Dellfield Farm",null,"P&P Cones WC"]
["Open Pony","Open Pony","Devon and Cornwall","Duchy College"]
["Novice Horse","Novice Horse","South Dorset","Kingston Maurward"]
["Open Horse","Intermediate Horse","Dorset"]
["Junior","Open Horse","East Anglia","Wix","Beechwood"]
["Multiples (Combined)","Novice Junior","Kent","Duckhurst"]
[null,"Novice Small Pony","Lincs and Leicestershire","Newbold Verdon","Saddlesdane"]
[null,"Intermediate Small Pony","Mid Wales","Fedw"]
[null,"Open Small Pony","Midlands","Moreton Morrell","Llwynon Saddlery"]
[null,"Small Pony Pair","Norfolk","Easton College"]
[null,"Pony Pair","North Scotland","Ardmedden","WHW Hall Farm"]
[null,"Pony Tandem","North West","Reaseheath","Fountain EC"]
[null,"Pony Team","North Yorks","Askham Bryan"]
[null,"Horse Pair","Notts and South Yorks","Tickhill"]
[null,"Horse Tandem","South","Merrist Wood"]
[null,"Horse Team","South Wales","Pencoed College"]
[null,"Veteran","South West","Stretcholt","South Wales Carriage Driving Centre"]
[null,null,"Sussex","Plumpton"]
[null,null,"Thames Valley","Berkshire College","Priory Court Farm"]
[null,null,"Wales and Gloucester","David Broome Event Centre"]
[null,null,"Wessex","Sparsholt"]
[null,null,"West Norfolk","Forest Edge"]
[null,null,"Championships","Arena UK"]

{"sheet":"Master_Template1","index":12,"n_rows":6,"n_cols":87,"rows_kept":6,"cut":false,"hidden":true,"merged":[[2,61,2,66]]}
[{"$f":"Details!B1","v":"ICD  01/09/2024"}]
[]
[null,null,"Paces & Precision",null,null,"P&P",null,"Cones",null,null,null,"Total",null,"  Obstacles cones",null,null,null,null,null,null,null,"Total",null,"Notes","Elim/Ret/Wd",null,null,"Cones - details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cones",null,null,null,null,null,null,"Obstacle pens",null,null,null,"Obstacle KD",null,null,null,"Obstacle times secs",null,null,null,"Obstacle Notes"]
["#","Name","Prec ision","Paces","Pen","P&P Total","Pl","Time faults","Driving","Cones Total","Pl","Total","Pl","Round1 secs","Obs2 secs","Rnd1 pens","Total 1","Place","Round2 secs","Obs4 secs","Rnd2 pens","TOTAL","Place Final","Notes","P&P","Cones","Rounds",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cones down","Other pens","Driving pens","Time","Time allowed","Time pens","Time under if clear",1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,"Local Class","Champs Class","Area"]
[null,"Open Pony"]
[null,null,null,null,null,{"$f":"IF(Y6<>\"\",Y6,IF(C6=\"\",\"\",C6+D6+E6))","v":""},"P",{"$f":"BO6","v":""},{"$f":"BL6","v":""},0,"P",{"$f":"IF(Y6<>\"\",Y6,IF(Z6<>\"\",Z6,IF(J6=\"\",\"\",IF(F6=\"\",\"\",F6+J6))))","v":""},"P",{"$f":"IF(BY6=\"\",\"\",ROUND(BY6,2))","v":""},{"$f":"IF(BZ6=\"\",\"\",ROUND(BZ6,2))","v":0},{"$f":"BQ6+BR6 + 5 * (BU6+BV6)","v":0},{"$f":"IF(Y6<>\"\",Y6,IF(Z6<>\"\",Z6,IF(AA6<>\"\",\"\",IF(N6=\"\",\"\",IF(L6=\"\",\"\",IF(O6=\"\",\"\",L6+N6+O6 +P6))))))","v":""},"P",{"$f":"IF(CA6=\"\",\"\",ROUND(CA6,2))","v":""},{"$f":"IF(CB6=\"\",\"\",ROUND(CB6,2))","v":0},{"$f":"BS6+BT6 + 5 * (BW6+BX6)","v":0},{"$f":"IF(Y6<>\"\",Y6,IF(Z6<>\"\",Z6,IF(AA6<>\"\",AA6,IF(L6=\"\",\"\",IF(Q6=\"\",\"\",IF(S6=\"\",\"\",IF(T6=\"\",\"\",Q6+S6+T6 +U6)))))))","v":""},"P",{"$f":"CC6 & \" \" & CD6 & \" \" & CE6 & \" \" & CF6","v":"   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BM6=\"\",\"\",SUM(AB6:BI6))","v":""},null,{"$f":"IF(BM6=\"\",\"\",BJ6*5+BK6)","v":""},null,{"$f":"Details!$E$15","v":"00:01:16"},{"$f":"IF(BM6=\"\",\"\",IF(BM6-BN6>=0,ROUNDUP((BM6+0.00000001 -BN6)*86400,0),ROUNDDOWN((BN6 - BM6-0.00000001)*86400,0)) & IF((BN6 - BM6)*86400 >1,\"-\",\"\") )","v":""},{"$f":"IF(BM6=\"\",\"\",IF(BL6>0,\"\",IF(BN6-BM6>=0,(BN6-BM6)*86400,\"\")))","v":""},null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,"Open Pony"]

{"sheet":"League","index":13,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Details!B1","v":"ICD  01/09/2024"}]
["Points league"]
["Points league for Total best 5 results"]
[]
["PCH=Previous champion"]

{"sheet":"Master_Template2","index":14,"n_rows":6,"n_cols":87,"rows_kept":6,"cut":false,"hidden":true,"merged":[[2,61,2,66]]}
[{"$f":"Details!B1","v":"ICD  01/09/2024"}]
[]
[null,null,"Paces & Precision",null,null,"P&P",null,"Cones",null,null,null,"Total",null,"WC",null,null,null,null,null,null,null,"Total",null,"Notes","Elim/Ret/Wd",null,null,"Cones - details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cones",null,null,null,null,null,null,"Obstacle pens",null,null,null,"Obstacle KD",null,null,null,"Obstacle times secs",null,null,null,"Obstacle Notes"]
["#","Name","Prec ision","Paces","Pen","P&P Total","Pl","Time faults","Driving","Cones Total","Pl","Total","Pl","secs","Obs2 secs","pens","Total WC","Place","Obs3 secs","Obs4 secs","Obs 3&4 pens","TOTAL","Place Final","Notes","P&P","Cones","Marathon",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cones down","Other pens","Driving pens","Time","Time allowed","Time pens","Time under if clear",1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,"Local Class","Champs Class","Area"]
[null,"Open Pony"]
[null,null,null,null,null,{"$f":"IF(Y6<>\"\",Y6,IF(C6=\"\",\"\",C6+D6+E6))","v":""},"P",{"$f":"BO6","v":""},{"$f":"BL6","v":""},{"$f":"IF(Z6<>\"\",Z6,IF(H6=\"\",\"\",VALUE(SUBSTITUTE(H6,\"-\",\"\"))+I6))","v":""},"P",{"$f":"IF(Y6<>\"\",Y6,IF(Z6<>\"\",Z6,IF(J6=\"\",\"\",IF(F6=\"\",\"\",F6+J6))))","v":""},"P",{"$f":"IF(BY6=\"\",\"\",ROUND(BY6,2))","v":""},{"$f":"IF(BZ6=\"\",\"\",ROUND(BZ6,2))","v":""},{"$f":"BQ6+BR6 + 5 * (BU6+BV6)","v":0},{"$f":"IF(AA6<>\"\",\"\",IF(N6=\"\",\"\",N6+P6))","v":""},"P",{"$f":"IF(CA6=\"\",\"\",ROUND(CA6,2))","v":""},{"$f":"IF(CB6=\"\",\"\",ROUND(CB6,2))","v":""},{"$f":"BS6+BT6 + 5 * (BW6+BX6)","v":0},{"$f":"IF(Y6<>\"\",Y6,IF(Z6<>\"\",Z6,IF(AA6<>\"\",AA6,IF(L6=\"\",\"\",IF(Q6=\"\",\"\",Q6+L6)))))","v":""},"P",{"$f":"CC6 & \" \" & CD6 & \" \" & CE6 & \" \" & CF6","v":"   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BM6=\"\",\"\",SUM(AB6:BI6))","v":""},null,{"$f":"IF(BM6=\"\",\"\",BJ6*5+BK6)","v":""},null,{"$f":"Details!$E$15","v":"00:01:16"},{"$f":"IF(BM6=\"\",\"\",IF(BM6-BN6>=0,ROUNDUP((BM6+0.00000001 -BN6)*86400,0),ROUNDDOWN((BN6 - BM6-0.00000001)*86400,0)) & IF((BN6 - BM6)*86400 >1,\"-\",\"\") )","v":""},{"$f":"IF(BM6=\"\",\"\",IF(BL6>0,\"\",IF(BN6-BM6>=0,(BN6-BM6)*86400,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Pony"]