{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["HOME","1| Checklist Compressed Air","2| Equipment data","3| Compressor Energy Cost","4| Pressure Reduction","5| Leakage Calculation-Offline","6| Leakage Calculation-Orifice","7| High Efficiency Motor","8| Multi-stage compressor","9| Variable Speed Drive","10| Waste Heat","Tabelle3","Calor Val","dropdown"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":12,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HOME","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[16,1,16,2],[16,3,16,5],[12,1,12,5],[11,1,11,5],[3,1,3,5],[5,1,5,5],[7,1,7,5],[8,1,8,5],[15,1,15,2],[15,3,15,5],[2,1,2,5],[6,1,6,5],[0,1,0,5],[13,1,13,5],[14,1,14,5],[9,1,9,5],[10,1,10,5]]}
[null,"ENERGY EFFICIENCY TOOLS FOR COMPRESSED AIR SYSTEMS"]
[null,"VER_01/150826"]
[null,"INTRODUCTION: This workbook consists of multiple tools that conduct Assessment of Compressed Air System, calculate Energy Performance of Compressors, and calculate Energy Saving Potentials in Compressed Air System"]
[]
[]
[null,"HOW TO USE:"]
[null,"1. Insert data from your company in cells that are highlighted in white.\n2. Results of calculations will be displayed in Orange Cells.\n3. Examples of Data and Calculation are shown in each tool."]
[null,"SOURCES:"]
[null,"1. Compressed Air Best Practice Tool; Sustainable Energy Authority of Ireland (seai)\n2. Recuperable heat from compressors, Energy Agency NRW\n3. Compressed Air Systems in the European Union, EU 2001\n4. International Energy Agency (IEA)\n5. Energy Markets International Limited\n6. ISO 11011 Compressed air – Energy Efficiency – Assessment\n7. Energy Efficiency Guide for Industry in Asia – www.energyefficiencyasia.org\n8. US Department of Energy  – www.eere.energy.gov/industry\n9. Air compressor Works Inc. [http://www.aircompressorworks.com/airflowthroughorifices.html]\n10. EU Study compresse air system\n"]
[null,"WHO WE ARE:"]
[null,"ESPIRE is a partnership project between the Training and Development Centers of the Bavarian Employers‘ Association (bfz) gGmbH and business associations in Lahore and Karachi in Pakistan. \n\nThe objective of ESPIRE project is to support industries in Pakistan to work economically more efficiently and ecologically more sustainable and start making energy conservation and cleaner production part of their work routine. \n\nMain project partners are; Pakistan Association of Automotive Parts and Accessories Manufacturers (PAAPAM), Pakistan Hosiery Manufacturers Association (PHMA), Pakistan Readymade Garments Manufacturers and Exporters Association (PRGMEA), Small and Medium Enterprises Development Authority (SMEDA), Towel Manufacturers Association of Pakistan (TMA).\n\nThe Project is funded by the German Federal Ministry for Economic Cooperation and Development (BMZ) via Sequa gGmbH."]
[null,"DISCLAIMER:"]
[null,"The information, calculations and conclusions in this tool are based on the projects executed by the experts and consultant under Project ESPIRE by bfz gGmbH – International Division. Some sources (as mentioned above) were also consulted to validate the contents. The efficiency improvement measures proposed in this tool are tested and tried in many companies in Pakistan. However, implementation of these measures in any particular case should be based on real time data analysis by qualified engineers after judging financial viability. Bfz gGmbH – International Division and it's Project Partners in Pakistan accepts 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.\n\nThe tool is provided as a freeware. Users may make copies and distribute the tool without making any changes."]
[null,"CONTACT:"]
[null,"Users may contact following for any clarification, suggestion and/or improvement in this tool;"]
[null,"Muhammad Salman Butt\nProject Manager, Project ESPIRE\nbfz gGmbH International Division\n0092 300 4322343\nmsalmanbutt@hotmail.com",null,"Muhammad Farooq\nCEO\nEnergy Saving Solutions, Lahore\n0092 321 2117115\nfarooq.ess@gmail.com"]

{"sheet":"1| Checklist Compressed Air","index":1,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,1,1,3],[55,2,55,3],[57,1,57,3],[2,1,2,3],[49,1,49,3],[50,1,50,3],[52,1,52,3],[53,2,53,3],[54,2,54,3]]}
[]
[null,"CHECKLIST FOR COMPRESSED AIR SYSTEM"]
[null,"ISSUE:  Companies find it difficult to draw a baseline of performance of Compressed Air System. \n\nWHAT WE DO HERE:  Conduct Self-assessment of compressed air system by rating the performance against each energy saving option in \"RATING\" column."]
[null,null,"ENERGY SAVING OPTIONS"]
[null,"LEVEL","PRODUCTION","RATING"]
[null,"-","Ensure compressors are only switched on if there is a demand for compressed air.","»"]
[null,"-","Match system’s air pressures with the lowest pressure practical for the application.","»"]
[null,"-","Provide cool inlet air (ventilation and compressed) to the compressors [4 degree Celsius rise in inlet air temperature increases the energy consumption by 1%].","»"]
[null,"-","Optimize the pressure stages of compressors considering the base load and peak load requirements.","»"]
[null,"-","Ensure proper operation of dryers and filters.","»"]
[null,"-","Ensure proper operation of low-flow blow down nozzles on compressed air systems.","»"]
[null,"- -","Investigate the use of a VSD/VFD based compressor.","»"]
[null,"- -","Design the header size to maintain air velocity below 6 m/sec and a maximum pressure drop of 2 psi in the compressor room.","»"]
[null,"- -","Check potential sequencing of compressors to operate most efficient compressors for total system air requirement.","»"]
[null,"- - -","Install a High Efficiency Motor on the compressor.","»"]
[null,"- - -","Recover waste heat from compressors to use for other heating operations.","»"]
[null,"- - -","Replace reciprocating compressors with high efficiency centrifugal compressors.","»"]
[null,null,"NETWORK","RATING"]
[null,"-","Avoid unnecessary bends and valves.","»"]
[null,"-","Keep the piping network rust-free by regularly maintaining moisture filters and condensate traps.","»"]
[null,"-","Install all branch pipes up-wards to avoid Moisture Accumulation.","»"]
[null,"-","Use leak-loss free condensate traps.","»"]
[null,"- -","Use closed loop piping network [reduces pressure Drop by 75%].","»"]
[null,"- -","Install pipe sizes appropriate to the flow and pressure requirements [Increasing pipe diameter from 1 ½” to 2” reduces Pressure Drop by 75%].","»"]
[null,"- -","Divide network in areas/sections to facilitate measurement, maintenance and shut off when not in use.","»"]
[null,"- -","Optimize air storage (location near equipment with high variation, size big enough to avoid regular frequent on/off).","»"]
[null,"- -","Design the piping to maintain air velocity below 9 m/sec and a maximum pressure drop of 3 psi to the farthest point of use.","»"]
[null,"- -","Install local compressor for High Pressure Demand equipment as a pressure booster [System pressure can thus be reduced to match base pressure requirements].","»"]
[null,"- - -","Reduce the length of the network to avoid pressure drops at far points.","»"]
[null,"- - -","Install all compressed air pipes with a fall of 1% [1:100] in direction of air flow.","»"]
[null,null,"USE","RATING"]
[null,"-","Eliminate wasteful practices, leaks, artificial demand and inappropriate use [e.g. for cleaning the floor].","»"]
[null,"-","Install pressure regulators at low-pressure requirement points.","»"]
[null,"-","Verify pressure requirements of end-use applications from their operations manuals.","»"]
[null,"- -","Segregate low & high pressure air requirements.","»"]
[null,"- -","Use blower air instead of compressed air (aeration in effluent treatment plants, drying applications, etc) [Saving potential is about 30%; blowers are available for pressures up to 1 bar in single stage and up to 2.2 bar in two stage design].","»"]
[null,"- -","Replace Pneumatic tools with hydraulic tools [Energy saving potential is about 30%].","»"]
[null,"- -","Replace pneumatic tools with electrical tools [Energy saving potential is about 50%].","»"]
[null,"- -","Replace pneumatic conveying by mechanical conveying [Energy Saving potential is about 30%]","»"]
[null,null,"CONTROL","RATING"]
[null,"- -","Install measurement equipment (flow meters, air meters, current meters, pressure gauges). ","»"]
[null,"- -","Assess performance of critical air demands and existing poor-performing end-use applications.","»"]
[null,"- -","Create and maintain an energy balance between supply and demand.","»"]
[null,"- -","Evaluate the system pressure profile and identify opportunities to eliminate pressure loss.","»"]
[null,"- -","Monitor and Calculate specific energy consumption (e.g. 7 kWh/m³/min by a loading factor of 80%).","»"]
[null,null,"MAINTENANCE","RATING"]
[null,"-","Regularly inspect and clean air inlet filters.","»"]
[null,"-","Regularly check the joints, valves, filters and connectors for leakages and eliminate all leakages immediately.","»"]
[]
[null,"NOTE:"]
[null,"This tool includes calculation of savings for measures highlighted in blue font."]
[]
[null,"LEVEL OF DIFFICULTY:"]
[null,"-","No/Low Cost or Short Term Investment [Pay-back period < 6 months]"]
[null,"- -","Medium Term Investment  [Pay-back period < 18 months]"]
[null,"- - -","Long Term Investment or Needs Feasibility Study  [Pay-back period > 18 months]"]
[]
[null,"RATING OF IMPLEMENTATION STATUS:"]
[null,null,"Energy Saving Option has not been considered yet.",1]
[null,null,"Energy Saving Option is in the planning stage but not yet realized.",2]
[null,null,"Energy Saving Option is partially (not in all areas/ machines or not all the time) implemented/ realized. ",3]
[null,null,"Energy Saving Option has been mostly implemented/ realized.",4]
[null,null,"Energy Saving Option is fully realized. ",5]
[null,null,null,"»"]

