{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Notes","Achievement","Progress","Gap Closing","Gifted Id and Srvcs - Building","Gifted Id and Srvcs - District","Early Literacy","Graduation","CCWMR","Overall"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["These component simulations were created by the Office of Accountability in the Spring of 2023. 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"]
[]
["Updated Resource Links to 2023 technical documentation","2023-10-05"]
["Updated maximum PI scores in Achievement tab","2023-10-14"]
["Added Overall Tab\n","2023-12-26"]
["Added Hover Notes\n","2023-12-26"]
["Updated maximum PI scores in Achievement tab and technical document links","2024-09-17"]
["Created CCWMR","2025-03-31"]
["Added loading buttons to Overall, updated conditional applicable cells in Gap Closing and Overall, added conditional colors to overall tab for points","2025-04-01"]
["Added clear button to Gap Closing, created CCWMR sections, fixed graduation when one rate is not present","2025-04-02"]
["Updated component ratings to incorporate \"Not Rated\", added applicable buttons to Gap Closing","2025-04-16"]
["Changed IFS function to nested IF/AND in Early Literacy due to compatibilty issues with older versions of Excel","2025-07-28"]
["Fixed Gap Closing point assignment error in Overall tab, updated rounding functions for CCWMR and Achievement, added clear button to Overall tab","2025-07-29"]
["Updated Maximum PI scores in Achievement tab for 2024-2025 report cards","2025-10-07"]

{"sheet":"Achievement","index":1,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,8,4,15],[22,5,23,6],[20,14,21,14],[20,9,21,13],[10,9,10,11],[6,0,6,3],[19,0,19,3],[4,0,4,3],[4,4,4,7],[12,5,12,6]]}
["How To Use This Simulator:"]
["To use this simulator. Enter your component measure percentages in the input boxes below (outlined in red)."]
["Select the \"School\" or \"District\" PI type to ensure the correct percentage is calculated."]
[]
["Performance Index Inputs",null,null,null,"Performance Index",null,null,null,"Component Rating"]
[]
["Input % of Students in Each Achievement Level"]
["Achievement Level","% of Students","Points for this Level","Points Received"]
["Advanced Plus",null,1.3,{"$f":"B9*C9","v":0},null,"Performance Index:",{"$f":"IF(OR(B16>100),\"% is not 100\",SUM(D9:D15))","v":0}]
["Advanced",null,1.2,{"$f":"B10*C10","v":0}]
["Accomplished",null,1.1000000000000001,0,null,null,null,null,null,"Score Range",null,null,"Stars"]
["Proficient",null,1,0,null,null,null,null,null,0,"to",0.5,"1 Star"]
["Basic",null,0.6,0,null,"The Performance Index is divided by the Max PI to find the Percent",null,null,null,0.5,"to",0.7,"2 Stars"]
["Limited",null,0.3,0,null,"Max PI District 2025",109.8,null,null,0.7,"to",0.8,"3 Stars"]
["Untested",null,0,0,null,"Max PI Building 2025",111.3,null,null,0.8,"to",0.9,"4 Stars"]
["Total %",{"$f":"SUM(B9:B15)","v":0},null,null,null,"Performance Index Percent:",{"$f":"IF(B18=\"District\", ROUND(G9/G14,3), ROUND(G9/G15,3))","v":0},null,null,0.9,"to","100%+","5 Stars"]
[]
["Select PI Type","District"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Achievement Component Rating",null,null,null,null,{"$f":"IF(AND(G16>=J16,B16<>0),\"5 Stars\",IF(AND(G16>=J15,G16<L15,B16<>0),\"4 Stars\",IF(AND(G16>=J14,G16<L14,B16<>0),\"3 Stars\",IF(AND(G16>=J13,G16<L13,B16<>0),\"2 Stars\",IF(AND(G16<L12,B16<>0),\"1 Star\",IF(B16=0,\"Not Rated\",\"Error\"))))))","v":"Not Rated"}]
[]
[null,null,null,null,null,"*The Performance Indicators are report only and do not contribute to the component rating"]
[]
[]
[]
[]
[]
[]
["Technical Document"]
["Report Card Resources"]

{"sheet":"Progress","index":2,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[15,9,15,10],[3,0,3,3],[9,1,9,2],[10,1,10,2],[3,4,3,12],[6,6,6,7],[6,8,6,9],[7,5,7,7],[7,8,7,10],[8,0,8,2]]}
["How To Use This Simulator:"]
["To use this simulator. Enter your growth index and effect size in the input boxes below (outlined in red)."]
[]
["Value-Added Inputs",null,null,null,"Component Rating"]
[]
["Select Value-Added Type"]
["District",null,null,null,null,null,{"$f":"A7","v":"District"},null,"Criteria"]
[null,null,null,null,null,"Growth Index",null,null,"Effect Size",null,null,"Stars"]
["Input Value-Added Growth Index and Effect Size",null,null,null,null,"-","to",-2,"-","to",{"$f":"IF(A7=\"District\",-0.1,-0.2)","v":-0.1},"1 Star"]
["Growth Index",null,null,null,null,"-","to",-2,{"$f":"IF(A7=\"District\",-0.1,-0.2)","v":-0.1},"to","-","2 Stars"]
["Effect Size",null,null,null,null,-2,"to",2,"-","to","-","3 Stars"]
[null,null,null,null,null,2,"to","-","-","to",{"$f":"IF(A7=\"District\", 0.1,0.2)","v":0.1},"4 Stars"]
[null,null,null,null,null,2,"to","-",{"$f":"IF(A7=\"District\",0.1,0.2)","v":0.1},"to","-","5 Stars"]
[]
[]
[null,null,null,null,null,"Progress Component Rating",null,null,null,{"$f":"IF(AND(B10<H9,B11<K9,B10<>\"\",B11<>\"\"),L9,IF(AND(B10<H10,B11>=I10,B10<>\"\",B11<>\"\"),L10,IF(AND(B10>=F11,B10<H11,B10<>\"\",B11<>\"\"),L11,IF(AND(B10>=F12,B11<K12,B10<>\"\",B11<>\"\"),L12,IF(AND(B10>=F13,B11>=I13,B10<>\"\",B11<>\"\"),L13,IF(AND(B10=\"\",B11=\"\"),\"Not Rated\",\"Error\"))))))","v":"Not Rated"}]
[]
[]
[]
["Technical Document"]
["Report Card Resources"]

