{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Budget Template","Example Budget"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":2,"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":52,"n_cols":3,"rows_kept":52,"cut":false,"hidden":false,"merged":[[49,1,49,5],[50,1,50,5],[51,1,51,5],[30,1,30,6],[46,1,46,6],[48,0,48,6],[32,0,32,6],[44,1,44,6],[45,1,45,6],[1,0,1,6],[42,1,42,6],[29,1,29,6],[28,1,28,6],[43,1,43,6],[5,0,5,6],[27,0,27,6],[34,0,34,6],[38,0,38,6],[41,0,41,6],[25,0,25,6],[3,0,3,6],[35,1,35,6],[36,1,36,6],[39,1,39,5]]}
[]
["Instructions for Budget Template"]
[]
["The following are instructions for filling out a budget template.  Budgets must be submitted when ADPH will be entering into a contractual (grants only) agreement with another entity. The template is meant to be a guideline for most grants. Exceptions will exist and the template can be modified to accommodate. Be sure to always include the required elements - see Budget Template on separate tab of this spreadsheet."]
[]
["Required Elements of a Budget:"]
[null,"Budget must be labeled properly (see Heading section below)"]
[null,"Organization name must match E-Verify."]
[null,"Date ranges of budget must match those on the grant."]
[null,"Budget must have total amount of grant broken down by categories."]
[null,"Budget must have a justification for each category used ."]
[null,null,"Important:  Any calculations used for mileage rate, personnel"]
[null,null,"time spent on project x  personnel costs, supply details,"]
[null,null,"and other detail information are to be included in the justification section."]
[null,null,"The justification section can be expanded to width/height as needed."]
[null,"A description is required by Item 1, Item 2, or other items added to each category."]
[null,null,"The cell description can be edited after \"Item #\" to add this information."]
[null,"Template includes Item 1 and Item 2 per category.  If you need to add more line items,"]
[null,null,"be sure new lines are included in the sum formula in Column C."]
[null,"Total amount for all categories must add up to total cost of the budget."]
[null,"The budget must match all other documents provided for the grant."]
[null,"If indirect cost is utilized in the instrument, an indirect rate agreement must be"]
[null,null,"provided (or default 10% used when no agreement exists)."]
[null,"Any time an indirect rate agreement is not followed, a letter waiving the rate must be provided."]
[]
["*Insert information related to your grant into the yellow fields provided. "]
[]
["Heading:"]
[null,"Insert the name of the organization (must match E-Verify)."]
[null,"Insert the name of the grant that pertains to this particular budget."]
[null,"List the date ranges of the grant (must match the grant end dates)."]
[]
["* IF A SECTION IS NOT NEEDED FOR YOUR BUDGET, PLEASE JUST LEAVE IT BLANK."]
[]
["For all Direct Costs: "]
[null,"Enter the individual costs for each category into the yellow field per item."]
[null,"Enter the justification utilized for each category into the appropriate yellow field."]
[]
["Total of Direct Costs:"]
[null,"The spreadsheet will automatically calculate total direct costs."]
[]
["Indirect Costs:"]
[null,"Enter the rate in the yellow field based on whether indirect is calculated based on Salary or Salary and Fringe.                    You must use the decimal percentage format (ex: .10 for 10%)"]
[null,"Use ONLY one rate or the other. Both percentage lines cannot be used on the same budget."]
[null,"Must have an attached indirect cost agreement if indirect cost is more than 10%."]
[null,"If less than 10%, must have a letter stating the entity is using a lower rate of their own accord."]
[null,"If entity chooses a lower rate than agreed upon, a waiver from the entity must be submitted."]
[]
["Total Being Requested:"]
[null,"Spreadsheet will automatically total all inputted costs in existing Column C. "]
[null,"However, if the requested amount is different, enter the amount requested into the yellow field."]
[null,"If the total costs and amount requested are different, provide a justification."]

