{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["RNAinVAL_CPB_june2016&dec20...","RNAinVAL_CPB_june2016&dec20 (2","Warning RNAinVAL_CPB_june20..."],"not_rendered":{"charts":4,"images":0,"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"}

{"sheet":"RNAinVAL_CPB_june2016&dec20...","index":0,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Experiment name:","RNAinVAL_CPB_june2016&dec2016_experiments",null,null,"samples that should be silenced"]
[]
[]
[null,null,"Target gene name"]
[null,"Sample name","JHBP_qPCR_TqMn","LdAlas","vATPaseE","LdMesh"]
["blank control","jun2016_H2O-1",4.0548799999999998,0.27663700000000002,0.43963200000000002,4.3310000000000001E-2]
[null,"jun2016_H2O-2",6.0755439999999998,0.26929399999999998,0.30922500000000003,5.0312000000000003E-2]
[null,"jun2016_H2O-3",44.609856999999998,0.239065,0.44461899999999999,5.0165000000000001E-2]
[null,"jun2016_H2O-4",2.5433680000000001,0.26762799999999998,0.49097299999999999,3.1709000000000001E-2]
["negative control","jun2016_dsegfp-1",108.66074999999999,0.31983699999999998,1.2395529999999999,3.7429999999999998E-2]
[null,"jun2016_dsegfp-2",52.648352000000003,0.14475399999999999,0.45348100000000002,4.0533E-2]
[null,"jun2016_dsegfp-3",3.8398500000000002,0.12328799999999999,1.024438,3.7432E-2]
[null,"jun2016_dsegfp-4",103.46709300000001,0.190051,0.820191,2.8788000000000001E-2]
[null,"jun2016_dsvATPaseE-1",9.0524620000000002,0.188384,6.0254000000000002E-2,6.1088000000000003E-2]
[null,"jun2016_dsvATPaseE-2",9.0583150000000003,"/",6.7756999999999998E-2,8.7219000000000005E-2]
[null,"jun2016_dsvATPaseE-3",6.8438129999999999,"/",3.8200999999999999E-2,5.9305999999999998E-2]
[null,"jun2016_dsvATPaseE-4",5.2649660000000003,0.35727700000000001,9.4760999999999998E-2,6.2021E-2]
[null,"jun2016_dsalas-1",3.346905,9.6134999999999998E-2,1.2654669999999999,7.1377999999999997E-2]
[null,"jun2016_dsalas-2",1.649195,0.10439,0.57450100000000004,7.6623999999999998E-2]
[null,"jun2016_dsalas-3",11.919420000000001,0.127584,0.46559299999999998,6.9627999999999995E-2]
[null,"jun2016_dsalas-4",2.4621550000000001,9.5260999999999998E-2,1.0401899999999999,6.9510000000000002E-2]
[null,"jun2016_dsJHBP-1",5.2503000000000001E-2,0.323071,0.53050799999999998,5.7599999999999998E-2]
[null,"jun2016_dsJHBP-2",3.4350000000000001E-3,0.27637699999999998,1.084049,4.9626999999999998E-2]
[null,"jun2016_dsJHBP-3",6.8110000000000004E-2,0.177539,0.51814899999999997,6.6396999999999998E-2]
[null,"jun2016_dsJHBP-4",5.1840000000000002E-3,0.33649899999999999,0.45336300000000002,5.9512000000000002E-2]
[null,"jun2016_dsmesh-1",2.6909999999999998E-3,0.197903,0.93237999999999999,9.9649999999999999E-3]
[null,"jun2016_dsmesh-2",0.137409,0.21893299999999999,0.75188100000000002,1.2324E-2]
[null,"jun2016_dsmesh-3",0.119492,0.19516600000000001,1.5670010000000001,9.4730000000000005E-3]
[null,"jun2016_dsmesh-4",3.0854309999999998,0.17729900000000001,0.81454300000000002,"/"]
["blank control","dec2016_H2O_1",8.7448390000000007,0.34839399999999998,1.3362780000000001,0.45882200000000001]
[null,"dec2016_H2O_2",4.1413460000000004,0.254552,1.5758559999999999,1.011509]
[null,"dec2016_H2O_3",8.9334000000000007,0.35125099999999998,1.042252,0.53094600000000003]
[null,"dec2016_H2O_4",12.008813999999999,0.39591500000000002,1.142047,0.59834900000000002]
["negative control","dec2016_egfp_1",66.687488999999999,9.6959000000000004E-2,0.77653499999999998,0.60291399999999995]
[null,"dec2016_egfp_2",16.363475999999999,0.180724,0.95945000000000003,0.57239899999999999]
[null,"dec2016_egfp_3",74.512659999999997,0.61370899999999995,1.751209,0.41463899999999998]
[null,"dec2016_egfp_4","/",0.133379,"/","/"]
[null,"dec2016_alas_1",5.0665310000000003,4.9931000000000003E-2,"/",0.72614100000000004]
[null,"dec2016_alas_2",30.863351000000002,4.6551000000000002E-2,1.8194699999999999,0.71863100000000002]
[null,"dec2016_alas_3",76.512086999999994,0.117616,2.5933670000000002,0.70459400000000005]
[null,"dec2016_alas_4",31.349688,0.119507,1.409103,0.68932800000000005]
[null,"dec2016_JHBP_1",9.5399999999999999E-4,0.43181700000000001,1.5230170000000001,0.70750900000000005]
[null,"dec2016_JHBP_2",9.5399999999999999E-4,"/",1.138199,0.72284499999999996]
[null,"dec2016_JHBP_3",9.5399999999999999E-4,0.124801,"/",1.1880230000000001]
[null,"dec2016_JHBP_4",4.5386000000000003E-2,"/","/","/"]
["JUN 2016","silencing eff compared to dsegfp",{"$f":"1-AVERAGE(C23:C26)/AVERAGE(C11:C14)","v":0.99951889694452167},{"$f":"1-AVERAGE(D19:D22)/AVERAGE(D11:D14)","v":0.45577365572737905},{"$f":"1-AVERAGE(E15:E18)/AVERAGE(E11:E14)","v":0.92623011293048552},{"$f":"1-AVERAGE(F27:F30)/AVERAGE(F11:F14)","v":0.70628067571535258}]
["whole larvae","ttest p-val",{"$f":"_xlfn.T.TEST(C23:C26,C11:C14,2,2)","v":3.4241305025417203E-2},{"$f":"_xlfn.T.TEST(D19:D22,D11:D14,2,2)","v":9.4515468770006522E-2},{"$f":"_xlfn.T.TEST(E15:E18,E11:E14,2,2)","v":2.7471844404459312E-3},{"$f":"_xlfn.T.TEST(F27:F30,F11:F14,2,2)","v":4.2253357742521382E-4}]
[null,"silencing eff compared to H2O",{"$f":"1-AVERAGE(C23:C26)/AVERAGE(C7:C10)","v":0.9977439984662988},{"$f":"1-AVERAGE(D19:D22)/AVERAGE(D7:D10)","v":0.59779560412834964},{"$f":"1-AVERAGE(E15:E18)/AVERAGE(E7:E10)","v":0.84506921848034577},{"$f":"1-AVERAGE(F27:F30)/AVERAGE(F7:F10)","v":0.75868775736578997}]
[null,"ttest p-val",{"$f":"_xlfn.T.TEST(C23:C26,C7:C10,2,2)","v":0.20776109278256646},{"$f":"_xlfn.T.TEST(D19:D22,D7:D10,2,2)","v":8.0549011377686663E-6},{"$f":"_xlfn.T.TEST(E15:E18,E7:E10,2,2)","v":1.2474553060852847E-4},{"$f":"_xlfn.T.TEST(F27:F30,F7:F10,2,2)","v":1.409076720972474E-3}]
["DEC 2016","silencing eff compared to dsegfp",{"$f":"1-AVERAGE(C43:C46)/AVERAGE(C35:C38)","v":0.99977034039423751},{"$f":"1-AVERAGE(D39:D42)/AVERAGE(D35:D38)","v":0.67445897668845034}]
["midguts","ttest p-val",{"$f":"_xlfn.T.TEST(C43:C46,C35:C38,2,2)","v":1.8342259745572555E-2},{"$f":"_xlfn.T.TEST(D39:D42,D35:D38,2,2)","v":0.20676958816990035}]
[null,"silencing eff compared to H2O",{"$f":"1-AVERAGE(C43:C46)/AVERAGE(C31:C34)","v":0.99857374273018362},{"$f":"1-AVERAGE(D39:D42)/AVERAGE(D31:D34)","v":0.7529056848617004}]
[null,"ttest p-val",{"$f":"_xlfn.T.TEST(C43:C46,C31:C34,2,2)","v":1.9990217413015125E-3},{"$f":"_xlfn.T.TEST(D39:D42,D31:D34,2,2)","v":4.0465782762163702E-4}]
[]
[null,null,"HIGH VARIABILITY BETWEEN BIOL. REPLICATES!","alas IS NOT SILENCED EFFICIENTLY "]

{"sheet":"RNAinVAL_CPB_june2016&dec20 (2","index":1,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Experiment name:","RNAinVAL_CPB_june2016&dec2016_experiments",null,null,"samples that should be silenced"]
[]
[]
[null,null,"Target gene name",{"$nulls":5},"average expression values",{"$nulls":4},"SE"]
[null,"Sample name","JHBP_qPCR_TqMn","LdAlas","vATPaseE","LdMesh",null,null,"JHBP","ALAS","vATPaseE","MESH",null,"JHBP","ALAS","vATPaseE","MESH"]
["blank control","jun2016_H2O-1",4.0548799999999998,0.27663700000000002,0.43963200000000002,4.3310000000000001E-2,null,"water",{"$f":"AVERAGE(C7:C10)","v":14.320912249999999},{"$f":"AVERAGE(D7:D10)","v":0.26315599999999995},0.42111224999999997,4.3873999999999996E-2,null,{"$f":"_xlfn.STDEV.S(C7:C10)/SQRT(COUNT(C7:C10))","v":10.122204298658669},{"$f":"_xlfn.STDEV.S(D7:D10)/SQRT(COUNT(D7:D10))","v":8.2653265210758629E-3},3.9045731242085498E-2,4.3715924444074523E-3]
[null,"jun2016_H2O-2",6.0755439999999998,0.26929399999999998,0.30922500000000003,5.0312000000000003E-2,null,"dsEGFP",{"$f":"AVERAGE(C11:C14)","v":67.154011249999996},{"$f":"AVERAGE(D11:D14)","v":0.19448249999999997},0.88441574999999994,3.6045750000000001E-2,null,{"$f":"_xlfn.STDEV.S(C11:C14)/SQRT(COUNT(C11:C14))","v":24.597673387455185},{"$f":"_xlfn.STDEV.S(D11:D14)/SQRT(COUNT(D11:D14))","v":4.4040671926640754E-2},0.16722197675115105,2.5273204642796416E-3]
[null,"jun2016_H2O-3",44.609856999999998,0.239065,0.44461899999999999,5.0165000000000001E-2,null,"target dsRNA",{"$f":"AVERAGE(C23:C26)","v":3.2308000000000003E-2},{"$f":"AVERAGE(D19:D22)","v":0.10584249999999999},{"$f":"AVERAGE(E15:E18)","v":6.5243249999999989E-2},{"$f":"AVERAGE(F27:F30)","v":1.0587333333333332E-2},null,{"$f":"_xlfn.STDEV.S(C23:C26)/SQRT(COUNT(C23:C26))","v":1.6479741942761118E-2},{"$f":"_xlfn.STDEV.S(D19:D22)/SQRT(COUNT(D19:D22))","v":7.533294304839927E-3},{"$f":"_xlfn.STDEV.S(E15:E18)/SQRT(COUNT(E15:E18))","v":1.1668306092252646E-2},{"$f":"_xlfn.STDEV.S(F27:F30)/SQRT(COUNT(F27:F30))","v":8.7987202352261308E-4}]
[null,"jun2016_H2O-4",2.5433680000000001,0.26762799999999998,0.49097299999999999,3.1709000000000001E-2]
["negative control","jun2016_dsegfp-1",108.66074999999999,0.31983699999999998,1.2395529999999999,3.7429999999999998E-2,null,null,"average expression values scaled to water",{"$nulls":4},"SE"]
[null,"jun2016_dsegfp-2",52.648352000000003,0.14475399999999999,0.45348100000000002,4.0533E-2,null,null,"JHBP","ALAS","vATPaseE","MESH",null,"JHBP","ALAS","vATPaseE","MESH"]
[null,"jun2016_dsegfp-3",3.8398500000000002,0.12328799999999999,1.024438,3.7432E-2,null,{"$f":"H7","v":"water"},{"$f":"I7/$I$7","v":1},{"$f":"J7/$J$7","v":1},{"$f":"K7/$K$7","v":1},{"$f":"L7/$L$7","v":1},null,{"$f":"N7/$I$7","v":0.70681281485113978},{"$f":"O7/$J$7","v":3.1408466921050114E-2},{"$f":"P7/$K$7","v":9.272048305905492E-2},{"$f":"Q7/$L$7","v":9.9639705620810787E-2}]
[null,"jun2016_dsegfp-4",103.46709300000001,0.190051,0.820191,2.8788000000000001E-2,null,{"$f":"H8","v":"dsEGFP"},{"$f":"I8/$I$7","v":4.6892271998943365},{"$f":"J8/$J$7","v":0.7390388210795118},{"$f":"K8/$K$7","v":2.1001900324675904},{"$f":"L8/$L$7","v":0.82157428089529116},null,{"$f":"N8/$I$7","v":1.7176052026612472},{"$f":"O8/$J$7","v":0.16735575828269453},{"$f":"P8/$K$7","v":0.39709596847669726},{"$f":"Q8/$L$7","v":5.7604058537622321E-2}]
[null,"jun2016_dsvATPaseE-1",9.0524620000000002,0.188384,6.0254000000000002E-2,6.1088000000000003E-2,null,{"$f":"H9","v":"target dsRNA"},{"$f":"I9/$I$7","v":2.2560015337011793E-3},{"$f":"J9/$J$7","v":0.40220439587165036},{"$f":"K9/$K$7","v":0.1549307815196542},{"$f":"L9/$L$7","v":0.24131224263421008},null,{"$f":"N9/$I$7","v":1.1507466602039349E-3},{"$f":"O9/$J$7","v":2.862672447080792E-2},{"$f":"P9/$K$7","v":2.7708303646480595E-2},{"$f":"Q9/$L$7","v":2.0054520297274312E-2}]
[null,"jun2016_dsvATPaseE-2",9.0583150000000003,"/",6.7756999999999998E-2,8.7219000000000005E-2]
[null,"jun2016_dsvATPaseE-3",6.8438129999999999,"/",3.8200999999999999E-2,5.9305999999999998E-2]
[null,"jun2016_dsvATPaseE-4",5.2649660000000003,0.35727700000000001,9.4760999999999998E-2,6.2021E-2]
[null,"jun2016_dsalas-1",3.346905,9.6134999999999998E-2,1.2654669999999999,7.1377999999999997E-2]
[null,"jun2016_dsalas-2",1.649195,0.10439,0.57450100000000004,7.6623999999999998E-2]
[null,"jun2016_dsalas-3",11.919420000000001,0.127584,0.46559299999999998,6.9627999999999995E-2]
[null,"jun2016_dsalas-4",2.4621550000000001,9.5260999999999998E-2,1.0401899999999999,6.9510000000000002E-2]
[null,"jun2016_dsJHBP-1",5.2503000000000001E-2,0.323071,0.53050799999999998,5.7599999999999998E-2]
[null,"jun2016_dsJHBP-2",3.4350000000000001E-3,0.27637699999999998,1.084049,4.9626999999999998E-2]
[null,"jun2016_dsJHBP-3",6.8110000000000004E-2,0.177539,0.51814899999999997,6.6396999999999998E-2]
[null,"jun2016_dsJHBP-4",5.1840000000000002E-3,0.33649899999999999,0.45336300000000002,5.9512000000000002E-2]
[null,"jun2016_dsmesh-1",2.6909999999999998E-3,0.197903,0.93237999999999999,9.9649999999999999E-3]
[null,"jun2016_dsmesh-2",0.137409,0.21893299999999999,0.75188100000000002,1.2324E-2]
[null,"jun2016_dsmesh-3",0.119492,0.19516600000000001,1.5670010000000001,9.4730000000000005E-3]
[null,"jun2016_dsmesh-4",3.0854309999999998,0.17729900000000001,0.81454300000000002,"/"]
["blank control","dec2016_H2O_1",8.7448390000000007,0.34839399999999998,1.3362780000000001,0.45882200000000001,null,null,"average expression values",{"$nulls":4},"SE"]
[null,"dec2016_H2O_2",4.1413460000000004,0.254552,1.5758559999999999,1.011509,null,null,"JHBP","ALAS",null,null,null,"JHBP","ALAS"]
[null,"dec2016_H2O_3",8.9334000000000007,0.35125099999999998,1.042252,0.53094600000000003,null,"water",{"$f":"AVERAGE(C31:C34)","v":8.4570997500000011},{"$f":"AVERAGE(D31:D34)","v":0.33752799999999999},null,null,null,{"$f":"_xlfn.STDEV.S(C31:C34)/SQRT(COUNT(C30:C33))","v":1.6214720767570201},{"$f":"_xlfn.STDEV.S(D31:D34)/SQRT(COUNT(D30:D33))","v":2.972155366901268E-2}]
[null,"dec2016_H2O_4",12.008813999999999,0.39591500000000002,1.142047,0.59834900000000002,null,"dsEGFP",{"$f":"AVERAGE(C35:C38)","v":52.521208333333334},{"$f":"AVERAGE(D35:D38)","v":0.25619274999999997},null,null,null,{"$f":"_xlfn.STDEV.S(C35:C38)/SQRT(COUNT(C35:C38))","v":18.219445023669486},{"$f":"_xlfn.STDEV.S(D35:D38)/SQRT(COUNT(D35:D38))","v":0.12039933747351976}]
["negative control","dec2016_egfp_1",66.687488999999999,9.6959000000000004E-2,0.77653499999999998,0.60291399999999995,null,"target dsRNA",{"$f":"AVERAGE(C43:C46)","v":1.2062E-2},{"$f":"AVERAGE(D39:D42)","v":8.340125000000001E-2},null,null,null,{"$f":"_xlfn.STDEV.S(C43:C46)/SQRT(COUNT(C43:C46))","v":1.1108000000000002E-2},{"$f":"_xlfn.STDEV.S(D43:D46)/SQRT(COUNT(D43:D46))","v":0.15350799999999995}]
[null,"dec2016_egfp_2",16.363475999999999,0.180724,0.95945000000000003,0.57239899999999999]
[null,"dec2016_egfp_3",74.512659999999997,0.61370899999999995,1.751209,0.41463899999999998,null,null,"average expression values scaled to water",{"$nulls":4},"SE"]
[null,"dec2016_egfp_4","/",0.133379,"/","/",null,null,"JHBP","ALAS",null,null,null,"JHBP","ALAS"]
[null,"dec2016_alas_1",5.0665310000000003,4.9931000000000003E-2,"/",0.72614100000000004,null,{"$f":"H33","v":"water"},{"$f":"I33/$I$33","v":1},{"$f":"J33/$J$33","v":1},null,null,null,{"$f":"N33/$I$33","v":0.19172909445191538},{"$f":"O33/$J$33","v":8.8056557290099424E-2}]
[null,"dec2016_alas_2",30.863351000000002,4.6551000000000002E-2,1.8194699999999999,0.71863100000000002,null,{"$f":"H34","v":"dsEGFP"},{"$f":"I34/$I$33","v":6.2103096671330293},{"$f":"J34/$J$33","v":0.75902665852907014},null,null,null,{"$f":"N34/$I$33","v":2.1543372506241854},{"$f":"O34/$J$33","v":0.35670918404849306}]
[null,"dec2016_alas_3",76.512086999999994,0.117616,2.5933670000000002,0.70459400000000005,null,{"$f":"H35","v":"target dsRNA"},1.4262572698164047E-3,0.24709431513829966,null,null,null,1.3134526407826749E-3,0.45480078689767944]
[null,"dec2016_alas_4",31.349688,0.119507,1.409103,0.68932800000000005]
[null,"dec2016_JHBP_1",9.5399999999999999E-4,0.43181700000000001,1.5230170000000001,0.70750900000000005]
[null,"dec2016_JHBP_2",9.5399999999999999E-4,"/",1.138199,0.72284499999999996]
[null,"dec2016_JHBP_3",9.5399999999999999E-4,0.124801,"/",1.1880230000000001]
[null,"dec2016_JHBP_4",4.5386000000000003E-2,"/","/","/"]
["JUN 2016","silencing eff compared to dsegfp",{"$f":"1-AVERAGE(C23:C26)/AVERAGE(C11:C14)","v":0.99951889694452167},{"$f":"1-AVERAGE(D19:D22)/AVERAGE(D11:D14)","v":0.45577365572737905},{"$f":"1-AVERAGE(E15:E18)/AVERAGE(E11:E14)","v":0.92623011293048552},{"$f":"1-AVERAGE(F27:F30)/AVERAGE(F11:F14)","v":0.70628067571535258}]
["whole larvae","ttest p-val",{"$f":"_xlfn.T.TEST(C23:C26,C11:C14,2,2)","v":3.4241305025417203E-2},{"$f":"_xlfn.T.TEST(D19:D22,D11:D14,2,2)","v":9.4515468770006522E-2},{"$f":"_xlfn.T.TEST(E15:E18,E11:E14,2,2)","v":2.7471844404459312E-3},{"$f":"_xlfn.T.TEST(F27:F30,F11:F14,2,2)","v":4.2253357742521382E-4}]
[null,"silencing eff compared to H2O",{"$f":"1-AVERAGE(C23:C26)/AVERAGE(C7:C10)","v":0.9977439984662988},{"$f":"1-AVERAGE(D19:D22)/AVERAGE(D7:D10)","v":0.59779560412834964},{"$f":"1-AVERAGE(E15:E18)/AVERAGE(E7:E10)","v":0.84506921848034577},{"$f":"1-AVERAGE(F27:F30)/AVERAGE(F7:F10)","v":0.75868775736578997}]
[null,"ttest p-val",{"$f":"_xlfn.T.TEST(C23:C26,C7:C10,2,2)","v":0.20776109278256646},{"$f":"_xlfn.T.TEST(D19:D22,D7:D10,2,2)","v":8.0549011377686663E-6},{"$f":"_xlfn.T.TEST(E15:E18,E7:E10,2,2)","v":1.2474553060852847E-4},{"$f":"_xlfn.T.TEST(F27:F30,F7:F10,2,2)","v":1.409076720972474E-3}]
["DEC 2016","silencing eff compared to dsegfp",{"$f":"1-AVERAGE(C43:C46)/AVERAGE(C35:C38)","v":0.99977034039423751},{"$f":"1-AVERAGE(D39:D42)/AVERAGE(D35:D38)","v":0.67445897668845034}]
["midguts","ttest p-val",{"$f":"_xlfn.T.TEST(C43:C46,C35:C38,2,2)","v":1.8342259745572555E-2},{"$f":"_xlfn.T.TEST(D39:D42,D35:D38,2,2)","v":0.20676958816990035}]
[null,"silencing eff compared to H2O",{"$f":"1-AVERAGE(C43:C46)/AVERAGE(C31:C34)","v":0.99857374273018362},{"$f":"1-AVERAGE(D39:D42)/AVERAGE(D31:D34)","v":0.7529056848617004}]
[null,"ttest p-val",{"$f":"_xlfn.T.TEST(C43:C46,C31:C34,2,2)","v":1.9990217413015125E-3},{"$f":"_xlfn.T.TEST(D39:D42,D31:D34,2,2)","v":4.0465782762163702E-4}]
[]
[null,null,"HIGH VARIABILITY BETWEEN BIOL. REPLICATES!","alas IS NOT SILENCED EFFICIENTLY "]

{"sheet":"Warning RNAinVAL_CPB_june20...","index":2,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Experiment name:","RNAinVAL_CPB_june2016&dec2016_experiments"]
[]
[]
[null,null,"Target gene name"]
[null,"Sample name","JHBP_qPCR_TqMn","LdAlas","vATPaseE","LdMesh"]
[null,"jun2016_H2O-1",4.0548799999999998,0.27663700000000002,0.43963200000000002,4.3310000000000001E-2]
[null,"jun2016_H2O-2",6.0755439999999998,0.26929399999999998,0.30922500000000003,5.0312000000000003E-2]
[null,"jun2016_H2O-3",44.609856999999998,0.239065,0.44461899999999999,5.0165000000000001E-2]
[null,"jun2016_H2O-4",2.5433680000000001,0.26762799999999998,0.49097299999999999,3.1709000000000001E-2]
[null,"jun2016_dsegfp-1",108.66074999999999,0.31983699999999998,1.2395529999999999,3.7429999999999998E-2]
[null,"jun2016_dsegfp-2",52.648352000000003,0.14475399999999999,0.45348100000000002,4.0533E-2]
[null,"jun2016_dsegfp-3",3.8398500000000002,0.12328799999999999,1.024438,3.7432E-2]
[null,"jun2016_dsegfp-4",103.46709300000001,0.190051,0.820191,2.8788000000000001E-2]
[null,"jun2016_dsvATPaseE-1",9.0524620000000002,0.188384,6.0254000000000002E-2,6.1088000000000003E-2]
[null,"jun2016_dsvATPaseE-2",9.0583150000000003,"QC target failed",6.7756999999999998E-2,8.7219000000000005E-2]
[null,"jun2016_dsvATPaseE-3",6.8438129999999999,"QC target failed",3.8200999999999999E-2,5.9305999999999998E-2]
[null,"jun2016_dsvATPaseE-4",5.2649660000000003,0.35727700000000001,9.4760999999999998E-2,6.2021E-2]
[null,"jun2016_dsalas-1",3.346905,9.6134999999999998E-2,1.2654669999999999,7.1377999999999997E-2]
[null,"jun2016_dsalas-2",1.649195,0.10439,0.57450100000000004,7.6623999999999998E-2]
[null,"jun2016_dsalas-3",11.919420000000001,0.127584,0.46559299999999998,6.9627999999999995E-2]
[null,"jun2016_dsalas-4",2.4621550000000001,9.5260999999999998E-2,1.0401899999999999,6.9510000000000002E-2]
[null,"jun2016_dsJHBP-1",5.2503000000000001E-2,0.323071,0.53050799999999998,5.7599999999999998E-2]
[null,"jun2016_dsJHBP-2",3.4350000000000001E-3,0.27637699999999998,1.084049,4.9626999999999998E-2]
[null,"jun2016_dsJHBP-3",6.8110000000000004E-2,0.177539,0.51814899999999997,6.6396999999999998E-2]
[null,"jun2016_dsJHBP-4",5.1840000000000002E-3,0.33649899999999999,0.45336300000000002,5.9512000000000002E-2]
[null,"jun2016_dsmesh-1",2.6909999999999998E-3,0.197903,0.93237999999999999,9.9649999999999999E-3]
[null,"jun2016_dsmesh-2",0.137409,0.21893299999999999,0.75188100000000002,1.2324E-2]
[null,"jun2016_dsmesh-3",0.119492,0.19516600000000001,1.5670010000000001,9.4730000000000005E-3]
[null,"jun2016_dsmesh-4",3.0854309999999998,0.17729900000000001,0.81454300000000002,"QC target failed"]
[null,"dec2016_H2O_1",8.7448390000000007,0.34839399999999998,1.3362780000000001,0.45882200000000001]
[null,"dec2016_H2O_2",4.1413460000000004,0.254552,1.5758559999999999,1.011509]
[null,"dec2016_H2O_3",8.9334000000000007,0.35125099999999998,1.042252,0.53094600000000003]
[null,"dec2016_H2O_4",12.008813999999999,0.39591500000000002,1.142047,0.59834900000000002]
[null,"dec2016_egfp_1",66.687488999999999,9.6959000000000004E-2,0.77653499999999998,0.60291399999999995]
[null,"dec2016_egfp_2",16.363475999999999,0.180724,0.95945000000000003,0.57239899999999999]
[null,"dec2016_egfp_3",74.512659999999997,0.61370899999999995,1.751209,0.41463899999999998]
[null,"dec2016_egfp_4","QC target failed",0.133379,"QC target failed","QC target failed"]
[null,"dec2016_alas_1",5.0665310000000003,4.9931000000000003E-2,"QC target failed",0.72614100000000004]
[null,"dec2016_alas_2",30.863351000000002,4.6551000000000002E-2,1.8194699999999999,0.71863100000000002]
[null,"dec2016_alas_3",76.512086999999994,0.117616,2.5933670000000002,0.70459400000000005]
[null,"dec2016_alas_4",31.349688,0.119507,1.409103,0.68932800000000005]
[null,"dec2016_JHBP_1","Under LOQ",0.43181700000000001,1.5230170000000001,0.70750900000000005]
[null,"dec2016_JHBP_2","Under LOQ","QC target failed",1.138199,0.72284499999999996]
[null,"dec2016_JHBP_3","Under LOQ",0.124801,"QC target failed",1.1880230000000001]
[null,"dec2016_JHBP_4",4.5386000000000003E-2,"QC target failed","QC target failed","QC target failed"]
["JUN 2016","silencing eff compared to dsegfp",{"$f":"1-AVERAGE(C23:C26)/AVERAGE(C11:C14)","v":0.99951889694452167},{"$f":"1-AVERAGE(D19:D22)/AVERAGE(D11:D14)","v":0.45577365572737905},{"$f":"1-AVERAGE(E15:E18)/AVERAGE(E11:E14)","v":0.92623011293048552},{"$f":"1-AVERAGE(F27:F30)/AVERAGE(F11:F14)","v":0.70628067571535258}]
["whole larvae","ttest p-val",{"$f":"_xlfn.T.TEST(C23:C26,C11:C14,2,2)","v":3.4241305025417203E-2},{"$f":"_xlfn.T.TEST(D19:D22,D11:D14,2,2)","v":9.4515468770006522E-2},{"$f":"_xlfn.T.TEST(E15:E18,E11:E14,2,2)","v":2.7471844404459312E-3},{"$f":"_xlfn.T.TEST(F27:F30,F11:F14,2,2)","v":4.2253357742521382E-4}]
[null,"silencing eff compared to H2O",{"$f":"1-AVERAGE(C23:C26)/AVERAGE(C11:C14)","v":0.99951889694452167},{"$f":"1-AVERAGE(D19:D22)/AVERAGE(D11:D14)","v":0.45577365572737905},{"$f":"1-AVERAGE(E15:E18)/AVERAGE(E11:E14)","v":0.92623011293048552},{"$f":"1-AVERAGE(F27:F30)/AVERAGE(F11:F14)","v":0.70628067571535258}]
[null,"ttest p-val",{"$f":"_xlfn.T.TEST(C23:C26,C7:C10,2,2)","v":0.20776109278256646},{"$f":"_xlfn.T.TEST(D19:D22,D7:D10,2,2)","v":8.0549011377686663E-6},{"$f":"_xlfn.T.TEST(E15:E18,E7:E10,2,2)","v":1.2474553060852847E-4},{"$f":"_xlfn.T.TEST(F27:F30,F7:F10,2,2)","v":1.409076720972474E-3}]
["DEC 2016","silencing eff compared to dsegfp",{"$f":"1-AVERAGE(C43:C46)/AVERAGE(C35:C38)","v":0.99913585384951631},{"$f":"1-AVERAGE(D39:D42)/AVERAGE(D35:D38)","v":0.67445897668845034}]
["midguts","ttest p-val",{"$f":"_xlfn.T.TEST(C43:C46,C35:C38,2,2)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.T.TEST(D39:D42,D35:D38,2,2)","v":0.20676958816990035}]
[null,"silencing eff compared to H2O",{"$f":"1-AVERAGE(C43:C46)/AVERAGE(C31:C34)","v":0.99463338480783559},{"$f":"1-AVERAGE(D39:D42)/AVERAGE(D31:D34)","v":0.7529056848617004}]
[null,"ttest p-val",{"$f":"_xlfn.T.TEST(C43:C46,C31:C34,2,2)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.T.TEST(D39:D42,D31:D34,2,2)","v":4.0465782762163702E-4}]