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

And the winner of the Excel Fundi Competition is....

Friday, 13 October 2017  
Posted by: Bert vd Heever
Share |

On the 14th September 2000, your webmaster spent a rainy day on the South Coast playing with Excel and ended up creating the original s-curve cash flow calculator which he then shared with fellow ASAQS members in the CUG. The calculator was then updated by Frans van der Walt of QS2000 to show graphs derived from a table which projects monthly- and cumulative expenditure. The calculator needed some refinement which was beyond the capabilities of it's original creators and so we decided to look for an Excel Fundi to take the workbook to the next level.

On the 15th September 2017, seventeen years later, almost to the day, we launched a competition to find an Excel magician.

Today we are happy to announce that we have found such a person in his Excellency Mr Ian van Zyl.

Ian van ZylIan is a 34 year old Capetonian who studied Bcom Financial Management Sciences at the University of Pretoria and who is about to finish his CIMA  qualification (Charted Institute of Management Accountants).

Ian is the Financial Manager at Innes Projects (a high-end residential construction company) and loves stand-up paddle boarding.

When asked how he became a proficient Excel user, Ian answered: "..over the past 7 years I have taught myself the ins-and-outs of Excel. I was always fascinated with Excel and saw the potential it has to build financial models to help assist with strategic and financial business decisions. I have used Excel in many areas of a business to consolidate large amounts of data to build useful and meaningful dashboards. I have an absolute passion for building Excel models and take great pride in presenting them to people."

We believe that the 2017 cash flow simulator showcases what can be done with Excel and that it will find wide use on government- and other projects as a simple tool that graphically indicates actual- against projected cash flows and also uses linear regression analysis to predicts the actual completion date based on current progress.

The new Cash Flow Simulator 2017 edition 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.

We once again wish to congratulate Ian and will have his prizes delivered to him next week.