Spreadsheet: 122123d1316621937-if-a-row-of-data-has-a-date-less-than-todays-date-how-do-you-pull-all-that-data-helpforlateitems
Sheet: Sheet1

Input name of cell |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 8 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2 |  |  |  | Personnel | 2
Monday |  |  |  | 1 | Tuesday |  |  |  | 2 | Wednesday |  |  |  | 0 | Thursday |  |  |  | 11 | Friday |  |  |  | 0 | Monday |  |  |  | 20 | Tuesday |  |  |  | 2 | Wednesday |  |  |  | 3 | Thursday |  |  |  | 11 | Friday |  |  |  | 4 | Monday |  |  |  | 14 | Tuesday |  |  |  | 4 | Wednesday |  |  |  | 0 | Thursday |  |  |  | 0 | Friday |  |  |  | 0 | Monday |  |  |  | 0 | Tuesday |  |  |  | 0 | Wednesday |  |  |  | 0 | Thursday |  |  |  | 0 | Friday |  |  |  | 1
2011-09-19 00:00:00 |  |  |  |  | 2011-09-20 00:00:00 |  |  |  |  | 2011-09-21 00:00:00 |  |  |  |  | 2011-09-22 00:00:00 |  |  |  |  | 2011-09-23 00:00:00 |  |  |  |  | 2011-09-26 00:00:00 |  |  |  |  | 2011-09-27 00:00:00 |  |  |  |  | 2011-09-28 00:00:00 |  |  |  |  | 2011-09-29 00:00:00 |  |  |  |  | 2011-09-30 00:00:00 |  |  |  |  | 2011-10-03 00:00:00 |  |  |  |  | 2011-10-04 00:00:00 |  |  |  |  | 2011-10-05 00:00:00 |  |  |  |  | 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
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]
32 | 131 | 5 | 0.33 |  | 33 | 132 | 198 | 6.59 |  |  |  |  |  |  | 35 | 134 | 20 | 2.5 |  |  |  |  |  |  | 3 | 102 | 180 | 7.14 |  | 65 | 164 | 5 | 0.5 |  | 67 | 166 | 3 | 0.6 |  | 70 | 169 | 610 | 20.31 |  | 81 | 180 | 20 | 2.5 |  | 85 | 184 | 7 | 0.7 |  | 99 | 198 | 5 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103 | 202 | 500 | 16.65
 |  |  |  |  | 34 | 133 | 10 | 1.43 |  |  |  |  |  |  | 36 | 135 | 20 | 2.5 |  |  |  |  |  |  | 46 | 145 | 3 | 0.3 |  | 66 | 165 | 27 | 2.7 |  | 68 | 167 | 4 | 0.2 |  | 71 | 170 | 10 | 1.25 |  | 82 | 181 | 25 | 2.5 |  | 86 | 185 | 11 | 1.1 |  | 100 | 199 | 10 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 136 | 100 | 10 |  |  |  |  |  |  | 47 | 146 | 50 | 6.26 |  |  |  |  |  |  | 69 | 168 | 3 | 0.15 |  | 72 | 171 | 100 | 12.52 |  | 83 | 182 | 20 | 2 |  | 87 | 186 | 25 | 2.5 |  | 101 | 200 | 10 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 137 | 200 | 20 |  |  |  |  |  |  | 48 | 147 | 18 | 1.8 |  |  |  |  |  |  |  |  |  |  |  | 73 | 172 | 600 | 60 |  | 84 | 183 | 25 | 2.5 |  | 88 | 187 | 10 | 1.43 |  | 102 | 201 | 3 | 0.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 138 | 20 | 2 |  |  |  |  |  |  | 49 | 148 | 180 | 18 |  |  |  |  |  |  |  |  |  |  |  | 74 | 173 | 4 | 0.4 |  |  |  |  |  |  | 89 | 188 | 5 | 0.71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 139 | 20 | 2 |  |  |  |  |  |  | 50 | 149 | 25 | 2.5 |  |  |  |  |  |  |  |  |  |  |  | 75 | 174 | 800 | 80 |  |  |  |  |  |  | 90 | 189 | 23 | 3.84
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 140 | 20 | 2 |  |  |  |  |  |  | 51 | 150 | 25 | 2.5 |  |  |  |  |  |  |  |  |  |  |  | 76 | 175 | 5 | 0.5 |  |  |  |  |  |  | 91 | 190 | 2 | 0.33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 141 | 8 | 1.14 |  |  |  |  |  |  | 52 | 151 | 10 | 1.43 |  |  |  |  |  |  |  |  |  |  |  | 77 | 176 | 800 | 80 |  |  |  |  |  |  | 92 | 191 | 14 | 2.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 142 | 40 | 2 |  |  |  |  |  |  | 53 | 152 | 7 | 1.4 |  |  |  |  |  |  |  |  |  |  |  | 78 | 177 | 1 | 0.1 |  |  |  |  |  |  | 93 | 192 | 2 | 0.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 143 | 4 | 0.2 |  |  |  |  |  |  | 54 | 153 | 6 | 1.2 |  |  |  |  |  |  |  |  |  |  |  | 79 | 178 | 100 | 20 |  |  |  |  |  |  | 94 | 193 | 5 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 144 | 10 | 0.5 |  |  |  |  |  |  | 55 | 154 | 6 | 1.2 |  |  |  |  |  |  |  |  |  |  |  | 80 | 179 | 6 | 0.3 |  |  |  |  |  |  | 95 | 194 | 20 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 | 155 | 1 | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96 | 195 | 20 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | 156 | 14 | 0.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97 | 196 | 15 | 0.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | 157 | 100 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98 | 197 | 2 | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59 | 158 | 11 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 159 | 4 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 | 160 | 11 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | 161 | 12 | 0.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 | 162 | 3 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 | 163 | 6 | 0.86
Shift Length | Total run time |  | 0.33 |  | Shift Length | Total run time |  | 8.02 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 44.84 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 52.39 |  | Shift Length | Total run time |  | 3.2 |  | Shift Length | Total run time |  | 0.9500000000000001 |  | Shift Length | Total run time |  | 275.3800000000001 |  | Shift Length | Total run time |  | 9.5 |  | Shift Length | Total run time |  | 17.66 |  | Shift Length | Total run time |  | 3.1 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 16.65
7.5 | Available labor time |  | 15 |  | 7.5 | Available labor time |  | 15 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 32 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 60 |  | 7.5 | Available labor time |  | 15 |  | 7.5 | Available labor time |  | 15 |  | 7.5 | Available labor time |  | 15 |  | 7.5 | Available labor time |  | 15 |  | 7.5 | Available labor time |  | 15 |  | 7.5 | Available labor time |  | 15
0 | Net run time available |  | 14.67 |  | 0 | Net run time available |  | 6.98 |  | 0 | Net run time available |  | 60 |  | 0 | Net run time available |  | 15.16 |  | 0 | Net run time available |  | 60 |  | 0 | Net run time available |  | 7.609999999999999 |  | 0 | Net run time available |  | 56.8 |  | 0 | Net run time available |  | 59.05 |  | 0 | Net run time available |  | -215.3800000000001 |  | 0 | Net run time available |  | 50.5 |  | 0 | Net run time available |  | 42.34 |  | 0 | Net run time available |  | 28.9 |  | 0 | Net run time available |  | 60 |  | 0 | Net run time available |  | 60 |  | 0 | Net run time available |  | 15 |  | 0 | Net run time available |  | 15 |  | 0 | Net run time available |  | 15 |  | 0 | Net run time available |  | 15 |  | 0 | Net run time available |  | 15 |  | 0 | Net run time available |  | -1.649999999999999
 | 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.022 |  |  | Utilization |  | 0.5346666666666666 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0.7473333333333334 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0.8731666666666666 |  |  | Utilization |  | 0.05333333333333334 |  |  | Utilization |  | 0.01583333333333333 |  |  | Utilization |  | 4.589666666666668 |  |  | Utilization |  | 0.1583333333333333 |  |  | Utilization |  | 0.2943333333333334 |  |  | Utilization |  | 0.096875 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0 |  |  | Utilization |  | 0 |  |  | Utilization |  | 1.11
late Items | Current Date | 2011-09-21 11:18:45
shop floor order | Part Number | Qty | Run Time | [NAME] | Origional due date
Capacities for CNC
Daily Capacity | Current Week | 2nd Week |  | 3rd Week |  | 4th Week
450 | 0.2608 | 1.138066666666667 |  | 0.07824166666666668 |  | 0.222