Files containing tab separated values (TSVs) can be imported into many software programs. Microsoft Excel is one such program that can easily process TSV formatted files. Cranium and Synapse can export data for chemicals, mixtures, elements and references into TSV formatted files.

Example exported text files are shown below for chemicals, elements, mixtures and references.

1. Open a Knowledge Base document using either Cranium or Synapse.
2. Click on the File menu and select the Export Values command.
3. The application will activate the KB Export Dialog.
4. Select 'MKS Text File Format' from the Output File Format list and press the Export button. The Entity Types Export dialog is activated.
5. Cranium and Synapse can export text values for the chemical, element, mixture and reference entity types. For this example, select the chemical entity type.
6. The application will activate the Export Values dialog.

   1	Destination file into which text values will be written.
   2	List of entities to select for export.
   3	Command buttons for selecting all entities, no entities, selecting entities using a bookmark and selecting an entity using the Find Entity dialog.
   4	Table of selected properties to export. Each table row specifies the information needed to retrieve a specific property value. Each table row corresponds to a column in the exported file.
   5	Commands for editing table rows as well as saving and loading export property specifications.
   6	List of columns required to have values. If an exported row does not contain a value for one or more of the required columns then that row will not be written to the destination file.
   7	Buttons for selecting the units of measure in which the selected properties will be exported. (See the Property Units dialog documentation for more details on property units.)
   8	Buttons for selecting how multiline strings will be exported. Encoded: special characters will be replaced by their encoded equivalents, i.e., tab replaced with \t, carriage return with \r and newline with \n. Single line: special characters will be replaced with spaces.
   9	Export button

7. Press the Browse button to select the file into which the exported values will be written.
8. Select one or more chemicals from the Entities list. Use the Find or Bookmark buttons to facilitate your selection. You can also press the All button to select all displayed entities for export.
9. Click on the first row of the Select Properties table and press the Edit button. The application will activate the Export a Chemical Value dialog. The attributes you select in this dialog will be used by Cranium and Synapse to retrieve a single property value to be written into the destination file.

   1	Name: the property whose value is being retrieved.
   2	Component Index: certain properties, e.g., the activity coefficient and the diffusion coefficeint, are specific to each property in a mixture. This index specifies which component's property will be retrieved.
   3	Datum Status: specifies which type of data will be retrieved, e.g., estimated values or data values.
   4	Datum Index: certain properties, e.g., chemical synonyms and the liquid vapor pressure, are multivalued, i.e., they contain several data points. This index specifies which of these data values will be retrieved. In the image above, the third datum will be retrieved.
   5	Attribute Name: specifies which attribute of the selected datum will be retrieved and written into the destination file. Attributes include composition, temperature, pressure, value, reference and comment.
   5	X Index: if the composition attribute is specified then you must also specify which composition value should be retrieved.

10. In the Export a Chemical Value dialog select the following entries:
    • Name: Identifier
    • Attribute Name: Value
11. Press the dialog's OK button. The entered value specifications will be entered on the selected table row.
12. Select the Property table's second row, press the Edit button and enter the following specifications:
    • Name: Critical Temperature
    • Datum Status: Active
    • Attribute Name: Value
13. Repeat the process for two more row add the following speficiations:
    • Name: Critical Temperature
    • Datum Status: Active
    • Attribute Name: Reference
    and
    • Name: Critical Temperature
    • Datum Status: Active
    • Attribute Name: Comment
14. The Select Properties table should now contain the four rows:
15. Enter the value "2" into the Required Columns edit control. This will tell the application to skip any rows that do not have a value for column 2, i.e., the Critical Temperature - Value attribute.
16. Finally, press the dialog's Export button. The specified values will be retrieved from the selected chemicals and written into the destination file.

Entering the specifications for even just a few properties can take some time. We thus recommend that you save your entered specifications for later retrieval. Even if you wish to enter different specifications, starting from a saved set can often save time.

Once you have entered a set of property specifications, press the Save button, located to the right of the Select Properties table, to write the entered specifications into a file that can be loaded again at a different time.

In this example we wil use Microsoft Excel to regress an equation for estimating the critical temperature as a function of the normal boiling point.

1. Open the MKS Core Knowledge Base using either Cranium or Synapse.
2. Use the File menu's Export Values command to Activate the Export Values to a Text File command.
3. Press the Browse button and enter a name for the destination file.
4. Press the All button to select all chemicals for export.
5. In the Select Properties table enter three rows:
   • Identifier - Value - Active
   • Boiling Point - Value - Active
   • Critical Temperature - Value - Active
6. Enter 2 and 3 in the Required Columns control. This will result in only chemicals having values for both the normal boiling point and critical temperature being exported.
7. Finally press the dialog's Export buton.

We can now open the exported file in Microsoft Excel. Using Excel's regression graphing and regression functions, we can generate the following graph (after deleting the entries for mercury and sulfur):

and determine our new estimation model:

Tc = 95.3 + 1.22 * Tb

The following files were generated using Cranium's and Synapse's text export capabilities.

Example File	Description
TbTcValues.xlsx	A Microsoft Excel file containing boiling point and critical temperature data. Values are graphed and regressed into a new estimation technique.

Topic	Description
Estimating Chemical Properties	a short video demonstrating how to estimate the physical properties of pure chemical using either Synapse or Cranium.
Estimating Mixture Properties	a short video demonstrating how to estimate the physical properties of mixtures using either Synapse or Cranium.
Getting Started using Cranium	provides a quick tour of Cranium's capabilities including physical property estimation and a discussion of structure editing.
Getting Started using Synapse	provides a quick tour of Synapse's capabilities including examples of chemical product design.