1. If the resource for the task is work ( not material) and the task has only one resource ( or has several resource, but you do not want to know the value for each resource) then you can try analyze timescaled date in excel Its on the analysis tool bar. if you can not see it, right click on the tool bar,then check it.
Follow the instruction, then you will get a excel sheet. you can have planned work for every day(or week, month...) for each task.
2.if your resource is material or you have more than 1 resource for each task and want to have the value for each resource.
change to task usageview, then use copy & paste to transfer all the data to excel, you will get a sheet with planned work for each resource and task
hope this helps
Member for
19 years 8 months
Member for19 years8 months
Submitted by jatin mamman on Fri, 2006-06-16 12:24
Ok, My problem is: For a particular Task - I want to know the Percentage of Works Planned in a particular month, I have the Quantity for the Task and the Rate, from which I will get the Amount.
So Getting the percentage of works planned for the required month will give me the exact Budgeted Amount for the particular month.
So can I use Filters to get the percentage of works planned for the required month and get the correct Budgeted Amount or is there a better way?
Cheers
Jatin
Member for
20 years 6 months
Member for20 years7 months
Submitted by Zhang Haixiang on Fri, 2006-06-16 05:04
Member for
19 years 8 monthsRE: Filter in MSP
Thank you sir,
Seems my work wont cut out so easily,
Will have to take the longer route
Cheers
Jatin
Member for
20 years 6 monthsRE: Filter in MSP
Its not so easy to do this.
1. If the resource for the task is work ( not material) and the task has only one resource ( or has several resource, but you do not want to know the value for each resource) then you can try analyze timescaled date in excel Its on the analysis tool bar. if you can not see it, right click on the tool bar,then check it.
Follow the instruction, then you will get a excel sheet. you can have planned work for every day(or week, month...) for each task.
2.if your resource is material or you have more than 1 resource for each task and want to have the value for each resource.
change to task usageview, then use copy & paste to transfer all the data to excel, you will get a sheet with planned work for each resource and task
hope this helps
Member for
19 years 8 monthsRE: Filter in MSP
hi
Ok, My problem is: For a particular Task - I want to know the Percentage of Works Planned in a particular month, I have the Quantity for the Task and the Rate, from which I will get the Amount.
So Getting the percentage of works planned for the required month will give me the exact Budgeted Amount for the particular month.
So can I use Filters to get the percentage of works planned for the required month and get the correct Budgeted Amount or is there a better way?
Cheers
Jatin
Member for
20 years 6 monthsRE: Filter in MSP
I mean you can not show part of a task.
You can scroll the timesacle,so you can alway see the end of the task, even the task last for years.
Member for
20 years 6 monthsRE: Filter in MSP
A filter only picks up those tasks meet certain Criteria then show them on the screen.
there are only two option show or not show.
Once the task is shown on screen, then you can access all information of this task e.g. finish date, % complete, resource, cost...
theres nothing to do with % planned work.(no such a field in MSP)
So for your example, you want to show the activity or not?