Spreadsheet QualitySpreadsheet Design Concepts Series
Fan in / fan out
- Low fan in - a 'unit' (cell/worksheet/VBA routine) depends on only a few other units
- Good because it minimises dependencies and reduces complexity
- High fan out - a 'unit' (cell/worksheet/VBA routine) is used by many others
- Good because it minimises duplication
- Example: putting VAT (Sales tax) rates in their own cells, and referring there in calculations
- Example: calculating an offset once and using the result many times
|
|
|
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. |
