Jst-Well-Dan/excel-variance-analyzer
business-analyst/excel-variance-analyzer/SKILL.md
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'.
$ install --global
skillsauthnpx skillsauth add Jst-Well-Dan/Skill-Box excel-variance-analyzerInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 6, 2026, 11:01 AM4.1s5 files scanned
SKILL.md
- name:
- excel-variance-analyzer
- description:
- |
- allowed-tools:
- Read, Write, Edit, Grep, Glob, Bash(cmd:*)
- version:
- 1.0.0
- author:
- Jeremy Longshore <[email protected]>
- 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
Related Skills
Jst-Well-Dan/video-frames
tools
VerifiedTrustedCommunity
Extract frames or short clips from videos using ffmpeg.
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/theme-factory
tools
VerifiedTrustedCommunity
Toolkit for styling artifacts with a theme. These artifacts can be slides, docs, reportings, HTML landing pages, etc. There are 10 pre-set themes with colors/fonts that you can apply to any artifact that has been creating, or can generate a new theme on-the-fly.
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/slack-gif-creator
tools
VerifiedTrustedCommunity
Toolkit for creating animated GIFs optimized for Slack, with validators for size constraints and composable animation primitives. This skill applies when users request animated GIFs or emoji animations for Slack from descriptions like "make me a GIF for Slack of X doing Y".
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/remotion-best-practices
development
VerifiedTrustedCommunity
Best practices for Remotion - Video creation in React
7SKILL.mdUpdated Apr 6, 2026