Recent Comments
New Tricks … |… on Tool-tip tip 
Sebastian Brown on Moving averages and User Defin… 
dougaj4 on Moving averages and User Defin… dougaj4 on More 3D Intersections and 3D p… Sebastian on Moving averages and User Defin… 
Lawrence Hoffman on More 3D Intersections and 3D p… dougaj4 on Passing variable argument list… 
maurizio nardò on Passing variable argument list… Units and solvers wi… on Evaluating text with units and… Units and solvers wi… on Working with units in Excel… 
Larry on Working with units in Excel… dougaj4 on Working with units in Excel… Larry on Working with units in Excel… 
vefa okumus on Section Properties with MeshPY… dougaj4 on Section Properties with MeshPY…
Author Archives: dougaj4
New Tricks …
… 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
Double Bass
Reading the comments on a Davey Graham YouTube video: I discovered that the bass player on the track was Danny Thompson, and checking the other artists playing on the album, “Large and Life and Twice as Natural”, I found they … Continue reading
Posted in Bach
Tagged Bach, Bruton Town, Danny Thompson, Davey Graham, Dick Heckstall-Smith, Double Bass, Jack Bruce, Jon Hiseman
Leave a comment
VBA vs Power Query vs Python
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 Chandoo, Excel, itertools, Power Query, Python, UDF, VBA, xlwings
Leave a comment
Cattle at the Melbourne International Film Festival
The Melbourne International Film Festival, started in 1952, is one of the oldest film festivals in the World. The Accelerator Program is a collection of short films by emerging filmmakers from Australia and New Zealand, which this year features a … Continue reading
Units and solvers with Pint and Sympy
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 Evaluate text, evaluate units, Excel, Pint, Python, Solve text, Sympy, UDF, unit aware, Units, VBA, xlwings
Leave a comment
Working with units in Excel – using VBA and Python
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 evaluate text strings, Excel, Python, Sympy, UDFs, Unyt, VBA, xlwings
4 Comments
Scipy Statistics Functions – coding and getting help
The Python Scipy library currently has 84 statistics functions. I have now updated the xlwSciPy3 spreadsheet to access all of them directly from Excel. The new version can be downloaded from: xlwSciPy3.zip As usual, the download includes full open-source code. … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Excel, link to Python docs, Python, SciPy, Scipy stats, UDFs, VBA, xlwings
Leave a comment
