{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Abrechnung BFV Ascota","Helper"],"not_rendered":{"images":1,"defined_names":7,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Abrechnung BFV Ascota","index":0,"n_rows":108,"n_cols":10,"rows_kept":108,"merged":[[0,1,0,4],[0,5,0,6],[0,7,0,9],[1,1,1,4],[1,7,1,9],[2,1,2,4],[2,7,2,9],[3,7,3,9],[4,7,4,9]]}
["Name:",{"$nulls":4},"Lizenznummern:"]
["Jahr:",{"$nulls":4},"Std (Ges/Detail):",null,{"$f":"SUM(E10:E545)&\" (\"&SUMIF(F10:F545,\"ohne Lizenz\",E10:E545)&\" / \"&SUMIF(F10:F545,\"Land/Schwimmen\",E10:E545) &\" / \"&SUMIF(F10:F545,\"Lunge/Wgym\",E10:E545)&\")\"","v":"0 (0 / 0 / 0)"}]
["Quartal:",{"$nulls":4},{"$f":"IF(B3=\"1. Quartal\",\"Std (Jan/Feb/Mar):\",IF(B3=\"2. Quartal\",\"Std (Apr/Mai/Jun):\",IF(B3=\"3. Quartal\",\"Std (Jul/Aug/Sep):\",IF(B3=\"4. Quartal\",\"Std (Okt/Nov/Dez):\",\"\"))))","v":""},null,{"$f":"SUMIF(A10:A545,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",2,IF(B3=\"2. Quartal\",5,IF(B3=\"3. Quartal\",8,IF(B3=\"4. Quartal\",11)))),1),E10:E545)-SUMIF(A10:A545,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",1,IF(B3=\"2. Quartal\",4,IF(B3=\"3. Quartal\",7,IF(B3=\"4. Quartal\",10)))),1),E10:E545) &\" / \"& SUMIF(A10:A545,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",3,IF(B3=\"2. Quartal\",6,IF(B3=\"3. Quartal\",9,IF(B3=\"4. Quartal\",12)))),1),E10:E545)-SUMIF(A10:A545,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",2,IF(B3=\"2. Quartal\",5,IF(B3=\"3. Quartal\",8,IF(B3=\"4. Quartal\",11)))),1),E10:E545) &\" / \"& SUMIF(A10:A545,\"<\"&DATE(IF(B3=\"4. Quartal\",B2+1,B2),IF(B3=\"1. Quartal\",4,IF(B3=\"2. Quartal\",7,IF(B3=\"3. Quartal\",10,IF(B3=\"4. Quartal\",1)))),1),E10:E545)-SUMIF(A10:A545,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",3,IF(B3=\"2. Quartal\",6,IF(B3=\"3. Quartal\",9,IF(B3=\"4. Quartal\",12)))),1),E10:E545)","v":"0 / 0 / 0"}]
[{"$nulls":5},"€ (Ges/Detail):",null,{"$f":"SUM(I10:I545)&\"€ (\"&SUMIF(F10:F545,\"ohne Lizenz\",I10:I545)&\"€ / \"&SUMIF(F10:F545,\"Land/Schwimmen\",I10:I545)&\"€ / \"&SUMIF(F10:F545,\"Lunge/Wgym\",I10:I545)&\"€)\"","v":"0€ (0€ / 0€ / 0€)"}]
[{"$nulls":5},{"$f":"IF(B3=\"1. Quartal\",\"€ (Jan/Feb/Mar):\",IF(B3=\"2. Quartal\",\"€ (Apr/Mai/Jun):\",IF(B3=\"3. Quartal\",\"€ (Jul/Aug/Sep):\",IF(B3=\"4. Quartal\",\"€ (Okt/Nov/Dez):\",\"\"))))","v":""},null,{"$f":"SUMIF(A10:A919,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",2,IF(B3=\"2. Quartal\",5,IF(B3=\"3. Quartal\",8,IF(B3=\"4. Quartal\",11)))),1),I10:I919)-SUMIF(A10:A919,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",1,IF(B3=\"2. Quartal\",4,IF(B3=\"3. Quartal\",7,IF(B3=\"4. Quartal\",10)))),1),I10:I919) &\"€ / \"& SUMIF(A10:A919,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",3,IF(B3=\"2. Quartal\",6,IF(B3=\"3. Quartal\",9,IF(B3=\"4. Quartal\",12)))),1),I10:I919)-SUMIF(A10:A919,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",2,IF(B3=\"2. Quartal\",5,IF(B3=\"3. Quartal\",8,IF(B3=\"4. Quartal\",11)))),1),I10:I919) &\"€ / \"& SUMIF(A10:A919,\"<\"&DATE(IF(B3=\"4. Quartal\",B2+1,B2),IF(B3=\"1. Quartal\",4,IF(B3=\"2. Quartal\",7,IF(B3=\"3. Quartal\",10,IF(B3=\"4. Quartal\",12)))),1),I10:I919)-SUMIF(A10:A919,\"<\"&DATE(B2,IF(B3=\"1. Quartal\",3,IF(B3=\"2. Quartal\",6,IF(B3=\"3. Quartal\",9,IF(B3=\"4. Quartal\",12)))),1),I10:I919)&\"€\"","v":"0€ / 0€ / 0€"}]
[]
["Datum","Tag","von","bis","Std","Tätigkeit","Bem.","AE/Std","AE/Ges","Ort"]
["1900-01-01",{"$f":"IF(A8=\"\",\"\",TEXT(A8,\"TTT\"))","v":"So"},"07:00:00","08:30:00",{"$f":"IF(C8=\"\",\"\",IF(D8=\"\",\"\",(HOUR(D8-C8)*60+MINUTE(D8-C8))/60))","v":1.5},"Land/Schwimmen",null,{"$f":"IF(F8=\"ohne Lizenz\",5,IF(F8=\"Land/Schwimmen\",10,IF(F8=\"Lunge/Wgym\",15,\"\")))","v":{"v":10,"d":"10.00 €"}},{"$f":"IF(H8=\"\",\"\",E8*H8)","v":{"v":15,"d":"15.00 €"}},"Südring, Max-Schäller-Str. 5, 09122 Ch."]
[]
[null,{"$f":"IF(A10=\"\",\"\",TEXT(A10,\"TTT\"))","v":""},null,null,{"$f":"IF(C10=\"\",\"\",IF(D10=\"\",\"\",(HOUR(D10-C10)*60+MINUTE(D10-C10))/60))","v":""},null,null,{"$f":"IF(F10=\"ohne Lizenz\",5,IF(F10=\"Land/Schwimmen\",10,IF(F10=\"Lunge/Wgym\",15,\"\")))","v":""},{"$f":"IF(H10=\"\",\"\",E10*H10)","v":""}]
[null,{"$f":"IF(A11=\"\",\"\",TEXT(A11,\"TTT\"))","v":""},null,null,{"$f":"IF(C11=\"\",\"\",IF(D11=\"\",\"\",(HOUR(D11-C11)*60+MINUTE(D11-C11))/60))","v":""},null,null,{"$f":"IF(F11=\"ohne Lizenz\",5,IF(F11=\"Land/Schwimmen\",10,IF(F11=\"Lunge/Wgym\",15,\"\")))","v":""},{"$f":"IF(H11=\"\",\"\",E11*H11)","v":""}]
[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,"",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,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,"",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,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,"",""]
[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,"",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,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,"",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,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,"",""]
[null,"",null,null,"",null,null,"",""]
[null,{"$f":"IF(A75=\"\",\"\",TEXT(A75,\"TTT\"))","v":""},null,null,{"$f":"IF(C75=\"\",\"\",IF(D75=\"\",\"\",(HOUR(D75-C75)*60+MINUTE(D75-C75))/60))","v":""},null,null,{"$f":"IF(F75=\"ohne Lizenz\",5,IF(F75=\"Land/Schwimmen\",10,IF(F75=\"Lunge/Wgym\",15,\"\")))","v":""},{"$f":"IF(H75=\"\",\"\",E75*H75)","v":""}]
[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,"",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,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,"",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,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,"",""]
[null,"",null,null,"",null,null,"",""]
[null,"",null,null,"",null,null,"",""]

{"sheet":"Helper","index":1,"n_rows":66,"n_cols":8,"rows_kept":66,"hidden":true}
["Aufsichtsarten","Sportstätte","Zeiten","Jahr","Quartal","Bemerkung",null,"Druckbereich bis J108"]
["ohne Lizenz","Stadtbad, Mühlenstr. 27, 09111 Ch.","06:00:00",2025,"1. Quartal","V (ertretung)"]
["Land/Schwimmen","SH Südring, Max-Schäller-Str. 5, 09122 Ch.",{"$f":"C2+15/60/24","v":"06:15:00"},2026,"2. Quartal","A (usbildung)"]
["Lunge/Wgym","SH Gablenz, Augustusburger Str. 197, 09127 Ch.",{"$f":"C3+15/60/24","v":"06:30:00"},2027,"3. Quartal","U (rlaub)"]
[null,"Sportforum, Reichenhainer Str. 54, 09125 Ch.",{"$f":"C4+15/60/24","v":"06:45:00"},2028,"4. Quartal"]
[null,"Physio Wiedemann, Am Karbel 1, 09116 Ch.",{"$f":"C5+15/60/24","v":"07:00:00"}]
[null,"Flemmingschule, Albert-Schweitzer-Str. 61, 09116 Ch",{"$f":"C6+15/60/24","v":"07:15:00"}]
[null,"Schule Altchemnitz, Schulstr. 2, 09125 Ch.",{"$f":"C7+15/60/24","v":"07:30:00"}]
[null,"ISB Sporthort, Max-Türpe-Str. 40, 09122 Ch.","07:45:00"]
[null,null,{"$f":"C9+15/60/24","v":"08:00:00"}]
[null,null,"08:15:00"]
[null,null,"08:30:00"]
[null,null,"08:45:00"]
[null,null,"09:00:00"]
[null,null,"09:15:00"]
[null,null,"09:30:00"]
[null,null,"09:45:00"]
[null,null,"10:00:00"]
[null,null,"10:15:00"]
[null,null,"10:30:00"]
[null,null,"10:45:00"]
[null,null,"11:00:00"]
[null,null,"11:15:00"]
[null,null,"11:30:00"]
[null,null,"11:45:00"]
[null,null,"12:00:00"]
[null,null,"12:15:00"]
[null,null,"12:30:00"]
[null,null,"12:45:00"]
[null,null,"13:00:00"]
[null,null,"13:15:00"]
[null,null,"13:30:00"]
[null,null,"13:45:00"]
[null,null,"14:00:00"]
[null,null,"14:15:00"]
[null,null,"14:30:00"]
[null,null,"14:45:00"]
[null,null,"15:00:00"]
[null,null,"15:15:00"]
[null,null,"15:30:00"]
[null,null,"15:45:00"]
[null,null,"16:00:00"]
[null,null,"16:15:00"]
[null,null,"16:30:00"]
[null,null,"16:45:00"]
[null,null,"17:00:00"]
[null,null,"17:15:00"]
[null,null,{"$f":"C47+15/60/24","v":"17:30:00"}]
[null,null,"17:45:00"]
[null,null,"18:00:00"]
[null,null,"18:15:00"]
[null,null,"18:30:00"]
[null,null,"18:45:00"]
[null,null,"19:00:00"]
[null,null,"19:15:00"]
[null,null,"19:30:00"]
[null,null,"19:45:00"]
[null,null,"20:00:00"]
[null,null,"20:15:00"]
[null,null,"20:30:00"]
[null,null,"20:45:00"]
[null,null,"21:00:00"]
[null,null,"21:15:00"]
[null,null,"21:30:00"]
[null,null,"21:45:00"]
[null,null,"22:00:00"]