Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Cash flow in primavera PM5

12 replies [Last post]
Wed, 2008-10-22 11:37
sonia rose
User offline. Last seen 14 years 47 weeks ago. Offline
Joined: 22 Oct 2008
Posts: 26
Groups: None
Hello,

I used to do cash flow and earned value in excel sheets.

How can I do it in Primavera PM5 with these assumptions for cash flow:

Advance payment at the start of the project
monthly expenditures on a S curve
Retention at the end of project

Thanks a lot
Top

Replies

Thu, 2011-03-10 02:56
#1
Susan Wyatt
User offline. Last seen 14 years 16 weeks ago. Offline
Joined: 26 Feb 2011
Posts: 2
Groups: None
Cialis generic inventively bromocresol Alternative to viagra malawian Dark
Top
Fri, 2008-10-24 14:55
#2
sonia rose
User offline. Last seen 14 years 47 weeks ago. Offline
Joined: 22 Oct 2008
Posts: 26
Groups: None
Thanks

I find it. you should modify the report and the click on the cell properties and uncheck "format text cell"

Thx very much
Top
Fri, 2008-10-24 14:26
#3
Dieter Wambach
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
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 don’t remember how I solved but I assume it was one of the above items.
Good luck!
Dieter
Top
Fri, 2008-10-24 13:14
#4
sonia rose
User offline. Last seen 14 years 47 weeks ago. Offline
Joined: 22 Oct 2008
Posts: 26
Groups: None
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
Top
Fri, 2008-10-24 07:59
#5
sonia rose
User offline. Last seen 14 years 47 weeks ago. Offline
Joined: 22 Oct 2008
Posts: 26
Groups: None
Thanks, This was very useful.
Top
Thu, 2008-10-23 12:26
#6
Dieter Wambach
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
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" --> you’ll be guided by the wizzard, don’t forget to enter a name --> Output to ASCII will create a csv-file. For the separator you’ll have to check: mostly ;, sometimes , or blank does work.
This csv-file you can open in EXCEL.
Good luck!
Dieter
Top
Thu, 2008-10-23 11:28
#7
sonia rose
User offline. Last seen 14 years 47 weeks ago. Offline
Joined: 22 Oct 2008
Posts: 26
Groups: None
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?
Top
Thu, 2008-10-23 11:18
#8
Dieter Wambach
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
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
Top
Thu, 2008-10-23 10:47
#9
sonia rose
User offline. Last seen 14 years 47 weeks ago. Offline
Joined: 22 Oct 2008
Posts: 26
Groups: None
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
Top
Thu, 2008-10-23 10:25
#10
Dieter Wambach
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Sonia
It depends on your needs for the cash flow, so you’ll have to establish a concept by yourself. To give you an idea:

All payments must be attached to activities. You’ll have payments for a specific date (--> milestones) and payments spread over a certain time (e.g. Level of Effort). Don’t 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 project’s 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
Top
Thu, 2008-10-23 09:52
#11
sonia rose
User offline. Last seen 14 years 47 weeks ago. Offline
Joined: 22 Oct 2008
Posts: 26
Groups: None
Hi,

26 views without any reply. Please help

sonia
Top
Wed, 2008-10-22 14:32
#12
Anoon Iimos
User offline. Last seen 3 years 25 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
Hi,

i suggest that you still do it in excel.
Top