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.

Creating Cost Curves

3 replies [Last post]
Tue, 2004-08-24 08:48
Kelly Randolph
User offline. Last seen 18 years 41 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 9
Groups: None
What is the best way to filter payment milestones in MS Project and export to Excel to create monthly or 3 month rolling S curve forcast?
Top

Replies

Wed, 2004-09-08 23:40
#1
IC Quiamco
User offline. Last seen 13 years 10 weeks ago. Offline
Joined: 20 Dec 2002
Posts: 48
Groups: Petro-Chem / Oil & Gas
Create a customs field, mark the task/item you want to include in your filtering.

Then go to Tools,customize,toolbars and click analysis new set of toolbars appear.

Click analyze timescaled data in excel, pick current selected task, select the field to be exported (cummulative cost), date range, units (days, weeks, months etc.), next, export data.

There you have you have your S-curve, just edit it to suit to your desire format.

you can also combine it with other fields.
Top
Wed, 2004-08-25 07:48
#2
Raj Maurya
User offline. Last seen 2 years 43 weeks ago. Offline
Joined: 17 Jul 2004
Posts: 132
Groups: Petro-Chem / Oil & Gas
You combined two thing in a single question as I understand. If you want 3 month look ahead schedule (Task) to export into excel or you want to export 3 months resource or cost profile (resources or cost data distribution) to make S curve in excel. In first case it is very simple create new filter as per your need then export. In second case after filtering change the view to task usage then export distributed work in excel. In case of only milestones also you can create new filter for 3 months. Hope this will solve your problem.
Top
Wed, 2004-08-25 05:41
#3
Forum Guest
User offline. Last seen 2 years 28 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
Hello,
Use any following way to automatically select these particular milestones: put Indicator # n field to YES, MARK the tasks
Create a filter that will consider only those tasks
Create a Export Map with this filter
You could try also the macro "Time distributed data" to export filtered informations into Excel
Regards
Alexandre Faulx-Briole
http://perso.wanadoo.fr/afaulxbriole
Top