Check Use File Data Source to use an ASCII file as a data source. The Browse button can be used to locate the desired file. It is recommended that the file be in the model's directory. The file must contain a single numeric value on each line, with no headers or other non-numeric information present.
 

Check Use Spreadsheet Data Source to use a spreadsheet file as a data source. The Browse button can be used to locate a spreadsheet file, which can be an Excel Workbook file or an XML spreadsheet file. It is recommended that the file be in the model's directory. These other fields are also required

• Sheet Name: The name of the worksheet in the selected spreadsheet file from which data will be read.
• Starting Row: The first row from which data should be read. Note that row numbers are numeric, rather than alphabetic as they appear in Excel, so Row A would be entered as 1, Row B as 2, etc.
• Column: Enter the column number from which the sample data will be read.

Both the Starting Row and Column fields are distributions. Thus, these values can be parameterized [with values such as Evl(Model.StartRow) or Evl(Model.Column) for example, where model attributes are used]. Note that the Read Data and Fit Now buttons described below cannot be used when such parameterization is used. Data will be read from the column specified, beginning at the starting row indicated, continuing downward until an empty cell is found.
 

Check Use Database Data Source to use an SQL database as a data source. The following fields are required

DSN/Properties File: This field should contain the information needed to connect to the database. It may contain a DSN (Data Source Name) defined in the Windows ODBC control panel or the name of a properties file containing necessary connection information. See Chapter 13 of the SIMPROCESS User Manual for more information on using databases with SIMPROCESS and for the contents of a properties file, which is optional on Windows and required on other platforms.

SQL Query: Enter an SQL statement which will return the sample data when executed. The query may be parameterized by using model attributes. For example, the SQL statement "Select TIME_VALUE from TimeTable" can be changed to "Select Model.TableColumn from TimeTable" to allow the name of the column to be determined at simulation time by substituting the value of the designated model attribute. In fact, any portion of the SQL statement which containing the string "Model." (case sensitive and including the "dot") will indicate that such parameterization has been done, and the resulting statement must be syntactically valid in order to obtain data for distribution fitting. (Note that such parameterization will prevent use of the Read Data or Fit Now buttons described below.) Only one column of data is read from the query results and it must be numeric. Therefore, any query returning multiple columns of data is allowable if the first is numeric.
 

View Data: When no data sources are parameterized (see the descriptions of Spreadsheet and Database data sources above), clicking this button will attempt to build a list of numeric values from all sources. It will report any errors it encounters. In the dialog which follows, it will display a scrollable list of the numeric values returned on the left and summary statistics about the sample data on the right. In order to obtain summary statistics there must be no less than two samples.

Fit Now: When no data sources are parameterized (see the descriptions of Spreadsheet and Database data sources above) this button will first attempt to read from all data sources. If successful, it will pass the returned list of numeric values to Model Fit to obtain a fitted distribution. If the returned distribution is valid for SIMPROCESS (see statistical distributions for more information) it will be formatted and placed into the Fitted Distribution field.
 

The checkboxes labeled Set Default Type and Set Default Bounds allow for supplying "hints" to Model Fit about the sample data. Selecting Set Default Type enables a choice of Continuous (the default) or Discrete. Selecting Set Default Bounds enables setting values for the lower and upper bounds. In Enter Lower Bound Value, values of "-Infinity" and "0.0" are offered, as these are commonly used lower bound values. Other values can be entered as desired. In Enter Upper Bound Value the commonly used upper value of "Infinity" is provided, but other values can likewise be entered here. When bounds are used the upper bound value must be greater than the lower bound. If neither of these checkboxes is selected no hints will be provided to Model Fit. See Auto Fits Distributions in Chapter 3 of the SIMPROCESS User Manual for more information.