xlsx

Create, edit, and analyze Excel spreadsheets with formulas, formatting, and visualizations.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/botassembly/jn --skill xlsx-botassembly
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/botassembly/jn/tree/main/demos/markdown-skills/data/xlsx
Command: npx skills add https://github.com/botassembly/jn --skill xlsx-botassembly

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enforces Excel modeling discipline: zero formula errors, template preservation, color/number conventions, and thorough documentation for hardcoded values.

Core Features & Use Cases

  • Zero formula errors and template preservation when updating models.
  • Color coding standards for hard inputs, calculations, internal links, and external links.
  • Number formatting standards (years as text, currency formats, negative numbers as parentheses).
  • Formula construction rules and documentation of hardcodes.
  • LibreOffice-based recalculation with recalc.py script.

Quick Start

Open the workbook and enforce the guidelines; when formulas update, run recalc.py to recompute values.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create Excel spreadsheets with zero formula errors and maintain formatting standards?

Create spreadsheets by enforcing modeling discipline: apply color coding for hard inputs, calculations, internal links, and external links; use strict number formatting conventions; document all hardcoded values; and run recalc.py for LibreOffice-based formula recalculation to eliminate errors.

What's the best way to update Excel templates without breaking formulas?

Update templates by preserving the existing formula structure, applying consistent color and number formatting standards, documenting any hardcoded changes, and running recalc.py to recompute all dependent values across the workbook.

How do I format financial models with color conventions and number standards?

Apply color coding to distinguish hard inputs, calculations, internal links, and external references; format years as text, use currency formats, and display negative numbers in parentheses; document conventions so models remain auditable and maintainable.

Can I analyze and visualize data across multiple Excel workbooks and dashboards?

Yes. Read, analyze, and generate data visualizations across financial models, dashboards, and scenario analyses while maintaining formula accuracy through recalc.py and enforcing consistent formatting and color conventions throughout.

What happens if I edit formulas in an Excel model—how do I recalculate values?

After editing formulas, run recalc.py to trigger LibreOffice-based recalculation, ensuring all dependent cells update correctly and formula errors are caught before the model is used in analysis or reporting.

Why is documentation of hardcoded values important in financial modeling?

Documenting hardcoded values prevents formula errors, enables auditing, reduces calculation mistakes, and ensures other users understand model assumptions and can update scenarios accurately without breaking dependent calculations.