Financial Spreadsheet Operations

What problem does it solve?

Financial spreadsheets and models often contain silent errors—broken formulas, hardcoded values, balance sheet mismatches, and messy input data—that corrupt analysis and lead to bad decisions. This Skill helps you find formula-level mistakes, verify model integrity (BS balances, cash tie-outs, rollforwards), and clean data so analyses run on reliable inputs.

Core Features & Use Cases

• Formula & Error Detection: Identify #REF!, #DIV/0!, hardcoded values in formulas, inconsistent patterns, off-by-one ranges, and broken cross-sheet links.
• Model Integrity Checks: Validate model types (DCF, LBO, 3-statement, merger), ensure balance sheet balancing, cash tie-outs, rollforwards, and flag circular references or iteration issues.
• Data Cleanup: Profile columns, trim whitespace, normalize casing, convert numbers stored as text, standardize dates, and detect duplicates with proposed helper formulas.
• Guardrails: Always create backups, report findings before changing anything, prefer helper formulas over destructive edits, and request explicit confirmation for overwrites or removals.

Quick Start

Open the workbook and ask the skill to audit the entire model and produce a findings table summarizing critical, warning, and info issues.