{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":41,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Example enzyme kinetics calculation using the Solver function - Alanine racemase (Alr) with D-ala (DA) as a substrate"]
[]
["Substrate (mM)","Rate avg","Calc avg","delta^2",null,"Std dev",null,"Substrate (mM)","Rate1","Calc1","delta^2 1",null,"Substrate (mM)","Rate2","Calc2","delta^2 2",null,"Substrate (mM)","Rate3","Calc3","delta^2 3"]
[0.05,{"$f":"AVERAGE(I4,N4,S4)","v":1.3736766666666664E-3},{"$f":"VmaxAlrDA*A4/(KmAlrDA+A4)","v":1.6966835371792674E-4},{"$f":"(B4-C4)^2","v":1.4496360176496704E-6},null,{"$f":"STDEV(I4,N4,S4)","v":1.0236631737702339E-4},null,0.05,1.4368499999999993E-3,{"$f":"VmaxAlrDA1*H4/(KmAlrDA1+H4)","v":1.8815907879067445E-4},{"$f":"(I4-J4)^2","v":1.5592290167105921E-6},null,0.05,1.2555699999999988E-3,{"$f":"VmaxAlrDA2*M4/(KmAlrDA2+M4)","v":1.7047080608669052E-4},{"$f":"(N4-O4)^2","v":1.1774402606313115E-6},null,0.05,1.4286100000000009E-3,{"$f":"VmaxAlrDA3*R4/(KmAlrDA3+R4)","v":1.5174845911275018E-4},{"$f":"(S4-T4)^2","v":1.6303753945969645E-6}]
[0.5,{"$f":"AVERAGE(I5,N5,S5)","v":2.630276666666665E-3},1.6495852567175785E-3,{"$f":"(B5-C5)^2","v":9.6175564154792716E-7},null,{"$f":"STDEV(I5,N5,S5)","v":1.0759597777488385E-4},null,0.5,2.6470999999999982E-3,1.8223433801908234E-3,{"$f":"(I5-J5)^2","v":6.8022348191905564E-7},null,0.5,2.5152599999999983E-3,1.6549139124740924E-3,{"$f":"(N5-O5)^2","v":7.4019539032113373E-7},null,0.5,2.728469999999998E-3,1.4826134688707355E-3,{"$f":"(S5-T5)^2","v":1.5521584961574392E-6}]
[1,3.1754899999999991E-3,3.2004576431790012E-3,6.2338320591397086E-10,null,6.70229318144171E-4,null,1,2.7676099999999993E-3,3.5214820959251747E-3,5.6832313701461682E-7,null,1,2.8098399999999983E-3,3.2057831339527953E-3,1.5677096532436251E-7,null,1,3.9490199999999993E-3,2.8914012519543303E-3,1.1185574162176882E-6]
[2.5,7.0953266666666662E-3,7.3421054498430411E-3,6.0899767826012248E-8,null,9.2890544908151367E-6,null,2.5,7.094640000000001E-3,7.993110107623623E-3,8.0724853429320285E-7,null,2.5,7.1049399999999997E-3,7.3237864702261884E-3,4.789377753046209E-8,null,2.5,7.0863999999999996E-3,6.7261195998199116E-3,1.2980196675392435E-7]
[5,1.3654023333333334E-2,1.2911692608223151E-2,5.5105490544261019E-7,null,2.8295388564275521E-3,null,5,1.6695270000000002E-2,1.3859396190400535E-2,8.0421802639721913E-6,null,5,1.109928E-2,1.2807961635575996E-2,2.9195929317546621E-6,null,5,1.3167519999999999E-2,1.2055771838618752E-2,1.2359839743345812E-6]
[10,2.1871363333333334E-2,2.0801518824286699E-2,1.1445672735372355E-6,null,8.4571049758965032E-4,null,10,2.0895610000000002E-2,2.1893359843046509E-2,9.9550474929932896E-7,null,10,2.2325250000000001E-2,2.0473361178901264E-2,3.42949220571047E-6,null,10,2.2393230000000004E-2,1.9966191472155049E-2,5.8905160156438051E-6]
[15,2.5815919999999996E-2,2.6122284906415421E-2,9.3859455882932298E-8,null,1.3778043238428306E-3,null,15,2.6322679999999998E-2,2.713689901082848E-2,6.629525975945115E-7,null,15,2.6868579999999996E-2,2.5575579040961863E-2,1.6718514800735307E-6,null,15,2.4256499999999997E-2,2.5555657267904475E-2,1.687809606749029E-6]
[20,2.8720863333333332E-2,2.9953097077677102E-2,1.5184000006994673E-6,null,1.9184911537542552E-3,null,20,3.0627049999999999E-2,3.0828690682971952E-2,4.0658965029395556E-8,null,20,2.8745239999999998E-2,2.921608622751929E-2,2.2169616996914895E-7,null,20,2.67903E-2,2.9714956595009948E-2,8.5536161987351876E-6]
[30,3.5167976666666663E-2,3.5100567153586247E-2,4.5440424537387583E-9,null,1.3561409381525743E-3,null,30,3.4242349999999991E-2,3.5683140777072749E-2,2.075878063297921E-6,null,30,3.4536930000000007E-2,3.4065004552489744E-2,2.2271362800776199E-7,null,30,3.6724650000000005E-2,3.549133214979177E-2,1.5210729196422619E-6]
[40,3.5983049999999996E-2,3.8400116624614664E-2,5.8422110678261444E-6,null,2.706944840054929E-3,null,40,3.8617789999999999E-2,3.873266695863687E-2,1.3196715625657403E-8,null,40,3.3209259999999997E-2,3.7147654673249771E-2,1.5510952602282187E-5,null,40,3.6122099999999997E-2,3.9312352579618071E-2,1.0177711521759772E-5]
[50,4.3210216666666662E-2,4.0695404319690022E-2,6.3242811405061568E-6,null,2.5303713251879295E-3,null,50,4.4655649999999991E-2,4.0826096767900354E-2,1.4665477957484781E-5,null,50,4.0288449999999996E-2,3.9280420444158921E-2,1.0161235854491551E-6,null,50,4.4686549999999992E-2,4.2027155490821706E-2,7.072379155447613E-6]
[75,4.4248113333333332E-2,4.4219583395922642E-2,8.1395732865789444E-10,null,2.3190038461445741E-3,null,75,4.2143479999999997E-2,4.3996683825685987E-2,3.4343644195371873E-6,null,75,4.3866669999999996E-2,4.2536640003925097E-2,1.7689797904589973E-6,null,75,4.6734189999999995E-2,4.6289304879814377E-2,1.9792277016257128E-7]
[null,null,"sum:",{"$f":"SUM(D4:D15)","v":1.7952646653906468E-5},{"$nulls":5},"sum:",{"$f":"SUM(K4:K15)","v":3.3545237901778435E-5},null,null,null,"sum:",{"$f":"SUM(P4:P15)","v":2.8883702787513184E-5},null,null,null,"sum:",{"$f":"SUM(U4:U15)","v":4.076790543620084E-5}]
[null,"KmAlrDA",15.710944099153151,null,null,{"$f":"STDEV(KmAlrDA1,KmAlrDA2,KmAlrDA3)","v":2.7894896053170632},null,null,"KmAlrDA1",13.791188208906286,null,null,null,"KmAlrDA2",14.905798716317241,null,null,null,"KmAlrDA3",19.082623724559863]
[null,"VmaxAlrDA",5.3482668766871737E-2,null,null,{"$f":"STDEV(VmaxAlrDA1,VmaxAlrDA2,VmaxAlrDA3)","v":3.8087141870205231E-3},null,null,"VmaxAlrDA1",5.208690445512304E-2,null,null,null,"VmaxAlrDA2",5.0990541256817831E-2,null,null,null,"VmaxAlrDA3",5.8066923379720123E-2]
[]
[]
[]
[{"$nulls":11},"Rate - initial velocity in mM L-ala/min*ug enz"]
[{"$nulls":11},"Calc - calculated initial velocity based on Michaelis-Menten equation and estimated Km and Vmax values"]
[{"$nulls":11},"delta^2 - minimized squared difference between empirical and calculated data"]
[{"$nulls":11},"sum - sum of the minimized squared differences (Solver varies the Km and Vmax to minimize this value)"]