After struggling to find a flexible seating plan that did what I needed it to do I created this. You can use 9-1 grades for the New GCSE.
Simply copy and paste the 'seat' in the top-left hand corner onto the spreadsheet to create the layout of your classroom.
On the data input sheet copy or type your data - it is currently set up to show name, target, current grade, PP, SEN, HP (health plan), and above, on or below target. All but target, current grade and AOB can be changed to show any other data without messing up the formatting. If you unhide a row on the seating plan you can also type text based information in the info section for example groups, access arrangements etc.
On the seating plan just change the top left number on each seat to match that student on the data sheet e.g. 1 will look up student 1, 2 will look up student 2. The information will be shown on the seating plan with colour coding for on, above, below target, SEN and PP.
It all uses very simple Excel formulas so easy to change to meet your needs.