{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Certification","Cover","EC 1 - Public Health","EC 2 - Negative Economic Impact","EC 3 - Public Sector Capacity","EC 4 - Premium Pay","EC 5 - Infrastructure","EC 7 - Admin","Subrecipient","Awards > 50000","Expenditures > 50000","Aggregate Awards < 50000","Summary","Dropdowns","EC6.1 Provision of Gov Services","ARPA Projects Requiring Reports","Logic"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":12,"comments":12,"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":"Certification","index":0,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Certification","Agency Financial Reviewer Name","Date"]
["By signing this report, I certify to the best of my knowledge and belief that the report is true, complete, and accurate, and the expenditures, disbursements and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award. I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise. (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812). (2 CFR 200.415)"]

{"sheet":"Cover","index":1,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Agency Code","Upload ID","Expenditure Category Group","Detailed Expenditure Category","Reporting Period Start Date","Reporting Period End Date","SFRF Project Line Sequence(s)","Natural Account"]
[null,null,"[Enter Detailed Expenditure Category] -->"]
[null,null,null,null,null,null,"Separate multiples by comma if applicable","Separate multiples by comma if applicable"]

{"sheet":"EC 1 - Public Health","index":2,"n_rows":13,"n_cols":47,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Expenditure category info:","Unused","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","EC 1.4, 1.11, 1.12, 1.13","EC 1.4, 1.11, 1.12, 1.13","EC 1.8","EC 1.9","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1","ALL EC1",1.1100000000000001,1.1100000000000001,1.1100000000000001]
["treasury template reference",null,"projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads","project18_229233BulkUploads","project19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads","projectBaselineBulkUpload (unless 1.8-1.9)\nproject18_229233BulkUploads\nproject19_234BulkUploads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload"]
["Treasury Column Title (Field ID)",null,"Name","Project_Identification_Number__c","Completion_Status__c","Adopted_Budget__c","Total_Obligations__c","Total_Expenditures__c","Current_Period_Obligations__c","Current_Period_Expenditures__c","Project_Description__c","Program_Income_Earned__c","Program_Income_Expended__c","Primary_Project_Demographics__c","Primary_Project_Demographics_Explanation__c","Secondary_Project_Demographics__c","Secondary_Proj_Demographics_Explanation__c","Tertiary_Project_Demographics__c","Tertiary_Proj_Demographics_Explanation__c","Structure_Objectives_of_Asst_Programs__c","Recipient_Approach_Description__c","Spending_Allocated_Toward_Evidence_Based_Interventions","Whether_program_evaluation_is_being_conducted","Small_Businesses_Served__c","Number_Non_Profits_Served__c","Does_Project_Include_Capital_Expenditure__c","Total_Cost_Capital_Expenditure__c","Type_of_Capital_Expenditure__c","Type_of_Capital_Expenditure_Other__c","Capital_Expenditure_Justification__c","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","Workers_Enrolled_in_Sectoral_Job_Training_Programs_c","Workers_Completing_Sectoral_Job_Training_Programs_c","People_Participating_in_Summer_Youth_Employment_Programs_c"]
["Required/Optional?",null,"Required","Required","Required","Required","Required","Required","Required","Required","Required","Optional","Optional","Required","Conditional","Optional","Conditional","Optional","Conditional","Required","Required","Required","Required","Required","Required","Required","Conditional","Conditional","Conditional","Conditional","Required if Budget > $10M","Required if DB is No","Required if DB is No","Required if DB is No","Required if DB is No","Required if Budget > $10M","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if Budget > $10M","Required if Budget > $10M","Required if Budget > $10M","Required","Required","Required"]
["Field definition (expected contents)",null,"Enter Project Name (Text - max Characters 80)","Identification number assigned to project by recipient. DO NOT USE Duplicate Project Numbers, system updates record on duplicate project ID.",null,"The amount of the adopted budget  for this project. Currency field with max 12 characters, 2 decimals. \nDO NOT include a \"$\" sign or commas \",\" when entering Amounts. ","The total dollar value of obligations for this project.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The total dollar value of expenditures for this project.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The dollar value of obligations for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The dollar value of expenditures for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","Enter Project Description (Text - max characters 1,500)","Enter the amount of Federal program income earned.","Enter the amount of program income that was used to cover eligible project costs.","What Impacted and/or Disproportionally Impacted population does this project primarily serve? Please select the population primarily served. \n\nNote: Populate this field with one of the below predefined responses. Cut and paste the exact verbiage, and do not include the quotation marks (\" \").\n\n\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","If the selected demographic includes 'specify' please provide a brief explanation\n\n(Text - max 250 characters)","What Impacted and/or Disproportionally Impacted population does this project primarily serve? Please select the population primarily served. \n\nNote: Populate this field with one of the below predefined responses. Cut and paste the exact verbiage, and do not include the quotation marks (\" \").\n\n\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","If the selected demographic includes 'specify' please provide a brief explanation\n\n(Text - max 250 characters)","What Impacted and/or Disproportionally Impacted population does this project primarily serve? Please select the population primarily served. \n\nNote: Populate this field with one of the below predefined responses. Cut and paste the exact verbiage, and do not include the quotation marks (\" \").\n\n\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","If the selected demographic includes 'specify' please provide a brief explanation\n\n(Text - max 250 characters)","Brief description of structure and objectives of assistance program(s), including public health or negative economic impact experienced \n\n(Text - max 250 characters)","Brief description of recipients approach to ensuring that response is reasonable and proportional to a public health or negative economic impact of Covid-19, as described in the final rule \n\n(Text - max 250 characters)","The dollar amount of the total project spending that is allocated toward evidence-based interventions","Whether a program evaluation of the project is being conducted","Number of small businesses served (by program if recipient establishes multiple separate small businesses assistance programs)\n\n(Numeric value - max 10 characters)","Number of Non-Profits served (by program if recipient establishes multiple separate non-profit assistance programs)\n\n(Numeric value - max 10 characters)","If this project includes a capital expenditure, select one of the valid predefined responses from the picklist:\n\"Yes\"\n\"No\"","If you answered \"Yes\" to the previous question, enter the total dollar value of the expected capital expenditure. ","If you answered \"Yes\" for the \"Does this project include a capital expenditure\" question, then you are required to select one of the valid predefined responses from the picklist.\n\nThe below picklist values are abbreviated. Please reference the User Guide for the the comprehensive list of acceptable picklist values. \n\n\"Acquisition of equipment for COVID-19 prevention and treatment\"\n\"Adaptations to congregate living facilities\"\n\"Affordable housing, supportive housing, or recovery housing\"\n\"Behavioral health facilities and equipment\"\n\"Childcare, daycare and early learning facilities\"\n\"COVID-19 testing sites and laboratories, and acquisition of related equipment\"\n\"COVID-19 vaccination sites\"\n\"Devices and equipment that assist households in accessing the internet\"\n\"Emergency operations centers and acquisition of emergency response equipment\"\n\"Food banks and other facilities\"\n\"Improvements to existing facilities\"\n\"Installation and improvement of ventilation systems\"\n\"Job and workforce training centers\"\n\"Medical equipment and facilities\"\n\"Medical facilities generally dedicated to COVID-19 treatment and mitigation\"\n\"Mitigation measures in small businesses, nonprofits and impacted industries\"\n\"Parks, green spaces, recreational facilities, sidewalks\"\n\"Public health data systems\"\n\"Rehabilitations, renovation, remediation, cleanup, or conversions\"\n\"Schools and other educational facilities\"\n\"Technology and equipment to allow law enforcement\"\n\"Technology and tools\"\n\"Technology infrastructure to adapt government operations\"\n\"Temporary medical facilities and other measures\"\n\"Transitional shelters\"\n\"Other (please specify)\"","If you selected \"Other (please specify)\" for the Capital Expenditure Type, please provide more details.\n\n(Text - max character 255)","For recipients (other than Tribal governments) investing in projects with total expected capital expenditures for an enumerated eligible use of $10 million or more, as well as projects with total expected capital expenditures for an \"other\" use of $1 million or more, please provide a written justification.\n\n(Text - max character 1500)",null,"the number of employees of contractors and sub-contractors working on the project; ","The number of employees on the project hired directly and hired through a third party;"," The wages and benefits of workers on the project by classification","Whether those wages are at rates less than those prevailing",null,"How the recipient will ensure the project has ready access to a sufficient supply of appropriately skilled and unskilled labor to ensure high-quality construction throughout the life of the project, including a description of any required professional certifications and/or in-house training;","How the recipient will minimize risks of labor disputes and disruptions that would jeopardize timeliness and cost-effectiveness of the project; ","How the recipient will provide a safe and healthy workplace that avoids delays and costs associated with workplace illnesses, injuries, and fatalities, including descriptions of safety training, certification, and/or licensure requirements for all relevant workers (e.g., OSHA 10, OSHA 30);  ","Whether workers on the project will receive wages and benefits that will secure an appropriately skilled workforce in the context of the local or regional labor market","Whether the project has completed a project labor agreement. ",null,null,null,"Number of workers enrolled in sectoral job training programs","Number of workers completing sectoral job training programs ","Number of people participating in summer youth employment programs"]
["List Values",null,"N/A","N/A","Not started\nCompleted less than 50%\nCompleted 50% or more\nCompleted","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","N/A","\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","N/A","\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","N/A","N/A","N/A","N/A","\"Yes\"\n\"No\"","N/A","N/A","Yes\nNo","N/A","\"Acquisition of equipment for COVID-19 prevention and treatment\"\n\"Adaptations to congregate living facilities\"\n\"Affordable housing, supportive housing, or recovery housing\"\n\"Behavioral health facilities and equipment\"\n\"Childcare, daycare and early learning facilities\"\n\"COVID-19 testing sites and laboratories, and acquisition of related equipment\"\n\"COVID-19 vaccination sites\"\n\"Devices and equipment that assist households in accessing the internet\"\n\"Emergency operations centers and acquisition of emergency response equipment\"\n\"Food banks and other facilities\"\n\"Improvements to existing facilities\"\n\"Installation and improvement of ventilation systems\"\n\"Job and workforce training centers\"\n\"Medical equipment and facilities\"\n\"Medical facilities generally dedicated to COVID-19 treatment and mitigation\"\n\"Mitigation measures in small businesses, nonprofits and impacted industries\"\n\"Parks, green spaces, recreational facilities, sidewalks\"\n\"Public health data systems\"\n\"Rehabilitations, renovation, remediation, cleanup, or conversions\"\n\"Schools and other educational facilities\"\n\"Technology and equipment to allow law enforcement\"\n\"Technology and tools\"\n\"Technology infrastructure to adapt government operations\"\n\"Temporary medical facilities and other measures\"\n\"Transitional shelters\"\n\"Other (please specify)\"","N/A","N/A","Yes\nNo","TBD","TBD","TBD","TBD","Yes\nNo","TBD","TBD","TBD","TBD","TBD","Yes\nNo","Yes\nNo","TBD","N/A","N/A","N/A"]
["Data Type ",null,"String","String","Pick List","Currency","Currency","Currency","Currency","Currency","String","Currency","Currency","Pick List","String","Pick List","String","Pick List","String","String","String","Currency","Picklist","Numeric","String","Pick List","Currency","Pick List","String","String","Pick List","TBD","TBD","TBD","TBD","Pick List","TBD","TBD","TBD","TBD","TBD","Pick List","Pick List","TBD","Numeric","Numeric","Numeric"]
["Max Length",null,80,20,"N/A","12,2","12,2","12,2","12,2","12,2",1500,"12,2","12,2","N/A",250,"N/A",250,"N/A",250,250,250,"12,2","N/A",10,10,"N/A","12,2","N/A",255,1500,"N/A","TBD","TBD","TBD","TBD","N/A","TBD","TBD","TBD","TBD","TBD","N/A","N/A","TBD",10,10,10]
["Suggested validations",null,null,null,null,null,null,null,"will equal total for this project ID from the expenditure and aggregate tabs","will equal total for this project ID from the expenditure and aggregate tabs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"conditional formatting based on Column Z","conditional formatting based on Column Z","conditional formatting based on Column AB","conditional formatting based on Column AA and Z","Conditional based on Column AA","Conditional Based on column AE","Conditional Based on column AE","Conditional Based on column AE","Conditional Based on column AE","Conditional based on Column AA","Conditional Based on column AJ","Conditional Based on column AJ","Conditional Based on column AJ","Conditional Based on column AJ","Conditional Based on column AJ","Conditional based on Column AA","Conditional based on Column AA","Conditional based on Column AQ"]
["Partner Guidance",null,"Name of the project.","Identification number assigned to project by recipient.","Completion status of the project.","Amount of the adopted budget for this project. This includes single audit fees, and should correspond to what is listed in the Reporting & Compliance form.","Total dollar value of obligations for this project. Per UST guidance and the CFR, obligations \"when referencing a recipient's or subrecipient's use of funds under a Federal award\" means \"orders placed for property and services, contracts and subawards made, and similar transactions that require payment.\"). (Part 200 CFR) Single audit fees and other direct pay items, both obligated and expended, qualify.","Total dollar value of expenditures for this project.\nTCE should be equal to the sum of cumulative expenditures from RIFANS across the entirety of the project. We have provided a tab with expenditures from RIFANS corresponding to the entire project period. ","Total dollar value of obligations for this current reporting period. \nThis number should comprise all Current Period Expenditures plus any obligations made and not yet paid in this current reporting period. For a definition of obligations, refer to the helptext under 'Total Cumulative Obligations'.","Total dollar value of expenditures for this current reporting period.\nThis number should be equal to the sum of cumulative expenditures from RIFANS filtered (using col 'Physical Posted Date') to only those expenditures made on or after the start of this reporting period, and on or before the end of this reporting period.","Provide a description for the project between 50 to 250 words. Each project description should be 3-5 sentences with an overview of the project, which includes a description of the project’s purpose, the population being served, the desired outcome from the project, and how this outcome is being measured (along with any current data on progress towards the desired outcome).","The amount of Federal program income earned.","The amount of program income that was used to cover eligible project costs."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Column Label",null,"Project Name","Project Identification Number\n(Assigned by recipient)","Status of Completion","Adopted Budget","Total Cumulative \nObligations","Total Cumulative \nExpenditures","Current Period Obligations","Current Period Expenditures","Project Description","Program Income Earned","Program Income Expended","Project Demographic Distribution - Primary Populations Served","Primary Project Demographic Explanation","Project Demographic Distribution - Additional Populations Served","Secondary Project Demographic Explanation","Project Demographic Distribution - Additional Populations Served","Tertiary Project Demographic Explanation","Structure and objectives of assistance program","Recipients approach","Identify the dollar amount of the total project spending that is allocated towards evidence-based interventions","Is a program evaluation of the project being conducted?","Number of Small Businesses Served ","Non-Profits Served","Does this project include a capital expenditure?","If yes, what is the total expected capital expenditure?","Capital Expenditure Type","Other Capital Expenditure Explanation","Capital Expenditure Narrative","If budget is over $10M, was a Davis Bacon Act Certification completed?","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the number of employees of contractors and sub-contractors working on the project.","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the number of employees on the project hired directly and hired through a third party. ","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the wages and benefits of workers on the project by classification","If budget is over $10M and Davis Bacon Act Certification NOT completed - are those wages are at rates less than those prevailing?","If budget is over $10M, was a Labor Agreement Certification completed?","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will ensure the project has ready access to a sufficient supply of appropriately skilled and unskilled labor to ensure high-quality construction throughout the life of the project, including a description of any required professional certifications and/or in-house training. ","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will minimize risks of labor disputes and disruptions that would jeopardize timeliness and cost-effectiveness of the project.","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will provide a safe and healthy workplace that avoids delays and costs associated with workplace illnesses, injuries, and fatalities, including descriptions of safety training, certification, and/or licensure requirements for all relevant workers (e.g., OSHA 10, OSHA 30).","If budget is over $10M and Labor Agreement Certification NOT completed - enter whether workers on the project will receive wages and benefits that will secure an appropriately skilled workforce in the context of the local or regional labor market.","If budget is over $10M and Labor Agreement Certification NOT completed - enter whether the project has completed a project labor agreement. ","If budget is over $10M, does the project prioritize local hires? ","If budget is over $10M, does the project have a Community Benefit Agreement?","If budget is over $10M and has a Community Benefit Agreement, provide a description. ","Number of workers enrolled in sectoral job training programs","Number of workers completing sectoral job training programs ","Number of people participating in summer youth employment programs"]
["Users will complete these fields, may do multiple rows "]

{"sheet":"EC 2 - Negative Economic Impact","index":3,"n_rows":13,"n_cols":55,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Expenditure category info:","Unused","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","EC 2.1-2.8","EC 2.1-2.4, 2.6, 2.7, 2.9-2.20, 2.25, 2.26, 2.30, 2.32, 2.33, 2.37","EC 2.1-2.4, 2.6, 2.7, 2.9-2.20, 2.25, 2.26, 2.30, 2.32, 2.33, 2.37","EC 2.29-2.33","EC 2.34","EC 2.14, 2.24-2.27","EC 2.36","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2","ALL EC2",2.1,2.1,2.1,"EC2.2, 2.15-16, 2.17-18","EC2.2, 2.15-16, 2.17-18","2.24-26, 2.27","2.11-14","2.11-14"]
["treasury template reference",null,"projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","project2128BulkUploads","hhn","projectBaselineBulkUpload, project2128BulkUploads, project214_224227BulkUploads, project18_229233BulkUploads","project18_229233BulkUploads","project19_234BulkUploads","project214_224227BulkUploads","\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads","projectBaselineBulkUpload\nproject2128BulkUploads\nproject214_224227BulkUploads\nproject18_229233BulkUploads\nproject19_234BulkUploads\nproject236BulkUploads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","project214_224227BulkUploads","project214_224227BulkUploads\nprojectBaselineBulkUpload","project214_224227BulkUploads\nprojectBaselineBulkUpload"]
["Treasury Column Title (Field ID)",null,"Name","Project_Identification_Number__c","Completion_Status__c","Adopted_Budget__c","Total_Obligations__c","Total_Expenditures__c","Current_Period_Obligations__c","Current_Period_Expenditures__c","Project_Description__c","Program_Income_Earned__c","Program_Income_Expended__c","Primary_Project_Demographics__c","Primary_Project_Demographics_Explanation__c","Secondary_Project_Demographics__c","Secondary_Proj_Demographics_Explanation__c","Tertiary_Project_Demographics__c","Tertiary_Proj_Demographics_Explanation__c","Structure_Objectives_of_Asst_Programs__c","Recipient_Approach_Description__c","Individuals_Served__c","Spending_Allocated_Toward_Evidence_Based_Interventions","Whether_program_evaluation_is_being_conducted","Small_Businesses_Served__c","Number_Non_Profits_Served__c","School_ID_or_District_ID__c","Industry_Experienced_8_Percent_Loss__c","Does_Project_Include_Capital_Expenditure__c","Total_Cost_Capital_Expenditure__c","Type_of_Capital_Expenditure__c","Type_of_Capital_Expenditure_Other__c","Capital_Expenditure_Justification__c","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","Workers_Enrolled_in_Sectoral_Job_Training_Programs_c","Workers_Completing_Sectoral_Job_Training_Programs_c","People_Participating_in_Summer_Youth_Employment_Programs_c","Households_Receiving_Eviction_Prevention_Services_c","Affordable_Housing_Units_Preserved_or_Developed_c","Students_Participating_in_Evidence_Based_Tutoring_Programs_c","Children_Served_by_Childcare_and_Early_Learning_Services_c","Families_Served_by_Home_Visiting_c"]
["Required/Optional?",null,"Required","Required","Required","Required","Required","Required","Required","Required","Required","Optional","Optional","Required","Conditional","Optional","Conditional","Optional","Conditional","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Conditional","Conditional","Conditional","Conditional","Required if Budget > $10M","Required if DB is No","Required if DB is No","Required if DB is No","Required if DB is No","Required if Budget > $10M","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if Budget > $10M","Required if Budget > $10M","Required if Budget > $10M","Required","Required","Required","Required","Required","Required","Required","Required"]
["Field definition (expected contents)",null,"b","Identification number assigned to project by recipient. DO NOT USE Duplicate Project Numbers, system updates record on duplicate project ID.",null,"The amount of the adopted budget  for this project. ","The total dollar value of obligations for this project.  ","The total dollar value of expenditures for this project. ","The dollar value of obligations for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The dollar value of expenditures for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","Enter Project Description (Text - max characters 1,500)","Enter the amount of Federal program income earned.","Enter the amount of program income that was used to cover eligible project costs.","What Impacted and/or Disproportionally Impacted population does this project primarily serve? Please select the population primarily served. \n\nNote: Populate this field with one of the below predefined responses. Cut and paste the exact verbiage, and do not include the quotation marks (\" \").\n\n\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","If the selected demographic includes 'specify' please provide a brief explanation\n\n(Text - max 250 characters)","What Impacted and/or Disproportionally Impacted population does this project primarily serve? Please select the population primarily served. \n\nNote: Populate this field with one of the below predefined responses. Cut and paste the exact verbiage, and do not include the quotation marks (\" \").\n\n\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","If the selected demographic includes 'specify' please provide a brief explanation\n\n(Text - max 250 characters)","What Impacted and/or Disproportionally Impacted population does this project primarily serve? Please select the population primarily served. \n\nNote: Populate this field with one of the below predefined responses. Cut and paste the exact verbiage, and do not include the quotation marks (\" \").\n\n\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","If the selected demographic includes 'specify' please provide a brief explanation\n\n(Text - max 250 characters)","Brief description of structure and objectives of assistance program(s), including public health or negative economic impact experienced \n\n(Text - max 250 characters)","Brief description of recipients approach to ensuring that response is reasonable and proportional to a public health or negative economic impact of Covid-19, as described in the final rule \n\n(Text - max 250 characters)","Number of households served (by program if recipient establishes multiple separate\nhousehold assistance programs) ","The dollar amount of the total project spending that is allocated toward evidence-based interventions","Whether a program evaluation of the project is being conducted","Number of small businesses served (by program if recipient establishes multiple separate small businesses assistance programs)\n\n(Numeric value - max 10 characters)","Number of Non-Profits served (by program if recipient establishes multiple separate non-profit assistance programs)\n\n(Numeric value - max 10 characters)","The National Center for Education Statistics (\"NCES\") School ID or NCES District\nID.  Separate IDs with comma's for multiple entries.\n\nExample - 10002, 10005,10010, etc","If aid is provided to industries other than travel, tourism, and hospitality (EC 2.36), please describe if the industry experienced at least 8 percent employment loss from pre-pandemic levels, or the industry is experiencing comparable or worse economic impacts as the national tourism, travel, and hospitality industries as of the date of the Final Rule, and rationale for providing aide to the industry\n\n(Text - max 250 characters)","If this project includes a capital expenditure, select one of the valid predefined responses from the picklist:\n\"Yes\"\n\"No\"","If you answered \"Yes\" to the previous question, enter the total dollar value of the expected capital expenditure. ","If you answered \"Yes\" for the \"Does this project include a capital expenditure\" question, then you are required to select one of the valid predefined responses from the picklist.\n\nThe below picklist values are abbreviated. Please reference the User Guide for the the comprehensive list of acceptable picklist values. \n\n\"Acquisition of equipment for COVID-19 prevention and treatment\"\n\"Adaptations to congregate living facilities\"\n\"Affordable housing, supportive housing, or recovery housing\"\n\"Behavioral health facilities and equipment\"\n\"Childcare, daycare and early learning facilities\"\n\"COVID-19 testing sites and laboratories, and acquisition of related equipment\"\n\"COVID-19 vaccination sites\"\n\"Devices and equipment that assist households in accessing the internet\"\n\"Emergency operations centers and acquisition of emergency response equipment\"\n\"Food banks and other facilities\"\n\"Improvements to existing facilities\"\n\"Installation and improvement of ventilation systems\"\n\"Job and workforce training centers\"\n\"Medical equipment and facilities\"\n\"Medical facilities generally dedicated to COVID-19 treatment and mitigation\"\n\"Mitigation measures in small businesses, nonprofits and impacted industries\"\n\"Parks, green spaces, recreational facilities, sidewalks\"\n\"Public health data systems\"\n\"Rehabilitations, renovation, remediation, cleanup, or conversions\"\n\"Schools and other educational facilities\"\n\"Technology and equipment to allow law enforcement\"\n\"Technology and tools\"\n\"Technology infrastructure to adapt government operations\"\n\"Temporary medical facilities and other measures\"\n\"Transitional shelters\"\n\"Other (please specify)\"","If you selected \"Other (please specify)\" for the Capital Expenditure Type, please provide more details.\n\n(Text - max character 255)","For recipients (other than Tribal governments) investing in projects with total expected capital expenditures for an enumerated eligible use of $10 million or more, as well as projects with total expected capital expenditures for an \"other\" use of $1 million or more, please provide a written justification.\n\n(Text - max character 1500)",null,"the number of employees of contractors and sub-contractors working on the project; ","The number of employees on the project hired directly and hired through a third party;"," The wages and benefits of workers on the project by classification","Whether those wages are at rates less than those prevailing",null,"How the recipient will ensure the project has ready access to a sufficient supply of appropriately skilled and unskilled labor to ensure high-quality construction throughout the life of the project, including a description of any required professional certifications and/or in-house training;","How the recipient will minimize risks of labor disputes and disruptions that would jeopardize timeliness and cost-effectiveness of the project; ","How the recipient will provide a safe and healthy workplace that avoids delays and costs associated with workplace illnesses, injuries, and fatalities, including descriptions of safety training, certification, and/or licensure requirements for all relevant workers (e.g., OSHA 10, OSHA 30);  ","Whether workers on the project will receive wages and benefits that will secure an appropriately skilled workforce in the context of the local or regional labor market","Whether the project has completed a project labor agreement. ",null,null,null,"Number of workers enrolled in sectoral job training programs","Number of workers completing sectoral job training programs ","Number of people participating in summer youth employment programs","Number of Households receiving eviction prevention services (including legal representation)","Number of affordable housing units preserved or developed","Number of students participating in evidence-based tutoring programs","Number of children served by childcare and early learning services (pre-school/pre-K/ages 3-5)","Number of families served by home visiting"]
["List Values",null,"N/A","N/A","Not started\nCompleted less than 50%\nCompleted 50% or more\nCompleted\"","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","N/A","\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","N/A","\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","N/A","N/A","N/A","N/A","N/A","\"Yes\"\n\"No\"","N/A","N/A","N/A","N/A","Yes\nNo","N/A","\"Acquisition of equipment for COVID-19 prevention and treatment\"\n\"Adaptations to congregate living facilities\"\n\"Affordable housing, supportive housing, or recovery housing\"\n\"Behavioral health facilities and equipment\"\n\"Childcare, daycare and early learning facilities\"\n\"COVID-19 testing sites and laboratories, and acquisition of related equipment\"\n\"COVID-19 vaccination sites\"\n\"Devices and equipment that assist households in accessing the internet\"\n\"Emergency operations centers and acquisition of emergency response equipment\"\n\"Food banks and other facilities\"\n\"Improvements to existing facilities\"\n\"Installation and improvement of ventilation systems\"\n\"Job and workforce training centers\"\n\"Medical equipment and facilities\"\n\"Medical facilities generally dedicated to COVID-19 treatment and mitigation\"\n\"Mitigation measures in small businesses, nonprofits and impacted industries\"\n\"Parks, green spaces, recreational facilities, sidewalks\"\n\"Public health data systems\"\n\"Rehabilitations, renovation, remediation, cleanup, or conversions\"\n\"Schools and other educational facilities\"\n\"Technology and equipment to allow law enforcement\"\n\"Technology and tools\"\n\"Technology infrastructure to adapt government operations\"\n\"Temporary medical facilities and other measures\"\n\"Transitional shelters\"\n\"Other (please specify)\"","N/A","N/A","Yes\nNo","TBD","TBD","TBD","TBD","Yes\nNo","TBD","TBD","TBD","TBD","TBD","Yes\nNo","Yes\nNo","TBD","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Data Type ",null,"String","String","Pick List","Currency","Currency","Currency","Currency","Currency","String","Currency","Currency","Pick List","String","Pick List","String","Pick List","String","String","String","Numeric","Currency","Picklist","Numeric","String","Numeric","String","Pick List","Currency","Pick List","String","String","Pick List","TBD","TBD","TBD","TBD","Pick List","TBD","TBD","TBD","TBD","TBD","Pick List","Pick List","TBD","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric"]
["Max Length",null,150,20,"N/A","12,2","12,2","12,2","12,2","12,2",1500,"12,2","12,2","N/A",250,"N/A",250,"N/A",250,250,250,10,"12,2","N/A",10,10,750,250,"N/A","12,2","N/A",255,1500,"N/A","TBD","TBD","TBD","TBD","N/A","TBD","TBD","TBD","TBD","TBD","N/A","N/A","TBD",10,10,10,10,10,10,10,10]
["Suggested validations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"conditional formatting based on Column AC","conditional formatting based on Column AC","conditional formatting based on Column AE","conditional formatting based on Column AC and AD","Conditional based on Column F","Conditional Based on column AH","Conditional Based on column AH","Conditional Based on column AH","Conditional Based on column AH","Conditional based on Column F","Conditional Based on column AM","Conditional Based on column AM","Conditional Based on column AM","Conditional Based on column AM","Conditional Based on column AM","Conditional based on Column F","Conditional based on Column F","Conditional based on Column AT"]
["Partner Guidance",null,"Name of the project.","Identification number assigned to project by recipient.","Completion status of the project.","Amount of the adopted budget for this project. This includes single audit fees, and should correspond to what is listed in the Reporting & Compliance form.","Total dollar value of obligations for this project. Per UST guidance and the CFR, obligations \"when referencing a recipient's or subrecipient's use of funds under a Federal award\" means \"orders placed for property and services, contracts and subawards made, and similar transactions that require payment.\"). (Part 200 CFR) Single audit fees and other direct pay items, both obligated and expended, qualify.","Total dollar value of expenditures for this project.\nTCE should be equal to the sum of cumulative expenditures from RIFANS across the entirety of the project. We have provided a tab with expenditures from RIFANS corresponding to the entire project period. ","Total dollar value of obligations for this current reporting period. \nThis number should comprise all Current Period Expenditures plus any obligations made and not yet paid in this current reporting period. For a definition of obligations, refer to the helptext under 'Total Cumulative Obligations'.","Total dollar value of expenditures for this current reporting period. \nThis number should be equal to the sum of cumulative expenditures from RIFANS filtered (using col 'Physical Posted Date') to only those expenditures made on or after the start of this reporting period, and on or before the end of this reporting period.","Provide a description for the project between 50 to 250 words. Each project description should be 3-5 sentences with an overview of the project, which includes a description of the project’s purpose, the population being served, the desired outcome from the project, and how this outcome is being measured (along with any current data on progress towards the desired outcome).","The amount of Federal program income earned.","The amount of program income that was used to cover eligible project costs."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Column Label",null,"Project Name","Project Identification Number\n(Assigned by recipient)","Status of Completion","Adopted Budget","Total Cumulative\nObligations","Total Cumulative\nExpenditures","Current Period Obligations","Current Period Expenditures","Project Description","Program Income Earned","Program Income Expended","Project Demographic Distribution - Primary Populations Served","Primary Project Demographic Explanation","Project Demographic Distribution - Secondary Populations Served","Secondary Project Demographic Explanation","Project Demographic Distribution - Tertiary Populations Served","Tertiary Project Demographic Explanation","Brief description of structure and objectives of assistance program(s), including public health or negative economic impact experienced.","Brief description of how a recipient’s response is related and reasonably and proportional  to a public health or negative economic impact of COVID-19.","Number of households served","The dollar amount of the total project spending that is allocated towards evidence-based interventions","Indicate if a program evaluation of the project is being conducted ","Number of small businesses served (by program if recipient establishes multiple separate \nsmall businesses assistance programs) ","Number of Non-Profits served (by program if recipient establishes multiple separate non-\nprofit assistance programs) ","NCES School ID or NCES District ID","Industry other than tourism Narrative","Does this project include a capital expenditure?","If yes, what is the total expected capital expenditure?","Capital Expenditure Type","Other Capital Expenditure Explanation","Capital Expenditure Narrative","If budget is over $10M, was a Davis Bacon Act Certification completed?","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the number of employees of contractors and sub-contractors working on the project.","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the number of employees on the project hired directly and hired through a third party. ","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the wages and benefits of workers on the project by classification","If budget is over $10M and Davis Bacon Act Certification NOT completed - are those wages are at rates less than those prevailing?","If budget is over $10M, was a Labor Agreement Certification completed?","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will ensure the project has ready access to a sufficient supply of appropriately skilled and unskilled labor to ensure high-quality construction throughout the life of the project, including a description of any required professional certifications and/or in-house training. ","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will minimize risks of labor disputes and disruptions that would jeopardize timeliness and cost-effectiveness of the project.","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will provide a safe and healthy workplace that avoids delays and costs associated with workplace illnesses, injuries, and fatalities, including descriptions of safety training, certification, and/or licensure requirements for all relevant workers (e.g., OSHA 10, OSHA 30).","If budget is over $10M and Labor Agreement Certification NOT completed - enter whether workers on the project will receive wages and benefits that will secure an appropriately skilled workforce in the context of the local or regional labor market.","If budget is over $10M and Labor Agreement Certification NOT completed - enter whether the project has completed a project labor agreement. ","If budget is over $10M, does the project prioritize local hires? ","If budget is over $10M, does the project have a Community Benefit Agreement?","If budget is over $10M and has a Community Benefit Agreement, provide a description. ","Number of workers enrolled in sectoral job training programs","Number of workers completing sectoral job training programs ","Number of people participating in summer youth employment programs","Number of Households receiving eviction prevention services (including legal representation)","Number of affordable housing units preserved or developed","Number of students participating in evidence-based tutoring programs","Number of children served by childcare and early learning services (pre-school/pre-K/ages 3-5)","Number of families served by home visiting"]
["Users will complete these fields, may do multiple rows ",null,null,null,null,null,null,null,null,null,null,null,null,"8 Imp SBs that experienced a negative economic impact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]

{"sheet":"EC 3 - Public Sector Capacity","index":4,"n_rows":13,"n_cols":36,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Expenditure category info:","Unused","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","EC 3.1","EC 3.2","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3","ALL EC3"]
["treasury template reference",null,"projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","project31BulkUpload","project32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload","projectBaselineBulkUpload\nproject31BulkUpload\nproject32BulkUpload"]
["Treasury Column Title (Field ID)",null,"Name","Project_Identification_Number__c","Completion_Status__c","Adopted_Budget__c","Total_Obligations__c","Total_Expenditures__c","Current_Period_Obligations__c","Current_Period_Expenditures__c","Project_Description__c","Program_Income_Earned__c","Program_Income_Expended__c","Structure_Objectives_of_Asst_Programs__c","Recipient_Approach_Description__c","Payroll_Public_Health_Safety__c","Number_of_FTEs_Rehired__c","Does_Project_Include_Capital_Expenditure__c","Total_Cost_Capital_Expenditure__c","Type_of_Capital_Expenditure__c","Type_of_Capital_Expenditure_Other__c","Capital_Expenditure_Justification__c","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)"]
["Required/Optional?",null,"Required","Required","Required","Required","Required","Required","Required","Required","Required","Optional","Optional","Required","Required","Required","Required","Required","Conditional","Conditional","Conditional","Conditional","Required if Budget > $10M","Required if DB is No","Required if DB is No","Required if DB is No","Required if DB is No","Required if Budget > $10M","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if Budget > $10M","Required if Budget > $10M","Required if Budget > $10M"]
["Field definition (expected contents)",null,"Enter Project Name (Text - max Characters 80)","Identification number assigned to project by recipient. DO NOT USE Duplicate Project Numbers, system updates record on duplicate project ID.",null,"The amount of the adopted budget  for this project. ","The total dollar value of obligations for this project.  ","The total dollar value of expenditures for this project. ","The dollar value of obligations for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The dollar value of expenditures for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","Enter Project Description (Text - max characters 1,500)","Enter the amount of Federal program income earned.","Enter the amount of program income that was used to cover eligible project costs.","Brief description of structure and objectives of assistance program(s), including public health or negative economic impact experienced \n\n(Text - max 250 characters)","Brief description of recipients approach to ensuring that response is reasonable and proportional to a public health or negative economic impact of Covid-19, as described in the final rule \n\n(Text - max 250 characters)","Number of government FTEs responding to COVID-19 supported under this ","Number of FTEs rehired by governments under this authority.","If this project includes a capital expenditure, select one of the valid predefined responses from the picklist:\n\"Yes\"\n\"No\"","If you answered \"Yes\" to the previous question, enter the total dollar value of the expected capital expenditure. ","If you answered \"Yes\" for the \"Does this project include a capital expenditure\" question, then you are required to select one of the valid predefined responses from the picklist.\n\nThe below picklist values are abbreviated. Please reference the User Guide for the the comprehensive list of acceptable picklist values. \n\n\"Acquisition of equipment for COVID-19 prevention and treatment\"\n\"Adaptations to congregate living facilities\"\n\"Affordable housing, supportive housing, or recovery housing\"\n\"Behavioral health facilities and equipment\"\n\"Childcare, daycare and early learning facilities\"\n\"COVID-19 testing sites and laboratories, and acquisition of related equipment\"\n\"COVID-19 vaccination sites\"\n\"Devices and equipment that assist households in accessing the internet\"\n\"Emergency operations centers and acquisition of emergency response equipment\"\n\"Food banks and other facilities\"\n\"Improvements to existing facilities\"\n\"Installation and improvement of ventilation systems\"\n\"Job and workforce training centers\"\n\"Medical equipment and facilities\"\n\"Medical facilities generally dedicated to COVID-19 treatment and mitigation\"\n\"Mitigation measures in small businesses, nonprofits and impacted industries\"\n\"Parks, green spaces, recreational facilities, sidewalks\"\n\"Public health data systems\"\n\"Rehabilitations, renovation, remediation, cleanup, or conversions\"\n\"Schools and other educational facilities\"\n\"Technology and equipment to allow law enforcement\"\n\"Technology and tools\"\n\"Technology infrastructure to adapt government operations\"\n\"Temporary medical facilities and other measures\"\n\"Transitional shelters\"\n\"Other (please specify)\"","If you selected \"Other (please specify)\" for the Capital Expenditure Type, please provide more details.\n\n(Text - max character 255)","For recipients (other than Tribal governments) investing in projects with total expected capital expenditures for an enumerated eligible use of $10 million or more, as well as projects with total expected capital expenditures for an \"other\" use of $1 million or more, please provide a written justification.\n\n(Text - max character 1500)",null,"the number of employees of contractors and sub-contractors working on the project; ","The number of employees on the project hired directly and hired through a third party;"," The wages and benefits of workers on the project by classification","Whether those wages are at rates less than those prevailing",null,"How the recipient will ensure the project has ready access to a sufficient supply of appropriately skilled and unskilled labor to ensure high-quality construction throughout the life of the project, including a description of any required professional certifications and/or in-house training;","How the recipient will minimize risks of labor disputes and disruptions that would jeopardize timeliness and cost-effectiveness of the project; ","How the recipient will provide a safe and healthy workplace that avoids delays and costs associated with workplace illnesses, injuries, and fatalities, including descriptions of safety training, certification, and/or licensure requirements for all relevant workers (e.g., OSHA 10, OSHA 30);  ","Whether workers on the project will receive wages and benefits that will secure an appropriately skilled workforce in the context of the local or regional labor market","Whether the project has completed a project labor agreement. "]
["List Values",null,"N/A","N/A","Not started\nCompleted less than 50%\nCompleted 50% or more\nCompleted\"","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","Yes\nNo","N/A","\"Acquisition of equipment for COVID-19 prevention and treatment\"\n\"Adaptations to congregate living facilities\"\n\"Affordable housing, supportive housing, or recovery housing\"\n\"Behavioral health facilities and equipment\"\n\"Childcare, daycare and early learning facilities\"\n\"COVID-19 testing sites and laboratories, and acquisition of related equipment\"\n\"COVID-19 vaccination sites\"\n\"Devices and equipment that assist households in accessing the internet\"\n\"Emergency operations centers and acquisition of emergency response equipment\"\n\"Food banks and other facilities\"\n\"Improvements to existing facilities\"\n\"Installation and improvement of ventilation systems\"\n\"Job and workforce training centers\"\n\"Medical equipment and facilities\"\n\"Medical facilities generally dedicated to COVID-19 treatment and mitigation\"\n\"Mitigation measures in small businesses, nonprofits and impacted industries\"\n\"Parks, green spaces, recreational facilities, sidewalks\"\n\"Public health data systems\"\n\"Rehabilitations, renovation, remediation, cleanup, or conversions\"\n\"Schools and other educational facilities\"\n\"Technology and equipment to allow law enforcement\"\n\"Technology and tools\"\n\"Technology infrastructure to adapt government operations\"\n\"Temporary medical facilities and other measures\"\n\"Transitional shelters\"\n\"Other (please specify)\"","N/A","N/A","Yes\nNo","TBD","TBD","TBD","TBD","Yes\nNo","TBD","TBD","TBD","TBD","TBD","Yes\nNo","Yes\nNo","TBD"]
["Data Type ",null,"String","String","Pick List","Currency","Currency","Currency","Currency","Currency","String","Currency","Currency","String","String","Numeric","Numeric","Pick List","Currency","Pick List","String","String","Pick List","TBD","TBD","TBD","TBD","Pick List","TBD","TBD","TBD","TBD","TBD","Pick List","Pick List","TBD"]
["Max Length",null,150,20,"N/A","12,2","12,2","12,2","12,2","12,2",1500,"12,2","12,2",250,250,6,6,"N/A","12,2","N/A",255,1500,"N/A","TBD","TBD","TBD","TBD","N/A","TBD","TBD","TBD","TBD","TBD","N/A","N/A","TBD"]
["Suggested validations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"conditional formatting based on Column R","conditional formatting based on Column R","conditional formatting based on Column T","conditional formatting based on Columns R and S","Conditional based on Column F","Conditional Based on column W","Conditional Based on column W","Conditional Based on column W","Conditional Based on column W","Conditional based on Column F","Conditional Based on column AC","Conditional Based on column AC","Conditional Based on column AC","Conditional Based on column AC","Conditional Based on column AC","Conditional based on Column F","Conditional based on Column F","Conditional based on Column AI"]
["Partner Guidance",null,"Name of the project.","Identification number assigned to project by recipient.","Completion status of the project.","Amount of the adopted budget for this project. This includes single audit fees, and should correspond to what is listed in the Reporting & Compliance form.","Total dollar value of obligations for this project. Per UST guidance and the CFR, obligations \"when referencing a recipient's or subrecipient's use of funds under a Federal award\" means \"orders placed for property and services, contracts and subawards made, and similar transactions that require payment.\"). (Part 200 CFR) Single audit fees and other direct pay items, both obligated and expended, qualify.","Total dollar value of expenditures for this project. \nTCE should be equal to the sum of cumulative expenditures from RIFANS across the entirety of the project. We have provided a tab with expenditures from RIFANS corresponding to the entire project period. ","Total dollar value of obligations for this current reporting period. \nThis number should comprise all Current Period Expenditures plus any obligations made and not yet paid in this current reporting period. For a definition of obligations, refer to the helptext under 'Total Cumulative Obligations'.","Total dollar value of expenditures for this current reporting period. \nThis number should be equal to the sum of cumulative expenditures from RIFANS filtered (using col 'Physical Posted Date') to only those expenditures made on or after the start of this reporting period, and on or before the end of this reporting period.","Provide a description for the project between 50 to 250 words. Each project description should be 3-5 sentences with an overview of the project, which includes a description of the project’s purpose, the population being served, the desired outcome from the project, and how this outcome is being measured (along with any current data on progress towards the desired outcome).","The amount of Federal program income earned.","The amount of program income that was used to cover eligible project costs."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Column Label",null,"Project Name","Project Identification Number\n(Assigned by recipient)","Status of Completion","Adopted Budget","Total Cumulative\nObligations","Total Cumulative\nExpenditures","Current Period Obligations","Current Period Expenditures","Project Description","Program Income Earned","Program Income Expended","Brief description of structure and objectives of assistance program(s), including public health or negative economic impact experienced.","Brief description of how a recipient’s response is related and reasonably and proportional  to a public health or negative economic impact of COVID-19.","Number of government FTEs responding to COVID-19 supported under this authority","Number of FTEs rehired by governments under this authority","Does this project include a capital expenditure?","If yes, what is the total expected capital expenditure?","Capital Expenditure Type","Other Capital Expenditure Explanation","Capital Expenditure Narrative","If budget is over $10M, was a Davis Bacon Act Certification completed?","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the number of employees of contractors and sub-contractors working on the project.","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the number of employees on the project hired directly and hired through a third party. ","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the wages and benefits of workers on the project by classification","If budget is over $10M and Davis Bacon Act Certification NOT completed - are those wages are at rates less than those prevailing?","If budget is over $10M, was a Labor Agreement Certification completed?","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will ensure the project has ready access to a sufficient supply of appropriately skilled and unskilled labor to ensure high-quality construction throughout the life of the project, including a description of any required professional certifications and/or in-house training. ","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will minimize risks of labor disputes and disruptions that would jeopardize timeliness and cost-effectiveness of the project.","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will provide a safe and healthy workplace that avoids delays and costs associated with workplace illnesses, injuries, and fatalities, including descriptions of safety training, certification, and/or licensure requirements for all relevant workers (e.g., OSHA 10, OSHA 30).","If budget is over $10M and Labor Agreement Certification NOT completed - enter whether workers on the project will receive wages and benefits that will secure an appropriately skilled workforce in the context of the local or regional labor market.","If budget is over $10M and Labor Agreement Certification NOT completed - enter whether the project has completed a project labor agreement. ","If budget is over $10M, does the project prioritize local hires? ","If budget is over $10M, does the project have a Community Benefit Agreement?","If budget is over $10M and has a Community Benefit Agreement, provide a description. "]
["Users will complete these fields, may do multiple rows "]

{"sheet":"EC 4 - Premium Pay","index":5,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Expenditure category info:","Unused","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4","ALL EC4"]
["treasury template reference",null,"project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload","project4142BulkUpload"]
["Treasury Column Title (Field ID)",null,"Name","Project_Identification_Number__c","Completion_Status__c","Adopted_Budget__c","Total_Obligations__c","Total_Expenditures__c","Current_Period_Obligations__c","Current_Period_Expenditures__c","Project_Description__c","Program_Income_Earned__c","Program_Income_Expended__c","Sectors_Critical_to_Health_Well_Being__c","Workers_Served__c","Premium_Pay_Narrative__c","Number_of_Workers_K_12__c"]
["Required/Optional?",null,"Required","Required","Required","Required","Required","Required","Required","Required","Required","Optional","Optional","Required","Required","Required","Required"]
["Field definition (expected contents)",null,"Enter Project Name (Text - max Characters 80)","Identification number assigned to project by recipient. DO NOT USE Duplicate Project Numbers, system updates record on duplicate project ID.",null,"The amount of the adopted budget  for this project. ","The total dollar value of obligations for this project.  ","The total dollar value of expenditures for this project. ","The dollar value of obligations for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The dollar value of expenditures for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","Enter Project Description (Text - max characters 1,500)","Enter the amount of Federal program income earned.","Enter the amount of program income that was used to cover eligible project costs.","List of Sectors Designated as Essential Critical Infrastructure by the chief executive of the jurisdiction, if beyond those included in the Interim Final\nRule\n\n(Text - max characters 1,500)","Number of workers to be served","For groups of workers that do not meet one of the two criteria, submit a written justification describing how the premium pay or grant is responsive to workers performing essential work during the public health emergency: 1) eligible worker receiving premium pay is earning (with the premium included) below 150 percent of their residing state or countys average annual wage for all occupations, as defined by the Bureau of Labor Statistics Occupational Employment and Wage Statistics, whichever is higher, on an annual basis; or 2) eligible worker receiving premium pay is not exempt from the Fair Labor Standards Act overtime provisions. Please see User Guide for additional detail on information to include and not to include in the description","Number of workers to be served with premium pay in K-12 schools"]
["List Values",null,"N/A","N/A","Not started\nCompleted less than 50%\nCompleted 50% or more\nCompleted\"","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","Any work performed by an employee of a State, local, or Tribal government;  \nBehavioral health work;  \nBiomedical Research;  \nDental care work;  \nEducational work, school nutrition work, and other work required to operate a school facility;  \nElections work;  \nEmergency response;  \nFamily or childcare;  \nGrocery stores, restaurants, food production, and food delivery \nHealth care;  \nHome- and community-based health care or assistance with activities of daily living;  \nLaundry work;  \nMaintenance work;  \nMedical testing and diagnostics;  \nPharmacy;  \nPublic health work;  \nSanitation, disinfection, and cleaning work;  \nSocial services work;  \nSolid waste or hazardous materials management, response, and cleanup work;  \nTransportation and warehousing;  \nVital services to Tribes;  \nWork at hotel and commercial lodging facilities that are used for COVID-19 mitigation and containment;  \nWork in a mortuary;  \nWork in critical clinical research, development, and testing necessary for COVID-19 response. \nWork requiring physical interaction with patients;  \nOther (AND manual entry box)","N/A","N/A","N/A"]
["Data Type ",null,"String","String","Pick List","Currency","Currency","Currency","Currency","Currency","String","Currency","Currency","Multi-Select","Numeric","String","Numeric"]
["Max Length",null,80,20,"N/A","12,2","12,2","12,2","12,2","12,2",1500,"12,2","12,2",1500,7,3000,10]
["Suggested validations",null,null,null,null,null,null,null,"will equal total for this project ID from the expenditure and aggregate tabs","will equal total for this project ID from the expenditure and aggregate tabs"]
["Partner Guidance",null,"Name of the project.","Identification number assigned to project by recipient.","Completion status of the project.","Amount of the adopted budget for this project. This includes single audit fees, and should correspond to what is listed in the Reporting & Compliance form.","Total dollar value of obligations for this project. Per UST guidance and the CFR, obligations \"when referencing a recipient's or subrecipient's use of funds under a Federal award\" means \"orders placed for property and services, contracts and subawards made, and similar transactions that require payment.\"). (Part 200 CFR) Single audit fees and other direct pay items, both obligated and expended, qualify.","Total dollar value of expenditures for this project. \nTCE should be equal to the sum of cumulative expenditures from RIFANS across the entirety of the project. We have provided a tab with expenditures from RIFANS corresponding to the entire project period. ","Total dollar value of obligations for this current reporting period. \nThis number should comprise all Current Period Expenditures plus any obligations made and not yet paid in this current reporting period. For a definition of obligations, refer to the helptext under 'Total Cumulative Obligations'.","Total dollar value of expenditures for this current reporting period. \nThis number should be equal to the sum of cumulative expenditures from RIFANS filtered (using col 'Physical Posted Date') to only those expenditures made on or after the start of this reporting period, and on or before the end of this reporting period.","Provide a description for the project between 50 to 250 words. Each project description should be 3-5 sentences with an overview of the project, which includes a description of the project’s purpose, the population being served, the desired outcome from the project, and how this outcome is being measured (along with any current data on progress towards the desired outcome).","The amount of Federal program income earned.","The amount of program income that was used to cover eligible project costs."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Column Label",null,"Project Name","Project Identification Number\n(Assigned by recipient)","Status of Completion","Adopted Budget","Total Cumulative \nObligations","Total Cumulative \nExpenditures","Current Period Obligations","Current Period Expenditures","Project Description","Program Income Earned","Program Income Expended","Sectors Designated as Essential Critical Infrastructure","Number of workers to be served","Premium Pay Narrative","Number of workers to be served with premium pay in K-12 schools "]
["Users will complete these fields, may do multiple rows "]

{"sheet":"EC 5 - Infrastructure","index":6,"n_rows":13,"n_cols":51,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Expenditure category info:","Unused","ALL EC5","ALL EC5","ALL EC5","ALL EC5","ALL EC5","ALL EC5",null,null,"ALL EC5","ALL EC5","ALL EC5","ALL EC5","ALL EC5","EC5.1-5.18","EC5.1-5.18","All EC5","All EC5","All EC5","All EC5","All EC5","All EC5","All EC5","All EC5","All EC5","All EC5","All EC5","All EC5","All EC5","All EC5","EC5.1-5.18","EC5.1-5.18","EC5.19-5.21","EC5.19-5.21","EC5.19-5.21","EC 5.1-5.18","EC 5.1-5.18","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21","5.19-5.21"]
["treasury template reference",null,"project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload","project51518BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload\nproject519521BulkUpload","project51518BulkUpload","project51518BulkUpload",null,null,null,"project51518BulkUpload","project51518BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload","project519521BulkUpload"]
["Treasury Column Title (Field ID)",null,"Name","Project_Identification_Number__c","Completion_Status__c","Adopted_Budget__c","Total_Obligations__c","Total_Expenditures__c","Current_Period_Obligations__c","Current_Period_Expenditures__c","Project_Description__c","Program_Income_Earned__c","Program_Income_Expended__c","Proj_Actual_Construction_Start_Date__c","Initiation_of_Operations_Date__c","Location__c","Location_Detail__c","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","(manual entry)","National_Pollutant_Discharge_Number__c","Public_Water_System_PWS_ID_number__c","Is_project_designed_to_meet_100_mbps__c","Project_not_met_100_mbps_explanation__c","Is_project_designed_to_exceed_100_mbps__c","Median_Household_Income_Service_Area__c","Lowest_Quintile_Income__c",null,"Project_Technology_Type_c","Project_Technology_Type_Other_c","Total_Miles_of_Fiber_Deployed_c","Total_Number_of_Funded_Locations_Served_c","Total_Number_of_Funded_Locations_25/3_c","Total_Number_of_Funded_Locations_Served_25/3_100/20_c","Total_Number_of_Funded_Locations_Served_100/100_c","Total_Number_of_Funded_Locations_Served_100/20_100/100_c","Total_Number_of_Funded_Locations_Served_Residential_c","Total_Number_of_Funded_Locations_Served_Business_c","Total_Number_of_Funded_Locations_Served_Community_Anchor_Institution_c","Speed_Tiers_Offered_c"]
["Required/Optional?",null,"Required","Required","Required","Required","Required","Required","Required","Required","Required","Optional","Optional","Conditional","Conditional","Conditional","Conditional","Required if Budget > $10M","Required if DB is No","Required if DB is No","Required if DB is No","Required if DB is No","Required if Budget > $10M","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if PLA is No","Required if Budget > $10M","Required if Budget > $10M","Required if Budget > $10M","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Required","Conditional","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required"]
["Field definition (expected contents)",null,"Enter Project Name (Text - max Characters 80)","Identification number assigned to project by recipient. DO NOT USE Duplicate Project Numbers, system updates record on duplicate project ID.",null,"The amount of the adopted budget  for this project. ","The total dollar value of obligations for this project.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The total dollar value of expenditures for this project.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The dollar value of obligations for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The dollar value of expenditures for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","Enter Project Description (Text - max characters 1,500)","Enter the amount of Federal program income earned.","Enter the amount of program income that was used to cover eligible project costs.","This field is:\n\nNOT REQUIRED if you selected \"Not Started\" for the \"Status to Completion\" question. \n\nProjected/actual construction start date  Valid Date - (MM/DD/YYYY)","This field is:\n\nNOT REQUIRED if you selected \"Not Started\" for the \"Status to Completion\" question. \n\nProjected/actual construction start date  Valid Date - (MM/DD/YYYY)","REQUIRED if the project has started. \n\nNOT REQUIRED if you selected \"Not Started\" for the \"Status to Completion\" question. \n\nSelect one of the valid predefined responses from the picklist:\n-Latitude/longitude (WGS84 or NAD83 geographic coordinate system)\n-Address\n-Address Range\n-Road Segment","REQUIRED if the project has started. \n\nNOT REQUIRED if you selected \"Not Started\" for the \"Status to Completion\" question.\n\n(Text - Max Characters 255)",null,"the number of employees of contractors and sub-contractors working on the project; ","The number of employees on the project hired directly and hired through a third party;"," The wages and benefits of workers on the project by classification","Whether those wages are at rates less than those prevailing",null,"How the recipient will ensure the project has ready access to a sufficient supply of appropriately skilled and unskilled labor to ensure high-quality construction throughout the life of the project, including a description of any required professional certifications and/or in-house training;","How the recipient will minimize risks of labor disputes and disruptions that would jeopardize timeliness and cost-effectiveness of the project; ","How the recipient will provide a safe and healthy workplace that avoids delays and costs associated with workplace illnesses, injuries, and fatalities, including descriptions of safety training, certification, and/or licensure requirements for all relevant workers (e.g., OSHA 10, OSHA 30);  ","Whether workers on the project will receive wages and benefits that will secure an appropriately skilled workforce in the context of the local or regional labor market","Whether the project has completed a project labor agreement. ",null,null,null,"REQUIRED if the project has started. \n\nNOT REQUIRED if you selected \"Not Started\" for the \"Status to Completion\" question. \n\nNational Pollutant Discharge Elimination System (NPDES) Permit Number (if applicable; for projects aligned with the Clean Water State Revolving Fund) \n\n(Text - Max Characters 50)","REQUIRED if the project has started. \n\nNOT REQUIRED if you selected \"Not Started\" for the \"Status to Completion\" question.\n\nPublic Water System (PWS) ID number (if applicable; for projects aligned with the Drinking Water State Revolving Fund)  \n\n\n(Text - Max Characters 50)","REQUIRED if the project has started. \n\nNOT REQUIRED if you selected \"Not Started\" for the \"Status to Completion\" question. \n\nSelect Yes / No","REQUIRED if the project has started. \n\nNOT REQUIRED if you selected \"Not Started\" for the \"Status to Completion\" question.\n\n(Text - max characters 1,500)","REQUIRED if the project has started. \n\nNOT REQUIRED if you selected \"Not Started\" for the \"Status to Completion\" question.\n\nSelect Yes / No",null,null,"Confirm that the service provider for the project has, or will upon completion of the project, either participated in the Federal Communications Commission (FCC)'s Affordable Connectivity Program (ACP) or otherwise provided access to a broad-based affordability program that proides benefits to households commensurate with those provided under the ACP to low-income consumers in the proposed service area of the broadband infrastructure (applicable only to projects that provide service to households)","Project Technology Type(s) (Planned/Actual)","If the selected Project Technology Type includes 'specify' please provide a brief explanation.\n\n(Text - max 250 characters)","Total Miles of Fiber Deployed (Planned/Actual)","Total Number of Funded Locations Served (Planned/Actual)","Total Number of Funded Locations Served, broken out by speeds (Pre-SLFRF investment, Number receiving 25/3 Mbps or below)","Total Number of Funded Locations Served, broken out by speeds (Pre-SLFRF investment, Number receiving between 25/3 Mbps and 100/20 Mbps)","Total Number of Funded Locations Served, broken out by speeds (Post-SLFRF investment, Number receiving minimum 100/100 Mbps)","Total Number of Funded Locations Served, broken out by speeds (Post-SLFRF investment, Number receiving minimum 100/20 Mbps and scalable to minimum 100/100 Mbps)","Total Number of Funded Locations Served, broken out by type (Planned/Actual) (Residential - Total Housing Units)","Total Number of Funded Locations Served, broken out by type (Planned/Actual) (Business)","Total Number of Funded Locations Served, broken out by type (Planned/Actual) (Community Anchor Institution)","Speed Tiers Offered, corresponding non-promotional prices, including associated fees, and data allowance for each speed tier of broadband service"]
["List Values",null,"N/A","N/A","Not started\nCompleted less than 50%\nCompleted 50% or more\nCompleted\"","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","Latitude/longitude (WGS84 or NAD83 geographic coordinate system)\nAddress\nAddress Range\nRoad Segment","N/A","Yes\nNo","TBD","TBD","TBD","Yes\nNo","Yes\nNo","TBD","TBD","TBD","Yes\nNo","Yes\nNo","Yes\nNo","Yes\nNo","TBD","N/A","N/A","TBD","N/A","Yes\nNo","N/A","Yes\nNo","\"Yes\"\n\"No\"","\"Fiber\"\n\"Coaxial Cable\"\n\"Terrestrial Fixed Wireless\"\n\"Other (specify)\"","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Data Type ",null,"String","String","Pick List","Currency","Currency","Currency","Currency","Currency","String","Currency","Currency","Date","Date","Pick List","String","Pick List","TBD","TBD","TBD","Pick List","Pick List","TBD","TBD","TBD","Pick List","Pick List","Pick List","Pick List","TBD","String","String","TBD","String","Pick List","Currency","Currency","Pick List","Pick List","String","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric"]
["Max Length",null,80,20,"N/A","12,2","12,2","12,2","12,2","12,2",1500,"12,2","12,2","mm/dd/yyyy","mm/dd/yyyy","N/A",255,"N/A","TBD","TBD","TBD","N/A","N/A","TBD","TBD","TBD","N/A","N/A","N/A","N/A","TBD",50,50,"TBD",1500,"N/A","12,2","12,2","N/A","N/A",250,10,10,10,10,10,10,10,10,10,10]
["Suggested validations",null,null,null,null,null,null,null,null,null,null,null,null,"conditional based on Column E","conditional based on Column E","conditional based on Column E","conditional based on Column E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"conditional based on Column E","conditional based on Column E","conditional based on Column E","conditional based on Column E","conditional based on Column E","conditional based on Column E","conditional based on Column E"]
["Partner Guidance",null,"Name of the project.","Identification number assigned to project by recipient.","Completion status of the project.","Amount of the adopted budget for this project. This includes single audit fees, and should correspond to what is listed in the Reporting & Compliance form.","Total dollar value of obligations for this project. Per UST guidance and the CFR, obligations \"when referencing a recipient's or subrecipient's use of funds under a Federal award\" means \"orders placed for property and services, contracts and subawards made, and similar transactions that require payment.\"). (Part 200 CFR) Single audit fees and other direct pay items, both obligated and expended, qualify.","Total dollar value of expenditures for this project. \nTCE should be equal to the sum of cumulative expenditures from RIFANS across the entirety of the project. We have provided a tab with expenditures from RIFANS corresponding to the entire project period. ","Total dollar value of obligations for this current reporting period. \nThis number should comprise all Current Period Expenditures plus any obligations made and not yet paid in this current reporting period. For a definition of obligations, refer to the helptext under 'Total Cumulative Obligations'.","Total dollar value of expenditures for this current reporting period. \nThis number should be equal to the sum of cumulative expenditures from RIFANS filtered (using col 'Physical Posted Date') to only those expenditures made on or after the start of this reporting period, and on or before the end of this reporting period.","Provide a description for the project between 50 to 250 words. Each project description should be 3-5 sentences with an overview of the project, which includes a description of the project’s purpose, the population being served, the desired outcome from the project, and how this outcome is being measured (along with any current data on progress towards the desired outcome).","The amount of Federal program income earned.","The amount of program income that was used to cover eligible project costs."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Column Label",null,"Project Name","Project Identification Number\n(Assigned by recipient)","Status of Completion","Adopted Budget","Total Cumulative \nObligations","Total Cumulative \nExpenditures","Current Period Obligations","Current Period Expenditures","Project Description","Program Income Earned","Program Income Expended","Projected/actual construction start date","Projected/actual initiation of operations date","Location Type","Location Details","If budget is over $10M, was a Davis Bacon Act Certification completed?","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the number of employees of contractors and sub-contractors working on the project.","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the number of employees on the project hired directly and hired through a third party. ","If budget is over $10M and Davis Bacon Act Certification NOT completed - enter the wages and benefits of workers on the project by classification","If budget is over $10M and Davis Bacon Act Certification NOT completed - are those wages are at rates less than those prevailing?","If budget is over $10M, was a Labor Agreement Certification completed?","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will ensure the project has ready access to a sufficient supply of appropriately skilled and unskilled labor to ensure high-quality construction throughout the life of the project, including a description of any required professional certifications and/or in-house training. ","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will minimize risks of labor disputes and disruptions that would jeopardize timeliness and cost-effectiveness of the project.","If budget is over $10M and Labor Agreement Certification NOT completed - enter how the recipient will provide a safe and healthy workplace that avoids delays and costs associated with workplace illnesses, injuries, and fatalities, including descriptions of safety training, certification, and/or licensure requirements for all relevant workers (e.g., OSHA 10, OSHA 30).","If budget is over $10M and Labor Agreement Certification NOT completed - enter whether workers on the project will receive wages and benefits that will secure an appropriately skilled workforce in the context of the local or regional labor market.","If budget is over $10M and Labor Agreement Certification NOT completed - enter whether the project has completed a project labor agreement. ","If budget is over $10M, does the project prioritize local hires? ","If budget is over $10M, does the project have a Community Benefit Agreement?","If budget is over $10M and has a Community Benefit Agreement, provide a description. ","National Pollutant Discharge Elimination System (NPDES)","Public Water System (PWS) ID number   ","Confirm that the project is designed to, upon completion, reliably meet or exceed symmetrical 100 Mbps download and upload speeds.","If the project is not designed to reliably meet or exceed symmetrical 100 Mbps download and upload speeds, explain why not","Confirm that the project is designed to, upon completion, meet or exceed symmetrical 100 Mbps download speed and between at least 20 Mbps and 100 Mbps upload speed, and be scalable to a minimum of 100 Mbps download speed and 100 Mbps upload speed","Median Household Income of service area ","Lowest Quintile Income of the service area ","Confirm that the service provider for the project has, or will upon completion of the project, either participated in the Federal Communications Commission (FCC)'s Affordable Connectivity Program (ACP) or otherwise provided access to a broad-based affordability program that proides benefits to households commensurate with those provided under the ACP to low-income consumers in the proposed service area of the broadband infrastructure (applicable only to projects that provide service to households)","Project Technology Type(s) (Planned/Actual)","Project Technology Type - Explanation","Total Miles of Fiber Deployed (Planned/Actual)","Total Number of Funded Locations Served (Planned/Actual)","Total Number of Funded Locations Served, broken out by speeds (Pre-SLFRF investment, Number receiving 25/3 Mbps or below)","Total Number of Funded Locations Served, broken out by speeds (Pre-SLFRF investment, Number receiving between 25/3 Mbps and 100/20 Mbps)","Total Number of Funded Locations Served, broken out by speeds (Post-SLFRF investment, Number receiving minimum 100/100 Mbps)","Total Number of Funded Locations Served, broken out by speeds (Post-SLFRF investment, Number receiving minimum 100/20 Mbps and scalable to minimum 100/100 Mbps)","Total Number of Funded Locations Served, broken out by type (Planned/Actual) (Residential - Total Housing Units)","Total Number of Funded Locations Served, broken out by type (Planned/Actual) (Business)","Total Number of Funded Locations Served, broken out by type (Planned/Actual) (Community Anchor Institution)","Speed Tiers Offered, corresponding non-promotional prices, including associated fees, and data allowance for each speed tier of broadband service"]
["Users will complete these fields, may do multiple rows "]

{"sheet":"EC 7 - Admin","index":7,"n_rows":13,"n_cols":26,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Expenditure category info:","Unused","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7","ALL EC 7"]
["treasury template reference",null,"projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload","projectBaselineBulkUpload"]
["Treasury Column Title (Field ID)",null,"Name","Project_Identification_Number__c","Completion_Status__c","Adopted_Budget__c","Total_Obligations__c","Total_Expenditures__c","Current_Period_Obligations__c","Current_Period_Expenditures__c","Does_Project_Include_Capital_Expenditure__c","Total_Cost_Capital_Expenditure__c","Type_of_Capital_Expenditure__c","Type_of_Capital_Expenditure_Other__c","Capital_Expenditure_Justification__c","Project_Description__c","Program_Income_Earned__c","Program_Income_Expended__c","Primary_Project_Demographics__c","Primary_Project_Demographics_Explanation__c","Secondary_Project_Demographics__c","Secondary_Proj_Demographics_Explanation__c","Tertiary_Project_Demographics__c","Tertiary_Proj_Demographics_Explanation__c","Structure_Objectives_of_Asst_Programs__c","Recipient_Approach_Description__c"]
["Required/Optional?",null,"Required","Required","Required","Required","Required","Required","Required","Required","Required","Conditional","Conditional","Conditional","Conditional","Required","Optional","Optional","Required","Conditional","Optional","Conditional","Optional","Conditional","Required","Required"]
["Field definition (expected contents)",null,"Enter Project Name (Text - max Characters 80)","Identification number assigned to project by recipient. DO NOT USE Duplicate Project Numbers, system updates record on duplicate project ID.",null,"The amount of the adopted budget  for this project. Currency field with max 12 characters, 2 decimals. \nDO NOT include a \"$\" sign or commas \",\" when entering Amounts. ","The total dollar value of obligations for this project.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The total dollar value of expenditures for this project.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The dollar value of obligations for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","The dollar value of expenditures for this project for the current period.  Currency max 12 characters, 2 decimals. DO NOT include a \"$\" sign or commas \",\" when entering Amounts.","If this project includes a capital expenditure, select one of the valid predefined responses from the picklist:\n\"Yes\"\n\"No\"","If you answered \"Yes\" to the previous question, enter the total dollar value of the expected capital expenditure. ","If you answered \"Yes\" for the \"Does this project include a capital expenditure\" question, then you are required to select one of the valid predefined responses from the picklist.\n\nThe below picklist values are abbreviated. Please reference the User Guide for the the comprehensive list of acceptable picklist values. \n\n\"Acquisition of equipment for COVID-19 prevention and treatment\"\n\"Adaptations to congregate living facilities\"\n\"Affordable housing, supportive housing, or recovery housing\"\n\"Behavioral health facilities and equipment\"\n\"Childcare, daycare and early learning facilities\"\n\"COVID-19 testing sites and laboratories, and acquisition of related equipment\"\n\"COVID-19 vaccination sites\"\n\"Devices and equipment that assist households in accessing the internet\"\n\"Emergency operations centers and acquisition of emergency response equipment\"\n\"Food banks and other facilities\"\n\"Improvements to existing facilities\"\n\"Installation and improvement of ventilation systems\"\n\"Job and workforce training centers\"\n\"Medical equipment and facilities\"\n\"Medical facilities generally dedicated to COVID-19 treatment and mitigation\"\n\"Mitigation measures in small businesses, nonprofits and impacted industries\"\n\"Parks, green spaces, recreational facilities, sidewalks\"\n\"Public health data systems\"\n\"Rehabilitations, renovation, remediation, cleanup, or conversions\"\n\"Schools and other educational facilities\"\n\"Technology and equipment to allow law enforcement\"\n\"Technology and tools\"\n\"Technology infrastructure to adapt government operations\"\n\"Temporary medical facilities and other measures\"\n\"Transitional shelters\"\n\"Other (please specify)\"","If you selected \"Other (please specify)\" for the Capital Expenditure Type, please provide more details.\n\n(Text - max character 255)","For recipients (other than Tribal governments) investing in projects with total expected capital expenditures for an enumerated eligible use of $10 million or more, as well as projects with total expected capital expenditures for an \"other\" use of $1 million or more, please provide a written justification.\n\n(Text - max character 1500)\n","Enter Project Description (Text - max characters 1,500)","Enter the amount of Federal program income earned.","Enter the amount of program income that was used to cover eligible project costs.","What Impacted and/or Disproportionally Impacted population does this project primarily serve? Please select the population primarily served. \n\nNote: Populate this field with one of the below predefined responses. Cut and paste the exact verbiage, and do not include the quotation marks (\" \").\n\n\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","If the selected demographic includes 'specify' please provide a brief explanation\n\n(Text - max 250 characters)","What Impacted and/or Disproportionally Impacted population does this project primarily serve? Please select the population primarily served. \n\nNote: Populate this field with one of the below predefined responses. Cut and paste the exact verbiage, and do not include the quotation marks (\" \").\n\n\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","If the selected demographic includes 'specify' please provide a brief explanation\n\n(Text - max 250 characters)","What Impacted and/or Disproportionally Impacted population does this project primarily serve? Please select the population primarily served. \n\nNote: Populate this field with one of the below predefined responses. Cut and paste the exact verbiage, and do not include the quotation marks (\" \").\n\n\"1 Imp General Public\"\n\"2 Imp Low or moderate income HHs or populations\"\n\"3 Imp HHs that experienced unemployment\"\n\"4 Imp HHs that experienced increased food or housing insecurity\"\n\"5 Imp HHs that qualify for certain federal programs\"\n\"6 Imp For services to address lost instructional time in K-12 schools\"\n\"7 Imp Other HHs or populations that experienced a negative economic\"\n\"8 Imp SBs that experienced a negative economic impact\"\n\"9 Imp Classes of SBs designated as negatively economically impacted\"\n\"10 Imp NPs that experienced a negative economic impact specify\"\n\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","If the selected demographic includes 'specify' please provide a brief explanation\n\n(Text - max 250 characters)","Brief description of structure and objectives of assistance program(s), including public health or negative economic impact experienced \n\n(Text - max 250 characters)","Brief description of recipients approach to ensuring that response is reasonable and proportional to a public health or negative economic impact of Covid-19, as described in the final rule \n\n(Text - max 250 characters)"]
["List Values",null,"N/A","N/A","Not started\nCompleted less than 50%\nCompleted 50% or more\nCompleted","N/A","N/A","N/A","N/A","N/A","Yes\nNo","N/A","\"Acquisition of equipment for COVID-19 prevention and treatment\"\n\"Adaptations to congregate living facilities\"\n\"Affordable housing, supportive housing, or recovery housing\"\n\"Behavioral health facilities and equipment\"\n\"Childcare, daycare and early learning facilities\"\n\"COVID-19 testing sites and laboratories, and acquisition of related equipment\"\n\"COVID-19 vaccination sites\"\n\"Devices and equipment that assist households in accessing the internet\"\n\"Emergency operations centers and acquisition of emergency response equipment\"\n\"Food banks and other facilities\"\n\"Improvements to existing facilities\"\n\"Installation and improvement of ventilation systems\"\n\"Job and workforce training centers\"\n\"Medical equipment and facilities\"\n\"Medical facilities generally dedicated to COVID-19 treatment and mitigation\"\n\"Mitigation measures in small businesses, nonprofits and impacted industries\"\n\"Parks, green spaces, recreational facilities, sidewalks\"\n\"Public health data systems\"\n\"Rehabilitations, renovation, remediation, cleanup, or conversions\"\n\"Schools and other educational facilities\"\n\"Technology and equipment to allow law enforcement\"\n\"Technology and tools\"\n\"Technology infrastructure to adapt government operations\"\n\"Temporary medical facilities and other measures\"\n\"Transitional shelters\"\n\"Other (please specify)\"","N/A","N/A","N/A","N/A","N/A","\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","N/A","\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","N/A","\"11 Imp Classes of NPs designated as negatively economically impacted\"\n\"12 Imp Travel tourism or hospitality sectors\"\n\"13 Imp Industry outside the travel tourism or hospitality sectors specify\"\n\"14 Dis Imp Low income HHs and populations\"\n\"15 Dis Imp HHs and populations residing in Qualified Census Tracts\"\n\"16 Dis Imp HHs that qualify for certain federal programs\"\n\"17 Dis Imp HHs receiving services provided by Tribal governments\"\n\"18 Dis Imp HHs residing in the U.S. territories or receiving services\"\n\"19 Dis Imp For services to address educational disparities Title I eligible\"\n\"20 Dis Imp Other HHs or populations that experienced a disproportionate\"\n\"21 Dis Imp SBs operating in Qualified Census Tracts\"\n\"22 Dis Imp SBs operated by Tribal governments or on Tribal lands\"\n\"23 Dis Imp SBs operating in the U.S. territories\"\n\"24 Dis Imp Other SBs Dis Imp by the pandemic specify\"\n\"25 Dis Imp NPs operating in Qualified Census Tracts\"\n\"26 Dis Imp NPs operated by Tribal governments or on Tribal lands\"\n\"27 Dis Imp NPs operating in the U.S. territories\"\n\"28 Dis Imp Other NPs Dis Imp by the pandemic specify\"","N/A","N/A","N/A"]
["Data Type ",null,"String","String","Pick List","Currency","Currency","Currency","Currency","Currency","Pick List","Currency","Pick List","String","String","String","Currency","Currency","Pick List","String","Pick List","String","Pick List","String","String","String"]
["Max Length",null,80,20,"N/A","12,2","12,2","12,2","12,2","12,2","N/A","12,2","N/A",255,1500,1500,"12,2","12,2","N/A",250,"N/A",250,"N/A",250,250,250]
["Suggested validations",null,null,null,null,null,null,null,null,null,"conditional formatting based on Column K","conditional formatting based on Column K","conditional formatting based on Column M","(conditional formatting moved to this one, based on amount in Column F?)"]
["Partner Guidance",null,"Name of the project.","Identification number assigned to project by recipient.","Completion status of the project.","Amount of the adopted budget for this project. This includes single audit fees, and should correspond to what is listed in the Reporting & Compliance form.","Total dollar value of obligations for this project. Per UST guidance and the CFR, obligations \"when referencing a recipient's or subrecipient's use of funds under a Federal award\" means \"orders placed for property and services, contracts and subawards made, and similar transactions that require payment.\"). (Part 200 CFR) Single audit fees and other direct pay items, both obligated and expended, qualify.","Total dollar value of expenditures for this project. \nTCE should be equal to the sum of cumulative expenditures from RIFANS across the entirety of the project. We have provided a tab with expenditures from RIFANS corresponding to the entire project period. ","Total dollar value of obligations for this current reporting period. \nThis number should comprise all Current Period Expenditures plus any obligations made and not yet paid in this current reporting period. For a definition of obligations, refer to the helptext under 'Total Cumulative Obligations'.","Total dollar value of expenditures for this current reporting period. \nThis number should be equal to the sum of cumulative expenditures from RIFANS filtered (using col 'Physical Posted Date') to only those expenditures made on or after the start of this reporting period, and on or before the end of this reporting period.",null,null,null,null,null,"Provide a description for the project between 50 to 250 words. Each project description should be 3-5 sentences with an overview of the project, which includes a description of the project’s purpose, the population being served, the desired outcome from the project, and how this outcome is being measured (along with any current data on progress towards the desired outcome).","The amount of Federal program income earned.","The amount of program income that was used to cover eligible project costs."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Column Label",null,"Project Name","Project Identification Number\n(Assigned by recipient)","Status of Completion","Adopted Budget","Total Cumulative \nObligations","Total Cumulative \nExpenditures","Current Period Obligations","Current Period Expenditures","Does this project include a capital expenditure?","If yes, what is the total expected capital expenditure?","Capital Expenditure Type","Other Capital Expenditure Explanation","Capital Expenditure Narrative","Project Description","Program Income Earned","Program Income Expended","Project Demographic Distribution - Primary Populations Served","Primary Project Demographic Explanation","Project Demographic Distribution - Secondary Populations Served","Secondary Project Demographic Explanation","Project Demographic Distribution - Tertiary Populations Served","Tertiary Project Demographic Explanation","Structure and objectives of assistance program","Recipients approach"]
["Users will complete these fields, may do multiple rows "]

{"sheet":"Subrecipient","index":8,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["treasury template reference",null,"Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient","Subrecipient"]
["Treasury Column Title (Field ID)",null,"Unique_Entity_Identifier__c","EIN__c","Name","Entity_Type__c","POC_Email_Address__c","Address__c","Address_2__c","Address_3__c","City__c","State_Abbreviated__c","Zip__c","Zip_4__c","Registered_in_Sam_gov__c","Federal_Funds_80_or_More_of_Revenue__c","Derives_25_Million_or_More_from_Federal__c","Total_Compensation_for_Officers_Public__c","Officer_Name__c","Officer_Total_Comp__c","Officer_2_Name__c","Officer_2_Total_Comp__c","Officer_3_Name__c","Officer_3_Total_Comp__c","Officer_4_Name__c","Officer_4_Total_Comp__c","Officer_5_Name__c","Officer_5_Total_Comp__c"]
["Required/Optional?",null,"Optional","Optional","Required","Required","Optional","Required","Optional","Optional","Required","Required","Required","Optional","Required","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional","Conditional"]
["Field definition (expected contents)",null,"The Subrecipient's or Contractor's Unique Entity Identifier (UEI) from their SAM.gov profile. \n\nFormat XXXXXXXXXXXX, \n12 alpha-numeric characters.\n\nNOTE: One of the following identification numbers must be provided:\n-UEI, or\n-TIN","The Subrecipient's, Contractor's, or Beneficiary's  Internal Revenue Service (IRS) Taxpayer Identification Number. \n\nFormat XXXXXXXXX, \n9 numeric characters.\n\nNOTE: One of the following identification numbers must be provided:\n-UEI, or\n-TIN","The name of the Sub-Recipient. Max character 80.","The type of entity. Select one of the following: \n-Subrecipient  \n-Contractor\n-Beneficiary","The type of entity. Select one of the following: \n-Subrecipient  \n-Contractor\n-Beneficiary","The email address of the primary point-of-contact for the sub-recipient. Must be valid Email format.","First line of the Sub-Recipient's address. (255 Character max)","Second line of the Sub-Recipient's address. (255 Character max)","Third line of the Sub-Recipient's address. (255 Character max)","Name of the city in which the Sub-Recipient is located. (100 Character Max)","United States Postal Service (USPS) two-letter abbreviation for the state or territory in which the Sub-Recipient is located. Valid Response:\n (AL, AK, AS, AZ, AR, CA, CO, CT, DE, DC, FM, FL, GA, GU, HI, ID, IL, IN, IA, KS, KY, LA, ME, MH, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, MP, OH, OK, OR, PW, PA, PR, RI, SC, SD, TN, TX, UT, VT, VI, VA, WA, WV, WI, WY)","United States ZIP code (five digits) associated with the Sub-Recipient's address.  \nFormat XXXXX, 5 numeric characters. ","Zip Plus4 (four digits) identifying where the predominant performance of the subaward will be accomplished. \nFormat XXXX, 4 numeric characters. ","Confirmation that the proportion of the Sub-Recipient's federal funding-to-total annual gross revenue for the preceding fiscal year is at least 80%.\nMust select Yes or No. ","Confirmation that the Sub-Recipient's total annual gross revenue from federal funding across all programs for the preceding fiscal year is greater than $25 million. \nMust select Yes or No. ","Confirmation that qualifying Sub-Recipient's publicly identify their top five highest compensated executives or have it listed in their SAM.gov profile, if No please enter the names and compensation for the 5 highest officers. \nMust select Yes or No. ","The legal name belonging to one of the five highest paid executives, officers, or employees of the Sub-Recipient. ","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Sub-Recipient. \nDO NOT include a \"$\" sign when entering compensation. ","The legal name belonging to one of the five highest paid executives, officers, or employees of the Sub-Recipient.","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Sub-Recipient.\nDO NOT include a \"$\" sign when entering compensation. ","The legal name belonging to one of the five highest paid executives, officers, or employees of the Sub-Recipient.","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Sub-Recipient.\nDO NOT include a \"$\" sign when entering compensation. ","The legal name belonging to one of the five highest paid executives, officers, or employees of the Sub-Recipient.","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Sub-Recipient.\nDO NOT include a \"$\" sign when entering compensation. ","The legal name belonging to one of the five highest paid executives, officers, or employees of the Sub-Recipient.","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Sub-Recipient.\nDO NOT include a \"$\" sign when entering compensation. "]
["List Values",null,"N/A","N/A","N/A","Subrecipient  \nContractor\nBeneficiary","N/A","N/A","N/A","N/A","N/A","2 Letter State abbr.","N/A","N/A","Yes\nNo","Yes\nNo","Yes\nNo","Yes\nNo","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Data Type ",null,"String","Numeric","String","Pick List","String","String","String","String","String","Pick List","Numeric","Numeric","Pick List","Pick List","Pick List","Pick List","String","Currency","String","Currency","String","Currency","String","Currency","String","Currency"]
["Max Length",null,12,9,80,"N/A",40,255,255,255,100,"N/A",5,4,"N/A","N/A","N/A","N/A",80,"12,2",80,"12,2",80,"12,2",80,"12,2",80,"12,2"]
["Suggested validations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conditional on Column N","Conditional on Column O","Conditional on Column P","Conditional on Column Q","Conditional on Column Q","Conditional on Column Q","Conditional on Column Q","Conditional on Column Q","Conditional on Column Q","Conditional on Column Q","Conditional on Column Q","Conditional on Column Q","Conditional on Column Q"]
["Partner Guidance",null,"The Sub-recipient's Unique Entity Identifier (UEI) created in SAM.gov. NOTE: Sub-recipients must provide one of the following numbers: -UEI, or -TIN","The Subrecipient's Internal Revenue Service (IRS) Taxpayer Identification Number. NOTE: Sub-recipients must provide one of the following numbers: -UEI, or -TIN","The name of the Subrecipient. ","Indicators for types of entities.","The email address of the primary point-of-contact for the Subrecipient.","First line of the Subrecipient's address.","Second line of the Subrecipient's address.","Third line of the Subrecipient's address.","Name of the city in which the Subrecipient is located.","United States Postal Service (USPS) two-letter abbreviation for the state or territory in which the Subrecipient is located.","United States ZIP code (five digits) associated with the Subrecipient's address.","Zip Plus4 (four digits) identifying where the predominant performance of the subaward will be accomplished.","Confirmation that the Subrecipient is registered in SAM.gov.","Confirmation that the proportion of the Subrecipient's federal fundingto-total annual gross revenue for the preceding fiscal year is at least 80%.","Confirmation that the Subrecipient's total annual gross revenue from federal funding across all programs for the preceding fiscal year is greater than $25 million.","Confirmation that qualifying Subrecipient's publicly identify their top five highest compensated executives or have it listed in their SAM.gov profile, if No please provide names and compensation for top 5 executives.","The legal name belonging to one of the five highest paid executives, officers, or employees of the Subrecipient.","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Subrecipient.","The legal name belonging to one of the five highest paid executives, officers, or employees of the Subrecipient.","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Subrecipient.","The legal name belonging to one of the five highest paid executives, officers, or employees of the Subrecipient.","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Subrecipient.","The legal name belonging to one of the five highest paid executives, officers, or employees of the Subrecipient.","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Subrecipient.","The legal name belonging to one of the five highest paid executives, officers, or employees of the Subrecipient.","The Total Compensation, as defined in 2 CFR part 170.330, earned by the five highest paid executives, officers, or employees of the Subrecipient."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Label",null,"Sub-Recipient UEI","Subrecipient TIN","Legal Name","Entity Type","Point of Contact Email Address","Address Line 1","Address Line 2","Address Line 3","City Name","State Code","Zip","Zip4","Recipient SAM.gov Registration?","In its preceding fiscal year, did recipient receive 80% or more of its annual gross revenue from federal funds?","In the preceding fiscal year, did recipient receive $25 million or more of its annual gross revenue from federal funds?","Is the \"total compensation\" for the organization's five highest paid officers publicly listed or otherwise listed in SAM.gov?","Executive Name (1)","Total Compensation Executive (1)","Executive Name (2)","Total Compensation Executive (2)","Executive Name (3)","Total Compensation Executive (3)","Executive Name (4)","Total Compensation Executive (4)","Executive Name (5)","Total Compensation Executive (5)"]
["Users will complete these fields, may do multiple rows "]

{"sheet":"Awards > 50000","index":9,"n_rows":13,"n_cols":22,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Expenditure category info:",null,null,null,null,null,null,null,null,null,null,"EC 1.10, 2.35-2.36"]
["treasury template reference"]
["Treasury Column Title (Field ID)",null,"Recipient_UEI__c","Recipient_EIN__c","Project_Identification_Number__c","Award_No__c","Award_Type__c","Award_Amount__c","Award_Date__c","Primary_Sector__c","If_Other__c","Purpose_of_Funds__c","Period_of_Performance_Start__c","Period_of_Performance_End__c","Place_of_Performance_Address_1__c","Place_of_Performance_Address_2__c","Place_of_Performance_Address_3__c","Place_of_Performance_City__c","State_Abbreviated__c","Place_of_Performance_Zip__c","Place_of_Performance_Zip_4__c","Description__c"]
["Required/Optional?",null,"Optional","Optional","Required","Required","Required","Required","Required","Required","**only required if Primary Sector is Other","TBD","Required","Required","Required","Optional","Optional","Required","Required","Required","Optional","Required"]
["Field definition (expected contents)",null,"The Subrecipient's or Contractor's Unique Entity Identifier (UEI) from their SAM.gov profile. \n\nFormat XXXXXXXXXXXX, \n12 alpha-numeric characters.\n\nNOTE: One of the following identification numbers must be provided:\n-UEI, or\n-TIN","The Subrecipient's, Contractor's, or Beneficiary's  Internal Revenue Service (IRS) Taxpayer Identification Number. \n\nFormat XXXXXXXXX, \n9 numeric characters.\n\nNOTE: One of the following identification numbers must be provided:\n-UEI, or\n-TIN","Recipient Project Id associated with this Sub Award. This is your Project Identification Number.   ","Recipient's internal account number for the grant, contract, transfer, or direct payment. This can be the account number or any other unique identifying number assigned by the Recipient to the award. This number is strictly for the Recipient's recordkeeping.  ","The type of subaward","Total amount of SLFRF funds obligated by the Recipient to a SubRecipient under a given SubAward. \nDO NOT INCLUDE $ sign when entering amount. ","The date the Recipient obligated funds to a SubRecipient. \nFormat MM/DD/YYYY",null,"Explaination if Primary Sector response is \"Other\"\n\nMax characters 100","TBD","The date on which efforts begin or the subaward is otherwise effective","The date on which all effort is completed or the subaward is otherwise ended. ","First line of the address where the predominant performance of the subaward will be accomplished. ","Second line of the address where the predominant performance of the subaward will be accomplished. ","Third line of the address where the predominant performance of the subaward will be accomplished. ","The name of the city where the predominant performance of the subaward will be accomplished.\n","United States Postal Service (USPS) twoletter abbreviation for the state or territory indicating where the predominant performance of the subaward will be accomplished. \nValid responses: (AL, AK, AS, AZ, AR, CA, CO, CT, DE, DC, FM, FL, GA, GU, HI, ID, IL, IN, IA, KS, KY, LA, ME, MH, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, MP, OH, OK, OR, PW, PA, PR, RI, SC, SD, TN, TX, UT, VT, VI, VA, WA, WV, WI, WY)\n","United States ZIP code (five digits) identifying where the predominant performance of the subaward will be accomplished. \nFormat XXXXX, 5 numeric characters. \n","Zip Plus4 (four digits) identifying where the predominant performance of the subaward will be accomplished. \nFormat XXXX, 4 numeric characters. "]
["List Values",null,"N/A","N/A","N/A","N/A"," \"Contract: Purchase Order\"\n \"Contract: Delivery Order\"\n \"Contract: Blanket Purchase Agreement\"\n \"Contract: Definitive Contract\"\n \"Grant: Lump Sum Payment(s)\"\n \"Grant: Reimbursable\"\n \"Direct Payment\"\n \"Transfer: Lump Sum Payment(s)\"\n \"Transfer: Reimbursable\"  \n \"Loan - maturity prior to 12/31/26 with planned forgiveness\"\n \"Loan - maturity prior to 12/31/26 without planned forgiveness\"\n \"Loan - maturity past 12/31/26 with planned forgiveness\"\n \"Loan - maturity past 12/31/26 without planned forgiveness\"","N/A","N/A"," \"any work performed by an employee of a State local or Tribal government\"\n \"behavioral health work\"\n \"biomedical research\"\n \"dental care work\"\n \"educational work school nutrition work and other work required to operate a school facility\"\n \"elections work\"\n \"emergency response\"\n \"family or child care\"\n \"grocery stores restaurants food production and food delivery\"\n \"health care\"\n \"home- and community-based health care or assistance with activities of daily living\"\n \"laundry work\"\n \"maintenance work\"\n \"medical testing and diagnostics\"\n \"pharmacy\"\n \"public health work\"\n \"sanitation disinfection and cleaning work\"\n \"social services work\"\n \"solid waste or hazardous materials management response and cleanup work\"\n \"transportation and warehousing\"\n \"vital services to Tribes\"\n \"work at hotel and commercial lodging facilities that are used for COVID-19 mitigation and containment\"\n \"work in a mortuary\"\n \"work in critical clinical research development and testing necessary for COVID-19 response\"\n \"work requiring physical interaction with patients \"\n \"Other\"","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","AL, AK, AS, AZ, AR, CA, CO, CT, DE, DC, FM, FL, GA, GU, HI, ID, IL, IN, IA, KS, KY, LA, ME, MH, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, MP, OH, OK, OR, PW, PA, PR, RI, SC, SD, TN, TX, UT, VT, VI, VA, WA, WV, WI, WY","N/A","N/A","N/A"]
["Data Type ",null,"String","Numeric","Numeric","String","Pick List","Currency","Date","Pick List","String","String","Date","Date","String","String","String","String","Pick List","Numeric","Numeric","String"]
["Max Length",null,12,9,20,20,30,"12,2","mm/dd/yyyy",30,100,3000,"mm/dd/yyyy","mm/dd/yyyy",120,120,120,40,2,5,4,750]
["Suggested validations"]
["Partner Guidance",null,"The Sub-recipient's Unique Entity Identifier (UEI) created in SAM.gov. NOTE: Sub-recipients must provide one\nof the following numbers: -UEI, or -TIN","The Subrecipient's Internal Revenue Service (IRS) Taxpayer Identification Number. NOTE: Sub-recipients must provide one of the following numbers: -UEI, or -TIN","Recipient Project ID associated with this Sub Award. This is your unique Project Identification Number.","Recipient's internal account number for the grant, contract, transfer, or direct payment. This can be the account number, or any other unique identifying number assigned by the Recipient to the award. This number is strictly for the Recipient's recordkeeping","The type of Subaward.","Total amount of SLFRF funds obligated by the Recipient to a Subrecipient under a given Subaward.","The date the Recipient obligated funds to a Subrecipient.","Select Primary Sector from picklist.","Explanation if the Primary Sector is “Other”","Recipients must submit a written justification to Treasury describing how the premium pay or grant is responsive to workers performing essential work during the public health emergency unless the worker or groups of workers receiving premium pay meet one of two criteria: (1) the eligible worker(s) receiving premium pay earn (with the premium included) below 150 percent of their residing state or county’s average annual wage for all occupations, as defined by the Bureau of Labor Statistics Occupational Employment and Wage Statistics; or (2) the eligible worker(s) receiving premium pay is not exempt from the Fair Labor Standards Act overtime provisions.","The date on which efforts begin or the Subaward is otherwise effective.","The date on which all effort is completed or the Subaward is otherwise ended.","First line of the address where the predominant performance of the Subaward will be accomplished.","Second line of the address where the predominant performance of the Subaward will be accomplished.","Third line of the address where the predominant performance of the Subaward will be accomplished.","The name of the city where the predominant performance of the Subaward will be accomplished.","United States Postal Service (USPS) two-letter abbreviation for the state or territory indicating where the predominant performance of the Subaward will be accomplished.","United States ZIP code (five digits) identifying where the predominant performance of the subaward will be accomplished.","United States ZIP code (four digits) identifying where the predominant performance of the Subaward will be accomplished.","A description of the overall purpose and expected outputs and outcomes or results of the funded subaward, including significant deliverables and, if appropriate, associated units of measure. The purpose and outcomes or results should be stated in terms that allow an understanding that the subaward constitutes an eligible use of funds."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Label",null,"Subrecipient UEI","Subrecipient TIN","Project ID","SubAward Number (unique identifier)","SubAward Type","SubAward Amount (Obligation)","SubAward Award Date","Primary Sector","If Other","Purpose of funds","Period of Performance Start Date ","Period of Performance End Date ","Primary Place of Performance Address Line 1 ","Primary Place of Performance Address Line 2","Primary Place of Performance Address Line 3","Primary Place of Performance City Name ","Primary Place of Performance State Code ","Primary Place of Performance Zip","Place of Performance Zip4","SubAward Description"]
["Users will complete these fields, may do multiple rows "]

{"sheet":"Expenditures > 50000","index":10,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["treasury template reference",null,"expendituresGT50000BulkUpload","expendituresGT50000BulkUpload","expendituresGT50000BulkUpload","expendituresGT50000BulkUpload"]
["Treasury Column Title (Field ID)",null,"Sub_Award_Lookup__c","Expenditure_Start__c","Expenditure_End__c","Expenditure_Amount__c"]
["Required/Optional?",null,"Required","Required","Required","Required"]
["Field definition (expected contents)",null,"Subaward IDs that allows the Recipient to associate Expenditure records to Subaward records. Enter Subaward Number. Subaward Number is not required if Expenditure Category is \"Administrative Cost\".","Start date for the range of time when the expenditure(s) occurred. \nDate Format MM/DD/YYYY.\n(8 Character max).","End date for the range of time when the expenditure(s) occurred.\nDate Format MM/DD/YYYY.\n(8 Character max).","Total amount of State Local Fiscal Recovery Funds dollars on the Sub-Award. \nDo not enter $ Sign when entering amount. "]
["List Values",null,"N/A","N/A","N/A","N/A"]
["Data Type ",null,"String","Date","Date","Currency"]
["Max Length",null,20,"mm/dd/yyyy","mm/dd/yyyy","12,2"]
["Suggested validations"]
["Partner Guidance",null,"Subaward number that allows the Recipient to associate Expenditure records to Subaward records. Enter Subaward Number. Subaward Number is not required if Expenditure Category is \"Administrative Cost\".","Start date for the range of time when the expenditure(s) occurred.","End date for the range of time when the expenditure(s) occurred.","Total amount of SLFRF dollars on the Subaward."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Column Label",null,"SubAward Number (unique identifier)","Expenditure Start Date","Expenditure End Date","Total Expenditure Amount"]
["Users will complete these fields, may do multiple rows "]

{"sheet":"Aggregate Awards < 50000","index":11,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"Recipient Project Id",null,"Total Period Obligation Amount (Aggregates)","Total Period Expenditure Amount  (Aggregates)"]
["treasury template reference",null,"expendituresLT50000BulkUpload\n\npaymentsIndividualsLT50000BulkUpload","expendituresLT50000BulkUpload\n\npaymentsIndividualsLT50000BulkUpload","expendituresLT50000BulkUpload\n\npaymentsIndividualsLT50000BulkUpload","expendituresLT50000BulkUpload\n\npaymentsIndividualsLT50000BulkUpload"]
["Treasury Column Title (Field ID)",null,"Project_Identification_Number__c","Sub_Award_Type_Aggregates_SLFRF__c","Quarterly_Obligation_Amt_Aggregates__c","Quarterly_Expenditure_Amt_Aggregates__c"]
["Required/Optional?",null,"Required","Required","Required","Required"]
["Field definition (expected contents)",null,"Recipient Project Id associated with this Sub Award. This is your Project Identification Number.   ","The Sub-Award Type that had obligation or expenditure/payment activity during the reporting period. Selection Required. Copy and Paste from the helptext minus the quoations (\" \"). Valid entires\n \"Aggregate of Contracts Awarded\"\n \"Aggregate of Grants Awarded\"\n \"Aggregate of Loans Issued\"\n \"Aggregate of Transfers\"\n \"Aggregate of Direct Payments\"\n","Sum of sub-award amounts/obligations during the most recent period for this Sub-Award Type (Aggregates). \nDO NOT enter $ sign when entering amount. ","Sum of Expenditures or Payments during the most recent period for this Sub-Award Type (Aggregates). \nDO NOT enter $ sign when entering amount. "]
["List Values",null,"N/A"," \"Aggregate of Contracts Awarded\"\n \"Aggregate of Grants Awarded\"\n \"Aggregate of Loans Issued\"\n \"Aggregate of Transfers\"\n \"Aggregate of Direct Payments\"\nPayments to Individuals","N/A","N/A"]
["Data Type ",null,"Numeric","Pick List","Currency","Currency"]
["Max Length",null,20,"N/A","12, 2","12, 2"]
["Suggested validations"]
["Partner Guidance",null,"Recipient Project ID that allows the Recipient to associate Expenditure records to Project records.","The Subaward Type that had obligation or expenditure/payment activity during the reporting period.","Sum of sub-award amounts/obligations during the most recent period for this Sub-Award Type (Aggregates).","Sum of Expenditures or Payments during the most recent period for this SubAward Type (Aggregates)."]
[null,null,{"$f":"Cover!$D$2","v":0}]
["Column Label",null,"Project ID","Aggregate Sub Award Type","Current Quarter Obligation","Current Quarter Expenditure/Payments"]
["Users will complete these fields, may do multiple rows "]

{"sheet":"Summary","index":12,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["CRF Project Summary Financial Report"]
["Agency Code",{"$f":"Cover!A2","v":0}]
["Project ID",{"$f":"Cover!B2","v":0}]
["Project Name"]
["Reporting Period End Date",{"$f":"Cover!F2","v":"00:00:00"}]
[]
["Award Type","Award Amounts (Awards ≥ $50,000 only)",null,"Obligations - Prior Periods","Current Reporting Period Obligation Amounts","Cumulative Obligation Amounts",null,"Expenditures - Prior Periods","Current Reporting Period Expenditure Amounts","Cumulative Expenditure Amounts",null,"Award Balance - Prior Periods","Award Balance - Current Period","Cumulative Award Balance"]
["Contract Amounts",{"$f":"SUM('Awards > 50000'!H13:H3009)","v":0},null,null,null,null,null,0,{"$f":"SUM('Awards > 50000'!#REF!)","v":{"$error":"#REF!"}},{"$f":"H8+I8","v":{"$error":"#REF!"}},null,null,null,{"$f":"B8-J8","v":{"$error":"#REF!"}}]
["Grant Amounts",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,0,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"H9+I9","v":{"$error":"#REF!"}},null,null,null,{"$f":"B9-J9","v":{"$error":"#REF!"}}]
["Loan Amounts",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,0,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["Transfer Amounts",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,0,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["Direct Payments",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,0,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["Contracts < $50k",null,null,0,{"$f":"'Aggregate Awards < 50000'!E13","v":0},{"$f":"D13+E13","v":0},null,0,{"$f":"'Aggregate Awards < 50000'!F13","v":0},0,null,null,null,{"$f":"F13-J13","v":0}]
["Grants < $50k",null,null,0,{"$f":"'Aggregate Awards < 50000'!#REF!","v":{"$error":"#REF!"}},{"$f":"D14+E14","v":{"$error":"#REF!"}},null,0,{"$f":"'Aggregate Awards < 50000'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$f":"F14-J14","v":{"$error":"#REF!"}}]
["Loans < $50k",null,null,0,{"$f":"'Aggregate Awards < 50000'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0,{"$f":"'Aggregate Awards < 50000'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["Transfers < $50k",null,null,0,{"$f":"'Aggregate Awards < 50000'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0,{"$f":"'Aggregate Awards < 50000'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["Direct Payments < $50k",null,null,0,{"$f":"'Aggregate Awards < 50000'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0,{"$f":"'Aggregate Awards < 50000'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["Pmts to Individuals",null,null,0,{"$f":"'Aggregate Awards < 50000'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["CRF Project TOTALS",{"$f":"SUM(B8:B18)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D8:D18)","v":0},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"SUM(H8:H18)","v":0},{"$f":"SUM(I8:I18)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$f":"SUM(N8:N18)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Negative Cumulative Award Balances will cause your upload to fail and/or require corrections.  "]
[null,null,null,null,null,null,null,"Add instructions to this tab?",null,null,null,"Correct data on relevant tab(s).  Please do NOT change this tab."]
[null,null,null,null,null,null,null,null,"Lock columns I, J.  Still allows data to be pasted from J to H"]

{"sheet":"Dropdowns","index":13,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Tab","Cover ","Cover ","Cover ","Multiple","Multiple","Multiple","Multiple","Expenditures","Aggregate Awards","Multiple","Metrics 5","Metrics 1","Multiple","Subrecipient  ","Expenditures"]
["Field","Agency Code","Expenditure Category Group","Detailed Expenditure Category","State Code","Country","Project Status","Yes/No Questions","Types","Funding Type","Sectors Designated as Essential Critical Infrastructure","Location (for broadband, geospatial location data)","Project Demographics","Capital Expenditure Type","Subrecipient  ","Broadband Type"]
["Dropdown Options","BOR77700","<< Values contained on Logic sheet >>","<< Values contained on Logic sheet >>","AL","United States","Not started","Yes","Contract: Purchase Order","Aggregate of Contracts Awarded","Any work performed by an employee of a State local or Tribal government","Latitude/longitude (WGS84 or NAD83 geographic coordinate system)","1 Imp General Public","Acquisition of equipment for COVID-19 prevention and treatment","Subrecipient","Fiber"]
[null,"CME49500",null,null,"AK","Canada","Completed less than 50%","No","Contract: Delivery Order","Aggregate of Grants Awarded","Behavioral health work","Address","2 Imp Low or moderate income HHs or populations","Adaptations to congregate living facilities","Contractor","Coaxial Cable"]
[null,"CSL66000",null,null,"AS","Mexico","Completed 50% or more",null,"Contract: Blanket Purchase Agreement","Aggregate of Loans Issued","Biomedical Research","Address Range","3 Imp HHs that experienced unemployment","Affordable housing, supportive housing, or recovery housing","Beneficiary","Terrestrial Fixed Wireless"]
[null,"DAG42500",null,null,"AZ",null,"Completed",null,"Contract: Definitive Contract","Aggregate of Transfers","Dental care work","Road Segment","4 Imp HHs that experienced increased food or housing insecurity","Behavioral health facilities and equipment",null,"Other (specify)"]
[null,"DAS23000",null,null,"AR",null,null,null,"Grant: Lump Sum Payment(s)","Aggregate of Direct Payments","Educational work school nutrition work and other work required to operate a school facility",null,"5 Imp HHs that qualify for certain federal programs","Childcare, daycare and early learning facilities"]
[null,"DCF91000",null,null,"CA",null,null,null,"Grant: Reimbursable","Payments to Individuals","Elections work",null,"6 Imp For services to address lost instructional time in K-12 schools","COVID-19 testing sites and laboratories, and acquisition of related equipment"]
[null,"DCJ30000",null,null,"CO",null,null,null,"Direct Payment",null,"Emergency response",null,"7 Imp Other HHs or populations that experienced a negative economic","COVID-19 vaccination sites"]
[null,"DDS50000",null,null,"CT",null,null,null,"Transfer: Lump Sum Payment(s)",null,"Family or childcare",null,"8 Imp SBs that experienced a negative economic impact","Devices and equipment that assist households in accessing the internet"]
[null,"DEP43000",null,null,"DE",null,null,null,"Transfer: Reimbursable",null,"Grocery stores restaurants food production and food delivery",null,"9 Imp Classes of SBs designated as negatively economically impacted","Emergency operations centers and acquisition of emergency response equipment"]
[null,"DHE66500",null,null,"DC",null,null,null,"Loan - maturity prior to 12/31/26 with planned forgiveness",null,"Health care",null,"10 Imp NPs that experienced a negative economic impact specify","Food banks and other facilities"]
[null,"DMV35000",null,null,"FM",null,null,null,"Loan - maturity prior to 12/31/26 without planned forgiveness",null,"Home- and community-based health care or assistance with activities of daily living",null,"11 Imp Classes of NPs designated as negatively economically impacted","Improvements to existing facilities"]
[null,"DOC88000",null,null,"FL",null,null,null,"Loan - maturity past 12/31/26 with planned forgiveness",null,"Laundry work",null,"12 Imp Travel tourism or hospitality sectors","Installation and improvement of ventilation systems"]
[null,"DOH46900",null,null,"GA",null,null,null,"Loan - maturity past 12/31/26 without planned forgiveness",null,"Maintenance work",null,"13 Imp Industry outside the travel tourism or hospitality sectors specify","Job and workforce training centers"]
[null,"DOL40000",null,null,"GU",null,null,null,null,null,"Medical testing and diagnostics",null,"14 Dis Imp Low income HHs and populations","Medical equipment and facilities"]
[null,"DOT57000",null,null,"HI",null,null,null,null,null,"Pharmacy",null,"15 Dis Imp HHs and populations residing in Qualified Census Tracts","Medical facilities generally dedicated to COVID-19 treatment and mitigation"]
[null,"DPH48500",null,null,"ID",null,null,null,null,null,"Public health work",null,"16 Dis Imp HHs that qualify for certain federal programs","Mitigation measures in small businesses, nonprofits and impacted industries"]
[null,"DPS32000",null,null,"IL",null,null,null,null,null,"Sanitation disinfection and cleaning work",null,"17 Dis Imp HHs receiving services provided by Tribal governments","Parks, green spaces, recreational facilities, sidewalks"]
[null,"DRS16000 ",null,null,"IN",null,null,null,null,null,"Social services work",null,"18 Dis Imp HHs residing in the U.S. territories or receiving services","Public health data systems"]
[null,"DSS60000",null,null,"IA",null,null,null,null,null,"Solid waste or hazardous materials management response and cleanup work",null,"19 Dis Imp For services to address educational disparities Title I eligible","Rehabilitations, renovation, remediation, cleanup, or conversions"]
[null,"ECD46000",null,null,"KS",null,null,null,null,null,"Transportation and warehousing",null,"20 Dis Imp Other HHs or populations that experienced a disproportionate","Schools and other educational facilities"]
[null,"GOV12000",null,null,"KY",null,null,null,null,null,"Vital services to Tribes",null,"21 Dis Imp SBs operating in Qualified Census Tracts","Technology and equipment to allow law enforcement"]
[null,"JUD95000",null,null,"LA",null,null,null,null,null,"Work at hotel and commercial lodging facilities that are used for COVID-19 mitigation and containment",null,"22 Dis Imp SBs operated by Tribal governments or on Tribal lands","Technology and tools"]
[null,"MHA53000",null,null,"ME",null,null,null,null,null,"Work in a mortuary",null,"23 Dis Imp SBs operating in the U.S. territories","Technology infrastructure to adapt government operations"]
[null,"OEC64800",null,null,"MH",null,null,null,null,null,"Work in critical clinical research development and testing necessary for COVID-19 response",null,"24 Dis Imp Other SBs Dis Imp by the pandemic specify","Temporary medical facilities and other measures"]
[null,"OHS49450",null,null,"MD",null,null,null,null,null,"Work requiring physical interaction with patients",null,"25 Dis Imp NPs operating in Qualified Census Tracts","Transitional shelters"]
[null,"OLM10000",null,null,"MA",null,null,null,null,null,"Other",null,"26 Dis Imp NPs operated by Tribal governments or on Tribal lands","Other (please specify)"]
[null,"OPM20000",null,null,"MI",null,null,null,null,null,null,null,"27 Dis Imp NPs operating in the U.S. territories"]
[null,"PDS98500",null,null,"MN",null,null,null,null,null,null,null,"28 Dis Imp Other NPs Dis Imp by the pandemic specify"]
[null,"PST34000",null,null,"MS"]
[null,"SDE64000",null,null,"MO"]
[null,"SDR63500",null,null,"MT"]
[null,"UHC72000",null,null,"NE"]
[null,"UOC67000",null,null,"NV"]
[null,null,null,null,"NH"]
[null,null,null,null,"NJ"]
[null,null,null,null,"NM"]
[null,null,null,null,"NY"]
[null,null,null,null,"NC"]
[null,null,null,null,"ND"]
[null,null,null,null,"MP"]
[null,null,null,null,"OH"]
[null,null,null,null,"OK"]
[null,null,null,null,"OR"]
[null,null,null,null,"PW"]
[null,null,null,null,"PA"]
[null,null,null,null,"PR"]
[null,null,null,null,"RI"]
[null,null,null,null,"SC"]
[null,null,null,null,"SD"]
[null,null,null,null,"TN"]
[null,null,null,null,"TX"]
[null,null,null,null,"UT"]
[null,null,null,null,"VT"]
[null,null,null,null,"VA"]
[null,null,null,null,"VI"]
[null,null,null,null,"WA"]
[null,null,null,null,"WV"]
[null,null,null,null,"WI"]
[null,null,null,null,"WY"]

{"sheet":"EC6.1 Provision of Gov Services","index":14,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Project Identification Number (SID):"]
["Title:"]
["Project Description:"]
["Completion Status:"]
["Total Cumulative Obligations:"]
["Total Cumulative Expenditures:"]
["Current Period Obligations:"]
["Current Period Expenditures:"]

{"sheet":"ARPA Projects Requiring Reports","index":15,"n_rows":111,"n_cols":8,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
["Department \n(Implementing)","Implementing Agency \nCode","SID","Legal\nReference","Title","Project Description\n(250 word limit)","Treasury Expenditure Category","Evidence-Based Intervention or Program Eval Required"]
["BOARD OF REGENTS","BOR77700",29691,"PA 21-2 (JSS), Section 306","Enhance Student Retention at Community Colleges","In response to declining student achievement retention and a corresponding loss of tuition and fee revenue that has been exacerbated by the COVID-19 pandemic the Connecticut community colleges are implementing Guided Pathways Advising a â€œholistic case management advising modelâ€\u009dÂ  With partial support from State Fiscal Relief funding Guided Pathways Advising will be implemented at scale across all 12 Connecticut community colleges beginning in FY 22 Under the program Connecticut community colleges will hire 158 advisors and eight other supervisory and support staff over a 3-year period","2.37 - Economic Impact Assistance Other","Yes"]
["CONNECTICUT STATE COLLEGES AND UNIVERSITIES","BOR77700",29692,"PA 21-2 (JSS), Section 306","Higher Education – CSCU","Support is provided to Connecticut State Colleges and University CSCU for the provision of public services This allocation from Connecticutâ€™s State Fiscal Recovery Fund award will be used to support adjunct faculty necessary to provide adequate course availability to students at CSCU institutionsÂ  Without these funds fiscal constraints would require these institutions to eliminate a large number of course sections across 16 institutionsÂ  Given CSCUâ€™s CDC-compliant social distancing protocols which limit class size based on room the students served by adjunct faculty in these courses would have difficulty finding alternatives within the system resulting in deferred completion further decreased revenue for the system and diminished student success","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF AGING AND DISABILITY SERVICES","SDR63500",29798,"PA 21-2 (JSS), Section 306","Blind and Deaf Community Supports","Funding will address deficiencies in support services for individuals who are blind deaf hard of hearing or deafblind. This may include purchase of clear masks, specialized vaccine clinic supports, and informational videos communication cards and interpreter services for the deaf community,  Additionally funding is provided in response to reduced operations at the Library for the Blind in Rocky Hill in order to provide comparable services to the blind community and to expand the library's programming.","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF AGRICULTURE","DAG42500",29694,"PA 21-2 (JSS), Section 306","Farmer's Market Nutrition ","The funds will be used to increase the value of the check booklets provided to WIC participants facing food insecurity due to the negative economic impacts of the COVID-19 pandemic This year check booklets increased from 15 to 21 to purchase fresh fruits and vegetables at participating Connecticut farmersâ€™ markets and farm stands","2.1 - Household Assistance: Food Programs","Yes"]
["DEPARTMENT OF AGRICULTURE","DAG42500",29695,"PA 21-2 (JSS), Section 306","Farm-to-School Grant","CTG4CTK is a grant program to support and establish farm to school programs in schools school districts childcare centers and homes Farm to school enriches the connection communities have with fresh healthy food and local food producers by changing food purchasing and education practices at schools and early care and education sites Students gain access to healthy local foods as well as education opportunities such as school gardens cooking lessons and farm field trips","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF AGRICULTURE","DAG42500",29696,"PA 21-2 (JSS), Section 306","Food Insecurity Grants to Food Pantries and Food Banks","In partnership with End Hunger CT! funds will enable SNAP participants who have faced an increase in food insecurity due to the negative economic impacts of the COVID-19 pandemic to double the value of their SNAP benefits to purchase CT Grown farm products at participating Connecticut farmer stands and at farmersâ€™ markets EndHunger CT!â€™s Full Shelves Pantry Program which supports food pantries and social service organizations with bulk purchases of food This program enables organizations to achieve economies of scale through bulk purchase of food access to a more diverse selection of foods and the efficient delivery of those foods than can be achieved independently which assists low to moderate communities with improving accessibly to food to individuals and families that have felt the negative economic impacts of the COVID-19 pandemic","2.1 - Household Assistance: Food Programs","Yes"]
["DEPARTMENT OF AGRICULTURE","DAG42500",29693,"PA 21-2 (JSS), Section 306","Senior Food Vouchers ","The funds will be used to increase the value of the check booklets provided to seniors over the age of 60 and disabled individuals living in congregate housing where nutrition services are provided Eligible program participants facing increased faced food insecurity due to the negative economic impacts of the COVID-19 pandemic will receive check booklets that were increased in value from 15 to 21 to purchase fresh fruits and vegetables at participating Connecticut farmersâ€™ markets and farm stands","2.1 - Household Assistance: Food Programs","Yes"]
["DEPARTMENT OF CHILDREN AND FAMILIES","DCF91000",29780,"PA 21-2 (JSS), Section 306","Casa Boricua-Meriden","Located in a qualified census tract Casa Boricua De Meriden Inc works to improve the education health and well-being the hispaniclatino community of Greater Meriden  Funds will support case managementassistance with public benefits determinations and referrals to health services  Casa Boricuas clients seek information assistance with form completion translation services and referrals to appropriate service providers to satisfy basic needs and maintain satisfactory life function","2.19 - Social Determinants of Health: Community Health Workers or Benefits Navigators","Yes"]
["DEPARTMENT OF CHILDREN AND FAMILIES","DCF91000",29782,"PA 21-2 (JSS), Section 306","Child First","Child First is a home visiting model that is targeted to serve families that present with the highest level of need for this service type.  Utilizing an evidence based psycho-educational model this service provides home-based assessment family plan development parent-child therapeutic intervention and education and care coordinationcase management for high-risk families with children under six years of age including pregnant women in order to decrease social-emotional and behavioral problems developmental and learning problems and abuse and neglect.  ARPA funding will allow for essentially doubling the capacity of Child First service teams statewide. An estimated 44% of all Child First families reside at a Qualified Census Tract address and at a minimum 25% of all those served are on the child welfare caseload.  DCF families have been waitlisted for Child First services historically and there is ample need within the child welfare-involved population alone to fill all the newly available capacity that would be added to pre-existing contracted capacity","2.12 - Healthy Childhood Environments: Home Visiting","Yes"]
["DEPARTMENT OF CHILDREN AND FAMILIES","DCF91000",29781,"PA 21-2 (JSS), Section 306","Children's Mental Health Initiatives","Will support various initiatives including expanding hours of operation of mobile crisis intervention teams to provide 247 response statewide; establishing intensive transition care management services to expedite and facilitate the timely and safe transition of children from acute levels of care to the community; creation of an urgent crisis center to provide immediate care to children having a behavioral health episode who are in need of an urgent response to divert children from emergency departments; interventions to address trauma experienced by youth residing in urban communities; and expanded data analysis related to racial equity and justice in behavioral health to be utilized to improve provider specific program performance","1.12 - Mental Health Services","Yes"]
["DEPARTMENT OF CHILDREN AND FAMILIES","DCF91000",29779,"PA 21-2 (JSS), Section 306","Fostering the Community ","Fostering the Community will develop an educational on-line database portal of trainings and articles for foster parents to access.  The materials will address the behavioral health challenges that foste children are experiencing most frequently due to COVID-19.  Trainings will be in the form of written content from experts in foster care issues and recorded video trainings.  Funds will be used for three purposes to contract with an IT consultant to create the portal and assista with technical aspects of postingaccessing trainings; to reimburse behavioral health professions for the production of live and recorded trainings and the collection of other print materials; and community outreach to determine topics of interest and share upcomgin events and training resources for foster parents","2.13 - Healthy Childhood Environments: Services to Foster Youth or Families Involved in Child Welfare System","Yes"]
["DEPARTMENT OF CORRECTION","DOC88000",29786,"PA 21-2 (JSS), Section 306","TRUE Unit - Cheshire CI ","Program enhancements implementing a nationally recognized correction model that expands services to reduce recidivism among young men  aged 18-24 and emphasizes personal dignity and developmentally appropriate programming","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF CORRECTION","DOC88000",29788,"PA 21-2 (JSS), Section 306","Vocational Village Dept Corrections","Program funding based on a national model where participants' workforce skills are developed to fill in-demand jobs in the community. A coordinated effort between DOC's Correctional Enterprises and Unified School District  1 to provide inmates with both the work experience and classroom instruction necessary for industry-recognized credentials in employment sectors which are in need of workers and that hire Returning Citizens Funding will be used for startup and capital costs constructionfit up equipment etc.","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF CORRECTION","DOC88000",29787,"PA 21-2 (JSS), Section 306","WORTH Program York CI ","Program enhancements implementing a nationally recognized correction model that expands services to reduce recidivism among young women  aged 18-24 and emphasizes personal dignity and developmentally appropriate programming","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF DEVELOPMENTAL SERVICES","DDS50000",29697,"PA 21-2 (JSS), Section 306","Respite Care for Family Caregivers","Because these populations were hit harder by aspects of COVID restrictions related to underlying health conditions or living situations funding is recommended to enhance or expand services across a variety of respite settings - - children or adults with complex behaviors related to intellectual disabilities or autism diagnoses or older adults needing adult day or alzheimers programs","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29699,"PA 21-2 (JSS), Section 306","Amistad","Funding provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic specifically revenue loss  Specifically this revenue loss was due to declines in revenue from their programs Discovering Amistad an organization purchased the Amistad CTs flagship and replica of the original schooner  The organization developed interactive curriculum with lessons conducted by trained educators in classrooms and aboard the ship  To date they have brought their program to more than 50000 students","2.35 - Aid to Tourism Travel or Hospitality","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29729,"PA 21-2 (JSS), Section 306","Ball and Sockets – Cheshire","Funding for restoring outdoor spaces that were vandalized during the pandemic as well as for replacing garage doors with glass doors that open outward from the building as well as an accessible ramp where the doors will open  This will allow for a more COVID friendly environment going forward where outdoor space can be utilized and social distancing can be implemented better","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29698,"PA 21-2 (JSS), Section 306","Beardsley Zoo","Funding to provide financial assistance due to loss of revenue- Grant to mitigate financial hardship due to a decline in revenues or impacts of periods of business closure funds to support payroll and benefits costs costs to retain employees mortgage rent or utilities costs and other operating costs  Due to the pandemic admissions and ticket sales for the zoo declined drastically  Additionally there was a revenue decline in their programs and services due to limited in person programs and capacity restrictions","2.35 - Aid to Tourism Travel or Hospitality","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29717,"PA 21-2 (JSS), Section 306","Beta Iota Boule Foundation -Youth Services","Funding will be provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic or support program engagement for disproportionately impacted families","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29709,"PA 21-2 (JSS), Section 306","Charter Oak Temple Restoration Association","Funding provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29719,"PA 21-2 (JSS), Section 306","Connecticut Center for Advanced Technologies","In collaboration with regional sector partners in high-demand manufacturing and technology industries initiatives will focus on unemployed and underemployed workers considering career changes into manufacturing and expanding the recruitment training and retention of a diverse and highly skilled workforce CCAT staffing will also support the wind alternative energy and battery companies in Connecticut in planning for opportunities post COVID","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29705,"PA 21-2 (JSS), Section 306","Connecticut Main Street Center","Funding is utilized by this entity to provide technical assistance counseling or other services to assist with business planning needs that responds to the negative economic impacts of COVID-19  This funding is anticipated to hep businesses who were affected by quarantines changing safety regulations and evolving customer behaviors by providing an education series that focuses on how communities Main Street and businesses can survive and thrive during this new time","2.30 - Technical Assistance Counseling or Business Planning","Yes"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29707,"PA 21-2 (JSS), Section 306","CRDA Economic Support for Venues","Funding used to mitigate significant decline in revenue at the Connecticut Convention Center the XL Center and Pratt and Whitney Stadium due to the loss of revenue from events in just FY 2022 as a result of the COVID-19 pandemic  Specifically this is due to the cancellation of events and capacity restrictions on events once they were able to resume","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29725,"PA 21-2 (JSS), Section 306","CT Hospitality Industry Support","Funding provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic specifically revenue loss  Specifically this revenue loss was due to declines in utilization resulting from capacity restrictions use and other public health guidelines or from periods of closure due to the pandemic","2.35 - Aid to Tourism Travel or Hospitality","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29839,"PA 21-2 (JSS), Section 306","CT Hospitality Industry Support - Small Business Support"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29714,"PA 21-2 (JSS), Section 306","East Hartford Little League","Funding will be provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic or support program engagement for disproportionately impacted families","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29716,"PA 21-2 (JSS), Section 306","ESF/Dream Camp of Hartford","Funding will be provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic or support program engagement for disproportionately impacted families","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29713,"PA 21-2 (JSS), Section 306","Family Justice Center"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29715,"PA 21-2 (JSS), Section 306","Hartford YMCA","Funding provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic specifically revenue loss  Specifically this revenue loss was due to declines in admission and ticket sales as well as decreased revenue from their programs and lowered memberships and subscriptions during the course of the pandemic","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29727,"PA 21-2 (JSS), Section 306","Historic Wooster Square  Association"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29728,"PA 21-2 (JSS), Section 306","Humane Commission/Animal Shelter of New Haven","Funding provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic specifically revenue loss The Humane Commission addresses policy issues regarding animal welfare at the Robin I Kroogman New Haven Animal Shelter and throughout the City of New Haven Connecticut  The New Haven Humane Commission is appointed by the Mayor to provide animal welfare oversight including the authority to adopt such rules and regulations that in its judgment are required for the operation of the animal shelter and related activities and for the proper care and treatment of animals within the city limits","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29730,"PA 21-2 (JSS), Section 306","Junta for Progressive Action","Funding will be provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic or support program engagement for disproportionately impacted families","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF PUBLIC HEALTH","DPH48500",29718,"PA 21-2 (JSS), Section 306","Legacy Foundation of Hartford","Funds would be provided to The Legacy Foundation of Hartford to address the impact of COVID-19 on the children support by their scholarly program Funding will go towards transportation for excursions supplies for programming and materials to help make indoor and outdoor sessions safer for all involved such as a pop-up tent and air purifiers With the support of this funding The Legacy Foundation will support scholars build back their academic social and emotional development while continuing to provide opportunities for building healthy habits and personal growth","1.9 - COVID-19 Assistance to Non-Profits","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29700,"PA 21-2 (JSS), Section 306","Maritime Center Authority","Funding provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic specifically revenue loss  Specifically this revenue loss was due to declines in admission and ticket sales as well as decreased revenue from their programs and lowered memberships and subscriptions during the course of the pandemic","2.35 - Aid to Tourism Travel or Hospitality","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29720,"PA 21-2 (JSS), Section 306","Middlesex YMCA","These funds would be used for the upgrade of the HVAC system in the gym and basement of the YMCA This is where Emergency Childcare and Distance Learning classrooms were housed and the programs took place This is also the area that is used for Vacation Day programs Summer Enrichment Camp Preschool programs Teen Programs and a variety of other children and adult programs throughout the year The upgrade was necessary to adequately filter the air to eliminate the COVID-19 virus and improve ventilation to improve the health and safety of members and those who visit the Y","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29706,"PA 21-2 (JSS), Section 306","Middletown Downtown Business District","The seven walkable blocks of Main Street home to nearly 200 independent businesses  Some of the businesses include museums The Library Studio the Inn at Middletown restaurants and coffee shops Amatos Toy and Hobby Middlesex Music Academy Farmers Market etc This project will reinvigorate the downtown store fronts that suffered as a result of the pandemic","2.31 - Rehabilitation of Commercial Properties or Other Improvements","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29702,"PA 21-2 (JSS), Section 306","Music Haven ","Funding provided to mitigate financial hardship as this entity experienced negative economic impacts from the pandemic specifically revenue loss  Specifically this revenue loss was due to declines in admission and ticket sales for concerts fee-based workshops and fundraisers  Due to limited concert capacity ticket sales declined and other in person workshops and events were cancelled which decreased program revenue as well","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29701,"PA 21-2 (JSS), Section 306","Mystic Aquarium","Funding provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic specifically revenue loss  Specifically this revenue loss was due to declines in admission and ticket sales as well as decreased revenue from their programs and lowered memberships and subscriptions during the course of the pandemic","2.35 - Aid to Tourism Travel or Hospitality","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29703,"PA 21-2 (JSS), Section 306","Norwalk Symphony ","Funding provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic specifically revenue loss  Specifically this revenue loss was due to declines in admission and ticket sales as well as decreased revenue from their programs and services This entity was unable to present live music performances during the pandemic and is still performing at limited capacity which creates a gap in ticket sales and reduces this entitys revenue","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29712,"PA 21-2 (JSS), Section 306","Playhouse on Park","Performing arts theater in West Hartford CT offering contemporary plays and musicals plays comedy and childrens shows  Specifically they provide quality entertainment at affordable costs offer educational and outreach opportunities through visiting and resident artists and educators and embrace and provide opportunities for professional emerging and community artists The funds will be used to support increased costs and revenue losses due to COVID","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29726,"PA 21-2 (JSS), Section 306","Regulatory Modernization","Invest in a modernized regulatory and licensing infrastructure for ease of access making it easier to start and run a business in Connecticut","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29704,"PA 21-2 (JSS), Section 306","Riverfront Recapture ","Funding provided to mitigate financial hardship as this entity experienced negative economic impacts from the pandemic The nonprofit leads the effort to revitalize the banks of CT River in Hartford and East Hartford   This nonprofit also maintains the parks coordinates and hosts events and provides opportunities for recreation and outdoor adventures","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29721,"PA 21-2 (JSS), Section 306","Shatterproof","Host a web-based platform which help people seeking treatment family members providers and others looking for quality care","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29723,"PA 21-2 (JSS), Section 306","Statewide Marketing","Funding is anticipated to support the  financial hardship of disproportionately impacted business as a direct result of the  negative economic impacts from the pandemic such as hospitality and tourism venues Technical assistance to include year round multicultural multilingual tourism campaigns driving economic recovery in the tourism and hospitality sectors that continue to experience economic decline due to COVID 19","2.35 - Aid to Tourism Travel or Hospitality","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29722,"PA 21-2 (JSS), Section 306","Summer Experience at Connecticut's Top Venues","Provides for free museum access at for children with one adult family member to promote the states summer learning objectives as well as marketing of the free museum access program","2.35 - Aid to Tourism Travel or Hospitality","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29722,"PA 21-2 (JSS), Section 306","Summer Experience at Connecticut's Top Venues","Provides for free museum access at for children with one adult family member to promote the states summer learning objectives as well as marketing of the free museum access program","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29838,2021,"Upper Albany Neighborhood Collaborative",null,"2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29711,"PA 21-2 (JSS), Section 306","VFW Rocky Hill","Funding provided to mitigate financial hardship as this entity experience negative economic impacts from the pandemic","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29710,"PA 21-2 (JSS), Section 306","West Haven Veterans Museum","Funding to provide financial assistance due to loss of\nrevenue. The primary source for this entity's operating\nrevenues is donations. Due to museum closure this entity faced revenue loss. In addition this entity needed to create a storage area to store PPE as they were cited by a building inspector due to their space not being suitable for all the products incurred.","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF ECONOMIC AND COMMUNITY DEVELOPMENT","ECD46000",29708,"PA 21-2 (JSS), Section 306","Working Cities Challenge ","A grant competition that supports collaborative community-wide leadership and promotes ambitious initiatives to improve the lives of low-income people in Connecticutâ€™s small and mid-size cities  The initiatives extend over a three-year period and aim to spur workforce development and job creation Each initiative team receives technical assistance and shares best practices with a community of experts and like-minded groups and organizations  Funding will be split evenly between all 5 participating communities","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["DEPARTMENT OF EDUCATION","SDE64000",29735,"PA 21-2 (JSS), Section 306","Ascend Mentoring – Windsor","The Connecticut State Department of Education is still in the preliminary phases of scoping out this project Ascend mentoring is an organization that serves children ages 12-18  in Windsor Public Schools with three areas of focus employment services mental health resources and financial planning Windsor is a high need district which serves 4421 Free and Reduced Lunch Students","2.25 - Addressing Educational Disparities: Academic Social and Emotional Services","Yes"]
["DEPARTMENT OF EDUCATION","SDE64000",29734,"PA 21-2 (JSS), Section 306","CT Writing Project ","The Connecticut State Department of Education is still in the preliminary phases of scoping out this project The CT Writing Project  an affiliate of the National Writing Project dedicated to improving studentsâ€™ writing by strengthening the teaching of writing providing professional development programs for classroom teachers and expanding the professional roles of teachers","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF EDUCATION","SDE64000",29739,"PA 21-2 (JSS), Section 306","East Hartford Youth Services ","The State Department of Education is still in the preliminary stages of scoping out this project The intended recipient East Hartford Youth Services is a Municipal Agency dedicated to providing community support counseling services and other services to youth in East Hartford","2.25 - Addressing Educational Disparities: Academic Social and Emotional Services","Yes"]
["DEPARTMENT OF EDUCATION","SDE64000",29737,"PA 21-2 (JSS), Section 306","Elevate Bridgeport","The State Department of Education is still in the preliminary stages of scoping out this project The intended recipient Elevate Bridgeport is an organization that provides additional elective classes mentoring extra-curricular activities and college and career preparation for students in Bridgeport one of Connecticuts highest need districts The exact use of these funds is still to be determined","2.25 - Addressing Educational Disparities: Academic Social and Emotional Services","Yes"]
["DEPARTMENT OF EDUCATION","SDE64000",29733,"PA 21-2 (JSS), Section 306","Faith Acts Priority School Districts","Funds will be distributed to Connecticuts Priority Districts according to a needs based formula in order to support activities related to improving student achievement enhanced educational opportunity and early reading intervention programs Priority districts are a collection of 15 of the states neediest districts as determined by measures enshrined in the states education statutes","2.24 - Addressing Educational Disparities: Aid to High-Poverty Districts","No"]
["DEPARTMENT OF EDUCATION","SDE64000",29738,"PA 21-2 (JSS), Section 306","Grant to RHAM Manufacturing Program","The State Department of Education is still in the preliminary phases of scoping out this project Funds are anticipated to support manufacturing programming at RHAM Regional High School however exact uses are still being determined in order to comply with federal guidance","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF EDUCATION","SDE64000",29743,"PA 21-2 (JSS), Section 306","Hamden Before and After School Programming","The State Department of Education is still in the preliminary stages of scoping out this project Funds will support before and after school programming in Hamden Connecticut a high need district that serves 4371 Free and Reduced Price Lunch Students Hamden is also an alliance district one of the States 33 lowest performing districts","2.24 - Addressing Educational Disparities: Aid to High-Poverty Districts","No"]
["DEPARTMENT OF EDUCATION","SDE64000",29744,"PA 21-2 (JSS), Section 306","Hamden Pre-K Programming","The State Department of Education is still in the preliminary stages of scoping out this project Funds will support Pre-K Programming in Hamden Connecticut a high need district that serves 4371 Free and Reduced Price Lunch Students Hamden is also an alliance district one of the States 33 lowest performing districts","2.24 - Addressing Educational Disparities: Aid to High-Poverty Districts","No"]
["DEPARTMENT OF EDUCATION","SDE64000",29742,"PA 21-2 (JSS), Section 306","New Haven Local Little League","The State Department of education is still in the preliminary stages of scoping out this project Funds will likely be operationalized to either provide economic support to the New Haven little league in proportion to its revenue loss or to provide enhanced programming for students in this high need LEA","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF EDUCATION","SDE64000",29732,"PA 21-2 (JSS), Section 306","Right to Read ","Funds will support the Center for Literacy Research and Success housed with the Department of Education The Center will provide intensive supports for reading and literacy programs in Connecticuts Alliance Districts the 33 lowest performing districts statewide and general oversight to reading and literacy programs statewide SDE is required to incorporate evidence based standards into this work","2.25 - Addressing Educational Disparities: Academic Social and Emotional Services","Yes"]
["DEPARTMENT OF EDUCATION","SDE64000",29740,"PA 21-2 (JSS), Section 306","Student Achievement Through Opportunity","The Connecticut State Department of Education is still in the preliminary phases of scoping out this project working with the intended recipient to determine an eligible use of funds","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF EDUCATION","SDE64000",29741,"PA 21-2 (JSS), Section 306","Summer Camp Scholarships for Families"]
["DEPARTMENT OF EDUCATION","SDE64000",29736,"PA 21-2 (JSS), Section 306","Women in Manufacturing - Platt Tech Regional Vocational Technical School","The State Department of Education is still in the preliminary phases of scoping out this project Funds are anticipated to support manufacturing programming at Platt Tech in Milford Connecticut however exact uses are still being determined in order to comply with federal guidance","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ENERGY AND ENVIRONMENTAL PROTECTION","DEP43000",29745,"PA 21-2 (JSS), Section 306","Air Quality Study "]
["DEPARTMENT OF ENERGY AND ENVIRONMENTAL PROTECTION","DEP43000",29748,"PA 21-2 (JSS), Section 306","Efficient Energy Retrofit for Housing","The funds would provide energy efficiency retrofits and access to renewable energy resources storage solar to reduce energy costs and pollution and promote equity and environmental justice for people working and learning from home","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ENERGY AND ENVIRONMENTAL PROTECTION","DEP43000",29747,"PA 21-2 (JSS), Section 306","Health and Safety Barriers to Housing Remediation","The funds would be invested into retrofit programs making homes healthier for people working and learning from home At least 30 of homes have health and safety barriers such as asbestos and mold that threaten health of residents and prevent weatherization upgrades such as insulation and efficiency measures that provide critical energy savings Weatherization services including core weatherstripping and sealing services and add-on attic and wall insulation","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF ENERGY AND ENVIRONMENTAL PROTECTION","DEP43000",29749,"PA 21-2 (JSS), Section 306","Quinnipiac Avenue Canoe Launch","The funds will be used to improve the Quinnipiac Avenue Canoe Launch to provide improved recreation for a community of need QCT","2.22 - Strong Healthy Communities: Neighborhood Features that Promote Health and Safety","No"]
["DEPARTMENT OF ENERGY AND ENVIRONMENTAL PROTECTION","DEP43000",29746,"PA 21-2 (JSS), Section 306","Swimming Lessons to DEEP","The Department of Energy and Environmental Protection will utilize funds to provide free swim lessons for children of families with limited financial ability to improve access to outdoor recreation Lessons will be provided by community organizations","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF HOUSING","DOH46900",29750,"PA 21-2 (JSS), Section 306","Downtown Evening Soup Kitchen","Serves people who are experiencing homelessness or living in poverty by providing food assistance and services including nightly dinners a weekly food pantry and drop in resource center in downtown New Haven  Funding was requested for HVAC system and an elevator that goes from the soup kitchen to the health clinic upstairs\n\nSpecifically the elevator will allow for ADA compliance and client access to the second floor medical clinic operated by Cornell Scott Hill Health Center from the first floor Drop-in Center this center was opened in April 2021 in response to increased utilization of DESKâ€™s programs  The target population is for people experiencing unsheltered homeless of whom the GNH-CAN has seen a marked increase since the start of the pandemic and for whom they expect to see continual increase with the end of the eviction moratorium as well as those who are unstably andor recently housed and availing themselves of Cornell Scotts Homeless Healthcare Department essentially as their primary care The purpose of the elevator is to facilitate access to the second floor medical facilities  The medical facilities will enable low-barrier onsite medical care for people experiencing unsheltered homelessness including COVID-19 testing and vaccination administration  Along with other basic needs provisions like food and immediate refuge the presence of the medical facility serves as a draw for the hundreds of individuals experiencing homelessness in New Haven who consider the CSHHC Homeless Healthcare team to be their primary care  As a result the medical services offer an opportunity to connect these clients to housing services and get them off the street where they are at risk of a variety of adverse health conditions and infectious disease including COVID-19","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF HOUSING","DOH46900",29751,"PA 21-2 (JSS), Section 306","Hands on Hartford","The specific programs for which Hands on Hartford is asking support are for its  Meals Assistance Neighbors Nurturing and Advocacy MANNA Community Pantry and Neighborhood Services its kids Backpack Nutrition Program which provides healthy meals to food insecure children at 8 Hartford area schools and its Community Meals and Day Program which serves its homeless neighbors and others struggling with food insecurity providing hot meals and one-to-one assistance with resources and referrals Monday through Thursday every week and on every major Holiday throughout the calendar year","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["DEPARTMENT OF HOUSING","DOH46900",29819,"PA 21-2 (JSS), Section 306","New Reach Life Haven Shelter","Funding will support New Reach a non-profit that offers a continuum of housing interventions and supports in Fairfield and New Haven counties helping vulnerable households achieve stability and self-reliance. This assistance will specifically support the organizations family homeless shelters providing services for unhoused persons as the pandemic exacerbated the need for these services","2.16 - Long-Term Housing Security: Services for Unhoused Persons","Yes"]
["DEPARTMENT OF MENTAL HEALTH AND ADDICTION SERVICES","MHA53000",29797,"PA 21-2 (JSS), Section 306","DMHAS Private Providers","$25 million in funds was allotted to the agency of which $15 million supported a 4% Cost of Living Adjustment to all their contracted mental health and substance use providers to be used for salary and related wage increases, and a $10 million for a grant program to support facility and infrastructure costs for these same providers for one time improvements.","2.37 - Economic Impact Assistance Other","Yes"]
["DEPARTMENT OF MENTAL HEALTH AND ADDICTION SERVICES","MHA53000","P1","PA 21-2 (JSS), Section 306","Fair Haven Clinic","The project will expand access and improve delivery of primary care including mental health and substance use treatment services to the Fair Haven community located in a Qualified Census Tract. The ARPA funding will increase Fair Haven Community Health Center's capacity to provide high-quality primary and behavioral health care to this predominantly low-income and Hispanic patient base. Substantial focus will be on improving clinical spaces clinical workflows and physical plant changes to prepare for future pandemics similar to COVID-19 and to expand services to address the broader and long-term health impacts COVID-19 has had on disproportionately impacted communities.","2.21 - Medical Facilities for Disproportionately Impacted Communities","No"]
["DEPARTMENT OF PUBLIC HEALTH","DPH48500",29755,"PA 21-2 (JSS), Section 306","Cornell Scott - Hill Health","To support personnel operations and covered benefit expenses for staff time and supplies dedicated to responding to the COVID-19 public health emergency  Cornell Scott Hill Health Corporation is a federally qualified health center offering community healthcare at over twenty care sites throughout New Haven County  To include performance of COVID-19 testing and vaccination and related patient health care","1.9 - COVID-19 Assistance to Non-Profits","No"]
["DEPARTMENT OF PUBLIC HEALTH","DPH48500",29752,"PA 21-2 (JSS), Section 306","DPH Loan Repayment ","To operate a state educational loan repayment program for primary care providers working in Health Professional Shortage Areas HPSA to meet health care workforce needs within Connecticut Goals include increased access to primary care services in HPSA communitiespopulations decreased health care disparities in HPSA communities and improved overall health care outcomes in disadvantaged communities","2.3 - Household Assistance: Cash Transfers","Yes"]
["DEPARTMENT OF PUBLIC HEALTH","DPH48500",29754,"PA 21-2 (JSS), Section 306","Obesity & COVID-19 Study","To promote the sharing of data collection and research epidemiological work and best policy approaches to address obesity in the context of COVID-19  Obesity increases the risk of severe disease and death from COVID-19 and may interfere with immune response to vaccination  The pandemic has also contributed to an increase in the prevalence of obesity in youth and adults","1.14 - Other Public Health Services","No"]
["DEPARTMENT OF SOCIAL SERVICES","DSS60000",29795,"PA 21-2 (JSS), Section 306","Community Action Agencies","Connecticut's Community Action Agency CAA network will establish a flexible client support fund to assist vulnerable and at-risk populations statewide particularly those who do not qualify for existing programs and services to meet meeting basic household necessities. The pandemic has resulted in increased numbers of first-time CAA clients presenting with short-term economic needs that if met can help the client to achieve independence as opposed to having to rely on long-term benefit programs","2.37 - Economic Impact Assistance Other","Yes"]
["DEPARTMENT OF SOCIAL SERVICES","DSS60000",29794,"PA 21-2 (JSS), Section 306","Mary Wade","Mary Wade is a nursing home that has experienced documented financial hardship in the form of reduced revenues as a result of the pandemic. This financial hardship has hindered the organizations ability to move forward with critical strategic initiatives and funding will supplement a broader project to address these initiatives including upgrades to shared spaces addressing critical life safety concerns and updating HVAC systems","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["DEPARTMENT OF SOCIAL SERVICES","DSS60000",29792,"PA 21-2 (JSS), Section 306","MyCT Resident One Stop","The MyCT initiative seeks to put all government services online in a way that makes state services more accessible This one-stop approach enables residents to access health and human services programs via the online portal by simplifying online interactions and making it easier to locate apply for and maintain participation in state benefit programs \nThis operating support will provide the necessary resources to bring in additional project assistance for user research and design of the health and human services function within MyCT In addition these funds will allow for backfill of existing state resources to allow knowledge leaders to participate in MyCT development and launch Lastly these funds will allow the state to bring in additional business domain expertise for the duration of the project","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF SOCIAL SERVICES","DSS60000",29791,"PA 21-2 (JSS), Section 306","Nursing Home Facility Support","The nursing home industry in Connecticut has experienced negative economic impacts as a result of the pandemic since the first cases presented in the state Funds are intended to provide temporary financial assistance for nursing homes based on the difference between issued and calculated rates   To be considered as part of a broader plan related to implementation of acuity-based rates","6.1 - Provision of Government Services","No"]
["DEPARTMENT OF SOCIAL SERVICES","DSS60000",29790,"PA 21-2 (JSS), Section 306","Workforce Development, Education and Training","The nursing home industry and its employees have borne the brunt of some of the worst impacts of the pandemic resulting in staff burnout and associated staffing shortages across the state and nationwide. This funding will provide workforce development for individuals employed in the nursing home industry to advance their careers eg assisting CNAs to become LPNs or RNs.","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["DEPARTMENT OF TRANSPORTATION","DOT57000",29835,"SA 22-2, Sec. 3","Free Bus Public Transportation Services"]
["DEPARTMENT OF TRANSPORTATION","DOT57000",29756,"PA 21-2 (JSS), Section 306","Groton Water Taxi ","Funding supports the operation of the Thames River Heritage Park Water Taxi - Sightseeing and Historic Boat Tours along the Thames River in Groton and New London  As a seasonal program that is busiest in the summer months the water taxis serving as economic drivers of tourism only run from May to September","2.35 - Aid to Tourism Travel or Hospitality","No"]
["JUDICIAL DEPARTMENT","JUD95000",29784,"PA 21-2 (JSS), Section 306","Legal Representation for Tenant Eviction","Per Connecticut Public Act 21-34 â€œActâ€\u009d which established the Right to Counsel Program effective July 1 2021 free legal representation will be provided to income-eligible tenants and occupants in residential eviction and administrative proceedings  Individuals with household incomes that are no more than 80 of the stateâ€™s median income or who receive certain types of public assistance are considered income eligible","2.18 - Housing Support: Other Housing Assistance","Yes"]
["JUDICIAL DEPARTMENT","JUD95000",29783,"PA 21-2 (JSS), Section 306","Mothers Against Violence ","Mothers Against Violence MAV a 501 c 3 non-profit  MAV provides direct services to victims of crime in underserved communities where the ongoing support is minimum This includes crisis intervention advocacy grief counseling compassion  support accompanying victims to secure services providing direction for short term needs food shelter clothing and transportation  In addition we have provided anti retaliation services and strategies which help to prevent any additional retaliation between victims and other individuals who may have been impacted","1.11 - Community Violence Interventions","Yes"]
["JUDICIAL DEPARTMENT","JUD95000",29785,"PA 21-2 (JSS), Section 306","New Haven Police Activities League","Through the New Haven Police Activities League NH-PAL program educational and athletic programs for children throughout the city will be provided NH-PAL responds to the needs of youth in many neighborhoods through after school weekend and special summer events The purpose is to build character help strengthen police-community relations and keep children off illegal drugs","1.11 - Community Violence Interventions","Yes"]
["LABOR DEPARTMENT","DOL40000",29761,"PA 21-2 (JSS), Section 306","Boys and Girls Club Workforce Development - Milford ","A youth workforce development initiative will be supported Through the workforce development program the Boys  Girls Club of Milfordâ€™s BGCM goal is to serve a minimum of 30 youth that are either freshmen or sophomores in high school \nOver the next 8 months each program participant will be required to Complete the Curriculum for the BGCA developed Career Launch Programs; Complete the Curriculum for the BGCA developed Money Matter Financial Literacy Program; Participate as active Members in Keystone BGCMâ€™s premier youth leadership club; Attend 80 of Mentoring Goal Meetings; and Complete a minimum of 40 hours of job shadowing","6.1 - Provision of Government Services","No"]
["LABOR DEPARTMENT","DOL40000",29757,"PA 21-2 (JSS), Section 306","Domestic Worker Grants","Funding provided to assist unemployed or underemployed workers including job training   To implement workforce assistance that responds to the public health emergency or its negative economic impacts such as assistance to unemployed individuals job training for individuals who want and are available for work including those who have looked for work in the past 12 months assistancetraining for part-time workers who want and are available for full-time work and assistancetraining for those seeking upward economic mobility","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["LABOR DEPARTMENT","DOL40000",29764,"PA 21-2 (JSS), Section 306","Greater Bridgeport OIC Job Development and Training Program ","Funding utilized to provide a community based Hub that will offer a variety of free customized business and leadership development services to existing small businesses  Also aid in a business development strategy for re-opening after mandated closings  Funding to support businesses that were impacted by the pandemic and need assistance with reassessing their models in the new environment","2.30 - Technical Assistance Counseling or Business Planning","Yes"]
["LABOR DEPARTMENT","DOL40000",29759,"PA 21-2 (JSS), Section 306","Opportunities for Long Term Unemployed Returning Citizens","The Opportunities for Long Term Unemployed Program also known as the Platform to Employment â€œP2Eâ€\u009d Program was established under Connecticut Public Act 15-244 P2E is a five-week preparatory program for job seekers which includes skills assessments career readiness workshops employee assistance programs and more Career coaches work with participants to leverage their professional experience and to develop effective job search strategies Upon completion P2E helps participants find open positions at local companies and offers a trial work experience","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["LABOR DEPARTMENT","DOL40000",29763,"PA 21-2 (JSS), Section 306","Senior Jobs Bank - West Hartford","Seniors Job Bank SJB connects people over 50 looking for part-time and temporary work with businesses organizations and households seeking workers","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["LABOR DEPARTMENT","DOL40000",29760,"PA 21-2 (JSS), Section 306","TBICO Danbury Women's Employment Program ","Nonprofit in Danbury whose mission is to promote personal and economic self-sufficiency through education job training and financial literacy  Provide individuals with employment focused education and training","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["LABOR DEPARTMENT","DOL40000",29766,"PA 21-2 (JSS), Section 306","Unemployment Support","Provide support to increased unemployment program demand at the Department of Labor in excess of what is support through federal UI funds  Specifically there has been an increase in claim intake increased demand for the unemployment customer contact center increased adjudication of claims increased need to audit overpayments and appeals","3.5 - Public Sector Capacity: Administrative Needs","No"]
["LABOR DEPARTMENT","DOL40000",29765,"PA 21-2 (JSS), Section 306","Unemployment Trust Fund","To support the states Unemployment Insurance Trust funds specifically to support the repayment of the principal and interest amount due on advances received","2.28 - Contributions to UI Trust Funds","No"]
["LABOR DEPARTMENT","DOL40000",29758,"PA 21-2 (JSS), Section 306","Veterans Employment Opportunity PILOT ","The Homeless Veterans Opportunity Pilot has been implemented statewide and consists of four basic components housing case management support services and employment services  Depending on the particular need of the veteran referrals are made to appropriate support services to overcome barriers to employment including but not limited to substance abuse and mental health programs state federal and private; employment services American Job Centers; mentoring through veteran service organizations; and housing and food programs","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["LABOR DEPARTMENT","DOL40000",29762,"PA 21-2 (JSS), Section 306","Women's Mentoring Network- Strategic Life Skills Workshop","Non profit that provides career educational and personal resources that lead to the economic empowerment of low-income women and their families Programs and services focus on Workforce Development Financial Literacy and Computer  Digital Literacy Womenâ€™s Mentoring Network offers workshops and one-on-one assistance to adults The organization also provides services to students through its First Generation Achievement Program Students may join the Junior Leadership Team or receive help in our Early Steps Tutoring Program","2.10 - Assistance to Unemployed or Underemployed Workers (eg job training subsidized employment employment supports or incentives)","Yes"]
["LABOR DEPARTMENT - BANKING FUND","DOL40000",29767,"PA 21-2 (JSS), Section 306","Customized Services for Mortgage Crisis Jobs Training Program ","The Mortgage Crisis Job Training Partnership Program will respond to the negative economic impacts of the public health emergency on homeowners by providing the following assistance to homeowners as follows  Assessments of eligibility; employment services; employment support services; job training; career coaching; Trainings to address economic hardship; financial literacy and credit counseling; COVID-safety training and job-specific training; Training scholarships for job training; support services including housing-related counseling and other supports as needed","6.1 - Provision of Government Services","No"]
["LEGISLATIVE MANAGEMENT","OLM10000",29796,"PA 21-2 (JSS), Section 306","CTN ","Broadcast upgrades  improvements to provide greater expansive public coverage including CTN Media Server Replacement Control Switcher  Production Switch AudioVideo Router Replacement Web Streaming HWSW servers remote equipment and other miscellaneous equipment to fully support the initiatives","6.1 - Provision of Government Services","No"]
["OFFICE OF EARLY CHILDHOOD","OEC64800",29768,"PA 21-2 (JSS), Section 306","Care4Kids Parent Fees ","Funds supported Parent Fees in Care4Kids Connecticuts childcare subsidy program for low to moderate income families To be eligible for Care4Kids a family most be at or below 60 of State Median Income The Connecticut Office of Early Childhood used these ARPA SLFRF funds along with other federal stimulus funds awarded directly to OEC to cover Parent Fees from April to November of 2021","6.1 - Provision of Government Services","No"]
["OFFICE OF EARLY CHILDHOOD","OEC64800",29769,"PA 21-2 (JSS), Section 306","Parents Fees for 3-4 Year Old's at State Funded Childcare Centers","For the service months of July and August funds were used to support parent fees at state funded Child Day Care Centers and School Readiness Programs Funding was limited to families at or under 75 of State Median Income centers located in priority school districtsa category of school districts which meets certain need based metrics defined in Connecticut state statute or to centers located in Qualified Census tracks","6.1 - Provision of Government Services","No"]
["OFFICE OF EARLY CHILDHOOD","OEC64800",29770,"PA 21-2 (JSS), Section 306","Universal Home Visiting","7 million of the funding in this projected has been dedicated to a universal home visiting pilot program in the Bridgeport Connecticut region The remaining 1 million has been dedicated to support a home visiting contract in the New Haven Connecticut region Both of these programs will connect families with behavioral and mental health resources responding to health disparities exacerbated by the pandemic","2.12 - Healthy Childhood Environments: Home Visiting","Yes"]
["OFFICE OF HIGHER EDUCATION","DHE66500",29771,"PA 21-2 (JSS), Section 306","Roberta Willis Need-Based Scholarships","The Office of Higher Education OHE will utilize funds to provide need-based financial aid grants to students who were disproportionately impacted by the pandemic This grant program entitled the Roberta B Willis Scholarship Program ARPA Supplement will be modeled on the existing state program that administered need-based scholarships Priority for grants provided from the State Fiscal Recovery Fund will be given to students whose income is equal to or less than 100 of the federal poverty level","2.37 - Economic Impact Assistance Other","Yes"]
["OFFICE OF HIGHER EDUCATION","DHE66500",29772,"PA 21-2 (JSS), Section 306","Summer College Corps","During the summer of 2021 College Corps based on the AmeriCorps model of addressing community challenges through civic engagement and service recruited and deployed a corps of undergraduate college student interns to serve as academic enrichment summer counselors for K-12 students in various enrichment programs throughout Connecticut The programâ€™s goals were to provide enriching summer experiences to K-12 students to prepare for the upcoming return to in-person schooling in Fall 2021","2.37 - Economic Impact Assistance Other","Yes"]
["OFFICE OF POLICY AND MANAGEMENT","OPM20000",29774,"PA 21-2 (JSS), Section 306","PPE & Supplies","This funding will support  the purchase of personal protective equipment and supplies to combat COVID-19","1.5 - Personal Protective Equipment","No"]
["OFFICE OF POLICY AND MANAGEMENT","OPM20000",29773,"PA 21-2 (JSS), Section 306","Private Providers","Funding will support a minimum wage increase for employees in DDS provider settings and support a 3% increase for those making over the minimum wage plus fund a health and retirement pool to enhance benefits for these important health care workers","2.34 - Assistance to Impacted Nonprofit Organizations Impacted or Disproportionately Impacted","No"]
["OFFICE OF POLICY AND MANAGEMENT","OPM20000",29775,"PA 21-2 (JSS), Section 306","State Employee Essential Workers and National Guard Premium Pay","Premium pay for state employee essential workers and national guardsmen","4.1 - Public Sector Employees","No"]
["OFFICE OF WORKFORCE STRATEGIES","GOV12000",29819,"PA 21-2 (JSS), Section 306","Governor's Workforce Initiatives"]
["UNIVERSITY OF CONNECTICUT","UOC67000",29776,"PA 21-2 (JSS), Section 306","Higher Education – UConn","Support is provided to the University of Connecticut UConn for the provision of public services. In response to significant revenue losses experienced in UConn's housing and dining units UConn will utilize this allocation for Residential Life and Dining Services operating expenditures in order to keep these critical services functioning for students residing on campus. Those operating expenses include food purchase contractual staff facility operations and equipment","6.1 - Provision of Government Services","No"]
["UNIVERSITY OF CONNECTICUT HEALTH CENTER","UHC72000",29777,"PA 21-2 (JSS), Section 306","Revenue Impact","Support is provided to the University of Connecticut Health Center UConn Health for the provision of public services To continue to provide outpatient clinical services to State of Connecticut residents UConn Health will utilize funds to support the multispecialty physician practice salary budget at John Dempsey Hospital a hospital and academic medical center operated by UConn Health  These funds will allow UConn Health to continue to support the patient needs of the State of Connecticut without cutting any programs","3.3 - Public Sector Workforce: Other","No"]
["UNIVERSITY OF CONNECTICUT HEALTH CENTER","UHC72000",29778,"PA 21-2 (JSS), Section 306","University of Connecticut Health Center ","Support is provided to the University of Connecticut Health Center UConn Health for the provision of public services To continue to provide outpatient clinical services to State of Connecticut residents UConn Health will utilize funds allocated from the State Fiscal Recovery Fund to support the multispecialty physician practice salary budget at John Dempsey Hospital a hospital and academic medical center operated by UConn Health  These funds will allow UConn Health to continue to support the patient needs of the State of Connecticut without cutting any programs","3.3 - Public Sector Workforce: Other","No"]

{"sheet":"Logic","index":16,"n_rows":83,"n_cols":58,"rows_kept":83,"cut":false,"hidden":true,"merged":[]}
["Visibility","v:20220620",null,"Columns"]
["Detail Expenditure","Summary","Sheet","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW","AX","AY","AZ","BA","BB","BC"]
["1.1-COVID-19 Vaccination","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.2-COVID-19 Testing","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.3-COVID-19 Contact Tracing","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.4-Prevention in Congregate Settings (Nursing Homes Prisons/Jails Dense Work Sites Schools Child care facilities etc.)","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.5-Personal Protective Equipment","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.6-Medical Expenses (including Alternative Care Facilities)","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.7-Other COVID-19 Public Health Expenses (including Communications Enforcement Isolation/Quarantine)","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.8-COVID-19 Assistance to Small Businesses","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x",null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.9-COVID 19 Assistance to Non-Profits","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.10-COVID-19 Aid to Impacted Industries","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.11-Community Violence Interventions","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.12-Mental Health Services","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.13-Substance Use Services","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["1.14-Other Public Health Services","1-Public Health",3,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.1-Household Assistance: Food Programs","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.2-Household Assistance: Rent Mortgage and Utility Aid","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["2.3-Household Assistance: Cash Transfers","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.4-Household Assistance: Internet Access Programs","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.5-Household Assistance: Paid Sick and Medical Leave","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.6-Household Assistance: Health Insurance","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.7-Household Assistance: Services for Un/Unbanked","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.8-Household Assistance: Survivors Benefits","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.9-Unemployment Benefits or Cash Assistance to Unemployed Workers","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.10-Assistance to Unemployed or Underemployed Workers (e.g. job training subsidized employment employment supports or incentives)","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.11-Healthy Childhood Environments: Child Care","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,"x","x"]
["2.12-Healthy Childhood Environments: Home Visiting","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,"x","x"]
["2.13-Healthy Childhood Environments: Services to Foster Youth or Families Involved in Child Welfare System","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,"x","x"]
["2.14-Healthy Childhood Environments: Early Learning","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,"x",null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,"x","x"]
["2.15-Long-term Housing Security: Affordable Housing","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["2.16-Long-term Housing Security: Services for Unhoused Persons","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["2.17-Housing Support: Housing Vouchers and Relocation Assistance for Disproportionately Impacted Communities","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["2.18-Housing Support: Other Housing Assistance","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["2.19-Social Determinants of Health: Community Health Workers or Benefits Navigators","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.20-Social Determinants of Health: Lead Remediation","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.21-Medical Facilities for Disproportionately Impacted Communities","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.22-Strong Healthy Communities: Neighborhood Features that Promote Health and Safety","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.23-Strong Healthy Communities: Demolition and Rehabilitation of Properties","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.24-Addressing Educational Disparities: Aid to High-Poverty Districts","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x"]
["2.25-Addressing Educational Disparities: Academic Social and Emotional Services","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,"x",null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x"]
["2.26-Addressing Educational Disparities: Mental Health Services","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,"x",null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x"]
["2.27-Addressing Impacts of Lost Instructional Time","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x"]
["2.28-Contributions to UI Trust Funds","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.29-Loans or Grants to Mitigate Financial Hardship","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x",null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.30-Technical Assistance Counseling or Business Planning","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x","x",null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.31-Rehabilitation of Commercial Properties or Other Improvements","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x",null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.32-Business Incubators and Start-Up or Expansion Assistance","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x","x",null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.33-Enhanced Support to Microbusinesses","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x","x",null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.34-Assistance to Non-Profits Assistance to Impacted Nonprofit Organizations (Impacted or Disproportionately Impacted)","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,"x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.35-Aid to Tourism Travel or Hospitality","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.36-Aid to Other Impacted Industries","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.37-Economic Impact Assistance: Other","2-Negative Economic Impacts",4,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x","x",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["3.1-Public Sector Workforce: Payroll and Benefits for Public Health Public Safety or Human Services Workers","3-Public Health-Negative Economic Impact: Public Sector Capacity ",5,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["3.2-Public Sector Workforce: Rehiring Public Sector Staff","3-Public Health-Negative Economic Impact: Public Sector Capacity ",5,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["3.3-Public Sector Workforce: Other","3-Public Health-Negative Economic Impact: Public Sector Capacity ",5,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["3.4-Public Sector Capacity: Effective Service Delivery","3-Public Health-Negative Economic Impact: Public Sector Capacity ",5,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["3.5-Public Sector Capacity: Administrative Needs","3-Public Health-Negative Economic Impact: Public Sector Capacity ",5,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["4.1-Public Sector Employees","4-Premium Pay",6,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["4.2-Private Sector: Grants to other employers","4-Premium Pay",6,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["5.1-Clean Water: Centralized wastewater treatment","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.2-Clean Water: Centralized wastewater collection and conveyance","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.3-Clean Water: Decentralized wastewater","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.4-Clean Water: Combined sewer overflows","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.5-Clean Water: Other sewer infrastructure","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.6-Clean Water: Stormwater","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.7-Clean Water: Energy conservation","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.8-Clean Water: Water conservation","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.9-Clean Water: Nonpoint source","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.10-Drinking water: Treatment","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.11-Drinking water: Transmission & distribution","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.12-Drinking water: Lead Remediation including in Schools and Daycares","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.13-Drinking water: Source","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.14-Drinking water: Storage","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.15-Drinking water: Other water infrastructure","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.16-Water and Sewer: Private Wells ","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.17-Water and Sewer: IIJA Bureau of Reclamation Match ","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.18-Water and Sewer: Other ","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,"x","x"]
["5.19-Broadband: Last Mile projects","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
["5.20-Broadband: IIJA Match","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
["5.21-Broadband: Other projects","5-Infrastructure",7,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,"x","x","x",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
["7.1-Administrative Expenses","7-Administrative and Other",8,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["7.2-Transfers to Other Units of Government","7-Administrative and Other",8,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]