Skip to content

Compared with spreadsheets

Your plate map, mixes and analysis, kept in step

Keep your formulas and your Prism figures. Clarida works the mixes out from the plate and carries efficiency and several reference genes into the result.

4 in your first month, then 2 a month. No card.

You keepYour own formulas, Prism for figures
You addPlate, mixes and analysis, linked
On this page

When is your spreadsheet enough?

qBase, the method behind Clarida’s normalization, began as an Excel tool.

You trust your plate and mix templateInstrument makers build on it: CFX Maestro reads a plate template back from Excel, QuantStudio a plate setup from text
You run one plate with a validated reference geneA quick check before the real experiment needs no more
You need a calculation of your ownA spreadsheet takes any formula; Clarida runs set methods
You share data with a collaboratorMIQE 2.0 names Excel among the formats to share qPCR data in
You make the figures and run the testsPrism: many tests, curve fitting and publication figures, with Info sheets for the experiment’s details
You work offlineA spreadsheet needs no connection

Is your spreadsheet doing too many jobs?

  • If the plate map, the mix sheet and the analysis are three files, two new samples change the plate at once, the mix volumes only when someone edits them.
  • If your template uses 2−ΔΔCq, it assumes 100% efficiency. MIQE 2.0 recommends against relying on ΔΔCq and asks for efficiency-corrected quantities.
  • A one-column template normalizes on one reference gene. One gene gave errors of up to 3.0-fold in a quarter of the cases studied (Vandesompele 2002). Published studies use 1.2 on average, and 15% tested their stability (Chapman 2015).
  • If three people have edited the template, which copy is right?
  • Gene names turned into dates. It affected 30.9% of papers with Excel gene lists (Abeysooriya 2021); Microsoft 365 and the 2024 edition of Excel can switch that off, though a name with a space or hyphen may still convert.
  • A reviewer asks which reference genes you checked, and how. The answer sits in someone’s copy of the template.

Side by side

What you needExcel or Google SheetsGraphPad PrismClarida
Define
Goal, background and papers
Details
A notes sheetWherever you write it: beside the data, or in another fileInfo sheetsExperimental details and notes, in the project fileIn the experimentGoal, background and linked papers, carried into the notebook export
Design
Plate layout
Details
TemplatesPlate maps drawn by hand; CFX Maestro and QuantStudio read a plate setup from a spreadsheet fileNot documentedPrism starts after the runStronger: GeneratedLaid out by your lab’s rules, in blocks for a multichannel pipette, with the reason for each automatic choice, then saved as your cycler’s plate setup file
Execute
Mix volumes
Details
CalculatorsMix calculators are common, some published; you keep the reaction count in step with the plateNot documentedPrism starts after the runStronger: From the plateA recipe per mix with its surplus, worked out again whenever the design changes, until the runs are ready
At the bench
Details
A printoutThe plate map on paper; notes go wherever you put themNot documentedPrism starts after the runStronger: GuidedWhat to collect, then the plate one stage at a time; a note on a well comes back beside its measurement
Import
Your original data
Details
EditablePasted over as easily as any other cellIn the fileKept in the project fileStronger: KeptImported Cq values are never overwritten, and the raw curves are kept
Analyze
Efficiency and its error
Details
By handPossible; a 2^−ΔΔCq template assumes 100% and carries no errorNot documentedGraphPad’s qPCR tutorial computes fold change as 2^−ΔΔCt, which assumes 100%; efficiency and its error are not mentionedStronger: Built inPer target, from your dilution series; the error is carried through to the normalized result
Reference genes
Details
By handAs many columns as the template hasOneIn GraphPad’s tutorialStronger: SeveralCombined by geometric mean, or the global mean; geNorm and NormFinder show which are stable
Your own calculations
Details
Stronger: Any formulaWrite whatever calculation you needManyTransforms and calculated variablesSet methodsThe published methods and their settings; no free formulas
Statistics and figures
Details
BasicA few tests; charts by handStronger: ExtensiveMany tests, curve fitting, publication figuresCommon testst-tests, one-way ANOVA with post-hoc comparisons, rank-based methods and correlation; adjusted p-values
Report
Sharing the data
Details
The file itselfMIQE 2.0 names Excel among the formats to share data inProject fileThe .prism file holds raw data, settings and results in an open formatStronger: Report, notebook, RDMLA PDF or HTML report with every table as CSV; an Excel notebook; RDML 1.3 with the raw curves, checked against its schema
Throughout
Who changed what
Details
Cell editsExcel 365 and Sheets record them, but not formatting or changes made by formulas, and copying the file can lose the recordNoneNo audit trail, says GraphPadDecisions storedSetting changes, automatic exclusions and accepted QC deviations, with who and when
One method for the whole lab
Details
Per copyEach copy of a template can drift; sheet protection is not a security featurePer fileOne analysis per project fileStronger: SharedA preset brings the lab’s settings set, which freezes once used; each experiment keeps its own copy; on a paid plan
A year later
Details
If you kept itAs the file was saved, if you still have the right copyLiveAnalyses update when the data change; results can be frozenStronger: FrozenA saved analysis never changes, even after an update; earlier versions of the design and settings can be restored

