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

{"sheet":"Burden","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[42,3,42,6],[43,6,43,8],[44,2,44,5]]}
["RUS Electric Loan Application and Related Reporting Burdens"]
["Rural Utilities Service, USDA"]
["OMB # 0572-0032"]
["2024-07-01"]
["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,"Sam Registration","Sam.gov",{"v":101,"d":"101.00"},1,{"$f":"D9*E9","v":{"v":101,"d":"101 "}},{"v":2,"d":"2.00"},{"$f":"F9*G9","v":202},70.19,{"$f":"H9*I9","v":{"v":14178.38,"d":"$14,178"}}]
["1710.501(a)(1)","Loan Application Letter","written",{"v":101,"d":"101.00"},1,{"$f":"D10*E10","v":{"v":101,"d":"101 "}},{"v":1,"d":"1.00"},{"$f":"F10*G10","v":101},70.19,{"$f":"H10*I10","v":{"v":7089.19,"d":"$7,089"}}]
["1710.501(a)(3)","Cost Estimates and Loan Budget for Electric Borrowers","Form 740c",{"v":101,"d":"101 "},1,{"v":101,"d":"101 "},{"v":2.5,"d":"2.50"},{"v":252.5,"d":"253"},70.19,{"v":17722.975,"d":"$17,723"}]
[1710.407,"Energy Efficiency Business Plan","written",{"v":1,"d":"1 "},1,{"v":1,"d":"1 "},{"v":2,"d":"2.00"},2,70.19,{"v":140.38,"d":"$140"}]
[1710.408,"Energy Efficiency Quality Assurance Plan","written",{"v":1,"d":"1 "},1,{"v":1,"d":"1 "},{"v":2,"d":"2.00"},2,70.19,{"v":140.38,"d":"$140"}]
[1710.411,"Analytical Support Documentation","written",{"v":1,"d":"1 "},1,{"v":1,"d":"1 "},{"v":10,"d":"10.00"},10,70.19,{"v":701.9,"d":"$702"}]
[null,"Financial and Operating Report"]
["1710.501(a)(4)","a.  Distribution Borrowers"]
[null,"         Loan Application","written",{"v":82,"d":"82 "},1,{"$f":"D17*E17","v":{"v":82,"d":"82 "}},{"v":2,"d":"2.00"},{"$f":"F17*G17","v":164},70.19,{"$f":"H17*I17","v":{"v":11511.16,"d":"$11,511"}}]
["1718.104 Article V,     Sec 5-19","        Annual Submission - Electronic completion - Web","online",{"v":520,"d":"520 "},1,{"v":520,"d":"520 "},{"v":15,"d":"15.00"},{"v":7800,"d":"7,800"},70.19,{"v":547482,"d":"$547,482"}]
["1710.501(a)(4)","b.  Power Supply Borrowers (G&T)"]
[null,"        Loan Application","written",{"v":19,"d":"19 "},1,{"$f":"D20*E20","v":{"v":19,"d":"19 "}},{"v":2,"d":"2.00"},{"$f":"F20*G20","v":38},70.19,{"$f":"H20*I20","v":{"v":2667.22,"d":"$2,667"}}]
["1718.104 Article V,     Sec 5-19","       Annual Submission - Electronic completion - Web","online",{"v":88,"d":"88 "},1,{"v":88,"d":"88 "},{"v":21,"d":"21.00"},{"v":1848,"d":"1,848"},70.19,{"v":129711.12,"d":"$129,711"}]
["1710.501(a)(2)","Special Resolution","written",{"v":20,"d":"20 "},1,{"v":20,"d":"20 "},{"v":1.5,"d":"1.50"},30,70.19,{"v":2105.7,"d":"$2,106"}]
["1710.501(b)(7)","Statements from Counsel","written",{"v":10,"d":"10 "},1,{"v":10,"d":"10 "},{"v":0.5,"d":"0.50"},5,70.19,{"v":350.95,"d":"$351"}]
["1710.501(b)(1) and (2)","Articles of Incorporation and Bylaws","written",{"v":101,"d":"101 "},1,{"v":101,"d":"101 "},{"v":0.5,"d":"0.50"},{"v":50.5,"d":"51"},70.19,{"$f":"H24*I24","v":{"v":3544.595,"d":"$3,545"}}]
["1710.501(a)(7)","Rate Disparity and Consumer Income Data","written",1,1,{"v":1,"d":"1 "},{"v":0.5,"d":"0.50"},{"v":0.5,"d":"1"},70.19,{"v":35.095,"d":"$35"}]
["1710.501(a)(6)","Long Range Financial Forecast and Board Resolution (Can use the form 325 or similar format)","Form 325 or written",{"v":101,"d":"101 "},1,{"v":101,"d":"101 "},{"v":17.5,"d":"17.50"},{"v":1767.5,"d":"1,768"},70.19,{"v":124060.825,"d":"$124,061"}]
["1710.501(a)(5) and 1710, subpart E","Load Forecast and Board Resolution","written",82,1,{"v":82,"d":"82 "},{"v":21.5,"d":"21.50"},{"v":1763,"d":"1,763"},70.19,{"v":123744.97,"d":"$123,745"}]
["1710.501(b)(10) and 1710, subpart F","Construction Workplan (CWP), Related Engineering Studies","written",101,1,{"v":101,"d":"101 "},{"v":229.5,"d":"229.50"},{"v":23179.5,"d":"23,180"},70.19,{"v":1626969.105,"d":"$1,626,969"}]
[1710.255,"Energy Efficiency Workplan (EEWP), Related Engineering Studies","written",{"v":1,"d":"1 "},1,{"v":1,"d":"1 "},{"v":3.5,"d":"3.50"},{"v":3.5,"d":"4"},70.19,{"v":245.665,"d":"$246"}]
[null,"Alternative Source of Power Statement","Written",{"v":1,"d":"1 "},1,{"v":1,"d":"1 "},{"v":0.5,"d":"0.50"},{"$f":"G30*F30","v":{"v":0.5,"d":"0.50"}},70.19,{"$f":"I30*H30","v":{"v":35.095,"d":"$35"}}]
["1710.501(b)(4)","Audited Financials","written",{"v":10,"d":"10 "},1,{"v":10,"d":"10 "},{"v":0.5,"d":"0.50"},5,70.19,{"v":350.95,"d":"$351"}]
["1710.501(b)(5)","List of Secured, Outstanding Debt with Lender names","written",10,1,{"v":10,"d":"10 "},{"v":0.5,"d":"0.50"},5,70.19,{"v":350.95,"d":"$351"}]
["1710.501(b)(6)","Evidence of collateral ","written",{"v":10,"d":"10 "},1,{"v":10,"d":"10 "},0.75,{"v":7.5,"d":"8"},70.19,{"v":526.425,"d":"$526"}]
["1710.501(a)(9)","Uniform Relocation Act","written",{"v":101,"d":"101 "},1,{"v":101,"d":"101 "},{"v":0.5,"d":"0.50"},{"v":50.5,"d":"51"},70.19,{"v":3544.595,"d":"$3,545"}]
["1710.501(a)(10)","Certification Regarding Lobbying","written",101,1,{"v":101,"d":"101 "},{"v":0.5,"d":"0.50"},{"v":50.5,"d":"51"},70.19,{"v":3544.595,"d":"$3,545"}]
["1710.501(a)(11)","Federal Debt Delinquency Requirements","written",101,1,{"v":101,"d":"101 "},{"v":0.5,"d":"0.50"},{"v":50.5,"d":"51"},70.19,{"v":3544.595,"d":"$3,545"}]
["1710.501(a)(8)","Equal Employment Opportunity Employer Report (A copy of the form is provided)","written",101,1,{"v":101,"d":"101 "},0.25,{"v":25.25,"d":"25"},70.19,{"v":1772.2975,"d":"$1,772"}]
[null,"Sam Registration","Sam.gov",101,1,{"v":101,"d":"101 "},{"v":1,"d":"1.00"},101,70.19,{"v":7089.19,"d":"$7,089"}]
[null,"Totals",null,{"$f":"D18+D21","v":{"v":608,"d":"608 "}},1,{"$f":"SUM(F9:F38)","v":{"v":1968,"d":"1,968 "}},null,{"$f":"SUM(H9:H38)","v":{"v":37514.75,"d":"37,515"}},null,{"$f":"SUM(J9:J38)","v":{"v":2633160.3025000007,"d":"$2,633,160"}}]
[]
[]
[null,null,"Total Estimated Annual Responses",null,null,{"$f":"D39","v":608}]
[{"$nulls":3},"Total Estimated Annual Burden Hours",{"$nulls":3},{"$f":"H39","v":{"v":37514.75,"d":"37,515"}}]
[{"$nulls":6},"Total Annual Burden Cost",null,null,{"$f":"J39","v":{"v":2633160.3025000007,"d":"$2,633,160"}}]
[null,null,"Total Estimated Burden Hours per Response",{"$nulls":3},{"$f":"H39/F39","v":{"v":19.062372967479675,"d":"19.062"}}]

{"sheet":"Weighted Wage ","index":1,"n_rows":10,"n_cols":10,"rows_kept":10}
["Table 2:  Estimated Wages for Employee Time"]
[]
["Wage Category","Code","Mean Wage*","29.7% Benefits**","Total Hourly Wage","Percent Time spent on Burden","Weighted Hourly Salary",null,"*","http://www.bls.gov/oes/current/oes_stru.htm"]
["General and Operations Manager","11-1021",62.18,{"$f":"C4*A10","v":{"v":18.46746,"d":"18.47"}},{"$f":"C4+D4","v":{"v":80.64746,"d":"80.65"}},80,{"$f":"E4*0.8","v":{"v":64.517968,"d":"64.52"}}]
["Secretaries and Administrative Assistants","43-6014",21.87,{"$f":"C5*A10","v":{"v":6.4953899999999996,"d":"6.50"}},{"$f":"C5+D5","v":{"v":28.36539,"d":"28.37"}},20,{"$f":"E5*0.2","v":{"v":5.673078,"d":"5.67"}},null,"**","https://www.bls.gov/news.release/pdf/ecec.pdf"]
[]
[{"$nulls":5},{"$f":"SUM(F4:F6)","v":100},{"$f":"SUM(G4:G6)","v":{"v":70.191046,"d":"70.19"}}]
[]
[{"$nulls":9},"Occupational Employment and Wage Statistics, Occupational Employment and Wages, May 2023"]
[0.297,null,"Benefit",{"$nulls":6},"EMPLOYER COSTS FOR EMPLOYEE COMPENSATION – MARCH 2024"]

{"sheet":"Federal","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"merged":[[34,0,34,1]]}
[]
[]
["Table 4:  Wage Rates for Reviews"]
["Reviews","Wage Rate","Benefits","Hourly Rate"]
["Application Review (GS 13/Step 5)",{"v":64.06,"d":"$64.06"},{"$f":"B5*0.3625","v":{"v":23.22175,"d":"$23.22"}},{"$f":"B5*1.3625","v":{"v":87.28175,"d":"$87.28"}},null,null,"SALARY TABLE 2024-DCB (opm.gov)"]
["Annual Financial and Statistical Report (GS 13/Step 5)",{"v":64.06,"d":"$64.06"},{"$f":"B6*0.3625","v":{"v":23.22175,"d":"$23.22"}},{"$f":"B6*1.3625","v":{"v":87.28175,"d":"$87.28"}}]
[]
[]
[]
[null,"Number of Apps/Reports","Hours to complete","Total Cost to Review"]
["Application Review (GS 13/Step 5)",101,164,{"$f":"(87.28*164)*101","v":{"v":1445705.92,"d":"$1,445,706"}}]
["Annual Financial and Statistical Report (GS 13/Step 5)",608,4,{"$f":"(87.28*4)*608","v":{"v":212264.96,"d":"$212,265"}}]
[{"$nulls":3},{"$f":"D11+D12","v":{"v":1657970.88,"d":"$1,657,971"}}]

{"sheet":"Not in Burden","index":3,"n_rows":7,"n_cols":10,"rows_kept":7}
[]
[]
["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)"]
["1710.501(a)(10)","Disclosure of Lobbying Activities","SF-LLL (4040-0013)",{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,0.16,{"$f":"F5*G5","v":1.12},null,{"$f":"H5*I5","v":{"v":0,"d":"$0"}}]
[]
["1710.501(a)(12)","Assurance Agreement","RD 400-4",{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":0.5,"d":"0.50"},{"$f":"F7*G7","v":{"v":3.5,"d":"3.50"}},null,{"$f":"H7*I7","v":{"v":0,"d":"$0"}}]