{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Notes","Summary","PTS ICB","PTS Org","Mode Org","BS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"comments":0,"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":"Notes","index":0,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Ambulance Friends and Family Test (FFT) data - July 2022",null,null,null,null,null,null," Show data for:"]

{"sheet":"Summary","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,1,6,2],[5,5,5,6],[5,7,5,8],[5,9,5,10],[7,1,9,1]]}
[]
[]
[]
[]
[]
[null,"FFT",null,"Number of organisations submitting","Total responses to date","Responses",null,"Percentage Positive",null,"Percentage Negative"]
[null,null,null,"2022-07-01","2022-07-01","2022-07-01","2022-06-26","2022-07-01","2022-06-26","2022-07-01","2022-06-26"]
[null,"Patient Transport Services","Total",12,278817,5003,5256,0.85208874675194879,0.81678082191780821,6.1363182090745552E-2,0.10464231354642313]
[null,null,"NHS",11,208381,3700,3424,0.82837837837837835,0.93078271028037385,7.0000000000000007E-2,3.6507009345794393E-2]
[null,null,"IS",1,70790,1303,1832,0.91941673062164231,0.60371179039301315,3.6838066001534921E-2,0.23198689956331878]

{"sheet":"PTS ICB","index":2,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,5,8,5],[7,6,7,11],[4,1,5,1],[4,4,5,4],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"  "]
[]
[]
["ICB Code","ICB Name","Total Responses","Total Eligible","Percentage Positive","Percentage Negative","Breakdown of Responses"]
[null,null,null,null,null,null,"Very Good","Good","Neither Good nor Poor","Poor","Very Poor","Don't Know"]
[null,"England (including Independent Sector Providers)",5003,511200,0.85208874675194879,6.1363182090745552E-2,2665,1598,408,227,80,25]
[null,"England (excluding Independent Sector Providers)",3700,467362,0.82837837837837835,7.0000000000000007E-2,1759,1306,360,197,62,16]
[null,"Selection (excluding suppressed data)",{"$f":"IFERROR(SUBTOTAL(9,C13:C40),\"-\")","v":5003},{"$f":"IFERROR(SUBTOTAL(9,D13:D40),\"-\")","v":511200},{"$f":"IFERROR((G12+H12)/SUM(G12:L12),\"-\")","v":0.85208874675194879},{"$f":"IFERROR((J12+K12)/SUM(G12:L12),\"-\")","v":6.1363182090745552E-2},{"$f":"IFERROR(SUBTOTAL(9,G13:G40),\"-\")","v":2665},1598,408,227,80,25]
["QHM","NORTH EAST AND NORTH CUMBRIA ICB",110,44390,0.92727272727272725,6.363636363636363E-2,83,19,1,1,6,0]
["QKK","SOUTH EAST LONDON ICB",220,22489,0.91818181818181821,1.8181818181818181E-2,143,59,14,4,0,0]
["QMJ","NORTH CENTRAL LONDON ICB",250,2546,0.98799999999999999,8.0000000000000002E-3,222,25,1,0,2,0]
["QOP","GREATER MANCHESTER ICB",1337,104952,0.91623036649214662,4.7868362004487658E-2,1089,136,32,25,39,16]
["QRL","HAMPSHIRE AND ISLE OF WIGHT ICB",25,1253,1,0,24,1,0,0,0,0]
["QRV","NORTH WEST LONDON ICB",1664,4282,0.71033653846153844,0.10336538461538461,127,1055,310,165,7,0]
["QT1","NOTTINGHAM AND NOTTINGHAMSHIRE ICB",8,23783,0.5,0.5,4,0,0,1,3,0]
["QU9","BUCKINGHAMSHIRE, OXFORDSHIRE AND BERKSHIRE WEST ICB",13,74751,1,0,11,2,0,0,0,0]
["QUA","BLACK COUNTRY ICB",0,74119,"NA","NA",0,0,0,0,0,0]
["QUE","CAMBRIDGESHIRE AND PETERBOROUGH ICB",27,41189,0.77777777777777779,0.22222222222222221,20,1,0,1,5,0]
["QWO","WEST YORKSHIRE ICB",46,73608,0.95652173913043481,0,36,8,2,0,0,0]
["IS1","INDEPENDENT SECTOR PROVIDERS",1303,43838,0.91941673062164231,3.6838066001534921E-2,906,292,48,30,18,9]

{"sheet":"PTS Org","index":3,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,6,8,6],[7,7,7,12],[4,1,5,2],[4,5,5,5],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5]]}
[]
[]
[]
[]
[]
[]
[]
["ICB Code","Org Code","Organisation Name","Total Responses","Total Eligible","Percentage Positive","Percentage Negative","Breakdown of Responses"]
[null,null,null,null,null,null,null,"Very Good","Good","Neither Good nor Poor","Poor","Very Poor","Don't Know"]
[null,null,"England (including Independent Sector Providers)",5003,511200,0.85208874675194879,6.1363182090745552E-2,2665,1598,408,227,80,25]
[null,null,"England (excluding Independent Sector Providers)",3700,467362,0.82837837837837835,7.0000000000000007E-2,1759,1306,360,197,62,16]
[null,null,"Selection (excluding suppressed data)",{"$f":"IFERROR(SUBTOTAL(9,D13:D40),\"-\")","v":5003},{"$f":"IFERROR(SUBTOTAL(9,E13:E40),\"-\")","v":511200},{"$f":"IFERROR((H12+I12)/SUM(H12:M12),\"-\")","v":0.85208874675194879},{"$f":"IFERROR((K12+L12)/SUM(H12:M12),\"-\")","v":6.1363182090745552E-2},{"$f":"IFERROR(SUBTOTAL(9,H13:H40),\"-\")","v":2665},1598,408,227,80,25]
["QHM","RX6","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",110,44390,0.92727272727272725,6.363636363636363E-2,83,19,1,1,6,0]
["QKK","RJ1","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",220,22489,0.91818181818181821,1.8181818181818181E-2,143,59,14,4,0,0]
["QMJ","RRV","UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST",250,2546,0.98799999999999999,8.0000000000000002E-3,222,25,1,0,2,0]
["QOP","RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST",1337,104952,0.91623036649214662,4.7868362004487658E-2,1089,136,32,25,39,16]
["QRL","R1F","ISLE OF WIGHT NHS TRUST",25,1253,1,0,24,1,0,0,0,0]
["QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",1664,4282,0.71033653846153844,0.10336538461538461,127,1055,310,165,7,0]
["QT1","RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",8,23783,0.5,0.5,4,0,0,1,3,0]
["QU9","RYE","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST",13,74751,1,0,11,2,0,0,0,0]
["QUA","RYA","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST",0,74119,"NA","NA",0,0,0,0,0,0]
["QUE","RYC","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST",27,41189,0.77777777777777779,0.22222222222222221,20,1,0,1,5,0]
["QWO","RX8","YORKSHIRE AMBULANCE SERVICE NHS TRUST",46,73608,0.95652173913043481,0,36,8,2,0,0,0]
["IS1","8JR17","ERS MEDICAL",1303,43838,0.91941673062164231,3.6838066001534921E-2,906,292,48,30,18,9]

