{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["16-18 traineeships calculator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"16-18 traineeships calculator","index":0,"n_rows":81,"n_cols":13,"rows_kept":81,"cut":false,"hidden":false,"merged":[[66,7,67,7],[74,7,75,7],[27,7,28,7],[29,7,30,7],[31,7,32,7],[68,7,69,7],[50,7,51,7],[52,7,54,7],[35,7,37,7],[47,7,48,7],[33,7,34,7],[22,13,22,20],[22,21,22,24],[27,13,27,20],[27,21,27,24],[3,1,3,8],[19,7,20,7],[21,7,22,7],[17,7,18,7],[1,1,1,8],[8,2,9,7],[6,2,6,3],[17,21,17,24],[17,13,17,20],[10,3,10,7],[13,5,13,7],[40,2,40,3],[15,2,15,3],[25,7,26,7],[23,2,23,3],[64,2,64,3],[45,7,46,7],[60,7,62,7],[41,2,42,7],[43,2,43,3],[55,7,56,7]]}
[]
[null,"16-18 traineeships 2019 to 2020 allocations calculator (for providers that do not receive 16-19 funding only)"]
[]
[null,"Disclaimer: \nThis is a tool to help you understand how your allocation has been calculated, it is not your allocation value.  Your digital allocation statement on MyESF sets out your allocation values.\nPlease read the information on our 19+ funding allocations page and our technical guidance before using this calculator.  \nIf you have experienced a data submission problem that has significantly affected the allocation we have calculated for you then you can raise a business case through your territorial team contact.  Please see the business case section of our 19+ funding allocations page for more information about this process.  We will not accept requests for additional funding not linked to technical errors.  ",null,null,null,null,null,null,null,null,null,null,"Grant"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Contract for service"]
[null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Your information",null,null,null,null,null,null,null,"No","Yes"]
[null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,"Complete the yellow cells and the calculation steps will populate to show how we have worked the value of your 2019 to 2020 16-18 traineeships allocation.  If you have merged with another organisation then you need to include the total for all of the organisations involved in the merger in the values you provide below."]
[]
[]
[null,null,null,"UKPRN"]
[]
[null,null,null,"Provider legal name"]
[]
[null,null,"2017/18 delivery"]
[]
[null,null,"a.","August 2017 to July 2018 (12 months) 16-18 traineeships delivery",null,null,null,"Enter the value of your 16-18 traineeships delivery between August 2017 and July 2018 in the 2017/18 funding year as recorded in your R14 data return.  Do not include bursary funding."]
[]
[null,null,"b.","January 2018 to July 2018 (7 months) 16-18 traineeships delivery",null,null,null,"Enter the value of your 16-18 traineeships delivery between January and July 2018 in the 2017/18 funding year as recorded in your R14 data return.  Do not include bursary funding."]
[]
[null,null,"c.","January 2018 to July 2018 (7 months) 16-18 traineeships bursary delivery",null,null,null,"Enter the value of your 16-18 traineeships bursary delivery between January and July 2018 in the 2017/18 funding year as recorded in your R14 data return."]
[]
[null,null,"2018/19 delivery and contract value"]
[]
[null,null,"d.","August 2018 to December 2018 (5 months) 16-18 traineeships delivery",null,null,null,"Enter the value of your 16-18 traineeships delivery between August and December 2018 in the 2018/19 funding year as recorded in your R05 data return.  Do not include bursary funding."]
[]
[null,null,"e.","August 2018 to December 2018 (5 months) 16-18 traineeships bursary delivery",null,null,null,"Enter the value of your 16-18 traineeships bursary delivery between August and December 2018 in the 2018/19 funding year as recorded in your R05 data return."]
[]
[null,null,"f.","Did you receive an increase to your 2018/19 16-18 traineeships contract value at PMP1?",null,null,null,"Select yes if you submitted a 16-18 traineeship growth request and it was accepted at performance-management point 1 (PMP1) of the 2018/19 funding year. Select no if your contract value was reduced or stayed the same at PMP1."]
[]
[null,null,"g.","Current 2018/19 16-18 traineeships contract value",null,null,null,"Enter the value of your 2018/19 16-18 traineeships contract value as of February 2019.  Do not include your bursary allocation in this value."]
[]
[null,null,"h.","Current 2018/19 16-18 traineeships bursary contract value",null,null,null,"Enter the value of your 2018/19 16-18 traineeships bursary contract value as of February 2019.  If you do not have a bursary contract value then enter £0."]
[]
[null,null,"i.","Do you have a track record issue?",null,null,null,"Select yes if you are under notice for failure of inspection or financial control or if you are not under a notice to improve, additional conditions of funding or additional contractual obligations in relation to minimum quality standards for 19+ education and training."]
[]
[]
[]
[]
[null,null,"Calculation steps "]
[null,null,"This section will automatically populate when you complete the your information section above."]
[]
[null,null,"16-18 traineeships allocation"]
[]
[null,null,"j.","January 2018 to July 2018 (7 months) 16-18 traineeships delivery",null,{"$f":"F20","v":0},null,"16-18 traineeships delivery between January and July 2018 in the 2017/18 funding year as recorded in your R14 data return (b). "]
[]
[null,null,"k.","August 2018 to December 2018 (5 months) 16-18 traineeships delivery",null,{"$f":"F26","v":0},null,"16-18 traineeships delivery between August and December 2018 in the 2018/19 funding year as recorded in your R05 data return (d)."]
[]
[null,null,"l.","Baseline",null,{"$f":"F46+F48","v":0},null,"Your allocation is based on 12 months of delivery (j + k)."]
[null,null,null,null,null,null,null,"We will not give you an allocation greater than your 2018/19 contract value if you did not receive growth at performance-management point 1 (PMP1) of the 2018/19 funding year."]
[null,null,"m.","Adjustment to align with PMP1 no change/reduction",null,{"$f":"IF(AND(F30=\"no\",F50>F32),F32-F50,0)","v":0}]
[null,null,null,null,null,null,null,"If you delivered 16-18 traineeships in the 2017/18 funding year and/or as of R05 in 2018/19 funding year then we have calculated a 2019/20 allocation of at least £5,000 for you.  If you did not deliver in this period then you will not receive an allocation.  You can request a 2019/20 allocation through our business case process if you plan to start delivering 16-18 traineeships in the 2019/20 funding year."]
[null,null,"n.","Adjustment for £5,000 minimum allocation",null,{"$f":"IF(AND(F18+F20+F26>0,F52+F50<5000),5000-(F50+F52),0)","v":0}]
[]
[null,null,"o.","Adjustment for track record issue",null,{"$f":"IF(AND(F36=\"yes\",(F50+F52+F54)>F32),F32-(F50+F52+F54),0)","v":0},null,"In line with our performance-management rules, we will not give you an allocation greater than your 2018/19 contract value if you have a track record issue (i)."]
[]
[null,null,"p.","Calculated 2019 to 2020 16-18 traineeships allocation",null,{"$f":"F50+F52+F54+F56","v":0},null,"This is your total allocation for the 2019/20 funding year."]
[]
[null,null,"q.","August 2019 to March 2020",null,{"$f":"ROUND(F58*66.45%,0)","v":0},null,"This is your allocation for periods 1 to 8 (August 2019 to March 2020) of the 2019/20 funding year."]
[null,null,null,null,null,null,null,"This is your allocation for periods 9 to 12 (April 2020 to July 2020) of the 2019/20 funding year."]
[null,null,"r.","April 2020 to July 2020",null,{"$f":"F58-F60","v":0}]
[]
[]
[null,null,"16-18 traineeships bursary allocation"]
[]
[null,null,"s.","January 2018 to July 2018 (7 months) 16-18 traineeships bursary delivery",null,{"$f":"F22","v":0},null,"16-18 traineeships bursary delivery between January and July 2018 in the 2017/18 funding year as recorded in your R14 data return (c). "]
[]
[null,null,"t.","August 2018 to December 2018 (5 months) 16-18 traineeships bursary delivery",null,{"$f":"F28","v":0},null,"16-18 traineeships delivery between August and December 2018 in the 2018/19 funding year as recorded in your R05 data return (e)."]
[]
[null,null,"u.","Baseline",null,{"$f":"F67+F69","v":0},null,"Your allocation is based on 12 months of delivery (s + t)."]
[]
[null,null,"v.","Adjustment for £500 minimum allocation",null,{"$f":"IF(AND(F58>0,F71<500),500-F71,0)","v":0},null,"If the 2019/20 allocation we have calculated for you is less than £500, we will uplift it to £500."]
[]
[null,null,"w.","Adjustment for track record issue",null,{"$f":"IF(AND(F71+F73>F34,F36=\"yes\"),F34-(F71+F73),0)","v":0},null,"In line with our performance-management rules, we will not give you an allocation greater than your 2018/19 contract value if you have a track record issue (i)."]
[]
[null,null,"x.","Calculated 2019 to 2020 16-18 traineeships bursary allocation",null,{"$f":"F71+F73+F75","v":0},null,"This is your total allocation for the 2019/20 funding year."]
[]
[null,null,"y.","August 2019 to March 2020",null,{"$f":"ROUND(F77*66.45%,0)","v":0},null,"This is your allocation for periods 1 to 8 (August 2019 to March 2020) of the 2019/20 funding year."]
[]
[null,null,"z.","April 2020 to July 2020",null,{"$f":"F77-F79","v":0},null,"This is your allocation for periods 9 to 12 (April 2020 to July 2020) of the 2019/20 funding year."]