Coal Consumption Spreadsheet

Coal Consumption Spreadsheet

PostBy: traderfjp On: Sun Oct 05, 2008 7:47 am

Hi,

I created a spreadsheet in Word to record the date, H/L outside temps, bags loaded into stove, and ash bin emptied. I thought I would share it here and it can be modified or used as is. Just download the attachment and have fun.
Attachments

[The extension doc has been deactivated and can no longer be displayed.]

traderfjp
 
Stove/Furnace Make: Alaska
Stove/Furnace Model: Channing 3

Re: Coal Consumption Spreadsheet

PostBy: Linc On: Sun Oct 05, 2008 8:23 am

Thanks Trader. :D
Linc
 
Hand Fed Coal Stove: Alaska Kodiak Stoker
Coal Size/Type: Rice

Re: Coal Consumption Spreadsheet

PostBy: traderfjp On: Sun Oct 05, 2008 8:31 am

Remember to disable macros when u download the file.
traderfjp
 
Stove/Furnace Make: Alaska
Stove/Furnace Model: Channing 3


Re: Coal Consumption Spreadsheet

PostBy: k9 Bara On: Sun Oct 05, 2008 11:00 am

Trader,

Ty, and I thought I was a freak keeping a note book for out/in side temps, stove settings and coal consumption. :)

Thanks for sharing.
k9 Bara
 
Stoker Coal Boiler: EFM
Coal Size/Type: Rice Anthricite

Re: Coal Consumption Spreadsheet

PostBy: Linc On: Sun Oct 05, 2008 12:35 pm

I modified it to record the inside temp/outside temp. Pounds used to top of the hopper and which Dealer and what brand of coal the dealer was/is selling. This way I can compare the useage and brands to see which is burning the most efficient in my stove and the ash content of each.
Linc
 
Hand Fed Coal Stove: Alaska Kodiak Stoker
Coal Size/Type: Rice

Re: Coal Consumption Spreadsheet

PostBy: traderfjp On: Sun Oct 05, 2008 1:20 pm

Linc: Can u upload it I may want to use yours instead. I thought we could treat it like a Wikie and keep tweking it.
traderfjp
 
Stove/Furnace Make: Alaska
Stove/Furnace Model: Channing 3

Re: Coal Consumption Spreadsheet

PostBy: LsFarm On: Sun Oct 05, 2008 1:22 pm

To be a 'freak' you need to add columns for wind speed and direction, sunrise and sunset [solar heat gain], cloudy or not. The draft in the chimney, and temperature in the chimney recorded on a drum-recorder... Need to weigh the ash to compare with weight of coal added in previous 24hrs.

Now all the above would be a bit much.. but oops I forgot,, a Bacharach exhaust gass tester to record CO and CO2 levels so burn effiecency can be calculated..

:lol: :D :lol:

I just keep the hopper full, and look at the amount of ash at the end of the week..

Greg L

.
LsFarm
 
Stoker Coal Boiler: Axeman Anderson 260
Hand Fed Coal Boiler: Self-built 'Big Bertha' SS Boiler
Baseburners & Antiques: Keystone 11, Art Garland

Re: Coal Consumption Spreadsheet

PostBy: traderfjp On: Sun Oct 05, 2008 1:35 pm

To each his own and I'm a coal freak. My stove is sipping coal as we speak with its new Coaltrol and magnetic thermostat. Anyway, I want to know my coal consumtion for the season at the least. That way I can hoard more coal to get me to retirement. I have about 9 years worth if I'm correct about burning 3 tons a year.
traderfjp
 
Stove/Furnace Make: Alaska
Stove/Furnace Model: Channing 3

Re: Coal Consumption Spreadsheet

PostBy: marvin On: Sun Oct 05, 2008 2:29 pm

Thanks for the spreadsheet. This will come in handy!
marvin
 
Stove/Furnace Make: Harman
Stove/Furnace Model: DVC-500

Re: Coal Consumption Spreadsheet

PostBy: Linc On: Sun Oct 05, 2008 6:48 pm

Trader, I have no idea how to upload it. I'm still very much a rookie with computers.LOL. All I did was download your spreadsheet.Clicked on the headers of each catagory and changed them to what I wanted and then saved the new format.
Linc
 
Hand Fed Coal Stove: Alaska Kodiak Stoker
Coal Size/Type: Rice

Re: Coal Consumption Spreadsheet

PostBy: traderfjp On: Sun Oct 05, 2008 7:08 pm

No problem - I really have all the data I need anyway.
traderfjp
 
Stove/Furnace Make: Alaska
Stove/Furnace Model: Channing 3

Re: Coal Consumption Spreadsheet

PostBy: EarthWindandFire On: Thu Oct 27, 2011 1:18 pm

I downloaded this and made a few modifications.

Thanks to trader for making it and sharing his hard work.

I'll start my record keeping on November 1st. I personally love statistics so this should be interesting for me.
EarthWindandFire
 
Hot Air Coal Stoker Furnace: Leisure Line Lil' Heater.
Hand Fed Coal Stove: Hitzer model 75. (sold)
Other Heating: Oil Furnace and Kerosene Heaters.

Re: Coal Consumption Spreadsheet

PostBy: freetown fred On: Thu Oct 27, 2011 1:36 pm

I'm with you Greg. ;)
LsFarm wrote:To be a 'freak' you need to add columns for wind speed and direction, sunrise and sunset [solar heat gain], cloudy or not. The draft in the chimney, and temperature in the chimney recorded on a drum-recorder... Need to weigh the ash to compare with weight of coal added in previous 24hrs.

Now all the above would be a bit much.. but oops I forgot,, a Bacharach exhaust gass tester to record CO and CO2 levels so burn effiecency can be calculated..

:lol: :D :lol:

I just keep the hopper full, and look at the amount of ash at the end of the week..

Greg L

.
freetown fred
 
Hand Fed Coal Stove: HITZER 50-93
Coal Size/Type: BLASCHAK Nut/Stove mix

Re: Coal Consumption Spreadsheet

PostBy: Rob R. On: Thu Oct 27, 2011 2:00 pm

I have been recording the hour meter reading on my EFM each day for the last couple weeks. When I get a few more weeks of data I will share it.
Rob R.
 
Stoker Coal Boiler: EFM DF520
Hand Fed Coal Stove: Hitzer 50-93
Coal Size/Type: Lehigh Rice
Other Heating: Dad's 1953 EFM Highboy

Re: Coal Consumption Spreadsheet

PostBy: Rob R. On: Thu Oct 27, 2011 7:53 pm

Coal Usage.jpg
(32.26 KiB) Viewed 45 times
View: New PagePopup • Select:BBCode
[nepathumb]30311[/nepathumb]


If I have the proper motivation to keep taking readings through the winter this will get interesting.
Rob R.
 
Stoker Coal Boiler: EFM DF520
Hand Fed Coal Stove: Hitzer 50-93
Coal Size/Type: Lehigh Rice
Other Heating: Dad's 1953 EFM Highboy