Skip to content
Skip to main content
Knowledge Base
< All Topics
Print

Recipe Data Calculation System

Posted
Updated
Byicecreamcalc

Understanding Ice Cream Calc’s Recipe Calculations

1. Introduction

Every recipe in Ice Cream Calc generates hundreds of calculated data properties that help you understand and optimize your ice cream formulations. These calculations power automatic balancing, giving you deep insights into your recipe’s characteristics.

The Data Viewer page (/data-items/view) provides a centralized place to explore all calculated properties from your current recipe. Whether you’re looking for specific values like PAC or POD, or creating custom calculations with formulas, the Data Viewer is your window into the recipe calculation engine.

When to use the Data Viewer:

  • Exploring available data properties for formula creation
  • Understanding what values are being calculated
  • Checking specific ice cream science metrics (freezing points, serving temperatures)
  • Verifying nutritional calculations
  • Creating and testing custom formulas

2. Understanding Calculated Data

What is a RecipeDataItem?

A RecipeDataItem is a single calculated property from your recipe. Each data item contains:

  • Property Key: The technical name (e.g., “PAC se”, “Butter fat”, “Total Cost”)
  • Display Value: Human-readable value with units (e.g., “185.23”, “8.5 %”, “$12.45”)
  • Numeric Value: Raw number for calculations (e.g., 185.23, 8.5, 12.45)
  • Description: What the property represents

How Calculations Work

Ice Cream Calc uses a two-base calculation system to handle different types of ingredients correctly:

1. Mix Base – Ice Cream Science

  • Uses only regular mix ingredients (excludes add-ins)
  • Calculates: PAC, POD, HF, freezing curves, serving temperatures
  • Why: Ice cream science properties depend on the base mix, not chocolate chips or cookie pieces
  • Calculates: Energy, protein, fats, vitamins, minerals
  • Note: Inclusions (physical add-ins) do not affect nutrition calculations. However the Nutrient label page does include Inclusions.

3. Cost Base – All Ingredients

  • Includes regular ingredients + inclusions + infusions
  • Calculates: Total cost, cost per liter, cost per kg
  • Why: Even strained ingredients (infusions) cost money

Understanding Add-Ins

Ice Cream Calc handles two types of add-ins differently:

Inclusions (Physical add-ins like chocolate chips):

  • Marked with “Inclusion” checkbox in recipe editor
  • Included in volume and weight calculations
  • Example: 100g chocolate chips adds to final ice cream volume

Infusions (Strained ingredients like vanilla beans):

  • Marked with “Infusion” checkbox in recipe editor
  • NOT included in final volume/weight (they’re strained out)
  • Still included in cost calculations

3. Categories of Calculated Properties

The Data Viewer automatically organizes properties into logical categories. Here’s a comprehensive guide to all calculated properties:

Understanding Property Suffixes

Many properties come in three variants to help you analyze composition from different perspectives:

  • [Property] – Percentage of total weight (e.g., “Total fat” = 8.5%)
    • Most common view for recipe formulation
    • What you see on nutrition labels
  • [Property]/Water – Percentage of water phase only (e.g., “Total fat/Water” = 14.2%)
    • Critical for understanding solute concentrations
    • Affects freezing point depression and ice crystal formation
    • Example: Lactose/Water shows risk of crystallization (max ~9%)
  • [Property]/TS – Percentage of total solids (e.g., “Total fat/TS” = 68.0%)
    • Shows dry matter composition independent of water content
    • Essential for comparing recipes with different evaporation levels
    • Example: Two recipes with 8% and 10% fat might both have 68% fat/TS
    • Particularly useful when adjusting total weight while maintaining balance

Why /TS matters: When you change evaporation or total weight, the regular percentages change but /TS ratios stay constant if the solid balance is maintained. This helps you understand whether changes affect true composition or just dilution.

Basic Weight and Volume Properties

