{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Workplan Narrative","Workplan and Reporting","Fiscal Quarterly Reporting"," Sample State Budget ","Incomplete - Comment Log table","Standardized Terms","Sample MSA Budget","Sample State or MSA Timeline"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"Instructions","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["The IRA CPRG Grant Program Guidance provides an overview of required grant Workplan deliverables and elements. This document provides additional information to support to grant applicants in developing the workplan for their IRA Climate Pollution Reduction Grant project. Specifically, this document provides more detailed instructions for what should be included in the narrative description of the project and offers an OPTIONAL State and MSA Sample Grant Workplan and Reporting Tool in the form of a spreadsheet for capturing the workplan narrative, key deliverables, elements, milestones, budget details, and to facilitate progress reporting, which is required on quarterly basis. The State and MSA Sample Grant Workplan and Reporting Tool can be voluntarily submitted in place of or in addition to a Word document narrative version using the Sample Workplan Outline.  \n\nBeyond the workplan requirements, applicants may include additional information (e.g., letters of commitment and/or resumes from collaborating partners, emissions inventories, emissions reductions calculations, etc.), but such additional information is optional.\n\nPart 1: Workplan Narrative\nPlease review the Sample Workplan Outline under Sample Documents section of the IRA CPRG Grant Program Guidance before starting your narrative. Applicants can choose to use the Sample Workplan Outline or fill in the Workplan Narrative worksheet of the State and MSA Sample Grant Workplan and Reporting Tool. \n\nFor the Column K in the Workplan Narrative worksheet, Interagency and Intergovernmental Coordination, requirements specific to States and MSAs are listed below. \n\nState Requirements \nOngoing coordination as much as possible among state agencies, air pollution control agencies, and municipalities is expected for the development of the PCAP and over the duration of the cooperative agreement. States are encouraged to similarly coordinate with tribes. A state workplan must include:\n \n•\tA description of the expected process for coordinating/collaborating with a variety of entities within the state (i.e., air pollution control agencies, municipalities, and tribes), including those that are not directly receiving their own planning cooperative agreement funding; and, \n•\tA description of any sub-awards that are expected to be issued to air pollution control agencies, municipalities, tribes, or other organizations. \n\nThe interagency collaboration process is intended to result in the identification and inclusion of priority measures in the state PCAP that can be implemented by collaborating entities. Sub-awards, including sub-awards to air pollution control agencies, municipalities, and tribes, are allowed under this funding award, subject to terms and conditions, and may be used to support planning efforts for those entities. \n\n\n\n\n"]
["MSA Requirements \nClimate plans for metropolitan areas should also be developed with regional coordination as much as possible, and applicants are encouraged to coordinate with geographically proximate tribes as appropriate. A MSA workplan must include:\n\n•\tThe existing or planned roles and relationships of the partnering jurisdictions and the process for developing joint work products; and, \n•\tAny sub-awards that are expected to be issued to partnering jurisdictions. \n\nSub-awards to partners are allowed under this funding award, subject to terms and conditions. Letters of support/commitment from partners are encouraged.\n\nPart 2: State and MSA Sample Grant Workplan and Reporting Tool\nThe sample workplan tool spreadsheet entitled State and MSA Sample Grant Workplan and Reporting Tool, illustrates how project deliverables, elements, outputs, and milestones can be captured in a spreadsheet format. Choosing to use this tool will also help ensure that the Workplan and the project itself comply with EPA Order 5700.7A1: EPA’s Policy for Environmental Results under EPA Assistance Agreements. Refer to Linking Assistance Agreements to Environmental Results for more information.\n\nThe State and MSA Sample Grant Workplan and Reporting Tool works best if using the desktop version of Excel.\n\nThe tool can also be used to document quarterly progress reports, which are required. These progress reports are integrated into columns N and O of the Workplan and Reporting worksheet of the spreadsheet tool. Progress reports should describe and evaluate progress towards the specific workplan outputs and outcomes, measured against targeted milestones. Generally, there are several outputs and a few overarching outcomes. \n\nAdditional progress reporting and EPA comment columns may be added as desired or needed. Please note the following EPA regulations governing workplans: 40 CFR 35.102 (definitions); 40 CFR 35.107 (state and local recipients); 40 CFR 35.507 (Tribal recipients).\n\nPart 3: Budget Detail\nThe State and MSA Sample Grant Workplan and Reporting Tool also includes worksheets entitled Sample State Budget and Sample MSA Budget which illustrate how budget details about an IRA Climate Pollution Program project can be captured. Please review the Sample Climate Pollution Reduction Grants Budget in the Sample Documents section of the IRA CPRG Grant Program Guidance. Applicants can choose to use worksheets to submit their Budget Details. Applicants must itemize costs related to personnel, fringe benefits, travel, equipment, supplies, contractual costs, other direct costs, indirect costs, and total costs. This tool works best if using the desktop version of Excel.\n"]
["Because the District of Columbia has no internal sub-state jurisdictions, they are encouraged to coordinate with the Virginia, Maryland, and West Virginia jurisdictions making up the metropolitan area. \n\nAdditional information on preparing applications and budgets can be found in EPA’s Interim General Budget Development Guidance for Applicants and Recipients of EPA Financial Assistance. \n\nPlease update the tool using your data and double check that the formulas reflect your updates.\n\nDescription of Detailed Budget Categories\nPlease ensure the following information is included in the budget worksheet. If additional detail is warranted, provide a description in the project narrative noting the relevant budget category.\n\n•\tPersonnel - List all staff positions by title. If you do not use the rate and hours in the budget detail, provide annual salary, percentage of time assigned to the project, and total cost for the budget period. This category includes only direct costs for the salaries of those individuals who will perform work directly for the project (generally, paid employees of the applicant organization). Personnel costs in this category do not include: (1) costs for services of consultants, contractors, consortia members, or other partner organizations, which are included in the “Contractual” category; (2) costs for employees of subrecipients under subawards, which are included in the “Other” category; or (3) effort that is not directly in support of the proposed project, which may be covered by the organization’s negotiated indirect cost rate. The budget details must identify the personnel category type by Full Time Equivalent (FTE), including percentage of FTE for part-time employees, number of personnel proposed for each category, and the estimated funding amounts.\n\n•\tFringe Benefits – Identify the percentage used, the basis for its computation, and the types of benefits included. Fringe benefits are allowances and services provided by employers to their employees as compensation in addition to regular salaries and wages. Fringe benefits include, but are not limited to the cost of leave, employee insurance, pensions, and unemployment benefit plans.\n\n•\tTravel – Specify the mileage, per diem, estimated number of trips in-State and out-of-State, number of travelers, and other costs for each type of travel. Travel may be integral to the purpose of the proposed project (e.g., inspections) or related to proposed project activities (e.g., attendance at meetings). Travel costs do not include: (1) costs for travel of consultants, contractors, consortia members, or other partner organizations, which are included in the “Contractual” category; (2) travel costs for employees of subrecipients under subawards, which are included in the “Other” category."]
["•\tSupplies – “Supplies” means all tangible personal property other than “equipment.” The budget details should identify categories of supplies to be procured (e.g., laboratory supplies, office supplies, etc.). Non-tangible goods and services associated with supplies, such as printing service, photocopy services, and rental costs should be included in the “Other” category.\n\n•\tEquipment – Identify each item to be purchased which has an estimated acquisition cost of $5,000 or more per unit and a useful life of more than one year. Equipment also includes accessories necessary to make the equipment operational. Equipment does not include: (1) equipment planned to be leased/rented, including lease/purchase agreement; or (2) equipment service or maintenance contracts. These types of proposed costs should be included in the “Other” category. Items with a unit cost of less than $5,000 should be categorized as supplies, pursuant to 2 CFR Part 200. The budget details must include an itemized listing of all equipment proposed under the project. \n\n•\tContractual – Identify each proposed contract and specify its purpose and estimated cost. Contractual/consultant services are those services to be carried out by an individual or organization, other than the applicant, through a procurement relationship. Leased or rented goods (equipment or supplies) should be included in the “Other” category. The applicant should list the proposed contract activities along with a brief description of the scope of work or services to be provided, proposed duration, and proposed procurement method (competitive or non-competitive), if known. \n\n•\tOther – List each item in sufficient detail for EPA to determine the reasonableness and allowability of its cost. This category should include only those types of direct costs that do not fit in any of the other budget categories. Examples of costs that may be in this category include: insurance, rental/lease of equipment or supplies, equipment service or maintenance contracts, printing or photocopying, participant support costs (i.e., rebates), and subaward costs.\n\nSubawards (e.g., subgrants) and participant support costs are each a distinct type of cost under the “Other” cost category. The term “subaward” means an award of financial assistance (money or property) by any legal agreement made by the recipient to an eligible subrecipient even if the agreement is referred to as a contract. Rebates, subsidies, incentives, and similar one-time, lump-sum payments to program beneficiaries for the purchase of eligible activities are considered participant support costs, not subawards. See EPA’s Participant Support Costs guidance.\n"]
["“Other” does not include procurement purchases, technical assistance in the form of services instead of money, or other assistance in the form of revenue sharing, loans, loan guarantees, interest subsidies, insurance, or direct appropriations. Subcontracts are not subawards and belong in the contractual category. Applicants must provide the aggregate amount they propose to issue as subaward work or participant support costs as a separate line item in the “Other” category, and a description of the types of activities to be supported. Refer to EPA’s Subaward Policy and supplemental Frequent Questions for additional guidance.\n\n•\tIndirect Charges – If indirect charges are budgeted, indicate the approved rate and base. Indirect costs are those incurred by the grantee for a common or joint purpose that benefit more than one cost objective or project and are not readily assignable to specific cost objectives or projects as a direct cost. In order for indirect costs to be allowable, the applicant must have a federal or state negotiated indirect cost rate (e.g., fixed, predetermined, final, or provisional), or must have submitted a proposal to the cognizant Federal or State agency. Examples of Indirect Cost Rate calculations are shown below:\n   o\t   Personnel (Indirect Rate x Personnel = Indirect Costs)\n   o\t  Personnel and Fringe (Indirect Rate x Personnel & Fringe = Indirect Costs)\n   o\t  Total Direct Costs (Indirect Rate x Total direct costs = Indirect Costs)\n   o\t  Direct Costs minus distorting or other factors such as contracts and equipment\n   o\t  Indirect Rate x (total direct cost – distorting factors) = Indirect Costs\nFor additional guidance, please refer to Indirect Cost Guidance for Recipients of EPA Assistance Agreements.\n\nPart 4: Timeline\nThe State and MSA Sample Grant Workplan and Reporting Tool also includes a Sample State or MSA Climate Planning Timeline worksheet. Applicants are required to provide a detailed schedule covering the 4-year duration of the planning grant (cooperative agreement). Key milestones and completion deadlines should be provided for each deliverable and reporting requirement. The schedule may include reporting and Quality Assurance Project Plan (QAPP) development, key meetings, public outreach, procurement and hiring deadlines, and completion of required workforce planning analysis and any legal or policy review. \n\nIf you have further questions, please contact your applicable EPA Regional Point of Contact."]
["Part 5: Quaterly Reporting and Fiscal Quaterly Reporting \nColumns N-AY of the \"Workplan and Reporting\" tab were updated and a new tab was created called \"Fiscal Quarterly Reporting\". Please follow instructions in these tabs when working on your quaterly reports. "]

{"sheet":"Workplan Narrative","index":1,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Grant Project Title","Grant Project Period (xx/xx/xxxx - xx/xx/xxxx)","Place of Performance","Lead Organization","Coordinating Entities","Connection to Previously Developed Climate Action Plan(s)","Previously Developed Climate Action Plan(s) Link(s)","Strategic Plan Reference: ","Overarching Deliverable Approach","Interagency and Intergovernmental Coordination ","Public and Stakeholder Engagement","Climate Innovation Teams"]
["Instructions:\nThis row may be deleted or hidden when workplans are submitted to EPA. For paragraph seperation press \"Alt\" and \"Enter\"","One descriptive sentence only.","Note the start and end date of the project period (not to exceed 4 years from the project start date, running until 2027).","List the primary place of performance. For example, place of performance can be described as an entire state/D.C./Puerto Rico or MSA - specify all counties ","Provide the name of the agency and office that will serve as the lead contact for this grant. This should match the Notice of Intent to Participate (NOIP) applicant or designee. Please provide the name of a point of contact at this agency and contact information (email address and phone number). ","List other organizations expected to be involved in the deliverable development process. This group can include, but is not limited to, state agencies/offices, tribal nations, municipalities, regional planning organizations, air pollution control agencies, advisory committees, subawardees (such as academic institutions or non-profit organizations), or contractors (if already identified). EPA highly recommends including letters of commitment from these coordinating entities. Letters of commitment originally included in the NOIP can be incorporated by reference.","Applicants may describe in their workplans how they expect to draw from previously developed climate action plans to help satisfy the required elements of each deliverable. For example, applicants may describe how an existing climate action plan will inform the identification of measures for the PCAP, how a CCAP funded through a planning grant award could extend or expand the work completed in a previously developed climate action plan, or how existing or updated climate metrics and emissions monitoring and reporting could inform the Status Report.","Provide link(s) to the previously developed Climate Action Plan(s) referenced in Column G","The narrative should include a section that notes “The deliverables and elements in this workplan support EPA’s Fiscal Yeary (FY) 2022-2026 Strategic Plan Goal 1 (Tackle the Climate Crisis); Objective 1.1 (Reduce Emissions that Cause Climate Change).” \n\nApplicants should include specific statements describing the environmental results of the proposed project in terms of well-defined outputs and, to the maximum extent practicable, well-defined outcomes that will demonstrate how the project will\ncontribute to the EPA Strategic Plan priorities. Reference the \"Workplan and Reporting\" tab columns  D-F in addressing Strategic Plan linkages. ","Describe overarching approach to developing the PCAP, CCAP, and Status Report. Applicants can expand on what is included in the \"General Approach/Deliverable Development Process\" in Column C on the \"Workplan and Reporting\" worksheet but do not need to duplicate information. \n","PCAP:  Describe how the lead organization intends to collaborate with coordinating entities, other appropriate agencies and offices within their own government and at various levels of government in the development and adoption of the PCAP. As applicable, discuss existing partnerships and how they will be engaged, the creation or expansion of interagency working groups, the creation of a shared electronic repository for background material and working drafts, and a meeting schedule. States must outline coordination with sub-state entities (e.g., municipalities, air pollution control agencies, regional planning organizations, etc.) and tribal nations during the development process as well as how these entities will be provided with the final PCAP in a timely manner for purposes of those entities applying for an implementation grant under the CPRG program.\n\nCCAP: Describe how the lead organization intends to collaborate with coordinating entities, other appropriate agencies and offices within their own government, and at various levels of government, in the development and adoption of the CCAP. As applicable, discuss existing partnerships and how they will be engaged, the creation or expansion of interagency working groups, the creation of a shared electronic repository for background material and working drafts, and a meeting schedule. \n\nStatus Report: Describe how the lead organization intends to collaborate with coordinating entities, other appropriate agencies and offices within their own government and at various levels of government in the development of the Status Report and any associated updated elements. \n\nPlease reference \"Instructions\" tab for State and MSA specific requirements ","PCAP:  Explain how the lead organization will involve stakeholder groups and the public in the PCAP development process. Describe the approach to identifying low-income and disadvantaged communities consistent with federal government guidance, conducting meaningful engagement with those communities, and identifying and including those communities’ priorities in the PCAP. \n\nCCAP: Describe how the lead organization and coordinating entities intend to conduct meaningful engagement with affected communities in the development of the CCAP, especially with low income and disadvantaged communities. At a minimum, describe the method for identifying interested and/or affected stakeholder groups (especially low-income and disadvantaged communities, consistent with federal government guidance), the proposed approach for seeking continuous input, and methods of communicating key decisions and overall progress, providing education, and sharing information with stakeholders both during and following CCAP development. Describe how early and frequent engagement with low-income and disadvantaged communities (described in Section 8.4.3 of the program guidance) will occur and how that engagement will inform the required elements of the CCAP, especially the low-income and disadvantaged communities benefits analysis. \n\nStatus Report:\nDescribe how stakeholders, including the public and disadvantaged communities, will be engaged in the identification of next steps and funding opportunities. Explain how stakeholders will be informed about the status of the PCAP and CCAP elements and the plan to continue engagement beyond the grant period.","A lead organization or any coordinating entity interested in participating in one or more Climate Innovation Teams (as described in Section 14.2 of the program guidance) should express their interest and (if known) any specific topical areas they are most interested in. (Please also identify any specific topics of interest that are not included in the examples in Section 14.2.) Costs associated with participation in the Climate Innovation Teams, such as travel to a potential annual meeting of the teams, should be included in the workplan budget. "]
[null,null,null,null,null,null,null,null,"The deliverables and elements in this workplan support EPA’s Fiscal Yeary (FY) 2022-2026 Strategic Plan Goal 1 (Tackle the Climate Crisis); Objective 1.1 (Reduce Emissions that Cause Climate Change)."]

{"sheet":"Workplan and Reporting","index":2,"n_rows":41,"n_cols":51,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,2],[0,15,0,30],[0,31,0,46],[1,15,1,18],[1,19,1,22],[1,23,1,26]]}
["DRAFT IRA CPRG State and MSA Sample Grant Workplan and Reporting Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024]
["Most Recent EPA Approved Grant Application Workplan Date: MM/DD/YYYY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",null,null,null,"Q2",null,null,null,"Q3"]
["Workplan Elements","Key Deliverables","General Approach/Deliverable Development Process","Outputs","Outcomes","Performance Measures","Entities Responsible for Completing Each Element","Collaborating/Partnering Entities Involved in Each Element","Location(s)","Contract or Subaward Support","Quality Assurance ","Milestones","Target Completion Date","Overall Status         ","Quarterly Performace Progress Report Grantee Contact","Quarterly Performance Progress (Grant start date-September 2023)","EPA Comments and Questions","Grantee Response","EPA Approved ","Quarterly Performance Progress (October-December 2023)","EPA Comments and Questions","Grantee Response","EPA Approved ","Quarterly Performance Progress (January-March 2024)","EPA Comments and Questions","Grantee Response","EPA Approved ","Quarterly Performance Progress (April-June 2024)","EPA Comments and Questions","Grantee Response","EPA Approved ","Quarterly Performance Progress (July-September 2024)","EPA Comments and Questions","Grantee Response","EPA Approved ","Quarterly Performance Progress (October-December 2024)","EPA Comments and Questions","Grantee Response","EPA Approved ","Quarterly Performance Progress (January-March 2025)","EPA Comments and Questions","Grantee Response","EPA Approved ","Quarterly Performance Progress (April-June 2025)","EPA Comments and Questions","Grantee Response","EPA Approved ","Quarterly Performance Progress (April-June 2025)","EPA Comments and Questions","Grantee Response","EPA Approved "]
["Instructions:\nThis row may be deleted or hidden when workplans are submitted to EPA. ","For each element under the Key Deliverables, the parentheses state if the element is required (green), encouraged/optional (yellow), or not required (red) per the program guidance. If the element is required, then all blue columns in this row related to that element should be filled in on this spreadsheet where applicable.","General approach to developing all required elements of each deliverable; Describe the decision-making process and the roles of the coordinating jurisdictions, contractors, subawards, lead organization and the general public.  ","The term “output” means an environmental activity, effort and/or associated work product related to an environmental goal and objective that will be produced or provided over a period of time or by a specified date. Outputs may be quantitative or qualitative but should be measurable during a cooperative agreement funding period. Potential outputs should be as detailed as possible associated with the key deliverables and elements. Only include outputs where applicable. Examples of potential outputs are in red text below in the appropriate Key Deliverables row. ","The term “outcome” means 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, but should also be quantitative. They may not necessarily be achievable within a cooperative agreement funding period. \n\nExpected outcomes from the projects to be funded under this announcement should include, but are not limited to: Tons of pollution (GHGs and co-pollutants) reduced over the lifetime of the measures identified in the PCAP and the CCAP; Tons of pollution (GHGs and co-pollutants) reduced annually; and, Tons of pollution (GHGs and co-pollutants) reduced with respect to low-income and disadvantaged communities.\n\nOther potential outcomes may include, but are not limited to: Improved staff capacity to implement policies to address climate change; Enhanced community engagement; Improved ambient air quality; Health benefits achieved; Increased public awareness of project and results; and/or, Creation of high-quality jobs with an emphasis on workers from underserved populations.\n\nOnly include outcomes where applicable. Examples of potential outcomes are in red text below in the appropriate Key Deliverables row. ","The applicant should develop performance measures and metrics they expect to use to track progress of the proposed activities. These measures and metrics must be described in their application. Such performance measures will help gather insights and will be the mechanism to track progress concerning successful processes and output and outcome strategies and will provide the basis for developing the Status Report deliverable. The description of the performance measures should directly relate to the project’s outputs and outcomes, including but not limited to:\n• Overseeing sub-recipients, and/or contractors and vendors;\n• Tracking and reporting project progress on expenditures and purchases; and,\n• Tracking, measuring, and reporting accomplishments and proposed timelines/milestones.\n\nThe following are questions to consider when developing output and outcome measures of quantitative and qualitative results:\n• What are the measurable short-term and longer-term results the project will achieve?\n• How will the grant recipient measure progress in achieving the expected results\n(including outputs and outcomes) and use resources effectively and efficiently? ","Enter name of entity (Ex. Territory A, Department of Health may be responsible for Element 1.1 but Territory B, Department of Natural Resources may be responsible for Element 1.3)","Enter name of entity (Ex. Tribe A, State of B, and City of C will all collaborate in indetifying and quantifying GHG reduction measures in 1.4) ","Tribal Lands or Territory","Indicate whether each commitment is supported by a contract, subgrant, rebate, and/or lease. Provide additional information in the budget detail.","Is a Quality Assurance Project Plan (QAPP) required (yes/no)?   please choose from the dropdown","Provide the month and year (xx/xxxx) targeted for any key interim milestones that support the outputs (e.g., reporting deadlines).","Provide the month and year (xx/xxxx) of the target completion date for the outcome.","Overall status (to be updated quarterly) - please choose from the dropdown","Provide the name, title, email address, and phone number of the person responsible for each deliverable/element. ","Provide 2-3 sentences summarizing the status of each element. If progress is slower than anticipated, please explain why, what barriers were encountered and how these barriers will be overcome. Include an additional 1-2 sentences summarizing outputs and/or outcomes, where applicable. If work for a specific element was not scheduled for this quarter, please type \"N/A\" next to that element.                                                                                                      Note: Quarterly performance progress reports are required, including grant fund reporting elements and summaries of the project activity and status of outputs during the reporting period.  In addition to this narrative reporting section of the \"Workplan and Reporting\" tab, please go to the \"Fiscal Quarterly Reporting\" tab and provide fiscal drawndown information. Quarterly reports are due 30 days after the end of the reporting period.","EPA may use this column to respond to Quarterly Performance Progress Reporting with comments, questions, and/or clarifications.","Provide response to EPA comments, questions, and/or clarifications, where applicable. ","Does EPA approve this workplan element progress to date (yes/no)? The EPA Project Officer should choose from the dropdown.","Provide 2-3 sentences summarizing the status of each element. If progress is slower than anticipated, please explain why, what barriers were encountered and how these barriers will be overcome. Include an additional 1-2 sentences summarizing outputs and/or outcomes, where applicable. If work for a specific element was not scheduled for this quarter, please type \"N/A\" next to that element.                                                                                                      Note: Quarterly performance progress reports are required, including grant fund reporting elements and summaries of the project activity and status of outputs during the reporting period.  In addition to this narrative reporting section of the \"Workplan and Reporting\" tab, please go to the \"Fiscal Quarterly Reporting\" tab and provide fiscal drawndown information. Quarterly reports are due 30 days after the end of the reporting period.","EPA may use this column to respond to Quarterly Performance Progress Reporting with comments, questions, and/or clarifications.","Provide response to EPA comments, questions, and/or clarifications, where applicable. ","Does EPA approve this workplan element progress to date (yes/no)?  The EPA Project Officer should choose from the dropdown.","Provide 2-3 sentences summarizing the status of each element. If progress is slower than anticipated, please explain why, what barriers were encountered and how these barriers will be overcome. Include an additional 1-2 sentences summarizing outputs and/or outcomes, where applicable. If work for a specific element was not scheduled for this quarter, please type \"N/A\" next to that element.                                                                                                      \nNote: Quarterly performance progress reports are required, including grant fund reporting elements and summaries of the project activity and status of outputs during the reporting period.  In addition to this narrative reporting section of the \"Workplan and Reporting\" tab, please go to the \"Fiscal Quarterly Reporting\" tab and provide fiscal drawndown information. Quarterly reports are due 30 days after the end of the reporting period.","EPA may use this column to respond to Quarterly Performance Progress Reporting with comments, questions, and/or clarifications.","Provide response to EPA comments, questions, and/or clarifications, where applicable. ","Does EPA approve this workplan element progress to date (yes/no)?  The EPA Project Officer should choose from the dropdown.","Provide 2-3 sentences summarizing the status of each element. If progress is slower than anticipated, please explain why, what barriers were encountered and how these barriers will be overcome. Include an additional 1-2 sentences summarizing outputs and/or outcomes, where applicable. If work for a specific element was not scheduled for this quarter, please type \"N/A\" next to that element.                                                                                                      \nNote: Quarterly performance progress reports are required, including grant fund reporting elements and summaries of the project activity and status of outputs during the reporting period.  In addition to this narrative reporting section of the \"Workplan and Reporting\" tab, please go to the \"Fiscal Quarterly Reporting\" tab and provide fiscal drawndown information. Quarterly reports are due 30 days after the end of the reporting period.","EPA may use this column to respond to Quarterly Performance Progress Reporting with comments, questions, and/or clarifications.","Provide response to EPA comments, questions, and/or clarifications, where applicable. ","Does EPA approve this workplan element progress to date (yes/no)?  The EPA Project Officer should choose from the dropdown.","Provide 2-3 sentences summarizing the status of each element. If progress is slower than anticipated, please explain why, what barriers were encountered and how these barriers will be overcome. Include an additional 1-2 sentences summarizing outputs and/or outcomes, where applicable. If work for a specific element was not scheduled for this quarter, please type \"N/A\" next to that element.                                                                                                      \nNote: Quarterly performance progress reports are required, including grant fund reporting elements and summaries of the project activity and status of outputs during the reporting period.  In addition to this narrative reporting section of the \"Workplan and Reporting\" tab, please go to the \"Fiscal Quarterly Reporting\" tab and provide fiscal drawndown information. Quarterly reports are due 30 days after the end of the reporting period.","EPA may use this column to respond to Quarterly Performance Progress Reporting with comments, questions, and/or clarifications.","Provide response to EPA comments, questions, and/or clarifications, where applicable. ","Does EPA approve this workplan element progress to date (yes/no)?  The EPA Project Officer should choose from the dropdown.","Provide 2-3 sentences summarizing the status of each element. If progress is slower than anticipated, please explain why, what barriers were encountered and how these barriers will be overcome. Include an additional 1-2 sentences summarizing outputs and/or outcomes, where applicable. If work for a specific element was not scheduled for this quarter, please type \"N/A\" next to that element.                                                                                                      \nNote: Quarterly performance progress reports are required, including grant fund reporting elements and summaries of the project activity and status of outputs during the reporting period.  In addition to this narrative reporting section of the \"Workplan and Reporting\" tab, please go to the \"Fiscal Quarterly Reporting\" tab and provide fiscal drawndown information. Quarterly reports are due 30 days after the end of the reporting period.","EPA may use this column to respond to Quarterly Performance Progress Reporting with comments, questions, and/or clarifications.","Provide response to EPA comments, questions, and/or clarifications, where applicable. ","Does EPA approve this workplan element progress to date (yes/no)?  The EPA Project Officer should choose from the dropdown.","Provide 2-3 sentences summarizing the status of each element. If progress is slower than anticipated, please explain why, what barriers were encountered and how these barriers will be overcome. Include an additional 1-2 sentences summarizing outputs and/or outcomes, where applicable. If work for a specific element was not scheduled for this quarter, please type \"N/A\" next to that element.                                                                                                      \nNote: Quarterly performance progress reports are required, including grant fund reporting elements and summaries of the project activity and status of outputs during the reporting period.  In addition to this narrative reporting section of the \"Workplan and Reporting\" tab, please go to the \"Fiscal Quarterly Reporting\" tab and provide fiscal drawndown information. Quarterly reports are due 30 days after the end of the reporting period.","EPA may use this column to respond to Quarterly Performance Progress Reporting with comments, questions, and/or clarifications.","Provide response to EPA comments, questions, and/or clarifications, where applicable. ","Does EPA approve this workplan element progress to date (yes/no)?  The EPA Project Officer should choose from the dropdown.","Provide 2-3 sentences summarizing the status of each element. If progress is slower than anticipated, please explain why, what barriers were encountered and how these barriers will be overcome. Include an additional 1-2 sentences summarizing outputs and/or outcomes, where applicable. If work for a specific element was not scheduled for this quarter, please type \"N/A\" next to that element.                                                                                                      \nNote: Quarterly performance progress reports are required, including grant fund reporting elements and summaries of the project activity and status of outputs during the reporting period.  In addition to this narrative reporting section of the \"Workplan and Reporting\" tab, please go to the \"Fiscal Quarterly Reporting\" tab and provide fiscal drawndown information. Quarterly reports are due 30 days after the end of the reporting period.","EPA may use this column to respond to Quarterly Performance Progress Reporting with comments, questions, and/or clarifications.","Provide response to EPA comments, questions, and/or clarifications, where applicable. ","Does EPA approve this workplan element progress to date (yes/no)?  The EPA Project Officer should choose from the dropdown.","Provide 2-3 sentences summarizing the status of each element. If progress is slower than anticipated, please explain why, what barriers were encountered and how these barriers will be overcome. Include an additional 1-2 sentences summarizing outputs and/or outcomes, where applicable. If work for a specific element was not scheduled for this quarter, please type \"N/A\" next to that element.                                                                                                      Note: Quarterly performance progress reports are required, including grant fund reporting elements and summaries of the project activity and status of outputs during the reporting period.  In addition to this narrative reporting section of the \"Workplan and Reporting\" tab, please go to the \"Fiscal Quarterly Reporting\" tab and provide fiscal drawndown information. Quarterly reports are due 30 days after the end of the reporting period.","EPA may use this column to respond to Quarterly Performance Progress Reporting with comments, questions, and/or clarifications.","Provide response to EPA comments, questions, and/or clarifications, where applicable. ","Does EPA approve this workplan element progress to date (yes/no)?  The EPA Project Officer should choose from the dropdown."]
[null,"Priority Climate Action Plan (PCAP)",null,null,null,null,null,null,null,null,null,null,"2024-03-01"]
["Element 1.1","GHG Inventory (Required)"]
["Element 1.2","GHG Emissions Projections (Not Required)"]
["Element 1.3","GHG Reduction Targets (Not Required)"]
["Element 1.4","Quantified GHG Reduction Measures  (Required - priority measures only) ",null,null,"Tons of GHGs reduced over the lifetime of the measures identified; Tons of GHGs reduced annually"]
["Element 1.5","Benefits Analysis (Encouraged)",null,null,"Tons of co-pollutants reduced over the lifetime of the measures identified; Tons of co-pollutants reduced annually; Improved ambient air quality; Health benefits achieved; Economic benefits achieved; Increased climate resilience"]
["Element 1.6","Low Income/Disadvantaged Communities Benefits Analysis (Required)",null,"Number of low-income and disadvantaged community members participating in plan development; Meetings, events, stakeholder sessions, etc. with low-income and disadvantaged community members ","Tons of pollution (GHGs and co-pollutants) reduced with respect to low-income and disadvantaged communities; Creation of high-quality jobs with an emphasis on workers from underserved populations "]
["Element 1.7","Review of Authority to Implement (Required) "]
["Element 1.8","Leverage/and Intersection with other Funding (Encouraged)"]
["Element 1.9","Workforce Planning Analysis (Encouraged)",null,null,"Improved staff capacity to implement policies to address climate change; Creation of high-quality jobs"]
["Element 1.10","Stakeholder engagement activities (Required) ",null,"Number of community members participating in plan development; Meetings, events, stakeholder sessions, etc.; and/or, Dissemination of project/technology information via list serves, websites, journals and outreach events.","Enhanced community engagement; Increased public awareness of project and results"]
["Element 1.11","Additional elements determined by grantee (Optional)"]
[null,"Comprehensive Climate Action Plan (CCAP)",null,null,null,null,null,null,null,null,null,null,"2 years from the date of the award (summer-fall 2025)"]
["Element 2.1","GHG Inventory (Required)"]
["Element 2.2","GHG Emissions Projections (Required)"]
["Element 2.3","GHG Reduction Targets (Required)"]
["Element 2.4","Quantified GHG Reduction Measures  (Required - comprehensive) "]
["Element 2.5","Benefits Analysis (Required)"]
["Element 2.6","Low Income/Disadvantaged Communities Benefits Analysis (Required)"]
["Element 2.7","Review of Authority to Implement (Required) "]
["Element 2.8","Leverage/and Intersection with other Funding (Required)"]
["Element 2.9","Workforce Planning Analysis (Required)"]
["Element 2.10","Stakeholder engagement activities (Required) "]
["Element 2.11","Additional elements determined by grantee (Optional)"]
[null,"Status Report",null,null,null,null,null,null,null,null,null,null,"due at the close of the 4-year project period (summer-fall 2027)"]
["Element 3.1","GHG Inventory (Update Encouraged)"]
["Element 3.2","GHG Emissions Projections (Update Encouraged)"]
["Element 3.3","GHG Reduction Targets (Not Required)"]
["Element 3.4","Quantified GHG Reduction Measures  (Status and Updates Required)"]
["Element 3.5","Benefits Analysis (Required)"]
["Element 3.6","Low Income/Disadvantaged Communities Benefits Analysis (Required)"]
["Element 3.7","Review of Authority to Implement (Required) "]
["Element 3.8","Leverage/and Intersection with other Funding (Update Required)"]
["Element 3.9","Workforce Planning Analysis (Required)"]
["Element 3.10","Next Steps/Future Budget/Staffing Needs (Required)"]
["Element 3.11","Stakeholder engagement activities (Required) "]
["Element 3.12","Additional elements determined by grantee (Optional)"]

{"sheet":"Fiscal Quarterly Reporting","index":3,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,18,5,18],[3,18,3,19],[4,19,5,19],[18,0,18,3],[4,1,5,1],[3,8,3,9],[4,8,5,8],[4,9,5,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17],[4,15,5,15],[4,16,5,16],[4,17,5,17],[4,10,5,10],[0,1,0,5],[4,4,5,4],[4,5,5,5],[3,6,3,7],[4,6,5,6],[4,7,5,7],[3,4,3,5],[2,0,2,3],[3,0,5,0],[3,2,3,3],[4,2,5,2],[4,3,5,3],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,14,5,14],[1,3,1,5]]}
["Fiscal Quarterly Reporting","Fiscal Quarterly Reporting"]
[null,null,null," Record and update project funds drawn down quarterly. Previous quarters should remain and updates should only be made for the quarterly report being submitted."]
[]
[null,null,"Project Start Date - September 2023",null,"October-December 2023",null,"January-March 2024",null,"April-June 2024",null,"July-September 2024",null,"October-December 2024",null,"January-March 2025",null,"April-June 2025",null,"July-September 2025"]
[null,"Cumulative","Federal Funds Drawndown by Grantee this Reporting Period","In 1-2 sentences, please descibe what these funds went toward in each budget category. Also include any additional pertinent information, including, when appropriate, analysis and explanation of cost overruns or high-unit costs. ","Federal Funds Drawndown by Grantee this Reporting Period","In 1-2 sentences, please descibe what these funds went toward in each budget category. Also include any additional pertinent information, including, when appropriate, analysis and explanation of cost overruns or high-unit costs. ","Federal Funds Drawndown by Grantee this Reporting Period","In 1-2 sentences, please descibe what these funds went toward in each budget category. Also include any additional pertinent information, including, when appropriate, analysis and explanation of cost overruns or high-unit costs. ","Federal Funds Drawndown by Grantee this Reporting Period","In 1-2 sentences, please descibe what these funds went toward in each budget category. Also include any additional pertinent information, including, when appropriate, analysis and explanation of cost overruns or high-unit costs. ","Federal Funds Drawndown by Grantee this Reporting Period","In 1-2 sentences, please descibe what these funds went toward in each budget category. Also include any additional pertinent information, including, when appropriate, analysis and explanation of cost overruns or high-unit costs. ","Federal Funds Drawndown by Grantee this Reporting Period","In 1-2 sentences, please descibe what these funds went toward in each budget category. Also include any additional pertinent information, including, when appropriate, analysis and explanation of cost overruns or high-unit costs. ","Federal Funds Drawndown by Grantee this Reporting Period","In 1-2 sentences, please descibe what these funds went toward in each budget category. Also include any additional pertinent information, including, when appropriate, analysis and explanation of cost overruns or high-unit costs. ","Federal Funds Drawndown by Grantee this Reporting Period","In 1-2 sentences, please descibe what these funds went toward in each budget category. Also include any additional pertinent information, including, when appropriate, analysis and explanation of cost overruns or high-unit costs. ","Federal Funds Drawndown by Grantee this Reporting Period","In 1-2 sentences, please descibe what these funds went toward in each budget category. Also include any additional pertinent information, including, when appropriate, analysis and explanation of cost overruns or high-unit costs. "]
[]
["Personnel",{"$f":"C7+E7+G7+I7+K7+M7+O7+Q7+S7","v":0},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Travel",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Equipment",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Supplies",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Contractual",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Subawards",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Participant Support Costs (e.g., Rebates)",{"$f":"C14+E14+G14+I14+K14+M14+O14+Q14+S14","v":0},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Other",{"$f":"C15+E15+G15+I15+K15+M15+O15+Q15+S15","v":0},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Direct Cost Total",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Indirect Charges",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["TOTALS",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]

{"sheet":" Sample State Budget ","index":4,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,7,2,7],[0,0,0,6],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,6,2,6]]}
["  Sample State Budget for CPRG Planning Grant ",null,null,null,null,null,null,"Budget Narrative "]
[" "," Year 1  "," Year 2  "," Year 3 "," Year 4  ",null," Total ","For all expenses, please provide a detailed narrative description for each line item. For further descriptions of budget categories, reference the \"Instructions\" tab.   \n\nFor guidance on developing budget narratives, please see:\n• https://www.epa.gov/sites/default/files/2019-05/documents/applicant-budgetdevelopment-guidance.pdf\n• https://www.epa.gov/sites/default/files/2018-05/documents/recipient_guidance_selected_items_of_cost_final.pdf"]
[]
[" Personnel "," "," "," "," ",null," "]
[" 1 FTE Program Manager @ $110,000/yr ",110000,115000,120000,125000,null,470000]
[" 0.5 FTE Outreach Coordinator @ $70,000/yr ",35000,37000,39000,41000,null,152000]
[" 1 FTE Summer Intern @ $2000/month x 3 months "," ",6000,6000,6000,null,18000]
[" 1 FTE Climate Specialist @ $78,000/yr ",78000,81000,84000,87000,null,330000]
["  TOTAL PERSONNEL ",223000,239000,249000,259000," ",970000]
[" Fringe Benefits "," "," "," "," ",null," "]
[" Program Manager @ 20% of salary ",22000,23000,24000,25000,null,94000]
[" Outreach Coordinator @ 22% of salary ",7700,8140,8580,9020,null,33440]
[" Climate Specialist @ 22% of salary ",17160,17820,18480,19140,null,72600]
[" TOTAL FRINGE BENEFITS  ",46860,48960,51060,53160," ",200040]
[" Travel "," "," "," "," ",null," "]
[" Travel for 2 staff to attend Climate Innovation Team Workshops "," "," $             -  "," "," $           -  ",null," $                   -  "]
[" Airfare: 2 @ $600 round trip  ",1200,1200,1200,1200,null,4800]
[" Per Diem: 2 staff X 4 days @ $60/day  ",480,480,480,480,null,1920]
["             Hotel: 2 staff X 3 nights @ $250/night  ",1500,1500,1500,1500,null,6000]
[" Local Mileage "," "," "," "," ",null," $                   -  "]
[" Outreach Coordinator, 100 mi/mo @ $.54/mi x 12 mo  ",648,648,648,648,null,2592]
[" Intern, 50 mi/mo @ $0.54/mi x 3 mo  "," ",81,81,81,null,243]
[" TOTAL TRAVEL ",3828,3909,3909,3909," ",15555]
[" Equipment "," "," "," "," ",null," "]
[null," "," "," "," ",null," "]
[" TOTAL EQUIPMENT "," $             -  "," $            -  "," $            -  "," $           -  "," "," $               -  "]
[" Supplies "," "," "," "," ",null," "]
["  Office and related supplies to support outreach meetings, trainings, etc ",10000,10000,10000,10000,null,40000]
[" TOTAL SUPPLIES ",10000,10000,10000,10000," ",40000]
[" Contractual "," "," "," "," ",null," "]
[" Facilitator for Stakeholder Meetings ",40000,30000,15000,15000,null,100000]
[" Translation Services for Stakeholder Meetings ",10000,7500,4000,3500,null,25000]
[" Energy Modeling ",200000,150000,50000,50000,null,450000]
["  Program Support Contract ",150000,150000,100000,100000,null,500000]
[" TOTAL CONTRACTUAL ",400000,337500,169000,168500," ",1075000]
[" Other "," "," "," "," ",null," "]
[" Postage  ",500,500,500,500,null,2000]
[" Space rental for in-person community workshops,  @ $3000 each ",15000,9000,3000,3000,null,30000]
[" Registration Fees for Training Events ",2400,2000,1000," ",null,5400]
[" Printing and Publication Fees ",4000,5000," $            -  ",3000,null,12000]
[" Subgrant to Administer Municipal Support Program ",150000,200000,150000,150000," ",650000]
[" TOTAL OTHER ",171900,216500,154500,156500," ",699400]
[" Indirect Charges "," "," "," "," ",null," "]
[" Federal Negotiated Indirect Cost Rate = 0%  "," $          -  "," $         -  "," $         -  "," $        -  ",null," $                   -  "]
[" (Indirect Rate x Personnel = Indirect Costs) "," "," "," "," "," "," $                   -  "]
[" TOTAL INDIRECT "," $             -  "," $            -  "," $            -  "," $           -  "," "," $               -  "]
[" TOTAL FUNDING ",855588,855869,637469,651069," ",2999995]
[" "," "," "," "," "]

