Developing Excel VBA Functions for the Mathematical Modeling of Three-Dimensional Vectors
Guardado en:
| Publicado en: | Analecta Technica Szegedinensia vol. 18, no. 3 (2024), p. 82 |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Publicado: |
Istvan Biro
|
| Materias: | |
| Acceso en línea: | Citation/Abstract Full Text - PDF |
| Etiquetas: |
Sin Etiquetas, Sea el primero en etiquetar este registro!
|
| Resumen: | The current computer support for operations involving three-dimensional vectors is insufficient, even in widely used programs like Excel. These programs lack customised features specifically designed for vector operations. However, this limitation can be overcome by using the options provided by Visual Basic for Applications. By creating user functions, we can effectively calculate various results related to the mathematical application of vectors. These functions include determining the magnitude and absolute value of a vector, calculating the angle between two vectors or the cosine of that angle, finding the scalar product and vector product of two vectors, and evaluating the mixed product of three vectors. By incorporating these custom functions into the spreadsheet program, users can easily perform mathematical calculations pertaining to three-dimensional vectors. |
|---|---|
| ISSN: | 2064-7964 |
| DOI: | 10.14232/analecta.2024.3.82-87 |
| Fuente: | Engineering Database |