24
Curva Radio V Pi Pf ip C1 100 40 -2 6.6 1.40 C2 120 40 -2 6.2 1.40 C3 70 40 -2 7.2 1.40 C4 165 40 -2 5.2 1.40 C5 95 40 -2 6.7 1.40 C6 300 40 -2 3.7 1.40 C7 60 40 -2 8 1.40 C8 120 40 -2 6.2 1.40

CALCULO DE Transicion de Peralte 08

Embed Size (px)

DESCRIPTION

EXCEL PARA CALCULO DE PERALTE EN CURVAS

Citation preview

Hoja1CurvaRadioVPiPfipaLtC110040-26.61.406.620.271C212040-26.21.406.619.329C37040-27.21.406.621.686C416540-25.21.406.616.971C59540-26.71.406.620.507C630040-23.71.406.613.436C76040-281.406.623.571C812040-26.21.406.619.329

Curva1Curva2Radio100V40Pi-2Pf6.6N4Ls30Ls30AB9.091A'B'9.091BC9.091B'C'9.091CD20.909C'D'20.909AF9.091A'F'9.091BG18.182B'G'18.182BermaCarrilCarrilBermaF53.982End Normal Shoulder-4-2-2-4A63.073End Normal Crown-2-2-2-4B=TS72.164Level Crown00-2-4C81.255Reverse Crown22-2-4G90.346Low Shoulder Match44-4-4D=Pc=SC102.164Begin Full Super6.66.6-6.6-6.6

D'=Pt=CS149.231End Full Super6.66.6-6.6-6.6G'161.049Low Shoulder Match44-4-4C'170.140Reverse Crown22-2-4B'=ST179.231Level Crown00-2-4A'188.322Begin Normal Crown-2-2-2-4F'197.413Begin Normal Shoulder-4-2-2-4

Curva2Curva2Radio120V40Pi-2Pf6.2N4Ls30Ls30AB9.677A'B'9.677BC9.677B'C'9.677CD20.323C'D'20.323AF9.677A'F'9.677BG19.355B'G'19.355BermaCarrilCarrilBermaF342.437End Normal Shoulder-4-2-2-4A352.115End Normal Crown-2-2-2-4B=TS361.792Level Crown00-2-4C371.469Reverse Crown22-2-4G381.147Low Shoulder Match44-4-4D=Pc=SC391.792Begin Full Super6.26.2-6.2-6.2

D'=Pt=CS529.051End Full Super6.26.2-6.2-6.2G'539.696Low Shoulder Match44-4-4C'549.374Reverse Crown22-2-4B'=ST559.051Level Crown00-2-4A'568.728Begin Normal Crown-2-2-2-4F'578.406Begin Normal Shoulder-4-2-2-4

Curva3Curva2Radio70V40Pi-2Pf7.2N4Ls30Ls30AB8.333A'B'8.333BC8.333B'C'8.333CD21.667C'D'21.667AF8.333A'F'8.333BG16.667B'G'16.667BermaCarrilCarrilBermaF622.349End Normal Shoulder-4-2-2-4A630.683End Normal Crown-4-2-2-2B=TS639.016Level Crown-4-200C647.349Reverse Crown-4-222G655.683Low Shoulder Match-4-444D=Pc=SC669.016Begin Full Super-7.2-7.27.27.2

D'=Pt=CS740.222End Full Super-7.2-7.27.27.2G'753.555Low Shoulder Match-4-444C'761.889Reverse Crown-4-222B'=ST770.222Level Crown-4-200A'778.555Begin Normal Crown-4-2-2-2F'786.889Begin Normal Shoulder-4-2-2-4

Curva4Curva4Radio165V40Pi-2Pf5.2ip1.40a6.6N4(Inclinacion Berma)

