| T O P I C R E V I E W |
| praveen248 |
Posted - 05/31/2016 : 04:46:11 AM
I have got huge chunks of data
For example:
I do calculations on Columns and creation of graphs on columns, then I have this problem like when I automate this process for different folders in a project, the entire origin gets stuck, how do I handle this calculations?
Is there a way we can speed up the origin to do the calculations fastly and reduce the load on
B.V.Praveen |
| 4 L A T E S T R E P L I E S (Newest First) |
| cpyang |
Posted - 06/01/2016 : 5:56:11 PM
Hi Praveen,
We did some test and found if Excel book is used inside the LabTalk code, then there is a significant slow down as more and more Excel books are open. Is it possible to do the calculation not using Excel book?
CP
|
| snowli |
Posted - 06/01/2016 : 2:46:58 PM
Hello,
We did some simple test with import, calculation and plotting, and repeat it for many folders but couldn't reproduce the issue.
So it could be related to the data size, calcuation, etc.
Some questions:
1. Are you using LabTalk Script to automate the process. If so, could you send your script to us together with some data files since we want to know how many rows of xy data in data file and what the excel template is like.
2. What kind of calculation are you doing. do you use column formula or some other way to calculate it.
3. How did you import Excel template into Sheet3 since i am not sure how your calculation in excel template can be executed in Origin. Or do you just mean you imported some excel data file into sheet3 and then used Origin's set column values to calculate them?
4. What kind of plot did you use. With user-defined template or some built-in one.
5. When you said, "So it works fine if its a single folder", do you mean if you repeat such process 100 times in same folder, it's fine?
Could you email to tech@originlab.com so we can see how to reproduce the issue and if we can improve the speed.
Thanks, Snow |
| praveen248 |
Posted - 05/31/2016 : 08:01:46 AM
Hi Sean,
Thanks for the quick reply, its not a problem with analysis template, I am using one, but its with the size or memory or calculation it does is slow when the file size is big or when the number of files are more.
But i'll explain you the process
Suppose I open a project and create a folder 1 and do the following operations:
Step1: Importing the ascii files to worksheet, Result: sheet1: x,y data
Step2: calculations on xy data and creation of two more columns in a seperate sheet, RESULT: Sheet2: x,y
Step3: importing a excel template and filling it with the calculations, Result: Sheet3(template)
step 4: plotting the graph of Sheet 2:
Step 5: renaming the folder
So it works fine if its a single folder
But i need to automate the above process for something like creating 100 folders with all these steps, and all folders should be into one single project
Problem: So while after creating the 5th or 6th folder in the same project, the entire origin gets slowed down and gets stuck,
So, what I want is a 100 folders creation with the calculations at each and every folder without origin getting stuck..
Regards,
Praveen
quote:
Originally posted by SeanMao
Hi,
Can you describe your problem in more details? For repeated analysis, you can simply do analysis and graphing for one data and save the workbook as analysis template, then use it to quickly batch process others. You can get some sense from this link below:
http://originlab.com/index.aspx?go=Products/Origin/HandlingRepetitiveTasks
Regards!
Sean
OriginLab Tech.
B.V.Praveen |
| SeanMao |
Posted - 05/31/2016 : 04:55:46 AM
Hi,
Can you describe your problem in more details? For repeated analysis, you can simply do analysis and graphing for one data and save the workbook as analysis template, then use it to quickly batch process others. You can get some sense from this link below:
http://originlab.com/index.aspx?go=Products/Origin/HandlingRepetitiveTasks
Regards!
Sean
OriginLab Tech. |
|
|
