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: 2
Default How accurate is Solver?

I want to compare two different optimal scenarios answers obtained from
Solver but they are quite close. I want to say, well scenario X's optimal
value is so and so larger than scenario Y's optimal value. For this I need to
understand how many decimal places are relevant in each answer. So I need to
understand what determines the accuracy of a Solver answer. Initially I
thought it was the Convergence setting but this is only for answers which
converge slowly. Not for answers which actually give the message 'Solver
found a solution'. Can anyone tell me exactly to how many decimal places I
can trust in a Solver answer?
 
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
Accurate time based analysis ASP1000 Excel Discussion (Misc queries) 1 June 27th 08 05:42 PM
How accurate is SOLVER? Augabog Excel Worksheet Functions 1 April 2nd 07 09:57 AM
My calculations are not always exact/accurate kanye Excel Discussion (Misc queries) 1 April 29th 05 03:09 PM
How can I fit an accurate trendline and formulae geoff Excel Worksheet Functions 1 April 28th 05 12:55 PM
getting accurate results when sorting LineRicher Excel Worksheet Functions 3 January 31st 05 12:40 AM


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

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

About Us

"It's about Microsoft Excel"