Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Using LINEST for non-linear curve fitting
- Daily Download 4: Continuous Beam Analysis
- Cubic Splines
- Daily Download 5: Frame Analysis
- The angle between two vectors, Python version
- Downloads
- About Newton Excel Bach
Recent Comments
Category Archives: Finite Element Analysis
Strand7 API GetNode functions
As promised in this post, I have written and documented Excel User Defined Functions (UDFs) to interface with all the Strand7 API functions that return node attributes or results. These 22 functions allow node attributes and results to be read directly … Continue reading
Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA
Tagged API, Excel, Node Functions, Strand7, UDF, VBA
5 Comments
VBA code generation on the spreadsheet
A previous post looked at using VBA to generate more VBA code. This post looks at automatic code generation on the spreadsheet, which may be transferred into the a VBA project using the techniques discussed in the earlier post, or simply … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged API, code generation, Excel, Strand7, UDF, VBA
Leave a comment
Using the Strand7 API
Strand7 is a general purpose Finite Element Analysis program, which has an Application Programming Interface (API), allowing external programs to interact with Strand7, including reading and writing to data files, running analyses, and reading the results. The API is a comprehensive … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged API, Excel, Finite Element Analysis, Strand7, UDF, VBA
7 Comments
Buckling of Tubes
The video here The Surfing Scientist shows a rough and ready experiment demonstrating the superior strength under axial load of cylindrical tubes, compared with square tubes (skip to 1:30 if you are not interested in the chat). The conclusion about … Continue reading
Posted in Finite Element Analysis, Newton
Tagged buckling, FEA, square tube, Strand7, Surfing Scientist
4 Comments
Dynamically Defined Dancing Pendulums
Following the previous post, I have re-created the animation using a non-linear dynamic analysis inside Strand7, rather than by feeding in the positions of each ball at each time step. The input using this approach is much simpler; just set … Continue reading
Posted in Finite Element Analysis, Newton
Tagged dynamic analysis, Pendulum animation, Strand7
2 Comments