EntradaSalidaK0.7K0.7Lt Calculada16.971Lt redondeada18Lt redondeada18AB =5.000A'B' =5.000BC =5.000B'C' =5.000CD =8.000C'D' =8.000BD =13.000B'D' =13.000BPc =9.100B'Pt =9.100CPc =4.100C'Pt =4.100PcD =3.9PtD' =3.9BG =10.000B'G' =10.000AF =5.000A'F' =5.000DescripcionBermaCarrilCarrilBermaF803.395End Normal Shoulder-4-2-2-4A808.395End Normal Crown-2-2-2-4B813.395Level Crown00-2-4C818.395Reverse Crown22-2-4Pc822.4953.643.64-3.64-4G823.395Low Shoulder Match44-4-4D822.714Begin Full Super5.25.2-5.2-5.2D'884.596End Full Super5.25.2-5.2-5.2G'887.596Low Shoulder Match44-4-4Pt888.4963.643.64-3.64-4C'892.596Reverse Crown22-2-4B'897.596Level Crown00-2-4A'902.596Begin Normal Crown-2-2-2-4F'907.596Begin Normal Shoulder-4-2-2-4

Curva5Curva2Radio95V40Pi-2Pf6.7N4Ls30Ls30AB8.955A'B'8.955BC8.955B'C'8.955CD21.045C'D'21.045AF8.955A'F'8.955BG17.910B'G'17.910BermaCarrilCarrilBermaF986.779End Normal Shoulder-4-2-2-4A995.734End Normal Crown-4-2-2-2B=TS1004.689Level Crown-4-200C1013.644Reverse Crown-4-222G1022.599Low Shoulder Match-4-444D=Pc=SC1034.689Begin Full Super-6.7-6.76.76.7

D'=Pt=CS1248.99End Full Super-6.7-6.76.76.7G'1261.080Low Shoulder Match-4-444C'1270.035Reverse Crown-4-222B'=ST1278.99Level Crown-4-200A'1287.945Begin Normal Crown-4-2-2-2F'1296.900Begin Normal Shoulder-4-2-2-4

Curva6Curva6Radio300V40Pi-2Pf3.7ip1.40a6.6N4(Inclinacion Berma)

EntradaSalidaK0.7K0.7Lt Calculada13.436Lt redondeada15Lt redondeada15AB =5.263A'B' =5.263BC =5.263B'C' =5.263CD =4.474C'D' =4.474BD =9.737B'D' =9.737BPc =6.816B'Pt =6.816CPc =1.553C'Pt =1.553PcD =2.9210526316PtD' =2.9210526316BG =10.526B'G' =10.526AF =5.263A'F' =5.263DescripcionBermaCarrilCarrilBermaF1543.406End Normal Shoulder-4-2-2-4A1548.669End Normal Crown-4-2-2-2B1553.932Level Crown-4-200C1559.195Reverse Crown-4-222Pc1560.748-4-2.592.592.59D1563.669Begin Full Super-4-3.73.73.7D'1610.661End Full Super-4-3.73.73.7Pt1613.582-4-2.592.592.59C'1615.135Reverse Crown-4-222B'1620.398Level Crown-4-200A'1625.661Begin Normal Crown-4-2-2-2F'1630.924Begin Normal Shoulder-4-2-2-4

Curva7Curva2Radio60V40Pi-2Pf8N4Ls30Ls30AB7.500A'B'7.500BC7.500B'C'7.500CD22.500C'D'22.500AF7.500A'F'7.500BG15.000B'G'15.000BermaCarrilCarrilBermaF1747.773End Normal Shoulder-4-2-2-4A1755.273End Normal Crown-2-2-2-4B=TS1762.773Level Crown00-2-4C1770.273Reverse Crown22-2-4G1777.773Low Shoulder Match44-4-4D=Pc=SC1792.773Begin Full Super88-8-8

D'=Pt=CS1882.482End Full Super88-8-8G'1897.482Low Shoulder Match44-4-4C'1904.982Reverse Crown22-2-4B'=ST1912.482Level Crown00-2-4A'1919.982Begin Normal Crown-2-2-2-4F'1927.482Begin Normal Shoulder-4-2-2-4

