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

 |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2
Thursday |  |  |  | 2 | Friday |  |  |  | 15 | Monday |  |  |  | 0 | Tuesday |  |  |  | 1 | Wednesday |  |  |  | 0 | Thursday |  |  |  | 6 | Friday |  |  |  | 4 | Monday |  |  |  | 2 | Tuesday |  |  |  | 12 | Wednesday |  |  |  | 6 | Thursday |  |  |  | 2 | Friday |  |  |  | 2 | Monday |  |  |  | 4 | Tuesday |  |  |  | 0 | Wednesday |  |  |  | 0 | Thursday |  |  |  | 0 | Friday |  |  |  | 2 | Monday |  |  |  | 0 | Tuesday |  |  |  | 0 | Wednesday |  |  |  | 0
2011-10-06 00:00:00 |  |  |  |  | 2011-10-07 00:00:00 |  |  |  |  | 2011-10-10 00:00:00 |  |  |  |  | 2011-10-11 00:00:00 |  |  |  |  | 2011-10-12 00:00:00 |  |  |  |  | 2011-10-13 00:00:00 |  |  |  |  | 2011-10-14 00:00:00 |  |  |  |  | 2011-10-17 00:00:00 |  |  |  |  | 2011-10-18 00:00:00 |  |  |  |  | 2011-10-19 00:00:00 |  |  |  |  | 2011-10-20 00:00:00 |  |  |  |  | 2011-10-21 00:00:00 |  |  |  |  | 2011-10-24 00:00:00 |  |  |  |  | 2011-10-25 00:00:00 |  |  |  |  | 2011-10-26 00:00:00 |  |  |  |  | 2011-10-27 00:00:00 |  |  |  |  | 2011-10-28 00:00:00 |  |  |  |  | 2011-10-31 00:00:00 |  |  |  |  | 2011-11-01 00:00:00 |  |  |  |  | 2011-11-02 00:00:00
shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME]
100 | 555 | 1 | 0.5 |  | 100 | 200 | 1 | 1 |  |  |  |  |  |  | 100 | 220 | 80 | 1.86 |  |  |  |  |  |  | 100 | 235 | 1 | 0.5 |  | 100 | 241 | 1 | 0.5 |  | 100 | 206 | 1 | 0.5 |  | 100 | 207 | 1 | 1 |  | 100 | 253 | 1 | 1.5 |  | 100 | 259 | 1 | 0.5 |  | 100 | 261 | 1 | 1 |  | 100 | 263 | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 267 | 1 | 0.5
100 | 555 | 10 | 0.33 |  | 100 | 201 | 185 | 3.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 236 | 25 | 1 |  | 100 | 242 | 120 | 0.64 |  | 100 | 207 | 5 | 0.14 |  | 100 | 207 | 30 | 0.79 |  | 100 | 254 | 300 | 3.99 |  | 100 | 260 | 40 | 2 |  | 100 | 262 | 150 | 3.75 |  | 100 | 264 | 20 | 0.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 268 | 200 | 4.44
 |  |  |  |  | 100 | 201 | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 237 | 1 | 0.5 |  | 100 | 243 | 1 | 1 |  |  |  |  |  |  | 100 | 207 | 1 | 0.5 |  | 100 | 255 | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  | 100 | 265 | 1 | 0.5
 |  |  |  |  | 100 | 201 | 170 | 11.34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 238 | 25 | 0.5 |  | 100 | 244 | 250 | 7.15 |  |  |  |  |  |  | 100 | 211 | 30 | 0.81 |  | 100 | 256 | 300 | 6.66 |  |  |  |  |  |  |  |  |  |  |  | 100 | 266 | 100 | 5
 |  |  |  |  | 100 | 204 | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 239 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  | 100 | 245 | 1 | 3 |  | 100 | 257 | 1 | 0.5
 |  |  |  |  | 100 | 205 | 150 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 240 | 25 | 0.63 |  |  |  |  |  |  |  |  |  |  |  | 100 | 246 | 2 | 0.13 |  | 100 | 258 | 350 | 7.77
 |  |  |  |  | 100 | 220 | 100 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 247 | 1 | 2
 |  |  |  |  | 100 | 878 | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 248 | 2 | 0.13
 |  |  |  |  | 100 | 878 | 300 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 249 | 1 | 2
 |  |  |  |  | 100 | 229 | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 250 | 1 | 0.02
 |  |  |  |  | 100 | 230 | 220 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 251 | 1 | 2
 |  |  |  |  | 100 | 231 | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 252 | 1 | 0.02
 |  |  |  |  | 100 | 232 | 110 | 3.66
 |  |  |  |  | 100 | 233 | 1 | 1
 |  |  |  |  | 100 | 234 | 175 | 2.57
