{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Spesenabrechnung"],"not_rendered":{"images":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Spesenabrechnung","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"merged":[[0,1,0,8],[0,9,0,11],[2,2,2,3],[2,4,2,5],[2,6,2,7],[5,2,5,3],[5,6,5,7],[5,10,5,11],[6,2,6,3],[6,6,6,7],[6,10,6,11],[17,1,17,10],[18,1,18,10],[19,1,19,10],[20,2,20,4],[20,6,20,9]]}
[null,"Firmenname",{"$nulls":7},"Nur für interne Zwecke"]
[null,"Spesenabrechnung"]
[null,"ZWECK:",null,null,"ANWEISUNGSNUMMER:",{"$nulls":4},"ZAHLUNGSZEITRAUM:","Von",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MIN(Ausgaben[Datum])), \"\")","v":""}]
[{"$nulls":10},"Nach",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MAX(Ausgaben[Datum])), \"\")","v":""}]
[null,"MITARBEITERINFORMATIONEN:"]
[null,"Name",{"$nulls":3},"Position",{"$nulls":3},"RVNR"]
[null,"Abteilung",{"$nulls":3},"Leiter",{"$nulls":3},"Mitarbeiter-ID"]
[]
[null,"Datum","Konto","Beschreibung","Hotel","Transport","Kraftstoff","Mahlzeiten","Telefon","Unterhaltung","Verschiedenes","Summe"]
[{"$nulls":11},{"$f":"IFERROR(SUM(Ausgaben[[#This Row],[Hotel]:[Verschiedenes]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Ausgaben[[#This Row],[Hotel]:[Verschiedenes]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Ausgaben[[#This Row],[Hotel]:[Verschiedenes]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Ausgaben[[#This Row],[Hotel]:[Verschiedenes]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Ausgaben[[#This Row],[Hotel]:[Verschiedenes]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Ausgaben[[#This Row],[Hotel]:[Verschiedenes]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Ausgaben[[#This Row],[Hotel]:[Verschiedenes]]), \"\")","v":0}]
[null,"Summe",null,null,{"$f":"SUBTOTAL(109,Ausgaben[Hotel])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Transport])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Kraftstoff])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Mahlzeiten])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Telefon])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Unterhaltung])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Verschiedenes])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Summe])","v":0}]
[null,"Zwischensumme",{"$nulls":9},{"$f":"IFERROR(SUM(Ausgaben[[#Totals],[Summe]]), \"\")","v":0}]
[null,"Barvorschüsse"]
[null,"Summe",{"$nulls":9},{"$f":"IFERROR((L18-L19), \"\")","v":0}]
[null,"GENEHMIGT:",{"$nulls":3},"ANMERKUNGEN: "]