{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Spesenabrechn."],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Spesenabrechn.","index":0,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,9,1,11],[0,9,0,11],[33,3,33,4],[35,9,35,10],[0,3,0,8],[1,3,1,8],[2,6,3,6],[2,7,3,7],[2,10,3,10],[2,8,2,9],[1,0,1,1],[0,0,0,1],[2,0,3,0],[2,1,3,1],[2,5,3,5],[2,3,3,3]]}
["Spesenabrechnung  von: (Name, Vorname)",null,null,"Ressort / Funktion:    ",{"$nulls":5},"Datum:"]
[]
["Datum","Zweck und Ort","Zeit-","Anz. Std. ","CHF/Std.","Anzahl Sitzungen","Kategorie","Total","Fahrspesen",null,"Andere Spesen","Total"]
[null,null,"aufwand",null,31.05,null,null,{"$f":"IF(G4=\"bis 2 Std.\",F4*72.4,IF(G4=\"bis 4 Std.\",F4*108.6,IF(G4=\"halber Tag\",F4*144.8,IF(G4=\"ganzer Tag\",F4*289.6,\"\"))))","v":""},"Km","CHF 0.80/km",null,"Auszahlung"]
[{"$nulls":4},{"$f":"SUM(D5*$E$4)","v":0},null,null,{"$f":"IF(G5=\"bis 2 Std.\",F5*72.4,IF(G5=\"2 bis 4 Std.\",F5*108.6,IF(G5=\"halber Tag\",F5*144.8,IF(G5=\"ganzer Tag\",F5*289.6,\"\"))))","v":""},null,{"$f":"SUM(I5*$A$36)","v":0},null,{"$f":"N(E5)+N(H5)+N(J5)+N(K5)","v":0}]
[{"$nulls":4},0,null,null,{"$f":"IF(G6=\"bis 2 Std.\",F6*72.4,IF(G6=\"2 bis 4 Std.\",F6*108.6,IF(G6=\"halber Tag\",F6*144.8,IF(G6=\"ganzer Tag\",F6*289.6,\"\"))))","v":""},null,{"$f":"SUM(I6*$A$36)","v":0},null,{"$f":"N(E6)+N(H6)+N(J6)+N(K6)","v":0}]
[{"$nulls":4},0,null,null,"",null,0,null,{"$f":"N(E7)+N(H7)+N(J7)+N(K7)","v":0}]
[{"$nulls":4},0,null,null,"",null,0,null,{"$f":"N(E8)+N(H8)+N(J8)+N(K8)","v":0}]
[{"$nulls":4},0,null,null,"",null,0,null,{"$f":"N(E9)+N(H9)+N(J9)+N(K9)","v":0}]
[{"$nulls":4},0,null,null,"",null,0,null,{"$f":"N(E10)+N(H10)+N(J10)+N(K10)","v":0}]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,0]
[{"$nulls":4},0,null,null,"",null,0,null,{"$f":"N(E31)+N(H31)+N(J31)+N(K31)","v":0}]
["Kontrolle:",null,{"$f":"SUM(C5:C31)","v":0},{"$f":"SUM(D5:D31)","v":0},{"$f":"SUM(E5:E31)","v":0},{"$f":"SUM(F5:F31)","v":0},null,{"$f":"SUM(H5:H31)","v":0},{"$f":"SUM(I5:I31)","v":0},{"$f":"SUM(J5:J31)","v":0},{"$f":"SUM(K5:K31)","v":0},{"$f":"SUM(E32+H32+J32+K32)","v":0}]
["Neue Ansätze ","Abendsitzung bis zu 2 Std.: CHF 72.40",{"$nulls":5},"",null,"Kontrollsumme vertikal",null,{"$f":"SUM(L5:L31)","v":0}]
["ab 2025","Abendsitzung 2 bis zu 4 Std. CHF 108.60",null,"Unterschrift:",null,null,null,""]
[null,"ganzer Tag: CHF 289.60, halber Tag CHF 144.80",{"$nulls":5},""]
[0.8,"Km-Entschädigung: CHF -.80/Km",{"$nulls":7},"Kontrollvisum :"]
[31.05,"Stundenlohn CHF 31.05"]
[]
["Bankverbindung und"]
["IBAN oder"]
["Einzahlungsschein"]