Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using Goal Seek on Multiple Cells
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Removing Add-ins
- Contour plots with Excel and Matplotlib
- Cubic Splines
Recent Comments
Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
Tag Archives: dot product
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
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