Flatten File Utility

When you run this program, it creates a resource rollup project file in the project directory. The file is called projname.RRM or projname.RRY depending on whether you select the monthly or yearly option. The file is a copy of the .RRD file that is easier to read with report writers. The files can be used to create custom reports instead of using the .RRD file.

The .RRM and/or .RRY files will contain the contents of the .RRD file that existed at the time the files were created. If changes are made to the project, you should rerun the utility.

To run the Flatten File utility, complete the following steps:

  1. On the Windows task bar click Start » Run.

  2. On the Run dialog, type MPMRRF.EXE in the Open box.

  3. Click OK and the Flatten File Utility dialog is displayed.

  4. In the Projects column, highlight the project you want to use to create the resource rollup project file.

  5. Choose whether you would like to create monthly or yearly data.

  6. The Output Directory defaults to the project file location for the selected project. You may optionally choose a different output directory for the file.

Resource Rollup Monthly File Format

File Name — projectname.RRM

File Type — Btrieve

Record Length — 28 bytes

Keys — 1

Field

Type*

Length

Description

Header Link

L

4

Link to header record in RRH file

Value Type

C

1

Value type:

  • BCW(S)

  • BCW(P)

  • (A)CWP

  • (E)TC

Cost Element

C

1

Cost element:

  • (S)td hours

  • (H)rs/units

  • (E)quiv men

  • (P)rime

  • (G) & A

  • (O)verhead

  • (F)ee

  • (C)ost of money

Burden Code

C

10

Burden Code

Year and Month

I

4

Year and month

Monthly Values

D

8

Monthly values

* C = Character D = Double I = Integer L = Long Integer

Keys

This file contains one segmented key. This key contains no duplicates.

Segment 1 = Header Link

Segment 2 = Value Type

Segment 3 = Cost Element

Segment 4 = Burden Code

Segment 5 = Year and Month

 

Resource Rollup Yearly File Format

File Name — projectname.RRY

File Type — Btrieve

Record Length — 114 bytes

Keys — 1

Field

Type*

Length

Description

Header Link

L

4

Link to header record in RRH file

Value Type

C

1

Value type:

  • BCW(S)

  • BCW(P)

  • (A)CWP

  • (E)TC

Cost Element

C

1

Cost element:

  • (S)td hours

  • (H)rs/units

  • (E)quiv men

  • (P)rime

  • (G) & A

  • (O)verhead

  • (F)ee

  • (C)ost of money

Burden Code

C

10

Burden Code

Year

I

2

Year

Monthly Values

D

8*12

Monthly values

* C = Character D = Double I = Integer L = Long Integer

Keys

This file contains one segmented key. This key contains no duplicates.

Segment 1 = Header Link

Segment 2 = Value Type

Segment 3 = Cost Element

Segment 4 = Burden Code

Segment 5 = Year