{"sheet":"Gap Closing","index":3,"n_rows":77,"n_cols":19,"rows_kept":77,"cut":false,"hidden":false,"merged":[[35,16,36,16],[35,17,36,18],[46,14,46,17],[47,14,47,17],[4,0,4,2],[4,4,4,5],[20,15,20,17],[4,6,4,12],[4,13,4,19],[7,4,8,5],[34,14,34,18],[37,14,37,15],[37,17,37,18],[35,14,36,15]]}
["How To Use This Simulator:"]
["To use this simulator. Enter your gap closing measure data in the input boxes below (outlined in red)."]
["The applicable option will include/remove the measure from the calculation by selecting \"Yes\" or \"No\"",null,null,"SELECT YEAR","2024-2025"]
[]
["Component Measure Inputs",null,null,"Goals","Points",null,"Point Totals",null,null,null,null,null,null,"Component Rating"]
["Chronic Absenteeism Measure","Applicable","Chronic Absenteeism Percent",{"$f":"E3","v":"2024-2025"},"Points","Points Possible"]
["Chronic Absenteeism Indicator","No",null,{"$f":"IF(E3=\"2021-2022\",0.221,IF(E3=\"2022-2023\",0.202,IF(E3=\"2023-2024\",0.183,IF(E3=\"2024-2025\",0.164,IF(E3=\"2025-2026\",0.145,IF(E3=\"2026-2027\",0.126,IF(E3=\"2027-2028\",0.107,IF(E3=\"2028-2029\",0.088,IF(E3=\"2029-2030\",0.069, IF(E3=\"2030-2031\",0.05,0))))))))))","v":0.16400000000000001},{"$f":"IF(OR(E3=\"2021-2022\",AND(C7=\"\",C9=\"\")),0,IF(AND(E3<>\"2021-2022\",B7=\"Yes\",C7<=D7),5,IF(AND(E3<>\"2021-2022\",B7=\"Yes\",C9>=36.7%,D9<=-1.1%),5,IF(AND(E3<>\"2021-2022\",B7=\"Yes\",C9<36.7%,D9<=-(C9*3%)),5,0))))","v":0},{"$f":"IF(AND(E3=\"2021-2022\"),0,IF(AND(E3<>\"2021-2022\",B7=\"Yes\"),5,0))","v":0}]
[null,null,"Previous Year Percent","Change",{"$f":"IF(E3=\"2021-2022\", \"*Report only for 21-22*\",\"\")","v":""}]
[null,null,null,{"$f":"C7-C9","v":0}]
["Gifted Measure","Applicable","Performance Index Percent",{"$f":"E3","v":"2024-2025"},"Points","Points Possible"]
["Gifted Performance Index","No",null,{"$f":"IF(E3=\"2021-2022\",0.95,IF(E3=\"2022-2023\",0.965,IF(E3=\"2023-2024\",0.975,IF(E3=\"2024-2025\",0.975,IF(E3=\"2025-2026\",0.975,IF(E3=\"2026-2027\",0.975,IF(E3=\"2027-2028\",0.975,IF(E3=\"2028-2029\",0.975,IF(E3=\"2029-2030\",0.975, IF(E3=\"2030-2031\",0.975,0))))))))))","v":0.97499999999999998},{"$f":"IF(AND(B11=\"Yes\",C11>=D11),5,0)","v":0},{"$f":"IF(B11=\"Yes\",5,0)","v":0}]
[null,null,"Star Rating"]
["Gifted Progress","No",null,"3, 4, 5 Star",{"$f":"IF(AND(OR(C13=\"3 Stars\",C13=\"4 Stars\",C13=\"5 Stars\"),B13=\"Yes\"),5,0)","v":0},{"$f":"IF(B13=\"Yes\",5,0)","v":0}]
[null,null,"Gifted Identification Percent"]
["Gifted Id and Services","No",null,{"$f":"IF(E3=\"2021-2022\",0.6,IF(E3=\"2022-2023\",0.7,IF(E3=\"2023-2024\",0.8,IF(E3=\"2024-2025\",0.8,IF(E3=\"2025-2026\",0.8,IF(E3=\"2026-2027\",0.8,IF(E3=\"2027-2028\",0.8,IF(E3=\"2028-2029\",0.8,IF(E3=\"2029-2030\",0.8, IF(E3=\"2030-2031\",0.8,0))))))))))","v":0.8},{"$f":"IF(AND(C15>=D15,B15=\"Yes\"),5,0)","v":0},{"$f":"IF(B15=\"Yes\",5,0)","v":0}]
["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(B17=\"Yes\",C17>=D17),5,IF(AND(B17=\"YES\",D19<>\"Error\",D19>=10%),5,0))","v":0},{"$f":"IF(B17=\"Yes\",5,0)","v":0}]
[null,null,"Previous Year Proficiency","Change"]
[null,null,null,{"$f":"IF(ISBLANK(C19),\"Error\",C17-C19)","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(B21=\"Yes\",C21>=D21),1,0)","v":0},{"$f":"IF(B21=\"Yes\",1,0)","v":0},null,null,null,null,null,null,null,null,null,"Score Range",null,null,"Stars"]
["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(B22=\"Yes\",C22>=D22),1,0)","v":0},{"$f":"IF(B22=\"Yes\",1,0)","v":0},null,null,null,null,null,null,null,null,null,0,"to",0.1,"1 Star"]
["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},0,0,null,null,null,null,null,null,null,null,null,0.1,"to",0.3,"2 Stars"]
["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},0,0,null,null,null,null,null,null,null,null,null,0.3,"to",0.45,"3 Stars"]
["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},0,0,null,null,null,null,null,null,null,null,null,0.45,"to",0.6,"4 Stars"]
["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},0,0,null,null,null,null,null,null,null,null,null,0.6,"to",1,"5 Stars"]
["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},0,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},0,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},0,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},0,0,null,null,"Measure",null,"Points Total","Points Possible"]
["ELA Growth Measure","Applicable","Growth Index",{"$f":"E3","v":"2024-2025"},"Points","Points Possible",null,null,"Chronic Absenteeism",null,{"$f":"E7","v":0},{"$f":"F7","v":0}]
["ELA Growth - All Students","No",null,2,{"$f":"IF(AND(B32=\"Yes\",C32>=D32),1,0)","v":0},{"$f":"IF(B32=\"Yes\",1,0)","v":0},null,null,"Gifted Indicator",null,{"$f":"SUM(E11,E13,E15)","v":0},{"$f":"SUM(F11,F13,F15)","v":0}]
["ELA Growth - American Indian/Alaskan Native","No",null,2,{"$f":"IF(AND(B33=\"Yes\",C33>=D33),1,0)","v":0},{"$f":"IF(B33=\"Yes\",1,0)","v":0},null,null,"ELP Indicator",null,{"$f":"SUM(E17)","v":0},{"$f":"SUM(F17)","v":0}]
["ELA Growth - Asian/Pacific Islander","No",null,2,0,0,null,null,"ELA Achievement",null,{"$f":"SUM(E21:E30)","v":0},{"$f":"SUM(F21:F30)","v":0}]
["ELA Growth - Black, Non-Hispanic","No",null,2,0,0,null,null,"ELA Growth",null,{"$f":"SUM(E32:E41)","v":0},{"$f":"SUM(F32:F41)","v":0},null,null,"Participation Demotion"]
["ELA Growth - Hispanic","No",null,2,0,0,null,null,"Math Achievement",null,{"$f":"SUM(E43:E52)","v":0},{"$f":"SUM(F43:F52)","v":0},null,null,"Participation Rate",null,"Goal ","Demotion Percentage Point Reduction"]
["ELA Growth - Multiracial","No",null,2,0,0,null,null,"Math Growth",null,{"$f":"SUM(E54:E63)","v":0},{"$f":"SUM(F54:F63)","v":0}]
["ELA Growth - White, Non-Hispanic","No",null,2,0,0,null,null,"Graduation",null,{"$f":"SUM(E65:E74)","v":0},{"$f":"SUM(F65:F74)","v":0},null,null,0.95,null,0.95,{"$f":"IF(AND(L39<>0,O38<Q38),((K39/L39) -(((K39)*(O38/Q38))/L39)),\"No Demotion\")","v":"No Demotion"}]
["ELA Growth - Economic Disadvantaged","No",null,2,0,0,null,null,"Total",null,{"$f":"SUM(K31:K38)","v":0},{"$f":"SUM(L31:L38)","v":0}]
["ELA Growth -Student with Disabilities","No",null,2,0,0]
["ELA Growth - English Learners","No",null,2,0,0]
["Math Achievement Measure","Applicable","Performance Index",{"$f":"E3","v":"2024-2025"},"Points","Points Possible"]
["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(B43=\"Yes\",C43>=D43),1,0)","v":0},{"$f":"IF(B43=\"Yes\",1,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(B44=\"Yes\",C44>=D44),1,0)","v":0},{"$f":"IF(B44=\"Yes\",1,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},0,0]
["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},0,0]
["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},0,0,null,null,null,null,null,null,null,null,"Gap Closing Percent",null,null,null,{"$f":"IF(AND(R38=\"No Demotion\",L39<>0),K39/L39,IF(L39=0,\"\",(O38/Q38)*(K39/L39)))","v":""}]
["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},0,0,null,null,null,null,null,null,null,null,"Gap Closing Rating",null,null,null,{"$f":"IF(AND(S47>=P26,L39<>0),\"5 Stars\",IF(AND(S47>=P25,S47<R25,L39<>0),\"4 Stars\",IF(AND(S47>=P24,S47<R24,L39<>0),\"3 Stars\",IF(AND(S47>=P23,S47<R23,L39<>0),\"2 Stars\",IF(AND(S47<R22,L39<>0),\"1 Star\",IF(AND(L39=0,S47=\"\"),\"Not Rated\",\"Error\"))))))","v":"Not Rated"}]
["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},0,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},0,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},0,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},0,0]
["Math Growth Measure","Applicable","Growth Index",{"$f":"E3","v":"2024-2025"},"Points","Points Possible"]
["Math Growth - All Students","No",null,2,{"$f":"IF(AND(B54=\"Yes\",C54>=D54),1,0)","v":0},{"$f":"IF(B54=\"Yes\",1,0)","v":0}]
["Math Growth - American Indian/Alaskan Native","No",null,2,{"$f":"IF(AND(B55=\"Yes\",C55>=D55),1,0)","v":0},{"$f":"IF(B55=\"Yes\",1,0)","v":0}]
["Math Growth - Asian/Pacific Islander","No",null,2,0,0]
["Math Growth - Black, Non-Hispanic","No",null,2,0,0]
["Math Growth - Hispanic","No",null,2,0,0]
["Math Growth - Multiracial","No",null,2,0,0]
["Math Growth - White, Non-Hispanic","No",null,2,0,0]
["Math Growth - Economic Disadvantaged","No",null,2,0,0]
["Math Growth - Students with Disabilities","No",null,2,0,0]
["Math Growth - English Learners","No",null,2,0,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(B65=\"Yes\",C65>=D65),1,0)","v":0},{"$f":"IF(B65=\"Yes\",1,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(B66=\"Yes\",C66>=D66),1,0)","v":0},{"$f":"IF(B66=\"Yes\",1,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},0,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},0,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},0,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},0,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},0,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},0,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},0,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},0,0]
[]
["Technical Document"]
["Report Card Resources"]

{"sheet":"Gifted Id and Srvcs - Building","index":4,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[[33,10,33,11],[34,10,34,11],[33,12,33,13],[34,12,34,13],[33,14,33,15],[34,14,34,15],[39,0,39,1],[23,14,23,15],[24,10,24,11],[25,10,25,11],[24,12,24,13],[25,12,25,13],[24,14,24,15],[25,14,25,15],[32,10,32,11],[32,12,32,13],[32,14,32,15],[33,0,33,3],[33,4,33,7],[27,0,27,3],[27,4,27,7],[28,0,28,3],[28,4,28,7],[30,0,30,7],[15,14,15,15],[16,10,16,11],[17,10,17,11],[16,14,16,15],[17,14,17,15],[9,10,9,11],[8,14,8,15],[9,14,9,15],[16,12,16,13],[17,12,17,13],[10,4,10,5],[10,6,10,7],[8,12,8,13],[9,12,9,13],[4,9,4,22],[7,10,7,11],[7,12,7,13],[7,14,7,15],[8,10,8,11],[7,0,7,7],[6,0,6,7],[8,0,8,1],[8,2,8,3],[8,4,8,5],[8,6,8,7],[23,10,23,11],[23,12,23,13],[13,0,14,7],[11,0,11,3],[11,4,11,7],[17,0,17,1],[17,2,17,3],[17,4,17,5],[17,6,17,7],[18,0,18,1],[18,2,18,3],[18,4,18,5],[15,0,15,7],[16,0,16,1],[16,2,16,3],[16,4,16,5],[16,6,16,7],[15,10,15,11],[15,12,15,13],[21,0,21,7],[22,0,22,7],[23,0,23,3],[23,4,23,7],[18,6,18,7],[37,0,37,3],[37,4,37,7],[4,0,4,8],[34,0,34,1],[34,2,34,3],[34,4,34,5],[34,6,34,7],[35,0,35,1],[35,2,35,3],[35,4,35,5],[35,6,35,7],[31,0,31,7],[32,0,32,3],[32,4,32,7],[25,0,25,1],[25,2,25,3],[25,4,25,5],[25,6,25,7],[9,0,9,1],[9,2,9,3],[9,4,9,5],[9,6,9,7],[10,0,10,1],[10,2,10,3],[26,0,26,1],[26,2,26,3],[19,0,19,3],[19,4,19,7],[26,4,26,5],[26,6,26,7],[24,0,24,3],[24,4,24,7],[36,0,36,3],[36,4,36,7]]}
["How To Use This Simulator:"]
["To use this simulator. Enter your gifted identification and served data in the input boxes below (outlined in red)."]
["Select the year to ensure the correct met % is applied."]
[]
["Building Inputs",null,null,null,null,null,null,null,null,"Point Totals"]
[]
["SUPERIOR COGNITIVE AND SPECIFIC ACADEMIC ABILITY IDENTIFICATION AND SERVICES"]
["K-12 Band",null,null,null,null,null,null,null,null,null,"Superior Cognitive",null,"Points Received",null,"Points Possible"]
["Students Identified FTE",null,"Total Students FTE",null,"Students Served FTE",null,"Students Identified FTE",null,null,null,"Identified",null,{"$f":"IF(AND(C10<15),\"<15 Students\",IF(AND(A12>=0,A12<0.1%),0,IF(AND(A12>=0.1%,A12<1%),5,IF(AND(A12>=1%,A12<2%),10,IF(AND(A12>=2%,A12<5%),15,IF(AND(A12>=5%,A12<10%),20,IF(AND(A12>=10%,A12<15%),25,IF(AND(A12>=15%),30,0))))))))","v":"<15 Students"},null,{"$f":"IF(C10<15,0,30)","v":0}]
[null,null,null,null,null,null,{"$f":"A10","v":0},null,null,null,"Served",null,{"$f":"IF(AND(G10<15),\"<15 Students\",IF(AND(E12>=0,E12<1%),0,IF(AND(E12>=1%,E12<10%),5,IF(AND(E12>=10%,E12<40%),10,IF(AND(E12>=40%,E12<60%),20,IF(AND(E12>=60%,E12<80%),30,IF(AND(E12>=80%),40)))))))","v":"<15 Students"},null,{"$f":"IF(G10<15,0,40)","v":0}]
["Percent Identified",null,"Points",null,"Percent Served",null,"Points"]
[{"$f":"A10/C10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"E10/G10","v":{"$error":"#DIV/0!"}}]
[]
["CREATIVE THINKING AND VISUAL OR PERFORMING ARTS ABILITY IDENTIFICATION AND SERVICES"]
[]
["K-12 Band",null,null,null,null,null,null,null,null,null,"Creative Thinking",null,"Points Received",null,"Points Possible"]
["Students Identified FTE",null,"Total Students FTE",null,"Students Served FTE",null,"Students Identified FTE",null,null,null,"Identified",null,{"$f":"IF(AND(C18<15),\"<15 Students\",IF(AND(A20>=0,A20<0.1%),0,IF(AND(A20>=0.1%,A20<1%),1,IF(AND(A20>=1%,A20<2%),2,IF(AND(A20>=2%,A20<3%),3,IF(AND(A20>=3%,A20<5%),4,IF(AND(A20>=5%),5,0)))))))","v":"<15 Students"},null,{"$f":"IF(C18<15,0,5)","v":0}]
[null,null,null,null,null,null,{"$f":"A18","v":0},null,null,null,"Served",null,{"$f":"IF(AND(G18<15),\"<15 Students\", IF(AND(E20>=0,E20<1%),0,IF(AND(E20>=1%,E20<10%),1,IF(AND(E20>=10%,E20<40%), 2,IF(AND(E20>=40%,E20<60%), 3,IF(AND(E20>=60%,E20<80%), 4,IF(AND(E20>=80%),5,0)))))))","v":"<15 Students"},null,{"$f":"IF(G18<15,0,5)","v":0}]
["Percent Identified",null,"Points",null,"Percent Served",null,"Points"]
[{"$f":"A18/C18","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"E18/G18","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Category","Total Points","Total Possible"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Identified",{"$f":"SUM(M9,M17,M25,M34)","v":0},{"$f":"SUM(O9,O17,O25,O34)","v":0}]
["ECONOMIC DISADVANTAGE REPRESENTATION INDEX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Served",{"$f":"SUM(M35,M26,M18,M10)","v":0},{"$f":"SUM(O10,O18,O26,O35)","v":0}]
["K-12 Band"]
["Economic Disadvantage FTE",null,null,null,"Total FTE",null,null,null,null,null,"ED Rep Index",null,"Points Received",null,"Points Possible"]
[null,null,null,null,null,null,null,null,null,null,"Identified",null,{"$f":"IF(AND(E25<15),\"<15 Students\",IF(AND(A29>=0,A29<0.4),0,IF(AND(A29>=0.4,A29<0.5),4,IF(AND(A29>=0.5,A29<0.6),8,IF(AND(A29>=0.6,A29<0.7),12,IF(AND(A29>=0.7,A29<0.8),16,(IF(AND(A29>=0.8),20,\"Error\"))))))))","v":"<15 Students"},null,{"$f":"IF(E25<15,0,20)","v":0}]
["ED Students Identified FTE",null,"Total Identified FTE",null,"ED Students Served FTE",null,"Total Served FTE",null,null,null,"Served",null,{"$f":"IF(AND(A27<15),\"<15 Students\",IF(AND(E29>=0,E29<0.4),0,IF(AND(E29>=0.4,E29<0.5),2,IF(AND(E29>=0.5,E29<0.6),4,IF(AND(E29>=0.6,E29<0.7),6,IF(AND(E29>=0.7,E29<0.8),8,IF(AND(E29>=0.8),10,\"Error\")))))))","v":"<15 Students"},null,{"$f":"IF(A27<15,0,10)","v":0}]
[]
["Representation Index",null,null,null,"Representation Index"]
[{"$f":"(A27/C27)/(A25/E25)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"(E27/G27)/(A25/E25)","v":{"$error":"#DIV/0!"}}]
[]
["UNDERREPRESENTED MINORITY REPRESENTATION INDEX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Points","Total Possible","Final Percent","Indicator"]
["K-12 Band",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T21:T22)","v":0},{"$f":"SUM(U21:U22)","v":0},{"$f":"S32/T32","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(U35=\"2021-2022\",U32>=60%),\"Met\",IF(AND(U35=\"2022-2023\",U32>=70%),\"Met\",IF(AND(U35=\"2023-2024\",U32>=80%),\"Met\",\"Not Met\")))","v":{"$error":"#DIV/0!"}}]
["Underrepresented Minority FTE",null,null,null,"Total FTE",null,null,null,null,null,"Minority Rep Index",null,"Points Received",null,"Points Possible"]
[null,null,null,null,null,null,null,null,null,null,"Identified",null,{"$f":"IF(AND(E34<15),\"<15 Students\",IF(AND(A38>=0,A38<0.4),0,IF(AND(A38>=0.4,A38<0.5),4,IF(AND(A38>=0.5,A38<0.6),8,IF(AND(A38>=0.6,A38<0.7),12,IF(AND(A38>=0.7,A38<0.8),16,(IF(AND(A38>=0.8),20,\"Error\"))))))))","v":"<15 Students"},null,{"$f":"IF(E34<15,0,20)","v":0}]
["Minority Identified FTE",null,"Total Identified FTE",null,"Minority Served FTE",null,"Total Served FTE",null,null,null,"Served",null,{"$f":"IF(AND(A36<15),\"<15 Students\",IF(AND(E38>=0,E38<0.4),0,IF(AND(E38>=0.4,E38<0.5),2,IF(AND(E38>=0.5,E38<0.6),4,IF(AND(E38>=0.6,E38<0.7),6,IF(AND(E38>=0.7,E38<0.8),8,IF(AND(E38>=0.8),10,\"Error\")))))))","v":"<15 Students"},null,{"$f":"IF(A36<15,0,10)","v":0},null,null,null,null,"Select Year","2023-2024"]
[]
["Representation Index",null,null,null,"Representation Index"]
[{"$f":"(A36/C36)/(A34/E34)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"(E36/G36)/(A34/E34)","v":{"$error":"#DIV/0!"}}]
[]
["Technical Document"]
["Report Card Resources"]

{"sheet":"Gifted Id and Srvcs - District","index":5,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[41,0,41,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[17,6,17,7],[23,0,23,1],[24,0,24,1],[23,2,23,3],[24,2,24,3],[17,0,17,1],[17,2,17,3],[17,4,17,5],[35,0,35,3],[32,0,32,1],[33,0,33,1],[32,2,32,3],[10,4,10,5],[11,4,11,5],[10,6,10,7],[11,6,11,7],[16,6,16,7],[16,4,16,5],[4,0,4,7],[4,9,4,20],[26,0,26,3],[27,0,27,3],[7,6,7,7],[6,0,6,7],[19,0,19,3],[20,0,20,3],[7,0,7,1],[7,2,7,3],[7,4,7,5],[12,0,12,7],[13,0,13,1],[13,2,13,3],[13,4,13,5],[13,6,13,7],[10,0,10,1],[11,0,11,1],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[10,2,10,3],[11,2,11,3],[16,0,16,1],[16,2,16,3],[33,2,33,3],[36,0,36,3],[37,0,37,1],[37,2,37,3],[38,0,38,1],[38,2,38,3]]}
["How To Use This Simulator:"]
["To use this simulator. Enter your gifted identification and served data in the input boxes below (outlined in red)."]
["Select the year to ensure the correct met % is applied."]
[]
["District Inputs",null,null,null,null,null,null,null,null,"Point Totals"]
[]
["SUPERIOR COGNITIVE AND SPECIFIC ACADEMIC ABILITY IDENTIFICATION"]
["K-2 Grade Band",null,"3-6 Grade Band",null,"7-8 Grade Band",null,"9-12 Grade Band",null,null,null,"Superior Cognitive","Points Received","Points Possible"]
["Students Identified FTE","Total Students FTE","Students Identified FTE","Total Students FTE","Students Identified FTE","Total Students FTE","Students Identified FTE","Total Students FTE",null,null,"Identification K-2",{"$f":"IF(AND(B10<15),\"<15 Students\",IF(AND(A12>=0.1%,A12<1%),1,IF(AND(A12>=1%,A12<2%),5,IF(AND(A12>=2%,A12<5%),9,IF(AND(A12>=5%,A12<10%),12,IF(A12>=10%,15,0))))))","v":"<15 Students"},{"$f":"IF(B10>=15,15,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Identification 3-6",{"$f":"IF(AND(D10<15),\"<15 Students\",IF(AND(C12>=0.1%,C12<3%),1,IF(AND(C12>=3%,C12<5%),2,IF(AND(C12>=5%,C12<10%),3,IF(AND(C12>=10%,C12<15%),4,IF(C12>=15%,5,0))))))","v":"<15 Students"},{"$f":"IF(D10>=15,5,0)","v":0}]
["Percent Identified",null,"Percent Identified",null,"Percent Identified",null,"Percent Identified",null,null,null,"Identification 7-8",{"$f":"IF(AND(F10<15),\"<15 Students\",IF(AND(E12>=0.1%,E12<3%),1,IF(AND(E12>=3%,E12<5%),2,IF(AND(E12>=5%,E12<10%),3,IF(AND(E12>=10%,E12<15%),4,IF(AND(E12>=15%),5,0))))))","v":"<15 Students"},{"$f":"IF(F10>=15,5,0)","v":0}]
[{"$f":"A10/B10","v":{"$error":"#DIV/0!"}},null,{"$f":"C10/D10","v":{"$error":"#DIV/0!"}},null,{"$f":"E10/F10","v":{"$error":"#DIV/0!"}},null,{"$f":"G10/H10","v":{"$error":"#DIV/0!"}},null,null,null,"Identification 9-12",{"$f":"IF(AND(H10<15),\"<15 Students\",IF(AND(G12>=0.1%,G12<3%),1,IF(AND(G12>=3%,G12<5%),2,IF(AND(G12>=5%,G12<10%),3,IF(AND(G12>=10%,G12<15%),4,IF(G12>=15%,5,0))))))","v":"<15 Students"},{"$f":"IF(H10>=15,5,0)","v":0}]
["SUPERIOR COGNITIVE AND SPECIFIC ACADEMIC ABILITY SERVED",null,null,null,null,null,null,null,null,null,"Served K-2",{"$f":"IF(AND(B16<15),\"<15 Students\",IF(AND(A18>=1%,A18<10%),2,IF(AND(A18>=10%,A18<40%),4,IF(AND(A18>=40%,A18<60%),6,IF(AND(A18>=60%,A18<80%),8,IF(A18>=80%,10,0))))))","v":"<15 Students"},{"$f":"IF(B16>=15,10,0)","v":0}]
["K-2 Grade Band",null,"3-6 Grade Band",null,"7-8 Grade Band",null,"9-12 Grade Band",null,null,null,"Served 3-6",{"$f":"IF(AND(D16<15),\"<15 Students\",IF(AND(C18>=1%,C18<20%),2,IF(AND(C18>=20%,C18<40%),4,IF(AND(C18>=40%,C18<60%),6,IF(AND(C18>=60%,C18<80%),8,IF(C18>=80%,10,0))))))","v":"<15 Students"},{"$f":"IF(D16>=15,10,0)","v":0}]
["Students Served FTE","Students Identified FTE","Students Served FTE","Students Identified FTE","Students Served FTE","Students Identified FTE","Students Served FTE","Students Identified FTE",null,null,"Served 7-8",{"$f":"IF(AND(F16<15),\"<15 Students\",IF(AND(E18>=1%,E18<20%),2,IF(AND(E18>=20%,E18<40%),4,IF(AND(E18>=40%,E18<60%),6,IF(AND(E18>=60%,E18<80%),8,IF(E18>=80%,10,0))))))","v":"<15 Students"},{"$f":"IF(F16>=15,10,0)","v":0}]
[null,{"$f":"A10","v":0},null,{"$f":"C10","v":0},null,{"$f":"E10","v":0},null,{"$f":"G10","v":0},null,null,"Served 9-12",{"$f":"IF(AND(H16<15),\"<15 Students\",IF(AND(G18>=1%,G18<20%),2,IF(AND(G18>=20%,G18<40%),4,IF(AND(G18>=40%,G18<60%),6,IF(AND(G18>=60%,G18<80%),8,IF(G18>=80%,10,0))))))","v":"<15 Students"},{"$f":"IF(H16>=15,10,0)","v":0}]
["Percent Served",null,"Percent Served",null,"Percent Served",null,"Percent Served"]
[{"$f":"A16/B16","v":{"$error":"#DIV/0!"}},null,{"$f":"C16/D16","v":{"$error":"#DIV/0!"}},null,{"$f":"E16/F16","v":{"$error":"#DIV/0!"}},null,{"$f":"G16/H16","v":{"$error":"#DIV/0!"}}]
[]
["CREATIVE THINKING AND VISUAL OR PERFORMING ARTS ABILITY IDENTIFICATION AND SERVICES",null,null,null,null,null,null,null,null,null,"Creative Thinking/Visual Arts","Points Received","Points Possible"]
["K-12 Grade Span",null,null,null,null,null,null,null,null,null,"Identified",{"$f":"IF(AND(B23<15),\"<15 Students\",IF(AND(A25>=0.1%,A25<1%),1,IF(AND(A25>=1%,A25<2%),2,IF(AND(A25>=2%,A25<5%),3,IF(AND(A25>=5%,A25<10%),4,IF(A25>=10%,5,0))))))","v":"<15 Students"},{"$f":"IF(B23<15,0,5)","v":0},null,null,"Category","Total Points","Total Possible"]
["Students Identified FTE","Total Students FTE","Students Served FTE","Students Identified FTE",null,null,null,null,null,null,"Served",{"$f":"IF(AND(D23<15),\"<15 Students\",IF(AND(C25>=1%,C25<10%),1,IF(AND(C25>=10%,C25<40%),2,IF(AND(C25>=40%,C25<60%),3,IF(AND(C25>=60%,C25<80%),4,IF(C25>=80%,5,0))))))","v":"<15 Students"},{"$f":"IF(D23<15,0,5)","v":0},null,null,"Identified",{"$f":"SUM(L9:L12,L21,L29,L38)","v":0},{"$f":"SUM(M9:M12,M21,M29,M38)","v":0}]
[null,null,null,{"$f":"A23","v":0},null,null,null,null,null,null,null,null,null,null,null,"Served",{"$f":"SUM(L13:L16,L22,L30,L39)","v":0},{"$f":"SUM(M13:M16,M22,M30,M39)","v":0}]
["Percent Identified",null,"Percent Served"]
[{"$f":"A23/B23","v":{"$error":"#DIV/0!"}},null,{"$f":"C23/D23","v":{"$error":"#DIV/0!"}}]
[]
["ECONOMIC DISADVANTAGE REPRESENTATION INDEX"]
["K-12 Grade Span",null,null,null,null,null,null,null,null,null,"ED Rep Index","Points Received","Points Possible"]
["Economic Disadvantage FTE",null,"Total FTE",null,null,null,null,null,null,null,"Identified",{"$f":"IF(AND(C30<15),\"<15 Students\",IF(AND(A34>0, A34<0.4),0,IF(AND(A34>=0.4,A34<0.5),4,IF(AND(A34>=0.5,A34<0.6),8,IF(AND(A34>=0.6,A34<0.7),12,IF(AND(A34>=0.7,A34<0.8),16,IF(AND(A34>=0.8),20,0)))))))","v":"<15 Students"},{"$f":"IF(C30<15,0,20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Served",{"$f":"IF(AND(A32<15),\"<15 Students\",IF(AND(C34>=0,C34<0.4),0,IF(AND(C34>=0.4,C34<0.5),2,IF(AND(C34>=0.5,C34<0.6),4,IF(AND(C34>=0.6, C34<0.7),6,IF(AND(C34>=0.7,C34<0.8),8,IF(AND(C34>=0.8),10,0)))))))","v":"<15 Students"},{"$f":"IF(A32<15,0,10)","v":0}]
["ED Students Identified FTE","Total Identified FTE","ED Students Served FTE","Total Served FTE"]
[]
["Representation Index",null,"Representation Index",null,null,null,null,null,null,null,null,null,null,null,null,"Total Points","Total Possible","Final Percent","Indicator"]
[{"$f":"(A32/B32)/(A30/C30)","v":{"$error":"#DIV/0!"}},null,{"$f":"(C32/D32)/(A30/C30)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q22:Q23)","v":0},{"$f":"SUM(R22:R23)","v":0},{"$f":"P34/Q34","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(R37=\"2021-2022\",R34>=60%),\"Met\",IF(AND(R37=\"2022-2023\",R34>=70%),\"Met\",IF(AND(R37=\"2023-2024\",R34>=80%),\"Met\",\"Not Met\")))","v":{"$error":"#DIV/0!"}}]
[]
["UNDERREPRESENTED MINORITY REPRESENTATION INDEX"]
["K-12 Grade Span",null,null,null,null,null,null,null,null,null,"Minority Rep Index","Points Received","Points Possible",null,null,null,"SELECT YEAR","2023-2024"]
["Underrepresented Minority FTE",null,"Total FTE",null,null,null,null,null,null,null,"Identified",{"$f":"(IF(AND(C39<15),\"<15 Students\",IF(AND(A43>=0,A43<0.4),0,IF(AND(A43>=0.4,A43<0.5),4,IF(AND(A43>=0.5,A43<0.6),8,IF(AND(A43>=0.6,A43<0.7),12,IF(AND(A43>=0.7,A43<0.8),16,IF(AND(A43>=0.8),20,0))))))))","v":"<15 Students"},{"$f":"IF(C39<15,0,20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Served",{"$f":"IF(AND(A41<15),\"<15 Students\",IF(AND(C43>=0,C43<0.4),0,IF(AND(C43>=0.4,C43<0.5),2,IF(AND(C43>=0.5,C43<0.6),4,IF(AND(C43>=0.6, C43<0.7),6,IF(AND(C43>=0.7,C43<0.8),8,IF(AND(C43>=0.8),10,0)))))))","v":"<15 Students"},{"$f":"IF(A41<15,0,10)","v":0}]
["Minority Identified FTE","Total Identified FTE","Minority Served FTE","Total Served FTE"]
[null,{"$f":"B32","v":0},null,{"$f":"D32","v":0}]
["Representation Index",null,"Representation Index"]
[{"$f":"(A41/B41)/(A39/C39)","v":{"$error":"#DIV/0!"}},null,{"$f":"(C41/D41)/(A39/C39)","v":{"$error":"#DIV/0!"}}]
[]
["Technical Document"]
["Report Card Resources"]

{"sheet":"Early Literacy","index":6,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,0,21,1],[13,18,14,21],[15,2,16,5],[17,2,17,5],[18,2,18,5],[11,18,12,21],[9,2,10,5],[11,2,11,5],[12,2,12,5],[5,0,5,6],[5,7,5,11],[5,12,5,22],[10,13,10,15]]}
["How To Use This Simulator:"]
["To use this simulator. Enter your component measure percentages in the input boxes below (outlined in red)."]
["The Improving K-3 Literacy measure also includes a question about the percent of Kindergarten student found to be \"off track\"."]
["You will need to select either Yes or No from the drop down in that input box before the simulator will preform any calculations."]
[]
["Inputs",null,null,null,null,null,null,"Measure Weighting",null,null,null,null,"Component Rating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,2]
["Promotion to Fourth Grade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,3]
["Enter a number between 0 and 100",null,"Does the building/district serve 3rd Grade?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,4]
[null,null,null,null,null,null,null,null,"Measure","Weighting","Weighted Points",null,null,"Score Range",null,null,"Stars",null,null,88,5]
[null,null,"Please Select Yes or No",null,null,null,null,null,"Promotion to Fourth Grade",{"$f":"IF(AND(K10_Yes_No=\"\",K3_Yes_No=\"\"),\"Please Select Yes or No\",IF(AND(K10_Yes_No=\"Yes\",K3_Yes_No=\"Yes\"),0.4,IF(AND(K10_Yes_No=\"No\",K3_Yes_No=\"Yes\"),0.35,IF(AND(K3_Yes_No=\"No\",K10_Yes_No=\"No\"),0,IF(AND(K3_Yes_No=\"No\",K10_Yes_No=\"Yes\"),0)))))","v":0.35},{"$f":"IF(Promo4th_weight=\"Please Select Yes or No\",0, IF(Promo4th_weight<>\"Please Select Yes or No\",Promo4th*Promo4th_weight))","v":0},null,null,0.88,"To",1,5,null,"Early Literacy\nComponent Rating"]
["Proficiency in Third Grade Reading",null,"Yes",null,null,null,null,null,"Proficiency in Third Grade Reading",{"$f":"IF(AND(K10_Yes_No=\"\", K3_Yes_No=\"\"),\"Please Select Yes or No\",IF(AND(K10_Yes_No=\"Yes\", K3_Yes_No=\"Yes\"),0.6,IF(AND(K10_Yes_No=\"No\", K3_Yes_No=\"Yes\"),0.4, IF(AND(K10_Yes_No=\"Yes\", K3_Yes_No=\"No\"),0, IF(AND(K10_Yes_No=\"No\", K3_Yes_No=\"No\"), 0)))))","v":0.4},{"$f":"IF(Prof3rd_weight=\"Please Select Yes or No\",0, IF(Prof3rd_weight<>\"Please Select Yes or No\",Prof3rd*Prof3rd_weight))","v":0},null,null,0.78,"To",0.88,4]
["Enter a number between 0 and 100",null,null,null,null,null,null,null,"Improving  K-3 Literacy",{"$f":"IF(AND(K10_Yes_No=\"\", K3_Yes_No=\"\"),\"Please Select Yes or No\",IF(AND(K10_Yes_No=\"Yes\", K3_Yes_No=\"Yes\"),0,IF(AND(K10_Yes_No=\"Yes\", K3_Yes_No=\"No\"),0,IF(AND(K10_Yes_No=\"No\", K3_Yes_No=\"Yes\"),0.25, IF(AND(K10_Yes_No=\"No\", K3_Yes_No=\"No\"),1)))))","v":0.25},{"$f":"IF(Imporv3rd_weight=\"Please Select Yes or No\",0,IF(Imporv3rd_weight<>\"Please Select Yes or No\",Improvk3*Imporv3rd_weight))","v":0},null,null,0.68,"To",0.78,3,null,{"$f":"IF(Total_Weighted_Points=0,\"\",IF(Total_Weighted_Points=\"\",\"Not Rated\",VLOOKUP(Total_Weighted_Points,T7:U11,2,TRUE)))","v":"Not Rated"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.57999999999999996,"To",0.68,2]
[null,null,"Were less than 10% of your Kindergarten students 'off track'?",null,null,null,null,null,null,null,"Total Weighted Points",null,null,0,"To",0.57999999999999996,1]
["Improving K-3 Literacy",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Promo4th=\"\",Prof3rd=\"\",Improvk3=\"\"),\"\",SUM(K12:K14))","v":""}]
["Enter a number between 0 and 100",null,"Please Select Yes or No"]
[null,null,"No"]
[null,null,null,"No","Yes"]
[]
["Technical Document"]
["Report Card Resources"]

{"sheet":"Graduation","index":7,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,1],[11,16,11,18],[10,16,10,18],[4,0,4,3],[4,4,4,9],[8,11,8,13],[4,10,4,19]]}
["How To Use This Simulator:"]
["To use this simulator enter the number of four-year graduates and five-year graduates.  Enter the number of students in the four-year graduation cohort and five-year graduation cohort"]
[]
[]
["Graduation Inputs",null,null,null,"Measure Weighting",null,null,null,null,null,"Graduation Component Rating"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Weighted Graduation Rate Range",null,null,"Stars"]
["Four-Year Graduates","Students in the Class of Prior year","Four-Year Adjusted Cohort Graduation Rate Meaure",null,null,"Weighting","Weighted Percentage ",null,null,null,null,0.96499999999999997,"To ",1,"5 Stars"]
[null,null,{"$f":"IF(OR(B11=\"\",B11=0,A11>B11),\"\",A11/B11)","v":""},null,null,{"$f":"IF(OR(B11 < 10,B11=\"\"),0,IF(B14<10,1,0.6))","v":0},{"$f":"C11*F11","v":{"$error":"#VALUE!"}},null,"Weighted Graduation Rate",null,null,0.93500000000000005,"To ",0.96499999999999997,"4 Stars",null,"Graduation Component Rating"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F14=0%,F11<>0%),G11,IF(AND(F11=0%,F14<>0%),G14,IF(AND(F11<>0%,F14<>0%),G11+G14,IF(AND(F11=0%,F14=0%),\"\",0))))","v":""},null,null,0.9,"To ",0.93500000000000005,"3 Stars",null,{"$f":"IF(AND(I12>=L10,I12<>\"\"),O10,IF(AND(I12>=L11,I12<>\"\"),O11,IF(AND(I12>=L12,I12<>\"\"),O12,IF(AND(I12>=L13,I12<>\"\"),O13,IF(I12=\"\",\"Not Rated\",O14)))))","v":"Not Rated"}]
["Five-Year Graduates","Students in the Class of 2 years Prior","Five-Year Adjusted Cohort Graduation Rate Measure",null,null,"Weighting","Weighted Percentage",null,null,null,null,0.84,"To ",0.9,"2 Stars"]
[null,null,{"$f":"IF(OR(B14=\"\",B14=0,A14>B14),\"\",A14/B14)","v":""},null,null,{"$f":"IF(OR(B14<10,B14=\"\"),0,IF(B11<10,1,0.4))","v":0},{"$f":"C14*F14","v":{"$error":"#VALUE!"}},null,null,null,null,0,"To ",0.84,"1 Star"]
[]
[]
[]
[]
[]
["Technical Document"]
["Report Card Resources"]

{"sheet":"CCWMR","index":8,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,0,3,5],[5,0,5,6],[17,12,17,15],[15,1,15,5],[13,1,14,5],[5,7,5,16],[9,8,9,10],[10,8,10,10],[16,12,16,15],[7,12,7,14],[9,1,10,5],[11,1,11,5]]}
["How To Use This Simulator:"]
["Input the number of students in the 4-year graduation cohort demonstrating post-secondary readiness and number of students in the 4-year graduation cohort"]
[]
[]
[]
["CCWMR Inputs",null,null,null,null,null,null,"CCWMR Rating"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"CCWMR Percentage",null,null,"Stars"]
[null,null,null,null,null,null,null,null,null,null,null,null,0.85,"to",1,"5 Stars"]
[null,"Number of students in the 4-year graduation cohort demonstrating post-secondary readiness",null,null,null,null,null,null,"CCWMR Percentage",null,null,null,0.75,"to",0.85,"4 Stars"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(B16<10,B16=0,B16=\"\"),\"\",ROUND(B12/B16,3))","v":""},null,null,null,0.63,"to",0.75,"3 Stars"]
[null,null,null,null,null,null,null,null,null,null,null,null,0.53,"to",0.63,"2 Stars"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"to",0.53,"1 Star"]
[null,"Number of students in the 4-year graduation cohort"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"CCWMR Rating"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I11>=M9,I11<>\"\"),P9,IF(AND(I11>=M10,I11<O10,I11<>\"\"),P10,IF(AND(I11>=M11,I11<O11,I11<>\"\"),P11,IF(AND(I11>=M12,I11<O12,I11<>\"\"),P12,IF(AND(I11>=M13,I11<O13,I11<>\"\"),P13,IF(I11=\"\",\"Not Rated\",\"Error\"))))))","v":"Not Rated"}]

{"sheet":"Overall","index":9,"n_rows":152,"n_cols":27,"rows_kept":152,"cut":false,"hidden":false,"merged":[[24,7,27,7],[32,23,32,24],[122,0,123,5],[81,3,81,4],[82,3,82,4],[99,7,99,11],[101,7,104,7],[78,7,81,7],[82,7,85,7],[86,7,89,7],[90,7,93,7],[100,8,100,10],[84,23,88,26],[79,23,83,26],[47,24,47,25],[48,24,48,25],[30,0,31,5],[36,8,36,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[50,24,50,25],[51,24,51,25],[34,8,34,9],[35,8,35,9],[56,3,56,4],[35,3,35,4],[36,3,36,4],[45,7,45,11],[55,3,55,4],[37,3,37,4],[41,3,41,4],[49,24,49,25],[4,21,4,27],[20,7,23,7],[4,6,4,20],[6,3,6,4],[6,7,6,11],[8,7,11,7],[12,7,15,7],[15,3,15,4],[16,3,16,4],[16,7,19,7],[17,3,17,4],[5,0,5,5],[4,0,4,5],[150,0,150,1],[7,8,7,10],[33,7,33,10],[47,7,50,7],[51,7,54,7],[55,7,58,7],[59,7,62,7],[63,7,66,7],[74,7,77,7],[105,7,108,7],[108,3,109,4],[109,7,112,7],[110,3,110,4],[113,7,116,7],[117,7,120,7],[72,7,72,11],[54,26,55,26],[65,23,65,25],[52,24,52,25],[53,24,53,25],[54,23,55,25],[139,7,142,7],[143,7,146,7],[42,0,43,5],[69,0,70,5],[96,0,97,5],[108,2,109,2],[134,2,135,2],[134,3,135,4],[136,3,136,4],[125,7,125,11],[126,8,126,10],[127,7,130,7],[131,7,134,7],[135,7,138,7],[73,8,73,10],[46,8,46,10]]}
["How To Use This Simulator:"]
["To use this simulator. Enter your component data in the input boxes below (outlined in red)."]
[]
[]
["Component Inputs",null,null,null,null,null,"Point Totals"]
["Achievement"]
[null,null,null,null,null,null,null,"PERFORMANCE INDEX PERCENT TO POINTS"]
[null,null,null,null,null,null,null,"Component Rating","Percentage",null,null,"Points"]
[null,null,null,null,null,null,null,"5 Star\n\n>=90%",0.95,"to",1,5]
[null,null,null,null,null,null,null,null,0.92500000000000004,"to",0.95,4.75]
[null,null,null,null,null,null,null,null,0.91,"to",0.92500000000000004,4.5]
[null,null,null,null,null,null,null,null,0.9,"to",0.91,4.25]
[null,null,null,null,null,null,null,"4 Star\n\n>=80% to <90%",0.875,"to",0.9,4]
[null,null,null,null,null,null,null,null,0.85,"to",0.875,3.75]
[null,null,null,null,null,null,null,null,0.82499999999999996,"to",0.85,3.5]
[null,null,"Applicable","PI Percentage",null,null,null,null,0.8,"to",0.82499999999999996,3.25]
[null,null,"Yes",null,null,null,null,"3 Star\n\n>=70% to <80%",0.77500000000000002,"to",0.8,3]
[null,null,null,null,null,null,null,null,0.75,"to",0.77500000000000002,2.75]
[null,null,null,null,null,null,null,null,0.72499999999999998,"to",0.75,2.5]
[null,null,null,null,null,null,null,null,0.7,"to",0.72499999999999998,2.25]
[null,null,null,null,null,null,null,"2 Star\n\n>=50% to <70%",0.65,"to",0.7,2]
[null,null,null,null,null,null,null,null,0.6,"to",0.65,1.75]
[null,null,null,null,null,null,null,null,0.55000000000000004,"to",0.6,1.5]
[null,null,null,null,null,null,null,null,0.5,"to",0.55000000000000004,1.25]
[null,null,null,null,null,null,null,"1 Star\n\n<50%",0.4,"to",0.5,1]
[null,null,null,null,null,null,null,null,0.3,"to",0.4,0.75]
[null,null,null,null,null,null,null,null,0.15,"to",0.3,0.5]
[null,null,null,null,null,null,null,null,0,"to",0.15,0]
[]
[]
["Progress"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighting Combinations"]
[null,null,null,null,null,null,null,"PROGRESS GROWTH INDEX AND EFFECT SIZE TO POINTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Achievement and Progress",{"$f":"IF(AND(S49<>\"\",S50<>\"\"),\"Y\",\"N\")","v":"Y"}]
[null,null,null,null,null,null,null,"Star Rating",null,null,"Points",null,null,null,null,null,null,null,null,null,null,null,null,"Achievement or Progress",{"$f":"IF(AND(S49<>\"\",S50=\"\"),\"Y\",IF(AND(S50<>\"\",S49=\"\"),\"Y\",\"N\"))","v":"N"}]
[null,null,"Applicable","Star Rating",null,null,null,5,"to",null,5,null,null,null,null,null,null,null,null,null,null,null,null,"Other Component Count",{"$f":"SUM(COUNTIF(C57,\"Yes\"),COUNTIF(C83,\"Yes\"),COUNTIF(C111,\"Yes\"),COUNTIF(C137,\"Yes\"))","v":4}]
[null,null,"Yes",null,null,null,null,4,"to",null,4]
[null,null,null,null,null,null,null,3,"to",null,3]
[null,null,null,null,null,null,null,2,"to",null,2]
[null,null,null,null,null,null,null,1,"to",null,1]
[]
[]
["Gap Closing"]
[]
[]
[null,null,null,null,null,null,null,"GAP CLOSING PERCENTAGE TO POINTS"]
[null,null,null,null,null,null,null,"Component Rating","Percentage",null,null,"Points"]
[null,null,null,null,null,null,null,"5 Star\n\n>=60% to 100%",0.9,"to",1,5,null,null,null,null,null,"Component","Total Points ",null,null,null,null,"Component","Weight ",null,"Points"]
[null,null,null,null,null,null,null,null,0.8,"to",0.9,4.75,null,null,null,null,null,"Achievement",{"$f":"IF(AND(D17=\"\",C17=\"Yes\"),0,IF(C17=\"No\",\"\",IF(D17>=I9,\"5.00\",IF(AND(D17>=I10,D17<K10),\"4.75\",IF(AND(D17>=I11,D17<K11),\"4.50\",IF(AND(D17>=I12,D17<K12),\"4.25\",IF(AND(D17>=I13,D17<K13),\"4.00\",IF(AND(D17>=I14,D17<K14),\"3.75\",IF(AND(D17>=I15,D17<K15),\"3.50\",IF(AND(D17>=I16,D17<K16),\"3.25\",IF(AND(D17>=I17,D17<K17),\"3.00\",IF(AND(D17>=I18,D17<K18),\"2.75\",IF(AND(D17>=I19,D17<K19),\"2.50\",IF(AND(D17>=I20,D17<K20),\"2.25\",IF(AND(D17>=I21,D17<K21),\"2.00\",IF(AND(D17>=I22,D17<K22),\"1.75\",IF(AND(D17>=I23,D17<K23),\"1.50\",IF(AND(D17>=I24,D17<K24),\"1.25\",IF(AND(D17>=I25,D17<K25),\"1.00\",IF(AND(D17>=I26,D17<K26),\"0.75\",IF(AND(D17>=I27,D17<K27),\"0.50\",IF(AND(D17>=I28,D17<K28),\"0.00\",\"Error\"))))))))))))))))))))))","v":0},null,null,null,null,"Achievement",{"$f":"IF(S49=\"\",0,IF(AND(Y34=\"Y\",S49<>\"\",Y36=4),0.25,IF(AND(Y34=\"N\",Y35=\"Y\",Y36=4),0.333333,IF(AND(S49<>\"\",Y34=\"Y\",Y35=\"N\",Y36=3),0.28601,(IF(AND(S49<>\"\",Y34=\"Y\",Y35=\"N\",Y36=2),0.3333333,IF(AND(S49<>\"\",Y35=\"Y\",Y36=3),0.4,IF(AND(S49<>\"\",Y35=\"Y\",Y36=2),0.5,IF(AND(S49<>\"\",Y35=\"Y\",Y36=1),0.666667,IF(AND(S49<>\"\",Y35=\"Y\",Y36=0),1,IF(AND(Y34=\"Y\",Y36=0),0.5,IF(AND(Y34=\"Y\",Y36=1),0.4,IF(C17=\"No\",0,\"error\")))))))))))))","v":0.25},null,{"$f":"IF(Y49=0,0,S49*Y49)","v":0}]
[null,null,null,null,null,null,null,null,0.7,"to",0.8,4.5,null,null,null,null,null,"Progress",{"$f":"IF(AND(D37=\"\",C37=\"Yes\"),0,IF(C37=\"No\",\"\",IF(OR(D37=H36,D37=\"5 Stars\"),5,IF(OR(D37=H37,D37=\"4 Stars\"),4,IF(OR(D37=H38,D37=\"3 Stars\"),3,IF(OR(D37=H39,D37=\"2 Stars\"),2,IF(OR(D37=H40,D37=\"1 Star\"),1,0)))))))","v":0},null,null,null,null,"Progress",{"$f":"IF(S50=\"\",0,IF(AND(Y34=\"Y\",S50<>\"\",Y36=4),0.25,IF(AND(Y34=\"N\",Y35=\"Y\",Y36=4),0.333333,IF(AND(S50<>\"\",Y34=\"Y\",Y35=\"N\",Y36=3),0.28601,(IF(AND(S50<>\"\",Y34=\"Y\",Y35=\"N\",Y36=2),0.3333333,IF(AND(S50<>\"\",Y35=\"Y\",Y36=3),0.4,IF(AND(S50<>\"\",Y35=\"Y\",Y36=2),0.5,IF(AND(S50<>\"\",Y35=\"Y\",Y36=1),0.666667,IF(AND(S50<>\"\",Y35=\"Y\",Y36=0),1,IF(AND(Y34=\"Y\",Y36=0),0.5,IF(AND(Y34=\"Y\",Y36=1),0.4,IF(C37=\"No\",0,\"error\")))))))))))))","v":0.25},null,0]
[null,null,null,null,null,null,null,null,0.6,"to",0.7,4.25,null,null,null,null,null,"Gap Closing",{"$f":"IF(AND(D57=\"\",C57=\"Yes\"),0,IF(C57=\"No\",\"\",IF(D57>=I48,\"5.00\",IF(AND(D57>=I49,D57<K49),\"4.75\",IF(AND(D57>=I50,D57<K50),\"4.50\",IF(AND(D57>=I51,D57<K51),\"4.25\",IF(AND(D57>=I52,D57<K52),\"4.00\",IF(AND(D57>=I53,D57<K53),\"3.75\",IF(AND(D57>=I54,D57<K54),\"3.50\",IF(AND(D57>=I55,D57<K55),\"3.25\",IF(AND(D57>=I56,D57<K56),\"3.00\",IF(AND(D57>=I57,D57<K57),\"2.75\",IF(AND(D57>=I58,D57<K58),\"2.50\",IF(AND(D57>=I59,D57<K59),\"2.25\",IF(AND(D57>=I60,D57<K60),\"2.00\",IF(AND(D57>=I61,D57<K61),\"1.75\",IF(AND(D57>=I62,D57<K62),\"1.50\",IF(AND(D57>=I63,D57<K63),\"1.25\",IF(AND(D57>=I64,D57<K64),\"1.00\",IF(AND(D57>=I65,D57<K65),\"0.75\",IF(AND(D57>=I66,D57<K66),\"0.50\",IF(AND(D57>=I67,D57<K67),\"0.00\",\"Error\"))))))))))))))))))))))","v":0},null,null,null,null,"Gap Closing",{"$f":"IF(AND(S51<>\"\",Y34=\"Y\",Y36=4),0.125,IF(AND(S51<>\"\",Y34=\"Y\",Y36=3),0.142667,IF(AND(S51<>\"\",Y34=\"Y\",Y36=2),0.166667,IF(AND(S51<>\"\",Y34=\"Y\",Y36=1),0.2,IF(AND(S51<>\"\",Y35=\"Y\",Y36=4),0.166667,IF(AND(S51<>\"\",Y35=\"Y\",Y36=3),0.2,IF(AND(S51<>\"\",Y35=\"Y\",Y36=2),0.25,IF(AND(S51<>\"\",Y35=\"Y\",Y36=1),0.333333,IF(C57=\"No\",0,IF(AND(Y34=\"N\",Y35=\"N\",S51<>\"\",Y36=4),0.25,IF(AND(Y34=\"N\",Y35=\"N\",S51<>\"\",Y36=3),0.333333,IF(AND(Y34=\"N\",Y35=\"N\",S51<>\"\",Y36=2),0.5,IF(AND(Y34=\"N\",Y35=\"N\",S51<>\"\",Y36=1),1,\"error\")))))))))))))","v":0.125},null,0]
[null,null,null,null,null,null,null,"4 Star\n\n>=45% to <60%",0.5625,"to",0.6,4,null,null,null,null,null,"Early Literacy",{"$f":"IF(AND(D83=\"\",C83=\"Yes\"),0,IF(C83=\"No\",\"\",IF(D83>=I75,\"5.00\",IF(AND(D83>=I76,D83<K76),\"4.75\",IF(AND(D83>=I77,D83<K77),\"4.50\",IF(AND(D83>=I78,D83<K78),\"4.25\",IF(AND(D83>=I79,D83<K79),\"4.00\",IF(AND(D83>=I80,D83<K80),\"3.75\",IF(AND(D83>=I81,D83<K81),\"3.50\",IF(AND(D83>=I82,D83<K82),\"3.25\",IF(AND(D83>=I83,D83<K83),\"3.00\",IF(AND(D83>=I84,D83<K84),\"2.75\",IF(AND(D83>=I85,D83<K85),\"2.50\",IF(AND(D83>=I86,D83<K86),\"2.25\",IF(AND(D83>=I87,D83<K87),\"2.00\",IF(AND(D83>=I88,D83<K88),\"1.75\",IF(AND(D83>=I89,D83<K89),\"1.50\",IF(AND(D83>=I90,D83<K90),\"1.25\",IF(AND(D83>=I91,D83<K91),\"1.00\",IF(AND(D83>=I92,D83<K92),\"0.75\",IF(AND(D83>=I93,D83<K93),\"0.50\",IF(AND(D83>=I94,D83<K94),\"0.00\",\"Error\"))))))))))))))))))))))","v":0},null,null,null,null,"Early Literacy",{"$f":"IF(AND(S52<>\"\",Y34=\"Y\",Y36=4),0.125,IF(AND(S52<>\"\",Y34=\"Y\",Y36=3),0.142667,IF(AND(S52<>\"\",Y34=\"Y\",Y36=2),0.166667,IF(AND(S52<>\"\",Y34=\"Y\",Y36=1),0.2,IF(AND(S52<>\"\",Y35=\"Y\",Y36=4),0.166667,IF(AND(S52<>\"\",Y35=\"Y\",Y36=3),0.2,IF(AND(S52<>\"\",Y35=\"Y\",Y36=2),0.25,IF(AND(S52<>\"\",Y35=\"Y\",Y36=1),0.333333,IF(C83=\"No\",0,IF(AND(Y34=\"N\",Y35=\"N\",S52<>\"\",Y36=4),0.25,IF(AND(Y34=\"N\",Y35=\"N\",S52<>\"\",Y36=3),0.333333,IF(AND(Y34=\"N\",Y35=\"N\",S52<>\"\",Y36=2),0.5,IF(AND(Y34=\"N\",Y35=\"N\",S52<>\"\",Y36=1),1,\"error\")))))))))))))","v":0.125},null,0]
[null,null,null,null,null,null,null,null,0.52500000000000002,"to",0.5625,3.75,null,null,null,null,null,"Graduation",{"$f":"IF(AND(D111=\"\",C111=\"Yes\"),0,IF(C111=\"No\",\"\",IF(D111>=I102,\"5.00\",IF(AND(D111>=I103,D111<K103),\"4.75\",IF(AND(D111>=I104,D111<K104),\"4.50\",IF(AND(D111>=I105,D111<K105),\"4.25\",IF(AND(D111>=I106,D111<K106),\"4.00\",IF(AND(D111>=I107,D111<K107),\"3.75\",IF(AND(D111>=I108,D111<K108),\"3.50\",IF(AND(D111>=I109,D111<K109),\"3.25\",IF(AND(D111>=I110,D111<K110),\"3.00\",IF(AND(D111>=I111,D111<K11),\"2.75\",IF(AND(D111>=I112,D111<K112),\"2.50\",IF(AND(D111>=I113,D111<K113),\"2.25\",IF(AND(D111>=I114,D111<K114),\"2.00\",IF(AND(D111>=I115,D111<K115),\"1.75\",IF(AND(D111>=I116,D111<K116),\"1.50\",IF(AND(D111>=I117,D111<K117),\"1.25\",IF(AND(D111>=I118,D111<K118),\"1.00\",IF(AND(D111>=I119,D111<K119),\"0.75\",IF(AND(D111>=I120,D111<K120),\"0.50\",IF(AND(D111>=I121,D111<K121),\"0.00\",\"Error\"))))))))))))))))))))))","v":0},null,null,null,null,"Graduation",{"$f":"IF(AND(S53<>\"\",Y34=\"Y\",Y36=4),0.125,IF(AND(S53<>\"\",Y34=\"Y\",Y36=3),0.142667,IF(AND(S53<>\"\",Y34=\"Y\",Y36=2),0.166667,IF(AND(S53<>\"\",Y34=\"Y\",Y36=1),0.2,IF(AND(S53<>\"\",Y35=\"Y\",Y36=4),0.166667,IF(AND(S53<>\"\",Y35=\"Y\",Y36=3),0.2,IF(AND(S53<>\"\",Y35=\"Y\",Y36=2),0.25,IF(AND(S53<>\"\",Y35=\"Y\",Y36=1),0.333333,IF(C111=\"No\",0,IF(AND(Y34=\"N\",Y35=\"N\",S53<>\"\",Y36=4),0.25,IF(AND(Y34=\"N\",Y35=\"N\",S53<>\"\",Y36=3),0.333333,IF(AND(Y34=\"N\",Y35=\"N\",S53<>\"\",Y36=2),0.5,IF(AND(Y34=\"N\",Y35=\"N\",S53<>\"\",Y36=1),1,\"error\")))))))))))))","v":0.125},null,0]
[null,null,null,null,null,null,null,null,0.48749999999999999,"to",0.52500000000000002,3.5,null,null,null,null,null,"CCWMR",{"$f":"IF(AND(D137=\"\",C137=\"Yes\"),0,IF(C137=\"No\",\"\",IF(AND(D137>=I128),L128,IF(AND(D137>=I129,D137<K129),L129,IF(AND(D137>=I130,D137<K130),L130,IF(AND(D137>=I131,D137<K131),L131,IF(AND(D137>=I132,D137<K132),L132,IF(AND(D137>=I133,D137<K133),L133,IF(AND(D137>=I134,D137<K134),L134,IF(AND(D137>=I135,D137<K135),L135,IF(AND(D137>=I136,D137<K136),L136,IF(AND(D137>=I137,D137<K137),L137,IF(AND(D137>=I138,D137<K138),L138,IF(AND(D137>=I139,D137<K139),L139,IF(AND(D137>=I140,D137<K140),L140,IF(AND(D137>=I141,D137<K141),L141,IF(AND(D137>=I142,D137<K142),L142,IF(AND(D137>=I143,D137<K143),L143,IF(AND(D137>=I144,D137<K144),L144,IF(AND(D137>=I145,D137<K145),L145,IF(AND(D137>=I146,D137<K146),L146,IF(AND(D137>=I147,D137<K147),L147,0))))))))))))))))))))))","v":0},null,null,null,null,"CCWMR",{"$f":"IF(AND(S54<>\"\",Y34=\"Y\",Y36=4),0.125,IF(AND(S54<>\"\",Y34=\"Y\",Y36=3),0.142667,IF(AND(S54<>\"\",Y34=\"Y\",Y36=2),0.166667,IF(AND(S54<>\"\",Y34=\"Y\",Y36=1),0.2,IF(AND(S54<>\"\",Y35=\"Y\",Y36=4),0.166667,IF(AND(S54<>\"\",Y35=\"Y\",Y36=3),0.2,IF(AND(S54<>\"\",Y35=\"Y\",Y36=2),0.25,IF(AND(S54<>\"\",Y35=\"Y\",Y36=1),0.333333,IF(C137=\"No\",0,IF(AND(Y34=\"N\",Y35=\"N\",S54<>\"\",Y36=4),0.25,IF(AND(Y34=\"N\",Y35=\"N\",S54<>\"\",Y36=3),0.333333,IF(AND(Y34=\"N\",Y35=\"N\",S54<>\"\",Y36=2),0.5,IF(AND(Y34=\"N\",Y35=\"N\",S54<>\"\",Y36=1),1,\"error\")))))))))))))","v":0.125},null,0]
[null,null,null,null,null,null,null,null,0.45,"to",0.48749999999999999,3.25,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(AA49:AA54)","v":0}]
[null,null,"Applicable","Percentage",null,null,null,"3 Star\n\n>=30% to <45%",0.41249999999999998,"to",0.45,3]
[null,null,"Yes",null,null,null,null,null,0.375,"to",0.41249999999999998,2.75]
[null,null,null,".",null,null,null,null,0.33750000000000002,"to",0.375,2.5]
[null,null,null,null,null,null,null,null,0.3,"to",0.33750000000000002,2.25]
[null,null,null,null,null,null,null,"2 Star\n\n>=10% to <30%",0.25,"to",0.3,2]
[null,null,null,null,null,null,null,null,0.2,"to",0.25,1.75]
[null,null,null,null,null,null,null,null,0.15,"to",0.2,1.5]
[null,null,null,null,null,null,null,null,0.1,"to",0.15,1.25]
[null,null,null,null,null,null,null,"1 Star\n\n<10%",7.4999999999999997E-2,"to",0.1,1]
[null,null,null,null,null,null,null,null,0.05,"to",7.4999999999999997E-2,0.75]
[null,null,null,null,null,null,null,null,2.5000000000000001E-2,"to",0.05,0.5,null,null,null,null,null,null,null,null,null,null,null,"Score Range",null,null,"Stars"]
[null,null,null,null,null,null,null,null,0,"to",2.5000000000000001E-2,0,null,null,null,null,null,null,null,null,null,null,null,4.125,"to",5,"5 Stars"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.625,"to",4.125,"4.5 Stars"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.125,"to",3.625,"4 Stars"]
["Early Literacy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.625,"to",3.125,"3.5 Stars"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.125,"to",2.625,"3 Stars"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.625,"to",2.125,"2.5 Stars"]
[null,null,null,null,null,null,null,"EARLY LITERACY PERCENTAGE TO POINTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.125,"to",1.625,"2 Stars"]
[null,null,null,null,null,null,null,"Component Rating","Percentage",null,null,"Points",null,null,null,null,null,null,null,null,null,null,null,0.56299999999999994,"to",1.125,"1.5 Stars"]
[null,null,null,null,null,null,null,"5 Star\n\n>=88% to 100%",0.97,"to",1,5,null,null,null,null,null,null,null,null,null,null,null,0,"to",0.56299999999999994,"1 Star"]
[null,null,null,null,null,null,null,null,0.94,"to",0.97,4.75]
[null,null,null,null,null,null,null,null,0.91,"to",0.94,4.5]
[null,null,null,null,null,null,null,null,0.88,"to",0.91,4.25]
[null,null,null,null,null,null,null,"4 Star\n\n>=78% to <88%",0.85499999999999998,"to",0.88,4]
[null,null,null,null,null,null,null,null,0.83,"to",0.85499999999999998,3.75,null,null,null,null,null,null,null,null,null,null,null,"Overall Rating"]
[null,null,null,null,null,null,null,null,0.80500000000000005,"to",0.83,3.5]
[null,null,"Applicable","Percentage",null,null,null,null,0.78,"to",0.80500000000000005,3.25]
[null,null,"Yes",null,null,null,null,"3 Star\n\n>=68% to <78%",0.755,"to",0.78,3]
[null,null,null,null,null,null,null,null,0.73,"to",0.755,2.75]
[null,null,null,null,null,null,null,null,0.70499999999999996,"to",0.73,2.5,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA55>=X67,AA67,IF(AA55>=X68,AA68,IF(AA55>=X69,AA69,IF(AA55>=X70,AA70,IF(AA55>=X71,AA71,IF(AA55>=X72,AA72,IF(AA55>=X73,AA73,IF(AA55>=X74,AA74,IF(AA55>=X75,AA75)))))))))","v":"1 Star"}]
[null,null,null,null,null,null,null,null,0.68,"to",0.70499999999999996,2.25]
[null,null,null,null,null,null,null,"2 Star\n\n>=58% to <68%",0.65500000000000003,"to",0.68,2]
[null,null,null,null,null,null,null,null,0.63,"to",0.65500000000000003,1.75]
[null,null,null,null,null,null,null,null,0.60499999999999998,"to",0.63,1.5]
[null,null,null,null,null,null,null,null,0.57999999999999996,"to",0.60499999999999998,1.25]
[null,null,null,null,null,null,null,"1 Star\n\n<58%",0.435,"to",0.57999999999999996,1]
[null,null,null,null,null,null,null,null,0.28999999999999998,"to",0.435,0.75]
[null,null,null,null,null,null,null,null,0.14499999999999999,"to",0.28999999999999998,0.5]
[null,null,null,null,null,null,null,null,0,"to",0.14499999999999999,0]
[]
[]
["Graduation"]
[]
[]
[null,null,null,null,null,null,null,"GRADUATION PERCENTAGE TO POINTS"]
[null,null,null,null,null,null,null,"Component Rating","Percentage",null,null,"Points"]
[null,null,null,null,null,null,null,"5 Star\n\n>=96.5% to 100%",0.99124999999999996,"to",1,5]
[null,null,null,null,null,null,null,null,0.98250000000000004,"to",0.99124999999999996,4.75]
[null,null,null,null,null,null,null,null,0.97375,"to",0.98250000000000004,4.5]
[null,null,null,null,null,null,null,null,0.96499999999999997,"to",0.97375,4.25]
[null,null,null,null,null,null,null,"4 Star\n\n>=93.5% to <96.5%",0.95750000000000002,"to",0.96499999999999997,4]
[null,null,null,null,null,null,null,null,0.95,"to",0.95750000000000002,3.75]
[null,null,null,null,null,null,null,null,0.9425,"to",0.95,3.5]
[null,null,"Applicable","Weighted Graduation Rate",null,null,null,null,0.93500000000000005,"to",0.9425,3.25]
[null,null,null,null,null,null,null,"3 Star\n\n>=90% to <93.5%",0.92625000000000002,"to",0.93500000000000005,3]
[null,null,"Yes",null,null,null,null,null,0.91749999999999998,"to",0.92625000000000002,2.75]
[null,null,null,null,null,null,null,null,0.90874999999999995,"to",0.91749999999999998,2.5]
[null,null,null,null,null,null,null,null,0.9,"to",0.90874999999999995,2.25]
[null,null,null,null,null,null,null,"2 Star\n\n>=84% to <90%",0.88500000000000001,"to",0.9,2]
[null,null,null,null,null,null,null,null,0.87,"to",0.88500000000000001,1.75]
[null,null,null,null,null,null,null,null,0.85499999999999998,"to",0.87,1.5]
[null,null,null,null,null,null,null,null,0.84,"to",0.85499999999999998,1.25]
[null,null,null,null,null,null,null,"1 Star\n\n<84%",0.63,"to",0.84,1]
[null,null,null,null,null,null,null,null,0.42,"to",0.63,0.75]
[null,null,null,null,null,null,null,null,0.21,"to",0.42,0.5]
[null,null,null,null,null,null,null,null,0,"to",0.21,0]
[]
["CCWMR"]
[]
[]
[null,null,null,null,null,null,null,"CCWMR PERCENTAGE TO POINTS"]
[null,null,null,null,null,null,null,"Component Rating","Percentage",null,null,"Points"]
[null,null,null,null,null,null,null,"5 Star\n\n>=85% to 100%",0.96250000000000002,"to",1,5]
[null,null,null,null,null,null,null,null,0.92500000000000004,"to",0.96250000000000002,4.75]
[null,null,null,null,null,null,null,null,0.88749999999999996,"to",0.92500000000000004,4.5]
[null,null,null,null,null,null,null,null,0.85,"to",0.88749999999999996,4.25]
[null,null,null,null,null,null,null,"4 Star\n\n>=75% to <85%",0.82499999999999996,"to",0.85,4]
[null,null,null,null,null,null,null,null,0.8,"to",0.82499999999999996,3.75]
[null,null,null,null,null,null,null,null,0.77500000000000002,"to",0.8,3.5]
[null,null,"Applicable","CCWMR Percentage",null,null,null,null,0.75,"to",0.77500000000000002,3.25]
[null,null,null,null,null,null,null,"3 Star\n\n>=63% to <75%",0.72,"to",0.75,3]
[null,null,"Yes",null,null,null,null,null,0.69,"to",0.72,2.75]
[null,null,null,null,null,null,null,null,0.66,"to",0.69,2.5]
[null,null,null,null,null,null,null,null,0.63,"to",0.66,2.25]
[null,null,null,null,null,null,null,"2 Star\n\n>=53% to <63%",0.60499999999999998,"to",0.63,2]
[null,null,null,null,null,null,null,null,0.57999999999999996,"to",0.60499999999999998,1.75]
[null,null,null,null,null,null,null,null,0.55500000000000005,"to",0.57999999999999996,1.5]
[null,null,null,null,null,null,null,null,0.53,"to",0.55500000000000005,1.25]
[null,null,null,null,null,null,null,"1 Star\n\n<53%",0.39750000000000002,"to",0.53,1]
[null,null,null,null,null,null,null,null,0.26500000000000001,"to",0.39750000000000002,0.75]
[null,null,null,null,null,null,null,null,0.13250000000000001,"to",0.26500000000000001,0.5]
[null,null,null,null,null,null,null,null,0,"to",0.13250000000000001,0]
[]
[]
[]
["Technical Document"]
["Report Card Resources"]