Steam Boiler Calculator
I've been working on a steam boiler excel sheet to help size boiler systems and predict performance. It's not done and I have other features I plan on adding. I thought I would upload it here if anyone is interested in using/giving feedback on the calculator. I'll be using the sheet this winter on a few boilers that are already installed that I have access to see how accurate it is.
How it works: Inputs are in orange, outputs are in blue.
The Main sheet takes the GROSS BTU/HR, the water in the boiler when filled to the water line(gal), operating pressure(psig), the weight of the boiler(lbs). The pipe size and count of the risers(the ID is accounted for each pipe size), the size and length of the main line(feet). The main vent that is installed and the number of vents.
The Radiators sheet has a heat load(%) calculation so that after you input the radiator information for the building you can change the heatload on the system. You have the option of radiator type: Column, tube, cast iron radiator/convetor and copper cabinets. Each of these radiator types references EDR tables using the height, number of tubes, and number of sections. You can also input the length of the upfeed pipe from the main, the size of pipe will automatically calculated. Finally the vent/trap can be selected. It takes data from vent tables from the venting capacity chart(at 3oz).
The volume of each radiator type is accounted for, the volume of the main, and the upfeed to the radiator is also accounted for. The radiation off the main and off the upfeed is calculated, right now it assumes no insulation, I may change that later. However, when I put in the data for an actual radiator system I have access to I did get a pickup factor of 1.6, which is a reasonable answer.
Finally the pressure drop is calculated using the appropriate steam charts. This should predict the necessary system pressure to read the farthest radiator. It isn't perfect because the way it is calculated right now all of the radiators come off the very end of the main line and are fed individually.
More to be added:
The heat of enthalpy is dependent on pressure. This is calculated for the boiler, but it will be different in each radiator. But the math is more difficult and right now it is set to 970btu/lb.
Insulation options for the mains and upfeeds.
A selectable list of boilers with all of the applicable performance information.
With the data available for the vents it should be possible to extrapolate and model the vents and traps as orifices for more pressure variation. But may be dependent on low reynolds number effects and may not be accurate.
It should be possible to calculate how long the boiler needs to run to get to pressure and how long it will be off before it turns back on. But that will take a lot of work.
Right now the calculator does NOT work for single pipe steam. I figure they are so small that it's not worth the effort.
Owner
Steamnowrockford.com
Comments
-
-
I agree there are many variables, however in my engineering career I have been able to make reasonable simplifications to a system and still arrive at an accurate solution. The same must be possible with steam systems. The enormous cost of these systems when originally installed tells me that they must have done engineering estimates before installation. The same physics is still known, from many steam tables for steam properties and pipe radiation. I do not pretend it will be easy, only possible. Mr Holohan discusses the steam systems using basic physics, of course there are rules of thumb, but the physics has not changed and should be repeatable.
Owner
Steamnowrockford.com
1 -
fairly large 1 pipe steam systems are common in some areas.
0 -
Interesting set of comments. There is one key element about steam heating: it is incredibly forgiving. We often make a fairly big production out of getting the header "just right" or making sure the insulation — if any — is properly accounted for and all of that. But, at the end of the day, it turns out that steam systems — whether one pipe or two, or "normal pressure" or "vapour" work most of the time with careful craftsmanship and attention to detail.
I have no beef with @SteamNow 's efforts here — in fact, I applaud them. And, of course, his comment that it must be possible to apply more rigorous engineering to them is quite correct. That said, however, there is a classic engineering problem here: there is a very large number of variables, and some of them have a very large impact on exactly how the system will operate on a given day. That wouldn't be too bad, except that… most of these variables are very poorly quantified (e.g. the heat output of a radiator on a given day) and may have rather large uncertainties (plus or minus 10% would be quite reasonable for some of them). So while the output of a mathematical set of calculations such as is proposed may appear to have great precision, the accuracy may be rather poor. Not through any fault of the computations, but simply because even the known data are poorly quantified.
This makes the engineering of a heating system quite unlike some other engineering disciplines — some branches of mechanical or aeronautical or electrical come to mind — where accuracies on the better than one percent level are to be expected routinely, this is much more like geotechnical or most of civil engineering, where coming within 10 percent of the real world on a given day is cause for considerable celebration.
I do have one perhaps minor disagreement with one statement, however: it is stated "It should be possible to calculate how long the boiler needs to run to get to pressure and how long it will be off before it turns back on." If by "get to pressure" is meant "get to an equilibrium operating pressure on start up of a cycle", then one can expect to calculate it, subject to the comments I made above; both the ambient environment and the preexisting conditions of the system will have a major effect on the time and must be taken into account (just an example for Cedric, my most-studied system: on a cold day, from a genuinely cold start, it will take about 10 minutes to reach running stable pressure (four ounces gauge), but on the same cold day, but when the system has running at capacity in the previous 15 minutes, it will take around one minute). The second half of that quote states "how long it will be off before it turns back on", which implies that the system will turn off — which simply isn't true of a well adjusted system. Such a system will operate at the running stable pressure indefinitely until the control device — usually a thermostat — is satisfied. On the other hand, on systems which are not so well adjusted and which cycle on pressure before the thermostat is satisfied, the time lapse between when the pressure control turns off the boiler and when it turns back on will be governed — or should be governed — by the characteristics of the pressure control device and the particular burner controls (Cedric again, which is not perfectly adjusted): in the situation where he does cycle off on pressure while the thermostat is still calling, which occurs at between 45 minutes and an hour into a cycle, depending on ambient factors, the pressure drops to "cutin" pressure (two ounces gauge) within 10 seconds, but the burner post purge/prepurge cycle controls and is one minute.
To follow the cycle point further a bit (sorry!), many if not most steam boilers have a constant firing rate. Thus the only way in which they can modulate to match the load (the radiation) is by cycling on and off. Provided that the "cutout" pressure is reasonable (no ore than twice the running pressure — Cedric again, 7 ounces gauge) the duty cycle is a direct result of the mismatch between the power output of the boiler and the power absorbing capacity of the system — and the latter is, as I noted above, variable, but if the both are known to some level of accuracy, the duty cycle may, of course, be calculated quite easily.
Br. Jamie, osb
Building superintendent/caretaker, 7200 sq. ft. historic house museum with dependencies in New England1 -
then there are large 2 pipe systems that are zoned, frequently by room, that use pressure to modulate or cycle the burner because they don't otherwise know what load is currently connected.
i kind of have this same sort of problem with heat loss calculations. you proably are only going to get within 20% or so.
even in electrical engineering you are usually within 20% or so, there are usually things you can't control or measure or other real world factors that mean you aren't calculating things to a couple percent.
1 -
@mattmia2 if I find that it is somewhat accurate after finishing the two pipe systems. I'll add in the one pipe. This was mostly born out of a desire to accurately calculate the EDR pickup in the building. And I figured as long as I was already calculating that and trying to add in piping that I already had a bunch of other information I could add in and see if it was going to be accurate.
Owner
Steamnowrockford.com
1 -
@Jamie Hall I definitely agree there are a lot of variables that need to be taken into account. I am working on a version which will take into account the mass of the cast iron of the boiler of the radiators and of the steel of the piping. This should help account for the specific heat required to heat up all of the metal in the system. And then this would account for the difference in time for the boiler to get to any set pressure because more Steam will be condensing when it is heating up the system. And once the system is heated up and the metal is already hot it will not take long comparatively to reach pressure again.
Owner
Steamnowrockford.com
1 -
Been doing more work. The system I'm modeling is a 4 floor building built in the early 1900s which has the original Kewanee, but currently runs on an LGB-12. It currently has a single Gorton 2 main vent. The return has a 1 inch nipple for venting. Based on the vent tables 5 Gorton 2's max out a 1inch vent capacity. This simple analysis looks at 2 variables: venting - using 1 vent(current setup) vs 5 vents; and startup temperature - one at 70F, one at 212F.
In this analysis the boiler is running the entire time simulated(60 minutes). The %load(% radiation the system is absorbing and radiating based on its total EDR) and the total summed Btu(the radiated heat that is being output to the building and the heat required to warm the cast iron and steel). So the higher the BTU ratings during this hour analysis is generally better, as more heat is being transferred, minus the warming heat.
Now, I always new that venting helps with heating, but I didn't realize how much. There is a near 50% decrease in first-hour radiation output if the system is poorly vented. Although this exact analysis is limited to this particular system.
Edit: I found an error with the supply line radiation plot, but it doesn't affect the findings. The step is smoothed to slopes though.
Owner
Steamnowrockford.com
1 -
are you accounting for the mass and specific heat of the piping?
0 -
Great analysis. I have always found this to be true as well. It is best practice to just get out of The Steam's Way! Mad Dog
1 -
@mattmia2 yep, you can see the beginning of each graph is flat and that is the time it takes the boiler to heat up the water and the cast iron which is specific to each different boiler model. And then it takes into account the steel for all of the piping and then the cast iron for the radiators.
Owner
Steamnowrockford.com
2 -
I believe the precise adjustment of boiler output is dependant on thermostat activity over time. Start up has to be longer to heat the system piping and radiators from cold to warm. Attaching a laptop to monitor behavior of systerm for a day or two allows for data collection which will indicate what software variable factor ranges can be adjusted for the particular building. Once set you forget it. This compensates for design inaccuracies, oversized boilers and state of insulation. Important of course is to assure that radiators or properly vented or trapped.
John Cockerill Exquisite Heat www.exqheat.com Precisions boiler control from indoor reset.0 -
Nice graphs. One does have to wonder a little, though — or maybe it's just me being a curmudgeon — how on earth we managed with just a good low pressure gauge and patience…
Br. Jamie, osb
Building superintendent/caretaker, 7200 sq. ft. historic house museum with dependencies in New England0 -
@Jamie Hall oh, NONE of this necessary. The hands on way is perfectly adequate(and more accurate) and that's what I use for actual work. This is something I'm doing to learn about the systems more. I also have a hope that I can come up with an estimate of efficiency loss from broken traps to help explain things to customers.
Owner
Steamnowrockford.com
0 -
I read you loud and clear. It seems that these days you really can't sell something without beautiful graphs and a computer calculation.
Br. Jamie, osb
Building superintendent/caretaker, 7200 sq. ft. historic house museum with dependencies in New England0 -
adjusting fire time hour to hour from thermostat activity will keep fuel use to a minimum.
John Cockerill Exquisite Heat www.exqheat.com Precisions boiler control from indoor reset.0 -
You helped me with this 25 years ago. Thank you
John Cockerill Exquisite Heat www.exqheat.com Precisions boiler control from indoor reset.0 -
-
-
Was I involved with this? Can't remember……………
Baltimore, MD, USA
Steam, Vapor & Hot-Water Heating Specialists
Oil & Gas Burner Service
Consulting0 -
I believe so. I had consulted you on how we could adopt our hydronic control to steam. We had discussed the difficulty of monitoring temperature at the boiler as a control data point. After our duscussion I discovered the applicability of establishing variable fire times to control steam for variation of heat loss in buildings. I hope it was you. As you probably know every control company has tried to get it right. They say they have it, but they don't. If I am wrong that it was you, my apologies.
John Cockerill Exquisite Heat www.exqheat.com Precisions boiler control from indoor reset.0 -
They say the memory is the second thing to go as we age- I've forgotten what the first one was…………..
Baltimore, MD, USA
Steam, Vapor & Hot-Water Heating Specialists
Oil & Gas Burner Service
Consulting2 -
Could be him! I'll mention this when I see him.
Baltimore, MD, USA
Steam, Vapor & Hot-Water Heating Specialists
Oil & Gas Burner Service
Consulting0 -
Ok, I've been doing work on adding failed steam traps into the calculations. So far the best way I've come up with to estimate how much steam loss you get is as follows:
I took the flow rate venting data from HH and used the orifice equation to back calculate the equivalent orifice diameter for each vent and trap. Then I used the standard isentropic orifice expansion equation to calculate the flow of steam through the traps modeled as orifices. I did not use the napier equation as it isn't applicable until you have a pressure of ~15psig in the boiler, and that shouldn't happen. From there I can calculate the amount of steam each failed trap is contributing to the return based on the pressure in the radiator and the model trap installed.
We know the BTU/Hr per ft for all pipe sizes from standard tables. Then we can take the size and length of the return and calculate how many BTU/HR the return will output at 212f. Now we have a maximum BTU/HR that the return can condense. Anything higher than what won't be able to condense and will leave through the vent.
While the results seem pretty reasonable using this method, it will require testing. In my example system, which is modeled on a real system I have regular access to, having 50% of the traps failed still doesn't release steam out of the system. The heat is retained in the building, it's just released in the wrong place. Now, if all of the traps are failed then the savings are still only 0.7% of the total boiler output. I'm not sure that's right. It seems low, but I've been told you can't promise heat savings from trap replacement. I would wager that the heat savings comes from getting the heat solely to the radiators and not heating the basement. Although at the point where all traps are failed you will be having other issues in the system as well.
Now, this is only for the radiator traps, no main traps, that I think would be a much larger issue. But the calculator has data on more than 180 traps and vents so that might be possible later.
Owner
Steamnowrockford.com
0
Categories
- All Categories
- 87.7K THE MAIN WALL
- 3.3K A-C, Heat Pumps & Refrigeration
- 59 Biomass
- 430 Carbon Monoxide Awareness
- 129 Chimneys & Flues
- 2.2K Domestic Hot Water
- 6K Gas Heating
- 122 Geothermal
- 170 Indoor-Air Quality
- 3.8K Oil Heating
- 79 Pipe Deterioration
- 1.1K Plumbing
- 6.6K Radiant Heating
- 396 Solar
- 16K Strictly Steam
- 3.5K Thermostats and Controls
- 56 Water Quality
- 51 Industry Classes
- 51 Job Opportunities
- 17 Recall Announcements






