Not Another Spreadsheet!!

w14-dilbert

I just spent 2 hours on the phone with a client reviewing one of the most complicated spreadsheets  I have ever laid my eyes on!  My head is still spinning from the vlookups and infinite cell references.  I have to give credit where credit is due, this damn thing was impressive.

 

 

The author of the spreadsheet was proud of it, but maintaining it was a nightmare. The goal of this mini-monster is to produce an estimated labor report for superintendents, project managers and executives.

Here’s the landscape of their systems…remote time entry (RTE), Sage 300 CRE (Timberline) and Excel.  RTE was being used to capture things like amount of concrete being poured, number of hours  worked, equipment time used, etc. Timberline was used to track costs and Excel was used to update cost to completion.

To make matters more difficult, they needed different ways to calculate the estimates e.g. % Complete, Estimated Cost, Estimated Units, etc.

We were 1.5 hours into the call and had 10 more spreadsheets to get through when the client said, “the more I talk through this, the more I think we should just stick with what we have because our situation is just too unique”.

This is when I smiled and said, what if I could show you how we can automate this process, save you and your people 25 hours per week and push real-time cost alerts to everyone in the organization. Not to mention, since we are The Construction Analytics Company, you’d also get all of the advanced reporting capabilities that come with ProNovos.

Needless to say, that was a proud moment for me and that’s why I love what I do.  I wrote this post not because I’m anti-Excel, but because I’ve come across these scenarios too often. If you’re in the construction industry and spend hours per week updating Excel to produce reports, send me a note and let’s talk.

Contact us for more info..

Comments are closed.