| T O P I C R E V I E W |
| moondream |
Posted - 09/13/2002 : 11:07:13 AM
HI, all,
I have a set of worksheets with x and y column. I would like to add all the y column of different worksheets up. I know how to add them with same row. But could any one tell me how to add them with same x value? and make it to a new worksheets.
best regards,
moondream |
| 2 L A T E S T R E P L I E S (Newest First) |
| moondream |
Posted - 09/14/2002 : 05:05:02 AM
Hi, easwar
Thank you so much. It is really what i want.
moondream |
| easwar |
Posted - 09/13/2002 : 2:56:31 PM
Hi moondream,
Say you have the following data:
Worksheet Data1 has:
A(X) B(Y)
1 10
2 20
3 30
Worksheet Data2 has:
A(X) B(Y)
2 20
3 30
5 40
and you set up your result worksheet as:
Worksheet Data3:
A(X) B(Y)
1
2
3
4
If you now execute the following line of command in your script window (menu command: Window->Script Window, type this line and then hit the Enter key)
data3_b = data1_b(data3_a)+data2_b(data3_a)
the result will be:
Worksheet Data3:
A(X) B(Y)
1 20
2 40
3 60
4 75
For value of x that are common to all worksheets, Origin just sums up the appropriate rows. For values of x that are not present in any worksheet, Origin gets the value for that worksheet by linear interpolation.
Hope this helps.
Easwar
OriginLab.
Edited by - easwar on 09/13/2002 2:57:32 PM |
|
|
