Spreadsheet: 58191d1258481527-hlookup-sample
Sheet: Cap Plan

 |  |  | 2010-01-04 00:00:00 |  |  |  | 2010-01-11 00:00:00 |  |  |  | 2010-01-18 00:00:00 |  |  |  | 2010-01-25 00:00:00 |  |  |  | 2010-02-01 00:00:00 |  |  |  | 2010-02-08 00:00:00 |  |  |  | 2010-02-15 00:00:00 |  |  |  | 2010-02-22 00:00:00 |  |  |  | 2010-03-01 00:00:00 |  |  |  | 2010-03-08 00:00:00 |  |  |  | 2010-03-15 00:00:00 |  |  |  | 2010-03-22 00:00:00 |  |  |  | 2010-03-29 00:00:00
 |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A
 | WORKTYPES | RE | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME] |  | Mode Forecast Items | Revised Forecast Items | [NAME]
#N/A | Workitem 1 | 3.16 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1 | 0.25 | 0.25 | 0.0791139240506329 | 1
#N/A | Workitem 2 | 1.5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1
#N/A | Workitem 3 | 13.56 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1 | 8.25 | 8.25 | 0.6084070796460177 | 1
#N/A | Workitem 4 | 4 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1 | 14 | 14 | 3.5 | 1
#N/A | Workitem 5 | 5 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1 | 21.75 | 21.75 | 4.35 | 1
#N/A | Workitem 6 | 8 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1 | 24.5 | 24.5 | 3.0625 | 1
#N/A | Workitem 7 | 5 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1 | 35.75 | 35.75 | 7.15 | 1
#N/A | Workitem 8 | 4 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1 | 10.5 | 10.5 | 2.625 | 1
#N/A | Workitem 9 | 5 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1 | 2.25 | 2.25 | 0.45 | 1
#N/A | Workitem 10 | 12 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1
#N/A | Workitem 11 | 8.94 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1 | 20 | 20 | 2.237136465324385 | 1
#N/A | Workitem 12 | 4 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 1 | 1
#N/A | Workitem 13 | 10 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1 | 1.75 | 1.75 | 0.175 | 1
#N/A | Workitem 14 | 4 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1 | 274.5 | 274.5 | 68.625 | 1
#N/A | Workitem 15 | 5.46 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1 | 6.25 | 6.25 | 1.144688644688645 | 1
#N/A | Workitem 16 | 4 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1 | 248.5 | 248.5 | 62.125 | 1
#N/A | Workitem 17 | 2.67 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1 | 3.5 | 3.5 | 1.310861423220974 | 1
#N/A | Workitem 18 | 6 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1 | 34.25 | 34.25 | 5.708333333333333 | 1
#N/A | Workitem 19 | 6 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1 | 114 | 114 | 19 | 1
#N/A | Workitem 20 | 4 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1 | 4.25 | 4.25 | 1.0625 | 1
#N/A | Workitem 21 | 5 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1 | 17.75 | 17.75 | 3.55 | 1
#N/A | Workitem 22 | 8 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1 | 344.5 | 344.5 | 43.0625 | 1
#N/A | Workitem 23 | 4 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1 | 13.5 | 13.5 | 3.375 | 1
#N/A | Workitem 24 | 5 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1 | 39.75 | 39.75 | 7.95 | 1
 | Workitem 25 | 8 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1
 | Workitem 26 | 10 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1 | 17.75 | 17.75 | 1.775 | 1
 | Workitem 27 | 6 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1 | 5 | 5 | 0.8333333333333334 | 1
 | Workitem 28 | 5 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1 | 4.5 | 4.5 | 0.9 | 1
 | Workitem 29 | 3.93 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1 | 9 | 9 | 2.290076335877862 | 1
#N/A | Workitem 30 | 6 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1 | 3.5 | 3.5 | 0.5833333333333334 | 1
 | Totals |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086 |  | 1283.5 | 1283.5 | 248.5327838728086