Spreadsheet design

[IV16384]

I have always separated input worksheets and formula (report) worksheets as
a general guideline as it has given my apps the ability to operate in manual
calculation mode. Calculations, row/hiding and those types of operations
occurred when a user either attempted to view a report or perform a printing
operation. I have inherited a moderately complex workbook with inputs and
calculations combined which I do not care for as the user expects to see the
calculations as data entry is being performed. Example : There are inputs
for expenses a,b,c,d and a total column for the expenses. All information
on this input sheet (Inputs and calculated columns) flows to a report sheet,
making the formulas redundant. This design is present throughout the
workbook. Am I off base here with my complaint?

 

[Dave F]

I would say: it depends.

1) Can you understand the workbook's logic?
2) Are there logical errors or design inconsistencies which create the
potential for errors?
3) Is performance hampered by the redundant formulas?

If the answer to 1 or 2 is no or the answer to 3 is yes, then I would say
your complaint is legitimate. Else I'd just chalk it up to individual
choice. I don't think there are hard and fast rules to effective workbook
design, only general principles.

Dave