Boiler Energy Efficiency Self-Assessment Tool
Introduction:
The Punjab Energy Efficiency and Conservation Authority (PEECA) of the Governnment of Punjab, Pakistan is working rigurously to improve energy
efficiency and promote a culture of Energy Conservation in the province. To aide the efforts, PEECA has developed excel based self-assessment
tools to calculate energy efficiency and enerrgy saving potentials in different industrial and commercial utilities.
About this tool:
This tool calculates Required and Actual Energy for steam production, Specific Fuel Consumption, Steam Cost and Overall Efficiency of Boilers.
Version Information:
Version No. V01_170304
Previous Version: N/A
How to Use?
- Enter data in the "Data Input" sheet. Please refer to "Example Data" sheet for guidance to fill the data.
- Blue tab sheets show results of calculations.
- Purple tab sheets show reference data used for calculations
- All Red labelled fields with white colored cells are data entry fields
- All blue labelled fields with Grey colored cells are Calculation and Output Fields.
- Please do not try to temper with any calculation cells as this will alter the results. Please contact PEECA or the developers for any alteration or
change requests.
References:
- Spirax Sarco Limited; http://www.spiraxsarco.com/pages/home.aspx
- Improving Steam Boiler Operating Efficiency , by Enercon.gov.pk
- Energy Technology Handbook, McGraw Hill, 9-46
- Saturated Steam Table by Pressure; http://www.tlv.com/global/TI/calculator/steam-table-pressure.html
- https://www.engineersedge.com/thermodynamics/steam_tables.htm
- Properties of Saturated Steam; http://www.engineeringtoolbox.com/saturated-steam-properties-d_457.html
- Water Thermal Properties; http://www.engineeringtoolbox.com/water-thermal-properties-d_162.html
- www.enggcyclopedia.com/2011/09/sample-problem-insulation-thickness-calculation-pipe/
- www.engineeringtoolbox.com/fiberglas-insulation-k-values-d_1172.html
- www.engineeringtoolbox.com/mineral-wool-insulation-k-values-d_815.html
- "INSULATION AND REFRACTORIES" by Bureau of Energy Efficiency India page 122-128, pdhonline.org/cources/m157/m157 content.pdf
- http://www.infrared-thermography.com/material.htm
- Estimating of cost steam lost through orifices(By Henry Manczyk, CPE, CEM); www.swagelokenergy.com/download/ECSLTOST.pdf
- Bureau of energy efficiency India
- Enorcon Pakistan
- APO Japan
- Excel add-in for Steam and Water Tables "Water97_v13.xla" by Bernhard Spang
Disclaimer:
The information, calculations and conclusions in this tool are based on the sources as mentioned above. The tool has been field tested, however,
qualified engineers must be consulted before makinng any decision based on these calculations. PEECA, Government of Punjab or the Developers
accept no liability whatsoever to any person, company or entity for any injury, loss or damage that may arise in connection with any misuse or
reliance on the information.
The tool is provided as a freeware. Users may make copies and distribute the tool without making any changes.
Contact:
Users may contact following for any clarification, suggestion and/or improvement in this tool;
Managing Director Developer
Punjab Energy Efficiency and Conservation Agency (PEECA) M. Salman Butt
Energy Department, Government of the Punjab ESPIRE Consult
[email protected] +92 305 555 2343
48-A, Block C-II, Ghalib Road, Gulberg-III, Lahore
[email protected]Pakistan 198 A-1, M. A. Jauhar Town, Lahore, Pakistan
Boiler Data Sheet
Average
Boiler Steam
Heating Production Specific Calculated Feed Water
Surface from Steam Steam Steam Enthalpy of Steam Annual Temperatur Enthalpy of Net Energy Fuel Price Annual Fuel Specific Fuel Hourly Fuel Total Energy Net Boiler
Boiler Code Area Flow Meter Pressure Temperature Steam Production Operation e Feed Water Required [PKR/ Consumption Consumption Consumption Cost Steam Fuel Cost Efficiency
# [Identity] [m²] [Ton/h] [bar] [⁰C] [kJ/kg] [Ton/y] [hrs/y] [⁰C] [kJ/kg] [mmBtu/y] Boiler Fuel mmbtu] [mmbtu/y] [mmbtu/Ton] [mmbtu/h] [MPKR/y] [PKR/Ton] [%]
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
0 0.00 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! #DIV/0! 0.00 #DIV/0! #DIV/0!
Boiler Efficiency Dashboard
Steam Production Specific Energy Consumption
No. of Boilers Total Steam Production Specific Fuel Consumption Hourly Fuel Consumption
0 0.00 #DIV/0! #DIV/0!
Ton/y Ton/y mmBtu/Ton mmBtu/h
Net Energy Requirement Annual Energy Input Total Energy Cost Steam Cost (Fuel only)
0.00 0.00 0.00 #DIV/0!
mmBtu/y mmBtu/y MPKR/y PKR/Ton
Efficiency Calculations
Max. Net Efficiency Min. Net Efficiency
0.0% 0.0%
% %
Overall Efficiency of Steam Boilers
#DIV/0!
%
EFFICIENCY OPTIMIZATION GUIDELINES
75.00% System is runnning well. Continuously monitor energy performance
70.00% Automate Boiler Controls, Improve Fuel Properties
65.00% Adjust Air:Fuel ratio, Check Insulations, Inspect Steam Traps and PRVs
60.00% Pre-Heat Air and/or Feed Water, Conduct Boiler Maintenance
55.00% Consult Expert; Boiler is Over Designed or Needs Replacement
Steam & Water Tables
Water Enthalpy Table Saturated Steam Enthalpy Table
Specific enthalpy of
Specific enthalpy of liquid
Temperature Pressure Pressure Saturated Steam as
water *
function of Pressure *
°C °K Bar kj/kg Bar psi kj/kg
0 273.15 1.01325 0.06 1 15 2674.95
1 274.15 1.01325 4.28 2 29 2706.24
2 275.15 1.01325 8.49 3 44 2724.89
3 276.15 1.01325 12.70 4 58 2738.06
4 277.15 1.01325 16.91 5 73 2748.11
5 278.15 1.01325 21.12 6 87 2756.14
6 279.15 1.01325 25.32 7 102 2762.75
7 280.15 1.01325 29.52 8 116 2768.30
8 281.15 1.01325 33.72 9 131 2773.04
9 282.15 1.01325 37.92 10 145 2777.12
10 283.15 1.01325 42.12 11 160 2780.67
11 284.15 1.01325 46.31 12 174 2783.77
12 285.15 1.01325 50.51 13 189 2786.49
13 286.15 1.01325 54.70 14 203 2788.89
14 287.15 1.01325 58.89 15 218 2791.01
15 288.15 1.01325 63.08 16 232 2792.88
16 289.15 1.01325 67.27 17 247 2794.53
17 290.15 1.01325 71.46 18 261 2795.99
18 291.15 1.01325 75.64 19 276 2797.26
19 292.15 1.01325 79.83 20 290 2798.38
20 293.15 1.01325 84.01 21 305 2799.36
21 294.15 1.01325 88.20 22 319 2800.20
22 295.15 1.01325 92.38 23 334 2800.92
23 296.15 1.01325 96.56 24 348 2801.54
24 297.15 1.01325 100.75 25 363 2802.04
25 298.15 1.01325 104.93 26 377 2802.45
26 299.15 1.01325 109.11 27 392 2802.78
27 300.15 1.01325 113.29 28 406 2803.02
28 301.15 1.01325 117.47 29 421 2803.18
29 302.15 1.01325 121.65 30 435 2803.26
30 303.15 1.01325 125.83 31 450 2803.28
31 304.15 1.01325 130.01 32 464 2803.24
32 305.15 1.01325 134.19 33 479 2803.13
33 306.15 1.01325 138.37 34 493 2802.96
34 307.15 1.01325 142.55 35 508 2802.74
35 308.15 1.01325 146.73 36 522 2802.47
36 309.15 1.01325 150.91 37 537 2802.15
37 310.15 1.01325 155.09 38 551 2801.78
38 311.15 1.01325 159.27 39 566 2801.36
39 312.15 1.01325 163.45 40 580 2800.90
40 313.15 1.01325 167.62 41 595 2800.39
41 314.15 1.01325 171.80 42 609 2799.85
42 315.15 1.01325 175.98 43 624 2799.27
43 316.15 1.01325 180.16 44 638 2798.65
44 317.15 1.01325 184.34 45 653 2798.00
45 318.15 1.01325 188.52 46 667 2797.31
46 319.15 1.01325 192.70 47 682 2796.59
47 320.15 1.01325 196.88 48 696 2795.83
48 321.15 1.01325 201.05 49 711 2795.04
49 322.15 1.01325 205.23 50 725 2794.23
50 323.15 1.01325 209.41 51 740 2793.38
51 324.15 1.01325 213.59 52 754 2792.51
52 325.15 1.01325 217.77 53 769 2791.60
53 326.15 1.01325 221.95 54 783 2790.67
54 327.15 1.01325 226.13 55 798 2789.72
55 328.15 1.01325 230.31 56 812 2788.74
56 329.15 1.01325 234.49 57 827 2787.73
57 330.15 1.01325 238.68 58 841 2786.70
58 331.15 1.01325 242.86 59 856 2785.64
59 332.15 1.01325 247.04 60 870 2784.56
60 333.15 1.01325 251.22 61 885 2783.46
61 334.15 1.01325 255.41 62 899 2782.33
62 335.15 1.01325 259.59 63 914 2781.19
63 336.15 1.01325 263.77 64 928 2780.02
64 337.15 1.01325 267.96 65 943 2778.83
65 338.15 1.01325 272.14 66 957 2777.62
66 339.15 1.01325 276.33 67 972 2776.39
67 340.15 1.01325 280.51 68 986 2775.13
68 341.15 1.01325 284.70 69 1001 2773.86
69 342.15 1.01325 288.89 70 1015 2772.57
70 343.15 1.01325 293.08 71 1030 2771.26
71 344.15 1.01325 297.26 72 1044 2769.93
72 345.15 1.01325 301.45 73 1059 2768.58
73 346.15 1.01325 305.64 74 1073 2767.21
74 347.15 1.01325 309.83 75 1088 2765.82
75 348.15 1.01325 314.02 76 1102 2764.41
76 349.15 1.01325 318.22 77 1117 2762.99
77 350.15 1.01325 322.41 78 1131 2761.55
78 351.15 1.01325 326.60 79 1146 2760.09
79 352.15 1.01325 330.80 80 1160 2758.61
80 353.15 1.01325 334.99 81 1175 2757.12
81 354.15 1.01325 339.19 82 1189 2755.60
82 355.15 1.01325 343.38 83 1204 2754.07
83 356.15 1.01325 347.58 84 1218 2752.52
84 357.15 1.01325 351.78 85 1233 2750.96
85 358.15 1.01325 355.98 86 1247 2749.38
86 359.15 1.01325 360.18 87 1262 2747.78
87 360.15 1.01325 364.38 88 1276 2746.16
88 361.15 1.01325 368.58 89 1291 2744.53
89 362.15 1.01325 372.79 90 1305 2742.88
90 363.15 1.01325 376.99 91 1320 2741.22
91 364.15 1.01325 381.20 92 1334 2739.53
92 365.15 1.01325 385.40 93 1349 2737.83
93 366.15 1.01325 389.61 94 1363 2736.12
94 367.15 1.01325 393.82 95 1378 2734.38
95 368.15 1.01325 398.03 96 1392 2732.64
96 369.15 1.01325 402.24 97 1407 2730.87
97 370.15 1.01325 406.45 98 1421 2729.09
98 371.15 1.01325 410.67 99 1436 2727.29
99 372.15 1.01325 414.88 100 1450 2725.47
100 373.15 1.01325 2675.58 101 1465 2723.64
* Enthalpy is calculated using Excel add-in for Steam and Water Tables "Water97_v13.xla" by Bernhard Spang
Example Boiler Data Sheet
Average
Boiler Steam
Heating Production Specific Calculated Feed Water
Surface from Steam Steam Steam Enthalpy of Steam Annual Temperatur Enthalpy of Net Energy Fuel Price Annual Fuel Specific Fuel Hourly Fuel Total Energy Net Boiler
Boiler Code Area Flow Meter Pressure Temperature Steam Production Operation e Feed Water Required [PKR/ Consumption Consumption Consumption Cost Steam Fuel Cost Efficiency
# [Identity] [m²] [Ton/h] [bar] [⁰C] [kJ/kg] [Ton/y] [hrs/y] [⁰C] [kJ/kg] [mmBtu/y] Boiler Fuel mmbtu] [mmbtu/y] [mmbtu/Ton] [mmbtu/h] [MPKR/y] [PKR/Ton] [%]
1 Boiler_001_ABC 3.00 7.00 170 2,762.75 7,959.00 2653 35 146.73 19,719.18 Natural Gas 600 26483.00 3.33 9.98 15.89 1,996.46 74.5%
2 Boiler_002_ABC 600 7.50 7.00 175 2,762.75 11,250.00 1500 35 146.73 27,872.94 HFO 900 35000.00 3.11 23.33 31.50 2,800.00 79.6%
2 10.50 19209.00 2076.5 47592.12 750 61483.00 3.22 16.66 47.39 2467.06 77.0%
