{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["READ ME 1st","1. Signature Page","2. Contact Information","3. Use of Funds","4. Budget","Schedule A","Dropdowns","DataLookupValues","dataDistrictList"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":4,"defined_names":150,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"READ ME 1st","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[52,2,52,4],[42,2,42,4],[46,1,46,4],[47,2,47,4],[48,2,48,4],[51,2,51,4],[49,2,49,4],[50,2,50,4],[26,1,26,11],[32,2,32,4],[31,2,31,4],[34,1,34,4],[1,1,1,12],[9,1,9,12],[10,1,10,12],[2,1,2,12],[3,1,3,12],[4,1,5,12],[6,1,6,12],[11,1,11,12],[8,1,8,12],[12,1,19,12],[20,1,20,12],[7,1,7,12],[21,1,21,12],[22,1,22,12],[23,1,23,12],[24,1,24,12],[25,1,25,12],[36,2,36,4],[38,2,38,4],[27,1,27,11],[30,2,30,4],[35,1,35,4]]}
[]
[null,"       Massachusetts Department of Elementary & Secondary Education"]
[null,"FY23 Improving Ventilation and Air Quality in Public School Buildings Grant                                                   Fund Code 209                                         "]
[null,"Overview"]
[null,"This application allows LEAs (districts and other eligible entities, referred to in this application collectively as districts) to apply for funding for the following federal program:  Fund Code 209, FY23 Improving Ventilation and Air Quality (IVAQ) in Public School Buildings Grant authorized\nby Massachusetts' Act Relative to Immediate COVID-19 Recovery Needs. The purpose of this grant program is to address inequitable school facilities’ needs and repairs for improved ventilation and indoor air-quality to support healthy learning environments in districts and schools with high concentrations of economically disadvantaged students, English language learners, and communities disproportionately impacted by the 2019 novel coronavirus pandemic"]
[]
[null,"\nThis grant prioritizes the following activities to improve ventilation and indoor air quality in their school buildings:\n\n    •   Needs assessments or studies of existing school environments, HVAC systems, and indoor air quality, by building and by room, in order to \n         establish a baseline of the school’s existing conditions.\n    •   Feasibility study to develop long-term indoor air quality improvement plans that improve fresh air exchange rates and reduce or eliminate\n         reliance on fossil fuels.\n    •   Design, bidding assistance and construction phase services for projects to upgrade or replace existing HVAC systems. Note that upgrades to or\n         replacement of windows and/or doors is allowable, but only to the extent that inoperable windows and doors become operable so that fresh air\n         can flow into the building.\n    •   To implement indoor air quality improvement plans, securing outsourced services, establishing in-house HVAC maintenance positions,\n         and/or securing materials/equipment to maintain, repair or install new HVAC systems. \n    •   To implement indoor air quality improvement plans, securing services and materials to ensure operability of windows and/or doors"]
[null,"Construction, Minor Remodeling, Repairs and Maintenance with IVAQ Funding\nAwardees are strongly encouraged to review DESE’s guidelines and tips for using federal funds for construction, minor remodeling, and repairs and maintenance, and DESE’s resource guide for conducting procurements with federal funds to ensure they are in compliance. In particular, if a district intends to use existing service contracts for any grant-related activities, the district should ensure that the contract was originally procured in a manner that satisfies federal procurement law (and state law and local policy) and that the work being funded does not go beyond the scope of the original service contract (i.e., if the service contract only covers maintenance of existing systems, it would not be permissible to use the contract to cover installation of new systems).\n\nAny capital expenditures or equipment expenditures that exceed $30,000 or any facilities improvement project on the grant application must be documented and justified on DESE’s Capital Expenditure Approval form (one for each project) and must be submitted with the grant application. Equipment is defined as “tangible personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes, or $5,000.” Id.  Construction for purposes of this grant adopts the Impact Aid definition (Title VII of ESEA), and includes new construction, as well as remodeling, alterations, renovations, and repairs. Non-facilities cCapital expenditures of less than $30,000 will be approved as part of your grant application workbook budgets."]
[null,"    The application due date is Friday, October 28, 2022. A start date cannot be given until you have submitted a substantially approvable\n    application and budget for the grant.\n\n    Note:  These grant funds must be obligated by December 31, 2024, and may be used for allowable expenses and liquidated through December 31, 2026.\n    "]
[null,"First Step:  Saving the File "]
[null,"Save this file to your computer (Important: ensure macros are enabled).  Rename the file by replacing the words 'leacode' in the file name with your 4-digit district code. For example, Abington (0001) would rename the file as 'FY23IVAQ-0001.xlsm'. Do not change the filename except for your district's 4-digit code. Users of Macintosh computers must save as a macro-enabled file (with an .xlsm extension) to their desktop for the workbook to function properly."]
[null,"Tips for Completing the IVAQ Application"]
[null,"  \n Workflow and printing:  \n   •  Complete the Signature Page first.  The rest of the tabs do not need to be completed in order, but your application will not be considered substantially\n         approvable if you leave required  information blank.\n\n    •  Complete the steps on each tab in the order that they are numbered. Note that some steps may not be required for your district and may be skipped.\n\n   •  The Budget worksheet (Tab ) must be completed.  This tab mirrors the budget entry page in EdGrants with the addition of sections re: equipment and \n       certain contracts.  The budget worksheet is mandatory, in addition to entering budget information in EdGrants. \n\n   •  This workbook is structured to be used in electronic format.  However, you can print a copy using Excel's print preview functions to set the appearance and \n        paper orientation to best fit your completed application.  \n   \n  Color-coding and cell features:\n   •  Those cells that appear light yellow require districts to input information.  Text may be pasted into these cells as long as the source of the information has no\n         Excel formulas or formatting.  \n\n   •  Those cells that appear light gray will automatically populate based on information your district supplies on the application or from preloaded data already\n       reported to the Department of Elementary and Secondary Education (DESE) (for example, SIMS data).  Do not cut and paste information from other pages or\n       sources into gray cells!  \n\n   •  Those cells that appear in light orange offer a dropdown menu from which districts can choose a supplied response.   Do not cut and paste information from\n       other pages or sources into orange cells! \n\n   •  Throughout the tabs of this application you will find instruction boxes, tip boxes (pink) to help avoid common mistakes, and resource boxes (tan) that\n       include links to materials outside the application with more detailed, grant-related information.\n"]
[]
[]
[]
[]
[]
[]
[]
[null,"Submit the FY23 IVAQ Application as an Excel workbook via\nEdGrants Front Office web page"]
[null,"EdGrants Submission Information:\nMost districts/applicants already have designated control users in EdGrants Front Office, who have access to submit grant applications as well as to make payment requests. Each district/applicant needs to ensure that it has an authorized control user prior to grant submission.  If a district waits until its grant submission is ready to submit before inquiring about a new username/login, grant submissions may be delayed several business days waiting for control user set-up.  Please review the EdGrants Security Controls documents and/or contact DESE's Grants Management Office, 781-338-6595 or EdGrants@mass.gov, regarding assigning your EdGrants Front Office control users.  "]
[null,"The district/applicant control users will register each grant opportunity, create each grant project and enter contact information, budget, and required attachments in EdGrants. All districts' business offices have been contacted with information regarding training.  If you are unsure of who in your office is a control user, please contact your business office. The FY23 HVAC Application Workbook, a signed and dated .pdf of the Signature Page (Tab 1), and any required Capital Expenditure form(s) must be submitted with your budget in EdGrants."]
[null,"Applications for FY23 are due by Friday, October 28, 2022"]
[null,"NOTE ON SUBMISSION TIMELINE: "]
[null,"    •  The start date will be the later of the date on which the district submits substantially approvable information and budget for the grant.  \n    •  Responding quickly to requests for information can result in an earlier approval of your grant application.  \n    •  Grant payment notices will be available in EdGrants after the grant application has been approved and the initial payment is processed.\n"]

