Developing Excel VBA Functions for the Mathematical Modeling of Three-Dimensional Vectors
Salvato in:
| Pubblicato in: | Analecta Technica Szegedinensia vol. 18, no. 3 (2024), p. 82 |
|---|---|
| Autore principale: | |
| Altri autori: | |
| Pubblicazione: |
Istvan Biro
|
| Soggetti: | |
| Accesso online: | Citation/Abstract Full Text - PDF |
| Tags: |
Nessun Tag, puoi essere il primo ad aggiungerne!!
|
MARC
| LEADER | 00000nab a2200000uu 4500 | ||
|---|---|---|---|
| 001 | 3123503607 | ||
| 003 | UK-CbPIL | ||
| 022 | |a 2064-7964 | ||
| 024 | 7 | |a 10.14232/analecta.2024.3.82-87 |2 doi | |
| 035 | |a 3123503607 | ||
| 045 | 2 | |b d20240101 |b d20241231 | |
| 100 | 1 | |a Fabulya, Zoltán | |
| 245 | 1 | |a Developing Excel VBA Functions for the Mathematical Modeling of Three-Dimensional Vectors | |
| 260 | |b Istvan Biro |c 2024 | ||
| 513 | |a Journal Article | ||
| 520 | 3 | |a 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. | |
| 653 | |a Angles (geometry) | ||
| 653 | |a Functions (mathematics) | ||
| 653 | |a Visual Basic for Applications | ||
| 653 | |a Software | ||
| 653 | |a Variables | ||
| 653 | |a Mars | ||
| 653 | |a Linear algebra | ||
| 700 | 1 | |a Hampel, György | |
| 773 | 0 | |t Analecta Technica Szegedinensia |g vol. 18, no. 3 (2024), p. 82 | |
| 786 | 0 | |d ProQuest |t Engineering Database | |
| 856 | 4 | 1 | |3 Citation/Abstract |u https://www.proquest.com/docview/3123503607/abstract/embedded/7BTGNMKEMPT1V9Z2?source=fedsrch |
| 856 | 4 | 0 | |3 Full Text - PDF |u https://www.proquest.com/docview/3123503607/fulltextPDF/embedded/7BTGNMKEMPT1V9Z2?source=fedsrch |