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
 stats on rows		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

zango24

India
Posts
Posted - 03/10/2015 :  3:03:06 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. 8 and Service Release (Select Help-->About Origin):
Operating System: win 7

Hello friends,
I got stuck at one point. Hope a help from your side.

I have a sheet with say 6 columns and each columns have several rows with random numbers. Now my interest is to get statistics done (e.g. sum total) of rows from 1-10, then from 11-20; then from 21-30..... and so on. And all the result of this stats (sum values) to appear or append on new worksheet.

I tried doing it manually but I realized it's just the beginning and I have to analyse more of this type of sheets in near future. So I am seeking your help.

Any suggestions?
Zen

lkb0221

China
497 Posts
Posted - 03/10/2015 :  3:20:41 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi, Zango24

A simple script can be used in Set Column Values dialog to implement this requirement. Would you mind sending one of your data to <tech@originlab.com> so I can make a sample opj for you?

Zheng
OriginLab
Go to Top of Page

snowli

USA
1411 Posts
Posted - 03/10/2015 :  4:36:13 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
In latest Origin 2015, you can choose Worksheet: Reduce Rows.
It can be used to reduce data of worksheet by different methods.
Set it as follows. You will get a new worksheet with sum of each 10 rows for each column. Is it what you want?



Thanks, Snow
OriginLab Corp.
Go to Top of Page

lkb0221

China
497 Posts
Posted - 03/10/2015 :  4:40:22 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Ah, yes. First use reducerows as Snow mentioned, and then do Statistics on Rows on the result worksheet.
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