Spreadsheet misuse
How many of you have experienced spreadsheet misuse in your company?
Seriously! It drives me insane when people send me some data in the form of a spreadsheet that was not generated as a csv from a database query to be used as read-only data. People use spreadsheets like they are a database and then inaccurate information spreads as they send copies around. It is absolute insanity.
My team pulled some of this data into a mysql db and provided some user interfaces. We are getting some sanity into the management of data now, but it will still take time to get some people to change their ways. Once people realise the time savings and data accuracy improvements, then everybody benefits.
Seriously! It drives me insane when people send me some data in the form of a spreadsheet that was not generated as a csv from a database query to be used as read-only data. People use spreadsheets like they are a database and then inaccurate information spreads as they send copies around. It is absolute insanity.
My team pulled some of this data into a mysql db and provided some user interfaces. We are getting some sanity into the management of data now, but it will still take time to get some people to change their ways. Once people realise the time savings and data accuracy improvements, then everybody benefits.
Replies
You are reading an archived discussion.
Related Posts
plzz, help me out choose best topic selection for final year civil civil project under structures & please help me out get best of best ideas
Just before the Independence Day, Intex has kept with the schedule and launched another smartphone in the market. The Intex Aqua Music like its name suggests is the first smartphone...
I've been hearing from multiple sources that Reliance Jio is about to roll out across multiple cities in India. My primary interest is in knowing how much real life downloading...
We design may of our remote sites with lots of redundancy and think of many failure scenarios that we can recover from with minimal impact.
Today, one of the sites...
If your lightening cable is showing signs of buldging near the connector shroud, please consider this image of a cable that I found one morning. I recommend disposing of it...