I will audit and update a structural calc spreadsheet to current codes
Structural Calc Spreadsheet Audits, ASCE Updates, and Structural CAD
About this Gig
Engineering firms rely on in-house spreadsheets that were built years ago, updated by people who've since left, and never independently checked. When your jurisdiction moves to the 2024 IBC, every one of them needs to be confirmed against ASCE 7-22 and the current material codes.
I audit your calc tools against independent hand calculations and published design examples, then document exactly what I found:
- Formula and unit errors
- Outdated code provisions and load factors
- Edge cases where the sheet silently fails (zero, negative, out-of-range inputs)
- Missing checks a reviewer would expect
On the Premium package I also update the sheet to the current code edition and deliver a test-case set and a clause-by-clause map, so you can re-verify it yourself any time.
Works with: Excel/VBA, Mathcad Prime, Python. Steel, concrete, wood, masonry, foundations, wind/snow/seismic loads.
For licensed engineers and firms. This is not stamped engineering: your engineer of record reviews and accepts all deliverables. Please message me before ordering so we can confirm scope.
Platform:
Excel
•
Microsoft Office
•
Other
Development technology:
Excel
•
Other
Expertise:
Formatting
•
Fixing
•
Formulas
•
Functions
•
Macros
My Portfolio
FAQ
Do you stamp or seal the calcs?
No. This is a review and update service for licensed engineers and firms, not stamped engineering. Your engineer of record reviews the findings and accepts any changes before the tool is used on a project.
What file types do you work with?
Excel (including VBA macros), Mathcad Prime and Python scripts. If your tool is built in something else, message me first and I'll tell you whether I can check it properly.
How do you check the results?
I rebuild the key equations independently, run your sheet through benchmark cases from hand calcs and published design examples, and test edge cases like zero, negative and out-of-range inputs. Every difference is listed in the findings report.
Will my files be kept confidential?
Yes. Your files are used only for your order and are never shared or reused. I can delete them after delivery on request. If your firm needs an NDA, send it over before you share anything.

