Print Page   |   Contact Us   |   Sign In   |   Register
News & Press: 2017 News Items

Version 2.01 of Cash Flow Simulator now available

09 November 2017   (0 Comments)
Posted by: Bert vd Heever
Share |

One of our members in the Eastern Cape, Matthew Hofart, tried to use the simulator on a project that started in 2016 and got unexpected results. This was because the simulator was set to only calculate leap years from 2020 onwards.

The bug has been fixed and the version 2.01 simulator can now be used on projects with start dates after 2012.

Download the latest version and use it to enhance your cost-reporting. The simulator compares the current expenditure on a project with theoretical expenditure based on a standard s-curve and then predicts the completion date based on a linear regression of the expenditure to date.

Max Wideman defines an s-curve as: "...a display of cumulative costs, labour hours or other quantities plotted against time. The name derives from the S-like shape of the curve, flatter at the beginning and end and steeper in the middle, which is typical of most projects. The beginning represents a slow, deliberate but accelerating start, while the end represents a deceleration as the work runs out."

Why use an s-curve? It's an important project management tool that allows the progress of a project to be tracked visually over time. To find out more uses of the s-curve watch the video on this page. By watching the video you will also learn about more sophisticated uses of the s-curve such as "banana" curves based on the early- and late dates of the schedule and how this is used to keep tabs on project progress.

The new Cash Flow Simulator 2017 version 2.01 is a basic tool which is especially useful in circumstances where the contractor cannot produce a proper schedule indicating the critical path of the project. It is available from the Sundries section of the Members Only CUG. Members can use it freely and firms are allowed to co-brand it by inserting their logo's along with that of the ASAQS on the simulation page.

Please note that the simulator may not function as intended on older versions of Excel. The Excel workbook was zipped in order to load the .xlsm file into the file library and members will have to unzip the file before use. We also strongly recommend that you read the instructions before inputting your own data into the simulator.

We look forward to hearing from you after using the simulator and will be guided by your suggestions in future enhancements and improvements to the simulator.