daniel exel con lo.xlsx

39
7:00-8:00 8:00-9:00 9:00- 10:00 10:00- 11:00 11:00- 12:00 12:00- 1:00 1:00-2:00 2:00-3:00 3:00-4:00 4:00-5:00 5:00-6:00 6:00-7:00 287 257 179 144 165 161 137 224 204 176 216 201 CONTEO AUTOS POR HORA Axis Title

Upload: francisco-gonzales-gonzales

Post on 11-Sep-2015

221 views

Category:

Documents


1 download

TRANSCRIPT

AUTOS

STATION WAGO

PICK UP

COMBI

PANEL

generalk

conteo general

CUADRO GENERAL 2

CONTEO GENERAL 2 TORTA

HUACA RIVERA (LUNES)

FORMATO N 1FORMATO DE CLASIFICACION VEHICULARESTUDIO DE TRAFICO

TRAMO DE LA CARRETERACHICLAYO - 2.5KM CARRETERA POMALCAESTACIONCARRETERASENTIDOCHICLAYO EPOMALCA SCODIGO DE LA ESTACIONUBICACIN CARRETERADIA Y FECHALUNES DIA

HORASENTIDOAUTOSTATION WAGONCAMIONETASMICROBUSCAMIONSEMI TRAYLERTRAYLERPICK UPPANELRURALCombi2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3DIAGRA.VEH.7:00-8:00E27237250122300146000010000480S8623212730001000010100002178:00-9:00E25039195111430225000010000459S1047197685012261002000002429:00-10:00E1742331264240133200000001319S128144038332014610000001229710:00-11:00E1441832192040217000110000321S10282285930015500000000222411:00-12:00E16428344121231246110040003396S11521262701209100013000225312:00-1:00E15231295104422274200300000365S1472019487211801202000042981:00-2:00E12625272103411215200020000319S8141189676211590100000052552:00-3:00E21839254119630246212040100454S1612522761900750000100002983:00-4:00E2054422792410146100040100401S12710276570103991011000002614:00-5:00E16523354101411234100060001369S4363437100620000000001025:00-6:00E21141364106352179100240001442S186452641155016115010000004056:00-7:00E1982318286210162000000000348S10111855131020000000000182PARCIAL:366060258410120497637113531172964124202121

AUTO3660STATION WAGON602PICK UP584PANEL101COMBI2049MICRO76B237>=B311C2353C3117C4292S1/2S262S343S1/3S212>= 3S3422T202T323T21>=3T321

FORMATO N 1FORMATO DE CLASIFICACION VEHICULARESTUDIO DE TRAFICO

TRAMO DE LA CARRETERA2.5KM CARRETERA POMALCA -DESVIOESTACIONCARRETERASENTIDOCARRETERA POMALCA EDESVIO SCODIGO DE LA ESTACIONUBICACIN CARRETERADIA Y FECHALUNES DIA

HORASENTIDOAUTOSTATION WAGONCAMIONETASMICROBUSCAMIONSEMI TRAYLERTRAYLERPICK UPPANELRURALCombi2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3TOTALDIAGRA.VEH.7:00-8:00E3126020108400002000157S2331102000112000000000528:00-9:00E22680204011000002000055S1231534000193010000000609:00-10:00E906010008300000000229S70400000120000000011510:00-11:00E7211020204100001000131S21901000310000000032011:00-12:00E1237050108000000000036S41222020620000000002112:00-1:00E21290000011400002000049S14040301071001000000311:00-2:00E25182601013300000000261S17170103091000000003422:00-3:00E241110501011300000000056S12291102062001000000363:00-4:00E152124301012410000000054S3391103092002010100354:00-5:00E2149000106500012001050S1601501010182000000000535:00-6:00E26060301025500100002271S111712120124000000000416:00-7:00E1826210206700000001045S704010005300000000020PARCIAL:35940195164912902296411511001415

FORMATO N 1FORMATO DE CLASIFICACION VEHICULARESTUDIO DE TRAFICO

TRAMO DE LA CARRETERA2.5KM CARRETERA POMALCA - POMALCAESTACIONCARRETERASENTIDOPOMALCA ECHICLAYO SCODIGO DE LA ESTACIONUBICACIN CARRETERADIA Y FECHALUNES DIA

