原文核对：2026-10-13 · 中文正文 · 英文提示词与演示
场景定位
根据导出、关联键、目标和规则生成可更新工作簿，保留图表、假设、刷新说明和错配审阅。
- 难度
- 中级
- 时间跨度
- 1 小时
适合用于
- 多导出合成可更新工作簿的报告流程。
- 有明确关联键和目标的商机、账户、运营或绩效分析。
- 需要单独检查错配记录和刷新假设的团队。
相关工具
起步提示词
英文原文 · 可复制后按实际材料修改
Consolidate the attached spreadsheet exports into one updateable workbook.
Join on [record or account key]. Clean duplicate records, calculate [metrics or views], compare [actuals or pipeline] with [target], and create a dashboard with charts and plain-English insights.
Include:
- assumptions and refresh instructions
- a review section for mismatched keys or records that did not join cleanly
- a short change log
Do not invent join keys or silently merge conflicting records. Preserve the original files and return the consolidated workbook for review.明确关联与报告规则
指定键、字段、目标计算和去重规则；关联失败的记录应显式呈现，不猜测匹配。
- 提供导出、映射、目标和报告要求。
- 确认键、去重、期间和输出视图。
- 要求可编辑工作簿及审阅部分。
- 检查公式、关联、错配、假设和刷新说明。
- 来源或规则改变后重新检查。
保留原始导出，明确哪些行已关联、被排除，以及刷新依赖的假设。
验证刷新路径
模拟下一次刷新，区分可重复步骤和仍需人工决定的步骤。
官方提示词
英文原文 · 可复制后按实际材料修改
Test the refresh process for this consolidated workbook.
Report:
- inputs that can be replaced without changing the workflow
- formulas, joins, and charts that update correctly
- duplicate or mismatched keys
- assumptions that are not documented
- rows that need manual review
- steps that should become a reusable skill or automation
Do not overwrite the source exports or change business definitions.展开英文原文对照
Give ChatGPT spreadsheet exports, join keys, targets, segment definitions, and reporting rules, then ask it to create a consolidated workbook with cleaned joins, charts, insights, assumptions, refresh instructions, and mismatch review.
Establish the join and reporting rules
Consolidation is safest when the key, field definitions, target calculations, and duplicate rules are explicit. Give ChatGPT the source exports and ask it to surface records that do not join cleanly instead of guessing.
- Attach the exports, mapping notes, targets, and reporting requirements.
- Confirm the join key, duplicate rule, period definitions, and required output views.
- Run the starter prompt and request an editable workbook with a review section.
- Inspect formulas, joins, mismatches, assumptions, and refresh instructions.
- Re-run the checks after any change to the source files or reporting rules.
Keep the original exports unchanged. A useful consolidated workbook makes it easy to tell which rows joined, which were excluded, and which assumptions a future refresh depends on.
Validate the refresh path
After the first workbook is ready, ask ChatGPT to simulate the next refresh and report which steps are repeatable and which still need a human decision.
官方提示词
英文原文 · 可复制后按实际材料修改
Test the refresh process for this consolidated workbook.
Report:
- inputs that can be replaced without changing the workflow
- formulas, joins, and charts that update correctly
- duplicate or mismatched keys
- assumptions that are not documented
- rows that need manual review
- steps that should become a reusable skill or automation
Do not overwrite the source exports or change business definitions.