{"sheet":"2| Equipment data","index":2,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,6],[25,1,25,8],[27,1,27,8],[28,1,28,8]]}
[]
[null,"EQUIPMENT DATA"]
[null,"  EQUIPMENT (Motor, Fan, Dryer)","  ID # EQUIPMENT","  MOTOR POWER [kW]","  MOTOR EFFICIENCY [%]","MP*ME","  MOTOR LOAD [%]","MP*ML","  OPERATION HOURS [h/y]"]
[null,"  Name of Equipment","  give unique ID","  Motor Rating","  Given in data sheet,   \n  measured or estimated",null," Measured or estimated",null,"  Measured or estimated based\n  on company operation hours"]
[null,"Example: Compressor 1","C100",200,0.92,null,0.65,null,6240]
[]
[]
[]
[null,null,null,null,null,{"$f":"D9*E9","v":0},null,{"$f":"D9*G9","v":0}]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,{"$f":"D21*E21","v":0},null,{"$f":"D21*G21","v":0}]
[null,null,null,null,null,{"$f":"D22*E22","v":0},null,{"$f":"D22*G22","v":0}]
[null,"RESULTS","# of Equipment","Sum Motor Power","Weighted average\nmotor efficiency",null,"Weighted average\nmotor load",null,"Average motor operation hours"]
[null,null,{"$f":"COUNT(D6:D22)","v":0},{"$f":"SUM(D6:D22)","v":0},{"$f":"SUM(F6:F22)/D24","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H6:H22)/D24","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(I6:I22)","v":{"$error":"#DIV/0!"}}]
[]
[null,"NOTE: Let the last two lines always empty. If you need more lines, you can copy the last two lines, then select the next-to-last line and add on right click \"Insert Copied Cells\" field. Do not just insert rows, as there are hidden cells with formulas that won't be copied!"]
[]
[null,"HOW TO USE:"]
[null,"1. Insert data for single equipment/motors from your company in cells \n2. Data for Motor Efficiency, % Full Load and Annual Operation Hours can be compiled in table \"INPUT VALUES Pressure\""]

