{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["Information","data","Plot","Plot_residuals","interpolate","general","calculations","scratch"],"not_rendered":{"charts":2,"external_links":1,"defined_names":7,"comments":4},"unopened":[{"sheet":"Plot","index":2,"reason":"not_a_worksheet"},{"sheet":"Plot_residuals","index":3,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Information","index":0,"n_rows":29,"n_cols":11,"rows_kept":29,"flags":["formulas_cached_only"]}
{"$rows_empty":8}
[{"$nulls":3},"SFU PCHEM  ",null,"WEIGHTED LINEAR LEAST-SQUARES FIT",{"$nulls":4},"JCB Fall 2007"]
[{"$nulls":3},"Template WLSQFIT.XLT",null,null,"2012-03-31T13:47:05.450",null,null,"No macro version"]
[{"$nulls":3},"interpolate bug corrected March 2012"]
[]
[]
[{"$nulls":3},"1)  Enter your data and other information requested in the sheet data. If the errors on Y are not known, enter"]
[{"$nulls":3},"an appropriate constant value in the column ErrorY; be aware in this case that the fit will NOT be weighted!"]
[{"$nulls":3},"For a data point to be included in the fit, the corresponding Flag column must be left blank; any character"]
[{"$nulls":3},"entered in this column will remove the corresponding point from the calculations. This can be useful to test"]
[{"$nulls":3},"the effect of rogue looking data points on the fit."]
[]
[{"$nulls":3},"2) As the data are entered, the results of the fit are displayed on the left. "]
[{"$nulls":3},"For your information, the results of a non-weighted fit are also shown below."]
[]
[{"$nulls":3},"3) The data and the fitted line are plotted in the sheet Plot. The scales may need adjustments."]
[]
[{"$nulls":3},"4) The sheet interpolate may be used to calculate an estimate of Y for a given X (or X for given Y)."]
[]
[{"$nulls":3},"5) If your data set has more than 500 points, the size of some of the arrays will have to be adjusted."]
[{"$nulls":3},"Do NOT enter anything  anywhere except in the Pale Yellow cells. Do not touch the sheet general."]
[{"$nulls":3},"Do not touch the sheet calculations."]

{"sheet":"data","index":1,"n_rows":209,"n_cols":18,"rows_kept":209,"flags":["formulas_cached_only"]}
[null,"SFU PCHEM WLSQ","2012-03-31"," TOUCH ONLY PALE YELLOW CELLS",{"$nulls":13},"#rejected"]
[null,null,"31 Mar 2012",{"$nulls":11}," # points",null,null,"points"]
[{"$nulls":5},"ENTER DATA",{"$nulls":8},0,0,0,0]
[null,null,"ENTER",null,"Flag","X","Y","ErrorY",null,null,"Residuals","1/err2 ",null,null,5," 1st row"]
[null,"X Title","X variable (xunit)",{"$nulls":7},"","",null,null,4," Last row"]
[null,"Y Title","Dependent Var (yunit)",{"$nulls":7},"","",null,null,4]
[{"$nulls":10},"","",null,null,"Range ","1st cell","Last cell"]
[null,null,"ENTER",{"$nulls":6},"X range for plot","","",null,null,"X ","$F$5","$F$4"]
[null,"Your name  ","Joe Student",{"$nulls":6},"Use default (y/n)","","",null,null,"Y ","$G$5","$G$4"]
[{"$nulls":9},"y","","",null,null,"EY ","$H$5","$H$4"]
[{"$nulls":9},"If No, enter plot range.","","",null,null,"w","$L$5","$L$4"]
[{"$nulls":9},"If default leave empty.","",""]
[null,"Weighted Fit",{"$nulls":6},"Min X",0,"","",null,null,"Show +/- 1stdvfit on plot"]
[null,"results","+/-",{"$nulls":5},"Max X",0,"","",null,null,0,""]
["Slope = ","","",{"$nulls":7},"","",null,null,0,""]
["Intercept = ","","",{"$nulls":7},"","",null,null,0,{"$error":"#VALUE!"}]
["Std Dev of fit","",{"$nulls":8},"","",null,null,0,{"$error":"#VALUE!"}]
["Rsq = ","",{"$nulls":8},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[null,"Regular LINEST Fit",{"$nulls":8},"",""]
[null,"results","  +/-  ",{"$nulls":7},"",""]
["Slope = ","","",{"$nulls":7},"",""]
["Intercept = ","","",{"$nulls":7},"",""]
["Std Dev of fit","",{"$nulls":8},"",""]
["Rsq = ","",{"$nulls":8},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
["Slope =   +/-  ",{"$nulls":9},"",""]
[{"$nulls":10},"",""]
["Intercept =   +/-  ",{"$nulls":9},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]
[{"$nulls":10},"",""]

{"sheet":"interpolate","index":4,"n_rows":19,"n_cols":10,"rows_kept":19,"flags":["formulas_cached_only"]}
["SFU PCHEM WLSQ"]
[]
[]
[{"$nulls":3},"Leave blank"]
[null,"ENTER",null,"if unknown",null,null,"X+err","X-err"]
["X  ",null,"+/-",{"$nulls":3},0,0,0]
[null,"TO GET",{"$nulls":3},"Y",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"<-- [Y(+)-Y(-)]/2"]
["Y = ","","+/-","",null,"Yerr",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}," <-- Yerror predicted from lsq"]
[]
[{"$nulls":3},"Leave blank"]
[null,"ENTER",null,"if unknown",null,null,"Y+err","Y-err"]
["Y  ",null,"+/-",{"$nulls":3},0,0]
[null,"TO GET"]
["X = ","","+/-","",null,"X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"<-- [(X+)-(X-)]/2 "]
[]
[{"$nulls":6},"Y+err","Y-err"]
["Y(Xinterpolated)",{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[{"$nulls":5},"X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"<-- [(X+)-(X-)]/2 "]

{"sheet":"general","index":5,"n_rows":11,"n_cols":7,"rows_kept":11,"flags":["formulas_cached_only"]}
["SFU PCHEM WLSQ"]
["JCB Apr-99","WEIGHTED LINEAR LEAST-SQUARES FIT",{"$nulls":4},"Oct 06 added table of residuals"]
["v41 6 june 07","Added Xerror in interpolation",{"$nulls":4},"Feb 07 added data flag"]
[]
[" Do not alter unless you know what you are doing!"]
[]
[]
["Max size",500,"If larger data arrays are needed, the sizes of plotting arrays will have to be changed."]
["Fitted line overhang"]
["(% of span)",15]
["Allow fitted line to go x < 0",true]

{"sheet":"calculations","index":6,"n_rows":48,"n_cols":8,"rows_kept":48,"flags":["formulas_cached_only"]}
[]
[null,"Ref. N.R. Draper & H. Smith, Applied Regression Analysis, Wiley, N.Y. (1966)"]
[null,null,0," # points used"]
[null,null,5," 1st row"]
[null,null,4," Last row"]
[null,null,"data!","Sheet name",null,null,"LINEST FIT"]
[null,null,"Range ","1st cell","Last cell",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"X ","data!$F$5","data!$F$4",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Y ","data!$G$5","data!$G$4",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"EY ","data!$H$5","data!$H$4",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"w","data!$L$5","data!$L$4",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Plotting range","Use default",null,"Fitted line"]
["Flag",true,"MIN X",0,null,null,"WLSQ"]
[null,null,"MAX X",0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"SPAN",0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"overhang",0,"X","Y",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":3},0,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},-2]
[{"$nulls":3},0,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":3},0,{"$error":"#VALUE!"}]
[null,null,"Deg. freedom",-2]
[null,null,"Swi ",0]
[null,null,"Swi xi ",{"$error":"#VALUE!"}]
[null,null,"Swi xi2 ",{"$error":"#VALUE!"}]
[null,null,"Swi yi ",{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[null,null,"Swi xiyi ",{"$error":"#VALUE!"}]
[null,null,"Swi yi2 ",{"$error":"#VALUE!"}," SSQ"]
[null,null,"Swi xi /Swi ",{"$error":"#VALUE!"},"<x>"]
[null,null,"LSQ Matrix (X' V-1 X)",null,null,"(X' V-1 Y)"]
[null,null,0,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[]
[null,"V(b) = "," (X' V-1 X)-1 ","s2 ",null,"b","err"]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"bo  = ",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"b1  = ",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[{"$nulls":3},{"$error":"#VALUE!"},"Reg SSQ"]
[null,"b'",null,{"$error":"#VALUE!"},"Res SSQ"]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},-2,"w deg freed",{"$error":"#DIV/0!"}]
[null,null,"s = ",{"$error":"#VALUE!"},"W stdv fit",{"$error":"#VALUE!"}," = s2 ",{"$error":"#VALUE!"}]
[{"$nulls":3},{"$error":"#VALUE!"}]
[null,null,"1/Swi",{"$error":"#DIV/0!"}]
[null,null,"DSwi",{"$error":"#VALUE!"}]
[null,null,"D",{"$error":"#DIV/0!"}]
[null,"(Swi1/2 yi )2 /n = ","SSQ(b0) = ",{"$error":"#VALUE!"}]
[null,null,"SSQ( b0 | b1 ) = ",{"$error":"#VALUE!"}]
[null,null,"F = ",{"$error":"#VALUE!"}]
[null,null,"Total SSQ (corrected) = ",{"$error":"#VALUE!"}]
[null,null,"R2  =  ",{"$error":"#VALUE!"}]

{"sheet":"scratch","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}