Each column represents one valve attribute and each attribute has a datatype and may also have some validation rules. The table below gives an explanation to this:
Column | Type | Unit/Format | Validation | Description |
|
|
|
|
|
Title | Free Text field |
| Mandatory value. | Valve Title. |
Group | Free Text field |
|
| Group can be used to categorize valves sharing a common relationship. E.g. Template XX valves. |
Location | Text |
|
| Attribute to be used to split the valve list by location. Can then be used in filtering e.g. when creating PowerBI reports
|
Tag | Free Text field |
|
| Functional tag number. |
Equipment Id | Free Text field |
|
| Unique identifier for valve hardware such as part number or ERP system identifier. |
Installation date | Date | MM/DD/YYYY |
| The date when the valve was installed. |
Subsea ROV marking | Free Text field |
|
| Subsea marking on the valve. |
Valve type | Free Text field |
|
| Type of valve, e.g., Ball, Gate or needle. |
Valve size | Number field (decimal format) | Inches | Number greater than 0 | Nominal valve size in inches. NB1: The field will display a decimal number, not a fraction. If you have the fraction value 7 1/16 in your Excel list, it will be displayed as 7.0625. NB2: Only use the punctuation character (.) in the Excel document. A comma (,) will not be respected and the number will be uploaded as a whole number (i.e. 7,0625 will be displayed as 70625). |
Pressure class (legacy) | Free Text field |
|
| Rated pressure class of the valve. E.g., 5K. |
Design Pressure | Number field (decimal format) | Bara/Barg/PSI |
| The maximum pressure per valve design standard, not the system pressure rating. |
Design pressure unit | Text field (forced list values) |
|
| Three valve pressure units: Bara, Barg and PSI |
Interface type (legacy) | Free Text field |
|
| Valve operation interface type, e.g. ROV operated valve. |
Interface class or size (legacy) | Free Text field |
|
| Valve class, e.g. type 2. |
Valve Interface Type | Text field (forced list values) |
|
| Interface type and size on the valve for ROV/Diver operation.
|
Material number | Free Text field |
|
| Material number is used to identify type of valves, sharing some of the same features. |
Turns to open | Number field (decimal format) |
| Number greater than 0 | Number of turns to open the valve. NB1: The field will display a decimal number, not a number with +/- turns. If you have the value 7 +/- 0.5 in your Excel list, the upload will give an error. NB2: Only use the punctuation character (.) in the Excel document. A comma (,) will not be respected and the number will be uploaded as a whole number (i.e. 7,5 will be displayed as 75). |
Direction to open | Text field (forced list values) |
| The input value must be written as either 'Clockwise' or 'CounterClockwise' (NB: input value must be as one word and the C's in the words doesn't have to be capitalized). | Direction to open. Either Clockwise or Counter-clockwise. If you have CCW in your Excel document, the upload will return an error message and the upload won't finish. |
Description | Free Text field |
|
| Free text field used to provide further context to valve. |
Break out torque | Number (decimal format) | Nm | Number greater than 0 | End-to-close, Start-to-open torque in Nm. NB: Only use the punctuation character (.) in the Excel document. A comma (,) will not be respected and the number will be uploaded as a whole number (i.e. the value 100,5 will be displayed as 1005). |
Running torque | Number (decimal format) | Nm | Number greater than 0. Cannot be higher than 'do not exceed' torque. | Expected average running torque per design in Nm. This could also be known as 'Minimum Input Torque' or 'Nominal Torque' from some valve suppliers'
NB: Only use the punctuation character (.) in the Excel document. A comma (,) will not be respected and the number will be uploaded as a whole number (i.e. the value 100,5 will be displayed as 1005). |
Max input torque | Number (decimal format) | Nm | Number greater than 0. Should be less than 'do not exceed' torque. | Absolute max applied torque (in Nm) during valve operations. This could also be known as 'Maximum Input Torque' , Do not exceed torque’, “Max Applied Torque” or “Maximum Allowable Torque” from some valve suppliers. Applying higher torque than Max Input Torque shall always be consulted with applicable valve supplier |
Damage torque | Number (decimal format) | Nm | Number greater than 0 | This could also be known as Damage Input torque or Maximum Allowable Stem Torque (MAST) from some valve suppliers. Applying higher torque than Damage Torque shall always be consulted with the valve supplier.
NB: Only use the punctuation character (.) in the Excel document. A comma (,) will not be respected and the number will be uploaded as a whole number (i.e. the value 100,5 will be displayed as 1005). |
Valve Id [GUID] | Guid (auto-generated by the system) |
|
| Unique identifier (database primary key) for this valve. If this column is empty it means that a new valve will be created. NB: Do NOT insert any values in this column or write over existing values if you have downloaded the Excel document. This value is needed for the system to find the unique valve (if already existing) or the system produces a new value if you want to create a new valve.
|
Is remotely capable | Choice | No / Yes |
| This is a valve property indicating that the valve can be remotely operated. If this proerty is Yes, then Control mode can either be Manual or Remote |
Control mode | Choice | Manual / Remote |
| This property indicates if this valve is currently Remotely operated (by the control room) or not |