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

{"sheet":"12 Burden Hours Collection","index":0,"n_rows":49,"n_cols":11,"rows_kept":49}
["RURAL BUSINESS COOPERATIVE SERVICE"]
["RURAL INNOVATION STRONGER ECONOMY (RISE) GRANT PROGRAM"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570-0075"]
["2025-03-03"]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"v":60,"d":"60 "},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",10]
["Average hours per response",null,{"$f":"I9/G9","v":{"v":2.155920281359906,"d":"2.15592"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G9/C7","v":{"v":14.216666666666667,"d":"14.2167"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G12:G49)","v":853},null,{"$f":"ROUND(SUM(I12:I49),0)","v":{"v":1839,"d":"1,839"}},null,{"$f":"ROUND(SUM(K12:K49),-1)","v":{"v":167900,"d":"$167,900"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation \nReference\n4284.XXXX","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 & ELGIBILITY"]
[1103,"Rural in character determination request","written",{"v":0.1,"d":"10%"},{"$f":"ROUND(($C$7*D13),0)","v":{"v":6,"d":"6 "}},{"v":1,"d":"1 "},{"$f":"E13*F13","v":6},{"v":3,"d":"3.00"},{"$f":"ROUND(IF((H13*G13)=\"\",\"\",(H13*G13)),0)","v":18},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"ROUND(IF((J13*I13)=\"\",\"\",(J13*I13)),0)","v":{"v":1643,"d":"$1,643"}}]
[1105,"Request for Appeal","written",{"v":0.1,"d":"10%"},{"$f":"ROUND(($C$7*D14),0)","v":{"v":6,"d":"6 "}},{"v":1,"d":"1 "},6,{"v":2,"d":"2.00"},{"$f":"ROUND(IF((H14*G14)=\"\",\"\",(H14*G14)),0)","v":12},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"ROUND(IF((J14*I14)=\"\",\"\",(J14*I14)),0)","v":{"v":1096,"d":"$1,096"}}]
["1108(d); 1113(e)","Environmental Analysis ","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},{"$f":"E15*F15","v":60},{"v":4,"d":"4.00"},240,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":21912,"d":"$21,912"}]
["1108(e)","Discrimination Compliants","written",{"v":0.016666666666666666,"d":"2%"},{"v":1,"d":"1 "},{"v":1,"d":"1 "},1,{"v":2,"d":"2.00"},2,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"ROUND(IF((J16*I16)=\"\",\"\",(J16*I16)),0)","v":{"v":183,"d":"$183"}}]
["1109(a)","Certification of no outstanding judgements","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},{"$f":"E17*F17","v":60},0.25,15,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":1370,"d":"$1,370"}]
["1110(d)","Application modification","written",{"v":0.1,"d":"10%"},{"v":6,"d":"6 "},{"v":1,"d":"1 "},{"$f":"E18*F18","v":6},{"v":1,"d":"1.00"},6,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":548,"d":"$548"}]
["1110(f)","Application withdrawal","written",{"v":0.1,"d":"10%"},{"v":6,"d":"6 "},{"v":1,"d":"1 "},6,{"v":0.5,"d":"0.50"},3,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":274,"d":"$274"}]
["1114(b); 1119(c)","Matching funds availability","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},60,{"v":0.5,"d":"0.50"},30,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":2739,"d":"$2,739"}]
["1115(a)","Concept Proposal","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},{"$f":"E21*F21","v":60},{"$f":"1+1.5+2+3","v":{"v":7.5,"d":"7.50"}},450,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":41085,"d":"$41,085"}]
["1115(b)(1)","SAM registration","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},{"$f":"E22*F22","v":60},{"v":1,"d":"1.00"},60,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":5478,"d":"$5,478"}]
["1115(b)(2)(vi)","Identify ethnicity, race, and sex characteristics of lead applicant's leadership","written",{"v":0.016666666666666666,"d":"2%"},{"v":1,"d":"1 "},{"v":1,"d":"1 "},{"$f":"E23*F23","v":1},{"v":1,"d":"1.00"},1,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":91,"d":"$91"}]
["1115(b)(2)(vii)","Certification that the Applicant is a legal entity in good standing","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},50,0.15,8,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":730,"d":"$730"}]
["1115(b)(2)(viii)","Identify known relationship or association with Agency employee","written",{"v":0.30000000000000004,"d":"30%"},{"v":18,"d":"18 "},{"v":1,"d":"1 "},{"$f":"E25*F25","v":18},{"v":0.5,"d":"0.50"},9,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":822,"d":"$822"}]
["1115(b)(2)(ix)","Concept Proposal Updates","written",{"v":0.30000000000000004,"d":"30%"},{"v":18,"d":"18 "},{"v":1,"d":"1 "},18,{"v":1,"d":"1.00"},18,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":1643,"d":"$1,643"}]
["1115(b)(2)(x); 1117(a)","Readiness demonstration","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},60,{"v":2,"d":"2.00"},120,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":10956,"d":"$10,956"}]
["1115(b)(2)(xi); 1117(b)","Targeted inititatives documentation","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},60,{"v":2,"d":"2.00"},120,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":10956,"d":"$10,956"}]
["1115(b)(2)(xii)","Jobs and benefits to rural small and disadvantaged businesses discussion","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},60,{"v":2,"d":"2.00"},120,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":10956,"d":"$10,956"}]
["1115(b)(2)(xiii); 1117(d); 1117(f)","Targeted region discussion","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},60,{"v":4,"d":"4.00"},240,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":21912,"d":"$21,912"}]
["1115(b)(2)(xiv)","Financial information","written",{"v":1,"d":"100%"},{"v":60,"d":"60 "},{"v":1,"d":"1 "},60,{"v":2,"d":"2.00"},120,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":10956,"d":"$10,956"}]
["1117(c)","Project support documentation","written",{"v":0.5,"d":"50%"},{"v":30,"d":"30 "},{"v":1,"d":"1 "},30,{"v":1,"d":"1.00"},30,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":2739,"d":"$2,739"}]
[null,"Build America Buy America Requirements","written",{"v":0.16666666666666666,"d":"17%"},{"v":10,"d":"10 "},{"v":1,"d":"1 "},10,{"v":2,"d":"2.00"},20,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":1826,"d":"$1,826"}]
["AWARDING & ADMINISTERING GRANT"]
["1110(g)(1)","Request for time extension","written",{"v":0.2,"d":"20%"},{"$f":"ROUND((D35*$K$7),0)","v":{"v":2,"d":"2 "}},{"v":1,"d":"1 "},{"$f":"E35*F35","v":2},{"v":0.5,"d":"0.50"},{"$f":"ROUND(IF((H35*G35)=\"\",\"\",(H35*G35)),0)","v":1},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"ROUND(IF((J35*I35)=\"\",\"\",(J35*I35)),0)","v":{"v":91,"d":"$91"}}]
["1119(a)","Bonding and insurance requirement","written",{"v":1,"d":"100%"},{"$f":"ROUND((D36*$K$7),0)","v":{"v":10,"d":"10 "}},{"v":1,"d":"1 "},10,{"v":0.5,"d":"0.50"},5,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":457,"d":"$457"}]
["1119(d)(iii)","SAM registration maintenance","written",{"v":1,"d":"100%"},{"v":10,"d":"10 "},{"v":1,"d":"1 "},{"$f":"E37*F37","v":10},{"v":1,"d":"1.00"},10,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":913,"d":"$913"}]
[null,"Build America Buy America Requirements","written",{"v":1,"d":"100%"},{"v":10,"d":"10 "},{"v":1,"d":"1 "},10,{"v":5,"d":"5.00"},50,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":4565,"d":"$4,565"}]
["SERVICING & REPORTING"]
["1120(a)","Inspection","written",{"v":1,"d":"100%"},{"v":10,"d":"10 "},{"v":1,"d":"1 "},{"$f":"E40*F40","v":10},{"v":4,"d":"4.00"},{"$f":"ROUND(IF((H40*G40)=\"\",\"\",(H40*G40)),0)","v":40},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"ROUND(IF((J40*I40)=\"\",\"\",(J40*I40)),0)","v":{"v":3652,"d":"$3,652"}}]
["1120(b)(2)","Programmatic changes- project cost or scope","written",{"v":0.2,"d":"20%"},{"v":2,"d":"2 "},{"v":1,"d":"1 "},{"$f":"E41*F41","v":2},{"v":2,"d":"2.00"},4,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":365,"d":"$365"}]
["1120(b)(3)","Programmatic changes- change in contractor or vendor","written",{"v":0.2,"d":"20%"},{"v":2,"d":"2 "},{"v":1,"d":"1 "},2,{"v":1,"d":"1.00"},2,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":183,"d":"$183"}]
["1120(c)","Transfer of applicant","written",{"v":0.1,"d":"10%"},{"v":1,"d":"1 "},{"v":1,"d":"1 "},1,{"v":1,"d":"1.00"},1,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":91,"d":"$91"}]
["1120(c)","Transfer of Financial Assistance Agreement","written",{"v":0.2,"d":"20%"},{"v":2,"d":"2 "},{"v":1,"d":"1 "},2,{"v":1,"d":"1.00"},2,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":183,"d":"$183"}]
["1120(d)","Disposition of acquired property","written",{"v":0.2,"d":"20%"},{"v":2,"d":"2 "},{"v":1,"d":"1 "},2,{"v":1,"d":"1.00"},2,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":183,"d":"$183"}]
["1120(e)(1)","Financial management","written",{"v":1,"d":"100%"},{"v":10,"d":"10 "},{"v":1,"d":"1 "},10,{"v":1,"d":"1.00"},10,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":913,"d":"$913"}]
["1120(e)(2)","Records management","written",{"v":1,"d":"100%"},{"v":10,"d":"10 "},{"v":1,"d":"1 "},10,{"v":2,"d":"2.00"},20,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":1826,"d":"$1,826"}]
["1120(f)","Audit requirements","written",{"v":1,"d":"100%"},{"v":10,"d":"10 "},{"v":1,"d":"1 "},10,{"v":1,"d":"1.00"},10,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":913,"d":"$913"}]
["1120(h)(2)","Semi-annual performance report","written",{"v":1,"d":"100%"},{"v":10,"d":"10 "},{"v":2,"d":"2 "},20,{"v":2,"d":"2.00"},40,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":3652,"d":"$3,652"}]

{"sheet":"12 Not Inc in Burden Hours","index":1,"n_rows":28,"n_cols":11,"rows_kept":28}
[{"$f":"'12 Burden Hours Collection'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"RURAL INNOVATION STRONGER ECONOMY (RISE) GRANT PROGRAM"}]
[{"$f":"'12 Burden Hours Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0570-0075"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"2025-03-03"}]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"$f":"'12 Burden Hours Collection'!C7","v":{"v":60,"d":"60 "}},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",{"$f":"'12 Burden Hours Collection'!K7","v":10}]
["Average hours per response",null,{"$f":"I9/G9","v":{"v":1.7906976744186047,"d":"1.791"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G9/C7","v":{"v":7.166666666666667,"d":"7.17"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G13:G28)","v":430},null,{"$f":"SUM(I13:I28)","v":770},null,{"$f":"SUM(K13:K28)","v":{"v":70301,"d":"$70,301"}}]
["(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 & ELGIBILITY"]
["1108(c)","Compliance Review","RD 400-8\n(0570-0062; 0575-0018, 0575-0189)",{"v":1,"d":"100%"},{"$f":"D13*$C$7","v":60},1,{"$f":"E13*F13","v":60},8,{"$f":"IF((H13*G13)=\"\",\"\",(H13*G13))","v":480},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"IF((J13*I13)=\"\",\"\",(J13*I13))","v":{"v":43824,"d":"$43,824"}}]
["1115(b)(2)(i)","Application for Federral Assistance","SF-424       (4040-0004)",{"v":1,"d":"100%"},{"$f":"D14*$C$7","v":60},1,{"$f":"E14*F14","v":60},1,{"$f":"IF((H14*G14)=\"\",\"\",(H14*G14))","v":60},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"IF((J14*I14)=\"\",\"\",(J14*I14))","v":{"v":5478,"d":"$5,478"}}]
["1115(b)(2)(ii)","Budget Information - Non-Construction Programs","SF 424A\n(4040-0006)",{"v":1,"d":"100%"},60,1,60,1,60,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":5478,"d":"$5,478"}]
["1115(b)(2)(iii)","Budget Information - Construction Programs","SF-424C\n(4040-0008)",{"v":0.5,"d":"50%"},30,1,30,1,30,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":2739,"d":"$2,739"}]
["115(b)(2)(iv)","Assurances - Construction Programs","SF-424D\n(4040-0009)",{"v":0.5,"d":"50%"},30,1,30,0.5,15,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":1369.5,"d":"$1,370"}]
["1115(b)(2)(v)","Equal Opportunity Agreement","RD 400-1\n(0575-0201)",{"v":1,"d":"100%"},60,1,{"$f":"E18*F18","v":60},{"$f":"10/60","v":{"v":0.16666666666666666,"d":"0.1667"}},{"$f":"IF((H18*G18)=\"\",\"\",(H18*G18))","v":10},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"IF((J18*I18)=\"\",\"\",(J18*I18))","v":{"v":913,"d":"$913"}}]
["AWARDING & ADMINISTERING GRANT"]
["1103; 1110(g); 1119(c),(e)&(f); 1120; 1120(c);","Rural Business-Cooperative Service Financial Assistance Agreement","RD 4280-2 (0570-0067)",{"v":1,"d":"100%"},{"$f":"D20*$K$7","v":10},1,{"$f":"E20*F20","v":10},1,{"$f":"IF((H20*G20)=\"\",\"\",(H20*G20))","v":10},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"IF((J20*I20)=\"\",\"\",(J20*I20))","v":{"v":913,"d":"$913"}}]
["1119(b)","Request for Obligation of Funds","RD 1940-1 (0570-0062, 0067)",{"v":1,"d":"100%"},{"$f":"D21*$K$7","v":10},1,{"$f":"E21*F21","v":10},0.25,{"$f":"IF((H21*G21)=\"\",\"\",(H21*G21))","v":{"v":2.5,"d":"3"}},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"IF((J21*I21)=\"\",\"\",(J21*I21))","v":{"v":228.25,"d":"$228"}}]
["1119(b)","Letter of Intent to Meet Conditions","RD 1942-46 (0575-0015, 0570-0021, 0061, 0062, 0572-0137)",{"v":1,"d":"100%"},{"$f":"D22*$K$7","v":10},1,{"$f":"E22*F22","v":10},1,{"$f":"IF((H22*G22)=\"\",\"\",(H22*G22))","v":10},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"IF((J22*I22)=\"\",\"\",(J22*I22))","v":{"v":913,"d":"$913"}}]
[null,"Assurance Agreement","RD 400-4\n(0575-0201)",{"v":1,"d":"100%"},{"$f":"D23*$K$7","v":10},1,{"$f":"E23*F23","v":10},0.25,{"$f":"IF((H23*G23)=\"\",\"\",(H23*G23))","v":{"v":2.5,"d":"3"}},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"IF((J23*I23)=\"\",\"\",(J23*I23))","v":{"v":228.25,"d":"$228"}}]
[null,"Disclosure of Lobbying Activities","SF LLL        (4040-0013)",{"v":1,"d":"100%"},10,1,10,1,10,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":913,"d":"$913"}]
["SERVICING & REPORTING"]
["1120(g)","Request for Advance or Reimbursement","SF-270        (4040-0012)",{"v":1,"d":"100%"},{"$f":"D26*$K$7","v":10},4,{"$f":"E26*F26","v":40},1,{"$f":"IF((H26*G26)=\"\",\"\",(H26*G26))","v":40},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"$f":"IF((J26*I26)=\"\",\"\",(J26*I26))","v":{"v":3652,"d":"$3,652"}}]
["1120(g)","Outlay Report and Request for Reimbursement for Construction Projects","SF-271      (4040-0011)",{"v":0.5,"d":"50%"},5,4,20,1,20,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":1826,"d":"$1,826"}]
["1120(h)(1)","Federal Financial Report","SF-425      (4040-0014)",{"v":1,"d":"100%"},10,2,20,1,20,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":91.3,"d":"$91.30"}},{"v":1826,"d":"$1,826"}]

{"sheet":"12 Est Prof Wage Rate","index":2,"n_rows":36,"n_cols":7,"rows_kept":36}
[{"$f":"'12 Burden Hours Collection'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"RURAL INNOVATION STRONGER ECONOMY (RISE) GRANT PROGRAM"}]
[{"$f":"'12 Burden Hours Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0570-0075"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"2025-03-03"}]
[]
["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 (December 17, 2024) News Release for Employer Costs for Employee Compensation - September 2024 opens in separate tab."]
["     d.  On first page, second paragraph use the benefit costs % of: ",null,null,{"v":0.296,"d":"29.60%"}]
["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)"]
["Public Relations Managers","11-2032",{"v":76.65,"d":"$76.65"},{"$f":"IF(C25=0,\"\",(C25*$D$18))","v":{"v":22.6884,"d":"$22.69"}},{"$f":"IF(SUM(C25:D25)=0,\"\",SUM(C25:D25))","v":{"v":99.33840000000001,"d":"$99.34"}},{"v":0.5,"d":"50%"},{"$f":"IF(E25=\"\",\"\",(E25*F25))","v":{"v":49.669200000000004,"d":"$49.67"}}]
["Fundraising Managers","11-2033",{"v":64.24,"d":"$64.24"},{"$f":"IF(C26=0,\"\",(C26*$D$18))","v":{"v":19.01504,"d":"$19.02"}},{"$f":"IF(SUM(C26:D26)=0,\"\",SUM(C26:D26))","v":{"v":83.25504,"d":"$83.26"}},{"v":0.5,"d":"50%"},{"$f":"IF(E26=\"\",\"\",(E26*F26))","v":{"v":41.62752,"d":"$41.63"}}]
[{"$nulls":3},{"$f":"IF(C27=0,\"\",(C27*$D$18))","v":""},{"$f":"IF(SUM(C27:D27)=0,\"\",SUM(C27:D27))","v":""},null,{"$f":"IF(E27=\"\",\"\",(E27*F27))","v":""}]
[{"$nulls":3},{"$f":"IF(C28=0,\"\",(C28*$D$18))","v":""},{"$f":"IF(SUM(C28:D28)=0,\"\",SUM(C28:D28))","v":""},null,{"$f":"IF(E28=\"\",\"\",(E28*F28))","v":""}]
{"$rows_empty":7}
["TOTAL",null,null,{"$f":"IF(C36=0,\"\",(C36*#REF!))","v":""},null,{"$f":"SUM(F25:F35)","v":{"v":1,"d":"100%"}},{"$f":"ROUND(SUM(G25:G35),1)","v":{"v":91.3,"d":"$91.30"}}]

{"sheet":"14 Annual Cost to Fed Gov Est","index":3,"n_rows":30,"n_cols":11,"rows_kept":30}
[{"$f":"'12 Burden Hours Collection'!A1","v":"RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"RURAL INNOVATION STRONGER ECONOMY (RISE) GRANT PROGRAM"}]
[{"$f":"'12 Burden Hours Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0570-0075"}]
["2025-03-03"]
[]
["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://obamawhitehouse.archives.gov/sites/default/files/omb/assets/omb/memoranda/fy2008/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":"H22+H25+H29","v":{"v":51,"d":"51.00"}},{"$f":"I22+I25+I29","v":{"v":4190,"d":"$4,190"}},null,{"$f":"K22+K25+K29","v":{"v":86000,"d":"$86,000"}}]
["Staff \nPosition","GS Grade","GS Step","GS \nSalary","Hourly Rate Calc","Benefits Calc","Total Salary Rate Calc","Hours Required","Cost Subtotals","# of Entities","Total Costs"]
["APPLICATION & ELGIBILITY",{"$nulls":6},{"$f":"SUM(H23:H24)","v":{"v":11,"d":"11.00"}},{"$f":"ROUND((SUM(I23:I24)),0)","v":{"v":882,"d":"$882"}},60,{"$f":"J22*I22","v":{"v":52920,"d":"$52,920"}}]
["Program Analyst ",13,5,{"v":122465,"d":"$122,465"},{"$f":"(D23/52)/40","v":{"v":58.87740384615385,"d":"$58.88"}},{"$f":"E23*$K$18","v":{"v":21.34305889423077,"d":"$21.34"}},{"$f":"E23+F23","v":{"v":80.22046274038462,"d":"$80.22"}},{"v":10,"d":"10.00"},{"$f":"H23*G23","v":{"v":802.2046274038462,"d":"$802.20"}}]
["Environmental Protection Specialist",13,5,{"v":122465,"d":"$122,465"},{"$f":"(D24/52)/40","v":{"v":58.87740384615385,"d":"$58.88"}},{"$f":"E24*$K$18","v":{"v":21.34305889423077,"d":"$21.34"}},{"$f":"E24+F24","v":{"v":80.22046274038462,"d":"$80.22"}},{"v":1,"d":"1.00"},{"$f":"H24*G24","v":{"v":80.22046274038462,"d":"$80.22"}}]
["AWARDING & ADMINISTERING GRANT",{"$nulls":6},{"$f":"SUM(H26:H28)","v":{"v":28,"d":"28.00"}},{"$f":"ROUND((SUM(I26:I28)),0)","v":{"v":2345,"d":"$2,345"}},10,{"$f":"J25*I25","v":{"v":23450,"d":"$23,450"}}]
["Program Analyst ",13,5,{"v":122465,"d":"$122,465"},{"$f":"(D26/52)/40","v":{"v":58.87740384615385,"d":"$58.88"}},{"$f":"E26*$K$18","v":{"v":21.34305889423077,"d":"$21.34"}},{"$f":"E26+F26","v":{"v":80.22046274038462,"d":"$80.22"}},{"v":26,"d":"26.00"},{"$f":"H26*G26","v":{"v":2085.73203125,"d":"$2,085.73"}}]
["Assistant Administrator",null,null,{"v":187930,"d":"$187,930"},{"$f":"(D27/52)/40","v":{"v":90.35096153846153,"d":"$90.35"}},{"$f":"E27*$K$18","v":{"v":32.752223557692304,"d":"$32.75"}},{"$f":"E27+F27","v":{"v":123.10318509615384,"d":"$123.10"}},{"v":1,"d":"1.00"},{"$f":"H27*G27","v":{"v":123.10318509615384,"d":"$123.10"}}]
["Administrator ",null,null,{"v":207500,"d":"$207,500"},{"v":99.75961538461539,"d":"$99.76"},{"v":36.16286057692307,"d":"$36.16"},{"v":135.92247596153845,"d":"$135.92"},{"v":1,"d":"1.00"},{"v":135.92247596153845,"d":"$135.92"}]
["SERVICING & REPORTING",{"$nulls":6},{"$f":"SUM(H30:H30)","v":{"v":12,"d":"12.00"}},{"$f":"ROUND((SUM(I30:I30)),0)","v":{"v":963,"d":"$963"}},10,{"$f":"J29*I29","v":{"v":9630,"d":"$9,630"}}]
["Program Analyst ",13,5,{"v":122465,"d":"$122,465"},{"$f":"(D30/52)/40","v":{"v":58.87740384615385,"d":"$58.88"}},{"$f":"E30*$K$18","v":{"v":21.34305889423077,"d":"$21.34"}},{"$f":"E30+F30","v":{"v":80.22046274038462,"d":"$80.22"}},{"v":12,"d":"12.00"},{"v":962.6455528846154,"d":"$962.65"}]