replacing various constants with single letters, this is
where , , , and .
If we further write that equation reduces to which can be solved for y using the quadratic formula. Once we have , and then .
I need to solve this equation for 'B'. I am having trouble rearranging the equation to achieve a 'B=' answer. Can someone help me rearrange this equation to solve for B?
0=((DCRMg) - (DCRMgAl)) ∗ e^(-B∗((ρMg)+(ρAl)))+ ((DCRMgAl )- (DCRAl ))∗e^(-2∗B∗(ρMg))+((DCRAl) - (DCRMg)) ∗e^(-B∗((ρMg)+(ρMgAl)))
replacing various constants with single letters, this is
where , , , and .
If we further write that equation reduces to which can be solved for y using the quadratic formula. Once we have , and then .
I have been recently told that this equation must be solved using Excel Solver. I have no idea how to use this program in order to calculate B.
I have created an excel formula relative to the above equation, but I am stuck at this point. Are you able to show me how you would solve the equation for B in Excel Solver?
=(B50-C50)*EXP(-B*($H$44+$I$44))+(C50-D50)*EXP((-2*B($H$44)))+(D50-B50)*EXP((-B($H$44+$J$44)))