{"sheet":"Budget Template","index":1,"n_rows":60,"n_cols":3,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,1,59,2],[10,1,10,2],[16,1,16,2],[22,1,22,2],[28,1,28,2],[57,0,57,1],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[34,1,34,2],[40,1,40,2],[46,1,46,2],[56,0,56,1],[54,1,54,2]]}
["Contractor/Grantee Name"]
["NDPP Lifestyle Change Program"]
[]
["July 1, 2020 - June 29, 2021"]
[]
["PROJECT BUDGET"]
["Salary:"]
["Item 1:"]
["Item 2:"]
["Total Salary",null,{"$f":"SUM(C8:C9)","v":0}]
["Justification of Salary: "]
[]
["Fringe:"]
["Item 1:"]
["Item 2:"]
["Total Fringe",null,{"$f":"SUM(C14:C15)","v":0}]
["Justification of Fringe:"]
[]
["Consultant Costs:"]
["Item 1:"]
["Item 2:"]
["Total Consultant Costs",null,{"$f":"SUM(C20:C21)","v":0}]
["Justification of Consultant:"]
[]
["Travel Costs:"]
["Item 1:"]
["Item 2:"]
["Total Travel Costs",null,{"$f":"SUM(C26:C27)","v":0}]
["Justification of Travel:"]
[]
["Equipment Costs:"]
["Item 1:"]
["Item 2:"]
["Total Equipment Costs",null,{"$f":"SUM(C32:C33)","v":0}]
["Justification of Equipment:"]
[]
["Supplies:"]
["Item 1:"]
["Item 2:"]
["Total Supplies",null,{"$f":"SUM(C38:C39)","v":0}]
["Justification of Supplies:"]
[]
["Other Costs:"]
["Item 1:"]
["Item 2:"]
["Total Other Costs",null,{"$f":"SUM(C44:C45)","v":0}]
["Justification of Other Costs:"]
[]
["Total of Direct Costs",null,{"$f":"SUM(C46,C40,C34,C28,C22,C16,C10)","v":0}]
[]
["Total Indirect Costs \n(calculated on Salary only)",0,{"$f":"B51*C10","v":0}]
["**** OR ****"]
["Total Indirect Costs \n(calculated on Salary and Fringe) ",0,{"$f":"B53*(C16+C10)","v":0}]
["NOTE:  Only use one type of % Calc",null,{"$f":"SUM(C51:C53)","v":0}]
["Justification of Indirect:","Must attach a federally negotiated indirect cost rate agreement to the budget, if one exists. If one does not exist, the entity can use 10% but must submit a letter acknowleding the rate. If a rate lower than the federally negotiated rate is used, submit the agreement and a letter waiving the agreed upon rate."]
[]
["Total of Direct and Indirect Costs:",null,{"$f":"SUM(C54,C49)","v":0}]
["Total Amount of Funds Requested\n from this Program:",null,0]
[]
["Justification if Different: ","If the total direct and indirect cost is different from the requested amount, please provide a justification.","If the total costs and total amount requested are different, please provide a justification"]

{"sheet":"Example Budget","index":2,"n_rows":60,"n_cols":3,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,1,46,2],[54,1,54,2],[56,0,56,1],[57,0,57,1],[59,1,59,2],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[34,1,34,2],[40,1,40,2],[5,0,5,2],[10,1,10,2],[16,1,16,2],[22,1,22,2],[28,1,28,2]]}
["ABC Contract Services, Inc."]
["ABC Contract Services, Inc. for Blood Pressure Program"]
[]
["October 1, 2017 - September 30, 2018"]
[]
["EXAMPLE PROJECT BUDGET"]
["Salary:"]
["Item 1:",null,20000]
["Item 2:"]
["Total Salary",null,{"$f":"SUM(C8:C9)","v":20000}]
["Justification of Salary: "]
[]
["Fringe:"]
["Item 1:",null,8500]
["Item 2:"]
["Total Fringe",null,{"$f":"SUM(C14:C15)","v":8500}]
["Justification of Fringe:"]
[]
["Consultant Costs:"]
["Item 1:",null,2500]
["Item 2:"]
["Total Consultant Costs",null,{"$f":"SUM(C20:C21)","v":2500}]
["Justification of Consultant:"]
[]
["Travel Costs:"]
["Item 1:"]
["Item 2:"]
["Total Travel Costs",null,{"$f":"SUM(C26:C27)","v":0}]
["Justification of Travel:"]
[]
["Equipment Costs:"]
["Item 1:"]
["Item 2:"]
["Total Equipment Costs",null,{"$f":"SUM(C32:C33)","v":0}]
["Justification of Equipment:"]
[]
["Supplies:"]
["Item 1:"]
["Item 2:"]
["Total Supplies",null,{"$f":"SUM(C38:C39)","v":0}]
["Justification of Supplies:"]
[]
["Other Costs:"]
["Item 1:"]
["Item 2:"]
["Total Other Costs",null,{"$f":"SUM(C44:C45)","v":0}]
["Justification of Other Costs:"]
[]
["Total of Direct Costs",null,{"$f":"SUM(C46,C40,C34,C28,C22,C16,C10)","v":31000}]
[]
["Total Indirect Costs \n(calculated on Salary only)",0.1,{"$f":"B51*C10","v":2000}]
["**** OR ****"]
["Total Indirect Costs \n(calculated on Salary and Fringe) ",0,{"$f":"B53*(C16+C10)","v":0}]
["NOTE:  Only use one type of % Calc",null,{"$f":"SUM(C51:C53)","v":2000}]
["Justification of Indirect:","Must attach a federally negotiated indirect cost rate agreement to the budget, if one exists. If one does not exist, the entity can use 10% but must submit a letter acknowleding the rate. If a rate lower than the federally negotiated rate is used, submit the agreement and a letter waiving the agreed upon rate."]
[]
["Total of Direct and Indirect Costs:",null,{"$f":"SUM(C54,C49)","v":33000}]
["Total Amount of Funds Requested\n from this Program:",null,{"$f":"SUM(C56:C57)","v":33000}]
[]
["Justification if Different: ","N/A","If the total costs and total amount requested are different, please provide a justification"]