School Form for 10% Top Up.xlsx

	A	B	C	D	E	F	G	H	I	J	K	AZ
1	Template form to be provided to schools for manually recording meal uptake in January 2025
2	MIS supplier:	Enter
3	Date of return	Enter
4	School URN	Enter
5	School Name	Enter
6	Local Authority	Enter
7	Average of percentages across two collection dates	#DIV/0!
8	Notes
9	Notes
10	ADD DATE January 2025				Total of these figures should equate to total on Roll
11	Year group	Total Number on Roll	No. of FSM gov eligible pupils	No. of (eligible for Mayor’s meals)	Total meals taken by gov FSM eligible pupils	Total meals taken by non-gov FSM eligible KS2 pupils (Mayor funded meals)	No of packed lunches	Absences	Check (columns E - H should total number on roll)	% uptake by FSM eligible pupils	% uptake London Meals (Mayor funded meals)
12	Example	60	10	50	8	40	12	N/A	60	80%	80%
13	3								0	#DIV/0!	#DIV/0!	Notes for Schools: Each table currently shows an example row to show users the calculations. Please ensure the formulae are not tampered with as this could result in wrong figures being entered. Rows 13, 14, 15 and 16 display figures for each year group. Row 17 is the total of all the year groups, with cell J17 showing the total % uptake for the Mayor's meals. If schools do not have certain data they should enter N/A. If any pupils are not taking up government funding for FSM, or the Mayor's meals, or bringing in a packed lunch, please explain in Row 8/9 (notes), for example pupils temporarily homeschooled, etc.
14	4								0	#DIV/0!	#DIV/0!
15	5								0	#DIV/0!	#DIV/0!
16	6								0	#DIV/0!	#DIV/0!
17	Total School level %	0	0	0	0	0	0	0	0	#DIV/0!	#DIV/0!
18
19
20
21	ADD DATE March 2025				Total of these figures should equate to total on Roll
22	Year group	Total Number on Roll	No. of FSM gov eligible pupils	No. of (eligible for Mayor’s meals)	Total meals taken by gov FSM eligible pupils	Total meals taken by non-gov FSM eligible KS2 pupils (Mayor funded meals)	No of packed lunches	Absences	Check (columns E - H should total number on roll)	% uptake by FSM eligible pupils	% uptake London Meals (Mayor funded meals)
23	Example	60	10	50	8	40	12	N/A	60	80%	80%	Notes for Borough Officers: The sum of columns E to H should equal the total number on roll in column B. Column I provides a check for this and will be green if correct. If not green, please check the figures in B and E to H. The average of percentages across the two collection dates in row 7 should be used as the figure for the percentage uptake figure in column C of the borough OPS form.
24	3								0	#DIV/0!	#DIV/0!
25	4								0	#DIV/0!	#DIV/0!
26	5								0	#DIV/0!	#DIV/0!
27	6								0	#DIV/0!	#DIV/0!
28	Total School level %	0	0	0	0	0	0	0	0	#DIV/0!	#DIV/0!
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100