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

{"sheet":"Budgetzusammenfassung","index":0,"n_rows":28,"n_cols":7,"rows_kept":28}
[{"$nulls":6}," "]
[]
[null,"GESAMTES HOCHZEITSBUDGET",{"v":20000,"d":"20,000 €"}]
[]
[null,"AUSGABEN","Zuteilung \n%","Zugewiesenes Budget","Geschätzte \nKosten","Tatsächliche \nKosten"]
[null,"Empfang",{"v":0.5,"d":"50%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C6","v":{"v":10000,"d":"10,000 €"}},{"$f":"Tabelle_Empfang[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_Empfang[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Bekleidung",{"v":0.1,"d":"10%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C7","v":{"v":2000,"d":"2,000 €"}},{"$f":"Tabelle_Kleiderordnung[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_Kleiderordnung[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Blumen und Dekorationen",{"v":0.1,"d":"10%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C8","v":{"v":2000,"d":"2,000 €"}},{"$f":"Tabelle_BlumenDekorationen[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_BlumenDekorationen[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Musik",{"v":0.1,"d":"10%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C9","v":{"v":2000,"d":"2,000 €"}},{"$f":"Tabelle_Musik[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_Musik[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Fotos und Video",{"v":0.1,"d":"10%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C10","v":{"v":2000,"d":"2,000 €"}},{"$f":"Tabelle_FotosVideos[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_FotosVideos[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Gastgeschenke und Geschenke",{"v":0.03,"d":"3%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C11","v":{"v":600,"d":"600 €"}},{"$f":"Tabelle_GefälligkeitenGeschenke[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_GefälligkeitenGeschenke[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Zeremonie",{"v":0.02,"d":"2%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C12","v":{"v":400,"d":"400 €"}},{"$f":"Tabelle_Zeremonie[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_Zeremonie[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Papierwaren",{"v":0.02,"d":"2%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C13","v":{"v":400,"d":"400 €"}},{"$f":"Tabelle_Drucksachen[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_Drucksachen[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Eheringe",{"v":0.02,"d":"2%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C14","v":{"v":400,"d":"400 €"}},{"$f":"Tabelle_Eheringe[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_Eheringe[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Transport",{"v":0.01,"d":"1%"},{"$f":"Hochzeit_Budget_Gesamt*Budgetzusammenfassung!$C15","v":{"v":200,"d":"200 €"}},{"$f":"Tabelle_Beförderung[[#Totals],[Geschätzte Kosten]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabelle_Beförderung[[#Totals],[Ist-Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUM(C6:C15)","v":{"v":1,"d":"100%"}},{"$f":"SUM(D6:D15)","v":{"v":20000,"d":"20,000 €"}},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[]
[null,"BEITRÄGE"]
[null,"Herkunft der Mittel","Beitrag"]
[null,"Spareinlagen",{"v":10000,"d":"10,000 €"}]
[null,"Mutter & Vater von Partner 1",{"v":4000,"d":"4,000 €"}]
[null,"Großeltern von Partner 1",{"v":2000,"d":"2,000 €"}]
[null,"Mutter & Vater von Partner 2",{"v":4000,"d":"4,000 €"}]
[null,"Großeltern von Partner 2",{"v":4000,"d":"4,000 €"}]
[null,"Andere Beiträge",{"v":2000,"d":"2,000 €"}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_Deckungsbeiträge[Beitrag])","v":{"v":26000,"d":"26,000 €"}}]
[]
[null,{"$f":"IF(Tabelle_Deckungsbeiträge[[#Totals],[Beitrag]]<Hochzeit_Budget_Gesamt,\"Differenz zum Ausgleichen\",\"Verfügbare zusätzliche Mittel\")","v":"Verfügbare zusätzliche Mittel"},{"$f":"IF(Tabelle_Deckungsbeiträge[[#Totals],[Beitrag]]<Hochzeit_Budget_Gesamt,Hochzeit_Budget_Gesamt-Tabelle_Deckungsbeiträge[[#Totals],[Beitrag]],Tabelle_Deckungsbeiträge[[#Totals],[Beitrag]]-Hochzeit_Budget_Gesamt)","v":{"v":6000,"d":"6,000 €"}}]

{"sheet":"Budgetdetails","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"EMPFANG","Geschätzte Kosten","Ist-Kosten"]
[null,"Veranstaltungsort und Vermietung"]
[null,"Verpflegung und Service"]
[null,"Getränke"]
[null,"Torte"]
[null,"Verschiedene Gebühren"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_Empfang[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_Empfang[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"BEKLEIDUNG","Geschätzte Kosten","Ist-Kosten"]
[null,"Smoking, Anzug und/oder Kleider"]
[null,"Änderungen"]
[null,"Kopfbedeckung und Schleier"]
[null,"Accessoires"]
[null,"Frisur und Make-up"]
[null,"Verschiedene Gebühren"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_Kleiderordnung[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_Kleiderordnung[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"BLUMEN UND DEKORATIONEN","Geschätzte Kosten","Ist-Kosten"]
[null,"Blumendekoration für die Zeremonie"]
[null,"Blumenmädchen Blüten und Korb"]
[null,"Ringkissen"]
[null,"Sträuße"]
[null,"Boutonnieres"]
[null,"Anstecksträuße"]
[null,"Dekorationen für den Empfang"]
[null,"Beleuchtung"]
[null,"Verschiedene Gebühren"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_BlumenDekorationen[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_BlumenDekorationen[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"MUSIK","Geschätzte Kosten","Ist-Kosten"]
[null,"Zeremonie Musiker"]
[null,"Cocktailempfang Musiker"]
[null,"Empfangsband, DJ oder Unterhaltung"]
[null,"Sound-System oder Tanzflächenverleih"]
[null,"Verschiedene Gebühren"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_Musik[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_Musik[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"FOTOS UND VIDEO","Geschätzte Kosten","Ist-Kosten"]
[null,"Fotografie"]
[null,"Videografie"]
[null,"Zusätzliche Fotoabzüge und Alben"]
[null,"Verschiedene Gebühren"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_FotosVideos[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_FotosVideos[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"GASTGESCHENKE UND GESCHENKE","Geschätzte Kosten","Ist-Kosten"]
[null,"Willkommensgeschenke"]
[null,"Party Geschenke"]
[null,"Verschiedene Gebühren"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_GefälligkeitenGeschenke[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_GefälligkeitenGeschenke[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"ZEREMONIE","Geschätzte Kosten","Ist-Kosten"]
[null,"Platzgebühr"]
[null,"Pfarrer Gebühr oder Kirchenspende"]
[null,"Verschiedene Gebühren"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_Zeremonie[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_Zeremonie[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"PAPIERWAREN","Geschätzte Kosten","Ist-Kosten"]
[null,"Save-the-date-Karten"]
[null,"Einladungen und RSVPs"]
[null,"Programme"]
[null,"Sitzplatz-und Platzkarten"]
[null,"Menükarten"]
[null,"Dankschreiben"]
[null,"Porto"]
[null,"Verschiedene Gebühren"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_Drucksachen[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_Drucksachen[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"EHERINGE","Geschätzte Kosten","Ist-Kosten"]
[null,"Eheringe"]
[null,"Eheringe Accessoires"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_Eheringe[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_Eheringe[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"TRANSPORT","Geschätzte Kosten","Ist-Kosten"]
[null,"Hauptmietwagen"]
[null,"Autovermietung für Gäste"]
[null,"Transport für auswärtige Gäste"]
[null,"Parkservice"]
[null,"Verschiedene Gebühren"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle_Beförderung[Geschätzte Kosten])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle_Beförderung[Ist-Kosten])","v":{"v":0,"d":"0.00 €"}}]