{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Planning Tool","Notes","Macro Source - Do not edit"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Planning Tool","index":0,"n_rows":101,"n_cols":27,"rows_kept":101,"cut":false,"hidden":false,"merged":[[77,21,77,25],[84,0,85,0],[76,6,76,7],[76,8,76,9],[77,6,77,10],[77,11,77,15],[77,16,77,20],[65,21,65,25],[72,0,73,0],[64,6,64,7],[64,8,64,9],[65,6,65,10],[65,11,65,15],[65,16,65,20],[36,0,37,0],[24,0,25,0],[0,0,0,5],[2,6,2,10],[2,11,2,15],[2,16,2,20],[2,21,2,25],[29,21,29,25],[16,6,16,7],[16,8,16,9],[28,6,28,7],[28,8,28,9],[29,6,29,10],[29,11,29,15],[29,16,29,20],[17,6,17,10],[17,11,17,15],[17,16,17,20],[17,21,17,25],[40,6,40,7],[40,8,40,9],[41,6,41,10],[41,11,41,15],[41,16,41,20],[60,0,61,0],[41,21,41,25],[48,0,49,0],[52,6,52,7],[52,8,52,9],[53,6,53,10],[53,11,53,15],[53,16,53,20],[53,21,53,25],[89,21,89,25],[96,0,97,0],[88,6,88,7],[88,8,88,9],[89,6,89,10],[89,11,89,15],[89,16,89,20]]}
["Summer Assignment Master Spreadsheet\nFaculty Summer Assignments"]
["Last Name, First Name","Empl ID","Position #","\nTitle","Academic Year Rate (9 months)","Max Summer Rate (1/3)"]
["Doe, John",600123000,10026878,"0 Prof",90000,{"$f":"E3/3","v":30000},"Contract #1",null,null,null,null,"Contract #2",null,null,null,null,"Contract #3",null,null,null,null,"Contract #4",null,null,null,null,"Contract Totals \nCK Figures"]
["\nWorkload Description",null,"Effort for Assignment or Flat Rate","Project ID/Cost Center","SAMS Dates","Allocation","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%"]
["BEGIN"]
["ACC 2013.02",null,"Flat Rate","EGX334","July 16 - August 31",2700,null,null,0,null,{"$f":"I6/SUM($I$5:$I$11)","v":0},"2016-07-16","2016-08-31",2700,100168444,{"$f":"N6/SUM($N$5:$N$11)","v":0.48648648648648651},null,null,0,null,{"$f":"S6/SUM($S$5:$S$11)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X6/SUM($X$5:$X$11)","v":{"$error":"#DIV/0!"}},{"$f":"I6+N6+S6+X6","v":2700}]
["ACC 2013.01T",null,"Flat Rate","EGX334","June  1- August 31",5200,"2016-06-01","2016-07-15",2600,100168444,{"$f":"I7/SUM($I$5:$I$11)","v":0.5977011494252874},"2016-07-16","2016-08-31",2600,100168444,{"$f":"N7/SUM($N$5:$N$11)","v":0.46846846846846846},null,null,0,null,{"$f":"S7/SUM($S$5:$S$11)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X7/SUM($X$5:$X$11)","v":{"$error":"#DIV/0!"}},5200]
["Grant:  Univ of Utah ABH-4043",null,0.1,"3267501010","June 1 - July 15",1500,"2016-06-01","2016-07-15",1500,100388556,{"$f":"I8/SUM($I$5:$I$11)","v":0.34482758620689657},null,null,0,null,{"$f":"N8/SUM($N$5:$N$11)","v":0},null,null,0,null,{"$f":"S8/SUM($S$5:$S$11)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X8/SUM($X$5:$X$11)","v":{"$error":"#DIV/0!"}},1500]
["Committee Assignment",null,"Flat Rate","EGR335","June 1-August 31",500,"2016-06-01","2016-07-15",250,100188598,{"$f":"I9/SUM($I$5:$I$11)","v":5.7471264367816091E-2},"2016-07-16","2016-08-31",250,100188598,{"$f":"N9/SUM($N$5:$N$11)","v":4.5045045045045043E-2},null,null,0,null,{"$f":"S9/SUM($S$5:$S$11)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X9/SUM($X$5:$X$11)","v":{"$error":"#DIV/0!"}},500]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I10/SUM($I$5:$I$11)","v":0},null,null,null,null,{"$f":"N10/SUM($N$5:$N$11)","v":0},null,null,0,null,{"$f":"S10/SUM($S$5:$S$11)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X10/SUM($X$5:$X$11)","v":{"$error":"#DIV/0!"}},0]
["END"]
[null,null,null,null,"Total Allocation",{"$f":"SUM(F5:F11)","v":9900},null,null,{"$f":"SUM(I5:I11)","v":4350},null,{"$f":"SUM(K5:K11)","v":1},null,null,{"$f":"SUM(N5:N11)","v":5550},null,{"$f":"SUM(P5:P11)","v":1},null,null,{"$f":"SUM(S5:S11)","v":0},null,{"$f":"SUM(U5:U11)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X5:X11)","v":0},null,{"$f":"SUM(Z5:Z11)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA5:AA11)","v":9900}]
[null,null,null,null,"Calculated FTE",{"$f":"F12/F3","v":0.33},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA12-F12","v":0}]
[]
[]
[]
["Last Name, First Name","Empl ID","Position #","Title","Academic Year Rate (9 months)","Max Summer Rate (1/3)","EFORM REQUEST ID:"]
[null,null,null,null,null,{"$f":"E18/3","v":0},"Contract #1",null,null,null,null,"Contract #2",null,null,null,null,"Contract #3",null,null,null,null,"Contract #4",null,null,null,null,"Contract Totals \nCK Figures"]
["\nWorkload Description",null,"Effort for Assignment or Flat Rate","Project ID/Cost Center","SAMS Dates","Allocation","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I20/SUM(I20:I24)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I21/SUM($I$20:$I$24)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N21/SUM($N$20:$N$24)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S21/SUM($S$20:$S$24)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X21/SUM($X$20:$X$24)","v":{"$error":"#DIV/0!"}},{"$f":"I21+N21+S21+X21","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I22/SUM($I$20:$I$24)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N22/SUM($N$20:$N$24)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S22/SUM($S$20:$S$24)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X22/SUM($X$20:$X$24)","v":{"$error":"#DIV/0!"}},{"$f":"I22+N22+S22+X22","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I23/SUM($I$20:$I$24)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N23/SUM($N$20:$N$24)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S23/SUM($S$20:$S$24)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X23/SUM($X$20:$X$24)","v":{"$error":"#DIV/0!"}},0]
["END"]
["Monthly Salary Rate (reference for T/TT appointments)",null,null,null,"Total Allocation",{"$f":"SUM(F20:F24)","v":0},null,null,{"$f":"SUM(I20:I24)","v":0},null,{"$f":"SUM(K20:K24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N20:N24)","v":0},null,{"$f":"SUM(P20:P24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(S20:S24)","v":0},null,{"$f":"SUM(U20:U24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X20:X24)","v":0},null,{"$f":"SUM(Z20:Z24)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA20:AA24)","v":0}]
[null,{"$f":"E18/9","v":0},null,null,"Calculated FTE",{"$f":"F25/F18","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA25-F25","v":0}]
[]
[]
["Last Name, First Name","Empl ID","Position #","Title","Academic Year Rate (9 months)","Max Summer Rate (1/3)","EFORM REQUEST ID:"]
[null,null,null,null,null,{"$f":"E30/3","v":0},"Contract #1",null,null,null,null,"Contract #2",null,null,null,null,"Contract #3",null,null,null,null,"Contract #4",null,null,null,null,"Contract Totals \nCK Figures"]
["\nWorkload Description",null,"Effort for Assignment or Flat Rate","Project ID/Cost Center","SAMS Dates","Allocation","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I32/SUM($I$32:$I$36)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N32/SUM($N$32:$N$36)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S32/SUM($S$32:$S$36)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X32/SUM($X$32:$X$36)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I33/SUM($I$32:$I$36)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N33/SUM($N$32:$N$36)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S33/SUM($S$32:$S$36)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X33/SUM($X$32:$X$36)","v":{"$error":"#DIV/0!"}},{"$f":"I33+N33+S33+X33","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I34/SUM($I$32:$I$36)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N34/SUM($N$32:$N$36)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S34/SUM($S$32:$S$36)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X34/SUM($X$32:$X$36)","v":{"$error":"#DIV/0!"}},{"$f":"I34+N34+S34+X34","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N35/SUM($N$32:$N$36)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S35/SUM($S$32:$S$36)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X35/SUM($X$32:$X$36)","v":{"$error":"#DIV/0!"}},0]
["END",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N36/SUM($N$32:$N$36)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S36/SUM($S$32:$S$36)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X36/SUM($X$32:$X$36)","v":{"$error":"#DIV/0!"}}]
["Monthly Salary Rate (reference for T/TT appointments)",null,null,null,"Total Allocation",{"$f":"SUM(F32:F36)","v":0},null,null,{"$f":"SUM(I32:I36)","v":0},null,{"$f":"SUM(K32:K36)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N32:N36)","v":0},null,{"$f":"SUM(P32:P36)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(S32:S36)","v":0},null,{"$f":"SUM(U32:U36)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X32:X36)","v":0},null,{"$f":"SUM(Z32:Z36)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA32:AA36)","v":0}]
[null,{"$f":"E30/9","v":0},null,null,"Calculated FTE",{"$f":"F37/F30","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA37-F37","v":0}]
[]
[]
["Last Name, First Name","Empl ID","Position #","Title","Academic Year Rate (9 months)","Max Summer Rate (1/3)","EFORM REQUEST ID:"]
[null,null,null,null,null,{"$f":"E42/3","v":0},"Contract #1",null,null,null,null,"Contract #2",null,null,null,null,"Contract #3",null,null,null,null,"Contract #4",null,null,null,null,"Contract Totals \nCK Figures"]
["\nWorkload Description",null,"Effort for Assignment or Flat Rate","Project ID/Cost Center","SAMS Dates","Allocation","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I44/SUM($I$44:$I$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N44/SUM($N$44:$N$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S44/SUM($S$44:$S$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X44/SUM($X$44:$X$48)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I45/SUM($I$44:$I$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N45/SUM($N$44:$N$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S45/SUM($S$44:$S$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X45/SUM($X$44:$X$48)","v":{"$error":"#DIV/0!"}},{"$f":"I45+N45+S45+X45","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N46/SUM($N$44:$N$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S46/SUM($S$44:$S$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X46/SUM($X$44:$X$48)","v":{"$error":"#DIV/0!"}},{"$f":"I46+N46+S46+X46","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N47/SUM($N$44:$N$48)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S47/SUM($S$44:$S$48)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X47/SUM($X$44:$X$48)","v":{"$error":"#DIV/0!"}},0]
["END",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N48/SUM($N$44:$N$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S48/SUM($S$44:$S$48)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X48/SUM($X$44:$X$48)","v":{"$error":"#DIV/0!"}}]
["Monthly Salary Rate (reference for T/TT appointments)",null,null,null,"Total Allocation",{"$f":"SUM(F44:F48)","v":0},null,null,{"$f":"SUM(I44:I48)","v":0},null,{"$f":"SUM(K44:K48)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N44:N48)","v":0},null,{"$f":"SUM(P44:P48)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(S44:S48)","v":0},null,{"$f":"SUM(U44:U48)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X44:X48)","v":0},null,{"$f":"SUM(Z44:Z48)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA44:AA48)","v":0}]
[null,{"$f":"E42/9","v":0},null,null,"Calculated FTE",{"$f":"F49/F42","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA49-F49","v":0}]
[]
[]
["Last Name, First Name","Empl ID","Position #","Title","Academic Year Rate (9 months)","Max Summer Rate (1/3)","EFORM REQUEST ID:"]
[null,null,null,null,73386.2,{"$f":"E54/3","v":24462.066666666666},"Contract #1",null,null,null,null,"Contract #2",null,null,null,null,"Contract #3",null,null,null,null,"Contract #4",null,null,null,null,"Contract Totals \nCK Figures"]
["\nWorkload Description",null,"Effort for Assignment or Flat Rate","Project ID/Cost Center","SAMS Dates","Allocation","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I56/SUM($I$56:$I$60)","v":0},null,null,null,null,{"$f":"N56/SUM($N$56:$N$60)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S56/SUM($S$56:$S$60)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X56/SUM($X$56:$X$60)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,6250,null,null,6250,null,{"$f":"I57/SUM($I$56:$I$60)","v":0.49212598425196852},null,null,null,null,{"$f":"N57/SUM($N$56:$N$60)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S57/SUM($S$56:$S$60)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X57/SUM($X$56:$X$60)","v":{"$error":"#DIV/0!"}},{"$f":"I57+N57+S57+X57","v":6250}]
[null,null,null,null,null,6250,null,null,6250,null,0.49212598425196852,null,null,null,null,{"$f":"N58/SUM($N$56:$N$60)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S58/SUM($S$56:$S$60)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X58/SUM($X$56:$X$60)","v":{"$error":"#DIV/0!"}},{"$f":"I58+N58+S58+X58","v":6250}]
[null,null,null,null,null,200,null,null,200,null,1.5748031496062992E-2,null,null,null,null,{"$f":"N59/SUM($N$56:$N$60)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S59/SUM($S$56:$S$60)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X59/SUM($X$56:$X$60)","v":{"$error":"#DIV/0!"}},200]
["END",null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"N60/SUM($N$56:$N$60)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S60/SUM($S$56:$S$60)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X60/SUM($X$56:$X$60)","v":{"$error":"#DIV/0!"}}]
["Monthly Salary Rate (reference for T/TT appointments)",null,null,null,"Total Allocation",{"$f":"SUM(F56:F60)","v":12700},null,null,{"$f":"SUM(I56:I60)","v":12700},null,{"$f":"SUM(K56:K60)","v":1},null,null,{"$f":"SUM(N56:N60)","v":0},null,{"$f":"SUM(P56:P60)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(S56:S60)","v":0},null,{"$f":"SUM(U56:U60)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X56:X60)","v":0},null,{"$f":"SUM(Z56:Z60)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA56:AA60)","v":12700}]
[null,{"$f":"E54/9","v":8154.0222222222219},null,null,"Calculated FTE",{"$f":"F61/F54","v":0.51917117932254297},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA61-F61","v":0}]
[]
[]
["Last Name, First Name","Empl ID","Position #","Title","Academic Year Rate (9 months)","Max Summer Rate (1/3)","EFORM REQUEST ID:"]
[null,null,null,null,null,{"$f":"E66/3","v":0},"Contract #1",null,null,null,null,"Contract #2",null,null,null,null,"Contract #3",null,null,null,null,"Contract #4",null,null,null,null,"Contract Totals \nCK Figures"]
["\nWorkload Description",null,"Effort for Assignment or Flat Rate","Project ID/Cost Center","SAMS Dates","Allocation","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I68/SUM($I$68:$I$72)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N68/SUM($N$68:$N$72)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S68/SUM($S$68:$S$72)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X68/SUM($X$68:$X$72)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I69/SUM($I$68:$I$72)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N69/SUM($N$68:$N$72)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S69/SUM($S$68:$S$72)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X69/SUM($X$68:$X$72)","v":{"$error":"#DIV/0!"}},{"$f":"I69+N69+S69+X69","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N70/SUM($N$68:$N$72)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S70/SUM($S$68:$S$72)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X70/SUM($X$68:$X$72)","v":{"$error":"#DIV/0!"}},{"$f":"I70+N70+S70+X70","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N71/SUM($N$68:$N$72)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S71/SUM($S$68:$S$72)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X71/SUM($X$68:$X$72)","v":{"$error":"#DIV/0!"}},0]
["END",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N72/SUM($N$68:$N$72)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S72/SUM($S$68:$S$72)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X72/SUM($X$68:$X$72)","v":{"$error":"#DIV/0!"}}]
["Monthly Salary Rate (reference for T/TT appointments)",null,null,null,"Total Allocation",{"$f":"SUM(F68:F72)","v":0},null,null,{"$f":"SUM(I68:I72)","v":0},null,{"$f":"SUM(K68:K72)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N68:N72)","v":0},null,{"$f":"SUM(P68:P72)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(S68:S72)","v":0},null,{"$f":"SUM(U68:U72)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X68:X72)","v":0},null,{"$f":"SUM(Z68:Z72)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA68:AA72)","v":0}]
[null,{"$f":"E66/9","v":0},null,null,"Calculated FTE",{"$f":"F73/F66","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA73-F73","v":0}]
[]
[]
["Last Name, First Name","Empl ID","Position #","Title","Academic Year Rate (9 months)","Max Summer Rate (1/3)","EFORM REQUEST ID:"]
[null,null,null,null,null,{"$f":"E78/3","v":0},"Contract #1",null,null,null,null,"Contract #2",null,null,null,null,"Contract #3",null,null,null,null,"Contract #4",null,null,null,null,"Contract Totals \nCK Figures"]
["\nWorkload Description",null,"Effort for Assignment or Flat Rate","Project ID/Cost Center","SAMS Dates","Allocation","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I80/SUM($I$80:$I$84)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N80/SUM($N$80:$N$84)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S80/SUM($S$80:$S$84)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X80/SUM($X$80:$X$84)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I81/SUM($I$80:$I$84)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N81/SUM($N$80:$N$84)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S81/SUM($S$80:$S$84)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X81/SUM($X$80:$X$84)","v":{"$error":"#DIV/0!"}},{"$f":"I81+N81+S81+X81","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N82/SUM($N$80:$N$84)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S82/SUM($S$80:$S$84)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X82/SUM($X$80:$X$84)","v":{"$error":"#DIV/0!"}},{"$f":"I82+N82+S82+X82","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N83/SUM($N$80:$N$84)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S83/SUM($S$80:$S$84)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X83/SUM($X$80:$X$84)","v":{"$error":"#DIV/0!"}},0]
["END",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N84/SUM($N$80:$N$84)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S84/SUM($S$80:$S$84)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X84/SUM($X$80:$X$84)","v":{"$error":"#DIV/0!"}}]
["Monthly Salary Rate (reference for T/TT appointments)",null,null,null,"Total Allocation",{"$f":"SUM(F80:F84)","v":0},null,null,{"$f":"SUM(I80:I84)","v":0},null,{"$f":"SUM(K80:K84)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N80:N84)","v":0},null,{"$f":"SUM(P80:P84)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(S80:S84)","v":0},null,{"$f":"SUM(U80:U84)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X80:X84)","v":0},null,{"$f":"SUM(Z80:Z84)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA80:AA84)","v":0}]
[null,{"$f":"E78/9","v":0},null,null,"Calculated FTE",{"$f":"F85/F78","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA85-F85","v":0}]
[]
[]
["Last Name, First Name","Empl ID","Position #","Title","Academic Year Rate (9 months)","Max Summer Rate (1/3)","EFORM REQUEST ID:"]
[null,null,null,null,null,{"$f":"E90/3","v":0},"Contract #1",null,null,null,null,"Contract #2",null,null,null,null,"Contract #3",null,null,null,null,"Contract #4",null,null,null,null,"Contract Totals \nCK Figures"]
["\nWorkload Description",null,"Effort for Assignment or Flat Rate","Project ID/Cost Center","SAMS Dates","Allocation","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%","Start Date","End Date","Allocation","Project ID/Cost Center","Funding Dist%"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I92/SUM($I$92:$I$96)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N92/SUM($N$92:$N$96)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S92/SUM($S$92:$S$96)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X92/SUM($X$92:$X$96)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I93/SUM($I$92:$I$96)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N93/SUM($N$92:$N$96)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S93/SUM($S$92:$S$96)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X93/SUM($X$92:$X$96)","v":{"$error":"#DIV/0!"}},{"$f":"I93+N93+S93+X93","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N94/SUM($N$92:$N$96)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S94/SUM($S$92:$S$96)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X94/SUM($X$92:$X$96)","v":{"$error":"#DIV/0!"}},{"$f":"I94+N94+S94+X94","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N95/SUM($N$92:$N$96)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S95/SUM($S$92:$S$96)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X95/SUM($X$92:$X$96)","v":{"$error":"#DIV/0!"}},0]
["END",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"N96/SUM($N$92:$N$96)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"S96/SUM($S$92:$S$96)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"X96/SUM($X$92:$X$96)","v":{"$error":"#DIV/0!"}}]
["Monthly Salary Rate (reference for T/TT appointments)",null,null,null,"Total Allocation",{"$f":"SUM(F92:F96)","v":0},null,null,{"$f":"SUM(I92:I96)","v":0},null,{"$f":"SUM(K92:K96)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N92:N96)","v":0},null,{"$f":"SUM(P92:P96)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(S92:S96)","v":0},null,{"$f":"SUM(U92:U96)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X92:X96)","v":0},null,{"$f":"SUM(Z92:Z96)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA92:AA96)","v":0}]
[null,{"$f":"E90/9","v":0},null,null,"Calculated FTE",{"$f":"F97/F90","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA97-F97","v":0}]
[]
[]
["Revised 2/22/22"]

{"sheet":"Notes","index":1,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Notes"]
["Position number for new hires can be 'NEW\""]
["Policy: payment must be made during the time the money is earned"]
["maintain monthly caps - addresses tax implication and ensures reasonable effort"]
["Not allowed to spread beyond assignment period - allows for cleaner audit trail with multiple positions"]

{"sheet":"Macro Source - Do not edit","index":2,"n_rows":19,"n_cols":27,"rows_kept":19,"cut":false,"hidden":true,"merged":[[10,16,10,20],[10,21,10,25],[9,6,9,7],[9,8,9,9],[17,0,18,0],[10,6,10,10],[10,11,10,15]]}
[]
[]
["BLANK GENERIC ROW:"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I4/SUM($I$6:$I$14)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N4/SUM($N$6:$N$14)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S4/SUM($S$6:$S$14)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X4/SUM($X$6:$X$14)","v":{"$error":"#DIV/0!"}},{"$f":"I4+N4+S4+X4","v":0}]
[]
[]
[]
[]
["NEW SECTION:"]
["Last Name, First Name","Empl ID","Position #","Title","Academic Year Rate (9 months)","Max Summer Rate (1/3)","EFORM REQUEST ID:"]
[null,null,null,null,null,{"$f":"E11/3","v":0},"Contract #1",null,null,null,null,"Contract #2",null,null,null,null,"Contract #3",null,null,null,null,"Contract #4",null,null,null,null,"Contract Totals \nCK Figures"]
["\nWorkload Description",null,"Effort for Assignment or Flat Rate","Project ID/Cost Center","SAMS Dates","Allocation","Start Date","End Date","Allocation","SPEEDTYPE","Funding Dist%","Start Date","End Date","Allocation","SPEEDTYPE","Funding Dist%","Start Date","End Date","Allocation","SPEEDTYPE","Funding Dist%","Start Date","End Date","Allocation","SPEEDTYPE","Funding Dist%"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I13/SUM(I13:I17)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I14/SUM($I$13:$I$17)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N14/SUM($N$13:$N$17)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S14/SUM($S$13:$S$17)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X14/SUM($X$13:$X$17)","v":{"$error":"#DIV/0!"}},{"$f":"I14+N14+S14+X14","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I15/SUM($I$13:$I$17)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N15/SUM($N$13:$N$17)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S15/SUM($S$13:$S$17)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X15/SUM($X$13:$X$17)","v":{"$error":"#DIV/0!"}},{"$f":"I15+N15+S15+X15","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I16/SUM($I$13:$I$17)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N16/SUM($N$13:$N$17)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"S16/SUM($S$13:$S$17)","v":{"$error":"#DIV/0!"}},null,null,0,null,{"$f":"X16/SUM($X$13:$X$17)","v":{"$error":"#DIV/0!"}},0]
["END"]
["Monthly Salary Rate (reference for T/TT appointments)",null,null,null,"Total Allocation",{"$f":"SUM(F13:F17)","v":0},null,null,{"$f":"SUM(I13:I17)","v":0},null,{"$f":"SUM(K13:K17)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N13:N17)","v":0},null,{"$f":"SUM(P13:P17)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(S13:S17)","v":0},null,{"$f":"SUM(U13:U17)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X13:X17)","v":0},null,{"$f":"SUM(Z13:Z17)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA13:AA17)","v":0}]
[null,{"$f":"E11/9","v":0},null,null,"Calculated FTE",{"$f":"F18/F11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA18-F18","v":0}]