Spreadsheet: 66835d1267527007-add-cells-with-multiple-criteria-in-excel-2003-resource-03-help
Sheet: Sheet1

 | Current Date: | 2010-03-02 21:33:19 |  |  |  |  |  |  |  |  |  | Probably put drafting summation in the eng. Column and rename to Estimate hours. Deletes two columns then.
 | Instructions: | Enter Data in 'RED' Type Cells ONLY! |  |  |  |  |  |  |  | Remaining Eng. Hours
 |  | Enter a '0' (zero) for no hour allocations. Try not to leave blank.
 | Messages: | Too Many Hours Have Been Allocated. CHECK! |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72
 |  |  |  |  |  |  |  |  |  |  |  | 100 | 100 | 2.10186585647898 | 9.10186585647898 | 16.10186585647898 | 23.10186585647898 | 30.10186585647898 | 37.10186585647898 | 44.10186585647898 | 51.10186585647898 | 58.10186585647898 | 65.10186585647898 | 72.10186585647898 | 79.10186585647898 | 86.10186585647898 | 93.10186585647898 | 100.101865856479 | 107.101865856479 | 114.101865856479 | 121.101865856479 | 128.101865856479 | 135.101865856479 | 142.101865856479 | 149.101865856479 | 156.101865856479 | 163.101865856479 | 170.101865856479 | 177.101865856479 | 184.101865856479 | 191.101865856479 | 198.101865856479 | 205.101865856479 | 212.101865856479 | 219.101865856479 | 226.101865856479 | 233.101865856479 | 240.101865856479 | 247.101865856479 | 254.101865856479 | 261.101865856479 | 268.101865856479 | 275.101865856479 | 282.101865856479 | 289.101865856479 | 296.101865856479 | 303.101865856479 | 310.101865856479 | 317.101865856479 | 324.101865856479 | 331.101865856479 | 338.101865856479 | 345.101865856479 | 352.101865856479 | 359.101865856479 | 366.101865856479 | 373.101865856479 | 380.101865856479 | 387.101865856479 | 394.101865856479 | 401.101865856479 | 408.101865856479 | 415.101865856479 | 422.101865856479 | 429.101865856479 | 436.101865856479 | 443.101865856479 | 450.101865856479 | 457.101865856479 | 464.101865856479 | 471.101865856479 | 478.101865856479 | 485.101865856479
 | Project No. and Project Description | Type | Client | Billability | CSG | PM | Project Phase | Phase Completion Date | Estimate Eng. Hours | c | a | 2010-02-19 00:00:00 | 2010-02-26 00:00:00 | 2010-03-05 00:00:00 | 2010-03-12 00:00:00 | 2010-03-19 00:00:00 | 2010-03-26 00:00:00 | 2010-04-02 00:00:00 | 2010-04-09 00:00:00 | 2010-04-16 00:00:00 | 2010-04-23 00:00:00 | 2010-04-30 00:00:00 | 2010-05-07 00:00:00 | 2010-05-14 00:00:00 | 2010-05-21 00:00:00 | 2010-05-28 00:00:00 | 2010-06-04 00:00:00 | 2010-06-11 00:00:00 | 2010-06-18 00:00:00 | 2010-06-25 00:00:00 | 2010-07-02 00:00:00 | 2010-07-09 00:00:00 | 2010-07-16 00:00:00 | 2010-07-23 00:00:00 | 2010-07-30 00:00:00 | 2010-08-06 00:00:00 | 2010-08-13 00:00:00 | 2010-08-20 00:00:00 | 2010-08-27 00:00:00 | 2010-09-03 00:00:00 | 2010-09-10 00:00:00 | 2010-09-17 00:00:00 | 2010-09-24 00:00:00 | 2010-10-01 00:00:00 | 2010-10-08 00:00:00 | 2010-10-15 00:00:00 | 2010-10-22 00:00:00 | 2010-10-29 00:00:00 | 2010-11-05 00:00:00 | 2010-11-12 00:00:00 | 2010-11-19 00:00:00 | 2010-11-26 00:00:00 | 2010-12-03 00:00:00 | 2010-12-10 00:00:00 | 2010-12-17 00:00:00 | 2010-12-24 00:00:00 | 2010-12-31 00:00:00 | 2011-01-07 00:00:00 | 2011-01-14 00:00:00 | 2011-01-21 00:00:00 | 2011-01-28 00:00:00 | 2011-02-04 00:00:00 | 2011-02-11 00:00:00 | 2011-02-18 00:00:00 | 2011-02-25 00:00:00 | 2011-03-04 00:00:00 | 2011-03-11 00:00:00 | 2011-03-18 00:00:00 | 2011-03-25 00:00:00 | 2011-04-01 00:00:00 | 2011-04-08 00:00:00 | 2011-04-15 00:00:00 | 2011-04-22 00:00:00 | 2011-04-29 00:00:00 | 2011-05-06 00:00:00 | 2011-05-13 00:00:00 | 2011-05-20 00:00:00 | 2011-05-27 00:00:00 | 2011-06-03 00:00:00 | 2011-06-10 00:00:00 | 2011-06-17 00:00:00 | 2011-06-24 00:00:00 | 2011-07-01 00:00:00
 | Draftee
 | [NAME] |  |  |  |  |  |  |  |  |  | Available Resource Hours | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 258 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | - - WP Management | - | - | Non-Billable | - | - | - | 2010-09-10 00:00:00 | - | - | 0
