Figure 2 illustrates the basic forces acting on a suspension bridge. The weight per unit length (w) is 168 kN/meter for the bridge in question. Formulas to calculate the horizontal (H) and vertical (V) forces acting on the bridge tower are 8d where: w is the load applied on the suspension cable per unit length (KN/m), Sis the span of the suspension bridge (meters), d is the maximum dip (meters) of the cable (see Figure 2) and T is the suspension cable tension (N) Bridge Deck Figure 2. Suspension Bridge Task 1: Create a simple VBA program to calculate the values of V, H and T. Produce three outputs in your subroutine and send them back to a separate worksheet that acts as user interface. In your program declare all variables explicitly (use the Option Explicit command as shown in class). Test your program with the following values: w = 168kN/m, S-200 m, d= 20 m. Task 2: Test your program and predict the tension in the bridge cable if w is 173 kN/m, s = 230 meters, d = 24 meters. Figure 2 illustrates the basic forces acting on a suspension bridge. The weight per unit length (w) is 168 kN/meter for the bridge in question. Formulas to calculate the horizontal (H) and vertical (V) forces acting on the bridge tower are 8d where: w is the load applied on the suspension cable per unit length (KN/m), Sis the span of the suspension bridge (meters), d is the maximum dip (meters) of the cable (see Figure 2) and T is the suspension cable tension (N) Bridge Deck Figure 2. Suspension Bridge Task 1: Create a simple VBA program to calculate the values of V, H and T. Produce three outputs in your subroutine and send them back to a separate worksheet that acts as user interface. In your program declare all variables explicitly (use the Option Explicit command as shown in class). Test your program with the following values: w = 168kN/m, S-200 m, d= 20 m. Task 2: Test your program and predict the tension in the bridge cable if w is 173 kN/m, s = 230 meters, d = 24 meters