Cash flow in primavera PM5
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Thanks
I find it. you should modify the report and the click on the cell properties and uncheck "format text cell"
Thx very much
Hi Sonja
Check for field delimiters and text indicator. Check with different combinations.
You should open the file in EXCEL, not import.
Some time ago I had this problem as well. Unfortunately I dont remember how I solved but I assume it was one of the above items.
Good luck!
Dieter
Hi Dieter Wambach
Sorry to bother you again. but when opening the report with excel, the cells are text format and I can not plot curves based on these infos. how can I have numbers?
Thanks
Thanks, This was very useful.
Sonia
Ask your employer to join a training.
View (Left side of P6-window) "Reports" --> right mouse button --> select "ADD" --> mark "Time distributed reports" --> select "Activities" --> youll be guided by the wizzard, dont forget to enter a name --> Output to ASCII will create a csv-file. For the separator youll have to check: mostly ;, sometimes , or blank does work.
This csv-file you can open in EXCEL.
Good luck!
Dieter
Thanks for your time
I have already the S curve data
now how can i export this to excel file ie to have the cost of each activity distributed over months following the S curve that i had already created in primavera?
Sonia
Let’s assume, retention to be paid after a warranty period of 12 months. You’ll have two milestones for cash in in their own WBS: Advanced and retention payment. No in-between payments?!?
"cost distributed as an s curve" is nice. It means the accumulated cost will be displayed as an s-curve, the curve for costs then is bell-shaped. Does some body want to make a fun of you? (Quelqu’un veut se môquer de toi?) This is absolutely too vague. But you’ll have freedom and can choose a curve with a flat curve to make the costs earlier. As you can’t attach expenses to a curve, you’ll have to use a dummy-resource. Assign this resource to a LoE between Project start and finish with a budget of x Dollar and attach a bell-shaped curve to this assignment. Then you’ll create a report from the group "activities" grouped by WBS.
Ask for more data. For my opinion this curve you’ll better draw manually.
Hope this helps.
Dieter
Thanks Dieter,
Could you please ewplain me how to do it in Primavera?
Assuming I have only contract value that will be spread over activity duration with 1- first month advance payment 2- cost distributed as an s curve 3- Retention at the end of activity
how can i model this using primavera and then export the details to excel to allow me plotting the curve
Thanks a lot
Sonia
It depends on your needs for the cash flow, so youll have to establish a concept by yourself. To give you an idea:
All payments must be attached to activities. Youll have payments for a specific date (--> milestones) and payments spread over a certain time (e.g. Level of Effort). Dont be too complicate.
Cash out:
- Man hours multiplied by price, can be one activity per role or one activity with more roles.
- Purchasing with down-payments --> milestones with expenses.
- Overhead: LoE with an expense, spread over duration
Cash in:
- Milestones in a different WBS than the other activities.
Cash in you can regard as expenses multiplied by -1.
If the projects time-frame does change, cash flow will change accordingly.
How to print the curve? Unfortunately P5/P6 are not leading edge in graphical outputs, but you can creat a report in CSV-format which can be processed by EXCEL. --> Print-out of the curve will be in EXCEL.
This is just one idea. It will depend on your needs for %-complete as well.
Good Luck!
Dieter
Hi,
26 views without any reply. Please help
sonia
Hi,
i suggest that you still do it in excel.