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 for Programming
 LabTalk Forum
 take derivative of all Y columns in XYXY worksheet		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

fexxor

USA
Posts
Posted - 03/08/2009 :  11:32:36 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin 8.0

I have large worksheets (XYXY type) for which I want to take the derivative of all the Y columns (with respect to the associated X) and put the results in another sheet(also XYXY) with appropriate colmmn names. Thus, if raw data column names are A1, A2, A3... then derivative columns will be called derA1, derA2, etc.

I want use script rather than a template as there are hundreds of columns in each sheet.

Presumably the same loop could be used to fit or find single peak of all the derivatives oor to plot all results (using plotxy?)

How can I do this for all worksheets in the workbook?

Thanks in advance for any help.

Deanna

China
Posts
Posted - 03/10/2009 :  01:09:07 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
To calculate derivative, please use the differentiate X-Function.

To loop over all workbooks, you can use the document -e command. For worksheets in a workbook, you can write another loop to loop over the sheets in the workbook.

Deanna
OriginLab Technical Services
Edited by - Deanna on 03/10/2009 01:09:35 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