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: 4
Default Solving Linear Programming

I have this problem with the solver and especially with the sensitivity
report, which I don't know how to fix. My target function is:

max Z = 16x1 + 16x2 +16x3 + 16x4 + 28x5 + 28x6 + 28x7 + 28x8

but the coefficient 16 is not independent from each variable. In other
terms, I have a cost vector which has the values 16 and 28 in it. And these
values are assigned as mentioned above. But when generating a sensitivity
report every coefficient of the variables is assumed to be independent from
each other. Does anybody know if and how I can block these coefficients, so
that the sensivity report doesn't assume independency?
 
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
Help on solving the linear programming model using solver papachunks Excel Programming 2 April 18th 07 05:48 AM
VBA Macro for Solving Linear Equations monir Excel Programming 5 October 3rd 06 06:10 PM
solving of linear equation Stan Excel Discussion (Misc queries) 5 August 30th 06 03:12 PM
Linear Programming Asif Mian Excel Programming 1 October 3rd 05 03:04 PM
Linear Programming Franklin Excel Discussion (Misc queries) 1 January 22nd 05 09:27 PM


All times are GMT +1. The time now is 01:28 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"