{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Feestoverzicht","Gastenlijst","Eten en drinken","Andere belangrijke punten","Raster voor tafelindeling"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Feestoverzicht","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,"Feestoverzicht"]
[]
[]
[null,"EVENEMENT",null,"GASTENLIJST",{"$nulls":3},{"$f":"\"RSVP'S ZONDER REACTIE: \"&RSVPsZonderReactie","v":"RSVP'S ZONDER REACTIE: 2"}]
[null,"75e verjaardag van oma",null,"RSVP-OVERZICHT",null,"KOSTEN PER GAST",null,"BUDGETBEDRAG"]
[{"$nulls":3},"Bevestigde gasten","Totaal bevestigd","Eten","Overig","Totaal"]
[null,"DATUM",null,"Volwassenen",{"$f":"SUMIF(TafelMetGasten[AANWEZIG?],\"=Ja\",TafelMetGasten[VOLWASSENEN])","v":26},{"$f":"TafelMetVoeding[[#Totals],[KOSTEN PER VOLWASSENE]]","v":{"v":12.690089084110037,"d":"€ 12.69"}},{"$f":"BasiskostenPerGast","v":{"v":18.695652173913043,"d":"€ 18.70"}},{"$f":"(OverzichtDeelnemers[[#This Row],[Eten]]+OverzichtDeelnemers[[#This Row],[Overig]])*AantalVolwassenen","v":{"v":816.0292727086002,"d":"€ 816.03"}}]
[null,"2011-06-14",null,"Kinderen",{"$f":"SUMIF(TafelMetGasten[AANWEZIG?],\"=Ja\",TafelMetGasten[KINDEREN])","v":20},{"$f":"TafelMetVoeding[[#Totals],[KOSTEN PER KIND]]","v":{"v":7.252884190656953,"d":"€ 7.25"}},{"$f":"BasiskostenPerGast","v":{"v":18.695652173913043,"d":"€ 18.70"}},{"$f":"(OverzichtDeelnemers[[#This Row],[Eten]]+OverzichtDeelnemers[[#This Row],[Overig]])*AantalKinderen","v":{"v":518.9707272914,"d":"€ 518.97"}}]
[{"$nulls":3},"Totaal",{"$f":"SUBTOTAL(109,OverzichtDeelnemers[Totaal bevestigd])","v":46},{"$f":"\"Gem.     \"&TEXT(SUBTOTAL(101,OverzichtDeelnemers[Eten]),\"€ #.##0,00\")","v":"Gem.     € 9,97"},{"$f":"\"Gem.     \"&TEXT(SUBTOTAL(101,OverzichtDeelnemers[Overig]),\"€ #.##0,00\")","v":"Gem.     € 18,70"},{"$f":"SUBTOTAL(109,OverzichtDeelnemers[Totaal])","v":{"v":1335,"d":"€ 1,335.00"}}]
[null,"TIJD"]
[null,"14:00 tot 16:00"]
[]
[null,"LOCATIE",null,"BUDGETOVERZICHT"]
[null,"Huis van tante Kim",null,"ARTIKEL","AANTAL","BUDGETBEDRAG","TOTALE KOSTEN","VERSCHIL"]
[{"$nulls":3},"Eten en drinken",{"$f":"COUNTA(TafelMetVoeding[EET- OF DRINKARTIKEL])","v":18},{"v":500,"d":"€ 500.00"},{"$f":"TafelMetVoeding[[#Totals],[TOTALE KOSTEN]]","v":{"v":475,"d":"€ 475.00"}},{"$f":"Budgetoverzicht[[#This Row],[BUDGETBEDRAG]]-Budgetoverzicht[[#This Row],[TOTALE KOSTEN]]","v":{"v":25,"d":"€ 25.00"}}]
[{"$nulls":3},{"$f":"Tabel1Kop","v":"Apparatuur en benodigdheden"},{"$f":"COUNTA(Tabel1Budget[Apparatuur en benodigdheden])","v":7},{"v":400,"d":"€ 400.00"},{"$f":"Tabel1Budget[[#Totals],[Kosten]]","v":{"v":400,"d":"€ 400.00"}},{"$f":"Budgetoverzicht[[#This Row],[BUDGETBEDRAG]]-Budgetoverzicht[[#This Row],[TOTALE KOSTEN]]","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":3},{"$f":"Tabel2Kop","v":"Decoraties"},{"$f":"COUNTA(Tabel2Budget[Decoraties])","v":4},{"v":150,"d":"€ 150.00"},{"$f":"Tabel2Budget[[#Totals],[Kosten]]","v":{"v":175,"d":"€ 175.00"}},{"$f":"Budgetoverzicht[[#This Row],[BUDGETBEDRAG]]-Budgetoverzicht[[#This Row],[TOTALE KOSTEN]]","v":{"v":-25,"d":"€ -25.00"}}]
[{"$nulls":3},{"$f":"Tabel3Kop","v":"Overig"},{"$f":"COUNTA(Tabel3Budget[Overig])","v":4},{"v":300,"d":"€ 300.00"},{"$f":"Tabel3Budget[[#Totals],[Kosten]]","v":{"v":285,"d":"€ 285.00"}},{"$f":"Budgetoverzicht[[#This Row],[BUDGETBEDRAG]]-Budgetoverzicht[[#This Row],[TOTALE KOSTEN]]","v":{"v":15,"d":"€ 15.00"}}]
[{"$nulls":3},"Totaal",{"$f":"SUBTOTAL(109,Budgetoverzicht[AANTAL])","v":33},{"$f":"SUBTOTAL(109,Budgetoverzicht[BUDGETBEDRAG])","v":{"v":1350,"d":"€ 1,350.00"}},{"$f":"SUBTOTAL(109,Budgetoverzicht[TOTALE KOSTEN])","v":{"v":1335,"d":"€ 1,335.00"}},{"$f":"SUBTOTAL(109,Budgetoverzicht[VERSCHIL])","v":{"v":15,"d":"€ 15.00"}}]

{"sheet":"Gastenlijst","index":1,"n_rows":22,"n_cols":12,"rows_kept":22}
[]
[]
[null,"Gastenlijst"]
[]
[]
[]
[null,"NAAM","ADRES","PLAATS","PROVINCIE","POSTCODE","TELEFOON","E-MAIL","AANWEZIG?","KINDEREN","VOLWASSENEN","TOTAAL"]
[null,"Familie 1","Adres 1","Plaats 1","Provincie 1","Postcode 1","Telefoon 1","E-mail 1","Nee",2,2,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":4}]
[null,"Familie 2","Adres 2","Plaats 2","Provincie 2","Postcode 2","Telefoon 2","E-mail 2","Ja",1,1,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":2}]
[null,"Familie 3","Adres 3","Plaats 3","Provincie 3","Postcode 3","Telefoon 3","E-mail 3","Ja",3,3,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":6}]
[null,"Familie 4","Adres 4","Plaats 4","Provincie 4","Postcode 4","Telefoon 4","E-mail 4",null,null,2,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":2}]
[null,"Familie 5","Adres 5","Plaats 5","Provincie 5","Postcode 5","Telefoon 5","E-mail 5","Ja",4,3,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":7}]
[null,"Familie 6","Adres 6","Plaats 6","Provincie 6","Postcode 6","Telefoon 6","E-mail 6","Ja",2,2,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":4}]
[null,"Familie 7","Adres 7","Plaats 7","Provincie 7","Postcode 7","Telefoon 7","E-mail 7","Ja",1,4,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":5}]
[null,"Familie 8","Adres 8","Plaats 8","Provincie 8","Postcode 8","Telefoon 8","E-mail 8","Nee",5,3,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":8}]
[null,"Familie 9","Adres 9","Plaats 9","Provincie 9","Postcode 9","Telefoon 9","E-mail 9","Ja",3,2,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":5}]
[null,"Familie 10","Adres 10","Plaats 10","Provincie 10","Postcode 10","Telefoon 10","E-mail 10","Ja",null,4,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":4}]
[null,"Familie 11","Adres 11","Plaats 11","Provincie 11","Postcode 11","Telefoon 11","E-mail 11","Ja",3,5,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":8}]
[null,"Familie 12","Adres 12","Plaats 12","Provincie 12","Postcode 12","Telefoon 12","E-mail 12","Nee",2,3,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":5}]
[null,"Familie 13","Adres 13","Plaats 13","Provincie 13","Postcode 13","Telefoon 13","E-mail 13","Ja",3,2,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":5}]
[null,"Familie 14","Adres 14","Plaats 14","Provincie 14","Postcode 14","Telefoon 14","E-mail 14","Nee",null,1,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":1}]
[null,"Familie 15","Adres 15","Plaats 15","Provincie 15","Postcode 15","Telefoon 15","E-mail 15",null,null,2,{"$f":"SUM(TafelMetGasten[[#This Row],[KINDEREN]:[VOLWASSENEN]])","v":2}]

{"sheet":"Eten en drinken","index":2,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[]
[null,"Eten en drinken"]
[]
[null,"Voer kosten en geschat aantal porties in om automatisch totaalaantal en kosten per portie te berekenen op basis van het totale aantal gasten"]
[null,"EET- OF DRINKARTIKEL","TOTALE KOSTEN","PORTIE PER KIND","PORTIE PER VOLWASSENE","TOTAAL AANTAL PORTIES","KOSTEN PER PORTIE","KOSTEN PER KIND","KOSTEN PER VOLWASSENE","OPMERKINGEN"]
[null,"Frisdrank",{"v":15,"d":"€ 15.00"},0.5,2,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":62},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.24193548387096775,"d":"€ 0.24"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.12096774193548387,"d":"€ 0.12"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.4838709677419355,"d":"€ 0.48"}},"Tweeliterflessen"]
[null,"Sappakken",{"v":15,"d":"€ 15.00"},2,0,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":40},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.375,"d":"€ 0.38"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.75,"d":"€ 0.75"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0,"d":"€ 0.00"}},"Appel en witte druif"]
[null,"Wijn",{"v":50,"d":"€ 50.00"},0,2,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":52},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.9615384615384616,"d":"€ 0.96"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0,"d":"€ 0.00"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":1.9230769230769231,"d":"€ 1.92"}}]
[null,"Taart",{"v":75,"d":"€ 75.00"},1,1,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":46},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":1.6304347826086956,"d":"€ 1.63"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":1.6304347826086956,"d":"€ 1.63"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":1.6304347826086956,"d":"€ 1.63"}},"Bestellen bij lokale bakker"]
[null,"IJs",{"v":20,"d":"€ 20.00"},1,1.5,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":59},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.3389830508474576,"d":"€ 0.34"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.3389830508474576,"d":"€ 0.34"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.5084745762711864,"d":"€ 0.51"}}]
[null,"Dessertschaaltjes",{"v":15,"d":"€ 15.00"},1,0,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":20},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.75,"d":"€ 0.75"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.75,"d":"€ 0.75"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0,"d":"€ 0.00"}},"Kant-en-klare bakjes kopen: vanille en chocolade"]
[null,"Gevulde champignons",{"v":32,"d":"€ 32.00"},1,2,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":72},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.4444444444444444,"d":"€ 0.44"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.4444444444444444,"d":"€ 0.44"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.8888888888888888,"d":"€ 0.89"}},"Champignons gevuld met roomkaas en worst"]
[null,"Bruschetta",{"v":22,"d":"€ 22.00"},0,3,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":78},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.28205128205128205,"d":"€ 0.28"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0,"d":"€ 0.00"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.8461538461538461,"d":"€ 0.85"}},"Tomaat en basilicum "]
[null,"Gerookte zalm",{"v":50,"d":"€ 50.00"},1,2,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":72},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.6944444444444444,"d":"€ 0.69"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.6944444444444444,"d":"€ 0.69"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":1.3888888888888888,"d":"€ 1.39"}}]
[null,"Minibagels",{"v":20,"d":"€ 20.00"},1,2,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":72},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.2777777777777778,"d":"€ 0.28"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.2777777777777778,"d":"€ 0.28"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.5555555555555556,"d":"€ 0.56"}},"4 zakken - gemengd"]
[null,"Roomkaas",{"v":10,"d":"€ 10.00"},1,2,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":72},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.1388888888888889,"d":"€ 0.14"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.1388888888888889,"d":"€ 0.14"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.2777777777777778,"d":"€ 0.28"}},"2 grote bakken"]
[null,"Kappertjes",{"v":12,"d":"€ 12.00"},1,2,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":72},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.16666666666666666,"d":"€ 0.17"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.16666666666666666,"d":"€ 0.17"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.3333333333333333,"d":"€ 0.33"}},"3 potten"]
[null,"Kipvleugeltjes",{"v":45,"d":"€ 45.00"},2,4,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":144},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.3125,"d":"€ 0.31"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.625,"d":"€ 0.63"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":1.25,"d":"€ 1.25"}},"Kopen bij lokale poelier"]
[null,"Hummus",{"v":10,"d":"€ 10.00"},4,6,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":236},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.0423728813559322,"d":"€ 0.04"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.1694915254237288,"d":"€ 0.17"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.2542372881355932,"d":"€ 0.25"}},"Avond van tevoren maken"]
[null,"Parmezaanse pitachips",{"v":14,"d":"€ 14.00"},4,6,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":236},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.059322033898305086,"d":"€ 0.06"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.23728813559322035,"d":"€ 0.24"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.3559322033898305,"d":"€ 0.36"}},"Avond van tevoren maken"]
[null,"Gemengde groenten",{"v":30,"d":"€ 30.00"},4,10,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":340},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.08823529411764706,"d":"€ 0.09"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.35294117647058826,"d":"€ 0.35"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.8823529411764707,"d":"€ 0.88"}},"Wortelstengels, selderij, broccoli, bloemkool, rode en groene paprika"]
[null,"Kaasballetje",{"v":15,"d":"€ 15.00"},5,10,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":360},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.041666666666666664,"d":"€ 0.04"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.20833333333333331,"d":"€ 0.21"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.41666666666666663,"d":"€ 0.42"}},"Gemengd: roomkaas, scherpe kaas met noten"]
[null,"Crackers",{"v":25,"d":"€ 25.00"},5,10,{"$f":"(TafelMetVoeding[[#This Row],[PORTIE PER KIND]]*AantalKinderen)+(TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]]*AantalVolwassenen)","v":360},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[TOTALE KOSTEN]]/TafelMetVoeding[[#This Row],[TOTAAL AANTAL PORTIES]],\"\")","v":{"v":0.06944444444444445,"d":"€ 0.07"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER KIND]],\"\")","v":{"v":0.3472222222222222,"d":"€ 0.35"}},{"$f":"IFERROR(TafelMetVoeding[[#This Row],[KOSTEN PER PORTIE]]*TafelMetVoeding[[#This Row],[PORTIE PER VOLWASSENE]],\"\")","v":{"v":0.6944444444444444,"d":"€ 0.69"}},"Gemengd"]
[null,"Totaal",{"$f":"SUBTOTAL(109,TafelMetVoeding[TOTALE KOSTEN])","v":{"v":475,"d":"€ 475.00"}},{"$f":"SUBTOTAL(109,TafelMetVoeding[PORTIE PER KIND])","v":34.5},{"$f":"SUBTOTAL(109,TafelMetVoeding[PORTIE PER VOLWASSENE])","v":65.5},{"$f":"SUBTOTAL(109,TafelMetVoeding[TOTAAL AANTAL PORTIES])","v":2393},{"$f":"SUBTOTAL(109,TafelMetVoeding[KOSTEN PER PORTIE])","v":{"v":6.915706603622084,"d":"€ 6.92"}},{"$f":"SUBTOTAL(109,TafelMetVoeding[KOSTEN PER KIND])","v":{"v":7.252884190656953,"d":"€ 7.25"}},{"$f":"SUBTOTAL(109,TafelMetVoeding[KOSTEN PER VOLWASSENE])","v":{"v":12.690089084110037,"d":"€ 12.69"}}]

{"sheet":"Andere belangrijke punten","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[14,1,14,4],[22,1,22,4]]}
[]
[]
[null,"Andere belangrijke punten"]
[]
[]
[null,"Apparatuur en benodigdheden","Kosten","Gekocht","Opmerkingen"]
[null,"Huur van ruimte/zaal",{"v":250,"d":"€ 250.00"},"Ja"]
[null,"Linnengoed",{"v":30,"d":"€ 30.00"},"Ja","Huur"]
[null,"Tafels en stoelen",{"v":0,"d":"€ 0.00"},null,"Inbegrepen in zaalhuur"]
[null,"Servetten voor dranken",{"v":25,"d":"€ 25.00"}]
[null,"Dinerservetten",{"v":20,"d":"€ 20.00"},null,"Huur"]
[null,"Tafelbediening",{"v":50,"d":"€ 50.00"},null,"Huur"]
[null,"Glas",{"v":25,"d":"€ 25.00"},null,"Huur"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel1Budget[Kosten])","v":{"v":400,"d":"€ 400.00"}}]
[]
[]
[null,"Decoraties","Kosten","Gekocht","Opmerkingen"]
[null,"Ballonnen",{"v":25,"d":"€ 25.00"}]
[null,"Heliumtank",{"v":50,"d":"€ 50.00"},null,"Huur"]
[null,"Tafelversiering",{"v":100,"d":"€ 100.00"},"Ja","10 totaal"]
[null,"Glazen vazen",{"v":0,"d":"€ 0.00"},null,"Lenen van Pascaline"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel2Budget[Kosten])","v":{"v":175,"d":"€ 175.00"}}]
[]
[]
[null,"Overig","Kosten","Gekocht","Opmerkingen"]
[null,"Uitnodigingen",{"v":50,"d":"€ 50.00"},"Ja"]
[null,"Portokosten",{"v":60,"d":"€ 60.00"},"Ja"]
[null,"Fotograaf",{"v":125,"d":"€ 125.00"},null,"2 uur (14:00 - 16:00)"]
[null,"Feestartikelen",{"v":50,"d":"€ 50.00"}]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel3Budget[Kosten])","v":{"v":285,"d":"€ 285.00"}}]

{"sheet":"Raster voor tafelindeling","index":4,"n_rows":43,"n_cols":34,"rows_kept":43,"merged":[[35,0,35,17],[35,19,35,33]]}
["Tafelindeling"]
{"$rows_empty":33}
[{"$nulls":33},"*1 vierkant = ongeveer 30 vierkante centimeter"]
["Opmerkingen",{"$nulls":18},{"$f":"\" Totaal aantal bevestigde gasten: \"&BevestigdeGasten","v":" Totaal aantal bevestigde gasten: 46"}]
[{"$nulls":19},"U kunt de volgende tafelindelingen gebruiken:"]
[{"$nulls":20},{"$f":"ROUNDUP(BevestigdeGasten/6,0)&\" ronde tafels van 135 cm (plaats voor 6)\"","v":"8 ronde tafels van 135 cm (plaats voor 6)"}]
[{"$nulls":20},{"$f":"ROUNDUP(BevestigdeGasten/8,0) &\" ronde tafels van 150 cm (plaats voor 8)\"","v":"6 ronde tafels van 150 cm (plaats voor 8)"}]
[{"$nulls":20},{"$f":"ROUNDUP(BevestigdeGasten/10,0)&\" ronde tafels van 180 cm (plaats voor 10)\"","v":"5 ronde tafels van 180 cm (plaats voor 10)"}]
[{"$nulls":20},{"$f":"ROUNDUP(BevestigdeGasten/6,0)& \" vierkante tafels van 70x180 cm (plaats voor 6)\"","v":"8 vierkante tafels van 70x180 cm (plaats voor 6)"}]
[{"$nulls":20},{"$f":"ROUNDUP(BevestigdeGasten/8,0)&\" vierkante tafels van 70x240 cm (plaats voor 8)\"","v":"6 vierkante tafels van 70x240 cm (plaats voor 8)"}]
[{"$nulls":19},"(Gewenste ruimte tussen tafels: 105 cm)"]