Shift Length | Total run time |  | 0.8300000000000001 |  | Shift Length | Total run time |  | 52.77 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 1.86 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 5.13 |  | Shift Length | Total run time |  | 9.290000000000001 |  | Shift Length | Total run time |  | 0.64 |  | Shift Length | Total run time |  | 12.4 |  | Shift Length | Total run time |  | 20.92 |  | Shift Length | Total run time |  | 2.5 |  | Shift Length | Total run time |  | 4.75 |  | Shift Length | Total run time |  | 6.4 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 4.94 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0
15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 32 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30 |  | 15 | Available labor time |  | 30
0 | Net run time available |  | 29.17 |  | 0 | Net run time available |  | -22.77 |  | 0 | Net run time available |  | 30 |  | 0 | Net run time available |  | 28.14 |  | 0 | Net run time available |  | 30 |  | 0 | Net run time available |  | 24.87 |  | 0 | Net run time available |  | 20.71 |  | 0 | Net run time available |  | 29.36 |  | 0 | Net run time available |  | 17.6 |  | 0 | Net run time available |  | 9.079999999999998 |  | 0 | Net run time available |  | 27.5 |  | 0 | Net run time available |  | 27.25 |  | 0 | Net run time available |  | 23.6 |  | 0 | Net run time available |  | 30 |  | 0 | Net run time available |  | 30 |  | 0 | Net run time available |  | 30 |  | 0 | Net run time available |  | 25.06 |  | 0 | Net run time available |  | 30 |  | 0 | Net run time available |  | 30 |  | 0 | Net run time available |  | 30
 | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor
 | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor
 | Utilization |  | 0.02766666666666667 |  |  | Utilization |  | 1.759 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0.06200000000000001 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0.171 |  |  | Utilization |  | 0.3096666666666667 |  |  | Utilization |  | 0.02133333333333333 |  |  | Utilization |  | 0.4133333333333333 |  |  | Utilization |  | 0.6973333333333334 |  |  | Utilization |  | 0.08333333333333333 |  |  | Utilization |  | 0.1484375 |  |  | Utilization |  | 0.2133333333333333 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0.1646666666666667 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0
 | Goal |  | 11 |  |  | Goal |  | 1417 |  |  | Goal |  | 0 |  |  | Goal |  | 80 |  |  | Goal |  | 0 |  |  | Goal |  | 78 |  |  | Goal |  | 372 |  |  | Goal |  | 6 |  |  | Goal |  | 72 |  |  | Goal |  | 953 |  |  | Goal |  | 41 |  |  | Goal |  | 151 |  |  | Goal |  | 122 |  |  | Goal |  | 0 |  |  | Goal |  | 0 |  |  | Goal |  | 0 |  |  | Goal |  | 201 |  |  | Goal |  | 0 |  |  | Goal |  | 0 |  |  | Goal |  | 0
 | Pieces Per Labor Hour Goal |  | 0.3666666666666666 |  |  | Pieces Per Labor Hour Goal |  | 47.23333333333333 |  |  | Pieces Per Labor Hour Goal |  | 0 |  |  | Pieces Per Labor Hour Goal |  | 2.666666666666667 |  |  | Pieces Per Labor Hour Goal |  | 0 |  |  | Pieces Per Labor Hour Goal |  | 2.6 |  |  | Pieces Per Labor Hour Goal |  | 12.4 |  |  | Pieces Per Labor Hour Goal |  | 0.2 |  |  | Pieces Per Labor Hour Goal |  | 2.4 |  |  | Pieces Per Labor Hour Goal |  | 31.76666666666667 |  |  | Pieces Per Labor Hour Goal |  | 1.366666666666667 |  |  | Pieces Per Labor Hour Goal |  | 4.71875 |  |  | Pieces Per Labor Hour Goal |  | 4.066666666666666 |  |  | Pieces Per Labor Hour Goal |  | 0 |  |  | Pieces Per Labor Hour Goal |  | 0 |  |  | Pieces Per Labor Hour Goal |  | 0 |  |  | Pieces Per Labor Hour Goal |  | 6.7 |  |  | Pieces Per Labor Hour Goal |  | 0 |  |  | Pieces Per Labor Hour Goal |  | 0 |  |  | Pieces Per Labor Hour Goal |  | 0
 | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery |  |  |  |  | Actual Delivery
 | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour |  |  |  |  | Actual Pieces Per Labor Hour
