### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Downloads
- The meaning of = in Python
- Drawing in Excel 7 - Creating drawings from coordinates
- Frame Analysis with Excel - 4, 2D frame analysis

### Recent Comments

dougaj4 on The meaning of = in Pytho… Doug Glancy on The meaning of = in Pytho… Emergence of Special… on Daily Download 8: Drawing in… ConBeamU 4.13 | Newt… on ConbeamU 4.10 dougaj4 on ConbeamU 4.10 44steps on ConbeamU 4.10 Alberto on ConbeamU 4.10 dougaj4 on ConbeamU 4.10 Alberto on ConbeamU 4.10 dougaj4 on A Loopy Link (and three m… Christy Moore sings… on Fine as a Bee’s win… Doug Glancy on Some thoughts on Magic … Doug Glancy on A Loopy Link (and three m… Princeton University on Solving cubic and quartic equa… Alberto on ConbeamU 4.10

# Category Archives: Coordinate Geometry

## Nearest Lookup Function

The Excel Lookup functions (including VLookup, HLookup and Match) all allow for an “exact” or “closest” match on numerical data, but the closest option has a number of problems: The data must be sorted For VLookup and HLookup the data … Continue reading

Posted in Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged Dist, Excel, HLookup, Match/Index, Nearest, Problems with Lookups, UDF, VBA, VLookup
2 Comments

## IP2 and IP2_py

The IP2 spreadsheet provides functions to calculate: Intersection points of 2D lines or polylines Intersection points of 2 circles, or a line and a circle Intersection circle of two spheres and intersection points of 3 spheres 3D centre point of … Continue reading

## Dividing shapes into layers

For reasons that will become apparent in a later post, I need to rotate irregular polygons, defined by the coordinates of each corner, by a specified angle, and then split the resulting shape into horizontal trapezoidal layers. I have written … Continue reading

Posted in Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged divide shape into layers, Excel, rotate coordinates, section properties, UDF, VBA
8 Comments

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

## The angle between two vectors, Python version

I posted a VBA function to return The angle between two vectors, in 2D or 3D last year, and have just discovered that Python and Numpy are lacking this function. Since all the suggested code I found in a quick search used: Cos θ … Continue reading

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, NumPy and SciPy
Tagged angle between two vectors, Numpy, Python, PyXLL
10 Comments

## Xlls, Maths and Plots; some useful links

Two from regular commenter here, Keith Lewis: Excel xll add-in library: This is a library for creating xll add-ins for Excel from 97 through 2013. It makes every feature of the latest Excel SDK available to you including the big … Continue reading

Posted in Coordinate Geometry, Excel, Link to dll, Maths, Newton
Tagged links, Maths, plotting, xll
3 Comments

## Section properties for groups of defined shapes

Following a discussion at Eng-Tips, I have modified the section properties spreadsheet (presented here) so that section properties can be found for groups of defined shapes, including provision for translation and rotation of each shape, and application of different E … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, section properties, section properties of multiple shapes, VBA
8 Comments