{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Notes","Achievement","Progress","Gap Closing","Graduation","Overall"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":22,"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":"Notes","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["These component simulations were created by the Office of Accountability for the 2024-2025 Report Card. If you have any questions or would like to report an error, then please contact us at Accountability@education.ohio.gov. The sheets are all protected, but if you wish to make changes you can unlock them by going to \"Review\" and clicking \"Unprotect Sheet.\" There is no password. "]
[]
["Update Notes","Date"]
["Calculator created","2024-11-06"]
["Checked calculations and updated data notes","2025-03-03"]
["Further updated data notes, fixed gap closing improvement points, set protection for cells, added in technical documents","2025-03-26"]
["Fixed protection problems, fixed gap closing rating ","2025-03-27"]
["Added overall rating grade scale","2025-04-02"]
["Cosmetic changes, adjusted gap closing improvement points to account for meeting exact 2030 goal","2025-04-09"]

{"sheet":"Achievement","index":1,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,5],[16,9,17,13],[16,14,17,14],[14,5,15,6],[10,1,10,2],[4,0,4,3],[4,4,4,7],[4,8,4,15],[6,9,6,11],[9,0,9,3],[11,0,12,3],[8,11,9,11],[13,0,13,3],[8,5,8,6],[9,5,9,6],[8,9,9,9],[8,0,8,3],[8,12,9,12],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,12,11,12],[8,10,9,10]]}
["How To Use This Simulator:"]
["Input the number of students passing the required tests and the number of students who are in grade 12 at any time during the school year and the number of additional students who reach age 21 years and 9 months prior to June 30."]
[]
[]
["High School Test Passage Rate",null,null,null,"Overall Percentage",null,null,null,"Achievement Component Rating"]
[]
[null,null,null,null,null,null,null,null,null,"Score Range",null,null,"Rating"]
[null,null,null,null,null,null,null,null,null,0,"to",0.32,"Does Not Meet Standards"]
["# of Students Passing Required Tests",null,null,null,null,"Passage Rate",null,null,null,0.32,"to",0.68,"Meets Standards"]
[null,null,null,null,null,{"$f":"IFERROR(A10/A14, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,0.68,"to",1,"Exceeds Standards"]
["The number of students who are in  grade 12 at any time during the school year and the number of additional students who reach age 21 years and 9 months prior to June 30"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Achievement Component Rating",null,null,null,null,{"$f":"IF(AND(F10>=J11,F10<>\"\"),\"Exceeds Standards\",IF(AND(F10>=J9,F10<L9),\"Meets Standards\",IF(AND(F10<L8,F10>=J8),\"Does Not Meet Standards\",IF(F10=\"\",\"Not Rated\",\"Error\"))))","v":"Not Rated"}]
[]
[]
[]
[]
["Achievement Component Technical Documentation"]

{"sheet":"Progress","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[13,5,14,8],[13,9,14,10],[8,5,8,6],[10,5,10,6],[3,0,3,3],[7,5,7,7],[3,4,3,11],[8,0,8,2],[9,1,9,2]]}
["How To Use This Simulator:"]
["Input the growth index score"]
[]
["Value-Added Inputs",null,null,null,"Progress Component Rating"]
[]
[]
[]
[null,null,null,null,null,"Growth Index",null,null,"Rating"]
["Input Value-Added Growth Index",null,null,null,null,"Less than ",null,-2,"Does Not Meet Standards"]
["Growth Index",null,null,null,null,-2,"to",2,"Meets Standards"]
[null,null,null,null,null,"Greater than or Equal to",null,2,"Exceeds Standards"]
[]
[]
[null,null,null,null,null,"Progress Component Rating",null,null,null,{"$f":"IF(AND(B10<H9),I9,IF(AND(B10>=F10,B10<H10,B10<>\"\"),I10,IF(AND(B10>=H11),I11,IF(ISBLANK(B10),\"Not Rated\",\"Error\"))))","v":"Not Rated"}]
[]
[]
[]
["Progress Component Technical Documentation"]

{"sheet":"Gap Closing","index":3,"n_rows":104,"n_cols":20,"rows_kept":104,"cut":false,"hidden":false,"merged":[[63,15,63,18],[62,15,62,18],[42,15,42,18],[52,10,52,12],[52,8,52,9],[50,18,50,19],[51,18,51,19],[52,18,52,19],[53,18,53,19],[50,15,50,17],[39,15,39,19],[40,15,41,18],[40,19,41,19],[4,0,4,2],[4,4,4,5],[4,6,4,13],[4,14,4,20]]}
["How To Use This Simulator:"]
["To use this simulator. Enter your gap closing measure data in the input boxes below (outlined in red)."]
["Select \"Yes\" or \"No\" under the Applicable column to add or remove measures from the component calculation",null,null,"SELECT YEAR","2024-2025"]
[]
["Component Measure Inputs",null,null,"Goals","Points",null,"Point Totals",null,null,null,null,null,null,null,"Gap Closing Component Rating"]
["ELP Measure","Applicable","English Learner Proficiency",{"$f":"E3","v":"2024-2025"},"Points","Points Possible"]
["English Language Proficiency Improvement Indicator","No",null,{"$f":"IF(E3=\"2021-2022\",0.4305,IF(E3=\"2022-2023\",0.466,IF(E3=\"2023-2024\",0.5015,IF(E3=\"2024-2025\",0.537,IF(E3=\"2025-2026\",0.5725,IF(E3=\"2026-2027\",0.608,IF(E3=\"2027-2028\",0.6435,IF(E3=\"2028-2029\",0.679,IF(E3=\"2029-2030\",0.7145, IF(E3=\"2030-2031\",0.75,0))))))))))","v":0.53700000000000003},{"$f":"IF(AND(B7=\"Yes\",C7>=D7),100,IF(AND(B7=\"YES\",D9<>\"Error\",D9>=10%),100,0))","v":0},{"$f":"IF(B7=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Change"]
[null,null,null,{"$f":"IF(ISBLANK(C9),\"Error\",C7-C9)","v":"Error"}]
["ELA Achievement Measure","Applicable","Performance Index",{"$f":"E3","v":"2024-2025"},"Points","Points Possible"]
["ELA Achievement - All Students","No",null,{"$f":"IF(E3=\"2021-2022\",78.56,IF(E3=\"2022-2023\",80.94,IF(E3=\"2023-2024\",83.33,IF(E3=\"2024-2025\",85.71,IF(E3=\"2025-2026\",88.09,IF(E3=\"2026-2027\",90.47,IF(E3=\"2027-2028\",92.85,IF(E3=\"2028-2029\",95.24,IF(E3=\"2029-2030\",97.62, IF(E3=\"2030-2031\",100,0))))))))))","v":85.71},{"$f":"IF(AND(B11=\"Yes\",OR(C11>=D11,D13>=10)),100,IF(AND(B11=\"Yes\",D13<10, D13>0),D13*10,0))","v":0},{"$f":"IF(B11=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C13), C11<>100),((C11-C13)/(100-C11))*100,0)","v":0}]
["ELA Achievement - American Indian/Alaskan Native","No",null,{"$f":"IF(E3=\"2021-2022\",69.67,IF(E3=\"2022-2023\",71.26,IF(E3=\"2023-2024\",72.86,IF(E3=\"2024-2025\",74.46,IF(E3=\"2025-2026\",76.05,IF(E3=\"2026-2027\",77.65,IF(E3=\"2027-2028\",79.24,IF(E3=\"2028-2029\",80.84,IF(E3=\"2029-2030\",82.44, IF(E3=\"2030-2031\",84.03,0))))))))))","v":74.459999999999994},{"$f":"IF(AND(B14=\"Yes\",OR(C14>=D14,D16>=10)),100,IF(AND(B14=\"Yes\",D16>0,D16<10),D16*10,0))","v":0},{"$f":"IF(B14=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C16), C14<>84.03),((C14-C16)/(84.03-C14))*100,0)","v":0}]
["ELA Achievement - Asian/Pacific Islander","No",null,{"$f":"IF(E3=\"2021-2022\",86.89,IF(E3=\"2022-2023\",87.58,IF(E3=\"2023-2024\",88.27,IF(E3=\"2024-2025\",88.96,IF(E3=\"2025-2026\",89.65,IF(E3=\"2026-2027\",90.34,IF(E3=\"2027-2028\",91.03,IF(E3=\"2028-2029\",91.72,IF(E3=\"2029-2030\",92.41, IF(E3=\"2030-2031\",93.1,0))))))))))","v":88.96},{"$f":"IF(AND(B17=\"Yes\",OR(C17>=D17,D19>=10)),100,IF(AND(B17=\"Yes\",D19>0,D19<10),D19*10,0))","v":0},{"$f":"IF(B17=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C19),C17<>93.1),((C17-C19)/(93.1-C17))*100,0)","v":0}]
["ELA Achievement - Black, Non-Hispanic","No",null,{"$f":"IF(E3=\"2021-2022\",54.79,IF(E3=\"2022-2023\",57.17,IF(E3=\"2023-2024\",59.55,IF(E3=\"2024-2025\",61.93,IF(E3=\"2025-2026\",64.31,IF(E3=\"2026-2027\",66.69,IF(E3=\"2027-2028\",69.07,IF(E3=\"2028-2029\",71.45,IF(E3=\"2029-2030\",73.83, IF(E3=\"2030-2031\",76.21,0))))))))))","v":61.93},{"$f":"IF(AND(B20=\"Yes\",OR(C20>=D20,D22>=10)),100,IF(AND(B20=\"Yes\",D22>0,D22<10),D22*10,0))","v":0},{"$f":"IF(B20=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C22),C20<>76.21),((C20-C22)/(76.21-C20))*100,0)","v":0}]
["ELA Achievement - Hispanic","No",null,{"$f":"IF(E3=\"2021-2022\",66.28,IF(E3=\"2022-2023\",68.05,IF(E3=\"2023-2024\",69.83,IF(E3=\"2024-2025\",71.6,IF(E3=\"2025-2026\",73.83,IF(E3=\"2026-2027\",75.15,IF(E3=\"2027-2028\",76.93,IF(E3=\"2028-2029\",78.7,IF(E3=\"2029-2030\",80.48, IF(E3=\"2030-2031\",82.25,0))))))))))","v":71.599999999999994},{"$f":"IF(AND(B23=\"Yes\",OR(C23>=D23,D25>=10)),100,IF(AND(B23=\"Yes\",D25>0,D25<10),D25*10,0))","v":0},{"$f":"IF(B23=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C25),C23<>82.25),((C23-C25)/(82.25-C23))*100,0)","v":0}]
["ELA Achievement - Multiracial","No",null,{"$f":"IF(E3=\"2021-2022\",71.64,IF(E3=\"2022-2023\",73.14,IF(E3=\"2023-2024\",74.63,IF(E3=\"2024-2025\",76.12,IF(E3=\"2025-2026\",77.61,IF(E3=\"2026-2027\",79.11,IF(E3=\"2027-2028\",80.6,IF(E3=\"2028-2029\",82.09,IF(E3=\"2029-2030\",83.58, IF(E3=\"2030-2031\",85.08,0))))))))))","v":76.12},{"$f":"IF(AND(B26=\"Yes\",OR(C26>=D26,D28>=10)),100,IF(AND(B26=\"Yes\", D28>0, D28<10), D28*10,0))","v":0},{"$f":"IF(B26=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C28),C26<>85.08),((C26-C28)/(85.08-C26))*100,0)","v":0}]
["ELA Achievement - White, Non-Hispanic","No",null,{"$f":"IF(E3=\"2021-2022\",84.26,IF(E3=\"2022-2023\",85.09,IF(E3=\"2023-2024\",85.92,IF(E3=\"2024-2025\",86.74,IF(E3=\"2025-2026\",87.57,IF(E3=\"2026-2027\",88.4,IF(E3=\"2027-2028\",89.23,IF(E3=\"2028-2029\",90.06,IF(E3=\"2029-2030\",90.89, IF(E3=\"2030-2031\",91.72,0))))))))))","v":86.74},{"$f":"IF(AND(B29=\"Yes\",OR(C29>=D29,D31>=10)),100,IF(AND(B29=\"Yes\",D31>0,D31<10),D31*10,0))","v":0},{"$f":"IF(B29=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C31),C29<>91.72),((C29-C31)/(91.72-C29))*100,0)","v":0}]
["ELA Achievement - Economic Disadvantaged","No",null,{"$f":"IF(E3=\"2021-2022\",64.22,IF(E3=\"2022-2023\",66.1,IF(E3=\"2023-2024\",67.98,IF(E3=\"2024-2025\",69.87,IF(E3=\"2025-2026\",71.75,IF(E3=\"2026-2027\",73.63,IF(E3=\"2027-2028\",75.52,IF(E3=\"2028-2029\",77.4,IF(E3=\"2029-2030\",79.28, IF(E3=\"2030-2031\",81.17,0))))))))))","v":69.87},{"$f":"IF(AND(B32=\"Yes\",OR(C32>=D32,D34>=10)),100,IF(AND(B32=\"Yes\",D34>0,D34<10),D34*10,0))","v":0},{"$f":"IF(B32=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C34),C32<>81.17),((C32-C34)/(81.17-C32))*100,0)","v":0}]
["ELA Achievement - Students with Disabilities","No",null,{"$f":"IF(E3=\"2021-2022\",50.64,IF(E3=\"2022-2023\",53.24,IF(E3=\"2023-2024\",55.84,IF(E3=\"2024-2025\",58.43,IF(E3=\"2025-2026\",61.03,IF(E3=\"2026-2027\",63.63,IF(E3=\"2027-2028\",66.23,IF(E3=\"2028-2029\",68.83,IF(E3=\"2029-2030\",71.42, IF(E3=\"2030-2031\",74.02,0))))))))))","v":58.43},{"$f":"IF(AND(B35=\"Yes\",OR(C35>=D35,D37>=10)),100,IF(AND(B35=\"Yes\",D37>0,D37<10),D37*10,0))","v":0},{"$f":"IF(B35=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C37),C35<>74.02),((C35-C37)/(74.02))*100,0)","v":0}]
["ELA Achievement -English Learners","No",null,{"$f":"IF(E3=\"2021-2022\",62.6,IF(E3=\"2022-2023\",64.57,IF(E3=\"2023-2024\",66.54,IF(E3=\"2024-2025\",68.51,IF(E3=\"2025-2026\",70.48,IF(E3=\"2026-2027\",72.44,IF(E3=\"2027-2028\",74.41,IF(E3=\"2028-2029\",76.38,IF(E3=\"2029-2030\",78.35, IF(E3=\"2030-2031\",80.32,0))))))))))","v":68.510000000000005},{"$f":"IF(AND(B38=\"Yes\",OR(C38>=D38,D40>=10)),100,IF(AND(B38=\"Yes\",D40>0,D40<10),D40*10,0))","v":0},{"$f":"IF(B38=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C40),C38<>80.32),((C38-C40)/(80.32-C38))*100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Participation Demotion"]
["Math Achievement Measure","`","Performance Index",{"$f":"E3","v":"2024-2025"},"Points","Points Possible",null,null,null,null,null,null,null,null,null,"One or more student groups has a participation rate < 95%",null,null,null,"Points after Demotion"]
["Math Achievement - All Students","No",null,{"$f":"IF(E3=\"2021-2022\",71.12,IF(E3=\"2022-2023\",74.33,IF(E3=\"2023-2024\",77.54,IF(E3=\"2024-2025\",80.75,IF(E3=\"2025-2026\",83.96,IF(E3=\"2026-2027\",87.16,IF(E3=\"2027-2028\",90.37,IF(E3=\"2028-2029\",93.58,IF(E3=\"2029-2030\",96.79, IF(E3=\"2030-2031\",100,0))))))))))","v":80.75},{"$f":"IF(AND(B42=\"Yes\",OR(C42>=D42,D44>=10)),100,IF(AND(B42=\"Yes\",D44>0,D44<10),D44*10,0))","v":0},{"$f":"IF(B42=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points",null,null,null,null,null,null,null,null,null,null,null,"No",null,null,null,{"$f":"IF(P43=\"Yes\",K53-5,K53)","v":""}]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C44), C42<>100),((C42-C44)/(100-C42))*100,0)","v":0}]
["Math Achievement - American Indian/Alaskan Native","No",null,{"$f":"IF(E3=\"2021-2022\",60.79,IF(E3=\"2022-2023\",62.85,IF(E3=\"2023-2024\",64.91,IF(E3=\"2024-2025\",66.98,IF(E3=\"2025-2026\",69.04,IF(E3=\"2026-2027\",71.11,IF(E3=\"2027-2028\",73.17,IF(E3=\"2028-2029\",75.23,IF(E3=\"2029-2030\",77.3, IF(E3=\"2030-2031\",79.36,0))))))))))","v":66.98},{"$f":"IF(AND(B45=\"Yes\",OR(C45>=D45,D47>=10)),100,IF(AND(B45=\"Yes\",D47>0,D47<10),D47*10,0))","v":0},{"$f":"IF(B45=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C47), C45<>79.36),((C45-C47)/(79.36-C45))*100,0)","v":0}]
["Math Achievement - Asian/Pacific Islander","No",null,{"$f":"IF(E3=\"2021-2022\",83.93,IF(E3=\"2022-2023\",84.78,IF(E3=\"2023-2024\",85.62,IF(E3=\"2024-2025\",86.47,IF(E3=\"2025-2026\",87.32,IF(E3=\"2026-2027\",88.16,IF(E3=\"2027-2028\",89.01,IF(E3=\"2028-2029\",89.85,IF(E3=\"2029-2030\",90.7, IF(E3=\"2030-2031\",91.54,0))))))))))","v":86.47},{"$f":"IF(AND(B48=\"Yes\",OR(C48>=D48,D50>=10)),100,IF(AND(B48=\"Yes\",D50>0,D50<10),D50*10,0))","v":0},{"$f":"IF(B48=\"Yes\",100,0)","v":0},null,null,"Measure",null,"Points Total","Points Possible","Points Earned"]
[null,null,"Previous Year Proficiency","Improvement Points",null,null,null,null,"ELP Indicator",null,{"$f":"SUM(E7)","v":0},{"$f":"SUM(F7)","v":0},{"$f":"IF(L49=0,\"\",(K49/L49)*100)","v":""}]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C50),C48<>91.54),((C48-C50)/(91.54-C48))*100,0)","v":0},null,null,null,null,"ELA Achievement",null,{"$f":"SUM(E11:E38)","v":0},{"$f":"SUM(F11:F38)","v":0},{"$f":"IF(L50=0,\"\",(K50/L50)*100)","v":""}]
["Math Achievement - Black, Non-Hispanic","No",null,{"$f":"IF(E3=\"2021-2022\",44.09,IF(E3=\"2022-2023\",47.03,IF(E3=\"2023-2024\",49.97,IF(E3=\"2024-2025\",52.92,IF(E3=\"2025-2026\",55.86,IF(E3=\"2026-2027\",58.8,IF(E3=\"2027-2028\",61.74,IF(E3=\"2028-2029\",64.69,IF(E3=\"2029-2030\",67.63, IF(E3=\"2030-2031\",70.57,0))))))))))","v":52.92},{"$f":"IF(AND(B51=\"Yes\",OR(C51>=D51,D53>=10)),100,IF(AND(B51=\"Yes\",D53>0,D53<10),D53*10,0))","v":0},{"$f":"IF(B51=\"Yes\",100,0)","v":0},null,null,"Math Achievement",null,{"$f":"SUM(E42:E69)","v":0},{"$f":"SUM(F42:F69)","v":0},{"$f":"IF(L51=0,\"\",(K51/L51)*100)","v":""},null,null,"Score Range",null,null,"Rating"]
[null,null,"Previous Year Proficiency","Improvement Points",null,null,null,null,"Graduation",null,{"$f":"SUM(E73:E100)","v":0},{"$f":"SUM(F73:F100)","v":0},{"$f":"IF(L52=0,\"\",(K52/L52)*100)","v":""},null,null,0,"to",0.01,"Does Not Meet Standards"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C53),C51<>70.57),((C51-C53)/(70.57-C51))*100,0)","v":0},null,null,null,null,"Preliminary Points",null,{"$f":"IF(AND(M49=\"\",M50=\"\",M51=\"\",M52=\"\"),\"\",AVERAGE(M49:M52))","v":""},null,null,null,null,0.01,"to",0.36,"Meets Standards"]
["Math Achievement - Hispanic","No",null,{"$f":"IF(E3=\"2021-2022\",57.7,IF(E3=\"2022-2023\",59.93,IF(E3=\"2023-2024\",62.15,IF(E3=\"2024-2025\",64.38,IF(E3=\"2025-2026\",66.61,IF(E3=\"2026-2027\",68.83,IF(E3=\"2027-2028\",71.06,IF(E3=\"2028-2029\",73.29,IF(E3=\"2029-2030\",75.51, IF(E3=\"2030-2031\",77.74,0))))))))))","v":64.38},{"$f":"IF(AND(B54=\"Yes\",OR(C54>=D54,D56>=10)),100,IF(AND(B54=\"Yes\",D56>0,D56<10),D56*10,0))","v":0},{"$f":"IF(B54=\"Yes\",100,0)","v":0},null,null,null,null,null,null,null,null,null,0.36,"to",1,"Exceeds Standards"]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C56),C54<>77.74),((C54-C56)/(77.74-C54))*100,0)","v":0}]
["Math Achievement - Multiracial","No",null,{"$f":"IF(E3=\"2021-2022\",61.72,IF(E3=\"2022-2023\",63.73,IF(E3=\"2023-2024\",65.75,IF(E3=\"2024-2025\",67.76,IF(E3=\"2025-2026\",69.78,IF(E3=\"2026-2027\",71.79,IF(E3=\"2027-2028\",73.81,IF(E3=\"2028-2029\",75.82,IF(E3=\"2029-2030\",77.84, IF(E3=\"2030-2031\",79.85,0))))))))))","v":67.760000000000005},{"$f":"IF(AND(B57=\"Yes\",OR(C57>=D57,D59>=10)),100,IF(AND(B57=\"Yes\",D59>0,D59<10),D59*10,0))","v":0},{"$f":"IF(B57=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C59),C57<>79.85),((C57-C59)/(79.85-C57))*100,0)","v":0}]
["Math Achievement - White, Non-Hispanic","No",null,{"$f":"IF(E3=\"2021-2022\",77.23,IF(E3=\"2022-2023\",78.43,IF(E3=\"2023-2024\",79.63,IF(E3=\"2024-2025\",80.83,IF(E3=\"2025-2026\",82.03,IF(E3=\"2026-2027\",83.22,IF(E3=\"2027-2028\",84.42,IF(E3=\"2028-2029\",85.62,IF(E3=\"2029-2030\",86.82, IF(E3=\"2030-2031\",88.02,0))))))))))","v":80.83},{"$f":"IF(AND(B60=\"Yes\",OR(C60>=D60,D62>=10)),100,IF(AND(B60=\"Yes\",D62>0,D62<10),D62*10,0))","v":0},{"$f":"IF(B60=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C62),C60<>88.02),((C60-C62)/(88.02-C60))*100,0)","v":0}]
["Math Achievement - Economic Disadvantaged","No",null,{"$f":"IF(E3=\"2021-2022\",55.12,IF(E3=\"2022-2023\",57.48,IF(E3=\"2023-2024\",59.84,IF(E3=\"2024-2025\",62.21,IF(E3=\"2025-2026\",64.57,IF(E3=\"2026-2027\",66.93,IF(E3=\"2027-2028\",69.29,IF(E3=\"2028-2029\",71.65,IF(E3=\"2029-2030\",74.02, IF(E3=\"2030-2031\",76.38,0))))))))))","v":62.21},{"$f":"IF(AND(B63=\"Yes\",OR(C63>=D63,D65>=10)),100,IF(AND(B63=\"Yes\",D65>0,D65<10),D65*10,0))","v":0},{"$f":"IF(B63=\"Yes\",100,0)","v":0},null,null,null,null,null,null,null,null,null,"Gap Closing Percent",null,null,null,{"$f":"IF(K53=\"\",\"\",T43/100)","v":""}]
[null,null,"Previous Year Proficiency","Improvement Points",null,null,null,null,null,null,null,null,null,null,null,"Gap Closing Rating",null,null,null,{"$f":"IF(AND(T63<R52,K53<>\"\"),S52,IF(AND(T63>=P53,T63<R53,K53<>\"\"),S53,IF(AND(T63>=P54,K53<>\"\"),S54,IF(T63=\"\",\"Not Rated\",\"Error\"))))","v":"Not Rated"}]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C65),C63<>76.38),((C63-C65)/(76.38-C63))*100,0)","v":0}]
["Math Achievement - Students with Diabilities","No",null,{"$f":"IF(E3=\"2021-2022\",45.52,IF(E3=\"2022-2023\",48.39,IF(E3=\"2023-2024\",51.26,IF(E3=\"2024-2025\",54.12,IF(E3=\"2025-2026\",56.99,IF(E3=\"2026-2027\",59.86,IF(E3=\"2027-2028\",62.73,IF(E3=\"2028-2029\",65.59,IF(E3=\"2029-2030\",68.46, IF(E3=\"2030-2031\",71.33,0))))))))))","v":54.12},{"$f":"IF(AND(B66=\"Yes\",OR(C66>=D66,D68>=10)),100,IF(AND(B66=\"Yes\",D68>0,D68<10),D68*10,0))","v":0},{"$f":"IF(B66=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C68),C66<>71.33),((C66-C68)/(71.33-C66))*100,0)","v":0}]
["Math Achievement -English Learners","No",null,{"$f":"IF(E3=\"2021-2022\",56.97,IF(E3=\"2022-2023\",59.23,IF(E3=\"2023-2024\",61.5,IF(E3=\"2024-2025\",63.76,IF(E3=\"2025-2026\",66.03,IF(E3=\"2026-2027\",68.29,IF(E3=\"2027-2028\",70.56,IF(E3=\"2028-2029\",72.82,IF(E3=\"2029-2030\",75.09, IF(E3=\"2030-2031\",77.35,0))))))))))","v":63.76},{"$f":"IF(AND(B69=\"Yes\",OR(C69>=D69,D71>=10)),100,IF(AND(B69=\"Yes\",D71>0,D71<10),D71*10,0))","v":0},{"$f":"IF(B69=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Proficiency","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C71),C69<>77.35),((C69-C71)/(77.35-C69))*100,0)","v":0}]
["Graduation Measure","Applicable","Graduation Rate",{"$f":"E3","v":"2024-2025"},"Points","Points Possible"]
["Graduation - All Students","No",null,{"$f":"IF(E3=\"2021-2022\",0.8813,IF(E3=\"2022-2023\",0.8906,IF(E3=\"2023-2024\",0.8999,IF(E3=\"2024-2025\",0.9092,IF(E3=\"2025-2026\",0.9185,IF(E3=\"2026-2027\",0.9278,IF(E3=\"2027-2028\",0.9371,IF(E3=\"2028-2029\",0.9464,IF(E3=\"2029-2030\",0.9557, IF(E3=\"2030-2031\",0.965,0))))))))))","v":0.90920000000000001},{"$f":"IF(AND(B73=\"Yes\",OR(C73>=D73,D75>=10)),100,IF(AND(B73=\"Yes\",D75>0,D75<10),D75*10,0))","v":0},{"$f":"IF(B73=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C75),C73<>0.965),((C73-C75)/(0.965-C73))*100,0)","v":0}]
["Graduation - American Indian/Alaskan Native","No",null,{"$f":"IF(E3=\"2021-2022\",0.8064,IF(E3=\"2022-2023\",0.8147,IF(E3=\"2023-2024\",0.8231,IF(E3=\"2024-2025\",0.8314,IF(E3=\"2025-2026\",0.8398,IF(E3=\"2026-2027\",0.8481,IF(E3=\"2027-2028\",0.8565,IF(E3=\"2028-2029\",0.8648,IF(E3=\"2029-2030\",0.8732, IF(E3=\"2030-2031\",0.8815,0))))))))))","v":0.83140000000000003},{"$f":"IF(AND(B76=\"Yes\",OR(C76>=D76,D78>=10)),100,IF(AND(B76=\"Yes\",D78>0,D78<10),D78*10,0))","v":0},{"$f":"IF(B76=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C78),C76<>0.8815),((C76-C78)/(0.8815-C76))*100,0)","v":0}]
["Graduation - Asian/Pacific Islander","No",null,{"$f":"IF(E3=\"2021-2022\",0.927,IF(E3=\"2022-2023\",0.929,IF(E3=\"2023-2024\",0.931,IF(E3=\"2024-2025\",0.933,IF(E3=\"2025-2026\",0.935,IF(E3=\"2026-2027\",0.937,IF(E3=\"2027-2028\",0.939,IF(E3=\"2028-2029\",0.941,IF(E3=\"2029-2030\",0.943, IF(E3=\"2030-2031\",0.945,0))))))))))","v":0.93300000000000005},{"$f":"IF(AND(B79=\"Yes\",OR(C79>=D79,D81>=10)),100,IF(AND(B79=\"Yes\",D81>0,D81<10),D81*10,0))","v":0},{"$f":"IF(B79=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C81),C79<>0.945),((C79-C81)/(0.945-C79))*100,0)","v":0}]
["Graduation - Black, Non-Hispanic","No",null,{"$f":"IF(E3=\"2021-2022\",0.7788,IF(E3=\"2022-2023\",0.7886,IF(E3=\"2023-2024\",0.7984,IF(E3=\"2024-2025\",0.8082,IF(E3=\"2025-2026\",0.818,IF(E3=\"2026-2027\",0.8278,IF(E3=\"2027-2028\",0.8376,IF(E3=\"2028-2029\",0.8474,IF(E3=\"2029-2030\",0.8572, IF(E3=\"2030-2031\",0.867,0))))))))))","v":0.80820000000000003},{"$f":"IF(AND(B82=\"Yes\",OR(C82>=D82,D84>=10)),100,IF(AND(B82=\"Yes\",D84>0,D84<10),D84*10,0))","v":0},{"$f":"IF(B82=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C84),C82<>0.867),((C82-C84)/(0.867-C82))*100,0)","v":0}]
["Graduation - Hispanic","No",null,{"$f":"IF(E3=\"2021-2022\",0.7969,IF(E3=\"2022-2023\",0.8057,IF(E3=\"2023-2024\",0.8146,IF(E3=\"2024-2025\",0.8234,IF(E3=\"2025-2026\",0.8323,IF(E3=\"2026-2027\",0.8411,IF(E3=\"2027-2028\",0.85,IF(E3=\"2028-2029\",0.8588,IF(E3=\"2029-2030\",0.8677, IF(E3=\"2030-2031\",0.8765,0))))))))))","v":0.82340000000000002},{"$f":"IF(AND(B85=\"Yes\",OR(C85>=D85,D87>=10)),100,IF(AND(B85=\"Yes\",D87>0,D87<10),D87*10,0))","v":0},{"$f":"IF(B85=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C87),C85<>0.8765),((C85-C87)/(0.8765-C85))*100,0)","v":0}]
["Graduation - Multiracial","No",null,{"$f":"IF(E3=\"2021-2022\",0.8425,IF(E3=\"2022-2023\",0.8489,IF(E3=\"2023-2024\",0.8554,IF(E3=\"2024-2025\",0.8618,IF(E3=\"2025-2026\",0.8683,IF(E3=\"2026-2027\",0.8747,IF(E3=\"2027-2028\",0.8812,IF(E3=\"2028-2029\",0.8876,IF(E3=\"2029-2030\",0.8941, IF(E3=\"2030-2031\",0.9005,0))))))))))","v":0.86180000000000001},{"$f":"IF(AND(B88=\"Yes\",OR(C88>=D88,D90>=10)),100,IF(AND(B88=\"Yes\",D90>0,D90<10),D90*10,0))","v":0},{"$f":"IF(B88=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C90),C88<>0.9005),((C88-C90)/(0.9005-C88))*100,0)","v":0}]
["Graduation - White, Non-Hispanic","No",null,{"$f":"IF(E3=\"2021-2022\",0.9042,IF(E3=\"2022-2023\",0.9074,IF(E3=\"2023-2024\",0.9106,IF(E3=\"2024-2025\",0.9138,IF(E3=\"2025-2026\",0.917,IF(E3=\"2026-2027\",0.9202,IF(E3=\"2027-2028\",0.9234,IF(E3=\"2028-2029\",0.9266,IF(E3=\"2029-2030\",0.9298, IF(E3=\"2030-2031\",0.933,0))))))))))","v":0.91379999999999995},{"$f":"IF(AND(B91=\"Yes\",OR(C91>=D91,D93>=10)),100,IF(AND(B91=\"Yes\",D93>0,D93<10),D93*10,0))","v":0},{"$f":"IF(B91=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C93),C91<>0.933),((C91-C93)/(0.933-C91))*100,0)","v":0}]
["Graduation - Economically Disadvantaged","No",null,{"$f":"IF(E3=\"2021-2022\",0.7931,IF(E3=\"2022-2023\",0.8021,IF(E3=\"2023-2024\",0.8112,IF(E3=\"2024-2025\",0.8202,IF(E3=\"2025-2026\",0.8293,IF(E3=\"2026-2027\",0.8383,IF(E3=\"2027-2028\",0.8474,IF(E3=\"2028-2029\",0.8564,IF(E3=\"2029-2030\",0.8655, IF(E3=\"2030-2031\",0.8745,0))))))))))","v":0.82020000000000004},{"$f":"IF(AND(B94=\"Yes\",OR(C94>=D94,D96>=10)),100,IF(AND(B94=\"Yes\",D96>0,D96<10),D96*10,0))","v":0},{"$f":"IF(B94=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C96),C94<>0.8745),((C94-C96)/(0.8745-C94))*100,0)","v":0}]
["Graduation - Students with Disabilities","No",null,{"$f":"IF(E3=\"2021-2022\",0.7541,IF(E3=\"2022-2023\",0.7652,IF(E3=\"2023-2024\",0.7763,IF(E3=\"2024-2025\",0.7874,IF(E3=\"2025-2026\",0.7985,IF(E3=\"2026-2027\",0.8096,IF(E3=\"2027-2028\",0.8207,IF(E3=\"2028-2029\",0.8318,IF(E3=\"2029-2030\",0.8429, IF(E3=\"2030-2031\",0.854,0))))))))))","v":0.78739999999999999},{"$f":"IF(AND(B97=\"Yes\",OR(C97>=D97,D99>=10)),100,IF(AND(B97=\"Yes\",D99>0,D99<10),D99*10,0))","v":0},{"$f":"IF(B97=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C99),C97<>0.854),((C97-C99)/(0.854-C97))*100,0)","v":0}]
["Graduation - English Learners","No",null,{"$f":"IF(E3=\"2021-2022\",0.7199,IF(E3=\"2022-2023\",0.7328,IF(E3=\"2023-2024\",0.7457,IF(E3=\"2024-2025\",0.7586,IF(E3=\"2025-2026\",0.7715,IF(E3=\"2026-2027\",0.7844,IF(E3=\"2027-2028\",0.7973,IF(E3=\"2028-2029\",0.8102,IF(E3=\"2029-2030\",0.8231, IF(E3=\"2030-2031\",0.836,0))))))))))","v":0.75860000000000005},{"$f":"IF(AND(B100=\"Yes\",OR(C100>=D100,D102>=10)),100,IF(AND(B100=\"Yes\",D102>0,D102<10),D102*10,0))","v":0},{"$f":"IF(B100=\"Yes\",100,0)","v":0}]
[null,null,"Previous Year Graduation Rate","Improvement Points"]
[null,null,null,{"$f":"IF(AND(ISNUMBER(C102),C100<>0.836),((C100-C102)/(0.836-C100))*100,0)","v":0}]
[]
["Gap Closing Technical Documentation"]

