{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Financials","JobData","Impact Metrics","Guidance&Definitions"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":1,"defined_names":1,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Financials","index":0,"n_rows":18,"n_cols":78,"rows_kept":18,"cut":false,"hidden":false,"merged":[[43,0,43,5],[12,0,17,0],[12,2,17,2],[10,18,10,29],[0,0,3,13],[10,6,10,17],[12,3,13,3],[16,3,17,3],[12,1,17,1],[4,0,6,13],[10,30,10,41],[10,42,10,53],[10,54,10,65],[10,66,10,77]],"flags":["formulas_cached_only"]}
["This data is being collected to ensure the Department of Energy meets public transparency and accountability standards for Recovery Act funds. Monitoring and tracking the progress of Recovery Act supported projects and Recovery Act recipients contribution to creating U.S. jobs. "]
[]
[]
[]
["Public reporting burden for this collection of information is estimated to average 3-5 hrs to complete the entire worksheet, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of Information Resources Management Policy, Plans, and Oversight, Records Management Division, HR-422 - GTN, Paperwork Reduction Project (1910-5134), U.S. Department of Energy, 1000 Independence Avenue, S.W., Washington, DC 20585; and to the Office of Management and Budget (OMB), Paperwork Reduction Project (1910-5134), Washington, DC 20503."]
[]
[]
[]
[]
["1.  Planned and Actual Monthly Financial Expenditures"]
[{"$nulls":6},"FY 10",{"$nulls":11},"FY 11",{"$nulls":11},"FY 12",{"$nulls":11},"FY 13",{"$nulls":11},"FY 14",{"$nulls":11},"FY 15"]
["Program Office","Recipient Name","Award Value",null,null,"FY 09","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"]
["EERE ","XXXX","$xxx","Obligation","Planned"]
[{"$nulls":4},"Actual"]
[]
[]
[null,null,null,"Outlay","Planned"]
[{"$nulls":4},"Actual"]

{"sheet":"JobData","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,3,2,6],[19,0,21,13]],"flags":["formulas_cached_only"]}
["2. Job Creation"]
[]
["Project Details",null,null,"Federally Funded Cummulative FTE",null,null,null,"Non-Federal Funding Cummulative FTE"]
["Project Name","Project Code","Total FTE","Prime Contractor Total FTE","Sub Contractor Total FTE","Prime Financial Assitance Recipient       Total FTE","Sub Financial Assitance Recipient           Total FTE","Total Cost-share/Matching FTE"]
{"$rows_empty":15}
["Public reporting burden for this collection of information is estimated to average 3-5 hrs to complete the entire worksheet, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of Information Resources Management Policy, Plans, and Oversight, Records Management Division, HR-422 - GTN, Paperwork Reduction Project (1910-5134), U.S. Department of Energy, 1000 Independence Avenue, S.W., Washington, DC 20585; and to the Office of Management and Budget (OMB), Paperwork Reduction Project (1910-5134), Washington, DC 20503."]

{"sheet":"Impact Metrics","index":2,"n_rows":20,"n_cols":75,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,21,13],[3,51,3,62],[3,63,3,74],[3,3,3,14],[3,15,3,26],[3,27,3,38],[3,39,3,50]],"flags":["formulas_cached_only"]}
[]
[]
["3. Progress Toward Project Completion Against Planned Milestones"]
[null,null,null,"FY 10",{"$nulls":11},"FY 11",{"$nulls":11},"FY 12",{"$nulls":11},"FY 13",{"$nulls":11},"FY 14",{"$nulls":11},"FY 15"]
["Milestone","Description","Lifetime Value/ Completion Milestone","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"]
["Project Start Date"]
["Construction Commences"]
["Construction Ends"]
["Operations Begin"]
{"$rows_empty":10}
["Public reporting burden for this collection of information is estimated to average 3-5 hrs to complete the entire worksheet, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of Information Resources Management Policy, Plans, and Oversight, Records Management Division, HR-422 - GTN, Paperwork Reduction Project (1910-5134), U.S. Department of Energy, 1000 Independence Avenue, S.W., Washington, DC 20585; and to the Office of Management and Budget (OMB), Paperwork Reduction Project (1910-5134), Washington, DC 20503."]

{"sheet":"Guidance&Definitions","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,6],[7,0,7,7],[3,0,3,7],[10,0,10,1],[10,3,10,6],[1,0,1,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[2,0,2,7]],"flags":["formulas_cached_only"]}
["Technical Guidance on Reporting Internal DOE Recovery Act Jobs per Memo M-01-01"]
["•On 9/15/09, the Department of Energy issued guidance requiring Program Offices to collect certain information about jobs created or retained under the Recovery Act.  In response to follow-up questions about this guidance, CFO/PA&E has developed this template to help create a uniformed standard for Program Offices to provide this information to CFO/PA&E.  These data will better enable the Department to track the number of actual jobs created under the Recovery Act and transparently show the American public how these programs are helping create jobs and spur sustainable, economic growth.  Per the guidance, Program Offices are asked to report jobs created or retained, using OMB-established definitions for FederalReporting.gov.  The guidance is attached to this spreadsheet.  If a Program Office already uses an existing database or spreadsheet to collect jobs information, please send that spreadsheet to CFO/PA&E and do not use this template.                                                                                                                                                                                    If  you have any questions, please contact Howard Dickenson, Assistant Director for Recovery Act Operations, CFO/PA&E at Howard.Dickenson@hq.doe.gov"]
["•Once completed, please send this spreadsheet to CFO/PA&E at RecoveryInformationCenter@hq.doe.gov .  Data should be submitted by the Friday of the first week of every month, or new fiscal quarter depending on your situation (e.g.a Nov. 6th submission for the month of October or FY09 Quarter 4--note this submission will be unique because the data will be cumulative from the start of the Recovery Act )."]
[" •Program offices should submit an FTE count for each project that falls under this guidance; FTE data should be rolled up for each project.  \n"]
[" •Not all projects will need to report information for each field.  If a field does not pertain to the project please enter a \"0\". Project Name, Project Code, and Total FTE are required fields for each project."]
[" •All contractor and sub-contractor direct jobs created/retained must be reported cumulatively on a monthly basis.  Prime contractors are still required to report quarterly to Federalreporting.gov for prime contractor jobs.  However, as FederalReporting.gov does not require prime contractors to report subcontractor jobs, DOE is requesting this information to provide a more comprehensive jobs picture."]
[" •All financial assistance awards that have a waiver from the Paperwork Reduction Act must submit FTE numbers on a monthly basis for both federally funded jobs and cost sharing/matching funds.  Recipients must also still comply with reporting requirements to FederalReporting.gov.  Currently, FederalReporting.gov does not collect jobs generated from cost-sharing; nor does FederalReporting.gov allow for monthly reporting for projects with a pre-existing Paperwork Reduction Act waiver for collecting such information."]
[" •All financial assistance awards that do NOT have a waiver from the Paperwork Reduction Act but have cost sharing/matching funds must submit FTE numbers on a quarterly basis for both federally funded jobs and cost sharing/matching funds.  Recipients must also still comply with reporting requirements to FederalReporting.gov.  Currently, FederalReporting.gov does not require recipients to report jobs created from cost-sharing. "]
[]
[]
["Project Details",null,null,"Federally Funded Cummulative FTE",null,null,null,"Non-Federal Funding Cummulative FTE"]
["Project Name","Project Code","Total FTE","Prime Contractor Total FTE","Sub Contractor Total FTE","Prime Financial Assitance Recipient       Total FTE","Sub Financial Assitance Recipient        Total FTE","Total Cost-share/Matching FTE"]