Assignment
1. Create two VBA functions:
a. One that calculates the positive root of a quadratic formula (y = ax2 + bx + c)
b. One that calculates the negative root of a quadratic formula (y = ax2 + bx + c)
2. Create a VBA function that:
a. Calculates the free flow speed of a basic highway segment (FF = 75.4 - fLW - fLC - 3.22 * TRD0.84)
b. Where
i. FFS - free flow speed
ii. fLW - adjustment for lane width (from 1" table below)
iii. fLC - adjustment for right-side lateral clearance (from 2nd table below
|
Average Lane Width (ft)
|
Reduction in FFS, fLW (mph)
|
|
≥12
|
0.0
|
|
≥ 11 - 12
|
1.9
|
|
≥ 10 - 11
|
6.6
|
|
Right-Side Lateral Clearance (ft)
|
Lanes in One Direction
|
|
2
|
3
|
4
|
≥5
|
|
≥6
|
0.0
|
0.0
|
0.0
|
0.0
|
|
5
|
0.6
|
0.4
|
0.2
|
0.1
|
|
4
|
1.2
|
0.8
|
0.4
|
0.2
|
|
3
|
1.8
|
1.2
|
0.6
|
0.3
|
|
2
|
2.4
|
1.6
|
0.8
|
0.4
|
|
1
|
3.0
|
2.0
|
1.0
|
0.5
|
|
0
|
3.6
|
2.4
|
1.2
|
0.6
|
3. Create a VBA subroutine that:
a. Finds breaks in the data in the first column (for example, time steps are 1 second, but the data jumps from 90 seconds to 95 seconds)
b. Inserts the missing time steps
c. Uses linear interpolation to fill in the missing data for the variable columns.