{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Titelblatt","Kontrollblatt","Liste"],"not_rendered":{"charts":0,"images":2,"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":"Titelblatt","index":0,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[8,0,8,6],[19,1,19,4],[25,2,25,3],[26,2,26,3],[9,0,9,6],[18,1,18,6],[13,1,13,4],[15,1,15,4],[17,1,17,4],[39,0,39,1],[30,0,32,6],[34,0,34,6],[22,1,22,4],[20,1,20,4]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Anleitung zum Ausfüllen"]
[null,null,null,null,null,null,null,null,null,"Schritt 1: Titelblatt ausfüllen"]
[null,null,null,null,null,null,null,null,null,"Schritt a: Distanz anhand der Liste auswählen"]
["www.sksg.ch",null,null,null,null,null,null,null,null,"Schritt b: Verein anhand der Liste auswählen "]
[null,null,null,null,null,null,null,null,null,"Schritt c: Informationen vom Verantwortlichen ausfüllen "]
["Abrechnung Kantonaler Spezialstich",null,null,null,null,null,null,null,null,"Schritt d: Standblatt Bestellung für das nächste Jahr ausfüllen "]
[{"$f":"YEAR(G12)","v":2023},null,null,null,null,null,null,null,null,"Schritt 2: Kontrollblatt ausfüllen"]
[null,null,null,null,null,null,null,null,null,"Schritt a: Name ausfüllen"]
[null,null,null,null,null,"Datum:",{"$f":"TODAY()","v":"2023-03-26"},null,null,"Schritt b: Vorname ausfüllen"]
[null,null,null,null,null,null,null,null,null,"Schritt c: Jahrgang ausfüllen (die Kategorie wird automatisch zugeteilt) "]
["Distanz:",null,null,null,null,null,null,null,null,"Schritt d: Sportgerät anhand der Liste auswählen "]
[null,null,null,null,null,null,null,null,null,"Schritt e: Resultate eintragen (Kranzresultate und die entsprechende KK werden automatisch ausgefüllt) "]
["Verein: "]
[null,null,null,null,null,null,null,null,null,"Schritt 3: die Excel Datei an renate.peters@sksg.ch schicken und den Totalbetrag vom Titelblatt an die SKSG überweisen "]
["Verantwortlicher:"]
[]
["Adresse:"]
[]
[]
["Email-Adresse:"]
[]
[]
[{"$f":"Kontrollblatt!G58","v":0},null,"Anzahl Hauptdoppel",null,"à CHF 13.00 ","=",{"$f":"13*A26","v":0}]
[{"$f":"SUM(Kontrollblatt!H58:K58)","v":0},null,"Anzahl Nachdoppel",null,"à CHF 3.00 ","=",{"$f":"3*A27","v":0}]
[]
["Totalbetrag",null,null,null,null,"=",{"$f":"G26+G27","v":0}]
[]
["Die Standblätter mit den Resultaten sind bis spätestens 31. Oktober an die verantwortliche Person \"Kantonaler Spezialstich\" gemäss Vorstandsverzeichnis www.sksg.ch zurückzusenden. "]
[]
[]
[]
["Der Totalbetrag ist bis spätestens 31. Oktober auf IBAN CH73 0077 7001 3003 0106 5 z.G. Schwyzer Kantonal-Schützengesellschaft, 6430 Schwyz zu überweisen. "]
[]
["Für eine prompte Erledigung dankt der Vorstand. "]
[]
[]
["Standblatt Bestellung für ",null,{"$f":"A10+1","v":2024}]

