{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Start Here","Copy 1","Supplemental Sheet "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":7,"defined_names":197,"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":"Start Here","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,3,11,4],[6,3,6,4],[7,3,7,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[8,3,8,4],[9,3,9,4],[14,3,15,4],[17,3,18,4],[20,3,21,4],[20,1,21,1],[20,2,21,2],[14,1,15,1],[14,2,15,2],[17,1,18,1],[17,2,18,2]]}
[]
[null,"FRS Input Description","Enter Information Below"]
[null,"Designation  ",null,"Enter the RUS Designation assigned to the Entity or Project (e.g. DC0501 or DC1701-A61)"]
[null,"Legal Name:",null,"Enter the Legal Name of the Entity"]
[null,"Correspondence Address\n (Street or PO Box):\n",null,"Enter the Street Name or PO Box Number for the Entity's correspondence address "]
[null,"Correspondence Address\n(City, State & Zip Code)",null,"Enter the City, State and Zip Code for the Entity's correspondence address "]
[null,"Statement Number  ",null,"Enter the FRS Nnumber "]
[null,"Date Prepared ",null,"Enter the preparation date of the FRS"]
[null,"Financial Information \"As Of\" Date:  ",null,{"$f":"IF(C9=\"\",\"Enter the Last Date Books are Closed Through\",\"Input Completed\")","v":"Enter the Last Date Books are Closed Through"}]
[null,":  "]
[]
[null,"Title of Person Authorized to Sign FRS  ",null,{"$f":"IF(C12=\"\",\"Enter 'TITLE' of Person Authorized to Sign FRS\",\"Input Completed\")","v":"Enter 'TITLE' of Person Authorized to Sign FRS"}]
[]
[]
[null,{"$f":"CONCATENATE(\"To ENTER Data for FRS Number \",C7,\" Press Either the Regular or Continuation Sheet Button\")","v":"To ENTER Data for FRS Number  Press Either the Regular or Continuation Sheet Button"},"<==  Regular FRS Button  ","        Continuation Sheet Button"]
[]
[]
[null,{"$f":"CONCATENATE(\"To Print FRS Number \",C7,\" \")","v":"To Print FRS Number  "},"<=  Press Blue Button  ","Do not print until input is complete!"]
[]
[]
[null,"To Print Supplement Sheet","<=====  Press Red Button  ","Prints Continuation Sheet"]
[]
[]
[null,null,null,"Brings You Back To This Page -->"]
[]
[]
[null,"Do Not Enter Data Below "]
[null,{"$f":"COUNTA('Supplemental Sheet '!B16:C54,'Supplemental Sheet '!B55:C55)","v":3}]
[null,{"$f":"COUNT('Supplemental Sheet '!E55:H55,'Supplemental Sheet '!E16:H54,'Supplemental Sheet '!K16:K54,'Supplemental Sheet '!K55:K55)","v":5}]
[null,{"$f":"IF(SUM(B28:B29)<1,1,2)","v":2}]

{"sheet":"Copy 1","index":1,"n_rows":74,"n_cols":14,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,0,1,10],[25,6,25,7],[8,0,8,2],[8,3,8,4],[23,6,23,7],[11,8,11,9],[12,8,12,9],[13,6,13,7],[14,6,14,7],[8,5,8,10],[3,5,3,6],[3,7,3,8],[3,9,3,10],[5,5,5,10],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[6,5,6,10],[7,5,7,10],[15,1,15,2],[73,3,73,7],[50,6,50,9],[51,6,51,9],[41,6,41,7],[72,3,72,7],[42,6,42,7],[57,5,57,9],[54,1,54,3],[57,1,57,3],[46,2,47,2],[56,5,56,9],[46,6,46,9],[47,6,47,9],[72,8,72,10],[72,0,72,2],[55,1,55,3],[56,1,56,3],[70,0,70,4],[70,5,70,10],[67,3,67,4],[44,1,44,2],[45,1,45,2],[43,1,43,2],[52,0,52,10],[39,6,39,7],[10,8,10,9],[15,6,15,7],[32,1,32,2],[34,1,34,2],[30,1,30,2],[24,1,24,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[25,1,25,2],[27,1,27,2],[31,1,31,2],[23,1,23,2],[26,1,26,2],[28,1,28,2],[39,1,39,2],[13,8,13,9],[14,8,14,9],[32,6,32,7],[24,6,24,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[29,6,29,7],[30,6,30,7],[31,6,31,7],[16,1,16,2],[17,1,17,2],[19,1,19,2],[10,6,10,7],[11,6,11,7],[12,6,12,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[27,6,27,7],[28,6,28,7],[26,6,26,7],[53,1,53,3],[53,5,53,9],[54,5,54,9],[46,4,47,4],[34,6,34,7],[37,6,37,7],[38,6,38,7],[33,6,33,7],[35,6,35,7],[48,6,49,9],[40,6,40,7],[44,6,44,7],[40,1,40,2],[41,1,41,2],[42,1,42,2],[46,3,47,3],[46,5,47,5],[45,6,45,7],[43,6,43,7],[37,1,37,2],[38,1,38,2],[35,1,35,2],[36,1,36,2],[36,6,36,7]]}
["According to the Paperwork Reduction Act of 1995, an agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a valid OMB control number.  The valid OMB control number for this information collection is 0575-0023.  The time required to complete this information collection is estimated to average 2 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information"]
[]
["USDA-RUS",null,null,null,null,"FORM APPROVED OMB NO. 0572-0023"]
["FINANCIAL REQUIREMENT STATEMENT",null,null,null,null,"DESIGNATION",null,"STATEMENT NUMBER",null,"DATE PREPARED"]
[null,null,null,null,null,{"$f":"'Start Here'!C3","v":0},null,{"$f":"'Start Here'!C7","v":0},null,{"$f":"'Start Here'!C8","v":"00:00:00"}]
[null,null,null,null,null,"LEGAL NAME AND CORRESPONDENCE ADDRESS"]
["RUS USE ONLY",null,null,null,null,{"$f":"'Start Here'!C4","v":0}]
["DATE RECEIVED",null,null,"RUS NUMBER",null,{"$f":"'Start Here'!C5","v":0}]
[null,null,null,null,null,{"$f":"'Start Here'!C6","v":0}]
[]
[null,null,null,"AMOUNT ENCUMBERED",null,null,null,null,"RUS USE ONLY",null,"TOTAL"]
["APPROVED PURPOSES",null,null,"RUS USE ONLY","TOTAL","TOTAL","ADVANCES",null,"ADVANCES",null,"DISBURSEMENTS"]
["(Use Supplemental Sheets",null,null,"WITHHELD ON","APPROVED","ADVANCES","NOW",null,"CURRENTLY",null,"& CREDITS AS"]
["as necessary)",null,null,"CONTRACT","FOR ADVANCE","TO DATE","REQUESTED",null,"APPROVED",null,{"$f":"CONCATENATE(\"OF  \",UPPER(TEXT('Start Here'!C9,\"DD-MMM-YY\")))","v":"OF  00-JAN-00"}]
[null,null,null,"(1)","(2)","(3)","(4)",null,"(5)",null,"(6)"]
["1.","Construction"]
["a."]
["b."]
["c."]
["d."]
["e."]
["f."]
["g."]
["2.","Professional Services"]
["a."]
["b."]
["3.","Support Assets"]
["a."]
["b."]
["4.","General "]
["a."]
["b."]
["5.","Operating Funds"]
["6.","Debt Retirement"]
["7.","Acquisitions"]
["a."]
["b."]
["8.","Closed Budget - Audited"]
["9.","Subtotals-All Funds",null,{"$f":"SUM(D17:D38)","v":0},{"$f":"SUM(E17:E38)","v":0},{"$f":"SUM(F17:F38)","v":0},{"$f":"SUM(G17:G38)","v":0},{"$f":"SUM(H14:H38)+'Supplemental Sheet '!H53","v":0},{"$f":"SUM(I17:I38)","v":0},null,{"$f":"SUM(K17:K38)","v":0}]
["10.","Sale of Property"]
["11.","Other"]
["a."]
["b."]
["c."]
["12.","Sub-Total (Supplemental Sheet)",null,{"$f":"'Supplemental Sheet '!D55","v":0},{"$f":"'Supplemental Sheet '!E55","v":0},{"$f":"'Supplemental Sheet '!F55","v":0},{"$f":"'Supplemental Sheet '!G55","v":0},null,{"$f":"'Supplemental Sheet '!I55","v":0},null,{"$f":"'Supplemental Sheet '!K55","v":0}]
["a.","Net Totals ",null,{"$f":"SUM(D39:D45)","v":0},{"$f":"SUM(E39:E45)","v":0},{"$f":"SUM(F39:F45)","v":0},{"$f":"SUM(G39:G45)","v":0},{"$f":"SUM(H41:H45)","v":0},{"$f":"SUM(I39:I45)","v":0},null,{"$f":"SUM(K39:K45)","v":0},{"$f":"SUM(L41:L45)","v":0},null,{"$f":"SUM(N45:N45)","v":0}]
[null,null,"Total Amount Approved","Total Amount Under Note/Agreement","Total Amount Previously Advanced","Total Amount Advanced on this FRS","17. Cash Bal. Per General Ledger"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"18. Advance Not Deposited FRS ___\")","v":"18. Advance Not Deposited FRS ___"}]
["13.","RUS LOAN",null,null,null,null,"19. Other Adjustments (Specify)",null,null,null,null,null,null,{"$f":"N42+N46","v":0}]
["14.","RUS GRANT "]
["15.","OTHER",null,null,null,null,"20. Total Item 12,Col 6+17,18&19",null,null,null,{"$f":"SUM(K46:K50)","v":0}]
["16.","TOTAL",{"$f":"SUM(C49:C51)","v":0},{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},{"$f":"SUM(F49:F51)","v":0},"21. Funds Not Released"]
["UNENCUMBERED FUNDS (This Space For RUS Use Only)"]
[null,"Network & Access Equipment ",null,null,null,"Professional Services"]
[null,"Outside Plant",null,null,null,"Support Assets"]
[null,"Land & Buildings ",null,null,null,"General & Contingency"]
[null,"Towers",null,null,null,"Funds Not Deposited (CR)"]
[null,"Customer Premises Equipment ",null,null,null,"Total Unencumbered Funds ",null,null,null,null,{"$f":"E54+E55+E56+E57+E58+K54+K55+K56+K57","v":0},null,{"$f":"D46+E46+K58","v":0}]
["CERTIFICATION"]
["On behalf of the designated Awardee, I request that the amount set forth as \"Advances Now Requested\" (Item 12a, Col. 4 above) be advanced under the "]
["provisions of the applicable legal agreement.  I certify that the amount so requested is for a purpose or purposes for which funds have been approved"]
["for advance or for which approval is requested herewith; that the amount advanced will be deposited in a bank, which is a member of the FDIC;"]
["as directed by the applicable legal agreement; that the loan, grant, matching and/or other funds required to be deposited in such bank account"]
["will be disbursed only for these purposes and not to exceed the amounts approved for each purpose in Column (2) \"Total Approved for Advance\""]
["of the Financial Requirement Statements; that the cash balance shown hereon is the balance of the bank account of the general ledger as of"]
[null,{"$f":"'Start Here'!C9","v":"00:00:00"},null,"; and that the disbursements reported in Column (6) were made in the amounts stated for each purpose,"]
["all in accordance with the provisions of the applicable legal agreement."]
[]
[" "]
["SIGNATURE ",null,null,null,null,"TITLE (Authorized Representative of the Awardee)"]
[null,null,null,null,null,{"$f":"'Start Here'!C12","v":0}]
[]
["RUS FORM 481 (Rev. 06-21)",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"PAGE _1_ OF _\",'Start Here'!B30,\"_ PAGES \")","v":"PAGE _1_ OF _2_ PAGES "}]
["Expires 11/30/2022"]

