{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Guadalajara","Teocaltiche","San Miguel","Sayula","Ahualulco","Villa Guerrero","Resumen por Residencia","Resumen Global"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":24,"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":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[8,0,8,8],[11,1,11,8],[27,1,27,4]]}
{"$rows_empty":8}
["REPORTE DE ACTIVIDADES RESIDENCIA GUADALAJARA"]
[]
["NOVIEMBRE"]
[null,"CONSERVACIÓN RUTINARIA"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS (30%)"]
[null,102,"BUENAVISTA - TLAJOMULCO DE ZÚÑIGA",9,"0+400-6+800( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","TLAJOMULCO DE ZÚÑIGA",6.4,{"$f":"H14*0.3","v":1.92}]
[null,106,"COYULA - MATATLAN",17.399999999999999,"0+000-5+500( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","TONALÁ",5.5,{"$f":"H15*0.3","v":1.65}]
[null,107,"EL CAPULIN - EL SALTO DE JUANACATLAN",9.6,"12+500-21+200( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","EL SALTO",8.6999999999999993,2.61]
[null,113,"STA. CRUZ DE LAS FLORES-TLAJOMULCO DE ZUÑIGA-CUYUTLAN-CAJITITLAN",26.9,"1+000-0+200( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","TLAJOMULCO DE ZÚÑIGA",0.8,0.24]
[null,115,"LA CALERA - CAJITITLAN",6.5,"1+000-0+200( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","TLAJOMULCO DE ZÚÑIGA",0.8,0.24]
[null,122,"OCOTLAN - TOTOTLAN",25.5,"3+600-21+200( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","OCOTLÁN",{"$f":"21.2-3.6","v":17.599999999999998},5.2799999999999994]
[null,124,"PARQUE J. GUADALUPE MONTENEGRO - EL CASTILLO",12.4,"0+000+8+600( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","EL SALTO",8.6,2.5799999999999996]
[null,129,"PONCITLAN - ZAPOTLAN DEL REY",9.5,"0+000-2+200( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","ZAPOTLÁN DEL REY",2.2000000000000002,0.66]
[null,148,"SANTA ROSA - CHAPALA",16.399999999999999,"0+400-6+800( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","IXTLAHUACÁN DE LOS MEMBRILLOS",6.4,1.92]
[null,"S/C","NODO VIAL LIBRAMIENTO DE CHAPALA",1.5,"0+000-0+450( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","CHAPALA",0.45,0.13500000000000001]
[null,"S/C","PROLONGACION COLON",null,"0+200 - 1+000( TRAMOS AISLADOS) ","LIMPIEZA\nBACHEO SUPERFICIAL AISLADO/ MEZCLA EN CALIENTE","TLAJOMULCO DE ZÚÑIGA",0.8,0.24]
[{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$nulls":5},"TOTAL",{"$f":"SUM(H14:H24)","v":58.25},{"$f":"SUM(I14:I24)","v":17.475000000000001}]
[]
[]
[null,"CONSERVACIÓN  RUTINARIA"]
[null,"CODIGO.","CARRETERA","MUNICIPIO","KM POR ATENDER"]
[null,"108\n191\n121","CONSERVACIÓN RUTINARIA CÓD. 108 EC (LA BARCA - ATOTONILCO) - CONDIRO - CANALES, CAMINO CÓD. 191 OCOTLÁN - SAN MIGUEL DE LA PAZ - JAMAY, KM DEL 0+000 AL KM 8+000 Y DEL 11+000 AL KM 17+000, CAMINO CÓD. 121 OCOTLÁN - LA COMUNIDAD - LABOR VIEJA, EN OCOTLÁN, JAMAY Y LA BARCA.","OCOTLÁN\nJAMAY\nLA BARCA",14]
[null,null,null,"TOTAL",{"$f":"SUM(E27:E30)","v":14}]

{"sheet":"Teocaltiche","index":1,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,0,7,8]]}
{"$rows_empty":7}
["REPORTE DE ACTIVIDADES RESIDENCIA TEOCALTICHE"]
["NOVIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS (30%)"]
[null,201,"IXTLAHUACAN DEL RIO-CUQUIO-MANALISCO-YAHUALICA",59.5,"0+000 AL 15+450\n27+580 AL 28+100\n  40+000 AL 43+600\n59+400\n  59+200\n  57+500\n57+000\n56+000","BACHEO SUPERFICIAL AISLADO CON MEZCLA ELABORADA EN EL LUGAR\nRE INSTALACIÓN DE SEÑALAMIENTO VERTICAL AISLADO                             ","IXLAHUACAN DEL RIO\nCUQUIO\nYAHUALICA DE GONZÁLEZ GALLO",{"$f":"15.45+(28.1-27.58)+3.6","v":19.570000000000004},{"$f":"H11*0.3","v":5.8710000000000013}]
[null,202,"ENTRONQUE CARRETERO 201.-MANALISCO",1.9490000000000001,"0+100 \n 1+880","RE INSTALACIÓN DE SEÑALAMIENTO VERTICAL AISLADO","YAHUALICA DE GONZÁLEZ GALLO",null,{"$f":"H12*0.3","v":0}]
[null,205,"YAHUALICA-TEOCALTICHE-JARALILLO",96.2,"0+000 AL 23+860\n44+000 AL 53+314    \n59+000 AL 96+000 (TRAMOS AISLADOS)             \n 1+600 \n 53+000                                                                                                                                                                                                                              ","LIMPIEZA Y PERFILA DE CORONA\nLIMPIEZA DE CUNETAS                                                                                                                                                                                                                                  SALIDA DE CUNETAS     \nHOMOGENEIZAR MATERIAL PARA ELAB. DE MEZCLA  ELABORACIÓN DE MEZCLA ASFÁLTICA EN EL LUGAR                                                                                                                                                                                                             RE INSTALACIÓN DE SEÑALAMIENTO                                                      CRIBAR MATERIAL PARA BASE\nBACHEO SUPERFICIAL AISLADO CON BASE                                                                                                                               BACHEO SUPERFICIAL AISLADO CON MEZCLA EN EL LUGAR\nBACHEO SUPERFICIAL CON CEMENTANTE   ","YAHUALICA DE GONZÁLEZ GALLO, TEOCALTICHE \nENCARNACION DE DIAZ\n  MEXTICACAN",{"$f":"23.86+(53.314-44)+(96-59)","v":70.174000000000007},21.052200000000003]
[null,207,"MEXTICACAN-CAÑADAS DE OBREGÓN",16.899999999999999,"4+600 AL 16+500","BACHEO SUPERFICIAL AISLADO","MEXTICACAN",11.9,3.57]
[null,211,"TEOCALTICHE-VILLA HIDALGO",26.6,"0+000 AL 17+300 (TRAMOS AISLADDOS)\n","DESMONTE A MANO                                                                                                                                    BACHEO SUPERFICIAL AISLADO CON MEZCLA       \nPINTURA DE RAYA CENTRAL                                   ","TEOCALTICHE\n VILLA HIDALGO",17.3,5.19]
[null,212,"ENCARNACIÓN DE DÍAZ-SAN SEBASTIÁN-EL TERRERO.",35.5,"0+000 AL 12+000","BACHEO SUPERFICIAL AISLADO CON BASE","ENCARNACION DE DIAZ",12,3.5999999999999996]
[null,213,"LAGOS DE MORENO-EL PUESTO-LA TROJE",51,"0+000 AL 2+000\n9+000 AL 12+000","BACHEO SUPERFICIAL AISLADO CON BASE","LAGOS DE MORENO",5,1.5]
[null,214,"LA RESURRECCIÓN-EL DESTIERRO-BETULIA",44.3,"0+000 AL 13+500","BACHEO SUPERFICIAL AISLADO CON MEZCLA                        BACHEO SUPERFICIAL AISLADO CON TEPETATE                               ","ENCARNACION DE DIAZ",13.5,4.05]
[null,215,"EL LLANO-TEOCALTICHE.",35.299999999999997,"8+000 AL 14+500 \n16+000 AL 35+300 (TRAMOS AISLADO)                                                    ","BACHEO SUPERFICIAL AISLADO CON TEPETATE                                                                                                             EXTRACCIÓN DE MATERIAL DE MALA CALIDAD                                                                                                                                                                                                                BACHEO SUPERFICIAL AISLADO                                                      BACHEO PROFUNDO AISLADO                                                                ","JALOSTOTITLAN\nTEOCALTICHE",{"$f":"6.5+(35.3-16)","v":25.799999999999997},7.7399999999999984]
[null,225,"YAHUALICA-HUISQUILCO",10.9,"1+300","RE INSTALACIÓN DE SEÑALAMIENTO VERTICAL AISLADO","YAHUALICA DE GONZÁLEZ GALLO",null,0]
[null,233,"LIBRAMIENTO TEOCALTICHE",9.0990000000000002,"0+000 AL 9+099 (TRAMOS AISLADOS)                                  ","DESMONTE A MANO\nLIMPIEZA DE LA SUPERFICIE DE RODAMIENTO                                BACHEO SUPERFICIAL AISLADO CON MEZCLA EN EL LUGAR REPOSICIÓN DE MARCAS SOBRE EL PAVIMENTO (ISLETAS)      \nREPOSICIÓN DE MARCAS SOBRE EL PAVIMENTO  ( FRANJAS LOGARITMICAS )                                                PINTURA DE RAYA CENTRAL","TEOCALTICHE",9.0990000000000002,2.7296999999999998]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H11:H21)","v":184.34300000000002},{"$f":"SUM(I11:I21)","v":55.302900000000001}]

