plantilla de conteo vehiculas

37
FORM TRAMO DE LA CARRETERA CHICLAYO-CHOSICA DEL NOR SENTIDO CHICLAYO E CHOSI UBICACIÓN PANAMERICANA NORTE DIA JUEVES HORA AUTO CAMIONETAS MICRO PICK UP PANEL 8:00 E 67 10 19 0 51 0 8:30 S 71 10 23 11 51 1 8:30 E 64 6 22 8 56 1 9:00 S 107 12 19 5 53 0 9:00 E 114 11 18 3 66 0 9:30 S 98 6 28 4 46 0 9:30 E 80 7 20 4 51 0 10:00 S 71 5 27 5 57 1 10:00 E 73 2 17 0 53 0 10:30 S 80 7 30 6 49 1 10:30 E 58 2 24 8 50 0 11:00 S 86 9 16 1 56 1 11:00 E 60 8 20 3 56 0 11:30 S 79 10 18 1 48 0 11:30 E 65 7 24 0 62 1 12:00 S 91 8 22 5 54 0 PARCIAL: 1264 120 0 64 0 6 0 ENCUESTADOR : ______________________ JEFE DE BRIGAD SENTI DO STATION WAGON RURAL Combi DIAGRA. VEH.

Upload: ivan-chavez-g

Post on 09-Nov-2015

15 views

Category:

Documents


5 download

DESCRIPTION

Excel de conteo vehicular IMDA

TRANSCRIPT

Hoja1

FORMATO DE CLASIFICACION VEHICULARCORRECCINFORMATO DE CLASIFICACION VEHICULARESTUDIO DE TRAFICOGRAFICAS DE FLUJO VEHICULAR - INTERV. 30minESTUDIO DE TRAFICOFORMATO N 1FORMATO N 1TRAMO DE LA CARRETERA CHICLAYO-CHOSICA DEL NORTE ESTACION1TRAMO DE LA CARRETERA CHICLAYO-CHOSICA DEL NORTE ESTACION1GRAFICAS DE FLUJO VEHICULAR - INTERV. 30minSENTIDOCHICLAYO ECHOSICA DEL NORTE SCODIGO DE LA ESTACIONSENTIDOCHICLAYO ECHOSICA DEL NORTE SCODIGO DE LA ESTACIONUBICACIN PANAMERICANA NORTE 437DIA Y FECHA7MAYO2015VEHICULOConteo 8hFactor de conteo en 24 hIMDUBICACIN PANAMERICANA NORTE 437DIA Y FECHA3MAYO2015DIAJUEVESE 01correcionE 01DIADOMINGOAutomovil28031.4440374037HORASENTIDOAUTOSTATION WAGONCAMIONETASMICROBUSCAMIONSEMI TRAYLERTRAYLERSUB - TOTALTOTALStation Wagon4871.44702702HORASENTIDOAUTOSTATION WAGONCAMIONETASMICROBUSCAMIONSEMI TRAYLERTRAYLERSUB - TOTALTOTALPICK UPPANELRURALCombi2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3Camionetas8091.4411651165PICK UPPANELRURALCombi2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3DIAGRA.VEH.Micro2151.44310310DIAGRA.VEH.8:00E6710190510111105000050100180383Buses16431.44236623668:00E7834154340241032010300211933508:30S7110231151121186100070010203Camion391.4457578:30S662513432011840000101011578:30E6462285614101260100100000200447Semy Trayler671.4497978:30E8131242380311110040400002003889:00S10712195530212610100080030247Trayler1091.441571579:00S722818841052411031310001889:00E114111836604014110000160000257478TOTAL88919:00E744115644000950031000001983809:30S9862844603115701011100002219:30S702623535015641000600001829:30E8072045102816101000700002064199:30E66381453901310510002000018437210:00S715275571211860001120034213VEHICULOConteo 8 hFactor de conteo en 24 hIMD10:00S73242211400239300001000018810:00E7321705300122360001110020200425E 01correcionE 0110:00E68271363403414630321000218641110:30S8073064912219130001140010225Automovil33291.384595459510:30S75402814450129310112001222510:30E58224850034113000190000173394Station Wagon15721.382170217010:30E66241164501212300017100017937311:00S869161561121811000210062221Camionetas8321.381149114911:00S6944169360415120006000119411:00E60820356033166000060030184375Micro2461.3834034011:00E71312164401112600026100020241111:30S791018148021144100170140191Buses15611.382155215511:30S8143166360146300137010120911:30E6572406210121121000120000206420Camion41.386611:30E6619204390465500001000016938912:00S91822554042134000190010214Semy Trayler581.38818112:00S82432374202142000164012220PARCIAL:12641200640635602641106207165022463341Trayler941.38130130PARCIAL:11585180103003240134551101612567241030740TOTAL106260ENCUESTADOR : ______________________ JEFE DE BRIGADA : ____________________ ING.RESPONS: __________________SUPERV.MTC : ________________________ENCUESTADOR : ______________________ JEFE DE BRIGADA : ____________________ ING.RESPONS: __________________SUPERV.MTC : ________________________

