Back to Templates
RESEARCH TOOL
Gabor-Granger Analysis Sheet
Spreadsheet to process survey data and calculate the optimal price point from willingness-to-pay responses.
LIVE PREVIEW
| Price Point | Respondents (Cumulative) | % Willing to Buy | projected Sales (N=1000) | Projected Revenue |
|---|---|---|---|---|
| $50 | 950 | 95% | 950 | $47,500 |
| $60 | 800 | 80% | 800 | $48,000 |
| $70 | 500 | 50% | 500 | $35,000 (Drop-off) |
| -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- |
Instructions
- 1Data Entry: Input survey 'Yes' counts.
- 2Curve: Plot Price vs Revenue.
- 3Peak: Identify max revenue.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Turn survey data into a clear revenue demand curve.
Key Features
Auto-Calculation: Cumulative logic.
Revenue Projection: Formula based.
Common Use Cases
New Feature Pricing: Monetization.
Price Hikes: Churn prediction.
Frequently Asked Questions
What about costs?
Add a cost column to calculate Profit, not just Revenue.