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

{"sheet":"Budgetplaner","index":0,"n_rows":21,"n_cols":6,"rows_kept":21}
[null,"Urlaubsbudget-Planer"]
[]
[null,"BUDGET PRO KATEGORIE"]
[null,"Kategorien","Geplantes Budget","Budget im Detail","Verfügbar / (Über)"]
[null,"Anreise",{"v":750,"d":"750 €"},{"$f":"SUMIF(Tabelle2[Kategorie],Tabelle1[[#This Row],[Kategorien]],Tabelle2[Betrag])","v":{"v":720,"d":"720 €"}},{"$f":"IFERROR(Tabelle1[[#This Row],[Geplantes Budget]]-Tabelle1[[#This Row],[Budget im Detail]],\"\")","v":{"v":30,"d":"30 €"}}]
[null,"Unterkunft",{"v":250,"d":"250 €"},{"$f":"SUMIF(Tabelle2[Kategorie],Tabelle1[[#This Row],[Kategorien]],Tabelle2[Betrag])","v":{"v":300,"d":"300 €"}},{"$f":"IFERROR(Tabelle1[[#This Row],[Geplantes Budget]]-Tabelle1[[#This Row],[Budget im Detail]],\"\")","v":{"v":-50,"d":"-50 €"}}]
[null,"Essen",{"v":100,"d":"100 €"},{"$f":"SUMIF(Tabelle2[Kategorie],Tabelle1[[#This Row],[Kategorien]],Tabelle2[Betrag])","v":{"v":80,"d":"80 €"}},{"$f":"IFERROR(Tabelle1[[#This Row],[Geplantes Budget]]-Tabelle1[[#This Row],[Budget im Detail]],\"\")","v":{"v":20,"d":"20 €"}}]
[null,"Aktivitäten",{"v":500,"d":"500 €"},{"$f":"SUMIF(Tabelle2[Kategorie],Tabelle1[[#This Row],[Kategorien]],Tabelle2[Betrag])","v":{"v":500,"d":"500 €"}},{"$f":"IFERROR(Tabelle1[[#This Row],[Geplantes Budget]]-Tabelle1[[#This Row],[Budget im Detail]],\"\")","v":{"v":0,"d":"0 €"}}]
[null,"Souvenirs",{"v":50,"d":"50 €"},{"$f":"SUMIF(Tabelle2[Kategorie],Tabelle1[[#This Row],[Kategorien]],Tabelle2[Betrag])","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tabelle1[[#This Row],[Geplantes Budget]]-Tabelle1[[#This Row],[Budget im Detail]],\"\")","v":{"v":50,"d":"50 €"}}]
[null,"Sonstiges",{"v":50,"d":"50 €"},{"$f":"SUMIF(Tabelle2[Kategorie],Tabelle1[[#This Row],[Kategorien]],Tabelle2[Betrag])","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tabelle1[[#This Row],[Geplantes Budget]]-Tabelle1[[#This Row],[Budget im Detail]],\"\")","v":{"v":50,"d":"50 €"}}]
[null,"Sicherheitsrücklage",{"v":200,"d":"200 €"},{"$f":"SUMIF(Tabelle2[Kategorie],Tabelle1[[#This Row],[Kategorien]],Tabelle2[Betrag])","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tabelle1[[#This Row],[Geplantes Budget]]-Tabelle1[[#This Row],[Budget im Detail]],\"\")","v":{"v":200,"d":"200 €"}}]
[null,"Gesamtbudget",{"$f":"SUBTOTAL(109,Tabelle1[Geplantes Budget])","v":{"v":1900,"d":"1,900 €"}},{"$f":"SUBTOTAL(109,Tabelle1[Budget im Detail])","v":{"v":1600,"d":"1,600 €"}},{"$f":"SUBTOTAL(109,Tabelle1[Verfügbar / (Über)])","v":{"v":300,"d":"300 €"}}]
[]
[null,"AUSGABENDETAILS"]
[null,"Beschreibung","Kategorie","Menge","Einzelkosten","Betrag"]
[null,"Flugkosten","Anreise",2,{"v":300,"d":"300 €"},{"$f":"IFERROR(Tabelle2[[#This Row],[Menge]]*Tabelle2[[#This Row],[Einzelkosten]],\"\")","v":{"v":600,"d":"600 €"}}]
[null,"Bus und Taxi, 2 Tage","Anreise",4,{"v":30,"d":"30 €"},{"$f":"IFERROR(Tabelle2[[#This Row],[Menge]]*Tabelle2[[#This Row],[Einzelkosten]],\"\")","v":{"v":120,"d":"120 €"}}]
[null,"Hotel, 2 Nächte","Unterkunft",2,{"v":150,"d":"150 €"},{"$f":"IFERROR(Tabelle2[[#This Row],[Menge]]*Tabelle2[[#This Row],[Einzelkosten]],\"\")","v":{"v":300,"d":"300 €"}}]
[null,"Essen, 2 Tage","Essen",2,{"v":40,"d":"40 €"},{"$f":"IFERROR(Tabelle2[[#This Row],[Menge]]*Tabelle2[[#This Row],[Einzelkosten]],\"\")","v":{"v":80,"d":"80 €"}}]
[null,"Tag 1, Konzertkarten","Aktivitäten",2,{"v":250,"d":"250 €"},{"$f":"IFERROR(Tabelle2[[#This Row],[Menge]]*Tabelle2[[#This Row],[Einzelkosten]],\"\")","v":{"v":500,"d":"500 €"}}]
[null,"Sonstige Ausgabenposten eingeben",{"$nulls":3},{"$f":"IFERROR(Tabelle2[[#This Row],[Menge]]*Tabelle2[[#This Row],[Einzelkosten]],\"\")","v":{"v":0,"d":"0 €"}}]