FORMATO DE CLASIFICACION VEHICULARCALCULO DEL IMDAFORMATO DE CLASIFICACION VEHICULARESTUDIO DE TRAFICOESTUDIO DE TRAFICOFORMATO N 1FORMATO N 1TRAMO DE LA CARRETERA CHICLAYO-CHOSICA DEL NORTE ESTACION1TRAMO DE LA CARRETERA CHICLAYO-CHOSICA DEL NORTE ESTACION1SENTIDOCHICLAYO ECHOSICA DEL NORTE SCODIGO DE LA ESTACIONF.C.E. Vehculos ligeros:1,088704SENTIDOCHICLAYO ECHOSICA DEL NORTE SCODIGO DE LA ESTACIONUBICACIN PANAMERICANA NORTE 437DIA Y FECHA7MAYO2015F.C.E. Vehculos pesados:1,035492UBICACIN PANAMERICANA NORTE 437DIA Y FECHA3MAYO2015DIAJUEVESDIADOMINGOTipo de VehculoTrfico Vehcular en dos Sentidos por DaTOTALIMDSFCIMDaHORASENTIDOAUTOSTATION WAGONCAMIONETASMICROBUSCAMIONSEMI TRAYLERTRAYLERSUB - TOTALTOTALLunesMartesMircolesJuevesViernesSbadoDomingoSEMANAHORASENTIDOAUTOSTATION WAGONCAMIONETASMICROBUSCAMIONSEMI TRAYLERTRAYLERSUB - TOTALTOTALPICK UPPANELRURALCombi2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3Automovil40374037403740374037459545952937541961,08870445331.08PICK UPPANELRURALCombi2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3DIAGRA.VEH.Station Wagon70270270270270221702170785011211,08870412121.08DIAGRA.VEH.12:00E5426246450121390001160001198434Camionetas1165116511651165116511491149812311601,08870412541.0812:00E7840315400038000106000021243512:30S91241984100418120010141300236Micro31031031031031034034022303191,0887043451.0812:30S81382584801111100018000022312:30E5313271138110961120210000184364Buses23662366236623662366215521551614023061,08870424911.0812:30E80412811470156010002000022246513:00S86531231011104000180000180Camion575757575766297421,035492441.0313:00S91423394402310401004000024313:00E60212173403021113000200001202423Semy Trayler97979797978181647921,035492961.0313:00E10137237351149000115000022550713:30S94181910360201570030161000221Trayler15715715715715713013010451491,0354921541.0313:30S11062355510226310012001128213:30E662418103051393201390100185438TOTAL8891889188918891889110626106266570793871012913:30E103461743002373200010000122851114:00S10415221352021168010217000025314:00S11166305511224300015001128314:00E524157472121813110011000017436914:00E114402114750118211017000128761214:30S81282252171054201381402195DEMANDA PROYECTADA14:30S1427526447011710000012000032514:30E4130182310309500118080015738714:30E12061317451218000005000028157815:00S82719549044218000229000023015:00S13264246490256310004000129715:00E811123105501326150024100110243520Tasa de Crecimiento x Regin en %rvp =1.50Tasa de Crecimiento Anual de la Poblacin(para vehculos de pasajeros)15:00E105582811510135100108000127357815:30S723927104132217161124332221277rvc =3.30Tasa de Crecimiento Anual del PBI Regional(para vehculos de carga)15:30S124642396200180000211001030515:30E74271763725044300021100120248715:30E1116031105302210211002000028558016:00S10019318701222383011130210285Proyeccin de Trfico - Situacin Sin Proyecto16:00S128592684912194200050001295PARCIAL:119131101206582130242341331641422254621463422PARCIAL:1731853432123777422381223693379600374266Tipo de VehculoAo 0Ao 1Ao 2Ao 3Ao 4Ao 5Ao 6Ao 7Ao 8Ao 9Ao 100ENCUESTADOR : ______________________ JEFE DE BRIGADA : ____________________ ING.RESPONS: __________________SUPERV.MTC : ________________________Trfico Normal99759975101261028110439105971076110924110911126011433ENCUESTADOR : ______________________ JEFE DE BRIGADA : ____________________ ING.RESPONS: __________________SUPERV.MTC : ________________________Automovil4533.004533.004601.004670.004740.004811.004883.004957.005031.005106.005183.00Station Wagon1212.001212.001230.001249.001267.001286.001306.001325.001345.001365.001386.00HORASENTIDOSTATIONCAMIONETASBUSCAMIONSEMI TRAYLERTRAYLERTOTALCamionetas1254.001254.001273.001292.001311.001331.001351.001371.001392.001413.001434.00HORASENTIDOSTATIONCAMIONETASBUSCAMIONSEMI TRAYLERTRAYLERTOTALAUTOSTATION WAGONPICK UPPANELRURALCombiMICRO2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3Micro345.00345.00350.00355.00361.00366.00372.00377.00383.00389.00394.00AUTOSTATION WAGONPICK UPPANELRURALCombiMICRO2 E>=3 E2 E3 E4 E2S1/2S22S33S1/3S2>= 3S32T22T33T2>=3T3DIAGRA.VEH.Buses2491.002491.002528.002566.002605.002644.002684.002724.002765.002806.002848.00DIAGRA.VEH.8:00309388324211292366272100300140830Camion44.0044.0045.0047.0049.0050.0052.0053.0055.0057.0059.008:002971187018145011833930811111227389:003632993162201111063341102460034897Semy Trayler96.0096.0099.00102.00106.00109.00113.00117.00120.00124.00129.009:0028312974271580411341720319000075210:00322209213207172272291103410054840Trayler154.00154.00159.00164.00170.00175.00181.00187.00193.00200.00206.0010:00277115722714807153918503210000274011:0030421941521026237635100344006484411:00300136802316108122716001620511380012:00284681012715513750311132591301798Tipo de VehculoAo 11Ao 12Ao 13Ao 14Ao 15Ao 16Ao 17Ao 18Ao 19Ao 2012:00330161117331790412355111120000090013:0030668892913157455255044531101788Trfico Normal1143311433116091178611966121491233512525127161291013:004051871082516017123210311221001297814:00303717735150145648285228451502807Automovil5183.005183.005261.005340.005420.005501.005584.005667.005752.005839.0014:00470227942720316726183102340013112315:002857682221567976132204105511312825Station Wagon1386.001386.001407.001428.001449.001471.001493.001516.001538.001561.0015:0049925810928192161026141010290002117616:003279698342036107704371597735421007Camionetas1434.001434.001456.001477.001500.001522.001545.001568.001592.001615.0016:004682411083821515732731122600121158TOTAL7636Micro394.00394.00400.00406.00412.00418.00424.00431.00437.00444.00TOTAL836528034878092151643396710956128425718414507282320Buses2848.002848.002891.002934.002978.003023.003068.003114.003161.003208.0033291572832246156145894284114214191718062616Camion59.0059.0061.0063.0065.0067.0069.0072.0074.0076.00Semy Trayler129.00129.00133.00138.00142.00147.00152.00157.00162.00167.00HORAVEHICULOSTrayler206.00206.00213.00220.00227.00235.00242.00250.00259.00267.00HORAVEHICULOS0:000ESTIMADOS0:000ESTIMADOS1:00103.751:0092.252:00207.5Demanda Proyectada "Con Proyecto"2:00184.53:00311.25Trfico Generado por Tipo de Proyecto3:00276.754:00415Tipo de Intervencin% de Trfico Normal4:003695:00518.75Mejoramiento155:00461.256:00622.5Fuente: Ministerio de Transportes y Comunicaciones - MTC6:00553.57:00726.25Proyeccin de Trfico - Con Proyecto 7:00645.758:00830CONTADOS8:00738CONTADOS9:00897Tipo de VehculoAo 0Ao 1Ao 2Ao 3Ao 4Ao 5Ao 6Ao 7Ao 8Ao 9Ao 109:0075210:00840Trfico Normal9975.009975.0010126.0010281.0010439.0010597.0010761.0010924.0011091.0011260.0011433.0010:0074011:00844Automovil4533.004533.004601.004670.004740.004811.004883.004957.005031.005106.005183.0011:0080012:00798Station Wagon1212.001212.001230.001249.001267.001286.001306.001325.001345.001365.001386.0012:0090013:00788Camionetas1254.001254.001273.001292.001311.001331.001351.001371.001392.001413.001434.0013:0097814:00807Micro345.00345.00350.00355.00361.00366.00372.00377.00383.00389.00394.0014:00112315:00825Buses2491.002491.002528.002566.002605.002644.002684.002724.002765.002806.002848.0015:00117616:001007Camion44.0044.0045.0047.0049.0050.0052.0053.0055.0057.0059.0016:00115817:00881.125ESTIMADOSSemy Trayler96.0096.0099.00102.00106.00109.00113.00117.00120.00124.00129.0017:001013.25ESTIMADOS18:00755.25Trayler154.00154.00159.00164.00170.00175.00181.00187.00193.00200.00206.00FACTOR DE CORRECIN1,418:00868.519:00629.375Trfico Generado0.001497.001520.001542.001566.001591.001615.001641.001664.001690.001714.0019:00723.75FACTOR DE CORRECCIN20:00503.5Automovil0.00680.00690.00701.00711.00722.00732.00744.00755.00766.00777.0020:0057921:00377.625Station Wagon0.00182.00185.00187.00190.00193.00196.00199.00202.00205.00208.0021:00434.2522:00251.75Camionetas0.00188.00191.00194.00197.00200.00203.00206.00209.00212.00215.0022:00289.523:00125.875Micro0.0052.0053.0053.0054.0055.0056.0057.0057.0058.0059.0023:00144.750:000Buses0.00374.00379.00385.00391.00397.00403.00409.00415.00421.00427.000:000Camion0.007.007.007.007.008.008.008.008.009.009.00Semy Trayler0.0014.0015.0015.0016.0016.0017.0018.0018.0019.0019.00Trayler0.0023.0024.0025.0026.0026.0027.0028.0029.0030.0031.00IMD TOTAL9975.0011472.0011646.0011823.0012005.0012188.0012376.0012565.0012755.0012950.0013147.00