{"sheet":"San Miguel","index":2,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[8,0,8,8],[11,1,11,8]]}
{"$rows_empty":8}
["REPORTE DE ACTIVIDADES RESIDENCIA SAN MIGUEL"]
[]
["NOVIEMBRE"]
[null,"CONSERVACIÓN RUTINARIA"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS (30%)"]
[null,304,"JALOSTOTITLAN-SN. MIGUEL-SN. JULIAN-SN. DIEGO DE A. - LIM.EDO.",75,"DEL KM. 17+500 AL KM. 17+100\nDEL KM. 20+000 AL KM. 25+000\nDEL KM. 62+000 AL KM. 65+500\nDEL KM. 68+000 AL KM. 73+300 ","TRABAJOS DE BACHEO Y/O CALAVEREO CON MEZCLA ASFALTICA (ELABORADA CON MATERIAL RECICLADO)  Y TEPETATE \nTRABAJOS DE BACHEO Y/O CALAVEREO CON MEZCLA ASFALTICA CALIENTE (PROPORCIONADA POR EL H. AYUNTAMIENTO DE SAN DIEGO DE A.","SAN MIGUEL EL ALTO\nSAN DIEGO DE ALEJANDRIA",{"$f":"0.4+5+3.5+5.3","v":14.2},{"$f":"H14*0.3","v":4.26}]
[null,307,"ATOTONILCO - SAN MIGUEL EL ALTO - SAN JUAN DE LOS LAGOS",95.7,"EN EL KM. 29+500\nDEL KM. 47+500 AL KM. 91+000 \n","TRABAJOS DE BACHEO CON MATERIAL TEPETATE\nTRABAJOS DE REMOCION DE MATERIAL PRODUCTO DE DERRUMBES\nTRABAJOS DE BACHEO Y/O CALAVEREO CON TEPETATE Y MEZCLA ASFALTICA","ARANDAS\nSAN MIGUEL EL ALTO\nATOTONILCO EL ALTO",{"$f":"91-47.5","v":43.5},{"$f":"H15*0.3","v":13.049999999999999}]
[null,314,"TEPATITLAN - ARANDAS - LIM. DE EDO.",97.1," DEL KM. 3+000 AL KM. 7+000 \nDEL KM. 15+500 AL KM. 25+000\nPLATAFORMA KM. 27+000 \nDEL KM. 26+000 AL KM. 42+800\n DEL KM. 60+000 AL KM. 60+200 \nDEL KM. 62+000 AL KM. 62+600 \nDEL KM. 68+000 AL KM. 85+000","TRABAJOS DE BACHEO Y/O CALAVEREO CON MEZCLA ASFALTICA (ELABORADA CON MATERIAL RECICLADO) \nTRABAJOS DE BACHEO CON TEPETATE Y MEZCLA ASFALTICA","SAN IGNACIO CERRO GORDO\nTEPATITLÁN DE MORELOS\n ARANDAS\n JESÚS MARÍA",{"$f":"4+9.5+(42.8-26)+0.2+0.6+(85-68)","v":48.099999999999994},14.429999999999998]
[null,326,"TEPATITLAN-SN. JOSE DE GRACIA-SN. FCO. DE ASIS-ATOTONILCO",42,"DEL KM. 29+000 AL KM. 32+000","TRABAJOS DE RENIVELACIONES SOBRE CARPETA ASFÁLTICA CON MATERIAL TEPETATE","ATOTONILCO EL ALTO",3,0.89999999999999991]
[null,349,"LIBRAMIENTO SUR TEPATITLAN",7,"DEL KM. 0+000 AL KM. 2+500\nDEL KM. 13+000 AL KM. 17+000 ","TRABAJOS DE BACHEO Y/O CALAVEREO CON MEZCLA ASFALTICA (ELABROADA CON MATERIAL RECICLADO","TEPATITLÁN DE MORELOS",6.5,1.95]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H14:H18)","v":115.3},{"$f":"SUM(I14:I18)","v":34.589999999999996}]

