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

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 change my CSV to read it from WEAP?"
Log in to post new messages or reply to existing messages.
 
Author Message
Mr. Amin Daghighi

Subject: How to change my CSV to read it from WEAP?   
Posted: 10/2/2017 Viewed: 1521 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?"