Tipo de VehculoAo 11Ao 12Ao 13Ao 14Ao 15Ao 16Ao 17Ao 18Ao 19Ao 20Trfico Normal11433.0011433.0011609.0011786.0011966.0012149.0012335.0012525.0012716.0012910.00Automovil5183.005183.005261.005340.005420.005501.005584.005667.005752.005839.00Station Wagon1386.001386.001407.001428.001449.001471.001493.001516.001538.001561.00Camionetas1434.001434.001456.001477.001500.001522.001545.001568.001592.001615.00Micro394.00394.00400.00406.00412.00418.00424.00431.00437.00444.00Buses2848.002848.002891.002934.002978.003023.003068.003114.003161.003208.00Camion59.0059.0061.0063.0065.0067.0069.0072.0074.0076.00Semy Trayler129.00129.00133.00138.00142.00147.00152.00157.00162.00167.00Trayler206.00206.00213.00220.00227.00235.00242.00250.00259.00267.00Trfico Generado0.001714.001741.001768.001795.001822.001851.001879.001908.001936.00Automovil0.00777.00789.00801.00813.00825.00838.00850.00863.00876.00Station Wagon0.00208.00211.00214.00217.00221.00224.00227.00231.00234.00Camionetas0.00215.00218.00222.00225.00228.00232.00235.00239.00242.00Micro0.0059.0060.0061.0062.0063.0064.0065.0066.0067.00Buses0.00427.00434.00440.00447.00453.00460.00467.00474.00481.00Camion0.009.009.009.0010.0010.0010.0011.0011.0011.00Semy Trayler0.0019.0020.0021.0021.0022.0023.0024.0024.0025.00Trayler7.0031.0032.0033.0034.0035.0036.0038.0039.0040.00IMD TOTAL11433.0013147.0013350.0013554.0013761.0013971.0014186.0014404.0014624.0014846.00

GRAFICO DE IMDAs