{"sheet":"3| Compressor Energy Cost","index":3,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,7],[29,1,29,7],[30,1,30,7],[12,7,13,7],[14,7,15,7],[16,7,17,7],[18,7,19,7],[20,7,21,7],[22,7,23,7]]}
[]
[null,"COMPRESSED AIR ENERGY COST CALCULATION"]
[null,"ISSUE: Compressed air is the most expensive form of energy, one should know that how much energy consumed by the compressor. It adds to manufacturing cost of products. \n\nWHAT WE DO HERE: Calculate compressed air cost, if one would know the cost then will think to avoid its wastage."]
[null,null,"Example",null,"ON Load Power"]
[null,null,160,null,null,"[kW]",">","Motor Power consumption when it is running ON Load"]
[null,null,null,null,"OFF Load Power"]
[null,null,40,null,null,"[kW]",">","Motor Power consumption when it is running OFF Load"]
[null,null,null,null,"ON load Runing hours per year"]
[null,null,4056,null,null,"[h/y]",">","Total time(hrs) when compessor is ON Load /year"]
[null,null,null,null,"OFF load Runing hours per year"]
[null,null,2184,null,null,"[h/y]",">","Total time(hrs) when compessor is OFF Load /year"]
[null,null,null,null,"Price of electrical Energy Unit "]
[null,null,18,null,null,"[Rs/kWh]",">","Average price of electricity from different means: e.g power company(WAPDA), Generatos,\npower plants etc"]
[null,null,null,null," Average ON Load running "]
[null,null,{"$f":"C9/(C9+C11)","v":0.65},null,{"$f":"E9/(E9+E11)","v":{"$error":"#DIV/0!"}},"[%]",">","ON load Runing hours per year [h/y] / (ON load Runing hours per year [h/y] + OFF load Runing hours per year [h/y])"]
[null,null,null,null,"Motor Efficiency"]
[null,null,0.92,null,null,"[%]",">","Different motors have different efficiancies varies from company to company, availiable on motor name plat data/brochure"]
[null,null,null,null,"Maximum Demand Indicator (MDI) Price"]
[null,null,400,null,null,"[Rs/kW]",">","Maximum demand index are fix charges charged by power company (e.g WAPDA) for your\nelectric sanction load and compresors have major share in MDI"]
[null,null,null,null,"ON Load Energy  cost"]
[null,null,{"$f":"C5*C9*C13/C17","v":12697043.478260869},null,{"$f":"E5*E9*E13/E17","v":{"$error":"#DIV/0!"}},"[Rs/y]",">","ON Load Power [kW] x ON Load Running hours per year [h/y] x Price of electrical energy unit [Rs/kWh] / Motor Effeiciency at ON load [%]"]
[null,null,null,null,"OFF Load Energy  cost"]
[null,null,{"$f":"C7*C11*C13/C17","v":1709217.3913043477},null,{"$f":"E7*E11*E13/E17","v":{"$error":"#DIV/0!"}},"[Rs/y]",">","OFF Load Power [kW] x OFF Load Running hours per year [h/y] x Price of electrical energy unit [Rs/kWh] / Motor Effeiciency at OFF load [%]"]
[null,null,null,null,"Demand Cost"]
[null,null,{"$f":"C7*C19*12","v":192000},null,{"$f":"E7*E19*12","v":0},"[Rs/y]",">","Maximum demand index Rate [Rs/kW] x OFF Load Power [kW] x 12"]
[null,null,null,null,"Total Annual Energy Cost"]
[null,null,{"$f":"C21+C23+C25","v":14598260.869565217},null,{"$f":"E21+E23+E25","v":{"$error":"#DIV/0!"}},"[Rs/y]",">","ON Load Energy cost [Rs]+ OFF energy cost [Rs/y]+ Demand Cost [Rs/y]"]
[]
[]
[null,"HOW TO USE:"]
[null,"1. Insert data from your company in cells that are highlighted in white \n"]

{"sheet":"4| Pressure Reduction","index":4,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,1,28,7],[1,1,1,7],[2,1,2,7],[25,1,25,7],[26,1,26,7],[27,1,27,7]]}
[]
[null,"ENERGY SAVING THROUGH PRESSURE REDUCTION"]
[null,"ISSUE: Energy is wasted if pressure is set higher than needed. The discharge pressure set point range should be set to the minimum level needed for process air requirements. \n\nWHAT WE DO HERE: Calculat the energy savings achievable by reducing the discharge pressure."]
[null,null,"Example",null,"Motor Power"]
[null,null,160,null,{"$f":"'2| Equipment data'!D24","v":0},"[kW]",">","Sum of all compressors, cooling fans and dryer motor ratings. Data automatically retreived from \"2| Equipment data\""]
[null,null,null,null,"Motor Efficiency"]
[null,null,{"$f":"'2| Equipment data'!E5","v":0.92},null,{"$f":"'2| Equipment data'!E24","v":{"$error":"#DIV/0!"}},"[%]",">","Weighted average combined motor efficiency (default = 90%). Data automatically retreived from \"2| Equipment data\""]
[null,null,null,null,"% Full Load"]
[null,null,{"$f":"'2| Equipment data'!G5","v":0.65},null,{"$f":"'2| Equipment data'!G24","v":{"$error":"#DIV/0!"}},"[%]",">","Estimate of average percentage motor load factor (default = 65%). Data automatically retreived from \"2| Equipment data\""]
[null,null,null,null,"Annual Operation Hours"]
[null,null,{"$f":"'2| Equipment data'!I5","v":6240},null,{"$f":"'2| Equipment data'!I24","v":{"$error":"#DIV/0!"}},"[h/y]",">","Data automatically retreived from \"2| Equipment data\""]
[null,null,null,null,"Pressure Reduction"]
[null,null,1,null,null,"[bar]",">","Average reduction in discharge pressure set-point"]
[null,null,null,null,"Annual Energy Consumption"]
[null,null,{"$f":"(C5/C7)*C9*C11","v":705391.30434782617},null,{"$f":"(E5/E7)*E9*E11","v":{"$error":"#DIV/0!"}},"[kWh/y]",">","= (Motor Power [kW]/ Motor Efficiency [%]) x (Full Load [%]) x (Operation Hours [h/y])"]
[null,null,null,null,"% Savings"]
[null,null,{"$f":"C13*0.065","v":6.5000000000000002E-2},null,{"$f":"E13*0.065","v":0},"[%]",">","= (Pressure Reduction [bar]) x (6-7% savings per bar)"]
[null,null,null,null,"Annual Energy Savings"]
[null,null,{"$f":"C15*C17","v":45850.434782608703},null,{"$f":"E15*E17","v":{"$error":"#DIV/0!"}},"[kWh/y]",">","= (Annual Energy Consumption [kWh]) x (Savings [%])"]
[null,null,null,null,"Average Electricity Price"]
[null,null,18,null,null,"[Rs/kWh]",">","Insert from Energy Bills"]
[null,null,null,null,"Annual Cost Savings"]
[null,null,{"$f":"C19*C21","v":825307.82608695666},null,{"$f":"E19*E21","v":{"$error":"#DIV/0!"}},"[Rs/y]",">","= (Annual Energy Savings [kWh/y] x (Average Electricity Price [$/kWh])"]
[]
[]
[null,"HOW TO USE:"]
[null,"1. Insert data from your company in cells that are highlighted in white \n2. Data for Motor Efficiency, % Full Load and Annual Operation Hours can be compiled in table \"INPUT VALUES Pressure\" and are automatically shown as input values in this table"]
[null,"ADDITIONAL INFORMATION & TIPS"]
[null,"1. Rule of Thumb: Every 1 bar pressure reduction results in 6-7% energy saving. If analysis of your equipment provide you with more accurate values for savings the formula for \"% Savings\" may be changed accordingly. \n2.  Payback depends on number of problems in the system and requirement of addtional controls (if any). Payback < 1 year possible\n3. Implementation should be done carefully: Discharge pressure should be reduced in small steps (e.g. 0,25 bar) and performance of critical end users should be monitored carefully. \n4. Reduce pressure until a probel arises at one consumer. Check if the problem can be fixed at the consumer site and continue. When all problems are located and repaired, raise the pressure range up by  a small amount (e.g. 0,15 bar) and stop process at new optimum setting. \n5. Please, be aware that a problem at end users do not only include problems of operation, but also longer processing time, e.g. as pneumatic screw driver operates slower with lower pressure. \n6. If only one or two specific end users dictate the pressure of the entire system, it is often more economic to replace or modigy this component rather than operate the whole system with higher pressure. It might be a solution to seperate the consumer from the compressed air system and to operate just this user with one compressor at a higher pressure level while rest of the system operatew with lower pressure. "]

