To successfully import your data, the import file has be in comma delimited ASCII file format.
In the table that follows, an * indicates a required field.
In the Type column:
A = alphanumeric
N = numeric
Y/N = Yes or No
For more information on the table, see Import File Formats Legend.
Field Position |
No. of Chars |
Type |
Field Content |
|||||||||||||||||||||||||||||||||
1* |
40 |
A |
WBS ID; must exist in the project |
|||||||||||||||||||||||||||||||||
2* |
10 |
A |
Resource Code; must exist in the Resource Library |
|||||||||||||||||||||||||||||||||
3 |
10 |
A |
Resource Department; must exist in the OBS |
|||||||||||||||||||||||||||||||||
4 |
20 |
N |
Overtime Factor. If you are importing overtime values, enter the appropriate value; otherwise, leave blank. |
|||||||||||||||||||||||||||||||||
5* |
9 |
A |
Start Date of estimate Valid Date Formats: See Creating Import Files for details. |
|||||||||||||||||||||||||||||||||
6* |
9 |
A |
Completion Date of estimate |
|||||||||||||||||||||||||||||||||
7* |
1 |
N |
Estimate Type (enter 1-9 or A-J)
|
|||||||||||||||||||||||||||||||||
8 |
3 |
N |
Efficiency: This is a percentage factor; applies only if using Standard Hours as the estimate type. |
|||||||||||||||||||||||||||||||||
9 |
3 |
N |
Scrap & Rework: This is a percentage factor; applies only if using Standard Hours as the estimate type. |
|||||||||||||||||||||||||||||||||
10* |
6 |
N |
If entering monthly values, enter the year and month (YYYYMM) for which this value is being imported. If entering autospread values, enter the identifier for the spread curve to use. Must be an existing spread curve, predefined or custom. If this field is left blank, it defaults to a linear curve.
|
|||||||||||||||||||||||||||||||||
11* |
12 |
N |
Estimate Value, expressed in the same units as the estimate type (hours, prime dollars, total burdened dollars, total dollars)
|
|||||||||||||||||||||||||||||||||
12 |
20 |
A |
Rate Table (enter only if you want to override current Table) |
|||||||||||||||||||||||||||||||||
13 |
20 |
A |
Burden Template (enter only if you want to override current Template) |
|||||||||||||||||||||||||||||||||
14 |
20 |
A |
XREF-EST |
*XREF-EST Field — The XREF-EST import field is an optional field that can be used to make the estimate unique.
MPM considers records as duplicates if they have the same values for the following fields:
Period
WBS ID
Resource Code
Resource Department
XREF-EST
Overtime
Using the optional XREF-EST field — each record must contain 13 commas, one after each field except the last field (even those being left blank), and end with a carriage return.
Not using the optional XREF-EST field — each record must contain 12 commas, one after each field except the last field (even those being left blank), and end with a carriage return.
These records update an estimate for WBS 1X using Resource ENG1 in Department ENG with monthly values. This estimate starts January 1, 2008 and goes through April 1, 2008, and does not contain overtime, using Rate Table 001 and Burden Template ENG, with 80% efficiency. We are reporting $504,944.25 in Prime Dollars (Estimate Type 3) for Jan-08, $499,395.93 for Feb-08, and $522,333.29 for Mar-08.
1X,ENG1,ENG,,20080101,20080401,3,,,200801,504944.25,001,ENG
1X,ENG1,ENG,,20080101,19970401,3,,,200802,499395.93,001,ENG
1X,ENG1,ENG,,20080101,20080401,3,,,200803,522333.29,001,ENG
This record updates an estimate for WBS 1X using Resource ENG1 in Department ENG with autospread values. This estimate starts January 1, 2008 and goes through April 1, 2008, and does not contain overtime, using Rate Table 001 and Burden Template ENG, with 80% efficiency. We are reporting $1,526,673.47 in Prime Dollars (Estimate Type C), using Spread Curve 2 (Bell Curve). MPM will autospread $1,526,673.47 across January through April.
1X,ENG1,ENG,,20080101,20080701,C,,,2,1526673.47,001,ENG