{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["XSV-Calc Horizontal","XSV-Calc Vertical"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"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":"XSV-Calc Horizontal","index":0,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[52,7,52,9],[53,7,53,9],[51,1,53,2],[51,3,51,6],[52,3,52,6],[53,3,53,6],[7,7,7,9],[2,7,6,9],[51,7,51,9],[47,2,47,7],[48,2,48,7],[49,2,49,7],[50,2,50,7],[12,3,12,6],[13,3,13,6],[14,3,14,6],[15,3,15,6]]}
[]
[]
[null,"Rev","Description","By","Chkd","Appd","Date"]
[null,0,"First Issue","ABC",null,null,"2012-11-10"]
[null,1]
[null,2]
[null,3]
[null,4,null,null,null,null,null,"Process Calculation Sheet"]
[null,"V-12A"]
[]
[null,null,"XSV-Calc","Vessel Partial Volume Calculator"]
[]
[null,null,"Project Name","Test Project"]
[null,null,"Customer","ABC Inc"]
[null,null,"Vessel Name","Surge Drum"]
[null,null,"Tag No","V-001"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2:1 Elliptical","2:1 Elliptical","2:1 Elliptical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Flat","Flat"]
[null,null,"Case",null,"A","B","C",null,null,null,null,null,null,null,null,{"$f":"E19","v":"A"},{"$f":"F19","v":"B"},"C"]
[null,null,"Vessel Internal Diameter, D","mm",1416,1422,2000]
[null,null,"Vessel Length T/T, L","mm",4013,4013,7000,null,null,null,null,null,null,null,null,{"$f":"E20/1000","v":1.4159999999999999},{"$f":"F20/1000","v":1.4219999999999999},2]
[null,null,"Height of Fluid, h","mm",660,660,1200,null,null,null,null,null,null,null,null,{"$f":"E21/1000","v":4.0129999999999999},4.0129999999999999,7]
[]
[null,null,"Type of Vessel Head","Select","2:1 Elliptical","2:1 Elliptical","Flat",null,null,null,null,null,null,null,null,{"$f":"IF(E24=P17,0.25*E20/1000,0)","v":0.35399999999999998},{"$f":"IF(F24=Q17,0.25*F20/1000,0)","v":0.35549999999999998},0]
[null,null,"Head Depth, a","mm",{"$f":"P24*1000","v":354},{"$f":"Q24*1000","v":355.5},{"$f":"R24*1000","v":0},null,null,null,null,null,null,null,null,{"$f":"E22/1000","v":0.66},{"$f":"F22/1000","v":0.66},1.2]
[]
[null,null,"Volume below Level h (Liquid)","m3",{"$f":"P39","v":3.221132669049513},{"$f":"Q39","v":3.2317853015439417},{"$f":"R39","v":13.776793989055172}]
[null,null,"Volume above Level h (Gas)","m3",{"$f":"E29-E27","v":3.8416986710425038},{"$f":"F29-F27","v":3.894203633937344},{"$f":"G29-G27","v":8.2143545860733802}]
[null,null,"Total Vessel Volume","m3",{"$f":"P44","v":7.0628313400920169},{"$f":"Q44","v":7.1259889354812858},{"$f":"R44","v":21.991148575128552}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R = D/2",{"$f":"P21/2","v":0.70799999999999996},{"$f":"Q21/2","v":0.71099999999999997},1]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To H","To H","To H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Af = R2 * cos-1((R-h)/R) - (R-h)*sqrt(2*R*h-h2)",{"$f":"P32^2*(ACOS((P32-P25)/P32))-((P32-P25)*SQRT(2*P32*P25-P25^2))","v":0.71946775370869853},{"$f":"Q32^2*(ACOS((Q32-Q25)/Q32))-((Q32-Q25)*SQRT(2*Q32*Q25-Q25^2))","v":0.72161076787629708},1.9681134270078817]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vf = Af*L + PI*a*h2 * (1-(h/(3R)))",{"$f":" P37*P22+ PI()*P24*P25^2 * (1-(P25/(3*P32)))","v":3.221132669049513},{"$f":" Q37*Q22+ PI()*Q24*Q25^2 * (1-(Q25/(3*Q32)))","v":3.2317853015439417},13.776793989055172]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100% Full","100% Full","100% Full"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P32^2*(ACOS((P32-P21)/P32))-((P32-P21)*SQRT(2*P32*P21-P21^2))","v":1.5747672999090339},{"$f":"Q32^2*(ACOS((Q32-Q21)/Q32))-((Q32-Q21)*SQRT(2*Q32*Q21-Q21^2))","v":1.5881410598353658},3.1415926535897931]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" P42*P22+ PI()*P24*P21^2 * (1-(P21/(3*P32)))","v":7.0628313400920169},{"$f":" Q42*Q22+ PI()*Q24*Q21^2 * (1-(Q21/(3*Q32)))","v":7.1259889354812858},21.991148575128552]
[]
[]
[null,null,"Notes"]
[null,"1)"]
[null,"2)"]
[null,"3)"]
[null,"4)"]
[null,"THIS DOCUMENT IS ISSUED AS PRELIMINARY DESIGN INFORMATION ONLY AND NO LIABILITY IS ACCEPTED OR IMPLIED FOR ACCURACY. ALL DATA SHOULD BE CHECKED AND VERIFIED BY QUALIFIED PERSONNEL. ©KIRK PROCESS SOLUTIONS LIMITED  WWW.KIRKPROCESS.COM",null,"Document Title",null,null,null,"Document No."]
[null,null,null,"Volume Calculations for",null,null,null,"ABC-12345"]
[null,null,null,"Horizontal  Drum",null,null,null,"Sheet 1 of 1"]

{"sheet":"XSV-Calc Vertical","index":1,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,7,55,9],[49,2,49,7],[50,2,50,7],[51,2,51,7],[52,2,52,7],[53,1,55,2],[53,3,53,6],[53,7,53,9],[54,3,54,6],[54,7,54,9],[55,3,55,6],[15,3,15,6],[2,7,6,9],[7,7,7,9],[12,3,12,6],[13,3,13,6],[14,3,14,6]]}
[]
[]
[null,"Rev","Description","By","Chkd","Appd","Date"]
[null,0,"First Issue","ABC",null,null,"2012-11-10"]
[null,1]
[null,2]
[null,3]
[null,4,null,null,null,null,null,"Process Calculation Sheet"]
[null,"V-10A"]
[]
[null,null,"XSV-Calc","Vessel Partial Volume Calculator"]
[]
[null,null,"Project Name","Test Project"]
[null,null,"Customer","ABC Inc"]
[null,null,"Vessel Name","Surge Drum"]
[null,null,"Tag No","V-001"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2:1 Elliptical","2:1 Elliptical","2:1 Elliptical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Flat","Flat"]
[null,null,"Case",null,"A","B","C",null,null,null,null,null,null,null,null,{"$f":"E19","v":"A"},{"$f":"F19","v":"B"},"C"]
[null,null,"Vessel Internal Diameter, D","mm",2250,2000,2000]
[null,null,"Vessel Height T/T, H","mm",3250,5000,5000,null,null,null,null,null,null,null,null,{"$f":"E20/1000","v":2.25},{"$f":"F20/1000","v":2},2]
[null,null,"Height of Fluid above T/L, h","mm",0,2500,2500,null,null,null,null,null,null,null,null,{"$f":"E21/1000","v":3.25},5,5]
[]
[null,null,"Type of Vessel Head","Select","2:1 Elliptical","2:1 Elliptical","Flat",null,null,null,null,null,null,null,null,{"$f":"IF(E24=P17,0.25*E20/1000,0)","v":0.5625},{"$f":"IF(F24=Q17,0.25*F20/1000,0)","v":0.5},0]
[null,null,"Head Depth, a","mm",{"$f":"P24*1000","v":562.5},{"$f":"Q24*1000","v":500},{"$f":"R24*1000","v":0},null,null,null,null,null,null,null,null,{"$f":"E22/1000","v":0},{"$f":"F22/1000","v":2.5},2.5]
[]
[null,null,"Volume of Liquid to h","m3",{"$f":"P39","v":1.4921718750000001},{"$f":"Q39","v":8.9019816339744828},{"$f":"R39","v":7.8539816339744828}]
[null,null,"Volume of Gas above h","m3",{"$f":"E29-E27","v":14.414426032148642},{"$f":"F29-F27","v":8.9019816339744828},{"$f":"G29-G27","v":7.8539816339744828}]
[null,null,"Total Vessel Volume incl 2 Heads","m3",{"$f":"P44","v":15.906597907148642},{"$f":"Q44","v":17.803963267948966},{"$f":"R44","v":15.707963267948966},null,null,null,null,null,null,null,"R = D/2",{"$f":"P21/2","v":1.125},{"$f":"Q21/2","v":1},{"$f":"R21/2","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area",{"$f":"PI()*P29^2","v":3.9760782021995817},{"$f":"PI()*Q29^2","v":3.1415926535897931},{"$f":"PI()*R29^2","v":3.1415926535897931}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vol 1 head = 0.131*D^3",{"$f":"IF(E24=P17,0.131*P21^3,0)","v":1.4921718750000001},{"$f":"IF(F24=Q17,0.131*Q21^3,0)","v":1.048},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vol 2 heads",{"$f":"P32*2","v":2.9843437500000003},{"$f":"Q32*2","v":2.0960000000000001},0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To H","To H","To H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vol in Body = Area x Ht",{"$f":"P30*P25","v":0},{"$f":"Q30*Q25","v":7.8539816339744828},{"$f":"R30*R25","v":7.8539816339744828}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vol to h incl 1 head",{"$f":"P37+P32","v":1.4921718750000001},{"$f":"Q37+Q32","v":8.9019816339744828},{"$f":"R37+R32","v":7.8539816339744828}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100% Full","100% Full","100% Full"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Body",{"$f":"P30*P22","v":12.922254157148641},{"$f":"Q30*Q22","v":15.707963267948966},{"$f":"R30*R22","v":15.707963267948966}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total body + heads",{"$f":"P42+P33","v":15.906597907148642},{"$f":"Q42+Q33","v":17.803963267948966},{"$f":"R42+R33","v":15.707963267948966}]
[]
[]
[]
[]
[null,null,"Notes"]
[null,"1)"]
[null,"2)"]
[null,"3)"]
[null,"4)"]
[null,"THIS DOCUMENT IS ISSUED AS PRELIMINARY DESIGN INFORMATION ONLY AND NO LIABILITY IS ACCEPTED OR IMPLIED FOR ACCURACY. ALL DATA SHOULD BE CHECKED AND VERIFIED BY QUALIFIED PERSONNEL. ©KIRK PROCESS SOLUTIONS LIMITED.    WWW.KIRKPROCESS.COM",null,"Document Title",null,null,null,"Document No."]
[null,null,null,"Volume Calculations for",null,null,null,"ABC-12345"]
[null,null,null,"Vertical  Drum",null,null,null,"Sheet 1 of 1"]