{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Opening Document","Budget Summary","Budget Detail"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":23,"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":"Opening Document","index":0,"n_rows":55,"n_cols":2,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,"UPON OPENING DOCUMENT…"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IF THE RED BANNER OCCURS…."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. DOWNLOAD DOCUMENT AND SAVE TO DESKTOP"]
[null,"2. RIGHT CLICK, PROPERTIES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. CHECK OFF UNBLOCK, CLICK APPLY, CLICK OK"]
[null,"4. REOPEN EXCEL WORKBOOK"]
[null,"5. IF NEEDED, ENABLE EDITING, ENABLE CONTENT"]

{"sheet":"Budget Summary","index":1,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[42,1,42,2]]}
[]
["Attachment B - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY 2025 Underserved Communities Traffic Safety Grant Program"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Personnel Costs",null,{"$f":"'Budget Detail'!E14","v":0}]
[]
["Fringe Benefit Costs",null,{"$f":"'Budget Detail'!E24","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!E34","v":0}]
[]
["Consultants / Contractors Costs",null,{"$f":"'Budget Detail'!E44","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E54","v":0}]
[]
["Travel Costs",null,{"$f":"'Budget Detail'!E64","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E74","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!E84","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!E86","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":86,"n_cols":5,"rows_kept":86,"cut":false,"hidden":false,"merged":[[76,0,76,4],[77,0,77,4],[57,0,57,4],[46,0,46,4],[47,0,47,4],[66,0,66,4],[67,0,67,4],[53,0,53,3],[37,0,37,4],[6,0,6,4],[7,0,7,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[56,0,56,4],[13,0,13,3],[5,0,5,4],[86,0,86,4],[73,0,73,3],[63,0,63,3],[83,0,83,3],[85,0,85,3],[23,0,23,3],[16,0,16,4],[17,0,17,4],[43,0,43,3],[33,0,33,3],[26,0,26,4],[27,0,27,4],[36,0,36,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2025 Underserved Communities Traffic Safety Grant Program"]
[{"$f":"CONCATENATE(\"Attachment B - \", 'Budget Summary'!B43)","v":"Attachment B - "}]
[]
[]
["PERSONNEL - Full or part-time regular salaried employees working on the grant. At a minimum, reporting will need to detail employee name, amount of time projected to be spent working on the grant, and the pay rate. Provide a brief description to show how the calculation was reached. Overtime is not an allowable cost under this grant program."]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Sue Smith",23.487500000000001,300,"Employee is projected to work a total of 300 hours during the grant at $23.4875/hr.",{"$f":"IF(B10=\"\",\"\",ROUND(ROUND(B10,4)*ROUND(C10,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"Please describe duties of Employee here. ",{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["FRINGE AND PAYROLL TAX - Eligible costs include the employer share of the following: life insurance, health insurance, social security costs, pension costs, unemployment insurance costs, workers compensation insurance, payroll taxes, FMLA. Cost amounts for direct fringe benefits can be either actual costs or rates per employee calculated by the fiscal or human resource unit in your organization (rate computations must be included). A copy of the approved rate agreement MUST be included with the application response."]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Cash Expenditures"]
["Example: Sue Smith",7046.25,0.21,"Per the fringe rate agreement, find the applicable cost categories to apply fringe to. In this example, the applicable cost category is \"Personnel.\" Take Sue Smith's total wages reported on this worksheet under the \"Personnel\" section and multiply by the federally approved fringe rate or the fringe rate that was proposed and approved by OGR in the application process. ($7,046.25 * 21%). Match expenditures should be in relation to the match in the applicable category. ",{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,6),2))","v":1479.71}]
["Example: Tracey Thomas ",10384.620000000001,0.1,"Per the fringe rate agreement, find the applicable cost categories to apply fringe to. In this example, the applicable cost category is \"Personnel.\" Take Tracey Thomas' total wages reported on this worksheet under the \"Personnel\" section and multiply by the breakout of what rates are being charged per eligible cost. (7.5% - health insurance, 2% - life insurance, .5% - workers compensation). ",{"$f":"IF(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,6),2))","v":1038.46}]
[null,null,null,null,{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS - Applicants that want to charge indirect costs through the use of an indirect cost rate may use a federally approved indirect cost rate agreement. A copy of the currently signed agreement MUST be submitted with the application. Applicants that do not currently have a negotiated (including provisional) indirect cost rate may elect to charge a de minimis rate of 10% of modified total direct costs. If the applicant’s accounting system permits, indirect costs may instead be allocated in the budget, including the category “other” if the costs being identified do not fit into one of the direct cost categories. For more information, see Title 2 CFR Part 200."]
[]
["Activity","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses are all categories, take the sum of all categories and multiply by the federally approved rate. If allowable expenses are only Personnel and Fringe like in this example, take the approved rate and multiply by the sum of Personnel and Fringe total costs associated with Sue Smith.      (18% * (7046.25 + 1479.71)). ",{"$f":"IF(B30=\"\",\"\",ROUND(ROUND(B30,4)*ROUND(C30,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses are all categories, take the sum of all categories and multiply by the federally approved rate. If allowable expenses are only Personnel and Fringe like in this example, take the approved rate and multiply by the sum of Personnel and Fringe total costs associated with Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,6),2))","v":2056.15}]
[null,null,null,null,{"$f":"IF(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTORS/CONSULTANTS - List each subcontractor and/or consultant along with their rate. The maximum rate for consultants is $650 for an eight-hour day or $81.25 per hour (excluding travel and subsistence costs).  Any request for compensation over $650 per day hour day or $81.25 per hour requires prior written approval by OGR.  This rate is the exception not the rule."]
[]
["Contractors/Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B40=\"\",\"\",ROUND(ROUND(B40,4)*ROUND(C40,4),2))","v":4800}]
["Example: JJ Contracting",45,210,"Please provide the names of each Contractor and Consultant as well as duties/obligations that will be performed here.",{"$f":"IF(B41=\"\",\"\",ROUND(ROUND(B41,4)*ROUND(C41,4),2))","v":9450}]
[null,null,null,null,{"$f":"IF(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT - List the purchases of tangible non-expendable personal property having a useful life of more than one year. Equipment must be directly related to the program implementation. Examples of equipment that will NOT be approved under this grant program include, but are not limited to: motor vehicles, radar detectors, lidar, security cameras, speed radar signs or trailers, portable or vehicle radios, and variable message boards. Separately purchased warranty/service plan expenses are not an allowable cost under this grant program."]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: AGF Allowed Item",1200,1,"Please describe purpose of Equipment here. ",{"$f":"IF(B50=\"\",\"\",ROUND(ROUND(B50,4)*ROUND(C50,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL - This must be travel directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates not in excess of $0.62 per mile, as well as the actual costs of tolls and parking. No grant funds may be spent for out of state conference fees, out of state travel or out of state lodging without prior written approval from OGR."]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",250,1,"Gas reimbursement related to grant. ",{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":250}]
["Example: Tracey Thomas",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B61=\"\",\"\",ROUND(ROUND(B61,4)*ROUND(C61,4),2))","v":310}]
[null,null,null,null,{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES - List the purchases of supplies required for program (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.)."]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"Please describe purpose of Supplies here. ",{"$f":"IF(B70=\"\",\"\",ROUND(ROUND(B70,4)*ROUND(C70,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B71=\"\",\"\",ROUND(ROUND(B71,4)*ROUND(C71,4),2))","v":75}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER - List the purchases for other expenses not applicable in the aforementioned that were incurred due to this program implementation (e.g., telephone costs, training material costs)."]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Telephone",65,6,"Please describe purpose of item/activity here. ",{"$f":"IF(B80=\"\",\"\",ROUND(ROUND(B80,4)*ROUND(C80,4),2))","v":390}]
["Example: Heat",6000,0.25,"Projected total bill for office during grant period is $6,000.00; this program is 1/4 of office space",{"$f":"IF(B81=\"\",\"\",ROUND(ROUND(B81,4)*ROUND(C81,4),2))","v":1500}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E14+E24+E34+E44+E64+E54+E74+E84),2)","v":0}]