{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["READ ME FIRST","1. Signature Page","2. Contact Information","3A. Expenditures Lines 1-6","3B. Expenditures Lines 7-11","4. Budget","5. ISA crosswalk","Schedule A","LiasionList","dropdown","DataDistrictList","DataLookupValues","drop down","liaison","district list"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":27,"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 FIRST","index":0,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[28,1,28,12],[29,1,29,12],[15,1,15,12],[16,1,23,12],[25,1,25,12],[26,1,26,12],[27,1,27,12],[24,1,24,12],[14,1,14,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[4,1,12,12],[13,1,13,12]]}
[]
[null,"Massachusetts Department of Elementary & Secondary Education"]
[null,"FY20 Carl D. Perkins Career and Technical Education Postsecondary 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 'FY20Perkins401-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."]
[]
[]
[]
[]
[]
[]
[]
[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 \na 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,10],[11,5,11,10],[12,5,12,10]]}
[]
[null,"Massachusetts Department of Elementary and Secondary Education\nSTANDARD CONTRACT FORM AND APPLICATION FOR PROGRAM GRANTS"]
[]
[]
[null,"UPLOAD A SCANNED, SIGNED COPY OF THIS PAGE WITH THE DATE OF SUBMISSION TO EDGRANTS WITH THE BUDGET FOR EACH FUND CODE"]
[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,"Address: ",null,null,null,null,null,null,null,null,"DESE Federal Grant Liaison",null,{"$f":"valname","v":"Liaison Name"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone number:",null,{"$f":"valphonenum","v":"Liaison Phone Number"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Email:",null,{"$f":"valemail","v":"Liaison 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 401",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":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,2,6,11],[7,2,7,11],[8,1,8,3],[8,4,8,11],[1,1,1,3],[2,1,2,11],[3,1,3,11],[4,1,4,3],[4,4,4,11],[5,1,5,2],[5,3,5,11]]}
[]
[null,{"$f":"valDistrName","v":"College Name"}]
[null,"District Contact Information by Program\nPlease provide information for primary district contact for each program"]
[null,"Perkins Postsecondary Allocation Grant (Fund Code 401)"]
[null,"Name of Primary Contact:"]
[null,"Title:"]
[null,"Phone:"]
[null,"Email:"]
[null,"New to this program?  (Y/N)",null,null,"Select One"]

{"sheet":"3A. Expenditures Lines 1-6","index":3,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,3,1,4],[40,4,40,7],[41,4,41,7],[42,4,42,7],[35,2,38,2],[35,3,36,7],[37,4,37,7],[38,4,38,7],[39,4,39,7],[4,3,7,6],[18,3,20,3],[21,3,23,3],[24,3,26,3],[27,3,29,3],[30,3,32,3]]}
[]
[null,null,null,{"$f":"valDistrName","v":"College Name"}]
[]
[null,null,null,"Expenditures"]
[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,"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 performance target(s), list the core indicator(s)  addressed.","Step 3.4\nIf this expenditure addresses a performance target(s), please list the special population(s) addressed."," 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 1: Administrator",null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,"Line 2: Instructional/Professional Staff",null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,"Line 3. Support Staff",null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,"Line 4: Stipends",null,"Select One"]
[null,null,null,null,null,"Select one"]
[null,null,null,null,null,"Select one"]
[null,null,null,"Line 6: Contractual Services",null,"Select One"]
[null,null,null,null,null,"Select One"]
[null,null,null,null,null,"Select one"]
[]
[]
[null,null,"Step 3.7\nRequired Program Elements","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,"1R"]
[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,"3R"]
[null,null,null,"4R"]
[null,null,null,"5R"]
[null,null,null,"6R"]

{"sheet":"3B. Expenditures Lines 7-11","index":4,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,2,4,5],[43,4,43,7],[14,4,18,4],[19,4,23,4],[24,4,27,4],[28,4,34,4],[39,4,39,7],[40,4,40,7],[41,4,41,7],[36,2,38,2],[36,3,37,7],[38,4,38,7],[5,2,7,5],[42,4,42,7]]}
[]
[]
[]
[]
[null,null,"Expenditures (Lines 7-11)"]
[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,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,"Line 7: Supplies and Materials",null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Line 8: Travel",null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Line 9: Other costs",null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,"Line 11: Equipment ",null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[]
[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,"1R"]
[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,"3R"]
[null,null,null,"4R"]
[null,null,null,"5R "]
[null,null,null,"6R"]

{"sheet":"4. Budget","index":5,"n_rows":134,"n_cols":34,"rows_kept":134,"cut":false,"hidden":false,"merged":[[132,5,132,6],[132,7,132,8],[132,10,132,20],[132,24,132,27],[133,5,133,6],[133,7,133,8],[133,11,134,21],[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],[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],[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],[120,5,120,6],[120,7,120,8],[120,10,120,20],[120,24,120,27],[121,5,121,6],[121,7,121,8],[121,10,121,20],[121,24,121,27],[122,5,122,6],[122,7,122,8],[122,10,122,20],[122,24,122,27],[86,9,86,10],[87,9,87,10],[111,1,112,1],[111,3,111,31],[112,3,113,31],[114,3,114,10],[116,23,116,30],[117,23,117,30],[118,5,119,6],[118,7,119,8],[118,10,119,20],[118,24,119,27],[118,29,119,29],[103,3,103,11],[98,19,98,20],[90,4,90,11],[90,19,90,20],[91,4,91,10],[91,19,91,20],[97,4,97,10],[97,19,97,20],[95,19,95,20],[82,4,82,10],[82,19,82,20],[83,3,83,11],[85,9,85,10],[71,4,71,10],[71,19,71,20],[72,4,72,10],[72,19,72,20],[73,4,73,10],[73,19,73,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],[74,3,74,11],[76,19,76,20],[77,4,77,10],[77,19,77,20],[78,4,78,10],[78,19,78,20],[66,4,66,10],[66,19,66,20],[67,4,67,6],[69,4,69,10],[69,19,69,20],[70,4,70,10],[70,19,70,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],[58,4,58,7],[58,19,58,20],[59,4,59,7],[59,19,59,20],[60,3,60,11],[62,19,62,20],[55,4,55,7],[55,19,55,20],[56,4,56,7],[56,19,56,20],[57,4,57,7],[57,19,57,20],[50,4,50,11],[50,19,50,20],[51,3,51,11],[53,19,53,20],[54,4,54,7],[54,19,54,20],[47,4,47,11],[47,19,47,20],[48,4,48,11],[48,19,48,20],[49,4,49,11],[49,19,49,20],[42,4,42,7],[42,19,42,20],[43,3,43,11],[44,3,44,7],[45,4,45,11],[45,19,46,20],[46,4,46,11],[38,19,38,20],[39,4,39,7],[39,19,39,20],[40,4,40,7],[40,19,40,20],[41,4,41,7],[41,19,41,20],[34,4,34,7],[34,19,34,20],[35,4,35,7],[35,19,35,20],[36,3,36,11],[37,3,37,7],[30,3,30,11],[30,19,30,20],[31,3,31,7],[32,4,32,7],[32,19,32,20],[33,4,33,7],[33,19,33,20],[29,4,29,7],[29,19,29,20],[23,19,23,20],[24,4,24,7],[24,19,24,20],[25,4,25,7],[25,19,25,20],[26,4,26,7],[26,19,26,20],[15,19,15,20],[17,4,17,7],[17,19,17,20],[18,4,18,7],[18,19,18,20],[27,4,27,7],[27,19,27,20],[28,4,28,7],[28,19,28,20],[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],[92,4,92,10],[96,4,96,10],[95,4,95,10],[94,4,94,10],[93,4,93,10],[96,19,96,20],[94,19,94,20],[93,19,93,20],[92,19,92,20],[19,4,19,7],[19,19,19,20],[20,4,20,7],[20,19,20,20],[21,19,21,20],[22,3,22,7],[14,2,14,22],[15,3,15,11]]}
[]
[]
[null,null,{"$f":"valDistrName","v":"College Name"}]
[]
[null,null,"FY20 Perkins Postsecondary Allocation Budget Worksheet"]
[]
[null,null,null,"Allocation \n",null,null,{"$f":"IFERROR(valAllocPerk, 0)","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,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,"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(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,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M21,P21,0)","v":0},null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,0,0,null,null,{"$f":"SUM(N19:N21)","v":0},null,{"$f":"SUM(P19:P21)","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,null,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,{"$f":"IF(M26,P26,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,0,null,null,null,"Select One"]
[]
[null,null,null,"SUB-TOTAL",null,null,null,null,null,0,0,null,null,{"$f":"SUM(N25:N30)","v":0},null,{"$f":"SUM(P25:P30)","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(M34, P34, 0)","v":0},null,null,null,"Select One"]
[null,null,null,null,"Select One",null,null,null,null,null,null,null,false,{"$f":"IF(M35, P35, 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(N34:N36)","v":0},null,{"$f":"SUM(P34:P36)","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,null,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,null,null,false,{"$f":"IF(M41, P41, 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,"SUB-TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N40:N43)","v":0},null,{"$f":"SUM(P40:P43)","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(N45+N38+N32+N23))*0.09,0)","v":0}]
[null,null,null,null,"5b  Other",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P49:P51)","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(P47:P48)","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(P55:P60)","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(P64:P67)","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(P71:P74)","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(P78:P83)","v":0}]
[null,null,null,null,null,null,null,"(a) rate (%)",null,"(b) allocation less indirect",null,null,null,null,null,"Amount"]
[null,null,null,10,"INDIRECT COSTS *",null,null,null,null,{"$f":"IF(H87=\"\",\"\", (G7-IndExcl401)/(1+H87))","v":""}]
[null,null,null,null,"   maximum allowed",null,null," (a x b)",null,{"$f":"IFERROR(ROUND(J87*H87, 0), \"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P87)","v":0}]
[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(P92:P98)","v":0}]
[]
[null,null,null,"TOTAL FUNDS REQUESTED ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P23+P32+P38+P45+P53+P62+P69+P76+P85+P90+P100","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(P102<>valAllocPerk,P102-valAllocPerk,\"\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 4.2\nDistricts requesting funds for 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,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":"IndK401+IndEquip401","v":0}]
[]
[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((F121-25000)>0, (F121-25000), \"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF((F122-25000)>0, (F122-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(F121:G133)","v":0},null,{"$f":"SUM(H121:I133)","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(AD121:AD133)","v":0}]

{"sheet":"5. ISA crosswalk","index":6,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[32,11,32,12],[2,3,6,10],[9,9,10,10],[16,10,16,12],[16,4,16,6],[31,11,31,12]]}
[]
[null,null,null,"Interdepartmental Service Agreement (ISA) Crosswalk"]
[null,null,null,"Community colleges eligble to receive Perkins Post Secondray funds are required to an ISA for our files.  \nPlease complete this crosswalk to expedite execution of your ISA.  Grants Management will reach out to you once your grant application has been approved to complete the ISA process.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"ISA Budget  \n",null,null,"ENTER YOUR ISA BUDGET","Fringe Rate\n37.99% AA + 2.44%CC","MAX amount for indirect. \nIndicate which line items Indirect Costs are calculated on *#11 Equipment is excluded from the indirect cost calculation*","EdGrants Budget",null,null,"ISA Budget Notes:  Identify the object class(es) that make up each budgeted line item.  Or if you need more object class options\nExample: Line 7 Supplies = $10,700; broken out as EE: $2700; FF: $3000; UU: $5,000"]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(M28,0)","v":0}]
[null,null,null,null,2020,"AA","State Employee ",null,{"$f":"H19*37.99%","v":0},0,"Line 1 - \nAdmin Salaries","AA and/or CC",{"$f":"'4. Budget'!P23","v":0}]
[null,null,null,null,null,"BB","Employee Expenses",null,null,0,"Line 2- \nInstructional Staff","AA and/or CC",{"$f":"'4. Budget'!P32","v":0}]
[null,null,null,null,null,"CC","Special / Contracted Employee",null,{"$f":"(H21*2.44%)","v":0},0,"Line 3 - \nSupport Staff","AA and/or CC",{"$f":"'4. Budget'!P38","v":0}]
[null,null,null,null,null,"DD","Fringe 35.55% AA + 2.44% CC (D09)",{"$f":"I36","v":0},null,0,"Line 4 - \nStipends","AA and/or CC",{"$f":"'4. Budget'!P45","v":0}]
[null,null,null,null,null,"DD","Health & Welfare (D08) (Com College ONLY)",0,null,0,"Line 5 - Fringe","DD",{"$f":"'4. Budget'!P53","v":0}]
[null,null,null,null,null,"EE","Admin Expenses",0,null,0,"Line 6 - \nContractual Services","HH, CC, MM and/or LL",{"$f":"'4. Budget'!P62","v":0}]
[null,null,null,null,null,"EE","Indirect Cost (Cannot Exceed the value in cell F6)",null,null,0,"Line 7 - Supplies*","EE, FF and/or UU",{"$f":"'4. Budget'!P69","v":0}]
[null,null,null,null,null,"FF","Programmatic Supplies",null,null,0,"Line 8 - Travel**","BB and/or EE",{"$f":"'4. Budget'!P76","v":0}]
[null,null,null,null,null,"HH","Contractual Services",null,null,0,"Line 9 - \nOther Costs","could be any Object Class",{"$f":"'4. Budget'!P85","v":0}]
[null,null,null,null,null,"KK","Equipment",null,null,null,"Line 10 - Indirect","EE",{"$f":"'4. Budget'!P90","v":0}]
[null,null,null,null,null,"LL","Equipment Lease/Maintenance",null,null,0,"Line 11 - \nEquipment","KK or UU",{"$f":"'4. Budget'!P100","v":0}]
[null,null,null,null,null,"MM","Purchased Client Human & Social Services and Non-Human Services",0,null,0,null,"TOTAL",{"$f":"SUM(M19:M29)","v":0}]
[null,null,null,null,null,"UU","IT Expenses (hardware/software/contracts)",0,null,0]
[null,null,null,null,null,null,null,0,null,0,"Supplies - Line 7*","Travel - Line 8**"]
[null,null,null,null,null,null,null,0,null,0,"EE for office supplies","EE - Payments made to Vendor on behalf of staff"]
[null,null,null,null,null,null,null,0,null,0,"FF for books & edu. materials","BB - Employee Reimbursement"]
[null,null,null,null,null,null,null,0,null,0,"UU for IT hardware/software"]
[null,null,null,null,null,null,"TOTAL",{"$f":"SUM(H19:H35)","v":0},{"$f":"ROUNDUP(I19+I21,0)","v":0},{"$f":"SUM(J19:J35)","v":0}]
[null,null,null,null,null,null,"ISA Budget:",{"$f":"H36","v":0}]
[null,null,null,null,null,null,"EdGrants Budget:",{"$f":"M31","v":0}]
[null,null,null,null,null,null,"Difference to equal ZERO",{"$f":"H37-H38","v":0}]

{"sheet":"Schedule A","index":7,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[19,1,20,1],[19,2,20,11],[26,1,27,5],[26,6,27,8],[26,9,27,11],[2,2,2,10],[3,2,11,10],[14,1,14,11],[15,1,15,11],[17,1,17,11],[28,1,28,5],[28,6,28,8],[28,9,28,11],[21,1,22,1],[21,2,22,4],[21,5,22,10],[21,11,22,11],[23,1,24,1],[23,2,24,4],[23,5,24,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],[31,1,31,5],[31,6,31,8],[31,9,31,11],[32,1,32,5],[32,6,32,8],[32,9,32,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],[35,1,35,5],[35,6,35,8],[35,9,35,11],[36,1,36,5],[36,6,36,8],[36,9,36,11],[37,1,37,5],[37,6,37,8],[37,9,37,11],[38,1,38,5],[38,6,38,8],[38,9,38,11],[39,1,39,5],[39,6,39,8],[39,9,39,11],[40,1,40,5],[40,6,40,8],[40,9,40,11],[41,1,41,5],[41,6,41,8],[41,9,41,11],[42,1,42,5],[42,6,42,8],[42,9,42,11],[45,6,46,8],[45,9,46,11],[46,1,46,5],[48,1,49,11],[43,1,43,5],[43,6,43,8],[43,9,43,11],[44,1,44,5],[44,6,44,8],[44,9,44,11]]}
[]
[]
[null,null,"Instructions:\n\n "]
[null,null,"Fill out and print a separate copy of Schedule A for each Perkins program for which 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":"College 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(G29:I44)","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":"LiasionList","index":8,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Aneesh","Aneesh Sahni","781-338-3532","aneesh.sahni@doe.mass.edu"]
["Alex","Alex Lilley","781-338-6212","alilley@doe.mass.edu"]
["Beth","Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu"]
["Nancy","Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu"]
["Ellie","Ellie Rounds-Bloom","781-338-3128","erounds-bloom@doe.mass.edu"]
["Julia","Julia Foodman","781-338-3577","jfoodman@doe.mass.edu"]
["Russ","Russ Fleming","781-338-6529","RFleming@doe.mass.edu"]
["Sue","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu"]
[]
[null,{"$f":"CONCATENATE(G10,D10)","v":"08010801"},2019,"0801","Ellie","Assabet Valley Regional Vocational Technical","0801","Ellie Rounds-Bloom","781-338-3128","erounds-bloom@doe.mass.edu"]
[null,"4010805",2019,"0805","Aneesh","Blackstone Valley Regional Vocational Technical","0805","Aneesh Sahni","781-338-3532","aneesh.sahni@doe.mass.edu"]
[null,"4010806",2019,"0806","Nancy","Blue Hills Regional Vocational Technical","0806","Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu"]
[null,"4010821",2019,"0821","Alex","Greater Fall River Regional Vocational Technical","0821","Alex Lilley","781-338-6212","alilley@doe.mass.edu"]
[null,"4010828",2019,"0828","Nancy","Greater Lowell Regional Vocational Technical","0828","Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu"]
[null,"4010832",2019,"0832","Beth","Montachusett Regional Vocational Technical","0832","Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu"]
[null,"4010851",2019,"0851","Sue","Northern Berkshire Regional Vocational Technical","0851","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu"]
[null,"4010871",2019,"0871","Russ","Shawsheen Valley Regional Vocational Technical","0871","Russ Fleming","781-338-6529","RFleming@doe.mass.edu"]
[null,"4010872",2019,"0872","Julia","Southeastern Regional Vocational Technical","0872","Julia Foodman","781-338-3577","jfoodman@doe.mass.edu"]
[null,"4010876",2019,"0876","Sue","Southern Worcester County Regional Vocational Technical","0876","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu"]
[null,"4010878",2019,"0878","Alex","Tri-County Regional Vocational Technical","0878","Alex Lilley","781-338-6212","alilley@doe.mass.edu"]
[null,"4010879",2019,"0879","Ellie","Upper Cape Cod Regional Vocational Technical","0879","Ellie Rounds-Bloom","781-338-3128","erounds-bloom@doe.mass.edu"]
[null,"4011203",2019,"1203","Beth","Berkshire Community College","1203","Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu"]
[null,{"$f":"CONCATENATE(G24,D23)","v":"12051203"},2019,"1203","Beth","Berkshire Community College","1203","Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu"]
[null,"4011205",2019,"1205","Ellie","Bristol Community College","1205","Ellie Rounds-Bloom","781-338-3128","erounds-bloom@doe.mass.edu"]
[null,"4011206",2019,"1206","Alex","Bunker Hill Community College",1206,"Alex Lilley","781-338-6212","alilley@doe.mass.edu"]
[null,"4011207",2019,"1207","Aneesh","Cape Cod Community College","1207","Aneesh Sahni","781-338-3532","aneesh.sahni@doe.mass.edu"]
[null,"4011210",2019,"1210","Nancy","Holyoke Community College","1210","Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu"]
[null,"4011211",2019,"1211","Sue","Massachusetts Bay Community College","1211","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu"]
[null,"4011213",2019,"1213","Julia","Massasoit Community College","1213","Julia Foodman","781-338-3577","jfoodman@doe.mass.edu"]
[null,"4011214",2019,"1214","Sue","Middlesex Community College","1214","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu"]
[null,"4011215",2019,"1215","Sue","Mount Wachusett Community College","1215","Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu"]
[null,"4011218",2019,"1218","Aneesh","Greenfield Community College","1218","Aneesh Sahni","781-338-3532","aneesh.sahni@doe.mass.edu"]
[null,"4011225",2019,"1225","Ellie","North Shore Community College","1225","Ellie Rounds-Bloom","781-338-3128","erounds-bloom@doe.mass.edu"]
[null,"4011230",2019,"1230","Aneesh","Northern Essex Community College","1230","Aneesh Sahni","781-338-3532","aneesh.sahni@doe.mass.edu"]
[null,"4011240",2019,"1240","Aneesh","Quinsigamond Community College","1240","Aneesh Sahni","781-338-3532","aneesh.sahni@doe.mass.edu"]
[null,"4011245",2019,"1245","Nancy","Roxbury Community College",1245,"Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu"]
[null,"4011257",2019,"1257","Russ","Springfield Technical Community College",1257,"Russ Fleming","781-338-6529","RFleming@doe.mass.edu"]
[null,"4012032",2019,"2032","Beth","Benjamin Franklin Institute of Technology",2032,"Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu"]
[null,"4013235",2019,"3235","Julia","Quincy College","3235","Julia Foodman","781-338-3577","jfoodman@doe.mass.edu"]

{"sheet":"dropdown","index":9,"n_rows":67,"n_cols":7,"rows_kept":67,"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","Select One"]
[null,null,null,null,null,"Grant Program Manager/Coordinator ","1R"]
[null,null,null,null,null,"Other ","2R"]
[null,null,null,null,null,"InstructionalProf Staff Salaries","3R"]
[null,null,null,null,null,"Select One","4R"]
[null,null,null,null,null,"Classroom Teachers  ","5R"]
[null,null,null,null,null,"Instructional Coaches ","6R"]
[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,"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,"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,"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,"Rental Lease of Buildings  "]
[null,null,null,null,null,"Utility Services/ Telephone "]
[null,null,null,null,null,"Other  "]

{"sheet":"DataDistrictList","index":10,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[1,"College Name","Org Code","Liaison Name","Liaison Phone Number","Liaison Email"]
[2,"Berkshire Community College",{"$f":"VLOOKUP(B2, LiasionList!$F$10:$G$50,2, FALSE)","v":"1203"},{"$f":"VLOOKUP(C2, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Beth O'Connell"},{"$f":"VLOOKUP(C2, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3132"},{"$f":"VLOOKUP(C2, LiasionList!$G$10:$J$39, 4, FALSE)","v":"EO'Connell@doe.mass.edu"}]
[3,"Bristol Community College  ","1205",{"$f":"VLOOKUP(C3, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Ellie Rounds-Bloom"},{"$f":"VLOOKUP(C3, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3128"},{"$f":"VLOOKUP(C3, LiasionList!$G$10:$J$39, 4, FALSE)","v":"erounds-bloom@doe.mass.edu"}]
[4,"Bunker Hill Community College ",1206,{"$f":"VLOOKUP(C4, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Alex Lilley"},{"$f":"VLOOKUP(C4, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-6212"},{"$f":"VLOOKUP(C4, LiasionList!$G$10:$J$39, 4, FALSE)","v":"alilley@doe.mass.edu"}]
[5,"Cape Cod Community College",{"$f":"VLOOKUP(B5, LiasionList!$F$10:$G$50,2, FALSE)","v":"1207"},{"$f":"VLOOKUP(C5, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Aneesh Sahni"},{"$f":"VLOOKUP(C5, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3532"},{"$f":"VLOOKUP(C5, LiasionList!$G$10:$J$39, 4, FALSE)","v":"aneesh.sahni@doe.mass.edu"}]
[6,"Holyoke Community College",{"$f":"VLOOKUP(B6, LiasionList!$F$10:$G$50,2, FALSE)","v":"1210"},{"$f":"VLOOKUP(C6, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Nancy Labrie"},{"$f":"VLOOKUP(C6, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3536"},{"$f":"VLOOKUP(C6, LiasionList!$G$10:$J$39, 4, FALSE)","v":"nlabrie@doe.mass.edu"}]
[7,"Massachusetts Bay Community College",{"$f":"VLOOKUP(B7, LiasionList!$F$10:$G$50,2, FALSE)","v":"1211"},{"$f":"VLOOKUP(C7, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Sue Mazzarella"},{"$f":"VLOOKUP(C7, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3587"},{"$f":"VLOOKUP(C7, LiasionList!$G$10:$J$39, 4, FALSE)","v":"smazzarella@doe.mass.edu"}]
[8,"Massasoit Community College",{"$f":"VLOOKUP(B8, LiasionList!$F$10:$G$50,2, FALSE)","v":"1213"},{"$f":"VLOOKUP(C8, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Julia Foodman"},{"$f":"VLOOKUP(C8, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3577"},{"$f":"VLOOKUP(C8, LiasionList!$G$10:$J$39, 4, FALSE)","v":"jfoodman@doe.mass.edu"}]
[9,"Middlesex Community College",{"$f":"VLOOKUP(B9, LiasionList!$F$10:$G$50,2, FALSE)","v":"1214"},{"$f":"VLOOKUP(C9, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Sue Mazzarella"},{"$f":"VLOOKUP(C9, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3587"},{"$f":"VLOOKUP(C9, LiasionList!$G$10:$J$39, 4, FALSE)","v":"smazzarella@doe.mass.edu"}]
[10,"Mount Wachusett Community College",{"$f":"VLOOKUP(B10, LiasionList!$F$10:$G$50,2, FALSE)","v":"1215"},{"$f":"VLOOKUP(C10, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Sue Mazzarella"},{"$f":"VLOOKUP(C10, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3587"},{"$f":"VLOOKUP(C10, LiasionList!$G$10:$J$39, 4, FALSE)","v":"smazzarella@doe.mass.edu"}]
[11,"Greenfield Community College",{"$f":"VLOOKUP(B11, LiasionList!$F$10:$G$50,2, FALSE)","v":"1218"},{"$f":"VLOOKUP(C11, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Aneesh Sahni"},{"$f":"VLOOKUP(C11, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3532"},{"$f":"VLOOKUP(C11, LiasionList!$G$10:$J$39, 4, FALSE)","v":"aneesh.sahni@doe.mass.edu"}]
[12,"North Shore Community College",{"$f":"VLOOKUP(B12, LiasionList!$F$10:$G$50,2, FALSE)","v":"1225"},{"$f":"VLOOKUP(C12, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Ellie Rounds-Bloom"},{"$f":"VLOOKUP(C12, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3128"},{"$f":"VLOOKUP(C12, LiasionList!$G$10:$J$39, 4, FALSE)","v":"erounds-bloom@doe.mass.edu"}]
[13,"Northern Essex Community College",{"$f":"VLOOKUP(B13, LiasionList!$F$10:$G$50,2, FALSE)","v":"1230"},{"$f":"VLOOKUP(C13, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Aneesh Sahni"},{"$f":"VLOOKUP(C13, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3532"},{"$f":"VLOOKUP(C13, LiasionList!$G$10:$J$39, 4, FALSE)","v":"aneesh.sahni@doe.mass.edu"}]
[14,"Quinsigamond Community College",{"$f":"VLOOKUP(B14, LiasionList!$F$10:$G$50,2, FALSE)","v":"1240"},{"$f":"VLOOKUP(C14, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Aneesh Sahni"},{"$f":"VLOOKUP(C14, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3532"},{"$f":"VLOOKUP(C14, LiasionList!$G$10:$J$39, 4, FALSE)","v":"aneesh.sahni@doe.mass.edu"}]
[15,"Roxbury Community College ",1245,{"$f":"VLOOKUP(C15, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Nancy Labrie"},{"$f":"VLOOKUP(C15, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3536"},{"$f":"VLOOKUP(C15, LiasionList!$G$10:$J$39, 4, FALSE)","v":"nlabrie@doe.mass.edu"}]
[16,"Springfield Technical Community College ",1257,{"$f":"VLOOKUP(C16, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Russ Fleming"},{"$f":"VLOOKUP(C16, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-6529"},{"$f":"VLOOKUP(C16, LiasionList!$G$10:$J$39, 4, FALSE)","v":"RFleming@doe.mass.edu"}]
[17,"Benjamin Franklin Institute of Technology ",2032,{"$f":"VLOOKUP(C17, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Beth O'Connell"},{"$f":"VLOOKUP(C17, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3132"},{"$f":"VLOOKUP(C17, LiasionList!$G$10:$J$39, 4, FALSE)","v":"EO'Connell@doe.mass.edu"}]
[18,"Quincy College",{"$f":"VLOOKUP(B18, LiasionList!$F$10:$G$50,2, FALSE)","v":"3235"},{"$f":"VLOOKUP(C18, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Julia Foodman"},{"$f":"VLOOKUP(C18, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3577"},{"$f":"VLOOKUP(C18, LiasionList!$G$10:$J$39, 4, FALSE)","v":"jfoodman@doe.mass.edu"}]
[19,"Northern Berkshire Regional Vocational Technical ","0851",{"$f":"VLOOKUP(C19, LiasionList!$G$10:$H$39, 2, FALSE)","v":"Sue Mazzarella"},{"$f":"VLOOKUP(C19, LiasionList!$G$10:$J$39, 3, FALSE)","v":"781-338-3587"},{"$f":"VLOOKUP(C19, LiasionList!$G$10:$J$39, 4, FALSE)","v":"smazzarella@doe.mass.edu"}]

{"sheet":"DataLookupValues","index":11,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["District Information"]
["College value",1,null,null,"Liasons"]
["College Name:",{"$f":"VLOOKUP(B2, DataDistrictList!A1:B19,2, FALSE)","v":"College Name"},"district code",{"$f":"LEFT(VLOOKUP(valDistr,dataDistr,3,FALSE),4)","v":"Org "},"Name",{"$f":"VLOOKUP(valDistr,dataDistr,4,FALSE)","v":"Liaison Name"}]
["Address1",{"$f":"VLOOKUP(valDistr,dataDistr,7,FALSE)","v":{"$error":"#REF!"}},null,null,"Phone",{"$f":"VLOOKUP(valDistr,dataDistr,5,FALSE)","v":"Liaison Phone Number"}]
["Address2",{"$f":"IF(VLOOKUP(valDistr,dataDistr,8,FALSE)=0,\"\",VLOOKUP(valDistr,dataDistr,8,FALSE))","v":{"$error":"#REF!"}},null,null,"Email",{"$f":"VLOOKUP(valDistr,dataDistr,6,FALSE)","v":"Liaison Email"}]
["City, State, ZIP",9]

{"sheet":"drop down","index":12,"n_rows":70,"n_cols":7,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["per day",null,null,"yes ",null,"Budget Categories","Primary Functions "]
["per hour",null,null,"no",null,"Administrator Salaries","Select One"]
["flat",null,null,null,null,"Select One","Instruction-School day (public, K-12) "]
[null,null,null,null,null,"Grant Program Manager/Coordinator ","High quality PD"]
[null,null,null,null,null,"Other ","Data collection/management"]
[null,null,null,null,null,"InstructionalProf Staff Salaries","Instructional technology/digital learning"]
[null,null,null,null,null,"Select One","Planning and evaluation"]
[null,null,null,null,null,"Classroom Teachers  ","Program administration"]
[null,null,null,null,null,"Instructional Coaches ","Student transportation"]
[null,null,null,null,null,"Certified Specialist Teachers (providing individualized instruction)  ","Other"]
[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":"liaison","index":13,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Aneesh Sahni","781-338-3532","aneesh.sahni@doe.mass.edu"]
["Alex Lilley","781-338-6212","alilley@doe.mass.edu"]
["Beth O'Connell","781-338-3132","EO'Connell@doe.mass.edu"]
["Nancy Labrie","781-338-3536","nlabrie@doe.mass.edu"]
["Ellie Rounds-Bloom","781-338-3128","erounds-bloom@doe.mass.edu"]
["Julia Foodman","781-338-3577","jfoodman@doe.mass.edu"]
["Russ Fleming","781-338-6529","RFleming@doe.mass.edu"]
["Sue Mazzarella","781-338-3587","smazzarella@doe.mass.edu"]

{"sheet":"district list","index":14,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["LEA code","Name","Address"]
["1203","Berkshire Community College"]
["1205","Bristol Community College  "]
["1206","Bunker Hill Community College "]
["1207","Cape Cod Community College"]
["1210","Holyoke Community College"]
["1211","Massachusetts Bay Community College"]
["1213","Massasoit Community College"]
["1214","Middlesex Community College"]
["1215","Mount Wachusett Community College"]
["1218","Greenfield Community College"]
["1225","North Shore Community College"]
["1230","Northern Essex Community College"]
["1240","Quinsigamond Community College"]
["1245","Roxbury Community College "]
["1257","Springfield Technical Community College "]
["2032","Benjamin Franklin Institute of Technology "]
["3235","Quincy College"]
["0851","Northern Berkshire Regional Vocational Technical "]