HORASENTIDOAUTOSTATION WAGONCAMIONETASMICROBUSCAMIONSEMI TRAYLERTRAYLERPICK UPPANELRURALCombi2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3DIAGRA.VEH.TOTAL7:00-8:00E28740356124300237000010000526S11024252740001630010200002578:00-9:00E25741328115420388010010000507S12011257695213061002000002799:00-10:00E1792334264240124200000002328S135144438432020810000001331810:00-11:00E1441938193040238000110003335S10793086031018600000000324511:00-12:00E16528346122251288110040003408S124233127413015100013000228012:00-1:00E16131315107432314201300000385S16321264872111601202000043301:00-2:00E13726322103441275200020003348S1004224107263125110100000063012:00-3:00E22441315119650277213040100476S17926307659101570000100003403:00-4:00E2044728792440207102050200423S13811369590201212101011000003014:00-5:00E17622484102421395100060001411S599104371101060000100001385:00-6:00E216424251074722312100240001468S2064530411751125155000000004546:00-7:00E2012321287210203000000000360S114121265232073000000000211PARCIAL:390663072911920857760115201563077124503131

HUACA RIVERA (DOMINGO)

FORMATO N 1FORMATO DE CLASIFICACION VEHICULARESTUDIO DE TRAFICO

TRAMO DE LA CARRETERAPANAMERICANA - HUACA RIVERAESTACIONCARRETERASENTIDOHUACA RIVERA EPANAMERICANA SCODIGO DE LA ESTACIONUBICACIN CARRETERADIA Y FECHADOMINGO DIA

HORASENTIDOAUTOSTATION WAGONCAMIONETASMICROBUSCAMIONSEMI TRAYLERTRAYLERPICK UPPANELRURALCombi2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3DIAGRA.VEH.MOTO LINEALMOTOTAXIMOTOCAR09-9:30E000010000000000000010404S0010000000000000000115179:30-10:00E000000000000000000001405S00001000000000100002062810:00-10:30E001000000000000000010707S00001000100000000002251810:30-11:00E000000000000000000000404S00001000000000000001251811:00-11:30E000010000000001000020426S00100000000000000001140511:30-12:00E000010000000000000010628S10000000000000000001180912:00-12:30E010010000000001000030718S00000000000000000000250712:30-13:00E001000001000000000020718S00101000000000000002040413:00-13:30E000000000000000000000707S10101000000000100004162913:30-14:00E000000000000000000000808S00101000000000000002050514:00-14:30E000000000000000000001618S00000000000000000000040414:30-15:00E001010000000000000020516S000000000000000000000606PARCIAL:218011000200000400001213215

DOMINGO 6H TRAMO PANAMERICANA-HUACA RIVERA

MOTO LINEAL12MOTOTAXI132MOTOCAR15AUTO2STATION WAGON1PICK UP8PANEL0COMBI11MICRO0B20>=B30C22C30C402S1/2S202S303S1/3S20>= 3S34T2S20T3S20T3S30>=C3R30

RESUMENLUNES 6H TRAMO PANAMERICANA-HUACA RIVERADOMINGO 6H TRAMO PANAMERICANA-HUACA RIVERA

MOTO LINEAL8MOTO LINEAL12MOTOTAXI126MOTOTAXI132MOTOCAR10MOTOCAR15AUTO1AUTO2STATION WAGON0STATION WAGON1PICK UP12PICK UP8PANEL1PANEL0COMBI4COMBI11MICRO0MICRO0B20B20>=B30>=B30C25C22C30C30C40C402S1/2S202S1/2S202S302S303S1/3S203S1/3S20>= 3S30>= 3S342T202T202T302T303T203T20>=3T30>=3T30167187

