Equation simplification

[raphaelroy]

Hi everybody,

I asked my intern to solver a problem about trigonometry. However, the equation he developped work, but are incredibly long and complicated for nothing.

I was wondering if there's was a way to shorten - simplify a excel equation.

Here's is the equation .... :

=DEGRES(PI()/2+ACOS((-(D5-D17/COS((PI()/2)-RADIANS(D14)-ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))*COS((RADIANS(D14)+ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))+RACINE((D13/2)^2-(D16-(D5-D17/COS((PI()/2)-RADIANS(D14)-ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))*SIN((RADIANS(D14)+ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6)))))^2))/RACINE((-(D5-D17/COS((PI()/2)-RADIANS(D14)-ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))*COS((RADIANS(D14)+ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))+RACINE((D13/2)^2-(D16-(D5-D17/COS((PI()/2)-RADIANS(D14)-ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))*SIN((RADIANS(D14)+ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6)))))^2))^2+D16^2))-ASIN((D5-D17/COS((PI()/2)-RADIANS(D14)-ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))*SIN(PI()-(RADIANS(D14)+ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6)))-ACOS((-(D5-D17/COS((PI()/2)-RADIANS(D14)-ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))*COS((RADIANS(D14)+ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))+RACINE((D13/2)^2-(D16-(D5-D17/COS((PI()/2)-RADIANS(D14)-ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))*SIN((RADIANS(D14)+ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6)))))^2))/RACINE((-(D5-D17/COS((PI()/2)-RADIANS(D14)-ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))*COS((RADIANS(D14)+ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))+RACINE((D13/2)^2-(D16-(D5-D17/COS((PI()/2)-RADIANS(D14)-ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6))))*SIN((RADIANS(D14)+ACOS((D5^2+D6^2-(D4/2)^2)/(2*D5*D6)))))^2))^2+D16^2)))/(D13/2)))


Thank you!
Raphael Roy

 

[StephenCrump]

Welcome to the Forum!

No guarantees, but you're probably more likely to get a response if you tell us:

- what D4, D5 etc represent?

- what the problem is that you're trying to solve?