Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Commenting a block of code in VBA
- Contour plots with Excel and Matplotlib
- Using Goal Seek on Multiple Cells
- Downloads by category
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Using ConbeamU DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Biaxial bending update
Tag Archives: F2Py
Tanh-Sinh Quadrature via F2PY – Part 3
For the last of the current series on combining Fortran, Python and Excel with F2PY and ExcelPython I have updated the xlSciPy spreadsheet to include two other variants of the Tanh-Sinh function: Quad_TSi integrates a non-periodic function over a semi-infinite … Continue reading
Tanh-Sinh Quadrature via F2PY – Part 2
Lets look at some details of the coding. The original code (available here) includes routines “intdeini” to generate an array of points and weights of the quadrature formula, and “intde” to carry out the integration of any supplied function “f”. … Continue reading
Posted in Excel, Link to dll, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged Excel, Excel-Python, F2Py, numerical integration, Python, SciPy, Tanh-Sinh Quadrature, UDF, VBA
Leave a comment
Tanh-Sinh Quadrature via F2PY
Fast and accurate numerical integration routines based on the Tanh-Sinh method are available as Excel VBA based functions in the Tanh_Sinh Quadrature spreadsheet by Graeme Dennes. Graeme’s VBA code is based on open source Fortran code by Takuya Ooura, which … Continue reading
Posted in Excel, Fortran, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged Excel, Excel-Python, F2Py, numerical integration, Python, SciPy, Tanh-Sinh Quadrature, UDF, VBA
Leave a comment
Running Fortran from Python with F2PY
The last post looking at using the Python F2Py package said: It is also necessary to install a Fortran compiler. After some trial and error I found that the MinGW (Minimalist GNU for Windows) package worked well. Trying some simple examples … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy
Tagged Anaconda, F2Py, Fortran, MinGW, Python
Leave a comment
Run Fortran from Excel with Python and F2Py
I have previously posted on the use of the Silverfrost Fortran compiler with Excel (e.g. Linking Excel to Fortran). More recently I have been concentrating on accessing high performance compiled routines via Python and the Python maths and science libraries … Continue reading
Posted in Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to Python, Maths, Newton
Tagged 3D frame analysis, Excel, F2Py, Fibonacci, Fortran, Python, Stiffness Matrix, UDF, VBA
6 Comments