{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Input","Notes"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":1,"comments":12,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Input","index":0,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,10,1,11],[3,10,3,11]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":7},"Faculty / School / Service / R.I."]
[]
[{"$nulls":9},"Period Ending"]
[]
["Person Number","Name","Transaction Date","Pay Code","Hours / Value","Cost Centre","Grade","Point","Project","Expense","Sub Category","Appointment ID"]

{"sheet":"Notes","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Notes on Use"]
[]
["Person Number","This is the six digit person number, sometimes called staff number or pay number. The previous 01, 02 figures from the eight digit version have been dropped, the system now uses Appointment ID where people have multiple contracts.\n\nCompletion of this field is mandatory."]
[]
["Name","This is the name of the person that you wish to make payment to.\n\nCompleteion of this field is mandatory."]
[]
["Transaction Date","This is either the date the work was actually performed or the period end date. The data must be entered in the format DD-MMM-YY e.g 31-JUL-12.\n\nThis field is optional."]
[]
["Pay Code","This is the payment code that determines the amount paid.\n\nCompletion of this field is mandatory.\n\nSome useful pay codes are:\n2143 Basic Hours (to be used for zero hour contracts and atypical workers)\n2223 Preparation Time\n2233 Marking\n2237 Development\n\n2003 Overtime at time and a half\n2007 Overtime at double time\n2017 Overtime at plain time - e.g. part-time workers doing additional hours"]
[]
["Hours / Value","This is the number of hours that you wish to pay. In some circumstances this can also be a cash value.\n\nCompletion of this field is mandatory."]
[]
["Cost Centre","This is the cost centre to which the person's post belongs.\n\nThis field is optional."]
[]
["Grade","This field can be used to pay someone at an alternative grade to that held against their appointment ID and should only be used when an alternative payment rate is required. If used the data must be input in the format GRADE4 i.e. no space between the E and the number that follows.\n\nThis field is optional."]
[]
["Point","This field is only required in conjunction with Grade. No entry is required unless you wish to pay someone at an alternative rate of pay.\n\nThis field is optional."]
[]
["Project","This field to be used when costs are to be charged somewhere other than the normal cost allocation held against the appointment.\n\nThis field is optional."]
[]
["Expense","Not currently in use."]
[]
["Sub Category","Not currently in use"]
[]
["Appointment ID","Enter the person's Appointment ID where the person has multiple contracts or may have recently changed appointment.\n\nThis field is optional."]