{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Controller","Components","Configuration","Input","Report","Results Summary","parameters","log"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":45,"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":"Controller","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[]
[]
[null,"Excel/Webservice CHARM integration example for Demonstration and Client Evaluation"]
[]
[null,"User ID:","demo"]
[null,"Password:","demopwd"]
[]
[null,"After Execution Show:","Results Summary"]
[]
[]
[]
[]
[null,null,"Completed sucessfully"]

{"sheet":"Components","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Component constants"]
[]
[null,"Component","Flash Acentric Factor","Critical Pressure (Pa)","Critical Temperature (K)","Mol. Weight","COSTALD Accentric Factor (SRK)","Characteristic Volume"]
[null,"C1",1.15E-2,4640680,190.7,16.04,7.4000000000000003E-3,9.9400000000000002E-2]
[null,"C2",9.8599999999999993E-2,4883850,305.39999999999998,30.07,9.8299999999999998E-2,0.14580000000000001]
[null,"C3",0.15240000000000001,4256660,369.9,44.1,0.1532,0.2001]
[null,"C4plus",0.30070000000000002,3031620,507.9,86.18,0.30070000000000002,0.36820000000000003]
[null,"N2",0.04,3394370,126.2,28.01,3.5799999999999998E-2,9.01E-2]
[null,"CO2",0.2389,7370000,304.10000000000002,44.01,0.23730000000000001,9.3799999999999994E-2]
[]
[]
[null,"Binary interaction parameters"]
[]
[null,null,"CO2","N2","C4plus","C3","C2","C1"]
[null,"C1",0.10000000149011599,3.5999000072479199E-2,2.34741177409887E-2,6.82880263775587E-3,2.2413488477468499E-3]
[null,"C2",0.12980000674724601,5.0000000745058101E-2,1.1413777247071299E-2,1.2579060858115599E-3]
[null,"C3",0.135000005364418,7.9998001456260695E-2,5.1419534720480399E-3]
[null,"C4plus",0.125,0.149000003933907]
[null,"N2",-1.9997000694274899E-2]

{"sheet":"Configuration","index":2,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,1,6,4],[6,5,6,6],[6,7,6,9]]}
[]
[null,"Object configuration"]
[null,"Leave a blank row between each object"]
[]
[null,"Name:","DEMO-EXCEL"]
[]
[null,"Object",null,null,null,"Inputs",null,"Outputs"]
[null,"ID","Order","Water","Type","ID","In?","ID","Type","Out?"]
[null,"S1",10,"Y","Separator","wellA","Y","S1-V","V","N"]
[null,null,null,null,null,"wellA2","Y","S1-L","L","N"]
[null,null,null,null,null,"wellA3","Y"]
[]
[null,"S2",20,"Y","Separator","S1-V","N","S2-V","V","N"]
[null,null,null,null,null,null,null,"S2-L","L","N"]
[]
[null,"S3",30,"Y","Separator","S1-L","N","S3-V","V","N"]
[null,null,null,null,null,"S2-L","N","S3-L","L","Y"]
[null,null,null,null,null,"wellB","Y"]
[]
[null,"M1",40,null,"Mixer","S2-V","N","M1-V","V","N"]
[null,null,null,null,null,"S3-V","N"]
[]
[null,"T1",50,null,"Tee","M1-V","N","InjGas","V","Y"]
[null,null,null,null,null,null,null,"ExpGas","V","Y"]

{"sheet":"Input","index":3,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[[15,1,16,1],[33,2,33,3],[33,4,33,6]]}
[]
[null,"ID:",{"$f":"name","v":"DEMO-EXCEL"}]
[]
[null,"Calculation settings"]
[]
[null,"Flash calc convergence","K-Factor convergence","Max iterations"]
[null,1E-4,1E-4,1000]
[]
[null,"Recycle calculation"]
[]
[null,"Recycle convergence","Max iterations"]
[null,1E-4,1000]
[]
[null,"Allocation method"]
[]
[null,"Method","Groups"]
[null,null,"Group A","Group B","Group C"]
[null,"ClonedComponent","wellA","wellB","wellA3"]
[null,null,"wellA2"]
[]
[]
[null,"Units"]
[]
[null,"Unit name"]
[null,"mass"]
[]
[null,"Output settings"]
[]
[null,"Full Info?"]
[null,"N"]
[]
[null,"Object Data"]
[]
[null,null,"Seperators / Scrubbers",null,"Tees"]
[null,"Object ID","Temperature (K)","Pressure (Pa)","Stream","Split","Tee Unit"]
[null,"S1",318.3,6000000]
[null,"S2",316.60000000000002,6500000]
[null,"S3",304,7000000]
[null,"T1",null,null,"InjGas",0.2,"ratio"]
[]
[]
[null,"Input Streams (kg or kmol depending on unit)"]
[]
[null,null,"wellA","wellB","wellA2","wellA3"]
[null,"C1",32895,16548,38141,55938]
[null,"C2",24671,21640,26006,21515]
[null,"C3",16447,31823,25312,15491]
[null,"C4plus",37830,50915,27739,3657]
[null,"N2",9868,764,1387,430]
[null,"CO2",3289,3310,6415,27969]

