Version Comparison and Change Detection Audit
Find what changed between two versions of a workbook.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Find what changed between two versions of a workbook. Spreadsheet app: [SPREADSHEET_APP]. Version A description and Version B description: [VERSION_DESCRIPTIONS]. Sheets, tables, or ranges to compare (paste samples or describe): [COMPARE_TARGETS]. Take the comparison through this tree: 1. Structure: IF sheets, columns, or named ranges were added, removed, or renamed THEN list them first. 2. Values: IF row counts differ THEN find added and removed rows by key (give formulas using lookup or match on the key column). IF counts match THEN compare cell by cell using a difference formula or conditional formatting. 3. Formulas: IF a formula was changed THEN show the old and new text side by side. Describe how to list formulas as text with the formula-text function. 4. Hardcodes: IF a formula cell now holds a typed number THEN flag as high risk. 5. Settings: calculation mode, filters, hidden items, data validation, external links. 6. Impact: for each change, say which outputs it affects. Output a change log table: Location | Type (added, removed, value changed, formula changed, structure) | Before | After | Likely reason | Risk | Approved? Add step-by-step instructions for my app, a method for keeping version history in future, and a checklist before approving a new version. Don't guess reasons; label them hypotheses.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.