Spreadsheet QualitySpreadsheet Design Concepts Series
Worksheet modularisation 2
An alternative approach to breaking model logic out is by 'Tier'. Tier is an important software development concept discussed further here.
In the above spreadsheet to logic is split between inputs - logic/calculations - reports. This is a very common split, and generally works very well, especially for larger or more complex models. |
|
|
Products for sale:
AltFileSearch
New information about the missing FileSearch feature in Office 2007 and details of our pragmatic solution (Current price GBP 25.00 + Vat)
wsUnprotector
Instant Excel worksheet protection remover and password recovery (Current price GBP 15.00 + Vat)
Classic Ribbon Tab
Add Excel 97/2000/2002/2003 compatible menu structure to Excel 2007
(Current Price GBP 10.00 + Vat)
Products coming soon:
XLAnalyst Pro
(Excel VBA based spreadsheet auditing tool)
Due before the end of 2009. |
