[bldg-sim] Occupied and unoccupied hours weather data

[Jeff Haberl]

FYI. 

You can calculate the DOY with the spreadsheet using an @MOD(@DATE(month,day,year),7) function. This yields a repetitive 0,1,2,3,4,5,6,0,1...for each hour. 0 and 1 are Sat and Sun, 1-6 are M-F. This is a modulo function base 7 that operates on the linear date that the DATE function generates. For all spreadsheets day 1 = Jan 1, 1900. You can then do a double sort on the DOY and hour to get your weather by weekday and by working hour. 

Jeff 
BB 8=!  8=)  :=)  8=)  ;=)  8=)  8=(  8=)  :=')  8=)  8=)  8=? BB

Jeff S. Haberl, Ph.D., P.E.............................jhaberl at esl.tamu.edu

Professor......................................................Office Ph: 979-845-6507

Department of Architecture.......................Lab Ph: 979-845-6065 

Energy Systems Laboratory.......................FAX: 979-862-2457 

Texas A&M University..............................77843-3581

College Station, Texas, USA.......................URL: www-esl.tamu.edu

BB 8=/  8=)  :=)  8=)  ;=)  8=)  8=()  8=) 8=?  8=)  8=)  8= BB


-----Original Message-----
From: bldg-sim at gard.com <bldg-sim at gard.com>
To: bldg-sim at gard.com <bldg-sim at gard.com>
Sent: Wed Oct 19 02:11:29 2005
Subject: [bldg-sim] Occupied and unoccupied hours weather data

Gaurav,

you can separate weekends and workdays with the excel method you used
already very simply:
just indroduce a new column in which you give the the workdays the number 1
and the weekdays the number 2. Then you can use the filter function to sort
out the days you need. Once you have created this column for one data file
you can copy it to the other files.

Greetings,

Caroline

-- 
Highspeed-Freiheit. Bei GMX supergünstig, z.B. GMX DSL_Cityflat,
DSL-Flatrate für nur 4,99 Euro/Monat*  http://www.gmx.net/de/go/dsl

======================================================
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