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
Forum Discussion
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.
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.