A fun math problem

[Tom Gonser]

meters = 44330.769 * (1 - (Millibars / 1013.25) ^ 0.190262525939031)

This converts millibars in pressure to meters given a simple atmosphere. Since the PIC does not have FP, and this point REALLY floats, how can a PIC do this?

Or can it at all? If we were just dealing with .xxx, then you could x1000, but we are dealing with .xxxxxxxxxxxxx!! Do we just multiply by 100000000000 I don't think so.

The accuracy to 15 decimal places is needed because of the very small pressure movements inpact on estimated altitude.

Hmmm...

[mister_e]

My simple solution, do a spread sheet and store the results in a external EEPROM. Once it`s done just reading the results from the EEPROM.

YEAH i can heard some here It's just an idea not the only one.

[Tom Gonser]

Except that I need to do this every time I get a new MB reading which can be as fast as 100ms....

[mister_e]

and then??? reading from a eeprom is really much faster than this.

Once the spread sheet is created and loaded into the EEPROM, you just need to read the results from. The longer part of the job will be to produce the spread sheet and load it to the EEPROM.

But if you have some VB programming ability, that will make things easy. In VB you can create your own .BIN file with your own format. Once it's done, you have two(or more) choice:

• use your favourite EEPROM programer to dump the file to your EEPROM
• create a VB program to send data to your PIC, then from your PIC to your EEPROM

Personnaly, i'll prefer the second one if the hardware permit to do it.

[Tom Gonser]

OK.. I guess I am not tracking..

How does one load a VB program into a PIC? I was under the impression the only things that could execute on a PIC were compiled code from PBP or some such compiler. I'd be VERY interested to know how I could load other things into a PIC or EEPROM or whatever.

I have the spreadsheet (Attached) It is very simple. If it is easier I am sure I can make a .BIN file using VB..

Very curious...

[mister_e]

i wasn't clear enough sorry. What i figure is to do a VB program wich will do the the whole calculation for you with a specified range and increment of Millibar or Meter value. Once the calculation are done, this program will store all result in a .BIN file. Once the file is created and saved to your hard disk, you use your EEPROM programmer to load this .BIN file into an external EEPROM attach to your PIC.

After that, your PIC will just need to read the value of the calculation to your EEPROM by using the millibar variable as a kind of 'EEPROM address pointer'

For sure a PIC can't run a VB program. But you can do a VB program that will communicate to your PIC via the COM port.

what is the range of your millibar value?
How many decimal you want to have in the result???

If you need any info about VB let me know in PM.