Curva8Curva8Radio120V40Pi-2Pf6.2ip1.40a6.6N4(Inclinacion Berma)

EntradaSalidaK0.7K0.7Lt Calculada19.329Lt redondeada20Lt redondeada20AB =4.878A'B' =4.878BC =4.878B'C' =4.878CD =10.244C'D' =10.244BD =15.122B'D' =15.122BPc =10.585B'Pt =10.585CPc =5.707C'Pt =5.707PcD =4.537PtD' =4.537BG =9.756B'G' =9.756AF =4.878A'F' =4.878DescripcionBermaCarrilCarrilBermaF1955.193End Normal Shoulder-4-2-2-4A1960.071End Normal Crown-4-2-2-2B1964.949Level Crown-4-200C1969.827Reverse Crown-4-222Pc1975.534-4-4.344.344.34G1974.705Low Shoulder Match-4-444D1980.071Begin Full Super-6.2-6.26.26.2D'2084.613End Full Super-6.2-6.26.26.2G'2089.979Low Shoulder Match-4-444Pt2089.15-4.34-4.344.344.34C'2094.857Reverse Crown-4-222B'2099.735Level Crown-4-200A'2104.613Begin Normal Crown-4-2-2-2F'2109.491Begin Normal Shoulder-4-2-2-4

ResumenCurvaEstacionDescripcionSuavizadoBermaExteriorCarrilExteriorCarrilInteriorBermaInteriorBermaExteriorCarrilExteriorCarrilInteriorBermaInterior00Begin Alignment0-4-200-4-2001End Normal Shoulder000001End Normal Crown000001Level Crown000001Reverse Crown000001Low Shoulder Match000001Begin Full Super000001End Full Super000001Low Shoulder Match000001Reverse Crown000001Level Crown000001Begin Normal Crown000001Begin Normal Shoulder000002End Normal Shoulder000002End Normal Crown000002Level Crown000002Reverse Crown000002Low Shoulder Match000002Begin Full Super000002End Full Super000002Low Shoulder Match000002Reverse Crown000002Level Crown000002Begin Normal Crown000002Begin Normal Shoulder000003End Normal Shoulder000003End Normal Crown000003Level Crown000003Reverse Crown000003Low Shoulder Match000003Begin Full Super000003End Full Super000003Low Shoulder Match000003Reverse Crown000003Level Crown000003Begin Normal Crown000003Begin Normal Shoulder000004End Normal Shoulder000004End Normal Crown000004Level Crown000004Reverse Crown000004Low Shoulder Match000004Begin Full Super000004End Full Super000004Low Shoulder Match000004Reverse Crown000004Level Crown000004Begin Normal Crown000004Begin Normal Shoulder000005End Normal Shoulder000005End Normal Crown000005Level Crown000005Reverse Crown000005Low Shoulder Match000005Begin Full Super000005End Full Super000005Low Shoulder Match000005Reverse Crown000005Level Crown000005Begin Normal Crown000005Begin Normal Shoulder000006End Normal Shoulder000006End Normal Crown000006Level Crown000006Reverse Crown000006Begin Full Super000006End Full Super000006Reverse Crown000006Level Crown000006Begin Normal Crown000006Begin Normal Shoulder000007End Normal Shoulder000007End Normal Crown000007Level Crown000007Reverse Crown000007Low Shoulder Match000007Begin Full Super000007End Full Super000007Low Shoulder Match000007Reverse Crown000007Level Crown000007Begin Normal Crown000007Begin Normal Shoulder000008End Normal Shoulder000008End Normal Crown000008Level Crown000008Reverse Crown000008Low Shoulder Match000008Begin Full Super000008End Full Super000008Low Shoulder Match000008Reverse Crown000008Level Crown000008Begin Normal Crown000008Begin Normal Shoulder0000002105.815End Alignment0-4-200-4-200