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

{"sheet":"Budgetoverzicht","index":0,"n_rows":28,"n_cols":7,"rows_kept":28}
[{"$nulls":6}," "]
[]
[null,"TOTAAL TROUWBUDGET",{"v":20000,"d":"€ 20,000"}]
[]
[null,"ONKOSTEN","Toewijzing \n%","Toegewezen budget","Geschatte \nKosten","Werkelijke \nKosten"]
[null,"Receptie",{"v":0.5,"d":"50%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C6","v":{"v":10000,"d":"€ 10,000"}},{"$f":"Tabel_Receptie[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_Receptie[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Kleding",{"v":0.1,"d":"10%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C7","v":{"v":2000,"d":"€ 2,000"}},{"$f":"Tabel_Kleding[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_Kleding[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Bloemen en versieringen",{"v":0.1,"d":"10%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C8","v":{"v":2000,"d":"€ 2,000"}},{"$f":"Tabel_BloemenEnVersiering[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_BloemenEnVersiering[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Muziek",{"v":0.1,"d":"10%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C9","v":{"v":2000,"d":"€ 2,000"}},{"$f":"Tabel_Muziek[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_Muziek[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Foto- en video-opnamen",{"v":0.1,"d":"10%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C10","v":{"v":2000,"d":"€ 2,000"}},{"$f":"Tabel_FotografieEnVideoOpnamen[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_FotografieEnVideoOpnamen[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Aandenkens en cadeaus",{"v":0.03,"d":"3%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C11","v":{"v":600,"d":"€ 600"}},{"$f":"Tabel_AandenkensEnCadeaus[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_AandenkensEnCadeaus[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Ceremonie",{"v":0.02,"d":"2%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C12","v":{"v":400,"d":"€ 400"}},{"$f":"Tabel_Ceremonie[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_Ceremonie[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Briefpapier",{"v":0.02,"d":"2%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C13","v":{"v":400,"d":"€ 400"}},{"$f":"Tabel_Briefpapier[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_Briefpapier[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Trouwringen",{"v":0.02,"d":"2%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C14","v":{"v":400,"d":"€ 400"}},{"$f":"Tabel_Trouwringen[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_Trouwringen[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Vervoer",{"v":0.01,"d":"1%"},{"$f":"Totaal_trouwbudget*Budgetoverzicht!$C15","v":{"v":200,"d":"€ 200"}},{"$f":"Tabel_Vervoer[[#Totals],[Geschatte kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"Tabel_Vervoer[[#Totals],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Totaal",{"$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,"BIJDRAGEN"]
[null,"Schenker","Contributie"]
[null,"Spaarrekening",{"v":10000,"d":"€ 10,000"}]
[null,"Ouders van partner 1",{"v":4000,"d":"€ 4,000"}]
[null,"Grootouders van partner 1",{"v":2000,"d":"€ 2,000"}]
[null,"Ouders van partner 2",{"v":4000,"d":"€ 4,000"}]
[null,"Grootouders van partner 2",{"v":4000,"d":"€ 4,000"}]
[null,"Overige bijdragen",{"v":2000,"d":"€ 2,000"}]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_Bijdragen[Contributie])","v":{"v":26000,"d":"€ 26,000"}}]
[]
[null,{"$f":"IF(Tabel_Bijdragen[[#Totals],[Contributie]]<Totaal_trouwbudget,\"Te compenseren verschil\",\"Beschikbare extra fondsen\")","v":"Beschikbare extra fondsen"},{"$f":"IF(Tabel_Bijdragen[[#Totals],[Contributie]]<Totaal_trouwbudget,Totaal_trouwbudget-Tabel_Bijdragen[[#Totals],[Contributie]],Tabel_Bijdragen[[#Totals],[Contributie]]-Totaal_trouwbudget)","v":{"v":6000,"d":"€ 6,000"}}]

{"sheet":"Budgetdetails","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"RECEPTIE","Geschatte kosten","Werkelijke kosten"]
[null,"Locaties en huur"]
[null,"Eten en dienstverlening"]
[null,"Dranken"]
[null,"Taart"]
[null,"Diverse kosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_Receptie[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_Receptie[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"KLEDING","Geschatte kosten","Werkelijke kosten"]
[null,"Smoking, pak en/of jurken"]
[null,"Vermaken"]
[null,"Hoofddeksel en sluier"]
[null,"Accessoires"]
[null,"Haar en make-up"]
[null,"Diverse kosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_Kleding[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_Kleding[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"BLOEMEN EN VERSIERINGEN","Geschatte kosten","Werkelijke kosten"]
[null,"Bloemstukken voor ceremonie"]
[null,"Bloemblaadjes en mand bloemenmeisje"]
[null,"Ringkussen"]
[null,"Boeketten"]
[null,"Boutonnières"]
[null,"Corsages"]
[null,"Versieringen receptie"]
[null,"Verlichting"]
[null,"Diverse kosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_BloemenEnVersiering[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_BloemenEnVersiering[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"MUZIEK","Geschatte kosten","Werkelijke kosten"]
[null,"Muzikanten ceremonie"]
[null,"Muzikanten borrel"]
[null,"Band, dj of animatie receptie"]
[null,"Geluidssysteem of huur dansvloer"]
[null,"Diverse kosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_Muziek[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_Muziek[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"FOTO- EN VIDEO-OPNAMEN","Geschatte kosten","Werkelijke kosten"]
[null,"Fotografie"]
[null,"Video-opnamen"]
[null,"Aanvullende afdrukken en fotoalbums"]
[null,"Diverse kosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_FotografieEnVideoOpnamen[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_FotografieEnVideoOpnamen[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"AANDENKENS EN CADEAUS","Geschatte kosten","Werkelijke kosten"]
[null,"Welkomstcadeaus"]
[null,"Feestcadeaus"]
[null,"Diverse kosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_AandenkensEnCadeaus[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_AandenkensEnCadeaus[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"CEREMONIE","Geschatte kosten","Werkelijke kosten"]
[null,"Locatiekosten"]
[null,"Kosten trouwambtenaar of donatie aan kerk"]
[null,"Diverse kosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_Ceremonie[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_Ceremonie[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"BRIEFPAPIER","Geschatte kosten","Werkelijke kosten"]
[null,"Uitnodigingskaarten"]
[null,"Uitnodigingen en aanmeldingen"]
[null,"Programma's"]
[null,"Plaatskaarten"]
[null,"Menukaarten"]
[null,"Bedankbriefjes"]
[null,"Portokosten"]
[null,"Diverse kosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_Briefpapier[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_Briefpapier[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"TROUWRINGEN","Geschatte kosten","Werkelijke kosten"]
[null,"Trouwringen"]
[null,"Ring-toebehoren"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_Trouwringen[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_Trouwringen[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"VERVOER","Geschatte kosten","Werkelijke kosten"]
[null,"Autohuur"]
[null,"Autohuur gasten"]
[null,"Vervoer voor gasten die van ver komen"]
[null,"Parkeerservice"]
[null,"Diverse kosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,Tabel_Vervoer[Geschatte kosten])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Tabel_Vervoer[Werkelijke kosten])","v":{"v":0,"d":"€ 0.00"}}]