Welcome to WEAP's Website
WEAP
WEAP is an initiative of the Stockholm Environment Institute.


About WEAP

Home
Why WEAP?
Features
What's New?
Sample Screens
Demonstration
Applications
Publications
History and Credits

Using WEAP
Download
Licensing
User Guide
Tutorial
Videos
Resources

User Forum
Discussions
Members List
Edit Profile

Additional Support
Training
University Courses
Collaboration

About Us
SEI-US Water Resources Program
Please Contact Us


 Environmental News
LEAP
Interested in Energy?
Read about LEAP: SEI's software for energy planning.

User Forum

All Topics | Topic "Is there a way to import values without excel with good performance?"
Log in to post new messages or reply to existing messages.
 
Author Message
Miguel Ruiz

Subject: Is there a way to import values without excel with good performance?   
Posted: 3/18/2017 Viewed: 125 times
I'm doing an automatization process in WEAP and I need to upload the initial Z1 and Initial Z2 variables for all branches.

I was tring to do that using the DataExpresion way:
WEAP.DataExpression(\Demand Sites and Catchments\CatchmentX\CoverY:Initial Z1) = var1

But it is very slow. I have 856 parameters to import and it take around 15 minutes to upload.

I'm going to run it in a Server without excel.
Is there another way to import a lot of values in WEAP without excel and with a good performance?


Jack Sieber

Subject: Re: Is there a way to import values without excel with good performance?   
Posted: 3/20/2017 Viewed: 64 times
Dear Miguel,

No, I do not think there is a faster way to do what you want to do. Importing expressions from Excel is the only way to change multiple branch expressions at once.

One other option would be to read the Z1 and Z2 values from one or more CSV files, which you could update before each run. In this approach, the expressions would not change (ReadFromFile), but the CSV file would change.

Jack
Topic "Is there a way to import values without excel with good performance?"