Open website http://bepan.info/contents and page tab Weather for Energy-Plus Weather (EPW) files converted to EXCEL Tables & Charts. http://bepan.info/weather
The files are in section C1d
The full EXCEL files (Minneapolis & Singapore) have not been included because the files are 15 MB and the website (Yahoo) will not upload files greater than 10 MB. My email won?t send attachments of over 8 MB. Windows ZIP, WINZIP & PKZIP file compression is 90%. Is there a way around this?
You can view images of the tables and charts by opening Energy-Plus-Weather (EPW) - EXCEL-Images - Analysis Reports - Tables & Charts
OR you can convert weather.epw to weather.bin using instructions in C1b and convert the weather.bin file to EXCEL tables and charts.
See example of ?full tables & charts? by opening 12 - Template - Beijing ? DOE2-Weather-Analysis - Long in section C1a.
I hope you are not as confused by all this as I am.
Varkie
http://www.iit.edu/arch/faculty/thomas_varkie.shtml
Weather Analysis
C1 - Weather-Analysis - Generate-Charts-Tables
C1a - INSTRUCTIONS - DOE2 Wthr - *.dat - *.bin - *.xls
1 - USDOE Real-Time Weather Data Tutorial
2 - USDOE Real-time Weather Data Access Guide
3 - USDOE Rainfall Data for US Cities
6 - Weather 2008-IIT-Seminar
? 7 - Customizing eQUEST Weather Data by Jeff Hirsch
8 - Saving eQUEST 3.64 Weather Files
9 - Weather _NCDC.tpe to DOE2.bin to Tables-Charts
TEMPLATES (DOE2.bin Data to EXCEL Tables & Charts)
11 - Template - Shanghai ? DOE2-Weather-Analysis - Short
12 - Template - Beijing ? DOE2-Weather-Analysis - Long
C1b - INSTRUCTIONS ? Converting Energy-Plus Weather Files
? TMY2-Users-Manual - tmy2man
0 - Typical Meteorological Year (TMY)
1 - Convert Energy-Plus.EPW to DOE2.BIN
2 - Convert EPW Text File to Charts-Reports
5 - Original - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.epw
6 - Edited - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.epw
7 - Read Text File into Excel - EPW-Minneapolis.xlsx
8 ? Template-Excel - Minneapolis - EPW-Weather-Analysis.xls
9 ? Template-Excel - Jeddah - EPW-Weather-Analysis.xls
C1c ?Excel Weather-Analysis of Converted DOE2.bin file
Using Q?(To~Ti,Ts), Q?(Wo~W,Ws), Q?(Ho~H,Hs) apprx = 8760-Hr-Calcs?? ?
1 - TEMPLATE - DOE2 BIN Weather to Excel & Analyze
2 - TEMPLATE - Sum (Ti,Ts~To, Wi,Ws~Wo & Hi,Hs~Ho) 8760 Hrs?
3 - LOCATIONS - Sum (Ti,Ts~To, Wi,Ws~Wo & Hi,Hs~Ho) for 8760-hrs?
DOE2 BIN Wthr to Excel & Analyze?
Sum (Ti-To, Wi-Wo & Hi-Ho) 8760
BEIJING - DOE2 BIN Weather to Excel
BEIJING - Sum (Ti-To, Wi-Wo & Hi-Ho)
BOSTON - DOE2 BIN Weather to Excel
BOSTON - Sum (Ti-To, Wi-Wo & Hi-Ho)
CHICAGO - DOE2 BIN Weather to Excel
CHICAGO - Sum (Ti-To, Wi-Wo & Hi-Ho)
DUBAI - DOE2 BIN Weather to Excel
DUBAI - Sum (Ti-To, Wi-Wo & Hi-Ho)
JEDDAH - DOE2 BIN Weather to Excel
JEDDAH - Sum (Ti-To, Wi-Wo & Hi-Ho)
KUWAIT - DOE2 BIN Weather to Excel
KUWAIT - Sum (Ti-To, Wi-Wo & Hi-Ho)
MINNEAP - DOE2 BIN Weather to Excel
MINNEAP - Sum (Ti-To, Wi-Wo & Hi-Ho)
NEW YORK - DOE2 BIN Weather to Excel
NEW YORK - Sum (Ti-To, Wi-Wo & Hi-Ho)
PHOENIX - DOE2 BIN Weather to Excel
PHOENIX - Sum (Ti-To, Wi-Wo & Hi-Ho)
TOKYO - DOE2 BIN Weather to Excel
TOKYO - Sum (Ti-To, Wi-Wo & Hi-Ho)
TORONTO - DOE2 BIN Weather to Excel
TORONTO - Sum (Ti-To, Wi-Wo & Hi-Ho)
?C1d ? Energy-Plus Weather-Analysis ? Excel Tables & Charts
INSTRUCTIONS ? EnergyPlus Weather Files ? Excel Analysis
? ? Energy-Plus-Weather (EPW) - EXCEL-Images - Analysis Reports - Tables & Charts
? Energy-Plus-Weather (EPW) - Instructions - Open Text File from EXCEL
1 - 8760-Hrs-Wthr+Captions - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.epw
2 - 8760-Hrs-Wthr-Only - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.epw
3 - 8760-Hrs-Wthr-Only - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.txt
4 - 8760-Hrs-Wthr-Only - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.xlsx
? ? 5a - Minneapolis - EPW-Weather-Analysis ? Short-Analysis. xlsx??
? 5b - Singapore - EPW-Weather-Analysis ? Short-Analysis.xlsx?
?6a - Minneapolis - EPW-Weather - Full-Analysis.xlsx (15 MB not uploaded)?
6b - Singapore - EPW-Weather - Full-Analysis.xlsx (15 MB not uploaded)
