{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Help – SAMPLE Workbook","Description of Project Sites","US States and Terr","Sites Copy","Rurality Calculation","Economic Need Calculation","Match Calculation","Budget","Budget Copy"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Help – SAMPLE Workbook","index":0,"n_rows":90,"n_cols":2,"rows_kept":90,"cut":false,"hidden":false,"merged":[[1,1,3,1]]}
[]
[null,"How to Navigate the SAMPLE Worksheets to Input Project Details"]
[]
[]
[null,"The SAMPLE Workbook consists of five SAMPLE Worksheets (1) Description of Project Sites, (2) Rurality Calculation, (3) Economic Need Calculation, (4) Match Calculation and (5) Line-Item Budget. The use of the workbook can assist applicants with submitting complete and consistent project information. For the best results, complete each tab, beginning with Description of Project Sites."]
[]
[null,"If there are any questions regarding the context of required data, please refer to the FY2026 Application Guide and your Local General Field Representative."]
[]
[null,"It is strongly recommended that the SAMPLE Workbook be submitted as a single Excel file. \nDo not submit worksheets as separate documents, and do not convert the worksheets to PDF or Word format."]
[]
[]
[]
[null,"SAMPLE Worksheets"]
[null,"Description of Project Sites"]
[null,"Rurality Calculation"]
[null,"Economic Need Calculation"]
[null,"Match Calculation"]
[null,"Budget"]
[]
[]
[null,"Completing the Description of Project Sites Tab"]
[null,"1. Enter the details for each participating hub, end user, or hub/end-user site."]
[null,"2. Add or remove rows as needed using the Insert Row or Delete Row buttons at the top of the worksheet."]
[]
[null,"                      • “Insert Row\" will add the specified number of rows below the active cell."]
[null,"                      • “Delete Row” allows you to specify the number of rows you would like to remove and select whether you would like to delete rows above or below the active cell."]
[]
[null,"Refer to Section B and Appendix A of the Application Guide for additional guidance."]
[]
[]
[]
[null,"Completing the Rurality Calculation Tab"]
[null,"Columns A–D populate automatically based on the entries in the Description of Project Sites tab."]
[null,"Note:  Sites cannot be added or deleted on this tab. All changes must be made on the Description of Project Sites tab."]
[null,"                             1.     Enter the following for each site:"]
[null,"                                                      • Census Population (Column E)"]
[null,"                                                      • Is Site Contiguous to a City or Town > 50,000? (Column F)"]
[null,"                                                      • Name of Urban City or Town (Column G), if applicable "]
[]
[null,"                               2.   The worksheet will calculate the Rurality Score (Column H)."]
[null,"                               3.   Calculate and enter the Project’s Estimated Rurality Score."]
[]
[null,"Refer to Section D, pages 14-16, and Appendix B  of the Application Guide for additional guidance."]
[]
[]
[]
[null,"Completing the Economic Need Calculation Tab"]
[null,"Columns A–D populate automatically from the Description of Project Sites tab"]
[null,"Note:  Sites cannot be added or deleted on this tab. All changes must be made on the Description of Project Sites tab."]
[null,"                             1.   Enter SAIPE data (Column E) according to the FY2026 Application Guide"]
[null,"                             2.   The worksheet will calculate the Economic Score (Column F)."]
[null,"                             3.   Calculate and enter the Project's Economic Need Score."]
[]
[null,"Refer to Section D, pages 17-18, and Appendix B of the Application Guide for additional guidance."]
[]
[]
[]
[null,"Completing the Match Calculation Tab"]
[null,"Refer to Section E, pages 20-23, of the Application Guide for additional guidance."]
[null,"                   The worksheet will automatically populate: (non-editable cells)"]
[null,"                            •  Total Proposed Matching Contribution (from Cash and In Kind amounts)"]
[null,"                            •  Total DLT Grant Request (after the Budget tab entry is completed)"]
[null,"                            •  Match Percent (based on the above values)"]
[]
[null,"Note: If additional rows are needed, right‑click an Excel row and choose Insert from the list."]
[]
[]
[]
[null,"Completing the Budget Tab"]
[null,"Refer to Section F, pages 23-24, of the Application Guide for additional guidance"]
[]
[null,"                         1.  Enter the following information:"]
[null,"                                •   Site Number (Column B)"]
[null,"                                •   Description of Equipment (Column D)"]
[null,"                                •   Unit Cost (Column E)"]
[null,"                                •   Number of Units (Column F) "]
[null,"Note:  Rows may be added or deleted using the “Insert Row” and/or “Delete Row” buttons found on the top of the worksheet."]
[]
[null,"                                •  \"Insert Row\"  will add the specified number of rows below the active cell."]
[null,"                                •  \"Delete Row\"  allows you to specify the number of rows you would like to remove,\n                                     and select whether you would like to delete rows above or below the active cell"]
[null,"                         2.  The worksheet will automcatically calculate the following: (non-editabele cells)"]
[]
[null,"                                •  Site Name (Column C)"]
[null,"                                • Extended Costs (Column G)"]
[null,"                                • Total Grant and Cash Match"]
[null,"                                • Total In-Kind"]
[null,"                                • Overall DLT Project Budget"]
[null,"                                • Less Proposed Cash Match (from Match Calculation tab)"]
[null,"                                • Less In-Kind Match"]
[null,"                                • DLT Grant Request"]

