{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["Guadalajara","Teocaltiche","San Miguel","Sayula","Autlán","Ahualulco","Villa Guerrero","Resumen por Residencia","Resumen Global"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":27,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Guadalajara","index":0,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,0,8,8]]}
{"$rows_empty":8}
["REPORTE DE ACTIVIDADES RESIDENCIA GUADALAJARA"]
[]
["DICIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS TRAMOS AISLADOS"]
[null,106,"COYULA - MATATLAN",17.399999999999999,"0+400-16+600( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","TONALÁ",16.2,{"$f":"H13*0.5","v":8.1}]
[null,111,"GLORIETA \"EL ALAMO\" – PERIFERICO (PAR VIAL)",4.5999999999999996,"0+000-4+300 ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","SAN PEDRO TLAQUEPAQUE",4.3,{"$f":"H14*0.5","v":2.15}]
[null,112,"CHAPALA - JOCOTEPEC",25.3,"0+000-24+900 ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","CHAPALA",24.9,12.45]
[null,121,"OCOTLAN - LA COMUNIDAD - LABOR VIEJA",14.8,"1+300-2+600( TRAMOS AISLADOS) \n3+000-4+500( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","OCOTLÁN",2.8,1.4]
[null,122,"OCOTLAN - TOTOTLAN",25.5,"6+400-17+800 ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","OCOTLÁN",11.4,5.7]
[null,124,"PARQUE J. GUADALUPE MONTENEGRO - EL CASTILLO",12.4,"0+000-1+300 ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","EL SALTO",1.3,0.65]
[null,126,"ANILLO PERIFERICO - TESISTAN",10,"0+000-2+000 ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","ZAPOPAN",2,1]
[null,132,"PUENTE GRANDE - SANTA FE",7.35,"0+000-8+500 ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","ZAPOTLANEJO",8.5,4.25]
[null,148,"SANTA ROSA - CHAPALA",16.399999999999999,"3+200-3+800  ( TRAMOS AISLADOS) \n4+200-4+800  ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","IXTLAHUACAN DE LOS MEMBRILLOS",{"$f":"0.6+0.6+1","v":2.2000000000000002},1.1000000000000001]
[null,154,"PERIFERICO SUR CHAPALA – SALTILLO",36.6,"1+000-4+000 ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","SAN PEDRO TLAQUEPAQUE",3,1.5]
[null,156,"JUANACATLAN - MIRAFLORES",17.8,"5+100-14+000 ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","JUANACATLÁN",8.9,4.45]
[null,168,"PERIFERICO ORIENTE (JAUJA - COLIMILLA)",14.8,"10+300-8+200  ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","TLAJOMULCO DE ZUÑIGA",2.1000000000000014,1.0500000000000007]
[null,191,"OCOTLAN - SN. MIGUEL DE LA PAZ - JAMAY",17,"0+000-6+000 ( TRAMOS AISLADOS) ","APLICACIÓN DE MARCAS SOBRE EL PAVIMENTO\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","OCOTLÁN",6,3]
[{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$nulls":5},"TOTAL",{"$f":"SUM(H13:H25)","v":93.6},{"$f":"SUM(I13:I25)","v":46.8}]

{"sheet":"Teocaltiche","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[7,0,7,8]]}
{"$rows_empty":7}
["REPORTE DE ACTIVIDADES RESIDENCIA TEOCALTICHE"]
["DICIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS TRAMOS AISLADOS"]
[null,201,"IXTLAHUACAN DEL RIO-CUQUIO-MANALISCO-YAHUALICA",59.5,"0+000 AL 3+000 \n12+300 AL 25+000\n27+208 AL 27+213 \n28+588 AL 28+772\n36+000 AL 52+000 \n 52+450 AL 54+200                         ","DESMONTE A MAQUINA                                                               BACHEO SUPERFICIAL AISLADO\nSUPERVISIÓN A PAVIMENTOS INDUSTRIALES Y URBANIZACIONES, S. A. DE C. V.          \nMARCAR, TRAZAR, BARRER Y PINTAR FRANJAS LOGARITMICAS                                                   ","IXTLAHUACÁN DEL RÍO \nCUQUÍO",{"$f":"3+(25-12.3)+(27.213-28.208)+(28.772-28.588)+(52-36)+(54.2-52.45)","v":32.638999999999996},9.7916999999999987]
[null,202,"ENTRONQUE CARRETERO 201.-MANALISCO",1.9490000000000001,"0+000 AL 1+949","BACHEO SUPERFCIAL AISLADO","YAHUALICA DE GONZÁLEZ GALLO",1.9490000000000001,0.5847]
[null,205,"YAHUALICA-TEOCALTICHE-JARALILLO",96.2,"0+000 AL  17+300\n36+000 AL 40+200\n53+000 AL 53+300                                               \n59+000 AL 96+000","DESMONTE A MANO                                                  DESMONTE A MÁQUINA  \nCALAVEREO Y BACHEO SUPERFICIAL AISLADO                                                                                                                                             MARCAS EN EL PAVIMENTO ","YAHUALICA DE GONZÁLEZ GALLO \nTEOCALTICHE\nENCARNACIÓN DE DÍAZ",12.55,3.7650000000000001]
[null,207,"MEXTICACAN-CAÑADAS DE OBREGÓN",16.899999999999999,"0+000 AL 11+000","SUPERVISIÓN A COSTOS, OBRAS Y PROYECTOS S. A. DE C. V.            ( MEDIR RAYA CENTRAL Y LATERAL )","MEXTICACÁN ",11,3.3]
[null,208,"YAHUALICA-PUENTE TIMONES ( SUB-TRAMO LIMITE EDO. ZAC. )",15.802,"4+000","BACHEO SUPERFICIAL AISLADO","YAHUALICA DE GONZÁLEZ GALLO",null,0]
[null,211,"TEOCALTICHE-VILLA HIDALGO",26.6,"4+000 AL 26+000","SUPERVISIÓN A CHÁVEZ TERRACERIAS Y PAVIMENTOS, S. A. DE C. V.\nCALAVEREO Y BACHEO SUPERFICIAL AISLADO","TEOCALTICHE \n VILLA HIDALGO",22,6.6]
[null,213,"LAGOS DE MORENO-EL PUESTO-LA TROJE",51,"0+000 AL 9+500","BACHEO SUPERFICIAL AISLADO","LAGOS DE MORENO",9.5,2.85]
[null,214,"LA RESURRECCIÓN-EL DESTIERRO-BETULIA",44.3,"0+000 AL 11+500\n21+000 AL 44+000","BACHEO SUPERFICIAL AISLADO","ENCARNACIÓN DE DÍAZ",{"$f":"11.5+23","v":34.5},10.35]
[null,215,"EL LLANO-TEOCALTICHE.",35.299999999999997,"0+000 AL 12+000\n35+000 AL 35+300","CALAVEREO Y BACHEO SUPERFICIAL AISLADO\nMARCAS SOBRE EL PAVIMENTO ","JALOSTOTITLÁN \nTEOCALTICHE",12.3,3.69]
[null,216,"LAS LIEBRES - MECHOACANEJO.",2.2999999999999998,"0+000 AL 2+000","CALAVEREO Y BACHEO SUPERFICIAL AISLADO","TEOCALTICHE",2,0.6]
[null,218,"SAN JUAN DE LOS LAGOS - ENCARNACIÓN DE DIAZ",25.4,"0+000 AL 16+000","CALAVEREO Y BACHEO SUPERFICIAL AISLADO                                               ","ENCARNACIÓN DE DÍAZ",16,4.8]
[null,225,"YAHUALICA-HUISQUILCO",10.9,"7+000 AL 10+900","BACHEO SUPERFICIAL AISLADO","YAHUALICA DE GONZÁLEZ GALLO",3.9,1.17]
[null,232,"TECUAN-EL PUESTO",9.8000000000000007,"0+000 AL 9+800","CALAVEREO Y BACHEO SUPERFICIAL AISLADO                                               ","ENCARNACIÓN DE DÍAZ\n LAGOS DE MORENO",9.8000000000000007,2.94]
[null,233,"LIBRAMIENTO TEOCALTICHE",9.0990000000000002,"0+000 AL 9+099","DESMONTE A MANO                                                               LIMPIEZA DE LA SUPERFICIE DE RODAMIENTO                                     LIMPIEZA DE CUNETAS                                                                  LIMPIEZA DE ALCANTARILLA                                                           LIMPIEZA DE BANQUETAS                                                            RECOGER SELLO RECICLADO                                                      MARCAS SOBRE EL PAVIMENTO                                                                                                                                                                                   BACHEO SUPERFICIAL AISLADO","TEOCALTICHE",9.0990000000000002,2.7296999999999998]
[null,236,"PALOS ALTOS-SAN JOSÉ-EL CUATRO",13.2,"0+000 AL 13+200","DESMONTE A MANO\nDESMONTE A MAQUINA","IXTLAHUACÁN DEL RÍO \nCUQUÍO",13.2,3.9599999999999995]
[null,237,"VILLA HIDALGO-SAN JUANICO-LAS FLORES",27,"0+000 AL 17+000","CALAVEREO Y BACHEO SUPERFICIAL AISLADO","VILLA HIDALGO",17,5.0999999999999996]
[null,238,"SAN ISIDRO ENTRONQUE CARRETERO YAHUALICA-HUISQUILCO",3.54,"0+000 AL 3+500","BACHEO SUPERFICIAL AISLADO","YAHUALICA DE GONZÁLEZ GALLO",3.5,1.05]
[null,240,"TEPONAHUASCO-TEPOZAN-EL CUATRO",12,"0+000 AL 9+400\n9+500 AL 12+000","BACHEO SUPERFICIAL AISLADO\nDESMONTE A MÁQUINA                                                    SUPERVISIÓN A CONSTRUCTORA SIVA, S. A. DE C. V.     ","CUQUIO",11.9,3.57]
[null,241,"ENTRONQUE CARRETERO 225.-EL DURAZNO",2.4500000000000002,"0+000 AL 2+450","BACHEO SUPERFICIAL AISLADO","YAHUALICA DE GONZÁLEZ GALLO",2.4500000000000002,0.73499999999999999]
[null,307,"ATOTONILCO SAN MIGUEL SAN JUAN",95.7,"112+000 AL 115+300\n 115+504 AL 123+500\n124+000 AL 124+700","BACHEO SUPERFICIAL AISLADO","SAN JUAN DE LOS LAGOS",{"$f":"(115.3-112)+(123.5-115.504)+0.7","v":11.995999999999992},3.5987999999999971]
[null,"S/C","BAJÍO DE SAN JOSÉ COYOTES LIMITE DE ESTADO",null,"17+800 AL 21+300                                                      22+000 AL 24+000","BACHEO SUPERFICIAL AISLADO","ENCARNACIÓN DE DÍAZ",5.5,1.65]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H11:H31)","v":242.78299999999996},{"$f":"SUM(I11:I31)","v":72.83489999999999}]

{"sheet":"San Miguel","index":2,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,0,8,8]]}
{"$rows_empty":8}
["REPORTE DE ACTIVIDADES RESIDENCIA SAN MIGUEL"]
[]
["DICIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS TRAMOS AISLADOS"]
[null,302,"LAGOS DE MORENO-UNION DE SAN ANTONIO-SAN DIEGO DE A.",41.7,"DEL KM. 37+000 AL KM. 41+700","BACHEO Y/O CALAVEREO EN CARPETA ASFALTICA CON MEZCLA FRIA","SAN DIEGO DE ALEJANDRIA",4.7000000000000028,2.3500000000000014]
[null,306,"SAN JUAN DE LOS LAGOS - MEZQUITIC",3.3,"DEL KM. 0+000 AL KM. 2+100","TRABAJOS DE BACHEO  Y/O CALAVEREO EN CARPETA ASFÁLTICA","SAN JUAN DE LOS LAGOS",2.1,1.05]
[null,307,"ATOTONILCO - SAN MIGUEL EL ALTO - SAN JUAN DE LOS LAGOS",95.7,"DEL KM. 28+700 DEL KM. 30+000 \nDEL KM. 55+000 AL KM. 77+000\nDEL KM. 80+000 AL KM. 90+000\nDEL KM. 99+000 AL KM. 100+000","BACHEO Y/O CALAVEREO EN CARPETA ASFALTICA CON MEZCLA PREMIUM, TRABAJOS DE SEÑALAMIENTO HORIZONTAL ","ATOTONILCO EL ALTO, ARANDAS\nSAN MIGUEL EL ALTO \nSAN JUAN DE LOS LAGOS ",{"$f":"13.3+11","v":24.3},12.15]
[null,311,"VALLE DE GPE. SAN MIGUEL EL ALTO (LA LLAVE)",20.7,"DEL KM. 18+000 AL KM. 19+000","BACHEO Y/O CALAVEREO EN CARPETA ASFALTICA CON MEZCLA FRIA","SAN MIGUEL EL ALTO   ",1,0.5]
[null,314,"TEPATITLAN - ARANDAS - LIM. DE EDO.",97.1," KM. 0+200 L/D\nKM. 17+000 L/IZQ. COLOCACION DE SEÑALAMIENTO \nDEL KM. 16+000 DEL KM. 42+000\nDEL KM. 51+000 AL KM. 73+000\nDEL KM. 78+000 AL KM. 80+000 \nDEL KM. 94+000 AL KM. 97+100","\nTRABAJOS DE DESMONTE Y DESHIERBE DEL DERECHO DE VIABACHEO Y/O CALAVEREO EN CARPETA ASFALTICA Y RIEGO DE SELLO\nCOLOCACION DE SEÑALAMIENTO VERTICAL ","SAN IGNACIO CEDRRO GORDO\nTEPATITLAN DE MORELOS  \nJESÚS MARÍA\nARANDAS",{"$f":"28+3.1+22","v":53.1},26.55]
[null,317,"ENT. CARR. MEX. 80 - MILPILLAS",8.5,"DEL KM. 0+000 AL KM.5+000","RENIVELACIONES EN CARPETA ASFALTICA, BACHEO Y/O CALAVEREO EN CARPETA ASFALTICA CON MEZCLA EN FRIO\nTRABAJOS DE DESMONTE Y DESHIERBE DEL DERECHO DE VIA","ACATIC\nTEPATITLÁN DE MORELOS",5,2.5]
[null,321,"ENT. CARR. 314.- JOSEFINO DE ALLENDE",null,"DEL KM. 0+000 AL KM. 2+200\nDEL KM. 2+500 AL KM. 5+400","BACHEO Y/O CALAVEREO EN CARPETA ASFALTICA CON MEZCLA PREMIUM","TEPATITLAN DE MORELOS\nJESUS MARIA ",{"$f":"2.2+2.9","v":5.0999999999999996},2.5499999999999998]
[null,323,"ARANDAS - MARTINEZ VALADEZ",46,"DEL KM. 2+000 AL KM. 4+000\nDEL KM. 4+500 AL KM. 6+900\nDEL KM. 9+700 AL KM. 9+708\nDEL KM. 9+755 AL KM. 9+775\nDEL KM. 9+780 AL KM. 9+784\nDEL KM. 9+800 AL KM. 9+805\nDEL KM. 10+000 AL KM. 15+000 \nDEL KM. 42+000 AL KM. 42+040","RENIVELACIONES EN CARPETA ASFALTICA, BACHEO Y/O CALAVEREO EN CARPETA ASFALTICA CON MEZCLA EN FRIO\nTRABAJOS DE PUNTEO DE RAYA CENTRAL Y DESMONTE DEL DERECHO DE VIA\nRIEGO DE SELLO 3-A PREMEZCLADO ","ARANDAS",{"$f":"2+(6.9-4.5)+0.008+0.02+0.004+0.005+5+0.04","v":9.4769999999999985},4.7384999999999993]
[null,326,"TEPATITLAN-SN. JOSE DE GRACIA-SN. FCO. DE ASIS-ATOTONILCO",42,"DEL KM. 1+000 AL KM. 1+600 ","BACHEO Y/O CALAVEREO EN CARPETA ASFALTICA CON MEZCLA FRIA","TEPATITLAN DE MORELOS ",0.6,0.3]
[null,328,"ENT. CARR. 314.- ARANDAS (INGRESO ORIENTE)",1.7,"DEL KM. 0+000 AL KM. 1+700","TRABAJOS DE BACHEO Y/O CALAVEREO EN CAREPTA ASFALTICA","ARANDAS",1.7,1.7]
[null,337,"ENT. CARR. MEX. 80.- CAÑADAS DE OBREGON",18.399999999999999,"DEL KM. 2+000 AL KM. 6+300","BACHEO Y/O CALAVEREO EN CARPETA ASFALTICA CON MEZCLA PREMIUM","VALLE DE GUADALUPE \nCAÑADAS DE OBREGÓN",4.3,2.15]
[null,338,"CAÑADAS DE OBREGON - TEMACAPULIN",8.9,"DEL KM. 2+000 AL KM. 7+000\nDEL KM. 0+000 AL KM. 0+250","TRABAJOS DE BACHEO Y/O CALAVEREO, TRABAJOS DE BACHEO DE CAJA, DESMONTE Y DESHIERBE DEL DERECHO DE VIA","CAÑADAS DE OBREGON",5.25,2.625]
[null,350,"LIBRAMIENTO NORTE DE ARANDAS",6.5,"DEL KM. 0+400 L/DER. \nKM. 6+000 L/IZQ. COLOCACION DE SEÑALAMIENTO","COLOCACION DE SEÑALAMIENTO VERTICAL ","ARANDAS"]
[null,356,"LIB. NORTE ATOTONILCO",10,"DEL KM. 0+000 AL KM. 0+400","TRABAJOS DE SEÑALAMIENTO HORIZONTAL ","ATOTONILCO EL ALTO",0.4,0.4]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H13:H26)","v":117.027},{"$f":"SUM(I13:I26)","v":59.563499999999998}]

