{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["12 BH Collection","12 Not Inc in BH","12 Est Prof Wage Rate","14 Ann Cost to Fed Gov Est"],"not_rendered":{"defined_names":92,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"12 BH Collection","index":0,"n_rows":50,"n_cols":11,"rows_kept":50}
["RURAL UTILITIES SERVICE"]
["SERVICING OF WATER AND WASTE PROGRAMS"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0572 - 0137"]
["2024-11-21"]
[]
["Estimated No. of Total Respondents"]
[null,null,"WWD/ \nWWLG","Watershed","RCDL","TAT","ECWAG","SWMG","Colonias/ \nTribal","Total"]
["Routine Servicing Actions (0572-0137)",null,{"v":3927,"d":"3,927"},1,0,0,0,0,1,{"$f":"SUM(C9:I9)","v":{"v":3929,"d":"3,929"}}]
["Special Servicing Actions (0572-0137)",null,130,1,0,1,1,1,1,{"$f":"SUM(C10:I10)","v":135}]
["Other OMB Packages that Use Forms from this Package - 0572-0121",{"$nulls":8},374]
[{"$nulls":8},"Estimated No. of Total Respondents",{"$f":"SUM(J9:J11)","v":{"v":4438,"d":"4,438"}}]
[]
["Average hours per response",null,{"$f":"I15/G15","v":{"v":2.1528574707367456,"d":"2.152857"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G15/J12","v":{"v":2.945245606128887,"d":"2.94525"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G19:G50)","v":{"v":13071,"d":"13,071"}},null,{"$f":"SUM(I19:I50)","v":{"v":28140,"d":"28,140"}},null,{"$f":"SUM(K19:K50)","v":{"v":2313689.5999999996,"d":"$2,313,690"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation or OMB Package 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 ","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["Routine Servicing Actions"]
["1782.10","Audits and Year-End Financial Reports","Written",{"v":1,"d":"100%"},{"$f":"ROUND(($J$9*D19),0)","v":{"v":3929,"d":"3,929 "}},{"v":1,"d":"1 "},{"$f":"E19*F19","v":{"v":3929,"d":"3,929"}},{"v":3,"d":"3.00"},{"$f":"ROUND((G19*H19),0)","v":{"v":11787,"d":"11,787"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"ROUND((I19*J19),1)","v":{"v":974549.2,"d":"$974,549"}}]
["1782.13(a)(9)","Insurance","Written",{"v":1,"d":"100%"},{"$f":"ROUND(($J$9*D20),0)","v":{"v":3929,"d":"3,929 "}},{"v":1,"d":"1 "},{"v":3929,"d":"3,929"},{"v":1,"d":"1.00"},{"$f":"ROUND((G20*H20),0)","v":{"v":3929,"d":"3,929"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"ROUND((I20*J20),1)","v":{"v":324849.7,"d":"$324,850"}}]
["1782.11 & .17(a)(3)","Operating Budget","Written",{"v":0.7,"d":"70%"},{"v":2750,"d":"2,750 "},{"v":1,"d":"1 "},{"v":2750,"d":"2,750"},{"v":3,"d":"3.00"},{"v":8250,"d":"8,250"},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":682110,"d":"$682,110"}]
["Special Servicing Actions"]
[1782.2,"Reamortization Request","RD 1951-33\n(0572-0137; 0575-0066)",{"v":0.4,"d":"40%"},{"$f":"ROUND(($J$10*D23),0)","v":54},1,{"$f":"E23*F23","v":54},0.25,{"$f":"ROUND((G23*H23),0)","v":14},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"ROUND((I23*J23),1)","v":{"v":1157.5,"d":"$1,158"}}]
[1782.2,"Offer to Convey Security","RD 1955-1\n(0572-0137; 0575-0172)",{"v":0.05,"d":"5%"},{"$f":"ROUND(($J$10*D24),0)","v":7},1,7,0.25,2,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":165.4,"d":"$165"}]
[1782.2,"Application for Settlement of Indebtedness","RD 3560-57 (0572-0137; 0575-0189)",{"v":0.05,"d":"5%"},7,1,7,{"v":1,"d":"1.00"},7,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":578.8,"d":"$579"}]
[1782.9,"Environmental Evaluation","Written",{"v":0.15,"d":"15%"},{"v":20,"d":"20 "},{"v":1,"d":"1 "},20,{"v":10,"d":"10.00"},200,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":16536,"d":"$16,536"}]
[1782.11,"Application for Commercial Credit - Graduation","Written",{"v":0.9,"d":"90%"},{"v":122,"d":"122 "},{"v":1,"d":"1 "},122,{"v":3,"d":"3.00"},366,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":30260.9,"d":"$30,261"}]
["1782.11 & .17(a)(3)","Statement of Budget, Income, and Equity","RD 442-2\n(0572-0137; 0575-0115, 0200 ) ",{"v":1,"d":"100%"},135,1,135,{"v":2.5,"d":"2.50"},338,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":27945.8,"d":"$27,946"}]
["1782.11 & .17(a)(3)","Balance Sheet","RD 442-3\n(0575-0015)        ",{"v":1,"d":"100%"},135,1,135,{"v":1,"d":"1.00"},135,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":11161.8,"d":"$11,162"}]
["1782.12, .13(a)(3),(6), .17 (a)(6), & .20","Appraisal","Written",{"v":0.4,"d":"40%"},{"v":54,"d":"54 "},{"v":1,"d":"1 "},54,{"v":1.5,"d":"1.50"},81,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":6697.1,"d":"$6,697"}]
["1782.12(a)(4)(i)","Conveyance Instrument - Purchase Agreement, etc.","Written",{"v":0.1,"d":"10%"},{"v":14,"d":"14 "},{"v":1,"d":"1 "},14,{"v":2,"d":"2.00"},28,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":2315,"d":"$2,315"}]
["1782.12(a)(4)(ii) & .13 (a)(5)","Rights and Obligations Assumption Agreement","Written",{"v":0.1,"d":"10%"},{"v":14,"d":"14 "},{"v":1,"d":"1 "},14,{"v":1,"d":"1.00"},14,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":1157.5,"d":"$1,158"}]
["1782.13(a)(7) & .17(a)","Consent of Lienholders                                                                     ","Written",{"v":0.8,"d":"80%"},{"v":108,"d":"108 "},{"v":1,"d":"1 "},108,{"v":1,"d":"1.00"},108,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":8929.4,"d":"$8,929"}]
["1782.13(a) (8)","Letter of Intent to Meet Conditions","RD 1942-46\n(0572-0137; 0575-0015; 0570-0021, 0061, 0062)",{"v":0.4,"d":"40%"},54,1,54,1,54,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":4464.7,"d":"$4,465"}]
["1782.13(a)(8)","Letter of Conditions","Written",{"v":0.4,"d":"40%"},{"v":54,"d":"54 "},{"v":1,"d":"1 "},54,{"v":1,"d":"1.00"},54,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":4464.7,"d":"$4,465"}]
["1782.13(a)(9)","Insurance","Written",{"v":0.8,"d":"80%"},{"v":108,"d":"108 "},{"v":1,"d":"1 "},108,{"v":1,"d":"1.00"},108,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":8929.4,"d":"$8,929"}]
["1782.13(a)(11), (b), .17(a)(4), & .20","Security Instruments","Written",{"v":0.8,"d":"80%"},{"v":108,"d":"108 "},{"v":1,"d":"1 "},108,{"v":2,"d":"2.00"},216,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":17858.9,"d":"$17,859"}]
["1782.13(d)(1)","Assumption/Disposition of Grant Agreement Terms                                                                     ","Written",{"v":0.1,"d":"10%"},{"v":14,"d":"14 "},{"v":1,"d":"1 "},14,{"v":2,"d":"2.00"},28,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":2315,"d":"$2,315"}]
["1782.17(a)(1)","Subordination/Parity Narrative Request","Written",{"v":0.5,"d":"50%"},{"v":68,"d":"68 "},{"v":1,"d":"1 "},68,{"v":2,"d":"2.00"},136,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":11244.5,"d":"$11,245"}]
["1782.17(a)(5)","Statement on availability to obtain credit elsewhere","Written",{"v":0.8,"d":"80%"},{"v":108,"d":"108 "},{"v":1,"d":"1 "},108,{"v":2,"d":"2.00"},216,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":17858.9,"d":"$17,859"}]
[1782.19,"Management Agreements","Written",{"v":0.3,"d":"30%"},{"v":41,"d":"41 "},{"v":1,"d":"1 "},41,{"v":3,"d":"3.00"},123,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":10169.6,"d":"$10,170"}]
[1782.19,"Lease Contracts (Facility, Mineral, etc.)","Written",{"v":0.3,"d":"30%"},{"v":41,"d":"41 "},{"v":1,"d":"1 "},41,{"v":3,"d":"3.00"},123,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":10169.6,"d":"$10,170"}]
[1780.2,"Bankruptcy Orders and Supplemental Information","Written",{"v":0.05,"d":"5%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":1.5,"d":"1.50"},11,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":909.5,"d":"$910"}]
[1782.2,"Repayment Agreement","Written",{"v":0.05,"d":"5%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":1,"d":"1.00"},7,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":578.8,"d":"$579"}]
[1782.2,"Rescheduling Agreement","Written",{"v":0.4,"d":"40%"},{"v":54,"d":"54 "},{"v":1,"d":"1 "},54,{"v":2,"d":"2.00"},108,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":8929.4,"d":"$8,929"}]
[1782.2,"Voluntary Conveyance- Board Resolution","Written",{"v":0.05,"d":"5%"},{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":2,"d":"2.00"},14,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":1157.5,"d":"$1,158"}]
["Other OMB Packages that Use Forms from this Package"]
["0572-0121","Statement of Budget, Income, and Equity","RD 442-2\n(0572-0137; 0575-0115, 0200 ) ",null,374,1,{"$f":"E48*F48","v":374},{"v":2.5,"d":"2.50"},{"$f":"ROUND((G48*H48),0)","v":935},{"v":75,"d":"$75.00"},{"$f":"ROUND((I48*J48),1)","v":{"v":70125,"d":"$70,125"}}]
["0572-0121","Balance Sheet","RD 442-3\n(0575-0015)        ",null,374,1,{"$f":"E49*F49","v":374},{"v":1,"d":"1.00"},374,{"v":75,"d":"$75.00"},{"v":28050,"d":"$28,050"}]
["0572-0121","Letter of Intent to Meet Conditions","RD 1942-46\n(0572-0137; 0575-0015; 0570-0021, 0061, 0062)",null,374,1,374,1,374,{"v":75,"d":"$75.00"},{"v":28050,"d":"$28,050"}]

{"sheet":"12 Not Inc in BH","index":1,"n_rows":49,"n_cols":11,"rows_kept":49}
[{"$f":"'12 BH Collection'!A1","v":"RURAL UTILITIES SERVICE"}]
[{"$f":"'12 BH Collection'!A2","v":"SERVICING OF WATER AND WASTE PROGRAMS"}]
[{"$f":"'12 BH Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BH Collection'!A4","v":"OMB # 0572 - 0137"}]
[{"$f":"'12 BH Collection'!A5","v":"2024-11-21"}]
[]
[null,null,"WWD/ \nWWLG","Watershed","RCDL","TAT","ECWAG","SWMG","Colonias/ \nTribal","Total"]
["Estimated No. of Total Respondents - Routine Servicing Actions",null,{"$f":"'12 BH Collection'!C9","v":{"v":3927,"d":"3,927"}},{"$f":"'12 BH Collection'!D9","v":1},{"$f":"'12 BH Collection'!E9","v":0},{"$f":"'12 BH Collection'!F9","v":0},{"$f":"'12 BH Collection'!G9","v":0},{"$f":"'12 BH Collection'!H9","v":0},{"$f":"'12 BH Collection'!I9","v":1},{"$f":"SUM(C8:I8)","v":{"v":3929,"d":"3,929"}}]
["Estimated No. of Total Respondents - Special Servicing Actions",null,{"$f":"'12 BH Collection'!C10","v":130},{"$f":"'12 BH Collection'!D10","v":1},{"$f":"'12 BH Collection'!E10","v":0},{"$f":"'12 BH Collection'!F10","v":1},{"$f":"'12 BH Collection'!G10","v":1},{"$f":"'12 BH Collection'!H10","v":1},{"$f":"'12 BH Collection'!I10","v":1},{"$f":"SUM(C9:I9)","v":135}]
[{"$nulls":8},"Estimated No. of Total Respondents",{"$f":"SUM(J8:J9)","v":{"v":4064,"d":"4,064"}}]
[]
["Average hours per response",null,{"$f":"I13/G13","v":{"v":2.580174927113703,"d":"2.580"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G13/J10","v":{"v":6.632121062992127,"d":"6.63"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G16:G49)","v":{"v":26952.940000000002,"d":"26,953"}},null,{"$f":"SUM(I16:I49)","v":{"v":69543.30000000002,"d":"69,543"}},null,{"$f":"SUM(K16:K49)","v":{"v":5749840.044,"d":"$5,749,840"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation 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 ","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["Routine Servicing Actions"]
["1782.11 & .17(a)(3)","Operating Budget","RD 442-7\n(0575-0015)           ",{"v":0.3,"d":"30%"},{"$f":"$J$8*D17","v":{"v":1178.7,"d":"1,179 "}},{"v":1,"d":"1 "},{"$f":"E17*F17","v":{"v":1178.7,"d":"1,179"}},{"v":5,"d":"5.00"},{"$f":"IF((H17*G17)=\"\",\"\",(H17*G17))","v":{"v":5893.5,"d":"5,894"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J17*I17)=\"\",\"\",(J17*I17))","v":{"v":487274.58,"d":"$487,275"}}]
["Special Servicing Actions"]
[1782.2,"Community Programs Workout Agreement","RD 1951-10\n(0575-0066)",{"v":0.7,"d":"70%"},{"$f":"$J$8*D19","v":{"v":2750.2999999999997,"d":"2,750"}},1,{"$f":"E19*F19","v":{"v":2750.2999999999997,"d":"2,750"}},{"v":1,"d":"1.00"},{"$f":"IF((H19*G19)=\"\",\"\",(H19*G19))","v":{"v":2750.2999999999997,"d":"2,750"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J19*I19)=\"\",\"\",(J19*I19))","v":{"v":227394.804,"d":"$227,395"}}]
[1782.5,"Compliance Review","RD 400-8\n (0570-0062; 0575-0018, 0575-0189)",{"v":1,"d":"100%"},{"$f":"$J$8*D20","v":{"v":3929,"d":"3,929"}},1,{"$f":"E20*F20","v":{"v":3929,"d":"3,929"}},{"v":8,"d":"8.00"},{"$f":"IF((H20*G20)=\"\",\"\",(H20*G20))","v":{"v":31432,"d":"31,432"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J20*I20)=\"\",\"\",(J20*I20))","v":{"v":2598797.7600000002,"d":"$2,598,798"}}]
[1782.8,"Authorization Agreement for Preauth. Payments","RD 3550-28\n(0575-0184)",{"v":1,"d":"100%"},{"$f":"$J$8*D21","v":{"v":3929,"d":"3,929"}},1,{"$f":"E21*F21","v":{"v":3929,"d":"3,929"}},{"v":0.5,"d":"0.50"},{"$f":"IF((H21*G21)=\"\",\"\",(H21*G21))","v":{"v":1964.5,"d":"1,965"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J21*I21)=\"\",\"\",(J21*I21))","v":{"v":162424.86000000002,"d":"$162,425"}}]
["1782.12 & .17(e)(1)","Application for Partial Release, Subordination, or Consent","RD 465-1\n(0560-0236)",{"v":0.4,"d":"40%"},{"v":1571.6000000000001,"d":"1,572"},1,{"v":1571.6000000000001,"d":"1,572"},{"v":1,"d":"1.00"},{"v":1571.6000000000001,"d":"1,572"},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":129939.88800000002,"d":"$129,940"}]
["1782.12(a)(4)(i)","Assurance Agreement","RD 400-4\n(0575-0201)",{"v":0.54,"d":"54%"},{"v":2121.6600000000003,"d":"2,122"},1,{"v":2121.6600000000003,"d":"2,122"},0.25,{"v":530.4150000000001,"d":"530"},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":43854.71220000001,"d":"$43,855"}]
["1782.13(a)","Applicant Certification, Federal Collection Policies for Consumer/Commercial Debts","RD 1910-11\n(0570-0062)",{"v":0.54,"d":"54%"},{"v":2121.6600000000003,"d":"2,122"},1,{"v":2121.6600000000003,"d":"2,122"},0.25,{"v":530.4150000000001,"d":"530"},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":43854.71220000001,"d":"$43,855"}]
["1782.13(a)(1)","Application for Federal Assistance- Initial App.","SF 424\n(4040-0004)",{"v":0.54,"d":"54%"},{"v":2121.6600000000003,"d":"2,122"},1,{"$f":"E25*F25","v":{"v":2121.6600000000003,"d":"2,122"}},{"v":1,"d":"1.00"},{"$f":"IF((H25*G25)=\"\",\"\",(H25*G25))","v":{"v":2121.6600000000003,"d":"2,122"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J25*I25)=\"\",\"\",(J25*I25))","v":{"v":175418.84880000004,"d":"$175,419"}}]
["1782.13(a)(1)","Budget Information--Non-Construction Programs","SF-424A\n(4040-0006)",{"v":0.54,"d":"54%"},{"v":2121.6600000000003,"d":"2,122"},1,{"$f":"E26*F26","v":{"v":2121.6600000000003,"d":"2,122"}},{"v":1,"d":"1.00"},{"$f":"IF((H26*G26)=\"\",\"\",(H26*G26))","v":{"v":2121.6600000000003,"d":"2,122"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J26*I26)=\"\",\"\",(J26*I26))","v":{"v":175418.84880000004,"d":"$175,419"}}]
["1782.13(a)(10)","Community Programs Assumption Agreement","RD 1951-15\n(0575-0066)",{"v":0.2,"d":"20%"},{"v":785.8000000000001,"d":"786"},1,{"v":785.8000000000001,"d":"786"},{"v":0.5,"d":"0.50"},{"v":392.90000000000003,"d":"393"},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":32484.972000000005,"d":"$32,485"}]
["1782.13(a)(11)","Preliminary Title Opinion","RD 1927-9\n(0575-0147, 0575-0189)",{"v":0.1,"d":"10%"},{"v":392.90000000000003,"d":"393"},1,{"$f":"E28*F28","v":{"v":392.90000000000003,"d":"393"}},{"v":1.5,"d":"1.50"},{"$f":"IF((H28*G28)=\"\",\"\",(H28*G28))","v":{"v":589.35,"d":"589"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J28*I28)=\"\",\"\",(J28*I28))","v":{"v":48727.458000000006,"d":"$48,727"}}]
["1782.17(a)(3) & .20(a)","Operating Budget","RD 442-7\n(0575-0015)           ",{"v":1,"d":"100%"},{"v":3929,"d":"3,929"},1,{"$f":"E29*F29","v":{"v":3929,"d":"3,929"}},{"v":5,"d":"5.00"},{"$f":"IF((H29*G29)=\"\",\"\",(H29*G29))","v":{"v":19645,"d":"19,645"}},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J29*I29)=\"\",\"\",(J29*I29))","v":{"v":1624248.6,"d":"$1,624,249"}}]
[{"$nulls":4},0,null,{"$f":"E30*F30","v":0},null,{"$f":"IF((H30*G30)=\"\",\"\",(H30*G30))","v":0},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J30*I30)=\"\",\"\",(J30*I30))","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,{"$f":"E32*F32","v":0},null,{"$f":"IF((H32*G32)=\"\",\"\",(H32*G32))","v":0},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J32*I32)=\"\",\"\",(J32*I32))","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,{"$f":"E39*F39","v":0},null,{"$f":"IF((H39*G39)=\"\",\"\",(H39*G39))","v":0},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J39*I39)=\"\",\"\",(J39*I39))","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},0,null,{"$f":"E40*F40","v":0},null,{"$f":"IF((H40*G40)=\"\",\"\",(H40*G40))","v":0},{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"$f":"IF((J40*I40)=\"\",\"\",(J40*I40))","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]
[{"$nulls":4},0,null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$29","v":{"v":82.68,"d":"$82.68"}},{"v":0,"d":"$0"}]

{"sheet":"12 Est Prof Wage Rate","index":2,"n_rows":29,"n_cols":7,"rows_kept":29}
[{"$f":"'12 BH Collection'!A1","v":"RURAL UTILITIES SERVICE"}]
[{"$f":"'12 BH Collection'!A2","v":"SERVICING OF WATER AND WASTE PROGRAMS"}]
[{"$f":"'12 BH Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BH Collection'!A4","v":"OMB # 0572 - 0137"}]
[{"$f":"'12 BH Collection'!A5","v":"2024-11-21"}]
[]
["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)"]
["General and Operations Manager","11-1021",{"v":62.18,"d":"$62.18"},{"$f":"IF(C25=0,\"\",(C25*$D$18))","v":{"v":18.46746,"d":"$18.47"}},{"$f":"IF(SUM(C25:D25)=0,\"\",SUM(C25:D25))","v":{"v":80.64746,"d":"$80.65"}},{"v":0.5,"d":"50%"},{"$f":"ROUND((E25*F25),2)","v":{"v":40.32,"d":"$40.32"}}]
["Civil Engineers","17-2051",{"v":48.64,"d":"$48.64"},{"$f":"IF(C26=0,\"\",(C26*$D$18))","v":{"v":14.44608,"d":"$14.45"}},{"$f":"IF(SUM(C26:D26)=0,\"\",SUM(C26:D26))","v":{"v":63.08608,"d":"$63.09"}},{"v":0.1,"d":"10%"},{"$f":"ROUND((E26*F26),2)","v":{"v":6.31,"d":"$6.31"}}]
["Lawyers","23-1011",{"v":84.84,"d":"$84.84"},{"$f":"IF(C27=0,\"\",(C27*$D$18))","v":{"v":25.19748,"d":"$25.20"}},{"$f":"IF(SUM(C27:D27)=0,\"\",SUM(C27:D27))","v":{"v":110.03748,"d":"$110.04"}},{"v":0.3,"d":"30%"},{"v":33.01,"d":"$33.01"}]
["Court, Municipal, and License Clerks","43-4031",{"v":23.44,"d":"$23.44"},{"$f":"IF(C28=0,\"\",(C28*$D$18))","v":{"v":6.96168,"d":"$6.96"}},{"$f":"IF(SUM(C28:D28)=0,\"\",SUM(C28:D28))","v":{"v":30.401680000000002,"d":"$30.40"}},{"v":0.1,"d":"10%"},{"v":3.04,"d":"$3.04"}]
["TOTAL",null,null,{"$f":"IF(C29=0,\"\",(C29*#REF!))","v":""},null,{"$f":"SUM(F25:F28)","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUM(G25:G28)","v":{"v":82.68,"d":"$82.68"}}]

{"sheet":"14 Ann Cost to Fed Gov Est","index":3,"n_rows":34,"n_cols":11,"rows_kept":34}
[{"$f":"'12 BH Collection'!A1","v":"RURAL UTILITIES SERVICE"}]
[{"$f":"'12 BH Collection'!A2","v":"SERVICING OF WATER AND WASTE PROGRAMS"}]
[{"$f":"'12 BH Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 BH Collection'!A4","v":"OMB # 0572 - 0137"}]
[{"$f":"'12 BH Collection'!A5","v":"2024-11-21"}]
[]
["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":"SUM(H23:H34)","v":{"v":255,"d":"255.00"}},{"$f":"I23+I24+I34","v":{"v":18083.59,"d":"$18,083.59"}},null,{"$f":"K23+K24+K34","v":{"v":4834769.029999999,"d":"$4,834,769"}}]
["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"]
["Routine Servicing Actions Reviews"]
["Loan Specialist - Field Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D23/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E23*$K$18","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E23+F23","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":8,"d":"8.00"},{"$f":"ROUND((G23*H23),2)","v":{"v":528.89,"d":"$528.89"}},{"$f":"'12 BH Collection'!J9","v":{"v":3929,"d":"3,929"}},{"$f":"J23*I23","v":{"v":2078008.81,"d":"$2,078,009"}}]
["Special Servicing Actions Reviews",{"$nulls":7},{"$f":"ROUND(SUM(I25:I32),2)","v":{"v":17422.48,"d":"$17,422.48"}},135,{"$f":"I24*J24","v":{"v":2352034.8,"d":"$2,352,035"}}]
["Loan Specialist - Field Office",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D25/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E25*$K$18","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E25+F25","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":100,"d":"100.00"},{"$f":"H25*G25","v":{"v":6611.138221153847,"d":"$6,611.14"}}]
["Program Director - State Office",13,5,{"v":120018,"d":"$120,018"},{"$f":"(D26/52)/40","v":{"v":57.700961538461534,"d":"$57.70"}},{"$f":"E26*$K$18","v":{"v":20.916598557692307,"d":"$20.92"}},{"$f":"E26+F26","v":{"v":78.61756009615384,"d":"$78.62"}},{"v":40,"d":"40.00"},{"$f":"H26*G26","v":{"v":3144.7024038461536,"d":"$3,144.70"}}]
["Loan Specialist - State Office",12,5,{"v":100926,"d":"$100,926"},{"v":48.52211538461539,"d":"$48.52"},{"v":17.58926682692308,"d":"$17.59"},{"v":66.11138221153847,"d":"$66.11"},{"v":40,"d":"40.00"},{"v":2644.4552884615387,"d":"$2,644.46"}]
["State Engineer - State Office",12,5,{"v":100926,"d":"$100,926"},{"v":48.52211538461539,"d":"$48.52"},{"v":17.58926682692308,"d":"$17.59"},{"v":66.11138221153847,"d":"$66.11"},{"v":20,"d":"20.00"},{"v":1322.2276442307693,"d":"$1,322.23"}]
["State Environmental Coordinator - State Office",12,5,{"v":100926,"d":"$100,926"},{"v":48.52211538461539,"d":"$48.52"},{"v":17.58926682692308,"d":"$17.59"},{"v":66.11138221153847,"d":"$66.11"},{"v":5,"d":"5.00"},{"v":330.55691105769233,"d":"$330.56"}]
["Loan Specialist - National Office",13,5,{"v":120018,"d":"$120,018"},{"v":57.700961538461534,"d":"$57.70"},{"v":20.916598557692307,"d":"$20.92"},{"v":78.61756009615384,"d":"$78.62"},{"v":30,"d":"30.00"},{"v":2358.5268028846153,"d":"$2,358.53"}]
["Branch Chief - National Office",14,5,{"v":141824,"d":"$141,824"},{"$f":"(D31/52)/40","v":{"v":68.18461538461538,"d":"$68.18"}},{"$f":"E31*$K$18","v":{"v":24.716923076923077,"d":"$24.72"}},{"$f":"E31+F31","v":{"v":92.90153846153846,"d":"$92.90"}},{"v":5,"d":"5.00"},{"$f":"H31*G31","v":{"v":464.5076923076923,"d":"$464.51"}}]
["Water Programs Director - National Office",15,5,{"v":166818,"d":"$166,818"},{"$f":"(D32/52)/40","v":{"v":80.20096153846154,"d":"$80.20"}},{"$f":"E32*$K$18","v":{"v":29.072848557692307,"d":"$29.07"}},{"$f":"E32+F32","v":{"v":109.27381009615385,"d":"$109.27"}},{"v":5,"d":"5.00"},{"$f":"H32*G32","v":{"v":546.3690504807693,"d":"$546.37"}}]
["Graduation Reviews"]
["Loan Specialist - Filed Office (for graduation reviews)",12,5,{"v":100926,"d":"$100,926"},{"$f":"(D34/52)/40","v":{"v":48.52211538461539,"d":"$48.52"}},{"$f":"E34*$K$18","v":{"v":17.58926682692308,"d":"$17.59"}},{"$f":"E34+F34","v":{"v":66.11138221153847,"d":"$66.11"}},{"v":2,"d":"2.00"},{"$f":"ROUND((G34*H34),2)","v":{"v":132.22,"d":"$132.22"}},{"v":3061,"d":"3,061"},{"$f":"J34*I34","v":{"v":404725.42,"d":"$404,725"}}]