{"sheet":"Mode Org","index":4,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,1,5,2],[4,4,5,4],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,7,10]]}
[]
[]
[]
[]
[]
[]
[]
["ICB Code","Org Code","Organisation Name","Total Responses","Breakdown of Responses"]
[null,null,null,null,"Mode SMS","Mode Electronic Discharge","Mode Paper Discharge","Mode Paper Home","Mode Telephone","Mode Online","Mode Other"]
[null,null,"England (including Independent Sector Providers)",5003,1338,16,174,1460,471,596,948]
[null,null,"England (excluding Independent Sector Providers)",3700,1338,16,174,157,471,596,948]
[null,null,"Selection (excluding suppressed data)",{"$f":"IFERROR(SUBTOTAL(9,D13:D37),\"-\")","v":5003},1338,16,174,1460,471,596,948]
["QHM","RX6","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",110,0,0,0,102,0,8,0]
["QKK","RJ1","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",220,0,0,0,0,220,0,0]
["QMJ","RRV","UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST",250,0,0,0,0,250,0,0]
["QOP","RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST",1337,1336,0,0,0,0,1,0]
["QRL","R1F","ISLE OF WIGHT NHS TRUST",25,0,0,25,0,0,0,0]
["QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",1664,2,16,149,0,0,550,947]
["QT1","RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",8,0,0,0,0,0,8,0]
["QU9","RYE","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST",13,0,0,0,0,0,13,0]
["QUA","RYA","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST",0,0,0,0,0,0,0,0]
["QUE","RYC","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST",27,0,0,0,11,1,14,1]
["QWO","RX8","YORKSHIRE AMBULANCE SERVICE NHS TRUST",46,0,0,0,44,0,2,0]
["IS1","8JR17","ERS MEDICAL",1303,0,0,0,1303,0,0,0]

