Guides — Spreadsheets

Tonnage math in a spreadsheet vs. Precision Form

By Jon Chacon · October 22, 2026

Most shops doing tonnage math outside a program are doing it in a spreadsheet somebody built once, or off the chart on the wall. So let’s be straight about the spreadsheet first, because it’s better than its reputation.

What a spreadsheet does well

• It’s free, and it’s already there. No purchase, no install, no account.
• It’s flexible. If you can write the formula, you can figure the job — odd sizes, odd materials, one-off math a program might not cover.
• You own it. It’s your file, on your computer, and it works the day the internet doesn’t.
• For the person who built it, it works. If you wrote the sheet and you know what’s in it, it’s a real tool. The tonnage math in a good sheet is the same math everywhere — tonnage doesn’t care where it’s figured.

Where it breaks down on the floor

• The assumption you can’t see. Somewhere in the sheet there’s a material strength baked into a formula — mild steel, figured once, years ago. The stainless job runs through the same sheet and nobody sees the one cell that matters.
• It doesn’t know your dies. The sheet gives you a tonnage for whatever opening you type in. It doesn’t know which dies you own, which one fits the flange, or that the die you’re about to grab needs half again the force of the one you should grab.
• No warning on short parts. Total tonnage can look fine while tons per foot — the number that actually cracks tooling — runs way over on a short, thick part. Most sheets never compute it.
• It lives on one computer. The one in the office. The setup figured at 9 in the morning is not in the operator’s hands at the brake at 2, and it’s not in the night shift’s hands at all.
• Nothing is saved against the job. Last time this part ran, somebody figured all of this out — and it’s in a file called Final_v3 on somebody’s desktop, if it’s anywhere. Next run, you figure it all again.

The wall chart, briefly

Everything above goes double for the chart. It’s drawn for one material, it knows nothing about your dies or your machine, and it can’t warn you about anything. It was a fine tool when the alternative was long division, and for a lot of shops it’s still the backup. Just know it’s answering a smaller question than the one you’re asking at the machine.

What Precision Form does instead

Precision Form isn’t different math. It’s the same tonnage calculation with the shop floor put back around it:

• It works from your tool inventory. The setup is figured against the dies and punches you actually own, and the die it picks is the safest fit — not just the first one that forms the part.
• It checks the whole job. Total tonnage and tons per foot, against the tooling and the machine class, planned at a 1.5× safety factor.
• Setups save against the job. Run the part again next month and the setup is there — same die, same numbers — for whoever is on the brake.
• Tooling gets QR labels. An operator can scan a die at the rack and pull up its inspection record, instead of guessing at a rack of look-alike steel.

That’s the difference on a real part: quarter-inch A36, 61 inches long. The app called 82.4 tons total, picked our #37 die at 84.1 tons, and flagged the #35 in the same rack at 130.8 tons — before anybody touched the machine. A spreadsheet gives you whichever of those numbers you happen to ask for. The tool’s job is asking for all of them. The full bend is written up in How press brake tonnage is calculated.

Questions we get asked