Using SAM with Excel

  • Victor Enzo
  • Topic Author
More
14 Jan 2015 14:00 #2917 by Victor Enzo
Using SAM with Excel was created by Victor Enzo
Hi,
I would like to use input from an Excel file to run a simulation in SAM and maybe make SAM to write the results in another Excel file (automatically). Is this, or something similar, possible?

Thanks in advance

Please Log in or Create an account to join the conversation.

  • Paul Gilman
More
14 Jan 2015 21:51 #2918 by Paul Gilman
Replied by Paul Gilman on topic Using SAM with Excel

Please Log in or Create an account to join the conversation.

  • Victor Enzo
  • Topic Author
More
15 Jan 2015 09:42 #2919 by Victor Enzo
Replied by Victor Enzo on topic Using SAM with Excel
Dear Paul

Thank you for the fast reply. I was able to run the LKscript downloaded from the SAM Sample Files page. Can I run the script from external programs? (like an Excel macro).

Thanks in advance

Please Log in or Create an account to join the conversation.

  • Paul Gilman
More
15 Jan 2015 17:51 #2920 by Paul Gilman
Replied by Paul Gilman on topic Using SAM with Excel
Dear Victor,
It is not possible to set the value of SAM inputs from outside of SAM.
However, if you are a software programmer, you can use the SAM software development kit to run SAM simulation modules without the SAM user interface. The SDK is a set of tools to work with the SAM Simulation Core (SSC) application programming interface (API). You can access the API in its native C, or using the language wrappers we've written for Java, C#, Python and MATLAB. We are considering writing a Microsoft VBA wrapper in the future, but do not have one now.
Best regards,

Paul.

Please Log in or Create an account to join the conversation.

  • Victor Enzo
  • Topic Author
More
19 Jan 2015 10:27 #2921 by Victor Enzo
Replied by Victor Enzo on topic Using SAM with Excel
Dear Paul,

I'll try to solve my problem in a different way.
Thank you for your help.

Best regards,
Victor

Please Log in or Create an account to join the conversation.

Moderators: Paul Gilman
Powered by Kunena Forum

NREL is a national laboratory of the U.S. Department of Energy, Office of Energy Efficiency and Renewable Energy, operated by the Alliance for Sustainable Energy, LLC.

NREL Home

NREL Research

Follow NREL

NREL is a national laboratory of the U.S. Department of Energy, Office of Energy Efficiency and Renewable Energy, operated by the Alliance for Sustainable Energy, LLC.