### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

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

### Recent Comments

dougaj4 on Buckling of columns with varyi… Marco Valsecchi on Buckling of columns with varyi… Displaying trend lin… on Using LINEST for non-linear cu… RCInteract and RC De… on RC Design Functions 7.03 Larry Schuster on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu…

# 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