PRJ98: Analyze_Timescaled_Data Macro Produces Incorrect Values

This article has been archived. It is offered "as is" and will no longer be updated.
Symptoms
In Microsoft Project 98, when you use the Analyze_Timescaled_Data macro toexport data to Microsoft Excel, you may see any of the following symptomswhen you view the data in Microsoft Excel:

Symptom 1: Cost or Work Values Are Greater Than Expected

Cost or work values for a task, resource or assignment may be greater thanexpected.

For example, a resource with 8h work and $1/hr cost will have the followingvalues in Microsoft Excel:
Work 800.000,00h
Cost $800.000,00

Symptom 2: Costs Are Displayed in Scientific Notation

Costs are displayed in scientific notation (for example, 1E+07.00000) andare not included in totals.

Symptom 3: Costs Are Rounded to an Incorrect Value

Most commonly, only decimal values of costs are rounded to an incorrectvalue.

Symptom 4: Start and Finish times are not exported

Only start and finish dates are exported; start and finish times are notexported.
Cause
These behaviors may occur when you run the Analyze_Timescaled_Data macrothat ships with Microsoft Project 98 and any of the following conditionsare true.

Condition for Symptom 1: Cost or Work Values Are Greater Than Expected

Cost or work values for a task, resource or assignment may be greater thanexpected when the Digit Group Symbol is a period (.) and the Decimal Symbolis a comma (,) under Regional Settings in Control Panel.

Condition for Symptom 2: Costs Are Displayed in Scientific Notation

Cost values greater than or equal to 9,999,999.50 in any of the followingfields may be displayed in scientific notation (for example, 1E+07.00000)and are not included in Totals:

  • Actual Cost
  • Baseline Cost
  • Cumulative Cost
  • Fixed Cost
  • ACWP
  • BCWP
  • BCWS
  • CV
  • SV

Condition for Symptom 3: Costs Are Rounded to an Incorrect Value

Values greater than or equal to $999,999.00 in the following fields may berounded to an incorrect value:

  • Actual Cost
  • Baseline Cost
  • Cumulative Cost
  • Fixed Cost
  • ACWP
  • BCWP
  • BCWS
  • CV
  • SV

Condition for symptom 4: Start and Finish Times Are Not Exported

Start and finish values are rounded to the nearest whole day.
Resolution
To correct symptoms 1-3, follow these steps:

  1. Obtain and install Microsoft Project 98 for Windows, Service Release 1 (SR-1). See the "Status" section later in this article for information about obtaining and installing SR-1.
  2. Start Microsoft Project 98 SR-1.
  3. On the File menu, click Open.
  4. Find and open the Backup.mpt file.

    NOTE: This file is found in the same directory where Winproj.exe is located. The default location is:
    C:\Program Files\Microsoft Office\Office.
  5. In the Organizer dialog box, click the Modules tab.
  6. Under the BACKUP.MPT column, click Analyze_Timescaled_Data.
  7. Click Copy. Click Yes when prompted to replace the existing Module Analyze_Timescaled_Data

    NOTE: The arrows should be pointing from the BACKUP.MPT column to the GLOBAL.MPT column.
  8. Click Close.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem was corrected in Microsoft Project 98 for Windows, Service Release 1 (SR-1).


For additional information about obtaining and installing SR-1, please seethe following article in the Microsoft Knowledge Base:
185102 PRJ98: How to Obtain and Install MS Project 98 SR-1
NOTE: See the "Workaround" section of this article for additional steps after obtaining SR-1.
analyze timescaled data wrong incorrect value
Properties

Article ID: 192026 - Last Review: 12/27/2014 11:50:58 - Revision: 4.0

  • Microsoft Project 98 Standard Edition
  • kbnosurvey kbarchive kbbug kbconversion kbfix KB192026
Feedback