measure how many hours a switch is on?

[johnlewis]

Is there a way to create a time that would tell you how long something is tuned on per day? I am trying to calculate how long my heaters are on per day. I would also like to do the same thing with my make up water solenoid for my RO is on.

Thanks

 

[swearint]

I am not aware of a way to calculate an accumulated time automatically. The only way I know of is to either look at a graph or XML report of the outlet and manually total the time.

Todd

 

[trivan]

This can be done in Excel.

- Go to the outlet xml, and if in IE, right click and there should be a open in Excel option. If you don't have this or Excel. I can't really help anymore then that
- Then subtract the on time and off time for each pairing
- You will have to use the following formula to convert the number into time format: =TEXT ((Sum(a1:a5),"h:mm") replacing a1:a5 with where your values are.

Hopefully this makes sense.

 

[aquamanic]

Go to the outlet xml, and if in IE, right click and there should be a open in Excel option.

I don't think that's an option.

 

[swearint]

Worked for me, though that may be specific to the way things are set up here at work. Once on the XML page, right click brought up a windows menu, toward the bottom was 'Export to Microsoft Excel'. You then have to log in to the Apex several times, even though I was already logged in. I did not actually try to manipulate the data much other than sorting by outlet.

Todd

 

[RussM]

It worked for me with Win7/IE8/Office2010, after jumping through some hoops as Swearint described. But it mangled the dates.

There is a better way...

Use the Outlet Log Processor on Reeftronics. The data is reformatted and output in plain text with the events from each outlet grouped together in chronological order. Click on the output anywhere, press CTRL-A, then copy the data and paste into Excel.... Massage the data as desired.

 

[Hawkdl2]

Russ,

+1 on using the Reeftronics approach. That is how I've done it in the past, but I never managed to come up with an easy way to extract total time for an outlet without having to manually copy equations to each "ON" or "OFF". Have you figured out how to automate the massaging part?

 

[aquamanic]

Interesting - didn't work at all in Win7/Firefox/Office 2010 but did in Win7/IE9/Office 2007.

 

[johnlewis]

Thanks the export worked. I found out they do not cycle much, but are on many hours per day.