Creating Excel VBA Functions for the Mathematical Application of Three-dimensional Vectors

Abstract

Computer support of three-dimensional vector operations is inadequate. Even Excel spreadsheet program, used by many, does not have customized services for vector operations. This defect can be solved with the options provided by Visual Basic for Applications in Excel. We can create user functions to calculate results related to the mathematical application of vectors:

• The size and the absolute value of vectors


• The angle between two vectors and the cosine of the angle


• The scalar product of two vectors


• The vector product of two vectors


• The mixed product of three vectors

The created user functions will be available in the spreadsheet program in the usual way, providing the simple execution of the mathematical calculations in the area of the three-dimensional vectors.