{"sheet":"Graduation","index":4,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[[10,16,10,18],[1,0,1,1],[4,0,4,3],[4,4,4,9],[4,10,4,19],[8,11,8,13],[9,16,9,18]]}
["How To Use This Simulator:"]
["To use this simulator enter the number of four-year, five-year, six-year, seven-year, and eight-year graduates.  Enter the number of students in each applicable cohort."]
[]
[]
["Graduation Inputs",null,null,null,"Measure Weighting",null,null,null,null,null,"Graduation Component Rating"]
[]
[]
[]
["Four-Year Graduates","Students in the Class of Prior year","Four-Year Adjusted Cohort Graduation Rate Meaure",null,null,null,null,null,null,null,null,"Combined Graduation Rate Range",null,null,"Rating"]
[null,null,{"$f":"IF(OR(B10=\"\",B10=0,A10>B10),\"\",A10/B10)","v":""},null,null,"Total Graduates","Total Students",null,"Combined Graduation Rate",null,null,0.4,"To ",1,"Exceeds Standards",null,"Graduation Component Rating"]
[null,null,null,null,null,{"$f":"SUM(A10,A13,A16,A19,A22)","v":0},{"$f":"SUM(B10,B13,B16,B19,B22)","v":0},null,{"$f":"IF(OR(G11=0,F11>G11),\"\",F11/G11)","v":""},null,null,0.12,"To ",0.4,"Meets Standards",null,{"$f":"IF(AND(I11<N12,I11<>\"\"),O12,IF(AND(I11>=L11,I11<N11,I11<>\"\"),O11,IF(AND(I11>=L10,I11<>\"\"),O10,IF(I11=\"\",\"Not Rated\",\"ERROR\"))))","v":"Not Rated"}]
["Five-Year Graduates","Students in the Class of 2 years Prior","Five-Year Adjusted Cohort Graduation Rate Measure",null,null,null,null,null,null,null,null,0,"To ",0.12,"Does Not Meet Standards"]
[null,null,{"$f":"IF(OR(B13=\"\",B13=0,A13>B13),\"\",A13/B13)","v":""}]
[]
["Six-Year Graduates","Students in the Class of 3 years Prior","Six-Year Adjusted Cohort Graduation Rate Measure"]
[null,null,{"$f":"IF(OR(B16=0,B16=\"\",A16>B16),\"\",A16/B16)","v":""}]
[]
["Seven-Year Graduates","Students in the Class of 4 years Prior","Seven-Year Adjusted Cohort Graduation Rate Measure"]
[null,null,{"$f":"IF(OR(B19=\"\",B19=0,A19>B19),\"\",A19/B19)","v":""}]
[]
["Eight-Year Graduates","Students in the Class of 5 years Prior","Eight-Year Adjusted Cohort Graduation Rate Measure"]
[null,null,{"$f":"IF(OR(B22=\"\",B22=0,A22>B22),\"\",A22/B22)","v":""}]
[]
[]
[]
["Graduation Component Technical Documentation"]

