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 25, 2024.
Note: To update, you only need to copy the content of the updated modules and replace it in the VBA editor, this way the work already done will not be affected.

Update to 1.53

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: 05-01-2025

This update requires modifying the macro settings and enabling the Trust access to the VBA project object model option (to enable this option see (in Spanish) image1, image2, image3 ). Replace the contents of MODULE1 and MODULE2 (MODULE1, MODULE2) with the contents of the following files, make sure that the modules to be replaced are MODULE 1 and MODULE 2.

Files to download (right click -> download):

UPDATE FEATURES:

A new procedure CheckIfProjectExists() has been added, which automatically updates the list of projects.
The counter has been made independent from simulations to rotate the coordinates.
A procedure has been implemented to delete the data table when data needs to be extracted in a simulation.

INSTALLATION:

Open the downloaded file 1_53_Update_MODULE_1, sselect all the code, copy it and replace the old code in Module1 in the VBA Editor of the ScienSolar file with the new code. Before replacing, check that the above code has the MAIN MODULE 1 header.
Open the downloaded file 1_53_Update_MODULE_2, select all the code, copy it, and replace the old code in Module2 in the VBA Editor of the ScienSolar file with the new code. Before replacing, verify that the old code has the header MAIN MODULE 2.
Press Reset in the spreadsheet.

User manual