Scribd
Upload
16 views4 pages

Excel Vertical Alignment

The document outlines the vertical alignment calculations for different types of vehicles including cars, buses, and trucks, detailing their efficiency, weight, and power requirements. It includes formulas for calculating friction, power, and acceleration across various grades of a road. Each vehicle type is analyzed for performance across multiple grades, with results indicating that all vehicle types pass the design criteria.

Uploaded by

BEDOLIDO FERNIL R.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
16 views4 pages

Excel Vertical Alignment

The document outlines the vertical alignment calculations for different types of vehicles including cars, buses, and trucks, detailing their efficiency, weight, and power requirements. It includes formulas for calculating friction, power, and acceleration across various grades of a road. Each vehicle type is analyzed for performance across multiple grades, with results indicating that all vehicle types pass the design criteria.

Uploaded by

BEDOLIDO FERNIL R.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

II-VERTICAL ALIGNMENT

ASSUMPTIONS AND GIVEN DATA:


EFFICIENCY, e
ROLLING coeffriction of
frictions μt
coefficient of air friction, α =
(1000/km)(1hr/
v1= 60 km/hr 3600s)=16.67m/s
v2=20kph =5.56 m/s

Types of Prop in Ave effective Width (M) Weight (kg) Horse height
vehicles traffic length (M) Power
(a) (b) (c) (k) (f) (d)
Cars/jeepneys 0.6 6 1.9 3000 50 1.8
buses 0.15 12 2.1 15000 100 3.6
trucks 0.25 15 2.3 30000 200 4.0

CARS/JEEPNEYS

Formulas to be used:

735( Hp) 735 (Hp) Y2—Y1


P= ( e )= ∗.90
V1 16.67 X2-X1
Fr=Friction=Μn=.15 * [ (E * 9.81)] X2-X1
GRADE HORIZONTAL DISTANCE elevation g (design) S
X1 X2 Y1 Y2
G1 0+000.00 0+400.00 96 113 4.25% 400.00
G2 0+400.00 0+960.00 113 105 -1.43% 560.00
G3 0+960.00 1+240.00 105 105 0.00% 280.00
G4 1+240.00 1+600.00 105 102 -0.83% 360.00
G5 1+600.00 2+115.37 102 72 -5.82% 515.37

aₙ = (V₂² − V₁²) / (2sₙ)

a₁ = ¿/ 2(400)
a₁ = −0.309

a₂ = ¿/ 2(960)
a₂ = −0.129

a₃ = ¿/ 2(1240)
a₃ = −0.0996

a₄ = ¿/ 2(1600)
a₄ = −0.0772
a5= ¿/ 2(2115.37)
a5 = −0.0772
GRADE COMPUTATION FOR JEEPNEYS: HP=50 e=.90 W=3000kg

Grade s a P(N) Fr (N) Fa(N) g G Remarks


(design) (Passing)
G1 400.00 -0.30864 1984.5 441.45 7.387 4.25% 8.36% PASS
G2 560.00 -0.22046 1984.5 441.45 7.387 -1.43% 7.47% PASS
G3 280.00 -0.44092 1984.5 441.45 7.387 0.00% 9.71% PASS
G4 360.00 -0.34294 1984.5 441.45 7.387 -0.83% 8.71% PASS
G5 515.37 -0.23955 1984.5 441.45 7.387 -5.82% 7.66% PASS

*P (N) G1-G5

735(Hp) 735(50)
P= = (.90)
V1 16.67
=1984.103

*Fr=Friction=μN

= (.015)(3000 × 9.81)=441.45

*Fa=Fair=αBHV12=(.0006) (1.9)(1.8)(60)2=7.387

mass ×9.81
*P-Fr-Fa- ( ¿ ( G )=mass (a)
100
3000× 9.81
=1984.103-441.45-7.387 ( ¿ ( G ) =(3000)(−0.514 )=10.46%
100
HP= 100 W=15,000 B=(2.1)(3.6)

FOR BUSES

Grade s a P(N) Fr (N) Fa(N) g G Remarks


(design) (Passing)
G1 400.00 -0.30864 3969 2207.25 16.330 4.25% 4.33% PASS
G2 560.00 -0.22046 3969 2207.25 16.330 -1.43% 3.43% PASS
G3 280.00 -0.44092 3969 2207.25 16.330 0.00% 5.68% PASS
G4 360.00 -0.34294 3969 2207.25 16.330 -0.83% 4.68% PASS
G5 515.37 -0.23955 3969 2207.25 16.330 -5.82% 3.63% PASS

FOR TRUCKS

Grade s a P(N) Fr (N) Fa(N) g G Remarks


(design) (Passing)
G1 400.00 -0.30864 7938 4414.5 19.872 4.25% 4.34% PASS
G2 560.00 -0.22046 7938 4414.5 19.872 -1.43% 3.44% PASS
G3 280.00 -0.44092 7938 4414.5 19.872 0.00% 5.69% PASS
G4 360.00 -0.34294 7938 4414.5 19.872 -0.83% 4.69% PASS
G5 515.37 -0.23955 7938 4414.5 19.872 -5.82% 3.63% PASS

You might also like