Could you please provide me a sample script:
- Detects increasing values in one column and copies the data (all rows) into a new worksheet
- Then the decline, and again the script detects this event and he just copies the data into a new worksheet
- Then again detects the change - the values are rising again - the script detects and stores the data in a new work sheet
- And so on
- Script ends up as run out of data
- It is important to point MAX and / or MIN naeay to anyone on the worksheet, eg:
- Worksheet1: contains values for some columns: 1 5 6 10 (value rise)
- Worksheet2: contains values from the same column: 10 8 7 4 2 (decreasing value) - those with a value of 10 are duplicated
- Worksheet3: contains values from the same column: 2 5 8 9 12 (value rise) - those with a value of 2 are duplicated, etc.
Thus, your script to work like the "Extract Worksheet Data" with the code written by myself: a) for increasing values: (((col (TC) [i]> = 148) & & (col (TC) [i] <= 800 )) & & col (TC) [i] <= col (TC) [i +1 ])||((( col (TC) [i]> = 148) & & (col (TC) [i] <= 800) ) & & col (TC) [i-1] <= col (TC) [i])
b) for diluting the value: (((col (TC) [i]> = 148) & & (col (TC) [i] <= 800)) & & col (TC) [i]> = col (TC) [i + 1 ])||((( col (TC) [i]> = 148) & & (col (TC) [i] <= 800)) & & col (TC) [i-1]> = col (TC) [i ])
Someone help me? I'll be very grateful.
|
Script to detect changes in the value
Posted - 12/02/2010 : 5:48:39 PM
