You are at a site in Mumbai. The soil is medium sand. You performed a PLT with a 300mm plate. Field readings:

q=Applied Load (kN)Area of Plate (m2)q equals the fraction with numerator Applied Load (kN) and denominator Area of Plate (m squared ) end-fraction

Several platforms offer specialized spreadsheets that automate the calculation of bearing capacity and settlement from raw field data.

Safe bearing capacity: Use settlement corresponding to 5 mm or 1/3 of failure load, whichever is smaller.

You can copy this layout directly into Excel. The workbook should contain at least 3 sheets: