Overview
PVX.AI exports the pile data for every rack in your design. Two formats are offered: a flat CSV of pile coordinates for the field, and a live four-sheet Excel procurement workbook.
Step-by-Step Guide
1. Review pile data on screen
Rack slope values are stamped on the racks in the drawing, alongside the rack labels. For a visual check, Rack Slope Analysis on the Layout panel colors every rack by the slope beneath it.
2. Run the export
Open the Export dropdown on the Export panel and choose Piles (XLS). The save dialog offers CSV and XLSX.
3. CSV: the flat pile table
The CSV lists every pile with its rack name, pile label, pile point X, Y and Z, pile length, boundary (the PV Area it belongs to), and the table’s horizontal (N-S and E-W) and vertical (tilt) slopes.
4. XLSX: the procurement workbook
The XLSX is a live, four-sheet pile procurement optimizer that recalculates in Excel as you edit it:
- Inputs: editable parameters (stock pile lengths, minimum and maximum embedment, slope and pre-drill threshold, steel unit weight), highlighted in the sheet.
- Pile Schedule: one row per pile with reveal and embed lengths, the Production Pile Length (the smallest stock length that covers it), off-cut waste, and a QC verdict, plus boundary and slopes.
- BoQ: quantity, total length, steel weight, and share for each stock length.
- Procurement: a single stock length versus optimised mix comparison, with a live recommendation.
5. Find a table in AutoCAD
To locate a table by its label from the spreadsheet, use AutoCAD’s FIND command.
Tips & Recommendations
- Every computed cell references the Inputs sheet, so changing a stock length or an embedment limit recomputes the whole workbook instantly.
- Share the CSV with the field team to streamline pile driving.
- Check the QC column for piles that need pre-drilling or an embedment adjustment before ordering steel.
- The coordinates can be used with GPS for on-site pile location verification.