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
- Solving non-linear equations with two or more unknowns – 3
- Writing Arrays to the worksheet - VBA function
Recent Comments
Category Archives: Newton
Dots and Crosses
The comments from Bill Harvey in the previous post prompted me to have a closer look at the functions available in Excel for working with vectors. Here is a complete list of them: =SUMPRODUCT() (Equivalent to the vector dot product) This … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged cross product, dot product, Excel, UDF, VBA, vector area, vectors
11 Comments
Section Properties from Coordinates Without VBA
At the Eng-Tips forum there was a question asking for a calculation of area and centroid values from coordinates without the use of VBA. In my opinion using VBA is much the easiest and most robust way to do it, … Continue reading
Posted in Coordinate Geometry, Excel, Newton, UDFs, VBA
Tagged Area, Centroid, Excel, section properties, UDF, VBA
13 Comments
PaulBourke.net
Another link from Al Vachris: PaulBourke.net. The link above has a general subject index, and google site search; for a full list of the site content go to the detailed site index. Here’s what the author says about it: “The … Continue reading
Posted in Computing - general, Coordinate Geometry, Maths, Newton, Ray Tracing
Tagged computer imaging, Fractals, geometry, PovRay
Leave a comment
Using LatPilePY
LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles. It was presented in this post: LatPilePY. In response to an e-mail request, this post will give step by step instructions for … Continue reading
Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Array Function, COM624, Excel, Laterally loaded pile, Non-linear concrete, UDF, VBA
Leave a comment
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