Category Archives: VBA

Continuous Beam spreadsheet with moving load

Posted on 26/11/2013 by dougaj4

I have added a moving load function to the ConBeamU spreadsheet, allowing maximum load actions and deflections to be determined in a continuous beam  under the influence of a vehicle defined by a number of point loads.  The new version … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | 17 Comments

Unit aware continuous beam spreadsheet update

Posted on 22/11/2013 by dougaj4

The ConbeamU spreadsheet provides Excel user defined functions (UDFs) for the analysis of continuous and simply supported beams and cantilevers using Macaulay’s method.  It allows complex combinations of any number of partial distributed loads, point loads and moments, with changes … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , | 1 Comment

Python for VBA users- 6; Using Pysparse with Excel

Posted on 29/10/2013 by dougaj4

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 , , , , , | 1 Comment

All about dictionaries

Posted on 24/10/2013 by dougaj4

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 →

Posted in Excel, VBA | Tagged , , | 3 Comments

Python for VBA users – 5; Using built in numpy functions

Posted on 13/10/2013 by dougaj4

Previous Python Post In previous posts in this series I have looked at translating VBA functions to solve quadratic and cubic equations, but the Python numpy library has a polyroots function that will solve polynomials of any degree, and will … Continue reading →

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