Building for Sensitivity Analysis
In the previous chapters, you investigated a wizard that could take in and store user input. In this chapter, you’re going to create a dashboard that allows you to perform sensitivity analysis based on the metrics described in the previous chapter. Figure 8-1 provides a preview of what’s to come.
Figure 8-1. Analysis of alternatives decision support system
The tool shown in Figure 8-1 allows you to do many things quickly and efficiently, much of it with only a small amount of VBA code. As you’ll see, ...