{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Stammdaten","Mannschaften","Rangliste","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"Stammdaten","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,1,3,3],[6,1,6,3]]}
["Stammdaten"]
[]
[]
[null,"OKV Mannschaftsdressurfinal 2018"]
[null,"Veranstaltungstitel 1"]
[]
[null,"Werdenberg"]
[null,"Veranstaltungstitel 1"]
[]
[]
[]
["Richterdaten"]
[]
[null,"Richter H / Reiter 1",null,"Richter 1"]
[null,"Titel 1",null,"Name 1"]
[]
[null,"Richter C / Reiter 2",null,"Richter 2"]
[null,"Titel 2",null,"Name 2"]
[]
[null,"Richter M / Reiter 3",null,"Richter 3"]
[null,"Titel 3",null,"Name 3"]
[]
[null,"Richter E / Gesamteindr.",null,"Richter 4"]
[null,"Titel 4",null,"Name 4"]
[]
[null,"Richter B / Gesamteindr.",null,"Richter 5"]
[null,"Titel 5",null,"Name 5"]

{"sheet":"Mannschaften","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Mannschaften"]
[]
[null,"Start-Nr.",null,"Mannschaft"]
[]
[null,1,null,"Mannschaft 1"]
[null,2,null,"Mannschaft 2"]
[null,3,null,"Mannschaft 3"]
[null,4,null,"Mannschaft 4"]
[null,5,null,"Mannschaft 5"]
[null,6,null,"Mannschaft 6"]
[null,7,null,"Mannschaft 7"]
[null,8,null,"Mannschaft 8"]
[null,9,null,"Mannschaft 9"]
[null,10,null,"Mannschaft 10"]
[null,11,null,"Mannschaft 11"]
[null,12,null,"Mannschaft 12"]
[null,13,null,"Mannschaft 13"]
[null,14,null,"Mannschaft 14"]
[null,15,null,"Mannschaft 15"]

{"sheet":"Rangliste","index":2,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,18,3,20],[2,9,2,10],[3,9,3,10],[2,3,2,4],[3,3,3,4],[2,6,2,7],[3,6,3,7],[2,12,2,13],[3,12,3,13],[2,15,2,16],[3,15,3,16]]}
["Rangliste"]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,"Total / Rang"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,{"$f":"Stammdaten!D23","v":"Richter 4"},null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Punkte","Prozent",null,"Punkte","Prozent",null,"Punkte","Prozent",null,"Punkte","Prozent",null,"Punkte","Prozent",null,"Note","Prozent","Rang"]
["Vereine"]
[1,{"$f":"VLOOKUP(A7,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 1"},1,{"$f":"'1'!$F$43","v":0},{"$f":"D7/320","v":0},null,{"$f":"'1'!$J$43","v":0},{"$f":"G7/320","v":0},null,{"$f":"'1'!$N$43","v":0},{"$f":"J7/320","v":0},null,{"$f":"'1'!$R$43","v":0},{"$f":"M7/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P7/320","v":0},null,{"$f":"D7+G7+J7+M7","v":0},{"$f":"((((E7+H7+K7)/3)+((Q7+N7)/2))/2)","v":0},{"$f":"RANK(T7,$T$7:T21)","v":1}]
[2,{"$f":"VLOOKUP(A8,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 2"},2,{"$f":"'2'!$F$43","v":0},{"$f":"D8/320","v":0},null,{"$f":"'2'!$J$43","v":0},{"$f":"G8/320","v":0},null,{"$f":"'2'!$N$43","v":0},{"$f":"J8/320","v":0},null,{"$f":"'2'!$R$43","v":0},{"$f":"M8/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P8/320","v":0},null,{"$f":"D8+G8+J8+M8","v":0},{"$f":"((((E8+H8+K8)/3)+((Q8+N8)/2))/2)","v":0},{"$f":"RANK(T8,$T$7:T22)","v":1}]
[3,{"$f":"VLOOKUP(A9,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 3"},3,{"$f":"'3'!$F$43","v":0},{"$f":"D9/320","v":0},null,{"$f":"'3'!$J$43","v":0},{"$f":"G9/320","v":0},null,{"$f":"'3'!$N$43","v":0},{"$f":"J9/320","v":0},null,{"$f":"'3'!$R$43","v":0},{"$f":"M9/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P9/320","v":0},null,{"$f":"D9+G9+J9+M9","v":0},{"$f":"((((E9+H9+K9)/3)+((Q9+N9)/2))/2)","v":0},{"$f":"RANK(T9,$T$7:T23)","v":1}]
[4,{"$f":"VLOOKUP(A10,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 4"},4,{"$f":"'4'!$F$43","v":0},{"$f":"D10/320","v":0},null,{"$f":"'4'!$J$43","v":0},{"$f":"G10/320","v":0},null,{"$f":"'4'!$N$43","v":0},{"$f":"J10/320","v":0},null,{"$f":"'4'!$R$43","v":0},{"$f":"M10/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P10/320","v":0},null,{"$f":"D10+G10+J10+M10","v":0},{"$f":"((((E10+H10+K10)/3)+((Q10+N10)/2))/2)","v":0},{"$f":"RANK(T10,$T$7:T24)","v":1}]
[5,{"$f":"VLOOKUP(A11,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 5"},5,{"$f":"'5'!$F$43","v":0},{"$f":"D11/320","v":0},null,{"$f":"'5'!$J$43","v":0},{"$f":"G11/320","v":0},null,{"$f":"'5'!$N$43","v":0},{"$f":"J11/320","v":0},null,{"$f":"'5'!$R$43","v":0},{"$f":"M11/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P11/320","v":0},null,{"$f":"D11+G11+J11+M11","v":0},{"$f":"((((E11+H11+K11)/3)+((Q11+N11)/2))/2)","v":0},{"$f":"RANK(T11,$T$7:T25)","v":1}]
[6,{"$f":"VLOOKUP(A12,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 6"},6,{"$f":"'6'!$F$43","v":0},{"$f":"D12/320","v":0},null,{"$f":"'6'!$J$43","v":0},{"$f":"G12/320","v":0},null,{"$f":"'6'!$N$43","v":0},{"$f":"J12/320","v":0},null,{"$f":"'6'!$R$43","v":0},{"$f":"M12/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P12/320","v":0},null,{"$f":"D12+G12+J12+M12","v":0},{"$f":"((((E12+H12+K12)/3)+((Q12+N12)/2))/2)","v":0},{"$f":"RANK(T12,$T$7:T26)","v":1}]
[7,{"$f":"VLOOKUP(A13,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 7"},7,{"$f":"'7'!$F$43","v":0},{"$f":"D13/320","v":0},null,{"$f":"'7'!$J$43","v":0},{"$f":"G13/320","v":0},null,{"$f":"'7'!$N$43","v":0},{"$f":"J13/320","v":0},null,{"$f":"'7'!$R$43","v":0},{"$f":"M13/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P13/320","v":0},null,{"$f":"D13+G13+J13+M13","v":0},{"$f":"((((E13+H13+K13)/3)+((Q13+N13)/2))/2)","v":0},{"$f":"RANK(T13,$T$7:T27)","v":1}]
[8,{"$f":"VLOOKUP(A14,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 8"},8,{"$f":"'8'!$F$43","v":0},{"$f":"D14/320","v":0},null,{"$f":"'8'!$J$43","v":0},{"$f":"G14/320","v":0},null,{"$f":"'8'!$N$43","v":0},{"$f":"J14/320","v":0},null,{"$f":"'8'!$R$43","v":0},{"$f":"M14/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P14/320","v":0},null,{"$f":"D14+G14+J14+M14","v":0},{"$f":"((((E14+H14+K14)/3)+((Q14+N14)/2))/2)","v":0},{"$f":"RANK(T14,$T$7:T28)","v":1}]
[9,{"$f":"VLOOKUP(A15,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 9"},9,{"$f":"'9'!$F$43","v":0},{"$f":"D15/320","v":0},null,{"$f":"'9'!$J$43","v":0},{"$f":"G15/320","v":0},null,{"$f":"'9'!$N$43","v":0},{"$f":"J15/320","v":0},null,{"$f":"'9'!$R$43","v":0},{"$f":"M15/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P15/320","v":0},null,{"$f":"D15+G15+J15+M15","v":0},{"$f":"((((E15+H15+K15)/3)+((Q15+N15)/2))/2)","v":0},{"$f":"RANK(T15,$T$7:T29)","v":1}]
[10,{"$f":"VLOOKUP(A16,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 10"},10,{"$f":"'10'!$F$43","v":0},{"$f":"D16/320","v":0},null,{"$f":"'10'!$J$43","v":0},{"$f":"G16/320","v":0},null,{"$f":"'10'!$N$43","v":0},{"$f":"J16/320","v":0},null,{"$f":"'10'!$R$43","v":0},{"$f":"M16/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P16/320","v":0},null,{"$f":"D16+G16+J16+M16","v":0},{"$f":"((((E16+H16+K16)/3)+((Q16+N16)/2))/2)","v":0},{"$f":"RANK(T16,$T$7:T30)","v":1}]
[11,{"$f":"VLOOKUP(A17,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 11"},11,{"$f":"'11'!$F$43","v":0},{"$f":"D17/320","v":0},null,{"$f":"'11'!$J$43","v":0},{"$f":"G17/320","v":0},null,{"$f":"'11'!$N$43","v":0},{"$f":"J17/320","v":0},null,{"$f":"'11'!$R$43","v":0},{"$f":"M17/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P17/320","v":0},null,{"$f":"D17+G17+J17+M17","v":0},{"$f":"((((E17+H17+K17)/3)+((Q17+N17)/2))/2)","v":0},{"$f":"RANK(T17,$T$7:T31)","v":1}]
[12,{"$f":"VLOOKUP(A18,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 12"},12,{"$f":"'12'!$F$43","v":0},{"$f":"D18/320","v":0},null,{"$f":"'12'!$J$43","v":0},{"$f":"G18/320","v":0},null,{"$f":"'12'!$N$43","v":0},{"$f":"J18/320","v":0},null,{"$f":"'12'!$R$43","v":0},{"$f":"M18/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P18/320","v":0},null,{"$f":"D18+G18+J18+M18","v":0},{"$f":"((((E18+H18+K18)/3)+((Q18+N18)/2))/2)","v":0},{"$f":"RANK(T18,$T$7:T32)","v":1}]
[13,{"$f":"VLOOKUP(A19,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 13"},13,{"$f":"'13'!$F$43","v":0},{"$f":"D19/320","v":0},null,{"$f":"'13'!$J$43","v":0},{"$f":"G19/320","v":0},null,{"$f":"'13'!$N$43","v":0},{"$f":"J19/320","v":0},null,{"$f":"'13'!$R$43","v":0},{"$f":"M19/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P19/320","v":0},null,{"$f":"D19+G19+J19+M19","v":0},{"$f":"((((E19+H19+K19)/3)+((Q19+N19)/2))/2)","v":0},{"$f":"RANK(T19,$T$7:T33)","v":1}]
[14,{"$f":"VLOOKUP(A20,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 14"},14,{"$f":"'14'!$F$43","v":0},{"$f":"D20/320","v":0},null,{"$f":"'14'!$J$43","v":0},{"$f":"G20/320","v":0},null,{"$f":"'14'!$N$43","v":0},{"$f":"J20/320","v":0},null,{"$f":"'14'!$R$43","v":0},{"$f":"M20/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P20/320","v":0},null,{"$f":"D20+G20+J20+M20","v":0},{"$f":"((((E20+H20+K20)/3)+((Q20+N20)/2))/2)","v":0},{"$f":"RANK(T20,$T$7:T34)","v":1}]
[15,{"$f":"VLOOKUP(A21,Mannschaften!B:D,3,FALSE)","v":"Mannschaft 15"},15,{"$f":"'15'!$F$43","v":0},{"$f":"D21/320","v":0},null,{"$f":"'15'!$J$43","v":0},{"$f":"G21/320","v":0},null,{"$f":"'15'!$N$43","v":0},{"$f":"J21/320","v":0},null,{"$f":"'15'!$R$43","v":0},{"$f":"M21/320","v":0},null,{"$f":"'1'!$V$43","v":0},{"$f":"P21/320","v":0},null,{"$f":"D21+G21+J21+M21","v":0},{"$f":"((((E21+H21+K21)/3)+((Q21+N21)/2))/2)","v":0},{"$f":"RANK(T21,$T$7:T35)","v":1}]
["Bei gleicher Total-Punktezahl entscheidet die höhere Wertung der Seitenrichter (Gesamteindruck) über die Klassierung."]
["Gewichtung: 50% Durchschnitt der 3 Reiter und 50% Wertung der Seitenrichter"]

