Excel Report on Refrigerant Leak Events
- Anastasia Troichuk (Unlicensed)
- Lamont Eddins
Having a single Excel file with all relevant information on leak events may be of great use when you, for example, need to share the leak event report with your fellow workers or submit it to an internal compliance department. Or, you may want to make some additional calculations, filtering, or sorting in the Excel report. Whatever the purpose is, the leak event report is at your disposal.
Downloading the Leak Events Report
Follow the steps below to export the leak event report to your device.
- Open the hamburger menu in the upper-left corner, and select Assets (Equipment) > Refrigerant Leak Events. You land on the page listing all leak events.
- (Optional) Apply the required filters to include only those leak events you’re interested in, and click Go.
- Click the Download # Leak Records button on the right-hand side.
Opt for the unit of measure the refrigerant amount should be displayed in, and then hit Download Report.
To track the refrigerant usage in kilograms and grams, ask your ServiceChannel representative to enable the required feature for you.
An Excel file with the required leak events gets exported to your device.
Viewing the Leak Events Report
The report reflects key information on leak events that occurred including the area where the leak took place, assets that leaked the refrigerant, amount of the refrigerant used to fix the leak, and more.
Take a look at the details available in the report.
Part 1 (A–E)
- Location. Identification number of the location where the leak happened
- Tag ID. Tag ID of the asset that leaked the refrigerant
- Leak Event Date. Date when the leak occurred or was found: MM/DD/YYYY
- Tracking Number. Tracking number of the work order associated with the leak event
- Work Order Status. Status of the associated work order
Part 2 (F–J)
- Refrigerant Type. Specific type of the refrigerant that was used to fix the leak
- Amount Added. Amount of the refrigerant added to the equipment to fix the leak. It can be in pounds and ounces, pounds and decimals of pounds, or kilograms and grams. What unit of measure to apply depends on the option you select when downloading the report.
- Refrigerant Source Location. Location where the refrigerant part was taken from.
- If the refrigerant was taken from an inventory location, you see the location name.
- In case it was supplied by the vendor, you see Vendor Supplied.
- Leak Record Number. Unique number of the leak event (record) in the system
Part 3 (K–O)
- Current Leak Rate %. Percentage of the current leak rate
- Repair Date. Date when the leak was fixed: MM/DD/YYYY
- Leak Status. Status of the leak event: Completed or In Process
- Leak Area. Area where the leak occurred: more general place, for example, receiver
- Leak Location. Location where the leak occurred: more specific place within the particular area, for example, level indicator/alarm
Part 4 (P–U)
- First Verification Date. Date when the first verification took place: MM/DD/YYYY
- First Verification Method. Method that was used during the first verification to make sure the leak had been fixed
- Second Verification Date. Date of the second verification: MM/DD/YYYY
- Second Verification Method. Method of the second verification
- Follow-Up Work Order Numbers. Tracking numbers of the follow-up work orders that were generated for providers to close the leak record. Based on your company settings, follow-ups may be created if the original work orders get completed with the associated leak events left open.
- Notes. Notes that were manually added by users to a leak record
Two additional fields will be added as the far right columns on the export file title when download for multi-leak:
User Name - Displays the user name of the user who entered the leak detail
User ID - Displays the user Id of the user who entered the leak detail