"Excel just wasn’t designed to do some of the heavy lifting that companies need to do in finance.” So says Paul Hammerman, a business applications analyst at Forrester Research Inc. Despite that generally accepted fact, spreadsheets continue to be widely used as the default tool of choice for managing the finances of construction projects large and small. Most individuals that find themselves in this situation however, would enthusiastically agree that the use of spreadsheets for this level of complexity requires a ridiculous amount of meaningless effort for very little return. Far too much effort is put into getting the data into the spreadsheet – and all the formulas straightened out – that little time is actually spent analyzing that data.
Time-phasing the project budget is as core to project controls on construction projects as pasta is to Italian food. Or hockey is to a Canadian winter. Time-phasing is so central to project controls, that in 4castplus there are five different time-phasing plans that can be setup on a single project. Actually, there are 10 – but in this article we’re mostly going to talk about one really important one.
One of the most important functions of project controls and cost engineering, is the ability to accurately forecast remaining costs-to-complete on a construction project. With the new Resource Forecasting tools in 4castplus, project controls professionals can now achieve ultimate accuracy and take full control of how projects are forecasted.
Several decades ago, organizations used to manage all their finances using big paper-based ledgers, where they’d spend much of their day “doing the books”. These large ledger books worked for hundreds of years, however it would be a challenge to find any modern company today that runs their business on paper-based accounting methods.
The best thing about Excel is that it’s so flexible. The worst thing about Excel is that it’s so flexible. With enough effort and programming, people can bend and twist Excel into doing almost anything. The challenge with that, as many people know, is that lurking inside every spreadsheet are errors that elude the creator. Some errors can be minor, but many errors are much greater in magnitude and can lead to executives making critical decisions based on bad math.