Looking to develop a Google Sheets extension similar to Goal Seek but with enhanced functionality. The goal is to create a tool that can dynamically adjust up to 15 simultaneous input cells, (the applicable google sheet would be provided once job is accepted) which would have user-defined upper and lower bounds to maximize the outcome of one output cell.
Maximum Outcome Optimization: The extension should seek the highest possible outcome by dynamically adjusting multiple input cells in real-time.
Simultaneous Input Control: User should have the ability to control and define the upper and lower bounds of up to 15 input cells including a tic amount min adjustment for each input cell allowing users to fine-tune their optimization parameters.
Intuitive User Interface: Design a user-friendly interface that seamlessly integrates into Google Sheets, making it easy for user to input data and customize the optimization settings. (Similar to google extension - Goal Seek)
Robust Error Handling: Implement effective error handling and notifications to guide users in case of invalid input or unexpected scenarios, including a rewritable sheet showing the output of each combination used.