Need a Dynamo script for QTO/Schedules in Civil 3D. Anyone

Job Requirement / Scope of Work

Civil 3D / Dynamo Programmer – Automated QTO Extraction and Reporting Tool

Develop a Dynamo script for Autodesk Civil 3D that automates the extraction and summarization of quantity takeoff (QTO) data from mapping and CAD sources.

Functional Requirements
Map Query Import
Utilize Civil 3D Map Query functionality to import entities into a new drawing (DWG).
Filter imported entities based on layer criteria, specifically layers whose layer name and/or layer description contains the keyword "QTO".

Drawing Processing

Create a new working DWG and populate it only with qualifying entities identified through the query process.
Process all imported entities and categorize them by layer.

Quantity Takeoff Calculations

Calculate and summarize the following quantities by layer:
Total linear length (for linework and polylines)
Total area (for polygons, hatches, and closed entities)
Total item count (for blocks, points, and count-based objects)
Automatically determine and assign the appropriate unit of measure (LF, SF, EA, etc.) based on entity type or layer configuration.

Reporting and Table Generation

Generate one or more CAD tables within the DWG containing summarized quantity information.
At a minimum, each table shall include the following fields:
Layer Name Layer Description Quantity Total Unit
Layer Name Layer Description Calculated Quantity LF / SF / EA
Excel Export Compatibility
Format results so they can be:
Exported directly to Microsoft Excel, or
Easily copied and pasted into an Excel spreadsheet while retaining tabular structure.
Optional enhancement: create an automated XLSX export directly from Dynamo.
Deliverables
Dynamo script (.dyn) compatible with Autodesk Civil 3D 2026 and Dynamo 3.7.
Source code and documentation describing workflow, inputs, and configuration requirements.
Sample output DWG with generated quantity tables.
Excel-compatible output file or export routine.
Preferred Enhancements
User-configurable keyword filtering (default = "QTO").
Support for multiple quantity categories and units.
Pay item mapping fields for future integration with MnDOT quantity and estimating workflows.
Automated CSV/XLSX export with no manual intervention.

Objective: Create a repeatable workflow that automatically extracts QTO-designated CAD entities, calculates quantities, summarizes results by layer, and produces Excel-ready reporting for estimating and quantity takeoff purposes. Included is a sample file that was manually created with a Map query of multiple project files all overlapping.
Pay is flexible and can lead for other projects in the future. read less