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
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 take derivative of all Y columns in XYXY worksheet

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
fexxor Posted - 03/08/2009 : 11:32:36 AM
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.
1   L A T E S T    R E P L I E S    (Newest First)
Deanna Posted - 03/10/2009 : 01:09:07 AM
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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000