Reference no: EM131858464

Assignment

1. Create two VBA functions:

a. One that calculates the positive root of a quadratic formula (y = ax² + bx + c)
b. One that calculates the negative root of a quadratic formula (y = ax² + bx + c)

2. Create a VBA function that:

a. Calculates the free flow speed of a basic highway segment (FF = 75.4 - f_LW - f_LC - 3.22 * TRD^0.84)

b. Where

i. FFS - free flow speed
ii. f_LW - adjustment for lane width (from 1" table below)
iii. f_LC - 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.