In: Civil Engineering
A 1000-ft vertical curve connects a -1% grade to a -3.5% grade. If the vertical tangents intersect at sta. 38+60.24 and elevation 1,400.13 ft, develop an Excel spreadsheet to calculate the elevations of the grade line at each station from sta. 31+00 to 45+00. Include the elevations of the PVC and PVT.