{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["例題12a 蒸留塔微分モデル","EtherIPA気液平衡"],"not_rendered":{"charts":4,"images":1,"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":"例題12a 蒸留塔微分モデル","index":0,"n_rows":49,"n_cols":22,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["微分方程式数",2,null,null,"F=",250,"L=DR",{"$f":"F8*F2","v":134},"L'=L+qF=",{"$f":"H1+F5*F1","v":384},null,null,null,null,null,null,null,null,null,"x","α=","ｙ*"]
["z=","yR=","yS=",null,"D=",134,"V=L+D",{"$f":"H1+F2","v":268},"V'=L+qF-W=",{"$f":"H1+F5*F1-F3","v":268},null,null,null,null,null,null,null,null,null,0,{"$f":"3.765*T2^2-8.6392*T2+5.3118","v":5.3117999999999999},{"$f":"U2*T2/(1+(U2-1)*T2)","v":0}]
[2.0000000000000004,0.73254486304769173,-2.9658018670730649E-2,null,"W=",116,"yq=",{"$f":"((F2/H1)*F6+(F3/J1)*F7)/((H1+F2)/H1-J2/J1)","v":0.54919999999999991},null,null,null,null,null,null,null,null,null,null,null,5.0000000000001002E-2,4.8892524999999916,0.20466326855560155]
[null,"yR'=","yS'",null,"zF=",0.4,"xq=",{"$f":"((H1+F2)/H1)*H3-(F2/H1)*F6","v":0.39839999999999987},null,null,null,null,null,null,null,null,null,null,null,0.100000000000001,4.4855299999999918,0.33261799869934877]
["微分方程式→",{"$f":"(H5/H2)*(H7-B3)","v":3.8754607946351043E-2},{"$f":"-(H5/J2)*(J7-C3)","v":2.9232644755841941E-3},null,"q=",1,"Kya=",725,null,null,null,null,null,null,null,null,null,null,null,0.15000000000000099,4.1006324999999926,0.41983279410488833]
[null,null,null,null,"xD=",0.7,"xR=",{"$f":"(H1+F2)*B3/H1-(F2/H1)*F6","v":0.7650897260953835},"xS=",{"$f":"(J2/J1)*C3+(F3/J1)*F7","v":-5.5946588639474316E-3},null,null,null,null,null,null,null,null,null,0.20000000000000101,3.7345599999999926,0.48284065286196093]
["積分区間z=[a,",0,null,null,"xW=",0.05,"yR*=",{"$f":"H8*H6/(1+(H8-1)*H6)","v":0.74687070432992908},"yS*=",{"$f":"J8*J6/(1+(J8-1)*J6)","v":-3.0738618504463841E-2},null,null,null,null,null,null,null,null,null,0.250000000000001,3.3873124999999931,0.53031889390099596]
["b]",2,null,null,"R=",1,"αR=",{"$f":"3.765*H6^2-8.6392*H6+5.3118","v":0.90592585631407196},"αS=",{"$f":"3.765*J6^2-8.6392*J6+5.3118","v":5.3602512221397962},null,null,null,null,null,null,null,null,null,0.3,3.0588899999999994,0.56727806155407745]
["積分刻み幅Δz",0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,2.7492924999999997,0.59683731276872831]
["計算結果",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B24","v":0},{"$f":"C24","v":0},null,null,0.4,2.4585199999999996,0.6210705010963693]
["z","yR","yS","xR","αR","yR*","xS","αS","yS*","zS",null,null,null,null,null,1,1,null,null,0.45,2.1865724999999996,0.64145033015498065]
[0,{"$f":"H3","v":0.54919999999999991},{"$f":"H3","v":0.54919999999999991},{"$f":"($H$1+$F$2)*B12/$H$1-($F$2/$H$1)*$F$6","v":0.39839999999999987},{"$f":"3.765*D12^2-8.6392*D12+5.3118","v":2.4675331584000006},{"$f":"E12*D12/(1+(E12-1)*D12)","v":0.62036145168882828},{"$f":"($J$2/$J$1)*C12+($F$3/$J$1)*$F$7","v":0.39839999999999987},{"$f":"3.765*G12^2-8.6392*G12+5.3118","v":2.4675331584000006},{"$f":"H12*G12/(1+(H12-1)*G12)","v":0.62036145168882828},{"$f":"-A12","v":0},null,null,null,null,null,null,null,null,null,0.5,1.9334499999999997,0.65910446743595419]
[0.2,0.58588904949940301,0.50269126166728906,0.47177809899880607,{"$f":"3.765*D13^2-8.6392*D13+5.3118","v":2.0740079208559155},{"$f":"E13*D13/(1+(E13-1)*D13)","v":0.64941646676859044},0.3659407763719621,{"$f":"3.765*G13^2-8.6392*G13+5.3118","v":2.6545455788384498},{"$f":"H13*G13/(1+(H13-1)*G13)","v":0.60506211616306527},-0.2,null,null,null,null,null,0.4,{"$f":"H3","v":0.54919999999999991},null,null,0.55000000000000004,1.6991524999999994,0.67498086675560742]
[0.4,0.61741414112048276,0.43670115009090338,0.53482828224096557,1.7682569665042047,0.67029805037399448,0.3198851776676096,2.9335073468402513,0.57978703801657472,-0.4,null,null,null,null,null,0.4,0.4,null,null,0.6,1.4836799999999992,0.68997246955529634]
[0.6,0.64321309625567624,0.34680378529770106,0.58642619251135253,1.5403140700824798,0.68593807203781498,0.25714430848902053,3.3392327207385897,0.53615595491846224,-0.6,null,null,null,null,null,0.4,0,null,null,0.65,1.2870324999999996,0.70503243115746639]
[0.79999999999999993,0.66397191427117552,0.23377851944548134,0.62794382854235109,1.3714578225005827,0.69831358649127373,0.17826209169632551,3.8913999480269528,0.45775157308265113,-0.79999999999999993,null,null,null,null,null,null,null,null,null,0.7,{"$f":"3.765*T16^2-8.6392*T16+5.3118","v":1.10921},{"$f":"U16*T16/(1+(U16-1)*T16)","v":0.72130536849468674}]
[0.99999999999999989,0.68072218294453057,0.1137822344630906,0.66144436588906119,1.2446698983226518,0.70860278704860147,9.4514684469031982E-2,4.528901579244895,0.32098770526377107,-0.99999999999999989,null,null,null,null,null,null,null,null,null,0.72499999999999998,{"$f":"3.765*T17^2-8.6392*T17+5.3118","v":1.0273581250000001},{"$f":"U17*T17/(1+(U17-1)*T17)","v":0.73034844175182378}]
[1.2,0.69443934553270281,2.4064109663659475E-2,0.68887869106540567,1.1471344611777567,0.71751113912346831,3.1898909869429011E-2,5.040049977653509,0.14241821081747066,-1.2,null,null,null,null,null,null,null,null,null,0.75,0.95021249999999924,0.74030274207842195]
[1.4000000000000001,0.70592328406224714,-1.4214221649728721E-2,0.71184656812449432,1.0698367737719536,0.72549314595433578,5.1838244736268305E-3,5.2671170768236353,2.671292097211897E-2,-1.4000000000000001,null,null,null,null,null,null,null,null,null,0.77500000000000002,0.87777312499999915,0.75145651230280752]
[1.6000000000000003,0.71579735047027115,-2.5191475987446997E-2,0.73159470094054235,1.0065510458971865,0.7328749539439714,-2.4773842829057171E-3,5.3332257257316913,-1.3355825246367576E-2,-1.6000000000000003,null,null,null,null,null,null,null,null,null,0.8,0.81003999999999898,0.76415984302479134]
[1.8000000000000005,0.72454500302402214,-2.8181321321649418E-2,0.74909000604804432,0.95293804666112258,0.73992128493877329,-4.5640471724011557E-3,5.3513081432644265,-2.4918493506223806E-2,-1.8000000000000005,null,null,null,{"$f":"2.9*250","v":725},null,null,null,null,null,0.82499999999999996,0.74701312499999961,0.77884097783644968]
[2.0000000000000004,0.7325526905511035,-2.8992151452868122E-2,0.76510538110220705,0.90588080096301127,0.74687776941352912,-5.1299390348142088E-3,5.3562176500830629,-2.8105139229334289E-2,-2.0000000000000004,null,null,null,null,null,null,null,null,null,0.85,0.68869249999999926,0.79602621675036078]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.875,0.63507812499999972,0.81636371461773516]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,0.58616999999999919,0.84065090916623764]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.92500000000000004,0.54196812499999858,0.86986408089487288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,0.50247249999999966,0.90518610663576349]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97499999999999998,0.46768312499999887,0.9480239805659062]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99,0.4490684999999992,0.97800156613450229]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0,0,0.4,0]
[1,0,0.4,-1.5]

