BRIGHTLY USEFUL: SYNTHETIC REPORT GUIDE
Local demonstration, September 2026. All data is fictional.

FIELDS
id: Synthetic job identifier. Required.
customer: Fictional customer label. Required.
status: completed or cancelled. Required.
amount: Nonnegative numeric USD amount. Required, including cancelled jobs.

RULES, IN ORDER
1. Remove extra exact duplicates based on all four field values. The first copy remains.
2. Move records missing or invalid in any required field to the visible exceptions view.
3. Keep valid completed and cancelled records.
4. Sum only completed amounts. Cancelled jobs contribute zero to completed value.

Text comparisons preserve case. The first issue is shown in the order: ID, customer, status, amount. After repairing it, refresh to check for another issue. A numeric amount of zero is valid; a missing amount is not.

This sample does not resolve conflicting records sharing a job ID. Distinct valid records are both retained even when their IDs match. A real report needs an agreed conflict rule. No tax or other accounting adjustments are implied.

EXPECTED RESULTS
Measure                     Sample 01     Sample 02
Raw rows                    52            62
Extra exact duplicates      4             4
Invalid unique records      3             3
Valid records               45            55
Completed jobs              40            50
Cancelled jobs              5             5
Completed value (USD)        7,000         8,250

RECONCILIATION
Raw = extra duplicates + exceptions + valid.
Valid = completed + cancelled.
Sample 01: 10*100 + 10*150 + 10*200 + 10*250 = 7,000.
Sample 02 adds 10 completed jobs at 125 = 1,250 more.

REFRESH IN THE BROWSER EXAMPLE
Open Examples > Every row has a reason.
Choose Sample 01, inspect all raw rows, then inspect Exceptions & duplicates and Reconciliation checks.
Choose Sample 02. Confirm 62 raw rows, 50 completed jobs, and 8,250 completed value.
Download each raw CSV; it matches the selected fixture.
Reset sample returns to Sample 01 and the source view.

REFRESH THE EDITABLE WORKBOOK
The companion brightly-useful-report.xlsx contains Report, Review, Input and Samples sheets.
1. Save a working copy. Clear the contents of Input A7:D206, keeping the sheet rows and headers.
2. Copy Samples G7:J68 (Sample 02) and paste values only into Input A7.
3. Keep IDs/customer/status as text, amounts numeric, and missing cells blank.
4. On Report, confirm the Sample 02 results above and zero reconciliation differences.
5. Filter Review by Disposition: Exception or Duplicate. Correct source data, not the formulas.
6. To restore Sample 01, clear Input A7:D206 and paste Samples A7:D58 into Input A7 as values.

The file supports 200 input rows. Fully blank slots are unused. Do not paste beyond row 206, delete worksheet rows, sort Review or overwrite calculated cells. Recalculate after pasting if the spreadsheet application uses manual calculation mode.

CHANGE-INPUT CHECK
Starting with Sample 01, change Input D12 from 100 to 137.25. Completed value becomes 7,037.25 with unchanged counts. Numeric zero remains valid and produces 6,900.00. Clearing D12 instead creates one extra exception and leaves 39 completed jobs. Restore D12 to 100 afterward.

The workbook uses formulas and a native chart. It has no macros, external connections or Power Query. Formula behavior was checked in the authoring calculation engine and after XLSX reimport; a live Excel desktop run has not been recorded. These are synthetic demonstrations, not accounting assurance or client results.