{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DataInput","Screen","Trim","Results"],"not_rendered":{"charts":3,"images":7,"macros":1,"external_links":0,"defined_names":71,"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":"DataInput","index":0,"n_rows":38,"n_cols":32,"rows_kept":38,"cut":false,"hidden":false,"merged":[[23,5,23,7],[12,5,12,7],[3,5,3,7],[1,0,1,2],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[19,29,19,30],[5,29,5,30],[6,29,6,30],[4,29,4,30],[0,23,1,27],[0,29,1,31],[2,29,2,30],[3,29,3,30]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combo Box Input Ranges",null,null,null,null,null,"Input for VBA and Graph"]
["Step 1 - Enter data (do not skip lines)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mg/L",null,null,null,null,null,"ConcentrationUnit:",null,2]
["Date","Concentration","Non-detect (enter \"<\")",null,null,"Step 2 - Enter Other Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"μg/L",null,null,null,null,null,"StartDay:",null,1]
["1982-05-30",2,"<",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toxic Units",null,null,null,null,null,"StartMonth:",null,5]
["1982-07-06",26,null,null,null,"Site:",null,"Sample (copper)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NTU",null,null,null,null,null,"EndDay:",null,31]
["1982-07-08",24,null,null,null,"Concentration Units:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EndMonth:",null,8]
["1982-07-14",29,null,null,null,"Analyst:",null,"JB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January",1,31,null,1]
["1982-07-21",31,null,null,null,"Date:",null,"2010-06-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February",2,28,null,{"$f":"AB8+1","v":2},null,{"$f":"MIN(A5:A1048576)","v":"1982-05-30"},{"$f":"IF(COUNTIF(C5:C1048576,\"=<\")=0,-100,MinDetLimit)","v":2}]
["1982-07-22",35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March",3,31,null,{"$f":"AB9+1","v":3},null,{"$f":"MAX(A5:A1048576)","v":"1983-12-31"},{"$f":"AE9","v":2}]
["1982-07-23",34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April",4,30,null,4]
["1982-07-23",38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May",5,31,null,5]
["1982-07-24",35,null,null,null,"Step 3 - Define Season Range",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June",6,30,null,6,null,{"$f":"OFFSET(X3,AF3-1,0)","v":"μg/L"}]
["1982-07-29",45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",7,31,null,7,null,{"$f":"\"Concentration (\" &AD13&\")\"","v":"Concentration (μg/L)"}]
["1982-07-30",25,null,null,null,null,"Day","Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",8,31,null,{"$f":"AB14+1","v":8}]
["1982-07-31",25,null,null,null,"Beginning:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September",9,30,null,9]
["1982-08-01",25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October",10,31,null,{"$f":"AB16+1","v":10}]
["1982-08-07",26,null,null,null,null,"Day","Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November",11,30,null,{"$f":"AB17+1","v":11}]
["1982-08-12",41,null,null,null,"Ending:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December",12,31,null,12]
["1982-08-14",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,"Minimum Detection Limit:",null,{"$f":"MAX(IF(C5:C1048576=\"<\",B5:B1048576))","v":2}]
["1982-09-13",38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
["1982-10-19",44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["1983-05-28",9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
["1983-06-15",10,null,null,null,"Step 4 - Process Data (click button)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
["1983-07-10",29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
["1983-08-03",33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
["1983-09-03",34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
["1983-12-31",50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB27+1","v":21}]
["1983-09-03",34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
["1983-12-31",50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB33+1","v":27}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB37+1","v":31}]

{"sheet":"Screen","index":1,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[17,6,17,9],[1,0,1,5],[3,14,3,17],[11,11,11,15]]}
[]
[" "]
[]
["Date","Season","Non-detect","Concentration",null,null,null,"Pass","Fail",null,null,null,null,null,"Data screening tests"]
["1982-05-30","S","<",2,null,null,null,null,null,null,null,null,null,null,null,"All Data","In Season","Out of Season"]
["1982-07-06","S",null,26,null,null,"Screening Tests","All Data","In Season","Out of Season",null,null,null,null,"Two criteria",{"$f":"AND(H7>=20,H9>1)","v":true},{"$f":"AND(I7>=20,I9>1)","v":true},{"$f":"AND(J7>=20,J9>1)","v":false}]
["1982-07-08","S",null,24,null,null,"Count",26,20,6,null,null,null,null,"All three criteria",{"$f":"AND(H8<=0.2,H7>=20,H9>1)","v":true},{"$f":"AND(I8<=0.2,I7>=20,I9>1)","v":true},{"$f":"AND(J8<=0.2,J7>=20,J9>1)","v":false}]
["1982-07-14","S",null,29,null,null,"% Non-detects",3.8461538461538464E-2,0.05,0,null,null,null,null,"Non-detect count",1,1,0]
["1982-07-21","S",null,31,null,null,"Date Range (years)",1.5890410958904109,1.178082191780822,1.2986301369863014]
["1982-07-22","S",null,35]
["1982-07-23","S",null,34,null,null,"Basic Stats","All Data","In Season","Out of Season"]
["1982-07-23","S",null,38,null,null,"Mean",30.46153846153846,27.1,41.666666666666664,null,"Calculated by macro CalculateStatsScreen()"]
["1982-07-24","S",null,35,null,null,"Median",32,27.5,41]
["1982-07-29","S",null,45,null,null,"Standard Dev.",11.734498776618521,10.730674182969707,7.4206917916503441]
["1982-07-30","S",null,25]
["1982-07-31","S",null,25]
["1982-08-01","S",null,25]
["1982-08-07","S",null,26,null,null,"Step 5 - Transfer data to next sheet to test for trimming"]
["1982-08-12","S",null,41]
["1982-08-14","S",null,20,null,null,"Wilcoxon Rank Sum Test (includes non-detects)"]
["1983-05-28","S",null,9,null,null,"Test positive for seasonality."]
["1983-06-15","S",null,10]
["1983-07-10","S",null,29,null,null,null,"Full dataset may be transfered, but seasonality is indicated."]
["1983-08-03","S",null,33]
["1982-09-13","X",null,38,null,null,null,"Transfer in season dataset."]
["1982-10-19","X",null,44]
["1983-09-03","X",null,34,null,null,null,"Seasonality indicated but out of season data do not meet minimum criteria."]
["1983-09-03","X",null,34]
["1983-12-31","X",null,50]
["1983-12-31","X",null,50]

{"sheet":"Trim","index":2,"n_rows":39,"n_cols":26,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,7,10,11],[2,0,2,4],[3,11,3,14]]}
[]
[]
[{"$f":"BadDLMsg","v":" "},null,null,null,null,null,null,"Basic Stats","Raw Data","Log Transformed"]
["Date","Season","Non-detect","Concentration","LN (Conc)","Trim",null,"Count",18,18,null,"Calculated by macro CalculateStatsTrim()",null,null,null,null,null,null,null,null,null,null,null,null,"N-values RD","N-values LT"]
["1982-05-30","S","<",2,0.69314718055994529,"Y",null,"Mean",27.5,3.2499843124905565,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.93762102046747642,0.7296625401194895]
["1983-05-28","S",null,9,2.1972245773362196,null,null,"Median",27.5,3.3126961840039781,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.82928191355998526,0.68207253729840289]
["1983-06-15","S",null,10,2.3025850929940459,null,null,"Standard dev.",8.5215988557795619,0.40792896388062633,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.67173857175656315,0.59248940831352981]
["1982-08-14","S",null,20,2.9957322735539909,null,null,"Skew",-0.77606386943322159,-1.7291048744646318,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56737369070645238,0.51713403006710057]
["1982-07-08","S",null,24,3.1780538303479458,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45912899340127827,0.44281032198152859]
["1982-07-30","S",null,25,3.2188758248682006,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35772772564948691,0.33018551636210736]
["1982-07-31","S",null,25,3.2188758248682006,null,null,"Step 6 - Trim data as needed, then perform statistical analyses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25438982961427681,0.2169123949463698]
["1982-08-01","S",null,25,3.2188758248682006,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15748002784947274,0.11725809358601702]
["1982-07-06","S",null,26,3.2580965380214821,null,null,"W test: W = 0.9304798; p-value = 0.1980",null,null,null,null,null,null,"t","Method for central tendancy",null,null,null,null,null,null,null,null,6.9147763816582081E-2,4.9309018795820198E-2]
["1982-08-07","S",null,26,3.2580965380214821,null,null,"No further trimming needed.",null,null,null,null,null,null,1,"Number of non-detects",null,null,null,null,null,null,null,null,3.1592228418036591E-2,2.7142679764077471E-2]
["1982-07-14","S",null,29,3.3672958299864741,null,null,"Data ready for statistical analysis.",null,null,null,null,null,null,{"$f":"COUNTIF(F5:F30004,\"Y\")","v":2},"Trim count"]
["1983-07-10","S",null,29,3.3672958299864741,null,null,null,null,null,null,null,null,null,20,"Total data count (including trimmed)"]
["1982-07-21","S",null,31,3.4339872044851463,null,null,null,"Method for estimation of central tendency",null,null,null,null,null,38.300000000000004,"90th percentile of full dataset"]
["1983-08-03","S",null,33,3.4965075614664802,null,null,null,"Student's t method for normal distribution"]
["1982-07-23","S",null,34,3.5263605246161616]
["1982-07-22","S",null,35,3.5553480614894135]
["1982-07-24","S",null,35,3.5553480614894135,null,null,null,null,null,null,null,null,null,null,"Histogram, untransformed"]
["1982-07-23","S",null,38,3.6375861597263857,null,null,null,null,null,null,null,null,null,null,{"$f":"RDmean-2*RDstdev","v":10.456802288440876},"count","bins","label"]
["1982-08-12","S",null,41,3.713572066704308,null,null,null,null,null,null,null,null,null,null,{"$f":"P$22+(P$29-P$22)*1/7","v":15.326287348886339},2,{"$f":"Q23","v":2},"-2 sd"]
["1982-07-29","S",null,45,3.8066624897703196,"Y",null,null,null,null,null,null,null,null,null,{"$f":"P$22+(P$29-P$22)*2/7","v":20.195772409331802},3,{"$f":"Q24-Q23","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$22+(P$29-P$22)*3/7","v":25.065257469777269},7,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$22+(P$29-P$22)*4/7","v":29.934742530222731},11,4,"Mean"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$22+(P$29-P$22)*5/7","v":34.804227590668191},14,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$22+(P$29-P$22)*6/7","v":39.673712651113661},17,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RDmean+2*RDstdev","v":44.543197711559124},18,1,"+2 sd"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Histogram, log transformed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LTmean-2*LTstdev","v":2.434126384729304},"count","bins","label"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$32+(P$39-P$32)*1/7","v":2.6672286498039477},2,{"$f":"Q33","v":2},"-2 sd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$32+(P$39-P$32)*2/7","v":2.9003309148785914},2,{"$f":"Q34-Q33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$32+(P$39-P$32)*3/7","v":3.1334331799532347},3,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$32+(P$39-P$32)*4/7","v":3.3665354450278784},9,6,"Mean"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$32+(P$39-P$32)*5/7","v":3.5996377101025221},16,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$32+(P$39-P$32)*6/7","v":3.8327399751771658},18,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LTmean+2*LTstdev","v":4.0658422402518095},18,0,"+2 sd"]

{"sheet":"Results","index":3,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,2,6,3],[2,1,2,10]]}
[]
[]
[null,"Alaska NCBWQS Analysis (Version 2.0) - Results"]
[]
[null,"Site:",{"$f":"IF(ISBLANK(DataInput!H6),\"\",DataInput!H6)","v":"Sample (copper)"}]
[null,"Analyst:",{"$f":"IF(ISBLANK(DataInput!H8),\"\",DataInput!H8)","v":"JB"}]
[null,"Date:",{"$f":"IF(ISBLANK(DataInput!H9),\"\",DataInput!H9)","v":"2010-06-28"}]
[]
[null,"Data points:",{"$f":"TotalN","v":20},null,"In-Season (5/1-8/31)"]
[]
[null,"Lower 95% Confidence Limit (CL) on 90th Percentile (Conover's Nonparametric Method)"]
[null,"Value:",35,{"$f":"ConcUnits","v":"μg/L"}]
[]
[null,"Lower 95% Confidence Limit (CL) on Central Tendency"]
[null,"Method:","Student's t Method for normal distributions"]
[null,"Value:",23.262308624297685,{"$f":"D$12","v":"μg/L"}]
[]
[]
[]
[null,"Published Criteria for Site (enter below)"]
[null,"Acute:",25,{"$f":"D$12","v":"μg/L"},null,null,"Define as allowance above natural background of",null,null,null,null,null,false]
[null,"Chronic:",20,{"$f":"D$12","v":"μg/L"},null,null,null,{"$f":"D$12","v":"μg/L"}]
[]
[null,"Natural Condition-Based Criteria for Site"]
[null,"Acute:",{"$f":"IF(bDefValue=TRUE,URvalue90+G22,URvalue90)","v":35},{"$f":"D$12","v":"μg/L"},{"$f":"IF(C21>C25,\"Published criterion is greater\",\"\")","v":""}]
[null,"Chronic:",{"$f":"IF(bDefValue=TRUE,CTvalue+DefValue,CTvalue)","v":23.262308624297685},{"$f":"D$12","v":"μg/L"},{"$f":"IF(C22>C26,\"Published criterion is greater\",\"\")","v":""}]
[]
[null,"Alternative Calculations for MDL"]
[null,null,"Lower 95% CL on 95th Percentile:",38.413040722767235,{"$f":"D$12","v":"μg/L"}]
[null,null,"Lower 95% CL on 90th Percentile:",{"$f":"URvalue90","v":35},{"$f":"D$12","v":"μg/L"}]
[null,null,"Estimated Mean:",27.5,{"$f":"D$12","v":"μg/L"}]
[null,null,"Estimated 90th Percentile:",{"$f":"Trim!O17","v":38.300000000000004},{"$f":"D$12","v":"μg/L"}]