Inserting Row and Column Rules (Headers)

Rules are entered into engineering tables as row and column labels. Row rules are populated with "dynamic data" (data taken from another table in the SKB). Column rules can be populated with either "dynamic data" or manually entered data.

How do I?

• Enter row rules (dynamic data)

  1. Open the Engineering data folder

  2. Open an engineering table.

  3. For a new table, the data manager window will display a cell containing the words Dynamic Rule.

  

   

  4. Click in the "Dynamic Rule" cell to display the rule drop down list.

  5. Select a rule for the rows. (This is accomplished by sliding your mouse over the desired rule and a single left click). The rule selected will appear in Row 0, Column A of the table.

  

  Material is highlighted, left click to select it for the rule.

  6. Click anywhere in the data manager pane to accept the rule. Column A will populate with the "dynamic data" for the selected rule.

     Dynamic data is information link from another table in the SKB (Selector Knowledge Builder).

     Hard links include:

     • Construction Specification

     • Industry

     • Liquid

     • MaterialMin

     • ProductLineIDSupplier

     • Pump Size

     To see an example, click here.

     Working pressure limit table with pump size as a row rule.

     

     Note: Dynamic rules are indicated by the magenta background and cannot be edited.

     Soft Links include:

     • Any Subcategory-ID's description in the Performance Option Subcategory Table.

     Note: You must have a Subcategory ID: SC-Mtl and it must be Enabled.

      

  Note: If an existing rule is being replaced the Horizontal Rule Changed dialog box will appear to indicate that data is going to be removed. Click Yes to proceed or No to cancel).

  7. Click to save changes.

  To enter row rules (dynamic data):

  1. Open the Engineering data folder

  2. Select one of the tables to edit

  3. For a new table, the data manager window will display a cell with the words Dynamic Rule

  4. Click in the dynamic rule cell to display the rule list for column A.

  5. Select a rule for the rows under column A, the column will populate with "dynamic data"

     Dynamic data is information from another table in the SKB (Selector Knowledge Builder), these include:

     •  Pump sizes from the Pump Size Table

     •  Materials from the Performance Options Table

     •  Liquids from the Liquids Table.

     Click  pump size to see an example

     Working Pressure Limit Table with Pump Size selected as a dynamic row rule

     Note: Cells with a magenta background cannotbe edited.

  6. Click save  to accept you changes.

• Enter column rules (dynamic data or manually entered data)

  1. Open an engineering table to edit.

  2. Right click on the "0" in "Row 0". An option list box will be displayed.

  3. Select Insert New Rule. ( A row will be inserted in the Row 0 position).

  

  4. Click in the "new" column A, Row 0 cell to display the rule list option menu.

  

  Clicking in the empty cell at location Column A; Row 0, will display the rule list menu.

  5. Select a rule for the drop down menu. (This is accomplished by sliding your mouse over the desired rule and a single left click). The rule selected will populate in the Row 0, Column A location.

  6. Click anywhere in the data manager pane to accept the rule. (the Horizontal Rule Changed dialog box will appear).

  7. Click Yes to proceed or No to cancel.

  8. Insert the numbers of columns required to populate the table. To see an example of a table with columns inserted click here.

     Hydrotest pressure table with material as a column rule and two columns inserted.

  9. Click in the teal colored column cell for which the rule's option is to be entered.

  10. Select or manually enter the rule criteria.

  • If the rule selected is based on "dynamic data", acceptable rule criteria is provided in a drop down menu.

  • If you select a rule based on non-dynamic data (max stages, max temperature, etc.) the rule criteria must be entered manually. Manually entered data must be the correct data type for the rule selected. (integer or string data). Avoid using "=" criteria for calculated integers like temperature or power. Instead, use "<="or ">=".

   

  11. Click to save changes.