PPRuNe Forums - View Single Post - Excel Formula
Thread: Excel Formula
View Single Post
Old 13th Mar 2013, 08:38
  #12 (permalink)  
MacBoero
 
Join Date: Jan 2008
Location: London, England
Age: 56
Posts: 300
Likes: 0
Received 0 Likes on 0 Posts
I have modelled this graph in Excel for the weight and fan lines as inputs and INDEX as the output:

It is solved in a very similar way to the original problem set by boofhead.

The trick is to realise that the intersection points between the fan lines and the horizontal weight lines are spaced evenly, i.e. the problem is actually linear.
MacBoero is offline