The Total Cost Model is a Microsoft Excel© macro-enabled workbook that evaluates data from competing systems using standard financial calculations. Version 1.5 has been updated from the original (Excel 2003) to be compatible with Excel versions 2013 through the current (2016.) Many fixes have been implemented and new features have been added to the workbook. Most portions of the workbook seem to be compatible with Excel 2010 with the exception of the PowerPoint export feature which definitely does not work.
A graduate student developed the spreadsheet as a Master’s project to accompany the research paper, “The Economics of Open Source Software – A Model for Total Cost Analysis.” It was submitted in partial satisfaction of the requirements for the degree of Master of Science in Management Information Science at California State University, Sacramento, Spring 2004 as original material based on previous research.
If you don’t use the Cost model, as such, the VBA code it contains is quite extensive and can save you hours of research. Procedures such as the Export multiple worksheets to a single PDF document, and others, are discussed in detail here on this website.
Get the Cost Model…
Get the workbook and see how it works. It is free to copy and use in your own projects. The model is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0) license.
After opening the new version (compatible with Excel 2010 and higher) in a more recent version of Excel (2013 or 2016) you will not be able to return to using it in the earlier compatible software. This is the way the Excel office libraries work with the early binding used in the Cost Model’s VBA code. The Microsoft PowerPoint and Word libraries are the ones that need to be current with the version of Excel being used. To open the workbook again in an earlier version, you can re-enable the old libraries from the VBA editor window under the Tools > References dialog. Easier yet, download the software again.
This is the complete The Economics of Open Source Software – A model for total cost analysis ISO file. It includes the Total Cost Model, the research paper, and printed materials (papers, books, and articles) used in the research. It was created in 2004 and is presented here free of any charge. The software is compatible with Excel 2003 and possibly 2007.