{"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":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,2,16,4]]}
["Please complete both sections, adding rows if needed for separate cohorts to reflect the delivery profile proposed"]
["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","April","June"]
["EN10 6AE","Extended Certificate in Employability Skills",12,12]
["EN10 6AE","Certificate for Introduction to Customer Service",12,12]
["EN10 6AE","Award for Door Supervisors in the Private Security Industry",12,12]
[]
["B- Financial Information"]
["Site Postcode","Qualification Title / Learning Aim","Programme Duration (weeks)","Unweighted rate £","Fully Funded Rate /Weighted rate £","Fully Funded Numbers","Co-Funded Rate £","Co-Funded Numbers","Total Funding","Management Fee %","Total Payment to Partner","Total Retained Income to College","Achievement payment"]
["EN10 6AE","Extended Certificate in Employability Skills",null,null,null,null,{"$f":"E12-(D12/2)","v":0},null,{"$f":"(E12*F12)+(G12*H12)","v":0},20,{"$f":"SUM((100-J12)/100)*I12","v":0},{"$f":"SUM(J12/100)*I12","v":0},{"$f":"G12*0.2","v":0}]
["EN10 6AE","Certificate for Introduction to Customer Service",null,null,null,null,{"$f":"E13-(D13/2)","v":0},null,{"$f":"(E13*F13)+(G13*H13)","v":0},20,{"$f":"SUM((100-J13)/100)*I13","v":0},{"$f":"SUM(J13/100)*I13","v":0},{"$f":"G13*0.2","v":0}]
["EN10 6AE","Award for Door Supervisors in the Private Security Industry",null,null,null,null,{"$f":"E14-(D14/2)","v":0},null,{"$f":"(E14*F14)+(G14*H14)","v":0},20,0,0,{"$f":"G14*0.2","v":0}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I12:I14)","v":0},null,{"$f":"SUM(K12:K14)","v":0},{"$f":"SUM(L12:L14)","v":0}]
[]
[]
[null,null,"Funding",null,{"$f":"I15","v":0}]
[null,null,"Payment to Partner",null,{"$f":"K15","v":0},{"$f":"+E19/E18","v":{"$error":"#DIV/0!"}}]
[null,null,"Retained income",null,{"$f":"E18-E19","v":0}]

{"sheet":"Achievement Data","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,6,0],[7,0,11,0],[12,0,16,0],[1,0,1,1]]}
[null,null,"Example"]
["Qualification Title / Learning Aim",null,"Certificate in Examples - 601/0000/X","Extended Certificate in Employability Skills","Certificate for Introduction to Customer Service","Award for Door Supervisors in the Private Security Industry"]
["Academic Year 2024/25","Number Enrolled",30]
[null,"Number Continuing ",25]
[null,"Achievement Rate  ",80]
[null,"Postiive Destinations",75]
[null,"Retention Rate ",96.7]
["Academic Year 2023/24","Number Enrolled ",60]
[null,"Number Continuing",0]
[null,"Achievement Rate",95]
[null,"Postiive Destinations",56]
[null,"Retention Rate",95]
["Academic Year 2022/23","Number Enrolled ",0]
[null,"Number Continuing",0]
[null,"Achievement Rate",0]
[null,"Postiive 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":11,"n_cols":7,"rows_kept":11,"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 hours",45]
["Delivery model","Blended"]
["Awarding Organisation Claims Status ","Direct Claims"]
["HRC only fields"]
["College Level","SC03"]
["Cost Code",{"$f":"IFERROR(VLOOKUP(B9,Admin!$E$2:$F$11,2,FALSE),\"\")","v":1456},{"$f":"IFERROR(VLOOKUP(C9,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D9,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E9,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(F9,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,Admin!$E$2:$F$11,2,FALSE),\"\")","v":""}]
["HRC Offering code","TPL506X"]

{"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]