Road Quantities and Setting-Out Data from AutoCAD to Excel
Last updated 24 October 2026
What RoadPro's report lists: barricade, cone and kerb quantities, signs, marking paint, curve data and the setting-out coordinates of the centre line and edges.
Where the report comes from
Every road drawn with RoadPro carries its own settings, so the quantities are counted from what is actually in the drawing. The report is made when the road is built, and RDR makes it again for any RoadPro road after changes. It comes two ways:
- Tables in the drawing, which you place, for the drawing sheet.
- A CSV file for Excel, saved next to the DWG and named like ROAD-01_RoadPro_Report.csv. Save the drawing before you build the road, so it has a folder to go in. Press F2 to see the full path.
What it lists
| Section | What is in it |
|---|---|
| Summary | General details, geometry, barricades, signs, road ends, chainage |
| Curve data | TC / CT chainage, radius, arc, deflection, E / N |
| Road sections | Every straight and curve with length, edges and area |
| Setting-out | E / N of the centre line and both edges at every chainage |
| Sign schedule | ID, sign, chainage, side, facing and post E / N |
| Widening, junction, corridor | New edge offsets, kerb returns TC / IP / CT with E / N, lanes, median, sidewalks, drains |
| Quantities | Barricades red / white, traffic cones (nos), kerb stone (m) per side, shoulder area |
| Road markings | Edge and lane line lengths, and paint area in m² |
Using it on site and in the office
- Ordering: the quantities give red and white barricades separately, cones by number and kerb stone by length, for each side of the road.
- Setting out: the eastings and northings of the centre line and both edges at every chainage go straight into a total station job. To see them on a map or send them to a client, open the CSV in Excel to KML and save a KMZ for Google Earth on the project's grid.
- Signs: the sign schedule gives every sign's ID, chainage, side, which way it faces and the post's coordinates.
- Curves: the curve data matches the labels RDRAD puts on the plan. To check a curve's tangent length or set it out by deflection angles, use the free horizontal curve calculator.
- Civil 3D: RDLX exports the centre line as a LandXML 1.2 alignment (Insert → LandXML in Civil 3D).
If the file isn't saved
Excel locks a CSV while it is open. Close the old report in Excel, then run RDR again.
Draw your next road with RoadPro