ng任意压缩因子计算

说明：本页只蓝色数据可改动，其他各页数据均不可改动！！,,NG压力,bar,39,,计算结果：,1.01325,1.01325,1.01325,39,,,,,

,,NG温度,K,283.15,,,273.15,293.15,303.15,283.15,,,,,

,,NG压缩因子,/,0.8653,,,0.9966,0.9973,0.9976,0.8655,1.152281918,,,,

,,组分,分子量,摩尔分数xi(%),,,,,"LHV:MJ/m3,(25℃/0℃)",,,,,,

可变单元格,目标单元格：0,,,,,压缩因子z,求和因子b^0.5,体积分数xi(%),理想体积,实际体积,,,,,

47.16626577,0.00,N2,28.0135,0.03,0.030,0.983875239,0.1270,0.036,\,\,0.00840405,0.000038095,0.029516257,#VALUE!,#VALUE!

28.96212915,0.00,CH4,16.043,87.35,87.350,0.917628727,0.2870,97.638,35.808,39.022,14.0135605,0.250697959,80.15486932,3127.8288,3810.056027

330.6304115,0.00,C2H6,30.07,8.3,8.300,0.150661597,0.9216,1.523,63.740,423.067,2.49581,0.076492433,1.250491258,529.042,644.4341394

478.7555562,0.00,C3H8,44.097,4.32,4.320,0.152583341,0.9206,0.803,91.150,597.378,1.9049904,0.039767862,0.659160034,393.768,479.6548142

531.6384345,0.00,iC4H10,58.123,0,0.000,0.181113585,0.9049,0.000,118.560,654.617,0,0,0,0,0

544.4885988,0.00,nC4H10,58.123,0,0.000,0.176839227,0.9073,0.000,118.150,668.121,0,0,0,0,0

580.0158323,0.00,iC5H12,72.15,0,0.000,0.206069829,0.8910,0.000,145.960,708.304,0,0,0,0,0

571.2990903,0.00,nC5H13,72.15,0,0.000,0.209213992,0.8893,0.000,145.660,696.225,0,0,0,0,0

426.7539599,0.00,CO2,44.01,0,0,0.170838485,0.9106,0.000,\,\,0,0,0,#VALUE!,#VALUE!

单变量求解,,NG,18.423,100,100.00,0.8653,0.3670,100.000,4050.639,4934.145,,,82