Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Daily Download 13: The ALGLIB maths library and Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Elastic Biaxial Bending
- Using Goal Seek on Multiple Cells
- Time in hours and minutes between two dates
- Downloads
- Cubic Splines
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Elastic Biaxial Bend… on Biaxial bending update Bill Harvey on Floating Point Precision … Floating Point Preci… on When does 35 not equal 35… dougaj4 on mpmath for Excel dougaj4 on mpmath for Excel Kapt Blasto on mpmath for Excel mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… mktisis on 3D Frame with zero stiffness… th3budd on Time in hours and minutes betw… dougaj4 on Moving Load Spreadsheet… Ario on Moving Load Spreadsheet… dougaj4 on About Newton Excel Bach David Graves on About Newton Excel Bach
Tag Archives: API
Daily Download 6: Working with FEA programs
Today’s downloads are three programs for working with Finite Element Analysis (FEA) programs. The first use the Scripting Dictionary Object to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at … Continue reading
Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA
Tagged API, Excel, FEA, Scripting dictionary, Strand7, UDF, VBA
Leave a comment
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
Dancing Pendulums
This animation was produced in response to a video of real pendulums performing similar tricks: Not having an animation program I thought I’d use the finite element program Strand7. Modelling the pendulums was easy, just 15 beam elements with a … Continue reading
Posted in Animation, Excel, Finite Element Analysis, Newton
Tagged animation, API, Pendulum patterns, Strand7
5 Comments