面向AI的电子表格建模提示词(适用于Sheets)
来自 Wikiprompt,自由的提示词百科全书
面向AI的电子表格建模提示词(适用于Sheets) 一套实用的AI提示词合集,用于在Google Sheets中使用Claude Cowork或ChatGPT构建、分析和调试财务电子表格。
提示词内容收藏
🌐
Build me a [TYPE] spreadsheet from this data
List your top 10 assumptions before executing
Use named ranges so formulas read like English
Keep all inputs on an Assumptions tab
Format for board projection: clean palette, frozen rows
Add a Dashboard tab with KPI tiles
Add Base / Bull / Bear scenario toggle
Add a P&L tab linked to the Revenue tab
Build a 12-month forecast by service line
Add a Funnel tab: audience → leads → deals
What trends stand out in 2026 vs 2025?
Compare actuals to budget, explain top 3 variances
Categorize these transactions into expense types
Which line items grow faster than revenue?
Find the deals that closed fastest - what's in common?
Visualize @Revenue as a stacked bar
Summarize @Funnel in 5 bullets
In @Assumptions, push Bull more optimistic - stay realistic
Add conditional formatting on margin %
Translate @Dashboard into French
Explain what the formula in [CELL] does in plain English
Trace [CELL] back to its source inputs
Why is [CELL] showing #REF! / #VALUE! / #DIV/0?
Show me how [CELL] connects to the Assumptions tab
Find any hardcoded numbers inside formulas
Add a data table for revenue at different growth rates
Add a Monte Carlo simulation on key drivers
Convert this monthly model to weekly granularity
Reconcile @Revenue tab with @P&L tab find mismatches
Stress-test the model what breaks first?
用法
此提示词专为 productivity 设计。复制上方内容并粘贴到你常用的 AI 工具中。
为获得最佳效果,可将占位符(方括号或大写字母标示)替换为你的具体需求。
讨论
0 条评论