A brief like “make a sales spreadsheet” leaves the discount calculation, cancelled orders and summary method unspecified. In our test, we supplied six exact source columns and asked for a seventh formula column. The rule was: for a completed order, multiply quantity by unit price and by (1 − discount), then round to cents; a cancelled or zero-quantity order must have a numeric zero total. Each product subtotal and the grand total also had to come from formulas.

Those edge cases matter. Order WB-104 has a nonzero quantity and price but is cancelled; simply multiplying its cells would add $12.50 incorrectly. Order WB-105 is completed but has quantity zero; its amount must also be zero. We fixed the expected line totals and the $140.25 grand total before submitting the prompt. The exact one-request prompt and frozen checks are available below.

If your own source has returns, pending orders, taxes or several currencies, define those separately. Our prompt contained none of them, and this workbook does not implement rules for them.

The signed-in Sheets page opened a Kimi chat after we sent one prompt. Kimi produced an online preview and an .xlsx file. We sent no corrective request. We downloaded the file through the All files panel, extracted its sole workbook from the ZIP and read the workbook locally in both formula and stored-value views. This is a check of the delivered file, not an acceptance of Kimi’s completion message.

All eight source rows matched the prompt, in order. The file contains a formula in every line-total cell (G4:G11), three SUMIF product-subtotal formulas and a SUM grand-total formula. The stored product subtotals are $60.00 for blue notebooks, $33.00 for pen sets and $47.25 for desk mugs; they add to the stored $140.25 total. Unit prices and totals have USD formats; discounts have percentage formats. We found no added order or charge.

The workbook is one visible, unprotected sheet called Orders, with editable source cells and no external workbook links. We parsed its file structure and stored formula results locally, but did not open or edit it in desktop Excel or LibreOffice. These observations apply to this one small fictional example only.

On 25 September, we checked the baseline and each change on a separate copy using a spreadsheet calculation engine. This was a local file check, not another Kimi request. These results have not been verified in desktop Excel or LibreOffice.

Why the added order did not reach the summary

We wrote WB-109 | Pen set | 2 | 5 | 0 | Completed into A12:F12 and put the existing row calculation, adjusted to row 12, in G12. We left the original table and summary ranges unchanged. This tests writing below the existing data; it does not test Excel’s automatic table expansion or an Insert Table Row command.

The pen-set summary in J5 still used =SUMIF($B$4:$B$11,$I5,$G$4:$G$11). Both source ranges stop at row 11, so a correct $10.00 in row 12 cannot enter that subtotal. The grand total sums the product subtotals and inherits the omission. These are valid calculations over an incomplete range, not a formula error. Kimi’s original brief asked for eight orders; this follow-up checks what happens when you extend that example.

Before using additional orders: check that the detail formula, table range and every summary source range include the new row. In this example, including row 12 in both ranges of each product SUMIF would be necessary to count WB-109; the target is $43.00 for pen sets and $150.25 overall. Those are the expected repair targets, not results of a repair performed in this test. Do not assume that adding a visually correct row updates every report.

The follow-up download preserves all three cases, including the omitted-order result. These are locally processed copies; the original Kimi download remains unchanged.

1. Compare every input with your source. Count the records, check IDs once each and inspect quantities, prices, discounts and statuses. A correct-looking total can hide a miscopied input.
2. Look at cell types and formulas. In our file, the cancelled and zero-quantity totals are numeric zero values, while their cells still contain formulas. The formula stored in G4 is =IF(OR($F4="Cancelled",$C4=0),0,ROUND($C4*$D4*(1-$E4),2)). Check that each subsequent line points to its own row; a typed answer would not update when an input changes.
3. Reconcile summary cells to the detail. Our summary uses SUMIF for the three exact product labels and SUM for the grand total. Check that the product subtotals add to the total and that no order is excluded by a misspelled label.
4. Test an edit on a copy. In your spreadsheet app, change WB-101’s quantity in C4 from 3 to 4. Check G4 = $50.00, J4 = $72.50 and J7 = $152.75. Our local engine test reproduced those values; repeat the check in the app you actually use. Restore 3 or discard the copy, keeping the original download untouched.
5. Inspect ranges before adding records. The delivered product formulas currently reference only rows 4:11. If you append an order, confirm the summary ranges expand and the total recalculates. The formula treats exactly Cancelled as excluded; it does not define what a new status such as Pending should do.

