Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Continuous Beam Spreadsheet - with Units
- Daily Download 2: SLS design of reinforced concrete sections ...
- Daily Download 4: Continuous Beam Analysis
Recent Comments
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… 
dougaj4 on Reinforced concrete elastic an…
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