Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Time in hours and minutes between two dates
- Daily Download 13: The ALGLIB maths library and Excel
- 3D Frames, axes and stiffness matrices
- Using LINEST for non-linear curve fitting
- Downloads by category
- Biaxial bending update
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
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
Category Archives: Strand7
Using Excel with Python and ctypes
The Strand7 API provides an interface between the Strand7 Finite Element Analysis program and external software. It works with many different languages, including Python, which uses ctypes to transfer data to and from the API functions. It is essential that … Continue reading
Posted in Beam Bending, Excel, Link to dll, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged ctypes, Excel, Python, PyXLL, Strand7 API, UDF
Leave a comment
Dancing Pendulums Revisited
I have previously posted on Dynamically Defined Dancing Pendulums, using the Strand7 FEA program to generate the motion of a series of pendulums of varying length. I have now updated that video using the latest Beta version of the program (Rel … Continue reading
Posted in Animation, Finite Element Analysis, Frame Analysis, Newton, Strand7
Tagged avi, dynamic analysis, mp4, Pendulum animation, Snagit, Strand7
Leave a comment
64 bit Excel and the Strand7 API
Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results. A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7
Tagged 64 bit Excel, Strand7 API
Leave a comment
Section Properties with MeshPY, including torsion and warping
I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants. The program uses the MeshPY Library for generating the finite element meshes required … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings
Tagged Excel, MatPlotlib, MeshPY, Python, section properties, Torsion, UDF, VBA, Warping
7 Comments
3DFrame update
The update to the Glob_to_loc3 and Loc_to_glob3 functions (and associated functions) has now been transferred to the 3DFrame spreadsheet, which will now give correct results when beams are defined in the global negative Z direction. The revised spreadsheet (including full … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA
Tagged 3D frame analysis, Excel, moment release, spring end release, Strand7, VBA
14 Comments