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 |
Multi-variable Equation Solving
Todd,
Is your email correct? I will try doing this on a spreadsheet and send you the results. Regards, Kevin "Todd" wrote in message ... 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 |
Multi-variable Equation Solving
Hi Todd,
I sent you a spreadsheet to your hotmail address. It contains the solutions for X1 to X10 as well as your 1-666 iteration. Be sure to look at the initial as well as the completed tabs of the spreadsheet. You should be on your way. Regards, Kevin "Todd" wrote in message ... 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 |
All times are GMT +1. The time now is 02:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com