Weight Properties:

  • Weight: Total weight of mix ingredients (excludes add-ins), in grams
  • Final weight: Weight after evaporation, in grams
  • Final water: Water content after evaporation, in grams
  • Evaporation: Amount of evaporated water, in grams
  • Evaporation %: Percentage of water evaporated

Volume Properties:

  • Mix volume: Volume of liquid mix before churning, in liters
  • Ice cream volume: Final volume including overrun and inclusions, in liters
  • Ice Cream Weight per Liter: Density including inclusions, in g/L

Water Properties:

  • Water: Percentage of water in mix after evaporation

Ice Cream Science Properties

PAC (Freezing Point Depression):

PAC is the single most important property for ice cream formulation because it directly controls:

  • How hard or soft your ice cream will be at serving temperature
  • The percentage of water that freezes vs remains liquid
  • The scoopability and mouthfeel
  • The melting rate and texture perception

Unlike other properties that affect quality or cost, PAC fundamentally determines whether your ice cream is even usable – too low PAC creates rock-hard ice cream that’s impossible to scoop, while too high PAC creates a soft, slushy texture that melts immediately.

How PAC connects to balancing:

PAC doesn’t work alone – it’s used to calculate the freezing curve, which shows how much water is frozen at each temperature. From this curve, the system calculates your Serving Temperature (the temperature where the target percentage of water is frozen – typically 75% for hard-scoop ice cream, 69% for gelato).

This is why modern balancing targets Serving Temperature rather than PAC directly:

  • Serving temp is what you actually experience when scooping
  • It accounts for PAC, HF (hardening factor), salt, and MSNF minerals
  • Target: typically -13°C to -16°C for hard-scoop ice cream
  • You balance to achieve your desired serving temp, which automatically adjusts PAC accordingly

The workflow: Adjust ingredients → PAC changes → Freezing curve recalculates → Serving temp updates → Check if serving temp is in your target range.

  • PAC se: The primary freezing point depression factor, measured per 100g mix
    • Determines how much ice forms vs remains liquid at serving temperature
    • Higher PAC = softer ice cream (more unfrozen water)
    • Dominated by sugars and salt – small molecules have highest effect
    • Name origin: “Potere Anti-Congelante” (Italian: anti-freezing power)
  • PAC normalized: PAC relative to water content
    • Accounts for different water levels due to total solids content
    • More accurate predictor of actual freezing behavior
  • PACtot: Total PAC including salt contribution
    • Salt has extremely high PAC value (~585 vs 100 for sucrose)
    • Even small amounts of salt significantly affect freezing
    • Used in freezing curve calculations
  • PACtot normalized: Total PAC normalized to water
    • Most accurate metric for predicting texture
    • Accounts for both sugar/salt levels AND water content

Sweetness:

POD (Potere Dolcificante – “Sweetening Power”) measures relative sweetness compared to sucrose (baseline = 100).

By using different sugars we can balance both sweetness and hardness independently.

Since PAC and POD don’t correlate perfectly, you can adjust texture without changing sweetness. For example, replacing sucrose (PAC 100, POD 100) with glucose (PAC 190, POD 77) makes ice cream softer but less sweet – then add a touch of fructose (POD 170) to restore sweetness without affecting texture much. This is why professional formulations typically use 2-3 different sugar types for independent control.

  • POD: Potere Dolcificante – relative sweetness vs sucrose (100 = sucrose baseline)
    • Different sugars have dramatically different sweetness
    • Fructose ≈170, Glucose ≈77, Lactose ≈16
    • Essential for sugar substitution while maintaining sweetness
    • Lower POD recipes taste less sweet despite same sugar percentage

Hardening Factor:

HF or Hardening Factor measures how much an ingredient makes ice cream firmer/harder at serving temperature. It’s essentially a “negative PAC” – while PAC softens ice cream, HF hardens it. Mainly from cocoa solids, cocoa butter, and nut fats.

