ispindel/ubidots SG Temperature correction

I recently built an ispindel, and got it working in a lager. My fermentation schedule has a rise in temp before crashing, and the ispindel was basically jumping all over the place on the gravity reading. I've been doing a lot of research into how to correct for temperature, even found a formula for it, but I can't seem to phrase the formula in a way the Ubidots will calculate as a derived variable...

Anyone have the same issue, or any solutions? Or anyone just good enough at speaking computer math to tell me how to adjust the formula so it works?

Here is the formula I have found:


CG = corrected gravity
MG = measured gravity
TR = temperature at time of reading
TC = calibration temperature of hydrometer



CG = MG * ((1.00130346 – 0.000134722124 * TR + 0.00000204052596 * TR – 0.00000000232820948 * TR) / (1.00130346 – 0.000134722124 * TC + 0.00000204052596 * TC – 0.00000000232820948 * TC))

Source: https://straighttothepint.com/hydrometer-temperature-correction/

 

This totally works in Excel, but Ubidots for some reason won't let me sub out the cells for variables.... grrrr...

Thank you!

 

Ok, I think I got it.... turns out Ubidots really doesn't like spaces, and all the copied minus signs were jacking it up.. Will need to do further testing...

 

Thanks to the Excel formula I can double check my work pretty easily. For some reason even though I am reading in ºF the formula is working better with ºC for the calibration temp.