{"sheet":"Description of Project Sites","index":1,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9]]}
["SAMPLE Description of Project Sites Worksheet"]
["Applicant's Legal Name"]
["Site Number","Site Name","Site Designation \n(Hub; End-User;Hub/End-User)  \n (select from drop-down)","Street Address","Town","County","State","5 Digit ZIP","Congressional District","# Rural Residents Served at each \nHub/End-User or End-User Site"]
[{"$f":"ROW()-3","v":1}]

{"sheet":"US States and Terr","index":2,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Alabama"]
[null,"Alaska"]
[null,"Arizona"]
[null,"Arkansas"]
[null,"California"]
[null,"Colorado"]
[null,"Connecticut"]
[null,"Delaware"]
[null,"Florida"]
[null,"Georgia"]
[null,"Hawaii"]
[null,"Idaho"]
[null,"Illinois"]
[null,"Indiana"]
[null,"Iowa"]
[null,"Kansas"]
[null,"Kentucky"]
[null,"Louisiana"]
[null,"Maine"]
[null,"Maryland"]
[null,"Massachusetts"]
[null,"Michigan"]
[null,"Minnesota"]
[null,"Mississippi"]
[null,"Missouri"]
[null,"Montana"]
[null,"Nebraska"]
[null,"Nevada"]
[null,"New Hampshire"]
[null,"New Jersey"]
[null,"New Mexico"]
[null,"New York"]
[null,"North Carolina"]
[null,"North Dakota"]
[null,"Ohio"]
[null,"Oklahoma"]
[null,"Oregon"]
[null,"Pennsylvania"]
[null,"Rhode Island"]
[null,"South Carolina"]
[null,"South Dakota"]
[null,"Tennessee"]
[null,"Texas"]
[null,"Utah"]
[null,"Vermont"]
[null,"Virginia"]
[null,"Washington"]
[null,"West Virginia"]
[null,"Wisconsin"]
[null,"Wyoming"]
[null,"American Samoa"]
[null,"Guam"]
[null,"Northern Mariana Islands"]
[null,"Puerto Rico"]
[null,"U.S. Virgin Islands"]

{"sheet":"Sites Copy","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,0,0,9],[1,0,1,9]]}
["SAMPLE Description of Project Sites Worksheet"]
["Applicant's Legal Name"]
["Site Number","Site Name","Site Designation \n(Hub; End-User;Hub/End-User)  \n (select from drop-down)","Street Address","Town","County","State","5 Digit ZIP","Congressional District","# Rural Residents Served at each \nHub/End-User or End-User Site"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]

{"sheet":"Rurality Calculation","index":4,"n_rows":11,"n_cols":28,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,4,9,5],[0,0,0,7],[1,0,1,7],[5,2,5,3],[4,5,4,6]]}
["SAMPLE Rurality Calculation Worksheet"]
[{"$f":"'Description of Project Sites'!A2","v":"Applicant's Legal Name"}]
["Site Number","Site Name","Site Designation\n(Hub, End-User, Hub/End-User)","Town or Place Name","Census Population","Is the Site in a Town contiguous to City or Town > 50,000?","Name of Urban City or Town \n(if Yes, in col. F )","Rurality Score"]
[{"$f":"IF('Description of Project Sites'!A4=\"\",\"\", 'Description of Project Sites'!A4)","v":1},{"$f":"IF('Description of Project Sites'!B4=\"\",\"\", 'Description of Project Sites'!B4)","v":""},{"$f":"IF('Description of Project Sites'!C4=\"\",\"\", 'Description of Project Sites'!C4)","v":""},{"$f":"IF('Description of Project Sites'!E4=\"\",\"\", 'Description of Project Sites'!E4)","v":""},null,null,null,{"$f":"IF(ISBLANK($E4),\"\",IF(AND($E4=\"Census Rural\",$F4=\"Yes\"),20,IF(AND($E4=\"Census Rural\",$F4=\"No\"),40,IF(AND($E4<=20000,$F4=\"Yes\"),0,IF(AND($E4>20000,$F4=\"No\"),20,_xlfn.IFS($E4<5001,40,$E4<10001,30,$E4<20001,20,$E4>=20001,0))))))","v":""}]
[null,null,null,null,null,"Project's Estimated Rurality Score"]
[null,null,"Scoring Table"]
[null,null,"Census Population","Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($C$4:$C$4995,\"End-User\")+COUNTIF($C$4:$C$4995,\"Hub/End-User\")+COUNTIF($C$4:$C$4995,\"Hub(proxy) serving non-fixed end-users\")","v":0}]
[null,null,"EXCEPTIONALLY RURAL AREA - 5,000 or less",40,null,null,null,null,null,{"$f":"COUNTIF($C$4:$C$4995,\"End-User\")+COUNTIF($C$4:$C$4995,\"Hub/End-User\")+COUNTIF($C$4:$C$4995,\"Hub(proxy) serving non-fixed end-users\")","v":0}]
[null,null,"RURAL AREA - 5,001-10,000",30]
[null,null,"MID-RURAL AREA - 10,001-20,000",20]
[null,null,"URBAN AREA - Over 20,000 or\n Adjacent to City > 50,000",0]

