{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Partyübersicht","Gästeliste","Essen und Getränke","Sonstiges Wichtiges","Raster für Sitzordnung"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Partyübersicht","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"merged":[[6,3,6,4],[6,5,6,6],[9,1,9,2]]}
[]
[]
[null,"Partyübersicht"]
[]
[]
[null,"ANLASS",null,"ZUSAMMENFASSUNG GÄSTE",{"$nulls":3},{"$f":"\"UAWGS AUSSTEHEND: \"&UAwgAusstehend","v":"UAWGS AUSSTEHEND: 2"}]
[null,"Omas 75. Geburtstag",null,"ÜBERSICHT UAWG",null,"KOSTEN PRO GAST",null,"BUDGETBETRAG"]
[{"$nulls":3},"Bestätigte Gäste","Gesamt Bestätigt","Essen","Sonstiges","Summe"]
[null,"DATUM",null,"Erwachsene",{"$f":"SUMIF(Gästetabelle[TEILNAHME?],\"=Ja\",Gästetabelle[ERWACHSENE])","v":26},{"$f":"Essenstabelle[[#Totals],[KOSTEN PRO ERWACHSENEM]]","v":{"v":12.690089084110037,"d":"12.69 €"}},{"$f":"GrundlegendeKostenProGast","v":{"v":18.695652173913043,"d":"18.70 €"}},{"$f":"(TeilnehmerZusammenfassung[[#This Row],[Essen]]+TeilnehmerZusammenfassung[[#This Row],[Sonstiges]])*ErwachseneGesamt","v":{"v":816.0292727086002,"d":"816.03 €"}}]
[null,"14. Juni 2011",null,"Kinder",{"$f":"SUMIF(Gästetabelle[TEILNAHME?],\"=Ja\",Gästetabelle[KINDER])","v":20},{"$f":"Essenstabelle[[#Totals],[KOSTEN PRO KIND]]","v":{"v":7.252884190656953,"d":"7.25 €"}},{"$f":"GrundlegendeKostenProGast","v":{"v":18.695652173913043,"d":"18.70 €"}},{"$f":"(TeilnehmerZusammenfassung[[#This Row],[Essen]]+TeilnehmerZusammenfassung[[#This Row],[Sonstiges]])*KinderGesamt","v":{"v":518.9707272914,"d":"518.97 €"}}]
[{"$nulls":3},"Ergebnis",{"$f":"SUBTOTAL(109,TeilnehmerZusammenfassung[Gesamt Bestätigt])","v":46},{"$f":"\"Durchschn.   \"&TEXT(SUBTOTAL(101,TeilnehmerZusammenfassung[Essen]),\"#.##0,00€\")","v":"Durchschn.   9,97€"},{"$f":"\"Durchschn.   \"&TEXT(SUBTOTAL(101,TeilnehmerZusammenfassung[Sonstiges]),\"#.##0,00€\")","v":"Durchschn.   18,70€"},{"$f":"SUBTOTAL(109,TeilnehmerZusammenfassung[Summe])","v":{"v":1335,"d":"1,335.00 €"}}]
[null,"UHRZEIT"]
[null,"14:00:00 bis 16:00:00 Uhr"]
[]
[null,"ORT",null,"ZUSAMMENFASSUNG BUDGET"]
[null,"Mehrzweckhalle in Münchfeld",null,"POSTEN","ANZAHL","BUDGETBETRAG","GESAMTKOSTEN","DIFFERENZ"]
[{"$nulls":3},"Essen und Getränke",{"$f":"COUNTA(Essenstabelle[ESSEN ODER GETRÄNK])","v":18},{"v":500,"d":"500.00 €"},{"$f":"Essenstabelle[[#Totals],[GESAMTKOSTEN]]","v":{"v":475,"d":"475.00 €"}},{"$f":"BudgetÜbersicht[[#This Row],[BUDGETBETRAG]]-BudgetÜbersicht[[#This Row],[GESAMTKOSTEN]]","v":{"v":25,"d":"25.00 €"}}]
[{"$nulls":3},{"$f":"Tabelle1Kopfzeile","v":"Einrichtung und Lieferungen"},{"$f":"COUNTA(Tabelle1Budget[Einrichtung und Lieferungen])","v":7},{"v":400,"d":"400.00 €"},{"$f":"Tabelle1Budget[[#Totals],[Kosten]]","v":{"v":400,"d":"400.00 €"}},{"$f":"BudgetÜbersicht[[#This Row],[BUDGETBETRAG]]-BudgetÜbersicht[[#This Row],[GESAMTKOSTEN]]","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},{"$f":"Tabelle2Kopfzeile","v":"Dekorationen"},{"$f":"COUNTA(Tabelle2Budget[Dekorationen])","v":4},{"v":150,"d":"150.00 €"},{"$f":"Tabelle2Budget[[#Totals],[Kosten]]","v":{"v":175,"d":"175.00 €"}},{"$f":"BudgetÜbersicht[[#This Row],[BUDGETBETRAG]]-BudgetÜbersicht[[#This Row],[GESAMTKOSTEN]]","v":{"v":-25,"d":"-25.00 €"}}]
[{"$nulls":3},{"$f":"Tabelle3Kopfzeile","v":"Sonstiges"},{"$f":"COUNTA(Tabelle3Budget[Sonstiges])","v":4},{"v":300,"d":"300.00 €"},{"$f":"Tabelle3Budget[[#Totals],[Kosten]]","v":{"v":285,"d":"285.00 €"}},{"$f":"BudgetÜbersicht[[#This Row],[BUDGETBETRAG]]-BudgetÜbersicht[[#This Row],[GESAMTKOSTEN]]","v":{"v":15,"d":"15.00 €"}}]
[{"$nulls":3},"Ergebnis",{"$f":"SUBTOTAL(109,BudgetÜbersicht[ANZAHL])","v":33},{"$f":"SUBTOTAL(109,BudgetÜbersicht[BUDGETBETRAG])","v":{"v":1350,"d":"1,350.00 €"}},{"$f":"SUBTOTAL(109,BudgetÜbersicht[GESAMTKOSTEN])","v":{"v":1335,"d":"1,335.00 €"}},{"$f":"BudgetÜbersicht[[#Totals],[BUDGETBETRAG]]-BudgetÜbersicht[[#Totals],[GESAMTKOSTEN]]","v":{"v":15,"d":"15.00 €"}}]

{"sheet":"Gästeliste","index":1,"n_rows":22,"n_cols":12,"rows_kept":22}
[]
[]
[null,"Gästeliste"]
[]
[]
[]
[null,"NAME","ADRESSE","ORT","BUNDESLAND","PLZ","TELEFON","E-MAIL-ADRESSE","TEILNAHME?","KINDER","ERWACHSENE","SUMME"]
[null,"Familie 1","Adresse 1","Ort 1","Bundesland 1","PLZ 1","Telefon 1","E-Mail1","Nein",2,2,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":4}]
[null,"Familie 2","Adresse 2","Ort 2","Bundesland 2","PLZ 2","Telefon 2","E-Mail2","Ja",1,1,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":2}]
[null,"Familie 3","Adresse 3","Ort 3","Bundesland 3","PLZ 3","Telefon 3","E-Mail3","Ja",3,3,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":6}]
[null,"Familie 4","Adresse 4","Ort 4","Bundesland 4","PLZ 4","Telefon 4","E-Mail4",null,null,2,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":2}]
[null,"Familie 5","Adresse 5","Ort 5","Bundesland 5","PLZ 5","Telefon 5","E-Mail5","Ja",4,3,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":7}]
[null,"Familie 6","Adresse 6","Ort 6","Bundesland 6","PLZ 6","Telefon 6","E-Mail6","Ja",2,2,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":4}]
[null,"Familie 7","Adresse 7","Ort 7","Bundesland 7","PLZ 7","Telefon 7","E-Mail7","Ja",1,4,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":5}]
[null,"Familie 8","Adresse 8","Ort 8","Bundesland 8","PLZ 8","Telefon 8","E-Mail8","Nein",5,3,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":8}]
[null,"Familie 9","Adresse 9","Ort 9","Bundesland 9","PLZ 9","Telefon 9","E-Mail9","Ja",3,2,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":5}]
[null,"Familie 10","Adresse 10","Ort 10","Bundesland 10","PLZ 10","Telefon 10","E-Mail10","Ja",null,4,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":4}]
[null,"Familie 11","Adresse 11","Ort 11","Bundesland 11","PLZ 11","Telefon 11","E-Mail11","Ja",3,5,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":8}]
[null,"Familie 12","Adresse 12","Ort 12","Bundesland 12","PLZ 12","Telefon 12","E-Mail12","Nein",2,3,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":5}]
[null,"Familie 13","Adresse 13","Ort 13","Bundesland 13","PLZ 13","Telefon 13","E-Mail13","Ja",3,2,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":5}]
[null,"Familie 14","Adresse 14","Ort 14","Bundesland 14","PLZ 14","Telefon 14","E-Mail14","Nein",null,1,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":1}]
[null,"Familie 15","Adresse 15","Ort 15","Bundesland 15","PLZ 15","Telefon 15","E-Mail15",null,null,2,{"$f":"SUM(Gästetabelle[[#This Row],[KINDER]:[ERWACHSENE]])","v":2}]

{"sheet":"Essen und Getränke","index":2,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[]
[null,"Essen und Getränke"]
[]
[null,"Geben Sie die Kosten und geschätzten Portionen ein, damit die Summe der Stücke und die Kosten pro Portion anhand der Gesamtzahl der Teilnehmer automatisch berechnet wird."]
[null,"ESSEN ODER GETRÄNK","GESAMTKOSTEN","PORTION PRO KIND","PORTION PRO ERWACHSENEM","SUMME PORTIONEN","KOSTEN PRO PORTION","KOSTEN PRO KIND","KOSTEN PRO ERWACHSENEM","ANMERKUNGEN"]
[null,"Mineralwasser",{"v":15,"d":"15.00 €"},0.5,2,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":62},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.24193548387096775,"d":"0.24 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.12096774193548387,"d":"0.12 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.4838709677419355,"d":"0.48 €"}},"2-Liter-Flaschen"]
[null,"Fruchtsäfte",{"v":15,"d":"15.00 €"},2,0,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":40},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.375,"d":"0.38 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.75,"d":"0.75 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0,"d":"0.00 €"}},"Apfelsaft und weißer Traubensaft"]
[null,"Wein",{"v":50,"d":"50.00 €"},0,2,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":52},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.9615384615384616,"d":"0.96 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":1.9230769230769231,"d":"1.92 €"}}]
[null,"Torte",{"v":75,"d":"75.00 €"},1,1,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":46},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":1.6304347826086956,"d":"1.63 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":1.6304347826086956,"d":"1.63 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":1.6304347826086956,"d":"1.63 €"}},"Bei \"unserem\" Bäcker bestellen"]
[null,"Eiscreme",{"v":20,"d":"20.00 €"},1,1.5,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":59},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.3389830508474576,"d":"0.34 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.3389830508474576,"d":"0.34 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.5084745762711864,"d":"0.51 €"}}]
[null,"Puddingbecher",{"v":15,"d":"15.00 €"},1,0,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":20},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.75,"d":"0.75 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.75,"d":"0.75 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0,"d":"0.00 €"}},"Verpackte kaufen: Vanille und Schokolade"]
[null,"Gefüllte Champignons",{"v":32,"d":"32.00 €"},1,2,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":72},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.4444444444444444,"d":"0.44 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.4444444444444444,"d":"0.44 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.8888888888888888,"d":"0.89 €"}},"Champignonköpfe, gefüllt mit Frischkäse und Brät"]
[null,"Bruschetta",{"v":22,"d":"22.00 €"},0,3,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":78},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.28205128205128205,"d":"0.28 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.8461538461538461,"d":"0.85 €"}},"Tomaten mit Basilikum"]
[null,"Räucherlachs",{"v":50,"d":"50.00 €"},1,2,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":72},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.6944444444444444,"d":"0.69 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.6944444444444444,"d":"0.69 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":1.3888888888888888,"d":"1.39 €"}}]
[null,"Minibrötchen",{"v":20,"d":"20.00 €"},1,2,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":72},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.2777777777777778,"d":"0.28 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.2777777777777778,"d":"0.28 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.5555555555555556,"d":"0.56 €"}},"4 Tüten – gemischt"]
[null,"Frischkäse",{"v":10,"d":"10.00 €"},1,2,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":72},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.1388888888888889,"d":"0.14 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.1388888888888889,"d":"0.14 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.2777777777777778,"d":"0.28 €"}},"2 große Schüsseln"]
[null,"Kapern",{"v":12,"d":"12.00 €"},1,2,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":72},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.16666666666666666,"d":"0.17 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.16666666666666666,"d":"0.17 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.3333333333333333,"d":"0.33 €"}},"3 Gläser"]
[null,"Hähnchenschenkel",{"v":45,"d":"45.00 €"},2,4,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":144},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.3125,"d":"0.31 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.625,"d":"0.63 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":1.25,"d":"1.25 €"}},"Bei \"unserer\" Hähnchenbraterei kaufen"]
[null,"Nudelsalat",{"v":10,"d":"10.00 €"},4,6,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":236},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.0423728813559322,"d":"0.04 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.1694915254237288,"d":"0.17 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.2542372881355932,"d":"0.25 €"}},"Abends vorher machen"]
[null,"Blätterteigstangen",{"v":14,"d":"14.00 €"},4,6,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":236},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.059322033898305086,"d":"0.06 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.23728813559322035,"d":"0.24 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.3559322033898305,"d":"0.36 €"}},"Abends vorher machen"]
[null,"Gemischtes Gemüse",{"v":30,"d":"30.00 €"},4,10,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":340},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.08823529411764706,"d":"0.09 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.35294117647058826,"d":"0.35 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.8823529411764707,"d":"0.88 €"}},"Fingermöhrchen, Stangensellerie, Brokkoli, Blumenkohl, rote und grüne Paprikaschoten"]
[null,"Käsebällchen",{"v":15,"d":"15.00 €"},5,10,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":360},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.041666666666666664,"d":"0.04 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.20833333333333331,"d":"0.21 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.41666666666666663,"d":"0.42 €"}},"Gemischt: Frischkäse, Camembert mit Nüssen"]
[null,"Knabbergebäck",{"v":25,"d":"25.00 €"},5,10,{"$f":"(Essenstabelle[[#This Row],[PORTION PRO KIND]]*KinderGesamt)+(Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]]*ErwachseneGesamt)","v":360},{"$f":"IFERROR(Essenstabelle[[#This Row],[GESAMTKOSTEN]]/Essenstabelle[[#This Row],[SUMME PORTIONEN]],\"\")","v":{"v":0.06944444444444445,"d":"0.07 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO KIND]],\"\")","v":{"v":0.3472222222222222,"d":"0.35 €"}},{"$f":"IFERROR(Essenstabelle[[#This Row],[KOSTEN PRO PORTION]]*Essenstabelle[[#This Row],[PORTION PRO ERWACHSENEM]],\"\")","v":{"v":0.6944444444444444,"d":"0.69 €"}},"Gemischt"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Essenstabelle[GESAMTKOSTEN])","v":{"v":475,"d":"475.00 €"}},{"$f":"SUBTOTAL(109,Essenstabelle[PORTION PRO KIND])","v":34.5},{"$f":"SUBTOTAL(109,Essenstabelle[PORTION PRO ERWACHSENEM])","v":65.5},{"$f":"SUBTOTAL(109,Essenstabelle[SUMME PORTIONEN])","v":2393},{"$f":"SUBTOTAL(109,Essenstabelle[KOSTEN PRO PORTION])","v":{"v":6.915706603622084,"d":"6.92 €"}},{"$f":"SUBTOTAL(109,Essenstabelle[KOSTEN PRO KIND])","v":{"v":7.252884190656953,"d":"7.25 €"}},{"$f":"SUBTOTAL(109,Essenstabelle[KOSTEN PRO ERWACHSENEM])","v":{"v":12.690089084110037,"d":"12.69 €"}}]

{"sheet":"Sonstiges Wichtiges","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[14,1,14,4],[22,1,22,4]]}
[]
[]
[null,"Sonstiges Wichtiges"]
[]
[]
[null,"Einrichtung und Lieferungen","Kosten","Gekauft","Anmerkungen"]
[null,"Raum-/Saalmiete",{"v":250,"d":"250.00 €"},"Ja"]
[null,"Tischwäsche",{"v":30,"d":"30.00 €"},"Ja","Miete"]
[null,"Tische und Stühle",{"v":0,"d":"0.00 €"},null,"In Saalmiete enthalten"]
[null,"Papierservietten",{"v":25,"d":"25.00 €"}]
[null,"Stoffservietten",{"v":20,"d":"20.00 €"},null,"Miete"]
[null,"Tafelservice",{"v":50,"d":"50.00 €"},null,"Miete"]
[null,"Gläser",{"v":25,"d":"25.00 €"},null,"Miete"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle1Budget[Kosten])","v":{"v":400,"d":"400.00 €"}}]
[]
[]
[null,"Dekorationen","Kosten","Gekauft","Anmerkungen"]
[null,"Ballons",{"v":25,"d":"25.00 €"}]
[null,"Heliumpatrone",{"v":50,"d":"50.00 €"},null,"Miete"]
[null,"Gestecke",{"v":100,"d":"100.00 €"},"Ja","insgesamt 10"]
[null,"Glasvasen",{"v":0,"d":"0.00 €"},null,"Von Sabine ausleihen"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle2Budget[Kosten])","v":{"v":175,"d":"175.00 €"}}]
[]
[]
[null,"Sonstiges","Kosten","Gekauft","Anmerkungen"]
[null,"Einladungen",{"v":50,"d":"50.00 €"},"Ja"]
[null,"Porto",{"v":60,"d":"60.00 €"},"Ja"]
[null,"Fotograf",{"v":125,"d":"125.00 €"},null,"2 Stunden (14:00 bis 16:00 Uhr)"]
[null,"Partyartikel",{"v":50,"d":"50.00 €"}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle3Budget[Kosten])","v":{"v":285,"d":"285.00 €"}}]

{"sheet":"Raster für Sitzordnung","index":4,"n_rows":43,"n_cols":34,"rows_kept":43,"merged":[[35,0,35,17],[35,19,35,33]]}
["Sitzordnung"]
{"$rows_empty":33}
[{"$nulls":33},"*1 Quadrat = ca. 30 x 30 cm"]
["Anmerkungen",{"$nulls":18},{"$f":"\" Bestätigte Gäste gesamt: \"&BestätigteGäste","v":" Bestätigte Gäste gesamt: 46"}]
[{"$nulls":19},"Sie können eine der folgenden Tischordnungen verwenden:"]
[{"$nulls":20},{"$f":"ROUNDUP(BestätigteGäste/6,0)&\" Runde Tische, 140 cm (6 Sitzplätze)\"","v":"8 Runde Tische, 140 cm (6 Sitzplätze)"}]
[{"$nulls":20},{"$f":"ROUNDUP(BestätigteGäste/8,0) &\"Runde Tische, 153 cm (8 Sitzplätze)\"","v":"6Runde Tische, 153 cm (8 Sitzplätze)"}]
[{"$nulls":20},{"$f":"ROUNDUP(BestätigteGäste/10,0)&\" Runde Tische, 183 cm (10 Sitzplätze)\"","v":"5 Runde Tische, 183 cm (10 Sitzplätze)"}]
[{"$nulls":20},{"$f":"ROUNDUP(BestätigteGäste/6,0)& \" Rechteckige Tische, 76 x 183 cm (6 Sitzplätze)\"","v":"8 Rechteckige Tische, 76 x 183 cm (6 Sitzplätze)"}]
[{"$nulls":20},{"$f":"ROUNDUP(BestätigteGäste/8,0)&\" Rechteckige Tische, 76 x 244 cm (8 Sitzplätze)\"","v":"6 Rechteckige Tische, 76 x 244 cm (8 Sitzplätze)"}]
[{"$nulls":19},"(Bevorzugter Abstand zwischen Tischen: ca. 107 cm)"]