Spreadsheet: 115519d1311100472-trying-to-index-and-offset-in-a-formula-excelforum
Sheet: CMT

 |  | Chemical Management Team Quarterly KPI Data Sheet
 |  | Asset:
 |  | Quarter | Date:
 |  | Lead:
 |  | Vendor:
 |  | Participants:
 |  | LAN Location:
 |  |  |  |  |  |  | In Compliance |  |  | Out of Compliance
 |  | CMT Efficiency & Effectiveness
 |  | Quarterly Target | Q | YTD | SHES Reporting |  |  |  | Quarterly Target | Q | YTD | Chemical Usage
 |  |  |  |  | Safety Incidents |  |  |  |  |  |  | Total Spend vs Plan ($k) - in cap
 |  |  |  |  | Near Misses Reported |  |  |  |  |  |  | Total Spend vs Plan ($k) - not in cap
 |  |  |  |  | [NAME] |  |  |  |  |  |  | Chemical Changes (new)
 |  |  |  |  | Spills during program execution |  |  |  |  |  |  | Chemical Changes (rate)
 |  |  |  |  | Internal Corrosion Losses of Containment |  |  |  |  |  |  | Chemical Changes without eMOC
 |  |  |  |  | Leaks in Injection Equipment |  |  |  | Target | Q | YTD | Maintenance
 |  | Target | Q | YTD | Administrative Items |  |  |  |  |  |  | Injection Pump Uptime (%)
 |  |  |  |  | CMT Meetings Conducted |  |  |  |  |  |  | Injection Equipment Repair Costs ($k)
 |  |  |  |  | Priority 1 Action Items Open > 1Q |  |  |  | Target | Q | YTD | Integrity Chemicals
 |  |  |  |  | Priority 2 Action Items Open > 6 months |  |  |  |  |  |  | Pumps Injecting at Target Rates (% of time)
 |  |  |  |  | Priority 3 Action Items Open > 1 yr |  |  |  |  |  |  | Corrosion Inhibitor Residual Outside Target
 |  |  |  |  | Action Items Closed |  |  |  |  |  |  | Biocide Residual Outside Target
 |  |  |  |  | eMOCs outstanding > 6 Months |  |  |  |  |  |  | [NAME] Target
 |  |  |  |  | Critical PMs > 30 days overdue |  |  |  | Target | Q | YTD | Flow Assurance Chemicals
 |  |  |  |  | Critical PMs > 90 days overdue |  |  |  |  |  |  | Pumps Injecting at Target Rates (% of time)
 |  | Target | Q | YTD | Participation |  |  |  |  |  |  | Scale Inhibitor Residual Outside Target
 |  |  |  |  | Operations |  |  |  |  |  |  | Wax/Hydrate Mitigator Residual Outside Target
 |  |  |  |  | Chemical Vendor |  |  |  |  |  |  | Demulsifier Residual Outside Target
 |  |  |  |  | Programmatics |  |  |  | Target | Q | YTD | Workover Chemicals
 |  |  |  |  | Facilities |  |  |  |  |  |  | Pumps Injecting at Target Rates (% of time)
 |  |  |  |  | Reservoir |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Subsurface |  |  |  |  |  |  | Unacceptable Emulsions (% volume)
 |  |  |  |  | Other (To be completed by asset) |  |  |  | Target | Q | YTD | Other Chemicals
 |  | Target | Q | YTD | OFC Vendor Man-hours |  |  |  |  |  |  | Pumps Injecting at Target Rates (% of time)
 |  |  |  |  | Field (%) |  |  |  |  |  |  | Water Clarifier Residual Outside Target
 |  |  |  |  | Office (%) |  |  |  |  |  |  | Other (To be completed by asset)
 |  |  |  |  | Offsite (%) |  |  |  | Target | Q | YTD | FIMS Stewardship
 |  | Target | Q | YTD | Total System Analyses |  |  |  |  |  |  | Monitoring Measurements (e.g., Coupon Pulls)
 |  |  |  |  | Recommendations Implemented |  |  |  |  |  |  | Monitoring Exceptions
 |  |  |  |  | Recommendations Rejected |  |  |  |  |  |  | Water Samples
 |  |  |  |  | Recommendations Outstanding (>1 yr) |  |  |  |  |  |  | Water Sample Exceptions
 |  | Target | Q | YTD | [NAME] |  |  |  |  |  |  | Amine Samples
 |  |  |  |  | Pig Runs |  |  |  |  |  |  | Amine Sample Exceptions
 |  |  |  |  | Skipped Pig Runs |  |  |  |  |  |  | Glycol Samples
 |  |  |  |  | Launcher/Receiver Issue |  |  |  |  |  |  | Glycol Sample Exceptions
 |  |  |  |  | Process Condition |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Other Reason |  |  |  |  |  |  | [NAME] Exceptions
 |  |  |  |  | Pig Samples |  |  |  |  |  |  | Other (To be completed by asset)
 |  |  |  |  | Pig Sample Analysis Exceptions (%) |  |  |  |  |  |  | Other (To be completed by asset)
 |  | Purpose: CMT tracking tool to communicate the performance of the CMT program in terms of efficiency and effectiveness.  CMT Charter Statement: A cross-functional ALT sub-team intended to optimize performance and deliver a cost-effective chemical program that stewards integrity chemicals and production enhancement chemicals.  CMT Goals: Eliminate significant process and facility incidents, apply a scaled focus on base capacity and reliability improvements, and identify additional opportunities to capture full resource potential.