excel-variance-analyzer
Analyze budget vs actual variances in Excel with drill-down and root cause analysis. Use when performing variance analysis or explaining budget differences. Trigger with phrases like 'excel variance', 'analyze budget variance', 'actual vs budget'.
Installation
Details
Usage
After installing, this skill will be available to your AI coding assistant.
Verify installation:
skills listSkill Instructions
name: excel-variance-analyzer description: | Analyze budget vs actual variances in Excel with drill-down and root cause analysis. Use when performing variance analysis or explaining budget differences. Trigger with phrases like 'excel variance', 'analyze budget variance', 'actual vs budget'. allowed-tools: Read, Write, Edit, Grep, Glob, Bash(cmd:*) version: 1.0.0 author: Jeremy Longshore jeremy@intentsolutions.io license: MIT
Excel Variance Analyzer
Overview
Performs comprehensive budget vs actual variance analysis with automated drill-down, root cause identification, and executive reporting.
Prerequisites
- Excel or compatible spreadsheet software
- Budget data by period and category
- Actual results for comparison
- Cost center or department structure
Instructions
- Import budget and actual data into comparison template
- Calculate absolute and percentage variances
- Apply materiality thresholds for flagging
- Create drill-down by category, period, or cost center
- Generate variance waterfall chart for executive reporting
Output
- Variance summary with favorable/unfavorable indicators
- Materiality-filtered exception report
- Waterfall chart showing budget-to-actual bridge
- Drill-down by category or cost center
Error Handling
| Error | Cause | Solution |
|---|---|---|
| Missing periods | Data gaps | Fill with zeros or interpolate |
| Percentage calc error | Zero budget | Use IF to handle div/0 |
| Misaligned categories | Changed chart of accounts | Create mapping table |
Examples
Example: Monthly P&L Variance Request: "Analyze why we missed budget by $500K this month" Result: Variance waterfall showing revenue shortfall offset by OPEX savings
Example: Department Budget Review Request: "Which departments are over budget YTD?" Result: Ranked list by variance magnitude with drill-down to line items
Resources
- FP&A Best Practices
{baseDir}/references/variance-formulas.mdfor calculation templates
More by jeremylongshore
View allRabbitmq Queue Setup - Auto-activating skill for Backend Development. Triggers on: rabbitmq queue setup, rabbitmq queue setup Part of the Backend Development skill category.
evaluating-machine-learning-models: This skill allows Claude to evaluate machine learning models using a comprehensive suite of metrics. It should be used when the user requests model performance analysis, validation, or testing. Claude can use this skill to assess model accuracy, precision, recall, F1-score, and other relevant metrics. Trigger this skill when the user mentions "evaluate model", "model performance", "testing metrics", "validation results", or requests a comprehensive "model evaluation".
building-neural-networks: This skill allows Claude to construct and configure neural network architectures using the neural-network-builder plugin. It should be used when the user requests the creation of a new neural network, modification of an existing one, or assistance with defining the layers, parameters, and training process. The skill is triggered by requests involving terms like "build a neural network," "define network architecture," "configure layers," or specific mentions of neural network types (e.g., "CNN," "RNN," "transformer").
Oauth Callback Handler - Auto-activating skill for API Integration. Triggers on: oauth callback handler, oauth callback handler Part of the API Integration skill category.