Spreadsheet: 103487d1301246780-dependent-lists-with-index-function-penguintar-_costingstemplateautomated_rev19d-
Sheet: Validations

Type | Plate | [NAME] | Tubular Welded | Section | Shipbuilding Plate | Offshore Plate | Structural Plate | Pressure Vessel Plate | High Tensile Plate | Low Temp Plate | Seamless Tubular | Alloy Seamless Tubular | S.A.W. Tubular | [NAME] | Alloy S.A.W. Tubular | Alloy E.R.W. Tubular | Structural Hollow Section | Structural Section |  |  | p/Tonne | 3.1 |  | Yes | Alloy Plate
Plate | Shipbuilding Plate | Seamless Tubular | S.A.W Tubular | Structural Hollow Section | ABS Grade A | API 2H Gr.45 | ASTM A36 | ASME SA516 Gr.60 | NKK KHT 60 | NKK KL24 Grade A | EN10225 S355G15+N | ASTM B729 | API 5L Grade B | API 5L Grade A | ASTM B464 | ASTM B464 | EN10210 S275J2H | [NAME] |  |  | p/mtr | 3.2 |  | No
[NAME] | Offshore Plate | Alloy Seamless Tubular | E.R.W Tubular | Structural Section | ABS Grade B | API 2H Gr.50 | ASTM A6 | ASME SA516 Gr.65 | NKK KHT 62 | NKK KL24 Grade B | API 5L Grade B | ASTM B622 | API 5L X42 | API 5L Grade B | ASTM B619 | ASTM B619 | EN10210 S355J2H | BS7191 355D |  |  | p/sq.mtr | L.O.C.
Tubular Welded | Structural Plate |  | Alloy S.A.W Tubular |  | ABS Grade D | API 2W Gr.50 | ASTM A572 Gr.40 | ASME SA516 Gr.70 | NKK KHT 72 | NKK KL27 | API 5L X42 | ASTM B161 | API 5L X52 Dual Certified to API 2H | API 5L X42 | ASTM B725 | ASTM B725 | EN10210 S355K2H | BS7191 355EM |  |  | p/Each
Section | Pressure Vessel Plate |  | Alloy E.R.W Tubular |  | ABS Grade E | API 2W Gr.60 | ASTM A572 Gr.45 | ASME SA516 Gr.60 HIC | NKK KHT 72N | NKK KL33 | API 5L X52 Modified | ASTM B165 | API 5L X52 PSL-1 | API 5L X52 PSL-1 | ASTM A790 | ASTM A790 | EN10219 S355J2H | API 2H Gr.50 |  |  | p/Kilo
Miscellaneous | High Tensile Plate |  |  |  | ABS Grade DS | API 2Y+QT | ASTM A572 Gr.50 | ASME SA516 Gr.65 HIC | NKK KHT 80 | NKK KL37 | API 5L X52 PSL-1 | ASTM B167 | API 5L X52 PSL-2 | API 5L X52 PSL-2 | ASTM A691 1-1/4CR | ASTM A691 1-1/4CR | EN10219 S355K2H | API 2W Gr.50
 | Low Temp Plate |  |  |  | ABS Grade CS | API 2W Dual Certified to EH36 | ASTM A572 Gr.60 | ASME SA516 Gr.70 HIC | NKK KHT 80N | NKK KL9M60 | API 5L X52 PSL-2 | ASTM B407 | API 5L X56 | API 5L X56 | ASTM A691 2-1/4CR | ASTM A691 2-1/4CR | EN10219 S275J2H | API 2W Gr.50T
 |  |  |  |  | ABS AH32 | API 2W Dual Certified to S355G10+M | ASTM A572 Gr.65 | ASME SA516 Triple Certified to Gr.60/65/70 | ASTM A514 Gr. B | ABS V-039 | API 5L X56 | ASTM B423 | API 5L X60 | API 5L X60 | ASTM A691 5CR | ASTM A691 5CR |  | API 2W Gr.60
 |  |  |  |  | ABS DH32 | EN10225 S355G2+N | EN10025 S235JR | ASME SA516 Triple Certified to Gr.60/65/70 HIC | ASTM A514 Gr. H | ABS V-051 | API 5L X60 | ASTM A790 | API 5L X65 | API 5L X65 | ASTM A691 9CR | ASTM A691 9CR |  | ASTM A283 Gr.A
 |  |  |  |  | ABS EH32 | EN10225 S355G3+N | EN10025 S235J0 | ASME SA516 Dual Certified to Gr.65/70 | ASTM A514 Gr. F | ABS V-060 | API 5L X65 | ASTM A312 | API 5L X70 | API 5L X70 | ASTM A691 91 | ASTM A691 91 |  | ASTM A283 Gr.B
 |  |  |  |  | ABS FH32 | EN10225 S355G5+M | EN10025 S235J2 | ASME SA516 Dual Certified to Gr.65/70 HIC | ASTM A514 Gr. Q | ABS VH-039 | API 5L X65Q Dual Certified to EN10225 S460G6+QT | ASTM A335 P1 | API 5L X80 | ASTM A252 [NAME] | ASTM A672 C60 | ASTM A672 C60 |  | ASTM A283 Gr.C
 |  |  |  |  | ABS DH36 | EN10225 S355G7+M | EN10025 S355JR |  | ASTM A710 Gr.70 | ABS VH-060 | ASTM A106 Grade B | ASTM A335 P22 | ASTM A252 [NAME] | 200 Brinell | ASTM A790 UNS S31803 Duplex | ASTM A790 UNS S31803 Duplex |  | ASTM A284 Gr.C
 |  |  |  |  | ABS EH36 | EN10225 [NAME] | EN10025 S355J2 |  | EN10225 S690 Q | ABS 9%Ni QT | ASTM A106 Grade C | ASTM A335 P5 | ASTM A671 Gr. CC60 | 240 Brinell | ASTM A790 UNS S32205 Duplex | ASTM A790 UNS S32205 Duplex |  | ASTM A284 Gr.D
 |  |  |  |  | ABS FH36 | EN10225 S355G8+N | EN10025 S355K2 |  | EN10225 S690 QL | Lloyd's LT-AH | BS7191 355EM | ASTM A335 P9 | ASTM A671 Gr. CC65 |  |  |  |  | ASTM A36
 |  |  |  |  | ABS AH40 | EN10225 S355G9+M | EN10025 S355K2+N |  | EN10225 S690 QL1 | Lloyd's LT-DH |  | ASTM A335 P91 | ASTM A671 Gr. CC70 |  |  |  |  | ASTM A572 Gr.40
 |  |  |  |  | ABS DH40 | EN10225 S355G9+N | EN10025 S355J2G3 |  | DNV NVE500 | Lloyd's LT-EH |  | ASTM A333 Grade 1 | ASTM A672 Gr. [NAME] |  |  |  |  | ASTM A572 Gr.45
 |  |  |  |  | ABS EH40 | EN10225 S355G10+M | EN10025 S355J2G4 |  | DNV NVF500 | Lloyd's LT-FH |  | ASTM A333 Grade 2 | ASTM A672 Gr. C65 |  |  |  |  | ASTM A572 Gr.50
 |  |  |  |  | ABS FH40 | EN10225 S355G10+N | BS4360 40A |  | ABS EQ70 | [NAME] |  | ASTM A333 Grade 3 | ASTM A672 Gr. C70 |  |  |  |  | ASTM A572 Gr.60
 |  |  |  |  | DNV Grade A | EN10225 S355G11 | [NAME] |  | ABS FQ70 | [NAME] |  | ASTM A312 TP304/L | [NAME] 483 Cat 2 |  |  |  |  | ASTM A572 Gr.65
 |  |  |  |  | DNV Grade B | 355 EM | BS4360 40C |  | AR400 | DNV NV4-3 |  | ASTM A312 TP316/L |  |  |  |  |  | EN10025 S235JR
 |  |  |  |  | DNV Grade D | 355 EMZ | [NAME] |  | AR500 | DNV NV4-4 |  | ASTM A312 TP304/H |  |  |  |  |  | EN10025 S235J0
 |  |  |  |  | DNV Grade E |  | [NAME] |  | Armour Plate | [NAME] |  | ASTM A312 TP321/H |  |  |  |  |  | EN10025 S235J2
 |  |  |  |  | DNV NV A27S |  | BS4360 43B |  |  | DNV NV4-4L |  | ASTM A312 TP347/H |  |  |  |  |  | EN10025 S235J2+N
 |  |  |  |  | [NAME] |  | BS4360 43C |  |  |  |  | ASTM A376 TP304/L |  |  |  |  |  | EN10025 S275JR
 |  |  |  |  | DNV NV E27S |  | BS4360 50B |  |  |  |  | ASTM A376 TP316/L |  |  |  |  |  | EN10025 S275J0
 |  |  |  |  | [NAME] |  | BS4360 50C |  |  |  |  | ASTM A376 TP304/H |  |  |  |  |  | EN10025 S275J2
 |  |  |  |  | DNV NV D32 |  | [NAME] |  |  |  |  | ASTM A376 TP321/H |  |  |  |  |  | EN10025 S275J2+N
 |  |  |  |  | DNV NV E32 |  |  |  |  |  |  | ASTM A376 TP347/H |  |  |  |  |  | EN10025 S450J0
 |  |  |  |  | DNV NV A36 |  |  |  |  |  |  | ASTM A790 UNS S31803 Duplex |  |  |  |  |  | EN10025 S355JR
 |  |  |  |  | [NAME] |  |  |  |  |  |  | ASTM A790 UNS S32205 Duplex |  |  |  |  |  | EN10025 S355J0
 |  |  |  |  | DNV NV E36 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S355J2
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S355K2
 |  |  |  |  | DNV NV D40S |  |  |  |  |  |  |  |  |  |  |  |  | EN10225 S355G1
 |  |  |  |  | DNV NV E40S |  |  |  |  |  |  |  |  |  |  |  |  | EN10225 S355G1+N
 |  |  |  |  | DNV NV D420 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S355G4
 |  |  |  |  | DNV NV E420 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S355G4+M
 |  |  |  |  | DNV NV F420 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S355G11
 |  |  |  |  | Lloyd's Grade A |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Lloyd's Grade B |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S355G11+M
 |  |  |  |  | Lloyd's Grade D |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S355G12
 |  |  |  |  | Lloyd's Grade E |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S355G12+N
 |  |  |  |  | Lloyd's AH32 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S355G12+M
 |  |  |  |  | Lloyd's DH32 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S420G3
 |  |  |  |  | Lloyd's EH32 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S420G3+M
 |  |  |  |  | Lloyd's AH36 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S420G4
 |  |  |  |  | Lloyd's DH36 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S420G4+M
 |  |  |  |  | Lloyd's EH36 |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S460G3
 |  |  |  |  | Lloyd's AH34S |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S460G3+M
 |  |  |  |  | Lloyd's DH34S |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S460G4
 |  |  |  |  | Lloyd's EH34S |  |  |  |  |  |  |  |  |  |  |  |  | EN10025 S460G4+M
 |  |  |  |  | Lloyd's AH40 |  |  |  |  |  |  |  |  |  |  |  |  | AS/NZS 3679.1 Gr.300
 |  |  |  |  | Lloyd's DH40 |  |  |  |  |  |  |  |  |  |  |  |  | AS/NZS 3679.1 Gr.350
 |  |  |  |  | Lloyd's EH40
 |  |  |  |  | BV Grade A
 |  |  |  |  | BV Grade B
 |  |  |  |  | BV Grade D
 |  |  |  |  | BV Grade E
 |  |  |  |  | BV AH32
 |  |  |  |  | BV DH32
 |  |  |  |  | BV EH32
 |  |  |  |  | BV AH36
 |  |  |  |  | BV DH36
 |  |  |  |  | BV EH36
 |  |  |  |  | BV AH40
 |  |  |  |  | BV DH40
 |  |  |  |  | BV EH40
 |  |  |  |  | NKK KA
 |  |  |  |  | NKK KB
 |  |  |  |  | NKK KD
 |  |  |  |  | NKK KE
 |  |  |  |  | NKK KA32
 |  |  |  |  | NKK KD32
 |  |  |  |  | NKK KE32
 |  |  |  |  | NKK KA36
 |  |  |  |  | NKK KD36
 |  |  |  |  | NKK KE36
 |  |  |  |  | NKK KA40
 |  |  |  |  | NKK KD40
 |  |  |  |  | NKK KE40
 |  |  |  |  | NKK KA43
 |  |  |  |  | NKK KD43
 |  |  |  |  | NKK KE43
 |  |  |  |  | NKK KA47
 |  |  |  |  | NKK KD47
 |  |  |  |  | NKK KE47
 |  |  |  |  | NKK KA51
 |  |  |  |  | NKK KD51
 |  |  |  |  | NKK KA56
 |  |  |  |  | NKK KD56
 |  |  |  |  | NKK KA63
 |  |  |  |  | NKK KD63
 |  |  |  |  | NKK KA63N
 |  |  |  |  | NKK KF63
 |  |  |  |  | NKK KA70
 |  |  |  |  | NKK KD70
 |  |  |  |  | NKK KA70N
 |  |  |  |  | NKK KD70N
 |  |  |  |  | NKK KE70N