Download Sciensolar

COPYRIGHT AND TERMS OF USE

ScienSolar © PhD Ariel R. Becerra B., 2022.

By downloading the package you agree to the terms and conditions under the license.

GNU General Public License v.3.0

Download ScienSolar 1.51

Update date: Oct 16, 2024.
Note: To update, you only need to copy the content of the first two modules (1_51MODULE1 and 1_51MODULE2) and 1_51MODULE7 and replace it in the VBA editor, this way the work already done will not be affected.

Update

Installation instructions:

Video (in spanish)

Make sure you don’t have any MS Excel activation issues. Macros only work if Excel is properly activated. For 3D models it is necessary to have a version of Excel 2019 or later, other models can work with previous versions.
Disable antivirus while installing.
Click on the link above to download the ScienSolar 1.51 package.
Open a new workbook in MS Excel.
Go to the Visual Basic (VBA) editor (Alt + F11 on Windows or Fn + Option + F11 on macOS).
In the VBA editor, in the project explorer on the left, right click and insert module. Insert 8 modules.
Go to the downloaded package, open the file 1_51MODULE_1, select all contents, copy and paste into VBA in the first module.
Do the same procedure for the other files, pasting the content of each one in a separate module until you have completed the 8 files.
Go to the Excel sheet, in the DEVELOPER tab insert a new button in the sheet. (If the PROGRAMMER or DEVELOPER tab is not enabled, you can enable it in the Excel menu, in Preferences or Options, Toolbar and Ribbon, in the list that appears on the right select DEVELOPER (PROGRAMMER).
When you press Insert button, you must touch some part of the sheet area to place the button. A window will appear requesting the name of the macro to be assigned to the button. Select the NewSheet macro. Press OK.
Then press the button. The ScienSolar interface will appear in the Spreadsheet.
Open the 3DModels book that comes with the package, then, on the 3DModels sheet name, right click and make a copy to the new book where it was copied in code. This sheet contains some items required for some models.
Save the new workbook as a macro-enabled workbook on your desktop or in a different folder than your downloads folder.

Other ways to download:

Download the file with the code already included: ScienSolar1_51.xlsm

Note: If the file does not open correctly, use the method described above to install it.

Update:

Update date: 26-Sep-2024

Instructions: Download the three text files below, copy the contents of the first two and replace them accordingly in modules 1 and 2 of the VBA editor. For the third file create a new module in the VBA editor and copy its contents there. This way of updating does not modify the example projects or the work that has been carried out in the book. The third file contains a new module for calculating differential operators (follow the instructions at the beginning of the module 7 code).

Files to download:

UPDATE FEATURES:
Improvement in the visualization of the field mode, the parameters are automatically generated according to the ongoing project, the user no longer has to experiment much to obtain a good visualization of the field. The module 2 was added for calculation of Dif Operators.

User manual