Category Archives: Link to dll

Using Frame4Buckle with the Alglib solver

The Frame4Buckle spreadsheet carries out a buckling analysis of a column or strut, which may be divided into any number of segments with varying cross section details, allowing the analysis of stepped or tapered members.  The spreadsheet includes a VBA … Continue reading

Posted in AlgLib, Computing - general, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , , , | 5 Comments

Xlls, Maths and Plots; some useful links

Two from regular commenter here, Keith Lewis: Excel xll add-in library: This is a library for creating xll add-ins for Excel from 97 through 2013. It makes every feature of the latest Excel SDK available to you including the big … Continue reading

Posted in Coordinate Geometry, Excel, Link to dll, Maths, Newton | Tagged , , , | 3 Comments

Installing Python, Scipy and Pyxll

I have recently been experimenting with Pyxll, which after a few initial hiccoughs is proving to be an easy and efficient way to connect Excel to Python based scientific and maths applications, such as linear algebra routines and ODE solvers.  … Continue reading

Posted in Excel, Link to dll, Link to Python | Tagged , , , , | 15 Comments

Installing dlls on 64 bit Windows

Several of the spreadsheets available here include routines linking to compiled code written in C#, C++ or Fortran, which require the installation and registration of dll files.  The procedures for doing this are significantly different on machines with 64 bit … Continue reading

Posted in Computing - general, Excel, Link to dll, VBA | Tagged , , , | 10 Comments

3DFrame Ver 1.03 and Frame4 Ver 3.07

Updated versions of my 2D and 3D frame analysis spreadsheets are now available for download from: 3DFrame.zip Frame4.zip The download files include full open-source VBA code, and dll files for compiled solvers for much better performance with large models. See https://newtonexcelbach.wordpress.com/2012/11/16/frame4-now-with-added-alglib/ for … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , | 34 Comments