Turn a PDF calc package into a working, checkable spreadsheet
Use an AI coding assistant to rebuild a PDF calculation package (for example a connection plate redesign) as a spreadsheet: inputs in highlighted cells, then one check per block (gross yielding, rupture, combined axial and bending, buckling, block shear), each matched to the PDF value.
Structural Engineer · Structural · OpenAI Codex · Microsoft Excel
Content updated · Tool links listed below; vendor features and pricing change, so confirm with the vendor
Short answer
Use an AI coding assistant to rebuild a PDF calculation package (for example a connection plate redesign) as a spreadsheet: inputs in highlighted cells, then one check per block (gross yielding, rupture, combined axial and bending, buckling, block shear), each matched to the PDF value. Start here: list every input in the PDF (geometry, material, demands) and put them in one highlighted input block. Keep a person in the loop: The spreadsheet reproduces a calc; it does not validate it. Adequacy is the engineer of record's call.
The problem
Turn a PDF calc package into a working, checkable spreadsheet. This is a common, time-consuming task for a structural engineer.
What this workflow does
Use an AI coding assistant to rebuild a PDF calculation package (for example a connection plate redesign) as a spreadsheet: inputs in highlighted cells, then one check per block (gross yielding, rupture, combined axial and bending, buckling, block shear), each matched to the PDF value.
How it works: AI drafts or analyzes. A person operates the tools, checks the work, and takes action.
Your checkpoint: The spreadsheet reproduces a calc; it does not validate it. Adequacy is the engineer of record's call.
Before you start
- Access to the named tool; confirm license, version and cost with the vendor.
- A small, non-confidential sample to try the workflow on first.
- A qualified person to review the output before it is used.
Tools and access
Follow the steps
- List every input in the PDF (geometry, material, demands) and put them in one highlighted input block.
- Rebuild one limit state at a time; cite the spec section next to each formula.
- After each check, compare the spreadsheet result to the PDF value and stop on any mismatch.
- Ask the assistant to explain any difference before changing a formula.
- Vary one input and confirm only the expected cells change.
- Have a second engineer check the finished sheet against the original package.
Try a small example
Replace the bracketed fields with your own project details. No tested sample run is published for this workflow yet.
Sample input
Fill in the bracketed [fields] in the text below with your project data.
Starter prompt
Here is one check from a PDF calc package: [paste the step]. Rebuild it as spreadsheet formulas referencing named input cells, cite the spec section, and show the value you expect so I can compare it to the PDF. Do not decide whether the member is adequate.
Expected output
Not published yet. Treat any output as a draft and check it against the source documents.
Check the result
- Every value, citation or quantity traces back to a source document.
- Missing information is marked as missing, not filled in.
Limits and recovery
- The spreadsheet reproduces a calc; it does not validate it. Adequacy is the engineer of record's call.
- Check your organization’s data policy before sharing project files with third-party tools.
Stop or switch when: The source cannot be verified, permissions are missing, or the result contains unsupported facts.
Frequently asked questions
How do I turn a PDF calc package into a working, checkable spreadsheet?
List every input in the PDF (geometry, material, demands) and put them in one highlighted input block. Rebuild one limit state at a time; cite the spec section next to each formula. After each check, compare the spreadsheet result to the PDF value and stop on any mismatch. The full step list is above.
Does this use an AI agent or regular software?
It is labeled AI assists: AI drafts or analyzes. A person operates the tools, checks the work, and takes action.
What tools do I need?
OpenAI Codex, Microsoft Excel. Confirm license, version and cost with the vendor, and try it on a small non-confidential sample first.
Can I use the output without checking it?
No. The spreadsheet reproduces a calc; it does not validate it. Adequacy is the engineer of record's call.
Has this workflow been tested?
Based on our own use · prototype. Written from a workflow we ran ourselves (prototype stage). Results are not independently verified; specifics are generalized and no project data is published.
Evidence and maintenance
Written from a workflow we ran ourselves (prototype stage). Results are not independently verified; specifics are generalized and no project data is published.