Change the Bass Model parameters M, p and q to explore. Use the sliders to watch the curves change.
To make this little jewel, I used Microsoft Visual Studio 2013 to create a Silverlight gadget, which is hosted in this blog page. The Silverlight gadget is based on three Telerik controls: ChartView, Spreadsheet and RibbonView.
I have been thinking about tools for technology market forecasters (like me) for many, many years. I’ve even completed a few would-be products (e..g, Excel add-ins). Now I envision a Web-centric service and am building it here.
The first step in any market forecast is the penetration curve, which is a sequence of points each providing the unit of time (e.g, year) and the percentage of a potential market that has adopted a product or service for each time. The penetration curve is popularly known as the s-curve.
Change m, p and q in the Excel model below to explore different penetration curves. The spreadsheet can be saved for use offline.
This spreadsheet uses the Bass Model to calculate the penetration curve.
Although the penetration curve is fundamental, it is just the first step to building a forecast.
I built this Silverlight gadget using Visual Studio 2013 and SpreadsheetGear for Silverlight.
Portia Isaacson Bass, Ph.D.
Geek grandma tech market forecaster with pug. 40 years of forecasting and still counting. I’ve learned a few things…again, again and again…
Life Is a Lab 