{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["20140121 - root length","20140224","20140315","20140410","Summary","Analysis"],"not_rendered":{"charts":4,"images":0,"macros":0,"external_links":1,"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":"20140121 - root length","index":0,"n_rows":43,"n_cols":19,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,10,2,10]],"flags":["formulas_cached_only"]}
["Root Length","PNS","DMSO 0.2%","1µM C14","10µM C14","20µM C14","50µM C14",null,null,null,"Number of Secondary roots","PNS","DMSO 0.2%","200nM IAA","10µM IAA","1µM C14","10µM C14","20µM C14","50µM C14"]
[null,50,52,40,21,14,0,{"$nulls":4},4,11,7,3,8,4,6,1]
[null,51,56,42,21,7,0,{"$nulls":4},5,12,2,5,9,3,7,1]
[null,52,48,31,19,11,0,{"$nulls":4},6,10,5,3,1,6,6,1]
[null,61,45,25,21,7,0,{"$nulls":4},5,5,10,3,1,8,7,1]
[null,52,33,34,22,11,0,{"$nulls":4},8,4,3,4,2,9,5,1]
[null,55,40,24,22,12,1,{"$nulls":4},6,4,5,3,1,8,9,1]
[null,44,23,51,17,9,1,{"$nulls":4},3,1,1,3,10,3,5,1]
[null,31,40,41,18,8,1,{"$nulls":4},1,4,5,3,4,3,8,1]
[null,31,20,47,17,9,1,{"$nulls":4},1,4,2,5,11,2,11,1]
[null,29,24,26,19,9,1,{"$nulls":4},1,2,3,3,2,5,12,1]
[null,28,32,23,19,10,1,{"$nulls":4},2,0,7,4,1,4,5,1]
[null,50,48,34,20,9,0,{"$nulls":4},6,4,5,4,5,9,2,0]
[null,47,25,23,26,11,0,{"$nulls":4},6,1,9,3,0,8,2,0]
[null,42,46,26,18,8,0,{"$nulls":4},7,9,8,7,2,2,9,0]
[null,52,40,56,17,7,1,{"$nulls":4},4,5,8,6,15,5,11,0]
[null,52,51,40,26,8,1,{"$nulls":4},4,7,4,3,7,9,16,1]
[null,62,48,45,20,8,1,{"$nulls":4},6,8,4,4,3,7,4,1]
[null,51,23,26,23,14,1,{"$nulls":4},5,2,2,4,2,8,5,1]
[null,57,43,44,21,11,1,{"$nulls":4},8,4,4,3,5,6,5,1]
[null,56,34,54,5,11,1,{"$nulls":4},6,0,5,3,11,7,4,1]
[null,41,38,53,20,8,1,{"$nulls":4},4,1,1,null,12,3,4,1]
[null,48,46,41,25,7,1,{"$nulls":4},5,4,2,null,10,8,4,1]
[null,27,51,null,19,8,1,{"$nulls":4},0,8,0,null,4,6,5,1]
[null,64,37,null,11,9,1,{"$nulls":4},4,4,null,null,null,4,6,0]
[null,54,35,null,19,9,1,{"$nulls":4},6,2,null,null,null,4,4,0]
[null,47,41,null,22,9,1,{"$nulls":4},5,5,null,null,null,10,7,0]
[null,37,41,null,29,9,{"$nulls":5},3,5,null,null,null,6,8]
[null,48,null,null,19,9,{"$nulls":5},4,{"$nulls":4},8,10]
[null,28,null,null,16,8,{"$nulls":5},2,{"$nulls":4},1,7]
[{"$nulls":5},6,{"$nulls":11},5]
[{"$nulls":5},8,{"$nulls":11},8]
[{"$nulls":5},12,{"$nulls":11},6]
[null,"PNS","DMSO 0.2%","1µM C14","10µM C14","20µM C14","50µM C14",{"$nulls":4},"PNS","DMSO 0.2%","200nM IAA","10µM IAA","1µM C14","10µM C14","20µM C14","50µM C14"]
["Average Root length",46.44827586206897,39.25925925925926,37.54545454545455,19.724137931034484,9.25,0.6923076923076923,null,null,null,"Average Roots",4.379310344827586,4.666666666666667,4.434782608695652,3.8,5.478260869565218,5.724137931034483,6.65625,0.7307692307692307]
["Std Dev",10.81528748345386,9.948299400835348,10.922790820452404,4.487256175024507,1.9338523589551917,0.47067872433164143,null,null,null,"Std Dev",2.094444916293853,3.269909431820351,2.727404476396124,1.1516578439248717,4.39906565717386,2.5198717615349557,3.0119051413756646,0.45234432086120474]
["n ",29,27,22,29,32,26,null,null,null,"n ",29,27,23,20,23,29,32,26]
["Sqrt n",5.385164807134504,5.196152422706632,4.69041575982343,5.385164807134504,5.656854249492381,5.0990195135927845,null,null,null,"Sqrt n",5.385164807134504,5.196152422706632,4.795831523312719,4.47213595499958,4.795831523312719,5.385164807134504,5.656854249492381,5.0990195135927845]
["Std Error",2.008348466722001,1.9145511123504269,2.3287468275229384,0.8332625529082401,0.34186002920770436,0.09230769230769227,null,null,null,"Std Error",0.3889286570243941,0.629294363562392,0.5687031462923806,0.2575185225836856,0.9172685979042079,0.467928438921037,0.5324346374393398,0.08871201995900611]
[]
[]
[null,"PNS","DMSO 0.2%","1µM C14","10µM C14","20µM C14","50µM C14"]
["root number/root length",0.09428359317000742,0.11886792452830189,0.14591009579955785,0.2902097902097902,0.7195945945945946,1.0555555555555556]

