{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Work Plan and Reporting","Budget Detail Cat. & Component","Incomplete - Comment Log table","Standardized Terms","List Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Work Plan and Reporting","index":0,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Work Plan & Reporting"]
["Note: Use the desktop version of Excel. The components, commitments and accompanying details in the worksheet below are just examples for illustrative purposes.  Please replace the fields with data specific to your project. "]
[" ","Outcome(s)","Output(s)","Commitment FFY","Interim Milestone ","Target Completion Date","Status","Semi-Annual Progress Report (PR) 1","EPA Comments","Semi-Annual Progress Report (PR) 2","EPA Comments2","EPA Contact ","Recipient Contact","Equipment Support","Contract or Subaward Subaward Support"]
["Instructions:\nThis row may be deleted or hidden when work plans are submitted to EPA.","The result, effect, or consequence that will occur from carrying out an environmental program or activity that is related to an environmental or programmatic goal or objective. Outcomes may be environmental, behavioral, health-related, or programmatic in nature, and may not necessarily be achievable within an assistance agreement funding period.","An environmental activity or effort, and/or associated work products that are produced or provided over a specific period of time. Outputs may be quantitative or qualitative but must be measurable during an assistance agreement funding period.","This column should indicate which federal fiscal year is associated with each commitment. ","Provide the month and year targeted for any interim milestones that support the outputs (e.g., reporting deadlines).","Provide the month and year of the target completion date for the outcome.","This column should be updated each time you submit a progress report.","This column may be hidden during work plan negotiation and finalization.  When Progress Reports are submitted, Provide 1-3 sentences on the status of each commitment.","This column may be hidden during work plan negotiation and finalization.  EPA may use this column to respond to Progress Reporting.","This column may be hidden during work plan negotiation and finalization.  When Progress Reports are submitted, Provide 1-3 sentences on the status of each commitment.","This column may be hidden during work plan negotiation and finalization.  EPA may use this column to respond to Progress Reporting.","Provide the name and email address of the EPA contact responsible for reviewing each row (commitment).  This may be left blank in work plan negotiations and finalization.","Provide the name and email address of the recipient contact responsible for reviewing each row (commitment). ","Reference equipment included in the budget detail that supports a given committment. Cost and quantity should appear in the budget detail table only.  Leave blank if no equipment supports the commitment.  Provide additional detail in the budget narrative. ","Indicate whether each commitment is supported by a contract, subgrant, rebate, and/or lease. Provide additional information in the budget detail."]
["Component 1","Administration and Coordination"]
["Comittment 1.1","Planning and preparation for implementation of other IRA Progams related to greenhouse gases and air quality","Grant application with established roles and responsibilities of those involved\n","FY23"," ","2023-12-23","Partially Complete"]
["Comittment 1.2","Ensure data collected and used under this grant is consistent with EPA Quality Asurance standards","Quality Assuarance Management Plan Development and approval by EPA","FY23",null,"2023-12-15"]
["Comittment 1.3","Training of personnel to advance the knowledge of air pollution sources and control technologies.","10 Air Quality Specialists Trained","FY23",null,"2023-09-30"]
["Comittment 1.4","Other activities to “conduct, and promote the coordination and acceleration of research, investigations, experiments, demonstrations, surveys and studies related to the causes, effects (including health and welfare effects), extent, prevention and control of air pollution. ","Examine the regional, state, and county level emission impacts of different energy programs based on temporal energy savings, hourly generation profiles, and vehicle types using https://www.epa.gov/avert/uses-avert ","FY23",null," "]
["Comittment 1.5","Plan, control, and monitor expenditures of manpower and state/federal financial resources.  Coordinate the development of performance reports and submit to EPA.","Submit to EPA initial two-year work plan and/or annual work plan amendments on time, according to published guidance documents, or as otherwise agreed through written communication.","FY23",null,"2023-06-30"]
["Comittment 1.6","Plan, control, and monitor expenditures of manpower and state/federal financial resources.  Coordinate the development of performance reports and submit to EPA.","Submit to EPA mid-year, end-of-year, and final grant performance and budget status summary reports on time, according to published guidance documents, or as otherwise agreed through written communication.","FY23/24","PR1: Due 4/24\nPR2: Due 10/24\nPR3: Due 4/25\nPR4: Due 10/25","2023-06-30"]
["Component 2","Research and Development"]
["Commitment 2.1","Improved decisionmaking based on a better understanding of cumulative health impacts in disadvantaged communities","Research and analysis of the effects or extent of pollution on low-income and disadvantaged communities within the air pollution control agency’s jurisdiction.  This may include analysis of disparate impacts from pollution sources.","FY23",null,"2023-09-30"]
["Commitment 2.2","Improved decisionmaking based on better understanding of the role of control technologies in greenhouse gases on localized pollution and health impacts ","Study that includes modeling of air pollution, including greenhouse gases, and potential reductions under varying control technologies and strategies.\n","FY23",null,"2023-09-30"]
["Commitment 2.3","Improved decisionmaking based on better understanding of the role of control technologies in greenhouse gases on localized pollution and health impacts ","Research of new or experimental technologies, methods or approaches for the control of air pollution, including greenhouse gases.","FY23",null,"2023-09-30"]
["Commitment 2.4","Modeling results will help estimate the relationship between sources and their effects on ambient air quality, including potential reductions under varying contol technolgies and strategies.","Utilize EPA's Averted Emissions and generation tool (https://www.epa.gov/avert) to compare the emission impacts of different types of energy programs and policies.","FY23",null,"2023-09-30"]
["Component 3","Air Planning"]
[]
[]
["Component 4","Pollution Source Information and/or Emission Inventories (including GHG) "]
[4.0999999999999996,"Improved decisionmaking based on increased knowledge of pollution sources and emissions inventories.","Development or updating of pollution source information and/or emissions inventories, including greenhouse gas inventories.","FY24","PR1: Due 4/23\nPR2: Due 10/23\nPR3: Due 4/24\nPR4: Due 10/24","2024-09-30"]
[]
["Component 5","Air Monitoring"]
[5.0999999999999996,"Provide realtime updates to the public on airnow.gov","Monitor for PM 2.5 at 23 monitoring stations","FY23",null,"2023-09-30"]
[]
[]
["Component 6","Program and Policy Development"]

