{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Delivery Profile","Achievement Data","Qualfications","Admin"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Delivery Profile","index":0,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[30,2,30,4],[3,2,3,13]]}
["Please complete both sections"]
["Failure to complete all tabs on this spreadsheet will result in non compliance and your applicatiion being removed from the process"]
[]
["A - Delivery profile",null,"Number of starts per month"]
["Site Postcode / Cohort","Qualification Title / Learning Aim","August","September","October","November","December","January","February","March","April","May ","June","July"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B- Delivery Band Information"]
["Site Postcode","Qualification Title / Learning Aim","Programme Duration (weeks)","Band (see table below)","Number of starts"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Total",null,null,{"$f":"SUBTOTAL(9,E19:E28)","v":0}]
[]
[]
[]
["Band (study programmes excluding T levels)","Annual planned hours","Students","National funding rate per student"]
[5,"580+ hours","16- and 17-year-olds and students aged 18 and over with high needs",4843]
["4a","485+ hours","students aged 18 and over who are not high needs",4006]
["4b","485 to 579 hours","16- and 17-year-olds and students aged 18 and over with high needs",4006]
[3,"385 to 484 hours","all students",3258]
[2,"300 to 384 hours","all students",2576]
[1,"up to 299 hours","all students","£4,843 \nproportion of band 5"]

{"sheet":"Achievement Data","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,0,10,0],[11,0,15,0],[16,0,20,0],[1,0,1,1],[2,0,5,0]]}
[null,null,"Example"]
["Qualification Title / Learning Aim",null,"Certificate in Examples - 601/0000/X"]
["Academic Year 2022/23","Number Enrolled",35]
[null,"Number Continuing YTD",27]
[null,"Predicted Achievement Rate   (%)",71.400000000000006]
[null,"Predicted Retention Rate (%)",77.099999999999994]
["Academic Year 2021/22","Number Enrolled",30]
[null,"Number Continuing into next academic year (planned or unplanned)",0]
[null,"Achievement Rate   (%)",80]
[null,"Positive Destinations (%)",75]
[null,"Retention Rate (%)",96.7]
["Academic Year 2020/21","Number Enrolled ",60]
[null,"Number Continuing into next academic year (planned or unplanned)",0]
[null,"Achievement Rate   (%)",95]
[null,"Positive Destinations (%)",56]
[null,"Retention Rate (%)",95]
["Academic Year 2019/20","Number Enrolled ",0]
[null,"Number Continuing into next academic year (planned or unplanned)",0]
[null,"Achievement Rate   (%)",0]
[null,"Positive Destinations (%)",0]
[null,"Retention Rate (%)",0]
[]
[]
["Please note a positive destination is counted as:"]
["Further training "]
["Employment (full time, part time or self employed)"]

{"sheet":"Qualfications","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Example","Qualification ID","Qualification ID","Qualification ID","Qualification ID","Qualification ID"]
[null,"601/0000/X"]
["Delivery postcode","SG12 9JF"]
["Funding source","ESFA"]
["Delivery band for 16-19 funding  (see table below)",5]
["Taught Hours",590]
["Work Experience Hours",32]
["Tutorial Hours",40]
["Independent Study Hours",32]
["Delivery model","Face to Face"]
["Awarding Organisation Claims Status ","Direct Claims"]
["HRC only fields"]
["College Level"]
["Cost Code",null,{"$f":"IFERROR(VLOOKUP(C13,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D13,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E13,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(F13,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""}]
["HRC Offering code"]
[]
[]
["Band (study programmes excluding T levels)","Annual planned hours","Students","National funding rate per student"]
[5,"580+ hours","16- and 17-year-olds and students aged 18 and over with high needs",4843]
["4a","485+ hours","students aged 18 and over who are not high needs",4006]
["4b","485 to 579 hours","16- and 17-year-olds and students aged 18 and over with high needs",4006]
[3,"385 to 484 hours","all students",3258]
[2,"300 to 384 hours","all students",2576]
[1,"up to 299 hours","all students","£4,843 \nproportion of band 5"]

{"sheet":"Admin","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
["Face to Face",null,"ESFA",null,"SC01",1517]
["Remote",null,"GLA",null,"SC02",1511]
["Blended",null,"Apprenticeship",null,"SC03",1456]
[null,null,null,null,"SC04",1519]
[null,null,null,null,"SC05",1524]
[null,null,null,null,"SC06",1522]
[null,null,null,null,"SC07",1523]
[null,null,null,null,"SC08",1516]
[null,null,null,null,"SC09",1525]
[null,null,null,null,"SC10",1509]