{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Guidance","Instructions & coding","Patient & Care Process","Sheet1","HBA1c","Blood Pressure","BMI","Cholesterol"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guidance","index":0,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[11,0,11,16],[10,0,10,16],[12,0,12,16],[13,0,13,16],[18,0,18,16],[20,0,20,16],[21,0,21,16],[14,0,14,16],[15,0,15,16],[16,0,16,16],[17,0,17,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Guidance For Completing The Template"]
["The National Diabetes Audit is a major National Clinical Audit, which measures the effectiveness of diabetes healthcare against NICE Clinical Guidelines and NICE Quality Standards, in England and Wales. The NDA collects and analyses data for use by a range of stakeholders to drive changes and improvements in the quality of services and health outcomes for people with diabetes. "]
["Who Should Complete the Template\nThis template should be used by Specialist Services and Insulin Pump Teams wishing to take part in the National Diabetes Audit\n"]
["Which Patients Should Be Included\nPlease return information for diabetes patients diagnosed and registered with your service. Records should be returned for people diagnosed with Diabetes Mellitus, this includes patients with Type 1, Type 2, MODY or Other diabetes. \n\nPlease do not include information for Patients diagnosed with gestational diabetes or diabetes insipidus.\n\n"]
["Insulin Pump Patients \nFor patients that are on an insulin pump please complete columns AA to AK in the Patient and Care Process worksheet. "]
["How to Complete the Template\nInstructions are contained within this spreadsheet. \n\nInstructions & Coding\nThis sheet contains information for what to include in each column. This includes which fields are mandatory or optional, what should be returned and how the data should be coded. \nPlease read this sheet before entering your data\n\nData Quality Tables\nThis sheet contains information to help you check your data prior to submission. Counts are displayed for how many records you have submitted and the different types of records e.g. number of records for each diabetes type. Information is also displayed for insulin pump patients. \n\nPlease check that the distribution of records looks right for your patient cohort before you submit your data. \n\nPatient & Care Process\nThis sheet is to be completed with patient data. Data can either be entered manually or pasted from your extracted data, if you are cutting and pasting your data from another database please paste as values only. \n\n\n"]
["HBA1c\nPlease complete all of the HBA1c readings that have been recorded for all of the patients that appear in the Patient and Care Process worksheet. Each person will have multiple rows depending on the number of readings recorded. "]
["Blood pressure\nPlease complete all of the blood pressure readings that have been recorded for all of the patients that appear in the Patient and Care Process worksheet. Each person will have multiple rows depending on the number of readings recorded. "]
["BMI\nPlease complete all of the BMI readings that have been recorded for all of the patients that appear in the Patient and Care Process worksheet. Each person will have multiple rows depending on the number of readings recorded. "]
["Cholesterol\nPlease complete all of the cholesterol readings that have been recorded for all of the patients that appear in the Patient and Care Process worksheet. Each person will have multiple rows depending on the number of readings recorded. "]
[]
["Submitting Your Data\nWhen you have checked your data and are ready to submit please make sure you have saved the spreadsheet locally. Press the \"Export Data as CSV\" button at the top of the Patient and Care Process worksheet. This will automatically create 5 csv files in the file location where you have saved the excel spreadsheet. On pressing the export data button you will automatically be taken to the NDA portal on the Clinical Audit Platform (CAP) so that you can log in and submit your data. Please make sure you have registered for CAP beforehand. We recommend that you keep a copy of this file for your records in case we need to contact you about your submission. This can be deleted once we have published the report although you may want to keep a copy of the insulin pump data to use as a basis for next years submission."]
["Contacting Us\nFor all queries relating the National Diabetes Audit, please contact the audit team at diabetes@nhs.net or telephone 0300 303 5678\n\n"]

{"sheet":"Instructions & coding","index":1,"n_rows":8,"n_cols":59,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,28,0,31],[0,32,0,33],[1,30,1,33],[1,34,1,35],[0,1,0,10],[1,39,1,42],[1,44,1,48],[1,50,1,53],[1,55,1,58],[7,1,7,8]]}
[null,"Instructions for completing the demographic and care process worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reason on Pump",null,null,null,"Have treatment goals been achieved for:",null,null,null,null,"Multiple readings HBA1c",null,null,null,null,"Multiple readings blood pressure",null,null,null,null,null,"Multiple readings BMI",null,null,null,null,"Multiple readings cholesterol"]
[null,"NHS Number","Date of Birth","Postcode of usual address","Sex","Ethnic category","GP Practice Code","Date of Diagnosis","Diabetes Type","Person observation (Serum Creatinine Level)","Observation Date (Serum creatinine level)","Person observation (Urinary Albumin Level)","Urinary Albumin Level Testing Method","Albuminuria Stage","Observation Date (Urinary Albumin level)","Diabetes routine review (eye)","Observation Date (Eye Examination)","Diabetes routine review (foot)","Observation Date (Foot examination)","Smoking status","Observation date (smoking status)","Patient Education review","Observation date (patient education)","Diabetes Structured Education Programme offered","Observation date (diabetes Structured Education Programme Offered)","Diabetes Structured Education Programme attended","Observation Date (Diabetes Structured Education Programme Attended)","Is the patient on an insulin pump?","Observation date (insulin pump)","Was patient previously on insulin pump?"," Hypoglycaemia Reduction","Glucose Control","Other","Unknown","Hypos","Glucose control","Year started Using Pump","Year stopped Using Pump",null,"NHS Number","Date of Birth","HbA1c level","Observation Date (HbA1c level)",null,"NHS Number","Date of Birth","Systolic Blood Pressure","Diastolic Blood Pressure","Observation Date (blood pressure)",null,"NHS Number","Date of Birth","BMI","Observation Date (BMI)",null,"NHS Number","Date of Birth","Total Serum Cholesterol Level","Observation Date (Cholesterol level)"]
["Mandatory/  Optional*","M","M","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",null,"M","M","O","O",null,"M","M","O","O","O",null,"M","M","O","O",null,"M","M","O","O"]
["Permitted values (codes)","Format (10N)\n10 digit numeric","Date: (format \nCCYY-MM-DD)","The patient’s postcode","National Codes:\n0  Unknown\n1  Male\n2  Female\n9  Not specified","National Codes :\nA White - British\nB White - Irish\nC White - Any other White background\nD Mixed - White and Black Caribbean\nE Mixed - White and Black African\nF Mixed - White and Asian\nG Mixed - Any other mixed background\nH Asian - Indian\nJ Asian - Pakistani\nK Asian - Bangladeshi\nL Asian - Any other Asian Background\nM Black - Caribbean\nN Black - African\nP Black - Any other Black Background\nR Other - Chinese\nS Other - Any other ethnic group\nT Other - Gypsy or Irish traveller\nW Other - Arab\nZ Not stated","Format X99999, where X can be A-H, J-N, P","Date: (format CCYY-MM-DD) ","01  Type 1\n02  Type 2\n06 MODY\n08 Other Specified\n99 Not specified","Format (4N)\n4 digit numeric","Date: (format CCYY-MM-DD)","Format 9999.99","01 Albumin concentration (mg/L)\n02 Albumin creatinine ratio (mg/mmol)\n03 Timed overnight albumin (ug/min)\n04   24hr albumin excretion (mg/24hr)","01 Normoalbuminuria\n02 Microalbuminuria\n03 Macroalbuminuria","Date: (format CCYY-MM-DD)","01 Carried out\n02 Not done\n03 Not necessary","Date: (format CCYY-MM-DD)","01 Carried out\n02 Not done\n03 Not necessary","Date: (format CCYY-MM-DD)","1  Current smoker\n2  Ex-smoker\n3   Non-smoker history unknown\n4   Never smoked\n9  Unknown   ","Date: (format CCYY-MM-DD)","01 Carried out\n02 Not Done","Date: (format: CCYY-MM-DD)","01 Carried out\n02 Not done","Date: (format CCYY-MM-DD)","01 Carried Out\n02 Not Done","Date: (format CCYY-MM-DD)","01 Yes\n02 No","Date: (format CCYY-MM-DD)","01 Yes\n02 No","01 Yes\n02 No","01 Yes\n02 No","01 Yes\n02 No","01 Yes\n02 No","01 Yes\n02 No\n03 Not Applicable\n04 Unknown","01 Yes\n02 No\n03 Not Applicable\n04 Unknown","Date (format CCYY)","Date (format CCYY)",null,"Format (10N)\n10 digit numeric","Date: (format \nCCYY-MM-DD)","Format 999.9","Date: (format CCYY-MM-DD)",null,"Format (10N)\n10 digit numeric","Date: (format \nCCYY-MM-DD)","Format (3N)\n3 digit numeric","Format (3N)\n3 digit numeric","Date: (format CCYY-MM-DD)",null,"Format (10N)\n10 digit numeric","Date: (format \nCCYY-MM-DD)","Format 99.9","Date: (format CCYY-MM-DD)",null,"Format (10N)\n10 digit numeric","Date: (format \nCCYY-MM-DD)","Format 99.9","Date: (format CCYY-MM-DD)"]
["Notes","Records must include an NHS number","If you only know the year of birth enter CCYY-01-01\n","The post code will be translated to LSOA code ",null,"Leave this blank if the ethnic category is unknown.","Leave this blank if the GP practice is not known. Cell will remain amber but your data will still be submitted. \n\n","If you do not know the date of diagnosis enter 9999-99-99 if you only know the year enter CCYY-01-01\n\n","Organisations should determine the type of diabetes from local coding systems. Where Type 1 or Type 2 cannot be derived e.g. a coding of NIDDM or IDDM is used the Type should be coded as 08 Other specified","Only required for children aged 12 years and above \n\nreturn the latest reading recorded for the audit period","Mandatory if observation value provided","Only required for children aged 12 years and above \n\nreturn the latest reading recorded for the audit period",null,null,"Mandatory if observation value provided","Only required for children aged 12 years and above ","Mandatory if observation value 01","Only required for children aged 12 years and above ","Mandatory if observation value 01","return the latest recorded reading for the audit period",null,"return the latest education review recorded","Mandatory if observation value 01","return the latest education offer recorded","Mandatory if observation value 01","return the last attendance at education recorded","Mandatory if observation value 01",null,"Mandatory if observation value 01","Mandatory if patient on pump = 02","Mandatory if patient on pump = 01","Mandatory if patient on pump = 01","Mandatory if patient on pump = 01","Mandatory if patient on pump = 01",null,null,"Mandatory if patient  on pump = 01","Mandatory if patient previously on pump = 01",null,"Records must include an NHS number\nwhere more than one reading in the audit year include multiple rows per person","If you only know the year of birth enter CCYY-01-01\n","Values accepted in mmol/mol only\nreturn all readings recorded for the audit period","Mandatory if observation value provided",null,"Records must include an NHS number\nwhere more than one reading in the audit year include multiple rows per person","If you only know the year of birth enter CCYY-01-01\n","Only required for children aged 12 years and above \nReturn all readings recorded for the audit period","Only required for children aged 12 years and above \nreturn all readings recorded for the audit period","Mandatory if observation value provided",null,"Records must include an NHS number\nwhere more than one reading in the audit year include multiple rows per person","If you only know the year of birth enter CCYY-01-01\n","Only required for children aged 12 years and above \n\nrecord all readings taken within the audit period","Mandatory if observation value provided. ",null,"Records must include an NHS number\nwhere more than one reading in the audit year include multiple rows per person","If you only know the year of birth enter CCYY-01-01\n","Only required for children aged 12 years and above \n\nreturn all readings recorded for the audit period","Mandatory if observation value provided"]
[]
[null,"* Please note that while some data items are marked as optional (O), published reports will contain analysis based on these items, your report will be supplemented by primary care data. Results will therefore be impacted by non-submission from either specialist services or primary care, we advise that wherever possible all data items are submitted and you work as a team to submit data within your CCG for all your diabetes patients. "]

