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: 1
Default Multi-variable Equation Solving

I am trying to get Excel to find a solution to a 10
variable system of equations by supplying a range for one
variable. I work for a steel company and I am trying to
set up a spreadsheet calculating the cheapest option for
galvanizing steel at two different places with four
different size tanks and six different freight charges. I
have all 10 equations set up, but can't figure out how to
enter the variables in solver. I also need it to select a
minimun value for the range of numbers I give it. Two
variables in the below equations happen to be zero for
this particular problem:

x7 = 0
x10 = 0

x1 + x2 + x3 + x4 = 666.41

x5 + x6 + x7 = x8 + x9 + x10 = 666.41

x5 + x6 + x7 - x8 - x9 - x10 = 0

x1 + x2 - x3 - x4 = 0

x5 + x8 = 590.31

x6 + x9 = 76.1

x7 + x10 = 0

x1 + x2 - x5 -x6 - x7 = 0

x3 + x4 - x8 - x9 - x10 = 0

150x1 + 150x2 + 150x3 + 150x4 + 61.05x5 + 87.45x6 + 0x7 +
22.5x8 + 31.05x9 + 0x10 = ?

* To find a solution, I want the minimum value of '?' when
x1 = 0 to 666 in increments of 1.

Can anybody help me? I would really appreciate it.

Thanks,

Todd

 
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
solving of linear equation Stan Excel Discussion (Misc queries) 5 August 30th 06 03:12 PM
Two unknown variable equation John Excel Worksheet Functions 6 March 10th 06 08:51 PM
Please help me solving this equation ...: ) Joe Satriani Excel Discussion (Misc queries) 3 February 22nd 06 05:50 PM
Multi-lookups on variable data C.Pflugrath Excel Worksheet Functions 0 October 27th 05 12:22 AM
Multi Variable Formula MadCap via OfficeKB.com Excel Worksheet Functions 2 May 24th 05 09:04 PM


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