... where visionaries, game changers, and challengers discuss business models
Hi BM experts!
I am thinking of creating an advanced yet simple to use (Excel) spreadsheet to do Business Model calculations. Something as easy to use as the BMG iPad app, but then in a spreadsheet you can use on your desktop. And with more advanced features and customizable by you if needed.
I have looked at the great spreadsheets people have already created and shared on Business Model Hub. These all are very advanced (and complex) and serve a specific need. I have not yet seen a "don't make me think" kind of spreadsheet that would be as forward to use as the BMC and the iPad app.
Would you be interested in a spreadsheet like that to do your business model calculations?
And would you be willing to pay a small amount to use the spreadsheet?
I have a lot of experience creating business case spreadsheets and financial benchmark models, also to be used by people who do not have the amount of expertise I (and you) have.
Thank you for your reply! (both positive and negative!)
I'd be also very interested in such spreadsheet. Your idea of starting with small pieces and then building the details around it is exaclty what I'm after.
Thank you for your reply! I will invest some time this week in building a first version of the spreadsheet. Would you be willing to review and help me in creating a nice and usable sheet?
I have created a first, *very* rudimentary version of the Business Model Calculator, just to get a feel of where it would be going. See attached file. It basically is a redo of the iPad toolbox, just to get the think process going. I have added the 'Online Training Website' example from the toolbox.
Do you think this is a direction of the spreadsheet you would like to see developed further?
Todo (for me!):
Other than that, it's already a pretty good and helpful spreadsheet. The chart/graph sheet would be also very cool and here are some chart ideas from me:
Thanks for your help on the considerations!
I have created a new version with the Customer Segments and Revenue Streams now fully implemented. See attachment.
They use conditional formatting, so you see cells to complete popping up depending on the number of customer segments and revenue streams you entered in the canvas.
Next step for me is the Cost Structure sheet, which will be a challenge! And then of course the Overview sheet and the Graph sheet. And then bringing all the numbers in a summarized way back to the Canvas sheet.
I am looking forward to your comments!
I would like to test the use of this tool as part of my exlporatin of Models for a new business venture.
I will, of course, give you any feedback and upload any a version with any changes to the template that I introduce.
Thanks for what, at first sight, seems like a really helpful and elegant tool.
Thanks for the update,, I'll use it in days to come for my new project and will give you any feedback I'll have. So far it is looking great:)
I like the concept.
It has always worked for me to start with an assumptions tab or tabs with assumptions in just a few places over time
so it is easy to change assumptions and do what if analysis. Seems like some of your tabs have assumptions listed, but they don't look to change over time,
there would be an accumulation tab by year to show assumptions over time as they relate to one another with the final results a business model in $$ s .
Assumptions important to set up tests for the assumptions and use lean start up methodology to test against customers and pivot where needed
this would become a living model then
This may work ...but do keep in mind that there is interplay with all the 9 building block of the canvas.. but deep focus on revenue and cost structure. Other key points to consider is allowing hypothesis testing and producing "what if " scenarios based business assumptions or predictions.
Would like to see it myself, though I am using the ipad version and see marginal success.