{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["INSTRUCTIONS","Special Ed Teachers (FS070)","Related Services Pers. (FS099)","Sp Ed Paraprofessionals (FS112)","Dashboard","Error Messages","Edit Check Details"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":50,"comments":3,"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":"INSTRUCTIONS","index":0,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,14,39,14],[1,1,1,13],[2,1,2,12],[3,4,3,5],[7,2,7,12],[9,2,9,12],[13,2,13,12],[15,2,15,12],[16,2,16,12],[29,1,29,13],[30,1,30,3],[23,1,23,13],[39,0,39,13],[11,2,11,12],[17,2,17,12],[19,2,19,12],[20,2,20,11],[21,1,21,13],[25,1,26,13],[27,1,27,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End of worksheet"]
[null,"Enhanced Pre-submission Edit Check Tool for IDEA 618 Part B Personnel Data"]
[null,"The Enhanced Pre-submission Edit Check Tool for IDEA 618 Part B Personnel Data is designed to be used by states as they prepare their data for submission via EDFacts. Use this tool to check SEA-level EDFacts files FS070, FS099, and FS112. The tool can identify potential edit check errors or errors in subtotals or totals. \n\nPlease note that data cannot be submitted using this tool. All data must be submitted following the guidelines provided in the "]
[null,"data file specifications at: ",null,null,"The EDFacts Initiative"]
[]
[null,"Please read the following instructions before using this tool:"]
[]
[null,"1.","To select, copy, and paste data from your EDFacts files into the tool:\n\n(a)  Open each of the three SEA-level IDEA personnel EDFacts data files (FS070, FS099, and FS112) in Excel (or similar application). \n\n(b)  Select and copy all rows and columns from each EDFacts data file. \n\n          •   Include the EDFacts data file header row and filler columns. \n          •   Do NOT use the \"Select All\" function in Excel. \n"]
[]
[null,null,"\nNOTE: Prior to copying the EDFacts data into each of the green data file tabs, \"Missing Category\" (MC) will appear in all data cells on the  Dashboard, Error Messages, and Edit Check Details tabs.  The missing categories are counted as triggered edit checks and displayed in the \"Triggered Edit Checks\" box on the Dashboard, Error Messages, and Edit Check Details tabs.\n\n(c)  Paste the selected data to cell A11 in the corresponding green data tab in this tool. "]
[]
[null,null,"(d)  Click the \"Check Data Format\" button to run all format checks. If there are format errors, you will see pop-up boxes that contain important information about the errors, and a list of data rows containing errors will be shown in the \"Triggered Format Checks\" table to the right of your EDFacts data on the green data file tabs. \n\n(e) To delete EDFacts files previously pasted into the selected green data file tabs, click the \"Clear Data\" button, if needed."]
[]
[null,"2.","To facilitate locating data errors in the EDFacts files, data displayed in the Dashboard, Error Messages, and Edit Check Details tabs are highlighted in red and hyperlinked. Use the hyperlinked data to trace each highlighted error through the Dashboard, Error Messages, and Edit Check Details tabs back to the EDFacts data file in the green data file tab in which the error originated. "]
[]
[null,"3.","Error messages in the RED tab indicate computational errors or other errors in reporting. Please correct all errors before the files are submitted to the U.S. Department of Education via the EDFacts EDEN Submission System.  \n\n          •   Keep in mind, this tool does not account for the state-specific differences in EDFacts file contents. \n          •   State-specific differences noted in your EDFacts IDEA State Supplemental Survey (SSS) may show up as error messages in this tool.\n\nPlease confirm that error messages due to state-specific differences align with the contents of your IDEA-SSS. For example, if your state does not use the related services personnel category \"Physical Education Teachers and Recreational and Therapeutic Recreation Specialists\" (EDFacts permitted value PEANDREC) and you have indicated \"No\" for that category in your IDEA-SSS, then you will receive error messages for the missing category PEANDREC."]
[]
[null,null,"Triggered format checks are shown in the table to the right of the EDFacts data file you pasted into the three green data file tabs. The text shown in each column of the \"Triggered Format Checks\" table indicates data that is missing, repeated, and/or formatted incorrectly. Scroll down to view all triggered format checks for repeated or incorrectly formatted data. The EDFacts permitted values are used to clearly identify data that are missing, repeated, and/or formatted incorrectly. \n\nFor example: SPEECHPATH_NFC_N in the \"Missing Data Elements\" column indicates that the Full Time Equivalent (FTE) count for speech-language pathologists who are not fully certified is missing from Category Set A in your FS099 file."]
[]
[null,"4.","Review and address each triggered format check and error message.  If changes need to be made to the data, make these changes in the corresponding data system and/or EDFacts file and then carefully re-paste the data into the green data file tabs. Do NOT make any data modifications in the Enhanced Edit Check Tool spreadsheet."]
[]
[null,"If you would like assistance using this tool, please contact your IDC State Liaison or e-mail IDEAdata@westat.com."]
[]
[null,"Please note this tool is currently not 508 accessible. If you need assistance with the use of this tool, please contact your IDC State Liaison or email IDEAdata@westat.com."]
[]
[null,"The IDEA Data Center (IDC) released this document under U.S. Department of Education, Office of Special Education Programs Grant No. H373Y130002. Richelle Davis and Meredith Miceli serve as the project officers. "]
[]
[null,"The views expressed herein do not necessarily represent the positions or policies of the U.S. Department of Education. No official endorsement by the U.S. Department of Education of any product, commodity, service, or enterprise mentioned in this publication is intended or should be inferred. This product is in the public domain. Authorization to reproduce it in whole or in part is granted. "]
[]
[null,"Westat is the lead organization for IDC. For more information about the center’s work and its partners, see"]
[null,"www.ideadata.org"]
[]
[null,"Version Date: 10/8/2018"]
[null,"IDEA Data Center (IDC)"]
[]
[]
[]
[]
[]
["End of worksheet"]

{"sheet":"Special Ed Teachers (FS070)","index":1,"n_rows":42,"n_cols":30,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,29,1048575,29],[0,0,0,12],[8,14,8,16],[2,9,2,12],[3,9,3,11],[4,9,4,11],[5,9,5,11],[6,9,6,11],[41,0,1048575,12]]}
[{"$f":"\"IDEA Personnel Data for School Year \"&'Special Ed Teachers (FS070)'!E11","v":"IDEA Personnel Data for School Year "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End of worksheet",null,null,null,"End of worksheet"]
[]
[null,null,null,null,null,null,null,null,null,"Triggered Format Checks",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V12:V40)","v":9}]
[null,null,null,null,null,null,null,null,null,"Type",null,null,"Total"]
[null,null,null,null,null,null,null,null,null,"Missing Data Elements",null,null,{"$f":"COUNTIF(O12:O70,\"?*\")","v":9}]
[null,null,null,null,null,null,null,null,null,"Duplicate Row Elements",null,null,{"$f":"COUNTIF(P13:P71,\"?*\")","v":0}]
[null,null,null,null,null,null,null,null,null,"Invalid Data Elements",null,null,{"$f":"COUNTIF(Q14:Q72,\"?*\")","v":0}]
[]
["FS070 — Special Education Teachers (FTE)",null,null,null,null,null,null,null,null,null,null,null,null,null,"                     Triggered Format Checks"]
["File Record Number","FIPS State Code","State Agency Number","Filler","Filler","Table Name","Filler","Qualification Status (Teachers)","Filler","Age Group","Total Indicator","Explanation","Teacher FTE",null,"Missing\nData Elements\n(formatted)","Duplicate Row\nElements","Invalid Data\nElements",null,"Missing\nData Element","Current\nListing","Master\nListing","Is Blank",null,{"$f":"COUNTIF(O12:O25,\"*\" & $Y$10 & \"*\")","v":0},"MISSING","Master\nListing\n(output)","Current\nListing\n(output)",null,"Is Missing Data Element"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(1:1))),\"\")","v":"SPEDTCHFULCRT_3TO5_N"},{"$f":"IF(COUNTIF(CurrentListing,T12)>1,AA12,\"\")","v":""},{"$f":"IF(LEN(T12)=0,\"\",IF(ISNA(MATCH(T12,MasterListing_FS070,0)),AA12,\"\"))","v":""},null,{"$f":"IF(LEN(U12)=0,\"\",IF(ISNA(MATCH(U12,CurrentListing,0)),Z12,\"\"))","v":"SPEDTCHFULCRT_3TO5_N"},{"$f":"H12&J12&K12","v":""},"SPEDTCHFULCRT3TO5N",{"$f":"IF(LEN(O12)>0,1,0)","v":1},null,null,null,"SPEDTCHFULCRT_3TO5_N",{"$f":"IF(LEN(H12&\"_\"&J12&\"_\"&K12)<3,\"\",H12&\"_\"&J12&\"_\"&K12)","v":""},null,{"$f":"IF(LEN(O12)>0,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(2:2))),\"\")","v":"SPEDTCHFULCRT_6TO21_N"},"","",null,"SPEDTCHFULCRT_6TO21_N",{"$f":"H13&J13&K13","v":""},"SPEDTCHFULCRT6TO21N",{"$f":"IF(LEN(O13)>0,1,0)","v":1},null,null,null,"SPEDTCHFULCRT_6TO21_N",{"$f":"IF(LEN(H13&\"_\"&J13&\"_\"&K13)<3,\"\",H13&\"_\"&J13&\"_\"&K13)","v":""},null,{"$f":"IF(LEN(O13)>0,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(3:3))),\"\")","v":"SPEDTCHNFULCRT_3TO5_N"},"","",null,"SPEDTCHNFULCRT_3TO5_N",{"$f":"H14&J14&K14","v":""},"SPEDTCHNFULCRT3TO5N",1,null,null,null,"SPEDTCHNFULCRT_3TO5_N",{"$f":"IF(LEN(H14&\"_\"&J14&\"_\"&K14)<3,\"\",H14&\"_\"&J14&\"_\"&K14)","v":""},null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(4:4))),\"\")","v":"SPEDTCHNFULCRT_6TO21_N"},"","",null,"SPEDTCHNFULCRT_6TO21_N","","SPEDTCHNFULCRT6TO21N",1,null,null,null,"SPEDTCHNFULCRT_6TO21_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(5:5))),\"\")","v":"_3TO5_Y"},"","",null,"_3TO5_Y","","3TO5Y",1,null,null,null,"_3TO5_Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(6:6))),\"\")","v":"_6TO21_Y"},"","",null,"_6TO21_Y","","6TO21Y",1,null,null,null,"_6TO21_Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(7:7))),\"\")","v":"SPEDTCHNFULCRT__Y"},"","",null,"SPEDTCHNFULCRT__Y","","SPEDTCHFULCRTY",1,null,null,null,"SPEDTCHNFULCRT__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(8:8))),\"\")","v":"SPEDTCHFULCRT__Y"},"","",null,"SPEDTCHFULCRT__Y","","SPEDTCHNFULCRTY",1,null,null,null,"SPEDTCHFULCRT__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(9:9))),\"\")","v":"__Y"},"","",null,"__Y","","Y",1,null,null,null,"__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(10:10))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,{"$f":"IF(LEN(H21&\"_\"&J21&\"_\"&K21)<3,\"\",H21&\"_\"&J21&\"_\"&K21)","v":""},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(11:11))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(12:12))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(13:13))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(14:14))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(15:15))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(16:16))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(17:17))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(18:18))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(19:19))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(20:20))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(21:21))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(22:22))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(23:23))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(24:24))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(25:25))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(26:26))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(27:27))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(28:28))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(29:29))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[]
["End of worksheet"]