late Items
late Items | Current Date | 2011-10-11 10:59:47 |  | 29
shop floor order | Part Number | Qty | run time | [NAME] | Origional due date | Description 1 | Description 2
100 | 200 | 1 | 1 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 201 | 185 | 3.7 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 201 | 1 | 0.5 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 201 | 170 | 11.34 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 204 | 1 | 1.5 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 205 | 150 | 3 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 212 | 850 | 20.85 |  | 2011-09-21 00:00:00 | Item 1 | Item 2
100 | 213 | 850 | 18.45 |  | 2011-09-22 00:00:00 | Item 1 | Item 2
100 | 214 | 300 | 6.96 |  | 2011-09-30 00:00:00 | Item 1 | Item 2
100 | 215 | 100 | 1.77 |  | 2011-09-30 00:00:00 | Item 1 | Item 2
100 | 220 | 150 | 10.01 |  | 2011-10-03 00:00:00 | Item 1 | Item 2
100 | 220 | 100 | 0 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 220 | 80 | 1.86 |  | 2011-10-11 00:00:00 | Item 1 | Item 2
100 | 221 | 1 | 0.5 |  | 2011-09-23 00:00:00 | Item 1 | Item 2
100 | 222 | 25 | 0.5 |  | 2011-09-23 00:00:00 | Item 1 | Item 2
100 | 222 | 1 | 0.5 |  | 2011-10-03 00:00:00 | Item 1 | Item 2
100 | 222 | 25 | 1 |  | 2011-10-03 00:00:00 | Item 1 | Item 2
100 | 222 | 1 | 0.5 |  | 2011-10-03 00:00:00 | Item 1 | Item 2
100 | 555 | 150 | 4.29 |  | 2011-10-03 00:00:00 | Item 1 | Item 2
100 | 555 | 1 | 0.5 |  | 2011-10-06 00:00:00 | Item 1 | Item 2
100 | 555 | 10 | 0.33 |  | 2011-10-06 00:00:00 | Item 1 | Item 2
100 | 878 | 1 | 0.5 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 878 | 300 | 12 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 229 | 1 | 0.5 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 230 | 220 | 11 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 231 | 1 | 0.5 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 232 | 110 | 3.66 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 233 | 1 | 1 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
100 | 234 | 175 | 2.57 |  | 2011-10-07 00:00:00 | Item 1 | Item 2
Sum |  | 3961 | 120.79
Capacities for CNC
Daily Capacity | Current Week | 2nd Week |  | 3rd Week |  | 4th Week
450 | 0.3697333333333334 | 0.3225333333333333 |  | 0.08902083333333333 |  | 0.03293333333333334