Foundation Design Spreadsheet in Excel

I need an engineer who can translate my structural design workflow into a clear, error-proof Excel workbook that covers two foundation types: Grade beam and Mat.

The Grade beam tab must handle:
• Load distribution calculations across beams and supports
• Reinforcement details with automatic bar sizing and spacing checks
• Soil interaction analysis that flags overstress conditions against the allowable bearing capacity

The Mat foundation tab must provide:
• Load distribution calculations for column grids and wall loads
• Reinforcement detailing that adapts to punching and flexural demands
• Settlement analysis driven by soil modulus and thickness inputs

I will supply all necessary design parameters, material properties, and any template sketches. Your job is to build the spreadsheet with clear input cells, locked calculation areas, and a concise results summary for quick review. Consistent units, colour-coded sections, and brief in-sheet notes are important so anyone on the team can follow the logic.

Formulas should rely on native Excel functions; VBA is welcome only if it meaningfully streamlines repetitive checks. Once complete, we’ll run a sample project together to verify that all outputs match my hand calculations.