{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Hoja1","Hoja2","Hoja3","Hoja4","Hoja1 (2)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Hoja1","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
[]
[null,"Para Calcular Total obras anexas en M$ 30° Llamado",null,null,null,null,null,null,null,null,"Para calcular antigüedad del conjunto Hab"]
[null,"INGRESAR CANTIDAD DE UF POR CADA VIA POSTULADA EN CADA CELDA AMARILLA."]
["Ejemplo",4.5999999999999996,5.45,2.1,null,null,"Valor UF 31/12/2019","Total\nUF","Valor Total  Obras Anexas en  (M$)",null,"Ingresar Año Recepción final Conjunto","Año según Fecha de Cierre","Cantidad de años del Conj. Habitacional"]
[null,null,null,null,null,null,28309.94,{"$f":"B4+C4+D4+E4+F4+B5+C5+D5+E5+F5","v":12.15},{"$f":"(H5*G5)/1000","v":343.96577100000002},null,null,2020,{"$f":"+L5-K5","v":2020}]
[]
["* Colocar Titulo en Software: Costo Total Obras Anexas Según Ptto.  Adjunto"]
["*Los datos se obtienen de los presupuestos detallados por via según Informe favorable"]

{"sheet":"Hoja2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hoja3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hoja4","index":3,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ALHUE",1.67,456754,1.67,456754,"No"]
[null,"BUIN",2.31,631798,2.31,631798,"No"]
[null,"CALERA DE TANGO",0,0,0,0,"No"]
[null,"CERRILLOS",1.69,462224,1.69,462224,"No"]
[null,"CERRO NAVIA",2.12,579832,2.12,579832,"No"]
[null,"COLINA",1.87,511455,1.87,511455,"No"]
[null,"CONCHALI",3.73,1020176,3.73,1020176,"No"]
[null,"CURACAVI",0,0,0,0,"No"]
[null,"EL BOSQUE",2.4300000000000002,664619,2.4300000000000002,664619,"No"]
[null,"EL MONTE",0,0,0,0,"No"]
[null,"ESTACION CENTRAL",1.96,536071,1.96,536071,"No"]
[null,"HUECHURABA",1.71,467695,1.71,467695,"No"]
[null,"INDEPENDENCIA",2.77,757610,2.77,757610,"No"]
[null,"ISLA DE MAIPO",0,0,0,0,"No"]
[null,"LA CISTERNA",2.31,631798,2.31,631798,"No"]
[null,"LA FLORIDA",2.76,754875,2.76,754875,"No"]
[null,"LA GRANJA",2.19,598977,2.19,598977,"No"]
[null,"LA PINTANA",2.74,749405,2.74,749405,"No"]
[null,"LA REINA",1.53,418464,1.53,418464,"No"]
[null,"LAMPA",3.14,858808,3.14,858808,"No"]
[null,"LAS CONDES",0,0,0,0,"No"]
[null,"LO BARNECHEA",1.86,508720,1.86,508720,"No"]
[null,"LO ESPEJO",1.92,525131,1.92,525131,"No"]
[null,"LO PRADO",1.86,508720,1.86,508720,"No"]
[null,"MACUL",1.97,538806,1.97,538806,"No"]
[null,"MAIPU",4,1094022,4,1094022,"No"]
[null,"MARIA PINTO",1.58,432139,1.58,432139,"No"]
[null,"MELIPILLA",2.63,719320,2.63,719320,"No"]
[null,"ÑUÑOA",0,0,0,0,"No"]
[null,"PADRE HURTADO",2.46,672824,2.46,672824,"No"]
[null,"PAINE",1.72,470430,1.72,470430,"No"]
[null,"PEDRO AGUIRRE CERDA",1.92,525131,1.92,525131,"No"]
[null,"PEÑAFLOR",1.84,503250,1.84,503250,"No"]
[null,"PEÑALOLEN",2.5099999999999998,686499,2.5099999999999998,686499,"No"]
[null,"PIRQUE",1.52,415728,1.52,415728,"No"]
[null,"PROVIDENCIA",0,0,0,0,"No"]
[null,"PUDAHUEL",2.17,593507,2.17,593507,"No"]
[null,"PUENTE ALTO",3.53,965475,3.53,965475,"No"]
[null,"QUILICURA",2.2000000000000002,601712,2.2000000000000002,601712,"No"]
[null,"QUINTA NORMAL",1.85,505985,1.85,505985,"No"]
[null,"RECOLETA",2.37,648208,2.37,648208,"No"]
[null,"RENCA",2.06,563422,2.06,563422,"No"]
[null,"SAN BERNARDO",4.8499999999999996,1326502,4.8499999999999996,1326502,"No"]
[null,"SAN JOAQUIN",2.5,683764,2.5,683764,"No"]
[null,"SAN JOSE DE MAIPO",0,0,0,0,"No"]
[null,"SAN MIGUEL",1.94,530601,1.94,530601,"No"]
[null,"SAN PEDRO",1.53,418464,1.53,418464,"No"]
[null,"SAN RAMON",1.91,522396,1.91,522396,"No"]
[null,"SANTIAGO",2.77,757610,2.77,757610,"No"]
[null,"TALAGANTE",1.61,440344,1.61,440344,"No"]
[null,"TIL TIL",3.99,1091287,3.99,1091287,"No"]
[null,"VITACURA",0,0,0,0,"No"]
[null,null,{"$f":"SUM(C2:C53)","v":99.999999999999986}]

{"sheet":"Hoja1 (2)","index":4,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[null,"Para Calcular Total obras anexas en M$",null,null,null,null,null,null,null,null,"Para calcular antigüedad del conjunto",null,null,null,"Para calcular aporte de quien Financia ingenieria (Comité o Municipio)"]
[null,"INGRESAR CANTIDAD DE UF POR CADA VIA POSTULADA EN CADA CELDA AMARILLA."]
[null,null,null,null,null,null,"UF 31/12/2017",null,"Valor Total  Obras Anexas (M$)",null,"Ingresar Año recepción final Conjunto",null,"Cantidad de años Conj. Habitacional",null,"Ingresar Costo Proyecto de Ingeniería (M$)","Ingresar Aporte min reglament . de quien financia ing.(M$)","Resultado del Aporte final de quien financia ing. (M$)"]
[null,null,null,null,35.173999999999999,46.106000000000002,28309.94,{"$f":"B3+C3+D3+E3+F3+B4+C4+D4+E4+F4","v":81.28},{"$f":"(H4*G4)/1000","v":2301.0319232000002},null,1987,2018,{"$f":"L4-K4","v":31},null,811,1893,{"$f":"P4-O4","v":1082}]
[]
["* Colocar Titulo en Software: Costo Total Obras Anexas Según PPTO Adjunto"]
["*Los datos se obtienen de los presupuestos detallados por via"]