Calculations formulas

Cancelled Posted Oct 9, 2005 Paid on delivery
Cancelled Paid on delivery

I have many columns of numbers in an Excel spreadsheet. You can see the attached example. As you can see there are 6 columns of numbers separated by an empty column and then 3 more columns. Those 3 columns are a direct result of the first 6.

I want a script that will be based on mathematical formulas to simply find the relationship between the 2. If you have an engineering background or have knowledge of engineering software this should be easy for you, and you can do it in no time.

The script should be able to go through the many rows of numbers and come up with a formula that will match the two sides. Once that is done, if I give a set of numbers, the script should be able to predict, based on the formula it has come up with, the second set of numbers. That is it. Very simple!!!

Visual Basic

Project ID: #29082

About the project

18 proposals Remote project Active Oct 18, 2005