Prepare an Excel table showing the design elevations every 100 feet.
Use stationing of 0+00 for the beginning, and 7+00 for the end.
Place the pipe at a gravity drainage slope of 3% towards station 7+00.
The invert elevation of the pipe at 0+00 is 6375.00'.
The pipe has an outside diameter of 1' and a wall thickness of 1".
Your design needs to include the following:
a) List the elevations for the top of the pipe for the plus stations (0+00, 1+00, 2+00,
3+00, 4+00, 5+00, 6+00 and 7+00) *.
b) Calculate the invert elevation for the pipe at station 7+00.
Fig: 1