{"sheet":"5| Leakage Calculation-Offline","index":5,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,1,2,7],[23,1,23,7],[24,1,24,7],[7,7,8,7],[13,7,14,7]]}
[]
[null,"LEAKAGE COST CALCULATION - OFFLINE METHOD"]
[null,"ISSUE: Compressed air is the most expensive form of energy, In industry this expensive energy is wasted due to Leakages in the air distribution system and also in machines/equipments. \n\nWHAT WE DO HERE: Calculate compressed air leakage cost,Leakage test can be when Plant is OFF. Take appropriate remedies to control air leakages."]
[null,null,"Example",null,"On Load Power consumption of compressor"]
[null,null,160,null,null,"[kW]",">","Compressor Motor power consumption when it's running On Load"]
[null,null,null,null,"Annual operation hours"]
[null,null,6240,null,null,"[h/y]",">","Compressor run time x working days per month x 12"]
[null,null,null,null,"ON Load Time ",null,null,"When plant is OFF, No machine/equipment is using air, Fill the reservior ensuring no branch/link is disconnected. Run only one compressor and note Compressor On load time, take 3-4 readings and average out it. "]
[null,null,32,null,null,"[sec]",">"]
[null,null,null,null,"OFF Load Time"]
[null,null,18,null,null,"[sec]",">","When plant is OFF, No machine/equipment is using air, Fill the reservior first after that note Compressor OFF load time, take 3-4 readings and average out it. "]
[null,null,null,null,"On Load time per hour"]
[null,null,{"$f":"C9/(C9+C11)*60","v":38.4},null,{"$f":"E9/(E9+E11)*60","v":{"$error":"#DIV/0!"}},"[min]",">","On load time/(On load time+Off load Time) x 60"]
[null,null,null,null,"Leakage Allowance",null,null,"Ideally, leakage allowance should be Zero (0%).\nHowever, 5-10% leakage is observed in well maintained systems"]
[null,null,0.05,null,null,"[%]",">"]
[null,null,null,null,"Price of electrical Energy Unit "]
[null,null,18,null,null,"[Rs/kWh]",">","Average price of electricity from different means: e.g power company(WAPDA), Generatos, power plants etc."]
[null,null,null,null,"Leakage Cost per hour"]
[null,null,{"$f":"C5*C17*C13*(1-C15)/60","v":1751.04},null,{"$f":"E5*E17*E13*(1-E15)/60","v":{"$error":"#DIV/0!"}},"Rs/h",">","On load power consumption x Price of Elecricity unit x On load time per hour ÷ 60"]
[null,null,null,null,"Leakage Cost per hour"]
[null,null,{"$f":"C19*C7","v":10926489.6},null,{"$f":"E19*E7","v":{"$error":"#DIV/0!"}},"Rs/y",">","Annual operation hours x leakage cost per hour"]
[]
[]
[null,"HOW TO USE:"]
[null,"1. Insert data from your company in cells that are highlighted in white \n2. Data for Motor Power, Motor Efficiency, and Annual Operation Hours can be compiled in table \"Equipment Data\" once and inserted from this source.  "]

