Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
- Automating chart scale limits - update
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Author Archives: dougaj4
Beam actions and deflections, 3D or 2D
Two new functions have been added to the ConBeamU spreadsheet, last discussed here. The new version can be downloaded from ConBeamU.zip, including full open-source code. The new functions, BeamAct3D and BeamAct2D calculate forces, moments, deflections and rotations along a 3D … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 2D beam, 3D beam, beam analysis, BeamAct functions, Excel, UDF, VBA
2 Comments
New Links: Scientific Python and Engineering Excel
The previous post had a link to Cyrille Rossant which is worth a closer look. The blog has many detailed posts on scientific applications of Python, as well as links to Galry: a high performance interactive visualization package in Python and his … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, VBA
Tagged Cyrille Rossant, Engineering spreadsheets, links, Python, Spreadsheets 4 Simulation
Leave a comment
The speed of loops in Python
This post is based on exercises published by Cyrille Rossant in his book “Learning IPython for Interactive Computing and Data Visualization”. Cyril also has a blog well worth looking at: http://cyrille.rossant.net/blog/ (Thanks to Alfred Vachris and Boris Vishnevsky for the links). … Continue reading
Posted in Arrays, Link to Python, NumPy and SciPy
Tagged IPython, Numpy, Pylab, Python, working with arrays
Leave a comment
Jack Orion
This is what Wikipedia says of the music played by The Pentangle: Pentangle are usually characterised as a folk-rock band. Danny Thompson preferred to describe the group as a “folk-jazz band.”[25] John Renbourn also rejected the “folk-rock” categorisation, saying, “One … Continue reading
Frame Analysis with Excel
Starting from 2009 I have posted a series on frame analysis using Excel, starting from a simple “on-sheet” solution and working through to applications able to solve large 2D or 3D problems. To follow the analysis process it is best … Continue reading