{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Info","Grant Summary","Grant Performance","Participant Satisfaction","Self Assessment","Grant Compliance","Star Rating Calculations","Control_Variables","Back_Sheet","Data for extraction"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":71,"comments":1,"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":"Info","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[22,2,22,10],[4,1,4,8]]}
[]
[null,"Employability Performance Rating Calculator"]
[]
[null,"Grant Summary"]
[null,"Contains the options to load in the key information on the provider's grant to allow the setup of the calculator."]
[]
[null,"Grant Performance"]
[null,"Contains tables to enter outcomes for performance targets."]
[]
[null,"Participant Satisfaction"]
[null,"Contains tables to enter record of responses of participant satisfaction."]
[]
[null,"Quality Self-Assessment"]
[null,"Contains tables to enter record of quality of the grant service as assessed by the contractor."]
[]
[null,"Grant Compliance"]
[null,"Contains tables to enter record of grant compliance as assessed by the grant manager."]
[]
[null,"Star Rating Calculations"]
[null,"Contains all the calculations for the components of the rating and calculates the final star rating"]
[]
[null,"Finding Help?"]
[null,null,"Through out the calculator you will see a number of info icons. When clicked, these icons provide prompts to useful information about the current section of the calculator."]
[]
[null,"Further guidance can also be found in the main provider guidance:",null,null,null,null,null,null,"http://data.london.gov.uk/dataset/lepr-esf-2014-20  "]
[]
[null,"(For funders only)"]

{"sheet":"Grant Summary","index":1,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,1,35,1],[34,2,35,2],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[20,2,20,4],[19,2,19,4],[34,3,34,5]]}
[null,null,"Back to Info"]
[null,"Grant Summary"]
[null,"Contains the options to load in the key information on the provider's grant to allow the setup of the calculator"]
[]
[null,"Provider: ",null,"Grant:"]
[]
[]
[null,"Summary Grant Information"]
[]
[null,"Year of Calculator","2018/19"]
[]
[null,"Funder","Test Funder"]
[null,"Grant Name","Test Grant Name"]
[null,"Prime/Sub","Prime"]
[null,"Number of Sub-contractors",5]
[null,"Grant start date",2017]
[null,"Year of grant",1]
[null,"Target Group","Test Target Group"]
[null,"Grant Value",200000]
[null,"Grant Description","Test Grant Description"]
[null,"Funding Round and Spec","ESF 2014-20 "]
[]
[null,"Areas of Operation:"]
[null,"Barking & Dagenham","City of London","Hammersmith & Fulham","Islington","Newham","Waltham Forest"]
[null,"Barnet","Croydon","Haringey","Kensington & Chelsea","Redbridge","Wandsworth"]
[null,"Bexley","Ealing","Harrow","Kingston","Richmond","Westminster"]
[null,"Brent","Enfield","Havering","Lambeth","Southwark"]
[null,"Bromley","Greenwich","Hillingdon","Lewisham","Sutton"]
[null,"Camden","Hackney","Hounslow","Merton","Tower Hamlets"]
[]
[null,"Grant Performance Targets"]
[]
[null,"Diversity Targets applicable?","Yes"]
[null,"Number of Targets",2]
[null,"Target Name","Annual Target","Diversity Targets"]
[null,null,null,"% BAME","% Disability ","% Women"]
[null,"Starts",250,20,20,60]
[null,"Jobs",150,20,20,60]

{"sheet":"Grant Performance","index":2,"n_rows":19,"n_cols":22,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,1,18,2],[14,3,18,4],[14,5,14,6],[8,5,8,6],[1,1,1,2],[2,1,2,2],[1,3,1,4],[2,3,2,4],[6,3,6,4],[8,1,12,2],[8,3,12,4]]}
[]
[null,"Provider:",null,"Test Provider"]
[null,"Grant:",null,"Test Grant Name"]
[null,"Back to Info"]
[null,"Grant Performance"]
[null,"Contains tables to enter outcomes for performance targets"]
[null,null,null,"Performance measure",null,"Target Category",null,null,"APR 2018","MAY 2018","JUN 2018","JUL 2018","AUG 2018","SEP 2018","OCT 2018","NOV 2018","DEC 2018","JAN 2019","FEB 2019","MAR 2019","Annual Total","% of Target"]
[]
[null,"Primary Outcome",null,"Starts",null,"Annual Targets",null,"Monthly",20,20,20,20,20,20,20,20,20,20,25,25]
[null,null,null,null,null,"Grant",250,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(INDEX(Target_Outcomes_1,1,0))","v":0},{"$f":"$U$10/$G$10","v":0}]
[null,null,null,null,null,"BAME",20,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_1,2,0))/SUM(INDEX(Target_Outcomes_1,1,0)),0)","v":0},{"$f":"$U$11/$G$11*100","v":0}]
[null,null,null,null,null,"Disability",20,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_1,3,0))/SUM(INDEX(Target_Outcomes_1,1,0)),0)","v":0},{"$f":"$U$12/$G$12*100","v":0}]
[null,null,null,null,null,"Women",60,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_1,4,0))/SUM(INDEX(Target_Outcomes_1,1,0)),0)","v":0},{"$f":"$U$13/$G$13*100","v":0}]
[]
[null,"Outcome 2",null,"Jobs",null,"Annual Targets",null,"Monthly",10,10,10,10,10,10,15,15,15,15,15,15]
[null,null,null,null,null,"Grant",150,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(INDEX(Target_Outcomes_2,1,0))","v":0},{"$f":"IFERROR($U$16/$G$16,0)","v":0}]
[null,null,null,null,null,"BAME",20,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,2,0))/SUM(INDEX(Target_Outcomes_2,1,0)),0)","v":0},{"$f":"IFERROR($U$17/$G$17*100,0)","v":0}]
[null,null,null,null,null,"Disability",20,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,3,0))/SUM(INDEX(Target_Outcomes_2,1,0)),0)","v":0},{"$f":"IFERROR($U$18/$G$18*100,0)","v":0}]
[null,null,null,null,null,"Women",60,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,4,0))/SUM(INDEX(Target_Outcomes_2,1,0)),0)","v":0},{"$f":"IFERROR($U$19/$G$19*100,0)","v":0}]

{"sheet":"Participant Satisfaction","index":3,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":false,"merged":[[7,1,7,6],[22,1,22,6],[37,1,37,6],[52,1,52,6]]}
[]
[null,"Provider:","Test Provider"]
[null,"Grant:","Test Grant Name"]
[null,"Back to Info"]
[null,"Participant Satisfaction"]
[null,"Contains tables to enter record of responses of participant satisfaction."]
[]
[null,"Quarter 1 - APR-JUN 2018"]
[null,"Question","Number of very positive responses","Number of positive responses","Number of neutral responses","Number of negative responses","Number of very negative responses"]
[null,"1a"]
[null,"1b"]
[null,"1c"]
[null,"1d"]
[null,"1e"]
[null,"2a"]
[null,"2b"]
[null,"2c"]
[null,"2d"]
[null,"2e"]
[null,"2f"]
[null,3]
[]
[null,"Quarter 2 - JUL-SEP 2018"]
[null,"Question","Number of very positive responses","Number of positive responses","Number of neutral responses","Number of negative responses","Number of very negative responses"]
[null,"1a"]
[null,"1b"]
[null,"1c"]
[null,"1d"]
[null,"1e"]
[null,"2a"]
[null,"2b"]
[null,"2c"]
[null,"2d"]
[null,"2e"]
[null,"2f"]
[null,3]
[]
[null,"Quarter 3 - OCT-DEC 2018"]
[null,"Question","Number of very positive responses","Number of positive responses","Number of neutral responses","Number of negative responses","Number of very negative responses"]
[null,"1a"]
[null,"1b"]
[null,"1c"]
[null,"1d"]
[null,"1e"]
[null,"2a"]
[null,"2b"]
[null,"2c"]
[null,"2d"]
[null,"2e"]
[null,"2f"]
[null,3]
[]
[null,"Quarter 4 - JAN-MAR 2019"]
[null,"Question","No of very positive responses","No of positive responses","No of neutral responses","No of negative responses","No of very negative responses"]
[null,"1a"]
[null,"1b"]
[null,"1c"]
[null,"1d"]
[null,"1e"]
[null,"2a"]
[null,"2b"]
[null,"2c"]
[null,"2d"]
[null,"2e"]
[null,"2f"]
[null,3]

{"sheet":"Self Assessment","index":4,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,1,8,5],[12,1,12,5],[15,1,15,5],[22,1,22,5]]}
[]
[null,"Provider:","Test Provider"]
[null,"Grant:","Test Grant Name"]
[null,"Back to Info"]
[null,"Quality Self-Assessment"]
[null,"Contains tables to enter record of quality of the grant service as assessed by the contractor."]
[]
[null,"Question","In place?\nF = fully \nFI = fully in place but needs some improvement\nP = partially in place\nN = not in place/being developed\n","Evidence or examples of current practice","Assessment of level of performance\n\nRate 1 –  4\n1 = Outstanding; 2= Good; 3 = Satisfactory; 4 = Inadequate","Priority for action?\n\nRank 1 – 3\n1 = high priority"]
[null,"Quality of provision/meeting participant needs"]
[null,"1. There is a comprehensive induction  for all participants "]
[null,"2. Participants receive appropriate advice and guidance on starting and on completion of participation in the service"]
[null,"3.  Progress reviews are used effectively with appropriate targets being set together with the participant, to assist progression and achievement of goals"]
[]
[null,"4.  Effectiveness is regularly monitored and evaluated against the aims and objectives of the service to ensure that it is responsive to customer needs and local priorities"]
[null,"5.  An effective quality assurance process is embedded throughout the organisation"]
[null,"Leadership, management and infrastructure "]
[null,"6.  There is a clear vision and associated aims and objectives for the organisation with a strategic plan/business plan/development plan in place that is reviewed on a regular basis"]
[null,"7. An engagement and outreach strategy is in place and reviewed regularly"]
[null,"8.  Sub delivery partners are, effectively managed to ensure that the needs of Participants are met  NB: if no provision is sub granted please insert '0' in column E."]
[null,"9.  Networks with key stakeholders are effectively used, managed, maintained and reviewed to ensure that the service meets the needs of Participants and employers are met and promotes social cohesion"]
[null,"10. There is a commitment to continuous professional development and staff are appropriately trained and experienced to provide the breadth of skills and interventions to support and progress Participants"]
[null,"11. Equality and Diversity are effectively promoted, discrimination tackled and reasonable adjustments provided for Participants and staff"]
[null,"Safety and Safe Practice"]
[null,"12. To ensure compliance with relevant legislation and good practice to safeguard and protect participants"]

