Specialist Microsoft Excel reports for NHS Primary Care, working in conjunction with clinical system applications
Download Updates
Below are the latest ViPC Dashboard QuarterMasters.
If the QuarterMaster Excel report you are using has displayed an update message, please click the appropriate download button shown below to update the report.
Important: All ViPC QuarterMasters are licenced applications and will only work if your practice has a valid licence to use the specific report. Please feel free to contact us to request a licence.
Optum (EMIS Web) QuarterMaster Reports
Quartermaster Dashboard - Download Instructions
- Please close any open Excel reports before initiating a download below
- Make sure you unzip any updates to the same folder as the current QM Dashboard/Excel report, so that it replaces your current version.
- If you are unsure of the exact file path of the QuarterMaster Dashboard, click the File menu and select "Copy QM Install Location". Then paste directly into the "Unzip to Folder" text area (Step 3 Updates below).
1. Click Download... button below
Once the browser has completed the download
2. Select Open or Run to extracted files (dependent on browser type)
New Install
3. The default installation path is set to O:\ViPC. Please feel free to change this path using the Browse... button
Updates
3. Please click the Browse... button and select the same folder as the current QuarterMaster Dashboard, so that it replaces the current version.
4. Click UNZIP button
All these reports require a search to be run within the Optum clinical system and an exported CSV report file produced. The QuarterMaster will then prompt you for the exported CSV file. If the clinical system search needs to be updated use the .xml file download option below.
Download and install the complete dashboard, which includes all the ViPC QuarterMaster Excel files listed below.
Last Updated: 22/05/2025 v1.0.0
(.xml file)
Specialist Excel Reports
Below are the individual specialist Microsoft Excel reports that make up all the reports in the Quartermaster Dashboard.
Tip: The majority of these reports provide a ViPC tab in the top Microsoft Excel ribbon that include additional tasks, such as creating a list of NHS numbers, so that the patients can be imported back into the clinical system for mail merge purposes or other tasks.
Click Download button > Once download has completed > Click Open or Run and follow instructions...
Routine Child Immunisations
Version: 1.0.0 | Updated: 16/12/2024
This will produce a detailed immunisation report on all children aged 10 years and younger.
Showing given and outstanding immunisations and stages.
Diabetes Management
Version: 1.1.0 | Updated: 11/04/2025
Displays tests, exams, lifestyle, risk factors, co-morbidities, and additional data columns of information to highlight areas in the management of diabetes.
GMS Activity Report
Version: 1.3.0 | Updated: 27/11/2022
Shows General Medical Services activity including areas such as Appointments, Consultations, Encounters, MED3, Medication, Online Medication, Referrals, Letters, SMS, Pathology, Smoking
MoB LTC Management
Version: 1.0.0 | Updated: 10/03/2025
Choose which long term conditions you would like to review, and use the interactive tools to define patients by month of birth.
This reports shows the last review, invite, exception and some clinical data for certain LTC's.
There is also a quick method to create a mail merge document for use with external organisations such as docmailer.
MoB LTC & Medication Reviews
Version: 1.0.0 | Updated: 10/04/2025
Provides a drug lookup table that may be customised to define what tests, health indices, reviews should be carried out against each drug(s) a patient is on. It consolidates all the data where patients are on multiple drugs to provide a single reference for the HCP to carry out.
This report can also be defined by month of birth and/or clinical condition(s)
Repeat Medication Analysis
Version: 1.0.0 | Updated: 09/01/2025
Displays a comprehensive data analysis report on all repeat medication across the whole practice.
Including last medication review and next set diary date.
Seasonal Influenza Report
Version: 1.0.0 | Updated: 14/02/2025
This report will provide statistical details of the yearly Seasonal Influenza vaccinations.
Including vaccines given in and out of practice, clinical judgement, PSD, alllergies and declined vaccines.
Weight Management Report
Version: 1.0.0 | Updated: 07/02/2025
The objective of this report is to shows all patients aged over 17 years that have or had (in last 10 years) a BMI reading outside the normal range of >=30 or <=18.5.
A trend graph of the last 10 readings shows loss or gain over the period up to the last reading.
Other relevant clinical data is also provided showing the latest information/values, including interactive tables and charts for a visual representation of the weight management data.
Hypertension Management
Version: 1.0.0 | Updated: Pending
This report is currently under construction!
South West Cardiff - QuarterMaster Reports
MDT Data Analysis
Version: 1.0.0 | Updated: 14/10/2024
This report has been designed specifcally for SW Cardiff MDT Team to provide an activity data count.
NOAC Analysis
Version: 1.0.0 | Updated: 03/09/2024
Patients taking NOAC medication, including monitoring & management data
Request a Report
If you would like a report designed for a specific project, please contact us to arrange a chat.