{"sheet":"Report","index":4,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["CHARM Output"]
[]
["Error code:",0]
["Start time:","2016/06/13 16:00:34.809"]
["End time:","2016/06/13 16:00:34.829"]
["Version:",2]
["Temp Unit:","K"]
["Pressure Unit:","Pa"]
["Stream Unit:","kg","mass"]
[]
["****************************************************************************"]
["**** THE FOLLOWING RESULTS ARE AVAILABLE IN EXCEL RANGE: Report_Results"]
["**** THEY CAN BE ACCESSED USING VLOOKUP ETC"]
["****************************************************************************"]
[]
["Exported gas"]
["InjGas","Outlet: InjGas","Group A","Group B","Group C"]
["InjGas-Total Mass","Total Mass",37694.7538187151,1356.2449103955801,22977.444919325]
["InjGas-Total Moles","Total Moles",1490.0495464640701,59.718048972183198,994.11775384847897]
["InjGas-C1","C1",13842.598409948499,637.80751879359605,10900.4908758334]
["InjGas-C2","C2",9263.6957678683193,322.17160925778398,3932.91659817445]
["InjGas-C3","C3",6809.3363551797902,223.17608594510099,2526.0046811008401]
["InjGas-C4plus","C4plus",3700.4583699986702,39.622772852975103,206.38680259093701]
["InjGas-N2","N2",2230.6324674604498,52.955652443100398,85.221853488049405]
["InjGas-CO2","CO2",1848.0324482593101,80.511271103030893,5326.4241081373502]
[]
["ExpGas","Outlet: ExpGas","Group A","Group B","Group C"]
["ExpGas-Total Mass","Total Mass",150779.01527485999,5424.9796415823503,91909.779677300205]
["ExpGas-Total Moles","Total Moles",5960.1981858562904,238.87219588873299,3976.47101539391]
["ExpGas-C1","C1",55370.393639794202,2551.2300751743801,43601.963503333704]
["ExpGas-C2","C2",37054.783071473299,1288.68643703113,15731.6663926978]
["ExpGas-C3","C3",27237.345420719099,892.70434378040397,10104.0187244033]
["ExpGas-C4plus","C4plus",14801.833479994701,158.49109141189999,825.54721036374804]
["ExpGas-N2","N2",8922.5298698418192,211.82260977240099,340.88741395219699]
["ExpGas-CO2","CO2",7392.1297930372602,322.045084412123,21305.696432549401]
[]
["Exported oil"]
["S3-L","Stream:","S3-L","(Costald density = 517.612529032727)"]
[null,null,"Group A","Group B","Group C"]
["S3-L-Total Mass","Total Mass",61526.230906424302,118218.775448022,10112.775403374601]
["S3-L-Total Moles","Total Moles",993.80153775762994,2867.6291771953602,276.88548450693298]
["S3-L-C1","C1",1823.00795025712,13358.962406032,1435.5456208328501]
["S3-L-C2","C2",4358.5211606583598,20029.141953711001,1850.4170091277001]
["S3-L-C3","C3",7712.31822410103,30707.119570274499,2860.9765944957699]
["S3-L-C4plus","C4plus",47066.708150006598,50716.886135735098,2625.0659870453101]
["S3-L-N2","N2",101.837662697718,499.22173778449701,3.8907325597528901]
["S3-L-CO2","CO2",463.83775870340997,2907.4436444848402,1336.87945931323]

{"sheet":"Results Summary","index":5,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Results Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Group A","Group B","Group C"]
[null,null,null,null,null,null,null,null,null,null,null,null,"InjGas-Total Mass",{"$f":"VLOOKUP($M12,Report_Results,MATCH(N$11,INDEX(Report_Results,1,0),0),FALSE)","v":37694.7538187151},{"$f":"VLOOKUP($M12,Report_Results,MATCH(O$11,INDEX(Report_Results,1,0),0),FALSE)","v":1356.2449103955801},22977.444919325,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,"InjGas-Total Moles",1490.0495464640701,59.718048972183198,994.11775384847897,"kmol"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Group A","Group B","Group C"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ExpGas-Total Mass",{"$f":"VLOOKUP($M16,Report_Results,MATCH(N$15,INDEX(Report_Results,1,0),0),FALSE)","v":150779.01527485999},5424.9796415823503,91909.779677300205,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ExpGas-Total Moles",5960.1981858562904,238.87219588873299,3976.47101539391,"kmol"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Group A","Group B","Group C"]
[null,null,null,null,null,null,null,null,null,null,null,null,"S3-L-Total Mass",{"$f":"VLOOKUP($M23,Report_Results,MATCH(N$22,INDEX(Report_Results,1,0),0),FALSE)","v":61526.230906424302},118218.775448022,10112.775403374601,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,"S3-L-Total Moles",993.80153775762994,2867.6291771953602,276.88548450693298,"kmol"]
[]
[]
[null,"Group A",null,"Group B",null,"Group C"]
[null,"wellA",null,"wellA3",null,"wellB"]
[null,"wellA2",null,null,null,null,null,null,null,null,null,null,null,"Group A","Group B","Group C"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Mass",{"$f":"N12+N16+N23","v":249999.99999999942},124999.99999999993,124999.99999999981,"kg"]
[null,{"$f":"IF(units=\"mass\",\"kg\",\"kmol\")","v":"kg"},null,{"$f":"IF(units=\"mass\",\"kg\",\"kmol\")","v":"kg"},null,{"$f":"IF(units=\"mass\",\"kg\",\"kmol\")","v":"kg"},null,null,null,null,null,null,"Total Moles",8444.0492700779905,3166.2194220562765,5247.4742537493221,"kmol"]
[null,{"$f":"SUM(Input!C45:C50)+SUM(Input!E45:E50)","v":250000},null,{"$f":"SUM(Input!F45:F50)","v":125000},null,{"$f":"SUM(Input!D45:D50)","v":125000}]

{"sheet":"parameters","index":6,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["Allocation types"]
["NoAllocation"]
["ClonedComponent"]
[]
[]
["Control Parameters"]
["Parameters_Use_Prebuilt_Components",false,"leave as false - no real speed gain in prebuilding the XML for repeat runs"]
["Parameters_Use_Prebuilt_Configuration",false,"leave as false - no real speed gain in prebuilding the XML for repeat runs"]
["Parameters_ExcelDebug_Timing",false,"True outputs detailed timing data in the status messages"]
["Parameters_SwitchOffAppRecalc",true,"Set to true if linked to other spreadsheets. This  prevents them recalculating while each CHARM status messages is output. Auto recalculation is enabled after charm run"]
["Parameters_SwitchOffXMLLog",false,"With large numbers of parameters the XML log can cause out of memory issues in Excel.  This allows the log to be switched off."]
["Parameters_SaveDataInWebservice",false,"If true the CHARM webservice will save the input and result XML in its database - useful during setup. Generally this should false in production systems."]
[]
["Object types"]
["Separator"]
["Scrubber"]
["Tee"]
["Mixer"]
[]
["Units"]
["mass"]
["moles"]
[]
["Tee Units"]
["ratio"]
["mass"]
["moles"]
[]
["Worksheet to Show after run "]
["Controller (This Worksheet)"]
["Report (detailed)"]
["Results Summary"]

{"sheet":"log","index":7,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["ConstData:"," <constData><componentList><comp id=\"C1\"><molarWeight>16.040000000000000000000</molarWeight><tempCrit>190.700000000000000000000</tempCrit><pressCrit>4640680.000000000000000000000</pressCrit><acenFactPR>0.011500000000000000000</acenFactPR><acenFactSRK>0.007400000000000000000</acenFactSRK><charVolume>0.099400000000000000000</charVolume></comp><comp id=\"C2\"><molarWeight>30.070000000000000000000</molarWeight><tempCrit>305.400000000000000000000</tempCrit><pressCrit>4883850.000000000000000000000</pressCrit><acenFactPR>0.098600000000000000000</acenFactPR><acenFactSRK>0.098300000000000000000</acenFactSRK><charVolume>0.145800000000000000000</charVolume></comp><comp id=\"C3\"><molarWeight>44.100000000000000000000</molarWeight><tempCrit>369.900000000000000000000</tempCrit><pressCrit>4256660.000000000000000000000</pressCrit><acenFactPR>0.152400000000000000000</acenFactPR><acenFactSRK>0.153200000000000000000</acenFactSRK><charVolume>0.200100000000000000000</charVolume></comp><comp id=\"C4plus\"><molarWeight>86.180000000000000000000</molarWeight><tempCrit>507.900000000000000000000</tempCrit><pressCrit>3031620.000000000000000000000</pressCrit><acenFactPR>0.300700000000000000000</acenFactPR><acenFactSRK>0.300700000000000000000</acenFactSRK><charVolume>0.368200000000000000000</charVolume></comp><comp id=\"N2\"><molarWeight>28.010000000000000000000</molarWeight><tempCrit>126.200000000000000000000</tempCrit><pressCrit>3394370.000000000000000000000</pressCrit><acenFactPR>0.040000000000000000000</acenFactPR><acenFactSRK>0.035800000000000000000</acenFactSRK><charVolume>0.090100000000000000000</charVolume></comp><comp id=\"CO2\"><molarWeight>44.010000000000000000000</molarWeight><tempCrit>304.100000000000000000000</tempCrit><pressCrit>7370000.000000000000000000000</pressCrit><acenFactPR>0.238900000000000000000</acenFactPR><acenFactSRK>0.237300000000000000000</acenFactSRK><charVolume>0.093800000000000000000</charVolume></comp></componentList><binaryInterList><comp id=\"C1\"><to id=\"CO2\">0.100000001490116000000</to><to id=\"N2\">0.035999000072479200000</to><to id=\"C4plus\">0.023474117740988700000</to><to id=\"C3\">0.006828802637755870000</to><to id=\"C2\">0.002241348847746850000</to></comp><comp id=\"C2\"><to id=\"CO2\">0.129800006747246000000</to><to id=\"N2\">0.050000000745058100000</to><to id=\"C4plus\">0.011413777247071300000</to><to id=\"C3\">0.001257906085811560000</to></comp><comp id=\"C3\"><to id=\"CO2\">0.135000005364418000000</to><to id=\"N2\">0.079998001456260700000</to><to id=\"C4plus\">0.005141953472048040000</to></comp><comp id=\"C4plus\"><to id=\"CO2\">0.125000000000000000000</to><to id=\"N2\">0.149000003933907000000</to></comp><comp id=\"N2\"><to id=\"CO2\">-0.019997000694274900000</to></comp></binaryInterList></constData>\r\n"]
[]
["ConfigData:"," <configData id=\"DEMO-EXCEL\"><objectList><object id=\"S1\" order=\"10\" water=\"Y\" type=\"Separator\"><inlet><stream id=\"wellA\" in=\"Y\"/><stream id=\"wellA2\" in=\"Y\"/><stream id=\"wellA3\" in=\"Y\"/></inlet><outlet><stream id=\"S1-V\" type=\"V\" out=\"N\"/><stream id=\"S1-L\" type=\"L\" out=\"N\"/></outlet></object><object id=\"S2\" order=\"20\" water=\"Y\" type=\"Separator\"><inlet><stream id=\"S1-V\" in=\"N\"/></inlet><outlet><stream id=\"S2-V\" type=\"V\" out=\"N\"/><stream id=\"S2-L\" type=\"L\" out=\"N\"/></outlet></object><object id=\"S3\" order=\"30\" water=\"Y\" type=\"Separator\"><inlet><stream id=\"S1-L\" in=\"N\"/><stream id=\"S2-L\" in=\"N\"/><stream id=\"wellB\" in=\"Y\"/></inlet><outlet><stream id=\"S3-V\" type=\"V\" out=\"N\"/><stream id=\"S3-L\" type=\"L\" out=\"Y\"/></outlet></object><object id=\"M1\" order=\"40\" type=\"Mixer\"><inlet><stream id=\"S2-V\" in=\"N\"/><stream id=\"S3-V\" in=\"N\"/></inlet><outlet><stream id=\"M1-V\" type=\"V\" out=\"N\"/></outlet></object><object id=\"T1\" order=\"50\" type=\"Tee\"><inlet><stream id=\"M1-V\" in=\"N\"/></inlet><outlet><stream id=\"InjGas\" type=\"V\" out=\"Y\"/><stream id=\"ExpGas\" type=\"V\" out=\"Y\"/></outlet></object></objectList></configData>\r\n"]
[]
["InputData:"," <inputData id=\"DEMO-EXCEL\"><calcSettings><flashCalc><convFlash>0.0001</convFlash><convKFac>0.0001</convKFac><maxFlashIter>1000</maxFlashIter></flashCalc><recycleCalc><convRecycle>0.0001</convRecycle><maxRecycleIter>1000</maxRecycleIter></recycleCalc><allocMethod><type>ClonedComponent</type><groups><group id=\"Group A\"><stream>wellA</stream><stream>wellA2</stream></group><group id=\"Group B\"><stream>wellB</stream></group><group id=\"Group C\"><stream>wellA3</stream></group></groups></allocMethod></calcSettings><units><streamUnit><unitName>mass</unitName></streamUnit></units><outSettings><fullInfo>N</fullInfo></outSettings><objectList><object id=\"S1\"><temperature>318.3</temperature><pressure>6000000</pressure></object><object id=\"S2\"><temperature>316.6</temperature><pressure>6500000</pressure></object><object id=\"S3\"><temperature>304</temperature><pressure>7000000</pressure></object><object id=\"T1\" unitName=\"ratio\"><stream id=\"InjGas\">0.2</stream></object></objectList><streamList><stream id=\"wellA\"><comp id=\"C1\">32895</comp><comp id=\"C2\">24671</comp><comp id=\"C3\">16447</comp><comp id=\"C4plus\">37830</comp><comp id=\"N2\">9868</comp><comp id=\"CO2\">3289</comp></stream><stream id=\"wellB\"><comp id=\"C1\">16548</comp><comp id=\"C2\">21640</comp><comp id=\"C3\">31823</comp><comp id=\"C4plus\">50915</comp><comp id=\"N2\">764</comp><comp id=\"CO2\">3310</comp></stream><stream id=\"wellA2\"><comp id=\"C1\">38141</comp><comp id=\"C2\">26006</comp><comp id=\"C3\">25312</comp><comp id=\"C4plus\">27739</comp><comp id=\"N2\">1387</comp><comp id=\"CO2\">6415</comp></stream><stream id=\"wellA3\"><comp id=\"C1\">55938</comp><comp id=\"C2\">21515</comp><comp id=\"C3\">15491</comp><comp id=\"C4plus\">3657</comp><comp id=\"N2\">430</comp><comp id=\"CO2\">27969</comp></stream></streamList></inputData>\r\n"]
[]
["SOAP Request:"," *** truncated to 30000 chars *** <soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:char=\"http://charm.ws.accord.com/\"><soapenv:Header><char:authentication><user>demo</user><password>demopwd</password></char:authentication></soapenv:Header><soapenv:Body><char:runCharm><char:saveStatus><![CDATA[false]]></char:saveStatus><char:configXML><![CDATA[<configData id=\"DEMO-EXCEL\"><objectList><object id=\"S1\" order=\"10\" water=\"Y\" type=\"Separator\"><inlet><stream id=\"wellA\" in=\"Y\"/><stream id=\"wellA2\" in=\"Y\"/><stream id=\"wellA3\" in=\"Y\"/></inlet><outlet><stream id=\"S1-V\" type=\"V\" out=\"N\"/><stream id=\"S1-L\" type=\"L\" out=\"N\"/></outlet></object><object id=\"S2\" order=\"20\" water=\"Y\" type=\"Separator\"><inlet><stream id=\"S1-V\" in=\"N\"/></inlet><outlet><stream id=\"S2-V\" type=\"V\" out=\"N\"/><stream id=\"S2-L\" type=\"L\" out=\"N\"/></outlet></object><object id=\"S3\" order=\"30\" water=\"Y\" type=\"Separator\"><inlet><stream id=\"S1-L\" in=\"N\"/><stream id=\"S2-L\" in=\"N\"/><stream id=\"wellB\" in=\"Y\"/></inlet><outlet><stream id=\"S3-V\" type=\"V\" out=\"N\"/><stream id=\"S3-L\" type=\"L\" out=\"Y\"/></outlet></object><object id=\"M1\" order=\"40\" type=\"Mixer\"><inlet><stream id=\"S2-V\" in=\"N\"/><stream id=\"S3-V\" in=\"N\"/></inlet><outlet><stream id=\"M1-V\" type=\"V\" out=\"N\"/></outlet></object><object id=\"T1\" order=\"50\" type=\"Tee\"><inlet><stream id=\"M1-V\" in=\"N\"/></inlet><outlet><stream id=\"InjGas\" type=\"V\" out=\"Y\"/><stream id=\"ExpGas\" type=\"V\" out=\"Y\"/></outlet></object></objectList></configData>\r\n]]></char:configXML><char:constXML><![CDATA[<constData><componentList><comp id=\"C1\"><molarWeight>16.040000000000000000000</molarWeight><tempCrit>190.700000000000000000000</tempCrit><pressCrit>4640680.000000000000000000000</pressCrit><acenFactPR>0.011500000000000000000</acenFactPR><acenFactSRK>0.007400000000000000000</acenFactSRK><charVolume>0.099400000000000000000</charVolume></comp><comp id=\"C2\"><molarWeight>30.070000000000000000000</molarWeight><tempCrit>305.400000000000000000000</tempCrit><pressCrit>4883850.000000000000000000000</pressCrit><acenFactPR>0.098600000000000000000</acenFactPR><acenFactSRK>0.098300000000000000000</acenFactSRK><charVolume>0.145800000000000000000</charVolume></comp><comp id=\"C3\"><molarWeight>44.100000000000000000000</molarWeight><tempCrit>369.900000000000000000000</tempCrit><pressCrit>4256660.000000000000000000000</pressCrit><acenFactPR>0.152400000000000000000</acenFactPR><acenFactSRK>0.153200000000000000000</acenFactSRK><charVolume>0.200100000000000000000</charVolume></comp><comp id=\"C4plus\"><molarWeight>86.180000000000000000000</molarWeight><tempCrit>507.900000000000000000000</tempCrit><pressCrit>3031620.000000000000000000000</pressCrit><acenFactPR>0.300700000000000000000</acenFactPR><acenFactSRK>0.300700000000000000000</acenFactSRK><charVolume>0.368200000000000000000</charVolume></comp><comp id=\"N2\"><molarWeight>28.010000000000000000000</molarWeight><tempCrit>126.200000000000000000000</tempCrit><pressCrit>3394370.000000000000000000000</pressCrit><acenFactPR>0.040000000000000000000</acenFactPR><acenFactSRK>0.035800000000000000000</acenFactSRK><charVolume>0.090100000000000000000</charVolume></comp><comp id=\"CO2\"><molarWeight>44.010000000000000000000</molarWeight><tempCrit>304.100000000000000000000</tempCrit><pressCrit>7370000.000000000000000000000</pressCrit><acenFactPR>0.238900000000000000000</acenFactPR><acenFactSRK>0.237300000000000000000</acenFactSRK><charVolume>0.093800000000000000000</charVolume></comp></componentList><binaryInterList><comp id=\"C1\"><to id=\"CO2\">0.100000001490116000000</to><to id=\"N2\">0.035999000072479200000</to><to id=\"C4plus\">0.023474117740988700000</to><to id=\"C3\">0.006828802637755870000</to><to id=\"C2\">0.002241348847746850000</to></comp><comp id=\"C2\"><to id=\"CO2\">0.129800006747246000000</to><to id=\"N2\">0.050000000745058100000</to><to id=\"C4plus\">0.011413777247071300000</to><to id=\"C3\">0.001257906085811560000</to></comp><comp id=\"C3\"><to id=\"CO2\">0.135000005364418000000</to><to id=\"N2\">0.079998001456260700000</to><to id=\"C4plus\">0.005141953472048040000</to></comp><comp id=\"C4plus\"><to id=\"CO2\">0.125000000000000000000</to><to id=\"N2\">0.149000003933907000000</to></comp><comp id=\"N2\"><to id=\"CO2\">-0.019997000694274900000</to></comp></binaryInterList></constData>\r\n]]></char:constXML><char:inputXML><![CDATA[<inputData id=\"DEMO-EXCEL\"><calcSettings><flashCalc><convFlash>0.0001</convFlash><convKFac>0.0001</convKFac><maxFlashIter>1000</maxFlashIter></flashCalc><recycleCalc><convRecycle>0.0001</convRecycle><maxRecycleIter>1000</maxRecycleIter></recycleCalc><allocMethod><type>ClonedComponent</type><groups><group id=\"Group A\"><stream>wellA</stream><stream>wellA2</stream></group><group id=\"Group B\"><stream>wellB</stream></group><group id=\"Group C\"><stream>wellA3</stream></group></groups></allocMethod></calcSettings><units><streamUnit><unitName>mass</unitName></streamUnit></units><outSettings><fullInfo>N</fullInfo></outSettings><objectList><object id=\"S1\"><temperature>318.3</temperature><pressure>6000000</pressure></object><object id=\"S2\"><temperature>316.6</temperature><pressure>6500000</pressure></object><object id=\"S3\"><temperature>304</temperature><pressure>7000000</pressure></object><object id=\"T1\" unitName=\"ratio\"><stream id=\"InjGas\">0.2</stream></object></objectList><streamList><stream id=\"wellA\"><comp id=\"C1\">32895</comp><comp id=\"C2\">24671</comp><comp id=\"C3\">16447</comp><comp id=\"C4plus\">37830</comp><comp id=\"N2\">9868</comp><comp id=\"CO2\">3289</comp></stream><stream id=\"wellB\"><comp id=\"C1\">16548</comp><comp id=\"C2\">21640</comp><comp id=\"C3\">31823</comp><comp id=\"C4plus\">50915</comp><comp id=\"N2\">764</comp><comp id=\"CO2\">3310</comp></stream><stream id=\"wellA2\"><comp id=\"C1\">38141</comp><comp id=\"C2\">26006</comp><comp id=\"C3\">25312</comp><comp id=\"C4plus\">27739</comp><comp id=\"N2\">1387</comp><comp id=\"CO2\">6415</comp></stream><stream id=\"wellA3\"><comp id=\"C1\">55938</comp><comp id=\"C2\">21515</comp><comp id=\"C3\">15491</comp><comp id=\"C4plus\">3657</comp><comp id=\"N2\">430</comp><comp id=\"CO2\">27969</comp></stream></streamList></inputData>\r\n]]></char:inputXML></char:runCharm></soapenv:Body></soapenv:Envelope>\r\n"]
[]
["SOAP Response:"," <?xml version=\"1.0\"?>\r\n<S:Envelope xmlns:S=\"http://schemas.xmlsoap.org/soap/envelope/\"><S:Body><ns2:runCharmResponse xmlns:ns2=\"http://charm.ws.accord.com/\"><return>&lt;resultData id=\"DEMO-EXCEL\"&gt;\r\n&lt;info&gt;\r\n&lt;error id=\"0\"&gt;&lt;/error&gt;\r\n&lt;warningList&gt;\r\n&lt;/warningList&gt;\r\n&lt;time&gt;\r\n&lt;start&gt;2016/06/13 16:00:34.809&lt;/start&gt;\r\n&lt;stop&gt;2016/06/13 16:00:34.829&lt;/stop&gt;\r\n&lt;/time&gt;\r\n&lt;version&gt;2.0&lt;/version&gt;\r\n&lt;allocMethod&gt;\r\n&lt;type&gt;ClonedComponent&lt;/type&gt;\r\n&lt;groups&gt;\r\n&lt;group id=\"Group A\"&gt;\r\n&lt;stream&gt;wellA&lt;/stream&gt;\r\n&lt;stream&gt;wellA2&lt;/stream&gt;\r\n&lt;/group&gt;\r\n&lt;group id=\"Group B\"&gt;\r\n&lt;stream&gt;wellB&lt;/stream&gt;\r\n&lt;/group&gt;\r\n&lt;group id=\"Group C\"&gt;\r\n&lt;stream&gt;wellA3&lt;/stream&gt;\r\n&lt;/group&gt;\r\n&lt;/groups&gt;\r\n&lt;/allocMethod&gt;\r\n&lt;units&gt;\r\n&lt;temperatureUnit&gt;K&lt;/temperatureUnit&gt;\r\n&lt;pressureUnit&gt;Pa&lt;/pressureUnit&gt;\r\n&lt;streamUnit&gt;\r\n&lt;unitName&gt;mass&lt;/unitName&gt;\r\n&lt;unitType&gt;kg&lt;/unitType&gt;\r\n&lt;/streamUnit&gt;\r\n&lt;/units&gt;\r\n&lt;/info&gt;\r\n&lt;exportGas&gt;\r\n&lt;stream id=\"InjGas\" &gt;\r\n&lt;group id=\"Group A\" totalMass=\"37694.753818715144\" totalMoles=\"1490.0495464640742\" &gt;\r\n&lt;comp id=\"C1\" &gt;13842.598409948574&lt;/comp&gt;\r\n&lt;comp id=\"C2\" &gt;9263.695767868327&lt;/comp&gt;\r\n&lt;comp id=\"C3\" &gt;6809.336355179796&lt;/comp&gt;\r\n&lt;comp id=\"C4plus\" &gt;3700.4583699986756&lt;/comp&gt;\r\n&lt;comp id=\"N2\" &gt;2230.632467460456&lt;/comp&gt;\r\n&lt;comp id=\"CO2\" &gt;1848.0324482593173&lt;/comp&gt;\r\n&lt;/group&gt;\r\n&lt;group id=\"Group B\" totalMass=\"1356.244910395588\" totalMoles=\"59.718048972183276\" &gt;\r\n&lt;comp id=\"C1\" &gt;637.8075187935963&lt;/comp&gt;\r\n&lt;comp id=\"C2\" &gt;322.17160925778427&lt;/comp&gt;\r\n&lt;comp id=\"C3\" &gt;223.17608594510108&lt;/comp&gt;\r\n&lt;comp id=\"C4plus\" &gt;39.622772852975196&lt;/comp&gt;\r\n&lt;comp id=\"N2\" &gt;52.95565244310049&lt;/comp&gt;\r\n&lt;comp id=\"CO2\" &gt;80.51127110303092&lt;/comp&gt;\r\n&lt;/group&gt;\r\n&lt;group id=\"Group C\" totalMass=\"22977.44491932507\" totalMoles=\"994.1177538484794\" &gt;\r\n&lt;comp id=\"C1\" &gt;10900.490875833428&lt;/comp&gt;\r\n&lt;comp id=\"C2\" &gt;3932.916598174458&lt;/comp&gt;\r\n&lt;comp id=\"C3\" &gt;2526.004681100846&lt;/comp&gt;\r\n&lt;comp id=\"C4plus\" &gt;206.38680259093707&lt;/comp&gt;\r\n&lt;comp id=\"N2\" &gt;85.22185348804943&lt;/comp&gt;\r\n&lt;comp id=\"CO2\" &gt;5326.424108137351&lt;/comp&gt;\r\n&lt;/group&gt;\r\n&lt;/stream&gt;\r\n&lt;stream id=\"ExpGas\" &gt;\r\n&lt;group id=\"Group A\" totalMass=\"150779.01527486058\" totalMoles=\"5960.198185856297\" &gt;\r\n&lt;comp id=\"C1\" &gt;55370.393639794296&lt;/comp&gt;\r\n&lt;comp id=\"C2\" &gt;37054.783071473306&lt;/comp&gt;\r\n&lt;comp id=\"C3\" &gt;27237.345420719183&lt;/comp&gt;\r\n&lt;comp id=\"C4plus\" &gt;14801.833479994702&lt;/comp&gt;\r\n&lt;comp id=\"N2\" &gt;8922.529869841825&lt;/comp&gt;\r\n&lt;comp id=\"CO2\" &gt;7392.129793037269&lt;/comp&gt;\r\n&lt;/group&gt;\r\n&lt;group id=\"Group B\" totalMass=\"5424.979641582352\" totalMoles=\"238.8721958887331\" &gt;\r\n&lt;comp id=\"C1\" &gt;2551.230075174385&lt;/comp&gt;\r\n&lt;comp id=\"C2\" &gt;1288.686437031137&lt;/comp&gt;\r\n&lt;comp id=\"C3\" &gt;892.7043437804043&lt;/comp&gt;\r\n&lt;comp id=\"C4plus\" &gt;158.49109141190078&lt;/comp&gt;\r\n&lt;comp id=\"N2\" &gt;211.82260977240196&lt;/comp&gt;\r\n&lt;comp id=\"CO2\" &gt;322.0450844121237&lt;/comp&gt;\r\n&lt;/group&gt;\r\n&lt;group id=\"Group C\" totalMass=\"91909.77967730028\" totalMoles=\"3976.4710153939177\" &gt;\r\n&lt;comp id=\"C1\" &gt;43601.96350333371&lt;/comp&gt;\r\n&lt;comp id=\"C2\" &gt;15731.666392697833&lt;/comp&gt;\r\n&lt;comp id=\"C3\" &gt;10104.018724403384&lt;/comp&gt;\r\n&lt;comp id=\"C4plus\" &gt;825.5472103637483&lt;/comp&gt;\r\n&lt;comp id=\"N2\" &gt;340.88741395219773&lt;/comp&gt;\r\n&lt;comp id=\"CO2\" &gt;21305.696432549405&lt;/comp&gt;\r\n&lt;/group&gt;\r\n&lt;/stream&gt;\r\n&lt;/exportGas&gt;\r\n&lt;exportOil&gt;\r\n&lt;stream id=\"S3-L\" costald-den=\"517.612529032727\" &gt;\r\n&lt;group id=\"Group A\" totalMass=\"61526.230906424316\" totalMoles=\"993.8015377576301\" &gt;\r\n&lt;comp id=\"C1\" &gt;1823.0079502571216&lt;/comp&gt;\r\n&lt;comp id=\"C2\" &gt;4358.521160658369&lt;/comp&gt;\r\n&lt;comp id=\"C3\" &gt;7712.318224101036&lt;/comp&gt;\r\n&lt;comp id=\"C4plus\" &gt;47066.708150006656&lt;/comp&gt;\r\n&lt;comp id=\"N2\" &gt;101.83766269771816&lt;/comp&gt;\r\n&lt;comp id=\"CO2\" &gt;463.83775870341003&lt;/comp&gt;\r\n&lt;/group&gt;\r\n&lt;group id=\"Group B\" totalMass=\"118218.77544802206\" totalMoles=\"2867.629177195363\" &gt;\r\n&lt;comp id=\"C1\" &gt;13358.96240603202&lt;/comp&gt;\r\n&lt;comp id=\"C2\" &gt;20029.14195371108&lt;/comp&gt;\r\n&lt;comp id=\"C3\" &gt;30707.1195702745&lt;/comp&gt;\r\n&lt;comp id=\"C4plus\" &gt;50716.886135735134&lt;/comp&gt;\r\n&lt;comp id=\"N2\" &gt;499.2217377844976&lt;/comp&gt;\r\n&lt;comp id=\"CO2\" &gt;2907.4436444848457&lt;/comp&gt;\r\n&lt;/group&gt;\r\n&lt;group id=\"Group C\" totalMass=\"10112.775403374646\" totalMoles=\"276.8854845069337\" &gt;\r\n&lt;comp id=\"C1\" &gt;1435.5456208328574&lt;/comp&gt;\r\n&lt;comp id=\"C2\" &gt;1850.4170091277063&lt;/comp&gt;\r\n&lt;comp id=\"C3\" &gt;2860.9765944957767&lt;/comp&gt;\r\n&lt;comp id=\"C4plus\" &gt;2625.0659870453155&lt;/comp&gt;\r\n&lt;comp id=\"N2\" &gt;3.8907325597528932&lt;/comp&gt;\r\n&lt;comp id=\"CO2\" &gt;1336.8794593132395&lt;/comp&gt;\r\n&lt;/group&gt;\r\n&lt;/stream&gt;\r\n&lt;/exportOil&gt;\r\n&lt;/resultData&gt;</return></ns2:runCharmResponse></S:Body></S:Envelope>\r\n"]
[null,null,{"$f":"LEN(C10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["ResultData:"," <resultData id=\"DEMO-EXCEL\">\n<info>\n<error id=\"0\"></error>\n<warningList>\n</warningList>\n<time>\n<start>2016/06/13 16:00:34.809</start>\n<stop>2016/06/13 16:00:34.829</stop>\n</time>\n<version>2.0</version>\n<allocMethod>\n<type>ClonedComponent</type>\n<groups>\n<group id=\"Group A\">\n<stream>wellA</stream>\n<stream>wellA2</stream>\n</group>\n<group id=\"Group B\">\n<stream>wellB</stream>\n</group>\n<group id=\"Group C\">\n<stream>wellA3</stream>\n</group>\n</groups>\n</allocMethod>\n<units>\n<temperatureUnit>K</temperatureUnit>\n<pressureUnit>Pa</pressureUnit>\n<streamUnit>\n<unitName>mass</unitName>\n<unitType>kg</unitType>\n</streamUnit>\n</units>\n</info>\n<exportGas>\n<stream id=\"InjGas\" >\n<group id=\"Group A\" totalMass=\"37694.753818715144\" totalMoles=\"1490.0495464640742\" >\n<comp id=\"C1\" >13842.598409948574</comp>\n<comp id=\"C2\" >9263.695767868327</comp>\n<comp id=\"C3\" >6809.336355179796</comp>\n<comp id=\"C4plus\" >3700.4583699986756</comp>\n<comp id=\"N2\" >2230.632467460456</comp>\n<comp id=\"CO2\" >1848.0324482593173</comp>\n</group>\n<group id=\"Group B\" totalMass=\"1356.244910395588\" totalMoles=\"59.718048972183276\" >\n<comp id=\"C1\" >637.8075187935963</comp>\n<comp id=\"C2\" >322.17160925778427</comp>\n<comp id=\"C3\" >223.17608594510108</comp>\n<comp id=\"C4plus\" >39.622772852975196</comp>\n<comp id=\"N2\" >52.95565244310049</comp>\n<comp id=\"CO2\" >80.51127110303092</comp>\n</group>\n<group id=\"Group C\" totalMass=\"22977.44491932507\" totalMoles=\"994.1177538484794\" >\n<comp id=\"C1\" >10900.490875833428</comp>\n<comp id=\"C2\" >3932.916598174458</comp>\n<comp id=\"C3\" >2526.004681100846</comp>\n<comp id=\"C4plus\" >206.38680259093707</comp>\n<comp id=\"N2\" >85.22185348804943</comp>\n<comp id=\"CO2\" >5326.424108137351</comp>\n</group>\n</stream>\n<stream id=\"ExpGas\" >\n<group id=\"Group A\" totalMass=\"150779.01527486058\" totalMoles=\"5960.198185856297\" >\n<comp id=\"C1\" >55370.393639794296</comp>\n<comp id=\"C2\" >37054.783071473306</comp>\n<comp id=\"C3\" >27237.345420719183</comp>\n<comp id=\"C4plus\" >14801.833479994702</comp>\n<comp id=\"N2\" >8922.529869841825</comp>\n<comp id=\"CO2\" >7392.129793037269</comp>\n</group>\n<group id=\"Group B\" totalMass=\"5424.979641582352\" totalMoles=\"238.8721958887331\" >\n<comp id=\"C1\" >2551.230075174385</comp>\n<comp id=\"C2\" >1288.686437031137</comp>\n<comp id=\"C3\" >892.7043437804043</comp>\n<comp id=\"C4plus\" >158.49109141190078</comp>\n<comp id=\"N2\" >211.82260977240196</comp>\n<comp id=\"CO2\" >322.0450844121237</comp>\n</group>\n<group id=\"Group C\" totalMass=\"91909.77967730028\" totalMoles=\"3976.4710153939177\" >\n<comp id=\"C1\" >43601.96350333371</comp>\n<comp id=\"C2\" >15731.666392697833</comp>\n<comp id=\"C3\" >10104.018724403384</comp>\n<comp id=\"C4plus\" >825.5472103637483</comp>\n<comp id=\"N2\" >340.88741395219773</comp>\n<comp id=\"CO2\" >21305.696432549405</comp>\n</group>\n</stream>\n</exportGas>\n<exportOil>\n<stream id=\"S3-L\" costald-den=\"517.612529032727\" >\n<group id=\"Group A\" totalMass=\"61526.230906424316\" totalMoles=\"993.8015377576301\" >\n<comp id=\"C1\" >1823.0079502571216</comp>\n<comp id=\"C2\" >4358.521160658369</comp>\n<comp id=\"C3\" >7712.318224101036</comp>\n<comp id=\"C4plus\" >47066.708150006656</comp>\n<comp id=\"N2\" >101.83766269771816</comp>\n<comp id=\"CO2\" >463.83775870341003</comp>\n</group>\n<group id=\"Group B\" totalMass=\"118218.77544802206\" totalMoles=\"2867.629177195363\" >\n<comp id=\"C1\" >13358.96240603202</comp>\n<comp id=\"C2\" >20029.14195371108</comp>\n<comp id=\"C3\" >30707.1195702745</comp>\n<comp id=\"C4plus\" >50716.886135735134</comp>\n<comp id=\"N2\" >499.2217377844976</comp>\n<comp id=\"CO2\" >2907.4436444848457</comp>\n</group>\n<group id=\"Group C\" totalMass=\"10112.775403374646\" totalMoles=\"276.8854845069337\" >\n<comp id=\"C1\" >1435.5456208328574</comp>\n<comp id=\"C2\" >1850.4170091277063</comp>\n<comp id=\"C3\" >2860.9765944957767</comp>\n<comp id=\"C4plus\" >2625.0659870453155</comp>\n<comp id=\"N2\" >3.8907325597528932</comp>\n<comp id=\"CO2\" >1336.8794593132395</comp>\n</group>\n</stream>\n</exportOil>\n</resultData>"]