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
 Origin Forum
 averaging data in multiple columns

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
NorthwestLee Posted - 04/16/2005 : 2:26:48 PM
Origin Version (Select Help-->About Origin): 7.0
Operating System: XP


I am new to Origin and I was reading through the automating analysis demonstrations, and the included Automation file in the samples folder, but I am rather lost in the code.

I need to take a series of about 100 project files (with the ability to add more) which each contain a worksheet that has a standard format. I need to extract the data from Column E and average it for each row in that column for every file. E is 6 rows long and so I want to calculate an average for row 1 of E for all the projects, average for row 2 etc. I need to do the same for row G as well. On some of them the row length will not be 6 and so I want that when a row is not present in E for it to not go into the average. The X values in row D which correspond to the Y values in E will not change. Then I want to graph the average Y's vs. the respective X values.

Any help or suggestions of where to read and start would be appreciated

Thanks
1   L A T E S T    R E P L I E S    (Newest First)
easwar Posted - 04/16/2005 : 3:05:48 PM
Hi,

Please do not post same item in multiple forums - makes it hard to keep track of threads...see response to same item in Origin C forum:
http://www.originlab.com/forum/topic.asp?TOPIC_ID=3886

Easwar
OriginLab


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