Re: Household electrical current to Excel ???

["Declan McEvoy" <ngacs@xxxxxxxxxx>]

That data logger and current clamp looks good. I wonder can it pass the info
directly to Excel without having to gather and store the collected data. I
wonder what the approx cost of the logger and clamp is?

The problem (I think) with the second option, the optical sensor is that it
takes a long time for one rev of the disk if there is only minimal things
happening in the house and so the responsivness of seeing the effects of
turning on and off appliances for short periods (10 secs) might not be good
or immediate.

Declan


"Palindr?me" <sb382638@xxxxxxxxxxxxxxxxxxx> wrote in message
news:11h6b85ndb3eg28@xxxxxxxxxxxxxxxxxxxxx

> >
> You can get a data logger, with a split core sensor, that will sense the
> current in your main supply cable and pass the data to a computer and
> hence to your spread sheet. It won't be as accurate as the supply meter
> but should do for what you want.
>
> http://www.onsetcomp.com/Newsletters/4880_home_power.html
>
> The point of the split core sensor is that it just clips onto the live
> but insulated wire from the meter/supply fuse - no having to go near any
>   bare wires or contacts.
>
> You may think it a bit pricey though.
>
> If you are into electronics, an opto-reflective switch held on the face
> of the electricity supplier's consumption meter may do it. Mine did,
> just held in place with Blutac and aligned to look at the face of the
> rotating meter disk with its black markings. Just feed the output from
> it into the parallel port and count the transitions. That was very cheap
> - the opto-switch came out of a defunct vcr.
>
>
> --
>
> Sue
>