QTO - Lengths Report

Last updated: 2024-01-29

Overview

This report will create an Excel spreadsheet that includes station range and 3D lengths of selected entities. The report can be used to report lengths for Polylines, 3D Polylines, Splines, Alignments, Feature Lines, and Survey Figures.

Info: Lengths of 3D objects are not in 2D, they are 3D lengths.

Usage

WisDOT Design tab > Analyze panel > QTO dropdown > Lengths

The tool can also be accessed from the command line: DOTREPORTLENGTHS.

  1. The Lengths Report dialog includes several options for selecting entities. Select Objects to select individual objects in model space. Check All objects on selected layers box to select all objects that are on the same layer as the objects that were individually selected.
  2. Alternatively, the ByLayer box can be check to select objects using a layer filter. Type the layers (comma separated) in to the provided text box to select all objects on those layers. Wildcards may be used. (Example: *Face*)
  3. To verify the objects that will be included in the report, Preview. This will highlight all the selected objects. Enter or Esc to return to the Lengths Report dialog.
  4. A running total length and object count is displayed on the interface. Clicking on the displayed total length will copy the value to the clipboard for use in other applications.
  5. To export a report to Excel, select the reference alignment to be used to compute the object station ranges.
  6. Set the Station Precision and Length Precision values. The running total displayed on the interface reports to the selected Length Precision value.
  7. Provide a name for the Excel worksheet.
  8. Click the folder icon to open the Save File As.. dialog. If the workbook already exists, it will be appended with the specified worksheet.
  9. Create Report

Sample report

Lengths.xlsx