spreadsheetslisted

*[日本語](SKILL.ja.md)* # Line-item Spreadsheets (Excel + Google Spreadsheet) ## Important - **One spec, two outputs.** The JSON spec builds the `.xlsx` with openpyxl; `--gsheet` converts that same file into a Google Spreadsheet via Drive. Never author the two outputs separately — they must stay identical. - **Amounts are formulas, not pasted numbers.** Amount = quantity × unit price as a real formula (`=D{row}*F{row}`), totals as `SUM`. The user will edit quantities in the delivered file and the totals must follow. Only put literal numbers in cells the user should treat as input (unit price, quantity). - **Fixes happen in the spec.** Regenerate on any change; with the same title and folder, the Google Spreadsheet is updated **in place** (URL preserved), so the user always holds one link. - **Run every command from the slide-forge root as cwd** — `${CLAUDE_PLUGIN_ROOT}` when running from an installed plugin, `/path/to/slide-forge` on a local clone. Auth and the venv are shared at the repo root (`config/`, `.venv`). - **Never invent prices.** Unit prices, tax rates, and discount terms come from the user or their material. Anything unsourced stays a `○○` placeholder flagged in the note row and the report — same rule as deck content. - **Companion to a deck**: when the spreadsheet backs a proposal's cost slide (`scalar-proposal-slides` BOM, etc.), put it in the **deck's Drive folder** and keep slide summary and sheet totals consistent — the slide show