Freezing Point:

  • Freezing point: Initial freezing temperature of the mix (°C and °F)
    • Pure water freezes at 0°C, ice cream mix at -2°C to -4°C typically
    • Lower freezing point = more scoopable (but also slower to freeze)
    • Affected by PAC, salt, and MSNF minerals

Temperature Data:

  • Serving temp: Optimal scooping temperature for hard-scoop ice cream
    • Calculated at 75% frozen water (configurable in settings)
    • Balance between scoopability and melting rate
    • Typically -13°C to -16°C
    • Too cold = difficult to scoop, too warm = melts too fast
  • Serving temp gelato: Optimal temperature for paddle/spatula-style gelato
    • Calculated at 69% frozen water (softer than hard-scoop)
    • Typically -10°C to -13°C
    • Warmer serving = smoother mouthfeel, more immediate flavor release
  • Extraction temp: Temperature for safe extraction from batch freezer
    • Calculated at 55% frozen water
    • Mix is firm enough to hold shape but soft enough to extract
    • Typically -8°C to -11°C
  • FW08 through FW16: Frozen water percentage at specific storage temperatures
    • FW13 and FW16 most commonly referenced (home freezer range)
    • Higher frozen water % = harder texture at that temperature
    • Affected by PAC, HF, and salt content
    • Example: FW13 = 65% means 65% of water is frozen at -13°C

Coldness Perception:

  • Coldness: Sensory perception of cold intensity (50 = typical benchmark)
    • Combines ice crystal content, fat level, and serving temperature
    • Higher values = more intensely cold sensation
    • Affected by: frozen water %, fat content, overrun, serving temp
    • Not the same as temperature – accounts for thermal buffering from fat
  • Coldness Gelato: Same metric calibrated for gelato serving temperature

User Settings (Display Only)

These show your current settings that affect calculations:

  • % Serving temp: Frozen water % used for serving temp calculation (typically 75%)
  • % Gelato serving temp: Frozen water % for gelato (typically 69%)
  • % Extraction FW: Frozen water % for extraction temp (typically 55%)
  • Overrun: Global overrun percentage setting
  • Density: Mix density in g/mL

Fat Properties

Fats are critical for ice cream texture, mouthfeel, and flavor delivery. Each fat property has three views: percentage of total weight, percentage of water phase, and percentage of total solids.

Total Fat Classification:

  • Total fat (and /Water, /TS): All lipids in the recipe
    • Target range: 10-16% for premium ice cream, 6-10% for standard
    • Provides creaminess, slows melting, carries fat-soluble flavors
    • Too high (>18%): buttery texture, coats palate
    • Too low (<6%): icy, lacks richness

Fat Source Breakdown:

  • Milk fat (and /Water, /TS): Fat from dairy sources (cream, milk, butter)
    • Traditional ice cream uses 100% milk fat (10-16% total)
    • Complex fatty acid profile gives characteristic dairy flavor
    • Crystallization behavior affects texture development during aging
  • Cacao fat (and /Water, /TS): Cocoa butter from chocolate
    • Sharp melting point at body temperature (33-34°C)
    • Contributes to HF – makes ice cream firmer
    • Different crystal forms affect texture (tempering matters)
  • Other fat (and /Water, /TS): Non-dairy, non-cocoa fats
    • Calculated: Total fat – Milk fat – Cacao fat
    • Includes: nut oils, egg yolk fat, vegetable oils
    • Each has unique melting profile affecting mouthfeel

Fatty Acid Composition:

  • Saturated fat (and /Water, /TS): Saturated fatty acids
    • Solid at room temperature
    • Higher in milk fat (~65%) and cocoa butter (~60%)
    • Affects firmness and scoopability
  • Unsaturated fat (and /Water, /TS): Mono- and polyunsaturated fatty acids
    • Liquid at room temperature
    • Higher in vegetable oils and nut fats
    • More prone to oxidation (rancidity) during storage
  • Trans fat (and /Water, /TS): Trans fatty acids
    • Naturally occurring (small amounts in dairy) or industrial
    • Usually near zero in modern ice cream

