|
The Quansys Analysis template is designed to work in conjunction with
our Quansys Analysis Software. Once the raw data, in the form of pixel
intensities, is collected from the analysis software it can then be imported
into the Analysis Template.
The template is an Excel® workbook embedded with Excel® Macros.
It is important that the macro security settings be set to allow the use
of macros. This can be accomplished by accessing the tools menu, then
options. Once in the options window click the security tab. Then click
the Macro Security button located at the bottom of the tab. Set the macro
security level to Medium. With this setting any time a workbook is opened
with embedded macros, Excel® will ask for permission to run the macros.
This enables only trusted macros to be run. When opening the Quansys Analysis
Template click enable macros when prompted.
The first sheet of the workbook (Opening Page) is where the information
about the type of array used and plate layout is entered. The first input
asks what kind of array was run. Using the list on the right enter the
number code in the outlined box that corresponds to the array used. The
next input requires the Antigen Standard code used in the array. This
code can either be found on the Antigen Standard vial or on the Certificate
of Analysis that was included in the kit. The next five questions pertain
to the plate layout. Enter the appropriate answer to each of the questions.
Once all the required data fields are filled move to the next sheet (Data
Input).
When using the analysis template in conjunction with the Analysis Software
it is imperative that the plate analysis is done in a particular order.
1. Each array in a well needs to be analyzed from left to right and
from top to bottom.
2. The standard curve needs to be analyzed from the high point to
the low point, with the blank well (negative control) being the last
well analyzed. If duplicates of the standard curve are run on the plate
analyze the first curve, high point to low point first, then analyze
the second curve.
3. The samples can be analyzed in any order the user wishes. It is
important to note how they were analyzed because the final data output
will be given in this same order.
4. If the samples were run in replicate, the replicates must be analyzed
one after the other.
The data from the standard curve is input starting on the red box on
the "Data Input” page. The sample data is input on the blue
box also on the "Data Input page. Once this is done the user may
proceed to the "Standard Curves Graphs” and "Sample Conc.”
sheets.
The "Standard Curves Graphs” sheet will display the standard
curves constructed from the standard curve data and antigen standard values.
The "Sample Conc.” sheet displays the calculated concentrations
for the samples run on the plate. These concentrations are calculated
using Spline Linear Regression Analysis. If replicates were run, they
will be averaged here on this sheet with "sample 1” correlating
to the first set of replicates, sample 2 the second set, etc.
If the sample pixel intensities fall outside of the standard curve linear
regression is used to calculate the values. These are indicated on the
sheet by different cell highlighting. |
