{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["calculoL","impresiónL","generadorL","CISTERNA"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"calculoL","index":0,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,8],[9,1,9,8],[10,6,10,8],[4,1,4,8],[3,4,3,8],[2,2,2,8]]}
[]
[null,"Cliente","MIGUEL ANGEL HERNANDEZ"]
[null,"Ubicación","55 PONINETE 32323-12"]
[null,"Fecha:",{"$f":"TODAY()","v":"2025-06-22"},"Elaboró","ARQ. MIGUEL ANGEL HERNANDEZ CASTILLO"]
[null,"Medidas Exteriores de la Cisterna"]
[null,2,"ancho",2,"largo",1.7,"altura",{"$f":"generadorL!E4","v":3.3234999999999992},"m3 de agua",null," "]
[null," ",null," "]
[]
[null," "]
[null,"Siguenos en nuestras redes sociales para nuevos videos"]
[null,null,null,null,null,null,"studio.digital.pue@gmail.com"]

{"sheet":"impresiónL","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[21,0,26,3],[21,4,21,5],[25,4,25,5],[4,0,4,5],[3,1,3,3]]}
[]
["Cliente",{"$f":"calculoL!C2","v":"MIGUEL ANGEL HERNANDEZ"},null,null,null,"fecha"]
["Ubicación",{"$f":"calculoL!C3","v":"55 PONINETE 32323-12"},null,null,null,{"$f":"calculoL!C4","v":"2025-06-22"}]
["Elaboró",{"$f":"calculoL!E4","v":"ARQ. MIGUEL ANGEL HERNANDEZ CASTILLO"},null,null,"CAP. CIST. M3",{"$f":"calculoL!H6","v":3.3234999999999992}]
["PRESUPUESTO DE CONSTRUCCION DE CISTERNA"]
["CLAVE","DESCRIPCION","U.","CANT.","P.U.","TOTAL"]
[{"$f":"generadorL!A6","v":"EXC01"},{"$f":"generadorL!B6","v":"EXCAVACION EN TERRENO TIPO 2 POR MEDIOS MECANICOS(RETROEXCAVADORA) HASTA UNA PROFUNDIDAD DE 2.5 M"},{"$f":"generadorL!C6","v":"M3"},{"$f":"generadorL!D6","v":6.8},120,{"$f":"E7*D7","v":816}]
[{"$f":"generadorL!A7","v":"AFINE"},{"$f":"generadorL!B7","v":"AFINE DE EXCAVACION EN FONDO Y PAREDES LATERALES "},{"$f":"generadorL!C7","v":"M3"},{"$f":"generadorL!D7","v":0.96},205,196.79999999999998]
[{"$f":"generadorL!A8","v":"ACA001"},{"$f":"generadorL!B8","v":"ACARREO DE MATERIAL PRODUCTO DE EXCAVACIONES SOBRE CAMION DE VOLTEO CAPACIDAD 6 M3, INCUYE CARGA MECANICA Y ABUNDAMIENTO"},{"$f":"generadorL!C8","v":"M3"},{"$f":"generadorL!D8","v":10.199999999999999},130,1326]
["PLANT",{"$f":"generadorL!B9","v":"PLATILLA DE CONCRETO SIMPLE F?C= 100 KG /CM2 ESPESOR PROMEDIO DE 5 CMS"},{"$f":"generadorL!C9","v":"M2"},{"$f":"generadorL!D9","v":4},135,540]
[{"$f":"generadorL!A10","v":"MALLA"},{"$f":"generadorL!B10","v":"LOSA O FIRME EN CIMENTACION A BASE DE MALLA 10-10/10-10 Y CONCRETO F'C= 200 KG/CM2 EN UN ESPESOR PROMEDIO DE 10 CMS"},{"$f":"generadorL!C10","v":"M2"},{"$f":"generadorL!D10","v":4},478,1912]
["CDD",{"$f":"generadorL!B11","v":"DALA O CADENAS DE DESPLANTE PARA MUROS DE 15X20, EN ARMEX Y CONCRETO F'C=250 KG/CM2"},{"$f":"generadorL!C11","v":"M"},{"$f":"generadorL!D11","v":8},275,2200]
[{"$f":"generadorL!A12","v":"CAS01"},{"$f":"generadorL!B12","v":"CASTILLO DE ARMEX 15X15 Y CONCRETO F'C= 200 KF/CM2"},{"$f":"generadorL!C12","v":"M"},{"$f":"generadorL!D12","v":5.6},300,1680]
[{"$f":"generadorL!A13","v":"MUR"},{"$f":"generadorL!B13","v":"MUROS DE BLOCK O DE LADRILLO ROJO COMUN"},{"$f":"generadorL!C13","v":"M2"},{"$f":"generadorL!D13","v":7.9999999999999991},350,2799.9999999999995]
[{"$f":"generadorL!A14","v":"REPE"},{"$f":"generadorL!B14","v":"REPELLADO DE MURO CON MORTERO CEMENTO ARENA PROP 1:4 EN 2 CMS PROM"},{"$f":"generadorL!C14","v":"M2"},{"$f":"generadorL!D14","v":7.9999999999999991},167,1335.9999999999998]
[{"$f":"generadorL!A15","v":"CHAFAN"},{"$f":"generadorL!B15","v":"CHAFLAN DE CONCRETO DE 5 CMS EN VERTICES DE PISO Y MUROS"},{"$f":"generadorL!C15","v":"ML"},{"$f":"generadorL!D15","v":13.6},55,748]
[{"$f":"generadorL!A16","v":"PULI"},{"$f":"generadorL!B16","v":"PULIDO DE CEMENTO SOBRE REPELLA EN MUROS"},{"$f":"generadorL!C16","v":"M2"},{"$f":"generadorL!D16","v":7.9999999999999991},217,1735.9999999999998]
[{"$f":"generadorL!A17","v":"LOSA "},{"$f":"generadorL!B17","v":"ELABORACION DE LOSA A BASE DE VIGUETA Y BOVEDILLA DE 16 CMS DE PERALTE Y REFORZADA CON MALLA 10-10/10-10 Y UNA CAPA DE CAPA DE COMPRESION DE 5 CMS EN CONCRETO F'C= 200 KG/CM2"},{"$f":"generadorL!C17","v":"M2"},{"$f":"generadorL!D17","v":4},1100,4400]
[{"$f":"generadorL!A18","v":"LIM F"},{"$f":"generadorL!B18","v":"LIMPIEZA FINAL DEL AREA DE TRANAJO RETIRANDO MATERIAL SOBRANTE O ESCOMBROS "},{"$f":"generadorL!C18","v":"m3"},{"$f":"generadorL!D18","v":0.79999999999999993},450,359.99999999999994]
[null," ",null,null,"SUMA",{"$f":"SUM(F7:F19)","v":20050.8}]
[" "]
["NOTAS: Se requiere un 30% de anticipo para iniciar los trabajos, el resto se dividira conra avance de los trabajos.",null,null,null,"Atentamente"]

{"sheet":"generadorL","index":2,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,8],[3,2,3,3]]}
["CISTERNA DE LADRILLO O BLOCK"]
[null,"DATOS BASICOS"]
[null,"MEDIDAS EXTERIORES     LARGO",{"$f":"calculoL!D6","v":2},"ANCHO",{"$f":"calculoL!B6","v":2},"PRFO.",{"$f":"calculoL!F6","v":1.7},"TOTAL M3",{"$f":"G3*E3*C3","v":6.8}]
[null,null,"Capacidad real",null,{"$f":"((C3-0.3)*(E3-0.3)*(G3-0.55))","v":3.3234999999999992},"CON MEDIDAS INTERIORES"]
["CLAVE","DESCRIPCION","U","CANT. T","LARGO","ANCHO","ALTO","PZA","SUB TOTAL"]
["EXC01","EXCAVACION EN TERRENO TIPO 2 POR MEDIOS MECANICOS(RETROEXCAVADORA) HASTA UNA PROFUNDIDAD DE 2.5 M","M3",{"$f":"I6","v":6.8},{"$f":"$C$3","v":2},{"$f":"$E$3","v":2},{"$f":"G3","v":1.7},null,{"$f":"E6*F6*G6","v":6.8}]
["AFINE","AFINE DE EXCAVACION EN FONDO Y PAREDES LATERALES ","M3",{"$f":"((C3*E3)+D13)*0.08","v":0.96}]
["ACA001","ACARREO DE MATERIAL PRODUCTO DE EXCAVACIONES SOBRE CAMION DE VOLTEO CAPACIDAD 6 M3, INCUYE CARGA MECANICA Y ABUNDAMIENTO","M3",{"$f":"D6*1.5","v":10.199999999999999}]
["PLAN","PLATILLA DE CONCRETO SIMPLE F?C= 100 KG /CM2 ESPESOR PROMEDIO DE 5 CMS","M2",{"$f":"I9","v":4},{"$f":"$C$3","v":2},{"$f":"$E$3","v":2},null,null,{"$f":"E9*F9","v":4}]
["MALLA","LOSA O FIRME EN CIMENTACION A BASE DE MALLA 10-10/10-10 Y CONCRETO F'C= 200 KG/CM2 EN UN ESPESOR PROMEDIO DE 10 CMS","M2",{"$f":"I10","v":4},{"$f":"$C$3","v":2},{"$f":"$E$3","v":2},null,null,{"$f":"E10*F10","v":4}]
["CDD","DALA O CADENAS DE DESPLANTE PARA MUROS DE 15X20, EN ARMEX Y CONCRETO F'C=250 KG/CM2","M",{"$f":"(C3*2)+(E3*2)","v":8}]
["CAS01","CASTILLO DE ARMEX 15X15 Y CONCRETO F'C= 200 KF/CM2","M",{"$f":"I12","v":5.6},null,null,{"$f":"G6-0.3","v":1.4},4,{"$f":"H12*G12","v":5.6}]
["MUR","MUROS DE BLOCK O DE LADRILLO ROJO COMUN","M2",{"$f":"D11*(G12-0.4)","v":7.9999999999999991}]
["REPE","REPELLADO DE MURO CON MORTERO CEMENTO ARENA PROP 1:4 EN 2 CMS PROM","M2",{"$f":"D13","v":7.9999999999999991}]
["CHAFAN","CHAFLAN DE CONCRETO DE 5 CMS EN VERTICES DE PISO Y MUROS","ML",{"$f":"D11+D12","v":13.6}]
["PULI","PULIDO DE CEMENTO SOBRE REPELLA EN MUROS","M2",{"$f":"D14","v":7.9999999999999991}]
["LOSA ","ELABORACION DE LOSA A BASE DE VIGUETA Y BOVEDILLA DE 16 CMS DE PERALTE Y REFORZADA CON MALLA 10-10/10-10 Y UNA CAPA DE CAPA DE COMPRESION DE 5 CMS EN CONCRETO F'C= 200 KG/CM2","M2",{"$f":"D9","v":4}]
["LIM F","LIMPIEZA FINAL DEL AREA DE TRANAJO RETIRANDO MATERIAL SOBRANTE O ESCOMBROS ","m3",{"$f":"(D13*0.05)*2","v":0.79999999999999993}]

