{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["例題11d 単蒸留"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"例題11d 単蒸留","index":0,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["No.",1,null,null,null,null,null,null,null,"気液平衡",null,null,null,null,null,null,"<COCO_11c_SimpleDistill"]
["β=","x=",null,null,null,null,null,null,null,"低沸点成分(1)","エタノール"]
[0.50000000000000011,7.0019536003293852E-3,null,null,null,null,null,null,null,"高沸点成分(2)","水",null,null,null,null,null,null,"L","V","vapor fraction"]
[null,"x'=",null,null,null,null,null,null,null,"van Laar定数",null,null,null,null,null,null,0.1,0.9,0.1,{"$f":"S4/(R4+S4)","v":0.1}]
["Diff eq→",{"$f":"-(K35-B3)/(1-A3)","v":-0.13632747090957836},null,null,null,null,null,null,null,"A12",0.72919999999999996,null,null,null,null,null,0.2,0.8,0.1,{"$f":"S5/(R5+S5)","v":0.11111111111111112}]
[null,null,null,null,null,null,null,null,null,"A21",0.41039999999999999,null,null,null,null,null,0.3,0.7,0.1,{"$f":"S6/(R6+S6)","v":0.12500000000000003}]
["Sectionβ=[a,",0,null,null,null,null,null,null,null,"Antoine定数(mmHg)",null,null,null,null,null,null,0.4,0.6,0.1,0.14285714285714288]
["b]",0.5,null,null,null,null,null,null,null,"A1",8.0449400000000004,null,null,null,null,null,0.5,0.5,0.1,0.16666666666666669]
["Division",0.05,null,null,null,null,null,null,null,"B1",1554.3]
["Results",null,null,null,null,null,null,null,null,"C1",222.65]
["β","x",null,"y","xD",null,null,null,null,"A2",7.9668099999999997]
[0,0.2,"←初期値",0.53449999999999998,null,null,null,null,null,"B2",1668.21,null,null,null,null,null,"L","β","x","y","xD"]
[0.05,0.18267272995029976,null,0.52400000000000002,{"$f":"($B$12-(1-A13)*B13)/A13","v":0.52921813094430503},null,null,null,null,"C2",228,null,null,null,null,null,null,0,0.16600000000000001,0.505]
[0.1,0.16409512084658895,null,0.51,{"$f":"($B$12-(1-A14)*B14)/A14","v":0.52314391238069935},null,null,null,null,null,null,null,null,null,null,1,0.9,{"$f":"1-Q14/1","v":9.9999999999999978E-2},0.16600000000000001,0.505]
[0.15,0.14422196127589432,null,0.49299999999999999,0.51607555276993233,null,null,null,null,"液組成 x",{"$f":"B3","v":7.0019536003293852E-3},null,null,null,null,null,null,0.1,{"$f":"S16","v":0.128},0.46899999999999997,{"$f":"U16","v":0.4870000000000001}]
[0.19999999999999998,0.12307775770222359,null,0.47099999999999997,0.50768896919110573,null,null,null,null,"全圧[kPa]",101.3,null,null,null,null,2,0.8,{"$f":"1-Q16/1","v":0.19999999999999996},0.128,0.46899999999999997,{"$f":"0.1*SUM(T13:T16)/2/R16","v":0.4870000000000001}]
[0.24999999999999997,0.10082818703399007,null,0.441,0.4975154388980299,null,null,null,null,"活量係数γ1",{"$f":"10^(K5/(1+K15*K5/(1-K15)/K6)^2)","v":5.1435825307313374},null,null,null,null,null,null,0.2,{"$f":"S18","v":8.7999999999999995E-2},0.41,{"$f":"U18","v":0.46133333333333332}]
[0.3,7.7910800602732463E-2,null,0.4,0.48487479859362437,null,null,null,null,"活量係数γ2",{"$f":"10^(K6/(1+(1-K15)*K6/K15/K5)^2)","v":1.0001446971434993},null,null,null,null,3,0.7,{"$f":"1-Q18/1","v":0.30000000000000004},8.7999999999999995E-2,0.41,{"$f":"0.1*SUM(T13:T18)/2/R18","v":0.46133333333333332}]
[0.35000000000000003,5.5253981653718601E-2,null,0.34189999999999998,0.46881403407166544,null,null,null,null,"t1",{"$f":"K9/(K8-LOG(760))-K10","v":78.330238918371634},null,null,null,null,null,null,0.3,{"$f":"S20","v":0.05},0.314,{"$f":"U20","v":0.42450000000000004}]
[0.40000000000000008,3.4541555920051009E-2,null,0.2621,0.44818766611992344,null,null,null,null,"p*1",{"$f":"10^(K8-K9/(K19+K10))*(101.3/760)","v":101.29999999999983},null,null,null,null,4,0.6,{"$f":"1-Q20/1","v":0.4},0.05,0.314,{"$f":"0.1*SUM(T13:T20)/2/R20","v":0.42450000000000004}]
[0.45000000000000012,1.8127939054073474E-2,null,0.16700000000000001,0.4222880744894657,null,null,null,null,"p*2",{"$f":"10^(K11-K12/(K19+K13))*(101.3/760)","v":44.240125328823567},null,null,null,null,null,null,0.4,{"$f":"S22","v":2.1999999999999999E-2},0.188,{"$f":"U22","v":0.37720000000000009}]
[0.50000000000000011,7.7464261688965346E-3,null,8.1799999999999998E-2,0.39225357383110337,null,null,null,null,"蒸気圧(t1)",{"$f":"K20*K17*K15+K21*K18*(1-K15)","v":47.585046907367449},null,null,null,null,5,0.5,{"$f":"1-Q22/1","v":0.5},2.1999999999999999E-2,0.188,{"$f":"0.1*SUM(T13:T22)/2/R22","v":0.37720000000000009}]
[null,null,null,null,null,null,null,null,null,"t2",{"$f":"(K19+K27)/2","v":89.165431912031337}]
[null,null,null,null,null,null,null,null,null,"p*1",{"$f":"10^(K8-K9/(K23+K10))*(101.3/760)","v":153.12860459468655}]
[null,null,null,null,null,null,null,null,null,"p*2",{"$f":"10^(K11-K12/(K23+K13))*(101.3/760)","v":67.898257543717875}]
[null,null,null,null,null,null,null,null,null,"蒸気圧(t2)",{"$f":"K24*K17*K15+K25*K18*(1-K15)","v":72.947539009103636}]
[null,null,null,null,null,null,null,null,null,"t3",{"$f":"K12/(K11-LOG(760))-K13","v":100.00062490569104}]
[null,null,null,null,null,null,null,null,null,"p*1",{"$f":"10^(K8-K9/(K27+K10))*(101.3/760)","v":225.13908744091657}]
[null,null,null,null,null,null,null,null,null,"p*2",{"$f":"10^(K11-K12/(K27+K13))*(101.3/760)","v":101.3000000000001}]
[null,null,null,null,null,null,null,null,null,"蒸気圧(t3)",{"$f":"K28*K17*K15+K29*K18*(1-K15)","v":108.71366993870366}]
[null,null,null,null,null,null,null,null,null,"沸点[℃]",{"$f":"K19*(K16-K26)*(K16-K30)/(K22-K26)/(K22-K30)+K23*(K16-K22)*(K16-K30)/(K26-K22)/(K26-K30)+K27*(K16-K22)*(K16-K26)/(K30-K22)/(K30-K26)","v":98.181990471735872}]
[null,null,null,null,null,null,null,null,null,"Tb",{"$f":"K31","v":98.181990471735872}]
[null,null,null,null,null,null,null,null,null,"p*1[kPa]",{"$f":"10^(K8-K9/(K32+K10))*(101.3/760)","v":211.41906472425609}]
[null,null,null,null,null,null,null,null,null,"p*2[kPa]",{"$f":"10^(K11-K12/(K32+K13))*(101.3/760)","v":94.896974654033613}]
[null,null,null,null,null,null,null,null,null,"y",{"$f":"K33*K17*K15/K16","v":7.5165689055118556E-2}]