{"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":1,"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 2023",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,"2023-07-01","2023-07-01","2023-07-01","2023-06-26","2023-07-01","2023-06-26","2023-07-01","2023-06-26"]
[null,"Patient Transport Services","Total",12,330942,4584,4790,0.90946771378708546,0.87035490605427979,4.5375218150087257E-2,4.8225469728601256E-2]
[null,null,"NHS",11,245748,3389,3547,0.9141339628208911,0.86129123202706515,4.5441133077604015E-2,4.9055539892867213E-2]
[null,null,"IS",1,85194,1195,1243,0.89623430962343098,0.8962188254223652,4.5188284518828455E-2,4.5856798069187452E-2]

{"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)",4584,582964,0.90946771378708546,4.5375218150087257E-2,2459,1710,175,119,89,32]
[null,"England (excluding Independent Sector Providers)",3389,480476,0.9141339628208911,4.5441133077604015E-2,1713,1385,113,86,68,24]
[null,"Selection (excluding suppressed data)",{"$f":"IFERROR(SUBTOTAL(9,C13:C40),\"-\")","v":4584},{"$f":"IFERROR(SUBTOTAL(9,D13:D40),\"-\")","v":582964},{"$f":"IFERROR((G12+H12)/SUM(G12:L12),\"-\")","v":0.90946771378708546},{"$f":"IFERROR((J12+K12)/SUM(G12:L12),\"-\")","v":4.5375218150087257E-2},{"$f":"IFERROR(SUBTOTAL(9,G13:G40),\"-\")","v":2459},1710,175,119,89,32]
["QHM","NHS NORTH EAST AND NORTH CUMBRIA ICB",101,45794,0.98019801980198018,9.9009900990099011E-3,83,16,0,1,0,1]
["QKK","NHS SOUTH EAST LONDON ICB",504,23565,0.87896825396825395,2.1825396825396824E-2,90,353,40,4,7,10]
["QMJ","NHS NORTH CENTRAL LONDON ICB",250,1197,1,0,238,12,0,0,0,0]
["QOP","NHS GREATER MANCHESTER ICB",1115,113442,0.9282511210762332,3.6771300448430494E-2,894,141,29,8,33,10]
["QRL","NHS HAMPSHIRE AND ISLE OF WIGHT ICB",10,1450,1,0,10,0,0,0,0,0]
["QRV","NHS NORTH WEST LONDON ICB",1151,4509,0.90095569070373593,6.8635968722849702E-2,225,812,34,64,15,1]
["QT1","NHS NOTTINGHAM AND NOTTINGHAMSHIRE ICB",28,31109,0.8571428571428571,0.14285714285714285,21,3,0,0,4,0]
["QU9","NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BERKSHIRE WEST ICB",11,74813,0.81818181818181823,9.0909090909090912E-2,6,3,1,0,1,0]
["QUA","NHS BLACK COUNTRY ICB",22,71498,0.72727272727272729,0.13636363636363635,10,6,3,3,0,0]
["QUE","NHS CAMBRIDGESHIRE AND PETERBOROUGH ICB",52,38314,0.78846153846153844,0.17307692307692307,37,4,2,3,6,0]
["QWO","NHS WEST YORKSHIRE ICB",145,74785,0.92413793103448272,3.4482758620689655E-2,99,35,4,3,2,2]
["IS1","INDEPENDENT SECTOR PROVIDERS",1195,102488,0.89623430962343098,4.5188284518828455E-2,746,325,62,33,21,8]

