| Author |
 Topic  |
|
|
andrews89
3 Posts |
 Posted - 02/24/2012 : 12:22:52 PM
|
Origin Ver. and Service Release (Select Help-->About Origin): 8.6.0 b70
Operating System: Windows 7 x64 SP1
I have a data set that I apply 8 fits to (over different ranges), and I have a working batch processing system for running through my entire batch of data sets. However, I would like to create a "summary sheet" for each individual data set during the batch processing. I have a template for the output I would like, consisting of the file name, a few values linked to the fits, and a plot of the fit for quick reference. This template is in a different workbook than the one that does the actual fitting. Is there a way to save one of these workbooks for each target? I would like to be able to look at the corresponding graphs if I have doubts about how well a fit worked on a given data set. In summary, I'm wondering if there is a way to, during the batch processing, output all of the graphs from my 8 fits onto a new workbook for each data set, to later be viewed/PDFed/printed. Is this possible? Thanks for any thoughts. |
|
|
easwar
USA
1964 Posts |
Posted - 02/24/2012 : 2:04:38 PM
|
Hi,
First of all, add your custom "summary sheet" to the same book you are using as template for batch processing. Then in the Batch Processing dialog, uncheck the check box "Delete Intermediate Workbook".
Then at the end of the batch processing task, the workbooks corresponding to each file will be left around, not deleted. You could look thru those to check what you want.
Will this work? Perhaps easier if you send your file to tech support and give them a call to discuss this further.
Easwar
OriginLab |
 |
|
|
andrews89
3 Posts |
Posted - 02/24/2012 : 2:43:39 PM
|
That would probably do it... My only concern is my total data set is around 500 sets. Would this cause stability issues with Origin having so many workbooks in one file?
Also, to show my real stupidity: Is there a simple way to move worksheet from one workbook to another? It's all nicely formatted, and I'd rather not have to go through formatting the page again if I can help it. |
|
|
|
easwar
USA
1964 Posts |
Posted - 02/24/2012 : 3:47:43 PM
|
Hi,
To move sheet from one book to another, just click and hold the sheet tab and then drag and drop to the other book.
The batch processing tool has an option to run script after each file has been processed, so I was thinking you could add script there to export your custom sheet as say a pdf or png, so you will have those export files to refer to, and don't need to save the entire intermediate workbook with all the data and the fit results. But when I try that, the sheet gets exported, but the graph inside the sheet is missing in the export..we will look into why this is occurring.
Not sure how large your dataset is...you have a 64-bit version which has access to more memory. So you could try keeping the intermediate book for all the 500 datasets and see how that goes.
If you run into more trouble with this, perhaps send us a few files and your template and we can help write some script (outside of batch processing tool).
Easwar
OriginLab
|
|
|
|
andrews89
3 Posts |
Posted - 03/01/2012 : 4:49:45 PM
|
| Thank you for that, and of course, I'd be happy to provide my template and some test files for a tutorial. Unfortunately, I've run into another problem: I was originally telling Origin to "repeatedly import into Active Analysis Template Window," as when I would try to save my template as an Analysis template and run it, I would receive an error about locked columns. The very first data set would run, but then Origin would just error out on the rest. Would there be a way for me to upload my template so as to see what is going wrong? I'm sure your code for exporting the graphs will work, however, it does not work with the "repeatedly import" setting. Thank you again for your help. |
|
|
| |
Topic |
|
|
|
Automated Output to Multiple Workbooks