title: Excel: Use a complex model to calculate values on another sheet
body: <p>Let's say I created a complex financial model that uses 20 variable inputs to ultimately come up with a single result through a very large series of cells and formulas. I then want to make a summary rollup sheet that provides 7 or so sets of the 20 variables and the result value for each combination, but be able to tweak them and get the new result re-calculated. How can I have the model sheet be used as a calculation for the rollup sheet with 20 variables being passed?</p>
  
  <p>For example, Model:</p>
  
  <pre><code>Var 1:  5
  Var 2:  3
  ...
  Var 20: 5
  
  Result: 10843 (large multi-cell based model calculation)
  </code></pre>
  
  <p>Rollup:</p>
  
  <pre><code>Var 1:  5      6      2
  Var 2:  3      3      5
  ...
  Var 20: 5      6      3
  
  Result: 10843  9834   5873
  </code></pre>