{"sheet":"6| Leakage Calculation-Orifice","index":6,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,1,27,7],[28,1,28,7],[2,1,2,7],[2,9,2,26],[3,9,3,26],[6,9,6,10],[4,9,5,9]]}
[]
[null,"LEAKAGE COST CALCULATION - THROUGH ORIFICE SIZE"]
[null,"ISSUE: Compressed air is the most expensive form of energy, In industry this expensive energy is wasted due to Leakages in the air distribution system and also in machines/equipments.\n\nWHAT WE DO HERE: Calculate compressed air leakage cost through orifice when you can not shut down Plant.",null,null,null,null,null,null,null,"AIR FLOW THROUGH ORIFICES   "]
[null,null,"Example",null,"Compressor Free air delivery",null,null,null,null,"Volume of free air in cubic feet of air per minute (CFM) that will flow through round holes from a receiver into the atmosphere.  CFM is measured at absolute pressure of 14.7psi and 70¼ F."]
[null,null,900,null,null,"[cfm]",">","Enter Actual discharge rate from flow meter or enter rated capacity of discharge ,from compressor name plate data",null,"Pressure","[psi]",15,20,25,30,35,40,45,50,60,70,80,90,100,125,150,200]
[null,null,null,null,"On Load Power consumption of compressor",null,null,null,null,null,"[bar]",{"$f":"L5*0.0689475729","v":1.0342135935000001},1.378951458,1.7236893225000001,2.0684271870000002,2.4131650515,2.7579029159999999,3.1026407805000003,3.4473786450000001,4.1368543740000003,4.8263301030000001,5.5158058319999999,6.2052815610000005,6.8947572900000003,8.6184466124999997,10.342135935,{"$f":"AA5*0.0689475729","v":13.789514580000001}]
[null,null,160,null,null,"[kW]",">","Compressor motor rating,from compressor name plate data",null,"Dia of orifice",null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,"Price of electrical Energy Unit ",null,null,null,null,"[inch]","[mm]"]
[null,null,18,null,null,"[Rs/KWh]",">","Average price of electricity from different means: e.g power company(WAPDA), Generatos, power plants etc",null,1.5625E-2,{"$f":"CONVERT(J9,\"in\",\"mm\")","v":0.39687499999999998},0.105,0.123,0.14000000000000001,0.158,0.17599999999999999,0.19400000000000001,0.21099999999999999,0.28999999999999998,0.26700000000000002,0.3,0.33500000000000002,0.37,0.40600000000000003,0.49399999999999999,0.58299999999999996,0.75]
[null,null,null,null,"Cost of compressed air  produced",null,null,null,null,3.125E-2,{"$f":"CONVERT(J10,\"in\",\"mm\")","v":0.79374999999999996},0.42,0.49099999999999999,0.56200000000000006,0.63300000000000001,0.70299999999999996,0.77400000000000002,0.84499999999999997,0.91600000000000004,1.06,1.2,1.34,1.48,1.62,1.98,2.3199999999999998,3.18]
[null,null,{"$f":"C7*C9/(C5*60)","v":5.3333333333333337E-2},null,{"$f":"E7*E9/(E5*60)","v":{"$error":"#DIV/0!"}},"[Rs/ftᶟ]",">","Full Load Power Consumption /Compressor Free Air Delivery * Price of Electrical Energy unit",null,4.6875E-2,{"$f":"CONVERT(J11,\"in\",\"mm\")","v":1.190625},0.94399999999999995,1.1000000000000001,1.26,1.42,1.58,1.75,1.91,2.06,2.38,2.7,3,3.33,3.66,4.4400000000000004,5.25,6.86]
[null,null,null,null,"Line pressure",null,null,null,null,6.25E-2,1.5874999999999999,1.68,1.96,2.25,2.5299999999999998,2.81,3.1,3.38,3.66,4.2300000000000004,4.79,5.36,5.92,6.49,7.9,9.1,12.17]
[null,null,30,null,null,"[psi]",">","Pressure in line where leakage available. Select appropriate unit from drop-down. Unit of example data is [psi].",null,9.375E-2,2.3812500000000001,3.78,4.41,5.05,5.69,6.31,7,7.63,8.25,9.5,10.8,12,13.3,14.6,17.8,20.9,27.35]
[null,null,null,null,"Orifice dia",null,null,null,null,0.125,3.1749999999999998,6.72,7.86,8.98,10.1,11.3,12.4,13.5,14.7,16.899999999999999,19.2,21.4,23.7,26,31.6,37.299999999999997,48.7]
[null,null,0.125,null,null,"[In]",">","Select Approximate diameter of One orifice in inches from drop-down in the cell",null,0.1875,4.7625000000000002,15.2,17.649999999999999,20.2,22.8,25.2,28,30.5,33,38,43.2,48.3,53.2,58.5,71,84,109.6]
[null,null,null,null,"Orifice type",null,null,null,null,0.25,6.35,26.9,31.4,35.9,40.5,45,49.6,54.1,58.6,67.599999999999994,76.7,85.7,94.8,104,126,149.30000000000001,195]
[null,null,"Sharp Edged",null,null,"[In]",">","Select type of orifice from drop-down in the cell",null,0.375,9.5250000000000004,60.5,70.7,80.900000000000006,91.1,101,112,122,132,152,173,193,213,234,284,336,438]
[null,null,null,null,"Leakage through one orifice",null,null,null,null,0.5,12.7,108,126,144,162,180,198,216,235,271,307,343,379,415,506,596,777]
[null,null,{"$f":"IF(C17=\"Sharp Edged\", 0.65*(VLOOKUP(C15,J9:AA28,(IF(F13=\"[psi]\", HLOOKUP(C13,L5:AA7,3,TRUE),HLOOKUP(C13,L6:AA7,2,TRUE))),FALSE)), 0.97*(VLOOKUP(C15,J9:AA28,(IF(F13=\"[psi]\", HLOOKUP(C13,L5:AA7,3,TRUE),HLOOKUP(C13,L6:AA7,2,TRUE))),FALSE)))","v":6.5650000000000004},null,{"$f":"IF(E17=\"Sharp Edged\", 0.65*(VLOOKUP(E15,J9:AA28,(IF(F13=\"[psi]\", HLOOKUP(E13,L5:AA7,3,TRUE),HLOOKUP(E13,L6:AA7,2,TRUE))),FALSE)), 0.97*(VLOOKUP(E15,J9:AA28,(IF(F13=\"[psi]\", HLOOKUP(E13,L5:AA7,3,TRUE),HLOOKUP(E13,L6:AA7,2,TRUE))),FALSE)))","v":{"$error":"#N/A"}},"[cfm]",">","Automatically retrieved from table\"AIR FLOW THROUGH ORIFICES\". Multiplied by flow factor 0.97 for Well Rounded and 0.65 for Sharp Edged orifices",null,0.625,15.875,168,196,225,253,281,310,338,366,423,479,536,592,649,790,932,1216]
[null,null,null,null,"Energy cost due to leakages per hour",null,null,null,null,0.75,19.05,242,283,323,365,405,446,487,528,609,690,771,853,934,1138,1340,1750]
[null,null,{"$f":"C11*C19*60","v":21.008000000000003},null,{"$f":"E11*E19*60","v":{"$error":"#DIV/0!"}},"[Rs/h]",">","Cost of Compressed air produced x Leakage through orifice",null,0.875,22.225000000000001,329,385,440,496,551,607,662,718,828,939,1050,1161,1272,1549,1825,2382]
[null,null,null,null,"Annual operation hours",null,null,null,null,1,25.4,430,503,575,648,720,793,865,938,1082,1227,1371,1516,1661,2023,2385,3112]
[null,null,6240,null,null,"[h/y]",">","24h/7d =8,760 hours; 24h/5d =6,240 hours; h/5d = 2,080 hours",null,{"$f":"1+1/8","v":1.125},28.574999999999999,544,637,727,820,910,1004,1094,1187,1370,1552,1734,1918,2101,2560,3020,3940]
[null,null,null,null,"Leakage Cost Per year",null,null,null,null,{"$f":"1+1/4","v":1.25},31.75,672,784,900,1019,1124,1240,1352,1464,1693,1917,2144,2370,2596,3160,3725,4860]
[null,null,{"$f":"C21*C23","v":131089.92000000001},null,{"$f":"E21*E23","v":{"$error":"#DIV/0!"}},"Rs/y",">","Annual operation hours x leakage cost per hour",null,{"$f":"1+3/8","v":1.375},34.924999999999997,816,954,1091,1230,1367,1505,1643,1780,2054,2330,2607,2880,3153,3840,4525,5910]
[null,null,null,null,null,null,null,null,null,{"$f":"1+1/2","v":1.5},38.1,968,1132,1293,1460,1620,1783,1946,2112,2335,2760,3081,3412,3734,4550,5360,7000]
[null,null,null,null,null,null,null,null,null,{"$f":"1+3/4","v":1.75},44.45,1318,1540,1760,1985,2205,2429,2650,2875,3310,3755,4200,4645,5085,6195,7300,9530]
[null,"HOW TO USE:",null,null,null,null,null,null,null,2,50.8,1720,2120,2300,2594,2880,3173,3460,3752,4330,4915,5480,6070,6650,8100,9540,12450]
[null,"1. Insert data from your company in cells that are highlighted in white \n2. Data for Motor Power, Motor Efficiency, and Annual Operation Hours can be compiled in table \"Equipment Data\" once and inserted from this source. "]