Fat Ratios:

  • Butter fat: Duplicate of Milk fat percentage (traditional terminology)
  • Saturated/Unsaturated: Ratio showing fat saturation level
    • Milk fat: ~180% (65% saturated / 35% unsaturated)
    • Olive oil: ~15% (mostly unsaturated)
    • Higher ratio = firmer at serving temperature
  • Fat/Protein: Critical ratio for emulsion stability and texture
    • Typical ice cream: 2.5-4.0 (10% fat / 3.5% protein)
    • Too high: risk of butter formation during churning
    • Too low: excessive protein network, can be chewy
    • Protein stabilizes fat globules and air cells
  • Emulsifiers/Fat: Emulsifier effectiveness (should be 0.2-0.5% of fat)
    • Mono-diglycerides reduce fat globule size
    • Improves air incorporation and distribution
    • Too much: dry texture from over-destabilization
    • Too little: large fat globules, poor overrun

Sugar Properties

Sugars are the primary tool for controlling freezing point and sweetness. All sugar properties come in three variants: /Weight, /Water, and /TS.

Sugar Classification:

  • Total sugars (and /Water, /TS): All mono- and disaccharides
    • Includes: sucrose, glucose, fructose, lactose, maltose
    • Target range: 12-20% for balanced ice cream
    • Lower limit: ice cream too icy/hard
    • Upper limit: too sweet, may not freeze firm enough
    • Primary contributor to PAC
  • Added sugars (and /Water, /TS): Sugars added during processing
    • Excludes natural sugars like lactose from milk
    • Required on US nutrition labels since 2020
    • Calculated: Total sugars – Lactose (from dairy)
  • Sugar (and /Water, /TS): Total sugars excluding lactose
    • Useful for tracking “added sweetness” separately from dairy sugars
    • Lactose contributes to PAC but minimal sweetness (POD ≈16)
    • Example: 15% Total sugars with 5% lactose = 10% Sugar
  • Lactose (and /Water, /TS): Milk sugar specifically
    • Natural sugar from dairy ingredients
    • Weak sweetness (POD = 16 vs 100 for sucrose)
    • Normal PAC contribution (100, same as sucrose)
    • CRITICAL: Lactose/Water > 9% = crystallization risk (sandy texture)
    • Typical ice cream: 4-6% lactose
  • Polyols (and /Water, /TS): Sugar alcohols
    • Maltitol, sorbitol, erythritol, xylitol, isomalt
    • Lower PAC than equivalent sugars (softer at same sweetness)
    • Variable sweetness (POD 25-90 depending on type)
    • May cause digestive issues at high levels
    • Used in sugar-free/reduced-sugar formulations

Sugar Concentration:

  • Lactose concentration: Lactose in water phase specifically
    • Most important metric for predicting lactose crystallization
    • Maximum safe concentration: ~9% of water
    • Formula: (Lactose weight / Water weight) × 100
    • Above 9%: risk of sandy texture after hardening/storage
    • Solution: reduce dairy powders, use lactose-free dairy

Solids Properties

Understanding solids composition is fundamental to ice cream structure and texture.

Total Solids:

  • Total solids (and /Water, /TS): All non-water, non-alcohol components
    • Target range: 36-42% for premium ice cream
    • Higher solids = richer mouthfeel, slower melting
    • Too high (>44%): heavy, cloying, expensive
    • Too low (<32%): watery, icy, poor body
    • Formula: 100 – Water – Alcohol
  • Other solids (and /Water, /TS): Unclassified dry matter
    • Calculated: Total Solids – Fat – Sugars – Protein – Stabilizers – Salt
    • Includes: ash (minerals), minor carbohydrates, fiber
    • Usually 1-3% of total weight
    • Higher in fruit purees (pectin, fiber) and dairy (minerals)
  • Cocoa solids (and /Water, /TS): Dry cocoa particles from chocolate
    • Strong chocolate flavor carrier
    • Major contributor to HF (coefficient 1.8)
    • Absorbs water, reducing available water for ice formation
    • 70% chocolate typically has 31% cocoa solids

