{"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 - September 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-09-01","2022-09-01","2022-09-01","2022-08-27","2022-09-01","2022-08-27","2022-09-01","2022-08-27"]
[null,"Patient Transport Services","Total",12,287350,4066,4467,0.83644859813084116,0.82561002910230585,7.6979832759468764E-2,8.4396686814416838E-2]
[null,null,"NHS",11,214701,2944,3376,0.80264945652173914,0.79798578199052128,9.6127717391304351E-2,9.9229857819905218E-2]
[null,null,"IS",1,73003,1122,1091,0.92513368983957223,0.91109074243813015,2.6737967914438502E-2,3.84967919340055E-2]

{"sheet":"PTS ICB","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"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)",4066,574141,0.83644859813084116,7.6979832759468764E-2,2116,1285,330,228,85,22]
[null,"England (excluding Independent Sector Providers)",2944,476270,0.80264945652173914,9.6127717391304351E-2,1361,1002,285,213,70,13]
[null,"Selection (excluding suppressed data)",{"$f":"IFERROR(SUBTOTAL(9,C13:C40),\"-\")","v":4066},{"$f":"IFERROR(SUBTOTAL(9,D13:D40),\"-\")","v":574141},{"$f":"IFERROR((G12+H12)/SUM(G12:L12),\"-\")","v":0.83644859813084116},{"$f":"IFERROR((J12+K12)/SUM(G12:L12),\"-\")","v":7.6979832759468764E-2},{"$f":"IFERROR(SUBTOTAL(9,G13:G40),\"-\")","v":2116},1285,330,228,85,22]
["QHM","NORTH EAST AND NORTH CUMBRIA ICB",108,45664,0.91666666666666663,8.3333333333333329E-2,80,19,0,2,7,0]
["QKK","SOUTH EAST LONDON ICB",228,22862,0.92982456140350878,1.3157894736842105E-2,145,67,13,2,1,0]
["QOP","GREATER MANCHESTER ICB",1084,107599,0.91143911439114389,5.2583025830258305E-2,880,108,26,26,31,13]
["QRL","HAMPSHIRE AND ISLE OF WIGHT ICB",16,1282,1,0,16,0,0,0,0,0]
["QRV","NORTH WEST LONDON ICB",1417,4280,0.68383909668313336,0.14467184191954835,180,789,243,182,23,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",8,79187,1,0,8,0,0,0,0,0]
["QUA","BLACK COUNTRY ICB",1,74603,"*","*",1,0,0,0,0,0]
["QUE","CAMBRIDGESHIRE AND PETERBOROUGH ICB",38,41893,0.89473684210526316,7.8947368421052627E-2,23,11,1,0,3,0]
["QWO","WEST YORKSHIRE ICB",36,75117,0.88888888888888884,5.5555555555555552E-2,24,8,2,0,2,0]
["IS1","INDEPENDENT SECTOR PROVIDERS",1122,97871,0.92513368983957223,2.6737967914438502E-2,755,283,45,15,15,9]

{"sheet":"PTS Org","index":3,"n_rows":23,"n_cols":13,"rows_kept":23,"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)",4066,574141,0.83644859813084116,7.6979832759468764E-2,2116,1285,330,228,85,22]
[null,null,"England (excluding Independent Sector Providers)",2944,476270,0.80264945652173914,9.6127717391304351E-2,1361,1002,285,213,70,13]
[null,null,"Selection (excluding suppressed data)",{"$f":"IFERROR(SUBTOTAL(9,D13:D40),\"-\")","v":4066},{"$f":"IFERROR(SUBTOTAL(9,E13:E40),\"-\")","v":574141},{"$f":"IFERROR((H12+I12)/SUM(H12:M12),\"-\")","v":0.83640836408364083},{"$f":"IFERROR((K12+L12)/SUM(H12:M12),\"-\")","v":7.6998769987699875E-2},{"$f":"IFERROR(SUBTOTAL(9,H13:H40),\"-\")","v":2115},1285,330,228,85,22]
["QHM","RX6","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",108,45664,0.91666666666666663,8.3333333333333329E-2,80,19,0,2,7,0]
["QKK","RJ1","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",228,22862,0.92982456140350878,1.3157894736842105E-2,145,67,13,2,1,0]
["QOP","RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST",1084,107599,0.91143911439114389,5.2583025830258305E-2,880,108,26,26,31,13]
["QRL","R1F","ISLE OF WIGHT NHS TRUST",16,1282,1,0,16,0,0,0,0,0]
["QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",1417,4280,0.68383909668313336,0.14467184191954835,180,789,243,182,23,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",8,79187,1,0,8,0,0,0,0,0]
["QUA","RYA","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST",1,74603,"*","*","*","*","*","*","*","*"]
["QUE","RYC","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST",38,41893,0.89473684210526316,7.8947368421052627E-2,23,11,1,0,3,0]
["QWO","RX8","YORKSHIRE AMBULANCE SERVICE NHS TRUST",36,75117,0.88888888888888884,5.5555555555555552E-2,24,8,2,0,2,0]
["IS1","8JR17","ERS MEDICAL",1122,97871,0.92513368983957223,2.6737967914438502E-2,755,283,45,15,15,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)",4066,1085,18,1366,137,234,327,899]
[null,null,"England (excluding Independent Sector Providers)",2944,1085,18,244,137,234,327,899]
[null,null,"Selection (excluding suppressed data)",{"$f":"IFERROR(SUBTOTAL(9,D13:D37),\"-\")","v":4066},1085,18,1366,137,234,318,899]
["QHM","RX6","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",108,0,0,0,104,0,4,0]
["QKK","RJ1","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",228,0,0,0,0,228,0,0]
["QMJ","RRV","UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST",0,0,0,0,0,0,0,0]
["QOP","RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST",1084,1083,0,1,0,0,0,0]
["QRL","R1F","ISLE OF WIGHT NHS TRUST",16,0,0,16,0,0,0,0]
["QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",1417,2,18,227,0,0,274,896]
["QT1","RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",8,"*","*","*","*","*","*","*"]
["QU9","RYE","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST",8,0,0,0,0,0,8,0]
["QUA","RYA","WEST MIDLANDS AMBULANCE SERVICE UNIVERSITY NHS FOUNDATION TRUST",1,"*","*","*","*","*","*","*"]
["QUE","RYC","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST",38,0,0,0,2,6,27,3]
["QWO","RX8","YORKSHIRE AMBULANCE SERVICE NHS TRUST",36,0,0,0,31,0,5,0]
["IS1","8JR17","ERS MEDICAL",1122,0,0,1122,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,{"$error":"#N/A"},"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,{"$error":"#N/A"},"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,"8JR17","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,{"$error":"#N/A"},"QKK","CAMBRIDGESHIRE AND PETERBOROUGH ICB",null,"QOP","RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST",null,null,null,"QOP","RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST",null,"RJ1","ERS MEDICAL",null,null,"R1F","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"},"QOP","GREATER MANCHESTER ICB",null,"QRL","R1F","ISLE OF WIGHT NHS TRUST",null,null,null,"QRL","R1F","ISLE OF WIGHT NHS TRUST",null,"RX6","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",null,null,"RJ1","ERS MEDICAL"]
["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"},"QRL","HAMPSHIRE AND ISLE OF WIGHT ICB",null,"QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",null,null,null,"QRV","RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",null,"RX7","IMPERIAL COLLEGE HEALTHCARE NHS TRUST",null,null,"RX6","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST"]
[null,null,null,null,null,null,"Percentage Negative","Percentage Positive","Mode Electronic Discharge",null,"QRV","NORTH WEST LONDON ICB",null,"QRV","INDEPENDENT SECTOR PROVIDERS",null,{"$error":"#N/A"},"QRV","INDEPENDENT SECTOR PROVIDERS",null,"QT1","RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",null,null,null,"QT1","RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST",null,"RX8","ISLE OF WIGHT NHS TRUST",null,null,"RX7","IMPERIAL COLLEGE HEALTHCARE NHS TRUST"]
[null,null,null,null,null,null,"Very Good","Percentage Negative","Mode Paper Discharge",null,"QT1","NOTTINGHAM AND NOTTINGHAMSHIRE ICB",null,"QT1","NORTH EAST AND NORTH CUMBRIA ICB",null,{"$error":"#N/A"},"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 EAST AMBULANCE SERVICE NHS FOUNDATION TRUST",null,null,"RX8","ISLE OF WIGHT NHS 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","NORTH WEST LONDON ICB",null,{"$error":"#N/A"},"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","NORTH WEST AMBULANCE SERVICE NHS TRUST",null,null,"RX9","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST"]
[null,null,null,null,null,null,"Neither Good nor Poor","Good","Mode Telephone",null,"QUA","BLACK COUNTRY ICB",null,"QUA","NOTTINGHAM AND NOTTINGHAMSHIRE ICB",null,{"$error":"#N/A"},"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","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST",null,null,"RYA","NORTH WEST AMBULANCE SERVICE NHS TRUST"]
[null,null,null,null,null,null,"Poor","Neither Good nor Poor","Mode Online",null,"QUE","CAMBRIDGESHIRE AND PETERBOROUGH ICB",null,"QUE","SOUTH EAST LONDON ICB",null,{"$error":"#N/A"},"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,"RYC","SOUTH CENTRAL AMBULANCE SERVICE 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"},"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,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,"IS1","8JR17","ERS MEDICAL",null,null,null,null,null,"RYJ","YORKSHIRE AMBULANCE SERVICE NHS TRUST"]
[null,null,null,null,null,null,null,"Don't Know"]