{"sheet":"Grant Compliance","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,1,8,1],[7,2,8,2],[7,3,8,3]]}
[]
[null,"Provider:","Test Provider"]
[null,"Grant:","Test Grant Name"]
[null,"Back to Info"]
[null,"Grant Compliance"]
[null,"Contains tables to enter record of grant compliance as assessed by the grant manager."]
[]
[null,"A. Indicator","B. Assessment criteria","C. Guidance for rating","D. Rating          (1 - 10)","E. Comments"]
[null,null,null,null,null,"(please insert)"]
[null,"Variance of forecast from profile: annual RAG rating based on the variation between output forecasts and actual outputs.","A RAG assessment should be given using the following guidelines:\n- Provider always forecasts their outputs accurately = Green.\n- Provider usually forecasts their outputs accurately = Amber.\n- Provider rarely forecasts their outputs accurately = Red ","Red =  1 to 3 points\nAmber = 4 to 7 points\nGreen = 8 to 10 points\n"]
[null,"Timeliness of claim: annual RAG rating based on date claims are submitted","A RAG assessment should be given using the following guidelines:\n-  Provider always submits their claim on time = Green\n-  Provider usually submits their claim on time = Amber\n-  Provider rarely submits their claim on time = Red","Red =  1 to 3 points\nAmber = 4 to 7 points\nGreen = 8 to 10 points"]
[null,"Accuracy of claim and associated returns:  annual RAG rating based on the accuracy of claims and Progress Reports","A RAG assessment should be given using the following guidelines: \n-  Provider always returns accurate Claims and Project Progress Reports = Green\n-  Provider usually returns accurate Claims and Project Progress Reports = Amber\n-  Provider rarely returns accurate Claims and Project Progress Reports = Red.","Red =  1 to 3 points\nAmber = 4 to 7 points\nGreen = 8 to 10 points"]
[null,"Responsiveness: annual RAG rating based upon timeliness of responses to funder’s requests for information, including Management Information, Action Plans, and timely completion of agreed actions","A RAG assessment should be given using the following \n-  Requests are always addressed in the timescale specified = Green\n-  Requests are usually addressed in the timescale specified = Amber\n-  Requests are rarely addressed in the timescale specified, = Red","Red =  1 to 3 points\nAmber = 4 to 7 points\nGreen = 8 to 10 points"]
[null,"Proactive management of business Risk:  Does the project identify and update risks?","A RAG assessment should be given using the following guidelines: \n-  Risks are always identified and sufficient contingencies identified = Green\n-  Risks are usually identified and sufficient contingencies identified = Amber\n-  Risks are identified or sufficient contingencies identified = Red","Red =  1 to 3 points\nAmber = 4 to 7 points\nGreen = 8 to 10 points"]

{"sheet":"Star Rating Calculations","index":6,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[16,7,17,13],[16,5,17,6],[19,2,20,4],[19,5,19,13],[20,5,20,7],[20,8,20,10],[20,11,20,13],[14,1,14,5],[8,1,9,1],[10,1,12,1],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[1,2,1,3],[2,2,2,3],[7,9,7,13],[12,2,12,5],[13,2,13,5]]}
[]
[null,"Provider:","Test Provider"]
[null,"Grant:","Test Grant Name"]
[null,"Back to Info"]
[null,"Star Rating Calculations"]
[null,"Contains all the calculations for the components of the rating and calculates the final star rating"]
[]
[null,"KPA","Indicator",null,null,null,"Star rating points","Total available",null,"Star rating guidance"]
[null,"Grant performance","Delivery against grant targets",null,null,null,{"$f":"SUM(INDEX(PerfomCalcTable,0,4))","v":0},48,null,"4 stars",87.5,"-",100,"points"]
[null,null,"Delivery against grant diversity targets",null,null,null,{"$f":"SUM(INDEX(PerfomCalcTable,0,7),INDEX(PerfomCalcTable,0,10),INDEX(PerfomCalcTable,0,13))","v":0},12,null,"3 stars",75,"-",87.4,"points"]
[null,"Quality","Conversion rate for positive outcomes",null,null,null,{"$f":"J27","v":0},12,null,"2 stars",62.5,"-",74.900000000000006,"points"]
[null,null,"Self assessment of quality",null,null,null,{"$f":"SUM(D40:D51)","v":0},9,null,"1 star",40,"-",62.4,"points"]
[null,null,"Customer satisfaction",null,null,null,{"$f":"IFERROR(H13*E36/(D36*4),0)","v":0},9,null,"0 star",0,"-",39.9,"points"]
[null,"Grant compliance","Grant compliance",null,null,null,{"$f":"SUM(D55:D59)","v":0},10]
[null,"Total Star Rating points",null,null,null,null,{"$f":"SUM(G9:G14)","v":0}]
[]
[null,"Rating:",null,null,null,"Comments on Rating performance"]
[]
[null,"Grant Performance"]
[null,null,"Delivery against grant targets",null,null,"Delivery against grant diversity targets"]
[null,null,null,null,null,"BAME",null,null,"Disabled",null,null,"Women"]
[null,"Target","Total pts available","% Delivery ","Star rating points","Total pts available","% Delivery ","Star rating points","Total pts available","% Delivery ","Star rating points","Total pts available","% Delivery ","Star rating points"]
[null,"Starts",24,{"$f":"SUM(INDEX(Target_Outcomes_1,1,0))/VLOOKUP(\"Starts\",PerformTargetTable,2,FALSE)","v":0},{"$f":"IF(INDEX(PerfomCalcTable,1,3)<1,INDEX(PerfomCalcTable,1,3)* INDEX(PerfomCalcTable,1,2),INDEX(PerfomCalcTable,1,2))","v":0},2,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_1,2,0))/SUM(INDEX(Target_Outcomes_1,1,0))*100/VLOOKUP(\"Starts\",PerformTargetTable,3,FALSE),0)","v":0},{"$f":"IF(INDEX(PerfomCalcTable,1,6)<1,INDEX(PerfomCalcTable,1,6)* INDEX(PerfomCalcTable,1,5),INDEX(PerfomCalcTable,1,5))","v":0},2,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_1,3,0))/SUM(INDEX(Target_Outcomes_1,1,0))*100/VLOOKUP(\"Starts\",PerformTargetTable,4,FALSE),0)","v":0},{"$f":"IF(INDEX(PerfomCalcTable,1,9)<1,INDEX(PerfomCalcTable,1,9)* INDEX(PerfomCalcTable,1,8),INDEX(PerfomCalcTable,1,8))","v":0},2,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_1,4,0))/SUM(INDEX(Target_Outcomes_1,1,0))*100/VLOOKUP(\"Starts\",PerformTargetTable,5,FALSE),0)","v":0},{"$f":"IF(INDEX(PerfomCalcTable,1,12)<1,INDEX(PerfomCalcTable,1,12)* INDEX(PerfomCalcTable,1,11),INDEX(PerfomCalcTable,1,11))","v":0}]
[null,"Jobs",24,{"$f":"SUM(INDEX(Target_Outcomes_2,1,0))/VLOOKUP(\"Jobs\",PerformTargetTable,2,FALSE)","v":0},{"$f":"IF(INDEX(PerfomCalcTable,2,3)<1,INDEX(PerfomCalcTable,2,3)* INDEX(PerfomCalcTable,2,2),INDEX(PerfomCalcTable,2,2))","v":0},2,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,2,0))/SUM(INDEX(Target_Outcomes_2,1,0))*100/VLOOKUP(\"Jobs\",PerformTargetTable,3,FALSE),0)","v":0},{"$f":"IF(INDEX(PerfomCalcTable,2,6)<1,INDEX(PerfomCalcTable,2,6)* INDEX(PerfomCalcTable,2,5),INDEX(PerfomCalcTable,2,5))","v":0},2,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,3,0))/SUM(INDEX(Target_Outcomes_2,1,0))*100/VLOOKUP(\"Jobs\",PerformTargetTable,4,FALSE),0)","v":0},{"$f":"IF(INDEX(PerfomCalcTable,2,9)<1,INDEX(PerfomCalcTable,2,9)* INDEX(PerfomCalcTable,2,8),INDEX(PerfomCalcTable,2,8))","v":0},2,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,4,0))/SUM(INDEX(Target_Outcomes_2,1,0))*100/VLOOKUP(\"Jobs\",PerformTargetTable,5,FALSE),0)","v":0},{"$f":"IF(INDEX(PerfomCalcTable,2,12)<1,INDEX(PerfomCalcTable,2,12)* INDEX(PerfomCalcTable,2,11),INDEX(PerfomCalcTable,2,11))","v":0}]
[]
[null,"Primary Outcome","Target number of starts","Actual number of starts","Target Outcomes","Actual Outcomes","Target conversion rate","Actual conversion rate","Actual  rate minus target rate","Total Star Rating points"]
[null,"Starts",{"$f":"VLOOKUP(\"Starts\",PerformTargetTable,2,FALSE)","v":250},{"$f":"VLOOKUP(\"Starts\",PerfomCalcTable,3,FALSE)*INDEX(ConversionCalcTable,1,2)","v":0},{"$f":"VLOOKUP(\"Starts\",PerformTargetTable,2,FALSE)","v":250},{"$f":"VLOOKUP(\"Starts\",PerfomCalcTable,3,FALSE)*INDEX(ConversionCalcTable,1,4)","v":0},{"$f":"IF(C27<>0,E27/C27,0)","v":1},{"$f":"IF(D27<>0,F27/D27,0)","v":0},{"$f":"H27-G27","v":-1},{"$f":"IF(I27>0,IF(I27<0.15,I27*100/1.25,ConversionWeight),0)","v":0}]
[]
[null,"Participant Satisfaction"]
[null,"Responses","Points per response","No of responses","Points Scored"]
[null,"Very positive",4,{"$f":"SUM(INDEX(OFFSET(ClientSatisfQ1,2,1,ROWS(ClientSatisfQ1)-2),0,1),INDEX(OFFSET(ClientSatisfQ2,2,1,ROWS(ClientSatisfQ2)-2),0,1),INDEX(OFFSET(ClientSatisfQ3,2,1,ROWS(ClientSatisfQ3)-2),0,1),INDEX(OFFSET(ClientSatisfQ4,2,1,ROWS(ClientSatisfQ4)-2),0,1))","v":0},{"$f":"D31*C31","v":0}]
[null,"Positive",3,{"$f":"SUM(INDEX(OFFSET(ClientSatisfQ1,2,1,ROWS(ClientSatisfQ1)-2),0,2),INDEX(OFFSET(ClientSatisfQ2,2,1,ROWS(ClientSatisfQ2)-2),0,2),INDEX(OFFSET(ClientSatisfQ3,2,1,ROWS(ClientSatisfQ3)-2),0,2),INDEX(OFFSET(ClientSatisfQ4,2,1,ROWS(ClientSatisfQ4)-2),0,2))","v":0},{"$f":"D32*C32","v":0}]
[null,"Neutral ",2,{"$f":"SUM(INDEX(OFFSET(ClientSatisfQ1,2,1,ROWS(ClientSatisfQ1)-2),0,3),INDEX(OFFSET(ClientSatisfQ2,2,1,ROWS(ClientSatisfQ2)-2),0,3),INDEX(OFFSET(ClientSatisfQ3,2,1,ROWS(ClientSatisfQ3)-2),0,3),INDEX(OFFSET(ClientSatisfQ4,2,1,ROWS(ClientSatisfQ4)-2),0,3))","v":0},0]
[null,"Negative",1,{"$f":"SUM(INDEX(OFFSET(ClientSatisfQ1,2,1,ROWS(ClientSatisfQ1)-2),0,4),INDEX(OFFSET(ClientSatisfQ2,2,1,ROWS(ClientSatisfQ2)-2),0,4),INDEX(OFFSET(ClientSatisfQ3,2,1,ROWS(ClientSatisfQ3)-2),0,4),INDEX(OFFSET(ClientSatisfQ4,2,1,ROWS(ClientSatisfQ4)-2),0,4))","v":0},0]
[null,"Very negative",0,{"$f":"SUM(INDEX(OFFSET(ClientSatisfQ1,2,1,ROWS(ClientSatisfQ1)-2),0,5),INDEX(OFFSET(ClientSatisfQ2,2,1,ROWS(ClientSatisfQ2)-2),0,5),INDEX(OFFSET(ClientSatisfQ3,2,1,ROWS(ClientSatisfQ3)-2),0,5),INDEX(OFFSET(ClientSatisfQ4,2,1,ROWS(ClientSatisfQ4)-2),0,5))","v":0},0]
[null,"Total",null,{"$f":"SUM(D31:D35)","v":0},{"$f":"IF(AND(F27*0.6<D36/12,F27>0),SUM(E31:E35),0)","v":0}]
[]
[null,"Self Assessment"]
[null,"Questions","Rating","Points","Total pts available"]
[null,1,{"$f":"OFFSET(QSAFQ1,,3)","v":0},{"$f":"IF(C40<>0,(5-C40)/4*E40,0)","v":0},{"$f":"QSAFPointsAvailable/ROWS(QSAFPointAvail)","v":0.75}]
[null,2,{"$f":"OFFSET(QSAFQ2,,3)","v":0},{"$f":"IF(C41<>0,(5-C41)/4*E41,0)","v":0},0.75]
[null,3,{"$f":"OFFSET(QSAFQ3,,3)","v":0},0,0.75]
[null,4,{"$f":"OFFSET(QSAFQ4,,3)","v":0},0,0.75]
[null,5,{"$f":"OFFSET(QSAFQ5,,3)","v":0},0,0.75]
[null,6,{"$f":"OFFSET(QSAFQ6,,3)","v":0},0,0.75]
[null,7,{"$f":"OFFSET(QSAFQ7,,3)","v":0},0,0.75]
[null,8,{"$f":"OFFSET(QSAFQ8,,3)","v":0},0,0.75]
[null,9,{"$f":"OFFSET(QSAFQ9,,3)","v":0},0,0.75]
[null,10,{"$f":"OFFSET(QSAFQ10,,3)","v":0},0,0.75]
[null,11,{"$f":"OFFSET(QSAFQ11,,3)","v":0},0,0.75]
[null,12,{"$f":"OFFSET(QSAFQ12,,3)","v":0},0,0.75]
[]
[null,"Grant Compliance"]
[null,"Questions","Rating","Points","Total pts available"]
[null,1,{"$f":"'Grant Compliance'!E10","v":0},{"$f":"C55*0.2","v":0},{"$f":"$H$14/ROWS($E$55:$E$59)","v":2}]
[null,2,{"$f":"'Grant Compliance'!E11","v":0},{"$f":"C56*0.2","v":0},{"$f":"$H$14/ROWS($E$55:$E$59)","v":2}]
[null,3,{"$f":"'Grant Compliance'!E12","v":0},0,{"$f":"$H$14/ROWS($E$55:$E$59)","v":2}]
[null,4,{"$f":"'Grant Compliance'!E13","v":0},0,{"$f":"$H$14/ROWS($E$55:$E$59)","v":2}]
[null,5,{"$f":"'Grant Compliance'!E14","v":0},0,{"$f":"$H$14/ROWS($E$55:$E$59)","v":2}]

