PPRuNe Forums - View Single Post - Excel Formula
Thread: Excel Formula
View Single Post
Old 13th March 2013 | 08:38
  #12 (permalink)  
MacBoero
15 Anniversary
 
Joined: Jan 2008
Posts: 300
Likes: 0
From: London, England
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  
Reply