Recent Comments
Author Archives: dougaj4
Links to link VBA to C#
If you search the Internet for information on how to link Excel VBA to C# you will find thousands, if not millions, of links with details of how to connect to Excel from C#, but very few about going the … Continue reading
More moves through the fair
Following the last Bach instalment, here are three more versions of She Moves Through the Fair. The first is the “official” Fairport Convention release, with Sandy Denny on vocals. Much more polished than the demo version posted last time, but … Continue reading
Posted in Bach
Tagged Bert Jansch, Davy Graham, Eric Clapton, Fairport Convention, Richard Thompson, Sandy Denny, She Moves Through the Fair
3 Comments
Polynomial Update
Following a comment here: Solving cubic and quartic equations with Excel the Quartic and CubicC User Defined Functions (UDFs) have been amended to fix a problem occurring with some combinations of coefficients. The updated spreadsheet (including full open source code) can be … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Evaluate polynomial, Excel, Jenkins-Traub, Quartic, Solve polynomial, UDF, VBA
12 Comments
Mohr’s Circle and Plate Stresses and Actions
The functions described in this post can be found in the download file PlateStress.zip, including examples and full open source code. The function MCircle returns the plane stress components (XX, YY and XY stress) for any specified stress field, when rotated through a … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged Excel, Gauss Points, Mohr's Circle, Plate stresses, Strand7, UDF, VBA
1 Comment
Newton Excel Bach, not (just) an Excel Blog 