{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":24,"comments":1,"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":"Sheet1","index":0,"n_rows":66,"n_cols":45,"rows_kept":66,"cut":false,"hidden":false,"merged":[[39,7,39,10],[45,7,45,10],[40,7,40,10],[41,7,41,10],[42,7,42,10],[43,7,43,10],[44,7,44,10],[34,7,34,10],[35,7,35,10],[36,7,36,10],[37,7,37,10],[38,7,38,10],[29,7,29,10],[30,7,30,10],[31,7,31,10],[32,7,32,10],[33,7,33,10],[24,7,24,10],[25,7,25,10],[26,7,26,10],[27,7,27,10],[28,7,28,10],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[14,7,14,10],[15,7,15,10],[16,7,16,10],[17,7,17,10],[18,7,18,10],[3,0,3,2],[11,7,11,10],[10,7,10,10],[13,7,13,10],[12,7,12,10]]}
["AMINE SOLUTION ANALYSIS VALIDATION TOOL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"MEA",61.082999999999998,105.092,null,"Use Measured"]
["Optimized Gas Treating, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"DEA",105.136,149.14500000000001,null,"Calculated"]
["ProTreat ™",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"MDEA",119.16,0]
["For information on how to use this calculator, visit: ",null,null,"http://www.ogtrt.com/contactor.cfm",null,null,null,"and read Vol_2 Issue_2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"DGA",105.136,149.14500000000001]
[]
["Company","Big Oil",null,null,null,null,null,null,null,"Sample Date","2010-09-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"DIPA",133.19,177.19900000000001]
["Site","Gulf Coast",null,null,null,null,null,null,null,"Lab","In-house",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Piperazine",86.137,130.14599999999999]
["Unit","TGU #2"]
[]
[]
["Parameter","Mole Weight","Analysis","Weight Fraction","Mole Fraction","Ion Charge","Mole Fr. Charge","Notes"]
["Amine","MDEA","wt%"]
["Free Amine",{"$f":"VLOOKUP(MATCH(AmineTypeUsed,AmineTypes,0),AN1:AP7,3)","v":119.16},42.8,{"$f":"C13/100","v":0.42799999999999999},{"$f":"D13/B13/$B$53","v":0.10272197590691888},null,null,"Also called Regenerable Free Base (RFB) and alkalinity"]
["Bound (AmineH+)",{"$f":"B13+1.008","v":120.16799999999999},0.6,{"$f":"C14/100","v":6.0000000000000001E-3},{"$f":"D14/B14/$B$53","v":1.427948378003092E-3},1,{"$f":"E14*F14","v":1.427948378003092E-3},"Titrated or backcalculated from Total - Free"]
["Total",null,{"$f":"C13+C14","v":43.4},{"$f":"SUM(D13:D14)","v":0.434},{"$f":"SUM(E13:E14)","v":0.10414992428492197},null,null,"Compare this figure to a GC or IC reading"]
["Strong Base Cations ",null,"ppmw"]
["Sodium (Na+)",22.99,243,{"$f":"C17/1000000","v":2.43E-4},{"$f":"D17/B17/$B$53","v":3.0228555362587904E-4},1,{"$f":"E17","v":3.0228555362587904E-4}]
["Potassium (K+)",39.097999999999999,0,{"$f":"C18/1000000","v":0},{"$f":"D18/B18/$B$53","v":0},1,{"$f":"E18","v":0}]
["Total Cations",{"$f":"D19/($B$53*E19)","v":22.99},{"$f":"SUM(C17:C18)","v":243},{"$f":"C19*0.000001","v":2.43E-4},{"$f":"SUM(E17:E18)","v":3.0228555362587904E-4},null,{"$f":"SUM(G17:G18)","v":3.0228555362587904E-4},"<2,000 ppmw (primary) and < 1,000 ppmw (TGU)"]
["Strong Acid Anions ",null,"ppmw"]
["Formate (HCOO−)",45.017000000000003,1561,{"$f":"C21/1000000","v":1.5610000000000001E-3},{"$f":"D21/B21/$B$53","v":9.9169116398165774E-4},-1,{"$f":"E21*F21","v":-9.9169116398165774E-4}]
["Acetate (CH3COO−)",59.043999999999997,409,4.0900000000000002E-4,1.9810599886339311E-4,-1,{"$f":"E22*F22","v":-1.9810599886339311E-4}]
["Glycolate (C2H3O3−)",75.044200000000004,0,{"$f":"C23/1000000","v":0},0,-1,0]
["Propionate (C2H5COO−)",74.078000000000003,0,{"$f":"C24/1000000","v":0},0,-1,0]
["Butyrate (C3H7COO−)",{"$f":"4*12.011+7*1.008+2*15.9994","v":87.098799999999997},0,{"$f":"C25/1000000","v":0},0,-1,0]
["Oxalate (C2O4=)",88.019000000000005,9,9.0000000000000002E-6,2.9242612507732792E-6,-2,-5.8485225015465584E-6]
["Lactate (C3H5O3-)",89.070999999999998,0,0,0,-1,0]
["Phosphate (PO4−3)",98.004000000000005,0,0,0,-3,0]
["Chloride (Cl−)",35.453000000000003,133,1.3300000000000001E-4,1.0728740488105118E-4,-1,-1.0728740488105118E-4,"Limits for stainless may be needed if H2S isn't processed"]
["Sulfate (SO4=)",96.061000000000007,19,1.9000000000000001E-5,5.6566145696825188E-6,-2,-1.1313229139365038E-5]
["Sulfite (SO3−)",{"$f":"32.064+3*15.9994","v":80.06219999999999},0,0,0,-1,0]
["Thiosulfate (S2O3=)",112.127,129,1.2899999999999999E-4,3.2902553040653221E-5,-2,-6.5805106081306443E-5]
["Thiocyanate (SCN−)",58.082999999999998,79,7.8999999999999996E-5,3.8898077906737389E-5,-1,-3.8898077906737389E-5]
["Total Anions",{"$f":"D34/($B$53*E34)","v":48.562317110228534},{"$f":"SUM(C21:C33)","v":2339},{"$f":"C34*0.000001","v":2.3389999999999999E-3},{"$f":"SUM(E21:E33)","v":1.3774660744939485E-3},null,{"$f":"SUM(G21:G33)","v":-1.4189495033550574E-3},"< 8,000 - 10,000 ppmw for reasonable corrosion rates"]
["Acid Gases",null,"wt%"]
["H2S (measured)",{"$f":"32.064+2*1.008","v":34.08},4.9000000000000002E-2,{"$f":"C36/100","v":4.8999999999999998E-4},{"$f":"D36/B36/$B$53","v":4.1119382500517905E-4},-1,{"$f":"E36*F36","v":-4.1119382500517905E-4}]
["CO2 (measured)",{"$f":"12.011+2*15.9994","v":44.009799999999998},0,{"$f":"C37/100","v":0},{"$f":"D37/B37/$B$53","v":0},-1,{"$f":"E37*F37","v":0}]
["Total acid gas (measured)",{"$f":"IF(C38>0,C38/(C36/B36+C37/B37),(B36+B37)/2)","v":34.08},{"$f":"C36+C37","v":4.9000000000000002E-2},{"$f":"C38/100","v":4.8999999999999998E-4},{"$f":"D38/B38/$B$53","v":4.1119382500517905E-4},-1,-4.1119382500517905E-4]
["Total acid gas as HS- (charge balance)",33.064999999999998,{"$f":"BisulfideWtFr*100","v":3.5989936615238791E-2},3.5989936615238793E-4,{"$f":"D39/B39/$B$53","v":3.1128819050007048E-4},-1,-3.1128819050007048E-4]
["Degradation Products",null,"wt%"]
["Bicine",163.17400000000001,0,{"$f":"C41/100","v":0},{"$f":"IF(B41>0,D41/B41/$B$53,0)","v":0},0,{"$f":"E41*F41","v":0}]
["Product 2",0,0,{"$f":"C42/100","v":0},{"$f":"IF(B42>0,D42/B42/$B$53,0)","v":0},0,{"$f":"E42*F42","v":0}]
["Product 3",0,0,0,0,0,0]
["Product 4",0,0,0,0,0,0]
["Product 4",0,0,0,0,0,0]
["Product 5",0,0,0,0,0,0]
["Water (H2O)",null,"wt%",null,null,null,null,"Water Option"]
["Measured water content",18.015000000000001,55,0.55000000000000004,0.87312920139079975,null,null,"Calculated"]
["Water content by balance (H2O)",18.015000000000001,{"$f":"D49*100","v":56.305810063384776},{"$f":"1-SUM(D13,D14,D17:D18,D21:D33,D39,D41:D46)","v":0.56305810063384776},{"$f":"D49/B49/$B$53","v":0.89385903589645821},null,null,"Acid Gas Option"]
["Total",{"$f":"1/B53","v":28.59895011464592},{"$f":"100*D50","v":100},{"$f":"SUM(D13:D14,D17:D18,D21:D33,D41:D46)+IF(H48=\"Calculated\",D49,D48)+IF(H50=\"Calculated\",BisulfideWtFr,D38)","v":1},{"$f":"SUM(E13:E14,E17:E18,E21:E33,E41:E46)+IF(H48=\"Calculated\",E49,E48)+IF(H50=\"Calculated\",E39,E38)","v":1},null,{"$f":"SUM(G14,G19,G34,G39,G41:G46)","v":-3.7622261567509148E-9},"Calculated"]
[]
["Other Calculations","Calculation status",null,{"$f":"IF(ABS(G50)>0.0000005,\"Not converged\", \"Converged\")","v":"Converged"}]
["Total gmoles per g solution",{"$f":"D13/B13+D14/B14+D17/B17+D18/B18+D21/B21+D22/B22+D23/B23+D24/B24+D26/B26+D28/B28+D29/B29+D30/B30+D31/B31+D32/B32+D33/B33+IF(H50=\"Calculated\",D39/B39,IF(B36>0,D36/B36,0)+IF(B37>0,D37/B37,0))+IF(H48=\"Calculated\",D49/B49,D48/B48)+IF(B41>0,D41/B41,0)+IF(B42>0,D42/B42,0)+IF(B43>0,D43/B43,0)+IF(B44>0,D44/B44,0)+IF(B45>0,D45/B45,0)+IF(B46>0,D46/B46,0)","v":3.4966318553347385E-2},null,null,null,{"$f":"IF(AmineTypeUsed<>\"MDEA\", \"Warning: charge balance may be invalid if significant CO2 loading exists.\",\"\")","v":""}]
["Charge balanced total acid gas loading",{"$f":"E39/E15","v":2.9888470168109036E-3},"mol/mol amine"]
[]
["Measured Acid Gas Loadings","mol/mol free\namine","mol/mol total amine"]
["H2S",{"$f":"E36/E13","v":4.0029781492694491E-3},{"$f":"E36/E15","v":3.9480952850266121E-3}]
["CO2",{"$f":"E37/E13","v":0},{"$f":"E37/E15","v":0}]
["Total",{"$f":"SUM(B57:B58)","v":4.0029781492694491E-3},{"$f":"SUM(C57:C58)","v":3.9480952850266121E-3}]
["Charge balanced Total",{"$f":"E39/E13","v":3.0303952757114315E-3},{"$f":"E39/E15","v":2.9888470168109036E-3},null,"For a \"perfect\" analysis, these should be in agreement"]
[]
["Residue (= 100 - Free Amine - Water)",{"$f":"100-C13-C48","v":2.2000000000000028},"%wt of solution"]
["Solvent recovery",{"$f":"C15+0.0001*SUM(C17:C18,C21:C33)+C38+SUM(C41:C46)+C48","v":98.7072},"%wt"]
["Percent of amine bound with HSS",{"$f":"(ABS(SUM(G21:G33))-SUM(G17:G18))/E15*100","v":1.0721697182172993}]
["Percent HSS anions neutralized",{"$f":"ABS(G19/G34)*100","v":21.303475064555517},"avoid overneutralization (>100%) for performance reasons, analytical interferences, and solids precipitation risks"]
["Heat stable amine salts (HSAS)",{"$f":"B64/100*C15","v":0.46532165770630796},"%wt of solution expressed as amine (can also be measured by titration)"]