Tag Archives: Trig functions

More Numpy with Excel and xlwings

Posted on May 24, 2018 by dougaj4

The spreadsheet presented in the last post on sorting also includes links to many other Numpy functions.  The spreadsheet and associated Python file can be downloaded from: xlNumpy.zip The Numpy functions require xlwings and Numpy to be installed, which are included in … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , , , , | 2 Comments

Trigonometric Functions in VBA – Update

Posted on December 6, 2008 by dougaj4

In this post from February a set of VBA trigonometric functions were presented, using the derivations given on the Microsoft Developer Network site: Derived Math Functions Unfortunately two of the functions were wrong; the correct versions are shown below: Inverse Secant … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , | 5 Comments

Trigonometric Functions in VBA

Posted on February 23, 2008 by dougaj4

Deep within the bowels of the Microsoft on-line help can be found: http://msdn2.microsoft.com/en-us/library/csfk8t62(VS.85).aspx which lists  the derivation of trigonometric functions not provided by VBA.  Not included in this list is ATan2(), which is strange because this is the one trigonometric … Continue reading →

Posted in Excel, Maths, UDFs | Tagged | 7 Comments