Skip to main content
HomeCornell Maple Calculators

Cornell Maple Calculators

Calculators and other Tools

 

Mobile Phone Instructions: Scroll to the right and left to view the entire calculator.

Double tap the yellow cells to type in your data. You may need to wait a moment for the calculator to load on your screen.

Scroll all the way to the right to download the spreadsheet to your device.

 

Download Instructions: Select the icon pictured below.

This download button is located at the bottom right corner of each calculator.

 

Jump To the tool you are looking for:

 

 
 

Grade Blending Calculator (light transmittance)

Get the grade you want by entering the light transmittance % of the two syrups you wish to blend.

You will need to know the transmittance % of a 50/50 blend of your two syrups before you begin. Mix thoroughly a small sample of equal parts lighter and darker syrup, wait for the bubbles to dissipate, and check the transmittance with your Hanna Meter.

If you are using mobile phone, double tap the yellow cells to type.

 
 

Density Blending Calculator

Get your syrup to proper density by entering the °brix of the two syrups you wish to blend, and your desired outcome.
You may also use this calculator to blend with sap or water. Just enter the brix for sap or water in the “Density of lower brix syrup” cell.
For water, enter zero.
Any unit of volume (cups, liters) is ok to use, as long as all units are the same. For this example, we used gallons.

If you are using mobile phone, double tap the yellow cells to type.

 
 

Dilution Calculator

Determine the amount of water (or permeate) needed to dilute your syrup to your desired density. This can be used to get off-density syrup in grade, to dilute syrup to an appropriate density for fermentations, or for other projects such as value-added product development.
Any unit of volume (cups, liters) is ok to use, as long as all units are the same. For this example, we used gallons.
This calculator is only appropriate for dilution using water. For diluting with sap, use the “Density Blending Calculator” above.

If you are using mobile phone, double tap the yellow cells to type.

 
 

Invert Blending Calculator

Adjust your syrup to the optimal invert sugar level for confection making. Enter the % invert of the two syrups you wish to blend, and your desired invert level outcome. This calculator is intended for blending two syrups that are close to finished syrup density.
You should always measure the invert on your finished syrup blend before using for confections.

If you are using mobile phone, double tap the yellow cells to type.

 

 

Welcome to the Maple Products Pricing Guide

These worksheets are brought to you by Michael Farrell and Chelsea Green Publishing as supplementary material for The Sugarmaker’s Companion: An integrated guide to producing syrup from maple, birch, and walnut trees.

This Excel file contains pricing guides for bottling syrup and creating other value-added maple products. Simply click on the worksheet tab for the product you would like to use. Scroll to the right to view more products.

This Excel file accompanies Chapter 11 Where the Money Is: Marketing Your Pure Maple Products

If you havent already read this chapter, doing so will greatly improve your ability to utilize these spreadsheets.

Download the Workbook:

 
 

Maple Syrup Retail Pricing Calculator

 
 

Syrup Retail and Wholesale Calculator

Scroll to the Right to see all of the results of your calculations

 
 

Maple Candy Pricing

 
 

Maple Cream Pricing

 
 

Maple Granulated Sugar Pricing

 
 

Maple Cotton Candy Pricing

 
 

Maple Soda Pricing

 

 

Cost of Maple Tubing Installation – updated 2023 prices

 

 

Costs and Returns with Vacuum Systems

 

 

Welcome to the Cornell Sap Buying Spreadsheets

You may download the entire workbook below, or scroll down to use the calculators directly on this webpage:

This Excel file is intended to help sugarmakers who want to expand their operations by purchasing sap from nearby landowners.
There are several worksheets within the downloadable Excel file. In order to see them all, you need to click through the sheets with the arrows on the bottom left. Otherwise, for use on this website, they are all laid out separately.
A brief description of each worksheet is as follows:

Sap Pricing Table
This is the basic table that displays the price of a gallon of sap. The variables include: sap sugar concentration, bulk syrup prices, and percentage of bulk syrup revenues provided to the sap seller.

Advanced Sap Pricing Table
This is an advanced version of the sap pricing table in which users can adjust the percentage of bulk syrup revenue given to the sap seller according to how sweet the sap is. This table is especially useful for smaller-scale sugarmakers who don’t have efficient evaporators and reverse osmosis units.