{"sheet":"1. Signature Page","index":1,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,13,29,15],[28,16,29,19],[31,1,31,19],[26,13,26,15],[26,16,27,19],[27,13,27,15],[25,1,27,3],[25,4,25,8],[25,16,25,19],[26,4,27,8],[25,10,25,15],[26,9,26,12],[27,9,27,12],[10,5,10,11],[1,1,2,19],[4,1,4,19],[5,1,5,19],[21,12,21,13],[11,5,11,11],[17,1,18,19],[20,1,20,4],[20,5,20,10],[20,12,20,13],[20,14,20,18],[21,14,21,18],[21,1,21,4],[21,5,21,10]]}
[]
[null,"Massachusetts Department of Elementary and Secondary Education\nSTANDARD CONTRACT FORM AND APPLICATION FOR PROGRAM GRANTS"]
[]
[]
[null,"UPLOAD A SCANNED, SIGNED COPY OF THIS PAGE WITH THE DATE OF SUBMISSION TO EDGRANTS WITH THE BUDGET FOR  IVAQ GRANT, FUND CODE 209"]
[null,"District staff with the role of “control user” in EdGrants have been provided user log-in names and passwords and have been trained to submit a grant application via EdGrants. Provide all required application materials to your\n district control user with access to EdGrants in order to submit budget and attachments.                                                              \n                 Applications are due by Friday, October 28, 2022"]
[]
[]
[null,null,null,"District Name:",null,null,null,null,null,null,null,null,"Code:",null,{"$f":"valorg4code","v":"DIST"}]
[]
[null,null,null,"Address: ",null,{"$f":"IF(valAddr2=\"\", valAddr1, valAddr1&\", \"&valAddr2)","v":"ADDR 1, ADDR 2"},null,null,null,null,null,null,"DESE Federal Grant Liaison",null,{"$f":"valname","v":"Liaison's Name"}]
[null,null,null,null,null,{"$f":"valCtyStZip","v":"City, State Zip"},null,null,null,null,null,null,"Phone number:",null,{"$f":"valphonenum","v":"Liaison's Number"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Email:",null,{"$f":"valemail","v":"Liaison's Email"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[null,"I CERTIFY THAT THE INFORMATION CONTAINED IN THIS APPLICATION IS CORRECT AND COMPLETE; THAT THE APPLICANT AGENCY HAS AUTHORIZED ME, AS ITS REPRESENTATIVE, TO FILE THIS APPLICATION; AND THAT I UNDERSTAND THAT FOR ANY FUNDS RECEIVED THROUGH THIS APPLICATION THE AGENCY AGREES TO COMPLY WITH ALL APPLICABLE STATE AND FEDERAL GRANT REQUIREMENTS COVERING BOTH THE PROGRAMMATIC AND FISCAL ADMINISTRATION OF GRANT FUNDS, INCLUDING USING THE GRANT FUNDS FOR ACTIVITIES ALLOWABLE UNDER THE AMERICAN RESCUE PLAN ACT OF 2021. IN ADDITION, THE APPLICANT AGENCY ACKNOWLEDGES AND AFFIRMS THAT ITS FY23 FEDERAL GRANT ASSURANCES (AS WELL AS ANY FUTURE ASSURANCES PROVIDED DURING THE GRANT PERIOD) APPLY TO THIS GRANT."]
[]
[]
[null,"AUTHORIZED SIGNATURE:",null,null,null,null,null,null,null,null,null,null,"TITLE:"]
[null,"PRINTED NAME:",null,null,null,null,null,null,null,null,null,null,"SUBMISSION DATE:"]
[]
[]
[]
[null,"FY2023\nAllocation",null,null,"FEDERAL GRANT",null,null,null,null,null,"PROJECT DURATION",null,null,null,null,null,"TOTAL ALLOCATION"]
[null,null,null,null,"IVAQ Grant \nFund Code 209",null,null,null,null,"FROM",null,null,null,"TO",null,null,{"$f":"IF(Q29=\"\", DataLookupValues!B11, \"\")","v":"FY23 IVAQ Allocation"}]
[null,null,null,null,null,null,null,null,null," UPON APPROVAL",null,null,null,"6/30/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Allocation for Schedule A Consortium\nFor Those Districts Filing Schedule A only"]
[]
[]
[null,"UPLOAD A SCANNED, SIGNED COPY OF THIS PAGE WITH THE DATE OF SUBMISSION TO EDGRANTS WITH THE BUDGET FOR THIS GRANT\nBY OCTOBER 28, 2022"]

{"sheet":"2. Contact Information","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,2,12,11],[13,2,13,11],[9,1,9,11],[10,1,10,3],[10,4,10,11],[6,1,6,2],[6,3,6,11],[7,2,7,11],[8,2,8,11],[11,1,11,2],[11,3,11,11],[1,1,1,7],[3,1,3,11],[3,13,5,17],[4,1,4,11],[5,1,5,3],[5,4,5,11]]}
[]
[null,{"$f":"valDistrName & \" (\"&valorg4code&\")\"","v":"OrgName (DIST)"}]
[]
[null,"District Contact Information \nPlease provide information for primary district contacts for your district's FY23 IVAQ application"]
[null,"FY23 IVAQ application"]
[null,"Name of Primary Contact:"]
[null,"Title:"]
[null,"Phone:"]
[null,"Email:"]
[null,"EdGrants Control User (person responsible for uploading to EdGrants, if different person from above)"]
[null,"Name of Primary Contact:"]
[null,"Title:"]
[null,"Phone:"]
[null,"Email:"]

{"sheet":"3. Use of Funds","index":3,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[17,2,17,10],[18,2,18,10],[19,2,19,10],[1,1,1,7],[5,1,8,11],[3,1,3,11],[13,2,13,11],[16,2,16,10],[14,2,14,10],[15,2,15,10],[10,2,10,9],[10,10,10,11],[11,2,11,9],[11,10,11,11],[10,1,11,1],[24,2,24,11],[25,2,25,11],[27,2,27,11],[28,2,28,11],[21,2,21,11],[22,2,22,11]]}
[]
[null,{"$f":"valDistrName & \" (\"&valorg4code&\")\"","v":"OrgName (DIST)"}]
[]
[null,"Uses of Funds"]
[]
[null,"These funds must be used for stand-alone air quality improvement activities as well as to supplement other ongoing air quality improvement activities, as long as fund use is aligned with the grant purpose and priorities described above and that have reasonable likelihood of being sustained (and/or having impact) beyond the grant period.\n\nFund use may include, but is not limited to:\n\n            •   Needs assessments or studies of existing school environments, HVAC systems, and indoor air quality, by building and by room, in order to establish a \n                baseline of the school’s existing conditions.\n            •   Feasibility study to develop long-term indoor air quality improvement plans that improve fresh air exchange rates and reduce or eliminate reliance on fossil fuels.\n            •   Design, bidding assistance and construction phase services for projects to upgrade or replace existing HVAC systems. Note that upgrades to or replacement of\n                windows and/or doors is allowable, but only to the extent that inoperable windows and doors become operable so that fresh air can flow into the building.\n            •   To implement indoor air quality improvement plans, securing outsourced services, establishing in-house HVAC maintenance positions, and/or securing\n                materials/equipment to maintain, repair or install new HVAC systems.\n            •   To implement indoor air quality improvement plans, securing services and materials to ensure operability of windows and/or doors.\n            •   Professional development for facilities directors to service and maintain air handling systems to ensure sustained, healthy indoor air quality conditions;\n            •   Other services and materials aligned with the priorities of this grant."]
[]
[]
[]
[]
[null,"Step 3.1\nAll Districts","Assurance:  Our use of IVAQ funds are being used to supplement and complement, and not supplant, state and other federal grants, including ESSER I, II, & III funds.",null,null,null,null,null,null,null,"Select"]
[null,null,"Assurance:  Our district agrees to participate in the state's Affirmative Marketing Program (AMP), set project goals for minority contractor participation, and ensure they are complying with the requirements set forth in M.G.L. c. 7C, §6. ",null,null,null,null,null,null,null,"Select"]
[]
[null,"Step 3.2\nAll Districts","FY23 IVAQ Priority Uses of Funds\nOn which of the following priority activities/categories does your district intend to spend its FY23 IVAQ Funds?\n(Select \"Yes\" for all that apply)"]
[null,null," 1.  Needs assessments or studies of existing school environments, HVAC systems, and indoor air quality, by building and by room, \n       in order to establish a baseline of the school’s existing conditions.",null,null,null,null,null,null,null,null,"Select "]
[null,null," 2.  Feasibility study to develop long-term indoor air quality improvement plans that improve fresh air exchange rates and reduce or\n      eliminate reliance on fossil fuels.",null,null,null,null,null,null,null,null,"Select "]
[null,null,"3.  Design, bidding assistance and construction phase services for projects to upgrade or replace existing HVAC systems. Note that upgrades\n      to or replacement of windows and/or doors is allowable, but only to the extent that inoperable windows and doors become operable \n      so that fresh air can flow into the building.",null,null,null,null,null,null,null,null,"Select "]
[null,null,"4.  To implement indoor air quality improvement plans, securing outsourced services, establishing in-house HVAC maintenance positions,\n      and/or securing materials/equipment to maintain, repair or install new HVAC systems.",null,null,null,null,null,null,null,null,"Select "]
[null,null,"5.  To implement indoor air quality improvement plans, securing services and materials to ensure operability of windows and/or doors.",null,null,null,null,null,null,null,null,"Select "]
[null,null,"6.  Other allowable uses.",null,null,null,null,null,null,null,null,"Select "]
[]
[null,"Step 3.3\nAll Districts","ACTIVITIES: Briefly describe the activities/projects that you will fund in whole or in part with FY23 IVAQ funds:"]
[]
[]
[null,"Step 3.4\nAll Districts","JUSTIFICATION: Briefly describe the justification for the activities/projects that you will fund in whole or in part with FY23 IVAQ funds (i.e. why target certain school buildings over others? What is the current state of air quality in the building(s)? How has district prioritized historically disadvantaged student populations?)"]
[]
[]
[null,"Step 3.5\nAll Districts","MEASURES OF SUCCESS: List at least one measure of success for each building that will be improved by way of the chosen grant activities (i.e. Improvements in building X, Y, and/or Z in clean air exchange rates (Air Changes per Hour) from 2 to 4, etc.):"]

{"sheet":"4. Budget","index":4,"n_rows":130,"n_cols":41,"rows_kept":130,"cut":false,"hidden":false,"merged":[[83,7,83,9],[84,7,84,9],[43,22,43,23],[42,22,42,23],[39,22,39,23],[40,22,40,23],[38,22,38,23],[37,22,37,23],[36,22,36,23],[53,22,53,23],[52,22,52,23],[51,22,51,23],[50,22,50,23],[37,4,37,7],[38,4,38,7],[47,4,47,11],[48,3,48,11],[40,3,40,11],[55,22,55,23],[54,22,54,23],[59,22,59,23],[41,3,41,7],[42,4,42,11],[51,4,51,7],[53,25,53,30],[54,25,54,30],[55,25,55,30],[56,25,56,30],[58,25,58,30],[82,5,82,7],[20,22,20,23],[18,22,18,23],[17,22,17,23],[35,22,35,23],[33,22,33,23],[26,22,26,23],[48,22,48,23],[47,22,47,23],[46,22,46,23],[45,22,45,23],[44,22,44,23],[80,22,80,23],[79,22,79,23],[78,22,78,23],[77,22,77,23],[76,22,76,23],[57,22,57,23],[56,22,56,23],[67,25,67,30],[66,22,66,23],[110,27,110,28],[75,25,75,30],[57,25,57,30],[66,25,66,30],[59,25,59,30],[60,25,60,30],[61,25,61,30],[62,25,62,30],[63,25,63,30],[64,25,64,30],[65,25,65,30],[71,22,71,23],[73,22,73,23],[74,22,74,23],[75,22,75,23],[98,23,98,31],[29,25,29,30],[77,25,77,30],[79,25,79,30],[80,25,80,30],[20,25,20,30],[21,4,21,7],[27,3,27,11],[27,25,27,30],[27,22,27,23],[28,3,28,7],[29,4,29,7],[30,4,30,7],[31,4,31,7],[30,25,30,30],[31,25,31,30],[32,25,32,30],[33,25,33,30],[35,25,35,30],[76,25,76,30],[78,25,78,30],[52,25,52,30],[50,25,50,30],[51,25,51,30],[39,4,39,7],[139,17,139,18],[72,25,72,30],[68,25,68,30],[69,25,69,30],[70,25,70,30],[71,25,71,30],[25,22,25,23],[24,22,24,23],[37,25,37,30],[38,25,38,30],[39,25,39,30],[40,25,40,30],[41,25,41,30],[73,25,73,30],[74,25,74,30],[49,25,49,30],[42,25,42,30],[43,25,43,30],[44,25,44,30],[45,25,45,30],[46,25,46,30],[47,25,47,30],[48,25,48,30],[70,22,70,23],[11,1,12,1],[12,3,12,11],[36,25,36,30],[30,22,30,23],[29,22,29,23],[32,4,32,7],[33,3,33,11],[34,3,34,7],[36,4,36,7],[12,25,12,30],[14,25,14,30],[15,25,15,30],[16,25,16,30],[18,25,18,30],[17,25,17,30],[19,25,19,30],[13,25,13,30],[17,4,17,7],[16,22,16,23],[15,22,15,23],[14,22,14,23],[12,22,12,23],[32,22,32,23],[31,22,31,23],[1,2,1,10],[5,2,6,5],[5,6,6,7],[6,8,6,9],[6,10,6,11],[21,25,21,30],[25,4,25,7],[26,4,26,7],[22,4,22,7],[23,4,23,7],[24,4,24,7],[22,25,22,30],[23,25,23,30],[24,25,24,30],[25,25,25,30],[26,25,26,30],[5,21,7,34],[19,3,19,7],[14,4,14,7],[15,4,15,7],[23,22,23,23],[22,22,22,23],[21,22,21,23],[16,4,16,7],[44,4,44,11],[45,4,45,11],[46,4,46,11],[43,4,43,11],[52,4,52,7],[53,4,53,7],[68,22,68,23],[69,22,69,23],[55,4,55,7],[56,4,56,7],[57,3,57,11],[60,22,60,23],[61,22,61,23],[62,22,62,23],[63,22,63,23],[64,22,64,23],[75,4,75,10],[68,4,68,10],[69,4,69,10],[70,4,70,10],[54,4,54,7],[63,4,63,10],[64,4,64,6],[66,4,66,10],[60,4,60,10],[61,4,61,10],[62,4,62,10],[101,1,102,1],[104,2,104,9],[132,17,132,18],[114,6,114,7],[123,4,123,5],[123,6,123,7],[117,4,117,5],[117,6,117,7],[111,4,111,5],[111,6,111,7],[112,4,112,5],[112,6,112,7],[132,3,132,6],[121,4,121,5],[121,6,121,7],[122,4,122,5],[122,6,122,7],[119,4,119,5],[105,3,107,11],[128,17,129,23],[108,9,109,11],[130,17,131,18],[118,4,118,5],[118,6,118,7],[132,20,132,23],[141,20,141,23],[142,20,142,23],[143,20,143,23],[144,20,144,23],[145,17,145,18],[138,20,138,23],[139,20,139,23],[140,20,140,23],[144,17,144,18],[143,17,143,18],[133,17,133,18],[134,17,134,18],[135,17,135,18],[136,17,136,18],[137,17,137,18],[138,17,138,18],[140,17,140,18],[141,17,141,18],[133,20,133,23],[134,20,134,23],[136,20,136,23],[135,20,135,23],[137,20,137,23],[147,21,147,24],[147,26,147,27],[148,21,148,24],[148,26,148,27],[149,21,149,24],[149,26,149,27],[142,17,142,18],[150,21,150,24],[150,26,150,27],[130,20,131,23],[122,27,122,28],[123,27,123,28],[123,23,123,25],[106,23,106,25],[107,23,107,26],[108,23,109,24],[110,23,110,24],[111,23,111,24],[112,23,112,24],[113,23,113,24],[114,23,114,24],[115,23,115,24],[116,23,116,24],[117,23,117,24],[118,23,118,24],[119,23,119,24],[120,23,120,24],[121,23,121,24],[122,23,122,24],[108,27,109,28],[115,27,115,28],[116,27,116,28],[118,27,118,28],[3,2,3,34],[117,27,117,28],[67,4,67,10],[67,22,67,23],[79,4,79,10],[80,3,80,11],[119,6,119,7],[120,4,120,5],[120,6,120,7],[115,4,115,5],[115,6,115,7],[116,4,116,5],[116,6,116,7],[113,4,113,5],[113,6,113,7],[114,4,114,5],[108,6,109,7],[110,4,110,5],[110,6,110,7],[76,4,76,10],[77,4,77,10],[78,4,78,10],[71,3,71,11],[74,4,74,10],[119,27,119,28],[120,27,120,28],[121,27,121,28],[108,4,109,5],[87,4,87,11],[95,23,95,31],[97,3,97,11],[97,23,97,31],[87,22,87,23],[88,22,88,23],[89,22,89,23],[88,25,88,30],[89,25,89,30],[87,25,87,30],[111,27,111,28],[112,27,112,28],[113,27,113,28],[114,27,114,28],[102,2,103,17],[102,18,103,34],[101,2,101,34]]}
[]
[null,null,{"$f":"valDistrName & \" (\"&valorg4code&\")\"","v":"OrgName (DIST)"}]
[]
[null,null,"FY23 IVAQ Grant (Fund Code 209) Budget Worksheet"]
[]
[null,null,"  Total Allocation ",null,null,null,{"$f":"IF(valallocSchedA=\"\", valAllocationESSRIII, valallocSchedA)","v":"FY23 IVAQ Allocation"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To determine FTE, divide total amount on budget line by total salary of staff on the line, then multiply by number of staff on that line. For example, 2 staff are paid $80,000 each from the grant. Their total salaries from all sources amount to $120,000 each. Divide 80,000 by 120,000 to get FTE per staff member (.67 FTE), then multiply by 2. The FTE for that line is 1.3 (round to the nearest tenth)."]
[]
[]
[]
[]
[]
[null,"Step 4.1\nAll Districts"]
[null,null,null,"Line Item Category: Select an option from the drop down menu.",null,null,null,null,null,null,null,null,null,"Amount",null,null,null,"Total Expenditures (whole numbers)",null,null,null,null,"Primary Function",null,null,"Comments"]
[]
[null,null,null,1,"ADMINISTRATOR SALARIES:",null,null,null,null,"# of staff","Total FTE","MTRS",null,null,null,null,null,"Amount",null,null,null,null,"Select from Drop Down List",null,null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M16,R16,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M17,R17,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M18,R18,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(J16:J18)","v":0},{"$f":"SUM(K16:K18)","v":0},null,null,{"$f":"SUM(N16:N18)","v":0},null,null,null,{"$f":"SUM(R16:R18)","v":0}]
[null,null,null,2,"INSTRUCTIONAL/PROF STAFF:",null,null,null,null,"# of staff","Total FTE","MTRS",null,null,null,null,null,"Amount",null,null,null,null,"Select from Drop Down List",null,null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M22, R22,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(J22:J27)","v":0},{"$f":"SUM(K22:K27)","v":0},null,null,{"$f":"SUM(N22:N27)","v":0},null,null,null,{"$f":"SUM(R22:R27)","v":0}]
[null,null,null,3,"SUPPORT STAFF SALARIES:",null,null,null,null,"# of staff","Total FTE","MTRS",null,null,null,null,null,"Amount",null,null,null,null,"Select from Drop Down List",null,null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M31, R31,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M32, R32,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M33, R33,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(J31:J33)","v":0},{"$f":"SUM(K31:K33)","v":0},null,null,{"$f":"SUM(N31:N33)","v":0},null,null,null,{"$f":"SUM(R31:R33)","v":0}]
[null,null,null,4,"STIPENDS:",null,null,null,"# of staff","Rate","Rate Type","MTRS",null,null,null,null,null,"Amount",null,null,null,null,"Select from Drop Down List",null,null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,false,{"$f":"IF(M37, R37,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,false,{"$f":"IF(M38, R38,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,false,{"$f":"IF(M39, R39,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,false,{"$f":"IF(M40, R40,0)","v":0},null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N37:N40)","v":0},null,null,null,{"$f":"SUM(R37:R40)","v":0}]
[null,null,null,5,"FRINGE BENEFITS:",null,null,null,null,null,null,null,null,null,null,null,null,"Amount",null,null,null,null,"Brief Description",null,null,"Budget Detail"]
[null,null,null,null,"5a  MTRS (automatically calculated if MTRS box is checked above)  ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((SUM(N35,N42,N29,N20))*0.09,0)","v":0}]
[null,null,null,null,"5b  Other",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R46:R48)","v":0}]
[null,null,null,null,"Health Insurance"]
[null,null,null,null,"Other Retirement Systems"]
[null,null,null,null,"Federal Insurance Contributions Act (FICA)"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R44:R45)","v":0}]
[null,null,null,6,"CONTRACTUAL SERVICES:",null,null,null,null,"Rate","Rate Type",null,null,null,null,null,null,"Amount",null,null,null,null,"Select from Drop Down List",null,null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R52:R57)","v":0}]
[null,null,null,7,"SUPPLIES AND MATERIALS:",null,null,null,null,null,null,null,null,null,null,null,null,"Amount",null,null,null,null,"Select from Drop Down List",null,null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R61:R64)","v":0}]
[null,null,null,8,"TRAVEL:  (mileage, conference registration, courses, hotels, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,"Amount",null,null,null,null,"Select from Drop Down List",null,null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R68:R71)","v":0}]
[null,null,null,9,"OTHER COSTS:",null,null,null,null,null,null,null,null,null,null,null,null,"Amount",null,null,null,null,"Select from Drop Down List",null,null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R75:R80)","v":0}]
[null,null,null,null,null,"(a) rate (%) \n(e.g., if 3.4%, enter 3.4)",null,null,null,null,null,null,null,null,null,null,null,"Amount"]
[null,null,null,10,"INDIRECT COSTS ",null,null,"(b) eligible allocation less indirect",null,null,{"$f":"IF(G84=\"\",\"\",(valAllocationBudget-(IndExclERF+AB124))/(1+(G84/100)))","v":""}]
[null,null,null,null,null,null,null,"  (c) maximum indirect allowed   ",null,null,{"$f":"IFERROR(ROUNDDOWN(K84*(G84/100), 0),\"\")","v":""}," (a x b)"]
[]
[]
[null,null,null,11,"EQUIPMENT:\nItems costing $5,000+ per unit and having a useful life more than 1 year must be listed",null,null,null,null,null,null,null,null,null,null,null,null,"Amount",null,null,null,null,"Select from Drop Down List",null,null,"Budget Detail"]
[null,null,null,null,"individually and described in Step 6.2, below (these expenditures are not eligible for recovery of indirect cost).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R89:R89)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"         TOTAL FUNDS REQUESTED "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R91+R84+R82+R73+R66+R59+R50+R42+R35+R29+R20","v":0}]
[]
[null,null,null,"                                    DISCREPANCY:  Difference between allocation and budgeted total, if any",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(R96<>valAllocationBudget,R96-valAllocationBudget,\"\"),\"\")","v":""}]
[]
[]
[]
[null,"Step 4.2\nAll districts with large contracts, capital expenditures, and/or equipment expenses"," Major contracts and Capital Expenditures, Including Equipment \nNo Indirect Costs Allowed on These Expenditures"]
[null,null,"Capital Expenditures (Equipment and Other Capital Expenditures)\nIVAQ Funds are subject to the Uniform Grants Guidance (2 CFR 200), which requires that capital expenditures and certain \nequipment have prior written approval from DESE. \n\nCapital expenditures are defined in the Uniform Guidance as “expenditures to acquire capital assets or expenditures to make additions, improvements, modifications, replacements, rearrangements, reinstallations, renovations, or alterations to capital assets \nthat materially increase their value or useful life.” 2 CFR 200.1. Capital assets are any tangible or intangible (software) asset that \nhas a useful life of greater than one year and meets or exceeds the capitalization level of the organization (usually $5,000).  Capital assets include land, buildings/facilities, equipment, intellectual property.  See  2 CFR 200.1 for additional information. Equipment \nis defined as “tangible personal property (including information technology systems) having a useful life of more than one year and\na per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the non-Federal entity for \nfinancial statement purposes, or $5,000.”  2 CFR 200.1\n\nIn order to receive prior approval of any equipment or other capital expenditure, please list them in the appropriate box below -- either \nEquipment or Other Capital Expenditures. Note that Other Capital Expenditures includes capital contracts, such as for renovations or \nfacilities upgrades (such as HVAC). Contracts that are not capital expenditures (such as services contracts for pd, enrichment, etc.) and that \nexceed $25,000 should be listed in the first box. All expenditures listed below should also be included in one of the 11 categories \nof the main budget, above.\n\nCapital Expenditure Approval Form.  Finally, for those capital expenditures (Equipment or Other Capital Expenditures) amounting to $30,000 \nor more (\"Amount\" cell will turn light blue), districts must fill out, sign and submit a Capital Expenditure Approval Form. These forms must be sent by email to  your district liaison with your application. The form can  be found on DESE's Federal Grant Programs IVAQ webpage here.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Indirect costs\n   Indirect costs are those expenses of doing business that are not readily identified with a particular grant, contract, project\n   fund or activity, but are necessary for  the  general operation of the organization and the conduct of the activities it performs.\n   Because these expenses are difficult to track with precision across all benefiting sources, federal grants allow use of a rate as \n   a mechanism for fairly and conveniently apportioning indirect costs across all programs within the boundaries of sound\n   administrative principles. See U.S. Department of Education, Indirect Cost Overview \n   (https://www2.ed.gov/about/offices/list/ocfo/intro.html). \n\n   For this grant, indirect costs must be consistent with the rate established by DESE's Office of School Finance. Note that\n   districts are allowed to take less than the maximum allowable for indirect costs. The decision to recover indirect costs \n   using these established rates is a local option. If indirect costs are recovered, they shall be returned to the general fund \n   of the city or town in accordance with G.L. Chapter 44, Section 53. In the case of regional schools, indirect costs shall be\n   returned to the regional school general fund. www.doe.mass.edu/Grants/essential.html  In calculating the indirect cost\n   allowable for a particular grant, some expenditures are not included. Two such exclusions include a portion of major\n   subawards or subcontracts (those exceeding $25,000), and capital costs (see adjacent box for description). See also,\n    U. S. Department of Education, Cost Allocation Guide for State and Local Governments.\n    https://www2.ed.gov/about/offices/list/ocfo/fipao/guideigcwebsite.pdf\n\n     •  Major Contracts:  For major contracts exceeding $25,000, districts may recover indirect costs on only the first \n      $25,000 of each contract. The remainder of the contract amount is excluded from application of the indirect cost rate. \n      Note that for contracts for professional services normally provided in-house, such as a speech pathologist or school nurse,\n      this exclusion does not apply, even if the contract exceeds $25,000. \n \n       Of course, these expenses are also subject to all other grant requirements (allowability, allocability, necessary and\n       reasonable, etc.) to be properly chargeable to the grant.\n\n                                        \n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"  Non-Capital/Services Contracts exceeding $25,000 \n  (include in budget categories above in addition to listing  individually here). List non-capital contracts\n  exceeding $25,000 below (but not those for professional services normally provided in house)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment and Other Capital Expenditures:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"List Items costing $5,000+ and having a useful life of more than 1 year.  "]
[null,null,null,null,"Amount of contract:",null,"Amount excluded from indirect cost:",null,null,"  Description:",null,null,null,null,null,null,null,null,null,null,null,null,null,"  Description:",null,null,null,"Amount:"]
[]
[null,null,null,null,null,null,{"$f":"IF((E111-25000)>0, (E111-25000), \"\")","v":""},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,null,null,null,null,null,{"$f":"SUM(CapEx,R124,IndConERF)","v":0}]
[null,null,null,null,null,null,{"$f":"IF((E112-25000)>0, (E112-25000), \"\")","v":""}]
[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,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,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"SUM(E111:F123)","v":0},null,{"$f":"SUM(G111:H123)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL",null,null,null,{"$f":"SUM(AB111:AB123)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IndConERF+R124+CapEx","v":0}]

{"sheet":"Schedule A","index":5,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[15,2,16,2],[15,3,16,5],[15,6,16,11],[15,12,16,12],[17,2,18,2],[17,3,18,5],[17,12,18,12],[7,9,7,12],[8,2,8,12],[9,2,9,12],[11,2,11,12],[13,2,14,2],[13,3,14,12],[26,2,26,6],[26,7,26,9],[26,10,26,12],[22,7,22,9],[22,10,22,12],[23,2,23,6],[23,7,23,9],[23,10,23,12],[20,7,21,9],[20,10,21,12],[22,2,22,6],[25,7,25,9],[25,10,25,12],[20,2,21,6],[31,7,32,9],[31,10,32,12],[32,2,32,6],[34,2,35,12],[30,2,30,6],[30,7,30,9],[30,10,30,12],[29,2,29,6],[29,7,29,9],[29,10,29,12],[1,3,1,11],[2,3,5,11],[27,2,27,6],[27,7,27,9],[27,10,27,12],[28,2,28,6],[28,7,28,9],[28,10,28,12],[24,2,24,6],[24,7,24,9],[24,10,24,12],[25,2,25,6],[17,6,18,11]]}
[]
[null,null,null,"Instructions:\n\n "]
[null,null,null," • Fill out and print a copy of Schedule A if you are lead district for a consortium and funds are assigned from other grant recipients to your district (agency).\n\nAttach a pdf of the fully executed Schedule A form to the Lead district's EdGrants submission for each grant for which there are Schedule A assignments of funds. \n"]
[]
[]
[]
[]
[]
[null,null,"MASSACHUSETTS DEPARTMENT OF ELEMENTARY AND SECONDARY EDUCATION"]
[null,null,"STANDARD APPLICATION FOR PROGRAM GRANTS"]
[]
[null,null,"FY23 SCHEDULE A - Assignment Schedule"]
[]
[null,null,1,"Schedule A is to be completed if the applicant agency operates and administers a grant project using funds from more than one grant recipient. Lead district submits with EdGrants submission."]
[]
[null,null,2,"Agency operating and administering the project:  ",null,null,{"$f":"valDistrName","v":"OrgName"},null,null,null,null,null,{"$f":"OrgCode","v":"DIST"}]
[]
[null,null,3,"Name of grant program/\nFund Code:",null,null,"FY23 IVAQ Grant",null,null,null,null,null,"FC 209"]
[]
[]
[null,null,"Name of Participating Agency",null,null,null,null,"Amount of \nAssigned Funds",null,null,"* Authorized Signature"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H23:J31)","v":0}]
[null,null,"Total of Assigned Funds"]
[]
[null,null,"*I/We assign the identified funds to the project described in the accompanying grant application. The indicated agency is authorized to receive and disburse funds for the purpose of operating the project."]

{"sheet":"Dropdowns","index":6,"n_rows":127,"n_cols":3,"rows_kept":127,"cut":false,"hidden":true,"merged":[]}
["Budget Worksheet Dropdowns","YesNo","Rate"]
["Primary Functions","Select One","select"]
["Select One","Yes","per hour"]
["Needs assessment/study of existing school environments","No","per day"]
["Feasibility study - indoor air quality ",null,"flat"]
["Design, bidding assistance, or construction phase services","YesNoNA"]
["Implementation of air quality improvement plans","Select One"]
["Services/materials to ensure operability of windows/doors","Yes"]
["Professional development for facilities directors","No"]
["Other services and/or materials aligned with grant priorities","N/A"]
[]
[]
[]
[]
[]
[]
[null,"YesOnly"]
[null,"Select "]
[null,"Yes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Budget Categories"]
["Administrator Salaries"]
["Select One"]
["Grant Program Manager/Coordinator "]
["Other "]
["InstructionalProf Staff Salaries"]
["Select One"]
["Classroom Teachers  "]
["Instructional Coaches "]
["Certified Specialist Teachers (providing individualized instruction)  "]
["Instructional Coordinators and Team Leaders  "]
["Medical / Therapeutic Services "]
["Librarians and Media Center Directors "]
["Professional Development Directors/Coordinators  "]
["Guidance or School Adjustment Counselors, Social Workers  "]
["Psychological Service Providers "]
["School Physicians and School Nurses  "]
["Other  "]
["Support Staff Salaries"]
["Select One"]
["Non-Clerical Paraprofessionals/Instructional Assistants "]
["Secretary/Bookkeeper/Clerical Support  "]
["Parent Liaisons"]
["Other "]
["Stipends"]
["Select One"]
["Teacher/ Instructional Staff Professional Days"]
["Administrators "]
["Other "]
["Support Staff"]
["Travel"]
["Select One"]
["Grant Program Manager/Coordinator (supervisory)"]
["Certified Classroom Teachers (providing group instruction) "]
["Certified Specialist Teachers (providing individualized instruction)"]
["Non-Clerical Paraprofessionals/Instructional Assistants"]
["Other "]
["Contractual Services"]
["Select One"]
["Instructional Services "]
["Consultants/Professional  Development for Teachers & Support Staff "]
["Substitutes (long and/or short term)"]
["Non-Clerical Paraprofessionals/Instructional Assistants"]
["Secretary/Bookkeeper/Clerical Support "]
["Contracted Service Providers -- Private School Services "]
["Contracted Services Providers -- Other Student Services "]
["Other "]
["Supplies and Materials"]
["Select One"]
["Textbooks and Related Software/Media/Materials "]
["Instructional Technology"]
["Other Instructional Materials (non-testing/assessment)"]
["Testing and Assessment Materials"]
["General Classroom Supplies "]
["Office Supplies  "]
["Other "]
["Other costs"]
["Select One"]
["Memberships/Subscriptions"]
["Advertising  "]
["Student Transportation Services "]
["Rental/Lease of Equipment"]
["Maintenance of Equipment"]
["Maintenance of Technology "]
["Tuition to Non-Public Schools "]
["Tuition to Out-of-State Schools "]
["Tuition to Collaboratives"]
["Rental Lease of Buildings  "]
["Utility Services/ Telephone "]
["Other  "]

{"sheet":"DataLookupValues","index":7,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Workbook Information"]
[]
[]
[]
["District Information"]
["District value",1,null,null,"Liasons"]
["District Name:",{"$f":"VLOOKUP(valDistr,dataDistr,3,FALSE)","v":"OrgName"},"district code",{"$f":"LEFT(VLOOKUP(valDistr,dataDistr,2,FALSE),4)","v":"DIST"},"Name",{"$f":"VLOOKUP(valDistr,dataDistr,12,FALSE)","v":"Liaison's Name"}]
["Address1",{"$f":"VLOOKUP(valDistr,dataDistr,7,FALSE)","v":"ADDR 1"},null,null,"Phone",{"$f":"VLOOKUP(valDistr,dataDistr,13,FALSE)","v":"Liaison's Number"}]
["Address2",{"$f":"IF(VLOOKUP(valDistr,dataDistr,8,FALSE)=0,\"\",VLOOKUP(valDistr,dataDistr,8,FALSE))","v":"ADDR 2"},null,null,"Email",{"$f":"VLOOKUP(valDistr,dataDistr,14,FALSE)","v":"Liaison's Email"}]
["City, State, ZIP",{"$f":"VLOOKUP(valDistr,dataDistr,9,FALSE)&\", \"&VLOOKUP(valDistr,dataDistr,10,FALSE)&\" \"&VLOOKUP(valDistr,dataDistr,11,FALSE)","v":"City, State Zip"}]
["District Enrollment",{"$f":"VLOOKUP(valDistr,dataDistr,17,FALSE)","v":"FY23 IVAQ Allocation"},"EL Enrollment",{"$f":"VLOOKUP(valDistr,dataDistr,16,FALSE)","v":"March 2019 nElCOUNT_sum"}]
["Low Inc Methods TI"]
["SELECT ONE",null,"TitleI Status"]
[null,null,1]
[null,null,2,"SW"]
[null,null,3,"TA"]
[null,null,4,"NT"]
[null,null,5,"CL"]

{"sheet":"dataDistrictList","index":8,"n_rows":142,"n_cols":17,"rows_kept":142,"cut":false,"hidden":true,"merged":[]}
[1,"DISTRICT","OrgName","Org Type","Function","Contact Name","ADDR 1","ADDR 2","City","State","Zip","Liaison's Name","Liaison's Number","Liaison's Email",null,"March 2019 nElCOUNT_sum","FY23 IVAQ Allocation"]
[2,"04450000","Abby Kelley Foster Charter Public (District)","Charter District","Charter School Leader","Heidi Paluk","10 New Bond Street",0,"Worcester","MA","01606","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,255325]
[3,"04120000","Academy Of the Pacific Rim Charter Public (District)","Charter District","Charter School Leader","Oliver Truog","1 Westinghouse Plaza Bldg B",0,"Hyde Park","MA","02136","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,100000]
[4,"04090000","Alma del Mar Charter School (District)","Charter District","Charter School Leader","Taylor DeLoach","515 Belleville Ave",0,"New Bedford","MA","02746","Alex Chiu","781-338-3586","alexandria.w.chiu@mass.gov",null,null,193661]
[5,"35090000","Argosy Collegiate Charter School (District)","Charter District","Charter School Leader","Kristen Pavao","263 Hamlet Street",0,"Fall River","MA","02724","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,106242]
[6,"06150000","Athol-Royalston","Public School District","Superintendent","Darcy Fernandes","1062 Pleasant Street",0,"Athol","MA","01331","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,254582]
[7,"04910000","Atlantis Charter (District)","Charter District","Charter School Leader","Robert Beatty","991 Jefferson St",0,"Fall River","MA","02721","Alex Chiu","781-338-3586","alexandria.w.chiu@mass.gov",null,null,219912]
[8,"00180000","Avon","Public School District","Superintendent","Christine Godino","1 Patrick Clark Drive",0,"Avon","MA","02322","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,170989]
[9,"00200000","Barnstable","Public School District","Superintendent","Sara Ahern","P O Box 955",0,"Hyannis","MA","02601","Alex Chiu","781-338-3586","alexandria.w.chiu@mass.gov",null,null,1206465]
[10,"35020000","Baystate Academy Charter Public School (District)","Charter District","Charter School Leader","Timothy Sneed","2001 Roosevelt Avenue",0,"Springfield","MA","01104","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,100000]
[11,"04200000","Benjamin Banneker Charter Public (District)","Charter District","Charter School Leader","Sherley Bretous-Carre","21 Notre Dame Avenue",0,"Cambridge","MA","02140","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,100000]
[12,"04140000","Berkshire Arts and Technology Charter Public (District)","Charter District","Charter School Leader","James White","1 Commercial Pl","PO Box 267","Adams","MA","01220","Jake Resetarits","781-338-3589","jake.s.resetarits@mass.gov",null,null,100000]
[13,"00350000","Boston","Public School District","Superintendent","Brenda Cassellius","2300 Washington Street",0,"Roxbury","MA","02119","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,15411815]
[14,"04240000","Boston Day and Evening Academy Charter (District)","Charter District","Charter School Leader","Alison Hramiec","20 Kearsarge Ave",0,"Roxbury","MA","02119","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,152663]
[15,"04110000","Boston Green Academy Horace Mann Charter School (District)","Charter District","Charter School Leader","Matthew Holzer","20 Warren St.",0,"Brighton","MA","02135","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,100000]
[16,"04160000","Boston Preparatory Charter Public (District)","Charter District","Charter School Leader","Meekerley Sanon","885 River Street",0,"Hyde Park","MA","02136","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,126549]
[17,"04810000","Boston Renaissance Charter Public (District)","Charter District","Charter School Leader","Alexandra Banhares-Buckmire","1415 Hyde Park Ave",0,"Hyde Park","MA","02136","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,170878]
[18,"04170000","Bridge Boston Charter School (District)","Charter District","Charter School Leader","Craig Martin","435 Warren St.",0,"Roxbury","MA","02119","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,100000]
[19,"00440000","Brockton","Public School District","Superintendent","Michael Thomas","43 Crescent Street",0,"Brockton","MA","02301","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,3472681]
[20,"04280000","Brooke Charter School (District)","Charter District","Charter School Leader","Jon Clark","190 Cummins Highway",0,"Roslindale","MA","02131","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,370233]
[21,"08150000","Cape Cod Regional Vocational Technical","Public School District","Superintendent","Robert Sanborn","351 Pleasant Lake Avenue",0,"Harwich","MA","02645","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,100000]
[22,"00570000","Chelsea","Public School District","Superintendent","Almudena Abeyta","500 Broadway","Room 216","Chelsea","MA","02150","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,1348191]
[23,"00610000","Chicopee","Public School District","Superintendent","Alvin Morton","134 Dulong Circle",0,"Chicopee","MA","01022","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,1414648]
[24,"04180000","Christa McAuliffe Charter Public (District)","Charter District","Charter School Leader","Frederick Randall","139 Newbury St",0,"Framingham","MA","01701","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,100000]
[25,"04370000","City on a Hill Charter Public School Circuit Street (District)","Charter District","Charter School Leader","Sonya Pratt","15 Allerton Street","Suite 1","Roxbury","MA","02119","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,100000]
[26,"00640000","Clinton","Public School District","Superintendent","Steven Meyer","150 School Street",0,"Clinton","MA","01510","Alex Chiu","781-338-3586","alexandria.w.chiu@mass.gov",null,null,356477]
[27,"04380000","Codman Academy Charter Public (District)","Charter District","Charter School Leader","Thabiti Brown","637 Washington Street",0,"Dorchester","MA","02124","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,100000]
[28,"35030000","Collegiate Charter School of Lowell (District)","Charter District","Charter School Leader","Laurie Hodgdon","1857 Middlesex Street",0,"Lowell","MA","01851","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,194652]
[29,"04360000","Community Charter School of Cambridge (District)","Charter District","Charter School Leader","Rebecca Norris","245 Bent Street",0,"Cambridge","MA","02141","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,100000]
[30,"04400000","Community Day Charter Public School - Prospect (District)","Charter District","Charter School Leader","Mary Chance","190 Hampshire Street",0,"Lawrence","MA","01840","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,234275]
[31,"04390000","Conservatory Lab Charter (District)","Charter District","Charter School Leader","John Chistolini","395 Columbia Rd",0,"Dorchester","MA","02125","Alex Chiu","781-338-3586","alexandria.w.chiu@mass.gov",null,null,100000]
[32,"06450000","Dennis-Yarmouth","Public School District","Superintendent","Carol Woodbury","296 Station Avenue",0,"South Yarmouth","MA","02664","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,596558]
[33,"04070000","Dudley Street Neighborhood Charter School (District)","Charter District","Charter School Leader","Elijah Heckstall","6 Shirley Street",0,"Boston","MA","02119","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,142758]
[34,"00850000","Eastham","Public School District","Superintendent","Brooke Clenchy","78 Eldredge Pkwy",0,"Orleans","MA","02653","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,100000]
[35,"00890000","Edgartown","Public School District","Superintendent","Richard Smith","4 Pine Street",0,"Vineyard Haven","MA","02568","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,100000]
[36,"04520000","Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District)","Charter District","Charter School Leader","Caren Walker Gregory","10 Fenwood Road",0,"Boston","MA","02115","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,158855]
[37,"00910000","Erving","Public School District","Superintendent","Jennifer Culkeen","PO Box 7",0,"Erving","MA","01344","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,100000]
[38,"00930000","Everett","Public School District","Superintendent","Priya Tahiliani","121 Vine Street",0,"Everett","MA","02149","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,1451460]
[39,"04100000","Excel Academy Charter (District)","Charter District","Charter School Leader","Owen Stearns","58 Moore Street",0,"East Boston","MA","02128","Alex Chiu","781-338-3586","alexandria.w.chiu@mass.gov",null,null,239723]
[40,"00950000","Fall River","Public School District","Superintendent","Maria Pontes","417 Rock Street",0,"Fall River","MA","02720","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,2618547]
[41,"06620000","Farmington River Reg","Public School District","Superintendent","Thomas Nadolny","555 N Main Street","PO Box 679","Otis","MA","01253","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,100000]
[42,"00970000","Fitchburg","Public School District","Superintendent","Robert Jokela","376 South Street",0,"Fitchburg","MA","01420","Michelle Thomas","781-338-3575","michelle.c.thomas@mass.gov",null,null,1246248]
[43,"00980000","Florida","Public School District","Superintendent","John Franzoni","56 North County Rd",0,"Florida","MA","01247","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,100000]
[44,"04460000","Foxborough Regional Charter (District)","Charter District","Charter School Leader","Anna Azarloza","131 Central Street","35 Commercial Street","Foxborough","MA","02035","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,193661]
[45,"01000000","Framingham","Public School District","Superintendent","Robert Tremblay","19 Flagg Drive",0,"Framingham","MA","01702","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,1494167]
[46,"01030000","Gardner","Public School District","Superintendent","Mark Pellegrino","70 Waterford Street",0,"Gardner","MA","01440","Jake Resetarits","781-338-3589","jake.s.resetarits@mass.gov",null,null,539600]
[47,"06720000","Gateway","Public School District","Superintendent","Kristen Smidy","12 Littleville Road",0,"Huntington","MA","01050","Jake Resetarits","781-338-3589","jake.s.resetarits@mass.gov",null,null,100000]
[48,"06740000","Gill-Montague","Public School District","Superintendent","Brian Beck","35 Crocker Avenue",0,"Turners Falls","MA","01376","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,286752]
[49,"04960000","Global Learning Charter Public (District)","Charter District","Charter School Leader","Stephen Furtado","190 Ashley Boulevard",0,"New Bedford","MA","02746","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,100000]
[50,"01070000","Gloucester","Public School District","Superintendent","Benjamin Lummis","2 Blackburn Drive",0,"Gloucester","MA","01930","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,438200]
[51,"08210000","Greater Fall River Regional Vocational Technical","Public School District","Superintendent","Elvio Ferreira","251 Stonehaven Rd",0,"Fall River","MA","02723","Alex Chiu","781-338-3586","alexandria.w.chiu@mass.gov",null,null,166420]
[52,"08230000","Greater Lawrence Regional Vocational Technical","Public School District","Superintendent","John Lavoie","57 River Rd",0,"Andover","MA","01810","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,295196]
[53,"08280000","Greater Lowell Regional Vocational Technical","Public School District","Superintendent","Jill Davis","250 Pawtucket Blvd",0,"Tyngsborough","MA","01879","Alex Chiu","781-338-3586","alexandria.w.chiu@mass.gov",null,null,331848]
[54,"08250000","Greater New Bedford Regional Vocational Technical","Public School District","Superintendent","Michael Watson","1121 Ashley Blvd",0,"New Bedford","MA","02745","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,356229]
[55,"01140000","Greenfield","Public School District","Superintendent","Christine DeBarge","195 Federal Street, Suite 100",0,"Greenfield","MA","01301","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,334932]
[56,"04990000","Hampden Charter School of Science East (District)","Charter District","Charter School Leader","Tarkan Topcuoglu","20 Johnson Road",0,"Chicopee","MA","01022","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,100000]
[57,"35160000","Hampden Charter School of Science West (District)","Charter District","Charter School Leader","Tarkan Topcuoglu","511 Main St.",0,"West Springfield","MA","01089","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,100000]
[58,"01280000","Haverhill","Public School District","Superintendent","Margaret Marotta","4 Summer Street",0,"Haverhill","MA","01830","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,1713893]
[59,"06850000","Hawlemont","Public School District","Superintendent","Sheryl Stanton","24 Ashfield Rd",0,"Shelburne Falls","MA","01370","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,100000]
[60,"04190000","Helen Y. Davis Leadership Academy Charter Public (District)","Charter District","Charter School Leader","Arturo Forrest","23 Leonard Street",0,"Boston","MA","02122","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,100000]
[61,"01330000","Holbrook","Public School District","Superintendent","Julie Hamilton","245 So. Franklin Street",0,"Holbrook","MA","02343","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,154780]
[62,"01370000","Holyoke","Public School District","Superintendent","Anthony Soto","57 Suffolk Street",0,"Holyoke","MA","01040","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,1819726]
[63,"04530000","Holyoke Community Charter (District)","Charter District","Charter School Leader","Sonia Pope","2200 Northampton Street",0,"Holyoke","MA","01040","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,139426]
[64,"06030000","Hoosac Valley Regional","Public School District","Superintendent","Aaron Dean","191 Church St",0,"Cheshire","MA","01225","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,231663]
[65,"04630000","KIPP Academy Boston Charter School (District)","Charter District","Charter School Leader","Rhonda Barnes","37 Babson Street","KIPP Academy Boston","Mattapan","MA","02126","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,124568]
[66,"04290000","KIPP Academy Lynn Charter (District)","Charter District","Charter School Leader","Rhonda Barnes","90 High Rock Street",0,"Lynn","MA","01902","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,295939]
[67,"01490000","Lawrence","Public School District","Superintendent","Cynthia Paris","237 Essex Street",0,"Lawrence","MA","01840","Jake Resetarits","781-338-3589","jake.s.resetarits@mass.gov",null,null,4576770]
[68,"04540000","Lawrence Family Development Charter (District)","Charter District","Charter School Leader","Ralph Carrero","355 Haverhill Street",0,"Lawrence","MA","01840","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,168649]
[69,"04860000","Learning First Charter Public School(District)","Charter District","Charter School Leader","Leo Flanagan","51 Gage Street",0,"Worcester","MA","01605","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,140912]
[70,"01500000","Lee","Public School District","Superintendent","Michael Richard","300A Greylock St",0,"Lee","MA","01238","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,100000]
[71,"01530000","Leominster","Public School District","Superintendent","Paula Deacon","24 Church Street",0,"Leominster","MA","01453","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,1192620]
[72,"35140000","Libertas Academy Charter School (District)","Charter District","Charter School Leader","Modesto Montero","146 Chestnut Street",0,"Springfield","MA","01103","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,100000]
[73,"01600000","Lowell","Public School District","Superintendent","Joel Boyd","155 Merrimack Street",0,"Lowell","MA","01852","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,4215725]
[74,"04560000","Lowell Community Charter Public (District)","Charter District","Charter School Leader","Nicholas Leonardos","206 Jackson Street",0,"Lowell","MA","01852","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,172116]
[75,"04580000","Lowell Middlesex Academy Charter (District)","Charter District","Charter School Leader","Sean McCarthy","67 Middle St",0,"Lowell","MA","01852","Jake Resetarits","781-338-3589","jake.s.resetarits@mass.gov",null,null,100000]
[76,"01630000","Lynn","Public School District","Superintendent","Patrick Tutwiler","100 Bennett St",0,"Lynn","MA","01905","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,4487170]
[77,"01650000","Malden","Public School District","Superintendent","Ligia Noriega","110 Pleasant St",0,"Malden","MA","02148","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,1320047]
[78,"35170000","Map Academy Charter School (District)","Charter District","Charter School Leader","Rachel Babcock","11 Resnik Road",0,"Plymouth","MA","02360","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,100000]
[79,"01700000","Marlborough","Public School District","Superintendent","Mary Murphy","25 Union Street",0,"Marlborough","MA","01752","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,954408]
[80,"04660000","Martha's Vineyard Charter (District)","Charter District","Charter School Leader","Peter Steedman","PO Box 1150",0,"West Tisbury","MA","02575","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,100000]
[81,"04920000","Martin Luther King Jr. Charter School of Excellence (District)","Charter District","Charter School Leader","Kendra Salvador","285 Dorset Street",0,"Springfield","MA","01108","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,100000]
[82,"04690000","MATCH Charter Public School (District)","Charter District","Charter School Leader","Nnenna Ude","1001 Commonwealth Avenue",0,"Boston","MA","02215","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,242447]
[83,"01810000","Methuen","Public School District","Superintendent","Brandi Kwong","10 Ditson Place",0,"Methuen","MA","01844","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,1138769]
[84,"01850000","Milford","Public School District","Superintendent","Kevin Mcintyre","31 West Fountain Street",0,"Milford","MA","01757","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,677315]
[85,"07170000","Mohawk Trail","Public School District","Superintendent","Sheryl Stanton","24 Ashfield Rd",0,"Shelburne Falls","MA","01370","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,100000]
[86,"04440000","Neighborhood House Charter (District)","Charter District","Charter School Leader","Kate Scott","21 Queen Street",0,"Dorchester","MA","02122","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,131006]
[87,"02010000","New Bedford","Public School District","Superintendent","Thomas Anderson","455 County Street","C/O Paul Rodrigues Administration Bldg.","New Bedford","MA","02740","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,3697832]
[88,"35130000","New Heights Charter School of Brockton (District)","Charter District","Charter School Leader","Omari Walker","1690 Main Street",0,"Brockton","MA","02301","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,124072]
[89,"02090000","North Adams","Public School District","Superintendent","Barbara Malkas","10 Main Street","Second Floor","North Adams","MA","01247","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,315615]
[90,"02150000","North Brookfield","Public School District","Superintendent","Mary Jane Rickson","10 New School Drive",0,"North Brookfield","MA","01535","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,100000]
[91,"08530000","Northeast Metropolitan Regional Vocational Technical","Public School District","Superintendent","David DiBarri","100 Hemlock Rd",0,"Wakefield","MA","01880","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,171373]
[92,"02210000","Oak Bluffs","Public School District","Superintendent","Richard Smith","4 Pine Street",0,"Vineyard Haven","MA","02568","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,131861]
[93,"02230000","Orange","Public School District","Superintendent","Elizabeth Zielinski","507 S. Main Street","P.O. Box 680","Orange","MA","01364","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,100051]
[94,"02270000","Palmer","Public School District","Superintendent","Patricia Gardner","4107 Main Street",0,"Palmer","MA","01069","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,336777]
[95,"35010000","Paulo Freire Social Justice Charter School (District)","Charter District","Charter School Leader","Gilbert Traverso","134 Springfield St",0,"Chicopee","MA","01013","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,100000]
[96,"02290000","Peabody","Public School District","Superintendent","Joshua Vadala","27 Lowell Street",0,"Peabody","MA","01960","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,807442]
[97,"35180000","Phoenix Academy Public Charter High School Lawrence (District)","Charter District","Charter School Leader","Beth Anderson","15 Union Street",0,"Lawrence","MA","01840","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,100000]
[98,"35080000","Phoenix Academy Public Charter High School Springfield (District)","Charter District","Charter School Leader","Beth Anderson","65 Lincoln Street",0,"Springfield","MA","01109","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,100000]
[99,"04930000","Phoenix Charter Academy (District)","Charter District","Charter School Leader","Beth Anderson","175 Hawthorne Street",0,"Chelsea","MA","02150","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,100000]
[100,"04940000","Pioneer Charter School of Science (District)","Charter District","Charter School Leader","Barish Icin","51-59 Summer Street",0,"Everett","MA","02149","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,131254]
[101,"35060000","Pioneer Charter School of Science II (PCSS-II) (District)","Charter District","Charter School Leader","Barish Icin","97 Main Street",0,"Saugus","MA","01906","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,100000]
[102,"02360000","Pittsfield","Public School District","Superintendent","Joseph Curtis","269 First Street",0,"Pittsfield","MA","01201","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,1070419]
[103,"04870000","Prospect Hill Academy Charter (District)","Charter District","Charter School Leader","Angela Allen","50 Essex Street",0,"Cambridge","MA","02139","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,189203]
[104,"02420000","Provincetown","Public School District","Superintendent","Gerry Goyette","Provincetown Schools",0,"Provincetown","MA","02657","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,100000]
[105,"07780000","Quaboag Regional","Public School District","Superintendent","Stephen Duff","284 Old West Brookfield Road","PO Box 1538","Warren","MA","01083","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,303592]
[106,"02430000","Quincy","Public School District","Superintendent","Kevin Mulvey","34 Coddington Street",0,"Quincy","MA","02169","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,1801065]
[107,"07550000","Ralph C Mahar","Public School District","Superintendent","Elizabeth Zielinski","507 South Main Street",0,"Orange","MA","01364","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,100000]
[108,"02440000","Randolph","Public School District","Superintendent","Thea Stovell","40 Highland Avenue",0,"Randolph","MA","02368","Michelle Thomas","781-338-3575","michelle.c.thomas@mass.gov",null,null,768401]
[109,"02480000","Revere","Public School District","Superintendent","Dianne Kelly","101 School Street",0,"Revere","MA","02151","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,1365279]
[110,"02510000","Rockland","Public School District","Superintendent","Alan Cron","34 MacKinlay Way",0,"Rockland","MA","02370","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,422710]
[111,"02530000","Rowe","Public School District","Superintendent","John Franzoni","86 Pond Road",0,"Rowe","MA","01367","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,100000]
[112,"04840000","Roxbury Preparatory Charter (District)","Charter District","Charter School Leader","John Verrilli","120 Fisher Avenue",0,"Roxbury","MA","02120","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,297673]
[113,"04410000","Sabis International Charter (District)","Charter District","Charter School Leader","Justin Baker","160 Joan Street",0,"Springfield","MA","01129","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,243933]
[114,"02580000","Salem","Public School District","Superintendent","Stephen Zrike","29 Highland Avenue",0,"Salem","MA","01970","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,680151]
[115,"04850000","Salem Academy Charter (District)","Charter District","Charter School Leader","Stephanie Callahan","45 Congress Street","c/o Shetland Pk","Salem","MA","01970","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,100000]
[116,"02620000","Saugus","Public School District","Superintendent","Erin McMahon","23 Main Street",0,"Saugus","MA","01906","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,387185]
[117,"02630000","Savoy","Public School District","Superintendent","John Franzoni","26 Chapel Road",0,"Savoy","MA","01256","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,167634]
[118,"04740000","Sizer School: A North Central Charter Essential (District)","Charter District","Charter School Leader","Michelle Paranto","500 Rindge Road",0,"Fitchburg","MA","01420","Nancy Labrie","781-338-3536","nancy.h.labrie@mass.gov",null,null,100000]
[119,"02740000","Somerville","Public School District","Superintendent","Mary Skipper","8 Bonair Street",0,"Somerville","MA","02145","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,760884]
[120,"08290000","South Middlesex Regional Vocational Technical","Public School District","Superintendent","Jonathan Evans","750 Winter Street",0,"Framingham","MA","01702","Michelle Thomas","781-338-3575","michelle.c.thomas@mass.gov",null,null,206650]
[121,"02770000","Southbridge","Public School District","Superintendent","Jeffrey Villar","132 Torrey Rd",0,"Southbridge","MA","01550","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,471385]
[122,"08720000","Southeastern Regional Vocational Technical","Public School District","Superintendent","Luis Lopes","250 Foundry Street",0,"South Easton","MA","02375","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,256180]
[123,"07670000","Spencer-E Brookfield","Public School District","Superintendent","Paul Haughey","306 Main Street",0,"Spencer","MA","01562","Colleen Holforty","781-338-3522","colleen.e.holforty@mass.gov",null,null,256675]
[124,"02810000","Springfield","Public School District","Superintendent","Daniel Warwick","1550 Main Street",0,"Springfield","MA","01103","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,6280294]
[125,"35100000","Springfield Preparatory Charter School (District)","Charter District","Charter School Leader","Bill Spirer","2071 Roosevelt Avenue",0,"Springfield","MA","01104","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,100000]
[126,"02850000","Stoughton","Public School District","Superintendent","Thomas Raab","31 Pierce Street",0,"Stoughton","MA","02072","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,496397]
[127,"02930000","Taunton","Public School District","Superintendent","John Cabral","215 Harris Street",0,"Taunton","MA","02780","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,1444366]
[128,"02960000","Tisbury","Public School District","Superintendent","Richard Smith","4 Pine Street",0,"Vineyard Haven","MA","02568","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,100000]
[129,"03000000","Truro","Public School District","Superintendent","Stephanie Costigan","P O Box 2029",0,"Truro","MA","02666","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,100000]
[130,"04800000","UP Academy Charter School of Boston (District)","Charter District","Charter School Leader","James Frier","215 Dorchester Street",0,"Boston","MA","02127","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,145729]
[131,"35050000","UP Academy Charter School of Dorchester (District)","Charter District","Charter School Leader","Ariella Silverstein-Tapp","35 Westville Street",0,"Boston","MA","02124","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,216061]
[132,"04980000","Veritas Preparatory Charter School (District)","Charter District","Charter School Leader","Rachel Romano","370 Pine Street",0,"Springfield","MA","01105","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,100000]
[133,"03060000","Wales","Public School District","Superintendent","Deborah Boyd","320 Brookfield Rd",0,"Fiskdale","MA","01518","Jake Resetarits","781-338-3589","jake.s.resetarits@mass.gov",null,null,100000]
[134,"03080000","Waltham","Public School District","Superintendent","Brian Reagan","617 Lexington Street",0,"Waltham","MA","02452","Sue Mazzarella","781-338-3587","susan.mazzarella@mass.gov",null,null,781327]
[135,"03090000","Ware","Public School District","Superintendent","Marlene Di Leo","P O Box 240",0,"Ware","MA","01082","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,418364]
[136,"03100000","Wareham","Public School District","Superintendent","Matthew D'Andrea","Central Office, 4 Viking Drive, Door 22",0,"Wareham","MA","02571","Ellie Rounds-Bloom","781-338-3128","eleanor.rounds@mass.gov",null,null,426313]
[137,"03160000","Webster","Public School District","Superintendent","Ruthann Petruno-Goguen","77 Poland Street",0,"Webster","MA","01570","Michelle Thomas","781-338-3575","michelle.c.thomas@mass.gov",null,null,315999]
[138,"03180000","Wellfleet","Public School District","Superintendent","Brooke Clenchy","78 Eldredge Pkwy",0,"Orleans","MA","02653","Julia Foodman","781-338-3577","julia.b.foodman@mass.gov",null,null,100000]
[139,"03320000","West Springfield","Public School District","Superintendent","Vito Perrone","11 Central Street",0,"West Springfield","MA","01089","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,643004]
[140,"03250000","Westfield","Public School District","Superintendent","Stefan Czaporowski","94 North Elm Street","Suite 101","Westfield","MA","01085","Alex Lilley","781-338-6212","alex.j.lilley@mass.gov",null,null,771150]
[141,"03430000","Winchendon","Public School District","Superintendent","Thaddeus King","175 Grove Street",0,"Winchendon","MA","01475","Dessi Kirova","781-338-3132","dessi.g.kirova@mass.gov",null,null,261133]
[142,"03480000","Worcester","Public School District","Superintendent","Rachel Monarrez","20 Irving Street",0,"Worcester","MA","01609","Jake Resetarits","781-338-3589","jake.s.resetarits@mass.gov",null,null,7185226]