{"sheet":"1","index":3,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,19,2,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,23,4,23],[3,19,3,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D5","v":"Mannschaft 1"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"2","index":4,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,3,2,5],[2,7,2,9],[2,11,2,13],[2,15,2,17],[3,3,3,5],[3,7,3,9],[3,11,3,13],[3,15,3,17],[2,19,2,21]]}
[{"$f":"Mannschaften!D6","v":"Mannschaft 2"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"3","index":5,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D7","v":"Mannschaft 3"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"4","index":6,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D8","v":"Mannschaft 4"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"5","index":7,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D9","v":"Mannschaft 5"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"6","index":8,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D10","v":"Mannschaft 6"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"7","index":9,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D11","v":"Mannschaft 7"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"8","index":10,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D12","v":"Mannschaft 8"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"9","index":11,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D13","v":"Mannschaft 9"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"10","index":12,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D14","v":"Mannschaft 10"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"11","index":13,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D15","v":"Mannschaft 11"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"12","index":14,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D16","v":"Mannschaft 12"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"13","index":15,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D17","v":"Mannschaft 13"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"14","index":16,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D18","v":"Mannschaft 14"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]

{"sheet":"15","index":17,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,23,4,23],[3,19,3,21],[0,20,0,21],[2,11,2,13],[3,11,3,13],[2,19,2,21],[2,3,2,5],[3,3,3,5],[2,7,2,9],[3,7,3,9],[2,15,2,17],[3,15,3,17]]}
[{"$f":"Mannschaften!D19","v":"Mannschaft 15"},null,null,null,null,null,null,null,null,null,null,null,"Startnummer:",1,null,null,null,"Prozente:",null,null,{"$f":"X45*100","v":0}]
[]
[{"$f":"Stammdaten!B4","v":"OKV Mannschaftsdressurfinal 2018"},null,null,{"$f":"Stammdaten!B14","v":"Richter H / Reiter 1"},null,null,null,{"$f":"Stammdaten!B17","v":"Richter C / Reiter 2"},null,null,null,{"$f":"Stammdaten!B20","v":"Richter M / Reiter 3"},null,null,null,{"$f":"Stammdaten!B23","v":"Richter E / Gesamteindr."},null,null,null,{"$f":"Stammdaten!B26","v":"Richter B / Gesamteindr."},null,null,null,"Total"]
[{"$f":"Stammdaten!B7","v":"Werdenberg"},null,null,{"$f":"Stammdaten!D14","v":"Richter 1"},null,null,null,{"$f":"Stammdaten!D17","v":"Richter 2"},null,null,null,{"$f":"Stammdaten!D20","v":"Richter 3"},null,null,null,{"$f":"Stammdaten!H20","v":0},null,null,null,{"$f":"Stammdaten!D26","v":"Richter 5"}]
[null,null,null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte",null,"Note","Koef.","Punkte"]
["Lektionen"]
[1,"Einreiten im Arbeitstrab",null,null,1,{"$f":"E7*D7","v":0},null,null,1,{"$f":"I7*H7","v":0},null,null,1,{"$f":"M7*L7","v":0},null,null,1,{"$f":"Q7*P7","v":0},null,null,1,{"$f":"U7*T7","v":0}]
[{"$f":"A7+1","v":2},"H Volte Links",null,null,1,{"$f":"E8*D8","v":0},null,null,1,{"$f":"I8*H8","v":0},null,null,1,{"$f":"M8*L8","v":0},null,null,1,{"$f":"Q8*P8","v":0},null,null,1,{"$f":"U8*T8","v":0}]
[{"$f":"A8+1","v":3},"S-F durch die Bahn wechseln",null,null,1,{"$f":"E9*D9","v":0},null,null,1,{"$f":"I9*H9","v":0},null,null,1,{"$f":"M9*L9","v":0},null,null,1,{"$f":"Q9*P9","v":0},null,null,1,{"$f":"U9*T9","v":0}]
[4,"Schlangenlinie 3 Bögen Mittellinie",null,null,2,{"$f":"E10*D10","v":0},null,null,2,{"$f":"I10*H10","v":0},null,null,2,{"$f":"M10*L10","v":0},null,null,2,{"$f":"Q10*P10","v":0},null,null,2,{"$f":"U10*T10","v":0}]
[5,"Durch die ganze Bahn wechseln",null,null,1,{"$f":"E11*D11","v":0},null,null,1,{"$f":"I11*H11","v":0},null,null,1,{"$f":"M11*L11","v":0},null,null,1,{"$f":"Q11*P11","v":0},null,null,1,{"$f":"U11*T11","v":0}]
[6,"Arbeitsgalopp links",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[7,"Grosse Volte ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[8,"Aufnehmen und gerade aus",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[9,"Durch halbe Diagonale wechseln",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[10,"Arbeitsgalopp rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[11,"Volte rechts",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[12,"Mittelgalopp",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[13,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[14,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[15,"Starker Schritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[16,"Mittelschritt",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[17,"Arbeitstrab ",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,0]
[18,"Grosse Volte Zügel aus der Hand",null,null,2,{"$f":"E24*D24","v":0},null,null,2,{"$f":"I24*H24","v":0},null,null,2,{"$f":"M24*L24","v":0},null,null,2,{"$f":"Q24*P24","v":0},null,null,2,{"$f":"U24*T24","v":0}]
[19,"Halbe Volte",null,null,1,0,null,null,1,0,null,null,1,0,null,null,1,{"$f":"Q25*P25","v":0},null,null,1,{"$f":"U25*T25","v":0}]
[20,"Halt und Gruss ",null,null,1,{"$f":"E26*D26","v":0},null,null,1,{"$f":"I26*H26","v":0},null,null,1,{"$f":"M26*L26","v":0},null,null,1,{"$f":"Q26*P26","v":0},null,null,1,{"$f":"U26*T26","v":0}]
["Total der Lektionen",null,null,null,null,{"$f":"SUM(F7:F26)","v":0},null,null,null,{"$f":"SUM(J7:J26)","v":0},null,null,null,{"$f":"SUM(N7:N26)","v":0},null,null,null,{"$f":"SUM(R7:R26)","v":0},null,null,null,{"$f":"SUM(V7:V26)","v":0}]
[]
["Gesamteindruck"]
[{"$f":"A26+1","v":21},"Reinheit der Gänge",null,null,2,{"$f":"E30*D30","v":0},null,null,2,0,null,null,2,0,null,null,2,{"$f":"Q30*P30","v":0},null,null,2,{"$f":"U30*T30","v":0}]
[{"$f":"A30+1","v":22},"Schwung",null,null,2,{"$f":"E31*D31","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A31+1","v":23},"Gehorsam",null,null,2,{"$f":"E32*D32","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A32+1","v":24},"Exaktheit",null,null,2,{"$f":"E33*D33","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
[{"$f":"A33+1","v":25},"Sitz und Einwirkung",null,null,2,{"$f":"E34*D34","v":0},null,null,2,0,null,null,2,0,null,null,2,0,null,null,2,0]
["Lektionen + Gesamteindruck",null,null,null,null,{"$f":"SUM(F30:F34,F27)","v":0},null,null,null,{"$f":"SUM(J30:J34,J27)","v":0},null,null,null,{"$f":"SUM(N30:N34,N27)","v":0},null,null,null,{"$f":"SUM(R30:R34,R27)","v":0},null,null,null,{"$f":"SUM(V30:V34,V27)","v":0}]
[]
["Abzüge"]
[null,"Erster Programmfehler",null,null,-2,{"$f":"E38*D38","v":0},null,null,-2,{"$f":"I38*H38","v":0},null,null,-2,{"$f":"M38*L38","v":0},null,null,-2,{"$f":"Q38*P38","v":0},null,null,-2,{"$f":"U38*T38","v":0}]
[null,"Zweiter Programmfehler",null,null,-5,{"$f":"E39*D39","v":0},null,null,-5,{"$f":"I39*H39","v":0},null,null,-5,{"$f":"M39*L39","v":0},null,null,-5,{"$f":"Q39*P39","v":0},null,null,-5,{"$f":"U39*T39","v":0}]
[null,"Dritter Programmfehler",null,null,-10,{"$f":"E40*D40","v":0},null,null,-10,{"$f":"I40*H40","v":0},null,null,-10,{"$f":"M40*L40","v":0},null,null,-10,{"$f":"Q40*P40","v":0},null,null,-10,{"$f":"U40*T40","v":0}]
["Total Abzüge",null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,null,null,{"$f":"SUM(J38:J40)","v":0},null,null,null,{"$f":"SUM(N38:N40)","v":0},null,null,null,{"$f":"SUM(R38:R40)","v":0},null,null,null,{"$f":"SUM(V38:V40)","v":0}]
[]
["Endresultat",null,null,null,null,{"$f":"F35+F41","v":0},null,null,null,{"$f":"J35+J41","v":0},null,null,null,{"$f":"N35+N41","v":0},null,null,null,{"$f":"R35+R41","v":0},null,null,null,{"$f":"V35+V41","v":0}]
[]
["in Prozenten",null,null,null,null,{"$f":"F43/320","v":0},null,null,null,{"$f":"J43/320","v":0},null,null,null,{"$f":"N43/320","v":0},null,null,null,{"$f":"R43/320","v":0},null,null,null,{"$f":"V43/320","v":0},null,{"$f":"(((F45+J45+N45)/3)+(R45+V45)/2)/2","v":0}]
[]
["ACHTUNG: Noten NUR in den farbigen Feldern eingeben & nach jeder Mannschaft speichern!"]