Milk Solids Classification:

  • MSNF (and /Water, /TS): Milk Solids Not Fat
    • Traditional ice cream balancing parameter
    • Formula: Lactose + Protein + Milk Minerals
    • Typical composition: ~54% lactose, ~36% protein, ~10% minerals
    • Target range: 9-12% for standard ice cream
    • Too high (>13%): sandy texture risk from lactose
    • Too low (<8%): weak body, lacks dairy character
  • Milk solids not fat (and /Water, /TS): Alternative name for MSNF
  • Milk solids (and /Water, /TS): Total solids from milk
    • Formula: MSNF + Milk Fat
    • Represents complete milk contribution to dry matter
    • Example: Whole milk has 12.5% milk solids (9.25% MSNF + 3.25% fat)

Non-Fat Solids:

  • TSNF (and /Water, /TS): Total Solids Not Fat
    • Formula: Total Solids – Total Fat
    • Alternative balancing approach (instead of MSNF + fat separately)
    • Includes sugars, proteins, stabilizers, minerals
    • Typical range: 24-28%
  • Total solids not fat (and /Water, /TS): Alternative name for TSNF
  • TSNFS (and /Water, /TS): Total Solids Not Fat or Sugar
    • Formula: Total Solids – Fat – Total Sugars
    • The “structural” dry matter: proteins, stabilizers, minerals, fiber
    • Critical for body and mouthfeel independent of fat and sugar
    • Typical range: 8-12%
    • Lower values: light, refreshing (sorbet-like)
    • Higher values: heavy, rich (dense gelato-style)

Protein and Carbohydrates

Protein:

  • Protein (and /Water, /TS): Total protein content
  • Energy from Protein: Energy from protein in kcal per 100g

Carbohydrates:

  • Carbohydrates (and /Water, /TS): Total carbohydrates (US definition – includes fiber)
  • Carbohydrates (EU) (and /Water, /TS): EU definition (excludes fiber)
  • Fiber (and /Water, /TS): Dietary fiber
  • Other carbs (and /Water, /TS): Carbohydrates not classified as sugars or fiber

Nutrition Data

Energy:

  • Calories/SS: Calories per serving size (kcal)
  • Energy/100g: Energy per 100g (kcal)
  • EnergyKj/100g: Energy per 100g (kJ)
  • Energy from Protein: Protein contribution to energy

Other Nutrients:

  • Cholesterol (and /Water, /TS): Cholesterol content

Minerals and Additives

Minerals:

  • Salt (and /Water, /TS): Total salt content
  • Sodium (and /Water, /TS): Elemental sodium
  • Calcium (and /Water, /TS): Calcium content
  • Iron (and /Water, /TS): Iron content
  • Potassium (and /Water, /TS): Potassium content
  • Vitamin D (and /Water, /TS): Vitamin D content

Additives:

  • Stabilizers (and /Water, /TS): Stabilizing agents (gums, starches)
  • Emulsifiers (and /Water, /TS): Emulsifying agents (lecithin, mono-diglycerides)

Alcohol Properties

  • Alcohol (and /Water, /TS): Alcohol content by weight
  • Alcohol vol%: Alcohol volume percentage

Ninja Creami Specific

  • Crumbly: Risk score for crumbly texture (0-100 scale)
    • <70: Good texture expected
    • 70-90: May need re-spin
    • 90: Add liquid after first spin (score based on PAC, fat, sugar, and polyol levels)

