{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Adjunct - Dual Comp Form","Contract Amount ePAF Calculator"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":6,"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":"Adjunct - Dual Comp Form","index":0,"n_rows":121,"n_cols":19,"rows_kept":121,"cut":false,"hidden":false,"merged":[[120,1,120,3],[119,1,119,3],[2,1,4,5],[6,1,7,5],[18,2,18,5],[19,2,19,5],[9,1,9,5],[37,1,48,5],[33,1,33,4],[34,1,34,4],[35,1,35,4],[13,1,17,5],[20,1,20,5],[36,1,36,5]]}
[null,null,null,null,"eForm # :",null,null,null,null,null,null,null,null,null,null,"FTE1 ","FTE2","Standard Hours","Standard Hours"]
[null,null,null,null,null,null,null,null,0,{"$f":"0.02999999","v":2.9999990000000001E-2},"FTE Must Be 0.03 or Greater",{"$f":"(C23*D23*E23)*3","v":0}]
[null,"UNIVERSITY OF CENTRAL FLORIDA\nORLANDO, FL 32816",null,null,null,null,null,null,0.03,{"$f":"I3+0.00999999","v":3.9999989999999999E-2},1.2,0]
[null,null,null,null,null,null,null,null,0.04,4.9999990000000001E-2,1.6,0]
[null,null,null,null,null,null,null,null,0.05,5.9999990000000003E-2,2,0]
[null,null,null,null,null,null,null,null,0.06,6.9999989999999998E-2,2.4,0]
[null,"COURSE INFORMATION FTE CALCULATOR:\nTeaching Adjunct/Teaching Dual Compensation FTE Calculator",null,null,null,null,null,null,7.0000000000000007E-2,7.9999990000000007E-2,2.8,0]
[null,null,null,null,null,null,null,null,0.08,8.9999990000000002E-2,3.2,0]
[null,null,null,null,null,null,null,null,0.09,9.9999989999999997E-2,3.6,0]
[null,"Please Select One of the Options Listed Below:",null,null,null,null,null,null,0.1,0.10999999000000001,4,0]
[null,1,null,null,null,null,null,null,0.11,0.11999999,4.4000000000000004,0]
[null,null,null,null,null,null,null,null,0.12,0.12999999000000001,4.8,{"$f":"L13*40","v":0}]
[null,null,null,null,null,null,null,null,0.13,0.13999999000000002,5.2,{"$f":"SUM(L2:L11)/40","v":0}]
[null,{"$f":"IF(B11=1,B120,E120)","v":"This calculator needs to be used to calculate the FTE for teaching adjuncts (9001A-9005A). Only individuals who are the Instructor of Record can be placed in teaching adjunct job codes"},null,null,null,null,null,null,0.14000000000000001,0.14999999000000003,5.6,{"$f":"ROUND(L13,2)","v":0}]
[null,null,null,null,null,null,null,null,0.15,0.15999998999999998,6]
[null,null,null,null,null,null,null,null,0.16,0.16999998999999999,6.4]
[null,null,null,null,null,null,null,null,0.17,0.17999999,6.8]
[null,null,null,null,null,null,null,null,0.18,0.18999999000000001,7.2]
[null,"Employee's Name:",null,null,null,null,null,null,0.19,0.19999999000000002,7.6]
[null,"Emplid:",null,null,null,null,null,null,0.2,0.20999999000000003,8.0000000000000107]
[null,null,null,null,null,null,null,null,0.21,0.21999998999999998,8.4]
[null,"Course Name/Number","Credit Hours","# of Sections","Load Factor","Standard Hours",null,null,0.22,0.22999998999999999,8.8000000000000007]
[null,null,null,null,1,{"$f":"IF(L2>0,L2,\"\")","v":""},null,null,0.23,0.23999999,9.1999999999999993]
[null,null,null,null,1,"",null,null,0.24,0.24999999000000001,9.6]
[null,null,null,null,1,"",null,null,0.25,0.25999999000000001,10]
[null,null,null,null,1,"",null,null,0.26,0.26999999000000002,10.4]
[null,null,null,null,1,"",null,null,0.27,0.27999999000000003,10.8]
[null,null,null,null,1,"",null,null,0.28000000000000003,0.28999999000000004,11.2]
[null,null,null,null,1,"",null,null,0.28999999999999998,0.29999998999999999,11.6]
[null,null,null,null,1,"",null,null,0.3,0.30999999,12]
[null,null,null,null,1,"",null,null,0.31,0.31999999000000001,12.4]
[null,null,null,null,1,"",null,null,0.32,0.32999999000000002,12.8]
[null,"Total",{"$f":"SUM(C23:C32)","v":0},{"$f":"SUM(D23:D32)","v":0},{"$f":"SUM(E23:E32)","v":10},"",null,null,0.33,0.33999999000000003,13.2]
[null,"Total FTE",null,null,null,{"$f":"IF(ISERROR(F33/40),\"\",F33/40)","v":""},null,null,0.34,0.34999999000000004,13.6]
[null,"PeopleSoft FTE",null,null,null,{"$f":"IF(F34<=1,L14,IF(F34=\"\",\"\",1))","v":""},null,null,0.35,{"$f":"I35+0.00999999","v":0.35999998999999999},14]
[null,"PeopleSoft Standard Hours",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($F$35,$I$2:$K$100,3,TRUE)),\"\",(VLOOKUP($F$35,$I$2:$K$100,3,TRUE)))","v":""},null,null,0.36,0.36999999,14.4]
[null,null,null,null,null,null,null,null,0.37,0.37999999000000001,14.8]
[null,{"$f":"IF(B11=1,B121,E121)","v":"• Teaching adjunct job codes are:\n          o 9001A-Adjunct Professor\n          o 9002A-Adjunct Associate Professor\n          o 9003A-Adjunct Assistant Professor\n          o 9004A-Adjunct Instructor\n          o 9005A-Adjunct Lecturer\n• One credit hour is equivalent to 3 standard hours. \n• Teaching Adjunct’s FTE is based on:\n          o Credit hours\n          o Number of sessions per course\n          o Load factor\n\n"},null,null,null,null,null,null,0.38,0.38999999000000002,15.2]
[null,null,null,null,null,null,null,null,0.39,0.39999999000000003,15.6]
[null,null,null,null,null,null,null,null,0.4,0.40999999000000004,16]
[null,null,null,null,null,null,null,null,0.41,0.41999998999999999,16.399999999999999]
[null,null,null,null,null,null,null,null,0.42,0.42999999,16.8]
[null,null,null,null,null,null,null,null,0.43,0.43999999000000001,17.2]
[null,null,null,null,null,null,null,null,0.44,0.44999999000000002,17.600000000000001]
[null,null,null,null,null,null,null,null,0.45,0.45999999000000003,18]
[null,null,null,null,null,null,null,null,0.46,0.46999999000000003,18.399999999999999]
[null,null,null,null,null,null,null,null,0.47,0.47999998999999999,18.8]
[null,null,null,null,null,null,null,null,0.48,0.48999999,19.2]
[null,null,null,null,null,null,null,null,0.49,0.49999999000000001,19.600000000000001]
[null,null,null,null,null,"Revised 12/2018 by AC",null,null,0.5,0.50999998999999996,20]
[null,null,null,null,null,null,null,null,0.51,0.51999998999999997,20.399999999999999]
[null,null,null,null,null,null,null,null,0.52,0.52999998999999998,20.8]
[null,null,null,null,null,null,null,null,0.53,0.53999998999999999,21.2]
[null,null,null,null,null,null,null,null,0.54,0.54999998999999999,21.6]
[null,null,null,null,null,null,null,null,0.55000000000000004,0.55999999,22]
[null,null,null,null,null,null,null,null,0.56000000000000005,0.56999999000000001,22.4]
[null,null,null,null,null,null,null,null,0.56999999999999995,0.57999998999999991,22.8]
[null,null,null,null,null,null,null,null,0.57999999999999996,0.58999998999999992,23.2]
[null,null,null,null,null,null,null,null,0.59,0.59999998999999993,23.6]
[null,null,null,null,null,null,null,null,0.6,0.60999998999999994,24]
[null,null,null,null,null,null,null,null,0.60999999999999743,0.61999998999999739,24.399999999999899]
[null,null,null,null,null,null,null,null,0.61999999999999755,0.62999998999999751,24.799999999999901]
[null,null,null,null,null,null,null,null,0.62999999999999745,0.63999998999999741,25.1999999999999]
[null,null,null,null,null,null,null,null,0.63999999999999746,0.64999998999999742,25.599999999999898]
[null,null,null,null,null,null,null,null,0.64999999999999747,0.65999998999999743,25.999999999999901]
[null,null,null,null,null,null,null,null,0.65999999999999748,0.66999998999999744,26.399999999999899]
[null,null,null,null,null,null,null,null,0.66999999999999749,{"$f":"I67+0.00999999","v":0.67999998999999745},26.799999999999901]
[null,null,null,null,null,null,null,null,0.6799999999999975,0.68999998999999745,27.1999999999999]
[null,null,null,null,null,null,null,null,0.6899999999999975,0.69999998999999746,27.599999999999898]
[null,null,null,null,null,null,null,null,0.69999999999999751,0.70999998999999747,27.999999999999901]
[null,null,null,null,null,null,null,null,0.70999999999999752,0.71999998999999748,28.399999999999899]
[null,null,null,null,null,null,null,null,0.71999999999999753,0.72999998999999749,28.799999999999901]
[null,null,null,null,null,null,null,null,0.72999999999999754,0.7399999899999975,29.1999999999999]
[null,null,null,null,null,null,null,null,0.73999999999999744,0.7499999899999974,29.599999999999898]
[null,null,null,null,null,null,null,null,0.74999999999999756,0.75999998999999752,29.999999999999901]
[null,null,null,null,null,null,null,null,0.75999999999999746,0.76999998999999741,30.399999999999899]
[null,null,null,null,null,null,null,null,0.76999999999999758,0.77999998999999753,30.799999999999901]
[null,null,null,null,null,null,null,null,0.77999999999999747,0.78999998999999743,31.1999999999999]
[null,null,null,null,null,null,null,null,0.78999999999999748,0.79999998999999744,31.599999999999898]
[null,null,null,null,null,null,null,null,0.79999999999999749,0.80999998999999745,31.999999999999901]
[null,null,null,null,null,null,null,null,0.8099999999999975,0.81999998999999746,32.399999999999899]
[null,null,null,null,null,null,null,null,0.8199999999999974,0.82999998999999736,32.799999999999898]
[null,null,null,null,null,null,null,null,0.82999999999999763,0.83999998999999759,33.199999999999903]
[null,null,null,null,null,null,null,null,0.83999999999999753,0.84999998999999749,33.599999999999902]
[null,null,null,null,null,null,null,null,0.84999999999999754,0.85999998999999749,33.999999999999901]
[null,null,null,null,null,null,null,null,0.85999999999999743,0.86999998999999739,34.399999999999899]
[null,null,null,null,null,null,null,null,0.86999999999999744,0.8799999899999974,34.799999999999898]
[null,null,null,null,null,null,null,null,0.87999999999999756,0.88999998999999752,35.199999999999903]
[null,null,null,null,null,null,null,null,0.88999999999999757,0.89999998999999753,35.599999999999902]
[null,null,null,null,null,null,null,null,0.89999999999999747,0.90999998999999743,35.999999999999901]
[null,null,null,null,null,null,null,null,0.90999999999999748,0.91999998999999744,36.399999999999899]
[null,null,null,null,null,null,null,null,0.91999999999999749,0.92999998999999745,36.799999999999898]
[null,null,null,null,null,null,null,null,0.92999999999999761,0.93999998999999756,37.199999999999903]
[null,null,null,null,null,null,null,null,0.9399999999999975,0.94999998999999746,37.599999999999902]
[null,null,null,null,null,null,null,null,0.94999999999999751,0.95999998999999747,37.999999999999901]
[null,null,null,null,null,null,null,null,0.95999999999999752,0.96999998999999748,38.399999999999899]
[null,null,null,null,null,null,null,null,0.96999999999999742,0.97999998999999738,38.799999999999898]
[null,null,null,null,null,null,null,null,0.97999999999999754,0.9899999899999975,39.199999999999903]
[null,null,null,null,null,null,null,null,0.98999999999999755,{"$f":"I99+0.00999999","v":0.99999998999999751},39.599999999999902]
[null,null,null,null,null,null,null,null,0.99999999999999756,{"$f":"I100+0.00999999","v":1.0099999899999976},39.999999999999901]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This calculator needs to be used to calculate the FTE for teaching adjuncts (9001A-9005A). Only individuals who are the Instructor of Record can be placed in teaching adjunct job codes",null,null,"This calculator needs to be used to calculate the FTE for teaching dual compensations (9001X-9005X). Only individuals who are the Instructor of Record for the teaching dual compensation position can be placed in teaching dual compensation job codes."]
[null,"• Teaching adjunct job codes are:\n          o 9001A-Adjunct Professor\n          o 9002A-Adjunct Associate Professor\n          o 9003A-Adjunct Assistant Professor\n          o 9004A-Adjunct Instructor\n          o 9005A-Adjunct Lecturer\n• One credit hour is equivalent to 3 standard hours. \n• Teaching Adjunct’s FTE is based on:\n          o Credit hours\n          o Number of sessions per course\n          o Load factor\n\n",null,null,"• Teaching dual compensation job codes are:\n          o 9001X- Professor-Dual Compensation\n          o 9002X- Associate Professor-Dual Compensation\n          o 9003X- Assistant Professor-Dual Compensation\n          o 9004X- Instructor-Dual Compensation\n          o 9005X- Lecturer-Dual Compensation\n• One credit hour is equivalent to 3 standard hours. \n• Teaching Dual Compensation’s FTE is based on:\n          o Credit hours\n          o Number of sessions per course\n          o Load factor\n\n"]

