{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Zeitnachweis","Listen"],"not_rendered":{"images":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Zeitnachweis","index":0,"n_rows":63,"n_cols":8,"rows_kept":63,"merged":[[0,1,0,7],[2,5,2,6],[4,5,4,6],[6,5,6,7],[8,5,8,7],[10,5,10,7],[12,5,12,7],[14,2,14,4],[16,2,16,5],[17,2,17,5],[54,1,54,7]]}
[null,"\n\nZeitnachweis "]
[]
[null,"Vertragsnummer (VN):"]
[]
[null,"Projektnummer (PN):"]
[]
[null,"Auftragnehmer:"]
[]
[null,"Adresse AN:"]
[]
[null,"Name der Fachkraft:"]
[]
[null,"Rolle / Funktion:"]
[]
[null,"Monat:","bitte auswählen",null,null,"Jahr:","bitte auswählen"]
[]
[null,null,"1 = ganze Tage\n0,5 = halbe Tage\nx = ja / zutreffend",{"$nulls":3},"\n\n"]
[]
[null," Datum"," Fachkrafttage"," Auftragsbedingte\n Kosten im Einsatzland"," Tagegeld"," Übernachtungsgeld","Ort","Aktivität / Arbeitsinhalt / Output"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"Total",{"$f":"SUM(C20:C50)","v":0},{"$f":"IFERROR(\"Fachkrafttage (FKT) im \"&TEXT(DATEVALUE(\"1 \"&C15&\" \"&G15),\"MMMM JJJJ\"),\"\")","v":""}]
[]
[null,"Hiermit bestätige ich die inhaltliche Richtigkeit der o.g. Angaben."]
[]
[null,"Fachkraft (Name und Datum), elektronischer Versand, daher ohne Unterschrift"]
[]
[null,"Hinweise:"]
[null,"• Fachkrafttage siehe Ziffer 3.3.1 AVB 2020"]
[null,"• Bei Stundenweise-Abrechnung die Anzahl der geleisteten Stunden unter \"Aktivitäten / Arbeitsinhalt / Output\" mit angeben"]
[null,"• Auftragsbedingte Kosten im Einsatzland siehe Ziffer 3.3.2 AVB 2020"]
[null,"• Tagegeld siehe Ziffer 3.3.4.2 AVB 2020"]
[null,"• Übernachtungsgeld siehe Ziffer 3.3.4.3 AVB 2020"]

{"sheet":"Listen","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"hidden":true}
[]
[]
[]
[null,null,"Monate",null,"Jahre",null,"Datum",null,"Fachfrakfttage"]
[null,null,"Januar",null,{"$f":"E6-1","v":2017},null,{"$f":"IFERROR(DATEVALUE(\"1 \"&Zeitnachweis!C15&\" \"&Zeitnachweis!G15),0)","v":0},null,1]
[null,null,"Februar",null,2018,null,{"$f":"IFERROR(DAY(DATE(YEAR(G5),MONTH(G5)+1,0)),31)","v":31},null,0.5]
[null,null,"März",null,2019]
[null,null,"April",null,2020]
[null,null,"Mai",null,{"$f":"YEAR(TODAY())","v":2021}]
[null,null,"Juni",null,{"$f":"E9+1","v":2022}]
[null,null,"Juli",null,{"$f":"E10+1","v":2023}]
[null,null,"August",null,{"$f":"E11+1","v":2024}]
[null,null,"September",null,2025]
[null,null,"Oktober",null,2026]
[null,null,"November",null,2027]
[null,null,"Dezember",null,2028]
[{"$nulls":4},2029]
[{"$nulls":4},{"$f":"E17+1","v":2030}]
[{"$nulls":4},2031]