jasonsargo
Well-Known Member
I can't find this answer with a search, and the thread I found just did not give me the exact answer I need...
I am using OpenOffice to piece together a basic spreadsheet to track my brews. I cannot, for the life of me, input the Tinseth formula for hop utilization into a field, even though the functions look the same as Excel. I have re-typed, tried symbols, rearranged parentheses, etc, and still spit up an error. I am at the limit of my understanding of math and Excel/OpenOffice.
Could someone just post a formula to cut and paste into a field for me?
By the way, here is my best effort:
=(1.65*0.000125exp(AVERAGE(H1;H3)))*((1-(2.72exp(-0.04*E24)))/4.14)
where the average of H1 and H3 are my initial and final boil gravities without the one and decimal, and E24 is my boil time field. I have tried just directly putting in 66 for my boil average, and 60 for the time. And the exp is actually displayed as ^ in my fields, but it came out exp when I copied it here.
Any help would be greatly appreciated.
I am using OpenOffice to piece together a basic spreadsheet to track my brews. I cannot, for the life of me, input the Tinseth formula for hop utilization into a field, even though the functions look the same as Excel. I have re-typed, tried symbols, rearranged parentheses, etc, and still spit up an error. I am at the limit of my understanding of math and Excel/OpenOffice.
Could someone just post a formula to cut and paste into a field for me?
By the way, here is my best effort:
=(1.65*0.000125exp(AVERAGE(H1;H3)))*((1-(2.72exp(-0.04*E24)))/4.14)
where the average of H1 and H3 are my initial and final boil gravities without the one and decimal, and E24 is my boil time field. I have tried just directly putting in 66 for my boil average, and 60 for the time. And the exp is actually displayed as ^ in my fields, but it came out exp when I copied it here.
Any help would be greatly appreciated.