Data organization in spreadsheets
Karl Broman and Kara Woo offer some good advice on organizing data in spreadsheets. They advocate confining the use of spreadsheets to data entry and storage---moving calculations and visualizations to other tools. This certainly avoids some of the biggest problems with using spreadsheets. However, spreadsheets don't enforce any discipline. It's up to the user to be vigilant and do the right … [Read more...]
Why Managing Risk with Spreadsheets is Risky
I'm encouraged by the fact that some organizations I speak to are trying to get their spreadsheet sprawl under control. However, far too many remain ignorant of the risks they are shouldering. Stratford Dick of Marsh ClearSight recently published an article describing how spreadsheets might be hurting your company. In his article he highlights the following risks. Spreadsheet development is … [Read more...]