LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Solver

I have a simple Solver problem set up to analyze a price increase. I have
about 20 rows that represent product groups (actually procedures - I work for
a hospital but I'll stick to general terms). These are broke down into three
columns and multiplied by a factor to get net increase in revenue - my target
cell. I have two constraints: a cell representing 10% total average
increase, and a range of cells representing the increase for each product
group to be between -20% and +20%. Specifically, my Constraint box looks
like this:
$A$12:$A$29<=0.2
$A$12:$A$29=-0.2
$AI$<=$AJ$9
AJ9 has a value of 0.10
All this works, and I believe is pretty simple as far as models go.

My question is I get different answers. Once I set up and hit "go" I get an
answer, with cells A12:A29 having values between 0% and 19% But if I erase
and set the range of cells to be 2%, and then rerun Solver, I get different
results.

My problem is simple enough that I can take Solver and tweak to get my goal.
But I am wondering if I am missing something? - I've seen increadibly more
complicated examples on this site.

thanks
 
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 VBA - Defining Solver Options Kyle Excel Programming 5 March 21st 08 10:41 AM
referencing Solver.xlam vs. Solver.xla - 2007 vs. 2003 Duke Carey Excel Programming 3 November 20th 07 03:48 PM
How to replace Excel solver with some free solver codes in Excel V ct2147 Excel Programming 2 November 8th 06 07:06 PM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Resetting Solver Manually to Fix Solver Bug Stratuser Excel Programming 0 September 13th 04 07:04 PM


All times are GMT +1. The time now is 01:55 AM.

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"