|
Introduction The House >> Live data >> Trend data >> Efficiency  WEL  >> (Web Energy Logger) >> (WEL World map) The Land Wildlife About Us Talk/Forum >> Archives Podcast Info Links (Resources) Books  |
|
Construction Pics Foundation Radiant Slab Acid Stain floors Ground Loop Wood Framing Mechanical Equipment Room Monitoring System Exterior Interior |
|
Mission Statement Earth (Sheltering) Sun (Passive Solar) Water (Geothermal) >> Efficiency test |
|
Design Process Timeline Goals Room Guide Concepts Preliminary 3D Model Final Design Download Plan |
|
Energy Mgmt. GREEN HVAC Energy Logger The Weather |
|
Related Stuff Designer Showcase >> Brian >> Scott Hall >> Jeff Ray Discussion Forum Web-Cam Marsupials |
|
Phil's Other Stuff GEARS SUGO FIRST Team 1629 Resume |
|
Jazzercise Chatter MegaTalk Chatter2 Chatter3 |
Re: Long Term Charts
[ Read Responses | Return to the Index ]
[ ]
Posted by Bill on Thursday, 28 August 2008, at 12:14 p.m.,
in response to Re: Long Term Charts, posted by Ethan
Ethan, this is exceptionally helpful! So many smart people on this forum!
For my 50-week-duration WEL-automatically-produced charts I have the sampling period set to once every 8 hours (3 times per day). So I set my Modulo Dividor to 480, and sorted. There it is! A sample line every 8 hours at the top of the table (which is easy to chart from).
Now I'm dealing with about 90 rows each month to off-line chart from, not about 43K rows. I'll create a new worksheet to serve for each year, and simply copy these 90 rows to it every month.
I thought I was done at this point. But, in the course of doing this trial effort, I discovered that my data files have missing one-minute samples. I'd guess it's on the order of 0 - 2 missing samples for every 2 hours. Looks like my home LAN, and my ISP's WAN are not capable of getting every singe one-minute WEL sample 'out the door.'
So, using the Modulo Division technique to easily 'cull out' samples, for me the sample time-of-day slowly drifts forward across a 24 hour day.
I looked at my 50 week charts to see how much this drift would affect the charts - I have 3 total.
All 3 are either:
samples of a 24 hour rolling avg (EWT);
samples of a monthly accumulation (KWH Energy Consumption);
or samples of a per day avg figured on a monthly basis (daily heating/cooling load of the residence).
Thus, slowly drifting time-of-day sampling isn't going to make any difference for me, and therefore I don't need to make any further adjustments to the sort process.
Once again, Ethan, thanks!
Best regards,
Bill
WEL0043
Responses
|
An exercise in Energy Smart, Not So Big living. www.OurCoolHouse.com - Ideas @OurCoolHouse.com
|
This site is all about building a cool, energy efficient house, that makes maximum use of earth sheltered design, passive solar heating and cooling, geothermal exchange energy management, and right sizing of the house for it's designated use. The home's placement is on a south-facing hillside in Deep Creek Lake, Maryland. This site describes the design process, the technologies used and the expected results. We also have a comprehensive Links Page for anyone who is also interested in designing a similar project.