{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":8,"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":"Sheet1","index":0,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Funding errors summary"]
[null,null,"16 to 19 financial support"]
["Ref","Description","16 to 19 Bursary Fund:\nBursary for vulnerable groups","16 to 19 Bursary Fund:\nDiscretionary bursaries","Free meals in further education","TOTAL"]
["a.","Value of the population",null,null,null,{"$f":"SUM(C4:E4)","v":0}]
["b.","Value of the sample",{"$f":"ROUND(SUM(SV_VB),0)","v":0},{"$f":"ROUND(SUM(SV_DB),0)","v":0},{"$f":"ROUND(SUM(SV_FMFE),0)","v":0},{"$f":"SUM(C5:E5)","v":0}]
["c.","Value of actual errors from the sample",{"$f":"ROUND(SUM(SE_VB),0)","v":0},{"$f":"ROUND(SUM(SE_DB),0)","v":0},{"$f":"ROUND(SUM(SE_FMFE),0)","v":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},0,"c / b"]
[]
["e.","Value of actual errors outside the sample but within the population",{"$f":"ROUND(SUM(IF(B3_FSType=\"Vulnerable bursary\",OSE)),0)","v":0},{"$f":"ROUND(SUM(IF(B3_FSType=\"Discretionary bursary\",OSE)),0)","v":0},{"$f":"ROUND(SUM(IF(B3_FSType=\"Free meals in further education\",OSE)),0)","v":0},{"$f":"SUM(C10:E10)","v":0}]
[]
["f.","Total actual errors",{"$f":"C6+C10","v":0},0,0,{"$f":"SUM(C12:E12)","v":0},"c + e"]
[]
["g.","Has an estimated error been agreed?","NO","NO","NO"]
[]
["h.","Value of estimated errors",{"$f":"ROUND(IF(C14=\"NO\",0,(IF(C10>(C8*C4-C6),0,(C8*C4-(C6+C10))))),0)","v":0},{"$f":"ROUND(IF(D14=\"NO\",0,(IF(D10>(D8*D4-D6),0,(D8*D4-(D6+D10))))),0)","v":0},{"$f":"ROUND(IF(E14=\"NO\",0,(IF(E10>(E8*E4-E6),0,(E8*E4-(E6+E10))))),0)","v":0},{"$f":"SUM(C16:E16)","v":0},"calculated estimate\n(d x a)-c-e"]
[]
["j.","Total funds at risk to be reported, and corrected or recovered",{"$f":"C12+C16","v":0},{"$f":"D12+D16","v":0},0,{"$f":"SUM(C18:E18)","v":0},"f + h"]
[]
["k.","Overall error rate\n(applicable following 100% testing, where sample error rate ≥ 5%)",{"$f":"IF(C8>=0.05,IFERROR(C18/C4,0),\"\")","v":""},{"$f":"IF(D8>=0.05,IFERROR(D18/D4,0),\"\")","v":""},"",null,"j / a"]
[]
["Values rounded to the nearest £."]
["Where they are calculated based on the sample error rate, estimated error values (h) do not include the actual errors within the population (c + e) to ensure that the same errors are not counted twice."]