Do you convert my model into a new format?
You have two options when uploading an Excel spreadsheet into BaseCase:
- to leave it in the original Excel format and run it on the server
- to convert your model to a native BaseCase spreadsheet.
The advantage of option (1) is that you have full compatibility with Excel. If you make changes to your Excel model outside of BaseCase, your can re-upload your model at any time - all references remain intact. Of course, if you move your inputs & outputs around, you should update your references in BaseCase.
The advantage of option (2) is that your spreadsheet can run locally and no connection to the server is required to recompute your spreadsheet. For this reason your spreadsheet will also compute faster.
Another advantage is that you can update your spreadsheet within BaseCase - there is no need to re-upload your model to update your app.
A disadvantage of option (2) is that the BaseCase spreadsheet supports a limited subset of Excel formulas - although these cover the majority of models used in haealthcare.