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

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: 9517 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: 9474 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: 9403 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: 9397 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"