1-Visitor

Solved

Optimization

Forum|Forum|14 years ago
March 21, 2012
3 replies
12666 views

I have a range of values that is entered in the program. in this case CL and HL, which are the height of a telephone pole.

here are the equations i have to work with.

h=0.001*S^alpha + CL

c=C1+2*h^beta

S=L/(N-1)

D=N/NP

and CT=c*N+NW(1 and 2)*C2*D

aplha,CL,C1, C2, beta, NW1, NW2, L, HM, HL, NP are all variables entered at the beginning of the program.

i need to find the lowest total cost (CT) with respect to the height when it is between CL and HL for NW1 and then between HL and HM for NW2. HL is the deciding point between a crew of NW1 for below HL, and above is NW2.

I attached a copy of the assignment and tomorrow will attach a copy of what i have so far.

1_Optimization-power-poles-w12.pdf

Physics

Best answer by Fred_Kohlhepp

Try this:

V

VladimirN

24-Ruby III

Please attach your Mathcad worksheet to the message.

P

ptc-4510012

Author

1-Visitor

here is is, i still have not added units. having trouble getting them to work corretly.

1_another-attempt-xmcd.zip

P

ptc-4510012

Author

1-Visitor

basically what i need to do is evaluate an equation over a range, from CL to HL and find the lowest cost.

i found an error in one of my equations

1_another-attempt-xmcd.zip

F

Fred_Kohlhepp

Answer

23-Emerald I

Try this:

1_optimize-xmcd.zip

P

ptc-4510012

Author

1-Visitor

Fred that helps alot, i had to make a few changes to get it correct. the only issue is i need it set up so i can change the input paramaters for different situations.

thanks again for the help
Case

edit, i uploaded the changes i made and "think" it will work, the "h" equation you made is amazing.

i also attached a copy of the correct answers from hand calculations.

Case

1_optimize2-xmcd.zip

2_Program-Results-Summary.xlsx

F

Fred_Kohlhepp

23-Emerald I

You have a block where you assign numbers to the parameters. If you change these values the sheet will calculate the new minimum cost and report the associated values.