solving for variable in e^ formula, check to see if right

[chrisdab]

Hi, I have this formula:
Tech% = BaseTech% + (MaxTech%-BaseTech%)*GvtTechBonus*(1-e^(-Effective*TechPoints/(180+6.5*Land)))

Abbreviated:
T% = BT% + (MT%-BT%)*GTB*(1-e^(-Ef*TP/(180+6.5*L)))

Solving for Techpoints (TP) I got:
(180+6.5L) * ln(1-(T%-BT%)/((MT%-BT%)*GTB)) / Ef
ln = natural log

I just want to make sure this is correct and if I can simplify it further.


Thanks

 

[tkhunny]

It looks fine to me, but personally, I'd lose the decimal and stick with integers as much as possible. \(\displaystyle \frac{360+13*L}{2*EF}\)

 

[chrisdab]

I think I did something incorrect cause the formula is not working out right when I put it into
excel.

 

[tkhunny]

You can create pieces of it in multiple columns. It's easier to decode.