{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["FormFA1","AcademicYears","Major Source of Funding Codes","Macros","Instructions","FundingOfficeUseOnly"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"FormFA1","index":0,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[[3,3,3,7],[2,3,2,7],[4,3,4,4],[4,6,4,7]]}
["56040","FORM FA1","FOR ALL FEE AWARDS - COMPLETE ALL WHITE BOXES",null,"DO NOT SENT REPLACEMENT FORMS",null,null,"ver FA1.0027"]
["56041",null,"ENSURE FUNDS ARE AVAILABLE","Email form to fa1@leeds.ac.uk "]
["56042",null,"*Name of School/Service:"]
[null,null,"*School/Service Contact Name(s):"]
[null,null,"*School/Service Contact Email:",null,null,"*Contact Phone Number:"]
[null,null,"Award Type:","Fee Award",null,"* GL Code:"]
[null,null,"*Apply awards to academic year:",null,null,"* Major Source of Funding:"]
[]
[null,null,null,{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,0)),MONTH(EDATE(D8,0)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,0)),MONTH(EDATE(D8,0)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,0)),MONTH(EDATE(D8,0)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,0)),MONTH(EDATE(D8,0)),\"01\"),\"\"))))","v":""},{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,1)),MONTH(EDATE(D8,1)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,1)),MONTH(EDATE(D8,1)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,1)),MONTH(EDATE(D8,1)),\"01\"),IF(((D6=A5)=TRUE),\"\",\"\"))))","v":""},null,null,{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,2)),MONTH(EDATE(D8,2)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,2)),MONTH(EDATE(D8,2)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,2)),MONTH(EDATE(D8,2)),\"01\"),IF(((D6=A5)=TRUE),\"\",\"\"))))","v":""}]
[null,null,null,{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,3)),MONTH(EDATE(D8,3)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,3)),MONTH(EDATE(D8,3)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,3)),MONTH(EDATE(D8,3)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,3)),MONTH(EDATE(D8,3)),\"01\"),\"\"))))","v":""},{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,4)),MONTH(EDATE(D8,4)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,4)),MONTH(EDATE(D8,4)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,4)),MONTH(EDATE(D8,4)),\"01\"),IF(((D6=A5)=TRUE),\"\",\"\"))))","v":""},null,null,{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,5)),MONTH(EDATE(D8,5)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,5)),MONTH(EDATE(D8,5)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,5)),MONTH(EDATE(D8,5)),\"01\"),IF(((D6=A5)=TRUE),\"\",\"\"))))","v":""}]
[null,"UserID: stumm","*=Mandatory Field",{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,6)),MONTH(EDATE(D8,6)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,6)),MONTH(EDATE(D8,6)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,6)),MONTH(EDATE(D8,6)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,6)),MONTH(EDATE(D8,6)),\"01\"),\"\"))))","v":""},{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,7)),MONTH(EDATE(D8,7)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,7)),MONTH(EDATE(D8,7)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,7)),MONTH(EDATE(D8,7)),\"01\"),IF(((D6=A5)=TRUE),\"\",\"\"))))","v":""},null,null,{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,8)),MONTH(EDATE(D8,8)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,8)),MONTH(EDATE(D8,8)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,8)),MONTH(EDATE(D8,8)),\"01\"),IF(((D6=A5)=TRUE),\"\",\"\"))))","v":""}]
[null,{"$f":"\"TOTAL TO PAY: \" & TEXT(SUM(E14:E63),\"£#,##0.00\")","v":"TOTAL TO PAY: £0.00"},null,{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,9)),MONTH(EDATE(D8,9)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,9)),MONTH(EDATE(D8,9)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,9)),MONTH(EDATE(D8,9)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,9)),MONTH(EDATE(D8,9)),\"01\"),\"\"))))","v":""},{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,10)),MONTH(EDATE(D8,10)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,10)),MONTH(EDATE(D8,10)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,10)),MONTH(EDATE(D8,10)),\"01\"),IF(((D6=A5)=TRUE),\"\",\"\"))))","v":""},null,null,{"$f":"IF(E8<(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,11)),MONTH(EDATE(D8,11)),\"01\"),IF(((D6=A5)=TRUE),DATE(YEAR(EDATE(D8,11)),MONTH(EDATE(D8,11)),\"01\"),\"\"))),\"\",(IF(((D6=A4)=TRUE),DATE(YEAR(EDATE(D8,11)),MONTH(EDATE(D8,11)),\"01\"),IF(((D6=A5)=TRUE),\"\",\"\"))))","v":""}]
[null,"*Student ID ↓","*Last Name of Student ↓","*Cost Object ↓","*Amount ↓","Notes for Authoriser (optional) ↓","GL Code ↓","Major Source of Funding ↓"]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B14),ISBLANK($C14),ISBLANK($D14),ISBLANK($E14),ISBLANK($F14)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B14),ISBLANK($C14),ISBLANK($D14),ISBLANK($E14),ISBLANK($F14)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B15),ISBLANK($C15),ISBLANK($D15),ISBLANK($E15),ISBLANK($F15)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B15),ISBLANK($C15),ISBLANK($D15),ISBLANK($E15),ISBLANK($F15)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B16),ISBLANK($C16),ISBLANK($D16),ISBLANK($E16),ISBLANK($F16)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B16),ISBLANK($C16),ISBLANK($D16),ISBLANK($E16),ISBLANK($F16)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B17),ISBLANK($C17),ISBLANK($D17),ISBLANK($E17),ISBLANK($F17)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B17),ISBLANK($C17),ISBLANK($D17),ISBLANK($E17),ISBLANK($F17)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B18),ISBLANK($C18),ISBLANK($D18),ISBLANK($E18),ISBLANK($F18)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B18),ISBLANK($C18),ISBLANK($D18),ISBLANK($E18),ISBLANK($F18)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B19),ISBLANK($C19),ISBLANK($D19),ISBLANK($E19),ISBLANK($F19)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B19),ISBLANK($C19),ISBLANK($D19),ISBLANK($E19),ISBLANK($F19)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B20),ISBLANK($C20),ISBLANK($D20),ISBLANK($E20),ISBLANK($F20)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B20),ISBLANK($C20),ISBLANK($D20),ISBLANK($E20),ISBLANK($F20)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B21),ISBLANK($C21),ISBLANK($D21),ISBLANK($E21),ISBLANK($F21)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B21),ISBLANK($C21),ISBLANK($D21),ISBLANK($E21),ISBLANK($F21)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B22),ISBLANK($C22),ISBLANK($D22),ISBLANK($E22),ISBLANK($F22)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B22),ISBLANK($C22),ISBLANK($D22),ISBLANK($E22),ISBLANK($F22)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B23),ISBLANK($C23),ISBLANK($D23),ISBLANK($E23),ISBLANK($F23)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B23),ISBLANK($C23),ISBLANK($D23),ISBLANK($E23),ISBLANK($F23)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B24),ISBLANK($C24),ISBLANK($D24),ISBLANK($E24),ISBLANK($F24)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B24),ISBLANK($C24),ISBLANK($D24),ISBLANK($E24),ISBLANK($F24)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B25),ISBLANK($C25),ISBLANK($D25),ISBLANK($E25),ISBLANK($F25)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B25),ISBLANK($C25),ISBLANK($D25),ISBLANK($E25),ISBLANK($F25)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B26),ISBLANK($C26),ISBLANK($D26),ISBLANK($E26),ISBLANK($F26)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B26),ISBLANK($C26),ISBLANK($D26),ISBLANK($E26),ISBLANK($F26)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B27),ISBLANK($C27),ISBLANK($D27),ISBLANK($E27),ISBLANK($F27)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B27),ISBLANK($C27),ISBLANK($D27),ISBLANK($E27),ISBLANK($F27)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B28),ISBLANK($C28),ISBLANK($D28),ISBLANK($E28),ISBLANK($F28)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B28),ISBLANK($C28),ISBLANK($D28),ISBLANK($E28),ISBLANK($F28)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B29),ISBLANK($C29),ISBLANK($D29),ISBLANK($E29),ISBLANK($F29)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B29),ISBLANK($C29),ISBLANK($D29),ISBLANK($E29),ISBLANK($F29)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B30),ISBLANK($C30),ISBLANK($D30),ISBLANK($E30),ISBLANK($F30)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B30),ISBLANK($C30),ISBLANK($D30),ISBLANK($E30),ISBLANK($F30)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B31),ISBLANK($C31),ISBLANK($D31),ISBLANK($E31),ISBLANK($F31)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B31),ISBLANK($C31),ISBLANK($D31),ISBLANK($E31),ISBLANK($F31)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B32),ISBLANK($C32),ISBLANK($D32),ISBLANK($E32),ISBLANK($F32)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B32),ISBLANK($C32),ISBLANK($D32),ISBLANK($E32),ISBLANK($F32)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B33),ISBLANK($C33),ISBLANK($D33),ISBLANK($E33),ISBLANK($F33)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B33),ISBLANK($C33),ISBLANK($D33),ISBLANK($E33),ISBLANK($F33)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B34),ISBLANK($C34),ISBLANK($D34),ISBLANK($E34),ISBLANK($F34)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B34),ISBLANK($C34),ISBLANK($D34),ISBLANK($E34),ISBLANK($F34)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B35),ISBLANK($C35),ISBLANK($D35),ISBLANK($E35),ISBLANK($F35)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B35),ISBLANK($C35),ISBLANK($D35),ISBLANK($E35),ISBLANK($F35)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B36),ISBLANK($C36),ISBLANK($D36),ISBLANK($E36),ISBLANK($F36)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B36),ISBLANK($C36),ISBLANK($D36),ISBLANK($E36),ISBLANK($F36)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B37),ISBLANK($C37),ISBLANK($D37),ISBLANK($E37),ISBLANK($F37)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B37),ISBLANK($C37),ISBLANK($D37),ISBLANK($E37),ISBLANK($F37)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B38),ISBLANK($C38),ISBLANK($D38),ISBLANK($E38),ISBLANK($F38)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B38),ISBLANK($C38),ISBLANK($D38),ISBLANK($E38),ISBLANK($F38)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B39),ISBLANK($C39),ISBLANK($D39),ISBLANK($E39),ISBLANK($F39)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B39),ISBLANK($C39),ISBLANK($D39),ISBLANK($E39),ISBLANK($F39)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B40),ISBLANK($C40),ISBLANK($D40),ISBLANK($E40),ISBLANK($F40)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B40),ISBLANK($C40),ISBLANK($D40),ISBLANK($E40),ISBLANK($F40)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B41),ISBLANK($C41),ISBLANK($D41),ISBLANK($E41),ISBLANK($F41)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B41),ISBLANK($C41),ISBLANK($D41),ISBLANK($E41),ISBLANK($F41)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B42),ISBLANK($C42),ISBLANK($D42),ISBLANK($E42),ISBLANK($F42)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B42),ISBLANK($C42),ISBLANK($D42),ISBLANK($E42),ISBLANK($F42)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B43),ISBLANK($C43),ISBLANK($D43),ISBLANK($E43),ISBLANK($F43)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B43),ISBLANK($C43),ISBLANK($D43),ISBLANK($E43),ISBLANK($F43)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B44),ISBLANK($C44),ISBLANK($D44),ISBLANK($E44),ISBLANK($F44)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B44),ISBLANK($C44),ISBLANK($D44),ISBLANK($E44),ISBLANK($F44)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B45),ISBLANK($C45),ISBLANK($D45),ISBLANK($E45),ISBLANK($F45)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B45),ISBLANK($C45),ISBLANK($D45),ISBLANK($E45),ISBLANK($F45)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B46),ISBLANK($C46),ISBLANK($D46),ISBLANK($E46),ISBLANK($F46)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B46),ISBLANK($C46),ISBLANK($D46),ISBLANK($E46),ISBLANK($F46)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B47),ISBLANK($C47),ISBLANK($D47),ISBLANK($E47),ISBLANK($F47)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B47),ISBLANK($C47),ISBLANK($D47),ISBLANK($E47),ISBLANK($F47)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B48),ISBLANK($C48),ISBLANK($D48),ISBLANK($E48),ISBLANK($F48)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B48),ISBLANK($C48),ISBLANK($D48),ISBLANK($E48),ISBLANK($F48)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B49),ISBLANK($C49),ISBLANK($D49),ISBLANK($E49),ISBLANK($F49)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B49),ISBLANK($C49),ISBLANK($D49),ISBLANK($E49),ISBLANK($F49)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B50),ISBLANK($C50),ISBLANK($D50),ISBLANK($E50),ISBLANK($F50)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B50),ISBLANK($C50),ISBLANK($D50),ISBLANK($E50),ISBLANK($F50)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B51),ISBLANK($C51),ISBLANK($D51),ISBLANK($E51),ISBLANK($F51)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B51),ISBLANK($C51),ISBLANK($D51),ISBLANK($E51),ISBLANK($F51)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B52),ISBLANK($C52),ISBLANK($D52),ISBLANK($E52),ISBLANK($F52)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B52),ISBLANK($C52),ISBLANK($D52),ISBLANK($E52),ISBLANK($F52)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B53),ISBLANK($C53),ISBLANK($D53),ISBLANK($E53),ISBLANK($F53)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B53),ISBLANK($C53),ISBLANK($D53),ISBLANK($E53),ISBLANK($F53)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B54),ISBLANK($C54),ISBLANK($D54),ISBLANK($E54),ISBLANK($F54)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B54),ISBLANK($C54),ISBLANK($D54),ISBLANK($E54),ISBLANK($F54)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B55),ISBLANK($C55),ISBLANK($D55),ISBLANK($E55),ISBLANK($F55)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B55),ISBLANK($C55),ISBLANK($D55),ISBLANK($E55),ISBLANK($F55)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B56),ISBLANK($C56),ISBLANK($D56),ISBLANK($E56),ISBLANK($F56)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B56),ISBLANK($C56),ISBLANK($D56),ISBLANK($E56),ISBLANK($F56)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B57),ISBLANK($C57),ISBLANK($D57),ISBLANK($E57),ISBLANK($F57)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B57),ISBLANK($C57),ISBLANK($D57),ISBLANK($E57),ISBLANK($F57)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B58),ISBLANK($C58),ISBLANK($D58),ISBLANK($E58),ISBLANK($F58)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B58),ISBLANK($C58),ISBLANK($D58),ISBLANK($E58),ISBLANK($F58)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B59),ISBLANK($C59),ISBLANK($D59),ISBLANK($E59),ISBLANK($F59)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B59),ISBLANK($C59),ISBLANK($D59),ISBLANK($E59),ISBLANK($F59)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B60),ISBLANK($C60),ISBLANK($D60),ISBLANK($E60),ISBLANK($F60)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B60),ISBLANK($C60),ISBLANK($D60),ISBLANK($E60),ISBLANK($F60)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B61),ISBLANK($C61),ISBLANK($D61),ISBLANK($E61),ISBLANK($F61)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B61),ISBLANK($C61),ISBLANK($D61),ISBLANK($E61),ISBLANK($F61)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B62),ISBLANK($C62),ISBLANK($D62),ISBLANK($E62),ISBLANK($F62)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B62),ISBLANK($C62),ISBLANK($D62),ISBLANK($E62),ISBLANK($F62)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK($B63),ISBLANK($C63),ISBLANK($D63),ISBLANK($E63),ISBLANK($F63)),\"\",IF(ISBLANK($G$6),\"\",$G$6))","v":""},{"$f":"IF(AND(ISBLANK($B63),ISBLANK($C63),ISBLANK($D63),ISBLANK($E63),ISBLANK($F63)),\"\",IF(ISBLANK($G$7),\"\",$G$7))","v":""}]

