{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Budget pour un mariage","Détails du budget"],"not_rendered":{"charts":1,"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Budget pour un mariage","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,1,1,5]]}
[{"$nulls":6}," "]
[null,"LISHA + DANIEL\nSE MARIER"]
[{"$nulls":7}," "]
[]
[null,"CATÉGORIE","COÛT ESTIMÉ","COÛT RÉEL","ÉCART","% DU BUDGET",{"$nulls":3},"Non trié","Coût estimé","Coût réel","Coût estimé – valeur de classement","Rang","N°","Trié"]
[null,{"$f":"P6","v":"Réception"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"14,500 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"12,800 $"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":{"v":1700,"d":"1,700 $"}},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"Réception",{"$f":"TBL_Reception[[#Totals],[ESTIMÉ]]","v":14500},{"$f":"TBL_Reception[[#Totals],[RÉELS]]","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":"Réception"}]
[null,{"$f":"P7","v":"Tenue"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"4,000 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"2,900 $"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":{"v":1100,"d":"1,100 $"}},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"Tenue",{"$f":"TBL_Attire[[#Totals],[ESTIMÉ]]","v":4000},{"$f":"TBL_Attire[[#Totals],[RÉELS]]","v":2900},{"$f":"K7-O7/100","v":3999.98},2,2,"Tenue"]
[null,"Fleurs et décorations",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"3,000 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"Fleurs et décorations",{"$f":"TBL_FlowersAndDecor[[#Totals],[ESTIMÉ]]","v":3000},{"$f":"TBL_FlowersAndDecor[[#Totals],[RÉELS]]","v":0},2999.97,3,3,"Fleurs et décorations"]
[null,"Photos et vidéo",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"2,500 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.08403361344537816,"d":"8.4%"}},{"$nulls":3},"Musique",{"$f":"TBL_Music[[#Totals],[ESTIMÉ]]","v":1800},{"$f":"TBL_Music[[#Totals],[RÉELS]]","v":0},1799.96,5,4,"Photos et vidéo"]
[null,"Musique",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"1,800 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"Photos et vidéo",{"$f":"TBL_PhotographsAndVideo[[#Totals],[ESTIMÉ]]","v":2500},{"$f":"TBL_PhotographsAndVideo[[#Totals],[RÉELS]]","v":0},2499.95,4,5,"Musique"]
[null,"Faveurs et dons",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"1,100 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Faveurs et dons",{"$f":"TBL_FavorsAndGifts[[#Totals],[ESTIMÉ]]","v":1100},{"$f":"TBL_FavorsAndGifts[[#Totals],[RÉELS]]","v":0},1099.94,6,6,"Faveurs et dons"]
[null,{"$f":"P12","v":"Alliances"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"1,100 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Cérémonie",{"$f":"TBL_Ceremony[[#Totals],[ESTIMÉ]]","v":800},{"$f":"TBL_Ceremony[[#Totals],[RÉELS]]","v":0},799.93,8,7,"Alliances"]
[null,"Cérémonie",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"800 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"Papeterie",{"$f":"TBL_Stationery[[#Totals],[ESTIMÉ]]","v":500},{"$f":"TBL_Stationery[[#Totals],[RÉELS]]","v":0},499.92,9,8,"Cérémonie"]
[null,"Papeterie",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"500 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"Alliances",{"$f":"TBL_WeddingRings[[#Totals],[ESTIMÉ]]","v":1100},{"$f":"TBL_WeddingRings[[#Totals],[RÉELS]]","v":0},1099.91,7,9,"Papeterie"]
[null,"Transport",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"450 $"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATÉGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COÛT ESTIMÉ]]=\"\",TBL_Summary[[#This Row],[COÛT RÉEL]]=\"\"),\"\",TBL_Summary[[#This Row],[COÛT ESTIMÉ]]-TBL_Summary[[#This Row],[COÛT RÉEL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COÛT ESTIMÉ]]/SUM(TBL_Summary[COÛT ESTIMÉ])","v":{"v":0.015126050420168067,"d":"1.5%"}},{"$nulls":3},"Transport",{"$f":"TBL_Transportation[[#Totals],[ESTIMÉ]]","v":450},{"$f":"TBL_Transportation[[#Totals],[RÉELS]]","v":0},449.9,10,10,"Transport"]
[null,"Total",{"$f":"SUBTOTAL(109,TBL_Summary[COÛT ESTIMÉ])","v":{"v":29750,"d":"29,750 $"}},{"$f":"SUBTOTAL(109,TBL_Summary[COÛT RÉEL])","v":{"v":15700,"d":"15,700 $"}},{"$f":"TBL_Summary[[#Totals],[COÛT ESTIMÉ]]-TBL_Summary[[#Totals],[COÛT RÉEL]]","v":{"v":14050,"d":"14,050 $"}},{"$f":"SUBTOTAL(109,TBL_Summary[% DU BUDGET])","v":{"v":1,"d":"100%"}}]

{"sheet":"Détails du budget","index":1,"n_rows":91,"n_cols":6,"rows_kept":91}
[{"$nulls":5}," "]
[null,"DÉTAILS DU BUDGET"]
[]
[null,"RÉCEPTION","ESTIMÉ","RÉELS","ÉCART"]
[null,"Lieu et location",{"v":8000,"d":"8,000.00 $"},{"v":7800,"d":"7,800.00 $"},{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMÉ]]=\"\",TBL_Reception[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMÉ]]-TBL_Reception[[#This Row],[RÉELS]])","v":{"v":200,"d":"200.00 $"}}]
[null,"Nourriture et service",{"v":4000,"d":"4,000.00 $"},{"v":4200,"d":"4,200.00 $"},{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMÉ]]=\"\",TBL_Reception[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMÉ]]-TBL_Reception[[#This Row],[RÉELS]])","v":{"v":-200,"d":"(200.00 $)"}}]
[null,"Boissons",{"v":1000,"d":"1,000.00 $"},{"v":800,"d":"800.00 $"},{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMÉ]]=\"\",TBL_Reception[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMÉ]]-TBL_Reception[[#This Row],[RÉELS]])","v":{"v":200,"d":"200.00 $"}}]
[null,"Gâteau",{"v":1000,"d":"1,000.00 $"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMÉ]]=\"\",TBL_Reception[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMÉ]]-TBL_Reception[[#This Row],[RÉELS]])","v":""}]
[null,"Divers",{"v":500,"d":"500.00 $"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMÉ]]=\"\",TBL_Reception[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMÉ]]-TBL_Reception[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LA RÉCEPTION",{"$f":"SUBTOTAL(109,TBL_Reception[ESTIMÉ])","v":{"v":14500,"d":"14,500.00 $"}},{"$f":"SUBTOTAL(109,TBL_Reception[RÉELS])","v":{"v":12800,"d":"12,800.00 $"}},{"$f":"TBL_Reception[[#Totals],[ESTIMÉ]]-TBL_Reception[[#Totals],[RÉELS]]","v":{"v":1700,"d":"1,700.00 $"}}]
[]
[]
[null,"TENUE","ESTIMÉ","RÉELS","ÉCART"]
[null,"Smoking, costume et/ou robes",{"v":3000,"d":"3,000.00 $"},{"v":2900,"d":"2,900.00 $"},{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMÉ]]=\"\",TBL_Attire[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMÉ]]-TBL_Attire[[#This Row],[RÉELS]])","v":{"v":100,"d":"100.00 $"}}]
[null,"Retouches",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMÉ]]=\"\",TBL_Attire[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMÉ]]-TBL_Attire[[#This Row],[RÉELS]])","v":""}]
[null,"Coiffe et voile",{"v":200,"d":"200.00 $"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMÉ]]=\"\",TBL_Attire[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMÉ]]-TBL_Attire[[#This Row],[RÉELS]])","v":""}]
[null,"Accessoires",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMÉ]]=\"\",TBL_Attire[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMÉ]]-TBL_Attire[[#This Row],[RÉELS]])","v":""}]
[null,"Coiffure et maquillage",{"v":500,"d":"500.00 $"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMÉ]]=\"\",TBL_Attire[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMÉ]]-TBL_Attire[[#This Row],[RÉELS]])","v":""}]
[null,"Divers",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMÉ]]=\"\",TBL_Attire[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMÉ]]-TBL_Attire[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LES TENUES",{"$f":"SUBTOTAL(109,TBL_Attire[ESTIMÉ])","v":{"v":4000,"d":"4,000.00 $"}},{"$f":"SUBTOTAL(109,TBL_Attire[RÉELS])","v":{"v":2900,"d":"2,900.00 $"}},{"$f":"TBL_Attire[[#Totals],[ESTIMÉ]]-TBL_Attire[[#Totals],[RÉELS]]","v":{"v":1100,"d":"1,100.00 $"}}]
[]
[]
[null,"FLEURS ET DÉCORATIONS","ESTIMÉ","RÉELS","ÉCART"]
[null,"Compositions florales pour la cérémonie",{"v":1000,"d":"1,000.00 $"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]=\"\",TBL_FlowersAndDecor[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]-TBL_FlowersAndDecor[[#This Row],[RÉELS]])","v":""}]
[null,"Bouquets et panier de fleurs",{"v":500,"d":"500.00 $"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]=\"\",TBL_FlowersAndDecor[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]-TBL_FlowersAndDecor[[#This Row],[RÉELS]])","v":""}]
[null,"Coussin pour les alliances",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]=\"\",TBL_FlowersAndDecor[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]-TBL_FlowersAndDecor[[#This Row],[RÉELS]])","v":""}]
[null,"Bouquets",{"v":500,"d":"500.00 $"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]=\"\",TBL_FlowersAndDecor[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]-TBL_FlowersAndDecor[[#This Row],[RÉELS]])","v":""}]
[null,"Fleurs à porter à la boutonnière",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]=\"\",TBL_FlowersAndDecor[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]-TBL_FlowersAndDecor[[#This Row],[RÉELS]])","v":""}]
[null,"Petits bouquets à épingler au corsage",{"v":200,"d":"200.00 $"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]=\"\",TBL_FlowersAndDecor[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]-TBL_FlowersAndDecor[[#This Row],[RÉELS]])","v":""}]
[null,"Décorations de la réception",{"v":300,"d":"300.00 $"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]=\"\",TBL_FlowersAndDecor[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]-TBL_FlowersAndDecor[[#This Row],[RÉELS]])","v":""}]
[null,"Éclairage",{"v":200,"d":"200.00 $"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]=\"\",TBL_FlowersAndDecor[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]-TBL_FlowersAndDecor[[#This Row],[RÉELS]])","v":""}]
[null,"Divers",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]=\"\",TBL_FlowersAndDecor[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMÉ]]-TBL_FlowersAndDecor[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LES DÉCORATIONS ET FLEURS",{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[ESTIMÉ])","v":{"v":3000,"d":"3,000.00 $"}},{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[RÉELS])","v":{"v":0,"d":"0.00 $"}},{"$f":"TBL_FlowersAndDecor[[#Totals],[ESTIMÉ]]-TBL_FlowersAndDecor[[#Totals],[RÉELS]]","v":{"v":3000,"d":"3,000.00 $"}}]
[]
[]
[null,"MUSIQUE","ESTIMÉ","RÉELS","ÉCART"]
[null,"Musiciens pour la cérémonie",{"v":700,"d":"700.00 $"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMÉ]]=\"\",TBL_Music[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMÉ]]-TBL_Music[[#This Row],[RÉELS]])","v":""}]
[null,"Musiciens pour le cocktail",{"v":300,"d":"300.00 $"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMÉ]]=\"\",TBL_Music[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMÉ]]-TBL_Music[[#This Row],[RÉELS]])","v":""}]
[null,"Groupe, DJ pour la réception",{"v":200,"d":"200.00 $"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMÉ]]=\"\",TBL_Music[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMÉ]]-TBL_Music[[#This Row],[RÉELS]])","v":""}]
[null,"Location sonorisation ou piste de danse",{"v":400,"d":"400.00 $"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMÉ]]=\"\",TBL_Music[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMÉ]]-TBL_Music[[#This Row],[RÉELS]])","v":""}]
[null,"Divers",{"v":200,"d":"200.00 $"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMÉ]]=\"\",TBL_Music[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMÉ]]-TBL_Music[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LA MUSIQUE",{"$f":"SUBTOTAL(109,TBL_Music[ESTIMÉ])","v":{"v":1800,"d":"1,800.00 $"}},{"$f":"SUBTOTAL(109,TBL_Music[RÉELS])","v":{"v":0,"d":"0.00 $"}},{"$f":"TBL_Music[[#Totals],[ESTIMÉ]]-TBL_Music[[#Totals],[RÉELS]]","v":{"v":1800,"d":"1,800.00 $"}}]
[]
[]
[null,"PHOTOS ET VIDÉO","ESTIMÉ","RÉELS","ÉCART"]
[null,"Photographie",{"v":1000,"d":"1,000.00 $"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[ESTIMÉ]]=\"\",TBL_PhotographsAndVideo[[#This Row],[RÉELS]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[ESTIMÉ]]-TBL_PhotographsAndVideo[[#This Row],[RÉELS]])","v":""}]
[null,"Vidéo",{"v":800,"d":"800.00 $"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[ESTIMÉ]]=\"\",TBL_PhotographsAndVideo[[#This Row],[RÉELS]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[ESTIMÉ]]-TBL_PhotographsAndVideo[[#This Row],[RÉELS]])","v":""}]
[null,"Autres impressions et albums",{"v":500,"d":"500.00 $"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[ESTIMÉ]]=\"\",TBL_PhotographsAndVideo[[#This Row],[RÉELS]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[ESTIMÉ]]-TBL_PhotographsAndVideo[[#This Row],[RÉELS]])","v":""}]
[null,"Divers",{"v":200,"d":"200.00 $"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[ESTIMÉ]]=\"\",TBL_PhotographsAndVideo[[#This Row],[RÉELS]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[ESTIMÉ]]-TBL_PhotographsAndVideo[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LES PHOTOS ET VIDÉO",{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[ESTIMÉ])","v":{"v":2500,"d":"2,500.00 $"}},{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[RÉELS])","v":{"v":0,"d":"0.00 $"}},{"$f":"TBL_PhotographsAndVideo[[#Totals],[ESTIMÉ]]-TBL_PhotographsAndVideo[[#Totals],[RÉELS]]","v":{"v":2500,"d":"2,500.00 $"}}]
[]
[]
[null,"ARTICLES DE FÊTE ET CADEAUX","ESTIMÉ","RÉELS","ÉCART"]
[null,"Cadeaux de bienvenue",{"v":700,"d":"700.00 $"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[ESTIMÉ]]=\"\",TBL_FavorsAndGifts[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[ESTIMÉ]]-TBL_FavorsAndGifts[[#This Row],[RÉELS]])","v":""}]
[null,"Cadeaux",{"v":200,"d":"200.00 $"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[ESTIMÉ]]=\"\",TBL_FavorsAndGifts[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[ESTIMÉ]]-TBL_FavorsAndGifts[[#This Row],[RÉELS]])","v":""}]
[null,"Divers",{"v":200,"d":"200.00 $"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[ESTIMÉ]]=\"\",TBL_FavorsAndGifts[[#This Row],[RÉELS]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[ESTIMÉ]]-TBL_FavorsAndGifts[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LES ARTICLES DE FÊTE ET CADEAUX",{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[ESTIMÉ])","v":{"v":1100,"d":"1,100.00 $"}},{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[RÉELS])","v":{"v":0,"d":"0.00 $"}},{"$f":"TBL_FavorsAndGifts[[#Totals],[ESTIMÉ]]-TBL_FavorsAndGifts[[#Totals],[RÉELS]]","v":{"v":1100,"d":"1,100.00 $"}}]
[]
[]
[null,"CÉRÉMONIE","ESTIMÉ","RÉELS","ÉCART"]
[null,"Frais de location",{"v":500,"d":"500.00 $"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[ESTIMÉ]]=\"\",TBL_Ceremony[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Ceremony[[#This Row],[ESTIMÉ]]-TBL_Ceremony[[#This Row],[RÉELS]])","v":""}]
[null,"Frais de l’officiant ou don",{"v":200,"d":"200.00 $"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[ESTIMÉ]]=\"\",TBL_Ceremony[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Ceremony[[#This Row],[ESTIMÉ]]-TBL_Ceremony[[#This Row],[RÉELS]])","v":""}]
[null,"Divers",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[ESTIMÉ]]=\"\",TBL_Ceremony[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Ceremony[[#This Row],[ESTIMÉ]]-TBL_Ceremony[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LA CÉRÉMONIE",{"$f":"SUBTOTAL(109,TBL_Ceremony[ESTIMÉ])","v":{"v":800,"d":"800.00 $"}},{"$f":"SUBTOTAL(109,TBL_Ceremony[RÉELS])","v":{"v":0,"d":"0.00 $"}},{"$f":"TBL_Ceremony[[#Totals],[ESTIMÉ]]-TBL_Ceremony[[#Totals],[RÉELS]]","v":{"v":800,"d":"800.00 $"}}]
[]
[]
[null,"PAPETERIE","ESTIMÉ","RÉELS","ÉCART"]
[null,"Carte de rappel de la date",{"v":50,"d":"50.00 $"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMÉ]]=\"\",TBL_Stationery[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMÉ]]-TBL_Stationery[[#This Row],[RÉELS]])","v":""}]
[null,"Invitations et relances",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMÉ]]=\"\",TBL_Stationery[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMÉ]]-TBL_Stationery[[#This Row],[RÉELS]])","v":""}]
[null,"Programmes",{"v":50,"d":"50.00 $"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMÉ]]=\"\",TBL_Stationery[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMÉ]]-TBL_Stationery[[#This Row],[RÉELS]])","v":""}]
[null,"Plan de table et marqueurs",{"v":50,"d":"50.00 $"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMÉ]]=\"\",TBL_Stationery[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMÉ]]-TBL_Stationery[[#This Row],[RÉELS]])","v":""}]
[null,"Menus",{"v":50,"d":"50.00 $"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMÉ]]=\"\",TBL_Stationery[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMÉ]]-TBL_Stationery[[#This Row],[RÉELS]])","v":""}]
[null,"Cartes de remerciement",{"v":50,"d":"50.00 $"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMÉ]]=\"\",TBL_Stationery[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMÉ]]-TBL_Stationery[[#This Row],[RÉELS]])","v":""}]
[null,"Affranchissement",{"v":50,"d":"50.00 $"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMÉ]]=\"\",TBL_Stationery[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMÉ]]-TBL_Stationery[[#This Row],[RÉELS]])","v":""}]
[null,"Divers",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMÉ]]=\"\",TBL_Stationery[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMÉ]]-TBL_Stationery[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LA PAPETERIE",{"$f":"SUBTOTAL(109,TBL_Stationery[ESTIMÉ])","v":{"v":500,"d":"500.00 $"}},{"$f":"SUBTOTAL(109,TBL_Stationery[RÉELS])","v":{"v":0,"d":"0.00 $"}},{"$f":"TBL_Stationery[[#Totals],[ESTIMÉ]]-TBL_Stationery[[#Totals],[RÉELS]]","v":{"v":500,"d":"500.00 $"}}]
[]
[]
[null,"ALLIANCES","ESTIMÉ","RÉELS","ÉCART"]
[null,"Alliances",{"v":1000,"d":"1,000.00 $"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[ESTIMÉ]]=\"\",TBL_WeddingRings[[#This Row],[RÉELS]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[ESTIMÉ]]-TBL_WeddingRings[[#This Row],[RÉELS]])","v":""}]
[null,"Accessoires pour les alliances",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[ESTIMÉ]]=\"\",TBL_WeddingRings[[#This Row],[RÉELS]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[ESTIMÉ]]-TBL_WeddingRings[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LES ALLIANCES",{"$f":"SUBTOTAL(109,TBL_WeddingRings[ESTIMÉ])","v":{"v":1100,"d":"1,100.00 $"}},{"$f":"SUBTOTAL(109,TBL_WeddingRings[RÉELS])","v":{"v":0,"d":"0.00 $"}},{"$f":"TBL_WeddingRings[[#Totals],[ESTIMÉ]]-TBL_WeddingRings[[#Totals],[RÉELS]]","v":{"v":1100,"d":"1,100.00 $"}}]
[]
[]
[null,"TRANSPORT  ","ESTIMÉ","RÉELS","ÉCART"]
[null,"Location de voiture",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMÉ]]=\"\",TBL_Transportation[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMÉ]]-TBL_Transportation[[#This Row],[RÉELS]])","v":""}]
[null,"Locations de voiture pour invités",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMÉ]]=\"\",TBL_Transportation[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMÉ]]-TBL_Transportation[[#This Row],[RÉELS]])","v":""}]
[null,"Transport pour les personnes venant de loin",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMÉ]]=\"\",TBL_Transportation[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMÉ]]-TBL_Transportation[[#This Row],[RÉELS]])","v":""}]
[null,"Voiturier",{"v":50,"d":"50.00 $"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMÉ]]=\"\",TBL_Transportation[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMÉ]]-TBL_Transportation[[#This Row],[RÉELS]])","v":""}]
[null,"Divers",{"v":100,"d":"100.00 $"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMÉ]]=\"\",TBL_Transportation[[#This Row],[RÉELS]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMÉ]]-TBL_Transportation[[#This Row],[RÉELS]])","v":""}]
[null,"TOTAL POUR LE TRANSPORT",{"$f":"SUBTOTAL(109,TBL_Transportation[ESTIMÉ])","v":{"v":450,"d":"450.00 $"}},{"$f":"SUBTOTAL(109,TBL_Transportation[RÉELS])","v":{"v":0,"d":"0.00 $"}},{"$f":"TBL_Transportation[[#Totals],[ESTIMÉ]]-TBL_Transportation[[#Totals],[RÉELS]]","v":{"v":450,"d":"450.00 $"}}]