2 | - - - | - | - | - | - | - | - | - | - | - | 0
3 | 401014-00241 - TCE | - | - | - | - | - | - | - | 69 | -560 | 5 | 5
4 | 401014-00340 - 2CDU Transfer Line Metallurgy Upgrde | - | - | - | - | - | - | - | 1 | 1 | 0
5 | 401014-00241 - TCE | - | - | - | - | - | - | - | 69 | -560 | 28 | 28
6 | - - Spare | - | - | - | - | - | - | - | - | - | 0
7 | - - - | - | - | - | - | - | - | - | - | - | 0
8 | - - - | - | - | - | - | - | - | - | - | - | 0
9 | 401014-00200 - Inst. Air Compressor Upgrade | Project | Alliance 5 | Billable | Infrastructure | MVC | Evaluate | 2018-12-31 00:00:00 | 1 | -70 | 69 | 69
10 | 401014-00356 - Alky Feed Ring Upgrade | Proposal | Alliance 3 | Billable | Power | BS | Operate | 1975-01-12 00:00:00 | 1 | -3 | 2 | 2
11 | - - WP Management | - | - | Non-Billable | - | - | - | 2010-09-10 00:00:00 | - | - | 96 | 96
12 | - - Public Holidays | - | - | Leave | - | - | - | - | - | - | 25 | 25
13 | - - Spare | - | - | - | - | - | - | - | - | - | 0
14 | - - Spare | - | - | - | - | - | - | - | - | - | 0
15 | - - Spare | - | - | - | - | - | - | - | - | - | 0
16 | 401014-00340 - 2CDU Transfer Line Metallurgy Upgrde | - | - | - | - | - | - | - | 1 | 1 | 0
17 | - - Public Holidays | - | - | Leave | - | - | - | - | - | - | 0
18 | 401014-00241 - TCE | - | - | - | - | - | - | - | 69 | -560 | 25 | 25
19 | - - Mobil Misc. | - | - | - | - | - | - | - | 1 | 1 | 0
20 | 401014-00257 - SGP Sour Water Dewatering | - | - | - | - | - | - | - | 1 | 1 | 0
21 | 401014-00200 - Inst. Air Compressor Upgrade | Project | Alliance 5 | Billable | Infrastructure | MVC | Evaluate | 2018-12-31 00:00:00 | 1 | -70 | 2 | 2
22 | 401014-00356 - Alky Feed Ring Upgrade | Proposal | Alliance 3 | Billable | Power | BS | Operate | 1975-01-12 00:00:00 | 1 | -3 | 2 | 2
23 | - - Annual Leave | - | - | Leave | - | - | - | - | - | - | 0
24 | - - Other Leave (e.g Sick or [NAME], LWOP) | - | - | Leave | - | - | - | - | - | - | 0
25 | - - Annual Leave | - | - | Leave | - | - | - | - | - | - | 0
26 | 401014-00227 - Mobil Weigh Bridge Verification | - | - | Overhead | - | - | - | - | 1 | -3 | 4 | 4
27 | - - Spare | - | - | - | - | - | - | - | - | - | 0
28 | - - Spare | - | - | - | - | - | - | - | - | - | 0
29 | - - Spare | - | - | - | - | - | - | - | - | - | 0
30 | - - Spare | - | - | - | - | - | - | - | - | - | 0