{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Summer Salary Form by Effort","Sheet1","Summer Salary Form by Amount","Sheet2"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":16,"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":"Instructions","index":0,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Instructions to complete the Summer Salary Form"]
[]
["To complete this form, populate each box with the requested information."]
["All June requests need to be kept separate from July and August."]
["Instructions to complete the Summer Salary Form by Effort"]
["Monthly Salary and Amount for each project auto calculates based on the input."]
["Monthly Salary calculation for academic year is based on 9 months appointment and calendar year is based on 11 months appointment."]
["For those faculty paid on NIH (National Institute of Health) award, enter the NIH salary limitation. For example, effective Janauary 2, 2022, "]
["the salary limitation for FY 2022 for Executive Level II is $203,700."]
["If the faculty monthly salary is greater than NIH salary cap, NIH monthly salary limit amount will auto populate. "]
["If the faculty monthly salary is less than NIH salary cap, effort needs to be entered to calculated the amount. "]
["For Faculty paid on NSF (National Science Foundation) award: A summer salary that exceeds 2/9 of the academic year salary is not allowable for academic year appointees. "]
["Similarly, a summer salary of 1/11 for calendar year appointees in lieu of vacation is not allowed."]
["Please refer to the monthly salary, amount of request for a particular period should not exceed the monthly salary. "]
["When the request is for less than a month, please select the number of working days in the month. "]
[]
["For example, in FY22 Networking days for June=22 and FY23 Networking days July=21 and August=23. "]
["Please refer to the below calendar"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Instructions to complete the Summer Salary Form by Amount"]
["Effort for each project and period will be auto calculated based on the input of amount"]

{"sheet":"Summer Salary Form by Effort","index":1,"n_rows":41,"n_cols":42,"rows_kept":41,"cut":false,"hidden":false,"merged":[[18,35,18,41],[18,16,18,22],[18,26,18,32],[0,1,0,12],[10,2,10,8],[16,1,16,12],[17,1,17,11],[18,2,18,4],[6,2,6,8],[11,2,11,3],[7,2,7,5],[8,2,8,5],[9,2,9,5],[32,1,32,12],[28,1,28,12],[30,1,30,12],[27,2,27,4],[25,2,25,4],[26,2,26,4],[23,2,23,4],[18,6,18,7],[18,8,18,9],[19,6,19,7],[20,6,20,7],[22,2,22,4],[22,6,22,7],[21,8,21,9],[22,8,22,9],[19,2,19,4],[20,2,20,4],[19,8,19,9],[20,8,20,9],[21,6,21,7],[21,2,21,4],[36,5,36,8],[36,9,36,11],[40,5,40,8],[40,9,40,11],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[27,6,27,7],[27,8,27,9],[23,6,23,7],[25,6,25,7],[26,6,26,7],[29,1,29,12],[24,2,24,4],[24,6,24,7]]}
[null,"Faculty Summer Salary Authorization Form"]
[null,"To complete this form, populate each box with the requested information."]
[null,"Refer to the Faculty Summer Salary instructions before processing appointments in the Peoplesoft system."]
[]
[null,"Requestor Information and Decanal Endorsement:"]
[]
[null,"PI's Name: ",null,null,null,null,null,null,null,null,"Date:"]
[null,"Employee ID:"]
[null,"Current Salary:",null,null,null,null,null,null,null,null,"Monthly Salary:",{"$f":"Sheet1!B8","v":0}]
[null,"AY or CY:"]
[null,"Department:",null,null,null,null,null,null,null,null,"Fiscal Year:",2022]
[null,"Department ID:"]
[null,null,null,null,null,null,null,null,null,null,null,"NIH cap:"]
[null,"For those faculty paid on NIH (National Institute of Health) award, enter the salary limitation:",null,null,null,null,null,null,null,null,null,203700]
[]
[null,"Business Purpose/Justification:"]
[]
[null,"List Amount of Pay Below: (for Summer Salary, list by each project, period and funding individually)"]
[null,"Project No. & Task","Amount",null,null,"%\nEffort","Period",null,"Period/Month (From)",null,"Period/Month (To)","Funding Source","Project Description",null,null,null,{"$f":"Sheet1!H2&\" \"&L11-1","v":"July  2021"},null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!I2&\" \"&'Summer Salary Form by Effort'!L11-1","v":"August 2021"},null,null,null,null,null,null,null,null,{"$f":"Sheet1!G2&\" \"&L11","v":"June 2022"}]
[null,null,{"$f":"Sheet1!L7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"M","T","W","T","F","S","S",null,null,null,"M","T","W","T","F","S","S",null,null,"M","T","W","T","F","S","S"]
[null,null,{"$f":"Sheet1!$L$15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATEVALUE(\"1-\"&Sheet1!H2&\"-\"&L11-1)-WEEKDAY(DATEVALUE(\"1-\"&Sheet1!H2&\"-\"&L11-1),3)","v":"2021-06-28"},{"$f":"Q21+1","v":"2021-06-29"},{"$f":"R21+1","v":"2021-06-30"},"2021-07-01","2021-07-02","2021-07-03","2021-07-04",null,null,null,{"$f":"DATEVALUE(\"1-\"&Sheet1!I2&\"-\"&L11-1)-WEEKDAY(DATEVALUE(\"1-\"&Sheet1!I2&\"-\"&L11-1),3)","v":"2021-07-26"},{"$f":"AA21+1","v":"2021-07-27"},{"$f":"AB21+1","v":"2021-07-28"},"2021-07-29","2021-07-30","2021-07-31","2021-08-01",null,null,{"$f":"DATEVALUE(\"1-\"&Sheet1!G2&\"-\"&L11)-WEEKDAY(DATEVALUE(\"1-\"&Sheet1!G2&\"-\"&L11),3)","v":"2022-05-30"},{"$f":"AJ21+1","v":"2022-05-31"},{"$f":"AK21+1","v":"2022-06-01"},"2022-06-02","2022-06-03","2022-06-04","2022-06-05"]
[null,null,{"$f":"Sheet1!$L$23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q21+7","v":"2021-07-05"},{"$f":"R21+7","v":"2021-07-06"},"2021-07-07","2021-07-08","2021-07-09","2021-07-10","2021-07-11",null,null,null,{"$f":"AA21+7","v":"2021-08-02"},{"$f":"AB21+7","v":"2021-08-03"},"2021-08-04","2021-08-05","2021-08-06","2021-08-07","2021-08-08",null,null,{"$f":"AJ21+7","v":"2022-06-06"},{"$f":"AK21+7","v":"2022-06-07"},"2022-06-08","2022-06-09","2022-06-10","2022-06-11","2022-06-12"]
[null,null,{"$f":"Sheet1!$L$31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q22+7","v":"2021-07-12"},{"$f":"R22+7","v":"2021-07-13"},"2021-07-14","2021-07-15","2021-07-16","2021-07-17","2021-07-18",null,null,null,{"$f":"AA22+7","v":"2021-08-09"},{"$f":"AB22+7","v":"2021-08-10"},{"$f":"AC22+7","v":"2021-08-11"},{"$f":"AD22+7","v":"2021-08-12"},{"$f":"AE22+7","v":"2021-08-13"},{"$f":"AF22+7","v":"2021-08-14"},{"$f":"AG22+7","v":"2021-08-15"},null,null,{"$f":"AJ22+7","v":"2022-06-13"},{"$f":"AK22+7","v":"2022-06-14"},{"$f":"AL22+7","v":"2022-06-15"},{"$f":"AM22+7","v":"2022-06-16"},{"$f":"AN22+7","v":"2022-06-17"},{"$f":"AO22+7","v":"2022-06-18"},{"$f":"AP22+7","v":"2022-06-19"}]
[null,null,{"$f":"Sheet1!$L$39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q23+7","v":"2021-07-19"},"2021-07-20","2021-07-21","2021-07-22","2021-07-23","2021-07-24","2021-07-25",null,null,null,"2021-08-16","2021-08-17","2021-08-18","2021-08-19","2021-08-20","2021-08-21","2021-08-22",null,null,"2022-06-20","2022-06-21","2022-06-22","2022-06-23","2022-06-24","2022-06-25","2022-06-26"]
[null,null,{"$f":"Sheet1!$L$47","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q24+7","v":"2021-07-26"},"2021-07-27","2021-07-28","2021-07-29","2021-07-30","2021-07-31","2021-08-01",null,null,null,"2021-08-23","2021-08-24","2021-08-25","2021-08-26","2021-08-27","2021-08-28","2021-08-29",null,null,"2022-06-27","2022-06-28","2022-06-29","2022-06-30","2022-07-01","2022-07-02","2022-07-03"]
[null,null,{"$f":"Sheet1!$L$55","v":0}]
[null,null,{"$f":"Sheet1!$L$63","v":0}]
[null,"TOTAL:",{"$f":"SUM($C$20:$E$27)","v":0},null,null,"%"]
[null,"Note: Faculty members receiving 3/9ths or 1/11th of their salary are expected to forego vacation during the period coinciding with the work effort; they must affirm in writing that they are not taking any vacation during that time. Under no circumstances may academic or calendar year faculty receive summer compensation exceeding 3/9ths or 1/11th of their respective salary. Please attach any “no vacation” letter signed by said faculty member, and the department Chair."]
[null,"Summer salary will not be allowed to be transferred to any grant account 90-days after the transaction has posted to the General Ledger."]
[null,"The cut off for summer salary will be September 30th. This is a firm deadline with no exceptions.                                                                                                                                                                                                                                "]
[null,"Provide Any Additional Comments Below:"]
[]
[]
[null,"Business Officer Signature                                                                                                            ",null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Type Business Officer’s Name:",null,null,null,null,null,null,null,", Business Office Director"]
[]
[null,"Research Director Signature                                                                                                   ",null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Type Dean/Director’s Name:",null,null,null,null,null,null,null,", Director of Research"]

{"sheet":"Sheet1","index":2,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":true,"merged":[[25,10,26,10],[29,10,30,10],[33,10,34,10],[37,10,38,10],[1,10,2,10],[5,10,6,10],[9,10,10,10],[13,10,14,10],[17,10,18,10],[21,10,22,10],[61,10,62,10],[41,10,42,10],[45,10,46,10],[49,10,50,10],[53,10,54,10],[57,10,58,10]]}
[null,null,null,null,null,null,6,7,8]
[null,"Appointment",null,"Funding",null,null,"June","July ","August",null,"Step :1","Salary calculation-NIH/non-NIH plus effort"]
[null,"AY",null,"DOD ",null,null,{"$f":"DATE('Summer Salary Form by Effort'!$L$11,Sheet1!$G$1,1)","v":"2022-06-01"},{"$f":"DATE('Summer Salary Form by Effort'!$L$11-1,Sheet1!$H$1,1)","v":"2021-07-01"},{"$f":"DATE('Summer Salary Form by Effort'!$L$11-1,Sheet1!$I$1,1)","v":"2021-08-01"},null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$L$20=\"NIH\",Sheet1!$B$16>=Sheet1!$B$8),Sheet1!$B$8*'Summer Salary Form by Effort'!$F$20,IF(AND('Summer Salary Form by Effort'!$L$20=\"NIH\",Sheet1!$B$16<=Sheet1!$B$8),Sheet1!$B$16,Sheet1!$B$8*'Summer Salary Form by Effort'!$F$20))","v":0}]
[null,"CY",null,"Faculty Funds",null,null,{"$f":"G3+1","v":"2022-06-02"},{"$f":"H3+1","v":"2021-07-02"},{"$f":"I3+1","v":"2021-08-02"}]
[null,null,null,"NIH",null,null,{"$f":"G4+1","v":"2022-06-03"},{"$f":"H4+1","v":"2021-07-03"},{"$f":"I4+1","v":"2021-08-03"}]
[null,null,null,"NOAA",null,null,"2022-06-04","2021-07-04","2021-08-04",null,"Step :2","Salary calculaton based on NWD"]
[null,"Monthly Salary",null,"NSF",null,null,"2022-06-05","2021-07-05","2021-08-05",null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$G$20=\"June\",NETWORKDAYS('Summer Salary Form by Effort'!$I$20,'Summer Salary Form by Effort'!$K$20)<Sheet1!$B$20),Sheet1!$L$3/Sheet1!$B$20*NETWORKDAYS('Summer Salary Form by Effort'!$I$20,'Summer Salary Form by Effort'!$K$20),IF(AND('Summer Salary Form by Effort'!$G$20=\"July\",NETWORKDAYS('Summer Salary Form by Effort'!$I$20,'Summer Salary Form by Effort'!$K$20)<Sheet1!$B$24),Sheet1!$L$3/Sheet1!$B$24*NETWORKDAYS('Summer Salary Form by Effort'!$I$20,'Summer Salary Form by Effort'!$K$20),IF(AND('Summer Salary Form by Effort'!$G$20=\"August\",NETWORKDAYS('Summer Salary Form by Effort'!$I$20,'Summer Salary Form by Effort'!$K$20)<Sheet1!$B$28),Sheet1!$L$3/Sheet1!$B$28*NETWORKDAYS('Summer Salary Form by Effort'!$I$20,'Summer Salary Form by Effort'!$K$20),$L$3)))","v":0}]
[null,{"$f":"IF('Summer Salary Form by Effort'!$C$10=\"AY\",('Summer Salary Form by Effort'!$C$9/9),('Summer Salary Form by Effort'!$C$9/11))","v":0},null,"Other Grants","Fiscal Year",null,"2022-06-06","2021-07-06","2021-08-06"]
[null,null,null,"SNJ",2022,null,"2022-06-07","2021-07-07","2021-08-07"]
[null,null,null,"USDA",2023,null,"2022-06-08","2021-07-08","2021-08-08",null,"Step :3","Basis for salary calcualtion for Line#2"]
[null,"NIH cap",null,null,2024,null,"2022-06-09","2021-07-09","2021-08-09",null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$L$21=\"NIH\",Sheet1!$B$16>=Sheet1!$B$8),Sheet1!$B$8*'Summer Salary Form by Effort'!$F$21,IF(AND('Summer Salary Form by Effort'!$L$21=\"NIH\",Sheet1!$B$16<=Sheet1!$B$8),Sheet1!$B$16,Sheet1!$B$8*'Summer Salary Form by Effort'!$F$21))","v":0}]
[null,{"$f":"'Summer Salary Form by Effort'!L14","v":203700},null,null,2025,null,"2022-06-10","2021-07-10","2021-08-10"]
[null,null,null,null,2026,null,"2022-06-11","2021-07-11","2021-08-11"]
[null,null,null,null,2027,null,"2022-06-12","2021-07-12","2021-08-12",null,"Step:4","Salary calculation for Line#2"]
[null,"Monthly NIH Salary",null,null,2028,null,"2022-06-13","2021-07-13","2021-08-13",null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$G$21=\"June\",NETWORKDAYS('Summer Salary Form by Effort'!$I$21,'Summer Salary Form by Effort'!$K$21)<Sheet1!$B$20),Sheet1!$L$11/Sheet1!$B$20*NETWORKDAYS('Summer Salary Form by Effort'!$I$21,'Summer Salary Form by Effort'!$K$21),IF(AND('Summer Salary Form by Effort'!$G$21=\"July\",NETWORKDAYS('Summer Salary Form by Effort'!$I$21,'Summer Salary Form by Effort'!$K$21)<Sheet1!$B$24),Sheet1!$L$11/Sheet1!$B$24*NETWORKDAYS('Summer Salary Form by Effort'!$I$21,'Summer Salary Form by Effort'!$K$21),IF(AND('Summer Salary Form by Effort'!$G$21=\"August\",NETWORKDAYS('Summer Salary Form by Effort'!$I$21,'Summer Salary Form by Effort'!$K$21)<Sheet1!$B$28),Sheet1!$L$11/Sheet1!$B$28*NETWORKDAYS('Summer Salary Form by Effort'!$I$21,'Summer Salary Form by Effort'!$K$21),$L$11)))","v":0}]
[null,{"$f":"B12/12","v":16975},null,null,2029,null,"2022-06-14","2021-07-14","2021-08-14"]
[null,null,null,null,2030,null,"2022-06-15","2021-07-15","2021-08-15"]
[null,null,null,null,2031,null,"2022-06-16","2021-07-16","2021-08-16",null,"Step :5","Basis for salary calcualtion for Line#3"]
[null,"Networking days in June",null,null,2032,null,"2022-06-17","2021-07-17","2021-08-17",null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$L$22=\"NIH\",Sheet1!$B$16>=Sheet1!$B$8),Sheet1!$B$8*'Summer Salary Form by Effort'!$F$22,IF(AND('Summer Salary Form by Effort'!$L$22=\"NIH\",Sheet1!$B$16<=Sheet1!$B$8),Sheet1!$B$16,Sheet1!$B$8*'Summer Salary Form by Effort'!$F$22))","v":0}]
[null,{"$f":"NETWORKDAYS.INTL($G$3,$G$32,1)","v":22},null,null,2033,null,"2022-06-18","2021-07-18","2021-08-18"]
[null,null,null,null,2034,null,"2022-06-19","2021-07-19","2021-08-19"]
[null,null,null,null,2035,null,"2022-06-20","2021-07-20","2021-08-20",null,"Step :6","Salary calculation for Line#3"]
[null,"Networking days in July",null,null,2036,null,"2022-06-21","2021-07-21","2021-08-21",null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$G$22=\"June\",NETWORKDAYS('Summer Salary Form by Effort'!$I$22,'Summer Salary Form by Effort'!$K$22)<Sheet1!$B$20),Sheet1!$L$19/Sheet1!$B$20*NETWORKDAYS('Summer Salary Form by Effort'!$I$22,'Summer Salary Form by Effort'!$K$22),IF(AND('Summer Salary Form by Effort'!$G$22=\"July\",NETWORKDAYS('Summer Salary Form by Effort'!$I$22,'Summer Salary Form by Effort'!$K$22)<Sheet1!$B$24),Sheet1!$L$19/Sheet1!$B$24*NETWORKDAYS('Summer Salary Form by Effort'!$I$22,'Summer Salary Form by Effort'!$K$22),IF(AND('Summer Salary Form by Effort'!$G$22=\"August\",NETWORKDAYS('Summer Salary Form by Effort'!$I$22,'Summer Salary Form by Effort'!$K$22)<Sheet1!$B$28),Sheet1!$L$19/Sheet1!$B$28*NETWORKDAYS('Summer Salary Form by Effort'!$I$22,'Summer Salary Form by Effort'!$K$22),$L$19)))","v":0}]
[null,{"$f":"NETWORKDAYS.INTL($H$3,$H$33,1)","v":22},null,null,2037,null,"2022-06-22","2021-07-22","2021-08-22"]
[null,null,null,null,2038,null,"2022-06-23","2021-07-23","2021-08-23"]
[null,null,null,null,2039,null,"2022-06-24","2021-07-24","2021-08-24",null,"Step :7","Basis for salary calcualtion for Line#4"]
[null,"Networking days in August",null,null,2040,null,"2022-06-25","2021-07-25","2021-08-25",null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$L$23=\"NIH\",Sheet1!$B$16>=Sheet1!$B$8),Sheet1!$B$8*'Summer Salary Form by Effort'!$F$23,IF(AND('Summer Salary Form by Effort'!$L$23=\"NIH\",Sheet1!$B$16<=Sheet1!$B$8),Sheet1!$B$16,Sheet1!$B$8*'Summer Salary Form by Effort'!$F$23))","v":0}]
[null,{"$f":"NETWORKDAYS.INTL($I$3,$I$33,1)","v":22},null,null,2041,null,"2022-06-26","2021-07-26","2021-08-26"]
[null,null,null,null,2042,null,"2022-06-27","2021-07-27","2021-08-27"]
[null,null,null,null,2043,null,"2022-06-28","2021-07-28","2021-08-28",null,"Step :8","Salary calculation for Line#4"]
[null,"Independence Day",null,null,2044,null,"2022-06-29","2021-07-29","2021-08-29",null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$G$23=\"June\",NETWORKDAYS('Summer Salary Form by Effort'!$I$23,'Summer Salary Form by Effort'!$K$23)<Sheet1!$B$20),Sheet1!$L$27/Sheet1!$B$20*NETWORKDAYS('Summer Salary Form by Effort'!$I$23,'Summer Salary Form by Effort'!$K$23),IF(AND('Summer Salary Form by Effort'!$G$23=\"July\",NETWORKDAYS('Summer Salary Form by Effort'!$I$23,'Summer Salary Form by Effort'!$K$23)<Sheet1!$B$24),Sheet1!$L$27/Sheet1!$B$24*NETWORKDAYS('Summer Salary Form by Effort'!$I$23,'Summer Salary Form by Effort'!$K$23),IF(AND('Summer Salary Form by Effort'!$G$23=\"August\",NETWORKDAYS('Summer Salary Form by Effort'!$I$23,'Summer Salary Form by Effort'!$K$23)<Sheet1!$B$28),Sheet1!$L$27/Sheet1!$B$28*NETWORKDAYS('Summer Salary Form by Effort'!$I$23,'Summer Salary Form by Effort'!$K$23),$L$27)))","v":0}]
[null,{"$f":"DATE('Summer Salary Form by Effort'!$L$11,$H$1,4)","v":"2022-07-04"},null,null,2045,null,"2022-06-30","2021-07-30","2021-08-30"]
[null,null,null,null,2046,null,null,"2021-07-31","2021-08-31"]
[null,null,null,null,2047,null,null,null,null,null,"Step :9","Basis for salary calcualtion for Line#5"]
[null,null,null,null,2048,null,null,null,null,null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$L$24=\"NIH\",Sheet1!$B$16>=Sheet1!$B$8),Sheet1!$B$8*'Summer Salary Form by Effort'!$F$24,IF(AND('Summer Salary Form by Effort'!$L$24=\"NIH\",Sheet1!$B$16<=Sheet1!$B$8),Sheet1!$B$16,Sheet1!$B$8*'Summer Salary Form by Effort'!$F$24))","v":0}]
[null,null,null,null,2049]
[null,null,null,null,2050]
[null,null,null,null,null,null,null,null,null,null,"Step :10","Salary calculation for Line#5"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$G$24=\"June\",NETWORKDAYS('Summer Salary Form by Effort'!$I$24,'Summer Salary Form by Effort'!$K$24)<Sheet1!$B$20),Sheet1!$L$35/Sheet1!$B$20*NETWORKDAYS('Summer Salary Form by Effort'!$I$24,'Summer Salary Form by Effort'!$K$24),IF(AND('Summer Salary Form by Effort'!$G$24=\"Juy\",NETWORKDAYS('Summer Salary Form by Effort'!$I$24,'Summer Salary Form by Effort'!$K$24)<Sheet1!$B$24),Sheet1!$L$35/Sheet1!$B$24*NETWORKDAYS('Summer Salary Form by Effort'!$I$24,'Summer Salary Form by Effort'!$K$24),IF(AND('Summer Salary Form by Effort'!$G$24=\"August\",NETWORKDAYS('Summer Salary Form by Effort'!$I$24,'Summer Salary Form by Effort'!$K$24)<Sheet1!$B$28),Sheet1!$L$35/Sheet1!$B$28*NETWORKDAYS('Summer Salary Form by Effort'!$I$24,'Summer Salary Form by Effort'!$K$24),$L$35)))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Step :11","Basis for salary calcualtion for Line#6"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$L$25=\"NIH\",Sheet1!$B$16>=Sheet1!$B$8),Sheet1!$B$8*'Summer Salary Form by Effort'!$F$25,IF(AND('Summer Salary Form by Effort'!$L$25=\"NIH\",Sheet1!$B$16<=Sheet1!$B$8),Sheet1!$B$16,Sheet1!$B$8*'Summer Salary Form by Effort'!$F$25))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Step :12","Salary calculation for Line#6"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$G$25=\"June\",NETWORKDAYS('Summer Salary Form by Effort'!$I$25,'Summer Salary Form by Effort'!$K$25)<Sheet1!$B$20),Sheet1!$L$43/Sheet1!$B$20*NETWORKDAYS('Summer Salary Form by Effort'!$I$25,'Summer Salary Form by Effort'!$K$25),IF(AND('Summer Salary Form by Effort'!$G$25=\"July\",NETWORKDAYS('Summer Salary Form by Effort'!$I$25,'Summer Salary Form by Effort'!$K$25)<Sheet1!$B$24),Sheet1!$L$43/Sheet1!$B$24*NETWORKDAYS('Summer Salary Form by Effort'!$I$25,'Summer Salary Form by Effort'!$K$25),IF(AND('Summer Salary Form by Effort'!$G$25=\"August\",NETWORKDAYS('Summer Salary Form by Effort'!$I$25,'Summer Salary Form by Effort'!$K$25)<Sheet1!$B$28),Sheet1!$L$43/Sheet1!$B$28*NETWORKDAYS('Summer Salary Form by Effort'!$I$25,'Summer Salary Form by Effort'!$K$25),$L$43)))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Step :13","Basis for salary calcualtion for Line#7"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$L$26=\"NIH\",Sheet1!$B$16>=Sheet1!$B$8),Sheet1!$B$8*'Summer Salary Form by Effort'!$F$26,IF(AND('Summer Salary Form by Effort'!$L$26=\"NIH\",Sheet1!$B$16<=Sheet1!$B$8),Sheet1!$B$16,Sheet1!$B$8*'Summer Salary Form by Effort'!$F$26))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Step :14","Salary calculation for Line#7"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$G$26=\"June\",NETWORKDAYS('Summer Salary Form by Effort'!$I$26,'Summer Salary Form by Effort'!$K$26)<Sheet1!$B$20),Sheet1!$L$51/Sheet1!$B$20*NETWORKDAYS('Summer Salary Form by Effort'!$I$26,'Summer Salary Form by Effort'!$K$26),IF(AND('Summer Salary Form by Effort'!$G$26=\"July\",NETWORKDAYS('Summer Salary Form by Effort'!$I$26,'Summer Salary Form by Effort'!$K$26)<Sheet1!$B$24),Sheet1!$L$51/Sheet1!$B$24*NETWORKDAYS('Summer Salary Form by Effort'!$I$26,'Summer Salary Form by Effort'!$K$26),IF(AND('Summer Salary Form by Effort'!$G$26=\"August\",NETWORKDAYS('Summer Salary Form by Effort'!$I$26,'Summer Salary Form by Effort'!$K$26)<Sheet1!$B$28),Sheet1!$L$51/Sheet1!$B$28*NETWORKDAYS('Summer Salary Form by Effort'!$I$26,'Summer Salary Form by Effort'!$K$26),$L$51)))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Step :15","Basis for salary calcualtion for Line#8"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$L$27=\"NIH\",Sheet1!$B$16>=Sheet1!$B$8),Sheet1!$B$8*'Summer Salary Form by Effort'!$F$27,IF(AND('Summer Salary Form by Effort'!$L$26=\"NIH\",Sheet1!$B$16<=Sheet1!$B$8),Sheet1!$B$16,Sheet1!$B$8*'Summer Salary Form by Effort'!$F$27))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Step :16","Salary calculation for Line#8"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Summer Salary Form by Effort'!$G$27=\"June\",NETWORKDAYS('Summer Salary Form by Effort'!$I$27,'Summer Salary Form by Effort'!$K$27)<Sheet1!$B$20),Sheet1!$L$59/Sheet1!$B$20*NETWORKDAYS('Summer Salary Form by Effort'!$I$27,'Summer Salary Form by Effort'!$K$27),IF(AND('Summer Salary Form by Effort'!$G$27=\"July\",NETWORKDAYS('Summer Salary Form by Effort'!$I$27,'Summer Salary Form by Effort'!$K$27)<Sheet1!$B$24),Sheet1!$L$59/Sheet1!$B$24*NETWORKDAYS('Summer Salary Form by Effort'!$I$27,'Summer Salary Form by Effort'!$K$27),IF(AND('Summer Salary Form by Effort'!$G$27=\"August\",NETWORKDAYS('Summer Salary Form by Effort'!$I$27,'Summer Salary Form by Effort'!$K$27)<Sheet1!$B$28),Sheet1!$L$59/Sheet1!$B$28*NETWORKDAYS('Summer Salary Form by Effort'!$I$27,'Summer Salary Form by Effort'!$K$27),$L$59)))","v":0}]

{"sheet":"Summer Salary Form by Amount","index":3,"n_rows":41,"n_cols":42,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,5,40,8],[40,9,40,11],[28,1,28,12],[29,1,29,12],[30,1,30,12],[32,1,32,12],[36,5,36,8],[36,9,36,11],[26,2,26,4],[26,6,26,7],[26,8,26,9],[27,2,27,4],[27,6,27,7],[27,8,27,9],[24,2,24,4],[24,6,24,7],[24,8,24,9],[25,2,25,4],[25,6,25,7],[25,8,25,9],[22,2,22,4],[22,6,22,7],[22,8,22,9],[23,2,23,4],[23,6,23,7],[23,8,23,9],[20,2,20,4],[20,6,20,7],[20,8,20,9],[21,2,21,4],[21,6,21,7],[21,8,21,9],[18,16,18,22],[18,26,18,32],[18,35,18,41],[19,2,19,4],[19,6,19,7],[19,8,19,9],[11,2,11,3],[16,1,16,12],[17,1,17,11],[18,2,18,4],[18,6,18,7],[18,8,18,9],[10,2,10,8],[0,1,0,12],[6,2,6,8],[7,2,7,5],[8,2,8,5],[9,2,9,5]]}
[null,"Faculty Summer Salary Authorization Form"]
[null,"To complete this form, populate each box with the requested information."]
[null,"Refer to the Faculty Summer Salary instructions before processing appointments in the Peoplesoft system."]
[]
[null,"Requestor Information and Decanal Endorsement:"]
[]
[null,"PI's Name: ",null,null,null,null,null,null,null,null,"Date:"]
[null,"Employee ID:"]
[null,"Current Salary:",1,null,null,null,null,null,null,null,"Monthly Salary:",{"$f":"Sheet2!F3","v":0.1111111111111111}]
[null,"AY or CY:","AY"]
[null,"Department:",null,null,null,null,null,null,null,null,"Fiscal Year:",2022]
[null,"Department ID:"]
[null,null,null,null,null,null,null,null,null,null,null,"NIH cap:"]
[null,"For those faculty paid on NIH (National Institute of Health) award, enter the salary limitation:",null,null,null,null,null,null,null,null,null,203700]
[]
[null,"Business Purpose/Justification:"]
[]
[null,"List Amount of Pay Below: (for Summer Salary, list by each project, period and funding individually)"]
[null,"Project No. & Task","Amount",null,null,"%\nEffort","Period",null,"Period/Month (From)",null,"Period/Month (To)","Funding Source","Project Description",null,null,null,{"$f":"Sheet2!H2&\" \"&L11-1","v":"July  2021"},null,null,null,null,null,null,null,null,null,{"$f":"Sheet2!I2&\" \"&L11-1","v":"August 2021"},null,null,null,null,null,null,null,null,{"$f":"Sheet2!G2&\" \"&L11","v":"June 2022"}]
[null,null,null,null,null,{"$f":"Sheet2!$D$3","v":0},null,null,null,null,null,null,null,null,null,null,"M","T","W","T","F","S","S",null,null,null,"M","T","W","T","F","S","S",null,null,"M","T","W","T","F","S","S"]
[null,null,null,null,null,{"$f":"Sheet2!$D$7","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"DATEVALUE(\"1-\"&Sheet2!H2&\"-\"&L11-1)-WEEKDAY(DATEVALUE(\"1-\"&Sheet2!H2&\"-\"&L11-1),3)","v":"2021-06-28"},{"$f":"Q21+1","v":"2021-06-29"},{"$f":"R21+1","v":"2021-06-30"},"2021-07-01","2021-07-02","2021-07-03","2021-07-04",null,null,null,{"$f":"DATEVALUE(\"1-\"&Sheet2!I2&\"-\"&L11-1)-WEEKDAY(DATEVALUE(\"1-\"&Sheet2!I2&\"-\"&L11-1),3)","v":"2021-07-26"},{"$f":"AA21+1","v":"2021-07-27"},{"$f":"AB21+1","v":"2021-07-28"},"2021-07-29","2021-07-30","2021-07-31","2021-08-01",null,null,{"$f":"DATEVALUE(\"1-\"&Sheet2!G2&\"-\"&L11)-WEEKDAY(DATEVALUE(\"1-\"&Sheet2!G2&\"-\"&L11),3)","v":"2022-05-30"},{"$f":"AJ21+1","v":"2022-05-31"},{"$f":"AK21+1","v":"2022-06-01"},"2022-06-02","2022-06-03","2022-06-04","2022-06-05"]
[null,null,null,null,null,{"$f":"Sheet2!$D$11","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"Q21+7","v":"2021-07-05"},{"$f":"R21+7","v":"2021-07-06"},"2021-07-07","2021-07-08","2021-07-09","2021-07-10","2021-07-11",null,null,null,{"$f":"AA21+7","v":"2021-08-02"},{"$f":"AB21+7","v":"2021-08-03"},"2021-08-04","2021-08-05","2021-08-06","2021-08-07","2021-08-08",null,null,{"$f":"AJ21+7","v":"2022-06-06"},{"$f":"AK21+7","v":"2022-06-07"},"2022-06-08","2022-06-09","2022-06-10","2022-06-11","2022-06-12"]
[null,null,null,null,null,{"$f":"Sheet2!$D$15","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"Q22+7","v":"2021-07-12"},"2021-07-13","2021-07-14","2021-07-15","2021-07-16","2021-07-17","2021-07-18",null,null,null,{"$f":"AA22+7","v":"2021-08-09"},"2021-08-10","2021-08-11","2021-08-12","2021-08-13","2021-08-14","2021-08-15",null,null,{"$f":"AJ22+7","v":"2022-06-13"},"2022-06-14","2022-06-15","2022-06-16","2022-06-17","2022-06-18","2022-06-19"]
[null,null,null,null,null,{"$f":"Sheet2!$D$19","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"Q23+7","v":"2021-07-19"},"2021-07-20","2021-07-21","2021-07-22","2021-07-23","2021-07-24","2021-07-25",null,null,null,"2021-08-16","2021-08-17","2021-08-18","2021-08-19","2021-08-20","2021-08-21","2021-08-22",null,null,"2022-06-20","2022-06-21","2022-06-22","2022-06-23","2022-06-24","2022-06-25","2022-06-26"]
[null,null,null,null,null,{"$f":"Sheet2!$D$23","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"Q24+7","v":"2021-07-26"},"2021-07-27","2021-07-28","2021-07-29","2021-07-30","2021-07-31","2021-08-01",null,null,null,"2021-08-23","2021-08-24","2021-08-25","2021-08-26","2021-08-27","2021-08-28","2021-08-29",null,null,"2022-06-27","2022-06-28","2022-06-29","2022-06-30","2022-07-01","2022-07-02","2022-07-03"]
[null,null,null,null,null,{"$f":"Sheet2!$D$27","v":0}]
[null,null,null,null,null,{"$f":"Sheet2!$D$31","v":0}]
[null,"TOTAL:",{"$f":"SUM($C$20:$E$27)","v":0},null,null,"%"]
[null,"Note: Faculty members receiving 3/9ths or 1/11th of their salary are expected to forego vacation during the period coinciding with the work effort; they must affirm in writing that they are not taking any vacation during that time. Under no circumstances may academic or calendar year faculty receive summer compensation exceeding 3/9ths or 1/11th of their respective salary. Please attach any “no vacation” letter signed by said faculty member, and the department Chair."]
[null,"Summer salary will not be allowed to be transferred to any grant account 90-days after the transaction has posted to the General Ledger."]
[null,"The cut off for summer salary will be September 30th. This is a firm deadline with no exceptions.                                                                                                                                                                                                                                "]
[null,"Provide Any Additional Comments Below:"]
[]
[]
[null,"Business Officer Signature                                                                                                            ",null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Type Business Officer’s Name:",null,null,null,null,null,null,null,", Business Office Director"]
[]
[null,"Research Director Signature                                                                                                   ",null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Type Dean/Director’s Name:",null,null,null,null,null,null,null,", Director of Research"]

{"sheet":"Sheet2","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[[1,2,2,2],[5,2,6,2],[9,2,10,2],[25,2,26,2],[29,2,30,2],[13,2,14,2],[17,2,18,2],[21,2,22,2]]}
[null,null,null,null,null,null,6,7,8]
[null,null,"Step :1","Salary calculation-NIH/non-NIH plus effort",null,"Monthly Salary","June","July ","August"]
[null,null,null,{"$f":"IF('Summer Salary Form by Amount'!$C$20<='Summer Salary Form by Amount'!$L$9,'Summer Salary Form by Amount'!$C$20/'Summer Salary Form by Amount'!$L$9,\"Error\")","v":0},null,{"$f":"IF('Summer Salary Form by Amount'!$C$10=\"AY\",('Summer Salary Form by Amount'!$C$9/9),('Summer Salary Form by Amount'!$C$9/11))","v":0.1111111111111111},{"$f":"DATE('Summer Salary Form by Amount'!$L$11,Sheet1!$G$1,1)","v":"2022-06-01"},{"$f":"DATE('Summer Salary Form by Amount'!$L$11-1,Sheet1!$H$1,1)","v":"2021-07-01"},{"$f":"DATE('Summer Salary Form by Amount'!$L$11-1,Sheet1!$I$1,1)","v":"2021-08-01"}]
[null,null,null,null,null,null,{"$f":"G3+1","v":"2022-06-02"},{"$f":"H3+1","v":"2021-07-02"},{"$f":"I3+1","v":"2021-08-02"}]
[null,null,null,null,null,null,{"$f":"G4+1","v":"2022-06-03"},"2021-07-03","2021-08-03"]
[null,null,"Step :2","Basis for salary calcualtion for Line#2",null,null,"2022-06-04","2021-07-04","2021-08-04"]
[null,null,null,{"$f":"IF('Summer Salary Form by Amount'!$C$21<='Summer Salary Form by Amount'!$L$9,'Summer Salary Form by Amount'!$C$21/'Summer Salary Form by Amount'!$L$9,\"Error\")","v":0},null,null,"2022-06-05","2021-07-05","2021-08-05"]
[null,null,null,null,"Fiscal Year",null,"2022-06-06","2021-07-06","2021-08-06"]
[null,null,null,null,2022,null,"2022-06-07","2021-07-07","2021-08-07"]
[null,null,"Step :3","Basis for salary calcualtion for Line#3",2023,null,"2022-06-08","2021-07-08","2021-08-08"]
[null,null,null,{"$f":"IF('Summer Salary Form by Amount'!$C$22<='Summer Salary Form by Amount'!$L$9,'Summer Salary Form by Amount'!$C$22/'Summer Salary Form by Amount'!$L$9,\"Error\")","v":0},2024,null,"2022-06-09","2021-07-09","2021-08-09"]
[null,null,null,null,2025,null,"2022-06-10","2021-07-10","2021-08-10"]
[null,null,null,null,2026,null,"2022-06-11","2021-07-11","2021-08-11"]
[null,null,"Step :4","Basis for salary calcualtion for Line#4",2027,null,"2022-06-12","2021-07-12","2021-08-12"]
[null,null,null,{"$f":"IF('Summer Salary Form by Amount'!$C$23<='Summer Salary Form by Amount'!$L$9,'Summer Salary Form by Amount'!$C$23/'Summer Salary Form by Amount'!$L$9,\"Error\")","v":0},2028,null,"2022-06-13","2021-07-13","2021-08-13"]
[null,null,null,null,2029,null,"2022-06-14","2021-07-14","2021-08-14"]
[null,null,null,null,2030,null,"2022-06-15","2021-07-15","2021-08-15"]
[null,null,"Step :5","Basis for salary calcualtion for Line#5",2031,null,"2022-06-16","2021-07-16","2021-08-16"]
[null,null,null,{"$f":"IF('Summer Salary Form by Amount'!$C$24<='Summer Salary Form by Amount'!$L$9,'Summer Salary Form by Amount'!$C$24/'Summer Salary Form by Amount'!$L$9,\"Error\")","v":0},2032,null,"2022-06-17","2021-07-17","2021-08-17"]
[null,null,null,null,2033,null,"2022-06-18","2021-07-18","2021-08-18"]
[null,null,null,null,2034,null,{"$f":"G20+1","v":"2022-06-19"},"2021-07-19","2021-08-19"]
[null,null,"Step :6","Basis for salary calcualtion for Line#6",2035,null,"2022-06-20","2021-07-20","2021-08-20"]
[null,null,null,{"$f":"IF('Summer Salary Form by Amount'!$C$25<='Summer Salary Form by Amount'!$L$9,'Summer Salary Form by Amount'!$C$25/'Summer Salary Form by Amount'!$L$9,\"Error\")","v":0},2036,null,"2022-06-21","2021-07-21","2021-08-21"]
[null,null,null,null,2037,null,"2022-06-22","2021-07-22","2021-08-22"]
[null,null,null,null,2038,null,"2022-06-23","2021-07-23","2021-08-23"]
[null,null,"Step :7","Basis for salary calcualtion for Line#7",2039,null,"2022-06-24","2021-07-24","2021-08-24"]
[null,null,null,{"$f":"IF('Summer Salary Form by Amount'!$C$26<='Summer Salary Form by Amount'!$L$9,'Summer Salary Form by Amount'!$C$26/'Summer Salary Form by Amount'!$L$9,\"Error\")","v":0},2040,null,"2022-06-25","2021-07-25","2021-08-25"]
[null,null,null,null,2041,null,"2022-06-26","2021-07-26","2021-08-26"]
[null,null,null,null,2042,null,"2022-06-27","2021-07-27","2021-08-27"]
[null,null,"Step :8","Basis for salary calcualtion for Line#8",2043,null,"2022-06-28","2021-07-28","2021-08-28"]
[null,null,null,{"$f":"IF('Summer Salary Form by Amount'!$C$27<='Summer Salary Form by Amount'!$L$9,'Summer Salary Form by Amount'!$C$27/'Summer Salary Form by Amount'!$L$9,\"Error\")","v":0},2044,null,"2022-06-29","2021-07-29","2021-08-29"]
[null,null,null,null,2045,null,"2022-06-30","2021-07-30","2021-08-30"]
[null,null,null,null,2046,null,null,"2021-07-31","2021-08-31"]
[null,null,null,null,2047]
[null,null,null,null,2048]
[null,null,null,null,2049]
[null,null,null,null,2050]