{"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":2,"defined_names":131,"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":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[40,1,40,2]]}
[]
["Attachment A - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SFY2025 Commonwealth Critical Incident Stress Management Program"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Personnel Costs",null,{"$f":"'Budget Detail'!E16","v":0}]
[]
["Consultants/Contractors Costs",null,{"$f":"'Budget Detail'!E26","v":0}]
[]
["Training Costs",null,{"$f":"'Budget Detail'!E36","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E46","v":0}]
[]
["Travel Costs",null,{"$f":"'Budget Detail'!E56","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E66","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!E76","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!E78","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":78,"n_cols":5,"rows_kept":78,"cut":false,"hidden":false,"merged":[[78,0,78,4],[65,0,65,3],[55,0,55,3],[75,0,75,3],[77,0,77,3],[68,0,68,4],[69,0,69,4],[59,0,59,4],[38,0,38,4],[39,0,39,4],[45,0,45,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[25,0,25,3],[18,0,18,4],[19,0,19,4],[8,0,8,4],[9,0,9,4],[48,0,48,4],[28,0,28,4],[29,0,29,4],[35,0,35,3],[6,0,6,4],[58,0,58,4],[15,0,15,3],[49,0,49,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["SFY2025 Commonwealth Critical Incident Stress Management Program"]
[{"$f":"CONCATENATE(\"Attachment A - \", 'Budget Summary'!B41)","v":"Attachment A - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you read the instructions on the Opening Document tab upon opening this document to make sure that macros are enabled macros. The items marked as Example are only examples, and do not necessarily reflect items in your requested budget. Please note that the subtotals will auto-populate based on the numbers reported within each category. Your requested budget per cost category shall be entered in the rows below the Examples using the \"Add\" command button to add another row if needed. If you have any questions, please contact the CISM grant manager assigned in the Availability of Grant Funds (AGF) document."]
["Please read the Availability of Grant Funds (AGF) document. This will outline key dates, funding criteria, allowable and unallowable costs. Also, please note that all costs reported below should be based on a (4) Month Timeline. "]
[]
["PERSONNEL - Full or part-time regular salaried employees working on the grant and general administrative for updating current resources, handouts, documents at interventions, upkeep of record keeping for active team member lists. Personnel costs are considered administration costs and shall not exceed 5% of your state award."]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Sue Smith",23.487500000000001,300,"Please describe duties of Employee here. ",{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONSULTANTS/CONTRACTORS - Consultants are individuals hired to provide a service and possess expertise in crisis management (therapists, stipend for spiritual guidance and support services). The maximum rate for consultants is $650 for an eight-hour day or $81.25 per hour (excluding travel and subsistence costs). Contracts are for subawards to partnering agencies/organizations to provide counseling services. "]
[]
["Contractors/Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Please provide the names of each Contractor and Consultant as well as duties/obligations that will be performed here.",{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":9450}]
[null,null,null,null,{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,4)*ROUND(C25,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING - Team member training for CISM and Peer Support- Basic 3-day GRIN Training, 2 Day Suicide Prevention, Intervention and Postvention, Advanced Group Intervention Training,  Trainings by the ICISF, etc."]
[]
["Activity","Cost","Quantity","Description","Cash Expenditures"]
["Example: 3 Day GRIN Training",250,3,"Please describe the trainings that will be taking place here.",{"$f":"IF(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,4),2))","v":750}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":150}]
[null,null,null,null,{"$f":"IF(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT - Tangible, non-expendable personal property having a useful life of more than one year; cost based on classification of equipment (e.g., communication, IT, etc.). Team Cell phone for in the moment assistance"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"Please describe purpose of Equipment here. ",{"$f":"IF(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":150}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,4)*ROUND(C45,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL - 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(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":250}]
["Example: Tracey Thomas",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":310}]
[null,null,null,null,{"$f":"IF(B54=\"\",\"\",ROUND(ROUND(B54,4)*ROUND(C54,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B55=\"\",\"\",ROUND(ROUND(B55,4)*ROUND(C55,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES - General supplies directly related to the CISM program such as business cards for post intervention contact purposes, paper needed for training materials and other expendable items."]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"Please describe purpose of Supplies here. ",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":75}]
[null,null,null,null,{"$f":"IF(B64=\"\",\"\",ROUND(ROUND(B64,4)*ROUND(C64,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B65=\"\",\"\",ROUND(ROUND(B65,4)*ROUND(C65,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER - Meeting room space/room rental costs, membership fees etc."]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Space Rental",50,6,"Please describe purpose of item/activity here. ",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":300}]
["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(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":1500}]
[null,null,null,null,{"$f":"IF(B74=\"\",\"\",ROUND(ROUND(B74,4)*ROUND(C74,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,4)*ROUND(C75,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E16+E26+E36+E46+E56+E66+E76),2)","v":0}]