{"sheet":"Sayula","index":3,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,0,8,8]]}
{"$rows_empty":8}
["REPORTE DE ACTIVIDADES RESIDENCIA SAYULA"]
[]
["DICIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS TRAMOS AISLADOS"]
[null,401,"ACATLAN DE J. - CD GUZMAN",91,"0+000 AL 4+540\n42+000 AL 72+500","DESMONTE\n BACHEO \nRETIRO SEÑALAM. DAÑADO","ACATLAN DE JUÁREZ\n AMACUECA\nSAYULA \nTECHALUTA DE MONTENEGRO",{"$f":"72.5-42+4.54","v":35.04},17.52]
[null,404,"EL ZAPOTE - TEOCUITATLAN",18.600000000000001,"15+000 AL 16+800","DESMONTE   ","TEOCUITATLAN",1.8,0.9]
[null,408,"USMAJAC -  AUTOPISTA (GDL - COL - MANZ.)",2.6,"0+000 AL 2+600","BACHEO SUPERFICIAL","SAYULA",2.6,1.3]
[null,425,"EL JAZMIN - ZAPOTITLAN DE V.",22.5,"7+500","REPARACION DE DESLAVE","TOLIMAN",null,0]
[null,427,"SAN GABRIEL - ENTR. CARR. TOLIMAN",21.6,"4+000 AL 6+000\n12+800 AL 20+200","BACHEO","SAN GABRIEL\nTOLIMAN",9.3999999999999986,4.6999999999999993]
[null,428,"TONAYA - CD GUZMAN",68.772999999999996,"101+500 AL 104+000\n107+500 AL 108+ 100","BACHEO","ZAPTLÁN EL GRANDE",{"$f":"0.6+2.5","v":3.1},1.55]
[null,432,"SAYULA - SAN GABRIEL",43.6,"0+000 AL 1+500","ENTREGA Y ELABORACION DE MEZCLA ASFALTICA\nBACHEO SUPERFICIAL","SAYULA",1.5,0.75]
[null,433,"TAPALPA - SAN GABRIEL",35,"33+000 AL 35+000","BACHEO","SN GABRIEL",2,1]
[null,436,"ENTR. CARR. 401 - TAPALPA",32.5,"3+200 AL 3+700\n15+000 AL 16+500\n18+000 AL 29+500","DESMONTE \nBACHEO AISLADO","AMACUECA \nTAPALPA ",{"$f":"12+1.5","v":13.5},6.75]
[null,449,"TECALITLAN - JILOTLAN DE LOS D.",62.506999999999998,"TRANSITO","TRANSITO","TECALITLÁN \nSAYULA",null,0]
[null,466,"ZAPOTLAN - ATEQUIZAYAN",8.69,"0+000 AL 5+400","BACHEO SUPERFICIAL","ZAPTLÁN EL GRANDE",5.4,2.7]
[null,467,"EL BALASTRE -- EL GUAYABO",42.38,"0+000 AL 22+000","SUPERVISION DE TRABAJO EMPRESA","PIHUAMO",22,11]
[null,472,"ENTR. CARR. TOLIMAN  - CUAUHTEMOC",1.2,"0+000 AL 1+200","BACHEO","TOLIMAN",1.2,0.6]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H13:H25)","v":97.54},{"$f":"SUM(I13:I25)","v":48.77}]

