Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions