{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FormMA1","Macros","Instructions","FundingOfficeUseOnly"],"not_rendered":{"charts":0,"images":6,"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":"FormMA1","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,3,3,5],[0,2,0,3],[2,3,2,5]]}
["Yes, pay even if not registered","FORM MA1","FOR ALL MAINTENANCE AWARDS - COMPLETE ALL WHITE BOXES",null,"DO NOT SEND REPLACEMENT FORMS","ver MA1.0035"]
["No",null,"ENSURE FUNDS ARE AVAILABLE","Email form to ma1@leeds.ac.uk "]
["Maintenance - Single Instalment",null,"*Name of School/Service:"]
["Maintenance - Monthly",null,"*School/Service Contact Name(s):"]
["Maintenance - Quarterly",null,"*Contact Phone Number:",null,"*Contact Email:"]
["University Approved Prize",null,"*Award Type:"]
["↓",null,"Override Registration Requirement? ","","Default=No"]
[null,null,"*PayDate(s) (format dd/mm/yyyy):"]
[null,null,"PayMonths (Users do not complete this section):",{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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) ↓"]

{"sheet":"Macros","index":1,"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":2,"n_rows":100,"n_cols":1,"rows_kept":100,"cut":false,"hidden":false,"merged":[[28,0,28,18],[14,0,14,18],[94,0,94,18],[95,0,95,18],[97,0,98,18],[93,0,93,18],[88,0,88,18],[71,0,71,18],[57,0,57,18],[43,0,43,18]]}
["Student awards form MA1 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"]
["·        MA1: maintenance payments to multiple (or a single) students 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 ma1@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. Each white box carries a brief description of the action that needs to be taken. \nFor example:-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The first two boxes require data entry, but the following three are all selected via a drop down. For example:-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The “Override Registration Requirement?” box will default to “No”. If you require a student to continue receiving payments during a period of suspension or if the award is for a student who has already graduated, then the “Override Registration Requirement?” should be changed to “Yes\". If this box isn’t ticked at the time of sending or the registration status changes before the payment is due to be made, then an email would be required to be sent to funding@leeds.ac.uk, in order for an immediate disbursement to be scheduled. For example:-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["If the payment is to be a single payment, then you would select “Maintenance – Single Instalment” and then select the closest Friday to the date that you wish the payment to be made. For example:-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["If the payment is to be monthly, you would select Maintenance Monthly and another white box will appear for the end date. You would then select the start date (the first day of the month) and end date (last date of the month) that the payment is to run for. This will then auto-populate the months that the payments are to be made. For example:-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2. Send file via authorised signatory"]
[]
["The file must be attached to an email and sent to ma1@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 a 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."]
[]
[]
["New MA1"]
["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 MA1 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."]
[]
["Please find below an example of a complete form:-"]

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