{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Burden Hours Collection","Not Included in Burden Hours ","Ann Cost to Fed Gov Est"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900"}

{"sheet":"Burden Hours Collection","index":0,"n_rows":46,"n_cols":13,"rows_kept":46}
["RURAL UTILITIES SERVICE "]
["7 CFR 1775 Technical Assistance Programs"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0572 - 0112"]
[]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"v":66,"d":"66 "},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",52]
["Average hours per response",null,{"$f":"I9/G9","v":{"v":5.052636363636363,"d":"5.0526"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G9/C7","v":{"v":16.666666666666668,"d":"16.67"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G13:G33)","v":{"v":1100,"d":"1,100"}},null,{"$f":"SUM(I13:I33)","v":{"v":5557.9,"d":"5,557.9000"}},null,{"$f":"SUM(K13:K33)","v":{"v":293482.812,"d":"$293,483"}}]
["(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)"]
["APPLICATION"]
["1775.10(c)(6)","Documentation of assistance provided to Rural Development employees",null,{"v":1,"d":"100%"},{"$f":"D13*$C$7","v":{"v":66,"d":"66 "}},{"v":1,"d":"1 "},{"$f":"E13*F13","v":66},0.25,{"$f":"IF((H13*G13)=\"\",\"\",(H13*G13))","v":{"v":16.5,"d":"16.50"}},{"v":52.68,"d":"$52.68"},{"$f":"IF((J13*I13)=\"\",\"\",(J13*I13))","v":{"v":869.22,"d":"$869"}}," "]
["1775.10(c)(9)","Indirect Cost Agreement",null,{"v":1,"d":"100%"},{"$f":"D14*$K$7","v":{"v":52,"d":"52 "}},{"v":1,"d":"1 "},52,{"v":1,"d":"1.00"},{"v":52,"d":"52.00"},{"v":66,"d":"$66.00"},{"v":3432,"d":"$3,432"}]
["1775.10(c)(10)","Statement of Compliance, Title VI of Civil Rights Act of 1964",null,{"v":1,"d":"100%"},{"v":52,"d":"52 "},{"v":1,"d":"1 "},52,{"v":0.5,"d":"0.50"},{"v":26,"d":"26.00"},{"$f":"$J$13","v":{"v":52.68,"d":"$52.68"}},{"v":1369.68,"d":"$1,370"}]
["1775.10","Statement concerning assistance under the National Forest Service-Dependent Rural Communities Economic Diversification Act",null,{"v":1,"d":"100%"},{"v":52,"d":"52 "},{"v":1,"d":"1 "},52,{"v":1,"d":"1.00"},{"v":52,"d":"52.00"},{"v":52.68,"d":"$52.68"},{"v":2739.36,"d":"$2,739"}," "]
["1775.10(d)(1)","Legal Authority and Responsibility",null,{"v":1,"d":"100%"},{"v":52,"d":"52 "},{"v":1,"d":"1 "},52,0.25,{"v":13,"d":"13.00"},{"v":52.68,"d":"$52.68"},{"v":684.84,"d":"$685"}]
["1775.10(d)(2)","Evidence of Tax Exempt Status",null,{"v":1,"d":"100%"},{"v":52,"d":"52 "},{"v":1,"d":"1 "},52,0.25,{"v":13,"d":"13.00"},{"v":52.68,"d":"$52.68"},{"v":684.84,"d":"$685"}]
["1775.10(d)(3)","Narrative- Initial Submission",null,{"v":1,"d":"100%"},{"v":52,"d":"52 "},{"v":1,"d":"1 "},52,{"v":2,"d":"2.00"},{"v":104,"d":"104.00"},{"v":52.68,"d":"$52.68"},{"v":5478.72,"d":"$5,479"}]
[null,"Narrative- Revised Submission",null,{"v":0.8,"d":"80%"},{"v":41.6,"d":"42 "},{"v":1,"d":"1 "},{"v":41.6,"d":"42"},{"v":2,"d":"2.00"},{"v":83.2,"d":"83.20"},{"v":52.68,"d":"$52.68"},{"v":4382.976000000001,"d":"$4,383"}]
["1775.10(d)(8)","Scope of Work- Initial Submission",null,{"v":1,"d":"100%"},{"v":66,"d":"66 "},{"v":1,"d":"1 "},66,{"v":12,"d":"12.00"},{"v":792,"d":"792.00"},{"v":52.68,"d":"$52.68"},{"v":41722.56,"d":"$41,723"}]
[null,"Scope of Work- Final Submission",null,{"v":0.8,"d":"80%"},{"v":52.800000000000004,"d":"53 "},{"v":1,"d":"1 "},{"v":52.800000000000004,"d":"53"},{"v":12,"d":"12.00"},{"v":633.6,"d":"633.60"},{"v":52.68,"d":"$52.68"},{"v":33378.048,"d":"$33,378"}]
["1775.10(d)(6)","Budget justification- Initial Submission",null,{"v":1,"d":"100%"},{"$f":"D23*$K$7","v":{"v":52,"d":"52 "}},{"v":1,"d":"1 "},52,{"v":10,"d":"10.00"},{"v":520,"d":"520.00"},{"v":52.68,"d":"$52.68"},{"v":27393.6,"d":"$27,394"}]
[null,"Budget justification- Revised Submission",null,{"v":0.8,"d":"80%"},{"v":41.6,"d":"42 "},{"v":1,"d":"1 "},{"v":41.6,"d":"42"},{"v":10,"d":"10.00"},{"v":416,"d":"416.00"},{"v":52.68,"d":"$52.68"},{"v":21914.88,"d":"$21,915"}]
["1775.10(d)(4)","Latest Financial Information",null,{"v":1,"d":"100%"},{"v":52,"d":"52 "},{"v":1,"d":"1 "},52,{"v":1,"d":"1.00"},{"v":52,"d":"52.00"},{"v":52.68,"d":"$52.68"},{"v":2739.36,"d":"$2,739"}]
["1775.10(d)(7)","Evidence of Financial Management System",null,{"v":1,"d":"100%"},{"v":52,"d":"52 "},{"v":1,"d":"1 "},52,0.25,{"v":13,"d":"13.00"},{"v":52.68,"d":"$52.68"},{"v":684.84,"d":"$685"}]
[]
["AWARD CLOSING, SERVICING, AND REPORTING"]
[1775.13,"Grant Agreement","RUS Guide 1775-1",{"v":1,"d":"100%"},{"$f":"D29*$K$7","v":{"v":52,"d":"52 "}},{"v":1,"d":"1 "},52,{"v":2,"d":"2.00"},{"$f":"IF((H29*G29)=\"\",\"\",(H29*G29))","v":{"v":104,"d":"104.00"}},{"$f":"$J$13","v":{"v":52.68,"d":"$52.68"}},{"$f":"IF((J29*I29)=\"\",\"\",(J29*I29))","v":{"v":5478.72,"d":"$5,479"}}]
[1775.2,"Project Performance Report",null,{"v":1,"d":"100%"},{"$f":"D30*$K$7","v":{"v":52,"d":"52 "}},{"v":4,"d":"4 "},208,{"v":12,"d":"12.00"},{"v":2496,"d":"2,496.00"},{"v":52.68,"d":"$52.68"},{"v":131489.28,"d":"$131,489"}]
[1775.21,"Audit",null,{"v":0.15,"d":"15%"},{"v":7.8,"d":"8 "},{"v":1,"d":"1 "},{"v":7.8,"d":"8"},{"v":3,"d":"3.00"},{"v":23.4,"d":"23.40"},{"v":52.68,"d":"$52.68"},{"v":1232.712,"d":"$1,233"}]
[1775.21,"Financial Statements",null,{"v":0.85,"d":"85%"},{"v":44.199999999999996,"d":"44 "},{"v":1,"d":"1 "},{"v":44.199999999999996,"d":"44"},{"v":1,"d":"1.00"},{"v":44.199999999999996,"d":"44.20"},{"v":52.68,"d":"$52.68"},{"v":2328.4559999999997,"d":"$2,328"}]
[null,"SAM Registration","Written",{"v":1,"d":"100%"},{"$f":"D33*$K$7","v":{"v":52,"d":"52 "}},{"v":1,"d":"1 "},{"$f":"E33*F33","v":52},{"v":2,"d":"2.00"},{"$f":"IF((H33*G33)=\"\",\"\",(H33*G33))","v":{"v":104,"d":"104.00"}},{"$f":"$J$13","v":{"v":52.68,"d":"$52.68"}},{"$f":"IF((J33*I33)=\"\",\"\",(J33*I33))","v":{"v":5478.72,"d":"$5,479"}}]
{"$rows_empty":12}
[{"$nulls":12},{"v":55.35,"d":"$55.35"}]

{"sheet":"Not Included in Burden Hours ","index":1,"n_rows":23,"n_cols":11,"rows_kept":23}
[]
[]
[]
[]
[]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"v":66,"d":"66 "},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",52]
["Average hours per response",null,{"$f":"I9/G9","v":{"v":1.1292904528410728,"d":"1.129"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G9/C7","v":{"v":21.012121212121215,"d":"21.01"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G13:G22)","v":{"v":1386.8000000000002,"d":"1,387"}},null,{"$f":"SUM(I13:I22)","v":{"v":1566.1,"d":"1,566"}},null,{"$f":"SUM(K13:K22)","v":{"v":82502.148,"d":"$82,502"}}]
["(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)"]
["APPLICATION"]
["1775.10(c)(1)","Application for Federal Assistance (Non-construction Programs)- Initial Submission","SF-424 (4040-0004)",{"v":1,"d":"100%"},{"$f":"D13*$K$7","v":52},1,{"$f":"E13*F13","v":52},0.75,{"$f":"IF((H13*G13)=\"\",\"\",(H13*G13))","v":39},{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"$f":"IF((J13*I13)=\"\",\"\",(J13*I13))","v":{"v":2054.52,"d":"$2,055"}}]
["1775.10(c)(1)","Application for Federal Assistance (Non-construction Programs)- Revised Submission","SF-424 (4040-0004)",{"v":0.8,"d":"80%"},{"$f":"D14*$K$7","v":41.6},1,{"v":41.6,"d":"42"},0.75,{"v":31.200000000000003,"d":"31"},{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"v":1643.6160000000002,"d":"$1,644"}]
["1775.10(c)(2)","Budget Information--Non-Construction Programs- Initial Submission","SF-424A (4040-0006)",{"v":1,"d":"100%"},{"$f":"D15*$K$7","v":52},1,52,3,156,{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"v":8218.08,"d":"$8,218"}]
["1775.10(c)(2)","Budget Information--Non-Construction Programs- Revised Submission","SF-424A (4040-0006)",{"v":0.8,"d":"80%"},{"$f":"D16*$K$7","v":41.6},1,{"v":41.6,"d":"42"},3,{"v":124.80000000000001,"d":"125"},{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"v":6574.464000000001,"d":"$6,574"}]
["1775.10(c)(8)","Equal Opportunity Agreement","RD 400-1",{"v":1,"d":"100%"},{"$f":"D17*$K$7","v":52},1,52,0.25,13,{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"v":684.84,"d":"$685"}]
["1775.10(c)(11)","Disclosure of Lobbying Activities","SF LLL",{"v":1,"d":"100%"},{"$f":"D18*$C$7","v":66},1,66,0.25,{"v":16.5,"d":"17"},{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"v":869.22,"d":"$869"}]
["AWARD CLOSING, SERVICING, AND REPORTING"]
["1775.18(a)","Request for Advance or Reimbursement (Corporation)","SF-270\n (0348-0004)",{"v":1,"d":"100%"},{"$f":"D20*$K$7","v":52},12,{"$f":"E20*F20","v":624},1,{"$f":"IF((H20*G20)=\"\",\"\",(H20*G20))","v":624},{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"$f":"IF((J20*I20)=\"\",\"\",(J20*I20))","v":{"v":32872.32,"d":"$32,872"}}]
["1775.18(a)","Request for Advance or Reimbursement (Corporation) - Extension","SF-270",{"v":0.4,"d":"40%"},{"$f":"D21*$K$7","v":20.8},12,{"$f":"E21*F21","v":{"v":249.60000000000002,"d":"250"}},1,{"$f":"IF((H21*G21)=\"\",\"\",(H21*G21))","v":{"v":249.60000000000002,"d":"250"}},{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"$f":"IF((J21*I21)=\"\",\"\",(J21*I21))","v":{"v":13148.928000000002,"d":"$13,149"}}]
[null,"Federal Financial Report","SF-425 (4040-0014)",{"v":1,"d":"100%"},{"$f":"D22*$K$7","v":52},4,{"$f":"E22*F22","v":208},1.5,{"$f":"IF((H22*G22)=\"\",\"\",(H22*G22))","v":312},{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"$f":"IF((J22*I22)=\"\",\"\",(J22*I22))","v":{"v":16436.16,"d":"$16,436"}}]
[null,"Federal Financial Report - Extension","SF-425 (4040-0014)",{"v":0.4,"d":"40%"},{"$f":"D23*$K$7","v":20.8},4,{"$f":"E23*F23","v":{"v":83.2,"d":"83"}},1.5,{"$f":"IF((H23*G23)=\"\",\"\",(H23*G23))","v":{"v":124.80000000000001,"d":"125"}},{"$f":"'Burden Hours Collection'!$J$13","v":{"v":52.68,"d":"$52.68"}},{"$f":"IF((J23*I23)=\"\",\"\",(J23*I23))","v":{"v":6574.464000000001,"d":"$6,574"}}]

{"sheet":"Ann Cost to Fed Gov Est","index":2,"n_rows":23,"n_cols":10,"rows_kept":23}
[{"$f":"'[1]12 BH Collection'!A1","v":"RURAL UTILITIES SERVICE"}]
["Technical Assistance Programs"]
[{"$f":"'[1]12 BH Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
["OMB # 0572 - 0012"]
[]
[]
["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 B (for base) Hourly Rate from table for St. Louis-St. Charles-Farmington, MO-IL."]
[]
[]
["2. Benefit % (OMB Memo M-08 13)","https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf ",{"$nulls":7},{"v":0.3625,"d":"36.25%"}]
[]
["Gray & Blue Columns have automatic formulas.  DO NOT input numbers in these columns.",{"$nulls":4},"Total  ",{"$f":"SUM(G20:G23)","v":{"v":285,"d":"285.00"}},{"$f":"SUM(H20:H22)","v":{"v":21334.501874999998,"d":"$21,334.50"}}]
["Staff \nPosition","GS Grade","GS Step","Hourly Rate Calc","Benefits Calc","Total Salary Rate Calc","Hours Required","Cost Subtotals"]
["Loan Specialist - State Office",12,5,{"v":48.36,"d":"$48.36"},{"$f":"D20*$J$16","v":{"v":17.5305,"d":"$17.53"}},{"$f":"D20+E20","v":{"v":65.8905,"d":"$65.89"}},{"v":80,"d":"80.00"},{"$f":"G20*F20","v":{"v":5271.24,"d":"$5,271.24"}}]
["Program Director - State Office",13,5,{"v":57.51,"d":"$57.51"},{"$f":"D21*$J$16","v":{"v":20.847375,"d":"$20.85"}},{"$f":"D21+E21","v":{"v":78.35737499999999,"d":"$78.36"}},{"v":5,"d":"5.00"},{"$f":"G21*F21","v":{"v":391.78687499999995,"d":"$391.79"}}]
["Loan Specialist - National Office",13,5,{"v":57.51,"d":"$57.51"},{"$f":"D22*$J$16","v":{"v":20.847375,"d":"$20.85"}},{"$f":"D22+E22","v":{"v":78.35737499999999,"d":"$78.36"}},{"v":200,"d":"200.00"},{"$f":"G22*F22","v":{"v":15671.474999999999,"d":"$15,671.48"}}]
[{"$nulls":4},{"$f":"D23*$J$16","v":{"v":0,"d":"$0.00"}},{"$f":"D23+E23","v":{"v":0,"d":"$0.00"}},null,{"$f":"G23*F23","v":{"v":0,"d":"$0.00"}}]