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

About WEAP

What's New?
Sample Screens
History and Credits

Using WEAP
User Guide
Videos (YouTube)

User Forum
Members List
Edit Profile

Additional Support
University Courses

About Us
SEI-US Water Resources Program
Please Contact Us

Environmental News
'Subterranean estuaries' crucial to sustainable fishing and aquacultur...
Pioneering research suggests 'subterranean estuaries' may be critical in managing sustainable fishing and aquaculture --...

Chemicals from human activities in transplanted oysters far from popul...
Wastewater treatment facilities clean the water that goes down our sinks and flushes our toilets, but they do not remove...

Antarctic Circumpolar Current flows more rapidly in warm phases
Our planet's strongest ocean current, which circulates around Antarctica, plays a major role in determining the transpor...
Source: Science Daily
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 "How to copy excel data to WEAP"
Log in to post new messages or reply to existing messages.
Author Message
Miss myat mon

Subject: How to copy excel data to WEAP   
Posted: 1/28/2018 Viewed: 4736 times
Hello Dear,

I cannot copy the observed data to paste in the WEAP data entry table. I saved as the CSV format in excel and already created comma format in excel. Then, I cannot get the next step. Please give me suggestion to do it.
Ms. Stephanie Galaitsi

Subject: Re: How to copy excel data to WEAP   
Posted: 1/30/2018 Viewed: 4696 times
Dear Myat,

You cannot paste Excel data in WEAP - you will need to use the ReadFromFile wizard. Please see the video on this topic ( http://www.screencast.com/t/hLpxOfX137 ) which is one of many topics discussed on our videos page ( www.WEAP21.org/videos ).


Miss myat mon

Subject: Re: How to copy excel data to WEAP   
Posted: 2/2/2018 Viewed: 4628 times
Hello Ms. Stephanie Galaitsi,

I followed the manual video that you sent. I got it but it is for monthly. I am using data for my thesis is daily. Although I tried to change the format for input from excel, WEAP told me " read from file error". Please give me some suggestions for daily data to input WEAP model.

Thank You.
Ms. Stephanie Galaitsi

Subject: Re: How to copy excel data to WEAP   
Posted: 2/2/2018 Viewed: 4622 times
Hi Myat

There's a great section about the ReadFromFile function in the Help Menu (in the top ribbon of WEAP, Help/Search, and then type in "ReadFromFile"). It's pretty long, but if you scroll down, there are different examples of how to format your excel/CSV files based on time steps. Scroll all the way to the bottom, and you'll see the section about formatting daily data.

Basically, it's date, data column 1, data column 2, data column 3, ...

For your data format, you should use a directive at the top of your sheet (this will make data transferable). You can find instructions for this in the same ReadFromFile document, about 2/3 down.

Topic "How to copy excel data to WEAP"