Page 790 - ExtendSim User Guide
P. 790

764
Data Management and Exchange
ExtendSim databases for internal data storage
Data worksheet that appears. Be sure to enter probabilities that total 100 for all the rows you want values in, then click OK. To view the table, go to the Named Distributions worksheet.
• Other than for the empirical table, it is optional to name the distribution. However, named distributions appear on the Named Distributions worksheet and are made available to other cells when Make Random is clicked.
• You can only randomize cells with an appropriate format, such as general. If the Make Ran- dom command is not enabled, check the field format.
Parent/child relationships
Parent and child fields are color-coded in the workbook. This matches the parent/child color coding in ExtendSim – red for parent fields and green for child fields. All relations are stored on the Data Relationships worksheet.
☞ A parent field must be designated as Unique and must have Record ID enabled. Make those changes in the parent’s field properties header before creating a relationship.
• To create a parent/child relationship, right-click the name of the proposed child field to get the Edit Relation dialog shown at right. Then either:
• Click the Select Parent Column button and select the col- umn that contains the field you want as the parent.
• Or, use the popups to choose the parent table and field.
• To change relationships, go to the Data Relationships work-
sheet and select the pertinent cell in the Indexed Fields table.
Then give the command ExtendSim DB > Edit Parent Child Relations and enter the correct table and field names into the Edit Parent-Child Relations dialog.
Child field names are hyperlinked to their parent fields. For example, clicking on a child field’s green header takes you to the linked field in the parent table. This allows use to quickly find parent tables and view the list of valid child values.
Check Database Consistency
One of the ExtendSim DB Add-In menu options is “Check Database Consistency”. This com- mand performs validations of the database and its parent/child relations, ensuring that the data- base structure and data content are internally consistent and valid.
Database consistency is checked every time a database file is exported from Excel and (option- ally) when a database file is imported to Excel. You can also click the button to check consis- tency at any time.
If errors are found a message is displayed at the completion of the check and the errors are recorded in an Errors Summary worksheet. The Errors Summary worksheet will have hyper- links to the errors so they can be fixed.
The Check Database Consistency command performs the following checks.
1) Parent/childdatacontent.Foreachchildfield,thecontentsarecheckedtoensurethatcor- responding values exist in the parent fields of the parent tables.
How To


































































































   788   789   790   791   792