{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Burden","Prof. Wage","Federal","Not in Burden"],"read":"whole","date_system":"1900"}

{"sheet":"Burden","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[31,3,31,6],[32,6,32,8],[33,2,33,5]]}
["RURAL ENERGY SAVINGS PROGRAM"]
["Rural Utilities Service, USDA"]
["OMB # 0572-0151"]
["Section of Rule ","Title","Form No. (if any)","No. of Respondents","Reports Filed","Total Responses (D) x (E)","Estimated No. of Manhours per response","Estimated Total Manhours (F) x (G)","Wage Class","Total Cost (H) x (I)"]
["(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)"]
[null,"Application"]
[]
[null,"SAM Registration","Sam.gov",{"v":25,"d":"25 "},{"v":1,"d":"1 "},{"$f":"D8*E8","v":{"v":25,"d":"25 "}},{"v":2,"d":"2.00"},{"$f":"G8*F8","v":50},76.55,{"$f":"H8*I8","v":{"v":3827.5,"d":"$3,828"}}]
[]
[null,"Narrative Grant Proposal and Application","Written",{"v":25,"d":"25 "},{"v":1,"d":"1 "},{"$f":"D10*E10","v":{"v":25,"d":"25 "}},{"v":10,"d":"10.00"},{"$f":"F10*G10","v":250},76.55,{"$f":"H10*I10","v":{"v":19137.5,"d":"$19,138"}}]
[]
[null,"RUS Environmental Questionnaire/Profile","Written",{"v":25,"d":"25 "},{"v":1,"d":"1 "},{"$f":"D12*E12","v":{"v":25,"d":"25 "}},{"v":6,"d":"6.00"},{"$f":"G12*F12","v":150},76.55,{"$f":"I12*H12","v":{"v":11482.5,"d":"$11,483"}}]
[]
[]
[]
[]
[]
[null,"Award Closing, Servicing and Reporting"]
[]
[null,"Grant Agreement","Written",{"v":8,"d":"8 "},1,{"$f":"SUM(D20*E20)","v":8},{"v":1,"d":"1.00"},{"$f":"F20*G20","v":8},76.55,{"$f":"I20*H20","v":{"v":612.4,"d":"$612"}}]
[]
[null,"Performance Reports","Written",{"v":40,"d":"40 "},4,160,{"v":2,"d":"2.00"},{"$f":"F22*G22","v":320},76.55,{"$f":"I22*H22","v":{"v":24496,"d":"$24,496"}}]
[]
[null,"Final Performance Report","Written",{"v":8,"d":"8 "},1,8,{"v":1,"d":"1.00"},{"$f":"F24*G24","v":8},76.55,{"$f":"I24*H24","v":{"v":612.4,"d":"$612"}}]
[]
[null,"SAM Maintenance","Sam.gov",40,1,{"$f":"SUM(D26*E26)","v":40},{"v":1,"d":"1.00"},{"$f":"SUM(F26*G26)","v":40},76.55,{"$f":"I26*H26","v":{"v":3062,"d":"$3,062"}}]
[]
[]
[{"$nulls":5},{"$f":"SUM(F8:F28)","v":291},null,{"$f":"SUM(H8:H28)","v":826},null,{"$f":"SUM(J8:J28)","v":{"v":63230.3,"d":"$63,230"}}]
[null,"Number of Respondents",null,{"v":40,"d":"40 "}]
[null,"Total Estimated Annual Responses",{"$nulls":3},{"$f":"F29","v":291}]
[null,"Total Estimated Annual Burden Hours",{"$nulls":5},{"$f":"H29","v":826}]
[null,"Total Annual Burden Cost",{"$nulls":7},{"$f":"J29","v":{"v":63230.3,"d":"$63,230"}}]
[null,"Total Estimated Burden Hours per response",{"$nulls":4},{"$f":"H32/F31","v":{"v":2.838487972508591,"d":"2.838"}}]
[]
["Notes:  ","Burden has not been included for record keeping because there is no requirement to maintain the records past three years."]

{"sheet":"Prof. Wage","index":1,"n_rows":12,"n_cols":12,"rows_kept":12}
["Table 2:  Estimated Wages for Employee Time"]
[]
["Wage Category","Mean Wage*","29.6% Benefits**","Total Hourly Wage",null,"*","http://www.bls.gov/oes/current/oes_stru.htm",{"$nulls":4},"Occupational Employment and Wages, May 2022"]
["General and Operatons Manager (11-021)",59.07,{"$f":"B4*A12","v":{"v":17.48472,"d":"17.48"}},{"$f":"B4+C4","v":{"v":76.55472,"d":"76.55"}}]
[{"$nulls":5},"**","https://www.bls.gov/news.release/pdf/ecec.pdf",{"$nulls":4},"EMPLOYER COSTS FOR EMPLOYEE COMPENSATION – DECEMBER 2023"]
[]
[]
[]
[]
[]
[]
[0.296,"Benefit"]

{"sheet":"Federal","index":2,"n_rows":50,"n_cols":7,"rows_kept":50}
[]
[]
["Table 4:  Wage Rates for Staff Positions:"]
["Staff Position","Wage Rate[1]","Benefits (36.25%)","Hourly Rate"]
["GS 5, Step 5",{"v":24.52,"d":"$24.52"},{"$f":"B5*0.3625","v":{"v":8.888499999999999,"d":"$8.89"}},{"$f":"B5+C5","v":{"v":33.4085,"d":"$33.41"}},null,null,"https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/salary-tables/24Tables/html/DCB_h.aspx"]
["GS 12, Step 5",{"v":53.87,"d":"$53.87"},{"$f":"B6*0.3625","v":{"v":19.527874999999998,"d":"$19.53"}},{"$f":"B6+C6","v":{"v":73.397875,"d":"$73.40"}}]
["GS 13, Step 5",{"v":64.06,"d":"$64.06"},{"$f":"B7*0.3625","v":{"v":23.22175,"d":"$23.22"}},{"$f":"B7+C7","v":{"v":87.28175,"d":"$87.28"}},null,null,"https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/2023/general-schedule  "]
[{"$nulls":6},"Executive Senior Level (opm.gov)"]
[{"$nulls":5},"https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf "]
{"$rows_empty":8}
["Staff Position","Total Hourly Wage","Hours Required","Cost"]
["Application Receipt, Review, Evaluate and Rank"]
["GS 12, Step 5",{"$f":"D6","v":{"v":73.397875,"d":"$73.40"}},10,{"$f":"B20*C20","v":{"v":733.97875,"d":"$733.98"}}]
[]
[]
[]
[]
[]
["Grant Award and Administraton"]
["GS 5, Step 5",{"$f":"D5","v":{"v":33.4085,"d":"$33.41"}},6,{"$f":"B27*C27","v":{"v":200.45099999999996,"d":"$200.45"}}]
["GS 12, Step 5",{"$f":"D6","v":{"v":73.397875,"d":"$73.40"}},8,{"$f":"B28*C28","v":{"v":587.183,"d":"$587.18"}}]
["GS 13, Step 5",{"$f":"D7","v":{"v":87.28175,"d":"$87.28"}},1,{"$f":"B29*C29","v":{"v":87.28175,"d":"$87.28"}}]
[]
[]
[]
["Cost Each",null,null,{"$f":"D27+D28+D29","v":{"v":874.91575,"d":"$874.92"}}]
[]
["Post Award Monitoring"]
["GS 5, Step 5",{"$f":"D5","v":{"v":33.4085,"d":"$33.41"}},10,{"$f":"B36*C36","v":{"v":334.085,"d":"$334.09"}}]
["GS 12, Step 5",{"$f":"D6","v":{"v":73.397875,"d":"$73.40"}},20,{"$f":"B37*C37","v":{"v":1467.9575,"d":"$1,467.96"}}]
[]
[]
["Cost each ",null,null,{"$f":"D36+D37","v":{"v":1802.0425,"d":"$1,802.04"}}]
[]
[]
[]
["Table 5:  Total Cost to the Federal Government:"]
["Stage","Cost of Each","Number of Entities","Total Cost"]
["Application Receipt, Review, Evaluate and Rank",{"$f":"D20","v":{"v":733.97875,"d":"$733.98"}},25,{"$f":"B46*C46","v":{"v":18349.46875,"d":"$18,349.47"}}]
["Grant Award and Administration",{"$f":"D33","v":{"v":874.91575,"d":"$874.92"}},8,{"$f":"B47*C47","v":{"v":6999.326,"d":"$6,999.33"}}]
["Post Award Monitoring",{"$f":"D40","v":{"v":1802.0425,"d":"$1,802.04"}},40,{"$f":"B48*C48","v":{"v":72081.7,"d":"$72,081.70"}}]
[]
["Total Cost to Federal Government",null,null,{"$f":"D46+D47+D48","v":{"v":97430.49475,"d":"$97,430.49"}}]

{"sheet":"Not in Burden","index":3,"n_rows":14,"n_cols":10,"rows_kept":14}
[]
[]
["Section of Rule ","Title","Form No. (if any)","No. of Respondents","Reports Filed","Total Responses (D) x (E)","Estimated No. of Manhours per response","Estimated Total Manhours (F) x (G)","Wage Class","Total Cost (H) x (I)"]
["(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)"]
[null,"Application for Federal Assistance  (4040-0004)"," SF-424",{"v":25,"d":"25 "},{"v":1,"d":"1.00"},{"$f":"SUM(D5*E5)","v":{"v":25,"d":"25 "}},{"v":1.1,"d":"1.10"}]
[null,"Budget Information Non-Construction Programs (4040-0006)","SF-424A",{"v":25,"d":"25 "},{"v":1,"d":"1.00"},{"$f":"SUM(D6*E6)","v":{"v":25,"d":"25 "}},{"v":1.8,"d":"1.80"}]
[null,"OR Budget Information Construction Programs (4040-0008)","SF-424C"]
[null,"Assurances Construction Programs (4040-0009)","SF-424D",{"v":25,"d":"25 "},{"v":1,"d":"1.00"},{"v":40,"d":"40 "}]
[null,"Letter of Intent (common form pkg pending in OIRA )","RD 1942-46",{"v":8,"d":"8 "},{"v":1,"d":"1.00"},{"$f":"SUM(D9*E9)","v":{"v":8,"d":"8 "}},{"v":1,"d":"1.00"}]
[null,"Disclosure of Lobbying Activities (4040-0013)","SF-LLL",{"v":25,"d":"25 "},{"v":1,"d":"1.00"},{"$f":"SUM(D10*E10)","v":{"v":25,"d":"25 "}},{"v":0.1,"d":"0.10"}]
[null,"Post Award:"]
[null,"Federal Financial Report (4040-0014)","SF-425",{"v":40,"d":"40 "},{"v":4,"d":"4.00"},{"$f":"SUM(D12*E12)","v":{"v":160,"d":"160 "}},{"v":1,"d":"1.00"}]
[null,"Request for Reimbursement or Advance of Funds (4040-0012)","SF-270",{"v":2,"d":"2 "},{"v":4,"d":"4.00"},{"$f":"D13*E13","v":{"v":8,"d":"8 "}},{"v":1,"d":"1.00"}]
[null,"Outlay Report and Request for Reimbursement (Const.)        (4040-0011)","SF-271",{"v":38,"d":"38 "},{"v":4,"d":"4.00"},{"$f":"SUM(D14*E14)","v":{"v":152,"d":"152 "}},{"v":1,"d":"1 "}]