{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":80,"n_cols":56,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,0,0,18],[3,2,3,10],[74,2,74,3],[74,7,74,8],[74,12,74,13],[75,2,75,3],[75,7,75,8],[75,12,75,13],[72,2,72,3],[72,7,72,8],[72,12,72,13],[73,2,73,3],[73,7,73,8],[73,12,73,13],[70,2,70,3],[70,7,70,8],[70,12,70,13],[71,2,71,3],[71,7,71,8],[71,12,71,13],[68,2,68,3],[68,7,68,8],[68,12,68,13],[69,2,69,3],[69,7,69,8],[69,12,69,13],[64,2,64,3],[64,7,64,8],[64,12,64,13],[64,17,64,18],[67,2,67,3],[67,7,67,8],[67,12,67,13],[66,0,66,3],[66,5,66,8],[66,10,66,13],[52,12,52,13],[33,2,33,3],[62,2,62,3],[62,7,62,8],[62,12,62,13],[62,17,62,18],[63,2,63,3],[63,7,63,8],[63,12,63,13],[63,17,63,18],[60,2,60,3],[60,7,60,8],[60,12,60,13],[60,17,60,18],[61,2,61,3],[61,7,61,8],[61,12,61,13],[61,17,61,18],[58,2,58,3],[58,7,58,8],[58,12,58,13],[58,17,58,18],[59,2,59,3],[59,7,59,8],[59,12,59,13],[59,17,59,18],[56,2,56,3],[56,7,56,8],[56,17,56,18],[57,2,57,3],[57,7,57,8],[57,12,57,13],[57,17,57,18],[56,12,56,13],[44,7,44,8],[44,12,44,13],[45,12,45,13],[46,12,46,13],[47,12,47,13],[48,12,48,13],[40,12,40,13],[41,12,41,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[2,13,2,18],[3,13,3,18],[55,15,55,18],[20,10,20,13],[39,7,39,8],[40,7,40,8],[41,7,41,8],[34,17,34,18],[35,17,35,18],[36,17,36,18],[37,17,37,18],[38,17,38,18],[39,17,39,18],[40,17,40,18],[41,17,41,18],[51,12,51,13],[49,12,49,13],[50,12,50,13],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[33,7,33,8],[33,17,33,18],[9,15,9,18],[20,0,20,3],[20,5,20,8],[32,15,32,18],[43,0,43,3],[43,5,43,8],[43,10,43,13],[55,0,55,3],[55,5,55,8],[55,10,55,13],[54,0,54,2],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[51,2,51,3],[52,2,52,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[44,2,44,3],[5,5,5,6],[39,12,39,13],[40,2,40,3],[41,2,41,3],[5,10,5,11],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[31,0,31,2],[38,2,38,3],[39,2,39,3],[8,0,8,2],[32,0,32,3],[9,0,9,3],[9,5,9,8],[9,10,9,13],[32,5,32,8],[32,10,32,13],[33,12,33,13]]}
["Faculty Hours Calculator"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Start Date:"]
[null,"Name:",null,null,null,null,null,null,null,null,null,null,"End Date:"]
[]
[null,null,null,null,null,"Temporary Duty",null,null,null,null,"Substitute "]
[null,null,null,null,null,{"$f":"SUM(D9,D32,D55)","v":0},{"$f":"SUM(BB23,BD23)","v":0},null,null,null,{"$f":"E9","v":0},{"$f":"SUM(BB26,BD26)","v":0}]
[]
["Instructional Hours",null,null,{"$f":"SUM(D19,I19,N19,S19,D30,I30,N30)","v":0},{"$f":"SUM(E19,J19,O19,T19,E30,J30,O30)","v":0}]
["Monday",null,null,null,null,"Tuesday",null,null,null,null,"Wednesday",null,null,null,null,"Thursday",null,null,null,null,null,"If the class is Vitual and does not"]
["Start","End","Virtual",null,null,"Start","End","Virtual",null,null,"Start","End","Virtual",null,null,"Start","End","Virtual",null,null,null,"require a substitute, type \"Yes\" "]
[null,null,null,{"$f":"B12-A12","v":"00:00:00"},{"$f":"IF(C12=\"Yes\",0,D12)","v":"00:00:00"},null,null,null,{"$f":"G12-F12","v":"00:00:00"},{"$f":"IF(H12=\"Yes\",0,I12)","v":"00:00:00"},null,null,null,{"$f":"L12-K12","v":"00:00:00"},{"$f":"IF(M12=\"Yes\",0,N12)","v":"00:00:00"},null,null,null,{"$f":"Q12-P12","v":"00:00:00"},{"$f":"IF(R12=\"Yes\",0,S12)","v":"00:00:00"},null,"in the Virtual column",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Virtual"]
[null,null,null,{"$f":"B13-A13","v":"00:00:00"},{"$f":"IF(C13=\"Yes\",0,D13)","v":"00:00:00"},null,null,null,{"$f":"G13-F13","v":"00:00:00"},{"$f":"IF(H13=\"Yes\",0,I13)","v":"00:00:00"},null,null,null,{"$f":"L13-K13","v":"00:00:00"},{"$f":"IF(M13=\"Yes\",0,N13)","v":"00:00:00"},null,null,null,{"$f":"Q13-P13","v":"00:00:00"},{"$f":"IF(R13=\"Yes\",0,S13)","v":"00:00:00"}]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00"]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00"]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00"]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00"]
[null,null,null,{"$f":"SUM(D12:D18)","v":"00:00:00"},{"$f":"SUM(E12:E18)","v":"00:00:00"},null,null,null,{"$f":"SUM(I12:I18)","v":"00:00:00"},{"$f":"SUM(J12:J18)","v":"00:00:00"},null,null,null,{"$f":"SUM(N12:N18)","v":"00:00:00"},{"$f":"SUM(O12:O18)","v":"00:00:00"},null,null,null,{"$f":"SUM(S12:S18)","v":"00:00:00"},{"$f":"SUM(T12:T18)","v":"00:00:00"}]
[]
["Friday",null,null,null,null,"Saturday",null,null,null,null,"Sunday"]
["Start","End","Virtual",null,null,"Start","End","Virtual",null,null,"Start","End","Virtual"]
[null,null,null,{"$f":"B23-A23","v":"00:00:00"},{"$f":"IF(C23=\"Yes\",0,D23)","v":"00:00:00"},null,null,null,{"$f":"G23-F23","v":"00:00:00"},{"$f":"IF(H23=\"Yes\",0,I23)","v":"00:00:00"},null,null,null,{"$f":"L23-K23","v":"00:00:00"},{"$f":"IF(M23=\"Yes\",0,N23)","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(F7/(1/24),0)*(1/24)","v":0},{"$f":"MROUND(BA23,\"0:15\")*(24)","v":0},{"$f":"MINUTE(F7)","v":0},{"$f":"(BC23/60)","v":0}]
[null,null,null,{"$f":"B24-A24","v":"00:00:00"},{"$f":"IF(C24=\"Yes\",0,D24)","v":"00:00:00"},null,null,null,{"$f":"G24-F24","v":"00:00:00"},{"$f":"IF(H24=\"Yes\",0,I24)","v":"00:00:00"},null,null,null,{"$f":"L24-K24","v":"00:00:00"},{"$f":"IF(M24=\"Yes\",0,N24)","v":"00:00:00"}]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00"]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(K7/(1/24),0)*(1/24)","v":0},{"$f":"MROUND(BA26,\"0:15\")*(24)","v":0},{"$f":"MINUTE(K7)","v":0},{"$f":"BC26/60","v":0}]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00"]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00"]
[null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00","00:00:00"]
[null,null,null,{"$f":"SUM(D23:D29)","v":"00:00:00"},{"$f":"SUM(E23:E29)","v":"00:00:00"},null,null,null,{"$f":"SUM(I23:I29)","v":"00:00:00"},{"$f":"SUM(J23:J29)","v":"00:00:00"},null,null,null,{"$f":"SUM(N23:N29)","v":"00:00:00"},{"$f":"SUM(O23:O29)","v":"00:00:00"}]
[]
["Office Hours",null,null,{"$f":"SUM(C42,H42,M42,R42,C53,H53,M53)","v":0}]
["Monday",null,null,null,null,"Tuesday",null,null,null,null,"Wednesday",null,null,null,null,"Thursday"]
["Start","End",null,null,null,"Start","End",null,null,null,"Start","End",null,null,null,"Start","End"]
[null,null,{"$f":"B35-A35","v":"00:00:00"},null,null,null,null,{"$f":"G35-F35","v":"00:00:00"},null,null,null,null,{"$f":"L35-K35","v":"00:00:00"},null,null,null,null,{"$f":"Q35-P35","v":"00:00:00"}]
[null,null,"00:00:00",null,null,null,null,{"$f":"G36-F36","v":"00:00:00"},null,null,null,null,{"$f":"L36-K36","v":"00:00:00"},null,null,null,null,{"$f":"Q36-P36","v":"00:00:00"}]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,{"$f":"SUM(C35:D41)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(H35:I41)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(M35:N41)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(R35:S41)","v":"00:00:00"}]
[]
["Friday",null,null,null,null,"Saturday",null,null,null,null,"Sunday"]
["Start","End",null,null,null,"Start","End",null,null,null,"Start","End"]
[null,null,{"$f":"B46-A46","v":"00:00:00"},null,null,null,null,{"$f":"G46-F46","v":"00:00:00"},null,null,null,null,{"$f":"L46-K46","v":"00:00:00"}]
[null,null,{"$f":"B47-A47","v":"00:00:00"},null,null,null,null,{"$f":"G47-F47","v":"00:00:00"},null,null,null,null,{"$f":"L47-K47","v":"00:00:00"}]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,{"$f":"SUM(C46:D52)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(H46:I52)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(M46:N52)","v":"00:00:00"}]
[]
["Campus Hours",null,null,{"$f":"SUM(C65,H65,M65,R65,C76,H76,M76)","v":0}]
["Monday",null,null,null,null,"Tuesday",null,null,null,null,"Wednesday",null,null,null,null,"Thursday"]
["Start","End",null,null,null,"Start","End",null,null,null,"Start","End",null,null,null,"Start","End"]
[null,null,{"$f":"B58-A58","v":"00:00:00"},null,null,null,null,{"$f":"G58-F58","v":"00:00:00"},null,null,null,null,{"$f":"L58-K58","v":"00:00:00"},null,null,null,null,{"$f":"Q58-P58","v":"00:00:00"}]
[null,null,"00:00:00",null,null,null,null,{"$f":"G59-F59","v":"00:00:00"},null,null,null,null,{"$f":"L59-K59","v":"00:00:00"},null,null,null,null,{"$f":"Q59-P59","v":"00:00:00"}]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,{"$f":"SUM(C58:D64)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(H58:I64)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(M58:N64)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(R58:S64)","v":"00:00:00"}]
[]
["Friday",null,null,null,null,"Saturday",null,null,null,null,"Sunday"]
["Start","End",null,null,null,"Start","End",null,null,null,"Start","End"]
[null,null,{"$f":"B69-A69","v":"00:00:00"},null,null,null,null,{"$f":"G69-F69","v":"00:00:00"},null,null,null,null,{"$f":"L69-K69","v":"00:00:00"}]
[null,null,{"$f":"B70-A70","v":"00:00:00"},null,null,null,null,{"$f":"G70-F70","v":"00:00:00"},null,null,null,null,{"$f":"L70-K70","v":"00:00:00"}]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,"00:00:00",null,null,null,null,"00:00:00",null,null,null,null,"00:00:00"]
[null,null,{"$f":"SUM(C69:D75)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(H69:I75)","v":"00:00:00"},null,null,null,null,{"$f":"SUM(M69:N75)","v":"00:00:00"}]
[]
[]
[]
["Updated: September 2018"]