Use the Estimates window to import monthly estimate values from outside MPM. You can replace all existing values, or partial values based on a date range.
Access the Estimates Import Conditioning window by selecting Estimates on the Imports tab. MPM displays the Estimates Import Conditioning window.
The Estimates import has three additional options on the Import Conditioning window:
Import Type
Replace Values (and the related Import From and Import Through options)
Duplicate value
You can choose to import estimates of monthly values that are not autospread, or choose to autospread estimates as they are imported.
The Monthly Values option imports the monthly values you supply, and calculates burden values just as it does in Integrated Planning (see below).
The Autospread option automatically burdens the monthly values you supply and spreads the value using the spread curve you specify in the import file.
If you choose the Complete option, the imported estimate will replace completely the estimate currently in the database.
If you choose the Partial option, the imported data is restricted to the dates you specify in the Import From and Import Through fields. You can also choose to replace the old values with the new values (Update), or add the new values to the old values (Accumulate).
When you are doing a partial import, you must use the Duplicate Values field to choose replacement of the old values with the new values (Update), or addition of the new values to the old values (Accumulate).
MPM considers to records as duplicates if they have the same values for the following fields:
Period
WBS ID
Resource Code
Resource Department
XREF-EST
Overtime
With the Estimates to Import option you can import and update baseline data, ETC data, or both provided you are importing complete estimates. If you are importing partial estimates, you can import and update baseline data, ETC data, but not both.