[Bldg-sim] Convert Energy-Plus Weather files to EXCEL tables and charts

Varkie Thomas thomasv at iit.edu
Tue Apr 16 14:01:30 PDT 2013
Previous message: [Bldg-sim] Convert Energy-Plus Weather (EPW)
Next message: [Bldg-sim] How to know how much cold is produced in eQuest?
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Open website  <http://bepan.info/contents> http://bepan.info/contents and page tab Weather for Energy-Plus Weather (EPW) files converted to EXCEL Tables & Charts.   <http://bepan.info/weather> 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  <http://bepan.info/yahoo_site_admin/assets/docs/Energy-Plus-Weather_EPW_-_EXCEL_Analysis_Reports_-_Tables__Charts.105105014.docx> 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  <http://bepan.info/yahoo_site_admin/assets/docs/12_-_Template_Beijing-Weather-Analysis-Long.132135635.zip> 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> http://www.iit.edu/arch/faculty/thomas_varkie.shtml


Weather Analysis


  C1 - Weather-Analysis - Generate-Charts-Tables


C1a - INSTRUCTIONS - DOE2 Wthr - *.dat - *.bin - *.xls




 <http://bepan.info/yahoo_site_admin/assets/docs/1_-_USDOE_Real-Time_Weather_Data_Tutorial.34092659.pdf> 1 -  USDOE Real-Time Weather Data Tutorial


 <http://bepan.info/yahoo_site_admin/assets/docs/2_-_USDOE_Real-time_Weather_Data_Access_Guide.34092720.pdf> 2 -  USDOE Real-time Weather Data Access Guide


 <http://bepan.info/yahoo_site_admin/assets/docs/3_-_USDOE_Rainfall_Data_for_US_Cities.34092808.pdf> 3 -  USDOE Rainfall Data for US Cities


 <http://bepan.info/yahoo_site_admin/assets/docs/6_-_Weather_2008-IIT-Seminar.34092840.pdf> 6 -  Weather 2008-IIT-Seminar


 <http://bepan.info/yahoo_site_admin/assets/docs/7_-_Customizing_eQUEST_Weather_Data_by_Jeff_Hirsch.103105753.pdf>  <http://bepan.info/yahoo_site_admin/assets/docs/7_-_Customizing_eQUEST_Weather_Data_by_Jeff_Hirsch.138125735.pdf> 7 - Customizing eQUEST Weather Data by Jeff Hirsch


 <http://bepan.info/yahoo_site_admin/assets/docs/8_-_Saving_eQUEST_364_Weather_Files.8190157.pdf> 8 - Saving eQUEST 3.64 Weather Files


 <http://bepan.info/yahoo_site_admin/assets/docs/9_-_Weather___NCDCtpe_to_DOE2bin_to_Tables-Charts.34093358.pdf> 9 -  Weather _NCDC.tpe to DOE2.bin to Tables-Charts


