Optimizer simple Tool
- Hali: Closed
- Zawadi: $10
- Wasilisho Zilizopokelewa: 1
- Mshindi: arghod95
Maelezo ya Shindano
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
Ujuzi unaopendekezwa
Wasilisho kuu kwenye hili shindano
-
arghod95 Bangladesh
Bodi ya Ufafanuzi ya Umma
Jinsi ya kuanza kwa kutumia mashindano
-
Chapisha Shindano Lako Haraka na rahisi
-
Pokea Wasilisho Nyingi Kutoka kote ulimwenguni
-
Tuza wasilisho bora zaidi Pakua faili - Rahisi!