{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SpB m Gassen","SpB","Ausfüllhilfe"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SpB m Gassen","index":0,"n_rows":64,"n_cols":35,"rows_kept":64,"cut":false,"hidden":false,"merged":[[55,7,55,9],[44,1,44,3],[45,1,45,3],[55,4,55,6],[47,1,47,3],[48,1,48,3],[49,1,49,3],[46,1,46,3],[63,4,64,15],[0,26,0,27],[24,4,25,15],[37,4,38,15],[50,4,51,15],[55,17,55,20],[53,1,53,7],[29,17,29,20],[42,17,42,20],[39,10,39,21],[62,1,62,3],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[61,1,61,3],[20,1,20,3],[31,1,31,3],[32,1,32,3],[35,1,35,3],[21,1,21,3],[27,1,27,7],[33,1,33,3],[34,1,34,3],[29,4,29,6],[22,1,22,3],[23,1,23,3],[26,10,26,21],[27,10,28,21],[42,4,42,6],[36,1,36,3],[40,1,40,7],[42,7,42,9],[29,7,29,9],[55,10,55,12],[55,13,55,15],[29,10,29,12],[29,13,29,15],[53,10,54,21],[40,10,41,21],[52,10,52,21],[42,13,42,15],[42,10,42,12],[0,3,3,15],[11,2,11,5],[9,1,9,12],[14,1,14,7],[13,10,13,21],[14,10,15,21],[0,0,4,2],[5,9,6,12],[5,4,6,7],[19,1,19,3],[16,7,16,9],[16,4,16,6],[16,17,16,20],[16,10,16,12],[16,13,16,15],[18,1,18,3]]}
["LFV Rhl.-Pfalz e.V.\n- Kegeln -\n\"Sektion Schere\"",null,null,"Spielbericht für\nMeister-/Abstiegsrunde",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modalwert",{"$f":"MODE(X3:X6)","v":0},null,"Adresse",null,null,null,null,"Liga","Klubname","Kegelbahn","Letzte bespielte Bahn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rheinland-Pfalz-Liga",null,null,null,null,null,"Ges.-Holz","Gleichheit","Rang","Holz","Abr.","NK","Zeile","EWP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(INDIRECT(AA3)),INDIRECT(AA3)+(INDIRECT(AB3)/100000)+IF(ISNUMBER(INDIRECT(AC3)),INDIRECT(AC3)/100000000,0),0)","v":0},{"$f":"IF(AND(X3=$Y$1,$Y$1>0),ROW()-2,0)","v":0},{"$f":"5-RANK(X3,$X$3:$X$6,0)","v":4},{"$f":"ADDRESS(AD3,21)","v":"$U$25"},{"$f":"ADDRESS(AD3,19)","v":"$S$25"},{"$f":"ADDRESS(AD3,20)","v":"$T$25"},25,{"$f":"INDIRECT(ADDRESS(AD3,22))","v":""},"RLP","Haardtkopf Morbach","Kegelsportanlage i.d. Baldenauhalle","4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(INDIRECT(AA4)),INDIRECT(AA4)+(INDIRECT(AB4)/100000)+IF(ISNUMBER(INDIRECT(AC4)),INDIRECT(AC4)/100000000,0),0)","v":0},{"$f":"IF(AND(X4=$Y$1,$Y$1>0),ROW()-2,0)","v":0},{"$f":"5-RANK(X4,$X$3:$X$6,0)","v":4},{"$f":"ADDRESS(AD4,21)","v":"$U$38"},{"$f":"ADDRESS(AD4,19)","v":"$S$38"},{"$f":"ADDRESS(AD4,20)","v":"$T$38"},{"$f":"AD3+13","v":38},{"$f":"INDIRECT(ADDRESS(AD4,22))","v":""},"RLP","KSC Daun-Weiersbach 2","Keglerheim Daun-Weiersbach"," 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(INDIRECT(AA5)),INDIRECT(AA5)+(INDIRECT(AB5)/100000)+IF(ISNUMBER(INDIRECT(AC5)),INDIRECT(AC5)/100000000,0),0)","v":0},{"$f":"IF(AND(X5=$Y$1,$Y$1>0),ROW()-2,0)","v":0},{"$f":"5-RANK(X5,$X$3:$X$6,0)","v":4},{"$f":"ADDRESS(AD5,21)","v":"$U$51"},{"$f":"ADDRESS(AD5,19)","v":"$S$51"},{"$f":"ADDRESS(AD5,20)","v":"$T$51"},{"$f":"AD4+13","v":51},{"$f":"INDIRECT(ADDRESS(AD5,22))","v":""},"RLP","SK Eifelland Gilzem 2","Gasthaus Dichter"," 4"]
[null,null,null,null,"Spielberichtversand per Fax an:",null,null,null,null,"Ligenleiter:  W. Adolph\n03222 150 4327 ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(INDIRECT(AA6)),INDIRECT(AA6)+(INDIRECT(AB6)/100000)+IF(ISNUMBER(INDIRECT(AC6)),INDIRECT(AC6)/100000000,0),0)","v":0},{"$f":"IF(AND(X6=$Y$1,$Y$1>0),ROW()-2,0)","v":0},{"$f":"5-RANK(X6,$X$3:$X$6,0)","v":4},{"$f":"ADDRESS(AD6,21)","v":"$U$64"},{"$f":"ADDRESS(AD6,19)","v":"$S$64"},{"$f":"ADDRESS(AD6,20)","v":"$T$64"},{"$f":"AD5+13","v":64},{"$f":"INDIRECT(ADDRESS(AD6,22))","v":""},"RLP","KSV Osburg 1","Kegelsportanlage Osburg"," 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meisterrunde",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE3:AE6)","v":0},"RLP","SKV Trier 2","Kegel- u. Bowlingcenter Trier","4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abstiegsrunde",null,null,null,null,null,null,null,null,null,null,null,null,null,"RLP","KSG Idar-Oberstein 1","Hotel Hosser"," 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RLP","SG Mittelrhein-Lonnig 1 ","Sporthalle Erbenstraße ","4"]
["Spielort:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bahn:",1,"-",{"$f":"P10+3","v":4},null,null,null,null,null,"Pass-Nr. nicht gefunden, ggf. im Blatt <Daten> ändern / ergänzen"]
[]
[null,"Spieldatum:",null,null,null,null,null,null,null,null,null,null,null,null,"Spieltag:"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($X$15),\"\",\"Achtung !!!   Mindestens \"&$AB$15&\" Spieler haben \"&ROUND($X$15,0)&\" Holz:  -\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Modalwert"]
["Gastgeber:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($X$15),\"\",INDIRECT(ADDRESS($Y$15,2))&IF($AB$15>2,\", \"&INDIRECT(ADDRESS($AA$15,2)),\"\")&\" und \"&INDIRECT(ADDRESS($Z$15,2))&\" ---- NEUNER und KRÄNZE ermitteln und in der Spalte N/K eintragen.\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MODE(X19:X63)","v":{"$error":"#N/A"}},{"$f":"MIN($Y$19:$Y$63)","v":{"$error":"#N/A"}},{"$f":"MAX($Y$19:$Y$63)","v":{"$error":"#N/A"}},{"$f":"IF(AB15>2,SUM($Y$19:$Y$63)-Y15-Z15,\"\")","v":""},{"$f":"COUNTIF(Y19:Y63,\">0\")","v":0}]
[]
[null,null,null,null,{"$f":"\"Bahn \" & $P$10","v":"Bahn 1"},null,null,{"$f":"\"Bahn \" & RIGHT(E17,2)+1","v":"Bahn 2"},null,null,{"$f":"\"Bahn \" & RIGHT(H17,2)+1","v":"Bahn 3"},null,null,{"$f":"\"Bahn \" & RIGHT(K17,2)+1","v":"Bahn 4"},null,null,null,"Gesamt",null,null,null,null,null,null,"Holz-"]
["Pass-Nr.","Name, Vorname",null,null,"Volle","Abr.","Gesamt","Volle","Abr.","Gesamt","Volle","Abr.","Gesamt","Volle","Abr.","Gesamt",null,"Volle","Abr.","N/K","Holz","EWP",null,"Holz","gleichheit","Rang","Verleich"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(G19),\"\",G19-E19)","v":""},null,null,{"$f":"IF(ISBLANK(J19),\"\",J19-H19)","v":""},null,null,{"$f":"IF(ISBLANK(M19),\"\",M19-K19)","v":""},null,null,{"$f":"IF(ISBLANK(P19),\"\",P19-N19)","v":""},null,null,{"$f":"IF(SUM(E19,H19,K19,N19)>0,SUM(E19,H19,K19,N19),\"\")","v":""},{"$f":"IF(SUM(F19,I19,L19,O19)>0,SUM(F19,I19,L19,O19),\"\")","v":""},null,{"$f":"IF(AND(R19<>\"\",S19<>\"\"),SUM(G19,J19,M19,P19)+(S19/10000)+IF(ISNUMBER(T19),(T19/10000000),0),\"\")","v":""},{"$f":"IF(U19>0,INDIRECT(ADDRESS(ROW(),26)),\"\")","v":""},"x",{"$f":"INDIRECT(ADDRESS(ROW(),COLUMN()-3))","v":""},{"$f":"IF(X19=$X$15,ROW(),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(X19),25-RANK(X19,$X$19:$X$63,0),\"\")","v":""}]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,"Punkte: ",null,{"$f":"IF(U25=\"\",\"\",IF(U25>0,INDIRECT(ADDRESS(ROUND(ROW()/14,0)+1,26)),0))","v":""},{"$f":"\"Mannschaft \"&MIN(Z25:AB25)&\" und \"&MAX(Z25:AB25)&\" haben das gleiche Ergebnis !  Es ent-scheidet nun die größere Zahl von Kränzen und Neunen.\"","v":"Mannschaft 0 und 0 haben das gleiche Ergebnis !  Es ent-scheidet nun die größere Zahl von Kränzen und Neunen."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R19:R24)>0,SUM(R19:R24),\"\")","v":""},{"$f":"IF(SUM(S19:S24)>0,SUM(S19:S24),\"\")","v":""},{"$f":"IF(SUM(T19:T24)>0,SUM(T19:T24),\"\")","v":""},{"$f":"IF(SUM(U19:U24)>0,ROUND(SUM(U19:U24),0),\"\")","v":""},{"$f":"IF(COUNT(V19:V24)>0,SUM(V19:V24),\"\")","v":""},null,{"$f":"ADDRESS(ROUND(ROW()/14,0)+1,COLUMN()+1)","v":"$Y$3"},null,null,{"$f":"INDIRECT(ADDRESS(ROUND(ROW()/14,0)+1,COLUMN()-2))","v":0},{"$f":"MAX(AA$38,AA$51,AA$64)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($X$15),\"\",\"Achtung !!!   Mindestens \"&$AB$15&\" Spieler haben \"&ROUND($X$15,0)&\" Holz:  -\")","v":""}]
["Gast:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($X$15),\"\",INDIRECT(ADDRESS($Y$15,2))&IF($AB$15>2,\", \"&INDIRECT(ADDRESS($AA$15,2)),\"\")&\" und \"&INDIRECT(ADDRESS($Z$15,2))&\" ---- NEUNER und KRÄNZE ermitteln und in der Spalte N/K eintragen.\")","v":""}]
[]
[null,null,null,null,{"$f":"\"Bahn \" & $P$10","v":"Bahn 1"},null,null,{"$f":"\"Bahn \" & RIGHT(E30,2)+1","v":"Bahn 2"},null,null,{"$f":"\"Bahn \" & RIGHT(H30,2)+1","v":"Bahn 3"},null,null,{"$f":"\"Bahn \" & RIGHT(K30,2)+1","v":"Bahn 4"},null,null,null,"Gesamt"]
["Pass-Nr.","Name, Vorname",null,null,"Volle","Abr.","Gesamt","Volle","Abr.","Gesamt","Volle","Abr.","Gesamt","Volle","Abr.","Gesamt",null,"Volle","Abr.","N/K","Holz","EWP"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(G32),\"\",G32-E32)","v":""},null,null,{"$f":"IF(ISBLANK(J32),\"\",J32-H32)","v":""},null,null,{"$f":"IF(ISBLANK(M32),\"\",M32-K32)","v":""},null,null,{"$f":"IF(ISBLANK(P32),\"\",P32-N32)","v":""},null,null,{"$f":"IF(SUM(E32,H32,K32,N32)>0,SUM(E32,H32,K32,N32),\"\")","v":""},"",null,{"$f":"IF(AND(R32<>\"\",S32<>\"\"),SUM(G32,J32,M32,P32)+(S32/10000)+IF(ISNUMBER(T32),(T32/10000000),0),\"\")","v":""},{"$f":"IF(U32>0,INDIRECT(ADDRESS(ROW(),26)),\"\")","v":""},"x",{"$f":"INDIRECT(ADDRESS(ROW(),COLUMN()-3))","v":""},{"$f":"IF(X32=$X$15,ROW(),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(X32),25-RANK(X32,$X$19:$X$63,0),\"\")","v":""}]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,"Punkte: ",null,{"$f":"IF(U38=\"\",\"\",IF(U38>0,INDIRECT(ADDRESS(ROUND(ROW()/14,0)+1,26)),0))","v":""},{"$f":"\"Mannschaft \"&MIN(Z38:AB38)&\" und \"&MAX(Z38:AB38)&\" haben das gleiche Ergebnis !  Es ent-scheidet nun die größere Zahl von Kränzen und Neunen.\"","v":"Mannschaft 0 und 0 haben das gleiche Ergebnis !  Es ent-scheidet nun die größere Zahl von Kränzen und Neunen."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R32:R37)>0,SUM(R32:R37),\"\")","v":""},{"$f":"IF(SUM(S32:S37)>0,SUM(S32:S37),\"\")","v":""},{"$f":"IF(SUM(T32:T37)>0,SUM(T32:T37),\"\")","v":""},{"$f":"IF(SUM(U32:U37)>0,ROUND(SUM(U32:U37),0),\"\")","v":""},{"$f":"IF(COUNT(V32:V37)>0,SUM(V32:V37),\"\")","v":""},null,{"$f":"ADDRESS(ROUND(ROW()/14,0)+1,COLUMN()-2)","v":"$V$4"},null,null,{"$f":"INDIRECT(ADDRESS(ROUND(ROW()/14,0)+1,COLUMN()-2))","v":0},{"$f":"MAX(AA$25,AA$51,AA$64)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($X$15),\"\",\"Achtung !!!   Mindestens \"&$AB$15&\" Spieler haben \"&ROUND($X$15,0)&\" Holz:  -\")","v":""}]
["Gast:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($X$15),\"\",INDIRECT(ADDRESS($Y$15,2))&IF($AB$15>2,\", \"&INDIRECT(ADDRESS($AA$15,2)),\"\")&\" und \"&INDIRECT(ADDRESS($Z$15,2))&\" ---- NEUNER und KRÄNZE ermitteln und in der Spalte N/K eintragen.\")","v":""}]
[]
[null,null,null,null,{"$f":"\"Bahn \" & $P$10","v":"Bahn 1"},null,null,{"$f":"\"Bahn \" & RIGHT(E43,2)+1","v":"Bahn 2"},null,null,{"$f":"\"Bahn \" & RIGHT(H43,2)+1","v":"Bahn 3"},null,null,{"$f":"\"Bahn \" & RIGHT(K43,2)+1","v":"Bahn 4"},null,null,null,"Gesamt"]
["Pass-Nr.","Name, Vorname",null,null,"Volle","Abr.","Gesamt","Volle","Abr.","Gesamt","Volle","Abr.","Gesamt","Volle","Abr.","Gesamt",null,"Volle","Abr.","N/K","Holz","EWP"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(G45),\"\",G45-E45)","v":""},null,null,{"$f":"IF(ISBLANK(J45),\"\",J45-H45)","v":""},null,null,{"$f":"IF(ISBLANK(M45),\"\",M45-K45)","v":""},null,null,{"$f":"IF(ISBLANK(P45),\"\",P45-N45)","v":""},null,null,{"$f":"IF(SUM(E45,H45,K45,N45)>0,SUM(E45,H45,K45,N45),\"\")","v":""},"",null,{"$f":"IF(AND(R45<>\"\",S45<>\"\"),SUM(G45,J45,M45,P45)+(S45/10000)+IF(ISNUMBER(T45),(T45/10000000),0),\"\")","v":""},{"$f":"IF(U45>0,INDIRECT(ADDRESS(ROW(),26)),\"\")","v":""},"x",{"$f":"INDIRECT(ADDRESS(ROW(),COLUMN()-3))","v":""},{"$f":"IF(X45=$X$15,ROW(),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(X45),25-RANK(X45,$X$19:$X$63,0),\"\")","v":""}]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,"Punkte: ",null,{"$f":"IF(U51=\"\",\"\",IF(U51>0,INDIRECT(ADDRESS(ROUND(ROW()/14,0)+1,26)),0))","v":""},{"$f":"\"Mannschaft \"&MIN(Z51:AB51)&\" und \"&MAX(Z51:AB51)&\" haben das gleiche Ergebnis !  Es ent-scheidet nun die größere Zahl von Kränzen und Neunen.\"","v":"Mannschaft 0 und 0 haben das gleiche Ergebnis !  Es ent-scheidet nun die größere Zahl von Kränzen und Neunen."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R45:R50)>0,SUM(R45:R50),\"\")","v":""},{"$f":"IF(SUM(S45:S50)>0,SUM(S45:S50),\"\")","v":""},{"$f":"IF(SUM(T45:T50)>0,SUM(T45:T50),\"\")","v":""},{"$f":"IF(SUM(U45:U50)>0,ROUND(SUM(U45:U50),0),\"\")","v":""},{"$f":"IF(COUNT(V45:V50)>0,SUM(V45:V50),\"\")","v":""},null,null,null,null,{"$f":"INDIRECT(ADDRESS(ROUND(ROW()/14,0)+1,COLUMN()-2))","v":0},{"$f":"MAX(AA$25,AA$38,AA$64)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($X$15),\"\",\"Achtung !!!   Mindestens \"&$AB$15&\" Spieler haben \"&ROUND($X$15,0)&\" Holz:  -\")","v":""}]
["Gast:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($X$15),\"\",INDIRECT(ADDRESS($Y$15,2))&IF($AB$15>2,\", \"&INDIRECT(ADDRESS($AA$15,2)),\"\")&\" und \"&INDIRECT(ADDRESS($Z$15,2))&\" ---- NEUNER und KRÄNZE ermitteln und in der Spalte N/K eintragen.\")","v":""}]
[]
[null,null,null,null,{"$f":"\"Bahn \" & $P$10","v":"Bahn 1"},null,null,{"$f":"\"Bahn \" & RIGHT(E56,2)+1","v":"Bahn 2"},null,null,{"$f":"\"Bahn \" & RIGHT(H56,2)+1","v":"Bahn 3"},null,null,{"$f":"\"Bahn \" & RIGHT(K56,2)+1","v":"Bahn 4"},null,null,null,"Gesamt"]
["Pass-Nr.","Name, Vorname",null,null,"Volle","Abr.","Gesamt","Volle","Abr.","Gesamt","Volle","Abr.","Gesamt","Volle","Abr.","Gesamt",null,"Volle","Abr.","N/K","Holz","EWP"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(G58),\"\",G58-E58)","v":""},null,null,{"$f":"IF(ISBLANK(J58),\"\",J58-H58)","v":""},null,null,{"$f":"IF(ISBLANK(M58),\"\",M58-K58)","v":""},null,null,{"$f":"IF(ISBLANK(P58),\"\",P58-N58)","v":""},null,null,{"$f":"IF(E58+H58+K58+N58>0,E58+H58+K58+N58,\"\")","v":""},{"$f":"IF(SUM(F58,I58,L58,O58)>0,SUM(F58,I58,L58,O58),\"\")","v":""},null,{"$f":"IF(AND(R58<>\"\",S58<>\"\"),SUM(G58,J58,M58,P58)+(S58/10000)+IF(ISNUMBER(T58),(T58/10000000),0),\"\")","v":""},{"$f":"IF(U58>0,INDIRECT(ADDRESS(ROW(),26)),\"\")","v":""},"x",{"$f":"INDIRECT(ADDRESS(ROW(),COLUMN()-3))","v":""},{"$f":"IF(X58=$X$15,ROW(),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(X58),25-RANK(X58,$X$19:$X$63,0),\"\")","v":""}]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,"","",null,"",{"$error":"#N/A"},""]
[null,"Punkte: ",null,{"$f":"IF(U64=\"\",\"\",IF(U64>0,INDIRECT(ADDRESS(ROUND(ROW()/14,0)+1,26)),0))","v":""},{"$f":"\"Mannschaft \"&MIN(Z64:AB64)&\" und \"&MAX(Z64:AB64)&\" haben das gleiche Ergebnis !  Es ent-scheidet nun die größere Zahl von Kränzen und Neunen.\"","v":"Mannschaft 0 und 0 haben das gleiche Ergebnis !  Es ent-scheidet nun die größere Zahl von Kränzen und Neunen."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R58:R63)>0,SUM(R58:R63),\"\")","v":""},{"$f":"IF(SUM(S58:S63)>0,SUM(S58:S63),\"\")","v":""},{"$f":"IF(SUM(T58:T63)>0,SUM(T58:T63),\"\")","v":""},{"$f":"IF(SUM(U58:U63)>0,ROUND(SUM(U58:U63),0),\"\")","v":""},{"$f":"IF(COUNT(V58:V63)>0,SUM(V58:V63),\"\")","v":""},null,null,null,null,{"$f":"INDIRECT(ADDRESS(ROUND(ROW()/14,0)+1,COLUMN()-2))","v":0},{"$f":"MAX(AA$25,AA$38,AA$51)","v":0}]

