Dry-product oxygen capacity worksheet

What the worksheet estimates

This worksheet estimates the air left in a sealed dry-product container and the oxygen carried by that air. It is a screening calculation for the initial package atmosphere, not a shelf-life or absorber performance model. The result depends on the measured container volume, how much of that volume the bulk product occupies, the air fraction inside the product, and the capacity allowance you enter. The output separates residual air, initial oxygen and a capacity figure so you can see which part changes when an input changes.

Container volume and bulk fill

Enter the measured sealed container volume in milliliters. Use the internal volume available to the product and air, not the product weight or an external carton dimension. The bulk fill input is the percentage of that container volume occupied by the product. At 70 percent fill, 30 percent of the container volume is unfilled headspace. That headspace is one part of residual air. If you raise fill while holding volume constant, unfilled headspace falls, so residual air normally falls. If you lower fill, more of the container is headspace and the initial oxygen estimate rises.

Interstitial air inside the product

The void input is the air fraction within the bulk product, expressed as a percentage. It is not the same as headspace. A product with 40 percent interstitial air has air in the spaces between pieces or particles. The worksheet adds this interstitial air to the unfilled headspace to obtain residual air. Changing void affects only the product-occupied portion. If fill is zero, there is no bulk product, so void has no effect on residual air. If fill is high, the interstitial term can dominate the residual air result.

Initial oxygen and capacity allowance

Initial oxygen is calculated from residual air using an oxygen fraction of 0.209. The oxygen row is reported in cc. The capacity allowance input scales that initial oxygen estimate after suitability is confirmed. A larger allowance produces a larger capacity figure; a zero allowance leaves capacity equal to initial oxygen. The allowance is a user-entered planning value, not a measured absorber rating or a guarantee. The worksheet does not model oxygen ingress, dissolved oxygen, leaks, moisture or absorber chemistry.

Suitability confirmation branch

The suitability select controls whether the capacity figure is shown. With Not confirmed, residual air and initial oxygen still display, but capacity is withheld and the status tells you to obtain product-specific food-safety review. With Confirmed dry product and suitable absorber, capacity displays and the status reads Capacity estimate only. The confirmation branch does not validate the product or absorber; it only unlocks the arithmetic. Oxygen reduction can create an unsafe environment for unsuitable foods, and moisture, water activity and processing safety cannot be assessed from package dimensions.

Worked examples for two cases

Starting scenario: 1,000 mL container, 70 percent bulk fill, 40 percent interstitial air, 25 percent allowance, suitability Not confirmed. Residual air is 580 mL. Initial oxygen is 121.22 cc. Capacity is withheld until suitability is confirmed, and the status directs you to obtain product-specific food-safety review. The 25 percent allowance is entered but not applied to a displayed capacity in this branch.

Changed scenario: same volume, fill, void and allowance, but suitability set to Confirmed dry product and suitable absorber. Residual air remains 580 mL and initial oxygen remains 121.22 cc. Capacity now displays as 151.53 cc, and status reads Capacity estimate only. The only changed input is suitability, so the air and oxygen rows stay fixed while the capacity branch unlocks.

Edge cases and interpretation

Use the edge cases to check whether the inputs describe the package you mean. At zero percent bulk fill, residual air equals the full container volume and the void input is irrelevant because no product occupies space. At 100 percent fill with zero percent void, residual air and initial oxygen are zero. Capacity displays as zero only when suitability is confirmed; otherwise it remains withheld. A high void with high fill can still leave substantial residual air because interstitial air is included. If the measured volume is uncertain, the residual air and oxygen outputs move in direct proportion to that volume.

Limits of the estimate

This is an initial-air estimate. It does not predict shelf life, food safety, absorber activation, absorber service life or package performance. It excludes oxygen ingress through seals and materials, dissolved oxygen in the product, leaks, moisture, water activity and absorber chemistry. Follow validated product and absorber manufacturer instructions. The Utah State University Extension oxygen absorber guidance supports dry-food storage context and absorber guidance, but product-specific suitability must still be established. Use the output as a screening checklist and confirm suitability before relying on any capacity figure.

Questions about dry-product oxygen capacity worksheet