{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":332,"n_cols":11,"rows_kept":332,"cut":false,"hidden":false,"merged":[[47,0,47,1],[3,8,3,9]]}
["                                                                    USDA - RUS",null,"Title  of  Information  Document",null,null,null,null,null,"OMB  No."]
[null,null,"Water and Waste Loan and Grant Program",null,null,null,null,null,null,"0572-0121"]
[" SUMMARY  OF  INFORMATION  COLLECTION",null,"7 CFR 1780",null,null,null,null,null,"Date  Prepared"]
[null,null," ",null,null,null,null,null,2021]
[" INSTRUCTIONS:"," ",null,null,">","(f)  TOTAL",null,"(h)  TOTAL",null,"(k)  TOTAL"]
["Use this form when a single information collection document involves multiple reporting and                  ",null,null,null,">","-","= (e)  Average","-","= (g)  Average","-","= (j)  Average"]
["  recordkeeping requirements.  ",null,null,null,">","(d)  TOTAL",null,"(f)  TOTAL",null,"(i)  TOTAL"]
["         IDENTIFICATION  OF  REPORTING  AND  RECORDKEEPPING  REQUIREMENTS",null,null,null,null,null,"ANNUAL  BURDEN"]
[null,null,"FORM",null,null,"REPORTS",null,null,null,"RECORDS"]
[null,null,"NO(s)","NO.  OF","NO.  OF","TOTAL","HOURS","TOTAL","NO.  OF","ANNUAL","TOTAL"]
["SECTION  OF",null,"(If  \"none\"","RESPON-","RESPONSES","ANNUAL","PER","HOURS","RECORD-","HOURS  PER","RECORD-"]
["REGULATIONS","DESCRIPTION","so  state)","DENTS","PER","RESPONSES","RESPONSE","(Col.  f  &  g)","KEEPERS","RECORD-","KEEPING"]
[null,null,null,null,"RESPON-","(Col.  d  &  e)",null,null,null,"KEEPER","HOURS"]
[null,null,null,null,"DENT",null,null,null,null,null,"(Col.  i  &  j)"]
["(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)","(j)","(k)"]
[]
[null,"NON-FORM BURDEN-(Under this collection 0572-0121)"]
[null,"Application/Eligibility: (uses application data)"]
["1780.1(d)","Documentation of Income Survey","Written",163,1,{"$f":"D19*E19","v":163},8,{"$f":"F19*G19","v":1304}]
[null,"      7 CFR 1777-Section 306C (0572-0109)",null,6,1,{"$f":"SUM(D20*E20)","v":6},8,{"$f":"SUM(F20*G20)","v":48}]
[null,"     7 CFR 1778-ECWAG (0572-0110)",null,9,1,{"$f":"D21*E21","v":9},8,{"$f":"F21*G21","v":72}]
[]
["1780.1(f)","Relationship or association with RUS employees","Written",817,1,{"$f":"SUM(D23*E23)","v":817},0.25,{"$f":"SUM(F23*G23)","v":204.25}," "," "," "]
[null,"      7 CFR 1777-Section 306C (0572-0109)",null,30,1,{"$f":"D24*E24","v":30},0.25,{"$f":"F24*G24","v":7.5}]
[null,"     7 CFR 1778-ECWAG (0572-0110)",null,49,1,{"$f":"D25*E25","v":49},0.25,{"$f":"F25*G25","v":12.25}]
[null,null,null,null,null,"  ",null," ",null,null," "]
["1780.7(d) &","Statement on availability to obtain credit elsewhere","Written",817,1,{"$f":"SUM(D27*E27)","v":817},1,{"$f":"SUM(F27*G27)","v":817}," "," "," "]
["1780.33 (d)","      7 CFR 1777-Section 306C",null,30,1,{"$f":"D28*E28","v":30},1,{"$f":"F28*G28","v":30}]
[null,"     7 CFR 1778-ECWAG",null,49,1,{"$f":"D29*E29","v":49},1,{"$f":"F29*G29","v":49}]
[]
["1780.11(a)(2)","Notification of service statement","Written",163,1,{"$f":"SUM(D31*E31)","v":163},1,{"$f":"SUM(F31*G31)","v":163}]
[null,"      7 CFR 1777-Colonias",null,6,1,{"$f":"D32*E32","v":6},1,{"$f":"F32*G32","v":6}," "," "," "]
[null,"     7 CFR 1778-ECWAG",null,9,1,{"$f":"D33*E33","v":9},1,{"$f":"F33*G33","v":9}]
[]
["1780.14(a)","Security- Public Bodies- General Obligation and Revenue Bonds","Written",517,1,{"$f":"D35*E35","v":517},4,{"$f":"F35*G35","v":2068}]
[null,"      7 CFR 1777-Colonias",null,0,1,0,4,0]
[null,"     7 CFR 1778-ECWAG",null,0,1,{"$f":"SUM(D37*E37)","v":0},4,{"$f":"SUM(F37*G37)","v":0}]
[]
["1780.14(b)","Security- Not-For-Profit- Liens on property and Financing Stmt.","Written",68,1,{"$f":"SUM(D39*E39)","v":68},4,{"$f":"SUM(F39*G39)","v":272}]
[null,"      7 CFR 1777-Colonias",null,0,1,{"$f":"D40*E40","v":0},4,{"$f":"F40*G40","v":0}]
[null,"     7 CFR 1778-ECWAG",null,0,1,{"$f":"D41*E41","v":0},4,{"$f":"F41*G41","v":0}]
[]
[1780.19,"Public Information","Written",817,1,{"$f":"SUM(D43*E43)","v":817},2,{"$f":"SUM(F43*G43)","v":1634}]
[null,"      7 CFR 1777-Colonias",null,30,1,{"$f":"D44*E44","v":30},2,{"$f":"F44*G44","v":60}]
[null,"     7 CFR 1778-ECWAG",null,49,1,{"$f":"D45*E45","v":49},2,{"$f":"F45*G45","v":98},{"$f":"SUM(H44:H45+H32:H33+H28:H29+H24:H25+H20:H21)","v":391.75}]
[null,"SUBTOTAL ",null,null,null,{"$f":"SUM(F19:F45)","v":3629},null,{"$f":"SUM(H19:H45)","v":6854},{"$f":"SUM(I23:I45)","v":391.75}," ",{"$f":"SUM(K23:K45)","v":0}]
[null,"TOTAL OF ALL PAGES",null,null,null,{"$f":"SUM(F46,F84,F117,F151,F184,F216)","v":47782},null,{"$f":"SUM(H46,H84,H117,H151,H184,H216)","v":162083},{"$f":"SUM(I216)","v":14000},null,{"$f":"SUM(K216)","v":1120}]
["TOTAL - Columns \"F\" and \"I\" = OMB 83I, 13 b;                                                                                                                                      Columns \"H\" and \"K\" = OMB 83I, 13c",null,null,null,null,{"$f":"SUM(F47,I47)","v":61782},null,{"$f":"SUM(H47,K47)","v":163203}]
["1780.33(b)","Intergovernmental comments","Written",163,1,{"$f":"SUM(D49*E49)","v":163},1,{"$f":"SUM(F49*G49)","v":163}]
[null,"      7 CFR 1777-Colonias",null,6,1,{"$f":"D50*E50","v":6},1,{"$f":"F50*G50","v":6}]
[null,"     7 CFR 1778-ECWAG",null,9,1,{"$f":"D51*E51","v":9},1,{"$f":"F51*G51","v":9}]
[]
["1780.33(c)","Preliminary engineering report","Written",817,1,{"$f":"SUM(D53*E53)","v":817},40,{"$f":"SUM(F53*G53)","v":32680}]
[null,"      7 CFR 1777-Colonias",null,30,1,{"$f":"D54*E54","v":30},40,{"$f":"F54*G54","v":1200}]
[null,"     7 CFR 1778-ECWAG",null,49,1,{"$f":"D55*E55","v":49},40,{"$f":"F55*G55","v":1960}]
[]
["1780.33(e)","Supporting documentation","Written",817,1,{"$f":"SUM(D57*E57)","v":817},4,{"$f":"SUM(F57*G57)","v":3268}]
[null,"      7 CFR 1777-Colonias",null,30,1,{"$f":"D58*E58","v":30},4,{"$f":"F58*G58","v":120}]
[null,"     7 CFR 1778-ECWAG",null,49,1,{"$f":"D59*E59","v":49},4,{"$f":"F59*G59","v":196}]
[]
["1780.33(f)","Environmental Report","Written",817,1,{"$f":"D61*E61","v":817},24,{"$f":"F61*G61","v":19608}]
[null,"      7 CFR 1777-Colonias",null,30,1,30,24,720]
[null,"     7 CFR 1778-ECWAG",null,49,1,49,24,{"$f":"SUM(F63*G63)","v":1176}]
[]
["1780.33(h)(5)","Certification Regarding Debarment- Primary Covered Trans.","AD-1047",817,1,{"$f":"SUM(D65*E65)","v":817},0.25,{"$f":"SUM(F65*G65)","v":204.25}]
[null,"      7 CFR 1777-Colonias","(0505-0027)",30,1,{"$f":"D66*E66","v":30},0.25,{"$f":"F66*G66","v":7.5}]
[null,"     7 CFR 1778-ECWAG",null,49,1,{"$f":"D67*E67","v":49},0.25,{"$f":"F67*G67","v":12.25}]
[]
["1780.33(h)(5)","Certification Regarding Debarment- Lower Tier Covered Trans.","AD-1048",708,4,{"$f":"SUM(D69*E69)","v":2832},0.25,{"$f":"SUM(F69*G69)","v":708}]
[null,"      7 CFR 1777-Colonias","(0505-0027)",29,4,{"$f":"D70*E70","v":116},0.25,{"$f":"F70*G70","v":29}]
[null,"     7 CFR 1778-ECWAG",null,42,4,{"$f":"D71*E71","v":168},0.25,{"$f":"F71*G71","v":42}]
[]
["1780.33(h)(6)","Certification Regarding Drug-Free Workplace","AD-1049",517,1,{"$f":"SUM(D73*E73)","v":517},0.25,{"$f":"SUM(F73*G73)","v":129.25}]
[null,"      7 CFR 1777-Colonias","(0505-0027)",29,1,{"$f":"D74*E74","v":29},0.25,{"$f":"F74*G74","v":7.25}]
[null,"     7 CFR 1778-ECWAG",null,42,1,{"$f":"D75*E75","v":42},0.25,{"$f":"F75*G75","v":10.5}]
[]
["1780.33(h)(7)","Cert. for Contracts, Grants, and Loans (Regarding Lobbying)","RD 1940-Q",817,1,{"$f":"D77*E77","v":817},0.25,{"$f":"F77*G77","v":204.25}]
[null,"      7 CFR 1777-Colonias",null,30,1,30,0.25,{"$f":"SUM(F78*G78)","v":7.5}]
[null,"     7 CFR 1778-ECWAG",null,49,1,49,0.25,{"$f":"F79*G79","v":12.25}]
[]
["1780.33(h)(8)","Certification on Tying Arrangements","Written",817,1,{"$f":"D81*E81","v":817},0.25,{"$f":"SUM(F81*G81)","v":204.25}]
[null,"      7 CFR 1777-Colonias",null,30,1,30,0.25,{"$f":"F82*G82","v":7.5}]
[null,"     7 CFR 1778-ECWAG",null,49,1,49,0.25,12.25,{"$f":"SUM(H82:H83+H78:H79+H74:H75+H70:H71+H66:H67+H62:H63+H58:H59+H54:H55+H50:H51)","v":5535}]
[null,"SUBTOTAL ",null,null,null,{"$f":"SUM(F49:F83)","v":9258},null,{"$f":"SUM(H49:H83)","v":62704}]
[]
["1780.39(b)(1),(2)","Agreements for professional services","Written &",817,1,{"$f":"SUM(D86*E86)","v":817},6,{"$f":"SUM(F86*G86)","v":4902}]
[", and (3)","      7 CFR 1777-Colonias","RUS Bulletin",30,1,{"$f":"D87*E87","v":30},6,{"$f":"F87*G87","v":180}]
[null,"     7 CFR 1778-ECWAG","1780-7",49,1,{"$f":"D88*E88","v":49},6,{"$f":"F88*G88","v":294}]
[]
["1780.39(b)(4)","Contracts for other services","Written",205,1,{"$f":"SUM(D90*E90)","v":205},2,{"$f":"SUM(F90*G90)","v":410}]
[null,"      7 CFR 1777-Colonias",null,7,1,{"$f":"D91*E91","v":7},2,{"$f":"F91*G91","v":14}]
[null,"     7 CFR 1778-ECWAG",null,15,1,{"$f":"D92*E92","v":15},2,{"$f":"F92*G92","v":30}]
[]
["1780.39(c)(3)","User agreement","Written &",163,1,{"$f":"SUM(D94*E94)","v":163},4,{"$f":"SUM(F94*G94)","v":652}]
[null,"      7 CFR 1777-Colonias","RUS Bulletin",6,1,{"$f":"D95*E95","v":6},4,{"$f":"F95*G95","v":24}]
[null,"     7 CFR 1778-ECWAG","1780-9",9,1,{"$f":"D96*E96","v":9},4,{"$f":"F96*G96","v":36}]
[]
["1780.39(c)(5)(i)","Positive programs to encourage connections","Written",163,1,{"$f":"SUM(D98*E98)","v":163},4,{"$f":"SUM(F98*G98)","v":652}]
[null,"      7 CFR 1777-Colonias",null,6,1,{"$f":"D99*E99","v":6},4,{"$f":"F99*G99","v":24}]
[null,"     7 CFR 1778-ECWAG",null,9,1,{"$f":"D100*E100","v":9},4,{"$f":"F100*G100","v":36}]
[]
["1780.39(d)","Interim financing","Written",469,1,{"$f":"SUM(D102*E102)","v":469},4,{"$f":"SUM(F102*G102)","v":1876}]
[null,"      7 CFR 1777-Colonias",null,0,1,{"$f":"D103*E103","v":0},4,{"$f":"F103*G103","v":0}]
[null,"     7 CFR 1778-ECWAG",null,0,1,{"$f":"D104*E104","v":0},4,{"$f":"F104*G104","v":0}]
[]
["1780.39(g)(3)","Fidelity or employee dishonesty Bond","Written",586,1,{"$f":"SUM(D106*E106)","v":586},2,{"$f":"SUM(F106*G106)","v":1172}]
[null,"      7 CFR 1777-Colonias",null,0,1,{"$f":"D107*E107","v":0},2,{"$f":"F107*G107","v":0}]
[null,"     7 CFR 1778-ECWAG",null,0,1,{"$f":"D108*E108","v":0},2,{"$f":"F108*G108","v":0}]
[null,null,null,null,null,null,null,null," "," "," "]
["1780.39(g)(4)","Property insurance","Written",817,1,{"$f":"SUM(D110*E110)","v":817},1,{"$f":"SUM(F110*G110)","v":817}]
[null,"      7 CFR 1777-Colonias",null,30,1,{"$f":"D111*E111","v":30},1,{"$f":"F111*G111","v":30}]
[null,"     7 CFR 1778-ECWAG",null,49,1,{"$f":"D112*E112","v":49},1,{"$f":"F112*G112","v":49}]
[]
["1780.39(g)(5)","General Liability Insurance","Written",817,1,{"$f":"SUM(D114*E114)","v":817},1,{"$f":"SUM(F114*G114)","v":817}]
[null,"      7 CFR 1777-Colonias",null,30,1,{"$f":"D115*E115","v":30},1,{"$f":"F115*G115","v":30}]
[null,"     7 CFR 1778-ECWAG",null,49,1,{"$f":"D116*E116","v":49},1,{"$f":"F116*G116","v":49}]
[null,"SUBTOTAL ",null,null,null,{"$f":"SUM(F85:F116)","v":4326},null,{"$f":"SUM(H85:H116)","v":12094}]
["1780.39(g)(6)","Flood Insurance","Written",163,1,{"$f":"SUM(D118*E118)","v":163},1,{"$f":"SUM(F118*G118)","v":163}]
[null,"      7 CFR 1777-Colonias",null,6,1,{"$f":"D119*E119","v":6},1,{"$f":"F119*G119","v":6}]
[null,"     7 CFR 1778-ECWAG",null,9,1,{"$f":"D120*E120","v":9},1,{"$f":"F120*G120","v":9}]
[]
["1780.39(g)7)","Workman's compensation insurance","Written",817,1,{"$f":"SUM(D122*E122)","v":817},1,{"$f":"SUM(F122*G122)","v":817}]
[null,"      7 CFR 1777-Colonias",null,30,1,{"$f":"D123*E123","v":30},1,{"$f":"F123*G123","v":30}]
[null,"     7 CFR 1778-ECWAG",null,49,1,{"$f":"D124*E124","v":49},1,{"$f":"F124*G124","v":49}]
[]
[null,"Approval/Actions Following Obligation: (uses obligation data)"]
["1780.41(a)(5)","Letter of Conditions","Written",805,1,{"$f":"D127*E127","v":805},1,{"$f":"F127*G127","v":805}]
[null,"      7 CFR 1777-Colonias",null,33,1,{"$f":"D128*E128","v":33},1,33]
[null,"     7 CFR 1778-ECWAG",null,42,1,{"$f":"SUM(D129*E129)","v":42},1,{"$f":"SUM(F129*G129)","v":42}]
[]
["1780.44(f)","Evidence of other funds","Written",160,1,{"$f":"SUM(D131*E131)","v":160},1,{"$f":"SUM(F131*G131)","v":160}]
[null,"      7 CFR 1777-Colonias",null,6,1,{"$f":"D132*E132","v":6},1,{"$f":"F132*G132","v":6}]
[null,"     7 CFR 1778-ECWAG",null,9,1,{"$f":"D133*E133","v":9},1,{"$f":"F133*G133","v":9}]
[]
["1780.44(g)","Appraisal Report","Written",94,1,{"$f":"SUM(D135*E135)","v":94},2,{"$f":"SUM(F135*G135)","v":188}]
[null,"      7 CFR 1777-Colonias",null,0,1,{"$f":"D136*E136","v":0},2,{"$f":"F136*G136","v":0}]
[null,"     7 CFR 1778-ECWAG",null,0,1,{"$f":"D137*E137","v":0},2,{"$f":"F137*G137","v":0}]
[]
["1780.44(g)(1)(ii)","User Connections","Written",80,1,{"$f":"SUM(D139*E139)","v":80},4,{"$f":"SUM(F139*G139)","v":320}]
[null,"      7 CFR 1777-Colonias",null,3,1,{"$f":"D140*E140","v":3},4,{"$f":"F140*G140","v":12}]
[null,"     7 CFR 1778-ECWAG",null,6,1,{"$f":"D141*E141","v":6},4,{"$f":"F141*G141","v":24}]
[]
["1780.44(g)(3)","Water rights","Written",80,1,{"$f":"D143*E143","v":80},4,{"$f":"SUM(F143*G143)","v":320}]
[null,"      7 CFR 1777-Colonias",null,3,1,{"$f":"D144*E144","v":3},4,{"$f":"F144*G144","v":12}]
[null,"     7 CFR 1778-ECWAG",null,6,1,{"$f":"D145*E145","v":6},4,{"$f":"F145*G145","v":24}]
[]
["1780.44(g)(4)","Lease agreement","Written",80,1,{"$f":"SUM(D147*E147)","v":80},4,{"$f":"SUM(F147*G147)","v":320}]
[null,"      7 CFR 1777-Colonias",null,3,1,{"$f":"D148*E148","v":3},4,{"$f":"F148*G148","v":12}]
[null,"     7 CFR 1778-ECWAG",null,6,1,{"$f":"D149*E149","v":6},4,{"$f":"F149*G149","v":24}]
[]
[null,"SUBTOTAL ",null,null,null,{"$f":"SUM(F118:F149)","v":2490},null,{"$f":"SUM(H118:H149)","v":3385}]
["1780.45(a)(2)","Loan Resolution (Public Bodies)","RUS Bulletin 1780-27",517,1,{"$f":"SUM(D152*E152)","v":517},1,{"$f":"SUM(F152*G152)","v":517}]
[null,"      7 CFR 1777-Colonias",null,0,1,{"$f":"D153*E153","v":0},1,{"$f":"F153*G153","v":0}]
[null,"     7 CFR 1778-ECWAG",null,0,1,{"$f":"D154*E154","v":0},1,{"$f":"F154*G154","v":0}]
[]
["1780.45(a)(2)","Loan Resolution, Security Agreement","RUS Bulletin 1780-28",68,1,{"$f":"SUM(D156*E156)","v":68},1,{"$f":"SUM(F156*G156)","v":68}]
[null,"      7 CFR 1777-Colonias",null,0,1,{"$f":"D157*E157","v":0},1,{"$f":"F157*G157","v":0}]
[null,"     7 CFR 1778-ECWAG",null,0,1,{"$f":"D158*E158","v":0},1,{"$f":"F158*G158","v":0}]
[]
["1780.45(c)","Grant Agreement","RUS Bulletin 1780-12",517,1,{"$f":"SUM(D160*E160)","v":517},1,{"$f":"SUM(F160*G160)","v":517}]
[null,"      7 CFR 1777-Colonias",null,33,1,{"$f":"D161*E161","v":33},1,{"$f":"F161*G161","v":33}]
[null,"     7 CFR 1778-ECWAG",null,42,1,{"$f":"D162*E162","v":42},1,{"$f":"F162*G162","v":42}]
[]
["1780.47(d) & (e )","Audits and Year-End Financial Reports","Written",805,3,{"$f":"SUM(D164*E164)","v":2415},8,{"$f":"SUM(F164*G164)","v":19320}]
[null,"      7 CFR 1777-Colonias",null,33,3,{"$f":"D165*E165","v":99},8,{"$f":"F165*G165","v":792}]
[null,"     7 CFR 1778-ECWAG",null,42,3,{"$f":"D166*E166","v":126},8,{"$f":"F166*G166","v":1008}]
[]
["1780.47(f)(1)","Management report- Quarterly Report","Written",160,4,{"$f":"SUM(D168*E168)","v":640},4,{"$f":"SUM(F168*G168)","v":2560}]
[null,"      7 CFR 1777-Colonias",null,7,4,{"$f":"D169*E169","v":28},4,{"$f":"F169*G169","v":112}]
[null,"     7 CFR 1778-ECWAG",null,10,4,{"$f":"D170*E170","v":40},4,{"$f":"F170*G170","v":160}]
[]
[null,"Actions during Construction: (uses construction data)"]
["1780.61(a)","Construction contract forms","Written",708,1,{"$f":"SUM(D173*E173)","v":708},8,{"$f":"SUM(F173*G173)","v":5664}]
[null,"      7 CFR 1777-Colonias",null,33,1,{"$f":"D174*E174","v":33},8,{"$f":"F174*G174","v":264}]
[null,"     7 CFR 1778-ECWAG",null,42,1,{"$f":"D175*E175","v":42},8,{"$f":"F175*G175","v":336}]
[]
["1780.61(b)","Borrower attorney's certification of construction contract ","Written &",708,1,{"$f":"SUM(D177*E177)","v":708},8,{"$f":"SUM(F177*G177)","v":5664}]
[null,"      7 CFR 1777-Colonias","Exhibit GC-H",33,1,{"$f":"D178*E178","v":33},8,{"$f":"F178*G178","v":264}]
[null,"     7 CFR 1778-ECWAG",null,42,1,{"$f":"D179*E179","v":42},8,{"$f":"F179*G179","v":336}]
[]
[1780.7,"Owner's Solicitation and Review of Offers","Written",708,1,{"$f":"D181*E181","v":708},8,{"$f":"F181*G181","v":5664}]
[null,"      7 CFR 1777-Colonias",null,33,1,33,8,264]
[null,"     7 CFR 1778-ECWAG",null,42,1,{"$f":"SUM(D183*E183)","v":42},8,{"$f":"SUM(F183*G183)","v":336}]
[null,"SUBTOTAL ",null,null,null,{"$f":"SUM(F152:F183)","v":6874},null,{"$f":"SUM(H152:H183)","v":43921}]
[]
[1780.74,"Contracts awarded prior to application","Written",39,1,{"$f":"SUM(D186*E186)","v":39},2,{"$f":"SUM(F186*G186)","v":78}]
[null,"      7 CFR 1777-Colonias",null,1,1,{"$f":"D187*E187","v":1},2,{"$f":"F187*G187","v":2}]
[null,"     7 CFR 1778-ECWAG",null,2,1,{"$f":"D188*E188","v":2},2,{"$f":"F188*G188","v":4}]
[]
["1780.76 (a)","Pre-Construction Conference","RD 1924-16",708,1,{"$f":"SUM(D190*E190)","v":708},1,{"$f":"SUM(F190*G190)","v":708}]
[null,"7 CFR 1777 - Colonias",null,33,1,33,1,33]
[null,"7 CFR 1778 -ECWAG",null,42,1,42,1,42]
[]
["1780.76(b)","Monitoring construction- Owner's Report","Written",708,12,{"$f":"SUM(D194*E194)","v":8496},2,{"$f":"SUM(F194*G194)","v":16992}]
[null,"      7 CFR 1777-Colonias",null,33,12,{"$f":"D195*E195","v":396},2,{"$f":"F195*G195","v":792}]
[null,"     7 CFR 1778-ECWAG",null,42,12,{"$f":"D196*E196","v":504},5,{"$f":"F196*G196","v":2520}]
[]
["1780.76(c)","Resident Inspector resume","Written",708,1,{"$f":"SUM(D198*E198)","v":708},2,{"$f":"SUM(F198*G198)","v":1416}]
[null,"      7 CFR 1777-Colonias",null,33,1,{"$f":"D199*E199","v":33},2,{"$f":"F199*G199","v":66}]
[null,"     7 CFR 1778-ECWAG",null,42,1,{"$f":"D200*E200","v":42},2,{"$f":"F200*G200","v":84}]
[]
["1780.76(d)","Daily inspection report","Written",708,12,{"$f":"SUM(D202*E202)","v":8496},0.5,{"$f":"SUM(F202*G202)","v":4248}]
[null,"      7 CFR 1777-Colonias",null,33,12,{"$f":"D203*E203","v":396},0.5,{"$f":"F203*G203","v":198}]
[null,"     7 CFR 1778-ECWAG",null,42,12,{"$f":"D204*E204","v":504},0.5,{"$f":"F204*G204","v":252}]
[]
[1780.83,"Bond Transcript Documents","Written",680,1,{"$f":"D206*E206","v":680},8,{"$f":"F206*G206","v":5440}]
[null,"      7 CFR 1777-Colonias",null,0,1,0,8,0]
[null,"     7 CFR 1778-ECWAG",null,0,1,{"$f":"SUM(D208*E208)","v":0},8,{"$f":"SUM(F208*G208)","v":0}]
[]
["1780.89 & .90","Multiple Advances of Agency Funds (Bond Anticipation Note)","Written",125,1,125,2,250]
[null,"      7 CFR 1777-Colonias",null,0,1,{"$f":"SUM(D211*E211)","v":0},2,{"$f":"SUM(F211*G211)","v":0}]
[null,"     7 CFR 1778-ECWAG",null,0,1,0,2,0]
[]
["1780.37(b)","Borrower shall maintain accounting records for 3 years",null,null,null," ",null,null,7000,0.08,{"$f":"SUM(I214*J214)","v":560}]
[null,"Contractor required records",null,null,null,null,null,null,7000,0.08,{"$f":"SUM(I215*J215)","v":560}]
[null,"SUBTOTAL ",null,null,null,{"$f":"SUM(F186:F214)","v":21205},null,{"$f":"SUM(H186:H214)","v":33125},{"$f":"SUM(I185:I215)","v":14000},null,{"$f":"SUM(K185:K215)","v":1120}]
[null,"FORMS APPROVED UNDER OTHER OMB NUMBERS"]
["1780.29(b)(1)","Agreement for Engineering Services","1942-19",817,1,{"$f":"SUM(D218*E218)","v":817},4,{"$f":"SUM(F218*G218)","v":3268}]
[null,"7 CFR 1777-Colonias","(0575-0015)",30,1,{"$f":"SUM(D219*E219)","v":30},4,120]
[null,"7 CFR 1778-ECWAG",null,49,1,{"$f":"SUM(D220*E220)","v":49},4,196]
[]
["1780.33(a)","Application for Federal Assistance- Initial Application","SF 424",817,2,{"$f":"SUM(D222*E222)","v":1634},1,{"$f":"SUM(F222*G222)","v":1634}]
[null,"7 CFR 1777-Colonias                  ","(4040-0004)",30,2,{"$f":"D223*E223","v":60},1,{"$f":"F223*G223","v":60}]
[null,"7 CFR 1778-ECWAG",null,49,2,{"$f":"D224*E224","v":98},1,{"$f":"F224*G224","v":98}]
[]
["1780.33(a)","Budget Information--Non-Construction Programs","SF-424A",817,2,{"$f":"SUM(D226*E226)","v":1634},1,{"$f":"SUM(F226*G226)","v":1634}]
[null,"7 CFR 1777-Colonias                  ","(4040-0006)",30,2,{"$f":"D227*E227","v":60},1,{"$f":"F227*G227","v":60}]
[null,"7 CFR 1778-ECWAG",null,49,2,{"$f":"D228*E228","v":98},1,{"$f":"F228*G228","v":98}]
[]
["1780.33(a)","Assurances--Non-construction Programs","SF-424B",817,2,{"$f":"SUM(D230*E230)","v":1634},1,{"$f":"SUM(F230*G230)","v":1634}]
[" ","7 CFR 1777-Colonias                  ","(4040-0007)",30,2,{"$f":"D231*E231","v":60},1,{"$f":"F231*G231","v":60}]
[null,"7 CFR 1778-ECWAG",null,49,2,{"$f":"D232*E232","v":98},1,{"$f":"F232*G232","v":98}]
[]
["1780.33(e)","Representations Regarding Felony Conviction and Tax ","AD-3030",817,1,{"$f":"SUM(D234*E234)","v":817},0.25,{"$f":"SUM(F234*G234)","v":204.25}]
[null,"Delinquent Status for Corporate Applicants","(0505-0025)"]
[null,"7 CFR 1777-Colonias                  ",null,30,1,30,0.25,7.5]
[null,"7 CFR 1778-ECWAG",null,49,1,49,0.25,12.25]
[]
["1780.33(e)","Assurances Regarding Felony Conviction and Tax Deilnquent","AD-3031",95,1,95,0.25,23.75]
[null,"Status for Corporate Applicants","(0505-0025)"]
[null,"7 CFR 1777-Colonias                  ",null,6,1,6,0.25,1.5]
[null,"7 CFR 1778-ECWAG",null,8,1,8,0.25,2]
[]
["1780.33(h)(1)","Operating Budget","RD 442-7",817,1,{"$f":"SUM(D244*E244)","v":817},5,{"$f":"SUM(F244*G244)","v":4085}]
[null,"7 CFR 1777-Colonias","(0575-0015)",30,1,{"$f":"SUM(D245*E245)","v":30},5,{"$f":"SUM(F245*G245)","v":150}]
[null,"7 CFR 1778-ECWAG",null,49,1,{"$f":"SUM(D246*E246)","v":49},5,{"$f":"SUM(F246*G246)","v":245}]
[]
["1780.33(h)(3)","Equal Opportunity Agreement","RD 400-1",817,1,{"$f":"SUM(D248*E248)","v":817},0.08,{"$f":"SUM(F248*G248)","v":65.36}]
[null,"7 CFR 1777-Colonias","(0575-0018)",30,1,{"$f":"SUM(D249*E249)","v":30},0.08,{"$f":"SUM(F249*G249)","v":2.4}]
[null,"7 CFR 1778-ECWAG",null,49,1,{"$f":"SUM(D250*E250)","v":49},0.08,{"$f":"SUM(F250*G250)","v":3.92}]
[]
[]
["1780.33(h)(4)","Assurance Agreement","RD 400-4",817,1,{"$f":"SUM(D253*E253)","v":817},0.25,{"$f":"SUM(F253*G253)","v":204.25}]
[null,"7 CFR 1777-Colonias","(0575-0018)",30,1,{"$f":"SUM(D254*E254)","v":30},0.25,{"$f":"SUM(F254*G254)","v":7.5}]
[null,"7 CFR 1778-ECWAG",null,49,1,{"$f":"SUM(D255*E255)","v":49},0.25,{"$f":"SUM(F255*G255)","v":12.25}]
[]
["1780.39(f)","Resolution of Members or Stockholders","RD 1942-8",95,1,167,1,{"$f":"SUM(F257*G257)","v":167}]
[null,"7 CFR 1777-Colonias","(0575-0015)",6,1,13,1,{"$f":"SUM(F258*G258)","v":13}]
[null,"7 CFR 1778-ECWAG",null,8,1,20,1,{"$f":"SUM(F259*G259)","v":20}]
[]
["1780.41(a)(3)","Balance Sheet or Financial Statement","RD 442-3",805,1,{"$f":"SUM(D261*E261)","v":805},1,{"$f":"SUM(F261*G261)","v":805}]
[null,"7 CFR 1777-Colonias","(0575-0015)",33,1,{"$f":"SUM(D262*E262)","v":33},1,{"$f":"SUM(F262*G262)","v":33}]
[null,"7 CFR 1778-ECWAG",null,42,1,{"$f":"SUM(D263*E263)","v":42},1,{"$f":"SUM(F263*G263)","v":42}]
[]
["1780.41(a)(6)","Letter of Intent to Meet Conditions","RD 1942-46",805,1,{"$f":"SUM(D265*E265)","v":805},1,{"$f":"SUM(F265*G265)","v":805}]
[null,"7 CFR 1777-Colonias","(0575-0015)",33,1,{"$f":"SUM(D266*E266)","v":33},1,{"$f":"SUM(F266*G266)","v":33}]
[null,"7 CFR 1778-ECWAG",null,42,1,{"$f":"SUM(D267*E267)","v":42},1,{"$f":"SUM(F267*G267)","v":42}]
[]
["1780.44©","Initial Compliance Review","RD 400-8",805,1,{"$f":"SUM(D269*E269)","v":805},8,{"$f":"SUM(F269*G269)","v":6440}]
[null,"7 CFR 1777-Colonias","(0575-0018)",33,1,33,8,264]
[null,"7 CFR 1778-ECWAG",null,42,1,42,8,336]
[]
["1780.44(g)(1)(i)","Opinion of Counsel Relative to Right-of-Way and Easements","RD 442-22",708,1,{"$f":"SUM(D273*E273)","v":708},1,{"$f":"SUM(F273*G273)","v":708}]
[null,"7 CFR 1777-Colonias","(0575-0015)",33,1,{"$f":"SUM(D274*E274)","v":33},1,{"$f":"SUM(F274*G274)","v":33}]
[null,"7 CFR 1778-ECWAG",null,42,1,{"$f":"SUM(D275*E275)","v":42},1,{"$f":"SUM(F275*G275)","v":42}]
[]
["1780.44(g)(2)","Preliminary Title Opinion","RD 1927-9",90,1,{"$f":"SUM(D277*E277)","v":90},1.5,{"$f":"SUM(F277*G277)","v":135}]
[null,"7 CFR 1777-Colonias","(0575-0147)",0,1,{"$f":"SUM(D278*E278)","v":0},1.5,{"$f":"SUM(F278*G278)","v":0}]
[null,"7 CFR 1778-ECWAG",null,0,1,{"$f":"SUM(D279*E279)","v":0},1.5,{"$f":"SUM(F279*G279)","v":0}]
[]
["1780.44(g)(2)","Final Title Opinion","RD 1927-10",90,1,{"$f":"SUM(D281*E281)","v":90},0.34,{"$f":"SUM(F281*G281)","v":30.6}]
[null,"7 CFR 1777-Colonias","(0575-0147)",0,1,{"$f":"SUM(D282*E282)","v":0},0.34,{"$f":"SUM(F282*G282)","v":0}]
[null,"7 CFR 1778-ECWAG",null,0,1,{"$f":"SUM(D283*E283)","v":0},0.34,{"$f":"SUM(F283*G283)","v":0}]
[]
["1780.45(a)","Promissory Note","RD 440-22",90,1,{"$f":"SUM(D285*E285)","v":90},0.25,{"$f":"SUM(F285*G285)","v":22.5}]
[null,"7 CFR 1777 - Colonias","(0575-0015)",0,1,{"$f":"SUM(D286*E286)","v":0},0.25,{"$f":"SUM(F286*G286)","v":0}]
[null,"7 CFR 1778 -ECWAG",null,0,1,{"$f":"SUM(D287*E287)","v":0},0.25,{"$f":"SUM(F287*G287)","v":0}]
[]
["1780.45(b)(1)(ii)","Estimate of Funds Needed for 30-Day Period Commencing _\"","RD 440-11",0,0,{"$f":"SUM(D289*E289)","v":0},1,{"$f":"SUM(F289*G289)","v":0}]
[null,"7 CFR 1777-Colonias","(0575-0015)",0,0,{"$f":"SUM(D290*E290)","v":0},1,{"$f":"SUM(F290*G290)","v":0}]
[null,"7 CFR 1778-ECWAG",null,0,0,{"$f":"SUM(D291*E291)","v":0},1,{"$f":"SUM(F291*G291)","v":0}]
[]
["1780.47(f)(2)","Statement of Budget, Income, and Equity","RD 442-2",817,1,{"$f":"SUM(D293*E293)","v":817},2.5,{"$f":"SUM(F293*G293)","v":2042.5}]
[null,"7 CFR 1777-Colonias","(0575-0015)",30,1,{"$f":"SUM(D294*E294)","v":30},2.5,{"$f":"SUM(F294*G294)","v":75}]
[null,"7 CFR 1778-ECWAG",null,49,1,{"$f":"SUM(D295*E295)","v":49},2.5,{"$f":"SUM(F295*G295)","v":122.5}]
[]
[1780.62,"Water Purchase Contract","RD 442-30",205,1,{"$f":"SUM(D297*E297)","v":205},1,{"$f":"SUM(F297*G297)","v":205}]
[null,"7 CFR 1777-Colonias","(0575-0015)",7,1,{"$f":"SUM(D298*E298)","v":7},1,{"$f":"SUM(F298*G298)","v":7}]
[null,"7 CFR 1778-ECWAG",null,15,1,{"$f":"SUM(D299*E299)","v":15},1,{"$f":"SUM(F299*G299)","v":15}]
[]
[1780.75,"Certification of Contractor's Release","RD 1924-9",708,1,{"$f":"SUM(D301*E301)","v":708},0.25,{"$f":"SUM(F301*G301)","v":177}]
[null,"7 CFR 1777 - Colonias","(0575-0042)",33,1,{"$f":"SUM(D302*E302)","v":33},0.25,{"$f":"SUM(F302*G302)","v":8.25}]
[null,"7 CFR 1778 -ECWAG",null,42,1,{"$f":"SUM(D303*E303)","v":42},0.25,{"$f":"SUM(F303*G303)","v":10.5}]
[]
[1780.75,"Release by Claimants","RD 1924-10",708,1,{"$f":"SUM(D305*E305)","v":708},0.5,{"$f":"SUM(F305*G305)","v":354}]
[null,"7 CFR 1777 - Colonias","(0575-0042)",33,1,{"$f":"SUM(D306*E306)","v":33},0.5,{"$f":"SUM(F306*G306)","v":16.5}]
[null,"7 CFR 1778 -ECWAG",null,42,1,{"$f":"SUM(D307*E307)","v":42},0.5,{"$f":"SUM(F307*G307)","v":21}]
[]
["1780.76(e)","Partial Payment Estimate","RD 1924-18",708,12,{"$f":"SUM(D309*E309)","v":8496},0.5,{"$f":"SUM(F309*G309)","v":4248}]
[null,"7 CFR 1777-Colonias","(0575-0042)",33,12,{"$f":"SUM(D310*E310)","v":396},0.5,{"$f":"SUM(F310*G310)","v":198}]
[null,"7 CFR 1778-ECWAG",null,42,12,{"$f":"SUM(D311*E311)","v":504},0.5,{"$f":"SUM(F311*G311)","v":252}]
[]
["1780.76(f)","Inspection Report","RD 1924-12",708,12,{"$f":"SUM(D313*E313)","v":8496},0.25,{"$f":"SUM(F313*G313)","v":2124}]
[null,"7 CFR 1777 - Colonias","(0575-0042)",33,12,{"$f":"SUM(D314*E314)","v":396},0.25,{"$f":"SUM(F314*G314)","v":99}]
[null,"7 CFR 1778 -ECWAG",null,42,12,{"$f":"SUM(D315*E315)","v":504},0.25,{"$f":"SUM(F315*G315)","v":126}]
[]
["1780.76(h)(2)","Contract Change Order","RD 1924-7",708,2,{"$f":"SUM(D317*E317)","v":1416},0.25,{"$f":"SUM(F317*G317)","v":354}]
[null,"7 CFR 1777-Colonias","(0575-0042)",33,2,{"$f":"SUM(D318*E318)","v":66},0.25,{"$f":"SUM(F318*G318)","v":16.5}]
[null,"7 CFR 1778-ECWAG",null,42,2,{"$f":"SUM(D319*E319)","v":84},0.25,{"$f":"SUM(F319*G319)","v":21}]
[]
[null,"Sub-total (Forms Approved Under Other OMB Numbers)",null,{"$f":"SUM(D218:D320)","v":16117},null,{"$f":"SUM(F218:F320)","v":36905},null,{"$f":"SUM(H218:H320)","v":34450.78}]
[" RUS  Form  36   (07-91)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}