| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
optimization
i was wondering if anyone knew of a macro formula or any formula tha would create an optimization button so that whenever you clicked th button it would select the best combination of three values in d2:f2 s that i2 will be the most minumum value possibl -- kcka ----------------------------------------------------------------------- kckar's Profile: http://www.excelforum.com/member.php...fo&userid=2532 View this thread: http://www.excelforum.com/showthread.php?threadid=39418 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
optimization
Help us understand what you are asking. D2:F2 is only thre cells...therefore whatever the SUM of those three cells...it is th minimum (and for that matter, the maximum) it can be. What are we missing? I2=SUM(D2:F2) More info, pleas -- swatsp0 ----------------------------------------------------------------------- swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510 View this thread: http://www.excelforum.com/showthread.php?threadid=39418 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
optimization
its kind of complex basically i am creating a forecast model where d2:f2 alpha, beta an delta values. (that all alter the forecast) i2 is the sum of squares of the errors between the forecasted data an the real values you need more info? what type -- kcka ----------------------------------------------------------------------- kckar's Profile: http://www.excelforum.com/member.php...fo&userid=2532 View this thread: http://www.excelforum.com/showthread.php?threadid=39418 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
optimization
Look at the Excel VBA help on Solver.
-- Regards, Tom Ogilvy "kckar" wrote in message ... its kind of complex basically i am creating a forecast model where d2:f2 alpha, beta and delta values. (that all alter the forecast) i2 is the sum of squares of the errors between the forecasted data and the real values you need more info? what type? -- kckar ------------------------------------------------------------------------ kckar's Profile: http://www.excelforum.com/member.php...o&userid=25322 View this thread: http://www.excelforum.com/showthread...hreadid=394184 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
optimization
It sounds to me that the tool you need is Solver... found on the mai menu under ToolsSolver. HTH Bruc -- swatsp0 ----------------------------------------------------------------------- swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510 View this thread: http://www.excelforum.com/showthread.php?threadid=39418 |
| 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 | |||
![kckar[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
