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

Using WEAP
Download
Licensing
User Guide
Tutorial
Videos
Resources

User Forum
Discussions
Members List
Edit Profile

Additional Support
Training
University Courses
Collaboration

About Us
SEI-US Water Resources Program
Please Contact Us


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

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: 846 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: 812 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 ).

Stephanie

Miss myat mon

Subject: Re: How to copy excel data to WEAP   
Posted: 2/2/2018 Viewed: 744 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: 740 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"