{"sheet":"Autlán","index":4,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[8,0,8,8]]}
{"$rows_empty":8}
["REPORTE DE ACTIVIDADES RESIDENCIA AUTLÁN"]
[]
["DICIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS TRAMOS AISLADOS"]
[null,504,"EL LIMÓN - LA CIENEGA - SAN MIGUEL",9,"KM 1+900 AL KM 7+000","DESMONTE","EL LIMÓN",{"$f":"7-1.9","v":5.0999999999999996},1.5299999999999998]
[null,505,"EL PINAL-LA CONCHA-CUAUTITLAN DE G.B.",23.7,"KM 0+000 AL KM 21+500","DESMONTE"," LA HUERTA \nCUAUTITLÁN DE GARCÍA BARRAGÁN",21.5,6.45]
[null,508,"LIBRAMIENTO AUTLÁN",4.5999999999999996,"KM 0+850 AL KM 2+600\nKM 3+200 AL KM 4+020","DESMONTE","AUTLÁN",{"$f":"1.75+0.82","v":2.57},0.77099999999999991]
[null,510,"ENTR. CARR. MEX. 80.- PURIFICACIÓN",21.1,"KM 0+000 AL KM 21+100","DESMONTE","CASIMIRO CASTILLO\nVILLA PURIFICACIÓN",21.1,6.33]
[null,513,"PUENTE CORCOVADO - TONAYA",39.6,"KM 0+000 AL KM 39+000","DESMONTE Y BALIZAMIENTO HORIZTAL.","EL GRULLO\nEL LIMÓN\nTONAYA",39,11.7]
[null,522,"ENTR. CARR. MEX. 200 - BOCA DE LAS IGUANAS",3,"KM 0+000 AL KM 3+000","BALIZAMIENTO","CIHUATLÁN",3,0.89999999999999991]
[null,526,"SAN CLEMENTE - AYUTLA - LA CAMPANA",61.2,"KM 15+000 AL KM 17+300","BALIZAMIENTO HORIZONTAL\nDESMONTE","UNIÓN DE TULA\n AYUTLA\n CUAUTLA\n ATENGUILLO",2.2999999999999998,0.69]
[null,529,"TECOLOTLÁN-TENAMAXTLÁN-SOYATLÁN DEL ORO",33.9,"KM 0+000 AL KM 23+000","CONSTRUC. DE MUROS DE MAMPOSTERÍA\nBALIZAMIENTO EN TOPES\nDESMONTE","TECOLOTLÁN\nTENAMAXTLÁN\nATENGO",23,6.8999999999999995]
[null,530,"UNIÓN DE TULA - EJUTLA",19.2,"KM 0+000 AL KM 19+200","BALIZAMIENTO","UNIÓN DE TULA \nEJUTLA",19.2,5.76]
[null,531,"EL GRULLO - EJUTLA",14.6,"KM 0+000 AL KM 14+600","BACHEO","EL GRULLO \nEJUTLA",14.6,4.38]
[null,532,"JUCHITLÁN - LOS GUAJES",10,"KM 0+000 AL KM 10+000","BALIZAMIENTO","JUCHITLÁN",10,3]
[null,536,"LAS PAREDES - EL CHANTE",9.3699999999999992,"KM 4+200 AL KM 5+100","DESMONTE","AUTLÁN",0.89999999999999947,0.26999999999999985]
[null,540,"ENTR. CARR. MEX. 200.- LA MANZANILLA",1.3,"KM 0+000 AL KM 1+300","BALIZAMIENTO HORIZONTAL","LA HUERTA",1.3,0.39]
[null,541,"ENTR. CARR. MEX. 200.- TENACATITA",9,"KM 0+000 AL KM 3+000","BALIZAMIENTO","LA HUERTA",3,0.89999999999999991]
[null,542,"ENTR. CARR. MEX. 200.- PUNTA PERULA",3,"KM 2+200 AL KM 3+000","BALIZAMIENTO HORIZONTAL","LA HUERTA",0.8,0.24]
[null,543,"AYUTLA - TEPANTLA",6,"KM 0+000 AL KM 6+000","BALIZAMIENTO","AYUTLA",6,1.7999999999999998]
[null,544,"MASCOTA-LA ESTANCIA-LAS PALMAS-LAS JUNTAS",91.3,"KM 16+000 AL KM 56+000","BACHEO\nDESMONTE Y REMOCIÓN DE DERRUMBES","MASCOTA\n SAN SEBASTÍAN DEL OESTE\n PUERTO VALLARTA.",{"$f":"56-16","v":40},12]
[null,554,"VILLA PURIFICACIÓN-CHAMELA",66,"KM 0+000 AL KM 5+200\nKM 28+000 AL KM 45+000","BACHEO","VILLA PURIFICACIÓN\nLA HUERTA",{"$f":"5.2+17","v":22.2},6.6599999999999993]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H13:H30)","v":235.57000000000002},{"$f":"SUM(I13:I30)","v":70.670999999999992}]