{"sheet":"Economic Need Calculation","index":5,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[28,0,28,7],[0,0,0,5],[1,0,1,5],[12,9,12,11],[13,9,13,11],[5,1,5,2]]}
["SAMPLE Economic Need Calculation Worksheet"]
[{"$f":"'Description of Project Sites'!A2","v":"Applicant's Legal Name"}]
["Site Number","Site Name","Site Designation \n(Hub; End-User; Hub/End-User)","County","SAIPE\nPercent Poverty, All Ages","Economic Need Score"]
[{"$f":"IF('Description of Project Sites'!A4=\"\",\"\", 'Description of Project Sites'!A4)","v":1},{"$f":"IF('Description of Project Sites'!B4=\"\",\"\", 'Description of Project Sites'!B4)","v":""},{"$f":"IF('Description of Project Sites'!C4=\"\",\"\", 'Description of Project Sites'!C4)","v":""},{"$f":"IF('Description of Project Sites'!F4=\"\",\"\", 'Description of Project Sites'!F4)","v":""},null,{"$f":"IF($E4=\"\",\"\",IF($E4>=0.3,30,IF($E4>=0.2,20,IF($E4>=0.1,10,IF($E4<0.1,0)))))","v":""}]
[null,null,null,null,"Project's Estimated Economic Score"]
[null,"Scoring Table"]
[null,"SAIPE County Poverty Percentage:","Points"]
[null,"Poverty % < 10%",0,null,null,null,null,null,null,null,{"$f":"COUNTIF(C4:C4994,\"End-User\")+COUNTIF(C4:C4994,\"Hub/End-User\")+COUNTIF(C4:C4994,\"Hub(proxy) serving non-fixed end-users\")","v":0},{"$f":"SUM(SUMIF(C1:C4981,{\"*End-User*\",\"*Hub/End-User*\",\"*Hub(proxy) serving non-fxed end-users*\"},F1:F4981))","v":0}]
[null,"Poverty % 10%  ≥ but < 20%",10]
[null,"Poverty % ≥ 20%  but < 30%",20]
[null,"Poverty % ≥ 30%",30,null,"≥"]

