{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Employee","Annual Example 1","Annual Example 2"],"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":119,"n_cols":20,"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],[5,4,5,5],[20,0,22,0],[20,1,22,1],[23,0,25,0],[23,1,25,1],[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,9,28,9],[29,9,31,9],[32,9,34,9],[35,9,37,9],[23,8,25,8],[26,8,28,8],[20,9,22,9],[29,8,31,8],[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,8,55,8],[56,8,58,8],[86,8,88,8],[86,9,88,9],[65,8,67,8],[80,8,82,8],[83,8,85,8],[32,0,34,0],[32,1,34,1],[35,0,37,0],[41,9,43,9],[59,8,61,8],[62,8,64,8],[71,0,73,0],[71,1,73,1],[38,9,40,9],[68,9,70,9],[71,9,73,9],[38,0,40,0],[38,1,40,1],[41,0,43,0],[41,1,43,1],[32,8,34,8],[8,8,10,8],[11,8,13,8],[14,8,16,8],[92,9,94,9],[95,9,97,9],[50,9,52,9],[53,9,55,9],[56,9,58,9],[89,8,91,8],[71,8,73,8],[74,8,76,8],[77,8,79,8],[74,9,76,9],[77,9,79,9],[80,9,82,9],[83,9,85,9],[89,9,91,9],[59,9,61,9],[62,9,64,9],[65,9,67,9],[50,8,52,8],[17,8,19,8],[20,8,22,8],[23,9,25,9],[0,6,0,8],[35,8,37,8],[38,8,40,8],[41,8,43,8],[44,8,46,8],[47,8,49,8],[6,7,7,7],[105,1,108,3],[5,9,7,9],[5,8,7,8],[6,4,7,4],[6,5,7,5],[6,6,7,6],[98,9,100,9],[68,8,70,8],[44,9,46,9],[47,9,49,9],[92,8,94,8],[95,8,97,8],[98,8,100,8],[8,9,10,9],[11,9,13,9],[14,9,16,9],[17,9,19,9]]}
["Crockett Community College",null,null,null,null,"Name: ","Joe Somebody"]
["DAILY SCHEDULE, ITINERARY, & TIME AND EFFORT REPORT",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,"A","February",2018,false]
[null,null,null,null,null,null,null,null,{"$f":"IF(Employee!T11=\"\",\"\",\"Please add required Information:  \"&Employee!T11)","v":""}]
[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 ",null,"Hours","Worked","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(O6:R6)","v":144},{"$f":"Employee!E102","v":11},{"$f":"Employee!F102","v":115},{"$f":"Employee!G102","v":18},{"$f":"Employee!H102","v":0}]
[null,null,null,null,{"$f":"IF(F106=\"\",\"\",F106&\" Actual Number of Hours\")","v":"Carl Perkins Administration Actual Number of Hours"},{"$f":"IF(F107=\"\",\"\",F107&\" Actual Number of Hours\")","v":"Carl Perkins Instructional Actual Number of Hours"},{"$f":"IF(F108=\"\",\"\",F108&\" Actual Number of Hours\")","v":"Carl Perkins Guidance Actual Number of Hours"},{"$f":"IF(F109=\"\",\"\",F109&\" Actual Number of Hours\")","v":"Non-Carl Perkins Duties Actual Number of Hours"},null,null,null,null,"Pcts",{"$f":"SUM(O7:R7)","v":1},{"$f":"N8-P7-Q7-R7","v":7.6300000000000034E-2},{"$f":"ROUNDUP(P6/N6,4)","v":0.79869999999999997},{"$f":"ROUNDDOWN(Q6/N6,4)","v":0.125},{"$f":"ROUNDDOWN(R6/N6,4)","v":0}]
["Month","Day","Location(s)","(Describe nature of work performed, meetings attended, service, visits, persons contacted, etc... )",null,null,null,null,null,null,null,null,null,1]
[{"$f":"+G$3","v":"February"},1,"Tulsa","Instruction",null,6,null,null,null,{"$f":"SUM(E9:G11:I11)","v":8}]
[null,null,null,"Guidance and Counseling",null,null,2,null,null,null,null,null,null,"Required Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Employee!G1=\"\",\"* Name \",\"\")","v":""},{"$f":"IF(Employee!F3=\"\",\"* Schedule \",\"\")","v":""},{"$f":"IF(Employee!F3=\"\",\"* Month \",\"\")","v":""},{"$f":"IF(Employee!G3=\"\",\"* Month \",\"\")","v":""},{"$f":"IF(Employee!H3=\"\",\"* Year\",\"\")","v":""},null,{"$f":"CONCATENATE(N11,O11,Q11,R11)","v":""}]
[{"$f":"+G$3","v":"February"},2,"Tulsa","Instruction",null,6,null,null,null,{"$f":"SUM(E12:G14:I14)","v":8}]
[null,null,null,"Prepared Budget for Supplemental Grant",2]
[]
[{"$f":"+G$3","v":"February"},3,null,null,null,null,null,null,null,{"$f":"SUM(E15:G17:I17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},4,null,null,null,null,null,null,null,{"$f":"SUM(E18:G20:I20)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},5,"Tulsa","Instruction",null,7,null,null,null,{"$f":"SUM(E21:G23:I23)","v":8},null,null,"Instruction"]
[null,null,null,"Submitted Supplemental Grant",1,null,null,null,null,null,null,null,"Submitted Supplemental Grant"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},6,"Tulsa","Career Fair",null,null,8,null,null,{"$f":"SUM(E24:G26:I26)","v":8},null,null,"Career Fair"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},7,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E27:G29:I29)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},8,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E30:G32:I32)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},9,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E33:G35:I35)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},10,null,null,null,null,null,null,null,{"$f":"SUM(E36:G38:I38)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},11,null,null,null,null,null,null,null,{"$f":"SUM(E39:G41:I41)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},12,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E42:G44:I44)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},13,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E45:G47:I47)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},14,"Tulsa","Professional Development for Carl Perkins- Administration of Perkins Grant",8,null,null,null,null,{"$f":"SUM(E48:G50:I50)","v":8},null,null,{"$f":"D48","v":"Professional Development for Carl Perkins- Administration of Perkins Grant"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},15,"Tulsa","Professional Development for Carl Perkins- Teacher Academy",null,8,null,null,null,{"$f":"SUM(E51:G53:I53)","v":8},null,null,"Professional Development for Carl Perkins- Teacher Academy"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},16,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E54:G56:I56)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},17,null,null,null,null,null,null,null,{"$f":"SUM(E57:G59:I59)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},18,null,null,null,null,null,null,null,{"$f":"SUM(E60:G62:I62)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},19,"Tulsa","President's Day",null,null,null,null,8,{"$f":"SUM(E63:G65:I65)","v":8},null,null,"President's Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},20,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E66:G68:I68)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},21,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E69:G71:I71)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},22,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E72:G74:I74)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},23,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E75:G77:I77)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},24,null,null,null,null,null,null,null,{"$f":"SUM(E78:G80:I80)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D80","v":0}]
[{"$f":"+G$3","v":"February"},25,null,null,null,null,null,null,null,{"$f":"SUM(E81:G83:I83)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},26,"Tulsa","Instruction",null,8,null,null,null,{"$f":"SUM(E84:G86:I86)","v":8},null,null,"Instruction"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},27,"Tulsa","Career Fair",null,null,8,null,null,{"$f":"SUM(E87:G89:I89)","v":8},null,null,"Career Fair"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},28,"Tulsa","Annual Leave",null,null,null,null,8,{"$f":"SUM(E90:G92:I92)","v":8},null,null,"Annual Leave"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},29,null,null,null,null,null,null,null,{"$f":"SUM(E93:G95:I95)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},30,null,null,null,null,null,null,null,{"$f":"SUM(E96:G98:I98)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+G$3","v":"February"},31,null,null,null,null,null,null,null,{"$f":"SUM(E99:G101:I101)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"TOTAL ACTUAL HOURS WORKED:",{"$f":"SUM(E9:E101)","v":11},{"$f":"SUM(F9:F101)","v":115},18,{"$f":"SUM(H9:H101)","v":0},16,160]
[null,null,null,"FUNDING DISTRIBUTION PERCENTAGE:",{"$f":"Employee!O7","v":7.6300000000000034E-2},{"$f":"Employee!P7","v":0.79869999999999997},{"$f":"Employee!Q7","v":0.125},{"$f":"Employee!R7","v":0},null,{"$f":"SUM(E103:H103)","v":1}]
[null,null,null,null,null,null,null,null,null,"(Should equal 100%)"]
["I Certify: ",null,null,null,null,"Funding Source"]
[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,"Carl Perkins Guidance"]
[null,null,null,null,null,"Non-Carl Perkins Duties"]
[]
[null,null,"Employee:"]
["Reviewed and Approved: ",null,null,{"$f":"IF(D111=\"\",\"Employee's Signature Required\",\"\")","v":"Employee's Signature Required"},"Date:"]
[null,null,"Supervisor:",null,null,{"$f":"IF(F112=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]
[null,null,null,{"$f":"IF(D113=\"\",\"Supervisor's Signature Required\",\"\")","v":"Supervisor's Signature Required"},"Date:"]
[null,null,"Employee:",null,null,{"$f":"IF(F114=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]
["Reviewed and Approved: ",null,null,{"$f":"IF(D115=\"\",\"Employee's Signature Required\",\"\")","v":"Employee's Signature Required"},"Date:",null,"Revised"]
[null,null,"Supervisor:",null,null,{"$f":"IF(F116=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]
[null,null,null,{"$f":"IF(D117=\"\",\"Supervisor's Signature Required\",\"\")","v":"Supervisor's Signature Required"},"Date:",null,"Revised"]
[null,null,"Comments:",null,null,{"$f":"IF(F118=\"\",\"Missing Date\",\"\")","v":"Missing Date"}]

{"sheet":"Annual Example 1","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Allocation of $200,000",null,null,"Max admin is $200,000*0.05= $10,000"]
["$150,000 spent on supplies"]
["$20,000 spent on equipment"]
["$30,000 spent on CTE instructor/coordinator"]
[]
["Month","Year","CP Admnistration","CP Instruciton","CP Guidance","Non-CP duties"]
["July",2017,0.02,0.8,0.18,0]
["August",2017,0,1,0,0]
["September",2017,0,1,0,0]
["October",2017,0,1,0,0]
["November",2017,0,1,0,0]
["December",2017,0.02,0.7,0.28000000000000003,0]
["January",2018,0,1,0,0]
["February",2018,7.6300000000000007E-2,0.79869999999999997,0.125,0]
["March",2018,0.05,0.95,0,0]
["April",2018,0.2,0.7,0.1,0]
["May",2018,0.08,0.65,0.27,0]
["June",2018,0.02,0.88,0.1,0]
["Average",null,{"$f":"AVERAGE(C7:C18)","v":3.8858333333333335E-2},{"$f":"AVERAGE(D7:D18)","v":0.87322500000000003},{"$f":"AVERAGE(E7:E18)","v":8.7916666666666657E-2},{"$f":"AVERAGE(F7:F18)","v":0}]
[]
["Salary of CTE instructor/director is $50,000"]
["Benefits are $20,000"]
[]
["They are claiming"]
[null,"Admin to Claim","Instruction","Guidance"]
["Salary",{"$f":"G26*C19","v":1942.9166666666667},10000,10000,null,null,50000]
["Benefits",{"$f":"G27*C19","v":777.16666666666674},2000,5279.92,null,null,20000]
["Total",{"$f":"SUM(B26:B27)","v":2720.0833333333335},{"$f":"SUM(C26:C27)","v":12000},{"$f":"SUM(D26:D27)","v":15279.92},{"$f":"B28+C28+D28","v":30000.003333333334},null,{"$f":"SUM(G26:G27)","v":70000}]
[]
["Is this allowable???"]
[]
["yes"]
["why?"]

{"sheet":"Annual Example 2","index":3,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Allocation of $200,000",null,null,"Max admin is $200,000*0.05= $10,000"]
["$150,000 spent on supplies"]
["$20,000 spent on equipment"]
["$30,000 spent on CTE instructor/coordinator"]
[]
["Month","Year","CP Admnistration","CP Instruction","CP Guidance","Non-CP duties"]
["July",2017,0.22,0.6,0.18,0]
["August",2017,0.1,0.9,0,0]
["September",2017,0.1,0.9,0,0]
["October",2017,0.1,0.9,0,0]
["November",2017,0.1,0.9,0,0]
["December",2017,0.32,0.4,0.28000000000000003,0]
["January",2018,0.2,0.8,0,0]
["February",2018,7.6300000000000007E-2,0.79869999999999997,0.125,0]
["March",2018,0.05,0.95,0,0]
["April",2018,0.2,0.7,0.1,0]
["May",2018,0.08,0.65,0.27,0]
["June",2018,0.22,0.68,0.1,0]
["Average",null,{"$f":"AVERAGE(C7:C18)","v":0.14719166666666667},{"$f":"AVERAGE(D7:D18)","v":0.76489166666666675},{"$f":"AVERAGE(E7:E18)","v":8.7916666666666657E-2},{"$f":"AVERAGE(F7:F18)","v":0}]
[]
["Salary of CTE instructor/director is $50,000"]
["Benefits are $20,000"]
[]
["They are claiming"]
[null,"Admin to Claim","Instruction","Guidance"]
["Salary",{"$f":"G26*C19","v":7359.583333333333},10000,10000,null,null,50000]
["Benefits",{"$f":"G27*C19","v":2943.8333333333335},2000,5279.92,null,null,20000]
["Total",{"$f":"SUM(B26:B27)","v":10303.416666666666},{"$f":"SUM(C26:C27)","v":12000},{"$f":"SUM(D26:D27)","v":15279.92},{"$f":"B28+C28+D28","v":37583.336666666662},null,{"$f":"SUM(G26:G27)","v":70000}]
[]
["Is this allowable???"]
[]
["no"]
["why?"]
["$303.42 over limit allowed"]