Resource usage spreadsheet error

Lucas,
It’s nothing to do with your calendar. Your units may have decimal. Try to show the decimal so you know where the sum came from. Edit-> User Preferences-> Time Unit tab-> Unit of Time-> Decimals. Change the decimal to 2. Also check spreadsheet Option and culculate average maybe tick.

Hi,

It’s not a decimal problem as it show 3.00+3.00=9.57

The correct total is 0.615 times the value and apply for all the total for manhr and non man hr. There are no mistake for material.


I guess it is either calender or time period mistake. As I have change the calender from a 24hr calender to a 13hr calender. I tried changing the setting many times but couldn’t resolve the issue

Lucas,
Are we talking durations or labor units and non-labor units? There is no way calendar will affect resource unit or qty. Calendar and unit/time will affect durations but not resource.

Note: You cannot sum a combination of material qty, labor unit and non-labor unit on a summary band. It combine in a summary band it will display "---" but can sum per resource type.

Hi,

Did you ever get a resolution to this problem? i am experiencing the same issue with the total not calculating correctly.

Cheers

 

Tony

Hi,

Did you ever get a resolution to this problem? i am experiencing the same issue with the total not calculating correctly.

Cheers

 

Tony