### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Time in hours and minutes between two dates
- Fitting high order polynomials
- Combining arrays
- Import Data from a Picture to Excel

### Recent Comments

dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw… SDAmy on Time in hours and minutes betw… Concrete Stress Bloc… on Equivalent Stress Blocks Concrete Stress Bloc… on Stress blocks in AS 3600 Section Properties f… on Using Section Properties-… dougaj4 on ULS Design Functions and … dougaj4 on ULS Design Functions and … dougaj4 on Using LinEst() on data with… Eduardo Torres on Using LinEst() on data with… DonB on ULS Design Functions and … DonB on ULS Design Functions and … James D on ULS Design Functions and …

# 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