Complete AI Training
Sign inGet my AI kit

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

AI agent for structural engineers

Calculation Spreadsheet Verification Agent

Test every calculation spreadsheet against known cases and catch formula changes before a version is released

Quality controlReal estate and construction
See how it worksGet access
Calculation Spreadsheet Verification Agent: what goes in, what the agent does and what you get

What it does

Spreadsheet errors can survive for years and flow into designs. The agent runs each calculation sheet against test cases with known answers and compares the results with hand checks. It scans the formulas and flags any cell that changed since the last approved version. If a result differs, it logs the difference and the cell involved, and notes which tests failed. After the engineer fixes the sheet, the agent reruns all tests. It keeps a record of each version and its test results. The engineer approves release of a sheet version. Edge case: a unit conversion is changed from 12 to 10 in one cell, and the test with a known beam moment fails.

How it works

Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.

Start and resultWhat it doesA check on its own workWaits for your OKGoes back and retries
Yes, continueYes, continueApprovedNoNo 1 STARTS WHEN Sheet edited or release requested 2 USES A TOOL Load the sheet and the test case library 3 USES A TOOL Compare formulas with the last approved version 4 DOES List changed cells and ask for a note 5 USES A TOOL Run each test case through the sheet 6 CHECKS THE RESULT Does every result match the known answer withintolerance? If not: Log the failing case and cell, and report to theengineer. Back to step 4. 7 DOES Wait for the fix and rerun all tests 8 CHECKS THE RESULT Do all tests and hand checks now pass? If not: Repeat the diagnosis on the remaining failures.Back to step 5. 9 DOES Write the version record with tests and changes 10 YOU APPROVE Engineer approves release of the sheet version 11 RESULT Approved version with test record
Read the steps as a list
  1. Sheet edited or release requested
  2. Load the sheet and the test case library
  3. Compare formulas with the last approved version
  4. List changed cells and ask for a note
  5. Run each test case through the sheet
  6. Does every result match the known answer within tolerance?If not: Log the failing case and cell, and report to the engineer. Back to step 4.
  7. Wait for the fix and rerun all tests
  8. Do all tests and hand checks now pass?If not: Repeat the diagnosis on the remaining failures. Back to step 5.
  9. Write the version record with tests and changes
  10. Engineer approves release of the sheet versionThe agent waits here for your OK.
  11. Approved version with test record

How it decides

A version is releasable only when every test case matches the known answer within tolerance and no formula changed without a note.

  • Pass only when every test is within tolerance (default 0.5%)
  • Flag a formula change not listed in the change note
  • Rerun every test after any fix, not only the failing ones
  • Never overwrite an approved version

Make it yours

Every agent is a starting point. You choose these settings for your own situation.

  • Tolerance (default 0.5%)
  • Test case library location
  • Sheets covered
  • Release approval rule

What keeps you in control

It always asks you first

  • Engineer approves release of a sheet version
  • Engineer approves changes to the test cases

Hard limits

  • Never release a sheet that fails a test
  • Do not edit the sheet itself

It stops when

  • Done: all tests pass and the version is approved
  • Stop: no test case exists for the sheet's main output

Set it up

We guide you through the set-up, step by step

Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.

10 minto set it up in your AI
5 AIsChatGPT, Claude, Copilot, Gemini, Grok
  • One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
  • The agent then walks you through connecting your own data, one source at a time
  • A downloadable copy with the flow chart, the rules and the full guide
Get access to this agent

An example run

What happensA beam sheet was edited and a cell changed from 12 to 10 in the moment conversion. The first test returned 68 kip-ft against a known 82. The agent logged the cell. The engineer fixed it, but the shear test then failed by 3% due to a rounded constant. The agent looped, the constant was fixed, and all tests passed.

More agents for structural engineers

Quality control · Analysis

Aircraft Structural Load Case Check Agent

A load and margin table in which every margin has been independently recomputed and every low margin explained.

11 steps2 checks2 jobs
Risk management · Real estate and construction

Consultant Drawing Coordination Agent

Close every inter-discipline clash before construction documents are issued.

11 steps2 checks2 jobs
Quality control · Analysis

Construction Drawing Dimension Conflict Agent

Resolve every dimension conflict before material is ordered or cut.

11 steps2 checks5 jobs
Risk management · Decisions

Load Path Check on Renovation Agent

Show that every member along the load path can carry the new loads, or propose a fix that does.

11 steps2 checks1 job