{"sheet":"BS","index":5,"n_rows":14,"n_cols":36,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,"Sort","Region code","Region Name","Org code","Org Name","Sort range…","Sort range…","Sort range…","Reference Region List:","Code…","Name…","Linked Region List (PTS, SaT, Mode):","Code…","Name…","Code…","Name…","Code…","Name…","Reference Lists (PTS, SaT, Mode):","Code…","Code…","Name…","Code…","Code…","Name…","Code…","Code…","Name…","Org Linked Lists:","Code…","Name…","Code…","Name…","Code…","Name…"]
["PTS Region",1,1,0,"N/A","N/A","ICB Code","ICB Code","ICB Code",null,"QHM","NORTH EAST AND NORTH CUMBRIA ICB",null,"QHM","NORTH EAST AND NORTH CUMBRIA ICB",null,{"$error":"#N/A"},"IS1","BUCKINGHAMSHIRE, OXFORDSHIRE AND BERKSHIRE WEST STP",null,"QHM","RX6","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",null,null,null,"QHM","RX6","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",null,"8JR17","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",null,null,"8JR17","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST"]
["SaT Region",1,1,1,"N/A","N/A","ICB Name","Org Code","Org Code",null,"QKK","SOUTH EAST LONDON ICB",null,"QKK","SOUTH EAST LONDON ICB",null,{"$error":"#N/A"},"QHM","CAMBRIDGESHIRE AND PETERBOROUGH STP",null,"QKK","RJ1","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",null,null,null,"QKK","RJ1","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",null,"R1F","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST",null,null,"R1F","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST"]
["PTS Org",1,1,1,1,1,"Total Responses","Organisation Name","Organisation Name",null,"QMJ","NORTH CENTRAL LONDON ICB",null,"QMJ","NORTH CENTRAL LONDON ICB",null,{"$error":"#N/A"},"QKK","CUMBRIA AND NORTH EAST STP",null,"QMJ","RRV","UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST",null,null,null,"QMJ","RRV","UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST",null,"RJ1","ERS MEDICAL",null,null,"RJ1","ERS MEDICAL"]
["SaT Org",1,1,1,1,1,"Total Eligible","Total Responses","Total Responses",null,"QOP","GREATER MANCHESTER ICB",null,"QOP","GREATER MANCHESTER ICB",null,{"$error":"#N/A"},"QMJ","GREATER MANCHESTER HEALTH & SOCIAL CARE PARTNERSHIP",null,"QOP","RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST",null,null,null,"QOP","RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST",null,"RRV","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",null,null,"RRV","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST"]
["Mode Org",1,1,1,1,1,"Percentage Positive","Total Eligible","Mode SMS",null,"QRL","HAMPSHIRE AND ISLE OF WIGHT ICB",null,"QRL","HAMPSHIRE AND ISLE OF WIGHT ICB",null,{"$error":"#N/A"},"QOP","HAMPSHIRE AND THE ISLE OF WIGHT STP",null,"QRL","R1F","ISLE OF WIGHT NHS TRUST",null,null,null,"QRL","R1F","ISLE OF WIGHT NHS TRUST",null,"RX6","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",null,null,"RX6","IMPERIAL COLLEGE HEALTHCARE NHS TRUST"]
[null,null,null,null,null,null,"Percentage Negative","Percentage Positive","Mode Electronic Discharge",null,"QRV","NORTH WEST LONDON ICB",null,"QRV","NORTH WEST LONDON ICB",null,{"$error":"#N/A"},"QRL","INDEPENDENT SECTOR PROVIDERS",null,"QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",null,null,null,"QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",null,"RX7","ISLE OF WIGHT NHS TRUST",null,null,"RX7","ISLE OF WIGHT NHS TRUST"]
[null,null,null,null,null,null,"Very Good","Percentage Negative","Mode Paper Discharge",null,"QT1","NOTTINGHAM AND NOTTINGHAMSHIRE ICB",null,"QT1","NOTTINGHAM AND NOTTINGHAMSHIRE ICB",null,{"$error":"#N/A"},"QRV","NORTH LONDON PARTNERS IN HEALTH & CARE (STP)",null,"QT1","RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",null,null,null,"QT1","RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",null,"RX8","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",null,null,"RX8","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST"]
[null,null,null,null,"1 Very Good","2 Good","Good","Very Good","Mode Paper Home",null,"QU9","BUCKINGHAMSHIRE, OXFORDSHIRE AND BERKSHIRE WEST ICB",null,"QU9","BUCKINGHAMSHIRE, OXFORDSHIRE AND BERKSHIRE WEST ICB",null,{"$error":"#N/A"},"QT1","NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP)",null,"QU9","RYE","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST",null,null,null,"QU9","RYE","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST",null,"RX9","NORTH WEST AMBULANCE SERVICE NHS TRUST",null,null,"RX9","NORTH WEST AMBULANCE SERVICE NHS TRUST"]
[null,null,null,null,null,null,"Neither Good nor Poor","Good","Mode Telephone",null,"QUA","BLACK COUNTRY ICB",null,"QUA","BLACK COUNTRY ICB",null,{"$error":"#N/A"},"QU9","NOTTINGHAM AND NOTTINGHAMSHIRE HEALTH AND CARE STP",null,"QUA","RYA","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST",null,null,null,"QUA","RYA","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST",null,"RYA","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST",null,null,"RYA","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST"]
[null,null,null,null,null,null,"Poor","Neither Good nor Poor","Mode Online",null,"QUE","CAMBRIDGESHIRE AND PETERBOROUGH ICB",null,"QUE","CAMBRIDGESHIRE AND PETERBOROUGH ICB",null,{"$error":"#N/A"},"QUA","OUR HEALTHIER SOUTH EAST LONDON STP",null,"QUE","RYC","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST",null,null,null,"QUE","RYC","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST",null,"RYC","UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST",null,null,"RYC","UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST"]
[null,null,null,null,null,null,"Very Poor","Poor","Mode Other",null,"QWO","WEST YORKSHIRE ICB",null,"QWO","WEST YORKSHIRE ICB",null,{"$error":"#N/A"},"QUE","THE BLACK COUNTRY AND WEST BIRMINGHAM STP",null,"QWO","RX8","YORKSHIRE AMBULANCE SERVICE NHS TRUST",null,null,null,"QWO","RX8","YORKSHIRE AMBULANCE SERVICE NHS TRUST",null,"RYE","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST",null,null,"RYE","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST"]
[null,null,null,null,null,null,"Don't Know","Very Poor",null,null,"IS1","INDEPENDENT SECTOR PROVIDERS",null,"IS1","INDEPENDENT SECTOR PROVIDERS",null,{"$error":"#N/A"},"QWO","WEST YORKSHIRE AND HARROGATE HEALTH & CARE PARTNERSHIP (STP)",null,"IS1","8JR17","ERS MEDICAL",null,null,null,"IS1","8JR17","ERS MEDICAL",null,"RYJ","YORKSHIRE AMBULANCE SERVICE NHS TRUST",null,null,"RYJ","YORKSHIRE AMBULANCE SERVICE NHS TRUST"]
[null,null,null,null,null,null,null,"Don't Know"]