{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["EAF","A216810396964DCDB399904ED81BA8E","Dropdowns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"EAF","index":0,"n_rows":94,"n_cols":15,"rows_kept":94,"cut":false,"hidden":false,"merged":[[44,1,49,1],[54,1,59,1],[67,11,67,12],[58,11,58,12],[0,2,0,11],[64,1,69,1],[8,2,8,4],[8,10,8,11],[10,1,12,12],[14,1,19,1],[24,1,29,1],[34,1,39,1],[17,6,17,8],[18,6,18,8],[27,6,27,8],[28,6,28,8],[83,12,84,12],[68,11,68,12],[86,2,86,12],[69,2,69,3],[75,10,75,11],[68,6,68,8],[69,5,69,10],[67,6,67,8],[47,6,47,8],[88,3,88,10],[93,3,93,10],[90,3,90,10],[4,3,4,5],[38,6,38,8],[37,6,37,8],[48,6,48,8],[57,6,57,8],[2,3,2,5],[39,2,39,3],[14,2,15,2],[24,2,25,2],[34,2,35,2],[19,5,19,10],[29,5,29,10],[39,5,39,10],[2,8,2,11],[4,8,4,11],[6,8,7,11],[6,4,7,6],[17,11,17,12],[27,11,27,12],[28,11,28,12],[37,11,37,12],[64,2,65,2],[29,2,29,3],[19,2,19,3],[18,11,18,12],[59,2,59,3],[49,2,49,3],[59,5,59,10],[47,11,47,12],[48,11,48,12],[57,11,57,12],[44,2,45,2],[54,2,55,2],[49,5,49,10],[38,11,38,12],[58,6,58,8]]}
[null,null,"2024 Summer Salary Employee Action Form (EAF)\nEffective dates May 16 through August 15"]
[]
[null,null,"Name:",null,null,null,null,null,"2023-24 Academic Year (AY) Salary:"]
[]
[null,null,"Home Dept. Number:",null,null,null,null,null,"Max. Summer Salary:",null,null,null,{"$f":"M3*((12-D7)/D7)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"2023-24 AY Contract:",null,{"$f":"IF(D7=12, \"12 mo. Faculty are ineligible to receive Summer Salary\", \"\")","v":""},null,null,null,"Max. Summer Salary Sponsored Projects \n(3XXXX - ZXXXX) 90%:",null,null,null,{"$f":"M5*0.9","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Has this faculty member submitted additional summer salary payments for Summer 2024?",null,null,"Select One",null,null,null,null,"Include total of all previously submitted payments:"]
[]
[null,"During the summer, a 9-month faculty member may be paid by RIT no more than a total of 33.33% (pro-rated for other appointments) of the faculty member's current AY salary. \nFaculty effort on sponsored activity is limited to 90% over the summer period.  Exceptions approving faculty effort greater than 90% during the summer may be granted upon submission and approval of the plan of work summer form. This limit also applies to the percentage that is pro-rated for faculty members with appointments greater than 9 months but less than 12 months. "]
[]
[]
[]
[null,1,"Oracle Account Number:","01",null,70550,null,32634,null,null,"00000",null,null,null,{"$f":"(VLOOKUP(I15,Dropdowns!$N$2:$P$12,3))","v":"Non-SPA"}]
[null,null,null,"ENT","DEPT","OBJ","FEC",null,"PROJ",null,"PROG"]
[]
[null,null,"May 16",null,null,null,null,null,null,null,null,{"$f":"(($M$3*D23)*G18)","v":0}]
[null,null,"Start Date","End Date",null,null,"% Effort",null,null,null,null,"Contract Amount"]
[null,null,{"$f":"IF(C23<D22,\"Exceeds maximum available summer months\",\"\")","v":""},null,"Approval:",null,null,null,null,null,null,"Date:"]
[null,null,{"$f":"IF(C18=\"May 16\",1,IF(C18=\"Jun 1\",2,IF(C18=\"Jun 16\",3,IF(C18=\"July 1\",4,IF(C18=\"July 16\",5,IF(C18=\"Aug 1\",6))))))","v":1},{"$f":"IF(D18=\"May 31\",2,IF(D18=\"Jun 15\",3,IF(D18=\"Jun 30\",4,IF(D18=\"July 15\",5,IF(D18=\"July 31\",6,IF(D18=\"Aug 15\",7))))))","v":false},null,null,null,null,null,null,null,"May",{"$f":"IF(C18=\"May 16\",L18/D22,0)","v":0}]
[null,null,{"$f":"(IF($D$7=9,Dropdowns!$F$2,IF($D$7=9.5,Dropdowns!$G$2,IF($D$7=10,Dropdowns!$H$2,IF($D$7=10.5,Dropdowns!$I$2,IF($D$7=11,Dropdowns!$J$2,IF($D$7=11.5,Dropdowns!$K$2)))))))","v":false},{"$f":"D21-C21","v":-1},null,null,null,null,null,null,null,"June",{"$f":"IF(OR(D18=\"May 31\",C18=\"July 1\",C18=\"July 16\", C18=\"Aug 1\"),0,IF(D18=\"Jun 15\",L18/D22,IF(C18=\"Jun 16\",L18/D22,IF(AND(C18=\"Jun 16\",D18=\"Jun 30\"),L18/D22,IF(AND(D18<>\"Jun 15\"),(L18/D22)*2,0)))))","v":0}]
[null,null,{"$f":"(12-$D$7)*2","v":24},{"$f":"D22*C22","v":0},null,null,null,null,null,null,null,"July",{"$f":"IF(OR(D18=\"June 30\",C18=\"June 1\",C18=\"June 16\",C18=\"Aug 1\"),0,IF(D18=\"July 15\",L18/D22,IF(C18=\"July 16\",L18/D22,IF(AND(D18=\"July 31\",C18<>\"July 16\"),(L18/D22)*2,IF(AND(D18=\"Aug 15\",C18<>\"July 16\"),(L18/D22)*2,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Aug",{"$f":"IF(D18=\"Aug 15\",L18/D22,0)","v":0}]
[null,2,"Oracle Account Number:","01",null,70550,null,null,null,null,"00000",null,null,null,{"$f":"(VLOOKUP(I25,Dropdowns!$N$2:$P$12,3))","v":"Non-SPA"}]
[null,null,null,"ENT","DEPT","OBJ","FEC",null,"PROJ",null,"PROG"]
[]
[null,null,"May 16",null,null,null,null,null,null,null,null,{"$f":"(($M$3*D33)*G28)","v":0}]
[null,null,"Start Date","End Date",null,null,"% Effort",null,null,null,null,"Contract Amount"]
[null,null,{"$f":"IF(C33<D32,\"Exceeds maximum available summer months\",\"\")","v":""},null,"Approval:",null,null,null,null,null,null,"Date:"]
[null,null,{"$f":"IF(C28=\"May 16\",1,IF(C28=\"Jun 1\",2,IF(C28=\"Jun 16\",3,IF(C28=\"July 1\",4,IF(C28=\"July 16\",5,IF(C28=\"Aug 1\",6))))))","v":1},{"$f":"IF(D28=\"May 31\",2,IF(D28=\"Jun 15\",3,IF(D28=\"Jun 30\",4,IF(D28=\"July 15\",5,IF(D28=\"July 31\",6,IF(D28=\"Aug 15\",7))))))","v":false},null,null,null,null,null,null,null,"May",{"$f":"IF(C28=\"May 16\",L28/D32,0)","v":0}]
[null,null,{"$f":"(IF($D$7=9,Dropdowns!$F$2,IF($D$7=9.5,Dropdowns!$G$2,IF($D$7=10,Dropdowns!$H$2,IF($D$7=10.5,Dropdowns!$I$2,IF($D$7=11,Dropdowns!$J$2,IF($D$7=11.5,Dropdowns!$K$2)))))))","v":false},{"$f":"D31-C31","v":-1},null,null,null,null,null,null,null,"June",{"$f":"IF(OR(D28=\"May 31\",C28=\"July 1\",C28=\"July 16\", C28=\"Aug 1\"),0,IF(D28=\"Jun 15\",L28/D32,IF(C28=\"Jun 16\",L28/D32,IF(AND(C28=\"Jun 16\",D28=\"Jun 30\"),L28/D32,IF(AND(D28<>\"Jun 15\"),(L28/D32)*2,0)))))","v":0}]
[null,null,{"$f":"(12-$D$7)*2","v":24},{"$f":"D32*C32","v":0},null,null,null,null,null,null,null,"July",{"$f":"IF(OR(D28=\"June 30\",C28=\"June 1\",C28=\"June 16\",C28=\"Aug 1\"),0,IF(D28=\"July 15\",L28/D32,IF(C28=\"July 16\",L28/D32,IF(AND(D28=\"July 31\",C28<>\"July 16\"),(L28/D32)*2,IF(AND(D28=\"Aug 15\",C28<>\"July 16\"),(L28/D32)*2,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Aug",{"$f":"IF(D28=\"Aug 15\",L28/D32,0)","v":0}]
[null,3,"Oracle Account Number:","01",null,70550,null,null,null,null,"00000",null,null,null,{"$f":"(VLOOKUP(I35,Dropdowns!$N$2:$P$12,3))","v":"Non-SPA"}]
[null,null,null,"ENT","DEPT","OBJ","FEC",null,null,null,"PROG"]
[]
[null,null,"May 16",null,null,null,null,null,null,null,null,{"$f":"(($M$3*D43)*G38)","v":0}]
[null,null,"Start Date","End Date",null,null,"% Effort",null,null,null,null,"Contract Amount"]
[null,null,{"$f":"IF(C43<D42,\"Exceeds maximum available summer months\",\"\")","v":""},null,"Approval:",null,null,null,null,null,null,"Date:"]
[null,null,{"$f":"IF(C38=\"May 16\",1,IF(C38=\"Jun 1\",2,IF(C38=\"Jun 16\",3,IF(C38=\"July 1\",4,IF(C38=\"July 16\",5,IF(C38=\"Aug 1\",6))))))","v":1},{"$f":"IF(D38=\"May 31\",2,IF(D38=\"Jun 15\",3,IF(D38=\"Jun 30\",4,IF(D38=\"July 15\",5,IF(D38=\"July 31\",6,IF(D38=\"Aug 15\",7))))))","v":false},null,null,null,null,null,null,null,"May",{"$f":"IF(C38=\"May 16\",L38/D42,0)","v":0}]
[null,null,{"$f":"(IF($D$7=9,Dropdowns!$F$2,IF($D$7=9.5,Dropdowns!$G$2,IF($D$7=10,Dropdowns!$H$2,IF($D$7=10.5,Dropdowns!$I$2,IF($D$7=11,Dropdowns!$J$2,IF($D$7=11.5,Dropdowns!$K$2)))))))","v":false},{"$f":"D41-C41","v":-1},null,null,null,null,null,null,null,"June",{"$f":"IF(OR(D38=\"May 31\",C38=\"July 1\",C38=\"July 16\", C38=\"Aug 1\"),0,IF(D38=\"Jun 15\",L38/D42,IF(C38=\"Jun 16\",L38/D42,IF(AND(C38=\"Jun 16\",D38=\"Jun 30\"),L38/D42,IF(AND(D38<>\"Jun 15\"),(L38/D42)*2,0)))))","v":0}]
[null,null,{"$f":"(12-$D$7)*2","v":24},{"$f":"D42*C42","v":0},null,null,null,null,null,null,null,"July",{"$f":"IF(OR(D38=\"June 30\",C38=\"June 1\",C38=\"June 16\",C38=\"Aug 1\"),0,IF(D38=\"July 15\",L38/D42,IF(C38=\"July 16\",L38/D42,IF(AND(D38=\"July 31\",C38<>\"July 16\"),(L38/D42)*2,IF(AND(D38=\"Aug 15\",C38<>\"July 16\"),(L38/D42)*2,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Aug",{"$f":"IF(D38=\"Aug 15\",L38/D42,0)","v":0}]
[null,4,"Oracle Account Number:","01",null,70550,null,null,null,null,"00000",null,null,null,{"$f":"(VLOOKUP(I45,Dropdowns!$N$2:$P$12,3))","v":"Non-SPA"}]
[null,null,null,"ENT","DEPT","OBJ","FEC",null,"PROJ",null,"PROG"]
[]
[null,null,"May 16",null,null,null,null,null,null,null,null,{"$f":"(($M$3*D53)*G48)","v":0}]
[null,null,"Start Date","End Date",null,null,"% Effort",null,null,null,null,"Contract Amount"]
[null,null,{"$f":"IF(C53<D52,\"Exceeds maximum available summer months\",\"\")","v":""},null,"Approval:",null,null,null,null,null,null,"Date:"]
[null,null,{"$f":"IF(C48=\"May 16\",1,IF(C48=\"Jun 1\",2,IF(C48=\"Jun 16\",3,IF(C48=\"July 1\",4,IF(C48=\"July 16\",5,IF(C48=\"Aug 1\",6))))))","v":1},{"$f":"IF(D48=\"May 31\",2,IF(D48=\"Jun 15\",3,IF(D48=\"Jun 30\",4,IF(D48=\"July 15\",5,IF(D48=\"July 31\",6,IF(D48=\"Aug 15\",7))))))","v":false},null,null,null,null,null,null,null,"May",{"$f":"IF(C48=\"May 16\",L48/D52,0)","v":0}]
[null,null,{"$f":"(IF($D$7=9,Dropdowns!$F$2,IF($D$7=9.5,Dropdowns!$G$2,IF($D$7=10,Dropdowns!$H$2,IF($D$7=10.5,Dropdowns!$I$2,IF($D$7=11,Dropdowns!$J$2,IF($D$7=11.5,Dropdowns!$K$2)))))))","v":false},{"$f":"D51-C51","v":-1},null,null,null,null,null,null,null,"June",{"$f":"IF(OR(D48=\"May 31\",C48=\"July 1\",C48=\"July 16\", C48=\"Aug 1\"),0,IF(D48=\"Jun 15\",L48/D52,IF(C48=\"Jun 16\",L48/D52,IF(AND(C48=\"Jun 16\",D48=\"Jun 30\"),L48/D52,IF(AND(D48<>\"Jun 15\"),(L48/D52)*2,0)))))","v":0}]
[null,null,{"$f":"(12-$D$7)*2","v":24},{"$f":"D52*C52","v":0},null,null,null,null,null,null,null,"July",{"$f":"IF(OR(D48=\"June 30\",C48=\"June 1\",C48=\"June 16\",C48=\"Aug 1\"),0,IF(D48=\"July 15\",L48/D52,IF(C48=\"July 16\",L48/D52,IF(AND(D48=\"July 31\",C48<>\"July 16\"),(L48/D52)*2,IF(AND(D48=\"Aug 15\",C48<>\"July 16\"),(L48/D52)*2,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Aug",{"$f":"IF(D48=\"Aug 15\",L48/D52,0)","v":0}]
[null,5,"Oracle Account Number:","01",null,70550,null,null,null,null,"00000",null,null,null,{"$f":"(VLOOKUP(I55,Dropdowns!$N$2:$P$12,3))","v":"Non-SPA"}]
[null,null,null,"ENT","DEPT","OBJ","FEC",null,"PROJ",null,"PROG"]
[]
[null,null,"May 16",null,null,null,null,null,null,null,null,{"$f":"(($M$3*D63)*G58)","v":0}]
[null,null,"Start Date","End Date",null,null,"% Effort",null,null,null,null,"Contract Amount"]
[null,null,{"$f":"IF(C63<D62,\"Exceeds maximum available summer months\",\"\")","v":""},null,"Approval:",null,null,null,null,null,null,"Date:"]
[null,null,{"$f":"IF(C58=\"May 16\",1,IF(C58=\"Jun 1\",2,IF(C58=\"Jun 16\",3,IF(C58=\"July 1\",4,IF(C58=\"July 16\",5,IF(C58=\"Aug 1\",6))))))","v":1},{"$f":"IF(D58=\"May 31\",2,IF(D58=\"Jun 15\",3,IF(D58=\"Jun 30\",4,IF(D58=\"July 15\",5,IF(D58=\"July 31\",6,IF(D58=\"Aug 15\",7))))))","v":false},null,null,null,null,null,null,null,"May",{"$f":"IF(C58=\"May 16\",L58/D62,0)","v":0}]
[null,null,{"$f":"(IF($D$7=9,Dropdowns!$F$2,IF($D$7=9.5,Dropdowns!$G$2,IF($D$7=10,Dropdowns!$H$2,IF($D$7=10.5,Dropdowns!$I$2,IF($D$7=11,Dropdowns!$J$2,IF($D$7=11.5,Dropdowns!$K$2)))))))","v":false},{"$f":"D61-C61","v":-1},null,null,null,null,null,null,null,"June",{"$f":"IF(OR(D58=\"May 31\",C58=\"July 1\",C58=\"July 16\", C58=\"Aug 1\"),0,IF(D58=\"Jun 15\",L58/D62,IF(C58=\"Jun 16\",L58/D62,IF(AND(C58=\"Jun 16\",D58=\"Jun 30\"),L58/D62,IF(AND(D58<>\"Jun 15\"),(L58/D62)*2,0)))))","v":0}]
[null,null,{"$f":"(12-$D$7)*2","v":24},{"$f":"D62*C62","v":0},null,null,null,null,null,null,null,"July",{"$f":"IF(OR(D58=\"June 30\",C58=\"June 1\",C58=\"June 16\",C58=\"Aug 1\"),0,IF(D58=\"July 15\",L58/D62,IF(C58=\"July 16\",L58/D62,IF(AND(D58=\"July 31\",C58<>\"July 16\"),(L58/D62)*2,IF(AND(D58=\"Aug 15\",C58<>\"July 16\"),(L58/D62)*2,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Aug",{"$f":"IF(D58=\"Aug 15\",L58/D62,0)","v":0}]
[null,6,"Oracle Account Number:","01",null,70550,null,null,null,null,"00000",null,null,null,{"$f":"(VLOOKUP(I65,Dropdowns!$N$2:$P$12,3))","v":"Non-SPA"}]
[null,null,null,"ENT","DEPT","OBJ","FEC",null,"PROJ",null,"PROG"]
[]
[null,null,"May 16",null,null,null,null,null,null,null,null,{"$f":"(($M$3*D73)*G68)","v":0}]
[null,null,"Start Date","End Date",null,null,"% Effort",null,null,null,null,"Contract Amount"]
[null,null,{"$f":"IF(C73<D72,\"Exceeds maximum available summer months\",\"\")","v":""},null,"Approval:",null,null,null,null,null,null,"Date:"]
[null,null,{"$f":"IF(C68=\"May 16\",1,IF(C68=\"Jun 1\",2,IF(C68=\"Jun 16\",3,IF(C68=\"July 1\",4,IF(C68=\"July 16\",5,IF(C68=\"Aug 1\",6))))))","v":1},{"$f":"IF(D68=\"May 31\",2,IF(D68=\"Jun 15\",3,IF(D68=\"Jun 30\",4,IF(D68=\"July 15\",5,IF(D68=\"July 31\",6,IF(D68=\"Aug 15\",7))))))","v":false},null,null,null,null,null,null,null,"May",{"$f":"IF(C68=\"May 16\",L68/D72,0)","v":0}]
[null,null,{"$f":"(IF($D$7=9,Dropdowns!$F$2,IF($D$7=9.5,Dropdowns!$G$2,IF($D$7=10,Dropdowns!$H$2,IF($D$7=10.5,Dropdowns!$I$2,IF($D$7=11,Dropdowns!$J$2,IF($D$7=11.5,Dropdowns!$K$2)))))))","v":false},{"$f":"D71-C71","v":-1},null,null,null,null,null,null,null,"June",{"$f":"IF(OR(D68=\"May 31\",C68=\"July 1\",C68=\"July 16\", C68=\"Aug 1\"),0,IF(D68=\"Jun 15\",L68/D72,IF(C68=\"Jun 16\",L68/D72,IF(AND(C68=\"Jun 16\",D68=\"Jun 30\"),L68/D72,IF(AND(D68<>\"Jun 15\"),(L68/D72)*2,0)))))","v":0}]
[null,null,{"$f":"(12-$D$7)*2","v":24},{"$f":"D72*C72","v":0},null,null,null,null,null,null,null,"July",{"$f":"IF(OR(D68=\"June 30\",C68=\"June 1\",C68=\"June 16\",C68=\"Aug 1\"),0,IF(D68=\"July 15\",L68/D72,IF(C68=\"July 16\",L68/D72,IF(AND(D68=\"July 31\",C68<>\"July 16\"),(L68/D72)*2,IF(AND(D68=\"Aug 15\",C68<>\"July 16\"),(L68/D72)*2,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Aug",{"$f":"IF(D68=\"Aug 15\",L68/D72,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Commitments"]
[null,null,null,null,null,null,null,null,null,null,"Dollars","%"]
[null,null,null,null,null,null,null,null,"May:",null,{"$f":"M21+M31+M41+M51+M61+M71","v":0},{"$f":"IF($D$7=9, K78/($M$5*Dropdowns!F12),IF($D$7=9.5, EAF!K78/(EAF!$M$5*Dropdowns!G12), IF(EAF!$D$7=10, EAF!K78/(EAF!$M$5*Dropdowns!H12),IF(EAF!$D$7=10.5, EAF!K78/(EAF!$M$5*Dropdowns!I12),IF(EAF!$D$7=11, EAF!K78/(EAF!$M$5*Dropdowns!J12), IF(EAF!$D$7=11.5, EAF!K78/(EAF!$M$5*Dropdowns!K12), \"\"))))))","v":""},{"$f":"IF(AND($D$7=9,(K78/$M$5)>Dropdowns!F12),\"Exceeds Allowable Amount for May\",IF(AND($D$7=9.5,(K78/$M$5)>Dropdowns!G12),\"Exceeds Allowable Amount for May\",IF(AND($D$7=10,(K78/$M$5)>Dropdowns!H12),\"Exceeds Allowable Amount for May\",IF(AND($D$7=10.5,(K78/$M$5)>Dropdowns!I12),\"Exceeds Allowable Amount for May\",IF(AND($D$7=11,(K78/$M$5)>Dropdowns!J12),\"Exceeds Allowable Amount for May\",IF(AND($D$7=11.5,(K78/$M$5)>Dropdowns!K12),\"Exceeds Allowable Amount for May\",\"\"))))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"June: ",null,{"$f":"M22+M32+M42+M52+M62+M72","v":0},{"$f":"IF($D$7=9, K79/($M$5*Dropdowns!F13),IF($D$7=9.5, EAF!K79/(EAF!$M$5*Dropdowns!G13), IF(EAF!$D$7=10, EAF!K79/(EAF!$M$5*Dropdowns!H13),IF(EAF!$D$7=10.5, EAF!K79/(EAF!$M$5*Dropdowns!I13),IF(EAF!$D$7=11, EAF!K79/(EAF!$M$5*Dropdowns!J13), IF(EAF!$D$7=11.5, EAF!K79/(EAF!$M$5*Dropdowns!K13), \"\"))))))","v":""},{"$f":"IF(AND($D$7=9,(K79/$M$5)>Dropdowns!F13),\"Exceeds Allowable Amount for June\",IF(AND($D$7=9.5,(K79/$M$5)>Dropdowns!G13),\"Exceeds Allowable Amount for June\",IF(AND($D$7=10,(K79/$M$5)>Dropdowns!H13),\"Exceeds Allowable Amount for June\",IF(AND($D$7=10.5,(K79/$M$5)>Dropdowns!I13),\"Exceeds Allowable Amount for June\",IF(AND($D$7=11,(K79/$M$5)>Dropdowns!J13),\"Exceeds Allowable Amount for June\",IF(AND($D$7=11.5,(K79/$M$5)>Dropdowns!K13),\"Exceeds Allowable Amount for June\",\"\"))))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"July:",null,{"$f":"M23+M33+M43+M53+M63+M73","v":0},{"$f":"IF($D$7=9, K80/($M$5*Dropdowns!F14),IF($D$7=9.5, EAF!K80/(EAF!$M$5*Dropdowns!G14), IF(EAF!$D$7=10, EAF!K80/(EAF!$M$5*Dropdowns!H14),IF(EAF!$D$7=10.5, EAF!K80/(EAF!$M$5*Dropdowns!I14),IF(EAF!$D$7=11, EAF!K80/(EAF!$M$5*Dropdowns!J14), IF(EAF!$D$7=11.5, EAF!K80/(EAF!$M$5*Dropdowns!K14), \"\"))))))","v":""},{"$f":"IF(AND($D$7=9,(K80/$M$5)>Dropdowns!F14),\"Exceeds Allowable Amount for July\",IF(AND($D$7=9.5,(K80/$M$5)>Dropdowns!G14),\"Exceeds Allowable Amount for July\",IF(AND($D$7=10,(K80/$M$5)>Dropdowns!H14),\"Exceeds Allowable Amount for July\",IF(AND($D$7=10.5,(K80/$M$5)>Dropdowns!I14),\"Exceeds Allowable Amount for July\",IF(AND($D$7=11,(K80/$M$5)>Dropdowns!J14),\"Exceeds Allowable Amount for July\",IF(AND($D$7=11.5,(K80/$M$5)>Dropdowns!K14),\"Exceeds Allowable Amount for July\",\"\"))))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"August:",null,{"$f":"M24+M34+M44+M54+M64+M74","v":0},{"$f":"IF($D$7=9, K81/($M$5*Dropdowns!F15),IF($D$7=9.5, EAF!K81/(EAF!$M$5*Dropdowns!G15), IF(EAF!$D$7=10, EAF!K81/(EAF!$M$5*Dropdowns!H15),IF(EAF!$D$7=10.5, EAF!K81/(EAF!$M$5*Dropdowns!I15),IF(EAF!$D$7=11, EAF!K81/(EAF!$M$5*Dropdowns!J15), IF(EAF!$D$7=11.5, EAF!K81/(EAF!$M$5*Dropdowns!K15), \"\"))))))","v":""},{"$f":"IF(AND($D$7=9,(K81/$M$5)>Dropdowns!F15),\"Exceeds Allowable Amount for August\",IF(AND($D$7=9.5,(K81/$M$5)>Dropdowns!G15),\"Exceeds Allowable Amount for August\",IF(AND($D$7=10,(K81/$M$5)>Dropdowns!H15),\"Exceeds Allowable Amount for August\",IF(AND($D$7=10.5,(K81/$M$5)>Dropdowns!I15),\"Exceeds Allowable Amount for August\",IF(AND($D$7=11,(K81/$M$5)>Dropdowns!J15),\"Exceeds Allowable Amount for August\",IF(AND($D$7=11.5,(K81/$M$5)>Dropdowns!K15),\"Exceeds Allowable Amount for August\",\"\"))))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Sponsored Projects Total:",null,{"$f":"IF(O15=\"SPA\",L18,0)+IF(O25=\"SPA\",$L$28,0)+IF(O35=\"SPA\",$L$38,0)+IF(O45=\"SPA\",$L$48,0)+IF(O55=\"SPA\",$L$58,0)+IF(O65=\"SPA\",$L$68,0)","v":0}]
[null,null,null,null,null,null,null,null,"Other Total:",null,{"$f":"IF(O15=\"Non-SPA\", $L$18,0)+IF(O25=\"Non-SPA\", $L$28,0)+IF(O35=\"Non-SPA\",$L$38,0)+IF(O45=\"Non-SPA\",$L$48,0)+IF(O55=\"Non-SPA\",$L$58,0)+IF(O65=\"Non-SPA\",$L$68,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K82>M7, \"Exceeds Max Amount for sponsored projects. Adjust % effort to <90% or fill out POW form.\",IF(K85>M5, \"Exceeds maximum summer salary amount.\",\"\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(K78:K81)+M9","v":0},{"$f":"K85/M5","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"If processing a paper EAF, please collect appropriate approvals. All Sponsored Projects must have PI approval for each award. "]
[]
[null,null,"Preparer Name:",null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,"Supervisor*:",null,null,null,null,null,null,null,null,"Date:"]
[null,null,"*only req'd if individual receiving SS is also the dept. approver"]
[]
[null,null,"SPA Approval:",null,null,null,null,null,null,null,null,"Date:"]

{"sheet":"A216810396964DCDB399904ED81BA8E","index":1,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Address","ValueType","Value"]

{"sheet":"Dropdowns","index":2,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,9,9.5,10,10.5,11,11.5,null,null,"Project delineations"]
[null,null,"Select One",null,"May 16",{"$f":"$F$10/6","v":5.5555555555555552E-2},{"$f":"$G$10/5","v":5.2631578947368418E-2},{"$f":"$H$10/4","v":0.05},{"$f":"$I$10/3","v":4.7619047619047616E-2},{"$f":"$J$10/2","v":4.5454545454545456E-2},{"$f":"$K$10/1","v":4.3478260869565216E-2},"May 31",null,0,9999,"Non-SPA"]
[9,null,"Yes",null,"Jun 1",5.5555555555555552E-2,5.2631578947368418E-2,0.05,4.7619047619047616E-2,4.5454545454545456E-2,4.3478260869565216E-2,"Jun 15",null,10000,19999,"Non-SPA"]
[9.5,null,"No",null,"Jun 16",5.5555555555555552E-2,5.2631578947368418E-2,0.05,4.7619047619047616E-2,4.5454545454545456E-2,4.3478260869565216E-2,"Jun 30",null,20000,29999,"Non-SPA"]
[10,null,null,null,"July 1",5.5555555555555552E-2,5.2631578947368418E-2,0.05,4.7619047619047616E-2,4.5454545454545456E-2,4.3478260869565216E-2,"July 15",null,30000,39999,"SPA"]
[10.5,null,null,null,"July 16",5.5555555555555552E-2,5.2631578947368418E-2,0.05,4.7619047619047616E-2,4.5454545454545456E-2,4.3478260869565216E-2,"July 31",null,40000,49999,"Non-SPA"]
[11,null,null,null,"Aug 1",5.5555555555555552E-2,5.2631578947368418E-2,0.05,4.7619047619047616E-2,4.5454545454545456E-2,4.3478260869565216E-2,"Aug 15",null,50000,59999,"Non-SPA"]
[11.5,null,null,null,null,null,null,null,null,null,null,null,null,60000,69999,"Non-SPA"]
[12,null,null,null,null,null,null,null,null,null,null,null,null,70000,79999,"Non-SPA"]
[null,null,null,null,null,{"$f":"3/9","v":0.33333333333333331},{"$f":"2.5/9.5","v":0.26315789473684209},{"$f":"2/10","v":0.2},{"$f":"1.5/10.5","v":0.14285714285714285},{"$f":"1/11","v":9.0909090909090912E-2},{"$f":"0.5/11.5","v":4.3478260869565216E-2},null,null,80000,89999,"Non-SPA"]
[null,null,null,null,null," ",null,null,null,null,null,null,null,90000,99999,"Non-SPA"]
[null,null,null,null,"May",{"$f":"0.5/3","v":0.16666666666666666},{"$f":"0.5/2.5","v":0.2},{"$f":"0.5/2","v":0.25},{"$f":"0.5/1.5","v":0.33333333333333331},{"$f":"0.5/1","v":0.5},{"$f":"0.5/0.5","v":1},null,null,"A0000","Z9999","SPA"]
[null,null,null,null,"June",{"$f":"1/3","v":0.33333333333333331},{"$f":"1/2.5","v":0.4},{"$f":"1/2","v":0.5},{"$f":"1/1.5","v":0.66666666666666663},{"$f":"1/1","v":1},{"$f":"0.5/1","v":0.5}]
[null,null,null,null,"July",{"$f":"1/3","v":0.33333333333333331},{"$f":"1/2.5","v":0.4},{"$f":"1/2","v":0.5},{"$f":"1/1.5","v":0.66666666666666663},{"$f":"1/1","v":1},{"$f":"0.5/1","v":0.5}]
[null,null,null,null,"Aug",{"$f":"0.5/3","v":0.16666666666666666},{"$f":"0.5/2.5","v":0.2},{"$f":"0.5/2","v":0.25},{"$f":"0.5/1.5","v":0.33333333333333331},{"$f":"0.5/1","v":0.5},{"$f":"0.5/0.5","v":1}]
[null,null,null,null,null,{"$f":"SUM(F12:F15)","v":0.99999999999999989},{"$f":"SUM(G12:G15)","v":1.2},1.5,1.9999999999999998,3,3]