{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Mw<150kDa","Mw<150kDa, CA<45","Mw<150kDa; CA>45"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":0,"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","formulas":"cached_only"}

{"sheet":"Mw<150kDa","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["REGRESSION USING OVERALL DATA FROM THE BAD"]
["but only protein with Mw <150kDa"]
[]
["First iteration: Breakpoint picked by the regression algorithm (Statistica)"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[1.498528571428572,-0.03039842352549161,0.1078055420774598,-0.3612569021799967,0.004337097174165426,0.09011873127569466,0.0012086878533286557,-1.341838234717946,4.064194100427096]
[null,2.683427089021107,1.0407741192704139,-1.8933404869396409,-0.0006556916781065325,-0.02947077030551603,0.000723034565518122,6.293946626128021,-33.70647805766504]
["Final loss:174.63961404 "]
["R= .90014 Variance explained: 81.024%"]
[]
[]
[1.498528571428572,"ave vals:",0.4742599047619047,0.09598285714285686,48.71190476190476,2.4323809523809548,332.62142857142857,0.15568285714285776,0.044205238095238304]
["normalised"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[null,null,0.0511278461184616,-0.03467446963381363,0.2112682644910725,0.2192030854077375,0.4020354804711108,-0.20890121020441843,0.17965866787464263]
[null,null,0.49359743468384176,-0.1817282294807146,-0.031939990577098926,-0.07168414034313145,0.24049679008915992,0.9798595934602602,-1.4900028878910085]
{"$rows_empty":7}
["Second iteration: Breakpoint picked by the user"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[2.6,0.18711005050529625,0.2142638203634392,-1.483932463240489,0.009218278658673865,0.1190975796145558,0.0012454651474647976,-1.4988365693800043,-0.2588802773808966]
[null,0.47143287568868636,0.6791112449782282,-2.010178409818911,0.0021135303417263935,1.1898627013237706,0.0023523560173984623,5.905392675810864,-44.21023103531499]
["Final loss:140.35100663 "]
["R= .92060 Variance explained: 84.750%"]
[]
[]
[2.6,null,0.4742599047619047,0.09598285714285686,48.71190476190476,2.4323809523809548,332.62142857142857,0.15568285714285776,0.044205238095238304]
["normalised"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[null,null,0.10161673903948654,-0.14243207762885954,0.4490399120900205,0.2896906841291198,0.41426839658566594,-0.23334315951127824,-0.01144386429978387]
[null,null,0.322075234366113,-0.1929426671413037,0.1029540887175721,2.8941993706484888,0.7824440190156728,0.9193684043207413,-1.954323789161593]

{"sheet":"Mw<150kDa, CA<45","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["REGRESSION USING HYDROPHILIC SURFACES DATA FROM THE BAD"]
["but only protein with Mw <150kDa; CONTACT ANGLE <45DEG"]
[]
["First iteration: Breakpoint picked by the regression algorithm (Statistica)"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[0.917345497630332,-0.1357038102020571,-0.0008382553528800484,-1.8226242786267923,0.011901218899179935,0.005741755834302582,0.00016926548587189392,-1.0751452688024266,17.15698546091185]
[null,-0.4579812220577433,-0.09798110204454352,-7.267275173682299,-0.011092323489330482,0.44478883900198146,0.003364378079067631,-6.549675072253077,44.15169354321701]
["Final loss:114.72283668 "]
["R= .77747 Variance explained: 60.446%"]
[]
[]
[0.917345497630332,"ave vals:",0.5273064454976305,0.11207582938388654,8.709715639810426,2.7079146919431305,274.09004739336496,0.14413886255924147,0.04233886255924176]
["normalised"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[null,null,-0.0004420174505465403,-0.20427212768230565,0.1036562323789949,0.015548184981258149,0.04639398504468835,-0.15497021613113168,0.7264072493604561]
[null,null,-0.05166606664504886,-0.8144858924513718,-0.09661098337685825,1.2044502319457933,0.9221425471408451,-0.9440627150471762,1.8693324846840267]
{"$rows_empty":7}
["Second iteration: Breakpoint picked by user"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[2.6,0.5275577340632748,0.11356561099288164,1.2860545080308612,-0.0011033013564894804,0.01628622479128921,0.0020966591697638742,-0.7194564928396571,-13.783531108710088]
[null,-105.68488741694965,1.3569812852014838,-155.0263945327133,0.05091229606919162,47.32733141356836,0.10377820239362434,-208.26884119137233,-28.798178053554082]
["Final loss:45.457160869 "]
["R= .91830 Variance explained: 84.327%"]
[]
[]
[2.6,"ave vals:",0.5273064454976305,0.11207582938388654,8.709715639810426,2.7079146919431305,274.09004739336496,0.14413886255924147,0.04233886255924176]
["normalised"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[null,null,0.05988387866342305,0.14413562562044493,-0.009609441080040486,0.044101707388620494,0.5746734112083135,-0.10370164053876922,-0.5835790291927097]
[null,null,0.7155449781064008,-17.374711743647456,0.44343162133249714,128.1583760652634,28.444572412466716,-30.019633875855703,-1.2192821025659988]

{"sheet":"Mw<150kDa; CA>45","index":2,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["REGRESSION USING HYDROPHOBIC SURFACES DATA FROM THE BAD"]
["but only protein with Mw <150kDa; CONTACT ANGLE >45DEG"]
[]
["First iteration: Breakpoint picked by the regression algorithm (Statistica)"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[2.0852732057416254,-1.1143133481743077,0.39980570670871846,-1.2420813603487064,0.024061314551282346,0.12482116744798419,2.061246700297879e-05,-0.9627636222921331,1.0608643594058322]
[null,1.07167016824677,0.9454235443985145,0.31355120047738694,0.01764413462763294,0.13094832986022942,0.000726030173566353,5.7067336292571795,-35.65992283744682]
["Final loss:71.039750342 "]
["R= .92420 Variance explained: 85.415%"]
[]
[]
[0.917345497630332,"ave vals:",0.34455058139534883,0.05121395348837218,91.69622093023256,2.335058139534881,397.8546511627907,0.1432156976744185,0.04374709302325583]
["normalised"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[null,null,0.13775328869166725,-0.0636118970176727,2.2063316149662056,0.2914646830356618,0.00820076586907466,-0.13788286386211818,0.046409731815983644]
[null,null,0.32574623188735957,0.016058196597472155,1.6179004669381967,0.30577196349862723,0.28885448143790177,0.8172938381561333,-1.560017961571911]
{"$rows_empty":7}
["Second iteration: Breakpoint picked by user"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[2.5,0.05096272697466499,0.5827653128787672,-2.2524926462657455,0.02053475435193937,0.20105825630405255,0.000431029667746348,1.529948114614846,-26.969267123811758]
[null,-0.6182357179784613,0.7092313215865713,-3.4492699545115966,0.023965321926682763,1.526240440523372,0.0026642400225094973,14.01330338199349,-115.27584782781592]
["Final loss:64.887207242 "]
["R= .93101 Variance explained: 86.678%"]
[]
[]
[2.6,"ave vals:",0.34455058139534883,0.05121395348837218,91.69622093023256,2.335058139534881,397.8546511627907,0.1432156976744185,0.04374709302325583]
["normalised"]
["Bkp","Const B0","sol_conc","IS","CA","abs(pI-pH)","residues","hydro","stdev"]
[null,null,0.20079212736942162,-0.11535905361875427,1.8829593718034867,0.46948271790346824,0.17148715810203685,0.21911258664022634,-1.1798270376344282]
[null,null,0.24436606419644477,-0.17665075101919653,2.197529454053249,3.5638601635314022,1.0599802847694617,2.006925020575486,-5.042983238258146]