Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Downloads
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Daily Download 2: SLS design of reinforced concrete sections ...
- Contour plots with Excel and Matplotlib
- Retrieving unique values from a range or array ...
- Downloads by category
- Latex Maths Text in Excel
Recent Comments

Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Installing Adobe Reader non-DC… 
Z on Downloads 
Z on Daily Download 8: Drawing in… py_ConBeamU and Stra… on py_ConBeamU and Strand7 check… 
dougaj4 on Daily Download 8: Drawing in… 
Z on Daily Download 8: Drawing in…
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