The calculation happens once. But the places it lands are not one. The same tank sits on a different site each time, and the point each reviewer wants to check first differs a little too. So AUTONEST VC hands over the report original as Excel, with the formulas still live. We don't lock it.
Two tanks can share a capacity and a pressure and still be placed quite differently. Indoors or outdoors, what it holds, how it ties into existing piping, what the client has done this way for years — all of it ends up attached to the report.
A program cannot hold every one of those cases in advance. The harder it tries, the more input boxes it grows, and the person using it spends the time filling in boxes their case doesn't have. So we automate what comes up often, and leave the rest open to be edited.
This is not about who is right. The scope each one is responsible for is different, so the place they start differs. At one desk the question is which value the external-pressure verdict was read from. At another it's which thickness the corrosion allowance went into. Somewhere else it's where the joint efficiency was applied, or on what basis the test pressure was set.
Same report, and still the first page people open isn't the same one.
What's needed there isn't a conclusion — it's a path you can follow. "The program produced it" does not end that conversation.
Click a cell in the Excel original and the formula shows where the value came from. You can walk through it with the person asking, and add a line of reasoning on the spot. There's no separate document to prepare just to explain.
The weight breakdown and the heat-duty sheet are Excel for the same reason. The value applied and the basis for it sit on the same row, so "where does this number come from" can be answered by pointing at the table.
What a reviewer doubts first in a strength report isn't the numbers. It's "was this chart really read for this case?" — the red line on the external-pressure chart, the seam lengths on the weld map, the judgment text in the yellow cell. Is it this case's value, or a picture carried over from the last file?
Shops that build reports in Excel mostly run on copying a template. Open the last case's file, change the numbers, redraw the line on top of a captured chart image, and re-count the weld lengths by hand. Miss a single cell and the previous case's value stays — and that doesn't show on the surface.
Every judgment element of an AUTONEST VC report is built fresh from this case's calculated values every run. That is why the original can stay open and still be trusted — the lines and text are not pictures drawn in separately; they move with the calculation.
This is why, in the 3-ton jacket case, the external-pressure design length 1622.57 could be reproduced exactly from the drawing as 1525.35 + 291.67/3. The lines and numbers in the report come from the drawn geometry itself.
An inspector or a client's reviewer is paid to doubt the report. So the output, instead of claiming "it's correct," has to let you follow where each value came from. When the chart line is at the computed coordinate, the weld lengths match the drawing dimensions, and the judgment text doesn't contradict the number beside it — the review gets shorter.
| What | What it's for |
|---|---|
| Excel original | Adjusting the unusual case, and opening it together when someone asks |
| Fixed copy (PDF) | Submission, circulation, records. It looks the same to anyone who opens it |
| Run it again | The same input gives the same result. If an edit goes sideways, you can get back to the original |
Submit the fixed copy; keep the original in your own hands. One run produces both — edit the report in Excel, submit it as PDF.
Since it is open, one point should be clear. Values after you edit the original are your judgment. What AUTONEST VC produced is what the program produced, up to that state. That's why each deliverable carries a fingerprint of the run it came from — so that later, "is this that same calculation?" can still be traced.
A calculation result is material that goes through the designer's own review. This program was not built to take that final judgment over.
Locking it would be easier. Nothing breaks from an edit, and what we produced is all that remains. But the moment it's locked, we have to have guessed every case in the world in advance. The field is always wider than the program.
So the flows that come up often run all the way through automatically, and the last step is left empty for the person using it. For the same reason we never tried to move the whole of the rules into code — why we didn't automate everything.
Q. What is the benefit of getting the strength report original as Excel?
Click a cell and the formula shows where the value came from. You can walk through it with the person asking during review, and adjust an unusual case yourself.
Q. Can I edit the Excel original?
Yes. It is not locked. Values after an edit are the editor's judgment, though; what AUTONEST VC produced is what the program produced, up to that state. Each deliverable carries a fingerprint of the run it came from.
Q. Do I submit the Excel file or the PDF?
Submit, circulate and file the fixed copy (PDF), and keep the original in your own hands. One run produces both the Excel original and the PDF.
Q. Is the judgment line on the external-pressure chart redrawn every time?
Yes. A is computed from the calculated L/Do and Do/t, B is read from the material/temperature curve, and the red (horizontal) and blue (vertical) lines are drawn anew at those coordinates. Change the case and the lines move.
Q. Where do the seam lengths and counts on the weld map come from?
They are calculated from the finalized shell length, jacket length and head sizes. The sketch dimensions, material list and plate layout reference the same final values.
Q. What if an edit to the original goes sideways?
The same input gives the same result. Run it again and you are back to the original.
Related — Edit the report in Excel, submit it as PDF · Why we didn't automate everything — the places we chose not to put into code