{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Worksheet","Resources","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Worksheet","index":0,"n_rows":72,"n_cols":33,"rows_kept":72,"cut":false,"hidden":false,"merged":[[42,0,42,2],[42,3,42,5],[42,6,42,9],[42,10,42,12],[42,13,42,16],[42,17,42,20],[42,21,42,25],[42,26,42,29],[42,30,42,34],[41,0,41,2],[41,3,41,5],[41,6,41,9],[41,10,41,12],[41,13,41,16],[41,17,41,20],[41,21,41,25],[41,26,41,29],[41,30,41,34],[58,23,58,34],[51,23,51,34],[52,23,52,34],[53,23,53,34],[62,27,62,34],[67,31,67,34],[54,23,54,34],[55,23,55,34],[56,23,56,34],[25,3,25,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[23,3,23,5],[71,12,71,14],[51,0,51,3],[51,4,51,8],[51,9,51,13],[51,14,51,21],[52,0,52,3],[52,4,52,8],[52,9,52,13],[52,14,52,21],[53,0,53,3],[53,4,53,8],[53,9,53,13],[53,14,53,21],[54,0,54,3],[54,4,54,8],[54,9,54,13],[54,14,54,21],[60,12,60,15],[66,17,67,30],[63,17,64,30],[64,0,66,15],[68,0,70,12],[68,13,70,15],[57,0,57,3],[57,4,57,8],[57,9,57,13],[57,14,57,21],[58,0,58,3],[58,4,58,8],[58,9,58,13],[58,14,58,21],[31,0,31,2],[36,0,36,2],[35,3,35,5],[36,3,36,5],[35,17,35,20],[37,0,37,2],[38,0,38,2],[39,0,39,2],[43,0,43,2],[44,0,44,2],[40,0,40,2],[40,3,40,5],[40,6,40,9],[40,10,40,12],[40,13,40,16],[56,0,56,3],[56,4,56,8],[56,9,56,13],[56,14,56,21],[49,23,49,34],[50,23,50,34],[50,14,50,21],[30,30,30,34],[33,10,33,12],[34,10,34,12],[33,0,33,2],[34,0,34,2],[33,3,33,5],[34,3,34,5],[34,17,34,20],[36,17,36,20],[35,10,35,12],[35,13,35,16],[35,30,35,34],[36,30,36,34],[36,10,36,12],[36,13,36,16],[35,0,35,2],[36,26,36,29],[37,3,37,5],[39,10,39,12],[24,30,24,34],[25,30,25,34],[26,30,26,34],[49,14,49,21],[70,31,70,34],[69,17,70,30],[32,21,32,25],[32,26,32,29],[33,21,33,25],[33,26,33,29],[34,21,34,25],[34,26,34,29],[35,21,35,25],[35,26,35,29],[38,30,38,34],[33,13,33,16],[33,30,33,34],[34,30,34,34],[34,13,34,16],[33,17,33,20],[60,29,60,34],[57,23,57,34],[64,31,64,34],[36,21,36,25],[21,30,21,34],[22,30,22,34],[23,30,23,34],[27,30,27,34],[48,4,48,8],[48,9,48,13],[28,6,28,9],[29,6,29,9],[30,6,30,9],[31,6,31,9],[32,6,32,9],[33,6,33,9],[34,6,34,9],[35,6,35,9],[36,6,36,9],[30,10,30,12],[30,13,30,16],[47,23,47,34],[48,23,48,34],[29,30,29,34],[26,13,26,16],[27,13,27,16],[26,6,26,9],[28,30,28,34],[2,21,2,34],[4,21,4,34],[6,18,6,24],[6,26,6,32],[14,7,14,8],[14,15,14,16],[14,23,14,24],[14,31,14,32],[6,2,6,8],[6,10,6,16],[13,18,13,22],[13,23,13,24],[13,26,13,30],[13,31,13,32],[13,7,13,8],[13,2,13,6],[13,10,13,14],[13,15,13,16],[3,5,3,14],[3,21,3,34],[18,6,18,9],[24,13,24,16],[21,6,21,9],[22,6,22,9],[22,13,22,16],[23,13,23,16],[19,6,19,9],[20,6,20,9],[2,5,2,14],[4,5,4,14],[16,6,16,9],[17,6,17,9],[16,13,16,16],[16,10,16,12],[24,3,24,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[20,10,20,12],[18,13,18,16],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[29,10,29,12],[29,13,29,16],[23,6,23,9],[24,6,24,9],[25,6,25,9],[25,13,25,16],[21,10,21,12],[22,10,22,12],[23,10,23,12],[24,10,24,12],[25,10,25,12],[26,10,26,12],[27,10,27,12],[27,6,27,9],[28,10,28,12],[28,13,28,16],[21,13,21,16],[18,10,18,12],[19,10,19,12],[19,13,19,16],[20,13,20,16],[18,30,18,34],[19,30,19,34],[20,30,20,34],[18,17,18,20],[19,17,19,20],[20,17,20,20],[18,21,18,25],[18,26,18,29],[19,21,19,25],[19,26,19,29],[20,21,20,25],[20,26,20,29],[17,30,17,34],[17,10,17,12],[16,17,16,20],[17,17,17,20],[16,21,16,25],[16,26,16,29],[17,21,17,25],[17,26,17,29],[17,13,17,16],[16,30,16,34],[17,0,17,2],[16,0,16,2],[31,10,31,12],[31,13,31,16],[31,30,31,34],[32,30,32,34],[32,10,32,12],[32,13,32,16],[31,21,31,25],[31,26,31,29],[32,0,32,2],[31,3,31,5],[32,3,32,5],[30,17,30,20],[31,17,31,20],[32,17,32,20],[21,17,21,20],[22,17,22,20],[23,17,23,20],[24,17,24,20],[25,17,25,20],[26,17,26,20],[27,17,27,20],[28,17,28,20],[38,3,38,5],[39,3,39,5],[38,10,38,12],[38,13,38,16],[37,10,37,12],[37,13,37,16],[37,30,37,34],[37,6,37,9],[37,17,37,20],[37,21,37,25],[39,13,39,16],[39,30,39,34],[38,6,38,9],[39,6,39,9],[38,17,38,20],[39,17,39,20],[38,21,38,25],[38,26,38,29],[39,21,39,25],[39,26,39,29],[37,26,37,29],[43,30,43,34],[44,10,44,12],[44,13,44,16],[44,30,44,34],[43,6,43,9],[44,6,44,9],[43,17,43,20],[44,17,44,20],[43,21,43,25],[43,26,43,29],[44,21,44,25],[44,26,44,29],[40,17,40,20],[40,21,40,25],[40,26,40,29],[40,30,40,34],[43,3,43,5],[44,3,44,5],[48,0,48,3],[48,14,48,21],[55,0,55,3],[55,4,55,8],[55,9,55,13],[55,14,55,21],[47,0,47,3],[47,14,47,21],[47,4,47,8],[47,9,47,13],[49,0,49,3],[50,0,50,3],[49,4,49,8],[50,4,50,8],[49,9,49,13],[50,9,50,13],[43,10,43,12],[43,13,43,16],[30,21,30,25],[30,26,30,29],[29,17,29,20],[21,21,21,25],[21,26,21,29],[22,21,22,25],[22,26,22,29],[23,21,23,25],[23,26,23,29],[24,21,24,25],[24,26,24,29],[25,21,25,25],[25,26,25,29],[26,21,26,25],[26,26,26,29],[27,21,27,25],[27,26,27,29],[28,21,28,25],[28,26,28,29],[29,21,29,25],[29,26,29,29]]}
["Summer Salary Worksheet 2022 (revised 5/12/2022)"]
[]
["Faculty Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Department:"]
["Employee ID:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title/Step:"]
["Position #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total # of Days:",null,null,null,null,{"$f":"SUM(D18:F45)","v":0}]
[]
[null,null,"June 2022",null,null,null,null,null,null,null,"July 2022",null,null,null,null,null,null,null,"August 2022",null,null,null,null,null,null,null,"September 2022"]
[null,null,"Su","M","Tu","W","Th","F","Sa",null,"Su","M","Tu","W","Th","F","Sa",null,"Su","M","Tu","W","Th","F","Sa",null,"Su","M","Tu","W","Th","F","Sa"]
[null,null,null,null,null,1,2,3,4,null,null,null,null,null,null,1,2,null,31,1,2,3,4,5,6,null,null,null,null,null,1,2,3]
[null,null,5,6,7,8,9,10,11,null,3,4,5,6,7,8,9,null,7,8,9,10,11,12,13,null,4,5,6,7,8,9,10]
[null,null,12,13,14,15,16,17,18,null,10,11,12,13,14,15,16,null,14,15,16,17,18,19,20,null,11,12,13,14,15,16,17]
[null,null,19,20,21,22,23,24,25,null,17,18,19,20,21,22,23,null,21,22,23,24,25,26,27,null,18,19,20,21,22,23,24]
[null,null,26,27,28,29,30,null,null,null,24,25,26,27,28,29,30,null,28,29,30,31,null,null,null,null,25,26,27,28,29,30]
[null,null,"Available Days:",null,null,null,null,{"$f":"14-SUMIF(A17:C45,\"June\",D17:F45)","v":14},null,null,"Available Days:",null,null,null,null,{"$f":"21-SUMIF(A17:C45,\"July\",D17:F45)","v":21},null,null,"Available Days:",null,null,null,null,{"$f":"23-SUMIF(A17:C45,\"August\",D17:F45)","v":23},null,null,"Available Days:",null,null,null,null,{"$f":"12-SUMIF(A17:C45,\"Sept\",D17:F45)","v":12}]
[null,null,"Job FTE for June:",null,null,null,null,{"$f":"SUMIF(A18:C45,\"June\",K18:M45)","v":0},null,null,"Job FTE for July:",null,null,null,null,{"$f":"SUMIF(A18:C45,\"July\",K18:M45)","v":0},null,null,"Job FTE for Aug:",null,null,null,null,{"$f":"SUMIF(A18:C45,\"August\",K18:M45)","v":0},null,null,"Job FTE for Sept:",null,null,null,null,{"$f":"SUMIF(A18:C45,\"Sept\",K18:M45)","v":0}]
[]
["Month",null,null,"# of Days",null,null,"Concurrent Job or\nAdd'l Pay",null,null,null,"FTE",null,null,"UCPath Annual Rate",null,null,null,"KFS\nAccount",null,null,null,"Fund's Annual Capped Rate \n(if applicable)",null,null,null,null,"Cap Gap Amount\n(if applicable)",null,null,null,"Amount \nto be Paid"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G18=\"addl pay\",0,ROUND((D18/19),4))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V18=\"\",\"\",(ROUND((N18/9),2)*ROUND((D18/19),4))-(ROUND((V18/12),2)*ROUND((D18/19),4)))","v":""},null,null,null,{"$f":"IF(V18=\"\",ROUND((N18/9),2)*ROUND((D18/19),4),ROUND((V18/12),2)*ROUND((D18/19),4))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G19=\"addl pay\",0,ROUND((D19/19),4))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V19=\"\",\"\",(ROUND((N19/9),2)*ROUND((D19/19),4))-(ROUND((V19/12),2)*ROUND((D19/19),4)))","v":""},null,null,null,{"$f":"IF(V19=\"\",ROUND((N19/9),2)*ROUND((D19/19),4),ROUND((V19/12),2)*ROUND((D19/19),4))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,0]
[]
["Over the Cap Funding:"]
["Month",null,null,null,"Paid Over the Cap Amount",null,null,null,null,"Unpaid Over the Cap Amount",null,null,null,null,"KFS Account",null,null,null,null,null,null,null,null,"Comments/Notes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Summer Session amount (if applicable):",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Summer Compensation Limit (3/9ths):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF(A18<>\"June\",N18,IF(A19<>\"June\",N19,IF(A20<>\"June\",N20,IF(A21<>\"June\",N21,\"\")))))/9*3","v":0}]
[]
["Certifications/Approvals:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Summer Salary Amount:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE18:AI45,E49:I59,M61)","v":0}]
[]
["With my signature below I certify that I am able to perform my administrative and/or research obligations on these funding sources."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Financial Analyst's Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chair/Unit Head or Director's Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
["Faculty/PI's Signature",null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,"Dean's Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Resources","index":1,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Related Job Aids"]
["UCPC Summer Salary Job Aid"]
["UCPC Unpaid Cap Gap Processing"]
[]
["Other Resources"]
["Funding Agency Caps"]
["Office of Research Guidance on Salary Caps"]
[]
["Summer Salary Policy/Guidance"]
["Summer Compensation"]
["Academic Personnel Procedures (APP)"]
["Academic Personnel Manual (APM)"]

{"sheet":"Sheet2","index":2,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Yes","June","Conc Job"]
["No","July","Addl Pay"]
[null,"August"]
[null,"Sept"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"sum:"]