Developing Excel VBA Functions for the Mathematical Modeling of Three-Dimensional Vectors
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 Vis...
Elmentve itt :
| Szerzők: | |
|---|---|
| Dokumentumtípus: | Cikk |
| Megjelent: |
2024
|
| Sorozat: | ANALECTA TECHNICA SZEGEDINENSIA
18 No. 3 |
| Tárgyszavak: | |
| doi: | 10.14232/analecta.2024.3.82-87 |
| mtmt: | 35485653 |
| Online Access: | http://publicatio.bibl.u-szeged.hu/35009 |
| LEADER | 01690nab a2200229 i 4500 | ||
|---|---|---|---|
| 001 | publ35009 | ||
| 005 | 20241030113252.0 | ||
| 008 | 241030s2024 hu o 000 eng d | ||
| 022 | |a 1788-6392 | ||
| 024 | 7 | |a 10.14232/analecta.2024.3.82-87 |2 doi | |
| 024 | 7 | |a 35485653 |2 mtmt | |
| 040 | |a SZTE Publicatio Repozitórium |b hun | ||
| 041 | |a eng | ||
| 100 | 1 | |a Fabulya Zoltán | |
| 245 | 1 | 0 | |a Developing Excel VBA Functions for the Mathematical Modeling of Three-Dimensional Vectors |h [elektronikus dokumentum] / |c Fabulya Zoltán |
| 260 | |c 2024 | ||
| 300 | |a 82-87 | ||
| 490 | 0 | |a ANALECTA TECHNICA SZEGEDINENSIA |v 18 No. 3 | |
| 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. | |
| 650 | 4 | |a Számítás- és információtudomány | |
| 700 | 0 | 1 | |a Hampel György |e aut |
| 856 | 4 | 0 | |u http://publicatio.bibl.u-szeged.hu/35009/1/82-87_Fabulya_Hampel.pdf |z Dokumentum-elérés |