{"sheet":"Ahualulco","index":5,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[8,0,8,8]]}
{"$rows_empty":8}
["REPORTE DE ACTIVIDADES RESIDENCIA AHUALULCO"]
[]
["DICIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS TRAMOS AISLADOS"]
[null,601,"TALA - STA. CRUZ DE LAS FLORES",35,"DEL KM 0+000 AL KM 14+000","BACHEO Y CALAVEREO","TALA\nTLAJOMULLCO DE ZUÑIGA",14,{"$f":"H13*0.5","v":7}]
[null,602,"EL AMARILLO - LA VEGA",8.9,"DEL KM 0+000 AL KM 1+000\nDEL KM 4+500 AL KM 7+360","DESMONTE EN EL DERECHO DE VIA","TEUCHITLAN",3.86,{"$f":"H14*0.5","v":1.93}]
[null,604,"EL REFUGIO - SAN MARCOS",53.7,"DEL KM 24+000+000 AL KM 53+700","DESMONTE EN EL DERECHO DE VIA, BACHEO Y CALAVEREO","AHUALULCO\n SAN JUANITO DE ESCOBEDO\nETZATLAN\nSAN MARCOS",{"$f":"53.7-24","v":29.700000000000003},14.850000000000001]
[null,608,"AHUALULCO - AMECA",30.6,"DEL KM 23+900 AL KM 29+000","DESMONTE EN EL DERECHO DE VIA","AHUALULCO\nAMECA",5.1000000000000014,2.5500000000000007]
[null,611,"ENTR. CARR. (GUAD.-AMECA) - CUISILLOS",1.7,"DEL KM 0+000 AL KM 1+700","BACHEO Y CALAVEREO","TALA",1.7,1.7]
[null,617,"ENTR. CARR. (GUAD.-AMECA) - HUAXTLA - STA. CRUZ DEL ASTILLERO",4.8600000000000003,"DEL KM 0+000 AL KM 4+860","BACHEO Y CALAVEREO","AMATITAN",4.8600000000000003,2.4300000000000002]
[null,618,"CRUC. STA. MARIA - SN. MARTIN HGO. - AMECA",23.1,"DEL KM 0+000 AL KM 23+100","DESMONTE EN EL DERECHO DE VIA\nBACHEO Y CALAVEREO","SAN MARTIN HIDALGO\nAMECA",23.1,11.55]
[null,619,"SN. MARTIN HGO. - STA. CRUZ DE LAS FLORES",3.6,"DEL KM 0+050 AL KM 0+636","BACHEO PROFUNDO AISLADO (RENIVELACIÓN), DESAZOLVE DE CUNETAS","SAN MARTIN HIDALGO",0.63600000000000001,0.318]
[null,620,"ENTR. CARR. (AMECA-MASCOTA) - GUACHINANGO",7.5,"DEL KM 0+000 AL KM 7+500","BACHEO Y CALAVEREO","GUACHINANGO",7.5,3.75]
[null,621,"LA COFRADIA - LA SAUCEDA - BUENAVISTA",22.2,"DEL KM 0+000 AL KM 22+000","BACHEO Y CALAVEREO","VILLA CORONA\nSAN MARTIN HIDALGO\nAMECA",22,11]
[null,623,"LA NORIA - ESTIPAC - ATOTONILCO EL BAJO",11.1,"DEL KM 0+000 AL KM 11+100","BACHEO Y CALAVEREO","VILLA CORONA",11.1,5.55]
[null,626,"AHUALULCO - SAN IGNACIO - EL CARMEN",9,"DEL KM 0+000 AL KM 9+000","BACHEO Y CALAVEREO","AHUALULCO",9,4.5]
[null,632,"SAN MARCOS - LIMITE DE ESTADOS",10.4,"DEL KM 2+000 AL KM 6+500","BACHEO Y CALAVEREO","SAN MARCOS",4.5,2.25]
[null,634,"ENTR. CARR. (GUAD.-AMECA) - PUERTA DE LA VEGA",6,"DEL KM 0+000 AL KM 5+600","BACHEO Y CALAVEREO","AMECA\nTEUCHITLAN",5.6,2.8]
[null,637,"INGRESO NORTE AMECA",1.1000000000000001,"DEL KM 0+000 AL KM 1+100","BACHEO Y CALAVEREO","AMECA",1.1000000000000001,0.71]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H13:H27)","v":143.75599999999997},{"$f":"SUM(I13:I27)","v":72.887999999999991}]

