{"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":48,"n_cols":12,"rows_kept":48,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[45,3,45,6],[46,6,46,8],[47,2,47,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)",null,65.9]
["(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)"]
[null,"Letter of Intent and Application Content"]
[]
[null,"SAM Registration","Online",{"v":9,"d":"9.00"},{"v":1,"d":"1.00"},{"$f":"SUM(D8*E8)","v":{"v":9,"d":"9 "}},{"v":2,"d":"2.00"},{"$f":"F8*G8","v":18},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"H8*I8","v":{"v":1186.2149760000002,"d":"$1,186"}}]
[]
["1719.5(b)(2)","Step 1:  Letter of Intent","written",{"v":9,"d":"9 "},{"v":1,"d":"1 "},{"$f":"SUM(D10*E10)","v":9},{"v":5,"d":"5.00"},{"$f":"F10*G10","v":45},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"H10*I10","v":{"v":2965.5374400000005,"d":"$2,966"}}]
[]
[null,"Step 2:  RESP Application"]
[]
["1719.5(3)(i)(A)","Transmittal Letter                                                                                               (Request for RESP loan from Gen. Mgr)","written",{"v":7,"d":"7 "},{"v":1,"d":"1 "},{"$f":"SUM(D14*E14)","v":7},{"v":1,"d":"1.00"},7,{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"H14*I14","v":{"v":461.30582400000003,"d":"$461"}}]
[]
["1719.5(3)(i)(B)","Board Resolution","written",{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":1,"d":"1.00"},7,{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"H16*I16","v":{"v":461.30582400000003,"d":"$461"}}]
[{"$nulls":9},{"$f":"H17*I17","v":{"v":0,"d":"$0"}}]
["1719.5(3)(i)(C)","Articles of Incorporation and Bylaws","written",{"v":7,"d":"7 "},{"v":1,"d":"1 "},{"$f":"SUM(D18*E18)","v":7},{"v":0.5,"d":"0.50"},{"v":3.5,"d":"4"},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"H18*I18","v":{"v":230.65291200000001,"d":"$231"}}]
[]
["1719.5(3)(i)(D)","Environmental Compliance Review","written",{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":10,"d":"10.00"},70,{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"v":4613.05824,"d":"$4,613"}]
[null," "]
["1719.5(3)(i)(E)","Long Range Financial Forecast and Board Resolution","written",{"v":7,"d":"7 "},{"v":1,"d":"1 "},{"$f":"SUM(D22*E22)","v":7},{"v":40,"d":"40.00"},280,{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"v":18452.23296,"d":"$18,452"}]
[]
["1719.5(3)(i)(F)","Energy Efficiency Program Implementation Work Plan","written",{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,{"v":40,"d":"40.00"},280,{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"v":18452.23296,"d":"$18,452"}]
[]
["1719.5(3)(i)(G)","Statement of Compliance with other Federal Statutes","written",7,1,7,{"v":1,"d":"1.00"},7,{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"v":461.30582400000003,"d":"$461"}]
[]
["1710.501(a)(8)","Equal Employment Opportunity Employer Report ","written",{"v":1,"d":"1 "},{"v":1,"d":"1 "},1,{"v":1,"d":"1.00"},{"$f":"F28*G28","v":1},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"H28*I28","v":{"v":65.90083200000001,"d":"$66"}}]
[{"$nulls":9},{"v":0,"d":"$0"}]
[null,"Award Closing, Servicing and Reporting"]
[]
[1719.7,"Review and Acceptance of Conditional Commitment Letter","written",{"v":7,"d":"7 "},1,{"$f":"SUM(D32*E32)","v":7},{"v":8,"d":"8.00"},{"$f":"F32*G32","v":56},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"I32*H32","v":{"v":3690.4465920000002,"d":"$3,690"}}]
[]
["1719.7(c) ","Review and Execution of RESP Loan Agreement","written",{"v":7,"d":"7 "},1,7,{"v":1,"d":"1.00"},{"$f":"F34*G34","v":7},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"I34*H34","v":{"v":461.30582400000003,"d":"$461"}}]
[]
["1719.7(c)(4)","Opinion of Counsel","written",{"v":7,"d":"7 "},1,7,{"v":1,"d":"1.00"},{"$f":"F36*G36","v":7},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"I36*H36","v":{"v":461.30582400000003,"d":"$461"}}]
[]
["1719.8(d)","Request for Reimbursement or Advance of Funds ","written",6,1,{"$f":"SUM(D38*E38)","v":6},{"v":1,"d":"1.00"},{"$f":"SUM(F38*G38)","v":6},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"I38*H38","v":{"v":395.40499200000005,"d":"$395"}}]
[]
[1719.12,"Performance and Financial Reports","written",6,2,{"$f":"SUM(D40*E40)","v":12},{"v":4,"d":"4.00"},{"$f":"SUM(F40*G40)","v":48},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"$f":"I40*H40","v":{"v":3163.2399360000004,"d":"$3,163"}}]
[]
[null,"SAM Registration Maintenance","written",{"v":6,"d":"6 "},{"v":1,"d":"1 "},{"$f":"D42*E42","v":6},{"v":1,"d":"1.00"},{"$f":"SUM(F42*G42)","v":6},{"$f":"'Weighted Wage '!F9","v":{"v":65.90083200000001,"d":"65.90"}},{"v":395.40499200000005,"d":"$395"}]
[{"$nulls":5},{"$f":"SUM(F8:F42)","v":113},null,{"$f":"SUM(H8:H42)","v":{"v":848.5,"d":"849"}},null,{"$f":"SUM(J8:J42)","v":{"v":55916.85595200001,"d":"$55,917"}}]
[]
[null,null,"Total Estimated Annual Responses",null,null,{"$f":"F43","v":113}]
[{"$nulls":3},"Total Estimated Annual Burden Hours",{"$nulls":3},{"$f":"H43","v":{"v":848.5,"d":"849"}}]
[{"$nulls":6},"Total Annual Burden Cost",null,null,{"$f":"J43","v":{"v":55916.85595200001,"d":"$55,917"}}]
[null,null,"Total Estimated Burden Hours per Response",{"$nulls":3},{"$f":"H46/F45","v":{"v":7.508849557522124,"d":"7.509"}}]

