Microsoft KB Archive/159629

= TMGR: Work and Cost Values in Sheet Don't Match Timesheet =

Article ID: 159629

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Team Manager 1.0 Standard Edition

-



This article was previously published under Q159629



SYMPTOMS
Work or cost values in the timescaled portion of a view, such as the Actual Work view on the Tasks tab, do not sum exactly to the values in the sheet portion of the view.



CAUSE
Microsoft Team Manager rounds timescaled values to equivalent 15-minute increments. Internally, Microsoft Team Manager schedules all tasks and people on 15-minute increments.



RESOLUTION
The behavior is by design in Microsoft Team Manager.



MORE INFORMATION
To understand how Microsoft Team Manager rounds values in a timescaled view, consider the following team file data where person P1 has a standard rate of $1.00/h:             Sheet                       |        Timescale

=
=======================================================                                        |          Week 1         | Task Name People Total Work  Total Cost | Total Work | Total Cost | - -  --  -  |-- Task       P1     1.7d        $13.60     |    1.72d       $13.75   | On the sheet side, Total Work is not rounded and the Total Cost is calculated as:  (1.7d * 8 hours per day) * $1.00/h On the timescaled side of the view, the work is rounded up to 1.72d; 1.7 days equals 13 hours 36 minutes or 13.6 hours. Microsoft Team Manager rounds the value up to the nearest 15-minute increment that is 13.75 hours. Converted to equivalent days, 13.75 hours equals 1.71875 days. Because Microsoft Team Manager shows only two decimal places of precision, this number is displayed as 1.72d. The Total Cost of $13.75 is equivalent to 13.75 hours * $1.00/h.

As you change the upper and lower timescale units of a timescaled view, in order to show more or less detail, Microsoft Team Manager recalculates Work and Cost values to distribute the value across the given time period. Therefore, rounding may occur.

Additional query words: 1.0 1.00

Keywords: KB159629

-

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

© Microsoft Corporation. All rights reserved.