{"sheet":"Budget Detail Cat. & Component","index":1,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Budget Details By Category & Component"]
[" Note: Use the desktop version of Excel. This worksheet is an example for illustrative purposes. Please replace the information with data specific to your project. Totals should match the costs in the applicant's SF-424A."]
[]
["Components (choose all that apply)","Personnel  \nPosition(s)","Annual Salary","% FTE spent on grant activities","Subtotal","Totals"]
["Air Planning, Program and Policy Development, Administration and Coordination, Pollut. Source Info / Emission Inv. (incl GHG) ","Air Program Director",100000,0.2,20000]
["Administration and Coordination, Pollution Source Information and/or Emission Inventories (including GHG) , Air Monitoring, Research and Development","Branch Manager of Program Partnerships",80000,0.2,16000]
["Air Monitoring, Pollution Source Information and/or Emission Inventories (including GHG) ","Team lead for GHG emissions reduction",60000,0.4,24000]
["Air Monitoring, Research and Development","Air Monitoring Staff",50000,0.3,15000]
[]
[null,null,null,null,"Personnel TOTAL",{"$f":"SUM(E5:E8)","v":75000}]
[null,"Fringe Benefits \n(Salary x %)","Salary","Percentage","Subtotal"]
["Administration and Coordination",null,75000,0.28000000000000003,{"$f":"D12*F10","v":21000.000000000004}]
[null,null,null,null,"Fringe TOTAL",{"$f":"E12","v":21000.000000000004}]
[null,"Travel\nPurpose and location of each trip","Cost/trip","#of trips","Trip Totals"]
["Administration and Coordination, Air Planning","Air Planning Training, Washington, DC ",1000,2,{"$f":"C15*D15","v":2000}]
["Administration and Coordination","Planning meetings, local travel in Sacramento area (mileage only)",100,10,{"$f":"C16*D16","v":1000}]
[]
["Research and Development, Air Planning, Pollut. Source Info / Emission Inv. (incl GHG) ",null,null,null,"Travel Total",{"$f":"SUM(E15:E17)","v":3000}]
[null,"Equipment\nList purpose and description of each piece of equipment\n\nGenerally defined as more than $5,000 and with a useful life of more than one year per 2CFR Part 200","Cost/item","# of items","Subtotal"]
["Air Monitoring","CO Analyzer",13320,2,{"$f":"C20*D20","v":26640}]
["Air Monitoring","O3 Analyzer",19820,1,{"$f":"C21*D21","v":19820}]
[]
[null,null,null,null,"Equipment TOTAL",{"$f":"SUM(E20:E21)","v":46460}]
[null,"Supplies\nList items under $5,000 that are not equipment","Cost/item","# of items","Subtotal"]
["Research and Development","Uninterruptible Power Supply",500,2,{"$f":"C25*D25","v":1000}]
["Research and Development","Equipment calibrator",500,1,{"$f":"C26*D26","v":500}]
[]
[null,"Supplies TOTAL",null,null,null,{"$f":"SUM(E25:E26)","v":1500}]
[null,"Contractual \nList purpose and description of each contract","Cost/contract","# of contracts","Subtotal"]
["Administration and Coordination, Pollution Source Information and/or Emission Inventories (including GHG) ","SO2 public-facing website development",null,null,75000]
["Air Monitoring","Maintenance for Air Monitoring Station",null,null,25000]
[]
[null,null,null,null,"Contractual TOTAL",{"$f":"SUM(E30:E31)","v":100000}]
[null,"Other \nList purpose and description of each subaward or participant support cost activity","Cost/subaward or participant support ","# of subawards or participants supported"]
["Administration and Coordination","Subaward to Air Quality Management District for commitments 1.2 & 1.4 - 1.6",130000,1,{"$f":"C35*D35","v":130000}]
["Administration and Coordination","Subaward to University of Clean Air for commitments 1.1 & 1.3",55000,1,{"$f":"C36*D36","v":55000}]
[]
["Administration and Coordination",null,null,null,"Other TOTAL",{"$f":"SUM(E35:E36)","v":185000}]
[null,null,null,null,"TOTAL DIRECT CHARGES",{"$f":"F10+F13+F18+F23+F28+F33+F38","v":431960}]
[null,"Indirect Charges","Percentage","Total Direct Costs",null,"Total Indirect Charges"]
[null,"Federal indirect cost rate (percentage) x Total Direct Costs = Indirect Costs",null,null,0,"n/a"]
[null,null,null,null,"TOTAL INDIRECT CHARGES",{"$f":"E41","v":0}]
[null,null,null,null,"TOTAL CHARGES",{"$f":"F39+F42","v":431960}]

{"sheet":"Incomplete - Comment Log table","index":2,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Media:","NPM:","Regional Division:","EPA Goal:","EPA Objective:","Workplan Component","Commitment FY","Workplan Commitment","Commitment Comment","Outcome","Status","Status Comment","EPA Comment","State Comment","Comment Date","Target Completion"]
["Air & Radiation","OAR","ARD","Goal 1 - Core Mission","Objective 1.1 – Improve Air Quality","Ozone, PM2.5, PM10, and CO","FY18","Continue participation in EPA's AIRNOW program. Submit real-time pollutant data and provide forecasts and alerts. By March 1, 2018, work with EPA to enable Twitter and real-time notification features of EnviroFlash. Attend R1 air quality outreach and forecasting workshop, if held, either in person or remotely. Attend EPA's National Air Quality Conference. (FY'18-19 DRAFT OAR NPM Guidance: NAAQS, 2.1.1.3 Other, #1; and Ambient Air Monitoring for Criteria Pollutants, 2.4.1, #8)"]
["Air & Radiation","OAR","ARD","Goal 1 - Core Mission","Objective 1.1 – Improve Air Quality","Ozone, PM2.5, PM10, and CO","FY19"]
["Air & Radiation","OAR","ARD","Goal 1 - Core Mission","Objective 1.1 – Improve Air Quality","Ozone, PM2.5, PM10, and CO","FY19","For all future revisions to the SIP, work to implement the recommendations in the final Standard Operating Procedures document developed by EPA Region 1 and the New England states.",null,null,"Complete",null,null,"NH will implement these recommendations"]

{"sheet":"Standardized Terms","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,2,0,4]]}
["Standardized Term","Definition","Also Known As"]
["Workplan Component","A negotiated set or group of work plan commitments established in the grant agreement. A work plan may have one or more work plan components","Program Area"]
["Workplan Commitment","The outputs and outcomes associated with each work plan component, as established in the grant agreement","Activity","Planned Accomplishments/Requirements","Output"]
["Status ","Short defined list of status options. Detailed status information can be captured in the comment field"]
["Comment"]
["Subcomponent","a subgrouping of commitments under a larger workplan component","Related Measure"]

{"sheet":"List Data","index":4,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Media","NPM","Regional Division","Commitment FY","Commitment Type","Work Plan Component","Status*","EPA Strategic Goal","EPA Strategic Objective","EPA/State/Joint","Type of Report"]
[null,"AO","MSD","FY23","Administration","Administration and Coordination","Complete"]
[null,"OAR","LSAD","FY24","Staff Training","Research and Development","Partially Complete"]
[null,"OCSPP","WD","FY25","Reporting","Air Planning","Not Complete"]
[null,"OECA","ECAD","FY26","Outreach","Pollut. Source Info / Emission Inv. (incl GHG) ","On Going"]
[null,"OITA","ORA","FY27","Assessments","Air Monitoring"]
[null,"OLEM","ORC","FY28","Training","Program and Policy Development"]
[null,"OMS","ARD","FY29","Record keeping","Air Quality Improvement Strategies"]
[null,"OW","SEMD","FY30","Program promotion"]
[null,null,"LCRD",null,"Collaboration"]
[null,null,null,null,"Program-specific"]
[null,null,null,null,"Evaluation"]