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 "Syntax for Excel Range in Yearly Time-Series Wizard if worksheet contains many columns"
Log in to post new messages or reply to existing messages.
 
Author Message
Mr. Oliver Priestley-Leach

Subject: Syntax for Excel Range in Yearly Time-Series Wizard if worksheet contains many columns   
Posted: 11/11/2016 Viewed: 12877 times
I have got a large spreadsheet with many columns of data. Each column represents a different demand site. I would like to use the Yearly Time-Series Wizard to produce forecast data using the linear or exponential forecast for my Reference Scenario. Column A of the spreadsheet is the year. How do I reference data in the second column if it is not next to Column A? I have tried the normal Excel syntax A1:A50,D1:D50 but this does not work. I have also created a named range but again unless the two columns are next to each other WEAP will not accept the Range. Can anyone recommend a simple work around for this? Thanks.
Mr. Jack Sieber

Subject: Re: Syntax for Excel Range in Yearly Time-Series Wizard if worksheet contains many columns   
Posted: 11/15/2016 Viewed: 12871 times
I can try to add this capability in a future version of WEAP. As a (cumbersome) workaround, you could create contiguous ranges in Excel for each set of data that you want to import into WEAP, by linking them to the original data.

Jack
Topic "Syntax for Excel Range in Yearly Time-Series Wizard if worksheet contains many columns"