{"sheet":"AcademicYears","index":1,"n_rows":164,"n_cols":9,"rows_kept":164,"cut":false,"hidden":true,"merged":[]}
[1,{"$f":"YEAR(DATE($I$1,1,1))+ROUNDUP(A1/2,0)","v":2018},{"$f":"IF(MOD(A1,2)=1,YEAR(DATE($B1+1,1,1)),\"2055\")","v":2019},{"$f":"B1 & RIGHT(C1,2)","v":"201819"},null,null,null,"BASE YEAR:",2017]
[2,{"$f":"YEAR(DATE($I$1,1,1))+ROUNDUP(A2/2,0)","v":2018},{"$f":"IF(MOD(A2,2)=1,YEAR(DATE($B2+1,1,1)),\"2055\")","v":"2055"},{"$f":"B2 & RIGHT(C2,2)","v":"201855"}]
[3,2019,2020,"201920"]
[4,2019,"2055","201955"]
[5,2020,2021,"202021"]
[6,2020,"2055","202055"]
[7,2021,2022,"202122"]
[8,2021,"2055","202155"]
[9,2022,2023,"202223"]
[10,2022,"2055","202255"]
[11,2023,2024,"202324"]
[12,2023,"2055","202355"]
[13,2024,2025,"202425"]
[14,2024,"2055","202455"]
[15,2025,2026,"202526"]
[16,2025,"2055","202555"]
[17,2026,2027,"202627"]
[18,2026,"2055","202655"]
[19,2027,2028,"202728"]
[20,2027,"2055","202755"]
[21,2028,2029,"202829"]
[22,2028,"2055","202855"]
[23,2029,2030,"202930"]
[24,2029,"2055","202955"]
[25,2030,2031,"203031"]
[26,2030,"2055","203055"]
[27,2031,2032,"203132"]
[28,2031,"2055","203155"]
[29,2032,2033,"203233"]
[30,2032,"2055","203255"]
[31,2033,2034,"203334"]
[32,2033,"2055","203355"]
[33,2034,2035,"203435"]
[34,2034,"2055","203455"]
[35,2035,2036,"203536"]
[36,2035,"2055","203555"]
[37,2036,2037,"203637"]
[38,2036,"2055","203655"]
[39,2037,2038,"203738"]
[40,2037,"2055","203755"]
[41,2038,2039,"203839"]
[42,2038,"2055","203855"]
[43,2039,2040,"203940"]
[44,2039,"2055","203955"]
[45,2040,2041,"204041"]
[46,2040,"2055","204055"]
[47,2041,2042,"204142"]
[48,2041,"2055","204155"]
[49,2042,2043,"204243"]
[50,2042,"2055","204255"]
[51,2043,2044,"204344"]
[52,2043,"2055","204355"]
[53,2044,2045,"204445"]
[54,2044,"2055","204455"]
[55,2045,2046,"204546"]
[56,2045,"2055","204555"]
[57,2046,2047,"204647"]
[58,2046,"2055","204655"]
[59,2047,2048,"204748"]
[60,2047,"2055","204755"]
[61,2048,2049,"204849"]
[62,2048,"2055","204855"]
[63,2049,2050,"204950"]
[64,2049,"2055","204955"]
[65,2050,2051,"205051"]
[66,{"$f":"YEAR(DATE($I$1,1,1))+ROUNDUP(A66/2,0)","v":2050},{"$f":"IF(MOD(A66,2)=1,YEAR(DATE($B66+1,1,1)),\"2055\")","v":"2055"},{"$f":"B66 & RIGHT(C66,2)","v":"205055"}]
[67,2051,2052,"205152"]
[68,2051,"2055","205155"]
[69,2052,2053,"205253"]
[70,2052,"2055","205255"]
[71,2053,2054,"205354"]
[72,2053,"2055","205355"]
[73,2054,2055,"205455"]
[74,2054,"2055","205455"]
[75,2055,2056,"205556"]
[76,2055,"2055","205555"]
[77,2056,2057,"205657"]
[78,2056,"2055","205655"]
[79,2057,2058,"205758"]
[80,2057,"2055","205755"]
[81,2058,2059,"205859"]
[82,2058,"2055","205855"]
[83,2059,2060,"205960"]
[84,2059,"2055","205955"]
[85,2060,2061,"206061"]
[86,2060,"2055","206055"]
[87,2061,2062,"206162"]
[88,2061,"2055","206155"]
[89,2062,2063,"206263"]
[90,2062,"2055","206255"]
[91,2063,2064,"206364"]
[92,2063,"2055","206355"]
[93,2064,2065,"206465"]
[94,2064,"2055","206455"]
[95,2065,2066,"206566"]
[96,2065,"2055","206555"]
[97,2066,2067,"206667"]
[98,2066,"2055","206655"]
[99,2067,2068,"206768"]
[100,2067,"2055","206755"]
[101,2068,2069,"206869"]
[102,2068,"2055","206855"]
[103,2069,2070,"206970"]
[104,2069,"2055","206955"]
[105,2070,2071,"207071"]
[106,2070,"2055","207055"]
[107,2071,2072,"207172"]
[108,2071,"2055","207155"]
[109,2072,2073,"207273"]
[110,2072,"2055","207255"]
[111,2073,2074,"207374"]
[112,2073,"2055","207355"]
[113,2074,2075,"207475"]
[114,2074,"2055","207455"]
[115,2075,2076,"207576"]
[116,2075,"2055","207555"]
[117,2076,2077,"207677"]
[118,2076,"2055","207655"]
[119,2077,2078,"207778"]
[120,2077,"2055","207755"]
[121,2078,2079,"207879"]
[122,2078,"2055","207855"]
[123,2079,2080,"207980"]
[124,2079,"2055","207955"]
[125,2080,2081,"208081"]
[126,2080,"2055","208055"]
[127,2081,2082,"208182"]
[128,2081,"2055","208155"]
[129,2082,2083,"208283"]
[130,{"$f":"YEAR(DATE($I$1,1,1))+ROUNDUP(A130/2,0)","v":2082},{"$f":"IF(MOD(A130,2)=1,YEAR(DATE($B130+1,1,1)),\"2055\")","v":"2055"},{"$f":"B130 & RIGHT(C130,2)","v":"208255"}]
[131,2083,2084,"208384"]
[132,2083,"2055","208355"]
[133,2084,2085,"208485"]
[134,2084,"2055","208455"]
[135,2085,2086,"208586"]
[136,2085,"2055","208555"]
[137,2086,2087,"208687"]
[138,2086,"2055","208655"]
[139,2087,2088,"208788"]
[140,2087,"2055","208755"]
[141,2088,2089,"208889"]
[142,2088,"2055","208855"]
[143,2089,2090,"208990"]
[144,2089,"2055","208955"]
[145,2090,2091,"209091"]
[146,2090,"2055","209055"]
[147,2091,2092,"209192"]
[148,2091,"2055","209155"]
[149,2092,2093,"209293"]
[150,2092,"2055","209255"]
[151,2093,2094,"209394"]
[152,2093,"2055","209355"]
[153,2094,2095,"209495"]
[154,2094,"2055","209455"]
[155,2095,2096,"209596"]
[156,2095,"2055","209555"]
[157,2096,2097,"209697"]
[158,2096,"2055","209655"]
[159,2097,2098,"209798"]
[160,2097,"2055","209755"]
[161,2098,2099,"209899"]
[162,2098,"2055","209855"]
[163,2099,2100,"209900"]
[164,2099,"2055","209955"]