{"sheet":"Villa Guerrero","index":6,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[10,0,10,7]]}
{"$rows_empty":10}
["REPORTE DE ACTIVIDADES RESIDENCIA VILLA GUERRERO"]
[]
["DICIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS TRAMOS AISLADOS"]
[null,701,"ENT.CARR.FED.MEX.23-VILLA GUERRERO",38.646000000000001,"DEL KM 0+000 AL KM 38+400","DESHIERBE, COLOCACION DE SEÑALAMIENTO Y PINTADO DE TOPES","COLOTLAN\nTOTATICHE\nVILLA GUERRERO",38.4]
[null,702,"VILLA GUERRERO-SAN MARTIN DE BOLAÑOS",62.15,"DEL KM 1+300 AL KM 7+000 \n DEL KM 49+200 AL KM 52+200","DESHIERBE Y DESMONTE","VILLA GUERRERO\nCHIMALTITAN",11.3]
[null,704,"ENT.CARR.JAL.701-TEMASTIAN",2.0099999999999998,"DEL KM 0+300 AL KM 0+500","PINTADO DE TOPES","TOTATICHE",0.2]
[null,705,"MONTE ESCOBEDO-MEZQUITIC",22.33,"DEL KM 18+860 AL KM 19+400","PINTADO DE PUENTES, TOPES Y RAYAS LOGARITMICAS","MEZQUITIC",0.53999999999999915]
[null,706,"HUEJUQUILLA-MEZQUITIC",27.8,"EN LOS KMS 0+300 \n25+000\n 34+200\n 41+100\nDEL KM 41+200 AL KM 42+000","PINTADO DE PUENTES\nDESHIERBE","MEZQUITIC\nHUEJUQUILLA",0.8]
[null,707,"HUEJUQUILLA-VALPARAISO",20.7,"EN LOS KMS 0+300\n3+300\n 7+200\nDEL KM 19+000 AL KM 19+300","PINTADO DE PUENTES\nRAYAS LOGARITMICAS","HUEJUQUILLA EL ALTO",0.3]
[null,711,"BOLAÑOS-TENZOMPA-HUEJUQUILLA",130.59299999999999,"DEL KM  38+900 AL KM 41+100","BACHEO SUPERFICIAL  ","BOLAÑOS",2.2000000000000028]
[null,712,"HUEJUCAR-MONTE ESCOBEDO",21.96,"DEL KM 1+400 AL KM 1+700\nDEL KM  16+000 AL KM 17+000","DESHIERBE Y PINTADO DE PUENTES","HUEJUCAR",1.3]
[null,718,"MEZQUITIC-NOSTIC",11.206," EN EL KM 5+500 \nDEL KM 7+800 AL KM 8+006","PINTADO DE PUENTES, BACHEO SUPERFICIAL Y DESHIERBE","MEZQUITIC",0.20600000000000041]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H15:H23)","v":55.246000000000002}]

