4.17 The Weight Matrix Window

<< Click to Display Table of Contents >>

Navigation:  4. Additional Features >

4.17 The Weight Matrix Window

The Weight Matrix window summarises project weights in a table with one code type along the rows and another along the columns. For example, use weight groups for rows and area codes for columns to see how each weight group is distributed between areas. Open it from View > Weight Matrix.

WeightMatrix_261026

Create a matrix

1. Enter a descriptive Title, or select a saved title to load an existing setting.

2. Select Codetype Rows and Codetype Cols. Choose SW - ShipWeight code for the weight-group structure, or choose one of the project's custom code types.

3. In Definition, add the codes to display under Row fields and Column fields. Select the relevant group or one of its entries and right-click. Use Insert for a single entry, Insert Codes... to choose codes, or Insert All to add all codes for that axis.

4. Select the code for each entry. Enter Label 1 and, if required, Label 2 to define the headings shown in the result. Right-click an entry and choose Create Label to copy its code text into Label 1.

5. Check Result, adjust the Item filter and headings as required, then click Save to store the setting under its Title.

Definition and headings

Definition contains separate Row fields and Column fields groups. The order of entries determines their order in the result. Click a selected cell again to edit it. You can drag entries within the definition to change their order.

Label 1 and Label 2 provide up to two heading levels for each axis. The adjacent format columns control the appearance of the labels and rows or columns. Select the available formatting options while editing these cells.

Use Delete to remove the selected definition entry and Delete All to clear entries for an axis. Insert Codes... and Deleted Codes... open the same code selection dialog; check the codes to include and uncheck those to remove from the definition. These commands do not delete weight items or code definitions.

Filters and calculated values

Item filter: Limits which items contribute to the matrix. Click (...) to define the filter, or edit the expression directly. The matrix also applies the active global item filter. Check both filters if expected weights are missing.

The matrix uses the application's current weight field. There is no separate visible Weight Field selector in this window. Each cell contains the sum for the intersection of its row and column codes. Parent codes include their descendants according to the code hierarchy; showing both parent and child entries therefore produces overlapping totals.

Result is calculated from project data and cannot be edited directly. It updates as the definition or filter changes. Right-click in Result and choose Recalculate to refresh it when needed.

Inspect the result

Double-click a data cell, or select it and choose Edit Items... from the Result context menu, to open the items matching its row and column. Changes made there affect project data. Use Open Item Estimates... from the same menu to work with the corresponding item estimates.

Save, import and print

Save: Stores the title, row and column code types, item filter, footer and definition in the current project. A title is required. Select a saved title to load its setting.

Delete setting: Deletes the selected saved matrix setting after confirmation. This does not delete the underlying project items.

Import: Opens Import Weight Matrix to bring settings in from another project.

Footer: Supplies footer text for the printed matrix.

Print: Opens the matrix report for preview and output. Printing requires permission to output weight information. The Definition and Result context menus also provide Copy Table and Print Table commands.

Close: Closes the window. If the setting has changed, the Close button asks whether to save it first. Use Save to retain a setting you want to reuse.

Related topics

See The Code Definition Window for custom code types and code hierarchies.

See Global Filter for filters that affect the matrix in addition to its own Item filter.