{"sheet":"Sayula","index":3,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[8,0,8,8],[11,1,11,8]]}
{"$rows_empty":8}
["REPORTE DE ACTIVIDADES RESIDENCIA SAYULA"]
[]
["NOVIEMBRE"]
[null,"CONSERVACIÓN RUTINARIA"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS (30%)"]
[null,401,"ACATLAN - CD GUZMAN",91,"2+900 AL 15+000\n33+000 AL 33+900\n62+000 AL 88+000","BACHEO\n DESMONTE","ACATLAN DE JUÁREZ\n ZACOALCO DE TORRES\n  SAYULA\nGÓMEZ FARÍAS ",39,{"$f":"H14*0.3","v":11.7}]
[null,417,"INGRESO SUR A CD GUZMAN",5.0999999999999996,"0+000 AL 5+100","BACHEO","ZAPOTLÁN EL GRANDE",5.0999999999999996,{"$f":"H15*0.3","v":1.5299999999999998}]
[null,432,"SAYULA - SAN GABRIEL",43.6,"0+000 AL 1+500\n4+000 AL 4+600","ENTREGA DE MEZCLA Y EMULSION \nELABORACION DE MEZCLA\nDESMONTE","SAYULA  ",2.1,0.63]
[null,435,"ATEMAJAC - LA FRONTERA - LAGUNILLAS",41.5,"44+900 AL 45+500","BACHEO","TAPALPA",0.6,0.18]
[null,436,"ENTR. CARR. 401 - TAPALPA",32.5,"0+000 AL 0+500","DESMONTE","AMACUECA",0.5,0.15]
[null,437,"CATARINA - SANTA CLARA - ATEMAJAC",34.200000000000003,"27+200 AL 34+000","BACHEO","ATEMAJAC DE BRIZUELA",6.8000000000000007,2.04]
[null,465,"LIBRAMIENTO DE ZAPOTILTIC",5.0430000000000001,"0+600 AL 4+000","BACHEO","ZAPOTILTIC",3.4,1.02]
[null,"MEX. 110","CARR FEDERAL ZONA URBANA TAMAZULA",2,"0+000 AL 2+000","CALAFATEO\n BACHEO\nSEÑALAMIENTO HORIZONTAL","TAMAZULA DE GORDIANO",2,0.6]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H14:H21)","v":59.500000000000007},{"$f":"SUM(I14:I21)","v":17.850000000000001}]