{"sheet":"Supplemental Sheet ","index":2,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[25,1,25,2],[22,1,22,2],[24,1,24,2],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[24,6,24,7],[9,8,9,9],[11,8,11,9],[22,6,22,7],[4,5,4,10],[3,9,3,10],[5,5,5,10],[7,0,7,2],[7,3,7,4],[7,5,7,7],[4,0,4,4],[6,5,6,10],[12,6,12,7],[10,8,10,9],[14,6,14,7],[16,1,16,2],[17,1,17,2],[0,0,0,10],[19,1,19,2],[21,1,21,2],[23,1,23,2],[36,1,36,2],[18,1,18,2],[23,6,23,7],[3,5,3,6],[13,8,13,9],[3,7,3,8],[14,1,14,2],[15,1,15,2],[9,6,9,7],[10,6,10,7],[11,6,11,7],[13,6,13,7],[31,1,31,2],[1,0,1,4],[2,0,2,4],[3,0,3,4],[12,8,12,9],[2,5,2,6],[2,7,2,8],[2,9,2,10],[55,8,55,10],[55,0,55,2],[20,1,20,2],[30,6,30,7],[53,1,53,2],[25,6,25,7],[29,6,29,7],[28,6,28,7],[42,1,42,2],[29,1,29,2],[41,1,41,2],[54,1,54,2],[39,1,39,2],[27,1,27,2],[35,1,35,2],[44,1,44,2],[47,1,47,2],[52,1,52,2],[45,1,45,2],[37,1,37,2],[38,1,38,2],[36,6,36,7],[28,1,28,2],[50,1,50,2],[26,1,26,2],[26,6,26,7],[27,6,27,7],[43,1,43,2],[47,6,47,7],[46,1,46,2],[33,1,33,2],[34,1,34,2],[31,6,31,7],[40,1,40,2],[41,6,41,7],[40,6,40,7],[39,6,39,7],[32,1,32,2],[38,6,38,7],[37,6,37,7],[30,1,30,2],[51,1,51,2],[48,1,48,2],[49,1,49,2],[35,6,35,7],[34,6,34,7],[33,6,33,7],[32,6,32,7],[42,6,42,7],[56,3,56,7],[49,6,49,7],[50,6,50,7],[52,6,52,7],[51,6,51,7],[55,3,55,7],[43,6,43,7],[53,6,53,7],[54,6,54,7],[45,6,45,7],[44,6,44,7],[48,6,48,7],[46,6,46,7]]}
[]
["USDA-RUS",null,null,null,null,"FORM APPROVED OMB NO. 0572-0023"]
["FINANCIAL REQUIREMENT STATEMENT",null,null,null,null,"DESIGNATION",null,"STATEMENT NUMBER",null,"DATE PREPARED"]
["SUPPLEMENTAL SHEET",null,null,null,null,{"$f":"'Start Here'!C3","v":0},null,{"$f":"'Start Here'!C7","v":0},null,{"$f":"'Start Here'!C8","v":"00:00:00"}]
[null,null,null,null,null,"LEGAL NAME AND CORRESPONDENCE ADDRESS"]
["RUS USE ONLY",null,null,null,null,{"$f":"'Start Here'!C4","v":0}]
["DATE RECEIVED",null,null,"RUS NUMBER",null,{"$f":"'Start Here'!C5","v":0}]
[{"$f":"'Copy 1'!A9","v":"00:00:00"},null,null,{"$f":"'Copy 1'!D9","v":0},null,{"$f":"'Start Here'!C6","v":0}]
[]
[null,null,null,"AMOUNT ENCUMBERED",null,null,null,null,"RUS USE ONLY",null,"TOTAL"]
["APPROVED PURPOSES",null,null,"RUS USE ONLY","TOTAL","TOTAL","ADVANCES",null,"ADVANCES",null,"DISBURSEMENTS"]
["(Use Supplemental Sheets",null,null,"WITHHELD ON","APPROVED","ADVANCES","NOW",null,"CURRENTLY",null,"& CREDITS AS"]
["as necessary)",null,null,"CONTRACT","FOR ADVANCE","TO DATE","REQUESTED",null,"APPROVED",null,{"$f":"CONCATENATE(\"OF  \",UPPER(TEXT('Start Here'!C9,\"MMM-YY\")))","v":"OF  JAN-00"}]
[null,null,null,"(1)","(2)","(3)","(4)",null,"(5)",null,"(6)"]
["1.","Construction (cont'd)"]
["h."]
["i."]
["j."]
["k."]
["l."]
["m."]
["n."]
["o."]
["p."]
["q."]
["r."]
["s."]
["t."]
["u."]
["v."]
["w."]
["x."]
["y."]
["z."]
["2.","Professional Services (cont'd)"]
["c."]
["d."]
["e."]
["f."]
["g."]
["h."]
["i."]
["j."]
["k."]
["l."]
["m."]
["3.","Support Assets (cont'd)"]
["c."]
["d."]
["e."]
["f."]
["f."]
["g."]
["h."]
[" ","SUB-TOTAL",null,{"$f":"SUM(D16:D54)","v":0},0,0,{"$f":"SUM(G16:G54)","v":0},0,0,0,0]
["RUS FORM 481 (Rev. 06-21)",null,null,null,null,null,null,null,"PAGE   2   OF   2   PAGES  "]
["Expires 11/30/2022"]