讨论

面向AI的电子表格建模提示词(适用于Sheets)

来自 Wikiprompt,自由的提示词百科全书

Sonal Shukla

2026年6月8日

面向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 工具中。

为获得最佳效果,可将占位符(方括号或大写字母标示)替换为你的具体需求。

参考资料

分类:productivity| twitter| spreadsheet| google-sheets

讨论