hanzoai/dev / .agents/skills/xlsx
xlsx
UnverifiedExcel & 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.
Excel & Financial Modeling (xlsx)
Create, inspect, and modify production-grade .xlsx spreadsheets, financial models, cohort tables, and operational trackers.
Core Rules
- 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. - Assumptions Isolation: Place all editable inputs and growth/pricing assumptions in a dedicated
AssumptionsorInputsblock with distinct styling, referenced cleanly across tabs. - 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. - 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###.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 465k | Updated | Claude CodeCodex | Verified | Install |
| 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: 465k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 465k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 192k | Updated | Claude CodeCodex | Verified | Install |