Simple Hourly Wage Calculator
This is a basic tool to give you a broad overview of if it will be economically feasible for you to purchase sap. It provides a rough estimate of the net profit per hour your sugaring operation could produce by purchasing and processing sap.

Advanced Hourly Wage Calculator
This is a more advanced version of the simple calculator that takes into account other costs such as sap and syrup filtering, sap and syrup storage, and depreciation on your reverse osmosis and evaporator.

Blank Worksheet
This worksheet allows you to keep track of sap payments over the course of a season for each individual that you are buying sap from.

Internal Sap Value Calculator
This worksheet allows you to determine what a gallon of sap is worth to your sugaring operation using many of the same parameters that help you determine the profitability of buying sap.

 
 

Sap Pricing Table

Read first:
The following table presents suggested prices per gallon of sap for a maple producer to purchase sap from someone else. The variables that affect sap prices in this table are sap sugar content, bulk syrup price, and the percentage of bulk syrup price provided to the sap seller. The default value for cell G3 (“Percentage of Bulk Syrup Price Provided to Sap Seller”) is set at 50%, since that is a figure commonly used in the maple industry. However, if the percentage of bulk syrup price provided to the sap seller differs from 50%, users can change that value in the yellow highlighted cell below (mobile phones scroll right) and the sap prices will change accordingly.

Scroll to the right to see the entire spreadsheet.

 
 

Advanced Sap Pricing Table

Read first:
This advanced sap pricing table is designed to allow sugarmakers to pay a higher percentage for sweeter sap and a lower percentage for less sweet sap. This may be advantageous for producers who do not use reverse osmosis or efficient evaporators. Enter in the parameters in cells G3-5 highlighted in yellow in order to customize the revenue distribution. If you would like to see how the distribution changes based on the values entered in G3-5, scroll down to rows 49-80.

Scroll to the right and down to see the entire spreadsheet.

 
 

Hourly Wage Calculator for Processing Sap

Read first:
This simple calculator displays the “hourly wage rate” for processing additional sap purchased from someone else. Simply enter in the values for the cells highlighted in yellow. This is the amount of money a sugaring operation can expect to make per hour by purchasing and processing additional sap.
Note that this is the “simple hourly wage calculator”- it gives you a rough idea of how much money you can earn by buying sap, but it usually overestimates the actual value by about 10%. For a more accurate estimation of the profitability of buying sap, use the “hourly wage calculator advanced” worksheet.

 
 

Advanced Hourly Wage Calculator for Processing Sap

Read first:
This advanced calculator displays the amount of profit per hour for processing additional sap purchased from someone else. This is the amount of money a sugaring operation can expect to make per hour by purchasing and processing additional sap. Simply enter in the values for the cells highlighted in yellow and the spreadsheet will calculate the values in green for you.
For the columns that have superscripts at the end of the title, scroll down to determine the values for each of these items.

 
 

Blank Worksheet

Read first:
Sugarmakers can use this spreadsheet to keep track of sap deliveries and payments throughout the course of the sugaring season.
Users are responsible for entering in values for the cells highlighted in yellow. Once each row has values entered in each cell for columns B-E, the spreadsheet will calculate the values in columns E-J. Columns D and E contain drop down items. In Column D you choose the grade of syrup you are making. In Column E you choose whether the sap is delivered or picked up.
Additional information appears below the chart in reference to the subscripts indicated within the chart.
Be sure to scroll down to the very bottom to read more.

 
 

Internal Sap Value Calculator

Read first:
This calculator displays the value of an additional gallon of sap that you are able to collect from your maple trees. Simply enter in the values for the cells highlighted in yellow and the spreadsheet will calculate the values in green for you. For the columns that have superscripts at the end of the title, scroll down to determine the values for each of these items. Note that if the value of sap that you produce yourself is higher than the price you have to pay for sap that someone else collects, then it makes economic sense to purchase sap.

 

 

Maple Business Income Calculator

Download to Save an Income Statement for your records.

 

Icons made by Freepik from www.flaticon.com

© 2014 Cornell University

Skip to toolbar