Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #21   Report Post  
Old December 9th 09, 12:58 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,180
Default Solver not working

Excel 2007
Yes, Goal Seek has only one variable,
but a workaround is iteration and RMS.
Illustrated that by adding two more columns.
Graphed it for visualization.
Solution has a range of values.
http://c0444202.cdn.cloudfiles.racks...12_07_09a.xlsm

  #22   Report Post  
Old December 9th 09, 05:34 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 26
Default Solver not working

On Dec 8, 6:58*pm, Herbert Seidenberg wrote:
Excel 2007
Yes, Goal Seek has only one variable,
but a workaround is iteration and RMS.
Illustrated that by adding two more columns.
Graphed it for visualization.
Solution has a range of values.http://c0444202.cdn.cloudfiles.racks...12_07_09a.xlsm


Thanks, I'll take a look tomorrow afternoon. In the meantime, Ray
Koopman over at http://groups.google.com/group/sci.stat.math helped
showed me a good sigmoid function that allows me to keep my data as
continuous but get values to reach very close to 0 and 1 depending on
what side of the thresholds they're on. Excel Solver is still fussy
about this since it is highly non-linear but it at least gave me a
more optimized value than I had eyeballed. That said, I look forward
to going over your suggestion to possibly getting something easier on
Solver since I have to change these data values iteratively (i.e.
after each Solver optimization).

Thanks again,
K


Reply
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
Solver or Other? Stan Excel Worksheet Functions 5 June 4th 09 10:29 PM
Will Solver do the job? Mark Excel Discussion (Misc queries) 7 March 11th 09 02:33 AM
Calculate working days but change working week SamB Excel Discussion (Misc queries) 1 September 1st 08 09:17 PM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 11:52 PM
solver Good Morning Excel Worksheet Functions 1 January 12th 05 06:52 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017