{"sheet":"Control_Variables","index":7,"n_rows":47,"n_cols":28,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,9,1,10],[1,25,1,26],[7,25,7,26],[7,21,8,22],[7,23,8,24],[1,11,1,12],[1,21,5,22],[1,23,5,24]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FullModuleFormatting"]
[null,"OutcomePriorityList","OutcomeTargets","iRowNo","iSwitch","Providersgrants","ProviderList","Locations","iQSAFQuestions","StartSizes",null,"TextRange",null,null,null,null,null,null,null,null,null,"Primary Outcome",null,"Entry to Education/Training",null,"Annual Targets",null,"Monthly"]
[null,"Sustained Education/Training or Employment (52wks)","Grant",2,true,"Test Grant Name","Test Provider","Barking & Dagenham",12,null,200,"PrimaryOutcomeText","The outcome which is key to delivering the intended benefits/objectives of the project and will achieve the greatest long-term impact for the participant on the project. Ideally this should be the last outcome to be achieved by the participant on their journey on the project, which is most likely to be a sustained outcome, if these outcomes are less than 10% of the lifetime targets the second to last outcome on the participant journey should be selected and so on.",null,null,null,null,null,null,null,null,null,null,null,null,"Grant",10]
[null,"Sustained Employment (26wk)","BAME",null,null,"LLW",null,"Barnet",null,null,150,"ConfirmDetailsText","Once the provider has been selected and the information checked, click the ‘Confirm Details’ button to prepare the calculator. Please note that all other sheets will be reset and any data entered in the subsequent sheets will be cleared. When preparing the calculator for a new grant, it is advisable to first save the calculator workbook with a different name. ",null,null,null,null,null,null,null,null,null,null,null,null,"BAME",40]
[null,"Sustained Education/Training (26wk)","Disability",null,null,"Have a go",null,"Bexley",null,null,101,"PeriodSelectText","Choose the period for which data entry is required. Note: at the 6 month period no star rating is calculated.",null,null,null,null,null,null,null,null,null,null,null,null,"Disability",40]
[null,"Entry to Employment","Women",null,null,null,null,"Brent",null,null,51,"ProviderSelectText","Select your provider name. This will automatically populate this grant Summary sheet with the required data.",null,null,null,null,null,null,null,null,null,null,null,null,"Women",40]
[null,"Entry to Education/Training",null,null,null,null,null,"Bromley",null,null,0,null,null,null,null,null,null,null,null,null,null,"ReducedModuleFormatting"]
[null,"Work Placements",null,null,null,null,null,"Camden",null,null,null,null,null,null,null,null,null,null,null,null,null,"Primary Outcome",null,"Entry to Employment",null,"Annual Targets",null,"Monthly"]
[null,"Volunteering",null,null,null,null,null,"City of London",null,null,null,"TargetCategoryText","For each outcome there are up to 4 types of targets to be achieved for which data must be entered:\n• grant – The absolute number of people that achieved this outcome\n• BAME – The number of BAME people that achieved the outcome. The target will be defined as a % of the grant target for this outcome.\n• Disabled – The number of disabled people that achieved the outcome. The target will be defined as a % of the grant target for this outcome.\n• Women– The number of women that achieved the outcome. The target will be defined as a % of the grant target for this outcome. \n",null,null,null,null,null,null,null,null,null,null,null,null,"Grant"]
[null,"Information, Advice and Guidance (IAG)",null,null,null,null,null,"Croydon",null,null,null,"RatingCommentText","This section allows the provider to comment on the rating achieved, and gives the opportunity to explain circumstances which may have impacted on the outcomes of the grant.",null,null,null,null,null,null,null,null,"FrontTargetFormats"]
[null,"Starts",null,null,null,null,null,"Ealing",null,null,null,"GrantSelectText","If you are providing services for more than one grant, please select the grant that you are filling in this calculator for. Otherwise your grant will have been automatically selected."]
[null,null,null,null,null,null,null,"Enfield",null,null,null,"ExamplePromptText","This is an example info prompt. Info prompts will disappear once you select another area on the page or if you click the icon again.",null,null,null,null,null,null,null,null,"FrontTargetFormatsManual"]
[null,null,null,null,null,null,null,"Greenwich",null,null,null,"GrantComplianceResponseText","For prime contractors, this section should be filled in by the funder. For sub-contractors, this section should be filled in by the prime contractor."]
[null,null,null,null,null,null,null,"Hackney",null,null,null,"QSAFQ1GuidanceText","• A comprehensive induction process is in place and includes:\n- A briefing of the aims and objectives of the organisation and the service ;\n- Introduction to all policies for example: health and safety, diversity and inclusion sustainable development , information governance, code of conduct and so forth Service Specific information including what to expect and what is involved\n- Initial and diagnostic assessments which inform the learning/training.\n• The induction should be an interactive process and uses the most appropriate and effective approach for the target audience.\n• All staff involved in the induction should have the relevant skills, experience and knowledge required to deliver the service."]
[null,null,null,null,null,null,null,"Hammersmith & Fulham",null,null,null,"QSAFQ1ExampleText","• Induction material and forms, including : Participants Charter, Participant Handling, Customer Communications – Business Support\n• Initial assessment and diagnostic forms,  action plans, course outlines\n• Policies"]
[null,null,null,null,null,null,null,"Haringey",null,null,null,"QSAFQ2GuidanceText","• All participants receive Information Advice and Guidance before admittance to service and to evaluate their specific needs and determine referrals to other internal and external services\n• At the beginning of participation in the service each participant works, on a one-to-one basis, with the tutor/advisor to develop a personalised action plan to assist with progression and achievement of goals.  The action plan includes internal and external progression routes as appropriate.\n• Upon completing the service each participant has a one-to-one exit interview with the tutor/advisor to:\n- Develop a personalised action plan for the next steps; and\n- Develop an ongoing support plan that is appropriate to the service and sets out the range and limits of the service available to the participant post-completion"]
[null,null,null,null,null,null,null,"Harrow",null,null,null,"QSAFQ2ExampleText","• IAG material\n• Initial assessment and Diagnostic documents.\n• Action and development plans\n• Quality Policy\n• Vision, Mission & Values"]
[null,null,null,null,null,null,null,"Havering",null,null,null,"QSAFQ3GuidanceText","• At the beginning of the service, personalised progress targets are set with the participant  as part of the action planning process.  All participants have regular one-to-one progress reviews, during which the participant and tutor/advisor review progress against the action plan and targets and, where appropriate, make any necessary updates. \n• If the participants receiving a range of services delivered by more than one person, the mentor/tutor/advisor ensures that appropriate progress information is captured from the relevant staff and is discussed with the participant during the progress review meeting."]
[null,null,null,null,null,null,null,"Hillingdon",null,null,null,"QSAFQ3ExampleText","• Policy documents\n• Service Delivery Plans\n• Participant files and records\n• Action and development  plans\n• Participant  journey information"]
[null,null,null,null,null,null,null,"Hounslow",null,null,null,"QSAFQ4GuidanceText","• The aims and objectives of the service are clearly defined and an evaluation strategy is in place\n• The effectiveness of the service is monitored and evaluated against key performance indicators, outcomes, targets and milestone achievements, and is informed by internal and external stakeholder feedback\n• Data, including participant feedback, is effectively collected and used to monitor effectiveness of services\n• Evidence about effectiveness is reviewed and used to\n- Review and evaluate services;\n- Inform self assessment and the production of an action/development plan for the organisation\n• Processes and mechanisms are in place to ensure that information relating to the effectiveness of the service is communicated appropriately to internal and external stakeholders.\n• Appropriate resources for monitoring and evaluating effectiveness are in place\n• All staff are aware of their roles and responsibilities for reporting and monitoring management information"]
[null,null,null,null,null,null,null,"Islington",null,null,null,"QSAFQ4ExampleText","• Up-to-date management system\n• Participant and employer feedback\n• Staff feedback\n• MI systems\n• Monthly performance reports\n• Evaluation strategy\n• Monitoring and review framework\n• Programme evaluations\n• Funding body monitoring and audits information\n• Meeting minutes\n• Self-assessment report and development/action plan"]
[null,null,null,null,null,null,null,"Kensington & Chelsea",null,null,null,"QSAFQ5GuidanceText","• An internal quality audit is conducted on all services\n• An observation system or peer review process is in place which includes standards and criteria\n• Staff involved in the quality assurance activities receive appropriate training\n• All staff are aware of their roles and responsibilities in respect of quality assurance"]
[null,null,null,null,null,null,null,"Kingston",null,null,null,"QSAFQ5ExampleText","• Peer reviews/observations records\n• Training modules on Common Inspection Framework and observation\n• Quality assurance policy\n• Staff induction information"]
[null,null,null,null,null,null,null,"Lambeth",null,null,null,"QSAFQ6GuidanceText","• A short and long term plan/strategy is in place which is responsive to local needs and reviewed and updated regularly\n• The development and ongoing review of the plans is informed by local needs analysis, including stakeholder feedback and review of Local Area Agreement priorities and labour market information\n• A self-assessment report and action/development plan are prepared annually and reviewed regularly against the business plan\n• Policies, resources and practices are in place to ensure all staff have an appropriate understanding of:\n- The priorities of the organisation, the business plan and action/development plan; \n- Their associated roles and responsibilities"]
[null,null,null,null,null,null,null,"Lewisham",null,null,null,"QSAFQ6ExampleText","• Business plan \n• Self assessment report and development plan \n• Evidence of review process\n• Evidence of needs analysis of local priorities\n• Board meeting minutes\n• SMT meeting minutes\n• Team meetings \n• Business Review Meeting notes"]
[null,null,null,null,null,null,null,"Merton",null,null,null,"QSAFQ7GuidanceText","• Research is conducted to understand the needs of the participants and other stakeholders that use the service and used to improve engagement and outreach activities.\n• Engagement and outreach activity maximises links with partner organisations and other stakeholders.\n• Lessons learned from previous marketing and outreach activities are used to inform future activity\n• A marketing plan informed by an understanding of employer and participant target groups and other stakeholders is in place and is reviewed regularly"]
[null,null,null,null,null,null,null,"Newham",null,null,null,"QSAFQ7ExampleText","• Information about the take-up of the service, including information about priority groups\n• Marketing plan\n• Review notes\n• Plans prepared for new programmes and tenders\n• Strategic review documents\n• Board meeting minutes\n• SMT meeting minutes\n• PR Strategy Framework\n• Business Review Meeting notes"]
[null,null,null,null,null,null,null,"Redbridge",null,null,null,"QSAFQ8GuidanceText","• Research is conducted to understand the needs of the participants and other stakeholders that use the service and used to improve engagement and outreach activities.\n• Engagement and outreach activity maximises links with partner organisations and other stakeholders.\n• Lessons learned from previous marketing and outreach activities are used to inform future activity\n• A marketing plan informed by an understanding of employer and participant target groups and other stakeholders is in place and is reviewed regularly"]
[null,null,null,null,null,null,null,"Richmond",null,null,null,"QSAFQ8ExampleText","• Material and policies on granting & Supplier Management, Consultancy Code of Practice\n• grants and SLAs\n• Approved Supplier List \n• Assessment reports of Potential suppliers/Partners\n• Records of Partner/Subcontractor Review Meetings.\n• Audits of subcontractors/partners.\n• Subcontractor/partner progress reports.\n• Register of Training Providers & Courses"]
[null,null,null,null,null,null,null,"Southwark",null,null,null,"QSAFQ9GuidanceText","• The organisation is actively involved in a variety of networks and partnerships, including professional networks, to ensure that \n- The service remains strategically relevant;\n- The service meets the needs of stakeholders and local priorities; \n- Effective practice and lessons learned are shared; and\n- Professional standards are met."]
[null,null,null,null,null,null,null,"Sutton",null,null,null,"QSAFQ9ExampleText","• Referral file\n• IAG interviews\n• Case studies\n• Joint bids.\n• Board/steering meeting minutes."]
[null,null,null,null,null,null,null,"Tower Hamlets",null,null,null,"QSAFQ10GuidanceText","• All staff receive an induction including:\n- A briefing about the aims and objectives of the organisation and the programme; \n- Understanding and implementations of health and safety diversity and inclusion sustainable development , information governance, code of conduct and other polices in professional practice \n- All relevant polices and processes, including the appraisal process.\n• A staff training needs assessment is undertaken. \n• All staff have access to a training programme to ensure staff have the essential knowledge to carry out their roles effectively. \n• A staff appraisal system is in place and all staff have an annual training plan.  All staff have access to regular supervisions and annual appraisals linked to training\n• Roles profiles/job descriptions are regularly reviewed"]
[null,null,null,null,null,null,null,"Waltham Forest",null,null,null,"QSAFQ10ExampleText","• Staff training needs assessments \n• All staff have an annual training plan and annual appraisals linked to training\n• Staff training delivered internally on training days each month\n• Staff have been on accredited external courses \n• Staff are involved in external professional development networks\n• Investors in People status"]
[null,null,null,null,null,null,null,"Wandsworth",null,null,null,"QSAFQ11GuidanceText","• The organisation has comprehensive Diversity and Inclusion policies that are communicated appropriately to internal and external stakeholders\n• The complaints procedure is clear, participants are aware of it and informed of action taken in response to any complaints raised\n• The diversity of the workforce,  customers and associated outcomes is regularly monitored to ensure that these reflect diversity targets and that no particular group is excluded\n• Information, learning/training activities, resources and assessments are adapted appropriately to ensure that these are accessible to all users\n• Equality and Diversity polices are reviewed to ensure that they are kept up to date with changing legislation.  All changes to policy and legislation are communicated appropriately.  "]
[null,null,null,null,null,null,null,"Westminster",null,null,null,"QSAFQ11ExampleText","• Equality and Diversity Policy\n• Learner and staff induction information \n• Equal Opportunities Implementation & Evaluation Action Plan\n• Equal Opportunities Champion\n• Evidence of equality and diversity review process"]
[null,null,null,null,null,null,null,null,null,null,null,"QSAFQ12GuidanceText","• Providers will have policies in place to ensure compliance with relevant legislation and good practice in regard to protecting participants and providing services safely\n• This will include the recruitment, selection, appointment and induction of staff and volunteers\n• Information Governance for sharing personal data of participants and data protection  \n• Child and Adult Protection Policies following appropriate government guidelines \n• Permission from participants for image consent \n• Risk Assessment to be conducted for activities, work or volunteer placements\n• Whistleblowing Policy \n• Code of conduct for staff, volunteers, trustees and participants \n• Named safeguarding member of staff, outline of roles, responsibility and actions for staff, volunteers, trustees etc \n• E-safety and usage of social media\n• Bullying Policy \n• First aid arrangements and appropriately trained personnel\n• Continuous professional development to keep abreast with legislative changes  "]
[null,null,null,null,null,null,null,null,null,null,null,"QSAFQ12ExampleText","Complaints for service users, first aid and medication policy,  Child and Adult protection policies, consent forms, code of conduct/ethics, data protection, risk assessments, smoking guidelines, Workplace Display Screen Equipment assessment. Under training can you please give some examples as training comes under several headings e.g. safeguarding, first aid, risk assessments, fire warden, E- safety"]
[null,null,null,null,null,null,null,null,null,null,null,"ZeroSatisfactionWarningText","Warning: The number of participant responses is below the minimum threshold of 60% of the primary outcome achieved. This automatically results in a zero score for this section."]
[null,null,null,null,null,null,null,null,null,null,null,"SubExtractionText","This button allows the aggregation of grant performance information from sub-contractor workbooks. This requires that the completed sub-contractor workbooks have been stored in the same folder as this workbook."]
[null,null,null,null,null,null,null,null,null,null,null,"SatisSubExtractionText","This button allows the aggregation of participant satisfaction information from sub-contractor workbooks. This requires that the completed sub-contractor workbooks have been stored in the same folder as this workbook."]
[null,null,null,null,null,null,null,null,null,null,null,"DiversityTargetText","Diversity targets are defined as the proportion of those achieving the Primary Target that are of the specific diversity group. The value of diversity targets set can be between 0 and 100%."]
[null,null,null,null,null,null,null,null,null,null,null,"SatisfactionQsText1","Q1. What do you think of your advisor’s/trainer’s? \na) Knowledge of the subject/activity* \nb) Understanding of your needs\nc) Support in setting targets to help you achieve your goals\nd)  Help with finding other support for you\ne) Support with helping you to plan your next steps    \nQ2. How has this activity made a difference to you?\na) My confidence has\nb) My skills have \nc) My prospects of getting a job have\nd) My knowledge of options available to me has  \ne) My motivation to make the next steps has\nf) My ability to manage my time and responsibilities has\nQ3.  Overall, how satisfied or dissatisfied were you with the activity? \n"]
[null,null,null,null,null,null,null,null,null,null,null,"SatisfactionQsText2","Q1. What do you think of your advisor’s/trainer’s? \na) Knowledge of the subject/activity* \nb) Understanding of your needs\nc) Support in setting targets to help you achieve your goals\nd)  Help with finding other support for you\ne) Support with helping you to plan your next steps    \nQ2. How has this activity made a difference to you?\na) My confidence has\nb) My skills have \nc) My prospects of getting a job have\nd) My knowledge of options available to me has  \ne) My motivation to make the next steps has\nf) My ability to manage my time and responsibilities has\nQ3.  Overall, how satisfied or dissatisfied were you with the activity? \n"]
[null,null,null,null,null,null,null,null,null,null,null,"SatisfactionQsText3","Q1. What do you think of your advisor’s/trainer’s? \na) Knowledge of the subject/activity* \nb) Understanding of your needs\nc) Support in setting targets to help you achieve your goals\nd)  Help with finding other support for you\ne) Support with helping you to plan your next steps    \nQ2. How has this activity made a difference to you?\na) My confidence has\nb) My skills have \nc) My prospects of getting a job have\nd) My knowledge of options available to me has  \ne) My motivation to make the next steps has\nf) My ability to manage my time and responsibilities has\nQ3.  Overall, how satisfied or dissatisfied were you with the activity? \n"]
[null,null,null,null,null,null,null,null,null,null,null,"SatisfactionQsText4","Q1. What do you think of your advisor’s/trainer’s? \na) Knowledge of the subject/activity* \nb) Understanding of your needs\nc) Support in setting targets to help you achieve your goals\nd)  Help with finding other support for you\ne) Support with helping you to plan your next steps    \nQ2. How has this activity made a difference to you?\na) My confidence has\nb) My skills have \nc) My prospects of getting a job have\nd) My knowledge of options available to me has  \ne) My motivation to make the next steps has\nf) My ability to manage my time and responsibilities has\nQ3.  Overall, how satisfied or dissatisfied were you with the activity? \n"]
[null,null,null,null,null,null,null,null,null,null,null,"ParticipantSatisSource","The results for this sheet should come from survey responses from participants as they achieve the primary outcome. The survey questions that need to be asked of the participant are outlined in the info icon below (next to each question) and are also documented in the main user guidance document."]
[null,null,null,null,null,null,null,null,null,null,null,"QSAFEvidenceNote","Examples of suitable evidence are detailed in the info icons below. Please note that evidence does not need to be submitted with the calculator. "]

