{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Employee","Instructions","DO NOT EDIT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":121,"n_cols":19,"rows_kept":121,"cut":false,"hidden":false,"merged":[[2,6,2,8],[37,7,39,7],[40,7,42,7],[43,7,45,7],[46,7,48,7],[49,7,51,7],[8,6,9,6],[107,1,110,3],[7,8,9,8],[7,7,9,7],[8,4,9,4],[8,5,9,5],[100,8,102,8],[70,7,72,7],[46,8,48,8],[49,8,51,8],[94,7,96,7],[97,7,99,7],[100,7,102,7],[10,8,12,8],[13,8,15,8],[16,8,18,8],[19,8,21,8],[10,7,12,7],[13,7,15,7],[16,7,18,7],[94,8,96,8],[97,8,99,8],[52,8,54,8],[55,8,57,8],[58,8,60,8],[91,7,93,7],[73,7,75,7],[76,7,78,7],[79,7,81,7],[76,8,78,8],[79,8,81,8],[82,8,84,8],[85,8,87,8],[91,8,93,8],[61,8,63,8],[64,8,66,8],[67,8,69,8],[52,7,54,7],[19,7,21,7],[22,7,24,7],[25,8,27,8],[88,8,90,8],[67,7,69,7],[82,7,84,7],[85,7,87,7],[34,0,36,0],[34,1,36,1],[37,0,39,0],[43,8,45,8],[61,7,63,7],[64,7,66,7],[73,0,75,0],[73,1,75,1],[40,8,42,8],[70,8,72,8],[73,8,75,8],[40,0,42,0],[40,1,42,1],[43,0,45,0],[43,1,45,1],[34,7,36,7],[28,8,30,8],[31,8,33,8],[34,8,36,8],[37,8,39,8],[25,7,27,7],[28,7,30,7],[22,8,24,8],[31,7,33,7],[91,0,93,0],[91,1,93,1],[88,0,90,0],[88,1,90,1],[46,0,48,0],[46,1,48,1],[82,0,84,0],[82,1,84,1],[85,0,87,0],[85,1,87,1],[76,0,78,0],[76,1,78,1],[37,1,39,1],[55,7,57,7],[58,7,60,7],[88,7,90,7],[10,0,12,0],[10,1,12,1],[13,0,15,0],[13,1,15,1],[16,0,18,0],[16,1,18,1],[19,0,21,0],[19,1,21,1],[7,4,7,6],[97,1,99,1],[22,0,24,0],[22,1,24,1],[25,0,27,0],[25,1,27,1],[28,0,30,0],[28,1,30,1],[31,0,33,0],[31,1,33,1],[2,0,2,2],[100,0,102,0],[100,1,102,1],[49,0,51,0],[49,1,51,1],[52,0,54,0],[52,1,54,1],[55,0,57,0],[55,1,57,1],[58,0,60,0],[58,1,60,1],[61,0,63,0],[61,1,63,1],[94,0,96,0],[94,1,96,1],[64,0,66,0],[64,1,66,1],[67,0,69,0],[67,1,69,1],[70,0,72,0],[70,1,72,1],[79,0,81,0],[79,1,81,1],[97,0,99,0]]}
["MONTANA PERKINS TIME AND EFFORT REPORT",null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[]
["School Name:",null,null,null,null,"Name: "]
[null,null,null,null,null,"Quarter","Month","Year","Revision",null,null,null,"Logic for Rounding Up or Down on three columns"]
[null,null,null,null,null,"Q2","October",2024,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Columns",{"$f":"TRIM(O7&P7&Q7&R7)","v":"1234"},null,1,2,3,4]
[null,null,null,"Summary and Description of Work Hours ","Actual Hours Worked",null,null,"Total Daily Holiday (8 hours) and Leave Hours (as reported in ESS)","Total Hours in Period*  =  Actual Hours Worked  + Holiday and Leave",null,null,"Hrs",{"$f":"SUM(N8:Q8)","v":{"$error":"#REF!"}},{"$f":"Employee!E104","v":0},{"$f":"Employee!F104","v":0},{"$f":"Employee!#REF!","v":{"$error":"#REF!"}},{"$f":"Employee!G104","v":0}]
[null,null,null,null,{"$f":"IF(F108=\"\",\"\",F108&\" Actual Number of Hours\")","v":"Carl Perkins Administration Actual Number of Hours"},{"$f":"IF(F109=\"\",\"\",F109&\" Actual Number of Hours\")","v":"Carl Perkins Instructional Actual Number of Hours"},"Other Funding Sources Actual Number of Hours",null,null,null,null,"Pcts",{"$f":"SUM(N9:Q9)","v":{"$error":"#REF!"}},{"$f":"M10-O9-P9-Q9","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(O8/M8,4)","v":{"$error":"#REF!"}},{"$f":"ROUNDDOWN(P8/M8,4)","v":{"$error":"#REF!"}},{"$f":"ROUNDDOWN(Q8/M8,4)","v":{"$error":"#REF!"}}]
["Month","Day","Location(s)","(Describe nature of work performed, projects managed, meetings attended, service, visits, persons contacted, etc... )",null,null,null,null,null,null,null,null,1]
[{"$f":"+G$5","v":"October"},1,null,null,null,null,null,null,{"$f":"SUM(E11:H13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Required Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Employee!G3=\"\",\"* Name \",\"\")","v":"* Name "},{"$f":"IF(Employee!#REF!=\"\",\"* Schedule \",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(Employee!#REF!=\"\",\"* Month \",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(Employee!G5=\"\",\"* Month \",\"\")","v":""},{"$f":"IF(Employee!H5=\"\",\"* Year\",\"\")","v":""},null,{"$f":"CONCATENATE(M13,N13,P13,Q13)","v":{"$error":"#REF!"}}]
[{"$f":"+G$5","v":"October"},2,null,null,null,null,null,null,{"$f":"SUM(E14:H16)","v":0}]
[]
[]
[{"$f":"+G$5","v":"October"},3,null,null,null,null,null,null,{"$f":"SUM(E17:H19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},4,null,null,null,null,null,null,{"$f":"SUM(E20:H22)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},5,null,null,null,null,null,null,{"$f":"SUM(E23:H25)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},6,null,null,null,null,null,null,{"$f":"SUM(E26:H28)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},7,null,null,null,null,null,null,{"$f":"SUM(E29:H31)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},8,null,null,null,null,null,null,{"$f":"SUM(E32:H34)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},9,null,null,null,null,null,null,{"$f":"SUM(E35:H37)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},10,null,null,null,null,null,null,{"$f":"SUM(E38:H40)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},11,null,null,null,null,null,null,{"$f":"SUM(E41:H43)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},12,null,null,null,null,null,null,{"$f":"SUM(E44:H46)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},13,null,null,null,null,null,null,{"$f":"SUM(E47:H49)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},14,null,null,null,null,null,null,{"$f":"SUM(E50:H52)","v":0},null,null,{"$f":"D50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},15,null,null,null,null,null,null,{"$f":"SUM(E53:H55)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},16,null,null,null,null,null,null,{"$f":"SUM(E56:H58)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},17,null,null,null,null,null,null,{"$f":"SUM(E59:H61)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},18,null,null,null,null,null,null,{"$f":"SUM(E62:H64)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},19,null,null,null,null,null,null,{"$f":"SUM(E65:H67)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},20,null,null,null,null,null,null,{"$f":"SUM(E68:H70)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},21,null,null,null,null,null,null,{"$f":"SUM(E71:H73)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},22,null,null,null,null,null,null,{"$f":"SUM(E74:H76)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},23,null,null,null,null,null,null,{"$f":"SUM(E77:H79)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},24,null,null,null,null,null,null,{"$f":"SUM(E80:H82)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D82","v":0}]
[{"$f":"+G$5","v":"October"},25,null,null,null,null,null,null,{"$f":"SUM(E83:H85)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},26,null,null,null,null,null,null,{"$f":"SUM(E86:H88)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},27,null,null,null,null,null,null,{"$f":"SUM(E89:H91)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},28,null,null,null,null,null,null,{"$f":"SUM(E92:H94)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},29,null,null,null,null,null,null,{"$f":"SUM(E95:H97)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},30,null,null,null,null,null,null,{"$f":"SUM(E98:H100)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$5","v":"October"},31,null,null,null,null,null,null,{"$f":"SUM(E101:H103)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"TOTAL ACTUAL HOURS WORKED:",{"$f":"SUM(E11:E103)","v":0},{"$f":"SUM(F11:F103)","v":0},{"$f":"SUM(G11:G103)","v":0},{"$f":"SUM(H11:H103)","v":0},{"$f":"SUM(I11:I103)","v":0}]
[null,null,null,"FUNDING DISTRIBUTION PERCENTAGE:",{"$f":"E104/(I104-H104)","v":{"$error":"#DIV/0!"}},{"$f":"F104/(I104-H104)","v":{"$error":"#DIV/0!"}},{"$f":"G104/(I104-H104)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(E105:G105)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,"(Should equal 100%)"]
["I Certify: ",null,null,null,null,"Funding"]
[null,"By signing this report, I certify to the best of my knowledge and belief that the report is true, complete, and accurate, and the expenditures, disbursements and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award. I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise. (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812).",null,null,null,"Carl Perkins Administration"]
[null,null,null,null,null,"Carl Perkins Instructional"]
[]
[null,null,null,null,null,"Local (other funding sources)"]
[]
[null,null,"Employee:",null,"Date:"]
["Reviewed and Approved: ",null,null,{"$f":"IF(D113=\"\",\"Employee's Signature Required\",\"\")","v":"Employee's Signature Required"},null,{"$f":"IF(F113=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]
[null,null,"Supervisor:",null,"Date:"]
[null,null,null,{"$f":"IF(D115=\"\",\"Supervisor's Signature Required\",\"\")","v":"Supervisor's Signature Required"},null,{"$f":"IF(F115=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]
[null,null,"Employee:",null,"Date:",null,"Revised"]
["Reviewed and Approved: ",null,null,{"$f":"IF(D117=\"\",\"Employee's Signature Required\",\"\")","v":"Employee's Signature Required"},null,{"$f":"IF(F117=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]
[null,null,"Supervisor:",null,"Date:",null,"Revised"]
[null,null,null,{"$f":"IF(D119=\"\",\"Supervisor's Signature Required\",\"\")","v":"Supervisor's Signature Required"},null,{"$f":"IF(F119=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]
[null,null,"Comments:"]

{"sheet":"Instructions","index":2,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,12,8],[14,0,20,8]]}
["Instructions: Complete fields for School Name and employee's Name. Select correct month and year. For each day worked in the month on ANY activities, Perkins or otherwise, list all tasks completed and location completed. Each distinct task should be on one row.  Categorize the accompanying hours in either column E, F, or G for Perkins Administration, Perkins Instruction, or all other non-Perkins Funding Sources. Categorize any sick leave, vacation or holiday pay as a total number for the day in column H. Column I should automatically total the hours worked in one day. If additional rows are needed for additional tasks, right click a row within the block of the day and select \"Insert\". Rows 104 and 105 will autocalculate total distributed hours for the month and accompanying percentages. At the end of the month, the employee and their supervisor should sign and date the form. Records should be retained and submitted with the quarterly Perkins Report. Hours reported should reflect any supplemental documentation such as timesheets. Each monthly form should be retained as a separate file."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Revisions: In instances where revisions need to be made after time and effort has been signed and submitted, a new file should be made and the revisions checkbox selected. Changes should be made and resubmitted with updated signatues and dates. Both the original monthly form and revised monthly form must be retained."]

{"sheet":"DO NOT EDIT","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[2024,"Q1"]
[2025,"Q2"]
[2026,"Q3"]
[null,"Q4"]