B31.3_Wall_Thickness_Sample.xlsx SAMPLE WORKBOOK
SHA-256 28a815ee b5a86f43 6546c770 2ea8702f f1fc66cb 77d15a42 d511af50 8ac260d1
41 formula cells · 8 unique formulas · 2 worksheets · 12 CMLs
3 assessor red flags · 2 more findings
-
Calc!F33 IEEE 754 precision drift
Calc!F33 =IF(C33-D33>=0.1,"ACTION","NO ACTION")(CML-04: 4.72 mm → 4.62 mm). The wall loss is exactly 0.10 mm on paper. Excel stores 0.099999999999999645, so the cell returns NO ACTION at your 0.10 mm action threshold. -
Calc (sheet) + Inputs!C9 Unlocked formula cells
Sheet Calc is not protected, so all 41 formula cells can be overtyped and its "Locked" cells are not locked. Inputs!C9 (quality factor E) has no data validation: it accepts 0.85, 1.00 or 10.
-
G14 · H22 · H23 · F30:F41 Buried hard-coded constants
0.4 (Y) in Calc!G14, 1.5 (corrosion allowance) in Calc!H22, 0.875 (mill under-tolerance) in Calc!H23 and 0.1 (action threshold) in Calc!F30:F41: 4 values with no source, in 15 formulas.
Also found
Display ≠ decision: Calc!H22 prints the minimum wall as 4.5 mm and stores 4.5053571428571431. G35 compares the stored value, so CML-06's 4.50 mm reading is rejected while the sheet shows 4.5 against 4.5.
Text accepted as a reading: "N/A" for CML-07 returns ACCEPT in Calc!G36, because Excel ranks any text above any number. MIN(D30:D41) skips it, and its wall-loss and interval-action cells show #VALUE!.
Ran in this tab · 0 requests carrying workbook data · 0 KB of your workbook uploaded