{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["READ ME 1ST","1. Signature Page","2. Contact Information ","3. Private School Services","4.  Fund Code 186 Narrative","5. Fund Code 186 Budget","dataLookupValues","dataDistrictList","Dropdowns"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":86,"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":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[56,2,56,4],[57,2,57,4],[47,2,47,4],[51,1,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[55,2,55,4],[43,2,43,4],[28,1,28,12],[29,1,29,12],[30,1,30,12],[31,1,31,11],[32,1,32,11],[35,2,35,4],[36,2,36,4],[37,2,37,4],[39,1,39,4],[40,1,40,4],[41,2,41,4],[27,1,27,12],[1,1,1,11],[2,1,2,11],[3,1,3,12],[4,1,4,11],[5,1,13,12],[14,1,14,12],[15,1,15,12],[16,1,16,12],[17,1,24,12],[25,1,25,12],[26,1,26,12]]}
[]
[null,"Massachusetts Department of Elementary & Secondary Education"]
[null,"FY20 Consolidated Federal ESEA Programs Application Workbook, Addendum for Title III, Part A, Immigrant Children and Youth (Fund Code 186)"]
[null,"Overview  "]
[null,"This Excel workbook contains the FY18 Title I grant application forms that a school district must submit to the Massachusetts Department of Elementary and Secondary Education. Information about the FY18 Title I grant can be found at http://www.doe.mass.edu/grants/."]
[null,"\nThis addendum supplements the consolidated application for subgrants for any combination of the federal programs authorized by the Elementary and Secondary Education Act (ESEA), as most recently reauthorized by the Every Student Succeeds Act (2015) (ESSA) (Titles I, Parts A & D, Title II, Part A; Title III, Part A; and Title IV, Part A).  Specifically, this addendum is for eligible districts applying for:                                                                       \n                                                       • Title III, Part A, Immigrant Children and Youth (Fund Code 186)\n\nESSA defines \"immigrant child or youth\" as an individual who 1) is aged 3 to 21 years, 2) was not born in any state, and 3) has not been attending one or more schools in any one or more states for more than 3 full academic years.  For the purposes of this definition, a student's legal status is irrelevant, and the District of Columbia and Puerto Rico are considered states.\n                                                                                                   \nYou may notice that some requirements of past applications have been omitted or are requested in a different way, which is permitted by ESSA to reduce burden to districts when applying for grants.  However, all districts are still required to meet all statutory requirements for any program for which they receive funds.  If you have questions about these requirements, please refer to our Federal Grant Programs web pages and/or contact the Federal Programs Specialist assigned to your district for guidance.\n\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 'FY20CAIMM-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) for the workbook to function properly."]
[null,"Tips for Completing this Addendum to the Consolidated Application"]
[null,"  \n Workflow and printing:  \n    • Complete each tab in the order that they are numbered unless instructed otherwise.  \n\n    • Complete the steps on each tab in the order that they are numbered (for example, on Tab 3, begin with Step 3.1, then complete 3.2).\n      Note that some steps may not be required for your district and may be skipped.\n\n   •  The budget worksheet appearing after the Title III, Immigrant subgrant narrative must be completed. It mirrors the budget entry \n     page in EdGrants with the addition of checkboxes to indicate whether funds are used for private school services.  This budget \n     worksheet is mandatory and 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 \n       to set the appearance and 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\n       the source of the information has no excel formulas.  \n\n   •  Those cells that appear light gray will automatically populate based on information districts supply on the application or from\n       preloaded data already reported to the Department of Elementary and Secondary Education (DESE) (for example, SIMS data).   \n       Do not cut and paste information from other pages or 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 or \n       \"other,\" which requires districts to supply a brief description where indicated.   Do not cut and paste information from other pages \n       or sources into orange cells!  \n\n   •  Throughout the tabs of this application you will find instruction boxes (gray), tip boxes (pink) to help avoid common mistakes, \n       and resource boxes (tan) that include links to materials outside the application with more detailed, grant-related information.\n"]
[]
[]
[]
[]
[]
[]
[]
[null,"\n    Last Steps:\n   •  Signature Page (Tab 1) :  Once the application has been completed, print, sign, date (using date of submission), scan and upload \n      a signed copy of the signature page with your district's EdGrants submissions for Fund Code 186.   We cannot approve\n      any grant without an uploaded, signed, and properly dated signature page!\n \n   •  A completed addendum to your consolidated workbook (this workbook) should be submitted as an attachment in EdGrants with \n      the district's submission for Title III, Part A Immigrant Children and Youth (FC 186) subgrant submission. "]
[null,"Submit this FY20 Addendum to the Consolidated Application  (Fund Code 186) via EdGrants Front Office web page"]
[null,"\nEdGrants 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 user name/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@doe.mass.edu, 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. "]
[null,"Applications are due by March 16, 2020"]
[null,"NOTE ON SUBMISSION TIMELINE: \n\n    • The start date for your Fund Code 186 grant is the date on which the district submits substantially approvable information and budget for this grant.  \n       For example, if the completed addendum to the consolidated ESSA application is submitted on February 25, 2020 and all grant information is\n       substantially approvable, the start date for this grant will be February 25, 2020 even if you do not receive notice of approval until March.  \n    •  Expenses incurred prior to approval of a district's consolidated application and start date(s) are not payable with grant funds!\n    •  Responding quickly to requests for information can facilitate approval of your grant application.  \n    •  Grant payment notices will be available in EdGrants after the grant application has been approved and processed.\n"]

{"sheet":"1. Signature Page","index":1,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,2,31,20],[22,2,22,5],[22,6,22,11],[22,13,22,14],[22,15,22,19],[26,2,28,4],[26,5,26,9],[26,10,26,16],[26,17,26,20],[27,5,28,9],[27,10,27,13],[27,14,27,16],[27,17,28,20],[28,10,28,13],[28,14,28,16],[12,6,12,12],[18,2,19,20],[21,2,21,5],[21,6,21,11],[21,13,21,14],[21,15,21,19],[11,6,11,12],[1,2,1,9],[1,18,1,20],[2,2,3,20],[5,2,5,20],[6,2,6,20]]}
[]
[]
[null,null,"Massachusetts Department of Elementary and Secondary Education\nSTANDARD CONTRACT FORM AND APPLICATION FOR PROGRAM GRANTS"]
[]
[]
[null,null,"UPLOAD A SCANNED, SIGNED COPY OF THIS PAGE WITH THE DATE OF SUBMISSION TO EDGRANTS WITH THE BUDGET "]
[null,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 district control user with access to EdGrants to submit budgets and attachments  for each fund code for which the district is applying.                                                              \n                 Applications are due by March 16, 2020"]
[]
[]
[null,null,null,null,"District Name:",null,null,null,null,null,null,null,null,"Code:",null,{"$f":"valorg4code","v":"Org "}]
[]
[null,null,null,null,"Address: ",null,{"$f":"valaddr1","v":"Address 1"},null,null,null,null,null,null,"DESE Federal Grant Liaison",null,{"$f":"valname","v":"Liaison's Name"}]
[null,null,null,null,null,null,{"$f":"valCtystzip","v":"Town, 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,null,"Email:",null,{"$f":"valemail","v":"Liaison's Email"}]
[]
[]
[null,null,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."]
[]
[]
[null,null,"AUTHORIZED SIGNATURE:",null,null,null,null,null,null,null,null,null,null,"TITLE:"]
[null,null,"PRINTED NAME:",null,null,null,null,null,null,null,null,null,null,"SUBMISSION DATE:"]
[]
[]
[]
[null,null,"FY2020 \nAllocation",null,null,"FEDERALGRANT",null,null,null,null,"PROJECT DURATION",null,null,null,null,null,null,"TOTAL ALLOCATION"]
[null,null,null,null,null,"Title III, Part A\nFund Code 186",null,null,null,null,"FROM",null,null,null,"TO",null,null,{"$f":"valAllocation","v":"FC 186 Allocation"}]
[null,null,null,null,null,null,null,null,null,null,"UPON APPROVAL",null,null,null,"6/30/2020"]
[]
[]
[null,null,"UPLOAD A SCANNED, SIGNED COPY OF THIS PAGE WITH THE DATE OF SUBMISSION TO EDGRANTS WITH THE BUDGET FOR EACH FUND CODE\nBY MARCH 16, 2020"]

{"sheet":"2. Contact Information ","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,2,6,11],[7,2,7,11],[1,1,1,3],[2,1,2,11],[2,13,4,17],[3,1,3,11],[4,1,4,3],[4,4,4,11],[5,1,5,2],[5,3,5,11]]}
[]
[null,{"$f":"valDistrName & \" (\"&valorg4code&\")\"","v":"Org Name (Org )"}]
[null,"District Contact Information by Program\nPlease provide information for primary district contact for each program"]
[null,"Title III, Part A, Immigrant Children and Youth (Fund Code 186)"]
[null,"Name of Primary Contact:"]
[null,"Title:"]
[null,"Phone:"]
[null,"Email:"]

{"sheet":"3. Private School Services","index":3,"n_rows":143,"n_cols":11,"rows_kept":143,"cut":false,"hidden":false,"merged":[[45,8,131,12],[31,8,31,12],[32,8,37,12],[38,8,40,12],[41,8,42,12],[43,8,44,12],[134,2,134,4],[136,2,136,9],[139,2,139,3],[142,2,142,3],[139,4,139,10],[140,2,140,10],[142,4,142,10],[134,10,135,10],[138,2,138,11],[1,2,1,6],[2,2,2,11],[4,2,4,11],[12,2,12,4],[15,8,16,8],[9,2,9,4],[28,2,28,6],[14,2,15,2],[14,3,15,3],[26,2,26,6],[17,2,17,7],[20,2,20,7],[23,2,23,4],[18,2,18,7],[19,2,19,7]]}
[]
[null,null,{"$f":"valDistrName & \" (\"&valorg4code&\")\"","v":"Org Name (Org )"}]
[null,null,"Non-Profit Private School Participation Worksheets"]
[]
[null,null,"ESSA requires the equitable participation of students and educators in private, non-profit schools for federally funded programs and services, including Title III, Part A, Immigrant Children and Youth (Fund Code 186). The public school district is required to have \"timely and meaningful consultation\" with private school officials regarding the participation of private school students and educators in ESSA-funded programs and services. The public school district is responsible for providing equitable services and must retain control of the federal funds used to provide such services. Therefore, equitable services are provided by either an employee of the district or through a contract by the district with an individual, association, agency, or organization. Reimbursement to participating private schools is not allowable."]
[]
[null,null,"Resources:"]
[null,null,"Private School Equitable Services under ESSA"]
[null,null,"Consolidated Affirmation of Consultation"]
[null,null,"DESE's ombudsman for equitable services for private schools is Russ Fleming, who can be reached at ESEAequitableservices@doe.mass.edu or 781-338-6259."]
[]
[]
[null,null,"Step 3.1\nTotal enrollment of immigrant students per October 2020 SIMS data and your district's Fund Code 186 allocation will prepopulate. Once you have entered all data for participating private school students, the total reservation for services for private school immigrant students will populate automatically."]
[]
[null,null,"District immigrant enrollment,October 2020 (SIMS)",{"$f":"IFERROR(valImmigrantCount, \" \")","v":" "}]
[null,null,null,null,null,null,null,null,"Title III, Part A\nImmigrant Children and Youth"]
[]
[null,null,"Total district allocation for Fund Code 186 ",null,null,null,null,null,{"$f":"valAllocation","v":"FC 186 Allocation"}]
[null,null,"Amount reserved by district for administrative costs"]
[null,null,"Amount available after subtracting administrative costs",null,null,null,null,null,{"$f":"IFERROR(I18-I19,\" \")","v":" "}]
[null,null,"Total amount that must be reserved for equitable services.  See below for allocations for each private school.",null,null,null,null,null,{"$f":"IF(G132>0, G132, \" \")","v":" "}]
[]
[]
[null,null,"Step 3.2 \nComplete worksheet in each section for individual private schools for each federal program."]
[]
[]
[null,null,"Titles III, Part A:  Immigrant Students and Youth (Fund Code 186)"]
[]
[null,null,"Title III, Part A:  Private Schools Serving Eligible Children Residing in District"]
[null,null,"\n\nList private schools located within district boundaries      ","Will this Private School Participate in Title III, Part A, Fund Code 186?\n(Yes or No)","Total Number of Immigrant Students Enrolled in Private School\n(not including preschool students)","Title III, Part A\n(Fund Code 186): \nAmount Per Pupil","Title III, Part A (Fund Code 186): Total Allocation for Private School Services, by School"]
[null,null,"A","B","C","D","E"]
[null,null,null,"Select One",null,{"$f":"IF(D32=\"Yes\",IFERROR($I$20/($D$15+$G$133),0), 0)","v":0},{"$f":"IFERROR(F32*E32, 0)","v":0},null,"Instructions:"]
[null,null,null,"Select One",null,{"$f":"IF(D33=\"Yes\",IFERROR($I$20/($D$15+$G$133),0), 0)","v":0},{"$f":"IFERROR(F33*E33, 0)","v":0},null,"Column A:  List the private schools located in the district boundaries and the number of immigrant students enrolled in each (see \"TIP\" for definition of immigrant children and youth). The list represents the private schools that have been contacted regarding eligibility and participation in the district’s  Title III, Part A immigrant programs. Indicate whether each listed school has chosen to participate by selecting from the drop-down menu."]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0,null,"Column B: Indicate whether the private school has elected to participate in the program identified in the column heading (yes or no)."]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0,null,"Column C: Indicate the number of immigrant students attending the listed private school."]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0,null,"Column D: This column will automatically populate based on your Title III, Part A Fund Code 186 funding after subtracting administrative expenses."]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0,null,"Column E:  This column will automatically populate based on the number of eligible students for this for each program (both district and private school).  Because the figures are reported in whole dollars, you might notice some discrepancies between per-pupil amounts and total allocated per school due to rounding issues -- rely on the total allocation by school for funding private school services."]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,{"$f":"IF(D97=\"Yes\",IFERROR($I$20/($D$15+$G$133),0), 0)","v":0},{"$f":"IFERROR(F97*E97, 0)","v":0}]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,"Select One",null,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G32:G131)","v":0}]
[null,null,null,null,null,"Title III FC 186 Total Private School Participation",{"$f":"SUMIF(D32:D131, \"Yes\", E32:E131)","v":0}]
[]
[null,null,"Step 3.3\nAnswer questions about Title III, Part A, Immigrant Children and Youth (Fund Code 186) services for private schools",null,null,null,null,null,null,null,"Title III, Part A: Immigrant Children and Youth"]
[]
[null,null,"  Has the district contacted all private schools located within district boundaries to inquire about  participation in  \n  Title III, Part A, Immigrant Children and Youth for their eligible students, with evidence of such outreach on file?  (select yes/no) ",null,null,null,null,null,null,null,"Select One"]
[]
[null,null,"1. What Title III, Part A services will be provided to immigrant students and youth in participating private schools? (Select primary service from dropdown menu; describe additional services in yellow box)."]
[null,null,"Select One"]
[null,null,"2. How will the district assess the impact of Title III, Part A services on participating immigrant students and youth in private schools? (Select primary source from dropdown menu; list additional sources in \"Other\")."]
[]
[null,null,"Select One"]

