Add Base Salary column to projections table, add 50% attainment to defaults
stepolan
8fe1fed
Fix session state conflict — use _default() helper on all widgets for plan loading
stepolan
396465d
Add Load Plan dropdown to sidebar — loads saved plan params for live editing
stepolan
bd920df
Add live projections table and agreement preview to Plan Builder tab
stepolan
ce5f3de
Refactor scenarios to plans with auto-projections
stepolan
6795a21
- Save a plan once (config only), auto-generate projections at 75/100/150/200%
- No more manually saving separate scenarios per attainment level
- New compute_projection() function computes results on-the-fly
- Compare tab shows all attainment levels per plan in one table
- Two charts: Total Comp and Net After Rep by attainment level
- Agreement text auto-generates illustrative earnings from projections
- Backward compatible with legacy scenarios via normalize_plan()
- Configurable attainment levels in sidebar
- Renamed: Scenario Calculator → Plan Builder, Compare Scenarios → Compare Plans
Add marginal vs retroactive rate toggle for commission tiers
stepolan
f57f6c4
Retroactive: once a threshold is crossed, the higher rate applies to ALL
revenue from dollar one. Much more expensive for the company but models
the co-founder's v3 plan structure accurately.
Add rich plan document format with deal types, targets, illustrative scenarios
stepolan
21b7b35
Supports co-founder's detailed comp plan view with:
- Deal type table (Enterprise/SMB with different rates)
- Annual quota built from deal targets
- Grouped ramp schedule with monthly targets and notes
- Accelerator tiers
- Illustrative earnings scenarios by deal mix
- Full policy terms
- Signature block
Calculate commission against full annual quota, not ramp-adjusted
stepolan
928cf68
Ramp still affects attainment % display but commission tiers run
against the full-year quota. This gives clean rates (8/14/26/50%)
that hit OTE targets exactly: 100% = $250K, 200% = $500K.
Update sn tiers to 9/12/18/31/57, change pay frequency to semi-monthly
stepolan
6475cf5
Format scenario details as agreement-ready text with download button
stepolan
ddc8c5c
Add select all / clear all toggle for scenario comparison
stepolan
f2314d2
Default to selecting all scenarios in compare view
stepolan
a57d759
Add scenario detail view with full plan config, save commission tiers in scenario data
stepolan
75ecc2d
Clarify other cost per rep is annual in tooltip
stepolan
3b87ee9
Add draw/ramp definitions in sidebar, update default base to 150K
stepolan
0ab0741
Default COGS to 20% for early-stage
stepolan
8cfe687
Add deeplink support via ?tab= query param
stepolan
9e2a43d
Improve UX with guided instructions, help tooltips, and clearer labels
stepolan
11d808e
Remove equity display field — no impact on calculations
stepolan
c32db91
Add HuggingFace Spaces config, env var secret fallback
stepolan
84c5f94
Switch to public Google Sheet backend, add privacy warnings
stepolan
7630609
- Replace service account auth with public sheet CSV reads + Apps Script writes
- No credentials needed — just a shared Google Sheet and a deployed script
- Add privacy warning on save: no real names, companies, or identifying info
- Add per-deal calculator with split deals, clawbacks, accelerator multipliers
- Support both attainment-based and deal-size commission models
- Include apps_script.js for easy Google Sheets setup
Initial sales comp calculator
stepolan
9095085
- Supports two commission models: attainment-based tiered rates and
deal-size rates with attainment accelerators
- Configurable: base salary, quota, draw, ramp schedule, commission
tiers, accelerators, COGS, equity
- Per-deal calculator with split deals and clawback tracking
- Google Sheets backend for scenario persistence across users
- Scenario comparison with side-by-side table and charts
- Commission curve visualization
