deck-refresh
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseDeck Refresh
Deck数据刷新
Update numbers across the deck. The deck is the source of truth for formatting; you're only changing values.
更新整个Deck中的数据。Deck的格式为基准,仅修改数值内容。
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.
此技能可在PowerPoint插件和聊天界面中使用。开始操作前需确认所处环境——编辑机制不同,但目标一致:
- 插件 — Deck处于实时打开状态;可直接编辑文本段、表格单元格和图表数据。
- 聊天界面 — Deck为上传文件;通过重新生成包含新数值的受影响幻灯片并写回结果来完成编辑。
无论哪种方式:尽可能做最小改动,保留现有格式不变。
此流程分为四个阶段,其中第三阶段为审批环节。在用户确认方案前,请勿进行任何编辑操作。
Phase 1 — Get the data
第一阶段 — 获取数据
Use to find out how the new numbers are arriving:
ask_user_question- 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.
使用询问用户新数据的提供方式:
ask_user_question- 粘贴映射 — 用户输入或粘贴“营收 $485M → $512M,EBITDA $120M → $135M”。这是最清晰的场景。
- 上传Excel文件 — 包含旧/新数据列,或用户希望从中提取数据的全新输出表格。读取文件后,需先确认各列对应关系再进行操作。
- 仅提供新数值 — “Q4营收为$512M,利润率为22%”。你需要自行判断每个数值对应的替换项。此方式可行,但在操作前必须确认映射关系——若你将$512M映射为营收,但用户实际指的是毛利,将会造成严重问题。
同时询问衍生数据相关问题:若营收数据变动,用户是否希望重新计算增长率和份额百分比,还是保持原样?大多数Deck中会包含诸如“+15% YoY”这类已过时的衍生数据。是否修改这些数据应由用户决定,而非你自行判断。
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:
| Variant | Example |
|---|---|
| Scale | |
| Precision | |
| Unit style | |
| Embedded | "revenue grew to $485M", "a $485M business", axis labels |
A deck that says on slide 3, on slide 8's chart axis, and in a footnote on slide 15 has three instances of the same number. Find-replace misses two of them. You shouldn't.
$485M485$485.0 millionWhere 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.
读取每一张幻灯片。针对每个旧数值,查找所有出现的实例——包括格式不同的情况:
| 变体类型 | 示例 |
|---|---|
| 数值规模 | |
| 精度格式 | |
| 单位样式 | |
| 嵌入文本 | "营收增长至$485M", "一家规模为$485M的企业", 坐标轴标签 |
若某Deck在第3页显示,第8页图表坐标轴显示,第15页脚注显示,这三个均为同一数值的不同实例。普通查找替换会遗漏其中两个,而你不能遗漏。
$485M485$485.0 million数值隐藏位置:
- 文本框(显而易见)
- 表格单元格
- 图表数据标签和坐标轴标签
- 图表源数据——驱动图表柱形/折线的底层数据,而非仅图表上的标签
- 脚注、来源标注、小号字体文本
- 演讲者备注(若用户关注此项)
构建一份清单:记录每个旧数值的所有出现位置、显示的精确文本以及替换后的新数值。此清单即为操作方案。
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 and slide 3 also has right next to it, that growth rate is probably wrong now. Flag it; don't silently fix it, don't silently leave it.
$485M → $512M+15% YoYUse for the approval: proceed as shown, proceed but skip the flagged items, or let them revise the mapping first.
ask_user_question此操作会对他人耗时制作的Deck产生修改影响。 在进行任何编辑前,需向用户展示完整的变更清单。清单格式应便于快速浏览:
$485M → $512M(营收)
第3页 — 标题框:"营收增长至$485M"
第8页 — 图表坐标轴标签:"485"
第15页 — 脚注:"FY24营收为$485.0 million"
$120M → $135M(调整后EBITDA)
第3页 — 表格单元格
第11页 — 正文文本:"调整后EBITDA为$120M"
标记项 — 可能为衍生数据,未在映射中提及:
第3页 — "+15% YoY"(增长率——若基准年份未变则已过时?)
第7页 — "12%市场份额"(是否由$485M / 市场规模计算得出?)标记部分至关重要。你并非仅执行查找替换操作——而是要捕捉用户在深夜可能忽略的二次影响。若映射关系为,而第3页同时紧邻显示,则该增长率很可能已失效。需标记此项,既不擅自修改,也不视而不见。
$485M → $512M+15% YoY使用请求用户审批:按方案执行、执行但跳过标记项,或先让用户修改映射关系。
ask_user_questionPhase 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 is 14pt navy bold inside a sentence,
$485Mis 14pt navy bold inside the same sentence.$512M - 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 ( → ) might now overflow its text box or push a table column width. Catch it before the user does.
$485M$1,205M针对每一项变更,采用最小改动完成操作。具体方式取决于所处环境:
- 插件 — 在实时打开的Deck中直接编辑特定文本段、单元格或图表系列。
- 聊天界面 — 重新生成包含新数值的受影响幻灯片,完全保留其他所有元素,然后写回文件。
无论哪种方式,标准一致:
- 形状中的文本 — 修改数值,完全保留字体、字号、颜色、加粗状态。若句子中的为14号深蓝色加粗字体,则替换后的
$485M也需保持14号深蓝色加粗字体。$512M - 表格单元格 — 修改单元格内容,保留表格其他部分不变。
- 图表数据 — 更新底层系列数值,使柱形/折线实际变化。仅修改标签而不更新数据会导致图表失真。
请勿修改任何无需触碰的格式。Deck的现有样式默认是正确的;你是精准操作的外科医生,而非全面翻新的装修工。
完成最后一项编辑后,向用户报告实际操作情况:
已更新8张幻灯片中的11处数值。
已修改内容:
[第三阶段的清单,改为过去时态]
仍为标记项 — 未进行修改:
第3页 — "+15% YoY"(衍生数据;需单独确认)
第7页 — "12%市场份额"对每张编辑过的幻灯片进行标准视觉验证检查。若数值长度增加(如 → ),可能会导致文本框溢出或表格列宽变化。需在用户发现前捕捉此类问题。
$485M$1,205MWhat 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 and the user's mapping says
$MM, match the deck, not the mapping. Values change; style stays.$M
- 不得重建幻灯片 — 若新数据导致幻灯片的叙述逻辑不合理(如文字显示“利润率压缩”但实际利润率上升),需标记此项,不得重写内容。
- 未经请求不得重新计算 — 衍生数据的处理由用户决定。第一阶段的问题已涵盖此点。
- 不得修改格式 — 若Deck使用作为单位,而用户映射中使用
$MM,需匹配Deck的格式,而非映射中的格式。仅修改数值,保留样式不变。$M