Pile QA Report Command

D_PileQAReport_600ppi    Pile QA Report Command

Command Licensing and Default Menu Location

  • The Pile QA Report command is part of the RPS Tool Shed Toolbox
  • The command is located on the Tool Shed macros menu ribbon
  • The command is located in the Piling menu group

Command Description

Creates a QA Report for pile as builts for Solar Farm projects combining pile design, pile as built machine data and survey QA data to analyze for position, embedment, alignment, twist and elevation errors. Individual error types and combined error analysis delivers an Excel based report plus layers of error data points with attributes that can be exported to ArcGIS for use in ArcPad.

Command Interface Description

The Pile QA Report command dialog looks as follows

The Pile QA Report is generated using styles and tolerances defined in the RPS Settings - Piling Settings - Report. The styles and tolerances are stored into a template. Select the template that you wish to use to run this report.

Pile plans:
This area of the dialog displays all of the Pile Plans that were created using the Import Pile Plan command. Pile Plans = Solar Blocks for Solar Farm Projects. Select the Pile Plans that you want to report by checking the checkboxes associated with those plans in the list.

Within each pile plan, the piles are grouped into “Tables” that run North to South for solar farm projects. The tables are typically imported from CAD files (DWG, DGN, DXF) and are represented as rectangles that surround the piles that go together to make a table. Typically a table can encompass 9, 11 or 13 piles in one table, with a motor pile typically centered in each table array. Select the tables that you wish to report on for the blocks that you selected for the report. You can use the Options button to access the advanced selection methods (Select by Layer, Advanced Select, Select by Elevation etc.).

In the RPS Settings - Piling Settings - Report you can elect to compute Embedment depth using a surface model in the calculations. If you checked that checkbox, then you will be able to select a surface model (typically the Existing Ground surface) here.

File Name:
Select the path and filename for the QA report that will be generated by the command execution. You can brose your PC, the Project Data folder or the RPS Settings folder for the file location by right clicking in the file name / path field.

Command Tips:
In this area of the dialog you will find useful information about the command that will supplement the help system for the command, accessed using the F1 key or the ? from the header bar commands.

Header Bar Commands:
In the header bar of the command dialog, you will find quick access buttons for associated commands that may be useful to you while running this command. Here you will find buttons for Help, RPS Settings, Pile Definition Manager and Import Pile Plan commands.

When you tap apply, XXXXX and the command will ready itself for another selection set and repeat process execution. If you do not want to make a second selection and repeat the process tap Close to finish the process.

Closes the command without further execution.

Example QA Report Output

Below you will find an example Pile QA Report. The report has 7 work sheets in an Excel spreadsheet format. The tabs are as follows

Pile QA Report - Block 5.35Jxls.xls (1.8 MB)



Delta Vertical





In each page of the report, the colored cells show whether or not the tolerances for the quality metric passed (in tolerance), failed but close to tolerance (near tolerance) or failed (out of tolerance).

The summary page provides a summary of all of the data analyzed.

The overall tab provides a summary of the quality metric statuses for each pile analyzed.

The other tabs show all of the results for each pile analyzed with regard to a specific quality metric.

At the top of each report page you will find a summary of that quality metric report.

Video Demonstration

The following video shows how to utilize the Pile QA Report command

Use Case Videos

The following videos show the use of the Pile QA Report command in a work process context

Feedback and Enhancement Requests

If you would like to provide feedback on the use of the Pile QA Report command or to request enhancements or improvements to the command please Click Reply below