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
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
Get step-by-step solutions from verified subject matter experts
