PDA

View Full Version : Data Interpolation



SilverBack
05-03-2006, 04:35 PM
Hey all,

I'm working on a data interpolation program for low altitude satellites and r/c aircraft. I've got everything figured out (I think) except how to get the program to figure out which values to to use for the interpolation formula.

I've included an attachment of what I have so far.

The idea is to run the form, input two values (one is a timer setting in seconds, the other is an image count that the operator has to get from the camera), click execute, select the file to work on, and it does its thing by converting data and putting it on sheets 1 and 2 on the parent file. Everything seems to work correctly up to the point where I have to get the interpolation formula to run.

The purpose of the interpolation process is to compute the altitudes where each picture was taken.

mckdillop helped me a few months back with a similar program, but I thought i'd make a userform so I could interpolate more files more quickly.

Thanks for the help!

John