quote:

---

Originally posted by snowli

Hello,

I couldn't download your data.

Origin supports statistics on columns. So you can first calculate the maximum value of all columns you want. Then do the copy and paste.

Here is how to do statistics on multiple columns in all worksheets of a workbook.

1, With the worksheet 0 active, you can choose Statistics: Descriptive Statistics: Statistics on Columns... menu.
2. In the dialog that opens, click the > button next to Range 1: Data Range box and choose Select Columns... context menu.
3. In the Column Browser, choose
List Columns in Current workbook.
--> It will list all columns in all worksheets (0, 4, 8, etc.)
U can select all columns you want to get maximum value on and click Add to add them into the bottom panel.
Then click OK to go back to Statistics on Columns dialog.
4. Under Quantities to computer. Uncheck all moments. Under Quantiles node, only keep Maximum checked.
5. Click OK.
--> U will get a result sheet with all maximum values calculated for all the columns you selected in Descriptive Statistics table.
6. Right click the Descriptive Statistics table and choose Create Copy as New Sheet.
7. A new sheet will be created.
8. U can reorganize the data so they are easier to be paste to the destination.


The following is a way to reorganize data better to do your copy and paste.
With the new sheet created, choose Worksheet: Worksheet Query...
Only Check Maximum column since that's the column you want to extract.
set condition to be mod(i,2)==1
Choose to output it to New worksheet.
It will copy all X values to a new sheet.
Then go back to the new sheet, and choose Worksheet: Worksheet Query... again.
Only Check Maximum column since that's the column you want to extract.
This time set condition to be mod(i,2)==0
Choose to output it to Specified worksheet. And use the > button to select the previous extracted sheet name.
Click OK
==> It will be easier to copy and paste maximum XY values now.

Hope it helps,
Thanks, Snow

quote:

---

Originally posted by lkb0221

Hi,

You can try the following script. I assume your sheets 0/4/8/.../80 all have XYXY structure.
The script does not set the the first column in the last worksheet(Tg) because I'm not sure whether all the former sheets has the same column short names.
Hope this will help you.

int bt = page.nlayers;
int st1, tti;
range rr1 = sheet$(bt)!;
for (nn=1;nn<bt;nn++)
{
range rr2 = sheet$(nn)!;
st1 = rr2.ncols;
for (kk=st1;kk>0;kk-2)
{
range rr3 = sheet$(nn)!col($(kk));
limit rr3;
tti = limit.imax;
range -v rr4 = sheet$(nn)!col($(kk-1))[$(tti)]:col($(kk))[$(tti)];
range -v rr5 = sheet$(bt)!col($(nn*2))[$(kk/2)]:col($(nn*3))[$(kk/2)];
rr5 = rr4;
}
}

Zheng