[bldg-sim] Occupied and unoccupied hours weather data
Gaurav Mehta
gmehta75 at gmail.com
Tue Oct 18 13:40:06 PDT 2005
Thanks a lot everyone for your response.
With the help of one of the responses out of the group, I figured out a way
in excel to separate out occupied and unoccupied hrs weather data from an
energy plus weather file that I converted to CSV format through energy plus
weather converter.
I used the menu item data/filter/autofilter to filter out data using the
custom feature specifying the hours 'greater or equal to' and 'lesser or
equal to'. Excel displayed the filtered out data which then was copied to
another work sheet. It is easier to do it for occupied hours as the hours
are in ascending order, it gets a bit trickier when working out for
unoccupied hours using this method. I filtered out data separately for hours
from 01:00 hrs to 07:00 hrs and for 19:00 hrs -24:00 hrs. After copying this
data onto another work sheet I sorted out using the date (mm/dd/yyyy) column
of data set. There is one problem here, as excel interprets the mm/dd/yyy as
numbers and they are not in the same order as the actual month. For this I
separated out the month and date in different columns and then sorted the
data to get the desired results.
I know this may not be the most efficient way to do it in excel, but I am
limited with my knowledge of using excel to its fullest capabilities.
However, there is a limitation in this method too, as it does not
differentiate between weekdays and weekends and holidays. I realized it
later, but I think I'll need to differentiate this for my analysis.
Gerald,
That was the first thing I realized that BinMaker Pro can do what I am
looking for. However, as a student I can not bear the cost of it. I greatly
appreciate your offer, but I don't know, it might take a long time as I need
to analyze 6 locations in the US.
I will need weather data (DB, DP, RH, Wind Speed, Wind Direction,
Atmospheric Pressure) for both occupied (08:00 hrs - 18:00 hrs) and
unoccupied hours (19:00 hrs- 07:00) hrs separately with a working week of 5
days per week (Monday through Friday).
1. San Francisco, CA
2. Los Angeles, CA
3. Phoenix, AZ
4. Portland, OR
5. Chicago, IL
6. Atlanta, GA
I must thank once again to all the respondents for their inputs.
best regards,
Gaurav Mehta
----- Original Message -----
From: "Gerald Pde" <geraldpde at yahoo.com>
To: <bldg-sim at gard.com>
Sent: Tuesday, October 18, 2005 11:40
Subject: [bldg-sim] Occupied and unoccupied hours weather data
> Gaurav,
> Bin maker pro can do that for you. Let me know what
> you need and maybe I can quickly do it for you.
> Gerald
>
>
> --- randy at hvacware.net wrote:
>
>> I have created a program that does exactly what you
>> asked for. Check it
>> out at
>> http://www.hvacware.net/tmy2bin.html
>>
>> I ask a reasonable fee ($25) to use it.
>>
>> It saves bin weather data to your occupancy
>> specifications as a .CSV file,
>> directly openable by excel.
>>
>> Randy Wilkinson
>>
>> > Is there a way to extract occupied hours data
>> (08:00 hrs-18:00 hrs) and
>> > unoccupied data (19:00hrs-07:00hrs.) from a TMY2
>> or energy plus weather
>> > file. Is it too time consuming to do it in excel?
>> >
>> > I know of Binmaker pro, but that costs around
>> $150.00.
>> >
>> >
>> >
>> > Any input would be greatly appreciated.
>> >
>> >
>> >
>> > Best regards,
>> >
>> >
>> > Gaurav Mehta
>>
>>
>>
>>
> ======================================================
>> You received this e-mail because you are subscribed
>> to the BLDG-SIM at GARD.COM mailing list. To
>> unsubscribe
>> from this mailing list send a blank message to
>> BLDG-SIM-UNSUBSCRIBE at GARD.COM
>>
>>
>
>
>
>
> __________________________________
> Yahoo! Music Unlimited
> Access over 1 million songs. Try it free.
> http://music.yahoo.com/unlimited/
>
> ======================================================
> You received this e-mail because you are subscribed
> to the BLDG-SIM at GARD.COM mailing list. To unsubscribe
> from this mailing list send a blank message to
> BLDG-SIM-UNSUBSCRIBE at GARD.COM
>
======================================================
You received this e-mail because you are subscribed
to the BLDG-SIM at GARD.COM mailing list. To unsubscribe
from this mailing list send a blank message to
BLDG-SIM-UNSUBSCRIBE at GARD.COM
More information about the Bldg-sim
mailing list