Hi,
You can make the operations into an analysis template and in the future either import data into this template or run batch processing.
1. Start a new workbook and import your data. (31 columns, 1 x and 30 y's).
2. Run differentiation tool on column 2, set recalculate mode to Auto in the dialog. It creates a new column in the worksheet.
3. click on the green lock on the resulting column header and select Repeat this for all y columns. Now 30 more columns are added with derivative data and worksheet has totally 61 columns.
4. From col 2 to col 31, we are going to plot with column (2,32), (3,33)... that is (i, i+30). Select menu Worksheet: Worksheet Script.., add following script:
wksname$ = page.name$;
win -t plot;
gpname$ = page.name$;
for (int i = 2; i <= 31; i++)
{
plotxy iy:=[wksname$]1!($(i),$(i+30)) plot:=202 o:=[gpname$]1!;
}
layer -g;
We can trigger the script when the derivative data in the worksheet is changed. Check Upon Changes in Range(s) and enter 32 in the entry. You can click the running man button to test the script.
5. Save the workbook as analysis template. You can use this analysis template to run batch processing to handle other data files.
If you need more help, please contact us at <tech@originlab.com>.
James
Plot dy/dx vs y for multiple columns
Posted - 02/08/2020 : 3:58:56 PM