Cost Properties

  • Total Cost: Total recipe cost in your currency
  • Cost per Liter: Cost efficiency per liter of ice cream
  • Cost per Kg: Cost efficiency per kilogram of final product

Add-Ins Properties

Inclusions Summary:

  • AddIns_Weight: Total weight of inclusions (physical add-ins), in grams
  • AddIns_Density: Average density of inclusions, in g/mL
  • AddIns_Volume: Total volume of inclusions, in mL

Individual Ingredient Data

For each ingredient in your recipe, the system creates weight and percentage properties:

Regular Ingredients (Prefix: I_):

  • I_[IngredientName]: Weight in grams
  • I_[IngredientName]_P: Percentage of final weight

Add-ins (Prefix: A_):

  • A_[IngredientName]: Weight in grams (for inclusions and infusions)
  • A_[IngredientName]_P: Percentage of total final weight including inclusions

Example: If your recipe has “Heavy Cream” and “Chocolate Chips” (as inclusion):

  • I_Heavy Cream: 500.00 g
  • I_Heavy Cream_P: 33.33 %
  • A_Chocolate Chips: 100.00 g
  • A_Chocolate Chips_P: 6.25 %

4. Data Viewer Page Guide

Accessing the Data Viewer

From Recipe Editor:

  1. Open any recipe in the Recipe Editor
  2. Click the “View Data” button in the top toolbar
  3. Data Viewer opens with current recipe’s calculated values

Page Layout

Header Section:

  • Recipe name and description
  • “Back to Recipe” button (returns to previous page)

Search and Filter Controls (Desktop only):

  • Search box: Filter by property name, value, or description
  • Category dropdown: Filter by property category
  • Results counter: Shows filtered vs total properties

Data Properties Table:

  • Property Key: Technical name (always visible)
  • Display Name: User-friendly name (desktop only)
  • Value: Formatted value with units (always visible)
  • Numeric Value: Raw number (desktop only)
  • Description: Property explanation (desktop only)

Using Search and Filters

Search Examples:

  • Search “fat” → finds all fat-related properties
  • Search “8.5” → finds properties with that value
  • Search “serving” → finds serving temperature properties
  • Search “cost” → finds all cost-related properties

Category Filtering: Use the category dropdown to focus on specific property groups:

  • Fat Properties
  • Sugar Properties
  • Temperature Properties
  • Basic Properties
  • Other Properties

Combining Search and Filters:

  • Select “Fat Properties” category
  • Search “protein” → finds “Fat/Protein” ratio

5. Custom Formulas Feature

Custom formulas let you create your own calculated properties using existing recipe data. This is perfect for:

  • Custom ratios (e.g., specific fat-to-protein targets)
  • Percentage calculations
  • Cost analysis
  • Quality metrics
  • Any mathematical combination of recipe properties

Creating Your First Formula

Step 1: Open the Formula Dialog

  1. Scroll to “Custom Formulas” section (bottom of Data Viewer)
  2. Click “Create Formula” button
  3. Formula editor dialog opens

Step 2: Name Your Formula

  • Enter a descriptive name (e.g., “Fat Protein Ratio”)
  • Name must be unique (cannot conflict with existing properties)
  • Name cannot duplicate existing data item names

Step 3: Build Your Expression

Click “Add Data Item” to select properties from your recipe:

  • Opens property selector dialog
  • Shows all available data items with descriptions
  • Search to find specific properties
  • Click to add property reference to expression

Expression Syntax:

  • Use [Property Name] with square brackets to reference data
  • Use standard math operators: +, -, *, /, (, )
  • Example: 100*[Total fat]/[Protein]
  • Example: [PAC se]*1.5 + [POD]

Step 4: Set Formatting Options

Decimal Places:

  • Choose 0-4 decimal places
  • Default: 2 decimals
  • Example: 2 decimals shows “185.23”

Unit/Suffix:

  • Optional suffix for the value
  • Common suffixes: “%”, “g”, “ratio”, “°C”
  • Example: “%” shows result as “85.5%”

