Spreadsheet: 65494d1266234830-finding-duplicates-and-then-sum-a-row-range-resource-03-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | ** Team Forecast Resource Sheet **
 |  |  | Current Date: | 2010-02-15 22:03:35
 |  |  | Instructions: | Enter Data in 'RED' Type Cells ONLY!
 |  |  |  | Enter a '0' (zero) for no hour allocations. Try not to leave blank.
 |  |  |  |  |  |  |  |  | Estimate Hours | RemainingHours
 | Project No. and Project Description | Type | Client | Billability | CSG | PM | Project Phase | Phase Completion Date |  |  |  | Current Drafting Estimate Hours | Current Drafting Estimate Hours Remaining | 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
 | DESIGNERS
 | A.Smith | 40 |  |  |  |  |  |  |  |  |  |  | [NAME] | 45 | 99 | 56 | 82 | 21 | 5
1 | - - - | - | - | - | - | - | - | -
2 | 401014-99100 - Overheads (Other) | - | - | Non-Billable | - | - | - | - | 100 | ? | 55 |  |  | 20 | 10 | 5 | 20 |  |  |  | 1
3 | 401014-99100 - Overheads (Other) | - | - | Non-Billable | - | - | - | - | 50 | ? | 30 |  |  | 5 | 5 | 5 | 5 | 5 | 5 |  | 0
4 | 401014-00340 - 2CDU Transfer Line Metallurgy Upgrde | - | - | - | - | - | - | - | 75 | ? | 20 |  |  |  | 10 |  | 10 |  |  |  | 0
5 | - - Public Holidays | - | - | Leave | - | - | - | - | 120 | ? | 2 |  |  |  | 2 |  |  |  |  |  | 1
6 | 401014-00362 - Heat Trace Gellibrand PSV's | - | - | - | - | - | - | - | 60 | ? | 43 |  |  |  | 34 |  | 9 |  |  |  | 0
7 | - - Mobil Misc. | - | - | - | - | - | - | - | 55 | ? | 8 |  |  |  |  | 8 |  |  |  |  | 0
8 | 401014-00257 - SGP Sour Water Dewatering | - | - | - | - | - | - | - | 75 | ? | 16 |  |  |  |  |  | 8 | 8 |  |  | 1
9 | 401014-00200 - Inst. Air Compressor Upgrade | Project | Karabashcopper | Billable | I | MVC | Evaluate | 2018-12-31 00:00:00 | 45 | ? | 9 |  |  |  | 3 | 3 | 3 |  |  |  | 0
10 | 401014-00356 - Alky Feed Ring Upgrade | Project | SA | Overhead | P | BS | Operate | 2011-01-12 00:00:00 | 68 | ? | 0 |  |  |  |  |  |  |  |  |  | 1
11 | - - Annual Leave | - | - | - | - | - | - | - | 25 | ? | 10 |  |  |  | 5 | 5 |  |  |  |  | 0
12 | - - Public Holidays | - | - | Leave | - | - | - | - | 69 |  | 14 |  |  |  | 7 | 7 |  |  |  |  | 1
13 | - - - | - | - | - | - | - | - | - | 32 |  | 13 |  |  |  | 3 | 3 | 7 |  |  |  | 0
14 | - - - | - | - | - | - | - | - | - | 42 |  | 8 |  |  |  |  |  |  | 8 |  |  | 1
15 | 401014-99100 - Overheads (Other) | - | - | Non-Billable | - | - | - | - | 100 |  | 0 |  |  |  |  |  |  |  |  |  | 0
16 | 401014-00340 - 2CDU Transfer Line Metallurgy Upgrde | - | - | - | - | - | - | - | 250 |  |  |  |  |  |  |  |  |  |  |  | 1
17 | - - Public Holidays | - | - | Leave | - | - | - | - | 120 |  |  |  |  |  |  |  |  |  |  |  | 1
18 | 401014-00115 - Fin Fan Motor | - | - | - | - | - | - | - | 150 |  |  |  |  |  |  |  |  |  |  |  | 0
19 | - - Mobil Misc. | - | - | - | - | - | - | - | 10 |  |  |  |  |  |  |  |  |  |  |  | 1
20 | 401014-00257 - SGP Sour Water Dewatering | - | - | - | - | - | - | - | 22 |  |  |  |  |  |  |  |  |  |  |  | 1
21 | 401014-00200 - Inst. Air Compressor Upgrade | Project | Karabashcopper | Billable | Infrastructure | MVC | Evaluate | 2018-12-31 00:00:00 | 45 |  |  |  |  |  |  |  |  |  |  |  | 1
22 | 401014-00356 - Alky Feed Ring Upgrade | Project | Sugar Australia | Overhead | Power | BS | Operate | 1975-01-12 00:00:00 | 62 |  |  |  |  |  |  |  |  |  |  |  | 1
23 | - - Annual Leave | - | - | - | - | - | - | - | 35 |  |  |  |  |  |  |  |  |  |  |  | 1
24 | - - - | - | - | - | - | - | - | -
25 | - - - | - | - | - | - | - | - | - |  |  |  |  |  | 10 | 10 | 10 | 10 | 0 | 0
26 | - - - | - | - | - | - | - | - | -
27 | - - - | - | - | - | - | - | - | - |  |  |  |  |  | 10 | 10 | 10 | 10
28 | - - - | - | - | - | - | - | - | -
29 | - - - | - | - | - | - | - | - | -
30 | - - - | - | - | - | - | - | - | -
 | J.Nice | 40 |  |  |  |  |  |  |  |  |  |  | [NAME] | 40 | 51 | 52 | 77 | 31 | 14 | 9