TEMPLATES (DOE2.bin Data to EXCEL Tables & Charts)


 <http://bepan.info/yahoo_site_admin/assets/docs/11_-_Template_Shanghai-Weather-Analysis-Short.132135521.zip> 11 -  Template - Shanghai – DOE2-Weather-Analysis - Short


 <http://bepan.info/yahoo_site_admin/assets/docs/12_-_Template_Beijing-Weather-Analysis-Long.132135635.zip> 12 -  Template - Beijing – DOE2-Weather-Analysis - Long

 C1b - INSTRUCTIONS – Converting Energy-Plus Weather Files


  <http://bepan.info/yahoo_site_admin/assets/docs/TMY2-Users-Manual_-_tmy2man.152135401.pdf> TMY2-Users-Manual - tmy2man

  <http://bepan.info/yahoo_site_admin/assets/docs/0-Typical_Meteorological_Year_TMY.152135120.pdf> 0 - Typical Meteorological Year (TMY)


  <http://bepan.info/yahoo_site_admin/assets/docs/1_-Convert_Energy-PlusEPW_to_DOE2BIN.138130152.pdf> 1 - Convert Energy-Plus.EPW to DOE2.BIN


  <http://bepan.info/yahoo_site_admin/assets/docs/2_-_Convert_EPW_Text_File_to_Charts-Reports.138130246.pdf> 2 - Convert EPW Text File to Charts-Reports


  <http://bepan.info/yahoo_site_admin/assets/docs/5_-_Original_-_USA_MN_Minneapolis-StPaulIntlAP726580_TMY3.138130317.epw> 5 - Original - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.epw


  <http://bepan.info/yahoo_site_admin/assets/docs/6_-_Edited_-_USA_MN_Minneapolis-StPaulIntlAP726580_TMY3.138130348.epw> 6 - Edited - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.epw


  <http://bepan.info/yahoo_site_admin/assets/docs/7_-_Read_Text_File_into_Excel_-_EPW-Minneapolis.138130420.xlsx> 7 - Read Text File into Excel - EPW-Minneapolis.xlsx


  <http://bepan.info/yahoo_site_admin/assets/docs/8_-_Template_-_Minneapolis_-_EPW-Weather-Analysis.138130545.zip> 8 – Template-Excel - Minneapolis - EPW-Weather-Analysis.xls


  <http://bepan.info/yahoo_site_admin/assets/docs/9_-_Template_-_Jeddah_-_EPW-Weather-Analysis.138130717.zip> 9 – Template-Excel - Jeddah - EPW-Weather-Analysis.xls

 

C1c –Excel Weather-Analysis of Converted DOE2.bin file

   <http://bepan.info/yahoo_site_admin/assets/docs/0_-_Using_Q%E2%82%ACToTiTs_Q%E2%82%ACWoWWs_Q%E2%82%ACHoHHs_is_approx__8760-Hr-Calcs.4681834.docx> Using Q€(To~Ti,Ts), Q€(Wo~W,Ws), Q€(Ho~H,Hs) apprx = 8760-Hr-Calcs 


  <http://bepan.info/yahoo_site_admin/assets/docs/1_-_TEMPLATE_-_DOE2_BIN_Weather_to_Excel__Analyze.4681907.xlsx> 1 - TEMPLATE - DOE2 BIN Weather to Excel & Analyze

 	

  <http://bepan.info/yahoo_site_admin/assets/docs/CHICAGO_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46114721.xlsx> 2 - TEMPLATE - Sum (Ti,Ts~To, Wi,Ws~Wo & Hi,Hs~Ho) 8760 Hrs

 	

  <http://bepan.info/yahoo_site_admin/assets/docs/1_-_LOCATIONS_-_Sum_of_TiTsTo_WiWsWo__HiHsHo_for_8760-hrs.49142726.xlsx> 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


  <http://bepan.info/yahoo_site_admin/assets/docs/BEIJING_-_DOE2_BIN_Weather_to_Excel__Analyze.43141719.xlsx> BEIJING - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/BEIJING_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46114640.xlsx> BEIJING - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/BOSTON_-_DOE2_BIN_Weather_to_Excel__Analyze.43141751.xlsx> BOSTON - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/BOSTON_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46114745.xlsx> BOSTON - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/CHICAGO_-_DOE2_BIN_Weather_to_Excel__Analyze.43141825.xlsx> CHICAGO - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/CHICAGO_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46114804.xlsx> CHICAGO - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/DUBAI_-_DOE2_BIN_Weather_to_Excel__Analyze.43141859.xlsx> DUBAI - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/DUBAI_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46114822.xlsx> DUBAI - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/JEDDAH_-_DOE2_BIN_Weather_to_Excel__Analyze.43141948.xlsx> JEDDAH - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/JEDDAH_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46114849.xlsx> JEDDAH - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/KUWAIT_-_DOE2_BIN_Weather_to_Excel__Analyze.43142038.xlsx> KUWAIT - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/KUWAIT_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46114913.xlsx> KUWAIT - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/MINNEAP_-_DOE2_BIN_Weather_to_Excel__Analyze.43142112.xlsx> MINNEAP - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/MINNEAP_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hs.46115010.xlsx> MINNEAP - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/NEW_YORK_-_DOE2_BIN_Weather_to_Excel__Analyze.43142154.xlsx> NEW YORK - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/NEW_YORK_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46115028.xlsx> NEW YORK - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/PHOENIX_-_DOE2_BIN_Weather_to_Excel__Analyze.43142229.xlsx> PHOENIX - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/PHOENIX_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46115057.xlsx> PHOENIX - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/TOKYO_-_DOE2_BIN_Weather_to_Excel__Analyze.43142309.xlsx> TOKYO - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/TOKYO_-_Sum_Ti-To_Wi-Wo__Hi-Ho_8760_Hrs.46115121.xlsx> TOKYO - Sum (Ti-To, Wi-Wo & Hi-Ho)


  <http://bepan.info/yahoo_site_admin/assets/docs/TORONTO_-_DOE2_BIN_Weather_to_Excel__Analyze.43142353.xlsx> TORONTO - DOE2 BIN Weather to Excel

  <http://bepan.info/yahoo_site_admin/assets/docs/TORONTO_-_Sum_Ti-To_Wi-Wo__Hi-Ho_for_8760_Hours.46115138.xlsx> TORONTO - Sum (Ti-To, Wi-Wo & Hi-Ho)

			

