# Utilisation

This spreadsheet is a summary of the average number of visits (utilisation) per patient by provider type, practice, ethnicity, age group and gender for your PHO.View a sample report (pdf 414kb)

It is important to distinguish between the number of visits and the utilisation rate. The absolute number of visits lets you see how much of your time is spent with different patient groups so is a good representation of time spent. However, when doing comparisons between groups, it is important to standardise to a utilisation rate. Otherwise it is easy to make mistaken judgments about which patient groups are receiving more or less service.

It is also very important when analysing by ethnicity or quintile to make sure that comparisons are done by age group. This is because different populations can have very different age distributions, and as utilisation varies by age group then comparison can be skewed.

All of the utilisation data excludes ACC, maternity, immunisation, scripts and administrative invoices. If your practices are not creating $0 invoices for visits that have no charge, then those visits will NOT be included in these totals.

### Summary

This page has two sections summarizing the utilisation data for the quarter.

To calculate the utilisation for a month it is simply the total number of visits divided by the total enrolled patients - giving a utilisation rate.

To calculate the utilisation for a quarter the number of patients will need to be averaged over the quarter as the number of patients is not constant over the period.

The left hand side of this sheet shows utilisation by month and as a total for the quarter. It is broken down by the type of visit ( GP or Nurse/Other)

The right hand side shows the utilisation rate by month and funding age group. This makes it clear how much utilisation rate varies by age group.

### Utilisation

This spreadsheet has a table showing utilisation data for the last two years (currently only back to the start of NES)

The table shows the monthly values for the following fields:

- Enrolled Patients in NES
- Gp Visits
- Gp Utilisation Rate
- Nurse/Other Visits
- Nurse/Other Utilisation Rate
- Total Visits
- Total Utilisation Rate

### Utilisation graph

This spreadsheet contains is a graph showing the information from the Utilisation spreadsheet. It shows trends for example seasonal variation or the impact of COVID19 on utilisation.

### Practice breakdown

This sheet has four tables.

All of these tables show the breakdown of the following values by practice.

- Enrolled Patients in NES
- Gp Visits
- Gp Utilisation Rate
- Nurse/Other Visits
- Nurse/Other Utilisation Rate
- Total Visits
- Total Utilisation Rate

The first of these tables show the average for the quarter.

The following three show the monthly values.

### Practice graph

This spreadsheet contains is a graph showing the information from the first table on the Practice spreadsheet.

**Age group**

This spreadsheet contains a table detailing the Utilisation rates by Age. It breakdown the below information using the standard Age Groups.

- Enrolled Patients in NES
- Gp Visits
- Gp Utilisation Rate
- Nurse/Other Visits
- Nurse/Other Utilisation Rate
- Total Visits
- Total Utilisation Rate

**Age group graph**

This is a graphical representation of the utilisation on the previous sheet.

**CSC**

This spreadsheet has three tables each is detailed below:

- The first table has a breakdown of the patients funded and registered in NES by Age Group and if they have a Community Service Card.
- The second table has a breakdown of the visits by Age Group and Community Service Card.
- The third table has a breakdown of the utilisation rates by Age Group and Community Service Card.

**CSC Graph**

This spreadsheet has a graph of the third table on the CSC spreadsheet.

**Quintile**

This spreadsheet has three tables each is detailed below:

- The first table has a breakdown of the patients funded and registered in NES by Age Group and Quintile.
- The second table has a breakdown of the visits by Age Group and Quintile.
- The third table has a breakdown of the utilisation rates by Age Group and Quintile.

**Quintile graph**

This spreadsheet has a graph of the third table on the Quintile spreadsheet.

**Ethnic group**

This spreadsheet has three tables each is detailed below:

- The first table has a breakdown of the patients funded and registered in NES by Age Group and Ethnic Group.
- The second table has a breakdown of the visits by Age Group and Ethnic Group.
- The third table has a breakdown of the utilisation rates by Age Group and Ethnic Group.

**Ethnic group graph**

This spreadsheet has a graph of the third table on the Ethnic Group spreadsheet.