{"sheet":"Related Services Pers. (FS099)","index":2,"n_rows":71,"n_cols":29,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,28,70,28],[0,0,0,11],[8,13,8,15],[2,8,2,11],[3,8,3,10],[6,8,6,10],[5,8,5,10],[4,8,4,10],[70,0,70,11]]}
[{"$f":"\"IDEA Personnel Data for School Year \"&'Special Ed Teachers (FS070)'!E11","v":"IDEA Personnel Data for School Year "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End of worksheet",null,null,"End of worksheet"]
[]
[null,null,null,null,null,null,null,null,"Triggered Format Checks",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U12:U70)","v":29}]
[null,null,null,null,null,null,null,null,"Type",null,null,"Total"]
[null,null,null,null,null,null,null,null,"Missing Data Elements",null,null,{"$f":"COUNTIF(N12:N70,\"?*\")","v":29}]
[null,null,null,null,null,null,null,null,"Duplicate Row Elements",null,null,{"$f":"COUNTIF(O13:O71,\"?*\")","v":0}]
[null,null,null,null,null,null,null,null,"Invalid Data Elements",null,null,{"$f":"COUNTIF(P14:P72,\"?*\")","v":0}]
[]
["FS099 — Special Education Related Services Personnel ",null,null,null,null,null,null,null,null,null,null,null,null,"Triggered Format Checks"]
["File Record Number","FIPS State Code","State Agency Number","Filler","Filler","Table Name","Staff Category (Special Education Related Service)","Certification Status","Filler","Total Indicator","Explanation","Staff FTE",null,"Missing\nData Elements\n(formatted)","Duplicate Row\nElements","Invalid Data\nElements",null,"Missing\nData Element","Current\nListing","Master\nListing","Is Blank",null,{"$f":"COUNTIF(N12:N25,\"*\" & $Y$10 & \"*\")","v":0},"MISSING","Master\nListing\n(output)","Current\nListing\n(output)",null,"Is Missing Data Element"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(1:1))),\"\")","v":"AUDIO_FC_N"},{"$f":"IF(COUNTIF(CurrentListing_C099,S12)>1,S12,\"\")","v":""},{"$f":"IF(LEN(S12)=0,\"\",IF(ISNA(MATCH(S12,MasterListing_FS099,0)),S12,\"\"))","v":""},null,{"$f":"IF(LEN(T12)=0,\"\",IF(ISNA(MATCH(T12,CurrentListing_C099,0)),Y12,\"\"))","v":"AUDIO_FC_N"},{"$f":"G12&H12&J12","v":""},"AUDIOFCN",{"$f":"IF(LEN(N12)>0,1,0)","v":1},null,null,null,"AUDIO_FC_N",{"$f":"IF(LEN(G12&\"_\"&H12&\"_\"&J12)<3,\"\",G12&\"_\"&H12&\"_\"&J12)","v":""},null,{"$f":"IF(LEN(N12)>0,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(2:2))),\"\")","v":"COUNSELOR_FC_N"},"","",null,"COUNSELOR_FC_N",{"$f":"G13&H13&J13","v":""},"COUNSELORFCN",{"$f":"IF(LEN(N13)>0,1,0)","v":1},null,null,null,"COUNSELOR_FC_N",{"$f":"IF(LEN(G13&\"_\"&H13&\"_\"&J13)<3,\"\",G13&\"_\"&H13&\"_\"&J13)","v":""},null,{"$f":"IF(LEN(N13)>0,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(3:3))),\"\")","v":"INTERPRET_FC_N"},"","",null,"INTERPRET_FC_N","","INTERPRETFCN",1,null,null,null,"INTERPRET_FC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(4:4))),\"\")","v":"MEDNURSE_FC_N"},"","",null,"MEDNURSE_FC_N","","MEDNURSEFCN",1,null,null,null,"MEDNURSE_FC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(5:5))),\"\")","v":"OCCTHERAP_FC_N"},"","",null,"OCCTHERAP_FC_N","","OCCTHERAPFCN",1,null,null,null,"OCCTHERAP_FC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(6:6))),\"\")","v":"ORIENTMOBIL_FC_N"},"","",null,"ORIENTMOBIL_FC_N","","ORIENTMOBILFCN",1,null,null,null,"ORIENTMOBIL_FC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(7:7))),\"\")","v":"PEANDREC_FC_N"},"","",null,"PEANDREC_FC_N","","PEANDRECFCN",1,null,null,null,"PEANDREC_FC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(8:8))),\"\")","v":"PHYSTHERAP_FC_N"},"","",null,"PHYSTHERAP_FC_N","","PHYSTHERAPFCN",1,null,null,null,"PHYSTHERAP_FC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(9:9))),\"\")","v":"PSYCH_FC_N"},"","",null,"PSYCH_FC_N","","PSYCHFCN",1,null,null,null,"PSYCH_FC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(10:10))),\"\")","v":"SOCIALWORK_FC_N"},"","",null,"SOCIALWORK_FC_N","","SOCIALWORKFCN",1,null,null,null,"SOCIALWORK_FC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(11:11))),\"\")","v":"SPEECHPATH_FC_N"},"","",null,"SPEECHPATH_FC_N","","SPEECHPATHFCN",1,null,null,null,"SPEECHPATH_FC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(12:12))),\"\")","v":"COUNSELOR_NFC_N"},"","",null,"COUNSELOR_NFC_N","","COUNSELORNFCN",1,null,null,null,"COUNSELOR_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(13:13))),\"\")","v":"INTERPRET_NFC_N"},"","",null,"INTERPRET_NFC_N","","INTERPRETNFCN",1,null,null,null,"INTERPRET_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(14:14))),\"\")","v":"OCCTHERAP_NFC_N"},"","",null,"OCCTHERAP_NFC_N","","OCCTHERAPNFCN",1,null,null,null,"OCCTHERAP_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(15:15))),\"\")","v":"ORIENTMOBIL_NFC_N"},"","",null,"ORIENTMOBIL_NFC_N","","ORIENTMOBILNFCN",1,null,null,null,"ORIENTMOBIL_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(16:16))),\"\")","v":"PHYSTHERAP_NFC_N"},"","",null,"PHYSTHERAP_NFC_N","","PHYSTHERAPNFCN",1,null,null,null,"PHYSTHERAP_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(17:17))),\"\")","v":"PSYCH_NFC_N"},"","",null,"PSYCH_NFC_N","","PSYCHNFCN",1,null,null,null,"PSYCH_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(18:18))),\"\")","v":"SOCIALWORK_NFC_N"},"","",null,"SOCIALWORK_NFC_N","","SOCIALWORKNFCN",1,null,null,null,"SOCIALWORK_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(19:19))),\"\")","v":"SPEECHPATH_NFC_N"},"","",null,"SPEECHPATH_NFC_N","","SPEECHPATHNFCN",1,null,null,null,"SPEECHPATH_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(20:20))),\"\")","v":"AUDIO_NFC_N"},"","",null,"AUDIO_NFC_N","","AUDIONFCN",1,null,null,null,"AUDIO_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(21:21))),\"\")","v":"MEDNURSE_NFC_N"},"","",null,"MEDNURSE_NFC_N","","MEDNURSENFCN",1,null,null,null,"MEDNURSE_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(22:22))),\"\")","v":"PEANDREC_NFC_N"},"","",null,"PEANDREC_NFC_N","","PEANDRECNFCN",1,null,null,null,"PEANDREC_NFC_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(23:23))),\"\")","v":"AUDIO__Y"},"","",null,"AUDIO__Y","","AUDIOY",1,null,null,null,"AUDIO__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(24:24))),\"\")","v":"COUNSELOR__Y"},"","",null,"COUNSELOR__Y","","COUNSELORY",1,null,null,null,"COUNSELOR__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(25:25))),\"\")","v":"INTERPRET__Y"},"","",null,"INTERPRET__Y","","INTERPRETY",1,null,null,null,"INTERPRET__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(26:26))),\"\")","v":"MEDNURSE__Y"},"","",null,"MEDNURSE__Y","","MEDNURSEY",1,null,null,null,"MEDNURSE__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(27:27))),\"\")","v":"OCCTHERAP__Y"},"","",null,"OCCTHERAP__Y","","OCCTHERAPY",1,null,null,null,"OCCTHERAP__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(28:28))),\"\")","v":"ORIENTMOBIL__Y"},"","",null,"ORIENTMOBIL__Y","","ORIENTMOBILY",1,null,null,null,"ORIENTMOBIL__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(29:29))),\"\")","v":"PEANDREC__Y"},"","",null,"PEANDREC__Y","","PEANDRECY",1,null,null,null,"PEANDREC__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(30:30))),\"\")","v":""},"","",null,"PHYSTHERAP__Y","","PHYSTHERAPY",0,null,null,null,"PHYSTHERAP__Y","",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(31:31))),\"\")","v":""},"","",null,"PSYCH__Y","","PSYCHY",0,null,null,null,"PSYCH__Y","",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(32:32))),\"\")","v":""},"","",null,"SOCIALWORK__Y","","SOCIALWORKY",0,null,null,null,"SOCIALWORK__Y","",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(33:33))),\"\")","v":""},{"$f":"IF(COUNTIF(CurrentListing_C099,S44)>1,S44,\"\")","v":""},{"$f":"IF(LEN(S44)=0,\"\",IF(ISNA(MATCH(S44,MasterListing_FS099,0)),S44,\"\"))","v":""},null,{"$f":"IF(LEN(T44)=0,\"\",IF(ISNA(MATCH(T44,CurrentListing_C099,0)),Y44,\"\"))","v":"SPEECHPATH__Y"},"","SPEECHPATHY",0,null,null,null,"SPEECHPATH__Y","",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(34:34))),\"\")","v":""},"","",null,"",{"$f":"G45&H45&J45","v":""},null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(35:35))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(36:36))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(37:37))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(38:38))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(39:39))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(40:40))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(41:41))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(42:42))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(43:43))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(44:44))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(45:45))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(46:46))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(47:47))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(48:48))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(49:49))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(50:50))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(51:51))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(52:52))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(53:53))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(54:54))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(55:55))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(56:56))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(57:57))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(58:58))),\"\")","v":""},"","",null,"","",null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($R$12:$R$40, SMALL(IF(ISBLANK($R$12:$R$40)+ISERROR($R$12:$R$40)+LEN($R$12:$R$40)=0, \"\", ROW($R$12:$R$40)-MIN(ROW($R$12:$R$40))+1), ROW(59:59))),\"\")","v":""},"","",null,{"$f":"IF(LEN(T70)=0,\"\",IF(ISNA(MATCH(T70,CurrentListing_C099,0)),T70,\"\"))","v":""},"",null,null,null,null,null,null,"",null,0]
["End of worksheet"]

{"sheet":"Sp Ed Paraprofessionals (FS112)","index":3,"n_rows":42,"n_cols":30,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,29,41,29],[0,0,0,12],[8,14,8,16],[2,9,2,12],[3,9,3,11],[4,9,4,11],[5,9,5,11],[6,9,6,11],[41,0,41,12]]}
[{"$f":"\"IDEA Personnel Data for School Year \"&'Special Ed Teachers (FS070)'!E11","v":"IDEA Personnel Data for School Year "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=IF(LEN(AF13)=0,\"\",IF(ISNA(MATCH(AF13,CurrentListing,0)),AG13,\"\"))",null,null,null,null,null,null,null,null,null,"End of worksheet"]
[]
[null,null,null,null,null,null,null,null,null,"Triggered Format Checks",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V12:V40)","v":9}]
[null,null,null,null,null,null,null,null,null,"Type",null,null,"Total"]
[null,null,null,null,null,null,null,null,null,"Missing Data Elements",null,null,{"$f":"COUNTIF(O12:O70,\"?*\")","v":9}]
[null,null,null,null,null,null,null,null,null,"Duplicate Row Elements",null,null,{"$f":"COUNTIF(P13:P71,\"?*\")","v":0}]
[null,null,null,null,null,null,null,null,null,"Invalid Data Elements",null,null,{"$f":"COUNTIF(Q14:Q72,\"?*\")","v":0}]
[]
["FS112 — Special Education Paraprofessionals ",null,null,null,null,null,null,null,null,null,null,null,null,null,"                     Triggered Format Checks"]
["File Record Number","FIPS State Code","State Agency Number","Filler","Filler","Table Name","Filler","Age Group","Qualification Status","Filler","Total Indicator","Explanation","Staff FTE",null,"Missing\nData Elements\n(formatted)","Duplicate Row\nElements","Invalid Data\nElements",null,"Missing\nData Element","Current\nListing","Master\nListing","Is Blank",null,{"$f":"COUNTIF(O12:O25,\"*\" & $Y$10 & \"*\")","v":0},"MISSING","Master\nListing\n(output)","Current\nListing\n(output)",null,"Is Missing Data Element"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(1:1))),\"\")","v":"3TO5_Q_N"},{"$f":"IF(COUNTIF(CurrentListing_C112,T12)>1,AA12,\"\")","v":""},{"$f":"IF(LEN(T12)=0,\"\",IF(ISNA(MATCH(T12,MasterListing_FS112,0)),AA12,\"\"))","v":""},null,{"$f":"IF(LEN(U12)=0,\"\",IF(ISNA(MATCH(U12,CurrentListing_C112,0)),Z12,\"\"))","v":"3TO5_Q_N"},{"$f":"H12&I12&K12","v":""},"3TO5QN",{"$f":"IF(LEN(O12)>0,1,0)","v":1},null,null,null,"3TO5_Q_N",{"$f":"IF(LEN(H12&\"_\"&I12&\"_\"&K12)<3,\"\",H12&\"_\"&I12&\"_\"&K12)","v":""},null,{"$f":"IF(LEN(O12)>0,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(2:2))),\"\")","v":"6TO21_Q_N"},"","",null,"6TO21_Q_N",{"$f":"H13&I13&K13","v":""},"6TO21QN",{"$f":"IF(LEN(O13)>0,1,0)","v":1},null,null,null,"6TO21_Q_N",{"$f":"IF(LEN(H13&\"_\"&I13&\"_\"&K13)<3,\"\",H13&\"_\"&I13&\"_\"&K13)","v":""},null,{"$f":"IF(LEN(O13)>0,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(3:3))),\"\")","v":"3TO5_NQ_N"},"","",null,"3TO5_NQ_N","","3TO5NQN",1,null,null,null,"3TO5_NQ_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(4:4))),\"\")","v":"6TO21_NQ_N"},"","",null,"6TO21_NQ_N","","6TO21NQN",1,null,null,null,"6TO21_NQ_N","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(5:5))),\"\")","v":"3TO5__Y"},"","",null,"3TO5__Y","","3TO5Y",1,null,null,null,"3TO5__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(6:6))),\"\")","v":"6TO21__Y"},"","",null,"6TO21__Y","","6TO21Y",1,null,null,null,"6TO21__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(7:7))),\"\")","v":"_Q_Y"},"","",null,"_Q_Y","","QY",1,null,null,null,"_Q_Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(8:8))),\"\")","v":"_NQ_Y"},"","",null,"_NQ_Y","","NQY",1,null,null,null,"_NQ_Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(9:9))),\"\")","v":"__Y"},"","",null,"__Y","","Y",1,null,null,null,"__Y","",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(10:10))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(11:11))),\"\")","v":""},{"$f":"IF(COUNTIF(CurrentListing_C112,T22)>1,T22,\"\")","v":""},"",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(12:12))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(13:13))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(14:14))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(15:15))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(16:16))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(17:17))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(18:18))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(19:19))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(20:20))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(21:21))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(22:22))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(23:23))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(24:24))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(25:25))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(26:26))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(27:27))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(28:28))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$41, SMALL(IF(ISBLANK($S$12:$S$41)+ISERROR($S$12:$S$41)+LEN($S$12:$S$41)=0, \"\", ROW($S$12:$S$41)-MIN(ROW($S$12:$S$41))+1), ROW(29:29))),\"\")","v":""},"","",null,"","",null,0,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($S$12:$S$40, SMALL(IF(ISBLANK($S$12:$S$40)+ISERROR($S$12:$S$40)+LEN($S$12:$S$40)=0, \"\", ROW($S$12:$S$40)-MIN(ROW($S$12:$S$40))+1), ROW(30:30))),\"\")","v":""},null,"",null,""]
["End of worksheet"]

{"sheet":"Dashboard","index":4,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,3,5,5],[4,3,4,5],[9,0,9,6],[17,0,17,6],[25,0,25,6],[41,0,41,6],[6,3,6,5],[25,13,25,22],[26,13,26,22],[27,13,27,22],[10,13,10,22],[11,13,11,22],[17,13,17,22],[22,13,22,22],[18,13,18,22],[19,13,19,22],[20,13,20,22],[21,13,21,22],[37,1,37,5],[32,1,32,5],[33,1,33,5],[30,1,30,5],[31,1,31,5],[28,1,28,5],[29,1,29,5],[27,1,27,5],[0,0,0,6],[0,7,37,7],[13,13,13,22],[9,13,9,22],[36,13,36,22],[29,13,29,22],[30,13,30,22],[31,13,31,22],[32,13,32,22],[33,13,33,22],[23,13,23,22],[15,13,15,22],[36,1,36,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[2,3,2,6],[3,3,3,5],[28,13,28,22],[34,13,34,22],[35,13,35,22],[13,1,13,5],[14,1,14,5],[15,1,15,5],[11,1,11,5],[12,1,12,5],[35,1,35,5],[14,13,14,22],[12,13,12,22],[22,1,22,5],[34,1,34,5],[23,1,23,5]]}
[{"$f":"\"IDEA Personnel Data for School Year \"&'Special Ed Teachers (FS070)'!E11","v":"IDEA Personnel Data for School Year "},null,null,null,null,null,null,"End of worksheet"]
[]
[null,null,null," Triggered Edit Checks"]
[null,null,null,"Data File",null,null,"Count"]
[null,null,null,"FS070 — Special Education Teachers (FTE)",null,null,{"$f":"SUM(J11:J16)","v":6}]
[null,null,null,"FS112 — Special Education Paraprofessionals ",null,null,{"$f":"SUM(J19:J24)","v":6}]
[null,null,null,"FS099 — Special Education Related Services Personnel ",null,null,{"$f":"SUM(J27:J37)","v":11}]
[null,null,null,"Total",null,null,{"$f":"SUM(G5:G7)","v":23},null,null,"Search Value:",1]
[]
["FS070 — Special Education Teachers (FTE)",null,null,null,null,null,null,null,"Link","Triggered?","FTE","File",null,"Error Messages"]
["File","Special Education Teachers",null,null,null,null,"FTE",null,"D12",{"$f":"IF(G12=\"\",0,IF(OR(G12=\"No Data\",SUM('Edit Check Details'!B12:C12)<>'Edit Check Details'!D12),1,0))","v":1},{"$f":"G12","v":"MC"},{"$f":"A16","v":"FS070"},null,{"$f":"IF(J11=1,\"Fully Certified + Not Fully Certified Special Education Teachers for Ages 3-5  ≠ Special Education Teachers for Ages 3-5\",\"\")","v":"Fully Certified + Not Fully Certified Special Education Teachers for Ages 3-5  ≠ Special Education Teachers for Ages 3-5"}]
["FS070","Special Education Teachers for Ages 3-5 ",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D12),\"No Data\",'Edit Check Details'!D12)","v":"MC"},null,"D13",{"$f":"IF(G13=\"\",0,IF(OR(G13=\"No Data\",SUM('Edit Check Details'!B13:C13)<>'Edit Check Details'!D13),1,0))","v":1},{"$f":"G13","v":"MC"},{"$f":"A12","v":"FS070"},null,{"$f":"IF(J12=1,\"Fully Certified + Not Fully Certified Special Education Teachers for Ages 6-21  ≠ Special Education Teachers for Ages 6-21\",\"\")","v":"Fully Certified + Not Fully Certified Special Education Teachers for Ages 6-21  ≠ Special Education Teachers for Ages 6-21"}]
["FS070","Special Education Teachers for Ages 6-21 ",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D13),\"No Data\",'Edit Check Details'!D13)","v":"MC"},null,"B14",{"$f":"IF(G14=\"\",0,IF(OR(G14=\"No Data\",SUM('Edit Check Details'!B12:B13)<>'Edit Check Details'!B14),1,0))","v":1},"MC",{"$f":"A13","v":"FS070"},null,{"$f":"IF(J13=1,\"Fully Certified Special Education Teachers for Ages 3-5 + Ages 6-21  ≠ Fully Certified Special Education Teachers for Ages 3-21\",\"\")","v":"Fully Certified Special Education Teachers for Ages 3-5 + Ages 6-21  ≠ Fully Certified Special Education Teachers for Ages 3-21"}]
["FS070","Fully Certified Special Education Teachers for Ages 3-21 ",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!B14),\"No Data\",'Edit Check Details'!B14)","v":"MC"},null,"C14",{"$f":"IF(G15=\"\",0,IF(OR(G15=\"No Data\",SUM('Edit Check Details'!C12:C13)<>'Edit Check Details'!C14),1,0))","v":1},"MC",{"$f":"A14","v":"FS070"},null,{"$f":"IF(J14=1,\"Not Fully Certified Special Education Teachers for Ages 3-5 + Ages 6-21  ≠ Not Fully Certified Special Education Teachers for Ages 3-21\",\"\")","v":"Not Fully Certified Special Education Teachers for Ages 3-5 + Ages 6-21  ≠ Not Fully Certified Special Education Teachers for Ages 3-21"}]
["FS070","Not Fully Certified Special Education Teachers for Ages 3-21",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!C14),\"No Data\",'Edit Check Details'!C14)","v":"MC"},null,"D14",{"$f":"IF(G16=\"\",0,IF(OR(G16=\"No Data\",SUM('Edit Check Details'!B14:C14)<>'Edit Check Details'!D14),1,0))","v":1},"MC",{"$f":"A15","v":"FS070"},null,{"$f":"IF(J15=1,\"Fully Certified Special Education Teachers for Ages 3-21 + Not Fully Certified Qualified Special Education Teachers for Ages 3-21 ≠ Total Special Education Teachers Serving Children with Disabilities Ages 3-21\",\"\")","v":"Fully Certified Special Education Teachers for Ages 3-21 + Not Fully Certified Qualified Special Education Teachers for Ages 3-21 ≠ Total Special Education Teachers Serving Children with Disabilities Ages 3-21"}]
["FS070","Total Special Education Teachers Serving Children with Disabilities Ages 3-21",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D14),\"No Data\",'Edit Check Details'!D14)","v":"MC"},null,"D14",{"$f":"IF(G16=\"\",0,IF(OR(G16=\"No Data\",SUM('Edit Check Details'!D12:D13)<>'Edit Check Details'!D14),1,0))","v":1},{"$f":"G16","v":"MC"},{"$f":"A16","v":"FS070"},null,{"$f":"IF(J16=1,\"Special Education Teachers for Ages 3-5 + Ages 6-21 ≠ Total Special Education Teachers Serving Children with Disabilities Ages 3-21\",\"\")","v":"Special Education Teachers for Ages 3-5 + Ages 6-21 ≠ Total Special Education Teachers Serving Children with Disabilities Ages 3-21"}]
[]
["FS112 — Special Education Paraprofessionals ",null,null,null,null,null,null,null,null,null,null,null,null,"Error Messages"]
["File","Special Education Paraprofessionals",null,null,null,null,"FTE",null,"D18",{"$f":"IF(G20=\"\",0,IF(OR(G20=\"No Data\",SUM('Edit Check Details'!B18:C18)<>'Edit Check Details'!D18),1,0))","v":1},{"$f":"G20","v":"MC"},{"$f":"A24","v":"FS112"},null,{"$f":"IF(J19=1,\"Qualified + Not Qualified Special Education Paraprofessionals for Ages 3-5  ≠ Special Education Paraprofessionals for Ages 3-5\",\"\")","v":"Qualified + Not Qualified Special Education Paraprofessionals for Ages 3-5  ≠ Special Education Paraprofessionals for Ages 3-5"}]
["FS112","Special Education Paraprofessionals for Ages 3-5",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D18),\"No Data\",'Edit Check Details'!D18)","v":"MC"},null,"D19",{"$f":"IF(G21=\"\",0,IF(OR(G21=\"No Data\",SUM('Edit Check Details'!B19:C19)<>'Edit Check Details'!D19),1,0))","v":1},{"$f":"G21","v":"MC"},{"$f":"A20","v":"FS112"},null,{"$f":"IF(J20=1,\"Qualified + Not Qualified Special Education Paraprofessionals for Ages 6-21  ≠ Special Education Paraprofessionals for Ages 6-21\",\"\")","v":"Qualified + Not Qualified Special Education Paraprofessionals for Ages 6-21  ≠ Special Education Paraprofessionals for Ages 6-21"}]
["FS112","Special Education Paraprofessionals for Ages 6-21",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D19),\"No Data\",'Edit Check Details'!D19)","v":"MC"},null,"B20",{"$f":"IF(G22=\"\",0,IF(OR(G22=\"No Data\",SUM('Edit Check Details'!B18:B19)<>'Edit Check Details'!B20),1,0))","v":1},"MC",{"$f":"A21","v":"FS112"},null,{"$f":"IF(J21=1,\"Qualified Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Qualified Special Education Paraprofessionals for Ages 3-21\",\"\")","v":"Qualified Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Qualified Special Education Paraprofessionals for Ages 3-21"}]
["FS112","Qualified Special Education Paraprofessionals for Ages 3-21",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!B20),\"No Data\",'Edit Check Details'!B20)","v":"MC"},null,"C20",{"$f":"IF(G23=\"\",0,IF(OR(G23=\"No Data\",SUM('Edit Check Details'!C18:C19)<>'Edit Check Details'!C20),1,0))","v":1},"MC",{"$f":"A22","v":"FS112"},null,{"$f":"IF(J22=1,\"Not Qualified Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Not Qualified Special Education Paraprofessionals for Ages 3-21\",\"\")","v":"Not Qualified Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Not Qualified Special Education Paraprofessionals for Ages 3-21"}]
["FS112","Not Qualified Special Education Paraprofessionals for Ages 3-21",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!C20),\"No Data\",'Edit Check Details'!C20)","v":"MC"},null,"D20",{"$f":"IF(G24=\"\",0,IF(OR(G24=\"No Data\",SUM('Edit Check Details'!B20:C20)<>'Edit Check Details'!D20),1,0))","v":1},"MC",{"$f":"A23","v":"FS112"},null,{"$f":"IF(J23=1,\"Qualified Special Education Paraprofessionals for Ages 3-21  + Not Qualified Special Education Paraprofessionals for Ages 3-21 ≠ Total Special Education Paraprofessionals Serving Children with Disabilities Ages 3-21\",\"\")","v":"Qualified Special Education Paraprofessionals for Ages 3-21  + Not Qualified Special Education Paraprofessionals for Ages 3-21 ≠ Total Special Education Paraprofessionals Serving Children with Disabilities Ages 3-21"}]
["FS112","Total Special Education Paraprofessionals Serving Children with Disabilities Ages 3-21",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D20),\"No Data\",'Edit Check Details'!D20)","v":"MC"},null,"D20",{"$f":"IF(G24=\"\",0,IF(OR(G24=\"No Data\",SUM('Edit Check Details'!D18:D19)<>'Edit Check Details'!D20),1,0))","v":1},{"$f":"G24","v":"MC"},"FS112",null,{"$f":"IF(J24=1,\"Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Total Special Education Paraprofessionals Serving Children with Disabilities Ages 3-21\",\"\")","v":"Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Total Special Education Paraprofessionals Serving Children with Disabilities Ages 3-21"}]
[]
["FS099 — Special Education Related Services Personnel ",null,null,null,null,null,null,null,null,null,null,null,null,"Error Messages"]
["File","Related Services Personnel",null,null,null,null,"FTE",null,"D24",{"$f":"IF(G28=\"\",0,IF(OR(G28=\"No Data\",SUM('Edit Check Details'!B24:C24)<>'Edit Check Details'!D24),1,0))","v":1},{"$f":"G28","v":"MC"},{"$f":"A28","v":"FS099"},null,{"$f":"IF(J27=1,\"Fully Certified + Not Fully Certified Audiologists  ≠ Total Audiologists\",\"\")","v":"Fully Certified + Not Fully Certified Audiologists  ≠ Total Audiologists"}]
["FS099","Audiologists",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D24),\"No Data\",'Edit Check Details'!D24)","v":"MC"},null,"D25",{"$f":"IF(G29=\"\",0,IF(OR(G29=\"No Data\",SUM('Edit Check Details'!B25:C25)<>'Edit Check Details'!D25),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J28=1,\"Fully Certified + Not Fully Certified Speech-Language Pathologists  ≠ Total Speech-Language Pathologists\",\"\")","v":"Fully Certified + Not Fully Certified Speech-Language Pathologists  ≠ Total Speech-Language Pathologists"}]
["FS099","Speech-Language Pathologists",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D25),\"No Data\",'Edit Check Details'!D25)","v":"MC"},null,"D26",{"$f":"IF(G30=\"\",0,IF(OR(G30=\"No Data\",SUM('Edit Check Details'!B26:C26)<>'Edit Check Details'!D26),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J29=1,\"Fully Certified + Not Fully Certified Interpreters  ≠ Total Interpreters\",\"\")","v":"Fully Certified + Not Fully Certified Interpreters  ≠ Total Interpreters"}]
["FS099","Interpreters",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D26),\"No Data\",'Edit Check Details'!D26)","v":"MC"},null,"D27",{"$f":"IF(G31=\"\",0,IF(OR(G31=\"No Data\",SUM('Edit Check Details'!B27:C27)<>'Edit Check Details'!D27),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J30=1,\"Fully Certified + Not Fully Certified Psychologists  ≠ Total Psychologists\",\"\")","v":"Fully Certified + Not Fully Certified Psychologists  ≠ Total Psychologists"}]
["FS099","Psychologists",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D27),\"No Data\",'Edit Check Details'!D27)","v":"MC"},null,"D28",{"$f":"IF(G32=\"\",0,IF(OR(G32=\"No Data\",SUM('Edit Check Details'!B28:C28)<>'Edit Check Details'!D28),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J31=1,\"Fully Certified + Not Fully Certified Occupational Therapists  ≠ Total Occupational Therapists\",\"\")","v":"Fully Certified + Not Fully Certified Occupational Therapists  ≠ Total Occupational Therapists"}]
["FS099","Occupational Therapists",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D28),\"No Data\",'Edit Check Details'!D28)","v":"MC"},null,"D29",{"$f":"IF(G33=\"\",0,IF(OR(G33=\"No Data\",SUM('Edit Check Details'!B29:C29)<>'Edit Check Details'!D29),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J32=1,\"Fully Certified + Not Fully Certified Physical Therapists  ≠ Total Physical Therapists\",\"\")","v":"Fully Certified + Not Fully Certified Physical Therapists  ≠ Total Physical Therapists"}]
["FS099","Physical Therapists",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D29),\"No Data\",'Edit Check Details'!D29)","v":"MC"},null,"D30",{"$f":"IF(G34=\"\",0,IF(OR(G34=\"No Data\",SUM('Edit Check Details'!B30:C30)<>'Edit Check Details'!D30),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J33=1,\"Fully Certified + Not Fully Certified Physical Education and Recreation and Therapeutic Recreation Specialists  ≠ Total Physical Education and Recreation and Therapeutic Recreation Specialists\",\"\")","v":"Fully Certified + Not Fully Certified Physical Education and Recreation and Therapeutic Recreation Specialists  ≠ Total Physical Education and Recreation and Therapeutic Recreation Specialists"}]
["FS099","Physical Education and Recreation and Therapeutic Recreation Specialists",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D30),\"No Data\",'Edit Check Details'!D30)","v":"MC"},null,"D31",{"$f":"IF(G35=\"\",0,IF(OR(G35=\"No Data\",SUM('Edit Check Details'!B31:C31)<>'Edit Check Details'!D31),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J34=1,\"Fully Certified + Not Fully Certified Social Workers  ≠ Total Social Workers\",\"\")","v":"Fully Certified + Not Fully Certified Social Workers  ≠ Total Social Workers"}]
["FS099","Social Workers",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D31),\"No Data\",'Edit Check Details'!D31)","v":"MC"},null,"D32",{"$f":"IF(G36=\"\",0,IF(OR(G36=\"No Data\",SUM('Edit Check Details'!B32:C32)<>'Edit Check Details'!D32),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J35=1,\"Fully Certified + Not Fully Certified Medical/Nursing Service Staff  ≠ Total Medical/Nursing Service Staff\",\"\")","v":"Fully Certified + Not Fully Certified Medical/Nursing Service Staff  ≠ Total Medical/Nursing Service Staff"}]
["FS099","Medical/Nursing Service Staff",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D32),\"No Data\",'Edit Check Details'!D32)","v":"MC"},null,"D33",{"$f":"IF(G37=\"\",0,IF(OR(G37=\"No Data\",SUM('Edit Check Details'!B33:C33)<>'Edit Check Details'!D33),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J36=1,\"Fully Certified + Not Fully Certified Counselors and Rehabilitation Counselors  ≠ Total Counselors and Rehabilitation Counselors\",\"\")","v":"Fully Certified + Not Fully Certified Counselors and Rehabilitation Counselors  ≠ Total Counselors and Rehabilitation Counselors"}]
["FS099","Counselors and Rehabilitation Counselors",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D33),\"No Data\",'Edit Check Details'!D33)","v":"MC"},null,"D34",{"$f":"IF(G38=\"\",0,IF(OR(G38=\"No Data\",SUM('Edit Check Details'!B34:C34)<>'Edit Check Details'!D34),1,0))","v":1},"MC","FS099",null,{"$f":"IF(J37=1,\"Fully Certified + Not Fully Certified Orientation and Mobility Specialists  ≠ Total Orientation and Mobility Specialists\",\"\")","v":"Fully Certified + Not Fully Certified Orientation and Mobility Specialists  ≠ Total Orientation and Mobility Specialists"}]
["FS099","Orientation and Mobility Specialists",null,null,null,null,{"$f":"IF(ISERROR('Edit Check Details'!D34),\"No Data\",'Edit Check Details'!D34)","v":"MC"}]
[]
["NOTE: \"MC\" = Missing Category"]
[]
["End of worksheet"]