C1d – Energy-Plus Weather-Analysis – Excel Tables & Charts


  INSTRUCTIONS – EnergyPlus Weather Files – Excel Analysis

   <http://bepan.info/yahoo_site_admin/assets/docs/Energy-Plus-Weather_EPW_-_EXCEL_Analysis_Reports_-_Tables__Charts.105105014.docx> Energy-Plus-Weather (EPW) - EXCEL-Images - Analysis Reports - Tables & Charts

 <http://bepan.info/yahoo_site_admin/assets/docs/Energy-Plus-Weather_EPW_-_EXCEL_Analysis_Reports_-_Tables__Charts.105105014.docx>     <http://bepan.info/yahoo_site_admin/assets/docs/Energy-Plus-Weather_EPW_-_Instructions_-_Open_Text_File_from_EXCEL.105104517.docx> Energy-Plus-Weather (EPW) - Instructions - Open Text File from EXCEL


   <http://bepan.info/yahoo_site_admin/assets/docs/1_-_8760-Hrs-WthrCaptions_-_USA_MN_Minneapolis-StPaulIntlAP726580_TMY3.105104535.epw> 1 - 8760-Hrs-Wthr+Captions - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.epw


   <http://bepan.info/yahoo_site_admin/assets/docs/2_-_8760-Hrs-Wthr-Only_-_USA_MN_Minneapolis-StPaulIntlAP726580_TMY3.105104555.epw> 2 - 8760-Hrs-Wthr-Only - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.epw


   <http://bepan.info/yahoo_site_admin/assets/docs/3_-_8760-Hrs-Wthr-Only_-_USA_MN_Minneapolis-StPaulIntlAP726580_TMY3epw.105104640.txt> 3 - 8760-Hrs-Wthr-Only - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.txt


   <http://bepan.info/yahoo_site_admin/assets/docs/4_-_8760-Hrs-Wthr-Only_-_USA_MN_Minneapolis-StPaulIntlAP726580_TMY3epw.105104710.xlsx> 4 - 8760-Hrs-Wthr-Only - USA_MN_Minneapolis-St.Paul.Intl.AP.726580_TMY3.xlsx


   <http://bepan.info/yahoo_site_admin/assets/docs/5_-_Minneapolis_-_EPW-Weather-Analysis_-_Short.105105058.xlsx>  <http://bepan.info/yahoo_site_admin/assets/docs/5_-_Minneapolis_-_EPW-Weather-Analysis_-_Short.105105058.xlsx> 5a - Minneapolis - EPW-Weather-Analysis – Short-Analysis. <http://bepan.info/yahoo_site_admin/assets/docs/5_-_Minneapolis_-_EPW-Weather-Analysis_-_Short.105105058.xlsx> xlsx


   <http://bepan.info/yahoo_site_admin/assets/docs/5_-_Singapore_-_EPW-Weather-Analysis_-_Short.105105124.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)


 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20130416/dcadebc0/attachment.htm>
Previous message: [Bldg-sim] Convert Energy-Plus Weather (EPW)
Next message: [Bldg-sim] How to know how much cold is produced in eQuest?
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Bldg-sim mailing list