---
title: Generate a De-identified Client Trip Summary Using Co-Pilot 
description: Learn how to use the High Level Booking Report and Excel Copilot to generate a de-identified summary of unique clients, including postcodes and total trip counts for a selected reporting period.
---

[Skip to content](https://knowledge.orcoda.com/en/generate-a-de-identified-client-trip-summary-using-copilotwhat-question-is-your-article-answering#main-content)

English

Show submenu for translations

[More support](https://knowledge.orcoda.com/en/kb-tickets/new?hsLang=en)

![ORCODA\_Inline\_Logo\_App\_RGB-1.png\]](https://knowledge.orcoda.com/hs-fs/hubfs/ORCODA_Inline_Logo_App_RGB-1.png?height=40&name=ORCODA_Inline_Logo_App_RGB-1.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [More support](https://knowledge.orcoda.com/en/kb-tickets/new)
- Go to orcoda.com

 Go to orcoda.com

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Orcoda Knowledge Base](https://knowledge.orcoda.com/en?hsLang=en)
2. [Orcoda Bookings System (OBS)](https://knowledge.orcoda.com/en/orcoda-bookings-system-obs?hsLang=en)

# Generate a De-identified Client Trip Summary Using Co-Pilot

## This guide explains how to use Copilot with the High Level Booking Report to generate a de-identified summary of unique clients and their total trip counts for a selected reporting period. The output excludes personal information and can be used for reporting and analysis purposes while maintaining client privacy. The approach was developed in response to a reporting requirement from the Community Transport Organisation (CTO) and can be reused for similar reporting needs.

### Before You Begin

Ensure you have access to:

- The **High Level Booking Report**
- **Co-Pilot** within Excel
- Reporting data covering the required date range (for example, the 2025/26 financial year)

 

### Step 1: Run the High Level Booking Report

1. Navigate to **Reports** in the menu sidebar.
   
   ![](https://knowledge.orcoda.com/hs-fs/hubfs/image-png-Aug-05-2026-12-40-31-4548-AM.png?width=665&height=250&name=image-png-Aug-05-2026-12-40-31-4548-AM.png)
2. Set the date range required (for example, 1 July 2025 to 30 June 2026).
3. Run the report.

The report will return booking and trip data for the selected period.

### Step 2: Open the Report in Excel

1. Export the Booking Report to Excel.
2. Open the exported file in Microsoft Excel.
3. Open the **Copilot** pane by selecting the **Copilot** button in the Excel toolbar.
   
   ![](https://knowledge.orcoda.com/hs-fs/hubfs/image-png-Aug-05-2026-12-44-17-6843-AM.png?width=1896&height=973&name=image-png-Aug-05-2026-12-44-17-6843-AM.png)

### Step 3: Use Copilot to Generate the Summary

In the Co-Pilot pane, enter the following prompt:

***"Using this spreadsheet, create a de-identified list of unique clients showing:***

***- Client postcode***  
***- Total completed trips for the selected reporting period***

***Exclude all personal information such as names, addresses, phone numbers, email addresses, and client IDs.***

***Group duplicate clients into a single record and provide the total trip count for each unique client."***

***![](https://knowledge.orcoda.com/hs-fs/hubfs/image-png-Aug-05-2026-12-52-18-7790-AM.png?width=1917&height=1027&name=image-png-Aug-05-2026-12-52-18-7790-AM.png)***

 

### Step 4: Review the Results

Copilot will generate a summary containing unique client postcodes and their total trip counts for the selected reporting period. Review the results to ensure they meet your reporting requirements and do not contain any identifiable client information.

 

### Step 5: Save or Export the Results

Copy the generated output into a new worksheet or save it as a separate Excel file for distribution or further analysis.

- [Transport 360](https://knowledge.orcoda.com/en/transport-360?hsLang=en#main-content)

    - [User Guides](https://knowledge.orcoda.com/en/transport-360?hsLang=en#user-guides)
- [Orcoda Bookings System (OBS)](https://knowledge.orcoda.com/en/orcoda-bookings-system-obs?hsLang=en#main-content)

    - [OBS Uerguides](https://knowledge.orcoda.com/en/orcoda-bookings-system-obs?hsLang=en#obs-uerguides)
- [Orcoda Care](https://knowledge.orcoda.com/en/orcoda-care?hsLang=en#main-content)

    - [Userguides](https://knowledge.orcoda.com/en/orcoda-care?hsLang=en#userguides)
- [Orcoda Driver App](https://knowledge.orcoda.com/en/orcoda-driver-app?hsLang=en)
- [Orcoda Connect](https://knowledge.orcoda.com/en/orcoda-connect?hsLang=en#main-content)

    - [Orcoda Connect Admin](https://knowledge.orcoda.com/en/orcoda-connect?hsLang=en#orcoda-connect-admin)

[![Chill listening crop-3](https://knowledge.orcoda.com/hs-fs/hubfs/ORCODA_Inline_Logo_App_RGB.png?width=131&height=24&name=ORCODA_Inline_Logo_App_RGB.png "Chill listening crop-3")](https://knowledge.orcoda.com/en?hsLang=en)

Orcoda Help Centre

Copyright © 2026, ORCODA