Download Sciensolar

27Physics 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 Versions	Notes
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
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: improved Auto scale button. The ability to add buttons, combo boxes, drop-down lists, radio buttons, and check boxes to each individual project has been implemented. 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. 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.