{"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":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[30,2,30,4],[3,2,3,5]]}
["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","April","May ","June","July"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,null,null,null,null,0,{"$f":"E19-(D19/2)","v":0},null,{"$f":"(E19*F19)+(G19*H19)","v":0},20,{"$f":"SUM((100-J19)/100)*I19","v":0},{"$f":"SUM(J19/100)*I19","v":0},{"$f":"G19*0.2","v":0}]
[null,null,null,null,null,0,{"$f":"E20-(D20/2)","v":0},null,{"$f":"(E20*F20)+(G20*H20)","v":0},20,{"$f":"SUM((100-J20)/100)*I20","v":0},{"$f":"SUM(J20/100)*I20","v":0},{"$f":"G20*0.2","v":0}]
[null,null,null,null,null,0,{"$f":"E21-(D21/2)","v":0},null,{"$f":"(E21*F21)+(G21*H21)","v":0},20,0,0,{"$f":"G21*0.2","v":0}]
[null,null,null,null,null,0,{"$f":"E22-(D22/2)","v":0},null,{"$f":"(E22*F22)+(G22*H22)","v":0},20,0,0,{"$f":"G22*0.2","v":0}]
[null,null,null,null,null,0,{"$f":"E23-(D23/2)","v":0},null,{"$f":"(E23*F23)+(G23*H23)","v":0},20,0,0,{"$f":"G23*0.2","v":0}]
[null,null,null,null,null,0,{"$f":"E24-(D24/2)","v":0},null,{"$f":"(E24*F24)+(G24*H24)","v":0},20,0,0,{"$f":"G24*0.2","v":0}]
[null,null,null,null,null,0,{"$f":"E25-(D25/2)","v":0},null,{"$f":"(E25*F25)+(G25*H25)","v":0},20,{"$f":"SUM((100-J25)/100)*I25","v":0},{"$f":"SUM(J25/100)*I25","v":0},{"$f":"G25*0.2","v":0}]
[null,null,null,null,null,0,{"$f":"E26-(D26/2)","v":0},null,{"$f":"(E26*F26)+(G26*H26)","v":0},20,0,0,0]
[null,null,null,null,null,0,{"$f":"E27-(D27/2)","v":0},null,{"$f":"(E27*F27)+(G27*H27)","v":0},20,0,0,0]
[null,null,null,null,null,0,{"$f":"E28-(D28/2)","v":0},null,{"$f":"(E28*F28)+(G28*H28)","v":0},20,0,0,0]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I19:I28)","v":0},null,{"$f":"SUM(K19:K28)","v":0},{"$f":"SUM(L19:L28)","v":0}]
[]
[]
[null,null,"Funding",null,{"$f":"I29","v":0}]
[null,null,"Payment to Partner",null,{"$f":"K29","v":0},{"$f":"+E33/E32","v":{"$error":"#DIV/0!"}}]
[null,null,"Retained income",null,{"$f":"E32-E33","v":0}]

{"sheet":"Achievement Data","index":1,"n_rows":22,"n_cols":3,"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"]
["Academic Year 2021/22","Number Enrolled",30]
[null,"Number Continuing ",25]
[null,"Achievement Rate  ",80]
[null,"Postiive Destinations",75]
[null,"Retention Rate ",96.7]
["Academic Year 2020/21","Number Enrolled ",60]
[null,"Number Continuing",0]
[null,"Achievement Rate",95]
[null,"Postiive Destinations",56]
[null,"Retention Rate",95]
["Academic Year 2019/20","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]