Resource usage spreadsheet error

L
Lucas l 👤 Member for 16 years 3 months
T
Tony Marsh 👤 Member for 14 years 5 months

Hi,

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

Cheers

 

Tony

T
Tony Marsh 👤 Member for 14 years 5 months

Hi,

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

Cheers

 

Tony

R
Rodel Marasigan 👤 Member for 19 years 8 months

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.

L
Lucas l 👤 Member for 16 years 3 months

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

R
Rodel Marasigan 👤 Member for 19 years 8 months

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.

Forum Sponsor

Top Posters

Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts
Nick Johnson-Pond
3 posts