{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Generic 5yr Budget","Look up tables"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"comments":1,"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":"1904"}

{"sheet":"Generic 5yr Budget","index":0,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,2,3,9],[4,3,4,9]]}
["Louisiana State University and Agricultural and Mechanical College"]
["Proposal Budget"]
["Cumulative Budget"]
["Project Title:",null,"(Insert project title here.  Sheet will auto-fill on subsequent years/composite)"]
["Principal Investigator(s):",null,null,"(Insert investigator(s) here.  Sheet will auto-fill on subsequent years/composite)"]
[]
[]
[null,null,null,null,null,null,"On-Campus Funds","Off-Campus Funds","Total Requested"]
[null,null,"A.","Senior Personnel Salaries and Wages"]
[null,null,null,"1.",null,null,0,0,{"$f":"SUM(G10:H10)","v":0}]
[null,null,null,"2.",null,null,0,0,{"$f":"SUM(G11:H11)","v":0}]
[null,null,null,"3.",null,null,0,0,0]
[null,null,null,"4.",null,null,0,0,0,null,"Enter Projected Start Date (Month/Year)"]
[null,null,null,"5.",null,null,0,0,0]
[null,null,null,"6.","Other Investigators (list on justification)",null,0,0,0]
[null,null,"B.","Other Personnel Salaries and Wages"]
[null,null,null,"1.","Postdoctoral Associates",null,0,0,0]
[null,null,null,"2.","Other Professionals",null,0,0,0]
[null,null,null,"3.","Graduate Assistants",null,0,0,0]
[null,null,null,"4.","Student Workers",null,0,0,0]
[null,null,null,"5.","Contingent Employees/Transients",null,0,0,0]
[null,null,"C.","Subtotal Salaries and Wages",null,null,{"$f":"SUM(G10:G21)","v":0},{"$f":"SUM(H10:H21)","v":0},0]
[null,null,"D.","Fringe Benefits  "]
[null,null,null,"Regular Employees                        @",null,0.41,{"$f":"ROUND(($F$24)*SUM(G10:G18),0)","v":0},{"$f":"ROUND(($F$24)*SUM(H10:H18),0)","v":0},0,null,null,"On Campus","Off Campus"]
[null,null,null,"Contingent Employee/Transients    @",null,7.6499999999999999E-2,{"$f":"ROUND(G21*$F$25,0)","v":0},{"$f":"ROUND(H21*$F$25,0)","v":0},0,null,"Type of Graduate Assistant","Effort in Months (combined for all On campus GAs)","Effort in Months (combined for all On campus GAs)","On Campus","Off Campus","Total"]
[null,null,null,"Graduate Assistants",null,null,{"$f":"N29","v":0},{"$f":"O29","v":0},0,null,"Calendar",null,null,{"$f":"(L26/12)*2162","v":0},{"$f":"(M26/12)*2162","v":0},{"$f":"((L26+M26)/12)*2162","v":0}]
[null,null,"E.","Subtotal Fringe Benefits",null,null,{"$f":"SUM(G24:G26)","v":0},{"$f":"SUM(H24:H26)","v":0},0,null,"Academic ",null,null,{"$f":"(L27/9)*1730","v":0},{"$f":"(M27/9)*1730","v":0},{"$f":"((L27+M27)/9)*1730","v":0}]
[null,null,"F.","Total Salaries, Wages and Fringe",null,null,{"$f":"SUM(G22+G27)","v":0},{"$f":"SUM(H22+H27)","v":0},0,null,"Summer",null,null,{"$f":"(L28/3)*432","v":0},{"$f":"(M28/3)*432","v":0},{"$f":"((L28+M28)/3)*432","v":0}]
[null,null,"G.","Travel",null,null,0,0,0,null,null,null,null,{"$f":"SUM(N26:N28)","v":0},{"$f":"SUM(O26:O28)","v":0},0]
[null,null,"H.","Supplies",null,null,0,0,0]
[null,null,"I.","Operating Services",null,null,0,0,0]
[null,null,"J.","Professional Services"]
[null,null,null,"1. Consultants",null,null,0,0,{"$f":"SUM(G33:H33)","v":0}]
[null,null,null,"2. Other Services",null,null,0,0,0]
[null,null,"K.","Other Charges",null,null,0,0,0]
[null,null,"L.","Equipment",null,null,0,0,0]
[null,null,"M.","Partcipant Support Costs",null,null,0,0,0]
[null,null,"M.","Tuition Remission                           @",null,0.38,{"$f":"G19*$F$38","v":0},{"$f":"H19*$F$38","v":0},0]
[null,null,"N.","Total Direct Costs",null,null,{"$f":"SUM(G28:G38)","v":0},{"$f":"SUM(H28:H38)","v":0},0]
[]
[null,null,"Percentage of Direct Costs",null,null,null,{"$f":"G39/I39","v":{"$error":"#DIV/0!"}},{"$f":"H39/I39","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"* Subawards are not included in decision to use on- or off-campus rate."]

{"sheet":"Look up tables","index":1,"n_rows":102,"n_cols":6,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
[]
["2019-01-01",null,null,null,null,"Research Non-State On-Campus"]
["2019-02-01",null,null,null,null,"Research State On-Campus"]
["2019-03-01",null,null,null,null,"Public Service Non-State On-Campus"]
["2019-04-01",null,null,null,null,"Public Service State On-Campus"]
["2019-05-01",null,null,null,null,"Instruction Non-State On-Campus"]
["2019-06-01",null,null,null,null,"Instruction State On-Campus"]
["2019-07-01",null,null,null,null,"Off-Campus Non-State"]
["2019-08-01",null,null,null,null,"Off-Campus State"]
["2019-09-01",null,null,null,null,"Other (enter rate below)"]
["2019-10-01"]
["2019-11-01"]
["2019-12-01"]
["2020-01-01"]
["2020-02-01"]
["2020-03-01"]
["2020-04-01"]
["2020-05-01"]
["2020-06-01"]
["2020-07-01"]
["2020-08-01"]
["2020-09-01"]
["2020-10-01"]
["2020-11-01"]
["2020-12-01"]
["2021-01-01"]
["2021-02-01"]
["2021-03-01"]
["2021-04-01"]
["2021-05-01"]
["2021-06-01"]
["2021-07-01"]
["2021-08-01"]
["2021-09-01"]
["2021-10-01"]
["2021-11-01"]
["2021-12-01"]
["2022-01-01"]
["2022-02-01"]
["2022-03-01"]
["2022-04-01"]
["2022-05-01"]
["2022-06-01"]
[{"$f":"A43+31","v":"2022-07-02"}]
[{"$f":"A44+31","v":"2022-08-02"}]
["2022-09-02"]
["2022-10-03"]
["2022-11-03"]
["2022-12-04"]
["2023-01-04"]
["2023-02-04"]
["2023-03-07"]
["2023-04-07"]
["2023-05-08"]
["2023-06-08"]
["2023-07-09"]
["2023-08-09"]
["2023-09-09"]
["2023-10-10"]
["2023-11-10"]
["2023-12-11"]
["2024-01-11"]
["2024-02-11"]
["2024-03-13"]
["2024-04-13"]
["2024-05-14"]
["2024-06-14"]
["2024-07-15"]
["2024-08-15"]
["2024-09-15"]
["2024-10-16"]
["2024-11-16"]
["2024-12-17"]
["2025-01-17"]
["2025-02-17"]
["2025-03-20"]
["2025-04-20"]
["2025-05-21"]
["2025-06-21"]
["2025-07-22"]
["2025-08-22"]
["2025-09-22"]
["2025-10-23"]
["2025-11-23"]
["2025-12-24"]
["2026-01-24"]
["2026-02-24"]
["2026-03-27"]
["2026-04-27"]
["2026-05-28"]
["2026-06-28"]
["2026-07-29"]
["2026-08-29"]
["2026-09-29"]
["2026-10-30"]
["2026-11-30"]
["2026-12-31"]
["2027-01-31"]
["2027-03-03"]
[{"$f":"A99+31","v":"2027-04-03"}]
["2027-05-04"]
["2027-06-04"]