Editing Cost distribution in Resource Spread Sheet

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 don’t have privilege to edit resource assignment for Planning under Security Profile-> Project Profiles

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

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 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

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,

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