terrypin Posted June 29, 2018 Report Share Posted June 29, 2018 Any mathematicians around? A macro I wrote needed some trigonometry, so I took the easiest course of an excursion to Excel to use its ATAN2 function. That works fine. But out of curiosity I wondered if I could do it entirely within ME Pro. (The copy/pasting to and from Excel always seems slow.) So i went looking for either a formula or a convergent series delivering a suitable approximation. I failed with ATAN2 but I did find a series for a good second best, arctan (which in Excel is called ATAN): arcatan(x) = x - (x^3)/3 + (x^5)/5 - (x^7)/7... etc where x<1 It's slow to converge but that shouldn't be a problem with enough terms, I thought. But after some hours I gave up trying to implement it. Reckon I could have done it 40 years ago with BASIC or FORTRAN, but Repeats within Repeats in ME Pro (which was my approach) never fail to bring on a headache! It's a long shot, but anyone ever written a similar macro they can share please? Terry, East Grinstead, UK Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.