Microsoft KB Archive/126106

= Resource Usage Cumulative Values Change When Scrolling =

Article ID: 126106

Article Last Modified on 11/25/2003

-

APPLIES TO


 * Microsoft Project 3.0 Standard Edition
 * Microsoft Project 3.0a
 * Microsoft Project 4.0 Standard Edition
 * Microsoft Project 4.1 Standard Edition
 * Microsoft Project 3.0 for Macintosh
 * Microsoft Project 4.0 for Macintosh

-



This article was previously published under Q126106



kbusage



SYMPTOMS
When you scroll the timescale in the Resource Usage view, if the view is formatted for cumulative work or cumulative cost, the value in a cell may be changed because of rounding errors that depend on what part of the timescale is visible. For cumulative work, the change can be several hundredths of an hour. For cumulative cost, the change depends on the resource rates.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
To compute the cumulative work or cumulative cost for a resource through a specific date, Microsoft Project gets the assignment work or cost through that date for each of the resource's assignments, and it then sums the results. If an assignment finishes before the first visible date on the timescale, then the exact total work or cost for that assignment is used; otherwise, a calculation is used that may introduce rounding errors. If you scroll to the right along the timescale, past the finish date of an assignment responsible for rounding errors, the rounding errors are removed, resulting in different and more accurate values in the cells under the timescale.

Assignments in which work divided by units gives fractions of minutes may cause the rounding errors discussed above; although, these rounding errors do not occur in every case. For example, if a resource is assigned 40h of work at .45 units, then Work divided by Units is 40h/.45 = 2400m/.45 = 5333.33m, and, in this case, rounding errors do occur in the calculation of resource usage cumulative values.

Additional query words: 3.00a

Keywords: kbbug KB126106

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.