IMDATRAMO PACORA - HUACA RIVERAVehiculoDia no lab. (DOM)Dia no lab. TotalDia lab. (LUNES)Dia lab. TotalIMDSFCIMDAPROYECCIN TRFICO NORMAL VEH/DIAPROYECCIN TRFICO GENERADO VEH/DIAPROYECCIN TRFICO PROYECTADO VEH/DIAVehculo AoTasa Crec. %2014201520162017201820192020202120222023202420252026202720282029Vehculo AoTasa Crec. %2014201520162017201820192020202120222023202420252026202720282029Vehculo AoTasa Crec. %2014201520162017201820192020202120222023202420252026202720282029MOTO LINEAL124883236.571.04216338.113MOTO LINEAL1.338383839404041414242434344444546MOTO LINEAL1.3666666666667777MOTO LINEAL1.3444445464647474848494951515253MOTOTAXI132528126504510.861.042163532.396MOTOTAXI1.3532532539546553560567575582590598605613621629637MOTOTAXI1.3808182838485868789909192939496MOTOTAXI1.3612620628636644652661669679688696705714723733MOTOCAR1560104045.711.04216347.642MOTOCAR5.148485053565962656871757983879296MOTOCAR5.1788899101011111212131414MOTOCAR5.1555861646871757882869195100106110AUTO28145.141.0421635.360AUTO1.35555555556666666AUTO1.3111111111111111AUTO1.3666666667777777STATION WAGON14001.141.0421631.191STATION WAGON1.31111111111111111STATION WAGON1.3000000000000000STATION WAGON1.3111111111111111PICK UP832124843.431.04216345.260PICK UP1.345454646474748494950515152535354PICK UP1.3777777778888888PICK UP1.3525353545455565658595960616162PANEL00142.861.0421632.978PANEL1.33333333333333444PANEL1.3000000000000111PANEL1.3333333333333555COMBI62441618.291.04216319.057COMBI1.319191919202020212121212222222223COMBI1.3333333333333333COMBI1.3222222232323242424242525252526MICRO00000.001.0421630.000MICRO1.30000000000000000MICRO1.3000000000000000MICRO1.3000000000000000B200000.001.0421630.000B21.30000000000000000B21.3000000000000000B21.3000000000000000>=B300000.001.0421630.000>=B31.30000000000000000>=B31.3000000000000000>=B31.3000000000000000C22852016.571.08241817.937C25.118181920212223242527283031333436C25.1333333444455555C25.1212223242526282931323536383941C300000.001.0824180.000C35.10000000000000000C35.1000000000000000C35.1000000000000000C400000.001.0824180.000C45.10000000000000000C45.1000000000000000C45.1000000000000000T2S1/T2S200000.001.0824180.000T2S1/T2S25.10000000000000000T2S25.1000000000000000T2S25.1000000000000000T3S200000.001.0824180.000T3S25.10000000000000000T3S25.1000000000000000T3S25.1000000000000000T3S1/T3S200000.001.0824180.000T3S1/T3S25.10000000000000000T3S1/T3S25.1000000000000000T3S1/T3S25.1000000000000000>= T3S3416004.571.0824184.948>= T3S35.1555666677788991010>= T3S35.1111111111111122>= T3S35.16677778889910101212C2R200000.001.0824180.000C2R25.10000000000000000C2R35.1000000000000000C2R35.1000000000000000C3R200000.001.0824180.000C3R25.10000000000000000C3R25.1000000000000000C3R25.1000000000000000>=C3R300000.001.0824180.000>=C3R35.10000000000000000>=C3R35.1000000000000000>=C3R35.1000000000000000182167IMDA PARCIAL (MOTOS)618.152SUBTOTAL (MOTOS)618618627638649659670681692703716727740752766779SUBTOTAL (MOTOS)9395969799100102103106107109111113115117SUBTOTAL (MOTOS)711722734746758770783795809823836851865881896IMDA PARCIAL 96.730SUBTOTAL 969698100103104106110111115118121124128130134SUBTOTAL 151515151515161617171818192020SUBTOTAL 111113115118119121126127132135139142147150154

PRESENTACION DE LA DEMANDA ACTUAL EN LA CARRETERA PACORA-HUACA RIVERA Y PROYECCIONES DE TRNSITO(SLO VEHIC. MTC)

2014201520162017201820192020202120222023202420252026202720282029TRFICO NORMALHUACA RIVERA969698100103104106110111115118121124128130134TRFICO GENERADOHUACA RIVERA0151515151515161617171818192020TRFICO PROYECTADOHUACA RIVERA96111113115118119121126127132135139142147150154