{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Questions","Allowable Cost Categories","Budget Summary","Building 1","Building 2","Building 3","Building Totals","Helper"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":52,"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":"Questions","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,0,4,1],[23,0,23,1]]}
["1. Make sure to click Enable Content and Enable Macros upon opening this Excel workbook. This is necessary in order to proceed with completing the budget. After doing so, please enter the name of the applicant:"]
[]
["Funding Parameters: School districts, educational collaboratives and charter schools may apply for up to $50,000 in funding per school building under their authority (maximum 3 buildings per applicant) AND not to exceed $150,000 in total funding being requested.  For example, an applicant requesting goods for one school building would be eligible to solicit up to $50,000 in grant funding.  An applicant requesting goods for two school building locations would be eligible for up to $100,000 in grant funding.  An applicant requesting goods for three school building locations would be eligible for up to $150,000 in grant funding. If applying for more than (1) building, the maximum funding for ANY of the buildings cannot be greater than $50,000. For example, if applying for (2) buildings, Building #1 cannot total $70,000, while Building #2 totals $30,000, even though both buildings combine to equal the \"eligible\" $100,000 threshold. "]
[]
[]
[]
["Please choose the number of total buildings and the names of the locations that this award will be funding:"]
[]
["Building #","Name of Location"]
["Building 1"]
["Building 2"]
["Building 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please note that the number of buildings that is entered above will populate a tab specific to each building. Each building will require a completed budget. If selecting more than one building, a Building Totals tab will also populate which will keep track of each budget that is entered. The Budget Summary tab will auto populate based off what is entered into each budget and will show the consolidated totals that will equal the total funding request. After review of all budgets and tabs, please click Print PDF on this page in order to generate a PDF \"hard\" copy of the entire workbook to mail in with your application. In addition, please submit this Excel document along with the electronic submission of your application."]

{"sheet":"Allowable Cost Categories","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Allowable Budget Cost Categories ","Definitions and Documentation Requirements "]
["1. Consultants/Contracts Costs","Consultant or Contractor fees associated with the equipment/technology purchased.  For example, a consultant might be hired to install the technology or train the staff on how to use it. The maximum rate for consultants is $650 for an eight hour day or $81.25 per hour.  Any request for compensation over $650 per day requires prior written approval by OGR. "]
["2. Equipment/Technology Costs","Tangible non-expendable personal property directly supporting the program and having a useful life of more than one year; cost based on classification of equipment. Shipping and handling charges for equipment purchased should be placed in this cost category."]
["3. Other Costs","Supplies directly correlated to the equipment purchased.  For example, ink or paper for a printer, batteries for communication device, etc.  "]

{"sheet":"Budget Summary","index":2,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":true,"merged":[[1,0,2,2],[18,0,18,2],[32,1,32,2]]}
[]
["Attachment B - Budget Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FY2023 Safer Schools and Communities Initiative"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Consultants/Contracts Costs",null,{"$f":"SUM('Building Totals'!B4:D4)","v":0}]
[]
["Equipment/Technology Costs",null,{"$f":"SUM('Building Totals'!B5:D5)","v":0}]
[]
["Other Costs",null,{"$f":"SUM('Building Totals'!B6:D6)","v":0}]
[]
["Total Costs",null,{"$f":"C24+C26+C28","v":0}]
[]
[]
["Name of Applicant  ",{"$f":"IF(Questions!$B$1=\"\",\"\",Questions!$B$1)","v":""}]

{"sheet":"Building 1","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[6,0,6,4],[37,0,37,4],[34,0,34,3],[36,0,36,3],[7,0,7,4],[8,0,8,4],[14,0,14,3],[27,0,27,4],[28,0,28,4],[17,0,17,4],[18,0,18,4],[24,0,24,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Safer Schools and Communities Initiative"}]
[{"$f":"CONCATENATE(\"Building 1 Budget Detail - \", Questions!$B$10)","v":"Building 1 Budget Detail - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
[]
["CONSULTANTS/CONTRACTS"]
[]
["Consultants/Contracts 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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT/TECHNOLOGY"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":150}]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER"]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Batteries",65,4,"(4) Communication device batteries",{"$f":"IF(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":260}]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,4),2))","v":1500}]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[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(E15+E25+E35),2)","v":0}]

{"sheet":"Building 2","index":4,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Safer Schools and Communities Initiative"}]
[{"$f":"CONCATENATE(\"Building 2 Budget Detail - \", Questions!$B$11)","v":"Building 2 Budget Detail - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
[]
["CONSULTANTS/CONTRACTS"]
[]
["Consultants/Contracts 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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT/TECHNOLOGY"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER"]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Batteries",65,4,"(4) Communication device batteries",{"$f":"IF(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":260}]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(E15+E25+E35),2)","v":0}]

{"sheet":"Building 3","index":5,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Safer Schools and Communities Initiative"}]
[{"$f":"CONCATENATE(\"Building 3 Budget Detail - \", Questions!$B$12)","v":"Building 3 Budget Detail - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
[]
["CONSULTANTS/CONTRACTS"]
[]
["Consultants/Contracts 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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":9450}]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT/TECHNOLOGY"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":150}]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER"]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Batteries",65,4,"(4) Communication device batteries",{"$f":"IF(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":260}]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,4),2))","v":1500}]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[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(E15+E25+E35),2)","v":0}]

