What it saves you
- Plate layouts for 96 and 384 wells, and a master mix calculator, ready in Excel
- No macros to allow: every workbook is an
.xlsxfile - Your own workbook reordered, renamed and restyled, with the original left as it was
How it works
01In the tool: Excel workbooks › Download a workbook
Start from a template
Starting templates are laid out in Clarida’s sections and styling: Styled blank, Quick start, and qPCR experiment, with its sheets Overview, Setup, Data and Analysis. The interactive tools calculate as you type: the 96-well and 384-well plate tools take sample and assay names as a list and show them on the plate, and read a filled-in plate back as a list. A 384-well plate fills whole, quadrant by quadrant if you like.
02In the tool: Excel workbooks › Download a workbook
Master mix calculator for the whole plate
Enter the samples, assays and replicates, the volume of each component and a surplus. Mix tools gives the reactions and plates you need, the material per sample and assay, and pipetting instructions three ways: 3-step, 2-step with a sample mix, 2-step with an assay mix. It flags a pipetting volume below 2 µL or above 1000 µL, and assumes every sample is measured for every assay. Plate & mix tools holds both plate sizes and the calculator in one workbook.
03In the tool: Excel workbooks › Enhance a workbook
Tidy a workbook of your own
Upload an .xlsx workbook, or load a template, and its sheets and sections show as a tree. Drag them into a new order, rename them, change a section’s type, add new ones and delete the rest. Download file gives you a new workbook; the one you uploaded is not changed, and Restore to original undoes every change to the structure.
- Styling: none by default, minimal, or full
- Added on every sheet: an Overview, an Experiment info section, a Sheet info section, if you tick them
What the workbooks don’t do
| ΔΔCt analysis | Gene expression in Clarida, inside an experiment |
|---|---|
| Check a layout for missing controls | The Plate editor, in the browser |
| Put the plate tools into your own workbook | Not here: they are download only; Plate & mix tools is the one that loads into Enhance |
Frequently asked questions
Are the Excel workbooks free?
Yes, with no account: downloading a workbook and tidying your own are both free.
Do the workbooks use macros?
No. Every workbook is an .xlsx file, which cannot hold macros; the interactive tools calculate with formulas.
Is there a 96-well plate template you can print?
Yes. Download the 96-well plate tools, fill in your names, and print the plate from Excel.
Which files can you upload?
Enhance takes an .xlsx workbook, and every template downloads as one.
Why does the citation say Lab workbooks?
That is the tool’s name in the app; this site calls it Excel workbooks.
