Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Downloads
- 3DFrame - 3D Frame analysis for Excel
- Filling Blanks with Go To-Special (and local help rant)
- Retrieving unique values from a range or array ...
- Writing Arrays to the worksheet - VBA function
Recent Comments
Category Archives: Newton
Defining beam orientation in 3D
The principal axes of a beam (or any 2D closed shape) are defined as the axes along which an applied load will not cause any deflection in the transverse direction. In mathematical terms, if the beam cross-section is defined in the … Continue reading
The angle between two vectors, in 2D or 3D
Finding the angle between two lines in 2D is easy, just find the angle of each line with the x-axis from the slope of the line and take the difference. In 3D it is not so obvious, but it can … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged 3D angle, angle between two vectors, cosine rule, Excel, UDF, VBA, vectors
9 Comments
Tanh-Sinh Quadrature V4.0
Since last September Graeme Dennes has continued work on his Tanh-Sinh Quadrature spreadsheet, and has recently released Version 4.0, which can be downloaded from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. The new version includes routines … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh method, UDF, VBA
6 Comments
The statement below is false
If you think I’m wrong, try looking at it from a different perspective. The picture above came from an optical illusion blog at: http://www.anopticalillusion.com/ and I was led there from: http://www.josleys.com/index.php which is an amazing collection of mathematical imagery by … Continue reading
Posted in Bach, Maths, Newton, Ray Tracing
Tagged Bach, Fractals, mathematical images, Newton, optical illusions
Leave a comment
Extending Frame4 with on sheet formulas
Still on Frame4, Julien asked if provision could be made for application of local loads, i.e. loads perpendicular to sloping members, rather than just horizontal or vertical. This will actually be incorporated in the spreadsheet “real soon now”, but it … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Frame Analysis, Frame4 spreadsheet, local loads, VBA
3 Comments