Recent Comments
Author Archives: dougaj4
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
Some thoughts on Magic …
… from Alana Hicks, Leonard Cohen, and Buffy St Marie. Alana Hicks is a friend of my daughter’s. This is her story: … which reminded me of a song I heard once on the radio over 40 years ago, and … Continue reading
Posted in Bach
Tagged Alana Hicks, Buffy Sainte-Marie, Leonard Cohen, Magic, Magic is Afoot, Smoke and Fire
2 Comments
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
3D Frame analyses with spring releases – 2
The latest version of the 3DFrame spreadsheet (previously presented here) includes provision for spring end releases, allowing for either rotational or translational springs in any direction. These springs are now incorporated in the model by adjustment of the beam properties, … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 3D frame analysis, Excel, moment release, spring end release, Strand7, VBA
Leave a comment
On the probability of frog croaks.
A recent logical puzzle from TED discussed the probability of one of two frogs being female, if we know that at least one of them is male: This puzzle is discussed (arriving at different conclusions) here: and puzzles of this … Continue reading
Posted in Excel, Maths, Newton, VBA
Tagged croaking frog paradox, Probability puzzle, probability spreadsheet
Leave a comment
