Tuesday, July 17, 2007

Modelling issues

by Mike Shallcross on July 17, 2007

There are many issues that can present a challenge in modelling. Discussion of these can be found at some of the websites listed on our Links page, and there are also many books covering spreadsheet software packages, although these tend to focus on technical points rather than quality and business issues.

Some of the most frequently encountered issues are:

  • Circular formulas
  • Interest calculations
  • Currency and inflation
  • Mixed time periods
  • Large models
  • Visual BasicTM for ExcelTM

[click to continue…]