{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Readme","Main Sheet","Calculations"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":15,"comments":1,"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":"Readme","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,1,2,10]]}
[12]
[]
[null,"Vaulting Freestyle Calculator"]

{"sheet":"Main Sheet","index":1,"n_rows":109,"n_cols":27,"rows_kept":109,"cut":false,"hidden":false,"merged":[[14,11,15,11],[9,0,9,2],[13,0,13,11],[14,0,16,0],[4,4,4,6],[14,4,15,4],[14,6,15,6],[14,8,15,8],[8,0,8,11],[14,10,15,10],[28,0,28,13],[25,0,25,11],[19,0,19,11],[27,0,27,10],[26,0,26,10],[22,0,22,11],[23,0,24,10],[20,0,21,4],[9,4,9,8],[4,10,6,10],[4,11,6,11],[9,11,11,11],[9,10,11,10],[2,12,2,13],[0,0,0,11],[3,0,3,11],[4,0,4,2],[2,0,2,11],[1,0,1,11]]}
["Vaulting Freestyle Calculator"]
["PERFORMANCE RECORD"]
[]
["Horse"]
["Quality",null,null,null,"Vault-ability",null,null,null,"General",null,"Penalties","Score"]
["Pace",null,"Impulsion",null,"Submission",null,"Lunging",null,"Salute/ GI"]
[{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,12,FALSE),\"\")","v":0.3},null,{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,13,FALSE),\"\")","v":0.25},null,{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,14,FALSE),\"\")","v":0.25},null,{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,15,FALSE),\"\")","v":0.15},null,{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,16,FALSE),\"\")","v":0.05}]
[null,{"$f":"A8*VLOOKUP(Readme!$A$1,Calculations!B:Q,12,FALSE)","v":0},null,{"$f":"C8*VLOOKUP(Readme!$A$1,Calculations!B:Q,13,FALSE)","v":0},null,{"$f":"E8*VLOOKUP(Readme!$A$1,Calculations!B:Q,14,FALSE)","v":0},null,{"$f":"G8*VLOOKUP(Readme!$A$1,Calculations!B:Q,15,FALSE)","v":0},null,{"$f":"I8*VLOOKUP(Readme!$A$1,Calculations!B:Q,16,FALSE)","v":0},null,{"$f":"IFERROR(IF((SUM(B8,D8,F8,H8,J8)-K8)=0,\"\",(SUM(B8,D8,F8,H8,J8)-K8)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Artistic"]
["Structure",null,null,null,"Choreography",null,null,null,null,null,"Penalties","Score"]
["Variety of Exercises",null,"Variety of Position",null,"Unity of Composition",null,"Music Interpretation",null,"Creativity and Originality"]
[{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,7,FALSE),\"\")","v":0.3},null,{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,8,FALSE),\"\")","v":0.2},null,{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,9,FALSE),\"\")","v":0.2},null,{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,10,FALSE),\"\")","v":0.2},null,{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:V,11,FALSE),\"\")","v":0.1}]
[null,{"$f":"A13*VLOOKUP(Readme!$A$1,Calculations!B:Q,7,FALSE)","v":0},null,{"$f":"C13*VLOOKUP(Readme!$A$1,Calculations!$B:Q,8,FALSE)","v":0},null,{"$f":"E13*VLOOKUP(Readme!$A$1,Calculations!$B:$Q,9,FALSE)","v":0},null,{"$f":"G13*VLOOKUP(Readme!$A$1,Calculations!$B:$Q,10,FALSE)","v":0},null,{"$f":"I13*VLOOKUP(Readme!$A$1,Calculations!$B:$Q,11,FALSE)","v":0},null,{"$f":"IFERROR(IF((SUM(B13,D13,F13,H13,J13)-K13)=0,\"\",(SUM(B13,D13,F13,H13,J13)-K13)),\"\")","v":""}]
["Degree Of Difficulty"]
[null,null,"Counted Exercises:",null,"R",null,"D",null,"M",null,"E","Score"]
[null,null,{"$f":"IFERROR(VLOOKUP(Readme!A1,Calculations!B:G,2,FALSE),\"\")","v":0}]
[null,null,"Actual Exercises",null,{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"R\",\"\")))","v":""},null,{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"D\",\"\")))","v":""},null,{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"M\",\"\")))","v":""},null,{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"E\",\"\")))","v":""},{"$f":"IFERROR(IF(L19=0,0,IF(L19>10,\"10\",L19)),\"\")","v":""}]
[null,null,"Counted Exercises",null,{"$f":"E17","v":""},null,{"$f":"IF(Rcnt<C16,IF((C16-Rcnt)<Dex,(C16-Rcnt),Dex),0)","v":0},null,{"$f":"IF((Rcnt+Dcnt)<Countedex,IF((Countedex-(Rcnt+Dcnt))<Mex,(Countedex-(Rcnt+Dcnt)),Mex),0)","v":{"$error":"#VALUE!"}},null,{"$f":"IF((Rcnt+Dcnt+Mcnt)<Countedex,IF((Countedex-(Rcnt+Dcnt+Mcnt))<Eex,(Countedex-(Rcnt+Dcnt+Mcnt)),Eex),0)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E18:K18)","v":{"$error":"#VALUE!"}}]
[null,null,"Score",null,{"$f":"E18*(VLOOKUP(Readme!A1,Calculations!B:G,3,FALSE))","v":{"$error":"#VALUE!"}},null,{"$f":"G18*VLOOKUP(Readme!A1,Calculations!B:G,4,FALSE)","v":0},null,{"$f":"I18*VLOOKUP(Readme!A1,Calculations!B:G,5,FALSE)","v":{"$error":"#VALUE!"}},null,{"$f":"K18*VLOOKUP(Readme!A1,Calculations!B:G,6,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E19,G19,I19,K19)","v":{"$error":"#VALUE!"}}]
["Performance"]
[null,null,null,null,null,null,"Exercises",null,"Deductions",null,"Falls","Score"]
[null,null,null,null,null,null,{"$f":"IF(SUM(Rex,Dex,Mex,Eex)=0,IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"X\",\"\"))),SUM(Rex,Dex,Mex,Eex))","v":""},null,{"$f":"IF(A3=\"\",\"\",SUM((((LEN(A3)-LEN(SUBSTITUTE(A3,\" 1\",\"\")))/2)*1)+(((LEN(A3)-LEN(SUBSTITUTE(A3,\" 2\",\"\")))/2)*2)+(((LEN(A3)-LEN(SUBSTITUTE(A3,\" 3\",\"\")))/2)*3)+(((LEN(A3)-LEN(SUBSTITUTE(A3,\" 4\",\"\")))/2)*4)+(((LEN(A3)-LEN(SUBSTITUTE(A3,\" 5\",\"\")))/2)*5)+(((LEN(A3)-LEN(SUBSTITUTE(A3,\" 6\",\"\")))/2)*6)+(((LEN(A3)-LEN(SUBSTITUTE(A3,\" 7\",\"\")))/2)*7)+(((LEN(A3)-LEN(SUBSTITUTE(A3,\" 8\",\"\")))/2)*8)+(((LEN(A3)-LEN(SUBSTITUTE(A3,\" 9\",\"\")))/2)*9)))","v":""},null,{"$f":"IF(I38>10,10,IF(I38=0,\"\",I38))","v":""},{"$f":"IF(I22=\"\",\"\",(IFERROR((10-(I22/G22))-IF(K22=\"\",0, K22),0)))","v":""}]
["Technique (Combined DOD & Performance)"]
[null,null,null,null,null,null,null,null,null,null,null,"Score"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((DOD*VLOOKUP(Class,Calculations!B:AC,17,FALSE))+(Performance*VLOOKUP(Class,Calculations!B:AC,18,FALSE)),\"\")","v":""}]
["Final"]
["Comments",null,null,null,null,null,null,null,null,null,null,"Final Score"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Class,Calculations!B:AD,29,FALSE),\"\")","v":"No Score"}]
[]
[2]
[]
[]
[]
["Fall Type","F1A","F1B","F2A","F2B","F3","F4","F5"]
["Char Count",{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"F1A\",\"\")))","v":""},{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"F1B\",\"\")))","v":""},{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"F2A\",\"\")))","v":""},{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"F2B\",\"\")))","v":""},{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"F3\",\"\")))","v":""},{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"F4\",\"\")))","v":""},{"$f":"IF(A3=\"\",\"\",LEN(A3)-LEN(SUBSTITUTE(A3,\"F5\",\"\")))","v":""}]
["Fall Count",{"$f":"B35/3","v":{"$error":"#VALUE!"}},{"$f":"C35/3","v":{"$error":"#VALUE!"}},{"$f":"D35/3","v":{"$error":"#VALUE!"}},{"$f":"E35/3","v":{"$error":"#VALUE!"}},{"$f":"F35/2","v":{"$error":"#VALUE!"}},{"$f":"G35/2","v":{"$error":"#VALUE!"}},{"$f":"H35/2","v":{"$error":"#VALUE!"}}]
["Penalty Value",{"$f":"VLOOKUP(Readme!$A$1,Calculations!$B:$AC,22,FALSE)","v":5},{"$f":"VLOOKUP(Readme!$A$1,Calculations!$B:$AC,23,FALSE)","v":"-"},{"$f":"VLOOKUP(Readme!$A$1,Calculations!$B:$AC,24,FALSE)","v":3},{"$f":"VLOOKUP(Readme!$A$1,Calculations!$B:$AC,25,FALSE)","v":"-"},{"$f":"VLOOKUP(Readme!$A$1,Calculations!$B:$AC,26,FALSE)","v":2},{"$f":"VLOOKUP(Readme!$A$1,Calculations!$B:$AC,27,FALSE)","v":2},{"$f":"VLOOKUP(Readme!$A$1,Calculations!$B:$AC,28,FALSE)","v":1},"Total Penalty"]
["Penalty Deduction",{"$f":"IFERROR(B36*B37,0)","v":0},0,0,0,0,0,0,{"$f":"SUM(B38:H38)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Horse"]
["Artisic"]
["Degree of Difficulty"]
["Performance"]

{"sheet":"Calculations","index":2,"n_rows":31,"n_cols":30,"rows_kept":31,"cut":false,"hidden":false,"merged":[[22,4,22,7],[29,1,29,3],[30,1,30,3],[22,1,23,3],[22,0,23,0],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3]]}
["Select a Class",null,"Count","R","D","M","E","C1","C2","C3","C4","C5","H1","H2","H3","H4","H5","Diff","Perf","Technique","Art","Horse","F1A","F1B","F2A","F2B","F3","F4","F5","Score*"]
["Individual (DOD)",2,10,1.3,0.9,0.4,0,0.25,0.25,0.2,0.2,0.1,0.3,0.25,0.25,0.15,0.05,0.3,0.7,0.5,0.25,0.25,2,"-",1,"-",0.6,0.6,0.4,{"$f":"(Athletic*Calculations!T2)+(Artistic*Calculations!U2)+IF(Horse=\"\",0,(Horse*Calculations!V2))","v":{"$error":"#VALUE!"}}]
["Individual (No DOD)",3,10,0,0,0,0,0.25,0.25,0.2,0.2,0.1,0.3,0.25,0.25,0.15,0.05,0,1,0.5,0.25,0.25,2,"-",1,"-",0.6,0.6,0.4,{"$f":"(Athletic*Calculations!T3)+(Artistic*Calculations!U3)+IF(Horse=\"\",0,(Horse*Calculations!V3))","v":{"$error":"#VALUE!"}}]
["Individual (Walk)",4,10,1.3,0.9,0.4,0,0.25,0.25,0.2,0.2,0.1,0.1,0.1,0.3,0.3,0.2,0,1,0.65,0.25,0.1,2,"-",1,"-",0.6,0.6,0.4,{"$f":"(Athletic*Calculations!T4)+(Artistic*Calculations!U4)+IF(Horse=\"\",0,(Horse*Calculations!V4))","v":{"$error":"#VALUE!"}}]
["PDD (DOD)",5,13,0,0.8,0.4,0,0.25,0.25,0.2,0.2,0.1,0.3,0.25,0.25,0.15," ",0.3,0.7,0.5,0.25,0.25,2,1,1,0.6,0.6,0.6,0.4,{"$f":"(Athletic*Calculations!T5)+(Artistic*Calculations!U5)+IF(Horse=\"\",0,(Horse*Calculations!V5))","v":{"$error":"#VALUE!"}}]
["PDD (no DOD)",6,13,0,0,0,0,0.25,0.25,0.2,0.2,0.1,0.3,0.25,0.25,0.15,0.05,0,1,0.5,0.25,0.25,2,1,1,0.6,0.6,0.6,0.4,{"$f":"(Athletic*Calculations!T6)+(Artistic*Calculations!U6)+IF(Horse=\"\",0,(Horse*Calculations!V6))","v":{"$error":"#VALUE!"}}]
["PDD (Walk)",7,13,0,0,0,0,0.25,0.25,0.2,0.2,0.1,0.1,0.1,0.3,0.3,0.2,0,1,0.65,0.25,0.1,2,1,1,0.6,0.6,0.6,0.4,{"$f":"(Athletic*Calculations!T7)+(Artistic*Calculations!U7)+IF(Horse=\"\",0,(Horse*Calculations!V7))","v":{"$error":"#VALUE!"}}]
["Squad **",8,25,0,0.4,0.3,0.1,0.25,0.25,0.2,0.2,0.1,0.3,0.25,0.25,0.15,0.05,0.3,0.7,0.5,0.25,0.25,2,1,1,0.4,0.4,0.4,0.1,{"$f":"(Athletic*Calculations!T8)+(Artistic*Calculations!U8)+IF(Horse=\"\",0,(Horse*Calculations!V8))","v":{"$error":"#VALUE!"}}]
["Squad *",9,20,0,0.5,0.3,0.1,0.25,0.25,0.2,0.2,0.1,0.3,0.25,0.25,0.15,0.05,0.3,0.7,0.5,0.25,0.25,2,1,1,0.4,0.4,0.4,0.1,{"$f":"(Athletic*Calculations!T9)+(Artistic*Calculations!U9)+IF(Horse=\"\",0,(Horse*Calculations!V9))","v":{"$error":"#VALUE!"}}]
["Squad (no DOD)",10,20,0,0,0,0,0.25,0.25,0.2,0.2,0.1,0.3,0.25,0.25,0.15,0.05,0,1,0.5,0.25,0.25,2,1,1,0.4,0.4,0.4,0.1,{"$f":"(Athletic*Calculations!T10)+(Artistic*Calculations!U10)+IF(Horse=\"\",0,(Horse*Calculations!V10))","v":{"$error":"#VALUE!"}}]
["Squad (Walk)",11,20,0,0,0,0,0.25,0.25,0.2,0.2,0.1,0.1,0.1,0.3,0.3,0.2,0,1,0.5,0.25,0.25,2,1,1,0.4,0.4,0.4,0.1,{"$f":"(Athletic*Calculations!T11)+(Artistic*Calculations!U11)+IF(Horse=\"\",0,(Horse*Calculations!V11))","v":{"$error":"#VALUE!"}}]
["Tech Test",12,0,0,0,0,0,0.3,0.2,0.2,0.2,0.1,0.3,0.25,0.25,0.15,0.05,0,1,"NA",0.25,0.25,5,"-",3,"-",2,2,1,"No Score"]
[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,"* Do Not use this column to record a score as the values change depending on the sum of difficulty and performance to calculate the athletic score."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Category","Description",null,null,"Penalty"]
[null,null,null,null,"Individual","PDD","Squad","Tech Test"]
["F1A","ALL Fall from horse - Not on feet",null,null,2,2,2,5]
["F1B","Some Fall from horse - Not on feet",null,null,"-",1,1,"-"]
["F2A","ALL fall from horse - on Feet",null,null,1,1,1,3]
["F2B","SOME fall from horse - On feet",null,null,"-",0.6,0.4,"-"]
["F3","Fall but still contacting horse",null,null,0.6,0.6,0.4,2]
["F4","Double touch in Ground Jump",null,null,0.6,0.6,0.4,2]
["F5","Dismount not on feet",null,null,0.4,0.4,0.1,1]