{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","CAP Historical","% breakdown"],"not_rendered":{"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":36,"n_cols":20,"rows_kept":36,"merged":[[4,0,4,5],[5,0,5,2],[5,3,5,5],[6,0,6,2],[6,3,6,5],[12,0,12,5],[14,0,14,2],[14,3,14,5],[16,0,16,2],[16,3,16,5],[22,4,23,14],[22,15,23,20],[24,0,24,3],[24,4,27,5],[24,6,27,7],[24,8,27,8],[24,9,27,10],[24,11,27,12],[24,13,27,14],[24,15,27,16],[24,17,27,18],[24,19,27,20],[25,2,27,3],[26,0,26,1],[28,0,28,1],[28,2,28,3],[28,4,28,5],[28,6,28,7],[28,9,28,10],[28,11,28,12],[28,13,28,14],[28,15,28,16],[28,17,28,18],[28,19,28,20],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[29,19,29,20]]}
["Salary Cap Calculator for Determining Salary Distribution"]
[]
["All cells highlighted in blue requires input from user.  "]
[]
["NIH Salary Cap"]
["Annual Salary Cap",null,null,"Capped Monthly Rate"]
[{"v":212100,"d":"$212,100"},null,null,{"$f":"A7/12","v":{"v":17675,"d":"$17,675"}}]
[]
["Institutional Base Salary"]
["Include all Academic Apppointments in this number, the monthly"]
["IBS salary rate will auto populate"]
[]
["Institutional Base Salary (IBS)"]
[]
["Annual IBS Salary Rate =",null,null,{"v":0,"d":"$0.00"}]
[]
["Monthly IBS Salary Rate =",null,null,{"$f":"D15/12","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[]
[]
[{"$nulls":4},"NIH Salary Cap Calculator",{"$nulls":10},"Use Only if Applicable"]
[]
["Grant Info and % of Salary",{"$nulls":3},"Monthly Amount to transfer to NIH grant including OTC (excludes benefits)",null,"Difference between NIH monthly salary cap and IBS monthly salary",null,"Amount of salary applied to NIH grant (2)","Amount Over the Cap (OTC) - to be moved to unrestricted fund",null,"Benefits CBR",null,"Total Benefits Amount (will be moved automatically with OTC amount)",null,"Total Monthly Amount (OTC + Benefits) ",null,"GL/EP Assessment (If Applicable)",null,"Total Monthly Amount (OTC + Benefits + GL/EP) "]
[null,null," % of Salary (1)"]
["Grant Info (optional)"]
[]
["Example 1",null,{"v":0,"d":"0.00000%"},null,{"$f":"$D$17*C29","v":{"v":0,"d":"$0.00"}},null,{"$f":"$D$17-$D$7","v":{"v":-17675,"d":"-$17,675"}},null,{"$f":"E29-J29","v":{"v":0,"d":"$0.00"}},{"$f":"G29*C29","v":{"v":0,"d":"$0.00"}},null,{"v":0,"d":"0.00%"},null,{"$f":"J29*L29","v":{"v":0,"d":"$0.00"}},null,{"$f":"J29+N29","v":{"v":0,"d":"$0.00"}},null,{"$f":"(0.0081+0.0049)*J29","v":{"v":0,"d":"$0.00"}},null,{"$f":"P29+R29","v":{"v":0,"d":"$0.00"}}]
["TOTALS:",null,{"$f":"SUM(C29:D29)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(E29:F29)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(J29:K29)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"$f":"SUM(N29:O29)","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(P29:Q29)","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(R29:S29)","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(T29:U29)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[null,"If you do not have the % of Salary (1), and only have the \"Amount of salary applied to NIH grant\" (2) and want to determine the % of Salary (1) do the following:"]
[null,"1.  Divide the 'Amount of salary applied to NIH grant\" (2) by the current CAP rate to determine the percentage"]
[null,"2.  Enter that percentage under \"% of Salary\" (1), the rest will automatically populate"]

{"sheet":"CAP Historical","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"merged":[[0,0,0,2]]}
["Executive Level II"]
[]
["Effective Dates","CAP Amount","Notice #"]
["1/1/23 - 9/30/23",{"v":212100,"d":"$212,100"},"NOT-OD-23-056"]
["1/2/22 - 9/30/22",{"v":203700,"d":"$203,700"},"NOT-OD-22-076"]
["10/1/21 - 1/1/22",{"v":199300,"d":"$199,300"}]
["1/3/21 - 9/30/21",{"v":199300,"d":"$199,300"},"NOT-OD-21-057"]
["10/1/20 - 1/2/21",{"v":197300,"d":"$197,300"}]
["1/5/20 - 9/30/20",{"v":197300,"d":"$197,300"},"NOT-OD-20-065"]
["10/1/19 - 1/4/20",{"v":192300,"d":"$192,300"}]
["1/6/19 - 9/30/19",{"v":192300,"d":"$192,300"},"NOT-OD-20-067"]
["10/1/18 - 1/5/19",{"v":189600,"d":"$189,600"},"NOT-OD-19-099"]
["1/7/18 - 9/30/18",{"v":189600,"d":"$189,600"}]
["10/1/17 - 1/6/18",{"v":187000,"d":"$187,000"},"NOT-OD-18-137"]

{"sheet":"% breakdown","index":2,"n_rows":32,"n_cols":19,"rows_kept":32,"hidden":true,"merged":[[4,0,4,5],[5,0,5,2],[5,3,5,5],[6,0,6,2],[6,3,6,5],[12,0,12,5],[14,0,14,2],[14,3,14,5],[16,0,16,2],[16,3,16,5],[22,4,23,19],[24,0,24,3],[24,4,27,5],[24,6,27,7],[24,8,27,9],[24,10,27,11],[24,12,27,13],[24,14,27,15],[24,16,27,17],[24,18,27,19],[26,0,26,1],[26,2,26,3],[28,0,28,1],[28,2,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,16,28,17],[28,18,28,19],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[29,16,29,17],[29,18,29,19],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,13],[30,14,30,15],[30,16,30,17],[30,18,30,19],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,15],[31,16,31,17],[31,18,31,19]]}
["Salary Cap Calculator for Determining Salary Distribution"]
[]
["All cells highlighted in blue requires input from user.  "]
[]
["NIH Salary Cap"]
["Annual Salary Cap",null,null,"Capped Monthly Rate"]
[{"v":192300,"d":"$192,300"},null,null,{"$f":"A7/12","v":{"v":16025,"d":"$16,025"}}]
[]
["Institutional Base Salary"]
["Include all Academic Apppointments in this number, the monthly"]
["IBS salary rate will auto populate"]
[]
["Institutional Base Salary (IBS)"]
[]
["Annual IBS Salary Rate =",null,null,{"v":285000,"d":"$285,000.00"}]
[]
["Monthly IBS Salary Rate =",null,null,{"$f":"D15/9","v":{"v":31666.666666666668,"d":"$31,666.67"}}]
[]
[]
[]
[]
[]
[{"$nulls":4},"NIH Salary Cap Calculator"]
[]
["Grant Info and % Effort",{"$nulls":3},"Appt % on NIH funds",null,"Appt % on unrestricted funds",null,"Monthly Amount transferred to NIH grant (excludes benefits)",null,"Difference between NIH monthly salary cap and IBS monthly salary",null,"Amount Over the Cap (OTC) - to be moved to unrestricted fund",null,"Benefits CBR",null,"Total Benefits Amount (will be moved automatically w/OTC amount)",null,"Total Monthly Amount (OTC + Benefits) "]
[]
["Grant Info (optional)",null," % of Effort"]
[]
["[enter Grant info]",null,{"v":0.1,"d":"10%"},null,{"$f":"($D$7/$D$17)*C29","v":{"v":0.050605263157894737,"d":"5.06%"}},null,{"$f":"C29-E29","v":{"v":0.04939473684210527,"d":"4.94%"}},null,{"$f":"$D$17*C29","v":{"v":3166.666666666667,"d":"$3,166.67"}},null,{"$f":"$D$17-$D$7","v":{"v":15641.666666666668,"d":"$15,641.67"}},null,{"$f":"K29*C29","v":{"v":1564.166666666667,"d":"$1,564.17"}},null,{"v":0.3587,"d":"35.87%"},null,{"$f":"M29*O29","v":{"v":561.0665833333335,"d":"$561.07"}},null,{"$f":"M29+Q29","v":{"v":2125.23325,"d":"$2,125.23"}}]
["[enter Grant info]",null,{"v":0,"d":"0%"},null,{"$f":"($D$7/$D$17)*C30","v":{"v":0,"d":"0.00%"}},null,{"$f":"C30-E30","v":{"v":0,"d":"0.00%"}},null,{"$f":"$D$17*C30","v":{"v":0,"d":"$0.00"}},null,{"$f":"$D$17-$D$7","v":{"v":15641.666666666668,"d":"$15,641.67"}},null,{"$f":"K30*C30","v":{"v":0,"d":"$0.00"}},null,{"v":0.3587,"d":"35.87%"},null,{"$f":"M30*O30","v":{"v":0,"d":"$0.00"}},null,{"$f":"M30+Q30","v":{"v":0,"d":"$0.00"}}]
["[enter Grant info]",null,{"v":0,"d":"0%"},null,{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00%"},null,{"v":0,"d":"$0.00"},null,{"v":15641.666666666668,"d":"$15,641.67"},null,{"$f":"K31*C31","v":{"v":0,"d":"$0.00"}},null,{"v":0.3587,"d":"35.87%"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
["TOTALS:",{"$nulls":7},{"$f":"SUM(I29:J31)","v":{"v":3166.666666666667,"d":"$3,166.67"}},{"$nulls":3},{"$f":"SUM(M29:N31)","v":{"v":1564.166666666667,"d":"$1,564.17"}},{"$nulls":3},{"$f":"SUM(Q29:R31)","v":{"v":561.0665833333335,"d":"$561.07"}},null,{"v":2125.23325,"d":"$2,125.23"}]