{"sheet":"Ahualulco","index":4,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,0,8,8]]}
{"$rows_empty":8}
["REPORTE DE ACTIVIDADES RESIDENCIA AHUALULCO"]
[]
["NOVIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS","KMS CONSERVADOS (30%)"]
[null,601,"TALA - STA. CRUZ DE LAS FLORES",35,"DEL KM 8+000 AL KM 10+200\nDEL KM 14+000 AL KM 35+000","BACHEO Y CALAVEREO.","TALA\nTLAJOMULCO DE ZUÑIGA.",23.2,{"$f":"H13*0.3","v":6.96}]
[null,602,"EL AMARILLO - LA VEGA",8.9,"DEL KM 0+000 AL KM 1+500","DESMONTE EN EL DERECHO DE VIA.","TEUCHITLÁN",1.5,{"$f":"H14*0.3","v":0.44999999999999996}]
[null,604,"EL REFUGIO - SAN MARCOS",53.7,"DEL KM 0+000 AL KM 53+700","EXTRACCION DE EMULSION, DESMONTE, BACHEO Y CALAVEREO.","TALA\n TEUCHITLAN\nAHUALULCO DE MERCADO\n SAN JUANITO DE ESCOBEDO\nETZATLÁN\n SAN MARCOS.",53.7,16.11]
[null,608,"AHUALULCO - AMECA",30.6,"DEL KM 1+000 AL KM 30+600","DESMONTE EN EL DERECHO DE VIA.","AHUALULCO DE MERCADO\n AMECA.",29.6,8.8800000000000008]
[null,609,"ENTR. CARR. 604 - EL CARMEN DE ORDAZ",3.5,"DEL KM 0+000 AL KM 3+500","DESMONTE EN EL DERECHO DE VIA.","AHUALULCO DE MERCADO",3.5,1.05]
[null,616,"ENTR. CARR. 604 - SAN JUANITO DE ESCOBEDO",4.2,"DEL KM 0+000 AL KM 4+200","BACHEO Y CALAVEREO.","SAN JUANITO DE ESCOBEDO.",4.2,1.26]
[null,618,"CRUC. STA. MARIA - SN. MARTIN HGO. - AMECA",23.1,"DEL KM 9+000 AL KM 23+100","APLICACIÓN DE PINTURA EN RAYAS, (ENTRONQUE)","SAN MARTÍN HIDALGO\nAMECA.",14.100000000000001,4.2300000000000004]
[null,620,"ENTR. CARR. (AMECA-MASCOTA) - GUACHINANGO",7.5,"DEL KM 0+000 AL KM 4+000","BACHEO Y CALAVEREO.","GUACHINANGO",4,1.2]
[null,621,"LA COFRADIA - LA SAUCEDA - BUENAVISTA",22.2,"DEL KM 0+000 AL KM 22+200","BACHEO Y CALAVEREO.","COCULA\n SAN MARTÍN HIDALGO.",22.2,6.6599999999999993]
[null,626,"AHUALULCO - SAN IGNACIO - EL CARMEN",9,"DEL KM 0+000 AL KM 9+000","DESMONTE EN EL DERECHO DE VIA.","AHUALULCO DE MERCADO",9,2.6999999999999997]
[null,628,"ENTR. CARR. 612 - LA MAZATA",5.2,"DEL KM 0+000 AL KM 5+200","DESAZOLVE DE CUNETAS, DESMONTE EN EL DERECHO DE VIA, BACHEO Y CALAVEREO","ETZATLÁN\nSAN JUANITO DE ESCOBEDO.",5.2,1.56]
[null,631,"ESTIPAC - EL TECUAN - BUENAVISTA",6,"DEL KM 0+000 AL KM 6+000","BACHEO Y CALAVEREO.","VILLA CORONA",6,1.7999999999999998]
[null,632,"SAN MARCOS - LIMITE DE ESTADOS",10.4,"DEL KM 0+000 AL KM 3+140","DESMONTE EN EL DERECHO DE VIA, BACHEO Y CALAVEREO.","SAN MARCOS",3.14,0.94199999999999995]
[null,633,"VILLA CORONA - ATOTONILCO EL BAJO",9.1999999999999993,"DEL KM 0+000 AL KM 9+200","BACHEO Y CALAVEREO.","VILLA CORONA",9.1999999999999993,2.76]
[null,636,"ENTR. CARR. (GUAD.-AMECA) - EL SALITRE",6.4,"DEL KM 0+000 AL KM 6+400","BACHEO Y CALAVEREO.","AMECA",6.4,1.92]
[null,637,"INGRESO NORTE AMECA",1.1000000000000001,"DEL KM 0+000 AL KM 1+100","BACHEO Y CALAVEREO.","AMECA",1.1000000000000001,0.33]
[null,641,"EL CARMEN - EL AMARILLO",2.4,"DEL KM 0+000 AL KM 2+400","BACHEO Y CALAVEREO.","AHUALULCO DE MERCADO\nTEUCHITLÁN.",2.4,0.72]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H13:H29)","v":198.43999999999997},{"$f":"SUM(I13:I29)","v":59.531999999999996}]

