The Origin Forum

The Origin Forum

All Forums

Origin Forum

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:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
ahc_hoyer	Posted - 08/10/2005 : 06:37:02 AM Origin Version (Select Help-->About Origin): 7.5 Operating System: xp Dear sirs, How this can be done automatically, especially the calculation of %-value? Thanks in advance. G. hoyer 1) Original Data A(X): a, b, c, d B(Y): 2, 3, 1, 4 2) Sort Descending: A(X): d, b, a, c B(Y): 4, 3, 2, 1 3) Calculate %: A(X): d, b, a, c B(Y): 4, 3, 2, 1 C(Y): 40, 30, 20, 10
1 L A T E S T R E P L I E S (Newest First)
Mike	Posted - 08/10/2005 : 09:36:29 AM Hi ahc_hoyer: You'll have to excuse my clumsy scripting, but I think this will do it for you: wks.addCol(C); // add column C col(C)=(col(B)/sum.total)*100; // calculate %ages sort.wksname$=Data1; // sort worksheet named Data1 sort.c1=0; // sort all columns; sort.r1=1; // sort range begin row 1 sort.r2=4; // sort range end row 4 sort.cname1$=D:C; //use col C as primary sort, descending sort.wks(); // execute sort Mike OriginLab

The Origin Forum