{"sheet":"7| High Efficiency Motor","index":7,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,7],[12,7,13,7],[14,7,15,7],[1,1,1,7],[2,1,2,7],[21,1,21,7],[22,1,22,7],[23,1,23,7]]}
[]
[null,"ENERGY SAVING BY INSTALLING HIGH EFFICIENCY MOTOR"]
[null,"ISSUE: Compressors usually do not come with high efficiency motors as standard, however, they are often offered as options. For compressors with long annual running hours a high efficiency motor may be more economical. \n\nWHAT WE DO HERE: Calculate the energy savings achievable by using a high efficienc motor instead of a standard motor. "]
[null,null,"Example",null,"Motor Power"]
[null,null,160,null,null,"[kW]",">","Compressor motor rating"]
[null,null,null,null,"Motor Efficiency"]
[null,null,0.92,null,null,"[%]",">","Standard compressor motor efficiency (default =92%)"]
[null,null,null,null,"% Full Load"]
[null,null,0.65,null,null,"[%]",">","Estimate of average percentage motor load factor (default =65%)"]
[null,null,null,null,"Annual Operation Hours"]
[null,null,6240,null,null,"[h/y]",">","24h/7d =8.760 hours; 24h/5d =6.240 hours; h/5d = 2.080 hours"]
[null,null,null,null,"New Motor Efficiency"]
[null,null,0.93500000000000005,null,null,"[%]",">","= Efficiency new motor [%]-Efficiency old standard compressor motor [%] \n(default = 1,5% higher than old motor)"]
[null,null,null,null,"Energy Savings"]
[null,null,{"$f":"C5*C9*C11*((1/C7)-(1/C13))","v":11316.43803766573},null,{"$f":"E5*E9*E11*((1/E7)-(1/E13))","v":{"$error":"#DIV/0!"}},"[kWh/y]",">","= (Motor Power [kW] x (Full Load [%]) x Operation Hours [h/y]) x (1/Compressor Motor Efficiency [%] - 1/New Motor Efficiency [%])"]
[null,null,null,null,"Average Electricity Price"]
[null,null,18,null,null,"[Rs/kWh]",">","Insert from Energy Bills"]
[null,null,null,null,"Annual Cost Savings"]
[null,null,{"$f":"C15*C17","v":203695.88467798315},null,{"$f":"E15*E17","v":{"$error":"#DIV/0!"}},"[$/y]",">","= (Annual Energy Savings [kWh/y] x (Average Electricity Price [$/kWh])"]
[]
[]
[null,"HOW TO USE:"]
[null,"1. Insert data from your company in cells that are highlighted in white \n2. Data for Motor Power, Motor Efficiency, % Full Load and Annual Operation Hours can be compiled in table \"Equipment Data\" once and inserted from this source.  "]
[null,"ADDITIONAL INFORMATION & TIPS"]
[null,"1. Rule of Thumb: a high efficiency motor will typically be 1,5% more efficient than a standard compressor motor. Please, insert exact value if available from supplier.  \n2. Payback: Base load machines that operate more hours annually show quicker returns on investment than trim machines that only operate few hours to cover peak demand.\n3. Compressors usually do not come with high efficiency motors as standard, however, motors with higher efficiency are often offered as option. For compressors for base load a high efficiency motor may be more economical.  \n\n"]

{"sheet":"8| Multi-stage compressor","index":8,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,7],[14,7,15,7],[1,1,1,7],[2,1,2,7],[21,1,21,7],[22,1,22,7],[23,1,23,7]]}
[]
[null,"ENERGY SAVING BY USING MULTIPLE-STAGE COMPRESSOR"]
[null,"ISSUE: Multiple-stage compressors are normally more efficient than single- or two stage machines. Reason: When pressure is generated over several steps the air can be cooled inbetween, thereby reducing volume and work required to compress the air. \n\nWHAT WE DO HERE:  Calculate the energy savings achievable by using a multiple stage compressor instead of a single stage compressor. "]
[null,null,"Example",null,"Motor Power"]
[null,null,160,null,null,"[kW]",">","Compressor motor rating"]
[null,null,null,null,"Motor Efficiency"]
[null,null,0.92,null,null,"[%]",">","Standard compressor motor efficiency (default =92%)"]
[null,null,null,null,"% Full Load"]
[null,null,0.65,null,null,"[%]",">","Estimate of average percentage motor load factor (default =65%)"]
[null,null,null,null,"Annual Operation Hours"]
[null,null,6240,null,null,"[h/y]",">","24h/7d =8.760 hours; 24h/5d =6.240 hours; h/5d = 2.080 hours"]
[null,null,null,null,"% Savings over Single-stage"]
[null,null,0.13,null,null,"[%]",">","default: 6% for Reciprocating Compressor, 13% for Rotary Screw Compressor"]
[null,null,null,null,"Energy Savings"]
[null,null,{"$f":"C5/C7*C9*C11*C13","v":91700.869565217406},null,{"$f":"E5/E7*E9*E11*E13","v":{"$error":"#DIV/0!"}},"[kWh/y]",">","= (Motor Power [kW] x (Full Load [%]) x Operation Hours [h/y]) x (1/Compressor Motor Efficiency [%] - 1/New Motor Efficiency [%])"]
[null,null,null,null,"Average Electricity Price"]
[null,null,18,null,null,"[Rs/kWh]",">","Insert from Energy Bills"]
[null,null,null,null,"Annual Cost Savings"]
[null,null,{"$f":"C15*C17","v":1650615.6521739133},null,{"$f":"E15*E17","v":{"$error":"#DIV/0!"}},"[Rs/y]",">","= (Annual Energy Savings [kWh/y] x (Average Electricity Price [$/kWh])"]
[]
[]
[null,"HOW TO USE:"]
[null,"1. Insert data from your company in cells that are highlighted in white \n2. Data for Motor Power, Motor Efficiency, % Full Load and Annual Operation Hours can be compiled in table \"Equipment Data\" once and inserted from this source.  "]
[null,"ADDITIONAL INFORMATION & TIPS"]
[null,"1. Rule of Thumb: Two-stage reciprocating compressors are 6% more efficient than single-stage reciprocating compressors. Two-stage rotary screw-compressors are 13% more efficient than single-stage versions. \n2. Payback: The premium paid for equal power, two-stage machines will be 30 to 40%. However, the two-stage machine will have more capacity (l/s) than the same power, single-stage machine. Therefore sometimes a smaller power two-stage machine can be used instead of the larger power single-stage machine for the same job, resulting in an effective cost premium of less than 30% . Payback highly depends on operating hours. \n3. Rotary Screw Compressors are the most common compressors used in industry today and do have many inherent advantages over reciprocating compressors including a lower capital cost; lower maintenance costs; smaller size and reduced vibration and noise.  Two stage rotary screw compressors may not be available for sizes smaller than ~75 kW.\n4. Reciprocating compressors were historically the most commonly used compressors. However, the higher capital and maintenance costs have reduced their market dominance in recent years.  Despite this, it is generally accepted that multi-stage version of these units are the most efficient compressor type.\n5. Centrifugal compressors are generally only suitable for high volume applications with little variance in the demand load. These compact units are available in two, three and four stage compression technology. Generally centrifugal compressors are three stage units – which tend to be more efficient than rotary screw compressors – with inherent efficiencies approaching those of double-acting reciprocating compressors."]

