You use the Weekly Data window to export weekly data. Access the Weekly Export Conditioning window by selecting Weekly Data on the Exports tab. MPM displays the Weekly Data Export Conditioning Window.
When exporting weekly data , all data conditioning options described in Project Export Conditioning Options are available to condition the data being exported. In addition, you can specify the following options:
Export Type (Required) — Use this option to specify either weekly WBS data or weekly EOC data for export.
Report From (Week Start) (Required) — Select the week start for the week you want to export from the list box. The dates in the list box begin with the first week of the three month window.
Report Through (Week End) (Required) — Select the week end for the week you want to export from the list box. The dates in the list box begin with the end of the first week of the three month window.
Elements of Cost to Include (Required if exporting by EOC) — This option is offered only if you are exporting by EOC and is used to select which EOCs to include in the export.
LRE Option — Use this option if you want to included the latest revised estimate in the weekly data being exported. You may select either Cum ACWP + ETC or Cum ACWP through Gate Month + ETC.
Gate Month — You may accept the default of current month or enter another month as the gate month.
Display Percentages (Optional) — Use this output option to choose whether to export percentages as decimal values (.5050) or as a percent (50.50).
When exporting weekly data, you can use the standard format files or create a custom format file. The standard format files, WEEKWBS.FMT and WEEKEOC.FMT, include the following fields:
WEEKWBS.FMT |
WEEKEOC.FMT |
WBS |
WBS |
Week End |
Week End |
BCWS Total Dollars WKLY |
Element of Cost |
BCWP Total Dollars WKLY |
BCWS Total Dollars WKLY |
ACWP Total Dollars WKLY |
BCWP Total Dollars WKLY |
ETC Total Dollars WKLY |
ACWP Total Dollars WKLY |
|
ETC Total Dollars WKLY |
You can create a custom file using the fields listed below. You may export up to a maximum of 250 fields in one batch. For information about creating custom files, see Creating Format Files.
WBS Fields |
||
Alias |
Fee Percent |
WBS Description |
Base WBS |
Last Statused Date |
WBS Percent Complete |
Baseline Complete |
Late Finish |
XREF-1 |
Baseline Start |
Late Start |
XREF-2 |
BCWP Base Unit |
Manager |
XREF-3 |
Charge Number |
Parent WBS |
XREF-4 |
CLIN |
Performing Dept |
XREF-5 |
Early Finish |
Recur/NonRecur |
XREF-6 |
Early Start |
Responsible Dept |
XREF-7 |
Earned Value Method |
Revision Letter Date |
XREF-8 |
Element Type |
Schedule Reference Date |
XREF-9 |
ETC Complete |
Responsible Dept |
XREF-10 |
ETC Start |
Total Float |
|
Fee Limit |
WBS |
|
Weekly Data Fields |
||
ACWP Cost of Money CUM |
BAC Cost of Money |
BCWP Cost of Money CUM |
ACWP Cost of Money MTD |
BAC EQP |
BCWP Cost of Money MTD |
ACWP Cost of Money WKLY |
BAC Fee BCWP |
BCWP Cost of Money WKLY |
ACWP EQP CUM |
BAC Gen and Admin |
BCWP EQP CUM |
ACWP EQP MTD |
BAC Hours/Units |
BCWP EQP MTD |
ACWP EQP WKLY |
BAC Overhead |
BCWP EQP WKLY |
ACWP Fee CUM |
BAC Prime |
BCWP Gen and Admin CUM |
ACWP Fee MTD |
BAC Standard Hours |
BCWP Gen and Admin MTD |
ACWP Fee WKLY |
BAC Total Burdened |
BCWP Gen and Admin WKLY |
ACWP Gen and Admin CUM |
BAC Total Cost |
BCWP Hours/Units CUM |
ACWP Gen and Admin MTD |
BAC Total Dollars |
BCWP Hours/Units MTD |
ACWP Gen and Admin WKLY |
BAC Total Price |
BCWP Hours/Units WKLY |
ACWP Hours/Units CUM |
|
BCWP Overhead CUM |
ACWP Hours/Units MTD |
|
BCWP Overhead MTD |
ACWP Hours/Units WKLY |
|
BCWP Overhead WKLY |
ACWP Overhead CUM |
|
BCWP Prime CUM |
ACWP Overhead MTD |
|
BCWP Prime MTD |
ACWP Overhead WKLY |
|
BCWP Prime WKLY |
ACWP Prime CUM |
|
BCWP Standard Hours CUM |
ACWP Prime MTD |
|
BCWP Standard Hours MTD |
ACWP Prime WKLY |
|
BCWP Standard Hours WKLY |
ACWP Standard Hours CUM |
|
BCWP Total Burdened CUM |
ACWP Standard Hours MTD |
|
BCWP Total Burdened MTD |
ACWP Standard Hours WKLY |
|
BCWP Total Burdened WKLY |
ACWP Total Burdened CUM |
|
BCWP Total Cost CUM |
ACWP Total Burdened MTD |
|
BCWP Total Cost MTD |
ACWP Total Burdened WKLY |
|
BCWP Total Cost WKLY |
ACWP Total Cost CUM |
|
BCWP Total Dollars CUM |
ACWP Total Cost MTD |
|
BCWP Total Dollars MTD |
ACWP Total Cost WKLY |
|
BCWP Total Dollars WKLY |
ACWP Total Dollars CUM |
|
BCWP Total Price CUM |
ACWP Total Dollars MTD |
|
BCWP Total Price MTD |
ACWP Total Dollars WKLY |
|
BCWP Total Price WKLY |
ACWP Total Price CUM |
|
|
ACWP Total Price MTD |
|
|
ACWP Total Price WKLY |
|
|
Weekly Data Fields (continued) |
||
BCWS Cost of Money CUM |
BV (S-A) Cost of Money CUM |
CPI Cost of Money CUM |
BCWS Cost of Money MTD |
BV (S-A) Cost of Money MTD |
CPI Cost of Money MTD |
BCWS Cost of Money WKLY |
BV (S-A) Cost of Money WKLY |
CPI Cost of Money WKLY |
BCWS EQP CUM |
BV (S-A) EQP CUM |
CPI EQP CUM |
BCWS EQP MTD |
BV (S-A) EQP MTD |
CPI EQP MTD |
BCWS EQP WKLY |
BV (S-A) EQP WKLY |
CPI EQP WKLY |
BCWS Fee CUM |
BV (S-A) Fee CUM |
CPI Gen and Admin CUM |
BCWS Fee MTD |
BV (S-A) Fee MTD |
CPI Gen and Admin MTD |
BCWS Fee WKLY |
BV (S-A) Fee WKLY |
CPI Gen and Admin WKLY |
BCWS Gen and Admin CUM |
BV (S-A) Gen and Admin CUM |
CPI Hours/Units CUM |
BCWS Gen and Admin MTD |
BV (S-A) Gen and Admin MTD |
CPI Hours/Units MTD |
BCWS Gen and Admin WKLY |
BV (S-A) Gen and Admin WKLY |
CPI Hours/Units WKLY |
BCWS Hours/Units CUM |
BV (S-A) Hours/Units CUM |
CPI Overhead CUM |
BCWS Hours/Units MTD |
BV (S-A) Hours/Units MTD |
CPI Overhead MTD |
BCWS Hours/Units WKLY |
BV (S-A) Hours/Units WKLY |
CPI Overhead WKLY |
BCWS Overhead CUM |
BV (S-A) Overhead CUM |
CPI Prime CUM |
BCWS Overhead MTD |
BV (S-A) Overhead MTD |
CPI Prime MTD |
BCWS Overhead WKLY |
BV (S-A) Overhead WKLY |
CPI Prime WKLY |
BCWS Prime CUM |
BV (S-A) Prime CUM |
CPI Standard Hours CUM |
BCWS Prime MTD |
BV (S-A) Prime MTD |
CPI Standard Hours MTD |
BCWS Prime WKLY |
BV (S-A) Prime WKLY |
CPI Standard Hours WKLY |
BCWS Standard Hours CUM |
BV (S-A) Standard Hours CUM |
CPI Total Burdened CUM |
BCWS Standard Hours MTD |
BV (S-A) Standard Hours MTD |
CPI Total Burdened MTD |
BCWS Standard Hours WKLY |
BV (S-A) Standard Hours WKLY |
CPI Total Burdened WKLY |
BCWS Total Burdened CUM |
BV (S-A) Total Burdened CUM |
CPI Total Cost CUM |
BCWS Total Burdened MTD |
BV (S-A) Total Burdened MTD |
CPI Total Cost MTD |
BCWS Total Burdened WKLY |
BV (S-A) Total Burdened WKLY |
CPI Total Cost WKLY |
BCWS Total Cost CUM |
BV (S-A) Total Cost CUM |
CPI Total Dollars CUM |
BCWS Total Cost MTD |
BV (S-A) Total Cost MTD |
CPI Total Dollars MTD |
BCWS Total Cost WKLY |
BV (S-A) Total Cost WKLY |
CPI Total Dollars WKLY |
BCWS Total Dollars CUM |
BV (S-A) Total Dollars CUM |
CPI Total Price CUM |
BCWS Total Dollars MTD |
BV (S-A) Total Dollars MTD |
CPI Total Price MTD |
BCWS Total Dollars WKLY |
BV (S-A) Total Dollars WKLY |
CPI Total Price WKLY |
BCWS Total Price CUM |
BV (S-A) Total Price CUM |
|
BCWS Total Price MTD |
BV (S-A) Total Price MTD |
|
BCWS Total Price WKLY |
BV (S-A) Total Price WKLY |
|
Weekly Data Fields (continued) |
||
CV (P-A) Cost of Money CUM |
EAC Cost of Money |
ETC Cost of Money CUM |
CV (P-A) Cost of Money MTD |
EAC EQP |
ETC Cost of Money MTD |
CV (P-A) Cost of Money WKLY |
EAC Fee |
ETC Cost of Money WKLY |
CV (P-A) EQP CUM |
EAC Gen and Admin |
ETC EQP CUM |
CV (P-A) EQP MTD |
EAC Hours/Units |
ETC EQP MTD |
CV (P-A) EQP WKLY |
EAC Overhead |
ETC EQP WKLY |
CV (P-A) Gen and Admin CUM |
EAC Prime |
ETC Fee CUM |
CV (P-A) Gen and Admin MTD |
EAC Standard Hours |
ETC Fee MTD |
CV (P-A) Gen and Admin WKLY |
EAC Total Burdened |
ETC Fee WKLY |
CV (P-A) Hours/Units CUM |
EAC Total Cost |
ETC Gen and Admin CUM |
CV (P-A) Hours/Units MTD |
EAC Total Dollars |
ETC Gen and Admin MTD |
CV (P-A) Hours/Units WKLY |
EAC Total Price |
ETC Gen and Admin WKLY |
CV (P-A) Overhead CUM |
|
ETC Hours/Units CUM |
CV (P-A) Overhead MTD |
|
ETC Hours/Units MTD |
CV (P-A) Overhead WKLY |
|
ETC Hours/Units WKLY |
CV (P-A) Prime CUM |
|
ETC Overhead CUM |
CV (P-A) Prime MTD |
|
ETC Overhead MTD |
CV (P-A) Prime WKLY |
|
ETC Overhead WKLY |
CV (P-A) Standard Hours CUM |
|
ETC Prime CUM |
CV (P-A) Standard Hours MTD |
|
ETC Prime MTD |
CV (P-A) Standard Hours WKLY |
|
ETC Prime WKLY |
CV (P-A) Total Burdened CUM |
|
ETC Standard Hours CUM |
CV (P-A) Total Burdened MTD |
|
ETC Standard Hours MTD |
CV (P-A) Total Burdened WKLY |
|
ETC Standard Hours WKLY |
CV (P-A) Total Cost CUM |
|
ETC Total Burdened CUM |
CV (P-A) Total Cost MTD |
|
ETC Total Burdened MTD |
CV (P-A) Total Cost WKLY |
|
ETC Total Burdened WKLY |
CV (P-A) Total Dollars CUM |
|
ETC Total Cost CUM |
CV (P-A) Total Dollars MTD |
|
ETC Total Cost MTD |
CV (P-A) Total Dollars WKLY |
|
ETC Total Cost WKLY |
CV (P-A) Total Price CUM |
|
ETC Total Dollars CUM |
CV (P-A) Total Price MTD |
|
ETC Total Dollars MTD |
CV (P-A) Total Price WKLY |
|
ETC Total Dollars WKLY |
|
|
ETC Total Price CUM |
|
|
ETC Total Price MTD |
|
|
ETC Total Price WKLY |
Weekly Data Fields (continued) |
||
SPI Cost of Money CUM |
SV (P-S) Cost of Money CUM |
TCPI Cost of Money |
SPI Cost of Money MTD |
SV (P-S) Cost of Money MTD |
TCPI EQP |
SPI Cost of Money WKLY |
SV (P-S) Cost of Money WKLY |
TCPI Fee |
SPI EQP CUM |
SV (P-S) EQP CUM |
TCPI Gen and Admin |
SPI EQP MTD |
SV (P-S) EQP MTD |
TCPI Hours/Units |
SPI EQP WKLY |
SV (P-S) EQP WKLY |
TCPI Overhead |
SPI Gen and Admin CUM |
SV (P-S) Gen and Admin CUM |
TCPI Prime |
SPI Gen and Admin MTD |
SV (P-S) Gen and Admin MTD |
TCPI Standard Hours |
SPI Gen and Admin WKLY |
SV (P-S) Gen and Admin WKLY |
TCPI Total Burdened |
SPI Hours/Units CUM |
SV (P-S) Hours/Units CUM |
TCPI Total Cost |
SPI Hours/Units MTD |
SV (P-S) Hours/Units MTD |
TCPI Total Dollars |
SPI Hours/Units WKLY |
SV (P-S) Hours/Units WKLY |
TCPI Total Price |
SPI Overhead CUM |
SV (P-S) Overhead CUM |
|
SPI Overhead MTD |
SV (P-S) Overhead MTD |
|
SPI Overhead WKLY |
SV (P-S) Overhead WKLY |
VAC (BAC-EAC) Cost of Money |
SPI Prime CUM |
SV (P-S) Prime CUM |
VAC (BAC-EAC) EQP |
SPI Prime MTD |
SV (P-S) Prime MTD |
VAC (BAC-EAC) Fee |
SPI Prime WKLY |
SV (P-S) Prime WKLY |
VAC (BAC-EAC) Gen and Admin |
SPI Standard Hours CUM |
SV (P-S) Standard Hours CUM |
VAC (BAC-EAC) Hours/Units |
SPI Standard Hours MTD |
SV (P-S) Standard Hours MTD |
VAC (BAC-EAC) Overhead |
SPI Standard Hours WKLY |
SV (P-S) Standard Hours WKLY |
VAC (BAC-EAC) Prime |
SPI Total Burdened CUM |
SV (P-S) Total Burdened CUM |
VAC (BAC-EAC) Standard Hours |
SPI Total Burdened MTD |
SV (P-S) Total Burdened MTD |
VAC (BAC-EAC) Total Burdened |
SPI Total Burdened WKLY |
SV (P-S) Total Burdened WKLY |
VAC (BAC-EAC) Total Cost |
SPI Total Cost CUM |
SV (P-S) Total Cost CUM |
VAC (BAC-EAC) Total Dollars |
SPI Total Cost MTD |
SV (P-S) Total Cost MTD |
VAC (BAC-EAC) Total Price |
SPI Total Cost WKLY |
SV (P-S) Total Cost WKLY |
|
SPI Total Dollars CUM |
SV (P-S) Total Dollars CUM |
|
SPI Total Dollars MTD |
SV (P-S) Total Dollars MTD |
|
SPI Total Dollars WKLY |
SV (P-S) Total Dollars WKLY |
|
SPI Total Price CUM |
SV (P-S) Total Price CUM |
|
SPI Total Price MTD |
SV (P-S) Total Price MTD |
|
SPI Total Price WKLY |
SV (P-S) Total Price WKLY |
|