Here is a script to make monetary balance control over the whole project. It will tell you if your project is positive or negative along the time on whatever date you want.
what if you wanna now the balance of your project at a particular time. ( say will I be positive on the 15 of may? ) Here is a simple way to handle the question: I've done a script to help me know my project balance at anytime during it ( see attachment )
this is a beta script - please create a "costSums" custom data for one task of your project before running it ( the absence of it won't crash OP but will display nasty alerts
I got a CostSummer ( aka CS ) milestone created in my project. (
if it's not here the script will create it )
where ever I move the CS milestone in my project gantt chart I just have to press the "OPTimeCost" script button in my tool bar to have the milestone reflect the economic of my project at the milestone exact time.
put the unzipped script file in your /library/Scripts/Applications/Omniplan folder of your account to get it available as a tool for your task bar
The script add all the costs of all the task wich ended before my CS milestone and publish the result in the "costSums" custom data entry of the milestone. the gantt chart is set to show "costSums" on the graph for milestones
please have a look to this graphic
see the following examples:
At the start of the project I got an income of 800.
All is well
next income is planned on may the eleven.
I will end the project well, 400 will remain on my account.
BUT if I look to the April month period I have time of negative values on my account!
So I will have to find a solution ( other income, advancing my second income date, endure the phone calls of the bank...)
I think such a tool could be usefull. Would you be so kind to comment?