Skip to content

Creating Cost Curves

Kelly RandolphMember for 23 years 3 months
Created
2
3
0
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?

2 replies

Oldest first
  1. 0
    Forum Guest ·
    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
  2. 0
    Raj Maurya ·
    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.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?