{"sheet":"20140224","index":1,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,15],[0,16,0,20],[0,25,0,32],[0,33,0,37],[1,0,1,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,25,1,26],[1,27,1,28],[1,29,1,30],[1,31,1,32],[1,33,1,34],[1,35,1,36],[38,0,38,1],[38,2,38,3],[38,4,38,5],[38,6,38,7],[38,25,38,26],[38,27,38,28],[38,29,38,30],[38,31,38,32],[38,33,38,34],[38,35,38,36],[39,4,39,5],[39,6,39,7],[39,8,39,9],[39,10,39,11],[39,12,39,13],[39,14,39,15],[49,0,51,0]],"flags":["formulas_cached_only"]}
[{"$nulls":8},"2/24/2014 Primary root length and lateral root number",{"$nulls":7},"2/24/2014 Primary root length and lateral root number"]
["PNS",null,"PNS+DMSO",null,"PNS+1µMC14",null,"PNS+10µMC14",null,"PNS+20µMC14",null,"PNS+50µMC14",null,"PNS+20µMC8",null,"PNS+50µMC8"]
["Length (mm)","number","Length (mm)","number","Length (mm)","number","Length (mm)","number","Length (mm)","number","Length (mm)","number","Length (mm)","number","Length (mm)","number"]
[51,12,47,7,25,0,21,10,13,1,0,0,20,1,10,2]
[44,8,37,3,17,0,16,2,15,3,0,0,45,8,35,11]
[46,9,25,0,37,2,19,8,14,6,1,1,43,4,30,4]
[42,8,36,1,14,0,20,6,13,4,1,1,34,0,25,1]
[22,0,29,0,24,2,36,10,16,5,1,1,42,7,35,12]
[41,4,42,5,28,1,18,2,8,4,1,1,44,5,49,14]
[44,8,49,5,43,9,18,2,7,5,1,1,45,6,42,9]
[50,9,30,0,20,1,22,5,19,7,1,1,34,3,47,15]
[48,10,32,2,42,3,37,12,21,5,1,1,42,9,48,13]
[49,8,29,1,35,7,22,8,15,4,1,1,37,4,43,11]
[46,5,36,5,37,6,32,8,16,5,1,1,35,4,45,12]
[48,8,33,3,40,9,31,8,15,2,1,1,44,11,43,12]
[27,0,40,3,38,12,18,5,16,4,1,1,39,8,44,11]
[45,11,49,12,47,13,23,3,15,8,1,1,41,4,45,8]
[51,7,27,1,34,6,36,6,13,3,1,1,56,13,35,8]
[49,11,41,6,38,5,20,8,19,10,1,1,47,11,37,4]
[48,11,48,11,35,6,24,10,17,6,1,1,43,5,32,4]
[34,2,43,10,45,8,27,13,21,10,1,1,35,6,42,6]
[40,2,46,11,40,9,23,12,22,11,1,0,53,13,30,2]
[39,3,43,7,48,12,27,7,16,5,1,0,46,11,31,2]
[33,14,{"$nulls":4},35,14,12,2,0,0,37,2,34,4]
[48,7,{"$nulls":4},26,11,17,1,0,0,48,6]
[36,7,{"$nulls":4},23,7,22,10,0,0,43,6]
[55,13,{"$nulls":6},22,6,0,0,50,11]
[53,9]
[47]
{"$rows_empty":9}
["PNS",null,"PNS+DMSO"]
["Length (mm)","number","Length (mm)","number","PNS+1µMC14",null,"PNS+10µMC14",null,"PNS+20µMC14",null,"PNS+50µMC14",null,"PNS+20µMC8",null,"PNS+50µMC8"]
[43.69230769230769,7.44,38.1,4.65,"Length (mm)","number","Length (mm)","number","Length (mm)","number","Length (mm)","number","Length (mm)","number","Length (mm)","number"]
[7.943647679846988,3.8522720568516444,7.785952262349093,3.9506828190633203,34.35,5.55,24.956521739130434,7.695652173913044,16,5.291666666666667,0.75,0.6666666666666666,41.791666666666664,6.583333333333333,37.23809523809524,7.857142857142857,"Average "]
[26,25,20,20,9.879670780792347,4.285532577601552,6.5399350905144535,3.521812325399519,4.0324768524093715,2.851074041200228,0.4423258684646914,0.48154341234307685,7.389647086158513,3.6821150191829637,9.262314839740453,4.530846656925329,"Std Dev"]
[5.0990195135927845,5,4.47213595499958,4.47213595499958,20,20,23,23,24,24,24,24,24,24,21,21,"n "]
[1.557877481870994,0.7704544113703289,1.7409918528180848,0.8833995340966085,4.47213595499958,4.47213595499958,4.795831523312719,4.795831523312719,4.898979485566356,4.898979485566356,4.898979485566356,4.898979485566356,4.898979485566356,4.898979485566356,4.58257569495584,4.58257569495584,"Sqrt n"]
[{"$nulls":4},2.209161546117011,0.9582742163306963,1.3636707333699236,0.7343486334496647,0.8231258906656127,0.5819730516529452,0.09028938981432691,0.09829463743659811,1.50840539502774,0.7516085809363796,2.0212028030296856,0.9887117984570445,"Std Error"]
[]
[]
[null,"PNS","DMSO 0.2%","1µM C14","10µM C14","20µM C14","50µM C14"]
["root number/root length",0.17028169014084507,0.1220472440944882,0.1615720524017467,0.3083623693379791,0.3307291666666667,0.8888888888888888]
[]
[]
[]
[null,null,"            "]

