### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category
- Fitting high order polynomials
- Using LinEst() on data with gaps

### Recent Comments

# Tag Archives: IP2.xls

## Global to Local for plates (and three node beams)

The Glob_to_Loc function (see Converting from global to local coordinates (and vice versa) ) converts forces and deflections of a beam from the global coordinate system to the local system, defined by the longitudinal axis of the beam and a rotation angle … Continue reading

Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Strand7, UDFs, VBA
Tagged Excel, Glob_to_Loc3, IP2.xls, Loc_to_Glob3, Python, PyXLL, UDF, VBA
3 Comments

## Geometry for Joiners

A question came up on the ABC Self-Service-Science Forum, asking for a solution to find the dimensions of a diagonal brace looking like the diagram below: The solution is not as simple as it might look because the angle of … Continue reading

Posted in Coordinate Geometry, Excel, Newton, UDFs, VBA
Tagged circle intersection, Excel, Framebrace.xlsb, geometry, IP2.xls, UDF, VBA
1 Comment

## More 3D Intersections and 3D plotting function

Following the previous post, I have added several new functions connected with intersections of lines and planes, and a function to generate a perspective plot from 3D coordinates. The new functions have been added to the IP2.xls worksheet, which can … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, intersections, IP2.xls, lines, perspective view, planes, UDF, VBA
7 Comments

## 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