Excel cable car project ENG

If the cable car is further than 30 feet from the nearest tower, its velocity is given by: Velocity = 0.625 + 0.12 d - 0.00025 d2 (ft/sec) You want to compute the velocity of the car from the time it starts moving from the first tower until it reaches the second tower, in increments of 5 feet. Prepare a spreadsheet that tabulates (in columns) the following: 1. Include a title on your spreadsheet. Ensure all data columns are centered justified and are appropriately titled with relevant units (figure 1). fo Excel Cable car Propa Excel Cable Car Project Figure 1: Sample Final Excel Spreadsheet 2. Column 1: Use an equation to determine the distance of the cable car from the first tower, in increments of 5 feet starting at 0 feet. Display distances with zero decimal places. 3. Column 2: Use a formula with a nested IF statement to determine the number describing the nearest tower. Your nested IF statement should return a 1, 2 or your first name (1 = closer to first tower, 2 = closer to second tower, first name = the midpoint of the cable). Display the tower number as a cardinal number (i.e., zero decimal places). 4. Column 3: Use a single IF statement to calculate the distance from the nearest tower. No nested IF statement is required. Reference information from column 1 and 2 in your IF statement. For example, your IF statement may read like, IF tower 1 is closer (column 2 information), than the distance is column 1, else the distance is calculated from column 1 distances. 5. Column 4: Use a single IF statement and the given velocity equations to calculate the velocity of the cable car to 1/1000th of a foot/sec (Format to 3 decimal places) over the entire trip in 5-foot increments. 6. Columns 5 and 6: Use MAX and MIN formulas to determine the maximum and minimum velocities of the cable car. Format results to 3 decimal places. 7. Back in Column 4: Use conditional formatting to change the color of the cells for the following conditions