跳到正文
cccskills
免费在 GitHub 公开

deck-refresh

Update figures throughout an existing presentation while preserving its formatting. Find equivalent values across text, tables, and chart data, present a change list for approval, and flag related growth rates or percentages that may need recalculation.

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

原文查看原文说明

Updates a presentation with new numbers — quarterly refreshes, earnings updates, comp rolls, rebased market data. Use whenever the user asks to "update the deck with Q4 numbers", "refresh the comps", "roll this forward", "swap in the new earnings", "change all the $485M to $512M", or any request to swap figures across an existing deck without rebuilding it.

查看安装方法

适用场景

  • Updating a presentation with quarterly results
  • Refreshing figures in peer comparison slides
  • Replacing values using an Excel update sheet
  • Checking related growth rates after revenue changes

包含的文件(1)

  • SKILL.md6.0 KB

SKILL.md(原文)

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

Deck Refresh

Update numbers across the deck. The deck is the source of truth for formatting; you're only changing values.

Environment check

This skill works in both the PowerPoint add-in and chat. Identify which you're in before starting — the edit mechanism differs, the intent doesn't:

  • Add-in — the deck is open live; edit text runs, table cells, and chart data directly.
  • Chat — the deck is an uploaded file; edit it by regenerating the affected slides with the new values and writing the result back.

Either way: smallest possible change, existing formatting stays intact.

This is a four-phase process and the third phase is an approval gate. Don't edit until the user has seen the plan.

Phase 1 — Get the data

Use ask_user_question to find out how the new numbers are arriving:

  • Pasted mapping — user types or pastes "revenue $485M → $512M, EBITDA $120M → $135M." The clearest case.
  • Uploaded Excel — old/new columns, or a fresh output sheet the user wants pulled from. Read it, confirm which column is which before you trust it.
  • Just the new values — "Q4 revenue was $512M, margins were 22%." You figure out what each one replaces. Workable, but confirm the mapping before you touch anything — a "$512M" that you map to revenue but the user meant for gross profit is a quiet disaster.

Also ask about derived numbers: if revenue moves, does the user want growth rates and share percentages recalculated, or left alone? Most decks have "+15% YoY" baked in somewhere that's now stale. Whether to touch those is a judgment call the user should make, not you.

Phase 2 — Read everything, find everything

Read every slide. For each old value, find every instance — including the ones that don't look the same:

VariantExample
Scale$485M, $0.485B, $485,000,000
Precision$485M, $485.0M, ~$485M
Unit style$485M, $485MM, $485 million, 485M
Embedded"revenue grew to $485M", "a $485M business", axis labels

A deck that says $485M on slide 3, 485 on slide 8's chart axis, and $485.0 million in a footnote on slide 15 has three instances of the same number. Find-replace misses two of them. You shouldn't.

Where numbers hide:

  • Text boxes (obvious)
  • Table cells
  • Chart data labels and axis labels
  • Chart source data — the numbers driving the bars, not just the labels on them
  • Footnotes, source lines, small print
  • Speaker notes, if the user cares about those

Build a list: for each old value, every location it appears, the exact text it appears as, and what it'll become. This list is the plan.

Phase 3 — Present the plan, get approval

This is a destructive operation on a deck someone spent time on. Show the full change list before editing a single thing. Format it so it's scannable:

$485M → $512M (Revenue)
  Slide 3  — Title box: "Revenue grew to $485M"
  Slide 8  — Chart axis label: "485"
  Slide 15 — Footnote: "$485.0 million in FY24 revenue"

$120M → $135M (Adj. EBITDA)
  Slide 3  — Table cell
  Slide 11 — Body text: "$120M of Adj. EBITDA"

FLAGGED — possibly derived, not in your mapping:
  Slide 3  — "+15% YoY" (growth rate — stale if base year didn't change?)
  Slide 7  — "12% market share" (was this computed from $485M / market size?)

The flagged section matters. You're not just executing a find-replace — you're catching the second-order effects the user would've missed at 11pm. If the mapping says $485M → $512M and slide 3 also has +15% YoY right next to it, that growth rate is probably wrong now. Flag it; don't silently fix it, don't silently leave it.

Use ask_user_question for the approval: proceed as shown, proceed but skip the flagged items, or let them revise the mapping first.

Phase 4 — Execute, preserve, report

For each change, make the smallest edit that accomplishes it. How that happens depends on your environment:

  • Add-in — edit the specific run, cell, or chart series directly in the live deck.
  • Chat — regenerate the affected slide with the new value in place, preserving every other element exactly as it was, and write it back to the file.

Either way, the standard is the same:

  • Text in a shape — change the value, leave font/size/color/bold state exactly as they were. If $485M is 14pt navy bold inside a sentence, $512M is 14pt navy bold inside the same sentence.
  • Table cell — change the cell, leave the table alone.
  • Chart data — update the underlying series values so the bars/lines actually move. Editing just the label without the data leaves a chart that lies.

Don't reformat anything you didn't need to touch. The deck's existing style is correct by definition; you're a surgeon, not a renovator.

After the last edit, report what actually happened:

Updated 11 values across 8 slides.

Changed:
  [the list from Phase 3, now past-tense]

Still flagged — did NOT change:
  Slide 3 — "+15% YoY" (derived; confirm separately)
  Slide 7 — "12% market share"

Run standard visual verification checks on every edited slide. A number that got longer ($485M → $1,205M) might now overflow its text box or push a table column width. Catch it before the user does.

What you're not doing

  • Not rebuilding slides — if a slide's narrative no longer makes sense with the new numbers ("margins compressed" but margins went up), flag it, don't rewrite it.
  • Not recalculating unless asked — derived numbers are the user's call. Your Phase 1 question covers this.
  • Not touching formatting — if the deck uses $MM and the user's mapping says $M, match the deck, not the mapping. Values change; style stays.

评价

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

评论

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

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

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

0 / 1000 字

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

同一仓库的技能

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万2026年9月22日 更新

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万2026年9月22日 更新

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万2026年9月22日 更新

audit-xls

免费

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万2026年9月22日 更新

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万2026年9月22日 更新

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万2026年9月22日 更新

查看 anthropics 的全部技能

报告此技能的问题