Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
I have a massive project that I have to undertake in order to graduate my Science degree. I am required to process the B727 Manual into excel and have a flight plan sheet which should automatically select the right data and insert it into another worksheet. For instance: If I put in a height of 33000 feet, and the takeoff weight is 76000kgs, and the temperature is +10 above the standard temperature range, the climb fuel will be 2345kgs, and the time taken will be 23 mins. Or, If the height is 35000feet, and the takeoff weight is 74000kg at the standard temperature the climb fuel will be 2100kg at 19mins. None of the tables are linear or at any proportion so there won't be a y= mx + c equation to solve it. This is usually done manually, but I need a working excel table to automatically put in the data into another active worksheet. Can someone help me? Xavier |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inputbox type 64 (array) | Excel Discussion (Misc queries) | |||
other type values in array. | Excel Programming | |||
other type values in array. | Excel Programming | |||
Programming Array Formulas in VBA - Can they be intermediate results in RAM? | Excel Programming | |||
Array formulas into VB programming | Excel Programming |