See personalized New Product recommendations! Get personalized New Product recommendations! Register or Login for personalized New Product recommendations!

Holiday Notification: Cayman Chemical will be closed Monday, May 28, 2012, in observance of the Memorial Day holiday. More…
Please feel free to continue placing orders via our website or via fax at 734-971-3640. You may send an email to customer service at custserv@caymanchem.com , or to technical support at techserv@caymanchem.com which we will respond to the next business day. Cayman will resume regular business hours and shipping schedules on Tuesday, May 29, 2012. Thank you for your patience and understanding.

Vitellogenin Analysis Tools

View other analysis tools

This is the Cayman Chemical Company Vitellogenin Assay Tools page. This area is dedicated to serving the analysis needs of our Vitellogenin Assay Kit customers. It contains information, Excel workbooks, and other tools useful for anyone using the Cayman Chemical Vitellogenin Assay Kit.

If you have questions on the use of our tools, or feel something is missing, please contact Technical Services.

The Workbooks

Currently, Cayman Chemical uses two Microsoft Excel workbooks for analyzing Vitellogenin assays: VitelloTriple and VitelloDouble. The first is formatted for assays performed in triplicate, and the second is formatted for assays performed in duplicate.

Download

Your downloading these files implies acceptance of the license agreement listed below and present in each workbook.

  • VitelloTriple ~ 600 Kb XLS formatted for assays performed in triplicate
  • VitelloDouble ~ 600 Kb XLS formatted for assays performed in duplicate

Trouble downloading? Right-click the link and select "Save Target As..."

These instructions are repeated on the first sheet of each workbook.

VitelloTriple worksheet screen shot
VitelloTriple Worksheet
VitelloDouble worksheet screen shot
VitelloDouble worksheet

Definition of Key Terms

Term Definition
NSB Absorbance due to non-specific binding of the antibody
Std# (Standards) Standards #1 through #11 made by serially diluting Std01 ten times. [NOTE: The rainbow trout assay only has 10 standards]
Smpl# (1:#) Samples and their associated dilution factors
Ctrl# (1:#) Positive controls and their dilutions (Cayman Chemical uses 1:5 dilutions of Std01 & Std03)

Workbook Sheets

Analysis
Field Explanation
LAYOUT Contains sample names and associated dilution factors
RAW DATA Data entered into the worksheet in the format defined by the LAYOUT section
SUBTRACTED The AvgNSB is subtracted from each cell
CONC The concentration for each cell is calculated based on the absorbance value, constants from the linear regression curve (see StdCurve section), and the dilution factor from the LAYOUT section
STANDARDS The Avg and Recalc values are calculated for each concentration value. Recalc are the standard concentration values calculated from the regression constants
Samples This table is compiled from the preceding sections. It includes
  • Conc: average of the replicate concentrations from the CONC section
  • Dilution: the dilution factor, for that sample, from the LAYOUT section
  • StdDev: the standard deviation of the replicate concentration values
  • %CV: the coefficient of variance of the replicate activity values
  • SEM: the standard error of the mean for the replicate concentration values
STATS y-int and slope are obtained from the linear regression fit of the calibration data.
FILENAME The filename given to the Excel workbook
VERSION The current version of the Excel workbook
StdCurve

This is the calibration curve of the concentration standards plotted versus their absorbance values. The data are fit to a linear regression line with the general equation: y = mx + b.

Instructions

The worksheets were designed to be as "hands-off" as possible. The following instructions assume you have loaded your plate according to one of the plate layouts shown above, and have the data in a form that can be imported (or pasted) directly into a spreadsheet. To analyze your data:

  1. Select your assay from the pull-down, scrollable menu. [For the Rainbow Trout kit, all references to Std11 are scratched out, and are not included in the calculations.]
  2. Input your sample names into the appropriate cells
  3. Input the sample dilutions into the appropriate cells in the format shown (e.g., 1:5)
  4. Paste/type your data into the RAW DATA section (starting in cell B14) of the Analysis worksheet. Select the "Values" option in the "Paste Special..." dialog box to maintain formatting.

All concentration values, and relevant statistics, are automatically calculated. The Samples table is then filled in with the data. All averages and statistics are calculated based on all replicates for each sample. It is the responsibility of the individual researcher to decide if any data can be eliminated. Caution should be exercised, however, when doing this! Cayman Chemical has examined statistical methods to test for the presence of outliers in 96-well assays. We find that individual replicates are rarely flagged as outliers, and cannot be eliminated from the experiment.

Note The sole purpose of the data contained in this workbook is to demonstrate the functions of the individual spreadsheets.

Copyright and Disclaimer

Copyright © 2012 Cayman Chemical Company, Inc. All rights reserved.

Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

  1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
  2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.

THIS SOFTWARE IS PROVIDED BY CAYMAN CHEMICAL COMPANY, INC. "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL CAYMAN CHEMICAL BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

The views and conclusions contained in the software and documentation are those of the authors and should not be interpreted as representing official policies, either expressed or implied, of Cayman Chemical Company, Inc.

Other Resources
Management Team Company Profile Company History ChemAssistant Tools FAQs Cayman Europe Cayman Pharma CaBRI Cayman Gear Press Releases Illustrations and Charts Key Research Area Posters Article Library Analysis Tools Conference Schedule Order Terms Browser Recommendation Privacy Statement Site Map

Cayman Chemical Company · 1180 East Ellsworth Road · Ann Arbor, Michigan 48108 · USA

Toll Free: (800) 364-9897 (USA and Canada Only) · Fax: (734) 971-3640

Copyright 2012 Cayman Chemical Company

Lost password?