{"sheet":"Overall","index":5,"n_rows":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":false,"merged":[[7,19,7,21],[3,0,3,4],[3,5,3,11],[6,6,6,7],[6,9,6,10],[3,12,3,22],[5,13,5,15],[14,0,14,3],[0,0,0,1],[1,0,1,1],[7,6,7,7],[7,9,7,10]]}
["How To Use This Simulator:"]
["Select the rating for each component on the Dropout Recovery Report Card"]
[]
["Component Inputs",null,null,null,null,"Overall Percentage",null,null,null,null,null,null,"Overall Rating"]
[]
["Component","Rating","Points","Points Possible",null,null,null,null,null,null,null,null,null,"Rating Percentage",null,null,"Rating"]
["Achievement",{"$f":"Achievement!O17","v":"Not Rated"},{"$f":"IF(B7=\"Exceeds Standards\",20,IF(B7=\"Meets Standards\",10,IF(B7=\"Does Not Meet Standards\",0,\"\")))","v":""},{"$f":"IF(AND(B7<>\"\",B7<>\"Not Rated\"),20,0)","v":0},null,null,"Total Points",null,"Total Possible","Overall Percentage",null,null,null,0.8,"to",1,"Exceeds Standards"]
["Progress",{"$f":"Progress!J14","v":"Not Rated"},{"$f":"IF(B8=\"Exceeds Standards\",30,IF(B8=\"Meets Standards\",20,IF(B8=\"Does Not Meet Standards\",0,\"\")))","v":""},{"$f":"IF(AND(B8<>\"\",B8<>\"Not Rated\"),30,0)","v":0},null,null,{"$f":"SUM(C7:C10)","v":0},null,{"$f":"SUM(D7:D10)","v":0},{"$f":"IF(I8=0,\"\",G8/I8)","v":""},null,null,null,0.4,"to ",0.8,"Meets Standards",null,"Rating:",{"$f":"IF(AND(J8>=80%,J8<>\"\"),\"Exceeds Standards\",IF(AND(J8>=40%,J8<80%,J8<>\"\"),\"Meets Standards\",IF(AND(J8<40%,J8<>\"\"),\"Does Not Meet Standards\",IF(J8=\"\",\"Not Rated\",\"Error\"))))","v":"Not Rated"}]
["Gap Closing",{"$f":"'Gap Closing'!T64","v":"Not Rated"},{"$f":"IF(B9=\"Exceeds Standards\",20,IF(B9=\"Meets Standards\",10,IF(B9=\"Does Not Meet Standards\",0,IF(B9=\"Not Rated\",\"\",\"\"))))","v":""},{"$f":"IF(AND(B9<>\"\",B9<>\"Not Rated\"),20,0)","v":0},null,null,null,null,null,null,null,null,null,0,"to",0.4,"Does Not Meet Standards"]
["Graduation",{"$f":"Graduation!Q11","v":"Not Rated"},{"$f":"IF(B10=\"Does Not Meet Standards\",0,IF(B10=\"Meets Standards\",20,IF(B10=\"Exceeds Standards\", 30, \"\")))","v":""},{"$f":"IF(AND(B10<>\"\",B10<>\"Not Rated\"),30,0)","v":0}]
[]
[]
[]
["Overall and Component Rating Technical Documentation"]
["*It is possible for a building rated as \"Does Not Meet Standards\" to receive an overall rating bump if both the assessment passage rate and the individual graduation rates improve by at least ten percent for two consecutive years. This is not included as an option in this calculator. Details are on the bottom of page 5 in the technical document."]