{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Workplan Narrative","Workplan and Reporting","Fiscal Quarterly Reporting","Sample Tribe-Territory Budget ","Incomplete - Comment Log table","Standardized Terms","Sample Tribe-Territory Timeline"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":5,"n_cols":1,"rows_kept":5,"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 Tribe and Territory 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 Tribe and Territory 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 Tribe and Territory Sample Grant Workplan and Reporting Tool. \n\n\n\n\n"]
["Part 2: Tribe and Territory Sample Grant Workplan and Reporting Tool\nThe sample workplan tool spreadsheet entitled Tribe and Territory 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 Tribe and Territory 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 Tribe and Territory Sample Grant Workplan and Reporting Tool also includes Sample Tribe-Territory Budget worksheet which illustrates 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 the worksheet 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"]
["Additional 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 Tribe and Territory Sample Grant Workplan and Reporting Tool also includes a Sample Tribe-Territory 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.\n\nPart 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 Tribal Lands or a Territory","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, partnering tribes, neighboring state agencies/offices, neighboring municipalities, advisory committees, subawardees (such as non-profit organizations), or contractors (if known). 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. ","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 and CCAP. 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","Lead organizations should coordinate with other appropriate agencies and offices within their own government in the development and adoption of the planning deliverables. For example, climate planning efforts should involve agencies with responsibilities in different program areas, including environmental protection, energy, utilities, transportation, housing, waste management, and land use planning. \n\nPCAP:  Describe how the lead organization intends to collaborate with coordinating entities and other appropriate agencies and offices within their own government in the development and adoption of the PCAP. As applicable, the applicant may 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\nCCAP: Explain how the lead organization will involve stakeholder groups and the public in the PCAP development process, including the approach to conducting meaningful engagement within their communities. \n\nClimate plans for tribes represented by a tribal partnership or tribal consortium should be developed in close coordination with the member tribes, and workplans should describe the existing or planned roles and relationships of the partnering tribes and the process for developing work products.","Potential stakeholders include the tribal community itself as well as other nearby community groups, governmental entities, Port Authorities, labor organizations, private sector and industry representatives as applicable. Describe how public and stakeholder engagement would be conducted (such as\nthrough a combination of in-person and/or virtual meetings with reasonable opportunities to provide input on preliminary products); and, Discuss how information on the PCAP and CCAP development processes will be made available to the public in a transparent manner, such as through in-person and virtual meetings, public websites, listservs, and social media. \n\nPCAP:  Explain how the lead organization will involve stakeholder groups and the public in the PCAP development process. \n\nCCAP: Describe how the lead organization and coordinating entities intend to conduct meaningful engagement with affected communities in the development of the CCAP. At a minimum, the workplan should describe the method for identifying interested and/or affected stakeholders, 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.","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":26,"n_cols":51,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["DRAFT IRA CPRG Tribe and Territory Sample Grant Workplan and Reporting Tool"]
["Most Recent EPA Approved Grant Application Workplan Date: MM/DD/YYYY"]
["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.                                                                                                      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.                                                                                                      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.                                                                                                      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."]
[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 (Required)",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.7","Review of Authority to Implement (Required) "]
["Element 1.8","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,"due at the end of the grant period, up to 4 years"]
["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.7","Review of Authority to Implement (Required) "]
["Element 2.8","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)"]

{"sheet":"Fiscal Quarterly Reporting","index":3,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,15,5,15],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[0,1,0,5],[1,3,1,5],[2,0,2,3],[3,0,5,0],[3,2,3,3],[3,4,3,5],[3,18,3,19],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,16,5,16],[4,17,5,17],[4,18,5,18],[4,19,5,19],[4,14,5,14],[3,16,3,17],[4,9,5,9],[18,0,18,3],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13]]}
["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)",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Other",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 Tribe-Territory Budget ","index":4,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,6,2,6],[0,0,0,5],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
["Sample Budget for Tribe or Territory CPRG Planning Grant",null,null,null,null,null,"Budget Narrative "]
[null,"Year 1 ","Year 2 ","Year 3","Year 4 ","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"]
["1 FTE Program Manager @ $80,000/yr",80000,82000,84000,86000,332000]
[" TOTAL PERSONNEL",80000,82000,84000,86000,332000]
["Fringe Benefits"]
["Program Manager @ 18% of salary",14400,14760,15120,15480,59760]
["TOTAL FRINGE BENEFITS ",14400,14760,15120,15480,59760]
["Travel"]
["Travel for 1 staff to attend Climate Innovation Team Training Workhop",null,"$-   ",null," $-   "," $-   "]
["Hotel: 1 staff x 3 nights x $200",600,600,600,600,2400]
["Airfare: 1 @ $500 round trip ",500,500,500,500,2000]
["Per Diem: 1 staff X 4 days @ $60/day ",240,240,240,240,960]
["TOTAL TRAVEL",1340,1340,1340,1340,5360]
["Equipment"]
[]
["TOTAL EQUIPMENT","$-   "," $-   "," $-   "," $-   "," $-   "]
["Supplies"]
["Office and related supplies to support outreach meetings, trainings, etc",1000,1000,1000,null,3000]
["TOTAL SUPPLIES",1000,1000,1000," $-   ",3000]
["Contractual"]
["Facilitation and Translation Services for Stakeholder Meetings",5000,5000,5000,null,15000]
["Analytical and Modeling Services",10000,null,9000,9000,28000]
["TOTAL CONTRACTUAL",15000,5000,14000,9000,43000]
["Other"]
[null,null,null,null,null,"$-   "]
["TOTAL OTHER","$-   "," $-   "," $-   "," $-   "," $-   "]
["Indirect Charges"]
["Federal Negotiated Indirect Cost Rate = 17% ",13600,13940,14280,14620,56440]
["(Indirect Rate x Personnel = Indirect Costs)",null,null,null,null,"$-   "]
["TOTAL INDIRECT",13600,13940,14280,14620,56440]
["TOTAL FUNDING",125340,118040,129740,126440,499560]

{"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 Tribe-Territory Timeline","index":7,"n_rows":25,"n_cols":50,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,2,1,4],[3,0,3,1],[0,1,0,20],[9,0,9,1],[16,0,16,1]]}
[null," Sample Tribal/Territory 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," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Quarterly Reports"," "," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," ","*"," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["Priority Climate Action Plan",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Inventory/Analysis"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Measure Selection"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Quantification of GHG and Benefits"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Review of Authority"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Publish PCAP"," "," "," "," "," "," "," ","*"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["Comprehensive Climate Action Plan",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Inventory and Projections"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Reduction Target Setting"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","GHG Measure Selection and Quantification"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Benefits Analysis"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Review of Authority and Funding Opportunities"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Workforce Analysis and Strategy "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[" ","Publish CCAP"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ","*"]
[" "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]