{"sheet":"EtherIPA気液平衡","index":1,"n_rows":48,"n_cols":33,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[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,"    25    0.425222    0.574778  ",null,null,null,"    25    0.588888    0.411112  "]
["COCOC Diisopropyl ether(1)/Isopropanol(2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"    26    0.408175    0.591825  ",null,null,null,"    26    0.577000    0.423000  "]
["DECHEMA/Mod UNIFAC/Antoine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,null,"    27    0.374389    0.625611  ",null,null,null,"    27    0.553692    0.446308  "]
["x","y",null,null,"α","相間α","y calc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    28    0.305668    0.694332  ",null,null,null,"    28    0.507444    0.492556  "]
[0,0,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,"    29    0.162002    0.837998  ",null,null,null,"    29    0.413151    0.586849  "]
[0.02,9.7933215961400005E-2,null,null,{"$f":"B6*(1-A6)/A6/(1-B6)","v":5.3197032270986044},{"$f":"3.765*A6^2-8.6392*A6+5.3118","v":5.1405219999999998},{"$f":"F6*A6/(1+(F6-1)*A6)","v":9.4947773130078059E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    30   0.0267268    0.97327",null,null,null,"    30    0.214869    0.785131  "]
[6.0999999999999999E-2,0.23699999999999999,null,null,{"$f":"B7*(1-A7)/A7/(1-B7)","v":4.7814494123713551},{"$f":"3.765*A7^2-8.6392*A7+5.3118","v":4.7988183649999998},{"$f":"F7*A7/(1+(F7-1)*A7)","v":0.23765631634137274}]
[0.116781157998,0.36148022050500001,null,null,4.2815964491957406,4.3542506831442056,0.36537298642363603]
[0.19499105545600001,0.47400443131100001,null,null,3.7203717005215711,3.7703842652845605,0.47733484927428271]
[0.26047658175799998,0.53503069013399995,null,null,3.2669136337376865,3.3169386217871963,0.53880909739008542]
[0.31610942249200003,0.57339550913899995,null,null,2.9078904627736248,2.9570857309177829,0.57749407931428043]
[0.36395759717300002,0.60001345844300003,null,null,2.6215062258057125,2.6662287505159057,0.60406629310736681]
[0.40554821664500001,0.61982048992200001,null,null,2.3897438937842757,2.4274149721906486,0.62349914096605996]
[0.44203347799100001,0.63534413249099997,null,null,2.1992712507729371,2.228641264618199,0.63841208256316473]
[0.47429906542099998,0.64800232241,null,null,2.0404372551579431,2.0612084210389128,0.6503090620032278]
[0.50303699613499997,0.65864806612000004,null,null,1.9062294983888726,1.918681799334681,0.6601104642979615]
[0.52879581151800004,0.66782364989200005,null,null,1.7914893125268421,1.796215388834054,0.66840783779455382]
[0.55201592832299995,0.675889617153,null,null,1.6923640622884255,1.6901007600174109,0.67559638592194426]
[0.57305502846300005,0.68309473928300002,null,null,1.6059316864777822,1.5974591252623869,0.68194852450477061]
[0.59220661531499996,0.68961611900499997,null,null,1.5299427035250666,1.5160267711846753,0.68765692961125358]
[0.60971379011299998,0.695562788805,null,null,1.4624997277672489,1.4440027849959272,0.69286084894287447]
[0.62577962578000002,0.70107293317700003,null,null,1.4025035497348723,1.3799391842171316,0.69766277931891596]
[0.64057507987200002,0.70619985708499999,null,null,1.3486950641776709,1.322660440037934,0.70213936867632842]
[0.65424510180600004,0.71100106814300001,null,null,1.300175197459549,1.2712037159154486,0.70634873335751569]
[0.66691339748300005,0.71552200091899998,null,null,1.2562093750019894,1.2247739276946925,0.71033548272809577]
[0.67868618350599996,0.71979907061699999,null,null,1.2161918890116841,1.1827095562974677,0.71413423869452897]
[0.68965517241399998,0.72386184474600002,null,null,1.1796190563950206,1.144456361473722,0.71777214424121183]
[0.75675675675700005,0.75111508984399999,"共沸点0.745",null,0.97004615569241903,0.93017019722353567,0.74318561229137836]
[0.8,0.77211528192300005,null,null,0.84704591913674288,0.81003999999999898,0.76415984302479134]
[0.83018867924499995,0.78931473443,null,null,0.76631244570869816,0.73452182271338451,0.78218232122532361]
[0.85245901639300004,0.80386868705900005,null,null,0.70937739022019697,0.68321026605849333,0.79787514601011045]
[0.86956521739100001,0.81604617026500004,null,null,0.66542200135988094,0.64633308128608036,0.81163660844269303]
[0.88311688311699998,0.82742009826100005,null,null,0.6345552552165814,0.61868291448787538,0.82377280634721328]
[0.89411764705899999,0.83713757674800005,null,null,0.60870218590797753,0.59725439446333084,0.83453246424466165]
[0.90322580645200001,0.84580152876100001,null,null,0.58769449293949017,0.58020208116474059,0.84412068646891147]
[0.91089108910899996,0.85357846537799997,null,null,0.57028661387656732,0.56633520243097557,0.85270733401724252]
[0.91743119266100004,0.86060472018,null,null,0.55564596531357868,0.55485361501479247,0.86043344116559561]
[0.93023255814000005,0.875526146778,null,null,0.52753617975307898,0.53331216873909781,0.87670803930326124]
[0.939597315436,0.88755805646700003,null,null,0.50743789939488981,0.51833520111744313,0.88966116288243136]
[0.94674556213000005,0.89746928252000002,null,null,0.49236607704198521,0.50734749483588271,0.9001947302541542]
[0.95238095238099996,0.90577618182399999,null,null,0.48065138908463512,0.49895646258496384,0.9089180956819255]
[0.95693779904300003,0.91283940298999999,null,null,0.47128834064662378,0.49234623291600155,0.91625511217253353]
[0.96069868995600005,0.91891880136799997,null,null,0.46363563215418951,0.4870084056372761,0.92250855261087283]
[0.963855421687,0.92420647394599997,null,null,0.45726521217697352,0.48261027725324368,0.92789990577039039]
[0.96654275092899999,0.92884753966400002,null,null,0.45188057704620666,0.47892527466502877,0.93259465635251559]
[0.96885813148800004,0.93295369075099999,null,null,0.44726991744214301,0.47579391769719681,0.93671878325236801]
[0.97087378640800004,0.93661229974799998,null,null,0.44327793689473477,0.47310078235429387,0.94036980054099606]
[1,1]