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

{"sheet":"SPESENABRECHNUNG","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"merged":[[2,2,2,3],[2,5,2,6],[4,2,4,3],[4,6,4,7],[4,10,4,11],[5,2,5,3],[5,6,5,7],[5,10,5,11],[21,2,21,4],[21,6,21,8],[22,2,22,4],[22,6,22,8]]}
[]
[]
[null,"Zweck:",null,null,"Auszugsnummer:",null,null,"Zahlungszeitraum","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},"SSN"]
[null,"Abteilung",{"$nulls":3},"Leiter",{"$nulls":3},"Mitarbeiter-ID"]
[]
[null,"Datum","Konto","Beschreibung","Hotel","Transport","Kraftstoff","Mahlzeiten","Telefon","Unterhaltung","Sonstiges","Ergebnis"]
[{"$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[Ergebnis])","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":10},"ZWISCHENSUMME",{"$f":"SpesenDaten[[#Totals],[Ergebnis]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Genehmigt:",{"$nulls":3},"Anmerkungen: ",{"$nulls":4},"VORSCHÜSSE",{"v":0,"d":"0.00 €"}]
[{"$nulls":10},"ERGEBNIS",{"$f":"Zwischensumme-Vorschüsse","v":{"v":0,"d":"0.00 €"}}]