Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: Solver
Hi,
I should apply the solver function a lot of times and I'd need to know if exist a function that make me able, once I've set the solver up, to obtain the estimated coefficient of the regression (the output of the solver) for each month of a my temporal series without change every time the cells. I hope you have understand what I mean, cause I'm not English, and someone can give me help. Thanks. Bye |
#2
|
|||
|
|||
Turn on the macro recorder (Tools | Macro Record new macro...) and
solve one problem by hand. Turn off the recorder and switch to the VBE (ALT+F11). Share the code in the newsgroup (as text in the message not as an attachment) and also indicate how the other scenarios are laid out in the worksheet. Someone should be able to give you a generalized solution. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , says... Hi, I should apply the solver function a lot of times and I'd need to know if exist a function that make me able, once I've set the solver up, to obtain the estimated coefficient of the regression (the output of the solver) for each month of a my temporal series without change every time the cells. I hope you have understand what I mean, cause I'm not English, and someone can give me help. Thanks. Bye |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel solver sensitivity report has empty shadow prices column? | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
Excel Solver background in forecasting modeling | Excel Worksheet Functions | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |