-
Excel workbook preview
Testing, Specifications and Shelf Life
Sensory Evaluation Score Sheet
3 downloads per free account, no card needed.
Who this is for
A technical manager running shelf-life time points or a supplier trial who needs panel scores a customer or auditor can follow.
What is inside
- 9-point quality scale with descriptions, against the approved standard sample
- 10 worked panellist rows for two shelf-life samples (day 10 passes, day 12 fails)
- Panellist mean and a defect flag when any score is at or below the defect level
- Results sheet: attribute means per sample with AVERAGEIF and the lowest attribute mean
- Verdict: Pass, Fail or Too few panellists from 4 editable pass marks
- Score cells limited to whole numbers 1 to 9, with defect scores shown red
How to use it: Agree the scale and pass marks on the first sheet, then enter one row per panellist per coded sample.
Files & formats
- XLSXsensory-evaluation-score-sheet-template.xlsx13 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



