LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default SOLVER does not iterate / work

I am using SOLVER for the first time and it appears that it is not iterating.
The initial objective and "change" values do not change at all after running
SOLVER.

My objective is to minimize the difference^2 between two columns of data by
optimizing one cell which contains a "cut" value.

- The first column of data contains fixed integer values of 0 and 1 for
10,000 cases.
- The second column of data contains decimal values between 0 and 1 for
10,000 cases.
- A third column is calculated based on a cut value ("change" value) where
values in the second column = cut are set to 1 and values < cut are set to 0.
- The objective/target is to minimize the sum of the differences between the
1st and 3rd column squared.

Can anyone help?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Goal Seek or Solver to work Geri Excel Discussion (Misc queries) 1 October 15th 08 12:01 AM
Premium Solver does not work with Vista OT Excel Worksheet Functions 2 October 11th 08 11:42 PM
I need to install the solver add-in but my setup CD doesn't work. dd Setting up and Configuration of Excel 0 April 29th 06 11:46 PM
Solver does not work from Macros mjd918 Setting up and Configuration of Excel 1 January 6th 06 04:15 PM
How do I get Solver to work Graeme Excel Discussion (Misc queries) 6 September 22nd 05 04:33 AM


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"