Recent Comments
Author Archives: dougaj4
Continuous Beam spreadsheet with moving load
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
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 continuous beam analysis, Excel, Macaulay's Method, moment restraint, spring supports, UDF, unit aware, VBA
1 Comment
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
