Export activity for one sensor to Excel (can be manual)

Configuration
1

I have a pump that is misbehaving…I have a sensor that goes from off to on:

image
image480×860 40.9 KB

I’m trying to find and easy way to capture the times of each off and on cycle change.

I’m not so interested in the Reset Cycle as it is pretty much 1:12 every time (mechanical setting). But once in a while, as shown, the change from ON to OFF is shorter. We don’t know why. So seeing this might help.

When the Reset Cycle is over the pump runs: Sensor state changes from OFF to ON. This I am interested in, but of course will end up grabbiing ALL changes, which is fine.

All of these are captured in the Activity area…but I’d like a way to grab them and dump them into Excel for analysis. I do NOT need to automate this (though if easy would be nice) and am happy to do so manually.

I can’t figure out how to do so. Simply would be best for me right now.

2

I use the File integration for this kind of thing. Pretty easy to then set up an automation that triggers on its state change and you have all the trigger data available to you to throw into a CSV file which you can import into your favourite spreadsheet program.

3

Google sheets

Or use the download button in history.

1000002305
10000023051220×2712 183 KB

4

Ok - that was WAY too stupid easy!! Thanks I had no idea one could do that…

(Didn’t we used to be able to mark a post as the solution?)