Can we perform Excel-Solver like Optimization calculations in Quickbase?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Users enters a lot of information in Quickbase app. Is there a way to perform excel-solver like optimization calculations with the user inputs within Quickbase
Photo of Nicholas Jessee

Nicholas Jessee

  • 70 Points

Posted 2 years ago

  • 0
  • 1
Juiced has a tool called Docs XL.  It basically can feed data either into into individual fields or into "rows" in a regular excel Workbook spreadsheet and then you get 100% of what Excel can do.  Like IRR calculations and well at that point you are in Excel but you did not have to have the drudgery of entering the data.  So you have full Excel capability.

http://www.juicedtech.com/add-ons/xldocs

Quick Base has a native set of formuals and they are what they are.  They do not iterate or optimize.