Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Contour plots with Excel and Matplotlib
- Cubic Splines
- Downloads by category
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
Tag Archives: Trigonometric functions
Daily Download 23: Trigonometric Functions in VBA and Fortran
The trigonometric functions provided in Excel omit some functions, and the functions provided in VBA are still more restricted. Notably VBA does not provide an ATan2 function, which is required to define an angle over a full 360 degree range, based on X, … Continue reading
Posted in Coordinate Geometry, Excel, Link to dll, Maths, Newton, UDFs, VBA
Tagged ATan2 function, Excel, hyperbolic functions, Trigonometric functions, UDF, VBA
8 Comments
Trigonometric Functions – dll
I have converted the trigonometric functions presented in this earlier post into a Fortran dll. The dll and associated spreadsheet and add-in files can be downloaded from here. This file and the associated file Trig.dll provide trigonometric and hyperbolic functions not … Continue reading
Posted in Excel, Link to dll, Maths, Newton, UDFs
Tagged dll, Excel, Fortran, hyperbolic functions, Trigonometric functions, UDF, VBA
2 Comments