{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Anfang","Feiertagsbudget Planer"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Anfang","index":0,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"So verwenden Sie diese Vorlage"]
[null,"Erfassen Sie Ihre Ausgaben mit diesem Feiertagsbudget-Planer."]
[null,"Geben Sie zunächst Ihr Budget und die Tatsächlichen Ausgaben für jede Kategorietabelle ein."]
[null,"Feiertagsbudget, tatsächlich ausgegebener Gesamtbetrag und Differenz werden automatisch für Sie berechnet."]

{"sheet":"Feiertagsbudget Planer","index":1,"n_rows":36,"n_cols":14,"rows_kept":36,"merged":[[0,2,5,7],[2,10,2,11],[8,2,8,5],[8,10,8,13],[18,2,18,5],[18,10,18,13],[29,2,29,5],[29,10,29,13]]}
[null,null,"Feiertagsbudget\nPlaner"]
[]
[{"$nulls":10},"FEIERTAGSBUDGET",null,null,{"$f":"SUM(Geschenke[Budget],Verpackung[Budget],(Reisen[Budget],(Mahlzeiten[Budget],(Bewirtung[Budget],Sonstiges[Budget]))))","v":{"v":750,"d":"750.00 €"}}]
[{"$nulls":10},"TATSÄCHLICHE AUSGABEN",null,null,{"$f":"SUM((Geschenke[Tatsächlich],(Verpackung[Tatsächlich],(Reisen[Tatsächlich],(Mahlzeiten[Tatsächlich],(Bewirtung[Tatsächlich],(Sonstiges[Tatsächlich])))))))","v":{"v":820,"d":"820.00 €"}}]
[]
[{"$nulls":10},"DIFFERENZ (über/unter Budget)",null,null,{"$f":"SUM(N3-N4)","v":{"v":-70,"d":"-70.00 €"}}]
[]
[]
[null,null,"GESCHENKE",{"$nulls":7},"FEIERTAGSESSEN"]
[null,null,"Posten","Budget","Tatsächlich","Differenz",{"$nulls":4},"Posten","Budget","Tatsächlich","Differenz"]
[null,null,"Familie",{"v":500,"d":"500.00 €"},{"v":495,"d":"495.00 €"},{"$f":"Geschenke[[#This Row],[Budget]]-Geschenke[[#This Row],[Tatsächlich]]","v":{"v":5,"d":"5.00 €"}},{"$nulls":4},"Lebensmittel",null,null,{"$f":"Mahlzeiten[[#This Row],[Budget]]-Mahlzeiten[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Freunde",{"v":250,"d":"250.00 €"},{"v":325,"d":"325.00 €"},{"$f":"Geschenke[[#This Row],[Budget]]-Geschenke[[#This Row],[Tatsächlich]]","v":{"v":-75,"d":"-75.00 €"}},{"$nulls":4},"Getränke",null,null,{"$f":"Mahlzeiten[[#This Row],[Budget]]-Mahlzeiten[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Kollegen",null,null,{"$f":"Geschenke[[#This Row],[Budget]]-Geschenke[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Dekoration",null,null,{"$f":"Mahlzeiten[[#This Row],[Budget]]-Mahlzeiten[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Lehrer, Kinderbetreuer, Babysitter usw.",null,null,{"$f":"Geschenke[[#This Row],[Budget]]-Geschenke[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Sonstiges (Drücken Sie die TABULATORTASTE in der letzten Spalte dieser Zeile, um weitere Zeilen hinzuzufügen.)",null,null,{"$f":"Mahlzeiten[[#This Row],[Budget]]-Mahlzeiten[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Gemeinnützige Spenden",null,null,{"$f":"Geschenke[[#This Row],[Budget]]-Geschenke[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":7},{"$f":"Mahlzeiten[[#This Row],[Budget]]-Mahlzeiten[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Sonstiges (Drücken Sie die TABULATORTASTE in der letzten Spalte dieser Zeile, um weitere Zeilen hinzuzufügen.)",null,null,{"$f":"Geschenke[[#This Row],[Budget]]-Geschenke[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Ergebnis",{"$f":"SUBTOTAL(109,Geschenke[Budget])","v":{"v":750,"d":"750.00 €"}},{"$f":"SUBTOTAL(109,Geschenke[Tatsächlich])","v":{"v":820,"d":"820.00 €"}},{"$f":"SUBTOTAL(109,Geschenke[Differenz])","v":{"v":-70,"d":"-70.00 €"}},{"$nulls":4},"Ergebnis",{"$f":"SUBTOTAL(109,Mahlzeiten[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Mahlzeiten[Tatsächlich])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Mahlzeiten[Differenz])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"VERPACKUNG",{"$nulls":7},"BEWIRTUNG"]
[null,null,"Posten","Budget","Tatsächlich","Differenz",{"$nulls":4},"Posten","Budget","Tatsächlich","Differenz"]
[null,null,"Geschenkverpackung",null,null,{"$f":"Verpackung[[#This Row],[Budget]]-Verpackung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Partyhilfen (Barkeeper, Catering, Reinigung, usw.)",null,null,{"$f":"Bewirtung[[#This Row],[Budget]]-Bewirtung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Etiketten",null,null,{"$f":"Verpackung[[#This Row],[Budget]]-Verpackung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Dekoration",null,null,{"$f":"Bewirtung[[#This Row],[Budget]]-Bewirtung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Zubehör (Geschenkband, Klebestreifen, usw.)",null,null,{"$f":"Verpackung[[#This Row],[Budget]]-Verpackung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Speisen und Getränke",null,null,{"$f":"Bewirtung[[#This Row],[Budget]]-Bewirtung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Kartons",null,null,{"$f":"Verpackung[[#This Row],[Budget]]-Verpackung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Kleidung",null,null,{"$f":"Bewirtung[[#This Row],[Budget]]-Bewirtung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Porto",null,null,{"$f":"Verpackung[[#This Row],[Budget]]-Verpackung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Eintrittskarten",null,null,{"$f":"Bewirtung[[#This Row],[Budget]]-Bewirtung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Sonstiges (Drücken Sie die TABULATORTASTE in der letzten Spalte dieser Zeile, um weitere Zeilen hinzuzufügen.)",null,null,{"$f":"Verpackung[[#This Row],[Budget]]-Verpackung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Essen im Restaurant",null,null,{"$f":"Bewirtung[[#This Row],[Budget]]-Bewirtung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":10},"Sonstiges (Drücken Sie die TABULATORTASTE in der letzten Spalte dieser Zeile, um weitere Zeilen hinzuzufügen.)",null,null,{"$f":"Bewirtung[[#This Row],[Budget]]-Bewirtung[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Ergebnis",{"$f":"SUBTOTAL(109,Verpackung[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Verpackung[Tatsächlich])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Verpackung[Differenz])","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Ergebnis",{"$f":"SUBTOTAL(109,Bewirtung[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Bewirtung[Tatsächlich])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Bewirtung[Differenz])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"REISE",{"$nulls":7},"SONSTIGES"]
[null,null,"Posten","Budget","Tatsächlich","Differenz",{"$nulls":4},"Posten","Budget","Tatsächlich","Differenz"]
[null,null,"Flugkosten",null,null,{"$f":"Reisen[[#This Row],[Budget]]-Reisen[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Fotos",null,null,{"$f":"Sonstiges[[#This Row],[Budget]]-Sonstiges[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Unterkunft",null,null,{"$f":"Reisen[[#This Row],[Budget]]-Reisen[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Gas ",null,null,{"$f":"Sonstiges[[#This Row],[Budget]]-Sonstiges[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Beförderung",null,null,{"$f":"Reisen[[#This Row],[Budget]]-Reisen[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Sonstiges (Drücken Sie die TABULATORTASTE in der letzten Spalte dieser Zeile, um weitere Zeilen hinzuzufügen.)",null,null,{"$f":"Sonstiges[[#This Row],[Budget]]-Sonstiges[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Sonstiges (Drücken Sie die TABULATORTASTE in der letzten Spalte dieser Zeile, um weitere Zeilen hinzuzufügen.)",null,null,{"$f":"Reisen[[#This Row],[Budget]]-Reisen[[#This Row],[Tatsächlich]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Ergebnis",{"$f":"SUBTOTAL(109,Reisen[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Reisen[Tatsächlich])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Reisen[Differenz])","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Ergebnis",{"$f":"SUBTOTAL(109,Sonstiges[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Sonstiges[Tatsächlich])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Sonstiges[Differenz])","v":{"v":0,"d":"0.00 €"}}]