Wednesday, April 29, 2020

Using Google Sheets to Check the Fit


    Since I was limited to the use my mobile phone I installed Google Sheets to do some simple calculations. Below is a check on the fit for the cooling temperature data and constants given in the last two blogs. Just below constants are three lines that show the formulas for the indicated cells.
This fit shows a slight improvement over the original fit due to a change in the interval used to fit the thermistor temperature curve as indicated by the cell containing the rms error. The rounded values for the temperatures may have also affected the fit.




No comments: