Spreadsheet: 263970d1378742128-retrieve-matching-value-from-another-worksheet-data1
Sheet: Sheet1

Sl | Vendor Description | Drawing No. | Vend_Rev | DOCUMENT NUMBER | [NAME] | CLIENT REVISION NUMBER | DATE              Received fm Vendor | DATE Submited to Consultnt | Transmittal No. | Date comments from consultnt | Date of submission to Client | Transmittal no | Client Comment | STATUS
1 |  |  |  | [NAME] | Project ProductionSchedule | 0
2 |  |  |  | VEN-3475-KHGA-6-52-0100 | Process Flow Diagram (PFD) Flares 6A-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
3 |  |  |  | VEN-3475-KHGB-6-52-0100 | Process Flow Diagram (PFD) Flares 6B-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
4 |  |  |  | [NAME] | Process Flow Diagram (PFD) Flares 6C-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
5 |  |  |  | VEN-3475-KHGD-6-52-0100 | Process Flow Diagram (PFD) Flares 6D-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
6 |  |  |  | VEN-3475-KHGE-6-52-0100 | Process Flow Diagram (PFD) Flares 6E-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
7 |  |  |  | [NAME] | Process Flow Diagram (PFD) Flares 6G-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
8 |  |  |  | VEN-3475-KHGH-6-52-0100 | Process Flow Diagram (PFD) Flares 6H-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
9 |  |  |  | [NAME] | Process Flow Diagram (PFD) Flares 6L-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
10 |  |  |  | VEN-3475-KHGA-6-50-0100 | Piping and Instrumentation Diagram (P&ID) [NAME] | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
11 |  |  |  | VEN-3475-KHGB-6-50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6B-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
12 |  |  |  | [NAME]50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6C-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
13 |  |  |  | VEN-3475-KHGD-6-50-0100 | Piping and Instrumentation Diagram (P&ID) [NAME] | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
14 |  |  |  | VEN-3475-KHGE-6-50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6E-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
15 |  |  |  | [NAME]50-0100 | Piping and Instrumentation Diagram (P&ID) [NAME] | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
16 |  |  |  | VEN-3475-KHGH-6-50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6H-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
17 |  |  |  | [NAME]50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6L-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
18 |  |  |  | VEN-3475-KHGA-5-13-0100 | Utility Consumption List Flare 6A-X-0001 | 0 |  | 2013-07-17 00:00:00
19 |  |  |  | VEN-3475-KHGB-5-13-0100 | Utility Consumption List Flare 6B-X-0001 | 0 |  | 2013-07-17 00:00:00
20 |  |  |  | [NAME]13-0100 | Utility Consumption List Flare 6C-X-0001 | 0 |  | 2013-07-17 00:00:00
21 |  |  |  | VEN-3475-KHGD-5-13-0100 | Utility Consumption List Flare 6D-X-0001 | 0 |  | 2013-07-17 00:00:00
22 |  |  |  | VEN-3475-KHGE-5-13-0100 | Utility Consumption List Flare 6E-X-0001 | 0 |  | 2013-07-17 00:00:00
23 |  |  |  | VEN-3475-KHGG-5-13-0100 | Utility Consumption List Flare 6G-X-0001 | 0 |  | 2013-07-17 00:00:00
24 |  |  |  | VEN-3475-KHGH-5-13-0100 | Utility Consumption List Flare 6H-X-0001 | 0 |  | 2013-07-17 00:00:00
25 |  |  |  | VEN-3475-KHGL-5-13-0100 | Utility Consumption List Flare 6L-X-0001 | 0 |  | 2013-07-17 00:00:00
26 |  |  |  | VEN-3475-KHGA-5-03-0100 | Operating Philosophy Flare 6A-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-04 00:00:00
27 |  |  |  | VEN-3475-KHGB-5-03-0100 | Operating Philosophy Flare 6B-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-04 00:00:00
28 |  |  |  | [NAME]03-0100 | Operating Philosophy Flare 6C-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-04 00:00:00
29 |  |  |  | VEN-3475-KHGD-5-03-0100 | Operating Philosophy [NAME] | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-04 00:00:00
30 |  |  |  | VEN-3475-KHGE-5-03-0100 | Operating Philosophy Flare 6E-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-04 00:00:00
31 |  |  |  | VEN-3475-KHGG-5-03-0100 | Operating Philosophy [NAME] | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-04 00:00:00
32 |  |  |  | VEN-3475-KHGH-5-03-0100 | Operating Philosophy Flare 6H-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-04 00:00:00
33 |  |  |  | VEN-3475-KHGL-5-03-0100 | Operating Philosophy Flare 6L-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-04 00:00:00
34 |  |  |  | VEN-3475-KHGA-5-12-0100 | Radiation Calculations for Flare Stacks 6A-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-01 00:00:00
35 |  |  |  | VEN-3475-KHGB-5-12-0100 | Radiation Calculations for Flare Stacks 6B-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-01 00:00:00
36 |  |  |  | [NAME]12-0100 | Radiation Calculations for Flare Stacks 6C-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-01 00:00:00
37 |  |  |  | VEN-3475-KHGD-5-12-0100 | Radiation Calculations for Flare Stacks 6D-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-01 00:00:00
38 |  |  |  | VEN-3475-KHGE-5-12-0100 | Radiation Calculations for Flare Stacks 6E-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-01 00:00:00
39 |  |  |  | VEN-3475-KHGG-5-12-0100 | Radiation Calculations for Flare Stacks 6G-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-01 00:00:00
40 |  |  |  | VEN-3475-KHGH-5-12-0100 | Radiation Calculations for Flare Stacks 6H-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-01 00:00:00
41 |  |  |  | VEN-3475-KHGL-5-12-0100 | Radiation Calculations for Flare Stacks 6L-X-0001 | 0 |  | 2013-07-20 00:00:00 |  | 2013-08-01 00:00:00
42 |  |  |  | VEN-3475-KHGA-4-30-0100 | Instrument List Flare 6A-X-0001 | 0
43 |  |  |  | VEN-3475-KHGB-4-30-0100 | Instrument List Flare 6B-X-0001 | 0
44 |  |  |  | VEN-3475-KHGC-4-30-0100 | Instrument List Flare 6C-X-0001 | 0
45 |  |  |  | VEN-3475-KHGD-4-30-0100 | Instrument List Flare 6D-X-0001 | 0
46 |  |  |  | [NAME] | Instrument List Flare 6E-X-0001 | 0
47 |  |  |  | VEN-3475-KHGG-4-30-0100 | Instrument List Flare 6G-X-0001 | 0
48 |  |  |  | [NAME]30-0100 | Instrument List Flare 6H-X-0001 | 0
49 |  |  |  | VEN-3475-KHGL-4-30-0100 | Instrument List Flare 6L-X-0001 | 0
50 |  |  |  | VEN-3475-KHGA-5-33-0100 | Line List Flare 6A-X-0001 | 0
51 |  |  |  | VEN-3475-KHGB-5-33-0100 | Line List Flare 6B-X-0001 | 0
52 |  |  |  | [NAME]33-0100 | Line List Flare 6C-X-0001 | 0
53 |  |  |  | VEN-3475-KHGD-5-33-0100 | Line List Flare 6D-X-0001 | 0
54 |  |  |  | VEN-3475-KHGE-5-33-0100 | Line List Flare 6E-X-0001 | 0
55 |  |  |  | VEN-3475-KHGG-5-33-0100 | Line List Flare 6G-X-0001 | 0
56 |  |  |  | VEN-3475-KHGH-5-33-0100 | Line List Flare 6H-X-0001 | 0
57 |  |  |  | VEN-3475-KHGL-5-33-0100 | Line List Flare 6L-X-0001 | 0
58 |  |  |  | VEN-3475-KHGA-5-32-0100 | Valve List Flare 6A-X-0001 | 0
59 |  |  |  | VEN-3475-KHGB-5-32-0100 | Valve List Flare 6B-X-0001 | 0
60 |  |  |  | [NAME]32-0100 | Valve List Flare 6C-X-0001 | 0
61 |  |  |  | VEN-3475-KHGD-5-32-0100 | Valve List Flare 6D-X-0001 | 0
62 |  |  |  | VEN-3475-KHGE-5-32-0100 | Valve List Flare 6E-X-0001 | 0
63 |  |  |  | VEN-3475-KHGG-5-32-0100 | Valve List Flare 6G-X-0001 | 0
64 |  |  |  | VEN-3475-KHGH-5-32-0100 | Valve List Flare 6H-X-0001 | 0
65 |  |  |  | VEN-3475-KHGL-5-32-0100 | Valve List Flare 6L-X-0001 | 0
66 |  |  |  | VEN-3475-KHGA-6-52-0100 | Process Flow Diagram (PFD) Flares 6A-X-0001 | 1
67 |  |  |  | VEN-3475-KHGB-6-52-0100 | Process Flow Diagram (PFD) Flares 6B-X-0001 | 1
68 |  |  |  | [NAME] | Process Flow Diagram (PFD) Flares 6C-X-0001 | 1
69 |  |  |  | VEN-3475-KHGD-6-52-0100 | Process Flow Diagram (PFD) Flares 6D-X-0001 | 1
70 |  |  |  | VEN-3475-KHGE-6-52-0100 | Process Flow Diagram (PFD) Flares 6E-X-0001 | 1
71 |  |  |  | [NAME] | Process Flow Diagram (PFD) Flares 6G-X-0001 | 1
72 |  |  |  | VEN-3475-KHGH-6-52-0100 | Process Flow Diagram (PFD) Flares 6H-X-0001 | 1
73 |  |  |  | [NAME] | Process Flow Diagram (PFD) Flares 6L-X-0001 | 1
74 |  |  |  | VEN-3475-KHGA-6-50-0100 | Piping and Instrumentation Diagram (P&ID) [NAME] | 1
75 |  |  |  | VEN-3475-KHGB-6-50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6B-X-0001 | 1
76 |  |  |  | [NAME]50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6C-X-0001 | 1
77 |  |  |  | VEN-3475-KHGD-6-50-0100 | Piping and Instrumentation Diagram (P&ID) [NAME] | 1
78 |  |  |  | VEN-3475-KHGE-6-50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6E-X-0001 | 1
79 |  |  |  | [NAME]50-0100 | Piping and Instrumentation Diagram (P&ID) [NAME] | 1
80 |  |  |  | VEN-3475-KHGH-6-50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6H-X-0001 | 1
81 |  |  |  | [NAME]50-0100 | Piping and Instrumentation Diagram (P&ID) Flare 6L-X-0001 | 1