Spreadsheet: 36420d1234301928-using-lists-function-in-excel-test-file-open
Sheet: PLANNING

Outstanding Work | 2008-01-01 00:00:00 |  |  |  | 2008-02-01 00:00:00 |  |  | 2008-03-01 00:00:00 |  |  | 2008-04-01 00:00:00 |  |  | 2008-05-01 00:00:00 |  |  | 2008-06-01 00:00:00 |  |  | 2008-07-01 00:00:00 |  |  | 2008-08-01 00:00:00 |  |  | 2008-09-01 00:00:00 |  |  | 2008-10-01 00:00:00 |  |  | 2008-11-01 00:00:00 |  |  | 2008-12-01 00:00:00 |  |  | 2009-01-01 00:00:00
 | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | New | Done | O/S | Prv Pend | Received | Processed | Pending
1A | 253 | 843 | 846 | 250 | 561 | 396 | 415 | 1606 | 1014 | 1007 | 1781 | 934 | 1854 | 2646 | 1243 | 3257 | 2114 | 1378 | 3993 | 1830 | 1476 | 4347 | 1856 | 2094 | 4109 | 1101 | 1622 | 3588 | 900 | 2702 | 1786 | 586 | 1992 | 380 | 629 | 704 | 305 |  |  | 0
1B | 202 | 100 | 100 | 278 | 100 | 100 | 1424 | 100 | 100 | 1899 | 100 | 100 | 1236 | 100 | 100 | 2189 | 100 | 100 | 551 |  |  | 906 |  |  | 90 |  |  | 937 |  |  | 606 |  |  | 289 |  |  | 99
1C | 794 | 2262 | 2122 | 934 | 1389 | 1206 | 1117 | 2551 | 1958 | 1710 | 2628 | 1375 | 2963 | 2954 | 2144 | 3773 | 2910 | 1654 | 5029 | 2684 | 2469 | 5244 | 3120 | 1951 | 6413 | 2677 | 6051 | 3039 | 2677 | 2588 | 3128 | 2301 | 3264 | 2165 | 2345 | 3142 | 1368 |  |  | 0
Blend | 1047 | 3105 | 2968 | 1184 | 1950 | 1602 | 1532 | 4157 | 2972 | 2717 | 4409 | 2309 | 4817 | 5600 | 3387 | 7030 | 5024 | 3032 | 9022 | 4514 | 3945 | 9591 | 4976 | 4045 | 10522 | 3778 | 7673 | 6627 | 3577 | 5290 | 4914 | 2887 | 5256 | 2545 | 2974 | 3846 | 1673 |  |  | 0
Actual Numbers Worked |  | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Staff1 | Staff2 | Total | Brk Total | Co. Total | Grand total
A |  |  | 530 | 530 |  | 390 | 390 |  | 465 | 465 |  | 944 | 944 |  | 1028 | 1028 |  | 944 | 944 |  | 1005 | 1005 |  | 860 | 860 |  | 769 | 769 |  | 847 | 847 |  | 606 | 606 |  | 511 | 511 | 0 | 8899 | 8899
B |  |  | 469 | 469 |  | 316 | 316 |  | 262 | 262 |  | 451 | 451 |  | 709 | 709 |  | 834 | 834 |  | 659 | 659 |  | 575 | 575 |  | 593 | 593 |  | 426 | 426 |  | 375 | 375 |  | 408 | 408 | 0 | 6077 | 6077
C |  |  | 1446 | 1446 |  | 935 | 935 |  | 769 | 769 |  | 896 | 896 |  | 1371 | 1371 |  | 1124 | 1124 |  | 1019 | 1019 |  | 886 | 886 |  | 2788 | 2788 |  | 1662 | 1662 |  | 2126 | 2126 |  | 2158 | 2158 | 0 | 17180 | 17180
D |  |  | 117 | 117 |  | 92 | 92 |  | 103 | 103 |  | 124 | 124 |  | 136 | 136 |  | 130 | 130 |  | 187 | 187 |  | 156 | 156 |  | 223 | 223 |  | 179 | 179 |  | 164 | 164 |  | 116 | 116 | 0 | 1727 | 1727
E |  |  | 59 | 59 |  | 63 | 63 |  | 114 | 114 |  | 229 | 229 |  | 304 | 304 |  | 175 | 175 |  | 124 | 124 |  | 179 | 179 |  | 137 | 137 |  | 132 | 132 |  | 117 | 117 |  | 107 | 107 | 0 | 1740 | 1740
F |  |  | 86 | 86 |  | 42 | 42 |  | 62 | 62 |  | 73 | 73 |  | 95 | 95 |  | 148 | 148 |  | 106 | 106 |  | 128 | 128 |  | 167 | 167 |  | 95 | 95 |  | 65 | 65 |  | 57 | 57 | 0 | 1124 | 1124
G |  | 15 | 766 | 781 | 5 | 454 | 459 | 9 | 527 | 536 | 38 | 1275 | 1313 | 36 | 1525 | 1561 | 46 | 2408 | 2454 | 6 | 2247 | 2253 | 31 | 1202 | 1233 | 24 | 1096 | 1120 | 22 | 3502 | 3524 | 33 | 772 | 805 | 8 | 636 | 644 | 273 | 16410 | 16683
H |  |  | 166 | 166 |  | 129 | 129 |  | 74 | 74 |  | 155 | 155 |  | 174 | 174 |  | 134 | 134 |  | 209 | 209 |  | 190 | 190 |  | 241 | 241 |  | 257 | 257 |  | 309 | 309 |  | 245 | 245 | 0 | 2283 | 2283
I |  |  | 188 | 188 |  | 138 | 138 |  | 123 | 123 |  | 141 | 141 |  | 183 | 183 |  | 265 | 265 |  | 221 | 221 |  | 205 | 205 |  | 238 | 238 |  | 163 | 163 |  | 137 | 137 |  | 129 | 129 | 0 | 2131 | 2131
J |  |  | 53 | 53 |  | 37 | 37 |  | 81 | 81 |  | 115 | 115 |  | 56 | 56 |  | 39 | 39 |  | 73 | 73 |  | 59 | 59 |  | 6 | 6 |  | 16 | 16 |  | 27 | 27 |  | 31 | 31 | 0 | 593 | 593
K |  |  | 906 | 906 |  | 500 | 500 |  | 378 | 378 |  | 806 | 806 |  | 938 | 938 |  | 675 | 675 |  | 544 | 544 |  | 928 | 928 |  | 995 | 995 |  | 511 | 511 |  | 566 | 566 |  | 670 | 670 | 0 | 8417 | 8417
L |  |  | 1 | 1 |  | 0 | 0 |  | 3 | 3 |  | 1 | 1 |  | 2 | 2 |  | 1 | 1 |  | 1 | 1 |  |  |  |  | 1 | 1 |  | 1 | 1 |  |  |  |  | 4 | 4 | 0 | 15 | 15
M |  |  | 6 | 6 |  | 11 | 11 |  | 2 | 2 |  | 12 | 12 |  | 16 | 16 |  | 17 | 17 |  | 3 | 3 |  | 10 | 10 |  | 12 | 12 |  | 14 | 14 |  | 13 | 13 |  | 8 | 8 | 0 | 124 | 124
N |  |  |  | 4 |  |  | 1 |  |  | 2 |  |  | 2 |  |  | 6 |  |  | 5 |  |  | 5 |  |  | 3 |  |  | 2 |  |  | 8 |  |  | 9 |  |  | 2 | 0 | 0 | 49
Grand Total |  | 15 | 4793 | 4812 | 5 | 3107 | 3113 | 9 | 2963 | 2974 | 38 | 5222 | 5262 | 36 | 6537 | 6579 | 46 | 6894 | 6945 | 6 | 6398 | 6409 | 31 | 5378 | 5412 | 24 | 7266 | 7292 | 22 | 7805 | 7835 | 33 | 5277 | 5319 | 8 | 5080 | 5090 | 273 | 66720 | 67042
O/S Work Estimation | B25 | C25 | D25 | E25 | F25 | G25 | H25
 | Weight Factor | % | Est. O/S | Total Avlbl. | % | Est. O/S | Total Avlbl.
