ScienSolar

Download Sciensolar

27 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

Option 1: Ready-to-use Excel file:
Solar Science1_7
(August 25, 2026).

Option 2: Install from scratch in a new book:
ScienSolar v 1.7 Files.zip

Version 1.7 has a new form of installation. .bas files are imported from the Visual Basic editor. This ensures an installation with less probability of error.

This version is multilingual. The interface and the 40 projects come in English, Spanish, French, Italian, Russian and Chinese. The installation of projects in different languages is modular. The Periodic Table project is included in the package.

Click here to see the steps to follow for installation.

Ready-to-use Excel file:
ScienSolar1_62.xlsm
(11-02-2026)

Complete periodic table elements model: 

Download

Update to version 1.62: 

(11-Feb-2026) 

Modules 1 and 2 correspond to the ScienSolar program, they must be updated together.

🔹 MODULE 1 (11-02-2026)
🔹 MODULE 2 (11-02-2026)

Installation:

Replace the Module 1 and Module 2 codes of ScienSolar in the Visual Basic editor with the updated ones.

Changes from version 1.6 (and 1.61):

Some bugs were fixed. The Scanner Field button has been introduced, allowing for more efficient use of the functionalities in cells C7, C16, etc., to view fields. How to use the button:

  1. Image 1
  2. Image 2
  3. Image 3
  4. Image 4
  5. Image 5
Ready-to-use Excel file:
ScienSolar1_6.xlsm
(04-10-2025)

Update to version 1.6:

 

(04-Oct-2025)

 

Modules 1 and 2 correspond to the ScienSolar program, they must be updated together.

🔹 MODULE 1 (04-10-2025)
🔹 MODULE 2 (04-10-2025)

Installation:

Replace the Module 1 and Module 2 codes of ScienSolar in the Visual Basic editor with the updated ones.

Changes with respect to v. 1.55:

  1. improved Auto scale button.
  2. The ability to add buttons, combo boxes, drop-down lists, radio buttons, and check boxes to each individual project has been implemented.
  3. Improved tolerance for special characters, including mathematical symbols and characters for different languages, which can be written in any cell and will be exported correctly.
  4. Field mode display has been improved and some bugs have been fixed. The code has been debugged.
 

Update to version 1.55:

 

(05-04-2025)

 

Modules 1 and 2 correspond to the ScienSolar program, they must be updated together.

🔹 MODULE 1 (04-05-2025)
🔹 MODULE 2 (04-05-2025)

Installation:

Replace the Module 1 and Module 2 codes of ScienSolar in the Visual Basic editor with the updated ones.

Changes with respect to v. 1.54:

Updated the code for the color gradient for the display of scalar and vector fields, with the possibility of choosing several color palettes, changing the value from 10 to 100 in the color cell (C6 or similar).

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)

🔹  3DModels (spreadsheet with formulas. Open it and move it to the workbook where the code is.)

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.