Optimization
Is there a way to optimize a specific cell by changing a few cells in excel?
What i'm trying to do is minimize my total cost by changing a few cells. These few cells (5 of them with each cell having a possible range between 0-5) will change the total cost. so my question is how or can this be done in excel and can it be automated instead of me plugging in(brute force and ignorance method) the different options. Thanks for the help, Josh |
Optimization
You can create and save Scenarios that can be applied to your data.
Create a default scenario using your original seed values, and then create additional scenarios to show optimized values in place of the originals. -- Kevin Backmann "jxbeeman" wrote: Is there a way to optimize a specific cell by changing a few cells in excel? What i'm trying to do is minimize my total cost by changing a few cells. These few cells (5 of them with each cell having a possible range between 0-5) will change the total cost. so my question is how or can this be done in excel and can it be automated instead of me plugging in(brute force and ignorance method) the different options. Thanks for the help, Josh |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com