{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Main Menu","IDEA Data","Comparison Data","Discipline Data","All Disabilities","Composition 2","Composition","Risk","TRPC","Work","Work 2","Work Discipline","Likelihood","dummy","Help"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":38,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main Menu","index":0,"n_rows":171,"n_cols":5,"rows_kept":171,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
["Description of Data"]
[]
["Children with Disabilities:",null,null,"Comparison Group:"]
[]
["Type of IDEA Data:","Select IDEA Data Type",null,"Type of Comparison Data:","Select Comparison Data Type"]
[null,null,null,"If Other, describe:",""]
["IDEA Data Category:","Select IDEA Data Category"]
["If Other, describe:","",null,"Grade/Age Range:",""]
[null,null,null,"Comparison Data Year:"]
["Age Range:",""]
["Data Collection Year:",null,null,"Are state totals included?","No - last row is not state total"]
[]
["Are state totals included?","No - last row is not state total"]
[]
["Race/Ethnicity:","5 Categories"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Parameters:"]
[]
[]
[]
[]
["Input Type","Child Count"]
[null,"Environment"]
[null,"Discipline"]
[null,"Other"]
[]
[]
["Disability","All Disabilities"]
[null,"Autism"]
[null,"Deaf-Blindness"]
[null,"Developmental Delay"]
[null,"Emotional Disturbance"]
[null,"Hearing Impairments"]
[null,"Intellectual Disabilities"]
[null,"Multiple Disabilities"]
[null,"Orthopedic Impairments"]
[null,"Other Health Impairments"]
[null,"Specific Learning Disabilities"]
[null,"Speech or Language Impairments"]
[null,"Traumatic Brain Injury"]
[null,"Visual Impairments"]
[null,"Other"]
[]
["Environments","Total"]
[null,"Inside regular class 80 percent or more of the day"]
[null,"Inside regular class no more than 79% of day and no less than 40% percent of the day"]
[null,"Inside regular class less than 40 percent of the day "]
[null,"Separate school"]
[null,"Residential facility"]
[null,"Homebound/hospital"]
[null,"Correctional facility"]
[null,"Parentally placed in private schools"]
[null,"Other"]
[]
["Discipline","Out-of-school suspensions/expulsions totaling 10 days or less"]
[null,"Out-of-school suspensions/expulsions totaling > 10 days"]
[null,"In-school suspensions totaling 10 days or less"]
[null,"In-school suspensions totaling > 10 days"]
[null,"Total disciplinary removals"]
[null,"Other"]
[]
["Total Disciplinary Removals","Total-Removals"]
[null,"Other"]
[]
["Race/Ethnicity","5 Categories"]
[null,"7 Categories"]
[null,"Other"]
[]
["Population Type","Enrollment"]
[null,"Total Child Count"]
[null,"Other"]
[]
[]
["Totals","Yes - last row is state total"]
[null,"No - last row is not state total"]
[null,"Yes - last rows are state totals"]
[null,"No - last rows are not state totals"]
[]
["Decimals",0]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
["Flags:"]
["All Disabilities Run?","No"]
["All Disabilities - Age",""]
["All Disabilities - Year"]
["All Disabilities - Pop Type","Enrollment"]
["Include Total?","N"]
["Run?","Y"]
["Unique Discipline Types","OSS>10"]
[null,"1"]
[null,"2"]
[null,"c"]
[null,"c"]
[null,"e"]
[null,"d"]
[null,"zz"]
["Previous Run","Discipline"]

{"sheet":"IDEA Data","index":1,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
[{"$f":"\"IDEA Data: \" &IF(input_type<>\"Other\",input_type & \" - \" & IF(input_desc=\"Other\",input_other,input_desc),IF(TRIM(input_other)<>\"\",input_other,\"Other\")) &IF(TRIM(input_age)<>\"\",\" for \"&input_age,\"\")","v":"IDEA Data: Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"IF(TRIM(input_year)<>\"\",\"in \"&input_year&\" \",\"\")&\"by Race/Ethnicity\"","v":"by Race/Ethnicity"}]
["ID","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)"]

{"sheet":"Comparison Data","index":2,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
[{"$f":"\"Comparison Data: \"&IF(pop_type<>\"Other\",pop_type,IF(TRIM(pop_other)<>\"\",pop_other,\"Other\"))&IF(TRIM(pop_age)<>\"\",\" for \"&pop_age,\"\")","v":"Comparison Data: Select Comparison Data Type"}]
[{"$f":"IF(TRIM(pop_year)<>\"\",\"in \"&pop_year&\" \",\"\")&\"by Race/Ethnicity\"","v":"by Race/Ethnicity"}]
["ID",{"$f":"IF('IDEA Data'!B3=\"Race/Ethnicity 1\",\"\",'IDEA Data'!B3)","v":"American Indian or Alaska Native"},{"$f":"IF('IDEA Data'!C3=\"Race/Ethnicity 2\",\"\",'IDEA Data'!C3)","v":"Asian or Other Pacific Islander"},{"$f":"IF('IDEA Data'!D3=\"Race/Ethnicity 3\",\"\",'IDEA Data'!D3)","v":"Black (not Hispanic)"},{"$f":"IF('IDEA Data'!E3=\"Race/Ethnicity 4\",\"\",'IDEA Data'!E3)","v":"Hispanic"},{"$f":" IF('IDEA Data'!F3=\"\",\"\",'IDEA Data'!F3)","v":"White (not Hispanic)"}]

{"sheet":"Discipline Data","index":3,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8]]}
[{"$f":"\"Discipline Data: \" &IF(input_type<>\"Other\",input_type & \" - \" & IF(input_desc=\"Other\",input_other,input_desc),IF(TRIM(input_other)<>\"\",input_other,\"Other\")) &IF(TRIM(input_age)<>\"\",\" for \"&input_age,\"\")","v":"Discipline Data: Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"IF(TRIM(input_year)<>\"\",\"in \"&input_year&\" \",\"\")&\"by Race/Ethnicity\"","v":"by Race/Ethnicity"}]
["ID","Discipline Type","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)"]

{"sheet":"All Disabilities","index":4,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
[{"$f":"\"IDEA Data: Child Count - All Disabilities\"","v":"IDEA Data: Child Count - All Disabilities"}]
[{"$f":"IF(TRIM(input_year)<>\"\",\"in \"&input_year&\" \",\"\")&\"by Race/Ethnicity\"","v":"by Race/Ethnicity"}]
["ID","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)"]

{"sheet":"Composition 2","index":5,"n_rows":7,"n_cols":22,"rows_kept":7,"cut":false,"hidden":true,"merged":[[5,1,5,7],[5,8,5,14],[5,15,5,21],[0,0,0,21],[1,0,1,21],[2,0,2,21],[3,0,3,21]]}
[{"$f":"\"Composition\"","v":"Composition"}]
[{"$f":"IF(input_type<>\"Other\",input_type & \" - \" & input_desc,IF(TRIM(input_other)<>\"\",input_other,\"Other\")) &IF(TRIM(input_age)<>\"\",\" for \"&input_age,\"\")&IF(TRIM(input_year)<>\"\",\" in \"&input_year&\" \",\"\")","v":"Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"\"Child Count: \" & all_dis_age & \" for \" & all_dis_year","v":"Child Count:  for "}]
["0 Districts"]
[]
[null,"IDEA Data: Environment - Inside regular class 80 percent or more of the day",null,null,null,null,null,null,"Child Count - All Disabilities",null,null,null,null,null,null,"Relative Difference in Composition"]
["ID","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races"]

{"sheet":"Composition","index":6,"n_rows":7,"n_cols":31,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,16,5,20],[5,21,5,25],[5,26,5,30],[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[5,1,5,5],[5,6,5,10],[5,11,5,15]]}
[{"$f":"\"Composition\"","v":"Composition"}]
[{"$f":"IF(input_type<>\"Other\",input_type & \" - \" & IF(input_desc=\"Other\",input_other,input_desc),IF(TRIM(input_other)<>\"\",input_other,\"Other\")) &IF(TRIM(input_age)<>\"\",\" for \"&input_age,\"\")&IF(TRIM(input_year)<>\"\",\" in \"&input_year&\" \",\"\")","v":"Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"IF(pop_type<>\"Other\",pop_type,IF(TRIM(pop_other)<>\"\",pop_other,\"Other\"))&IF(TRIM(pop_age)<>\"\",\" for \"&pop_age,\"\")&IF(TRIM(pop_year)<>\"\",\" in \"&pop_year,\"\")","v":"Select Comparison Data Type"}]
["0 Districts"]
[]
[null,"Composition",null,null,null,null,"Comparison Composition",null,null,null,null,"Difference in Composition",null,null,null,null,"Relative Difference in Composition ",null,null,null,null,"E-Formula for Overrepresentation",null,null,null,null,"E-Formula for Underrepresentation"]
["ID","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)"]

{"sheet":"Risk","index":7,"n_rows":7,"n_cols":26,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,11,5,15],[5,16,5,20],[5,21,5,25],[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[5,1,5,5],[5,6,5,10]]}
["Risk"]
[{"$f":"Composition!A2","v":"Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"Composition!A3","v":"Select Comparison Data Type"}]
["0 Districts"]
[]
[null,"Risk",null,null,null,null,"Risk Ratio",null,null,null,null,"Weighted Risk Ratio",null,null,null,null,"Alternate Risk Ratio",null,null,null,null,"Risk Difference"]
["ID","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)"]

{"sheet":"TRPC","index":8,"n_rows":7,"n_cols":36,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,0,0,21],[1,0,1,21],[2,0,2,21],[3,0,3,21],[5,29,5,35],[5,22,5,28],[5,1,5,7],[5,8,5,14],[5,15,5,21]]}
["Total Removals Per Child (TRPC) Ratios"]
[{"$f":"Composition!A2","v":"Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"Composition!A3","v":"Select Comparison Data Type"}]
["8 Districts"]
[]
[null,"Total Removals Per Child (TRPC)",null,null,null,null,null,null,"TRPC Ratio",null,null,null,null,null,null,"Weighted TRPC Ratio",null,null,null,null,null,null,"Alternate TRPC Ratio",null,null,null,null,null,null,"TRPC Difference"]
["ID","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races"]

{"sheet":"Work","index":9,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,6,0,10],[1,1,1,5],[1,6,1,10],[1,11,1,12]]}
[null,{"$f":"'IDEA Data'!A1","v":"IDEA Data: Select IDEA Data Type - Select IDEA Data Category"},null,null,null,null,{"$f":"'Comparison Data'!A1","v":"Comparison Data: Select Comparison Data Type"}]
[null,"by Race/Ethnicity",null,null,null,null,"by Race/Ethnicity",null,null,null,null,"Sum of Race/Ethnicity"]
["ID","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)",{"$f":"\"Total: \"&input_type","v":"Total: Select IDEA Data Type"},{"$f":"\"Total: \"&pop_type","v":"Total: Select Comparison Data Type"}]

{"sheet":"Work 2","index":10,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":true,"merged":[[1,15,1,16],[0,1,0,7],[1,1,1,7],[0,8,0,14],[1,8,1,14]]}
[null,"IDEA Data: Environment - Inside regular class 80 percent or more of the day",null,null,null,null,null,null,"Child Count - All Disabilities"]
[null,"by Race/Ethnicity",null,null,null,null,null,null,"by Race/Ethnicity",null,null,null,null,null,null,"Sum of Race/Ethnicity"]
["ID","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Total: Environment","Total: Child Count"]

{"sheet":"Work Discipline","index":11,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":true,"merged":[[1,17,1,18],[0,3,0,9],[1,3,1,9],[0,10,0,16],[1,10,1,16]]}
[null,null,null,"Discipline Data: Discipline - Multiple Categories for 5-21",null,null,null,null,null,null,"Child Count - All Disabilities"]
[null,null,null,"in 0910 by Race/Ethnicity",null,null,null,null,null,null,"in 0910 by Race/Ethnicity",null,null,null,null,null,null,"Sum of Race/Ethnicity"]
["ID","Discipline Type","Number of Discipline Categories","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Total: Discipline","Total: Child Count - All Disabilities"]

{"sheet":"Likelihood","index":12,"n_rows":6,"n_cols":23,"rows_kept":6,"cut":false,"hidden":true,"merged":[[4,15,4,16],[4,21,4,22],[4,17,4,18],[4,19,4,20],[0,0,0,16],[1,0,1,16],[2,0,2,16],[3,0,3,16],[4,7,4,8],[4,3,4,4],[4,5,4,6],[4,11,4,12],[4,9,4,10],[4,13,4,14]]}
["Likelihood"]
[{"$f":"IF(input_type<>\"Other\",input_type & \" - \" & IF(input_desc=\"Other\",input_other,input_desc),IF(TRIM(input_other)<>\"\",input_other,\"Other\")) &IF(TRIM(input_age)<>\"\",\" for \"&input_age,\"\")","v":"Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"\"vs \" & pop_type","v":"vs Select Comparison Data Type"}]
["0 Districts"]
[null,null,null,{"$f":"IF('Discipline Data'!C3=\"\",\"\",'Discipline Data'!C3)","v":"American Indian or Alaska Native"},null,{"$f":"IF('Discipline Data'!D3=\"\",\"\",'Discipline Data'!D3)","v":"Asian or Other Pacific Islander"},null,{"$f":"IF('Discipline Data'!E3=\"\",\"\",'Discipline Data'!E3)","v":"Black (not Hispanic)"},null,{"$f":"IF('Discipline Data'!F3=\"\",\"\",'Discipline Data'!F3)","v":"Hispanic"},null,{"$f":"IF('Discipline Data'!G3=\"\",\"\",'Discipline Data'!G3)","v":"White (not Hispanic)"},null,{"$f":"IF('Discipline Data'!H3=\"\",\"\",'Discipline Data'!H3)","v":""},null,{"$f":"IF('Discipline Data'!I3=\"\",\"\",'Discipline Data'!I3)","v":""},null,{"$f":"IF('Discipline Data'!J3=\"\",\"\",'Discipline Data'!J3)","v":""},null,{"$f":"IF('Discipline Data'!K3=\"\",\"\",'Discipline Data'!K3)","v":""},null,{"$f":"IF('Discipline Data'!L3=\"\",\"\",'Discipline Data'!L3)","v":""}]
["ID","Discipline Type","Overall Likelihood",{"$f":"IF(D5<>\"\",\"Rate\",\"\")","v":"Rate"},{"$f":"IF(D5<>\"\",\"Binomial     likelihood\",\"\")","v":"Binomial     likelihood"},{"$f":"IF(F5<>\"\",\"Rate\",\"\")","v":"Rate"},{"$f":"IF(F5<>\"\",\"Binomial     likelihood\",\"\")","v":"Binomial     likelihood"},{"$f":"IF(H5<>\"\",\"Rate\",\"\")","v":"Rate"},{"$f":"IF(H5<>\"\",\"Binomial     likelihood\",\"\")","v":"Binomial     likelihood"},{"$f":"IF(J5<>\"\",\"Rate\",\"\")","v":"Rate"},{"$f":"IF(J5<>\"\",\"Binomial     likelihood\",\"\")","v":"Binomial     likelihood"},{"$f":"IF(L5<>\"\",\"Rate\",\"\")","v":"Rate"},{"$f":"IF(L5<>\"\",\"Binomial     likelihood\",\"\")","v":"Binomial     likelihood"},{"$f":"IF(N5<>\"\",\"Rate\",\"\")","v":""},{"$f":"IF(N5<>\"\",\"Binomial LikeliHood\",\"\")","v":""},{"$f":"IF(P5<>\"\",\"Rate\",\"\")","v":""},{"$f":"IF(P5<>\"\",\"Binomial     likelihood\",\"\")","v":""},{"$f":"IF(R5<>\"\",\"Rate\",\"\")","v":""},{"$f":"IF(R5<>\"\",\"Binomial     likelihood\",\"\")","v":""},{"$f":"IF(T5<>\"\",\"Rate\",\"\")","v":""},{"$f":"IF(T5<>\"\",\"Binomial     likelihood\",\"\")","v":""},{"$f":"IF(V5<>\"\",\"Rate\",\"\")","v":""},{"$f":"IF(V5<>\"\",\"Binomial     likelihood\",\"\")","v":""}]

{"sheet":"dummy","index":13,"n_rows":57,"n_cols":36,"rows_kept":57,"cut":false,"hidden":true,"merged":[[48,0,48,5],[49,0,49,5],[54,0,54,5],[55,0,55,5],[40,0,40,21],[42,1,42,7],[42,8,42,14],[42,15,42,21],[42,29,42,35],[32,1,32,5],[32,6,32,10],[32,11,32,12],[37,0,37,21],[38,0,38,21],[39,0,39,21],[24,16,24,20],[24,21,24,25],[31,1,31,5],[31,6,31,10],[42,22,42,28],[21,0,21,15],[22,0,22,15],[24,1,24,5],[24,6,24,10],[24,11,24,15],[13,16,13,20],[13,21,13,25],[13,26,13,30],[19,0,19,15],[20,0,20,15],[9,0,9,15],[10,0,10,15],[11,0,11,15],[13,1,13,5],[13,6,13,10],[13,11,13,15],[0,0,0,5],[1,0,1,5],[4,0,4,5],[5,0,5,5],[8,0,8,15]]}
[{"$f":"\"IDEA Data: \" &IF(input_type<>\"Other\",input_type & \" - \" & IF(input_desc=\"Other\",input_other,input_desc),IF(TRIM(input_other)<>\"\",input_other,\"Other\")) &IF(TRIM(input_age)<>\"\",\" for \"&input_age,\"\")","v":"IDEA Data: Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"IF(TRIM(input_year)<>\"\",\"in \"&input_year&\" \",\"\")&\"by Race/Ethnicity\"","v":"by Race/Ethnicity"}]
["ID","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)"]
[]
[{"$f":"\"Comparison Data: \"&IF(pop_type<>\"Other\",pop_type,IF(TRIM(pop_other)<>\"\",pop_other,\"Other\"))&IF(TRIM(pop_age)<>\"\",\" for \"&pop_age,\"\")","v":"Comparison Data: Select Comparison Data Type"}]
[{"$f":"IF(TRIM(pop_year)<>\"\",\"in \"&pop_year&\" \",\"\")&\"by Race/Ethnicity\"","v":"by Race/Ethnicity"}]
["ID",{"$f":"IF('IDEA Data'!B7=\"Race/Ethnicity 1\",\"\",'IDEA Data'!B7)","v":0},{"$f":"IF('IDEA Data'!C7=\"Race/Ethnicity 2\",\"\",'IDEA Data'!C7)","v":0},{"$f":"IF('IDEA Data'!D7=\"Race/Ethnicity 3\",\"\",'IDEA Data'!D7)","v":0},{"$f":"IF('IDEA Data'!E7=\"Race/Ethnicity 4\",\"\",'IDEA Data'!E7)","v":0},{"$f":" IF('IDEA Data'!F7=\"\",\"\",'IDEA Data'!F7)","v":""}]
[]
[{"$f":"\"Composition\"","v":"Composition"}]
[{"$f":"IF(input_type<>\"Other\",input_type & \" - \" & IF(input_desc=\"Other\",input_other,input_desc),IF(TRIM(input_other)<>\"\",input_other,\"Other\")) &IF(TRIM(input_age)<>\"\",\" for \"&input_age,\"\")&IF(TRIM(input_year)<>\"\",\" in \"&input_year&\" \",\"\")","v":"Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"IF(pop_type<>\"Other\",pop_type,IF(TRIM(pop_other)<>\"\",pop_other,\"Other\"))&IF(TRIM(pop_age)<>\"\",\" for \"&pop_age,\"\")&IF(TRIM(pop_year)<>\"\",\" in \"&pop_year,\"\")","v":"Select Comparison Data Type"}]
["0 Districts"]
[]
[null,"Composition",null,null,null,null,"Comparison Composition",null,null,null,null,"Difference in Composition",null,null,null,null,"Relative Difference in Composition ",null,null,null,null,"E-Formula for Overrepresentation",null,null,null,null,"E-Formula for Underrepresentation"]
["ID","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)"]
[]
[]
[]
[]
["Risk"]
[{"$f":"Composition!A21","v":0}]
[{"$f":"Composition!A22","v":0}]
["0 Districts"]
[]
[null,"Risk",null,null,null,null,"Risk Ratio",null,null,null,null,"Weighted Risk Ratio",null,null,null,null,"Alternate Risk Ratio",null,null,null,null,"Risk Difference"]
["ID","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)"]
[]
[]
[]
[]
[]
[null,{"$f":"'IDEA Data'!A32","v":0},null,null,null,null,{"$f":"'Comparison Data'!A32","v":0}]
[null,"by Race/Ethnicity",null,null,null,null,"by Race/Ethnicity",null,null,null,null,"Sum of Race/Ethnicity"]
["ID","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)","American Indian or Alaska Native","Asian or Other Pacific Islander","Black (not Hispanic)","Hispanic","White (not Hispanic)",{"$f":"\"Total: \"&input_type","v":"Total: Select IDEA Data Type"},{"$f":"\"Total: \"&pop_type","v":"Total: Select Comparison Data Type"}]
[]
[]
[]
["Total Removals Per Child (TRPC) Ratios"]
[{"$f":"Composition!A39","v":0}]
[{"$f":"Composition!A40","v":0}]
["8 Districts"]
[]
[null,"Total Removals Per Child (TRPC)",null,null,null,null,null,null,"TRPC Ratio",null,null,null,null,null,null,"Weighted TRPC Ratio",null,null,null,null,null,null,"Alternate TRPC Ratio",null,null,null,null,null,null,"TRPC Difference"]
["ID","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races"]
[]
[]
[]
[]
[{"$f":"\"IDEA Data: \" &IF(input_type<>\"Other\",input_type & \" - \" & IF(input_desc=\"Other\",input_other,input_desc),IF(TRIM(input_other)<>\"\",input_other,\"Other\")) &IF(TRIM(input_age)<>\"\",\" for \"&input_age,\"\")","v":"IDEA Data: Select IDEA Data Type - Select IDEA Data Category"}]
[{"$f":"IF(TRIM(input_year)<>\"\",\"in \"&input_year&\" \",\"\")&\"by Race/Ethnicity\"","v":"by Race/Ethnicity"}]
["ID","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races"]
[]
[]
[]
[{"$f":"\"Comparison Data: \"&IF(pop_type<>\"Other\",pop_type,IF(TRIM(pop_other)<>\"\",pop_other,\"Other\"))&IF(TRIM(pop_age)<>\"\",\" for \"&pop_age,\"\")","v":"Comparison Data: Select Comparison Data Type"}]
[{"$f":"IF(TRIM(pop_year)<>\"\",\"in \"&pop_year&\" \",\"\")&\"by Race/Ethnicity\"","v":"by Race/Ethnicity"}]
["ID","Hispanic / Latino","American Indian or Alaska Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Two or More Races"]

{"sheet":"Help","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}