So for example to get the value of a cell 3 down and 2 left, the reference would look like: Numeric references are made according to how many cells away the cell that has the result isĭirectional references are made using the following symbols:Įach co-ordinate is placed within square brackets, and separated with a comma ,.Taking the position of the cell requiring the result (the cell having the rule built) as a starting point: When building cell rules, using the result of another cell is done by using relative referencing. When rows are added to the Calculation table, Column Rules will apply to each cell in the column. The rule builder will open to allow a rule to be constructed in the usual way. Select the cell to have a rule applied and click the Build Column Rules button from the command bar.When the calculation table is selected, Column rules are built by: The rule builder will open to allow a rule to be constructed in the usual way.Select the cell to have a rule applied and click the Build Cell Rules button from the command bar.When the calculation table is selected, Cell rules are built by: There are 2 types of rule that can be built: Rules can be built for any column of the type Data or Control Output. The Calculation Table will display the Control Names Return value in normal viewing mode.
#Workbook for solidworks 2005 update#
When using a Control Output column, the Set Output Control Rules button will need to be clicked to update the rules in the controls if the rule is added or changed.ĭriveWorks will detect a corresponding name has been added and will present a grey indicator in the corner of the applicable cells. The form controls PanelWidth1, PanelWidth2, PanelWidth3, and PanelWidth4 must exist on a user form.įorm controls with the required column name and row reference number can be added after the Calculation Table has been created. When a column with the name PanelWidth has been added to the Calculation Table Name matching will append the row number to the column name and look for a control with that name. Form Control Name MatchingĬolumns set to be of the type Control Input and Control Output will have their column name matched to a form control. Columns can be removed by selecting the Name to be removed and clicking the Remove button.Ĭolumns are set to be a specific type, these can be:ĭata type columns allow set values or rules to be entered.Ĭontrol Input type columns will take the value from a set of corresponding controls (see Form Control Name Matching below).Ĭontrol Output type columns allow set values or rules to be entered, and will return the result to a set of corresponding controls (see Form Control Name Matching below).Columns can be renamed by selecting the Name to be renamed and clicking the Rename button.Column order can be modified by selecting the Name to be moved and clicking the Move Up and Move Down buttons from the Edit dialog.Set the Type for each column by clicking in the Type column adjacent to the Name the Type is to be applied. Enter the name for the required columns clicking the Add button after each.The Edit Calculation Table dialog will open.
Rules can be built for each cell in the table, and these rules can reference other cells in the table either using an absolute reference or a relative reference.įrom DriveWorks Administrator, and with a project open, go to Stage 3: Data and Rules > Calculation Tables:Įnter a Name for the table in the pop-up that appears and click OK.
Calculation tables allow real time calculations, in tabular form, to be carried out during a specification.ĭata from form controls can be used in the table and results can be returned to other form controls.
0 kommentar(er)