{"sheet":"20140315","index":2,"n_rows":33,"n_cols":23,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,15,1,15],[32,0,35,0]],"flags":["formulas_cached_only"]}
["Root Length","PNS","DMSO 0.1%","DMSO 0.2%","20µM C8BH","50µM C8BH","20µM C14BH","50µM C14BH",{"$nulls":7},"Number of Secondary roots","PNS","DMSO 0.1%","DMSO 0.2%","20µM C8BH","50µM C8BH","20µM C14BH","50µM C14BH"]
[null,37,30,31,20,29,12,1,{"$nulls":8},9,5,7,1,5,4,1]
[null,26,30,21,28,30,12,1,{"$nulls":8},5,6,3,6,6,6,1]
[null,30,37,33,20,30,15,1,{"$nulls":8},6,6,7,0,5,5,1]
[null,33,29,35,15,23,13,1,{"$nulls":8},6,4,8,1,2,8,1]
[null,30,36,15,30,20,14,1,{"$nulls":8},4,6,0,3,1,5,1]
[null,27,23,19,25,32,18,1,{"$nulls":8},3,4,0,4,7,8,1]
[null,36,24,37,33,22,12,1,{"$nulls":8},4,3,6,9,4,7,1]
[null,33,32,38,33,22,13,1,{"$nulls":8},3,3,9,4,2,7,1]
[null,27,23,30,26,32,14,1,{"$nulls":8},5,5,5,8,6,10,1]
[null,24,16,25,30,30,13,1,{"$nulls":8},3,3,2,9,6,6,1]
[null,25,20,20,32,24,15,1,{"$nulls":8},2,1,0,5,4,8,1]
[null,30,21,null,32,32,11,1,{"$nulls":8},5,1,null,6,6,4,1]
[null,26,26,null,32,29,10,1,{"$nulls":8},3,1,null,2,5,7,1]
[null,null,33,null,25,18,10,1,{"$nulls":9},3,null,3,3,5,1]
[null,null,38,null,21,26,14,1,{"$nulls":9},3,null,3,4,4,0]
[null,null,17,null,26,20,null,0,{"$nulls":9},7,null,2,2,5,0]
[null,null,25,null,25,12,null,0,{"$nulls":9},0,null,3,0,null,0]
[null,null,31,{"$nulls":4},0,{"$nulls":9},2,{"$nulls":4},0]
[null,null,29,{"$nulls":4},0,{"$nulls":9},5,{"$nulls":4},1]
[{"$nulls":17},4]
[]
[]
[]
[]
[]
["Average ",29.53846153846154,27.36842105263158,27.636363636363637,26.647058823529413,25.352941176470587,13.066666666666666,0.7894736842105263,{"$nulls":7},"Average ",4.461538461538462,3.5789473684210527,4.2727272727272725,4.0588235294117645,4,6.1875,0.7894736842105263]
[]
[]
[]
[]
[null,"PNS","DMSO 0.1%","DMSO 0.2%","20µM C8BH","50µM C8BH","20µM C14BH","50µM C14BH"]
["Lateral root number/mm primary root",0.15104166666666666,0.13076923076923078,0.15460526315789472,0.15231788079470196,0.1577726218097448,0.47353316326530615,1]

