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
 average curves with intervall		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Jengo

Germany
13 Posts
Posted - 08/02/2010 :  11:19:46 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release: v 8.1.13.88
Operating System: Win XP

I have 8.000 columns and want to generate the average from every 6 columns.(1-6,7-12,....)

I dont know how to integrate the interval of 6 in my code

avecurves -r 2 avex:=same; (is working for marked columns)

for each column I would use the loop

loop(ii,1,wks.ncols)

{

}

does anybody have a advice for me?

larry_lan

China
Posts
Posted - 08/02/2010 :  9:09:31 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Here is an example. Please read the LabTalk Guide for more information.

string sbk$ = %H;
string sst$ = page.active$;
int scol = wks.ncols;
int tcol = scol/6;
string bkname$;
newbook result:=bkname;
for(int ii=1; ii<=tcol; ii++)
{
	rowstats irng:=[sbk$]sst$!$(ii*6-5):$(ii*6) mean:=[bkname$]sheet1!$(ii) sd:=<optional>;
}

Thanks
Larry
Go to Top of Page

Jengo

Germany
13 Posts
Posted - 12/13/2010 :  08:08:09 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hallo again! :)

Is the same possible for rows? I found it only for columns in the labtalk guide :/

http://www.originlab.de/www/helponline/Origin/en/programming/mergedProjects/LabTalk/LabTalk/Data_Reduction.html

Thank you very much for the help! :)

Jengo
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