Discussions

Expand all | Collapse all

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

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

    Posted 10-23-2017 22:05
    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


  • 2.  RE: Can we perform Excel-Solver like Optimization calculations in Quickbase?

    Posted 10-23-2017 22:11
    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.