{"sheet":"Villa Guerrero","index":5,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[10,0,10,8]]}
{"$rows_empty":10}
["REPORTE DE ACTIVIDADES RESIDENCIA VILLA GUERRERO"]
[]
["NOVIEMBRE"]
[null,"CÓDIGO","CAMINO","TOTAL KM. DEL CAMINO","TRAMO A INTERVENIR","ACTIVIDADES REALIZADAS","MUNICIPIOS BENEFICIADOS","KMS CONSERVADOS ","KMS CONSERVADOS \n(30%)"]
[null,701,"ENT.CARR.FED.MEX.23-VILLA GUERRERO",38.646000000000001,"DEL KM 0+000 AL KM 38+600\nEN EL KM 29+000"," BACHEO SUPERFICIAL CON TIERRA","COLOTLÁN\nTOTATICHE\nVILLA GUERRERO",38.6,{"$f":"H15*0.3","v":11.58}]
[null,702,"VILLA GUERRERO-SAN MARTIN DE BOLAÑOS",62.15,"\nDEL KM 1+300 AL KM 5+340\nDEL KM 38+700 AL KM 40+000\nDEL KM 53+800 AL KM 55+300","REEMOSION DE DERRUMBES\nLIMPIEZA DE CUNETAS  \nBACHEO SUPERFICIAL CON TIERRA\nDESHIERBE","BOLAÑOS\nSAN MARTIN DE BOLAÑOS\nVILLAGUERRERO",{"$f":"2.8+4.04","v":6.84},{"$f":"H16*0.3","v":2.052}]
[null,705,"MONTE ESCOBEDO-MEZQUITIC",22.33,"DEL KM 30+000 AL KM 31+000","DESHIERBE","MEZQUITIC",1,0.3]
[null,707,"HUEJUQUILLA-VALPARAISO",20.7,"DEL KM 1+000 AL KM 2+500","DESHIERBE","HUEJUQUILLA EL ALTO",1.5,0.44999999999999996]
[null,710,"E.C.702-BOLAÑOS-HUILACATITLAN",7.25,"DEL KM 0+000 AL KM 7+250","BACHEO SUPERFICIAL AISLADO","BOLAÑOS",7.25,2.1749999999999998]
[null,711,"BOLAÑOS-TENZOMPA-HUEJUQUILLA",130.59299999999999,"DEL KM 53+700 AL KM 54+100\nDEL KM 117+400 AL KM 124+000\nDEL KM 128+000 AL KM 130+500 ","REEMOSION DE DERRUMBES,LIMPIEZA DE CUNETAS, DESHIERBE Y BACHEO SUPERFICIAL","HUEJUQUILLA EL ALTO",{"$f":"(54.1-53.7)+(124-117.4)+(130.5-128)","v":9.4999999999999929},2.8499999999999979]
[null,712,"HUEJUCAR-MONTE ESCOBEDO",21.96,"DEL KM 1+300 AL KM 2+000","DESMONTE","HUEJÚCAR",0.7,0.21]
[null,718,"MEZQUITIC-NOSTIC",11.206,"DEL KM 2+000 AL KM 6+000","DESHIERBE","MEZQUITIC",4,1.2]
[null,719,"BOLAÑOS-TEPEC",0.86899999999999999,"DEL KM 0+000 AL KM 0+869","BACHEO SUPERFICIAL AISLADO","BOLAÑOS",0.86899999999999999,0.26069999999999999]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H15:H23)","v":70.259},{"$f":"SUM(I15:I23)","v":21.077699999999997}]

