Skip to content

seb1n/awesome-ai-agent-skills / documents-and-files/spreadsheet-analysis

spreadsheet-analysis

Verified

Inspect, profile, clean, reconcile, analyze, visualize, and verify spreadsheet data while preserving formulas, formatting, types, and source files. Use when working with .xlsx, .xlsm, .xls, .ods, .csv, or .tsv files; answering questions from a workbook; auditing formulas or data quality; comparing sheets or versions; producing pivots, charts, forecasts, or summary workbooks; repairing malformed tables; or validating that spreadsheet edits and calculations are accurate.

FileKindSize
SKILL.mdskill md9.8 KB
agents/openai.yamlconfig219 B
assets/analysis-report-template.mdmarkdown1.7 KB
references/analysis-checklist.mdmarkdown2.5 KB
references/tool-routing.mdmarkdown2.5 KB
scripts/profile_table.pyexecutablescript33.9 KB

assets/analysis-report-template.md

View on GitHub
# Spreadsheet Analysis Record

- Question and acceptance criteria:
- Source file(s), SHA-256, format, and byte size:
- Output path(s), SHA-256, format, and byte size (or `no output created`):
- Grain / primary key:
- Period / units / currency / time zone:
- Toolchain and versions:
- Recalculation engine used (or not used):
- Untrusted-workbook controls: macros/VBA disabled; events disabled; DDE/add-ins disabled; external refresh disabled; network disabled; isolated/no-secret environment (record each as `verified`, `not verified`, or `not applicable`):

## Workbook and sheet inventory

| File | Workbook properties / calculation mode | Sheet | Visibility | Used range / rows / columns | Formulas/errors | Links/connections/macros/events | Profile coverage/limits |
|---|---|---|---|---|---|---|---|
| | | | | | | | |

## Assumptions and metric definitions

| Item | Definition or assumption | Evidence | Impact if wrong |
|---|---|---|---|
| | | | |

## Data quality and formula findings

| ID | Severity | Sheet/range | Observed issue | Impact | Recommended action |
|---|---|---|---|---|---|
| | | | | | |

## Results

| Metric/finding | Value | Formula/method | Filters/period | Evidence location | Limitation |
|---|---|---|---|---|---|
| | | | | | |

## Reconciliation

| Control | Expected | Actual | Variance | Explanation/status |
|---|---:|---:|---:|---|
| | | | | |

## Verification record

Record re-open, recalculation, source-row traces, visual checks, chart checks, and tests not performed. Label every macro-, event-, add-in-, query-, connection-, or external-link-dependent result `unverified—active dependency not executed` unless that dependency was separately authorized and safely verified.
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: 472kUpdated 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: 472kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 472kUpdated 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