{"sheet":"Error Messages","index":5,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,13,42,13],[20,1,20,11],[21,1,21,11],[22,1,22,11],[23,1,23,11],[24,1,24,11],[25,1,25,11],[26,1,26,11],[27,1,27,11],[28,1,28,11],[29,1,29,11],[30,1,30,11],[31,1,31,11],[32,1,32,11],[33,1,33,11],[34,1,34,11],[44,0,44,12],[0,0,0,12],[3,5,3,9],[19,1,19,11],[18,1,18,11],[17,1,17,11],[16,1,16,11],[15,1,15,11],[14,1,14,11],[13,1,13,11],[12,1,12,11],[11,1,11,11],[10,1,10,11],[4,5,4,8]]}
[{"$f":"\"IDEA Personnel Data for School Year \"&'Special Ed Teachers (FS070)'!E11","v":"IDEA Personnel Data for School Year "},null,null,null,null,null,null,null,null,null,null,null,null,"End of worksheet","End of worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!#REF!, SMALL(IF($C$2=Dashboard!J19:J23, ROW(Dashboard!J19:J23)-MIN(ROW(Dashboard!J19:J23))+1, \"\"), ROW(A1))),\"\")","v":""}]
[]
[null,null,null,null,null,"Triggered Edit Checks"]
[null,null,null,null,null,"Data File",null,null,null,"Count",null,null,null,null,null,null,null,null,null,"=IFERROR(INDEX(Dashboard!$T$16:$T$20, SMALL(IF($U$7=Dashboard!$S$16:$S$20, ROW(Dashboard!$S$16:$S$20)-MIN(ROW(Dashboard!$S$16:$S$20))+1, \"\"), ROW(A1))),\"\")"]
[null,null,null,null,null,"FS070 — Special Education Teachers (FTE)",null,null,null,{"$f":"SUM(Dashboard!J11:J16)","v":6}]
[null,null,null,null,null,"FS112 — Special Education Paraprofessionals ",null,null,null,{"$f":"SUM(Dashboard!J19:J24)","v":6}]
[null,null,null,null,null,"FS099 — Special Education Related Services Personnel ",null,null,null,{"$f":"SUM(Dashboard!J27:J37)","v":11},null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J6:J8)","v":23},null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A1))),\"\")","v":"D12"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A1))),\"\")","v":"Fully Certified + Not Fully Certified Special Education Teachers for Ages 3-5  ≠ Special Education Teachers for Ages 3-5"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A1))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A1))),\"\")","v":"FS070"},{"$f":"IF(U9=\"No Data\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A2))),\"\")","v":"D13"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A2))),\"\")","v":"Fully Certified + Not Fully Certified Special Education Teachers for Ages 6-21  ≠ Special Education Teachers for Ages 6-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A2))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A2))),\"\")","v":"FS070"},0]
["File","Triggered Edit Checks",null,null,null,null,null,null,null,null,null,null,"FTE",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A3))),\"\")","v":"B14"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A3))),\"\")","v":"Fully Certified Special Education Teachers for Ages 3-5 + Ages 6-21  ≠ Fully Certified Special Education Teachers for Ages 3-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A3))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A3))),\"\")","v":"FS070"},0]
[{"$f":"V9","v":"FS070"},{"$f":"IF(W9=1,\"No Data\",T9)","v":"Fully Certified + Not Fully Certified Special Education Teachers for Ages 3-5  ≠ Special Education Teachers for Ages 3-5"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S9=\"\",\"\",HYPERLINK(CONCATENATE(\"#\",\"'Edit Check Details'!\",S9),U9))","v":"MC"},null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A4))),\"\")","v":"C14"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A4))),\"\")","v":"Not Fully Certified Special Education Teachers for Ages 3-5 + Ages 6-21  ≠ Not Fully Certified Special Education Teachers for Ages 3-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A4))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A4))),\"\")","v":"FS070"},0]
[{"$f":"V10","v":"FS070"},"Fully Certified + Not Fully Certified Special Education Teachers for Ages 6-21  ≠ Special Education Teachers for Ages 6-21",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S10=\"\",\"\",HYPERLINK(CONCATENATE(\"#\",\"'Edit Check Details'!\",S10),U10))","v":"MC"},null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A5))),\"\")","v":"D14"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A5))),\"\")","v":"Fully Certified Special Education Teachers for Ages 3-21 + Not Fully Certified Qualified Special Education Teachers for Ages 3-21 ≠ Total Special Education Teachers Serving Children with Disabilities Ages 3-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A5))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A5))),\"\")","v":"FS070"},0]
[{"$f":"V11","v":"FS070"},"Fully Certified Special Education Teachers for Ages 3-5 + Ages 6-21  ≠ Fully Certified Special Education Teachers for Ages 3-21",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A6))),\"\")","v":"D14"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A6))),\"\")","v":"Special Education Teachers for Ages 3-5 + Ages 6-21 ≠ Total Special Education Teachers Serving Children with Disabilities Ages 3-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A6))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A6))),\"\")","v":"FS070"},0]
[{"$f":"V12","v":"FS070"},{"$f":"IF(W12=1,\"No Data\",T12)","v":"Not Fully Certified Special Education Teachers for Ages 3-5 + Ages 6-21  ≠ Not Fully Certified Special Education Teachers for Ages 3-21"},null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A7))),\"\")","v":"D18"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A7))),\"\")","v":"Qualified + Not Qualified Special Education Paraprofessionals for Ages 3-5  ≠ Special Education Paraprofessionals for Ages 3-5"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A7))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A7))),\"\")","v":"FS112"},0]
[{"$f":"V13","v":"FS070"},{"$f":"IF(W13=1,\"No Data\",T13)","v":"Fully Certified Special Education Teachers for Ages 3-21 + Not Fully Certified Qualified Special Education Teachers for Ages 3-21 ≠ Total Special Education Teachers Serving Children with Disabilities Ages 3-21"},null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A8))),\"\")","v":"D19"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A8))),\"\")","v":"Qualified + Not Qualified Special Education Paraprofessionals for Ages 6-21  ≠ Special Education Paraprofessionals for Ages 6-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A8))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A8))),\"\")","v":"FS112"},0]
["FS070","Special Education Teachers for Ages 3-5 + Ages 6-21 ≠ Total Special Education Teachers Serving Children with Disabilities Ages 3-21",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A9))),\"\")","v":"B20"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A9))),\"\")","v":"Qualified Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Qualified Special Education Paraprofessionals for Ages 3-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A9))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A9))),\"\")","v":"FS112"},0]
["FS112","Qualified + Not Qualified Special Education Paraprofessionals for Ages 3-5  ≠ Special Education Paraprofessionals for Ages 3-5",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A10))),\"\")","v":"C20"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A10))),\"\")","v":"Not Qualified Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Not Qualified Special Education Paraprofessionals for Ages 3-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A10))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A10))),\"\")","v":"FS112"},0]
["FS112","Qualified + Not Qualified Special Education Paraprofessionals for Ages 6-21  ≠ Special Education Paraprofessionals for Ages 6-21",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A11))),\"\")","v":"D20"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A11))),\"\")","v":"Qualified Special Education Paraprofessionals for Ages 3-21  + Not Qualified Special Education Paraprofessionals for Ages 3-21 ≠ Total Special Education Paraprofessionals Serving Children with Disabilities Ages 3-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A11))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A11))),\"\")","v":"FS112"},0]
["FS112","Qualified Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Qualified Special Education Paraprofessionals for Ages 3-21",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A12))),\"\")","v":"D20"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A12))),\"\")","v":"Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Total Special Education Paraprofessionals Serving Children with Disabilities Ages 3-21"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A12))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A12))),\"\")","v":"FS112"},0]
["FS112","Not Qualified Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Not Qualified Special Education Paraprofessionals for Ages 3-21",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A13))),\"\")","v":"D24"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A13))),\"\")","v":"Fully Certified + Not Fully Certified Audiologists  ≠ Total Audiologists"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A13))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A13))),\"\")","v":"FS099"},0]
["FS112","Qualified Special Education Paraprofessionals for Ages 3-21  + Not Qualified Special Education Paraprofessionals for Ages 3-21 ≠ Total Special Education Paraprofessionals Serving Children with Disabilities Ages 3-21",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A14))),\"\")","v":"D25"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A14))),\"\")","v":"Fully Certified + Not Fully Certified Speech-Language Pathologists  ≠ Total Speech-Language Pathologists"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A14))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A14))),\"\")","v":"FS099"},0]
["FS112","Special Education Paraprofessionals for Ages 3-5 + Ages 6-21  ≠ Total Special Education Paraprofessionals Serving Children with Disabilities Ages 3-21",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A15))),\"\")","v":"D26"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A15))),\"\")","v":"Fully Certified + Not Fully Certified Interpreters  ≠ Total Interpreters"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A15))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A15))),\"\")","v":"FS099"},0]
["FS099","Fully Certified + Not Fully Certified Audiologists  ≠ Total Audiologists",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A16))),\"\")","v":"D27"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A16))),\"\")","v":"Fully Certified + Not Fully Certified Psychologists  ≠ Total Psychologists"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A16))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A16))),\"\")","v":"FS099"},0]
["FS099","Fully Certified + Not Fully Certified Speech-Language Pathologists  ≠ Total Speech-Language Pathologists",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A17))),\"\")","v":"D28"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A17))),\"\")","v":"Fully Certified + Not Fully Certified Occupational Therapists  ≠ Total Occupational Therapists"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A17))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A17))),\"\")","v":"FS099"},0]
["FS099","Fully Certified + Not Fully Certified Interpreters  ≠ Total Interpreters",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A18))),\"\")","v":"D29"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A18))),\"\")","v":"Fully Certified + Not Fully Certified Physical Therapists  ≠ Total Physical Therapists"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A18))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A18))),\"\")","v":"FS099"},0]
["FS099","Fully Certified + Not Fully Certified Psychologists  ≠ Total Psychologists",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A19))),\"\")","v":"D30"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A19))),\"\")","v":"Fully Certified + Not Fully Certified Physical Education and Recreation and Therapeutic Recreation Specialists  ≠ Total Physical Education and Recreation and Therapeutic Recreation Specialists"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A19))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A19))),\"\")","v":"FS099"},0]
["FS099","Fully Certified + Not Fully Certified Occupational Therapists  ≠ Total Occupational Therapists",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A20))),\"\")","v":"D31"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A20))),\"\")","v":"Fully Certified + Not Fully Certified Social Workers  ≠ Total Social Workers"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A20))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A20))),\"\")","v":"FS099"},0]
["FS099","Fully Certified + Not Fully Certified Physical Therapists  ≠ Total Physical Therapists",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A21))),\"\")","v":"D32"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A21))),\"\")","v":"Fully Certified + Not Fully Certified Medical/Nursing Service Staff  ≠ Total Medical/Nursing Service Staff"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A21))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A21))),\"\")","v":"FS099"},0]
["FS099","Fully Certified + Not Fully Certified Physical Education and Recreation and Therapeutic Recreation Specialists  ≠ Total Physical Education and Recreation and Therapeutic Recreation Specialists",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A22))),\"\")","v":"D33"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A22))),\"\")","v":"Fully Certified + Not Fully Certified Counselors and Rehabilitation Counselors  ≠ Total Counselors and Rehabilitation Counselors"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A22))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A22))),\"\")","v":"FS099"},0]
["FS099","Fully Certified + Not Fully Certified Social Workers  ≠ Total Social Workers",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A23))),\"\")","v":"D34"},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A23))),\"\")","v":"Fully Certified + Not Fully Certified Orientation and Mobility Specialists  ≠ Total Orientation and Mobility Specialists"},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A23))),\"\")","v":"MC"},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A23))),\"\")","v":"FS099"},0]
["FS099","Fully Certified + Not Fully Certified Medical/Nursing Service Staff  ≠ Total Medical/Nursing Service Staff",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A24))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A24))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A24))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A24))),\"\")","v":""},0]
["FS099","Fully Certified + Not Fully Certified Counselors and Rehabilitation Counselors  ≠ Total Counselors and Rehabilitation Counselors",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A25))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A25))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A25))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A25))),\"\")","v":""},0]
["FS099","Fully Certified + Not Fully Certified Orientation and Mobility Specialists  ≠ Total Orientation and Mobility Specialists",null,null,null,null,null,null,null,null,null,null,"MC",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A26))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A26))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A26))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A26))),\"\")","v":""},0]
["","",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A27))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A27))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A27))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A27))),\"\")","v":""},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dashboard!$I$11:$I$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A28))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$N$11:$N$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A28))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$K$11:$K$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A28))),\"\")","v":""},{"$f":"IFERROR(INDEX(Dashboard!$L$11:$L$37, SMALL(IF($U$8=Dashboard!$J$11:$J$37, ROW(Dashboard!$J$11:$J$37)-MIN(ROW(Dashboard!$J$11:$J$37))+1, \"\"), ROW(A28))),\"\")","v":""},0]
[]
[]
[]
[]
[]
[]
["NOTE: \"MC\" = Missing Category"]
[]
["End of worksheet"]

