原文核对：2026-10-13 · 中文正文 · 英文提示词与演示
场景定位
结合最新实际、获准假设和负责人输入更新模型，比较情景、敏感性和触发点。
- 难度
- 中级
- 时间跨度
- 1 小时
适合用于
- 纳入近期实际与获准假设的经营计划更新。
- 覆盖收入、利润率、招聘和现金的基准、乐观和悲观情景。
- 需敏感性、触发点和审批项的规划审阅。
相关工具
更新可编辑预测，保留假设控制，建立带公式检查的情景和敏感性表。
起步提示词
英文原文 · 可复制后按实际材料修改
Use $spreadsheets to refresh the [forecast or operating plan] for [business].
Use the attached operating model, revenue-driver model, headcount plan, cash forecast, latest actuals, approved planning assumptions, owner inputs, and prior forecast. Preserve the original model and make assumption changes visible.
Create base, downside, and upside scenarios with the key revenue, margin, hiring, and cash drivers. Summarize cash impact, hiring implications, trigger points, key sensitivities, risks, and a recommendation. Include a sensitivity table and list every assumption that needs approval before the plan is shared. Do not overwrite business assumptions silently.简介
说明哪些假设变了及其影响，更新模型、构建可比情景，并汇总管理层需审阅的敏感性和触发点。
准备输入
提供模型、实际、获准假设、负责人输入和旧预测，加上规划日程与情景规则，标出需批准才能改变的假设。
- 上传模型和驱动文件。
- 加入最新实际、假设、负责人输入和旧预测。
- 定义三类情景及受保护假设。
- 要求可编辑预测工作簿。
- 审阅假设变化、公式链接、敏感性和审批项。
- 继续逐个调整驱动因素。
比较情景
保持基准可见，每个情景追溯到少量明确驱动变化。
官方提示词
英文原文 · 可复制后按实际材料修改
Compare the base, downside, and upside scenarios.
For each scenario, list:
- changed assumptions and their source
- revenue, margin, hiring, and cash impact
- the most sensitive drivers
- trigger points that would move us into this scenario
- risks and open assumptions
- approvals required before sharing the plan
Check formula links and keep the prior forecast available for comparison. Do not change any additional assumptions.展开英文原文对照
Give ChatGPT an operating model, latest actuals, approved assumptions, owner inputs, and scenario rules, then ask it to refresh the forecast and compare scenarios with sensitivities, trigger points, and review notes.
Introduction
A forecast refresh should show which assumptions changed and how those changes affect the plan. ChatGPT can update an editable model, build comparable scenarios, and summarize the sensitivities and trigger points leadership should review.
Prepare the planning inputs
Attach the operating model, latest actuals, approved assumptions, owner inputs, and prior forecast. Include the planning calendar and scenario rules, and identify assumptions that ChatGPT may update only after approval.
- Attach the operating model and supporting driver files.
- Add the latest actuals, approved assumptions, owner inputs, and prior forecast.
- Define base, upside, and downside rules along with protected assumptions.
- Run the starter prompt and request an editable forecast workbook.
- Review assumption changes, formula links, sensitivities, and approval items.
- Continue in the same chat to tune one driver at a time.
Compare the scenarios
Good scenario planning makes the differences easy to audit. Keep the base case visible and trace each scenario back to a small set of explicit driver changes.
官方提示词
英文原文 · 可复制后按实际材料修改
Compare the base, downside, and upside scenarios.
For each scenario, list:
- changed assumptions and their source
- revenue, margin, hiring, and cash impact
- the most sensitive drivers
- trigger points that would move us into this scenario
- risks and open assumptions
- approvals required before sharing the plan
Check formula links and keep the prior forecast available for comparison. Do not change any additional assumptions.