Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- Taming Symbols in Excel
- Frame Analysis with Excel 1 - Single beam
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- Solving non-linear equations with two or more unknowns – 3
Recent Comments
Category Archives: Newton
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
Using Beam Design Functions
“Beam Design Functions” is an Excel spreadsheet providing a User Defined Function (UDF) that will calculate the stresses, strains, forces and moments in a reinforced or prestressed concrete section subject to any specified bending moment and axial load, using an … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Beam Bending, elastic analysis, Excel, Prestressed concrete, Reinforced Concrete, Section Analysis, UDF, VBA
12 Comments
Spline Interpolation Alternatives
A recent post at Jon Peltier’s Blog looks at an “on-sheet” method of performing linear interpolation on a set of tabular data, and the following comments include a number of alternative ways of carrying out the same process, and also some … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic splines, curve fitting, Excel, Interpolation, UDF, VBA
7 Comments
Yet more new links
Cosmic Horizons is about what’s going on within our Event Horizon, and In the Dark is a blog about the Universe, and all that surrounds it, so that just about covers everything I suppose. Have a look, they aren’t just your usual … Continue reading
Area from Vectors
The previous post looked at User Defined Functions (UDFs) for working with vectors, including examples of functions to find the area of polygons defined by coordinates. In this post the functions will be extended to find other section properties (such … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged Area, coordinates, Excel, section properties, UDF, VBA, vectors
5 Comments