{"sheet":"20140410","index":3,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,8,1,8],[32,0,35,0]],"flags":["formulas_cached_only"]}
["Root Length","PNS","DMSO 0.2%","20µM C14BH","50µM C14BH",null,null,null,"Number of Secondary roots","PNS","DMSO 0.2%","20µM C14BH","50µM C14BH"]
[null,31,34,19,1,{"$nulls":4},5,6,7,1]
[null,36,32,15,1,{"$nulls":4},5,7,8,1]
[null,30,36,12,{"$nulls":5},3,7,6]
[null,40,36,20,{"$nulls":5},5,4,9]
[null,32,34,16,{"$nulls":5},4,6,9]
[null,37,45,13,{"$nulls":5},4,11,6]
[null,33,34,18,{"$nulls":5},5,3,5]
[null,16,30,20,{"$nulls":5},0,3,7]
[null,40,38,18,{"$nulls":5},7,9,9]
[null,39,37,8,{"$nulls":5},4,4,4]
[null,34,31,20,{"$nulls":5},7,3,4]
[null,38,38,15,{"$nulls":5},6,6,5]
[null,30,35,19,{"$nulls":5},3,4,10]
[null,30,31,14,{"$nulls":5},4,3,4]
[null,43,39,10,{"$nulls":5},12,3,4]
[null,40,28,{"$nulls":6},4,2]
[null,33,35,{"$nulls":6},3,4]
[null,35,36,{"$nulls":6},6,5]
[null,39,35,{"$nulls":6},5,3]
[null,32,27,{"$nulls":6},4,0]
[null,35,{"$nulls":7},4]
[null,33,{"$nulls":7},5]
[null,21,{"$nulls":7},2]
[null,29,{"$nulls":7},3]
[null,30,{"$nulls":7},2]
[null,18,{"$nulls":7},2]
[]
["Average ",32.84615384615385,34.55,15.8,1,null,null,null,"Average ",4.384615384615385,4.65,6.466666666666667,1]
[]
[]
[null,"PNS","DMSO 0.2%","20µM C14BH","50µM C14BH"]
["Lateral root number/mm primary root",0.13348946135831383,0.13458755426917512,0.4092827004219409,1]

