Annual T-Stat Setback or Increase Vs. Coal Consumption

 
User avatar
lsayre
Member
Posts: 21781
Joined: Wed. Nov. 23, 2005 9:17 pm
Location: Ohio
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Lehigh Anthracite Pea
Other Heating: Resistance Boiler (13.5 KW), ComfortMax 75

Post by lsayre » Fri. Oct. 28, 2016 10:33 am

For those of us with thermostat (T-Stat) regulated home heating, I have whipped up a quick and simple calculator (spreadsheet) that will compute what you should expect to gain or lose annually in pounds of coal by either setting back or increasing your thermostat temperature. This simple spreadsheet is not for programmed daily changes, but only for entire season changes in your T-Stat's setting. Spreadsheet is attached.

Note: I was lazy, so you must enter temperature decreases in the top section as positive values. And then enter temperature increases in the bottom section, also as positive values. All degree changes are for the Fahrenheit scale. You must fill in (provide) the tan section values. Output is the orange section values.

Note2: Written in Linux, so as always, please kick the tires and let me know if it works in Windows.
T_Stat_VS_Coal_Usage.xls
.XLS | 9.2KB | T_Stat_VS_Coal_Usage.xls


 
User avatar
Sunny Boy
Member
Posts: 25698
Joined: Mon. Nov. 11, 2013 1:40 pm
Location: Central NY
Hand Fed Coal Boiler: Anthracite Industrial, domestic hot water heater
Baseburners & Antiques: Glenwood range 208, # 6 base heater, 2 Modern Oak 118.
Coal Size/Type: Nuts !
Other Heating: Oil &electric plenum furnace

Post by Sunny Boy » Fri. Oct. 28, 2016 10:40 am

Thanks Larry.
I have Windows 7 with just the basic "Microsoft Excel Starter 2010" program and it showed up fine.

Paul

 
franco b
Site Moderator
Posts: 11417
Joined: Wed. Nov. 05, 2008 5:11 pm
Location: Kent CT
Hand Fed Coal Stove: V ermont Castings 2310, Franco Belge 262
Baseburners & Antiques: Glenwood Modern Oak 114
Coal Size/Type: nut and pea

Post by franco b » Fri. Oct. 28, 2016 10:58 am

Vista opened it in Works but said there were errors. filled in the bianks but got no result.

 
User avatar
lsayre
Member
Posts: 21781
Joined: Wed. Nov. 23, 2005 9:17 pm
Location: Ohio
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Lehigh Anthracite Pea
Other Heating: Resistance Boiler (13.5 KW), ComfortMax 75

Post by lsayre » Fri. Oct. 28, 2016 11:18 am

franco b wrote:Vista opened it in Works but said there were errors. filled in the bianks but got no result.
It likely requires Excel in Windows, or you can use a free spreadsheet called LibreOffice in Linux. UNIX, or Windows. It was generated using LibreOffice.

 
User avatar
lsayre
Member
Posts: 21781
Joined: Wed. Nov. 23, 2005 9:17 pm
Location: Ohio
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Lehigh Anthracite Pea
Other Heating: Resistance Boiler (13.5 KW), ComfortMax 75

Post by lsayre » Fri. Oct. 28, 2016 11:21 am

