{"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":88,"n_cols":13,"rows_kept":88,"cut":false,"hidden":false,"merged":[[71,7,72,7],[81,7,82,7],[28,7,29,7],[30,7,31,7],[34,7,35,7],[73,7,74,7],[55,7,56,7],[57,7,59,7],[38,7,40,7],[52,7,53,7],[36,7,37,7],[77,7,78,7],[23,13,23,20],[23,21,23,24],[28,13,28,20],[28,21,28,24],[3,1,3,8],[20,7,21,7],[22,7,23,7],[18,7,19,7],[1,1,1,8],[8,2,9,7],[6,2,6,3],[11,3,11,7],[14,5,14,7],[10,2,10,7],[43,2,43,3],[16,2,16,3],[26,7,27,7],[24,2,24,3],[69,2,69,3],[50,7,51,7],[65,7,67,7],[44,2,45,7],[46,2,46,3],[60,7,61,7],[32,7,33,7]]}
[]
[null,"16-18 traineeships 2020 to 2021 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. ",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 2020 to 2021 16-18 traineeships and bursary 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.\n\nYou can find your 2019/20 delivery values on your funding summary reports in the download reports section of Submit Learner Data: https://submitlearnerdatabeta.fasst.org.uk/  \n\nYou can find your 2018/19 delivery values on The Hub: https://hub.fasst.org.uk/Pages/default.aspx  You need to click on the data returns tab and then the business reports tab to view your R14 ILR report."]
[]
[null,null,"You can find your current contract values on the contracts and agreements tile of Manage your Education and Skills Funding (MYESF): https://skillsfunding.service.gov.uk/home"]
[]
[null,null,null,"UKPRN",null,null,null,"You only need to complete your UKPRN and provider name if you plan to share your calculations with the ESFA."]
[]
[null,null,null,"Provider name"]
[]
[null,null,"2018/19 delivery"]
[]
[null,null,"a.","August 2018 to July 2019 (12 months) 16-18 traineeships delivery",null,null,null,"Enter the value of your 16-18 traineeships full year delivery between August 2018 and July 2019 in the 2018/19 funding year as recorded in your R14 data return.  Do not include bursary funding."]
[]
[null,null,"b.","February to July 2019 (6 months) 16-18 traineeships delivery",null,null,null,"Enter the value of your 16-18 traineeships delivery between February and July 2019 in the 2018/19 funding year as recorded in your R14 data return.  Do not include bursary funding."]
[]
[null,null,"c.","February to July 2019 (6 months) 16-18 traineeships bursary delivery",null,null,null,"Enter the value of your 16-18 traineeships bursary delivery between February and July 2019 in the 2018/19 funding year as recorded in your R14 data return."]
[]
[null,null,"2019/20 delivery and contract value"]
[]
[null,null,"d.","August 2019 to January 2020 (6 months) 16-18 traineeships delivery",null,null,null,"Enter the value of your 16-18 traineeships delivery between August 2019 and January 2020 in the 2019/20 funding year as recorded in your R06 data return.  Do not include bursary funding."]
[]
[null,null,"e.","August 2019 to January 2020 (6 months) 16-18 traineeships bursary delivery",null,null,null,"Enter the value of your 16-18 traineeships bursary delivery between August 2019 and January 2020 in the 2019/20 funding year as recorded in your R06 data return."]
[]
[null,null,"f.","Did you receive an increase to your 2019/20 16-18 traineeships contract value at PMP1?",null,null,null,"Select yes if you were offered an increase to your 16-18 traineeships contract value at performance-management point 1 (PMP1) of the 2019/20 funding year. Select no if your contract value stayed the same at PMP1.  We emailed your head of organisation in January 2020 if we awarded growth to your organisation."]
[]
[null,null,"g.","Did you receive an increase to your 2019/20 bursary contract value at PMP1?",null,null,null,"Select yes if you were offered an increase to your 16-18 traineeships bursary contract value at performance-management point 1 (PMP1) of the 2019/20 funding year. Select no if your contract value stayed the same at PMP1. "]
[]
[null,null,"h.","Current 2019/20 16-18 traineeships contract value (as at February 2020)",null,null,null,"Enter the value of your 2019/20 16-18 traineeships contract value as of February 2020.  Do not include your bursary allocation in this value."]
[]
[null,null,"i.","Current 2019/20 16-18 traineeships bursary contract value (as at February 2020)",null,null,null,"Enter the value of your 2019/20 16-18 traineeships bursary contract value as of February 2020. "]
[]
[null,null,"j.","Do you have a track record issue?",null,null,null,"Select yes if any of the following apply to you:\n- you are in formal intervention for minimum standards\n- you are in formal intervention for inspection \n- you have been issued with a notice for financial control\n- you have been issued with a notice to improve, additional conditions of funding or additional contractual obligations in relation to minimum quality standards for 19+ education and training\nSelect no if none of the above apply to your organisation."]
[]
[]
[]
[]
[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,"k.","February to July 2019 (6 months) 16-18 traineeships delivery",null,{"$f":"F21","v":0},null,"16-18 traineeships delivery between February and July 2019 in the 2018/19 funding year as recorded in your R14 data return (b). "]
[]
[null,null,"l.","August 2019 to January 2020 (6 months) 16-18 traineeships delivery",null,{"$f":"F27","v":0},null,"16-18 traineeships delivery between August 2019 and January 2020 in the 2019/20 funding year as recorded in your R06 data return (d)."]
[]
[null,null,"m.","Baseline",null,{"$f":"F51+F53","v":0},null,"Your allocation is based on 12 months of delivery (k + l)."]
[null,null,null,null,null,null,null,"If we increased your 2019/20 contract value at performance-management point 1 (PMP1) of the 2019/20 funding year, we will uplift your allocation to at least your current 2019/20 contract value (h)."]
[null,null,"n.","Adjustment for PMP1 growth",null,{"$f":"IF(AND(F31=\"Yes\",F55<F35),F35-F55,0)","v":0}]
[null,null,null,null,null,null,null,"If you delivered 16-18 traineeships in the 2018/19 funding year and/or as of R06 in 2019/20 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 2020/21 allocation (if you had a 2019/20 contract) through our business case process if you plan to start delivering 16-18 traineeships in the 2020/21 funding year."]
[null,null,"o.","Adjustment for £5,000 minimum allocation",null,{"$f":"IF(AND(F19+F27>0,F55+F57<5000),5000-(F55+F57),0)","v":0}]
[]
[null,null,"p.","Adjustment for track record issue",null,{"$f":"IF(AND(F39=\"yes\",(F55+F57+F59)>F35),F35-(F55+F57+F59),0)","v":0},null,"In line with our performance-management rules, we will not give you an allocation greater than your 2019/20 contract value if you have a track record issue (j)."]
[]
[null,null,"q.","Calculated 2020 to 2021 16-18 traineeships allocation",null,{"$f":"F55+F57+F59+F61","v":0},null,"This is your total allocation for the 2020/21 funding year."]
[]
[null,null,"r.","August 2020 to March 2021",null,{"$f":"ROUND(F63*66.45%,0)","v":0},null,"This is your allocation for periods 1 to 8 (August 2020 to March 2021) of the 2020/21 funding year."]
[null,null,null,null,null,null,null,"This is your allocation for periods 9 to 12 (April 2021 to July 2021) of the 2020/21 funding year."]
[null,null,"s.","April 2021 to July 2021",null,{"$f":"F63-F65","v":0}]
[]
[]
[null,null,"16-18 traineeships bursary allocation"]
[]
[null,null,"t.","February to July 2019 (6 months) 16-18 traineeships bursary delivery",null,{"$f":"F23","v":0},null,"16-18 traineeships bursary delivery between February and July 2019 in the 2018/19 funding year as recorded in your R14 data return (c). "]
[]
[null,null,"u.","August 2019 to January 2020 (6 months) 16-18 traineeships bursary delivery",null,{"$f":"F29","v":0},null,"16-18 traineeships bursary delivery between August 2019 and January 2020 in the 2019/20 funding year as recorded in your R06 data return (e)."]
[]
[null,null,"v.","Baseline",null,{"$f":"F72+F74","v":0},null,"Your allocation is based on 12 months of delivery (t + u)."]
[]
[null,null,"w.","Adjustment for PMP1 growth",null,{"$f":"IF(AND(F33=\"yes\",F76<F37),F37-F76,0)","v":0},null,"If we increased your 2019/20 16-18 traineeships bursary contract value at performance-management point 1 (PMP1) of the 2019/20 funding year, we will uplift your allocation to at least your current 2019/20 contract value (i)."]
[]
[null,null,"x.","Adjustment for £500 minimum allocation",null,{"$f":"IF(AND(F63>0,(F76+F78)<500),500-(F76+F78),0)","v":0},null,"If the allocation we have calculated for you is less than £500, we will uplift it to £500."]
[]
[null,null,"y.","Adjustment for track record issue",null,{"$f":"IF(AND(F76+F78+F80>F37,F39=\"yes\"),F37-(F76+F78+F80),0)","v":0},null,"In line with our performance-management rules, we will not give you an allocation greater than your 2019/20 contract value if you have a track record issue (j)."]
[]
[null,null,"z.","Calculated 2020 to 2021 16-18 traineeships bursary allocation",null,{"$f":"F76+F78+F80+F82","v":0},null,"This is your total allocation for the 2020/21 funding year."]
[]
[null,null,"aa.","August 2020 to March 2021",null,{"$f":"ROUND(F84*66.45%,0)","v":0},null,"This is your allocation for periods 1 to 8 (August 2020 to March 2021) of the 2020/21 funding year."]
[]
[null,null,"ab.","April 2021 to July 2021",null,{"$f":"F84-F86","v":0},null,"This is your allocation for periods 9 to 12 (April 2021 to July 2021) of the 2020/21 funding year."]