{"sheet":"Incomplete - Comment Log table","index":5,"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":6,"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":"Sample MSA Budget","index":7,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,7,2,7],[0,0,0,6],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,6,2,6]]}
["  Sample Budget for MSA (Metro Area) CPRG Planning Grant ",null,null,null,null,null,null,"Budget Narrative "]
[" "," Year 1  "," Year 2  "," Year 3 "," Year 4  ",null," Total ","For all expenses, please provide a detailed narrative description for each line item. For further descriptions of budget categories, reference the \"Instructions\" tab.   \n\nFor guidance on developing budget narratives, please see:\n• https://www.epa.gov/sites/default/files/2019-05/documents/applicant-budgetdevelopment-guidance.pdf\n• https://www.epa.gov/sites/default/files/2018-05/documents/recipient_guidance_selected_items_of_cost_final.pdf"]
[]
[" Personnel "," "," "," "," ",null," "]
[" 1 FTE Program Manager @ $95,000/yr ",95000,97000,99000,101000,null,392000]
[" 0.5 FTE Outreach Coordinator @ $60,000/yr ",30000,32000,35000,38000,null,135000]
["  TOTAL PERSONNEL ",125000,129000,134000,139000," ",527000]
[" Fringe Benefits "," "," "," "," ",null," "]
[" Program Manager @ 20% of salary ",19000,19400,19800,20200,null,78400]
[" Outreach Coordinator @ 21% of salary ",6300,6720,7350,7980,null,28350]
[" TOTAL FRINGE BENEFITS  ",25300,26120,27150,28180," ",106750]
[" Travel "," "," "," "," ",null," "]
[" Travel for 1 staff to attend Climate Innovation Team Training Workhop "," "," $             -  "," "," $           -  ",null," $                   -  "]
[" Airfare: 1 @ $600 round trip  ",600,600,600,600,null,2400]
[" Per Diem: 1 staff X 4 days @ $60/day  ",240,240,240,240,null,960]
["             Hotel: 1 staff X 3 nights @ $250/night  ",750,750,750,750,null,3000]
[" Local Mileage "," "," "," "," ",null," $                   -  "]
[" Outreach Coordinator, 100 mi/mo @ $.54/mi x 12 mo  ",648,648,648,648,null,2592]
[" TOTAL TRAVEL ",2238,2238,2238,2238," ",8952]
[" Equipment "," "," "," "," ",null," "]
[" "," "," "," "," ",null," "]
[" TOTAL EQUIPMENT "," $             -  "," $            -  "," $            -  "," $           -  "," "," $               -  "]
[" Supplies "," "," "," "," ",null," "]
["  Office and related supplies to support outreach meetings, trainings, etc ",3000,3000,3000,3000,null,12000]
[" TOTAL SUPPLIES ",3000,3000,3000,3000," ",12000]
[" Contractual "," "," "," "," ",null," "]
[" Facilitation and Translation Services for Stakeholder Meetings ",20000,10000,5000,5000,null,40000]
[" Analytical and Modeling Services ",40000,40000," ",20000,null,100000]
[" TOTAL CONTRACTUAL ",60000,50000,5000,25000," ",140000]
[" Other "," "," "," "," ",null," "]
[" Subgrant to Support Regional Planning ",70000,70000,35000,30000," ",205000]
[" TOTAL OTHER ",70000,70000,35000,30000," ",205000]
[" Indirect Charges "," "," "," "," ",null," "]
[" Federal Negotiated Indirect Cost Rate = 0%  "," $          -  "," $         -  "," $         -  "," $        -  ",null," $                   -  "]
[" (Indirect Rate x Personnel = Indirect Costs) "," "," "," "," "," "," $                   -  "]
[" TOTAL INDIRECT "," $             -  "," $            -  "," $            -  "," $           -  "," "," $               -  "]
[" TOTAL FUNDING ",285538,280358,206388,227418," ",999702]
[" "," "," "," "," "]

