{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Requested Profile matrix","Achievement Data","Qualfications","Admin"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":11,"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":"Requested Profile matrix","index":0,"n_rows":42,"n_cols":71,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,5,4,5],[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,4,4],[2,6,4,6],[2,7,4,7],[2,9,2,21],[2,23,3,23],[2,24,3,24],[2,68,3,68],[2,69,3,69],[2,70,3,70],[30,9,30,11],[30,12,30,14],[30,15,30,17],[30,18,30,20],[2,26,2,37],[31,9,31,12],[31,13,31,16],[31,17,31,20],[2,39,2,50],[2,51,2,62]]}
[]
[]
["offer","Sector subject area","Framework/ Standard","Level","Maximum funding band value","minus achievement ","Duration","Monthly payment",null,"Starts Profile",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total in-year  funding","In-year \nCo-Funding",null,"Monthly profile",null,null,null,null,null,null,null,null,null,null,null,null,"Monthly profile 23/24",null,null,null,null,null,null,null,null,null,null,null,"Monthly profile 24/25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivery","Serviced","In-fill"]
[null,null,null,null,null,null,null,null,null,"Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Total",null,null,null,null,"Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul",null,"Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul",null,"23/24","24/25"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J6:J27)","v":0},{"$f":"SUBTOTAL(9,K6:K27)","v":0},12,0,0,0,12,0,0,0,12,0,{"$f":"SUBTOTAL(9,V6:V27)","v":36},null,{"$f":"SUBTOTAL(9,X6:X27)","v":222171.42857142858},{"$f":"SUBTOTAL(9,Y6:Y27)","v":11108.571428571429},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,{"$f":"SUM(BM6:BM25)","v":0},{"$f":"SUM(BN6:BN25)","v":0}]
["Accounting","Accounts / finance assistant","S",2,7000,{"$f":"E6*0.8","v":5600},15,{"$f":"F6/G6","v":373.33333333333331},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J6:U6)","v":0},null,{"$f":"SUM(AA6:AL6)","v":0},{"$f":"X6*0.05","v":0},null,{"$f":"SUM(J6)*H6","v":0},{"$f":"SUM(J6:K6)*H6","v":0},{"$f":"SUM(J6:L6)*H6","v":0},{"$f":"SUM(J6:M6)*H6","v":0},{"$f":"SUM(J6:N6)*H6","v":0},{"$f":"SUM(J6:O6)*H6","v":0},{"$f":"SUM(J6:P6)*H6","v":0},{"$f":"SUM(J6:Q6)*H6","v":0},{"$f":"SUM(J6:R6)*H6","v":0},{"$f":"SUM(J6:S6)*H6","v":0},{"$f":"SUM(J6:T6)*H6","v":0},{"$f":"SUM(J6:U6)*H6","v":0},null,{"$f":"AL6","v":0},{"$f":"AN6-(K6*$H6)","v":0},{"$f":"AO6-(L6*$H6)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AY6","v":0},{"$f":"AZ6","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AN6:AY6)","v":0},{"$f":"SUM(AZ6:BK6)","v":0},null,null,"Day-release","Yes","Yes"]
["Accounting",null,"S",3,12000,9600,18,533.33333333333337,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:U7)","v":0},null,{"$f":"SUM(AA7:AL7)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AL7","v":0},{"$f":"AN7","v":0},{"$f":"AO7","v":0},0,0,0,{"$f":"AS7-(J7*$H7)","v":0},{"$f":"AT7-(K7*$H7)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"BF7-(W7*$H7)","v":0},{"$f":"BG7","v":0},0,0,0,null,{"$f":"SUM(AN7:AY7)","v":0},{"$f":"SUM(AZ7:BK7)","v":0},null,null,"Day-release","Yes","Yes"]
["Accounting",null,null,4,8000,6400,18,355.55555555555554,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,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,"Day-release","Yes","Yes"]
["Business admin",null,"S",3,5000,4000,18,222.22222222222223,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AL9","v":0},{"$f":"AN9","v":0},0,0,0,0,{"$f":"AS9-(J9*$H9)","v":0},{"$f":"AT9-(K9*$H9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BG9","v":0},0,0,0,null,0,0,null,null,"Workshop","No","n/a"]
["Business admin",null,"S",2,3500,2800,15,186.66666666666666,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN10","v":0},0,0,0,0,{"$f":"AS10-(J10*$H10)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Workshop","No","n/a"]
["Business admin",null,null,3,4000,3200,15,213.33333333333334,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
["Education & early years",null,"S",2,4000,3200,15,213.33333333333334,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN12-(K12*$H12)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,0,null,0,0,0,0,null,0,0,null,null,"Workshop","No","n/a"]
["Education & early years",null,"S",3,7000,5600,18,311.11111111111109,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,{"$f":"SUM(J13)*H13","v":0},0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN13","v":0},0,0,0,0,{"$f":"AS13-(J13*$H13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BF13-(W13*$H13)","v":0},0,0,0,0,null,0,0,null,null,"Workshop","No","n/a"]
["Education & early years",null,"S",3,7000,5600,18,311.11111111111109,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,null,"Workshop","No","n/a"]
["Education & early years",null,"S",5,8000,6400,24,266.66666666666669,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN15","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"AY15-(J15*$H15)","v":0},{"$f":"AZ15-(K15*$H15)","v":0},0,0,0,0,0,0,0,0,0,0,null,0,0,null,null,"Workshop","No","n/a"]
["Management",null,"S",3,4500,3600,12,300,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J16:U16)","v":0},null,0,{"$f":"X16*0.05","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,"This area will be offered on a case by case depending on the job role and employer needs",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AZ16","v":0},{"$f":"BA16","v":0},0,0,0,0,0,0,0,0,0,null,0,0]
["Construction",null,"S",2,13000,10400,24,433.33333333333331,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(AA17:AL17)","v":0},{"$f":"X17*0.05","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN17","v":0},{"$f":"AO17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,0,0,null,null,"Day-release","Yes","No"]
["Construction",null,"S",2,13000,10400,24,433.33333333333331,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(AA18:AL18)","v":0},{"$f":"X18*0.05","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN18","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"AY18-(J18*$H18)","v":0},{"$f":"AZ18-(K18*$H18)","v":0},0,0,0,0,0,0,0,0,0,0,null,0,0,null,null,"Day-release","Yes","No"]
["Construction",null,"S",3,20000,16000,48,333.33333333333331,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(AA19:AL19)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BE19","v":0},0,0,0,0,0,null,0,0,null,null,"Day-release","Yes","No"]
["Construction",null,null,3,17478,13982.400000000001,36,388.40000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(AA20:AL20)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN20","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"Day-release","Yes","No"]
["Construction",null,null,3,14308,11446.400000000001,21,545.06666666666672,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,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,"Workshop","Yes","n/a"]
["Hair and Beauty ",null,"S",2,11000,8800,24,366.66666666666669,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(AA22:AL22)","v":0},{"$f":"X22*0.05","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN22","v":0},{"$f":"AO22","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AY22-(J22*$H22)","v":0},{"$f":"AZ22-(K22*$H22)","v":0},0,0,0,0,0,0,0,0,0,0,null,0,0,null,null,"Day-release","Yes","No"]
["Engineering",null,"S",2,12000,9600,24,400,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(AA23:AL23)","v":0},{"$f":"X23*0.05","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BE23","v":0},0,0,0,0,0,null,0,0,null,null,"Day-release","Yes","No"]
["Construction",null,"S",2,14000,11200,24,466.66666666666669,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J24:U24)","v":0},null,{"$f":"SUM(AA24:AL24)","v":0},{"$f":"X24*0.05","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"Day-release","Yes","No"]
["Digital ",null,"S",3,11000,{"$f":"E25*0.8","v":8800},18,488.88888888888891,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J25:U25)","v":0},null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"AN25","v":0},{"$f":"AO25","v":0},0,0,0,{"$f":"AS25-(J25*$H25)","v":0},{"$f":"AT25-(K25*$H25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,null,"Workshop","No","n/a"]
["Engineering",null,null,3,16000,{"$f":"E26*0.8","v":12800},36,{"$f":"F26/G26","v":355.55555555555554},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J26:U26)","v":0},null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(W26)*U26","v":0},{"$f":"SUM(W26:X26)*U26","v":0},{"$f":"SUM(W26:Y26)*U26","v":0},{"$f":"SUM(W26:Z26)*U26","v":0},{"$f":"SUM(W26:AA26)*U26","v":0},{"$f":"SUM(W26:AB26)*U26","v":0},{"$f":"SUM(W26:AC26)*U26","v":0},{"$f":"SUM(W26:AD26)*U26","v":0},{"$f":"SUM(W26:AE26)*U26","v":0},{"$f":"SUM(W26:AF26)*U26","v":0},{"$f":"SUM(W26:AG26)*U26","v":0},{"$f":"SUM(W26:AH26)*U26","v":0}]
["Engineering","Plate Welder",null,3,27000,{"$f":"E27*0.8","v":21600},21,{"$f":"F27/G27","v":1028.5714285714287},null,0,0,12,0,0,0,12,0,0,0,12,0,{"$f":"SUM(J27:U27)","v":36},null,{"$f":"SUM(AA27:AL27)","v":222171.42857142858},11108.571428571429,null,0,0,12342.857142857145,12342.857142857145,12342.857142857145,12342.857142857145,24685.71428571429,24685.71428571429,24685.71428571429,24685.71428571429,37028.571428571435,37028.571428571435,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J6:J27)","v":0},0,12,0,0,0,12,0,0,0,12,0,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J29:L29)","v":12},null,null,{"$f":"SUM(M29:O29)","v":0},null,null,{"$f":"SUM(P29:R29)","v":12},null,null,{"$f":"SUM(S29:U29)","v":12},null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J29:M29)","v":12},null,null,null,{"$f":"SUM(N29:Q29)","v":12},null,null,null,{"$f":"SUM(R29:U29)","v":12},null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Achievement Data","index":1,"n_rows":22,"n_cols":4,"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","Plate Welder Level 3 STO852\n"]
["Academic Year 2024/25 (predicted)","Number Enrolled",30]
[null,"Number Continuing ",25]
[null,"Achievement Rate  ",80]
[null,"Positive Destinations",75]
[null,"Retention Rate ",96.7]
["Academic Year 2023/24","Number Enrolled ",60]
[null,"Number Continuing",0]
[null,"Achievement Rate",95]
[null,"Positive Destinations",56]
[null,"Retention Rate",95]
["Academic Year 2022/23","Number Enrolled ",0]
[null,"Number Continuing",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":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]