{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions ","1 Year","2 Year","3 Year","4 Year","5 Year","RATES-Non Fed","Salary Inflation","NIH sal cap info","PM Conversion Chart","Ref","Kuali"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":39,"comments":6,"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":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[[28,1,30,11],[37,1,38,11],[40,1,40,10],[35,10,35,12],[70,10,70,12]]}
["Instructions for Federal projects "]
[]
["Step 1:  MANDATORY"]
["Click on Rates worksheet"]
[null,"Change the budget period dates to coincide with your project period"]
[null,"Change the BUDGET INITIATION DATE to coincide with the date you started your budget (today's date). This is needed in order to calculate salary increases correctly"]
[]
[]
["Click on the worksheet that agrees with the number years you are requesting the sponsor to fund"]
[null,"Go to the \"Indirect Data\" section at the bottom of the worksheet and enter the indirect data relative to your project"]
[null,null,"Change the letters/numbers in blue as appropriate"]
[null,"Return to Row 4"]
[null,"Click on the word name next to Sponsoring Agency and enter your sponsor's name"]
[null,"Click on the word name next to Title and enter the title of your project"]
[null,"Click on the word name next to Principal Investigator (PI) and the PI's name "]
[]
[null,"Your project start and end date should appear in red. "]
[null,null," They come from the dates you entered on the Rates Worksheet"]
[]
[null,"Click on the first \"-\" under salary and enter the current base salary per UCFlex. The spreadsheet will calculate the appropriate base for the start date of the award based on inflation factors"]
[null,null,"The appropriate salary increases for the same % of effort in subsequent years are automatically calculated in the spreadsheet."]
[null,null,"The recess base salary will be calculated automatically"]
[]
[null,"Click on the 0% under effort and enter the percentage of time you will spend on the project during the academic period."]
[null,null,"The amount will automatically calculate and be entered in the year 1 column"]
[]
[null,"Click on the second 0% under effort and enter the percentage of time you will spend on the project during the recess year."]
[]
[null,"Determine if the CoPI(s) are on a 32 week (aka 9 month or academic year) or 12 month appointment (most College of Medicine faculty are on a 12 month appointment). Use the appropriate line(s) in Senior Personnel section for their type of Appointment."]
[]
[]
[]
[null,"Enter the name of the Co-PI"]
[null,"Enter the percentage of time the Co PI will spend on the project during the academic period."]
[null,null,"The amount will automatically calculate  and be entered in the year 1 column"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'RATES-Non Fed'!Q69","v":0}]
[]
[null,"If the Co-PI is on a 32 week appointment and eligible for Extra Compensation enter the percentage of time the CoPI will spend on the project during the recess period."]
[]
[]
[null,"Add additional Co-PIs as appropriate"]
[]
[null,"Proceed to enter budget dollars for remainder of personnel"]
[]
[null,"Fringes will calculate automatically for you."]
[]
[null,"Proceed to enter budget dollars for remainder of cost categories."]
[]
[null,"If you are using a multi year budget you will notice in years 2 and beyond "]
[null,"some of the fields are calculating automatically (4% increase)"]
[]
[null,"You may override any of those dollars by entering any number in the field."]
[null,"Do not override any fringe or indirect cost entries"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'RATES-Non Fed'!Q69","v":0}]

{"sheet":"1 Year","index":1,"n_rows":85,"n_cols":13,"rows_kept":85,"cut":false,"hidden":false,"merged":[[7,9,7,11],[3,10,4,14],[84,12,84,14],[83,3,84,6]]}
["Grants / Contracts"]
["1 Year Budget "]
[" ",null,null,null,null,null,null,null,null," "]
["Sponsoring Agency : ",null,null,"name",null,null,null,null,"name","Titled : ","name"]
["Principal Investigator : ",null,null,"name"]
[null,"Period : ",null,{"$f":"'RATES-Non Fed'!E2","v":"2024-01-01"},"thru",null,{"$f":"'RATES-Non Fed'!G2","v":"1930-12-31"}]
[null,null,null,null,null,null,null,null,null," "]
[null," Salaries",null,null,null,null,null,null,null,"Year 1",null,null,"CUMULATIVE"]
["A.","AAUP Faculty",null,null,null,null,null,null,null,"Sal","FB","Total"]
[null,null,null,"App't Type","% Effort","PM","Salary",null,null,null,null,null,{"$f":"IF(SUM(J10:L10)=0,\"\",SUM(J10:L10))","v":""}]
[null,"PI",null,"ACAD",0,{"$f":"IF(D11=\"CAL\",(52*E11/4.3333),(IF(D11=\"ACAD\",(36.35*E11/4.33333),IF(D11=\"SUMR\",(15.65*E11/4.33333),IF(D11=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"IF($D11=\"CAL\",ROUND(($G11*(1+'Salary Inflation'!$B$30))*$E11,0),IF($D11=\"ACAD\",($G11/0.9965)*(1+'Salary Inflation'!$B$31)*$E11,IF($D11=\"SUMR\",($G11)*(1+'Salary Inflation'!$B$32)*$E11,\"NA\")))","v":0},{"$f":"IF(D11=\"CAL\",ROUND(J11*'RATES-Non Fed'!$E$38,0),IF(D11=\"ACAD\",J11*'RATES-Non Fed'!$E$44,J11*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K11+J11,0)","v":0},{"$f":"SUM(L11)","v":0}]
[null,"PI",null,"SUMR",0,0,{"$f":"IF(D11=\"ACAD\",+G11*0.437,0)","v":0},null,null,{"$f":"IF($D12=\"CAL\",ROUND(($G12*(1+'Salary Inflation'!$B$30))*$E12,0),IF($D12=\"ACAD\",($G12/0.9965)*(1+'Salary Inflation'!$B$31)*$E12,IF($D12=\"SUMR\",($G12)*(1+'Salary Inflation'!$B$32)*$E12,\"NA\")))","v":0},{"$f":"IF(D12=\"CAL\",ROUND(J12*'RATES-Non Fed'!$E$38,0),IF(D12=\"ACAD\",J12*'RATES-Non Fed'!$E$44,J12*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K12+J12,0)","v":0},{"$f":"SUM(L12)","v":0}]
[null,"Co",null,"ACAD",0,0,0,null,null,{"$f":"IF($D13=\"CAL\",ROUND(($G13*(1+'Salary Inflation'!$B$30))*$E13,0),IF($D13=\"ACAD\",($G13/0.9965)*(1+'Salary Inflation'!$B$31)*$E13,IF($D13=\"SUMR\",($G13)*(1+'Salary Inflation'!$B$32)*$E13,\"NA\")))","v":0},{"$f":"IF(D13=\"CAL\",ROUND(J13*'RATES-Non Fed'!$E$38,0),IF(D13=\"ACAD\",J13*'RATES-Non Fed'!$E$44,J13*'RATES-Non Fed'!$E$45))","v":0},0,0]
[null,null,null,{"$f":"IF(D13=\"ACAD\",(\"SUMR\"),\"\")","v":"SUMR"},0,0,{"$f":"IF(D13=\"ACAD\",+G13*0.437,0)","v":0},null,null,{"$f":"IF($D14=\"CAL\",ROUND(($G14*(1+'Salary Inflation'!$B$30))*$E14,0),IF($D14=\"ACAD\",($G14/0.9965)*(1+'Salary Inflation'!$B$31)*$E14,IF($D14=\"SUMR\",($G14)*(1+'Salary Inflation'!$B$32)*$E14,\"NA\")))","v":0},{"$f":"IF(D14=\"CAL\",ROUND(J14*'RATES-Non Fed'!$E$38,0),IF(D14=\"ACAD\",J14*'RATES-Non Fed'!$E$44,J14*'RATES-Non Fed'!$E$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D15=\"CAL\",ROUND(($G15*(1+'Salary Inflation'!$B$30))*$E15,0),IF($D15=\"ACAD\",($G15/0.9965)*(1+'Salary Inflation'!$B$31)*$E15,IF($D15=\"SUMR\",($G15)*(1+'Salary Inflation'!$B$32)*$E15,\"NA\")))","v":0},{"$f":"IF(D15=\"CAL\",ROUND(J15*'RATES-Non Fed'!$E$38,0),IF(D15=\"ACAD\",J15*'RATES-Non Fed'!$E$44,J15*'RATES-Non Fed'!$E$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D16=\"CAL\",ROUND(($G16*(1+'Salary Inflation'!$B$30))*$E16,0),IF($D16=\"ACAD\",($G16/0.9965)*(1+'Salary Inflation'!$B$31)*$E16,IF($D16=\"SUMR\",($G16)*(1+'Salary Inflation'!$B$32)*$E16,\"NA\")))","v":0},{"$f":"IF(D16=\"CAL\",ROUND(J16*'RATES-Non Fed'!$E$38,0),IF(D16=\"ACAD\",J16*'RATES-Non Fed'!$E$44,J16*'RATES-Non Fed'!$E$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D17=\"CAL\",ROUND(($G17*(1+'Salary Inflation'!$B$30))*$E17,0),IF($D17=\"ACAD\",($G17/0.9965)*(1+'Salary Inflation'!$B$31)*$E17,IF($D17=\"SUMR\",($G17)*(1+'Salary Inflation'!$B$32)*$E17,\"NA\")))","v":0},{"$f":"IF(D17=\"CAL\",ROUND(J17*'RATES-Non Fed'!$E$38,0),IF(D17=\"ACAD\",J17*'RATES-Non Fed'!$E$44,J17*'RATES-Non Fed'!$E$45))","v":0},0,0]
[null,null,null,"AAUP Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J11:J17)","v":0},{"$f":"SUM(K11:K17)","v":0},{"$f":"SUM(L11:L17)","v":0},{"$f":"SUM(M11:M17)","v":0}]
["B","Dual Compensation Faculty"]
[null,"PI",null,"CAL",0,{"$f":"IF(D20=\"CAL\",(52*E20/4.3333),(IF(D20=\"ACAD\",(32*E20/4.33333),IF(D20=\"SUMR\",(14*E20/4.33333),IF(D20=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G20*(1+'Salary Inflation'!$B$34))*$E20,0)","v":0},{"$f":"ROUND(J20*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K20+J20,0)","v":0},{"$f":"SUM(L20)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D21=\"CAL\",(52*E21/4.3333),(IF(D21=\"ACAD\",(32*E21/4.33333),IF(D21=\"SUMR\",(14*E21/4.33333),IF(D21=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G21*(1+'Salary Inflation'!$B$34))*$E21,0)","v":0},{"$f":"ROUND(J21*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K21+J21,0)","v":0},{"$f":"SUM(L21)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D22=\"CAL\",(52*E22/4.3333),(IF(D22=\"ACAD\",(32*E22/4.33333),IF(D22=\"SUMR\",(14*E22/4.33333),IF(D22=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G22*(1+'Salary Inflation'!$B$34))*$E22,0)","v":0},{"$f":"ROUND(J22*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K22+J22,0)","v":0},{"$f":"SUM(L22)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D23=\"CAL\",(52*E23/4.3333),(IF(D23=\"ACAD\",(32*E23/4.33333),IF(D23=\"SUMR\",(14*E23/4.33333),IF(D23=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G23*(1+'Salary Inflation'!$B$34))*$E23,0)","v":0},{"$f":"ROUND(J23*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K23+J23,0)","v":0},{"$f":"SUM(L23)","v":0}]
[null,null,null,"Dual Comp Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J20:J23)","v":0},{"$f":"SUM(K20:K23)","v":0},{"$f":"SUM(L20:L23)","v":0},{"$f":"SUM(M20:M23)","v":0}]
[]
["C."," Other Personnel"]
[null,null,"Exempt Staff (Monthly)","Name"]
[null,null,null,null,0,{"$f":"SUM(52*E28/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G28*(1+'Salary Inflation'!$B$33))*$E28,0)","v":0},{"$f":"ROUND(J28*'RATES-Non Fed'!E39,0)","v":0},{"$f":"SUM(J28:K28)","v":0},{"$f":"SUM(L28)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E29/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G29*(1+'Salary Inflation'!$B$33))*$E29,0)","v":0},{"$f":"ROUND(J29*'RATES-Non Fed'!E39,0)","v":0},{"$f":"SUM(J29:K29)","v":0},{"$f":"SUM(L29)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E30/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G30*(1+'Salary Inflation'!$B$33))*$E30,0)","v":0},{"$f":"ROUND(J30*'RATES-Non Fed'!E39,0)","v":0},{"$f":"SUM(J30:K30)","v":0},{"$f":"SUM(L30)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E31/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G31*(1+'Salary Inflation'!$B$33))*$E31,0)","v":0},{"$f":"ROUND(J31*'RATES-Non Fed'!E39,0)","v":0},{"$f":"SUM(J31:K31)","v":0},{"$f":"SUM(L31)","v":0}]
[null,null,null,"Total Exempt Staff",null,null,null,null,null,{"$f":"SUM(J28:J31)","v":0},{"$f":"SUM(K28:K31)","v":0},{"$f":"SUM(L28:L31)","v":0},{"$f":"SUM(M28:M31)","v":0}]
[]
[null,null,"Post Doctoral Support",null,0,{"$f":"SUM(52*E34/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G34*(1+'Salary Inflation'!$B$33))*$E34,0)","v":0},{"$f":"ROUND(J34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(J34:K34)","v":0},{"$f":"SUM(L34)","v":0}]
[null,null,"Graduate Students",null,0,{"$f":"SUM(52*E35/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G35*(1+'Salary Inflation'!$B$33))*$E35,0)","v":0},{"$f":"ROUND(J35*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J35:K35)","v":0},{"$f":"SUM(L35)","v":0}]
[null,null,"Undergrad Students",null,0,{"$f":"SUM(52*E36/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G36*(1+'Salary Inflation'!$B$33))*$E36,0)","v":0},{"$f":"ROUND(J36*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J36:K36)","v":0},{"$f":"SUM(L36)","v":0}]
[null,null,"Part-time Faculty/Staff",null,0,{"$f":"SUM(52*E37/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G37*(1+'Salary Inflation'!$B$33))*$E37,0)","v":0},{"$f":"ROUND(J37*'RATES-Non Fed'!E43,0)","v":0},{"$f":"SUM(J37:K37)","v":0},{"$f":"SUM(L37)","v":0}]
[null,null,"Non-Exempt Staff (Bi-Weekly)",null,0,{"$f":"SUM(52*E38/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G38*(1+'Salary Inflation'!$B$33))*$E38,0)","v":0},{"$f":"ROUND(J38*'RATES-Non Fed'!E41,0)","v":0},{"$f":"SUM(J38:K38)","v":0},{"$f":"SUM(L38)","v":0}]
[null,null,null,"Sub Totals",null,null,null,null,null,{"$f":"SUM(J18+J24+J32+J34+J35+J36+J37+J38)","v":0},{"$f":"SUM(K18+K24+K32+K34+K35+K36+K37+K38)","v":0},{"$f":"SUM(L34:L38)","v":0},{"$f":"SUM(M34:M38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
["Total Salaries and Fringe Benefits : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J39+K39)","v":0},null,null,{"$f":"SUM(J41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
["D."," Equipment",null,null,null,null,null,null,null,null,null,null," "]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,{"$f":"SUM(J44:L44)","v":0}]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,{"$f":"SUM(J45:L45)","v":0}]
[null,null,"Total Equipment : ",null,null,null,null,null,null,{"$f":"SUM(J44:J45)","v":0},null,null,{"$f":"SUM(J46:L46)","v":0}]
[]
["E."," Travel",null,null,null,null,null,null,null," "]
[null,null,"Domestic ","(list)",null,null,null,null,null,0,null,null,{"$f":"SUM(J49:L49)","v":0}]
[null,null,"International ","(list)",null,null,null,null,null,0,null,null,{"$f":"SUM(J50:L50)","v":0}]
[null,null,"Total Travel : ",null,null,null,null,null,null,{"$f":"SUM(J49:J50)","v":0},null,null,{"$f":"SUM(J51:L51)","v":0}]
[]
["G."," Supplies and Other Direct Costs",null,null,null,null,null,null,null," "]
[null,null,"Materials & Supplies",null,null,null,null,null,null,0,null,null,{"$f":"SUM(J54:L54)","v":0}]
[null,null,"LAM",null,null,null,null,null,null,0,null,null,0]
[null,null,"Consultant Services",null,null,null,null,null,null,0,null,null,0]
[null,null,"Subject Incentives",null,null,null,null,null,null,0,null,null,0]
[null,null,"UC Tuition for Trainees/Fellows",null,null,null,null,null,null,0,null,null,0]
[null,null,"UC Tuition on Research Projects",null,null,null,null,null,null,0,null,null,{"$f":"SUM(J59:L59)","v":0}]
[null,null,"Lab Expenses",null,null,null,null,null,null,0,null,null,0]
[null,null,"Other (Analytical Services/Instrument Use)",null,null,null,null,null,null,0,null,null,0]
[null,null,"Subcontracts       1)",null,null,null,null,null,null,0,null,null,0]
[null,null,"2)",null,null,null,null,null,null,0,null,null,0]
[null,null,"3)",null,null,null,null,null,null,0,null,null,0]
[null,null,"4)",null,null,null,null,null,null,0,null,null,0]
["Total Supplies and Other Direct Costs : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J54:J65)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"TOTAL DIRECT COSTS: ",null,null,null,null,{"$f":"ROUND(+J66+J51+J46+J41,0)","v":0},null,null,{"$f":"SUM(J68:L68)","v":0}]
[]
[null,null,null,null,null,null,null,"Facilities and Administrative Cost Base:",null,{"$f":"J68","v":0},null,null,{"$f":"SUM(J70:L70)","v":0}]
["Facilities and Administrative Costs Calculation: "]
["F&A Cost (on MTDC): ",null,null,{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!E48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!E53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!E49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!E54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!E50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!E55),($E$80)))))))","v":0.62},null,null,null,null,null,{"$f":"+J70*D72","v":0},null,null,{"$f":"SUM(J72:L72)","v":0}]
["Total F&A Cost : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J72:J72)","v":0},null,null,{"$f":"SUM(J73:L73)","v":0}]
[]
[null,null,"Total  Cost",null,null,null,null,null,null,{"$f":"J73+J68","v":0},null,null,{"$f":"SUM(J75:L75)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"Facilities and Administrative Data"]
[null,null,"Purpose of Grant / Contract : ",null,"R",null,"(R = Research, I = Instruction, P = Public Service, S = Special Rate on Total Costs)"]
[null,null,"Special F&A Rate : ",null,0.1]
[null,null,"Campus Status :",null,"C",null,"(C = On Campus, O = Off Campus)"]
[]
[null,null,null,"Detailed F&A figures for prorated rates",null,null,null,{"$f":"+'RATES-Non Fed'!E31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$C$48","v":0}]
[null,null,null,"*If both lines have the same rate, then just list as one line on forms.",null,null,null,{"$f":"+'RATES-Non Fed'!G31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$D$48","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J83:J84)","v":0}]

{"sheet":"2 Year","index":2,"n_rows":86,"n_cols":16,"rows_kept":86,"cut":false,"hidden":false,"merged":[[3,10,4,14],[7,9,7,11],[7,12,7,14],[84,13,84,15],[84,3,85,6]]}
["Grants / Contracts"]
["2 Year Budget "]
[" ",null,null,null,null,null,null,null,null," "]
["Sponsoring Agency : ",null,null,"name",null,null,null,null,null,"Titled : ","name"]
["Principal Investigator : ",null,null,"name"]
[null,"Period : ",null,{"$f":"'RATES-Non Fed'!E2","v":"2024-01-01"},"thru",null,{"$f":"'RATES-Non Fed'!G2","v":"1930-12-31"}]
[null,null,null,null,null,null,null,null,null," "]
[null,null," Salaries",null,null,null,null,null,null,"Year 1",null,null,"Year 2",null,null,"CUMULATIVE"]
["A.",null,null,null,null,null,null,null,null,"Sal","FB","Total","Sal","FB","Total"]
[null,"Senior Personnel",null,"App't Type","% Effort","PM","Salary",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J10:N10)=0,\"\",SUM(J10:N10))","v":""}]
[null,"PI",null,"ACAD",0,{"$f":"IF(D11=\"CAL\",(52*E11/4.3333),(IF(D11=\"ACAD\",(36.35*E11/4.33333),IF(D11=\"SUMR\",(15.65*E11/4.33333),IF(D11=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"IF($D11=\"CAL\",ROUND(($G11*(1+'Salary Inflation'!$B$30))*$E11,0),IF($D11=\"ACAD\",($G11/0.9965)*(1+'Salary Inflation'!$B$31)*$E11,IF($D11=\"SUMR\",($G11)*(1+'Salary Inflation'!$B$32)*$E11,\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(J11*'RATES-Non Fed'!$E$38,0),IF($D11=\"ACAD\",J11*'RATES-Non Fed'!$E$44,J11*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K11+J11,0)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((J11*(1+'Salary Inflation'!$C$30)),0),IF($D11=\"ACAD\",(J11)*(1+'Salary Inflation'!$C$31),IF($D11=\"SUMR\",(J11)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(M11*'RATES-Non Fed'!$G$38,0),IF($D11=\"ACAD\",M11*'RATES-Non Fed'!$G$44,M11*'RATES-Non Fed'!$G$45))","v":0},{"$f":"ROUND(M11+N11,0)","v":0},{"$f":"SUM(L11+O11)","v":0}]
[null,"PI",null,"SUMR",0,0,{"$f":"IF(D11=\"ACAD\",+G11*0.437,0)","v":0},null,null,{"$f":"IF($D12=\"CAL\",ROUND(($G12*(1+'Salary Inflation'!$B$30))*$E12,0),IF($D12=\"ACAD\",($G12/0.9965)*(1+'Salary Inflation'!$B$31)*$E12,IF($D12=\"SUMR\",($G12)*(1+'Salary Inflation'!$B$32)*$E12,\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(J12*'RATES-Non Fed'!$E$38,0),IF($D12=\"ACAD\",J12*'RATES-Non Fed'!$E$44,J12*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K12+J12,0)","v":0},{"$f":"IF($D12=\"CAL\",ROUND((J12*(1+'Salary Inflation'!$C$30)),0),IF($D12=\"ACAD\",(J12)*(1+'Salary Inflation'!$C$31),IF($D12=\"SUMR\",(J12)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(M12*'RATES-Non Fed'!$G$38,0),IF($D12=\"ACAD\",M12*'RATES-Non Fed'!$G$44,M12*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"SUM(L12+O12)","v":0}]
[null,"Co",null,"ACAD",0,0,0,null,null,{"$f":"IF($D13=\"CAL\",ROUND(($G13*(1+'Salary Inflation'!$B$30))*$E13,0),IF($D13=\"ACAD\",($G13/0.9965)*(1+'Salary Inflation'!$B$31)*$E13,IF($D13=\"SUMR\",($G13)*(1+'Salary Inflation'!$B$32)*$E13,\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(J13*'RATES-Non Fed'!$E$38,0),IF($D13=\"ACAD\",J13*'RATES-Non Fed'!$E$44,J13*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((J13*(1+'Salary Inflation'!$C$30)),0),IF($D13=\"ACAD\",(J13)*(1+'Salary Inflation'!$C$31),IF($D13=\"SUMR\",(J13)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(M13*'RATES-Non Fed'!$G$38,0),IF($D13=\"ACAD\",M13*'RATES-Non Fed'!$G$44,M13*'RATES-Non Fed'!$G$45))","v":0},0,0]
[null,null,null,{"$f":"IF(D13=\"ACAD\",(\"SUMR\"),\"\")","v":"SUMR"},0,0,{"$f":"IF(D13=\"ACAD\",+G13*0.437,0)","v":0},null,null,{"$f":"IF($D14=\"CAL\",ROUND(($G14*(1+'Salary Inflation'!$B$30))*$E14,0),IF($D14=\"ACAD\",($G14/0.9965)*(1+'Salary Inflation'!$B$31)*$E14,IF($D14=\"SUMR\",($G14)*(1+'Salary Inflation'!$B$32)*$E14,\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(J14*'RATES-Non Fed'!$E$38,0),IF($D14=\"ACAD\",J14*'RATES-Non Fed'!$E$44,J14*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((J14*(1+'Salary Inflation'!$C$30)),0),IF($D14=\"ACAD\",(J14)*(1+'Salary Inflation'!$C$31),IF($D14=\"SUMR\",(J14)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(M14*'RATES-Non Fed'!$G$38,0),IF($D14=\"ACAD\",M14*'RATES-Non Fed'!$G$44,M14*'RATES-Non Fed'!$G$45))","v":0},0,0]
[null,"Co",null,"ACAD",0,0,0,null,null,{"$f":"IF($D15=\"CAL\",ROUND(($G15*(1+'Salary Inflation'!$B$30))*$E15,0),IF($D15=\"ACAD\",($G15/0.9965)*(1+'Salary Inflation'!$B$31)*$E15,IF($D15=\"SUMR\",($G15)*(1+'Salary Inflation'!$B$32)*$E15,\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(J15*'RATES-Non Fed'!$E$38,0),IF($D15=\"ACAD\",J15*'RATES-Non Fed'!$E$44,J15*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((J15*(1+'Salary Inflation'!$C$30)),0),IF($D15=\"ACAD\",(J15)*(1+'Salary Inflation'!$C$31),IF($D15=\"SUMR\",(J15)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(M15*'RATES-Non Fed'!$G$38,0),IF($D15=\"ACAD\",M15*'RATES-Non Fed'!$G$44,M15*'RATES-Non Fed'!$G$45))","v":0},0,0]
[null,null,null,{"$f":"IF(D15=\"ACAD\",(\"SUMR\"),\"\")","v":"SUMR"},0,0,{"$f":"IF(D15=\"ACAD\",+G15*0.428,0)","v":0},null,null,{"$f":"IF($D16=\"CAL\",ROUND(($G16*(1+'Salary Inflation'!$B$30))*$E16,0),IF($D16=\"ACAD\",($G16/0.9965)*(1+'Salary Inflation'!$B$31)*$E16,IF($D16=\"SUMR\",($G16)*(1+'Salary Inflation'!$B$32)*$E16,\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(J16*'RATES-Non Fed'!$E$38,0),IF($D16=\"ACAD\",J16*'RATES-Non Fed'!$E$44,J16*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((J16*(1+'Salary Inflation'!$C$30)),0),IF($D16=\"ACAD\",(J16)*(1+'Salary Inflation'!$C$31),IF($D16=\"SUMR\",(J16)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(M16*'RATES-Non Fed'!$G$38,0),IF($D16=\"ACAD\",M16*'RATES-Non Fed'!$G$44,M16*'RATES-Non Fed'!$G$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D17=\"CAL\",ROUND(($G17*(1+'Salary Inflation'!$B$30))*$E17,0),IF($D17=\"ACAD\",($G17/0.9965)*(1+'Salary Inflation'!$B$31)*$E17,IF($D17=\"SUMR\",($G17)*(1+'Salary Inflation'!$B$32)*$E17,\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(J17*'RATES-Non Fed'!$E$38,0),IF($D17=\"ACAD\",J17*'RATES-Non Fed'!$E$44,J17*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((J17*(1+'Salary Inflation'!$C$30)),0),IF($D17=\"ACAD\",(J17)*(1+'Salary Inflation'!$C$31),IF($D17=\"SUMR\",(J17)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(M17*'RATES-Non Fed'!$G$38,0),IF($D17=\"ACAD\",M17*'RATES-Non Fed'!$G$44,M17*'RATES-Non Fed'!$G$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D18=\"CAL\",ROUND(($G18*(1+'Salary Inflation'!$B$30))*$E18,0),IF($D18=\"ACAD\",($G18/0.9965)*(1+'Salary Inflation'!$B$31)*$E18,IF($D18=\"SUMR\",($G18)*(1+'Salary Inflation'!$B$32)*$E18,\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(J18*'RATES-Non Fed'!$E$38,0),IF($D18=\"ACAD\",J18*'RATES-Non Fed'!$E$44,J18*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((J18*(1+'Salary Inflation'!$C$30)),0),IF($D18=\"ACAD\",(J18)*(1+'Salary Inflation'!$C$31),IF($D18=\"SUMR\",(J18)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(M18*'RATES-Non Fed'!$G$38,0),IF($D18=\"ACAD\",M18*'RATES-Non Fed'!$G$44,M18*'RATES-Non Fed'!$G$45))","v":0},0,0]
[null,null,null,"AAUP Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J11:J18)","v":0},0,0,0,0,0,0]
["B","Dual Compensation Faculty"]
[null,"Co",null,"CAL",0,{"$f":"IF(D21=\"CAL\",(52*E21/4.3333),(IF(D21=\"ACAD\",(32*E21/4.33333),IF(D21=\"SUMR\",(14*E21/4.33333),IF(D21=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G21*(1+'Salary Inflation'!$B$34))*$E21,0)","v":0},{"$f":"ROUND(J21*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K21+J21,0)","v":0},{"$f":"ROUND(J21*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M21*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M21+N21,0)","v":0},{"$f":"SUM(L21+O21)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D22=\"CAL\",(52*E22/4.3333),(IF(D22=\"ACAD\",(32*E22/4.33333),IF(D22=\"SUMR\",(14*E22/4.33333),IF(D22=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G22*(1+'Salary Inflation'!$B$34))*$E22,0)","v":0},{"$f":"ROUND(J22*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K22+J22,0)","v":0},{"$f":"ROUND(J22*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M22*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M22+N22,0)","v":0},{"$f":"SUM(L22+O22)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D23=\"CAL\",(52*E23/4.3333),(IF(D23=\"ACAD\",(32*E23/4.33333),IF(D23=\"SUMR\",(14*E23/4.33333),IF(D23=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G23*(1+'Salary Inflation'!$B$34))*$E23,0)","v":0},{"$f":"ROUND(J23*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K23+J23,0)","v":0},{"$f":"ROUND(J23*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M23*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M23+N23,0)","v":0},{"$f":"SUM(L23+O23)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D24=\"CAL\",(52*E24/4.3333),(IF(D24=\"ACAD\",(32*E24/4.33333),IF(D24=\"SUMR\",(14*E24/4.33333),IF(D24=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G24*(1+'Salary Inflation'!$B$34))*$E24,0)","v":0},{"$f":"ROUND(J24*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K24+J24,0)","v":0},{"$f":"ROUND(J24*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M24*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M24+N24,0)","v":0},{"$f":"SUM(L24+O24)","v":0}]
[null,null,null,"Dual Comp Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J21:J24)","v":0},0,0,0,0,0,0]
[]
["C."," Other Personnel"]
[null,null,"Exempt Staff (Monthly)","Name"]
[null,null,null,null,0,{"$f":"SUM(52*E29/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G29*(1+'Salary Inflation'!$B$33))*$E29,0)","v":0},{"$f":"ROUND(J29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J29:K29)","v":0},{"$f":"ROUND(J29*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M29*'RATES-Non Fed'!G39,0)","v":0},{"$f":"SUM(M29:N29)","v":0},{"$f":"SUM(L29+O29)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E30/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G30*(1+'Salary Inflation'!$B$33))*$E30,0)","v":0},{"$f":"ROUND(J30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J30:K30)","v":0},{"$f":"ROUND(J30*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M30*'RATES-Non Fed'!G39,0)","v":0},{"$f":"SUM(M30:N30)","v":0},{"$f":"SUM(L30+O30)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E31/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G31*(1+'Salary Inflation'!$B$33))*$E31,0)","v":0},{"$f":"ROUND(J31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J31:K31)","v":0},{"$f":"ROUND(J31*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M31*'RATES-Non Fed'!G39,0)","v":0},{"$f":"SUM(M31:N31)","v":0},{"$f":"SUM(L31+O31)","v":0}]
[null,null,null,"Total Exempt Staff",null,null,null,null,null,{"$f":"SUM(J29:J31)","v":0},0,0,0,0,0,0]
[]
[null,null,"Post Doctoral Support",null,0,{"$f":"SUM(52*E34/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G34*(1+'Salary Inflation'!$B$33))*$E34,0)","v":0},{"$f":"ROUND(J34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(J34:K34)","v":0},{"$f":"ROUND(J34*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M34*'RATES-Non Fed'!G43,0)","v":0},{"$f":"SUM(M34:N34)","v":0},{"$f":"SUM(L34+O34)","v":0}]
[null,null,"Graduate Students",null,0,{"$f":"SUM(52*E35/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G35*(1+'Salary Inflation'!$B$33))*$E35,0)","v":0},{"$f":"ROUND(J35*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J35:K35)","v":0},{"$f":"ROUND(J35*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M35*'RATES-Non Fed'!G42,0)","v":0},{"$f":"SUM(M35:N35)","v":0},{"$f":"SUM(L35+O35)","v":0}]
[null,null,"Undergrad Students",null,0,{"$f":"SUM(52*E36/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G36*(1+'Salary Inflation'!$B$33))*$E36,0)","v":0},{"$f":"ROUND(J36*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J36:K36)","v":0},{"$f":"ROUND(J36*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M36*'RATES-Non Fed'!G42,0)","v":0},{"$f":"SUM(M36:N36)","v":0},{"$f":"SUM(L36+O36)","v":0}]
[null,null,"Part-time Faculty/Staff",null,0,{"$f":"SUM(52*E37/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G37*(1+'Salary Inflation'!$B$33))*$E37,0)","v":0},{"$f":"ROUND(J37*'RATES-Non Fed'!E43,0)","v":0},{"$f":"SUM(J37:K37)","v":0},{"$f":"ROUND(J37*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M37*'RATES-Non Fed'!G43,0)","v":0},{"$f":"SUM(M37:N37)","v":0},{"$f":"SUM(L37+O37)","v":0}]
[null,null,"Non-Exempt Staff (Bi-Weekly)",null,0,{"$f":"SUM(52*E38/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G38*(1+'Salary Inflation'!$B$33))*$E38,0)","v":0},{"$f":"ROUND(J38*'RATES-Non Fed'!E41,0)","v":0},{"$f":"SUM(J38:K38)","v":0},{"$f":"ROUND(J38*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M38*'RATES-Non Fed'!G41,0)","v":0},{"$f":"SUM(M38:N38)","v":0},{"$f":"SUM(L38+O38)","v":0}]
[null,null,null,"Sub Totals",null,null,null,null,null,{"$f":"SUM(J19+J25+J32+J34+J35+J36+J37+J38)","v":0},0,0,0,0,0,{"$f":"SUM(P34:P38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Total Salaries and Fringe Benefits : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J39+K39)","v":0},null,null,{"$f":"SUM(M39+N39)","v":0},null,null,{"$f":"SUM(J41+M41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["D."," Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J44*1.02),0)","v":0},null,null,{"$f":"SUM(J44:O44)","v":0}]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J45*1.02),0)","v":0},null,null,{"$f":"SUM(J45:O45)","v":0}]
[null,null,"Total Equipment : ",null,null,null,null,null,null,{"$f":"SUM(J44:J45)","v":0},null,null,{"$f":"SUM(M44:M45)","v":0},null,null,{"$f":"SUM(J46:O46)","v":0}]
[]
["E."," Travel",null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Domestic ","(list)",null,null,null,null,null,0,null,null,{"$f":"ROUND((J49*1.02),0)","v":0},null,null,{"$f":"SUM(J49:O49)","v":0}]
[null,null,"International ","(list)",null,null,null,null,null,0,null,null,{"$f":"ROUND((J50*1.02),0)","v":0},null,null,{"$f":"SUM(J50:O50)","v":0}]
[null,null,"Total Travel : ",null,null,null,null,null,null,{"$f":"SUM(J49:J50)","v":0},null,null,{"$f":"SUM(M49:M50)","v":0},null,null,{"$f":"SUM(J51:O51)","v":0}]
[]
["G."," Supplies and Other Direct Costs",null,null,null,null,null,null,null," ",null,null," "]
[null,null,"Materials & Supplies",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J54*1.02),0)","v":0},null,null,{"$f":"SUM(J54:O54)","v":0}]
[null,null,"Publication Costs",null,null,null,null,null,null,0,null,null,0,null,null,0]
[null,null,"Consultant Services",null,null,null,null,null,null,0,null,null,0,null,null,0]
[null,null,"Subject Incentives",null,null,null,null,null,null,0,null,null,0,null,null,0]
[null,null,"UC Tuition for Trainees/Fellows",null,null,null,null,null,null,0,null,null,0,null,null,0]
[null,null,"UC Tuition on Research Projects",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J59*1.02),0)","v":0},null,null,{"$f":"SUM(J59:O59)","v":0}]
[null,null,"Lab Expenses",null,null,null,null,null,null,0,null,null,0,null,null,0]
[null,null,"Other (Analytical Services/Instrument Use)",null,null,null,null,null,null,0,null,null,0,null,null,0]
[null,null,"Subcontracts       1)",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J62*1.02),0)","v":0},null,null,0]
[null,null,"2)",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J63*1.02),0)","v":0},null,null,0]
[null,null,"3)",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J64*1.02),0)","v":0},null,null,0]
[null,null,"4)",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J65*1.02),0)","v":0},null,null,0]
["Total Supplies and Other Direct Costs : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J54:J65)","v":0},null,null,{"$f":"SUM(M54:M65)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"TOTAL DIRECT COSTS: ",null,null,null,null,{"$f":"ROUND(+J66+J51+J46+J41,0)","v":0},null,null,{"$f":"ROUND(+M66+M51+M46+M41,0)","v":0},null,null,{"$f":"SUM(J68:O68)","v":0}]
[]
[null,null,null,null,null,null,null,"Facilities and Administrative Cost Base:",null,{"$f":"J68","v":0},null,null,{"$f":"M68","v":0},null,null,{"$f":"SUM(J70:O70)","v":0}]
["Facilities and Administrative Costs Calculation: "]
["F&A Cost (on MTDC): ",null,null,{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!E48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!E53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!E49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!E54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!E50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!E55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!G48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!G53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!G49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!G54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!G50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!G55),($E$80)))))))","v":0.62},null,null,null,null,{"$f":"+J70*D72","v":0},null,null,{"$f":"+M70*E72","v":0},null,null,{"$f":"SUM(J72:O72)","v":0}]
["Total F&A Cost : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J72:J72)","v":0},null,null,{"$f":"SUM(M72:M72)","v":0},null,null,{"$f":"SUM(J73:O73)","v":0}]
[]
[null,null,"Total  Cost",null,null,null,null,null,null,{"$f":"J73+J68","v":0},null,null,{"$f":"M73+M68","v":0},null,null,{"$f":"SUM(J75:O75)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"Facilities and Administrative Data"]
[null,null,"Purpose of Grant / Contract : ",null,"R",null,"(R = Research, I = Instruction, P = Public Service, S = Special Rate on Total Costs)"]
[null,null,"Special F&A Rate : ",null,0]
[null,null,"Campus Status :",null,"C",null,"(C = On Campus, O = Off Campus)"]
[]
[]
[null,null,null,"Detailed F&A figures for prorated rates",null,null,null,{"$f":"+'RATES-Non Fed'!E31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$C$48","v":0},null,{"$f":"+'RATES-Non Fed'!G31","v":0.62},{"$f":"M73/12*'RATES-Non Fed'!$C$48","v":0}]
[null,null,null,"*If both lines have the same rate, then just list as one line on forms.",null,null,null,{"$f":"+'RATES-Non Fed'!G31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$D$48","v":0},null,{"$f":"+'RATES-Non Fed'!I31","v":0.62},{"$f":"M73/12*'RATES-Non Fed'!$D$48","v":0},{"$f":"'RATES-Non Fed'!Q69","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J84:J85)","v":0},null,null,{"$f":"SUM(M84:M85)","v":0}]

{"sheet":"3 Year","index":3,"n_rows":85,"n_cols":19,"rows_kept":85,"cut":false,"hidden":false,"merged":[[83,3,84,6],[3,10,4,17],[7,9,7,11],[7,12,7,14],[7,15,7,17],[84,16,84,18]]}
["Grants / Contracts"]
["3 Year Budget "]
[" ",null,null,null,null,null,null,null,null," "]
["Sponsoring Agency : ",null,null,"name",null,null,null,null,null,"Titled : ","name"]
["Principal Investigator : ",null,null,"name"]
[null,"Period : ",null,{"$f":"'RATES-Non Fed'!E2","v":"2024-01-01"},"thru",null,{"$f":"'RATES-Non Fed'!G2","v":"1930-12-31"}]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,"Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"CUMULATIVE"]
["A."," Salaries",null,null,null,null,null,null,null,"Sal","FB","Total","Sal","FB","Total","Sal","FB","Total"]
[null,"Senior Personnel",null,"App't Type","% Effort","PM","Salary",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J10:N10)=0,\"\",SUM(J10:N10))","v":""}]
[null,"PI",null,"ACAD",0,{"$f":"IF(D11=\"CAL\",(52*E11/4.3333),(IF(D11=\"ACAD\",(36.35*E11/4.33333),IF(D11=\"SUMR\",(15.65*E11/4.33333),IF(D11=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"IF($D11=\"CAL\",ROUND(($G11*(1+'Salary Inflation'!$B$30))*$E11,0),IF($D11=\"ACAD\",($G11/0.9965)*(1+'Salary Inflation'!$B$31)*$E11,IF($D11=\"SUMR\",($G11)*(1+'Salary Inflation'!$B$32)*$E11,\"NA\")))","v":0},{"$f":"IF(D11=\"CAL\",ROUND(J11*'RATES-Non Fed'!$E$38,0),IF(D11=\"ACAD\",J11*'RATES-Non Fed'!$E$44,J11*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K11+J11,0)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((J11*(1+'Salary Inflation'!$C$30)),0),IF($D11=\"ACAD\",(J11)*(1+'Salary Inflation'!$C$31),IF($D11=\"SUMR\",(J11)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(M11*'RATES-Non Fed'!$G$38,0),IF($D11=\"ACAD\",M11*'RATES-Non Fed'!$G$44,M11*'RATES-Non Fed'!$G$45))","v":0},{"$f":"ROUND(M11+N11,0)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((M11*(1+'Salary Inflation'!$D$30)),0),IF($D11=\"ACAD\",(M11)*(1+'Salary Inflation'!$D$31),IF($D11=\"SUMR\",(M11)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(P11*'RATES-Non Fed'!$I$38,0),IF($D11=\"ACAD\",P11*'RATES-Non Fed'!$I$44,P11*'RATES-Non Fed'!$I$45))","v":0},{"$f":"SUM(P11:Q11)","v":0},{"$f":"SUM(L11+O11+R11)","v":0}]
[null,"PI",null,"SUMR",0,0,{"$f":"IF(D11=\"ACAD\",+G11*0.437,0)","v":0},null,null,{"$f":"IF($D12=\"CAL\",ROUND(($G12*(1+'Salary Inflation'!$B$30))*$E12,0),IF($D12=\"ACAD\",($G12/0.9965)*(1+'Salary Inflation'!$B$31)*$E12,IF($D12=\"SUMR\",($G12)*(1+'Salary Inflation'!$B$32)*$E12,\"NA\")))","v":0},{"$f":"IF(D12=\"CAL\",ROUND(J12*'RATES-Non Fed'!$E$38,0),IF(D12=\"ACAD\",J12*'RATES-Non Fed'!$E$44,J12*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K12+J12,0)","v":0},{"$f":"IF($D12=\"CAL\",ROUND((J12*(1+'Salary Inflation'!$C$30)),0),IF($D12=\"ACAD\",(J12)*(1+'Salary Inflation'!$C$31),IF($D12=\"SUMR\",(J12)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(M12*'RATES-Non Fed'!$G$38,0),IF($D12=\"ACAD\",M12*'RATES-Non Fed'!$G$44,M12*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D12=\"CAL\",ROUND((M12*(1+'Salary Inflation'!$D$30)),0),IF($D12=\"ACAD\",(M12)*(1+'Salary Inflation'!$D$31),IF($D12=\"SUMR\",(M12)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(P12*'RATES-Non Fed'!$I$38,0),IF($D12=\"ACAD\",P12*'RATES-Non Fed'!$I$44,P12*'RATES-Non Fed'!$I$45))","v":0},{"$f":"SUM(P12:Q12)","v":0},{"$f":"SUM(L12+O12+R12)","v":0}]
[null,"Co",null,"ACAD",0,0,0,null,null,{"$f":"IF($D13=\"CAL\",ROUND(($G13*(1+'Salary Inflation'!$B$30))*$E13,0),IF($D13=\"ACAD\",($G13/0.9965)*(1+'Salary Inflation'!$B$31)*$E13,IF($D13=\"SUMR\",($G13)*(1+'Salary Inflation'!$B$32)*$E13,\"NA\")))","v":0},{"$f":"IF(D13=\"CAL\",ROUND(J13*'RATES-Non Fed'!$E$38,0),IF(D13=\"ACAD\",J13*'RATES-Non Fed'!$E$44,J13*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((J13*(1+'Salary Inflation'!$C$30)),0),IF($D13=\"ACAD\",(J13)*(1+'Salary Inflation'!$C$31),IF($D13=\"SUMR\",(J13)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(M13*'RATES-Non Fed'!$G$38,0),IF($D13=\"ACAD\",M13*'RATES-Non Fed'!$G$44,M13*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((M13*(1+'Salary Inflation'!$D$30)),0),IF($D13=\"ACAD\",(M13)*(1+'Salary Inflation'!$D$31),IF($D13=\"SUMR\",(M13)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(P13*'RATES-Non Fed'!$I$38,0),IF($D13=\"ACAD\",P13*'RATES-Non Fed'!$I$44,P13*'RATES-Non Fed'!$I$45))","v":0},0,0]
[null,null,null,{"$f":"IF(D13=\"ACAD\",(\"SUMR\"),\"\")","v":"SUMR"},0,0,{"$f":"IF(D13=\"ACAD\",+G13*0.437,0)","v":0},null,null,{"$f":"IF($D14=\"CAL\",ROUND(($G14*(1+'Salary Inflation'!$B$30))*$E14,0),IF($D14=\"ACAD\",($G14/0.9965)*(1+'Salary Inflation'!$B$31)*$E14,IF($D14=\"SUMR\",($G14)*(1+'Salary Inflation'!$B$32)*$E14,\"NA\")))","v":0},{"$f":"IF(D14=\"CAL\",ROUND(J14*'RATES-Non Fed'!$E$38,0),IF(D14=\"ACAD\",J14*'RATES-Non Fed'!$E$44,J14*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((J14*(1+'Salary Inflation'!$C$30)),0),IF($D14=\"ACAD\",(J14)*(1+'Salary Inflation'!$C$31),IF($D14=\"SUMR\",(J14)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(M14*'RATES-Non Fed'!$G$38,0),IF($D14=\"ACAD\",M14*'RATES-Non Fed'!$G$44,M14*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((M14*(1+'Salary Inflation'!$D$30)),0),IF($D14=\"ACAD\",(M14)*(1+'Salary Inflation'!$D$31),IF($D14=\"SUMR\",(M14)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(P14*'RATES-Non Fed'!$I$38,0),IF($D14=\"ACAD\",P14*'RATES-Non Fed'!$I$44,P14*'RATES-Non Fed'!$I$45))","v":0},0,0]
[null,"Co",null,"ACAD",0,0,0,null,null,{"$f":"IF($D15=\"CAL\",ROUND(($G15*(1+'Salary Inflation'!$B$30))*$E15,0),IF($D15=\"ACAD\",($G15/0.9965)*(1+'Salary Inflation'!$B$31)*$E15,IF($D15=\"SUMR\",($G15)*(1+'Salary Inflation'!$B$32)*$E15,\"NA\")))","v":0},{"$f":"IF(D15=\"CAL\",ROUND(J15*'RATES-Non Fed'!$E$38,0),IF(D15=\"ACAD\",J15*'RATES-Non Fed'!$E$44,J15*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((J15*(1+'Salary Inflation'!$C$30)),0),IF($D15=\"ACAD\",(J15)*(1+'Salary Inflation'!$C$31),IF($D15=\"SUMR\",(J15)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(M15*'RATES-Non Fed'!$G$38,0),IF($D15=\"ACAD\",M15*'RATES-Non Fed'!$G$44,M15*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((M15*(1+'Salary Inflation'!$D$30)),0),IF($D15=\"ACAD\",(M15)*(1+'Salary Inflation'!$D$31),IF($D15=\"SUMR\",(M15)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(P15*'RATES-Non Fed'!$I$38,0),IF($D15=\"ACAD\",P15*'RATES-Non Fed'!$I$44,P15*'RATES-Non Fed'!$I$45))","v":0},0,0]
[null,null,null,{"$f":"IF(D15=\"ACAD\",(\"SUMR\"),\"\")","v":"SUMR"},0,0,{"$f":"IF(D15=\"ACAD\",+G15*0.428,0)","v":0},null,null,{"$f":"IF($D16=\"CAL\",ROUND(($G16*(1+'Salary Inflation'!$B$30))*$E16,0),IF($D16=\"ACAD\",($G16/0.9965)*(1+'Salary Inflation'!$B$31)*$E16,IF($D16=\"SUMR\",($G16)*(1+'Salary Inflation'!$B$32)*$E16,\"NA\")))","v":0},{"$f":"IF(D16=\"CAL\",ROUND(J16*'RATES-Non Fed'!$E$38,0),IF(D16=\"ACAD\",J16*'RATES-Non Fed'!$E$44,J16*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((J16*(1+'Salary Inflation'!$C$30)),0),IF($D16=\"ACAD\",(J16)*(1+'Salary Inflation'!$C$31),IF($D16=\"SUMR\",(J16)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(M16*'RATES-Non Fed'!$G$38,0),IF($D16=\"ACAD\",M16*'RATES-Non Fed'!$G$44,M16*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((M16*(1+'Salary Inflation'!$D$30)),0),IF($D16=\"ACAD\",(M16)*(1+'Salary Inflation'!$D$31),IF($D16=\"SUMR\",(M16)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(P16*'RATES-Non Fed'!$I$38,0),IF($D16=\"ACAD\",P16*'RATES-Non Fed'!$I$44,P16*'RATES-Non Fed'!$I$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D17=\"CAL\",ROUND(($G17*(1+'Salary Inflation'!$B$30))*$E17,0),IF($D17=\"ACAD\",($G17/0.9965)*(1+'Salary Inflation'!$B$31)*$E17,IF($D17=\"SUMR\",($G17)*(1+'Salary Inflation'!$B$32)*$E17,\"NA\")))","v":0},{"$f":"IF(D17=\"CAL\",ROUND(J17*'RATES-Non Fed'!$E$38,0),IF(D17=\"ACAD\",J17*'RATES-Non Fed'!$E$44,J17*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((J17*(1+'Salary Inflation'!$C$30)),0),IF($D17=\"ACAD\",(J17)*(1+'Salary Inflation'!$C$31),IF($D17=\"SUMR\",(J17)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(M17*'RATES-Non Fed'!$G$38,0),IF($D17=\"ACAD\",M17*'RATES-Non Fed'!$G$44,M17*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((M17*(1+'Salary Inflation'!$D$30)),0),IF($D17=\"ACAD\",(M17)*(1+'Salary Inflation'!$D$31),IF($D17=\"SUMR\",(M17)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(P17*'RATES-Non Fed'!$I$38,0),IF($D17=\"ACAD\",P17*'RATES-Non Fed'!$I$44,P17*'RATES-Non Fed'!$I$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D18=\"CAL\",ROUND(($G18*(1+'Salary Inflation'!$B$30))*$E18,0),IF($D18=\"ACAD\",($G18/0.9965)*(1+'Salary Inflation'!$B$31)*$E18,IF($D18=\"SUMR\",($G18)*(1+'Salary Inflation'!$B$32)*$E18,\"NA\")))","v":0},{"$f":"IF(D18=\"CAL\",ROUND(J18*'RATES-Non Fed'!$E$38,0),IF(D18=\"ACAD\",J18*'RATES-Non Fed'!$E$44,J18*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((J18*(1+'Salary Inflation'!$C$30)),0),IF($D18=\"ACAD\",(J18)*(1+'Salary Inflation'!$C$31),IF($D18=\"SUMR\",(J18)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(M18*'RATES-Non Fed'!$G$38,0),IF($D18=\"ACAD\",M18*'RATES-Non Fed'!$G$44,M18*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((M18*(1+'Salary Inflation'!$D$30)),0),IF($D18=\"ACAD\",(M18)*(1+'Salary Inflation'!$D$31),IF($D18=\"SUMR\",(M18)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(P18*'RATES-Non Fed'!$I$38,0),IF($D18=\"ACAD\",P18*'RATES-Non Fed'!$I$44,P18*'RATES-Non Fed'!$I$45))","v":0},0,0]
[null,null,null,"AAUP Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J11:J18)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(S11:S18)","v":0}]
["B","Dual Compensation Faculty"]
[null,"Co",null,"CAL",0,{"$f":"IF(D21=\"CAL\",(52*E21/4.3333),(IF(D21=\"ACAD\",(32*E21/4.33333),IF(D21=\"SUMR\",(14*E21/4.33333),IF(D21=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G21*(1+'Salary Inflation'!$B$34))*$E21,0)","v":0},{"$f":"ROUND(J21*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K21+J21,0)","v":0},{"$f":"ROUND(J21*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M21*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M21+N21,0)","v":0},{"$f":"ROUND(M21*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(P21*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P21+Q21,0)","v":0},{"$f":"SUM(L21+O21+R21)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D22=\"CAL\",(52*E22/4.3333),(IF(D22=\"ACAD\",(32*E22/4.33333),IF(D22=\"SUMR\",(14*E22/4.33333),IF(D22=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G22*(1+'Salary Inflation'!$B$34))*$E22,0)","v":0},{"$f":"ROUND(J22*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K22+J22,0)","v":0},{"$f":"ROUND(J22*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M22*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M22+N22,0)","v":0},{"$f":"ROUND(M22*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(P22*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P22+Q22,0)","v":0},{"$f":"SUM(L22+O22+R22)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D23=\"CAL\",(52*E23/4.3333),(IF(D23=\"ACAD\",(32*E23/4.33333),IF(D23=\"SUMR\",(14*E23/4.33333),IF(D23=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G23*(1+'Salary Inflation'!$B$34))*$E23,0)","v":0},{"$f":"ROUND(J23*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K23+J23,0)","v":0},{"$f":"ROUND(J23*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M23*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M23+N23,0)","v":0},{"$f":"ROUND(M23*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(P23*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P23+Q23,0)","v":0},{"$f":"SUM(L23+O23+R23)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D24=\"CAL\",(52*E24/4.3333),(IF(D24=\"ACAD\",(32*E24/4.33333),IF(D24=\"SUMR\",(14*E24/4.33333),IF(D24=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G24*(1+'Salary Inflation'!$B$34))*$E24,0)","v":0},{"$f":"ROUND(J24*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K24+J24,0)","v":0},{"$f":"ROUND(J24*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M24*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M24+N24,0)","v":0},{"$f":"ROUND(M24*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(P24*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P24+Q24,0)","v":0},{"$f":"SUM(L24+O24+R24)","v":0}]
[null,null,null,"Dual Comp Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J21:J24)","v":0},0,0,0,0,0,0,0,0,0]
[]
["C."," Other Personnel"]
[null,null,"Exempt Staff (Monthly)","Name"]
[null,null,null,null,0,{"$f":"SUM(52*E29/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G29*(1+'Salary Inflation'!$B$33))*$E29,0)","v":0},{"$f":"ROUND(J29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J29:K29)","v":0},{"$f":"ROUND(J29*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(M29:N29)","v":0},{"$f":"ROUND(M29*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P29*'RATES-Non Fed'!I39,0)","v":0},{"$f":"SUM(P29:Q29)","v":0},{"$f":"SUM(L29+O29+R29)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E30/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G30*(1+'Salary Inflation'!$B$33))*$E30,0)","v":0},{"$f":"ROUND(J30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J30:K30)","v":0},{"$f":"ROUND(J30*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(M30:N30)","v":0},{"$f":"ROUND(M30*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P30*'RATES-Non Fed'!I39,0)","v":0},{"$f":"SUM(P30:Q30)","v":0},{"$f":"SUM(L30+O30+R30)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E31/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G31*(1+'Salary Inflation'!$B$33))*$E31,0)","v":0},{"$f":"ROUND(J31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J31:K31)","v":0},{"$f":"ROUND(J31*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(M31:N31)","v":0},{"$f":"ROUND(M31*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P31*'RATES-Non Fed'!I39,0)","v":0},{"$f":"SUM(P31:Q31)","v":0},{"$f":"SUM(L31+O31+R31)","v":0}]
[null,null,null,"Total Exempt Staff",null,null,null,null,null,{"$f":"SUM(J29:J31)","v":0},0,0,0,0,0,0,{"$f":"SUM(Q29:Q31)","v":0},{"$f":"SUM(R29:R31)","v":0},{"$f":"SUM(S29:S31)","v":0}]
[]
[null,null,"Post Doctoral Support",null,0,{"$f":"SUM(52*E34/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G34*(1+'Salary Inflation'!$B$33))*$E34,0)","v":0},{"$f":"ROUND(J34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(J34:K34)","v":0},{"$f":"ROUND(J34*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(M34:N34)","v":0},{"$f":"ROUND(M34*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P34*'RATES-Non Fed'!I43,0)","v":0},{"$f":"SUM(P34:Q34)","v":0},{"$f":"SUM(L34+O34+R34)","v":0}]
[null,null,"Graduate Students",null,0,{"$f":"SUM(52*E35/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G35*(1+'Salary Inflation'!$B$33))*$E35,0)","v":0},{"$f":"ROUND(J35*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J35:K35)","v":0},{"$f":"ROUND(J35*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M35*'RATES-Non Fed'!H42,0)","v":0},{"$f":"SUM(M35:N35)","v":0},{"$f":"ROUND(M35*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P35*'RATES-Non Fed'!I42,0)","v":0},{"$f":"SUM(P35:Q35)","v":0},{"$f":"SUM(L35+O35+R35)","v":0}]
[null,null,"Undergrad Students",null,0,{"$f":"SUM(52*E36/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G36*(1+'Salary Inflation'!$B$33))*$E36,0)","v":0},{"$f":"ROUND(J36*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J36:K36)","v":0},{"$f":"ROUND(J36*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M36*'RATES-Non Fed'!H42,0)","v":0},{"$f":"SUM(M36:N36)","v":0},{"$f":"ROUND(M36*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P36*'RATES-Non Fed'!I42,0)","v":0},{"$f":"SUM(P36:Q36)","v":0},{"$f":"SUM(L36+O36+R36)","v":0}]
[null,null,"Part-time Faculty/Staff",null,0,{"$f":"SUM(52*E37/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G37*(1+'Salary Inflation'!$B$33))*$E37,0)","v":0},{"$f":"ROUND(J37*'RATES-Non Fed'!E43,0)","v":0},{"$f":"SUM(J37:K37)","v":0},{"$f":"ROUND(J37*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M37*'RATES-Non Fed'!H43,0)","v":0},{"$f":"SUM(M37:N37)","v":0},{"$f":"ROUND(M37*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P37*'RATES-Non Fed'!I43,0)","v":0},{"$f":"SUM(P37:Q37)","v":0},{"$f":"SUM(L37+O37+R37)","v":0}]
[null,null,"Non-Exempt Staff (Bi-Weekly)",null,0,{"$f":"SUM(52*E38/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G38*(1+'Salary Inflation'!$B$33))*$E38,0)","v":0},{"$f":"ROUND(J38*'RATES-Non Fed'!E41,0)","v":0},{"$f":"SUM(J38:K38)","v":0},{"$f":"ROUND(J38*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M38*'RATES-Non Fed'!H41,0)","v":0},{"$f":"SUM(M38:N38)","v":0},{"$f":"ROUND(M38*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P38*'RATES-Non Fed'!I41,0)","v":0},{"$f":"SUM(P38:Q38)","v":0},{"$f":"SUM(L38+O38+R38)","v":0}]
[null,null,null,"Sub Totals",null,null,null,null,null,{"$f":"SUM(J19+J25+J32+J34+J35+J36+J37+J38)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(S34:S38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Total Salaries and Fringe Benefits : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J39+K39)","v":0},null,null,{"$f":"SUM(M39+N39)","v":0},null,null,{"$f":"SUM(P39+Q39)","v":0},null,null,{"$f":"SUM(J41+M41+P41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["D."," Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,{"$f":"SUM(J44:R44)","v":0}]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,{"$f":"SUM(J45:R45)","v":0}]
[null,null,"Total Equipment : ",null,null,null,null,null,null,{"$f":"SUM(J44:J45)","v":0},null,null,{"$f":"SUM(M44:M45)","v":0},null,null,{"$f":"SUM(P44:P45)","v":0},null,null,{"$f":"SUM(J46:R46)","v":0}]
[]
["E."," Travel",null,null,null,null,null,null,null," ",null,null," ",null,null," "]
[null,null,"Domestic ","(list)",null,null,null,null,null,0,null,null,{"$f":"ROUND((J49*1.02),0)","v":0},null,null,{"$f":"ROUND((M49*1.02),0)","v":0},null,null,{"$f":"SUM(J49:R49)","v":0}]
[null,null,"International ","(list)",null,null,null,null,null,0,null,null,{"$f":"ROUND((J50*1.02),0)","v":0},null,null,{"$f":"ROUND((M50*1.02),0)","v":0},null,null,{"$f":"SUM(J50:R50)","v":0}]
[null,null,"Total Travel : ",null,null,null,null,null,null,{"$f":"SUM(J49:J50)","v":0},null,null,{"$f":"SUM(M49:M50)","v":0},null,null,{"$f":"SUM(P49:P50)","v":0},null,null,{"$f":"SUM(J51:R51)","v":0}]
[]
["G."," Supplies and Other Direct Costs",null,null,null,null,null,null,null," ",null,null," ",null,null," "]
[null,null,"Materials & Supplies",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J54*1.02),0)","v":0},null,null,{"$f":"ROUND((M54*1.02),0)","v":0},null,null,{"$f":"SUM(J54:R54)","v":0}]
[null,null,"Publication Costs",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J55*1.02),0)","v":0},null,null,{"$f":"ROUND((M55*1.02),0)","v":0},null,null,0]
[null,null,"Consultant Services",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Subject Incentives",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"UC Tuition for Trainees/Fellows",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"UC Tuition on Research Projects",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J59*1.02),0)","v":0},null,null,{"$f":"ROUND((M59*1.02),0)","v":0},null,null,{"$f":"SUM(J59:R59)","v":0}]
[null,null,"Lab Expenses",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Other (Analytical Services/Instrument Use)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Subcontracts       1)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"2)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"3)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"4)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0]
["Total Supplies and Other Direct Costs : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J54:J65)","v":0},null,null,{"$f":"SUM(M54:M65)","v":0},null,null,{"$f":"SUM(P54:P65)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"TOTAL DIRECT COSTS: ",null,null,null,null,{"$f":"ROUND(+J66+J51+J46+J41,0)","v":0},null,null,{"$f":"ROUND(+M66+M51+M46+M41,0)","v":0},null,null,{"$f":"ROUND(+P66+P51+P46+P41,0)","v":0},null,null,{"$f":"SUM(J68:R68)","v":0}]
[]
[null,null,null,null,null,null,null,"Facilities and Administrative Cost Base:",null,{"$f":"J68","v":0},null,null,{"$f":"M68","v":0},null,null,{"$f":"P68","v":0},null,null,{"$f":"SUM(J70:R70)","v":0}]
["Facilities and Administrative Costs Calculation: "]
["F&A Cost (on MTDC): ",null,null,{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!E48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!E53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!E49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!E54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!E50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!E55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!G48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!G53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!G49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!G54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!G50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!G55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!I48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!I53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!I49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!I54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!I50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!I55),($E$80)))))))","v":0.62},null,null,null,{"$f":"+J70*D72","v":0},null,null,{"$f":"+M70*E72","v":0},null,null,{"$f":"+P70*F72","v":0},null,null,{"$f":"SUM(J72:R72)","v":0}]
["Total F&A Cost : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J72:J72)","v":0},null,null,{"$f":"SUM(M72:M72)","v":0},null,null,{"$f":"SUM(P72:P72)","v":0},null,null,{"$f":"SUM(J73:R73)","v":0}]
[]
[null,null,"Total  Cost",null,null,null,null,null,null,{"$f":"J73+J68","v":0},null,null,{"$f":"M73+M68","v":0},null,null,{"$f":"P73+P68","v":0},null,null,{"$f":"SUM(J75:R75)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"Facilities and Administrative Data"]
[null,null,"Purpose of Grant / Contract : ",null,"R",null,"(R = Research, I = Instruction, P = Public Service, S = Special Rate on Total Costs)"]
[null,null,"Special F&A Rate : ",null,0.1]
[null,null,"Campus Status :",null,"C",null,"(C = On Campus, O = Off Campus)"]
[]
[null,null,null,"Detailed F&A figures for prorated rates",null,null,null,{"$f":"+'RATES-Non Fed'!E31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$C$48","v":0},null,{"$f":"+'RATES-Non Fed'!G31","v":0.62},{"$f":"M73/12*'RATES-Non Fed'!$C$48","v":0},null,{"$f":"+'RATES-Non Fed'!I31","v":0.62},{"$f":"P73/12*'RATES-Non Fed'!$C$48","v":0}]
[null,null,null,"*If both lines have the same rate, then just list as one line on forms.",null,null,null,{"$f":"+'RATES-Non Fed'!G31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$D$48","v":0},null,{"$f":"+'RATES-Non Fed'!I31","v":0.62},{"$f":"M73/12*'RATES-Non Fed'!$D$48","v":0},null,{"$f":"+'RATES-Non Fed'!K31","v":0.62},{"$f":"P73/12*'RATES-Non Fed'!$D$48","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J83:J84)","v":0},null,null,{"$f":"SUM(M83:M84)","v":0},null,null,{"$f":"SUM(P83:P84)","v":0},{"$f":"'RATES-Non Fed'!Q69","v":0}]

{"sheet":"4 Year","index":4,"n_rows":85,"n_cols":22,"rows_kept":85,"cut":false,"hidden":false,"merged":[[83,3,84,6],[3,10,4,20],[7,9,7,11],[7,12,7,14],[7,15,7,17],[7,18,7,20],[84,20,84,22]]}
["Grants / Contracts"]
["4 Year Budget "]
[" ",null,null,null,null,null,null,null,null," "]
["Sponsoring Agency : ",null,null,"name",null,null,null,null,null,"Titled : ","name"]
["Principal Investigator : ",null,null,"name"]
[null,"Period : ",null,{"$f":"'RATES-Non Fed'!E2","v":"2024-01-01"},"thru",null,{"$f":"'RATES-Non Fed'!G2","v":"1930-12-31"}]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,"Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"CUMULATIVE"]
["A."," Salaries",null,null,null,null,null,null,null,"Sal","FB","Total","Sal","FB","Total","Sal","FB","Total","Sal","FB","Total"]
[null,"Senior Personnel",null,"App't Type","% Effort","PM","Salary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J10:N10)=0,\"\",SUM(J10:N10))","v":""}]
[null,"PI",null,"ACAD",0,{"$f":"IF(D11=\"CAL\",(52*E11/4.3333),(IF(D11=\"ACAD\",(36.35*E11/4.33333),IF(D11=\"SUMR\",(15.65*E11/4.33333),IF(D11=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"IF($D11=\"CAL\",ROUND(($G11*(1+'Salary Inflation'!$B$30))*$E11,0),IF($D11=\"ACAD\",($G11/0.9965)*(1+'Salary Inflation'!$B$31)*$E11,IF($D11=\"SUMR\",($G11)*(1+'Salary Inflation'!$B$32)*$E11,\"NA\")))","v":0},{"$f":"IF(D11=\"CAL\",ROUND(J11*'RATES-Non Fed'!$E$38,0),IF(D11=\"ACAD\",J11*'RATES-Non Fed'!$E$44,J11*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K11+J11,0)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((J11*(1+'Salary Inflation'!$C$30)),0),IF($D11=\"ACAD\",(J11)*(1+'Salary Inflation'!$C$31),IF($D11=\"SUMR\",(J11)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(M11*'RATES-Non Fed'!$G$38,0),IF($D11=\"ACAD\",M11*'RATES-Non Fed'!$G$44,M11*'RATES-Non Fed'!$G$45))","v":0},{"$f":"ROUND(M11+N11,0)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((M11*(1+'Salary Inflation'!$D$30)),0),IF($D11=\"ACAD\",(M11)*(1+'Salary Inflation'!$D$31),IF($D11=\"SUMR\",(M11)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(P11*'RATES-Non Fed'!$I$38,0),IF($D11=\"ACAD\",P11*'RATES-Non Fed'!$I$44,P11*'RATES-Non Fed'!$I$45))","v":0},{"$f":"SUM(P11:Q11)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((P11*(1+'Salary Inflation'!$E$30)),0),IF($D11=\"ACAD\",(P11)*(1+'Salary Inflation'!$E$31),IF($D11=\"SUMR\",(P11)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(S11*'RATES-Non Fed'!$K$38,0),IF($D11=\"ACAD\",S11*'RATES-Non Fed'!$K$44,S11*'RATES-Non Fed'!$K$45))","v":0},{"$f":"SUM(S11:T11)","v":0},{"$f":"SUM(L11+O11+R11+U11)","v":0}]
[null,"PI",null,"SUMR",0,0,{"$f":"IF(D11=\"ACAD\",+G11*0.437,0)","v":0},null,null,{"$f":"IF($D12=\"CAL\",ROUND(($G12*(1+'Salary Inflation'!$B$30))*$E12,0),IF($D12=\"ACAD\",($G12/0.9965)*(1+'Salary Inflation'!$B$31)*$E12,IF($D12=\"SUMR\",($G12)*(1+'Salary Inflation'!$B$32)*$E12,\"NA\")))","v":0},{"$f":"IF(D12=\"CAL\",ROUND(J12*'RATES-Non Fed'!$E$38,0),IF(D12=\"ACAD\",J12*'RATES-Non Fed'!$E$44,J12*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K12+J12,0)","v":0},{"$f":"IF($D12=\"CAL\",ROUND((J12*(1+'Salary Inflation'!$C$30)),0),IF($D12=\"ACAD\",(J12)*(1+'Salary Inflation'!$C$31),IF($D12=\"SUMR\",(J12)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(M12*'RATES-Non Fed'!$G$38,0),IF($D12=\"ACAD\",M12*'RATES-Non Fed'!$G$44,M12*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D12=\"CAL\",ROUND((M12*(1+'Salary Inflation'!$D$30)),0),IF($D12=\"ACAD\",(M12)*(1+'Salary Inflation'!$D$31),IF($D12=\"SUMR\",(M12)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(P12*'RATES-Non Fed'!$I$38,0),IF($D12=\"ACAD\",P12*'RATES-Non Fed'!$I$44,P12*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D12=\"CAL\",ROUND((P12*(1+'Salary Inflation'!$E$30)),0),IF($D12=\"ACAD\",(P12)*(1+'Salary Inflation'!$E$31),IF($D12=\"SUMR\",(P12)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(S12*'RATES-Non Fed'!$K$38,0),IF($D12=\"ACAD\",S12*'RATES-Non Fed'!$K$44,S12*'RATES-Non Fed'!$K$45))","v":0},{"$f":"SUM(S12:T12)","v":0},{"$f":"SUM(L12+O12+R12+U12)","v":0}]
[null,"Co",null,"ACAD",0,0,0,null,null,{"$f":"IF($D13=\"CAL\",ROUND(($G13*(1+'Salary Inflation'!$B$30))*$E13,0),IF($D13=\"ACAD\",($G13/0.9965)*(1+'Salary Inflation'!$B$31)*$E13,IF($D13=\"SUMR\",($G13)*(1+'Salary Inflation'!$B$32)*$E13,\"NA\")))","v":0},{"$f":"IF(D13=\"CAL\",ROUND(J13*'RATES-Non Fed'!$E$38,0),IF(D13=\"ACAD\",J13*'RATES-Non Fed'!$E$44,J13*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((J13*(1+'Salary Inflation'!$C$30)),0),IF($D13=\"ACAD\",(J13)*(1+'Salary Inflation'!$C$31),IF($D13=\"SUMR\",(J13)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(M13*'RATES-Non Fed'!$G$38,0),IF($D13=\"ACAD\",M13*'RATES-Non Fed'!$G$44,M13*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((M13*(1+'Salary Inflation'!$D$30)),0),IF($D13=\"ACAD\",(M13)*(1+'Salary Inflation'!$D$31),IF($D13=\"SUMR\",(M13)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(P13*'RATES-Non Fed'!$I$38,0),IF($D13=\"ACAD\",P13*'RATES-Non Fed'!$I$44,P13*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((P13*(1+'Salary Inflation'!$E$30)),0),IF($D13=\"ACAD\",(P13)*(1+'Salary Inflation'!$E$31),IF($D13=\"SUMR\",(P13)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(S13*'RATES-Non Fed'!$K$38,0),IF($D13=\"ACAD\",S13*'RATES-Non Fed'!$K$44,S13*'RATES-Non Fed'!$K$45))","v":0},0,0]
[null,null,null,{"$f":"IF(D13=\"ACAD\",(\"SUMR\"),\"\")","v":"SUMR"},0,0,{"$f":"IF(D13=\"ACAD\",+G13*0.437,0)","v":0},null,null,{"$f":"IF($D14=\"CAL\",ROUND(($G14*(1+'Salary Inflation'!$B$30))*$E14,0),IF($D14=\"ACAD\",($G14/0.9965)*(1+'Salary Inflation'!$B$31)*$E14,IF($D14=\"SUMR\",($G14)*(1+'Salary Inflation'!$B$32)*$E14,\"NA\")))","v":0},{"$f":"IF(D14=\"CAL\",ROUND(J14*'RATES-Non Fed'!$E$38,0),IF(D14=\"ACAD\",J14*'RATES-Non Fed'!$E$44,J14*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((J14*(1+'Salary Inflation'!$C$30)),0),IF($D14=\"ACAD\",(J14)*(1+'Salary Inflation'!$C$31),IF($D14=\"SUMR\",(J14)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(M14*'RATES-Non Fed'!$G$38,0),IF($D14=\"ACAD\",M14*'RATES-Non Fed'!$G$44,M14*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((M14*(1+'Salary Inflation'!$D$30)),0),IF($D14=\"ACAD\",(M14)*(1+'Salary Inflation'!$D$31),IF($D14=\"SUMR\",(M14)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(P14*'RATES-Non Fed'!$I$38,0),IF($D14=\"ACAD\",P14*'RATES-Non Fed'!$I$44,P14*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((P14*(1+'Salary Inflation'!$E$30)),0),IF($D14=\"ACAD\",(P14)*(1+'Salary Inflation'!$E$31),IF($D14=\"SUMR\",(P14)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(S14*'RATES-Non Fed'!$K$38,0),IF($D14=\"ACAD\",S14*'RATES-Non Fed'!$K$44,S14*'RATES-Non Fed'!$K$45))","v":0},0,0]
[null,"Co",null,"ACAD",0,0,0,null,null,{"$f":"IF($D15=\"CAL\",ROUND(($G15*(1+'Salary Inflation'!$B$30))*$E15,0),IF($D15=\"ACAD\",($G15/0.9965)*(1+'Salary Inflation'!$B$31)*$E15,IF($D15=\"SUMR\",($G15)*(1+'Salary Inflation'!$B$32)*$E15,\"NA\")))","v":0},{"$f":"IF(D15=\"CAL\",ROUND(J15*'RATES-Non Fed'!$E$38,0),IF(D15=\"ACAD\",J15*'RATES-Non Fed'!$E$44,J15*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((J15*(1+'Salary Inflation'!$C$30)),0),IF($D15=\"ACAD\",(J15)*(1+'Salary Inflation'!$C$31),IF($D15=\"SUMR\",(J15)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(M15*'RATES-Non Fed'!$G$38,0),IF($D15=\"ACAD\",M15*'RATES-Non Fed'!$G$44,M15*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((M15*(1+'Salary Inflation'!$D$30)),0),IF($D15=\"ACAD\",(M15)*(1+'Salary Inflation'!$D$31),IF($D15=\"SUMR\",(M15)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(P15*'RATES-Non Fed'!$I$38,0),IF($D15=\"ACAD\",P15*'RATES-Non Fed'!$I$44,P15*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((P15*(1+'Salary Inflation'!$E$30)),0),IF($D15=\"ACAD\",(P15)*(1+'Salary Inflation'!$E$31),IF($D15=\"SUMR\",(P15)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(S15*'RATES-Non Fed'!$K$38,0),IF($D15=\"ACAD\",S15*'RATES-Non Fed'!$K$44,S15*'RATES-Non Fed'!$K$45))","v":0},0,0]
[null,null,null,{"$f":"IF(D15=\"ACAD\",(\"SUMR\"),\"\")","v":"SUMR"},0,0,{"$f":"IF(D15=\"ACAD\",+G15*0.428,0)","v":0},null,null,{"$f":"IF($D16=\"CAL\",ROUND(($G16*(1+'Salary Inflation'!$B$30))*$E16,0),IF($D16=\"ACAD\",($G16/0.9965)*(1+'Salary Inflation'!$B$31)*$E16,IF($D16=\"SUMR\",($G16)*(1+'Salary Inflation'!$B$32)*$E16,\"NA\")))","v":0},{"$f":"IF(D16=\"CAL\",ROUND(J16*'RATES-Non Fed'!$E$38,0),IF(D16=\"ACAD\",J16*'RATES-Non Fed'!$E$44,J16*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((J16*(1+'Salary Inflation'!$C$30)),0),IF($D16=\"ACAD\",(J16)*(1+'Salary Inflation'!$C$31),IF($D16=\"SUMR\",(J16)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(M16*'RATES-Non Fed'!$G$38,0),IF($D16=\"ACAD\",M16*'RATES-Non Fed'!$G$44,M16*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((M16*(1+'Salary Inflation'!$D$30)),0),IF($D16=\"ACAD\",(M16)*(1+'Salary Inflation'!$D$31),IF($D16=\"SUMR\",(M16)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(P16*'RATES-Non Fed'!$I$38,0),IF($D16=\"ACAD\",P16*'RATES-Non Fed'!$I$44,P16*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((P16*(1+'Salary Inflation'!$E$30)),0),IF($D16=\"ACAD\",(P16)*(1+'Salary Inflation'!$E$31),IF($D16=\"SUMR\",(P16)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(S16*'RATES-Non Fed'!$K$38,0),IF($D16=\"ACAD\",S16*'RATES-Non Fed'!$K$44,S16*'RATES-Non Fed'!$K$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D17=\"CAL\",ROUND(($G17*(1+'Salary Inflation'!$B$30))*$E17,0),IF($D17=\"ACAD\",($G17/0.9965)*(1+'Salary Inflation'!$B$31)*$E17,IF($D17=\"SUMR\",($G17)*(1+'Salary Inflation'!$B$32)*$E17,\"NA\")))","v":0},{"$f":"IF(D17=\"CAL\",ROUND(J17*'RATES-Non Fed'!$E$38,0),IF(D17=\"ACAD\",J17*'RATES-Non Fed'!$E$44,J17*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((J17*(1+'Salary Inflation'!$C$30)),0),IF($D17=\"ACAD\",(J17)*(1+'Salary Inflation'!$C$31),IF($D17=\"SUMR\",(J17)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(M17*'RATES-Non Fed'!$G$38,0),IF($D17=\"ACAD\",M17*'RATES-Non Fed'!$G$44,M17*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((M17*(1+'Salary Inflation'!$D$30)),0),IF($D17=\"ACAD\",(M17)*(1+'Salary Inflation'!$D$31),IF($D17=\"SUMR\",(M17)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(P17*'RATES-Non Fed'!$I$38,0),IF($D17=\"ACAD\",P17*'RATES-Non Fed'!$I$44,P17*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((P17*(1+'Salary Inflation'!$E$30)),0),IF($D17=\"ACAD\",(P17)*(1+'Salary Inflation'!$E$31),IF($D17=\"SUMR\",(P17)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(S17*'RATES-Non Fed'!$K$38,0),IF($D17=\"ACAD\",S17*'RATES-Non Fed'!$K$44,S17*'RATES-Non Fed'!$K$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D18=\"CAL\",ROUND(($G18*(1+'Salary Inflation'!$B$30))*$E18,0),IF($D18=\"ACAD\",($G18/0.9965)*(1+'Salary Inflation'!$B$31)*$E18,IF($D18=\"SUMR\",($G18)*(1+'Salary Inflation'!$B$32)*$E18,\"NA\")))","v":0},{"$f":"IF(D18=\"CAL\",ROUND(J18*'RATES-Non Fed'!$E$38,0),IF(D18=\"ACAD\",J18*'RATES-Non Fed'!$E$44,J18*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((J18*(1+'Salary Inflation'!$C$30)),0),IF($D18=\"ACAD\",(J18)*(1+'Salary Inflation'!$C$31),IF($D18=\"SUMR\",(J18)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(M18*'RATES-Non Fed'!$G$38,0),IF($D18=\"ACAD\",M18*'RATES-Non Fed'!$G$44,M18*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((M18*(1+'Salary Inflation'!$D$30)),0),IF($D18=\"ACAD\",(M18)*(1+'Salary Inflation'!$D$31),IF($D18=\"SUMR\",(M18)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(P18*'RATES-Non Fed'!$I$38,0),IF($D18=\"ACAD\",P18*'RATES-Non Fed'!$I$44,P18*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((P18*(1+'Salary Inflation'!$E$30)),0),IF($D18=\"ACAD\",(P18)*(1+'Salary Inflation'!$E$31),IF($D18=\"SUMR\",(P18)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(S18*'RATES-Non Fed'!$K$38,0),IF($D18=\"ACAD\",S18*'RATES-Non Fed'!$K$44,S18*'RATES-Non Fed'!$K$45))","v":0},0,0]
[null,null,null,"AAUP Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J11:J18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["B","Dual Compensation Faculty"]
[null,"Co",null,"CAL",0,{"$f":"IF(D21=\"CAL\",(52*E21/4.3333),(IF(D21=\"ACAD\",(32*E21/4.33333),IF(D21=\"SUMR\",(14*E21/4.33333),IF(D21=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G21*(1+'Salary Inflation'!$B$34))*$E21,0)","v":0},{"$f":"ROUND(J21*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K21+J21,0)","v":0},{"$f":"ROUND(J21*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M21*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M21+N21,0)","v":0},{"$f":"ROUND(M21*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(P21*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P21+Q21,0)","v":0},{"$f":"ROUND(P21*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(S21*'RATES-Non Fed'!K40,0)","v":0},{"$f":"SUM(S21:T21)","v":0},{"$f":"SUM(L21+O21+R21+U21)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D22=\"CAL\",(52*E22/4.3333),(IF(D22=\"ACAD\",(32*E22/4.33333),IF(D22=\"SUMR\",(14*E22/4.33333),IF(D22=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G22*(1+'Salary Inflation'!$B$34))*$E22,0)","v":0},{"$f":"ROUND(J22*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K22+J22,0)","v":0},{"$f":"ROUND(J22*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M22*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M22+N22,0)","v":0},{"$f":"ROUND(M22*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(P22*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P22+Q22,0)","v":0},{"$f":"ROUND(P22*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(S22*'RATES-Non Fed'!K40,0)","v":0},{"$f":"SUM(S22:T22)","v":0},{"$f":"SUM(L22+O22+R22+U22)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D23=\"CAL\",(52*E23/4.3333),(IF(D23=\"ACAD\",(32*E23/4.33333),IF(D23=\"SUMR\",(14*E23/4.33333),IF(D23=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G23*(1+'Salary Inflation'!$B$34))*$E23,0)","v":0},{"$f":"ROUND(J23*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K23+J23,0)","v":0},{"$f":"ROUND(J23*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M23*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M23+N23,0)","v":0},{"$f":"ROUND(M23*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(P23*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P23+Q23,0)","v":0},{"$f":"ROUND(P23*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(S23*'RATES-Non Fed'!K40,0)","v":0},{"$f":"SUM(S23:T23)","v":0},{"$f":"SUM(L23+O23+R23+U23)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D24=\"CAL\",(52*E24/4.3333),(IF(D24=\"ACAD\",(32*E24/4.33333),IF(D24=\"SUMR\",(14*E24/4.33333),IF(D24=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G24*(1+'Salary Inflation'!$B$34))*$E24,0)","v":0},{"$f":"ROUND(J24*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K24+J24,0)","v":0},{"$f":"ROUND(J24*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M24*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M24+N24,0)","v":0},{"$f":"ROUND(M24*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(P24*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P24+Q24,0)","v":0},{"$f":"ROUND(P24*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(S24*'RATES-Non Fed'!K40,0)","v":0},{"$f":"SUM(S24:T24)","v":0},{"$f":"SUM(L24+O24+R24+U24)","v":0}]
[null,null,null,"Dual Comp Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J21:J24)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(S21:S24)","v":0},0,null,{"$f":"SUM(V21:V24)","v":0}]
[]
["C."," Other Personnel"]
[null,null,"Exempt Staff (Monthly)","Name"]
[null,null,null,null,0,{"$f":"SUM(52*E29/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G29*(1+'Salary Inflation'!$B$33))*$E29,0)","v":0},{"$f":"ROUND(J29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J29:K29)","v":0},{"$f":"ROUND(J29*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(M29:N29)","v":0},{"$f":"ROUND(M29*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(P29:Q29)","v":0},{"$f":"ROUND(P29*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S29*'RATES-Non Fed'!K39,0)","v":0},{"$f":"SUM(S29:T29)","v":0},{"$f":"SUM(L29+O29+R29+U29)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E30/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G30*(1+'Salary Inflation'!$B$33))*$E30,0)","v":0},{"$f":"ROUND(J30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J30:K30)","v":0},{"$f":"ROUND(J30*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(M30:N30)","v":0},{"$f":"ROUND(M30*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(P30:Q30)","v":0},{"$f":"ROUND(P30*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S30*'RATES-Non Fed'!K40,0)","v":0},{"$f":"SUM(S30:T30)","v":0},{"$f":"SUM(L30+O30+R30+U30)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E31/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G31*(1+'Salary Inflation'!$B$33))*$E31,0)","v":0},{"$f":"ROUND(J31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J31:K31)","v":0},{"$f":"ROUND(J31*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(M31:N31)","v":0},{"$f":"ROUND(M31*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(P31:Q31)","v":0},{"$f":"ROUND(P31*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S31*'RATES-Non Fed'!K41,0)","v":0},{"$f":"SUM(S31:T31)","v":0},{"$f":"SUM(L31+O31+R31+U31)","v":0}]
[null,null,null,"Total Exempt Staff",null,null,null,null,null,{"$f":"SUM(J29:J31)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(T29:T31)","v":0},{"$f":"SUM(U29:U31)","v":0},{"$f":"SUM(V29:V31)","v":0}]
[]
[null,null,"Post Doctoral Support",null,0,{"$f":"SUM(52*E34/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G34*(1+'Salary Inflation'!$B$33))*$E34,0)","v":0},{"$f":"ROUND(J34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(J34:K34)","v":0},{"$f":"ROUND(J34*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(M34:N34)","v":0},{"$f":"ROUND(M34*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(P34:Q34)","v":0},{"$f":"ROUND(P34*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(S34:T34)","v":0},{"$f":"SUM(L34+O34+R34+U34)","v":0}]
[null,null,"Graduate Students",null,0,{"$f":"SUM(52*E35/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G35*(1+'Salary Inflation'!$B$33))*$E35,0)","v":0},{"$f":"ROUND(J35*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J35:K35)","v":0},{"$f":"ROUND(J35*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M35*'RATES-Non Fed'!H42,0)","v":0},{"$f":"SUM(M35:N35)","v":0},{"$f":"ROUND(M35*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P35*'RATES-Non Fed'!K42,0)","v":0},{"$f":"SUM(P35:Q35)","v":0},{"$f":"ROUND(P35*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S35*'RATES-Non Fed'!N42,0)","v":0},{"$f":"SUM(S35:T35)","v":0},{"$f":"SUM(L35+O35+R35+U35)","v":0}]
[null,null,"Undergrad Students",null,0,{"$f":"SUM(52*E36/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G36*(1+'Salary Inflation'!$B$33))*$E36,0)","v":0},{"$f":"ROUND(J36*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J36:K36)","v":0},{"$f":"ROUND(J36*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M36*'RATES-Non Fed'!H42,0)","v":0},{"$f":"SUM(M36:N36)","v":0},{"$f":"ROUND(M36*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P36*'RATES-Non Fed'!K42,0)","v":0},{"$f":"SUM(P36:Q36)","v":0},{"$f":"ROUND(P36*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S36*'RATES-Non Fed'!N42,0)","v":0},{"$f":"SUM(S36:T36)","v":0},{"$f":"SUM(L36+O36+R36+U36)","v":0}]
[null,null,"Part-time Faculty/Staff",null,0,{"$f":"SUM(52*E37/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G37*(1+'Salary Inflation'!$B$33))*$E37,0)","v":0},{"$f":"ROUND(J37*'RATES-Non Fed'!E43,0)","v":0},{"$f":"SUM(J37:K37)","v":0},{"$f":"ROUND(J37*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M37*'RATES-Non Fed'!H43,0)","v":0},{"$f":"SUM(M37:N37)","v":0},{"$f":"ROUND(M37*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P37*'RATES-Non Fed'!K43,0)","v":0},{"$f":"SUM(P37:Q37)","v":0},{"$f":"ROUND(P37*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S37*'RATES-Non Fed'!N43,0)","v":0},{"$f":"SUM(S37:T37)","v":0},{"$f":"SUM(L37+O37+R37+U37)","v":0}]
[null,null,"Non-Exempt Staff (Bi-Weekly)",null,0,{"$f":"SUM(52*E38/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G38*(1+'Salary Inflation'!$B$33))*$E38,0)","v":0},{"$f":"ROUND(J38*'RATES-Non Fed'!E41,0)","v":0},{"$f":"SUM(J38:K38)","v":0},{"$f":"ROUND(J38*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M38*'RATES-Non Fed'!H41,0)","v":0},{"$f":"SUM(M38:N38)","v":0},{"$f":"ROUND(M38*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P38*'RATES-Non Fed'!K41,0)","v":0},{"$f":"SUM(P38:Q38)","v":0},{"$f":"ROUND(P38*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S38*'RATES-Non Fed'!N41,0)","v":0},{"$f":"SUM(S38:T38)","v":0},{"$f":"SUM(L38+O38+R38+U38)","v":0}]
[null,null,null,"Sub Totals",null,null,null,null,null,{"$f":"SUM(J19+J25+J32+J34+J35+J36+J37+J38)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(V34:V38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Total Salaries and Fringe Benefits : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J39+K39)","v":0},null,null,{"$f":"SUM(M39+N39)","v":0},null,null,{"$f":"SUM(P39+Q39)","v":0},null,null,{"$f":"SUM(S39+T39)","v":0},null,null,{"$f":"SUM(J41+M41+P41+S41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["D."," Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"SUM(J44:U44)","v":0}]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"SUM(J45:U45)","v":0}]
[null,null,"Total Equipment : ",null,null,null,null,null,null,{"$f":"SUM(J44:J45)","v":0},null,null,{"$f":"SUM(M44:M45)","v":0},null,null,{"$f":"SUM(P44:P45)","v":0},null,null,{"$f":"SUM(S44:S45)","v":0},null,null,{"$f":"SUM(J46:U46)","v":0}]
[]
["E."," Travel",null,null,null,null,null,null,null," ",null,null," ",null,null," ",null,null," "]
[null,null,"Domestic ","(list)",null,null,null,null,null,0,null,null,{"$f":"ROUND((J49*1.02),0)","v":0},null,null,{"$f":"ROUND((M49*1.02),0)","v":0},null,null,{"$f":"ROUND((P49*1.02),0)","v":0},null,null,{"$f":"SUM(J49:U49)","v":0}]
[null,null,"International ","(list)",null,null,null,null,null,0,null,null,{"$f":"ROUND((J50*1.02),0)","v":0},null,null,{"$f":"ROUND((M50*1.02),0)","v":0},null,null,{"$f":"ROUND((P50*1.02),0)","v":0},null,null,{"$f":"SUM(J50:U50)","v":0}]
[null,null,"Total Travel : ",null,null,null,null,null,null,{"$f":"SUM(J49:J50)","v":0},null,null,{"$f":"SUM(M49:M50)","v":0},null,null,{"$f":"SUM(P49:P50)","v":0},null,null,{"$f":"SUM(S49:S50)","v":0},null,null,{"$f":"SUM(J51:U51)","v":0}]
[]
["G."," Supplies and Other Direct Costs",null,null,null,null,null,null,null," ",null,null," ",null,null," ",null,null," "]
[null,null,"Materials & Supplies",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J54*1.02),0)","v":0},null,null,{"$f":"ROUND((M54*1.02),0)","v":0},null,null,{"$f":"ROUND((P54*1.02),0)","v":0},null,null,{"$f":"SUM(J54:U54)","v":0}]
[null,null,"Publication Costs",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J55*1.02),0)","v":0},null,null,{"$f":"ROUND((M55*1.02),0)","v":0},null,null,{"$f":"ROUND((P55*1.02),0)","v":0},null,null,0]
[null,null,"Consultant Services",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Subject Incentives",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"UC Tuition for Trainees/Fellows",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"UC Tuition on Research Projects",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J59*1.02),0)","v":0},null,null,{"$f":"ROUND((M59*1.02),0)","v":0},null,null,{"$f":"ROUND((P59*1.02),0)","v":0},null,null,{"$f":"SUM(J59:U59)","v":0}]
[null,null,"Lab Expenses",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Other (Analytical Services/Instrument Use)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Subcontracts       1)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"2)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"3)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"4)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Total Supplies and Other Direct Costs : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J54:J65)","v":0},null,null,{"$f":"SUM(M54:M65)","v":0},null,null,{"$f":"SUM(P54:P65)","v":0},null,null,{"$f":"SUM(S54:S65)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"TOTAL DIRECT COSTS: ",null,null,null,null,{"$f":"ROUND(+J66+J51+J46+J41,0)","v":0},null,null,{"$f":"ROUND(+M66+M51+M46+M41,0)","v":0},null,null,{"$f":"ROUND(+P66+P51+P46+P41,0)","v":0},null,null,{"$f":"ROUND(+S66+S51+S46+S41,0)","v":0},null,null,{"$f":"SUM(J68:U68)","v":0}]
[]
[null,null,null,null,null,null,null,"Facilities and Administrative Cost Base:",null,{"$f":"J68","v":0},null,null,{"$f":"M68","v":0},null,null,{"$f":"P68","v":0},null,null,{"$f":"S68","v":0},null,null,{"$f":"SUM(J70:U70)","v":0}]
["Facilities and Administrative Costs Calculation: "]
["F&A Cost (on MTDC): ",null,null,{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!E48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!E53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!E49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!E54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!E50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!E55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!G48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!G53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!G49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!G54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!G50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!G55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!I48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!I53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!I49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!I54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!I50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!I55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!K48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!K53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!K49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!K54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!K50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!K55),($E$80)))))))","v":0.62},null,null,{"$f":"+J70*D72","v":0},null,null,{"$f":"+M70*E72","v":0},null,null,{"$f":"+P70*F72","v":0},null,null,{"$f":"+S70*G72","v":0},null,null,{"$f":"SUM(J72:U72)","v":0}]
["Total F&A Cost : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J72:J72)","v":0},null,null,{"$f":"SUM(M72:M72)","v":0},null,null,{"$f":"SUM(P72:P72)","v":0},null,null,{"$f":"SUM(S72:S72)","v":0},null,null,{"$f":"SUM(J73:U73)","v":0}]
[]
[null,null,"Total  Cost",null,null,null,null,null,null,{"$f":"J73+J68","v":0},null,null,{"$f":"M73+M68","v":0},null,null,{"$f":"P73+P68","v":0},null,null,{"$f":"S73+S68","v":0},null,null,{"$f":"SUM(J75:U75)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"Facilities and Administrative Data"]
[null,null,"Purpose of Grant / Contract : ",null,"R",null,"(R = Research, I = Instruction, P = Public Service, S = Special Rate on Total Costs)"]
[null,null,"Special F&A Rate : ",null,0.1]
[null,null,"Campus Status :",null,"C",null,"(C = On Campus, O = Off Campus)"]
[]
[null,null,null,"Detailed F&A figures for prorated rates",null,null,null,{"$f":"+'RATES-Non Fed'!E31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$C$48","v":0},null,{"$f":"+'RATES-Non Fed'!G31","v":0.62},{"$f":"M73/12*'RATES-Non Fed'!$C$48","v":0},null,{"$f":"+'RATES-Non Fed'!I31","v":0.62},{"$f":"P73/12*'RATES-Non Fed'!$C$48","v":0},null,{"$f":"+'RATES-Non Fed'!K31","v":0.62},{"$f":"S73/12*'RATES-Non Fed'!$C$48","v":0}]
[null,null,null,"*If both lines have the same rate, then just list as one line on forms.",null,null,null,{"$f":"+'RATES-Non Fed'!G31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$D$48","v":0},null,{"$f":"+'RATES-Non Fed'!I31","v":0.62},{"$f":"M73/12*'RATES-Non Fed'!$D$48","v":0},null,{"$f":"+'RATES-Non Fed'!K31","v":0.62},{"$f":"P73/12*'RATES-Non Fed'!$D$48","v":0},null,{"$f":"+'RATES-Non Fed'!M31","v":0.62},{"$f":"S73/12*'RATES-Non Fed'!$D$48","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J83:J84)","v":0},null,null,{"$f":"SUM(M83:M84)","v":0},null,null,{"$f":"SUM(P83:P84)","v":0},null,null,{"$f":"SUM(S83:S84)","v":0},null,{"$f":"'RATES-Non Fed'!Q69","v":0}]

{"sheet":"5 Year","index":5,"n_rows":85,"n_cols":25,"rows_kept":85,"cut":false,"hidden":false,"merged":[[7,21,7,23],[3,10,4,20],[83,3,84,6],[7,9,7,11],[7,12,7,14],[7,15,7,17],[7,18,7,20]]}
["Grants / Contracts"]
["5 Year Budget "]
[" ",null,null,null,null,null,null,null,null," "]
["Sponsoring Agency : ",null,null,"name",null,null,null,null,null,"Titled : ","name"]
["Principal Investigator : ",null,null,"name"]
[null,"Period : ",null,{"$f":"'RATES-Non Fed'!E2","v":"2024-01-01"},"thru",null,{"$f":"'RATES-Non Fed'!G2","v":"1930-12-31"}]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,"Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5",null,null,"CUMULATIVE"]
["A."," Salaries",null,null,null,null,null,null,null,"Sal","FB","Total","Sal","FB","Total","Sal","FB","Total","Sal","FB","Total","Sal","FB","Total"]
[null,"Senior Personnel",null,"App't Type","% Effort","PM","Salary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J10:N10)=0,\"\",SUM(J10:N10))","v":""}]
[null,"PI",null,"ACAD",0,{"$f":"IF(D11=\"CAL\",(52*E11/4.3333),(IF(D11=\"ACAD\",(36.35*E11/4.33333),IF(D11=\"SUMR\",(15.65*E11/4.33333),IF(D11=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"IF($D11=\"CAL\",ROUND(($G11*(1+'Salary Inflation'!$B$30))*$E11,0),IF($D11=\"ACAD\",($G11/0.9965)*(1+'Salary Inflation'!$B$31)*$E11,IF($D11=\"SUMR\",($G11)*(1+'Salary Inflation'!$B$32)*$E11,\"NA\")))","v":0},{"$f":"IF(D11=\"CAL\",ROUND(J11*'RATES-Non Fed'!$E$38,0),IF(D11=\"ACAD\",J11*'RATES-Non Fed'!$E$44,J11*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K11+J11,0)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((J11*(1+'Salary Inflation'!$C$30)),0),IF($D11=\"ACAD\",(J11)*(1+'Salary Inflation'!$C$31),IF($D11=\"SUMR\",(J11)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(M11*'RATES-Non Fed'!$G$38,0),IF($D11=\"ACAD\",M11*'RATES-Non Fed'!$G$44,M11*'RATES-Non Fed'!$G$45))","v":0},{"$f":"ROUND(M11+N11,0)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((M11*(1+'Salary Inflation'!$D$30)),0),IF($D11=\"ACAD\",(M11)*(1+'Salary Inflation'!$D$31),IF($D11=\"SUMR\",(M11)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(P11*'RATES-Non Fed'!$I$38,0),IF($D11=\"ACAD\",P11*'RATES-Non Fed'!$I$44,P11*'RATES-Non Fed'!$I$45))","v":0},{"$f":"SUM(P11:Q11)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((P11*(1+'Salary Inflation'!$E$30)),0),IF($D11=\"ACAD\",(P11)*(1+'Salary Inflation'!$E$31),IF($D11=\"SUMR\",(P11)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(S11*'RATES-Non Fed'!$K$38,0),IF($D11=\"ACAD\",S11*'RATES-Non Fed'!$K$44,S11*'RATES-Non Fed'!$K$45))","v":0},{"$f":"SUM(S11:T11)","v":0},{"$f":"IF($D11=\"CAL\",ROUND((S11*(1+'Salary Inflation'!$F$30)),0),IF($D11=\"ACAD\",(S11)*(1+'Salary Inflation'!$F$31),IF($D11=\"SUMR\",(S11)*(1+'Salary Inflation'!$F$32),\"NA\")))","v":0},{"$f":"IF($D11=\"CAL\",ROUND(V11*'RATES-Non Fed'!$M$38,0),IF($D11=\"ACAD\",V11*'RATES-Non Fed'!$M$44,V11*'RATES-Non Fed'!$M$45))","v":0},{"$f":"SUM(V11:W11)","v":0},{"$f":"SUM(L11+O11+R11+U11+X11)","v":0}]
[null,"PI",null,"SUMR",0,0,{"$f":"IF(D11=\"ACAD\",+G11*0.437,0)","v":0},null,null,{"$f":"IF($D12=\"CAL\",ROUND(($G12*(1+'Salary Inflation'!$B$30))*$E12,0),IF($D12=\"ACAD\",($G12/0.9965)*(1+'Salary Inflation'!$B$31)*$E12,IF($D12=\"SUMR\",($G12)*(1+'Salary Inflation'!$B$32)*$E12,\"NA\")))","v":0},{"$f":"IF(D12=\"CAL\",ROUND(J12*'RATES-Non Fed'!$E$38,0),IF(D12=\"ACAD\",J12*'RATES-Non Fed'!$E$44,J12*'RATES-Non Fed'!$E$45))","v":0},{"$f":"ROUND(K12+J12,0)","v":0},{"$f":"IF($D12=\"CAL\",ROUND((J12*(1+'Salary Inflation'!$C$30)),0),IF($D12=\"ACAD\",(J12)*(1+'Salary Inflation'!$C$31),IF($D12=\"SUMR\",(J12)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(M12*'RATES-Non Fed'!$G$38,0),IF($D12=\"ACAD\",M12*'RATES-Non Fed'!$G$44,M12*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D12=\"CAL\",ROUND((M12*(1+'Salary Inflation'!$D$30)),0),IF($D12=\"ACAD\",(M12)*(1+'Salary Inflation'!$D$31),IF($D12=\"SUMR\",(M12)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(P12*'RATES-Non Fed'!$I$38,0),IF($D12=\"ACAD\",P12*'RATES-Non Fed'!$I$44,P12*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D12=\"CAL\",ROUND((P12*(1+'Salary Inflation'!$E$30)),0),IF($D12=\"ACAD\",(P12)*(1+'Salary Inflation'!$E$31),IF($D12=\"SUMR\",(P12)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(S12*'RATES-Non Fed'!$K$38,0),IF($D12=\"ACAD\",S12*'RATES-Non Fed'!$K$44,S12*'RATES-Non Fed'!$K$45))","v":0},{"$f":"SUM(S12:T12)","v":0},{"$f":"IF($D12=\"CAL\",ROUND((S12*(1+'Salary Inflation'!$F$30)),0),IF($D12=\"ACAD\",(S12)*(1+'Salary Inflation'!$F$31),IF($D12=\"SUMR\",(S12)*(1+'Salary Inflation'!$F$32),\"NA\")))","v":0},{"$f":"IF($D12=\"CAL\",ROUND(V12*'RATES-Non Fed'!$M$38,0),IF($D12=\"ACAD\",V12*'RATES-Non Fed'!$M$44,V12*'RATES-Non Fed'!$M$45))","v":0},0,{"$f":"SUM(L12+O12+R12+U12+X12)","v":0}]
[null,"Co",null,"ACAD",0,0,0,null,null,{"$f":"IF($D13=\"CAL\",ROUND(($G13*(1+'Salary Inflation'!$B$30))*$E13,0),IF($D13=\"ACAD\",($G13/0.9965)*(1+'Salary Inflation'!$B$31)*$E13,IF($D13=\"SUMR\",($G13)*(1+'Salary Inflation'!$B$32)*$E13,\"NA\")))","v":0},{"$f":"IF(D13=\"CAL\",ROUND(J13*'RATES-Non Fed'!$E$38,0),IF(D13=\"ACAD\",J13*'RATES-Non Fed'!$E$44,J13*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((J13*(1+'Salary Inflation'!$C$30)),0),IF($D13=\"ACAD\",(J13)*(1+'Salary Inflation'!$C$31),IF($D13=\"SUMR\",(J13)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(M13*'RATES-Non Fed'!$G$38,0),IF($D13=\"ACAD\",M13*'RATES-Non Fed'!$G$44,M13*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((M13*(1+'Salary Inflation'!$D$30)),0),IF($D13=\"ACAD\",(M13)*(1+'Salary Inflation'!$D$31),IF($D13=\"SUMR\",(M13)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(P13*'RATES-Non Fed'!$I$38,0),IF($D13=\"ACAD\",P13*'RATES-Non Fed'!$I$44,P13*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((P13*(1+'Salary Inflation'!$E$30)),0),IF($D13=\"ACAD\",(P13)*(1+'Salary Inflation'!$E$31),IF($D13=\"SUMR\",(P13)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(S13*'RATES-Non Fed'!$K$38,0),IF($D13=\"ACAD\",S13*'RATES-Non Fed'!$K$44,S13*'RATES-Non Fed'!$K$45))","v":0},0,{"$f":"IF($D13=\"CAL\",ROUND((S13*(1+'Salary Inflation'!$F$30)),0),IF($D13=\"ACAD\",(S13)*(1+'Salary Inflation'!$F$31),IF($D13=\"SUMR\",(S13)*(1+'Salary Inflation'!$F$32),\"NA\")))","v":0},{"$f":"IF($D13=\"CAL\",ROUND(V13*'RATES-Non Fed'!$M$38,0),IF($D13=\"ACAD\",V13*'RATES-Non Fed'!$M$44,V13*'RATES-Non Fed'!$M$45))","v":0},0,0]
[null,null,null,{"$f":"IF(D13=\"ACAD\",(\"SUMR\"),\"\")","v":"SUMR"},0,0,{"$f":"IF(D13=\"ACAD\",+G13*0.437,0)","v":0},null,null,{"$f":"IF($D14=\"CAL\",ROUND(($G14*(1+'Salary Inflation'!$B$30))*$E14,0),IF($D14=\"ACAD\",($G14/0.9965)*(1+'Salary Inflation'!$B$31)*$E14,IF($D14=\"SUMR\",($G14)*(1+'Salary Inflation'!$B$32)*$E14,\"NA\")))","v":0},{"$f":"IF(D14=\"CAL\",ROUND(J14*'RATES-Non Fed'!$E$38,0),IF(D14=\"ACAD\",J14*'RATES-Non Fed'!$E$44,J14*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((J14*(1+'Salary Inflation'!$C$30)),0),IF($D14=\"ACAD\",(J14)*(1+'Salary Inflation'!$C$31),IF($D14=\"SUMR\",(J14)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(M14*'RATES-Non Fed'!$G$38,0),IF($D14=\"ACAD\",M14*'RATES-Non Fed'!$G$44,M14*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((M14*(1+'Salary Inflation'!$D$30)),0),IF($D14=\"ACAD\",(M14)*(1+'Salary Inflation'!$D$31),IF($D14=\"SUMR\",(M14)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(P14*'RATES-Non Fed'!$I$38,0),IF($D14=\"ACAD\",P14*'RATES-Non Fed'!$I$44,P14*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((P14*(1+'Salary Inflation'!$E$30)),0),IF($D14=\"ACAD\",(P14)*(1+'Salary Inflation'!$E$31),IF($D14=\"SUMR\",(P14)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(S14*'RATES-Non Fed'!$K$38,0),IF($D14=\"ACAD\",S14*'RATES-Non Fed'!$K$44,S14*'RATES-Non Fed'!$K$45))","v":0},0,{"$f":"IF($D14=\"CAL\",ROUND((S14*(1+'Salary Inflation'!$F$30)),0),IF($D14=\"ACAD\",(S14)*(1+'Salary Inflation'!$F$31),IF($D14=\"SUMR\",(S14)*(1+'Salary Inflation'!$F$32),\"NA\")))","v":0},{"$f":"IF($D14=\"CAL\",ROUND(V14*'RATES-Non Fed'!$M$38,0),IF($D14=\"ACAD\",V14*'RATES-Non Fed'!$M$44,V14*'RATES-Non Fed'!$M$45))","v":0},0,0]
[null,"Co",null,"ACAD",0,0,0,null,null,{"$f":"IF($D15=\"CAL\",ROUND(($G15*(1+'Salary Inflation'!$B$30))*$E15,0),IF($D15=\"ACAD\",($G15/0.9965)*(1+'Salary Inflation'!$B$31)*$E15,IF($D15=\"SUMR\",($G15)*(1+'Salary Inflation'!$B$32)*$E15,\"NA\")))","v":0},{"$f":"IF(D15=\"CAL\",ROUND(J15*'RATES-Non Fed'!$E$38,0),IF(D15=\"ACAD\",J15*'RATES-Non Fed'!$E$44,J15*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((J15*(1+'Salary Inflation'!$C$30)),0),IF($D15=\"ACAD\",(J15)*(1+'Salary Inflation'!$C$31),IF($D15=\"SUMR\",(J15)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(M15*'RATES-Non Fed'!$G$38,0),IF($D15=\"ACAD\",M15*'RATES-Non Fed'!$G$44,M15*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((M15*(1+'Salary Inflation'!$D$30)),0),IF($D15=\"ACAD\",(M15)*(1+'Salary Inflation'!$D$31),IF($D15=\"SUMR\",(M15)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(P15*'RATES-Non Fed'!$I$38,0),IF($D15=\"ACAD\",P15*'RATES-Non Fed'!$I$44,P15*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((P15*(1+'Salary Inflation'!$E$30)),0),IF($D15=\"ACAD\",(P15)*(1+'Salary Inflation'!$E$31),IF($D15=\"SUMR\",(P15)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(S15*'RATES-Non Fed'!$K$38,0),IF($D15=\"ACAD\",S15*'RATES-Non Fed'!$K$44,S15*'RATES-Non Fed'!$K$45))","v":0},0,{"$f":"IF($D15=\"CAL\",ROUND((S15*(1+'Salary Inflation'!$F$30)),0),IF($D15=\"ACAD\",(S15)*(1+'Salary Inflation'!$F$31),IF($D15=\"SUMR\",(S15)*(1+'Salary Inflation'!$F$32),\"NA\")))","v":0},{"$f":"IF($D15=\"CAL\",ROUND(V15*'RATES-Non Fed'!$M$38,0),IF($D15=\"ACAD\",V15*'RATES-Non Fed'!$M$44,V15*'RATES-Non Fed'!$M$45))","v":0},0,0]
[null,null,null,{"$f":"IF(D15=\"ACAD\",(\"SUMR\"),\"\")","v":"SUMR"},0,0,{"$f":"IF(D15=\"ACAD\",+G15*0.428,0)","v":0},null,null,{"$f":"IF($D16=\"CAL\",ROUND(($G16*(1+'Salary Inflation'!$B$30))*$E16,0),IF($D16=\"ACAD\",($G16/0.9965)*(1+'Salary Inflation'!$B$31)*$E16,IF($D16=\"SUMR\",($G16)*(1+'Salary Inflation'!$B$32)*$E16,\"NA\")))","v":0},{"$f":"IF(D16=\"CAL\",ROUND(J16*'RATES-Non Fed'!$E$38,0),IF(D16=\"ACAD\",J16*'RATES-Non Fed'!$E$44,J16*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((J16*(1+'Salary Inflation'!$C$30)),0),IF($D16=\"ACAD\",(J16)*(1+'Salary Inflation'!$C$31),IF($D16=\"SUMR\",(J16)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(M16*'RATES-Non Fed'!$G$38,0),IF($D16=\"ACAD\",M16*'RATES-Non Fed'!$G$44,M16*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((M16*(1+'Salary Inflation'!$D$30)),0),IF($D16=\"ACAD\",(M16)*(1+'Salary Inflation'!$D$31),IF($D16=\"SUMR\",(M16)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(P16*'RATES-Non Fed'!$I$38,0),IF($D16=\"ACAD\",P16*'RATES-Non Fed'!$I$44,P16*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((P16*(1+'Salary Inflation'!$E$30)),0),IF($D16=\"ACAD\",(P16)*(1+'Salary Inflation'!$E$31),IF($D16=\"SUMR\",(P16)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(S16*'RATES-Non Fed'!$K$38,0),IF($D16=\"ACAD\",S16*'RATES-Non Fed'!$K$44,S16*'RATES-Non Fed'!$K$45))","v":0},0,{"$f":"IF($D16=\"CAL\",ROUND((S16*(1+'Salary Inflation'!$F$30)),0),IF($D16=\"ACAD\",(S16)*(1+'Salary Inflation'!$F$31),IF($D16=\"SUMR\",(S16)*(1+'Salary Inflation'!$F$32),\"NA\")))","v":0},{"$f":"IF($D16=\"CAL\",ROUND(V16*'RATES-Non Fed'!$M$38,0),IF($D16=\"ACAD\",V16*'RATES-Non Fed'!$M$44,V16*'RATES-Non Fed'!$M$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D17=\"CAL\",ROUND(($G17*(1+'Salary Inflation'!$B$30))*$E17,0),IF($D17=\"ACAD\",($G17/0.9965)*(1+'Salary Inflation'!$B$31)*$E17,IF($D17=\"SUMR\",($G17)*(1+'Salary Inflation'!$B$32)*$E17,\"NA\")))","v":0},{"$f":"IF(D17=\"CAL\",ROUND(J17*'RATES-Non Fed'!$E$38,0),IF(D17=\"ACAD\",J17*'RATES-Non Fed'!$E$44,J17*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((J17*(1+'Salary Inflation'!$C$30)),0),IF($D17=\"ACAD\",(J17)*(1+'Salary Inflation'!$C$31),IF($D17=\"SUMR\",(J17)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(M17*'RATES-Non Fed'!$G$38,0),IF($D17=\"ACAD\",M17*'RATES-Non Fed'!$G$44,M17*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((M17*(1+'Salary Inflation'!$D$30)),0),IF($D17=\"ACAD\",(M17)*(1+'Salary Inflation'!$D$31),IF($D17=\"SUMR\",(M17)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(P17*'RATES-Non Fed'!$I$38,0),IF($D17=\"ACAD\",P17*'RATES-Non Fed'!$I$44,P17*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((P17*(1+'Salary Inflation'!$E$30)),0),IF($D17=\"ACAD\",(P17)*(1+'Salary Inflation'!$E$31),IF($D17=\"SUMR\",(P17)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(S17*'RATES-Non Fed'!$K$38,0),IF($D17=\"ACAD\",S17*'RATES-Non Fed'!$K$44,S17*'RATES-Non Fed'!$K$45))","v":0},0,{"$f":"IF($D17=\"CAL\",ROUND((S17*(1+'Salary Inflation'!$F$30)),0),IF($D17=\"ACAD\",(S17)*(1+'Salary Inflation'!$F$31),IF($D17=\"SUMR\",(S17)*(1+'Salary Inflation'!$F$32),\"NA\")))","v":0},{"$f":"IF($D17=\"CAL\",ROUND(V17*'RATES-Non Fed'!$M$38,0),IF($D17=\"ACAD\",V17*'RATES-Non Fed'!$M$44,V17*'RATES-Non Fed'!$M$45))","v":0},0,0]
[null,"Co",null,"CAL",0,0,0,null,null,{"$f":"IF($D18=\"CAL\",ROUND(($G18*(1+'Salary Inflation'!$B$30))*$E18,0),IF($D18=\"ACAD\",($G18/0.9965)*(1+'Salary Inflation'!$B$31)*$E18,IF($D18=\"SUMR\",($G18)*(1+'Salary Inflation'!$B$32)*$E18,\"NA\")))","v":0},{"$f":"IF(D18=\"CAL\",ROUND(J18*'RATES-Non Fed'!$E$38,0),IF(D18=\"ACAD\",J18*'RATES-Non Fed'!$E$44,J18*'RATES-Non Fed'!$E$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((J18*(1+'Salary Inflation'!$C$30)),0),IF($D18=\"ACAD\",(J18)*(1+'Salary Inflation'!$C$31),IF($D18=\"SUMR\",(J18)*(1+'Salary Inflation'!$C$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(M18*'RATES-Non Fed'!$G$38,0),IF($D18=\"ACAD\",M18*'RATES-Non Fed'!$G$44,M18*'RATES-Non Fed'!$G$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((M18*(1+'Salary Inflation'!$D$30)),0),IF($D18=\"ACAD\",(M18)*(1+'Salary Inflation'!$D$31),IF($D18=\"SUMR\",(M18)*(1+'Salary Inflation'!$D$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(P18*'RATES-Non Fed'!$I$38,0),IF($D18=\"ACAD\",P18*'RATES-Non Fed'!$I$44,P18*'RATES-Non Fed'!$I$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((P18*(1+'Salary Inflation'!$E$30)),0),IF($D18=\"ACAD\",(P18)*(1+'Salary Inflation'!$E$31),IF($D18=\"SUMR\",(P18)*(1+'Salary Inflation'!$E$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(S18*'RATES-Non Fed'!$K$38,0),IF($D18=\"ACAD\",S18*'RATES-Non Fed'!$K$44,S18*'RATES-Non Fed'!$K$45))","v":0},0,{"$f":"IF($D18=\"CAL\",ROUND((S18*(1+'Salary Inflation'!$F$30)),0),IF($D18=\"ACAD\",(S18)*(1+'Salary Inflation'!$F$31),IF($D18=\"SUMR\",(S18)*(1+'Salary Inflation'!$F$32),\"NA\")))","v":0},{"$f":"IF($D18=\"CAL\",ROUND(V18*'RATES-Non Fed'!$M$38,0),IF($D18=\"ACAD\",V18*'RATES-Non Fed'!$M$44,V18*'RATES-Non Fed'!$M$45))","v":0},0,0]
[null,null,null,"AAUP Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J11:J18)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(V11:V18)","v":0},{"$f":"SUM(W11:W18)","v":0},{"$f":"SUM(X11:X18)","v":0},{"$f":"SUM(Y11:Y18)","v":0}]
["B","Dual Compensation Faculty"]
[null,"Co",null,"CAL",0,{"$f":"IF(D21=\"CAL\",(52*E21/4.3333),(IF(D21=\"ACAD\",(32*E21/4.33333),IF(D21=\"SUMR\",(14*E21/4.33333),IF(D21=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G21*(1+'Salary Inflation'!$B$34))*$E21,0)","v":0},{"$f":"ROUND(J21*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K21+J21,0)","v":0},{"$f":"ROUND(J21*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M21*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M21+N21,0)","v":0},{"$f":"ROUND((M21*1.02),0)","v":0},{"$f":"ROUND(P21*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P21+Q21,0)","v":0},{"$f":"ROUND(P21*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(S21*'RATES-Non Fed'!K40,0)","v":0},{"$f":"SUM(S21:T21)","v":0},{"$f":"ROUND(S21*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(V21*'RATES-Non Fed'!M40,0)","v":0},{"$f":"SUM(V21:W21)","v":0},{"$f":"SUM(L21+O21+R21+U21+X21)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D22=\"CAL\",(52*E22/4.3333),(IF(D22=\"ACAD\",(32*E22/4.33333),IF(D22=\"SUMR\",(14*E22/4.33333),IF(D22=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G22*(1+'Salary Inflation'!$B$34))*$E22,0)","v":0},{"$f":"ROUND(J22*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K22+J22,0)","v":0},{"$f":"ROUND(J22*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M22*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M22+N22,0)","v":0},{"$f":"ROUND((M22*1.02),0)","v":0},{"$f":"ROUND(P22*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P22+Q22,0)","v":0},{"$f":"ROUND(P22*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(S22*'RATES-Non Fed'!K40,0)","v":0},{"$f":"SUM(S22:T22)","v":0},{"$f":"ROUND(S22*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(V22*'RATES-Non Fed'!M40,0)","v":0},{"$f":"SUM(V22:W22)","v":0},{"$f":"SUM(L22+O22+R22+U22+X22)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D23=\"CAL\",(52*E23/4.3333),(IF(D23=\"ACAD\",(32*E23/4.33333),IF(D23=\"SUMR\",(14*E23/4.33333),IF(D23=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G23*(1+'Salary Inflation'!$B$34))*$E23,0)","v":0},{"$f":"ROUND(J23*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K23+J23,0)","v":0},{"$f":"ROUND(J23*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M23*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M23+N23,0)","v":0},{"$f":"ROUND((M23*1.02),0)","v":0},{"$f":"ROUND(P23*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P23+Q23,0)","v":0},{"$f":"ROUND(P23*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(S23*'RATES-Non Fed'!K40,0)","v":0},{"$f":"SUM(S23:T23)","v":0},{"$f":"ROUND(S23*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(V23*'RATES-Non Fed'!M40,0)","v":0},{"$f":"SUM(V23:W23)","v":0},{"$f":"SUM(L23+O23+R23+U23+X23)","v":0}]
[null,"Co",null,"CAL",0,{"$f":"IF(D24=\"CAL\",(52*E24/4.3333),(IF(D24=\"ACAD\",(32*E24/4.33333),IF(D24=\"SUMR\",(14*E24/4.33333),IF(D24=\"PT\",(0),0)))))","v":0},0,null,null,{"$f":"ROUND(($G24*(1+'Salary Inflation'!$B$34))*$E24,0)","v":0},{"$f":"ROUND(J24*'RATES-Non Fed'!E40,0)","v":0},{"$f":"ROUND(K24+J24,0)","v":0},{"$f":"ROUND(J24*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(M24*'RATES-Non Fed'!G40,0)","v":0},{"$f":"ROUND(M24+N24,0)","v":0},{"$f":"ROUND((M24*1.02),0)","v":0},{"$f":"ROUND(P24*'RATES-Non Fed'!I40,0)","v":0},{"$f":"ROUND(P24+Q24,0)","v":0},{"$f":"ROUND(P24*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(S24*'RATES-Non Fed'!K40,0)","v":0},{"$f":"SUM(S24:T24)","v":0},{"$f":"ROUND(S24*(1+'Salary Inflation'!$C$34),0)","v":0},{"$f":"ROUND(V24*'RATES-Non Fed'!M40,0)","v":0},{"$f":"SUM(V24:W24)","v":0},{"$f":"SUM(L24+O24+R24+U24+X24)","v":0}]
[null,null,null,"Dual Comp Faculty Subtotal : ",null,null,null,null,null,{"$f":"SUM(J21:J24)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U21:U24)","v":0},{"$f":"SUM(V21:V24)","v":0},{"$f":"SUM(W21:W24)","v":0},{"$f":"SUM(X21:X24)","v":0},{"$f":"SUM(Y21:Y24)","v":0}]
[]
["C."," Other Personnel"]
[null,null,"Exempt Staff (Monthly)","Name"]
[null,null,null,null,0,{"$f":"SUM(52*E29/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G29*(1+'Salary Inflation'!$B$33))*$E29,0)","v":0},{"$f":"ROUND(J29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J29:K29)","v":0},{"$f":"ROUND(J29*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(M29:N29)","v":0},{"$f":"ROUND(M29*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(P29:Q29)","v":0},{"$f":"ROUND(P29*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S29*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(S29:T29)","v":0},{"$f":"ROUND(S29*(1+'Salary Inflation'!$F$33),0)","v":0},{"$f":"ROUND(V29*'RATES-Non Fed'!M39,0)","v":0},{"$f":"SUM(V29:W29)","v":0},{"$f":"SUM(L29+O29+R29+U29+X29)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E30/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G30*(1+'Salary Inflation'!$B$33))*$E30,0)","v":0},{"$f":"ROUND(J30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J30:K30)","v":0},{"$f":"ROUND(J30*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(M30:N30)","v":0},{"$f":"ROUND(M30*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(P30:Q30)","v":0},{"$f":"ROUND(P30*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S30*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(S30:T30)","v":0},{"$f":"ROUND(S30*(1+'Salary Inflation'!$F$33),0)","v":0},{"$f":"ROUND(V30*'RATES-Non Fed'!M39,0)","v":0},{"$f":"SUM(V30:W30)","v":0},{"$f":"SUM(L30+O30+R30+U30+X30)","v":0}]
[null,null,null,null,0,{"$f":"SUM(52*E31/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G31*(1+'Salary Inflation'!$B$33))*$E31,0)","v":0},{"$f":"ROUND(J31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(J31:K31)","v":0},{"$f":"ROUND(J31*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(M31:N31)","v":0},{"$f":"ROUND(M31*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(P31:Q31)","v":0},{"$f":"ROUND(P31*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S31*'RATES-Non Fed'!$E$39,0)","v":0},{"$f":"SUM(S31:T31)","v":0},{"$f":"ROUND(S31*(1+'Salary Inflation'!$F$33),0)","v":0},{"$f":"ROUND(V31*'RATES-Non Fed'!M39,0)","v":0},{"$f":"SUM(V31:W31)","v":0},{"$f":"SUM(L31+O31+R31+U31+X31)","v":0}]
[null,null,null,"Total Exempt Staff",null,null,null,null,null,{"$f":"SUM(J29:J31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(W29:W31)","v":0},{"$f":"SUM(X29:X31)","v":0},{"$f":"SUM(Y29:Y31)","v":0}]
[]
[null,null,"Post Doctoral Support",null,0,{"$f":"SUM(52*E34/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G34*(1+'Salary Inflation'!$B$33))*$E34,0)","v":0},{"$f":"ROUND(J34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(J34:K34)","v":0},{"$f":"ROUND(J34*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(M34:N34)","v":0},{"$f":"ROUND(M34*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(P34:Q34)","v":0},{"$f":"ROUND(P34*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S34*'RATES-Non Fed'!$E$43,0)","v":0},{"$f":"SUM(S34:T34)","v":0},{"$f":"ROUND(S34*(1+'Salary Inflation'!$F$33),0)","v":0},{"$f":"ROUND(V34*'RATES-Non Fed'!M43,0)","v":0},{"$f":"SUM(V34:W34)","v":0},{"$f":"SUM(L34+O34+R34+U34+X34)","v":0}]
[null,null,"Graduate Students",null,0,{"$f":"SUM(52*E35/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G35*(1+'Salary Inflation'!$B$33))*$E35,0)","v":0},{"$f":"ROUND(J35*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J35:K35)","v":0},{"$f":"ROUND(J35*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M35*'RATES-Non Fed'!H42,0)","v":0},{"$f":"SUM(M35:N35)","v":0},{"$f":"ROUND(M35*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P35*'RATES-Non Fed'!K42,0)","v":0},{"$f":"SUM(P35:Q35)","v":0},{"$f":"ROUND(P35*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S35*'RATES-Non Fed'!N42,0)","v":0},{"$f":"SUM(S35:T35)","v":0},{"$f":"ROUND((S35*1.02),0)","v":0},{"$f":"ROUND(V35*'RATES-Non Fed'!M42,0)","v":0},{"$f":"SUM(V35:W35)","v":0},{"$f":"SUM(L35+O35+R35+U35+X35)","v":0}]
[null,null,"Undergrad Students",null,0,{"$f":"SUM(52*E36/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G36*(1+'Salary Inflation'!$B$33))*$E36,0)","v":0},{"$f":"ROUND(J36*'RATES-Non Fed'!E42,0)","v":0},{"$f":"SUM(J36:K36)","v":0},{"$f":"ROUND(J36*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M36*'RATES-Non Fed'!H42,0)","v":0},{"$f":"SUM(M36:N36)","v":0},{"$f":"ROUND(M36*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P36*'RATES-Non Fed'!K42,0)","v":0},{"$f":"SUM(P36:Q36)","v":0},{"$f":"ROUND(P36*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S36*'RATES-Non Fed'!N42,0)","v":0},{"$f":"SUM(S36:T36)","v":0},{"$f":"ROUND(S36*(1+'Salary Inflation'!$F$33),0)","v":0},{"$f":"ROUND(V36*'RATES-Non Fed'!M42,0)","v":0},{"$f":"SUM(V36:W36)","v":0},{"$f":"SUM(L36+O36+R36+U36+X36)","v":0}]
[null,null,"Part-time Faculty/Staff",null,0,{"$f":"SUM(52*E37/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G37*(1+'Salary Inflation'!$B$33))*$E37,0)","v":0},{"$f":"ROUND(J37*'RATES-Non Fed'!E43,0)","v":0},{"$f":"SUM(J37:K37)","v":0},{"$f":"ROUND(J37*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M37*'RATES-Non Fed'!H43,0)","v":0},{"$f":"SUM(M37:N37)","v":0},{"$f":"ROUND(M37*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P37*'RATES-Non Fed'!K43,0)","v":0},{"$f":"SUM(P37:Q37)","v":0},{"$f":"ROUND(P37*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S37*'RATES-Non Fed'!N43,0)","v":0},{"$f":"SUM(S37:T37)","v":0},{"$f":"ROUND(S37*(1+'Salary Inflation'!$F$33),0)","v":0},{"$f":"ROUND(V37*'RATES-Non Fed'!M43,0)","v":0},{"$f":"SUM(V37:W37)","v":0},{"$f":"SUM(L37+O37+R37+U37+X37)","v":0}]
[null,null,"Non-Exempt Staff (Bi-Weekly)",null,0,{"$f":"SUM(52*E38/4.3333)","v":0},0,null,null,{"$f":"ROUND(($G38*(1+'Salary Inflation'!$B$33))*$E38,0)","v":0},{"$f":"ROUND(J38*'RATES-Non Fed'!E41,0)","v":0},{"$f":"SUM(J38:K38)","v":0},{"$f":"ROUND(J38*(1+'Salary Inflation'!$C$33),0)","v":0},{"$f":"ROUND(M38*'RATES-Non Fed'!H41,0)","v":0},{"$f":"SUM(M38:N38)","v":0},{"$f":"ROUND(M38*(1+'Salary Inflation'!$D$33),0)","v":0},{"$f":"ROUND(P38*'RATES-Non Fed'!K41,0)","v":0},{"$f":"SUM(P38:Q38)","v":0},{"$f":"ROUND(P38*(1+'Salary Inflation'!$E$33),0)","v":0},{"$f":"ROUND(S38*'RATES-Non Fed'!N41,0)","v":0},{"$f":"SUM(S38:T38)","v":0},{"$f":"ROUND(S38*(1+'Salary Inflation'!$F$33),0)","v":0},{"$f":"ROUND(V38*'RATES-Non Fed'!M41,0)","v":0},{"$f":"SUM(V38:W38)","v":0},{"$f":"SUM(L38+O38+R38+U38+X38)","v":0}]
[null,null,null,"Sub Totals",null,null,null,null,null,{"$f":"SUM(J19+J25+J32+J34+J35+J36+J37+J38)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(V19+V25+V32+V34+V35+V36+V37+V38)","v":0},{"$f":"SUM(W19+W25+W32+W34+W35+W36+W37+W38)","v":0},{"$f":"SUM(X19+X25+X32+X34+X35+X36+X37+X38)","v":0},{"$f":"SUM(Y34:Y38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Total Salaries and Fringe Benefits : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J39+K39)","v":0},null,null,{"$f":"SUM(M39+N39)","v":0},null,null,{"$f":"SUM(P39+Q39)","v":0},null,null,{"$f":"SUM(S39+T39)","v":0},null,null,{"$f":"SUM(V39+W39)","v":0},null,null,{"$f":"SUM(J41+M41+P41+S41+V41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["D."," Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"+J44+M44+P44+S44+V44","v":0}]
[null,null,"(list)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"+J45+M45+P45+S45+V45","v":0}]
[null,null,"Total Equipment : ",null,null,null,null,null,null,{"$f":"SUM(J44:J45)","v":0},null,null,{"$f":"SUM(M44:M45)","v":0},null,null,{"$f":"SUM(P44:P45)","v":0},null,null,{"$f":"SUM(S44:S45)","v":0},null,null,{"$f":"SUM(V44:V45)","v":0},null,null,{"$f":"SUM(Y44:Y45)","v":0}]
[]
["E."," Travel",null,null,null,null,null,null,null," ",null,null," ",null,null," ",null,null," "]
[null,null,"Domestic ","(list)",null,null,null,null,null,0,null,null,{"$f":"ROUND((J49*1.02),0)","v":0},null,null,{"$f":"ROUND((M49*1.02),0)","v":0},null,null,{"$f":"ROUND((P49*1.02),0)","v":0},null,null,{"$f":"ROUND((S49*1.02),0)","v":0},null,null,{"$f":"+J49+M49+P49+S49+V49","v":0}]
[null,null,"International ","(list)",null,null,null,null,null,0,null,null,{"$f":"ROUND((J50*1.02),0)","v":0},null,null,{"$f":"ROUND((M50*1.02),0)","v":0},null,null,{"$f":"ROUND((P50*1.02),0)","v":0},null,null,{"$f":"ROUND((S50*1.02),0)","v":0},null,null,{"$f":"+J50+M50+P50+S50+V50","v":0}]
[null,null,"Total Travel : ",null,null,null,null,null,null,{"$f":"SUM(J49:J50)","v":0},null,null,{"$f":"SUM(M49:M50)","v":0},null,null,{"$f":"SUM(P49:P50)","v":0},null,null,{"$f":"SUM(S49:S50)","v":0},null,null,{"$f":"SUM(V49:V50)","v":0},null,null,{"$f":"SUM(Y49:Y50)","v":0}]
[]
["G."," Supplies and Other Direct Costs",null,null,null,null,null,null,null," ",null,null," ",null,null," ",null,null," "]
[null,null,"Materials & Supplies",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J54*1.02),0)","v":0},null,null,{"$f":"ROUND((M54*1.02),0)","v":0},null,null,{"$f":"ROUND((P54*1.02),0)","v":0},null,null,{"$f":"ROUND((S54*1.02),0)","v":0},null,null,{"$f":"+J54+M54+P54+S54+V54","v":0}]
[null,null,"Publication Costs",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J55*1.02),0)","v":0},null,null,{"$f":"ROUND((M55*1.02),0)","v":0},null,null,{"$f":"ROUND((P55*1.02),0)","v":0},null,null,{"$f":"ROUND((S55*1.02),0)","v":0},null,null,0]
[null,null,"Consultant Services",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Subject Incentives",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"UC Tuition for Trainees/Fellows",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"UC Tuition on Research Projects",null,null,null,null,null,null,0,null,null,{"$f":"ROUND((J59*1.02),0)","v":0},null,null,{"$f":"ROUND((M59*1.02),0)","v":0},null,null,{"$f":"ROUND((P59*1.02),0)","v":0},null,null,{"$f":"ROUND((S59*1.02),0)","v":0},null,null,{"$f":"+J59+M59+P59+S59+V59","v":0}]
[null,null,"Lab Expenses",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Other (Analytical Services/Instrument Use)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Subcontracts       1)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"2)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"3)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"4)",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Total Supplies and Other Direct Costs : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J54:J65)","v":0},null,null,{"$f":"SUM(M54:M65)","v":0},null,null,{"$f":"SUM(P54:P65)","v":0},null,null,{"$f":"SUM(S54:S65)","v":0},null,null,{"$f":"SUM(V54:V65)","v":0},null,null,{"$f":"SUM(Y54:Y65)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"TOTAL DIRECT COSTS: ",null,null,null,null,{"$f":"ROUND(+J66+J51+J46+J41,0)","v":0},null,null,{"$f":"ROUND(+M66+M51+M46+M41,0)","v":0},null,null,{"$f":"ROUND(+P66+P51+P46+P41,0)","v":0},null,null,{"$f":"ROUND(+S66+S51+S46+S41,0)","v":0},null,null,{"$f":"ROUND(+V66+V51+V46+V41,0)","v":0},null,null,{"$f":"+J68+M68+P68+S68+V68","v":0}]
[]
[null,null,null,null,null,null,null,"Facilities and Administrative Cost Base:",null,{"$f":"J68","v":0},null,null,{"$f":"M68","v":0},null,null,{"$f":"P68","v":0},null,null,{"$f":"S68","v":0},null,null,{"$f":"V68","v":0},null,null,{"$f":"+J70+M70+P70+S70+V70","v":0}]
["Facilities and Administrative Costs Calculation: "]
["F&A Cost (on MTDC): ",null,null,{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!E48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!E53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!E49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!E54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!E50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!E55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!G48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!G53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!G49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!G54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!G50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!G55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!I48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!I53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!I49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!I54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!I50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!I55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!K48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!K53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!K49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!K54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!K50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!K55),($E$80)))))))","v":0.62},{"$f":"IF(AND(($E$79)=\"R\",($E$81)=\"C\"),('RATES-Non Fed'!I48),IF(AND(($E$79)=\"R\",($E$81)=\"O\"),('RATES-Non Fed'!I53),IF(AND(($E$79)=\"I\",($E$81)=\"C\"),('RATES-Non Fed'!I49),IF(AND(($E$79)=\"I\",($E$81)=\"O\"),('RATES-Non Fed'!I54),IF(AND(($E$79)=\"P\",($E$81)=\"C\"),('RATES-Non Fed'!I50),IF(AND(($E$79)=\"P\",($E$81)=\"O\"),('RATES-Non Fed'!I55),($E$80)))))))","v":0.62},null,{"$f":"+J70*D72","v":0},null,null,{"$f":"+M70*E72","v":0},null,null,{"$f":"+P70*F72","v":0},null,null,{"$f":"+S70*G72","v":0},null,null,{"$f":"+V70*H72","v":0},null,null,{"$f":"+J72+M72+P72+S72+V72","v":0}]
["Total F&A Cost : ",null,null,null,null,null,null,null,null,{"$f":"SUM(J72:J72)","v":0},null,null,{"$f":"SUM(M72:M72)","v":0},null,null,{"$f":"SUM(P72:P72)","v":0},null,null,{"$f":"SUM(S72:S72)","v":0},null,null,{"$f":"SUM(V72:V72)","v":0},null,null,{"$f":"SUM(Y72:Y72)","v":0}]
[]
[null,null,"Total  Cost",null,null,null,null,null,null,{"$f":"J73+J68","v":0},null,null,{"$f":"M73+M68","v":0},null,null,{"$f":"P73+P68","v":0},null,null,{"$f":"S73+S68","v":0},null,null,{"$f":"V73+V68","v":0},null,null,{"$f":"+J75+M75+P75+S75+V75","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"Facilities and Administrative Data"]
[null,null,"Purpose of Grant / Contract : ",null,"R",null,"(R = Research, I = Instruction, P = Public Service, S = Special Rate on Total Costs)"]
[null,null,"Special F&A Rate : ",null,0.1]
[null,null,"Campus Status :",null,"C",null,"(C = On Campus, O = Off Campus)"]
[]
[null,null,null,"Detailed F&A figures for prorated rates",null,null,null,{"$f":"+'RATES-Non Fed'!E31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$C$48","v":0},null,{"$f":"+'RATES-Non Fed'!G31","v":0.62},{"$f":"M73/12*'RATES-Non Fed'!$C$48","v":0},null,{"$f":"+'RATES-Non Fed'!I31","v":0.62},{"$f":"P73/12*'RATES-Non Fed'!$C$48","v":0},null,{"$f":"+'RATES-Non Fed'!K31","v":0.62},{"$f":"S73/12*'RATES-Non Fed'!$C$48","v":0},{"$f":"+'RATES-Non Fed'!M31","v":0.62},{"$f":"U73/12*'RATES-Non Fed'!$C$48","v":0}]
[null,null,null,"*If both lines have the same rate, then just list as one line on forms.",null,null,null,{"$f":"+'RATES-Non Fed'!G31","v":0.62},null,{"$f":"J73/12*'RATES-Non Fed'!$D$48","v":0},null,{"$f":"+'RATES-Non Fed'!I31","v":0.62},{"$f":"M73/12*'RATES-Non Fed'!$D$48","v":0},null,{"$f":"+'RATES-Non Fed'!K31","v":0.62},{"$f":"P73/12*'RATES-Non Fed'!$D$48","v":0},null,{"$f":"+'RATES-Non Fed'!M31","v":0.62},{"$f":"S73/12*'RATES-Non Fed'!$D$48","v":0},{"$f":"+'RATES-Non Fed'!O31","v":0.62},{"$f":"U73/12*'RATES-Non Fed'!$D$48","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J83:J84)","v":0},null,null,{"$f":"SUM(M83:M84)","v":0},null,null,{"$f":"SUM(P83:P84)","v":0},null,null,{"$f":"SUM(S83:S84)","v":0},null,{"$f":"SUM(U83:U84)","v":0}]

{"sheet":"RATES-Non Fed","index":6,"n_rows":65,"n_cols":49,"rows_kept":65,"cut":false,"hidden":false,"merged":[[13,23,13,35]]}
[]
[null,"Budget Period : ",null,null,"2024-01-01",null,"1930-12-31"]
[null,"Budget Initiation Date (TODAY'S DATE):",null,null,"2024-01-01"]
[]
[null,null,null,null,{"$f":"X16","v":"FY24"},null,{"$f":"Z16","v":"FY25"},null,{"$f":"AB16","v":"FY26"},null,{"$f":"AD16","v":"FY27"},null,{"$f":"AF16","v":"FY28"},null,{"$f":"AH16","v":"FY29"},null,{"$f":"AJ16","v":"FY30"}]
[null,"Fringe Benefit Rates",null,null,{"$f":"\"7/\"&RIGHT(TEXT(W15,\"0\"),2)&\"-6/\"&RIGHT(E5,2)","v":"7/23-6/24"},null,{"$f":"\"7/\"&RIGHT(E5,2)&\"-6/\"&RIGHT(G5,2)","v":"7/24-6/25"},null,{"$f":"\"7/\"&RIGHT(G5,2)&\"-6/\"&RIGHT(I5,2)","v":"7/25-6/26"},null,{"$f":"\"7/\"&RIGHT(I5,2)&\"-6/\"&RIGHT(K5,2)","v":"7/26-6/27"},null,{"$f":"\"7/\"&RIGHT(K5,2)&\"-6/\"&RIGHT(M5,2)","v":"7/27-6/28"},null,{"$f":"\"7/\"&RIGHT(M5,2)&\"-6/\"&RIGHT(O5,2)","v":"7/28-6/29"},null,{"$f":"\"7/\"&RIGHT(O5,2)&\"-6/\"&RIGHT(Q5,2)","v":"7/29-6/30"}]
[null,"Faculty (AAUP)",null,null,{"$f":"HLOOKUP(E$5,$AM$13:$AW$19,2,FALSE)","v":0.307},null,{"$f":"HLOOKUP(G$5,$AM$13:$AW$19,2,FALSE)","v":0.308},null,{"$f":"HLOOKUP(I$5,$AM$13:$AW$19,2,FALSE)","v":0.312},null,{"$f":"HLOOKUP(K$5,$AM$13:$AW$19,2,FALSE)","v":0.314},null,{"$f":"HLOOKUP(M$5,$AM$13:$AW$19,2,FALSE)","v":0.317},null,{"$f":"HLOOKUP(O$5,$AM$13:$AW$19,2,FALSE)","v":0.31900000000000001},null,{"$f":"HLOOKUP(Q$5,$AM$13:$AW$19,2,FALSE)","v":0.32200000000000001}]
[null,"Exmpt Staff (Mnthly)/",null,null,{"$f":"HLOOKUP(E$5,$AM$13:$AW$19,3,FALSE)","v":0.40500000000000003},null,{"$f":"HLOOKUP(G$5,$AM$13:$AW$19,3,FALSE)","v":0.35099999999999998},null,{"$f":"HLOOKUP(I$5,$AM$13:$AW$19,3,FALSE)","v":0.36399999999999999},null,{"$f":"HLOOKUP(K$5,$AM$13:$AW$19,3,FALSE)","v":0.36699999999999999},null,{"$f":"HLOOKUP(M$5,$AM$13:$AW$19,3,FALSE)","v":0.37},null,{"$f":"HLOOKUP(O$5,$AM$13:$AW$19,3,FALSE)","v":0.373},null,{"$f":"HLOOKUP(Q$5,$AM$13:$AW$19,3,FALSE)","v":0.376}]
[null,"Dual Comp Faculty",null,null,{"$f":"HLOOKUP(E$5,$AM$13:$AW$19,4,FALSE)","v":0.45700000000000002},null,{"$f":"HLOOKUP(G$5,$AM$13:$AW$19,4,FALSE)","v":0.42499999999999999},null,{"$f":"HLOOKUP(I$5,$AM$13:$AW$19,4,FALSE)","v":0.442},null,{"$f":"HLOOKUP(K$5,$AM$13:$AW$19,4,FALSE)","v":0.45400000000000001},null,{"$f":"HLOOKUP(M$5,$AM$13:$AW$19,4,FALSE)","v":0.46700000000000003},null,{"$f":"HLOOKUP(O$5,$AM$13:$AW$19,4,FALSE)","v":0.48099999999999998},null,{"$f":"HLOOKUP(Q$5,$AM$13:$AW$19,4,FALSE)","v":0.495}]
[null,"NonExempt Staff (Bi-Weekly)",null,null,{"$f":"HLOOKUP(E$5,$AM$13:$AW$19,5,FALSE)","v":0.437},null,{"$f":"HLOOKUP(G$5,$AM$13:$AW$19,5,FALSE)","v":0.54800000000000004},null,{"$f":"HLOOKUP(I$5,$AM$13:$AW$19,5,FALSE)","v":0.49},null,{"$f":"HLOOKUP(K$5,$AM$13:$AW$19,5,FALSE)","v":0.495},null,{"$f":"HLOOKUP(M$5,$AM$13:$AW$19,5,FALSE)","v":0.5},null,{"$f":"HLOOKUP(O$5,$AM$13:$AW$19,5,FALSE)","v":0.504},null,{"$f":"HLOOKUP(Q$5,$AM$13:$AW$19,5,FALSE)","v":0.50900000000000001}]
[null,"Students (Grad and Undergrad)",null,null,{"$f":"HLOOKUP(E$5,$AM$13:$AW$19,6,FALSE)","v":0.11},null,{"$f":"HLOOKUP(G$5,$AM$13:$AW$19,6,FALSE)","v":8.3000000000000004E-2},null,{"$f":"HLOOKUP(I$5,$AM$13:$AW$19,6,FALSE)","v":8.3000000000000004E-2},null,{"$f":"HLOOKUP(K$5,$AM$13:$AW$19,6,FALSE)","v":8.3000000000000004E-2},null,{"$f":"HLOOKUP(M$5,$AM$13:$AW$19,6,FALSE)","v":8.3000000000000004E-2},null,{"$f":"HLOOKUP(O$5,$AM$13:$AW$19,6,FALSE)","v":8.3000000000000004E-2},null,{"$f":"HLOOKUP(Q$5,$AM$13:$AW$19,6,FALSE)","v":8.3000000000000004E-2}]
[null,"Part-Time Faculty (<65%)/Staff (<80%)/Post Doc",null,null,{"$f":"HLOOKUP(E$5,$AM$13:$AW$19,7,FALSE)","v":0.2},null,{"$f":"HLOOKUP(G$5,$AM$13:$AW$19,7,FALSE)","v":0.19800000000000001},null,{"$f":"HLOOKUP(I$5,$AM$13:$AW$19,7,FALSE)","v":0.19500000000000001},null,{"$f":"HLOOKUP(K$5,$AM$13:$AW$19,7,FALSE)","v":0.19700000000000001},null,{"$f":"HLOOKUP(M$5,$AM$13:$AW$19,7,FALSE)","v":0.19800000000000001},null,{"$f":"HLOOKUP(O$5,$AM$13:$AW$19,7,FALSE)","v":0.2},null,{"$f":"HLOOKUP(Q$5,$AM$13:$AW$19,7,FALSE)","v":0.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blue = Actual Red = Estimates"]
[null,null,null,null,null,null,null,null,null,"`",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate Chart","FY22","FY23","FY24","FY25","FY26","FY27","FY28","FY29","FY30","FY31","FY32"]
[null,"Indirect Cost Rates (on Campus)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(U14)+2000","v":2024},{"$f":"RIGHT(E5,2)","v":"24"},null,null,"Starting Year Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Faculty (AAUP)",0.29099999999999998,0.27800000000000002,0.307,0.308,0.312,0.314,0.317,0.31900000000000001,0.32200000000000001,0.32400000000000001,0.32400000000000001]
[null,"Research Indirect Costs",null,null,{"$f":"HLOOKUP(E$5,$AM$13:$AW$23,9,FALSE)","v":0.62},null,{"$f":"HLOOKUP(G$5,$AM$13:$AW$23,9,FALSE)","v":0.62},null,{"$f":"HLOOKUP(I$5,$AM$13:$AW$23,9,FALSE)","v":0.62},null,{"$f":"HLOOKUP(K$5,$AM$13:$AW$23,9,FALSE)","v":0.62},null,{"$f":"HLOOKUP(M$5,$AM$13:$AW$23,9,FALSE)","v":0.62},null,{"$f":"HLOOKUP(O$5,$AM$13:$AW$23,9,FALSE)","v":0.62},null,{"$f":"HLOOKUP(Q$5,$AM$13:$AW$23,9,FALSE)","v":0.62},null,null,{"$f":"T14+1","v":2025},null,null,{"$f":"X15-1","v":2023},{"$f":"IF(MONTH(E2)>6,YEAR(E2)+1,YEAR(E2))","v":2024},null,{"$f":"X15+1","v":2025},null,{"$f":"Z15+1","v":2026},null,{"$f":"AB15+1","v":2027},null,{"$f":"AD15+1","v":2028},null,{"$f":"AF15+1","v":2029},null,{"$f":"AH15+1","v":2030},null,"Exmpt Staff (Mnthly)/",0.312,0.375,0.40500000000000003,0.35099999999999998,0.36399999999999999,0.36699999999999999,0.37,0.373,0.376,0.379,0.379]
[null,"Instruction Indirect Costs",null,null,{"$f":"HLOOKUP(E$5,$AM$13:$AW$23,10,FALSE)","v":0.56999999999999995},null,{"$f":"HLOOKUP(G$5,$AM$13:$AW$23,10,FALSE)","v":0.56999999999999995},null,{"$f":"HLOOKUP(I$5,$AM$13:$AW$23,10,FALSE)","v":0.56999999999999995},null,{"$f":"HLOOKUP(K$5,$AM$13:$AW$23,10,FALSE)","v":0.56999999999999995},null,{"$f":"HLOOKUP(M$5,$AM$13:$AW$23,10,FALSE)","v":0.56999999999999995},null,{"$f":"HLOOKUP(O$5,$AM$13:$AW$23,10,FALSE)","v":0.56999999999999995},null,{"$f":"HLOOKUP(Q$5,$AM$13:$AW$23,10,FALSE)","v":0.56999999999999995},null,null,2026,null,null,null,{"$f":"\"FY\" & RIGHT(TEXT(X15,\"0\"),2)","v":"FY24"},null,{"$f":"\"FY\" & RIGHT(TEXT(Z15,\"0\"),2)","v":"FY25"},null,{"$f":"\"FY\" & RIGHT(TEXT(AB15,\"0\"),2)","v":"FY26"},null,{"$f":"\"FY\" & RIGHT(TEXT(AD15,\"0\"),2)","v":"FY27"},null,{"$f":"\"FY\" & RIGHT(TEXT(AF15,\"0\"),2)","v":"FY28"},null,{"$f":"\"FY\" & RIGHT(TEXT(AH15,\"0\"),2)","v":"FY29"},null,{"$f":"\"FY\" & RIGHT(TEXT(AJ15,\"0\"),2)","v":"FY30"},null,"Dual Comp Faculty",0.371,0.44400000000000001,0.45700000000000002,0.42499999999999999,0.442,0.45400000000000001,0.46700000000000003,0.48099999999999998,0.495,0.51,0.51]
[null,"Public Service Indirect Costs",null,null,{"$f":"HLOOKUP(E$5,$AM$13:$AW$23,11,FALSE)","v":0.31},null,{"$f":"HLOOKUP(G$5,$AM$13:$AW$23,11,FALSE)","v":0.31},null,{"$f":"HLOOKUP(I$5,$AM$13:$AW$23,11,FALSE)","v":0.31},null,{"$f":"HLOOKUP(K$5,$AM$13:$AW$23,11,FALSE)","v":0.31},null,{"$f":"HLOOKUP(M$5,$AM$13:$AW$23,11,FALSE)","v":0.31},null,{"$f":"HLOOKUP(O$5,$AM$13:$AW$23,11,FALSE)","v":0.31},null,{"$f":"HLOOKUP(Q$5,$AM$13:$AW$23,11,FALSE)","v":0.31},null,null,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NonExempt Staff (Bi-Weekly)",0.372,0.39900000000000002,0.437,0.54800000000000004,0.49,0.495,0.5,0.504,0.50900000000000001,0.51400000000000001,0.51400000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2028,null,null,null,null,null,null,null,null,null,"Initiation Date FY",null,null,null,null,null,null,null,"Students (Grad and Undergrad)",7.1999999999999995E-2,9.1999999999999998E-2,0.11,8.3000000000000004E-2,8.3000000000000004E-2,8.3000000000000004E-2,8.3000000000000004E-2,8.3000000000000004E-2,8.3000000000000004E-2,8.3000000000000004E-2,8.3000000000000004E-2]
[null,"Indirect Cost Rates (off Campus & for Sub-Contracts $25,000 or less)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2029,null,null,null,null,null,null,null,null,null,{"$f":"IF(MONTH(E3)>6,YEAR(E3)+1,YEAR(E3))","v":2024},null,null,null,null,null,null,null,"Part-Time Faculty (<65%)/Staff (<80%)/Post Doc",0.193,0.17899999999999999,0.2,0.19800000000000001,0.19500000000000001,0.19700000000000001,0.19800000000000001,0.2,0.2,0.20100000000000001,0.20100000000000001]
[null,"Research Indirect Costs",null,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,null,2030]
[null,"Instruction Indirect Costs",null,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Research Indirect Costs",0.62,0.62,0.62,0.62,0.62,0.62,0.62,0.62,0.62,0.62,0.62]
[null,"Public Service Indirect Costs",null,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instruction Indirect Costs",0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Service Indirect Costs",0.31,0.31,0.31,0.31,0.31,0.31,0.31,0.31,0.31,0.31,0.31]
[null,"Fringe Benefit Base for Project Period",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,null,null,null,null,"Row Value"]
[null,"Faculty (AAUP)",null,null,{"$f":"IF(X$15 < $T$20, HLOOKUP(X$16,$E$5:$Q$17,$W25,FALSE),$Q7+(0.005 * (X$15 - $T$20)))","v":0.307},null,{"$f":"IF(Z$15 < $T$20, HLOOKUP(Z$16,$E$5:$Q$17,$W25,FALSE),$Q7+(0.005 * (Z$15 - $T$20)))","v":0.308},null,{"$f":"IF(AB$15 < $T$20, HLOOKUP(AB$16,$E$5:$Q$17,$W25,FALSE),$Q7+(0.005 * (AB$15 - $T$20)))","v":0.312},null,{"$f":"IF(AD$15 < $T$20, HLOOKUP(AD$16,$E$5:$Q$17,$W25,FALSE),$Q7+(0.005 * (AD$15 - $T$20)))","v":0.314},null,{"$f":"IF(AF$15 < $T$20, HLOOKUP(AF$16,$E$5:$Q$17,$W25,FALSE),$Q7+(0.005 * (AF$15 - $T$20)))","v":0.317},null,{"$f":"IF(AH$15 < $T$20, HLOOKUP(AH$16,$E$5:$Q$17,$W25,FALSE),$Q7+(0.005 * (AH$15 - $T$20)))","v":0.31900000000000001},null,{"$f":"IF(AJ$15 < $T$20, HLOOKUP(AJ$16,$E$5:$Q$17,$W25,FALSE),$Q7+(0.005 * (AJ$15 - $T$20)))","v":0.32200000000000001},null,null,null,null,null,3]
[null,"Exmpt Staff (Mnthly)/Non-AAUP Faculty",null,null,0.40500000000000003,null,0.35099999999999998,null,0.36399999999999999,null,0.36699999999999999,null,0.37,null,0.373,null,0.376,null,null,null,null,null,4]
[null,"Dual Comp Faculty",null,null,0.45700000000000002,null,0.42499999999999999,null,0.442,null,0.45400000000000001,null,0.46700000000000003,null,0.48099999999999998,null,0.495,null,null,null,null,null,5]
[null,"NonExempt Staff (Bi-Weekly)",null,null,0.437,null,0.54800000000000004,null,0.49,null,0.495,null,0.5,null,0.504,null,0.50900000000000001,null,null,null,null,null,6]
[null,"Students (Grad and Undergrad)",null,null,0.11,null,8.3000000000000004E-2,null,8.3000000000000004E-2,null,8.3000000000000004E-2,null,8.3000000000000004E-2,null,8.3000000000000004E-2,null,8.3000000000000004E-2,null,null,null,null,null,7]
[null,"Part-Time Faculty (<65%)/Staff (<80%)/Post Doc",null,null,0.2,null,0.19800000000000001,null,0.19500000000000001,null,0.19700000000000001,null,0.19800000000000001,null,0.2,null,0.2,null,null,null,null,null,8]
[null,"Research F&A",null,null,{"$f":"IF(X$15 < $T$20, HLOOKUP(X$16,$E$5:$Q$17,$W31,FALSE),$Q15)","v":0.62},null,{"$f":"IF(Z$15 < $T$20, HLOOKUP(Z$16,$E$5:$Q$17,$W31,FALSE),$Q15)","v":0.62},null,{"$f":"IF(AB$15 < $T$20, HLOOKUP(AB$16,$E$5:$Q$17,$W31,FALSE),$Q15)","v":0.62},null,{"$f":"IF(AD$15 < $T$20, HLOOKUP(AD$16,$E$5:$Q$17,$W31,FALSE),$Q15)","v":0.62},null,{"$f":"IF(AF$15 < $T$20, HLOOKUP(AF$16,$E$5:$Q$17,$W31,FALSE),$Q15)","v":0.62},null,{"$f":"IF(AH$15 < $T$20, HLOOKUP(AH$16,$E$5:$Q$17,$W31,FALSE),$Q15)","v":0.62},null,{"$f":"IF(AJ$15 < $T$20, HLOOKUP(AJ$16,$E$5:$Q$17,$W31,FALSE),$Q15)","v":0.62},null,null,null,null,null,11]
[null,"Instruction F&A",null,null,{"$f":"IF(X$15 < $T$20, HLOOKUP(X$16,$E$5:$Q$17,$W32,FALSE),$Q16)","v":0.56999999999999995},null,{"$f":"IF(Z$15 < $T$20, HLOOKUP(Z$16,$E$5:$Q$17,$W32,FALSE),$Q16)","v":0.56999999999999995},null,{"$f":"IF(AB$15 < $T$20, HLOOKUP(AB$16,$E$5:$Q$17,$W32,FALSE),$Q16)","v":0.56999999999999995},null,{"$f":"IF(AD$15 < $T$20, HLOOKUP(AD$16,$E$5:$Q$17,$W32,FALSE),$Q16)","v":0.56999999999999995},null,{"$f":"IF(AF$15 < $T$20, HLOOKUP(AF$16,$E$5:$Q$17,$W32,FALSE),$Q16)","v":0.56999999999999995},null,{"$f":"IF(AH$15 < $T$20, HLOOKUP(AH$16,$E$5:$Q$17,$W32,FALSE),$Q16)","v":0.56999999999999995},null,{"$f":"IF(AJ$15 < $T$20, HLOOKUP(AJ$16,$E$5:$Q$17,$W32,FALSE),$Q16)","v":0.56999999999999995},null,null,null,null,null,12]
[null,"PS F&A",null,null,{"$f":"IF(X$15 < $T$20, HLOOKUP(X$16,$E$5:$Q$17,$W33,FALSE),$Q17)","v":0.31},null,{"$f":"IF(Z$15 < $T$20, HLOOKUP(Z$16,$E$5:$Q$17,$W33,FALSE),$Q17)","v":0.31},null,{"$f":"IF(AB$15 < $T$20, HLOOKUP(AB$16,$E$5:$Q$17,$W33,FALSE),$Q17)","v":0.31},null,{"$f":"IF(AD$15 < $T$20, HLOOKUP(AD$16,$E$5:$Q$17,$W33,FALSE),$Q17)","v":0.31},null,{"$f":"IF(AF$15 < $T$20, HLOOKUP(AF$16,$E$5:$Q$17,$W33,FALSE),$Q17)","v":0.31},null,{"$f":"IF(AH$15 < $T$20, HLOOKUP(AH$16,$E$5:$Q$17,$W33,FALSE),$Q17)","v":0.31},null,{"$f":"IF(AJ$15 < $T$20, HLOOKUP(AJ$16,$E$5:$Q$17,$W33,FALSE),$Q17)","v":0.31},null,null,null,null,null,13]
[null," "]
[null,"PRO-RATED RATES USED"]
[null,null," "," "]
[null,"Fringe Benefit Rates","weight",null,"YEAR 1",null,"YEAR 2",null,"YEAR 3",null,"YEAR 4",null,"YEAR 5",null,"YEAR 6",null,"YEAR 7"]
[null,"Faculty",{"$f":"IF(MONTH($E$2)<7,182-($E$2-DATE(YEAR($E$2),1,1)+1),365-($E$2-DATE(YEAR($E$2),7,1)))","v":181},{"$f":"365-C38","v":184},{"$f":"((E25*$C38)+(G25*$D38))/365","v":0.30750410958904112},null,{"$f":"((G25*$C38)+(I25*$D38))/365","v":0.31001643835616438},null,{"$f":"((I25*$C38)+(K25*$D38))/365","v":0.31300821917808219},null,{"$f":"((K25*$C38)+(M25*$D38))/365","v":0.31551232876712332},null,{"$f":"((M25*$C38)+(O25*$D38))/365","v":0.3180082191780822},null,{"$f":"((O25*$C38)+(Q25*$D38))/365","v":0.32051232876712332},null,{"$f":"((Q25*$C38)+((Q25+0.005)*$D38))/365","v":0.32452054794520546}]
[null,"Exempt Staff (Monthly)",{"$f":"$C$38","v":181},184,{"$f":"((E26*C39)+(G26*D39))/365","v":0.37777808219178083},null,0.35755342465753426,null,0.36551232876712325,null,0.36851232876712331,null,0.37151232876712331,null,0.37451232876712331,null,0.37852054794520545]
[null,"Dual Comp Faculty",{"$f":"$C$38","v":181},184,{"$f":"((E27*C40)+(G27*D40))/365","v":0.44086849315068494},null,0.4335698630136986,null,0.44804931506849316,null,0.46055342465753435,null,0.47405753424657537,null,0.48805753424657533,null,0.49752054794520545]
[null,"NonExempt Staff (Bi-Weekly)",{"$f":"$C$38","v":181},184,{"$f":"((E28*C41)+(G28*D41))/365","v":0.49295616438356166},null,0.51876164383561651,null,0.49252054794520544,null,0.49752054794520545,null,0.50201643835616439,null,0.50652054794520551,null,0.51152054794520552]
[null,"Students (Grad and Undergrad)",{"$f":"$C$38","v":181},184,{"$f":"((E29*C42)+(G29*D42))/365","v":9.6389041095890415E-2},null,8.3000000000000004E-2,null,8.3000000000000004E-2,null,8.3000000000000004E-2,null,8.3000000000000004E-2,null,8.3000000000000004E-2,null,8.5520547945205486E-2]
[null,"P-T Fac(<65%)/Staff(<80%)&Post Doc",{"$f":"$C$38","v":181},184,{"$f":"((E30*C43)+(G30*D43))/365","v":0.19899178082191782},null,0.19648767123287672,null,0.1960082191780822,null,0.1975041095890411,null,0.1990082191780822,null,0.2,null,0.20252054794520552]
[null,"Faculty (ACAD)",{"$f":"IF($E$2-DATE(YEAR($E$2),1,1)+1 > 243, 499-($E$2-DATE(YEAR($E$2),1,1)+1),IF($E$2-DATE(YEAR($E$2),1,1)+1 > 181,255,IF($E$2-DATE(YEAR($E$2),1,1)+1 > 133, 0,134-($E$2-DATE(YEAR($E$2),1,1)+1))))","v":133},{"$f":"255-C44","v":122},{"$f":"((E25*$C44)+(G25*$D44))/255","v":0.30747843137254899},null,{"$f":"((G25*$C44)+(I25*$D44))/255","v":0.30991372549019602},null,{"$f":"((I25*$C44)+(K25*$D44))/255","v":0.31295686274509804},null,{"$f":"((K25*$C44)+(M25*$D44))/255","v":0.31543529411764709},null,{"$f":"((M25*$C44)+(O25*$D44))/255","v":0.31795686274509805},null,{"$f":"((O25*$C44)+(Q25*$D44))/255","v":0.32043529411764704},null,{"$f":"((Q25*$C44)+((Q25+0.005)*$D44))/255","v":0.32439215686274508}]
[null,"Faculty (SUMR)",{"$f":"IF($E$2-DATE(YEAR($E$2),1,1)+1 > 243,48,IF($E$2-DATE(YEAR($E$2),1,1)+1 > 181,292-($E$2-DATE(YEAR($E$2),1,1)+1),IF($E$2-DATE(YEAR($E$2),1,1)+1 > 133, 182-($E$2-DATE(YEAR($E$2),1,1)+1),48)))","v":48},{"$f":"110-C45","v":62},{"$f":"((E25*$C45)+(G25*$D45))/110","v":0.30756363636363637},null,{"$f":"((G25*$C45)+(I25*$D45))/110","v":0.31025454545454545},null,{"$f":"((I25*$C45)+(K25*$D45))/110","v":0.31312727272727275},null,{"$f":"((K25*$C45)+(M25*$D45))/110","v":0.31569090909090908},null,{"$f":"((M25*$C45)+(O25*$D45))/110","v":0.3181272727272727},null,{"$f":"((O25*$C45)+(Q25*$D45))/110","v":0.32069090909090914},null,{"$f":"((Q25*$C45)+((Q25+0.005)*$D45))/110","v":0.32481818181818184}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Indirect Cost Rates (on Campus)",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Research Indirect Costs",{"$f":"$C$38","v":181},{"$f":"365-C48","v":184},{"$f":"((E31*$C48)+(G31*$D48))/365","v":0.62},null,{"$f":"((G31*$C48)+(I31*$D48))/365","v":0.62},null,{"$f":"((I31*$C48)+(K31*$D48))/365","v":0.62},null,{"$f":"((K31*$C48)+(M31*$D48))/365","v":0.62},null,{"$f":"((M31*$C48)+(O31*$D48))/365","v":0.62},null,{"$f":"((O31*$C48)+(Q31*$D48))/365","v":0.62},null,{"$f":"+O48","v":0.62}]
[null,"Instruction Indirect Costs",{"$f":"$C$38","v":181},{"$f":"365-C49","v":184},{"$f":"((E32*$C49)+(G32*$D49))/365","v":0.56999999999999995},null,{"$f":"((G32*$C49)+(I32*$D49))/365","v":0.56999999999999995},null,{"$f":"((I32*$C49)+(K32*$D49))/365","v":0.56999999999999995},null,{"$f":"((K32*$C49)+(M32*$D49))/365","v":0.56999999999999995},null,{"$f":"((M32*$C49)+(O32*$D49))/365","v":0.56999999999999995},null,{"$f":"((O32*$C49)+(Q32*$D49))/365","v":0.56999999999999995},null,{"$f":"+O49","v":0.56999999999999995}]
[null,"Public Service Indirect Costs",{"$f":"$C$38","v":181},{"$f":"365-C50","v":184},{"$f":"((E33*$C50)+(G33*$D50))/365","v":0.31},null,{"$f":"((G33*$C50)+(I33*$D50))/365","v":0.31},null,{"$f":"((I33*$C50)+(K33*$D50))/365","v":0.31},null,{"$f":"((K33*$C50)+(M33*$D50))/365","v":0.31},null,{"$f":"((M33*$C50)+(O33*$D50))/365","v":0.31},null,{"$f":"((O33*$C50)+(Q33*$D50))/365","v":0.31},null,{"$f":"+O50","v":0.31}]
[null,null,null,null,null,null,null,null,null,null," ",null," ",null," ",null," "]
[null,"Indirect Cost Rates (off Campus)",null,null,null,null,null,null,null,null," ",null," ",null," ",null," "]
[null,"Research Indirect Costs",{"$f":"$C$38","v":181},{"$f":"365-C53","v":184},0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26]
[null,"Instruction Indirect Costs",{"$f":"$C$38","v":181},{"$f":"365-C54","v":184},0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26]
[null,"Public Service Indirect Costs",{"$f":"$C$38","v":181},{"$f":"365-C55","v":184},0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26,null,0.26]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Last Revised: 8/17/23"]

{"sheet":"Salary Inflation","index":7,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Inflation Factors"]
["Employee Type","Start Date","FY","Increase",null,"Year 1 Fiscal Year days",null,null,null,null,"ACAD/SUMR Days Per Month"]
["AAUP Faculty","2023-09-01",{"$f":"IF(MONTH(B3)<7,YEAR(B3),YEAR(B3)+1)","v":2024},{"$f":"IF('RATES-Non Fed'!$E$3>=B3,0,0.03)","v":0}]
["AAUP Faculty","2024-09-01",{"$f":"IF(MONTH(B4)<7,YEAR(B4),YEAR(B4)+1)","v":2025},{"$f":"IF('RATES-Non Fed'!$E$3>=B4,0,0.03)","v":0.03},null,"Type","FY","Days",null,null,"Month","ACAD","SUMR","Total"]
["AAUP Faculty","2025-09-01",{"$f":"IF(MONTH(B5)<7,YEAR(B5),YEAR(B5)+1)","v":2026},{"$f":"IF('RATES-Non Fed'!$E$3>=B5,0,0.03)","v":0.03},null,"CAL",{"$f":"RIGHT('RATES-Non Fed'!E5,2)*1+2000","v":2024},{"$f":"'RATES-Non Fed'!C38","v":181},null,null,1,31,0,{"$f":"L5+M5","v":31}]
["AAUP Faculty","2026-09-01",{"$f":"IF(MONTH(B6)<7,YEAR(B6),YEAR(B6)+1)","v":2027},{"$f":"IF('RATES-Non Fed'!$E$3>=B6,0,0.03)","v":0.03},null,"CAL",{"$f":"RIGHT('RATES-Non Fed'!G5,2)*1+2000","v":2025},{"$f":"'RATES-Non Fed'!D38","v":184},null,null,2,28,0,28]
["AAUP Faculty","2027-09-01",2028,{"$f":"IF('RATES-Non Fed'!$E$3>=B7,0,0.03)","v":0.03},null,"ACAD",{"$f":"RIGHT('RATES-Non Fed'!E5,2)*1+2000","v":2024},{"$f":"'RATES-Non Fed'!C44","v":133},null,null,3,31,0,31]
["AAUP Faculty","2028-09-01",2029,{"$f":"IF('RATES-Non Fed'!$E$3>=B8,0,0.03)","v":0.03},null,"ACAD",{"$f":"RIGHT('RATES-Non Fed'!G5,2)*1+2000","v":2025},{"$f":"'RATES-Non Fed'!D44","v":122},null,null,4,30,0,30]
["AAUP Faculty","2029-09-01",2030,{"$f":"IF('RATES-Non Fed'!$E$3>=B9,0,0.03)","v":0.03},null,"SUMR",{"$f":"RIGHT('RATES-Non Fed'!E5,2)*1+2000","v":2024},{"$f":"'RATES-Non Fed'!C45","v":48},null,null,5,13,18,31]
["AAUP Faculty","2030-09-01",2031,{"$f":"IF('RATES-Non Fed'!$E$3>=B10,0,0.02)","v":0.02},null,"SUMR",{"$f":"RIGHT('RATES-Non Fed'!G5,2)*1+2000","v":2025},{"$f":"'RATES-Non Fed'!D45","v":62},null,null,6,0,30,30]
["Staff/Students","2023-07-01",2024,{"$f":"IF('RATES-Non Fed'!$E$3>=B11,0,0.02)","v":0},null,"Ex Staff",{"$f":"RIGHT('RATES-Non Fed'!E5,2)*1+2000","v":2024},{"$f":"'RATES-Non Fed'!C39","v":181},null,null,7,0,31,31]
["Staff/Students","2024-07-01",2025,0.03,null,"Ex Staff",{"$f":"RIGHT('RATES-Non Fed'!G5,2)*1+2000","v":2025},{"$f":"'RATES-Non Fed'!D39","v":184},null,null,8,0,31,31]
["Staff/Students","2025-07-01",2026,{"$f":"IF('RATES-Non Fed'!$E$3>=B13,0,0.02)","v":0.02},null,"Dual Comp",{"$f":"RIGHT('RATES-Non Fed'!E5,2)*1+2000","v":2024},{"$f":"'RATES-Non Fed'!C40","v":181},null,null,9,30,0,30]
["Staff/Students","2026-07-01",2027,{"$f":"IF('RATES-Non Fed'!$E$3>=B14,0,0.02)","v":0.02},null,"Dual Comp",{"$f":"RIGHT('RATES-Non Fed'!G5,2)*1+2000","v":2025},{"$f":"'RATES-Non Fed'!D40","v":184},null,null,10,31,0,31]
["Staff/Students","2027-07-01",2028,{"$f":"IF('RATES-Non Fed'!$E$3>=B15,0,0.02)","v":0.02},null,null,null,null,null,null,11,30,0,30]
["Staff/Students","2028-07-01",2029,{"$f":"IF('RATES-Non Fed'!$E$3>=B16,0,0.02)","v":0.02},null,null,null,null,null,null,12,31,0,31]
["Staff/Students","2029-07-01",2030,{"$f":"IF('RATES-Non Fed'!$E$3>=B17,0,0.02)","v":0.02},null,null,null,null,null,null,"Total",{"$f":"SUM(L5:L16)","v":255},{"$f":"SUM(M5:M16)","v":110},{"$f":"SUM(N5:N16)","v":365}]
["Dual Comp Faculty","2023-07-01",2024,{"$f":"IF('RATES-Non Fed'!$E$3>=B18,0,0.02)","v":0}]
["Dual Comp Faculty","2024-07-01",2025,{"$f":"IF('RATES-Non Fed'!$E$3>=B19,0,0.02)","v":0.02}]
["Dual Comp Faculty","2025-07-01",2026,{"$f":"IF('RATES-Non Fed'!$E$3>=B20,0,0.02)","v":0.02}]
["Dual Comp Faculty","2026-07-01",2027,{"$f":"IF('RATES-Non Fed'!$E$3>=B21,0,0.02)","v":0.02}]
["Dual Comp Faculty","2027-07-01",2028,{"$f":"IF('RATES-Non Fed'!$E$3>=B22,0,0.02)","v":0.02}]
["Dual Comp Faculty","2028-07-01",2029,{"$f":"IF('RATES-Non Fed'!$E$3>=B23,0,0.02)","v":0.02}]
["Dual Comp Faculty","2029-07-01",2030,{"$f":"IF('RATES-Non Fed'!$E$3>=B24,0,0.02)","v":0.02}]
[]
[]
[]
[]
["EE Type","Year 1 Inc","Year 2 Inc","Year 3 Inc","Year 4 Inc","Year 5 Inc"]
["CAL Faculty",{"$f":"IF('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19>1,(1+N41+N42)*(1.03^('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19-1))-1,N41+N42)","v":0},{"$f":"(VLOOKUP((G5+1),$C$4:$D$10,2,FALSE)*H11+VLOOKUP((G6+1),$C$4:$D$10,2,FALSE)*H12)/365","v":0.03},{"$f":"C30","v":0.03},{"$f":"D30","v":0.03},{"$f":"E30","v":0.03}]
["ACAD Faculty",{"$f":"IF('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19>1,(1+N41)*(1.03^('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19-1))-1,O41)","v":0},{"$f":"(VLOOKUP((G7+1),$C$4:$D$10,2,FALSE)*H12+VLOOKUP((G8+1),$C$4:$D$10,2,FALSE)*H13)/365","v":0.03},{"$f":"C31","v":0.03},{"$f":"D31","v":0.03},0.03]
["SUMR Faculty",{"$f":"IF('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19>1,(1+N42)*(1.03^('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19-1))-1,O42)","v":0},{"$f":"(VLOOKUP((G9+1),$C$4:$D$10,2,FALSE)*H13+VLOOKUP((G10+1),$C$4:$D$10,2,FALSE)*H14)/365","v":0.03},0.03,{"$f":"D32","v":0.03},0.03]
["Staff/Students",{"$f":"IF('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19>1,(1+$O$43)*(1.02^('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19-1))-1,$O$43)","v":5.1000000000000004E-3},{"$f":"(VLOOKUP((G11+1),$C$11:$D$17,2,FALSE)*H11+VLOOKUP((G12+1),$C$11:$D$17,2,FALSE)*H12)/365","v":2.495890410958904E-2},2.495890410958904E-2,{"$f":"D33","v":2.495890410958904E-2},2.495890410958904E-2]
["Dual Comp Fac",{"$f":"IF('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19>1,(1+$O$44)*(1.02^('RATES-Non Fed'!$X$15-'RATES-Non Fed'!$AD$19-1))-1,$O$44)","v":5.1000000000000004E-3},{"$f":"(VLOOKUP((G13+1),$C$11:$D$17,2,FALSE)*H11+VLOOKUP((G14+1),$C$11:$D$17,2,FALSE)*H12)/365","v":2.495890410958904E-2},2.495890410958904E-2,{"$f":"D34","v":2.495890410958904E-2},2.495890410958904E-2]
[]
[]
[]
["ACAD/SUMR Increases"]
["Date - Y1","2023-09-01",{"$f":"IF(MONTH(B39)=12,DATE(YEAR(B39)+1,1,1),DATE(YEAR(B39),MONTH(B39)+1,1))","v":"2023-10-01"},"2023-11-01",{"$f":"IF(MONTH(D39)=12,DATE(YEAR(D39)+1,1,1),DATE(YEAR(D39),MONTH(D39)+1,1))","v":"2023-12-01"},{"$f":"IF(MONTH(E39)=12,DATE(YEAR(E39)+1,1,1),DATE(YEAR(E39),MONTH(E39)+1,1))","v":"2024-01-01"},"2024-02-01","2024-03-01",{"$f":"IF(MONTH(H39)=12,DATE(YEAR(H39)+1,1,1),DATE(YEAR(H39),MONTH(H39)+1,1))","v":"2024-04-01"},"2024-05-01","2024-06-01","2024-07-01","2024-08-01"]
["FY",{"$f":"IF(MONTH(B39)>6,YEAR(B39)+1,YEAR(B39))","v":2024},2024,2024,2024,2024,2024,2024,2024,2024,2024,2025,2025,"NAV of Inc","Value"]
["ACAD Inc",{"$f":"IF(MONTH(B$39)<5,VLOOKUP(B$39,$B$3:$D$10,3,TRUE),IF(MONTH(B$39)=5,VLOOKUP(B$39,$B$3:$D$10,3,TRUE)*13/31,IF(MONTH(B$39)<9,0,VLOOKUP(B$39,$B$3:$D$10,3,TRUE))))+B47","v":0},{"$f":"IF(MONTH(C$39)<5,VLOOKUP(C$39,$B$3:$D$10,3,TRUE),IF(MONTH(C$39)=5,VLOOKUP(C$39,$B$3:$D$10,3,TRUE)*13/31,IF(MONTH(C$39)<9,0,VLOOKUP(C$39,$B$3:$D$10,3,TRUE))))+IF(MONTH(C$39)<5,C$47,IF(MONTH(C$39)=5,C$47*13/31,IF(MONTH(C$39)<9,0,C$47)))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B41:M41)/12","v":0},{"$f":"ROUND((1/0.702)*N41,4)","v":0}]
["SUMR Inc",{"$f":"IF(MONTH(B$39)<5,0,IF(MONTH(B$39)=5,VLOOKUP(B$39,$B$3:$D$10,3,TRUE)*18/31,IF(MONTH(B$39)<9,VLOOKUP(B$39,$B$3:$D$10,3,TRUE),0)))","v":0},{"$f":"IF(MONTH(C$39)<5,0,IF(MONTH(C$39)=5,VLOOKUP(C$39,$B$3:$D$10,3,TRUE)*18/31,IF(MONTH(C$39)<9,VLOOKUP(C$39,$B$3:$D$10,3,TRUE),0)))+IF(MONTH(C$39)<5,0,IF(MONTH(C$39)=5,C$47*18/31,IF(MONTH(C$39)<9,C$47,0)))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B42:M42)/12","v":0},{"$f":"ROUND((1/0.298)*N42,4)","v":0}]
["Staff/Stu Inc",{"$f":"VLOOKUP(B$39,$B$11:$D$17,3,TRUE)*VLOOKUP(MONTH(B$39),$K$5:$N$16,4,FALSE)/365","v":0},{"$f":"(VLOOKUP(C$39,$B$11:$D$17,3,TRUE)*VLOOKUP(MONTH(C$39),$K$5:$N$16,4,FALSE)/365)+C48","v":0},0,0,0,0,0,0,0,0,2.5479452054794518E-3,2.5479452054794518E-3,null,{"$f":"ROUND(SUM(B43:M43),4)","v":5.1000000000000004E-3}]
["Dual Comp Inc",{"$f":"VLOOKUP(B$39,$B$18:$D$24,3,TRUE)*VLOOKUP(MONTH(B$39),$K$5:$N$16,4,FALSE)/365","v":0},{"$f":"(VLOOKUP(C$39,$B$11:$D$17,3,TRUE)*VLOOKUP(MONTH(C$39),$K$5:$N$16,4,FALSE)/365)+C49","v":0},0,0,0,0,0,0,0,0,2.5479452054794518E-3,2.5479452054794518E-3,null,{"$f":"ROUND(SUM(B44:M44),4)","v":5.1000000000000004E-3}]
[]
[]
["Faculty Kicker",null,{"$f":"IF(MONTH(C$39)=9,B42,0)+B47","v":0},{"$f":"IF(MONTH(D$39)=9,C42,0)+C47","v":0},{"$f":"IF(MONTH(E$39)=9,D42,0)+D47","v":0},{"$f":"IF(MONTH(F$39)=9,E42,0)+E47","v":0},0,0,0,0,0,0,0]
["Staff Kicker",null,{"$f":"IF(MONTH(C$39)=7,B43,0)+B48","v":0},0,0,{"$f":"IF(MONTH(F$39)=7,E43,0)+E48","v":0},0,0,0,0,0,0,0]
["Dual Comp Kicker",null,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"NIH sal cap info","index":8,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,3,38,4],[38,7,38,8],[8,2,8,3],[32,0,34,5],[32,6,34,7],[32,8,34,8],[36,0,36,2],[36,3,36,4]]}
[null,null,null,null,"Effective Dates",null,"NIH Annual Limitation","Limitation Based on 9 Month Appt.","Recess Cap"]
["DHHS Salary Caps"]
[null,null,null,null,"o  October 1, 1998 through December 31, 1999 ",null,125900,77476.92307692302,33896.153846153822]
["NIH1",null,62.6,null,"o  January 1, 2000 and beyond",null,130200,80123.076923076864,35053.846153846127]
[]
[null,null,null,null,"FY 2000 Awards  (Executive Level II)"]
["NIH2",null,65.72,null,"o  October 1, 1999 through December 31, 1999",null,136700,84123.076923076864,36803.846153846127]
["NIH3",null,67.930000000000007,null,"o  January 1, 2000 and beyond",null,141300,86953.846153846098,38042.307692307666]
["NIH4",null,69.760000000000005]
[null,null,null,null,"FY 2001 Awards  (Executive Level I)"]
["NIH5",null,75.48,null,"o  October 1, 2000 through December 31, 2000",null,157000,96615.384615384552,42269.230769230744]
["NIH6",null,77.5,null,"o  January 1, 2001 though December 31, 2001",null,161200,99199.999999999927,43399.999999999971]
["NIH7",null,80.14,null,"o  January 1, 2002 through December 31, 2002",null,166700,102584.61538461532,44880.769230769205]
["NIH8",null,82.64,null,"o  January 1, 2003 through December 31, 2003",null,171900,105784.61538461532,46280.769230769205]
["NIH9",null,83.89,null,"o  January 1, 2004 - March 3, 2004",null,174500,107384.61538461532,46980.769230769205]
["NIH9",null,84.47,null,"o  March 2, 2004 through December 31, 2004",null,175700,108123.07692307685,47303.84615384612]
[]
["NIH10",null,86.59,null,"o  January 1, 2005 and beyond ",null,180100,110830.76923076916,48488.46153846151]
["NIH11",null,88.22,null,"o  January 1, 2006 and beyond ",null,183500,112923.07692307685,49403.84615384612]
["NIH12",null,89.71,null,"o  January 1, 2007 and beyond ",null,186600,114830.76923076916,50238.46153846151]
[null,null,91.97,null,"o  January 1, 2008 to December 31, 2008",null,191300,{"$f":"G21*0.615384615384615","v":117723.07692307685},{"$f":"+H21*0.4375","v":51503.84615384612}]
[null,null,94.57,null,"o  January 1, 2009 to December 31, 2009",null,196700,121046.15384615377,52957.692307692276]
[null,null,96.01,null,"o  January 1, 2010 to December 23, 2011",null,199700,122892.30769230762,53765.384615384581]
[null,null,86.39,null,"o  December 24, 2011 to January 11, 2014",null,179700,110584.61538461532,48380.769230769205]
[null,null,87.26,null,"o  January 12, 2014 to January 10, 2015",null,181500,111692.30769230762,48865.384615384581]
[null,null,{"$f":"SUM((G26/52)/40)","v":88.125},null,"o  January 11, 2015 to January 09, 2016",null,183300,112799.99999999993,49349.999999999971]
[null,null,89.90384615384616,null,"o  January 8, 2017 to January 6, 2018",null,187000,{"$f":"G27*0.615384615384615","v":115076.92307692301},{"$f":"+H27*0.4375","v":50346.153846153815}]
[null,null,91.15384615384616,null,"o  January 7, 2018 and January 5, 2019",null,189600,{"$f":"G28*0.615384615384615","v":116676.92307692301},{"$f":"+H28*0.4375","v":51046.153846153815}]
[null,null,92.451923076923066,null,"o  January 6, 2019 to January 4, 2020",null,192300,{"$f":"G29*0.615384615384615","v":118338.46153846146},{"$f":"+H29*0.4375","v":51773.076923076886}]
[null,null,94.855769230769226,null,"o  January 5, 2020 to January 2, 2021",null,197300,{"$f":"G30*0.615384615384615","v":121415.38461538454},{"$f":"+H30*0.4375","v":53119.230769230737}]
[null,null,95.817307692307693,null,"o  January 3, 2021 and Beyond",null,199300,{"$f":"G31*0.615384615384615","v":122646.15384615377},{"$f":"+H31*0.4375","v":53657.692307692276}]
[]
["The typical appointment for non-Medical College faculty is 32 weeks, usually referred to as \"9 month\" or \"academic year\". Per the AAUP agreement they may also earn an additional 14 weeks of salary during their recess period, typically the summer quarter. ",null,null,null,null,null,"Academic and Recess cap together ",null,{"$f":"H31+I31","v":176303.84615384604}]
[]
[]
[]
["Enter 32 week salary base here"]
[]
[null,null,"recess period base",{"$f":"D37/33*14","v":0},null,null,null,"Last Revised: 5/7/21"]

{"sheet":"PM Conversion Chart","index":9,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[42,11,42,13],[5,0,5,1],[6,0,6,1],[5,12,5,13],[6,12,6,13],[5,3,5,4],[6,3,6,4],[5,6,5,7],[6,6,6,7],[5,9,5,10],[6,9,6,10]]}
[null,null,null,null,null,null,null,"Percent of Time & Effort to Person Months (PM)"]
[null,null,null,null,null,null,null,"Interactive Conversion Table for the University of Cincinnati"]
[]
[]
[]
["EXC",null,null,"9 Month",null,null,"12 Month"]
["Recess",null,null,"Academic Year",null,null,"Calendar Year"]
[]
["  % effort ","         PM",null," % effort","PM",null,"  % effort","        PM"]
[]
[1,{"$f":"15.65*A11/4.3333","v":3.6115662428172524},null,{"$f":"A11","v":1},{"$f":"36.35*D11/4.3333","v":8.3885260655851202},null,{"$f":"A11","v":1},{"$f":"52*G11/4.3333","v":12.000092308402371}]
[]
[]
["Instructions:"]
[]
["To use the chart simply insert the percent effort that you want to convert into the -0- of the Recess % effort line and"]
["hit enter.  The person month 9 and 12 will be displayed simultaneously."]

{"sheet":"Ref","index":10,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Please DO NOT change any information on this sheet."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ACAD","Academic"]
[null,null,"CAL","Calendar"]

{"sheet":"Kuali","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}