Good morning,
I am trying to find a way to change the precision of the polyline elevation editor. When our points come in from the field crews, the elevations are reported to the third decimal place. Once field to finish is ran, and we are labeling the pipe runs with length and slope percentage, depending on the length of the pipe, the rounding can drastically change the slope. Is there a way within Polyline Elevation Editor, or somewhere in the settings, to round these elevations to the nearest hundredth and to get the software to read it that way? I have seen the option to change decimals reported within the elevation editor, but the software still will read the entire elevation, regardless of how many decimals are shown on the screen.
For example, we had a run that was 8.81' with one end at an elevation of 20.641', and the other at 19.837'. Using the polyline elevation editor, it reports the slope at 9.13%; however, our as-built report will only show the pipe length at plus/minus 9', and elevations at 20.64' and 19.84'. Using these values, the slope would be 8.89%. This difference could throw up a red flag to the clients.
Hopefully this all makes sense, and any help is appreciated!
From your example the polyline elevation editor is doing it correctly. The problem stems from the change of the pipe length in your asbuilt report. Using the correct pipe length you will get the correct slope.
In your case, you might want to bring your points in already rounded to force the label to match what someone could calculate from the map labels.
In Excel:
- Open your point file (csv or txt).
- Add a column for your rounded elevations.
- In the first row, enter this formula, assuming it is PNEZD formatted:
- =text(D1,"0.00")
- Copy that formula down to all the rows, using your favorite method.
- Select the whole new column. Cut.
- Select the original elevation column. Paste Special: Values.
- Delete the now-blank new column.
- Save As to rename your file to show it has rounded values.
A better option, however, is to let the computer label accurately, and include a survey note that pipe length and invert elevation labels have been rounded from field measurements for legibility.