Unlike the information you get on the internet whereby everything is guessing, the spreadsheet uses your homes past historical data and your areas actual HDD demand to compute your personal expectation for savings/loss. Should be far more reliable than the typical government (or anyone else's) guesswork.

The LibreOffice Suite is a free download. Gives you about 90% of the power of the Microsoft Office Suite for free.

https://www.libreoffice.org/

 
User avatar
Rob R.
Site Moderator
Posts: 18003
Joined: Fri. Dec. 28, 2007 4:26 pm
Location: Chazy, NY
Stoker Coal Boiler: EFM 520
Hand Fed Coal Stove: Chubby Jr

Post by Rob R. » Fri. Oct. 28, 2016 11:39 am

I thought the old rule was 1% for every degree ?

 
User avatar
lsayre
Member
Posts: 21781
Joined: Wed. Nov. 23, 2005 9:17 pm
Location: Ohio
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Lehigh Anthracite Pea
Other Heating: Resistance Boiler (13.5 KW), ComfortMax 75

Post by lsayre » Fri. Oct. 28, 2016 11:45 am

Rob R. wrote:I thought the old rule was 1% for every degree ?
The governments "one answer fits all" guess is (or at least used to be) 3% for every degree. My program does not use pre-determined percentages (rules of thumb) such as 1% or 2% or 3%. It tries to calculate what you will more likely actually experience. No rules of thumb used here.

The basic spreadsheet logic is as follows:

Lets assume a case where someone typically heats their home for 200 days out of the year, and their area typically sees 6,000 HDD's (heating degree days), and they typically burn 7,000 lbs. of coal.

7,000/6,000 = 1.167 lbs. burned per HDD
7,000/200 = 35 average pounds burned per day

Backing down by 1 degree on your thermostat for an entire season is the same as going through a heating season that averages 1 degree warmer outside than the typical season. Call it the 'Theory of Temperature Relativity'.

Therefore, for this example: Instead of averaging 35 lbs per day burned, you will experience 35-1.167 = 33.833 lbs. per average day burned if you set the T-Stat back 1 degree.

(1.167/35 ) x 100 = 3.33% "typical season" savings
33.833 lbs/day x 200 days = 6,767 lbs. burned for the "typical" season (instead of 7,000).


 
User avatar
lsayre
Member
Posts: 21781
Joined: Wed. Nov. 23, 2005 9:17 pm
Location: Ohio
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Lehigh Anthracite Pea
Other Heating: Resistance Boiler (13.5 KW), ComfortMax 75

Post by lsayre » Fri. Oct. 28, 2016 1:32 pm

As long as your home is heated via T-Stat(s), the spreadsheet also works properly for other fuels. Electricity, Propane, Oil, NG, etc ...

Just substitute your annual gallons of oil, KWH of electricity, gallons of propane, Therms (or CCF or MCF) of NG, etc... where the spreadsheet asks for your annual coal usage.

 
User avatar
Scottscoaled
Member
Posts: 2812
Joined: Tue. Jan. 08, 2008 9:51 pm
Location: Malta N.Y.
Stoker Coal Boiler: EFM 520, 700, Van Wert 800 GJ 61,53
Baseburners & Antiques: Magic Stewart 16, times 2!
Coal Size/Type: Lots of buck
Other Heating: Slant Fin electric boiler backup

Post by Scottscoaled » Fri. Oct. 28, 2016 3:53 pm

This is Great!!!!!! If I keep my house 30 degrees colder all winter, I won't even have to buy coal! :lol: :lol: :lol:

 
User avatar
lsayre
Member
Posts: 21781
Joined: Wed. Nov. 23, 2005 9:17 pm
Location: Ohio
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Lehigh Anthracite Pea
Other Heating: Resistance Boiler (13.5 KW), ComfortMax 75

Post by lsayre » Fri. Oct. 28, 2016 3:58 pm

Scottscoaled wrote:This is Great!!!!!! If I keep my house 30 degrees colder all winter, I won't even have to buy coal! :lol: :lol: :lol:
:lol: But your pipes will freeze! :lol:

Moderation is a wonderful thing. Please try to use the tool realistically.

As I've played with it, I've determined that the governments 3% savings per degree of setback was about right. The way they got it wrong was in saying that this degree of savings could be achieved by raising and lowering your T-Stats daily. The embarrassment that caused when it proved to not be true has since caused them to stop publishing such rot. To make it work (within moderation) you need to lower them and leave them that way for the whole winter season.
Last edited by lsayre on Fri. Oct. 28, 2016 4:06 pm, edited 3 times in total.

 
User avatar
Rob R.
Site Moderator
Posts: 18003
Joined: Fri. Dec. 28, 2007 4:26 pm
Location: Chazy, NY
Stoker Coal Boiler: EFM 520
Hand Fed Coal Stove: Chubby Jr

Post by Rob R. » Fri. Oct. 28, 2016 4:00 pm

I would have to turn my thermostat down 7 degrees to save 1 ton of coal. I am thinking the extra blankets and lawyer bills may erase the coal savings. :lol:

 
User avatar
lsayre
Member
Posts: 21781
Joined: Wed. Nov. 23, 2005 9:17 pm
Location: Ohio
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Lehigh Anthracite Pea
Other Heating: Resistance Boiler (13.5 KW), ComfortMax 75

Post by lsayre » Fri. Oct. 28, 2016 4:12 pm

Rob R. wrote:I would have to turn my thermostat down 7 degrees to save 1 ton of coal. I am thinking the extra blankets and lawyer bills may erase the coal savings. :lol:
Or alternately, for the price of 1 ton of coal you could keep your house 7 degrees warmer. Mama may like that! :)

 
User avatar
Rob R.
Site Moderator
Posts: 18003
Joined: Fri. Dec. 28, 2007 4:26 pm
Location: Chazy, NY
Stoker Coal Boiler: EFM 520
Hand Fed Coal Stove: Chubby Jr

Post by Rob R. » Fri. Oct. 28, 2016 4:24 pm

I haul enough coal and ash as it is.

 
User avatar
lsayre
Member
Posts: 21781
Joined: Wed. Nov. 23, 2005 9:17 pm
Location: Ohio
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Lehigh Anthracite Pea
Other Heating: Resistance Boiler (13.5 KW), ComfortMax 75

Post by lsayre » Fri. Oct. 28, 2016 4:27 pm

Rob R. wrote:I haul enough coal and ash as it is.
I'm right with you there.

 
User avatar
Lightning
Site Moderator
Posts: 14669
Joined: Wed. Nov. 16, 2011 9:51 am
Location: Olean, NY
Stoker Coal Boiler: Modified AA 130
Coal Size/Type: Pea Size - Anthracite

Post by Lightning » Fri. Oct. 28, 2016 4:32 pm

Couldn't you achieve the same calculation by subtracting 200 hdds from the total? In using your example of dropping the thermostat one degree?


Post Reply

Return to “Stoker Coal Boilers Using Anthracite (Hydronic & Steam)”