Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Latex Maths Text in Excel
- Commenting a block of code in VBA
- Removing Add-ins
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Solving cubic and quartic equations with Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Retrieving unique values from a range or array ...
Recent Comments
Tag Archives: Trig functions
More Numpy with Excel and xlwings
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 Anaconda, Excel, math functions, Numerical ranges, Numpy, Polynomial functions, Python, Trig functions, UDF, VBA, xlwings
2 Comments
Trigonometric Functions in VBA – Update
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
Trigonometric Functions in VBA
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