Forum Discussion

valexiacapital's avatar
valexiacapital
Copper Contributor
Aug 04, 2022

Multi-Variable Data Tables

Hello, Everyone - I'm trying to understand if there's a way to do multi-variable data tables. Let's take a loan for example. How could we see different monthly payments based on the interest rate, term, and loan size? Right now, data tables only allow for 2 inputs for 1 solution. But what if there was a way to create something new for 3+ variables? Here's my thought process:

 

  1. We're constrained in Excel by the 2 dimensions of the table (rows and columns) 
  2. We can't see the 3rd dimension of what that 3rd input would look like
  3. But what if we could show it graphically, like a triangle?
  4. If you have 3 variables, you could represent the limits on your inputs on each side
  5. The solution would populate a point within that triangle
  6. If this is possible, you could have an infinite number of inputs for an endless number of shapes 
  7. I've attached a quick sketch of what that might be able to look like 

Any thoughts or ideas would be greatly appreciated! 

 

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Excel already can handle multi-variable tables, simply have a column for each variable and column(s) for the "result".

Resources