{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Summary INTERNAL USE","Instructions and Summary","a. Personnel","b. Travel","c. Equipment","d. Supplies","e1. Contractual","e2. Subawards","f. Construction","g. Other","h. Indirect","i. Cost Sharing-Matching","j. Program Income","List"],"not_rendered":{"images":3,"macros":1,"defined_names":60},"read":"whole","date_system":"1900"}

{"sheet":"Summary INTERNAL USE","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"hidden":true,"merged":[[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],[19,4,19,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],[34,0,35,6]]}
[]
["Instructions and Summary"]
[]
["Award Number:",{"$nulls":4},"Date of Submission:"]
["Award Recipient:",{"$nulls":4},"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":"'a. Personnel'!H22","v":{"v":0,"d":"$0"}},{"$f":"'Instructions and Summary'!C12","v":{"v":0,"d":"$0"}},{"$f":"'Instructions and Summary'!D11","v":{"v":0,"d":"$0"}}]
["Salary",{"$f":"'a. Personnel'!E22","v":{"v":0,"d":"$0"}}]
["Fringe",{"$f":"'a. Personnel'!F22","v":{"v":0,"d":"$0"}}]
["b. Travel",{"$f":"'b. Travel'!K29","v":{"v":0,"d":"$0"}},{"$f":"'Instructions and Summary'!C14","v":"N"},{"$f":"'Instructions and Summary'!D14","v":{"v":0,"d":"$0"}}]
["c. Equipment",{"$f":"'c. Equipment'!D19","v":{"v":0,"d":"$0"}},{"$f":"'Instructions and Summary'!C15","v":"N"},{"$f":"'Instructions and Summary'!D15","v":{"v":0,"d":"$0"}}]
["d. Supplies",{"$f":"'d. Supplies'!D18","v":{"v":0,"d":"$0"}},{"$f":"'Instructions and Summary'!C16","v":"N"},{"$f":"'Instructions and Summary'!D16","v":{"v":0,"d":"$0"}}]
["e. Contractual/Subawards",{"$f":"'e2. Subawards'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions and Summary'!C18","v":"N"},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}}]
["f. Construction",{"$f":"'f. Construction'!B22","v":{"v":0,"d":"$0"}},{"$f":"'Instructions and Summary'!C19","v":"N"},{"$f":"'Instructions and Summary'!D18","v":{"v":0,"d":"$0"}}]
["g. Other Direct Costs",{"$f":"'g. Other'!B15","v":{"v":0,"d":"$0"}},{"$f":"'Instructions and Summary'!C20","v":"N"},{"$f":"'Instructions and Summary'!D20","v":{"v":0,"d":"$0"}}]
["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":"'h. Indirect'!D17","v":{"v":0,"d":"$0"}},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}}]
["Federal Funds",{"$f":"'h. Indirect'!E17","v":{"v":0,"d":"$0"}}]
["Non-Federal Funds",{"$f":"'h. Indirect'!#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":"'i. Cost Sharing-Matching'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions and Summary'!C26","v":"An Eligible Entity that includes matching funds as part of its application will receive additional consideration during the review process."},{"$f":"'Instructions and Summary'!D27","v":{"v":0,"d":"$0"}}]
["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":"Instructions and Summary","index":1,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[1,0,1,9],[3,0,3,9],[5,0,5,9],[6,0,6,9],[8,0,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[25,2,26,5],[25,8,25,9],[28,0,28,1],[28,3,28,5],[28,7,28,9],[29,0,29,1],[29,3,29,5],[29,7,29,9],[31,1,31,5],[44,0,44,9]]}
[{"$nulls":9},"OMB Control No. XXXX-XXX\nExpiration Date: XX/XX/XXXX"]
["Native Entities Grant Program (NEGP) Use and Adoption\nConsolidated Budget Form (CBF)"]
[]
["Per Section IV.A.1.d of the NOFO, any Eligible Entity applying for Native Entities Grant Program (NEGP) Funds must submit the Consolidated Budget Form as part of their application. \nApplications from Eligible Entities must be received no later 11:59 p.m. ET on September 15, 2026.\n\nIf you have any further questions, or require technical assistance, please reach out to broadbandgrants@ntia.gov."]
[]
["Please read the instructions on each worksheet tab before starting. Only fill out blank white cells. Cells shaded blue should not be altered."]
["1. First fill out the blank white cells in workbook tabs a. through j. Enter the project costs by line item within each category. Each line item should represent a project cost on a per year basis. If a cost will be paid over various years, then additional line items must be used to capture the annualized cost. The total of each cost category will automatically sum and auto-populate in Column B of this tab.\n2. This Instructions and Summary tab is completed automatically and will pull information from tabs a through j.  Anything that is shaded blue should not be altered. The only space where information can be entered is if you have additional comments to make for each cost category under the \"Summary of Budget Category Costs Proposed\". \n3. All costs incurred by the Eligible Entity's contractors or subrecipients, should be entered only in Tab e1. Contractual or Tab e2. Subaward.This includes any cost share/matching provided by the contractors or subrecipients. All other tabs are for the costs of the Eligible Entity only.\n4. Ensure all entered costs are allowable, allocable, and reasonable in accordance with the administrative requirements prescribed in 2 CFR 200. If you have questions about certain cost categories, please reference 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.403.\n      • Allocable refers to costs that can be directly charged to the grant award based on the benefit provided. See 2 CFR 200.405.\n      • Reasonable refers to actions a prudent business person would employ and are necessary to the execution of the award. See 2 CFR 200.404.\n5. Add rows as needed throughout tabs a. through g and tab i. Cost Sharing-Matching. To insert rows, right click on the row number on the left of the tab and choose \"Insert\". A new row will be added to the table. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to this tab (Instructions and Summary) or tabs h or j.\n6. Expenses relating to the administration of the grant: An Eligible Entity may not use more than ten percent of the grant amounts received under the Native Entities Grant Program (NEGP) for expenses relating (directly or indirectly) to administration of the grant (see 47 U.S.C. § 1724(d)(2)(C)). To identify if any expenses relating to the administration of the grant are included, please fill out each tab and identify the percentage of each cost (if any) that relates to the administration of the grant. These amounts will automatically flow into Columns D and E of the Instructions and Summary tab. The final cap value is calculated by dividing the total expenses allocable to the administration of the grant by the Total Project Costs. This value must not exceed 10%. If it does, that cell will turn red.  \n7. Expenses relating to the evaluation of the grant: An Eligible Entity may not use more than ten percent of the grant amounts received under NEGP for expenses relating (directly or indirectly) to evaluation of the grant (see 47 U.S.C. § 1724(d)(2)(B)(i)). To identify if any expenses relating to the evaluation of the grant are included, please fill out each tab and identify the percentage of each cost (if any) that relates to the evaluation of the grant. These amounts will automatically flow into Columns G and H of the Instructions and Summary tab. The final Evaluation Cap value is calculated by dividing the total expenses allocable to the evaluation of the grant by the Total Project Costs. This value must not exceed 10%. If it does, that cell will turn red.\n8. The Total Federal Cost should reflect NEGP funds requested.\n9. The totals of ALL cost categories should appear as rounded dollar values. \n10. If any cells turn red after the completion of the workbook, review the budget to ensure the Eligible Entity is not exceeding the 10% Administration cap and/or the 10% Evaluation cap and has shown at least 10% cost sharing/matching. \n11. The table at the bottom of this tab titled \"Estimated Costs by Category Per Year\" will autopopulate with information from every tab. This table will track expected drawdown of grant funds. Note that the 5th year is an evaluation year."]
[]
["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 subject to the 10% administrative cap (Y/N)"," Expenses ($) relating to the administration of the grant (DIRECT)"," Expenses ($) relating to the administration of the grant (INDIRECT)","Includes expenses subject to the 10% evaluation cap (Y/N)"," Expenses ($) relating to the evaluation of the grant (DIRECT)"," Expenses ($) relating to the evaluation of the grant (INDIRECT)","Comments (as needed)"]
["a. Personnel",{"$f":"SUM(B12:B13)","v":{"v":0,"d":"$0"}},{"$f":"IF(SUM(D11:E11)>0,\"Y\",\"N\")","v":"N"},{"$f":"SUM('Instructions and Summary'!D12:D13)","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A11,'h. Indirect'!$G$8:$G$15),0)","v":{"v":0,"d":"$0"}},{"$f":"IF(SUM(G11:H11)>0,\"Y\",\"N\")","v":"N"},{"$f":"SUM(G12:G13)","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A11,'h. Indirect'!$I$8:$I$15),0)","v":{"v":0,"d":"$0"}}]
["Salary",{"$f":"'a. Personnel'!E22","v":{"v":0,"d":"$0"}},null,{"$f":"SUM('a. Personnel'!L22)","v":{"v":0,"d":"$0"}},null,null,{"$f":"'a. Personnel'!O22","v":{"v":0,"d":"$0"}}]
["Fringe",{"$f":"'a. Personnel'!F22","v":{"v":0,"d":"$0"}},null,{"$f":"SUM('a. Personnel'!M22)","v":{"v":0,"d":"$0"}},null,null,{"$f":"'a. Personnel'!P22","v":{"v":0,"d":"$0"}}]
["b. Travel",{"$f":"'b. Travel'!M29","v":{"v":0,"d":"$0"}},{"$f":"IF(SUM(D14:E14)>0,\"Y\",\"N\")","v":"N"},{"$f":"SUM('b. Travel'!Q29)","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A14,'h. Indirect'!$G$8:$G$15),0)","v":{"v":0,"d":"$0"}},{"$f":"IF(SUM(G14:H14)>0,\"Y\",\"N\")","v":"N"},{"$f":"'b. Travel'!S29","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A14,'h. Indirect'!$I$8:$I$15),0)","v":{"v":0,"d":"$0"}}]
["c. Equipment",{"$f":"'c. Equipment'!D19","v":{"v":0,"d":"$0"}},{"$f":"IF(SUM(D15:E15)>0,\"Y\",\"N\")","v":"N"},{"$f":"SUM('c. Equipment'!H19)","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A15,'h. Indirect'!$G$8:$G$15),0)","v":{"v":0,"d":"$0"}},{"$f":"IF(SUM(G15:H15)>0,\"Y\",\"N\")","v":"N"},{"$f":"'c. Equipment'!J19","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A15,'h. Indirect'!$I$8:$I$15),0)","v":{"v":0,"d":"$0"}}]
["d. Supplies",{"$f":"'d. Supplies'!D18","v":{"v":0,"d":"$0"}},"N",{"$f":"SUM('d. Supplies'!H18)","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A16,'h. Indirect'!$G$8:$G$15),0)","v":{"v":0,"d":"$0"}},"N",{"$f":"'d. Supplies'!J18","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A16,'h. Indirect'!$I$8:$I$15),0)","v":{"v":0,"d":"$0"}}]
["e1. Contractual",{"$f":"'e1. Contractual'!B18","v":{"v":0,"d":"$0"}},"N",{"$f":"'e1. Contractual'!F18","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A17,'h. Indirect'!$G$8:$G$15),0)","v":{"v":0,"d":"$0"}},"N",{"$f":"'e1. Contractual'!H18","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A17,'h. Indirect'!$I$8:$I$15),0)","v":{"v":0,"d":"$0"}}]
["e2. Subawards",{"$f":"'e2. Subawards'!C24","v":{"v":0,"d":"$0"}},"N",{"$f":"'e2. Subawards'!G24","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A18,'h. Indirect'!$G$8:$G$15),0)","v":{"v":0,"d":"$0"}},"N",{"$f":"'e2. Subawards'!I24","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A18,'h. Indirect'!$I$8:$I$15),0)","v":{"v":0,"d":"$0"}}]
["f. Construction",{"$f":"'f. Construction'!B22","v":{"v":0,"d":"$0"}},"N",{"$f":"'f. Construction'!F22","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A19,'h. Indirect'!$G$8:$G$15),0)","v":{"v":0,"d":"$0"}},"N",{"$f":"'f. Construction'!H22","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A19,'h. Indirect'!$I$8:$I$15),0)","v":{"v":0,"d":"$0"}}]
["g. Other Direct Costs",{"$f":"'g. Other'!B15","v":{"v":0,"d":"$0"}},"N",{"$f":"'g. Other'!F15","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A20,'h. Indirect'!$G$8:$G$15),0)","v":{"v":0,"d":"$0"}},"N",{"$f":"'g. Other'!H15","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUMIF('h. Indirect'!$A$8:$A$15,'Instructions and Summary'!A20,'h. Indirect'!$I$8:$I$15),0)","v":{"v":0,"d":"$0"}}]
["Total Direct Costs",{"$f":"SUM(B11,B14:B20)","v":{"v":0,"d":"$0"}},"Total direct and indirect expenses related to the administration of the grant",{"$f":"SUM(D11,D14:D20)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E11,E14:E20)","v":{"v":0,"d":"$0"}},"Total direct and indirect expenses related to the evaluation of the grant.",{"$f":"SUM(G11,G14:G20)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H11,H14:H20)","v":{"v":0,"d":"$0"}}]
["Total Indirect Costs",{"$f":"'h. Indirect'!D17","v":{"v":0,"d":"$0"}}]
["Total Project Cost",{"$f":"B21+B22","v":{"v":0,"d":"$0"}}]
["Total Federal Cost (Total Project Cost minus Cost Sharing/Matching)",{"$f":"B23-B26","v":{"v":0,"d":"$0"}}]
[]
["i. Cost Sharing/Matching $",{"$f":"'i. Cost Sharing-Matching'!E35","v":{"v":0,"d":"$0"}},"An Eligible Entity that includes matching funds as part of its application will receive additional consideration during the review process."]
["i. Cost Sharing/Matching %",{"$f":"IFERROR(B26/B23,0)","v":{"v":0,"d":"0.000000%"}}]
[]
["Total expenses related to the administration of the grant ($)",null,{"$f":"SUM(D21:E21)","v":{"v":0,"d":"$0"}},"Percent of the total award that will be allocated to the administration of the grant (%)",null,null,{"$f":"IFERROR(C29/B23,0)","v":{"v":0,"d":"0.000000%"}},"The administration expenses cap for this Program is 10% of the total project cost. Cell G35 will turn red if this percentage is calculated as more than 10% and green if this percentage is calculated as equal or less than 10%."]
["Total expenses related to the evaluation of the grant ($)",null,{"$f":"SUM(G21:H21)","v":{"v":0,"d":"$0"}},"Percent of total award that will be allocated to the evaluation of the grant (%)",null,null,{"$f":"IFERROR(C30/B23,0)","v":{"v":0,"d":"0.000000%"}},"The evaluation expenses cap for this Program is 10% of the total project cost. Cell G36 will turn red if this percentage is calculated as more than 10% and green if this percentage is calculated as equal or less than 10%."]
[]
[null,"Estimated Costs by Category Per Year"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["a. Personnel",{"$f":"'a. Personnel'!B26","v":{"v":0,"d":"$0"}},{"$f":"'a. Personnel'!C26","v":{"v":0,"d":"$0"}},{"$f":"'a. Personnel'!D26","v":{"v":0,"d":"$0"}},{"$f":"'a. Personnel'!E26","v":{"v":0,"d":"$0"}},{"$f":"'a. Personnel'!F26","v":{"v":0,"d":"$0"}}]
["b. Travel",{"$f":"'b. Travel'!B33","v":{"v":0,"d":"$0"}},{"$f":"'b. Travel'!C33","v":{"v":0,"d":"$0"}},{"$f":"'b. Travel'!D33","v":{"v":0,"d":"$0"}},{"$f":"'b. Travel'!E33","v":{"v":0,"d":"$0"}},{"$f":"'b. Travel'!F33","v":{"v":0,"d":"$0"}}]
["c. Equipment",{"$f":"'c. Equipment'!B23","v":{"v":0,"d":"$0"}},{"$f":"'c. Equipment'!C23","v":{"v":0,"d":"$0"}},{"$f":"'c. Equipment'!D23","v":{"v":0,"d":"$0"}},{"$f":"'c. Equipment'!E23","v":{"v":0,"d":"$0"}},{"$f":"'c. Equipment'!F23","v":{"v":0,"d":"$0"}}]
["d. Supplies",{"$f":"'d. Supplies'!B22","v":{"v":0,"d":"$0"}},{"$f":"'d. Supplies'!C22","v":{"v":0,"d":"$0"}},{"$f":"'d. Supplies'!D22","v":{"v":0,"d":"$0"}},{"$f":"'d. Supplies'!E22","v":{"v":0,"d":"$0"}},{"$f":"'d. Supplies'!F22","v":{"v":0,"d":"$0"}}]
["e1. Contractual",{"$f":"'e1. Contractual'!B22","v":{"v":0,"d":"$0"}},{"$f":"'e1. Contractual'!C22","v":{"v":0,"d":"$0"}},{"$f":"'e1. Contractual'!D22","v":{"v":0,"d":"$0"}},{"$f":"'e1. Contractual'!E22","v":{"v":0,"d":"$0"}},{"$f":"'e1. Contractual'!F22","v":{"v":0,"d":"$0"}}]
["e2. Subawards",{"$f":"'e2. Subawards'!B28","v":{"v":0,"d":"$0"}},{"$f":"'e2. Subawards'!C28","v":{"v":0,"d":"$0"}},{"$f":"'e2. Subawards'!D28","v":{"v":0,"d":"$0"}},{"$f":"'e2. Subawards'!E28","v":{"v":0,"d":"$0"}},{"$f":"'e2. Subawards'!F28","v":{"v":0,"d":"$0"}}]
["f. Construction",{"$f":"'f. Construction'!B26","v":{"v":0,"d":"$0"}},{"$f":"'f. Construction'!C26","v":{"v":0,"d":"$0"}},{"$f":"'f. Construction'!D26","v":{"v":0,"d":"$0"}},{"$f":"'f. Construction'!E26","v":{"v":0,"d":"$0"}},{"$f":"'f. Construction'!F26","v":{"v":0,"d":"$0"}}]
["g. Other Direct Costs",{"$f":"'g. Other'!B19","v":{"v":0,"d":"$0"}},{"$f":"'g. Other'!C19","v":{"v":0,"d":"$0"}},{"$f":"'g. Other'!D19","v":{"v":0,"d":"$0"}},{"$f":"'g. Other'!E19","v":{"v":0,"d":"$0"}},{"$f":"'g. Other'!F19","v":{"v":0,"d":"$0"}}]
["h. Indirect Costs",{"$f":"(SUMIFS('a. Personnel'!$H$11:$H$20,'a. Personnel'!$I$11:$I$20,'Instructions and Summary'!B33,'a. Personnel'!$J$11:$J$20,\"Yes\")*'h. Indirect'!$C$8)+(SUMIFS('b. Travel'!$M$8:$M$27,'b. Travel'!$N$8:$N$27,'Instructions and Summary'!B33,'b. Travel'!$O$8:$O$27,\"Yes\")*'h. Indirect'!$C$9)+(SUMIFS('c. Equipment'!$D$8:$D$17,'c. Equipment'!$E$8:$E$17,'Instructions and Summary'!B33,'c. Equipment'!$F$8:$F$17,\"Yes\")*'h. Indirect'!$C$10)+(SUMIFS('d. Supplies'!$D$9:$D$16,'d. Supplies'!$E$9:$E$16,'Instructions and Summary'!B33,'d. Supplies'!$F$9:$F$16,\"Yes\")*'h. Indirect'!$C$11)+(SUMIFS('e1. Contractual'!$B$8:$B$16,'e1. Contractual'!$C$8:$C$16,'Instructions and Summary'!B33,'e1. Contractual'!$D$8:$D$16,\"Yes\")*'h. Indirect'!$C$12)+(SUMIFS('e2. Subawards'!$C$8:$C$22,'e2. Subawards'!$D$8:$D$22,'Instructions and Summary'!B33,'e2. Subawards'!$E$8:$E$22,\"Yes\")*'h. Indirect'!$C$13)+(SUMIFS('f. Construction'!$B$8:$B$20,'f. Construction'!$C$8:$C$20,'Instructions and Summary'!B33,'f. Construction'!$D$8:$D$20,\"Yes\")*'h. Indirect'!$C$14)+(SUMIFS('g. Other'!$B$8:$B$13,'g. Other'!$C$8:$C$13,'Instructions and Summary'!B33,'g. Other'!$D$8:$D$13,\"Yes\")*'h. Indirect'!$C$15)","v":{"v":0,"d":"$0"}},{"$f":"(SUMIFS('a. Personnel'!$H$11:$H$20,'a. Personnel'!$I$11:$I$20,'Instructions and Summary'!C33,'a. Personnel'!$J$11:$J$20,\"Yes\")*'h. Indirect'!$C$8)+(SUMIFS('b. Travel'!$M$8:$M$27,'b. Travel'!$N$8:$N$27,'Instructions and Summary'!C33,'b. Travel'!$O$8:$O$27,\"Yes\")*'h. Indirect'!$C$9)+(SUMIFS('c. Equipment'!$D$8:$D$17,'c. Equipment'!$E$8:$E$17,'Instructions and Summary'!C33,'c. Equipment'!$F$8:$F$17,\"Yes\")*'h. Indirect'!$C$10)+(SUMIFS('d. Supplies'!$D$9:$D$16,'d. Supplies'!$E$9:$E$16,'Instructions and Summary'!C33,'d. Supplies'!$F$9:$F$16,\"Yes\")*'h. Indirect'!$C$11)+(SUMIFS('e1. Contractual'!$B$8:$B$16,'e1. Contractual'!$C$8:$C$16,'Instructions and Summary'!C33,'e1. Contractual'!$D$8:$D$16,\"Yes\")*'h. Indirect'!$C$12)+(SUMIFS('e2. Subawards'!$C$8:$C$22,'e2. Subawards'!$D$8:$D$22,'Instructions and Summary'!C33,'e2. Subawards'!$E$8:$E$22,\"Yes\")*'h. Indirect'!$C$13)+(SUMIFS('f. Construction'!$B$8:$B$20,'f. Construction'!$C$8:$C$20,'Instructions and Summary'!C33,'f. Construction'!$D$8:$D$20,\"Yes\")*'h. Indirect'!$C$14)+(SUMIFS('g. Other'!$B$8:$B$13,'g. Other'!$C$8:$C$13,'Instructions and Summary'!C33,'g. Other'!$D$8:$D$13,\"Yes\")*'h. Indirect'!$C$15)","v":{"v":0,"d":"$0"}},{"$f":"(SUMIFS('a. Personnel'!$H$11:$H$20,'a. Personnel'!$I$11:$I$20,'Instructions and Summary'!D33,'a. Personnel'!$J$11:$J$20,\"Yes\")*'h. Indirect'!$C$8)+(SUMIFS('b. Travel'!$M$8:$M$27,'b. Travel'!$N$8:$N$27,'Instructions and Summary'!D33,'b. Travel'!$O$8:$O$27,\"Yes\")*'h. Indirect'!$C$9)+(SUMIFS('c. Equipment'!$D$8:$D$17,'c. Equipment'!$E$8:$E$17,'Instructions and Summary'!D33,'c. Equipment'!$F$8:$F$17,\"Yes\")*'h. Indirect'!$C$10)+(SUMIFS('d. Supplies'!$D$9:$D$16,'d. Supplies'!$E$9:$E$16,'Instructions and Summary'!D33,'d. Supplies'!$F$9:$F$16,\"Yes\")*'h. Indirect'!$C$11)+(SUMIFS('e1. Contractual'!$B$8:$B$16,'e1. Contractual'!$C$8:$C$16,'Instructions and Summary'!D33,'e1. Contractual'!$D$8:$D$16,\"Yes\")*'h. Indirect'!$C$12)+(SUMIFS('e2. Subawards'!$C$8:$C$22,'e2. Subawards'!$D$8:$D$22,'Instructions and Summary'!D33,'e2. Subawards'!$E$8:$E$22,\"Yes\")*'h. Indirect'!$C$13)+(SUMIFS('f. Construction'!$B$8:$B$20,'f. Construction'!$C$8:$C$20,'Instructions and Summary'!D33,'f. Construction'!$D$8:$D$20,\"Yes\")*'h. Indirect'!$C$14)+(SUMIFS('g. Other'!$B$8:$B$13,'g. Other'!$C$8:$C$13,'Instructions and Summary'!D33,'g. Other'!$D$8:$D$13,\"Yes\")*'h. Indirect'!$C$15)","v":{"v":0,"d":"$0"}},{"$f":"(SUMIFS('a. Personnel'!$H$11:$H$20,'a. Personnel'!$I$11:$I$20,'Instructions and Summary'!E33,'a. Personnel'!$J$11:$J$20,\"Yes\")*'h. Indirect'!$C$8)+(SUMIFS('b. Travel'!$M$8:$M$27,'b. Travel'!$N$8:$N$27,'Instructions and Summary'!E33,'b. Travel'!$O$8:$O$27,\"Yes\")*'h. Indirect'!$C$9)+(SUMIFS('c. Equipment'!$D$8:$D$17,'c. Equipment'!$E$8:$E$17,'Instructions and Summary'!E33,'c. Equipment'!$F$8:$F$17,\"Yes\")*'h. Indirect'!$C$10)+(SUMIFS('d. Supplies'!$D$9:$D$16,'d. Supplies'!$E$9:$E$16,'Instructions and Summary'!E33,'d. Supplies'!$F$9:$F$16,\"Yes\")*'h. Indirect'!$C$11)+(SUMIFS('e1. Contractual'!$B$8:$B$16,'e1. Contractual'!$C$8:$C$16,'Instructions and Summary'!E33,'e1. Contractual'!$D$8:$D$16,\"Yes\")*'h. Indirect'!$C$12)+(SUMIFS('e2. Subawards'!$C$8:$C$22,'e2. Subawards'!$D$8:$D$22,'Instructions and Summary'!E33,'e2. Subawards'!$E$8:$E$22,\"Yes\")*'h. Indirect'!$C$13)+(SUMIFS('f. Construction'!$B$8:$B$20,'f. Construction'!$C$8:$C$20,'Instructions and Summary'!E33,'f. Construction'!$D$8:$D$20,\"Yes\")*'h. Indirect'!$C$14)+(SUMIFS('g. Other'!$B$8:$B$13,'g. Other'!$C$8:$C$13,'Instructions and Summary'!E33,'g. Other'!$D$8:$D$13,\"Yes\")*'h. Indirect'!$C$15)","v":{"v":0,"d":"$0"}},{"$f":"(SUMIFS('a. Personnel'!$H$11:$H$20,'a. Personnel'!$I$11:$I$20,'Instructions and Summary'!F33,'a. Personnel'!$J$11:$J$20,\"Yes\")*'h. Indirect'!$C$8)+(SUMIFS('b. Travel'!$M$8:$M$27,'b. Travel'!$N$8:$N$27,'Instructions and Summary'!F33,'b. Travel'!$O$8:$O$27,\"Yes\")*'h. Indirect'!$C$9)+(SUMIFS('c. Equipment'!$D$8:$D$17,'c. Equipment'!$E$8:$E$17,'Instructions and Summary'!F33,'c. Equipment'!$F$8:$F$17,\"Yes\")*'h. Indirect'!$C$10)+(SUMIFS('d. Supplies'!$D$9:$D$16,'d. Supplies'!$E$9:$E$16,'Instructions and Summary'!F33,'d. Supplies'!$F$9:$F$16,\"Yes\")*'h. Indirect'!$C$11)+(SUMIFS('e1. Contractual'!$B$8:$B$16,'e1. Contractual'!$C$8:$C$16,'Instructions and Summary'!F33,'e1. Contractual'!$D$8:$D$16,\"Yes\")*'h. Indirect'!$C$12)+(SUMIFS('e2. Subawards'!$C$8:$C$22,'e2. Subawards'!$D$8:$D$22,'Instructions and Summary'!F33,'e2. Subawards'!$E$8:$E$22,\"Yes\")*'h. Indirect'!$C$13)+(SUMIFS('f. Construction'!$B$8:$B$20,'f. Construction'!$C$8:$C$20,'Instructions and Summary'!F33,'f. Construction'!$D$8:$D$20,\"Yes\")*'h. Indirect'!$C$14)+(SUMIFS('g. Other'!$B$8:$B$13,'g. Other'!$C$8:$C$13,'Instructions and Summary'!F33,'g. Other'!$D$8:$D$13,\"Yes\")*'h. Indirect'!$C$15)","v":{"v":0,"d":"$0"}},"Total Project Costs"]
["Total Per Year",{"$f":"SUM(B34:B41)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C34:C41)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D34:D41)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(B43:F43)","v":{"v":0,"d":"$0"}}]
[]
["Additional Explanation (as needed):"]

{"sheet":"a. Personnel","index":2,"n_rows":28,"n_cols":22,"rows_kept":28,"merged":[[2,0,3,23],[4,0,4,23],[6,17,6,23],[21,0,21,3],[23,1,23,5],[27,0,27,23]]}
[]
[]
["a. Personnel"]
[]
["INSTRUCTIONS\n1. List project costs solely for employees of the Eligible Entity. All personnel should be identified by position title and not employee name. Personnel costs for contractors and subrecipients must be included under Tab e1. Contractual or Tab e2. Subawards. \n2. Each row should represent an individual employee working during a single year. If an employee will be working for more than 1 year, additional rows must be used to account for their full employment with the grant. Do not account for multiple employees with the same title on one row.\n3. Enter the unit in Column B, level of effort in Column C, and unit cost in Column D. Level of effort is defined as the amount of time required to complete an activity. If the unit of level of effort is in annual units, then the maximum level of effort on each row should be 1. If an employee is working more than 1 year, then additional rows should be added. E.g., If an employee will spend four years working on the activity, then 4 rows should be used to represent each year of their employment. For clarity, include unique names for every position title, or if more than one person will have the same position, consider numbering them. Once these three columns are completed, the subtotal salary will automatically calculate in Column E.\n4. Enter the fringe rate in Column G. Fringe benefits are allowances and services provided to employees as compensation in addition to regular salaries and wages. The rates and how they are applied should not be averaged to get one fringe cost percentage. Complex calculations should be described/provided in the Additional Explanation section below. Once the fringe rate is entered, the fringe benefits (Column F) and the total compensation (Column H) will automatically calculate.\n5. Enter the estimated drawdown year in Column I. This is the year when you expect to spend the funds. This will autopopulate into the \"Estimated Costs Per Year\" table at the bottom of this tab.\n6. Enter whether the line item is included in your indirect cost base in Column J. Reference your specific indirect cost rate method for further guidance on what items will count towards your indirect cost base.\n7. Include the percentage of the cost that will be allocated to the administration of the grant in Column K (e.g., the percentage of time a position is spending on the administration of the grant). The total personnel cost that is allocable to the administration of the grant will automatically calculate and inform Columns C and D of the \"Instructions and Summary\" tab.\n8. Include the percentage of the cost that will be allocated to the evaluation of the grant in Column N (e.g., the percentage of equipment dedicated to the evaluation of the grant). The total personnel cost that is allocable to the evaluation of the grant will automatically calculate and inform Columns F and G of the \"Instructions and Summary\" tab.\n9. For each personnel line-item, write a justification of need in Column Q. Describe the role and its responsiblities, and explain how this role is critical to the delivery of the project.\n10. Personnel cannot exceed 100% of their time on all active projects.\n11. If loaded labor rates are utilized, a description of the costs the loaded rate is comprised of must be included in the Additional Explanation section below. NIST/DOC must review all components of the loaded labor rate for reasonableness and unallowable costs (e.g., fee or profit). \n12. Personnel Cost Share/Matching: Please provide any cost share/matching that is being provided for personnel.  If no cost share/matching is included for that line item, please select \"No\" in Column R and do not complete Columns S through V."]
[]
[{"$nulls":17},"Personnel Cost Share/Matching"]
["Position Title","Unit","Level of Effort","Unit Cost","Subtotal Salary","Fringe Benefits","Fringe Rate","Total Compensation","Estimated Drawdown Year","Line item is included in indirect cost base? (Yes/No)","% Allocable for the Administration of the Grant (If applicable)","Total Salary for the Administration of the Grant","Total Fringe for the Administration of the Grant","% Allocable for the Evaluation of the Grant (If applicable)","Total Salary for the Evaluation of the Grant","Total Fringe for the Evaluation of the Grant","Justification of Need","Is Cost Share/  Matching Provided?","Total Match Value ($)","Type (Cash or In Kind) ","Source","Cost Share Item/ Description"]
["Example: Grant Manager","Annual",1,{"v":80000,"d":"$80,000.00"},{"v":80000,"d":"$80,000.00"},{"v":28000,"d":"$28,000.00"},{"v":0.35,"d":"35.00%"},{"v":108000,"d":"$108,000.00"},"Year 1","Yes",{"v":0.3,"d":"30%"},{"v":24000,"d":"$24,000.00"},{"$f":"'a. Personnel'!$F9*'a. Personnel'!$K9","v":{"v":8400,"d":"$8,400.00"}},{"v":0.05,"d":"5%"},{"$f":"'a. Personnel'!$E9*'a. Personnel'!$N9","v":{"v":4000,"d":"$4,000.00"}},{"$f":"'a. Personnel'!$F9*'a. Personnel'!$N9","v":{"v":1400,"d":"$1,400.00"}},"The Grant Manager will be responsible for completing NEGP reports; archiving grant-related documents and documentation; preparing for, and supporting, any activities related to grant monitoring, audit or compliance requests; compiling, reconciling, and managing the submission of subgrantee reports and documents. \n\nThe fringe benefit rate of the Grant Manager is expected to be 35% of the salary charges. Fringe benefits for this position include health and dental care, life insurance, long-term disability, retirement, workers compensation, and agency personnel charges.","Yes",{"v":108000,"d":"$108,000"},"Cash","State","Cost match is being  provided through a state grant program to assist with staffing support."]
["Example: Legal Services","Hour",300,{"v":300,"d":"$300.00"},{"v":90000,"d":"$90,000.00"},{"v":18000,"d":"$18,000.00"},{"v":0.2,"d":"20.00%"},{"v":108000,"d":"$108,000.00"},"Year 1","No",{"v":1,"d":"100%"},{"v":90000,"d":"$90,000.00"},{"$f":"'a. Personnel'!$F10*'a. Personnel'!$K10","v":{"v":18000,"d":"$18,000.00"}},{"v":0,"d":"0.00%"},{"$f":"'a. Personnel'!$E10*'a. Personnel'!$N10","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F10*'a. Personnel'!$N10","v":{"v":0,"d":"$0.00"}},"An attorney will be hired to handle all contracts and legal needs for the tribe. Their hourly rate will be $300 and they are expected to complete 300 hours of work. \n\nThe fringe benefit rate of this attorney is expected to be 20% of the salary charges. Fringe benefits for this position include health and dental care, life insurance, long-term disability, retirement, workers compensation, and agency personnel charges.","No"]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"$f":"C11*D11","v":{"v":0,"d":"$0.00"}},{"$f":"E11*G11","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"SUM(E11:F11)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E11*'a. Personnel'!$K11,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F11*'a. Personnel'!$K11","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E11*'a. Personnel'!$N11,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F11*'a. Personnel'!$N11,2)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"$f":"C12*D12","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"$f":"SUM(E12:F12)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E12*'a. Personnel'!$K12,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F12*'a. Personnel'!$K12","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E12*'a. Personnel'!$N12,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F12*'a. Personnel'!$N12,2)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"$f":"SUM(E13:F13)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E13*'a. Personnel'!$K13,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F13*'a. Personnel'!$K13","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E13*'a. Personnel'!$N13,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F13*'a. Personnel'!$N13,2)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"$f":"SUM(E14:F14)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E14*'a. Personnel'!$K14,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F14*'a. Personnel'!$K14","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E14*'a. Personnel'!$N14,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F14*'a. Personnel'!$N14,2)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"$f":"SUM(E15:F15)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E15*'a. Personnel'!$K15,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F15*'a. Personnel'!$K15","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E15*'a. Personnel'!$N15,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F15*'a. Personnel'!$N15,2)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E16*'a. Personnel'!$K16,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F16*'a. Personnel'!$K16","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E16*'a. Personnel'!$N16,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F16*'a. Personnel'!$N16,2)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E17*'a. Personnel'!$K17,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F17*'a. Personnel'!$K17","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E17*'a. Personnel'!$N17,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F17*'a. Personnel'!$N17,2)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"$f":"SUM(E18:F18)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E18*'a. Personnel'!$K18,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F18*'a. Personnel'!$K18","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E18*'a. Personnel'!$N18,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F18*'a. Personnel'!$N18,2)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"$f":"SUM(E19:F19)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E19*'a. Personnel'!$K19,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F19*'a. Personnel'!$K19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E19*'a. Personnel'!$N19,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F19*'a. Personnel'!$N19,2)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"$f":"SUM(E20:F20)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E20*'a. Personnel'!$K20,2)","v":{"v":0,"d":"$0.00"}},{"$f":"'a. Personnel'!$F20*'a. Personnel'!$K20","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('a. Personnel'!$E20*'a. Personnel'!$N20,2)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND('a. Personnel'!$F20*'a. Personnel'!$N20,2)","v":{"v":0,"d":"$0.00"}}]
[]
["TOTAL PERSONNEL",{"$nulls":3},{"$f":"SUM(E11:E20)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F11:F20)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H11:H20)","v":{"v":0,"d":"$0"}},"Total Indirect Cost Base:",{"$f":"SUMIF(J11:J20,\"Yes\",H11:H20)","v":{"v":0,"d":"$0"}},"Sum of Administration Cost:",{"$f":"SUM(L11:L20)","v":{"v":0,"d":"$0"}},{"$f":"SUM(M11:M20)","v":{"v":0,"d":"$0"}},"Sum of Evaluation Cost:",{"$f":"SUM(O11:O20)","v":{"v":0,"d":"$0"}},{"$f":"SUM(P11:P20)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(S11:S20)","v":{"v":0,"d":"$0"}}]
[]
[null,"Estimated Costs Per Year"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Total per year",{"$f":"SUMIF($I$11:$I$20,B25,$H$11:$H$20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($I$11:$I$20,C25,$H$11:$H$20)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
["Additional Explanation (as needed):"]

{"sheet":"b. Travel","index":3,"n_rows":35,"n_cols":25,"rows_kept":35,"merged":[[1,0,1,24],[2,0,2,24],[4,20,4,24],[28,0,28,9],[30,1,30,5],[34,0,34,24]]}
[]
["b. Travel"]
["INSTRUCTIONS\n1. Only travel that is directly associated with this award and necessary for performance of the project should be included as a direct travel cost to the award.\n2. Funds requested in the travel category should be only for project staff. Travel for consultants/contractors or subrecipients should be shown in Tab e1. Contractual or Tab e2. Subawards cost categories.\n3. Travel costs should remain consistent with travel costs incurred by an organization during normal business operations as a result of the organizations written travel policy. In absence of a written travel policy, organizations must follow the regulations prescribed by the General Services Administration (GSA). \n4. Enter a purpose of travel/justification of need in Column A. Include a brief (1-3 sentences) description of planned activities associated with the travel expense.  Examples of Purpose of Travel are subrecipient site visits, DOC meetings, project management meetings, etc. \n5. Data entered in Columns B through J are on a per-trip basis, not a per-person basis.\n6. Enter if the trip is to an in-state or out-of-state destination in Column B.\n7. Enter the number of days in Column C, inclusive of the day of departure and day of return.\n8. Enter the number of travelers in Column D, including the number of all personnel that will be traveling on the trip.\n9. Enter the cost of lodging per traveler per night in Column E, using the cost of each lodging unit if each person has their own accommodation. If any accommodation is shared, take the total cost of lodging and divide that figure by the number of individuals. If GSA rates are not used, please provide an explanation in the space at the bottom of this tab. \n10. Enter the cost of airfare per traveler in Column F if the trip requires airfare. This should represent the roundtrip cost per traveler. If the traveler is taking ground transportation, enter $0.\n11. Enter the vehicle cost per traveler in Column G by taking the total cost of the vehicle rented and dividing that figure by the number of individuals. \n12. Enter the total per diem cost for the entire trip in Column H. This rate should include a sum of all per diem costs on a per traveler basis and should match your respective travel policy. If using GSA rates, identify which rates your application is using in the \"Basis for Estimating Costs\" in Column L. If you are using an alternate per diem rate, please state the policy and the modified per diem rate in the Basis for Estimating Costs. \n13. Enter the mileage cost in Column I by taking the number of anticipated miles to be driven and multiplying it by your fuel cost according to your applicable mileage policy.\n14. Enter any miscellaneous costs not accounted for in previous columns in Column J. Provide further details about what miscellaneous costs are incurred in the Basis for Estimating Costs column in Column T.\n15. The cost per trip will automatically calculate in Column K.\n16. If this trip will be repeated multiple times in one year, put the number of identical trips that will happen each year in Column L. If this trip is not repeated throughout the year, please put a 1 in Column L. You must put a number in Column L for the total to calculate. Column M will autopopulate with the annual cost for this trip line item.\n17. Enter the estimated drawdown year in Column N. This is the year when you expect to spend the funds. This will autopopulate into the \"Estimated Costs Per Year\" table at the bottom of this tab.\n18. Enter whether the line item is included in your indirect cost base in Column O. Reference your specific indirect cost rate method for further guidance on what items will count towards your indirect cost base.\n19. Include the percentage of the cost that will be allocated to the administration of the grant in Column P (e.g., the percentage of travel dedicated to the administration of the grant). The total travel cost that is allocable to the administration of the grant will automatically calculate and inform Columns C and D of the \"Instructions and Summary\" tab.      \n20. Include the percentage of the cost that will be allocated to the evaluation of the grant in Column R (e.g., the percentage of travel dedicated to the evaluation of the grant). The total personnel cost that is allocable to the evaluation of the grant will automatically calculate and inform Columns F and G of the \"Instructions and Summary\" tab.      \n21. The Basis for Estimating Costs in Column T should be used to enter the information sources used to determine costs entered in the preceding cells. Examples include past trips, travel quotes, and GSA rates.    \n22. Travel Cost Share/Matching: Please provide any cost share/matching that is being provided for travel.  If no cost share/matching is included for that line item, please select \"No\" in Column U and do not complete Columns V through Y."]
[]
[{"$nulls":20},"Travel Cost Share/Matching"]
["Purpose of Travel/Justification of Need","Type","No. of Days","No. of Travelers","Lodging Per Traveler/  Per Night","Airfare per Traveler","Vehicle Cost per Traveler","Total Per Diem Cost per Traveler","Total Mileage Cost (Roundtrip)","Miscellaneous","Cost per Trip","# of Identical Trips per Year","Total Cost per Year","Estimated Drawdown Year","Line item is included in indirect cost base? Yes/No","% Allocable for the Administration of the Grant (If applicable)","Total Travel for the Administration of the Grant","% Allocable for the Evaluation of the Grant (If applicable)","Total Travel for the Evaluation of the Grant","Basis for Estimating Costs","Is Cost Share/  Matching Provided?","Total Match Value ($)","Type (Cash or In Kind) ","Source","Cost Share Item/Description"]
["Example: Digital Skills Training\n\nFunds are requested for 2 Office staff members to travel to Y city for the Digital Skills Training series kick-off using a rented automobile.\n\nRequesting mileage estimated at 250 miles at GSA rate of $.725 per mile.","In-State",4,2,{"v":180,"d":"$180.00"},{"v":0,"d":"$0.00"},{"v":100,"d":"$100.00"},{"v":276.5,"d":"$276.50"},{"v":0,"d":"$0.00"},{"v":60,"d":"$60.00"},{"$f":"(((C7-1)*E7)*D7)+(D7*F7)+(D7*G7)+(D7*H7)+I7+J7","v":{"v":1893,"d":"$1,893.00"}},1,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":1893,"d":"$1,893.00"}},"Year 1","Yes",{"v":0,"d":"0%"},{"$f":"'b. Travel'!$K7*'b. Travel'!$P7","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"v":0,"d":"$0.00"},"For per diem, current GSA rates were used with the first and last day of travel being 75% of the total per diem amount.\n\nVehicle rental costs were calculated using local car rental company quotes.\n\nLodging is based on quote from local hotels.\n\nMiscellaneous costs are gas for the rented automobile.\n\nNo airfare or mileage costs are applicable. ","No"]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P8,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(M8*R8,2)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P9,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P10,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P11,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P12,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P13,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P14,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P15,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P16,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P17,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P18,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P19,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P20,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P21,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P22,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P23,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P24,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P25,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P26,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[{"$nulls":10},{"v":0,"d":"$0.00"},null,{"$f":"Table2[[#This Row],[Cost per Trip]]*Table2[[#This Row],['# of Identical Trips per Year]]","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(Table2[[#This Row],[Total Cost per Year]]*'b. Travel'!$P27,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[]
["TOTAL TRAVEL",{"$nulls":11},{"$f":"SUM(M8:M27)","v":{"v":0,"d":"$0"}},"Total Indirect Cost Base:",{"$f":"SUMIF($O$8:$O$27, \"Yes\",$M$8:$M$27)","v":{"v":0,"d":"$0"}},"Sum of Administration Cost:",{"$f":"SUM(Q8:Q27)","v":{"v":0,"d":"$0"}},"Sum of Evaluation Cost:",{"$f":"SUM(S8:S27)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(V8:V27)","v":{"v":0,"d":"$0"}}]
[]
[null,"Estimated Costs Per Year"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Total per year",{"$f":"SUMIF($N$8:$N$27,B32,$M$8:$M$27)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($N$8:$N$27,C32,$M$8:$M$27)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
["Additional Explanation (as needed):"]

{"sheet":"c. Equipment","index":4,"n_rows":25,"n_cols":17,"rows_kept":25,"merged":[[1,0,1,16],[2,0,2,16],[4,12,4,16],[20,1,20,5],[24,0,25,16]]}
[]
["c. Equipment"]
["INSTRUCTIONS\n1. Equipment means a single item of tangible, personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost that equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes, or $10,000. Please refer to the applicable Federal regulations in 2 CFR 200 for specific equipment definitions and treatment. Do not include supply items under equipment. Please refer to 2 CFR 200 and Tab d. Supplies on what constitutes a supply item.\n2. Any equipment that is leased must be listed under Tab g. Other and not under this Tab c. Equipment.  \n3. Enter the equipment item name in Column A.\n4. Enter the equipment quantity in Column B and the unit cost in Column C. The total cost of the equipment item will be calculated in Column D.\n5. Enter the estimated drawdown year in Column E. This is the year when you expect to spend the funds. This will autopopulate into the \"Estimated Costs Per Year\" table at the bottom of this tab.\n6. Enter whether the line item is included in your indirect cost base in Column F. Reference your specific indirect cost rate method for further guidance on what items will count towards your indirect cost base.\n7. Include the percentage of the cost that will be allocated to the administration of the grant in Column G (e.g., the percentage of equipment dedicated to the administration of the grant). The total equipment cost that is allocable to the administration of the grant will automatically calculate and inform Columns C and D of the \"Instructions and Summary\" tab.      \n8. Include the percentage of the cost that will be allocated to the evaluation of the grant in Column I (e.g., the percentage of equipment dedicated to the evaluation of the grant). The total equipment cost that is allocable to the evaluation of the grant will automatically calculate and inform Columns C and D of the \"Instructions and Summary\" tab.       \n9. Enter the basis of estimating cost in Column K to identify sources used to determine the costs entered in preceding fields. If using a quote, please explain the quote and any information provided in the quote. If using a prior project or experience, please provide that estimate and how this estimate compares to this new equipment.\n10. For each equipment line item, provide a justification of need in Column L. Describe the requested equipment and how it directly supports goals of the proposed project.\n11. Equipment Cost Share/Matching:Please provide any cost share/matching that is being provided for equipment.  If no cost share/matching is included for that line item, please select \"No\" in Column M and do not complete Columns N  through Q.\n"]
[]
[{"$nulls":12},"Equipment Cost Share/Matching"]
["Equipment Item","Qty","Unit Cost \n(More than $10,000/unit)      ","Total Cost             ","Estimated Drawdown Year","Line item is included in the indirect cost base? (Yes/No)","% Allocable for the Administration of the Grant (If applicable)","Total Equipment for the Administration of the Grant","% Allocable for the Evaluation of the Grant (If applicable) ","Total Equipment for the Evaluation of the Grant","Basis of Estimating Cost","Justification of Need","Is Cost Share/  Matching Provided?","Total Match Value ($)","Type (Cash or In Kind) ","Source","Cost Share Item/Description"]
["Example:  Laser All-In-One Printer",1,{"v":13699,"d":"$13,699.00"},{"$f":"B7*C7","v":{"v":13699,"d":"$13,699.00"}},"Year 2","Yes",{"v":1,"d":"100%"},{"$f":"'c. Equipment'!$G7*'c. Equipment'!$D7","v":{"v":13699,"d":"$13,699.00"}},{"v":0,"d":"0%"},{"$f":"'c. Equipment'!$D7*'c. Equipment'!$I7","v":{"v":0,"d":"$0.00"}},"Online Cost Comparison","The high-capacity printer is needed to support the Tribe. Cost comparisons across eligible vendors of renting for a period of five years or purchasing demonstrated that purchasing is more cost effective. The proposed cost was the best value among eligible vendors and included a warranty covering maintenance costs for a period of five years.","No"]
[{"$nulls":3},{"$f":"B8*C8","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G8*'c. Equipment'!$D8,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D8*'c. Equipment'!$I8,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"$f":"B9*C9","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G9*'c. Equipment'!$D9,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D9*'c. Equipment'!$I9,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"$f":"B10*C10","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G10*'c. Equipment'!$D10,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D10*'c. Equipment'!$I10,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"$f":"B11*C11","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G11*'c. Equipment'!$D11,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D11*'c. Equipment'!$I11,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G12*'c. Equipment'!$D12,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D12*'c. Equipment'!$I12,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"$f":"B13*C13","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G13*'c. Equipment'!$D13,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D13*'c. Equipment'!$I13,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G14*'c. Equipment'!$D14,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D14*'c. Equipment'!$I14,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G15*'c. Equipment'!$D15,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D15*'c. Equipment'!$I15,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G16*'c. Equipment'!$D16,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D16*'c. Equipment'!$I16,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":3},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$G17*'c. Equipment'!$D17,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0%"},{"$f":"ROUND('c. Equipment'!$D17*'c. Equipment'!$I17,1)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
["TOTAL EQUIPMENT",null,null,{"$f":"SUM(D8:D17)","v":{"v":0,"d":"$0"}},"Total Indirect Cost Base:",{"$f":"SUMIF(F8:F17,\"Yes\",D8:D17)","v":{"v":0,"d":"$0"}},"Sum of Administration Cost:",{"$f":"SUM(H8:H17)","v":{"v":0,"d":"$0"}},"Sum of Evaluation Cost:",{"$f":"SUM(J8:J17)","v":{"v":0,"d":"$0"}},{"$nulls":3},{"$f":"SUM(N8:N17)","v":{"v":0,"d":"$0"}}]
[]
[null,"Estimated Costs Per Year"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Total per year",{"$f":"SUMIF($E$8:$E$17,B22,$D$8:$D$17)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($E$8:$E$17,C22,$D$8:$D$17)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($E$8:$E$17,D22,$D$8:$D$17)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
["Additional Explanation (as needed):"]

{"sheet":"d. Supplies","index":5,"n_rows":24,"n_cols":17,"rows_kept":24,"merged":[[0,0,0,1],[1,0,1,16],[2,0,2,16],[4,12,4,16],[17,0,17,2],[19,1,19,5],[23,0,24,16]]}
[]
["d. Supplies"]
["INSTRUCTIONS\n1.Supplies are generally defined as all tangible personal property other than equipment, which is generally an item with an acquisition cost of less than $10,000 or a useful life expectancy of one year or less.\n2. Name the supply item in Column A.\n3. Enter the quantity the supply item in Column B and the unit cost in Column C. The total cost of the supply item will be calculated in Column D.\n4. Enter the estimated drawdown year in Column E. This is the year when you expect to spend the funds. This will autopopulate into the \"Estimated Costs Per Year\" table at the bottom of this tab.\n5. Enter whether the line item is included in your indirect cost base in Column F. Reference your specific indirect cost rate method for further guidance on what items will count towards your indirect cost base.\n6. Include the percentage of the cost that will be allocated to the administration of the grant in Column G (e.g., the percentage of supplies dedicated to the administration of the grant). The total supplies cost that is allocable to the administration of the grant will automatically calculate and inform Columns C and D of the \"Instructions and Summary\" tab. \n7. Include the percentage of the cost that will be allocated to the evaluation of the grant in Column I (e.g., the percentage of equipment dedicated to the evaluation of the grant). The total supplies cost that is allocable to the evaluation of the grant will automatically calculate and inform Columns C and D of the \"Instructions and Summary\" tab.     \n8. Enter the basis of estimating cost in Column K to identify sources used to determine the costs entered in preceding fields. If using a quote, please explain the quote and any information provided in the quote. If using a prior project or experience, please provide that estimate and how this estimate compares to this new supply.\n9. For each supply line item, provide a justification of need in Column L. Describe the requested supply and how it directly supports goals of the proposed project.\n10. Supplies Cost Share/Matching:Please provide any cost share/matching that is being provided for supplies.  If no cost share/matching is included for that line item, please select \"No\" in Column M  and do not complete Columns N through Q."]
[]
[{"$nulls":12},"Supplies Cost Share/Matching"]
["Supply Item","Qty","Unit Cost \n($10,000 or less)        ","Total Cost             ","Estimated Drawdown Year","Line item is included in the indirect cost base? (Yes/No)","% Allocable for the Administration of the Grant (If applicable)","Total Supplies for the Administration of the Grant","% Allocable for the Evaluation of the Grant (If applicable)","Total Supplies for the Evaluation of the Grant","Basis of Estimating Cost","Justification of Need","Is Cost Share/  Matching Provided?","Total Match Value ($)","Type (Cash or In Kind) ","Source","Cost Share Item/Description"]
["Example: Two (2) 15\" laptop computers ",2,{"v":1000,"d":"$1,000.00"},{"$f":"B7*C7","v":{"v":2000,"d":"$2,000.00"}},"Year 1","Yes",{"v":1,"d":"100%"},{"$f":"'d. Supplies'!$D7*'d. Supplies'!$G7","v":{"v":2000,"d":"$2,000.00"}},{"v":0,"d":"0.00%"},{"$f":"'d. Supplies'!$D7*'d. Supplies'!$I7","v":{"v":0,"d":"$0"}},"Catalog price (based on online search)","The laptop computers are needed for Tribal Office staff (e.g., Grant Manager) to carry out their work on the Native Entities Grant Program.","No"]
["Example: General office supplies",36,{"v":150,"d":"$150.00"},{"$f":"B8*C8","v":{"v":5400,"d":"$5,400.00"}},"Year 3","Yes",{"v":1,"d":"100%"},{"$f":"'d. Supplies'!$D8*'d. Supplies'!$G8","v":{"v":5400,"d":"$5,400.00"}},{"v":0,"d":"0.00%"},{"$f":"'d. Supplies'!$D8*'d. Supplies'!$I8","v":{"v":0,"d":"$0"}},"Catalog price (based on online search). Items expected to include pens, paper, staples, sticky notes, etc. for approximately five (5) people. Unit cost is monthly.","General office supplies are needed to carry out the work of the Grant Program (i.e., reporting requirements) during the period leading up to the submission of the Final Proposal and throughout the period of performance.","No"]
[null,0,{"v":0,"d":"$0.00"},{"$f":"B9*C9","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D9*'d. Supplies'!$G9,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D9*'d. Supplies'!$I9,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,0,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D10*'d. Supplies'!$G10,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D10*'d. Supplies'!$I10,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,0,{"v":0,"d":"$0.00"},{"$f":"B11*C11","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D11*'d. Supplies'!$G11,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D11*'d. Supplies'!$I11,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,0,{"v":0,"d":"$0.00"},{"$f":"B12*C12","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D12*'d. Supplies'!$G12,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D12*'d. Supplies'!$I12,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,0,{"v":0,"d":"$0.00"},{"$f":"B13*C13","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D13*'d. Supplies'!$G13,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D13*'d. Supplies'!$I13,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,0,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D14*'d. Supplies'!$G14,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D14*'d. Supplies'!$I14,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,0,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D15*'d. Supplies'!$G15,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D15*'d. Supplies'!$I15,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,0,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D16*'d. Supplies'!$G16,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND('d. Supplies'!$D16*'d. Supplies'!$I16,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
["TOTAL SUPPLIES",null,null,{"$f":"SUM(D9:D16)","v":{"v":0,"d":"$0"}},"Total Indirect Cost Base:",{"$f":"SUMIF(F9:F16,\"Yes\",D9:D16)","v":{"v":0,"d":"$0"}},"Sum of Administration Cost:",{"$f":"SUM(H9:H16)","v":{"v":0,"d":"$0"}},"Sum of Evaluation Cost:",{"$f":"SUM(J9:J16)","v":{"v":0,"d":"$0"}},{"$nulls":3},{"$f":"SUM(N9:N16)","v":{"v":0,"d":"$0"}}]
[]
[null,"Estimated Costs Per Year"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Total per year",{"$f":"SUMIF($E$9:$E$16,B21,$D$9:$D$16)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($E$9:$E$16,C21,$D$9:$D$16)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
["Additional Explanation (as needed):"]

{"sheet":"e1. Contractual","index":6,"n_rows":25,"n_cols":15,"rows_kept":25,"merged":[[1,0,1,14],[2,0,2,14],[4,10,4,14],[19,1,19,5],[24,0,25,14]]}
[]
["e1. Contractual"]
["INSTRUCTIONS\n1. The Eligible Entity must provide all costs related to contractors in the applicable boxes in this tab. \n2. Definition of contractors: A contractor is a legal entity contracted to provide goods and services within normal business operations, provides similar goods or services to many different purchasers, operates in a competitive environment, provides goods or services that are ancillary to the operation of the Federal program, and is not subject to compliance requirements of the Federal program. All characteristics may not be present and judgment must be used to determine subrecipient vs. contractor status. List all contractors supplying commercial supplies or services used to support the project. \n3. In determining whether an agreement between a pass-through entity and another non-Federal entity casts the latter as a subrecipient or a contractor, the substance of the relationship is more important than the form of the agreement. Please refer to 2 CFR 200.331 Subrecipient and contractor determinations for more information on making a determination on subrecipient vs contractor.\n4. Enter the name or organization of the contractor in Column A.\n5. Enter the total cost of the contractor in Column B. \n6. Enter the estimated drawdown year in Column C. This is the year when you expect to spend the funds. This will autopopulate into the \"Estimated Costs Per Year\" table at the bottom of this tab.\n7. Enter whether the line item is included in your indirect cost base in Column D. Reference your specific indirect cost rate method for further guidance on what items will count towards your indirect cost base.\n8. Include the percentage of the cost that will be allocated to the administration of the grant in Column E (e.g., the percentage of the contractors dedicated to the administration of the grant). The total contractor costs for the administration of the Grant (Column F) will be automatically calculated. This should inform Columns C and D of the \"Instructions and Summary\" tab. Note: The Administrative cost cap applies to contractor costs only when the contractor is engaged to perform grant administration duties.\n9. Include the percentage of the cost that will be allocated to the evaluation of the grant in Column G (e.g., the percentage of the contractors dedicated to the evaluation of the grant). The total contractor costs for the Evaluation of the Grant (Column H) will be automatically calculated. This should inform Columns F and G of the \"Instructions and Summary\" tab. Note: The Evaluation cost cap applies to contractor costs only when the contractor is engaged to perform program evaluation duties.\n10. Enter a justification of need in Column I. Proper budget justifications should explain how the costs associated with each line item relate to the implementation of the project as outlined in the proposal being submitted. Justifications should be concise and be written in such a way that someone not specifically familiar with the project can conceptually understand the rational, purpose and calculation of the anticipated costs identified. Explain why items are essential in relation to the aims of the project as well as meeting the goals of the project. Do not merely restate the proposed expenditure. The specific items in the contractor budget(s) should not be explained here.        \n11. Enter the basis of estimating cost in Column J to identify sources used to determine the costs entered in preceding fields. If using a quote, please explain the quote and any information provided in the quote. If using a prior project or experience, please provide that estimate and how this estimate compares to this new equipment. For construction contracts, provide information in this column such as engineering estimates, fees, permits, prior construction, etc., and briefly justify its need as it applies to the project.\n12. Contractor Cost Share/Matching: Please provide any cost share/matching that is being provided for contractual.  If no cost share/matching is included for that line item, please select \"No\" in Column K and do not complete Columns L through O."]
[]
[{"$nulls":10},"Contractual Cost Share/Matching"]
["Contractor\nName/Organization","Contractor Costs","Estimated Drawdown Year","Line item is included in the indirect cost base? (Yes/No)","% Allocable for the Administration of the Grant (If applicable)","Total Contractor Costs for the Administration of the Grant","% Allocable for the Evaluation of the Grant (If applicable)","Total Contractor Costs for the Evaluation of the Grant","Justification of Need","Basis of Estimating Cost","Is Cost Share/ Matching Provided?","Total Match Value ($)","Type (Cash or In Kind) ","Source","Cost Share Item/Description"]
["Example: ABC IT & Program Support Services",{"v":250000,"d":"$250,000"},"Year 1","Yes",{"v":0,"d":"0%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},"ABC IT & Program Support Services will provide a critical role in the planning of 4 digital education programs. They will develop all training materials (print & online) and provide website updates including making materials available once the programming has concluded. This digital education programming is critical to increase local digital literacy and address the digital divide. ","ABC IT & Program Support Services was selected following a competitive review process in line with the applicable procurement policies. The contract amount will be inclusive of staff, travel, supplies, and all other costs necessary to meet the goals of the contract. \n\nThe contractor expects to have 3 total staff members (Two facilitatiors and one IT specialist) dedicated to these programs. The two facilitators are expected to work 1,000 hours each at a rate of $65 per hour for a total of $130,000 ($65,000 per facilitator). The IT specialist is expected to work 1200 hours at a rate of $100 per hour for a total of $130,000. The total cost for this contract would be $250,000.\n\nContractor responsible for paying payroll taxes and fringe benefits.","Yes",{"v":30000,"d":"$30,000"},"Cash","Other","A local non-profit educational outreach organization is providing a $30,000 donation to assist with these digital education programs from their overall donor pool. "]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(E8*B8,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(B8*G8,2)","v":{"v":0,"d":"$0"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(E9*B9,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(B9*G9,2)","v":{"v":0,"d":"$0"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
["TOTAL CONTRACTORS",{"$f":"SUM(B8:B16)","v":{"v":0,"d":"$0"}},"Total Indirect Cost Base:",{"$f":"SUMIF(D8:D16,\"Yes\",B8:B16)","v":{"v":0,"d":"$0"}},"Sum of Administration Cost:",{"$f":"SUM(F8:F16)","v":{"v":0,"d":"$0"}},"Sum of Evaluation Cost:",{"$f":"SUM(H8:H16)","v":{"v":0,"d":"$0"}},{"$nulls":3},{"$f":"SUM(L8:L16)","v":{"v":0,"d":"$0"}}]
[]
[null,"Estimated Costs Per Year"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Total per year",{"$f":"SUMIF($C$8:$C$16,B21,$B$8:$B$16)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($C$8:$C$16,C21,$B$8:$B$16)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($C$8:$C$16,D21,$B$8:$B$16)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[]
["Additional Explanation (as needed):"]

{"sheet":"e2. Subawards","index":7,"n_rows":30,"n_cols":16,"rows_kept":30,"merged":[[1,0,1,15],[2,0,2,15],[4,11,4,15],[23,0,23,1],[25,1,25,5],[29,0,30,15]]}
[]
["e.2 Subawards"]
["INSTRUCTIONS\n1. The Eligible Entity must provide all costs related to subrecipients in the applicable boxes in this tab.  \n2. Definition of subrecipients (sub-awardees): A subrecipient is a legal entity to which a subaward is made, who has performance measured against whether the objectives of the Federal program are met, is responsible for programmatic decision making, must adhere to applicable Federal program compliance requirements, and uses the Federal funds to carry out a program of the organization. All characteristics may not be present and judgment must be used to determine subrecipient vs. contractor status.\n3. In determining whether an agreement between a pass-through entity and another non-Federal entity casts the latter as a subrecipient or a contractor, the substance of the relationship is more important than the form of the agreement. Please refer to 2 CFR 200.331 Subrecipient and contractor determinations for more information on making a determination on subrecipient vs contractor.\n4. Enter the subrecipient name or organization in Column A.\n5. Enter the project name in Column B.\n6. Enter the total cost of the subrecipient in Column C.\n7. Enter the estimated drawdown year in Column D. This is the year when you expect to spend the funds. This will autopopulate into the \"Estimated Costs Per Year\" table at the bottom of this tab.\n8. Enter whether the line item is included in your indirect cost base in Column E. Reference your specific indirect cost rate method for further guidance on what items will count towards your indirect cost base.\n9. Include the percentage of the cost that will be allocated to the administration of the grant in Column F (e.g., the percentage of the subrecipient cost dedicated to the administration of the grant). The total subaward cost that is allocable to the administration of the grant will automatically calculate and inform Columns C and D of the \"Instructions and Summary\" tab. Note: The Administrative cost cap applies to subrecipient costs only when the subrecipient is engaged to perform grant administration duties.\n10. Include the percentage of the cost that will be allocated to the evaluation of the grant in Column H (e.g., the percentage of the subrecipient cost dedicated to the evaluation of the grant). The total subaward cost that is allocable to the evaluation of the grant will automatically calculate and inform Columns F and G of the \"Instructions and Summary\" tab. Note: The Evaluation cost cap applies to subrecipient costs only when the contractor is engaged to perform program evaluation duties.\n11. Enter a justification of need in Column J. Proper budget justifications should explain how the costs associated with each line item relate to the implementation of the project as outlined in the proposal being submitted. Justifications should be concise and be written in such a way that someone not specifically familiar with the project can conceptually understand the rational, purpose and calculation of the anticipated costs identified. Explain why items are essential in relation to the aims of the project as well as meeting the goals of the project. Do not merely restate the proposed expenditure. The specific items in the subrecipient's budget(s) should not be explained here.\n12. Enter the basis of estimating cost in Column K to identify sources used to determine the costs entered in preceding fields. If using a quote, please explain the quote and any information provided in the quote. If using a prior project or experience, please provide that estimate and how this estimate compares to the work being done by the subrecipients. Describe if the project was competitively selected and if the Eligible Entity followed their procurement policy. The cost per location should be listed if applicable.\n13. Subrecipient Cost Share/Matching: Please provide any cost share/matching that is being provided for subawards.  If no cost share/matching is included for that line item, please select \"No\" in Column L and do not complete Columns M through P.\n"]
[]
[{"$nulls":11},"Subrecipient Cost Share/Matching"]
["Subrecipient\nName/Organization","Project Name","Subrecipient Costs","Estimated Drawdown Year","Line item is included in the indirect cost base? (Yes/No)","% Allocable for the Administration of the Grant (If applicable)","Total Subrecipient Costs for the Administration of the Grant","% Allocable for the Evaluation of the Grant (If applicable)","Total Subrecipient Costs for the Evaluation of the Grant","Justification of Need","Basis of Estimating Cost","Is Cost Share/  Matching Provided?","Total Match Value ($)","Type (Cash or In Kind) ","Source","Cost Share Item/Description"]
["Example: Mobile Health Clinic XY","Telehealth Expansion",{"v":282500,"d":"$282,500"},"Year 2","Yes",{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0.1,"d":"10.00%"},{"$f":"H7*C7","v":{"v":28250,"d":"$28,250.00"}},"Funds are requested to support the expansion of telehealth services through the deployment of a mobile health clinic and the delivery of targeted training to ensure Tribal citizens can effectively access and utilize telehealth technologies. A lack of access to healthcare continues to be an issue within tribal lands and the use of a mobile health lab will ensure follow-up care that goes beyond only telehealth options. ","The cost of the mobile health clinic is estimated to include the following components: staff, equipment, vehicle, and gasoline.\n\nThe mobile health clinic is expected to go out into the community for six hours one day a week for 50 weeks a year. The clinic will be staffed by a doctor and nurse. The weekly expense for the staff will be $1,950 ($200 hour for the doctor, $125 per hour for the nurse). The equipment cost per week will be $1,500. The vehicle cost per week will be $2,000. The gasoline cost is expected to be $200 per week with 50 gallons used per week at an average of $4 per gallon. These estimates were provided by the existing mobile health clinic and are based on their current actual operations.\n\nThe total subaward cost is therefore $97,500 (staff) + $75,000 (equipment) + $100,000 (equipment) + $10,000 (gas) for a total of $282,500.","Yes",{"v":50000,"d":"$50,000"},"In Kind","Other","The mobile health clinic is providing an in kind contribution through donating one third of the actual weekly cost to operate the vehicle. This is a total in kind contribution of $50,000 (Normal weekly cost is $3,000 of which $1,000 per week is being donated by the mobile health clinic while it is in operation)."]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Administration of the Grant (If applicable)]],1)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(Table12[[#This Row],[Subrecipient Costs]]*Table12[[#This Row],[% Allocable for the Evaluation of the Grant (If applicable)]],2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00%"},{"$f":"C22*F22","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"H22*C22","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
["TOTAL SUBRECIPIENTS",null,{"$f":"SUM(C8:C22)","v":{"v":0,"d":"$0"}},"Total Indirect Cost Base:",{"$f":"SUMIF(E8:E22,\"Yes\",C8:C22)","v":{"v":0,"d":"$0"}},"Sum of Administration Cost:",{"$f":"SUM(G8:G22)","v":{"v":0,"d":"$0"}},"Sum of Evaluation Cost:",{"$f":"SUM(I8:I22)","v":{"v":0,"d":"$0"}},{"$nulls":3},{"$f":"SUM(M8:M22)","v":{"v":0,"d":"$0"}}]
[]
[null,"Estimated Costs Per Year"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Total per year",{"$f":"SUMIF($D$8:$D$22,B27,$C$8:$C$22)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($D$8:$D$22,C27,$C$8:$C$22)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($D$8:$D$22,D27,$C$8:$C$22)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($D$8:$D$22,E27,$C$8:$C$22)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($D$8:$D$22,F27,$C$8:$C$22)","v":{"v":0,"d":"$0.00"}}]
[]
["Additional Explanation (as needed):"]

{"sheet":"f. Construction","index":8,"n_rows":28,"n_cols":15,"rows_kept":28,"merged":[[0,0,1,14],[2,0,2,14],[4,10,4,14],[23,1,23,5],[27,0,28,14]]}
["f. Construction"]
[]
["INSTRUCTIONS\n1. List all proposed construction being undertaken directly by the Eligible Entity below.\n2. Construction for the purpose of budgeting, is defined as the construction of new buildings, completion of shell space in existing buildings, renovation or rehabilitation of existing buildings, and construction or development of real property infrastructure improvements (e.g., site preparation, utilities, streets, curbs, sidewalks, parking lots, other streetscaping improvements). \n3. Any construction work that is performed by a contractor or subrecipient should be entered under Tab e. Contractual-Subawards.  Important reminder: An Eligible Entity may not undertake broadband deployment construction activities itself.  It must engage in a competitive subgrant process for these activities, so any such activities must be classified under the Contractual/Subawards tabs.\n4. Enter a brief general description in Column A on the construction project to be covered by the proposed cost.\n5. Enter the cost in Column B of the entirety of the construction. \n6. Enter the estimated drawdown year in Column C. This is the year when you expect to spend the funds. This will autopopulate into the \"Estimated Costs Per Year\" table at the bottom of this tab.\n7. Enter whether the line item is included in your indirect cost base in Column D. Reference your specific indirect cost rate method for further guidance on what items will count towards your indirect cost base.\n8. Include the percentage of the cost that will be allocated to the administration of the grant in Column E (e.g., the percentage of construction dedicated to the administration of the grant). The total construction cost that is allocable to the administration of the grant will automatically calculate and inform Columns C and D of the \"Instructions and Summary\" tab.\n9. Include the percentage of the cost that will be allocated to the evaluation of the grant in Column G (e.g., the percentage of equipment dedicated to the evaluation of the grant). The total construction cost that is allocable to the administration of the grant will automatically calculate and inform Columns F and G of the \"Instructions and Summary\" tab.\n10. Enter the basis of estimating cost in Column I and provide sources used to estimate the sum entered in Column B. Examples include contractor quotes, prior purchases of similar or like items, and published price lists. If using a quote, please explain the quote and any information provided in the quote. If using a prior project or experience, please provide that estimate and how this estimate compares to the work being done by the subrecipients. Describe if the project was competitively selected and if the Eligible Entity followed their procurement policy. \n11. Enter the justification of need in Column J.  \n12. Construction Cost Share/Matching: Please provide any cost share/matching that is being provided for construction.  If no cost share/matching is included for that line item, please select \"No\" in Column K and do not complete Columns L through O."]
[]
[{"$nulls":10},"Construction Cost Share/Matching"]
["General Description","Cost             ","Estimated Drawdown Year","Line item is included in the indirect cost base? (Yes/No)","% Allocable for the Administration of the Grant (If applicable)","Total Construction for the Administration of the Grant","% Allocable for the Evaluation of the Grant (If applicable)","Total Construction for the Evaluation of the Grant","Basis of Estimating Cost","Justification of Need","Is Cost Share/  Matching Provided?","Total Match Value ($)","Type (Cash or In Kind) ","Source","Cost Share Item/Description"]
["Example: Expansion of a Native Entity Public Library to build a computer center.",{"v":100000,"d":"$100,000.00"},"Year 1","No",{"v":0,"d":"0.00%"},{"$f":"B7*E7","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"B7*F7","v":{"v":0,"d":"$0.00"}},"Discussions with a local construction company and estimates for necessary supplies have put the project at a tentative total cost of $100,000. Costs associated with furnishing the Computing Center with necessary equipment (computers, tablets, keyboards, monitors, etc.) can be found in the Equipment tab. Costs associated with renovating the existing library space to house the technology (physical expansion, building rewiring, etc.) are covered in the proposed $100,000 sum. ","The jurisdiction covered by the Native Entity Public Library currently does not have an alternative site for citizens without internet and/or technology access at home to use those tools. The Computing Center will serve as a site for publicly available equipment, as well as relevant training and events to promote responsible use of technology.","Yes",{"v":20000,"d":"$20,000.00"},"In Kind","Other","The local construction firm will provide $20,000 of in-kind contributions for this project through donated labor."]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(B8*E8,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(B8*G8,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"$f":"ROUND(B9*E9,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
["TOTAL CONSTRUCTION",{"$f":"SUM(B8:B20)","v":{"v":0,"d":"$0"}},"Total Indirect Cost Base:",{"$f":"SUMIF(D8:D20, \"Yes\",B8:B20)","v":{"v":0,"d":"$0"}},"Sum of Administration Cost:",{"$f":"SUM(F8:F20)","v":{"v":0,"d":"$0"}},"Sum of Evaluation Cost:",{"$f":"SUM(H8:H20)","v":{"v":0,"d":"$0"}},{"$nulls":3},{"$f":"SUM(L8:L20)","v":{"v":0,"d":"$0"}}]
[]
[null,"Estimated Costs Per Year"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Total per year",{"$f":"SUMIF($C$8:$C$20,B25,$B$8:$B$20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($C$8:$C$20,C25,$B$8:$B$20)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"SUMIF($C$8:$C$20,E25,$B$8:$B$20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($C$8:$C$20,F25,$B$8:$B$20)","v":{"v":0,"d":"$0.00"}}]
[]
["Additional Explanation (as needed):"]

{"sheet":"g. Other","index":9,"n_rows":21,"n_cols":15,"rows_kept":21,"merged":[[0,0,0,4],[1,0,1,16],[2,0,2,14],[4,10,4,14],[16,1,16,5],[20,0,22,14]]}
[]
["g. Other Direct Costs"]
["INSTRUCTIONS\n1. Other direct costs are direct cost items required for the project which do not fit clearly into other categories.  These direct costs must not be included in the indirect costs (for which the indirect rate is being applied for this project).  Examples are: tuition, printing costs, etc. which can be directly charged to the project and are not duplicated in indirect costs (overhead costs). Please ensure that information entered in this tab should not be included elsewhere.\n2. For each line-item, write a brief general description in Column A including what activites are covered by this cost.\n3. Enter the total cost for the line item in Column B.\n4. Enter the estimated drawdown year in Column C. This is the year when you expect to spend the funds. This will autopopulate the total line item cost in the corresponding year of the \"Estimated Costs Per Year\" table at the bottom of this tab.\n5. Enter whether the line item is included in your indirect cost base in Column D. This information can be found in your indirect cost rate agreement. \n6. Include the percentage of the cost that will be allocated to the administration of the grant in Column E (e.g., the percentage of Other costs dedicated to the administration of the grant). This should inform Columns C and D of the \"Instructions and Summary\" tab. \n7. Include the percentage of the cost that will be allocated to the evaluation of the grant in Column G (e.g., the percentage of equipment dedicated to the evaluation of the grant). This should inform Columns F and G of the \"Instructions and Summary\" tab. \n8. Enter the basis of estimating cost in Column I. Provide sources used to estimate the sum entered in Column B. Examples include contractor quotes, prior purchases of similar or like items, published price list.  If using a prior project or experience, please provide that estimate and how this estimate compares to this new activity.\n9. Enter the justification of need in Column J.   \n10. Other Direct Cost Share/Matching: If no cost share/matching is included for that line item, please select \"No\" in Column K and do not complete Columns L through O."]
[]
[{"$nulls":10},"Other Cost Share/Matching"]
["General Description"," Cost             ","Estimated Drawdown Year","Line item is included in the indirect cost base? (Yes/No)","% Allocable for the Administration of the Grant (If applicable)","Total Other Costs for the Administration of the Grant","% Allocable for the Evaluation of the Grant (If applicable)","Total Other Costs for the Evaluation of the Grant","Basis of Estimating Cost","Justification of Need","Is Cost Share/  Matching Provided?","Total Match Value ($)","Type (Cash or In Kind) ","Source","Cost Share Item/Description"]
["Example: Digital Literacy Train the Trainer Online Course",{"v":1500,"d":"$1,500.00"},"Year 1","No",{"v":0,"d":"0.00%"},{"$f":"B7*E7","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"B7*G7","v":{"v":0,"d":"$0.00"}},"Based on direct quotes from the vendor, ensuring transparency and accuracy in budgeting. Utilizing an approved vendor reduces procurement risk and aligns with organizational policies for compliance and quality assurance. ","A Project Manager’s attendance at a Digital Literacy Train-the-Trainer course is essential for the successful execution of the project. This course equips the Project Manager with the latest techniques and resources to effectively lead and support digital literacy initiatives, enabling them to train local facilitators and community representatives who directly engage with covered populations. By participating in this specialized training, the Project Manager gains valuable skills to coordinate, implement, and sustain digital literacy efforts across diverse communities, ensuring the project’s long-term impact and alignment with digital equity goals.","No"]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"$f":"ROUND(E8*B8,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(B8*G8,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"$f":"ROUND(E9*B9,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"ROUND(B9*G9,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"$f":"ROUND(E12*B12,2)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00%"},{"$f":"ROUND(B13*G13,2)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
["TOTAL OTHER DIRECT COSTS",{"$f":"SUM(B8:B13)","v":{"v":0,"d":"$0"}},"Total Indirect Cost Base:",{"$f":"SUMIF(D8:D13,\"Yes\",B8:B13)","v":{"v":0,"d":"$0"}},"Sum of Administration Cost:",{"$f":"SUM(F8:F13)","v":{"v":0,"d":"$0"}},"Sum of Evaluation Cost:",{"$f":"SUM(H8:H13)","v":{"v":0,"d":"$0"}},{"$nulls":3},{"$f":"SUM(L8:L13)","v":{"v":0,"d":"$0"}}]
[]
[null,"Estimated Costs Per Year"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Total per year",{"$f":"SUMIF($C$8:$C$13,B18,$B$8:$B$13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($C$8:$C$13,C18,$B$8:$B$13)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"SUMIF($C$8:$C$13,E18,$B$8:$B$13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($C$8:$C$13,F18,$B$8:$B$13)","v":{"v":0,"d":"$0.00"}}]
[]
["Additional Explanation (as needed):"]

{"sheet":"h. Indirect","index":10,"n_rows":19,"n_cols":15,"rows_kept":19,"merged":[[0,0,0,3],[1,0,1,16],[2,0,2,14],[4,10,4,14],[16,0,16,2],[18,0,19,14]]}
[]
["h. Indirect Costs"]
["INSTRUCTIONS\n1. Indirect (facilities & administrative (F&A)) costs means those costs incurred for a common or joint purpose benefitting more than one cost objective, and not readily assignable to the cost objectives specifically benefitted, without effort disproportionate to the results achieved.\n2. Indirect costs may be charged to the award if, the applicant has a Federally approved indirect cost rate or the applicant has never received a negotiated indirect cost rate and elects to charge a de minimis rate of 15 percent of modified total direct costs (MTDC), which can be used indefinitely. MTDC means all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $50,000 of each subaward (regardless of the period of performance of the subawards under the award). MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs and the portion of each subaward in excess of $50,000.\n3. Each prior cost category tabs a. through g. has a Total Indirect Cost Base calculated directly below a column titled \"Line item is included in the indirect cost rate\". The total from tabs a. through g. is the sum of all line items that were marked Yes in the column titled \"Line item is included in the Indirect cost base\". Check to ensure this number accurately represents your indirect cost base, make modifications if necessary, and include the correct total in Column B of this tab for each cost category.\n4. Enter the appropriate indirect cost rate in Column C for each cost category.  If the applicant has a current Negotiated Indirect Cost Rate Agreement (NICRA), they must use the appropriate indirect cost base defined in the agreement. If not using a NICRA, the appropriate indirect cost base is the applicant’s Modified Direct Costs as described in 2 CFR 4.414(f). Once an indirect cost rate is added, the Total Indirect Costs for every cost category will autopopulate in Column D. \n5. Enter the amount of indirect costs that will be covered by federal funds in Column E. If no cost sharing or matching is being utilized, this amount should equal the total indirect costs calculated in Column D. If cost sharing or matching is being utilized, then the sum of Column E and Column L should equal Column D.\n6. Columns F and H will automatically calculate the percentage of costs within each cost category that are being allocated towards the administration and evaluation of the grant and apply those percentages to the total indirect costs calculated for each cost category. The total indirect costs for the administration and evaluation of the grant will automatically calculate in Columns G and I.This will count towards the 10% administrative cap and 10% evaluation cap that must be met for this grant program.\n7. Enter an explanation of how you are calculating your indirect cost base in Column J.\n8. NOTE: A Recipient who elects to employ the de minimis indirect cost rate cannot claim resulting costs as a Cost Share contribution, nor can the Recipient claim \"unrecovered indirect costs\" as a Cost Share contribution.  Neither of these costs can be reflected as actual indirect cost rates realized by the organization, and therefore are not verifiable in the Recipient records as required by Federal Regulation (§200.306(b)(1)).\n9.  Indirect Cost Share/Matching: Please provide any cost share/matching that is being provided for indirect costs.  If no cost share/matching is included for that line item, please select \"No\" in Column K and do not complete Columns L through O.  "]
[]
[{"$nulls":10},"Indirect Cost Share/Matching"]
["Cost Category","Indirect Cost Base ($)","Indirect Cost Rate (%)","Total Indirect Costs ($)","Amount ($) of Indirect Costs Covered by Federal Funds","% Allocable for the Administration of the Grant (If applicable)","Total Indirect Costs for the Administration of the Grant","% Allocable for the Evaluation of the Grant (If applicable)","Total Indirect Costs for the Evaluation of the Grant","Explanation of Indirect Cost Base ","Is Cost Share/  Matching Provided?","Total Match Value ($)","Type (Cash or In Kind) ","Source","Cost Share Item/Description"]
["a. Personnel",{"v":600000,"d":"$600,000.00"},{"v":0.56,"d":"56.00%"},{"$f":"B7*C7","v":{"v":336000.00000000006,"d":"$336,000.00"}},{"v":300000,"d":"$300,000.00"},{"v":0,"d":"0.00%"},{"$f":"F7*D7","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"0.00%"},{"$f":"H7*D7","v":{"v":0,"d":"$0.00"}},"Cost base is based on negotiated rate agreement and includes Salary and Fringe Benefits.","Yes",{"v":36000,"d":"$36,000"},"In Kind","Other","Native Corporation is providing in kind support through program evaluation, strategic guidance, and recruitment assistance for digital education programs."]
["a. Personnel",null,null,{"$f":"ROUND(B8*C8,2)","v":{"v":0,"d":"$0.00"}},null,{"$f":"IFERROR(SUMIF('a. Personnel'!J11:J20,\"Yes\",'a. Personnel'!L11:M20)/'a. Personnel'!J22,0)","v":{"v":0,"d":"0.00%"}},{"$f":"ROUND(F8*D8,2)","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(SUMIF('a. Personnel'!J11:J20,\"Yes\",'a. Personnel'!O11:P20)/'a. Personnel'!J22,0)","v":{"v":0,"d":"0.00%"}},{"$f":"ROUND(H8*D8,2)","v":{"v":0,"d":"$0.00"}},null,null,{"v":0,"d":"$0.00"}]
["b. Travel",null,null,{"$f":"ROUND(B9*C9,2)","v":{"v":0,"d":"$0.00"}},null,{"$f":"IFERROR(SUMIF('b. Travel'!O8:O27,\"Yes\",'b. Travel'!Q8:Q27)/'b. Travel'!O29,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},{"$f":"IFERROR(SUMIF('b. Travel'!O8:O27,\"Yes\",'b. Travel'!S8:S27)/'b. Travel'!O29,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
["c. Equipment",null,null,{"$f":"ROUND(B10*C10,2)","v":{"v":0,"d":"$0.00"}},null,{"$f":"IFERROR(SUMIF('c. Equipment'!F8:F17,\"Yes\",'c. Equipment'!H8:H17)/'c. Equipment'!F19,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},{"$f":"IFERROR(SUMIF('c. Equipment'!F8:F17,\"Yes\",'c. Equipment'!J8:J17)/'c. Equipment'!F19,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
["d. Supplies",null,null,{"v":0,"d":"$0.00"},null,{"$f":"IFERROR(SUMIF('d. Supplies'!F9:F16,\"Yes\",'d. Supplies'!H9:H16)/'d. Supplies'!F18,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},{"$f":"IFERROR(SUMIF('d. Supplies'!F9:F16,\"Yes\",'d. Supplies'!J9:J16)/'d. Supplies'!F18,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
["e1. Contractual",null,null,{"v":0,"d":"$0.00"},null,{"$f":"IFERROR(SUMIF('e1. Contractual'!D8:D16,\"Yes\",'e1. Contractual'!F8:F16)/'e1. Contractual'!E18,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},{"$f":"IFERROR(SUMIF('e1. Contractual'!D8:D16,\"Yes\",'e1. Contractual'!H8:H16)/'e1. Contractual'!D18,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
["e2. Subawards",null,null,{"v":0,"d":"$0.00"},null,{"$f":"IFERROR(SUMIF('e2. Subawards'!E8:E22,\"Yes\",'e2. Subawards'!G8:G22)/'e2. Subawards'!E24,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},{"$f":"IFERROR(SUMIF('e2. Subawards'!E8:E22,\"Yes\",'e2. Subawards'!I8:I22)/'e2. Subawards'!E24,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
["f. Construction",null,null,{"v":0,"d":"$0.00"},null,{"$f":"IFERROR(SUMIF('f. Construction'!D8:D20,\"Yes\",'f. Construction'!F8:F20)/'f. Construction'!D22,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},{"$f":"IFERROR(SUMIF('f. Construction'!D8:D20,\"Yes\",'f. Construction'!H8:H20)/'f. Construction'!D22,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
["g. Other Direct Costs",null,null,{"v":0,"d":"$0.00"},null,{"$f":"IFERROR(SUMIF('g. Other'!D8:D13,\"Yes\",'g. Other'!F8:F13)/'g. Other'!D15,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},{"$f":"IFERROR(SUMIF('g. Other'!D8:D13,\"Yes\",'g. Other'!H8:H13)/'g. Other'!D15,0)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"$0.00"},null,null,{"v":0,"d":"$0.00"}]
[]
["TOTAL INDIRECT COSTS",null,null,{"$f":"SUM(D8:D15)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E8:E15)","v":{"v":0,"d":"$0"}},"Sum of Administration Cost:",{"$f":"SUM(G8:G15)","v":{"v":0,"d":"$0"}},"Sum of Evaluation Cost:",{"$f":"SUM(I8:I15)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(L8:L15)","v":{"v":0,"d":"$0"}}]
[]
["Additional Explanation (as needed):"]

{"sheet":"i. Cost Sharing-Matching","index":11,"n_rows":37,"n_cols":5,"rows_kept":37,"merged":[[1,0,1,4],[2,0,2,4],[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[21,0,21,4],[34,0,34,3],[36,0,36,4],[37,0,37,4]]}
[]
["i. Cost Sharing/Matching"]
["INSTRUCTIONS\n1. A detailed presentation of the cash or cash value of all cost share/matching proposed by the Eligible Entity that has not been included in tabs a through h must be provided in the table below. Identify the source organization & amount of each cost share item proposed in the award. Any cost share/matching provided by a contractor or subrecipients should be entered in Tab e1. Contractual or Tab e2. Subawards and not on this tab.\n2. Cost share/match information from each cost category tab will automatically sum in the table \"Cost Share/Matching by Cost Category\". \n3. Any cost share/matching that was not included in a cost category tab should be included in the table directly below these instructions.\n4. In Kind Definition - Contributions, which may include third-party in-kind contributions, are non-cash donations of property, goods or services, which benefit a federally assisted project, and which may count toward satisfying the non-federal matching requirement of a project’s total budgeted costs when such contributions meet certain criteria. NTIA encourages applicants to thoroughly consider potential sources of in-kind contributions that, depending on the particular property or service and the applicable federal cost principles, could include employee or volunteer services; equipment; supplies; indirect costs; computer hardware and software; and use of facilities. In the broadband context this could include, consistent with federal cost principles, waiver of fees associated with access to rights of way, pole attachments, conduits, easements, or access to other types of infrastructure.\n5. All matching must be necessary to the performance of the project. If questions exist, consult your NTIA contact before filling out In Kind cost share in this section. \n6. Fee or profit, including foregone fee or profit, are not allowable as project costs (including cost share) under any resulting award. The project may only incur those costs that are allowable and allocable to the project (including cost share) as determined in accordance with the applicable cost principles prescribed in 2 CFR Part 200.\n7. A Recipient who elects to employ the 15% de minimis Indirect Cost rate cannot claim the resulting indirect costs as a Cost Share contribution.                           \n8. A Recipient cannot claim \"unrecovered indirect costs\" as a Cost Share contribution.             \n9. 3rd party cost share/matching should be listed as an Other source.                                                                                                                                                                                                                                                                                                          "]
[]
["Organization             ","Cost Share Item/Description","Type (Cash or In Kind) ","Source","Total Project Cost Share Value ($)"]
["Example: Fellow Consortium Member","A fellow member of the consortium will be providing in-kind contributions worth $150,000 over 4 years to assist with overall strategic guidance and program management assistance should their award be granted.","In Kind","Other",{"v":150000,"d":"$150,000.00"}]
["Example: Local Non-Profit Training Center","The local non-profit training center will provide $250,000 of in kind contributions over 2 years through staff time, facility use, and services to support the successful implementation of a biweekly digital literacy course aimed a local youth aged 18-25.   ","In Kind","Other",{"v":250000,"d":"$250,000.00"}]
[{"$nulls":4},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"$0.00"}]
[{"$nulls":4},{"v":0,"d":"$0.00"}]
["State",{"$nulls":3},{"$f":"SUMIF(D8:D16,A17,E8:E16)","v":{"v":0,"d":"$0.00"}}]
["Local",{"$nulls":3},{"$f":"SUMIF(D8:D16,A18,E8:E16)","v":{"v":0,"d":"$0.00"}}]
["Other",{"$nulls":3},{"$f":"SUMIF(D8:D16,A19,E8:E16)","v":{"v":0,"d":"$0.00"}}]
["SUBTOTAL RECIPIENT COST SHARE/MATCHING ",{"$nulls":3},{"$f":"SUM(E17:E19)","v":{"v":0,"d":"$0"}}]
[]
["Cost Share/Matching by Cost Category"]
[null,"State","Local","Other","Total per Cost Category"]
["a. Personnel",{"$f":"SUMIF('a. Personnel'!$U$11:$U$20,'i. Cost Sharing-Matching'!B23,'a. Personnel'!$S$11:$S$20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('a. Personnel'!$U$11:$U$20,'i. Cost Sharing-Matching'!C23,'a. Personnel'!$S$11:$S$20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('a. Personnel'!$U$11:$U$20,'i. Cost Sharing-Matching'!D23,'a. Personnel'!$S$11:$S$20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(B24:D24)","v":{"v":0,"d":"$0.00"}}]
["b. Travel",{"$f":"SUMIF('b. Travel'!$X$8:$X$27,'i. Cost Sharing-Matching'!B23,'b. Travel'!$V$8:$V$27)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('b. Travel'!$X$8:$X$27,'i. Cost Sharing-Matching'!C23,'b. Travel'!$V$8:$V$27)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('b. Travel'!$X$8:$X$27,'i. Cost Sharing-Matching'!D23,'b. Travel'!$V$8:$V$27)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(B25:D25)","v":{"v":0,"d":"$0.00"}}]
["c. Equipment",{"$f":"SUMIF('c. Equipment'!$P$8:$P$17,'i. Cost Sharing-Matching'!B23,'c. Equipment'!$N$8:$N$17)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('c. Equipment'!$P$8:$P$17,'i. Cost Sharing-Matching'!C23,'c. Equipment'!$N$8:$N$17)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('c. Equipment'!$P$8:$P$17,'i. Cost Sharing-Matching'!D23,'c. Equipment'!$N$8:$N$17)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
["d. Supplies",{"$f":"SUMIF('d. Supplies'!$P$9:$P$16,'i. Cost Sharing-Matching'!B23,'d. Supplies'!$N$10:$N$16)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('d. Supplies'!$P$9:$P$16,'i. Cost Sharing-Matching'!C23,'d. Supplies'!$N$10:$N$16)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('d. Supplies'!$P$9:$P$16,'i. Cost Sharing-Matching'!D23,'d. Supplies'!$N$10:$N$16)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
["e1. Contractual",{"$f":"SUMIF('e1. Contractual'!$N$8:$N$16,'i. Cost Sharing-Matching'!B23,'e1. Contractual'!$L$8:$L$16)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('e1. Contractual'!$N$8:$N$16,'i. Cost Sharing-Matching'!C23,'e1. Contractual'!$L$8:$L$16)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('e1. Contractual'!$N$8:$N$16,'i. Cost Sharing-Matching'!D23,'e1. Contractual'!$L$8:$L$16)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
["e2. Subawards",{"$f":"SUMIF('e2. Subawards'!$Q$8:$Q$22,'i. Cost Sharing-Matching'!B23,'e2. Subawards'!$M$8:$M$22)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('e2. Subawards'!$Q$8:$Q$22,'i. Cost Sharing-Matching'!C23,'e2. Subawards'!$M$8:$M$22)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('e2. Subawards'!$Q$8:$Q$22,'i. Cost Sharing-Matching'!D23,'e2. Subawards'!$M$8:$M$22)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
["f. Construction",{"$f":"SUMIF('f. Construction'!$N$8:$N$20,'i. Cost Sharing-Matching'!B23,'f. Construction'!$L$8:$L$20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('f. Construction'!$N$8:$N$20,'i. Cost Sharing-Matching'!C23,'f. Construction'!$L$8:$L$20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('f. Construction'!$N$8:$N$20,'i. Cost Sharing-Matching'!D23,'f. Construction'!$L$8:$L$20)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
["g. Other",{"$f":"SUMIF('g. Other'!$N$8:$N$13,'i. Cost Sharing-Matching'!B23,'g. Other'!$L$8:$L$13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('g. Other'!$N$8:$N$13,'i. Cost Sharing-Matching'!C23,'g. Other'!$L$8:$L$13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('g. Other'!$N$8:$N$13,'i. Cost Sharing-Matching'!D23,'g. Other'!$L$8:$L$13)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
["h. Indirect",{"$f":"SUMIF('h. Indirect'!$N$8:$N$15,'i. Cost Sharing-Matching'!B23,'h. Indirect'!$L$8:$L$15)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('h. Indirect'!$N$8:$N$15,'i. Cost Sharing-Matching'!C23,'h. Indirect'!$L$8:$L$15)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF('h. Indirect'!$N$8:$N$15,'i. Cost Sharing-Matching'!D23,'h. Indirect'!$L$8:$L$15)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
["Total Per Cost Share/Matching Source",{"$f":"SUM(B24:B32)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(C24:C32)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[]
["TOTAL COST SHARE/MATCHING",{"$nulls":3},{"$f":"SUM(E20,E24:E32)","v":{"v":0,"d":"$0"}}]
[]
["Additional Explanation (as needed):\n\n\n"]

{"sheet":"j. Program Income","index":12,"n_rows":9,"n_cols":2,"rows_kept":9,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[8,0,8,2]]}
[]
["J. Program Income"]
["INSTRUCTIONS\n1. Program Income: Non-Federal entities are encouraged to earn income to defray program costs where appropriate. Program income means gross income earned by the non-Federal entity that is directly generated by a supported activity or earned as a result of the Federal award during the period of performance except as provided in 2 CFR 200.307.  Program income includes but is not limited to income from fees for services performed, the use or rental or real or personal property acquired under Federal awards, the sale of commodities or items fabricated under a Federal award, license fees and royalties on patents and copyrights, and principal and interest on loans made with Federal award funds. Interest earned on advances of Federal funds is not program income. Except as otherwise provided in Federal statutes, regulations, or the terms and conditions of the Federal award, program income does not include rebates, credits, discounts, and interest earned on any of them.\n2. Please complete the questions below using the dropdown menu.\n                                                                                                                                                                                       "]
[]
["Question","Response"]
["1. Does the recipient anticipate earning Program Income as a result of this grant program? If the answer is yes, please answer question 2."]
["2. How does the recipient elect to use any earned Program Income? Please refer to 2 CFR 200.307 for the definition of each approach."]
[]
["Additional Explanation (as needed):"]

{"sheet":"List","index":13,"n_rows":8,"n_cols":26,"rows_kept":8,"hidden":true}
["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)",{"$nulls":3},"Deployment"]
["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",{"$nulls":3},"Other"]
["Annual",{"$nulls":7},"Equipment",{"$nulls":3},"Cost Sharing or Matching",{"$nulls":5},"TBD","Combination of both Cash & In Kind (explanation is provided under Additional Explanation)","Local","Consolidated Appropriations Act (CAA)"]
[{"$nulls":8},"Supplies",{"$nulls":3},"Other (explanation is provided under Additional Explanation)",{"$nulls":6},"TBD","Other","ReConnect Loan and Grant Program"]
[{"$nulls":8},"Contractual",{"$nulls":11},"Combination","Families First Coronavirus Response Act (FFCRA)"]
[{"$nulls":8},"Construction",{"$nulls":11},"TBD","TBD"]
[{"$nulls":8},"Subaward"]
[{"$nulls":8},"Other"]