Epower2 Custom Field Calculation

[kagliostro]

Hi to everyone,
I would like to discuss a custom field calculation with you guys in order to achieve %a.a. calculation.
The sequence written is this one:

Code: Select all

Vial    Inj    Label    SampleName 
  1       1     S11              STD1
  2       1     S12              STD2
  3       1     A                  x1
  4       1     A                  x2
   .       .       .                   .
  5       1     A                  x5
  1       1     S13              STD1
  2       1     S14              STD2
                                       Clear Calibration
                                       Calibrate S1*
                                       Quantitate A*
  1       1     S21              STD1
  2       1     S22              STD2
  3       1     B                  x1
  4       1     B                  x2
   .       .       .                   .
  5       1     B                  x5
  1       1     S23              STD1
  2       1     S24              STD2
                                       Clear Calibration
                                       Calibrate S2*
                                       Quantitate B*
                                       Summirize Custom Fields

All I need is to calcultate the average amount over 10 sample results. An ideal custom field would be:
SAME.%..AVE(Amount), however the label difference used to re-calibrate every 5 samples makes the 10 samples amount average calculation almost impossible.
I hope that someone can pass me a breakthrough idea.

Thanks a lot for the moment.

[DR]

summary table, for all samples (unknowns), include summary stats for that column.

Or use A1_ _ and A2_ _ to differentiate your groups. A* gets all sample results in one table, sort by label in an otherwise identical table gets you A1, A2... in separate tables.

[kagliostro]

summary table, for all samples (unknowns), include summary stats for that column.

Or use A1_ _ and A2_ _ to differentiate your groups. A* gets all sample results in one table, sort by label in an otherwise identical table gets you A1, A2... in separate tables.

I tried already what you suggesting however empower does not accept the A* as label for Summirize custom fields. Enpower says it does not exist the label A*

[DR]

I use component summary tables, label my different groups U01, U02 etc. then the tables in the report method group by label. Works fine for me.

I wonder if the problem could be with the use of "A" and "B" in the labels. These are generally used for dissolution samples in Empower.

[kagliostro]

I use component summary tables, label my different groups U01, U02 etc. then the tables in the report method group by label. Works fine for me.

I wonder if the problem could be with the use of "A" and "B" in the labels. These are generally used for dissolution samples in Empower.

The dissolution feature is not activated in this project so it should not be a problem the A and B label. I know that you can group results in the report and obtain the average amount but this number cannot be used for further calculations.

[shaun78]

How about using more characters for your sample labels?

For example, in your brackets use B11 or the first bracket and B21 for the second.

The per five sample summaries would be set to quantitate B1* and B2*

Your custom field would then become B??.%.%.AVE(Amount), as you are correct that Empower will not accept "*" as a summary function.

[kagliostro]

How about using more characters for your sample labels?

For example, in your brackets use B11 or the first bracket and B21 for the second.

The per five sample summaries would be set to quantitate B1* and B2*

Your custom field would then become B??.%.%.AVE(Amount), as you are correct that Empower will not accept "*" as a summary function.

I think this is a great idea, thanks a lot. What about if I have twp different lots in analysis. How can I distinguish the two summirize custom fields if I use label B in the script. If you can solve this it would be simply wonderful!!
Thanks a lot again.

[shaun78]

I read your post very quickly before. My apologies.

Going back to your original A and B lot designation idea...

In your example, you are only using A and B for the lot. In your example, you are calculating samples by A* or B*.

Again, I am unsure if Empower will accept the "*" wildcard in a sample set; it might, but I have never attempted that. Additionally, if your example is correct, you need something to come after your A and B designation, and you don't have that (I assume this is likely an error you made when you created the post here).

I would use A1-A5 or lot A, B1-B5 for lot B, and quantitate by A? and B?. That should take care of things for you.

You then have two summary function custom fields:

1. A?.%.%.AVE(Amount)
2. B?.%.%.AVE(Amount)