{"text_format":"3","workbook":"xlsx","n_sheets":17,"sheets":["Overall Summary","12 BHCollection RES-EEI<80K","12 Not Inc BH RES-EEI<80","12 BHCollection RES-EEI 80><200","12 Not Inc BH RES-EEI 80><200","12 BHCollection RES-EEI >200","12 Not Inc BH RES-EEI >200","12 BHCollection EA REDA","12 Not Inc BH EA REDA","12 BHCollection TAG","12 Not Inc BH TAG","12 Est Prof Wage Rate","14 Annual$FedGovEst RES-EEI <80","14Ann$FedGovEst RES-EEI80><200","14 Annual$FedGovEst RES-EEI>200","14 Annual $ Fed Gov Est EA REDA","14 Annual $ Fed Gov Est TAG"],"not_rendered":{"external_links":1,"defined_names":340,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Overall Summary","index":0,"n_rows":49,"n_cols":7,"rows_kept":49}
[{"$f":"'12 BHCollection EA REDA'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 BHCollection EA REDA'!A2","v":"RURAL ENERGY FOR AMERICA PROGRAM"}]
[{"$f":"'12 BHCollection EA REDA'!A3","v":"ENERGY AUDIT (EA) AND RENEWABLE ENERGY DEVELOPMENT ASSITANCE (REDA)"}]
[{"$f":"'12 BHCollection RES-EEI<80K'!A3","v":"RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - <$80K"}]
[{"$f":"'12 BHCollection RES-EEI 80><200'!A3","v":"RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - $80K> <$200K"}]
[{"$f":"'12 BHCollection RES-EEI >200'!A3","v":"RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - >$200K"}]
["TECHNICAL ASSISTANCE GRANT PROGRAM"]
[{"$f":"'12 BHCollection EA REDA'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BHCollection EA REDA'!A5","v":"OMB # 0570 - 0067"}]
["2024-10-10"]
[]
["For FR Notice"]
[null,"RES/EEI"]
[null,"<80","80><200",">200","EA/REDA","TAG","Total"]
["Estimated No. of Total Respondents (Applicants)",{"$f":"'12 BHCollection RES-EEI<80K'!E9","v":{"v":1054,"d":"1,054"}},{"$f":"'12 BHCollection RES-EEI 80><200'!E9","v":{"v":1326,"d":"1,326"}},{"$f":"'12 BHCollection RES-EEI >200'!E9","v":{"v":1818,"d":"1,818"}},{"$f":"'12 BHCollection EA REDA'!C8","v":28},{"$f":"'12 BHCollection TAG'!C8","v":389},{"$f":"SUM(B15:F15)","v":{"v":4615,"d":"4,615"}}]
["Estimated No. of Total Awards (Awardees)",{"$f":"'12 BHCollection RES-EEI<80K'!K9","v":966},{"$f":"'12 BHCollection RES-EEI 80><200'!K9","v":{"v":1215,"d":"1,215"}},{"$f":"'12 BHCollection RES-EEI >200'!K9","v":{"v":1666,"d":"1,666"}},{"$f":"'12 BHCollection EA REDA'!K8","v":22},{"$f":"'12 BHCollection TAG'!K8","v":116},{"$f":"SUM(B16:F16)","v":{"v":3985,"d":"3,985"}}]
["Total Responses",{"$f":"'12 BHCollection RES-EEI<80K'!G12","v":{"v":18687.68,"d":"18,688"}},{"$f":"'12 BHCollection RES-EEI 80><200'!G12","v":{"v":23456.375000000004,"d":"23,456"}},{"$f":"'12 BHCollection RES-EEI >200'!G12","v":{"v":38046.97,"d":"38,047"}},{"$f":"'12 BHCollection EA REDA'!G10","v":{"v":298.24,"d":"298"}},{"$f":"'12 BHCollection TAG'!G10","v":{"v":2368,"d":"2,368"}},{"$f":"SUM(B17:F17)","v":{"v":82857.26500000001,"d":"82,857"}}]
["Estimated Total Hours",{"$f":"'12 BHCollection RES-EEI<80K'!I12","v":{"v":51143.34500000001,"d":"51,143"}},{"$f":"'12 BHCollection RES-EEI 80><200'!I12","v":{"v":60825.142499999994,"d":"60,825"}},{"$f":"'12 BHCollection RES-EEI >200'!I12","v":{"v":139164.86,"d":"139,165"}},{"$f":"'12 BHCollection EA REDA'!I10","v":{"v":963.864,"d":"964"}},{"$f":"'12 BHCollection TAG'!I10","v":{"v":6546.074,"d":"6,546"}},{"v":258643.28549999997,"d":"258,643"}]
["Total Cost",{"$f":"'12 BHCollection RES-EEI<80K'!K12","v":{"v":3786150.320145271,"d":"3,786,150"}},{"$f":"'12 BHCollection RES-EEI 80><200'!K12","v":{"v":4502895.396248656,"d":"4,502,895"}},{"$f":"'12 BHCollection RES-EEI >200'!K12","v":{"v":10302397.68716676,"d":"10,302,398"}},{"$f":"'12 BHCollection EA REDA'!K10","v":{"v":71355.01192142401,"d":"71,355"}},{"$f":"'12 BHCollection TAG'!K10","v":{"v":484606.94486828404,"d":"484,607"}},{"v":19147405.360350396,"d":"19,147,405"}]
["Average Hours Per Response",{"$f":"B18/B17","v":{"v":2.7367412648333023,"d":"2.737"}},{"$f":"C18/C17","v":{"v":2.5931177558339678,"d":"2.593"}},{"v":3.657712033310405,"d":"3.658"},{"v":3.2318401287553646,"d":"3.232"},{"v":2.764389358108108,"d":"2.764"},{"v":3.1215522923668786,"d":"3.122"}]
["Number of Responses Per Respondent",{"$f":"B17/B15","v":{"v":17.73024667931689,"d":"17.730"}},{"$f":"C17/C15","v":{"v":17.689573906485673,"d":"17.690"}},{"v":20.927926292629262,"d":"20.928"},{"v":10.651428571428571,"d":"10.651"},{"v":6.087403598971722,"d":"6.087"},{"v":17.953903575297943,"d":"17.954"}]
[]
[]
[]
["Supporting Statement Tables:"]
["Table 12.1"]
[null,"RES/EEI"]
[null,"<80","80><200",">200","EA/REDA","TAG","Total"]
["Total Respondents (Applicants)",{"$f":"'12 BHCollection RES-EEI<80K'!E9","v":{"v":1054,"d":"1,054 "}},{"$f":"'12 BHCollection RES-EEI 80><200'!E9","v":{"v":1326,"d":"1,326 "}},{"$f":"'12 BHCollection RES-EEI >200'!E9","v":{"v":1818,"d":"1,818 "}},{"$f":"'12 BHCollection EA REDA'!C8","v":{"v":28,"d":"28 "}},{"$f":"'12 BHCollection TAG'!C8","v":{"v":389,"d":"389 "}},{"$f":"SUM(B29:F29)","v":{"v":4615,"d":"4,615 "}}]
["Total Awards (Awardees)",{"$f":"'12 BHCollection RES-EEI<80K'!K9","v":966},{"$f":"'12 BHCollection RES-EEI 80><200'!K9","v":{"v":1215,"d":"1,215 "}},{"$f":"'12 BHCollection RES-EEI >200'!K9","v":{"v":1666,"d":"1,666 "}},{"$f":"'12 BHCollection EA REDA'!K8","v":22},{"$f":"'12 BHCollection TAG'!K8","v":116},{"$f":"SUM(B30:F30)","v":{"v":3985,"d":"3,985 "}}]
["Annual Responses",{"$f":"'12 BHCollection RES-EEI<80K'!G12","v":{"v":18687.68,"d":"18,688"}},{"$f":"'12 BHCollection RES-EEI 80><200'!G12","v":{"v":23456.375000000004,"d":"23,456"}},{"$f":"'12 BHCollection RES-EEI >200'!G12","v":{"v":38046.97,"d":"38,047"}},{"$f":"'[1]12 BH Collection Tribal Lands'!$H$10","v":{"v":718.85,"d":"719"}},{"$f":"'[1]12 BH Collection ECWAG'!$H$10","v":{"v":1968,"d":"1,968"}},{"$f":"SUM(B31:F31)","v":{"v":82877.87500000001,"d":"82,878 "}}]
["Total Hours",{"$f":"ROUND('12 BHCollection RES-EEI<80K'!I12,0)","v":{"v":51143,"d":"51,143"}},{"$f":"ROUND('12 BHCollection RES-EEI 80><200'!I12,0)","v":{"v":60825,"d":"60,825"}},{"$f":"ROUND('12 BHCollection RES-EEI >200'!I12,0)","v":{"v":139165,"d":"139,165"}},{"$f":"ROUND('12 BHCollection EA REDA'!I10,0)","v":964},{"$f":"ROUND('12 BHCollection TAG'!I10,0)","v":{"v":6546,"d":"6,546"}},{"$f":"SUM(B32:F32)","v":{"v":258643,"d":"258,643 "}}]
["Cost per Hours",{"$f":"ROUND('12 Est Prof Wage Rate'!G38,2)","v":{"v":74.03,"d":"$74.03"}}]
["Total Annual Cost",{"$f":"B32*$B$33","v":{"v":3786116.29,"d":"$3,786,116"}},{"$f":"C32*$B$33","v":{"v":4502874.75,"d":"$4,502,875"}},{"v":10302384.95,"d":"$10,302,385"},{"v":71364.92,"d":"$71,365"},{"v":484600.38,"d":"$484,600"},{"$f":"SUM(B34:F34)","v":{"v":19147341.29,"d":"$19,147,341"}}]
[]
["Table 14.1"]
["Review","RES/EEI"]
["Type","<80","80><200",">200","EA/REDA","TAG","Total"]
["Other Requirements",{"$f":"ROUND('14 Annual$FedGovEst RES-EEI <80'!K23,0)","v":{"v":628907,"d":"$628,907"}},{"$f":"ROUND('14Ann$FedGovEst RES-EEI80><200'!K23,0)","v":{"v":791206,"d":"$791,206"}},{"$f":"ROUND('14 Annual$FedGovEst RES-EEI>200'!K23,0)","v":{"v":1325156,"d":"$1,325,156"}},{"$f":"ROUND('14 Annual $ Fed Gov Est EA REDA'!K23,0)","v":{"v":15210,"d":"$15,210"}},{"v":0,"d":"$0"},{"$f":"SUM(B39:F39)","v":{"v":2760479,"d":"$2,760,479"}}]
["Application",{"$f":"ROUND('14 Annual$FedGovEst RES-EEI <80'!K27,0)","v":{"v":628907,"d":"$628,907"}},{"$f":"ROUND('14Ann$FedGovEst RES-EEI80><200'!K27,0)","v":{"v":1127336,"d":"$1,127,336"}},{"$f":"ROUND('14 Annual$FedGovEst RES-EEI>200'!K27,0)","v":{"v":2266766,"d":"$2,266,766"}},{"$f":"ROUND('14 Annual $ Fed Gov Est EA REDA'!K27,0)","v":{"v":11154,"d":"$11,154"}},{"$f":"ROUND('14 Annual $ Fed Gov Est TAG'!K23,0)","v":{"v":258483,"d":"$258,483"}},{"$f":"SUM(B40:F40)","v":{"v":4292646,"d":"$4,292,646"}}]
["Awardee Documents and Certifications",{"$f":"ROUND('14 Annual$FedGovEst RES-EEI <80'!K32,0)","v":{"v":155181,"d":"$155,181"}},{"$f":"ROUND('14Ann$FedGovEst RES-EEI80><200'!K32,0)","v":{"v":195182,"d":"$195,182"}},{"$f":"ROUND('14 Annual$FedGovEst RES-EEI>200'!K32,0)","v":{"v":267632,"d":"$267,632"}},{"$f":"ROUND('14 Annual $ Fed Gov Est EA REDA'!K31,0)","v":{"v":7464,"d":"$7,464"}},{"$f":"ROUND('14 Annual $ Fed Gov Est TAG'!K27,0)","v":{"v":60276,"d":"$60,276"}},{"$f":"SUM(B41:F41)","v":{"v":685735,"d":"$685,735"}}]
["Reporting and Other",{"$f":"ROUND('14 Annual$FedGovEst RES-EEI <80'!K36,0)","v":{"v":136164,"d":"$136,164"}},{"$f":"ROUND('14Ann$FedGovEst RES-EEI80><200'!K36,0)","v":{"v":412238,"d":"$412,238"}},{"$f":"ROUND('14 Annual$FedGovEst RES-EEI>200'!K36,0)","v":{"v":565258,"d":"$565,258"}},{"$f":"ROUND('14 Annual $ Fed Gov Est EA REDA'!K35,0)","v":{"v":7464,"d":"$7,464"}},{"$f":"ROUND('14 Annual $ Fed Gov Est TAG'!K31,0)","v":{"v":69411,"d":"$69,411"}},{"$f":"SUM(B42:F42)","v":{"v":1190535,"d":"$1,190,535"}}]
["Total Cost to Federal Government",{"$f":"SUM(B39:B42)","v":{"v":1549159,"d":"$1,549,159"}},{"$f":"SUM(C39:C42)","v":{"v":2525962,"d":"$2,525,962"}},{"v":4424812,"d":"$4,424,812"},{"v":41292,"d":"$41,292"},{"v":388170,"d":"$388,170"},{"v":8929395,"d":"$8,929,395"}]
[]
[]
[]
["ROCIS Information:"]
["Number of Responses per Respondent",{"$f":"G31/G29","v":17.958369447453958}]
["Time per Response",{"$f":"G32/G31","v":{"v":3.120772582549926,"d":"3.12077"}}]

{"sheet":"12 BHCollection RES-EEI<80K","index":1,"n_rows":48,"n_cols":11,"rows_kept":48}
["RURAL BUSINESS COOPERATIVE SERVICE"]
["RURAL ENERGY FOR AMERICA PROGRAM"]
["RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - <$80K"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570 - 0067"]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
[null,null,"RES","EEI","Total",{"$nulls":3},"RES","EEI","Total"]
["Estimated No. of Total Respondents (Applicants)",null,{"v":864,"d":"864 "},{"v":190,"d":"190 "},{"$f":"SUM(C9:D9)","v":{"v":1054,"d":"1,054 "}},null,null,"Estimated No. of Total Awards (Awardees)",792,174,{"$f":"SUM(I9:J9)","v":966}]
["Average hours per response",{"$nulls":3},{"$f":"I12/G12","v":{"v":2.7367412648333023,"d":"2.737"}},{"$nulls":4},"Number of responses per respondent",{"$f":"G12/E9","v":{"v":17.73024667931689,"d":"17.73"}}]
[]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G15:G48)","v":{"v":18687.68,"d":"18,688"}},null,{"$f":"SUM(I15:I48)","v":{"v":51143.34500000001,"d":"51,143"}},null,{"$f":"SUM(K15:K48)","v":{"v":3786150.320145271,"d":"$3,786,150"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference\n4280.XXX","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["OTHER REQUIREMENTS"]
[105,"Reviews and appeals","written",{"v":0.005,"d":"1%"},{"$f":"D16*$E$9","v":{"v":5.2700000000000005,"d":"5 "}},{"v":1,"d":"1.00"},{"$f":"E16*F16","v":{"v":5.2700000000000005,"d":"5"}},{"v":12,"d":"12.00"},{"$f":"IF((H16*G16)=\"\",\"\",(H16*G16))","v":{"v":63.24000000000001,"d":"63.24"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J16*I16)=\"\",\"\",(J16*I16))","v":{"v":4681.667697840001,"d":"$4,682"}}]
["108(e)","Discrimation Complaints","written",{"v":0.005,"d":"1%"},{"v":5.2700000000000005,"d":"5 "},{"v":1,"d":"1.00"},{"v":5.2700000000000005,"d":"5"},{"v":1,"d":"1.00"},{"v":5.2700000000000005,"d":"5.27"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":390.1389748200001,"d":"$390"}]
["APPLICATION"]
["110(f)","Application Withdrawal","written",{"v":0.01,"d":"1%"},{"$f":"D19*$E$9","v":{"v":10.540000000000001,"d":"11 "}},{"v":1,"d":"1.00"},{"$f":"E19*F19","v":{"v":10.540000000000001,"d":"11"}},{"v":0.5,"d":"0.50"},{"$f":"IF((H19*G19)=\"\",\"\",(H19*G19))","v":{"v":5.2700000000000005,"d":"5.27"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J19*I19)=\"\",\"\",(J19*I19))","v":{"v":390.1389748200001,"d":"$390"}}]
["112(f), (g)","SAM Registration & UEI","written",{"v":1,"d":"100%"},{"$f":"D20*$E$9","v":{"v":1054,"d":"1,054 "}},{"v":1,"d":"1.00"},{"v":1054,"d":"1,054"},{"v":9.5,"d":"9.50"},{"v":10013,"d":"10,013.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":741264.0521580001,"d":"$741,264"}]
["116(b)","Feasibility Study (RES ONLY)","written",{"v":0.06,"d":"6%"},{"$f":"D21*$C$9","v":{"v":51.839999999999996,"d":"52 "}},{"v":1,"d":"1.00"},{"$f":"E21*F21","v":{"v":51.839999999999996,"d":"52"}},{"v":40,"d":"40.00"},{"$f":"IF((H21*G21)=\"\",\"\",(H21*G21))","v":{"v":2073.6,"d":"2,073.60"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J21*I21)=\"\",\"\",(J21*I21))","v":{"v":153508.95221760002,"d":"$153,509"}}]
["120(b)(1)(i)","Application for Renewable Energy Systems and Energy Efficiency Improvements Projects, Total Project Costs of $80,000 or less.","RD 4280-3A",{"v":1,"d":"100%"},{"v":1054,"d":"1,054 "},{"v":1,"d":"1.00"},{"v":1054,"d":"1,054"},{"v":10,"d":"10.00"},{"$f":"IF((H22*G22)=\"\",\"\",(H22*G22))","v":{"v":10540,"d":"10,540.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J22*I22)=\"\",\"\",(J22*I22))","v":{"v":780277.9496400001,"d":"$780,278"}}]
["120(b)(1)(vi)","Environmental Documentation","written",{"v":1,"d":"100%"},{"v":1054,"d":"1,054 "},{"v":1,"d":"1.00"},{"v":1054,"d":"1,054"},{"v":6,"d":"6.00"},{"v":6324,"d":"6,324.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":468166.76978400006,"d":"$468,167"}]
["120(b)(3), (b)(4)","Technical Report ","written",{"v":1,"d":"100%"},{"$f":"D24*$E$9","v":{"v":1054,"d":"1,054 "}},{"v":1,"d":"1.00"},{"v":1054,"d":"1,054"},{"v":4,"d":"4.00"},{"v":4216,"d":"4,216.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":312111.17985600006,"d":"$312,111"}]
["120(b)(3)(iii)","Energy Assessment (EEI ONLY)","written",{"v":1,"d":"100%"},{"$f":"D25*$D$9","v":{"v":190,"d":"190 "}},{"v":1,"d":"1.00"},{"$f":"E25*F25","v":190},{"v":4,"d":"4.00"},{"$f":"IF((H25*G25)=\"\",\"\",(H25*G25))","v":{"v":760,"d":"760.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J25*I25)=\"\",\"\",(J25*I25))","v":{"v":56262.92616,"d":"$56,263"}}]
["120(b), 121","Project Self Score ","written",{"v":1,"d":"100%"},{"$f":"D26*$E$9","v":{"v":1054,"d":"1,054 "}},{"v":1,"d":"1.00"},{"v":1054,"d":"1,054"},{"v":2,"d":"2.00"},{"v":2108,"d":"2,108.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":156055.58992800003,"d":"$156,056"}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["110(g)(2)","Technical Report Modifications","written",{"v":0.01,"d":"1%"},{"$f":"D28*$K$9","v":{"v":9.66,"d":"10 "}},{"v":1,"d":"1.00"},{"v":9.66,"d":"10"},{"v":1,"d":"1.00"},{"$f":"IF((H28*G28)=\"\",\"\",(H28*G28))","v":9.66},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J28*I28)=\"\",\"\",(J28*I28))","v":{"v":715.1314035600001,"d":"$715"}}]
["110(h)(1)","Time Extensions","written",{"v":0.05,"d":"5%"},{"v":48.300000000000004,"d":"48 "},{"v":1,"d":"1.00"},{"v":48.300000000000004,"d":"48"},{"v":0.5,"d":"0.50"},{"v":24.150000000000002,"d":"24.15"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":1787.8285089000003,"d":"$1,788"}]
["123(b)","Insurance","written",{"v":1,"d":"100%"},{"v":966,"d":"966 "},{"v":1,"d":"1.00"},966,{"v":1,"d":"1.00"},{"v":966,"d":"966.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":71513.140356,"d":"$71,513"}]
["123(c)(2)","Request for Obligation of Funds","RD 1940-1",{"v":1,"d":"100%"},{"v":966,"d":"966 "},{"v":1,"d":"1.00"},966,0.25,{"v":241.5,"d":"241.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":17878.285089,"d":"$17,878"}]
["123(d)","Evidence of matching funds","written",{"v":1,"d":"100%"},{"$f":"D32*$K$9","v":{"v":966,"d":"966 "}},{"v":1,"d":"1.00"},{"$f":"E32*F32","v":966},{"v":1,"d":"1.00"},{"$f":"IF((H32*G32)=\"\",\"\",(H32*G32))","v":{"v":966,"d":"966.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J32*I32)=\"\",\"\",(J32*I32))","v":{"v":71513.140356,"d":"$71,513"}}]
[" 123(e) ","SAM Renewal","written",{"v":1,"d":"100%"},{"v":966,"d":"966 "},{"v":1,"d":"1.00"},966,{"v":1,"d":"1.00"},{"v":966,"d":"966.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":71513.140356,"d":"$71,513"}]
["123(f)","Rural Business Cooperative Service Financial Assistance Agreement","RD 4280-2 ",{"v":1,"d":"100%"},{"v":966,"d":"966 "},{"v":1,"d":"1.00"},966,{"v":1,"d":"1.00"},{"v":966,"d":"966.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":71513.140356,"d":"$71,513"}]
["123(h)","Power purchase agreement (RES ONLY)","written",{"v":0.29,"d":"29%"},{"$f":"D35*$I$9","v":{"v":229.67999999999998,"d":"230 "}},{"v":1,"d":"1.00"},{"v":229.67999999999998,"d":"230"},{"v":1.5,"d":"1.50"},344.52,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":25504.87279032,"d":"$25,505"}]
["124(b)","Programmatic changes","written",{"v":0.005,"d":"1%"},{"v":4.83,"d":"5 "},{"v":1,"d":"1.00"},{"v":4.83,"d":"5"},{"v":1,"d":"1.00"},4.83,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":357.56570178000004,"d":"$358"}]
["120(d)(1)","Grantee statement for accepting contractor's work","written",{"v":1,"d":"100%"},{"v":966,"d":"966 "},{"v":1,"d":"1.00"},966,0.25,{"v":241.5,"d":"241.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":17878.285089,"d":"$17,878"}]
["120(d)(1) & (2)","Contractor Certification of Final Completion (Plus 30 days for RES only projects)","written",{"v":1,"d":"100%"},{"$f":"D38*$K$9","v":{"v":966,"d":"966 "}},{"v":1,"d":"1.00"},966,{"v":1,"d":"1.00"},{"v":966,"d":"966.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":71513.140356,"d":"$71,513"}]
["124(a)","Inspection ","written",{"v":0.25,"d":"25%"},{"$f":"D39*$K$9","v":{"v":241.5,"d":"242 "}},{"v":1,"d":"1.00"},{"$f":"E39*F39","v":{"v":241.5,"d":"242"}},{"v":0.5,"d":"0.50"},{"$f":"IF((H39*G39)=\"\",\"\",(H39*G39))","v":120.75},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J39*I39)=\"\",\"\",(J39*I39))","v":{"v":8939.1425445,"d":"$8,939"}}]
["REPORTING AND OTHER"]
["124(c)","Transfer of ownership ","written",{"v":0.005,"d":"1%"},{"$f":"D41*$K$9","v":{"v":4.83,"d":"5 "}},{"v":1,"d":"1.00"},{"$f":"E41*F41","v":{"v":4.83,"d":"5"}},{"v":0.5,"d":"0.50"},{"$f":"IF((H41*G41)=\"\",\"\",(H41*G41))","v":{"v":2.415,"d":"2.42"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J41*I41)=\"\",\"\",(J41*I41))","v":{"v":178.78285089000002,"d":"$179"}}]
["124(d)","Disposition/bi-annual check of acquired property ","written",{"v":0.1,"d":"10%"},{"$f":"D42*$K$9","v":{"v":96.60000000000001,"d":"97 "}},{"v":0.5,"d":"0.50"},{"v":48.300000000000004,"d":"48"},{"v":1,"d":"1.00"},{"v":48.300000000000004,"d":"48.30"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":3575.6570178000006,"d":"$3,576"}]
["124(e) ","Recordkeeping","written",{"v":1,"d":"100%"},{"$f":"D43*$K$9","v":{"v":966,"d":"966 "}},{"v":1,"d":"1.00"},{"$f":"E43*F43","v":966},{"v":1,"d":"1.00"},{"$f":"IF((H43*G43)=\"\",\"\",(H43*G43))","v":{"v":966,"d":"966.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J43*I43)=\"\",\"\",(J43*I43))","v":{"v":71513.140356,"d":"$71,513"}}]
["124(f)","Audit requirement","written",{"v":0.01,"d":"1%"},{"v":9.66,"d":"10 "},{"v":1,"d":"1.00"},{"v":9.66,"d":"10"},{"v":24,"d":"24.00"},{"$f":"IF((H44*G44)=\"\",\"\",(H44*G44))","v":231.84},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J44*I44)=\"\",\"\",(J44*I44))","v":{"v":17163.153685440004,"d":"$17,163"}}]
["124(i)(3)(i)","Annual outcome project performance certification-RES","4280-3D",{"v":1,"d":"100%"},{"$f":"D45*$I$9","v":{"v":792,"d":"792 "}},{"v":1,"d":"1.00"},792,0.25,{"v":198,"d":"198.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":14657.972868,"d":"$14,658"}]
["124(i)(3)(ii)","Annual outcome project performance certification-EEI","4280-3D",{"v":1,"d":"100%"},{"$f":"D46*$J$9","v":{"v":174,"d":"174 "}},{"v":1,"d":"1.00"},174,0.25,{"v":43.5,"d":"43.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":3220.312221,"d":"$3,220"}]
["124(i)(2)(i)","Project performance report - semiannual ","written",{"v":1,"d":"100%"},{"$f":"K9*D47","v":{"v":966,"d":"966 "}},{"v":2,"d":"2.00"},{"v":1932,"d":"1,932"},{"v":2,"d":"2.00"},{"v":3864,"d":"3,864.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J47*I47)=\"\",\"\",(J47*I47))","v":{"v":286052.561424,"d":"$286,053"}}]
["124(i)(2)(ii) ","Final Project Performance Report","written",{"v":1,"d":"100%"},{"$f":"K9*D48","v":{"v":966,"d":"966 "}},{"v":2,"d":"2.00"},{"$f":"E48*F48","v":{"v":1932,"d":"1,932"}},{"v":2,"d":"2.00"},{"v":3864,"d":"3,864.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":286052.561424,"d":"$286,053"}]

{"sheet":"12 Not Inc BH RES-EEI<80","index":2,"n_rows":27,"n_cols":11,"rows_kept":27}
["RURAL BUSINESS COOPERATIVE SERVICE"]
["RURAL ENERGY FOR AMERICA PROGRAM"]
["RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - <$80K"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570 - 0067"]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
[null,null,"RES","EEI","Total",{"$nulls":3},"RES","EEI","Total"]
["Estimated No. of Total Respondents (Applicants)",null,{"$f":"'12 BHCollection RES-EEI<80K'!C9","v":{"v":864,"d":"864 "}},{"$f":"'12 BHCollection RES-EEI<80K'!D9","v":{"v":190,"d":"190 "}},{"$f":"SUM(C9:D9)","v":{"v":1054,"d":"1,054 "}},null,null,"Estimated No. of Total Awards (Awardees)",{"$f":"'12 BHCollection RES-EEI<80K'!I9","v":{"v":792,"d":"792 "}},{"$f":"'12 BHCollection RES-EEI<80K'!J9","v":{"v":174,"d":"174 "}},{"$f":"SUM(I9:J9)","v":966}]
["Average hours per response",{"$nulls":3},{"$f":"I12/G12","v":{"v":0.729782838474104,"d":"0.730"}},{"$nulls":4},"Number of responses per respondent",{"$f":"G12/E9","v":{"v":9.87381404174573,"d":"9.87"}}]
[]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G15:G27)","v":{"v":10407,"d":"10,407"}},null,{"$f":"SUM(I15:I27)","v":{"v":7594.85,"d":"7,595"}},null,{"$f":"SUM(K15:K27)","v":{"v":562248.0062451002,"d":"562,248"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference\n4280.XXX","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["APPLICATION"]
["120(b)(1)(ii)","Application for Federal Assistance","SF 424\n(4040-0004)",{"v":1,"d":"100%"},{"$f":"D16*$E$9","v":{"v":1054,"d":"1,054 "}},{"v":1,"d":"1.00"},{"$f":"E16*F16","v":{"v":1054,"d":"1,054"}},{"v":1,"d":"1.00"},{"$f":"IF((H16*G16)=\"\",\"\",(H16*G16))","v":{"v":1054,"d":"1,054.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J16*I16)=\"\",\"\",(J16*I16))","v":{"v":78027.79496400002,"d":"$78,028"}}]
["120(b)(1)(iii)","Budget Information - Construction Programs","SF 424C\n(4040-0008)",{"v":1,"d":"100%"},{"v":1054,"d":"1,054 "},{"v":1,"d":"1.00"},{"v":1054,"d":"1,054"},{"v":3,"d":"3.00"},{"v":3162,"d":"3,162.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":234083.38489200003,"d":"$234,083"}]
["120(b)(1)(iv)","Assurances - Construction Programs","SF 424D\n(4040-0009)",{"v":1,"d":"100%"},{"v":1054,"d":"1,054 "},{"v":1,"d":"1.00"},{"v":1054,"d":"1,054"},0.25,{"v":263.5,"d":"263.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":19506.948741000004,"d":"$19,507"}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["119(c)(3)(i); 120(c)(3)(i)","Compliance Statement (Contract in excess of $10,000)","RD-400-6\n(0575-0201, 0189)",{"v":0.5,"d":"50%"},{"$f":"D20*$K$9","v":{"v":483,"d":"483 "}},{"v":1,"d":"1.00"},{"$f":"E20*F20","v":483},0.25,{"$f":"IF((H20*G20)=\"\",\"\",(H20*G20))","v":120.75},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J20*I20)=\"\",\"\",(J20*I20))","v":{"v":8939.1425445,"d":"$8,939"}}]
[" 120(d)(3)","Certificate of Contractor's Release","RD 1924-9 \n(0575-0042)",{"v":0.5,"d":"50%"},{"v":483,"d":"483 "},{"v":1,"d":"1.00"},483,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":0,"d":"$0"}]
["120(d)(3)","Release by Claimants","RD 1924-10\n(0575-0189) ",{"v":0.5,"d":"50%"},{"v":483,"d":"483 "},{"v":1,"d":"1.00"},483,{"v":1,"d":"1.00"},{"v":483,"d":"483.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":35756.570178,"d":"$35,757"}]
["123(c)(1)","Letter of Intent","RD 1942-46\n(0570-0021, 0061, 0062; 0572-0137; 0575-0015)",{"v":1,"d":"100%"},{"$f":"D23*$K$9","v":{"v":966,"d":"966 "}},{"v":1,"d":"1.00"},{"$f":"E23*F23","v":966},{"v":0.1,"d":"0.10"},{"$f":"IF((H23*G23)=\"\",\"\",(H23*G23))","v":{"v":96.60000000000001,"d":"96.60"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J23*I23)=\"\",\"\",(J23*I23))","v":{"v":7151.314035600001,"d":"$7,151"}}]
["123(c)(3)","Disclosure of Lobbying Activities","SF LLL\n(4040-0013)",{"v":1,"d":"100%"},{"$f":"D24*$K$9","v":{"v":966,"d":"966 "}},{"v":1,"d":"1.00"},966,0.25,{"$f":"IF((H24*G24)=\"\",\"\",(H24*G24))","v":{"v":241.5,"d":"241.50"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J24*I24)=\"\",\"\",(J24*I24))","v":{"v":17878.285089,"d":"$17,878"}}]
["123(c)(4)","Assurance Agreement","RD-400-4\n(0575-0201, 0189)",{"v":1,"d":"100%"},{"v":966,"d":"966 "},{"v":1,"d":"1.00"},966,0.25,{"v":241.5,"d":"241.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":17878.285089,"d":"$17,878"}]
["124(i)(1)","Federal Financial Report ","SF 425\n(4040-0014)",{"v":1,"d":"100%"},{"v":966,"d":"966 "},{"v":2,"d":"2.00"},{"v":1932,"d":"1,932"},{"v":0.5,"d":"0.50"},{"v":966,"d":"966.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":71513.140356,"d":"$71,513"}]
["124(g)(4)","Outlay Report and Request for Reimbursement for Construction Programs","SF 271\n(4040-0011)",{"v":1,"d":"100%"},{"v":966,"d":"966 "},{"v":1,"d":"1.00"},966,{"v":1,"d":"1.00"},{"v":966,"d":"966.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":71513.140356,"d":"$71,513"}]

{"sheet":"12 BHCollection RES-EEI 80><200","index":3,"n_rows":52,"n_cols":11,"rows_kept":52}
["RURAL BUSINESS COOPERATIVE SERVICE"]
["RURAL ENERGY FOR AMERICA PROGRAM"]
["RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - $80K> <$200K"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570 - 0067"]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
[null,null,"RES","EEI","Total",{"$nulls":3},"RES","EEI","Total"]
["Estimated No. of Total Respondents (Applicants)",null,{"v":1028,"d":"1,028 "},{"v":298,"d":"298 "},{"$f":"SUM(C9:D9)","v":{"v":1326,"d":"1,326 "}},null,null,"Estimated No. of Total Awards (Awardees)",942,273,{"$f":"SUM(I9:J9)","v":{"v":1215,"d":"1,215 "}}]
["Average hours per response",{"$nulls":3},{"$f":"I12/G12","v":{"v":2.5931177558339678,"d":"2.593"}},{"$nulls":4},"Number of responses per respondent",{"$f":"G12/E9","v":{"v":17.689573906485673,"d":"17.69"}}]
[]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G15:G52)","v":{"v":23456.375000000004,"d":"23,456"}},null,{"$f":"SUM(I15:I52)","v":{"v":60825.142499999994,"d":"60,825"}},null,{"$f":"SUM(K15:K52)","v":{"v":4502895.396248656,"d":"4,502,895"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference\n4280.XXX","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["OTHER REQUIREMENTS"]
[105,"Reviews and appeals","written",{"v":0.01,"d":"1%"},{"$f":"D16*$E$9","v":{"v":13.26,"d":"13 "}},{"v":1,"d":"1.00"},{"$f":"E16*F16","v":{"v":13.26,"d":"13"}},{"v":12,"d":"12.00"},{"$f":"IF((H16*G16)=\"\",\"\",(H16*G16))","v":159.12},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J16*I16)=\"\",\"\",(J16*I16))","v":{"v":11779.680013920002,"d":"$11,780"}}]
["108(e)","Discrimation Complaints","written",{"v":0.005,"d":"1%"},{"v":6.63,"d":"7 "},{"v":1,"d":"1.00"},{"v":6.63,"d":"7"},{"v":1,"d":"1.00"},6.63,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":490.82000058000006,"d":"$491"}]
["APPLICATION"]
["110(f)","Application Withdrawal","written",{"v":0.01,"d":"1%"},{"$f":"D19*$E$9","v":{"v":13.26,"d":"13 "}},{"v":1,"d":"1.00"},{"$f":"E19*F19","v":{"v":13.26,"d":"13"}},{"v":0.5,"d":"0.50"},{"$f":"IF((H19*G19)=\"\",\"\",(H19*G19))","v":6.63},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J19*I19)=\"\",\"\",(J19*I19))","v":{"v":490.82000058000006,"d":"$491"}}]
["112(f), (g)","SAM Registration & UEI","written",{"v":1,"d":"100%"},{"v":1326,"d":"1,326 "},{"v":1,"d":"1.00"},{"v":1326,"d":"1,326"},{"v":9.5,"d":"9.50"},{"v":12597,"d":"12,597.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":932558.0011020001,"d":"$932,558"}]
["116(b)","Feasibility Study (RES ONLY)","written",{"v":0.0125,"d":"1.25%"},{"$f":"D21*$C$9","v":{"v":12.850000000000001,"d":"13 "}},{"v":1,"d":"1.00"},{"v":12.850000000000001,"d":"13"},{"v":40,"d":"40.00"},{"v":514,"d":"514.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":38051.505324000005,"d":"$38,052"}]
["119(b)(1)","Application for Renewable Energy Systems and Energy Efficiency Improvements Projects, Total Project Costs of Less than $200,000 but greater than $80,000.","RD 4280-3B",{"v":1,"d":"100%"},{"v":1326,"d":"1,326 "},{"v":1,"d":"1.00"},{"v":1326,"d":"1,326"},{"v":10,"d":"10.00"},{"v":13260,"d":"13,260.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":981640.0011600001,"d":"$981,640"}]
["118(a)(6)","Environmental Documentation","written",{"v":1,"d":"100%"},{"v":1326,"d":"1,326 "},{"v":1,"d":"1.00"},{"v":1326,"d":"1,326"},{"v":5,"d":"5.00"},{"v":6630,"d":"6,630.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":490820.00058000005,"d":"$490,820"}]
["119(b)(4)","Technical Report","written",{"v":0.3,"d":"30%"},{"$f":"D24*$E$9","v":{"v":397.8,"d":"398 "}},{"v":1,"d":"1.00"},{"v":397.8,"d":"398"},{"v":8,"d":"8.00"},{"v":3182.4,"d":"3,182.40"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":235593.60027840003,"d":"$235,594"}]
["119(b)(4), 110(g)","Energy Assessment (EEI ONLY)","written",{"v":1,"d":"100%"},{"$f":"D25*$D$9","v":{"v":298,"d":"298 "}},{"v":1,"d":"1.00"},{"$f":"E25*F25","v":298},{"v":8,"d":"8.00"},{"$f":"IF((H25*G25)=\"\",\"\",(H25*G25))","v":{"v":2384,"d":"2,384.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J25*I25)=\"\",\"\",(J25*I25))","v":{"v":176487.91574400003,"d":"$176,488"}}]
["119(b), 121","Project Self Score ","written",{"v":1,"d":"100%"},{"$f":"D26*$E$9","v":{"v":1326,"d":"1,326 "}},{"v":1,"d":"1.00"},{"v":1326,"d":"1,326"},{"v":2,"d":"2.00"},{"v":2652,"d":"2,652.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":196328.00023200002,"d":"$196,328"}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["110(g)(2)","Technical Report Modifications","written",{"v":0.01,"d":"1%"},{"$f":"D28*$K$9","v":{"v":12.15,"d":"12 "}},{"v":1,"d":"1.00"},{"v":12.15,"d":"12"},{"v":1,"d":"1.00"},{"$f":"IF((H28*G28)=\"\",\"\",(H28*G28))","v":12.15},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J28*I28)=\"\",\"\",(J28*I28))","v":{"v":899.4665169000001,"d":"$899"}}]
["110(h)(1)","Time Extensions","written",{"v":0.05,"d":"5%"},{"v":60.75,"d":"61 "},{"v":1,"d":"1.00"},{"v":60.75,"d":"61"},{"v":0.5,"d":"0.50"},{"v":30.375,"d":"30.38"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":2248.6662922500004,"d":"$2,249"}]
["123(b)","Insurance","written",{"v":1,"d":"100%"},{"v":1215,"d":"1,215 "},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":89946.65169000001,"d":"$89,947"}]
["123(c)(2)","Request for Obligation of Funds","RD 1940-1",{"v":1,"d":"100%"},{"v":1215,"d":"1,215 "},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},0.25,303.75,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":22486.662922500003,"d":"$22,487"}]
["123(d)","Evidence of matching funds","written",{"v":1,"d":"100%"},{"v":1215,"d":"1,215 "},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":89946.65169000001,"d":"$89,947"}]
[" 123(e) ","SAM Renewal","written",{"v":1,"d":"100%"},{"v":1215,"d":"1,215 "},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":89946.65169000001,"d":"$89,947"}]
["123(f)","Rural Business Cooperative Service Financial Assistance Agreement","RD 4280-2 ",{"v":1,"d":"100%"},{"v":1215,"d":"1,215 "},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":89946.65169000001,"d":"$89,947"}]
["123(h)","Power purchase agreement (RES ONLY)","written",{"v":1,"d":"100%"},{"$f":"D35*$J$9","v":{"v":273,"d":"273 "}},{"v":1,"d":"1.00"},273,{"v":1.5,"d":"1.50"},{"v":409.5,"d":"409.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":30315.352977000002,"d":"$30,315"}]
["124(b)","Programmatic changes","written",{"v":0.005,"d":"1%"},{"v":6.075,"d":"6 "},{"v":1,"d":"1.00"},{"v":6.075,"d":"6"},{"v":1,"d":"1.00"},{"v":6.075,"d":"6.08"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":449.73325845000005,"d":"$450"}]
[null,"Certification for Contracts,Grants and Loans (Regarding Lobbying) - For grants over $100,000","written",{"v":0.5,"d":"50%"},{"v":607.5,"d":"608 "},{"v":1,"d":"1.00"},{"v":607.5,"d":"608"},0.25,{"v":151.875,"d":"151.88"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J37*I37)=\"\",\"\",(J37*I37))","v":{"v":11243.331461250002,"d":"$11,243"}}]
["119(d)(1)","Grantee acceptance of contractor work","written",{"v":1,"d":"100%"},{"v":1215,"d":"1,215 "},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},0.25,303.75,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":22486.662922500003,"d":"$22,487"}]
["119(d)(1) & (2)","Contractor Certification of Final Completion (Plus 30 days for RES only projects)","written",{"v":1,"d":"100%"},{"$f":"D39*$K$9","v":{"v":1215,"d":"1,215 "}},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":89946.65169000001,"d":"$89,947"}]
["125(a)(3)","Surety","written",{"v":0.05,"d":"5%"},{"v":60.75,"d":"61 "},{"v":1,"d":"1.00"},{"v":60.75,"d":"61"},{"v":1,"d":"1.00"},60.75,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":4497.332584500001,"d":"$4,497"}]
["125(d)","Final plans and specs ","written",{"v":0.05,"d":"5%"},{"v":60.75,"d":"61 "},{"v":1,"d":"1.00"},{"v":60.75,"d":"61"},{"v":2,"d":"2.00"},{"$f":"IF((H41*G41)=\"\",\"\",(H41*G41))","v":{"v":121.5,"d":"121.50"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J41*I41)=\"\",\"\",(J41*I41))","v":{"v":8994.665169000002,"d":"$8,995"}}]
["125(e )","Contruction Contract","written",{"v":0.05,"d":"5%"},{"v":60.75,"d":"61 "},{"v":1,"d":"1.00"},{"v":60.75,"d":"61"},{"v":2,"d":"2.00"},{"v":121.5,"d":"121.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":8994.665169000002,"d":"$8,995"}]
["124(a)","Inspection ","written",{"v":0.25,"d":"25%"},{"v":303.75,"d":"304 "},{"v":1,"d":"1.00"},{"v":303.75,"d":"304"},{"v":0.5,"d":"0.50"},{"v":151.875,"d":"151.88"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":11243.331461250002,"d":"$11,243"}]
["REPORTING AND OTHER"]
["124(c)","Transfer of ownership ","written",{"v":0.005,"d":"1%"},{"$f":"D45*$K$9","v":{"v":6.075,"d":"6 "}},{"v":1,"d":"1.00"},{"$f":"E45*F45","v":{"v":6.075,"d":"6"}},{"v":0.5,"d":"0.50"},{"$f":"IF((H45*G45)=\"\",\"\",(H45*G45))","v":{"v":3.0375,"d":"3.04"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J45*I45)=\"\",\"\",(J45*I45))","v":{"v":224.86662922500003,"d":"$225"}}]
["124(d)","Disposition/bi-annual check of acquired property ","written",{"v":0.25,"d":"25%"},{"$f":"D46*$K$9","v":{"v":303.75,"d":"304 "}},{"v":0.5,"d":"0.50"},{"v":151.875,"d":"152"},{"v":1,"d":"1.00"},{"v":151.875,"d":"151.88"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":11243.331461250002,"d":"$11,243"}]
["124(e) ","Recordkeeping","written",{"v":1,"d":"100%"},{"$f":"D47*$K$9","v":{"v":1215,"d":"1,215 "}},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":89946.65169000001,"d":"$89,947"}]
["124(f)","Audit requirement ","written",{"v":0.01,"d":"1%"},{"v":12.15,"d":"12 "},{"v":1,"d":"1.00"},{"v":12.15,"d":"12"},{"v":24,"d":"24.00"},{"v":291.6,"d":"291.60"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J48*I48)=\"\",\"\",(J48*I48))","v":{"v":21587.196405600003,"d":"$21,587"}}]
["124(i)(3)(i)","Annual outcome project performance certification-RES","4280-3D",{"v":1,"d":"100%"},{"$f":"D49*$I$9","v":{"v":942,"d":"942 "}},{"v":1,"d":"1.00"},942,0.25,{"v":235.5,"d":"235.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":17434.104093,"d":"$17,434"}]
["124(i)(3)(ii)","Annual outcome project performance certification-EEI","4280-3D",{"v":1,"d":"100%"},{"$f":"D50*$J$9","v":{"v":273,"d":"273 "}},{"v":1,"d":"1.00"},273,0.25,68.25,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":5052.558829500001,"d":"$5,053"}]
["124(i)(2)(i)","Project performance report - semiannual ","written",{"v":1,"d":"100%"},{"$f":"$K$9*D51","v":{"v":1215,"d":"1,215 "}},{"v":2,"d":"2.00"},{"v":2430,"d":"2,430"},{"v":2,"d":"2.00"},{"v":4860,"d":"4,860.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J51*I51)=\"\",\"\",(J51*I51))","v":{"v":359786.60676000005,"d":"$359,787"}}]
["124(i)(2)(ii) ","Final Project Performance Report","written",{"v":1,"d":"100%"},{"$f":"$K$9*D52","v":{"v":1215,"d":"1,215 "}},{"v":2,"d":"2.00"},{"$f":"E52*F52","v":{"v":2430,"d":"2,430"}},{"v":2,"d":"2.00"},{"v":4860,"d":"4,860.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":359786.60676000005,"d":"$359,787"}]

{"sheet":"12 Not Inc BH RES-EEI 80><200","index":4,"n_rows":27,"n_cols":11,"rows_kept":27}
["RURAL BUSINESS COOPERATIVE SERVICE"]
["RURAL ENERGY FOR AMERICA PROGRAM"]
["RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - $80K> <$200K"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570 - 0067"]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
[null,null,"RES","EEI","Total",{"$nulls":3},"RES","EEI","Total"]
["Estimated No. of Total Respondents (Applicants)",null,{"$f":"'12 BHCollection RES-EEI 80><200'!C9","v":{"v":1028,"d":"1,028 "}},{"$f":"'12 BHCollection RES-EEI 80><200'!D9","v":{"v":298,"d":"298 "}},{"$f":"SUM(C9:D9)","v":{"v":1326,"d":"1,326 "}},null,null,"Estimated No. of Total Awards (Awardees)",{"$f":"'12 BHCollection RES-EEI 80><200'!I9","v":{"v":942,"d":"942 "}},{"$f":"'12 BHCollection RES-EEI 80><200'!J9","v":{"v":273,"d":"273 "}},{"$f":"SUM(I9:J9)","v":{"v":1215,"d":"1,215 "}}]
["Average hours per response",{"$nulls":3},{"$f":"I12/G12","v":{"v":0.7553569382376533,"d":"0.755"}},{"$nulls":4},"Number of responses per respondent",{"$f":"G12/E9","v":{"v":9.872171945701357,"d":"9.87"}}]
[]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G15:G27)","v":{"v":13090.5,"d":"13,091"}},null,{"$f":"SUM(I15:I27)","v":{"v":9888,"d":"9,888"}},null,{"$f":"SUM(K15:K27)","v":{"v":732010.281408,"d":"$732,010"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference\n4280.XXX","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["APPLICATION"]
["118(a)(2)","Application for Federal Assistance","SF 424\n(4040-0004)",{"v":1,"d":"100%"},{"$f":"D16*$E$9","v":{"v":1326,"d":"1,326 "}},{"v":1,"d":"1.00"},{"$f":"E16*F16","v":{"v":1326,"d":"1,326"}},{"v":1,"d":"1.00"},{"$f":"IF((H16*G16)=\"\",\"\",(H16*G16))","v":{"v":1326,"d":"1,326.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J16*I16)=\"\",\"\",(J16*I16))","v":{"v":98164.00011600001,"d":"$98,164"}}]
["118(a)(3)","Budget Information - Construction Programs","SF 424C\n(4040-0008)",{"v":1,"d":"100%"},{"v":1326,"d":"1,326 "},{"v":1,"d":"1.00"},{"v":1326,"d":"1,326"},{"v":3,"d":"3.00"},{"v":3978,"d":"3,978.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":294492.00034800003,"d":"$294,492"}]
["118(a)(4)","Assurances - Construction Programs","SF 424D\n(4040-0009)",{"v":1,"d":"100%"},{"v":1326,"d":"1,326 "},{"v":1,"d":"1.00"},{"v":1326,"d":"1,326"},0.25,{"v":331.5,"d":"331.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":24541.000029000003,"d":"$24,541"}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["119(c)(3)(i); 120(c)(3)(i)","Compliance Statement (Contract in excess of $10,000)","RD-400-6\n(0575-0201, 0189)",{"v":0.5,"d":"50%"},{"$f":"D20*$K$9","v":{"v":607.5,"d":"608 "}},{"v":1,"d":"1.00"},{"$f":"E20*F20","v":{"v":607.5,"d":"608"}},0.25,{"$f":"IF((H20*G20)=\"\",\"\",(H20*G20))","v":{"v":151.875,"d":"151.88"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J20*I20)=\"\",\"\",(J20*I20))","v":{"v":11243.331461250002,"d":"$11,243"}}]
["119(d)(3)","Certificate of Contractor's Release","RD 1924-9 \n(0575-0042)",{"v":0.5,"d":"50%"},{"v":607.5,"d":"608 "},{"v":1,"d":"1.00"},{"v":607.5,"d":"608"},0.25,{"v":151.875,"d":"151.88"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":11243.331461250002,"d":"$11,243"}]
["119(d)(3)","Release by Claimants","RD 1924-10\n(0575-0189) ",{"v":0.5,"d":"50%"},{"v":607.5,"d":"608 "},{"v":1,"d":"1.00"},{"v":607.5,"d":"608"},{"v":1,"d":"1.00"},{"v":607.5,"d":"607.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":44973.32584500001,"d":"$44,973"}]
["123(c)(1)","Letter of Intent","RD 1942-46\n(0570-0021, 0061, 0062; 0572-0137; 0575-0015)",{"v":1,"d":"100%"},{"$f":"D23*$K$9","v":{"v":1215,"d":"1,215 "}},{"v":1,"d":"1.00"},{"$f":"E23*F23","v":{"v":1215,"d":"1,215"}},0.25,{"$f":"IF((H23*G23)=\"\",\"\",(H23*G23))","v":303.75},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J23*I23)=\"\",\"\",(J23*I23))","v":{"v":22486.662922500003,"d":"$22,487"}}]
["123(c)(3)","Disclosure of Lobbying Activities","SF LLL\n(4040-0013)",{"v":1,"d":"100%"},{"$f":"D24*$K$9","v":{"v":1215,"d":"1,215 "}},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},0.25,{"$f":"IF((H24*G24)=\"\",\"\",(H24*G24))","v":303.75},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J24*I24)=\"\",\"\",(J24*I24))","v":{"v":22486.662922500003,"d":"$22,487"}}]
["123(c)(4)","Assurance Agreement","RD-400-4\n(0575-0201, 0189)",{"v":1,"d":"100%"},{"v":1215,"d":"1,215 "},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},0.25,303.75,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":22486.662922500003,"d":"$22,487"}]
["124(i)(1)","Federal Financial Report ","SF 425\n(4040-0014)",{"v":1,"d":"100%"},{"v":1215,"d":"1,215 "},{"v":2,"d":"2.00"},{"v":2430,"d":"2,430"},{"v":0.5,"d":"0.50"},{"v":1215,"d":"1,215.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":89946.65169000001,"d":"$89,947"}]
["124(g)(4)","Outlay Report and Request for Reimbursement for Construction Programs","SF 271\n(4040-0011)",{"v":1,"d":"100%"},{"v":1215,"d":"1,215 "},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215"},{"v":1,"d":"1.00"},{"v":1215,"d":"1,215.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":89946.65169000001,"d":"$89,947"}]

{"sheet":"12 BHCollection RES-EEI >200","index":5,"n_rows":53,"n_cols":11,"rows_kept":53}
["RURAL BUSINESS COOPERATIVE SERVICE"]
["RURAL ENERGY FOR AMERICA PROGRAM"]
["RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - >$200K"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570 - 0067"]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
[null,null,"RES","EEI","Total",{"$nulls":3},"RES","EEI","Total"]
["Estimated No. of Total Respondents (Applicants)",null,{"v":1470,"d":"1,470 "},{"v":348,"d":"348 "},{"$f":"SUM(C9:D9)","v":{"v":1818,"d":"1,818 "}},null,null,"Estimated No. of Total Awards (Awardees)",{"v":1347,"d":"1,347"},319,{"$f":"SUM(I9:J9)","v":{"v":1666,"d":"1,666 "}}]
["Average hours per response",{"$nulls":3},{"$f":"I12/G12","v":{"v":3.657712033310405,"d":"3.658"}},{"$nulls":4},"Number of responses per respondent",{"$f":"G12/E9","v":{"v":20.927926292629262,"d":"20.93"}}]
[]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G15:G53)","v":{"v":38046.97,"d":"38,047"}},null,{"$f":"SUM(I15:I53)","v":{"v":139164.86,"d":"139,165"}},null,{"$f":"SUM(K15:K53)","v":{"v":10302397.68716676,"d":"10,302,398"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference\n4280.XXX","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["OTHER REQUIREMENTS"]
[105,"Reviews and appeals","written",{"v":0.005,"d":"0.50%"},{"$f":"D16*$E$9","v":{"v":9.09,"d":"9 "}},{"v":1,"d":"1.00"},{"$f":"E16*F16","v":{"v":9.09,"d":"9"}},{"v":12,"d":"12.00"},{"$f":"IF((H16*G16)=\"\",\"\",(H16*G16))","v":109.08},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J16*I16)=\"\",\"\",(J16*I16))","v":{"v":8075.2105072800005,"d":"$8,075"}}]
["108(e)","Discrimation Complaints","written",{"v":0.005,"d":"0.50%"},{"v":9.09,"d":"9 "},{"v":1,"d":"1.00"},{"v":9.09,"d":"9"},{"v":1,"d":"1.00"},9.09,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":672.9342089400001,"d":"$673"}]
["APPLICATION"]
["110(f)","Application Withdrawal","written",{"v":0.01,"d":"1%"},{"$f":"D19*$E$9","v":{"v":18.18,"d":"18 "}},{"v":1,"d":"1.00"},{"$f":"E19*F19","v":{"v":18.18,"d":"18"}},{"v":0.5,"d":"0.50"},{"$f":"IF((H19*G19)=\"\",\"\",(H19*G19))","v":9.09},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J19*I19)=\"\",\"\",(J19*I19))","v":{"v":672.9342089400001,"d":"$673"}}]
["112(f), (g)","SAM Registration & UEI","written",{"v":1,"d":"100%"},{"v":1818,"d":"1,818 "},{"v":1,"d":"1.00"},{"v":1818,"d":"1,818"},{"v":9.5,"d":"9.50"},{"v":17271,"d":"17,271.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":1278574.996986,"d":"$1,278,575"}]
["116(b)","Feasibility Study (RES ONLY)","written",{"v":0.04,"d":"4%"},{"$f":"D21*$C$9","v":{"v":58.800000000000004,"d":"59 "}},{"v":1,"d":"1.00"},{"v":58.800000000000004,"d":"59"},{"v":40,"d":"40.00"},{"v":2352,"d":"2,352.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":174118.950432,"d":"$174,119"}]
["118(a)(1)","Application for Renewable Energy Systems and Energy Efficiency Improvements Projects, Total Project Costs greater than $200,000.","RD 4280-3C",{"v":1,"d":"100%"},{"v":1818,"d":"1,818 "},{"v":1,"d":"1.00"},{"v":1818,"d":"1,818"},{"v":30,"d":"30.00"},{"v":54540,"d":"54,540.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":4037605.2536400002,"d":"$4,037,605"}]
["118(a)(6)","Environmental Documentation","written",{"v":1,"d":"100%"},{"v":1818,"d":"1,818 "},{"v":1,"d":"1.00"},{"v":1818,"d":"1,818"},{"v":6,"d":"6.00"},{"v":10908,"d":"10,908.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":807521.0507280001,"d":"$807,521"}]
["118(d)","Technical Report","written",{"v":0.36,"d":"36%"},{"$f":"D24*$E$9","v":{"v":654.48,"d":"654 "}},{"v":1,"d":"1.00"},{"v":654.48,"d":"654"},{"v":16,"d":"16.00"},{"v":10471.68,"d":"10,471.68"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":775220.2086988802,"d":"$775,220"}]
["118(d), 110(g)","Energy Audit (EEI ONLY)","written",{"v":1,"d":"100%"},{"$f":"D25*$D$9","v":{"v":348,"d":"348 "}},{"v":1,"d":"1.00"},{"$f":"E25*F25","v":348},{"v":16,"d":"16.00"},{"$f":"IF((H25*G25)=\"\",\"\",(H25*G25))","v":{"v":5568,"d":"5,568.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J25*I25)=\"\",\"\",(J25*I25))","v":{"v":412199.964288,"d":"$412,200"}}]
["118, 121","Project Self Score ","written",{"v":1,"d":"100%"},{"$f":"D26*$E$9","v":{"v":1818,"d":"1,818 "}},{"v":1,"d":"1.00"},{"v":1818,"d":"1,818"},{"v":2,"d":"2.00"},{"v":3636,"d":"3,636.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":269173.68357600004,"d":"$269,174"}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["110(g)(2)","Technical Report Modifications","written",{"v":0.01,"d":"1%"},{"$f":"D28*$K$9","v":{"v":16.66,"d":"17 "}},{"v":1,"d":"1.00"},{"v":16.66,"d":"17"},{"v":1,"d":"1.00"},{"$f":"IF((H28*G28)=\"\",\"\",(H28*G28))","v":16.66},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J28*I28)=\"\",\"\",(J28*I28))","v":{"v":1233.3425655600001,"d":"$1,233"}}]
["110(h)(1)","Time Extensions","written",{"v":0.05,"d":"5%"},{"v":83.30000000000001,"d":"83 "},{"v":1,"d":"1.00"},{"v":83.30000000000001,"d":"83"},{"v":0.5,"d":"0.50"},{"v":41.650000000000006,"d":"41.65"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":3083.356413900001,"d":"$3,083"}]
["123(b)","Insurance","written",{"v":1,"d":"100%"},{"v":1666,"d":"1,666 "},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":123334.25655600001,"d":"$123,334"}]
["123(c)(2)","Request for Obligation of Funds","RD 1940-1",{"v":1,"d":"100%"},{"v":1666,"d":"1,666 "},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},0.25,{"v":416.5,"d":"416.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":30833.564139000002,"d":"$30,834"}]
["123(d)","Evidence of matching funds","written",{"v":1,"d":"100%"},{"v":1666,"d":"1,666 "},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":123334.25655600001,"d":"$123,334"}]
[" 123(e) ","SAM Renewal","written",{"v":1,"d":"100%"},{"v":1666,"d":"1,666 "},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":123334.25655600001,"d":"$123,334"}]
["123(f)","Rural Business Cooperative Service Financial Assistance Agreement","RD 4280-2 ",{"v":1,"d":"100%"},{"v":1666,"d":"1,666 "},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":123334.25655600001,"d":"$123,334"}]
["123(h)","Power purchase agreement (RES ONLY)","written",{"v":1,"d":"100%"},{"$f":"D35*$I$9","v":{"v":1347,"d":"1,347 "}},{"v":1,"d":"1.00"},{"v":1347,"d":"1,347"},{"v":1.5,"d":"1.50"},{"v":2020.5,"d":"2,020.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":149577.95040300002,"d":"$149,578"}]
["124(b)","Programmatic changes","written",{"v":0.005,"d":"0.50%"},{"v":8.33,"d":"8 "},{"v":1,"d":"1.00"},{"v":8.33,"d":"8"},{"v":1,"d":"1.00"},8.33,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":616.6712827800001,"d":"$617"}]
[null,"Certification for Contracts,Grants and Loans (Regarding Lobbying) - For grants over $100,000","written",{"v":0.75,"d":"75%"},{"v":1249.5,"d":"1,250 "},{"v":1,"d":"1.00"},{"v":1249.5,"d":"1,250"},0.25,{"v":312.375,"d":"312.38"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":23125.173104250003,"d":"$23,125"}]
[null,"Grantee acceptance of contractor work","written",{"v":1,"d":"100%"},{"v":1666,"d":"1,666 "},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},0.25,{"v":416.5,"d":"416.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":30833.564139000002,"d":"$30,834"}]
["119(d)(2), 120(d)(1)","Contractor Certification of Final Completion (Plus 30 days for RES only projects)","written",{"v":1,"d":"100%"},{"$f":"D39*$K$9","v":{"v":1666,"d":"1,666 "}},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":123334.25655600001,"d":"$123,334"}]
["125(a)(3)","Surety","written",{"v":0.1,"d":"10%"},{"v":166.60000000000002,"d":"167 "},{"v":1,"d":"1.00"},{"v":166.60000000000002,"d":"167"},{"v":1,"d":"1.00"},{"v":166.60000000000002,"d":"166.60"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":12333.425655600004,"d":"$12,333"}]
["125(c) ","Technical services  (for total project cost $1,000,000 or greater)","written",{"v":0.4,"d":"40%"},{"v":666.4000000000001,"d":"666 "},{"v":4,"d":"4.00"},{"v":2665.6000000000004,"d":"2,666"},{"v":1,"d":"1.00"},{"v":2665.6000000000004,"d":"2,665.60"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J41*I41)=\"\",\"\",(J41*I41))","v":{"v":197334.81048960006,"d":"$197,335"}}]
["125(d)","Final plans and specs ","written",{"v":0.1,"d":"10%"},{"v":166.60000000000002,"d":"167 "},{"v":1,"d":"1.00"},{"v":166.60000000000002,"d":"167"},{"v":2,"d":"2.00"},{"v":333.20000000000005,"d":"333.20"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":24666.851311200007,"d":"$24,667"}]
["125(e )","Contruction Contract","written",{"v":1,"d":"100%"},{"v":1666,"d":"1,666 "},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},{"v":2,"d":"2.00"},{"v":3332,"d":"3,332.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":246668.51311200002,"d":"$246,669"}]
["124(a)","Inspection ","written",{"v":0.25,"d":"25%"},{"v":416.5,"d":"417 "},{"v":1,"d":"1.00"},{"v":416.5,"d":"417"},{"v":0.5,"d":"0.50"},208.25,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":15416.782069500001,"d":"$15,417"}]
["REPORTING AND OTHER"]
["124(c)","Transfer of ownership ","written",{"v":0.005,"d":"1%"},{"$f":"D46*$K$9","v":{"v":8.33,"d":"8 "}},{"v":1,"d":"1.00"},{"$f":"E46*F46","v":{"v":8.33,"d":"8"}},{"v":0.5,"d":"0.50"},{"$f":"IF((H46*G46)=\"\",\"\",(H46*G46))","v":{"v":4.165,"d":"4.17"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J46*I46)=\"\",\"\",(J46*I46))","v":{"v":308.33564139000003,"d":"$308"}}]
["124(d)","Disposition/bi-annual check of acquired property ","written",{"v":0.25,"d":"25%"},{"$f":"D47*$K$9","v":{"v":416.5,"d":"417 "}},{"v":0.5,"d":"0.50"},{"v":208.25,"d":"208"},{"v":1,"d":"1.00"},208.25,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":15416.782069500001,"d":"$15,417"}]
["124(e) ","Recordkeeping","written",{"v":1,"d":"100%"},{"$f":"D48*$K$9","v":{"v":1666,"d":"1,666 "}},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":123334.25655600001,"d":"$123,334"}]
["124(f)","Audit requirement","written",{"v":0.01,"d":"1%"},{"v":16.66,"d":"17 "},{"v":1,"d":"1.00"},{"v":16.66,"d":"17"},{"v":24,"d":"24.00"},{"v":399.84000000000003,"d":"399.84"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J49*I49)=\"\",\"\",(J49*I49))","v":{"v":29600.221573440005,"d":"$29,600"}}]
["124(i)(3)(i)","Annual outcome project performance certification-RES","4280-3D",{"v":1,"d":"100%"},{"$f":"D50*$I$9","v":{"v":1347,"d":"1,347 "}},{"v":1,"d":"1.00"},{"v":1347,"d":"1,347"},0.25,336.75,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":24929.658400500004,"d":"$24,930"}]
["124(i)(3)(ii)","Annual outcome project performance certification-EEI","4280-3D",{"v":1,"d":"100%"},{"$f":"D51*$J$9","v":{"v":319,"d":"319 "}},{"v":1,"d":"1.00"},319,0.25,79.75,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":5903.905738500001,"d":"$5,904"}]
["124(i)(2)(i)","Project performance report - semiannual ","written",{"v":1,"d":"100%"},{"$f":"$K$9*D52","v":{"v":1666,"d":"1,666 "}},{"v":2,"d":"2.00"},{"v":3332,"d":"3,332"},{"v":2,"d":"2.00"},{"v":6664,"d":"6,664.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J52*I52)=\"\",\"\",(J52*I52))","v":{"v":493337.02622400003,"d":"$493,337"}}]
["124(i)(2)(ii) ","Final Project Performance Report","written",{"v":1,"d":"100%"},{"$f":"$K$9*D53","v":{"v":1666,"d":"1,666 "}},{"v":2,"d":"2.00"},{"$f":"E53*F53","v":{"v":3332,"d":"3,332"}},{"v":2,"d":"2.00"},{"v":6664,"d":"6,664.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":493337.02622400003,"d":"$493,337"}]

{"sheet":"12 Not Inc BH RES-EEI >200","index":6,"n_rows":27,"n_cols":11,"rows_kept":27}
["RURAL BUSINESS COOPERATIVE SERVICE"]
["RURAL ENERGY FOR AMERICA PROGRAM"]
["RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - >$200K"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570 - 0067"]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
[null,null,"RES","EEI","Total",{"$nulls":3},"RES","EEI","Total"]
["Estimated No. of Total Respondents (Applicants)",null,{"$f":"'12 BHCollection RES-EEI >200'!C9","v":{"v":1470,"d":"1,470 "}},{"$f":"'12 BHCollection RES-EEI >200'!D9","v":{"v":348,"d":"348 "}},{"$f":"SUM(C9:D9)","v":{"v":1818,"d":"1,818 "}},null,null,"Estimated No. of Total Awards (Awardees)",{"$f":"'12 BHCollection RES-EEI >200'!I9","v":{"v":1347,"d":"1,347 "}},{"$f":"'12 BHCollection RES-EEI >200'!J9","v":{"v":319,"d":"319 "}},{"$f":"SUM(I9:J9)","v":{"v":1666,"d":"1,666 "}}]
["Average hours per response",{"$nulls":3},{"$f":"I12/G12","v":{"v":0.8160805558513471,"d":"0.816"}},{"$nulls":4},"Number of responses per respondent",{"$f":"G12/E9","v":{"v":10.331133113311331,"d":"10.33"}}]
[]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G15:G27)","v":{"v":18782,"d":"18,782"}},null,{"$f":"SUM(I15:I27)","v":{"v":15327.625,"d":"15,328"}},null,{"$f":"SUM(K15:K27)","v":{"v":1134706.6231357502,"d":"$1,134,707"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference\n4280.XXX","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["APPLICATION"]
["118(a)(2)","Application for Federal Assistance","SF 424\n(4040-0004)",{"v":1,"d":"100%"},{"$f":"D16*$E$9","v":{"v":1818,"d":"1,818 "}},{"v":1,"d":"1.00"},{"$f":"E16*F16","v":{"v":1818,"d":"1,818"}},{"v":1,"d":"1.00"},{"$f":"IF((H16*G16)=\"\",\"\",(H16*G16))","v":{"v":1818,"d":"1,818.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J16*I16)=\"\",\"\",(J16*I16))","v":{"v":134586.84178800002,"d":"$134,587"}}]
["118(a)(3)","Budget Information - Construction Programs","SF 424C\n(4040-0008)",{"v":1,"d":"100%"},{"v":1818,"d":"1,818 "},{"v":1,"d":"1.00"},{"v":1818,"d":"1,818"},{"v":3,"d":"3.00"},{"v":5454,"d":"5,454.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":403760.52536400006,"d":"$403,761"}]
["118(a)(4)","Assurances - Construction Programs","SF 424D\n(4040-0009)",{"v":1,"d":"100%"},{"v":1818,"d":"1,818 "},{"v":1,"d":"1.00"},{"v":1818,"d":"1,818"},0.25,{"v":454.5,"d":"454.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":33646.710447000005,"d":"$33,647"}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["119(c)(3)(i); 120(c)(3)(i)","Compliance Statement (Contract in excess of $10,000)","RD-400-6\n(0575-0201, 0189)",{"v":0.75,"d":"75%"},{"$f":"D20*$K$9","v":{"v":1249.5,"d":"1,250 "}},{"v":1,"d":"1.00"},{"$f":"E20*F20","v":{"v":1249.5,"d":"1,250"}},0.25,{"$f":"IF((H20*G20)=\"\",\"\",(H20*G20))","v":{"v":312.375,"d":"312.38"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J20*I20)=\"\",\"\",(J20*I20))","v":{"v":23125.173104250003,"d":"$23,125"}}]
[null,"Certificate of Contractor's Release","RD 1924-9 \n(0575-0042)",{"v":0.75,"d":"75%"},{"v":1249.5,"d":"1,250 "},{"v":1,"d":"1.00"},{"v":1249.5,"d":"1,250"},0.25,{"v":312.375,"d":"312.38"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":23125.173104250003,"d":"$23,125"}]
[null,"Release by Claimants","RD 1924-10\n(0575-0189) ",{"v":0.75,"d":"75%"},{"v":1249.5,"d":"1,250 "},{"v":1,"d":"1.00"},{"v":1249.5,"d":"1,250"},{"v":1,"d":"1.00"},{"v":1249.5,"d":"1,249.50"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":92500.69241700001,"d":"$92,501"}]
["123(c)(1)","Letter of Intent","RD 1942-46\n(0570-0021, 0061, 0062; 0572-0137; 0575-0015)",{"v":1,"d":"100%"},{"$f":"D23*$K$9","v":{"v":1666,"d":"1,666 "}},{"v":1,"d":"1.00"},{"$f":"E23*F23","v":{"v":1666,"d":"1,666"}},{"v":1,"d":"1.00"},{"$f":"IF((H23*G23)=\"\",\"\",(H23*G23))","v":{"v":1666,"d":"1,666.00"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J23*I23)=\"\",\"\",(J23*I23))","v":{"v":123334.25655600001,"d":"$123,334"}}]
["123(c)(3)","Disclosure of Lobbying Activities","SF LLL\n(4040-0013)",{"v":1,"d":"100%"},{"$f":"D24*$K$9","v":{"v":1666,"d":"1,666 "}},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},0.25,{"$f":"IF((H24*G24)=\"\",\"\",(H24*G24))","v":{"v":416.5,"d":"416.50"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J24*I24)=\"\",\"\",(J24*I24))","v":{"v":30833.564139000002,"d":"$30,834"}}]
["123(c)(4)","Assurance Agreement","RD-400-4\n(0575-0201, 0189)",{"v":0.75,"d":"75%"},{"v":1249.5,"d":"1,250 "},{"v":1,"d":"1.00"},{"v":1249.5,"d":"1,250"},0.25,{"v":312.375,"d":"312.38"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":23125.173104250003,"d":"$23,125"}]
["124(i)(1)","Federal Financial Report ","SF 425\n(4040-0014)",{"v":1,"d":"100%"},{"v":1666,"d":"1,666 "},{"v":2,"d":"2.00"},{"v":3332,"d":"3,332"},{"v":0.5,"d":"0.50"},{"v":1666,"d":"1,666.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":123334.25655600001,"d":"$123,334"}]
["124(g)(4)","Outlay Report and Request for Reimbursement for Construction Programs","SF 271\n(4040-0011)",{"v":1,"d":"100%"},{"v":1666,"d":"1,666 "},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666"},{"v":1,"d":"1.00"},{"v":1666,"d":"1,666.00"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":123334.25655600001,"d":"$123,334"}]

{"sheet":"12 BHCollection EA REDA","index":7,"n_rows":36,"n_cols":11,"rows_kept":36}
["RURAL BUSINESS COOPERATIVE SERVICE"]
["RURAL ENERGY FOR AMERICA PROGRAM"]
["ENERGY AUDIT (EA) AND RENEWABLE ENERGY DEVELOPMENT ASSITANCE (REDA)"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570 - 0067"]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"v":28,"d":"28 "},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",22]
["Average hours per response",null,{"$f":"I10/G10","v":{"v":3.2318401287553646,"d":"3.232"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G10/C8","v":{"v":10.651428571428571,"d":"10.65"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G14:G32)","v":{"v":298.24,"d":"298"}},null,{"$f":"SUM(I14:I32)","v":{"v":963.864,"d":"964"}},null,{"$f":"SUM(K14:K32)","v":{"v":71355.01192142401,"d":"$71,355"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference\n4280.XXX","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["OTHER REQUIREMENTS"]
[105,"Reviews and appeals","written",{"v":0.04,"d":"4.0%"},{"$f":"$C$8*D14","v":{"v":1.12,"d":"1 "}},{"v":1,"d":"1 "},{"$f":"E14*F14","v":{"v":1.12,"d":"1"}},{"v":12,"d":"12.00"},{"$f":"IF((H14*G14)=\"\",\"\",(H14*G14))","v":{"v":13.440000000000001,"d":"13"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J14*I14)=\"\",\"\",(J14*I14))","v":{"v":994.9654310400002,"d":"$995"}}]
["108(e)","Discrimation Complaints","written",{"v":0.04,"d":"4.0%"},{"$f":"D15*$C$8","v":{"v":1.12,"d":"1 "}},{"v":1,"d":"1 "},{"$f":"E15*F15","v":{"v":1.12,"d":"1"}},{"v":1,"d":"1.00"},{"v":1.12,"d":"1"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":82.91378592000002,"d":"$83"}]
["APPLICATION"]
["110(f)","Application Withdrawal","written",{"v":0.04,"d":"4%"},{"v":1.12,"d":"1 "},{"v":1,"d":"1 "},{"v":1.12,"d":"1"},{"v":0.5,"d":"0.50"},{"$f":"IF((H17*G17)=\"\",\"\",(H17*G17))","v":{"v":0.56,"d":"1"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J17*I17)=\"\",\"\",(J17*I17))","v":{"v":41.45689296000001,"d":"$41"}}]
["112(f), (g)","SAM number & UEI","written",{"v":1,"d":"100%"},{"v":28,"d":"28 "},{"v":1,"d":"1 "},28,{"v":9.5,"d":"9.50"},266,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":19692.024156000003,"d":"$19,692"}]
["153(b)(3)","Data to Assist in Assessment of USDA Compliance with Civil Rights Laws","written",{"v":1,"d":"100%"},{"v":28,"d":"28 "},{"v":1,"d":"1 "},28,0.08,{"v":2.24,"d":"2"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":165.82757184000005,"d":"$166"}]
["153(b)(4)","Certification that Applicant is a legal entity in good standing","written",{"v":1,"d":"100%"},{"v":28,"d":"28 "},{"v":1,"d":"1 "},28,{"v":0.083,"d":"0.08"},{"v":2.3240000000000003,"d":"2"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":172.04610578400005,"d":"$172"}]
["153(b)(5)","Association or Relationship with Rural Development Employees Certification","written",{"v":1,"d":"100%"},{"v":28,"d":"28 "},{"v":1,"d":"1 "},28,0.08,{"v":2.24,"d":"2"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":165.82757184000005,"d":"$166"}]
["153(b)(6)","Scope of work ","written",{"v":1,"d":"100%"},{"v":28,"d":"28 "},{"v":1,"d":"1 "},28,{"v":20,"d":"20.00"},560,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":41456.892960000005,"d":"$41,457"}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["158(a)","Insurance","written",{"v":1,"d":"100%"},{"$f":"D24*$K$8","v":{"v":22,"d":"22 "}},{"v":1,"d":"1 "},{"$f":"E24*F24","v":22},{"v":0.5,"d":"0.50"},{"$f":"IF((H24*G24)=\"\",\"\",(H24*G24))","v":11},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J24*I24)=\"\",\"\",(J24*I24))","v":{"v":814.3318260000001,"d":"$814"}}]
["123(c)(2)","Request for Obligation of Funds","RD 1940-1",{"v":1,"d":"100%"},{"$f":"D25*$K$8","v":{"v":22,"d":"22 "}},{"v":1,"d":"1 "},22,0.25,{"$f":"IF((H25*G25)=\"\",\"\",(H25*G25))","v":{"v":5.5,"d":"6"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J25*I25)=\"\",\"\",(J25*I25))","v":{"v":407.16591300000005,"d":"$407"}}]
["123(d)","Evidence of matching funds","written",{"v":1,"d":"100%"},{"v":22,"d":"22 "},{"v":1,"d":"1 "},22,{"v":1,"d":"1.00"},22,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":1628.6636520000002,"d":"$1,629"}]
["149(d)(2)","SAM Renewal","written",{"v":1,"d":"100%"},{"$f":"D27*$K$8","v":{"v":22,"d":"22 "}},{"v":1,"d":"1 "},22,{"v":1,"d":"1.00"},22,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":1628.6636520000002,"d":"$1,629"}]
["123(f)","Rural Business Cooperative Service Financial Assistance Agreement","RD 4280-2 ",{"v":1,"d":"100%"},{"v":22,"d":"22 "},{"v":1,"d":"1 "},22,{"v":1,"d":"1.00"},22,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":1628.6636520000002,"d":"$1,629"}]
["124(b)","Programmatic changes","written",{"v":1,"d":"100%"},{"v":22,"d":"22 "},{"v":1,"d":"1 "},22,{"v":0.5,"d":"0.50"},11,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J29*I29)=\"\",\"\",(J29*I29))","v":{"v":814.3318260000001,"d":"$814"}}]
["REPORTING AND OTHER"]
["124(c)","Transfer of ownership ","written",{"v":0.04,"d":"4%"},{"$f":"D31*$K$8","v":{"v":0.88,"d":"1 "}},{"v":1,"d":"1 "},{"$f":"E31*F31","v":{"v":0.88,"d":"1"}},{"v":0.5,"d":"0.50"},{"$f":"IF((H31*G31)=\"\",\"\",(H31*G31))","v":{"v":0.44,"d":"0"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J31*I31)=\"\",\"\",(J31*I31))","v":{"v":32.573273040000004,"d":"$33"}}]
["124 (e)","Recordkeeping","written",{"v":1,"d":"100%"},{"$f":"D32*$K$8","v":{"v":22,"d":"22 "}},{"v":1,"d":"1 "},22,{"v":1,"d":"1.00"},22,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":1628.6636520000002,"d":"$1,629"}]
["159 & 124(f)","Audit requirement","written",{"v":0.04,"d":"4%"},{"$f":"D33*$K$8","v":{"v":0.88,"d":"1 "}},{"v":1,"d":"1 "},{"$f":"E33*F33","v":{"v":0.88,"d":"1"}},{"v":24,"d":"24.00"},{"$f":"IF((H33*G33)=\"\",\"\",(H33*G33))","v":{"v":21.12,"d":"21"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J33*I33)=\"\",\"\",(J33*I33))","v":{"v":1563.5171059200002,"d":"$1,564"}}]
["159(d)","Annual outcome project performance certification","4280-3D",{"v":1,"d":"100%"},{"v":22,"d":"22 "},{"v":1,"d":"1 "},22,{"v":1,"d":"1.00"},22,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":1628.6636520000002,"d":"$1,629"}]
["159 (b)","Project performance report - semiannual ","written",{"v":1,"d":"100%"},{"v":22,"d":"22 "},{"v":2,"d":"2 "},44,{"v":1,"d":"1.00"},44,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":3257.3273040000004,"d":"$3,257"}]
["159 (c)","Final Project Performance Report ","written",{"v":1,"d":"100%"},{"v":22,"d":"22 "},{"v":1,"d":"1 "},22,{"v":1,"d":"1.00"},22,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":1628.6636520000002,"d":"$1,629"}]

{"sheet":"12 Not Inc BH EA REDA","index":8,"n_rows":21,"n_cols":11,"rows_kept":21}
[{"$f":"'12 BHCollection EA REDA'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 BHCollection EA REDA'!A2","v":"RURAL ENERGY FOR AMERICA PROGRAM"}]
[{"$f":"'12 BHCollection EA REDA'!A3","v":"ENERGY AUDIT (EA) AND RENEWABLE ENERGY DEVELOPMENT ASSITANCE (REDA)"}]
[{"$f":"'12 BHCollection EA REDA'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BHCollection EA REDA'!A5","v":"OMB # 0570 - 0067"}]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"$f":"'12 BHCollection EA REDA'!C8","v":{"v":28,"d":"28 "}},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",{"$f":"'12 BHCollection EA REDA'!K8","v":22}]
["Average hours per response",null,{"$f":"I10/G10","v":{"v":1.1558695652173911,"d":"1.156"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G10/C8","v":{"v":9.857142857142858,"d":"9.86"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G14:G21)","v":276},null,{"$f":"SUM(I14:I21)","v":{"v":319.02,"d":"319"}},null,{"$f":"SUM(K14:K21)","v":{"v":23617.103557320002,"d":"$23,617"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference\n4280.XXX","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["APPLICATION"]
["153 (b)(1)","Application for Federal Assistance","SF 424\n(4040-0004)",{"v":1,"d":"100%"},{"$f":"D14*$C$8","v":28},1,{"$f":"E14*F14","v":28},1,{"$f":"IF((H14*G14)=\"\",\"\",(H14*G14))","v":28},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J14*I14)=\"\",\"\",(J14*I14))","v":{"v":2072.8446480000002,"d":"$2,073"}}]
["153 (b)(2)","Budget Information - Non-Construction Programs","SF 424A\n(4040-0006)",{"v":1,"d":"100%"},{"$f":"D15*$C$8","v":28},1,{"$f":"E15*F15","v":28},3,{"$f":"IF((H15*G15)=\"\",\"\",(H15*G15))","v":84},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J15*I15)=\"\",\"\",(J15*I15))","v":{"v":6218.533944000001,"d":"$6,219"}}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["123(c)(1)","Letter of Intent","RD 1942-46\n(0570-0021, 0061, 0062; 0572-0137; 0575-0015)",{"v":1,"d":"100%"},{"$f":"D17*$K$8","v":{"v":22,"d":"22 "}},{"v":1,"d":"1 "},{"$f":"E17*F17","v":22},{"v":1,"d":"1.00"},{"$f":"IF((H17*G17)=\"\",\"\",(H17*G17))","v":22},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J17*I17)=\"\",\"\",(J17*I17))","v":{"v":1628.6636520000002,"d":"$1,629"}}]
["123(c)(3)","Disclosure of Lobbying Activities","SF LLL\n(4040-0013)",{"v":1,"d":"100%"},{"$f":"D18*$K$8","v":22},1,{"$f":"E18*F18","v":22},0.16,{"$f":"IF((H18*G18)=\"\",\"\",(H18*G18))","v":{"v":3.52,"d":"4"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J18*I18)=\"\",\"\",(J18*I18))","v":{"v":260.58618432000003,"d":"$261"}}]
[158,"Assurance Agrement","RD-400-4\n(0575-0201, 0189)",{"v":1,"d":"100%"},{"$f":"D19*$K$8","v":{"v":22,"d":"22 "}},{"v":1,"d":"1 "},{"$f":"E19*F19","v":22},0.25,{"$f":"IF((H19*G19)=\"\",\"\",(H19*G19))","v":{"v":5.5,"d":"6"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J19*I19)=\"\",\"\",(J19*I19))","v":{"v":407.16591300000005,"d":"$407"}}]
["124(i)(1)","Federal Financial Report ","SF 425\n(4040-0014)",{"v":1,"d":"100%"},{"$f":"D20*$K$8","v":22},2,{"$f":"E20*F20","v":44},1.5,{"$f":"IF((H20*G20)=\"\",\"\",(H20*G20))","v":66},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J20*I20)=\"\",\"\",(J20*I20))","v":{"v":4885.990956000001,"d":"$4,886"}}]
["159 (a)","Request for Advance or Reimbursement","SF-270 \n(4040-0012)",{"v":1,"d":"100%"},{"$f":"D21*$K$8","v":22},5,{"$f":"E21*F21","v":110},1,{"$f":"IF((H21*G21)=\"\",\"\",(H21*G21))","v":110},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J21*I21)=\"\",\"\",(J21*I21))","v":{"v":8143.318260000001,"d":"$8,143"}}]

{"sheet":"12 BHCollection TAG","index":9,"n_rows":25,"n_cols":11,"rows_kept":25}
["RURAL BUSINESS COOPERATIVE SERVICE"]
["RURAL ENERGY FOR AMERICA PROGRAM"]
["TECHNICAL ASSISTANCE GRANT PROGRAM"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570 - 0067"]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"v":389,"d":"389 "},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",116]
["Average hours per response",null,{"$f":"I10/G10","v":{"v":2.764389358108108,"d":"2.764"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G10/C8","v":{"v":6.087403598971722,"d":"6.09"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G13:G25)","v":{"v":2368,"d":"2,368"}},null,{"$f":"SUM(I13:I25)","v":{"v":6546.074,"d":"6,546"}},null,{"$f":"SUM(K13:K25)","v":{"v":484606.94486828404,"d":"$484,607"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["REAP TAG NOFO Reference","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["APPLICATION"]
["Sec. D.3","SAM Registration & UEI","written",{"v":1,"d":"100%"},{"$f":"D14*$C$8","v":{"v":389,"d":"389 "}},{"v":1,"d":"1 "},{"$f":"E14*F14","v":389},{"v":9.5,"d":"9.50"},{"$f":"IF((H14*G14)=\"\",\"\",(H14*G14))","v":{"v":3695.5,"d":"3,696"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J14*I14)=\"\",\"\",(J14*I14))","v":{"v":273578.478453,"d":"$273,578"}}]
["Sec. D.2(e)","Certification that Applicant is a legal entity in good standing","written",{"v":1,"d":"100%"},{"v":389,"d":"389 "},{"v":1,"d":"1 "},389,{"v":0.083,"d":"0.08"},{"v":32.287,"d":"32"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":2390.211969642,"d":"$2,390"}]
["Sec. D.2(f)","Association or Relationship with Rural Development Employees Certification","written",{"v":1,"d":"100%"},{"v":389,"d":"389 "},{"v":1,"d":"1 "},389,{"v":0.083,"d":"0.08"},{"v":32.287,"d":"32"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":2390.211969642,"d":"$2,390"}]
["Sec. D.2(g)","Scope of Work","written",{"v":1,"d":"100%"},{"v":389,"d":"389 "},{"v":1,"d":"1 "},389,{"v":5,"d":"5.00"},{"v":1945,"d":"1,945"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":143988.67287,"d":"$143,989"}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["Sec. F.2(a)","Request for Obligation of Funds","RD 1940-1",{"v":1,"d":"100%"},{"$f":"D19*$K$8","v":{"v":116,"d":"116 "}},{"v":1,"d":"1 "},116,0.25,{"$f":"IF((H19*G19)=\"\",\"\",(H19*G19))","v":29},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J19*I19)=\"\",\"\",(J19*I19))","v":{"v":2146.8748140000002,"d":"$2,147"}}]
[null,"RBCS Financial Assistance Agreement","RD 4280-2",{"v":1,"d":"100%"},{"$f":"D20*$K$8","v":{"v":116,"d":"116 "}},{"v":1,"d":"1 "},116,{"v":2,"d":"2.00"},232,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":17174.998512000002,"d":"$17,175"}]
["Sec. D.3","SAM Renewal","written",{"v":1,"d":"100%"},{"$f":"D21*$K$8","v":{"v":116,"d":"116 "}},{"v":1,"d":"1 "},{"$f":"E21*F21","v":116},{"v":1,"d":"1.00"},{"$f":"IF((H21*G21)=\"\",\"\",(H21*G21))","v":116},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J21*I21)=\"\",\"\",(J21*I21))","v":{"v":8587.499256000001,"d":"$8,587"}}]
["REPORTING AND OTHER"]
["Sec. F.4(a)(1)","Project performance report - semiannual","written",{"v":1,"d":"100%"},{"v":116,"d":"116 "},{"v":2,"d":"2 "},232,{"v":1,"d":"1.00"},232,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":17174.998512000002,"d":"$17,175"}]
["Sec. F.4(a)(2)","Final Project Status Report","written",{"v":1,"d":"100%"},{"v":116,"d":"116 "},{"v":1,"d":"1 "},116,{"v":1,"d":"1.00"},116,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":8587.499256000001,"d":"$8,587"}]
["Sec. F.4(a)(3)","Annual outcome project performance certification","written",{"v":1,"d":"100%"},{"v":116,"d":"116 "},{"v":1,"d":"1 "},116,{"v":1,"d":"1.00"},116,{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":8587.499256000001,"d":"$8,587"}]

{"sheet":"12 Not Inc BH TAG","index":10,"n_rows":22,"n_cols":11,"rows_kept":22}
[{"$f":"'12 BHCollection EA REDA'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 BHCollection EA REDA'!A2","v":"RURAL ENERGY FOR AMERICA PROGRAM"}]
["TECHNICAL ASSISTANCE GRANT PROGRAM"]
[{"$f":"'12 BHCollection EA REDA'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BHCollection EA REDA'!A5","v":"OMB # 0570 - 0067"}]
[{"$f":"'Overall Summary'!A10","v":"2024-10-10"}]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"$f":"'12 BHCollection TAG'!C8","v":{"v":389,"d":"389 "}},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",{"$f":"'12 BHCollection TAG'!K8","v":116}]
["Average hours per response",null,{"$f":"I10/G10","v":{"v":0.7931694756554307,"d":"0.793"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G10/C8","v":{"v":5.4910025706940875,"d":"5.49"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G14:G22)","v":{"v":2136,"d":"2,136"}},null,{"$f":"SUM(I14:I22)","v":{"v":1694.21,"d":"1,694"}},null,{"$f":"SUM(K14:K22)","v":{"v":125422.64753886,"d":"$125,423"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["REAP TAG NOFO Reference","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response \n(time estimated in 5 min intervals)","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["APPLICATION"]
["Sec. D.2(a)","Application for Federal Assistance","SF 424\n(4040-0004)",{"v":1,"d":"100%"},{"$f":"D14*$C$8","v":389},1,{"$f":"E14*F14","v":389},1,{"$f":"IF((H14*G14)=\"\",\"\",(H14*G14))","v":389},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J14*I14)=\"\",\"\",(J14*I14))","v":{"v":28797.734574000002,"d":"$28,798"}}]
["Sec. D.2(b)","Budget Information - Non Construction Program","SF 424A\n(4040-0006)",{"v":1,"d":"100%"},{"$f":"D15*$C$8","v":389},1,{"$f":"E15*F15","v":389},2,{"$f":"IF((H15*G15)=\"\",\"\",(H15*G15))","v":778},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J15*I15)=\"\",\"\",(J15*I15))","v":{"v":57595.469148000004,"d":"$57,595"}}]
["AWARDEE DOCUMENTS AND CERTIFICATIONS"]
["Sec. F.2(b)","Letter of Intent to Meet Conditions","RD 1942-46\n(0570-0021, 0061, 0062; 0572-0137; 0575-0015)",{"v":1,"d":"100%"},{"$f":"D17*$K$8","v":{"v":116,"d":"116 "}},{"v":1,"d":"1 "},{"$f":"E17*F17","v":116},{"v":1,"d":"1.00"},{"$f":"IF((H17*G17)=\"\",\"\",(H17*G17))","v":116},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J17*I17)=\"\",\"\",(J17*I17))","v":{"v":8587.499256000001,"d":"$8,587"}}]
["Sec. F.2(c)","Disclosure of Lobbying Activities","SF LLL\n(4040-0013)",{"v":1,"d":"100%"},{"$f":"D18*$K$8","v":116},1,{"$f":"E18*F18","v":116},0.17,{"$f":"IF((H18*G18)=\"\",\"\",(H18*G18))","v":{"v":19.720000000000002,"d":"20"}},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J18*I18)=\"\",\"\",(J18*I18))","v":{"v":1459.8748735200004,"d":"$1,460"}}]
["Sec. D.2(c)","Assurance Agreement (Application)","RD-400-4\n(0575-0201, 0189)",{"v":1,"d":"100%"},389,1,389,0.25,{"v":97.25,"d":"97"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":7199.4336435000005,"d":"$7,199"}]
["Sec. F.4(a)(1)","Federal Financial Report","SF 425\n(4040-0014)",{"v":1,"d":"100%"},{"$f":"D20*$K$8","v":116},2,{"$f":"E20*F20","v":232},0.5,{"$f":"IF((H20*G20)=\"\",\"\",(H20*G20))","v":116},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J20*I20)=\"\",\"\",(J20*I20))","v":{"v":8587.499256000001,"d":"$8,587"}}]
["Sec. F.2(d)","Request for Advance or Reimbursement","SF-270 \n(4040-0012)",{"v":1,"d":"100%"},{"$f":"D21*$K$8","v":116},1,{"$f":"E21*F21","v":116},1,{"$f":"IF((H21*G21)=\"\",\"\",(H21*G21))","v":116},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"$f":"IF((J21*I21)=\"\",\"\",(J21*I21))","v":{"v":8587.499256000001,"d":"$8,587"}}]
["Sec. D.2(d)","Equal Opportunity Agreement","RD 400-1\n(0575-0201, 0189)",{"v":1,"d":"100%"},389,1,389,0.16,{"v":62.24,"d":"62"},{"$f":"'12 Est Prof Wage Rate'!$G$38","v":{"v":74.03016600000001,"d":"$74.03"}},{"v":4607.6375318400005,"d":"$4,608"}]

{"sheet":"12 Est Prof Wage Rate","index":11,"n_rows":38,"n_cols":7,"rows_kept":38}
[{"$f":"'12 BHCollection EA REDA'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 BHCollection EA REDA'!A2","v":"RURAL ENERGY FOR AMERICA PROGRAM"}]
[{"$f":"'12 BHCollection EA REDA'!A3","v":"ENERGY AUDIT (EA) AND RENEWABLE ENERGY DEVELOPMENT ASSITANCE (REDA)"}]
[{"$f":"'12 BHCollection RES-EEI<80K'!A3","v":"RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - <$80K"}]
[{"$f":"'12 BHCollection RES-EEI 80><200'!A3","v":"RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - $80K> <$200K"}]
[{"$f":"'12 BHCollection RES-EEI >200'!A3","v":"RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - >$200K"}]
[{"$f":"'12 BHCollection EA REDA'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BHCollection EA REDA'!A5","v":"OMB # 0570 - 0067"}]
[{"$f":"'12 BHCollection EA REDA'!A6","v":"2024-10-10"}]
[]
["Instructions:"]
["1.  Use the U.S. Bureau of Labor Statistics Occupational Emplyment and Wage Statistics Link below to complete Columns A, B, C for the table below."]
["     a.  Click the link:","https://www.bls.gov/oes/tables.htm "]
["     b.  Under the latest Month Year (May 2023) click Occupation Profiles "]
["     c.  Use the Occupational Titles to choose which professions (A) need to be added to the table below.  You can more than one occupation or just one."]
["     d.  The code in front of each Occupational Title is the Occupation Code that goes in (B) for the table below."]
["     e.  When you click on each Occupational Titles, choose the Mean Hourly Wage to input in (C) for the table below.  "]
["2.  Use the U.S. Bureau of Labor Economic News Release, Employer Costs for Employee Compension to complete Column D for the table below.  "]
["     a.  Click the link:","https://www.bls.gov/news.release/ecec.toc.htm "]
["     b.  Choose \"The PDF verison of the news release\" link"]
["     c.  The latest (September 10, 2024) News Release for Employer Costs for Employee Compensation - June 2024 opens in separate tab."]
["     d.  On first page, second paragraph use the benefit costs % of: ",null,null,{"v":0.297,"d":"29.70%"}]
["3.  For each profession fill in the % for (F).  The total for the column should be 100%.  "]
["     a.  Note that if there is only one profession then (F) would be 100%. "]
[]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  "]
["(A)","(B)","(C)","(D)","(E)","(F)","(G)"]
["Profession","Bureau of Labor Occupation Code 1.d","Mean Wage 1.e","Benefits 2\n(C) * (2.d)","Total Hourly Wage\n(C ) + (D)","% Time Spent on Burden","Weighted Hourly Salary\n(E) * (F)"]
["Farmers, Ranchers, and Other Agricultural Managers","11-9013",{"v":43.35,"d":"$43.35"},{"$f":"IF(C29=0,\"\",(C29*$D$22))","v":{"v":12.87495,"d":"$12.87"}},{"$f":"IF(SUM(C29:D29)=0,\"\",SUM(C29:D29))","v":{"v":56.22495,"d":"$56.22"}},{"v":0.4,"d":"40%"},{"$f":"IF(E29=\"\",\"\",(E29*F29))","v":{"v":22.489980000000003,"d":"$22.49"}}]
["Management Occupations for Rural Small Business Owners","11-0000",{"v":66.23,"d":"$66.23"},{"$f":"IF(C30=0,\"\",(C30*$D$22))","v":{"v":19.67031,"d":"$19.67"}},{"$f":"IF(SUM(C30:D30)=0,\"\",SUM(C30:D30))","v":{"v":85.90031,"d":"$85.90"}},{"v":0.6,"d":"60%"},{"$f":"IF(E30=\"\",\"\",(E30*F30))","v":{"v":51.540186,"d":"$51.54"}}]
{"$rows_empty":7}
["TOTAL",null,null,{"$f":"IF(C38=0,\"\",(C38*#REF!))","v":""},null,{"$f":"SUM(F29:F37)","v":{"v":1,"d":"100%"}},{"$f":"SUM(G29:G37)","v":{"v":74.03016600000001,"d":"$74.03"}}]

{"sheet":"14 Annual$FedGovEst RES-EEI <80","index":12,"n_rows":39,"n_cols":11,"rows_kept":39}
[{"$f":"'12 BHCollection EA REDA'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 BHCollection EA REDA'!A2","v":"RURAL ENERGY FOR AMERICA PROGRAM"}]
[{"$f":"'12 BHCollection RES-EEI<80K'!A3","v":"RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - <$80K"}]
[{"$f":"'12 BHCollection EA REDA'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BHCollection EA REDA'!A5","v":"OMB # 0570 - 0067"}]
[{"$f":"'12 BHCollection EA REDA'!A6","v":"2024-10-10"}]
[]
["1. OPM GS & SES Pay Tables:"]
["  Click Link ","Pay & Leave (opm.gov)"]
["  Click \"pay tables\" from first paragraph"]
["  Click current Year at top under Salaries & Wages"]
[]
["  a. OPM GS Pay Tables:  Under \"General Schedule (GS) & Locality Pay Tables\" click 20## GS Pay Tables (ex. 2024 GS Pay Tables)"]
["  Then choose Annual Rate Table for St. Louis - St. Charles - Farminton, MO-IL"]
[]
["  b. OPM SES Schedules:  Under \"Executive & Senior Level Employee Pay Tables\" click \"Rates of Pay for the Executive Schedule\""]
["  Then choose Annual Rate Table for Basic Rates of Pay for Members of the Senior Executive Service."]
[]
["2. Benefit % (OMB Memo M-08 13)","https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf ",{"$nulls":8},{"v":0.3625,"d":"36.25%"}]
[]
["Gray & Blue Columns have automatic formulas.  DO NOT input numbers in these columns.",{"$nulls":5},"Total  ",{"$f":"H23+H27+H32+H36","v":22.75},{"$f":"I23+I27+I32+I36","v":{"v":1494.9713551682694,"d":"$1,494.97"}},null,{"$f":"K23+K27+K32+K36","v":{"v":1549159.0498617792,"d":"$1,549,159.05"}}]
["Staff \nPosition","GS Grade","GS Step","GS \nSalary","Hourly Rate Calc","Benefits Calc","Total Salary Rate Calc","Hours Required","Cost Subtotals","# of Responses","Total Costs"]
["Other Requirements",{"$nulls":6},{"$f":"SUM(H24:H26)","v":{"v":9,"d":"9.00"}},{"$f":"SUM(I24:I26)","v":{"v":596.6859134615385,"d":"$596.69"}},{"$f":"'12 BHCollection RES-EEI<80K'!E9","v":{"v":1054,"d":"1,054"}},{"$f":"J23*I23","v":{"v":628906.9527884616,"d":"$628,906.95"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D24/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E24*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E24+F24","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":1,"d":"1.00"},{"$f":"H24*G24","v":{"v":78.74856971153845,"d":"$78.75"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D25/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E25*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E25+F25","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":7,"d":"7.00"},{"$f":"H25*G25","v":{"v":462.7796754807693,"d":"$462.78"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["Application",{"$nulls":6},{"$f":"SUM(H28:H31)","v":{"v":9,"d":"9.00"}},{"$f":"SUM(I28:I31)","v":{"v":596.6859134615386,"d":"$596.69"}},{"$f":"J23","v":{"v":1054,"d":"1,054"}},{"$f":"J27*I27","v":{"v":628906.9527884617,"d":"$628,906.95"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D28/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E28*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E28+F28","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":1,"d":"1.00"},{"$f":"H28*G28","v":{"v":78.74856971153845,"d":"$78.75"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D29/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E29*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E29+F29","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":4,"d":"4.00"},{"$f":"H29*G29","v":{"v":264.4455288461539,"d":"$264.45"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["State Environmental Coordinator - State Office",12,5,{"v":100926,"d":"$100,926"},{"v":48.52211538461539,"d":"$48.52"},{"$f":"E31*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"v":66.11138221153847,"d":"$66.11"},{"v":3,"d":"3.00"},{"v":198.33414663461542,"d":"$198.33"}]
["Awardee Documents and Certifications",{"$nulls":6},{"$f":"SUM(H33:H35)","v":{"v":2.5,"d":"2.50"}},{"$f":"SUM(I33:I35)","v":{"v":160.64333533653848,"d":"$160.64"}},{"$f":"'12 BHCollection RES-EEI<80K'!K9","v":966},{"$f":"J32*I32","v":{"v":155181.4619350962,"d":"$155,181.46"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D33/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E33*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E33+F33","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":0.5,"d":"0.50"},{"$f":"H33*G33","v":{"v":39.374284855769226,"d":"$39.37"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D34/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E34*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E34+F34","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":1,"d":"1.00"},{"$f":"H34*G34","v":{"v":66.11138221153847,"d":"$66.11"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["Reporting and Other",{"$nulls":6},{"$f":"SUM(H37:H39)","v":2.25},{"$f":"SUM(I37:I39)","v":{"v":140.95619290865386,"d":"$140.96"}},{"$f":"J32","v":966},{"$f":"J36*I36","v":{"v":136163.68234975962,"d":"$136,163.68"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D37/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E37*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E37+F37","v":{"v":78.74856971153845,"d":"$78.75"}},0.25,{"$f":"H37*G37","v":{"v":19.687142427884613,"d":"$19.69"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D38/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E38*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E38+F38","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":1,"d":"1.00"},{"$f":"H38*G38","v":{"v":66.11138221153847,"d":"$66.11"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]

{"sheet":"14Ann$FedGovEst RES-EEI80><200","index":13,"n_rows":39,"n_cols":11,"rows_kept":39}
[{"$f":"'12 BHCollection EA REDA'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 BHCollection EA REDA'!A2","v":"RURAL ENERGY FOR AMERICA PROGRAM"}]
[{"$f":"'12 BHCollection RES-EEI 80><200'!A3","v":"RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - $80K> <$200K"}]
[{"$f":"'12 BHCollection EA REDA'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BHCollection EA REDA'!A5","v":"OMB # 0570 - 0067"}]
[{"$f":"'12 BHCollection EA REDA'!A6","v":"2024-10-10"}]
[]
["1. OPM GS & SES Pay Tables:"]
["  Click Link ","Pay & Leave (opm.gov)"]
["  Click \"pay tables\" from first paragraph"]
["  Click current Year at top under Salaries & Wages"]
[]
["  a. OPM GS Pay Tables:  Under \"General Schedule (GS) & Locality Pay Tables\" click 20## GS Pay Tables (ex. 2024 GS Pay Tables)"]
["  Then choose Annual Rate Table for St. Louis - St. Charles - Farminton, MO-IL"]
[]
["  b. OPM SES Schedules:  Under \"Executive & Senior Level Employee Pay Tables\" click \"Rates of Pay for the Executive Schedule\""]
["  Then choose Annual Rate Table for Basic Rates of Pay for Members of the Senior Executive Service."]
[]
["2. Benefit % (OMB Memo M-08 13)","https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf ",{"$nulls":8},{"v":0.3625,"d":"36.25%"}]
[]
["Gray & Blue Columns have automatic formulas.  DO NOT input numbers in these columns.",{"$nulls":5},"Total  ",{"$f":"H23+H27+H32+H36","v":29.75},{"$f":"I23+I27+I32+I36","v":{"v":1946.7973167067307,"d":"$1,946.80"}},null,{"$f":"K23+K27+K32+K36","v":{"v":2525960.604041466,"d":"$2,525,960.60"}}]
["Staff \nPosition","GS Grade","GS Step","GS \nSalary","Hourly Rate Calc","Benefits Calc","Total Salary Rate Calc","Hours Required","Cost Subtotals","# of Responses","Total Costs"]
["Other Requirements",{"$nulls":6},{"$f":"SUM(H24:H26)","v":{"v":9,"d":"9.00"}},{"$f":"SUM(I24:I26)","v":{"v":596.6859134615385,"d":"$596.69"}},{"$f":"'12 BHCollection RES-EEI 80><200'!E9","v":{"v":1326,"d":"1,326"}},{"$f":"J23*I23","v":{"v":791205.52125,"d":"$791,205.52"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D24/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E24*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E24+F24","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":1,"d":"1.00"},{"$f":"H24*G24","v":{"v":78.74856971153845,"d":"$78.75"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D25/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E25*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E25+F25","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":7,"d":"7.00"},{"$f":"H25*G25","v":{"v":462.7796754807693,"d":"$462.78"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["Application",{"$nulls":6},{"$f":"SUM(H28:H31)","v":{"v":13,"d":"13.00"}},{"$f":"SUM(I28:I31)","v":{"v":850.1777283653846,"d":"$850.18"}},{"$f":"J23","v":{"v":1326,"d":"1,326"}},{"$f":"J27*I27","v":{"v":1127335.6678125,"d":"$1,127,335.67"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D28/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E28*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E28+F28","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":1,"d":"1.00"},{"$f":"H28*G28","v":{"v":78.74856971153845,"d":"$78.75"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D29/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E29*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E29+F29","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":5,"d":"5.00"},{"$f":"H29*G29","v":{"v":330.55691105769233,"d":"$330.56"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":2,"d":"2.00"},{"v":110.31533653846155,"d":"$110.32"}]
["State Environmental Coordinator - State Office",12,5,{"v":100926,"d":"$100,926"},{"v":48.52211538461539,"d":"$48.52"},{"$f":"E31*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"v":66.11138221153847,"d":"$66.11"},{"v":5,"d":"5.00"},{"v":330.55691105769233,"d":"$330.56"}]
["Awardee Documents and Certifications",{"$nulls":6},{"$f":"SUM(H33:H35)","v":{"v":2.5,"d":"2.50"}},{"$f":"SUM(I33:I35)","v":{"v":160.64333533653848,"d":"$160.64"}},{"$f":"'12 BHCollection RES-EEI 80><200'!K9","v":{"v":1215,"d":"1,215"}},{"$f":"J32*I32","v":{"v":195181.65243389425,"d":"$195,181.65"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D33/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E33*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E33+F33","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":0.5,"d":"0.50"},{"$f":"H33*G33","v":{"v":39.374284855769226,"d":"$39.37"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D34/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E34*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E34+F34","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":1,"d":"1.00"},{"$f":"H34*G34","v":{"v":66.11138221153847,"d":"$66.11"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["Reporting and Other",{"$nulls":6},{"$f":"SUM(H37:H39)","v":5.25},{"$f":"SUM(I37:I39)","v":{"v":339.2903395432693,"d":"$339.29"}},{"$f":"J32","v":{"v":1215,"d":"1,215"}},{"$f":"J36*I36","v":{"v":412237.7625450722,"d":"$412,237.76"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D37/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E37*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E37+F37","v":{"v":78.74856971153845,"d":"$78.75"}},0.25,{"$f":"H37*G37","v":{"v":19.687142427884613,"d":"$19.69"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D38/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E38*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E38+F38","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":4,"d":"4.00"},{"$f":"H38*G38","v":{"v":264.4455288461539,"d":"$264.45"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]

{"sheet":"14 Annual$FedGovEst RES-EEI>200","index":14,"n_rows":39,"n_cols":11,"rows_kept":39}
[{"$f":"'12 BHCollection EA REDA'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 BHCollection EA REDA'!A2","v":"RURAL ENERGY FOR AMERICA PROGRAM"}]
[{"$f":"'12 BHCollection RES-EEI >200'!A3","v":"RENEWABLE ENERGY SYSTEM (RES) AND ENERGY EFFICIENCY IMPROVEMENTS (EEI) - >$200K"}]
[{"$f":"'12 BHCollection EA REDA'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BHCollection EA REDA'!A5","v":"OMB # 0570 - 0067"}]
[{"$f":"'12 BHCollection EA REDA'!A6","v":"2024-10-10"}]
[]
["1. OPM GS & SES Pay Tables:"]
["  Click Link ","Pay & Leave (opm.gov)"]
["  Click \"pay tables\" from first paragraph"]
["  Click current Year at top under Salaries & Wages"]
[]
["  a. OPM GS Pay Tables:  Under \"General Schedule (GS) & Locality Pay Tables\" click 20## GS Pay Tables (ex. 2024 GS Pay Tables)"]
["  Then choose Annual Rate Table for St. Louis - St. Charles - Farminton, MO-IL"]
[]
["  b. OPM SES Schedules:  Under \"Executive & Senior Level Employee Pay Tables\" click \"Rates of Pay for the Executive Schedule\""]
["  Then choose Annual Rate Table for Basic Rates of Pay for Members of the Senior Executive Service."]
[]
["2. Benefit % (OMB Memo M-08 13)","https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf ",{"$nulls":8},{"v":0.3625,"d":"36.25%"}]
[]
["Gray & Blue Columns have automatic formulas.  DO NOT input numbers in these columns.",{"$nulls":5},"Total  ",{"$f":"H23+H27+H32+H36","v":37.75},{"$f":"I23+I27+I32+I36","v":{"v":2475.6883743990393,"d":"$2,475.69"}},null,{"$f":"K23+K27+K32+K36","v":{"v":4424811.546075722,"d":"$4,424,811.55"}}]
["Staff \nPosition","GS Grade","GS Step","GS \nSalary","Hourly Rate Calc","Benefits Calc","Total Salary Rate Calc","Hours Required","Cost Subtotals","# of Responses","Total Costs"]
["Other Requirements",{"$nulls":6},{"$f":"SUM(H24:H26)","v":{"v":11,"d":"11.00"}},{"$f":"SUM(I24:I26)","v":{"v":728.9086778846155,"d":"$728.91"}},{"$f":"'12 BHCollection RES-EEI >200'!E9","v":{"v":1818,"d":"1,818"}},{"$f":"J23*I23","v":{"v":1325155.976394231,"d":"$1,325,155.98"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D24/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E24*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E24+F24","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":1,"d":"1.00"},{"$f":"H24*G24","v":{"v":78.74856971153845,"d":"$78.75"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D25/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E25*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E25+F25","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":9,"d":"9.00"},{"$f":"H25*G25","v":{"v":595.0024399038463,"d":"$595.00"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["Application",{"$nulls":6},{"$f":"SUM(H28:H31)","v":{"v":19,"d":"19.00"}},{"$f":"SUM(I28:I31)","v":{"v":1246.8460216346157,"d":"$1,246.85"}},{"$f":"J23","v":{"v":1818,"d":"1,818"}},{"$f":"J27*I27","v":{"v":2266766.0673317313,"d":"$2,266,766.07"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D28/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E28*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E28+F28","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":1,"d":"1.00"},{"$f":"H28*G28","v":{"v":78.74856971153845,"d":"$78.75"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D29/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E29*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E29+F29","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":9,"d":"9.00"},{"$f":"H29*G29","v":{"v":595.0024399038463,"d":"$595.00"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":2,"d":"2.00"},{"v":110.31533653846155,"d":"$110.32"}]
["State Environmental Coordinator - State Office",12,5,{"v":100926,"d":"$100,926"},{"v":48.52211538461539,"d":"$48.52"},{"$f":"E31*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"v":66.11138221153847,"d":"$66.11"},{"v":7,"d":"7.00"},{"v":462.7796754807693,"d":"$462.78"}]
["Awardee Documents and Certifications",{"$nulls":6},{"$f":"SUM(H33:H35)","v":{"v":2.5,"d":"2.50"}},{"$f":"SUM(I33:I35)","v":{"v":160.64333533653848,"d":"$160.64"}},{"$f":"'12 BHCollection RES-EEI >200'!K9","v":{"v":1666,"d":"1,666"}},{"$f":"J32*I32","v":{"v":267631.7966706731,"d":"$267,631.80"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D33/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E33*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E33+F33","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":0.5,"d":"0.50"},{"$f":"H33*G33","v":{"v":39.374284855769226,"d":"$39.37"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D34/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E34*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E34+F34","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":1,"d":"1.00"},{"$f":"H34*G34","v":{"v":66.11138221153847,"d":"$66.11"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["Reporting and Other",{"$nulls":6},{"$f":"SUM(H37:H39)","v":5.25},{"$f":"SUM(I37:I39)","v":{"v":339.2903395432693,"d":"$339.29"}},{"$f":"J32","v":{"v":1666,"d":"1,666"}},{"$f":"J36*I36","v":{"v":565257.7056790866,"d":"$565,257.71"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D37/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E37*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E37+F37","v":{"v":78.74856971153845,"d":"$78.75"}},0.25,{"$f":"H37*G37","v":{"v":19.687142427884613,"d":"$19.69"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D38/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E38*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E38+F38","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":4,"d":"4.00"},{"$f":"H38*G38","v":{"v":264.4455288461539,"d":"$264.45"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]

{"sheet":"14 Annual $ Fed Gov Est EA REDA","index":15,"n_rows":38,"n_cols":11,"rows_kept":38}
[{"$f":"'12 BHCollection EA REDA'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 BHCollection EA REDA'!A2","v":"RURAL ENERGY FOR AMERICA PROGRAM"}]
[{"$f":"'12 BHCollection EA REDA'!A3","v":"ENERGY AUDIT (EA) AND RENEWABLE ENERGY DEVELOPMENT ASSITANCE (REDA)"}]
[{"$f":"'12 BHCollection EA REDA'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BHCollection EA REDA'!A5","v":"OMB # 0570 - 0067"}]
[{"$f":"'12 BHCollection EA REDA'!A6","v":"2024-10-10"}]
[]
["1. OPM GS & SES Pay Tables:"]
["  Click Link ","Pay & Leave (opm.gov)"]
["  Click \"pay tables\" from first paragraph"]
["  Click current Year at top under Salaries & Wages"]
[]
["  a. OPM GS Pay Tables:  Under \"General Schedule (GS) & Locality Pay Tables\" click 20## GS Pay Tables (ex. 2024 GS Pay Tables)"]
["  Then choose Annual Rate Table for St. Louis - St. Charles - Farminton, MO-IL"]
[]
["  b. OPM SES Schedules:  Under \"Executive & Senior Level Employee Pay Tables\" click \"Rates of Pay for the Executive Schedule\""]
["  Then choose Annual Rate Table for Basic Rates of Pay for Members of the Senior Executive Service."]
[]
["2. Benefit % (OMB Memo M-08 13)","https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf ",{"$nulls":8},{"v":0.3625,"d":"36.25%"}]
[]
["Gray & Blue Columns have automatic formulas.  DO NOT input numbers in these columns.",{"$nulls":5},"Total  ",{"$f":"H23+H27+H31+H35","v":{"v":24.5,"d":"24.50"}},{"$f":"I23+I27+I31+I35","v":{"v":1620.1441646634617,"d":"$1,620.14"}},null,{"$f":"K23+K27+K31+K35","v":{"v":41292.55253605769,"d":"$41,292.55"}}]
["Staff \nPosition","GS Grade","GS Step","GS \nSalary","Hourly Rate Calc","Benefits Calc","Total Salary Rate Calc","Hours Required","Cost Subtotals","# of Responses","Total Costs"]
["Other Requirements",{"$nulls":6},{"$f":"SUM(H24:H26)","v":{"v":8,"d":"8.00"}},{"$f":"SUM(I24:I26)","v":{"v":543.2117187499999,"d":"$543.21"}},{"$f":"'12 BHCollection EA REDA'!C8","v":28},{"$f":"J23*I23","v":{"v":15209.928124999999,"d":"$15,209.93"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D24/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E24*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E24+F24","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":2,"d":"2.00"},{"$f":"H24*G24","v":{"v":157.4971394230769,"d":"$157.50"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D25/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E25*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E25+F25","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":5,"d":"5.00"},{"$f":"H25*G25","v":{"v":330.55691105769233,"d":"$330.56"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["Application",{"$nulls":6},{"$f":"SUM(H28:H30)","v":{"v":6,"d":"6.00"}},{"$f":"SUM(I28:I30)","v":{"v":398.3517668269231,"d":"$398.35"}},{"$f":"J23","v":28},{"$f":"J27*I27","v":{"v":11153.849471153846,"d":"$11,153.85"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D28/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E28*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E28+F28","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":1,"d":"1.00"},{"$f":"H28*G28","v":{"v":78.74856971153845,"d":"$78.75"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D29/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E29*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E29+F29","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":4,"d":"4.00"},{"$f":"H29*G29","v":{"v":264.4455288461539,"d":"$264.45"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["Awardee Documents and Certifications",{"$nulls":6},{"$f":"SUM(H32:H34)","v":5.25},{"$f":"SUM(I32:I34)","v":{"v":339.2903395432693,"d":"$339.29"}},{"$f":"'12 BHCollection EA REDA'!K8","v":22},{"$f":"J31*I31","v":{"v":7464.387469951924,"d":"$7,464.39"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D32/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E32*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E32+F32","v":{"v":78.74856971153845,"d":"$78.75"}},0.25,{"$f":"H32*G32","v":{"v":19.687142427884613,"d":"$19.69"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D33/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E33*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E33+F33","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":4,"d":"4.00"},{"$f":"H33*G33","v":{"v":264.4455288461539,"d":"$264.45"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]
["Reporting and Other",{"$nulls":6},{"$f":"SUM(H36:H38)","v":5.25},{"$f":"SUM(I36:I38)","v":{"v":339.2903395432693,"d":"$339.29"}},{"$f":"J31","v":22},{"$f":"J35*I35","v":{"v":7464.387469951924,"d":"$7,464.39"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D36/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E36*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E36+F36","v":{"v":78.74856971153845,"d":"$78.75"}},0.25,{"$f":"H36*G36","v":{"v":19.687142427884613,"d":"$19.69"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D37/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E37*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E37+F37","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":4,"d":"4.00"},{"$f":"H37*G37","v":{"v":264.4455288461539,"d":"$264.45"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":1,"d":"1.00"},{"v":55.157668269230776,"d":"$55.16"}]

{"sheet":"14 Annual $ Fed Gov Est TAG","index":16,"n_rows":34,"n_cols":11,"rows_kept":34}
[{"$f":"'12 BHCollection EA REDA'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 BHCollection EA REDA'!A2","v":"RURAL ENERGY FOR AMERICA PROGRAM"}]
[{"$f":"'12 BHCollection EA REDA'!A3","v":"ENERGY AUDIT (EA) AND RENEWABLE ENERGY DEVELOPMENT ASSITANCE (REDA)"}]
[{"$f":"'12 BHCollection EA REDA'!A4","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BHCollection EA REDA'!A5","v":"OMB # 0570 - 0067"}]
[{"$f":"'12 BHCollection EA REDA'!A6","v":"2024-10-10"}]
[]
["1. OPM GS & SES Pay Tables:"]
["  Click Link ","Pay & Leave (opm.gov)"]
["  Click \"pay tables\" from first paragraph"]
["  Click current Year at top under Salaries & Wages"]
[]
["  a. OPM GS Pay Tables:  Under \"General Schedule (GS) & Locality Pay Tables\" click 20## GS Pay Tables (ex. 2024 GS Pay Tables)"]
["  Then choose Annual Rate Table for St. Louis - St. Charles - Farminton, MO-IL"]
[]
["  b. OPM SES Schedules:  Under \"Executive & Senior Level Employee Pay Tables\" click \"Rates of Pay for the Executive Schedule\""]
["  Then choose Annual Rate Table for Basic Rates of Pay for Members of the Senior Executive Service."]
[]
["2. Benefit % (OMB Memo M-08 13)","https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf ",{"$nulls":8},{"v":0.3625,"d":"36.25%"}]
[]
["Gray & Blue Columns have automatic formulas.  DO NOT input numbers in these columns.",{"$nulls":5},"Total  ",{"$f":"H23+H27+H31","v":{"v":27,"d":"27.00"}},{"$f":"I23+I27+I31","v":{"v":1782.4709735576923,"d":"$1,782.47"}},null,{"$f":"K23+K27+K31","v":{"v":388169.88293269236,"d":"$388,169.88"}}]
["Staff \nPosition","GS Grade","GS Step","GS \nSalary","Hourly Rate Calc","Benefits Calc","Total Salary Rate Calc","Hours Required","Cost Subtotals","# of Responses","Total Costs"]
["Application",{"$nulls":6},{"$f":"SUM(H24:H26)","v":{"v":10,"d":"10.00"}},{"$f":"SUM(I24:I26)","v":{"v":664.4807692307693,"d":"$664.48"}},{"$f":"'12 BHCollection TAG'!C8","v":389},{"$f":"J23*I23","v":{"v":258483.01923076925,"d":"$258,483.02"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D24/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E24*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E24+F24","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":2,"d":"2.00"},{"$f":"H24*G24","v":{"v":157.4971394230769,"d":"$157.50"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D25/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E25*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E25+F25","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":6,"d":"6.00"},{"$f":"H25*G25","v":{"v":396.66829326923084,"d":"$396.67"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":2,"d":"2.00"},{"v":110.31533653846155,"d":"$110.32"}]
["Awardee Documents and Certifications",{"$nulls":6},{"$f":"SUM(H28:H30)","v":{"v":8,"d":"8.00"}},{"$f":"SUM(I28:I30)","v":{"v":519.6208173076923,"d":"$519.62"}},{"$f":"'12 BHCollection TAG'!K8","v":116},{"$f":"J27*I27","v":{"v":60276.01480769231,"d":"$60,276.01"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D28/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E28*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E28+F28","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":1,"d":"1.00"},{"$f":"H28*G28","v":{"v":78.74856971153845,"d":"$78.75"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D29/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E29*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E29+F29","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":5,"d":"5.00"},{"$f":"H29*G29","v":{"v":330.55691105769233,"d":"$330.56"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":2,"d":"2.00"},{"v":110.31533653846155,"d":"$110.32"}]
["Reporting and Other",{"$nulls":6},{"$f":"SUM(H32:H34)","v":{"v":9,"d":"9.00"}},{"$f":"SUM(I32:I34)","v":{"v":598.3693870192308,"d":"$598.37"}},{"$f":"J27","v":116},{"$f":"J31*I31","v":{"v":69410.84889423077,"d":"$69,410.85"}}]
["Program Director - State Office",13,5,{"v":120218,"d":"$120,218"},{"$f":"(D32/52)/40","v":{"v":57.79711538461538,"d":"$57.80"}},{"$f":"E32*$K$19","v":{"v":20.951454326923074,"d":"$20.95"}},{"$f":"E32+F32","v":{"v":78.74856971153845,"d":"$78.75"}},{"v":2,"d":"2.00"},{"$f":"H32*G32","v":{"v":157.4971394230769,"d":"$157.50"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D33/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E33*$K$19","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E33+F33","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":5,"d":"5.00"},{"$f":"H33*G33","v":{"v":330.55691105769233,"d":"$330.56"}}]
["Loan Specialist - State Office",11,5,{"v":84204,"d":"$84,204"},{"v":40.48269230769231,"d":"$40.48"},{"v":14.674975961538463,"d":"$14.67"},{"v":55.157668269230776,"d":"$55.16"},{"v":2,"d":"2.00"},{"v":110.31533653846155,"d":"$110.32"}]