{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["READ ME FIRST","1. Signature Page","2. Contact Information","3A. Expenditures Lines 1-6","3B. Expenditures Lines 7-11","4. Budget ","Schedule A","drop down","LiaisonList","DataDistrictList","DataLookupValues"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":21,"comments":1,"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 FIRST","index":0,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[24,1,24,12],[1,1,1,12],[16,1,23,12],[15,1,15,12],[2,1,2,12],[3,1,3,12],[4,1,12,12],[13,1,13,12],[14,1,14,12],[29,1,29,12],[28,1,28,12],[27,1,27,12],[26,1,26,12],[25,1,25,12]]}
[]
[null,"Massachusetts Department of Elementary & Secondary Education"]
[null,"FY20 Carl D. Perkins Career and Technical Education Secondary Application Workbook"]
[null,"Overview  "]
[null,"\nThis application allows LEAs (districts and other eligible entities, referred to in this application collectively as \"districts\") to apply for funding for the Perkins Secondary Allocation Grant.                                \n\n If you have questions, please refer to our Federal Grant Programs website 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. Rename the file by replacing the words 'leacode' in the file name with your 4-digit district code, but keep the rest of the filename and the file extension (.xlsm) the same. For example, Abington (0001) would rename the file as 'FY20Perkins-0001.xlsm'. Users of Apple Macintosh computers must save as a macro-enabled file (with an .xlsm extension) for the workbook to function properly."]
[null,"Tips for Completing the Application"]
[null,"  \n Workflow and printing:  \n    • Each tab must be completed, unless otherwise stated.\n\n   •  The Budget worksheet, which mirrors the budget entry page in EdGrants, must be completed. The budget worksheet in this Excel document, in addition to entering budget informaton in EdGrants, are both mandatory.\n\n•  This workbook is structured to be completed in electronic format, zoomed to a scale of 100%. You may also print a copy using Excel's print preview functions to set the appearance and paper orientation to best fit your completed application.  \n   \n  Color-coding and cell features:\n   •  Cells that appear in light yellow require districts to input information. Text may be pasted into these cells as long as the text does not contain Excel formulas.  \n\n   •   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 other pages or sources into orange cells!\n\n   •  Throughout the tabs of this application you will find instruction boxes (gray), tip boxes (pink) to help you avoid common mistakes. You will also find resource boxes (tan) that include links to materials outside the application with more detailed, grant-related information.\n\n"]
[]
[]
[]
[]
[]
[]
[]
[null,"   •  If boxes/cells containing text in some parts of the application appear to be cut off, please enlarge the \"view\" of that page using your \n      Zoom feature (usually a slide bar appearing in the lower corner of your Excel screen), which should solve the problem.  100% is best \n      in most cases.\n\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 the district's EdGrants submissions.   We cannot approve\n      any grant without an uploaded, signed, and properly dated signature page!\n\n   •  NEW! Federal Grant Assurances Signature Page : Each district must review the FY20 Federal Grant Assurances and submit a signed, \n      scanned (pdf) signature page indicating such review and assurance of compliance with  Once the application has been completed,\n      print, sign, date (using date of submission), scan and upload as an attachment to to its Title I Edgrants submission (Fund Code 305).  \n      If your district does not receive a Title I grant, contact your district's DESE grant liaison for submission instructions.  We cannot \n      approve  any federal entitlement grant without an uploaded, signed, and properly dated signature page!\n\n   •  All tabs related to programs for which a district has received an allocation must be complete and budget submitted in \n      EdGrants for each of those fund codes in order for an application to be substantially approvable and ready for review.  No partial \n      submissions will be accepted.\n"]
[null,"Submit the FY20 Workbook as an Excel workbook via EdGrants Front Office web page"]
[null,"\nEdGrants Submission Information:\nMost districts/applicants already have designated control users in EdGrants: Front Office, who may access and submit grant applications, as well as make payment requests. Each district/applicant must ensure that it has an authorized control user prior to grant submission. If a district waits until its completed grant is ready to submit before inquiring about a new user name/login, the grant submission may be delayed several business days to allow 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, with any questions regarding 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 district business offices have been contacted with information regarding training. If you are unsure who in your office is a control user, please contact your business office. The Perkins Application Workbook must be uploaded with your Perkins budget in EdGrants. "]
[null,"Applications are due by September 27, 2019. "]
[null,"NOTE ON SUBMISSION TIMELINE: \n    • Due to higher volume of applications coming in to DESE close to the 2019 deadline, districts that submit near the due date should expect to wait a few weeks to hear back from your DESE liaison. Districts that submit early may see a shorter turnaround.   \n    • The start date for the grant is the date on which the district submits an application that contains substantially approvable programmatic and budget information.  \n    •  Districts that fail to file by September 27, 2019 will receive last priority for review.    \n    •  Expenses incurred prior to approval of a district's application and start date(s) are not payable with grant funds!\n    •  Responding quickly to your liaison's 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":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,1,27,3],[25,4,25,8],[25,9,25,15],[25,16,25,19],[26,4,27,8],[26,9,26,12],[26,13,26,15],[26,16,27,19],[27,9,27,12],[27,13,27,15],[20,1,20,4],[20,5,20,10],[20,12,20,13],[20,14,20,18],[21,1,21,4],[21,5,21,10],[21,12,21,13],[21,14,21,18],[17,1,18,19],[1,1,2,19],[4,1,4,19],[5,1,5,19],[10,5,10,11],[11,5,11,11]]}
[]
[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 "]
[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 September 27, 2019"]
[]
[]
[null,null,null,"District Name:",null,null,null,null,null,null,null,null,"Org Code:",null,{"$f":"valorg4code","v":"Org "}]
[]
[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,{"$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,"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."]
[]
[]
[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,"FY2020\nAllocation",null,null,"FEDERAL GRANT",null,null,null,null,"PROJECT DURATION",null,null,null,null,null,null,"TOTAL ALLOCATION"]
[null,null,null,null,"Carl D. Perkins Career & Technical Education, FC 400",null,null,null,null,"FROM",null,null,null,"TO"]
[null,null,null,null,null,null,null,null,null,"UPON APPROVAL",null,null,null,"8/31/2020"]

{"sheet":"2. Contact Information","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,2,7,11],[8,2,8,11],[9,1,9,3],[9,4,9,11],[1,1,1,3],[3,1,3,11],[4,1,4,11],[5,1,5,3],[5,4,5,11],[6,1,6,2],[6,3,6,11],[15,2,15,11],[16,2,16,11],[17,1,17,3],[17,4,17,11],[12,1,12,11],[13,1,13,3],[13,4,13,11],[14,1,14,2],[14,3,14,11]]}
[]
[null,{"$f":"DataLookupValues!B7","v":"Org Name"}]
[]
[null,"District Contact Information by Program\nPlease provide information for primary district contact for each program"]
[null,"Perkins Secondary Allocation Grant (Fund Code 400)"]
[null,"Name of Primary Contact:"]
[null,"Title:"]
[null,"Phone:"]
[null,"Email:"]
[null,"New to this program?  (Y/N)",null,null,"Select One"]
[]
[]
[null,"Business Office Contact (for fiscal information, if different from above)"]
[null,"Name of Primary Contact:"]
[null,"Title:"]
[null,"Phone:"]
[null,"Email:"]
[null,"New to these programs?  (Y/N)",null,null,"Select One"]

{"sheet":"3A. Expenditures Lines 1-6","index":3,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,6,44,9],[42,6,42,9],[43,6,43,9],[18,5,20,5],[21,5,24,5],[25,5,27,5],[28,5,31,5],[32,5,35,5],[40,6,40,9],[41,6,41,9],[1,2,1,5],[3,5,3,6],[37,4,39,4],[37,5,38,9],[39,6,39,9],[4,5,7,8]]}
[]
[null,null,{"$f":"valDistrName","v":"Org Name"}]
[]
[null,null,null,null,null,"Expenditures (Lines 1-6)"]
[null,null,null,null,null,"For each expenditure in each line, complete steps 3.1 though 3.6. \nAll information for the individual expenditure will be correlated across the table.\nLines 1-6 are on this tab; Line 7-11 are on the following tab. \nBoth tabs need to be completed and expenditures should match the items on the Budget tab."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Line Item","Step 3.1 \nPlease include a description of the position(s) or services that will be funded. Please describe in some detail how expenditures are SUPPLEMENTING, not SUPPLANTING local funds.","Step 3.2\nDoes this expenditure address the performance targets on core indicators?","Step 3.3\nIf this expenditure addresses the performance target on a core indictor, list the core indicator(s)  addressed.","Step 3.4\nIf this expenditure addresses performance targets on a core indicator, please list the special population(s) targeted."," Step 3.5\nFor each expenditure item, explain how the expenditure addresses one or more required use of funds. You must use a portion of the Perkins allocation for professional development.\nIf all required uses are not addressed, please complete Step 3.7 below.","Step 3.6\nPlease describe how this expenditure will improve your program."]
[null,null,null,null,null," Line 1: Administrator",null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Line 2: Instructional/Professional Staff",null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Line 3: Support Staff",null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,null,"Select one"]
[null,null,null,null,null,"Line 4: Stipends",null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,null,"Select one"]
[null,null,null,null,null,"Line 6: Contractual Services",null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,null,"Select one"]
[]
[null,null,null,null,"Step 3.7\nRequired Use of Funds \n(From Perkins V)","These are the six required activities that should support CTE programs of size, quality and scope. If you are not using Perkins allocation to fund the required program activities, explain below how you will fund the activites.\n\n If all required activities are referenced in Step 3.5, you can skip this step."]
[]
[null,null,null,null,null,"1R"]
[null,null,null,null,null,"2R","At least a portion of Perkins funds must be used for professional development even if the district has other sources of professional development funds."]
[null,null,null,null,null,"3R"]
[null,null,null,null,null,"4R"]
[null,null,null,null,null,"5R "]
[null,null,null,null,null,"6R"]

{"sheet":"3B. Expenditures Lines 7-11","index":4,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[42,1,44,1],[42,2,43,6],[44,3,44,6],[45,3,45,6],[3,3,3,4],[4,3,7,6],[20,3,24,3],[25,3,29,3],[30,3,33,3],[46,3,46,6],[47,3,47,6],[48,3,48,6],[49,3,49,6],[34,3,40,3]]}
[]
[null,{"$f":"valDistrName","v":"Org Name"}]
[]
[null,null,null,"Expenditures (Lines 7-11)"]
[null,null,null,"For each expenditure in each line, complete steps 3.1 though 3.6. \nAll information for the individual expenditure will be correlated across the table.\nLines 7-11 are on this tab; Line 1-6 are on the prior tab. \nBoth tabs need to be completed and expenditures should match the items on the Budget tab."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Line Item","Step 3.1 \nPlease include a description of the position(s) or services that will be funded. Please describe in some detail how expenditures are SUPPLEMENTING, not SUPPLANTING local funds.","Step 3.2\nDoes this expenditure address the performance targets on core indicators?","Step 3.3\nIf this expenditure addresses the performance target on a core indictor, list the core indicator(s)  addressed.","Step 3.4\nIf this expenditure addresses performance targets on a core indicator, please list the special population(s) targeted."," Step 3.5\nFor each expenditure item, explain how the expenditure addresses one or more required use of funds. You must use a portion of the Perkins allocation for professional development.\nIf all required uses are not addressed, please complete Step 3.7 below.","Step 3.6\nPlease describe how this expenditure will improve your program."]
[null,null,null,"Line 7: Supplies and Materials",null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,"Line 8: Travel",null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,"Line 9: Other costs",null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select one"]
[null,null,null,"Line 11: Equipment ",null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[]
[null,"Step 3.7\nRequired Use of Funds \n(From Perkins V)","These are the six required activities that  should support CTE programs of size, quality and scope. If you are not using Perkins allocation to fund the required program activities, explain below how you will fund the activites.\n\n If all required activities are referenced in Step 3.5, you can skip this step."]
[]
[null,null,"1R"]
[null,null,"2R","At least a portion of Perkins funds must be used for professional development even if the district has other sources of professional development funds."]
[null,null,"3R"]
[null,null,"4R"]
[null,null,"5R "]
[null,null,"6R"]

{"sheet":"4. Budget ","index":5,"n_rows":133,"n_cols":34,"rows_kept":133,"cut":false,"hidden":false,"merged":[[84,8,84,11],[13,1,16,1],[102,3,102,11],[89,19,89,20],[90,4,90,10],[90,19,90,20],[91,4,91,10],[91,19,91,20],[97,19,97,20],[82,3,82,11],[85,9,85,10],[86,9,86,10],[89,4,89,11],[78,19,78,20],[79,4,79,10],[79,19,79,20],[80,4,80,10],[80,19,80,20],[81,4,81,10],[81,19,81,20],[72,4,72,10],[72,19,72,20],[73,3,73,11],[75,19,75,20],[76,4,76,10],[76,19,76,20],[77,4,77,10],[77,19,77,20],[78,4,78,10],[61,19,61,20],[62,4,62,10],[62,19,62,20],[63,4,63,10],[63,19,63,20],[64,4,64,10],[64,19,64,20],[65,4,65,10],[65,19,65,20],[66,4,66,6],[68,4,68,10],[68,19,68,20],[69,4,69,10],[69,19,69,20],[70,4,70,10],[70,19,70,20],[71,4,71,10],[71,19,71,20],[56,19,56,20],[57,4,57,7],[57,19,57,20],[58,4,58,7],[58,19,58,20],[59,3,59,11],[50,3,50,11],[52,19,52,20],[53,4,53,7],[53,19,53,20],[54,4,54,7],[54,19,54,20],[55,4,55,7],[55,19,55,20],[56,4,56,7],[47,4,47,11],[47,19,47,20],[48,4,48,11],[48,19,48,20],[49,4,49,11],[49,19,49,20],[41,4,41,7],[41,19,41,20],[42,3,42,11],[43,3,43,7],[44,4,44,11],[44,19,45,20],[45,4,45,11],[46,4,46,11],[46,19,46,20],[35,3,35,11],[36,3,36,7],[37,19,37,20],[38,4,38,7],[38,19,38,20],[39,4,39,7],[39,19,39,20],[40,4,40,7],[40,19,40,20],[32,4,32,7],[32,19,32,20],[33,4,33,7],[33,19,33,20],[34,4,34,7],[34,19,34,20],[28,4,28,7],[28,19,28,20],[29,3,29,11],[29,19,29,20],[30,3,30,7],[31,4,31,7],[31,19,31,20],[26,19,26,20],[27,4,27,7],[27,19,27,20],[19,4,19,7],[19,19,19,20],[20,19,20,20],[21,3,21,7],[22,19,22,20],[23,4,23,7],[23,19,23,20],[24,4,24,7],[24,19,24,20],[120,10,120,20],[120,24,120,27],[121,5,121,6],[121,7,121,8],[121,10,121,20],[121,24,121,27],[2,2,2,10],[3,19,3,20],[4,2,4,20],[6,3,7,5],[6,6,7,7],[7,8,7,9],[7,10,7,11],[14,3,14,11],[14,19,14,20],[16,4,16,7],[16,19,16,20],[17,4,17,7],[17,19,17,20],[18,4,18,7],[18,19,18,20],[25,4,25,7],[25,19,25,20],[26,4,26,7],[122,5,122,6],[122,7,122,8],[122,10,122,20],[122,24,122,27],[123,5,123,6],[123,7,123,8],[123,10,123,20],[123,24,123,27],[124,5,124,6],[124,7,124,8],[124,10,124,20],[124,24,124,27],[125,5,125,6],[125,7,125,8],[125,10,125,20],[125,24,125,27],[126,5,126,6],[126,7,126,8],[126,10,126,20],[126,24,126,27],[127,5,127,6],[127,7,127,8],[127,10,127,20],[127,24,127,27],[128,5,128,6],[128,7,128,8],[128,10,128,20],[128,24,128,27],[129,5,129,6],[129,7,129,8],[129,10,129,20],[129,24,129,27],[130,5,130,6],[130,7,130,8],[130,10,130,20],[130,24,130,27],[131,5,131,6],[131,7,131,8],[131,10,131,20],[131,24,131,27],[132,5,132,6],[132,7,132,8],[132,11,133,21],[111,3,112,31],[110,1,111,1],[110,3,110,31],[113,3,113,10],[115,23,115,30],[116,23,116,30],[117,5,118,6],[117,7,118,8],[117,10,118,20],[117,24,118,27],[117,29,118,29],[119,5,119,6],[119,7,119,8],[119,10,119,20],[119,24,119,27],[120,5,120,6],[120,7,120,8],[95,19,95,20],[96,19,96,20],[94,19,94,20],[93,19,93,20],[92,19,92,20],[92,4,92,10],[93,4,93,10],[94,4,94,10],[95,4,95,10],[96,4,96,10]]}
[]
[]
[null,null,{"$f":"DataLookupValues!B7","v":"Org Name"}]
[]
[null,null,"FY20 Perkins Secondary Allocation Budget Worksheet"]
[]
[null,null,null,"Allocation \n",null,null,{"$f":"valAllocPerk","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Bellingham",null,null,null,null,null,null,"Bellingham (0025)"]
[null,null,null,null,null,null,null,null,null,"Bellingham"]
[]
[]
[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,"Expenditures \n(whole numbers)",null,"Primary Function",null,"Comments"]
[]
[null,null,null,1,"ADMINISTRATOR SALARIES:",null,null,null,null,"# of staff","FTE","MTRS",null,null,null,"Amount",null,"Select from Drop Down List",null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M18,P18,0)","v":0},null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M19,P19,0)","v":0},null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M20,P20,0)","v":0},null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,0,0,null,null,{"$f":"SUM(N18:N20)","v":0},null,{"$f":"SUM(P18:P20)","v":0}]
[null,null,null,2,"INSTRUCTIONAL/PROF STAFF:",null,null,null,null,"# of staff","FTE","MTRS",null,null,null,"Amount",null,"Select from Drop Down List",null,"Budget Detail"]
[null,null,null,null,"Classroom Teachers  ",null,null,null,null,null,null,null,false,{"$f":"IF(M24, P24,0)","v":0},null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M25, P25,0)","v":0},null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M29, P29,0)","v":0},null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,0,0,null,null,{"$f":"SUM(N24:N29)","v":0},null,{"$f":"SUM(P24:P29)","v":0}]
[null,null,null,3,"SUPPORT STAFF SALARIES:",null,null,null,null,"# of staff","FTE","MTRS",null,null,null,"Amount",null,"Select from Drop Down List",null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M33, P33, 0)","v":0},null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M34, P34, 0)","v":0},null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,0,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,0,0,null,null,{"$f":"SUM(N33:N35)","v":0},null,{"$f":"SUM(P33:P35)","v":0}]
[null,null,null,4,"STIPENDS:",null,null,null,"# of staff","Rate","Rate Type","MTRS",null,null,null,"Amount",null,"Select from Drop Down List",null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,false,{"$f":"IF(M39, P39, 0)","v":0},null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,false,{"$f":"IF(M40, P40, 0)","v":0},null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,false,0,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,false,0,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N39:N42)","v":0},null,{"$f":"SUM(P39:P42)","v":0}]
[null,null,null,5,"FRINGE BENEFITS:",null,null,null,null,null,null,null,null,null,null,"Amount",null,"Brief Description",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,{"$f":"ROUND((SUM(N44,N37,N31,N22))*0.09,0)","v":0}]
[null,null,null,null,"5b  Other",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P48:P50)","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,{"$f":"SUM(P46:P47)","v":0}]
[null,null,null,6,"CONTRACTUAL SERVICES:",null,null,null,null,"Rate","Rate Type",null,null,null,null,"Amount",null,"Select from Drop Down List",null,"Budget Detail"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,"Select One",null,null,null,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P54:P59)","v":0}]
[null,null,null,7,"SUPPLIES AND MATERIALS:",null,null,null,null,null,null,null,null,null,null,"Amount",null,"Select from Drop Down List",null,"Budget Detail"]
[null,null,null,null,"Select One",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,"Select One"]
[null,null,null,null,"Select One",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,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P63:P66)","v":0}]
[null,null,null,8,"TRAVEL:  (mileage, conference registration, courses, hotels, etc.)",null,null,null,null,null,null,null,null,null,null,"Amount",null,"Select from Drop Down List",null,"Budget Detail"]
[null,null,null,null,"Select One",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,"Select One"]
[null,null,null,null,"Select One",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,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P70:P73)","v":0}]
[null,null,null,9,"OTHER COSTS:",null,null,null,null,null,null,null,null,null,null,"Amount",null,"Select from Drop Down List",null,"Budget Detail"]
[null,null,null,null,"Select One",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,"Select One"]
[null,null,null,null,"Select One",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,"Select One"]
[null,null,null,null,"Select One",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,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P77:P82)","v":0}]
[null,null,null,null,null,null,null,"(a) rate (%)","(b) eligible allocation less indirect",null,null,null,null,null,null,"Amount"]
[null,null,null,10,"INDIRECT COSTS *",null,null,null,null,{"$f":"IF(H86=\"\",\"\", (G7-IndExcl400)/(1+H86))","v":""}]
[null,null,null,null,"   maximum allowed",null,null," (a x b)",null,{"$f":"IFERROR(ROUND(J86*H86, 0), \"\")","v":""}]
[]
[]
[null,null,null,11,"EQUIPMENT:\nOnly list items costing $5,000+ per unit and having a useful life more than 1 year",null,null,null,null,null,null,null,null,null,null,"Amount",null,"Select from Drop Down List",null,"Budget Detail"]
[null,null,null,null,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,"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,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,"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,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,{"$f":"SUM(P91:P97)","v":0}]
[]
[null,null,null,"TOTAL FUNDS REQUESTED ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P99+P86+P84+P75+P68+P61+P52+P44+P37+P31+P22)","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,{"$f":"IFERROR(IF(P101<>valAllocPerk,P101-valAllocPerk,\"\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 4.2\nDistricts requesting funds for indirect costs",null,"Indirect Costs:  Major contracts and equipment",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":"IndK400+IndEquip400","v":0}]
[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,null,null,null,null,"  Equipment:  (from Line 11, above)\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,"    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,null,null,null,null,null,"  Description:",null,null,null,null,"Amount:"]
[]
[null,null,null,null,null,null,null,{"$f":"IF((F120-25000)>0, (F120-25000), \"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF((F121-25000)>0, (F121-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,"SUB-TOTAL",{"$f":"SUM(F120:G132)","v":0},null,{"$f":"SUM(H120:I132)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(AD120:AD132)","v":0}]

{"sheet":"Schedule A","index":6,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[80,6,81,8],[80,9,81,11],[81,1,81,5],[83,1,84,11],[78,1,78,5],[78,6,78,8],[78,9,78,11],[79,1,79,5],[79,6,79,8],[79,9,79,11],[76,1,76,5],[76,6,76,8],[76,9,76,11],[77,1,77,5],[77,6,77,8],[77,9,77,11],[74,1,74,5],[74,6,74,8],[74,9,74,11],[75,1,75,5],[75,6,75,8],[75,9,75,11],[72,1,72,5],[72,6,72,8],[72,9,72,11],[73,1,73,5],[73,6,73,8],[73,9,73,11],[70,1,70,5],[70,6,70,8],[70,9,70,11],[71,1,71,5],[71,6,71,8],[71,9,71,11],[68,1,68,5],[68,6,68,8],[68,9,68,11],[69,1,69,5],[69,6,69,8],[69,9,69,11],[66,1,66,5],[66,6,66,8],[66,9,66,11],[67,1,67,5],[67,6,67,8],[67,9,67,11],[64,1,64,5],[64,6,64,8],[64,9,64,11],[65,1,65,5],[65,6,65,8],[65,9,65,11],[61,1,62,5],[61,6,62,8],[61,9,62,11],[63,1,63,5],[63,6,63,8],[63,9,63,11],[56,1,57,1],[56,2,57,4],[56,5,57,10],[56,11,57,11],[58,1,59,1],[58,2,59,4],[58,5,59,10],[58,11,59,11],[43,1,44,11],[49,1,49,11],[50,1,50,11],[52,1,52,11],[54,1,55,1],[54,2,55,11],[39,1,39,5],[39,6,39,8],[39,9,39,11],[40,6,41,8],[40,9,41,11],[41,1,41,5],[37,1,37,5],[37,6,37,8],[37,9,37,11],[38,1,38,5],[38,6,38,8],[38,9,38,11],[35,1,35,5],[35,6,35,8],[35,9,35,11],[36,1,36,5],[36,6,36,8],[36,9,36,11],[33,1,33,5],[33,6,33,8],[33,9,33,11],[34,1,34,5],[34,6,34,8],[34,9,34,11],[31,1,31,5],[31,6,31,8],[31,9,31,11],[32,1,32,5],[32,6,32,8],[32,9,32,11],[29,1,29,5],[29,6,29,8],[29,9,29,11],[30,1,30,5],[30,6,30,8],[30,9,30,11],[27,1,27,5],[27,6,27,8],[27,9,27,11],[28,1,28,5],[28,6,28,8],[28,9,28,11],[25,1,25,5],[25,6,25,8],[25,9,25,11],[26,1,26,5],[26,6,26,8],[26,9,26,11],[23,1,23,5],[23,6,23,8],[23,9,23,11],[24,1,24,5],[24,6,24,8],[24,9,24,11],[18,1,19,1],[18,2,19,4],[18,5,19,10],[18,11,19,11],[21,1,22,5],[21,6,22,8],[21,9,22,11],[2,2,2,10],[3,2,6,10],[9,1,9,11],[10,1,10,11],[12,1,12,11],[14,1,15,1],[14,2,15,11],[16,1,17,1],[16,2,17,4],[16,5,17,10],[16,11,17,11]]}
[]
[]
[null,null,"Instructions:\n\n "]
[null,null,"Fill out and print a Schedule A if  Perkins Fund Code 400 funds \nare assigned to your district from other grant recipients, and your district (agency) is operator/administrator.              \n"]
[]
[]
[]
[]
[]
[null,"MASSACHUSETTS DEPARTMENT OF ELEMENTARY AND SECONDARY EDUCATION"]
[null,"STANDARD APPLICATION FOR PROGRAM GRANTS"]
[]
[null,"FY20 SCHEDULE A - Assignment Schedule"]
[]
[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."]
[]
[null,2,"Agency operating and administering the project:  ",null,null,{"$f":"valDistrName","v":"Org Name"},null,null,null,null,null,{"$f":"valorg4code","v":"Org "}]
[]
[null,3,"Name of grant program/\nFund Code:"]
[]
[]
[null,"Name of Participating Agency",null,null,null,null,"Amount of \nAssigned Funds",null,null,"* Authorized Signature"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G24:I39)","v":0}]
[null,"Total of Assigned Funds"]
[]
[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":"drop down","index":7,"n_rows":70,"n_cols":7,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["per day",null,null,"Select One",null,"Budget Categories","Primary Functions "]
["per hour",null,null,"yes ",null,"Administrator Salaries","Select One"]
["flat",null,null,"no",null,"Select One","1R"]
[null,null,null,null,null,"Grant Program Manager/Coordinator ","2R"]
[null,null,null,null,null,"Other ","3R"]
[null,null,null,null,null,"InstructionalProf Staff Salaries","4R"]
[null,null,null,null,null,"Select One","5R"]
[null,null,null,null,null,"Classroom Teachers  ","6R"]
[null,null,null,null,null,"Instructional Coaches "]
[null,null,null,null,null,"Certified Specialist Teachers (providing individualized instruction)  "]
[null,null,null,null,null,"Instructional Coordinators and Team Leaders  "]
[null,null,null,null,null,"Medical / Therapeutic Services "]
[null,null,null,null,null,"Librarians and Media Center Directors "]
[null,null,null,null,null,"Professional Development Directors/Coordinators  "]
[null,null,null,null,null,"Guidance or School Adjustment Counselors, Social Workers  "]
[null,null,null,null,null,"Psychological Service Providers "]
[null,null,null,null,null,"School Physicians and School Nurses  "]
[null,null,null,null,null,"Other  "]
[null,null,null,null,null,"Support Staff Salaries"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Non-Clerical Paraprofessionals/Instructional Assistants "]
[null,null,null,null,null,"Secretary/Bookkeeper/Clerical Support  "]
[null,null,null,null,null,"Parent Liaisons"]
[null,null,null,null,null," Other "]
[null,null,null,null,null,"Stipends"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Teacher/ Instructional Staff Professional Days"]
[null,null,null,null,null,"Administrators "]
[null,null,null,null,null,"Other "]
[null,null,null,null,null,"Support Staff"]
[null,null,null,null,null,"Travel"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Grant Program Manager/Coordinator (supervisory)"]
[null,null,null,null,null,"Certified Classroom Teachers (providing group instruction) "]
[null,null,null,null,null,"Certified Specialist Teachers (providing individualized instruction)"]
[null,null,null,null,null,"Non-Clerical Paraprofessionals/Instructional Assistants"]
[null,null,null,null,null,"Other "]
[null,null,null,null,null,"Contractual Services"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Instructional Services "]
[null,null,null,null,null,"Consultants/Professional  Development for Teachers & Support Staff "]
[null,null,null,null,null,"Substitutes (long and/or short term)"]
[null,null,null,null,null,"Non-Clerical Paraprofessionals/Instructional Assistants"]
[null,null,null,null,null,"Secretary/Bookkeeper/Clerical Support "]
[null,null,null,null,null,"Contracted Service Providers -- Private School Services "]
[null,null,null,null,null,"Contracted Services Providers -- Other Student Services "]
[null,null,null,null,null,"Other "]
[null,null,null,null,null,"Supplies and Materials"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Textbooks and Related Software/Media/Materials "]
[null,null,null,null,null,"Instructional Technology"]
[null,null,null,null,null,"Other Instructional Materials (non-testing/assessment)"]
[null,null,null,null,null,"Testing and Assessment Materials"]
[null,null,null,null,null,"General Classroom Supplies "]
[null,null,null,null,null,"Office Supplies  "]
[null,null,null,null,null,"Other "]
[null,null,null,null,null,"Other costs"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Memberships/Subscriptions"]
[null,null,null,null,null,"Advertising  "]
[null,null,null,null,null,"Student Transportation Services "]
[null,null,null,null,null," Rental/Lease of Equipment"]
[null,null,null,null,null,"Maintenance of Equipment"]
[null,null,null,null,null,"Maintenance of Technology "]
[null,null,null,null,null,"Tuition to Non-Public Schools "]
[null,null,null,null,null,"Tuition to Out-of-State Schools "]
[null,null,null,null,null,"Tuition to Collaboratives"]
[null,null,null,null,null,"Rental Lease of Buildings  "]
[null,null,null,null,null,"Utility Services/ Telephone "]
[null,null,null,null,null,"Other  "]

{"sheet":"LiaisonList","index":8,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Aneesh Sahni","781-338-3532","aneesh.sahni@doe.mass.edu","Aneesh Sahni"]
["Alex Lilley","781-338-6212","alilley@doe.mass.edu","Alex Lilley"]
["Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu","Beth O'Connell"]
["Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu","Nancy Labrie"]
["Ellie Rounds-Bloom","781-338-3128","erounds-bloom@doe.mass.edu","Ellie Rounds-Bloom"]
["Julia Foodman","781-338-3577","jfoodman@doe.mass.edu","Julia Foodman"]
["Russ Fleming","781-338-6529","RFleming@doe.mass.edu","Russ Fleming"]
["Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu","Sue Mazzarella"]

{"sheet":"DataDistrictList","index":9,"n_rows":84,"n_cols":19,"rows_kept":84,"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 EL Count (18c)","March Enrolled Count"]
[2,"08010000","Assabet Valley Regional Vocational Technical","Public School District","Superintendent","Ernest Houle","215 Fitchburg Street",null,"Marlborough","MA","01752",{"$f":"VLOOKUP(N2, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Ellie Rounds-Bloom"},"781-338-3128","erounds-bloom@doe.mass.edu",28,1103,{"$f":"IF(L2=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q2=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[3,"00160000","Attleboro","Public School District","Superintendent","David Sawyer","100 Rathbun Willard Drive",null,"Attleboro","MA","02703",{"$f":"VLOOKUP(N3, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Ellie Rounds-Bloom"},"781-338-3128","erounds-bloom@doe.mass.edu",381,5791,{"$f":"IF(L3=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q3=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[4,"00200000","Barnstable","Public School District","Superintendent","Meg Mayo-Brown","P O Box 955",null,"Hyannis","MA","02601",{"$f":"VLOOKUP(N4, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",471,4728,{"$f":"IF(L4=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q4=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[5,"00300000","Beverly","Public School District","Superintendent","Steven Hiersche","70 Balch St.",null,"Beverly","MA","01915",{"$f":"VLOOKUP(N5, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Nancy Labrie"},{"$f":"IF(N5=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":"781-338-3536"},"nlabrie@doe.mass.edu",171,4385]
[6,"08050000","Blackstone Valley Regional Vocational Technical","Public School District","Superintendent","Michael Fitzpatrick","65 Pleasant Street",null,"Upton","MA","01568",{"$f":"VLOOKUP(N6, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",3,1220,{"$f":"IF(L6=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q6=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[7,"08060000","Blue Hills Regional Vocational Technical","Public School District","Superintendent","James Quaglia","800 Randolph Street",null,"Canton","MA","02021",{"$f":"VLOOKUP(N7, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Nancy Labrie"},{"$f":"IF(N7=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":"781-338-3536"},"nlabrie@doe.mass.edu",4,842]
[8,"00350000","Boston","Public School District","Superintendent","Tommy Chang","2300 Washington Street",null,"Roxbury","MA","02119",{"$f":"VLOOKUP(N8, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",15445,49775,{"$f":"IF(L8=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q8=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[9,"09100000","Bristol County Agricultural","Public School District","Superintendent","Adele Sands","135 Center Street",null,"Dighton","MA","02715",{"$f":"VLOOKUP(N9, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Nancy Labrie"},{"$f":"IF(N9=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":"781-338-3536"},"nlabrie@doe.mass.edu",0,457]
[10,"08100000","Bristol-Plymouth Regional Vocational Technical","Public School District","Superintendent","Alexandre Magalhaes","207 Hart Street",null,"Taunton","MA","02780",{"$f":"VLOOKUP(N10, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Russ Fleming"},"781-338-6529","RFleming@doe.mass.edu",3,1247,{"$f":"IF(L10=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q10=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[11,"00440000","Brockton","Public School District","Superintendent","Kathleen Smith","43 Crescent Street",null,"Brockton","MA","02301",{"$f":"VLOOKUP(N11, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",4161,16527," ",""]
[12,"00460000","Brookline","Public School District","Superintendent","Andrew Bott","333 Washington Street",null,"Brookline","MA","02445",{"$f":"VLOOKUP(N12, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",808,7493," ",""]
[13,"00490000","Cambridge","Public School District","Superintendent","Kenneth Salim","159 Thorndike Street",null,"Cambridge","MA","02141",{"$f":"VLOOKUP(N13, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",577,6357," ",""]
[14,"08150000","Cape Cod Regional Vocational Technical","Public School District","Superintendent","Robert Sanborn","351 Pleasant Lake Avenue",null,"Harwich","MA","02645",{"$f":"VLOOKUP(N14, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",9,580," ",""]
[15,"06350000","Central Berkshire","Public School District","Superintendent","Laurie Casna","PO Box 299","Rt 8","Dalton","MA","01227",{"$f":"VLOOKUP(N15, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",8,1546," ",""]
[16,"00610000","Chicopee","Public School District","Superintendent","Richard Rege","180 Broadway Street",null,"Chicopee","MA","01020",{"$f":"VLOOKUP(N16, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",462,7255," ",""]
[17,"00640000","Clinton","Public School District","Superintendent","Steven Meyer","150 School Street",null,"Clinton","MA","01510",{"$f":"VLOOKUP(N17, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",168,1765," ",""]
[18,"06500000","Dighton-Rehoboth","Public School District","Superintendent","Anthony Azar","2700 Regional Road",null,"North Dighton","MA","02764",{"$f":"VLOOKUP(N18, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",4,2842," ",""]
[19,"06550000","Dover-Sherborn","Public School District","Superintendent","Andrew Keough","157 Farm Street","","Dover","MA","02030","Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu",null,4," ",""]
[20,"08170000","Essex North Shore Agricultural and Technical School District","Public School District","Superintendent","William Lupini","565 Maple Street","P.O. Box 346","Hathorne","MA","01937",{"$f":"VLOOKUP(N20, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",4,1367," ",""]
[21,"00930000","Everett","Public School District","Superintendent","Frederick Foresteire","121 Vine Street",null,"Everett","MA","02149",{"$f":"VLOOKUP(N21, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Ellie Rounds-Bloom"},"781-338-3128","erounds-bloom@doe.mass.edu",1470,6567," ",""]
[22,"00950000","Fall River","Public School District","Superintendent","Matthew Malone","417 Rock Street",null,"Fall River","MA","02720",{"$f":"VLOOKUP(N22, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",1671,9902," ",""]
[23,"00960000","Falmouth","Public School District","Superintendent","Nancy Taylor","340 Teaticket Hwy",null,"East Falmouth","MA","02536",{"$f":"VLOOKUP(N23, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",108,3264," ",""]
[24,"00970000","Fitchburg","Public School District","Superintendent","Andre Ravenelle","376 South Street",null,"Fitchburg","MA","01420",{"$f":"VLOOKUP(N24, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Russ Fleming"},"781-338-6529","RFleming@doe.mass.edu",756,5165," ",""]
[25,"01000000","Framingham","Public School District","Superintendent","Robert Tremblay","73 Mt. Wayte Avenue","Suite 5","Framingham","MA","01702",{"$f":"VLOOKUP(N25, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",1960,8471," ",""]
[26,"08180000","Franklin County Regional Vocational Technical","Public School District","Superintendent","Richard Martin","82 Industrial Blvd",null,"Turners Falls","MA","01376",{"$f":"VLOOKUP(N26, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",1,476," ",""]
[27,"01070000","Gloucester","Public School District","Superintendent","Richard Safier","2 Blackburn Drive",null,"Gloucester","MA","01930",{"$f":"VLOOKUP(N27, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",167,2798," ",""]
[28,"08210000","Greater Fall River Regional Vocational Technical","Public School District","Superintendent","Thomas Aubin","251 Stonehaven Rd",null,"Fall River","MA","02723",{"$f":"VLOOKUP(N28, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",31,1377," ",""]
[29,"08230000","Greater Lawrence Regional Vocational Technical","Public School District","Superintendent","John Lavoie","57 River Rd",null,"Andover","MA","01810",{"$f":"VLOOKUP(N29, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Ellie Rounds-Bloom"},"781-338-3128","erounds-bloom@doe.mass.edu",187,1492]
[30,"08280000","Greater Lowell Regional Vocational Technical","Public School District","Superintendent","Joseph Mastrocola","250 Pawtucket Blvd",null,"Tyngsborough","MA","01879",{"$f":"VLOOKUP(N30, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Nancy Labrie"},{"$f":"IF(N30=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":"781-338-3536"},"nlabrie@doe.mass.edu",1544,2201,{"$f":"IF(L30=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q30=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[31,"08250000","Greater New Bedford Regional Vocational Technical","Public School District","Superintendent","James O'Brien","1121 Ashley Blvd",null,"New Bedford","MA","02745",{"$f":"VLOOKUP(N31, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",66,2132,{"$f":"IF(L31=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q31=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[32,"01170000","Hadley","Public School District","Superintendent","Anne McKenzie","125 Russell Street","","Hadley","MA","01035","Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu",null,31,{"$f":"IF(L32=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q32=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[33,"01280000","Haverhill","Public School District","Superintendent","James Scully","4 Summer Street",null,"Haverhill","MA","01830",{"$f":"VLOOKUP(N33, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Ellie Rounds-Bloom"},"781-338-3128","erounds-bloom@doe.mass.edu",790,7311,{"$f":"IF(L33=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q33=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[34,"01370000","Holyoke","Public School District","Superintendent","Stephen Zrike","57 Suffolk Street",null,"Holyoke","MA","01040",{"$f":"VLOOKUP(N34, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",1285,5141,{"$f":"IF(L34=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q34=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[35,"01420000","Hull","Public School District","Superintendent","Michael Devine","18 Harborview Road","","Hull","MA","02045","Aneesh Sahni","781-338-3532","aneesh.sahni@doe.mass.edu",null,3]
[36,"01500000","Lee","Public School District","Superintendent","H. Eberwein","300A Greylock St",null,"Lee","MA","01238",{"$f":"VLOOKUP(N36, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",27,673,{"$f":"IF(L36=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q36=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[37,"01510000","Leicester","Public School District","Superintendent","Marilyn Tencza","1078 Main Street",null,"Leicester","MA","01524",{"$f":"VLOOKUP(N37, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",43,1490," ",""]
[38,"01600000","Lowell","Public School District","Superintendent","Salah Khelfaoui","155 Merrimack Street",null,"Lowell","MA","01852",{"$f":"VLOOKUP(N38, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Nancy Labrie"},{"$f":"IF(N38=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":"781-338-3536"},"nlabrie@doe.mass.edu",1544,14004," ",""]
[39,"05360000","Lower Pioneer Valley Education Collaborative","Collaborative","Executive Director","Andrew Churchill","174 Brush Hill Avenue",null,"West Springfield","MA","01089",{"$f":"VLOOKUP(N39, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu"]
[40,"01630000","Lynn","Public School District","Superintendent","Catherine Latham","100 Bennett St",null,"Lynn","MA","01905",{"$f":"VLOOKUP(N40, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",3591,15385," ",""]
[41,"01710000","Marshfield","Public School District","Superintendent","Jeffrey Granatino","76 South River Street",null,"Marshfield","MA","02050",{"$f":"VLOOKUP(N41, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",42,4040," ",""]
[42,"07000000","Martha's Vineyard","Public School District","Superintendent","Matthew D'Andrea","4 Pine Street",null,"Vineyard Haven","MA","02568",{"$f":"VLOOKUP(N42, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",64,635," ",""]
[43,"01760000","Medford","Public School District","Superintendent","Roy Belson","489 Winthrop Street",null,"Medford","MA","02155",{"$f":"VLOOKUP(N43, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",486,4230," ",""]
[44,"01810000","Methuen","Public School District","Superintendent","Judith Scannell","10 Ditson Place",null,"Methuen","MA","01844",{"$f":"VLOOKUP(N44, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",649,6868," ",""]
[45,"01850000","Milford","Public School District","Superintendent","Kevin Mcintyre","31 West Fountain Street",null,"Milford","MA","01757",{"$f":"VLOOKUP(N45, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",683,4081," ",""]
[46,"08300000","Minuteman Regional Vocational Technical","Public School District","Superintendent","Edward Bouquillon","758 Marrett Rd",null,"Lexington","MA","02421",{"$f":"VLOOKUP(N46, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",8,531," ",""]
[47,"08320000","Montachusett Regional Vocational Technical","Public School District","Superintendent","Sheila Harrity","1050 Westminster Street",null,"Fitchburg","MA","01420",{"$f":"VLOOKUP(N47, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",8,1395," ",""]
[48,"01970000","Nantucket","Public School District","Superintendent","William Cozort","10 Surfside Road","","Nantucket","MA","02554","Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu",null,256," ",""]
[49,"08520000","Nashoba Valley Regional Vocational Technical","Public School District","Superintendent","Denise Pigeon","100 Littleton Road",null,"Westford","MA","01886",{"$f":"VLOOKUP(N49, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",3,690," ",""]
[50,"02010000","New Bedford","Public School District","Superintendent","Pia Durkin","455 County Street","C/O Paul Rodrigues Administration Bldg.","New Bedford","MA","02740",{"$f":"VLOOKUP(N50, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",3645,12116," ",""]
[51,"02070000","Newton","Public School District","Superintendent","David Fleishman","100 Walnut Street",null,"Newtonville","MA","02460",{"$f":"VLOOKUP(N51, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",818,12683," ",""]
[52,"09150000","Norfolk County Agricultural","Public School District","Superintendent","Tammy Quinn","400 Main Street",null,"Walpole","MA","02081",{"$f":"VLOOKUP(N52, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Russ Fleming"},"781-338-6529","RFleming@doe.mass.edu",1,538," ",""]
[53,"04060000","Northampton-Smith Vocational Agricultural","Public School District","Superintendent","Andrew Linkenhoker","80 Locust Street",null,"Northampton","MA","01060",{"$f":"VLOOKUP(N53, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",6,491]
[54,"08530000","Northeast Metropolitan Regional Vocational Technical","Public School District","Superintendent","David DiBarri","100 Hemlock Rd",null,"Wakefield","MA","01880",{"$f":"VLOOKUP(N54, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Ellie Rounds-Bloom"},"781-338-3128","erounds-bloom@doe.mass.edu",45,1231,{"$f":"IF(L54=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q54=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[55,"08510000","Northern Berkshire Regional Vocational Technical","Public School District","Superintendent","James Brosnan","70 Hodges Cross Rd",null,"North Adams","MA","01247",{"$f":"VLOOKUP(N55, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",0,486,{"$f":"IF(L55=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q55=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[56,"08550000","Old Colony Regional Vocational Technical","Public School District","Superintendent","Aaron Polansky","476 North Avenue",null,"Rochester","MA","02770",{"$f":"VLOOKUP(N56, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",1,531,{"$f":"IF(L56=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q56=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[57,"08600000","Pathfinder Regional Vocational Technical","Public School District","Superintendent","Gerald Paist","240 Sykes Street",null,"Palmer","MA","01069",{"$f":"VLOOKUP(N57, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",0,620]
[58,"02290000","Peabody","Public School District","Superintendent","Herbert Levine","27 Lowell Street",null,"Peabody","MA","01960",{"$f":"VLOOKUP(N58, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",436,5655,{"$f":"IF(L58=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q58=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[59,"02360000","Pittsfield","Public School District","Superintendent","Jason Mccandless","269 First Street",null,"Pittsfield","MA","01201",{"$f":"VLOOKUP(N59, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",215,5333,{"$f":"IF(L59=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q59=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[60,"02390000","Plymouth","Public School District","Superintendent","Gary Maestas","253 South Meadow Rd",null,"Plymouth","MA","02360",{"$f":"VLOOKUP(N60, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",91,7364]
[61,"02430000","Quincy","Public School District","Superintendent","Richard Decristofaro","34 Coddington Street",null,"Quincy","MA","02169",{"$f":"VLOOKUP(N61, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Nancy Labrie"},{"$f":"IF(N61=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":"781-338-3536"},"nlabrie@doe.mass.edu",1544,9048,{"$f":"IF(L61=\"djwalker@doe.mass.edu\", \"nlabrie@doe.mass.edu\", \" \")","v":" "},{"$f":"IF(Q61=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":""}]
[62,"02580000","Salem","Public School District","Superintendent","Margarita Ruiz","29 Highland Avenue",null,"Salem","MA","01970",{"$f":"VLOOKUP(N62, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",488,3646," ",""]
[63,"08710000","Shawsheen Valley Regional Vocational Technical","Public School District","Superintendent","Timothy Broadrick","100 Cook Street",null,"Billerica","MA","01821",{"$f":"VLOOKUP(N63, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Russ Fleming"},"781-338-6529","RFleming@doe.mass.edu",0,1311," ",""]
[64,"07600000","Silver Lake","Public School District","Superintendent","Joy Blackwood","250 Pembroke Street",null,"Kingston","MA","02364",{"$f":"VLOOKUP(N64, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Nancy Labrie"},{"$f":"IF(N64=\"nlabrie@doe.mass.edu\", \"781-338-3536\",\"\")","v":"781-338-3536"},"nlabrie@doe.mass.edu",5,1737," ",""]
[65,"02740000","Somerville","Public School District","Superintendent","Mary Skipper","8 Bonair Street",null,"Somerville","MA","02145",{"$f":"VLOOKUP(N65, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",896,4544," ",""]
[66,"08290000","South Middlesex Regional Vocational Technical","Public School District","Superintendent","Jonathan Evans","750 Winter Street",null,"Framingham","MA","01702",{"$f":"VLOOKUP(N66, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Russ Fleming"},"781-338-6529","RFleming@doe.mass.edu",69,720," ",""]
[67,"08730000","South Shore Regional Vocational Technical","Public School District","Superintendent","Thomas Hickey","476 Webster Street",null,"Hanover","MA","02339",{"$f":"VLOOKUP(N67, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Beth O'Connell"},"781-338-3132","EO'Connell@doe.mass.edu",0,636," ",""]
[68,"08720000","Southeastern Regional Vocational Technical","Public School District","Superintendent","Luis Lopes","250 Foundry Street",null,"South Easton","MA","02375",{"$f":"VLOOKUP(N68, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",15,1409," ",""]
[69,"07650000","Southern Berkshire","Public School District","Superintendent","Beth Regulbuto","PO BOX 339",null,"Sheffield","MA","01257",{"$f":"VLOOKUP(N69, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",11,646," ",""]
[70,"08760000","Southern Worcester County Regional Vocational Technical","Public School District","Superintendent","John LaFleche","57 Old Muggett Hill Road",null,"Charlton","MA","01507",{"$f":"VLOOKUP(N70, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",2,1103," ",""]
[71,"07670000","Spencer-E Brookfield","Public School District","Superintendent","Jodi Bourassa","306 Main Street",null,"Spencer","MA","01562",{"$f":"VLOOKUP(N71, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",39,1337," ",""]
[72,"02810000","Springfield","Public School District","Superintendent","Daniel Warwick","1550 Main Street",null,"Springfield","MA","01103",{"$f":"VLOOKUP(N72, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",4340,24371," ",""]
[73,"02840000","Stoneham","Public School District","Superintendent","John Macero","149 Franklin Street",null,"Stoneham","MA","02180",{"$f":"VLOOKUP(N73, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",80,2253," ",""]
[74,"07700000","Tantasqua","Public School District","Superintendent","Erin Nosek","320A Brookfield Rd",null,"Fiskdale","MA","01518",{"$f":"VLOOKUP(N74, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Russ Fleming"},"781-338-6529","RFleming@doe.mass.edu",4,1775," ",""]
[75,"02930000","Taunton","Public School District","Superintendent","Julie Hackett","215 Harris Street",null,"Taunton","MA","02780",{"$f":"VLOOKUP(N75, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Julia Foodman"},"781-338-3577","jfoodman@doe.mass.edu",366,7755," ",""]
[76,"08780000","Tri-County Regional Vocational Technical","Public School District","Superintendent","Stephen Dockray","147 Pond Street",null,"Franklin","MA","02038",{"$f":"VLOOKUP(N76, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",3,975," ",""]
[77,"08790000","Upper Cape Cod Regional Vocational Technical","Public School District","Superintendent","Robert Dutch","220 Sandwich Rd",null,"Bourne","MA","02532",{"$f":"VLOOKUP(N77, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Ellie Rounds-Bloom"},"781-338-3128","erounds-bloom@doe.mass.edu",0,698," ",""]
[78,"03080000","Waltham","Public School District","Superintendent","Drew Echelson","617 Lexington Street",null,"Waltham","MA","02452",{"$f":"VLOOKUP(N78, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Sue Mazzarella"},"781-338-3587","smazzarella@doe.mass.edu",1260,5447," ",""]
[79,"03100000","Wareham","Public School District","Superintendent","Kimberly Shaver-Hood","48 Marion Road",null,"Wareham","MA","02571",{"$f":"VLOOKUP(N79, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Ellie Rounds-Bloom"},"781-338-3128","erounds-bloom@doe.mass.edu",25,2217," ",""]
[80,"03140000","Watertown","Public School District","Superintendent","Deanne Galdston","30 Common Street",null,"Watertown","MA","02472",{"$f":"VLOOKUP(N80, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",317,2453," ",""]
[81,"03250000","Westfield","Public School District","Superintendent","Stefan Czaporowski","94 North Elm Street","Suite 101","Westfield","MA","01085",{"$f":"VLOOKUP(N81, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Alex Lilley"},"781-338-6212","alilley@doe.mass.edu",317,5256,509,0,"Yes"]
[82,"03360000","Weymouth","Public School District","Superintendent","Jennifer Curtis-Whipple","111 Middle Street",null,"Weymouth","MA","02189",{"$f":"VLOOKUP(N82, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Ellie Rounds-Bloom"},"781-338-3128","erounds-bloom@doe.mass.edu",232,5813,843,0,"Yes"]
[83,"08850000","Whittier Regional Vocational Technical","Public School District","Superintendent","Maureen Lynch","115 Amesbury Line Rd",null,"Haverhill","MA","01830",{"$f":"VLOOKUP(N83, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Aneesh Sahni"},"781-338-3532","aneesh.sahni@doe.mass.edu",13,1247,1609,0,"Yes"]
[84,"03480000","Worcester","Public School District","Superintendent","Maureen Binienda","20 Irving Street",null,"Worcester","MA","01609",{"$f":"VLOOKUP(N84, LiaisonList!$C$1:$D$8, 2, FALSE)","v":"Russ Fleming"},"781-338-6529","RFleming@doe.mass.edu",7958,24429,1221,0,"Yes"]

{"sheet":"DataLookupValues","index":10,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Workbook Information"]
["Fiscal Year","FY18","Fundcode:",305]
["Title full name","I, Part A"]
["Title abbreviated","I"]
["District Information"]
["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"}]
["District Enrollment",{"$f":"VLOOKUP(valDistr,dataDistr,16,FALSE)","v":"March Enrolled Count"},"EL Enrollment",{"$f":"VLOOKUP(valDistr,dataDistr,15,FALSE)","v":"March EL Count (18c)"}]
["Low Inc Methods TI"]
["SELECT ONE",null,"TitleI Status"]
["Oct Eco Dis",null,1]
["Oct Eco Dis x 1.6",null,2,"SW"]
["March Eco Dis",null,3,"TA"]
["March Eco Dis x 1.6",null,4,"NT"]
["Other ",null,5,"CL"]
[]
["District lookup values"]
[]
[]
[null,null,null,null,null,1]
[null,null,null,null,null,1]