{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["NIH Salary Cap Calculator","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":53,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NIH Salary Cap Calculator","index":0,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,1,55,2],[27,1,28,2],[30,1,31,2],[33,1,34,2],[36,1,37,2],[39,1,40,2],[42,1,43,2],[45,1,46,2],[48,1,49,2],[51,1,52,2],[14,7,14,9],[16,9,16,10],[8,8,8,9],[27,5,28,5],[27,6,27,7],[28,6,28,7],[23,1,23,12],[27,4,28,4],[27,3,28,3],[30,5,31,5],[33,4,34,4],[33,5,34,5],[36,4,37,4],[36,5,37,5],[54,3,55,3],[30,4,31,4],[39,3,40,3],[42,3,43,3],[45,3,46,3],[48,3,49,3],[51,3,52,3],[30,3,31,3],[33,3,34,3],[36,3,37,3],[30,6,30,7],[31,6,31,7],[33,6,33,7],[34,6,34,7],[36,6,36,7],[37,6,37,7],[39,6,39,7],[40,6,40,7],[52,6,52,7],[54,6,54,7],[51,6,51,7],[55,6,55,7],[42,6,42,7],[43,6,43,7],[45,6,45,7],[46,6,46,7],[48,6,48,7],[57,1,58,10],[22,1,22,2],[48,4,49,4],[48,5,49,5],[51,4,52,4],[51,5,52,5],[54,4,55,4],[54,5,55,5],[39,4,40,4],[39,5,40,5],[42,4,43,4],[42,5,43,5],[45,4,46,4],[24,1,25,2],[45,5,46,5],[49,6,49,7],[1,2,2,10],[24,3,25,3],[24,4,25,4],[24,5,25,5],[24,6,24,7],[25,6,25,7],[18,2,18,3],[18,4,18,5],[16,1,16,3],[22,6,22,7],[5,10,5,12],[8,4,8,6],[12,4,12,7],[14,4,14,5],[16,4,16,7],[10,6,10,7]]}
[]
[null,null,"NIH/DHHS\nSALARY CAP CALCULATOR"]
[]
[]
[]
[null,"STEP 1. Enter data in yellow highlighted cells.",null,null,null,null,null,null,null,null,"Current NIH Salary Cap"]
[null,"STEP 2. Review results in gray cells for use in iForms to properly reflect required cost sharing."]
[]
[null,null,null,"Name of Individual: ab","Mickey Mouse",null,null,"DUID:ab",110110]
[]
[null,null,null,"Type of Appointment: ab",12,null,{"$f":"VLOOKUP(Appointment_Type,Sheet2!A2:B4,2,FALSE)","v":"Calendar"}]
[]
[null,null,null,"Position Type:ab","Regular Rank Tenure/Tenure-Track Faculty"]
[]
[null,null,null,"Institutional Base Salary (IBS):ab",250000,null,null,{"$f":"VLOOKUP(Appointment_Type,IBS_Message,2,FALSE)","v":"Enter Full Time Institutional Base Salary"}]
[]
[null,"Choose Salary Cap Time Frame:ab",null,null,"Level II   01/06/2019 - until changed",null,null,null,null,{"$f":"VLOOKUP(Level,Sheet2!A11:C17,3,FALSE)","v":192300}]
[]
[null,null,"Effective Date:ab ",null,"2018-02-01"]
[]
[]
[]
[null,"WBSE",null,"Project Type","Total % Effort*","DHHS Federal / Federal Prime*","Effort G/Ls",null,null,"% Effort",{"$f":"Sheet2!B7&\" Amount\"","v":"Calendar Year Amount"},null,{"$f":"IF(Appointment_Type=1,\"\",\"Monthly Amount\")","v":"Monthly Amount"}]
[null,"EXAMPLE:"]
[null,"A030000",null,"Research",0.15,"Yes","A030000 - 603600",null,"Direct Cost",0.14000000000000001,{"$f":"IF($E$15<$J$17,ROUNDUP(+$J$17*E25,2),ROUNDUP(+Salary_Cap*E25,2))","v":28845},{"$f":"IBS_Full*Effort_1","v":0},{"$f":"IF(Appointment_Type=1,\"\",SUM(K25/Appointment_Type))","v":2403.75}]
[null,null,null,null,null,null,"A030000 - 603400",null,"Cost Share",0.01,{"$f":"IF($E$15<$J$17,0,ROUNDUP(+IBS_Full*E25,2)-K25)","v":8655},{"$f":"SUM(L25-I26-J26)","v":{"$error":"#VALUE!"}},{"$f":"IF(Appointment_Type=1,\"\",SUM(K26/Appointment_Type))","v":721.25}]
[]
[null,null,null,"Research",0,"Yes",{"$f":"Sheet2!C21","v":" - 603600"},null,"Direct Cost",{"$f":"Sheet2!D21","v":0},{"$f":"Sheet2!E21","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q21)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Federal_1=\"Yes\",Sheet2!C22,\"\")","v":" - 603400"},null,"Cost Share",{"$f":"Sheet2!D22","v":0},{"$f":"IF(F28=\"Yes\",Sheet2!E22,\"\")","v":0},null,{"$f":"IF(Federal_1=\"Yes\",Sheet2!Q22,\"\")","v":0}]
[]
[null,null,null,"Non-Research",0,"No",{"$f":"Sheet2!C23","v":" - 603700"},null,"Direct Cost",{"$f":"Sheet2!D23","v":0},{"$f":"Sheet2!E23","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q23)","v":0}]
[null,null,null,null,null,null,{"$f":"Sheet2!C24","v":" "},null,"Cost Share",{"$f":"Sheet2!D24","v":""},{"$f":"IF(F31=\"Yes\",Sheet2!E24,\" \")","v":" "},null,{"$f":"IF(Federal_2=\"Yes\",Sheet2!Q24,\"\")","v":""}]
[]
[null,null,null,"Non-Research",0,"No",{"$f":"Sheet2!C25","v":" - 603700"},null,"Direct Cost",{"$f":"Sheet2!D25","v":0},{"$f":"Sheet2!E25","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q25)","v":0}]
[null,null,null,null,null,null,{"$f":"Sheet2!C26","v":" "},null,"Cost Share",{"$f":"Sheet2!D26","v":""},{"$f":"IF(F34=\"Yes\",Sheet2!E26,\" \")","v":" "},null,{"$f":"IF(Federal_3=\"Yes\",Sheet2!Q26,\"\")","v":""}]
[]
[null,null,null,"Research",0,"No",{"$f":"Sheet2!C27","v":" - 603600"},null,"Direct Cost",{"$f":"Sheet2!D27","v":0},{"$f":"Sheet2!E27","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q27)","v":0}]
[null,null,null,null,null,null,{"$f":"Sheet2!C28","v":" "},null,"Cost Share",{"$f":"Sheet2!D28","v":""},{"$f":"IF(F37=\"Yes\",Sheet2!E28,\" \")","v":" "},null,{"$f":"IF(Federal_4=\"Yes\",Sheet2!Q28,\"\")","v":""}]
[]
[null,null,null,"Research",0,"No",{"$f":"Sheet2!C29","v":" - 603600"},null,"Direct Cost",{"$f":"Sheet2!D29","v":0},{"$f":"Sheet2!E29","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q29)","v":0}]
[null,null,null,null,null,null,{"$f":"Sheet2!C30","v":" "},null,"Cost Share",{"$f":"Sheet2!D30","v":""},{"$f":"IF(F40=\"Yes\",Sheet2!E30,\" \")","v":" "},null,{"$f":"IF(Federal_5=\"Yes\",Sheet2!Q30,\"\")","v":""}]
[]
[null,null,null,"Research",0,"No",{"$f":"Sheet2!C31","v":" - 603600"},null,"Direct Cost",{"$f":"Sheet2!D31","v":0},{"$f":"Sheet2!E31","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q31)","v":0}]
[null,null,null,null,null,null,{"$f":"Sheet2!C32","v":" "},null,"Cost Share",{"$f":"Sheet2!D32","v":""},{"$f":"IF(F43=\"Yes\",Sheet2!E32,\" \")","v":" "},null,{"$f":"IF(Federal_6=\"Yes\",Sheet2!Q32,\"\")","v":""}]
[]
[null,null,null,"Research",0,"No",{"$f":"Sheet2!C33","v":" - 603600"},null,"Direct Cost",{"$f":"Sheet2!D33","v":0},{"$f":"Sheet2!E33","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q33)","v":0}]
[null,null,null,null,null,null,{"$f":"Sheet2!C34","v":" "},null,"Cost Share",{"$f":"Sheet2!D34","v":""},{"$f":"IF(F46=\"Yes\",Sheet2!E34,\" \")","v":" "},null,{"$f":"IF(Federal_7=\"Yes\",Sheet2!Q34,\"\")","v":""}]
[]
[null,null,null,"Research",0,"No",{"$f":"Sheet2!C35","v":" - 603600"},null,"Direct Cost",{"$f":"Sheet2!D35","v":0},{"$f":"Sheet2!E35","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q35)","v":0}]
[null,null,null,null,null,null,{"$f":"Sheet2!C36","v":" "},null,"Cost Share",{"$f":"Sheet2!D36","v":""},{"$f":"IF(F49=\"Yes\",Sheet2!E36,\" \")","v":" "},null,{"$f":"IF(Federal_8=\"Yes\",Sheet2!Q36,\"\")","v":""}]
[]
[null,null,null,"Research",0,"No",{"$f":"Sheet2!C37","v":" - 603600"},null,"Direct Cost",{"$f":"Sheet2!D37","v":0},{"$f":"Sheet2!E37","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q37)","v":0}]
[null,null,null,null,null,null,{"$f":"Sheet2!C38","v":" "},null,"Cost Share",{"$f":"Sheet2!D38","v":""},{"$f":"IF(F52=\"Yes\",Sheet2!E38,\" \")","v":" "},null,{"$f":"IF(Federal_9=\"Yes\",Sheet2!Q38,\"\")","v":""}]
[]
[null,null,null,"Research",0,"No",{"$f":"Sheet2!C39","v":" - 603600"},null,"Direct Cost",{"$f":"Sheet2!D39","v":0},{"$f":"Sheet2!E39","v":0},null,{"$f":"IF(Appointment_Type=1,\"\",Sheet2!Q39)","v":0}]
[null,null,null,null,null,null,{"$f":"Sheet2!C40","v":" "},null,"Cost Share",{"$f":"Sheet2!D40","v":""},{"$f":"IF(F55=\"Yes\",Sheet2!E40,\" \")","v":" "},null,{"$f":"IF(Federal_10=\"Yes\",Sheet2!Q40,\"\")","v":""}]
[]
[null,"*All DHHS operating divisions except the FDA (funded under the USDA appropriations bill) are under the salary cap requirement."]

{"sheet":"Sheet2","index":1,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,1],[8,0,8,1]]}
["Type of Appointment",null,null,"Description",12,9,1,null,null,"Position","Direct","Cost Share-Research","Cost Share-Non-Research"]
[12,"Calendar",null,"Level II   01/06/2019 - until changed",192300,144225,{"$f":"+F2/9","v":16025},null,null,"Regular Rank Tenure/Tenure-Track Faculty",603600,603400,603300]
[9,"Academic",null,"Level II   01/07/2018 - 01/05/2019",189600,142200,15800,null,null,"Regular Rank Non-Tenure Track Faculty",602600,600400,600300]
[1,"Summer Supplement",null,"Level II   01/08/2017 - 01/06/2018",187000,140250,{"$f":"+F4/9","v":15583.333333333334},null,null,"Non-Regular Rank Faculty",602600,600400,600300]
[null,null,null,"Level II   01/10/2016 - 01/07/2017",185100,138825,15425,null,null,"Monthly Exempt Staff",601600,600400,600300]
[null,null,null,"Level II   01/11/2015 - 01/09/2016",183300,137475,15275]
[{"$f":"Appointment_Type","v":12},{"$f":"VLOOKUP(A7,H9:I11,2,FALSE)","v":"Calendar Year"},null,"Level II   01/12/2014 - 01/10/2015",181500,136125,15125,null,null,"Research"]
[null,null,null,"Level II   12/23/2011 - 01/11/2015",179700,134775,14975,null,null,"Non-Research"]
[{"$f":"Level","v":"Level II   01/06/2019 - until changed"},null,{"$f":"IFERROR(INDEX($E$1:$E$8,SMALL(IF($A9=$G$1:$G$8,ROW($F$1:$F$8)-MIN(ROW($A$7))+1,\"\"),COLUMN()-4)), \"\")","v":""},null,null,null,null,12,"Calendar Year"]
[null,null,null,{"$f":"IBS_Full","v":250000},"Full IBS",null,null,9,"Academic Year",null,"Direct","Cost Share"]
[{"$f":"D2","v":"Level II   01/06/2019 - until changed"},null,{"$f":"HLOOKUP($A$7,$E$1:$G$8,2,FALSE)","v":192300},{"$f":"Salary_Cap","v":192300},"Salary Cap Amount",null,null,1,"Summer Supplement",{"$f":"J2&\"-\"&J7","v":"Regular Rank Tenure/Tenure-Track Faculty-Research"},603600,603400]
[{"$f":"D3","v":"Level II   01/07/2018 - 01/05/2019"},null,{"$f":"HLOOKUP($A$7,$E$1:$G$8,3,FALSE)","v":189600},null,null,null,null,null,null,{"$f":"J2&\"-\"&J8","v":"Regular Rank Tenure/Tenure-Track Faculty-Non-Research"},603700,603300]
[{"$f":"D4","v":"Level II   01/08/2017 - 01/06/2018"},null,{"$f":"HLOOKUP($A$7,$E$1:$G$8,4,FALSE)","v":187000},12,"Enter Full Time Institutional Base Salary",null,null,null,null,{"$f":"J3&\"-\"&J7","v":"Regular Rank Non-Tenure Track Faculty-Research"},602600,600400]
[{"$f":"D5","v":"Level II   01/10/2016 - 01/07/2017"},null,{"$f":"HLOOKUP($A$7,$E$1:$G$8,5,FALSE)","v":185100},9,"Enter Full Time Institutional Base Salary",null,null,null,null,{"$f":"J3&\"-\"&J8","v":"Regular Rank Non-Tenure Track Faculty-Non-Research"},602700,600300]
[{"$f":"D6","v":"Level II   01/11/2015 - 01/09/2016"},null,{"$f":"HLOOKUP($A$7,$E$1:$G$8,6,FALSE)","v":183300},1,"Summer-Enter ONE month Salary",null,null,null,null,{"$f":"J4&\"-\"&J7","v":"Non-Regular Rank Faculty-Research"},602600,600400]
["Level II   01/12/2014 - 01/10/2015",null,{"$f":"HLOOKUP($A$7,$E$1:$G$8,7,FALSE)","v":181500},null,null,null,null,null,null,{"$f":"J4&\"-\"&J8","v":"Non-Regular Rank Faculty-Non-Research"},602700,600300]
["Level II   12/23/2011 - 01/11/2015",null,{"$f":"HLOOKUP($A$7,$E$1:$G$8,8,FALSE)","v":179700},"Yes","Y",null,null,null,null,{"$f":"J5&\"-\"&J7","v":"Monthly Exempt Staff-Research"},601600,600400]
[null,null,null,"No","N",null,null,null,null,{"$f":"J5&\"-\"&J8","v":"Monthly Exempt Staff-Non-Research"},601900,600300]
[]
["WBSE","Total % EFFORT on Project*",null,null,null,"Direct Charge \n(% and $)","Cost Share\n(% and $)",null,null,null,null,null,"Fed Prime?","Salary Over Cap?",null,"Appointment","Monthly"]
[{"$f":"WBSE_1","v":0},{"$f":"Effort_1","v":0},{"$f":"IF(M21=\"Y\",WBSE_1&\" - \"&K22,WBSE_1&\" - \"&K22)","v":" - 603600"},{"$f":"IF(M21=\"Y\",F21,B21)","v":0},{"$f":"IF(M21=\"Y\",F22,I21)","v":0},{"$f":"ROUNDDOWN(+$H21/IBS_Full*100,1)/100","v":0},{"$f":"IF(H22>0,ROUNDUP(+$H22/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_1,2),ROUNDUP(+Salary_Cap*Effort_1,2))","v":0},{"$f":"IBS_Full*Effort_1","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_1,Federal_Prime,2,FALSE)","v":"Y"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M21&N21","v":"YY"},{"$f":"$A$7","v":12},{"$f":"IF(P21=1,\"\",SUM(F22/P21))","v":0}]
[null,null,{"$f":"IF(O21=\"YY\",WBSE_1&\" - \"&L22,\" \")","v":" - 603400"},{"$f":"IF(O21=\"YY\",G21,\"\")","v":0},{"$f":"IF(O21=\"YY\",G22,\"\")","v":0},{"$f":"ROUND(+IBS_Full*F21,2)","v":0},{"$f":"IF(H22>0,ROUND(+IBS_Full*G21,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_1,2)-H21)","v":0},{"$f":"SUM(I21-F22-G22)","v":0},{"$f":"Rank&\"-\"&WBSE_1_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Research"},{"$f":"VLOOKUP($J22,$J$11:$L$18,2,FALSE)","v":603600},{"$f":"VLOOKUP($J22,$J$11:$L$18,3,FALSE)","v":603400},null,null,null,{"$f":"$A$7","v":12},{"$f":"IF(P22=1,\"\",SUM(G22/P22))","v":0}]
[{"$f":"WBSE_2","v":0},{"$f":"Effort_2","v":0},{"$f":"IF(M23=\"Y\",WBSE_2&\" - \"&K24,WBSE_2&\" - \"&K24)","v":" - 603700"},{"$f":"IF(M23=\"Y\",F23,B23)","v":0},{"$f":"IF(M23=\"Y\",F24,I23)","v":0},{"$f":"ROUNDDOWN(+$H23/IBS_Full*100,1)/100","v":0},{"$f":"IF(H24>0,ROUNDUP(+$H24/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_2,2),ROUNDUP(+Salary_Cap*Effort_2,2))","v":0},{"$f":"IBS_Full*Effort_2","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_2,Federal_Prime,2,FALSE)","v":"N"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M23&N23","v":"NY"},12,{"$f":"IF(P23=1,\"\",SUM(F24/P23))","v":0}]
[null,null,{"$f":"IF(O23=\"YY\",WBSE_2&\" - \"&L24,\" \")","v":" "},{"$f":"IF(O23=\"YY\",G23,\"\")","v":""},{"$f":"IF(O23=\"YY\",G24,\"\")","v":""},{"$f":"ROUND(+IBS_Full*F23,2)","v":0},{"$f":"IF(H24>0,ROUND(+IBS_Full*G23,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_2,2)-H23)","v":0},{"$f":"SUM(I23-F24-G24)","v":0},{"$f":"Rank&\"-\"&WBSE_2_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Non-Research"},{"$f":"VLOOKUP($J24,$J$11:$L$18,2,FALSE)","v":603700},{"$f":"VLOOKUP($J24,$J$11:$L$18,3,FALSE)","v":603300},null,null,null,12,{"$f":"IF(P24=1,\"\",SUM(G24/P24))","v":0}]
[{"$f":"WBSE_3","v":0},{"$f":"Effort_3","v":0},{"$f":"IF(M25=\"Y\",WBSE_3&\" - \"&K26,WBSE_3&\" - \"&K26)","v":" - 603700"},{"$f":"IF(M25=\"Y\",F25,B25)","v":0},{"$f":"IF(M25=\"Y\",F26,I25)","v":0},{"$f":"ROUNDDOWN(+$H25/IBS_Full*100,1)/100","v":0},{"$f":"IF(H26>0,ROUNDUP(+$H26/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_3,2),ROUNDUP(+Salary_Cap*Effort_3,2))","v":0},{"$f":"IBS_Full*Effort_3","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_3,Federal_Prime,2,FALSE)","v":"N"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M25&N25","v":"NY"},12,{"$f":"IF(P25=1,\"\",SUM(F26/P25))","v":0}]
[null,null,{"$f":"IF(O25=\"YY\",WBSE_3&\" - \"&L26,\" \")","v":" "},{"$f":"IF(O25=\"YY\",G25,\"\")","v":""},{"$f":"IF(O25=\"YY\",G26,\"\")","v":""},{"$f":"ROUND(+IBS_Full*F25,2)","v":0},{"$f":"IF(H26>0,ROUND(+IBS_Full*G25,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_3,2)-H25)","v":0},{"$f":"SUM(I25-F26-G26)","v":0},{"$f":"Rank&\"-\"&WBSE_3_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Non-Research"},{"$f":"VLOOKUP($J26,$J$11:$L$18,2,FALSE)","v":603700},{"$f":"VLOOKUP($J26,$J$11:$L$18,3,FALSE)","v":603300},null,null,null,12,{"$f":"IF(P26=1,\"\",SUM(G26/P26))","v":0}]
[{"$f":"WBSE_4","v":0},{"$f":"Effort_4","v":0},{"$f":"IF(M27=\"Y\",WBSE_4&\" - \"&K28,WBSE_4&\" - \"&K28)","v":" - 603600"},{"$f":"IF(M27=\"Y\",F27,B27)","v":0},{"$f":"IF(M27=\"Y\",F28,I27)","v":0},{"$f":"ROUNDDOWN(+$H27/IBS_Full*100,1)/100","v":0},{"$f":"IF(H28>0,ROUNDUP(+$H28/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_4,2),ROUNDUP(+Salary_Cap*Effort_4,2))","v":0},{"$f":"IBS_Full*Effort_4","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_4,Federal_Prime,2,FALSE)","v":"N"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M27&N27","v":"NY"},12,{"$f":"IF(P27=1,\"\",SUM(F28/P27))","v":0}]
[null,null,{"$f":"IF(O27=\"YY\",WBSE_4&\" - \"&L28,\" \")","v":" "},{"$f":"IF(O27=\"YY\",G27,\"\")","v":""},{"$f":"IF(O27=\"YY\",G28,\"\")","v":""},{"$f":"ROUND(+IBS_Full*F27,2)","v":0},{"$f":"IF(H28>0,ROUND(+IBS_Full*G27,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_4,2)-H27)","v":0},{"$f":"SUM(I27-F28-G28)","v":0},{"$f":"Rank&\"-\"&WBSE_4_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Research"},{"$f":"VLOOKUP($J28,$J$11:$L$18,2,FALSE)","v":603600},{"$f":"VLOOKUP($J28,$J$11:$L$18,3,FALSE)","v":603400},null,null,null,12,{"$f":"IF(P28=1,\"\",SUM(G28/P28))","v":0}]
[{"$f":"WBSE_5","v":0},{"$f":"Effort_5","v":0},{"$f":"IF(M29=\"Y\",WBSE_5&\" - \"&K30,WBSE_5&\" - \"&K30)","v":" - 603600"},{"$f":"IF(M29=\"Y\",F29,B29)","v":0},{"$f":"IF(M29=\"Y\",F30,I29)","v":0},{"$f":"ROUNDDOWN(+$H29/IBS_Full*100,1)/100","v":0},{"$f":"IF(H30>0,ROUNDUP(+$H30/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_5,2),ROUNDUP(+Salary_Cap*Effort_5,2))","v":0},{"$f":"IBS_Full*Effort_5","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_5,Federal_Prime,2,FALSE)","v":"N"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M29&N29","v":"NY"},12,{"$f":"IF(P29=1,\"\",SUM(F30/P29))","v":0}]
[null,null,{"$f":"IF(O29=\"YY\",WBSE_5&\" - \"&L30,\" \")","v":" "},{"$f":"IF(O29=\"YY\",G29,\"\")","v":""},{"$f":"IF(O29=\"YY\",G30,\"\")","v":""},{"$f":"ROUND(+IBS_Full*F29,2)","v":0},{"$f":"IF(H30>0,ROUND(+IBS_Full*G29,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_5,2)-H29)","v":0},{"$f":"SUM(I29-F30-G30)","v":0},{"$f":"Rank&\"-\"&WBSE_5_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Research"},{"$f":"VLOOKUP($J30,$J$11:$L$18,2,FALSE)","v":603600},{"$f":"VLOOKUP($J30,$J$11:$L$18,3,FALSE)","v":603400},null,null,null,12,{"$f":"IF(P30=1,\"\",SUM(G30/P30))","v":0}]
[{"$f":"WBSE_6","v":0},{"$f":"Effort_6","v":0},{"$f":"IF(M31=\"Y\",WBSE_6&\" - \"&K32,WBSE_6&\" - \"&K32)","v":" - 603600"},{"$f":"IF(M31=\"Y\",F31,B31)","v":0},{"$f":"IF(M31=\"Y\",F32,I31)","v":0},{"$f":"ROUNDDOWN(+$H31/IBS_Full*100,1)/100","v":0},{"$f":"IF(H32>0,ROUNDUP(+$H32/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_6,2),ROUNDUP(+Salary_Cap*Effort_6,2))","v":0},{"$f":"IBS_Full*Effort_6","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_6,Federal_Prime,2,FALSE)","v":"N"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M31&N31","v":"NY"},12,{"$f":"IF(P31=1,\"\",SUM(F32/P31))","v":0}]
[null,null,{"$f":"IF(O31=\"YY\",WBSE_6&\" - \"&L32,\" \")","v":" "},{"$f":"IF(O31=\"YY\",G31,\"\")","v":""},{"$f":"IF(O31=\"YY\",G32,\"\")","v":""},{"$f":"ROUND(+IBS_Full*F31,2)","v":0},{"$f":"IF(H32>0,ROUND(+IBS_Full*G31,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_6,2)-H31)","v":0},{"$f":"SUM(I31-F32-G32)","v":0},{"$f":"Rank&\"-\"&WBSE_6_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Research"},{"$f":"VLOOKUP($J32,$J$11:$L$18,2,FALSE)","v":603600},{"$f":"VLOOKUP($J32,$J$11:$L$18,3,FALSE)","v":603400},null,null,null,12,{"$f":"IF(P32=1,\"\",SUM(G32/P32))","v":0}]
[{"$f":"WBSE_7","v":0},{"$f":"Effort_7","v":0},{"$f":"IF(M33=\"Y\",WBSE_7&\" - \"&K34,WBSE_7&\" - \"&K34)","v":" - 603600"},{"$f":"IF(M33=\"Y\",F33,B33)","v":0},{"$f":"IF(M33=\"Y\",F34,I33)","v":0},{"$f":"ROUNDDOWN(+$H33/IBS_Full*100,1)/100","v":0},{"$f":"IF(H34>0,ROUNDUP(+$H34/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_7,2),ROUNDUP(+Salary_Cap*Effort_7,2))","v":0},{"$f":"IBS_Full*Effort_7","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_7,Federal_Prime,2,FALSE)","v":"N"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M33&N33","v":"NY"},12,{"$f":"IF(P33=1,\"\",SUM(F34/P33))","v":0}]
[null,null,{"$f":"IF(O33=\"YY\",WBSE_7&\" - \"&L34,\" \")","v":" "},{"$f":"IF(O33=\"YY\",G33,\"\")","v":""},{"$f":"IF(O33=\"YY\",G34,\"\")","v":""},{"$f":"ROUND(+IBS_Full*F33,2)","v":0},{"$f":"IF(H34>0,ROUND(+IBS_Full*G33,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_7,2)-H33)","v":0},{"$f":"SUM(I33-F34-G34)","v":0},{"$f":"Rank&\"-\"&WBSE_7_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Research"},{"$f":"VLOOKUP($J34,$J$11:$L$18,2,FALSE)","v":603600},{"$f":"VLOOKUP($J34,$J$11:$L$18,3,FALSE)","v":603400},null,null,null,12,{"$f":"IF(P34=1,\"\",SUM(G34/P34))","v":0}]
[{"$f":"WBSE_8","v":0},{"$f":"Effort_8","v":0},{"$f":"IF(M35=\"Y\",WBSE_8&\" - \"&K36,WBSE_8&\" - \"&K36)","v":" - 603600"},{"$f":"IF(M35=\"Y\",F35,B35)","v":0},{"$f":"IF(M35=\"Y\",F36,I35)","v":0},{"$f":"ROUNDDOWN(+$H35/IBS_Full*100,1)/100","v":0},{"$f":"IF(H36>0,ROUNDUP(+$H36/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_8,2),ROUNDUP(+Salary_Cap*Effort_8,2))","v":0},{"$f":"IBS_Full*Effort_8","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_8,Federal_Prime,2,FALSE)","v":"N"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M35&N35","v":"NY"},12,{"$f":"IF(P35=1,\"\",SUM(F36/P35))","v":0}]
[null,null,{"$f":"IF(O35=\"YY\",WBSE_8&\" - \"&L36,\" \")","v":" "},{"$f":"IF(O35=\"YY\",G35,\"\")","v":""},{"$f":"IF(O35=\"YY\",G36,\"\")","v":""},{"$f":"ROUND(+IBS_Full*F35,2)","v":0},{"$f":"IF(H36>0,ROUND(+IBS_Full*G35,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_8,2)-H35)","v":0},{"$f":"SUM(I35-F36-G36)","v":0},{"$f":"Rank&\"-\"&WBSE_8_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Research"},{"$f":"VLOOKUP($J36,$J$11:$L$18,2,FALSE)","v":603600},{"$f":"VLOOKUP($J36,$J$11:$L$18,3,FALSE)","v":603400},null,null,null,12,{"$f":"IF(P36=1,\"\",SUM(G36/P36))","v":0}]
[{"$f":"WBSE_9","v":0},{"$f":"Effort_9","v":0},{"$f":"IF(M37=\"Y\",WBSE_9&\" - \"&K38,WBSE_9&\" - \"&K38)","v":" - 603600"},{"$f":"IF(M37=\"Y\",F37,B37)","v":0},{"$f":"IF(M37=\"Y\",F38,I37)","v":0},{"$f":"ROUNDDOWN(+$H37/IBS_Full*100,1)/100","v":0},{"$f":"IF(H38>0,ROUNDUP(+$H38/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_9,2),ROUNDUP(+Salary_Cap*Effort_9,2))","v":0},{"$f":"IBS_Full*Effort_9","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_9,Federal_Prime,2,FALSE)","v":"N"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M37&N37","v":"NY"},12,{"$f":"IF(P37=1,\"\",SUM(F38/P37))","v":0}]
[null,null,{"$f":"IF(O37=\"YY\",WBSE_9&\" - \"&L38,\" \")","v":" "},{"$f":"IF(O37=\"YY\",G37,\"\")","v":""},{"$f":"IF(O37=\"YY\",G38,\"\")","v":""},{"$f":"ROUND(+IBS_Full*F37,2)","v":0},{"$f":"IF(H38>0,ROUND(+IBS_Full*G37,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_9,2)-H37)","v":0},{"$f":"SUM(I37-F38-G38)","v":0},{"$f":"Rank&\"-\"&WBSE_9_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Research"},{"$f":"VLOOKUP($J38,$J$11:$L$18,2,FALSE)","v":603600},{"$f":"VLOOKUP($J38,$J$11:$L$18,3,FALSE)","v":603400},null,null,null,12,{"$f":"IF(P38=1,\"\",SUM(G38/P38))","v":0}]
[{"$f":"WBSE_10","v":0},{"$f":"Effort_10","v":0},{"$f":"IF(M39=\"Y\",WBSE_10&\" - \"&K40,WBSE_10&\" - \"&K40)","v":" - 603600"},{"$f":"IF(M39=\"Y\",F39,B39)","v":0},{"$f":"IF(M39=\"Y\",F40,I39)","v":0},{"$f":"ROUNDDOWN(+$H39/IBS_Full*100,1)/100","v":0},{"$f":"IF(H40>0,ROUNDUP(+$H40/$D$10*100,1)/100,0)","v":0},{"$f":"IF($D$10<$D$11,ROUNDUP(+$D$10*Effort_10,2),ROUNDUP(+Salary_Cap*Effort_10,2))","v":0},{"$f":"IBS_Full*Effort_10","v":0},null,"Direct","Cost Share",{"$f":"VLOOKUP(Federal_10,Federal_Prime,2,FALSE)","v":"N"},{"$f":"IF($D$10>$D$11,\"Y\",\"N\")","v":"Y"},{"$f":"M39&N39","v":"NY"},12,{"$f":"IF(P39=1,\"\",SUM(F40/P39))","v":0}]
[null,null,{"$f":"IF(O39=\"YY\",WBSE_10&\" - \"&L40,\" \")","v":" "},{"$f":"IF(O39=\"YY\",G39,\"\")","v":""},{"$f":"IF(O39=\"YY\",G40,\"\")","v":""},{"$f":"ROUND(+IBS_Full*F39,2)","v":0},{"$f":"IF(H40>0,ROUND(+IBS_Full*G39,2),0)","v":0},{"$f":"IF($D$10<$D$11,0,ROUNDUP(+IBS_Full*Effort_10,2)-H39)","v":0},{"$f":"SUM(I39-F40-G40)","v":0},{"$f":"Rank&\"-\"&WBSE_10_Project","v":"Regular Rank Tenure/Tenure-Track Faculty-Research"},{"$f":"VLOOKUP($J40,$J$11:$L$18,2,FALSE)","v":603600},{"$f":"VLOOKUP($J40,$J$11:$L$18,3,FALSE)","v":603400},null,null,null,12,{"$f":"IF(P40=1,\"\",SUM(G40/P40))","v":0}]