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

{"sheet":"Reisekostenbudget","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,2,5],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4]]}
[null,"Reisekostenbudget"]
[null,"Geplantes Reisekostenbudget",null,{"v":2500,"d":"2,500.00 €"},null,null,{"$f":"D3","v":{"v":2369.3599999999997,"d":"2,369.36 €"}}]
[null,"Gesamtkosten der Reise",null,{"$f":"SUBTOTAL(9,Daten[Betrag])","v":{"v":2369.3599999999997,"d":"2,369.36 €"}},null,null,{"$f":"D2","v":{"v":2500,"d":"2,500.00 €"}}]
[null,{"$f":"IF(D2>D3,\"Um diesen Wert unter dem Budget:\",\"Um diesen Wert über dem Budget:\")","v":"Um diesen Wert unter dem Budget:"},null,{"$f":"(D2-D3)","v":{"v":130.64000000000033,"d":"130.64 €"}}]
[null,"Position","Beschreibung","Kosten","Menge","Betrag","Anmerkungen"]
[null,"Flugkosten","Eintrittskarten",{"v":300,"d":"300.00 €"},1,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":300,"d":"300.00 €"}}]
[null,"Flugkosten","Eintrittskarten",{"v":350,"d":"350.00 €"},1,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":350,"d":"350.00 €"}}]
[null,"Hotel","Zimmer",{"v":125,"d":"125.00 €"},3,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":375,"d":"375.00 €"}}]
[null,"Hotel","Zimmer",{"v":150,"d":"150.00 €"},3,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":450,"d":"450.00 €"}}]
[null,"Mietwagen","Kosten pro Tag",{"v":52,"d":"52.00 €"},6,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":312,"d":"312.00 €"}}]
[null,"Benzin","Kosten pro Liter",{"v":1.74,"d":"1.74 €"},14,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":24.36,"d":"24.36 €"}}]
[null,"Unterhaltung","Betrag",{"v":130,"d":"130.00 €"},1,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":130,"d":"130.00 €"}}]
[null,"Geschenke","Betrag",{"v":85,"d":"85.00 €"},1,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":85,"d":"85.00 €"}}]
[null,"Sonstiges","Betrag",{"v":55,"d":"55.00 €"},1,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":55,"d":"55.00 €"}}]
[null,"Essen","Kosten pro Tag",{"v":48,"d":"48.00 €"},6,{"$f":"Daten[[#This Row],[Menge]]*Daten[[#This Row],[Kosten]]","v":{"v":288,"d":"288.00 €"}}]
[null,"Ergebnis",{"$nulls":3},{"$f":"SUBTOTAL(109,Daten[Betrag])","v":{"v":2369.3599999999997,"d":"2,369.36 €"}}]