Question: Please do it correctly sing Microsoft Excel complete the following: 1. Create a function that calculates the demand flow rate from the following equation: where

Please do it correctly  Please do it correctly sing Microsoft Excel complete the following: 1.

sing Microsoft Excel complete the following: 1. Create a function that calculates the demand flow rate from the following equation: where v, demand flow rate under equivalent base conditions (pch) = demand volume under prevailing conditions (vehh) PHF = peak-hour factor N = number of lanes in analysis direction -adjustment factor for presence of heavy vehicles in traffic stream = adjustment factor for unfamiliar driver populations where Jheavy-vehicle adjustment factor Pr = proportion of trucks and buses in traffic stream P, = proportion of RVs in traffic stream E, -passenger-car equivalent (PCE) of one truck or bus in traffic stream E PCE of one RV in traffic stream Vehicle Level Rolling Mountainous Trucks and buses, E 15 25 20 4.5 4.0 RVs, E 1.2 sing Microsoft Excel complete the following: 1. Create a function that calculates the demand flow rate from the following equation: where v, demand flow rate under equivalent base conditions (pch) = demand volume under prevailing conditions (vehh) PHF = peak-hour factor N = number of lanes in analysis direction -adjustment factor for presence of heavy vehicles in traffic stream = adjustment factor for unfamiliar driver populations where Jheavy-vehicle adjustment factor Pr = proportion of trucks and buses in traffic stream P, = proportion of RVs in traffic stream E, -passenger-car equivalent (PCE) of one truck or bus in traffic stream E PCE of one RV in traffic stream Vehicle Level Rolling Mountainous Trucks and buses, E 15 25 20 4.5 4.0 RVs, E 1.2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!