{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Employee","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Sheet1","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
["Flex","January",2017]
["A","February",2018]
["B","March",2019]
["C","April",2020]
["D","May"]
[null,"June"]
[null,"July"]
[null,"August"]
[null,"September"]
[null,"October"]
[null,"November"]
[null,"December"]

{"sheet":"Employee","index":1,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[8,7,8,8],[2,11,4,12],[2,5,2,8],[3,5,3,8],[4,5,4,8],[5,5,5,8],[2,0,5,3],[46,1,49,3]]}
["MONTANA PERKINS PARTICIPATION PLAN CONFIRMATION",null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
["Time & Effort For Faculty and Exempt Staff"]
["This certification form is for Professional (exempt) Employees, employees who are paid either salary or hourly but exempt from overtime compensation AND for Professorial Employees who are either tenured, non-tenured, or adjunct faculty. Hourly classifed employees who are eligible for overtime compensation do not complete this form. Hourly classified employees should complete the hourly time and effort sheet.",null,null,null,"School Name:",null,null,null,null,null,null,". "]
[null,null,null,null,"Employee Name: "]
[null,null,null,null,"Title:"]
[null,null,null,null,"Department:"]
[]
[null,null,null,null,"Quarter:"]
[null,null,null,null,"Start Date:",null,"End Date:"]
[]
["BUDGETED"]
[]
[null,null,"Grants & Contracts"]
[null,null,"Budget Name","Budget Account Number","Budget Amount","% Effort"]
[]
[]
[]
[]
[]
[]
[null,null,"Other Salary Sources"]
[null,null,"Budget Name","Budget Account Number","Budget Amount","% Effort"]
[null,null,"All other sources"]
[]
[]
[]
[null,null,"Average Monthly Total",null,{"$f":"SUM(E15:E20,E23:E25)","v":0},{"$f":"SUM(F15:F20,F23:F25)","v":0},"(Should not exceed 100%)"]
["ACTUAL EFFORT"]
[]
[null,null,"Grants & Contracts"]
[null,null,"Actual Name","Budget Account Number",null,"% Effort"]
[]
[]
[]
[]
[]
[]
[null,null,"Other Salary Sources"]
[null,null,"Budget Name","Budget Account Number",null,"% Effort"]
[null,null,"All other sources"]
[]
[]
[]
[null,null,"Average Monthly Total",null,null,{"$f":"SUM(F32:F37,F40:F42)","v":0}]
[]
["I Certify: "]
[null,"I/we certify to the best of my/our knowledge and belief that the salary percentage distribution for the grant projects shown above is reasonable in relation to the work performed."]
[]
[]
[]
[]
[null,null,"Employee:",null,"Date:"]
["Reviewed and Approved: "]
[null,null,"Supervisor:",null,"Date:"]
[null,null,"Comments:"]

{"sheet":"Instructions","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,12,8]]}
["Instructions: Complete fields for School Name, Employee's Name, Title, Department, Quarter, start Date and End Date. Under BUDGETED \"Grants & Contracts\" List the names of any grants funding the position. For each grant title listed, list the accompanying account number, monthly budgeted amount and monthly budgeted% effort. For funding sources that are not grants or contracts, list them under \"Other Salary Sources\". Sums for amounts and percentages will auto-calculate. Under ACTUAL EFFORT, list the names of any grants actually worked on during the quarter with the appropriate account number and actual percentage worked. Total percentages should not exceed 100%. In the case where an employee works additional contracts that exceed 100% multiple Plan Confirmation Forms should be submitted. At the end of the quarter, the employee and their supervisor should sign and date the form. Records should be retained and submitted with the quarterly Perkins Report. "]