Exporting Pile Coordinates (XLS)

Overview

Piles (XLS) exports the piles of every rack in the drawing. You choose the format when you save:

  • CSV: a flat table of pile coordinates and lengths, for the survey crew and the piling contractor.
  • XLSX: a four-sheet pile procurement workbook that recalculates in Excel when you change its inputs.

Prerequisites

Racks placed, with pile labels in the drawing. Pile lengths are only as good as the terrain under them, so finish grading and Adapt Terrain to Pile before you export. If the drawing has no pile labels, the export stops with Nothing to Export.

Step-by-Step Guide

1. Start the export

Open Export on the Export panel and choose Piles (XLS).

2. Set the length increments

The Pile Export Settings window lists one row per pile position found in the drawing (for example the front and back piles of a fixed table). Enter the production increment for each. Pile lengths are rounded down to the nearest increment, so the exported length matches what the mill cuts. Enter 0 to keep the exact computed length. Click Export.

3. Choose CSV or XLSX

In the save dialog, pick XLSX Files or CSV Files as the file type and save.

4. Use the CSV

The CSV lists every pile with its rack name, pile label, pile point X, Y and Z, pile length, the PV area it belongs to, and the table’s horizontal (N-S and E-W) and vertical (tilt) slopes. Lengths and coordinates are in the drawing’s units.

5. Use the XLSX workbook

  • Inputs: the editable parameters, highlighted: stock pile lengths, minimum and maximum embedment, slope and pre-drill thresholds, and steel unit weight.
  • Pile Schedule: one row per pile with reveal and embedment, the production pile length (the shortest stock length that covers it), off-cut waste and a QC verdict, plus PV area and slopes.
  • BoQ: quantity, total length, steel weight and share for each stock length.
  • Procurement: a single stock length compared with an optimised mix of lengths, with a recommendation.

Tips & Recommendations

  • Every computed cell in the workbook refers to the Inputs sheet. Change a stock length or an embedment limit there and the whole workbook updates.
  • Check the QC column for piles that need pre-drilling or an embedment change before you order steel.
  • In a feet drawing, lengths are written in feet and steel weight in lb/ft. See Working in Feet and US Survey Feet.
  • To find a rack from the spreadsheet in the drawing, search its name with AutoCAD’s FIND command.
  • If the export reports that the file is in use, close it in Excel (or wait for OneDrive to finish syncing) and export again.

Related