{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary","RV Selection(Crit flow)","RV Selection (sub-crit)","RV Selection Liq cert","Spare"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":49,"comments":0,"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":"Summary","index":0,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[65,2,65,3],[65,6,65,7],[66,2,66,3],[65,4,65,5],[66,4,66,5],[66,6,66,7],[61,4,61,5],[62,2,62,5],[63,4,63,5],[64,4,64,5],[61,2,61,3],[63,2,63,3],[64,2,64,3],[66,8,66,9],[62,6,62,9],[61,6,61,7],[63,6,63,7],[64,6,64,7],[61,8,61,9],[63,8,63,9],[64,8,64,9],[65,8,65,9],[66,10,66,11],[65,12,65,13],[66,12,66,13],[65,10,65,11],[61,12,61,13],[62,10,62,13],[63,12,63,13],[64,12,64,13],[61,10,61,11],[63,10,63,11],[64,10,64,11],[66,14,66,15],[1,16,1,17],[61,16,61,17],[62,14,62,17],[63,16,63,17],[64,16,64,17],[65,16,65,17],[66,16,66,17],[61,14,61,15],[63,14,63,15],[64,14,64,15],[65,14,65,15],[1,20,1,21],[63,20,63,21],[64,20,64,21],[65,20,65,21],[66,20,66,21],[62,18,62,21],[61,18,61,19],[63,18,63,19],[64,18,64,19],[65,18,65,19],[66,18,66,19]]}
[null,null,"PROCESS CALCULATION",null,null,null,null,null,null,null,null,null,"Document No.",null,null,"PRxxxx"]
[null,null,"SUMMARY SHEET",null,null,null,null,null,null,null,null,null,"Sheet",null,null,1,"of",null,null,"Rev.",1]
[null,"  Job",null,null,null,null,null,null,null,null,null,null,"Item No. (s)"]
[null,"  Item Name / Subject"]
[]
[null,"   1.  OBJECTIVE"]
[]
[null,"To size suitable relief valves to protect",null,null,null,null,null,null,null,"from any possible overpressure"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"   2.  ASSUMPTIONS"]
[]
[]
[]
[]
[]
[]
[]
[null,"6.  The protected vessel will be built to ASME VIII codes ( based on vendor information)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"   3.  REFERENCES"]
[]
[null,"1.  API RP520 Part.1 "]
[null,"2.  Shell DEP 80.45.10.10-Gen"]
[null,"3.  Gas Processors Suppliers Assoc.,\"Engineering Data Book\""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"   4.  CONCLUSIONS"]
[]
[null,"The sizing calculation method chosen was",null,null,null,null,null,"API 520 Gas critical flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"API 520 Gas critical flow",null,null,null,1]
[null,"The only credible overpressure scenario was",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"API 520 Gas sub-critical flow",null,null,null,2]
[null,"The fire load was calculated as",null,null,null,null,null,"kg/h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"API 520 Liquid API certified",null,null,null,3]
[null,"The calculated relief area is",null,null,null,null,null,"mm2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-standard",null,null,null,4]
[null,"This required standard orifice(s) of"]
[]
[]
[]
[]
[null,null,1,null,"Date",null,2,null,"Date",null,3,null,"Date",null,4,null,"Date",null,5,null,"Date"]
[null,"Description"]
[null,"Made / Revised by","JG",null,"2003-12-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E64,I64,M64,Q64,U64)","v":"2003-12-08"}]
[null,"Checked by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E65,I65,M65,Q65,U65)","v":"00:00:00"}]
[null,"Approved Process",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E66,I66,M66,Q66,U66)","v":"00:00:00"}]
[null,"Approved"]

{"sheet":"RV Selection(Crit flow)","index":1,"n_rows":70,"n_cols":28,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,3,0,7],[0,1,0,2]]}
[null,"Project:"]
[null,"Calculations for:",null,"Divn/Dept:",null,"Job Nr/File No ."]
[null,null,null,"Calculated by:",null,"Date: ",null,"Sheet No.",null,null,null,null,null,null,null,null,null,null,null,null,"Std/Conv"]
[null,null,null,"Checked by: ",null,null,null,null,null,2,{"$f":"CHOOSE($J$4,1,645.16)","v":645.16},"in2",{"$f":"CHOOSE($J$4,F44,K24*F44)","v":0.26881132490629028},null,null,null,null,null,null,null,"B/Bellows"]
[null,null,null,null,null,null,null,null,null,null,"Units selection",null,"Overpress",null,null,null,null,null,null,null,"Pilot"]
[null,null,null,null,null,null,null,null,null,"USCust","lb/h,psig,F,in2",null,0.1]
[null,"Relief Valve : ",null,"Type","B/Bellows",null,{"$f":"IF(AND(E7=\"B/Bellows\",CHOOSE(UNITS,1,14.503773)*F13<=50),\"WARNING VALVE TYPE!\",\"\")","v":""},null,null,"SI units","kg/h,barg,C,mm2",null,0.16]
[null,"Case",null,null,null,null,null,null,null,null,null,null,0.21,null,"Standard Orifice tables"]
[null,null,null,null,null,null,null,null,null,"Units","Multiplier","Offset",{"$f":"CHOOSE(J4,\"SI value\",\"USCust value\")","v":"USCust value"}]
[null,"PSV  GAS/VAPOUR  SIZING CALCULATIONS",null,null,"USCust","Input values","Comments",null,null,null,null,null,null,1,2,null,1E-4,"1 D 2",0.11]
[null,"REQUIRED CAPACITY (W) =",null,null,{"$f":"CHOOSE(UNITS,\"lb/h\",\"kg/h\")","v":"kg/h"},10000,"API Example3.6.3.2",null,null,"Mass",{"$f":"CHOOSE($J$4,0.45359237,1/0.45359237)","v":2.2046226218487757},0,{"$f":"F11*K11+L11","v":22046.226218487758},2,null,null,0.11,"1 E 2",0.19600000000000001,null,"API RP520 Back pressure corrections"]
[null,"MOLECULAR WEIGHT (M) =",null,null,"-",29,null,null,null,"-",1,null,{"$f":"F12*K12+L12","v":29},3,null,null,0.19600000000000001,"1.5 F 2",0.307,null,"Standard Conventional or Pilot Operated"]
[null,"SET PRESSURE (Pset)  =",null,null,{"$f":"CHOOSE(UNITS,\"psig\",\"barg\")","v":"barg"},60,null,null,null,"Press",{"$f":"CHOOSE($J$4,0.068947573,1/0.068947573)","v":14.503773758649924},null,870.22642551899548,4,null,null,0.307,"2 G 3",0.503,null,null,"calc val","min val",null,0.1]
[null,"OVERPRESSURE =",null,null,"%",0.1,"ASME VIII non-fire single valve",null,null,"%",1,null,0.1,5,null,null,0.503,"2 H 3",0.78500000000000003,null,"rabs",{"$f":"(F16+F15)/(F13+F15)","v":0.53143345217073501},{"$f":"($Z$31+$Z$32*F18)/(1+$Z$33*F18+$Z$34*F18^2)","v":0.58679960269227682},null,"Rational Function: y=(a+bx)/(1+cx+dx^2)"]
[null,"ATMOS PRESSURE (Patm)=",null,null,{"$f":"CHOOSE(UNITS,\"psia\",\"bara\")","v":"bara"},14.6959,"ground level",null,null,"Press",{"$f":"CHOOSE($J$4,0.068947573,1/0.068947573)","v":14.503773758649924},0,213.14600877974343,6,null,null,0.78500000000000003,"3 J 4",1.2869999999999999,null,"k/(k-1)",{"$f":"F18/(F18-1)","v":12.111111111111102},null,null,"Coefficient Data:"]
[null,"BACK PRESSURE(Pback)",null,null,{"$f":"CHOOSE(UNITS,\"psig\",\"barg\")","v":"barg"},25,"incl built-up back P",null,null,"Press",{"$f":"CHOOSE($J$4,0.068947573,1/0.068947573)","v":14.503773758649924},null,362.59434396624812,7,null,null,1.2869999999999999,"3 K 6",1.8380000000000001,null,"1-r",{"$f":"1-V14","v":0.46856654782926499},null,null,"a =",-6.3614087000000004E-6]
[null,"TEMPERATURE (T) =",null,null,{"$f":"CHOOSE(UNITS,\"F\",\"C\")","v":"C"},120,null,null,null,"Temp",{"$f":"CHOOSE($J$4,1/1.8,1.8)","v":1.8},{"$f":"CHOOSE($J$4,-17.7777777777777,32)","v":32},248,8,null,null,1.8380000000000001,"4 L 6",2.8530000000000002,null,"sqrt term",{"$f":"V15*V14^(2/F18)*((1-V14^(1/V15))/V16)","v":0.41211529379275319},null,null,"b =",2.8934538999999999]
[null,"SPECIFIC HEAT RATIO (k) =",null,null,"-",1.0900000000000001,null,null,null,null,null,null,{"$f":"F24*K18+L18","v":0},9,null,null,2.8530000000000002,"4 M 6",3.6,null,"Ö",{"$f":"SQRT(V17)","v":0.64196206569606062},null,null,"c =",-4.3098540999999999]
[null,"COMPRESSIBILITY (z) =",null,null,"-",0.84,null,null,null,"-",1,null,{"$f":"F18*K19+L19","v":1.0900000000000001},10,null,null,3.6,"4 N 6",4.34,null,null,{"$f":"735*V18/F38","v":1.4497466422436391},null,null,"d =",12.934358]
[null,"COEFF. OF DISCHARGE (Kd) =",null,null,"-",0.97499999999999998,"API 520 rec.  No rupture disk",null,null,"-",1,null,{"$f":"F19*K20+L20","v":0.84},11,null,null,4.34,"4 P 6",6.3789999999999996,null,null,{"$f":"V19*SQRT(V16)","v":0.99237942515830246},5.3176120748199595E-4,null,0.16]
[null,"CAPACITY CORRECTION FACTOR (Kb)",null,null,"-",1,"input according to type",null,null,"-",1,null,{"$f":"F20*K21+L21","v":0.97499999999999998},12,null,null,6.3789999999999996,"6 Q 8",11.045,null,"Kb",{"$f":"IF(V14<W14,1,V20+W20)","v":1},null,null,"Rational Function: y=(a+bx)/(1+cx+dx^2)"]
[null,"COMBINATION CORRECTION FACTOR (Kc)",null,null,"-",1,null,null,null,"-",1,null,{"$f":"F21*K22+L22","v":1},13,null,null,11.045,"6 R 10",16,null,null,null,null,null,"Coefficient Data:"]
[null,"CONSTANT FOR CRIT.FLOW ORIF. AREA (Ccfoa)",null,null,{"$f":"CHOOSE(UNITS,\"US Cust\",\"SI units\")","v":"SI units"},{"$f":"CHOOSE(UNITS,1,131.6)","v":131.6},null,null,null,"-",1,null,{"$f":"F22*K23+L23","v":1},14,null,null,16,"8 T 10",26,null,"Balanced Bellows (critical flow only)",null,null,null,"a =",4.0102182000000001E-9]
[null,"CONST. FOR CONVERSION TO ABS. TEMP( Tcon )",null,null,{"$f":"CHOOSE(UNITS,\"F->R\",\"C->K\")","v":"C->K"},{"$f":"CHOOSE(UNITS,459.67,273.15)","v":273.14999999999998},null,null,null,"area",{"$f":"CHOOSE($J$4,25.4^2,1/(25.4^2))","v":1.5500031000062E-3},null,null,null,null,null,26,"Too big",null,null,"rgauge",{"$f":"F16/F13","v":0.41666666666666669},null,null,"b =",36.617888999999998]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"Kb10",{"$f":"AB34*IF(V24<0.29,1,($Z$16+$Z$17*V24)/(1+$Z$18*V24+$Z$19*V24^2))","v":0.83157650647509718},"for 10% OP",null,"c =",20.532222999999998]
[null,"Calculation formula for relieving pressure( P1 )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kb16",{"$f":"AB34*IF(V24<0.375,1,($Z$23+$Z$24*V24)/(1+$Z$25*V24+$Z$26*V24^2))","v":0.9680827602220482},"for 16% OP",null,"d =",35.743057999999998]
[null,null,null,"P1 = Pset * ( 1 + Overpressure) + Patm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kb21",{"$f":"AB34*1","v":1},"for all BP<50%"]
[null,"RELIEVING PRESSURE (P1) =",null,null,{"$f":"CHOOSE(UNITS,\"psia\",\"bara\")","v":"bara"},{"$f":"F13*(1+F14)+F15","v":80.695899999999995},{"$f":"+F28*14.5","v":1170.0905499999999},null,null,null,{"$f":"1/25.4^2","v":1.5500031000062E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,"rmax as function of k"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"25.4^2","v":645.16},null,null,null,null,null,null,null,null,null,null,null,null,null,"Rational Function: y=(a+bx)/(1+cx+dx^2)"]
[null,"Calculation formula for critical back pressure(Pcf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficient Data:"]
[null,null,null,"Pcf = P1 * [ 2 / (k+1) ] {k/(k-1)}",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a =",0.98903110000000005]
[null,"CRITICAL BACK PRESSURE(Pcf) =",null,null,{"$f":"CHOOSE(UNITS,\"psia\",\"bara\")","v":"bara"},{"$f":"F28*(2/(F18+1))^(F18/(F18-1))","v":47.351304929684119},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b =",0.12680632]
[null,"ACTUAL BACK PRESSURE(P2)",null,null,{"$f":"CHOOSE(UNITS,\"psia\",\"bara\")","v":"bara"},{"$f":"F16+F15","v":39.695900000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c =",0.78156751000000002]
[null,"Check if Critical Flow (P2 <= Pcf)",null,null,null,{"$f":"IF((F16+F15)<=F32,\"TRUE!\",\"FALSE!\")","v":"TRUE!"},{"$f":"IF(F34=\"FALSE!\",0,1)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d =",5.8164266999999999E-2,null,{"$f":"IF(F34=\"TRUE!\",1,0)","v":1}]
[null,"The following equations are valid for critical flow of Gas or Vapour only"]
[null,"Calculation formula for Sp. Ht. coefficient ( C )"]
[null,null,null,"C = 519.7 * Ö {(k)[2/ (k+1) ](k+1)/(k-1)}",null,null,"Ref. API 520 Fig.32"]
[null,"SP. HT COEFFICIENT (C) =",null,null,"-",{"$f":"519.7*((((2/(F18+1))^((F18+1)/(F18-1)))*F18)^0.5)","v":325.46522581102727}]
[]
[null,"Calculation formula for crit. flow. calc. orif. area (AGCF)"]
[null,null,"AGCF = ","Ccfoa * W * Ö [ ( Tabs) * z / M ]",null,null,"Ref.   API 520 Eq.3.2"]
[null,null,null,"P1 * C * Kd * Kb * Kc"]
[null,"Tabs = T + Tcon",null,null,{"$f":"CHOOSE(UNITS,\"R\",\"K\")","v":"K"},{"$f":"F17+F24","v":393.15}]
[null,"Calc. Area ( Acfoa) =",null,null,{"$f":"CHOOSE(UNITS,\"in²\",\"mm²\")","v":"mm²"},{"$f":"F23*G34*F11*SQRT((F43)*F19/F12)/F28/F38/F20/F21/F22","v":173.42631437654222}]
[]
[null,"Calculation formula for diameter (d)"]
[null,null,"  d = "," Ö  (4 * AG/ p )"]
[null,null,null,null,{"$f":"CHOOSE(UNITS,\"in\",\"mm\")","v":"mm"},{"$f":"SQRT(F44*4/PI())","v":14.859786053705006}]
[null,"Selection of no. off and API standard letter orifice"]
[null,"User choice of number",null,null,null,1,"Check overpressure"]
[null,"Selected API Orifice = ",null,null,null,{"$f":"CHOOSE($J$4,VLOOKUP(M4,orifices,2,TRUE),VLOOKUP(0.0015500031*F44/F50,orifices,2,TRUE))","v":"1.5 F 2"}]
[null,"Selected Orifice Area (Asel) = ",null,null,{"$f":"CHOOSE(UNITS,\"in²\",\"mm²\")","v":"mm²"},{"$f":"F50*CHOOSE(UNITS,1,645.16)*VLOOKUP(F51,orificesize,2,FALSE)","v":198.06411999999997}]
[null,null,null,"Non std orifice",{"$f":"CHOOSE(UNITS,\"in²\",\"mm²\")","v":"mm²"},5,{"$f":"IF((F53*F50)<F44,\"LESS THAN REQUIRED AREA!\",\"\")","v":"LESS THAN REQUIRED AREA!"}]
[null,"Calculation formula for rated flow =  Aselect / Acalc * W"]
[null,"Rated Flow per PSV = ",null,null,{"$f":"CHOOSE(UNITS,\"lb/h\",\"kg/h\")","v":"kg/h"},{"$f":"IF(ISBLANK(F53),F52/F44*F11,F53/F44*F11)","v":288.30688226147902}]
[]
[]
[null,"Conclusion :"]
[]
[null,"Relief valve selection table:"]
[null,"Ref: GPSA Engineering Data Book Fig. 5-7"]
[null,null,"Orifice","Area","Area","Orifice","Area","Area"]
[null,null,null,"in2","mm²",null,"in2","mm2"]
[null,null,{"$f":"INDEX(orificesize,N10,1)","v":"1 D 2"},{"$f":"INDEX(orificesize,N10,2)","v":0.11},71,{"$f":"INDEX(orificesize,$N17,1)","v":"4 L 6"},{"$f":"INDEX(orificesize,$N17,2)","v":2.8530000000000002},1841]
[null,null,"1 E 2",0.19600000000000001,125,"4 M 6",3.6,2323]
[null,null,"1.5 F 2",0.307,198,"4 N 6",4.34,2800]
[null,null,"2 G 3",0.503,325,"4 P 6",6.3789999999999996,4116]
[null,null,"2 H 3",0.78500000000000003,506,"6 Q 8",11.045,7129]
[null,null,"3 J 4",1.2869999999999999,830,"6 R 10",16,10323]
[null,null,"3 K 6",1.8380000000000001,1186,"8 T 10",26,16774]

{"sheet":"RV Selection (sub-crit)","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,3,0,7],[1,5,1,7],[2,1,3,2],[0,1,0,2],[2,5,2,6],[3,5,3,6],[1,3,1,4]]}
[null,"Project:\n"]
[null,"Calculations for:",null,"Divn/Dept",null,"Job Nr/File No."]
[null,null,null,"Calculated by:",null,"Date: ",null,"Sheet No."]
[null,null,null,"Checked by: ",null,"Date: "]
[]
[null,"Relief Valve : ",{"$f":"'RV Selection(Crit flow)'!C7","v":0}]
[null,"Case",{"$f":"'RV Selection(Crit flow)'!C8","v":0}]
[null,null,{"$f":"'RV Selection(Crit flow)'!C9","v":0}]
[null,null,null,null,{"$f":"CHOOSE('RV Selection(Crit flow)'!$J$4,\"USCust\",\"SI Units\")","v":"SI Units"},"Value","Comments"]
[null,{"$f":"'RV Selection(Crit flow)'!B11","v":"REQUIRED CAPACITY (W) ="},null,null,{"$f":"CHOOSE(UNITS,\"lb/h\",\"kg/h\")","v":"kg/h"},{"$f":"'RV Selection(Crit flow)'!F11","v":10000}]
[null,{"$f":"'RV Selection(Crit flow)'!B12","v":"MOLECULAR WEIGHT (M) ="},null,null,{"$f":"'RV Selection(Crit flow)'!E12","v":"-"},{"$f":"'RV Selection(Crit flow)'!F12","v":29}]
[null,{"$f":"'RV Selection(Crit flow)'!B13","v":"SET PRESSURE (Pset)  ="},null,null,{"$f":"CHOOSE(UNITS,\"psig\",\"barg\")","v":"barg"},{"$f":"'RV Selection(Crit flow)'!F13","v":60}]
[null,{"$f":"'RV Selection(Crit flow)'!B14","v":"OVERPRESSURE ="},null,null,"%",{"$f":"'RV Selection(Crit flow)'!F14","v":0.1}]
[null,{"$f":"'RV Selection(Crit flow)'!B15","v":"ATMOS PRESSURE (Patm)="},null,null,{"$f":"CHOOSE(UNITS,\"psia\",\"bara\")","v":"bara"},{"$f":"'RV Selection(Crit flow)'!F15","v":14.6959}]
[null,{"$f":"'RV Selection(Crit flow)'!B16","v":"BACK PRESSURE(Pback)"},null,null,{"$f":"CHOOSE(UNITS,\"psig\",\"barg\")","v":"barg"},{"$f":"'RV Selection(Crit flow)'!F16","v":25}]
[null,{"$f":"'RV Selection(Crit flow)'!B17","v":"TEMPERATURE (T) ="},null,null,{"$f":"CHOOSE(UNITS,\"F\",\"C\")","v":"C"},{"$f":"'RV Selection(Crit flow)'!F17","v":120}]
[null,{"$f":"'RV Selection(Crit flow)'!B18","v":"SPECIFIC HEAT RATIO (k) ="},null,null,{"$f":"'RV Selection(Crit flow)'!E18","v":"-"},{"$f":"'RV Selection(Crit flow)'!F18","v":1.0900000000000001}]
[null,{"$f":"'RV Selection(Crit flow)'!B19","v":"COMPRESSIBILITY (z) ="},null,null,{"$f":"'RV Selection(Crit flow)'!E19","v":"-"},{"$f":"'RV Selection(Crit flow)'!F19","v":0.84}]
[null,{"$f":"'RV Selection(Crit flow)'!B20","v":"COEFF. OF DISCHARGE (Kd) ="},null,null,{"$f":"'RV Selection(Crit flow)'!E20","v":"-"},{"$f":"'RV Selection(Crit flow)'!F20","v":0.97499999999999998}]
[null,{"$f":"'RV Selection(Crit flow)'!B21","v":"CAPACITY CORRECTION FACTOR (Kb)"},null,null,{"$f":"'RV Selection(Crit flow)'!E21","v":"-"},1]
[null,{"$f":"'RV Selection(Crit flow)'!B22","v":"COMBINATION CORRECTION FACTOR (Kc)"},null,null,{"$f":"'RV Selection(Crit flow)'!E22","v":"-"},{"$f":"'RV Selection(Crit flow)'!F22","v":1}]
[null,"CONSTANT FOR Sub crit. orif. area (Cscoa)",null,null,null,{"$f":"CHOOSE(UNITS,735,5.58659217877095)","v":5.5865921787709496}]
[null,{"$f":"'RV Selection(Crit flow)'!B24","v":"CONST. FOR CONVERSION TO ABS. TEMP( Tcon )"},null,null,{"$f":"CHOOSE(UNITS,\"F->R\",\"C->K\")","v":"C->K"},{"$f":"'RV Selection(Crit flow)'!F24","v":273.14999999999998}]
[null,"The following equations are valid for sub-critical flow of Gas or Vapour (std valves) only"]
[null,"RELIEVING PRESSURE (P1) =",null,null,{"$f":"CHOOSE(UNITS,\"psia\",\"bara\")","v":"bara"},{"$f":"F12*(1+F13)+F14","v":80.695899999999995}]
[null,"CRITICAL BACK PRESSURE(Pcf) =",null,null,{"$f":"CHOOSE(UNITS,\"psia\",\"bara\")","v":"bara"},{"$f":"'RV Selection(Crit flow)'!F32","v":47.351304929684119}]
[null,"ACTUAL BACK PRESSURE(P2)",null,null,{"$f":"CHOOSE(UNITS,\"psia\",\"bara\")","v":"bara"},{"$f":"F15+F14","v":39.695900000000002}]
[null,"Check for sub-criticality(P2 > Pcf)",null,null,null,{"$f":"IF('RV Selection(Crit flow)'!F34=\"TRUE!\",\"FALSE!\",\"TRUE!\")","v":"FALSE!"},{"$f":"IF(F28=\"TRUE!\",1,0)","v":0}]
[null,"Calculation for Subcritical Flow of Gas or Vapour",null,null,null,null,"API RP520 para 3.6.3"]
[]
[null,"Calculate coefficient (F2)"]
[null,"F2 = SQRT[ {k/(k-1)} * r2/k * {(1-r((k-1)/k)  / (1-r) } ]"]
[null,"k/(k-1)",null,null,"-",{"$f":"'RV Selection(Crit flow)'!F18/('RV Selection(Crit flow)'!F18-1)","v":12.111111111111102}]
[null,"(k-1)/k",null,null,"-",{"$f":"1/F33","v":8.2568807339449601E-2}]
[null,"2/k",null,null,"-",{"$f":"2/'RV Selection(Crit flow)'!F18","v":1.8348623853211008}]
[null,"r"," = P2 / P1",null,"-",{"$f":"F27/F25","v":0.49191966382430835}]
[null,"1-r",null,null,"-",{"$f":"1-F36","v":0.50808033617569159}]
[null,"F2",null,null,null,{"$f":"SQRT(F33*(F36^F35)*((1-(F36^F34))/F37))","v":0.60743075260298607}]
[]
[null,"Calculate required orifice area (AG)"]
[null,"AG ={ W / Cscoa / F2 / Kd / Kc } * SQRT [ Z * Tabs / M /  P1 / ( P1- P2) ]"]
[null,"Tabs = T + Tcon",null,null,{"$f":"CHOOSE(UNITS,\"R\",\"K\")","v":"K"},{"$f":"F16+F23","v":393.15}]
[null,"W / Cunit / F2 / Kd / Kc",null,null,null,{"$f":"F10/F38/F22/F19/F21","v":3022.3979079593455}]
[null,"Z * Tabs / M / P1 / (P1-P2)",null,null,null,{"$f":"F18*F42/F11/F25/(F25-F27)","v":3.4419475004754461E-3}]
[null,"Calc. Area (AG )",null,null,{"$f":"CHOOSE(UNITS,\"in2\",\"mm2\")","v":"mm2"},{"$f":"G28*F43*SQRT(F44)","v":0}]
[]
[null,"Calculation formula for diameter (d)"]
[null,null,"  d = "," Ö  (4 * AG/ p )"]
[null,null,null,null,{"$f":"CHOOSE(UNITS,\"in\",\"mm\")","v":"mm"},{"$f":"SQRT(F45*4/PI())","v":0}]
[null,"Selected Orifice = ",null,null,null,{"$f":"VLOOKUP(CHOOSE(UNITS,1,1/645.16)*F45,orifices,2,TRUE)","v":{"$error":"#N/A"}}]
[null,"Selected Orifice area (Asel) = ",null,null,{"$f":"CHOOSE(UNITS,\"in2\",\"mm2\")","v":"mm2"},{"$f":"VLOOKUP(F50,orificesize,2,FALSE)*CHOOSE(UNITS,1,645.16)","v":{"$error":"#N/A"}}]
[]
[null,"Calculation formula for rated flow =  Aselect / Acalc * W"]
[null,"Rated Flow per PSV = ",null,null,{"$f":"CHOOSE(UNITS,\"lb/h\",\"kg/h\")","v":"kg/h"},{"$f":"F51/F45*F10","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Conclusion :",{"$f":"CONCATENATE(\"As per Relief valve selection table:- \",F50,\" , to be considered\")","v":{"$error":"#N/A"}}]

{"sheet":"RV Selection Liq cert","index":3,"n_rows":72,"n_cols":16,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,3,0,7],[1,5,1,7],[2,1,3,2],[0,1,0,2],[2,5,2,6],[3,5,3,6],[1,3,1,4]]}
[null,"Project:"]
[null,"Calculations for:",null,"Divn/Dept",null,"Job Nr/File No"]
[null,null,null,"Calculated by:",null,"Date: ",null,"Sheet No."]
[null,null,null,"Checked by: ",null,"Date: "]
[]
[null,null,null,null,null,null,null,null,null,null,"Units selection"]
[null,"Relief Valve : ","API RP520 Examples",null,null,null,null,null,null,"USCust","Units selection"]
[null,"Case"," Work in progress",null,null,null,null,null,null,"SI"]
[]
[null,"PSV LIQUID CERTIFIED SIZING CALCULATIONS",null,null,"Units","Input values","Comments",1,null,null,"YES"]
[null,"REQUIRED CAPACITY (Q) =",null,null,{"$f":"CHOOSE($H$10,\"USgpm\",\"lit./min\")","v":"USgpm"},1800,null,null,null,null,"NO"]
[null,"SPECIFIC GRAVITY rel. water 60F(G) =",null,null,"-",0.9]
[null,"VISCOSITY OF FLUID AT RELIEF CONDITIONS ( Mu)",null,null,"cP",{"$f":"2800*F12*2000/12700","v":396.85039370078738},null,null,null,null,10]
[null,"SET PRESSURE (Pset)  =",null,null,{"$f":"CHOOSE(LIQUNITS,\"psig\",\"bar.g\")","v":"psig"},250,null,null,null,null,21]
[null,"OVERPRESSURE =",null,null,"%",0.1]
[null,"ATMOS PRESSURE (Patm)=",null,null,{"$f":"CHOOSE(LIQUNITS,\"psia\",\"bara\")","v":"psia"},14.7]
[null,"BACK PRESSURE(Pback)",null,null,{"$f":"CHOOSE(LIQUNITS,\"psig\",\"bar.g\")","v":"psig"},50]
[null,"COEFF. OF DISCHARGE (Kd) =",null,null,null,0.65,"API reccom. For RV w/o BD"]
[null,"CORRECTION FACTOR DUE TO BACK PRESSURE (Kw) =",null,null,null,0.97]
[null,"CORRECTION FACTOR FOR RUPTURE DISK (Kc) =",null,null,null,1]
[null,"CORRECTION FACTOR FOR VISCOSITY (Kv) =",null,null,"Init. Estimate",{"$f":"IF(F24<>\"YES\",1,F41)","v":0.96664215350581861}]
[null,"CONSTANT FOR ORIFICE AREA EQN.(Carea)=",null,null,null,{"$f":"CHOOSE(LIQUNITS,38,1/1.178)","v":38}]
[null,"CONSTANT FOR REYNOLDS No. EQN(CR)=",null,null,null,{"$f":"CHOOSE(LIQUNITS,2800,18800)","v":2800}]
[null,"ITERATE FOR Kv?",null,null,null,"YES"]
[]
[null,"Calculation formula for relieving pressure( P1 )"]
[null,null,"P1=","Pset * ( 1 + Overpressure) + Patm"]
[null,"RELIEVING PRESSURE (P1) =",null,null,{"$f":"CHOOSE(LIQUNITS,\"psia\",\"bara\")","v":"psia"},{"$f":"F14*(1+F15)+14.6959","v":289.69589999999999},{"$f":"+F28*14.5","v":4200.5905499999999}]
[null,"BACK PRESSURE(P2)=","P2=","Pback+Patm",{"$f":"CHOOSE(LIQUNITS,\"psia\",\"bara\")","v":"psia"},{"$f":"F17+F16","v":64.7}]
[null,"Calculation formula for required orifice area(AL)"]
[null,null,"AL = ","Q *Ö [G / ( P1- P2) ]",null,null,"ref:API RP 520 Pt.1 para.3.8.1.2"]
[null,null,null,"Carea * Kd * Kw * Kv"]
[null,"Required orifice area(AL) =",null,null,{"$f":"CHOOSE(LIQUNITS,\"in2\",\"mm2\")","v":"in2"},{"$f":"F11*SQRT((F12/(F28-F29)))/Carea/F18/F19/F20/F21","v":4.9155491189329483}]
[null,"Selected Orifice = ",null,null,null,{"$f":"CHOOSE(LIQUNITS,VLOOKUP(F33,orifices,2,TRUE),VLOOKUP(0.0015500031*F33,orifices,2,TRUE))","v":"4 P 6"}]
[null,"Selected Orifice Area (Asel) = ",null,"from table",{"$f":"CHOOSE(LIQUNITS,\"in2\",\"mm2\")","v":"in2"},{"$f":"CHOOSE(LIQUNITS,1,645.16)*VLOOKUP(F34,orificesize,2,FALSE)","v":6.3789999999999996}]
[]
[null,"Calculation formula for Reynolds number(R)"]
[null,null,"R = ","Q * CR * G / Mu / Ö Asel",null,{"$f":"F11*F23*F12/F13/SQRT(F33)","v":5155.3743960837901}]
[]
[null,"Calculation formula for Kv "]
[null,null,"Kv = ","[.9935+2.878/R0.5 + 342.75/R1.5]-1.0",null,{"$f":"1/(0.9935+2.878/SQRT(F38)+342.75/(F38^1.5))","v":0.96664215350581861}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Conclusion :",{"$f":"CONCATENATE(\"As per Relief valve selection table:- \",F34,\" , to be considered\")","v":"As per Relief valve selection table:- 4 P 6 , to be considered"}]
[]
[null,"Relief valve selection table:"]
[null,"============================="]
[null,"Ref: GPSA Engineering Data Book Fig. 5-7"]
[null,"Data:"]
[null,null,{"$f":"'RV Selection(Crit flow)'!C62","v":"Orifice"},{"$f":"'RV Selection(Crit flow)'!D62","v":"Area"},{"$f":"'RV Selection(Crit flow)'!E62","v":"Area"},{"$f":"'RV Selection(Crit flow)'!F62","v":"Orifice"},{"$f":"'RV Selection(Crit flow)'!G62","v":"Area"},{"$f":"'RV Selection(Crit flow)'!H62","v":"Area"},null,null,1,2,null,1E-4,"1 D 2",0.11]
[null,null,{"$f":"'RV Selection(Crit flow)'!C63","v":0},{"$f":"'RV Selection(Crit flow)'!D63","v":"in2"},{"$f":"'RV Selection(Crit flow)'!E63","v":"mm²"},{"$f":"'RV Selection(Crit flow)'!F63","v":0},{"$f":"'RV Selection(Crit flow)'!G63","v":"in2"},{"$f":"'RV Selection(Crit flow)'!H63","v":"mm2"},null,null,2,null,null,0.11,"1 E 2",0.19600000000000001]
[null,null,{"$f":"'RV Selection(Crit flow)'!C64","v":"1 D 2"},{"$f":"'RV Selection(Crit flow)'!D64","v":0.11},{"$f":"'RV Selection(Crit flow)'!E64","v":71},{"$f":"'RV Selection(Crit flow)'!F64","v":"4 L 6"},{"$f":"'RV Selection(Crit flow)'!G64","v":2.8530000000000002},{"$f":"'RV Selection(Crit flow)'!H64","v":1841},null,null,3,null,null,0.19600000000000001,"1.5 F 2",0.307]
[null,null,{"$f":"'RV Selection(Crit flow)'!C65","v":"1 E 2"},{"$f":"'RV Selection(Crit flow)'!D65","v":0.19600000000000001},{"$f":"'RV Selection(Crit flow)'!E65","v":125},{"$f":"'RV Selection(Crit flow)'!F65","v":"4 M 6"},{"$f":"'RV Selection(Crit flow)'!G65","v":3.6},{"$f":"'RV Selection(Crit flow)'!H65","v":2323},null,null,4,null,null,0.307,"2 G 3",0.503]
[null,null,{"$f":"'RV Selection(Crit flow)'!C66","v":"1.5 F 2"},{"$f":"'RV Selection(Crit flow)'!D66","v":0.307},{"$f":"'RV Selection(Crit flow)'!E66","v":198},{"$f":"'RV Selection(Crit flow)'!F66","v":"4 N 6"},{"$f":"'RV Selection(Crit flow)'!G66","v":4.34},{"$f":"'RV Selection(Crit flow)'!H66","v":2800},null,null,5,null,null,0.503,"2 H 3",0.78500000000000003]
[null,null,{"$f":"'RV Selection(Crit flow)'!C67","v":"2 G 3"},{"$f":"'RV Selection(Crit flow)'!D67","v":0.503},{"$f":"'RV Selection(Crit flow)'!E67","v":325},{"$f":"'RV Selection(Crit flow)'!F67","v":"4 P 6"},{"$f":"'RV Selection(Crit flow)'!G67","v":6.3789999999999996},{"$f":"'RV Selection(Crit flow)'!H67","v":4116},null,null,6,null,null,0.78500000000000003,"3 J 4",1.2869999999999999]
[null,null,{"$f":"'RV Selection(Crit flow)'!C68","v":"2 H 3"},{"$f":"'RV Selection(Crit flow)'!D68","v":0.78500000000000003},{"$f":"'RV Selection(Crit flow)'!E68","v":506},{"$f":"'RV Selection(Crit flow)'!F68","v":"6 Q 8"},{"$f":"'RV Selection(Crit flow)'!G68","v":11.045},{"$f":"'RV Selection(Crit flow)'!H68","v":7129},null,null,7,null,null,1.2869999999999999,"3 K 6",1.8380000000000001]
[null,null,{"$f":"'RV Selection(Crit flow)'!C69","v":"3 J 4"},{"$f":"'RV Selection(Crit flow)'!D69","v":1.2869999999999999},{"$f":"'RV Selection(Crit flow)'!E69","v":830},{"$f":"'RV Selection(Crit flow)'!F69","v":"6 R 10"},{"$f":"'RV Selection(Crit flow)'!G69","v":16},{"$f":"'RV Selection(Crit flow)'!H69","v":10323},null,null,8,null,null,1.8380000000000001,"4 L 6",2.8530000000000002]
[null,null,null,null,null,null,null,null,null,null,9,null,null,2.8530000000000002,"4 M 6",3.6]
[null,null,null,null,null,null,null,null,null,null,10,null,null,3.6,"4 N 6",4.34]
[null,null,null,null,null,null,null,null,null,null,11,null,null,4.34,"4 P 6",6.3789999999999996]
[null,null,null,null,null,null,null,null,null,null,12,null,null,6.3789999999999996,"6 Q 8",11.045]
[null,null,null,null,null,null,null,null,null,null,13,null,null,11.045,"6 R 10",16]
[null,null,null,null,null,null,null,null,null,null,14,null,null,16,"8 T 10",26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26,"Too big"]

{"sheet":"Spare","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}