Plate Load Test Report Xls Work May 2026

When you send an XLS file, the recipient might see #### or broken charts. Always save a final copy as PDF. Use File > Export > Create PDF directly from your Summary tab.

Your first sheet should mirror your field data sheet. Include columns for:

If the curve shows a clear failure point (break): plate load test report xls work

Set up columns as follows:

| Load Increment | Load (kN) | Pressure (kN/m²) | Dial Gauge 1 (mm) | Gauge 2 (mm) | Gauge 3 (mm) | Time Elapsed (min) | |----------------|-----------|------------------|-------------------|--------------|--------------|---------------------| When you send an XLS file, the recipient

Pro Tip: Use data validation to restrict time entries (e.g., 0, 1, 2.5, 5, 10, 15, 30 min intervals). Add a cell for Plate Area (A) and Plate Diameter (B) so pressure auto-calculates: =Load/(PI()*(B/2000)^2) (adjust units as needed).

While there are expensive software packages out there, an Excel-based (.xls) reporting system offers three unbeatable advantages: Your first sheet should mirror your field data sheet

Don’t calculate Pressure (kN/m²) manually. Use a simple formula: = (Load_kg * 9.81) / (1000 * Plate_Area_m2) Link this to your plate diameter (e.g., 300mm, 450mm, 750mm) so the sheet auto-updates if the plate size changes.

Let's build a master template. Open a new Excel workbook and follow along.