Spreadsheet: Mat Foundation Design

But the crown jewel was the . Most engineers design top and bottom rebar uniformly—wasting steel. Maya’s spreadsheet sliced the mat into east-west and north-south design strips. It calculated the maximum positive and negative moment in each strip, then suggested different rebar spacing for the middle strip versus the column strips. It even accounted for development length, splicing, and temperature steel.

Six months later, the Riverview Medical Center’s mat foundation was poured—12,000 cubic meters of concrete in a single 18-hour continuous operation. Sensors embedded in the mat streamed data back to Maya’s office. mat foundation design spreadsheet

The hardest part was . In a mat, every column tries to punch through the slab like a fist through a cardboard box. Maya wrote a Visual Basic for Applications (VBA) function called CheckPunchingShear(col_load, col_dim, d_effective) . It iterated through every column, calculated the critical perimeter, and spat out a utilization ratio. If any ratio exceeded 1.0, the entire sheet froze until the user increased the mat thickness. But the crown jewel was the