Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
- About Newton Excel Bach
- Retrieving unique values from a range or array ...
- Downloads
- Writing Arrays to the worksheet - VBA function
Recent Comments
Tag Archives: 3D coordinates
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
Finding Circle Centres in 3D
In 2 new functions for IP.xls I described two Excel User Defined Functions (UDFs) to find the radius and centre of a circle defined by 3D coordinates for either 3 points on the circumference, or for two tangent points and the … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged 3D coordinates, Center, Circle Centre, direction cosines, Excel, IP2.xls, Radius, UDF, VBA
5 Comments