Charting Solver solution results

%3CLINGO-SUB%20id%3D%22lingo-sub-1638803%22%20slang%3D%22en-US%22%3ECharting%20Solver%20solution%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1638803%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20running%20a%20solver%20solution%20to%20find%20the%20optimal%20conditions%20for%20a%20fixed%20set%20of%20historic%20data%20to%20help%20determine%20reliable%20conditions%20for%20future%2Flive%20data.%20%26nbsp%3BI%20am%20currently%20stress%20testing%20my%20solver%20results%20as%20i%20want%20to%20avoid%20any%20curve%20fitting%20where%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wondering%20if%20there%20is%20a%20way%20to%20chart%20all%20of%20the%20possible%20results%20that%20solver%20calculates%20in%20the%20process%20of%20finding%20the%20optimised%20settings%20so%20that%20i%20can%20custom%20choose%20a%20setting%20that%20isn't%20necessarily%20the%20optimal%20for%20the%20historic%20data%20(curve%20fit)%20but%20a%20setting%20that%20may%20produce%20less%20volatility%20to%20the%20end%20result%20when%20feeding%20in%20future%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20Chart%20similar%20to%20the%20one%20attached%20would%20be%20perfect%20where%20red%20shows%20an%20overall%20net%20negative%20outcome%20and%20green%20shows%20net%20overall%20positive%20outcome.%20%26nbsp%3BI%20wouldn't%20necessarily%20choose%20the%20setting%20highlighted%20(despite%20it%20being%20most%20positive)%20but%20rather%20a%20setting%20that%20is%20more%20central%20in%20the%20green%20area%20(as%20it%20will%20most%20likely%20less%20susceptible%20to%20volatility%20when%20inputting%20future%20data)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20Newb%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1638803%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1639484%22%20slang%3D%22en-US%22%3ERe%3A%20Charting%20Solver%20solution%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639484%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F783374%22%20target%3D%22_blank%22%3E%40Excel_Newb-27%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20many%20decision%20variables%20you%20have%3F%3C%2FP%3E%3CP%3Eyou%20can%20plot%20only%20X%2CY%20and%20Z%3C%2FP%3E%3CP%3Eso%20only%20two%20variables%2C%20you%20need%20to%20use%20a%20contour%20diagram%2C%20it%20would%20give%20you%20something%20similar.%3C%2FP%3E%3CP%3Eif%20you%20have%20the%20file%20I%20can%20give%20it%20a%20look%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebest%20of%20luck%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

I am running a solver solution to find the optimal conditions for a fixed set of historic data to help determine reliable conditions for future/live data.  I am currently stress testing my solver results as i want to avoid any curve fitting where possible.

 

I am wondering if there is a way to chart all of the possible results that solver calculates in the process of finding the optimised settings so that i can custom choose a setting that isn't necessarily the optimal for the historic data (curve fit) but a setting that may produce less volatility to the end result when feeding in future data.

 

A Chart similar to the one attached would be perfect where red shows an overall net negative outcome and green shows net overall positive outcome.  I wouldn't necessarily choose the setting highlighted (despite it being most positive) but rather a setting that is more central in the green area (as it will most likely less susceptible to volatility when inputting future data)

 

Thanks

 

Excel Newb

2 Replies
Highlighted

@Excel_Newb-27 

 

How many decision variables you have?

you can plot only X,Y and Z

so only two variables, you need to use a contour diagram, it would give you something similar.

if you have the file I can give it a look

 

best of luck

Highlighted

 Hi Ramiz,

 

Thank you for your message, i actually figured out a way to solve the problem shortly after posting the query.  I created a table and used a What-If analysis to determine what would happen if the variables were set to the various iterations.

 

Thank you for your response