{"sheet":"Major Source of Funding Codes","index":2,"n_rows":50,"n_cols":2,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["01","No award or financial backing"]
["02","Award assessed by English or Welsh LEA & paid in full by LA or by the SLC (includes EU students assessed by SLC)"]
["03","Paid in full by Student Awards Agency for Scotland/Student Loans Company (SAAS/SLC); includes where fee is paid directly to provider"]
["04","Paid in full by DfE(NI)/Northern Ireland Education & Library Boards (via Student Loans Company) (includes EU students in NI)"]
["06","Local Government - Channel Islands & Isle of Man/Scottish FE Bursaries"]
["07","Fee waiver under government unemployed students scheme"]
["08","British Academy"]
["09","Fees paid under part-time graduate apprentice study programme"]
["11","Biotechnology & Biological Sciences Research Council (BBSRC)"]
["12","Medical Research Council (MRC)"]
["13","Natural Environment Research Council (NERC)"]
["14","Engineering & Physical Sciences Research Council (EPSRC)"]
["15","Economic & Social Research Council (ESRC)"]
["17","Arts & Humanities Research Council (AHRC)"]
["18","Science & Technology Facilities Council (STFC)"]
["19","Research council - not specified"]
["22","International agency"]
["23","Cancer Research UK"]
["24","Wellcome Trust"]
["25","Other Association of Medical Research Charities (AMRC) charity"]
["26","Other charitable foundation"]
["30","NCTL"]
["31","Departments of Health/NHS/Social Care"]
["32","Departments of Social Services"]
["34","Other HM government departments/public bodies"]
["35","Scholarship of HM forces"]
["36","Scottish Enterprise Network/Highlands & Islands Enterprise/Local Enterprise Companies (LECs)"]
["37","LEA training grants scheme"]
["38","Department of Agriculture & Rural Development for Northern Ireland (DARDNI)"]
["39","Scottish Local Authority - discretionary award"]
["41","EU Commission (EC)"]
["42","Overseas student award from HM government/British Council"]
["43","Overseas government"]
["44","Department for International Development"]
["45","Overseas provider"]
["46","Overseas industry or commerce"]
["47","Other overseas funding"]
["48","Other overseas - repayable loan"]
["49","ORSAS"]
["52","Mix of student & SLC (following assessment by English or Welsh LA, or SLC for EU students studying in England and Wales)"]
["53","Mix of student & Student Awards Agency for Scotland/Student Loans Company(SAAS/SLC)"]
["54","Mix of student & DfE(NI)/Northern Ireland Education & Library Boards (via Student Loans Company)"]
["61","UK industry/commerce"]
["71","Absent for year"]
["81","Student's employer"]
["91","Provider own funds"]
["96","FE student - New Deal"]
["97","Other"]
["98","No fees"]
["99","Not known"]

{"sheet":"Macros","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["You need to enable macros in order to be able to use this form! You may need to re-open this spreadsheet after enabling macros."]

{"sheet":"Instructions","index":4,"n_rows":43,"n_cols":1,"rows_kept":43,"cut":false,"hidden":false,"merged":[[15,0,15,18],[32,0,32,18],[37,0,37,18],[42,0,42,18]]}
["Student awards form FA1 process: Schools and departments"]
["Last updated: 16/07/2019 GF"]
[]
["If you have any problems filling out the below form, please contact us via email at funding@leeds.ac.uk or by telephoning (0113) 343 2007"]
[]
["Master Forms available"]
["·       FA1: tuition fee award (scholarship, fee bursary, fee discount, fee waiver) from a single cost object number (account)"]
["Summary of procedure"]
["1.     Create file from the master form"]
["2.     Send the file via an authorised signatory to fa1@leeds.ac.uk."]
["3.     Amending an award"]
[]
[]
["1. Create file from master form"]
[]
["All formatting should be preserved in the sheets when completing them. All of the white boxes must be completed. A number of the white boxes carries a brief description of the action that needs to be taken. Please find below an example of a completed form:-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["It is important that all of the mandatory fields in the header and the body of the form are completed, in order for the request to be processed."]
[]
["2. Send file via authorised signatory"]
[]
["The file must be attached to an email and sent to fa1@leeds.ac.uk by an authorised signatory. The form is approved and verified (equivalent of a signature) by this act of the authorised signatory sending the form."]
[]
["3. Amending an award"]
[]
["Payment amendment form"]
["If there is a change to be made to an award, such as a reduction in the award amount, a change to the payment date or a change to the cost object number, then Payment Amendment Form would need to be completed. An authorised signatory must be copied into the email - unless they send the email - so that the change is made with the awareness of the authorised signatory."]
["Please note: this form has been passed on to Jay McIntyre, Becky Whitaker, Rachel Greenbank, and Noemy Ellis-Martin who will circulate to the relevant colleagues."]
[]
[]
["New FA1"]
["Any changes except increasing the award are dealt with via a Payment Amendment Form. Any changes increasing the award are achieved by sending a new FA1 for the additional amount. An authorised signatory must be copied into the email - unless they send the email - so that the change is made with the awareness of the authorised signatory."]

{"sheet":"FundingOfficeUseOnly","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}