{"sheet":"Edit Check Details","index":6,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,37,4],[18,9,18,12],[24,9,24,12],[37,0,37,3],[9,0,9,3],[15,0,15,3],[21,0,21,3],[7,1,7,2],[6,1,6,2],[5,1,5,2],[4,1,4,2],[3,1,3,2],[2,1,2,3],[12,9,12,12]]}
[{"$f":"\"IDEA Personnel Data for School Year \"&'Special Ed Teachers (FS070)'!E11","v":"IDEA Personnel Data for School Year "},null,null,null,"End of worksheet"]
[]
[null,"Triggered Edit Checks"]
[null,"Data File",null,"Count"]
[null,"FS070 — Special Education Teachers (FTE)",null,{"$f":"SUM(Dashboard!J11:J16)","v":6}]
[null,"FS112 — Special Education Paraprofessionals ",null,{"$f":"SUM(Dashboard!J19:J24)","v":6}]
[null,"FS099 — Special Education Related Services Personnel ",null,{"$f":"SUM(Dashboard!J27:J37)","v":11}]
[null,"Total",null,{"$f":"SUM(D5:D7)","v":23}]
[null,null,null," "]
["FS070 — Special Education Teachers (FTE)"]
[null,"Fully Certified  \nFTE","Not Fully Certified  \nFTE","Total\nFTE",null,null,null,null,null,null,null,null,null,"Link","Triggered?"]
["Special Education Teachers for Ages 3-5",{"$f":"IFERROR(HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&ADDRESS(ROW(INDEX(CurrentListing,MATCH(F15,CurrentListing,0),1)),13),K15),HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&\"$O$10\",K15))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&ADDRESS(ROW(INDEX(CurrentListing,MATCH(G15,CurrentListing,0),1)),13),L15),HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&\"$O$10\",L15))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&ADDRESS(ROW(INDEX(CurrentListing,MATCH(H15,CurrentListing,0),1)),13),M15),HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&\"$O$10\",M15))","v":"MC"},null,null,null,null,null,null,null,null,null,"D14",{"$f":"IF(D12=\"\",0,IF(OR(D12=\"No Data\",SUM(B12:C12)<>D12),1,0))","v":1}]
["Special Education Teachers for Ages 6-21",{"$f":"IFERROR(HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&ADDRESS(ROW(INDEX(CurrentListing,MATCH(F16,CurrentListing,0),1)),13),K16),HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&\"$O$10\",K16))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&ADDRESS(ROW(INDEX(CurrentListing,MATCH(G16,CurrentListing,0),1)),13),L16),HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&\"$O$10\",L16))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&ADDRESS(ROW(INDEX(CurrentListing,MATCH(H16,CurrentListing,0),1)),13),M16),HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&\"$O$10\",M16))","v":"MC"},null,null,null,null,null,"SEA C070 - Special Education Teachers Serving Children with Disabilities",null,null,null,"D15",{"$f":"IF(D13=\"\",0,IF(OR(D13=\"No Data\",SUM(B13:C13)<>D13),1,0))","v":1}]
["Total",{"$f":"IFERROR(HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&ADDRESS(ROW(INDEX(CurrentListing,MATCH(F17,CurrentListing,0),1)),13),K17),HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&\"$O$10\",K17))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&ADDRESS(ROW(INDEX(CurrentListing,MATCH(G17,CurrentListing,0),1)),13),L17),HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&\"$O$10\",L17))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&ADDRESS(ROW(INDEX(CurrentListing,MATCH(H17,CurrentListing,0),1)),13),M17),HYPERLINK(\"#'Special Ed Teachers (FS070)'!\"&\"$O$10\",M17))","v":"MC"},null,null,null,null,null,null,"Fully Certified \nFTE","Not Fully Certified  \nFTE","Total\nFTE","B16",{"$f":"IF(B14=\"\",0,IF(OR(B14=\"No Data\",SUM(B12:B13)<>B14),1,0))","v":1}]
[null,null,null,null,null,"SPEDTCHFULCRT3TO5N","SPEDTCHNFULCRT3TO5N","3TO5Y",null,"Special Education Teachers for Ages 3-5",{"$f":"IFERROR(IF(INDEX(FTE_FS070,MATCH(F15,CurrentListing,0))=\"\",\"No Data\",INDEX(FTE_FS070,MATCH(F15,CurrentListing,0))),\"MC\")","v":"MC"},{"$f":"IFERROR(IF(INDEX(FTE_FS070,MATCH(G15,CurrentListing,0))=\"\",\"No Data\",INDEX(FTE_FS070,MATCH(G15,CurrentListing,0))),\"MC\")","v":"MC"},"MC","C16",{"$f":"IF(C14=\"\",0,IF(OR(C14=\"No Data\",SUM(C12:C13)<>C14),1,0))","v":1}]
["FS112 — Special Education Paraprofessionals ",null,null,null,null,"SPEDTCHFULCRT6TO21N","SPEDTCHNFULCRT6TO21N","6TO21Y",null,"Special Education Teachers for Ages 6-21","MC","MC","MC","D16",{"$f":"IF(D14=\"\",0,IF(OR(D14=\"No Data\",SUM(D12:D13)<>D14),1,0))","v":1}]
[null,"Qualified \nFTE","Not Qualified\nFTE","Total\nFTE",null,"SPEDTCHFULCRTY","SPEDTCHNFULCRTY","Y",null,"Total","MC","MC","MC","D16",{"$f":"IF(D14=\"\",0,IF(OR(D14=\"No Data\",SUM(B14:C14)<>D14),1,0))","v":1}]
["Special Education Paraprofessionals for Ages 3-5",{"$f":"IFERROR(HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C112,MATCH(F21,CurrentListing_C112,0),1)),13),K21),HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&\"$O$10\",K21))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C112,MATCH(G21,CurrentListing_C112,0),1)),13),L21),HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&\"$O$10\",L21))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C112,MATCH(H21,CurrentListing_C112,0),1)),13),M21),HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&\"$O$10\",M21))","v":"MC"},null,null,null,null,null,null,null,null,null,"D20",{"$f":"IF(D18=\"\",0,IF(OR(D18=\"No Data\",SUM(B18:C18)<>D18),1,0))","v":1}]
["Special Education Paraprofessionals for Ages 6-21",{"$f":"IFERROR(HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C112,MATCH(F22,CurrentListing_C112,0),1)),13),K22),HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&\"$O$10\",K22))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C112,MATCH(G22,CurrentListing_C112,0),1)),13),L22),HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&\"$O$10\",L22))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C112,MATCH(H22,CurrentListing_C112,0),1)),13),M22),HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&\"$O$10\",M22))","v":"MC"},null,null,null,null,null,"SEA C112 - Special Education Paraprofessionals Serving Children with Disabilities",null,null,null,"D21",{"$f":"IF(D19=\"\",0,IF(OR(D19=\"No Data\",SUM(B19:C19)<>D19),1,0))","v":1}]
["Total",{"$f":"IFERROR(HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C112,MATCH(F23,CurrentListing_C112,0),1)),13),K23),HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&\"$O$10\",K23))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C112,MATCH(G23,CurrentListing_C112,0),1)),13),L23),HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&\"$O$10\",L23))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C112,MATCH(H23,CurrentListing_C112,0),1)),13),M23),HYPERLINK(\"#'Sp Ed Paraprofessionals (FS112)'!\"&\"$O$10\",M23))","v":"MC"},null,null,null,null,null,null,"Qualified \nFTE","Not Qualified\nFTE","Total\nFTE","B22",{"$f":"IF(B20=\"\",0,IF(OR(B20=\"No Data\",SUM(B18:B19)<>B20),1,0))","v":1}]
[null,null,null,null,null,"3TO5QN","3TO5NQN","3TO5Y",null,"Special Education Paraprofessionals for Ages 3-5",{"$f":"IFERROR(IF(INDEX(FTE_FS112,MATCH(F21,CurrentListing_C112,0))=\"\",\"No Data\",INDEX(FTE_FS112,MATCH(F21,CurrentListing_C112,0))),\"MC\")","v":"MC"},{"$f":"IFERROR(IF(INDEX(FTE_FS112,MATCH(G21,CurrentListing_C112,0))=\"\",\"No Data\",INDEX(FTE_FS112,MATCH(G21,CurrentListing_C112,0))),\"MC\")","v":"MC"},{"$f":"IFERROR(IF(INDEX(FTE_FS112,MATCH(H21,CurrentListing_C112,0))=\"\",\"No Data\",INDEX(FTE_FS112,MATCH(H21,CurrentListing_C112,0))),\"MC\")","v":"MC"},"C22",{"$f":"IF(C20=\"\",0,IF(OR(C20=\"No Data\",SUM(C18:C19)<>C20),1,0))","v":1}]
["FS099 — Special Education Related Services Personnel ",null,null,null,null,"6TO21QN","6TO21NQN","6TO21Y",null,"Special Education Paraprofessionals for Ages 6-21","MC","MC","MC","D22",{"$f":"IF(D20=\"\",0,IF(OR(D20=\"No Data\",SUM(D18:D19)<>D20),1,0))","v":1}]
[null,"Fully Certified\nFTE","Not Fully Certified \nFTE","Total\nFTE",null,"QY","NQY","Y",null,"Total","MC","MC","MC","D22",{"$f":"IF(D20=\"\",0,IF(OR(D20=\"No Data\",SUM(B20:C20)<>D20),1,0))","v":1}]
["Audiologists",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_FS099,MATCH(F27,CurrentListing_FS099,0),1)),12),K27),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K27))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G27,CurrentListing_C099,0),1)),12),L27),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L27))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H27,CurrentListing_C099,0),1)),12),M27),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M27))","v":"MC"}]
["Speech-Language Pathologists",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F28,CurrentListing_C099,0),1)),12),K28),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K28))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G28,CurrentListing_C099,0),1)),12),L28),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L28))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H28,CurrentListing_C099,0),1)),12),M28),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M28))","v":"MC"},null,null,null,null,null,"SEA C099 - Related Services Personnel Serving Children with Disabilities Ages 3-21"]
["Interpreters",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F29,CurrentListing_C099,0),1)),12),K29),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K29))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G29,CurrentListing_C099,0),1)),12),L29),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L29))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H29,CurrentListing_C099,0),1)),12),M29),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M29))","v":"MC"},null,null,null,null,null,null,"Fully\nCertified\nFTE","Not Fully\nCertified\nFTE","Total\nFTE"]
["Psychologists",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F30,CurrentListing_C099,0),1)),12),K30),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K30))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G30,CurrentListing_C099,0),1)),12),L30),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L30))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H30,CurrentListing_C099,0),1)),12),M30),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M30))","v":"MC"},null,"AUDIOFCN","AUDIONFCN","AUDIOY",null,"Audiologists",{"$f":"IFERROR(IF(INDEX(FTE_FS099,MATCH(F27,CurrentListing_C099,0))=\"\",\"No Data\",INDEX(FTE_FS099,MATCH(F27,CurrentListing_C099,0))),\"MC\")","v":"MC"},{"$f":"IFERROR(IF(INDEX(FTE_FS099,MATCH(G27,CurrentListing_C099,0))=\"\",\"No Data\",INDEX(FTE_FS099,MATCH(G27,CurrentListing_C099,0))),\"MC\")","v":"MC"},{"$f":"IFERROR(IF(INDEX(FTE_FS099,MATCH(H27,CurrentListing_C099,0))=\"\",\"No Data\",INDEX(FTE_FS099,MATCH(H27,CurrentListing_C099,0))),\"MC\")","v":"MC"},"D26",{"$f":"IF(D24=\"\",0,IF(OR(D24=\"No Data\",SUM(B24:C24)<>D24),1,0))","v":1}]
["Occupational Therapists",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F31,CurrentListing_C099,0),1)),12),K31),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K31))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G31,CurrentListing_C099,0),1)),12),L31),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L31))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H31,CurrentListing_C099,0),1)),12),M31),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M31))","v":"MC"},null,"SPEECHPATHFCN","SPEECHPATHNFCN","SPEECHPATHY",null,"Speech-Language Pathologists","MC","MC","MC","D27",1]
["Physical Therapists",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F32,CurrentListing_C099,0),1)),12),K32),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K32))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G32,CurrentListing_C099,0),1)),12),L32),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L32))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H32,CurrentListing_C099,0),1)),12),M32),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M32))","v":"MC"},null,"INTERPRETFCN","INTERPRETNFCN","INTERPRETY",null,"Interpreters","MC","MC","MC","D28",1]
["Physical Education and Recreation and Therapeutic Recreation Specialists",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F33,CurrentListing_C099,0),1)),12),K33),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K33))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G33,CurrentListing_C099,0),1)),12),L33),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L33))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H33,CurrentListing_C099,0),1)),12),M33),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M33))","v":"MC"},null,"PSYCHFCN","PSYCHNFCN","PSYCHY",null,"Psychologists","MC","MC","MC","D29",1]
["Social Workers",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F34,CurrentListing_C099,0),1)),12),K34),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K34))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G34,CurrentListing_C099,0),1)),12),L34),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L34))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H34,CurrentListing_C099,0),1)),12),M34),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M34))","v":"MC"},null,"OCCTHERAPFCN","OCCTHERAPNFCN","OCCTHERAPY",null,"Occupational Therapists","MC","MC","MC","D30",1]
["Medical/Nursing Service Staff",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F35,CurrentListing_C099,0),1)),12),K35),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K35))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G35,CurrentListing_C099,0),1)),12),L35),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L35))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H35,CurrentListing_C099,0),1)),12),M35),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M35))","v":"MC"},null,"PHYSTHERAPFCN","PHYSTHERAPNFCN","PHYSTHERAPY",null,"Physical Therapists","MC","MC","MC","D31",1]
["Counselors and Rehabilitation Counselors",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F36,CurrentListing_C099,0),1)),12),K36),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K36))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G36,CurrentListing_C099,0),1)),12),L36),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L36))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H36,CurrentListing_C099,0),1)),12),M36),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M36))","v":"MC"},null,"PEANDRECFCN","PEANDRECNFCN","PEANDRECY",null,"Physical Education and Recreation and Therapeutic Recreation Specialists","MC","MC","MC","D32",1]
["Orientation and Mobility Specialists",{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(F37,CurrentListing_C099,0),1)),12),K37),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",K37))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(G37,CurrentListing_C099,0),1)),12),L37),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",L37))","v":"MC"},{"$f":"IFERROR(HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(H37,CurrentListing_C099,0),1)),12),M37),HYPERLINK(\"#'Related Services Pers. (FS099)'!\"&\"$N$10\",M37))","v":"MC"},null,"SOCIALWORKFCN","SOCIALWORKNFCN","SOCIALWORKY",null,"Social Workers","MC","MC","MC","D33",1]
[null,null,null,null,null,"MEDNURSEFCN","MEDNURSENFCN","MEDNURSEY",null,"Medical/Nursing Service Staff","MC","MC","MC","D34",1]
["NOTE: \"MC\" = Missing Category",null,null,null,null,"COUNSELORFCN","COUNSELORNFCN","COUNSELORY",null,"Counselors and Rehabilitation Counselors","MC","MC","MC","D35",1]
[null,null,null,null,null,"ORIENTMOBILFCN","ORIENTMOBILNFCN","ORIENTMOBILY",null,"Orientation and Mobility Specialists","MC","MC","MC","D36",1]
["End of worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"=HYPERLINK(\"#'Related Services Pers. (C099)'!\"&ADDRESS(ROW(INDEX(CurrentListing_C099,MATCH(I28,MasterListing_C099,0),1)),17),N28)"]