Developing Excel VBA Functions for the Mathematical Modeling of Three-Dimensional Vectors

Zoltán Fabulya; György Hampel

doi:10.14232/analecta.2024.3.82-87

Authors

Zoltán Fabulya University of Szeged Faculty of Engineering https://orcid.org/0000-0003-2309-1075
György Hampel University of Szeged Faculty of Engineering https://orcid.org/0000-0003-0550-1878

DOI:

https://doi.org/10.14232/analecta.2024.3.82-87

Keywords:

Excel VBA, programming, vector operations

Abstract

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.

Downloads

Download data is not yet available.

References

B. L. Matteson, Microsoft Excel Visual Basic Programmer’s Guide, Microsoft Press, Washington, 1995

G. Kovalcsik, Az Excel programozása / Programming in Excel, Computerbooks, Budapest, 2005

M., Alexander, D., Kusleika, Excel 2016 Power Programming with VBA, John Wiley & Sons, Inc., Hoboken, New Jersey, 2016

R., Mansfield, Mastering VBA for Microsoft Office 365, 2019 Edition, John Wiley & Sons, Inc., Hoboken, New Jersey, 2019 https://doi.org/10.1002/9781119579366

J., Walkenbach, Excel 2016 Bible (1st ed.), John Wiley & Sons, Inc., Hoboken, New Jersey, 2015

B. Zsótér, I. Túri, Economical calculations related to a smoking technology investment of a pork processing plant. Annals of Faculty of Engineering Hunedoara – International Journal of Engineering 15 (4) (2017), pp. 57-61.

B. Zsótér, A. Tóth, Examination of statisfaction related to investments (2006-2011) accomplished by the local council in Abony, Analecta Technica Szegedinensia 8 (1) (2014), pp. 33-37. https://doi.org/10.14232/analecta.2014.1.33-37

Gy. Hampel, Excel alkalmazása normális eloszlás tesztelésére Shapiro-Wilk próbával / Using Excel to Test Normal Distribution with Shapiro-Wilk Test, Jelenkori társadalmi és gazdasági folyamatok / Current social and economic processes, 13 (1-2) (2018), pp. 77-82. https://doi.org/10.14232/jtgf.2018.1-2.77-82

Gy. Hampel, Egymintás t-próba programozható kialakítása Excel VBA környezetben / Designing Programmable One-Sample t-Test in Excel VBA Environment, Jelenkori társadalmi és gazdasági folyamatok / Current social and economic processes, 13 (3-4) (2018b), pp. 169-175. https://doi.org/10.14232/jtgf.2018.3-4.169-175

Z. Fabulya, Hőkezelési folyamatok összehangolása Excel VBA szolgáltatásokkal / Coordination of Heat Treatment Processes with Excel VBA Services, Jelenkori társadalmi és gazdasági folyamatok / Current social and economic processes, 12 (4) (2017), pp. 19-25. https://doi.org/10.14232/jtgf.2017.4.19-25