{"sheet":"Resumen por Residencia","index":7,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,2,3,6],[4,2,7,6],[9,0,9,6],[12,2,12,5]]}
[]
[null,null,"S E C R E T A R I A   D E   I N F R A E S T R U C T U R A   Y   O B R A   P Ú B L I C A"]
[]
[]
[null,null,"D I R E C C I Ó N   G E N E R A L   D E  I N F R A E S T R U C T U R A   C A R R E T E R A"]
{"$rows_empty":7}
[null,null,"AVANCES MIDE POR RESIDENCIA DICIEMBRE 2017"]
[]
[]
[]
[]
[]
[null,null,"RESIDENCIA","TOTAL DE CAMINOS ATENDIDOS","TOTAL KM CONSERVADOS","TOTAL KM CONSERVADOS"]
[null,null,"GUADALAJARA",13,{"$f":"Guadalajara!I26","v":46.8},{"$f":"Guadalajara!I26","v":46.8}]
[null,null,"TEOCALTICHE",21,{"$f":"Teocaltiche!I32","v":72.83489999999999},{"$f":"Teocaltiche!I32","v":72.83489999999999}]
[null,null,"SAN MIGUEL",14,{"$f":"'San Miguel'!I27","v":59.563499999999998},{"$f":"'San Miguel'!I27","v":59.563499999999998}]
[null,null,"SAYULA",13,{"$f":"Sayula!I26","v":48.77},{"$f":"Sayula!I26","v":48.77}]
[null,null,"AUTLÁN",18,{"$f":"Autlán!I31","v":70.670999999999992},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"AHUALULCO",15,{"$f":"Ahualulco!I28","v":72.887999999999991},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"VILLA GUERRERO",9,{"$f":"'Villa Guerrero'!H24","v":55.246000000000002},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"TOTAL",{"$f":"SUM(D20:D26)","v":103},{"$f":"SUM(E20:E26)","v":426.77339999999998},{"$f":"SUM(F20:F26)","v":{"$error":"#REF!"}}]

