Math Problem

[erice1984]

I need to figure out how to convert the non-linear AD Value to something more linear as far as the conversion goes.

I figured out by reading a little on NTC thermistors, with the little data I have, I came up with resistance values that I believe are accurate within 1ohm

Anyways, here is a link to the spreadsheet
www.drivearu.com/Electronics/ntc%20thermistor.xls

I am stumped!

[erice1984]

Ah, forgot that it needs to be the temperature range 100-250 degrees F

When o I get the ability to edit my posts?

[rsocor01]

Erice1984,

You can do a linear approximation but you are going to loose accuracy. Try doing a polynomial or exponential approximation. In EXCEL go to help and see how to add a trendline (it varies with the different versions of EXCEL). Obtaining the trendline is very simple. The trendline is going to give you a formula in the form of Y(X), X being the temperature and Y being the Resistance. Try with different options and settings until you get a good approximation. Then, you can use the resulting formula in your PBP program. That is with any value X (temperature) you can calculate a value Y (resistance).

You should get the whole temperature range 100-250 degrees F in your graph before doing an approximation, so you get better results.

This is one way to do it, which is very accurate. It all depends on the accuracy that you want for the resistance reading.

Hope that this helps.

Robert

[erice1984]

Thank you very much!

Wow, that was really easy!

I lost accuracy but its in the place I don't care about!

[mister_e]

I already used the following with good results.

Curve Expert
http://userpages.xfoneusa.net/~dhyams/cmain.htm

[erice1984]

It all works, just wondering how I will try to make exponents happen..

[mister_e]

What's your current formula?

A third degree polynomial didn't fit?

[erice1984]

f(x) = 5167.68(0.98^x)