open lab intelligent report

[ydna6969]

Hi,

I am trying to figure out how to trend results using Open lab (Ezchrom) Intelligent Report with limited success.

From looking at the 'filtering' on template sheet, 2 tables have trended calibration and samples separately.

The filtering functions differ by 1 value as below :
Expression Operation Value
=Peak_CalibRole = 1
=Peak_CalibRole = 4
=Sample_Type = 1

The only difference is Sample Type operation (<>) between the two tables for filtering

I'm assuming these values come from the sequence/results or methods?

How does this distinguish between calibration standards and samples for example?
I have seen similar report functionalilty in Empower and Chromeleon but struggling to sort this basic trending out

Any information much appreciated

[adeputy]

Search the term "enumeration" (no quotes) in the help menu for the data system. This will tell you how the numbers were selected.

[ydna6969]

Hi ,

I have figured out what these numbers refer to , thanks for your help

I am trying to do a simple standard verification using this software as below:

Mean Area S1/ Mean Area S2 *WT S2/WT S1

How would you create an expression like this in intelligent report
I know how to reprot means ,and weights would be entered into sequence table, just not sure how to combine 4 result varaibles into one expression and filter

Thanks again

[mmj08]

Hi ydna6969,

I'm searching to do the same things on intellingent report. If you've found something about that, please tell me !

Thanks a lot !

[ydna6969]

Hi mmjo8 ,

It must be possible using filters and expressions, but no luck as yet.
Also this may be limited on how final results are quantified (calibration bracketed,total etc)

I will let you know if I found out anything

[varossf]

Hi ,

I have figured out what these numbers refer to , thanks for your help

I am trying to do a simple standard verification using this software as below:

Mean Area S1/ Mean Area S2 *WT S2/WT S1

How would you create an expression like this in intelligent report
I know how to reprot means ,and weights would be entered into sequence table, just not sure how to combine 4 result varaibles into one expression and filter

Thanks again

This one is simple, just create 2 tables, one for S1 and 1 for S2, calculate the average Area per S and store that as a variable. Standard weight can be entered in the sequence or as a report variable. Then just set up that calculation. Done it, got the T shirt.

[ydna6969]

Hi
I have tables set up for S1 and S2 with mean displayed using 'Column Properties' Tab and 'Summary calculations', is this correct?
I have entered weights into sequence table and also have these summarised in the report.

I am unsure what you mean by 'store this as a variable'
Do you type this value into a custom field column everytime then stored as variable?
Though this seems pointless as the mean value would change by sequence/day /system etc and report would be required to be updated everytime


Where can this changing variable be stored, and how?
Where would the final calcualtion be set up ? Would this be as an expression calculation ?

I think I am missing something here ,, my mind is still programmed using Chromeleon and Empower reports !!

Thanks

[varossf]

time for a training i would say.
When you make a table in Intelligent Reporter (IR) it consists of columns like Area column. In the properties of the column you can select which statistics to be calculated, like Average.
You can see an open line behind that Averge when selected, fill out there the variable name you wish to use.

Then add a text field, open it an in the properties define under the value the formula you want to use.

If you don't understand i can set up a webex to explain ti to you.

[ydna6969]

Hi ,

Thanks for this information.
I now have standard verification in reports and I have afew more things to experiment with using this.

Though I am now having problems when priniting off summary reports
The print preview window may say 'page 1 of 2' on screen but when it comes to printing it prints off more pages than required, most are blank apart from header and footer.
I have check page breaks and everything is ok here.
It also occurs when I copy and paste tables to summary report.
Example :
Report originally 3 pages (prints out 3 pages ,none are blank)
Expand footer to fit extra tables.
Copy and paste tables required and change filters
Print preview now read 'page 1 of 4'
When printing it prints report but every other page is blank accept header and footer

Where I am going wrong?
Why when you add tables to end it prints blank pages ?

[varossf]

THere are multiple reasons for blank pages. Either the tables are wider than the actual page size and/or in the tables or other objects on the report there are 'form feeds' defined in the properties resulting in blank pages.
I have seen this before and after combing through the report i could eliminate the blank pages.

So double check your settings and reduce the table width.

[ydna6969]

Hi ,

Yeah I figured out the problem of printing as you have mentioned ,thanks again

I'm also trying the charting function in intelligent report
I have created a dissolution profile using the average results (n=6).

Each Mean result as a custom field and charting using scatter - lines

The points are shown on chart but I cant seem figure out how to draw line between series points

Example Data values
X- values (timepoint in mins)
20 (series 1)
30 (series 2)
45 (series 3)

Y-values
Average compound amount (using varaiable option naming at that timepoint for n=6)

This creates 3 series and shows this on chart though no line/curve
Any ideas?
Not sure how you would create this plot using just 1 series (mean result versus timpoint without scatter?)
Cheers

[ydna6969]

Hi

Think I may of confused myself reading this back.

What I am trying to do is have an xy scatter where x is timepoint (mins) and y is compound amount (% release), as per excel.
Each series would be the vessel number at each timepoint so 6 profiles are shown in the chart.

How is this charting possible to do in Intelleignet report ?
Thanks in advance

[varossf]

I think this is possible, but requires to store the %released in a matrix and then select that in the graph. I need to work on it but i think it is doable.

[ydna6969]

Hi ,

Thanks for your reply.
I currently have each timepoint tabulated for n=6 (each vessel) with mean ,min max also (column properties and summary calculations) using a filter for sample description
ie
Timepoint 1 - sample description = A (filter contains A)
Timepoint 2 - sample description = B (filter contains B)

This works fine

As mentioned for charting each series would be a vessel (y been % release and x been timepoint)
As you say this should be doable
I have tried custom fields (timepoints as custom fields v % release) but this creates separate series for each field

Let me know if anybody has any further success witht this

Cheers

[KrisMiklos]

Hi,

what about with the systems with two compounds?
Report calculate average area for both of compounds but when I define it like variable in Summary Calculations, in Expressions IR used only one average area of the two. I need results from control area/average area of Compound1 and control area/average area of Compound2 too in the same table.

Hi ,

I have figured out what these numbers refer to , thanks for your help

I am trying to do a simple standard verification using this software as below:

Mean Area S1/ Mean Area S2 *WT S2/WT S1

How would you create an expression like this in intelligent report
I know how to reprot means ,and weights would be entered into sequence table, just not sure how to combine 4 result varaibles into one expression and filter

Thanks again

This one is simple, just create 2 tables, one for S1 and 1 for S2, calculate the average Area per S and store that as a variable. Standard weight can be entered in the sequence or as a report variable. Then just set up that calculation. Done it, got the T shirt.