Spreadsheet: 548669d1511268007-using-structure-table-references-in-conditional-formatting-formulae-sampleforforum-v2
Sheet: Sheet2

 |  |  |  |  | Mathematics |  | Reading |  | Language Usage |  | Science |  | Mathematics |  |  |  |  |  | Reading |  |  |  |  |  | Language Usage |  |  |  |  |  | Science
AcadYear | Term | Grade | Name | ID | BY Mean | BY SD | BY Mean | BY SD | BY Mean | BY SD | BY Mean | BY SD | RIT-Low | RIT | RIT-High | Percent-Low | Percentile | Percent-High | RIT-Low | RIT | RIT-High | Percent-Low | Percentile | Percent-High | RIT-Low | RIT | RIT-High | Percent-Low | Percentile | Percent-High | RIT-Low | RIT | RIT-High | Percent-Low | Percentile | Percent-High
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 217 | 220 | 223 | 50 | 58 | 65 | 209 | 212 | 216 | 45 | 54 | 63 | 206 | 209 | 212 | 38 | 47 | 55 | 206 | 209 | 212 | 56 | 67 | 77
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 212 | 215 | 218 | 37 | 45 | 52 | 222 | 225 | 228 | 77 | 83 | 88 | 206 | 209 | 212 | 38 | 47 | 55 | 202 | 205 | 208 | 43 | 54 | 64
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 207 | 210 | 213 | 26 | 32 | 39 | 229 | 232 | 235 | 89 | 92 | 95 | 205 | 208 | 211 | 36 | 44 | 52 | 204 | 207 | 210 | 50 | 61 | 71
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 222 | 225 | 228 | 63 | 70 | 76 | 216 | 219 | 223 | 63 | 71 | 79 | 215 | 218 | 221 | 63 | 71 | 78 | 216 | 219 | 223 | 84 | 90 | 95
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 217 | 220 | 223 | 50 | 58 | 65 | 199 | 202 | 205 | 21 | 29 | 37 | 209 | 212 | 215 | 47 | 55 | 63 | 201 | 204 | 207 | 40 | 50 | 61
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 212 | 215 | 218 | 37 | 45 | 52 | 220 | 223 | 226 | 73 | 80 | 85 | 210 | 213 | 216 | 49 | 58 | 66 | 203 | 206 | 209 | 46 | 57 | 68
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 209 | 212 | 215 | 30 | 37 | 44 | 193 | 196 | 199 | 12 | 17 | 23 | 191 | 194 | 197 | 8 | 12 | 17 | 196 | 199 | 202 | 24 | 33 | 44
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 215 | 218 | 221 | 45 | 52 | 60 | 216 | 219 | 222 | 64 | 71 | 78 | 209 | 212 | 215 | 47 | 55 | 63 | 198 | 201 | 204 | 29 | 40 | 52
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 231 | 234 | 237 | 82 | 86 | 90 | 233 | 236 | 239 | 93 | 95 | 97 | 232 | 235 | 238 | 94 | 96 | 98 | 220 | 223 | 226 | 92 | 95 | 97
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 228 | 231 | 234 | 76 | 82 | 86 | 210 | 213 | 216 | 48 | 57 | 65 | 208 | 211 | 214 | 44 | 52 | 60 | 203 | 206 | 209 | 46 | 57 | 68
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 205 | 208 | 211 | 22 | 28 | 35 | 214 | 217 | 220 | 59 | 67 | 74 | 194 | 197 | 200 | 12 | 17 | 23 | 204 | 207 | 210 | 50 | 61 | 71
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 216 | 219 | 222 | 48 | 55 | 62 | 215 | 218 | 221 | 61 | 69 | 76 | 208 | 211 | 214 | 44 | 52 | 60 | 205 | 208 | 211 | 53 | 64 | 74
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 230 | 233 | 236 | 80 | 85 | 89 | 222 | 225 | 228 | 77 | 83 | 88 | 222 | 225 | 228 | 80 | 86 | 90 | 204 | 208 | 212 | 52 | 64 | 75
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 195 | 198 | 201 | 8 | 11 | 15 | 183 | 187 | 191 | 4 | 6 | 10 | 181 | 184 | 187 | 2 | 3 | 5 | 178 | 181 | 184 | 1 | 2 | 4
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 214 | 217 | 220 | 42 | 50 | 57 | 206 | 209 | 212 | 38 | 46 | 55 | 212 | 215 | 218 | 55 | 63 | 71 | 200 | 203 | 206 | 35 | 47 | 59
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 217 | 220 | 223 | 50 | 58 | 65 | 217 | 220 | 223 | 66 | 74 | 80 | 209 | 212 | 215 | 47 | 55 | 63 | 211 | 214 | 217 | 72 | 81 | 88
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 230 | 233 | 236 | 80 | 85 | 89 | 216 | 219 | 222 | 63 | 71 | 79 | 221 | 224 | 227 | 78 | 84 | 89 | 212 | 215 | 218 | 75 | 83 | 90
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 218 | 221 | 224 | 52 | 60 | 67 | 228 | 231 | 234 | 87 | 91 | 94 | 223 | 226 | 229 | 82 | 87 | 91 | 219 | 222 | 226 | 90 | 94 | 97
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 207 | 210 | 213 | 26 | 32 | 40 | 204 | 207 | 210 | 33 | 41 | 49 | 198 | 201 | 204 | 19 | 25 | 32 | 194 | 197 | 200 | 19 | 27 | 38
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 239 | 242 | 245 | 92 | 95 | 96 | 226 | 229 | 232 | 84 | 89 | 93 | 222 | 225 | 228 | 80 | 86 | 90 | 214 | 217 | 221 | 80 | 87 | 92
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 208 | 211 | 214 | 28 | 35 | 42 | 192 | 195 | 198 | 10 | 15 | 21 | 187 | 190 | 193 | 5 | 7 | 11 | 189 | 192 | 195 | 9 | 15 | 22
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 212 | 215 | 218 | 37 | 45 | 52 | 208 | 211 | 214 | 42 | 51 | 60 | 202 | 205 | 208 | 28 | 35 | 44 | 199 | 202 | 205 | 32 | 43 | 55
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 214 | 217 | 220 | 42 | 50 | 57 | 205 | 208 | 212 | 35 | 43 | 53 | 201 | 204 | 207 | 26 | 33 | 41 | 200 | 203 | 206 | 36 | 47 | 58
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 231 | 234 | 237 | 82 | 86 | 90 | 207 | 210 | 213 | 40 | 49 | 57 | 213 | 216 | 219 | 58 | 66 | 73 | 217 | 220 | 224 | 86 | 92 | 96
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 230 | 233 | 236 | 80 | 85 | 89 | 225 | 228 | 231 | 83 | 88 | 92 | 218 | 221 | 224 | 71 | 78 | 84 | 208 | 211 | 214 | 63 | 73 | 82
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 216 | 219 | 222 | 48 | 55 | 62 | 226 | 229 | 232 | 84 | 89 | 93 | 227 | 230 | 233 | 89 | 92 | 95 | 200 | 204 | 208 | 38 | 50 | 62
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 234 | 237 | 240 | 86 | 90 | 93 | 220 | 223 | 226 | 73 | 80 | 85 | 218 | 221 | 224 | 72 | 78 | 84 | 211 | 214 | 218 | 72 | 81 | 88
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 221 | 224 | 227 | 60 | 67 | 74 | 221 | 224 | 227 | 75 | 82 | 87 | 214 | 217 | 220 | 61 | 69 | 76 | 208 | 211 | 214 | 63 | 73 | 82
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 230 | 233 | 236 | 80 | 85 | 89 | 231 | 234 | 237 | 91 | 94 | 96 | 228 | 231 | 234 | 90 | 93 | 96 | 206 | 209 | 213 | 55 | 67 | 77
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 204 | 207 | 210 | 19 | 26 | 33 | 198 | 201 | 204 | 20 | 26 | 34 | 194 | 197 | 200 | 12 | 17 | 23 | 195 | 198 | 202 | 21 | 30 | 42
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 216 | 219 | 222 | 48 | 55 | 62 | 213 | 216 | 219 | 56 | 64 | 72 | 208 | 211 | 214 | 44 | 52 | 61 | 200 | 203 | 206 | 36 | 47 | 58
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 210 | 213 | 216 | 33 | 40 | 47 | 218 | 221 | 224 | 68 | 76 | 82 | 210 | 213 | 216 | 50 | 58 | 66 | 206 | 209 | 212 | 57 | 67 | 77
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 219 | 222 | 225 | 55 | 63 | 70 | 213 | 216 | 219 | 56 | 64 | 72 | 206 | 209 | 212 | 38 | 47 | 55 | 196 | 199 | 202 | 24 | 33 | 44
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 227 | 230 | 233 | 74 | 80 | 85 | 206 | 209 | 212 | 38 | 46 | 55 | 211 | 214 | 217 | 53 | 61 | 69 | 195 | 198 | 201 | 22 | 30 | 40
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 225 | 228 | 231 | 70 | 76 | 81 | 221 | 224 | 227 | 75 | 82 | 87 | 227 | 230 | 233 | 89 | 92 | 95 | 213 | 216 | 219 | 78 | 85 | 91
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 238 | 241 | 244 | 91 | 94 | 96 | 207 | 210 | 213 | 40 | 49 | 58 | 218 | 221 | 224 | 72 | 78 | 84 | 198 | 201 | 204 | 30 | 40 | 51
2017-2018 | Fall | 6 |  |  |  |  |  |  |  |  |  |  | 214 | 217 | 220 | 42 | 50 | 58 | 203 | 206 | 209 | 30 | 38 | 47 | 207 | 210 | 213 | 41 | 49 | 58 | 204 | 207 | 210 | 50 | 61 | 71