[EnergyPlus_Support] Custom Weather file csv back to EPW

[Seth Moody <seths.moody@xxxxxxxxx>]

Hello all,

I have taken an EPW weather file and used the weather converter utility to convert it to CSV in order to paste in my own hourly weather data.
I did the editing in excel 2007 and re-saved as CSV
 

Now I would like to convert it back to EPW and run it with my model.


Converter doesn't like the edited CSV and claims I have a "Custom Data Format (requires DEF file)".
I've tried overriding the default "Custom Data Format (requires DEF file)" requirement by selecting "Energy Plus Comma Separated Variable (CSV) Format" but it still kicks it back.

Comparing the original output CSV with the new edited CSV, in notepad, reveals header month/day dates have been altered by Excel (I changed them back easily) and extra commas at all the carriage returns.  The extra commas are a bit more problematic as they're on nearly every line of code.

Are the extra commas the issue?
What would be the best way to edit the weather file and then output format for the converter?


Seth


-- 
Seth S. Moody
seths.moody@xxxxxxxxx

Laboratory Manager, ME EIT
Green Building Research Laboratory,
Portland State University
503-367-5792

__._,_.___

Primary EnergyPlus support is found at:
http://energyplus.helpserve.com or send a message to energyplus-support@xxxxxxxx

The primary EnergyPlus web site is found at:
http://www.energyplus.gov

The group web site is:
http://groups.yahoo.com/group/EnergyPlus_Support/

Attachments are currently allowed but be mindful that not everyone has a high speed connection.  Limit attachments to small files.

EnergyPlus Documentation is searchable.  Open EPlusMainMenu.pdf under the Documentation link and press the "search" button.

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___