|
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 |
Long Term Charts
[ Read Responses | Return to the Index ]
[ ]
Posted by Bill on Tuesday, 26 August 2008, at 10:08 a.m.
I'd like to fix one of my "bad habits" related to my WEL usage (WEL0043), but I'm not able to figure out how to do it. I'd appreciate some help, please.
As Phil notes in another thread, I have a few 50 week duration WEL charts. These are pretty fundamental charts that have sparked considerable dialog amongst those that have chatted with me in the past on my WEL implementation - such as my Entering Water Temp chart.
Noting Phil's comments on data reliability, I indeed log key device data, religiously offload monthly log files from the WEL server, and even make sure to backup these files to another location here at home.
But what I've got are these monster WEL-produced log files, with key device data recorded every minute, resulting in over 43,000 'rows' of data for each monthly file. And add up the number of months so far for me (8), that's over one-third million rows of data to attempt to 'off-line' chart from.
As noted, what I want are a few long term charts that are approximately 1 year in duration. While it puts a lot of dependence on the WEL server (and network connections near and far), the only way I know at the moment how to create a 3 sample per day chart is to use the WEL charting capability to do it.
So I'll agree I have a "bad habit" here, using the WEL server to keep up with long term data, but, I don't know how else to do it. And I'd actually prefer to do it 'off-line' with a nice Excel-based chart if I knew how to do it.
Does anyone know how to 'sift' through WEL-produced monthly 43,000+ row tables, to pick up, for example, just 3 samples per day?
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.