Difference between revisions of "Introduction to SubTables"
Line 1: Line 1:
−
[[media:California Power Plants2.ANA]]
+
A [[SubTable]] provides an edit table view for the users of your model, but which displays only a subset of a larger edit table, and may display the rows or columns in a different order from the original.  In this mini-tutorial, you'll create a [[SubTable]] view.
 +
 
 +
Begin by downloading the following model as a starting point: [[media:California Power Plants2.ANA]]
 +
 
 +
After loading the model, you'll should see the following diagram:
  
 
[[image:SubTable Tutorial 1.jpg]]
 
[[image:SubTable Tutorial 1.jpg]]
 +
 +
Click on the '''Edit Table''' button for "Power Plant Data".  This model contains data on 34 power plants in California of various types, a portion of which is shown here:
  
 
[[image:Power Plant Data2.jpg]]
 
[[image:Power Plant Data2.jpg]]
 +
 +
A user can edit this large table, but you may have certain users that need to worry only about Natural Gas plants.  For these users, we can provide a [[SubTable]] containing only the rows corresponding to Natural Gas plants.  We can also sort the table for them, and eliminate the ''Plant Type'' column, since it will always beset to Natural Gas.
 +
 +
Steps:
 +
1. Press [[image:Edit Mode Toolbar Button.jpg]] to enter edit mode.
 +
2. Create a decision node titled ''Sort By'', defined as
 +
Choice(Plant_fields,1,false)
 +
3. Create an index named ''Gas Plants'', defined as
 +
 +
index J := subset( Power_plant_data[Plant_fields='Plant Type']='Natural Gas' );
 +
sortIndex( Power_plant_data[Plant_fields=Sort_by, Plant_id=J ] )
 +
 +
This expression extracts the subset of ''Plant_ID''s in which ''Plant Type'' is "Natural Gas".  It then sorts by whichever column we've selected in Sort_by.
 +
 +
4. Create an index, Gas_fields, defined as a list of labels:
 +
{| border="1"
 +
| Plant Name
 +
|-
 +
| County
 +
|-
 +
| Cogen
 +
|-
 +
| MegaWatts
 +
|}
 +
 +
These are the columns we want to include in the [[SubTable]], in the order we wish for them to appear.  Notice that we have excluded ''Plant Type''.
 +
 +
5. Finally, create a variable node titled ''Gas Plant Data'', defined as
 +
SubTable( Power_plant_data[ Plant_id=Gas_plants, Plant_fields=Gas_fields ] )
 +
 +
Your screen should now look like (just before you press Enter to accept the definition):
  
 
[[image:Gas plant subtable diagram.JPG]]
 
[[image:Gas plant subtable diagram.JPG]]
 +
 +
6. Press the green check button to accept the definition.  Notice that the definition panel changes to a [[SubTable]] button.
  
 
[[image:SubTable Panel.jpg]]
 
[[image:SubTable Panel.jpg]]
 +
 +
7. Return to browse mode by pressing [[image:BrowseTool.jpg]].  (This is so the [[Choice]] cells will appear as drop downs when we view the edit table.
 +
 +
8. Press the [[SubTable]] button to bring up the [[SubTable]] edit view.  You should see:
  
 
[[image:Subtable Edit View.jpg]]
 
[[image:Subtable Edit View.jpg]]

Revision as of 23:18, 3 August 2007

A SubTable provides an edit table view for the users of your model, but which displays only a subset of a larger edit table, and may display the rows or columns in a different order from the original. In this mini-tutorial, you'll create a SubTable view.

Begin by downloading the following model as a starting point: media:California Power Plants2.ANA

After loading the model, you'll should see the following diagram:

SubTable Tutorial 1.jpg

Click on the Edit Table button for "Power Plant Data". This model contains data on 34 power plants in California of various types, a portion of which is shown here:

Power Plant Data2.jpg

A user can edit this large table, but you may have certain users that need to worry only about Natural Gas plants. For these users, we can provide a SubTable containing only the rows corresponding to Natural Gas plants. We can also sort the table for them, and eliminate the Plant Type column, since it will always beset to Natural Gas.

Steps: 1. Press Edit Mode Toolbar Button.jpg to enter edit mode. 2. Create a decision node titled Sort By, defined as 

Choice(Plant_fields,1,false)

3. Create an index named Gas Plants, defined as 

index J := subset( Power_plant_data[Plant_fields='Plant Type']='Natural Gas' );
sortIndex( Power_plant_data[Plant_fields=Sort_by, Plant_id=J ] )

This expression extracts the subset of Plant_IDs in which Plant Type is "Natural Gas". It then sorts by whichever column we've selected in Sort_by.

4. Create an index, Gas_fields, defined as a list of labels:

Plant Name
County
Cogen
MegaWatts

These are the columns we want to include in the SubTable, in the order we wish for them to appear. Notice that we have excluded Plant Type.

5. Finally, create a variable node titled Gas Plant Data, defined as 

SubTable( Power_plant_data[ Plant_id=Gas_plants, Plant_fields=Gas_fields ] )

Your screen should now look like (just before you press Enter to accept the definition):

Gas plant subtable diagram.JPG

6. Press the green check button to accept the definition. Notice that the definition panel changes to a SubTable button.

SubTable Panel.jpg

7. Return to browse mode by pressing BrowseTool.jpg. (This is so the Choice cells will appear as drop downs when we view the edit table.

8. Press the SubTable button to bring up the SubTable edit view. You should see:

Subtable Edit View.jpg

Comments


You are not allowed to post comments.