{"sheet":"Weighted Wage ","index":1,"n_rows":12,"n_cols":9,"rows_kept":12}
["Table 2:  Estimated Wages for Employee Time"]
[]
["Wage Category","Mean Wage*","29.4% Benefits**","Total Hourly Wage","Percent Time spent on Burden","Weighted Hourly Salary",null,"*","http://www.bls.gov/oes/current/oes_stru.htm"]
["Senior Manager (11-1021)",59.07,{"$f":"B4*A12","v":{"v":17.36658,"d":"17.37"}},{"$f":"B4+C4","v":{"v":76.43657999999999,"d":"76.44"}},20,{"$f":"D4*0.2","v":{"v":15.287315999999999,"d":"15.29"}}]
["Attorney (23-1011)",78.74,{"$f":"B5*A12","v":{"v":23.149559999999997,"d":"23.15"}},{"$f":"B5+C5","v":{"v":101.88955999999999,"d":"101.89"}},10,{"$f":"D5*0.1","v":{"v":10.188956,"d":"10.19"}},null,"**","https://www.bls.gov/news.release/pdf/ecec.pdf"]
["Electrical Engineer (17-2071)",54.83,{"$f":"B6*A12","v":{"v":16.12002,"d":"16.12"}},{"$f":"B6+C6","v":{"v":70.95002,"d":"70.95"}},30,{"$f":"D6*0.3","v":{"v":21.285006,"d":"21.29"}}]
["Accountants/Auditors (13-2011)",{"v":41.7,"d":"41.70"},{"$f":"B7*A12","v":{"v":12.2598,"d":"12.26"}},{"$f":"B7+C7","v":{"v":53.9598,"d":"53.96"}},30,{"$f":"D7*0.3","v":{"v":16.18794,"d":"16.19"}}]
["Bookkeeping, Accounting and Auditing Clerks (43-3031)",22.81,{"$f":"B8*A12","v":{"v":6.7061399999999995,"d":"6.71"}},{"$f":"B8+C8","v":{"v":29.51614,"d":"29.52"}},10,{"$f":"D8*0.1","v":{"v":2.951614,"d":"2.95"}}]
[{"$nulls":4},{"$f":"SUM(E4:E8)","v":100},{"$f":"SUM(F4:F8)","v":{"v":65.90083200000001,"d":"65.90"}}]
[]
[]
[0.294,"Benefit"]

