Most states do not have ISD’s therefore we duplicate the municipal couties and insert them as ISD’s. To do this run the MySQL query “SE Create ISD Records from Counties”. Be careful this inserts records. You must first change the state code in 2 places and insert the state’s MunID.

The recently inserted ISD’s now need to be exported and pasted into the State’s Census Data XLSX file. To do this, first export the ISD’s from MySQL using “SE Export ISDs” query. Be careful to change the state code before exporting. Name the file “[State Code] Export ISDs.xlsx” and save it to Box in the state’s “Schools” folder.

Paste values only the exported ISD’s into the ISDs workbook in the state’s census data file.

In the ISDs tab, create a Data Validtion for F2:F last row by selecting Data à Data Validation à Allow List à Source =SchoolRegionsPicklist.

In the ISDs tab, enter into E2:E last row the formulae =VLOOKUP(F2,SchoolRegionsVlookup,3,FALSE).

Now tag the ISD’s by Region.