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
Publications
History and Credits

Using WEAP
Download
Licensing
User Guide
Tutorial
Videos (YouTube)

User Forum
Discussions
Members List
Edit Profile

Additional Support
Training
University Courses
Collaboration

About Us
SEI-US Water Resources Program
Please Contact Us

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

Link WEAP and LEAP for combined Water-Energy planning.
Watch a video demo!
   

User Forum

All Topics | Topic "Expression Builder"
Log in to post new messages or reply to existing messages.
 
Author Message
Eng. Ramadhani Twaha

Subject: Expression Builder   
Posted: 12/6/2022 Viewed: 3391 times
I have an Annual Water Use Rate of 195775488 m3 in the Current Accounts year (2000). I developed a growth rate expression for the next 35 years in the reference scenario as follows:

If(Year < 2021, Growth(0%), Growth(Key\Percent Increase in Irr.Demand by 2035\Irrigation Demand[%])).

The growth is 1.13% per year. In my next scenario for Irrigation Improvement, I want to reduce the water demand by 30% (From the Current Accounts), how do I include this in the previous expression? I tried multiplying it by 0.7 but the results have cumulative effect, it reducing 30% then 60% then 90%.... until the demand becomes 0m3.

Can anyone help please?
Mr. Miroslav Kandera

Subject: Re: Expression Builder   
Posted: 1/17/2023 Viewed: 2978 times
Hello,

probably a bit late to reply, but I would create new variable (let's call it "Growth"), which would have expression you created, and then in Annual Water Use, you can use expression "Growth*0. 7" or "Growth*1" or something more sophisticated to reduce it as you want in each scenario.

M.
Topic "Expression Builder"