{"sheet":"Building Totals","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[[1,0,1,3]]}
[]
["Building Budgets"]
["Cost \nCategories",{"$f":"CONCATENATE(\"Building 1 - \", Questions!$B$10)","v":"Building 1 - "},{"$f":"CONCATENATE(\"Building 2 - \", Questions!$B$11)","v":"Building 2 - "},{"$f":"CONCATENATE(\"Building 3 - \", Questions!$B$12)","v":"Building 3 - "}]
["Consultants/Contracts Costs",{"$f":"'Building 1'!$E$15","v":0},{"$f":"'Building 2'!$E$15","v":0},{"$f":"'Building 3'!$E$15","v":0}]
["Equipment/Technology Costs",{"$f":"'Building 1'!$E$25","v":0},{"$f":"'Building 2'!$E$25","v":0},{"$f":"'Building 3'!$E$25","v":0}]
["Other Costs",{"$f":"'Building 1'!$E$35","v":0},{"$f":"'Building 2'!$E$35","v":0},{"$f":"'Building 3'!$E$35","v":0}]
["TOTALS:",{"$f":"'Building 1'!$E$37","v":0},{"$f":"'Building 2'!$E$37","v":0},{"$f":"'Building 3'!$E$37","v":0}]
[]
[]
["Grand Total:",{"$f":"SUM(B7:D7)","v":0}]

{"sheet":"Helper","index":7,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Individual Option Text","You are applying for the Individual Option, with a maximum award amount of up to $20,000. There will be no subawards given. Please take the time to read the AGF to better understand what expenses are and are not allowable. The Allowable Cost Categories tab, highlighted in green, will provide definitions of the allowable budget cost categories. The Budget Summary and Primary Application tabs, highlighted in blue, will need to be completed by the primary applicant. The Subawards section in the Primary Application should not be completed unless, Individual Option is changed to Group Option in Question 2."]
["Group Option Text","You are applying for the Group Option, with a maximum award amount of up to $50,000. This allows for subawards to be given. Please take the time to read the AGF to better understand what expenses are and are not allowable. The Allowable Cost Categories tab, highlighted in green, will provide definitions of the allowable budget cost categories. Using the drop-down in Question 3, select the number of subawards that will be given. For each subaward, enter the names of the subawardees in the fields that populate. The Budget Summary and Primary Application tabs, highlighted in blue, will need to be completed by the primary applicant. The Subtotal listed in Subawards in these tabs should be the total amount that will be distributed to all subawardees. The primary applicant must have other activities budgeted (Ex. Personnel, Supplies, Consultants) in other to be eligible to pass through funds to subawardees. Depending on the number of subawards chosen in Question 3, each subawardee will need to have their own completed budget, highlighted in red. A subawardee will not be eligible to award funds to another subawardee. Please check that all subawardee budgets are accurate in the Subaward Totals tab, highlighted in red. The Grand Total at the bottom of the Subaward Totals tab should reflect the Subawards Section in the Primary Application tab. If not, please make any adjustment as needed. "]