| Author |
 Topic  |
|
|
shorty
3 Posts |
 Posted - 04/06/2018 : 07:14:43 AM
|
Hi everyone,
I have a question concerning repetitive statistical analysis. The analysis itself is very simple: I just want to calculate the mean of some columns in a range of rows. However I have many datasets of the same structure and want to do it for all of them simultaneously, without clicking through the process again and again.
I have tried with each dataset in a separate sheet, opening the statistics on columns dialogue, and entering several sheets as the range:
[Workbook1](Sheet1:Sheet2)!1[89]:17[95]
This range (and several variant ways of defining the it) did not work.
Is it generally possible to do statistics on several sheets / workbooks simultaneously? If so, how does ist work?
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 04/06/2018 : 1:56:40 PM
|
Hi shorty,
> [Workbook1](Sheet1:Sheet2)!1[89]:17[95]
> This range (and several variant ways of defining the it) did not work.
Currently ":" notation for sheets is not possible. So, you need to distribute them like: ([Workbook1]Sheet1!1[89]:17[95],[Workbook1]Sheet2!1[89]:17[95]) If Workbook1 is the active book, you can use the shorthand:(1!1[89]:17[95],2!1[89]:17[95]) Of course, if you make a script, it's a completely different proposition.
Hope this helps.
--Hideo Fujii
OriginLab
|
 |
|
|
shorty
3 Posts |
Posted - 04/09/2018 : 11:52:54 AM
|
Thanks for replying so quickly! I'm afraid it still doesn't work. :/
When I do it that way, Origin accepts the syntax, but only gives back the first row of data from the two sheets without calculating the mean.
Any other ideas what the problem might be? |
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 04/09/2018 : 5:00:51 PM
|
Hi shorty,
Which version of Origin are you using? As far as I tried on my Origin 2018, it worked fine. I just guess it's an old bug?
--Hideo Fujii
OriginLab |
|
|
|
shorty
3 Posts |
Posted - 04/10/2018 : 03:16:57 AM
|
Yes, probably, I'm using Pro8. v8.0951
Alright, so it's a bug, nothing we can do about that I guess  |
|
|
|
minimax
351 Posts |
Posted - 11/07/2018 : 03:09:11 AM
|
Hi shorty,
In fact Origin v8.0951 already supports multiple sheets syntax, using index (instead of sheet name), like following:
[Workbook1](1,3:5)!1[89]:17[95]
Name syntax (Sheet1:Sheet2)!1:2 would be also supported in next version, probably Origin 2020. |
|
|
| |
Topic |
|
|
|
Statistics on multiple sheets/ Workbooks