{"sheet":"4.  Fund Code 186 Narrative","index":4,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,11,22,13],[24,1,24,3],[25,1,31,3],[25,4,31,13],[20,2,20,5],[22,2,22,5],[20,11,20,13],[21,2,21,5],[21,11,21,13],[18,11,18,13],[19,2,19,5],[19,11,19,13],[17,2,17,5],[17,11,17,13],[18,2,18,5],[14,2,14,5],[14,11,14,13],[15,2,15,5],[15,11,15,13],[16,2,16,5],[16,11,16,13],[12,11,12,13],[11,1,11,5],[12,1,12,5],[12,7,12,8],[12,9,12,10],[11,7,11,10],[11,11,11,13],[10,1,10,3],[6,1,6,3],[7,1,7,7],[1,1,1,6],[2,1,2,3],[2,4,2,12],[4,1,4,12]]}
[]
[null,{"$f":"valDistrName & \" (\"&valorg4code&\")\"","v":"Org Name (Org )"}]
[null,"Title III, Part A",null,null,"Immigrant Children and Youth (Fund Code 186)"]
[]
[null,"  This grant must be used to pay for activities that provide enhanced instructional opportunities for immigrant children and youth, which may include: \n\n  (A) family literacy, parent and family outreach, and training activities designed to assist parents and families to become active participants in the education of their children; \n  (B) recruitment of, and support for, personnel, including teachers and paraprofessionals who have been specifically trained, or are being trained, to provide services to immigrant \n        children and youth; \n  (C) provision of tutorials, mentoring, and academic or career counseling for immigrant children and youth;\n  (D) identification, development, and acquisition of curricular materials, educational software, and technologies to be used in the program carried out with awarded funds; \n  (E) basic instructional services that are directly attributable to the presence of immigrant children and youth in the local educational agency involved, including the payment of \n        costs of providing additional classroom supplies, costs of transportation, or such other costs as are directly attributable to such additional basic instructional services; \n  (F) other instructional services that are designed to assist immigrant children and youth to achieve in elementary schools and secondary schools in the United States, \n        such as programs of introduction to the educational system and civics education; and\n  (G) activities, coordinated with community-based organizations, institutions of higher education, private sector entities, or other entities with expertise in working with immigrants, \n         to assist parents and families of immigrant children and youth by offering comprehensive community services. \n\nESSA defines \"immigrant child or youth\" as an individual who 1) is aged 3 to 21 years, 2) was not born in any state, and 3) has not been attending one or more schools in any one or more states for more than 3 full academic years.  For the purposes of this definition, a student's legal status is irrelevant, and the District of Columbia and Puerto Rico are considered states.\n"]
[]
[null,"STEP 4.1"]
[null,"Have you submitted and received approval for a Title III, Part A grant for FY20, either individually or as part of a consortium (Schedule A)?",null,null,null,null,null,null,"Select One"]
[]
[]
[null,"STEP 4.2"]
[null,"A",null,null,null,null,"B","C",null,null,null,"D"]
[null,"\nDescribe the activities funded by Title III , Part A, subgrant for immigrant Children and Youth and how they respond to your district's needs assessment \n(for reference, see the above, non-exclusive list of appropriate activities)",null,null,null,null,"Supplemental to federal, state, and local funding?\n","What data prompted this activity?\n(Select at least one source for each activity; report additional sources/explanation in \"Other\" box at row's end)",null,"What data will you use to determine progress and attainment of goals?\n(Select at least one source for each activity; report additional sources/explanation in \"Other\" box at row's end)",null,"If  you selected \"Other\" in Column C for any activity,  please describe data that you will use  here"]
[null,null,"A"]
[null,1,null,null,null,null,"Select One","Select One","Select One","Select One","Select One"]
[null,2,null,null,null,null,"Select One","Select One","Select One","Select One","Select One"]
[null,3,null,null,null,null,"Select One","Select One","Select One","Select One","Select One"]
[null,4,null,null,null,null,"Select One","Select One","Select One","Select One","Select One"]
[null,5,null,null,null,null,"Select One","Select One","Select One","Select One","Select One"]
[null,6,null,null,null,null,"Select One","Select One","Select One","Select One","Select One"]
[null,7,null,null,null,null,"Select One","Select One","Select One","Select One","Select One"]
[null,8,null,null,null,null,"Select One","Select One","Select One","Select One","Select One"]
[null,9,null,null,null,null,"Select One","Select One","Select One","Select One","Select One"]

