Mat Foundation Design Spreadsheet May 2026

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.

Maya Vesper was a senior geotechnical engineer, but on a humid Tuesday in July, she felt like a fraud. She was staring at a crack. Not just any crack—a hairline fissure running through the corner of a newly poured shear wall at the Oakwood Towers site. mat foundation design spreadsheet

Maya didn’t stop at v1. She released v2 with a tool that could run 500 different mat thicknesses and show a cost-vs-safety curve. v3 added a Soil-Structure Interaction module that allowed for variable subgrade modulus. v4 included a Construction Stage Check to handle partial loading before the superstructure was finished. The hardest part was

Last night, she’d found a rounding error in a moment calculation from two weeks ago. That error meant the rebar spacing was off by 15%. The crack in the wall wasn't structural—yet—but it was a warning. It iterated through every column, calculated the critical

Maya smiled. "Four minutes, including the re-run."

"This foundation was designed not just with numbers, but with the understanding that a crack in the ground is a story waiting to be told. Listen to the soil. It will never lie."

She added a —a simplified elastic layer method that estimated immediate and consolidation settlement. She linked it to the soil pressure grid. If settlement exceeded 25 mm, the spreadsheet would automatically suggest increasing the mat’s plan dimensions.