Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
- Writing Arrays to the worksheet - VBA function
- Linking Excel to C - 2
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
Tag Archives: Strand7
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 – 2
Following on from yesterday’s post, today we’ll look at the buckling of the cylindrical tubes: The tube in this analysis was defined to have a small (0.01 mm) asymmetric bulge at mid height, to initiate buckling. The video shows that … Continue reading
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