Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Changing Dates Cashflow/Income calculated from

4 replies [Last post]
Sat, 2019-11-23 09:55
J Muzz
User offline. Last seen 4 years 20 weeks ago. Offline
Joined: 21 Nov 2019
Posts: 3
Groups: None
Hi all I have generated a cashflow forecast in Powerproject which by the default periods are calendar months. I want to change this so that the calculation is based on specific dates - i.e valuation dates, which in this case are on the 18th of the month. So I would like the cashflow to show the periods between the 18th to 18th. Sometimes this date changes due to weekends to say the 16th. Any ideas how to do that? Thanks
Top

Replies

Fri, 2019-11-29 10:07
#1
Dariusz C
User offline. Last seen 2 years 22 weeks ago. Offline
Joined: 10 Dec 2018
Posts: 8
Groups: None

Create new graph definition for example I move Income 10 days forward:

IncomeOf(Defer 10ed)

 

It will move your income/cost according to Defer value:

 

7141
move_income.png

Top
Mon, 2019-11-25 01:40
#2
Rafael Davila
User offline. Last seen 9 hours 54 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team

Look at the following video, looks interesting, not sure if it can do the trick for what you need.  Maybe Asta's pre-defined progress periods need not to be of same period/duration, maybe can be edited any time to account for changes such as when planned update date was delayed some days.

Spider is different, reporting does not necessarily depends on pre-defined progress periods to get it right.  After/before some progress is posted, truncation can start at any time and finish at any time; might include several progress periods, might be portions of first + intermediate + portion of last.

Top
Sun, 2019-11-24 23:49
#3
J Muzz
User offline. Last seen 4 years 20 weeks ago. Offline
Joined: 21 Nov 2019
Posts: 3
Groups: None
Hi Many thanks for the reply, but unfortunately we do not have Spider Project, is there anyway it can be done in Powerproject?
Top
Sun, 2019-11-24 23:43
#4
Rafael Davila
User offline. Last seen 9 hours 54 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team

For this purpose we use Spider Project Software - Project truncation:  Project truncation is one of the report forms executed for a certain period and presented in a separate project form. In project truncation, project data and representations are all displayed, also data under charges of cost components and materials, duration, volume, and also cost and materials calculation for the set time period are automatically executed. In the Activity Gantt activities which have been only planned or executed during this period will be presented.

Before-Truncation CURRENT SCHEDULE (Click image)

Truncation_01 Select period, click OK and done for all fields.
Truncation-02CURRENT SCHEDULE AFTER TRUNCATION (Click image)

If you do not have project truncation and everything else fails you can create report templates and transfer reports to Excel where you can summarize the data. Might require several templates for multiple parameters, some with actual and remaining data.
Truncation-03

Good luck.

Top