Google Sheets prompts Page 2 of 6
Prompts
-
Budget Variance Investigation
Explain gaps between budget and actuals.
-
Unit Economics Audit
Evaluate CAC, LTV, margins, and payback calculations.
-
Pricing and Margin Model Review
Check cost allocation and price-setting logic.
-
Scenario and Sensitivity Design Review
Check that scenarios are coherent and informative.
-
Budget Model Input Control Audit
Audit a budget model's input controls: how numbers enter and change, who can edit them and how changes are tracked.
-
Break-Even Model Verification Walkthrough
Verify break-even calculations step by step.
-
Startup Financial Model Sanity Audit
Check growth, costs and cash assumptions for plausibility.
-
Three-Statement Model Integrity Audit
Check that income, balance and cash flow tie together.
-
Pricing Model Spreadsheet Audit
Check margins, discounts and volume tiers.
-
Loan and Mortgage Comparison Sheet Audit
Check amortisation and fee assumptions.
-
Break-Even and Scenario Workbook Audit
Check fixed and variable cost logic.
-
Cash Flow Forecast Spreadsheet Audit
Check timing, assumptions and buffers.
-
Household Budget Spreadsheet Audit
Check categories, totals and missing irregular costs.
-
Three-Statement Model Integrity Check
Verify linkage between income, balance sheet, and cash flow.
-
Revenue Forecast Assumption Challenge
Stress-test growth assumptions like an investor.
-
Valuation Model Sensitivity and Method Review
Examine a discounted cash flow or multiples valuation.
-
Cash Runway and Scenario Model Audit
Check a startup or small business cash model.
-
Lease, Loan and Capital Budgeting Calculation Check
Verify lease, loan and capital budgeting calculations such as NPV, IRR and payback in your spreadsheet financial model.
-
KPI and Ratio Calculation Standardization
Make financial metrics consistent across reports.
-
Departmental Cost Allocation Fairness Review
Examine shared-cost allocation methods.
-
Formula Error Hunt
Hunt for broken or inconsistent formulas in a spreadsheet, with an explanation of each error and a suggested fix.
-
Lookup and Match Troubleshooter
Diagnose VLOOKUP, XLOOKUP, INDEX/MATCH failures.
-
Workbook Structure and Dependency Review
Assess the architecture of a multi-tab workbook for fragility.
-
Pivot Table and Report Accuracy Check
Verify that reports tie to source data.
-
Named Range and Table Reference Audit
Check that references are stable and understandable.
-
Circular Reference and Iterative Calculation Review
Find and handle circular logic safely.
-
Version Comparison and Change Detection Audit
Find what changed between two versions of a workbook.
-
Hardcoded Number Hunt in a Budget Workbook
Find typed-over formulas and constants buried in calculations.
-
Lookup Function Error Audit
Check lookups for wrong matches, missing values and fragile ranges.
-
Date and Time Calculation Audit
Find errors from text dates, time zones and month-end logic.
-
Circular Reference and Dependency Audit
Trace loops and fragile chains of dependency.
-
Percentage and Rate Calculation Audit
Check percentages, growth rates and weighted averages.
-
Array and Dynamic Formula Audit
Check modern formulas for spill errors and version dependence.
-
Unit and Currency Mismatch Audit
Find mixed units, currencies and scale errors.
-
Hardcoded Numbers and Hidden Assumptions Finder
Locate constants buried in formulas.
-
Date, Time Zone and Rounding Error Audit
Find calculation errors tied to dates and precision.
-
Array, SUMPRODUCT and Dynamic Formula Review
Review array, SUMPRODUCT and dynamic array formulas for correctness and fragility, with simpler alternatives to consider.
-
Cross-Sheet and External Link Dependency Audit
Trace how a workbook depends on other sheets and files.
-
Macro and Script Review for Spreadsheets
Review VBA or Apps Script for risk and reliability.
-
Conditional Logic and Nested IF Simplifier
Untangle decision formulas.
-
Spreadsheet Error Risk Scorecard (Before Sharing)
Run a final review before sending a workbook.
-
Google Sheets Apps Script Triggers and Permissions Review
Review scripts attached to a spreadsheet for risks.
-
Google Sheets Import Function Reliability Audit
Find fragile imports that may break or show stale data.
-
Google Sheets Form Response Data Quality Audit
Find duplicates, odd values and missing answers in form data.
-
Google Sheets Protected Ranges and Edit History Audit
Check who can change what and what changed recently.
-
Google Sheets Performance and Size Audit
Find reasons for a slow shared sheet.
-
Power BI Row-Level Security Rules Review (Defensive)
Review the row-level security roles on your own Power BI model for gaps, overlaps and test coverage, with a checklist for safe validation.
-
Power BI Date Table and Time Intelligence Check
Check a Power BI model's date table, relationships and year-to-date style measures for gaps and wrong comparisons, with test cases to verify.