### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Downloads
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- COM624 download and documentation sites
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- P-Y Curve function

### Recent Comments

# Tag Archives: vectors

## The angle between two vectors, in 2D or 3D

Finding the angle between two lines in 2D is easy, just find the angle of each line with the x-axis from the slope of the line and take the difference. In 3D it is not so obvious, but it can … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged 3D angle, angle between two vectors, cosine rule, Excel, UDF, VBA, vectors
9 Comments

## Daily Download 25: Vector Functions

Today’s download file provides a variety of vector arithmetic functions, which can be used either from other VBA routines, or on the spreadsheet as User Defined Functions. Download file: http://interactiveds.com.au/software/VectorFunc.xlsb In addition to Dot and Cross the spreadsheet contains the following … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged cross product, dot product, Excel, UDF, VBA, vector area, vectors
Leave a comment

## Daily Download 20: Section Properties

The download spreadsheets today provide functions to find section properties of shapes either defined by coordinates or selected from a list of shape types. The section properties found are: area, first and second moments of area about the X and Y … Continue reading

Posted in Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, Section Properties; Area; First Moment of Area; Second Moment of Area, UDF, VBA, vectors
Leave a comment

## Area from Vectors

The previous post looked at User Defined Functions (UDFs) for working with vectors, including examples of functions to find the area of polygons defined by coordinates. In this post the functions will be extended to find other section properties (such … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged Area, coordinates, Excel, section properties, UDF, VBA, vectors
5 Comments

## Dots and Crosses

The comments from Bill Harvey in the previous post prompted me to have a closer look at the functions available in Excel for working with vectors. Here is a complete list of them: =SUMPRODUCT() (Equivalent to the vector dot product) This … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged cross product, dot product, Excel, UDF, VBA, vector area, vectors
11 Comments