# Microsoft Copilot — Excel, raw output

- Date: 2026-09-17, sent 09:19 (+07), answered in ~2 min ("Рассуждение завершено за 3 действий"). Free tier, copilot.com web app, model "Автоматически"; interface Russian, answer in English. The composer warned that a copy of the upload goes to the personal OneDrive ("При отправке с устройства копия будет отправлена в OneDrive (личный)").
- Capture: page text via JS. Returned "Cleaned XLSX" as a download card.
- First read: category totals, top product, the four duplicates and the five mismatches all exact - but the monthly revenue is wrong in a telling way: €1,213.90 / €594.50 / €822.30 sums to €2,630.70, about €765 short of its own category total, and re-running the ground truth with the 30 `dd/mm/yyyy` rows excluded gives exactly those three numbers: it parsed the Excel dates and the "Apr 5, 2026" strings but silently dropped every day-first date from the month split. Seven of the eight faults named (blank regions not mentioned). Formula is a Table-based SUMIFS with EOMONTH, grows with rows, and says the Table must be named Orders.

## Answer

Cleaned workbook:

[Cleaned XLSX]

What was fixed

- Standardized product names/casing/spaces (e.g., LINEN TEA TOWEL, olive oil 1l, VINHO VERDE 750ML).
- Removed duplicate orders (kept first occurrence).
- Filled missing categories from product type.
- Normalized dates and prices (including € formats).
- Fixed missing quantity and corrected totals where Total ≠ Qty × Unit Price.

Revenue

- Apr 2026: €1,213.90
- May 2026: €594.50
- Jun 2026: €822.30

Revenue by category

- Home: €1,399.00
- Pantry: €1,109.70
- Drinks: €886.80

Top product by units sold

Vinho Verde 750ml: 42 units

Duplicate order IDs

PT-1027, PT-1075, PT-1085, PT-1120

Orders where Total didn't match Qty × Unit Price

PT-1028, PT-1037, PT-1101, PT-1010, PT-1039

Excel formula for monthly revenue (works as rows are added if the cleaned data is formatted as an Excel Table named Orders)

    =SUMIFS(Orders[Total],Orders[Date],">="&EOMONTH(A1,-1)+1,Orders[Date],"<"&EOMONTH(A1,0)+1)

Where A1 contains any date in the month you want to total.

[Suggested follow-ups: Explain how the formula works · How to prevent future duplicates? · How to automate this process?]