{"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)",4584,582964,0.90946771378708546,4.5375218150087257E-2,2459,1710,175,119,89,32]
[null,null,"England (excluding Independent Sector Providers)",3389,480476,0.9141339628208911,4.5441133077604015E-2,1713,1385,113,86,68,24]
[null,null,"Selection (excluding suppressed data)",{"$f":"IFERROR(SUBTOTAL(9,D13:D40),\"-\")","v":4584},{"$f":"IFERROR(SUBTOTAL(9,E13:E40),\"-\")","v":582964},{"$f":"IFERROR((H12+I12)/SUM(H12:M12),\"-\")","v":0.90946771378708546},{"$f":"IFERROR((K12+L12)/SUM(H12:M12),\"-\")","v":4.5375218150087257E-2},{"$f":"IFERROR(SUBTOTAL(9,H13:H40),\"-\")","v":2459},1710,175,119,89,32]
["QHM","RX6","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",101,45794,0.98019801980198018,9.9009900990099011E-3,83,16,0,1,0,1]
["QKK","RJ1","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",504,23565,0.87896825396825395,2.1825396825396824E-2,90,353,40,4,7,10]
["QMJ","RRV","UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST",250,1197,1,0,238,12,0,0,0,0]
["QOP","RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST",1115,113442,0.9282511210762332,3.6771300448430494E-2,894,141,29,8,33,10]
["QRL","R1F","ISLE OF WIGHT NHS TRUST",10,1450,1,0,10,0,0,0,0,0]
["QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",1151,4509,0.90095569070373593,6.8635968722849702E-2,225,812,34,64,15,1]
["QT1","RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",28,31109,0.8571428571428571,0.14285714285714285,21,3,0,0,4,0]
["QU9","RYE","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST",11,74813,0.81818181818181823,9.0909090909090912E-2,6,3,1,0,1,0]
["QUA","RYA","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST",22,71498,0.72727272727272729,0.13636363636363635,10,6,3,3,0,0]
["QUE","RYC","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST",52,38314,0.78846153846153844,0.17307692307692307,37,4,2,3,6,0]
["QWO","RX8","YORKSHIRE AMBULANCE SERVICE NHS TRUST",145,74785,0.92413793103448272,3.4482758620689655E-2,99,35,4,3,2,2]
["IS1","8JR17","ERS MEDICAL",1195,102488,0.89623430962343098,4.5188284518828455E-2,746,325,62,33,21,8]

{"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)",4584,1147,59,1321,243,754,138,922]
[null,null,"England (excluding Independent Sector Providers)",3389,1147,59,126,243,754,138,922]
[null,null,"Selection (excluding suppressed data)",{"$f":"IFERROR(SUBTOTAL(9,D13:D37),\"-\")","v":4584},1147,59,1321,243,754,138,922]
["QHM","RX6","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",101,0,0,0,92,0,9,0]
["QKK","RJ1","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",504,0,0,0,0,504,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",1115,1114,0,1,0,0,0,0]
["QRL","R1F","ISLE OF WIGHT NHS TRUST",10,0,0,10,0,0,0,0]
["QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",1151,33,40,115,0,0,69,894]
["QT1","RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",28,0,0,0,0,0,0,28]
["QU9","RYE","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST",11,0,0,0,0,0,11,0]
["QUA","RYA","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST",22,0,19,0,0,0,3,0]
["QUE","RYC","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST",52,0,0,0,12,0,40,0]
["QWO","RX8","YORKSHIRE AMBULANCE SERVICE NHS TRUST",145,0,0,0,139,0,6,0]
["IS1","8JR17","ERS MEDICAL",1195,0,0,1195,0,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,1,"N/A","N/A","ICB Code","ICB Code","ICB Code",null,"QHM","NORTH EAST AND NORTH CUMBRIA ICB",null,"IS1","BLACK COUNTRY ICB",null,null,"IS1","BLACK COUNTRY ICB",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,"QHM","BUCKINGHAMSHIRE, OXFORDSHIRE AND BERKSHIRE WEST ICB",null,null,"QHM","BUCKINGHAMSHIRE, OXFORDSHIRE AND BERKSHIRE WEST ICB",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,"QKK","CAMBRIDGESHIRE AND PETERBOROUGH ICB",null,null,"QKK","CAMBRIDGESHIRE AND PETERBOROUGH ICB",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,"QMJ","GREATER MANCHESTER ICB",null,null,"QMJ","GREATER MANCHESTER ICB",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,"QOP","HAMPSHIRE AND ISLE OF WIGHT ICB",null,null,"QOP","HAMPSHIRE AND ISLE OF WIGHT ICB",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,"QRL","INDEPENDENT SECTOR PROVIDERS",null,null,"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,"QRV","NORTH CENTRAL LONDON ICB",null,null,"QRV","NORTH CENTRAL LONDON ICB",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,"QT1","NORTH EAST AND NORTH CUMBRIA ICB",null,null,"QT1","NORTH EAST AND NORTH CUMBRIA ICB",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,"QU9","NORTH WEST LONDON ICB",null,null,"QU9","NORTH WEST LONDON ICB",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,"QUA","NOTTINGHAM AND NOTTINGHAMSHIRE ICB",null,null,"QUA","NOTTINGHAM AND NOTTINGHAMSHIRE ICB",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,"QUE","SOUTH EAST LONDON ICB",null,null,"QUE","SOUTH EAST LONDON ICB",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,"QWO","WEST YORKSHIRE ICB",null,null,"QWO","WEST YORKSHIRE ICB",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"]