I normally have between 10 and 25 samples. How do you report average impurities of 10 peaks for 3 to 5 samples if each pair use different custom fields?
If S2 and S1 are raun in pairs, what the custom fields will look like?
You could create a custom field that averages the results of the other custom fields. This is getting quite complicated at this point, and is probably not worth it.
Now, if you were to process in pairs.
I would use the following custom field
to calculate % related compound for each peak in S1
In the sample set, under labels label S2 as S2
In your processing method label each impurity peak as ImpX or however you want to label them and Main Peak as Main_Peak or however you want to label it. You mention that there might be correction factors, in my formula I would use CFX, but you enter whatever correction factor you need.
%area = 100*Area/((Imp1[Area]*CF1)+(Imp2[Area]*CF2)+(Imp3[Area]*CF3)+(Imp4[Area]*CF4)+(Imp5[Area]*CF5)+(Imp6[Area]*CF6)+(Imp7[Area]*CF7)+(Imp8[Area]*CF8)+(Imp9[Area]*CF9)+(Imp10[Area]*CF10)+S2.1.%(Main_Peak[Area]))
To simplify this formulate you can group all the impurities under a group name and use that instead of each individual peak.
This will only work when you process S2 followed by S1 but it should work for all of your samples, unless I made a huge mistake somewhere. It uses the last result for S2, so if the last S2 processed is not the S2 for the S1 that you are processing, then it will not give the correct result.
I will try to test the calc when I get a chance, I have a lot of work today, so it may not be today.