Matrix Report

The Matrix report displays a summary of crew availability in a matrix layout where crews are grouped based on two assigned attributes. The attributes used for the report are selected by the user upon export.

Note: The Matrix report is only accessible through the crew mode.

Note: If you have edit access to your current view set, you can save your report selection as part of the view set.

To export Crew Manager in Matrix report form

1. Click the export button in Crew Manager. The Data Export dialog box appears.

2. Type the name of the crew attribute you wish to display at the top of the matrix in the Matrix Attribute 1 textbox.

Note: If selecting a child attribute as one of the attributes, the export will also show and group by the selected attribute’s parent. ARCOS will not show multiple levels of parents. E.g. If OpCo is Division’s parent and Division is OpCenter’s parent then you select OpCenter for the export, only OpCenter and Division will be in the export.

3. Type the name of the crew attribute you wish to display on the left side of the matrix in the Matrix Attribute 2 textbox.

4. Click the Summarize by button to the summarize type either Crews/Members or Member Status. (Crew/Members shows the number of crews and Member Status shows a summary of the members’ availability statuses.)

5. Check the Current crew values only? checkbox, to only include the values of attributes that are currently assigned to the crews within your view.

6. Click the Matrix button.

Reading the Matrix Export

The charts below are examples of the Matrix report summary options. Across the top of the grid (in purple) are the crew types used (CrewType was selected as Matrix Attribute 1). Down the left hand side is the Divisions included in the current view along with their parent OpCo (in pink) (Division was selected as Matrix Attribute 2).

Chart 1 represents the Member Status summarize option. The cross sections (e.g. Overhead and Athens represents overhead crews in the Athens area) of the export display a summary of availability for the included members in the following format: number working/number on rest/number on exception/number available.

Note: If there are no available employees in a cross section, the available field will not be included. For example, if two were working, no one was on rest, one was on vacation and no one was available, the cross section would be “2/0/1”.

Chart 1

Chart 2 represents the Crews/Members summarize option. The cross sections (e.g. Overhead and Athens represents overhead crews in the Athens area) of the export display a summary of crews and members: number of crews/number of members.

Chart 2

The Crews/Members summarize option may also be used to display a summary of crews and their reassigned location in relation to their home location. For example, you may have a crew attribute called “HomeLoc” that is used to show where a crew works out of on “Blue Sky” days, and then a second crew attribute called “AssignedLoc” that is used to show where a crew has been assigned to for a storm. If you use this type of setup, you can use “HomeLoc” as matrix one and “AssignedLoc” as matrix two. When you export the data this way, it will look similar to Chart 3.

Note: The areas where the attribute values are the same are filled in gray to represent the crews in the “AssignedLoc” are from the same location.

Chart 3

---

*Note: Not all companies have all of the items described in the Online Help.

*Please note, the ARCOS online documentation is a living document that is always under review. If you see information that is inconsistent with the behavior in the application, or you do not see a page covering an ARCOS feature you would like to know more about, please contact the ARCOS Support Center.