For work where an incorrect number matters, recalculate the downloaded file in the spreadsheet app you actually use and compare it with a separate manual or trusted-system total. Our stored results passed this one test, but they do not certify new inputs, future Kimi versions or every Excel implementation.

Kimi’s help page says Sheets can preview a workbook online and download .xlsx. In our session, the preview’s individual Download icon did not place a file in the machine’s Downloads folder. Opening All files and choosing Download all files did deliver a ZIP with the single workbook. If a download seems absent, check your browser’s download list and the All files panel before concluding the generation failed. We did not establish why the first icon did not deliver a file in this browser.

Our Moderato account completed the request without an API key or payment prompt. That does not show that every plan can do the same task, or establish a per-workbook price. We could not see the credit deduction for this run. Check Kimi’s current membership rules and our Kimi plans guide for the consumer product; the separate developer API is not needed for this browser workflow.

The original Kimi task did not upload an existing file or exercise cross-sheet analysis. The later local engine test checked two existing-input changes and one appended-order case; it did not establish desktop Excel/LibreOffice behavior or display compatibility. If you need to extract rows from a source PDF first, the separate Kimi PDF reading guide explains how we checked that task; its results should not be treated as evidence about Sheets accuracy.

Download the unchanged first-run Excel workbook (.xlsx). The complete test records (ZIP) include that workbook, the fictional source, exact prompt, checks fixed before submission and the file-inspection results. No credentials or real customer data are included.

Download the 25 September recalculation follow-up (ZIP): the unchanged original, three separately labelled local test copies, exact edits, expected and actual values, and calculation limits. The added-order copy deliberately retains the incomplete summary. These copies were recalculated locally, not regenerated by Kimi.

Create one editable Excel workbook for the fictional Willow Bay Stationery orders below. Use only the supplied data. Do not browse, invent extra orders or change any source value.

Keep the six source columns: Order ID, Product, Quantity, Unit price (USD), Discount, Status. Add a Line total (USD) formula for every order. For a Completed order, calculate Quantity × Unit price × (1 − Discount), rounded to two decimals. For a Cancelled order, show a numeric zero even if quantity and price are nonzero. A Completed order with quantity zero must also show a numeric zero. Keep the source inputs editable and keep the calculated line totals as Excel formulas, not manually entered answers.

Add a compact summary with a formula-derived subtotal for each of the three products and a formula-derived grand total. Use USD currency formatting for money and percentage formatting for discounts. Do not add tax, shipping, forecasts, external data, logos, people or contact details. Make the result readable and downloadable as .xlsx if this workflow supports it.

Fictional source rows:
Order ID | Product | Quantity | Unit price (USD) | Discount | Status
WB-101 | Blue notebook | 3 | 12.50 | 0% | Completed
WB-102 | Pen set | 4 | 5.00 | 10% | Completed
WB-103 | Desk mug | 2 | 8.75 | 20% | Completed
WB-104 | Blue notebook | 1 | 12.50 | 0% | Cancelled
WB-105 | Pen set | 0 | 5.00 | 0% | Completed
WB-106 | Desk mug | 4 | 8.75 | 5% | Completed
WB-107 | Blue notebook | 2 | 12.50 | 10% | Completed
WB-108 | Pen set | 3 | 5.00 | 0% | Completed

Sources reviewed 23 September 2026: Kimi Docs & Sheets overview, Kimi Sheets feature page and Sheets use cases. The official Sheets feature page was rechecked on 25 September alongside our local follow-up. Provider descriptions, the original Kimi output and our later calculations are identified separately above. For the broader assistant and other tasks, see our Kimi overview. If a control changes or you find a reproducible correction, contact China AI Chat Team. We will revisit this guide when the official Sheets workflow or export behavior materially changes.