WEAP: Water Evaluation And Planning System

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

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 change my CSV to read it from WEAP?"

Author

Message

Mr. Amin Daghighi

Subject: How to change my CSV to read it from WEAP?
Posted: 10/2/2017 Viewed: 9781 times

Hi I have a CSV file but it says I cannot read the file because of duplicate!

From excel:
# 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

From Notepad copy pasted:
# 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

this is the type of my csv and rest of the file is just numbers
Please help me to revise it
Regards,
Amin

Topic "How to change my CSV to read it from WEAP?"