Skip to content

hanzoai/dev / .agents/skills/xlsx

Excel & Spreadsheet Financial Modeling (`xlsx`). Create, audit, and transform `.xlsx` workbooks with dynamic formulas, multi-sheet financial statements, pivot tables, sensitivity matrices, and zero hardcoded magic numbers.

FileKindSize
SKILL.mdskill md1.2 KB
---
name: xlsx
description: "Excel & Spreadsheet Financial Modeling (`xlsx`). Create, audit, and transform `.xlsx` workbooks with dynamic formulas, multi-sheet financial statements, pivot tables, sensitivity matrices, and zero hardcoded magic numbers."
source: hanzoai/skills
---

# Excel & Financial Modeling (`xlsx`)

Create, inspect, and modify production-grade `.xlsx` spreadsheets, financial models, cohort tables, and operational trackers.

## Core Rules
1. **Formulas Over Hardcoded Values**: Always write live Excel formulas (`SUM`, `INDEX/MATCH`, `XLOOKUP`, `SUMIFS`, `XNPV`, `XIRR`) rather than pre-computed static numbers so downstream cells recalculate automatically.
2. **Assumptions Isolation**: Place all editable inputs and growth/pricing assumptions in a dedicated `Assumptions` or `Inputs` block with distinct styling, referenced cleanly across tabs.
3. **Audit Checks**: Include balance-sheet/reconciliation check rows (`=IF(ABS(A1-B1)<0.01, "OK", "ERROR")`) and never leave `#REF!`, `#DIV/0!`, or `#NAME?` errors in generated sheets.
4. **Formatting & Readability**: Format currencies (`$#,##0`), percentages (`0.0%`), dates (`YYYY-MM-DD`), freeze header panes, and set explicit column widths so no values render as `###`.
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 471kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 471kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 471kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall