Design in Blocks

June 16, 2009

One of the more important considerations when attempting to create a well designed spreadsheet model is the concept of designing in blocks.

“Blocks” is a colloquial rather than a technical term, and means a “range of contiguous cells that have something in common”. This could be something trivial like number format (currency, percentages, etc.), cell shading, and the like. Or it could be something more meaningful like a logically identical formula. Read the rest of this entry »