HF Project


LCCCG Heart Failure Project

Welcome to the page supporting the project. We are working in Leicester to improve our Heart failure Registers and the care of the multimorbidity these people often suffer from alongside their heart failure.

Accessing the searches

The searches are designed to help you check teh heart failure quickly based on searches shared freely on SystmOne and processed using the spreadsheet supplied on this site. You can access the searches on SystmOne as follows:-

Join HNN South Leicester Group by:-

  • Set-up / Users and Policy / Organisational groups
  • Find Leicester City Pct (Trust Group)
  • Find HNN South leicester
  • Click Join Group
(This enables you to get access to the searches and the format for data output)

Run Search and Process output

  • Under Reporting / Clinical Reporting find 'HNN South Leicester' / 'HF' and the search set 'HF'
  • Select all searches in the set and run them
  • Once run select 'XYZ' / Show Patients / Select Output /Pre-defined report output and select 'HFRegister'
  • Click 'Save All Pages to CSV'.
  • Select all data in the ShowPatients sheet except the headers in row 1. Ctrl +C to copy
  • Open the HFRegister Spreadsheet which has digitally signed macros 'HFRegister.xlsm'
  • Paste values into sheet INP (Ctrl + V) after selecting cell A2

Download the tool

Here is the HF Register spreadsheet (which only supports SystmOne searches.)


Telephone:        0116 244 0888
Fax:                   0116 283 0863
Postal address: 509 Saffron Lane, Leicester, LE2 6UL
E-mail:              daveshep@nhs.net

Author: © 2018 Dr DJ Shepherd
Last modified: 21-05-2018
URL: http://www.ukaguzi.com