{"sheet":"Federal","index":2,"n_rows":63,"n_cols":4,"rows_kept":63,"merged":[[34,0,34,1]]}
[]
[]
["Table 4:  Wage Rates for Staff Positions:"]
["Staff Position","Wage Rate[1]","Benefits[2]","Hourly Rate"]
["Policy Advisor  (GS 15/ Step 5)",{"v":84.55,"d":"$84.55"},{"$f":"B5*0.3625","v":{"v":30.649375,"d":"$30.65"}},{"$f":"B5*1.3625","v":{"v":115.199375,"d":"$115.20"}}]
["Senior Level Engineer (GS 15/Step 5)",{"v":84.55,"d":"$84.55"},{"$f":"B6*0.3625","v":{"v":30.649375,"d":"$30.65"}},{"$f":"B6*1.3625","v":{"v":115.199375,"d":"$115.20"}}]
["Senior Loan Specialist (GS 13/Step 5)",{"v":60.83,"d":"$60.83"},{"v":22.050874999999998,"d":"$22.05"},{"v":82.880875,"d":"$82.88"}]
["Engineer (GS 13/Step 5)",{"v":60.83,"d":"$60.83"},{"v":22.050874999999998,"d":"$22.05"},{"v":82.880875,"d":"$82.88"}]
["General Field Representative (GS 13/Step 5)",{"v":60.83,"d":"$60.83"},{"v":22.050874999999998,"d":"$22.05"},{"v":82.880875,"d":"$82.88"}]
["Deputy Ass’t Admin. (OLOA) (GS 15/Step 5)",{"v":84.55,"d":"$84.55"},{"v":30.649375,"d":"$30.65"},{"v":115.199375,"d":"$115.20"}]
["Financial Branch Chief (GS 15/Step 5)",{"v":84.55,"d":"$84.55"},{"v":30.649375,"d":"$30.65"},{"v":115.199375,"d":"$115.20"}]
["Ass’t Administrator (SES)",{"v":87.93,"d":"$87.93"},{"v":31.874625,"d":"$31.87"},{"v":119.80462500000002,"d":"$119.80"}]
["RUS Administrator (ES)",{"v":90.99,"d":"$90.99"},{"v":32.983875,"d":"$32.98"},{"v":123.97387499999999,"d":"$123.97"}]
[]
[]
["Table 4:  Employee Time and Wage Calculations:"]
["Step 1 Letter of Intent Review"]
["Staff Position","Total Hourly Wage","Hours Required","Cost"]
["Policy Advisor",{"v":115.199375,"d":"$115.20"},2,{"$f":"B19*C19","v":{"v":230.39875,"d":"$230.40"}}]
["Senior Level Engineer",{"v":115.199375,"d":"$115.20"},3,{"$f":"B20*C20","v":{"v":345.598125,"d":"$345.60"}}]
["Senior Loan Specialist",{"v":82.880875,"d":"$82.88"},6,{"v":497.28525,"d":"$497.29"}]
["Engineer",{"v":82.880875,"d":"$82.88"},5,{"v":414.404375,"d":"$414.40"}]
["Ass’t Admin. (Electric)",{"v":119.8,"d":"$119.80"},2,{"v":239.6,"d":"$239.60"}]
["Cost Each",null,null,{"$f":"SUM(D19:D23)","v":{"v":1727.2865000000002,"d":"$1,727.29"}}]
[]
["Step-2 Pre-Application"]
["Policy Advisor",{"v":115.199375,"d":"$115.20"},45,{"$f":"B27*C27","v":{"v":5183.971875,"d":"$5,183.97"}}]
["Senior Level Engineer",{"v":115.199375,"d":"$115.20"},30,{"v":3455.9812500000003,"d":"$3,455.98"}]
["Senior Loan Specialist",{"v":82.880875,"d":"$82.88"},30,{"v":2486.42625,"d":"$2,486.43"}]
["General Field Representative",{"v":82.880875,"d":"$82.88"},64,{"v":5304.376,"d":"$5,304.38"}]
["Deputy Ass’t Admin (OLOA)",{"v":115.199375,"d":"$115.20"},5,{"v":575.996875,"d":"$576.00"}]
["Ass’t Admin. (Electric)",{"v":119.8,"d":"$119.80"},5,{"v":599,"d":"$599.00"}]
["Cost Each",null,null,{"$f":"SUM(D27:D32)","v":{"v":17605.75225,"d":"$17,605.75"}}]
[]
["Step 3: Application Review & Loan Approval"]
["Policy Advisor",{"v":115.199375,"d":"$115.20"},16,{"$f":"B36*C36","v":{"v":1843.19,"d":"$1,843.19"}}]
["Senior Level Engineer",{"v":115.199375,"d":"$115.20"},40,{"v":4607.975,"d":"$4,607.98"}]
["Senior Loan Specialist",{"v":82.880875,"d":"$82.88"},80,{"v":6630.47,"d":"$6,630.47"}]
["Financial Branch Chief",{"v":115.199375,"d":"$115.20"},20,{"v":2303.9875,"d":"$2,303.99"}]
["Consultant",{"v":100,"d":"$100.00"},15,{"v":1500,"d":"$1,500.00"}]
["Deputy Ass’t Admin. (OLOA)",{"v":115.199375,"d":"$115.20"},10,{"v":1151.99375,"d":"$1,151.99"}]
["Ass’t Admin. (Electric)",{"v":119.8,"d":"$119.80"},10,{"v":1198,"d":"$1,198.00"}]
["Ass’t Admin. (WEP)",{"v":119.8,"d":"$119.80"},1,{"v":119.8,"d":"$119.80"}]
["Ass’t Admin. (TELECOM)",{"v":119.8,"d":"$119.80"},1,{"v":119.8,"d":"$119.80"}]
["RUS Administrator",{"v":123.97,"d":"$123.97"},2,{"v":247.94,"d":"$247.94"}]
["Cost Each",{"$f":"SUM(B36:B45)","v":{"v":1127.0483749999999,"d":"$1,127.05"}},{"$f":"SUM(C36:C45)","v":195},{"$f":"SUM(D36:D45)","v":{"v":19723.15625,"d":"$19,723.16"}}]
[]
["Step 4: Post Award"]
["Senior Level Engineer",{"v":115.199375,"d":"$115.20"},5,{"$f":"B49*C49","v":{"v":575.996875,"d":"$576.00"}}]
["Senior Loan Specialist",{"v":82.880875,"d":"$82.88"},5,{"v":414.404375,"d":"$414.40"}]
["Financial Branch Chief",{"v":115.199375,"d":"$115.20"},5,{"v":575.996875,"d":"$576.00"}]
["Deputy Ass’t Admin. (OLOA)",{"v":115.199375,"d":"$115.20"},5,{"v":575.996875,"d":"$576.00"}]
["Ass’t Admin. (Electric)",{"v":119.8,"d":"$119.80"},5,{"v":599,"d":"$599.00"}]
["Cost Each",null,null,{"$f":"SUM(D49:D53)","v":{"v":2741.3950000000004,"d":"$2,741.40"}}]
[]
[]
["Table 3:  Total Cost to the Federal Government:"]
["Stage","Cost of Each","Number of Entities","Total Cost"]
["Step 1: Letter of Intent Review",{"$f":"D24","v":{"v":1727.2865000000002,"d":"$1,727.29"}},9,{"$f":"B59*C59","v":{"v":15545.578500000001,"d":"$15,545.58"}}]
["Step 2: Pre-Application",{"$f":"D33","v":{"v":17605.75225,"d":"$17,605.75"}},7,{"$f":"B60*C60","v":{"v":123240.26575,"d":"$123,240.27"}}]
["Step 3: Application Review & Loan Approval",{"$f":"D46","v":{"v":19723.15625,"d":"$19,723.16"}},7,{"v":138062.09375,"d":"$138,062.09"}]
["Step 4: Post Award",{"$f":"D54","v":{"v":2741.3950000000004,"d":"$2,741.40"}},6,{"v":16448.370000000003,"d":"$16,448.37"}]
["Total Cost to Federal Government",null,null,{"$f":"SUM(D59:D62)","v":{"v":293296.30799999996,"d":"$293,296.31"}}]

{"sheet":"Not in Burden","index":3,"n_rows":8,"n_cols":10,"rows_kept":8}
[]
[]
["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,"LOI and Application Content"]
[null," Assurance agreement (OMB No. 0575-0018)","RD Form 400-4",{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,0.25,{"$f":"F6*G6","v":1.75},66,{"$f":"H6*I6","v":{"v":115.5,"d":"$116"}}]
[]
[null," Equal Opportunity Agreement (OMB No. 0575-0018)","RD Form 400-1",{"v":7,"d":"7 "},{"v":1,"d":"1 "},7,0.16,{"$f":"F8*G8","v":1.12},66,{"$f":"H8*I8","v":{"v":73.92,"d":"$74"}}]