原文核对：2026-10-13 · 中文正文 · 英文提示词与演示
场景定位
进行安全的小范围清理，按严重程度报告公式、断链、来源勾稽和待负责人判断的假设。
- 难度
- 中级
- 时间跨度
- 1 小时
适合用于
- 管理层、投资者或董事会审阅前的模型 QA。
- 存在硬编码、断链、期间不一致或检查不清的工作簿。
- 需区分安全清理和业务假设变化的团队。
相关工具
检查结构公式，做安全修改并渲染结果。
起步提示词
英文原文 · 可复制后按实际材料修改
Use $spreadsheets to clean and review [model name] before it goes to [audience].
Inspect workbook structure, formulas, hardcodes, broken links, circular references, sign conventions, period labels, source tie-outs, model checks, and output tabs. Pay special attention to [priority tabs or outputs].
Make safe cleanup and formula fixes where the intended behavior is clear. Do not change business assumptions without approval. Return an editable cleaned workbook plus a severity-ranked QA memo with issues found, fixes made, remaining assumptions, and the exact cells or tabs that need finance-owner review. Preserve the original file as a separate input.简介
模型可能积累隐藏硬编码、旧链接、期间不一致和失效勾稽。系统检查并做小范围修复，以 QA 说明指出仍需财务判断的部分。
界定范围
提供模型和勾稽来源，说明受众、重点页、输出和禁止修改的假设，保留原文件便于比较。
- 上传模型及来源。
- 指定重点页、检查和受保护假设。
- 要求清理副本与 QA 说明。
- 检查公式、链接和输出修改。
- 接受假设变化前解决负责人问题。
检查清理
按严重程度定位到具体单元格或页。可直接处理安全格式、标签和明确公式修复；业务逻辑不清时留待审阅。
官方提示词
英文原文 · 可复制后按实际材料修改
Compare the cleaned model with the original.
List:
- formulas, links, or checks that changed
- source tie-outs that now pass or still fail
- hardcodes and assumptions that remain
- circular references or sign issues
- output tabs affected by the changes
- items that require finance-owner approval
Do not make additional assumption changes. Return a concise change log with exact cell or tab references.展开英文原文对照
Give ChatGPT a financial model and its supporting sources, then ask it to make safe cleanup changes and return a severity-ranked QA memo covering formula risks, broken links, source tie-outs, and assumptions that need an owner.
Introduction
Financial models often accumulate hidden hardcodes, stale links, inconsistent periods, and checks that no longer tie. ChatGPT can inspect the workbook systematically, make narrowly scoped fixes, and produce a QA memo that tells a finance owner where judgment is still required.
Define the review boundary
Attach the model and the source files it should tie to. Name the audience, priority tabs, expected outputs, and any assumptions ChatGPT must leave unchanged. Keep the original workbook available so you can compare every edit.
- Attach the model and its supporting source files.
- Identify priority tabs, expected checks, and protected assumptions.
- Run the starter prompt and request a cleaned copy plus a QA memo.
- Open the workbook in ChatGPT and inspect changed formulas, links, and output tabs.
- Resolve finance-owner questions before accepting assumption changes.
Check the cleanup
The QA memo should rank issues by severity and point to exact cells or tabs. Safe formatting, labeling, and clear formula repairs can be applied directly; ambiguous business logic should remain flagged for review.
官方提示词
英文原文 · 可复制后按实际材料修改
Compare the cleaned model with the original.
List:
- formulas, links, or checks that changed
- source tie-outs that now pass or still fail
- hardcodes and assumptions that remain
- circular references or sign issues
- output tabs affected by the changes
- items that require finance-owner approval
Do not make additional assumption changes. Return a concise change log with exact cell or tab references.