Category Archives: VBA

Arcs and arc-splines

Posted on 17/08/2018 by dougaj4

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single  arc, or a series of arcs connected (if necessary) by straight lines.  The new version may be downloaded from: IP2.zip As an example … Continue reading →

Posted in Animation, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 1 Comment

New Tricks …

Posted on 16/08/2018 by dougaj4

… or in some cases, old but forgotten tricks. The first comes from a Quora question, asking for the most underutilised feature in Excel. When de-bugging a VBA routine you can set a break point where the code will stop: … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 4 Comments

VBA vs Power Query vs Python

Posted on 04/08/2018 by dougaj4

A recent post at Chandoo’s Excel Forum asked for a formula to extract all pairs of digits from a number with 4 digits.  This was soon extended to dealing with longer numbers, and the examples looked at here will work with … Continue reading →

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

Units and solvers with Pint and Sympy

Posted on 29/07/2018 by dougaj4

Following the previous post I have adapted the units code to use the Pint package, and added a function using the Sympy equation solver, with Pint units.  I have applied the functions to finding the depth of neutral axis of a … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, UDFs, VBA, xlwings | Tagged , , , , , , , , , , , | 1 Comment

Working with units in Excel – using VBA and Python

Posted on 15/07/2018 by dougaj4

One of the most frequent reasons given for not using Excel for engineering and scientific applications is its very limited  facilities for dealing with calculations involving units.  It is possible to overcome this deficiency with VBA (see  Daily Download 24: … Continue reading →

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