{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["CRYSTAL_PERSIST","Controls 2023 to 2024","Student testing 2023 to 2024","B3_Temp","B3_Summary","Error summary Annex","DVs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":57,"comments":1,"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":"CRYSTAL_PERSIST","index":0,"n_rows":1,"n_cols":22,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<CrystalAddin Version=\"1\"/>"]

{"sheet":"Controls 2023 to 2024","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[15,2,15,3],[16,2,16,3],[1,6,2,6],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3]]}
["16 to 19 financial support: Controls questionnaire"]
["Provider:",null,"[Enter provider's legal entity name]",null,"Prepared by:  ","Date:  ","Reference:  "]
["UKPRN:  ",null,"[Enter UKPRN]",null,"Reviewed by:  ","Date:  "]
[null,null,"16 to 19 Bursary Fund","Free meals in further education","Funding guidance"]
["Allocation",null,null,null,"16-to-19-bursary-fund-guide-2023-to-2024-academic-year"]
["Year-to-date payments",null,null,null,"Free meals in further education funded institutions guide: 2023 to 2024 academic year "]
["No.","Category","Control question",null,"Provider's response","Control satisfactory?","Comments"]
[1,"General","a) Do you use your 16 to 19 Bursary Fund or free meals in further education funding allocation to cover administrative costs?\n\nb) What percentage of the funding do you use?\n\nc) Please state the amount.",null,"a)\n\nb)\n\nc)"]
[{"$f":"A8+1","v":2},"General","a) Describe your controls for ensuring that you do not carry forward funding for discretionary bursary and/or free meals in further education over more than one funding year.\n\nb) Where you hold unspent funds from any year prior to the 2021 to 2022 academic year, have you contacted ESFA to arrange to return these funds?\n\nc) Please state the amount.",null,"a)\n\nb)\n\nc)"]
[3,"General","Describe your controls for ensuring all learners meet the general eligibility criteria for the programme, namely:\n\na) Age\n\nb) Eligible education provision\n\nc) Residency",null,"a)\n\nb)\n\nc)"]
[4,"General","Describe your arrangements for administering the 16 to 19 Bursary Fund and free meals in further education.\n\nPlease include:\n- the names and roles of the members of staff involved\n- the administration of payments"]
[5,"16 to 19 Bursary Fund","Describe your procedures for evidencing bursary applications and awards.  For example:\n\n1. Bursary for vulnerable groups and discretionary bursary fund\na) Student funding application forms\nb) Evidence of assessments of students' actual financial need\n\n2. Bursary for vulnerable groups only\na) Evidence to confirm eligibility to receive bursary for vulnerable groups\nb) Evidence to confirm payments received from the Student Bursary Support Service\nc) Procedures for ensuring that you do not claim for duplicate students or students no longer in education\n\n3. Discretionary bursary only\na) Evidence to confirm eligibility to receive discretionary bursary (age and household income)\nb) Evidence of income used to assess eligibility\nc) Receipts for purchases made on behalf of students, such as equipment\n\n4. Emergency food\na) Evidence of the number of students supported in this way\nb) Evidence of the number of days this support is given\nc) Evidence of the £s value of support given to each student along with the rationale for the food support\nd) Evidence of signed confirmation of receipt of funding by the student, if actual spend receipts are not obtained",null,"1a)\n\n1b)\n\n2a)\n\n2b)\n\n2c)\n\n3a)\n\n3b)\n\n3c)\n\n4a)\n\n4b)\n\n4c)\n\n4d)"]
[6,"16 to 19 Bursary Fund","Have you developed and published a policy and made it available to young people?\n\nDoes your policy describe how you will administer and distribute your 16 to 19 Bursary Fund?\n\nDoes it include the eligibility criteria and the type of support available?\n\nPlease provide a copy.\n\nNote: Block, blanket or flat rate payments are not permitted.  Payments should be based on actual financial need."]
[7,"16 to 19 Bursary Fund","a) How do you raise awareness of the 16 to 19 Bursary Fund when marketing your courses to young people, for example, by working in partnership with local authorities or with feeder schools?\n\nb) State how you make the policy available sufficiently early for students to use in order to make an informed decision on which provider to attend.\n\nc) In particular, where you offer provision from more than one location, or through subcontractors, how do you ensure that any student attending such provision can apply for a bursary?",null,"a)\n\nb)\n\nc)"]
[8,"16 to 19 Bursary Fund","Describe your controls for ensuring the accurate recording, storage and security of 16 to 19 Bursary Fund evidence and data?"]
[9,"16 to 19 Bursary Fund","How often do you review the 16 to 19 Bursary Fund guidance, available on the GOV.UK website, to ensure that you keep up-to-date with any changes?"]
[10,"16 to 19 Bursary Fund","a) Describe any conditions that students need to meet in order to receive payment, for example, relating to attendance or standards of behaviour.\n\nb) How do you ensure that students are aware of such conditions, for example, with a signed agreement?",null,"a)\n\nb)"]
[11,"16 to 19 Bursary Fund: Discretionary bursary","a) Describe your controls for ensuring that you award discretionary bursaries only to students facing financial barriers to participation, for example, the costs of transport, meals, books, equipment and other course-related items.\n\nb) Describe also your controls for ensuring that you have appropriately assessed applications and documented actual financial need, and that you have taken into account any allowances or other sources of financial support.",null,"a)\n\nb)"]
[12,"Free meals in further education","Describe your administrative procedures for recording free meals in further education applications and awards, including:\n \na) checks to ensure that there is a fully and accurately completed application form for each student\n\nb) checks on students’ eligibility, covering age and receipt of qualifying benefits (student or parents)\n\nc) recording in the ILR the Learner funding and monitoring type code/value FME2 for all eligible students who have taken up a free meal at any point during the academic year",null,"a)\n\nb)\n\nc)"]
[13,"Free meals in further education","a)  Have you enhanced the £2.53 free meals funding rate from the 16 to 19 Bursary Fund or other sources?\n\nb)  How do you ensure and evidence value for money and reasonableness of this enhancement?\n\nc)  If you have adopted a significant variation to the standard rate, what is your rationale and have you documented it?\n\nd)  How do you ensure that there is no negative impact on the discretionary bursary fund and that money remains available to support students facing other barriers to participation?",null,"a)\n\nb)\n\nc)\n\nd)"]
[14,"Free meals in further education","Describe how you make available free meals provision for students when they are off-site, for example, attending a work placement or work experience?"]
[15,"Free meals in further education","Do you make cash payments to students?\n\nIf so, describe how you ensure that you make such payments in accordance with the exceptional circumstances set out in the guidance?"]

{"sheet":"Student testing 2023 to 2024","index":2,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Transaction no."]
["Learner reference number"]
["Student name (Family name & Given names)"]
["Bursary for vulnerable groups"]
["Discretionary bursary"]
["Free meals in further education"]
["Total funding claim"]
["Test",null,null,"Issue","Critical factor",{"$f":"SUM(F9:F30)","v":0},"Test satisfied\nYes/No","Comments, by exception"]
["General"]
[1,"Is there evidence confirming that the student satisfies the general eligibility criteria?","i","Eligibility for funding","The student satisfies the eligibility criteria relating to age, residency and type of provision.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G10:IV10),2)=1),--($G10:IV10=\"No\"))","v":0}]
[2,"Is there a fully completed application form, signed by all parties?","i","Application","The student, or someone acting on their behalf, must complete an application.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G11:IV11),2)=1),--($G11:IV11=\"No\"))","v":0}]
["All bursaries"]
[3,"Is there evidence that the student has seen and agreed to the conditions of the bursary?","i","Bursary conditions agreed","Providers should retain evidence that a student has seen and agreed to the conditions.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G13:IV13),2)=1),--($G13:IV13=\"No\"))","v":0}]
["Bursary for vulnerable groups"]
[4,"Is there evidence confirming that the student satisfies the specific eligibility criteria for receipt of a bursary for vulnerable groups?","i","Eligibility for specific financial support (bursary for vulnerable groups)","The student satisfies the eligibility criteria for bursay for vulnerable groups:\n- In care\n- Care leaver\n- Receiving Income Support, or Universal Credit because they are financially supporting themselves or financially supporting themselves and someone who is dependent on them and living with them such as a child or partner\n- Receiving Disability Living Allowance or Personal Independence Payments in their own right as well as Employment and Support Allowance or Universal Credit in their own right.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G15:IV15),2)=1),--($G15:IV15=\"No\"))","v":0}]
[5,"Is there evidence of an assessment of financial need, based on the amount the learner actually needs in order to participate?","i","Assessment of need (bursary for vulnerable groups)","The provider must undertake an assessment of the student's financial need.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G16:IV16),2)=1),--($G16:IV16=\"No\"))","v":0}]
[6,"Has the provider awarded the bursary for vulnerable groups in accordance with the funding guidance?","i","Correct award (bursary for vulnerable groups)","The bursary for vulnerable groups can pay up to £1,200 for a course of 30 weeks or more, or a proportionate amount if the course is fewer than 30 weeks.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G17:IV17),2)=1),--($G17:IV17=\"No\"))","v":0}]
[7,"Is the bursary for vulnerable groups award for eligible items?","i","Eligible items (bursary for vulnerable groups)","The student can receive bursary for vulnerable groups only for specific types of costs such as meals, travel, books and equipment.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G18:IV18),2)=1),--($G18:IV18=\"No\"))","v":0}]
[8,"Has the provider paid the bursary for vulnerable groups to the student as agreed?","i","Payment (bursary for vulnerable groups)","The provider should make payments to the student as per the agreed method, normally in kind or in cash.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G19:IV19),2)=1),--($G19:IV19=\"No\"))","v":0}]
["Discretionary bursary"]
[9,"Is there evidence confirming that the student satisfies the provider's specific eligibility criteria for receipt of a discretionary bursary, as per its bursary policy?","i","Eligibility for specific financial support (discretionary bursary)","The student must satisfy the conditions described in the provider's bursary policy, which should include household income and may also involve other factors.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G21:IV21),2)=1),--($G21:IV21=\"No\"))","v":0}]
[10,"Is there evidence of the provider's individual assessment of the student's financial need?","i","Assessment of need (discretionary bursary)","The provider must undertake an assessment of the student's financial need.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G22:IV22),2)=1),--($G22:IV22=\"No\"))","v":0}]
[11,"Is the discretionary bursary award for eligible items?","i","Eligible items (discretionary bursary)","The student can receive discretionary bursary only for specific types of costs such as meals, travel, books and equipment.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G23:IV23),2)=1),--($G23:IV23=\"No\"))","v":0}]
[12,"Has the provider given the value of the discretionary bursary to the student (in cash or in kind) as agreed?","i","Payment (discretionary bursary)","The provider should make payments to the student as per the agreed method, normally in kind or in cash.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G24:IV24),2)=1),--($G24:IV24=\"No\"))","v":0}]
[13,"Has the provider used the discretionary bursary to provide emergency food support?","i","Payment \n(Emergency food)","The provider should make payments to the student as agreed.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G25:IV25),2)=1),--($G25:IV25=\"No\"))","v":0}]
["Free meals in further education"]
[14,"Is there evidence confirming that the student is, or has parents that are, in receipt of one or more of the eligible benefits listed in the funding guidance?","i","Benefits status (free meals in further education)","To be eligible for free meals in further education funding, the student (or a parent) must be in receipt of a qualifying benefit.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G27:IV27),2)=1),--($G27:IV27=\"No\"))","v":0}]
[15,"Has the provider given the value of the free meals to the student as agreed?","i","Provision of meal or equivalent (free meals in further education)","The provider must provide meals to the student, or the value of the meal as per the agreed method, normally voucher or credit but cash in exceptional circumstances.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G28:IV28),2)=1),--($G28:IV28=\"No\"))","v":0}]
[16,"Does the evidence of the student's attendance support the value of payments?","i","Attendance (free meals in further education)","The student receives a free meal for each day that they attend their study programme.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G29:IV29),2)=1),--($G29:IV29=\"No\"))","v":0}]
[17,"Has the provider recorded the Learner funding and monitoring type code/value FME2 in the ILR?","i","ILR completed (free meals in further education)","Providers should record in the ILR a student's eligibility for free meals in further education where the student has taken up free meals at any point during the teaching year.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G30:IV30),2)=1),--($G30:IV30=\"No\"))","v":0}]

