The Problem of Spreadsheets
Today’s Dilbert shows the PHB berating Asok for poor performance due to the conclusions of his new performance spreadsheet. Asok points out that the model is both simplistic, and more importantly, the formulae certainly point to the wrong cells. Oh yes.
How often have you seen spreadsheets which look fine to the creator, but actually have subtle but fatal flaws in them due to wrong ranges/cells being used? I’ve lost count. I’m glad to see someone other than me bemoaning this error, which as common as forgetting attachments on e-mails but much, much more serious.
Is there a way of avoiding this? I’m sure there is, but product after product just settles for replicating the old model.
