The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Saving Formulas within a Template		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

spstills23

1 Posts
Posted - 04/07/2017 :  09:59:14 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver.2015 and Service Release (Select Help-->About Origin):
Operating System: Windows 7

I am new to OriginLab and I am trying to save a formula inside a sheet template on a specific column so that when multiple data files are loaded with that template that formula automatically applies but I am not having any luck.

I am putting in the formula, in this case I want the absolute value of the integers in the column, I have used both functions of inserting the equation such as just typing it in the f(x) row as well as setting the column values. When I go to save the template and reload with new data files the equations shows up in the right spot in the f(x) line but the action of making the column absolute values didn't happen. Any ideas of what is going on and what I am missing?

Thanks for the help

arstern

USA
237 Posts
Posted - 04/07/2017 :  11:10:30 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello,

To create a sheet template and create automation (Batch Processing), you will need to create a second column in the workbook to do the analysis. The second column can be in the same worksheet or in a different worksheet. The green locked button present at the top of the column is where the automation will occur. The first column will be setup with your original values and the second column will be setup for the analysis (in this case the absolute value equation). Make sure to save the workbook as template analysis and use it for batch processing. Note: make sure the recalculate parameters are set to auto.



For more information on batch processing:
http://www.originlab.com/doc/Origin-Help/Batch-Processing

--Aviel Stern
OriginLab
Edited by - arstern on 04/10/2017 09:33:00 AM
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000