{"sheet":"B3_Temp","index":3,"n_rows":3,"n_cols":35,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bursary for vulnerable groups",null,null,null,"Discretionary bursary",null,null,null,"Free meals in further education",null,null,null,"Total"]
["No.","Original WP Ref.","Learner name (if applicable)","Learner reference no. (if applicable)","Critical factor issue","Critical factor description","Details of potential error","Provider's response to error","Accept provider's response?","Error cleared?","Has a (sub-) population of learners with the same error characteristics as the error in the main sample been identified?","Describe the (sub-) population affected","Has (sub-) population been 100% tested and assurance gained?","Additional testing working paper ref.","Error categorisation","Report issue?\n(Yes/No)","Action plan ref.","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Total funding error (£)","Errors corrected?\n(include file references where applicable)"]
[{"$f":"ROW()-2","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AD3=0,AE3=0,AG3<>0),\"Under-claim\",IF(K3=\"N/A\",\"N/A\",IF(K3=\"Not found in main sample\",\"PDSAT/Other\",IF(K3=\"No\",\"Random\",IF(AND(K3=\"Yes\",M3=\"Yes\"),\"Ring-fenced\",IF(OR(ISBLANK(K3),ISBLANK(M3)),\"\",\"Random\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(MOD(COLUMN($R3:$AC3),4)=2),--($R3:$AC3))","v":0},{"$f":"SUMPRODUCT(--(MOD(COLUMN($R3:$AC3),4)=3),--($R3:$AC3))","v":0},{"$f":"SUMPRODUCT(--(MOD(COLUMN($R3:$AC3),4)=0),--($R3:$AC3))","v":0},{"$f":"SUMPRODUCT(--(MOD(COLUMN($R3:$AC3),4)=1),--($R3:$AC3))","v":0},{"$f":"SUM(AD3:AF3)","v":0}]

{"sheet":"B3_Summary","index":4,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["B3 summary by critical factor","Bursary for vulnerable groups",null,"Discretionary bursary",null,"Free meals in further education",null,"Total errors"]
["Critical factor issue","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)"]
[null,{"$f":"COUNTIFS(B3_CF,$A3,ISE_VB,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_VB)+SUMIF(B3_CF,$A3,OSE_VB)+SUMIF(B3_CF,$A3,PFY_VB)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_DB,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_DB)+SUMIF(B3_CF,$A3,OSE_DB)+SUMIF(B3_CF,$A3,PFY_DB)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_FM,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_FM)+SUMIF(B3_CF,$A3,OSE_FM)+SUMIF(B3_CF,$A3,PFY_FM)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT(--(MOD(COLUMN($B3:$G3),2)=0),--($B3:$G3))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT(--(MOD(COLUMN($B3:$G3),2)=1),--($B3:$G3))","v":{"$error":"#REF!"}}]

{"sheet":"Error summary Annex","index":5,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Funding errors summary"]
[]
["Ref","Description","Bursary for vulnerable groups","Discretionary bursary","Free meals in further education","TOTAL"]
["a","Value of the population",0,0,0,{"$f":"SUM(C4:E4)","v":0}]
["b","Value of the sample",0,0,0,{"$f":"SUM(C5:E5)","v":0}]
["c","Value of actual errors from the sample",0,0,0,{"$f":"SUM(C6:E6)","v":0}]
[]
["d","Sample error rate",{"$f":"IFERROR(C6/C5,0)","v":0},{"$f":"IFERROR(D6/D5,0)","v":0},{"$f":"IFERROR(E6/E5,0)","v":0},{"$f":"IFERROR(F6/F5,0)","v":0},"c ÷ b"]
[]
["e","Value of actual errors outside the sample but within the population",0,0,0,{"$f":"SUM(C10:E10)","v":0}]
["f","Value of actual errors relating to prior funding years",0,0,0,{"$f":"SUM(C11:E11)","v":0}]
[]
["g","Total actual errors",{"$f":"C6+C10+C11","v":0},{"$f":"D6+D10+D11","v":0},0,{"$f":"SUM(C13:E13)","v":0},"c + e + f"]
[]
["h","Has an estimated error been agreed?","NO","NO","NO"]
[]
["i","Value of estimated errors",{"$f":"ROUND(IF(C15=\"NO\",0,(IF(C10>(C8*C4-C6),0,(C8*C4-(C6+C10))))),0)","v":0},0,0,{"$f":"SUM(C17:E17)","v":0},"calculated estimate\n(d x a) - c - e"]
[]
["j","Total funds at risk to be reported, and corrected or recovered",{"$f":"C13+C17","v":0},{"$f":"D13+D17","v":0},0,{"$f":"SUM(C19:E19)","v":0},"g + i"]
[]
["Values rounded to the nearest £."]
["Where they are calculated based on the sample error rate, estimated error values (i) do not include the actual errors within the population (c + e) to ensure that the same errors are not counted twice."]
[]
["Notation lines"]
[]
["k","Under-claims",0,0,0,{"$f":"SUM(C26:E26)","v":0}]

{"sheet":"DVs","index":6,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Workbook_open completed",0,null,"Yes","16 to 18","Levy"]
[null,null,null,"No","19+","Non-levy"]
["B3_Endrow (Last used row of B3)",3,null,"N/A","16 to 18 and 19+","Levy and Non-levy"]
["B3_Newlastrow",null,null,null,null,"Check funding type"]
[]
["B3_Lastrow value when Name_Ranges were last run",3]
[]
[]
["1650 hours (T level Band 9)",6108]
["1500 hours (T level Band 8)",5584]
["1300 hours (T level Band 7)",5061]
["1100 hours (T level Band 6)",4363]
["540+ hours (Band 5)",4188]
["450+ hours (Band 4a)",3455]
["450 to 539 hours (Band 4b)",3455]
["360 to 449 hours (Band 3)",2827]
["280 to 359 hours (Band 2)",2234]
["Up to 279 hours (Band 1)",4188]
["T Level is in year 3, not funded",0]
["Band 9",6108]
["Band 8",5584]
["Band 7",5061]
["Band 6",4363]
["Band 5",4188]
["Band 4a",3455]
["Band 4b",3455]
["Band 3",2827]
["Band 2",2234]
["Band 1",4188]
["band 9",6108]
["band 8",5584]
["band 7",5061]
["band 6",4363]
["band 5",4188]
["band 4a",3455]
["band 4b",3455]
["band 3",2827]
["band 2",2234]
["band 1",4188]
["Not funded",0]