Category Archives: VBA

Fitting 3D circles to scattered points

Posted on 11/02/2018 by dougaj4

Following a comment at update-to-glob_to_loc3-and-loc_to_glob3-functions, I have modified the Python code at the linked site, so it can be run from Excel, via xlwings.  The spreadsheet described below, and the associated Python code, can be download from: 3DCirc.zip The original … Continue reading →

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | 7 Comments

Cubic splines with jagged data

Posted on 07/02/2018 by dougaj4

A cubic spline provides a good approximation to a smooth curve, and alternative versions are available for free download (see Daily Download 22: Splines and Curves, Update to AL-Spline-Matrix, and xlwSciPy 1.09 – update for xlwings 0.10 and Scipy 0.18.1), but if … Continue reading →

Posted in Arrays, Beam Bending, Concrete, Curve fitting, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 2 Comments

Evaluating text with units and finding the neutral axis

Posted on 07/01/2018 by dougaj4

A few weeks ago a comment asked for guidance on finding the moment capacity of a reinforced concrete section.  This post will look at finding the depth of the neutral axis (NA) in a rectangular section, with a single layer of … Continue reading →

Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , | 7 Comments

On not using Hungarian Notation, and VBA shortcuts

Posted on 01/01/2018 by dougaj4

In June this year Michael Alexander at Bacon Bits had a post on using Hungarian Notation (or not).  It contained the following quote from Stackoverflow, which for me sums up excellently a good reason for not using it: “vUsing adjHungarian nNotation vMakes … Continue reading →

Posted in Excel, VBA | Tagged , , , | 1 Comment

Excel Uservoice and Python for Excel

Posted on 18/12/2017 by dougaj4

The Excel Uservoice site is a forum for users to post suggestions for improvements to Excel.  A suggestion to add native Python support to Excel, as a replacement to VBA, has had by far the most votes since the start, and … Continue reading →

Posted in Computing - general, Excel, Link to Python, VBA | Tagged , , , , | 1 Comment