The Total Cost Model is a Microsoft Excel© (Windows version) macro-enabled workbook that evaluates data from competing systems using standard financial calculations. Version 1.6 has been updated from the original (Excel 2003) to be compatible with Excel versions 2013 through the current 2021 (Office 365.) 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 workbook 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 Systems at California State University, Sacramento, Spring 2004 as original material based on previous research.
If you don’t use the Total 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 Total Cost Model…
Get the Total Cost Model and see how it works. It is free to copy and use in your own projects. It 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 2021) 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.
Version 1.6 has been updated with several Ribbon menu additions and fixes and some much-needed spelling fixes. There is now a Protect/UnProtect menu option and a method to Hide or Unhide columns L through P on the Options form. Of course, the Copyright dates have been updated as needed.
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.