Agent Skills

Spreadsheet Ops

AIPOCH

Spreadsheet processing and analysis for CSV/Excel; trigger when users ask to merge/clean tabular data, run statistics, add/edit Excel formulas, apply formatting, generate charts, or force workbook recalculation.

2
0
FILES
spreadsheet-ops/
skill.md
scripts
analyze_data.py
apply_formatting.py
apply_formulas.py
build_charts.py
merge_files.py
recalc_workbook.py
references
analysis.md
column-matching.md
dedup-conflict.md
formatting.md
formulas.md
large-files.md
recalc.md
report-template.md
visualization.md
85100Total Score
View Evaluation Report
Core Capability
86 / 100
Functional Suitability
11 / 12
Reliability
10 / 12
Performance & Context
7 / 8
Agent Usability
14 / 16
Human Usability
8 / 8
Security
9 / 12
Maintainability
10 / 12
Agent-Specific
17 / 20
Medical Task
15 / 20 Passed
85You need to merge multiple CSV/Excel files into a single dataset and align columns
3/4
85You need to clean tabular data (normalize headers, deduplicate rows, resolve conflicts) before downstream use
3/4
85CSV/Excel merge & cleaning: combine files, normalize column names, deduplicate, and resolve conflicts
3/4
85CSV/Excel analysis: compute descriptive statistics and analysis reports
3/4
85End-to-end case for CSV/Excel merge & cleaning: combine files, normalize column names, deduplicate, and resolve conflicts
3/4

SKILL.md

When to Use

  • You need to merge multiple CSV/Excel files into a single dataset and align columns.
  • You need to clean tabular data (normalize headers, deduplicate rows, resolve conflicts) before downstream use.
  • You need to perform data analysis/statistics on CSV/Excel (summaries, distributions, group-by metrics).
  • You need to add or edit formulas in an Excel workbook (including applying formulas across ranges).
  • You need to apply Excel formatting (including conditional formatting), generate charts, or force formula recalculation.

Key Features

  • CSV/Excel merge & cleaning: combine files, normalize column names, deduplicate, and resolve conflicts.
  • CSV/Excel analysis: compute descriptive statistics and analysis reports.
  • Excel-only formula operations: create/edit formulas and apply them to specified ranges.
  • Excel-only formatting: apply cell styles and conditional formatting rules.
  • Excel-only visualization: build charts from worksheet ranges.
  • Excel-only recalculation: set workbook to full recalculation (recalc flag) to ensure formulas update.

Dependencies

  • Python 3.x
  • Project Python dependencies are defined by the repository environment (e.g., requirements.txt / lockfile if present).
    (No explicit versions were provided in the source document.)

Example Usage

The following commands assume you are in the repository root and have a Python environment available.

1) Merge files (CSV/Excel)

python scripts/merge_files.py

2) Analyze data (CSV/Excel)

python scripts/analyze_data.py

3) Apply formulas (Excel only)

python scripts/apply_formulas.py

4) Apply formatting (Excel only)

python scripts/apply_formatting.py

5) Build charts (Excel only)

python scripts/build_charts.py

6) Force workbook recalculation (Excel only)

python scripts/recalc_workbook.py

Implementation Details

  • Workflow

    1. Confirm inputs/outputs: file paths, file formats (CSV vs Excel), worksheet names, and target ranges.
    2. Choose the task type: merge, analysis, formula, formatting, chart, or recalculation.
    3. Run the corresponding script and configure parameters in CONFIG (as used by the scripts).
    4. Produce output files and any generated reports.

  • Task boundaries

    • CSV/Excel supported: merging/cleaning, data analysis.
    • Excel only: formula creation/editing, formatting, chart visualization, and recalculation.

  • Key parameters to clarify (priority)

    • Input type: CSV or Excel; single file or multiple files.
    • Worksheet names and cell ranges to operate on (Excel).
    • Whether formulas/formatting/charts must preserve original styles.
    • Desired output format: CSV / Excel / JSON / Parquet.

  • Standards / constraints

    • Python file I/O must explicitly specify encoding='utf-8'.
    • json.dump(...) must set ensure_ascii=False.

  • Reference documentation (optional)

    • Column name matching & normalization: references/column-matching.md
    • Deduplication & conflict resolution: references/dedup-conflict.md
    • Large files & performance: references/large-files.md
    • Formula design & ranges: references/formulas.md
    • Formatting & conditional formatting: references/formatting.md
    • Data analysis & statistics: references/analysis.md
    • Charts & visualization: references/visualization.md
    • Formula recalculation: references/recalc.md