{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Budgetplaner"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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