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.

How to edit gray boxes in Resource Usage Spreadsheet

No replies
Huss PS
User offline. Last seen 46 weeks 2 days ago. Offline
Joined: 2 Aug 2022
Posts: 7
Groups: None

Hi All,

I am trying to distribute hours using resource usage spreadsheet. some of the boxes have turned gray and i can not edit them.

Activities haven't started

actual hours are 0

budgeted hours = remaining hours

Refer to activity "Insert seismic bracing" in below snapshot.

8303
screenshot_16-12.png

 

Duartion type is Fixed Units. All activities are fixed units and i was able to edit them. Its just these couple of activities.wysiwyg_imageupload::

8304
screenshot_17-12.png

Huss PS
User offline. Last seen 46 weeks 2 days ago. Offline
Joined: 2 Aug 2022
Posts: 7
Groups: None

It Worked!!

Great. Thanks for your help.

The issue was duration type. I changed it from "Fixed Units"to "Fixed Duration & Units"

Huss PS
User offline. Last seen 46 weeks 2 days ago. Offline
Joined: 2 Aug 2022
Posts: 7
Groups: None

It Worked!!

Great. Thanks for your help.

The issue was duration type. I changed it from "Fixed Units"to "Fixed Duration & Units"

david kelly
User offline. Last seen 5 hours 35 min ago. Offline
Joined: 12 Feb 2016
Posts: 33
Groups: None

Check out page five of the PDF document 'Using a holiday plan rather than calendar exceptions' that you will find on:

 

www.p6david.uk/tipnew

 

Currently the above page not behaving perfectly on Firefox, but fine on Edge