One of the common things you have to do when coming up with a schedule of quantities is calculate the length of pipe that a contractor has to lay at a certain depth range. Typically in New Zealand this are 0 to 1.5m , 1.5m to 3.0m and greater than 3.0m. Peter Thomson from MWH explained to me a few years ago how he does did and I have finally gotten around to trying it. Here is how.
1. To start you need invert profiles along the bottom of your pipes in your long sections.
2. Now go to the ANZ Civil Reports and pick profiles and Incremental Station Elevation Difference Report.
right Click and Execute the report.
Note: One issue with this method is that pipes of different diameter are not accounted for without having a separate invert profile for different pipe diameters. Perhaps something that can be improved with a little bit of vb.net coding.