STW CommCell Guide

PREPARED BY: Luke Mosley

PREPARED FOR: ECAS Teams

VERSION / REFERENCE: V1

Report Guide Severn Trent CommCell

From here, navigate to the most recent months folder and download each Catchments slidedeck. Though not essential, it is advisable to have a designated CommCell folder on your devicde to store these.

It is important to edit previous copies of the Report from SharePoint. This is because Officers may have added their own slides in, or updates from the Client from attendance at the previous months CommCell. These can be found in the CommCell Slides folder, within the CommCell folder, of the Client Engagements Library of the STW SharePoint (direct link below).

Obtaining Previous Copies

Back

Before opening and editing these downloaded copies, it is sensible to edit the file names so these do not get confused with previous versions. Navigate to (or open) the folder containing the downloads and then rename the files to show the date that the new reports are being created. Finally, select all, and open all at the same time. This will make things easier to copy across in one go.

Preparing Copies

Back

Apply these steps to all Catchment presentations. There are 9.

Page 1- Title Page

Back

Copy this slide to all Catchment presentations and delete the one from the previous month. There are 9.

Back

Location of Report

Page 2- New Cases Created

Copy this slide to all Catchment presentations and delete the one from the previous month. There are 9.

Back

Location of Report

Page 3- FOG Captured at Source

Back

Copy this slide to all Catchment presentations and delete the one from the previous month. There are 9.

Location of Report

Page 4- WNO Region Overview Reactive Cases

Back

Copy this slide to all Catchment presentations and delete the one from the previous month. There are 9.

Location of Report

Page 5- WNO Region Overview Proactive Cases

Back

Copy this slide to all Catchment presentations and delete the one from the previous month. There are 9.

Location of Report

Page 6- Successes: Installations and Approvals

Back

Other Pages

Back

Once the slides are completed, they should be saved and then uploaded to a relevantly named monthly folder in the CommCell Slides folder of CommCells in the STW SharePoint.

Upload to SharePoint

Installations Completed

This is obtained by opening the Operational FSE Report and then: -filter Column J (Compliance Status) to include only Compliant -filter Column K (Compliance Date) to include only accounts with a Date of the previous month -filter Column D (Region) to select each Catchment -copy the entries for Column F (Post Code) and Column G (FSE Name) into the table in relevant Catchment Powerpoint. If necessary, change font in table to Aptos Narrow and size 14.

Location of Report

For this slide, you will need the New Referrals Report, located in the Monthly Reports folder of the Client Reports folder in the ECAS Management Data SharePoint. Navigate to the relevant folder and download the report.

Reactive Cases

This is obtained by opening the Operational FSE Report and then: -filter Column B (Incident Type) to exclude Proactive -filter Column H (Engagement Status) to exclude Case Suspended, Ceased Trading, and Client Closed -filter Column D (Region) to select each Catchment -highlight Column G (FSE Name) to get a count of the # of FSEs (minus one for Row A) -for each Catchment, filter Column J (Compliance Status) and exclude Non-Compliant -highlight Column G (FSE Name) to get the numerator for the percentage calculation (minus one for Row A) -Divide this number by the # of FSEs to get Compliance %

Referrals Other Sources

This includes referrals from Perfromance Team, Trade Effluent and Proactive cases: -filter Column D (Incident Department) and exclude 'Waste Network Operations' -filter Column G (Region) to go through each Catchment Highlighting the column will give you a count of the total FSEs (minus one for Row A). Selecting the Filter on Column C (Cluster Name) will let you easily count how many Clusters there are.

For this slide, you will need the Volume of FOG Report, located in the Monthly Reports folder of the Client Reports folder in the ECAS Management Data SharePoint. Navigate to the relevant folder and download the report.

Location of Report

Volume of FOG Graph

This can be obtained by simply compying the graph from the STW Graphs Document in the Monthly Reports folder (direct link below). Navigate to the FOG Captured tab and copy the graph. This graph is for all STW contract (all referral types).

These slides need to be inputted by the Officer for any specific accounts that they need Client assistance with. These can be deleted by the Officer as they are completed or closed off.

Challenges

Proactive Cases Graph

This can be obtained by compying the values from the slide to the STW Graphs Document in the Monthly Reports folder (direct link available). Navigate to the Proactive Cases tab and copy in your values (Including the WNO Region).

Referrals From Networks Teams

This is obtained by using the details tab of the report and then: -filter Column D (Incident Department) and select 'Waste Network Operations' -filter Column G (Region) to go through each Catchment Highlighting the column will give you a count of the total FSEs (minus one for Row A). Selecting the Filter on Column C (Cluster Name) will let you easily count how many Clusters there are.

Proactive Cases

This is obtained by opening the Operational FSE Report and then: -filter Column B (Incident Type) to include only Proactive -filter Column D (Region) to select each Catchment -highlight Column G (FSE Name) to get a count of the # of FSEs (minus one for Row A)

FOG Captured at Source

This is obtained by using the Region tab of the report and then: -filter Column G (Region) for a Catchment -highlight Column F (Total Volume of FOG Removed- Daily) to get a count for that Region.

For this slide, you will need the Operational FSE Report, located in the Monthly Reports folder of the Client Reports folder in the ECAS Management Data SharePoint. Navigate to the relevant folder and download the report.

Location of Report

This should be completed by the Officer once the template has been uploaded. These should highlight positive engagement, installations and good news stories in the Catchment. If there is anything present here from the previous months report, delete the content. We should be showing new successes every month.

Successes: Examples of Installations

Awaiting Installation

This is obtained by opening the Operational FSE Report and then: -filter Column H (Engagement Status) to include only Grease Trap Plan Approval and Grease Trap Installation Reminder -filter Column D (Region) to select each Catchment -copy the entries for Column F (Post Code) and Column G (FSE Name) into the table in relevant Catchment Powerpoint. If necessary, change font in table to Aptos Narrow and size 14.

Reactive Cases Graph

This can be obtained by copying the values from the slide to the STW Graphs Document in the Monthly Reports folder (direct link available). Navigate to the Reactive Cases tab and copy in your values (Including the WNO Region). Columns D and E do not need to be edited.