Testing Engineering Spreadsheet Formula Ranges
Label cells by role and units. Use the example below to practice the review and record an output that another reviewer can reproduce.
Inputs and Prerequisites
A copy of the calculation workbook, a known baseline and a list of expected inputs.
Review Workflow
- Input rows
- Formula range
- Inserted case
- Linked results
- Label cells by role and units.
- Trace totals back to the range and look for hard-coded values.
- Insert a test row and check that totals and dependent calculations update.
Worked Example
A support schedule lists 2.5, 1.5 and 4.0 kN for 8.0 kN total. Add a 0.75 kN test row. A correct total becomes 8.75 kN. If a linked reaction table still shows 8.0 kN, inspect the source range.
Output Checks and Common Errors
Use a clean copy and verify zero, blank and inserted inputs before relying on a revised workbook.
Official References
- Microsoft Excel structured references
Review how formulas reference table data and adjust to changes in the table.