Engineering Calculation Sheets in Excel: Units, Interpolation in Design Tables, Iteration, Tolerance Stack-Ups & Design Checks

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Lay out Halvard's base-plate sheet like a checkable calculation: convert millimetres with a named constant, take off the bolt holes, work out the net mass and report it in the unit the reader asks for.
• Read a fictional strength factor at 235 °C from a table that only lists every 50 °C: find the bracketing rows with MATCH, fetch x₁, x₂, y₁ and y₂ with INDEX, interpolate, and count the temperatures that lie outside the table.
• Read the fictional property K at 230 °C and 27 bar from a table with rows every 50 °C and columns every 10 bar: find both bracket positions, interpolate along the pressure in two rows, then once more along the temperature.
• Solve a fictional implicit formula step by step: start the iteration chain, measure the change per step, find the first step that meets the tolerance and report the converged answer.
• Add up a fictional six-part stack along a shaft: the nominal gap with direction signs, the worst-case tolerance, the statistical RSS tolerance and the share each part has in the RSS result.
• Turn six fictional demand and capacity pairs into utilisation ratios, find the governing utilisation and the check it belongs to, and give each row a Pass, Review or Fail status.
• Vary the span of a fictional beam from 2 to 7 m, calculate the utilisation for each span, find the first span in the table that fails, solve the exact limit by formula and plot the curve.
• Compare Mira's key results with Tomás's independent hand checks, count the results inside the allowed deviation, build the sign-off line from an unsorted revision log and chart the deviations.