ScienSolar
Download
Donate
Modules
FAQ

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

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: 16-Nov-2024

To have version 1.52 from version 1.51 you do not need to install all the code again. Simply update the contents of Module1 in the VBA editor downloaded below. 

Files to download:

UPDATE FEATURES:
 The new procedure CheckIfProjectExists() has been added with the following main functions:

  1. Checks all VBA modules, counts how many projects exist and sets the number of the last project.
  2. Automatically updates the list of projects in the CONFIG sheet.
  3. Remove projects after the last one from the list that do not have code.
  4. Mark the projects that are in the middle and have no code.
  5. The user will no longer have to modify, add or remove projects from the list in CONFIG when adding a new project. When adding a new project code to a module in VBA, ScienSolar will automatically detect it. You just have to verify in the code that the consecutive number is not already occupied. 

INSTALLATION:

  1. Open  the downloaded file, select all the  code, copy it and replace the previous code from Module1 in the VBA Editor of the ScienSolar file with the new one. Before replacing, verify that the old code is titled MAIN MODULE 1.
  2. Press Reset on the spreadsheet.
 

User manual

© ScienSolar, 2023.