ScienSolar: Development of an Open-Source VBA-Excel Based Package to Model 3D Physics Problems Without Coding

Abstract

This study presents a novel modular package developed in Visual Basic for Applications (VBA) that integrates into a macro-enabled MS Excel workbook. This package creates a three-dimensional coordinate system within the spreadsheet, allowing users to model various physics problems efficiently. Designed for users with basic knowledge of MS Excel and fundamental physics knowledge, the package enables rapid model development without the need for programming experience. Users can add vectors to the coordinate system, which can be transformed into other mathematical objects. The package features specialized cells that function as coordinates or time variables. It has been rigorously tested and includes 25 fundamental examples in disciplines such as electrodynamics, mechanics, thermodynamics, optics, and mathematics. This tool significantly simplifies the modeling process and provides an accessible approach to solving complex physics problems.