ScienSolar
Download
Donate
New Models
FAQ
Models list

Download Sciensolar

Physics simulation package for MS Excel, free and with no usage limits. By downloading the package, you agree to the terms under the license

GNU General Public License v. 3.0

 
📥 Install from Scratch🔄 Update Previously Installed VersionsNotes
If the quick option does not work, install ScienSolar using the first option.To update any module, download it and replace it in the VBA editor. Right-click to download.📹 Installation Video
📖 User Manual

Download version 1.54:
(16-03-2025)

First option:

🔹 ScienSolar1_54.zip

(see instructions below)


Quick option:

🔹 ScienSolar1_54.xlsm

Update to version 1.54:
(16-03-2025)

Modules 1 and 2 belong to the ScienSolar program and must be updated together. The other modules contain the model codes.

🔹 MODULE 1 (09-03-2025)
🔹 MODULE 2 (09-03-2025)
🔹 MODULE 3 (09-03-2025)
🔹 MODULE 4 (09-03-2025)
🔹 MODULE 5 (01-04-2024)
🔹 MODULE 6 (09-03-2025)
🔹 MODULE 7 (16-10-2024)
🔹 MODULE 8 (09-03-2025)

Main updates in v. 1.54:

  • New function to delete the data table.
  • Added RenameSheet() procedure to rename the current sheet according to the project.
  • Added a button in CONFIG to update the project list when new ones are added.
  • Fixed some reported errors.
Download ScienSolar 1.53 (25-10-2024) Update to 1.53
🔹 MODULE 1 (25-10-2024)
🔹 MODULE 2 (25-10-2024)		 
 

 

First Option Installation Instructions:

Video

  • The package only works on PCs and laptops with MS Excel enabled for macros. It does not work on mobile devices.
  • Make sure there are no activation issues with MS Excel. Macros only work if Excel is properly activated. For 3D models, Excel 2019 or later is required; other models may work with earlier versions.
  • Disable antivirus while installing.
  • Click the link above to download the compressed ScienSolar 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 a module. Insert 8 modules.
  • Go to the downloaded package, open the file 1_XXMODULE_1, select all content, copy and paste it into VBA in the first module.
  • Repeat the same procedure for the other files, pasting the content of each into a separate module until all 8 files are copied into 8 modules.
  • Go to the Excel sheet, in the DEVELOPER tab, insert a new button on the sheet. (If the DEVELOPER tab is not enabled, enable it in Excel’s menu under Preferences or Options, Toolbar and Ribbon, then select DEVELOPER from the list on the right).
  • When inserting the button, click anywhere on the sheet to place it. A window will appear asking for the macro name to assign to the button. Select the macro NewSheet and click OK.
  • Then press the button. The ScienSolar interface will appear in the spreadsheet.
  • Open the 3DModels workbook that comes with the package. In the sheet named 3DModels, right-click and move it to the new workbook where the code was copied. This sheet contains essential elements for some models.
  • Save the new workbook as a macro-enabled workbook (.xlsm) and store it on the desktop or in a folder different from the Downloads folder.
 

© ScienSolar, 2023.