1 | - - - | - | - | - | - | - | - | -
2 | 401014-99100 - Overheads (Other) | - | - | Non-Billable | - | - | - | - | 100 | #N/A | 55 |  |  | 20 | 10 | 5 | 20
3 | 401014-00318 - CLR Inlet Separator Bottoms Blowdown | - | - | - | - | - | - | - | 10 |  | 19 |  |  |  | 4 |  | 5 | 5 | 5
4 | 401014-00356 - Alky Feed Ring Upgrade | Project | SA | Overhead | P | BS | Operate | 2011-01-12 00:00:00 | 21 |  | 6 |  |  |  |  | 6
5 | - - Public Holidays | - | - | Leave | - | - | - | - | 120 |  | 21 |  |  |  | 6 |  | 7 | 8
6 | 401014-00115 - Fin Fan Motor | - | - | - | - | - | - | - | 98 |  | 12 |  |  |  |  | 4 | 4 | 4
7 | 401014-00109 - WWTP Lagoon Improvement | - | - | - | - | - | - | - | 78 |  | 0
8 | 401014-00257 - SGP Sour Water Dewatering | - | - | - | - | - | - | - | 75 |  | 12 |  |  |  | 6 | 6
9 | 401014-00057 - Alliance Induction | - | Alliance 1 | Billable | H | - | - | - | 77 |  | 12 |  |  |  |  | 6 | 6
10 | 401014-00356 - Alky Feed Ring Upgrade | Project | SA | Overhead | P | BS | Operate | 2011-01-12 00:00:00 | 68 |  | 36 |  |  |  |  |  | 9 | 9 | 9 | 9
11 | 401014-00315 - Main Gate & Loadout Weighbridge | - | - | - | - | - | - | - | 36 |  | 0
12 | - - Public Holidays | - | - | Leave | - | - | - | - | 69 |  | 5 |  |  |  | 5
13 | 401014-00331 - TK801 Sample Points Upgrade | - | - | - | - | - | - | - | 88 |  | 5 |  |  |  |  | 5
14 | - - - | - | - | - | - | - | - | - | 42 |  | 6 |  |  |  |  |  | 6
15 | 401014-00341 - B1103 Heater Convection Section Upgrde | - | - | - | - | - | - | - | 77 |  | 5 |  |  |  |  |  |  | 5
16 | 401014-00340 - 2CDU Transfer Line Metallurgy Upgrde | - | - | - | - | - | - | -
17 | - - Public Holidays | - | - | Leave | - | - | - | -
18 | 401014-00057 - Alliance Induction | - | Alliance 1 | Billable | Hydrocarbons | - | - | -
19 | - - Mobil Misc. | - | - | - | - | - | - | -
20 | 401014-00257 - SGP Sour Water Dewatering | - | - | - | - | - | - | -
21 | 401014-00200 - Inst. Air Compressor Upgrade | Project | Karabashcopper | Billable | Infrastructure | MVC | Evaluate | 2018-12-31 00:00:00
22 | 401014-00356 - Alky Feed Ring Upgrade | Project | Sugar Australia | Overhead | Power | BS | Operate | 1975-01-12 00:00:00
23 | - - Annual Leave | - | - | - | - | - | - | -
24 | - - - | - | - | - | - | - | - | -
25 | - - - | - | - | - | - | - | - | - |  |  |  |  |  | 10 | 10 | 10 | 10 | 0 | 0
26 | - - - | - | - | - | - | - | - | -
27 | - - - | - | - | - | - | - | - | - |  |  |  |  |  | 10 | 10 | 10 | 10
28 | - - - | - | - | - | - | - | - | -
29 | - - - | - | - | - | - | - | - | -
30 | - - - | - | - | - | - | - | - | -