Tag Archives: Fortran

Making non-linear FEA with Excel go (much) faster

Posted on 30/06/2016 by dougaj4

The spreadsheet presented in the previous post takes about 90 seconds to complete (with the iteration limit set at 500) on my computer, and is much slower on some other systems.  The VBA code that does all the hard work is based … Continue reading →

Posted in Computing - general, Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, VBA | Tagged , , , , , , , | 3 Comments

Tanh-Sinh Quadrature via F2PY – Part 3

Posted on 06/02/2016 by dougaj4

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 →

Posted in Excel, Fortran, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Running Fortran from Python with F2PY

Posted on 13/01/2016 by dougaj4

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 , , , , | Leave a comment

Run Fortran from Excel with Python and F2Py

Posted on 15/09/2014 by dougaj4

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 , , , , , , , , | 6 Comments

Daily Download 31: Linking to Fortran

Posted on 18/10/2012 by dougaj4

Several routines linking to Fortran dll files, produced with the Silverfrost Fortran compiler, have been provided in previous daily downloads.  Today’s files are example routines, provided with posts covering the procedures to link Excel to Fortran code.  Note that these files … Continue reading →

Posted in Computing - general, Excel, Fortran, Link to dll, UDFs, VBA | Tagged , , , , , | Leave a comment