{"sheet":"Patient & Care Process","index":2,"n_rows":2,"n_cols":37,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,29,0,32],[0,33,0,34]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reason on Pump",null,null,null,"Have treatment goals been achieved for:"]
["NHSNumber","Date of Birth","Postcode of usual address","Sex","Ethnic category","GP Practice Code","Date of Diagnosis","Diabetes Type","Person observation (Serum Creatinine Level)","Observation Date (Serum creatinine level)","Person observation (Urinary Albumin Level)","Urinary Albumin Level Testing Method","Albuminuria Stage","Observation Date (Urinary Albumin level)","Diabetes routine review (eye)","Observation Date (Eye Examination)","Diabetes routine review (foot)","Observation Date (Foot examination)","Smoking status","Observation date (smoking status)","Patient Education review","Observation date (patient education)","Diabetes Structured Education Prog offered","Observation date(struct edu)","Diabetes Structured Education Prog attended","Observation date(prog attendance)","Is the patient on an insulin pump?","Observation date (insulin pump)","Was patient previously on insulin pump?"," Hypoglycaemia Reduction","Glucose Control","Other","Unknown","Hypos","Glucose control","Year started Using Pump","Year stopped Using Pump"]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"HBA1c","index":4,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["NHS_Number","Date of Birth","HBA1c_Value","HBA1c_Date_Recorded"]

{"sheet":"Blood Pressure","index":5,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["NHS_Number","Date of Birth","Systolic_Value","Diastolic_Value","Date_Recorded"]

{"sheet":"BMI","index":6,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["NHS_Number","Date of Birth","BMI_Value","BMI_Date_Recorded"]

{"sheet":"Cholesterol","index":7,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["NHS_Number","Date of Birth","Total_Serum_Cholesterol_Value","Total_Serum_Cholesterol_Date_Recorded"]