When you open the budget calculator, Excel will issue a security prompt asking if you want to Enable Macros. You must click “Enable Macros” for the budget calculator to function.
The user can make two types of changes: checking and un-checking technology options or typing alternative values into editable cells. Editable cells appear recessed and have grey text. These changes allow you to tailor the calculations to the specific technology options you are interested in—alone or in combination—and to adjust prices of inputs and outputs as well as physical parameters like the rate of biogas production.
We suggest that after opening the workbook, you save a working copy that you can make changes to and save as a specific scenario. Revert back to the original copy to establish unchanged values again.
Downloads
- Anaerobic Digester System Enterprise Budget Calculator (Excel workbook)
- AD Budget Calculator User Guide (PDF)
