{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Summary INTERNAL USE","Cost Cap Calculator","List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Summary INTERNAL USE","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":true,"merged":[[19,4,19,6],[1,0,1,6],[6,0,6,6],[7,0,7,6],[9,0,9,6],[10,4,10,6],[11,4,11,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[34,0,35,6],[20,4,20,6],[21,0,21,6],[22,4,22,6],[25,0,25,6],[26,4,26,6],[27,0,27,6],[28,4,28,6],[29,4,29,6],[30,0,30,4],[31,4,31,6],[32,0,32,2]]}
[]
["Instructions and Summary"]
[]
["Award Number:",null,null,null,null,"Date of Submission:"]
["Award Recipient:",null,null,null,null,"Form submitted by: "]
[]
["Please read the instructions on each worksheet tab before starting. If you have any questions, please ask your DOC contact.                                                                                                    Do not modify this template or any cells or formulas.  "]
["1. Fill out the blank white cells in workbook tabs a. through i. with costs only for the current phase  (e.g., initial proposal or final proposal) being submitted. Also complete tab j.\n2. Blue colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated.   \n3. Enter the project costs identified for each Category line item within each worksheet tab to auto-populate the summary tab.  \n4. All costs incurred by the eligible entity's sub-recipients and contractors, should be entered only in section e. Contractual/Subaward. All other sections are for the costs of the eligible entity only.\n5. Ensure all entered costs are allowable, allocable, and reasonable in accordance with the administrative requirements prescribed in 2 CFR 200.  Only include costs that can be directly attributed to the project.  Do not include costs that will be incurred for any other Federal financial assistance award. \n      • Allowable refers to costs that may be charged to a grant in accordance with the cost principles prescribed in 2 CFR 200.400.\n      • Allocable refers to costs that can be directly charged to the grant award based on the benefit provided.\n      • Reasonable refers to actions a prudent business person would employ.\n6. Add rows as needed throughout tabs a. through i. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to the Instructions and Summary tab or tab j.\n7. Expenses relating to the administration of the grant: An Eligible Entity may not use more than two percent of the grant amounts received under the BEAD Program for expenses relating (directly or indirectly) to administration of the grant under Section 60102(d)(2)(B) of the Infrastructure Act. Identify if any expenses relating to the administration of the grant are included  as part of the category cost and enter dollar amount. Expenses related to the administration of the grant are not in addition to the total cost category.\n8. The totals of ALL cost categories are rounded to the nearest dollar.\n"]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\nThe values in this summary table are from entries made in subsequent tabs, only blank white cells require data entry"]
["Category","Cost","Includes expenses relating to the administration of the grant?","Total ($) Expenses relating to the administration of the grant","Comments (as needed)"]
["a. Total Personnel",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}}]
["Salary",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Fringe",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["b. Travel",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}}]
["c. Equipment",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}}]
["d. Supplies",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}}]
["e. Contractual/Subawards",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}}]
["f. Construction",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}}]
["g. Other Direct Costs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}}]
["Total Direct Costs",{"$f":"SUM(B12:B20)-(B13+B14)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D12:D20)","v":{"$error":"#REF!"}}]
[]
["h. Total Indirect Charges",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}}]
["Federal Funds",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Non-Federal Funds",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Total Federal Costs",{"$f":"B21+B23","v":{"$error":"#REF!"}},null,{"$f":"D21+D23","v":{"$error":"#REF!"}}]
[]
["i. Cost Sharing/Matching $",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cost Cap Calculator'!#REF!","v":{"$error":"#REF!"}}]
["i. Cost Sharing/Matching %",{"$f":"B29/B32","v":{"$error":"#REF!"}}]
[]
["Total Project Costs",{"$f":"B27+B29","v":{"$error":"#REF!"}},"Total expenses relating to the administration of the grant ($)",{"$f":"D27+D29","v":{"$error":"#REF!"}}]
["Total expenses relating to the administration of the grant (%)",null,null,{"$f":"D32/B27","v":{"$error":"#REF!"}}]
[]
["Additional Explanation (as needed):"]

{"sheet":"Cost Cap Calculator","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,18,8],[13,0,13,8],[15,6,15,8],[14,6,14,8],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[0,0,0,13],[2,0,2,8],[5,0,5,8],[10,6,10,8],[12,6,12,8],[7,0,7,8],[8,6,8,8],[9,6,9,8],[11,6,11,8]]}
[]
[]
["State Digital Equity Capacity Grant Program\nBudget Addendum - Example 2"]
[]
[]
["NOTE:\nThe budget addendum is a supporting document for the project, required via Field 15 of the SF-424 (OMB Control No. 4040-0004, Expiration Date: 11/30/2025); however, use of this specific example addendum is not required to report this information."]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\nOnly blank white cells require data entry; Blue-shaded cells will calculate automatically."]
["Type","Cost","Includes expenses relating to Digital Equity Plan updates? (Y/N)"," Expenses ($) relating to Digital Equity Plan updates","Includes expenses relating to affordable broadband programs? (Y/N)"," Expenses ($) relating to affordable broadband programs","Narrative Description"]
["Total Direct Costs",0,null,0,null,0,"Describe the basis of this cost number including personnel, travel, equipment, supplies, subawards, construction or other direct costs and where each of these costs are reflected in the Consolidated Budget Form."]
[]
["Total Indirect Costs",0,null,0,null,0,"Describe both Federal and Non-Federal Funds allocated to indirect costs and where these costs are reflected in the Consolidated Budget Form."]
[]
[]
["TOTAL PROJECT COSTS",{"$f":"SUM(B10:B12)","v":0},"Total expenses relating to Digital Equity Plan updates ($)",{"$f":"SUM(D10:D12)","v":0},"Total expenses relating to affordable broadband programs ($)",{"$f":"SUM(F10:F12)","v":0}]
[null,null,"Percent of expenses relating to Digital Equity Plan updates ($)",{"$f":"IFERROR(D15/B15,0)","v":0},"Percent of expenses relating to affordable broadband programs ($)",{"$f":"IFERROR(F15/B15,0)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"List","index":2,"n_rows":8,"n_cols":22,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Hour",null,"Cash",null,"Domestic",null,"Yes",null,"Personnel",null,"Yes",null,"Deduction",null,"Federal",null,"Yes",null,"Yes","Cash","Federal","American Rescue Plan Act (ARPA)"]
["Month",null,"In Kind",null,"International",null,"No",null,"Travel",null,"No",null,"Addition",null,"Non-Federal",null,"No",null,"No","In Kind","State","CARES Act"]
["Annual",null,null,null,null,null,null,null,"Equipment",null,null,null,"Cost Sharing or Matching",null,null,null,null,null,"TBD","Combination of both Cash & In Kind (explanation is provided under Additional Explanation)","Local","Consolidated Appropriations Act (CAA)"]
[null,null,null,null,null,null,null,null,"Supplies",null,null,null,"Other (explanation is provided under Additional Explanation)",null,null,null,null,null,null,"TBD","Other","ReConnect Loan and Grant Program"]
[null,null,null,null,null,null,null,null,"Contractual",null,null,null,null,null,null,null,null,null,null,null,"TBD","Families First Coronavirus Response Act (FFCRA)"]
[null,null,null,null,null,null,null,null,"Construction",null,null,null,null,null,null,null,null,null,null,null,null,"TBD"]
[null,null,null,null,null,null,null,null,"Subaward"]
[null,null,null,null,null,null,null,null,"Other"]