{"sheet":"Summary","index":4,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,3,0]],"flags":["formulas_cached_only"]}
["Lateral root number/mm primary root"]
[]
[]
[null,"PNS","DMSO 0.1%","DMSO 0.2%","20µM C8BH","50µM C8BH","20µM C14BH","50µM C14BH"]
["Trial-1",0.09428359317000742,null,0.11886792452830189,null,null,0.7195945945945946,1.05]
["Trial-2",0.1702816901408451,null,0.12204724409448821,0.15752741774675974,0.21099744245524293,0.3307291666666667,0.89]
["Trial-3",0.15104166666666666,0.13076923076923078,0.15460526315789472,0.15231788079470196,0.1577726218097448,0.4735331632653062,1]
["Trial-4",0.13348946135831385,null,0.13458755426917512,null,null,0.4092827004219409]
[]
[]
["Average",0.13727410283395827,0.13076923076923078,0.132526996512465,0.15492264927073085,0.18438503213249385,0.48328490623712717,0.9800000000000001]
["St.Dev.",0.03236023313664925,{"$error":"#DIV/0!"},0.016207932363980226,0.0036836989056419547,0.03763563160586948,0.16801482617514762,0.0818535277187245]
["n",4,1,4,2,2,4,3]
["Sq. Rt. (n)",2,1,2,1.4142135623730951,1.4142135623730951,2,1.7320508075688772]
["Error",0.016180116568324625,0,0.008103966181990113,0.00260476847602889,0.026612410322749063,0.08400741308757381,0.047258156262526094]
[]
[]
["Primary Root Length","PNS","DMSO 0.1%","DMSO 0.2%","20µM C8BH","50µM C8BH","20µM C14BH","50µM C14BH"]
["Trial-1",46.44827586206897,null,39.25925925925926,null,null,9.25,0.4615384615384616]
["Trial-2",43.69230769230769,null,38.1,41.791666666666664,37.23809523809524,16,0.4166666666666667]
["Trial-3",29.53846153846154,27.36842105263158,27.636363636363637,26.647058823529413,25.352941176470587,13.066666666666666,1]
["Trial-4",32.84615384615385,null,34.55,null,null,15.8,1]
[]
[]
["Average",38.13129973474801,27.36842105263158,34.886405723905725,34.21936274509804,31.295518207282914,13.529166666666667,0.7195512820512822]
["St.Dev.",8.202977848272589,{"$error":"#DIV/0!"},5.232122427696304,10.708854904293323,8.40407303242163,3.1510249655204787,0.3243520066141241]
["n",4,1,4,2,2,4,4]
["Sq. Rt. (n)",2,1,2,1.4142135623730951,1.4142135623730951,2,2]
["Error",4.101488924136294,0,2.616061213848152,7.572303921568625,5.942577030812326,1.5755124827602394,0.16217600330706206]
[]
[]
["Lateral root number","PNS","DMSO 0.1%","DMSO 0.2%","20µM C8BH","50µM C8BH","20µM C14BH","50µM C14BH"]
["Trial-1",4.379310344827586,null,4.666666666666667,null,null,6.65625,0.73]
["Trial-2",7.44,null,4.65,6.583333333333333,7.857142857142857,5.291666666666667,0.66]
["Trial-3",4.461538461538462,3.5789473684210527,4.2727272727272725,4.0588235294117645,4,6.1875,0.79]
["Trial-4",4.384615384615385,null,4.65,null,null,6.466666666666667]
[]
[]
["Average",5.166366047745358,3.5789473684210527,4.559848484848485,5.321078431372548,5.928571428571429,6.150520833333333,0.7266666666666667]
["St.Dev.",1.5162216256122591,{"$error":"#DIV/0!"},0.19157531659473975,1.7850980015248625,2.7274118702909687,0.60407177176211,0.06506407098647712]
["n",4,1,4,2,2,4,3]
["Sq. Rt. (n)",2,1,2,1.4142135623730951,1.4142135623730951,2,1.7320508075688772]
["Error",0.7581108128061296,0,0.09578765829736988,1.2622549019607843,1.9285714285714282,0.302035885881055,0.03756475889861549]

{"sheet":"Analysis","index":5,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"PNS","DMSO 0.2%","20µM C14BH","50µM C14BH"]
["Lateral root number/mm primary root",0.13727410283395824,0.13252699651246497,0.48328490623712717,1]
["Error",0.016180116568324642,0.00810396618199022,0.08400741308757388,0.05]
["Primary Root Length",38.13129973474801,34.886405723905725,13.529166666666665,0.7195512820512822]
["Error",4.101488924136296,2.616061213848132,1.5755124827602427,0.162176003307062]
["Lateral root number",5.166366047745358,4.5598484848484855,6.150520833333333,0.73]
["Error",0.7581108128061311,0.09578765829736988,0.302035885881055,0.04]
[]
[]
[]
[]
[null,"PNS","20µM C14BH","20µM C8BH"]
["Lateral root number/mm primary root",0.13727410283395824,0.48328490623712717,0.15492264927073085]
["Error",0.016180116568324642,0.08400741308757388,0.0026047684760288764]
[]
[]
[null,"PNS","DMSO 0.2%","20µM C14","50µM C14","20µM C8","50µM C8"]
["Lateral root number/mm primary root",0.13727410283395824,0.13252699651246497,0.48328490623712717,1,0.15492264927073085,0.18438503213249385]
["Error",0.016180116568324642,0.00810396618199022,0.08400741308757388,0.05,0.0026047684760288764,0.026612410322749174]
["Primary Root Length",38.13129973474801,34.886405723905725,13.529166666666665,0.7195512820512822,34.21936274509804,31.295518207282914]
["Error",4.101488924136296,2.616061213848132,1.5755124827602427,0.162176003307062,7.572303921568622,5.94257703081233]
["Lateral root number",5.166366047745358,4.5598484848484855,6.150520833333333,1,5.321078431372548,5.928571428571429]
["Error",0.7581108128061311,0.09578765829736988,0.302035885881055,0.05,1.2622549019607858,1.9285714285714286]