{"sheet":"SpB","index":1,"n_rows":59,"n_cols":33,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,4,3],[9,18,9,20],[10,18,11,20],[11,2,11,7],[9,1,9,10],[0,4,1,12],[2,4,3,12],[5,4,6,12],[9,14,9,15],[11,14,11,15],[58,1,58,6],[57,12,57,18],[58,12,58,18],[34,11,34,16],[35,11,35,16],[57,1,57,6],[51,2,51,20],[55,0,55,20],[54,0,54,20],[49,14,49,15],[34,1,34,5],[36,11,36,16],[44,0,44,20],[41,0,41,5],[40,0,40,5],[46,14,46,15],[53,0,53,20],[52,0,52,20],[35,1,35,5],[36,1,36,5],[47,12,47,13],[48,12,48,13],[49,12,49,13],[47,14,47,15],[48,14,48,15],[40,10,40,16],[45,12,45,13],[46,12,46,13],[45,14,45,15],[41,10,41,16],[37,11,37,16],[37,1,37,5],[17,11,17,16],[14,11,14,20],[14,1,14,9],[29,1,29,9],[17,1,17,5],[22,11,22,16],[22,1,22,5],[21,1,21,5],[19,1,19,5],[18,1,18,5],[20,11,20,16],[21,11,21,16],[18,11,18,16],[19,11,19,16],[20,1,20,5],[32,1,32,5],[33,1,33,5],[25,10,25,16],[25,0,25,5],[26,0,26,5],[26,10,26,16],[29,11,29,20],[32,11,32,16],[33,11,33,16]]}
["LFV Rhl.-Pfalz e.V.\n- Kegeln -\n\"Sektion Schere\"",null,null,null,"Spielbericht"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W2=0,\"\",W2)","v":""},{"$f":"'SpB m Gassen'!R2","v":"Rheinland-Pfalz-Liga"},null,null,null,null,null,{"$f":"BULI_HE_1","v":0}]
[null,null,null,null,"für",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W3=0,\"\",W3)","v":""},null,null,null,null,null,null,{"$f":"BULI_HE_S","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W4=0,\"\",W4)","v":""},null,null,null,null,null,null,{"$f":"BULI_HE_N","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W5=0,\"\",W5)","v":""},null,null,null,null,null,null,{"$f":"BULI_DA","v":0}]
[null,null,null,null,"Meister- / Abstiegsrunde"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W7=0,\"\",W7)","v":""},"Meisterrunde",null,null,null,null,null,{"$f":"BULI_MR","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W8=0,\"\",W8)","v":""},"Abstiegsrunde",null,"Spielberichtversand:",null,null,null,{"$f":"BULI_AR","v":0}]
[]
["Spielort:",{"$f":"IF(ISBLANK(SPIELORT),\"\",SPIELORT)","v":""},null,null,null,null,null,null,null,null,null,null,"Bahn:",null,{"$f":"IF(ISBLANK(BAHN),1,BAHN)","v":1},null,{"$f":"\"-   \"&O10+3","v":"-   4"},null,"per Fax an:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ligenleiter: W. Adolph \n03222 150 4327 "]
[null,"Spieldatum:",{"$f":"SPIELDATUM","v":"00:00:00"},null,null,null,null,null,null,null,null,null,"Spieltag:",{"$f":"SPNR","v":0},{"$f":"SPNR","v":0}]
[]
[]
["Gastgeber:",{"$f":"IF(ISBLANK(GASTGEBER),\"\",GASTGEBER)","v":""},null,null,null,null,null,null,null,null,"Gast:",{"$f":"IF(ISBLANK(GAST_1),\"\",GAST_1)","v":""}]
[]
["Pass-Nr.","Name, Vorname",null,null,null,null,"EWP","Abr.","N / K","Ergebnis","Pass-Nr.","Name, Vorname",null,null,null,null,null,"EWP","Abr.","N / K","Ergebnis",null,"Zeile","Rang","Adr","Holz","Holz","Adr","Rang","Zeile"]
[{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W18,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W18,1,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W18,2,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W18,2,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W18,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W18,1,,,\"SpB m Gassen\")))","v":""},"","","",{"$f":"IF(J18>0,INDIRECT(ADDRESS(ROW(),24)),\"\")","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W18,19,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W18,19,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W18,20,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W18,20,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W18,21,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W18,21,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD18,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD18,1,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD18,2,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD18,2,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD18,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD18,1,,,\"SpB m Gassen\")))","v":""},null,{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD18,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD18,1,,,\"SpB m Gassen\")))","v":""},"","",{"$f":"IF(U18>0,INDIRECT(ADDRESS(ROW(),29)),\"\")","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD18,19,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD18,19,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD18,20,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD18,20,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD18,21,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD18,21,,,\"SpB m Gassen\")))","v":""},null,19,{"$f":"IF(ISNUMBER(Z18),25-RANK($Z18,$Z$18:$AA$38,0),\"\")","v":""},{"$f":"ADDRESS(ROW(),10)","v":"$J$18"},{"$f":"INDIRECT(Y18)","v":""},{"$f":"INDIRECT(AB18)","v":""},{"$f":"ADDRESS(ROW(),21)","v":"$U$18"},{"$f":"IF(ISNUMBER(AA18),25-RANK($AA18,$Z$18:$AA$38,0),\"\")","v":""},{"$f":"W18+13","v":32}]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W18+1","v":20},"","$J$19","","","$U$19","",33]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W19+1","v":21},"","$J$20","","","$U$20","",34]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W20+1","v":22},"","$J$21","","","$U$21","",35]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W21+1","v":23},"","$J$22","","","$U$22","",36]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W22+1","v":24},"","$J$23","","","$U$23","",37]
[null,"Punkte:",{"$f":"IF(ISERROR(AF24),\"\",IF(AF24>0,RANK(AF24,$AF$24:$AF$40,TRUE),0))","v":0},null,null,null,{"$f":"IF(COUNT(G18:G23)>0,SUM(G18:G23),\"\")","v":""},{"$f":"IF(COUNT(H18:H23)>0,SUM(H18:H23),\"\")","v":""},{"$f":"IF(COUNT(I18:I23)>0,SUM(I18:I23),\"\")","v":""},{"$f":"IF(COUNT(J18:J23)>0,ROUNDDOWN(SUM(J18:J23),0),\"\")","v":""},null,"Punkte: ",{"$f":"IF(ISERROR(AF25),\"\",IF(AF25>0,RANK(AF25,$AF$24:$AF$40,TRUE),0))","v":0},null,null,null,null,{"$f":"IF(COUNT(R18:R23)>0,SUM(R18:R23),\"\")","v":""},{"$f":"IF(COUNT(S18:S23)>0,SUM(S18:S23),\"\")","v":""},{"$f":"IF(COUNT(T18:T23)>0,SUM(T18:T23),\"\")","v":""},{"$f":"IF(COUNT(U18:U23)>0,ROUNDDOWN(SUM(U18:U23),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"ADDRESS(24,8)","v":"$H$24"},{"$f":"ADDRESS(24,9)","v":"$I$24"},{"$f":"ADDRESS(24,10)","v":"$J$24"},{"$f":"IF(ISNUMBER(INDIRECT(AE24)),INDIRECT(AE24)+(INDIRECT(AC24)/10000)+IF(ISNUMBER(INDIRECT(AD24)),INDIRECT(AD24)/10000000,0),0)","v":0},{"$f":"IF(ISNUMBER(AF24),5-RANK($AF24,$AF$24:$AF$40,0),\"\")","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ADDRESS(24,19)","v":"$S$24"},{"$f":"ADDRESS(24,20)","v":"$T$24"},{"$f":"ADDRESS(24,21)","v":"$U$24"},{"$f":"IF(ISNUMBER(INDIRECT(AE25)),INDIRECT(AE25)+(INDIRECT(AC25)/10000)+IF(ISNUMBER(INDIRECT(AD25)),INDIRECT(AD25)/10000000,0),0)","v":0},{"$f":"IF(ISNUMBER(AF25),5-RANK($AF25,$AF$24:$AF$40,0),\"\")","v":4}]
[]
["(Unterschrift Mannschaftsführer)",null,null,null,null,null,null,null,null,null,"(Unterschrift Mannschaftsführer)"]
[]
[]
["Gast:",{"$f":"IF(ISBLANK(GAST_2),\"\",GAST_2)","v":""},null,null,null,null,null,null,null,null,"Gast:",{"$f":"IF(ISBLANK(GAST_3),\"\",GAST_3)","v":""}]
[]
["Pass-Nr.","Name, Vorname",null,null,null,null,"EWP","Abr.","N / K","Ergebnis","Pass-Nr.","Name, Vorname",null,null,null,null,null,"EWP","Abr.","N / K","Ergebnis",null,"Zeile","Rang","Adr","Holz","Holz","Adr","Rang","Zeile"]
[{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W33,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W33,1,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W33,2,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W33,2,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W33,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W33,1,,,\"SpB m Gassen\")))","v":""},"","","",{"$f":"IF(J33>0,INDIRECT(ADDRESS(ROW(),24)),\"\")","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W33,19,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W33,19,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W33,20,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W33,20,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($W33,21,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($W33,21,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD33,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD33,1,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD33,2,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD33,2,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD33,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD33,1,,,\"SpB m Gassen\")))","v":""},null,{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD33,1,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD33,1,,,\"SpB m Gassen\")))","v":""},"","",{"$f":"IF(U33>0,INDIRECT(ADDRESS(ROW(),29)),\"\")","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD33,19,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD33,19,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD33,20,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD33,20,,,\"SpB m Gassen\")))","v":""},{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($AD33,21,,,\"SpB m Gassen\"))),\"\",INDIRECT(ADDRESS($AD33,21,,,\"SpB m Gassen\")))","v":""},null,{"$f":"AD18+13","v":45},{"$f":"IF(ISNUMBER(Z33),25-RANK($Z33,$Z$18:$AA$38,0),\"\")","v":""},{"$f":"ADDRESS(ROW(),10)","v":"$J$33"},{"$f":"INDIRECT(Y33)","v":""},{"$f":"INDIRECT(AB33)","v":""},{"$f":"ADDRESS(ROW(),21)","v":"$U$33"},{"$f":"IF(ISNUMBER(AA33),25-RANK($AA33,$Z$18:$AA$38,0),\"\")","v":""},{"$f":"W33+13","v":58}]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W33+1","v":46},"","$J$34","","","$U$34","",59]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W34+1","v":47},"","$J$35","","","$U$35","",60]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W35+1","v":48},"","$J$36","","","$U$36","",61]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W36+1","v":49},"","$J$37","","","$U$37","",62]
["","","","","","","","","","","","","",null,"","","","","","","",null,{"$f":"W37+1","v":50},"","$J$38","","","$U$38","",63]
[null,"Punkte: ",{"$f":"IF(ISERROR(AF39),\"\",IF(AF39>0,RANK(AF39,$AF$24:$AF$40,TRUE),0))","v":0},null,null,null,{"$f":"IF(COUNT(G33:G38)>0,SUM(G33:G38),\"\")","v":""},{"$f":"IF(COUNT(H33:H38)>0,SUM(H33:H38),\"\")","v":""},{"$f":"IF(COUNT(I33:I38)>0,SUM(I33:I38),\"\")","v":""},{"$f":"IF(COUNT(J33:J38)>0,ROUNDDOWN(SUM(J33:J38),0),\"\")","v":""},null,"Punkte: ",{"$f":"IF(ISERROR(AF40),\"\",IF(AF40>0,RANK(AF40,$AF$24:$AF$40,TRUE),0))","v":0},null,null,null,null,{"$f":"IF(COUNT(R33:R38)>0,SUM(R33:R38),\"\")","v":""},{"$f":"IF(COUNT(S33:S38)>0,SUM(S33:S38),\"\")","v":""},{"$f":"IF(COUNT(T33:T38)>0,SUM(T33:T38),\"\")","v":""},{"$f":"IF(COUNT(U33:U38)>0,ROUNDDOWN(SUM(U33:U38),0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"ADDRESS(39,8)","v":"$H$39"},{"$f":"ADDRESS(39,9)","v":"$I$39"},{"$f":"ADDRESS(39,10)","v":"$J$39"},{"$f":"IF(ISNUMBER(INDIRECT(AE39)),INDIRECT(AE39)+(INDIRECT(AC39)/10000)+IF(ISNUMBER(INDIRECT(AD39)),INDIRECT(AD39)/10000000,0),0)","v":0},{"$f":"IF(ISNUMBER(AF39),5-RANK($AF39,$AF$24:$AF$40,0),\"\")","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(AD40)","v":""},null,{"$f":"ADDRESS(39,19)","v":"$S$39"},{"$f":"ADDRESS(39,20)","v":"$T$39"},{"$f":"ADDRESS(39,21)","v":"$U$39"},{"$f":"IF(ISNUMBER(INDIRECT(AE40)),INDIRECT(AE40)+(INDIRECT(AC40)/10000)+IF(ISNUMBER(INDIRECT(AD40)),INDIRECT(AD40)/10000000,0),0)","v":0},{"$f":"IF(ISNUMBER(AF40),5-RANK($AF40,$AF$24:$AF$40,0),\"\")","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MODE(AF24:AF40)","v":0}]
["(Unterschrift Mannschaftsführer)",null,null,null,null,null,null,null,null,null,"(Unterschrift Mannschaftsführer)"]
[]
[]
["T a b e l l e *)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MODE(Z18:AA38)","v":{"$error":"#N/A"}},"Modalwert","Ergebnis"]
[null,null,null,null,null,"Vorgabe\nPunkte","1. Tag\nPunkte","2. Tag\nPunkte","3. Tag\nPunkte","4. Tag\nPunkte","Gesamt\nPunkte",null,"1. Tag\nEWP",null,"2. Tag\nEWP",null,"3. Tag\nEWP","4. Tag\nEWP","Gesamt\nEWP",null,"Ges.\nRang",null,null,null,null,{"$f":"($Z$45-ROUNDDOWN($Z$45,0))*10000","v":{"$error":"#N/A"}},"Modalwert","Abräumen"]
[{"$f":"IF(ISBLANK(GASTGEBER),\"\",GASTGEBER)","v":""},null,null,null,null,1,null,null,null,null,{"$f":"IF(SUM(F47:J47)>0,SUM(F47:J47)+IF(ISNUMBER(S47),S47/1000,0),\"\")","v":1},null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(F47),SUM(M47:R47),\"\")","v":0},null,{"$f":"IF(ISNUMBER(K47),RANK(K47,$K$47:$K$50,FALSE),\"\")","v":4},null,null,null,null,{"$f":"($Z$45-ROUNDDOWN($Z$45,4))*10000000","v":{"$error":"#N/A"}},"Modalwert","N / K"]
[{"$f":"IF(ISBLANK(GAST_1),\"\",GAST_1)","v":""},null,null,null,null,2,null,null,null,null,{"$f":"IF(SUM(F48:J48)>0,SUM(F48:J48)+IF(ISNUMBER(S48),S48/1000,0),\"\")","v":2},null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(F48),SUM(M48:R48),\"\")","v":0},null,{"$f":"IF(ISNUMBER(K48),RANK(K48,$K$47:$K$50,FALSE),\"\")","v":3}]
[{"$f":"IF(ISBLANK(GAST_2),\"\",GAST_2)","v":""},null,null,null,null,3,null,null,null,null,{"$f":"IF(SUM(F49:J49)>0,SUM(F49:J49)+IF(ISNUMBER(S49),S49/1000,0),\"\")","v":3},null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(F49),SUM(M49:R49),\"\")","v":0},null,{"$f":"IF(ISNUMBER(K49),RANK(K49,$K$47:$K$50,FALSE),\"\")","v":2}]
[{"$f":"IF(ISBLANK(GAST_3),\"\",GAST_3)","v":""},null,null,null,null,4,null,null,null,null,{"$f":"IF(SUM(F50:J50)>0,SUM(F50:J50)+IF(ISNUMBER(S50),S50/1000,0),\"\")","v":4},null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(F50),SUM(M50:R50),\"\")","v":0},null,{"$f":"IF(ISNUMBER(K50),RANK(K50,$K$47:$K$50,FALSE),\"\")","v":1}]
["*) Die Tabelle wird nicht automatisch beschrieben, bitte nach jedem Spiel ausfüllen !"]
["Bemerkungen:"]
[]
[]
[]
[]
[]
[null,"entfällt",null,null,null,null,null,null,null,null,null,null,"entfällt"]
[null,"(Unterschrift Schiedsrichter)",null,null,null,null,null,null,null,null,null,null,"(Unterschrift Schiedsrichter)"]

