{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["User_Guide","FrontSheet","Inputs (No Stream Selection)","Inputs Tandem(Stream Selection)","Inputs Tandem(No Stream Sel)","Inputs (Stream Selection)","Inputs (Single Stream)","SingleStream - Pressure Control","S-S - Pressure Control Tandem","No S-S -Pressure Control Tandem","No S-S - Pressure Control","S-S - Pressure Control","No S-S - Volumetric","S-S - Volumetric","Data Tandem(stream selection)","DataCheck Tandem(no stream sel)","DataCheck (Single stream)","DataCheck (stream selection)","DataCheck (no stream selection)","TD13 %ages","Sheet1","Cases","Worked Examples"],"not_rendered":{"charts":5,"images":7,"macros":1,"external_links":0,"defined_names":115,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User_Guide","index":0,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,2,2],[13,0,13,2]]}
["TD13 Site Settings Calculator - User Guide"]
[]
["Warning - This calculator will not work if 'saved as', please use as 'read only'"]
[]
["Front Sheet"]
["Step 1",": Select number of streams present at the pressure regulating installation"]
["Step 2",": Select if there is stream selection present, either by non-return valves or a pilot operated system"]
[null,": If present, the slam shut settings will be the same if multi stream"]
["Step 3",": Select type of control on site from 3 options: Pressure/Volumetric or Tandem Pressure Control"]
["Step 4",": If there is seasonal settings or High/Low limits for profile control, then press the corresponding button"]
[null,": This will give an option to manually add settings to the output sheets"]
["Step 5",": When you are happy with the selctions, go to the Inputs Tab"]
[]
["Clear All Selections' button will allow you to start the process again "]
[]
["Inputs Tab: Mechanical Downstream"]
["Step 1",": Static Asset Data like Site Name is entered into lines 1 to 6"]
["Step 2",": If there are test certificates to justify a MIP of 1.33 MOP, enter Yes in C8"]
["Step 3",": Enter Maximum Operating Pressure of downstream system (MOPd) in C9"]
["Step 4",": Enter Accuracy Class (AC) of the Monitor regulator in C10"]
["Step 5",": Enter Accuracy Class (AC) of the Active regulator in C11"]
["Step 6",": Enter Accuracy Group (AG) of the Slam Shut valves in C12"]
["Step 6",": Additional Safety Margins can be entered to space out settings "]
[null,"CR = Creep Relief, MR = Monitor Regulator, AR = Active Regulator, WS = Working Stream, SS = Standby Stream"]
[null,"SSV = SlamShutValve"]
["Step 7",": If there is volumetric control, enter Yes in C18"]
["Step 8",": You can overwrite component set points using the operational settings section, if predetermined levels and accuracies will allow"]
[]
["Results 1",": Major component settings are calculated and given in relation to TD13 pre defined levels"]
["Results 2",": Editable graphical representation given to ensure all setting are set appropriately and in relation to each other"]
[]
["Inputs Tab: Upstream Pressure and Electrical & Instrumentation"]
["Step 1",": Input Maximum Upstream Operating Pressure MOPu"]
["Step 2",": If there is an inlet high hardware alarm, enter Yes"]
["Step 3",": Inlet Temp Hardware Low is from modelled minimum pressure for peak demand times"]
["Step 4",": High/Low Temp alarm levels to be entered as appropriately"]
["Step 5",": Outlet pressure high and low alarms are auto populated or based on rules described "]
[]
["Results 3",": Site Setting Sheets displayed with Mechanical and Electrical & Instrumentation"]

{"sheet":"FrontSheet","index":1,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,24,5],[0,0,0,5]]}
["TD13 Site Settings Calculator "]
[null,"How many streams are present on site?"]
[null,"Is there stream selection present on site?"]
[null,"What is the site control type?"]
[]
[null,null,{"$f":"IF(C4=\"\",\"\",IF(AND(C4=\"Volumetric\",C3=\"No\"),\"No S-S - Volumetric\",IF(AND(C4=\"Volumetric\",C3=\"Yes\"),\"S-S - Volumetric\",IF(AND(C4=\"Pressure Control\",C3=\"Yes\"),\"S-S - Pressure Control\",IF(AND(C4=\"Pressure Control\",C3=\"No\"),\"No S-S - Pressure Control\",IF(AND(C4=\"Tandem Pressure Control\",C3=\"Yes\"),\"S-S - Pressure Control Tandem\",\"No S-S -Pressure Control Tandem\"))))))","v":""}]
[null,null,{"$f":"IF(C2=\"\",\"\",IF(C2=\"One\",\"Single Stream\",\"\"))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["© 2018 Wales & West Utilities LTD ALL RIGHTS RESERVED"]
["All information and Content in this TD13 Site Settings Calculator is the property of Wales & West Utilities LTD. Any unauthorized use of the Content will be considered a violation of Wales & West Utilities intellectual property rights. Unless otherwise stated in this document, Wales & West Utilities LTD reserve all tacit and direct rights to patents, trademarks, copyrights or confidential information relating to the Content. Unless otherwise stated in this document, no Content may be copied, distributed, published or used in any way, in whole or in part, without prior written agreement from Wales & West Utilities LTD. These Conditions of Use do NOT give you permission to, reproduce, reverse engineer, decompile, disassemble, modify or create derivative works with respect to the TD13 Site Settings Calculator."]

{"sheet":"Inputs (No Stream Selection)","index":2,"n_rows":73,"n_cols":9,"rows_kept":73,"cut":false,"hidden":true,"merged":[[6,0,6,8],[0,2,0,5],[4,2,4,5],[3,2,3,5],[2,2,2,5],[1,2,1,5],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[5,2,5,5],[50,0,50,8],[54,0,54,8],[31,0,31,8],[70,0,70,8],[72,0,73,8],[65,0,65,8]]}
["SITE NAME  "]
["SAP Functional Location "]
["Drawing Ref & Rev. Used"]
["Telemetry System"]
["Date  "]
["Version  "]
[{"$f":"CONCATENATE(\"Downstream Pressure <= \",IF(C9<=0.1,0.1,IF(C9<=1,1,IF(C9<=2,2,IF(C9<=7,7,IF(C9<=100,100,\"Error\"))))),\" barg\")","v":"Downstream Pressure <= 0.1 barg"}]
["Test Certificates for 2 to 7 barg",null,"No","Yes/No"]
["Maximum Downstream Operating Pressure (MOPd)",null,null,"Barg"]
["Accuracy Class of Monitor Regulator (AC)","±",null,null,null,null,"Operational Settings:","(set default as 999)"]
["Accuracy Class of Active Regulator (AC)","±",null,null,null,null,"Slamshut WS",999,{"$f":"IF(H11>E22,\"exceeds max\",\"\")","v":"exceeds max"}]
["Accuracy Group of Slam Shuts (AG)","±",null,null,null,null,"Monitor Regulator WS",999,{"$f":"IF(H12>E26,\"exceeds max\",\"\")","v":"exceeds max"}]
[null,null,null,null,null,null,"Active Regulator WS",999,{"$f":"IF(H13>E30,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) CR & MR (WS &SS)",null,0,null,null,null,"Slamshut SS",999,{"$f":"IF(H14>H22,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) MR & AR (WS)",null,0,null,null,null,"Monitor Regulator SS",999,{"$f":"IF(H15>H26,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) AR WS & SS",null,0,null,null,null,"Active Regulator SS",999,{"$f":"IF(H16>H30,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) SSV (WS) & CR",null,0]
["Additional Safety Margin (ASM) SSV (WS & SS)",null,0]
["Volumetric Control?",null,"no","Yes/No"]
["NO STREAM SELECTION",null,"%MOP",null,"Working Stream (WS) - Proposed Settings  (Barg)",null,"%MOP","Standby  Stream (SS) - Proposed Settings (Barg)"]
[{"$f":"'DataCheck (no stream selection)'!E10","v":"TD13 Maximum Incidental Pressure (MIP)"},null,{"$f":"E21/$C$9","v":{"$error":"#DIV/0!"}},null,{"$f":"'DataCheck (no stream selection)'!F10","v":0.2},null,{"$f":"H21/$C$9","v":{"$error":"#DIV/0!"}},{"$f":"'DataCheck (no stream selection)'!C10","v":0.2}]
[{"$f":"'DataCheck (no stream selection)'!E11","v":"Slam Shut Valve (SSV)"},null,{"$f":"E22/$C$9","v":{"$error":"#DIV/0!"}},null,{"$f":"'DataCheck (no stream selection)'!F11","v":0.2},null,{"$f":"H22/$C$9","v":{"$error":"#DIV/0!"}},{"$f":"'DataCheck (no stream selection)'!C11","v":0.2}]
[{"$f":"'DataCheck (no stream selection)'!E12","v":"Creep Relief (CR)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (no stream selection)'!F12","v":0.2},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck (no stream selection)'!C12","v":0.2}]
[{"$f":"'DataCheck (no stream selection)'!E14","v":"TD13 Temporary Operating Pressure (TOP)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (no stream selection)'!F14","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck (no stream selection)'!C14","v":0}]
[{"$f":"'DataCheck (no stream selection)'!E15","v":"Calculated TOP"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (no stream selection)'!F15","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck (no stream selection)'!C15","v":0}]
[{"$f":"'DataCheck (no stream selection)'!E16","v":"Monitor Regulator (MR)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (no stream selection)'!F16","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck (no stream selection)'!C16","v":0}]
[{"$f":"'DataCheck (no stream selection)'!E17","v":"Lower Accuracy Level MR"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (no stream selection)'!F17","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck (no stream selection)'!C17","v":0}]
[{"$f":"'DataCheck (no stream selection)'!E19","v":"TD13 Peak Level Operating Pressure (PLOP)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (no stream selection)'!F19","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck (no stream selection)'!C19","v":0}]
[{"$f":"'DataCheck (no stream selection)'!E20","v":"Calculated PLOP"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (no stream selection)'!F20","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck (no stream selection)'!C20","v":0}]
[{"$f":"'DataCheck (no stream selection)'!E21","v":"Active Regulator (AR)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (no stream selection)'!F21","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck (no stream selection)'!C21","v":0}]
[]
["Proposed Settings Graph"]
[]
["MIP (SSV + AG on SS)",null,{"$f":"H21","v":0.2},{"$f":"C34","v":0.2},{"$f":"D34","v":0.2},0.2,0.2,0.2]
["Slam Shut Valve (SS)",null,{"$f":"H22","v":0.2},0.2,{"$f":"D35","v":0.2},0.2,0.2,0.2]
["SSV - AG (SS)",null,{"$f":"(1-C12)*C35","v":0.2},0.2,{"$f":"D36","v":0.2},0.2,0.2,0.2]
["SSV + AG (WS)",null,{"$f":"(1+C12)*C38","v":0.2},0.2,{"$f":"D37","v":0.2},0.2,0.2,0.2]
["Slam Shut Valve (WS)",null,{"$f":"E22","v":0.2},0.2,{"$f":"D38","v":0.2},0.2,0.2,0.2]
["SSV - AG (WS)",null,{"$f":"C38*(1-C12)","v":0.2},0.2,0.2,0.2,0.2,0.2]
["Creep Relief (WS & SS) ",null,{"$f":"E23","v":0.2},{"$f":"C40","v":0.2},0.2,0.2,0.2,0.2]
["MR + AC (WS & SS)",null,{"$f":"C42*(1+C10)","v":0},0,0,0,0,0]
["Monitor Regulator (WS & SS)",null,{"$f":"E26","v":0},0,0,0,0,0]
["MR - AC (WS & SS)",null,{"$f":"C42*(1-C10)","v":0},0,0,0,0,0]
["AR + AC (WS)",null,{"$f":"(1+C11)*C45","v":0},0,0,0,0,0]
["Active Regulator (WS)",null,{"$f":"E30","v":0},{"$f":"C45","v":0},0,0,0,0]
["AR - AC (WS)",null,{"$f":"(1-C11)*C45","v":0},{"$f":"C46","v":0},0,0,0,0]
["AR + AC (SS)",null,{"$f":"(1+C11)*C48","v":0},0,0,0,0,0]
["Active Regulator (SS)",null,{"$f":"H30","v":0},0,0,0,0,0]
["AR - AC (SS)",null,{"$f":"(1-C11)*C48","v":0},0,0,0,0,0]
[]
[{"$f":"CONCATENATE(\"Upstream Pressure <= \",IF(C52<=0.1,0.1,IF(C52<=1,1,IF(C52<=2,2,IF(C52<=7,7,IF(C52<=100,100,\"Error\"))))),\" barg\")","v":"Upstream Pressure <= 0.1 barg"}]
["Maximum Upstream Operating Pressure MOPu",null,null,"barg"]
["TD13 Maximum Incidental Pressure (MIP) (SOL)",null,{"$f":"IF(AND(C52>0,C52<='TD13 %ages'!A2),C52*'TD13 %ages'!D2,IF(AND(C52>0.1,C52<='TD13 %ages'!A3),C52*'TD13 %ages'!D3,IF(AND(C52>'TD13 %ages'!A3,C52<='TD13 %ages'!A4),C52*'TD13 %ages'!D4,IF(AND(C52>'TD13 %ages'!A4,C52<='TD13 %ages'!A5),C52*'TD13 %ages'!D5,IF(AND(C52>'TD13 %ages'!A5,C52<='TD13 %ages'!A6),C52*'TD13 %ages'!D6,\"Out of Range\")))))","v":"Out of Range"},"barg"]
[]
["Electrical & Instrumentation"]
["Hardware inlet high telemetered?",null,null,"Yes/No"]
["Inlet Pressure Hardware High ",null,{"$f":"IF(C56=\"Yes\", (IF(C52>69.9999,\"NTS\",IF(AND(C52>0,C52<='TD13 %ages'!A2),C52*'TD13 %ages'!B2,IF(AND(C52>0.1,C52<='TD13 %ages'!A3),C52*'TD13 %ages'!B3,IF(AND(C52>'TD13 %ages'!A3,C52<='TD13 %ages'!A4),C52*'TD13 %ages'!B4,IF(AND(C52>'TD13 %ages'!A4,C52<='TD13 %ages'!A5),C52*'TD13 %ages'!B5,IF(AND(C52>'TD13 %ages'!A5,C52<='TD13 %ages'!A6),C52*'TD13 %ages'!B6,\"Out of Range\"))))))),\"N/A\")","v":"N/A"},"barg","Equal to Peak Level Operating Pressure Upstream or N/A"]
["Inlet Pressure Hardware Low",null,null,"barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Inlet Temp Hardware High",null,30,"0C"]
["Inlet Temp Hardware Low",null,-3,"0C"]
["Outlet Pressure Hardware High ",null,{"$f":"E26","v":0},"barg","Equal to Monitor Setting on the working stream"]
["Outlet Pressure Hardware Low",null,{"$f":"H30","v":0},"barg","Equal to active setting on the standby stream"]
["Outlet Pressure Hardware Low Volumetric",null,0,"barg","For volumetric order is Hardware, Electronic, pneumatic"]
["Outlet Temp Hardware High",null,30,"0C"]
["Outlet Temp Hardware Low",null,-3,"0C"]
["Volumetric Overrides"]
["Electronic High",null,"N/A","barg","Based on MOP/active regulator WS setting"]
["Pneumatic High",null,"N/A","barg","Based on MOP or PLOP, rule of thumb is 0.5 bar higher than electronic"]
["Electronic Low",null,"N/A","barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Pneumatic Low",null,"N/A","barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Notes"]
[]
["Standby stream active regulator is set 2 x AC plus an Additional Safety Margin if required below the active regulator on the working stream.   If no creep relief setting present, set the ASM between the SSV and CR to 0 and ignore creep relief setting.            "]

{"sheet":"Inputs Tandem(Stream Selection)","index":3,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":true,"merged":[[66,0,67,8],[6,0,6,8],[25,0,25,8],[44,0,44,8],[48,0,48,8],[59,0,59,8],[65,0,65,8],[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[0,0,0,1],[0,2,0,5],[1,0,1,1],[1,2,1,5],[2,0,2,1],[2,2,2,5]]}
["SITE NAME  "]
["SAP Functional Location "]
["Drawing Ref & Rev. Used"]
["Telemetry System"]
["Date  "]
["Version  "]
[{"$f":"CONCATENATE(\"Downstream Pressure <= \",IF(C9<=0.1,0.1,IF(C9<=1,1,IF(C9<=2,2,IF(C9<=7,7,IF(C9<=100,100,\"Error\"))))),\" barg\")","v":"Downstream Pressure <= 0.1 barg"}]
["Test Certificates for 2 to 7 barg systems",null,"no","*"]
["Maximum Downstream Operating Pressure (MOPd)",null,null,"barg",null,null,"Operational Settings:","(set default as 999)"]
["Accuracy Class of Regulator (AC)","±",null,null,null,null,"Slamshut",999,{"$f":"IF(H10>E19,\"exceeds max\",\"\")","v":"exceeds max"}]
["Accuracy Group of Slam Shuts (AG)","±",null,null,null,null,"Active Regulator",999,{"$f":"IF(H11>E23,\"exceeds max\",\"\")","v":"exceeds max"}]
[null,null,null,null,null,null,"Active Regulator SS",999,{"$f":"IF(H12>E24,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) CR & AR/MR",null,0]
["Additional Safety Margin (ASM) AR/MR WS & SS",null,0]
["Additional Safety Margin (ASM) SSV & CR",null,0]
["Volumetric Control?",null,"no","Yes/No"]
["STREAM SELECTION",null,"%MOP",null,"Proposed Settings (barg)"]
[{"$f":"'Data Tandem(stream selection)'!A10","v":"TD13 Maximum Incidental Pressure (MIP)"},null,{"$f":"E18/$C$9","v":{"$error":"#DIV/0!"}},null,{"$f":"'Data Tandem(stream selection)'!C10","v":0.2}]
[{"$f":"'Data Tandem(stream selection)'!A11","v":"Slam Shut Valve (SSV) - Both Streams"},null,{"$f":"E19/$C$9","v":{"$error":"#DIV/0!"}},null,{"$f":"'Data Tandem(stream selection)'!C11","v":0.2}]
[{"$f":"'Data Tandem(stream selection)'!A12","v":"Creep Relief (CR) - Both Streams"},null,{"$error":"#DIV/0!"},null,{"$f":"'Data Tandem(stream selection)'!C12","v":0.2}]
[{"$f":"'Data Tandem(stream selection)'!A14","v":"TD13 Peak Level Operating Pressure (PLOP)"},null,{"$error":"#DIV/0!"},null,{"$f":"'Data Tandem(stream selection)'!C14","v":0}]
[{"$f":"'Data Tandem(stream selection)'!A15","v":"Calculated PLOP"},null,{"$error":"#DIV/0!"},null,{"$f":"'Data Tandem(stream selection)'!C15","v":0}]
[{"$f":"'Data Tandem(stream selection)'!A16","v":"Active & Monitor Regulator (AR/MR) - Working Stream"},null,{"$error":"#DIV/0!"},null,{"$f":"'Data Tandem(stream selection)'!C16","v":0}]
[{"$f":"'Data Tandem(stream selection)'!A18","v":"Active & Monitor Regulator (AR/MR) - Standby Stream"},null,{"$error":"#DIV/0!"},null,{"$f":"'Data Tandem(stream selection)'!C18","v":0}]
[]
["Downstream Proposed Settings Graph"]
[]
["MIP (SSV + AG) (WS & SS)",null,{"$f":"E18","v":0.2},{"$f":"C28","v":0.2},{"$f":"D28","v":0.2},0.2,0.2,0.2]
["Slam Shut Valve (WS & SS)",null,{"$f":"E19","v":0.2},0.2,0.2,0.2,0.2,0.2]
["SSV - AG (WS & SS)",null,{"$f":"(1-C11)*C29","v":0.2},{"$f":"C30","v":0.2},0.2,0.2,0.2,0.2]
["Creep Relief (WS & SS) (SSV - AG)",null,{"$f":"E20","v":0.2},0.2,0.2,0.2,0.2,0.2]
["MR + AC (WS & SS)",null,{"$f":"C33*(1+C10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Monitor Regulator (WS & SS)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C33","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["MR - AC (WS & SS)",null,{"$f":"C33*(1-C10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["AR/MR + AC (WS)",null,{"$f":"(1+C10)*C36","v":0},0,0,0,0,0]
["Active & Monitor Regulator (WS)",null,{"$f":"E23","v":0},{"$f":"C36","v":0},0,0,0,0]
["AR/MR - AC (WS)",null,{"$f":"(1-C10)*C36","v":0},{"$f":"C37","v":0},0,0,0,0]
["AR/MR + AC (SS)",null,{"$f":"(1+C10)*C39","v":0},0,0,0,0,0]
["Active & Monitor Regulator (SS)",null,{"$f":"E24","v":0},0,0,0,0,0]
["AR/MR - AC (SS)",null,{"$f":"(1-C10)*C39","v":0},0,0,0,0,0]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"Upstream Pressure <= \",IF(C46<=0.1,0.1,IF(C46<=1,1,IF(C46<=2,2,IF(C46<=7,7,IF(C46<=100,100,\"Error\"))))),\" barg\")","v":"Upstream Pressure <= 0.1 barg"}]
["Maximum Upstream Operating Pressure MOPu",null,null,"barg"]
["TD13 Maximum Incidental Pressure (MIP) (SOL)",null,{"$f":"IF(AND(C46>0,C46<='TD13 %ages'!A2),C46*'TD13 %ages'!D2,IF(AND(C46>0.1,C46<='TD13 %ages'!A3),C46*'TD13 %ages'!D3,IF(AND(C46>'TD13 %ages'!A3,C46<='TD13 %ages'!A4),C46*'TD13 %ages'!D4,IF(AND(C46>'TD13 %ages'!A4,C46<='TD13 %ages'!A5),C46*'TD13 %ages'!D5,IF(AND(C46>'TD13 %ages'!A5,C46<='TD13 %ages'!A6),C46*'TD13 %ages'!D6,\"Out of Range\")))))","v":"Out of Range"},"barg"]
[]
["Electrical & Instrumentation"]
["Hardware inlet high telemetered?",null,null,"Yes/No"]
["Inlet Pressure Hardware High ",null,{"$f":"IF(C50=\"Yes\", (IF(C46>69.9999,\"NTS\",IF(AND(C46>0,C46<='TD13 %ages'!A2),C46*'TD13 %ages'!B2,IF(AND(C46>0.1,C46<='TD13 %ages'!A3),C46*'TD13 %ages'!B3,IF(AND(C46>'TD13 %ages'!A3,C46<='TD13 %ages'!A4),C46*'TD13 %ages'!B4,IF(AND(C46>'TD13 %ages'!A4,C46<='TD13 %ages'!A5),C46*'TD13 %ages'!B5,IF(AND(C46>'TD13 %ages'!A5,C46<='TD13 %ages'!A6),C46*'TD13 %ages'!B6,\"Out of Range\"))))))),\"N/A\")","v":"N/A"},"barg","Equal to Peak Level Operating Pressure Upstream"]
["Inlet Pressure Hardware Low",null,null,"barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Inlet Temp Hardware High",null,30,"0C"]
["Inlet Temp Hardware Low",null,-3,"0C"]
["Outlet Pressure Hardware High ",null,{"$f":"E22+((E19-E22)/2)","v":0.1},"barg","Half way between SSV and Calculated PLOP"]
["Outlet Pressure Hardware Low",null,{"$f":"E24","v":0},"barg","Equal to active setting on the standby stream"]
["Outlet Pressure Hardware Low Volumetric",null,0,"barg","For volumetric order is Hardware, Electronic, pneumatic"]
["Outlet Temp Hardware High",null,30,"0C"]
["Outlet Temp Hardware Low",null,-3,"0C"]
["Volumetric Overrides"]
["Electronic High",null,0,"barg","Based on MOP/active regulator WS setting"]
["Pneumatic High",null,0,"barg","Based on PLOP, rule of thumb is 0.5 bar higher than electronic"]
["Electronic Low",null,0,"barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Pneumatic Low",null,0,"barg","Based on minimum modelled pressure for 1 in 20 conditions"]
[]
["Notes"]
["Standby stream active regulator is set 2 x AC plus an Additional Safety Margin if required delow the active regulator on the working stream.     If no creep relief present, set the ASM detween the SSV and the CR to 0 and ignore the creep relief setting.             "]

{"sheet":"Inputs Tandem(No Stream Sel)","index":4,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":true,"merged":[[66,0,67,8],[6,0,6,8],[25,0,25,8],[44,0,44,8],[48,0,48,8],[59,0,59,8],[64,0,64,8],[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[0,0,0,1],[0,2,0,5],[1,0,1,1],[1,2,1,5],[2,0,2,1],[2,2,2,5]]}
["SITE NAME  "]
["SAP Functional Location "]
["Drawing Ref & Rev. Used"]
["Telemetry System"]
["Date  "]
["Version  "]
[{"$f":"CONCATENATE(\"Downstream Pressure <= \",IF(C9<=0.1,0.1,IF(C9<=1,1,IF(C9<=2,2,IF(C9<=7,7,IF(C9<=100,100,\"Error\"))))),\" barg\")","v":"Downstream Pressure <= 0.1 barg"}]
["Test Certificates for 2 to 7 barg",null,"No","Yes/No"]
["Maximum Downstream Operating Pressure (MOPd)",null,null,"Barg",null,null,"Operational Settings:","(set default as 999)"]
["Accuracy Class of Regulator (AC)","±",null,null,null,null,"Slamshut WS",999,{"$f":"IF(H10>E20,\"exceeds max\",\"\")","v":"exceeds max"}]
["Accuracy Group of Slam Shuts (AG)","±",null,null,null,null,"Active Regulator WS",5.6929999999999996,{"$f":"IF(H11>E24,\"exceeds max\",\"\")","v":"exceeds max"}]
[null,null,null,null,null,null,"Slamshut SS",999,{"$f":"IF(H12>H20,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) CR & AR/MR (WS)",null,0,null,null,null,"Active Regulator SS",999,{"$f":"IF(H13>H24,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) AR/MR WS & SS",null,0]
["Additional Safety Margin (ASM) SSV (WS) & CR",null,0]
["Additional Safety Margin (ASM) SSV (WS & SS)",null,0]
["Volumetric Control?",null,"no","Yes/No"]
["NO STREAM SELECTION",null,"%MOP",null,"Working Stream (WS) - Proposed Settings  (Barg)",null,"%MOP","Standby  Stream (SS) - Proposed Settings (Barg)"]
[{"$f":"'DataCheck Tandem(no stream sel)'!E9","v":"TD13 Maximum Incidental Pressure (MIP)"},null,{"$f":"E19/$C$9","v":{"$error":"#DIV/0!"}},null,{"$f":"'DataCheck Tandem(no stream sel)'!F9","v":0.2},null,{"$f":"H19/$C$9","v":{"$error":"#DIV/0!"}},{"$f":"'DataCheck Tandem(no stream sel)'!C9","v":0.2}]
[{"$f":"'DataCheck Tandem(no stream sel)'!E10","v":"Slam Shut Valve (SSV)"},null,{"$f":"E20/$C$9","v":{"$error":"#DIV/0!"}},null,{"$f":"'DataCheck Tandem(no stream sel)'!F10","v":0.2},null,{"$f":"H20/$C$9","v":{"$error":"#DIV/0!"}},{"$f":"'DataCheck Tandem(no stream sel)'!C10","v":0.2}]
[{"$f":"'DataCheck Tandem(no stream sel)'!E11","v":"Creep Relief (CR)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck Tandem(no stream sel)'!F11","v":0.2},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck Tandem(no stream sel)'!C11","v":0.2}]
[{"$f":"'DataCheck Tandem(no stream sel)'!E18","v":"TD13 Peak Level Operating Pressure (PLOP)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck Tandem(no stream sel)'!F18","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck Tandem(no stream sel)'!C18","v":0}]
[{"$f":"'DataCheck Tandem(no stream sel)'!E19","v":"Calculated PLOP"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck Tandem(no stream sel)'!F19","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck Tandem(no stream sel)'!C19","v":0}]
[{"$f":"'DataCheck Tandem(no stream sel)'!E20","v":"Active & Monitor Regulator (AR)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck Tandem(no stream sel)'!F20","v":0},null,{"$error":"#DIV/0!"},{"$f":"'DataCheck Tandem(no stream sel)'!C20","v":0}]
[]
["Proposed Settings Graph"]
[]
["MIP (SSV + AG on SS)",null,{"$f":"H19","v":0.2},{"$f":"C28","v":0.2},0.2,0.2,0.2,0.2]
["Slam Shut Valve (SS)",null,{"$f":"H20","v":0.2},0.2,0.2,0.2,0.2,0.2]
["SSV - AG (SS)",null,{"$f":"(1-C11)*C29","v":0.2},0.2,0.2,0.2,0.2,0.2]
["SSV + AG (WS)",null,{"$f":"(1+C11)*C32","v":0.2},0.2,0.2,0.2,0.2,0.2]
["Slam Shut Valve (WS)",null,{"$f":"E20","v":0.2},0.2,0.2,0.2,0.2,0.2]
["SSV - AG (WS)",null,{"$f":"C32*(1-C11)","v":0.2},0.2,0.2,0.2,0.2,0.2]
["Creep Relief (WS & SS) ",null,{"$f":"E21","v":0.2},0.2,0.2,0.2,0.2,0.2]
["MR + AC (WS & SS)",null,{"$f":"C36*(1+C10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Monitor Regulator (WS & SS)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["MR - AC (WS & SS)",null,{"$f":"C36*(1-C10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["AR/MR + AC (WS)",null,{"$f":"(1+C10)*C39","v":0},0,0,0,0,0]
["Active & Monitor Regulator (WS)",null,{"$f":"E24","v":0},{"$f":"C39","v":0},0,0,0,0]
["AR/MR - AC (WS)",null,{"$f":"(1-C10)*C39","v":0},{"$f":"C40","v":0},0,0,0,0]
["AR/MR + AC (SS)",null,{"$f":"(1+C10)*C42","v":0},0,0,0,0,0]
["Active & Monitor Regulator (SS)",null,{"$f":"H24","v":0},0,0,0,0,0]
["AR/MR - AC (SS)",null,{"$f":"(1-C10)*C42","v":0},0,0,0,0,0]
[]
[{"$f":"CONCATENATE(\"Upstream Pressure <= \",IF(C46<=0.1,0.1,IF(C46<=1,1,IF(C46<=2,2,IF(C46<=7,7,IF(C46<=100,100,\"Error\"))))),\" barg\")","v":"Upstream Pressure <= 0.1 barg"}]
["Maximum Upstream Operating Pressure MOPu",null,null,"barg"]
["TD13 Maximum Incidental Pressure (MIP) (SOL)",null,{"$f":"IF(AND(C46>0,C46<='TD13 %ages'!A2),C46*'TD13 %ages'!D2,IF(AND(C46>0.1,C46<='TD13 %ages'!A3),C46*'TD13 %ages'!D3,IF(AND(C46>'TD13 %ages'!A3,C46<='TD13 %ages'!A4),C46*'TD13 %ages'!D4,IF(AND(C46>'TD13 %ages'!A4,C46<='TD13 %ages'!A5),C46*'TD13 %ages'!D5,IF(AND(C46>'TD13 %ages'!A5,C46<='TD13 %ages'!A6),C46*'TD13 %ages'!D6,\"Out of Range\")))))","v":"Out of Range"},"barg"]
[]
["Electrical & Instrumentation"]
["Hardware inlet high telemetered?",null,null,"Yes/No"]
["Inlet Pressure Hardware High ",null,{"$f":"IF(C50=\"Yes\", (IF(C46>69.9999,\"NTS\",IF(AND(C46>0,C46<='TD13 %ages'!A2),C46*'TD13 %ages'!B2,IF(AND(C46>0.1,C46<='TD13 %ages'!A3),C46*'TD13 %ages'!B3,IF(AND(C46>'TD13 %ages'!A3,C46<='TD13 %ages'!A4),C46*'TD13 %ages'!B4,IF(AND(C46>'TD13 %ages'!A4,C46<='TD13 %ages'!A5),C46*'TD13 %ages'!B5,IF(AND(C46>'TD13 %ages'!A5,C46<='TD13 %ages'!A6),C46*'TD13 %ages'!B6,\"Out of Range\"))))))),\"N/A\")","v":"N/A"},"barg","Equal to Peak Level Operating Pressure Upstream or N/A"]
["Inlet Pressure Hardware Low",null,null,"barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Inlet Temp Hardware High",null,30,"0C"]
["Inlet Temp Hardware Low",null,-3,"0C"]
["Outlet Pressure Hardware High ",null,{"$f":"E23+((E20-E23)/2)","v":0.1},"barg","Half way between SSV and calculated PLOP"]
["Outlet Pressure Hardware Low",null,{"$f":"H24","v":0},"barg","Equal to active setting on the standby stream"]
["Outlet Pressure Hardware Low Volumetric",null,0,"barg","For volumetric order is Hardware, Electronic, pneumatic"]
["Outlet Temp Hardware High",null,30,"0C"]
["Outlet Temp Hardware Low",null,-3,"0C"]
["Volumetric Overrides"]
["Electronic High",null,"N/A","barg","Based on MOP/active regulator WS setting"]
["Pneumatic High",null,"N/A","barg","Based on MOP or PLOP, rule of thumb is 0.5 bar higher than electronic"]
["Electronic Low",null,"N/A","barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Pneumatic Low",null,"N/A","barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Notes"]
[]
["Standby stream active regulator is set 2 x AC plus an Additional Safety Margin if required below the active regulator on the working stream.   If no creep relief setting present, set the ASM between the SSV and CR to 0 and ignore creep relief setting.            "]

{"sheet":"Inputs (Stream Selection)","index":5,"n_rows":73,"n_cols":9,"rows_kept":73,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[31,0,31,8],[2,2,2,5],[0,0,0,1],[1,0,1,1],[2,0,2,1],[71,0,71,8],[72,0,73,8],[6,0,6,8],[4,2,4,5],[3,2,3,5],[3,0,3,1],[4,0,4,1],[5,0,5,1],[5,2,5,5],[50,0,50,8],[54,0,54,8],[65,0,65,8]]}
["SITE NAME  "]
["SAP Functional Location "]
["Drawing Ref & Rev. Used"]
["Telemetry System"]
["Date  "]
["Version  "]
[{"$f":"CONCATENATE(\"Downstream Pressure <= \",IF(C9<=0.1,0.1,IF(C9<=1,1,IF(C9<=2,2,IF(C9<=7,7,IF(C9<=100,100,\"Error\"))))),\" barg\")","v":"Downstream Pressure <= 0.1 barg"}]
["Test Certificates for 2 to 7 barg systems",null,"no"]
["Maximum Downstream Operating Pressure (MOPd)",null,null,"barg"]
["Accuracy Class of Monitor Regulator","±",null,null,null,null,"Operational Settings:","(set default as 999)"]
["Accuracy Class of Active Regulator (AC)","±",null,null,null,null,"Slamshut",999,{"$f":"IF(H11>E21,\"exceeds max\",\"\")","v":"exceeds max"}]
["Accuracy Group of Slam Shuts (AG)","±",null,null,null,null,"Monitor Regulator",999,{"$f":"IF(H12>E25,\"exceeds max\",\"\")","v":"exceeds max"}]
[null,null,null,null,null,null,"Active Regulator",999,{"$f":"IF(H13>E29,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) CR & MR",null,0,null,null,null,"Active Regulator SS",999,{"$f":"IF(H14>E30,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) MR & AR",null,0]
["Additional Safety Margin (ASM) AR WS & SS",null,0]
["Additional Safety Margin (ASM) SSV & CR",null,0]
["Volumetric Control?",null,"no","Yes/No"]
["STREAM SELECTION",null,"%MOP",null,"Proposed Settings (barg)"]
[{"$f":"'DataCheck (stream selection)'!A11","v":"TD13 Maximum Incidental Pressure (MIP)"},null,{"$f":"E20/$C$9","v":{"$error":"#DIV/0!"}},null,{"$f":"'DataCheck (stream selection)'!C11","v":0.2}]
[{"$f":"'DataCheck (stream selection)'!A12","v":"Slam Shut Valve (SSV) - Both Streams"},null,{"$f":"E21/$C$9","v":{"$error":"#DIV/0!"}},null,{"$f":"'DataCheck (stream selection)'!C12","v":0.2}]
[{"$f":"'DataCheck (stream selection)'!A13","v":"Creep Relief (CR) - Both Streams"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (stream selection)'!C13","v":0.2}]
[{"$f":"'DataCheck (stream selection)'!A15","v":"TD13 Temporary Operating Pressure (TOP)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (stream selection)'!C15","v":0}]
[{"$f":"'DataCheck (stream selection)'!A16","v":"Calculated TOP"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (stream selection)'!C16","v":0}]
[{"$f":"'DataCheck (stream selection)'!A17","v":"Monitor Regulator (MR) - Both Streams"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (stream selection)'!C17","v":0}]
[{"$f":"'DataCheck (stream selection)'!A18","v":"Lower Accuracy Level MR"},null,{"$f":"E26/$C$9","v":{"$error":"#DIV/0!"}},null,{"$f":"'DataCheck (stream selection)'!C18","v":0}]
[{"$f":"'DataCheck (stream selection)'!A20","v":"TD13 Peak Level Operating Pressure (PLOP)"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (stream selection)'!C20","v":0}]
[{"$f":"'DataCheck (stream selection)'!A21","v":"Calculated PLOP"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (stream selection)'!C21","v":0}]
[{"$f":"'DataCheck (stream selection)'!A22","v":"Active Regulator (AR) - Working Stream"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (stream selection)'!C22","v":0}]
[{"$f":"'DataCheck (stream selection)'!A24","v":"Active Regulator (AR) - Standby Stream"},null,{"$error":"#DIV/0!"},null,{"$f":"'DataCheck (stream selection)'!C24","v":0}]
[]
["Downstream Proposed Settings Graph"]
[]
["MIP (SSV + AG) (WS & SS)",null,{"$f":"E20","v":0.2},{"$f":"C34","v":0.2},{"$f":"D34","v":0.2},0.2,0.2,0.2]
["Slam Shut Valve (WS & SS)",null,{"$f":"E21","v":0.2},0.2,0.2,0.2,0.2,0.2]
["SSV - AG (WS & SS)",null,{"$f":"(1-C12)*C35","v":0.2},{"$f":"C36","v":0.2},0.2,0.2,0.2,0.2]
["Creep Relief (WS & SS) (SSV - AG)",null,{"$f":"E22","v":0.2},0.2,0.2,0.2,0.2,0.2]
["MR + AC (WS & SS)",null,{"$f":"C39*(1+C10)","v":0},0,0,0,0,0]
["Monitor Regulator (WS & SS)",null,{"$f":"E25","v":0},{"$f":"C39","v":0},0,0,0,0]
["MR - AC (WS & SS)",null,{"$f":"C39*(1-C10)","v":0},0,0,0,0,0]
["AR + AC (WS)",null,{"$f":"(1+C11)*C42","v":0},0,0,0,0,0]
["Active Regulator (WS)",null,{"$f":"E29","v":0},{"$f":"C42","v":0},0,0,0,0]
["AR - AC (WS)",null,{"$f":"(1-C11)*C42","v":0},{"$f":"C43","v":0},0,0,0,0]
["AR + AC (SS)",null,{"$f":"(1+C11)*C45","v":0},0,0,0,0,0]
["Active Regulator (SS)",null,{"$f":"E30","v":0},0,0,0,0,0]
["AR - AC (SS)",null,{"$f":"(1-C11)*C45","v":0},0,0,0,0,0]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"Upstream Pressure <= \",IF(C52<=0.1,0.1,IF(C52<=1,1,IF(C52<=2,2,IF(C52<=7,7,IF(C52<=100,100,\"Error\"))))),\" barg\")","v":"Upstream Pressure <= 0.1 barg"}]
["Maximum Upstream Operating Pressure MOPu",null,null,"barg"]
["TD13 Maximum Incidental Pressure (MIP) (SOL)",null,{"$f":"IF(AND(C52>0,C52<='TD13 %ages'!A2),C52*'TD13 %ages'!D2,IF(AND(C52>0.1,C52<='TD13 %ages'!A3),C52*'TD13 %ages'!D3,IF(AND(C52>'TD13 %ages'!A3,C52<='TD13 %ages'!A4),C52*'TD13 %ages'!D4,IF(AND(C52>'TD13 %ages'!A4,C52<='TD13 %ages'!A5),C52*'TD13 %ages'!D5,IF(AND(C52>'TD13 %ages'!A5,C52<='TD13 %ages'!A6),C52*'TD13 %ages'!D6,\"Out of Range\")))))","v":"Out of Range"},"barg"]
[]
["Electrical & Instrumentation"]
["Hardware inlet high telemetered?",null,null,"Yes/No"]
["Inlet Pressure Hardware High ",null,{"$f":"IF(C56=\"Yes\", (IF(C52>69.9999,\"NTS\",IF(AND(C52>0,C52<='TD13 %ages'!A2),C52*'TD13 %ages'!B2,IF(AND(C52>0.1,C52<='TD13 %ages'!A3),C52*'TD13 %ages'!B3,IF(AND(C52>'TD13 %ages'!A3,C52<='TD13 %ages'!A4),C52*'TD13 %ages'!B4,IF(AND(C52>'TD13 %ages'!A4,C52<='TD13 %ages'!A5),C52*'TD13 %ages'!B5,IF(AND(C52>'TD13 %ages'!A5,C52<='TD13 %ages'!A6),C52*'TD13 %ages'!B6,\"Out of Range\"))))))),\"N/A\")","v":"N/A"},"barg","Equal to Peak Level Operating Pressure Upstream"]
["Inlet Pressure Hardware Low",null,null,"barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Inlet Temp Hardware High",null,30,"0C"]
["Inlet Temp Hardware Low",null,-3,"0C"]
["Outlet Pressure Hardware High ",null,{"$f":"E25","v":0},"barg","Equal to Monitor Setting on the working stream"]
["Outlet Pressure Hardware Low",null,{"$f":"E30","v":0},"barg","Equal to active setting on the standby stream"]
["Outlet Pressure Hardware Low Volumetric",null,"N/A","barg","For volumetric order is Hardware, Electronic, pneumatic"]
["Outlet Temp Hardware High",null,30,"0C"]
["Outlet Temp Hardware Low",null,-3,"0C"]
["Volumetric Overrides"]
["Electronic High",null,0,"barg","Based on MOP/active regulator WS setting"]
["Pneumatic High",null,0,"barg","Based on PLOP, rule of thumb is 0.5 bar higher than electronic"]
["Electronic Low",null,0,"barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Pneumatic Low",null,0,"barg","Based on minimum modelled pressure for 1 in 20 conditions"]
[]
["Notes"]
["Standby stream active regulator is set 2 x AC plus an Additional Safety Margin if required delow the active regulator on the working stream.     If no creep relief present, set the ASM detween the SSV and the CR to 0 and ignore the creep relief setting.             "]

{"sheet":"Inputs (Single Stream)","index":6,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":true,"merged":[[67,0,68,8],[6,0,6,8],[29,0,29,8],[45,0,45,8],[49,0,49,8],[60,0,60,8],[65,0,65,8],[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[0,0,0,1],[0,2,0,5],[1,0,1,1],[1,2,1,5],[2,0,2,1],[2,2,2,5]]}
["SITE NAME  "]
["SAP Functional Location "]
["Drawing Ref & Rev. Used"]
["Telemetry System"]
["Date  "]
["Version  "]
[{"$f":"CONCATENATE(\"Downstream Pressure <= \",IF(C9<=0.1,0.1,IF(C9<=1,1,IF(C9<=2,2,IF(C9<=7,7,IF(C9<=100,100,\"Error\"))))),\" barg\")","v":"Downstream Pressure <= 100 barg"}]
["Test Certificates for 2 to 7 barg",null,null,"Yes/No"]
["Maximum Downstream Operating Pressure (MOPd)",null,30,"Barg",null,null,"Operational Settings:","(set default as 999)"]
["Accuracy Class of Monitor Regulator (AC)","±"]
["Accuracy Class of Regulator (AC)","±",null,null,null,null,"Slamshut WS",999,{"$f":"IF(H11>E20,\"exceeds max\",\"\")","v":"exceeds max"}]
["Accuracy Group of Slam Shuts (AG)","±",null,null,null,null,"Monitor Regulator WS",999,{"$f":"IF(H12>E24,\"exceeds max\",\"\")","v":"exceeds max"}]
[null,null,null,null,null,null,"Active Regulator WS",999,{"$f":"IF(H13>E28,\"exceeds max\",\"\")","v":"exceeds max"}]
["Additional Safety Margin (ASM) CR & MR",null,0]
["Additional Safety Margin (ASM) MR & AR (WS)",null,0]
["Additional Safety Margin (ASM) SSV (WS) & CR",null,0]
["Volumetric Control?",null,null,"Yes/No"]
["NO STREAM SELECTION",null,"%MOP",null,"Working Stream (WS) - Proposed Settings  (Barg)"]
[{"$f":"'DataCheck (no stream selection)'!E10","v":"TD13 Maximum Incidental Pressure (MIP)"},null,{"$f":"E19/$C$9","v":1.1000000000000001},null,{"$f":"'DataCheck (Single stream)'!C10","v":33}]
[{"$f":"'DataCheck (no stream selection)'!E11","v":"Slam Shut Valve (SSV)"},null,{"$f":"E20/$C$9","v":1.1000000000000001},null,{"$f":"'DataCheck (Single stream)'!C11","v":33}]
[{"$f":"'DataCheck (no stream selection)'!E12","v":"Creep Relief (CR)"},null,1.1000000000000001,null,{"$f":"'DataCheck (Single stream)'!C12","v":33}]
[{"$f":"'DataCheck (no stream selection)'!E14","v":"TD13 Temporary Operating Pressure (TOP)"},null,1.05,null,{"$f":"'DataCheck (Single stream)'!C14","v":31.5}]
[{"$f":"'DataCheck (no stream selection)'!E15","v":"Calculated TOP"},null,1.05,null,{"$f":"'DataCheck (Single stream)'!C15","v":31.5}]
[{"$f":"'DataCheck (no stream selection)'!E16","v":"Monitor Regulator (MR)"},null,1.05,null,{"$f":"'DataCheck (Single stream)'!C16","v":31.5}]
[{"$f":"'DataCheck (no stream selection)'!E17","v":"Lower Accuracy Level MR"},null,1.05,null,{"$f":"'DataCheck (Single stream)'!C17","v":31.5}]
[{"$f":"'DataCheck (no stream selection)'!E19","v":"TD13 Peak Level Operating Pressure (PLOP)"},null,1.0249999999999999,null,{"$f":"'DataCheck (Single stream)'!C19","v":30.749999999999996}]
[{"$f":"'DataCheck (no stream selection)'!E20","v":"Calculated PLOP"},null,1.0249999999999999,null,{"$f":"'DataCheck (Single stream)'!C20","v":30.749999999999996}]
[{"$f":"'DataCheck (no stream selection)'!E21","v":"Active Regulator (AR)"},null,1,null,{"$f":"'DataCheck (Single stream)'!C21","v":30}]
[]
["Proposed Settings Graph"]
[]
["MIP (SSV + AG) WS",null,{"$f":"(1+C12)*C33","v":33},{"$f":"C32","v":33},33,33,33,33]
["Slam Shut Valve (WS)",null,{"$f":"E20","v":33},33,33,33,33,33]
["SSV - AG (WS)",null,{"$f":"(1-C12)*C33","v":33},33,33,33,33,33]
["Creep Relief (WS) ",null,{"$f":"E21","v":33},33,33,33,33,33]
["MR + AC (WS)",null,{"$f":"C37*(1+C10)","v":31.5},31.5,31.5,31.5,31.5,31.5]
["Monitor Regulator (WS)",null,{"$f":"E24","v":31.5},31.5,31.5,31.5,31.5,31.5]
["MR - AC (WS)",null,{"$f":"C37*(1-C10)","v":31.5},31.5,31.5,31.5,31.5,31.5]
["AR + AC (WS)",null,{"$f":"(1+C11)*C40","v":30},30,30,30,30,30]
["Active Regulator (WS)",null,{"$f":"E28","v":30},{"$f":"C40","v":30},30,30,30,30]
["AR - AC (WS)",null,{"$f":"(1-C11)*C40","v":30},{"$f":"C41","v":30},30,30,30,30]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"Upstream Pressure <= \",IF(C47<=0.1,0.1,IF(C47<=1,1,IF(C47<=2,2,IF(C47<=7,7,IF(C47<=100,100,\"Error\"))))),\" barg\")","v":"Upstream Pressure <= 0.1 barg"}]
["Maximum Upstream Operating Pressure MOPu",null,null,"barg"]
["TD13 Maximum Incidental Pressure (MIP) (SOL)",null,{"$f":"IF(AND(C47>0,C47<='TD13 %ages'!A2),C47*'TD13 %ages'!D2,IF(AND(C47>0.1,C47<='TD13 %ages'!A3),C47*'TD13 %ages'!D3,IF(AND(C47>'TD13 %ages'!A3,C47<='TD13 %ages'!A4),C47*'TD13 %ages'!D4,IF(AND(C47>'TD13 %ages'!A4,C47<='TD13 %ages'!A5),C47*'TD13 %ages'!D5,IF(AND(C47>'TD13 %ages'!A5,C47<='TD13 %ages'!A6),C47*'TD13 %ages'!D6,\"Out of Range\")))))","v":"Out of Range"},"barg"]
[]
["Electrical & Instrumentation"]
["Hardware inlet high telemetered?",null,null,"Yes/No"]
["Inlet Pressure Hardware High ",null,{"$f":"IF(C51=\"Yes\", (IF(C47>69.9999,\"NTS\",IF(AND(C47>0,C47<='TD13 %ages'!A2),C47*'TD13 %ages'!B2,IF(AND(C47>0.1,C47<='TD13 %ages'!A3),C47*'TD13 %ages'!B3,IF(AND(C47>'TD13 %ages'!A3,C47<='TD13 %ages'!A4),C47*'TD13 %ages'!B4,IF(AND(C47>'TD13 %ages'!A4,C47<='TD13 %ages'!A5),C47*'TD13 %ages'!B5,IF(AND(C47>'TD13 %ages'!A5,C47<='TD13 %ages'!A6),C47*'TD13 %ages'!B6,\"Out of Range\"))))))),\"N/A\")","v":"N/A"},"barg","Equal to Peak Level Operating Pressure Upstream or N/A"]
["Inlet Pressure Hardware Low",null,null,"barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Inlet Temp Hardware High",null,30,"0C"]
["Inlet Temp Hardware Low",null,-3,"0C"]
["Outlet Pressure Hardware High ",null,{"$f":"E24","v":31.5},"barg","Equal to Monitor Setting on the working stream"]
["Outlet Pressure Hardware Low",null,{"$f":"H28","v":0},"barg","Equal to active setting on the standby stream"]
["Outlet Pressure Hardware Low Volumetric",null,0,"barg","For volumetric order is Hardware, Electronic, pneumatic"]
["Outlet Temp Hardware High",null,30,"0C"]
["Outlet Temp Hardware Low",null,-3,"0C"]
["Volumetric Overrides"]
["Electronic High",null,"N/A","barg","Based on MOP/active regulator WS setting"]
["Pneumatic High",null,"N/A","barg","Based on MOP or PLOP, rule of thumb is 0.5 bar higher than electronic"]
["Electronic Low",null,"N/A","barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Pneumatic Low",null,"N/A","barg","Based on minimum modelled pressure for 1 in 20 conditions"]
["Notes"]
[]
["Standby stream active regulator is set 2 x AC plus an Additional Safety Margin if required below the active regulator on the working stream.   If no creep relief setting present, set the ASM between the SSV and CR to 0 and ignore creep relief setting.            "]

{"sheet":"SingleStream - Pressure Control","index":7,"n_rows":39,"n_cols":28,"rows_kept":39,"cut":false,"hidden":true,"merged":[[25,23,26,29],[14,0,14,6],[17,16,17,19],[17,23,17,26],[18,16,18,21],[18,23,18,29],[19,16,26,21],[19,23,20,29],[22,24,22,25],[22,28,22,29],[23,24,23,25],[23,28,23,29],[25,0,25,6],[25,8,25,14],[24,24,24,25],[24,28,24,29],[7,23,7,24],[7,25,7,27],[9,16,9,22],[9,23,9,29],[10,17,10,18],[10,19,10,20],[10,24,10,25],[10,26,10,27],[7,18,7,20],[7,0,7,1],[7,2,7,5],[7,8,7,9],[7,10,7,13],[7,16,7,17],[5,23,5,24],[5,25,5,27],[6,0,6,1],[6,2,6,5],[6,8,6,9],[6,10,6,13],[6,16,6,17],[6,18,6,20],[6,23,6,24],[6,25,6,27],[5,0,5,1],[5,2,5,5],[5,8,5,9],[5,10,5,13],[5,16,5,17],[5,18,5,20],[3,23,3,24],[3,25,3,27],[4,0,4,1],[4,2,4,5],[4,8,4,9],[4,10,4,13],[4,16,4,17],[4,18,4,20],[4,23,4,24],[4,25,4,27],[3,0,3,1],[3,2,3,5],[3,8,3,9],[3,10,3,13],[3,16,3,17],[3,18,3,20],[1,23,1,24],[1,25,1,27],[2,0,2,1],[2,2,2,5],[2,8,2,9],[2,10,2,13],[2,16,2,17],[2,18,2,20],[2,23,2,24],[2,25,2,27],[1,0,1,1],[1,2,1,5],[1,8,1,9],[1,10,1,13],[1,16,1,17],[1,18,1,20]]}
[]
["SITE NAME  ",null,{"$f":"'Inputs (Single Stream)'!C1:F1","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"C2","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"K2","v":0},null,null,null,null,"SITE NAME  ",null,{"$f":"S2","v":0}]
["SAP Functional Location ",null,{"$f":"'Inputs (Single Stream)'!C2:F2","v":0},null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,"SAP Functional Location ",null,0]
["Drawing Ref & Rev. Used ",null,{"$f":"'Inputs (Single Stream)'!C3:F3","v":0},null,null,null,null,null,{"$f":"A4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,null,{"$f":"I4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,{"$f":"Q4","v":"Drawing Ref & Rev. Used "},null,0]
["Telemetry System",null,{"$f":"'Inputs (Single Stream)'!C4:F4","v":0},null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,"Telemetry System",null,0]
["Date  ",null,{"$f":"'Inputs (Single Stream)'!C5:F5","v":"00:00:00"},null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,"Date  ",null,"00:00:00"]
["Version  ",null,{"$f":"'Inputs (Single Stream)'!C6:F6","v":0},null,null,null,null,null,"Version  ",null,0,null,null,null,null,null,"Version  ",null,0,null,null,null,null,"Version  ",null,0]
["Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"2 of 2",null,null,null,null,"Page Number",null,"2 of 2"]
[]
["UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS",null,null,null,null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS"]
[]
["MOP (Barg)",{"$f":"'Inputs (Single Stream)'!C47","v":0},null,null,"MOP (Barg)",{"$f":"'Inputs (Single Stream)'!C9","v":30},null,null,"MOP (Barg)",{"$f":"B12","v":0},null,null,"MOP (Barg)",{"$f":"F12","v":30},null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE",null,null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE"]
["MIP/SOL (Barg)",{"$f":"'Inputs (Single Stream)'!C48","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"'Inputs (Single Stream)'!E19","v":33},null,null,"MIP/SOL (Barg)",{"$f":"B13","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"F13","v":33},null,null,null,"Setting",null,null,"Setting",null,null,null,"Setting",null,null,"Setting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure High (Barg)",{"$f":"'Inputs (Single Stream)'!C52","v":"N/A"},null,"Pressure High (Barg)",{"$f":"'Inputs (Single Stream)'!C56","v":31.5},null,null,"Pressure High (Barg)",{"$f":"R14","v":"N/A"},null,"Pressure High (Barg)",{"$f":"U14","v":31.5}]
["PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,"PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,"Pressure Low (Barg)",{"$f":"'Inputs (Single Stream)'!C53","v":0},null,"Pressure Low (Barg)",{"$f":"'Inputs (Single Stream)'!C57","v":0},null,null,"Pressure Low (Barg)",{"$f":"R15","v":0},null,"Pressure Low (Barg)",{"$f":"U15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature High (°C)",{"$f":"'Inputs (Single Stream)'!C54","v":30},null,"Temperature High (°C)",{"$f":"'Inputs (Single Stream)'!C59","v":30},null,null,"Temperature High (°C)",{"$f":"R16","v":30},null,"Temperature High (°C)",{"$f":"U16","v":30}]
["WORKING STREAM",null,null,null,null,null,null,null,"WORKING STREAM",null,null,null,null,null,null,null,"Temperature Low (°C)",{"$f":"'Inputs (Single Stream)'!C55","v":-3},null,"Temperature Low (°C)",{"$f":"'Inputs (Single Stream)'!C60","v":-3},null,null,"Temperature Low (°C)",{"$f":"R17","v":-3},null,"Temperature Low (°C)",-3]
["Equipment","Setting (Barg)",null,null,null,null,null,null,"Equipment","Setting (Barg)"]
["Slam Shut",{"$f":"'Inputs (Single Stream)'!E20","v":33},null,null,null,null,null,null,{"$f":"IF(A19=\"\",\"\",A19)","v":"Slam Shut"},{"$f":"IF(B19=\"\",\"\",B19)","v":33},null,null,null,null,null,null,null,null,null,null,null,null,null,"SITE UPDATE CONTROL"]
["1st Stage Cut","N/A",null,null,null,null,null,null,{"$f":"IF(A20=\"\",\"\",A20)","v":"1st Stage Cut"},"N/A",null,null,null,null,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)",null,null,null,null,null,null,"Please complete when all settings have been updated, visibly display site copy and send office copy back to site settings email AssetIntegritySiteSettings@wwutilities.co.uk "]
["Creep Relief",{"$f":"'Inputs (Single Stream)'!E21","v":33},null,null,null,null,null,null,"Creep Relief",33]
["Monitor",{"$f":"'Inputs (Single Stream)'!E24","v":31.5},null,null,null,null,null,null,"Monitor",31.5]
["Active",{"$f":"'Inputs (Single Stream)'!E28","v":30},null,null,null,null,null,null,"Active",30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Print Name",null,"Sign Name","Date"]
[null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mechanical Operative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E & I Operative"]
["ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,"ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)"]
[]
["WORKING STREAM",null,null,null,null,null,null,null,"WORKING STREAM"]
["Equipment","Setting (Barg)",null,null,null,null,null,null,"Equipment","Setting (Barg)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A30=\"\",\"\",A30)","v":""},{"$f":"IF(B30=\"\",\"\",B30)","v":""}]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]

{"sheet":"S-S - Pressure Control Tandem","index":8,"n_rows":38,"n_cols":28,"rows_kept":38,"cut":false,"hidden":true,"merged":[[25,23,26,29],[19,16,26,21],[19,23,20,29],[22,24,22,25],[22,28,22,29],[24,0,24,6],[24,8,24,14],[23,24,23,25],[23,28,23,29],[24,24,24,25],[24,28,24,29],[14,0,14,6],[17,16,17,19],[17,23,17,26],[18,16,18,21],[18,23,18,29],[14,8,14,15],[7,23,7,24],[7,25,7,27],[9,16,9,22],[9,23,9,29],[10,17,10,18],[10,19,10,20],[10,24,10,25],[10,26,10,27],[7,18,7,20],[7,0,7,1],[7,2,7,5],[7,8,7,9],[7,10,7,13],[7,16,7,17],[5,23,5,24],[5,25,5,27],[6,0,6,1],[6,2,6,5],[6,8,6,9],[6,10,6,13],[6,16,6,17],[6,18,6,20],[6,23,6,24],[6,25,6,27],[5,0,5,1],[5,2,5,5],[5,8,5,9],[5,10,5,13],[5,16,5,17],[5,18,5,20],[3,23,3,24],[3,25,3,27],[4,0,4,1],[4,2,4,5],[4,8,4,9],[4,10,4,13],[4,16,4,17],[4,18,4,20],[4,23,4,24],[4,25,4,27],[3,0,3,1],[3,2,3,5],[3,8,3,9],[3,10,3,13],[3,16,3,17],[3,18,3,20],[1,23,1,24],[1,25,1,27],[2,0,2,1],[2,2,2,5],[2,8,2,9],[2,10,2,13],[2,16,2,17],[2,18,2,20],[2,23,2,24],[2,25,2,27],[1,0,1,1],[1,2,1,5],[1,8,1,9],[1,10,1,13],[1,16,1,17],[1,18,1,20]]}
[]
["SITE NAME  ",null,{"$f":"'Inputs Tandem(Stream Selection)'!C1:F1","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"C2","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"K2","v":0},null,null,null,null,"SITE NAME  ",null,{"$f":"S2","v":0}]
["SAP Functional Location ",null,{"$f":"'Inputs Tandem(Stream Selection)'!C2:F2","v":0},null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,"SAP Functional Location ",null,0]
["Drawing Ref & Rev. Used ",null,{"$f":"'Inputs Tandem(Stream Selection)'!C3:F3","v":0},null,null,null,null,null,{"$f":"A4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,null,{"$f":"I4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,{"$f":"Q4","v":"Drawing Ref & Rev. Used "},null,0]
["Telemetry System",null,{"$f":"'Inputs Tandem(Stream Selection)'!C4:F4","v":0},null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,"Telemetry System",null,0]
["Date  ",null,{"$f":"'Inputs Tandem(Stream Selection)'!C5:F5","v":"00:00:00"},null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,"Date  ",null,"00:00:00"]
["Version  ",null,{"$f":"'Inputs Tandem(Stream Selection)'!C6:F6","v":0},null,null,null,null,null,"Version  ",null,0,null,null,null,null,null,"Version  ",null,0,null,null,null,null,"Version  ",null,0]
["Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"2 of 2",null,null,null,null,"Page Number",null,"2 of 2"]
[]
["UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS",null,null,null,null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS"]
[]
["MOP (Barg)",{"$f":"'Inputs Tandem(Stream Selection)'!C46","v":0},null,null,"MOP (Barg)",{"$f":"'Inputs Tandem(Stream Selection)'!C9","v":0},null,null,"MOP (Barg)",{"$f":"B12","v":0},null,null,"MOP (Barg)",{"$f":"F12","v":0},null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE",null,null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE"]
["MIP/SOL (Barg)",{"$f":"'Inputs Tandem(Stream Selection)'!C47","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"'Inputs Tandem(Stream Selection)'!E18","v":0.2},null,null,"MIP/SOL (Barg)",{"$f":"B13","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"F13","v":0.2},null,null,null,"Setting",null,null,"Setting",null,null,null,"Setting",null,null,"Setting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure High (Barg)",{"$f":"'Inputs Tandem(Stream Selection)'!C51","v":"N/A"},null,"Pressure High (Barg)",{"$f":"'Inputs Tandem(Stream Selection)'!C55","v":0.1},null,null,"Pressure High (Barg)",{"$f":"R14","v":"N/A"},null,"Pressure High (Barg)",{"$f":"U14","v":0.1}]
["PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,"PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,"Pressure Low (Barg)",{"$f":"'Inputs Tandem(Stream Selection)'!C52","v":0},null,"Pressure Low (Barg)",{"$f":"'Inputs Tandem(Stream Selection)'!C56","v":0},null,null,"Pressure Low (Barg)",{"$f":"R15","v":0},null,"Pressure Low (Barg)",{"$f":"U15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature High (°C)",{"$f":"'Inputs Tandem(Stream Selection)'!C53","v":30},null,"Temperature High (°C)",{"$f":"'Inputs Tandem(Stream Selection)'!C58","v":30},null,null,"Temperature High (°C)",{"$f":"R16","v":30},null,"Temperature High (°C)",{"$f":"U16","v":30}]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"Temperature Low (°C)",{"$f":"'Inputs Tandem(Stream Selection)'!C54","v":-3},null,"Temperature Low (°C)",{"$f":"'Inputs Tandem(Stream Selection)'!C59","v":-3},null,null,"Temperature Low (°C)",{"$f":"R17","v":-3},null,"Temperature Low (°C)",-3]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
["Slam Shut",{"$f":"'Inputs Tandem(Stream Selection)'!E19","v":0.2},null,null,"Slam Shut",{"$f":"'Inputs Tandem(Stream Selection)'!E19","v":0.2},null,null,{"$f":"IF(A19=\"\",\"\",A19)","v":"Slam Shut"},{"$f":"IF(B19=\"\",\"\",B19)","v":0.2},null,null,{"$f":"IF(E19=\"\",\"\",E19)","v":"Slam Shut"},{"$f":"IF(F19=\"\",\"\",F19)","v":0.2},null,null,null,null,null,null,null,null,null,"SITE UPDATE CONTROL"]
["1st Stage Cut",null,null,null,"1st Stage Cut",{"$f":"IF(B20=\"\",\"\",B20)","v":""},null,null,{"$f":"IF(A20=\"\",\"\",A20)","v":"1st Stage Cut"},{"$f":"IF(B20=\"\",\"\",B20)","v":""},null,null,{"$f":"IF(E20=\"\",\"\",E20)","v":"1st Stage Cut"},{"$f":"IF(F20=\"\",\"\",F20)","v":""},null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)",null,null,null,null,null,null,"Please complete when all settings have been updated, visibly display site copy and send office copy back to site settings email AssetIntegritySiteSettings@wwutilities.co.uk "]
["Creep Relief",{"$f":"'Inputs Tandem(Stream Selection)'!E20","v":0.2},null,null,"Creep Relief",{"$f":"'Inputs Tandem(Stream Selection)'!E20","v":0.2},null,null,"Creep Relief",0.2,null,null,"Creep Relief",0.2]
["Active",{"$f":"'Inputs Tandem(Stream Selection)'!E23","v":0},null,null,"Active",{"$f":"'Inputs Tandem(Stream Selection)'!E24","v":0},null,null,"Active",0,null,null,"Active",0]
[null,null,null,null,null,null,null,null,"","",null,null,"","",null,null,null,null,null,null,null,null,null,null,"Print Name",null,"Sign Name","Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mechanical Operative"]
["ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,"ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E & I Operative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)"]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM"]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A29=\"\",\"\",A29)","v":""},{"$f":"IF(B29=\"\",\"\",B29)","v":""},null,null,{"$f":"IF(E29=\"\",\"\",E29)","v":""},{"$f":"IF(F29=\"\",\"\",F29)","v":""}]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]

{"sheet":"No S-S -Pressure Control Tandem","index":9,"n_rows":38,"n_cols":28,"rows_kept":38,"cut":false,"hidden":true,"merged":[[25,23,26,29],[14,0,14,6],[17,16,17,19],[17,23,17,26],[18,16,18,21],[18,23,18,29],[19,16,26,21],[19,23,20,29],[22,24,22,25],[22,28,22,29],[24,0,24,6],[24,8,24,14],[23,24,23,25],[23,28,23,29],[24,24,24,25],[24,28,24,29],[7,23,7,24],[7,25,7,27],[9,16,9,22],[9,23,9,29],[10,17,10,18],[10,19,10,20],[10,24,10,25],[10,26,10,27],[7,18,7,20],[7,0,7,1],[7,2,7,5],[7,8,7,9],[7,10,7,13],[7,16,7,17],[5,23,5,24],[5,25,5,27],[6,0,6,1],[6,2,6,5],[6,8,6,9],[6,10,6,13],[6,16,6,17],[6,18,6,20],[6,23,6,24],[6,25,6,27],[5,0,5,1],[5,2,5,5],[5,8,5,9],[5,10,5,13],[5,16,5,17],[5,18,5,20],[3,23,3,24],[3,25,3,27],[4,0,4,1],[4,2,4,5],[4,8,4,9],[4,10,4,13],[4,16,4,17],[4,18,4,20],[4,23,4,24],[4,25,4,27],[3,0,3,1],[3,2,3,5],[3,8,3,9],[3,10,3,13],[3,16,3,17],[3,18,3,20],[1,23,1,24],[1,25,1,27],[2,0,2,1],[2,2,2,5],[2,8,2,9],[2,10,2,13],[2,16,2,17],[2,18,2,20],[2,23,2,24],[2,25,2,27],[1,0,1,1],[1,2,1,5],[1,8,1,9],[1,10,1,13],[1,16,1,17],[1,18,1,20]]}
[]
["SITE NAME  ",null,{"$f":"'Inputs Tandem(No Stream Sel)'!C1:F1","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"C2","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"K2","v":0},null,null,null,null,"SITE NAME  ",null,{"$f":"S2","v":0}]
["SAP Functional Location ",null,{"$f":"'Inputs Tandem(No Stream Sel)'!C2:F2","v":0},null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,"SAP Functional Location ",null,0]
["Drawing Ref & Rev. Used ",null,{"$f":"'Inputs Tandem(No Stream Sel)'!C3:F3","v":0},null,null,null,null,null,{"$f":"A4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,null,{"$f":"I4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,{"$f":"Q4","v":"Drawing Ref & Rev. Used "},null,0]
["Telemetry System",null,{"$f":"'Inputs Tandem(No Stream Sel)'!C4:F4","v":0},null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,"Telemetry System",null,0]
["Date  ",null,{"$f":"'Inputs Tandem(No Stream Sel)'!C5:F5","v":"00:00:00"},null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,"Date  ",null,"00:00:00"]
["Version  ",null,{"$f":"'Inputs Tandem(No Stream Sel)'!C6:F6","v":0},null,null,null,null,null,"Version  ",null,0,null,null,null,null,null,"Version  ",null,0,null,null,null,null,"Version  ",null,0]
["Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"2 of 2",null,null,null,null,"Page Number",null,"2 of 2"]
[]
["UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS",null,null,null,null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS"]
[]
["MOP (Barg)",{"$f":"'Inputs Tandem(No Stream Sel)'!C46","v":0},null,null,"MOP (Barg)",{"$f":"'Inputs Tandem(No Stream Sel)'!C9","v":0},null,null,"MOP (Barg)",{"$f":"B12","v":0},null,null,"MOP (Barg)",{"$f":"F12","v":0},null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE",null,null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE"]
["MIP/SOL (Barg)",{"$f":"'Inputs Tandem(No Stream Sel)'!C47","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"'Inputs Tandem(No Stream Sel)'!E19","v":0.2},null,null,"MIP/SOL (Barg)",{"$f":"B13","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"F13","v":0.2},null,null,null,"Setting",null,null,"Setting",null,null,null,"Setting",null,null,"Setting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure High (Barg)",{"$f":"'Inputs Tandem(No Stream Sel)'!C51","v":"N/A"},null,"Pressure High (Barg)",{"$f":"'Inputs Tandem(No Stream Sel)'!C55","v":0.1},null,null,"Pressure High (Barg)",{"$f":"R14","v":"N/A"},null,"Pressure High (Barg)",{"$f":"U14","v":0.1}]
["PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,"PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,"Pressure Low (Barg)",{"$f":"'Inputs Tandem(No Stream Sel)'!C52","v":0},null,"Pressure Low (Barg)",{"$f":"'Inputs Tandem(No Stream Sel)'!C56","v":0},null,null,"Pressure Low (Barg)",{"$f":"R15","v":0},null,"Pressure Low (Barg)",{"$f":"U15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature High (°C)",{"$f":"'Inputs Tandem(No Stream Sel)'!C53","v":30},null,"Temperature High (°C)",{"$f":"'Inputs Tandem(No Stream Sel)'!C58","v":30},null,null,"Temperature High (°C)",{"$f":"R16","v":30},null,"Temperature High (°C)",{"$f":"U16","v":30}]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"Temperature Low (°C)",{"$f":"'Inputs Tandem(No Stream Sel)'!C54","v":-3},null,"Temperature Low (°C)",{"$f":"'Inputs Tandem(No Stream Sel)'!C59","v":-3},null,null,"Temperature Low (°C)",{"$f":"R17","v":-3},null,"Temperature Low (°C)",-3]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
["Slam Shut",{"$f":"'Inputs Tandem(No Stream Sel)'!E20","v":0.2},null,null,"Slam Shut",{"$f":"'Inputs Tandem(No Stream Sel)'!H20","v":0.2},null,null,{"$f":"IF(A19=\"\",\"\",A19)","v":"Slam Shut"},{"$f":"IF(B19=\"\",\"\",B19)","v":0.2},null,null,{"$f":"IF(E19=\"\",\"\",E19)","v":"Slam Shut"},{"$f":"IF(F19=\"\",\"\",F19)","v":0.2},null,null,null,null,null,null,null,null,null,"SITE UPDATE CONTROL"]
["1st Stage Cut","N/A",null,null,"1st Stage Cut",{"$f":"B20","v":"N/A"},null,null,{"$f":"IF(A20=\"\",\"\",A20)","v":"1st Stage Cut"},{"$f":"IF(B20=\"\",\"\",B20)","v":"N/A"},null,null,{"$f":"IF(E20=\"\",\"\",E20)","v":"1st Stage Cut"},{"$f":"IF(F20=\"\",\"\",F20)","v":"N/A"},null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)",null,null,null,null,null,null,"Please complete when all settings have been updated, visibly display site copy and send office copy back to site settings email AssetIntegritySiteSettings@wwutilities.co.uk "]
["Creep Relief",{"$f":"'Inputs Tandem(No Stream Sel)'!E21","v":0.2},null,null,"Creep Relief",{"$f":"'Inputs Tandem(No Stream Sel)'!H21","v":0.2},null,null,"Creep Relief",0.2,null,null,"Creep Relief",0.2]
["Active",{"$f":"'Inputs Tandem(No Stream Sel)'!E24","v":0},null,null,"Active",{"$f":"'Inputs Tandem(No Stream Sel)'!H24","v":0},null,null,"Active",0,null,null,"Active",0]
[null,null,null,null,null,null,null,null,"","",null,null,"","",null,null,null,null,null,null,null,null,null,null,"Print Name",null,"Sign Name","Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mechanical Operative"]
["ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,"ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E & I Operative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)"]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM"]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A29=\"\",\"\",A29)","v":""},{"$f":"IF(B29=\"\",\"\",B29)","v":""},null,null,{"$f":"IF(E29=\"\",\"\",E29)","v":""},{"$f":"IF(F29=\"\",\"\",F29)","v":""}]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]

{"sheet":"No S-S - Pressure Control","index":10,"n_rows":39,"n_cols":28,"rows_kept":39,"cut":false,"hidden":true,"merged":[[25,0,25,6],[25,8,25,14],[24,28,24,29],[2,8,2,9],[3,8,3,9],[14,0,14,6],[17,16,17,19],[17,23,17,26],[18,16,18,21],[18,23,18,29],[7,23,7,24],[7,25,7,27],[9,16,9,22],[9,23,9,29],[10,17,10,18],[10,19,10,20],[25,23,26,29],[19,16,26,21],[19,23,20,29],[22,28,22,29],[23,28,23,29],[22,24,22,25],[23,24,23,25],[24,24,24,25],[10,24,10,25],[10,26,10,27],[7,18,7,20],[7,0,7,1],[7,2,7,5],[7,8,7,9],[7,10,7,13],[7,16,7,17],[5,23,5,24],[5,25,5,27],[6,0,6,1],[6,2,6,5],[6,8,6,9],[6,10,6,13],[6,16,6,17],[6,18,6,20],[6,23,6,24],[6,25,6,27],[5,0,5,1],[5,2,5,5],[5,8,5,9],[5,10,5,13],[5,16,5,17],[5,18,5,20],[3,25,3,27],[4,0,4,1],[4,2,4,5],[4,8,4,9],[4,10,4,13],[4,16,4,17],[4,18,4,20],[4,23,4,24],[4,25,4,27],[3,0,3,1],[3,2,3,5],[3,10,3,13],[3,16,3,17],[3,18,3,20],[3,23,3,24],[1,23,1,24],[1,25,1,27],[2,0,2,1],[2,2,2,5],[2,10,2,13],[2,16,2,17],[2,18,2,20],[2,23,2,24],[2,25,2,27],[1,0,1,1],[1,2,1,5],[1,8,1,9],[1,10,1,13],[1,16,1,17],[1,18,1,20]]}
[]
["SITE NAME  ",null,{"$f":"'Inputs (No Stream Selection)'!C1:F1","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"C2","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"K2","v":0},null,null,null,null,"SITE NAME  ",null,{"$f":"S2","v":0}]
["SAP Functional Location ",null,{"$f":"'Inputs (No Stream Selection)'!C2:F2","v":0},null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,"SAP Functional Location ",null,0]
["Drawing Ref & Rev. Used ",null,{"$f":"'Inputs (No Stream Selection)'!C3:F3","v":0},null,null,null,null,null,{"$f":"A4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,null,{"$f":"I4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,{"$f":"Q4","v":"Drawing Ref & Rev. Used "},null,0]
["Telemetry System",null,{"$f":"'Inputs (No Stream Selection)'!C4:F4","v":0},null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,"Telemetry System",null,0]
["Date  ",null,{"$f":"'Inputs (No Stream Selection)'!C5:F5","v":"00:00:00"},null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,"Date  ",null,"00:00:00"]
["Version  ",null,{"$f":"'Inputs (No Stream Selection)'!C6:F6","v":0},null,null,null,null,null,"Version  ",null,0,null,null,null,null,null,"Version  ",null,0,null,null,null,null,"Version  ",null,0]
["Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"2 of 2",null,null,null,null,"Page Number",null,"2 of 2"]
[]
["UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS",null,null,null,null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS"]
[]
["MOP (Barg)",{"$f":"'Inputs (No Stream Selection)'!C52","v":0},null,null,"MOP (Barg)",{"$f":"'Inputs (No Stream Selection)'!C9","v":0},null,null,"MOP (Barg)",{"$f":"B12","v":0},null,null,"MOP (Barg)",{"$f":"F12","v":0},null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE",null,null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE"]
["MIP/SOL (Barg)",{"$f":"'Inputs (No Stream Selection)'!C53","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"'Inputs (No Stream Selection)'!E21","v":0.2},null,null,"MIP/SOL (Barg)",{"$f":"B13","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"F13","v":0.2},null,null,null,"Setting",null,null,"Setting",null,null,null,"Setting",null,null,"Setting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure High (Barg)",{"$f":"'Inputs (No Stream Selection)'!C57","v":"N/A"},null,"Pressure High (Barg)",{"$f":"'Inputs (No Stream Selection)'!C61","v":0},null,null,"Pressure High (Barg)",{"$f":"R14","v":"N/A"},null,"Pressure High (Barg)",{"$f":"U14","v":0}]
["PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,"PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,"Pressure Low (Barg)",{"$f":"'Inputs (No Stream Selection)'!C58","v":0},null,"Pressure Low (Barg)",{"$f":"'Inputs (No Stream Selection)'!C62","v":0},null,null,"Pressure Low (Barg)",{"$f":"R15","v":0},null,"Pressure Low (Barg)",{"$f":"U15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature High (°C)",{"$f":"'Inputs (No Stream Selection)'!C59","v":30},null,"Temperature High (°C)",{"$f":"'Inputs (No Stream Selection)'!C64","v":30},null,null,"Temperature High (°C)",{"$f":"R16","v":30},null,"Temperature High (°C)",{"$f":"U16","v":30}]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"Temperature Low (°C)",{"$f":"'Inputs (No Stream Selection)'!C60","v":-3},null,"Temperature Low (°C)",{"$f":"'Inputs (No Stream Selection)'!C65","v":-3},null,null,"Temperature Low (°C)",{"$f":"R17","v":-3},null,"Temperature Low (°C)",-3]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
["Slam Shut",{"$f":"'Inputs (No Stream Selection)'!E22","v":0.2},null,null,"Slam Shut",{"$f":"'Inputs (No Stream Selection)'!H22","v":0.2},null,null,{"$f":"IF(A19=\"\",\"\",A19)","v":"Slam Shut"},{"$f":"IF(B19=\"\",\"\",B19)","v":0.2},null,null,{"$f":"IF(E19=\"\",\"\",E19)","v":"Slam Shut"},{"$f":"IF(F19=\"\",\"\",F19)","v":0.2},null,null,null,null,null,null,null,null,null,"SITE UPDATE CONTROL"]
["1st Stage Cut","N/A",null,null,"1st Stage Cut",{"$f":"B20","v":"N/A"},null,null,{"$f":"IF(A20=\"\",\"\",A20)","v":"1st Stage Cut"},"N/A",null,null,{"$f":"IF(E20=\"\",\"\",E20)","v":"1st Stage Cut"},"N/A",null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)",null,null,null,null,null,null,"Please complete when all settings have been updated, visibly display site copy and send office copy back to site settings email AssetSiteSettings@wwutilities.co.uk "]
["Creep Relief",{"$f":"'Inputs (No Stream Selection)'!E23","v":0.2},null,null,"Creep Relief",{"$f":"'Inputs (No Stream Selection)'!H23","v":0.2},null,null,"Creep Relief",0.2,null,null,"Creep Relief",0.2]
["Monitor",{"$f":"'Inputs (No Stream Selection)'!E26","v":0},null,null,"Monitor",{"$f":"'Inputs (No Stream Selection)'!H26","v":0},null,null,"Monitor",0,null,null,"Monitor",0]
["Active",{"$f":"'Inputs (No Stream Selection)'!E30","v":0},null,null,"Active",{"$f":"'Inputs (No Stream Selection)'!H30","v":0},null,null,"Active",0,null,null,"Active",0,null,null,null,null,null,null,null,null,null,null,"Print Name",null,"Sign Name","Date"]
[null,null,null,null,null,null,null,null,"","",null,null,"","",null,null,null,null,null,null,null,null,null,"Mechanical Operative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E & I Operative"]
["ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,"ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)"]
[]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM"]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A30=\"\",\"\",A30)","v":""},{"$f":"IF(B30=\"\",\"\",B30)","v":""},null,null,{"$f":"IF(E30=\"\",\"\",E30)","v":""},{"$f":"IF(F30=\"\",\"\",F30)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A31=\"\",\"\",A31)","v":""},"",null,null,{"$f":"IF(E31=\"\",\"\",E31)","v":""},""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]

{"sheet":"S-S - Pressure Control","index":11,"n_rows":39,"n_cols":28,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,23,1,24],[1,25,1,27],[2,0,2,1],[2,2,2,5],[2,10,2,13],[2,16,2,17],[2,18,2,20],[2,23,2,24],[2,25,2,27],[1,0,1,1],[1,2,1,5],[1,8,1,9],[1,10,1,13],[1,16,1,17],[1,18,1,20],[2,8,2,9],[3,25,3,27],[4,0,4,1],[4,2,4,5],[4,8,4,9],[4,10,4,13],[4,16,4,17],[4,18,4,20],[4,23,4,24],[4,25,4,27],[3,0,3,1],[3,2,3,5],[3,10,3,13],[3,16,3,17],[3,18,3,20],[3,23,3,24],[3,8,3,9],[5,23,5,24],[5,25,5,27],[6,0,6,1],[6,2,6,5],[6,8,6,9],[6,10,6,13],[6,16,6,17],[6,18,6,20],[6,23,6,24],[6,25,6,27],[5,0,5,1],[5,2,5,5],[5,8,5,9],[5,10,5,13],[5,16,5,17],[5,18,5,20],[7,0,7,1],[7,2,7,5],[7,8,7,9],[7,10,7,13],[7,16,7,17],[7,23,7,24],[7,25,7,27],[9,16,9,22],[9,23,9,29],[10,17,10,18],[10,19,10,20],[10,24,10,25],[10,26,10,27],[7,18,7,20],[14,0,14,6],[14,9,14,15],[17,16,17,19],[17,23,17,26],[18,16,18,21],[18,23,18,29],[25,0,25,6],[25,8,25,14],[24,24,24,25],[24,28,24,29],[25,23,26,29],[19,16,26,21],[19,23,20,29],[22,24,22,25],[22,28,22,29],[23,24,23,25],[23,28,23,29]]}
[]
["SITE NAME  ",null,{"$f":"'Inputs (Stream Selection)'!C1:F1","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"C2","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"K2","v":0},null,null,null,null,"SITE NAME  ",null,{"$f":"S2","v":0}]
["SAP Functional Location ",null,{"$f":"'Inputs (Stream Selection)'!C2:F2","v":0},null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,"SAP Functional Location ",null,0]
["Drawing Ref & Rev. Used ",null,{"$f":"'Inputs (Stream Selection)'!C3:F3","v":0},null,null,null,null,null,{"$f":"A4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,null,{"$f":"I4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,{"$f":"Q4","v":"Drawing Ref & Rev. Used "},null,0]
["Telemetry System",null,{"$f":"'Inputs (Stream Selection)'!C4:F4","v":0},null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,"Telemetry System",null,0]
["Date  ",null,{"$f":"'Inputs (Stream Selection)'!C5:F5","v":"00:00:00"},null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,"Date  ",null,"00:00:00"]
["Version  ",null,{"$f":"'Inputs (Stream Selection)'!C6:F6","v":0},null,null,null,null,null,"Version  ",null,0,null,null,null,null,null,"Version  ",null,0,null,null,null,null,"Version  ",null,0]
["Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"2 of 2",null,null,null,null,"Page Number",null,"2 of 2"]
[]
["UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS",null,null,null,null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS"]
[]
["MOP (Barg)",{"$f":"'Inputs (Stream Selection)'!C52","v":0},null,null,"MOP (Barg)",{"$f":"'Inputs (Stream Selection)'!C9","v":0},null,null,"MOP (Barg)",{"$f":"B12","v":0},null,null,"MOP (Barg)",{"$f":"F12","v":0},null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE",null,null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE"]
["MIP/SOL (Barg)",{"$f":"'Inputs (Stream Selection)'!C53","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"'Inputs (Stream Selection)'!E20","v":0.2},null,null,"MIP/SOL (Barg)",{"$f":"B13","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"F13","v":0.2},null,null,null,"Setting",null,null,"Setting",null,null,null,"Setting",null,null,"Setting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure High (Barg)",{"$f":"'Inputs (Stream Selection)'!C57","v":"N/A"},null,"Pressure High (Barg)",{"$f":"'Inputs (Stream Selection)'!C61","v":0},null,null,"Pressure High (Barg)",{"$f":"R14","v":"N/A"},null,"Pressure High (Barg)",{"$f":"U14","v":0}]
["PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,"PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,"Pressure Low (Barg)",{"$f":"'Inputs (Stream Selection)'!C58","v":0},null,"Pressure Low (Barg)",{"$f":"'Inputs (Stream Selection)'!C62","v":0},null,null,"Pressure Low (Barg)",{"$f":"R15","v":0},null,"Pressure Low (Barg)",{"$f":"U15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature High (°C)",{"$f":"'Inputs (Stream Selection)'!C59","v":30},null,"Temperature High (°C)",{"$f":"'Inputs (Stream Selection)'!C64","v":30},null,null,"Temperature High (°C)",{"$f":"R16","v":30},null,"Temperature High (°C)",{"$f":"U16","v":30}]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"Temperature Low (°C)",{"$f":"'Inputs (Stream Selection)'!C60","v":-3},null,"Temperature Low (°C)",{"$f":"'Inputs (Stream Selection)'!C65","v":-3},null,null,"Temperature Low (°C)",{"$f":"R17","v":-3},null,"Temperature Low (°C)",-3]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
["Slam Shut",{"$f":"'Inputs (Stream Selection)'!E21","v":0.2},null,null,"Slam Shut",{"$f":"'Inputs (Stream Selection)'!E21","v":0.2},null,null,{"$f":"IF(A19=\"\",\"\",A19)","v":"Slam Shut"},{"$f":"B19","v":0.2},null,null,{"$f":"IF(E19=\"\",\"\",E19)","v":"Slam Shut"},0.2,null,null,null,null,null,null,null,null,null,"SITE UPDATE CONTROL"]
["1st Stage Cut","N/A",null,null,"1st Stage Cut",{"$f":"B20","v":"N/A"},null,null,"1st Stage Cut",{"$f":"B20","v":"N/A"},null,null,"1st Stage Cut","N/A",null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)",null,null,null,null,null,null,"Please complete when all settings have been updated, visibly display site copy and send office copy back to site settings email AssetSiteSettings@wwutilities.co.uk "]
["Creep Relief",{"$f":"'Inputs (Stream Selection)'!E22","v":0.2},null,null,"Creep Relief",{"$f":"'Inputs (Stream Selection)'!E22","v":0.2},null,null,"Creep Relief",{"$f":"B21","v":0.2},null,null,"Creep Relief",0.2]
["Monitor ",{"$f":"'Inputs (Stream Selection)'!E25","v":0},null,null,"Monitor ",{"$f":"'Inputs (Stream Selection)'!E25","v":0},null,null,"Monitor ",{"$f":"B22","v":0},null,null,"Monitor ",0]
["Active",{"$f":"'Inputs (Stream Selection)'!E29","v":0},null,null,"Active",{"$f":"'Inputs (Stream Selection)'!E30","v":0},null,null,"Active",{"$f":"B23","v":0},null,null,"Active",0,null,null,null,null,null,null,null,null,null,null,"Print Name",null,"Sign Name","Date"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A24=\"\",\"\",A24)","v":""},null,null,null,{"$f":"IF(E24=\"\",\"\",E24)","v":""},{"$f":"IF(F24=\"\",\"\",F24)","v":""},null,null,null,null,null,null,null,null,null,"Mechanical Operative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E & I Operative"]
["ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,"ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)"]
[]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM"]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A30=\"\",\"\",A30)","v":""},{"$f":"IF(B30=\"\",\"\",B30)","v":""},null,null,{"$f":"IF(E30=\"\",\"\",E30)","v":""},{"$f":"IF(F30=\"\",\"\",F30)","v":""}]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]

{"sheet":"No S-S - Volumetric","index":12,"n_rows":44,"n_cols":28,"rows_kept":44,"cut":false,"hidden":true,"merged":[[32,0,32,6],[32,8,32,14],[19,16,27,21],[19,23,20,29],[23,28,23,29],[23,24,23,25],[24,24,24,25],[25,24,25,25],[24,28,24,29],[25,28,25,29],[26,23,27,29],[14,0,14,6],[14,9,14,15],[17,16,17,19],[17,23,17,26],[18,16,18,21],[18,23,18,29],[7,23,7,24],[7,25,7,27],[9,16,9,22],[9,23,9,29],[10,17,10,18],[10,19,10,20],[10,24,10,25],[10,26,10,27],[7,18,7,20],[7,0,7,1],[7,2,7,5],[7,8,7,9],[7,10,7,13],[7,16,7,17],[5,23,5,24],[5,25,5,27],[6,0,6,1],[6,2,6,5],[6,8,6,9],[6,10,6,13],[6,16,6,17],[6,18,6,20],[6,23,6,24],[6,25,6,27],[5,0,5,1],[5,2,5,5],[5,8,5,9],[5,10,5,13],[5,16,5,17],[5,18,5,20],[3,25,3,27],[4,0,4,1],[4,2,4,5],[4,8,4,9],[4,10,4,13],[4,16,4,17],[4,18,4,20],[4,23,4,24],[4,25,4,27],[3,0,3,1],[3,2,3,5],[3,10,3,13],[3,16,3,17],[3,18,3,20],[3,23,3,24],[3,8,3,9],[1,23,1,24],[1,25,1,27],[2,0,2,1],[2,2,2,5],[2,10,2,13],[2,16,2,17],[2,18,2,20],[2,23,2,24],[2,25,2,27],[1,0,1,1],[1,2,1,5],[1,8,1,9],[1,10,1,13],[1,16,1,17],[1,18,1,20],[2,8,2,9]]}
[]
["SITE NAME  ",null,{"$f":"'Inputs (No Stream Selection)'!C1:F1","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"C2","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"K2","v":0},null,null,null,null,"SITE NAME  ",null,{"$f":"S2","v":0}]
["SAP Functional Location ",null,{"$f":"'Inputs (No Stream Selection)'!C2:F2","v":0},null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,"SAP Functional Location ",null,0]
["Drawing Ref & Rev. Used ",null,{"$f":"'Inputs (No Stream Selection)'!C3:F3","v":0},null,null,null,null,null,{"$f":"A4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,null,{"$f":"I4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,{"$f":"Q4","v":"Drawing Ref & Rev. Used "},null,0]
["Telemetry System",null,{"$f":"'Inputs (No Stream Selection)'!C4:F4","v":0},null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,"Telemetry System",null,0]
["Date  ",null,{"$f":"'Inputs (No Stream Selection)'!C5:F5","v":"00:00:00"},null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,"Date  ",null,"00:00:00"]
["Version  ",null,{"$f":"'Inputs (No Stream Selection)'!C6:F6","v":0},null,null,null,null,null,"Version  ",null,0,null,null,null,null,null,"Version  ",null,0,null,null,null,null,"Version  ",null,0]
["Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"2 of 2",null,null,null,null,"Page Number",null,"2 of 2"]
[]
["UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS",null,null,null,null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS"]
[]
["MOP (Barg)",{"$f":"'Inputs (No Stream Selection)'!C52","v":0},null,null,"MOP (Barg)",{"$f":"'Inputs (No Stream Selection)'!C9","v":0},null,null,"MOP (Barg)",{"$f":"IF(B12=\"\",\"\",B12)","v":0},null,null,"MOP (Barg)",{"$f":"IF(F12=\"\",\"\",F12)","v":0},null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE",null,null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE"]
["MIP/SOL (Barg)",{"$f":"'Inputs (No Stream Selection)'!C53","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"'Inputs (No Stream Selection)'!E21","v":0.2},null,null,"MIP/SOL (Barg)","Out of Range",null,null,"MIP/SOL (Barg)",0.2,null,null,null,"Setting",null,null,"Setting",null,null,null,"Setting",null,null,"Setting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure High (Barg)",{"$f":"'Inputs (No Stream Selection)'!C57","v":"N/A"},null,"Pressure High (Barg)",{"$f":"'Inputs (No Stream Selection)'!C61","v":0},null,null,"Pressure High (Barg)",{"$f":"R14","v":"N/A"},null,"Pressure High (Barg)",{"$f":"U14","v":0}]
["PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,"PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,"Pressure Low (Barg)",{"$f":"'Inputs (No Stream Selection)'!C58","v":0},null,"Pressure Low (Barg)",{"$f":"'Inputs (No Stream Selection)'!C62","v":0},null,null,"Pressure Low (Barg)",{"$f":"R15","v":0},null,"Pressure Low (Barg)",{"$f":"U15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature High (°C)",{"$f":"'Inputs (No Stream Selection)'!C59","v":30},null,"Temperature High (°C)",{"$f":"'Inputs (No Stream Selection)'!C64","v":30},null,null,"Temperature High (°C)",{"$f":"R16","v":30},null,"Temperature High (°C)",{"$f":"U16","v":30}]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"Temperature Low (°C)",{"$f":"'Inputs (No Stream Selection)'!C60","v":-3},null,"Temperature Low (°C)",{"$f":"'Inputs (No Stream Selection)'!C65","v":-3},null,null,"Temperature Low (°C)",{"$f":"R17","v":-3},null,"Temperature Low (°C)",-3]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
["Slam Shut",{"$f":"'Inputs (No Stream Selection)'!E22","v":0.2},null,null,"Slam Shut",{"$f":"'Inputs (No Stream Selection)'!H22","v":0.2},null,null,{"$f":"IF(A19=\"\",\"\",A19)","v":"Slam Shut"},0.2,null,null,{"$f":"IF(E19=\"\",\"\",E19)","v":"Slam Shut"},{"$f":"IF(F19=\"\",\"\",F19)","v":0.2},null,null,null,null,null,null,null,null,null,"SITE UPDATE CONTROL"]
["1st Stage Cut",null,null,null,"1st Stage Cut",{"$f":"B20","v":0},null,null,"1st Stage Cut",{"$f":"IF(B20=\"\",\"\",B20)","v":""},null,null,"1st Stage Cut",0,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)",null,null,null,null,null,null,"Please complete when all settings have been updated, visibly display site copy and send office copy back to site settings email AssetSiteSettings@wwutilities.co.uk "]
["Creep Relief",{"$f":"'Inputs (No Stream Selection)'!E23","v":0.2},null,null,"Creep Relief",{"$f":"'Inputs (No Stream Selection)'!H23","v":0.2},null,null,"Creep Relief",0.2,null,null,"Creep Relief",0.2]
["Monitor ",{"$f":"'Inputs (No Stream Selection)'!E26","v":0},null,null,"Monitor ",{"$f":"'Inputs (No Stream Selection)'!H26","v":0},null,null,"Monitor ",0,null,null,"Monitor ",0]
["Active",{"$f":"'Inputs (No Stream Selection)'!E30","v":0},null,null,"Active",{"$f":"'Inputs (No Stream Selection)'!H30","v":0},null,null,"Active",0,null,null,"Active",0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(B24=\"\",\"\",B24)","v":""},null,null,"",{"$f":"IF(F24=\"\",\"\",F24)","v":""},null,null,null,null,null,null,null,null,null,null,"Print Name",null,"Sign Name","Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mechanical Operative"]
["VOLUMETRIC",null,null,null,"VOLUMETRIC",null,null,null,"VOLUMETRIC",null,null,null,"VOLUMETRIC",null,null,null,null,null,null,null,null,null,null,"E & I Operative"]
[null,"Settings (Barg)",null,null,null,"Settings (Barg)",null,null,null,"Settings (Barg)",null,null,null,"Settings (Barg)",null,null,null,null,null,null,null,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)"]
["HP Override (Pneumatic)",{"$f":"'Inputs (No Stream Selection)'!C68","v":"N/A"},null,null,"HP Override (Pneumatic)",{"$f":"'Inputs (No Stream Selection)'!C68","v":"N/A"},null,null,"HP Override (Pneumatic)",{"$f":"B28","v":"N/A"},null,null,"HP Override (Pneumatic)",{"$f":"F28","v":"N/A"}]
["LP Override (Pneumatic)",{"$f":"'Inputs (No Stream Selection)'!C70","v":"N/A"},null,null,"LP Override (Pneumatic)",{"$f":"'Inputs (No Stream Selection)'!C70","v":"N/A"},null,null,"LP Override (Pneumatic)",{"$f":"B29","v":"N/A"},null,null,"LP Override (Pneumatic)",{"$f":"F29","v":"N/A"}]
["HP Override (Electronic)",{"$f":"'Inputs (No Stream Selection)'!C67","v":"N/A"},null,null,"HP Override (Electronic)",{"$f":"'Inputs (No Stream Selection)'!C67","v":"N/A"},null,null,"HP Override (Electronic)",{"$f":"B30","v":"N/A"},null,null,"HP Override (Electronic)",{"$f":"F30","v":"N/A"}]
["LP Override (Electronic)",{"$f":"'Inputs (No Stream Selection)'!C69","v":"N/A"},null,null,"LP Override (Electronic)",{"$f":"'Inputs (No Stream Selection)'!C69","v":"N/A"},null,null,"LP Override (Electronic)",{"$f":"B31","v":"N/A"},null,null,"LP Override (Electronic)",{"$f":"F31","v":"N/A"}]
[]
["ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,"ADDITIONAL PRESSURE MANAGEMENT SETTINGS"]
[]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM"]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A37=\"\",\"\",A37)","v":""},"",null,null,{"$f":"IF(E37=\"\",\"\",E37)","v":""},""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]

{"sheet":"S-S - Volumetric","index":13,"n_rows":44,"n_cols":28,"rows_kept":44,"cut":false,"hidden":true,"merged":[[1,23,1,24],[1,25,1,27],[2,0,2,1],[2,2,2,5],[2,8,2,9],[2,10,2,13],[2,16,2,17],[2,18,2,20],[2,23,2,24],[2,25,2,27],[1,0,1,1],[1,2,1,5],[1,8,1,9],[1,10,1,13],[1,16,1,17],[1,18,1,20],[3,23,3,24],[3,25,3,27],[4,0,4,1],[4,2,4,5],[4,8,4,9],[4,10,4,13],[4,16,4,17],[4,18,4,20],[4,23,4,24],[4,25,4,27],[3,0,3,1],[3,2,3,5],[3,8,3,9],[3,10,3,13],[3,16,3,17],[3,18,3,20],[5,23,5,24],[5,25,5,27],[6,0,6,1],[6,2,6,5],[6,8,6,9],[6,10,6,13],[6,16,6,17],[6,18,6,20],[6,23,6,24],[6,25,6,27],[5,0,5,1],[5,2,5,5],[5,8,5,9],[5,10,5,13],[5,16,5,17],[5,18,5,20],[7,0,7,1],[7,2,7,5],[7,8,7,9],[7,10,7,13],[7,16,7,17],[7,23,7,24],[7,25,7,27],[9,16,9,22],[9,23,9,29],[10,17,10,18],[10,19,10,20],[10,24,10,25],[10,26,10,27],[7,18,7,20],[14,0,14,6],[14,9,14,15],[17,16,17,19],[17,23,17,26],[18,16,18,21],[18,23,18,29],[32,0,32,6],[32,8,32,14],[19,16,27,21],[19,23,20,29],[23,24,23,25],[23,28,23,29],[24,24,24,25],[24,28,24,29],[25,24,25,25],[25,28,25,29],[26,23,27,29]]}
[]
["SITE NAME  ",null,{"$f":"'Inputs (Stream Selection)'!C1:F1","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"C2","v":0},null,null,null,null,null,"SITE NAME  ",null,{"$f":"K2","v":0},null,null,null,null,"SITE NAME  ",null,{"$f":"S2","v":0}]
["SAP Functional Location ",null,{"$f":"'Inputs (Stream Selection)'!C2:F2","v":0},null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,null,"SAP Functional Location ",null,0,null,null,null,null,"SAP Functional Location ",null,0]
["Drawing Ref & Rev. Used ",null,{"$f":"'Inputs (Stream Selection)'!C3:F3","v":0},null,null,null,null,null,{"$f":"A4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,null,{"$f":"I4","v":"Drawing Ref & Rev. Used "},null,0,null,null,null,null,{"$f":"Q4","v":"Drawing Ref & Rev. Used "},null,0]
["Telemetry System",null,{"$f":"'Inputs (Stream Selection)'!C4:F4","v":0},null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,null,"Telemetry System",null,0,null,null,null,null,"Telemetry System",null,0]
["Date  ",null,{"$f":"'Inputs (Stream Selection)'!C5:F5","v":"00:00:00"},null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,null,"Date  ",null,"00:00:00",null,null,null,null,"Date  ",null,"00:00:00"]
["Version  ",null,{"$f":"'Inputs (Stream Selection)'!C6:F6","v":0},null,null,null,null,null,"Version  ",null,0,null,null,null,null,null,"Version  ",null,0,null,null,null,null,"Version  ",null,0]
["Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"1 of 2",null,null,null,null,null,"Page Number",null,"2 of 2",null,null,null,null,"Page Number",null,"2 of 2"]
[]
["UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"UPSTREAM SYSTEM ",null,null,null,"DOWNSTREAM SYSTEM ",null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS",null,null,null,null,null,null,"ELECTRICAL & INSTRUMENTATION SETTINGS"]
[]
["MOP (Barg)",{"$f":"'Inputs (Stream Selection)'!C52","v":0},null,null,"MOP (Barg)",{"$f":"'Inputs (Stream Selection)'!C9","v":0},null,null,"MOP (Barg)",{"$f":"B12","v":0},null,null,"MOP (Barg)",{"$f":"F12","v":0},null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE",null,null,null,"INLET HARDWARE",null,null,"OUTLET HARDWARE"]
["MIP/SOL (Barg)",{"$f":"'Inputs (Stream Selection)'!C53","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"'Inputs (Stream Selection)'!E20","v":0.2},null,null,"MIP/SOL (Barg)",{"$f":"B13","v":"Out of Range"},null,null,"MIP/SOL (Barg)",{"$f":"F13","v":0.2},null,null,null,"Setting",null,null,"Setting",null,null,null,"Setting",null,null,"Setting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure High (Barg)",{"$f":"'Inputs (Stream Selection)'!C57","v":"N/A"},null,"Pressure High (Barg)",{"$f":"'Inputs (Stream Selection)'!C61","v":0},null,null,"Pressure High (Barg)",{"$f":"R14","v":"N/A"},null,"Pressure High (Barg)",{"$f":"U14","v":0}]
["PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,null,"PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,"Pressure Low (Barg)",{"$f":"'Inputs (Stream Selection)'!C58","v":0},null,"Pressure Low (Barg)",{"$f":"'Inputs (Stream Selection)'!C62","v":0},null,null,"Pressure Low (Barg)",{"$f":"R15","v":0},null,"Pressure Low (Barg)",{"$f":"U15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature High (°C)",{"$f":"'Inputs (Stream Selection)'!C59","v":30},null,"Temperature High (°C)",{"$f":"'Inputs (Stream Selection)'!C64","v":30},null,null,"Temperature High (°C)",{"$f":"R16","v":30},null,"Temperature High (°C)",{"$f":"U16","v":30}]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"Temperature Low (°C)",{"$f":"'Inputs (Stream Selection)'!C60","v":-3},null,"Temperature Low (°C)",{"$f":"'Inputs (Stream Selection)'!C65","v":-3},null,null,"Temperature Low (°C)",{"$f":"R17","v":-3},null,"Temperature Low (°C)",-3]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
["Slam Shut",{"$f":"'Inputs (Stream Selection)'!E21","v":0.2},null,null,"Slam Shut",{"$f":"'Inputs (Stream Selection)'!E21","v":0.2},null,null,{"$f":"IF(A19=\"\",\"\",A19)","v":"Slam Shut"},{"$f":"IF(B19=\"\",\"\",B19)","v":0.2},null,null,{"$f":"IF(E19=\"\",\"\",E19)","v":"Slam Shut"},{"$f":"IF(F19=\"\",\"\",F19)","v":0.2},null,null,null,null,null,null,null,null,null,"SITE UPDATE CONTROL"]
["1st Stage Cut",null,null,null,"1st Stage Cut",{"$f":"B20","v":0},null,null,"1st Stage Cut","",null,null,"1st Stage Cut",0,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)",null,null,null,null,null,null,"Please complete when all settings have been updated, visibly display site copy and send office copy back to site settings email AssetSiteSettings@wwutilities.co.uk "]
["Creep Relief",{"$f":"'Inputs (Stream Selection)'!E22","v":0.2},null,null,"Creep Relief",{"$f":"'Inputs (Stream Selection)'!E22","v":0.2},null,null,"Creep Relief",0.2,null,null,"Creep Relief",0.2]
["Monitor ",{"$f":"'Inputs (Stream Selection)'!E25","v":0},null,null,"Monitor ",{"$f":"'Inputs (Stream Selection)'!E25","v":0},null,null,"Monitor ",0,null,null,"Monitor ",0]
["Active",{"$f":"'Inputs (Stream Selection)'!E29","v":0},null,null,"Active",{"$f":"'Inputs (Stream Selection)'!E30","v":0},null,null,"Active",0,null,null,"Active",0]
[null,null,null,null,null,null,null,null,{"$f":"IF(A24=\"\",\"\",A24)","v":""},{"$f":"IF(B24=\"\",\"\",B24)","v":""},null,null,{"$f":"IF(E24=\"\",\"\",E24)","v":""},{"$f":"IF(F24=\"\",\"\",F24)","v":""},null,null,null,null,null,null,null,null,null,null,"Print Name",null,"Sign Name","Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mechanical Operative"]
["VOLUMETRIC",null,null,null,"VOLUMETRIC",null,null,null,"VOLUMETRIC",null,null,null,"VOLUMETRIC",null,null,null,null,null,null,null,null,null,null,"E & I Operative"]
[null,"Settings (Barg)",null,null,null,"Settings (Barg)",null,null,null,"Settings (Barg)",null,null,null,"Settings (Barg)",null,null,null,null,null,null,null,null,null,"If you have any queries regarding this form or the settings provided please contact \nMorgan James (07805 808741) or Helen Fitzgerald (07814 169374)"]
["HP Override (Pneumatic)",{"$f":"'Inputs (Stream Selection)'!C68","v":0},null,null,"HP Override (Pneumatic)",{"$f":"'Inputs (Stream Selection)'!C68","v":0},null,null,"HP Override (Pneumatic)",{"$f":"B28","v":0},null,null,"HP Override (Pneumatic)",{"$f":"F28","v":0}]
["LP Override (Pneumatic)",{"$f":"'Inputs (Stream Selection)'!C70","v":0},null,null,"LP Override (Pneumatic)",{"$f":"'Inputs (Stream Selection)'!C70","v":0},null,null,"LP Override (Pneumatic)",{"$f":"B29","v":0},null,null,"LP Override (Pneumatic)",{"$f":"F29","v":0}]
["HP Override (Electronic)",{"$f":"'Inputs (Stream Selection)'!C67","v":0},null,null,"HP Override (Electronic)",{"$f":"'Inputs (Stream Selection)'!C67","v":0},null,null,"HP Override (Electronic)",{"$f":"B30","v":0},null,null,"HP Override (Electronic)",{"$f":"F30","v":0}]
["LP Override (Electronic)",{"$f":"'Inputs (Stream Selection)'!C69","v":0},null,null,"LP Override (Electronic)",{"$f":"'Inputs (Stream Selection)'!C69","v":0},null,null,"LP Override (Electronic)",{"$f":"B31","v":0},null,null,"LP Override (Electronic)",{"$f":"F31","v":0}]
[]
["ADDITIONAL PRESSURE MANAGEMENT SETTINGS",null,null,null,null,null,null,null,"ADDITIONAL PRESSURE MANAGEMENT SETTINGS"]
[]
["WORKING STREAM",null,null,null,"STANDBY STREAM",null,null,null,"WORKING STREAM",null,null,null,"STANDBY STREAM"]
["Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)",null,null,"Equipment","Setting (Barg)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A37=\"\",\"\",A37)","v":""},{"$f":"IF(B37=\"\",\"\",B37)","v":""},null,null,{"$f":"IF(E37=\"\",\"\",E37)","v":""},{"$f":"IF(F37=\"\",\"\",F37)","v":""}]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,"",""]

{"sheet":"Data Tandem(stream selection)","index":14,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Static Data:",null,null,"Operational Settings:","(set default as 999)"]
["MOP (As built)",{"$f":"'Inputs Tandem(Stream Selection)'!C9","v":0},null,"Slamshut",{"$f":"'Inputs Tandem(Stream Selection)'!H10","v":999},{"$f":"IF(E2>C11,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Accuracy Group (As built)",{"$f":"'Inputs Tandem(Stream Selection)'!C11*100","v":0},null,"Monitor Reg",{"$f":"'Inputs Tandem(Stream Selection)'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(E3>#REF!,\"Exceeds max\",\"\")","v":{"$error":"#REF!"}}]
["Accuracy Class (As built)",{"$f":"'Inputs Tandem(Stream Selection)'!C10*100","v":0},null,"Active Reg",{"$f":"'Inputs Tandem(Stream Selection)'!H11","v":999},{"$f":"IF(E4>C16,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Asm - Creep and Active/monitor regulator",{"$f":"'Inputs Tandem(Stream Selection)'!C13*100","v":0}]
["Asm - Slam shut and creep relief",{"$f":"100*'Inputs Tandem(Stream Selection)'!C15","v":0},null,"Asm - AR/MR working and standby",{"$f":"'Inputs Tandem(Stream Selection)'!C14*100","v":0}]
["Design Pressure (for MOP =<0.1)",null,{"$f":"IF(AND(B2<=0.1,B7=\"\"),\"<< Enter DP\",\"\")","v":"<< Enter DP"},"Active Reg (standby stream)",{"$f":"'Inputs Tandem(Stream Selection)'!H12","v":999},{"$f":"IF(E7>C18,\"Exceeds max\",\"\")","v":"Exceeds max"}]
[null,null,null,null,null,{"$f":"IF(E8>C18,\"Exceeds max\",\"\")","v":""}]
[null,"TD13 %ages","Takes Account of TD13, avoids overlaps, and takes account of data entered in e2:e4"]
["TD13 Maximum Incidental Pressure (MIP)",{"$f":"IF(AND(B2>2,B2<=7),IF('Inputs Tandem(Stream Selection)'!C8=\"yes\",1.33,1.2),IF($B$2<='TD13 %ages'!A$2,\"NA\",IF('Data Tandem(stream selection)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!D$3,IF('Data Tandem(stream selection)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!D$4,IF('Data Tandem(stream selection)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!D$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!D$6,\"MOP above 100 no data available\"))))))","v":"NA"},{"$f":"IF(B10=\"NA\",0.2,B10*B2)","v":0.2}]
["Slam Shut Valve (SSV) - Both Streams",null,{"$f":"MIN(C10/(1+B$3/100),E2)","v":0.2}]
["Creep Relief (CR) - Both Streams",null,{"$f":"C11*(1-(B$3)/100)*(1-(B$6)/100)","v":0.2}]
[]
["TD13 Peak Level Operating Pressure (PLOP)",null,{"$f":"B15*B2","v":0}]
["Calculated PLOP",{"$f":"IF($B$2<='TD13 %ages'!A$2,'TD13 %ages'!B$2,IF('Data Tandem(stream selection)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!B$3,IF('Data Tandem(stream selection)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!B$4,IF('Data Tandem(stream selection)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!B$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!B$6,\"MOP above 100 no data available\")))))","v":1.125},{"$f":"MIN(C12,B15*B2)","v":0}]
["Active & Monitor Regulator (AR/MR) - Working Stream",null,{"$f":"MIN((C15/(1+B4/100)/(1+B5/100)),B2,E4)","v":0}]
[null,null,{"$f":"C16/(1+B4/100)","v":0}]
["Active & Monitor Regulator (AR/MR) - Standby Stream",null,{"$f":"MIN(C17/(1+B4/100)/(1+E6/100),E7,B2)","v":0}]

{"sheet":"DataCheck Tandem(no stream sel)","index":15,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Static Data:",null,null,null,"Operational Settings (standby):","(set default as 999)",null,"Operational Settings (working):","(set default as 999)"]
["MOP (As built)",{"$f":"'Inputs Tandem(No Stream Sel)'!C9","v":0},null,null,"Slamshut ",{"$f":"'Inputs Tandem(No Stream Sel)'!H12","v":999},{"$f":"IF(F2>C10,\"Exceeds max\",\"\")","v":"Exceeds max"},"Slamshut",{"$f":"'Inputs Tandem(No Stream Sel)'!H10","v":999},{"$f":"IF(I2>F10,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Accuracy Group (As built)",{"$f":"'Inputs Tandem(No Stream Sel)'!C11*100","v":0},null,null,null,null,{"$f":"IF(F3>C15,\"Exceeds max\",\"\")","v":""},null,null,{"$f":"IF(I3>F15,\"Exceeds max\",\"\")","v":""}]
["Accuracy Class (As built)",{"$f":"'Inputs Tandem(No Stream Sel)'!C10*100","v":0},null,null,"Active & Monitor Regulator",{"$f":"'Inputs Tandem(No Stream Sel)'!H13","v":999},{"$f":"IF(F4>C20,\"Exceeds max\",\"\")","v":"Exceeds max"},"Active & Monitor Regulator",{"$f":"'Inputs Tandem(No Stream Sel)'!H11","v":5.6929999999999996},{"$f":"IF(I4>F20,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Asm - Creep and AR/MR WS",{"$f":"'Inputs Tandem(No Stream Sel)'!C13*100","v":0},null,null,null,null,null,"Asm - slam shut and creep",{"$f":"'Inputs Tandem(No Stream Sel)'!C15*100","v":0}]
[null,null,null,null,"Asm - active regs working and standby",{"$f":"'Inputs Tandem(No Stream Sel)'!C14*100","v":0},null,"Asm -slam shut upper and lower",{"$f":"'Inputs Tandem(No Stream Sel)'!C16*100","v":0}]
[null,null,null,null,null,null,{"$f":"IF(F7>#REF!,\"Exceeds max\",\"\")","v":{"$error":"#REF!"}}]
["Standby","TD13\n%ages","Takes Account of TD13, avoids overlaps, and takes account of operational settings",null,"Working","Takes Account of TD13, avoids overlaps, and takes account of operational settings"]
["TD13 Maximum Incidental Pressure (MIP)",{"$f":"IF(AND($B$2>2,$B$2<=7),IF('Inputs Tandem(No Stream Sel)'!C8=\"yes\",1.33,1.2),IF($B$2<='TD13 %ages'!A$2,\"NA\",IF('DataCheck Tandem(no stream sel)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!D$3,IF('DataCheck Tandem(no stream sel)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!D$4,IF('DataCheck Tandem(no stream sel)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!D$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!D$6,\"MOP above 100 no data available\"))))))","v":"NA"},{"$f":"IF(B9=\"NA\",0.2,B9*B2)","v":0.2},null,"TD13 Maximum Incidental Pressure (MIP)",{"$f":"C9","v":0.2}]
["Slam Shut Valve (SSV)",null,{"$f":"MIN(C9/(1+B$3/100),F2)","v":0.2},null,"Slam Shut Valve (SSV)",{"$f":"MIN(($C$10*(1-($B$3)/100)/(1+B$3/100))*(1-I6/100),I2)","v":0.2}]
["Creep Relief (CR)",null,{"$f":"F11","v":0.2},null,"Creep Relief (CR)",{"$f":"F10*(1-(B$3)/100)*(1-I5/100)","v":0.2}]
[]
[]
[]
[]
[]
[]
["TD13 Peak Level Operating Pressure (PLOP)",null,{"$f":"$B$19*$B$2","v":0},null,"TD13 Peak Level Operating Pressure (PLOP)",{"$f":"$B$19*$B$2","v":0}]
["Calculated PLOP",{"$f":"IF($B$2<='TD13 %ages'!A$2,'TD13 %ages'!B$2,IF('DataCheck Tandem(no stream sel)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!B$3,IF('DataCheck Tandem(no stream sel)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!B$4,IF('DataCheck Tandem(no stream sel)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!B$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!B$6,\"MOP above 100 no data available\")))))","v":1.125},{"$f":"MIN(C11/(1+B5/100),B19*B2)","v":0},null,"Calculated PLOP",{"$f":"MIN(F11,C19)","v":0}]
["Active & Monitor Regulator (AR)",null,{"$f":"MIN(C19/(1+B4/100),F4,($F$20*(1-$B$4/100))/(1+F6/100)/(1+B4/100))","v":0},null,"Active & Monitor Regulator (AR)",{"$f":"MIN(($F$19/(1+$B$4/100)),$B$2,$I$4)","v":0}]

{"sheet":"DataCheck (Single stream)","index":16,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Static Data:",null,null,null,null,null,null,"Operational Settings (working):","(set default as 999)"]
["MOP (As built)",{"$f":"'Inputs (Single Stream)'!C9","v":30},null,null,null,null,null,"Slamshut",{"$f":"'Inputs (Single Stream)'!H11","v":999},{"$f":"IF(I2>F11,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Accuracy Group (As built)",{"$f":"'Inputs (Single Stream)'!C12*100","v":0},null,null,null,null,null,"Monitor Regulator",{"$f":"'Inputs (Single Stream)'!H12","v":999},{"$f":"IF(I3>F16,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Accuracy Class Monitor Reg (As built)",{"$f":"'Inputs (Single Stream)'!C10*100","v":0}]
["Accuracy Class Active Reg (As built)",{"$f":"'Inputs (Single Stream)'!C11*100","v":0},null,null,null,null,null,"Active Regulator",{"$f":"'Inputs (Single Stream)'!H13","v":999},{"$f":"IF(I5>F21,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Asm - Creep and AR/MR WS",{"$f":"'Inputs (Single Stream)'!C14*100","v":0},null,null,null,null,null,"Asm - monitor and active regs",{"$f":"'Inputs (Single Stream)'!C15*100","v":0}]
[]
[null,null,null,null,null,null,{"$f":"IF(F8>#REF!,\"Exceeds max\",\"\")","v":{"$error":"#REF!"}}]
["Working","TD13\n%ages","Takes Account of TD13, avoids overlaps, and takes account of operational settings"]
["TD13 Maximum Incidental Pressure (MIP)",{"$f":"IF(AND($B$2>2,$B$2<=7),IF('Inputs (Single Stream)'!C8=\"yes\",1.33,1.2),IF($B$2<='TD13 %ages'!A$2,\"NA\",IF('DataCheck (Single stream)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!D$3,IF('DataCheck (Single stream)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!D$4,IF('DataCheck (Single stream)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!D$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!D$6,\"MOP above 100 no data available\"))))))","v":1.1000000000000001},{"$f":"IF(B10=\"NA\",0.2,B10*B2)","v":33}]
["Slam Shut Valve (SSV)",null,{"$f":"MIN(C10/(1+B$3/100),I2)","v":33}]
["Creep Relief (CR)",null,{"$f":"$C$11*(1-($B3)/100)*(1-$I$6/100)","v":33}]
[]
["TD13 Temporary Operating Pressure (TOP)",null,{"$f":"$B$15*$B$2","v":31.5}]
["Calculated TOP",{"$f":"IF($B$2<='TD13 %ages'!A$2,'TD13 %ages'!C$2,IF('DataCheck (Single stream)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!C$3,IF('DataCheck (Single stream)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!C$4,IF('DataCheck (Single stream)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!C$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!C$6,\"MOP above 100 no data available\")))))","v":1.05},{"$f":"MIN($B$15*$B$2,$C$12)","v":31.5}]
["Monitor Regulator (MR)",null,{"$f":"MIN($I$3,$C$15/(1+$B$4/100)/(1+B6/100))","v":31.5}]
["Lower Accuracy Level MR",null,{"$f":"$C$16*(1-($B$4)/100)","v":31.5}]
[]
["TD13 Peak Level Operating Pressure (PLOP)",null,{"$f":"$B$20*$B$2","v":30.749999999999996}]
["Calculated PLOP",{"$f":"IF($B$2<='TD13 %ages'!A$2,'TD13 %ages'!B$2,IF('DataCheck (Single stream)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!B$3,IF('DataCheck (Single stream)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!B$4,IF('DataCheck (Single stream)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!B$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!B$6,\"MOP above 100 no data available\")))))","v":1.0249999999999999},{"$f":"MIN(C17/(1+I6/100),B20*B2)","v":30.749999999999996}]
["Active Regulator (AR)",null,{"$f":"MIN(C20/((1+B5/100))/(1+I6/100),I5,B2)","v":30}]

{"sheet":"DataCheck (stream selection)","index":17,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Static Data:",null,null,"Operational Settings:","(set default as 999)"]
["MOP (As built)",{"$f":"'Inputs (Stream Selection)'!C9","v":0},null,"Slamshut",{"$f":"'Inputs (Stream Selection)'!H11","v":999},{"$f":"IF(E2>C12,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Accuracy Group (As built)",{"$f":"'Inputs (Stream Selection)'!C12*100","v":0},null,"Monitor Reg",{"$f":"'Inputs (Stream Selection)'!H12","v":999},{"$f":"IF(E3>C17,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Accuracy Class Monitor Reg (As built)",{"$f":"'Inputs (Stream Selection)'!C10*100","v":0}]
["Accuracy Class Active Reg (As built)",{"$f":"'Inputs (Stream Selection)'!C11*100","v":0},null,"Active Reg",{"$f":"'Inputs (Stream Selection)'!H13","v":999},{"$f":"IF(E5>C22,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Asm - Creep and monitor regulator",{"$f":"'Inputs (Stream Selection)'!C14*100","v":0},null,"Asm - monitor and active regs",{"$f":"'Inputs (Stream Selection)'!C15*100","v":0}]
["Asm - Slam shut and creep relief",{"$f":"100*'Inputs (Stream Selection)'!C17","v":0},null,"Asm - active regs working and standby",{"$f":"'Inputs (Stream Selection)'!C16*100","v":0}]
[null,null,null,"Active Reg (standby stream)",{"$f":"'Inputs (Stream Selection)'!H14","v":999},{"$f":"IF(E8>C24,\"Exceeds max\",\"\")","v":"Exceeds max"}]
[null,null,null,null,null,{"$f":"IF(E9>C24,\"Exceeds max\",\"\")","v":""}]
[null,"TD13 %ages","Takes Account of TD13, avoids overlaps, and takes account of data entered in e2:e4"]
["TD13 Maximum Incidental Pressure (MIP)",{"$f":"IF(AND(B2>2,B2<=7),IF('Inputs (Stream Selection)'!C8=\"yes\",1.33,1.2),IF($B$2<='TD13 %ages'!A$2,\"NA\",IF('DataCheck (stream selection)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!D$3,IF('DataCheck (stream selection)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!D$4,IF('DataCheck (stream selection)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!D$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!D$6,\"MOP above 100 no data available\"))))))","v":"NA"},{"$f":"IF(B11=\"NA\",0.2,B11*B2)","v":0.2}]
["Slam Shut Valve (SSV) - Both Streams",null,{"$f":"MIN(C11/(1+B$3/100),E2)","v":0.2}]
["Creep Relief (CR) - Both Streams",null,{"$f":"C12*(1-(B$3)/100)*(1-(B$7)/100)","v":0.2}]
[]
["TD13 Temporary Operating Pressure (TOP)",null,{"$f":"B16*B2","v":0}]
["Calculated TOP",{"$f":"IF($B$2<='TD13 %ages'!A$2,'TD13 %ages'!C$2,IF('DataCheck (stream selection)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!C$3,IF('DataCheck (stream selection)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!C$4,IF('DataCheck (stream selection)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!C$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!C$6,\"MOP above 100 no data available\")))))","v":1.35},{"$f":"MIN(B16*B2,C13)","v":0}]
["Monitor Regulator (MR) - Both Streams",null,{"$f":"MIN(E3,C16/(1+B$4/100)/(1+B6/100))","v":0}]
["Lower Accuracy Level MR",null,{"$f":"C17*(1-(B$4)/100)","v":0}]
[]
["TD13 Peak Level Operating Pressure (PLOP)",null,{"$f":"B21*B2","v":0}]
["Calculated PLOP",{"$f":"IF($B$2<='TD13 %ages'!A$2,'TD13 %ages'!B$2,IF('DataCheck (stream selection)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!B$3,IF('DataCheck (stream selection)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!B$4,IF('DataCheck (stream selection)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!B$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!B$6,\"MOP above 100 no data available\")))))","v":1.125},{"$f":"MIN(C18,B21*B2)","v":0}]
["Active Regulator (AR) - Working Stream",null,{"$f":"MIN((C21/(1+B5/100)/(1+E6/100)),B2,E5)","v":0}]
[null,null,{"$f":"C22/(1+B5/100)","v":0}]
["Active Regulator (AR) - Standby Stream",null,{"$f":"MIN(C23/(1+B5/100)/(1+E7/100),E8,B2)","v":0}]
[]
[]
[]
["Software High High",null,{"$f":"C17+((C13-C17)/2)","v":0.1}]
["Hardware High ",null,{"$f":"C17","v":0}]
["Software High  ",null,{"$f":"C22+((C17-C22)/2)","v":0}]
["Software Low",null,{"$f":"C22-((C22-C24)/2)","v":0}]
["Hardware Low",null,{"$f":"C24","v":0}]
["Software Low Low",null,{"$f":"0.9*C22","v":0}]

{"sheet":"DataCheck (no stream selection)","index":18,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Static Data:",null,null,null,"Operational Settings (standby):","(set default as 999)",null,"Operational Settings (working):","(set default as 999)"]
["MOP (As built)",{"$f":"'Inputs (No Stream Selection)'!C9","v":0},null,null,"Slamshut ",{"$f":"'Inputs (No Stream Selection)'!H14","v":999},{"$f":"IF(F2>C11,\"Exceeds max\",\"\")","v":"Exceeds max"},"Slamshut",{"$f":"'Inputs (No Stream Selection)'!H11","v":999},{"$f":"IF(I2>F11,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Accuracy Group (As built)",{"$f":"'Inputs (No Stream Selection)'!C12*100","v":0},null,null,"Monitor Regulator",{"$f":"'Inputs (No Stream Selection)'!H15","v":999},{"$f":"IF(F3>C16,\"Exceeds max\",\"\")","v":"Exceeds max"},"Monitor Regulator",{"$f":"'Inputs (No Stream Selection)'!H12","v":999},{"$f":"IF(I3>F16,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Accuracy Class Monitor (As built)",{"$f":"'Inputs (No Stream Selection)'!C10*100","v":0}]
["Accuracy Class Active (As built)",{"$f":"'Inputs (No Stream Selection)'!C11*100","v":0},null,null,"Active Regulator",{"$f":"'Inputs (No Stream Selection)'!H16","v":999},{"$f":"IF(F5>C21,\"Exceeds max\",\"\")","v":"Exceeds max"},"Active Regulator",{"$f":"'Inputs (No Stream Selection)'!H13","v":999},{"$f":"IF(I5>F21,\"Exceeds max\",\"\")","v":"Exceeds max"}]
["Asm - Creep and monitor regulator",{"$f":"'Inputs (No Stream Selection)'!C14*100","v":0},null,null,"Asm - monitor and active regs",{"$f":"'Inputs (No Stream Selection)'!C15*100","v":0},null,"Asm - slam shut and creep",{"$f":"'Inputs (No Stream Selection)'!C17*100","v":0}]
[null,null,null,null,"Asm - active regs working and standby",{"$f":"'Inputs (No Stream Selection)'!C16*100","v":0},null,"Asm -slam shut upper and lower",{"$f":"'Inputs (No Stream Selection)'!C18*100","v":0}]
[null,null,null,null,null,null,{"$f":"IF(F8>#REF!,\"Exceeds max\",\"\")","v":{"$error":"#REF!"}}]
["Standby","TD13\n%ages","Takes Account of TD13, avoids overlaps, and takes account of operational settings",null,"Working","Takes Account of TD13, avoids overlaps, and takes account of operational settings"]
["TD13 Maximum Incidental Pressure (MIP)",{"$f":"IF(AND($B$2>2,$B$2<=7),IF('Inputs (No Stream Selection)'!C8=\"yes\",1.33,1.2),IF($B$2<='TD13 %ages'!A$2,\"NA\",IF('DataCheck (no stream selection)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!D$3,IF('DataCheck (no stream selection)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!D$4,IF('DataCheck (no stream selection)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!D$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!D$6,\"MOP above 100 no data available\"))))))","v":"NA"},{"$f":"IF(B10=\"NA\",0.2,B10*B2)","v":0.2},null,"TD13 Maximum Incidental Pressure (MIP)",{"$f":"C10","v":0.2}]
["Slam Shut Valve (SSV)",null,{"$f":"MIN(C10/(1+B$3/100),F2)","v":0.2},null,"Slam Shut Valve (SSV)",{"$f":"MIN(($C$11*(1-($B$3)/100)/(1+B$3/100))*(1-I7/100),I2)","v":0.2}]
["Creep Relief (CR)",null,{"$f":"F12","v":0.2},null,"Creep Relief (CR)",{"$f":"F11*(1-(B$3)/100)*(1-I6/100)","v":0.2}]
[]
["TD13 Temporary Operating Pressure (TOP)",null,{"$f":"$B$15*$B$2","v":0},null,"TD13 Temporary Operating Pressure (TOP)",{"$f":"$B$15*$B$2","v":0}]
["Calculated TOP",{"$f":"IF($B$2<='TD13 %ages'!A$2,'TD13 %ages'!C$2,IF('DataCheck (no stream selection)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!C$3,IF('DataCheck (no stream selection)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!C$4,IF('DataCheck (no stream selection)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!C$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!C$6,\"MOP above 100 no data available\")))))","v":1.35},{"$f":"MIN($B$15*$B$2,$C$12,F12)","v":0},null,"Calculated TOP",{"$f":"MIN($B$15*$B$2,$F$12)","v":0}]
["Monitor Regulator (MR)",null,{"$f":"MIN($F$3,$C$15/(1+$B$4/100)/(1+B6/100))","v":0},null,"Monitor Regulator (MR)",{"$f":"MIN($I$3,($F$15/(1+$B$4/100))/(1+B6/100))","v":0}]
["Lower Accuracy Level MR",null,{"$f":"$C$16*(1-($B$4)/100)","v":0},null,"Lower Accuracy Level MR",{"$f":"$F$16*(1-($B$4)/100)","v":0}]
[]
["TD13 Peak Level Operating Pressure (PLOP)",null,{"$f":"$B$20*$B$2","v":0},null,"TD13 Peak Level Operating Pressure (PLOP)",{"$f":"$B$20*$B$2","v":0}]
["Calculated PLOP",{"$f":"IF($B$2<='TD13 %ages'!A$2,'TD13 %ages'!B$2,IF('DataCheck (no stream selection)'!$B$2<='TD13 %ages'!A$3,'TD13 %ages'!B$3,IF('DataCheck (no stream selection)'!$B$2<='TD13 %ages'!A$4,'TD13 %ages'!B$4,IF('DataCheck (no stream selection)'!$B$2<='TD13 %ages'!A$5,'TD13 %ages'!B$5,IF($B$2<='TD13 %ages'!A$6,'TD13 %ages'!B$6,\"MOP above 100 no data available\")))))","v":1.125},{"$f":"MIN(C17/(1+F6/100),B20*B2)","v":0},null,"Calculated PLOP",{"$f":"MIN(F17,C20)","v":0}]
["Active Regulator (AR)",null,{"$f":"MIN(C20/(1+B5/100),F5,($F$21*(1-$B$5/100))/(1+F7/100)/(1+B5/100))","v":0},null,"Active Regulator (AR)",{"$f":"MIN(($F$20/(1+$B$5/100)),$B$2,$I$5)","v":0}]
[]
[]
[]
["Software High High"]
["Hardware High ",null,{"$f":"F16","v":0}]
["Software High  "]
["Software Low"]
["Hardware Low",null,{"$f":"C21","v":0}]
["Software Low Low"]

{"sheet":"TD13 %ages","index":19,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Max Pressure (bar)","Peak level OP","TOP","MIP"]
[0.1,1.125,1.35,"Lower of 2.5 Dp and 0.2 bar (accounted for in front sheet)"]
[1,1.125,1.35,1.75]
[2,1.1000000000000001,1.2,1.35]
[7,1.05,1.1000000000000001,1.2]
[100,1.0249999999999999,1.05,1.1000000000000001]
[]
["Max Pressure (bar)","Top of Constant Pressure (CP) or Controllable Range (CR) = PLOP"]
[0.1,1.125]
[1,1.125]
[2,1.1000000000000001]
[7,1.05]
[100,1.0249999999999999]

{"sheet":"Sheet1","index":20,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Number of Streams?","Stream Selection?","Volumetric?","Pressure?"]
[]
[null,"One","Yes","Volumetric","Yes"]
[null,"Two","No","Pressure Control","No"]
[]
[]
[]
[null,"Inputs (No Stream Selection)","Inputs (Stream Selection)","Inputs (No Stream Selection)","Inputs (Stream Selection)"]
[null,"No S-S - Pressure Control","S-S - Pressure Control","No S-S - Volumetric","S-S - Volumetric"]

{"sheet":"Cases","index":21,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Inputs (No Stream Selection) : No S-S - Pressure Control"]
[null,"Inputs (Stream Selection) : S-S - Pressure Control"]
[null,"Inputs (No Stream Selection) : No S-S - Volumetric"]
[null,"Inputs (Stream Selection) : S-S - Volumetric"]

{"sheet":"Worked Examples","index":22,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Pembroke Dock PRI Settings",null,null,null,null,null,null,"Neath PRI Settings - stream selection present?",null,null,null,null,null,null,null,"Cirencester Offtake IP"]
["HP-MP",null,null,null,null,null,null,"VHP-MP",null,null,null,null,null,null,null,"VHP-IP"]
[null,"Existing","Proposed","% MOP",null,null,null,null,"Existing Working","Proposed Working","% MOP","Existing Standby","Proposed Standby","% MOP",null,null,"Existing Working","Proposed Working","% MOP","Existing Standby","Proposed Standby","% MOP"]
["STREAM SELECTION","Barg","Barg","%",null,null,null,"STREAM SELECTION","Barg","Barg","%","Barg","Barg","%",null,"STREAM SELECTION","Barg","Barg","%","Barg","Barg","%"]
["TD13 Maximum Incidental Pressure (MIP)",null,{"$f":"'Inputs (Stream Selection)'!E20","v":0.2},{"$f":"C5/$C$14","v":{"$error":"#DIV/0!"}},null,null,null,"TD13 Maximum Incidental Pressure (MIP)",null,{"$f":"'Inputs (No Stream Selection)'!E21","v":0.2},{"$f":"J5/$J$14","v":{"$error":"#DIV/0!"}},null,{"$f":"'Inputs (No Stream Selection)'!H21","v":0.2},{"$f":"M5/$J$14","v":{"$error":"#DIV/0!"}},null,"TD13 Maximum Incidental Pressure (MIP)",null,{"$f":"'Inputs (No Stream Selection)'!E21","v":0.2},{"$f":"R5/$J$14","v":{"$error":"#DIV/0!"}},null,{"$f":"'Inputs (No Stream Selection)'!H21","v":0.2},{"$f":"U5/$J$14","v":{"$error":"#DIV/0!"}}]
["Slam Shut Valve (SSV) - Both Streams",2.21,{"$f":"'Inputs (Stream Selection)'!E21","v":0.2},{"$f":"C6/$C$14","v":{"$error":"#DIV/0!"}},null,null,null,"Slam Shut Valve (SSV)",2.2799999999999998,{"$f":"'Inputs (No Stream Selection)'!E22","v":0.2},{"$f":"J6/$J$14","v":{"$error":"#DIV/0!"}},2.5499999999999998,{"$f":"'Inputs (No Stream Selection)'!H22","v":0.2},{"$f":"M6/$J$14","v":{"$error":"#DIV/0!"}},null,"Slam Shut Valve (SSV)",7.7,{"$f":"'Inputs (No Stream Selection)'!E22","v":0.2},{"$f":"R6/$J$14","v":{"$error":"#DIV/0!"}},8.3000000000000007,{"$f":"'Inputs (No Stream Selection)'!H22","v":0.2},{"$f":"U6/$J$14","v":{"$error":"#DIV/0!"}}]
["Creep Relief (CR) - Both Streams",1.72,{"$f":"'Inputs (Stream Selection)'!E22","v":0.2},{"$error":"#DIV/0!"},null,null,null,"Creep Relief (CR) ",2.0699999999999998,{"$f":"'Inputs (No Stream Selection)'!E23","v":0.2},{"$error":"#DIV/0!"},2.0699999999999998,{"$f":"'Inputs (No Stream Selection)'!H23","v":0.2},{"$error":"#DIV/0!"},null,"Creep Relief (CR) ",7.45,{"$f":"'Inputs (No Stream Selection)'!E23","v":0.2},{"$error":"#DIV/0!"},7.45,{"$f":"'Inputs (No Stream Selection)'!H23","v":0.2},{"$error":"#DIV/0!"}]
["TD13 Temporary Operating Pressure (TOP)",null,{"$f":"'Inputs (Stream Selection)'!E23","v":0},{"$error":"#DIV/0!"},null,null,null,"TD13 Temporary Operating Pressure (TOP)",null,{"$f":"'Inputs (No Stream Selection)'!E24","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H24","v":0},{"$error":"#DIV/0!"},null,"TD13 Temporary Operating Pressure (TOP)",null,{"$f":"'Inputs (No Stream Selection)'!E24","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H24","v":0},{"$error":"#DIV/0!"}]
["Calculated TOP",null,{"$f":"'Inputs (Stream Selection)'!E24","v":0},{"$error":"#DIV/0!"},null,null,null,"Calculated TOP",null,{"$f":"'Inputs (No Stream Selection)'!E25","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H25","v":0},{"$error":"#DIV/0!"},null,"Calculated TOP",null,{"$f":"'Inputs (No Stream Selection)'!E25","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H25","v":0},{"$error":"#DIV/0!"}]
["Monitor Regulator (MR) - Both Streams",1.52,{"$f":"'Inputs (Stream Selection)'!E25","v":0},{"$error":"#DIV/0!"},null,null,null,"Monitor Regulator (MR) ",1.93,{"$f":"'Inputs (No Stream Selection)'!E26","v":0},{"$error":"#DIV/0!"},1.93,{"$f":"'Inputs (No Stream Selection)'!H26","v":0},{"$error":"#DIV/0!"},null,"Monitor Regulator (MR) ",7.25,{"$f":"'Inputs (No Stream Selection)'!E26","v":0},{"$error":"#DIV/0!"},7.25,{"$f":"'Inputs (No Stream Selection)'!H26","v":0},{"$error":"#DIV/0!"}]
["Lower Accuracy Level MR",null,{"$f":"'Inputs (Stream Selection)'!E26","v":0},{"$error":"#DIV/0!"},null,null,null,"Lower Accuracy Level MR",null,{"$f":"'Inputs (No Stream Selection)'!E27","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H27","v":0},{"$error":"#DIV/0!"},null,"Lower Accuracy Level MR",null,{"$f":"'Inputs (No Stream Selection)'!E27","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H27","v":0},{"$error":"#DIV/0!"}]
["TD13 Peak Level Operating Pressure (PLOP)",null,{"$f":"'Inputs (Stream Selection)'!E27","v":0},{"$error":"#DIV/0!"},null,null,null,"TD13 Peak Level Operating Pressure (PLOP)",null,{"$f":"'Inputs (No Stream Selection)'!E28","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H28","v":0},{"$error":"#DIV/0!"},null,"TD13 Peak Level Operating Pressure (PLOP)",null,{"$f":"'Inputs (No Stream Selection)'!E28","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H28","v":0},{"$error":"#DIV/0!"}]
["Calculated PLOP",null,{"$f":"'Inputs (Stream Selection)'!E28","v":0},{"$error":"#DIV/0!"},null,null,null,"Calculated PLOP",null,{"$f":"'Inputs (No Stream Selection)'!E29","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H29","v":0},{"$error":"#DIV/0!"},null,"Calculated PLOP",null,{"$f":"'Inputs (No Stream Selection)'!E29","v":0},{"$error":"#DIV/0!"},null,{"$f":"'Inputs (No Stream Selection)'!H29","v":0},{"$error":"#DIV/0!"}]
["Active Regulator (AR) - Working Stream",1.38,{"$f":"'Inputs (Stream Selection)'!E29","v":0},{"$error":"#DIV/0!"},null,null,null,"Active Regulator (AR) - Working Stream",1.72,{"$f":"'Inputs (No Stream Selection)'!E30","v":0},{"$f":"J14/$J$14","v":{"$error":"#DIV/0!"}},1.59,{"$f":"'Inputs (No Stream Selection)'!H30","v":0},{"$error":"#DIV/0!"},null,"Active Regulator (AR) - Working Stream",6.9,{"$f":"'Inputs (No Stream Selection)'!E30","v":0},{"$f":"R14/$J$14","v":{"$error":"#DIV/0!"}},6.55,{"$f":"'Inputs (No Stream Selection)'!H30","v":0},{"$error":"#DIV/0!"}]
["Active Regulator (AR) - Standby Stream",1.28,{"$f":"'Inputs (Stream Selection)'!E30","v":0},{"$error":"#DIV/0!"}]
[]
["1st Stage Pressure Setting",4.1399999999999997,null,null,null,null,null,"1st Stage Pressure Setting",6.9]
[]
["Existing settings taken from lotus notes database so may not be up to date",null,null,null,null,null,null,"Existing settings taken from lotus notes database so may not be up to date",null,null,null,null,null,null,null,"Existing settings taken from lotus notes database so may not be up to date"]
["Non Return Valves present in each stream so stream selection?",null,null,null,null,null,null,"Non Return Valves present in each stream so stream selection?",null,null,null,null,null,null,null,"No non return valves shown on ELD so assumed no stream selection"]
["Elster Axial Flow Regulator - AC is 5% (confirmed by manufacturer)",null,null,null,null,null,null,"Elster Axial Flow Regulator - AC is 5% (confirmed by manufacturer)",null,null,null,null,null,null,null,"Mooney Regulators installed - AC is 2.5% at < 40 barg and 1% at > 40 barg"]
["Tartarini BM5 Slam Shut - AG is 1% (confirmed by manufacturer)",null,null,null,null,null,null,"Tartarini BM5 Slam Shut - AG is 1% (confirmed by manufacturer)",null,null,null,null,null,null,null,"Don't know what the AG is so have assumed 1% as it is an offtake."]