Finish a Spreadsheet Server / GL Wand conversion Copy link

The Blitz Report add-in has already converted this workbook: every balance, period and segment description formula now uses the add-in's own functions, and what the converter could not finish is listed on the Conversion Log sheet (row 1 headers Level | Cell | Message, one line per issue, Cell is <sheet>!<address> or blank for a workbook-wide line). Your job is that list, nothing else.

Self-contained: read no other skill. Each numbered Op is one workbook operation (Claude: one execute_office_js call; Copilot: one read or edit action).

Rules

1. Only what the log names. Never rewrite a formula the log does not point at, never "tidy" a converted formula, never recalculate or refresh balances yourself.
2. One confirmation before any edit. Show every change as cell: before -> after and ask. A line that needs a business decision (which ledger, which currency, which values) is a question in that same message, never a guess.
3. Every argument of a balance, period or description formula is a plain cell reference or a quoted literal — the add-in reads them without Excel calculating. A computed value goes into a helper cell, and the formula points at that cell. Never put an expression inside these formulas.
4. A helper cell must be empty (read it first) and sit next to the cell it serves; tell the user where it went.
5. Talk about periods, balances, segments, ledgers and cells in the user's language. Never name the add-in's worksheet functions, this skill, or the log's internal wording.

Op 1 — Read the log

Read Conversion Log columns A:C (its whole used range). No such sheet: the conversion finished clean — say so and stop. Classify every line with references/log-messages.md: Fix, Ask, Info, or Re-run (the converter can finish it once the input is corrected).

Op 2 — Read what the fixes need

In one operation, read the formulas (not values) of every cell the Fix and Ask lines name, plus the cells those formulas point at that the fix procedure needs (period cells, format cells, the source cell of a period number). references/fixes.md says exactly what each procedure reads.

Op 3 — Propose → confirmation

One message, grouped:

• I will change — per line: the cell, before -> after, one plain sentence why.
• I need your answer — the Ask lines, each with the options the procedure lists.
• For your information — the Info lines in one sentence each (no action).
• The converter can finish these — Re-run lines: what to correct first (you may propose that correction above) and that they then run the Spreadsheet Server or GL Wand converter again on this workbook from the Blitz Report ribbon (Tools > Converter), which converts only what is still unconverted. Options: Yes — make the changes / Change some first / Cancel. Nothing is written before Yes.

Op 4 — Apply

Write the confirmed changes, one contiguous block per write (a comma-separated multi-area address is rejected; retry a rejected write once on that range, then move on). A formula written into a cell formatted as Text stays text: set that cell's number format to General first.

Op 5 — Mark the log

Write a Status heading in D1 of Conversion Log and, in one block write down column D, Fixed, Needs you, Info or Run the converter again for every line. Never delete log lines.

Op 6 — Reply

What was changed (cell by cell), what still needs the user (with the question), and: "Refresh the workbook (Blitz Report ribbon > Refresh > Other > Workbook) to calculate the balances." If the user answered an Ask question, apply it in a further Op 4 + Op 5 round.