{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["COÛTS DE RÉNOVATION DE SDB"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"COÛTS DE RÉNOVATION DE SDB","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[1,1,2,3],[2,4,2,6],[2,7,2,9],[21,1,21,3],[21,4,21,6],[21,7,21,9],[22,1,22,3],[22,4,22,6],[22,7,22,9]]}
[null,"Feuille de calcul des coûts de rénovation de salle de bain"]
[null,"REMARQUE : Les colonnes de différence dans le tableau indiquent si les montants réels ont dépassé les montants estimés. Les nombres en rouge indiquent un montant supérieur au montant estimé (négatif), et les nombres en noir un montant inférieur au montant estimé (positif). "]
[{"$nulls":4},"Coût détaillé (€)",null,null,"Coût total (€)"]
[null,"Catégorie","Articles","Quantité","Estimé","Réel","Différence","Estimé ","Réel ","Différence "]
[null,"Bain/Douche","Baignoire en fonte 150 cm standard",1,{"v":250,"d":"250.00 €"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":265,"d":"265.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-15,"d":"-15.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":250,"d":"250.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":265,"d":"265.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-15,"d":"-15.00 €"}}]
[null,"Bain/Douche","Portes de douche articulées standard",1,{"v":200,"d":"200.00 €"},{"v":214,"d":"214.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-14,"d":"-14.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":214,"d":"214.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-14,"d":"-14.00 €"}}]
[null,"Bain/Douche","Pomme de douche standard",1,{"v":50,"d":"50.00 €"},{"v":70,"d":"70.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-20,"d":"-20.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":50,"d":"50.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":70,"d":"70.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-20,"d":"-20.00 €"}}]
[null,"Bain/Douche","Paroi standard",1,{"v":200,"d":"200.00 €"},{"v":205,"d":"205.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-5,"d":"-5.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":205,"d":"205.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-5,"d":"-5.00 €"}}]
[null,"Meubles de rangement","Armoire à pharmacie 60 cm de luxe",1,{"v":200,"d":"200.00 €"},{"v":207,"d":"207.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-7,"d":"-7.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":207,"d":"207.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-7,"d":"-7.00 €"}}]
[null,"Meubles de rangement","Meuble-lavabo modulaire 70 cm standard",2,{"v":100,"d":"100.00 €"},{"v":111,"d":"111.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-11,"d":"-11.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":222,"d":"222.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-22,"d":"-22.00 €"}}]
[null,"Plans horizontaux","Carrelage en céramique de luxe (en cm linéaires)",5,{"v":22.5,"d":"22.50 €"},{"v":36,"d":"36.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-13.5,"d":"-13.50 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":112.5,"d":"112.50 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":180,"d":"180.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-67.5,"d":"-67.50 €"}}]
[null,"Mitigeurs","Mitigeur baignoire standard",1,{"v":90,"d":"90.00 €"},{"v":103,"d":"103.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-13,"d":"-13.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":90,"d":"90.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":103,"d":"103.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-13,"d":"-13.00 €"}}]
[null,"Mitigeurs","Mitigeur douche à levier unique standard",1,{"v":115,"d":"115.00 €"},{"v":134,"d":"134.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-19,"d":"-19.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":115,"d":"115.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":134,"d":"134.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-19,"d":"-19.00 €"}}]
[null,"Mitigeurs","Mitigeur lavabo standard",1,{"v":95,"d":"95.00 €"},{"v":105,"d":"105.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-10,"d":"-10.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":95,"d":"95.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":105,"d":"105.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-10,"d":"-10.00 €"}}]
[null,"Revêtement de sol","Carrelage en céramique standard (en cm linéaires)",35,{"v":12,"d":"12.00 €"},{"v":31,"d":"31.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-19,"d":"-19.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":420,"d":"420.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":1085,"d":"1,085.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-665,"d":"-665.00 €"}}]
[null,"Quincaillerie","Barre à serviettes standard",2,{"v":15,"d":"15.00 €"},{"v":25,"d":"25.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-10,"d":"-10.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":30,"d":"30.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":50,"d":"50.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-20,"d":"-20.00 €"}}]
[null,"Quincaillerie","Porte-papier hygiénique",1,{"v":10,"d":"10.00 €"},{"v":12,"d":"12.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-2,"d":"-2.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":10,"d":"10.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":12,"d":"12.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-2,"d":"-2.00 €"}}]
[null,"Éclairage","Luminaires encastrés standard",4,{"v":25,"d":"25.00 €"},{"v":35,"d":"35.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-10,"d":"-10.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":100,"d":"100.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":140,"d":"140.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-40,"d":"-40.00 €"}}]
[null,"Éviers","WC standard",2,{"v":60,"d":"60.00 €"},{"v":77,"d":"77.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-17,"d":"-17.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":120,"d":"120.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":154,"d":"154.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-34,"d":"-34.00 €"}}]
[null,"Autres",null,1,{"v":20,"d":"20.00 €"},{"v":37,"d":"37.00 €"},{"$f":"IFERROR(Coûts[[#This Row],[Estimé]]-Coûts[[#This Row],[Réel]], \"\")","v":{"v":-17,"d":"-17.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Estimé]], \"\")","v":{"v":20,"d":"20.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Quantité]]*Coûts[[#This Row],[Réel]], \"\")","v":{"v":37,"d":"37.00 €"}},{"$f":"IFERROR(Coûts[[#This Row],[Estimé ]]-Coûts[[#This Row],[Réel ]], \"\")","v":{"v":-17,"d":"-17.00 €"}}]
[null,"Sous-total",null,null,{"$f":"SUBTOTAL(109,Coûts[Estimé])","v":{"v":1464.5,"d":"1,464.50 €"}},{"$f":"SUBTOTAL(109,Coûts[Réel])","v":{"v":1667,"d":"1,667.00 €"}},{"$f":"SUBTOTAL(109,Coûts[Différence])","v":{"v":-202.5,"d":"-202.50 €"}},{"$f":"SUBTOTAL(109,Coûts[[Estimé ]])","v":{"v":2212.5,"d":"2,212.50 €"}},{"$f":"SUBTOTAL(109,Coûts[[Réel ]])","v":{"v":3183,"d":"3,183.00 €"}},{"$f":"SUBTOTAL(109,Coûts[[Différence ]])","v":{"v":-970.5,"d":"-970.50 €"}}]
[null,"Frais imprévus (ajouter 30 % estimés)",null,null,{"$f":"IFERROR(Coûts[[#Totals],[Estimé]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"439.35 €"}},null,null,{"$f":"IFERROR(Coûts[[#Totals],[Estimé ]]*0.3, \"\")","v":{"v":663.75,"d":"663.75 €"}}]
[null,"Total des coûts",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"1,464.50 €"}},null,null,{"$f":"IFERROR(SUM(Coûts[[#Totals],[Estimé ]],Dépassement), \"\")","v":{"v":2876.25,"d":"2,876.25 €"}}]