{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tägliche Heimfahrt","Ohne Heimfahrt","Tabelle1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Tägliche Heimfahrt","index":0,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,3,2,7],[1,8,2,10],[37,8,37,9]]}
[]
["Jahr:",2024,null,"Verpflegungszuschuss",null,null,null,null,"Fahrtkosten"]
["Monat:",1]
["Datum",null,"Name der\nBaustelle ","über 8 Std.\naußer Haus","0-50Km","51-75Km","ab 75Km","Verpflegungs-\nzuschuss","Mit dem privat Fahrzeug gefahrene Kilometer \n(hin und zurück)","Fahrtkosten","Bullifahrer \nStunden:",null,null,false,false]
[{"$f":"DATE(B$2,B$3,1)","v":"2024-01-01"},{"$f":"TEXT(A5,\"TTTT\")","v":"Montag"},null,null,null,null,null,{"$f":"IF(AND(L5=TRUE, M5=TRUE), 7, IF(AND(L5=TRUE, N4=TRUE), 8, IF(AND(L5=TRUE, O4=TRUE), 9, 0)))","v":0},null,{"$f":"IF(I5<10, 0, MIN(MAX(I5 * 0.2, 0), 30))","v":0},null,false,false,false,false]
[{"$f":"A5+1","v":"2024-01-02"},{"$f":"TEXT(A6,\"TTTT\")","v":"Dienstag"},null,null,null,null,null,{"$f":"IF(AND(L6=TRUE, M6=TRUE), 7, IF(AND(L6=TRUE, N5=TRUE), 8, IF(AND(L6=TRUE, O5=TRUE), 9, 0)))","v":0},null,0,null,false,false,false,false]
[{"$f":"A6+1","v":"2024-01-03"},{"$f":"TEXT(A7,\"TTTT\")","v":"Mittwoch"},null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-04","Donnerstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-05","Freitag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-06","Samstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-07","Sonntag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-08","Montag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-09","Dienstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-10","Mittwoch",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-11","Donnerstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-12","Freitag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-13","Samstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-14","Sonntag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-15","Montag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-16","Dienstag",null,null,null,null,null,0,null,0,null,false,false,"lnlkndclknlkcsnv",false]
["2024-01-17","Mittwoch",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-18","Donnerstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-19","Freitag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-20","Samstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-21","Sonntag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-22","Montag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-23","Dienstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-24","Mittwoch",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-25","Donnerstag",null,null,null,null,null,0,null,0,null,false,null,false,false]
["2024-01-26","Freitag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-27","Samstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-28","Sonntag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-29","Montag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-30","Dienstag",null,null,null,null,null,0,null,0,null,false,false,false,false]
["2024-01-31","Mittwoch",null,null,null,null,null,0,null,0,null,false,false]
[null,null,null,null,null,null,null,{"$f":"SUM(H5:H35)","v":0},null,{"$f":"SUM(J5:J34)","v":0},{"$f":"SUM(K5:K35)*B38","v":0}]
[]
["Gib hier deinen Stundenlohn\nals Bullifahrer ein:",20,null,null,null,null,null,null,"Gesammtsumme:",null,{"$f":"SUM(H36,J36,K36)","v":0}]

{"sheet":"Ohne Heimfahrt","index":1,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,0,43,1],[39,4,39,5],[1,10,3,12],[1,7,3,9],[1,2,3,6],[43,8,43,12]]}
[null,null,null,null,"           "]
[null,null,"Wegezeitentschädigung",null,null,null,null,"Verpflegungszuschuss",null,null,"Fahrtgeld"]
["Jahr:",2024]
["Monat:\n",1]
["Datum","Wochentag","Name der\nBaustelle","Hinfahrt \nankreuzen","Rückfahrt \nankreuzen","Entfernung\nBetrieb->\nBaustelle in KM","Wegezeit-\nentschädigung","Arbeitstag\n(bitte ankreuzen)","Unterkunft\naußerhalb\n der Baustelle","Verpflegungs-\nzuschuss","Mit dem privat Fahrzeug angereist/ abgereist oder die Strecke Unterkunft -> Baustelle gefahren","Entfernung in Km \nUnterkunft->Baustelle","Fahrtgelt",null,null,null,null,null,null,false]
[{"$f":"DATE(B$3,B$4,1)","v":"2024-01-01"},{"$f":"TEXT(A6,\"TTTT\")","v":"Montag"},null,null,null,null,{"$f":"IF(OR(O6=TRUE, P6=TRUE), IF(F6<75, 0, IF(F6<=200, 9, IF(F6<=300, 18, IF(F6<=400, 27, 39)))), IF(OR(O6=FALSE, P6=FALSE), 0, \"\"))","v":0},null,null,{"$f":"IF(S6=TRUE,\n  IF(AND($N$44=TRUE, T5=FALSE), 28,\n    IF(AND($N$44=TRUE, T5=TRUE), 32,\n      IF(AND($O$44=TRUE, T5=FALSE), 24,\n        IF(AND($O$44=TRUE, T5=TRUE), 28, 0)\n      )\n    )\n  ),\n0)","v":0},null,null,{"$f":"IF(V6=TRUE, IF(AND(L6<>\"\", L6>10), IF(L6*0.2 > 30, 30, L6*0.2), 0) + IF(V6=TRUE, F6*0.2, 0), 0)","v":0},null,false,false,null,null,false,false,null,false]
[{"$f":"A6+1","v":"2024-01-02"},{"$f":"TEXT(A7,\"TTTT\")","v":"Dienstag"},null,null,null,null,{"$f":"IF(OR(O7=TRUE, P7=TRUE), IF(F7<75, 0, IF(F7<=200, 9, IF(F7<=300, 18, IF(F7<=400, 27, 39)))), IF(OR(O7=FALSE, P7=FALSE), 0, \"\"))","v":0},null,null,{"$f":"IF(S7=TRUE,\n  IF(AND($N$44=TRUE, T6=FALSE), 28,\n    IF(AND($N$44=TRUE, T6=TRUE), 32,\n      IF(AND($O$44=TRUE, T6=FALSE), 24,\n        IF(AND($O$44=TRUE, T6=TRUE), 28, 0)\n      )\n    )\n  ),\n0)","v":0},null,null,{"$f":"IF(V7=TRUE, IF(AND(L7<>\"\", L7>10), IF(L7*0.2 > 30, 30, L7*0.2), 0) + IF(V7=TRUE, F7*0.2, 0), 0)","v":0},null,false,false,null,null,false,false,null,false]
[{"$f":"A7+1","v":"2024-01-03"},"Mittwoch",null,null,null,null,0,null,null,0,null,null,0,null,false,false,null,null,false,false,null,false]
["2024-01-04","Donnerstag",null,null,null,null,0,null,null,0,null,null,0,null,true,false,null,null,false,false,null,false]
["2024-01-05","Freitag",null,null,null,null,0,null,null,0,null,null,0,null,false,false,null,null,false,false,null,false]
["2024-01-06","Samstag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false,null,false]
["2024-01-07","Sonntag",null,null,null,null,0,null,null,0,null,null,0,null,false,null,null,null,false,false,null,false]
["2024-01-08","Montag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-09","Dienstag",null,null,null,null,0,null,null,0,null,null,0,null,null,null,null,null,false,false,null,false]
["2024-01-10","Mittwoch",null,null,null,null,0,null,null,0,null,null,0,null,false,false,null,null,false,false,null,false]
["2024-01-11","Donnerstag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false,null,false]
["2024-01-12","Freitag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false,null,false]
["2024-01-13","Samstag",null,null,null,null,0,null,null,0,null,null,0,null,false,null,null,null,false,false]
["2024-01-14","Sonntag",null,null,null,null,0,null,null,0,null,null,0,null,false,false,null,null,false,false]
["2024-01-15","Montag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-16","Dienstag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-17","Mittwoch",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-18","Donnerstag",null,null,null,null,0,null,null,0,null,null,0,null,null,null,null,null,false,false]
["2024-01-19","Freitag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-20","Samstag",null,null,null,null,0,null,null,0,null,null,0,null,null,null,null,null,false,false]
["2024-01-21","Sonntag",null,null,null,null,0,null,null,0,null,null,0,null,false,null,null,null,false,false]
["2024-01-22","Montag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-23","Dienstag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-24","Mittwoch",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-25","Donnerstag",null,null,null,null,0,null,null,0,null,null,0,null,null,null,null,null,false,false]
["2024-01-26","Freitag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-27","Samstag",null,null,null,null,0,null,null,0,null,null,0,null,null,null,null,null,false,false]
["2024-01-28","Sonntag",null,null,null,null,0,null,null,0,null,null,0,null,null,false,null,null,false,false]
["2024-01-29","Montag",null,null,null,null,0,null,null,0,null,null,0,null,null,null,null,null,false,false]
["2024-01-30","Dienstag",null,null,null,null,0,null,null,0,null,null,0,null,null,null,null,null,false,false]
["2024-01-31","Mittwoch",null,null,null,null,0,null,null,0,null,null,0,null,false,false,null,null,false]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,{"$f":"SUM(J6:J36)","v":0},null,null,{"$f":"SUM(M6:M36)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Gesamtsumme:",{"$f":"SUM(G37+J37+M37)","v":0}]
[]
[]
[null,null,"Ja","Nein"]
["Gibt es eine Betriebsvereinbarung über eine Erhöhung\nder Verpflegungspauschale von 24€ auf 28€? (Bitte ankreuzen)",null,null,null,null,null,null,null,null,null,null,null,null,true,false]

{"sheet":"Tabelle1","index":2,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,1,null,null,2026,null,7,2024,null,1]
[null,null,null,null,null,null,null,2025,null,2]
[{"$f":"DATE(A$1,B$1,1)","v":"1900-01-01"},null,null,null,null,null,null,2026,null,3]
[{"$f":"A3+1","v":"1900-01-02"},null,null,null,null,"Wochentag ",null,null,null,4]
[{"$f":"A4+1","v":"1900-01-03"},{"$f":"IF(ISNUMBER(C5), TEXT(C5, \"dddd\"), \"\")","v":""},null,null,{"$f":"DATE(E$1,G$1,1)","v":"2026-07-01"},{"$f":"TEXT(E5,\"TTTT\")","v":"Mittwoch"},null,null,null,5]
["1900-01-04","",null,null,{"$f":"E5+1","v":"2026-07-02"},{"$f":"TEXT(E6,\"TTTT\")","v":"Donnerstag"},null,null,null,6]
["1900-01-05","",null,null,{"$f":"E6+1","v":"2026-07-03"},"Freitag",null,null,null,7]
["1900-01-06","",null,null,"2026-07-04","Samstag",null,null,null,8]
["1900-01-07","",null,null,"2026-07-05","Sonntag",null,null,null,9]
["1900-01-08","",null,null,"2026-07-06","Montag",null,null,null,10]
["1900-01-09","",null,null,"2026-07-07","Dienstag",null,null,null,11]
["1900-01-10",null,null,null,"2026-07-08","Mittwoch",null,null,null,12]
["1900-01-11",null,null,null,"2026-07-09","Donnerstag"]
["1900-01-12",null,null,null,"2026-07-10","Freitag"]
["1900-01-13",null,null,null,"2026-07-11","Samstag"]
["1900-01-14",null,null,null,"2026-07-12","Sonntag"]
["1900-01-15",null,null,null,"2026-07-13","Montag"]
["1900-01-16",null,null,null,"2026-07-14","Dienstag"]
["1900-01-17",null,null,null,"2026-07-15","Mittwoch"]
["1900-01-18",null,null,null,"2026-07-16","Donnerstag"]
["1900-01-19",null,null,null,"2026-07-17","Freitag"]
["1900-01-20",null,null,null,"2026-07-18","Samstag"]
["1900-01-21",null,null,null,"2026-07-19","Sonntag"]
["1900-01-22",null,null,null,"2026-07-20","Montag"]
["1900-01-23",null,null,null,"2026-07-21","Dienstag"]
["1900-01-24",null,null,null,"2026-07-22","Mittwoch"]
["1900-01-25",null,null,null,"2026-07-23","Donnerstag"]
["1900-01-26",null,null,null,"2026-07-24","Freitag"]
["1900-01-27",null,null,null,"2026-07-25","Samstag"]
["1900-01-28",null,null,null,"2026-07-26","Sonntag"]
["1900-01-29",null,null,null,"2026-07-27","Montag"]
["1900-01-30",null,null,null,"2026-07-28","Dienstag"]
["1900-01-31",null,null,null,"2026-07-29","Mittwoch"]
["1900-02-01"]
["1900-02-02"]