QTO - Culvert and Storm Sewer Table

Last updated: 2021-12-10

Overview

Generates the Storm Sewer Pipes Quantity report in .xlsx format. This report combines QTO functionality with pipe network data. It is intended to be used with Pipe networks created from the WisDOT custom parts lists.

Warning:

Pipe network parts that do not have a valid bid item attached will not be included in the report output.

Pipe networks created from parts lists other than WisDOT parts lists may not produce an accurate result.

Usage

WisDOT Design tab > Analyze panel > QTO dropdown > Culvert and Storm Sewer Table

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

Requirement: Do not combine Storm Sewer and Culvert Networks when creating the quantities table. Culverts have a different report compared to the Storm Sewer networks.

  1. Select the pipe networks from the list for which the report is desired.

    • Multiple networks may be selected. Use Shift or Ctrl buttons to select multiple pipe networks.

    • The report can be run multiple times to create the desired pipe network reports.

  2. Select the Report Type:

    • Storm Pipes: Intended for Storm Sewer Networks and creates a table containing the Storm Sewer Pipe quantities.

    • Storm Structures: Intended for Storm Sewer Networks and creates a table containing the Storm Sewer Structure quantities.

      • Adjust the Ring Height if necessary. Default is 6 inches.

    • Culverts: Intended for Culvert Networks and creates a table containing the Culvert Quantities.

  3. Select the File Icon to specify a file name and location to save the file.

Sample report

StormSewerPipes.xlsx