{"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":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,2,14,4],[3,2,3,7]]}
["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","February","March","April","May","June","July"]
[null,"NVQ Diploma in Performing Manufacturing Operations\n"]
[null,"Award in Introductory Metal Inert Gas Welding Skills\n"]
[]
["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,"NVQ Diploma in Performing Manufacturing Operations\n",null,1987,2583,0,{"$f":"E11-(D11/2)","v":1589.5},null,{"$f":"(E11*F11)+(G11*H11)","v":0},20,{"$f":"SUM((100-J11)/100)*I11","v":0},{"$f":"SUM(J11/100)*I11","v":0},{"$f":"G11*0.2","v":317.90000000000003}]
[null,"Award in Introductory Metal Inert Gas Welding Skills\n",null,300,390,0,240,null,0,20,{"$f":"SUM((100-J12)/100)*I12","v":0},{"$f":"SUM(J12/100)*I12","v":0},48]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I11:I12)","v":0},null,{"$f":"SUM(K11:K12)","v":0},{"$f":"SUM(L11:L12)","v":0}]
[]
[]
[null,null,"Funding",null,{"$f":"I13","v":0}]
[null,null,"Payment to Partner",null,{"$f":"K13","v":0},{"$f":"+E17/E16","v":{"$error":"#DIV/0!"}}]
[null,null,"Retained income",null,{"$f":"E16-E17","v":0}]

{"sheet":"Achievement Data","index":1,"n_rows":22,"n_cols":5,"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","NVQ Diploma in Performing Manufacturing Operations\n","Award in Introductory Metal Inert Gas Welding Skills\n"]
["Academic Year 2022/23","Number Enrolled",30]
[null,"Number Continuing ",25]
[null,"Achievement Rate  ",80]
[null,"Postiive Destinations",75]
[null,"Retention Rate ",96.7]
["Academic Year 2021/22","Number Enrolled ",60]
[null,"Number Continuing",0]
[null,"Achievement Rate",95]
[null,"Postiive Destinations",56]
[null,"Retention Rate",95]
["Academic Year 2020/21","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]