Automatic Coal Consumption Tracking

Re: Automatic Coal Consumption Tracking

PostBy: mdrelyea On: Fri Jan 11, 2013 11:42 pm

So I gotta share this bit of awesomeness... With the rotation counting, I just predicted how much coal it would take to fill my hopper to within 0.3 pounds... I predicted 187.3 pounds required to fill the hopper based on the number of revolutions since it was last filled up. It actually took 187.0 Seeing as how the scale I weigh it on can only resolve to the nearest 0.5 pounds I'd call that a resounding success!
mdrelyea
 
Hot Air Coal Stoker Furnace: Alaska 140 Auger
Hand Fed Coal Stove: Russo #2
Coal Size/Type: Anthracite Rice/Nut

Re: Automatic Coal Consumption Tracking

PostBy: KLook On: Sat Jan 12, 2013 12:53 am

Really dude, you gotta get out more. :shock: :P

Kevin
KLook
 
Stoker Coal Boiler: Harman VF 3000
Coal Size/Type: rice, bagged, Blaschak
Stove/Furnace Make: Harman (Back In Maine)
Stove/Furnace Model: VF 3000

Re: Automatic Coal Consumption Tracking

PostBy: dcrane On: Sat Jan 12, 2013 5:54 am

mdrelyea wrote:So I hooked up a pedometer to the shaft of the feed auger on my Alaska 140. It worked great to track the number of revolutions. I kept good records to determine that 1 revolution feeds about 0.1017 lbs of my oiled Reading coal. Sure would be nice, I thought, to not have to write down the number of revolutions. Since I have a computer that is always on, I wanted to record a date/time on the computer each time a revolution was recorded. That would give me the best possible resolution on my consumption data.

The normal solution there is to hook a switch up to a serial port and write your own program to do it. Since a lot of computers now don't even come with a serial port I wanted to do it via USB. After a lot of searching I found this little board. To the computer it looks like a keyboard (or a mouse, or a gamepad).

Using the technique I had learned when hooking up the pedometer, I put a magnet on the shaft of the auger and a reed switch mounted off to the side of the auger. I hooked up the reed switch to the board that I bought and plugged that in to a USB port. I configured the board so that every time the switch was triggered it looked like I had pressed Ctrl-Shift-Alt-E on the keyboard. I then set up a very small batch file with one command:
echo 1,%date:~4% %time:~0,8% >> "%userprofile%\My Documents\Revolutions %date:~4,2%-%date:~-4%.csv"
which just adds a new line containing the number of revolutions (just 1) and the date/time to a file in the My Documents folder. It will create a new file each month. Finally, created a desktop shortcut to my batch file and then assigned a shortcut key to the desktop shortcut. My shortcut key is Ctrl-Shift-Alt-E.

So, whenever the feed auger makes a full revolution, the reed switch is triggered, my computer sees a Ctrl-Shift-Alt-E, runs my batch file, and records a date/time in a file on my computer. I've had it running for a few days now and it is working great.

I no longer need to weigh my coal or write anything down to keep track of my consumption - and I can track it much more closely than I ever did before!


I call innovation of the month :D (i dont think we have such a title yet... cough cough...Rich! LOL)
Time to send this idea down to the patent office :P hehehe
dcrane
 
Hand Fed Coal Stove: Crane 404

Visit Lehigh Anthracite

Re: Automatic Coal Consumption Tracking

PostBy: lsayre On: Sat Jan 12, 2013 8:46 am

I thought I was doing pretty good with hitting my advanced usage predictions within typically about 8-10 lbs. over a 3 day period, but this level of precision is awesome. :clap:

That said, counting revolutions after they have occurred is not predictive of coal consumption in advance based upon the weather conditions. It is only precision achieved after the fact. Prediction should be your next step. Predicting revolutions per HDD (in advance of them happening) will turn this into a powerful coal consumption forecasting tool.
lsayre
 
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Anthracite Pea
Other Heating: Resistance Boiler (It has been fixed!)

Re: Automatic Coal Consumption Tracking

PostBy: dcrane On: Sat Jan 12, 2013 8:55 am

lsayre wrote:I thought I was doing pretty good with hitting my advanced usage predictions within typically about 8-10 lbs. over a 3 day period, but this level of precision is awesome. :clap:

That said, counting revolutions after they have occurred is not predictive of coal consumption in advance based upon the weather conditions. It is only precision achieved after the fact. Prediction should be your next step. Predicting revolutions per HDD (in advance of them happening) will turn this into a powerful coal consumption forecasting tool.


Mehhhh, details details LOL.... its a cool gogo gadget either way :up:
dcrane
 
Hand Fed Coal Stove: Crane 404

Re: Automatic Coal Consumption Tracking

PostBy: mdrelyea On: Sat Jan 12, 2013 12:11 pm

lsayre wrote:That said, counting revolutions after they have occurred is not predictive of coal consumption in advance based upon the weather conditions. It is only precision achieved after the fact. Prediction should be your next step. Predicting revolutions per HDD (in advance of them happening) will turn this into a powerful coal consumption forecasting tool.


RIght. Step one though is to make sure that I have a good measurement system. Wouldn't do me any good to base my predictions on a crappy measurement system.
mdrelyea
 
Hot Air Coal Stoker Furnace: Alaska 140 Auger
Hand Fed Coal Stove: Russo #2
Coal Size/Type: Anthracite Rice/Nut

Re: Automatic Coal Consumption Tracking

PostBy: mdrelyea On: Sun Jan 13, 2013 10:54 pm

I looked back through my data this evening and not all of the data is as close as it was this last time. It varied from predicting 3.5 lbs to much to 4.1 pounds to little.
Lbs Data.png
(28.56 KiB) Viewed 25 times
View: New PagePopup • Select:BBCode
[nepathumb]39608[/nepathumb]
Lbs data.xls
(34.5 KiB) Not downloaded yet
Select:BBcode: [nepafile=39609]Lbs data.xls[/nepafile]
mdrelyea
 
Hot Air Coal Stoker Furnace: Alaska 140 Auger
Hand Fed Coal Stove: Russo #2
Coal Size/Type: Anthracite Rice/Nut

Re: Automatic Coal Consumption Tracking

PostBy: lsayre On: Mon Jan 14, 2013 2:16 pm

Pretty close overall though. Still good info.
lsayre
 
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Anthracite Pea
Other Heating: Resistance Boiler (It has been fixed!)

Re: Automatic Coal Consumption Tracking

PostBy: mdrelyea On: Tue Feb 12, 2013 9:55 pm

For anyone thinking of giving this a shot, I highly recommend it. I'm seeing very good results. If I were to do it over again I might try something other than a reed switch as a sensor. I occasionally get a double hit on it - meaning that one rotation is counted as two. Seems to happen on average once a day or so. At that frequency it's within the noise of my weight measurement system so I am not going to change it now. Maybe while I'm shut down during the summer I'll change it if I'm not busy mowing or gardening! :lol:

I'm seeing an excellent correlation between number of rotations and pounds of coal used.
RotationsVSlbs.png
(18.25 KiB) Viewed 5 times
View: New PagePopup • Select:BBCode
Scatter Plot of rotations and pounds
[nepathumb]40521[/nepathumb]
mdrelyea
 
Hot Air Coal Stoker Furnace: Alaska 140 Auger
Hand Fed Coal Stove: Russo #2
Coal Size/Type: Anthracite Rice/Nut

Visit Lehigh Anthracite