OpenGolem: Skill for Claude Code

SKILL.md — /xlsx Corporate Workbook Generator

What It Does

Generates professional Excel workbooks (.xlsx) from structured input. Output is generated from the reference template at: .claude/skills/xlsx/templates/reference.xlsx

How to Invoke

/xlsx [workbook title] — [brief description of the workbook, sheets, and data it should contain]

The agent will generate a complete corporate workbook and recalculate formulas when needed.

---

Output

• File: output/[title]_YYYY-MM-DD.xlsx
• Format: Corporate workbook with a cover sheet plus styled data sheets
• Template: Loads .claude/skills/xlsx/templates/reference.xlsx directly and preserves its workbook styles, page setup, sheet layout, and header/footer behavior

---

Workbook Structure

Every generated workbook follows this structure:

1. COVER
   ├── Workbook title
   ├── Subtitle (if applicable)
   ├── Prepared by
   ├── Date
   ├── Classification
   └── Sheet index / notes

2. WORKSHEETS
   ├── Sheet title row
   ├── Header row with filters
   ├── Data rows
   └── Optional formulas / notes

---

Formatting Standards

• Template authority: The reference workbook controls the visual system
• Headers: Dark fill, white bold text
• Body cells: Clean corporate formatting
• Hardcoded inputs: Blue text
• Formulas: Black text
• Negative values: Prefer number formats with parentheses where appropriate
• Freeze panes: Header row remains visible
• Filters: Enabled on header rows

---

Generation Script

Use the provided generator: .claude/skills/xlsx/scripts/generate_corporate_xlsx.py

python3 .claude/skills/xlsx/scripts/generate_corporate_xlsx.py \
  --title "Fuel Oil Market Workbook" \
  --subtitle "Q1 2026 Benchmark Review" \
  --date "April 2026" \
  --classification "CONFIDENTIAL" \
  --prepared-by "BedRock AI Research" \
  --output output/fuel_oil_workbook.xlsx \
  --sheets-json '[
    {
      "name": "Key Metrics",
      "description": "Top-line findings and benchmark statistics",
      "headers": ["Metric", "Value", "Notes"],
      "rows": [
        ["MOC Window", "30 minutes", "Platts closing window"],
        ["Settlement", 1100000000, "2022 Glencore resolution"],
        ["Coverage", "=COUNTA(A4:A5)", "Formula example"]
      ]
    },
    {
      "name": "Trade Log",
      "description": "Observed transactions and flags",
      "headers": ["Date", "Counterparty", "Volume", "Flag"],
      "rows": [
        ["2026-03-01", "Firm A", 42000, "Review"],
        ["2026-03-02", "Firm B", 38000, "Escalate"]
      ]
    }
  ]'