{"sheet":"Resumen por Residencia","index":6,"n_rows":26,"n_cols":6,"rows_kept":26,"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 NOVIEMBRE 2018"]
[]
[]
[]
[]
[]
[null,null,"RESIDENCIA","TOTAL DE CAMINOS ATENDIDOS","TOTAL KM CONSERVADOS","TOTAL KM CONSERVADOS"]
[null,null,"GUADALAJARA",11,{"$f":"Guadalajara!I25+Guadalajara!E31","v":31.475000000000001},{"$f":"Guadalajara!#REF!","v":{"$error":"#REF!"}}]
[null,null,"TEOCALTICHE",11,{"$f":"Teocaltiche!I22","v":55.302900000000001},{"$f":"Teocaltiche!#REF!","v":{"$error":"#REF!"}}]
[null,null,"SAN MIGUEL",5,{"$f":"'San Miguel'!I19","v":34.589999999999996},{"$f":"'San Miguel'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"SAYULA",8,{"$f":"Sayula!I22","v":17.850000000000001},{"$f":"Sayula!#REF!","v":{"$error":"#REF!"}}]
[null,null,"AHUALULCO",17,{"$f":"Ahualulco!I30","v":59.531999999999996},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"VILLA GUERRERO",9,{"$f":"'Villa Guerrero'!I24","v":21.077699999999997},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"TOTAL",{"$f":"SUM(D20:D25)","v":61},{"$f":"SUM(E20:E25)","v":219.82759999999996},{"$f":"SUM(F20:F25)","v":{"$error":"#REF!"}}]

{"sheet":"Resumen Global","index":7,"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 NOVIEMBRE 2018"]
[]
[]
[]
[null,null,null,"RESIDENCIA","TOTAL DE CAMINOS ATENDIDOS EN EL MES NOVIEMBRE","TOTAL KM. CONSERVADOS NOVIEMBRE","TOTAL KM. CONSERVADOS ACUMULADOS","TOTAL KM. CONSERVADOS"]
[null,null,null,"GUADALAJARA, TEOCALTICHE, SAN MIGUEL, SAYULA, AHUALULCO, VILLA GUERRERO.",{"$f":"'Resumen por Residencia'!D26","v":61},{"$f":"'Resumen por Residencia'!E26","v":219.82759999999996},4443.7776999999987,{"$f":"'Resumen por Residencia'!F26","v":{"$error":"#REF!"}}]
{"$rows_empty":17}
[null,null,null,"ATENTAMENTE"]
[]
[]
[]
[null,null,null,"ARQ. JUAN PABLO CORTES CALLEJA"]
[null,null,null,"DIRECTOR GENERAL DE INFRAESTRUCTURA CARRTERA."]