{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["1 YEAR","2 YEARS","3 YEARS","4 YEARS","5 YEARS"],"not_rendered":{"defined_names":7,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"1 YEAR","index":0,"n_rows":66,"n_cols":9,"rows_kept":66,"merged":[[1,2,1,4],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,4],[4,0,4,1],[4,2,4,4],[5,0,5,1],[5,2,5,8],[6,0,6,1],[6,2,6,6],[7,2,7,4],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[28,2,28,5],[29,2,29,4],[30,2,30,4],[32,2,32,5],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[47,2,47,5],[48,2,48,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[55,2,55,5],[58,2,58,5],[59,2,59,4],[60,2,60,5]]}
["Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff"]
[null,"MUID  ",{"$nulls":3},"ACCT  "]
["Prepared by  "]
["Last Modified on  ",null,{"$f":"NOW()","v":"2014-07-25T11:07:07.440"}]
["PI  ",{"$nulls":4},"DEPT  "]
["Project Title  "]
["Sponsor  "]
[null,"Budget Period  "]
[]
[null,"BUDGET ITEM","Name or Comment",{"$nulls":3},"GRANT","Cost Share","TOTAL"]
["A.","PERSONNEL"]
[6000,"PI Acad. Year",{"$nulls":6},{"$f":"SUM(G12:H12)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},{"$f":"SUM(G13:H13)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},0]
[6000,"Other Professional",{"$nulls":6},0]
[6000,"Total Professional",{"$nulls":4},{"$f":"ROUND(SUM(G11:G15),0)","v":0},{"$f":"ROUND(SUM(H11:H15),0)","v":0},{"$f":"ROUND(SUM(I11:I15),0)","v":0}]
[6007,"PI Summer",{"$nulls":6},0]
[6007,"Co-I Summer",{"$nulls":6},0]
[6007,"Co-I Summer",{"$nulls":6},0]
[6007,"Total Sumr Salaries",{"$nulls":4},{"$f":"ROUND(SUM(G17:G19),0)","v":0},{"$f":"ROUND(SUM(H17:H19),0)","v":0},{"$f":"ROUND(SUM(I17:I19),0)","v":0}]
[6008,"Post Doc/Fellow Full-Time",{"$nulls":6},{"$f":"SUM(G21:H21)","v":0}]
[6012,"Clinical/Lab Staff Full-Time",{"$nulls":6},0]
[6013,"Clinical/Lab Staff Part-Time",{"$nulls":6},0]
[6020,"Full-Time Hourly Staff",{"$nulls":6},0]
[6035,"Part-Time Hourly Staff",{"$nulls":6},0]
[6050,"Undergraduate Students",{"$nulls":6},0]
[6024,"GRA-Academic Year","#:",null,"Biweekly $:",null,{"$f":"ROUND(D27*F27*20,0)","v":0},0,0]
[6024,"GRA-Summer","#:",null,"Biweekly $:",null,{"$f":"ROUND(D28*F28*6,0)","v":0},0,0]
[6024,"Total GRA",{"$nulls":4},{"$f":"SUM(G27:G28)","v":0},{"$f":"SUM(H27:H28)","v":0},{"$f":"SUM(I27:I28)","v":0}]
[6195,"Fringe FT",{"$nulls":3},{"v":0.285,"d":"28.5%"},{"$f":"ROUND($F$30*SUM(G16,G21,G22,G24),0)","v":0},{"$f":"ROUND($F$30*SUM(H16,H21,H22,H24),0)","v":0},{"$f":"SUM(G30:H30)","v":0}]
[6195,"Fringe Summer",{"$nulls":3},{"v":0.16,"d":"16.0%"},{"$f":"ROUND($F$31*G20,0)","v":0},{"$f":"ROUND($F$31*H20,0)","v":0},{"$f":"SUM(G31:H31)","v":0}]
[6195,"Fringe PT & Summer Students",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"ROUND($F$32*SUM(G23,G25,G28),0)","v":0},{"$f":"ROUND($F$32*SUM(H23,H25,H28),0)","v":0},{"$f":"SUM(G32:H32)","v":0}]
[6195,"Total Fringes",{"$nulls":4},{"$f":"ROUND(SUM(G30:G32),0)","v":0},{"$f":"ROUND(SUM(H30:H32),0)","v":0},{"$f":"ROUND(SUM(I30:I32),0)","v":0}]
[null,"TOTAL PERSONNEL",{"$nulls":4},{"$f":"SUM(G16,G20:G26,G29,G33)","v":0},{"$f":"SUM(H16,H20:H26,H29,H33)","v":0},{"$f":"SUM(I16,I20:I26,I29,I33)","v":0}]
[]
["B.","NONPERSONNEL"]
[6200,"Office Expenses",{"$nulls":6},{"$f":"SUM(G37:H37)","v":0}]
[6235,"Lab Supplies",{"$nulls":6},0]
[6247,"Equipment > $5000",{"$nulls":6},0]
[6265,"Computer Software",{"$nulls":6},0]
[6505,"Consulting Fees",{"$nulls":6},0]
[6515,"Subcontract 1 < $25K",{"$nulls":6},0]
[6520,"Subcontract 1 > $25K",{"$nulls":6},0]
[6515,"Subcontract 2 < $25K",{"$nulls":6},0]
[6520,"Subcontract 2 > $25K",{"$nulls":6},0]
[6515,"Total Sub < $25K",{"$nulls":4},{"$f":"SUM(G42,G44)","v":0},0,0]
[6520,"Total Sub > $25K",{"$nulls":4},0,0,0]
[6602,"Student Stipends",{"$nulls":6},{"$f":"SUM(G48:H48)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G49:H49)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G50:H50)","v":0}]
[6900,"Total Domestic Travel",{"$nulls":4},{"$f":"SUM(G49:G50)","v":0},{"$f":"SUM(H49:H50)","v":0},{"$f":"SUM(I49:I50)","v":0}]
[6930,"Foreign Travel",{"$nulls":6},{"$f":"SUM(G52:H52)","v":0}]
[7010,"Publications",{"$nulls":6},{"$f":"SUM(G53:H53)","v":0}]
[7225,"Tuition",{"$nulls":6},{"$f":"SUM(G54:H54)","v":0}]
[null,"TOTAL NONPERSONNEL",{"$nulls":4},{"$f":"ROUND(SUM(G37:G41,G46:G48,G51:G54),0)","v":0},{"$f":"ROUND(SUM(H37:H41,H46:H48,H51:H54),0)","v":0},{"$f":"ROUND(SUM(I37:I41,I46:I48,I51:I54),0)","v":0}]
[]
[null,"TOTAL DIRECT COSTS: NIH MODULAR (Less Subs I/C)",{"$nulls":4},{"$f":"SUM(G34,G55)-G66","v":0},{"$f":"SUM(H34,H55)-H66","v":0},{"$f":"SUM(I34,I55)-I66","v":0}]
[null,"TOTAL DIRECT COSTS: MU (Includes Subs I/C)",{"$nulls":4},{"$f":"SUM(G34,G55)","v":0},{"$f":"SUM(H34,H55)","v":0},{"$f":"SUM(I34,I55)","v":0}]
[null,"MTDC BASE",{"$nulls":4},{"$f":"G58-SUM(G39,G47,G54)","v":0},{"$f":"H58-SUM(H39,H47,H54)","v":0},{"$f":"I58-SUM(I39,I47,I54)","v":0}]
[7520,"F&A Costs",{"$nulls":3},{"v":0.51,"d":"51.0%"},{"$f":"ROUND(SUM(G59*$F$60),0)","v":0},{"$f":"ROUND(SUM(H59*$F$60),0)","v":0},{"$f":"SUM(G60:H60)","v":0}]
[null,"TOTAL PROJ COSTS",{"$nulls":4},{"$f":"SUM(G58,G60)","v":0},{"$f":"SUM(H58,H60)","v":0},{"$f":"SUM(I58,I60)","v":0}]
[]
[{"$nulls":5},"F&A for Subcontract"]
[{"$nulls":5},"#1",null,null,{"$f":"SUM(G64:H64)","v":0}]
[{"$nulls":5},"#2",null,null,{"$f":"SUM(G65:H65)","v":0}]
[{"$nulls":6},{"$f":"SUM(G64:G65)","v":0},{"$f":"SUM(H64:H65)","v":0},{"$f":"SUM(I64:I65)","v":0}]

