Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Alternative iterative solvers
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Latex Maths Text in Excel
- Automating chart scale limits - update
- 3D Frames, axes and stiffness matrices
- Cubic Splines
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Taming Symbols in Excel
- Reinforced Concrete Section Analysis - with prestress
Recent Comments
Category Archives: Finite Element Analysis
Applied Mechanics of Solids
Applied Mechanics of Solids is a free text on finite element analysis by Allan F Bower, who seems to have a gift for clear explanation of the topic combined with a wry sense of humour; not a combination you see every … Continue reading
Frame Analysis with Excel – 7; Shear deflections and support displacements
Continuing from: Frame Analysis with Excel – 6; Beam end releases and actions Download Frame4.zip – the download file includes complete open source code. Two more refinements have been added to the frame analysis spreadsheet: The stiffness matrix has been revised to … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Finite Element Analysis, Frame Analysis, VBA
31 Comments
Frame Analysis with Excel – 6; Beam end releases and actions
Continuing from: Frame Analysis with Excel – 5; Large frames in Excel 2003 Download Frame3.zip – the download file includes complete open source code. The frame analysis spreadsheet presented previously has now been revised to deal with beam end releases (either rotation or translation) … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
4 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
Will it Fall Over?
Is the arch in the picture below stable, or has it been created in Photoshop, or perhaps with the assistance of some glue or external straps? A simple analysis suggests that tension will be generated at the bottom of the … Continue reading
Posted in Arch structures, Finite Element Analysis, Newton, Ray Tracing
Tagged Arch structures, Finite Element Analysis
2 Comments