// Business & Operations

Spreadsheet Formula Change Auditor

Compare two XLSX versions for formulas replaced by values, formula-family drift, broken references, new cycles, and workbook-control changes.

Get it on Agensi Find another skill $19 one-time

What problem does Spreadsheet Formula Change Auditor solve?

A spreadsheet can still open and show plausible totals after a formula was pasted over, a relative reference drifted, a name changed, or calculation mode became manual.

Use it to

Review an edited financial or operating model before client handoff
Catch pasted-over formulas after bulk copy, import, or AI-assisted edits
Compare recurring reporting workbooks before publication
Create an evidence ledger for intentional and unexpected logic changes

What it returns

Cell-level formula and workbook-control change ledger
Sheet-level formula and severity summary
JSON BLOCK, REVIEW, or CLEAR release gate
Review memo tied to the exact before and after workbooks

A representative input and result

fixture-backed sample

input Before: Model!C3 contains =A3*B3, D2 contains =C2*$B$1, workbook calculates automatically. After: C3 contains 999, D2 contains =D2+$B$1, E2 contains =#REF!+1, calculation mode is manual.

result Release gate: BLOCK Critical: formula replaced by value at Model!C3. Critical: new dependency cycle at Model!D2. Critical: #REF! at Model!E2 and manual calculation mode. High: formula and defined-name changes require owner reconciliation.

Access and approval boundaries

Read access to two user-supplied local XLSX files.
Write access only to the selected local audit output directory.
No Excel automation, macro, browser, network, credential, or environment-variable access is required.

Known limitations

Only unencrypted .xlsx files are supported in version 1; .xls, .xlsb, and password-protected files are not parsed.
The helper does not recalculate cached values or execute macros, data connections, Power Query, or application-specific functions.
Shared, array, table, dynamic-array, and external formulas can require manual Excel or LibreOffice review.

// choose with context

Is Spreadsheet Formula Change Auditor the right skill?

Best fit

A spreadsheet can still open and show plausible totals after a formula was pasted over, a relative reference drifted, a name changed, or calculation mode became manual.

It returns

Cell-level formula and workbook-control change ledger. Sheet-level formula and severity summary.

Do not use it as

It does not recalculate formulas, run macros, refresh data connections, or modify either workbook.

Compatibility, access, version, and licence

Reads or accesses: Declared local scope: spreadsheet-audit-input/**, spreadsheet-audit-output/**, *.xlsx, *.csv.
Compatibility: Unencrypted Microsoft Excel .xlsx workbooks. Windows, macOS, or Linux environments with Python 3. Local or agent workflows that can preserve an authoritative before and candidate after file.
Version: 1.0.0
Licence: Review the package licence and seller terms at the linked destination.

What happens next

The Agensi listing opens at the current offer. Complete purchase there, inspect SKILL.md and its bundled files, then add the complete folder to your agent.

Questions

Does it need Microsoft Excel installed?

No. It reads the standard XLSX ZIP and XML structure locally with Python 3.

Will it change or recalculate my workbook?

No. Both workbooks remain read-only. The helper does not launch Excel, calculate formulas, run macros, or refresh connections.

What is a formula-family outlier?

It is a formula whose relative A1-reference pattern differs while the immediately adjacent formulas in the same column share one pattern.

Can a CLEAR result prove the workbook is correct?

No. CLEAR means no covered before-and-after difference was found. Unchanged formulas can still be wrong, and cached values can be stale.

Does it support password-protected or legacy Excel files?

No. Version 1 supports unencrypted .xlsx files. Convert or decrypt authorized files in the application of record first.

What should I do with an intentional formula change?

Tie it to an owner-approved requirement, recalculate in the application of record, verify representative results, and preserve the disposition with the audit.