# 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

| | 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 | | 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 | | 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 | | 5 Comments