Skip to main content
Question

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

  • October 24, 2017
  • 0 replies
  • 16 views
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
      This topic has been closed for replies.

      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.
      Terms & ConditionsAccessibility statement