Hi, I am trying to use Origin to display the data I measured in a column plot. I want to merge some channels of my ADC measurement (meaning that I want to add up the values for a certain number of channels and display them as one column). How can I do that? I also uploaded the data.

Origin Ver. and Service Release: 9.9.5.167 Operating System: Windows 10

I found that tool but I couldn't get it to do what I want.

I basically want to have sum of the first 5 values of the data in the first cell, the sum of the second 5 values in the second cell and so on. In the data provided that would work out to 0 0 0 0 0 0 1 1 8 12 and so on.

But not with only with 5 but with an odd variable x. Then I can calculate the middle of each data point with: z = (x+1)/2 + (y-1) * x with y as the current cell.

So then the sum needs to reach from z-(x+1)/2 to z+(x+1)/2.

I also found the total function for calculating a sum, but I total(B[z-(x+1)/2 : z+(x+1)/2]) (with the data in Column B) didn't seem to work.

You said second 5 values in second column? But looks like you want to use column A as source and put result into column B with sum of each 5 values right?

Hi, thank you very much for your help. I tried using your code but my results are different. It just puts a -- in every cell. What could be the reason for that? In addition Origin changes the , in py.group_sum(A, 5) to a . (py.group_sum(A. 5)) when I close the window and reopen it. Could that be connected?

Looks like your PC is using "," as decimal separator. The Python or Labtalk part will still use comma, but the formula part we need to allow for comma as decimal so must use ; to separator function arguments.