{"sheet":"9| Variable Speed Drive","index":9,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,7],[14,7,15,7],[1,1,1,7],[2,1,2,7],[23,1,23,7],[24,1,24,7],[25,1,25,7]]}
[]
[null,"ENERGY SAVING BY INSTALLING VARIABLE SPEED DRIVE"]
[null,"ISSUE: Traditionally, one or more compressors provide the base load and one compressor the peak load. Airflow is typically controlled by a valve. This method results in a higher discharge pressure, lower part load efficiencies and increased overall power consumption. VSD motors are interesting for facilities with high variance in demand profile. \n\nWHAT WE DO HERE:  Calculate the energy savings achievable by using a Variable Speed Drive (VSD) instead of inlet modulation control. "]
[null,null,"Example",null,"Motor Power"]
[null,null,160,null,null,"[kW]",">","Compressor motor rating"]
[null,null,null,null,"Motor Efficiency"]
[null,null,0.92,null,null,"[%]",">","Standard compressor motor efficiency (default =92%)"]
[null,null,null,null,"VSD Efficiency"]
[null,null,0.96,null,null,"[%]",">","Variable Speed Drive efficiency (default = 96%)"]
[null,null,null,null,"Average Part Load Condition"]
[null,null,0.65,null,null,"[%]",">","Average compressor loading expressed as a percentage of the rated capacity (l/s or CFM)"]
[null,null,null,null,"Annual Operation Hour"]
[null,null,6240,null,null,"[h/y]",">","24h/7d =8.760 hours; 24h/5d =6.240 hours; h/5d = 2.080 hours"]
[null,null,null,null,"Average Power Saving"]
[null,null,{"$f":"C5/C7*70%*(100%-C11)*C9","v":40.904347826086955},null,{"$f":"E5/E7*70%*(100%-E11)*E9","v":{"$error":"#DIV/0!"}},"[kW]",">","= Motor Power [kW]/Motor Efficiency [%] x 70% x (100%-Average Part Load Condition [%]) X VSD Efficiency [%]"]
[null,null,null,null,"Annual Energy Savings"]
[null,null,{"$f":"C15*C13","v":255243.13043478259},null,{"$f":"E15*E13","v":{"$error":"#DIV/0!"}},"[kWh/y]",">","= Average Power Saving [kW] x Annual Operation Hours [h/y]"]
[null,null,null,null,"Average Electricity Price"]
[null,null,18,null,null,"[Rs/kWh]",">","Insert from Energy Bills"]
[null,null,null,null,"Annual Cost Savings"]
[null,null,{"$f":"C17*C19","v":4594376.3478260869},null,{"$f":"E17*E19","v":{"$error":"#DIV/0!"}},"[Rs/y]",">","= (Annual Energy Savings [kWh/y] x (Average Electricity Price [$/kWh])"]
[]
[]
[null,"HOW TO USE:"]
[null,"1. Insert data from your company in cells that are highlighted in white \n2. Data for Motor Power, Motor Efficiency, and Annual Operation Hours can be compiled in table \"Equipment Data\" once and inserted from this source. "]
[null,"ADDITIONAL INFORMATION & TIPS"]
[null,"1. Rule of Thumb: Use of VSD compressor control instead of inlet variation control can be expressed approximately by: Power Savings = 70% (100%-% Rated Flow)"]