{"sheet":"Contract Amount ePAF Calculator","index":1,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[17,3,17,11],[18,3,18,11],[8,3,8,11],[9,3,9,11],[10,3,10,11],[12,3,12,11],[13,3,13,11],[15,3,15,11],[16,3,16,11]]}
[]
[]
[]
[null,null,null,"ePAF Calculator"]
[]
[]
[]
[]
[null,"A",null,{"$f":"IF(C9=\"\",\"Input Begin Date\",\"Begin Date\")","v":"Input Begin Date"}]
[null,"B",null,{"$f":"IF(C10=\"\",\"Input End Date\",\"End Date\")","v":"Input End Date"}]
[null,null,{"$f":"IF(C9=\"\",\"\",IF(C10=\"\",\"\",NETWORKDAYS(C9,C10)/10))","v":""},{"$f":"IF(C11=\"\",\"\",IF(C11<0,\"WARNING! End Date is Before Start Date\",IF(C11>26.1,\"WARNING! Date Range is greater than 26.1 Pay Periods\",\"Number of Pay Periods\")))","v":""}]
[null,null,null,"There are 26.1 pay periods in a regular calendar year.  During leap years there are 26.2 pay periods."]
[null,"C",null,{"$f":"IF(C13=\"\",\"Input Contract Amount\",\"Contract Amount\")","v":"Input Contract Amount"}]
[null,null,{"$f":"IF(C11<=0,\"\",IF(C9=\"\",\"\",IF(C10=\"\",\"\",IF(C13=\"\",\"\",C13/C11))))","v":""},{"$f":"IF(C14=\"\",\"\",\"Fixed Bi-Weekly Rate\")","v":""}]
[]
[null,"D",{"$f":"'Adjunct - Dual Comp Form'!F35","v":""},{"$f":"IF(ISNUMBER(C16),\"PeopleSoft FTE Automatically Populated by Adjunct - Dual Compensation FTE Calculator\",\"Please Complete Adjunct - Dual Comp FTE Calculator Before using ePAF Calculator\")","v":"Please Complete Adjunct - Dual Comp FTE Calculator Before using ePAF Calculator"}]
[null,"E",{"$f":"'Adjunct - Dual Comp Form'!F36","v":""},{"$f":"IF(ISNUMBER(C17),\"PeopleSoft Standard Hours Automatically Populated by Adjunct - Dual Compensation FTE Calculator\",\"Please Complete Adjunct - Dual Comp FTE Calculator Before using ePAF Calculator\")","v":"Please Complete Adjunct - Dual Comp FTE Calculator Before using ePAF Calculator"}]
[]
[null,null,{"$f":"IF(C11<0,\"\",IF(C9=\"\",\"\",IF(C10=\"\",\"\",IF(C13=\"\",\"\",IF(C16<=0,\"\",IF(C16=\"\",\"\",IF(C16>1,\"\",C14/('Adjunct - Dual Comp Form'!F36*2))))))))","v":""},{"$f":"IF(C19=\"\",\"\",IF(C19<8.46,\"WARNING!  Hourly Rate of Pay is less than $8.46 Minimum Hourly Rate\",IF(C19>200,\"WARNING!  Hourly Rate of Pay is Greater than $200.00/hour\",\"Hourly Rate of Pay\")))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Revised on 12/2018 by AC"]