{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Costes de remodelación del baño"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Costes de remodelación del baño","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,"Hoja de cálculo de los costes de reforma del baño"]
[null,"NOTA: En las columnas de diferencia de la tabla se mostrará si el importe real superó la cantidad estimada. Los números en color rojo indican que se superó (negativo) y los números en color negro que no (positivo). "]
[{"$nulls":4},"Coste detallado (€)",null,null,"Coste total (€)"]
[null,"Área","Elementos","Cantidad","Estimado","Real","Diferencia","Estimado ","Real ","Diferencia "]
[null,"Baño/Ducha","Bañera, hierro fundido, 152,4 cm, estándar",1,{"v":250,"d":"250.00 €"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":269,"d":"269.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-19,"d":"-19.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":250,"d":"250.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":269,"d":"269.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-19,"d":"-19.00 €"}}]
[null,"Baño/Ducha","Puertas de ducha, con bisagras, estándar",1,{"v":200,"d":"200.00 €"},{"v":219,"d":"219.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-19,"d":"-19.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":219,"d":"219.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-19,"d":"-19.00 €"}}]
[null,"Baño/Ducha","Alcachofa de ducha, estándar",1,{"v":50,"d":"50.00 €"},{"v":58,"d":"58.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-8,"d":"-8.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":50,"d":"50.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":58,"d":"58.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-8,"d":"-8.00 €"}}]
[null,"Baño/Ducha","Recubrimiento de la pared de la bañera, estándar",1,{"v":200,"d":"200.00 €"},{"v":208,"d":"208.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-8,"d":"-8.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":208,"d":"208.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-8,"d":"-8.00 €"}}]
[null,"Armarios","Botiquín de 60,96 cm, de lujo",1,{"v":200,"d":"200.00 €"},{"v":217,"d":"217.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-17,"d":"-17.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":217,"d":"217.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-17,"d":"-17.00 €"}}]
[null,"Armarios","Lavabo modular de 76,20 cm, estándar",2,{"v":100,"d":"100.00 €"},{"v":107,"d":"107.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-7,"d":"-7.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":214,"d":"214.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-14,"d":"-14.00 €"}}]
[null,"Encimeras","Azulejo cerámico, de lujo (cantidad en metros lineales)",5,{"v":22.5,"d":"22.50 €"},{"v":39,"d":"39.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-16.5,"d":"-16.50 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":112.5,"d":"112.50 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":195,"d":"195.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-82.5,"d":"-82.50 €"}}]
[null,"Grifería","Grifo, bañera, estándar",1,{"v":90,"d":"90.00 €"},{"v":107,"d":"107.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-17,"d":"-17.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":90,"d":"90.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":107,"d":"107.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-17,"d":"-17.00 €"}}]
[null,"Grifería","Grifo, ducha, un solo mando, estándar",1,{"v":115,"d":"115.00 €"},{"v":118,"d":"118.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-3,"d":"-3.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":115,"d":"115.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":118,"d":"118.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-3,"d":"-3.00 €"}}]
[null,"Grifería","Grifo de lavabo, estándar",1,{"v":95,"d":"95.00 €"},{"v":107,"d":"107.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-12,"d":"-12.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":95,"d":"95.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":107,"d":"107.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-12,"d":"-12.00 €"}}]
[null,"Suelo","Azulejo cerámico, estándar (cantidad en metros cuadrados).",35,{"v":12,"d":"12.00 €"},{"v":30,"d":"30.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-18,"d":"-18.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":420,"d":"420.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":1050,"d":"1,050.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-630,"d":"-630.00 €"}}]
[null,"Accesorios","Toallero, estándar",2,{"v":15,"d":"15.00 €"},{"v":31,"d":"31.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-16,"d":"-16.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":30,"d":"30.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":62,"d":"62.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-32,"d":"-32.00 €"}}]
[null,"Accesorios","Portarrollos",1,{"v":10,"d":"10.00 €"},{"v":18,"d":"18.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-8,"d":"-8.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":10,"d":"10.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":18,"d":"18.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-8,"d":"-8.00 €"}}]
[null,"Iluminación","Luces encastrables, estándar",4,{"v":25,"d":"25.00 €"},{"v":28,"d":"28.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-3,"d":"-3.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":100,"d":"100.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":112,"d":"112.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-12,"d":"-12.00 €"}}]
[null,"Fregaderos","Inodoro, estándar",2,{"v":60,"d":"60.00 €"},{"v":79,"d":"79.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-19,"d":"-19.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":120,"d":"120.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":158,"d":"158.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-38,"d":"-38.00 €"}}]
[null,"Otros",null,1,{"v":20,"d":"20.00 €"},{"v":29,"d":"29.00 €"},{"$f":"IFERROR(Costes[[#This Row],[Estimado]]-Costes[[#This Row],[Real]], \"\")","v":{"v":-9,"d":"-9.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Estimado]], \"\")","v":{"v":20,"d":"20.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Cantidad]]*Costes[[#This Row],[Real]], \"\")","v":{"v":29,"d":"29.00 €"}},{"$f":"IFERROR(Costes[[#This Row],[Estimado ]]-Costes[[#This Row],[Real ]], \"\")","v":{"v":-9,"d":"-9.00 €"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Costes[Estimado])","v":{"v":1464.5,"d":"1,464.50 €"}},{"$f":"SUBTOTAL(109,Costes[Real])","v":{"v":1664,"d":"1,664.00 €"}},{"$f":"SUBTOTAL(109,Costes[Diferencia])","v":{"v":-199.5,"d":"-199.50 €"}},{"$f":"SUBTOTAL(109,Costes[[Estimado ]])","v":{"v":2212.5,"d":"2,212.50 €"}},{"$f":"SUBTOTAL(109,Costes[[Real ]])","v":{"v":3141,"d":"3,141.00 €"}},{"$f":"SUBTOTAL(109,Costes[[Diferencia ]])","v":{"v":-928.5,"d":"-928.50 €"}}]
[null,"Costes inesperados (agregar una estimación del 30 %)",null,null,{"$f":"IFERROR(Costes[[#Totals],[Estimado]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"439.35 €"}},null,null,{"$f":"IFERROR(Costes[[#Totals],[Estimado ]]*0.3, \"\")","v":{"v":663.75,"d":"663.75 €"}}]
[null,"Costes totales",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"1,464.50 €"}},null,null,{"$f":"IFERROR(SUM(Costes[[#Totals],[Estimado ]],Excedente), \"\")","v":{"v":2876.25,"d":"2,876.25 €"}}]