{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Feed","Combined Rotameter Graphs","Thermometer Calibration","Feed rotameter","Bottoms rotameter","Distillate rotameter","Reflux rotameter"],"not_rendered":{"charts":11,"images":0,"macros":1,"external_links":0,"defined_names":34,"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":"Feed","index":0,"n_rows":102,"n_cols":21,"rows_kept":102,"cut":false,"hidden":false,"merged":[[73,1,73,3],[30,3,30,4],[96,1,96,2],[96,6,96,7],[0,0,0,1],[6,0,6,4],[24,0,24,4],[30,0,30,2],[36,0,36,2],[20,0,20,4]]}
["Molecular Weights"]
["Methanol ",32]
["Water",18]
[]
[]
[]
["Rotameter Readings from Experiment"]
[null,"Feed","Distillate","Bottoms","Reflux"]
["rotameter reading/ %",47,28,31,22]
["gradient",0.1186,7.4700000000000003E-2,0.48330000000000001,0.1231,"Constants"]
["intercept",0.13780000000000001,-0.2591,-0.91900000000000004,-0.1,"Constants"]
["total mass flow/g/s",{"$f":"B10*B9+B11","v":5.7120000000000006},{"$f":"C10*C9+C11","v":1.8325},{"$f":"D10*D9+D11","v":14.0633},{"$f":"E10*E9+E11","v":2.6082000000000001},null,{"$f":"B12+E12","v":8.3201999999999998},{"$f":"C12+D12","v":15.895799999999999}]
[null,null,null,null,null,null,4.5]
["refractive index",1.3381810000000001,1.33954,1.3355300000000001,1.3355300000000001]
["mole fraction of methanol",0.15,0.16500000000000001,0.05,0.05]
["avg molecular weight g/mol",{"$f":"$B$2*B15+(1-B15)*$B$3","v":20.099999999999998},{"$f":"$B$2*C15+(1-C15)*$B$3","v":20.309999999999999},{"$f":"$B$2*D15+(1-D15)*$B$3","v":18.7},{"$f":"$B$2*E15+(1-E15)*$B$3","v":18.7},null,null,"Molar Balance Checker"]
[null,null,null,null,null,null,"Feed","Distillate","Bottoms",null,"Difference","% Difference"]
["total molar flow mol/s",{"$f":"B12/B16","v":0.28417910447761202},{"$f":"C12/C16","v":9.0226489414081734E-2},{"$f":"D12/D16","v":0.75204812834224599},{"$f":"E12/E16","v":0.13947593582887702},null,{"$f":"B18+E18","v":0.42365504030648904},{"$f":"C18+E18","v":0.22970242524295875},{"$f":"D18","v":0.75204812834224599},null,{"$f":"G18-(H18+I18)","v":-0.55809551327871565},{"$f":"100*K18/G18","v":-131.7334765744713}]
["molar flow of methanol",{"$f":"B18*B15","v":4.2626865671641805E-2},{"$f":"C18*C15","v":1.4887370753323487E-2},{"$f":"D18*D15","v":3.7602406417112301E-2},{"$f":"E18*E15","v":6.9737967914438514E-3},null,{"$f":"B19+E19","v":4.9600662463085657E-2},{"$f":"C19+E19","v":2.186116754476734E-2},{"$f":"D19","v":3.7602406417112301E-2},null,{"$f":"G19-(H19+I19)","v":-9.8629114987939803E-3},{"$f":"100*K19/G19","v":-19.884636633904364}]
["molar flow of water",{"$f":"B18*(1-B15)","v":0.24155223880597021},{"$f":"C18*(1-C15)","v":7.533911866075825E-2},{"$f":"D18*(1-D15)","v":0.71444572192513367},{"$f":"E18*(1-E15)","v":0.13250213903743316},null,{"$f":"B20+E20","v":0.37405437784340334},{"$f":"C20+E20","v":0.2078412576981914},{"$f":"D20","v":0.71444572192513367},null,{"$f":"G20-(H20+I20)","v":-0.54823260177992172},{"$f":"100*K20/G20","v":-146.56494730545236}]
["Calibrated Balance Sheets",null,null,null,null,null,{"$f":"SUM(G19:G20)","v":0.42365504030648898}]
["molar flow/mol/s",0.28417910447761202,9.0226489414081734E-2,0.75204812834224599,null,null,{"$f":"G19/G21","v":0.11707794725445153}]
["mole fraction",0.15,0.16500000000000001,0.05]
[]
["Mass Transfer Ratio"]
["Enthalpy of A","i(A)",5.4,"I(A)",40.700000000000003]
["Enthalpy of B","i(B)",7.5,"I(B)",48.1]
[]
["z",{"$f":"-(E27-C27)/((E26-E27)-(C26-C27))","v":7.6603773584905674}]
[]
["Operating Line",null,null,"Raw data"]
["Condensate m/g/s",{"$f":"E33/E32","v":4.4871794871794872},"Mass","Time/t",{"$f":"6.5*60","v":390}]
["Condensate n/mol/s",{"$f":"B32/B3","v":0.2492877492877493},"Molar","Water collected/ml",1750]
["Heat of Condensation",{"$f":"E27-C27","v":40.6}]
["Power/kW",{"$f":"B33*B34","v":10.121082621082621}]
[]
["Enthalpy of Bottom Product"]
["Vapour",{"$f":"(E26-E27)*D23+E27","v":47.730000000000004}]
["Liquid",{"$f":"(C26-C27)*D23+C27","v":7.3949999999999996}]
[]
[null,"Lb","xb","Vb","B","Balance","x","Diagonal"]
[null,0.98826800000000004,0.05,0.23622000000000001,0.75204800000000005,{"$f":"B42-(D42+E42)","v":0},0,0]
[null,"Lb*xb","Vb*yB","B*xB",null,null,1,1]
[null,{"$f":"B42*C42","v":4.9413400000000003E-2},{"$f":"D42*D23","v":1.1811000000000002E-2},{"$f":"D22*D23","v":3.7602406417112301E-2},null,{"$f":"B44-(C44+D44)","v":-6.4171122998724073E-9}]
[null,"Lb*ib","fii","Vb*Ib","B*iB",null,"xa","ya"]
[null,{"$f":"B42*((C26-C27)*C42+C27)","v":7.3082418599999999},{"$f":"B35","v":10.121082621082621},{"$f":"D42*B38","v":11.274780600000001},{"$f":"E42*B39","v":5.5613949600000003},{"$f":"B46+C46-(D46+E46)","v":0.5931489210826193},0,{"$f":"C23","v":0.16500000000000001}]
[null,null,null,null,null,null,1,{"$f":"H46","v":0.16500000000000001}]
[]
[]
["Data Calculations","x","L","V","L/V","y","alpha","y*","xi","alpha","yi","(y-yi)/(x-xi)"," -kx/ky","Solver","z/(abs(y-yi)*(z-y))","dy","Ny integ.","z/(abs(x-xi)*(z-x))","dx","Nx integ.","y-yi"]
[null,0.05,{"$f":"B42","v":0.98826800000000004},{"$f":"D42","v":0.23622000000000001},{"$f":"C51/D51","v":4.1836762340191349},{"$f":"B51*C51/D51-$D$44/D51","v":4.9999972834170264E-2},{"$f":"7.836-12.22*B51+7.749*B51^2","v":7.2443725000000008},{"$f":"G51*B51/(1+(G51-1)*B51)","v":0.27603527194258504},6.7466833894568954E-3,{"$f":"7.836-12.22*I51+7.749*I51^2","v":7.7539082459229718},{"$f":"J51*I51/(1+(J51-1)*I51)","v":5.0033321589735669E-2},{"$f":"(F51-K51)/(B51-I51)","v":-7.7101036819163943E-4},{"$f":"-D94","v":-7.7108731458598373E-4},{"$f":"1000000000*(M51-L51)","v":-76.946394344298142},null,null,null,null,null,null,{"$f":"F51-K51","v":-3.3348755565404398E-5}]
[null,{"$f":"B51+0.008846","v":5.8846000000000002E-2},{"$f":"$B$42*($B$29-$C$42)/($B$29-B52)","v":0.98941806020704437},{"$f":"C52-$E$42","v":0.23737006020704432},{"$f":"C52/D52","v":4.1682512922818979},{"$f":"B52*C52/D52-$D$44/D52","v":8.6872323897314668E-2},7.1437355179472846,0.30875481620261019,1.2159056005156835E-2,{"$f":"7.836-12.22*I52+7.749*I52^2","v":7.6885619682570994},{"$f":"J52*I52/(1+(J52-1)*I52)","v":8.6454597166737798E-2},8.9473993119577565E-3,{"$f":"M51+$D$99","v":-7.57915558725431E-4},{"$f":"1000000000*(M52-L52)","v":-9705314.8706831876},{"$f":"$B$29/(ABS(F52-K52)*($B$29-F52))","v":2421.3690035128398},{"$f":"F52-F51","v":3.6872351063144404E-2},{"$f":"O52*P52","v":89.281567950941565},{"$f":"$B$29/(ABS(B52-I52)*($B$29-B52))","v":21.585078154000648},{"$f":"B52-B51","v":8.8459999999999997E-3},{"$f":"R52*S52","v":0.19094160135028973},4.1772673057687004E-4]
[null,6.7692000000000002E-2,{"$f":"$B$42*($B$29-$C$42)/($B$29-B53)","v":0.99057080021237132},{"$f":"C53-$E$42","v":0.23852280021237127},{"$f":"C53/D53","v":4.1529396742382962},{"$f":"C53/D53*B53-$D$44/D53","v":0.12347378181306468},7.0443112809891364,0.33839052275397469,1.8012936299070501E-2,7.6183962044838713,0.12261225149323911,1.7341919425294013E-2,-7.4474380286487828E-4,-18086663.228158891,1179.7409069734183,{"$f":"F53-F52","v":3.6601457915750008E-2},{"$f":"O53*P53","v":43.180237158076316},20.308664206170864,{"$f":"B53-B52","v":8.8459999999999997E-3},{"$f":"R53*S53","v":0.17965044356778745},8.6153031982556805E-4]
[null,7.6537999999999995E-2,0.9917262293933532,{"$f":"C54-$E$42","v":0.23967822939335315},4.1377401356122343,{"$f":"C54/D54*B54-$D$44/D54","v":0.15980732094501357},6.9460997891255563,0.36536295852908451,2.4364396221756648E-2,{"$f":"7.836-12.22*I54+7.749*I54^2","v":7.5428670690215238},{"$f":"J54*I54/(1+(J54-1)*I54)","v":0.15850900500065587},2.4884536438694347E-2,-7.3157204700432556E-4,-25616108.485698674,786.63905181684311,3.6333539131948894E-2,28.581380771906442,19.360216210644946,8.8459999999999928E-3,0.17126047259936505,1.2983159443576975E-3]
[null,8.5383999999999988E-2,0.99288435717116574,{"$f":"C55-$E$42","v":0.24083635717116569},4.1226514502771243,{"$f":"C55/D55*B55-$D$44/D55","v":0.19587587227149128},6.849101042356545,0.39001999605279308,3.1279378703446145E-2,7.4613476102179268,0.19414771681154805,3.1940995399838516E-2,-7.1840029114377283E-4,-32659395.690982286,593.83603436506337,3.606855132647771E-2,21.418805485008271,18.691043404987177,8.8459999999999928E-3,0.16534096996051642,1.7281554599432314E-3]
[null,9.422999999999998E-2,0.99404519301104388,{"$f":"C56-$E$42","v":0.24199719301104383},4.1076724099261739,0.23168232417373402,6.7533150406821001,0.41265189320995421,3.8835863198213548E-2,7.3731129815887755,0.22953104649864067,3.8835837135456033E-2,{"$f":"M55+$D$99","v":-7.0522853528322011E-4},-39541065.670739256,479.33723209235472,3.5806451902242742E-2,17.163365545869066,18.277280180922091,8.8459999999999928E-3,0.16168082048043669,2.1512776750933493E-3]
[null,0.10307599999999997,0.99520874642253998,0.24316074642253993,4.0928018237498245,0.26722952320693349,6.6587417841022241,0.43350276969263096,4.7126762785419447E-2,7.277320959052811,0.2646617436782141,4.5894808518501543E-2,-6.9205677942266739E-4,-46586865.297924213,403.51811975600333,3.5547199033199472E-2,14.343938916469071,18.117123855688746,8.8459999999999928E-3,0.16026407762742251,2.5677795287193939E-3]
[null,0.11192199999999997,0.99637502695978286,0.24432702695978281,4.0780385181201835,0.30252027485459887,6.565381272616917,0.45277944618554922,5.6263526110077927E-2,7.1729898242206076,0.2995423844006444,5.3502912419840322E-2,-6.7888502356211466E-4,-54181797.443402439,349.61503296219411,3.5290751647665375E-2,12.338177300559137,18.233111123856375,8.8459999999999928E-3,0.16129010100163335,2.9778904539544682E-3]
[null,0.12076799999999996,0.99754404422173959,0.24549604422173954,4.0633813362822551,0.33755734426665096,6.473233506226177,0.47065832726176277,6.6380946335880028E-2,7.058970262127974,0.33417562834480891,6.2178693163388449E-2,{"$f":"M58+$D$99","v":-6.6571326770156194E-4},-62844406.43109002,309.33900328773103,3.5037069412052091E-2,10.838332130047242,18.681243743630485,8.8459999999999928E-3,0.16525428215615515,3.3817159218420545E-3]
[null,0.12961399999999995,0.99871580785247926,0.24666780785247922,4.0488291380517953,{"$f":"C60/D60*B60-$D$44/D60","v":0.37234345698165566},6.3822984849300042,0.48729081515250527,7.7643304921652972E-2,6.933913527068067,0.36856397632070109,7.2723304070821435E-2,-6.5254151184100922E-4,-73375845.582662448,278.10426698930047,3.4786112715004702E-2,9.6741663780135667,19.572785552924646,8.8459999999999928E-3,0.17314086100117126,3.7794806609545706E-3]
[null,0.13845999999999994,0.99989032754143736,0.24784232754143731,4.0343807995196599,{"$f":"C61/D61*B61-$D$44/D61","v":0.40688129963359454},6.2925762087284012,0.50280760766863231,9.0252560588923184E-2,6.7962333804483093,0.40270989148098602,8.6530382106336234E-2,-6.393697559804565E-4,-87169751.862316698,253.17458045798639,3.4537842651938877E-2,8.7441038233285742,21.125526540138928,8.8459999999999928E-3,0.1868764077740688,4.1714081526085245E-3]
[null,0.14730599999999994,1.0010676130236837,0.24901961302368369,4.0200352127624361,0.44117352064355581,6.2040666776213653,0.51732213968456897,0.10445915678761916,6.6440639869749054,0.43661587929171441,0.10637052837825964,-6.2619800011990377E-4,-106996726.37837954,232.82022929268791,3.4292221009961266E-2,7.9839227584947121,23.796540239301248,8.8459999999999928E-3,0.21050419495685865,4.5576413518413905E-3]
[null,0.15615199999999993,1.0022476740801907,0.25019967408019061,4.0057912855592441,0.4752227308967204,6.1167698916088966,0.53093336088494514,0.12057615425930586,6.4752190759060273,0.47028431240094049,0.13881380450587624,-6.1302624425935105E-4,-139426830.7501356,215.8868326460971,3.4049210253164597E-2,7.3507761556567193,28.693865803397838,8.8459999999999928E-3,0.25382593689685706,4.9384184957799171E-3]
[null,0.16500000000000001,{"$f":"$B$42*($B$29-$C$42)/($B$29-B64)","v":1.0034307882846032},0.25138278828460314,3.9916447547258826,0.50903912126622253,6.030666525,0.54373080081238179,0.13900217855373592,6.2871165001985112,0.5037249739468197,0.20440740892027617,-5.9985448839879833E-4,-205007263.40867499,201.57155902033861,3.3816390369502125E-2,6.816422527220908,39.311508090152962,8.848000000000078E-3,0.34782822358167648,5.3141473194028288E-3]
[]
[]
[]
[]
["No. of data points",{"$f":"COUNT(B51:B65)","v":14},null,null,null,null,null,null,null,null,null,null,null,null,null,"Ny",{"$f":"SUM(Q52:Q64)","v":277.71519690159153},null,"Nx",{"$f":"SUM(T52:T64)","v":2.5278583929542386}]
[]
[]
["Column diameter/m",0.156,null,"Packing height/m",2.5399999999999999E-2]
["Column area/m2",{"$f":"PI()*(B72/2)^2","v":1.9113449704440302E-2}]
["Area","Mass Transfer Coeff in the gas phase",null,null,null,null,"Mass Transfer Coef in liquid"]
[null,"Bottom","Top",null,null,null,"Bottom","Top"]
["T/K",373,353,null,null,"T/K",373,353]
["Pressure/Pa",101325,101325,null,null,"Pressure/Pa",101325,101325]
["z",1,1,null,null,"z",1,1]
["Density/kg/m3",{"$f":"0.001*$C$16*B77/(B78*8.31441*B76)","v":0.66356927278291966},{"$f":"0.001*$C$16*C77/(C78*8.31441*C76)","v":0.70116526557515302},null,null,"Density/kg/m3",965,978]
["Viscosity/kg/m/s",1.2E-5,1.1E-5,null,null,"Viscosity/kg/m/s",3.1700000000000001E-4,4.06E-4]
["Diffusion Rate/m2/s",2.0000000000000002E-5,2.0000000000000002E-5,null,null,"Diffusion Rate/m2/s",5.0000000000000001E-9,5.0000000000000001E-9]
[]
["Molar Flow Rate/mol/s",{"$f":"D51","v":0.23622000000000001},{"$f":"D64","v":0.25138278828460314},null,null,"Molar Flow Rate/mol/s",{"$f":"C51","v":0.98826800000000004},{"$f":"C64","v":1.0034307882846032}]
["Molecular Weight/g/mol",{"$f":"$C$16","v":20.309999999999999},{"$f":"$C$16","v":20.309999999999999},"kg/hr","kg/hr","Molecular Weight/g/mol",{"$f":"$D$16","v":18.7},{"$f":"$D$16","v":18.7}]
["Mass Flow Rate/kg/s",{"$f":"B84*0.001*B83","v":4.7976282E-3},{"$f":"C84*0.001*C83","v":5.1055844300602893E-3},{"$f":"B85*3600/B73","v":903.6286901148784},{"$f":"G85*3600/B73","v":3480.80554733896},"Mass Flow Rate/kg/s",{"$f":"G84*0.001*G83","v":1.8480611600000002E-2},{"$f":"H84*0.001*H83","v":1.8764155740922082E-2}]
["Volumetric Flow Rate/m3/s",{"$f":"B85/B79","v":7.2300336932109542E-3},{"$f":"C85/C79","v":7.2815706663282471E-3},null,null,"Volumetric Flow Rate/m3/s",{"$f":"G85/G79","v":1.9150892849740933E-5},{"$f":"H85/H79","v":1.918625331382626E-5}]
["Linear Velocity/m/s",{"$f":"B86/$B$73","v":0.37826942833513322},{"$f":"C86/$B$73","v":0.38096580046649786},null,null,"Linear Velocity/m/s",{"$f":"G86/$B$73","v":1.0019589946283706E-3},{"$f":"H86/$B$73","v":1.003809025085045E-3}]
[]
["a/m2/m3",255.9,255.9,null,null,"a/m2/m3",255.9,255.9]
["Sc",{"$f":"B80/(B79*B81)","v":0.90420099997047965},{"$f":"C80/(C79*C81)","v":0.78440850824069985},null,null,"Sc",{"$f":"G80/(G79*G81)","v":65.699481865284966},{"$f":"H80/(H79*H81)","v":83.02658486707567}]
["Re",{"$f":"(B79*B87)/(B80*B89)","v":81.740253183650879},{"$f":"(C79*C87)/(C80*C89)","v":94.895018174408577},null,null,"Re",{"$f":"(G79*G87)/(G80*G89)","v":11.919216642645276},{"$f":"(H79*H87)/(H80*H89)","v":9.4491693235039662}]
["k'y/m/s",{"$f":"0.523*B91^0.7*B90^0.333*(B89*$E$72)^-2*(B89*B81)","v":1.3363966851869372E-3},{"$f":"0.523*C91^0.7*C90^0.333*(C89*$E$72)^-2*(C89*C81)","v":1.4149690456340032E-3},"bottom",null,"k'x/m/s",{"$f":"0.000051*G91^0.667*G90^-0.5*(G89*$E$72)^0.4*(G79/(G80*9.81))^-0.333","v":1.0304785312024058E-6},{"$f":"0.000051*H91^0.667*H90^-0.5*(H89*$E$72)^0.4*(H79/(H80*9.81))^-0.333","v":8.4877553296892046E-7}]
[null,{"$f":"1/B92","v":748.28081443506312},null,"kx/ky","kx/ky",null,{"$f":"1/G92","v":970422.93431689241}]
["(phi)y,k",1,1,{"$f":"G92/B92","v":7.7108731458598373E-4},{"$f":"H92/C92","v":5.99854488398798E-4},"(phi)x,k",1,1]
[]
["Hy",{"$f":"(B94*B87)/(B92*B89)","v":1.106102993007031},{"$f":"(C94*C87)/(C92*C89)","v":1.0521284529204569},null,null,"Hx",{"$f":"(G94*G87)/(G92*G89)","v":3.7996248051288268},{"$f":"(H94*H87)/(H92*H89)","v":4.6215532157074861}]
["Average Hy",{"$f":"AVERAGE(C96,B96)","v":1.0791157229637438},null,null,null,"Average Hx",{"$f":"AVERAGE(H96,G96)","v":4.2105890104181567}]
[null,null,null,{"$f":"D94-E94","v":1.7123282618718573E-4}]
[null,null,null,{"$f":"D98/(B69-1)","v":1.3171755860552749E-5}]
["Ny",{"$f":"Q69","v":277.71519690159153},null,null,null,"Nx",{"$f":"T69","v":2.5278583929542386}]
[]
["h=Hy*Ny",{"$f":"B96*Q69","v":307.18161049638729},null,null,null,"h=Hx*Nx",{"$f":"G96*T69","v":9.604913453722018}]

{"sheet":"Combined Rotameter Graphs","index":1,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,15,0,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Run"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distillate",null,null,"Reflux"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% reading","Mass Flow",null,"% reading","Mass Flow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"0.0747 * P4 - 0.2591","v":1.8325},null,22,{"$f":"0.1231 * S4 - 0.1","v":2.6082000000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed",null,null,"Bottoms"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% reading","Mass Flow",null,"% reading","Mass Flow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"0.1186 * P8 + 0.1378","v":5.7120000000000006},null,31,{"$f":"0.4833 * S8 - 0.919","v":14.0633}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Readings",null,null,"There is one rotameter with scale from 0-0.1"]
[null,null,null,"0 on the rotameter = 0%",null,null,"0=0%"]
[null,null,null,"1 on the rotameter = 100%",null,null,"0.1=100%"]

{"sheet":"Thermometer Calibration","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,0,21,5]]}
[]
["Koska ikivanha lämpömittari meni rikki, laitoin tilalle uudemman"]
["lämpömittarin. ",null,null,null,null,null,null,null,null,"T2-3","Correction"]
["Kalibrointikäyrä Frontek:in kanssa (valm. nro. 1311601), (anturin nro. T2-3)",null,null,null,null,null,null,null,null,19.975000000000001,{"$f":"0.025","v":2.5000000000000001E-2}]
[null,null,null,null,null,null,null,null,null,49.96,0.04]
["Findip lämpömittari, kanava 3",null,null,null,null,null,null,null,null,79.944999999999993,5.5E-2]
[null,null,null,null,null,null,null,null,null,99.935000000000002,6.5000000000000002E-2]
[null,"Original T","Corrected T",null,"Difference"]
[null,"Frontek","Frontek","Findip","Findip"]
[null,"T/C, näyttämä","T/C, calibr.","T/C, näyttämä","T/C, korjaus"]
[null,20.6,{"$f":"(0.00050025*B11+0.0150075)+B11","v":20.625312650000001},20.45,{"$f":"C11-D11","v":0.17531265000000218}]
[null,29.945,{"$f":"(0.00050025*B12+0.0150075)+B12","v":29.974987486250001},29.8,{"$f":"C12-D12","v":0.17498748625000005}]
[null,40.005000000000003,40.040020001249999,39.799999999999997,{"$f":"C13-D13","v":0.24002000125000222}]
[null,50.774999999999999,50.815407693749997,50.48,0.33540769374999968]
[null,59.96,60.005002490000003,59.5,0.50500249000000252]
[null,69.844999999999999,69.894947461249998,69.2,0.69494746124999551]
[null,79.849999999999994,79.904952462499992,78.98,0.92495246249998786]
[null,89.875,89.934967468750003,88.63,1.3049674687500072]
[]
[null,null,null,100,{"$f":"0.00028336*D20^2-0.01480591*D20+0.36609879","v":1.7191077900000002}]
[]
["Graph for correcting the raw temperature"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"."]

{"sheet":"Feed rotameter","index":3,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Data Plots for establishing trendline"]
[null,null,"grammaa",null,null,"Reading","Mass Flow"]
[null,"aika/s","astia","astia+liuos","liuos","lukema/%","massavirta"]
[null,225,270,1815,{"$f":"D6-C6","v":1545},56.5,{"$f":"E6/B6","v":6.8666666666666663}]
[null,247,274,1704,{"$f":"D7-C7","v":1430},48,{"$f":"E7/B7","v":5.7894736842105265}]
[null,342,274,1747,{"$f":"D8-C8","v":1473},35,{"$f":"E8/B8","v":4.307017543859649}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"min",{"$f":"(0.1186*20+0.1378)*60/1000/0.997","v":0.15104112337011033},"l/min"]
[null,null,null,null,null,null,null,null,"max",{"$f":"(0.1186*100+0.1378)*60/1000/0.997","v":0.72203410230692067},"l/min"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"feed rate"]
[null,"syoton tiheys"]
[null,null,"astia","astia+liuos","liuos","tilavuus"]
[null,null,95.64,342.33499999999998,{"$f":"D34-C34","v":246.69499999999999},250,{"$f":"E34/F34","v":0.98677999999999999}]
[null,null,"vessel?","ves+solution","solution","volume"]

{"sheet":"Bottoms rotameter","index":4,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Data Plots for establishing trendline"]
[null,null,"grammaa",null,null,"Reading","Mass Flow"]
[null,"aika/s","astia","astia+liuos","liuos","lukema/%","massavirta"]
[null,68,52,424,{"$f":"D6-C6","v":372},12.5,{"$f":"E6/B6","v":5.4705882352941178}]
[null,85,53,373,320,8.8000000000000007,3.7647058823529411]
[null,235,53,364,311,5,1.323404255319149]
[null,57,53,408,355,15,6.2280701754385968]
[null,51,53,420,367,17,7.1960784313725492]
[null,70,53,299,246,10,3.5142857142857142]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"min",{"$f":"(0.4833*5-0.919)*60/1000/0.997","v":9.0120361083249764E-2},"l/min"]
[null,null,null,null,null,null,null,null,null,"max",{"$f":"(0.4833*20-0.919)*60/1000/0.997","v":0.52639919759277831},"l/min"]

{"sheet":"Distillate rotameter","index":5,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Data Plots for establishing trendline"]
[null,null,"grammaa",null,null,"Reading","Mass Flow"]
[null,"aika/s","astia","astia+liuos","liuos","lukema/%","massavirta"]
[null,null,null,null,null,14.4,0.81]
[null,69,54,133,{"$f":"D7-C7","v":79},19.399999999999999,{"$f":"E7/B7","v":1.144927536231884}]
[null,124,54,147,{"$f":"D8-C8","v":93},13.5,{"$f":"E8/B8","v":0.75}]
[null,110,54,154,100,15.5,0.90909090909090906]
[null,84,54,153,99,18.5,1.1785714285714286]
[null,205,54,150,96,10,0.4682926829268293]
[null,257,54,114,60,7,0.23346303501945526]
[null,240,54,71,17,4,7.0833333333333331E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"min",{"$f":"(0.0747*4-0.2591)*60/1000/0.997","v":2.3891675025075232E-3},"l/min"]
[null,null,null,null,null,null,null,null,"max",{"$f":"(0.0747*20-0.2591)*60/1000/0.997","v":7.4316950852557684E-2},"l/min"]

{"sheet":"Reflux rotameter","index":6,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Data Plots for establishing trendline"]
[null,null,"grammaa",null,null,"Reading","Mass Flow"]
[null,"aika/s","astia","astia+liuos","liuos","lukema/%","massavirta"]
[null,339,274,1080,{"$f":"D6-C6","v":806},20,{"$f":"E6/B6","v":2.3775811209439528}]
[null,249,274,1172,898,30,3.606425702811245]
[null,244,274,1446,1172,40,4.8032786885245899]
[null,168,274,1283,1009,50,6.0059523809523814]
[null,129,274,1216,942,60,7.3023255813953485]
[null,129,274,1375,1101,70,8.5348837209302317]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"min",{"$f":"(0.1231*15-0.1)*60/1000/0.997","v":0.10510531594784353},"l/min"]
[null,null,null,null,null,null,null,null,"max",{"$f":"(0.1231*100-0.1)*60/1000/0.997","v":0.73480441323971923},"l/min"]