{"sheet":"2 YEARS","index":1,"n_rows":67,"n_cols":15,"rows_kept":67,"merged":[[1,2,1,4],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,4],[4,0,4,1],[4,2,4,4],[5,0,5,1],[5,2,5,12],[6,0,6,1],[6,2,6,6],[7,2,7,4],[8,2,8,4],[9,6,9,8],[9,9,9,11],[9,12,9,14],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[29,2,29,5],[30,2,30,4],[31,2,31,4],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[47,2,47,5],[48,2,48,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[55,2,55,5],[56,2,56,5],[59,2,59,5],[60,2,60,4],[61,2,61,5]]}
["Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff"]
[null,"MUID  ",{"$nulls":3},"ACCT  "]
["Prepared by  "]
["Last Modified on  ",null,{"$f":"NOW()","v":"2014-07-25T11:07:07.440"}]
["PI  ",{"$nulls":4},"DEPT  "]
["Project Title  "]
["Sponsor  "]
[null,"Budget Period  "]
[null,"Increase Annually By",1.03]
[{"$nulls":6},"PERIOD 1",null,null,"PERIOD 2",null,null,"TOTAL"]
[null,"BUDGET ITEM","Name or Comment",{"$nulls":3},"GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL"]
["A.","PERSONNEL"]
[6000,"PI Acad. Year",{"$nulls":6},{"$f":"SUM(G13:H13)","v":0},{"$f":"ROUND(G13*$C$9,0)","v":0},{"$f":"ROUND(H13*$C$9,0)","v":0},{"$f":"SUM(J13:K13)","v":0},{"$f":"G13+J13","v":0},0,{"$f":"SUM(M13:N13)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},{"$f":"SUM(G14:H14)","v":0},{"$f":"ROUND(G14*$C$9,0)","v":0},0,{"$f":"SUM(J14:K14)","v":0},0,0,{"$f":"SUM(M14:N14)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},0,0,0,{"$f":"SUM(J15:K15)","v":0},0,0,{"$f":"SUM(M15:N15)","v":0}]
[6000,"Other Professional",{"$nulls":6},0,0,0,{"$f":"SUM(J16:K16)","v":0},0,0,{"$f":"SUM(M16:N16)","v":0}]
[6000,"Total Professional",{"$nulls":4},{"$f":"ROUND(SUM(G13:G16),0)","v":0},0,0,0,0,0,0,0,0]
[6007,"PI Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J18:K18)","v":0},{"$f":"G18+J18","v":0},0,{"$f":"SUM(M18:N18)","v":0}]
[6007,"Co-I Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J19:K19)","v":0},0,0,{"$f":"SUM(M19:N19)","v":0}]
[6007,"Co-I Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J20:K20)","v":0},0,0,{"$f":"SUM(M20:N20)","v":0}]
[6007,"Total Sumr Salaries",{"$nulls":4},{"$f":"ROUND(SUM(G18:G20),0)","v":0},0,0,0,0,0,0,0,0]
[6008,"Post Doc/Fellow Full-Time",{"$nulls":6},{"$f":"SUM(G22:H22)","v":0},0,0,{"$f":"SUM(J22:K22)","v":0},{"$f":"G22+J22","v":0},0,{"$f":"SUM(M22:N22)","v":0}]
[6012,"Clinical/Lab Staff Full-Time",{"$nulls":6},0,0,0,0,0,0,0]
[6013,"Clinical/Lab Staff Part-Time",{"$nulls":6},0,0,0,0,0,0,0]
[6020,"Full-Time Hourly Staff",{"$nulls":6},0,0,0,0,0,0,0]
[6035,"Part-Time Hourly Staff",{"$nulls":6},0,0,0,0,0,0,0]
[6050,"Undergraduate Students",{"$nulls":6},0,0,0,0,0,0,0]
[6024,"GRA-Academic Year","#:",null,"Biweekly $:",null,{"$f":"ROUND(D28*F28*20,0)","v":0},null,0,0,0,0,0,0,0]
[6024,"GRA-Summer","#:",null,"Biweekly $:",null,{"$f":"ROUND(D29*F29*6,0)","v":0},null,0,0,0,0,0,0,0]
[6024,"Total GRA",{"$nulls":4},{"$f":"SUM(G28:G29)","v":0},0,0,0,0,0,0,0,0]
[6195,"Fringe FT",{"$nulls":3},{"v":0.285,"d":"28.5%"},{"$f":"ROUND($F$31*SUM(G17,G22,G23,G25),0)","v":0},{"$f":"ROUND($F$31*SUM(H17,H22,H23,H25),0)","v":0},{"$f":"SUM(G31:H31)","v":0},{"$f":"ROUND($F$31*SUM(J17,J22,J23,J25),0)","v":0},{"$f":"ROUND($F$31*SUM(K17,K22,K23,K25),0)","v":0},{"$f":"SUM(J31:K31)","v":0},{"$f":"G31+J31","v":0},0,{"$f":"SUM(M31:N31)","v":0}]
[6195,"Fringe Summer",{"$nulls":3},{"v":0.16,"d":"16.0%"},{"$f":"ROUND($F$32*G21,0)","v":0},{"$f":"ROUND($F$32*H21,0)","v":0},{"$f":"SUM(G32:H32)","v":0},{"$f":"ROUND($F$32*J21,0)","v":0},{"$f":"ROUND($F$32*K21,0)","v":0},{"$f":"SUM(J32:K32)","v":0},0,0,{"$f":"SUM(M32:N32)","v":0}]
[6195,"Fringe PT & Summer Students",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"ROUND($F$33*SUM(G24,G26,G29),0)","v":0},{"$f":"ROUND($F$33*SUM(H24,H26,H29),0)","v":0},{"$f":"SUM(G33:H33)","v":0},{"$f":"ROUND($F$33*SUM(J24,J26,J29),0)","v":0},{"$f":"ROUND($F$33*SUM(K24,K26,K29),0)","v":0},{"$f":"SUM(J33:K33)","v":0},0,0,{"$f":"SUM(M33:N33)","v":0}]
[6195,"Total Fringes",{"$nulls":4},{"$f":"ROUND(SUM(G31:G33),0)","v":0},0,0,0,0,0,0,0,0]
[null,"TOTAL PERSONNEL",{"$nulls":4},{"$f":"SUM(G17,G21:G27,G30,G34)","v":0},0,0,0,0,0,0,0,0]
[]
["B.","NONPERSONNEL"]
[6200,"Office Expenses",{"$nulls":6},{"$f":"SUM(G38:H38)","v":0},null,null,{"$f":"SUM(J38:K38)","v":0},{"$f":"G38+J38","v":0},{"$f":"H38+K38","v":0},{"$f":"SUM(M38:N38)","v":0}]
[6235,"Lab Supplies",{"$nulls":6},0,null,null,0,0,0,0]
[6247,"Equipment > $5000",{"$nulls":6},0,null,null,0,0,0,0]
[6265,"Computer Software",{"$nulls":6},0,null,null,0,0,0,0]
[6505,"Consulting Fees",{"$nulls":6},0,null,null,0,0,0,0]
[6515,"Subcontract 1 < $25K",{"$nulls":6},0,null,null,0,0,0,0]
[6520,"Subcontract 1 > $25K",{"$nulls":6},0,null,null,0,0,0,0]
[6515,"Subcontract 2 < $25K",{"$nulls":6},0,null,null,0,0,0,0]
[6520,"Subcontract 2 > $25K",{"$nulls":6},0,null,null,0,0,0,0]
[6515,"Total Sub < $25K",{"$nulls":4},{"$f":"SUM(G43,G45)","v":0},0,0,0,{"$f":"SUM(K43,K45)","v":0},0,0,0,0]
[6520,"Total Sub > $25K",{"$nulls":4},0,0,0,0,0,0,0,0,0]
[6602,"Student Stipends",{"$nulls":6},{"$f":"SUM(G49:H49)","v":0},null,null,{"$f":"SUM(J49:K49)","v":0},{"$f":"G49+J49","v":0},0,{"$f":"SUM(M49:N49)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G50:H50)","v":0},null,null,{"$f":"SUM(J50:K50)","v":0},0,0,{"$f":"SUM(M50:N50)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G51:H51)","v":0},null,null,{"$f":"SUM(J51:K51)","v":0},0,0,{"$f":"SUM(M51:N51)","v":0}]
[6900,"Total Domestic Travel",{"$nulls":4},{"$f":"SUM(G50:G51)","v":0},0,0,0,0,0,0,0,0]
[6930,"Foreign Travel",{"$nulls":6},{"$f":"SUM(G53:H53)","v":0},null,null,{"$f":"SUM(J53:K53)","v":0},{"$f":"G53+J53","v":0},0,{"$f":"SUM(M53:N53)","v":0}]
[7010,"Publications",{"$nulls":6},{"$f":"SUM(G54:H54)","v":0},null,null,{"$f":"SUM(J54:K54)","v":0},0,0,{"$f":"SUM(M54:N54)","v":0}]
[7225,"Tuition",{"$nulls":6},{"$f":"SUM(G55:H55)","v":0},null,null,{"$f":"SUM(J55:K55)","v":0},0,0,{"$f":"SUM(M55:N55)","v":0}]
[null,"TOTAL NONPERSONNEL",{"$nulls":4},{"$f":"ROUND(SUM(G38:G42,G47:G49,G52:G55),0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"TOTAL DIRECT COSTS: NIH MODULAR (Less Subs I/C)",{"$nulls":4},{"$f":"SUM(G35,G56)-G67","v":0},{"$f":"SUM(H35,H56)-H67","v":0},0,0,0,0,0,0,0]
[null,"TOTAL DIRECT COSTS: MU (Includes Subs I/C)",{"$nulls":4},{"$f":"SUM(G35,G56)","v":0},{"$f":"SUM(H35,H56)","v":0},0,0,0,0,0,0,0]
[null,"MTDC BASE",{"$nulls":4},{"$f":"G59-SUM(G40,G48,G55)","v":0},{"$f":"H59-SUM(H40,H48,H55)","v":0},0,0,0,0,0,0,0]
[7520,"F&A Costs",{"$nulls":3},{"v":0.51,"d":"51.0%"},{"$f":"ROUND(SUM(G60*$F$61),0)","v":0},{"$f":"ROUND(SUM(H60*$F$61),0)","v":0},{"$f":"SUM(G61:H61)","v":0},{"$f":"ROUND(SUM(J60*$F$61),0)","v":0},{"$f":"ROUND(SUM(K60*$F$61),0)","v":0},{"$f":"SUM(J61:K61)","v":0},{"$f":"G61+J61","v":0},{"$f":"H61+K61","v":0},{"$f":"SUM(M61:N61)","v":0}]
[null,"TOTAL PROJ COSTS",{"$nulls":4},{"$f":"SUM(G59,G61)","v":0},{"$f":"SUM(H59,H61)","v":0},0,0,0,0,0,0,0]
[]
[{"$nulls":5},"F&A for Subcontracts"]
[{"$nulls":5},"#1",null,null,{"$f":"SUM(G65:H65)","v":0},null,null,{"$f":"SUM(J65:K65)","v":0},{"$f":"G65+J65","v":0},{"$f":"H65+K65","v":0},{"$f":"SUM(M65:N65)","v":0}]
[{"$nulls":5},"#2",null,null,{"$f":"SUM(G66:H66)","v":0},null,null,{"$f":"SUM(J66:K66)","v":0},{"$f":"G66+J66","v":0},{"$f":"H66+K66","v":0},{"$f":"SUM(M66:N66)","v":0}]
[{"$nulls":6},{"$f":"SUM(G65:G66)","v":0},{"$f":"SUM(H65:H66)","v":0},0,0,0,0,0,0,0]

{"sheet":"3 YEARS","index":2,"n_rows":67,"n_cols":18,"rows_kept":67,"merged":[[1,2,1,4],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,4],[4,0,4,1],[4,2,4,4],[5,0,5,1],[5,2,5,11],[6,0,6,1],[6,2,6,6],[7,2,7,4],[8,2,8,4],[9,6,9,8],[9,9,9,11],[9,12,9,14],[9,15,9,17],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[29,2,29,5],[30,2,30,4],[31,2,31,4],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[47,2,47,5],[48,2,48,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[55,2,55,5],[56,2,56,5],[59,2,59,5],[60,2,60,4],[61,2,61,5]]}
["Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff"]
[null,"MUID  ",{"$nulls":3},"ACCT  "]
["Prepared by  "]
["Last Modified on  ",null,{"$f":"NOW()","v":"2014-07-25T11:07:07.440"}]
["PI  ",{"$nulls":4},"DEPT  "]
["Project Title  "]
["Sponsor  "]
[null,"Budget Period  "]
[null,"Increase Annually By",1.03]
[{"$nulls":6},"PERIOD 1",null,null,"PERIOD 2",null,null,"PERIOD 3",null,null,"TOTAL"]
[null,"BUDGET ITEM","Name or Comment",{"$nulls":3},"GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL"]
["A.","PERSONNEL"]
[6000,"PI Acad. Year",{"$nulls":6},{"$f":"SUM(G13:H13)","v":0},{"$f":"ROUND(G13*$C$9,0)","v":0},{"$f":"ROUND(H13*$C$9,0)","v":0},{"$f":"SUM(J13:K13)","v":0},{"$f":"ROUND(J13*$C$9,0)","v":0},0,{"$f":"SUM(M13:N13)","v":0},{"$f":"G13+J13+M13","v":0},{"$f":"H13+K13+N13","v":0},{"$f":"SUM(P13:Q13)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},{"$f":"SUM(G14:H14)","v":0},{"$f":"ROUND(G14*$C$9,0)","v":0},0,{"$f":"SUM(J14:K14)","v":0},0,0,{"$f":"SUM(M14:N14)","v":0},{"$f":"G14+J14+M14","v":0},{"$f":"H14+K14+N14","v":0},{"$f":"SUM(P14:Q14)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},0,0,0,{"$f":"SUM(J15:K15)","v":0},0,0,{"$f":"SUM(M15:N15)","v":0},0,{"$f":"H15+K15+N15","v":0},{"$f":"SUM(P15:Q15)","v":0}]
[6000,"Other Professional",{"$nulls":6},0,0,0,{"$f":"SUM(J16:K16)","v":0},0,0,{"$f":"SUM(M16:N16)","v":0},0,{"$f":"H16+K16+N16","v":0},{"$f":"SUM(P16:Q16)","v":0}]
[6000,"Total Professional",{"$nulls":4},{"$f":"ROUND(SUM(G13:G16),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[6007,"PI Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J18:K18)","v":0},{"$f":"ROUND(J18*$C$9,0)","v":0},0,{"$f":"SUM(M18:N18)","v":0},0,{"$f":"H18+K18+N18","v":0},{"$f":"SUM(P18:Q18)","v":0}]
[6007,"Co-I Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J19:K19)","v":0},0,0,{"$f":"SUM(M19:N19)","v":0},0,{"$f":"H19+K19+N19","v":0},{"$f":"SUM(P19:Q19)","v":0}]
[6007,"Co-I Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J20:K20)","v":0},0,0,{"$f":"SUM(M20:N20)","v":0},0,{"$f":"H20+K20+N20","v":0},{"$f":"SUM(P20:Q20)","v":0}]
[6007,"Total Sumr Salaries",{"$nulls":4},{"$f":"ROUND(SUM(G18:G20),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[6008,"Post Doc/Fellow Full-Time",{"$nulls":6},{"$f":"SUM(G22:H22)","v":0},0,0,{"$f":"SUM(J22:K22)","v":0},{"$f":"ROUND(J22*$C$9,0)","v":0},{"$f":"ROUND(K22*$C$9,0)","v":0},{"$f":"SUM(M22:N22)","v":0},{"$f":"G22+J22+M22","v":0},0,{"$f":"SUM(P22:Q22)","v":0}]
[6012,"Clinical/Lab Staff Full-Time",{"$nulls":6},0,0,0,0,0,0,0,0,0,0]
[6013,"Clinical/Lab Staff Part-Time",{"$nulls":6},0,0,0,0,0,0,0,0,0,0]
[6020,"Full-Time Hourly Staff",{"$nulls":6},0,0,0,0,0,0,0,0,0,0]
[6035,"Part-Time Hourly Staff",{"$nulls":6},0,0,0,0,0,0,0,0,0,0]
[6050,"Undergraduate Students",{"$nulls":6},0,0,0,0,0,0,0,0,0,0]
[6024,"GRA-Academic Year","#:",null,"Biweekly $:",null,{"$f":"ROUND(D28*F28*20,0)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[6024,"GRA-Summer","#:",null,"Biweekly $:",null,{"$f":"ROUND(D29*F29*6,0)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[6024,"Total GRA",{"$nulls":4},{"$f":"SUM(G28:G29)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[6195,"Fringe FT",{"$nulls":3},{"v":0.285,"d":"28.5%"},{"$f":"ROUND($F$31*SUM(G17,G22,G23,G25),0)","v":0},{"$f":"ROUND($F$31*SUM(H17,H22,H23,H25),0)","v":0},{"$f":"SUM(G31:H31)","v":0},{"$f":"ROUND($F$31*SUM(J17,J22,J23,J25),0)","v":0},{"$f":"ROUND($F$31*SUM(K17,K22,K23,K25),0)","v":0},{"$f":"SUM(J31:K31)","v":0},{"$f":"ROUND($F$31*SUM(M17,M22,M23,M25),0)","v":0},{"$f":"ROUND($F$31*SUM(N17,N22,N23,N25),0)","v":0},{"$f":"SUM(M31:N31)","v":0},{"$f":"G31+J31+M31","v":0},0,{"$f":"SUM(P31:Q31)","v":0}]
[6195,"Fringe Summer",{"$nulls":3},{"v":0.16,"d":"16.0%"},{"$f":"ROUND($F$32*G21,0)","v":0},{"$f":"ROUND($F$32*H21,0)","v":0},{"$f":"SUM(G32:H32)","v":0},{"$f":"ROUND($F$32*J21,0)","v":0},{"$f":"ROUND($F$32*K21,0)","v":0},{"$f":"SUM(J32:K32)","v":0},{"$f":"ROUND($F$32*M21,0)","v":0},{"$f":"ROUND($F$32*N21,0)","v":0},{"$f":"SUM(M32:N32)","v":0},0,0,{"$f":"SUM(P32:Q32)","v":0}]
[6195,"Fringe PT & Summer Students",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"ROUND($F$33*SUM(G24,G26,G29),0)","v":0},{"$f":"ROUND($F$33*SUM(H24,H26,H29),0)","v":0},{"$f":"SUM(G33:H33)","v":0},{"$f":"ROUND($F$33*SUM(J24,J26,J29),0)","v":0},{"$f":"ROUND($F$33*SUM(K24,K26,K29),0)","v":0},{"$f":"SUM(J33:K33)","v":0},{"$f":"ROUND($F$33*SUM(M24,M26,M29),0)","v":0},{"$f":"ROUND($F$33*SUM(N24,N26,N29),0)","v":0},{"$f":"SUM(M33:N33)","v":0},0,0,{"$f":"SUM(P33:Q33)","v":0}]
[6195,"Total Fringes",{"$nulls":4},{"$f":"ROUND(SUM(G31:G33),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL PERSONNEL",{"$nulls":4},{"$f":"SUM(G17,G21:G27,G30,G34)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["B.","NONPERSONNEL"]
[6200,"Office Expenses",{"$nulls":6},{"$f":"SUM(G38:H38)","v":0},null,null,{"$f":"SUM(J38:K38)","v":0},null,null,{"$f":"SUM(M38:N38)","v":0},{"$f":"G38+J38+M38","v":0},{"$f":"H38+K38+N38","v":0},{"$f":"SUM(P38:Q38)","v":0}]
[6235,"Lab Supplies",{"$nulls":6},0,null,null,0,null,null,0,{"$f":"G39+J39+M39","v":0},0,0]
[6247,"Equipment > $5000",{"$nulls":6},0,null,null,0,null,null,0,0,0,0]
[6265,"Computer Software",{"$nulls":6},0,null,null,0,null,null,0,0,0,0]
[6505,"Consulting Fees",{"$nulls":6},0,null,null,0,null,null,0,0,0,0]
[6515,"Subcontract 1 < $25K",{"$nulls":6},0,null,null,0,null,null,0,{"$f":"G43+J43+M43","v":0},{"$f":"H43+K43+N43","v":0},0]
[6520,"Subcontract 1 > $25K",{"$nulls":6},0,null,null,0,null,null,0,{"$f":"G44+J44+M44","v":0},0,0]
[6515,"Subcontract 2 < $25K",{"$nulls":6},0,null,null,0,null,null,0,0,0,0]
[6520,"Subcontract 2 > $25K",{"$nulls":6},0,null,null,0,null,null,0,0,0,0]
[6515,"Total Sub < $25K",{"$nulls":4},{"$f":"SUM(G43,G45)","v":0},0,0,0,0,0,{"$f":"SUM(M43,M45)","v":0},0,0,0,0,0]
[6520,"Total Sub > $25K",{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,0]
[6602,"Student Stipends",{"$nulls":6},{"$f":"SUM(G49:H49)","v":0},null,null,{"$f":"SUM(J49:K49)","v":0},null,null,{"$f":"SUM(M49:N49)","v":0},{"$f":"G49+J49+M49","v":0},0,{"$f":"SUM(P49:Q49)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G50:H50)","v":0},null,null,{"$f":"SUM(J50:K50)","v":0},null,null,{"$f":"SUM(M50:N50)","v":0},0,0,{"$f":"SUM(P50:Q50)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G51:H51)","v":0},null,null,{"$f":"SUM(J51:K51)","v":0},null,null,{"$f":"SUM(M51:N51)","v":0},0,0,{"$f":"SUM(P51:Q51)","v":0}]
[6900,"Total Domestic Travel",{"$nulls":4},{"$f":"SUM(G50:G51)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[6930,"Foreign Travel",{"$nulls":6},{"$f":"SUM(G53:H53)","v":0},null,null,{"$f":"SUM(J53:K53)","v":0},null,null,{"$f":"SUM(M53:N53)","v":0},{"$f":"G53+J53+M53","v":0},0,{"$f":"SUM(P53:Q53)","v":0}]
[7010,"Publications",{"$nulls":6},{"$f":"SUM(G54:H54)","v":0},null,null,{"$f":"SUM(J54:K54)","v":0},null,null,{"$f":"SUM(M54:N54)","v":0},0,0,{"$f":"SUM(P54:Q54)","v":0}]
[7225,"Tuition",{"$nulls":6},{"$f":"SUM(G55:H55)","v":0},null,null,{"$f":"SUM(J55:K55)","v":0},null,null,{"$f":"SUM(M55:N55)","v":0},0,0,{"$f":"SUM(P55:Q55)","v":0}]
[null,"TOTAL NONPERSONNEL",{"$nulls":4},{"$f":"ROUND(SUM(G38:G42,G47:G49,G52:G55),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL DIRECT COSTS: NIH MODULAR (Less Subs I/C)",{"$nulls":4},{"$f":"SUM(G35,G56)-G67","v":0},{"$f":"SUM(H35,H56)-H67","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL DIRECT COSTS: MU (Includes Subs I/C)",{"$nulls":4},{"$f":"SUM(G35,G56)","v":0},{"$f":"SUM(H35,H56)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"MTDC BASE",{"$nulls":4},{"$f":"G59-SUM(G40,G48,G55)","v":0},{"$f":"H59-SUM(H40,H48,H55)","v":0},0,0,0,0,0,0,0,0,0,0]
[7520,"F&A Costs",{"$nulls":3},{"v":0.51,"d":"51.0%"},{"$f":"ROUND(SUM(G60*$F$61),0)","v":0},{"$f":"ROUND(SUM(H60*$F$61),0)","v":0},{"$f":"SUM(G61:H61)","v":0},{"$f":"ROUND(SUM(J60*$F$61),0)","v":0},{"$f":"ROUND(SUM(K60*$F$61),0)","v":0},{"$f":"SUM(J61:K61)","v":0},{"$f":"ROUND(SUM(M60*$F$61),0)","v":0},{"$f":"ROUND(SUM(N60*$F$61),0)","v":0},{"$f":"SUM(M61:N61)","v":0},{"$f":"G61+J61+M61","v":0},{"$f":"H61+K61+N61","v":0},{"$f":"SUM(P61:Q61)","v":0}]
[null,"TOTAL PROJ COSTS",{"$nulls":4},{"$f":"SUM(G59,G61)","v":0},{"$f":"SUM(H59,H61)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":5},"F&A for Subcontracts"]
[{"$nulls":5},"#1",null,null,{"$f":"SUM(G65:H65)","v":0},null,null,{"$f":"SUM(J65:K65)","v":0},null,null,{"$f":"SUM(M65:N65)","v":0},{"$f":"G65+J65+M65","v":0},{"$f":"H65+K65+N65","v":0},{"$f":"SUM(P65:Q65)","v":0}]
[{"$nulls":5},"#2",null,null,{"$f":"SUM(G66:H66)","v":0},null,null,{"$f":"SUM(J66:K66)","v":0},null,null,{"$f":"SUM(M66:N66)","v":0},{"$f":"G66+J66+M66","v":0},{"$f":"H66+K66+N66","v":0},{"$f":"SUM(P66:Q66)","v":0}]
[{"$nulls":6},{"$f":"SUM(G65:G66)","v":0},{"$f":"SUM(H65:H66)","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"4 YEARS","index":3,"n_rows":67,"n_cols":21,"rows_kept":67,"merged":[[1,2,1,4],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,4],[4,0,4,1],[4,2,4,4],[5,0,5,1],[5,2,5,11],[6,0,6,1],[6,2,6,6],[7,2,7,4],[8,2,8,4],[9,6,9,8],[9,9,9,11],[9,12,9,14],[9,15,9,17],[9,18,9,20],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[29,2,29,5],[30,2,30,4],[31,2,31,4],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[47,2,47,5],[48,2,48,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[55,2,55,5],[56,2,56,5],[59,2,59,5],[60,2,60,4],[61,2,61,5]]}
["Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff"]
[null,"MUID  ",{"$nulls":3},"ACCT  "]
["Prepared by  "]
["Last Modified on  ",null,{"$f":"NOW()","v":"2014-07-25T11:07:07.440"}]
["PI  ",{"$nulls":4},"DEPT  "]
["Project Title  "]
["Sponsor  "]
[null,"Budget Period  "]
[null,"Increase Annually By",1.03]
[{"$nulls":6},"PERIOD 1",null,null,"PERIOD 2",null,null,"PERIOD 3",null,null,"PERIOD 4",null,null,"TOTAL"]
[null,"BUDGET ITEM","Name or Comment",{"$nulls":3},"GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL"]
["A.","PERSONNEL"]
[6000,"PI Acad. Year",{"$nulls":6},{"$f":"SUM(G13:H13)","v":0},{"$f":"ROUND(G13*$C$9,0)","v":0},{"$f":"ROUND(H13*$C$9,0)","v":0},{"$f":"SUM(J13:K13)","v":0},{"$f":"ROUND(J13*$C$9,0)","v":0},{"$f":"ROUND(K13*$C$9,0)","v":0},{"$f":"SUM(M13:N13)","v":0},{"$f":"ROUND(M13*$C$9,0)","v":0},0,{"$f":"SUM(P13:Q13)","v":0},{"$f":"G13+J13+M13+P13","v":0},{"$f":"H13+K13+N13+Q13","v":0},{"$f":"SUM(S13:T13)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},{"$f":"SUM(G14:H14)","v":0},{"$f":"ROUND(G14*$C$9,0)","v":0},0,{"$f":"SUM(J14:K14)","v":0},{"$f":"ROUND(J14*$C$9,0)","v":0},0,{"$f":"SUM(M14:N14)","v":0},0,0,{"$f":"SUM(P14:Q14)","v":0},{"$f":"G14+J14+M14+P14","v":0},0,{"$f":"SUM(S14:T14)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},0,0,0,{"$f":"SUM(J15:K15)","v":0},0,0,{"$f":"SUM(M15:N15)","v":0},0,0,{"$f":"SUM(P15:Q15)","v":0},0,0,{"$f":"SUM(S15:T15)","v":0}]
[6000,"Other Professional",{"$nulls":6},0,0,0,{"$f":"SUM(J16:K16)","v":0},0,0,{"$f":"SUM(M16:N16)","v":0},0,0,{"$f":"SUM(P16:Q16)","v":0},0,0,{"$f":"SUM(S16:T16)","v":0}]
[6000,"Total Professional",{"$nulls":4},{"$f":"ROUND(SUM(G13:G16),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6007,"PI Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J18:K18)","v":0},{"$f":"ROUND(J18*$C$9,0)","v":0},0,{"$f":"SUM(M18:N18)","v":0},{"$f":"ROUND(M18*$C$9,0)","v":0},0,{"$f":"SUM(P18:Q18)","v":0},{"$f":"G18+J18+M18+P18","v":0},0,{"$f":"SUM(S18:T18)","v":0}]
[6007,"Co-I Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J19:K19)","v":0},0,0,{"$f":"SUM(M19:N19)","v":0},0,0,{"$f":"SUM(P19:Q19)","v":0},0,0,{"$f":"SUM(S19:T19)","v":0}]
[6007,"Co-I Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J20:K20)","v":0},0,0,{"$f":"SUM(M20:N20)","v":0},0,0,{"$f":"SUM(P20:Q20)","v":0},0,0,{"$f":"SUM(S20:T20)","v":0}]
[6007,"Total Sumr Salaries",{"$nulls":4},{"$f":"ROUND(SUM(G18:G20),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6008,"Post Doc/Fellow Full-Time",{"$nulls":6},{"$f":"SUM(G22:H22)","v":0},0,0,{"$f":"SUM(J22:K22)","v":0},{"$f":"ROUND(J22*$C$9,0)","v":0},0,{"$f":"SUM(M22:N22)","v":0},{"$f":"ROUND(M22*$C$9,0)","v":0},{"$f":"ROUND(N22*$C$9,0)","v":0},{"$f":"SUM(P22:Q22)","v":0},{"$f":"G22+J22+M22+P22","v":0},{"$f":"H22+K22+N22+Q22","v":0},{"$f":"SUM(S22:T22)","v":0}]
[6012,"Clinical/Lab Staff Full-Time",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,{"$f":"G23+J23+M23+P23","v":0},0,0]
[6013,"Clinical/Lab Staff Part-Time",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0]
[6020,"Full-Time Hourly Staff",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0]
[6035,"Part-Time Hourly Staff",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0]
[6050,"Undergraduate Students",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0]
[6024,"GRA-Academic Year","#:",null,"Biweekly $:",null,{"$f":"ROUND(D28*F28*20,0)","v":0},null,0,0,0,0,0,0,0,0,0,0,{"$f":"G28+J28+M28+P28","v":0},{"$f":"H28+K28+N28+Q28","v":0},0]
[6024,"GRA-Summer","#:",null,"Biweekly $:",null,{"$f":"ROUND(D29*F29*6,0)","v":0},null,0,0,0,0,0,0,0,0,0,0,{"$f":"G29+J29+M29+P29","v":0},{"$f":"H29+K29+N29+Q29","v":0},0]
[6024,"Total GRA",{"$nulls":4},{"$f":"SUM(G28:G29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6195,"Fringe FT",{"$nulls":3},{"v":0.285,"d":"28.5%"},{"$f":"ROUND($F$31*SUM(G17,G22,G23,G25),0)","v":0},{"$f":"ROUND($F$31*SUM(H17,H22,H23,H25),0)","v":0},{"$f":"SUM(G31:H31)","v":0},{"$f":"ROUND($F$31*SUM(J17,J22,J23,J25),0)","v":0},{"$f":"ROUND($F$31*SUM(K17,K22,K23,K25),0)","v":0},{"$f":"SUM(J31:K31)","v":0},{"$f":"ROUND($F$31*SUM(M17,M22,M23,M25),0)","v":0},{"$f":"ROUND($F$31*SUM(N17,N22,N23,N25),0)","v":0},{"$f":"SUM(M31:N31)","v":0},{"$f":"ROUND($F$31*SUM(P17,P22,P23,P25),0)","v":0},{"$f":"ROUND($F$31*SUM(Q17,Q22,Q23,Q25),0)","v":0},{"$f":"SUM(P31:Q31)","v":0},{"$f":"G31+J31+M31+P31","v":0},0,{"$f":"SUM(S31:T31)","v":0}]
[6195,"Fringe Summer",{"$nulls":3},{"v":0.16,"d":"16.0%"},{"$f":"ROUND($F$32*G21,0)","v":0},{"$f":"ROUND($F$32*H21,0)","v":0},{"$f":"SUM(G32:H32)","v":0},{"$f":"ROUND($F$32*J21,0)","v":0},{"$f":"ROUND($F$32*K21,0)","v":0},{"$f":"SUM(J32:K32)","v":0},{"$f":"ROUND($F$32*M21,0)","v":0},{"$f":"ROUND($F$32*N21,0)","v":0},{"$f":"SUM(M32:N32)","v":0},{"$f":"ROUND($F$32*P21,0)","v":0},{"$f":"ROUND($F$32*Q21,0)","v":0},{"$f":"SUM(P32:Q32)","v":0},0,0,{"$f":"SUM(S32:T32)","v":0}]
[6195,"Fringe PT & Summer Students",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"ROUND($F$33*SUM(G24,G26,G29),0)","v":0},{"$f":"ROUND($F$33*SUM(H24,H26,H29),0)","v":0},{"$f":"SUM(G33:H33)","v":0},{"$f":"ROUND($F$33*SUM(J24,J26,J29),0)","v":0},{"$f":"ROUND($F$33*SUM(K24,K26,K29),0)","v":0},{"$f":"SUM(J33:K33)","v":0},{"$f":"ROUND($F$33*SUM(M24,M26,M29),0)","v":0},{"$f":"ROUND($F$33*SUM(N24,N26,N29),0)","v":0},{"$f":"SUM(M33:N33)","v":0},{"$f":"ROUND($F$33*SUM(P24,P26,P29),0)","v":0},{"$f":"ROUND($F$33*SUM(Q24,Q26,Q29),0)","v":0},{"$f":"SUM(P33:Q33)","v":0},0,0,{"$f":"SUM(S33:T33)","v":0}]
[6195,"Total Fringes",{"$nulls":4},{"$f":"ROUND(SUM(G31:G33),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL PERSONNEL",{"$nulls":4},{"$f":"SUM(G17,G21:G27,G30,G34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["B.","NONPERSONNEL"]
[6200,"Office Expenses",{"$nulls":6},{"$f":"SUM(G38:H38)","v":0},null,null,{"$f":"SUM(J38:K38)","v":0},null,null,{"$f":"SUM(M38:N38)","v":0},null,null,{"$f":"SUM(P38:Q38)","v":0},{"$f":"G38+J38+M38+P38","v":0},{"$f":"H38+K38+N38+Q38","v":0},{"$f":"SUM(S38:T38)","v":0}]
[6235,"Lab Supplies",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,{"$f":"G39+J39+M39+P39","v":0},0,0]
[6247,"Equipment > $5000",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,0,0,0]
[6265,"Computer Software",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,0,0,0]
[6505,"Consulting Fees",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,0,0,0]
[6515,"Subcontract 1 < $25K",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,{"$f":"G43+J43+M43+P43","v":0},{"$f":"H43+K43+N43+Q43","v":0},0]
[6520,"Subcontract 1 > $25K",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,{"$f":"G44+J44+M44+P44","v":0},0,0]
[6515,"Subcontract 2 < $25K",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,0,0,0]
[6520,"Subcontract 2 > $25K",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,0,0,0]
[6515,"Total Sub < $25K",{"$nulls":4},{"$f":"SUM(G43,G45)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(P43,P45)","v":0},0,0,0,0,0]
[6520,"Total Sub > $25K",{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6602,"Student Stipends",{"$nulls":6},{"$f":"SUM(G49:H49)","v":0},null,null,{"$f":"SUM(J49:K49)","v":0},null,null,{"$f":"SUM(M49:N49)","v":0},null,null,{"$f":"SUM(P49:Q49)","v":0},{"$f":"G49+J49+M49+P49","v":0},0,{"$f":"SUM(S49:T49)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G50:H50)","v":0},null,null,{"$f":"SUM(J50:K50)","v":0},null,null,{"$f":"SUM(M50:N50)","v":0},null,null,{"$f":"SUM(P50:Q50)","v":0},0,0,{"$f":"SUM(S50:T50)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G51:H51)","v":0},null,null,{"$f":"SUM(J51:K51)","v":0},null,null,{"$f":"SUM(M51:N51)","v":0},null,null,{"$f":"SUM(P51:Q51)","v":0},0,0,{"$f":"SUM(S51:T51)","v":0}]
[6900,"Total Domestic Travel",{"$nulls":4},{"$f":"SUM(G50:G51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6930,"Foreign Travel",{"$nulls":6},{"$f":"SUM(G53:H53)","v":0},null,null,{"$f":"SUM(J53:K53)","v":0},null,null,{"$f":"SUM(M53:N53)","v":0},null,null,{"$f":"SUM(P53:Q53)","v":0},{"$f":"G53+J53+M53+P53","v":0},0,{"$f":"SUM(S53:T53)","v":0}]
[7010,"Publications",{"$nulls":6},{"$f":"SUM(G54:H54)","v":0},null,null,{"$f":"SUM(J54:K54)","v":0},null,null,{"$f":"SUM(M54:N54)","v":0},null,null,{"$f":"SUM(P54:Q54)","v":0},0,0,{"$f":"SUM(S54:T54)","v":0}]
[7225,"Tuition",{"$nulls":6},{"$f":"SUM(G55:H55)","v":0},null,null,{"$f":"SUM(J55:K55)","v":0},null,null,{"$f":"SUM(M55:N55)","v":0},null,null,{"$f":"SUM(P55:Q55)","v":0},0,0,{"$f":"SUM(S55:T55)","v":0}]
[null,"TOTAL NONPERSONNEL",{"$nulls":4},{"$f":"ROUND(SUM(G38:G42,G47:G49,G52:G55),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL DIRECT COSTS: NIH MODULAR (Less Subs I/C)",{"$nulls":4},{"$f":"SUM(G35,G56)-G67","v":0},{"$f":"SUM(H35,H56)-H67","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL DIRECT COSTS: MU (Includes Subs I/C)",{"$nulls":4},{"$f":"SUM(G35,G56)","v":0},{"$f":"SUM(H35,H56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"MTDC BASE",{"$nulls":4},{"$f":"G59-SUM(G40,G48,G55)","v":0},{"$f":"H59-SUM(H40,H48,H55)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[7520,"F&A Costs",{"$nulls":3},{"v":0.51,"d":"51.0%"},{"$f":"ROUND(SUM(G60*$F$61),0)","v":0},{"$f":"ROUND(SUM(H60*$F$61),0)","v":0},{"$f":"SUM(G61:H61)","v":0},{"$f":"ROUND(SUM(J60*$F$61),0)","v":0},{"$f":"ROUND(SUM(K60*$F$61),0)","v":0},{"$f":"SUM(J61:K61)","v":0},{"$f":"ROUND(SUM(M60*$F$61),0)","v":0},{"$f":"ROUND(SUM(N60*$F$61),0)","v":0},{"$f":"SUM(M61:N61)","v":0},{"$f":"ROUND(SUM(P60*$F$61),0)","v":0},{"$f":"ROUND(SUM(Q60*$F$61),0)","v":0},{"$f":"SUM(P61:Q61)","v":0},{"$f":"G61+J61+M61+P61","v":0},{"$f":"H61+K61+N61+Q61","v":0},{"$f":"SUM(S61:T61)","v":0}]
[null,"TOTAL PROJ COSTS",{"$nulls":4},{"$f":"SUM(G59,G61)","v":0},{"$f":"SUM(H59,H61)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":5},"F&A for Subcontracts"]
[{"$nulls":5},"#1",null,null,{"$f":"SUM(G65:H65)","v":0},null,null,{"$f":"SUM(J65:K65)","v":0},null,null,{"$f":"SUM(M65:N65)","v":0},null,null,{"$f":"SUM(P65:Q65)","v":0},{"$f":"G65+J65+M65+P65","v":0},{"$f":"H65+K65+N65+Q65","v":0},{"$f":"SUM(S65:T65)","v":0}]
[{"$nulls":5},"#2",null,null,{"$f":"SUM(G66:H66)","v":0},null,null,{"$f":"SUM(J66:K66)","v":0},null,null,{"$f":"SUM(M66:N66)","v":0},null,null,{"$f":"SUM(P66:Q66)","v":0},{"$f":"G66+J66+M66+P66","v":0},{"$f":"H66+K66+N66+Q66","v":0},{"$f":"SUM(S66:T66)","v":0}]
[{"$nulls":6},{"$f":"SUM(G65:G66)","v":0},{"$f":"SUM(H65:H66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"5 YEARS","index":4,"n_rows":67,"n_cols":24,"rows_kept":67,"merged":[[1,2,1,4],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,4],[4,0,4,1],[4,2,4,4],[5,0,5,1],[5,2,5,11],[6,0,6,1],[6,2,6,6],[7,2,7,4],[8,2,8,4],[9,6,9,8],[9,9,9,11],[9,12,9,14],[9,15,9,17],[9,18,9,20],[9,21,9,23],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[29,2,29,5],[30,2,30,4],[31,2,31,4],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[47,2,47,5],[48,2,48,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[55,2,55,5],[56,2,56,5],[59,2,59,5],[60,2,60,4],[61,2,61,5]]}
["Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff"]
[null,"MUID  ",{"$nulls":3},"ACCT  "]
["Prepared by  "]
["Last Modified on  ",null,{"$f":"NOW()","v":"2014-07-25T11:07:07.440"}]
["PI  ",{"$nulls":4},"DEPT  "]
["Project Title  "]
["Sponsor  "]
[null,"Budget Period  "]
[null,"Increase Annually By",1.03]
[{"$nulls":6},"PERIOD 1",null,null,"PERIOD 2",null,null,"PERIOD 3",null,null,"PERIOD 4",null,null,"PERIOD 5",null,null,"TOTAL"]
[null,"BUDGET ITEM","Name or Comment",{"$nulls":3},"GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL","GRANT","Cost Share","TOTAL"]
["A.","PERSONNEL"]
[6000,"PI Acad. Year",{"$nulls":6},{"$f":"SUM(G13:H13)","v":0},{"$f":"ROUND(G13*$C$9,0)","v":0},{"$f":"ROUND(H13*$C$9,0)","v":0},{"$f":"SUM(J13:K13)","v":0},{"$f":"ROUND(J13*$C$9,0)","v":0},{"$f":"ROUND(K13*$C$9,0)","v":0},{"$f":"SUM(M13:N13)","v":0},{"$f":"ROUND(M13*$C$9,0)","v":0},{"$f":"ROUND(N13*$C$9,0)","v":0},{"$f":"SUM(P13:Q13)","v":0},{"$f":"ROUND(P13*$C$9,0)","v":0},0,{"$f":"SUM(S13:T13)","v":0},{"$f":"G13+J13+M13+P13+S13","v":0},{"$f":"H13+K13+N13+Q13+T13","v":0},{"$f":"SUM(V13:W13)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},{"$f":"SUM(G14:H14)","v":0},{"$f":"ROUND(G14*$C$9,0)","v":0},0,{"$f":"SUM(J14:K14)","v":0},{"$f":"ROUND(J14*$C$9,0)","v":0},0,{"$f":"SUM(M14:N14)","v":0},{"$f":"ROUND(M14*$C$9,0)","v":0},0,{"$f":"SUM(P14:Q14)","v":0},0,0,{"$f":"SUM(S14:T14)","v":0},{"$f":"G14+J14+M14+P14+S14","v":0},0,{"$f":"SUM(V14:W14)","v":0}]
[6000,"Co-I Acad Year",{"$nulls":6},0,0,0,{"$f":"SUM(J15:K15)","v":0},0,0,{"$f":"SUM(M15:N15)","v":0},0,0,{"$f":"SUM(P15:Q15)","v":0},0,0,{"$f":"SUM(S15:T15)","v":0},0,0,{"$f":"SUM(V15:W15)","v":0}]
[6000,"Other Professional",{"$nulls":6},0,0,0,{"$f":"SUM(J16:K16)","v":0},0,0,{"$f":"SUM(M16:N16)","v":0},0,0,{"$f":"SUM(P16:Q16)","v":0},0,0,{"$f":"SUM(S16:T16)","v":0},0,0,{"$f":"SUM(V16:W16)","v":0}]
[6000,"Total Professional",{"$nulls":4},{"$f":"ROUND(SUM(G13:G16),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6007,"PI Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J18:K18)","v":0},{"$f":"ROUND(J18*$C$9,0)","v":0},0,{"$f":"SUM(M18:N18)","v":0},{"$f":"ROUND(M18*$C$9,0)","v":0},0,{"$f":"SUM(P18:Q18)","v":0},{"$f":"ROUND(P18*$C$9,0)","v":0},0,{"$f":"SUM(S18:T18)","v":0},{"$f":"G18+J18+M18+P18+S18","v":0},0,{"$f":"SUM(V18:W18)","v":0}]
[6007,"Co-I Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J19:K19)","v":0},0,0,{"$f":"SUM(M19:N19)","v":0},0,0,{"$f":"SUM(P19:Q19)","v":0},0,0,{"$f":"SUM(S19:T19)","v":0},0,0,{"$f":"SUM(V19:W19)","v":0}]
[6007,"Co-I Summer",{"$nulls":6},0,0,0,{"$f":"SUM(J20:K20)","v":0},0,0,{"$f":"SUM(M20:N20)","v":0},0,0,{"$f":"SUM(P20:Q20)","v":0},0,0,{"$f":"SUM(S20:T20)","v":0},0,0,{"$f":"SUM(V20:W20)","v":0}]
[6007,"Total Sumr Salaries",{"$nulls":4},{"$f":"ROUND(SUM(G18:G20),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6008,"Post Doc/Fellow Full-Time",{"$nulls":6},{"$f":"SUM(G22:H22)","v":0},0,0,{"$f":"SUM(J22:K22)","v":0},{"$f":"ROUND(J22*$C$9,0)","v":0},0,{"$f":"SUM(M22:N22)","v":0},{"$f":"ROUND(M22*$C$9,0)","v":0},0,{"$f":"SUM(P22:Q22)","v":0},{"$f":"ROUND(P22*$C$9,0)","v":0},{"$f":"ROUND(Q22*$C$9,0)","v":0},{"$f":"SUM(S22:T22)","v":0},{"$f":"G22+J22+M22+P22+S22","v":0},{"$f":"H22+K22+N22+Q22+T22","v":0},{"$f":"SUM(V22:W22)","v":0}]
[6012,"Clinical/Lab Staff Full-Time",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"G23+J23+M23+P23+S23","v":0},0,0]
[6013,"Clinical/Lab Staff Part-Time",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6020,"Full-Time Hourly Staff",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6035,"Part-Time Hourly Staff",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6050,"Undergraduate Students",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6024,"GRA-Academic Year","#:",null,"Biweekly $:",null,{"$f":"ROUND(D28*F28*20,0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"G28+J28+M28+P28+S28","v":0},{"$f":"H28+K28+N28+Q28+T28","v":0},0]
[6024,"GRA-Summer","#:",null,"Biweekly $:",null,{"$f":"ROUND(D29*F29*6,0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"G29+J29+M29+P29+S29","v":0},{"$f":"H29+K29+N29+Q29+T29","v":0},0]
[6024,"Total GRA",{"$nulls":4},{"$f":"SUM(G28:G29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6195,"Fringe FT",{"$nulls":3},{"v":0.285,"d":"28.5%"},{"$f":"ROUND($F$31*SUM(G17,G22,G23,G25),0)","v":0},{"$f":"ROUND($F$31*SUM(H17,H22,H23,H25),0)","v":0},{"$f":"SUM(G31:H31)","v":0},{"$f":"ROUND($F$31*SUM(J17,J22,J23,J25),0)","v":0},{"$f":"ROUND($F$31*SUM(K17,K22,K23,K25),0)","v":0},{"$f":"SUM(J31:K31)","v":0},{"$f":"ROUND($F$31*SUM(M17,M22,M23,M25),0)","v":0},{"$f":"ROUND($F$31*SUM(N17,N22,N23,N25),0)","v":0},{"$f":"SUM(M31:N31)","v":0},{"$f":"ROUND($F$31*SUM(P17,P22,P23,P25),0)","v":0},{"$f":"ROUND($F$31*SUM(Q17,Q22,Q23,Q25),0)","v":0},{"$f":"SUM(P31:Q31)","v":0},{"$f":"ROUND($F$31*SUM(S17,S22,S23,S25),0)","v":0},{"$f":"ROUND($F$31*SUM(T17,T22,T23,T25),0)","v":0},{"$f":"SUM(S31:T31)","v":0},{"$f":"G31+J31+M31+P31+S31","v":0},0,{"$f":"SUM(V31:W31)","v":0}]
[6195,"Fringe Summer",{"$nulls":3},{"v":0.16,"d":"16.0%"},{"$f":"ROUND($F$32*G21,0)","v":0},{"$f":"ROUND($F$32*H21,0)","v":0},{"$f":"SUM(G32:H32)","v":0},{"$f":"ROUND($F$32*J21,0)","v":0},{"$f":"ROUND($F$32*K21,0)","v":0},{"$f":"SUM(J32:K32)","v":0},{"$f":"ROUND($F$32*M21,0)","v":0},{"$f":"ROUND($F$32*N21,0)","v":0},{"$f":"SUM(M32:N32)","v":0},{"$f":"ROUND($F$32*P21,0)","v":0},{"$f":"ROUND($F$32*Q21,0)","v":0},{"$f":"SUM(P32:Q32)","v":0},{"$f":"ROUND($F$32*S21,0)","v":0},{"$f":"ROUND($F$32*T21,0)","v":0},{"$f":"SUM(S32:T32)","v":0},0,0,{"$f":"SUM(V32:W32)","v":0}]
[6195,"Fringe PT & Summer Students",{"$nulls":3},{"v":0.08,"d":"8.0%"},{"$f":"ROUND($F$33*SUM(G24,G26,G29),0)","v":0},{"$f":"ROUND($F$33*SUM(H24,H26,H29),0)","v":0},{"$f":"SUM(G33:H33)","v":0},{"$f":"ROUND($F$33*SUM(J24,J26,J29),0)","v":0},{"$f":"ROUND($F$33*SUM(K24,K26,K29),0)","v":0},{"$f":"SUM(J33:K33)","v":0},{"$f":"ROUND($F$33*SUM(M24,M26,M29),0)","v":0},{"$f":"ROUND($F$33*SUM(N24,N26,N29),0)","v":0},{"$f":"SUM(M33:N33)","v":0},{"$f":"ROUND($F$33*SUM(P24,P26,P29),0)","v":0},{"$f":"ROUND($F$33*SUM(Q24,Q26,Q29),0)","v":0},{"$f":"SUM(P33:Q33)","v":0},{"$f":"ROUND($F$33*SUM(S24,S26,S29),0)","v":0},{"$f":"ROUND($F$33*SUM(T24,T26,T29),0)","v":0},{"$f":"SUM(S33:T33)","v":0},0,0,{"$f":"SUM(V33:W33)","v":0}]
[6195,"Total Fringes",{"$nulls":4},{"$f":"ROUND(SUM(G31:G33),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL PERSONNEL",{"$nulls":4},{"$f":"SUM(G17,G21:G27,G30,G34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["B.","NONPERSONNEL"]
[6200,"Office Expenses",{"$nulls":6},{"$f":"SUM(G38:H38)","v":0},null,null,{"$f":"SUM(J38:K38)","v":0},null,null,{"$f":"SUM(M38:N38)","v":0},null,null,{"$f":"SUM(P38:Q38)","v":0},null,null,{"$f":"SUM(S38:T38)","v":0},{"$f":"G38+J38+M38+P38+S38","v":0},{"$f":"H38+K38+N38+Q38+T38","v":0},{"$f":"SUM(V38:W38)","v":0}]
[6235,"Lab Supplies",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"G39+J39+M39+P39+S39","v":0},0,0]
[6247,"Equipment > $5000",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
[6265,"Computer Software",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
[6505,"Consulting Fees",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
[6515,"Subcontract 1 < $25K",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"G43+J43+M43+P43+S43","v":0},{"$f":"H43+K43+N43+Q43+T43","v":0},0]
[6520,"Subcontract 1 > $25K",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"G44+J44+M44+P44+S44","v":0},0,0]
[6515,"Subcontract 2 < $25K",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
[6520,"Subcontract 2 > $25K",{"$nulls":6},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
[6515,"Total Sub < $25K",{"$nulls":4},{"$f":"SUM(G43,G45)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S43,S45)","v":0},0,0,0,0,0]
[6520,"Total Sub > $25K",{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6602,"Student Stipends",{"$nulls":6},{"$f":"SUM(G49:H49)","v":0},null,null,{"$f":"SUM(J49:K49)","v":0},null,null,{"$f":"SUM(M49:N49)","v":0},null,null,{"$f":"SUM(P49:Q49)","v":0},null,null,{"$f":"SUM(S49:T49)","v":0},{"$f":"G49+J49+M49+P49+S49","v":0},0,{"$f":"SUM(V49:W49)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G50:H50)","v":0},null,null,{"$f":"SUM(J50:K50)","v":0},null,null,{"$f":"SUM(M50:N50)","v":0},null,null,{"$f":"SUM(P50:Q50)","v":0},null,null,{"$f":"SUM(S50:T50)","v":0},0,0,{"$f":"SUM(V50:W50)","v":0}]
[6900,"Domestic Travel",{"$nulls":6},{"$f":"SUM(G51:H51)","v":0},null,null,{"$f":"SUM(J51:K51)","v":0},null,null,{"$f":"SUM(M51:N51)","v":0},null,null,{"$f":"SUM(P51:Q51)","v":0},null,null,{"$f":"SUM(S51:T51)","v":0},0,0,{"$f":"SUM(V51:W51)","v":0}]
[6900,"Total Domestic Travel",{"$nulls":4},{"$f":"SUM(G50:G51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6930,"Foreign Travel",{"$nulls":6},{"$f":"SUM(G53:H53)","v":0},null,null,{"$f":"SUM(J53:K53)","v":0},null,null,{"$f":"SUM(M53:N53)","v":0},null,null,{"$f":"SUM(P53:Q53)","v":0},null,null,{"$f":"SUM(S53:T53)","v":0},{"$f":"G53+J53+M53+P53+S53","v":0},0,{"$f":"SUM(V53:W53)","v":0}]
[7010,"Publications",{"$nulls":6},{"$f":"SUM(G54:H54)","v":0},null,null,{"$f":"SUM(J54:K54)","v":0},null,null,{"$f":"SUM(M54:N54)","v":0},null,null,{"$f":"SUM(P54:Q54)","v":0},null,null,{"$f":"SUM(S54:T54)","v":0},0,0,{"$f":"SUM(V54:W54)","v":0}]
[7225,"Tuition",{"$nulls":6},{"$f":"SUM(G55:H55)","v":0},null,null,{"$f":"SUM(J55:K55)","v":0},null,null,{"$f":"SUM(M55:N55)","v":0},null,null,{"$f":"SUM(P55:Q55)","v":0},null,null,{"$f":"SUM(S55:T55)","v":0},0,0,{"$f":"SUM(V55:W55)","v":0}]
[null,"TOTAL NONPERSONNEL",{"$nulls":4},{"$f":"ROUND(SUM(G38:G42,G47:G49,G52:G55),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL DIRECT COSTS: NIH MODULAR (Less Subs I/C)",{"$nulls":4},{"$f":"SUM(G35,G56)-G67","v":0},{"$f":"SUM(H35,H56)-H67","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL DIRECT COSTS: MU (Includes Subs I/C)",{"$nulls":4},{"$f":"SUM(G35,G56)","v":0},{"$f":"SUM(H35,H56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"MTDC BASE",{"$nulls":4},{"$f":"G59-SUM(G40,G48,G55)","v":0},{"$f":"H59-SUM(H40,H48,H55)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7520,"F&A Costs",{"$nulls":3},{"v":0.51,"d":"51.0%"},{"$f":"ROUND(SUM(G60*$F$61),0)","v":0},{"$f":"ROUND(SUM(H60*$F$61),0)","v":0},{"$f":"SUM(G61:H61)","v":0},{"$f":"ROUND(SUM(J60*$F$61),0)","v":0},{"$f":"ROUND(SUM(K60*$F$61),0)","v":0},{"$f":"SUM(J61:K61)","v":0},{"$f":"ROUND(SUM(M60*$F$61),0)","v":0},{"$f":"ROUND(SUM(N60*$F$61),0)","v":0},{"$f":"SUM(M61:N61)","v":0},{"$f":"ROUND(SUM(P60*$F$61),0)","v":0},{"$f":"ROUND(SUM(Q60*$F$61),0)","v":0},{"$f":"SUM(P61:Q61)","v":0},{"$f":"ROUND(SUM(S60*$F$61),0)","v":0},{"$f":"ROUND(SUM(T60*$F$61),0)","v":0},{"$f":"SUM(S61:T61)","v":0},{"$f":"G61+J61+M61+P61+S61","v":0},{"$f":"H61+K61+N61+Q61+T61","v":0},{"$f":"SUM(V61:W61)","v":0}]
[null,"TOTAL PROJ COSTS",{"$nulls":4},{"$f":"SUM(G59,G61)","v":0},{"$f":"SUM(H59,H61)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":5},"F&A for Subcontracts"]
[{"$nulls":5},"#1",null,null,{"$f":"SUM(G65:H65)","v":0},null,null,{"$f":"SUM(J65:K65)","v":0},null,null,{"$f":"SUM(M65:N65)","v":0},null,null,{"$f":"SUM(P65:Q65)","v":0},null,null,{"$f":"SUM(S65:T65)","v":0},{"$f":"G65+J65+M65+P65+S65","v":0},{"$f":"H65+K65+N65+Q65+T65","v":0},{"$f":"SUM(V65:W65)","v":0}]
[{"$nulls":5},"#2",null,null,{"$f":"SUM(G66:H66)","v":0},null,null,{"$f":"SUM(J66:K66)","v":0},null,null,{"$f":"SUM(M66:N66)","v":0},null,null,{"$f":"SUM(P66:Q66)","v":0},null,null,{"$f":"SUM(S66:T66)","v":0},{"$f":"G66+J66+M66+P66+S66","v":0},{"$f":"H66+K66+N66+Q66+T66","v":0},{"$f":"SUM(V66:W66)","v":0}]
[{"$nulls":6},{"$f":"SUM(G65:G66)","v":0},{"$f":"SUM(H65:H66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]