All Topics |
Topic: “Importing New Branches into WEAP from Excel”
Author | Message |
---|
Subject: Importing New Branches into WEAP from Excel
Posted: 4/28/2016 Viewed: 20024 times
Hello,
I am developing a water management model of certain African countries in WEAP. I had to make a 'Key Assumption' to represent 1000 small districts and their population. I was wondering if I could have it in Excel and directly import them into WEAP. But i did some digging on the user Manuals and it had the following words "WEAP can only import data that corresponds to an existing branch/variable/scenario" So i believe that I need to create these 1000 branches in WEAP and then I can use the import/export function to deal with the EXPRESSIONS. Can someone guide me if my understanding is right and if wrong, how do i take numerous amount of branches into WEAP without clicking and adding them one by one. Best vignesh |
Subject: Re: Importing New Branches into WEAP from Excel
Posted: 4/28/2016 Viewed: 20020 times
You can use the WEAP Application Programming Interface (API) to automate the adding of branches. See the WEAP help topic for more information: Advanced Topics \ Automating WEAP (API).
Here's the Visual Basic Script (VBS) code you use to create 1000 branches, named with sequential numbers: Set WEAP=CreateObject("WEAP.WEAPApplication") Set ParentBranch=WEAP.Branch("\Key Assumptions") For i = 1 to 1000 Set NewBranch = ParentBranch.AddChild("Branch " & i) Next If you have the names of the new branches in an Excel spreadsheet, you could use Excel's Visual Basic for Applications (VBA) language to write a simple macro that would create branches using names from Excel cells. For more information on controlling WEAP from Excel, see the Help topic: Advanced Topics \ Automating WEAP (API) \ Exploring the API. Jack |
Subject: Re: Importing New Branches into WEAP from Excel
Posted: 5/9/2016 Viewed: 19964 times
Dear Jack,
Thanks for the help. It definitely reduces a lot of downtime. Best vignesh |
Subject: Re: Importing New Branches into WEAP from Excel
Posted: 6/10/2019 Viewed: 13170 times
hello
i want to know how can set a content for key assumptions by vba? for example we can do that by such command for other variables: WEAP.BranchVariable("\Demand Sites\South City:Consumption").Expression = "30" but how can we address a key assumption? |
Subject: Re: Importing New Branches into WEAP from Excel
Posted: 6/10/2019 Viewed: 13161 times
Because Key Assumption and Other Assumption branches do not have variable tabs, you do not need to give a variable name when referencing them.
For example, to change the population growth rate assumption in Weaping River Basin, here is the VB code: WEAP.BranchVariable("\Key Assumptions\Drivers\Population Growth Rate").Expression = 1.5 |
Subject: Re: Importing New Branches into WEAP from Excel
Posted: 6/16/2019 Viewed: 13095 times
thanks mr.sieber
but i have one more question are there any way to set different content for each months as what we do in 'monthly time-series wizard' ,from excel? same what we do for resualt value: 'WEAP.ResultValue("\Supply and Resources\River\Weaping River\Reservoirs\Central Reservoir:Storage Volume[Million]", 2017, 7, "Reference"). i do not want to do it by 'readfromfile wizard' ,because it's very time-consuming in optimization model that i want to develop it. |
Topic: “Importing New Branches into WEAP from Excel”