| Author |  | 
      
        | crisx Groupie
 
  
  
 Joined: September 14 2006
 Location: United States
 Online Status: Offline
 Posts: 72
 | 
          Thought I'd just throw this out here to see if this is something that could be incorporated into PowerHome.  It's not tremendously useful, but would be an opportunity to look at pretty charts of your insteon usage.  For several months I have been tracking Insteon device usage.  Every time a light switch is pushed, a powerhome trigger runs a macro (that runs a script) that enters the date and time, and the switch that was pushed into an external database.  After a subsequent push of the button, the script goes back and enters the 'minutes at this state' into the database.  Thus, I have a database of how long each light/device was on or off over the last several months.  I haven't done much with it, but it seems to work fairly consistently.  I threw together a quick chart just to demonstrate the potential:
           | Posted: January 31 2007 at 18:40 | IP Logged |   |  
           | 
 |  
 
   
 The 'Reports' tab of the Insteon Explorer kind of gave me the idea, but the possibilities of data manipulation are endless.  You could be able to see what time of day you use a specific light the most, compare different light usage, view usage by day, week, month, year... Like I said, not very practical, but still fun to play with and might help give some 'eye candy' to powerhome.
 
 Thoughts?
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | crisx Groupie
 
  
  
 Joined: September 14 2006
 Location: United States
 Online Status: Offline
 Posts: 72
 | 
          Playing around some more....
           | Posted: January 31 2007 at 18:57 | IP Logged |   |  
           | 
 |  
 
 
   | 
       
        | Back to Top |     | 
       
       
        |  | 
        | Viper Groupie
 
  
 
 Joined: January 14 2007
 Location: United States
 Online Status: Offline
 Posts: 88
 | 
          Add a wattage factor to each item and you start getting some very useful data
           | Posted: February 01 2007 at 07:52 | IP Logged |   |  
           | 
 |  | 
       
        | Back to Top |     | 
       
       
        |  | 
        | crisx Groupie
 
  
  
 Joined: September 14 2006
 Location: United States
 Online Status: Offline
 Posts: 72
 | 
          True, I thought of that and even started recording dim/bright levels, but got in a little over my head with 'data overload'.  Ultimately, though, this could be useful - add in cost per Kw from your electric bill and you can see what each device costs you each week/month/day/year.
           | Posted: February 01 2007 at 10:44 | IP Logged |   |  
           | 
 |  | 
       
        | Back to Top |     | 
       
       
        |  | 
        | dhoward Admin Group
 
  
  
 Joined: June 29 2001
 Location: United States
 Online Status: Offline
 Posts: 4447
 | 
          Cris,
           | Posted: February 01 2007 at 14:25 | IP Logged |   |  
           | 
 |  
 Excellent work!  What external database do you use?  I can see where something like this would be very useful to some people.
 
 I'll keep this info in mind to see what could possibly be integrated directly within PowerHome.
 
 Dave.
 
 | 
       
        | Back to Top |       | 
       
       
        |  | 
        | crisx Groupie
 
  
  
 Joined: September 14 2006
 Location: United States
 Online Status: Offline
 Posts: 72
 | 
          Dave,
           | Posted: February 01 2007 at 23:46 | IP Logged |   |  
           | 
 |  
 I just used MS Access because I'm familiar with it and it happened to be on my PH computer.
 
 Thanks for considering this.
 
 Cris
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | lazyone Newbie
 
  
 
 Joined: February 21 2006
 Online Status: Offline
 Posts: 5
 | 
          This is the type of functionality I would really like to see in PH.  AND, if we could also log temperatures, weather data, security sensors, everything, this would be extremely useful to me.
           | Posted: February 02 2007 at 18:45 | IP Logged |   |  
           | 
 |  
 The function to add some "math" like runtime, as crisx has, would make this even better.
 
 I have accomplished a little bit of this with my Elk and Homeseer, but I would prefer to see it integrated into PH.
 
 lz
 | 
       
        | Back to Top |     | 
       
       
        |  |