Repeat The values in the generated data sequence will be output to the selected column(s) by ascending/descending order (When Increment is positive, will be in ascending order when it is negative, will be in descending order).The options in the drop-down are Second, Minute, Hour, Day, Week, Month and Year. Specify the unit for the Increment value. Specify the increment within the generated data sequence. When Format is Date, it will be a combo box with calendar control when the Format is Time, it will be a text box. Specify the ending value of the generated data sequence. Specify the starting value of the generated data sequence. See Custom Date and Time Formats for more information. You can select or enter a custom format of the date/time data. This combo box is only available when the Display is set to Custom Display. See this help file page for more information. Specify the display format of the date/time data. Time The values in generated dataset will be time format.Date The values in generated dataset will be date format.The following table summarize the controls in the patternD dialog box. Right-click and select Fill Column With: A set of Date Time values.Select Column: Fill Column With: A set of Date Time values.To change its value, you must clear the Auto box.Ī set of patterned date and time data can be output to the selected column(s) using the patternD dialog. It specifies the total number of values in the whole dataset which will be generated based on the current settings. This text box is only controllable when Random is chosen for Mode(When Repeat is chosen, it is read-only). It specifies how many times each whole data sequence repeats itself in the generated dataset. This text box is only controllable when Repeat is chosen for Mode. It specifies how many times each value repeats itself in the generated data sequence. Use Total Number of Whole Set to determine the size of the generated dataset. Random For each cell in the selected column, a value picked at random from the generated data sequence, will be output to this cell.You can define Repeat Times for each value and Repeat Times for an entire sequence. Repeat The values in the generated data sequence will be output to the selected column(s) by ascending/descending order (When Increment is positive, will be in ascending order when negative, will be in descending order).Specify how the generated data should be arranged. The following table summarizes the controls in the patternN dialog box. Right-click and select Fill Column With: A set of Numbers.Select Column: Fill Column With: A set of Numbers.To open this dialog, select the column(s) you would like to fill. Selected column(s) can be filled with numeric patterned data using the patternN dialog box. By default, these variables are set to 0 and 1, respectively. Right-click and select Fill Column With: Normal Random Numbers.įor the normal random number fill, the mean and the standard deviation are controlled by the NORMAL_MEAN and NORMAL_SIGMA variables in the section of the ORIGIN.INI file.Select Column: Fill Column With: Normal Random Numbers.Click the Set Column Values with Normal Random Numbers button on the Worksheet Data toolbar.This menu command fills the worksheet column with normally distributed random numbers. Right-click and select Fill Column With: Uniform Random Numbers.įilled minimum and maximum values are determined by the UNIFORM_MIN and UNIFORM_MAX variables in the section of the ORIGIN.INI file.Select Column: Fill Column With: Uniform Random Numbers.Click the Set Column Values with Uniform Random Numbers button on the Worksheet Data toolbar.This menu command fills the worksheet column with uniformly distributed numbers between 0 and 1. Right-click and select Fill Column With: Row Numbers.Select Column: Fill Column With: Row Numbers.Click the Set Column Values According to Row Number button on the Worksheet Data toolbar.Select the column(s) you would like to fill, then do one of the following: This simple procedure creates a dataset from row index numbers. 6 Fill with Arbitrary Text Numeric Values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |