In this list are all the models and modules developed so far in ScienSolar.
To add models that you can't find in your ScienSolar package, copy the content of the model into the two Text files and, in the VBA editor of the book with ScienSolar, add a new module and paste the copied content there. In a clean VBA module, 5 to 10 models can be glued, depending on their size.
You can create your own list by eliminating the models you don't need. To do this, delete the content of the modules in VBA from 3 to 8 in and distribute there the models you require from the list described here. Models 2 and 15 should not be modified or deleted, or if you delete them, add them again without making any modification. The other models can be changed the number in the header of the code, but always taking into account that each model has its version in Spanish (ES) and English (EN). Just change the number. Make sure you do this correctly and then rearrange the list on the CONFIG sheet. In this sheet there is a button to make an automatic update, however, for this button to work, you need trusted access to the objects in the Excel macro settings.
In the VBA editor, the first two modules contain the main code of ScienSolar and should not be modified so as not to alter its operation, unless you are an expert.
Area: ScienSolar - additional modules
This module is downloaded to other modules or is accompanied by other vectors that contain scalar and vector fields. The module allows you to make several operations to these fields, including: gradient, divergence, rotational, derivative with respect to time, Laplace operator, scalar product and vector product. It also allows the mixing of these operators and in most cases verifies that this mixture is mathematically correct.
The module is in the default list of ScienSolar, VBA, module 7.
Area: Vector analysis
Addition (sum) of any number of vectors. You can expand the model for addition and multiplication properties by a number.
The model is in the default list of ScienSolar, VBA, module 3.
Area: Vector analysis
Addition (sum) of any number of vectors showing their projections and exchanging the head-tail shape. You can expand the model for addition and multiplication properties by a number.
The model is in the default list of ScienSolar, VBA, module 3.
Area: Vector analysis
Vector multiplication (cross product) of two arbitrary vectors in three-dimensional space.
The model is in the default list of ScienSolar, VBA, module 3.
Area: Vector analysis
Unit vector of any vector in three-dimensional space.
The model is in the default list of ScienSolar, VBA, module 3.
Area: Mathematics of programming
The equations are modeled to rotate any vector around an axis with a unit vector.
The model is in the default list of ScienSolar, VBA, module 3.
Area: Mathematics of programming
The equations are modeled to rotate any vector around a unit vector, which in turn is found in another vector that rotates. The number of simulation vectors is increased with the +OBJ button. Each vector can be drawn its trajectory
The model is in the default list of ScienSolar, VBA, module 3.
Area: Mathematics of programming
The equations are modeled to rotate any vector tangentially around a unit vector.
The model is in the default list of ScienSolar, VBA, module 3.
Area: Vector analysis
The equations are modeled for conversion of Cartesian coordinates to cylindrical and vice versa.
The model is in the default list of ScienSolar, VBA, module 3.
Area: Vector analysis
The equations for converting Cartesian coordinates to spherical coordinates and vice versa are modeled.
The model is in the default list of ScienSolar, VBA, module 4.
Area: Vector analysis
A vector field of flat symmetry is modeled. The field is better visualized in Cartesian coordinates. The user can configure it to see it in other coordinates.
The model is in the default list of ScienSolar, VBA, module 4.
Area: Vector analysis
A vector field of cylindrical symmetry is modeled. The field is best visualized in cylindrical coordinates. The user can configure it to see it in other coordinates.
The model is in the default list of ScienSolar, VBA, module 4.
Area: Vector analysis
A vector field of spherical symmetry is modeled. The field is better visualized in spherical coordinates. The user can configure it to see it in other coordinates.
The model is in the default list of ScienSolar, VBA, module 4.
Area: ScienSolar - additional modules
This module is downloaded to any existing model and allows you to draw paths of objects moving during a simulation. The path becomes Excel form immediately after the simulation is finished. This module cannot change its number in the code header (number 15) because ScienSolar uses this number to perform special tasks with it.
The module is in the default list of ScienSolar, VBA, module 4.
Area: Electricity, mechanics.
The movement of a charged point particle is modeled, which moves in a constant electric field of any orientation in space. The model can easily be adapted to the movement of a projectile in a gravitational field.
The model is in the default list of ScienSolar, VBA, module 4.
Area: Mathematical modeling in ScienSolar.
The model shows how 3D Excel models (2019 and later) can be integrated into ScienSolar. The process is simple, download the 3D model to the 3DModels sheet and integrate it into the ScienSolar model, as shown in cells B15 (object name), B16 (always equal to 200), B17 (model size), A18 and B18 (rotation angles) of this model.
The model is in the default list of ScienSolar, VBA, module 4.
Area: Geometric optics
Simulation of the behavior of an image of an object in a lens (concave or convex) according to the position of the object. The parameters can be modified: focal length, position and height of the object, visualization of optical rays, fixation of the trajectory of both the object and the image when moving them consecutively.
The model is in the default list of ScienSolar, VBA, module 4.
Area: Geometry
Through the simulation of a dynamic pyramid of n polygons, in which faces can be increased or decreased by pressing the +OBJ and - OBJ buttons, the possibility of modeling almost any three-dimensional geometric figure without the need for programming, only with the functions of Excel + ScienSolar is demonstrated.
The model is in the default list of ScienSolar, VBA, module 4.
Area: Mathematics and physics
Elaboration of graphs of three-dimensional functions. In this case, the thermodynamic equation of the gases is simulated, specifically the dependence P(V,T)
The model is in the default list of ScienSolar, VBA, module 4.
Area: Mathematics and physics
With this model, the user can enter in the list the functions he wants to graph, along with their parameters and variables. Several functions can be entered into the list and saved in the model.
The model is in the default list of ScienSolar, VBA, module 5.
Area: basic physics, chemistry and engineering
Simulation model of the behavior of the main parameters of a battery: FEM concept, calculation of its capacity, amount of electrolyte, amount of charge. Behavior of the potential within the battery. Conservation of charge and chemical balance.
The model is in the default list of ScienSolar, VBA, module 5.
Area: Electrostatic
The model calculates the electrical force experienced by a point charge by other charges distributed in the three-dimensional space. Charges are added by pressing a button and the force is calculated automatically. The charge limit is subject to the computational capacity of the user and not to the model. The components of each force of each pair of charges and of the resulting force are calculated. The phenomenon can be viewed from any 3D view.
The model is in the default list of ScienSolar, VBA, module 5.
Area: Electrostatic
The model calculates the electric field of point charges distributed in the three-dimensional space. Charges are added by pressing a button and the field is calculated automatically. The charge limit is subject to the computational capacity of the user and not to the model. The components of the field of each charge and of the resulting field are calculated numerically. The phenomenon can be viewed from any 3D view. The field can also be seen in a region of space such as the one shown in the figure.
The model is in the default list of ScienSolar, VBA, module 5.
Area: Magnetostatic
Two rectilinear current elements are distributed in space and the magnetic force between them is calculated. The supposed violation of Newton's third law in certain orientations of the elements is modeled, which is explained because the modeled currents are not closed, which is contrary to reality.
The model is in the default list of ScienSolar, VBA, module 6.
Area: Magnetostatic
The behavior of a rectangular spiral with current, which is in a constant magnetic field, is modeled. The magnetic forces that act on the four segments of the current are observed, causing it to rotate. The equation F=ILB is studied. Magnetic moment of the spiral. Potential energy of the coil.
The model is in the default list of ScienSolar, VBA, module 6.
Area: Magnetostatic
The model calculates the magnetic field at any point in space of various currents of any spatial configuration. The law of Biot - Savart is used. The components of the resulting magnetic field vector are found, as well as, simultaneously, the components of the field of each current element that composes each current. The field can be viewed in a region of space.
The model is in the default list of ScienSolar, VBA, module 6.
Area: Electrostatic Field
The model calculates the electric field at any point in space of several linear charge distributions of any spatial configuration. Coulomb's law is used for the electric field. The components of the resulting field vector are found, as well as, simultaneously, the components of the field of each charge element that composes each distribution. The field can be viewed in a region of space.
The model is in the default list of ScienSolar, VBA, module 8.
Area: Electrostatic
This model is the same model 25, but adapted to atomic dimensions.
The model is in the default list of ScienSolar, VBA, module 8.
Area: Electrodynamics
Model of a flat electromagnetic wave. Both the real part and the imaginary part of the equations that describe the wave can be visualized. The physical sense is only the real part.
The model is in the default list of ScienSolar, VBA, module 8.
Area: Magnetstatic
The model calculates the magnetic field of currents in toroidal form by means of the Law of Biot - Savart. You can modify the two radii of the toroid, the current, its position. Several toroidal currents can be added to the system.
The model is in the default list of ScienSolar, VBA, module 8.
Area: Differential operators
Model with different examples to use module 2, differential operators.
The model is in the default list of ScienSolar, VBA, module 8.
Area: Magnetic field
Simulation of the magnetic field of a current element that belongs to a circular coil. The field is calculated at any point in the space.
The model is not in the default list. To install it, copy the contents of the files to a new module in VBA and update the list in the CONFIG sheet. Visit the installation instructions page.
Area: Electricity and Magnetism
Numerical calculation with analytical formulas of the potential of several point charges distributed in space.
The model is not in the default list. To install it, copy the contents of the files to a new module in VBA and update the list in the CONFIG sheet. Visit the installation instructions page
Area: Electricity and Magnetism
Study of the movement of charged particles in electric and magnetic fields oriented in space in different directions. Speed selector and mass spectrometer. Some mutual orientations of E, v and B may not be available.
The model is not in the default list. To install it, copy the contents of the files to a new module in VBA and update the list in the CONFIG sheet.Visit the installation instructions page.
Area: Electricity and Magnetism
The model calculates the electric force on a charge Q by influence of several linear distributions of charge of any spatial configuration. The model initially starts from a small distribution, but the user has the possibility to lengthen it and give it the desired shape. You can also multiply the distributions with the help of the Clone All button.
The model is not in the default list. To install it, copy the contents of the files to a new module in VBA and update the list in the CONFIG sheet. Visit the installation instructions page
Area: Mathematics
Model code:
Construction of a paraboloid through points in space, with data output from the heights as a function of x, y. Parameters: focal length, dimensions, point resolution,
The model is not in the default list. To install it, copy the contents of the files to a new module in VBA and update the list in the CONFIG sheet. Visit the installation instructions page.
© ScienSolar, 2023.