{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["UOIT","Intructions","BAR"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"UOIT","index":0,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Budget Year"]
["2014-15"]
["2015-16"]
["2016-17"]
["2017-18"]
["2018-19"]
[]
["Development Series","Budget Type"]
["In-Year Base Adj.","BU07 - Base Adjustment"]
["In-Year OTO Adj.","BU08 - OTO Adjustment"]
["Other","See Finance"]
[]
["ID","ID","Description","QUARTER 1 (APR - JUN)","QUARTER 2 (JUL - SEP)","QUARTER 3 (OCT - DEC)","QUARTER 4 (JAN - MAR)"]
["1234 - Q1(25) Q2(25) Q3(25) Q4(25)",1234,"Q1(25) Q2(25) Q3(25) Q4(25)",0.25,0.25,0.25,0.25]
["234 - Q2(33) Q3(33) Q4(34)",234,"Q2(33) Q3(33) Q4(34)",0,0.33329999999999999,0.33329999999999999,0.33339999999999997]
["34 - Q3(50) Q4(50)",34,"Q3(50) Q4(50)",0,0,0.5,0.5]
["1 - Q1 (100)",1,"Q1 (100)",1,0,0,0]
["2 - Q2 (100)",2,"Q2 (100)",0,1,0,0]
["3 - Q3 (100)",3,"Q3 (100)",0,0,1,0]
["4 - Q4 (100)",4,"Q4 (100)",0,0,0,1]
["123 - Q1(33) Q2(33) Q3(34)",123,"Q1(33) Q2(33) Q3(34)",0.33329999999999999,0.33329999999999999,0.33339999999999997,0]
["12 - Q1(50) Q2(50)",12,"Q1(50) Q2(50)",0.5,0.5,0,0]
["23 - Q2(25) Q3(75)",23,"Q2(25) Q3(75)",0,0.25,0.75,0]

{"sheet":"Intructions","index":1,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Note: Please open the Budget Adjustment Request as Read-Only and save as a new Excel file."]
[]
["BUDGET ADJUSTMENT REQUEST (BAR)"]
["Budget Adjustment Requests (BARs) pertaining to a Department are initiated and authorized by the Budget Officers of that unit.  Counterpart Departments will be listed and will also need to authorize."]
[]
["Budget Adjustment Requests will need to net to zero (see Part 1)."]
[]
["A Budget Adjustment Request is inputted into one of two specific Development Series:"]
["Development Series",null,"Budget Type","Description"]
["BYXX IY Base Adj",null,"BU07","In-Year Base Adjustments: Is a permanent adjustment.  In the following budget year, the adjustment is included in the base budget of the Unit who received the base adjustment."]
["BYXX IY OTO Adj.",null,"BU08","In-Year One-Time-Only Adjustments: Is not a permanent adjustment.  In the following budget year, the adjustment is returned to the base budget of the Unit who transferred the OTO adjustment."]
[]
["HOW TO INITIATE A BUDGET ADJUSTMENT REQUEST (BAR)"]
[]
["Contact:","Ben Suter, CGA, Project Manager, Budget and Forecast "]
[null,"Ben.Suter@uoit.ca or T. 905-721-8668 ext. 2162"]
[]
["Complete the Budget Adjustment Request (Part 1)."]
["Please complete all areas shaded in Blue."]
[]
["Budget Year:  From the drop-down filter, choose the applicable budget year."]
["Effective Date: Date the BAR will be inputted in the system.  For example, if the BAR is for the 3rd quarter, input 01-Oct-2014 as the effective date."]
["Development Series:  See above.  From the drop-down filter, choose the applicable Development Series."]
["Budget Type: Assigned based on the Development Series chosen."]
[]
["Initiating Budget Officer: Budget Officer initiating the BAR."]
["Initiating Orgn: Department initiating the BAR."]
["Date: Date stamp of when the BAR is initiated (or submitted).  This is different from the Effective Date."]
["BAR Total: A Budget Adjustment Request should always net out to zero.  If the Total in Part 2 does not net out to zero, that amount will be reflected in Yellow with Red font in the BAR Total."]
[]
["Counterpart Budget Officer(s) & Orgn: List all of the Departments that are affected by the BAR."]
[]
["Description: Include a detailed description relevant to the BAR."]
[]
["Complete the Budget Adjustment Details (Part 2)."]
["Please complete all areas shaded in Blue."]
[]
["Complete the FUND, ORGN, ACCT section.  Note that the CHART, PROG, ACTV, LOCN can be left blank.  These will be automatically populated either by the Excel sheet or the FAST Budget module."]
[]
["TOTAL: Input the dollar amount.  A positive value is an increase to the budget and a (negative) value is a decrease.  "]
["Remember that the BAR will need to net to zero.  If the BAR Total (see Part 1) is Yellow with Red fond, the BAR is not netting out to zero."]
[]
["Reminder: If requesting a BAR for a salary adjustment, the relevant burden account and amount will need to be included and calculated.  For example, a salary adjustment for 61100 will also need the corresponding 63040 at 18.5%."]
[]
["SPREAD:  From the drop-down filter, choose the applicable spreading model.  Note that the quarterly amounts will be reflected in columns P to S."]
[]
["FTE:  If you are requesting a BAR for a salary adjustment, please include the relevant FTE (contact Ben Suter for further instructions)."]
["EMPLOYEE: Include the Employee Banner ID (e.g. 100…) if the BAR is for a specific employee."]
["POSITION #: Include the Position Banner No. (e.g. 1A1234) if the BAR is for a specific position."]
[]
["COMMENTS:  Include a shortened descption (e.g. maximum no. if characters allowed is 190) that will be displayed in the Budget Transaction."]
["Note: For ease of Reporting, Finance Planning & Reporting might adjust or add information to the Comments field before approving the Budget Adjustment Request."]
[]
["HOW TO SUBMIT A BUDGET ADJUSTMENT REQUEST (BAR)"]
[]
["Once completed, submit you BAR to Ben Suter in Finance (se above) via e-mail.  Please include any Counterpart Departments on the communication."]
[]
["Finance Planning & Reporting will assign a Budget Adjustment Request No. and upload the BAR in the FAST Budget module."]
[]
["Once a month, at the close, Finance Planning & Reporting will post Approved Budget Adjustment Requests to Banner/FAST."]

{"sheet":"BAR","index":2,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[38,12,38,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[39,12,39,13],[9,2,9,13],[37,12,37,13],[4,9,4,11],[26,12,26,13],[28,12,28,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[6,9,6,10],[7,9,7,10],[6,11,6,12],[27,12,27,13],[16,12,16,13],[7,11,7,12],[21,12,21,13],[6,3,6,6],[7,3,7,6],[1,4,1,6],[2,4,2,6],[3,4,3,6],[4,4,4,6],[1,9,1,11],[2,9,2,11],[3,9,3,11],[32,12,32,13],[14,12,14,13],[15,12,15,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[25,12,25,13],[17,12,17,13]]}
[null,null,null,null,"Budget Adjustment Request (Part 1)",null,null,null,"BU15__________",null,null,null,"Finance Only:"]
[null,null,null,null,"Budget Year:",null,null,"2014-15","Initiating Budget Officer:",null,null,null,"Approved By:"]
[null,null,null,null,"Effective Date:",null,null,null,"Initiating Orgn:",null,null,null,"Approval Date:"]
[null,null,null,null,"Development Series:",null,null,"In-Year OTO Adj.","Date:",null,null,null,"Entered By:"]
[null,null,null,null,"Budget Type:",null,null,{"$f":"VLOOKUP(H4,UOIT!A9:B11,2,FALSE)","v":"BU08 - OTO Adjustment"},"BAR Total:",{"$f":"SUM(H16:H150)","v":0},null,null,"Entry Date:"]
[]
["Counterpart Budget Officer(s):"]
["Counterpart Orgn:"]
[]
["Description:"]
[]
["Budget Adjustment Details (Part 2)"]
["Note: If your Budget Adjustment Request requires more lines, please copy a row and then insert copied row."]
[]
["CHART","FUND","ORGN","ACCT","PROG","ACTV","LOCN","TOTAL","SPREAD","FTE","EMPLOYEE #","POSITION #","COMMENTS",null,null,"QUARTER 1 (APR - JUN)","QUARTER 2 (JUL - SEP)","QUARTER 3 (OCT - DEC)","QUARTER 4 (JAN - MAR)"]
["U"]
["U"]
["U"]
["U"]
["U"]
["U"]
["U"]
["U"]
["U"]
["U"]