• 07-10-2009, 07:05 PM
FredWorrell
For those that may be interrested, I have developed an Excel spreadsheet to calculate the output of linear sensors. This is only for resistive sensors with a direct linear response. Example is a fuel level sensor, as fuel level goes up, the resistance goes up in a linear relationship. It is designed for the basic circuit, 5VDC to a fixed resister then to the sensor then to ground. You input the min and max resistance of the sensor, the min and max value the sensor will measure, (psig, or whatever) and the value of the series resister. It assumes the unit will be calibrated to read the min value at the min resistance and the the max value at the max resistance. You can then see where the output will be inaccurate. Note that unless a constant current source is used, the reading WILL be inaccurate. You really want the circuit to imitate a constant current source. To imitiate a constant current source the series resister should be as large as possible as compared to the max resistance of the sensor. I plan on using a series resister 5 times the value of the max resistance of my sensors.

You can try different resister values for your sensor and see just how the accuracy is effected. I even graphed the results.

The fields you should not mess with are locked (easly unlocked in excel). The colored cells are where you input your values. The spreadsheet has my last sensor loaded so you can see how I inputed my values. The fuel level sensor has 35 ohms with the tank empty (0%) and 240 ohms with the tank full (100%). A 1000 ohm series resister is used.

I don't know how to post the spreadsheet, so if anyone wants it just email me at [email protected]. The file is 18 Kb.
• 07-11-2009, 07:38 AM
Dan2008
Try zipping it before uploading it. If you meant that you don't know the procedure for uploading, click the paperclip then "Browse" for the file and click the "Upload" button.
• 07-11-2009, 09:28 AM
FredWorrell
Thanks Dan. I have never gone to the "advanced" reply section. Now you have shown me how to do it... Here is the spreadsheet zipped to 6k.
• 07-11-2009, 10:30 AM
Dan2008
Ummm...you passworded the zip file Fred.
• 07-11-2009, 11:34 AM
FredWorrell