{"sheet":"Back_Sheet","index":8,"n_rows":8,"n_cols":181,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,48,5,48],[3,49,3,150],[3,151,3,180],[4,49,4,65],[4,66,4,82],[4,83,4,99],[4,100,4,116],[4,117,4,133],[4,134,4,150],[4,151,4,155],[4,156,4,160],[4,161,4,165],[4,166,4,170],[4,171,4,175],[4,176,4,180],[3,47,5,47],[3,36,5,36],[3,37,5,37],[3,38,5,38],[3,39,5,39],[3,40,5,40],[3,41,5,41],[3,42,5,42],[3,43,5,43],[3,44,5,44],[3,45,5,45],[3,46,5,46],[3,35,5,35],[3,24,5,24],[3,25,5,25],[3,26,5,26],[3,27,5,27],[3,28,5,28],[3,29,5,29],[3,30,5,30],[3,31,5,31],[3,32,5,32],[3,33,5,33],[3,34,5,34],[3,23,5,23],[3,12,5,12],[3,13,5,13],[3,14,5,14],[3,15,5,15],[3,16,5,16],[3,17,5,17],[3,18,5,18],[3,19,5,19],[3,20,5,20],[3,21,5,21],[3,22,5,22],[3,8,5,8],[3,9,5,9],[3,10,5,10],[3,11,5,11],[3,1,5,1],[3,2,5,2],[3,3,5,3],[3,4,5,4],[3,5,5,5],[3,6,5,6],[3,7,5,7]]}
[]
[]
[]
[null,"Provider","Year","Funder","Grant Name","Prime/Sub","Number of Sub-contractors","Target Group","grant start date","Year of grant","Grant Value","grant Description","Pan London","Barking & Dagenham","Barnet","Bexley","Brent","Bromley","Camden","City of London","Croydon","Ealing","Enfield","Greenwich","Hackney","Hammersmith & Fulham","Haringey","Harrow","Havering","Hillingdon","Hounslow","Islington","Kensington & Chelsea","Kingston","Lambeth","Lewisham","Merton","Newham","Redbridge","Richmond","Southwark","Sutton","Tower Hamlets","Waltham Forest","Wandsworth","Westminster","Funding Round and Spec","Number of Targets","Diversity Targets","Current Year Targets",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,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,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,null,null,null,null,null,null,null,null,null,null,null,"Lifetime Targets"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Primary Target",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Target 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Target 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Target 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Target 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Target 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Primary Target",null,null,null,null,"Target 2",null,null,null,null,"Target 3",null,null,null,null,"Target 4",null,null,null,null,"Target 5",null,null,null,null,"Target 6"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Target Type","Outcome Target","BAME Target (%)","Disability Target (%)","Women Target (%)","Outcome Target for APR","Outcome Target for MAY","Outcome Target for JUN","Outcome Target for JUL","Outcome Target for AUG","Outcome Target for SEP","Outcome Target for OCT","Outcome Target for NOV","Outcome Target for DEC","Outcome Target for JAN","Outcome Target for FEB","Outcome Target for MAR","Target Type","Outcome Target","BAME Target (%)","Disability Target (%)","Women Target (%)","Outcome Target for APR","Outcome Target for MAY","Outcome Target for JUN","Outcome Target for JUL","Outcome Target for AUG","Outcome Target for SEP","Outcome Target for OCT","Outcome Target for NOV","Outcome Target for DEC","Outcome Target for JAN","Outcome Target for FEB","Outcome Target for MAR","Target Type","Outcome Target","BAME Target (%)","Disability Target (%)","Women Target (%)","Outcome Target for APR","Outcome Target for MAY","Outcome Target for JUN","Outcome Target for JUL","Outcome Target for AUG","Outcome Target for SEP","Outcome Target for OCT","Outcome Target for NOV","Outcome Target for DEC","Outcome Target for JAN","Outcome Target for FEB","Outcome Target for MAR","Target Type","Outcome Target","BAME Target (%)","Disability Target (%)","Women Target (%)","Outcome Target for APR","Outcome Target for MAY","Outcome Target for JUN","Outcome Target for JUL","Outcome Target for AUG","Outcome Target for SEP","Outcome Target for OCT","Outcome Target for NOV","Outcome Target for DEC","Outcome Target for JAN","Outcome Target for FEB","Outcome Target for MAR","Target Type","Outcome Target","BAME Target (%)","Disability Target (%)","Women Target (%)","Outcome Target for APR","Outcome Target for MAY","Outcome Target for JUN","Outcome Target for JUL","Outcome Target for AUG","Outcome Target for SEP","Outcome Target for OCT","Outcome Target for NOV","Outcome Target for DEC","Outcome Target for JAN","Outcome Target for FEB","Outcome Target for MAR","Target Type","Outcome Target","BAME Target (%)","Disability Target (%)","Women Target (%)","Outcome Target for APR","Outcome Target for MAY","Outcome Target for JUN","Outcome Target for JUL","Outcome Target for AUG","Outcome Target for SEP","Outcome Target for OCT","Outcome Target for NOV","Outcome Target for DEC","Outcome Target for JAN","Outcome Target for FEB","Outcome Target for MAR","Lifetime Target Type","Lifetime Outcome Target","Lifetime BAME Target (%)","Lifetime Disability Target (%)","Lifetime Women Target (%)","Lifetime Target Type","Lifetime Outcome Target","Lifetime BAME Target (%)","Lifetime Disability Target (%)","Lifetime Women Target (%)","Lifetime Target Type","Lifetime Outcome Target","Lifetime BAME Target (%)","Lifetime Disability Target (%)","Lifetime Women Target (%)","Lifetime Target Type","Lifetime Outcome Target","Lifetime BAME Target (%)","Lifetime Disability Target (%)","Lifetime Women Target (%)","Lifetime Target Type","Lifetime Outcome Target","Lifetime BAME Target (%)","Lifetime Disability Target (%)","Lifetime Women Target (%)","Lifetime Target Type","Lifetime Outcome Target","Lifetime BAME Target (%)","Lifetime Disability Target (%)","Lifetime Women Target (%)"]
[null,"Provider","Year","Funder","Grant Name","Prime/Sub","Number of Sub-contractors","Target Group","grant start date","Year of grant","Grant Value","grant Description","Pan London","Barking & Dagenham","Barnet","Bexley","Brent","Bromley","Camden","City of London","Croydon","Ealing","Enfield","Greenwich","Hackney","Hammersmith & Fulham","Haringey","Harrow","Havering","Hillingdon","Hounslow","Islington","Kensington & Chelsea","Kingston","Lambeth","Lewisham","Merton","Newham","Redbridge","Richmond","Southwark","Sutton","Tower Hamlets","Waltham Forest","Wandsworth","Westminster","Funding Round and Spec","Number of Targets","Diversity Targets?","Target_1_Type","Target_1_Profile","Target_1_BAME","Target_1_Disability","Target_1_Women","Target_1_M1","Target_1_M2","Target_1_M3","Target_1_M4","Target_1_M5","Target_1_M6","Target_1_M7","Target_1_M8","Target_1_M9","Target_1_M10","Target_1_M11","Target_1_M12","Target_2_Type","Target_2_Profile","Target_2_BAME","Target_2_Disability","Target_2_Women","Target_2_M1","Target_2_M2","Target_2_M3","Target_2_M4","Target_2_M5","Target_2_M6","Target_2_M7","Target_2_M8","Target_2_M9","Target_2_M10","Target_2_M11","Target_2_M12","Target_3_Type","Target_3_Profile","Target_3_BAME","Target_3_Disability","Target_3_Women","Target_3_M1","Target_3_M2","Target_3_M3","Target_3_M4","Target_3_M5","Target_3_M6","Target_3_M7","Target_3_M8","Target_3_M9","Target_3_M10","Target_3_M11","Target_3_M12","Target_4_Type","Target_4_Profile","Target_4_BAME","Target_4_Disability","Target_4_Women","Target_4_M1","Target_4_M2","Target_4_M3","Target_4_M4","Target_4_M5","Target_4_M6","Target_4_M7","Target_4_M8","Target_4_M9","Target_4_M10","Target_4_M11","Target_4_M12","Target_5_Type","Target_5_Profile","Target_5_BAME","Target_5_Disability","Target_5_Women","Target_5_M1","Target_5_M2","Target_5_M3","Target_5_M4","Target_5_M5","Target_5_M6","Target_5_M7","Target_5_M8","Target_5_M9","Target_5_M10","Target_5_M11","Target_5_M12","Target_6_Type","Target_6_Profile","Target_6_BAME","Target_6_Disability","Target_6_Women","Target_6_M1","Target_6_M2","Target_6_M3","Target_6_M4","Target_6_M5","Target_6_M6","Target_6_M7","Target_6_M8","Target_6_M9","Target_6_M10","Target_6_M11","Target_6_M12","Life_Target_1_Type","Life_Target_1_Profile","Life_Target_1_BAME","Life_Target_1_Disability","Life_Target_1_Women","Life_Target_2_Type","Life_Target_2_Profile","Life_Target_2_BAME","Life_Target_2_Disability","Life_Target_2_Women","Life_Target_3_Type","Life_Target_3_Profile","Life_Target_3_BAME","Life_Target_3_Disability","Life_Target_3_Women","Life_Target_4_Type","Life_Target_4_Profile","Life_Target_4_BAME","Life_Target_4_Disability","Life_Target_4_Women","Life_Target_5_Type","Life_Target_5_Profile","Life_Target_5_BAME","Life_Target_5_Disability","Life_Target_5_Women","Life_Target_6_Type","Life_Target_6_Profile","Life_Target_6_BAME","Life_Target_6_Disability","Life_Target_6_Women"]
[null,"Test Provider","2018/19","Test Funder","Test Grant Name","Prime",5,"Test Target Group",2017,1,200000,"Test Grant Description",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"ESF 2014-20 ",2,"Yes","Starts",250,20,20,60,20,20,20,20,20,20,20,20,20,20,25,25,"Jobs",150,20,20,60,10,10,10,10,10,10,15,15,15,15,15,15,"Sustained Employment",50,20,20,60,null,null,null,null,null,null,null,10,10,10,10,10,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Starts",1000,20,20,60,"Jobs",500,20,20,60,"Sustained Employment",250,20,20,60]

{"sheet":"Data for extraction","index":9,"n_rows":17,"n_cols":92,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,4,2],[3,1,4,1],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,42,4,42],[3,44,4,44],[3,45,4,45],[3,46,4,46],[3,47,4,47],[3,43,4,43],[3,37,4,37],[3,38,4,38],[3,39,4,39],[3,40,4,40],[3,41,4,41],[3,50,4,50],[3,51,4,51],[3,52,4,52],[3,53,4,53],[3,48,4,48],[3,49,4,49],[3,36,4,36],[3,25,4,25],[3,26,4,26],[3,27,4,27],[3,28,4,28],[3,29,4,29],[3,30,4,30],[3,32,4,32],[3,33,4,33],[3,34,4,34],[3,35,4,35],[3,31,4,31],[3,6,4,6],[3,24,4,24],[3,8,3,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,19,4,19],[3,7,4,7]]}
[]
[null,"Master Data requirements"]
[]
[null,"Funder","Rating Year","Provider","Grant Name","Prime/Sub","Stars","Comments","12 Month Stocktake Performance Rating Points ",null,null,null,null,null,null,"Target Group","Primary Outcome","No. of starters ","Year of Delivery","Pan London","Barking & Dagenham","Barnet","Bexley","Brent","Bromley","Camden","City of London","Croydon","Ealing","Enfield","Greenwich","Hackney","Hammersmith & Fulham","Haringey","Harrow","Havering","Hillingdon","Hounslow","Islington","Kensington & Chelsea","Kingston","Lambeth","Lewisham","Merton","Newham","Redbridge","Richmond","Southwark","Sutton","Tower Hamlets","Waltham Forest","Wandsworth","Westminster","Funding Round and Spec"]
[null,null,null,null,null,null,null,null,"Total %","Delivery (Max: 48)","Diversity (Max: 12)","Conversion (Max: 12)","Self Assessment (Max: 9)","Participant Satisfaction (Max: 9)","Grant Compliance (Max:10)"]
[null,{"$f":"'Grant Summary'!C12","v":"Test Funder"},{"$f":"CalcYear","v":"2018/19"},"Test Provider",{"$f":"GrantName","v":"Test Grant Name"},{"$f":"'Grant Summary'!C14","v":"Prime"},0,{"$f":"RatingComment","v":0},{"$f":"StarRatingPoints","v":0},{"$f":"'Star Rating Calculations'!G9","v":0},{"$f":"'Star Rating Calculations'!G10","v":0},{"$f":"'Star Rating Calculations'!G11","v":0},{"$f":"'Star Rating Calculations'!G12","v":0},{"$f":"'Star Rating Calculations'!G13","v":0},{"$f":"'Star Rating Calculations'!G14","v":0},{"$f":"'Grant Summary'!C18","v":"Test Target Group"},"Starts",{"$f":"VLOOKUP(\"Starts\",PerfomCalcTable,3,FALSE)*INDEX(ConversionCalcTable,1,2)","v":0},{"$f":"'Grant Summary'!C17","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!T4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!U4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!V4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!W4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!X4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!Y4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!Z4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AA4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AB4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AC4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AD4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AE4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AF4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AG4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AH4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AI4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AJ4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AK4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AL4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AM4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AN4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AO4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AP4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AQ4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AR4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AS4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AT4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AU4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AV4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AW4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AX4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AY4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!AZ4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"VLOOKUP(ProviderName,Back_Sheet_Table,MATCH('Data for extraction'!BA4,INDEX(Back_Sheet_Table,1,0),0),FALSE)","v":1},{"$f":"'Grant Summary'!C18","v":"Test Target Group"}]
[]
[null,"Grant Performance information"]
[]
[null,"Funder","Rating Year","Provider","Grant Name","Prime/Sub","Number of Targets","Diversity Targets?","Outcome_1_Type","Outcome_1_Profile","Outcome_1_BAME","Outcome_1_Disability","Outcome_1_Women","Outcome_2_Type","Outcome_2_Profile","Outcome_2_BAME","Outcome_2_Disability","Outcome_2_Women","Outcome_3_Type","Outcome_3_Profile","Outcome_3_BAME","Outcome_3_Disability","Outcome_3_Women","Outcome_4_Type","Outcome_4_Profile","Outcome_4_BAME","Outcome_4_Disability","Outcome_4_Women","Outcome_5_Type","Outcome_5_Profile","Outcome_5_BAME","Outcome_5_Disability","Outcome_5_Women","Outcome_6_Type","Outcome_6_Profile","Outcome_6_BAME","Outcome_6_Disability","Outcome_6_Women","Target_1_Profile","Target_1_BAME","Target_1_Disability","Target_1_Women","Target_2_Profile","Target_2_BAME","Target_2_Disability","Target_2_Women","Target_3_Profile","Target_3_BAME","Target_3_Disability","Target_3_Women","Target_4_Profile","Target_4_BAME","Target_4_Disability","Target_4_Women","Target_5_Profile","Target_5_BAME","Target_5_Disability","Target_5_Women","Target_6_Profile","Target_6_BAME","Target_6_Disability","Target_6_Women","Life_Target_1_Type","Life_Target_1_Profile","Life_Target_1_BAME","Life_Target_1_Disability","Life_Target_1_Women","Life_Target_2_Type","Life_Target_2_Profile","Life_Target_2_BAME","Life_Target_2_Disability","Life_Target_2_Women","Life_Target_3_Type","Life_Target_3_Profile","Life_Target_3_BAME","Life_Target_3_Disability","Life_Target_3_Women","Life_Target_4_Type","Life_Target_4_Profile","Life_Target_4_BAME","Life_Target_4_Disability","Life_Target_4_Women","Life_Target_5_Type","Life_Target_5_Profile","Life_Target_5_BAME","Life_Target_5_Disability","Life_Target_5_Women","Life_Target_6_Type","Life_Target_6_Profile","Life_Target_6_BAME","Life_Target_6_Disability","Life_Target_6_Women"]
[null,{"$f":"B6","v":"Test Funder"},{"$f":"C6","v":"2018/19"},"Test Provider","Test Grant Name","Prime",{"$f":"TargetCount","v":2},{"$f":"DiversitySwitch","v":"Yes"},"Starts",{"$f":"SUM(INDEX(Target_Outcomes_1,1,0))","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_1,2,0)),\"\")","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_1,3,0)),\"\")","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_1,4,0)),\"\")","v":0},"Jobs",{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,1,0)),\"\")","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,2,0)),\"\")","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,3,0)),\"\")","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_2,4,0)),\"\")","v":0},null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_3,1,0)),\"\")","v":""},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_3,2,0)),\"\")","v":""},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_3,3,0)),\"\")","v":""},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_3,4,0)),\"\")","v":""},null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_4,1,0)),)","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_4,2,0)),)","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_4,3,0)),)","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_4,4,0)),)","v":0},null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_5,1,0)),)","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_5,2,0)),\"\")","v":""},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_5,3,0)),\"\")","v":""},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_5,4,0)),\"\")","v":""},null,{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_6,1,0)),)","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_6,2,0)),)","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_6,3,0)),)","v":0},{"$f":"IFERROR(SUM(INDEX(Target_Outcomes_6,4,0)),)","v":0},250,20,20,60,150,20,20,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Starts",1000,20,20,60,"Jobs",500,20,20,60,"Sustained Employment",250,20,20,60]
[]
[null,"Participant Satisfaction",null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(R16,LEN(R16)-2)","v":"3"}]
[null,{"$f":"MATCH(LEFT(G16,LEN(G16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":3},{"$f":"MATCH(LEFT(H16,LEN(H16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":4},{"$f":"MATCH(LEFT(I16,LEN(I16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":5},{"$f":"MATCH(LEFT(J16,LEN(J16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":6},{"$f":"MATCH(LEFT(K16,LEN(K16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":7},{"$f":"MATCH(LEFT(L16,LEN(L16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":8},9,10,11,12,13,{"$f":"MATCH(INT(LEFT(R16,LEN(R16)-2)),INDEX(ClientSatisfQ1,0,1),0)","v":14},{"$f":"MATCH(LEFT(S16,LEN(S16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":3},4,5,6,7,8,9,10,11,12,13,{"$f":"MATCH(INT(LEFT(AD16,LEN(AD16)-2)),INDEX(ClientSatisfQ1,0,1),0)","v":14},{"$f":"MATCH(LEFT(AE16,LEN(AE16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":3},4,5,6,7,8,9,10,11,12,13,{"$f":"MATCH(INT(LEFT(AP16,LEN(AP16)-2)),INDEX(ClientSatisfQ1,0,1),0)","v":14},{"$f":"MATCH(LEFT(AQ16,LEN(AQ16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":3},4,5,6,7,8,9,10,11,12,13,{"$f":"MATCH(INT(LEFT(BB16,LEN(BB16)-2)),INDEX(ClientSatisfQ1,0,1),0)","v":14},{"$f":"MATCH(LEFT(BC16,LEN(BC16)-2),INDEX(ClientSatisfQ1,0,1),0)","v":3},4,5,6,7,8,9,10,11,12,13,{"$f":"MATCH(INT(LEFT(BN16,LEN(BN16)-2)),INDEX(ClientSatisfQ1,0,1),0)","v":14}]
[null,{"$f":"6-RIGHT(G16)","v":2},{"$f":"6-RIGHT(H16)","v":2},{"$f":"6-RIGHT(I16)","v":2},{"$f":"6-RIGHT(J16)","v":2},{"$f":"6-RIGHT(K16)","v":2},{"$f":"6-RIGHT(L16)","v":2},2,2,2,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,4,4,4,4,4,4,4,4,{"$f":"6-RIGHT(AM16)","v":4},4,4,4,5,5,5,5,5,5,5,5,5,5,5,5,6,6,6,6,6,6,6,6,6,6,6,6]
[null,"Funder","Rating Year","Provider","Grant Name","Prime/Sub","1a_4","1b_4","1c_4","1d_4","1e_4","2a_4","2b_4","2c_4","2d_4","2e_4","2f_4","3_4","1a_3","1b_3","1c_3","1d_3","1e_3","2a_3","2b_3","2c_3","2d_3","2e_3","2f_3","3_3","1a_2","1b_2","1c_2","1d_2","1e_2","2a_2","2b_2","2c_2","2d_2","2e_2","2f_2","3_2","1a_1","1b_1","1c_1","1d_1","1e_1","2a_1","2b_1","2c_1","2d_1","2e_1","2f_1","3_1","1a_0","1b_0","1c_0","1d_0","1e_0","2a_0","2b_0","2c_0","2d_0","2e_0","2f_0","3_0"]
[null,{"$f":"B11","v":"Test Funder"},{"$f":"C11","v":"2018/19"},"Test Provider","Test Grant Name","Prime",{"$f":"INDEX(ClientSatisfQ1,B14,B15) +INDEX(ClientSatisfQ2,B14,B15)+ INDEX(ClientSatisfQ3,B14,B15) + INDEX(ClientSatisfQ4,B14,B15)","v":0},{"$f":"INDEX(ClientSatisfQ1,C14,C15) +INDEX(ClientSatisfQ2,C14,C15)+ INDEX(ClientSatisfQ3,C14,C15) + INDEX(ClientSatisfQ4,C14,C15)","v":0},{"$f":"INDEX(ClientSatisfQ1,D14,D15) +INDEX(ClientSatisfQ2,D14,D15)+ INDEX(ClientSatisfQ3,D14,D15) + INDEX(ClientSatisfQ4,D14,D15)","v":0},{"$f":"INDEX(ClientSatisfQ1,E14,E15) +INDEX(ClientSatisfQ2,E14,E15)+ INDEX(ClientSatisfQ3,E14,E15) + INDEX(ClientSatisfQ4,E14,E15)","v":0},{"$f":"INDEX(ClientSatisfQ1,F14,F15) +INDEX(ClientSatisfQ2,F14,F15)+ INDEX(ClientSatisfQ3,F14,F15) + INDEX(ClientSatisfQ4,F14,F15)","v":0},{"$f":"INDEX(ClientSatisfQ1,G14,G15) +INDEX(ClientSatisfQ2,G14,G15)+ INDEX(ClientSatisfQ3,G14,G15) + INDEX(ClientSatisfQ4,G14,G15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"INDEX(ClientSatisfQ1,AH14,AH15) +INDEX(ClientSatisfQ2,AH14,AH15)+ INDEX(ClientSatisfQ3,AH14,AH15) + INDEX(ClientSatisfQ4,AH14,AH15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]