{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Gas","LPG","CV","WI","SFL"],"read":"whole","date_system":"1900"}

{"sheet":"Gas","index":0,"n_rows":8,"n_cols":5,"rows_kept":8}
["Fuel","SGi","ni (mol)","yi (ni/100)","SG-in-mixture"]
["Methane",0.554,92.74,{"$f":"C2/100","v":0.9274},{"$f":"D2*B2","v":0.5137796}]
["Ethane",1.0494,4.07,{"$f":"C3/100","v":0.0407},{"$f":"D3*B3","v":0.042710580000000005}]
["Propane",1.5625,0.77,0.0077,0.01203125]
["Butane",2.085,0.14,1.4000000000000002E-3,2.9190000000000006E-3]
["N2",0.9674,0.45,4.5000000000000005E-3,0.004353300000000001]
["CO2",1.5291,1.83,0.0183,0.02798253]
[null,"Total",{"$f":"SUM(C2:C7)","v":100},{"$f":"SUM(D2:D7)","v":0.9999999999999999},{"$f":"SUM(E2:E7)","v":0.6037762600000001}]

{"sheet":"LPG","index":1,"n_rows":8,"n_cols":5,"rows_kept":8}
["Fuel","SGi","ni (mol)","yi (ni/100)","SG-in-mixture"]
["Methane",0.554,0,{"$f":"C2/100","v":0},{"$f":"D2*B2","v":0}]
["Ethane",1.0494,0,{"$f":"C3/100","v":0},{"$f":"D3*B3","v":0}]
["Propane",1.5625,30,0.3,0.46875]
["Butane",2.085,70,0.7,1.4594999999999998]
["N2",0.9674,0,0,0]
["CO2",1.5291,0,0,0]
[null,"Total",{"$f":"SUM(C2:C7)","v":100},{"$f":"SUM(D2:D7)","v":1},{"$f":"SUM(E2:E7)","v":1.9282499999999998}]

{"sheet":"CV","index":2,"n_rows":12,"n_cols":12,"rows_kept":12}
["Fuel","netCV","ni","yi","yiCVi"]
["CH4",8561,30,{"$f":"C2/100","v":0.3},{"$f":"D2*B2","v":2568.2999999999997}]
["C3H8",21809,70,{"$f":"C3/100","v":0.7},{"$f":"D3*B3","v":15266.3}]
[{"$nulls":3},"mix-CV",{"$f":"SUM(E2:E3)","v":17834.6}]
[]
[]
["Fuel","netCV","ni","yi","yiCVi",null,null,"Fuel","netCV","ni","yi","yiCVi"]
["CH4",8561,30,{"$f":"C8/100","v":0.3},{"$f":"D8*B8","v":2568.2999999999997},null,null,"CH4",8561,30,{"$f":"J8/SUM(J8:J11)","v":0.25},{"$f":"K8*I8","v":2140.25}]
["C3H8",21809,60,{"$f":"C9/100","v":0.6},{"$f":"D9*B9","v":13085.4},null,null,"C3H8",21809,70,{"$f":"J9/SUM(J8:J11)","v":0.5833333333333334},{"$f":"K9*I9","v":12721.916666666668}]
["N2",0,5,0.05,0,null,null,"N2",0,10,{"$f":"J10/SUM(J8:J11)","v":0.08333333333333333},0]
["CO2",0,5,0.05,0,null,null,"CO2",0,10,{"$f":"J11/SUM(J8:J11)","v":0.08333333333333333},0]
[{"$nulls":3},"CV-mix",{"$f":"SUM(E8:E11)","v":15653.699999999999},{"$nulls":5},{"$f":"SUM(K8:K11)","v":1},{"$f":"SUM(L8:L11)","v":14862.166666666668}]

{"sheet":"WI","index":3,"n_rows":5,"n_cols":5,"rows_kept":5}
["Fuel","SG","NCV","WI","%var"]
["Methane",0.554,8561,{"$f":"C2/SQRT(B2)","v":11501.900721907075}]
["Ethane",1.0494,15235,{"$f":"C3/SQRT(B3)","v":14872.08738639306},{"$f":"ABS(D3-D4)/D4*100","v":14.759460621801443}]
["Propane",1.5625,21809,17447.2,{"$f":"ABS(D4-D5)/D5*100","v":11.136031134723}]
["Butane",2.085,28350,19633.60428617698]

{"sheet":"SFL","index":4,"n_rows":7,"n_cols":8,"rows_kept":7}
["Fuel","x","y","z","vol% in fuel","a","SFL-i","yi/SFL-i"]
["C2H4",2,4,0,10,{"$f":"B2+C2/4-D2/2","v":3},{"$f":"1/(1+F2*4.76)*100","v":6.544502617801047},{"$f":"E2/G2","v":1.528}]
["CH4",1,4,0,50,{"$f":"B3+C3/4-D3/2","v":2},{"$f":"1/(1+F3*4.76)*100","v":9.505703422053232},{"$f":"E3/G3","v":5.26}]
["C2H6",2,6,0,20,{"$f":"B4+C4/4-D4/2","v":3.5},{"$f":"1/(1+F4*4.76)*100","v":5.662514156285391},3.532]
["H2",0,2,0,10,{"$f":"B5+C5/4-D5/2","v":0.5},{"$f":"1/(1+F5*4.76)*100","v":29.585798816568047},0.338]
["CO",1,0,1,10,{"$f":"B6+C6/4-D6/2","v":0.5},{"$f":"1/(1+F6*4.76)*100","v":29.585798816568047},0.338]
[{"$nulls":6},"SFL-mix",{"$f":"100/SUM(H2:H6)","v":9.094216078574028}]