{"sheet":"Resumen Global","index":8,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,3,40,4],[12,3,12,7],[1,3,3,8],[4,3,7,8],[9,1,9,8],[35,3,35,4],[39,3,39,4]]}
[]
[null,null,null,"S E C R E T A R I A   D E   I N F R A E S T R U C T U R A   Y   O B R A   P Ú B L I C A"]
[]
[]
[null,null,null,"D I R E C C I Ó N   G E N E R A L   D E  I N F R A E S T R U C T U R A   C A R R E T E R A"]
{"$rows_empty":7}
[null,null,null,"AVANCES MIDE DICIEMBRE 2017"]
[]
[]
[]
[null,null,null,"RESIDENCIA","TOTAL DE CAMINOS ATENDIDOS EN EL MES DICIEMBRE","TOTAL KM. CONSERVADOS DICIEMBRE","TOTAL KM. CONSERVADOS ACUMULADOS","TOTAL KM. CONSERVADOS"]
[null,null,null,"GUADALAJARA, TEOCALTICHE, SAN MIGUEL, SAYULA, AUTLAN, AHUALULCO, VILLA GUERRERO.",{"$f":"'Resumen por Residencia'!D27","v":103},{"$f":"'Resumen por Residencia'!E27","v":426.77339999999998},4403.7019,{"$f":"'Resumen por Residencia'!F27","v":{"$error":"#REF!"}}]
{"$rows_empty":17}
[null,null,null,"ATENTAMENTE"]
[]
[]
[]
[null,null,null,"ING. ESAÚ FLORES ÁLVAREZ"]
[null,null,null,"DIRECTOR GENERAL DE INFRAESTRUCTURA CARRTERA."]