Subscribe To This Website
You will receive an email when a new article is posted about once a month.-
Recent Posts
- Deriving Historic Pipeline Data Without Snapshots: A Novel Approach
- Modeling Commission Calculations in Excel
- Ever Wonder Why the Capitalization of Your Acronyms is Wrong in Your Database? (and how to fix them… )
- Confused About Funnel Conversion Rates?
- New and Improved Capacity Planning Model
- Size Matters for the Top Sales Leader’s Comp
Recent Comments
- Bob Bacon on Modeling Commission Calculations in Excel
- Danielle Crowley on Modeling Commission Calculations in Excel
- Aaron L Fung on Modeling Commission Calculations in Excel
- Bob Bacon on Modeling Commission Calculations in Excel
- John Kowalczyk on Modeling Commission Calculations in Excel
Archives
Monthly Archives: January 2021
Modeling Commission Calculations in Excel
During a recent consulting engagement I found myself once again re-inventing a formula in Excel for modeling commission calculations to estimate the cost of the plan at various points above and below 100% attainment. This task is complicated by the infinite variations … Continue reading