Automated Baremetrics Spreadsheet

June 5, 2017

Back in April I read a great post by Jaakko Piipponen on the SaaS financial model he'd built as an Excel spreadsheet. I'm interested in spreadsheet financial models, so I enjoyed Jaakko's run down on how his model covers PnL report, operating expenses, payroll and revenue. Jaakko describes how you only need to spend 30 mins a month downloading reports from the Baremetrics dashboard and pasting it into Excel to keep it up to date. The post is titled an "SaaS financial model you’ll actually update", because the value of the model is such that 30 mins of manual handle turning a month is more than justified. Now I'm the first to advocate Excel for business agility; it's a great tool that enables sales, marketing and finance people to solve problems for themselves without the bottleneck of a software development team. But the downside of Excel is manual operation like the download and paste Jaakko spells out. Wouldn't it be great if the Baremetrics data in the spreadsheet downloaded and updated automatically? Then the model would always be up to date, and no tedious and error prone download'n'paste operations are necessary.

So I built it by adding Baremetrics functions to SpreadServe's SSAddin. Here's a spreadsheet that strips Jaako's model down to just the revenue parts of the model. It uses SSAddin functions to automatically download the revenue numbers every 10 minutes into the MRR Export sheet via the Show Summary API so the Revenue Model sheet will update every 10 minutes with the latest new customers, subscriptions, cancellations, upgrades and downgrades. All you need to do is download SSAddin 32 or 64 bit .xll binaries from here install the addin in Excel and fire up the spreadsheet. Don't forget to ensure that auto calc is on, and that you've got a copy of SSAddin.xll.config from the download page and put it next to SSAddin.xll on your PC. You'll need to edit the .config to add your Baremetrics license key. You can see flight_bare_model2.xls running online and driven by data here and here.

The online spreadsheet takes automation to the ultimate level. When you run a spreadsheet model automated with SSAddin on your desktop or laptop you still have to start Excel, load the spreadsheet and hit F9 before auto updates can start. With SpreadServe, you can move the spreadsheet onto a cloud server. All manual operations are eliminated, and everyone can see the same auto updating numbers in their browsers.