formula for finding drawings' latest revision

[Baggeepants]

Below is an extract from a drawing register spreadsheet & in column B, I require a formula that displays the latest revision of the document. Column E onwards display the received/issued revisions of the documents listed in column A at different times during the life of the project. As new revisions are received a new column is inserted before column E & different suppliers use different revision codes. C1 being a later revision than P3.
[TABLE="width: 982"]
<tbody>[TR]
[TD]
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD="colspan: 2"]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]L
[/TD]
[TD]M
[/TD]
[TD]N
[/TD]
[TD]O
[/TD]
[TD]P
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Document Number
[/TD]
[TD]Current Revision
[/TD]
[TD="colspan: 2"]

Reason for Issue​

[/TD]
[TD][/TD]
[TD]R
[/TD]
[TD]R
[/TD]
[TD]R
[/TD]
[TD]ACT
[/TD]
[TD]APP
[/TD]
[TD]APP
[/TD]
[TD]ACT
[/TD]
[TD]R
[/TD]
[TD]R
[/TD]
[TD]APP
[/TD]
[TD]R
[/TD]
[TD]ACT
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Title
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]C891-B2-AB-34391
[/TD]
[TD][/TD]
[TD]Interlocking Control System Cable Block Diagram
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]C891-B2-AU-30155
[/TD]
[TD][/TD]
[TD]SLUDGE & LAUNDER COLLECTION ACCESS ROAD LIGHTING GENERAL ARRANGEMENT
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]C891-B2-AU-30159
[/TD]
[TD][/TD]
[TD]PRIMARY DIGESTER TANK NO.4 HEAT EXCHANGER ACCESS WALKWAY LIGHTING GENERAL ARRANGEMENT
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]C891-B2-AU-30161
[/TD]
[TD][/TD]
[TD]WASHWATER PUMP WWS03P_01 BLOCK CABLE DIAGRAM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]C891-B2-AU-30180
[/TD]
[TD][/TD]
[TD]WASHWATER PUMP WWS03P_01 CONNECTION DIAGRAM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]C891-B2-AU-30182
[/TD]
[TD][/TD]
[TD]PST5 RIO BLOCK CABLE DIAGRAM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]C891-B2-AU-30195
[/TD]
[TD][/TD]
[TD]INLET & SLUDGE IMCC BLOCK CABLE DIAGRAM SHEET 4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P2
[/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]C891-B2-AU-30200
[/TD]
[TD][/TD]
[TD]INLET & SLUDGE MCC ICA COMPARTMENT A1 CONNECTION DIAGRAM SHEET 1 OF 5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24
[/TD]
[TD]C891-HOGSS1ZZ-ELE-SPEC-10085-Addendum02
[/TD]
[TD][/TD]
[TD]ICS Cable Schedule
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]25
[/TD]
[TD]Appendix 1
[/TD]
[TD][/TD]
[TD]HMI Screen Switchboards
[/TD]
[TD][/TD]
[TD][/TD]
[TD]-
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26
[/TD]
[TD]3334787_B03_04_A03 3 x CRE 45-2-1 VSD Booster Pump Data Sheets
[/TD]
[TD][/TD]
[TD]VSD Booster Pump Data Sheets
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]27
[/TD]
[TD]99195220 as built
[/TD]
[TD][/TD]
[TD]Hydro MPC Control Panel 2 Pump Pressure Boosting System EF
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]B
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28
[/TD]
[TD]Control MPC
[/TD]
[TD][/TD]
[TD]Installation & Operating Instructions
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29
[/TD]
[TD]Hydro MPC
[/TD]
[TD][/TD]
[TD]Service Instructions
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jorismoerings]

Hi,

Welcome to MrExcel,

Check if this works for you:

Book1
	A	B
1	Document Number	Current Revision
2	Title
3	C891-B2-AB-34391	E
4	C891-B2-AU-30155	P2
5	C891-B2-AU-30159	P2
6	C891-B2-AU-30161	C2
7	C891-B2-AU-30180	C2
8	C891-B2-AU-30182
9	C891-B2-AU-30195	P2
10	C891-B2-AU-30200	C3
11	C891-HOGSS1ZZ-ELE-SPEC-10085-Addendum02	5
12	Appendix 1	-
13	3334787_B03_04_A03 3 x CRE 45-2-1 VSD Booster Pump Data Sheets	-
14	99195220 as built	B
15	Control MPC	-
16	Hydro MPC	-
Sheet1

Cell Formulas
Range	Formula
B3	{=IFERROR(INDEX(E3:P3,MATCH(TRUE,E3:P3<>"",0)),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Baggeepants]

Hi,

Welcome to MrExcel,

Check if this works for you:

	A	B
Document Number	Current Revision
Title
C891-B2-AB-34391
C891-B2-AU-30155
C891-B2-AU-30159
C891-B2-AU-30161
C891-B2-AU-30180
C891-B2-AU-30182
C891-B2-AU-30195
C891-B2-AU-30200
C891-HOGSS1ZZ-ELE-SPEC-10085-Addendum02
Appendix 1
3334787_B03_04_A03 3 x CRE 45-2-1 VSD Booster Pump Data Sheets
99195220 as built
Control MPC
Hydro MPC

<colgroup><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]E[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]P2[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]P2[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]C2[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]C2[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"][/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]P2[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]C3[/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]12[/TD]

[TD="align: center"]-[/TD]

[TD="align: center"]13[/TD]

[TD="align: center"]-[/TD]

[TD="align: center"]14[/TD]

[TD="align: center"]B[/TD]

[TD="align: center"]15[/TD]

[TD="align: center"]-[/TD]

[TD="align: center"]16[/TD]

[TD="align: center"]-[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B3[/TH]
[TD="align: left"]{=IFERROR(INDEX(E3:P3,MATCH(TRUE,E3:P3<>"",0)),"")}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

Thanks, formula works a treat for most of the documents listed. But some of the drawings have revisions P1, P2 P3 which are provisional drawings, then the same drawing will have C1, C2 etc which are for construction finally followed by X which is 'As Built' (The quirks of the construction industry). Is there any way the formula could be adjusted to show the correct revision for these types of documents.

 

[jorismoerings]

Hi,

My formula was build upon the requirements of the latest revision was entered in a new inserted column. But clearly there's some hierarchy level within.
Could you explain the hierarchy level used with an example. EG if you look at line 10 the last code used is P2 directly followed by C2.
Does X always prevales over Cx codes and do Cx codes prevale over Px codes? What does an E code mean?
etc.

 

[Baggeepants]

Hi,

My formula was build upon the requirements of the latest revision was entered in a new inserted column. But clearly there's some hierarchy level within.
Could you explain the hierarchy level used with an example. EG if you look at line 10 the last code used is P2 directly followed by C2.
Does X always prevales over Cx codes and do Cx codes prevale over Px codes? What does an E code mean?
etc.

Within the construction industry, some companies use an alphabetical revision system (A, B, C etc) while others use an Alpha-Numeric system (P1, P2, C1, C2 etc). Where the P revisions are preliminary drawings, the C revisions are the construction drawings and the X revisions are the final drawings of what has been built/installed.

Here is an extract from a document register but as it is a current project there are as yet no X revision drawings.
[TABLE="width: 1035"]
<tbody>[TR]
[TD]Document Number
[/TD]
[TD]Current Revision
[/TD]
[TD="colspan: 2"]Reason for Issue
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Title (Duplicate Document No.) (Superseded Document)
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30034
[/TD]
[TD][/TD]
[TD]PFT3 & DIG4 PACKAGE PLANT WIRING BLOCK CABLE DIAGRAM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30047
[/TD]
[TD][/TD]
[TD]PICKET FENCE THICKENER NO.3 ACCESS WALKWAYS LIGHTING GENERAL ARRANGEMENT
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]C3
[/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30049
[/TD]
[TD][/TD]
[TD]SLUDGE BLENDING TANK NO.2 PLATFORM LIGHTING GENERAL ARRANGEMENT
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30055
[/TD]
[TD][/TD]
[TD]PRIMARY DIGESTER TANK NO.4 ACCESS PLATFORM LIGHTING GENERAL ARRANGEMENT
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C5
[/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30086
[/TD]
[TD][/TD]
[TD]INLET & SLUDGE iMCC RTU10 BLOCK CABLE DIAGRAM SHEET 2 OF 3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C5
[/TD]
[TD]C4
[/TD]
[TD]C3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30126
[/TD]
[TD][/TD]
[TD]PFT 3 DRIVE PUMP CONNECTION DIAGRAM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30127
[/TD]
[TD][/TD]
[TD]DIGESTER 4 GRAVITY FLOW MACERATOR CONNECTION DIAGRAM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30128
[/TD]
[TD][/TD]
[TD]PFT 3 DESLUDGE MOTOR AND PUMP CONNECTION DIAGRAM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30134
[/TD]
[TD][/TD]
[TD]PFT NO.3 DESLUDGE PUMP PLINTH TASK & EMERGENCY LIGHTING GENERAL ARRANGEMENT
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD]P1
[/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30155
[/TD]
[TD][/TD]
[TD]SLUDGE & LAUNDER COLLECTION ACCESS ROAD LIGHTING GENERAL ARRANGEMENT
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30159
[/TD]
[TD][/TD]
[TD]PRIMARY DIGESTER TANK NO.4 HEAT EXCHANGER ACCESS WALKWAY LIGHTING GENERAL ARRANGEMENT
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30195
[/TD]
[TD][/TD]
[TD]INLET & SLUDGE IMCC BLOCK CABLE DIAGRAM SHEET 4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P2
[/TD]
[TD]C2
[/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30200
[/TD]
[TD][/TD]
[TD]INLET & SLUDGE MCC ICA COMPARTMENT A1 CONNECTION DIAGRAM SHEET 1 OF 5
[/TD]
[TD][/TD]
[TD][/TD]
[TD]C3
[/TD]
[TD]C2
[/TD]
[TD]C1
[/TD]
[TD]P1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30209
[/TD]
[TD][/TD]
[TD]110V INSTRUMENT DB WAYS 16-23 CONNECTION DIAGRAM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD]C1
[/TD]
[TD]P1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30212
[/TD]
[TD][/TD]
[TD]INLET & SLUDGE MCC ICA COMPARTMENT A1 CONNECTION DIAGRAM SHEET 6 OF 6
[/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD]C1
[/TD]
[TD]P1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-B2-AU-30221
[/TD]
[TD][/TD]
[TD]PST5 TANK, KIOSK & FERRIC PLANT FOOTPATH LIGHTING GA
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-DOC-B2-AU-30008
[/TD]
[TD][/TD]
[TD]PICKET FENCE THICKENER NO.3 LIGHTING CALCULATION
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]P2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-DOC-B2-AU-30033
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-DOC-B2-AU-30097
[/TD]
[TD][/TD]
[TD]110V INSTRUMENTATION DISTRIBUTION BOARD CABLE SCHEDULE
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C4
[/TD]
[TD]C3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD]P1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-DOC-B2-AU-30133
[/TD]
[TD][/TD]
[TD]PFT3 DESLUDGE PUMPS PLINTH LIGHTING CALCULATION
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]P1
[/TD]
[/TR]
[TR]
[TD]C891-DOC-B2-AU-30158
[/TD]
[TD][/TD]
[TD]PRIMARY DIGESTER TANK NO.4 HEAT EXCHANGER ACCESS WALKWAY LIGHTING CALCULATION
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C891-DOC-B2-AU-30220
[/TD]
[TD][/TD]
[TD]PRIMARY DIGESTER TANK NO.5 FOOTPATHS LIGHTING CALCULATIONS
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P1

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]