Hi All
I have an issue solving for multiple variables. I would like to find out the distribution of litres (of fuel) per fuel station range. I currently have the total number of litres, and the average litres per range. Now I need to solve for the variables - number of fuel stations per range.
ie. (a*200litres)+(b*300litres)+(c*380litres)=9000litres
In the excel - the variable a should be deposited into cell A1, b into B1 and c into C1. The total litres is in D1.
Any help will do.
Thanks
Steve
Pls attach a sample file with expected result
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
This sounds like the "start" of a "solve a system of equations" type problem that you should have learned about back in secondary school (refresher here: http://www.purplemath.com/modules/systlin1.htm ). It is only the start because you only have one equation with three unkowns. It seems like there should be more information or constraints about the three variables.
Exactly as it is presented, you can randomly select values for any two of the variables, then solve for the third variable algebraically. For example, I choose 10 for a, 9 for b, and c=(9000-sumproduct({10,9},{200,300}))/380=11.3... I can similarly choose any other values for a and b and find the corresponding value for c.
Originally Posted by shg
To calculate the minimum number of barrels use application "Solver".
@ Czeslaw
A minor improvement of you model?
As this is a linear problem don't use excel’s default setting “GRG Nonlinear” try the “Simplex LP” instead. It works a bit faster.
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks