Editing Cost distribution in Resource Spread Sheet
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
you do not edit the resource spreadsheet the costs and units are spread over the activities start and end date based on the cost and units that you input for the resource.
this is based on your calendar and availabe work hours per day.
the only way to change distribution is to change the duration, chnage the costs, change the units or assign a curve to the resource so that the distribution is different.
this is not excel
In a project I need to distribute fixed cost across the task duration manually without resource. I was trying to enter cost in Cost usage sheet. But found this is not editable. Like Activity No 2 August-2014 Plan cost is $15,000 and September-14 is $ 16,500. How can I edit this numbers.
Thanks.
Hi Ijaz,
As mentioned in previous post, you cannot edit/modify cost manually whether it is Labor, Nonlabor & Material Resource Type.
This is just a suggestion, I think the best thing you can do is to set your Budgeted Cost equal to your Budgeted Units. To perform this try the following:
1. I pressumed you have cost-loaded schedule and no Budgeted Units in your schedule.
2. Perform a global change or do it in Excel.
Select Subject Area = "Activity Resource Assignments"
Where
Resource ID Name "is under" "Assigned Resource ID/Name"
Then
Budgeted Labor Units = Budgeted Cost
3. When done, set your Price/Unit = 1
4. Do not forget to "Recalculate Assignment Cost" under Tools Menu.
Now, You have a Budgeted Unit & Cost. If you wish to modify your Budgetd Units, your cost as well will be modified and updated according to your units.
If you find some difficulties try to send PM to me.
Regards,
Arnold
Thank you Arnold,
What about if we have Non-labor cost like miscellaneous cost charges or material cost. How can we spread this cost manually.
Hi Ijaz,
I agree with Rodel, you cannot modify/edit cost but only budget units and remaining units.
Tell us what is really your intention otherwise, we can suggest another perspective.
Regards,
Arnold
Ijaz,
It maybe using roles instead of resource and you also needs privileges to edit roles assignment for planning under Security Profile-> Project Profiles.
Note: You can only edit budget units and remaining units and not cost fields.
Hi Rodel,
I have the duration type Fixed duration & units and I also have security priviliges to edit resource assignments. Also I checked the possible cause that are metioned in the help menu of PM, but to no vail.
Probably, some one else can guide me if there is some secret behind it.
Thanks
Ijaz
Ijas,
You cannot edit cost only remaining units and budgets units.
Another cause is duration type settings: Fixed Units and Fixed Unit/Time are not editable in spreadsheet.
Worse scenario: You dont have privilege to edit resource assignment for Planning under Security Profile-> Project Profiles