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

references/analysis-checklist.md

View on GitHub
# Spreadsheet analysis checklist

## Structure and semantics

- Record file hash, format, workbook date system, calculation mode, locale, and last calculation indicators.
- Inventory visible/hidden sheets, named ranges, tables, filters, merged cells, validations, comments, links, queries, macros, charts, pivots, and protection.
- Define row grain, primary key, allowed duplicates, units, signs, currencies, period, and source of truth.
- Distinguish blank, zero, empty string, `NA`, suppressed, not applicable, and formula error.

## Data quality

- Row/column counts and duplicate headers/keys.
- Missingness by field and by relevant segment.
- Type drift, mixed date systems, locale-specific numbers, and IDs coerced to numeric/scientific notation.
- Invalid categories, whitespace, casing, encoding, and delimiter issues.
- Date gaps/overlaps, impossible dates, future dates, and time-zone boundaries.
- Outliers, negative values, unit changes, stale refresh dates, and hidden exclusions.

## Formula integrity

- Formula count and error count by sheet.
- Formula consistency across contiguous regions.
- Hard-coded values inside formula regions.
- Relative/absolute reference drift, incomplete ranges, and off-by-one totals.
- Circular references, volatile functions, array/spill behavior, error suppression, external references, DDE, and web functions.
- Cached values compared with a real recalculation when available.

## Joins and aggregation

- Cardinality checked before every join; unmatched and multiplied rows reported.
- Grouping keys and filters documented.
- Subtotals are not double-counted with detail rows.
- Percentages use the stated denominator; weighted averages use explicit weights.
- Currency conversion rates, effective dates, and rounding rules are recorded.

## Verification

- Key totals reconcile to an independent control or variance is explained.
- A sample of source rows traces through each transformation to final output.
- Re-run from the preserved source produces the same result.
- Saved output re-opens without repair warnings and, if relevant, recalculates.
- For untrusted recalculation, macros/VBA, workbook events, DDE, add-ins, network access, external links, connections, queries, and automatic refresh were demonstrably disabled.
- Results dependent on disabled macros, events, add-ins, links, or connections are labeled unverified rather than accepted from cached values.
- Changed sheets and dashboards are visually inspected in the intended viewer.
- Findings distinguish facts, assumptions, estimates, cached values, and unresolved gaps.
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