Download Sciensolar


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.5

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


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.5 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 6 modules.
  • Go to the downloaded package, open the file 1_5MODULE_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 6 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: ScienSolar.xlsm

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


Update date: 07-07-2024

Instructions: Download the two text files below, copy their entire contents and replace them accordingly in modules 1 and 2 of the VBA editor. This way of updating does not modify the example projects or the work that has been carried out in the book. 

Files to download:

  1. 1_5MODULE_1.txt
  2. 1_5MODULE_2.txt
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.

User manual