Results 1 to 7 of 7

Thread: Excel Spreadsheet for Sensors

  1. #1
    Newbie
    Join Date
    Aug 2008
    Location
    Decatur Illinois
    Posts
    41

    Excel Spreadsheet for Sensors

    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.

  2. #2
    Constant Bitrate
    Join Date
    Jun 2008
    Location
    Georgia, USA
    Posts
    188
    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.
    Attached Images Attached Images  
    Thanks,

    Dan

  3. #3
    Newbie
    Join Date
    Aug 2008
    Location
    Decatur Illinois
    Posts
    41

    Spreadsheet attached

    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.
    Attached Files Attached Files

  4. #4
    Constant Bitrate
    Join Date
    Jun 2008
    Location
    Georgia, USA
    Posts
    188
    Ummm...you passworded the zip file Fred.
    Thanks,

    Dan

  5. #5
    Newbie
    Join Date
    Aug 2008
    Location
    Decatur Illinois
    Posts
    41

    Excel Spreadsheet

    Geeze you think I could get this right. Here is is again. Sorry!

  6. #6
    Newbie
    Join Date
    Aug 2008
    Location
    Decatur Illinois
    Posts
    41

    Try again

    I need to go back to my Comodore 64 and start over.
    Attached Files Attached Files

  7. #7
    Constant Bitrate
    Join Date
    Jun 2008
    Location
    Georgia, USA
    Posts
    188
    WooHoooo!!! Ya got it that time!

    I haven't looked at it in depth but it looks good from my quick glance.
    Thanks,

    Dan

Similar Threads

  1. Replies: 5
    Last Post: 05-12-2009, 03:35 PM
  2. Excel Shortcuts not working
    By Chaky in forum Software & Software Development
    Replies: 2
    Last Post: 02-01-2008, 01:38 PM
  3. Replies: 3
    Last Post: 12-02-2007, 11:28 PM
  4. ProScan excel spreadsheet data reformat
    By RacerRex in forum Engine Management, OBD-II, Engine Diagnostics, etc.
    Replies: 0
    Last Post: 04-13-2007, 03:49 AM
  5. Excel 2000 password recovery
    By wizardPC in forum Off Topic
    Replies: 2
    Last Post: 03-07-2005, 03:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •