In this chapter, we provide guidance on the choice of computer software for the budget-impact analysis calculations. In general, we recommend the use of simple spreadsheet software so that the model is readily accessible to budget holders and other decision-makers. We also discuss user interfaces and the importance of transparency and ease of use. A typical budget-impact analysis interface includes introductory information, input parameters, results, and background calculations. The introductory information should describe the model structure and provide instructions on using the model. The input parameters should be clearly laid out, documented, and easy to customize. The model calculations and results should be transparent and simply presented. We recommend selecting a visually appealing layout and color scheme, opting for worksheet equations rather than Visual Basic for Applications code to perform model calculations, and using Microsoft Excel’s available features, such as buttons and drop-down boxes, to help simplify user interactions with the model. Screenshots of a sample budget-impact model programmed in Excel are presented, and a link to the full Excel model is provided.In this chapter, we provide guidance on the choice of computer software for the budget-impact analysis calculations. In general, we recommend the use of simple spreadsheet software so that the model is readily accessible to budget holders and other decision-makers. We also discuss user interfaces and the importance of transparency and ease of use. A typical budget-impact analysis interface includes introductory information, input parameters, results, and background calculations. The introductory information should describe the model structure and provide instructions on using the model. The input parameters should be clearly laid out, documented, and easy to customize. The model calculations and results should be transparent and simply presented. We recommend selecting a visually appealing layout and color scheme, opting for worksheet equations rather than Visual Basic for Applications code to perform model calculations, and using Microsoft Excel’s available features, such as buttons and drop-down boxes, to help simplify user interactions with the model. Screenshots of a sample budget-impact model programmed in Excel are presented, and a link to the full Excel model is provided.
