Optimizer simple Tool

• Stato: Closed
• Premio: $10
• Proposte ricevute: 1
• Vincitore: arghod95

Winner

Descrizione del concorso

Hello Everyone,

The goal of this contest is to develop a tool that will optimize a result wanted by the user.

The optimizer has to find the IDENTIFIERS and its corresponding percentages (Output Weight Tab) by minimizing the sum of monthly errors (cell312, Output Weight tab, Excel Process workbook attached).

I recorded how the process is currently done (two videos) and included three excel files:

1. Data provided by user: these are the inputs that are going to be used in the optimization

2.Example_process: by following the excel formulas after watching the videos you will be able to deep diver of how the optimization is currently done.As you will notice at the end of the video the Solver says too many variables, this is why I am looking for an alternative solution to run this optimization, feel free to use any coding language.

3. Example-Results: This are optimal weights found manually for each variable which minimizes the target cell. This is what the user is expecting to get after running the tool.

Thank you for participating

Cristobal

*If two entries are tied, then the one with best user interphase will be the winner

Competenze consigliate

• Coding