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

{"sheet":"Trouwbudget","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,1,1,5]]}
[]
[null,"KAYLA + JACOB\nGAAN TROUWEN"]
[]
[]
[null,"CATEGORIE","GESCHATTE KOSTEN","WERKELIJKE KOSTEN","VERSCHIL","% VAN BUDGET",{"$nulls":3},"Niet gesorteerd","Geschatte kosten","Werkelijke kosten","Geschatte kosten - rangwaarde","Rang","#","Gesorteerd"]
[null,{"$f":"P6","v":"Receptie"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"€ 14,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"€ 12,800"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":{"v":1700,"d":"€ 1,700"}},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"Receptie",{"$f":"TBL_Reception[[#Totals],[GESCHAT]]","v":14500},{"$f":"TBL_Reception[[#Totals],[WERKELIJK]]","v":12800},{"$f":"K6-O6/100","v":14499.99},{"$f":"_xlfn.RANK.AVG(M6,$M$6:$M$15)","v":1},1,{"$f":"INDEX(TBL_RankingData,MATCH(O6,$N$6:$N$15,0),1)","v":"Receptie"}]
[null,{"$f":"P7","v":"Kleding"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"€ 4,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"€ 2,900"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":{"v":1100,"d":"€ 1,100"}},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"Kleding",{"$f":"TBL_Attire[[#Totals],[GESCHAT]]","v":4000},{"$f":"TBL_Attire[[#Totals],[WERKELIJK]]","v":2900},{"$f":"K7-O7/100","v":3999.98},2,2,"Kleding"]
[null,"Bloemen en versieringen",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"€ 3,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"Bloemen en versieringen",{"$f":"TBL_FlowersAndDecor[[#Totals],[GESCHAT]]","v":3000},{"$f":"TBL_FlowersAndDecor[[#Totals],[WERKELIJK]]","v":0},2999.97,3,3,"Bloemen en versieringen"]
[null,"Foto- en video-opnamen",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"€ 2,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.08403361344537816,"d":"8.4%"}},{"$nulls":3},"Muziek",{"$f":"TBL_Music[[#Totals],[GESCHAT]]","v":1800},{"$f":"TBL_Music[[#Totals],[WERKELIJK]]","v":0},1799.96,5,4,"Foto- en video-opnamen"]
[null,"Muziek",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"€ 1,800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"Foto- en video-opnamen",{"$f":"TBL_PhotographsAndVideo[[#Totals],[GESCHAT]]","v":2500},{"$f":"TBL_PhotographsAndVideo[[#Totals],[WERKELIJK]]","v":0},2499.95,4,5,"Muziek"]
[null,"Aandenkens en cadeaus",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"€ 1,100"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Aandenkens en cadeaus",{"$f":"TBL_FavorsAndGifts[[#Totals],[GESCHAT]]","v":1100},{"$f":"TBL_FavorsAndGifts[[#Totals],[WERKELIJK]]","v":0},1099.94,6,6,"Aandenkens en cadeaus"]
[null,{"$f":"P12","v":"Trouwringen"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"€ 1,100"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Ceremonie",{"$f":"TBL_Ceremony[[#Totals],[GESCHAT]]","v":800},{"$f":"TBL_Ceremony[[#Totals],[WERKELIJK]]","v":0},799.93,8,7,"Trouwringen"]
[null,{"$f":"P13","v":"Ceremonie"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"€ 800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"Uitnodigingen",{"$f":"TBL_Stationery[[#Totals],[GESCHAT]]","v":500},{"$f":"TBL_Stationery[[#Totals],[WERKELIJK]]","v":0},499.92,9,8,"Ceremonie"]
[null,{"$f":"P14","v":"Uitnodigingen"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"€ 500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"Trouwringen",{"$f":"TBL_WeddingRings[[#Totals],[GESCHAT]]","v":1100},{"$f":"TBL_WeddingRings[[#Totals],[WERKELIJK]]","v":0},1099.91,7,9,"Uitnodigingen"]
[null,{"$f":"P15","v":"Vervoer"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"€ 450"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]-TBL_Summary[[#This Row],[WERKELIJKE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHATTE KOSTEN]]/SUM(TBL_Summary[GESCHATTE KOSTEN])","v":{"v":0.015126050420168067,"d":"1.5%"}},{"$nulls":3},"Vervoer",{"$f":"TBL_Transportation[[#Totals],[GESCHAT]]","v":450},{"$f":"TBL_Transportation[[#Totals],[WERKELIJK]]","v":0},449.9,10,10,"Vervoer"]
[null,"Totaal",{"$f":"SUBTOTAL(109,TBL_Summary[GESCHATTE KOSTEN])","v":{"v":29750,"d":"€ 29,750"}},{"$f":"SUBTOTAL(109,TBL_Summary[WERKELIJKE KOSTEN])","v":{"v":15700,"d":"€ 15,700"}},{"$f":"TBL_Summary[[#Totals],[GESCHATTE KOSTEN]]-TBL_Summary[[#Totals],[WERKELIJKE KOSTEN]]","v":{"v":14050,"d":"€ 14,050"}},{"$f":"SUBTOTAL(109,TBL_Summary[% VAN BUDGET])","v":{"v":1,"d":"100%"}}]

{"sheet":"Budgetgegevens","index":1,"n_rows":91,"n_cols":5,"rows_kept":91}
[]
[null,"BUDGETGEGEVENS"]
[]
[null,"RECEPTIE","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Locaties en huur",{"v":8000,"d":"€ 8,000.00"},{"v":7800,"d":"€ 7,800.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[GESCHAT]]=\"\",TBL_Reception[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Reception[[#This Row],[GESCHAT]]-TBL_Reception[[#This Row],[WERKELIJK]])","v":{"v":200,"d":"€ 200.00"}}]
[null,"Eten en dienstverlening",{"v":4000,"d":"€ 4,000.00"},{"v":4200,"d":"€ 4,200.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[GESCHAT]]=\"\",TBL_Reception[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Reception[[#This Row],[GESCHAT]]-TBL_Reception[[#This Row],[WERKELIJK]])","v":{"v":-200,"d":"€ -200.00"}}]
[null,"Dranken",{"v":1000,"d":"€ 1,000.00"},{"v":800,"d":"€ 800.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[GESCHAT]]=\"\",TBL_Reception[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Reception[[#This Row],[GESCHAT]]-TBL_Reception[[#This Row],[WERKELIJK]])","v":{"v":200,"d":"€ 200.00"}}]
[null,"Taart",{"v":1000,"d":"€ 1,000.00"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[GESCHAT]]=\"\",TBL_Reception[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Reception[[#This Row],[GESCHAT]]-TBL_Reception[[#This Row],[WERKELIJK]])","v":""}]
[null,"Diverse kosten",{"v":500,"d":"€ 500.00"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[GESCHAT]]=\"\",TBL_Reception[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Reception[[#This Row],[GESCHAT]]-TBL_Reception[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL RECEPTIE",{"$f":"SUBTOTAL(109,TBL_Reception[GESCHAT])","v":{"v":14500,"d":"€ 14,500.00"}},{"$f":"SUBTOTAL(109,TBL_Reception[WERKELIJK])","v":{"v":12800,"d":"€ 12,800.00"}},{"$f":"TBL_Reception[[#Totals],[GESCHAT]]-TBL_Reception[[#Totals],[WERKELIJK]]","v":{"v":1700,"d":"€ 1,700.00"}}]
[]
[]
[null,"KLEDING","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Smoking, pak en/of jurken",{"v":3000,"d":"€ 3,000.00"},{"v":2900,"d":"€ 2,900.00"},{"$f":"IF(OR(TBL_Attire[[#This Row],[GESCHAT]]=\"\",TBL_Attire[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Attire[[#This Row],[GESCHAT]]-TBL_Attire[[#This Row],[WERKELIJK]])","v":{"v":100,"d":"€ 100.00"}}]
[null,"Vermaken",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[GESCHAT]]=\"\",TBL_Attire[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Attire[[#This Row],[GESCHAT]]-TBL_Attire[[#This Row],[WERKELIJK]])","v":""}]
[null,"Hoofddeksel en sluier",{"v":200,"d":"€ 200.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[GESCHAT]]=\"\",TBL_Attire[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Attire[[#This Row],[GESCHAT]]-TBL_Attire[[#This Row],[WERKELIJK]])","v":""}]
[null,"Accessoires",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[GESCHAT]]=\"\",TBL_Attire[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Attire[[#This Row],[GESCHAT]]-TBL_Attire[[#This Row],[WERKELIJK]])","v":""}]
[null,"Haar en make-up",{"v":500,"d":"€ 500.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[GESCHAT]]=\"\",TBL_Attire[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Attire[[#This Row],[GESCHAT]]-TBL_Attire[[#This Row],[WERKELIJK]])","v":""}]
[null,"Diverse kosten",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[GESCHAT]]=\"\",TBL_Attire[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Attire[[#This Row],[GESCHAT]]-TBL_Attire[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL KLEDING",{"$f":"SUBTOTAL(109,TBL_Attire[GESCHAT])","v":{"v":4000,"d":"€ 4,000.00"}},{"$f":"SUBTOTAL(109,TBL_Attire[WERKELIJK])","v":{"v":2900,"d":"€ 2,900.00"}},{"$f":"TBL_Attire[[#Totals],[GESCHAT]]-TBL_Attire[[#Totals],[WERKELIJK]]","v":{"v":1100,"d":"€ 1,100.00"}}]
[]
[]
[null,"BLOEMEN EN VERSIERINGEN","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Bloemstukken voor ceremonie",{"v":1000,"d":"€ 1,000.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[GESCHAT]]=\"\",TBL_FlowersAndDecor[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[GESCHAT]]-TBL_FlowersAndDecor[[#This Row],[WERKELIJK]])","v":""}]
[null,"Bloemblaadjes en mand bloemenmeisje",{"v":500,"d":"€ 500.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[GESCHAT]]=\"\",TBL_FlowersAndDecor[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[GESCHAT]]-TBL_FlowersAndDecor[[#This Row],[WERKELIJK]])","v":""}]
[null,"Ringkussen",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[GESCHAT]]=\"\",TBL_FlowersAndDecor[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[GESCHAT]]-TBL_FlowersAndDecor[[#This Row],[WERKELIJK]])","v":""}]
[null,"Boeketten",{"v":500,"d":"€ 500.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[GESCHAT]]=\"\",TBL_FlowersAndDecor[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[GESCHAT]]-TBL_FlowersAndDecor[[#This Row],[WERKELIJK]])","v":""}]
[null,"Boutonnières",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[GESCHAT]]=\"\",TBL_FlowersAndDecor[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[GESCHAT]]-TBL_FlowersAndDecor[[#This Row],[WERKELIJK]])","v":""}]
[null,"Corsages",{"v":200,"d":"€ 200.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[GESCHAT]]=\"\",TBL_FlowersAndDecor[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[GESCHAT]]-TBL_FlowersAndDecor[[#This Row],[WERKELIJK]])","v":""}]
[null,"Versieringen receptie",{"v":300,"d":"€ 300.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[GESCHAT]]=\"\",TBL_FlowersAndDecor[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[GESCHAT]]-TBL_FlowersAndDecor[[#This Row],[WERKELIJK]])","v":""}]
[null,"Verlichting",{"v":200,"d":"€ 200.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[GESCHAT]]=\"\",TBL_FlowersAndDecor[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[GESCHAT]]-TBL_FlowersAndDecor[[#This Row],[WERKELIJK]])","v":""}]
[null,"Diverse kosten",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[GESCHAT]]=\"\",TBL_FlowersAndDecor[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[GESCHAT]]-TBL_FlowersAndDecor[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL BLOEMEN EN VERSIERINGEN",{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[GESCHAT])","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[WERKELIJK])","v":{"v":0,"d":"€ 0.00"}},{"$f":"TBL_FlowersAndDecor[[#Totals],[GESCHAT]]-TBL_FlowersAndDecor[[#Totals],[WERKELIJK]]","v":{"v":3000,"d":"€ 3,000.00"}}]
[]
[]
[null,"MUZIEK","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Muzikanten ceremonie",{"v":700,"d":"€ 700.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[GESCHAT]]=\"\",TBL_Music[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Music[[#This Row],[GESCHAT]]-TBL_Music[[#This Row],[WERKELIJK]])","v":""}]
[null,"Muzikanten borrel",{"v":300,"d":"€ 300.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[GESCHAT]]=\"\",TBL_Music[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Music[[#This Row],[GESCHAT]]-TBL_Music[[#This Row],[WERKELIJK]])","v":""}]
[null,"Band, dj of animatie receptie",{"v":200,"d":"€ 200.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[GESCHAT]]=\"\",TBL_Music[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Music[[#This Row],[GESCHAT]]-TBL_Music[[#This Row],[WERKELIJK]])","v":""}]
[null,"Geluidssysteem of huur dansvloer",{"v":400,"d":"€ 400.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[GESCHAT]]=\"\",TBL_Music[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Music[[#This Row],[GESCHAT]]-TBL_Music[[#This Row],[WERKELIJK]])","v":""}]
[null,"Diverse kosten",{"v":200,"d":"€ 200.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[GESCHAT]]=\"\",TBL_Music[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Music[[#This Row],[GESCHAT]]-TBL_Music[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL MUZIEK",{"$f":"SUBTOTAL(109,TBL_Music[GESCHAT])","v":{"v":1800,"d":"€ 1,800.00"}},{"$f":"SUBTOTAL(109,TBL_Music[WERKELIJK])","v":{"v":0,"d":"€ 0.00"}},{"$f":"TBL_Music[[#Totals],[GESCHAT]]-TBL_Music[[#Totals],[WERKELIJK]]","v":{"v":1800,"d":"€ 1,800.00"}}]
[]
[]
[null,"FOTOGRAFIE EN VIDEO","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Fotografie",{"v":1000,"d":"€ 1,000.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[GESCHAT]]=\"\",TBL_PhotographsAndVideo[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[GESCHAT]]-TBL_PhotographsAndVideo[[#This Row],[WERKELIJK]])","v":""}]
[null,"Video-opnamen",{"v":800,"d":"€ 800.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[GESCHAT]]=\"\",TBL_PhotographsAndVideo[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[GESCHAT]]-TBL_PhotographsAndVideo[[#This Row],[WERKELIJK]])","v":""}]
[null,"Aanvullende afdrukken en fotoalbums",{"v":500,"d":"€ 500.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[GESCHAT]]=\"\",TBL_PhotographsAndVideo[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[GESCHAT]]-TBL_PhotographsAndVideo[[#This Row],[WERKELIJK]])","v":""}]
[null,"Diverse kosten",{"v":200,"d":"€ 200.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[GESCHAT]]=\"\",TBL_PhotographsAndVideo[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[GESCHAT]]-TBL_PhotographsAndVideo[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL FOTOGRAFIE EN VIDEO",{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[GESCHAT])","v":{"v":2500,"d":"€ 2,500.00"}},{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[WERKELIJK])","v":{"v":0,"d":"€ 0.00"}},{"$f":"TBL_PhotographsAndVideo[[#Totals],[GESCHAT]]-TBL_PhotographsAndVideo[[#Totals],[WERKELIJK]]","v":{"v":2500,"d":"€ 2,500.00"}}]
[]
[]
[null,"AANDENKENS EN CADEAUS","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Welkomstcadeaus",{"v":700,"d":"€ 700.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[GESCHAT]]=\"\",TBL_FavorsAndGifts[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[GESCHAT]]-TBL_FavorsAndGifts[[#This Row],[WERKELIJK]])","v":""}]
[null,"Feestcadeaus",{"v":200,"d":"€ 200.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[GESCHAT]]=\"\",TBL_FavorsAndGifts[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[GESCHAT]]-TBL_FavorsAndGifts[[#This Row],[WERKELIJK]])","v":""}]
[null,"Diverse kosten",{"v":200,"d":"€ 200.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[GESCHAT]]=\"\",TBL_FavorsAndGifts[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[GESCHAT]]-TBL_FavorsAndGifts[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL AANDENKENS EN CADEAUS",{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[GESCHAT])","v":{"v":1100,"d":"€ 1,100.00"}},{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[WERKELIJK])","v":{"v":0,"d":"€ 0.00"}},{"$f":"TBL_FavorsAndGifts[[#Totals],[GESCHAT]]-TBL_FavorsAndGifts[[#Totals],[WERKELIJK]]","v":{"v":1100,"d":"€ 1,100.00"}}]
[]
[]
[null,"CEREMONIE","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Locatiekosten",{"v":500,"d":"€ 500.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[GESCHAT]]=\"\",TBL_Ceremony[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Ceremony[[#This Row],[GESCHAT]]-TBL_Ceremony[[#This Row],[WERKELIJK]])","v":""}]
[null,"Kosten trouwambtenaar of donatie aan kerk",{"v":200,"d":"€ 200.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[GESCHAT]]=\"\",TBL_Ceremony[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Ceremony[[#This Row],[GESCHAT]]-TBL_Ceremony[[#This Row],[WERKELIJK]])","v":""}]
[null,"Diverse kosten",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[GESCHAT]]=\"\",TBL_Ceremony[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Ceremony[[#This Row],[GESCHAT]]-TBL_Ceremony[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL CEREMONIE",{"$f":"SUBTOTAL(109,TBL_Ceremony[GESCHAT])","v":{"v":800,"d":"€ 800.00"}},{"$f":"SUBTOTAL(109,TBL_Ceremony[WERKELIJK])","v":{"v":0,"d":"€ 0.00"}},{"$f":"TBL_Ceremony[[#Totals],[GESCHAT]]-TBL_Ceremony[[#Totals],[WERKELIJK]]","v":{"v":800,"d":"€ 800.00"}}]
[]
[]
[null,"KAARTEN E.D.","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Uitnodigingskaarten",{"v":50,"d":"€ 50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[GESCHAT]]=\"\",TBL_Stationery[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Stationery[[#This Row],[GESCHAT]]-TBL_Stationery[[#This Row],[WERKELIJK]])","v":""}]
[null,"Uitnodigingen en aanmeldingen",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[GESCHAT]]=\"\",TBL_Stationery[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Stationery[[#This Row],[GESCHAT]]-TBL_Stationery[[#This Row],[WERKELIJK]])","v":""}]
[null,"Programma's",{"v":50,"d":"€ 50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[GESCHAT]]=\"\",TBL_Stationery[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Stationery[[#This Row],[GESCHAT]]-TBL_Stationery[[#This Row],[WERKELIJK]])","v":""}]
[null,"Plaatskaarten",{"v":50,"d":"€ 50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[GESCHAT]]=\"\",TBL_Stationery[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Stationery[[#This Row],[GESCHAT]]-TBL_Stationery[[#This Row],[WERKELIJK]])","v":""}]
[null,"Menukaarten",{"v":50,"d":"€ 50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[GESCHAT]]=\"\",TBL_Stationery[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Stationery[[#This Row],[GESCHAT]]-TBL_Stationery[[#This Row],[WERKELIJK]])","v":""}]
[null,"Bedankbriefjes",{"v":50,"d":"€ 50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[GESCHAT]]=\"\",TBL_Stationery[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Stationery[[#This Row],[GESCHAT]]-TBL_Stationery[[#This Row],[WERKELIJK]])","v":""}]
[null,"Portokosten",{"v":50,"d":"€ 50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[GESCHAT]]=\"\",TBL_Stationery[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Stationery[[#This Row],[GESCHAT]]-TBL_Stationery[[#This Row],[WERKELIJK]])","v":""}]
[null,"Diverse kosten",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[GESCHAT]]=\"\",TBL_Stationery[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Stationery[[#This Row],[GESCHAT]]-TBL_Stationery[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL KAARTEN E.D.",{"$f":"SUBTOTAL(109,TBL_Stationery[GESCHAT])","v":{"v":500,"d":"€ 500.00"}},{"$f":"SUBTOTAL(109,TBL_Stationery[WERKELIJK])","v":{"v":0,"d":"€ 0.00"}},{"$f":"TBL_Stationery[[#Totals],[GESCHAT]]-TBL_Stationery[[#Totals],[WERKELIJK]]","v":{"v":500,"d":"€ 500.00"}}]
[]
[]
[null,"TROUWRINGEN","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Trouwringen",{"v":1000,"d":"€ 1,000.00"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[GESCHAT]]=\"\",TBL_WeddingRings[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[GESCHAT]]-TBL_WeddingRings[[#This Row],[WERKELIJK]])","v":""}]
[null,"Ring-toebehoren",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[GESCHAT]]=\"\",TBL_WeddingRings[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[GESCHAT]]-TBL_WeddingRings[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL TROUWRINGEN",{"$f":"SUBTOTAL(109,TBL_WeddingRings[GESCHAT])","v":{"v":1100,"d":"€ 1,100.00"}},{"$f":"SUBTOTAL(109,TBL_WeddingRings[WERKELIJK])","v":{"v":0,"d":"€ 0.00"}},{"$f":"TBL_WeddingRings[[#Totals],[GESCHAT]]-TBL_WeddingRings[[#Totals],[WERKELIJK]]","v":{"v":1100,"d":"€ 1,100.00"}}]
[]
[]
[null,"VERVOER  ","GESCHAT","WERKELIJK","VERSCHIL"]
[null,"Autohuur",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[GESCHAT]]=\"\",TBL_Transportation[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Transportation[[#This Row],[GESCHAT]]-TBL_Transportation[[#This Row],[WERKELIJK]])","v":""}]
[null,"Autohuur gasten",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[GESCHAT]]=\"\",TBL_Transportation[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Transportation[[#This Row],[GESCHAT]]-TBL_Transportation[[#This Row],[WERKELIJK]])","v":""}]
[null,"Vervoer voor gasten die van ver komen",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[GESCHAT]]=\"\",TBL_Transportation[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Transportation[[#This Row],[GESCHAT]]-TBL_Transportation[[#This Row],[WERKELIJK]])","v":""}]
[null,"Parkeerservice",{"v":50,"d":"€ 50.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[GESCHAT]]=\"\",TBL_Transportation[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Transportation[[#This Row],[GESCHAT]]-TBL_Transportation[[#This Row],[WERKELIJK]])","v":""}]
[null,"Diverse kosten",{"v":100,"d":"€ 100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[GESCHAT]]=\"\",TBL_Transportation[[#This Row],[WERKELIJK]]=\"\"),\"\",TBL_Transportation[[#This Row],[GESCHAT]]-TBL_Transportation[[#This Row],[WERKELIJK]])","v":""}]
[null,"TOTAAL VERVOER",{"$f":"SUBTOTAL(109,TBL_Transportation[GESCHAT])","v":{"v":450,"d":"€ 450.00"}},{"$f":"SUBTOTAL(109,TBL_Transportation[WERKELIJK])","v":{"v":0,"d":"€ 0.00"}},{"$f":"TBL_Transportation[[#Totals],[GESCHAT]]-TBL_Transportation[[#Totals],[WERKELIJK]]","v":{"v":450,"d":"€ 450.00"}}]