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 "CLIMATE DATA FORMAT"
Log in to post new messages or reply to existing messages.
 
Author Message
Mr. Asavela Jack

Subject: CLIMATE DATA FORMAT   
Posted: 11/1/2021 Viewed: 4646 times
Hello colleagues, I would like to be assisted here, I want to know the format to use when creating climate data, like what headings and how to arrange your data so that WEAP may read it correctly. If possible can one of us send the example of the climate data with all the components like precipitation, wind, humididy, temperature etc in excell and in CSV.


kind regards

Mr A.Jack
Mr. Asavela Jack

Subject: Re: CLIMATE DATA FORMAT   
Posted: 11/10/2021 Viewed: 4623 times
My personal email is asavelajack08@gmail.com

I am still waiting for your help good people.


Regards

Mr a.Jack
Ms. Anne Hereford

Subject: Re: CLIMATE DATA FORMAT   
Posted: 1/19/2022 Viewed: 4437 times
Dear Asavela,

The following is from the WEAP User Guide under the topic ReadFromFile. In the same section of the help you will find information about offsetting your data, aggregating daily data to monthly data, what to do about missing data, etc. Hope this helps!

Column Descriptions
Use the optional $Columns directive to describe the contents and unit for each data column. The optional unit, if included, is in square brackets after the name. This is a very good way to document your data. In addition, you can then refer to columns by their name instead of their number in the ReadFromFile expression -- not only will this make for a clearer expression, but the reference will still be correct if you later add or remove columns in the file. Here is an example from a climate file named Climate.csv with 5 data columns (rainfall, min and max temperature, humidity and wind):

$Columns = Precipitation[mm], Min Temperature[C], Max Temperature[C], Relative Humidity[%], Wind Speed[m/s]

Here's how to refer to the Max Temperature column in the ReadFromFile expression: ReadFromFile(Climate.csv, "Max Temperature[C]") Note: you must enclose the column name in quotes. The unit is optional and can be omitted, e.g., ReadFromFile(Climate.csv, "Max Temperature")

Optionally, you may list the time columns first. Some examples:

Annual: $Columns = Year, Population

Monthly: $Columns = Year, Month, Burlington Brook USGS 1188000[CFS], Weber River USGS 1932000[CFS]

Daily: $Columns = Date, Precipitation[mm], Mean Temperature[C]

If any column names include the list separator character, you must enclose the name in quotes, e.g., "Daily Temperature, Average[C]"
Topic "CLIMATE DATA FORMAT"