Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Worksheet Functions | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Setting up and Configuration of Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel |