Event Times dialog box

 

Use this dialog box to convert an event in one or more series to their event times equivalent series, or to return event times equivalent series to the times event format. Predictive Systems Lab implements event times by transforming the original series to another series whose entries consist of the times at which the event occurs in the original series. When returning event times series to times event format, however, the resulting series consist of a series of 1's at the times the event occurred, and 0's everywhere else.

 

 

Input

Specifies the worksheet location of the input data for this operation.

 

Valid Input Range

Provides a reference to the extent of the data available in the currently active worksheet. Use this range as a guide for typing valid extents in the Input Range box.

 

Input Range

Type in this box the range of cells containing the data you want to use as input for this command.

 

Series in Rows

Check this box to indicate that the data specified by the Input Range box is organized in rows as opposed to columns (the default).

 

Refer to Specifying Input Arguments for additional information on this subject.

 

Output

Specifies the worksheet location for placing the results of this operation.

 

New Workbook

Select this option to place the results of this operation in a new document workbook.

 

New Sheet

Select this option to place the results of this operation in a new worksheet.

 

Range Position

Select this option to place the results of this operation starting at the worksheet location specified in the box to the right of this option.

 

Refer to Specifying Output Locations for additional information on this subject.

 

Options

 

Operation

Specifies the operation you want to perform. Select from this list Event Times to transform an event from the selected series to their event times representations, or select Times Event to return event times series to the times event format.

 

Event Type

Indicates the type of event you want to detect. Select one of:

 

Single Value

Indicates the event you want to detect is represented by a single numerical value. If you select this option you must type the corresponding value in the Value box.

 

Value Range

Indicates the event you want to detect is represented by a numerical range of values. If you select this option you must type the low and high values delimiting the range in the Low and High boxes, respectively.

 

 

LT Threshold (Lower Than Threshold)

Specifies the event you want to detect is represented by all numerical values lower than the indicated threshold. If you select this option you must type the threshold value in the Value box, and select from the Context list if the threshold value itself should be considered as part of the event.

 

GT Threshold (Greater Than Threshold)

Specifies the event you want to detect is represented by all numerical values greater than the indicated threshold. If you select this option you must type the threshold value in the Value box, and select from the Context list if the threshold value itself should be considered as part of the event.

 

Value List

Indicates the event you want to detect is represented by a list of numerical values. If you select this option you must type the list of values in the Value List box.

 

Value

Type in this box the value or threshold you want to associate with the selected event type.

 

 

Lower Limit

Type in this box the lower limit of the numerical range associated with the event you want to detect.

 

This value will be included as part of the event.

 

Upper Limit

Type in this box the upper limit of the numerical range associated with the event you want to detect.

 

This value will be included as part of the event.

 

Context

Select one of Inclusive or Exclusive to indicate whether the specified threshold value should be included or excluded as being part of the event.

 

 

Value List

Type in this box the list of values, separated by commas, semicolons or spaces, you want to associate with the event.

 

 

 

OK

Closes the dialog box and carries out this operation.

 

Cancel

Closes the dialog box without carrying out this operation.