Recent Comments
Tag Archives: Excel
The meaning of = in Python
In VBA, if you have an array named a and a variant named b, then the statement “b = a” creates a new array b with the same size and values as a. If the values of either a or b are subsequently changed, the values of the … Continue reading
ConBeamU 4.13
The continuous beam analysis spreadsheet, ConBeamU, is now up to version 4.13 with some minor bug-fixes, and the addition of a non-linear option for the BeamAct functions. See ConBeamU for more details of the functions available in the spreadsheet. Download … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged BeamAct functions, continuous beams, Excel, non-linear analysis, Strand7, UDF, VBA
7 Comments
February Links
Two new links with valuable free resources: .net and office automation follies : including many advanced VBA resources. Thanks to Alfred Vachris for the link. AET VBE Tools : Tools for the Visual Basic editor from Andrew Engwirda (via Daily Dose of … Continue reading
Debugging with xlwings and PyCharm
The xlwings documentation covers de-bugging, but it is very brief and it took me some time to get everything working, so this article covers the process in a bit more detail. The details are affected by the editor being used, … Continue reading
Posted in Excel, Link to Python, UDFs, VBA
Tagged debugging xlwings, Excel, PyCharm, Python, UDF, VBA, xlwings
Leave a comment
The Conjugate Beam Method
The Conjugate Beam Method is a variation of the Moment-Area Method that allows beam slopes and deflections to be calculated purely from the calculation of shear forces and bending moments of the beam with (in some cases) modified support conditions. Both methods were … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton
Tagged Beam deflections, Conjugate Beam Method, Excel, Mohr
6 Comments
Newton Excel Bach, not (just) an Excel Blog 