skills.rest
SethyPagna
SethyPagnaCOMMUNITY
Explore all skills by this author →
GitHub

excel-author

Generate auditable .xlsx workbooks with openpyxl using blue, black, and green cell conventions.

Updated May 14, 2026
Search Tags:#openpyxl#excel#audit-trail#financial-modeling#sensitivity-analysis#workbook-automation
One-click install
npx skills add https://github.com/SethyPagna/Secretary-Jarvis --skill excel-author-sethypagna
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-author
Source: https://github.com/SethyPagna/Secretary-Jarvis/tree/main/src/capabilities/optional-skills/finance/excel-author
Command: npx skills add https://github.com/SethyPagna/Secretary-Jarvis --skill excel-author-sethypagna

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill removes the friction of building audit-ready Excel workbooks by hand, especially when formulas, formatting, and traceable inputs all need to stay consistent.

Core Features & Use Cases

  • Auditable workbook generation: Creates .xlsx files with blue input cells, black formula cells, and green linked cells so assumptions are easy to review.
  • Financial modeling controls: Uses named ranges, balance checks, hardcode comments, and sensitivity tables to support valuation, reconciliation, and planning models.
  • Headless delivery: Produces files with openpyxl and can recalculate formulas through a helper script for automated pipelines.
  • Use Case: Build a monthly forecast workbook for a finance team that needs transparent assumptions, checks that tie out, and a sensitivity analysis for key drivers.

Quick Start

Use the excel-author skill to build an auditable Excel workbook for my financial model and save it in the out folder.

Frequently Asked Questions about excel-author

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate auditable Excel financial models with openpyxl?▼

To generate auditable Excel financial models, this Skill uses openpyxl to create .xlsx files with blue input cells, black formula cells, and green linked cells, ensuring transparent assumptions and reviewable formulas.

What cell formatting conventions are used for audit-ready workbook automation?▼

Audit-ready workbook automation applies blue input cells, black formula cells, and green linked cells, alongside named ranges and hardcoded input comments, to make financial modeling assumptions easy to review.

Can I automate sensitivity analysis and balance checks in financial modeling?▼

Yes, you can automate sensitivity analysis and balance checks in financial modeling. The Skill builds valuation schedules and reconciliations with built-in checks that tie out and support key driver analysis.

How do you handle headless recalculation for spreadsheet automation pipelines?▼

Headless recalculation for spreadsheet automation is handled by producing files with openpyxl and using a helper script to recalculate formulas, enabling seamless integration into automated financial modeling pipelines.

Do I need openpyxl to build Excel workbooks with transparent formulas?▼

Yes, you need openpyxl to build Excel workbooks with transparent formulas. The Skill requires openpyxl-based .xlsx generation to apply cell conventions, named ranges, and hardcoded input comments for auditable output.

Related Skills

Explore More Finance & Accounting Skills→
projectedanxprojectedanx
1

excel-author

Generate auditable Excel workbooks with openpyxl for financial modeling.

Community
Advanced
lava-chenlava-chen
1

xlsx

Create and edit XLSX, XLSM, CSV, and TSV spreadsheets with formulas and formatting.

Community
Advanced
LynxLabVNLynxLabVN

excel-author

Create Excel workbooks for financial modeling with openpyxl conventions.

Official
Advanced
MooseGoose0701MooseGoose0701
1.1k

spreadsheet

Create, edit, analyze, and visualize .xlsx, .csv, and .tsv files with Python.

Community
Intermediate