Background: I have a length of road which has been picked up by a group of surveyours. The centre line of the road has a few areas which need to be re-graded to level it out.
I have a data series of uneven intervals that represents the running chainage (distance in metres)
A1:A214, or 2103.974:2855.039. Each interval has a corresponding height B1:B214, or 493.616:503.870.
I have plotted these values on a line graph and the level that need to be regraded are quite obvious.
I would like to know if there is a way to regrade this using excel by giving a new height corresponding to the running chainage?
Please help if you can.
Bookmarks