This month I will be discussing how to create a Compressed Air Report. This air report is exactly like our Compressed Mixed Gas report, except that this report is just for compressed air. When you look at this new air report, you will see some subtle differences.
When you open your Compressed Air Report, you will need to know three things in order for this report to work. First, you need to know what the db levels are for the leaks (you get this from your Ultraprobe). Second, you need to know what the pressure is at each of these leaks (Note: this spreadsheet is an estimator because you only have a few options to choose from your pressure at leak. It is wise to underscore your pressure because if you have a pressure of 90 psi you don’t want to choose 100 in your spreadsheet because it will over-inflate your dollar amount. You always want to choose the lower pressure value. This way you will be more conservative of your findings.) Finally, you need to know how much you pay for electricity (per KWh) at your facility to produce that air.
Once you plug those figures in, your report will then start crunching the numbers and it will then spit out the dollar figures for each individual leak that you just found from your survey. It will give you a grand total (in dollars) of all of the leaks you found. After you finish plugging in the values for your report you can then start typing in where the leaks are located within the problem description.
If you have fixed some of the leaks you can type in “Y” under the “Repaired” column. It will then add that dollar value to the overall “Repaired” slot which will be located just under the “Cost Avoidance.” This report will also give you the percentage of all the leaks that you have repaired within this survey. The survey will also have CFM values for each individual leak and it will give values for the greenhouse gases for each individual leak as well.
There is a “Repair Difficulty” column in this report, where there is a drop down box and you get to choose the level of repair difficulty. There is also a “Safety Issue” column where you can state if there are any safety problems. Also there are “Repair Date” and “Repair By” columns.
Lastly, you will notice under the cost tab that there is a “Capturable Rate” box. If you know the percentage loss that you can recover overall then the report will adjust the grand total of money to the capturable rate. Example, if you found $100,000 worth of leaks and you figure that your Capturable Rate is 60%, then your report will adjust to saying that out of the $100,000 that you have found, you can only recover $60,000.
With all of this data at your fingertips you’ll be able to continue to help your organization cut down on energy waste, and best of all, save money!