Step 5: Add Description (Optional)

  • Explain what your formula calculates
  • Helps you remember the purpose later
  • Shows in formula list and when hovering

Step 6: Test Your Formula

Click “Test Expression” to validate:

  • Success: Shows calculated result with your formatting
  • Error: Shows what went wrong (missing property, syntax error)
  • Calculation preview: Shows how values were substituted

Step 7: Save

  • Click “Create” to save the formula
  • Formula appears in list below
  • Formula automatically updates when recipe changes

Formula Examples

Example 1: Fat-to-Protein Ratio

Expression: 100*[Total fat]/[Protein]
Decimals: 2
Suffix: (leave empty or "ratio")
Description: Fat to protein ratio as percentage

Example 2: Custom Sweetness Target

Expression: [POD] - 180
Decimals: 1
Suffix: (deviation)
Description: How far POD is from my target of 180

Example 3: Cost per Serving

Expression: [Total Cost]/8
Decimals: 2
Suffix: $ per serving
Description: Cost divided by 8 servings

Example 4: Adjusted PAC for High Fat

Expression: [PAC se]*[Total fat]*0.1
Decimals: 2
Suffix: (empty)
Description: PAC weighted by fat content

Example 5: Temperature Difference

Expression: [Serving temp] - [Extraction temp]
Decimals: 1
Suffix: °C
Description: Temperature rise from extraction to serving

Editing and Managing Formulas

Edit Formula:

  1. Click the Edit icon (pencil) next to formula
  2. Make your changes in the dialog
  3. Test the updated expression
  4. Click “Update” to save

Delete Formula:

  1. Click the Delete icon (trash can) next to formula
  2. Confirm deletion in dialog
  3. Formula is permanently removed

Formula List Display:

Desktop View:

  • Name, Expression, Current Value, Description, Actions columns
  • All information visible at once

Understanding Formula Errors

Common Error Messages:

“Property not found: [PropertyName]”

  • You referenced a property that doesn’t exist
  • Check spelling of property name
  • Use “Add Data Item” to ensure correct names

“Invalid expression syntax”

  • Mathematical syntax error
  • Common issues: mismatched parentheses, invalid operators
  • Example bad syntax: [Total fat]*/[Protein] (extra asterisk)

“Division by zero”

  • Your formula divides by a property that has zero value
  • Add protection: [Value A]/([Value B]+0.001)

“Name conflicts with existing data item”

  • Your formula name matches an existing property
  • Choose a different, unique name

“A formula with this name already exists”

  • You already have a formula with this name
  • Edit the existing formula or choose a new name

6. Using Data in Other Features

The recipe calculation system powers many other features in Ice Cream Calc:

Recipe Balancing

Chart Targeting

  • Charts use calculated data to show recipe positioning
  • Properties like PAC and POD plotted on chart ranges
  • Learn more about charts →

Recipe Cards

  • Info chips pull from calculated data
  • Nutrition facts use energy and macro calculations
  • Custom formulas can appear on recipe cards

7. Tips & Best Practices

Finding Properties Efficiently

Use Search for Known Terms:

  • Know you want fat data? Search “fat”
  • Need temperature info? Search “temp”
  • Looking for costs? Search “cost”

Use Categories for Exploration:

  • Not sure what’s available? Browse by category
  • Categories group related properties logically

Look at Descriptions:

  • Desktop view shows full descriptions
  • Helps understand what each property means
  • Important for choosing formula data sources

Understanding Property Names

Properties with “/Water”:

  • Shows value as percentage of water only
  • Example: “Lactose/Water” = lactose in water phase
  • Useful for concentration calculations

Properties with “/TS”:

  • Shows value as percentage of total solids
  • Example: “Protein/TS” = protein in solid phase
  • Useful for composition analysis

