Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Writing Arrays to the worksheet - VBA function
- Linking Excel to C - 2
- Reinforced Concrete Moment-Curvature - 1
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Polynomial Update
- Numpy and Scipy for Excel
Recent Comments
Category Archives: Newton
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
xlSciPy – Python SciPy for Excel; Update with new functions
The xlSciPy spreadsheet, previously described here, has been updated with new functions for integration, finding equation roots and maxima and minima, solving systems of non-linear equations, and evaluation of equations entered as text. The new version (including full open-source VBA … Continue reading
Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Integration, minimization, Python, root finding, SciPy, SciPy.optimize, solvers, UDF, VBA
Leave a comment
ConBeamU 4.08
The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point. The new version (4.08) can be downloaded from: ConbeamU.zip … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, moving load, Strand7, UDF, VBA
1 Comment
Paper bridge
Making a model bridge out of paper is pretty easy. Making a full size bridge, strong enough to carry a Range Rover, out of just paper takes a bit of doing: It seems the guy who built the bridge (Steve … Continue reading
Posted in Arch structures, Newton
Tagged Arch bridges, China, Paper bridge, Range Rover
Leave a comment