{"sheet":"5. Fund Code 186 Budget","index":5,"n_rows":129,"n_cols":30,"rows_kept":129,"cut":false,"hidden":false,"merged":[[7,4,7,6],[7,7,7,8],[14,1,15,1],[14,3,14,23],[15,4,15,12],[15,21,15,22],[1,3,1,11],[1,21,1,23],[2,21,2,22],[3,3,3,23],[6,4,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[20,5,20,8],[20,21,20,22],[21,21,21,22],[22,4,22,8],[23,21,23,22],[24,5,24,8],[24,21,24,22],[17,5,17,8],[17,21,17,22],[18,5,18,8],[18,21,18,22],[19,5,19,8],[19,21,19,22],[28,5,28,8],[28,21,28,22],[29,5,29,8],[29,21,29,22],[30,4,30,12],[30,21,30,22],[25,5,25,8],[25,21,25,22],[26,5,26,8],[26,21,26,22],[27,5,27,8],[27,21,27,22],[35,5,35,8],[35,21,35,22],[36,4,36,12],[37,4,37,8],[38,21,38,22],[39,5,39,8],[39,21,39,22],[31,4,31,8],[32,5,32,8],[32,21,32,22],[33,5,33,8],[33,21,33,22],[34,5,34,8],[34,21,34,22],[43,4,43,12],[44,4,44,8],[45,5,45,12],[45,21,45,22],[46,5,46,12],[46,21,46,22],[40,5,40,8],[40,21,40,22],[41,5,41,8],[41,21,41,22],[42,5,42,8],[42,21,42,22],[50,5,50,12],[50,21,50,22],[51,4,51,12],[53,21,53,22],[54,5,54,8],[54,21,54,22],[47,5,47,12],[47,21,47,22],[48,5,48,12],[48,21,48,22],[49,5,49,12],[49,21,49,22],[58,5,58,8],[58,21,58,22],[59,5,59,8],[59,21,59,22],[60,4,60,12],[62,21,62,22],[55,5,55,8],[55,21,55,22],[56,5,56,8],[56,21,56,22],[57,5,57,8],[57,21,57,22],[66,5,66,11],[66,21,66,22],[67,5,67,7],[69,5,69,11],[69,21,69,22],[70,5,70,11],[70,21,70,22],[63,5,63,11],[63,21,63,22],[64,5,64,11],[64,21,64,22],[65,5,65,11],[65,21,65,22],[74,4,74,12],[76,21,76,22],[77,5,77,11],[77,21,77,22],[78,5,78,11],[78,21,78,22],[71,5,71,11],[71,21,71,22],[72,5,72,11],[72,21,72,22],[73,5,73,11],[73,21,73,22],[82,5,82,11],[82,21,82,22],[83,4,83,12],[85,10,85,11],[86,10,86,11],[87,10,87,11],[79,5,79,11],[79,21,79,22],[80,5,80,11],[80,21,80,22],[81,5,81,11],[81,21,81,22],[106,1,107,1],[106,3,106,27],[107,3,108,27],[101,21,102,24],[90,5,90,12],[90,21,90,22],[91,21,91,22],[92,5,92,11],[92,21,92,22],[93,21,93,22],[109,3,109,10],[112,19,112,22],[113,5,114,6],[113,7,114,8],[113,10,114,16],[114,19,114,20],[96,24,97,25],[97,12,97,18],[101,4,101,12],[115,5,115,6],[115,7,115,8],[116,5,116,6],[116,7,116,8],[113,19,113,20],[115,19,115,20],[116,19,116,20],[117,19,117,20],[118,19,118,20],[119,5,119,6],[119,7,119,8],[120,5,120,6],[120,7,120,8],[119,19,119,20],[120,19,120,20],[117,5,117,6],[117,7,117,8],[118,5,118,6],[118,7,118,8],[128,5,128,6],[128,7,128,8],[127,19,127,20],[125,5,125,6],[125,7,125,8],[126,5,126,6],[126,7,126,8],[125,19,125,20],[126,19,126,20],[123,5,123,6],[123,7,123,8],[124,5,124,6],[124,7,124,8],[123,19,123,20],[124,19,124,20],[121,5,121,6],[127,5,127,6],[127,7,127,8],[121,7,121,8],[122,5,122,6],[122,7,122,8],[121,19,121,20],[122,19,122,20]]}
[]
[null,null,null,{"$f":"valDistrName & \" (\"&valorg4code&\")\"","v":"Org Name (Org )"}]
[]
[null,null,null,"FY20 Title III, Part A (Fund Code 186) Budget Worksheet"]
[]
[]
[null,null,null,null,"Allocation (before any flexing)",null,null,{"$f":"valAllocation","v":"FC 186 Allocation"}]
[null,null,null,null,"Reservation for Equitable (Private-School) Services",null,null,{"$f":"IFERROR(ROUND(valPrivateSchool186, 0), \"0\")","v":"0"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"OrgName"]
[null,null,null,null,null,null,null,null,null,null,"OrgName"]
[]
[]
[null,"Step 5.1\nAllDistricts "]
[null,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,"Expenditures (whole numbers)",null,null,"Primary Function",null,"Comments",null,null,null,"Amount Included in this line item for Equitable Services "]
[]
[null,null,null,null,1,"ADMINISTRATOR SALARIES:",null,null,null,null,"# of staff","Total FTE","MTRS",null,null,null,"Amount",null,null,"Select from Drop Down List",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(N19,Q19,0)","v":0},null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(N20,Q20,0)","v":0},null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(N21,Q21,0)","v":0},null,null,null,null,"Select One"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(K19:K21)","v":0},{"$f":"SUM(L19:L21)","v":0},null,null,{"$f":"SUM(O19:O21)","v":0},null,{"$f":"SUM(Q19:Q21)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z19:Z21)","v":0}]
[null,null,null,null,2,"INSTRUCTIONAL/PROF STAFF:",null,null,null,null,"# of staff","Total FTE","MTRS",null,null,null,"Amount",null,null,"Select from Drop Down List",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(N25, Q25,0)","v":0},null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,"Select One"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(K25:K30)","v":0},{"$f":"SUM(L25:L30)","v":0},null,null,{"$f":"SUM(O25:O30)","v":0},null,{"$f":"SUM(Q25:Q30)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z25:Z30)","v":0}]
[null,null,null,null,3,"SUPPORT STAFF SALARIES:",null,null,null,null,"# of staff","Total FTE","MTRS",null,null,null,"Amount",null,null,"Select from Drop Down List",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(N34, Q34, 0)","v":0},null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(N35, Q35, 0)","v":0},null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,null,"Select One"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(K34:K36)","v":0},{"$f":"SUM(L34:L36)","v":0},null,null,{"$f":"SUM(O34:O36)","v":0},null,{"$f":"SUM(Q34:Q36)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z34:Z36)","v":0}]
[null,null,null,null,4,"STIPENDS:",null,null,null,"# of Staff","Rate","Rate Type","MTRS",null,null,null,"Amount",null,null,"Select from Drop Down List",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,false,{"$f":"IF(N40, Q40, 0)","v":0},null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,false,{"$f":"IF(N41, Q41, 0)","v":0},null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,false,0,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,false,0,null,null,null,null,"Select One"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O40:O43)","v":0},null,{"$f":"SUM(Q40:Q43)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z40:Z43)","v":0}]
[null,null,null,null,5,"FRINGE BENEFITS:",null,null,null,null,null,null,null,null,null,null,"Amount",null,null,"Brief Description",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"5a  MTRS (automatically calculated if MTRS box is checked)  ",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((SUM(O45,O38,O32,O23))*0.09,0)","v":0}]
[null,null,null,null,null,"5b  Other",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q49:Q51)","v":0}]
[null,null,null,null,null,"Health Insurance"]
[null,null,null,null,null,"Other Retirement Systems"]
[null,null,null,null,null,"Federal Insurance Contributions Act (FICA)"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q47:Q48)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z47, Z49:Z51)","v":0}]
[null,null,null,null,6,"CONTRACTUAL SERVICES:",null,null,null,null,"Rate","Rate Type",null,null,null,null,"Amount",null,null,"Select from Drop Down List",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,"select",null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q55:Q60)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z55:Z60)","v":0}]
[null,null,null,null,7,"SUPPLIES AND MATERIALS:",null,null,null,null,null,null,null,null,null,null,"Amount",null,null,"Select from Drop Down List",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q64:Q67)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z64:Z67)","v":0}]
[null,null,null,null,8,"TRAVEL:  (mileage, conference registration, courses, hotels, etc.)",null,null,null,null,null,null,null,null,null,null,"Amount",null,null,"Select from Drop Down List",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q71:Q74)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z71:Z74)","v":0}]
[null,null,null,null,9,"OTHER COSTS:",null,null,null,null,null,null,null,null,null,null,"Amount",null,null,"Select from Drop Down List",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q78:Q83)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z78:Z83)","v":0}]
[null,null,null,null,null,null,null,null,"(a) rate (%)",null,"(b) eligible allocation less indirect"]
[null,null,null,null,10,"INDIRECT COSTS ",null,null,null,null,{"$f":"IF(I87=\"\",\"\", (H7-IndExclImm)/(1+I87))","v":""}]
[null,null,null,null,null,null,null,null," (a x b)",null,{"$f":"IFERROR(+K87*I87,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"   maximum allowed"]
[]
[null,null,null,null,11,"EQUIPMENT:\nItems costing $5,000+ per unit and having a useful life more than 1 year should also be listed",null,null,null,null,null,null,null,null,null,null,"Amount",null,null,"Select from Drop Down List",null,"Budget Detail",null,null,null,"Amount"]
[null,null,null,null,null,"individually in Step 15.2, below (these expenditures are not eligible for recovery of indirect costs).",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[]
[null,null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q92:Q93)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z92:Z93)","v":0}]
[]
[]
[null,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,{"$f":"Q95+Q87+Q85+Q76+Q69+Q62+Q53+Q45+Q38+Q32+Q23","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z95+Z85+Z76+Z69+Z62+Z53+Z45+Z38+Z32+Z23)","v":0}]
[]
[null,null,null,null,"                                    DISCREPANCY:  Difference between allocation and budgeted total, if any",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Q100<>valAllocation,Q100-valAllocation,\"\"), 0)","v":0},null,null,null,null,"DISCREPANCY:  Difference between reservation and \n                            budgeted total, if any",null,null,null,{"$f":"IF(Z100<>H8,Z100-H8,\"\")","v":0}]
[]
[]
[]
[]
[null,"Step 5.2\nDistricts taking Indirect Costs",null,"Indirect Costs:  Major contracts and equipment"]
[null,null,null,"\nIndirect costs are those expenses of doing business that are not readily identifed with a particular grant, contract, project fund or activity, but are necessary for the general operation of the organization and the conduct of the activities it performs.  Because these expenses are difficult to track with precision across all benefiting sources, federal grants allow use of a rate as a mechanism for fairly and conveniently apportioning indirect costs across all programs within the boundaries of sound administrative principles.  \nSee U.S. Department of Education, Indirect Cost Overview (https://www2.ed.gov/about/offices/list/ocfo/intro.html). \n\nFor this grant, indirect costs must be consistent with the rate established by DESE's Office of School Finance.  Note that districts are allowed to take less than the maximum allowable for indirect costs. The decision to recover indirect costs using these established rates is a local option.  If indirect costs are recovered, they shall be returned to the general fund of the city or town in  accordance with G.L. Chapter 44, Section 53.  In the case of regional schools, indirect costs shall be returned to the regional school general fund.  www.doe.mass.edu/Grants/essential.html\n\nIn calculating the indirect cost allowable for a particular grant, some expenditures are not included.  Two such exclusions include a portion of major subawards or subcontracts (those exceeding $25,000), and capital costs (equipment purchases of $5,000 or more).  \nSee, U. S. Department of Education, Cost Allocation Guide for State and Local Governments.  https://www2.ed.gov/about/offices/list/ocfo/fipao/guideigcwebsite.pdf\n\n                                        •  Contracts:  For major contracts exceeding $25,000, districts may recover indirect costs on only the first $25,000 of each contract.   The remainder of the contract amount is excluded from application of the indirect cost rate.  Note that for contracts \n                                            for professional services normally provided in-house, such as a speech pathologist or school nurse, this exclusion does not apply, even if the contract exceeds $25,000.  Of course, these expenses are also subject to all other grant requirements \n                                            (allowability, allocability, necessarily and reasonable, etc.) to be properly chargeable to the grant as well.\n\n                                        • Equipment:  All equipment costing $5,000 or more and having a useful life of more than 1 year is considered a capital expenditure and not eligible for recovery of indirect cost.  The total for equipment should match the total entered in Line 11, above.\n\nDirections:  List contracts exceeding $25,000 below (but not those for professional services normally provided in house) and the amount to be excluded will be calculated automatically.  The excluded amount will be added to the equipment total (Line 11) and subtracted from your district's allocation before calculating your district's maximum allowable indirect cost on Line 10."]
[]
[]
[null,null,null,null," "]
[null,null,null,null,null,"Contracts exceeding $25,000 (include in budget categories above in addition to listing individually here)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment:  (from Line 11, above)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"List Items costing $5,000+ per unit and having a useful life of more than 1 year.  "]
[null,null,null,null,null,"Amount of contract:",null,"Amount excluded from indirect cost:",null,null,"  Description:",null,null,null,null,null,null,null,null,"  Description:",null,null,"Amount of Expenditure:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9889]
[null,null,null,null,null,35000,null,{"$f":"IF((F116-25000)>0, (F116-25000), \"\")","v":10000}]
[null,null,null,null,null,null,null,{"$f":"IF((F117-25000)>0, (F117-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,""]
[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":"IndK186+ExclEquip186","v":19889}]
[null,null,null,null,"SUB-TOTAL",{"$f":"SUM(F116:G128)","v":35000},null,{"$f":"SUM(H116:I128)","v":10000},null,null,null,null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL",{"$f":"SUM(W115:W128)","v":9889}]

{"sheet":"dataLookupValues","index":6,"n_rows":94,"n_cols":6,"rows_kept":94,"cut":false,"hidden":true,"merged":[[69,0,69,1],[77,0,77,1],[15,0,15,1],[20,0,20,1],[34,0,34,1],[41,0,41,1],[48,0,48,1],[59,0,59,1]]}
["Workbook Information"]
["Fiscal Year","FY18","Fundcode:",186]
["Title full name","III Language Acquisition"]
["Title abbreviated","III"]
["District Information",null,null,null,"Immigrant Count",{"$f":"VLOOKUP(valDistr,dataDistrictList!A2:R43,18,FALSE)","v":{"$error":"#N/A"}}]
["District value",1,null,null,"Liasons"]
["District Name:",{"$f":"VLOOKUP(valDistr,dataDistr,3,FALSE)","v":"Org Name"},"district code",{"$f":"LEFT(VLOOKUP(valDistr,dataDistr,2,FALSE),4)","v":"Org "},"Name",{"$f":"VLOOKUP(valDistr,dataDistr,12,FALSE)","v":"Liaison's Name"}]
["Address1",{"$f":"VLOOKUP(valDistr,dataDistr,7,FALSE)","v":"Address 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":"Address 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":"Town, State Zip"},null,null,"Allocation",{"$f":"VLOOKUP(valDistr,dataDistr,17,FALSE)","v":"FC 186 Allocation"}]
[]
["Common Values"]
["Budget Workbook"]
["LINE VALUES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Customized values"]
["PRIMARY FUNCTIONS"]

{"sheet":"dataDistrictList","index":7,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[1,"Org Code","Org Name","Org Type","Function","Contact Name","Address 1","Address 2","Town","State","Zip","Liaison's Name","Liaison's Number","Liaison's Email","March 19 EL Count ","March 19 Enrolled Count","FC 186 Allocation","Oct19 Immigrant Count"]
[2,"0035","Boston","Public School District","Superintendent","Laura Perille","2300 Washington Street","","Roxbury","MA","02119","Julia Foodman","781-338-3577","jfoodman@doe.mass.edu",15262,153506,153506,4641]
[3,"0044","Brockton","Public School District","Superintendent","Kathleen Smith","43 Crescent Street","","Brockton","MA","02301","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu",4240,16138,45799,1449]
[4,"0049","Cambridge","Public School District","Superintendent","Kenneth Salim","159 Thorndike Street","","Cambridge","MA","02141","Alex Lilley","781-338-6212","alilley@doe.mass.edu",548,6592,15295,542]
[5,"0057","Chelsea","Public School District","Superintendent","Mary Bourque","500 Broadway Street","c/o City Hall Room 216","Chelsea","MA","02150","Julia Foodman","781-338-3577","jfoodman@doe.mass.edu",2191,5932,49264,1050]
[6,"0093","Everett","Public School District","Superintendent","Janice Gauthier","121 Vine Street","","Everett","MA","02149","Ellie Rounds-Bloom","781-338-3128","erounds-bloom@doe.mass.edu",1669,6664,41228,969]
[7,"0095","Fall River","Public School District","Superintendent","Matthew Malone","417 Rock Street","","Fall River","MA","02720","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu",1714,9999,53537,536]
[8,"0100","Framingham","Public School District","Superintendent","Robert Tremblay","73 Mt. Wayte Avenue","Suite 5","Framingham","MA","01702","Colleen Holforty","781-338-3522","colleen.holforty@doe.mass.edu",2001,8690,178946,1084]
[9,"0149","Lawrence","Public School District","Superintendent","Cynthia Paris","237 Essex Street","","Lawrence","MA","01840","Russ Fleming","781-338-6259","RFleming@doe.mass.edu",4764,13313,57219,2270]
[10,"0160","Lowell","Public School District","Superintendent","Jeannine Durkin","155 Merrimack Street","","Lowell","MA","01852","Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu",3518,14093,23809,1034]
[11,"0163","Lynn","Public School District","Superintendent","Patrick Tutwiler","100 Bennett St","","Lynn","MA","01905","Colleen Holforty","781-338-3522","colleen.holforty@doe.mass.edu",4063,15741,125356,1923]
[12,"0170","Marlborough","Public School District","Superintendent","Michael Bergeron","17 Washington Street","","Marlborough","MA","01752","Ellie Rounds-Bloom","781-338-3128","erounds-bloom@doe.mass.edu",1087,4551,101928,624]
[13,"0185","Milford","Public School District","Superintendent","Kevin Mcintyre","31 West Fountain Street","","Milford","MA","01757","Julia Foodman","781-338-3577","jfoodman@doe.mass.edu",746,4215,91098,482]
[14,"0201","New Bedford","Public School District","Superintendent","Thomas Anderson","455 County Street","C/O Paul Rodrigues Administration Bldg.","New Bedford","MA","02740","Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu",3604,12470,46148,912]
[15,"0243","Quincy","Public School District","Superintendent","Richard Decristofaro","34 Coddington Street","","Quincy","MA","02169","Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu",1546,9251,45049,872]
[16,"0248","Revere","Public School District","Superintendent","Dianne Kelly","101 School Street","","Revere","MA","02151","Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu",1677,7435,22059,696]
[17,"0274","Somerville","Public School District","Superintendent","Mary Skipper","8 Bonair Street","","Somerville","MA","02145","Colleen Holforty","781-338-3522","colleen.holforty@doe.mass.edu",930,4647,27103,422]
[18,"0308","Waltham","Public School District","Superintendent","George Frost","617 Lexington Street","","Waltham","MA","02452","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu",1312,5553,55651,685]
[19,"0321","Westborough","Public School District","Superintendent","Amber Bock","45 West Main Street","","Westborough","MA","01581","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu",406,3840,13040,351]
[20,"0348","Worcester","Public School District","Superintendent","Maureen Binienda","20 Irving Street","","Worcester","MA","01609","Russ Fleming","781-338-6259","RFleming@doe.mass.edu",7774,24574,42290,1704]

{"sheet":"Dropdowns","index":8,"n_rows":135,"n_cols":12,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
["Budget Worksheet Dropdowns","Evidence/Data Sources","YesNo","Means of Identifying Els","Title IVA Categories","Title I School Types","Title I Low Income Methods","Private School Services Low Income Methods","Title IIA Prof. Growth ","Budget Pages:  Flexing","Private School Services:  Primary Functions","Private School DataList"]
["Primary Functions:  Title I","Select One","Select One","Select One","Access to Well-Rounded Education","SW","Select One","Select One","Select One","Flexed Funds II,Part A","Title I","Select One"]
["Select One","ACCESS data","Yes","Using initial assessment materials purchased by TIII identified by private school personnel","Safe and Healthy Schools","TA","March Eco Dis","Eco Dis","Recruiting diverse educators","Select, if applicable","Select One","Attendance data (educators)"]
["Instruction-School day (public, K-12) ","Attendance data (educators)","No","Using initial assessment materials purchased by TIII identified by LEA trained personnel","Effective Use of Technology","NT","March Eco Dis x 1.6","Free and Reduced Price Lunch/Meals Status","Building a principal pipeline","Title I, Part A","Instruction-School day (public, K-12) ","Attendance data (students)"]
["Instruction - Extended day/year (public, K-12) ","Attendance data (students)",null,"Identified by LEA by consultation agreement",null,"CL","Other ","Other","Strategically placing and/or screening  student teachers","Title III, Part A","Instruction - Extended day/year (public, K-12) ","College application, enrollment, and  completion data"]
["High quality PD","CHART reports ","YesNoNA","Previously identified for services",null,null,1,null,"Training supervising practitioners","Title IV, Part A","High quality PD","Discipline data"]
["Data collection/management","College application, enrollment, and  completion data","Select One","Previously identified student not yet proficient in English ",null,null,null,null,"Other",null,"Instructional technology","School-based assessments"]
["Homeless services","DART reports","Yes","Other",null,null,"Methods of qualifying T1 Schools",null,"None of the above","Flexed Funds IV,Part A","Parent, family and community engagement","School-sponsored research"]
["Instructional technology","Discipline data","No",null,null,null,"Select One",null,null,"Select, if applicable","Social and emotional learning","Educator evaluation data"]
["Neglected or delinquent services","District assessments","N/A",null,null,null,"District-wide low income percentage",null,"Select One","Title I, Part A","Other","Learning walks/teacher observations"]
["Parent, family and community engagement","District-sponsored research",null,null,null,null,"Grade span grouping and district-wide percentage",null,"Training mentors","Title II, Part A",null,"Peer-reviewed research"]
["Planning and evaluation","Educator evaluation data","RATE",null,null,null,"35% rule",null,"New administrator support","Title III, Part A","Title IIA","Student report cards"]
["Pre-school activities","Early Warning Indicator System (EWIS) data","select",null,null,null,"Grade span grouping and 35% rule",null,"Supports for educators in Years 2 and 3",null,"Select One","Surveys (student)"]
["Program administration","Learning walks/teacher observations","per hour",null,null,null,"Grade span grouping and group-wide percentage",null,"Cycles of observation and feedback",null,"Educator effectiveness PD","Survey (educator)"]
["Social and emotional learning","MCAS data","per day",null,null,null,"One school per grade span (eg. K-5, 6-8, 9-12)",null,"Cohort-based programming",null,"Social and emotional learning PD","Surveys (other)"]
["Student transportation","Peer-reviewed research","flat",null,null,null,"Total Enrollment of less than 1000 students",null,"Retaining educators of color",null,"School climate PD","Workforce outcomes data"]
["Other","RADAR reports ",null,null,null,null,1,null,"Other",null,"Inclusive practice PD","Other"]
[null,"Student report cards",null,null,null,null,null,null,"None of the above",null,"Other PD","None"]
["Primary Functions:  Title IIA","School accountability data"]
["Select One","Student Learning Experience reports",null,null,null,null,null,null,"Select One",null,"Title III Dropdown Private Schools"]
["Induction and mentoring ","Survey  - School Climate (student)",null,null,null,null,null,null,"Implementing the new student learning indicator",null,"Select One"]
["Instructional coaches","Survey - School Climate (educator)",null,null,null,null,null,null,"Incorporating staff/student feedback",null,"Instruction Extended day/year"]
["Curriculum Frameworks implementation ","Surveys - Other",null,null,null,null,null,null,"Calibrating the judgments and ratings of evaluators",null,"Supplemental literacy materials"]
["Educator effectiveness PD","Workforce outcomes data",null,null,null,null,null,null,"Other",null,"Assessment/screening materials"]
["Social and emotional learning PD","Other",null,null,null,null,null,null,"None of the above",null,"Professional development"]
["School climate PD","None",null,null,null,null,null,null,null,null,"Parent/Family Engagement for currently served TIII ELs"]
["Inclusive practice PD",null,null,null,null,null,null,null,"Select One",null,"Software for supplemental services during TIII extended day program"]
["Class size reduction",null,null,null,null,null,null,null,"Coaching supports to educators"]
["Program administration","Evidence/Data Sources TIVA",null,null,null,null,null,null,"Teacher Led PD",null,"Title VIA Dropdown Private Schools"]
["Other","Select One",null,null,null,null,null,null,"Curriculum-specific PD",null,"Select One"]
[null,"ACCESS data",null,null,null,null,null,null,"PD on data/ assessment",null,"Academic supports and personalized learning"]
["Primary Functions: Title III","Attendance data (educators)",null,null,null,null,null,null,"Other",null,"Arts education activities"]
["Select One","Attendance data (students)",null,null,null,null,null,null,"None of the above",null,"College and career readiness activities"]
["Instruction Extended day/year","CHART reports ",null,null,null,null,null,null,null,null,"Curriculum revision, training and implementation"]
["Supplemental literacy materials","College application, enrollment, and  completion data",null,null,null,null,null,null,"Select One",null,"Inclusion-related activities"]
["Assessment/screening materials","DART reports ",null,null,null,null,null,null,"Providing differentiated roles and opportunities",null,"School safety and student wellness activities"]
["Professional development","Discipline data",null,null,null,null,null,null,"Facilitating recognition programs and/or events",null,"Service learning, civics and community engagement activities"]
["Parent/Family Engagement for currently served TIII ELs","District assessments",null,null,null,null,null,null,"Other",null,"Social emotional learning activities"]
["Software for supplemental services during TIII extended day program","District-sponsored research",null,null,null,null,null,null,"None of the above",null,"Strengthening school climate and culture"]
["Other","Educator evaluation data",null,null,null,null,null,null,null,null,"Technology integration activities"]
[null,"Learning walks/teacher observations",null,null,null,null,null,null,null,null,"Other"]
["Primary Functions:  Title IV","MCAS data"]
["Select One","Peer-reviewed research"]
["Academic supports and personalized learning","RADAR reports "]
["Arts education activities","Referrals"]
["College and career readiness activities","Student Learning Experience reports"]
["Curriculum revision, training and implementation","Student report cards"]
["Inclusion-related activities","Survey  - School Climate (student)"]
["School safety and student wellness activities","Survey - School Climate (educator)"]
["Service learning, civics and community engagement activities","Survey -- Youth Risk"]
["Social emotional learning activities","Surveys -- Other"]
["Strengthening school climate and culture","Workforce outcomes data"]
["Technology integration activities","Other"]
["Other","None"]
[]
["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  "]
[]
["Select One"]
["Parent and family outreach and engagement"]
["Recruitment and support for specialized personnel "]
["Instructional Technology"]
["Additional instructional services - Private"]
["Additional instructional services - Public"]
["Orientation/transitional services and instruction "]
["Coordinated services with community-based partners"]
["Other"]