| Author |
 Topic  |
|
|
freddie_mclair
United Kingdom
7 Posts |
 Posted - 01/23/2016 : 11:23:27 AM
|
Hi,
I would like to have a column with different sequential data, from 0.001 to 1, with increments of 0.001, and then from 1 to 10000 with increments of 1. How can I do this?
I know how to work out the "datarange" function, but I don't know if it is possible to concatenate two different data ranges functions sequentially.
Here's what I would like to have:
A(Y)
--------
0.001
0.002
0.003
...
1
2
3
...
10000
--------
Thanks in advance!
Freddie
Origin Ver.: OriginPro 2016
Operating System: Windows 7 Professional |
Edited by - freddie_mclair on 01/23/2016 11:24:22 AM |
|
|
SeanMao
China
288 Posts |
Posted - 01/24/2016 : 9:11:21 PM
|
Hi,
You can use Set Column Value dialog to enter the formula i<=1000?i*0.001:(i-999) as shown in the figure below:
Regards!
Sean
OriginLab Tech. |
 |
|
|
freddie_mclair
United Kingdom
7 Posts |
Posted - 01/25/2016 : 1:44:47 PM
|
Hi Sean!
Thanks a lot! This worked, but in order to get the full column (up to 10000) I had to set "Row(i): From 1 To 10999" in the "Set Values" menu.
Is there any other way to make it automatically? Because the first time I tried it, it only filled the values until Row 32 (which was the default number of rows when I opened the Workbook).
Thanks again 
Regards!
Freddie |
Edited by - freddie_mclair on 01/25/2016 1:47:38 PM |
|
|
|
SeanMao
China
288 Posts |
Posted - 01/25/2016 : 7:35:57 PM
|
Hi,
I should have mentioned this earlier. You can run script to set maximum row number wks.nrows = 10999; before running the formula in Before Formula Scripts section as shown below:
Regards!
Sean
quote:
Originally posted by freddie_mclair
Hi Sean!
Thanks a lot! This worked, but in order to get the full column (up to 10000) I had to set "Row(i): From 1 To 10999" in the "Set Values" menu.
Is there any other way to make it automatically? Because the first time I tried it, it only filled the values until Row 32 (which was the default number of rows when I opened the Workbook).
Thanks again
Regards!
Freddie
|
|
|
|
freddie_mclair
United Kingdom
7 Posts |
Posted - 01/26/2016 : 12:54:47 PM
|
Hi Sean,
Wow, thanks a lot, this worked out perfectly!
Regards!
Freddie |
|
|
| |
Topic |
|
Different data ranges in a column