1 | 1A | 0.2281021897810219 | 120.8941605839416 | 650.8941605839416 | 0.5117139334155364 | 199.5684340320592 | 589.5684340320593
2 | 1B | 0.9205298013245033 | 431.7284768211921 | 900.7284768211921 | 3.767195767195767 | 1190.433862433862 | 1506.433862433862
3 | 1C | 0.3056282722513089 | 441.9384816753927 | 1887.938481675393 | 0.4808437365475678 | 449.5888936719759 | 1384.588893671976
4 | Blend | 0.2851637764932562 | 33.36416184971098 | 150.364161849711 | 0.4888321633694959 | 44.97255902999362 | 136.9725590299936
5 | 1A | 0.2281021897810219 | 13.45802919708029 | 72.4580291970803 | 0.5117139334155364 | 32.23797780517879 | 95.23797780517879
6 | 1B | 0.9205298013245033 | 79.1655629139073 | 165.1655629139073 | 3.767195767195767 | 158.2222222222222 | 200.2222222222222
7 | 1C | 0.3056282722513089 | 234.1112565445026 | 1015.111256544503 | 0.4808437365475678 | 218.3030563925958 | 677.3030563925957
8 | Blend | 0.2851637764932562 | 47.33718689788054 | 213.3371868978805 | 0.4888321633694959 | 63.05934907466496 | 192.059349074665
9 | Blend | 0.2851637764932562 | 53.61078998073217 | 241.6107899807322 | 0.4888321633694959 | 67.45883854499043 | 205.4588385449904
10 | 1A | 0.2281021897810219 | 12.08941605839416 | 65.08941605839416 | 0.5117139334155364 | 18.93341553637485 | 55.93341553637485
11 | 1B | 0.9205298013245033 | 834 | 1740 | 3.767195767195767 | 1883.597883597884 | 2383.597883597884
12 | 1C | 0.3056282722513089 | 0.3056282722513089 | 1.305628272251309 | 0.4808437365475678 | 0 | 0
13 | Blend | 0.2851637764932562 | 1.710982658959538 | 7.710982658959537 | 0.4888321633694959 | 5.377153797064454 | 16.37715379706446
14 | Blend | 0.2851637764932562 | 0 | 4 | 0.4888321633694959 | 0 | 1
Grand Total |  |  | 2303.714133453945 | 7115.714133453944 |  | 4331.753646138866 | 7444.753646138866