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

{"sheet":"SPESENABRECHNUNG","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"merged":[[1,2,1,3],[1,5,1,6],[3,2,3,3],[3,6,3,7],[3,10,3,11],[4,2,4,3],[4,6,4,7],[4,10,4,11],[20,2,20,4],[20,6,20,8],[21,2,21,4],[21,6,21,8]]}
[null,"SPESENABRECHNUNG",{"$nulls":8},"Nur für interne Zwecke"]
[null,"ZWECK:",null,null,"ANWEISUNGS-NUMMER:",null,null,"ZAHLUNGSZEIT-RAUM","VON:",{"$f":"IF(COUNTA(SpesenDaten[Datum])=0,\"\",MIN(SpesenDaten[Datum]))","v":""},"BIS:",{"$f":"IF(COUNTA(SpesenDaten[Datum])=0,\"\",MAX(SpesenDaten[Datum]))","v":""}]
[null,"MITARBEITERINFORMATIONEN:"]
[null,"NAME",{"$nulls":3},"POSITION",{"$nulls":3},"Sozialversicherung"]
[null,"ABTEILUNG",{"$nulls":3},"VORGESETZTER",{"$nulls":3},"MITARBEITER-ID"]
[]
[null,"Datum","Konto","Beschreibung","Hotel","Transport","Kraftstoff","Mahlzeiten","Telefon","Unterhaltung","Sonstiges","Gesamt"]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},{"$f":"SUM(SpesenDaten[[#This Row],[Hotel]:[Sonstiges]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Ergebnis",null,null,{"$f":"SUBTOTAL(109,SpesenDaten[Hotel])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,SpesenDaten[Transport])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,SpesenDaten[Kraftstoff])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,SpesenDaten[Mahlzeiten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,SpesenDaten[Telefon])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,SpesenDaten[Unterhaltung])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,SpesenDaten[Sonstiges])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,SpesenDaten[Gesamt])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":10},"ZWISCHENSUMME",{"$f":"SpesenDaten[[#Totals],[Gesamt]]","v":{"v":0,"d":"0.00 €"}}]
[null,"GENEHMIGT:",{"$nulls":3},"ANMERKUNGEN: ",{"$nulls":4},"VORSCHÜSSE",{"v":0,"d":"0.00 €"}]
[{"$nulls":10},"SUMME",{"$f":"Zwischensumme-Vorschüsse","v":{"v":0,"d":"0.00 €"}}]