mcpField
E
excel

excel

github.com/igorwarzochaDocuments122202 installsUpdated 38w ago
Repository

About excel

An Excel-focused skill that guides agents in building and reviewing spreadsheets, emphasizing formula-driven calculations, dedicated assumptions, formatting, and an audit loop. It also describes Pandas and Openpyxl workflows for data analysis and workbook output.

Key features

  1. 01Use formulas for derived values
  2. 02Keep inputs in assumption cells
  3. 03Apply units and number formatting
  4. 04Analyze with Pandas and format with Openpyxl
  5. 05Recalculate and audit workbooks

Use cases

  1. 01Building financial or analytical models
  2. 02Formatting workbook outputs consistently
  3. 03Checking formulas before delivery

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/igorwarzocha/opencode-workflows --skill excel

After installing, type/excelin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

references/
artifact_tool_spreadsheet_formulas.md
artifact_tool_spreadsheets_api.md
spreadsheet.md
references/examples/
create_basic_spreadsheet.py
create_spreadsheet_with_styling.py
read_existing_spreadsheet.py
styling_spreadsheet.py
references/examples/features/
change_existing_charts.py
cite_cells.py
create_area_chart.py
create_bar_chart.py
create_doughnut_chart.py
create_line_chart.py
create_pie_chart.py
create_tables.py
set_cell_borders.py
set_cell_fills.py
set_cell_width_height.py
set_conditional_formatting.py
set_font_styles.py
set_merge_cells.py
set_number_formats.py
set_text_alignment.py
set_wrap_text_styles.py
scripts/
recalc.py

Details

From the project README

<modeling_standards>

  • Zero Formula Errors: Models MUST have zero #REF!, #DIV/0!, or #VALUE! errors.
  • Dynamic Logic: You MUST NOT hardcode derived values. You MUST use Excel formulas for all calculations.
  • Assumptions: You MUST place all inputs in dedicated assumption cells. </modeling_standards>

<professional_formatting>

  • Standards: Specify units in headers ("Revenue ($mm)"). Format zeros as "-".
  • Color Coding: The agent SHOULD follow the project's branding skill for color choices. If not defined, the agent SHOULD default to professional standards (e.g., Blue for hardcoded inputs, Black for formulas).
  • Visuals: You SHOULD use artifact_tool to render sheets and verify layout. Reference: references/artifact_tool_spreadsheets_api.md. </professional_formatting>

<technical_workflows>

1. Data Analysis (Pandas)
  • You SHOULD use Pandas for heavy lifting and aggregation.
  • You SHOULD convert to Openpyxl for final professional formatting and formula insertion.
2. Verification Loop (MANDATORY)

Before delivery, you MUST run the audit script:

  • python scripts/recalc.py output.xlsx
  • You MUST fix all errors identified in the resulting JSON summary. </technical_workflows>

<citation_logic>

  • Citations: You SHOULD cite sources for hardcoded data in cell comments.
  • Best Practices: See references/spreadsheet.md for guidance on cross-sheet references and complex formula construction. </citation_logic>

</excel_professional_suite>

Comments

Markdown supported