跳到正文
cccskills
Claude 官方免费在 GitHub 公开

xlsx-author

Generate an Excel workbook file in an agent session without an open Office app. Use Python and openpyxl to organize inputs, formulas, and checks, then save the .xlsx file and return its relative path.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

Produce a .xlsx file on disk (headless) instead of driving a live Excel workbook — for managed-agent sessions with no open Office app.

集成工具Excel

实测评分 未实测

查看安装方法

适用场景

  • Creating an Excel file without opening Office
  • Keeping model inputs and calculations on separate sheets
  • Adding a sheet for financial consistency checks
  • Delivering a workbook file with its saved path

包含的文件(1)

  • SKILL.md1.8 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

xlsx-author

Use this skill when running headless (managed-agent / CMA mode) and you need to deliver an Excel workbook as a file artifact rather than editing a live workbook via mcp__office__excel_*.

Output contract

  • Write to ./out/<name>.xlsx. Create ./out/ if it does not exist.
  • Return the relative path in your final message so the orchestration layer can collect it.

How to build the workbook

Write a short Python script and run it with Bash. Use openpyxl:

from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill

wb = Workbook()
ws = wb.active; ws.title = "Inputs"
ws["B2"] = "Revenue"; ws["C2"] = 1_250_000_000
ws["C2"].font = Font(color="0000FF")           # blue = hardcoded input
calc = wb.create_sheet("DCF")
calc["C5"] = "=Inputs!C2*(1+Inputs!C3)"        # black = formula
wb.save("./out/model.xlsx")

Conventions (mirror audit-xls)

  • Blue / black / green. Blue = hardcoded input, black = formula, green = link to another sheet/file.
  • No hardcodes in calc cells. Every calculation cell is a formula; every input lives on an Inputs tab.
  • Named ranges for any value referenced from a deck or memo.
  • Balance checks. Include a Checks tab that ties (BS balances, CF ties to cash, etc.) and surfaces TRUE/FALSE.
  • One model per file. Do not append to an existing workbook unless explicitly asked.

When NOT to use

If mcp__office__excel_* tools are available (Cowork plugin mode), use those instead — they drive the user's live workbook with review checkpoints. This skill is the file-producing fallback for headless runs.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

3-statement-model

Claude 官方免费

Complete an existing financial model template by entering historical data and forecast assumptions, then linking the income statement, balance sheet, and cash flow statement with formulas. Check statement balances, cash consistency, and scenario behavior as each section is completed.

中文简介正在准备中。当前显示英语简介。

  • Complete a partially filled financial model
  • Link forecasts across three financial statements
  • Check balance sheet and cash flow consistency
anthropics/financial-services4.1万2026年9月22日 更新

accrual-schedule

Claude 官方免费

Prepare a period-end accrual schedule for expenses incurred but not yet fully recorded. Apply company policy, subtract amounts already booked, cite supporting records, and draft journal entries for controller approval, including reversal notes where required.

中文简介正在准备中。当前显示英语简介。

  • Preparing an accrual schedule for month-end close
  • Calculating audit fee, bonus, or utilities accruals
  • Drafting journal entries with supporting references
anthropics/financial-services4.1万2026年9月22日 更新

ai-readiness

Claude 官方免费

Review quarterly updates and financials across portfolio companies to identify practical AI opportunities. Rank them by estimated profit impact, speed, and feasibility, then outline first steps and approaches that other companies can reuse.

中文简介正在准备中。当前显示英语简介。

  • Quarterly reviews of AI opportunities across portfolio companies
  • Prioritizing companies for AI investment and operational support
  • Finding ways to reuse successful AI projects across companies
anthropics/financial-services4.1万2026年9月22日 更新

audit-xls

Claude 官方免费

Check spreadsheet formulas for errors, broken references, inconsistent calculations, and unit mismatches. Review a selected range, one sheet, or an entire financial model, then receive findings ranked by severity with suggested fixes.

中文简介正在准备中。当前显示英语简介。

  • Checking formulas in a selected range
  • Investigating a balance sheet that does not balance
  • Reviewing a financial model before client delivery
anthropics/financial-services4.1万2026年9月22日 更新

bond-futures-basis

Claude 官方免费

Analyze price differences between bond futures and cash bonds, identify the cheapest bond to deliver, and compare implied financing rates with market rates. Present valuation tables and historical context to assess potential basis trades.

中文简介正在准备中。当前显示英语简介。

  • Comparing bond futures with cash bond prices
  • Identifying the cheapest bond to deliver
  • Comparing implied financing rates with market rates
anthropics/financial-services4.1万2026年9月22日 更新

bond-relative-value

Claude 官方免费

Assess whether bonds are expensive, cheap, or fairly priced by comparing yields with government rates and credit risk benchmarks. Combine spread breakdowns, historical context, and interest rate scenarios into tables and a recommendation.

中文简介正在准备中。当前显示英语简介。

  • Comparing the relative value of candidate bonds
  • Separating credit risk from other yield differences
  • Estimating gains and losses under interest rate shifts
anthropics/financial-services4.1万2026年9月22日 更新

查看 anthropics 的全部技能

报告此技能的问题