Horizontal Alignment Formatter
Clean Civil 3D horizontal curve exports, validate design parameters per road standards, and compile structured Excel spreadsheets.
Config & Design Settings
Station Equations
Import Alignment
Columns Checklist & Reorder
Check/uncheck columns to toggle visibility. Click arrows to shift column order.
Design Cross-Check & Validations
Upload a curve file to run structural checks.
Alignment Output Preview
Upload alignment data to render layout previews.
Horizontal Alignment Formatter Documentation
Technical specifications, mathematical formulas, and civil guidelines
1. Functional Purpose
Autodesk Civil 3D horizontal alignment XML/TXT reports output raw coordinate data points at dense station intervals. However, administrative design submittals require a cleaned, structured layout focusing strictly on critical control points: Point of Curve (PC), Point of Intersection (PI), and Point of Tangency (PT). The **Horizontal Alignment Formatter** parses raw alignment text/CSV logs, identifies and extracts these horizontal curve control points, and compiles them into a submission-ready table.
It eliminates the duplicate tangent coordinate listings, structures coordinates into clean sequences, and automatically formats the output with standardized station formats (e.g., 1+000.00). This ensures immediate approval from clients and checking engineers who review geometry submittals.
2. Practical Workflow Instructions
Follow these steps to clean and format your horizontal alignment:
- Export Alignment from Civil 3D: Generate a LandXML or raw text alignment curve report from Civil 3D Toolspace (under Reports Manager > Alignments). Save it as a CSV or TSV file.
- Upload File: Select or drop your exported alignment file into the uploader box. The system automatically scans headers for keywords like Easting, Northing, Station, and Curve Type.
- Set Validation Speeds: Input the design speed of the highway section (e.g., 50 km/h or 80 km/h) to cross-validate design parameters against standard manuals.
- Review & Export: Examine the live cleaned preview showing PC → PI → PT sequences. Click the export button to download a polished Microsoft Excel sheet with Times New Roman formatting and auto-adjusted columns.
3. Mathematical & Civil Engineering Basis
The alignment formatting and geometric validation rely on classical civil engineering circular curve mechanics. Crucial parameters calculated and checked include:
- Tangent Length (T): Determined by the deflection angle (delta) and radius (R):T = R * tan(delta / 2)
- Curve Length (L): The length along the arc between PC and PT:L = R * delta * (pi / 180)
- External Distance (E): Clearance between the PI and the curve center point:E = R * (sec(delta / 2) - 1)
The tool automatically validates the minimum curve radius against the maximum superelevation (e_max) and side friction factor (f_max) defined by **AASHTO Green Book** and **ERA standards**:
If the extracted radius falls below this calculated minimum threshold for the specified design speed, the tool immediately flags a high-severity warning.