Average Repeated Locations

Use the Database Tools > Channel Tools > Average Repeated Locations menu option (AVGREPXY GX) to average the values in a given channel which appear at repeating locations in a line.

Average Repeated Locations dialog options

Channel

Name of the channel to process Script Parameter: AVGREPXY.CHANNEL

Notes

This GX first sorts the data in X and Y in order to put the data with the same locations next to each other, while preserving the original order for duplicated individual locations. (This sorting is done internally, and does not show up in the database after the GX is run).

The first location value is replaced by the average of all values at that particular location, while subsequent values are reset to dummy.

For instance, the following data:

X	Y	Z
0	4	1
5	7	2
2	5	3
3	2	4
7	8	5
2	5	6
9	8	7
6	3	8
9	8	9

…is replaced by:

X	Y	Z
0	4	1
5	7	2
2	5	4.5
3	2	4
7	8	5
2	5	*
9	8	8
6	3	8
9	8	*