Disposable Spreadsheets

SurvivalWare is a great conglomerator of data: financial, cash flow, and other.  It also houses a good solid financial model.  You can be pretty sure that the numbers coming out of SurvivalWare are calculated correctly.  What SurvivalWare lacks is the immediacy and autonomy of a spreadsheet – to do stuff like take in crazy assumptions or do one-off KPI calculations. (You didn’t hear me say that!)  The structure of SurvivalWare is nice – until it isn’t.

Introducing the Disposable Spreadsheet – to give you the best of both worlds.  What is it?  A spreadsheet created on the fly, whenever needed.  It includes not just numbers, but the formulas underlying the SurvivalWare financial model.  A complete financial model in Excel, populated with 12 months or more of history, and 24 months or more of projections.  The inputs are clearly marked, as are the calculated cells.  Note that the calculations for a given row can be – often is – different for projected months vs. historical  months.

You can send the spreadsheet to the business owner or to a controller or CFO. A Tax planner.  Consultant on a project that impacts cash flow.  They can do their own what-if?’s in Excel.  If you have a boss,  you can load the marked up spreadsheet back into SurvivalWare.  This is called “Recycling” the spreadsheet.  The updated assumptions become part of the master data file in SurvivalWare, and available for analysis and reporting.  These assumptions are the ones used next time a Disposable Spreadsheet is created.

Otherwise, toss the file in an archive bin in case you ever want to mine it, and move on to next month’s edition of the Disposable Spreadsheet.

Here’s what the disposable spreadsheet looks looks like for a sample data file from the SIMPLE model.

Sample DIsposable Spreadsheet

Sample DIsposable Spreadsheet

Currently, this (the Simple Model) is the only model it is available for.  We are working on upgrading the Fort Knox model to do the same.  As you might expect, the more complex the model, the harder to get it to work reliably in Excel.  The Fort Knox Disposable Spreadsheet Feature should be available in March when we release SurvivalWare 2014. (Luckily nobody reads this blog, so I might have a little wiggle room on the date).

Right now, the way you create a spreadsheet with formulas is to go to the Projections Module and select the “Export Formulas” tab.  You probably want more than a single month of history, so click “More” in the upper right to display more history months.  This is what you see in SurvivalWare prior to the export.

Proj-Exp-Excel

It takes about 30 seconds or so to complete after you click the Export to Excel button.

The neat thing is that it is a piece a cake to read an updated Excel file back in.  Just select File / Import from XLS File…  Then select the file with the updated projections.  SurvivalWare takes care not to change any history numbers during this process.

File-Import-Proj