CSV Desk — group totals and category lookup test record
Test date: 2026-10-12
Engine: Microsoft Excel for Mac 16.113.2 (26092012), Microsoft 365.
Method: original fictional inputs written through a connected Excel session; native formula values and formulas read back. English range images captured from the native workbook. The surrounding Excel interface was Chinese.
Group totals: 11 input records; 9 numeric amounts, one text amount and one missing amount. Region subtotals 85, 50, 50, 0, 0. One unassigned-region record contributes 25. Numeric total 210. Row and amount reconciliation differences both 0; two unresolved amount issues remain.
Changing C7 from text 30 to numeric 30 changed East from 85/incomplete to 115/complete. Restoring text returned 85/incomplete.
Category lookup: 8 input rows, 7 mapping rows; 4 ready, 1 missing category, 1 duplicate mapping, 1 unmapped and 1 missing code. Literal A*1 maps to Special; a01 maps to Office under the declared case-insensitive contract.
Changing the second A04 reference to A05 released A04 as Hardware. Filling the empty A03 category with Services released A03. Both changes were restored and all original results rechecked.
Scope: native worksheet formulas and recalculation. Not a CSV import/export UI test; not a Windows or English-interface test; no claim of independent reader trials.
CSV does not store Excel cell types. For the totals exercise, follow input_type and set C7 to Text before entering 30; keep C9 empty. Other amounts must be actual numbers. The input_type column documents test setup; formulas inspect column C itself.
All files are UTF-8 with BOM, comma-delimited, with one header row. Blank expected cells are deliberately empty. Expected files are reference answers, not inputs.
