Rapid Application Development / Advanced Excel Development

Modularisation

• Basic idea - to break down complexity into understandable chunks (note Millers Theorem (7+/-2))
• Advantages
  • Simplifies and adds analysis layers
  • Adds flexibility
  • Improves robustness
  • Reduces dependencies
  • Improves testability
• Disadvantages/Limitations
  • All Cells can be read from everywhere
  • Can add redundancy
  • Not really applicable for very small models
• Use of a block of cells for one (single) task, then start new block.