{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["External Grant Budget","List Options"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"External Grant Budget","index":0,"n_rows":62,"n_cols":28,"rows_kept":62,"cut":false,"hidden":false,"merged":[[15,1,15,3],[8,5,8,25],[9,5,9,25],[10,5,10,25],[13,5,13,7],[13,9,13,11],[13,13,13,15],[13,17,13,19],[13,21,13,23]]}
["TIAA","Course Release"]
["SERS","Additonal Compensation"]
["Social Security","SCUPA"]
["Medicare","AFSCME"]
["OTHER","N/A"]
[]
[]
[null,"East Stroudsburg University"]
[null,"Office of Sponsored Projects and Research",null,null,null,"Name of PI(s)"]
[null,"Grant Budget Template",null,null,null,"Title of Grant Proposal"]
[null,null,null,null,null,"Amount and estimated Period of Performance"]
[]
[]
[null,null,null,null,null,"Year 1",null,null,null,"Year 2",null,null,null,"Year 3",null,null,null,"Year 4",null,null,null,"Year 5",null,null,null,"TOTAL"]
["PERSONNEL"]
[null,"SALARIES & WAGES"]
[null,"Position/Name","Type of Compensation","Hourly Rate",null,"Hours",null,"Total",null,"Hours",null,"Total",null,"Hours",null,"Total",null,"Hours",null,"Total",null,"Hours",null,"Total",null,"Total",null,"Notes:"]
[null,"Example","Additonal Compensation",25,null,1,null,{"$f":"ROUND(D18*F18,2)","v":25},null,1,null,{"$f":"ROUND((D18*J18)*1.03,2)","v":25.75},null,1,null,{"$f":"ROUND((D18*N18)*1.03*1.03,2)","v":26.52},null,1,null,{"$f":"ROUND((D18*R18)*1.03*1.03*1.03,2)","v":27.32},null,1,null,{"$f":"ROUND((D18*V18)*1.03*1.03*1.03*1.03,2)","v":28.14},null,{"$f":"H18+L18+P18+T18+X18","v":132.73000000000002}]
[null,null,null,null,null,null,null,{"$f":"ROUND(D19*F19,2)","v":0},null,null,null,{"$f":"ROUND((D19*J19)*1.03,2)","v":0},null,null,null,{"$f":"ROUND((D19*N19)*1.03*1.03,2)","v":0},null,null,null,{"$f":"ROUND((D19*R19)*1.03*1.03*1.03,2)","v":0},null,null,null,{"$f":"ROUND((D19*V19)*1.03*1.03*1.03*1.03,2)","v":0},null,{"$f":"H19+L19+P19+T19+X19","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(D20*F20,2)","v":0},null,null,null,{"$f":"ROUND((D20*J20)*1.03,2)","v":0},null,null,null,{"$f":"ROUND((D20*N20)*1.03*1.03,2)","v":0},null,null,null,0,null,null,null,0,null,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(D21*F21,2)","v":0},null,null,null,{"$f":"ROUND((D21*J21)*1.03,2)","v":0},null,null,null,{"$f":"ROUND((D21*N21)*1.03*1.03,2)","v":0},null,null,null,0,null,null,null,0,null,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(D22*F22,2)","v":0},null,null,null,{"$f":"ROUND((D22*J22)*1.03,2)","v":0},null,null,null,{"$f":"ROUND((D22*N22)*1.03*1.03,2)","v":0},null,null,null,0,null,null,null,0,null,0]
[]
[null,"TOTAL SALARIES",null,null,null,null,null,{"$f":"SUM(H18:H23)","v":25},null,null,null,{"$f":"SUM(L18:L22)","v":25.75},null,null,null,{"$f":"SUM(P18:P22)","v":26.52},null,null,null,{"$f":"SUM(T18:T22)","v":27.32},null,null,null,{"$f":"SUM(X18:X22)","v":28.14},null,{"$f":"SUM(Z18:Z23)","v":132.73000000000002}]
[]
[null,"BENEFITS (pick from drop down box)"]
[null,"Social Security",{"$f":"IF(B27=\"SERS\",0.2483,IF(B27=\"PSERS\",0.2057,IF(B27=\"TIAA\",0.0929,IF(B27=\"Social Security\",0.062,IF(B27=\"Medicare\",0.0145,0)))))","v":6.2E-2},null,null,null,null,{"$f":"+$H$24*C27","v":1.55},null,null,null,{"$f":"+$L$24*C27","v":1.5965},null,null,null,{"$f":"+$P$24*C27","v":1.6442399999999999},null,null,null,{"$f":"+$T$24*C27","v":1.69384},null,null,null,{"$f":"+$X$24*C27","v":1.74468},null,{"$f":"H27+L27+P27+T27+X27","v":8.22926}]
[null,"Medicare",{"$f":"IF(B28=\"SERS\",0.2483,IF(B28=\"PSERS\",0.2057,IF(B28=\"TIAA\",0.0929,IF(B28=\"Social Security\",0.062,IF(B28=\"Medicare\",0.0145,0)))))","v":1.4500000000000001E-2},null,null,null,null,{"$f":"+$H$24*C28","v":0.36250000000000004},null,null,null,{"$f":"+$L$24*C28","v":0.37337500000000001},null,null,null,{"$f":"+$P$24*C28","v":0.38453999999999999},null,null,null,{"$f":"+$T$24*C28","v":0.39614000000000005},null,null,null,{"$f":"+$X$24*C28","v":0.40803},null,{"$f":"H28+L28+P28+T28+X28","v":1.924585}]
[null,"TIAA",9.2899999999999996E-2,null,null,null,null,2.3224999999999998,null,null,null,{"$f":"+$L$24*C29","v":2.3921749999999999},null,null,null,{"$f":"+$P$24*C29","v":2.463708},null,null,null,2.5380279999999997,null,null,null,2.6142059999999998,null,12.330617]
[null,"OTHER",0,null,null,null,null,0,null,null,null,{"$f":"+$L$24*C30","v":0},null,null,null,{"$f":"+$P$24*C30","v":0},null,null,null,0,null,null,null,0,null,0]
[null,"OTHER",null,null,null,null,null,0,null,null,null,{"$f":"+$L$24*C31","v":0},null,null,null,{"$f":"+$P$24*C31","v":0},null,null,null,0,null,null,null,0,null,0]
[]
[null,"TOTAL BENEFITS",null,null,null,null,null,{"$f":"SUM(H27:H31)","v":4.2349999999999994},null,null,null,{"$f":"SUM(L27:L31)","v":4.36205},null,null,null,{"$f":"SUM(P27:P31)","v":4.4924879999999998},null,null,null,{"$f":"SUM(T27:T31)","v":4.6280079999999995},null,null,null,{"$f":"SUM(X27:X31)","v":4.7669160000000002},null,{"$f":"SUM(Z27:Z31)","v":22.484462000000001}]
[]
["TOTAL PERSONNEL",null,null,null,null,null,null,{"$f":"H24+H33","v":29.234999999999999},null,null,null,{"$f":"L24+L33","v":30.11205},null,null,null,{"$f":"P24+P33","v":31.012487999999998},null,null,null,{"$f":"T24+T33","v":31.948008000000002},null,null,null,{"$f":"X24+X33","v":32.906916000000002},null,{"$f":"Z24+Z33","v":155.21446200000003}]
[]
["OTHER EXPENSES"]
[null,"PURCHASED SERVICES"]
[null,"    Printing",null,null,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,{"$f":"H39+L39+P39+T39+X39","v":5}]
[null,"    Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H40+L40+P40+T40+X40","v":0}]
[null,"    Consultants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0]
[null,"TOTAL PURCHASED SERVICES",null,null,null,null,null,{"$f":"SUM(H39:H42)","v":1},null,null,null,{"$f":"SUM(L39:L42)","v":1},null,null,null,{"$f":"SUM(P39:P42)","v":1},null,null,null,{"$f":"SUM(T39:T42)","v":1},null,null,null,{"$f":"SUM(X39:X42)","v":1},null,{"$f":"SUM(Z39:Z42)","v":5}]
[]
[null,"SUPPLIES & OTHER"]
[null,"    Supplies",null,null,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,{"$f":"H46+L46+P46+T46+X46","v":5}]
[null,"    Materials",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H47+L47+P47+T47+X47","v":0}]
[null,"    Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"H51+L51+P51+T51+X51","v":0}]
[null,"TOTAL SUPPLIES & OTHER",null,null,null,null,null,{"$f":"SUM(H46:H51)","v":1},null,null,null,{"$f":"SUM(L46:L51)","v":1},null,null,null,{"$f":"SUM(P46:P51)","v":1},null,null,null,{"$f":"SUM(T46:T51)","v":1},null,null,null,{"$f":"SUM(X46:X51)","v":1},null,{"$f":"SUM(Z46:Z51)","v":5}]
[]
["TOTAL OTHER EXPENSES",null,null,null,null,null,null,{"$f":"H43+H52","v":2},null,null,null,{"$f":"L43+L52","v":2},null,null,null,{"$f":"P43+P52","v":2},null,null,null,{"$f":"T43+T52","v":2},null,null,null,{"$f":"X43+X52","v":2},null,{"$f":"Z43+Z52","v":10}]
[]
["TOTAL DIRECT EXPENSES",null,null,null,null,null,null,{"$f":"H35+H54","v":31.234999999999999},null,null,null,{"$f":"L35+L54","v":32.112049999999996},null,null,null,{"$f":"P35+P54","v":33.012487999999998},null,null,null,{"$f":"T35+T54","v":33.948008000000002},null,null,null,{"$f":"X35+X54","v":34.906916000000002},null,{"$f":"Z35+Z54","v":165.21446200000003}]
[]
["INDIRECT COSTS"]
[null,"Indirect Base","Rate (%)"]
[null,"Salary, Wages & Benefits",0.53120000000000001,null,null,null,null,{"$f":"ROUND(IF($B60=\"Salary & Wages\", H24*$C60,IF($B60=\"Salary, Wages & Benefits\",H35*$C60,IF($B60=\"Total Direct Costs\",H56*$C60,0))),2)","v":15.53},null,null,null,{"$f":"ROUND(IF($B60=\"Salary & Wages\", L24*$C60,IF($B60=\"Salary, Wages & Benefits\",L35*$C60,IF($B60=\"Total Direct Costs\",L56*$C60,0))),2)","v":16},null,null,null,{"$f":"ROUND(IF($B60=\"Salary & Wages\", P24*$C60,IF($B60=\"Salary, Wages & Benefits\",P35*$C60,IF($B60=\"Total Direct Costs\",P56*$C60,0))),2)","v":16.47},null,null,null,{"$f":"ROUND(IF($B60=\"Salary & Wages\", T24*$C60,IF($B60=\"Salary, Wages & Benefits\",T35*$C60,IF($B60=\"Total Direct Costs\",T56*$C60,0))),2)","v":16.97},null,null,null,{"$f":"ROUND(IF($B60=\"Salary & Wages\", X24*$C60,IF($B60=\"Salary, Wages & Benefits\",X35*$C60,IF($B60=\"Total Direct Costs\",X56*$C60,0))),2)","v":17.48},null,{"$f":"H60+L60+P60+T60+X60","v":82.45}]
[]
["TOTAL BUDGET",null,null,null,null,null,null,{"$f":"H56+H60","v":46.765000000000001},null,null,null,{"$f":"L56+L60","v":48.112049999999996},null,null,null,{"$f":"P56+P60","v":49.482487999999996},null,null,null,{"$f":"T56+T60","v":50.918008},null,null,null,{"$f":"X56+X60","v":52.386915999999999},null,{"$f":"Z56+Z60","v":247.66446200000001}]

{"sheet":"List Options","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Benefits",null,null,"Indirect"]
[null,"TIAA",null,null,"Salary & Wages"]
[null,"SERS",null,null,"Salary, Wages & Benefits"]
[null,"PSERS",null,null,"Total Direct Costs"]
[null,"N/A"]
[null,"STUDENT"]