{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["External Grant Budget","List Options"],"not_rendered":{"charts":0,"images":0,"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":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[15,1,15,3],[8,5,8,17],[9,5,9,17],[10,5,10,17],[13,5,13,7],[13,9,13,11],[13,13,13,15]]}
["TIAA","Course Release"]
["SERS","Additonal Compensation"]
["Social Security","SCUPA"]
["Medicare","AFSCME"]
["OTHER","N/A"]
["Shippensburg University"]
["Institute for Public Service and Sponsored Programs"]
["Grant Budget Template"]
[null,null,null,null,null,"Name of PI(s)"]
[null,null,null,null,null,"Title of Grant Proposal"]
[null,null,null,null,null,"$ Amount Total 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,"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,"Total",null,"Notes:"]
[null,"Example","Additonal Compensation",25,null,10,null,{"$f":"ROUND(D18*F18,2)","v":250},null,10,null,{"$f":"ROUND((D18*J18)*1.03,2)","v":257.5},null,10,null,{"$f":"ROUND((D18*N18)*1.03*1.03,2)","v":265.23},null,{"$f":"H18+L18+P18","v":772.73}]
[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,{"$f":"H19+L19+P19","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,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,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,0]
[]
[null,"TOTAL SALARIES",null,null,null,null,null,{"$f":"SUM(H18:H22)","v":250},null,null,null,{"$f":"SUM(L18:L22)","v":257.5},null,null,null,{"$f":"SUM(P18:P22)","v":265.23},null,{"$f":"SUM(R18:R22)","v":772.73}]
[]
[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":15.5},null,null,null,{"$f":"+$L$24*C27","v":15.965},null,null,null,{"$f":"+$P$24*C27","v":16.44426},null,{"$f":"H27+L27+P27","v":47.909260000000003}]
[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":3.625},null,null,null,{"$f":"+$L$24*C28","v":3.7337500000000001},null,null,null,{"$f":"+$P$24*C28","v":3.8458350000000006},null,{"$f":"H28+L28+P28","v":11.204585000000002}]
[null,"TIAA",9.2899999999999996E-2,null,null,null,null,23.224999999999998,null,null,null,23.921749999999999,null,null,null,24.639867000000002,null,71.786617000000007]
[null,"OTHER",0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,0]
[null,"OTHER",null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,0]
[]
[null,"TOTAL BENEFITS",null,null,null,null,null,{"$f":"SUM(H27:H31)","v":42.349999999999994},null,null,null,{"$f":"SUM(L27:L31)","v":43.6205},null,null,null,{"$f":"SUM(P27:P31)","v":44.929962000000003},null,{"$f":"SUM(R27:R31)","v":130.900462}]
[]
["TOTAL PERSONNEL",null,null,null,null,null,null,{"$f":"H24+H33","v":292.35000000000002},null,null,null,{"$f":"L24+L33","v":301.12049999999999},null,null,null,{"$f":"P24+P33","v":310.15996200000001},null,{"$f":"R24+R33","v":903.63046200000008}]
[]
["OTHER EXPENSES"]
[null,"PURCHASED SERVICES"]
[null,"    Printing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H39+L39+P39","v":0}]
[null,"    Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H40+L40+P40","v":0}]
[null,"    Consultants",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:H41)","v":0},null,null,null,{"$f":"SUM(L39:L41)","v":0},null,null,null,{"$f":"SUM(P39:P41)","v":0},null,{"$f":"SUM(R39:R41)","v":0}]
[]
[null,"SUPPLIES & OTHER"]
[null,"    Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H46+L46+P46","v":0}]
[null,"    Materials",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H47+L47+P47","v":0}]
[null,"    Equipment",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,0]
[]
[null,"TOTAL SUPPLIES & OTHER",null,null,null,null,null,{"$f":"SUM(H46:H49)","v":0},null,null,null,{"$f":"SUM(L46:L49)","v":0},null,null,null,{"$f":"SUM(P46:P49)","v":0},null,{"$f":"SUM(R46:R49)","v":0}]
[]
["TOTAL OTHER EXPENSES",null,null,null,null,null,null,{"$f":"H43+H51","v":0},null,null,null,{"$f":"L43+L51","v":0},null,null,null,{"$f":"P43+P51","v":0},null,{"$f":"R43+R51","v":0}]
[]
["TOTAL DIRECT EXPENSES",null,null,null,null,null,null,{"$f":"H35+H53","v":292.35000000000002},null,null,null,{"$f":"L35+L53","v":301.12049999999999},null,null,null,{"$f":"P35+P53","v":310.15996200000001},null,{"$f":"R35+R53","v":903.63046200000008}]
[]
["INDIRECT COSTS"]
[null,"Indirect Base","Rate (%)"]
[null,"Salary, Wages & Benefits",0.45,null,null,null,null,{"$f":"ROUND(IF(B59=\"Salary & Wages\", H24*C59,IF(B59=\"Salary, Wages & Benefits\",H35*C59,IF(B59=\"Total Direct Costs\",H55*C59,0))),2)","v":131.56},null,null,null,{"$f":"ROUND(IF(B59=\"Salary & Wages\", L24*C59,IF(B59=\"Salary, Wages & Benefits\",L35*C59,IF(B59=\"Total Direct Costs\",L55*C59,0))),2)","v":135.5},null,null,null,{"$f":"ROUND(IF(B59=\"Salary & Wages\", P24*C59,IF(B59=\"Salary, Wages & Benefits\",P35*C59,IF(B59=\"Total Direct Costs\",P55*C59,0))),2)","v":139.57},null,{"$f":"H59+L59+P59","v":406.63}]
[]
["TOTAL BUDGET",null,null,null,null,null,null,{"$f":"H55+H59","v":423.91},null,null,null,{"$f":"L55+L59","v":436.62049999999999},null,null,null,{"$f":"P55+P59","v":449.729962},null,{"$f":"R55+R59","v":1310.2604620000002}]

{"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"]