{"sheet":"10| Waste Heat","index":10,"n_rows":86,"n_cols":8,"rows_kept":86,"cut":false,"hidden":false,"merged":[[85,1,85,7],[23,4,23,5],[2,1,2,7],[1,1,1,7],[82,1,82,7],[83,1,83,7],[84,1,84,7]]}
[]
[null,"RECUPERATION OF WASTE HEAT FROM COMPRESSOR"]
[null,"ISSUE: Compressed air is the most expensive form of energy as over 90% of electrical energy is wasted, mainly as heat, while only around 5% is converted into compressed air. \n\nWHAT WE DO HERE:  Calculate the thermal energy that can be recovered from the compressor and used for heating in other processes. "]
[null,null,"Example",null,"Motor Power"]
[null,null,160,null,null,"[kW]",">","Compressor motor rating"]
[null,null,null,null,"Recoverable heat from compressor"]
[null,null,0.85,null,null,"[%]",">","Recovery efficiency; default = 80-90% for air-cooled packaged rotary screw compressors; default = 50-60% for water-cooled compressors"]
[null,null,null,null,"Annual Operation Hour"]
[null,null,6240,null,null,"[h/y]",">","24h/7d =8.760 hours; 24h/5d =6.240 hours; h/5d = 2.080 hours"]
[null,null,null,null,"% Full Load"]
[null,null,0.65,null,null,"[%]",">","Estimate of average percentage motor load factor (default =65%)"]
[null,null,null,null,"% Hours in which waste heat can be used"]
[null,null,0.86,null,null,"[%]",">","= Operating hours in which heat is used while compressor is operating / operating hours compressor"]
[null,null,null,null,"Primary heater efficiency"]
[null,null,0.85,null,null,"[%]",">","default = 85% for gas or oil heating"]
[null,null,null,null,"Recoverable heat from compressor"]
[null,null,{"$f":"C5*C7","v":136},null,{"$f":"E5*E7","v":0},"[kW]",">","= Motor Power [kW] x Recoverable heat from compressor [%]"]
[null,null,null,null,"Annual operation hours of compressor with full load"]
[null,null,{"$f":"C9*C11","v":4056},null,{"$f":"E9*E11","v":0},"[h/y]",">","= Annual Operation Hours [h/y] x Full Load [%]"]
[null,null,null,null,"Useable amount of waste heat from compressor"]
[null,null,{"$f":"C17*C19*C13","v":474389.76000000001},null,{"$f":"E17*E19*E13","v":0},"[kWh/y]",">","= Recoverable heat from compressor [kW] x Annual Operation Hours with \nfull load [h/y] x Hours in which waste heat can be used [%]"]
[]
[]
[null,null,null,null,"Fuel Mix Used for Primary Heater"]
[]
[null,null,null,null,"Natural Gas"]
[null,null,0.25,null,null,"[%]",">","=%age of time the Primary Heater runs on this fuel"]
[null,null,null,null,"Furnace Oil"]
[null,null,0.5,null,null,"[%]",">","=%age of time the Primary Heater runs on this fuel"]
[null,null,null,null,"Electricity"]
[null,null,0.1,null,null,"[%]",">","=%age of time the Primary Heater runs on this fuel"]
[null,null,null,null,"LPG"]
[null,null,0.05,null,null,"[%]",">","=%age of time the Primary Heater runs on this fuel"]
[null,null,null,null,"Coal"]
[null,null,0.1,null,null,"[%]",">","=%age of time the Primary Heater runs on this fuel"]
[]
[null,null,null,null,{"$f":"IF(SUM(E27:E35)>0%,(IF(SUM(E27:E35)=100%,\"\",\"Total Mix is not 100%\")), \"\")","v":""}]
[null,null,null,null,"Fuel Unit Purchase Price"]
[]
[null,null,null,null," Natural Gas "]
[null,null,400,null,null,"[PKR/mmBtu]",">","Enter unit price from Utility Bill"]
[null,null,null,null," Furnace Oil "]
[null,null,100,null,null,"[PKR/Liter]",">","Enter unit price from purchase invoice"]
[null,null,null,null," Electricity "]
[null,null,18,null,null,"[PKR/kWh]",">","Enter unit price from Utility Bill"]
[null,null,null,null," LPG "]
[null,null,150,null,null,"[PKR/kg]",">","Enter unit price from purchase invoice"]
[null,null,null,null," Coal "]
[null,null,5,null,null,"[PKR/kg]",">","Enter unit price from purchase invoice"]
[]
[]
[null,null,null,null,"Total Quantity of Fuel Saved"]
[null,null,{"$f":"C55+C57+C59+C61+C63","v":558105.59999999986},null,{"$f":"E55+E57+E59+E61+E63","v":{"$error":"#DIV/0!"}},"[kWhHoTotal/y]",">","Total kWh equivalent Fuel Saving"]
[null,null,null,null,"Natural Gas"]
[null,null,{"$f":"C$21/C$15*C27","v":139526.39999999999},null,{"$f":"E$21/E$15*E27","v":{"$error":"#DIV/0!"}},"[kWhHo/y] ",">","Share of Natural Gas in total savings"]
[null,null,null,null,"Furnace Oil"]
[null,null,{"$f":"C$21/C$15*C29","v":279052.79999999999},null,{"$f":"E$21/E$15*E29","v":{"$error":"#DIV/0!"}},"[kWhHo/y] ",">","Share of Furnace Oil in total savings"]
[null,null,null,null,"Electricity"]
[null,null,{"$f":"C$21/C$15*C31","v":55810.559999999998},null,{"$f":"E$21/E$15*E31","v":{"$error":"#DIV/0!"}},"[kWhHo/y] ",">","Share of Grid Electricity in total savings"]
[null,null,null,null,"LPG"]
[null,null,{"$f":"C$21/C$15*C33","v":27905.279999999999},null,{"$f":"E$21/E$15*E33","v":{"$error":"#DIV/0!"}},"[kWhHo/y] ",">","Share of LPG in total savings"]
[null,null,null,null,"Coal"]
[null,null,{"$f":"C$21/C$15*C35","v":55810.559999999998},null,{"$f":"E$21/E$15*E35","v":{"$error":"#DIV/0!"}},"[kWhHo/y] ",">","Share of Coal in total savings"]
[]
[null,null,null,null,"Total Quantity of Fuel Saved"]
[]
[null,null,null,null,"Natural Gas"]
[null,null,{"$f":"C55/((1055.1/36)*10)","v":476.0639181120273},null,{"$f":"E55/((1055.1/36)*10)","v":{"$error":"#DIV/0!"}},"[mmBru/y] ",">","= [Natural Gas kWhHo/y]/[(1055.1/36)*10]"]
[null,null,null,null,"Furnace Oil"]
[null,null,{"$f":"C57*1165.34/11630","v":27961.426479105758},null,{"$f":"E57*1165.34/11630","v":{"$error":"#DIV/0!"}},"[Liter/y] ",">","[10.786 kWhHo per 1 Liter Furnace Oil]"]
[null,null,null,null,"Electricity"]
[null,null,{"$f":"C59","v":55810.559999999998},null,{"$f":"E59","v":{"$error":"#DIV/0!"}},"[kWh/y] ",">"]
[null,null,null,null,"LPG"]
[null,null,{"$f":"C61/13","v":2146.56},null,{"$f":"E61/13","v":{"$error":"#DIV/0!"}},"[Toe/Tonne]",">","[13 kWhHo per 1 kg LPG]"]
[null,null,null,null,"Coal Calorific Value"]
[null,null,0.44,null,0.44400000000000001,"[kg/y] ",">","Select calorific value from drop-down in the cell"]
[null,null,null,null,"Coal"]
[null,null,{"$f":"C63*1000/(11630*$C$76)","v":10906.46447275854},null,{"$f":"E63*1000/(11630*$E$76)","v":{"$error":"#DIV/0!"}},"[kg/y] ",">","= [1000 x Coal kWhHo/y] / [11630*(Calorific Value of Coal)]"]
[null,null,null,null,"Annual Cost Savings"]
[null,null,{"$f":"C68*C41+C70*C43+C72*C45+C74*C47+C78*C49","v":4367674.6175191803},null,{"$f":"E68*E41+E70*E43+E72*E45+E74*E47+E78*E49","v":{"$error":"#DIV/0!"}},"[PKR/y]",">"]
[]
[]
[null,"HOW TO USE:"]
[null,"1. Insert data from your company in cells that are highlighted in white \n2. Data for Motor Power, Motor Efficiency, and Annual Operation Hours can be compiled in table \"Equipment Data\" once and inserted from this source. "]
[null,"ADDITIONAL INFORMATION & TIPS"]
[null,"1. Rule of Thumb: Use of VSD compressor control instead of inlet variation control can be expressed approximately by: Power Savings = 70% (100%-% Rated Flow)"]

{"sheet":"Tabelle3","index":11,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["Level"]
[1]
[2]
[3]
[4]
[5]

{"sheet":"Calor Val","index":12,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[[2,1,2,3]]}
[]
[]
[null,"Net Calorific Values - Coal"]
[null,null,"toe/tonne"]
[null,"USA",0.64600000000000002]
[null,"India",0.47699999999999998]
[null,"South Africa",0.53500000000000003]
[null,"Australia",0.59199999999999997]
[null,"Russia",0.44400000000000001]
[null,"Poland",0.56999999999999995]
[null,"Kazakhstan",0.44400000000000001]
[null,"Ukraine",0.51600000000000001]
[null,"Germany",0.58799999999999997]
[null,"Others"]

{"sheet":"dropdown","index":13,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[null,"[psi]","Sharp Edged"]
[null,"[bar]","Well Rounded"]