Recent Comments
Tag Archives: Excel
Frame Analysis with Excel – 3, Continuous beam or frame
Continuing from Frame Analysis with Excel 2 – Single inclined beam Download Beam3.zip – the download file includes complete open source code. The spreadsheet for a single inclined beam presented in the previous post has been modified to deal with up … Continue reading
Posted in Excel, Frame Analysis, Newton, VBA
Tagged Excel, Finite Element Analysis, Frame Analysis, VBA
30 Comments
Frame Analysis with Excel 2 – Single inclined beam
This post continues from – Frame Analysis with Excel 1 – Single beam Download Beam2.zip The stiffness matrix shown in the previous post was for a single beam with loads applied either perpendicular to the beam, or along the longitudinal beam axis, … Continue reading
Posted in Excel, Frame Analysis, Newton, UDFs
Tagged Excel, Finite Element Analysis, Frame Analysis, UDF
11 Comments
Frame Analysis with Excel 1 – Single beam
Download Beam1.zip This is the first of a series of posts in which I will develop a structural frame analysis program operating within Excel. The first few stages will be mostly spreadsheet based, with later stages using VBA routines to … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, Uncategorized
Tagged Excel, Frame Analysis, structural analysis, UDF
14 Comments
Excel 2007 performance – Microsoft looking for feedback
The latest post on the Microsoft Excel Blog is asking for comment on slow performance of Excel 2007, specifically related to VBA: Microsoft Excel Blog I encourage everyone to respond!
Drawing in Excel 8 – scaling and trimming
Previous Post – Drawing in Excel 7 Download PlotXY-xls.zip (XL 2003 and earlier) Download PlotXY-xlsb.zip (XL 2007) The previous post presented VBA routines to plot drawings in Excel from a series of coordinates, a list of connected points, and a … Continue reading
Newton Excel Bach, not (just) an Excel Blog 