{"sheet":"Kontrollblatt","index":1,"n_rows":58,"n_cols":31,"rows_kept":58,"cut":false,"hidden":false,"merged":[[23,15,24,15],[25,15,27,15],[17,15,22,15],[0,0,5,8],[15,0,16,0],[15,1,16,1],[15,2,16,2],[6,0,6,1],[8,0,8,13],[9,2,9,10],[11,2,11,5],[13,2,13,5]]}
[]
[]
[]
[]
[]
[]
["www.sksg.ch"]
[]
["Kontrollblatt Kantonaler Spezialstich "]
[null,null,{"$f":"YEAR(Titelblatt!G12)","v":2023}]
[]
[null,"Distanz:",{"$f":"IF(Titelblatt!B14 =\"\",\"\",Titelblatt!B14)","v":""}]
[]
[null,"Verein: ",{"$f":"IF(Titelblatt!B16 =\"\",\"\",Titelblatt!B16)","v":""}]
[]
["Nr. ","Name","Vorname","JG","Kate-","Sportgerät","HD","1. ND","2. ND","3. ND","4. ND ","Kranz-","KK","KK ",null,null,null,null,null,null,null,null,null,"HD","1. ND","2. ND","3. ND","4. ND ",null,"Kat","Spaltenindex"]
[null,null,null,"YYYY","gorie",{"$f":"IF(C12=\"G300m\",\"W300m\",IF(C12=\"P50m\",\"W50m\",IF(C12=\"\",\"\",\"W25m\")))","v":""},"Pkt.","Pkt.","Pkt.","Pkt.","Pkt. ","Resultate","10CHF","12CHF",null,null,null,"U17","U21","E/S","V","SV",null,null,null,null,null,null,null,"U17",2]
[1,null,null,null,{"$f":"IF(D18<>\"\",IF(ABS(D18-$C$10)>=60,IF(ABS(D18-$C$10)>=70,IF(ABS(D18-$C$10)>100,\" \",\"SV\"),\"V\"),IF(ABS(D18-$C$10)<=16,\"U17\",IF(ABS(D18-$C$10)<=20,\"U21\",\"E\"))),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(SUM(X18:AB18),\"\")","v":""},{"$f":"IF(L18=1,\"X\",IF(L18=2,\"X\",\" \"))","v":" "},{"$f":"IF(L18=3,\"X\",IF(L18=4,\"X\",IF(L18=5,\"X\",\" \")))","v":" "},null,"300m ","Standardgewehr",87,88,90,88,87,null,{"$f":"IF(G18>= VLOOKUP($F18,$Q$18:$V$28,VLOOKUP($E18,$AD$17:$AE$21,2,FALSE),FALSE),1,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(I18>= VLOOKUP($F18,$Q$18:$V$28,VLOOKUP($E18,$AD$17:$AE$21,2,FALSE),FALSE),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(J18>= VLOOKUP($F18,$Q$18:$V$28,VLOOKUP($E18,$AD$17:$AE$21,2,FALSE),FALSE),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(K18>= VLOOKUP($F18,$Q$18:$V$28,VLOOKUP($E18,$AD$17:$AE$21,2,FALSE),FALSE),1,0)","v":{"$error":"#N/A"}},null,"U21",3]
[2,null,null,null,{"$f":"IF(D19<>\"\",IF(ABS(D19-$C$10)>=60,IF(ABS(D19-$C$10)>=70,IF(ABS(D19-$C$10)>100,\" \",\"SV\"),\"V\"),IF(ABS(D19-$C$10)<=16,\"U17\",IF(ABS(D19-$C$10)<=20,\"U21\",\"E\"))),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(SUM(X19:AB19),\"\")","v":""},{"$f":"IF(L19=1,\"X\",IF(L19=2,\"X\",\" \"))","v":" "},{"$f":"IF(L19=3,\"X\",IF(L19=4,\"X\",IF(L19=5,\"X\",\" \")))","v":" "},null,null,"Freigewehr",87,88,90,88,87,null,{"$f":"IF(G19>= VLOOKUP($F19,$Q$18:$V$28,VLOOKUP($E19,$AD$17:$AE$21,2,FALSE),FALSE),1,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"E",4]
[3,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L20=1,\"X\",IF(L20=2,\"X\",\" \"))","v":" "}," ",null,null,"Karabiner",80,81,83,81,80,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"V",5]
[4,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,"Stgw57/03",83,84,86,84,83,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"SV",6]
[5,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,"Stgw57/02",78,79,81,79,78,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,"Stgw90",80,81,83,81,80,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,null,null,null,"",null,null,null,null,null,null,""," "," ",null,"25m","SPK 25m",174,178,182,178,174,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,"OP 25m",168,170,174,170,168,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,null,null,null,"",null,null,null,null,null,null,""," "," ",null,"50m","FP 50m",87,88,90,88,87,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,"RP 50m",82,84,86,84,82,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[11,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,"OP 50m",80,81,83,81,80,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[12,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[13,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[14,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[15,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[16,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[17,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[18,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[19,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[20,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[21,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[22,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[23,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[24,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[25,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[26,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[27,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[28,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[29,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[30,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[31,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[32,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[33,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[34,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[35,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[36,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[37,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[38,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[39,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[40,null,null,null,"",null,null,null,null,null,null,""," "," ",null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,"Total",{"$f":"COUNTA(G18:G57)","v":0},{"$f":"COUNTA(H18:H57)","v":0},0,0,0,null,{"$f":"COUNTIF(M18:M57,\"X\")","v":0},{"$f":"COUNTIF(N18:N57,\"X\")","v":0}]

{"sheet":"Liste","index":2,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Distanz",null,"G300m","P25m","P50m",null,"Waffe",null,"W300m","W25m","W50m"]
["G300m",null,"Altendorf, FS","Einsiedeln, PS","Brunnen, PS",null,"W300m",null,"Standardgewehr","SPK 25m","FP 50m"]
["P25m",null,"Bennau, SG","Pistolenschützen am Rigi","Einsiedeln, PS",null,"W25m",null,"Freigewehr","OP 25m","RF 50m"]
["P50m",null,"Brunnen, StSG","Pfäffikon, PS am Etzel","Pistolenschützen am Rigi",null,"W50m",null,"Karabiner",null,"OP 50m"]
[null,null,"Brunnen-Ingenbohl, MSV",null,"Lachen-Altendorf, PS",null,null,null,"Stgw57/03"]
[null,null,"Einsiedeln, SV Tell",null,"Pfäffikon, PS am Etzel",null,null,null,"Stgw57/02"]
[null,null,"Einsiedeln, SG",null,"Schwyz, PS UOV",null,null,null,"Stgw90"]
[null,null,"Feusisberg, FSS"]
[null,null,"Freienbach-Pfäffikon, SV"]
[null,null,"Galgenen, ISV"]
[null,null,"Gersau, SG"]
[null,null,"Ibach-Schönenbuch, SV"]
[null,null,"Innerthal, FSG"]
[null,null,"Küssnacht, BS"]
[null,null,"Lachen, SV"]
[null,null,"Lauerz, StSG"]
[null,null,"Morschach, SG"]
[null,null,"Muotathal, SG"]
[null,null,"Oberiberg, SG"]
[null,null,"Reichenburg, FS"]
[null,null,"Ried-Muotathal, FSG"]
[null,null,"Rothenthurm, FSV"]
[null,null,"Sattel, FSV"]
[null,null,"Schindellegi, SV"]
[null,null,"Schindellegi-Rossberg, FSV"]
[null,null,"Schübelbach, GS"]
[null,null,"Schwyz, SG"]
[null,null,"Schwyz-Burg, FSG"]
[null,null,"Seewen, SV"]
[null,null,"Steinen, SG"]
[null,null,"Steinerberg, SG"]
[null,null,"Trachslau, SG"]
[null,null,"Tuggen, SG"]
[null,null,"Unteriberg, SG"]
[null,null,"Vorderthal, MSV"]
[null,null,"Wilen-Wollerau, MSV"]
[null,null,"Willerzell, MSV"]
[null,null,"Wollerau, SV"]