(Hitachi Software Engneering America Ltd. MiraiBio Group.)

Hitachi

Document details

Details for Summary Report with conditional formatting #3
PropertyValue
NameSummary Report with conditional formatting #3
DescriptionThis report contains a summary worksheet and individual worksheets for each analyte.
  1. Conc. Summary - This worksheet lists the average concentrations of replicate groups. It also reports the highest and lowest standards for each analyte as well as the lower limit of detection and a %CV cutoff. The conditional formatting is as follows:
    • Cells with bold font represent values that have been extrapolated
    • Cells with concentrations below the lower limit of detection (background + 3 SD) have a red background
    • Cells with concentrations below the background are marked as "<OOR"
    • Cells with concentrations above the saturation point are marked as ">OOR"
    • Cells with concentrations above the %CV cutoff are highlighted in yellow
  2. Additional sheets per analyte - Lists the individual well information containing:
    • SampleID
    • Mean MFI
    • Mean Concentration
    • CV%
    • # of Replicates
    • Well Location
    • Dilution
    • Run Order
    • MFI
    • Bead Count
    • Concentration
    The same conditional formatting rules listed above applies to the Concentration and Mean Concentration columns.
This template exports a .xml file which is intended for Microsoft Excel.

To open the file, right-click -> Open With -> Microsoft Excel.

Please refer to our community forum post for instructions on using these report templates.

If you would like to have a customized report template tailored to your needs, we can provide it as a service. Please email info@miraibio.com for more information.

FilenameFlag2.xsl
Filesize119.78 KB
Filetypexsl (Mime Type: text/x-xslt)
Last updated on 08.02.2010 18:10