Syrup recipes
Syrup products used in the plant. Multiple finished beverages may share one syrup.
Download template
Import file format
Accepted formats, column layouts, and import behaviour
ShowHide
Import file format
Accepted formats, column layouts, and import behaviour
Upload .xlsx, .xls, or .csv files. Row 1 must be headers; data starts on row 2. Only the first worksheet is read.
Required column
Each row needs a syrup name. Accepted header names: Syrup, Name, Product, or Recipe. Rows without a name and summary rows (Total, Sum) are skipped.
Optional columns
Group, Required residence time (hours), Dilution ratio / Throw (e.g. 1+5), Sucrose granulated % w/w, Sugar kg/hL, Prep min, CIP min, Minimum batch size (litres of finished product), Number of units at minimum batch size, Batch increment, CIP required. Use the Group column for tank-sharing families — configure isolated groups on the Configuration page.
Syrup,Group,Required residence time (hours),Dilution ratio / Throw,Sucrose granulated % w/w,Sugar kg/hL,Prep min,CIP min,Minimum batch size (L finished product),Number of units at minimum batch size,Batch increment,CIP required Cola,Cola,0,1+5,62.1,80,45,45,30000,4,30000,yes Orange,Juice,0,1+6,55.7,70,60,60,30000,3,30000,yes PEPSI-Semi,Cola,24,1+5,55,70,45,45,30000,3,30000,yes
Import behaviour
Recipes are merged into the current project. Rows with a matching syrup name update that recipe; new names are added. Production demand and other project data are kept. Missing columns use default values — download the CSV or Excel template for the full column list. Throw notation (1+5, 1:5) and European number formats (e.g. 10.220,6118) are supported.
Active data set
No input data loaded
Upload a project or demand file, or enter data manually to begin analysis.
Syrup recipes
Product identity, sequencing group, and preparation parameters for each syrup.
Add a syrup to define products and recipe parameters.
Add at least one syrup before defining beverages.