{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Spielbericht"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Spielbericht","index":0,"n_rows":35,"n_cols":23,"rows_kept":35,"merged":[[0,0,0,4],[2,0,2,2],[2,3,2,6],[4,0,4,2],[4,3,4,6],[4,9,4,13],[4,14,4,22],[6,0,6,2],[6,3,6,6],[6,9,6,13],[6,14,6,22],[8,2,9,2],[8,3,9,4],[8,5,9,5],[8,6,9,6],[8,8,9,10],[8,11,9,13],[8,14,9,16],[8,17,8,18],[8,19,8,20],[8,21,8,22],[11,0,12,0],[11,3,11,4],[11,8,12,8],[11,9,12,9],[11,10,12,10],[11,11,12,11],[11,12,12,12],[11,13,12,13],[11,14,12,14],[11,15,12,15],[11,16,12,16],[11,17,12,18],[11,19,12,20],[11,21,12,22],[12,3,12,4],[13,0,14,0],[13,3,13,4],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,12,14,12],[13,13,14,13],[13,14,14,14],[13,15,14,15],[13,16,14,16],[13,17,14,18],[13,19,14,20],[13,21,14,22],[14,3,14,4],[15,0,16,0],[15,3,15,4],[15,8,16,8],[15,9,16,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,15,16,15],[15,16,16,16],[15,17,16,18],[15,19,16,20],[15,21,16,22],[16,3,16,4],[17,3,17,4],[17,17,17,18],[17,19,17,20],[17,21,17,22],[18,3,18,4],[18,17,18,18],[18,19,18,20],[18,21,18,22],[19,0,20,0],[19,3,19,4],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,20,12],[19,13,20,13],[19,14,20,14],[19,15,20,15],[19,16,20,16],[19,17,20,18],[19,19,20,20],[19,21,20,22],[20,3,20,4],[21,3,21,4],[21,17,21,18],[21,19,21,20],[21,21,21,22],[22,3,22,4],[22,17,22,18],[22,19,22,20],[22,21,22,22],[24,2,25,3],[24,4,25,6],[24,8,25,16],[24,17,25,18],[24,19,25,20],[24,21,25,22],[27,0,27,3],[27,4,27,6],[27,8,27,22],[28,4,28,6],[28,8,28,22],[29,0,29,3],[29,4,29,16],[29,18,29,21],[30,18,30,22],[31,0,31,22],[33,0,33,3],[33,9,33,16],[33,18,33,22],[34,0,34,3],[34,9,34,16],[34,18,34,22]]}
["Badminton-Spielbericht"]
[]
["Spielklasse :"]
[]
["Heimverein :",{"$nulls":8},"Austragungsort :"]
[]
["Gastverein :",{"$nulls":8},"Schiedsrichter :",{"$nulls":4},"                                     / "]
[]
["Beginn :",null,"RL-Pos.",{"$f":"IF(D5<>\"\",D5,\"Heimverein\")","v":"Heimverein"},null,"RL-Pos.",{"$f":"IF(D7<>\"\",D7,\"Gastverein\")","v":"Gastverein"},null,"1.Satz",null,null,"2.Satz",null,null,"3.Satz",null,null,"Punkte",null,"Sätze",null,"Spiele"]
[{"$nulls":17},"Heim","Gast","Heim","Gast","Heim","Gast"]
[]
["1.HD",{"$nulls":4},5,{"$nulls":3},":",null,null,":",null,null,":",null,{"$f":"IF(I12+L12+O12+K12+N12+Q12=0,\":\",CONCATENATE(I12+L12+O12,\" : \",K12+N12+Q12))","v":":"},null,{"$f":"IF(AND(I12>K12,L12>N12,K12<>\"\",N12<>\"\",O12=\"\",Q12=\"\"),\"2 : 0\",IF(AND(I12<K12,L12<N12,I12<>\"\",L12<>\"\",O12=\"\",Q12=\"\"),\"0 : 2\",IF(AND(O12>Q12,Q12<>\"\",NOT(AND(I12>K12,L12>N12)),NOT(AND(I12<K12,L12<N12)),I12<>K12,L12<>N12,I12<>\"\",K12<>\"\",L12<>\"\",N12<>\"\"),\"2 : 1\",IF(AND(O12<Q12,O12<>\"\",NOT(AND(I12>K12,L12>N12)),NOT(AND(I12<K12,L12<N12)),I12<>K12,L12<>N12,I12<>\"\",K12<>\"\",L12<>\"\",N12<>\"\"),\"1 : 2\",\":\"))))","v":":"},null,{"$f":"IF(T12=\":\",\":\",IF(VALUE(LEFT(T12,1))>VALUE(RIGHT(T12,1)),\"1 : 0\",\"0 : 1\"))","v":":"}]
[{"$nulls":5},4]
["DD",{"$nulls":4},2,{"$nulls":3},":",null,null,":",null,null,":",null,{"$f":"IF(I14+L14+O14+K14+N14+Q14=0,\":\",CONCATENATE(I14+L14+O14,\" : \",K14+N14+Q14))","v":":"},null,{"$f":"IF(AND(I14>K14,L14>N14,K14<>\"\",N14<>\"\",O14=\"\",Q14=\"\"),\"2 : 0\",IF(AND(I14<K14,L14<N14,I14<>\"\",L14<>\"\",O14=\"\",Q14=\"\"),\"0 : 2\",IF(AND(O14>Q14,Q14<>\"\",NOT(AND(I14>K14,L14>N14)),NOT(AND(I14<K14,L14<N14)),I14<>K14,L14<>N14,I14<>\"\",K14<>\"\",L14<>\"\",N14<>\"\"),\"2 : 1\",IF(AND(O14<Q14,O14<>\"\",NOT(AND(I14>K14,L14>N14)),NOT(AND(I14<K14,L14<N14)),I14<>K14,L14<>N14,I14<>\"\",K14<>\"\",L14<>\"\",N14<>\"\"),\"1 : 2\",\":\"))))","v":":"},null,{"$f":"IF(T14=\":\",\":\",IF(VALUE(LEFT(T14,1))>VALUE(RIGHT(T14,1)),\"1 : 0\",\"0 : 1\"))","v":":"}]
[{"$nulls":5},4]
["2.HD",{"$nulls":4},3,{"$nulls":3},":",null,null,":",null,null,":",null,{"$f":"IF(I16+L16+O16+K16+N16+Q16=0,\":\",CONCATENATE(I16+L16+O16,\" : \",K16+N16+Q16))","v":":"},null,{"$f":"IF(AND(I16>K16,L16>N16,K16<>\"\",N16<>\"\",O16=\"\",Q16=\"\"),\"2 : 0\",IF(AND(I16<K16,L16<N16,I16<>\"\",L16<>\"\",O16=\"\",Q16=\"\"),\"0 : 2\",IF(AND(O16>Q16,Q16<>\"\",NOT(AND(I16>K16,L16>N16)),NOT(AND(I16<K16,L16<N16)),I16<>K16,L16<>N16,I16<>\"\",K16<>\"\",L16<>\"\",N16<>\"\"),\"2 : 1\",IF(AND(O16<Q16,O16<>\"\",NOT(AND(I16>K16,L16>N16)),NOT(AND(I16<K16,L16<N16)),I16<>K16,L16<>N16,I16<>\"\",K16<>\"\",L16<>\"\",N16<>\"\"),\"1 : 2\",\":\"))))","v":":"},null,{"$f":"IF(T16=\":\",\":\",IF(VALUE(LEFT(T16,1))>VALUE(RIGHT(T16,1)),\"1 : 0\",\"0 : 1\"))","v":":"}]
[{"$nulls":5},7]
["1.HE",{"$nulls":4},2,{"$nulls":3},":",null,null,":",null,null,":",null,{"$f":"IF(I18+L18+O18+K18+N18+Q18=0,\":\",CONCATENATE(I18+L18+O18,\" : \",K18+N18+Q18))","v":":"},null,{"$f":"IF(AND(I18>K18,L18>N18,K18<>\"\",N18<>\"\",O18=\"\",Q18=\"\"),\"2 : 0\",IF(AND(I18<K18,L18<N18,I18<>\"\",L18<>\"\",O18=\"\",Q18=\"\"),\"0 : 2\",IF(AND(O18>Q18,Q18<>\"\",NOT(AND(I18>K18,L18>N18)),NOT(AND(I18<K18,L18<N18)),I18<>K18,L18<>N18,I18<>\"\",K18<>\"\",L18<>\"\",N18<>\"\"),\"2 : 1\",IF(AND(O18<Q18,O18<>\"\",NOT(AND(I18>K18,L18>N18)),NOT(AND(I18<K18,L18<N18)),I18<>K18,L18<>N18,I18<>\"\",K18<>\"\",L18<>\"\",N18<>\"\"),\"1 : 2\",\":\"))))","v":":"},null,{"$f":"IF(T18=\":\",\":\",IF(VALUE(LEFT(T18,1))>VALUE(RIGHT(T18,1)),\"1 : 0\",\"0 : 1\"))","v":":"}]
["DE",{"$nulls":4},4,{"$nulls":3},":",null,null,":",null,null,":",null,{"$f":"IF(I19+L19+O19+K19+N19+Q19=0,\":\",CONCATENATE(I19+L19+O19,\" : \",K19+N19+Q19))","v":":"},null,{"$f":"IF(AND(I19>K19,L19>N19,K19<>\"\",N19<>\"\",O19=\"\",Q19=\"\"),\"2 : 0\",IF(AND(I19<K19,L19<N19,I19<>\"\",L19<>\"\",O19=\"\",Q19=\"\"),\"0 : 2\",IF(AND(O19>Q19,Q19<>\"\",NOT(AND(I19>K19,L19>N19)),NOT(AND(I19<K19,L19<N19)),I19<>K19,L19<>N19,I19<>\"\",K19<>\"\",L19<>\"\",N19<>\"\"),\"2 : 1\",IF(AND(O19<Q19,O19<>\"\",NOT(AND(I19>K19,L19>N19)),NOT(AND(I19<K19,L19<N19)),I19<>K19,L19<>N19,I19<>\"\",K19<>\"\",L19<>\"\",N19<>\"\"),\"1 : 2\",\":\"))))","v":":"},null,{"$f":"IF(T19=\":\",\":\",IF(VALUE(LEFT(T19,1))>VALUE(RIGHT(T19,1)),\"1 : 0\",\"0 : 1\"))","v":":"}]
["GD",{"$nulls":8},":",null,null,":",null,null,":",null,{"$f":"IF(I20+L20+O20+K20+N20+Q20=0,\":\",CONCATENATE(I20+L20+O20,\" : \",K20+N20+Q20))","v":":"},null,{"$f":"IF(AND(I20>K20,L20>N20,K20<>\"\",N20<>\"\",O20=\"\",Q20=\"\"),\"2 : 0\",IF(AND(I20<K20,L20<N20,I20<>\"\",L20<>\"\",O20=\"\",Q20=\"\"),\"0 : 2\",IF(AND(O20>Q20,Q20<>\"\",NOT(AND(I20>K20,L20>N20)),NOT(AND(I20<K20,L20<N20)),I20<>K20,L20<>N20,I20<>\"\",K20<>\"\",L20<>\"\",N20<>\"\"),\"2 : 1\",IF(AND(O20<Q20,O20<>\"\",NOT(AND(I20>K20,L20>N20)),NOT(AND(I20<K20,L20<N20)),I20<>K20,L20<>N20,I20<>\"\",K20<>\"\",L20<>\"\",N20<>\"\"),\"1 : 2\",\":\"))))","v":":"},null,{"$f":"IF(T20=\":\",\":\",IF(VALUE(LEFT(T20,1))>VALUE(RIGHT(T20,1)),\"1 : 0\",\"0 : 1\"))","v":":"}]
[]
["2.HE",{"$nulls":4},3,{"$nulls":3},":",null,null,":",null,null,":",null,{"$f":"IF(I22+L22+O22+K22+N22+Q22=0,\":\",CONCATENATE(I22+L22+O22,\" : \",K22+N22+Q22))","v":":"},null,{"$f":"IF(AND(I22>K22,L22>N22,K22<>\"\",N22<>\"\",O22=\"\",Q22=\"\"),\"2 : 0\",IF(AND(I22<K22,L22<N22,I22<>\"\",L22<>\"\",O22=\"\",Q22=\"\"),\"0 : 2\",IF(AND(O22>Q22,Q22<>\"\",NOT(AND(I22>K22,L22>N22)),NOT(AND(I22<K22,L22<N22)),I22<>K22,L22<>N22,I22<>\"\",K22<>\"\",L22<>\"\",N22<>\"\"),\"2 : 1\",IF(AND(O22<Q22,O22<>\"\",NOT(AND(I22>K22,L22>N22)),NOT(AND(I22<K22,L22<N22)),I22<>K22,L22<>N22,I22<>\"\",K22<>\"\",L22<>\"\",N22<>\"\"),\"1 : 2\",\":\"))))","v":":"},null,{"$f":"IF(T22=\":\",\":\",IF(VALUE(LEFT(T22,1))>VALUE(RIGHT(T22,1)),\"1 : 0\",\"0 : 1\"))","v":":"}]
["3.HE",{"$nulls":4},4,{"$nulls":3},":",null,null,":",null,null,":",null,{"$f":"IF(I23+L23+O23+K23+N23+Q23=0,\":\",CONCATENATE(I23+L23+O23,\" : \",K23+N23+Q23))","v":":"},null,{"$f":"IF(AND(I23>K23,L23>N23,K23<>\"\",N23<>\"\",O23=\"\",Q23=\"\"),\"2 : 0\",IF(AND(I23<K23,L23<N23,I23<>\"\",L23<>\"\",O23=\"\",Q23=\"\"),\"0 : 2\",IF(AND(O23>Q23,Q23<>\"\",NOT(AND(I23>K23,L23>N23)),NOT(AND(I23<K23,L23<N23)),I23<>K23,L23<>N23,I23<>\"\",K23<>\"\",L23<>\"\",N23<>\"\"),\"2 : 1\",IF(AND(O23<Q23,O23<>\"\",NOT(AND(I23>K23,L23>N23)),NOT(AND(I23<K23,L23<N23)),I23<>K23,L23<>N23,I23<>\"\",K23<>\"\",L23<>\"\",N23<>\"\"),\"1 : 2\",\":\"))))","v":":"},null,{"$f":"IF(T23=\":\",\":\",IF(VALUE(LEFT(T23,1))>VALUE(RIGHT(T23,1)),\"1 : 0\",\"0 : 1\"))","v":":"}]
[]
["Ende :",null,"Sieger :",null,{"$f":"IF(OR(T12=\":\",T14=\":\",T16=\":\",T18=\":\",T19=\":\",T20=\":\",T22=\":\",T23=\":\"),\"\",IF(VALUE(LEFT(V25,1))>VALUE(RIGHT(V25,1)),D9,IF(VALUE(LEFT(V25,1))<VALUE(RIGHT(V25,1)),G9,\"Unentschieden\")))","v":""},{"$nulls":3},"Ergebnis :",{"$nulls":8},{"$f":"IF(SUM(I12:I23,K12:L23,N12:O23,Q12:Q23)=0,\":\",CONCATENATE(SUM(I12:I23,L12:L23,O12:O23),\" : \",SUM(K12:K23,N12:N23,Q12:Q23)))","v":":"},null,{"$f":"IF(AND(T12=\":\",T14=\":\",T16=\":\",T18=\":\",T19=\":\",T20=\":\",T22=\":\",T23=\":\"),\":\",CONCATENATE(SUM(IF(T12<>\":\",VALUE(LEFT(T12,1)),0),IF(T14<>\":\",VALUE(LEFT(T14,1)),0),IF(T16<>\":\",VALUE(LEFT(T16,1)),0),IF(T18<>\":\",VALUE(LEFT(T18,1)),0),IF(T19<>\":\",VALUE(LEFT(T19,1)),0),IF(T20<>\":\",VALUE(LEFT(T20,1)),0),IF(T22<>\":\",VALUE(LEFT(T22,1)),0),IF(T23<>\":\",VALUE(LEFT(T23,1)),0)),\" : \",SUM(IF(T12<>\":\",VALUE(RIGHT(T12,1)),0),IF(T14<>\":\",VALUE(RIGHT(T14,1)),0),IF(T16<>\":\",VALUE(RIGHT(T16,1)),0),IF(T18<>\":\",VALUE(RIGHT(T18,1)),0),IF(T19<>\":\",VALUE(RIGHT(T19,1)),0),IF(T20<>\":\",VALUE(RIGHT(T20,1)),0),IF(T22<>\":\",VALUE(RIGHT(T22,1)),0),IF(T23<>\":\",VALUE(RIGHT(T23,1)),0))))","v":":"},null,{"$f":"IF(AND(V12=\":\",V14=\":\",V16=\":\",V18=\":\",V19=\":\",V20=\":\",V22=\":\",V23=\":\"),\":\",CONCATENATE(SUM(IF(V12<>\":\",VALUE(LEFT(V12,1)),0),IF(V14<>\":\",VALUE(LEFT(V14,1)),0),IF(V16<>\":\",VALUE(LEFT(V16,1)),0),IF(V18<>\":\",VALUE(LEFT(V18,1)),0),IF(V19<>\":\",VALUE(LEFT(V19,1)),0),IF(V20<>\":\",VALUE(LEFT(V20,1)),0),IF(V22<>\":\",VALUE(LEFT(V22,1)),0),IF(V23<>\":\",VALUE(LEFT(V23,1)),0)),\" : \",SUM(IF(V12<>\":\",VALUE(RIGHT(V12,1)),0),IF(V14<>\":\",VALUE(RIGHT(V14,1)),0),IF(V16<>\":\",VALUE(RIGHT(V16,1)),0),IF(V18<>\":\",VALUE(RIGHT(V18,1)),0),IF(V19<>\":\",VALUE(RIGHT(V19,1)),0),IF(V20<>\":\",VALUE(RIGHT(V20,1)),0),IF(V22<>\":\",VALUE(RIGHT(V22,1)),0),IF(V23<>\":\",VALUE(RIGHT(V23,1)),0))))","v":":"}]
[]
[]
["vorgesehener Zusatzspieler :"]
[{"$nulls":4},{"$f":"IF(D5<>\"\",D5,\"Heimverein\")","v":"Heimverein"},{"$nulls":3},{"$f":"IF(D7<>\"\",D7,\"Gastverein\")","v":"Gastverein"}]
["Besondere Vorkomnisse :",{"$nulls":17},"Protestvorbehalt :"]
[{"$nulls":18},"(siehe Rückseite inkl. Protestzeit)"]
["Die Richtigkeit der Angaben wird bescheinigt. Das Spiel hat unter Beachtung der für die angegebene Spielklasse gültigen Spielordnung stattgefunden."]
[]
["Freital",{"$nulls":3},", den 27.09.2019"]
["Ort",{"$nulls":3},"Datum",null,"Schiedsrichter",null,null,{"$f":"CONCATENATE(\"MF \",IF(D5<>\"\",D5,\"Heimverein\"))","v":"MF Heimverein"},{"$nulls":8},{"$f":"CONCATENATE(\"MF \",IF(D7<>\"\",D7,\"Gastverein\"))","v":"MF Gastverein"}]