Hidden Sins of Using Spreadsheets to Manage Projects

One of the most widely used tools for project management in software teams today is the spreadsheet. Although fairly cheap and easy to use spreadsheets hide problems that can hinder the success of your project and create more costs than you have planned for.2 min


91
121 shares, 91 points
Shocking, we know
Shocking, we know

One of the most widely used tools for project management  today is the spreadsheet. Spreadsheets are ubiquitous, heavily relied on by organisations to manage data and make critical business decisions. However, contrary to popular belief, spreadsheets are not free.

I will admit that I did not adopt early to new technology and when thinking about using future devices and incorporating them into my daily routine, i’m somewhat of a technical loafer.

I’ve used spreadsheets nearly most of my working life and as a result I had become lazy in moving on from excel as this met my needs. However, as i work more in the cloud it began to register that spreadsheets are so dated. Continuing to use this method would only cost in terms of productivity and accuracy.

Spreadsheets have collaboration inefficiencies

Spreadsheets have been used for team projects, the downside to this is that only one person at the time can access a  file. There is the risk factor of over writing the original file. The file has to be kept on a shared drive. If that is not accessible then e-mailing or sending copies out can prove to be detrimental.

Spreadsheets require lots of  maintenance

When all team members have updated the spreadsheet you will then need to consolidate the data and up date the information on to the main spreadsheet. This can prove time consuming and leaves room for errors. Your objective as a project manager is to focus on deliverables and results not the simple administrative task of the process. The task of managing the spreadsheet should not be anyone’s full time job.

Spreadsheets have inadequate workflow

Spreadsheets have not kept up with new technology and as Projects are becoming more complex, tasks are becoming automated, therefore team members need to be alerted instantly as you can not afford to be held up. Spreadsheets do not have an automated trigger or alarm and it is not equipped for providing on the spot information, thus, the onus is left on the project manager to ensure that information is accurate at any given time.

Spreadsheets are disconnected

In order for a remote team member to access information from the host spreadsheet on the network drive the member will either have to VPN (i.e. access via a virtual private network) request that a copy of the document be emailed to them.  

Spreadsheets don’t transfer easily

Project managers are often faced with the dilemma of having to reduce the size of a spreadsheet, or splitting it into mini spreadsheets. Have you ever tried sending via email a 100MB spreadsheet?  Large spreadsheets also  take forever to download.

Spreadsheets have  no  traceability

You cannot manage something that you cannot track. With spreadsheets project information is usually scattered across multiple files and folders. There is no easy way to get a complete view of the project progress and status. This can delay decision making and increase time to market. Plus all spreadsheets contain errors as many as 88%. This statement was made by the financial modelling training firm F1F9. They  also stated that 50% of spreadsheets used by large organisations have material defects.   On a lot of occasions spreadsheets are modified by team members to suit their own data needs and as a result this could create hidden formula inaccuracies. It can also lead to conflicting data, missed dead lines and bad business decisions based on inaccurate data. So  are spreadsheets really  free? I  think not!

Don’t forget to leave your comments below.


Like it? Share with your friends!

91
121 shares, 91 points

What's Your Reaction?

hate hate
8
hate
confused confused
20
confused
fail fail
14
fail
fun fun
12
fun
geeky geeky
10
geeky
love love
4
love
lol lol
6
lol
omg omg
20
omg
win win
14
win
George Brzozowski
I want to help you to see news events as starting points for constructive conversations. I seek to cut through the froth of the political spin cycle to underlying truths and values. I want to be so focused on progress that together we can provide a credible and constructive counter-narrative to the hopelessness-, anger-, and fear-inducing brand of discourse that is so pervasive in the news.

2 Comments

SHARE YOUR THOUGHTS

  1. Articles like this are great for us all to re-evaluate the software used vs. project needs. It sparks “continuous improvements”. I’ve got one spreadsheet that is a “beast” and I am going to have to re-think alternatives to the spreadsheet approach. Thanks for sharing a new way of thinking…

Choose A Format
Poll
Voting to make decisions or determine opinions
Story
Formatted Text with Embeds and Visuals
List
The Classic Internet Listicles
Open List
Submit your own item and vote up for the best submission
Ranked List
Upvote or downvote to decide the best list item
Meme
Upload your own images to make custom memes
Video
Youtube, Vimeo or Vine Embeds
Image
Photo or GIF
Gif
GIF format
%d bloggers like this: