Forum Discussion

NicholasJessee's avatar
NicholasJessee
Qrew Member
8 years ago

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

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
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.