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.

Resource Spread sheet

3 replies [Last post]
Wed, 2008-12-03 16:32
Carlos Dominguez
User offline. Last seen 11 years 3 weeks ago. Offline
Joined: 22 Oct 2008
Posts: 11
Groups: Petro-Chem / Oil & Gas
can someone tell me
if i have a activity with a resource assigned to it as a example the left side of the spead sheet i have my activity and budgeted labour units that says
1 electrician for 2 hrs and on the spread sheet it shows that i need 0 men how come ?

Top

Replies

Tue, 2008-12-30 09:54
#1
SAIF-UR- REHMEN
User offline. Last seen 15 years 16 weeks ago. Offline
Joined: 3 Mar 2004
Posts: 5
Groups: None
I think Ali Farhat is right, almost all MS applications e.g. XL, MSP & P3 etc. have this by default and one has to set the fomat. I think you can get not only in decimal but also in factoring format e.g. 1/2,3/4 etc.
Top
Thu, 2008-12-04 11:33
#2
Carlos Dominguez
User offline. Last seen 11 years 3 weeks ago. Offline
Joined: 22 Oct 2008
Posts: 11
Groups: Petro-Chem / Oil & Gas
Ali , Thank you so much it is appreciated ...
Top
Wed, 2008-12-03 19:37
#3
Ali Farhat
User offline. Last seen 13 years 41 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
when you assign a resource to an activity, Primavera distributesd the budgeted units on the whole duration of the activity by default. this means that ther 2 hours budgeted where divided on the total duration of your activity.
In this example if the duration is more than 4 days, say 5..
2hrs / 5 days = less than 0.5 hour per day. all numbers below 0.5 will be rounded to zero!
so to solve this, you need to go to "user preference menu" -> time units tab -> Units format -> and choose to display 2 decimals.
please note that the resource spreadsheet shows the number of budgeted units (in this example hours) over the time scale. to view the number of MEN, right click on the spreadsheet -> spreadsheet options-> check calculate average, and check "base on hours per time period". Only then you will view the number of MEN per day
Top