{"sheet":"CISTERNA","index":3,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":true,"merged":[[35,2,35,3],[32,0,32,8],[5,0,6,0],[0,0,0,15],[2,0,3,0],[2,1,3,1],[2,2,2,5],[2,6,2,15],[11,0,11,8]]}
["CISTERNA DE CONCRETO ARMADO"]
[null,"LARGO",2.1,"ANCHO",1.5,"PROFUNDIDA",null,2]
["CLAVE","ELEMENTO","DATOS",null,null,null," "]
[null,null,"largo","ancho","GANCHOS","ALTURA","  @ PARR.","No. Acero A","ML","total acero A (kg)","M2 CIMBRA","M3 CONC.","EXCAV. M3","PLANTILLA M2","AFINE FONDO Y MUROS M2","CARG Y ACA + ABUND M3"]
["BASE","LOSA DE CIMENTACION ",{"$f":"C2","v":2.1},{"$f":"E2","v":1.5},0.15,0.25,0.2,3,{"$f":"((((C5/G5)+1)*(C5+E5))+(((D5/G5)+1)*(D5+E5)))","v":39.9},{"$f":"I5*(H5*H5/16)","v":22.443749999999998}," ",{"$f":"C5*D5*F5","v":0.78750000000000009},{"$f":"C5*D5*F6","v":6.3000000000000007},{"$f":"C5*D5","v":3.1500000000000004},{"$f":"N5+((C5+D5+C5+D5)*F6)","v":17.55},{"$f":"M5*1.5","v":9.4500000000000011}]
["MUROS","MURO LARGO",{"$f":"C5","v":2.1},0.15,null,{"$f":"H2","v":2},0.2,3,{"$f":"((C6/G6+1)*C6)+((F6/G6+1)*F6)","v":46.150000000000006},{"$f":"(((H6*H6/16)*I6)*2)*2","v":103.83750000000001},{"$f":"F6*C6*2","v":8.4},{"$f":"F6*D6*C6","v":0.63}]
[null,"MURO CORTO",{"$f":"D5","v":1.5},0.15,null,{"$f":"F6","v":2},0.2,3,{"$f":"((C7/G7+1)*C7)+((F7/G7+1)*F7)","v":34.75},{"$f":"(((H7*H7/16)*I7)*2)*2","v":78.1875},{"$f":"F7*C7*2","v":6},{"$f":"F7*D7*C7","v":0.44999999999999996}]
["LOSA","LOSA DE CONCRETO ARMADO",{"$f":"C6","v":2.1},{"$f":"C7","v":1.5},7.0000000000000007E-2,0.15,0.2,3,{"$f":"((((C8/G8)+1)*(C8+E8))+(((D8/G8)+1)*(D8+E8)))","v":38.299999999999997},{"$f":"I8*(H8*H8/16)","v":21.543749999999999},{"$f":"D8*C8","v":3.1500000000000004},{"$f":"F8*D8*C8","v":0.47249999999999998}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J5:J8)","v":226.01249999999999},{"$f":"SUM(K6:K8)","v":17.55},{"$f":"SUM(L5:L8)","v":2.34},{"$f":"SUM(M5:M8)","v":6.3000000000000007},{"$f":"SUM(N5:N8)","v":3.1500000000000004},{"$f":"SUM(O5:O8)","v":17.55},{"$f":"SUM(P5:P8)","v":9.4500000000000011}]
[null,null,null,null,null,null,null,null,null,{"$f":"J8+J7+J6","v":203.56875000000002}]
[]
["CATALOGO DE CONCEPTOS DE CISTERNA DE CONCRETO ARMADO"]
["CLAVE","DESCRIPCION","U","CANT. T","LARGO","ANCHO","ALTO","PZA","SUB TOTAL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CISTERNA DE LADRILLO O BLOCK"]
[null,"DATOS BASICOS"]
[null,"LARGO",1.8,"ANCHO",2,"PRFO.",2.2000000000000002,"TOTAL M3",{"$f":"G35*E35*C35","v":7.9200000000000008}]
[null,null,"Capacidad real",null,{"$f":"((C35-0.3)*(E35-0.3)*(G35-0.5))","v":4.335}]
["CLAVE","DESCRIPCION","U","CANT. T","LARGO","ANCHO","ALTO","PZA","SUB TOTAL"]
["LT01","LIMPEZA DE TERRENO DE MATERIALES VEGETALES RETIRANMDO UNA CAPA PROMEDIO DE 20 CMS","M3",{"$f":"I38","v":0.72000000000000008},{"$f":"$C$35","v":1.8},{"$f":"$E$35","v":2},0.2,null,{"$f":"E38*F38*G38","v":0.72000000000000008}]
["TRA01","TRAZO DE TERRENO PARA LOCALIZA EJES CONSTRUCTIVOS POR MEDIOS MANUALES CON HILO Y MANGUERA","M2",{"$f":"I39","v":3.6},{"$f":"$C$35","v":1.8},{"$f":"$E$35","v":2},null,null,{"$f":"E39*F39","v":3.6}]
["EXC01","EXCAVACION EN TERRENO TIPO 2 POR MEDIOS MECANICOS(RETROEXCAVADORA) HASTA UNA PROFUNDIDAD DE 2.5 M","M3",{"$f":"I40","v":7.9200000000000008},{"$f":"$C$35","v":1.8},{"$f":"$E$35","v":2},{"$f":"G35","v":2.2000000000000002},null,{"$f":"E40*F40*G40","v":7.9200000000000008}]
["PANTILLA ","PLATILLA DE CONCRETO SIMPLE F?C= 100 KG /CM2 ESPESOR PROMEDIO DE 5 CMS","M2",{"$f":"I41","v":3.6},{"$f":"$C$35","v":1.8},{"$f":"$E$35","v":2},null,null,{"$f":"E41*F41","v":3.6}]
["MALLA","LOSA DE CIMENETACION A BASE DE MALLA 10-10/10-10 Y CONCRETO F'C= 200 KG/CM2 EN UN ESPESOR PROMEDIO DE 10 CMS","M2",{"$f":"I42","v":3.6},{"$f":"$C$35","v":1.8},{"$f":"$E$35","v":2},null,null,{"$f":"E42*F42","v":3.6}]
["CADENAS","CADENAS DE DESPLANTE PARA MUROS DE 15X20, EN ARMEX Y CONCRETO F'C=150 KG/CM2","M",{"$f":"(C35*2)+(E35*2)","v":7.6}]
["CAS01","CASTILLO DE ARMEX 15X15 Y CONCRETO F'C= 150 KF/CM2","M",{"$f":"I44","v":8.8000000000000007},null,null,{"$f":"G40","v":2.2000000000000002},4,{"$f":"H44*G44","v":8.8000000000000007}]
["MUR","MUROS DE BLOCK DE 12X20X40 CON REFUERZO HORINZONTAL A CADA 3 HILADAS ACENTADO CON MORTERO CEMENTO ARENA 1:4","M2",{"$f":"D43*(G44-0.4)","v":13.680000000000001}]
["REPE","REPELLADO DE MURO CON MORTERO CEMENTO ARENA PROP 1:4 EN 2 CMS PROM","M2",{"$f":"D45","v":13.680000000000001}]
["PULI","PULIDO DE CEMENTO SOBRE REPELLA EN MUROS","M2",{"$f":"D46","v":13.680000000000001}]
["LOSA ","ELABORACION DE LOSA A BASE DE VIGUETA Y BOVEDILLA DE 16 CMS DE PERALTE Y REFORZADA CON MALLA 10-10/10-10 Y UNA CAPA DE CAPA DE COMPRESION DE 5 CMS EN CONCRETO F'C= 200 KG/CM2","M2",{"$f":"D41","v":3.6}]