• State Not Answered
  • Locked Locked
  • Replies 18 replies
  • Subscribers 21 subscribers
  • Views 3247 views
  • Users 0 members are here
2025 survey

We are running a survey to help us improve the experience for all of our members. If you see the survey appear, please take the time to tell us about your experience if you can.

Options
Related
How was your experience today?
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Assignments of measured values from a spreadsheet (excel. Csv, etc.)

Jonas Hobel

Hi, all.

I'm visiting a german technical school and we have do start a Project work in February. For the coarse advance planning I would like to have a Basic structure of the Programming with Keil µ-Vison. We already programmed some stuff with µ-Vision, but not deep enough

I would like to read the digitized value of a pressure sensor with a microcontroller, let the Software evaluate it, and show the pressure value on a Display.

so is it possible, to build a Table (like Excel, .csv, etc.) and let the programm compare the Value of the input Port from the microcontroller withe the values in the table and take appropriate pressure value.

Or is there another possibility, do assign the values, so that I can change the assignments quick and easy?

please excuse my bad english.

Thank you in advance!

Jonas

Parents
  • 0 in reply to Jon Ward

    Except that if the sensor is linear, you never use just the two endpoints to find the two constants (except as possibly a quick and dirty to see if the system is linear enough or if a piece-wise or higher-order approximation is needed). You use a number of measurements all over the line and then do a least-square match.

    Then you get a quality factor R telling how well a straight line matches the samples, i.e. informing if the sensor (or ADC) isn't really linear, or if one or more measures are incorrect. It also better compensates for noise in individual samples and irregularities in individual ADC steps.

Reply
  • 0 in reply to Jon Ward

    Except that if the sensor is linear, you never use just the two endpoints to find the two constants (except as possibly a quick and dirty to see if the system is linear enough or if a piece-wise or higher-order approximation is needed). You use a number of measurements all over the line and then do a least-square match.

    Then you get a quality factor R telling how well a straight line matches the samples, i.e. informing if the sensor (or ADC) isn't really linear, or if one or more measures are incorrect. It also better compensates for noise in individual samples and irregularities in individual ADC steps.

Children