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

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

扫码查看
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.

physics in MS Excelphysics modelingsciensolar

Ariel R. Becerra Becerra、Alvaro Herrera Carrillo

展开 >

Grupo Integrar, Departamento de Fisica, Universidad de Pamplona, Pamplona, Norte de Santander, Colombia

Facultad de Ciencias Exactas y Naturales, Universidad de Antioquia, Medellin, Antioquia, Colombia

2025

Computer applications in engineering education

Computer applications in engineering education

ISSN:1061-3773
年,卷(期):2025.33(3)
  • 25