首页|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
扫码查看
点击上方二维码区域,可以放大扫码查看
原文链接
NETL
NSTL
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