{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Cost Cap Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Cost Cap Calculator","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,6,25,7],[0,0,0,15],[2,0,2,10],[5,0,5,10],[12,8,12,10],[9,8,9,10],[7,0,7,10],[28,0,29,10],[8,8,8,10],[18,8,18,10],[20,8,20,10],[24,0,24,8],[15,8,15,10],[19,0,19,10],[17,8,17,10],[26,8,26,10],[25,8,25,10],[23,8,23,10],[14,8,14,10],[26,6,26,7],[13,8,13,10],[25,3,25,4],[26,3,26,4]]}
[]
[]
["State Digital Equity Capacity Grant Program\nBudget Addendum - Example 1"]
[]
[]
["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."]
["Category","Cost","Includes expenses relating to Digital Equity Plan updates? (Y/N)"," Expenses ($) relating to Digital Equity Plan updates\n(DIRECT COSTS)"," Expenses ($) relating to Digital Equity Plan updates\n(INDIRECT COSTS)","Includes expenses relating to affordable broadband programs? (Y/N)"," Expenses ($) relating to affordable broadband programs\n(DIRECT COSTS)"," Expenses ($) relating to affordable broadband programs\n(INDIRECT COSTS)","Comments (as needed)"]
["a. Total Personnel",{"$f":"SUM(B11:B12)","v":0}]
["         Salary",0,null,0,0,null,0,0]
["         Fringe",0,null,0,0,null,0,0]
["b. Travel",0,null,0,0,null,0,0]
["c. Equipment",0,null,0,0,null,0,0]
["d. Supplies",0,null,0,0,null,0,0]
["e. Contractual/Subawards",0,null,0,0,null,0,0]
["f. Construction",0,null,0,0,null,0,0]
["g. Other Direct Costs",0,null,0,0,null,0,0]
["Total Direct Costs",{"$f":"SUM(B10:B18)-(B11+B12)","v":0},null,{"$f":"SUM(D11:D18)","v":0},null,null,{"$f":"SUM(G11:G18)","v":0}]
[]
["h. Total Indirect Charges",0,null,null,{"$f":"SUM(E11:E18)","v":0},null,null,{"$f":"SUM(H11:H18)","v":0}]
["         Federal Funds",0]
["         Non-Federal Funds",0]
["Total Federal Costs",{"$f":"B19+B21","v":0},null,{"$f":"D19","v":0},{"$f":"E21","v":0},null,{"$f":"G19","v":0},{"$f":"H21","v":0}]
[]
["TOTAL PROJECT COSTS",{"$f":"B24","v":0},"Total expenses relating to Digital Equity Plan updates ($)",{"$f":"SUM(D24:E24)","v":0},null,"Total expenses relating to affordable broadband programs ($)",{"$f":"SUM(G24:H24)","v":0}]
[null,null,"Percent of expenses relating to Digital Equity Plan updates ($)",{"$f":"IFERROR(D26/B26,0)","v":0},null,"Percent of expenses relating to affordable broadband programs ($)",{"$f":"IFERROR(G26/B26,0)","v":0}]
[]
["Additional Explanation (as needed):"]