{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Costos de la reforma del baño"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Costos de la reforma del baño","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"merged":[[1,1,2,3],[2,4,2,6],[2,7,2,9],[22,1,22,3],[22,4,22,6],[22,7,22,9],[23,1,23,3],[23,4,23,6],[23,7,23,9]]}
[null,"Hoja de cálculo de costos 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},"Costo por artículo ($)",null,null,"Costo 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":267,"d":"$267.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-17,"d":"-$17.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":250,"d":"$250.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":267,"d":"$267.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-17,"d":"-$17.00"}}]
[null,"Baño/Ducha","Puertas de ducha, con bisagras, estándar",1,{"v":200,"d":"$200.00"},{"v":203,"d":"$203.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-3,"d":"-$3.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":200,"d":"$200.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":203,"d":"$203.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-3,"d":"-$3.00"}}]
[null,"Baño/Ducha","Alcachofa de ducha, estándar",1,{"v":50,"d":"$50.00"},{"v":65,"d":"$65.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-15,"d":"-$15.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":50,"d":"$50.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":65,"d":"$65.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-15,"d":"-$15.00"}}]
[null,"Baño/Ducha","Recubrimiento de la pared de la bañera, estándar",1,{"v":200,"d":"$200.00"},{"v":220,"d":"$220.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-20,"d":"-$20.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":200,"d":"$200.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":220,"d":"$220.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-20,"d":"-$20.00"}}]
[null,"Armarios","Botiquín de 60,96 cm, de lujo",1,{"v":200,"d":"$200.00"},{"v":216,"d":"$216.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-16,"d":"-$16.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":200,"d":"$200.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":216,"d":"$216.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-16,"d":"-$16.00"}}]
[null,"Armarios","Lavabo modular de 76,20 cm, estándar",2,{"v":100,"d":"$100.00"},{"v":105,"d":"$105.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-5,"d":"-$5.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":200,"d":"$200.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":210,"d":"$210.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-10,"d":"-$10.00"}}]
[null,"Encimeras","Azulejo cerámico, de lujo (cantidad en metros lineales)",5,{"v":22.5,"d":"$22.50"},{"v":26,"d":"$26.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-3.5,"d":"-$3.50"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":112.5,"d":"$112.50"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":130,"d":"$130.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-17.5,"d":"-$17.50"}}]
[null,"Grifería","Grifo, bañera, estándar",1,{"v":90,"d":"$90.00"},{"v":97,"d":"$97.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-7,"d":"-$7.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":90,"d":"$90.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":97,"d":"$97.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-7,"d":"-$7.00"}}]
[null,"Grifería","Grifo, ducha, un solo mando, estándar",1,{"v":115,"d":"$115.00"},{"v":132,"d":"$132.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-17,"d":"-$17.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":115,"d":"$115.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":132,"d":"$132.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-17,"d":"-$17.00"}}]
[null,"Grifería","Grifo de lavabo, estándar",1,{"v":95,"d":"$95.00"},{"v":114,"d":"$114.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-19,"d":"-$19.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":95,"d":"$95.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":114,"d":"$114.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-19,"d":"-$19.00"}}]
[null,"Suelo","Azulejo cerámico, estándar (cantidad en metros cuadrados).",35,{"v":12,"d":"$12.00"},{"v":19,"d":"$19.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-7,"d":"-$7.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":420,"d":"$420.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":665,"d":"$665.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-245,"d":"-$245.00"}}]
[null,"Accesorios","Toallero, estándar",2,{"v":15,"d":"$15.00"},{"v":18,"d":"$18.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-3,"d":"-$3.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":30,"d":"$30.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":36,"d":"$36.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-6,"d":"-$6.00"}}]
[null,"Accesorios","Portarrollos",1,{"v":10,"d":"$10.00"},{"v":12,"d":"$12.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-2,"d":"-$2.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":10,"d":"$10.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":12,"d":"$12.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-2,"d":"-$2.00"}}]
[null,"Iluminación","Luces encastrables, estándar",4,{"v":25,"d":"$25.00"},{"v":32,"d":"$32.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-7,"d":"-$7.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":128,"d":"$128.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-28,"d":"-$28.00"}}]
[null,"Fregaderos","Inodoro, estándar",2,{"v":60,"d":"$60.00"},{"v":77,"d":"$77.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-17,"d":"-$17.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":120,"d":"$120.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":154,"d":"$154.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-34,"d":"-$34.00"}}]
[null,"Otros",null,1,{"v":20,"d":"$20.00"},{"v":30,"d":"$30.00"},{"$f":"IFERROR(Costos[[#This Row],[Estimado]]-Costos[[#This Row],[Real]], \"\")","v":{"v":-10,"d":"-$10.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Estimado]], \"\")","v":{"v":20,"d":"$20.00"}},{"$f":"IFERROR(Costos[[#This Row],[Cantidad]]*Costos[[#This Row],[Real]], \"\")","v":{"v":30,"d":"$30.00"}},{"$f":"IFERROR(Costos[[#This Row],[Estimado ]]-Costos[[#This Row],[Real ]], \"\")","v":{"v":-10,"d":"-$10.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Costos[Estimado])","v":{"v":1464.5,"d":"$1,464.50"}},{"$f":"SUBTOTAL(109,Costos[Real])","v":{"v":1633,"d":"$1,633.00"}},{"$f":"SUBTOTAL(109,Costos[Diferencia])","v":{"v":-168.5,"d":"-$168.50"}},{"$f":"SUBTOTAL(109,Costos[[Estimado ]])","v":{"v":2212.5,"d":"$2,212.50"}},{"$f":"SUBTOTAL(109,Costos[[Real ]])","v":{"v":2679,"d":"$2,679.00"}},{"$f":"SUBTOTAL(109,Costos[[Diferencia ]])","v":{"v":-466.5,"d":"-$466.50"}}]
[]
[null,"Costos inesperados (agregar un 30 % estimado)",null,null,{"$f":"IFERROR(Costos[[#Totals],[Estimado]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"$439.35"}},null,null,{"$f":"IFERROR(Costos[[#Totals],[Estimado ]]*0.3, \"\")","v":{"v":663.75,"d":"$663.75"}}]
[null,"Costos totales",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"$1,464.50"}},null,null,{"$f":"IFERROR(SUM(Costos[[#Totals],[Estimado ]],Excedente), \"\")","v":{"v":2876.25,"d":"$2,876.25"}}]