| T O P I C R E V I E W |
| dominik.mierzwa |
Posted - 01/28/2020 : 12:55:13 PM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2020 (64-bit)
9.7.0.185 (Academic)
Operating System: Windows 10 Pro
Hi,
I have three questions:
1. It is possible to create the batch processing report with links? Currently, when I perform batch processing I receive the summary report but the data are pasted there so change in the source data does not change the values in the summary report.
2. Does the "mask cells by condition" (MCC) function work in the analysis template (AT)? During the preparation of the AT I applied MCC on particular columns, but during batch processing the mask is not applied. I have tried multiple options including "keep existing mask" but unsuccessful. Each new file is processed in accordance AT, but the mask is not applied.
I also noticed that during clone import of a new xls file, the mask applied on the "source sheet" is also omitted, and I have to add it manually on new, imported data.
3. What is the best method for the following analysis:
-import of data from single xls (multiple sheets) or multiple xls (single sheet)
-mask cells by the condition in selected columns
-calculate the mean value and standard deviation for selected columns
-generate a summary report (with links) with calculated mean and SD
Kind regards,
Dominik |
| 4 L A T E S T R E P L I E S (Newest First) |
| dominik.mierzwa |
Posted - 02/06/2020 : 1:50:45 PM
OMG  I tried irng:=2-5 instead of 2:5
THANK YOU!
Kind regards,
Dominik |
| YimingChen |
Posted - 02/06/2020 : 09:10:27 AM
Yes, you can use e.g. colmask irng:=2:4 cond:=gt val:=1200 to mask column 2 to column 4. More details can be found in this xfunction page:
https://www.originlab.com/doc/X-Function/ref/colmask
James
|
| dominik.mierzwa |
Posted - 02/06/2020 : 08:09:23 AM
Hi James,
Regarding the colmask function, is there any method to define more than one column at once? Do I need to define a mask for each column separately?
Kind regards,
Dominik |
| YimingChen |
Posted - 01/28/2020 : 5:03:40 PM
Hi Dominik,
1. We have addressed this issue in our next version, we add a reprocess button in the summary worksheet that same batch process can be rerun after the data file has been updated. For now, you can click on the triangle button on the upper right of the batch processing dialog and select Generate Script. To repeat the batch process, you can run the script in Script Window. Check below for more details
https://www.originlab.com/doc/LabTalk/guide/From-Script-and-Command-Window
2. Worksheet Script will do the job. Activate first worksheet of your analysis template where you import your data. Go to menu Worksheet-> Worksheet Script and add a line of LT script e.g. colmask irng:=1 cond:=gt val:=1200;. Check After Import. This way conditional masking will be applied during batch process.
https://www.originlab.com/doc/Quick-Help/run-script-after-import
3. Do you mean the steps to build analysis template? Once you import your data and apply mask by condition, you can go to menu Statistics->Column Statistics.. to get mean and std of selected columns. Add new summary sheet, copy mean and std values as links into the summary sheet. Then you can save the workbook as analysis template. Check details in the following tutorial page:
https://www.originlab.com/doc/Tutorials/AnalysisTemplate-BatchProcess
James |
|
|
