### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- The angle between two vectors, Python version
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Retrieving unique values from a range or array ...
- Combining arrays
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Downloads by category

### Recent Comments

Suelio Josileissu on Stepping through Python code c… dougaj4 on Stepping through Python code c… dougaj4 on 3DFrame – 3D Frame analy… jawadcharsadda on 3DFrame – 3D Frame analy… Suelio Josileissu on Stepping through Python code c… pyxll on Stepping through Python code c… More Python Traps |… on The meaning of = in Pytho… More Python Traps |… on Python Traps Using LINEST for non… on LinEstGap with non-linear… dougaj4 on Using LinEst() on data with… LinEstGap with non-l… on Fitting high order polyno… LinEstGap with non-l… on Using LinEst() on data with… dougaj4 on Using LinEst() on data with… Charlene Van Wyngaar… on Using LinEst() on data with… dougaj4 on DigitGraph Spreadsheet and Web…

# 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