Rapid Application Development / Advanced Excel Development

Worksheet modularisation

Worksheet modularisation is the process of breaking out the complete model logic across a set of individually understandable worksheets. There is no one 'right way' it depends on what is being modeled, and how it will be used.

The above diagram shows one way, (by geography) that a projection spreadsheet might be organised. The key point is that each individual spreadsheet can be understood without constant reference to any of the others.