Spreadsheet: 096129fc-5ee6-472b-8f76-a3f41ad14d62
Sheet: Setup and Instructions

Staff Missing Override Record Template, version 1.0
1. SETUP REQUIRED BEFORE PROCEEDING
Enter the current values for Fiscal Year, Reporting Period, and District IRN in the fields below. |  |  | Example:
Enter Fiscal Year (e.g., 2012 for the 2011-2012 school year): | 2012 |  | 2020
Enter Reporting Period (K for October, N for Yearend): | K |  | N |  |  | K | October
Enter [NAME], including leading zeros, if any: | 999999 |  | 123456 |  |  | N | Yearend
Once these values are entered, you can go to the next tab (Data Entry) to enter specific override requests.
2. INSTRUCTIONS
Data Entry Tab
1. You will create and submit one override file for each Fiscal Year/Reporting Period combination. If this is the first time you are entering overrides for this year/reporting period, be sure to delete out any overrides from prior years/reporting periods that may still be included on the sheet from a previous year/reporting period's submission.
2. Enter override requests on the Data Entry tab.
3. Please do not skip rows when entering data. Any rows listed after a blank row will not be included in the export.
4. For a row to be included in the export, it must be complete. The Data Entry tab will identify if a row is complete or not.
5. If you later need to add additional overrides, be sure to start with the *.xlsx or *.xls version of the file.  It should contain the earlier overrides, assuming you saved the file.
6. Add additional overrides in the next available set of empty rows, leaving all prior overrides in place.  Just as with other data submitted to EMIS, each file submitted is cumulative  for the reporting period and must include the data from the prior submission. You should only delete rows after starting a reporting period if you intend to no longer request that override.
7. If you paste data into the Data Entry sheet, you may delete the data validation built into the sheet for the pasted cells.  To keep the data validation in place, do a "Paste Special" for "Values" only.
When you are ready to export a file for uploading into the Data Collector, complete the following steps (you may want to print a hard copy of these instructions, as you will not be able to return to this sheet in the middle of the process).
Sheet to Export Tab
1. After all overrides are entered on the "Data Entry" tab, switch to the "Sheet to Export" tab.
2. The overrides entered will be displayed in the uploadable file format.
3. Review the data to be sure that the rows just added are included at the bottom of the listing.
4. IMPORTANT! Save your changes by saving the file without changing its format (Save as Type *.xlsx or *.xls.) You will have to save the file twice- the first time in the *.xls(x) format to keep the data in a format that will allow you to add more overrides later, and the second time to save in a format (*.prn) for the Data Collector (steps 5 to 12 below).
5. On the menus at the top of the window, choose "File"
6. Choose "Save As"
7. Navigate to the directory where you want to save the file for later upload to the Data Collector
8. In the "File Name" box, we recommend you add the date to the file name for later tracking, as the date a file was created is not visible in the Data Collector (Examples: Myoverrides01012012, 01012012 YE Overrides, 01 12 2012 Overrides, etc.). There is no specific naming convention required for the file upload to be successful- the date is for your reference only.  The data collector will always use the version of the file with the most recent upload date, regardless of the file name or when the file was originally created.
9. In the "Save as type" dropdown, select "Formatted Text (Space delimited) (*.prn)"
10. Click the "Save" button
11. You will be prompted to make sure you only wish to save the active sheet- click "OK"
12. You will be prompted to make sure you wish to keep the file in this format, even though all features are not supported.  Since you saved the file back in step 4, you can click "Yes"
13. You can close the file and not save it again, as you already saved it in steps 4 and 10
Notes
1. This file is set up to handle no more than 150 override requests.  If you have over 150 requests to submit, please contact ODE via the help desk to discuss.
2. There is nothing special about using this file to submit overrides- any text file that meets the layout for the CP record can be submitted.