Sugar Syrup Calculation (Excel spreadsheet)January 7, 2015 in Bee Health - Protection by jaycam Click here to access an Excel spreadsheet that will help calculate the amount of dry sugar to water to make a 2:1 sugar to water solution (65% sugar syrup) or the amount of water to add to dilute a 77% sugar syrup to a 67% sugar to water solution.