{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":75,"n_cols":6,"rows_kept":75,"merged":[[36,0,36,1]],"flags":["formulas_cached_only"]}
["蛋白定量数据的EXCEL处理"]
["1、数据的输入"]
["以Bradford的标准曲线制作为例，数据最关键的就是变量X和变量Y。你对应的修改这两组数据即可推广到其他的类似实验。"]
["您可以以你的实验数据修改表格中的数据，即可自动得到新的图表和曲线方程"]
[null,null,"变量X",null,null,"变量Y"]
["样品号","标准蛋白量ug","标准蛋白平均值","A595下的OD值",null,"OD平均值"]
[1,0,0,0,null,0]
[]
[2,2.5,null,0.12]
[3,2.5,2.5,0.13,null,0.125]
[]
[4,5,null,0.25]
[5,5,5,0.215,null,0.23249999999999998]
[]
[6,7.5,null,0.331]
[7,7.5,7.5,0.364,null,0.34750000000000003]
[]
[8,10,null,0.46]
[9,10,10,0.442,null,0.451]
[]
[10,12.5,null,0.531]
[11,12.5,12.5,0.562,null,0.5465]
[]
[12,15,null,0.633]
[13,15,15,0.617,null,0.625]
[]
[14,17.5,null,0.684]
[15,17.5,17.5,0.65,null,0.667]
[]
[16,20,null,0.721]
[17,20,20,0.727,null,0.724]
[]
[]
[]
["2、计算方程"]
["我们这里的图表默认选中了直线方程。"]
["Y=A*X+B"]
["Y","吸光值"]
["X","蛋白浓度"]
["方程如图中所示，y=0.0367x+0.0461"]
["备注：图表中的R的平方是统计学中的\"决定系数\"。该指标用于表明曲线方程与你的数据点之间的拟合程度，完全符合则是1，完全不符合则取0."]
[]
["3、计算蛋白浓度"]
["将曲线方程中的A和B填入下表，Y值是你的样品测得的OD值。下表将自动得出蛋白浓度X."]
["Y","A","B","X浓度值"]
[0.136,0.0367,0.0461,{"v":2.449591280653951,"d":"2.450"}]
[0.718,0.0367,0.0461,{"v":18.307901907356946,"d":"18.308"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},{"$error":"#DIV/0!"}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}