| Author |
 Topic  |
|
|
jbolha
Slovenia
2 Posts |
 Posted - 11/21/2014 : 05:54:16 AM
|
My problem is that I need to calculate area under 1600 curves with OriginPro 9.1. It would take too much time to calculate every integral separately, is there possibility to calculate it automatically? Datas are in Excel file and every curve is on one sheet.
Thank you! |
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 11/21/2014 : 4:44:35 PM
|
Hi jbolha,
If your XY dataset pairs are stored in a single worksheet, highlight all Y columns, and run the integration("Analysis:Math:Integrate" menu). All result columns are appended to the end of the original worksheet.
Does it work in your case?
--Hideo Fujii
OrginLab
|
 |
|
|
jbolha
Slovenia
2 Posts |
Posted - 11/24/2014 : 03:27:33 AM
|
Thank you for your answer, but it doesn't work because I have multiple worksheets (one curve per worksheet, so I have 1600 worksheets) and if I highlight Y columns it calculates only currently open worksheet.
Any other possible methods? |
|
|
|
snowli
USA
1379 Posts |
Posted - 11/24/2014 : 2:32:07 PM
|
Hello,
We made a lot of Excel Import Improvements in Origin 2015, including importing columns in different sheets into one sheet in Origin.
In Import Excel dialog, set 1st File Import Mode to Start New Columns.
Then you can use the way Hideo said above.
Otherwise, you may need to write some Labtalk script to automate the process.
Or after importing all data into worksheets,
plot all data into one graph: Choose Plot: line with nothing hilighted in worksheet. In Plot Setup dialog, choose all worksheets to plot all data into one graph.
Then click on any plot to select all data plots. Use Analysis: Mathematics: Integrate. In the dialog expand Input Data node to make sure there are multiple ranges. Set Output to New Sheet. This way, it can do integration for all plots and put results into a new sheet.
Thanks, Snow |
Edited by - snowli on 11/24/2014 2:39:15 PM |
|
|
| |
Topic |
|
|
|
Automatic calculation of multiple sheets