Spreadsheet: 124362d1318349131-prioritization-countif-function-file-for-help-with-late-prioritization
Sheet: Data

Status | Order | Part Number | Operation | Oper Description | [NAME] | Complete | Due Date | Remaing Hrs | [NAME] | [NAME] |  | Count before now date
COMING | 100 | 200 | 10 | Test | 1 | 0 | 2011-10-07 00:00:00 | 1 | Item 1 | Item 2 | 40823_1 | 1
COMING | 100 | 201 | 20 | Test | 185 | 0 | 2011-10-07 00:00:00 | 3.7 | Item 1 | Item 2 | 40823_2 | 2
COMING | 100 | 201 | 10 | Test | 1 | 0 | 2011-10-07 00:00:00 | 0.5 | Item 1 | Item 2 | 40823_3 | 3
COMING | 100 | 201 | 20 | Test | 170 | 0 | 2011-10-07 00:00:00 | 11.34 | Item 1 | Item 2 | 40823_4 | 4
COMING | 100 | 204 | 10 | Test | 1 | 0 | 2011-10-07 00:00:00 | 1.5 | Item 1 | Item 2 | 40823_5 | 5
COMING | 100 | 205 | 20 | Test | 150 | 0 | 2011-10-07 00:00:00 | 3 | Item 1 | Item 2 | 40823_6 | 6
COMING | 100 | 206 | 10 | Test | 1 | 0 | 2011-10-17 00:00:00 | 0.5 | Item 1 | Item 2 | 40833_1
COMING | 100 | 207 | 20 | Test | 5 | 0 | 2011-10-17 00:00:00 | 0.14 | Item 1 | Item 2 | 40833_2
COMING | 100 | 207 | 10 | Test | 1 | 0 | 2011-10-18 00:00:00 | 1 | Item 1 | Item 2 | 40834_1
COMING | 100 | 207 | 20 | Test | 30 | 0 | 2011-10-18 00:00:00 | 0.79 | Item 1 | Item 2 | 40834_2
COMING | 100 | 207 | 10 | Test | 1 | 0 | 2011-10-18 00:00:00 | 0.5 | Item 1 | Item 2 | 40834_3
COMING | 100 | 211 | 20 | Test | 30 | 0 | 2011-10-18 00:00:00 | 0.81 | Item 1 | Item 2 | 40834_4
STARTED | 100 | 212 | 20 | Test | 850 | 433 | 2011-09-21 00:00:00 | 20.85 | Item 1 | Item 2 | 40807_1 | 7
STARTED | 100 | 213 | 20 | Test | 850 | 481 | 2011-09-22 00:00:00 | 18.45 | Item 1 | Item 2 | 40808_1 | 8
STARTED | 100 | 214 | 20 | Test | 300 | 126 | 2011-09-30 00:00:00 | 6.96 | Item 1 | Item 2 | 40816_1 | 9
STARTED | 100 | 215 | 20 | Test | 100 | 38 | 2011-09-30 00:00:00 | 1.77 | Item 1 | Item 2 | 40816_2 | 10
STARTED | 100 | 220 | 20 | Test | 150 | 0 | 2011-10-03 00:00:00 | 10.01 | Item 1 | Item 2 | 40819_1 | 11
STARTED | 100 | 220 | 20 | Test | 100 | 100 | 2011-10-07 00:00:00 | 0 | Item 1 | Item 2 | 40823_7 | 12
STARTED | 100 | 220 | 20 | Test | 80 | 15 | 2011-10-11 00:00:00 | 1.86 | Item 1 | Item 2 | 40827_1 | 13
WAITING | 100 | 221 | 10 | Test | 1 | 0 | 2011-09-23 00:00:00 | 0.5 | Item 1 | Item 2 | 40809_1 | 14
WAITING | 100 | 222 | 20 | Test | 25 | 0 | 2011-09-23 00:00:00 | 0.5 | Item 1 | Item 2 | 40809_2 | 15
WAITING | 100 | 222 | 10 | Test | 1 | 0 | 2011-10-03 00:00:00 | 0.5 | Item 1 | Item 2 | 40819_2 | 16
WAITING | 100 | 222 | 20 | Test | 25 | 0 | 2011-10-03 00:00:00 | 1 | Item 1 | Item 2 | 40819_3 | 17
WAITING | 100 | 222 | 10 | Test | 1 | 0 | 2011-10-03 00:00:00 | 0.5 | Item 1 | Item 2 | 40819_4 | 18
WAITING | 100 | 555 | 20 | Test | 150 | 0 | 2011-10-03 00:00:00 | 4.29 | Item 1 | Item 2 | 40819_5 | 19
WAITING | 100 | 555 | 10 | Test | 1 | 0 | 2011-10-06 00:00:00 | 0.5 | Item 1 | Item 2 | 40822_1 | 20
WAITING | 100 | 555 | 20 | Test | 10 | 0 | 2011-10-06 00:00:00 | 0.33 | Item 1 | Item 2 | 40822_2 | 21
WAITING | 100 | 878 | 10 | Test | 1 | 0 | 2011-10-07 00:00:00 | 0.5 | Item 1 | Item 2 | 40823_8 | 22
WAITING | 100 | 878 | 20 | Test | 300 | 0 | 2011-10-07 00:00:00 | 12 | Item 1 | Item 2 | 40823_9 | 23
WAITING | 100 | 229 | 10 | Test | 1 | 0 | 2011-10-07 00:00:00 | 0.5 | Item 1 | Item 2 | 40823_10 | 24
WAITING | 100 | 230 | 20 | Test | 220 | 0 | 2011-10-07 00:00:00 | 11 | Item 1 | Item 2 | 40823_11 | 25
WAITING | 100 | 231 | 10 | Test | 1 | 0 | 2011-10-07 00:00:00 | 0.5 | Item 1 | Item 2 | 40823_12 | 26
WAITING | 100 | 232 | 20 | Test | 110 | 0 | 2011-10-07 00:00:00 | 3.66 | Item 1 | Item 2 | 40823_13 | 27
WAITING | 100 | 233 | 10 | Test | 1 | 0 | 2011-10-07 00:00:00 | 1 | Item 1 | Item 2 | 40823_14 | 28
WAITING | 100 | 234 | 20 | Test | 175 | 0 | 2011-10-07 00:00:00 | 2.57 | Item 1 | Item 2 | 40823_15 | 29
WAITING | 100 | 235 | 10 | Test | 1 | 0 | 2011-10-13 00:00:00 | 0.5 | Item 1 | Item 2 | 40829_1
WAITING | 100 | 236 | 20 | Test | 25 | 0 | 2011-10-13 00:00:00 | 1 | Item 1 | Item 2 | 40829_2
WAITING | 100 | 237 | 50 | Test | 1 | 0 | 2011-10-13 00:00:00 | 0.5 | Item 1 | Item 2 | 40829_3
WAITING | 100 | 238 | 60 | Test | 25 | 0 | 2011-10-13 00:00:00 | 0.5 | Item 1 | Item 2 | 40829_4
WAITING | 100 | 239 | 10 | Test | 1 | 0 | 2011-10-13 00:00:00 | 2 | Item 1 | Item 2 | 40829_5
WAITING | 100 | 240 | 20 | Test | 25 | 0 | 2011-10-13 00:00:00 | 0.63 | Item 1 | Item 2 | 40829_6
WAITING | 100 | 241 | 10 | Test | 1 | 0 | 2011-10-14 00:00:00 | 0.5 | Item 1 | Item 2 | 40830_1
WAITING | 100 | 242 | 20 | Test | 120 | 0 | 2011-10-14 00:00:00 | 0.64 | Item 1 | Item 2 | 40830_2
WAITING | 100 | 243 | 10 | Test | 1 | 0 | 2011-10-14 00:00:00 | 1 | Item 1 | Item 2 | 40830_3
WAITING | 100 | 244 | 20 | Test | 250 | 0 | 2011-10-14 00:00:00 | 7.15 | Item 1 | Item 2 | 40830_4
WAITING | 100 | 245 | 10 | Test | 1 | 0 | 2011-10-18 00:00:00 | 3 | Item 1 | Item 2 | 40834_5
WAITING | 100 | 246 | 20 | Test | 2 | 0 | 2011-10-18 00:00:00 | 0.13 | Item 1 | Item 2 | 40834_6
WAITING | 100 | 247 | 30 | Test | 1 | 0 | 2011-10-18 00:00:00 | 2 | Item 1 | Item 2 | 40834_7
WAITING | 100 | 248 | 40 | Test | 2 | 0 | 2011-10-18 00:00:00 | 0.13 | Item 1 | Item 2 | 40834_8
WAITING | 100 | 249 | 10 | Test | 1 | 0 | 2011-10-18 00:00:00 | 2 | Item 1 | Item 2 | 40834_9
WAITING | 100 | 250 | 20 | Test | 1 | 0 | 2011-10-18 00:00:00 | 0.02 | Item 1 | Item 2 | 40834_10
WAITING | 100 | 251 | 30 | Test | 1 | 0 | 2011-10-18 00:00:00 | 2 | Item 1 | Item 2 | 40834_11
WAITING | 100 | 252 | 40 | Test | 1 | 0 | 2011-10-18 00:00:00 | 0.02 | Item 1 | Item 2 | 40834_12
WAITING | 100 | 253 | 10 | Test | 1 | 0 | 2011-10-19 00:00:00 | 1.5 | Item 1 | Item 2 | 40835_1
WAITING | 100 | 254 | 20 | Test | 300 | 0 | 2011-10-19 00:00:00 | 3.99 | Item 1 | Item 2 | 40835_2
WAITING | 100 | 255 | 10 | Test | 1 | 0 | 2011-10-19 00:00:00 | 0.5 | Item 1 | Item 2 | 40835_3
WAITING | 100 | 256 | 20 | Test | 300 | 0 | 2011-10-19 00:00:00 | 6.66 | Item 1 | Item 2 | 40835_4
WAITING | 100 | 257 | 10 | Test | 1 | 0 | 2011-10-19 00:00:00 | 0.5 | Item 1 | Item 2 | 40835_5
WAITING | 100 | 258 | 20 | Test | 350 | 0 | 2011-10-19 00:00:00 | 7.77 | Item 1 | Item 2 | 40835_6
WAITING | 100 | 259 | 10 | Test | 1 | 0 | 2011-10-20 00:00:00 | 0.5 | Item 1 | Item 2 | 40836_1
WAITING | 100 | 260 | 20 | Test | 40 | 0 | 2011-10-20 00:00:00 | 2 | Item 1 | Item 2 | 40836_2
WAITING | 100 | 261 | 10 | Test | 1 | 0 | 2011-10-21 00:00:00 | 1 | Item 1 | Item 2 | 40837_1
WAITING | 100 | 262 | 20 | Test | 150 | 0 | 2011-10-21 00:00:00 | 3.75 | Item 1 | Item 2 | 40837_2
WAITING | 100 | 263 | 10 | Test | 1 | 0 | 2011-10-24 00:00:00 | 0.5 | Item 1 | Item 2 | 40840_1
WAITING | 100 | 264 | 20 | Test | 20 | 0 | 2011-10-24 00:00:00 | 0.4 | Item 1 | Item 2 | 40840_2
WAITING | 100 | 265 | 30 | Test | 1 | 0 | 2011-10-24 00:00:00 | 0.5 | Item 1 | Item 2 | 40840_3
WAITING | 100 | 266 | 40 | Test | 100 | 0 | 2011-10-24 00:00:00 | 5 | Item 1 | Item 2 | 40840_4
WAITING | 100 | 267 | 10 | Test | 1 | 0 | 2011-10-28 00:00:00 | 0.5 | Item 1 | Item 2 | 40844_1
WAITING | 100 | 268 | 20 | Test | 200 | 0 | 2011-10-28 00:00:00 | 4.44 | Item 1 | Item 2 | 40844_2
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0