{"sheet":"Match Calculation","index":6,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,3],[0,0,0,3]]}
["SAMPLE Match Calculation Worksheet"]
[{"$f":"'Description of Project Sites'!A2","v":"Applicant's Legal Name"}]
["Name of Entity Providing Donor \n(Documentation Letter from each donor must be provided)","Amount of Proposed Cash  ($)","Amount of Proposed In-Kind ($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1. Total Proposed Matching Contribution (must equal Line B + Line C in the Budget Worksheet)",{"$f":"SUM(B4:B30)","v":0},{"$f":"SUM(C4:C30)","v":0},{"$f":"B31+C31","v":0}]
["2. Total DLT Grant Request  (Must equal Line D in the Budget Worksheet)",null,null,{"$f":"Budget!G73","v":0}]
["Match Percent (Line 1 ÷ Line 2), must be at least 15% of Grant Request",null,null,{"$f":"IF(D31=0,\"\",ROUNDDOWN(D31/D32,4))","v":""}]

{"sheet":"Budget","index":7,"n_rows":74,"n_cols":8,"rows_kept":74,"cut":false,"hidden":false,"merged":[[68,0,68,5],[1,4,1,6],[1,0,1,2],[2,0,2,2],[56,0,56,6],[3,0,3,6],[55,0,55,5],[69,2,69,5],[70,2,70,5],[71,2,71,5],[72,2,72,5],[74,2,74,5]]}
[null,null,null,"SAMPLE Line-Item Budget Worksheet ",null,null,null,"Do Not Delete"]
[null,null,null,{"$f":"'Description of Project Sites'!A2","v":"Applicant's Legal Name"},null,null,null,"Do Not Delete"]
["     (Insert additional rows as needed)",null,null,null,null,null,null,"Do Not Delete"]
["Items being funded by Grant and Cash Match",null,null,null,null,null,null,"Do Not Delete"]
["Line Item #","Site Number","Site Name","Description of Equipment","Unit Cost","# of Units","Extended Costs","Do Not Delete"]
[{"$f":"ROW()-5","v":1},null,{"$f":"IF(B6=\"\",\"\",_xlfn.XLOOKUP(B6,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,{"$f":"E6*F6","v":0}]
[{"$f":"ROW()-5","v":2},null,{"$f":"IF(B7=\"\",\"\",_xlfn.XLOOKUP(B7,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,{"$f":"E7*F7","v":0}]
[3,null,{"$f":"IF(B8=\"\",\"\",_xlfn.XLOOKUP(B8,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[4,null,{"$f":"IF(B9=\"\",\"\",_xlfn.XLOOKUP(B9,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[5,null,{"$f":"IF(B10=\"\",\"\",_xlfn.XLOOKUP(B10,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[6,null,{"$f":"IF(B11=\"\",\"\",_xlfn.XLOOKUP(B11,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[7,null,{"$f":"IF(B12=\"\",\"\",_xlfn.XLOOKUP(B12,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[8,null,{"$f":"IF(B13=\"\",\"\",_xlfn.XLOOKUP(B13,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[9,null,{"$f":"IF(B14=\"\",\"\",_xlfn.XLOOKUP(B14,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[10,null,{"$f":"IF(B15=\"\",\"\",_xlfn.XLOOKUP(B15,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[11,null,{"$f":"IF(B16=\"\",\"\",_xlfn.XLOOKUP(B16,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[12,null,{"$f":"IF(B17=\"\",\"\",_xlfn.XLOOKUP(B17,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[13,null,{"$f":"IF(B18=\"\",\"\",_xlfn.XLOOKUP(B18,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[14,null,{"$f":"IF(B19=\"\",\"\",_xlfn.XLOOKUP(B19,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[15,null,{"$f":"IF(B20=\"\",\"\",_xlfn.XLOOKUP(B20,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[16,null,{"$f":"IF(B21=\"\",\"\",_xlfn.XLOOKUP(B21,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[17,null,{"$f":"IF(B22=\"\",\"\",_xlfn.XLOOKUP(B22,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[18,null,{"$f":"IF(B23=\"\",\"\",_xlfn.XLOOKUP(B23,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[19,null,{"$f":"IF(B24=\"\",\"\",_xlfn.XLOOKUP(B24,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[20,null,{"$f":"IF(B25=\"\",\"\",_xlfn.XLOOKUP(B25,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[21,null,{"$f":"IF(B26=\"\",\"\",_xlfn.XLOOKUP(B26,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[22,null,{"$f":"IF(B27=\"\",\"\",_xlfn.XLOOKUP(B27,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[23,null,{"$f":"IF(B28=\"\",\"\",_xlfn.XLOOKUP(B28,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[24,null,{"$f":"IF(B29=\"\",\"\",_xlfn.XLOOKUP(B29,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[25,null,{"$f":"IF(B30=\"\",\"\",_xlfn.XLOOKUP(B30,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[26,null,{"$f":"IF(B31=\"\",\"\",_xlfn.XLOOKUP(B31,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[27,null,{"$f":"IF(B32=\"\",\"\",_xlfn.XLOOKUP(B32,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,{"$f":"E32*F32","v":0}]
[28,null,{"$f":"IF(B33=\"\",\"\",_xlfn.XLOOKUP(B33,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[29,null,{"$f":"IF(B34=\"\",\"\",_xlfn.XLOOKUP(B34,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[30,null,{"$f":"IF(B35=\"\",\"\",_xlfn.XLOOKUP(B35,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[31,null,{"$f":"IF(B36=\"\",\"\",_xlfn.XLOOKUP(B36,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[32,null,{"$f":"IF(B37=\"\",\"\",_xlfn.XLOOKUP(B37,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[33,null,{"$f":"IF(B38=\"\",\"\",_xlfn.XLOOKUP(B38,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[34,null,{"$f":"IF(B39=\"\",\"\",_xlfn.XLOOKUP(B39,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[35,null,{"$f":"IF(B40=\"\",\"\",_xlfn.XLOOKUP(B40,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[36,null,{"$f":"IF(B41=\"\",\"\",_xlfn.XLOOKUP(B41,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[37,null,{"$f":"IF(B42=\"\",\"\",_xlfn.XLOOKUP(B42,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[38,null,{"$f":"IF(B43=\"\",\"\",_xlfn.XLOOKUP(B43,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[39,null,{"$f":"IF(B44=\"\",\"\",_xlfn.XLOOKUP(B44,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[40,null,{"$f":"IF(B45=\"\",\"\",_xlfn.XLOOKUP(B45,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[41,null,{"$f":"IF(B46=\"\",\"\",_xlfn.XLOOKUP(B46,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[42,null,{"$f":"IF(B47=\"\",\"\",_xlfn.XLOOKUP(B47,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[43,null,{"$f":"IF(B48=\"\",\"\",_xlfn.XLOOKUP(B48,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[44,null,{"$f":"IF(B49=\"\",\"\",_xlfn.XLOOKUP(B49,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[45,null,{"$f":"IF(B50=\"\",\"\",_xlfn.XLOOKUP(B50,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[46,null,{"$f":"IF(B51=\"\",\"\",_xlfn.XLOOKUP(B51,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[47,null,{"$f":"IF(B52=\"\",\"\",_xlfn.XLOOKUP(B52,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[48,null,{"$f":"IF(B53=\"\",\"\",_xlfn.XLOOKUP(B53,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[49,null,{"$f":"IF(B54=\"\",\"\",_xlfn.XLOOKUP(B54,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[50,null,{"$f":"IF(B55=\"\",\"\",_xlfn.XLOOKUP(B55,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
["Total Grant and Cash Match",null,null,null,null,null,{"$f":"SUM(INDEX(G:G,5):INDEX(G:G,ROW()-1))","v":0},"Do Not Delete"]
["Items being Funded by In-Kind",null,null,null,null,null,null,"Do Not Delete"]
["Line Item #","Site Number","Site Name","Description of Equipment","Unit Cost","# of Units","Extended Costs","Do Not Delete"]
[1,null,{"$f":"IF(B59=\"\",\"\",_xlfn.XLOOKUP(B59,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,{"$f":"E59*F59","v":0}]
[null,null,{"$f":"IF(B60=\"\",\"\",_xlfn.XLOOKUP(B60,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,{"$f":"E60*F60","v":0}]
[{"$f":"A60+1","v":1},null,{"$f":"IF(B61=\"\",\"\",_xlfn.XLOOKUP(B61,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,{"$f":"E61*F61","v":0}]
[2,null,{"$f":"IF(B62=\"\",\"\",_xlfn.XLOOKUP(B62,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[3,null,{"$f":"IF(B63=\"\",\"\",_xlfn.XLOOKUP(B63,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[4,null,{"$f":"IF(B64=\"\",\"\",_xlfn.XLOOKUP(B64,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[5,null,{"$f":"IF(B65=\"\",\"\",_xlfn.XLOOKUP(B65,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,{"$f":"E65*F65","v":0}]
[6,null,{"$f":"IF(B66=\"\",\"\",_xlfn.XLOOKUP(B66,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[7,null,{"$f":"IF(B67=\"\",\"\",_xlfn.XLOOKUP(B67,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
[8,null,{"$f":"IF(B68=\"\",\"\",_xlfn.XLOOKUP(B68,'Description of Project Sites'!$A:$A,'Description of Project Sites'!$B:$B))","v":""},null,null,null,0]
["Total In-Kind Match",null,null,null,null,null,{"$f":"_xlfn.LET(_xlpm.Acol,A:A,_xlpm.Gcol,G:G,_xlpm.hdr,IFERROR(_xlfn.XMATCH(\"*Items being funded by In-Kind*\",_xlpm.Acol,2),0),_xlpm.ftr,IFERROR(_xlfn.XMATCH(\"*Total In-kind match*\",_xlpm.Acol,2),0),_xlpm.startRow,_xlpm.hdr+2,_xlpm.endRow,_xlpm.ftr-1,IF(OR(_xlpm.hdr=0,_xlpm.ftr=0,_xlpm.startRow>_xlpm.endRow),0,SUM(INDEX(_xlpm.Gcol,_xlpm.startRow):INDEX(_xlpm.Gcol,_xlpm.endRow))))","v":0},"Do Not Delete"]
["A",null,"Overall DLT Project Budget (Sum of Total Grant & Cash Match and Total In-Kind Match)",null,null,null,{"$f":"G69+G56","v":0},"Do Not Delete"]
["B",null,"Less Proposed Cash Match (As documented on Match Calculation Worksheet)",null,null,null,{"$f":"'Match Calculation'!B31","v":0},"Do Not Delete"]
["C",null,"Less In-Kind Match ",null,null,null,{"$f":"G69","v":0},"Do Not Delete"]
["D",null,"DLT Grant Request (A-B-C)",null,null,null,{"$f":"ROUND(G70-(G71+G72),0)","v":0},"Do Not Delete"]
[null,null,null,null,null,"Grant to Match %                 (minimum of 15% required)",{"$f":"IF(G73=0,\"\",ROUNDDOWN((G71+G72)/G73,4))","v":""},"Do Not Delete"]

{"sheet":"Budget Copy","index":8,"n_rows":84,"n_cols":8,"rows_kept":84,"cut":false,"hidden":true,"merged":[[84,2,84,5],[55,0,55,5],[56,0,56,6],[79,2,79,5],[80,2,80,5],[81,2,81,5],[3,0,3,6],[1,0,1,2],[1,4,1,6],[2,0,2,2],[82,2,82,5]]}
[null,null,null,"SAMPLE Line-Item Budget Worksheet ",null,null,null,"Do Not Delete"]
[null,null,null,"Applicant's Legal Name",null,null,null,"Do Not Delete"]
["     (Insert additional rows as needed)",null,null,null,null,null,null,"Do Not Delete"]
["Items being funded by Grant and Cash Match",null,null,null,null,null,null,"Do Not Delete"]
["Line Item #","Site Number","Site Name","Description of Equipment","Unit Cost","# of Units","Extended Costs","Do Not Delete"]
[1,null,null,null,null,null,0]
[2,null,null,null,null,null,0]
[3,null,null,null,null,null,0]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
[21,null,null,null,null,null,0]
[22,null,null,null,null,null,0]
[23,null,null,null,null,null,0]
[24,null,null,null,null,null,0]
[25,null,null,null,null,null,0]
[26,null,null,null,null,null,0]
[27,null,null,null,null,null,0]
[28,null,null,null,null,null,0]
[29,null,null,null,null,null,0]
[30,null,null,null,null,null,0]
[31,null,null,null,null,null,0]
[32,null,null,null,null,null,0]
[33,null,null,null,null,null,0]
[34,null,null,null,null,null,0]
[35,null,null,null,null,null,0]
[36,null,null,null,null,null,0]
[37,null,null,null,null,null,0]
[38,null,null,null,null,null,0]
[39,null,null,null,null,null,0]
[40,null,null,null,null,null,0]
[41,null,null,null,null,null,0]
[42,null,null,null,null,null,0]
[43,null,null,null,null,null,0]
[44,null,null,null,null,null,0]
[45,null,null,null,null,null,0]
[46,null,null,null,null,null,0]
[47,null,null,null,null,null,0]
[48,null,null,null,null,null,0]
[49,null,null,null,null,null,0]
[50,null,null,null,null,null,0]
["Total Grant and Cash Match",null,null,null,null,null,0,"Do Not Delete"]
["Items being Funded by In-Kind",null,null,null,null,null,null,"Do Not Delete"]
["Line Item #","Site Number","Site Name","Description","Unit Cost","# of Units","Extended Costs","Do Not Delete"]
[1,null,null,null,null,null,0]
[2,null,null,null,null,null,0]
[3,null,null,null,null,null,0]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
[null,null,null,null,null,"Total In-Kind Match",0,"Do Not Delete"]
["A",null,"Overall DLT Project Budget (Sum of Total Grant & Cash Match and Total In-Kind Match)",null,null,null,0,"Do Not Delete"]
["B",null,"Less Proposed Cash Match (As documented on Match Calculation Worksheet)",null,null,null,0,"Do Not Delete"]
["C",null,"Less In-Kind Match ",null,null,null,0,"Do Not Delete"]
["D",null,"DLT Grant Request (A-B-C)",null,null,null,0,"Do Not Delete"]
[null,null,null,null,null,"Grant to Match %                 (minimum of 15% required)",null,"Do Not Delete"]