2. Create a VBA function that: Using Microsoft Excel complete the following: Cal

Question

2. Create a VBA function that: Using Microsoft Excel complete the following: Calculates the free flow speed of a basic highway segment (FF-75.4-hw fic 3.22 TRD0.84) a. LW- b. Where FFS- free flow speed fw - adjustment for lane width (from 1st table below) ii. adjustment for right-side lateral clearance (from 2nd table below Reduction in FFS Average Lane Width (ft 212 0.0 11-12 2 10 11 6.6 Lanes in One Direction Right-Side Lateral Clearance (ft 26 3 0.0 0.4 0.8 4 0.0 0.2 0.4 0.6 0.8 0.0 0.6 0.0 0.2 0.3 0.4 0.5 0.6 4 2.4 3.0 3.6 1.6 2.0 2.4 0

Explanation / Answer

Function ffspeed(fLW As Double, fLC As Double,DRD As Double ) As Doube

ffspeed = 75.4- fLW - fLC - 3.22*TRD^(0.84)

End Function

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.