Excel Solver with User Interface (EXCEL VBA)
Project detail
A full and detailed description of the project requirements and expectations is attached. This project requires Excel VBA coding to use the Excel Solver feature to solve an optimization model and be presented with a UserInterface created in Excel VB allowing the user to have input capabilities such as adding, deleting and updating information like the provided in the Examples Excel files (BetaData.xlsx). The goal is to create this as simple as possible in terms of the coding and programming so that people that are not expert with Excel and Excel VB can understand the ideas, processes, coding behind the tool.
This is a time sensitive project and requires that you will understand the mathematical model and calculations referenced for the optimization calculation using the solver.
Review all details and ask questions! Do not overestimate the demand of work for this and the difficulty! So, again, carefully read all documents and details and ask questions!