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 "Using data from Excel"
Log in to post new messages or reply to existing messages.
 
Author Message
Mr. behzad jamali

Subject: Using data from Excel   
Posted: 1/6/2011 Viewed: 43010 times
Hi
I think one of the problems with the WEAP is entering data without copy and paste capability. this is more Annoying when we want to enter data of many rivers or other supplies in weap. It is very useful if the user could copy and paste all data from excel to weap without making CSV or text files.
thank u

Mr. Jack Sieber

Subject: Re: Using data from Excel   
Posted: 1/6/2011 Viewed: 43004 times
There is a way to do this. In WEAP's Data View, go to the menu: Edit, Export Expressions to Excel. This will create a new Excel workbook, into which you can paste your data. When you are ready to import these new data into WEAP, go to the WEAP menu: Edit, Import Expressions from Excel.

See http://www.weap21.org/WebHelp/index.html#Excel_Export.htm for more information.

Mr. behzad jamali

Subject: Re: Using data from Excel   
Posted: 1/7/2011 Viewed: 42969 times
Thank you Jack
I have the same problem yet. In monthly variations data I must enter the values manually.
for example this is monthly variation of demand data in excel exported file:
MonthlyValues( Jul,10.72, Aug, 10.05, Sep,6.63, Oct,6.421, Nov,6.421, Dec,6.421, Jan, 6.421, Feb,6.421, Mar,6.21, Apr, 9.5, May,14.05, Jun, 10.72 ).
unfortunately I must prepare the data in monthly variation form(like the example) and then copy and paste them to excel exported file or directly to the weap demand data. In other words, my problem is preparing the data in this form.

Mr. Jack Sieber

Subject: Re: Using data from Excel   
Posted: 1/7/2011 Viewed: 42966 times
I forgot to mention another, very easy, way to paste time-series data into WEAP from Excel. You can copy an array of numbers from Excel and paste it into the WEAP expression box. WEAP will bring up the Paste Special Wizard to help create a monthly or yearly time series expression from these values. For example, if you have data in Excel for monthly variation, copy this array of 12 numbers and paste it into WEAP, and WEAP will create a MonthlyValues expression using these 12 values. This also works for importing a volume-elevation array into the Volume-Elevation Curve tab for a reservoir.

Mr. behzad jamali

Subject: Re: Using data from Excel   
Posted: 1/7/2011 Viewed: 42960 times
That's wonderful Jack :)
I try it and see how it works. I realized that it dose not work with right click and paste, but it works with Cntrl+V !!
thank you for your help.

Mr. Gilad Safier

Subject: Re: Using data from Excel   
Posted: 8/29/2012 Viewed: 18644 times

> There is a way to do this. In WEAP's Data View, go to the menu: Edit, Export Expressions to Excel. This will create a new Excel workbook, into which you can paste your data. When you are ready to import these new data into WEAP, go to the WEAP menu: Edit, Import Expressions from Excel.
>
> See http://www.weap21.org/WebHelp/index.html#Excel_Export.htm for more information.
>
>
One thing I'm missing in this option, is changing the units.
I have 160 consumers I want to insert all the data to with excel.
The annual activity level for some of the consumers, for example, is "People" (or "cap").
For others it's "aquare kilometers".
Is there a way to change the units in excel or do I have to go one by one and change that?
Mr. Amin Daghighi

Subject: Re: Using data from Excel   
Posted: 10/2/2017 Viewed: 18644 times
Hi, Do you have a contact email to ask you couple of questions regarding reading CSV files?
Regards,
Amin
Mr. Jack Sieber

Subject: Re: Using data from Excel   
Posted: 10/2/2017 Viewed: 18642 times
Yes, you can change the unit name in Excel, and when you import it back into WEAP, WEAP will change the unit to use the new ones from Excel.
Mr. Amin Daghighi

Subject: Re: Using data from Excel   
Posted: 10/2/2017 Viewed: 18637 times
This is my CSV file:

# Streamflow for Weaping River: Below Downstream Requirement
# Calculated by WEAP: 9/1/2016 4:06:32 PM
# Area: Weaping River Basin
# Scenario: Supply Measures

$ListSeparator = ,
$DecimalSymbol = .
$Columns = Year $Columns = Month Streamflow[CMS]

2010 1 142.06
2010 2 119.53
2010 3 209.79
2010 4 286.26
2010 5 128.08
2010 6 44.5
2010 7 23
2010 8 43.5
2010 9 27
2010 10 58.5
2010 11 158.86
2010 12 172.96

Unfortunately it says there is a duplicate in years, I'm not sure how should I change the file format to be readable for you
Appreciate your time and help.

Mr. Amin Daghighi

Subject: Re: Using data from Excel   
Posted: 10/2/2017 Viewed: 18627 times
It is the notepad file copy paste format, last one was a copy paste from my excel sheet

# Streamflow for Weaping River: Below Downstream Requirement,,
# Calculated by WEAP: 9/1/2016 4:06:32 PM,,
# Area: Weaping River Basin,,
# Scenario: Supply Measures,,
,,
"$ListSeparator = ,",,
$DecimalSymbol = .,,
$Columns = Year,$Columns = Month, Streamflow[CMS]
,,
2010,1,142.06
2010,2,119.53
2010,3,209.79
2010,4,286.26
2010,5,128.08
2010,6,44.5
2010,7,23
2010,8,43.5
2010,9,27
2010,10,58.5
2010,11,158.86
2010,12,172.96

Topic "Using data from Excel"