{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Rollup","FedGov Cost"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Rollup","index":0,"n_rows":38,"n_cols":10,"rows_kept":38}
["2012 Burden Estimate for 9007 - Renewable Energy Development Feasibility Study Grants"]
["OMB No 0570-0061 - USDA Rural Business-Cooperative Service "]
["Section of Notice","Title","Form No. (if any)","No. of Respondents","Reports Filed","Total Responses (C) x (D)","Estimated No. of Manhours per response","Estimated Total Manhours (E) x (F)","Wage** Class","Total Cost (G) x (H)"]
["(A)",null,"(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)"]
[null,"Reporting - No Forms Approved Under this Docket"]
[]
[null,"Project Proposal - Applicants"]
["V.B.6","Application Narrative","written",354,1,{"$f":"(D8)*(E8)","v":354},8,{"$f":"(F8)*(G8)","v":{"v":2832,"d":"2,832"}},{"v":62,"d":"$62"},{"$f":"(H8)*(I8)","v":{"v":175584,"d":"$175,584"}}]
["V.B.6","Organizational documents","written",354,1,{"$f":"(D9)*(E9)","v":354},0.33,{"$f":"(F9)*(G9)","v":{"v":116.82000000000001,"d":"117"}},{"v":62,"d":"$62"},{"$f":"(H9)*(I9)","v":{"v":7242.84,"d":"$7,243"}}]
["V.B.6","Intergovernmental comments","written",354,1,{"$f":"(D10)*(E10)","v":354},1,{"$f":"(F10)*(G10)","v":354},{"v":62,"d":"$62"},{"$f":"(H10)*(I10)","v":{"v":21948,"d":"$21,948"}}]
[]
[null,"Grantees"]
["V.B.14","Performance Report - Semiannual","written",248,1,{"$f":"(D13)*(E13)","v":248},1,{"$f":"(F13)*(G13)","v":248},{"v":62,"d":"$62"},{"$f":"(H13)*(I13)","v":{"v":15376,"d":"$15,376"}}]
["V.B.14","Performance Report - Final","written",118,1,118,1,118,{"v":62,"d":"$62"},{"v":7316,"d":"$7,316"}]
["V.B.14","Annual Status Report","written",92,1,92,1,92,{"v":62,"d":"$62"},{"v":5704,"d":"$5,704"}]
["V.B.14","Other Reports","written",60,1,60,1,60,{"v":62,"d":"$62"},{"v":3720,"d":"$3,720"}]
["V.B.14","Recordkeeping",null,275,1,275,1,275,{"v":62,"d":"$62"},{"v":17050,"d":"$17,050"}]
[]
[]
[null,"Reporting - Forms Approved Under this Docket"]
[null,"Certification Regarding Debarment, Suspension & Other Resp. Matters-Primary Covered Trans.","AD-1047 or in writing",220,1,{"$f":"(D21)*(E21)","v":220},0.25,{"$f":"(F21)*(G21)","v":55},{"v":62,"d":"$62"},{"$f":"(H21)*(I21)","v":{"v":3410,"d":"$3,410"}}]
[null,"Certification Regarding Debarment, Suspension, Ineligibility & Vol. Excl. -Lower Tiered Covered Trans.","AD-1048 or in writing",220,1,220,0.25,55,{"v":62,"d":"$62"},{"v":3410,"d":"$3,410"}]
[null,"Cert. Regarding Drug-Free Workplace Req. (Grants) Alt. I - For Grantees Other Than Individuals","AD -1049 (9000-0101)",220,1,220,0.25,55,{"v":62,"d":"$62"},{"v":3410,"d":"$3,410"}]
[null,"Assurance Agreement","RD 400-4 (0575-0018)",220,1,220,0.25,55,{"v":62,"d":"$62"},{"v":3410,"d":"$3,410"}]
[null,"Request for Obligation of Funds","RD 1940-1 (0575-0062)",220,1,220,0.25,55,{"v":62,"d":"$62"},{"v":3410,"d":"$3,410"}]
[null,"Letter of Intent","RD 1942-46 (0575-0015 and 0570-0061)",220,1,220,1,220,{"v":62,"d":"$62"},{"v":13640,"d":"$13,640"}]
[null,"RBS Grant Agreement ","RD 4280-2 ",220,1,{"$f":"(D27)*(E27)","v":220},0.75,{"$f":"(F27)*(G27)","v":165},{"v":62,"d":"$62"},{"$f":"(H27)*(I27)","v":{"v":10230,"d":"$10,230"}}]
[]
[]
[null,"Grand Totals",{"$nulls":3},{"$f":"SUM(F8:F27)","v":{"v":3395,"d":"3,395"}},null,{"$f":"SUM(H8:H27)","v":{"v":4755.82,"d":"4,756"}},null,{"$f":"SUM(J8:J27)","v":{"v":294860.83999999997,"d":"294,861"}}]
[]
[null,"Forms Approved Under Other OMB Numbers"]
[null,"Application for Federal Assistance","SF 424 (4040-0004)",220,1,{"$f":"(D33)*(E33)","v":220},1,{"$f":"(F33)*(G33)","v":220}]
[null,"Assurances - Non-Construction Program","SF 424B (4040-0007)",220,1,{"$f":"(D34)*(E34)","v":220},0.25,{"$f":"(F34)*(G34)","v":55}]
[null,"Financial Status Report","SF-245 (0348-0061)",220,1,{"$f":"(D35)*(E35)","v":220},{"v":0.5,"d":"0.50"},{"$f":"(F35)*(G35)","v":110}]
[null,"Request for Advance or Reimbursement","SF-270 (0348-0004)",220,1,{"$f":"(D36)*(E36)","v":220},1,{"$f":"(F36)*(G36)","v":220}]
[null,"Disclosure of Lobbying Activities","SF LLL (0348-0046)",220,1,{"$f":"(D37)*(E37)","v":220},0.13,{"$f":"(F37)*(G37)","v":{"v":28.6,"d":"29"}}]
[null,"Totals",{"$nulls":3},{"$f":"SUM(F33:F37)","v":{"v":1100,"d":"1,100"}},null,{"$f":"SUM(H33:H37)","v":{"v":633.6,"d":"634"}}]

