Resource Units/Time - Display units per time as a percentage or as units per duration, for example h/d. Sub-Units - Choose this option to display the corresponding subunit for the selected Unit of Time.ĭecimals - Choose the number of decimal places to display.
P6 Professional and P6 calculates and stores time unit values in hourly increments, when you choose to display time unit fields in increments other than hours, P6 Progress Reporter converts durations and resource units based on the the administrative settings defined by your P6 administrator. Unit of Time - Choose the time increment you want to use for displaying resource units and activity durations. Refer to the Example area of the tab to preview your selection. Choose from the following time format options.Choose File, User Preferences (Alt+F+U).To choose a display format for units and durations I do not use P6 but wonder if more than two decimal places can be selected. The error is then often magnified as subsequent computations are made using the data (although it can also be reduced).Įven if initially everything matches there is high probability you will eventually find some "minor" accuracy issues as the schedule is updated and duration spread or total duration changes. Excel nominally works with 8-byte numbers by default, a modified 1985 version of the IEEE 754 specification (Besides numbers, Excel uses a few other data types.) Although Excel can display 30 decimal places, its precision for a specified number is confined to 15 significant figures, and calculations may have an accuracy that is even less due to three issues: round off, truncation, and binary storage. The methodology described in my first post adds a resource to every activity, and then removes it, causing all the activity records to have the same value as the sum of its resource assignments.Īs with other spreadsheets, Microsoft Excel works only to limited accuracy because it retains only a certain number of figures to describe numbers (it has limited precision). Pick “No” and there are labour units in the activity record and no resource assignments.Īny time you add, change or delete a resource assignment record it recalculates the value in the activity record. Do you want to reset labor units to zero on this activity?” “All labor resources have been deleted on this activity. For example when removing the last labour resource from an activity this message: It is possible that these values can differ, while clearly we would not want them to.
For example the value of Budgeted Labour Units in the activity layout is not constantly being recalculated by adding up all of the resource assignments associated with each activity. One of the reasons for the excellent performance of “Group and Sort” in activity layouts is that it does NOT access any other tables. So you are looking at two different sources of what should be the same data. If more than one resource is working on an activity there is a many-to-one relationship between the resource assignment records and the parent activity record. are summaries of the underlying resource assignment records. The resource quantity values that you pick in an Activity Layout – Budget, Actual, Remaining etc.
The problem you describe about being unable to validate resource quantities is quite common, getting different answers from the resource spreadsheet and the activity layout is possible.