| T O P I C R E V I E W |
| shorty |
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?
|
| 5 L A T E S T R E P L I E S (Newest First) |
| minimax |
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. |
| shorty |
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  |
| Hideo Fujii |
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 |
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 |
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
|
|
|