marks the stronger tool for that need.

In short

Stronger in a spreadsheetYour own calculations
Stronger in PrismStatistics and figures
Stronger in ClaridaPlate layout · Mix volumes · At the bench · Your original data · Efficiency and its error · Reference genes · Sharing the data · One method for the whole lab · A year later
A drawGoal, background and papers · Who changed what

How do you check it against your template?

  • Import the Cq table your template already uses. Excel, CSV and text come in, and you map the columns before anything is saved.
  • Match your template first. With one reference gene and every efficiency at 100%, Clarida should give your template’s ΔΔCq.
  • Then switch on what it skipped. Your measured efficiencies and a second reference gene, and see how far the result moves.

Can you keep your spreadsheet?

Attach your lab’s workbookYour own Excel notebook: samples, assays and Cq are read from it, and the experiment is written back into it
Paste the lists you keepSample and assay lists go into Design; an extra column, such as treatment, becomes a property to group by
Keep Prism for figuresFrom the normalized results in the Excel export
Keep planning in ExcelThe free Excel workbooks hold plate layout and master mix templates
What the export showsEach step in its own section with every intermediate value, and the settings it started from

Frequently asked questions

Isn’t ΔΔCq good enough?

For one reference gene and every efficiency at exactly 100%, yes: ΔΔCq is a special case of what Clarida computes, and the two agree. When efficiencies differ or you use several reference genes, they don’t. That is why MIQE 2.0 recommends against relying on ΔΔCq.

Is there a free qPCR Excel template?

Yes. The free Excel workbooks hold plate layout and master mix templates, with no account. For the analysis itself, Clarida imports the Cq table you already have.

Does Clarida make a lab compliant with 21 CFR Part 11?

No, not on its own, and neither does a spreadsheet: Excel, Prism and Clarida alike need validating, together with the way your lab uses them. Excel and Sheets keep cell edits; Clarida stores each setting change, each automatic exclusion and each accepted QC deviation with who and when, keeps imported data unchanged and freezes saved analyses.

Is it free?

Yes, to start. Clarida’s free plan: 4 experiments in your first month, then 2 a month. No card. The Excel workbooks cost nothing either. For comparison, GraphPad lists Prism Personal Standard at $265 a year, with no free plan.

Sources

Each source with the day we last checked it. Something out of date? Tell us.

Checked

Bring last month’s spreadsheet.

Paste its sample list to lay out the next plate, or import its Cq table and see the result corrected for efficiency. The file itself stays untouched. 4 experiments in your first month, then 2 a month. No card.

Other comparisons

All comparisons
  • Instrument software

    You keep
    The run, the protocol, signed records
    You add
    The plan, and runs from four makers
  • Dedicated qPCR software

    You keep
    GenEx for PCA and replicate planning
    You add
    Plate layout and mixes, from your lists
  • R and Python scripts

    You keep
    New methods, the wider pipeline
    You add
    The plan, the mixes, published methods
  • ELN or LIMS

    You keep
    Samples, signatures, the release
    You add
    qPCR methods your team doesn’t code
  • Benchling

    You keep
    The record, stock and sign-off
    You add
    The qPCR layout, mixes and method