{"sheet":"FedGov Cost","index":1,"n_rows":14,"n_cols":6,"rows_kept":14}
["Rollup of Costs"]
["Feasibility Study Grants","Applicants or Grantees","Hours","Rate","Cost","3-year Average"]
["Acknowledge and review application",1062,4,42,{"$f":"+B3*C3*D3","v":{"v":178416,"d":"$178,416"}},{"$f":"+E3/3","v":{"v":59472,"d":"$59,472"}}]
["Evaluate and score",1062,2,42,{"v":89208,"d":"$89,208"},{"$f":"+E4/3","v":{"v":29736,"d":"$29,736"}}]
["Inform applicants of selection results",1062,1,42,{"v":44604,"d":"$44,604"},{"v":14868,"d":"$14,868"}]
["Legal document preparation",660,8,42,{"v":221760,"d":"$221,760"},{"v":73920,"d":"$73,920"}]
["Release and advance of funds",495,1,42,{"v":20790,"d":"$20,790"},{"v":6930,"d":"$6,930"}]
["Performace Report - Semiannual",743,1,42,{"v":31206,"d":"$31,206"},{"v":10402,"d":"$10,402"}]
["Performace Report - Final",357,1,42,{"v":14994,"d":"$14,994"},{"v":4998,"d":"$4,998"}]
["Annual Reports",275,0.5,42,{"v":5775,"d":"$5,775"},{"v":1925,"d":"$1,925"}]
["Other Reports",180,1,42,{"v":7560,"d":"$7,560"},{"v":2520,"d":"$2,520"}]
["Review feasibility studies for approval",495,4,42,{"v":83160,"d":"$83,160"},{"v":27720,"d":"$27,720"}]
["Publication in the FR",{"$nulls":3},{"v":43000,"d":"$43,000"},{"v":14333.333333333334,"d":"$14,333"}]
["Total Over Three Years",{"$nulls":3},{"$f":"SUM(E3:E13)","v":{"v":740473,"d":"$740,473"}},{"v":246824.33333333334,"d":"$246,824"}]