Audit Spreadsheet
Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model, including financial-model integrity checks like BS balance, cash tie-out, and logic sanity. Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this spreads
Overview
The Audit Spreadsheet skill, hosted in the fivetaku/claude-office-skills repository, provides automated verification for spreadsheet data and logic. Compatible with Claude and Claude Code, this tool allows users to examine specific ranges, individual sheets, or entire workbooks for formula accuracy and common errors. It performs specialized financial integrity checks, such as verifying balance sheet equilibrium, cash tie-outs, and general logic sanity. By leveraging Python and Pandas-based analysis, the skill identifies inconsistencies that might lead to incorrect data reporting. This technical utility is designed to streamline the quality assurance process for complex models, ensuring that formulaic relationships remain intact across large datasets and multi-sheet workbooks.
Use Cases
Install Notes
# Review source first
open https://github.com/fivetaku/claude-office-skills/blob/main/claude-in-excel/audit-xls/SKILL.mdCopy or clone the skill folder into your agent skills directory after reviewing its instructions and scripts.
Security Notes
This skill operates within the environment provided by the fivetaku/claude-office-skills repository. Users should ensure the agent has the necessary permissions to access the target spreadsheet files and that the execution environment complies with their data privacy standards.
Related Skills
Xlsx
anthropics/skills
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scr...
Experience Lwc Widget Migrate
forcedotcom/sf-skills
Convert a specific existing Lightning web component (LWC) into a declarative HXL / Agentforce widget, end to end. Gates on experience-lwc-widget-assess and stops when a widget cannot serve the LWC's purpose; otherwise hands the derived field shape to platform-widget-generate and wires the widget as the Lightning Typ...
Experience Lwc Widget Assess
forcedotcom/sf-skills
Assess whether a specific Lightning web component can serve its user's purpose as an HXL declarative widget. Use for LWC-to-widget feasibility, portability audits, and candidate screening; use experience-lwc-widget-migrate when the user wants the widget built.
Service De Channel Consent Configure
forcedotcom/sf-skills
Configure consent (opt-in/opt-out) on an Enhanced `MessagingChannel` so activation will accept it. Given a `{CHANNEL_ID}`, sets the channel's `ConsentType` (ImplicitOptIn / ExplicitOptIn / DoubleOptIn) and the `OptInPrompt` / `DoubleOptInPrompt` prompt fields, then creates or updates one `MsgChannelLanguageKeyword`...
Clean Data
fivetaku/claude-office-skills
Clean up messy spreadsheet data — trim whitespace, fix inconsistent casing, convert numbers-stored-as-text, standardize dates, remove duplicates, and flag mixed-type columns. Use when data is messy, inconsistent, or needs prep before analysis. Triggers on "clean this data", "clean up this sheet", "normalize this data",
3-Statement Financial Model Template Completion
fivetaku/claude-office-skills
Complete, populate and fill out 3-statement financial model templates (Income Statement, Balance Sheet, Cash Flow Statement). Use when asked to fill out model templates, complete existing model frameworks, populate financial models with data, complete a partially filled IS/BS/CF framework, or link integrated financial