Below is an example script which performs the necessary calculations on the active dataset (column). To activate a dataset, select the corresponding column in your worksheet. Alternatively, activate it in a graph window by selecting the dataset from the list at the bottom of the Data menu. Once activated, highlight the script (after pasting it in the Script window) and press the ENTER key on your keyboard.

total=0;
loop (ii,1,10) {total=total+%C[ii];}; // sum up first ten cells
total=total/10; // average them
(%C)=(%C)-total; // subtract total from active dataset

Note: %C is enclosed in ( ) to force the string inside %C to be expressed before assignment (before the vector calculation ensues). This is required.

To apply this script to every column (except the first), place the calculations above in another loop which goes from 2 to wks.ncols. Use the worksheet -s command option to activate each successive column in the loop. Be sure to use a different index variable (i.e. jj instead of ii) for the second loop.

Good Luck!
Ryan