{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Regression","Regression_back"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":34,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Regression","index":0,"n_rows":209,"n_cols":9,"rows_kept":209,"cut":false,"hidden":false,"merged":[[4,6,4,8],[2,0,2,8]]}
["Non-Linear Titer Estimator"]
["Instructions"]
["Place data in columns below and press run. The tool will perform non-linear regression to fit a titer curve with a set cut point factor. Interface will prompt errors in data or warn about potentially incorrect outputs. Paramaters can be edited but are set to recommended defaults. "]
[]
["Dilution","Signal",null,null,null,null,"Parameters"]
[null,null,null,null,null,null,"Dilution Fold",2,"*Default = 2"]
[null,null,null,null,null,null,"Cut Point Factor",1.6,"*Default = 1.6"]
[null,null,null,null,null,null,"Estimated Titer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,27.61]
[1,27.61]
[1,27.61]
[1,27.61]
[1,27.61]

{"sheet":"Regression_back","index":1,"n_rows":200,"n_cols":22,"rows_kept":200,"cut":false,"hidden":true,"merged":[[0,12,0,13]]}
[{"$f":"IF(ISBLANK(Regression!A5),\"\",Regression!A5)","v":"Dilution"},"Ynew","Cutpoint",null,null,null,null,"min_data","max_data","nrow",null,null,"Titer Bar",null,null,"min_data","max_data","nrow",null,null,null,"R2"]
[{"$f":"IF(ISBLANK(Regression!$A$7),\"\",MIN(Regression!A:A))","v":""},{"$f":"IF(A2=\"\",\"\",(Titer*Cp-Titer)/A2+1)","v":""},{"$f":"IF(Cp=\"\",\"\",Cp)","v":1.6},null,null,null,null,{"$f":"IF(ISBLANK(Regression!$A$7),\"\",MIN(Regression!A:A))","v":""},{"$f":"IF(ISBLANK(Regression!$A$7),\"\",MAX(Regression!A:A))","v":""},199,{"$f":"IF(I4=\"\",\"\",(I4-H4)/J2)","v":""},null,{"$f":"IF($S$2=\"\",\"\",ROUND(Titer,1))","v":""},{"$f":"IF($S$2=\"\",\"\",0)","v":""},null,0,{"$f":"IF(ISBLANK(Regression!$A$7),\"\",MAX(B:B))","v":""},9,{"$f":"IF(Q2=\"\",\"\",(Q2-P2)/R2)","v":""}]
[{"$f":"IF($K$2=\"\",\"\",10^((ROW()-1)*$K$2))","v":""},"",1.6,null,null,null,null,"n_min","n_max",null,null,null,"",{"$f":"IF($S$2=\"\",\"\",$S$2+N2)","v":""}]
[{"$f":"IF($K$2=\"\",\"\",10^((ROW()-1)*$K$2))","v":""},"",1.6,null,null,null,null,{"$f":"IF(H2=\"\",\"\",LOG10(H2))","v":""},{"$f":"IF(I2=\"\",\"\",LOG10(I2))","v":""},null,null,null,"",{"$f":"IF($S$2=\"\",\"\",$S$2+N3)","v":""}]
["","",1.6,null,null,null,null,null,null,null,null,null,"",""]
["","",1.6,null,null,null,null,null,null,null,null,null,"",""]
["","",1.6,null,null,null,null,null,null,null,null,null,"",""]
["","",1.6,null,null,null,null,null,null,null,null,null,"",""]
["","",1.6,null,null,null,null,null,null,null,null,null,"",""]
["","",1.6,null,null,null,null,null,null,null,null,null,"",""]
["","",1.6,null,null,null,null,null,null,null,null,null,"",""]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["",{"$f":"IF(A34=\"\",\"\",(Titer*Cp-Titer)/A34+1)","v":""},{"$f":"IF(Cp=\"\",\"\",Cp)","v":1.6}]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["",{"$f":"IF(A66=\"\",\"\",(Titer*Cp-Titer)/A66+1)","v":""},{"$f":"IF(Cp=\"\",\"\",Cp)","v":1.6}]
["","",1.6]
[{"$f":"IF($K$2=\"\",\"\",10^((ROW()-1)*$K$2))","v":""},"",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["",{"$f":"IF(A98=\"\",\"\",(Titer*Cp-Titer)/A98+1)","v":""},{"$f":"IF(Cp=\"\",\"\",Cp)","v":1.6}]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["",{"$f":"IF(A130=\"\",\"\",(Titer*Cp-Titer)/A130+1)","v":""},{"$f":"IF(Cp=\"\",\"\",Cp)","v":1.6}]
["","",1.6]
[{"$f":"IF($K$2=\"\",\"\",10^((ROW()-1)*$K$2))","v":""},"",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["",{"$f":"IF(A162=\"\",\"\",(Titer*Cp-Titer)/A162+1)","v":""},{"$f":"IF(Cp=\"\",\"\",Cp)","v":1.6}]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["",{"$f":"IF(A194=\"\",\"\",(Titer*Cp-Titer)/A194+1)","v":""},{"$f":"IF(Cp=\"\",\"\",Cp)","v":1.6}]
["","",1.6]
[{"$f":"IF($K$2=\"\",\"\",10^((ROW()-1)*$K$2))","v":""},"",1.6]
["","",1.6]
["","",1.6]
["","",1.6]
["","",1.6]