Properties with Prefixes:

  • “I_” = Individual ingredient (mix)
  • “A_” = Add-in ingredient (inclusion/infusion)
  • “_P” suffix = Percentage of total

Creating Effective Formulas

Start Simple:

  • Test basic formulas first
  • Build complexity gradually
  • Verify each step works

Use Descriptive Names:

  • “My Custom Ratio” is better than “Formula1”
  • Future you will thank present you
  • Easier to share formulas with others

Document Your Formulas:

  • Use the description field
  • Explain the logic behind complex calculations
  • Note any assumptions or targets

Test with Different Recipes:

  • Formulas should work across recipes
  • Some formulas may fail if certain ingredients are zero
  • Add protection for division by zero

Organize by Purpose:

  • Group related formulas conceptually
  • Name formulas consistently
  • Consider prefixes: “Cost: Per Serving”, “Ratio: Fat to Protein”

8. Troubleshooting

“No Recipe Available” Warning

Problem: Data Viewer shows warning that no recipe is available

Causes:

  • You navigated directly to /data-items/view without an active recipe
  • Your recipe session expired
  • No recipes exist in your account yet

Solutions:

  1. Open any recipe from the Recipes page
  2. Edit a recipe to create a temporary working copy
  3. Create a new recipe if you don’t have any
  4. Click “Back to Recipe” to return to recipe editor

Formula Evaluation Errors

Problem: Formula shows “ERROR” instead of a calculated value

Common Causes:

  1. Property doesn’t exist in current recipe
    • Solution: Check property name spelling
    • Solution: Use “Add Data Item” to insert correct names
  2. Division by zero
    • Solution: Add small constant to denominator: [A]/([B]+0.001)
    • Solution: Check if denominator property can be zero
  3. Invalid mathematical syntax
    • Solution: Check parentheses match
    • Solution: Verify operators are correct
    • Solution: Use Test Expression to get detailed error
  4. Circular reference
    • Solution: Formula cannot reference itself
    • Solution: Formula cannot reference other formulas (currently)

Debugging Steps:

  1. Click “Test Expression” to see detailed error
  2. Simplify formula to isolate problem
  3. Test individual property references
  4. Build formula back up piece by piece

Missing or Unexpected Values

Problem: Expected property not showing in list

Possible Reasons:

  1. Search filter too restrictive
    • Clear search box and category filter
    • Browse full unfiltered list

Problem: Property shows unexpected value

Check These Factors:

  1. Evaporation setting
    • Affects final weight and concentrations
    • Check evaporation percentage in recipe
  2. Add-ins configuration
    • Inclusions vs infusions behave differently
    • Verify ingredient checkboxes in recipe editor
  3. User settings
    • Overrun percentage affects volume calculations
    • Serving temperature settings affect temp calculations
    • Check Settings page for your current values
  4. Recent recipe changes
    • Data updates when recipe is recalculated
    • Edit recipe to trigger recalculation

9. Related Topics

10. Summary

The Recipe Data Calculation System is the computational heart of Ice Cream Calc, providing:

✅ Comprehensive calculations – Hundreds of properties covering ice cream science, nutrition, and costs

✅ Smart ingredient handling – Correctly processes regular ingredients, inclusions, and infusions

✅ Data Viewer interface – Easy access to all calculated properties with search and filtering

✅ Custom formulas – Create your own calculations for specific needs

✅ Integration everywhere – Powers balancing, charts, recipe cards, and production features

Key Takeaways:

  • Every recipe generates calculated data automatically
  • Three-base system handles different ingredient types correctly
  • Data Viewer is your window into recipe calculations
  • Custom formulas extend functionality with your own metrics
  • Calculated data powers all major Ice Cream Calc features

Next Steps:

  1. Open a recipe and explore the Data Viewer
  2. Search for properties relevant to your needs
  3. Create your first custom formula
  4. Use calculated data with balancing and charts

Last updated: [Date] Article version: 1.0