{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Employee"],"not_rendered":{"charts":0,"images":2,"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",2023]
["A","February",{"$f":"C2+1","v":2024}]
["B","March",{"$f":"C3+1","v":2025}]
["C","April",2026]
["D","May"]
[null,"June"]
[null,"July"]
[null,"August"]
[null,"September"]
[null,"October"]
[null,"November"]
[null,"December"]

{"sheet":"Employee","index":1,"n_rows":119,"n_cols":18,"rows_kept":119,"cut":false,"hidden":false,"merged":[[98,0,100,0],[98,1,100,1],[47,0,49,0],[47,1,49,1],[50,0,52,0],[50,1,52,1],[53,0,55,0],[53,1,55,1],[56,0,58,0],[56,1,58,1],[59,0,61,0],[59,1,61,1],[92,0,94,0],[92,1,94,1],[62,0,64,0],[62,1,64,1],[65,0,67,0],[65,1,67,1],[68,0,70,0],[68,1,70,1],[77,0,79,0],[77,1,79,1],[95,0,97,0],[95,1,97,1],[20,0,22,0],[20,1,22,1],[23,0,25,0],[26,0,28,0],[26,1,28,1],[29,0,31,0],[29,1,31,1],[8,0,10,0],[8,1,10,1],[11,0,13,0],[11,1,13,1],[14,0,16,0],[14,1,16,1],[17,0,19,0],[17,1,19,1],[26,7,28,7],[29,7,31,7],[32,7,34,7],[35,7,37,7],[23,6,25,6],[26,6,28,6],[20,7,22,7],[29,6,31,6],[89,0,91,0],[89,1,91,1],[86,0,88,0],[86,1,88,1],[44,0,46,0],[44,1,46,1],[80,0,82,0],[80,1,82,1],[83,0,85,0],[83,1,85,1],[74,0,76,0],[74,1,76,1],[35,1,37,1],[53,6,55,6],[56,6,58,6],[86,6,88,6],[86,7,88,7],[65,6,67,6],[80,6,82,6],[83,6,85,6],[32,0,34,0],[32,1,34,1],[35,0,37,0],[41,7,43,7],[59,6,61,6],[62,6,64,6],[71,0,73,0],[71,1,73,1],[38,7,40,7],[68,7,70,7],[71,7,73,7],[38,0,40,0],[38,1,40,1],[41,0,43,0],[41,1,43,1],[32,6,34,6],[95,6,97,6],[98,6,100,6],[8,7,10,7],[11,7,13,7],[14,7,16,7],[17,7,19,7],[8,6,10,6],[11,6,13,6],[14,6,16,6],[92,7,94,7],[95,7,97,7],[50,7,52,7],[53,7,55,7],[56,7,58,7],[74,7,76,7],[77,7,79,7],[80,7,82,7],[83,7,85,7],[89,7,91,7],[59,7,61,7],[62,7,64,7],[65,7,67,7],[50,6,52,6],[23,7,25,7],[0,6,0,8],[35,6,37,6],[38,6,40,6],[41,6,43,6],[44,6,46,6],[47,6,49,6],[105,1,108,3],[89,6,91,6],[71,6,73,6],[74,6,76,6],[77,6,79,6],[17,6,19,6],[20,6,22,6],[23,1,25,1],[5,4,5,5],[5,7,7,7],[5,6,7,6],[6,4,7,4],[6,5,7,5],[98,7,100,7],[68,6,70,6],[44,7,46,7],[47,7,49,7],[92,6,94,6]]}
[null,null,null,null,null,"Name: "]
[null,null,null,null,null,"Work Schedule","Month","Year","Revision",null,null,null,"Logic for Rounding Up or Down on three columns"]
[null,null,null,null,null,"N/A",null,2023,false]
["DAILY SCHEDULE, ITINERARY, & TIME AND EFFORT REPORT",null,null,null,null,null,null,null,{"$f":"IF(Employee!R11=\"\",\"\",\"Please add required Information:  \"&Employee!R11)","v":"Please add required Information:  * Name * Month "}]
[null,null,null,null,null,null,null,null,null,null,null,"Columns",{"$f":"TRIM(O5&P5&Q5&R5)","v":"1234"},null,1,2,3,4]
[null,null,null,"Summary of Work Hours and Nature of Service","Actual Hours Worked",null,"Total Daily Holiday (8 hours) and Leave Hours (as reported in HR system)","Total Hours in Period*  =  Actual Hours Worked  + Holiday and Leave",null,null,"Hrs",{"$f":"SUM(M6:P6)","v":{"$error":"#REF!"}},{"$f":"Employee!E102","v":0},{"$f":"Employee!F102","v":0},{"$f":"Employee!#REF!","v":{"$error":"#REF!"}},{"$f":"Employee!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"IF(F106=\"\",\"\",F106&\" Actual Number of Hours\")","v":"ARPA Federal Actual Number of Hours"},{"$f":"IF(F107=\"\",\"\",F107&\" Actual Number of Hours\")","v":"Other Funding Actual Number of Hours"},null,null,null,null,"Pcts",{"$f":"SUM(M7:P7)","v":{"$error":"#REF!"}},{"$f":"L8-N7-O7-P7","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(N6/L6,4)","v":{"$error":"#REF!"}},{"$f":"ROUNDDOWN(O6/L6,4)","v":{"$error":"#REF!"}},{"$f":"ROUNDDOWN(P6/L6,4)","v":{"$error":"#REF!"}}]
["Month","Day","Location(s)","(Describe nature of work performed, meetings attended, service, visits, persons contacted, etc... )",null,null,null,null,null,null,null,1]
[{"$f":"+G$3","v":0},1]
[null,null,null,null,null,null,null,null,null,null,null,"Required Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Employee!G1=\"\",\"* Name \",\"\")","v":"* Name "},{"$f":"IF(Employee!F3=\"\",\"* Schedule \",\"\")","v":""},{"$f":"IF(Employee!F3=\"\",\"* Month \",\"\")","v":""},{"$f":"IF(Employee!G3=\"\",\"* Month \",\"\")","v":"* Month "},{"$f":"IF(Employee!H3=\"\",\"* Year\",\"\")","v":""},null,{"$f":"CONCATENATE(L11,M11,O11,P11)","v":"* Name * Month "}]
[{"$f":"+G$3","v":0},2,null,null,null,null,null,{"$f":"SUM(E12:F14:G14)","v":0}]
[]
[]
[{"$f":"+G$3","v":0},3,null,null,null,null,null,{"$f":"SUM(E15:F17:G17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"D16","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},4,null,null,null,null,null,{"$f":"SUM(E18:F20:G20)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},5,null,null,null,null,null,{"$f":"SUM(E21:F23:G23)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},6,null,null,null,null,null,{"$f":"SUM(E24:F26:G26)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},7,null,null,null,null,null,{"$f":"SUM(E27:F29:G29)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},8,null,null,null,null,null,{"$f":"SUM(E30:F32:G32)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},9,null,null,null,null,null,{"$f":"SUM(E33:F35:G35)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},10,null,null,null,null,null,{"$f":"SUM(E36:F38:G38)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},11,null,null,null,null,null,{"$f":"SUM(E39:F41:G41)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},12,null,null,null,null,null,{"$f":"SUM(E42:F44:G44)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},13,null,null,null,null,null,{"$f":"SUM(E45:F47:G47)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},14,null,null,null,null,null,{"$f":"SUM(E48:F50:G50)","v":0},null,null,{"$f":"D48","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},15,null,null,null,null,null,{"$f":"SUM(E51:F53:G53)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},16,null,null,null,null,null,{"$f":"SUM(E54:F56:G56)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},17,null,null,null,null,null,{"$f":"SUM(E57:F59:G59)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},18,null,null,null,null,null,{"$f":"SUM(E60:F62:G62)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},19,null,null,null,null,null,{"$f":"SUM(E63:F65:G65)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},20,null,null,null,null,null,{"$f":"SUM(E66:F68:G68)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},21,null,null,null,null,null,{"$f":"SUM(E69:F71:G71)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},22,null,null,null,null,null,{"$f":"SUM(E72:F74:G74)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},23,null,null,null,null,null,{"$f":"SUM(E75:F77:G77)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},24,null,null,null,null,null,{"$f":"SUM(E78:F80:G80)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"D80","v":0}]
[{"$f":"+G$3","v":0},25,null,null,null,null,null,{"$f":"SUM(E81:F83:G83)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},26,null,null,null,null,null,{"$f":"SUM(E84:F86:G86)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},27,null,null,null,null,null,{"$f":"SUM(E87:F89:G89)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},28,null,null,null,null,null,{"$f":"SUM(E90:F92:G92)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},29,null,null,null,null,null,{"$f":"SUM(E93:F95:G95)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},30,null,null,null,null,null,{"$f":"SUM(E96:F98:G98)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":0},31,null,null,null,null,null,{"$f":"SUM(E99:F101:G101)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"TOTAL ACTUAL HOURS WORKED:",{"$f":"SUM(E9:E101)","v":0},{"$f":"SUM(F9:F101)","v":0},0,0]
[null,null,null,"FUNDING DISTRIBUTION PERCENTAGE:",{"$f":"E102/$H$102","v":{"$error":"#DIV/0!"}},{"$f":"F102/$H$102","v":{"$error":"#DIV/0!"}},{"$f":"G102/$H$102","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E103:G103)","v":{"$error":"#DIV/0!"}}]
[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,"ARPA Federal"]
[null,null,null,null,null,"Other Funding"]
[]
[]
[]
[null,null,"Employee:",null,"Date:"]
["Reviewed and Approved: ",null,null,{"$f":"IF(D111=\"\",\"Employee's Signature Required\",\"\")","v":"Employee's Signature Required"},null,{"$f":"TODAY()","v":"2023-05-05"}]
[null,null,"Supervisor:",null,"Date:"]
[null,null,null,{"$f":"IF(D113=\"\",\"Supervisor's Signature Required\",\"\")","v":"Supervisor's Signature Required"},null,{"$f":"IF(F113=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]
[null,null,"Employee:",null,"Date:",null,"Revised"]
["Reviewed and Approved: ",null,null,{"$f":"IF(D115=\"\",\"Employee's Signature Required\",\"\")","v":"Employee's Signature Required"},null,{"$f":"IF(F115=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]
[null,null,"Supervisor:",null,"Date:",null,"Revised"]
[null,null,null,{"$f":"IF(D117=\"\",\"Supervisor's Signature Required\",\"\")","v":"Supervisor's Signature Required"},null,{"$f":"TODAY()","v":"2023-05-05"}]
[null,null,"Comments:"]