{"sheet":"Sample State or MSA Timeline","index":8,"n_rows":33,"n_cols":50,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,12],[1,2,1,4],[3,0,3,1],[10,0,10,1],[18,0,18,1]]}
[null," Sample State or MSA Climate Planning Timeline and Milestones"]
[" ","ACTIVITY","Months",null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48]
["Ongoing Processes and Meetings",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Develop Quality Assurance Plan"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Interagency Meetings"," "," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Stakeholder Meetings"," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Meetings with Municipal Partners"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Quarterly Reports"," "," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["Priority Climate Action Plan",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Inventory/Analysis"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Measure Selection"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Quantification of GHG and LIDAC Benefits"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Review of Authority"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Leveraging Funding Opportunities and Workforce Analysis"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Publish PCAP"," "," "," "," "," "," "," ","*"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["Comprehensive Climate Action Plan",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Inventory and Projections"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Target Setting"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Measure Selection and Quantification"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Benefits and LI-DC Benefits Analyses"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Review of Authority and Funding Opportunities"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Workforce Analysis and Strategy "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Publish CCAP"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ","*"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["Status Report and Ongoing Activities"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Update Emissions Analyses"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Update Workforce Analysis"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Assess Implementation Status"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Develop Next Steps and Status Report"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Publish Status Report"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ","*"]