excel-variance-analyzer

Name: excel-variance-analyzer
Author: jst-well-dan

github.com/jst-well-danData & databases1040 installsUpdated 31w ago

About excel-variance-analyzer

A spreadsheet skill for comparing budgets with actual results and preparing variance analysis. It supports drill-downs, materiality-based exception reports, and waterfall charts for finance and department reviews.

Key features

01Calculate absolute and percentage variances
02Flag results using materiality thresholds
03Drill down by category, period, or cost center
04Create budget-to-actual waterfall charts
05Generate favorable and unfavorable summaries

Use cases

01Investigate monthly profit-and-loss deviations
02Rank departments by year-to-date budget variance
03Prepare executive budget variance reports

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/jst-well-dan/skill-box --skill excel-variance-analyzer

After installing, type/excel-variance-analyzerin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

assets/

README.md

references/

README.md

variance-formulas.md

scripts/

README.md

Details

From the project README

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.md for calculation templates

Comments

Markdown supported

Details

Author: jst-well-dan
Repository: jst-well-dan/skill-box
Category: Data & databases
Installs: 40
GitHub stars: 10

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.6k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

823.2k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

821.8k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

701.4k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).