Recent Comments
Author Archives: dougaj4
Selecting Ranges from a UDF
In the process of tidying up the ConBeamU spreadsheet (which will be posted here in the next few days) I decided to revise the routine for converting input ranges to arrays. The input for the continuous beam analysis functions consists … Continue reading
The Incredible String Band
The Incredible String Band was a late 1960’s/ early 70’s musical group often categorised as “psychedelic folk”, and dismissed as a peculiarity of the era of no great interest beyond that. That is a pity, because the two key members … Continue reading
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 links, Maths, plotting, xll
3 Comments
Python for VBA users- 6; Using Pysparse with Excel
Previous Python Post The analysis of structural frames requires the solution of large sparse matrix systems, which rapidly becomes very time consuming using a VBA based solver, especially for 3D analysis. I have previously presented versions of my frame analysis … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, VBA
Tagged Excel, Frame Analysis, PYsparse, Python, sparse matrices, VBA
1 Comment
All about dictionaries
A couple of links to sites with comprehensive information on using the scripting dictionary object, found via Daily Dose of Excel: VBA for smarties I. What is a dictionary ? A dictionary in VBA is a collectionobject: you can store … Continue reading
Newton Excel Bach, not (just) an Excel Blog 