RockWorks | Datasheet | Columns | Increment
Use this RockWorks Datasheet program to create a list of numeric values in a datasheet column, automatically incrementing the values by the real number you declare.
Example: This can be a handy way to list sample numbers, survey station numbers, etc.
- Data Columns
- Output: Select the name of the column into which the incremented values are to be listed. This prompt should default to the column in which you selected the block of cells (in step 2, below). Any existing data in this column will be overwritten.
- Options
- Rows: Initial, Final: In these prompts type in the number of the rows in which the values are to be started and ended. For example, if you want to list sample numbers in the first 100 rows in the datasheet, you would enter "1" and "100" in these prompts.
- Initial value: Type into this prompt the initial numeric value to be listed in the Initial Row.
- Increment: Type here the increment by which each row is to be increased. Entering "1" would increase the numbers by 1, entering 2.5 would increase the entry of each row by 2.5.
- Decimals: Enter here the number of decimal places to be represented in the values.
- Access the RockWorks Datasheet program tab.
- Open the datasheet to be manipulated or create a new datasheet.
- (Optional) Select the block of cells in the datasheet that are to be listed with incremented numbers.
- Click on the Columns menu above the datasheet, and select the Increment option.
- Enter the requested menu settings, described above.
- Click theProcess button to continue.
The program will record the Initial value in the selected column, in the Initial Row you specified. The entry in the next rows will be incremented by the indicated value, down to the specified Final Row.
Back to Editing the Datasheet
RockWare home page