{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Year 1","Year 2","Year 3","Year 4","Year 5","Budget Detail Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"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":"Instructions","index":0,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,9,7],[10,1,10,7],[13,9,20,13],[22,9,27,13],[13,1,13,7],[22,1,22,7],[12,9,12,13],[81,2,81,7],[82,2,82,7],[83,2,83,7],[77,2,77,7],[73,1,73,7],[74,2,74,7],[75,2,75,7],[76,2,76,7],[78,2,78,7],[53,9,58,13],[29,9,36,13],[79,2,79,7],[80,2,80,7],[60,9,65,13],[60,1,60,7],[38,9,43,13],[45,9,50,13],[29,1,29,7],[38,1,38,7],[45,1,45,7],[53,1,53,7]]}
[]
[null,"Budget Worksheet Instructions"]
[null,"This worksheet uses macros. You must enable the macros and trust the document for the workbook to function correctly. \n\nPurpose: This template provides a consistent method for applicants to submit their grant budget proposals and ensure an equitable review process as all applicants will have included the same level of information. This will also assist applicants in considering more specifics of their proposals and facilitate applicants with writing their budget narratives. \n\nAbout the workbook: This workbook consists of seven tabs, including this instructions tab, five budget year tabs, and a budget detail summary. Applicants are required to complete only the number of budget years applicable to the respective grant for which they are applying. Each budget year sheet is identifcal and the budget deail summary sheet culminates all of the information from each completed budget year sheet. "]
[]
[]
[]
[]
[]
[]
[]
[null,"General Instructions:\n1. Each budget category starts with two useable rows in which you can add your line items.\n2. Do not enter information into the first row of each section (the row containing the add and delete row buttons).\n3. To add rows to a section, select a cell in that section before selecting the \"Add Row\" button. (If you do not, you may receive an error message or a row may appear in the wrong place) \n4. If you know the number of rows you will need in each section, it is recommended to add all rows before entering information (for ease of use).\n5. If you add too many rows to a section, you may delete unnecessary rows. \n6. To delete a row, select a cell in the desired row and then select \"Delete Row.\"\n7. Complete all columns for each line item you enter, even if you enter a 0 or N/A.\n8. After completing all line items for each required grant year, review the budget detail summary to ensure everything is correct.\n\nSee below for an example budget. Definitions for each category and other important terms can be found below the example budget."]
[]
[null,"Example Budget",null,null,null,null,null,null,null,"Explanations"]
[null,"Personnel",null,null,null,null,null,null,null,"Tim is being paid an hourly rate of $53. The grantee anticipates that he will work 1040 hours in year 1 and 100% of those hours will be dedicated to the project.\n\nJuanita is a salaried employee. Her time worked is 1 to represent her 1 year's worth of salary contributions. The grantee anticipates that she will spend 25% of her time on the grant project, and that time will be paid for through grant funds.\n"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Percentage","Total Cost"]
[null,null,null,"(Do not enter information into this row)"]
[null,"Tim Smith","Data Analyst",53,"Hourly",1040,1,{"$f":"D17*F17*G17","v":55120}]
[null,"Juanita Martinez","Lead Researcher",105000,"Yearly",1,0.25,{"$f":"D18*F18*G18","v":26250}]
[null,null,null,null,null,null,null,{"$f":"D19*F19*G19","v":0}]
[null,null,null,null,null,null,null,{"$f":"D20*F20*G20","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table216[Total Cost])","v":81370}]
[]
[null,"Fringe Benefits",null,null,null,null,null,null,null,"The grantee will pay for a portion of Tim's healthcare to offset the cost of being a part-time employee paying out of pocket for healthcare. The applicant has agreed to cover 10% of the healthcare cost"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Fringe Percentage","Total Cost"]
[null,null,null,"(Do not enter information into this row)"]
[null,"Tim Smith","Data Analyst",53,"Hourly",1040,0.1,{"$f":"D26*F26*G26","v":5512}]
[null,null,null,null,null,null,null,{"$f":"D27*F27*G27","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table2422[Total Cost])","v":5512}]
[]
[null,"Travel",null,null,null,null,null,null,null,"A team of three is going to a conference in Denver. Their per diem will cover three meals per day for three days (x three people = 9). All three will have separate hotel rooms costiing $275 ($275 x 3 people = $825/day) for three nights. The applicant is also requesting the cost of plane tickets at $235 per person for three people."]
[null,"Purpose of Travel","Location","Expense Type","Basis","Cost","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table517[[#This Row],[Cost]]*Table517[[#This Row],[Quantity]]","v":0}]
[null,"Conference","Denver, CO","Per diem","Per meal",35,9,{"$f":"Table517[[#This Row],[Cost]]*Table517[[#This Row],[Quantity]]","v":315}]
[null,"Conference","Denver, CO","Lodging","Per day",825,3,{"$f":"Table517[[#This Row],[Cost]]*Table517[[#This Row],[Quantity]]","v":2475}]
[null,"Conference","Denver, CO","Flight","Per flight",235,3,{"$f":"Table517[[#This Row],[Cost]]*Table517[[#This Row],[Quantity]]","v":705}]
[null,null,null,null,null,null,null,{"$f":"Table517[[#This Row],[Cost]]*Table517[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table517[Total Cost])","v":3495}]
[]
[null,"Professional Development",null,null,null,null,null,null,null,"This section covers the registration fees for the conference in Denver for three people. "]
[null,"Course Name","Purpose","Location","Delivery Method","Cost","# of Staff","Total Cost"]
[null,null,null,"(Do not enter information into this row)",null,null,null,{"$f":"Table618[[#This Row],[Cost]]*Table618[[#This Row],['# of Staff]]","v":0}]
[null,"Annual Conference of Researchers","Networking and Collaboration","Denver, CO","In Person",300,3,{"$f":"Table618[[#This Row],[Cost]]*Table618[[#This Row],['# of Staff]]","v":900}]
[null,null,null,null,null,null,null,{"$f":"Table618[[#This Row],[Cost]]*Table618[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table618[],Table618[Total Cost])","v":2103}]
[]
[null,"Equipment",null,null,null,null,null,null,null,"This applicant is requesting a laptop and subscription services for the part-time staff assigned to the project. The subscriptions are single items, so they are listed as individual units costing a certain amount each"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table719[[#This Row],[Cost]]*Table719[[#This Row],[Quantity]]","v":0}]
[null,"Microsoft PowerBI Pro","Non-Expendable",75,"Individual","Each",1,{"$f":"Table719[[#This Row],[Cost]]*Table719[[#This Row],[Quantity]]","v":75}]
[null,"Tableau Subscription","Non-Expendable",100,"Individual","Each",1,{"$f":"Table719[[#This Row],[Cost]]*Table719[[#This Row],[Quantity]]","v":100}]
[null,"Laptop","Non-Expendable",456,"Individual","Each",1,{"$f":"Table719[[#This Row],[Cost]]*Table719[[#This Row],[Quantity]]","v":456}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table719[Total Cost])","v":631}]
[]
[null,"Supplies",null,null,null,null,null,null,null,"The applicant is requesting general office supplies for the part-time staff assigned to the project. Info packs will be the culmination of reasearch provided to stakeholders. Once printed, they will cost $45 per box and the applicant is requesting 25 boxes. The applicant would detail the total number of info packs and office supplies in the narrative."]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table7221[[#This Row],[Cost]]*Table7221[[#This Row],[Quantity]]","v":0}]
[null,"Office Supplies","Expendable",300,"Other","Other",1,{"$f":"Table7221[[#This Row],[Cost]]*Table7221[[#This Row],[Quantity]]","v":300}]
[null,"Info Packs","Expendable",45,"Box","Per Box",25,{"$f":"Table7221[[#This Row],[Cost]]*Table7221[[#This Row],[Quantity]]","v":1125}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table7221[Total Cost])","v":1425}]
[]
[null,"Other",null,null,null,null,null,null,null,"This applicant has no additional line items, so this section remains blank"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table7920[[#This Row],[Cost]]*Table7920[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7920[[#This Row],[Cost]]*Table7920[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7920[[#This Row],[Cost]]*Table7920[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table7920[Total Cost])","v":0}]
[]
[null,"The yearly total calculates here:"]
[]
[]
[null,"Year 1 Budget Total",{"$f":"Table216[[#Totals],[Total Cost]]+Table517[[#Totals],[Total Cost]]+Table618[[#Totals],[Total Cost]]+Table719[[#Totals],[Total Cost]]+Table7920[[#Totals],[Total Cost]]","v":87599}]
[]
[]
[null,"Definitions"]
[null,"Personnel","This section should contain all employees who will work on the project if any portion of their compensation will be paid out by grant funds. Include the employees title and name, if available, along with their rate and anticipated time and percentage of work within the respective budget year. All rates should be comparable to those of similar positions across your  institution. In the accompanying budget narrative, include the anticipated responsibilities of the listed employees for the respective grant year. "]
[null,"Fringe Benefits","This section should contain any additional benefits paid out to employees listed in the personnel section. Fringe benefits should align with any prenegotiated state or federal rates."]
[null,"Travel","In this section, itemize all travel expenses related to the project. Any proposed travel must align with proposed project objectives, and applicants must describe this alignment in the accompanying budget narrative. Travel expenses should include any expense expected to be paid for through grant funds such as meals, flights, and lodging. Costs may not exceed those allowable by the US General Services Administration (GSA). For more information, visist their website: "]
[null,null,"https://www.gsa.gov/travel/plan-book/per-diem-rates"]
[null,"Professional Development","This section should contain any professional development registration fees or other associated costs for which the applicant intends to use grant funds. Travel associated with professional development opportunities should be addressed in the travel section."]
[null,"Equipment","Equipment generally includes any non-expendible items an applicant intends to purchase with grant funds. This may include computer hardward and softwware or other items that will not be consumed or discarded withing approximatey two years."]
[null,"Supplies","Supplies generally include expendable items that will be consumed over the duration of the project or within approximately two years. This may inlcude any office supplies. "]
[null,"Other","This section is for any line item applicants feel do not fit under any of the previous categories."]
[null,"Expendable","Expendible items are items that are consumed throughout the project period or have a life span of fewer than two years (i.e., these items are eventually discarded). Such items may include office supplies. "]
[null,"Non-Expendable","Non-expendible items are those intended for long-term use and are general not consumed or discarded by the project end. Items that have an anticipated lifespan of approximately two or more years are generally considered non-expendable. Such items may include computer hardware and software."]

{"sheet":"Year 1","index":1,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,1,43,7],[1,10,1,13],[2,10,15,14],[36,1,36,7],[8,1,8,7],[22,1,22,7],[1,1,1,7],[15,1,15,7],[29,1,29,7]]}
[]
[null,"Personnel",null,null,null,null,null,null,null,null,"Instruction Reminders:"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Percentage","Total Cost",null,null,"To add a row to a section, you must click on an existing row in that section and select \"Add Row.\" If you know how many rows you need in a section, add the rows prior to starting as you may have to remove information if you add rows after entering data. "]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D5*F5*G5","v":0}]
[null,null,null,null,null,null,null,{"$f":"D6*F6*G6","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table2[Total Cost])","v":0}]
[]
[null,"Fringe Benefits"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Fringe Percentage","Total Cost"]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D12*F12*G12","v":0}]
[null,null,null,null,null,null,null,{"$f":"D13*F13*G13","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table24[Total Cost])","v":0}]
[]
[null,"Travel"]
[null,"Purpose of Travel","Location","Expense Type","Basis","Cost","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table5[[#This Row],[Cost]]*Table5[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table5[[#This Row],[Cost]]*Table5[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table5[[#This Row],[Cost]]*Table5[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table5[Total Cost])","v":0}]
[]
[null,"Professional Development"]
[null,"Course Name","Purpose","Location","Delivery Method","Cost","# of Staff","Total Cost"]
[null,null,null,"(Do not enter information into this row)",null,null,null,{"$f":"Table6[[#This Row],[Cost]]*Table6[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table6[[#This Row],[Cost]]*Table6[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table6[[#This Row],[Cost]]*Table6[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table6[],Table6[Total Cost])","v":0}]
[]
[null,"Equipment"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table7[[#This Row],[Cost]]*Table7[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7[[#This Row],[Cost]]*Table7[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7[[#This Row],[Cost]]*Table7[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table7[Total Cost])","v":0}]
[]
[null,"Supplies"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table72[[#This Row],[Cost]]*Table72[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table72[[#This Row],[Cost]]*Table72[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table72[[#This Row],[Cost]]*Table72[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table72[Total Cost])","v":0}]
[]
[null,"Other"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table79[[#This Row],[Cost]]*Table79[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table79[[#This Row],[Cost]]*Table79[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table79[[#This Row],[Cost]]*Table79[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table79[Total Cost])","v":0}]
[]
[]
[]
[]
[null,"Year 1 Budget Total",{"$f":"Table2[[#Totals],[Total Cost]]+Table5[[#Totals],[Total Cost]]+Table6[[#Totals],[Total Cost]]+Table7[[#Totals],[Total Cost]]+Table79[[#Totals],[Total Cost]]","v":0}]

{"sheet":"Year 2","index":2,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[29,1,29,7],[36,1,36,7],[43,1,43,7],[1,1,1,7],[1,10,1,13],[2,10,15,14],[8,1,8,7],[15,1,15,7],[22,1,22,7]]}
[]
[null,"Personnel",null,null,null,null,null,null,null,null,"Instruction Reminders:"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Percentage","Total Cost",null,null,"To add a row to a section, you must click on an existing row in that section and select \"Add Row.\" If you know how many rows you need in a section, add the rows prior to starting as you may have to remove information if you add rows after entering data. "]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D5*F5*G5","v":0}]
[null,null,null,null,null,null,null,{"$f":"D6*F6*G6","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table243[Total Cost])","v":0}]
[]
[null,"Fringe Benefits"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Fringe Percentage","Total Cost"]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D12*F12*G12","v":0}]
[null,null,null,null,null,null,null,{"$f":"D13*F13*G13","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table2449[Total Cost])","v":0}]
[]
[null,"Travel"]
[null,"Purpose of Travel","Location","Expense Type","Basis","Cost","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table544[[#This Row],[Cost]]*Table544[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table544[[#This Row],[Cost]]*Table544[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table544[[#This Row],[Cost]]*Table544[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table544[Total Cost])","v":0}]
[]
[null,"Professional Development"]
[null,"Course Name","Purpose","Location","Delivery Method","Cost","# of Staff","Total Cost"]
[null,null,null,"(Do not enter information into this row)",null,null,null,{"$f":"Table645[[#This Row],[Cost]]*Table645[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table645[[#This Row],[Cost]]*Table645[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table645[[#This Row],[Cost]]*Table645[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table645[],Table645[Total Cost])","v":0}]
[]
[null,"Equipment"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table746[[#This Row],[Cost]]*Table746[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table746[[#This Row],[Cost]]*Table746[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table746[[#This Row],[Cost]]*Table746[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table746[Total Cost])","v":0}]
[]
[null,"Supplies"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table7248[[#This Row],[Cost]]*Table7248[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7248[[#This Row],[Cost]]*Table7248[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7248[[#This Row],[Cost]]*Table7248[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table7248[Total Cost])","v":0}]
[]
[null,"Other"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table7947[[#This Row],[Cost]]*Table7947[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7947[[#This Row],[Cost]]*Table7947[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7947[[#This Row],[Cost]]*Table7947[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table7947[Total Cost])","v":0}]
[]
[]
[]
[]
[null,"Year 2 Budget Total",{"$f":"Table243[[#Totals],[Total Cost]]+Table544[[#Totals],[Total Cost]]+Table645[[#Totals],[Total Cost]]+Table746[[#Totals],[Total Cost]]+Table7947[[#Totals],[Total Cost]]","v":0}]

{"sheet":"Year 3","index":3,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[29,1,29,7],[36,1,36,7],[43,1,43,7],[1,1,1,7],[1,10,1,13],[2,10,15,14],[8,1,8,7],[15,1,15,7],[22,1,22,7]]}
[]
[null,"Personnel",null,null,null,null,null,null,null,null,"Instruction Reminders:"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Percentage","Total Cost",null,null,"To add a row to a section, you must click on an existing row in that section and select \"Add Row.\" If you know how many rows you need in a section, add the rows prior to starting as you may have to remove information if you add rows after entering data. "]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D5*F5*G5","v":0}]
[null,null,null,null,null,null,null,{"$f":"D6*F6*G6","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table24350[Total Cost])","v":0}]
[]
[null,"Fringe Benefits"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Fringe Percentage","Total Cost"]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D12*F12*G12","v":0}]
[null,null,null,null,null,null,null,{"$f":"D13*F13*G13","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table244956[Total Cost])","v":0}]
[]
[null,"Travel"]
[null,"Purpose of Travel","Location","Expense Type","Basis","Cost","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table54451[[#This Row],[Cost]]*Table54451[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table54451[[#This Row],[Cost]]*Table54451[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table54451[[#This Row],[Cost]]*Table54451[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table54451[Total Cost])","v":0}]
[]
[null,"Professional Development"]
[null,"Course Name","Purpose","Location","Delivery Method","Cost","# of Staff","Total Cost"]
[null,null,null,"(Do not enter information into this row)",null,null,null,{"$f":"Table64552[[#This Row],[Cost]]*Table64552[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table64552[[#This Row],[Cost]]*Table64552[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table64552[[#This Row],[Cost]]*Table64552[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table64552[],Table64552[Total Cost])","v":0}]
[]
[null,"Equipment"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table74653[[#This Row],[Cost]]*Table74653[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table74653[[#This Row],[Cost]]*Table74653[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table74653[[#This Row],[Cost]]*Table74653[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table74653[Total Cost])","v":0}]
[]
[null,"Supplies"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table724855[[#This Row],[Cost]]*Table724855[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table724855[[#This Row],[Cost]]*Table724855[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table724855[[#This Row],[Cost]]*Table724855[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table724855[Total Cost])","v":0}]
[]
[null,"Other"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table794754[[#This Row],[Cost]]*Table794754[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table794754[[#This Row],[Cost]]*Table794754[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table794754[[#This Row],[Cost]]*Table794754[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table794754[Total Cost])","v":0}]
[]
[]
[]
[]
[null,"Year 3 Budget Total",{"$f":"Table24350[[#Totals],[Total Cost]]+Table54451[[#Totals],[Total Cost]]+Table64552[[#Totals],[Total Cost]]+Table74653[[#Totals],[Total Cost]]+Table794754[[#Totals],[Total Cost]]","v":0}]

{"sheet":"Year 4","index":4,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[29,1,29,7],[36,1,36,7],[43,1,43,7],[1,1,1,7],[1,10,1,13],[2,10,15,14],[8,1,8,7],[15,1,15,7],[22,1,22,7]]}
[]
[null,"Personnel",null,null,null,null,null,null,null,null,"Instruction Reminders:"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Percentage","Total Cost",null,null,"To add a row to a section, you must click on an existing row in that section and select \"Add Row.\" If you know how many rows you need in a section, add the rows prior to starting as you may have to remove information if you add rows after entering data. "]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D5*F5*G5","v":0}]
[null,null,null,null,null,null,null,{"$f":"D6*F6*G6","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table2435057[Total Cost])","v":0}]
[]
[null,"Fringe Benefits"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Fringe Percentage","Total Cost"]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D12*F12*G12","v":0}]
[null,null,null,null,null,null,null,{"$f":"D13*F13*G13","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table24495663[Total Cost])","v":0}]
[]
[null,"Travel"]
[null,"Purpose of Travel","Location","Expense Type","Basis","Cost","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table5445158[[#This Row],[Cost]]*Table5445158[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table5445158[[#This Row],[Cost]]*Table5445158[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table5445158[[#This Row],[Cost]]*Table5445158[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table5445158[Total Cost])","v":0}]
[]
[null,"Professional Development"]
[null,"Course Name","Purpose","Location","Delivery Method","Cost","# of Staff","Total Cost"]
[null,null,null,"(Do not enter information into this row)",null,null,null,{"$f":"Table6455259[[#This Row],[Cost]]*Table6455259[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table6455259[[#This Row],[Cost]]*Table6455259[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table6455259[[#This Row],[Cost]]*Table6455259[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table6455259[],Table6455259[Total Cost])","v":0}]
[]
[null,"Equipment"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table7465360[[#This Row],[Cost]]*Table7465360[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7465360[[#This Row],[Cost]]*Table7465360[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7465360[[#This Row],[Cost]]*Table7465360[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table7465360[Total Cost])","v":0}]
[]
[null,"Supplies"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table72485562[[#This Row],[Cost]]*Table72485562[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table72485562[[#This Row],[Cost]]*Table72485562[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table72485562[[#This Row],[Cost]]*Table72485562[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table72485562[Total Cost])","v":0}]
[]
[null,"Other"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table79475461[[#This Row],[Cost]]*Table79475461[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table79475461[[#This Row],[Cost]]*Table79475461[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table79475461[[#This Row],[Cost]]*Table79475461[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table79475461[Total Cost])","v":0}]
[]
[]
[]
[]
[null,"Year 4 Budget Total",{"$f":"Table2435057[[#Totals],[Total Cost]]+Table5445158[[#Totals],[Total Cost]]+Table6455259[[#Totals],[Total Cost]]+Table7465360[[#Totals],[Total Cost]]+Table79475461[[#Totals],[Total Cost]]","v":0}]

{"sheet":"Year 5","index":5,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[29,1,29,7],[36,1,36,7],[43,1,43,7],[1,1,1,7],[1,10,1,13],[2,10,15,14],[8,1,8,7],[15,1,15,7],[22,1,22,7]]}
[]
[null,"Personnel",null,null,null,null,null,null,null,null,"Instruction Reminders:"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Percentage","Total Cost",null,null,"To add a row to a section, you must click on an existing row in that section and select \"Add Row.\" If you know how many rows you need in a section, add the rows prior to starting as you may have to remove information if you add rows after entering data. "]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D5*F5*G5","v":0}]
[null,null,null,null,null,null,null,{"$f":"D6*F6*G6","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table243505764[Total Cost])","v":0}]
[]
[null,"Fringe Benefits"]
[null,"Name","Position Title","Salary","Basis","Time Worked","Fringe Percentage","Total Cost"]
[null,null,null,"(Do not enter information into this row)"]
[null,null,null,null,null,null,null,{"$f":"D12*F12*G12","v":0}]
[null,null,null,null,null,null,null,{"$f":"D13*F13*G13","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table2449566370[Total Cost])","v":0}]
[]
[null,"Travel"]
[null,"Purpose of Travel","Location","Expense Type","Basis","Cost","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table544515865[[#This Row],[Cost]]*Table544515865[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table544515865[[#This Row],[Cost]]*Table544515865[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table544515865[[#This Row],[Cost]]*Table544515865[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table544515865[Total Cost])","v":0}]
[]
[null,"Professional Development"]
[null,"Course Name","Purpose","Location","Delivery Method","Cost","# of Staff","Total Cost"]
[null,null,null,"(Do not enter information into this row)",null,null,null,{"$f":"Table645525966[[#This Row],[Cost]]*Table645525966[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table645525966[[#This Row],[Cost]]*Table645525966[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table645525966[[#This Row],[Cost]]*Table645525966[[#This Row],['# of Staff]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table645525966[],Table645525966[Total Cost])","v":0}]
[]
[null,"Equipment"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table746536067[[#This Row],[Cost]]*Table746536067[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table746536067[[#This Row],[Cost]]*Table746536067[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table746536067[[#This Row],[Cost]]*Table746536067[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table746536067[Total Cost])","v":0}]
[]
[null,"Supplies"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table7248556269[[#This Row],[Cost]]*Table7248556269[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7248556269[[#This Row],[Cost]]*Table7248556269[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7248556269[[#This Row],[Cost]]*Table7248556269[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table7248556269[Total Cost])","v":0}]
[]
[null,"Other"]
[null,"Item","Type","Cost","Unit","Basis","Quantity","Total Cost"]
[null,null,null,null,null,null,null,{"$f":"Table7947546168[[#This Row],[Cost]]*Table7947546168[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7947546168[[#This Row],[Cost]]*Table7947546168[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"Table7947546168[[#This Row],[Cost]]*Table7947546168[[#This Row],[Quantity]]","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(Table7947546168[Total Cost])","v":0}]
[]
[]
[]
[]
[null,"Year 4 Budget Total",{"$f":"Table243505764[[#Totals],[Total Cost]]+Table544515865[[#Totals],[Total Cost]]+Table645525966[[#Totals],[Total Cost]]+Table746536067[[#Totals],[Total Cost]]+Table7947546168[[#Totals],[Total Cost]]","v":0}]

{"sheet":"Budget Detail Summary","index":6,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Personnel","Fringe Benefits","Travel","Professional Development","Equipment","Supplies","Other","Total"]
[null,"Year 1",{"$f":"Table2[[#Totals],[Total Cost]]","v":0},{"$f":"Table24[[#Totals],[Total Cost]]","v":0},{"$f":"Table5[[#Totals],[Total Cost]]","v":0},{"$f":"Table6[[#Totals],[Total Cost]]","v":0},{"$f":"Table7[[#Totals],[Total Cost]]","v":0},{"$f":"Table72[[#Totals],[Total Cost]]","v":0},{"$f":"Table79[[#Totals],[Total Cost]]","v":0},{"$f":"SUM(C4:I4)","v":0}]
[null,"Year 2",{"$f":"Table243[[#Totals],[Total Cost]]","v":0},{"$f":"Table2449[[#Totals],[Total Cost]]","v":0},{"$f":"Table544[[#Totals],[Total Cost]]","v":0},{"$f":"Table645[[#Totals],[Total Cost]]","v":0},{"$f":"Table746[[#Totals],[Total Cost]]","v":0},{"$f":"Table7248[[#Totals],[Total Cost]]","v":0},{"$f":"Table7947[[#Totals],[Total Cost]]","v":0},{"$f":"SUM(C5:I5)","v":0}]
[null,"Year 3",{"$f":"Table24350[[#Totals],[Total Cost]]","v":0},{"$f":"Table244956[[#Totals],[Total Cost]]","v":0},{"$f":"Table54451[[#Totals],[Total Cost]]","v":0},{"$f":"Table64552[[#Totals],[Total Cost]]","v":0},{"$f":"Table74653[[#Totals],[Total Cost]]","v":0},{"$f":"Table724855[[#Totals],[Total Cost]]","v":0},{"$f":"Table794754[[#Totals],[Total Cost]]","v":0},{"$f":"SUM(C6:I6)","v":0}]
[null,"Year 4",{"$f":"Table2435057[[#Totals],[Total Cost]]","v":0},{"$f":"Table24495663[[#Totals],[Total Cost]]","v":0},{"$f":"Table5445158[[#Totals],[Total Cost]]","v":0},{"$f":"Table6455259[[#Totals],[Total Cost]]","v":0},{"$f":"Table7465360[[#Totals],[Total Cost]]","v":0},{"$f":"Table72485562[[#Totals],[Total Cost]]","v":0},{"$f":"Table79475461[[#Totals],[Total Cost]]","v":0},{"$f":"SUM(C7:I7)","v":0}]
[null,"Year 5",{"$f":"Table243505764[[#Totals],[Total Cost]]","v":0},{"$f":"Table2449566370[[#Totals],[Total Cost]]","v":0},{"$f":"Table544515865[[#Totals],[Total Cost]]","v":0},{"$f":"Table645525966[[#Totals],[Total Cost]]","v":0},{"$f":"Table746536067[[#Totals],[Total Cost]]","v":0},{"$f":"Table7248556269[[#Totals],[Total Cost]]","v":0},{"$f":"Table7947546168[[#Totals],[Total Cost]]","v":0},{"$f":"SUM(C8:I8)","v":0}]
[null,"Totals",{"$f":"SUM(C4:C8)","v":0},{"$f":"SUM(D4:D8)","v":0},{"$f":"SUM(E4:E8)","v":0},0,0,0,0,0]