{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Récapitulatif du budget","Détails du budget"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Récapitulatif du budget","index":0,"n_rows":28,"n_cols":7,"rows_kept":28}
[{"$nulls":6}," "]
[]
[null,"BUDGET TOTAL DU MARIAGE",{"v":20000,"d":"20,000 €"}]
[]
[null,"DÉPENSES","Répartition \n%","Budget alloué","Estimation \ndes coûts","Réalité \ndes coûts"]
[null,"Réception",{"v":0.5,"d":"50%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C6","v":{"v":10000,"d":"10,000 €"}},{"$f":"Table_Reception[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Reception[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Tenue",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C7","v":{"v":2000,"d":"2,000 €"}},{"$f":"Table_Attire[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Attire[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Fleurs et décorations",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C8","v":{"v":2000,"d":"2,000 €"}},{"$f":"Table_FlowersAndDecorations[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_FlowersAndDecorations[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Musique",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C9","v":{"v":2000,"d":"2,000 €"}},{"$f":"Table_Music[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Music[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Photo et vidéo",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C10","v":{"v":2000,"d":"2,000 €"}},{"$f":"Table_PhotographsAndVideo[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_PhotographsAndVideo[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Faveurs et dons",{"v":0.03,"d":"3%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C11","v":{"v":600,"d":"600 €"}},{"$f":"Table_FavorsAndGifts[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_FavorsAndGifts[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Cérémonie",{"v":0.02,"d":"2%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C12","v":{"v":400,"d":"400 €"}},{"$f":"Table_Ceremony[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Ceremony[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Papeterie",{"v":0.02,"d":"2%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C13","v":{"v":400,"d":"400 €"}},{"$f":"Table_Stationery[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Stationery[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Alliances",{"v":0.02,"d":"2%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C14","v":{"v":400,"d":"400 €"}},{"$f":"Table_WeddingRings[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_WeddingRings[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Transport",{"v":0.01,"d":"1%"},{"$f":"Total_Wedding_Budget*'Récapitulatif du budget'!$C15","v":{"v":200,"d":"200 €"}},{"$f":"Table_Transportation[[#Totals],[Coût estimé]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Transportation[[#Totals],[Coût réel]]","v":{"v":0,"d":"0 €"}}]
[null,"Total",{"$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,"CONTRIBUTIONS"]
[null,"Sources des fonds","Contribution"]
[null,"Épargne",{"v":10000,"d":"10,000 €"}]
[null,"Parents du partenaire 1",{"v":4000,"d":"4,000 €"}]
[null,"Grands-parents du partenaire 1",{"v":2000,"d":"2,000 €"}]
[null,"Parents du partenaire 2",{"v":4000,"d":"4,000 €"}]
[null,"Grands-parents du partenaire 2",{"v":4000,"d":"4,000 €"}]
[null,"Autres contributions",{"v":2000,"d":"2,000 €"}]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Contributions[Contribution])","v":{"v":26000,"d":"26,000 €"}}]
[]
[null,{"$f":"IF(Table_Contributions[[#Totals],[Contribution]]<Total_Wedding_Budget,\"Écart à combler\",\"Fonds supplémentaires disponibles\")","v":"Fonds supplémentaires disponibles"},{"$f":"IF(Table_Contributions[[#Totals],[Contribution]]<Total_Wedding_Budget,Total_Wedding_Budget-Table_Contributions[[#Totals],[Contribution]],Table_Contributions[[#Totals],[Contribution]]-Total_Wedding_Budget)","v":{"v":6000,"d":"6,000 €"}}]

{"sheet":"Détails du budget","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"RÉCEPTION","Coût estimé","Coût réel"]
[null,"Lieu et location"]
[null,"Nourriture et service"]
[null,"Boissons"]
[null,"Gâteau"]
[null,"Divers"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Reception[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Reception[Coût réel])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"TENUE","Coût estimé","Coût réel"]
[null,"Smoking, costume et/ou robes"]
[null,"Retouches"]
[null,"Coiffe et voile"]
[null,"Accessoires"]
[null,"Coiffure et maquillage"]
[null,"Divers"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Attire[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Attire[Coût réel])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"FLEURS ET DÉCORATIONS","Coût estimé","Coût réel"]
[null,"Compositions florales pour la cérémonie"]
[null,"Bouquets et panier de fleurs"]
[null,"Coussin pour les alliances"]
[null,"Bouquets"]
[null,"Fleurs à porter à la boutonnière"]
[null,"Petits bouquets à épingler au corsage"]
[null,"Décorations de la réception"]
[null,"Éclairage"]
[null,"Divers"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_FlowersAndDecorations[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_FlowersAndDecorations[Coût réel])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"MUSIQUE","Coût estimé","Coût réel"]
[null,"Musiciens pour la cérémonie"]
[null,"Musiciens pour le cocktail"]
[null,"Groupe, DJ pour la réception"]
[null,"Location sonorisation ou piste de danse"]
[null,"Divers"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Music[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Music[Coût réel])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"PHOTO ET VIDÉO","Coût estimé","Coût réel"]
[null,"Photographie"]
[null,"Vidéo"]
[null,"Autres impressions et albums"]
[null,"Divers"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_PhotographsAndVideo[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_PhotographsAndVideo[Coût réel])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"FAVEURS ET DONS","Coût estimé","Coût réel"]
[null,"Cadeaux de bienvenue"]
[null,"Cadeaux"]
[null,"Divers"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_FavorsAndGifts[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_FavorsAndGifts[Coût réel])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"CÉRÉMONIE","Coût estimé","Coût réel"]
[null,"Frais de location"]
[null,"Frais de l’officiant ou don"]
[null,"Divers"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Ceremony[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Ceremony[Coût réel])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"PAPETERIE","Coût estimé","Coût réel"]
[null,"Carte de rappel de la date"]
[null,"Invitations et relances"]
[null,"Programmes"]
[null,"Plan de table et marqueurs"]
[null,"Menus"]
[null,"Cartes de remerciement"]
[null,"Affranchissement"]
[null,"Divers"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Stationery[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Stationery[Coût réel])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"ALLIANCES","Coût estimé","Coût réel"]
[null,"Alliances"]
[null,"Accessoires"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_WeddingRings[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_WeddingRings[Coût réel])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"TRANSPORT","Coût estimé","Coût réel"]
[null,"Location de voiture"]
[null,"Locations de voiture pour invités"]
[null,"Transport pour les personnes venant de loin"]
[null,"Voiturier"]
[null,"Divers"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Transportation[Coût estimé])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Transportation[Coût réel])","v":{"v":0,"d":"0.00 €"}}]