Spreadsheet


The more modern approach to simplifying the calculations is to use a spreadsheet. Figure 22.6 is a snapshot of one that I constructed in far less time than it took to create the nomograph.

Figure 22.6. Growth and productivity spreadsheet.


Starting from this very simple spreadsheet, you can easily develop some of the more sophisticated enhancements talked about earlier in the chapter. For example, I have already allowed for using a different wage rate for the new hires, although the example has them equal so that you can compare the spreadsheet result with your own calculation using the equations or nomograph. Moreover, once the model is cast in spreadsheet form, you can use tools such as Goal Seeking to implicitly solve, or work backwards, as you see fit.




The Software Development Edge(c) Essays on Managing Successful Projects
The Software Development Edge(c) Essays on Managing Successful Projects
ISBN: N/A
EAN: N/A
Year: 2006
Pages: 269

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net