Skip to content

Planning worksheet

Beverage Shelf Life Sampling Calendar

Enter the date the study starts, the time points your protocol uses and a pull window. The worksheet lists the calendar date for each pull, flags weekend dates and counts the pulls across storage conditions. It schedules work; it does not predict shelf life.

The date the time-zero samples are tested. The initial value is an example.

Taken from your protocol. The initial list is an example, not a recommended design.

Months are added by calendar month; a start on the 31st falls back to the last day of shorter months.

Allowed deviation from the target date, as set in your protocol.

For example the intended storage and one stress condition.

Calculated result

Enter the values above to calculate. Results appear here.

A date schedule only. The protocol sets time points, conditions, tests and acceptance criteria.

What the calendar does

Magnesium beverage shelf life testing runs for months, and missed or late pulls are a common reason a study cannot be used. This worksheet adds each time point to the time-zero date, gives the earliest and latest date inside your pull window, marks dates that fall on a weekend and counts the total pulls so the laboratory can plan sample quantities. Months are added by calendar month, so a study started on 31 January has its one-month pull on the last day of February.

Plan the number of containers from the pull count: each pull at each condition needs enough containers for every test in the protocol plus any retained units. The calendar does not choose tests or time points and does not estimate how long the product will last.

What to settle before the start date

Use processed and packaged product from a representative run as time zero, tested on the start date. Write the storage conditions, the tests at each pull, such as appearance, pH, turbidity, sediment, total magnesium and sensory comparison, and the acceptance criteria into the protocol before the first pull. For a conventional beverage the declared magnesium is a Class I nutrient, so the magnesium result at the later pulls is the one that matters for the label.

Related technical guides

Public sources