Tag Archives: VBA

February Links

Posted on 16/02/2017 by dougaj4

Two new links with valuable free resources: .net and office automation follies : including many advanced VBA resources.  Thanks to Alfred Vachris for the link. AET VBE Tools : Tools for the Visual Basic editor from Andrew Engwirda (via Daily Dose of … Continue reading →

Posted in Excel, Link to dll, VBA | Tagged , , , | Leave a comment

Weighted Least Squares Regression, using Excel, VBA, Alglib and Python

Posted on 05/02/2017 by dougaj4

Least squares linear regression in Excel is easy.  That’s what the Linest and Trend functions do.  That is, they find the coefficients of a straight line (or higher dimension shape) so that the sum of the squares of the distances of … Continue reading →

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 9 Comments

Debugging with xlwings and PyCharm

Posted on 26/01/2017 by dougaj4

The xlwings documentation covers de-bugging, but it is very brief and it took me some time to get everything working, so this article covers the process in a bit more detail.  The details are affected by the editor being used, … Continue reading →

Posted in Excel, Link to Python, UDFs, VBA | Tagged , , , , , , | Leave a comment

3D Frame analyses with spring releases – 2

Posted on 04/01/2017 by dougaj4

The latest version of the 3DFrame spreadsheet (previously presented here) includes provision for spring end releases, allowing for either rotational or translational springs in any direction.  These springs are now incorporated in the model by adjustment of the beam properties, … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | Leave a comment

Transferring and converting strings in Excel and Python

Posted on 26/12/2016 by dougaj4

The load table for the 3D Frame spreadsheet has a column listing the global axis for each load as text (X, Y, or Z).  In the VBA version the table is converted to a variant array, and the axes are handled … Continue reading →

Posted in Excel, Link to Python, Newton, NumPy and SciPy, VBA | Tagged , , , , , , , , | Leave a comment