{"sheet":"Ausfüllhilfe","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,2,2,3],[0,0,0,3]]}
["Ausfüllhilfe zum Spielbericht für Meister- und Abstiegsrunde"]
[null,"Tätigkeit","Beschreibung","Mögliche Fehler bzw. Auswirkungen"]
[{"$f":"ROW()-2","v":1},"Allgemeine Informationen","Systemvoraussetzungen: MS Excel 2000 und höher. Die im Hintergrund laufenden Makros arbeiten nur, wenn die Makro-Sicherheit im Menü \"/Extras/Makro/Sicherheit\" auf niedrig gestellt wird. Wird die Sicherheitsstufe geändert, muss Excel geschlossen werden und das Tool danach neu aufgerufen werden. In Excel 2007 muss ähnlich verfahren werden - jedoch unter anderen Menüpunkten.\nDamit die hinterlegten Kommentare nicht dauernd sichtbar sind, Kommentar-Option unter /Menü/Extras/Optionen/Ansicht/ - Komentare auf \"nur Indikatoren\" einstellen.\n\nEs dürfen in keinem Fall Zeilen und Spalten hinzugefügt werden, sonst werden Zellverweise zerstört!\nSoll der Spielbericht als Blanko-Formular genutzt werden, müssen alle weißen Felder leer sein.\n\nDie Beschreibungsfelder und automatisch ausgefüllte Felder sind für die Eingabe gesperrt, damit der Spielbericht die einheitliche Form behält. Außerdem können so die hinterlegten Formeln und Makros nicht zerstört werden.\n\nVor dem Drucken oder Seitenansicht wird der Spielbericht auf Eingabefehler hin überprüft.\nBestimmte Felder werden auf Gültigkeit der Eingaben überwacht.\nBei bestimmten Feldern wird eine Direkthilfe bei Anklicken des Feldes angezeigt.\n\nDas Ergebnis von gleichen Gesamtholzzahlen (siehe Punkt 7) wird überwacht und signalisiert. Ein Spieler der Mannschaft mit der höheren Gesamtabräumzahl bekommt dann eine Kommastelle hinzugefügt.\n"]
[{"$f":"ROW()-2","v":2},"Ausfüllen des Spielberichtes im Tabellenblatt \n\"SpB m Gassen\"","Alle Daten werden im \"SpB m Gassen\" eingegeben!\nDer zu versendende Spielbericht befindet sich im Blatt \"SpB\"!","Die Funktion \"Makro\" ist deaktiviert. Siehe Systemvoraussetzungen.\n\nDas Tabellenblatt wurde in eine andere Datei kopiert. Dadurch fehlt die dazugehörige Makrofunktion"]
[3,"Ausfüllen des Spielberichtes im Tabellenblatt \n\"SpB\"","Alle Daten, bis auf die Tabelle, werden automatisch aus dem \"SpB m Gassen\" übernommen.\nDie Tabelle ist bei jedem Spieltag händisch aktuell zu halten."]
[4,"Gleiche Holzzahlen bei Ergebnis und Abräumen","In diesem Fall sind die betreffenden Felder \"rot\" hinterlegt. Zur Ermittlung, wer den höheren EWP erhält, dient einmal das Abräumergebnis. Ist dies auch gleich, dann wird nach LfV-SpO Ziffer 7.ff weiter selektiert, \"Neuner\" und \"Kränze\", usw.! Der ermittelte Wert wird in das entsprechende Feld mit der Überschrift \"N/K\" eingetragen. "]
[5,"Auswahlfelder \"Liga\"","Die Auswahl der Liga erfolgt mit einem Doppelklick mit der linken Maustaste auf das entsprechende Feld. Bei nochmaligen Doppelklicken wird die Auswahl wieder aufgehoben.\n","Die Funktion \"Makro\" ist deaktiviert. Siehe Systemvoraussetzungen.\n\nDas Tabellenblatt wurde in eine andere Datei kopiert. Dadurch fehlt die dazugehörige Makrofunktion"]
[6,"Auswahlfelder \"Meisterrunde / Abstiegsrunde\"","Die Auswahl erfolgt mit einem Doppelklick mit der linken Maustaste auf das entsprechende Feld. Bei nochmaligen Doppelklicken wird die Auswahl wieder aufgehoben.\n","Die Funktion \"Makro\" ist deaktiviert.\n\nDas Tabellenblatt wurde in eine andere Datei kopiert. Dadurch fehlt die dazugehörige Makrofunktion"]
[7,"Eingabefeld \"Datum\"","Es wird nur ein gültiger Datumswert zugelassen.\n\n","Nur Eingabeformate \"TT.MM.JJJJ\" oder \"TT.MM.JJ\" sind zugelassen. Nicht existierende Tage werden als Fehleingabe angezeit."]
[8,"Eingabefeld \"Spiel-Nr\"","Es wird nur eine gültige Spiel-Nr. (1 - 4) zugelassen.\n","Es werden nur Zahlen zwischen 1 und 90 akzeptiert."]
[9,"Eingabefelder \"Gastgeber, Gast\"","Wenn man auf das Feld klickt, erscheint rechts ein Pfeil für das Listenfeld. Im Listenfeld kann der gewünschte Klub ausgewählt werden.\nWird im Listenfeld \"Gastgeber\" ausgewählt, wird automatisch der Spielort und Bahn beschrieben."]
[7,"Eingabe der Spielerdaten;\nhier:  Pass-Nr. und Name","Wichtig:\nEs ist mit dem Buchstaben \" D \" zu beginnen !"]
[11,"Drucken bzw. Seitenansicht","Vor dem Ausdrucken bzw. Seitenansicht wird der Spielbericht auf mögliche Fehler überprüft.\n- Auswahl \"Liga\"\n- Auswahl \"Meister- / Abstiegsrunde\"\n- Eintrag \"Datum\"\n- Eintrag \"Spiel-Nr.\"\n- Eintrag \"Spielort\"\n","Falls negativ, kommt Abfrage, ob man trotzdem drucken will.\n"]
[12,"Ansprechpartner","Ligenleiter RLP-Liga Herren\nWalter Adolph\nTel. 06781 / 3 36 35\nFax 03222 150 4327\nMobil +49 170 3513534\nWalter.Adolph@t-online.de\n"]