{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Intro","Single Sample CI","Compare to Threshold","Two means -- temporary","Two means -- permanent","CI for proportion","Two proportions -- temporary","Two stage hidden"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Intro","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Single Sample CI","index":1,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,0,2,9],[7,0,8,0],[16,0,16,8],[17,0,22,1],[17,3,19,5],[17,2,19,2],[7,2,7,8],[8,2,8,8],[5,1,5,8],[36,3,36,8],[38,3,38,8],[20,3,22,5],[23,2,25,5],[26,4,28,5],[20,2,22,2],[29,2,31,5]]}
[]
[]
["The user needs to enter targeted level of precision from a sampling objective and summary statistics from pilot sampling"]
[]
["Targeted precision level"]
[null,"Desired confidence level (e.g., 90%, 95%)",null,null,null,null,null,null,null,0.9]
[null,"Desired confidence interval width -- choose one of the following:"]
[{"$f":"IF(J8<>0,IF(J9<>0,\"Warning - enter 1 choice only\",\"\"),\"\")","v":""},"A.","Confidence interval width as a percent of mean (e.g., within ± 20% of mean)",null,null,null,null,null,null,0.2]
[null,"B.","Absolute confidence interval width"]
[null,null,null,null,null,null,null,null,"Tolerance probability",0.9]
[]
["Additional information if sampling from a Finite Population"]
[null,null,null,null,null,null,null,null,"Specify total population area -->",1000]
[null,null,null,null,null,null,null,null,"Specify area of 1 quadrat -->",10]
[null,null,null,null,null,null,null,null,"Formula yields big N =",{"$f":"IF(J14>0,J13/J14,10^10)","v":100}]
[]
["Summary statistics from pilot sampling "]
[{"$f":"IF(SUM(J19:J20)<>0,IF(SUM(J21:J23)<>0,warning,\"\"),\"\")","v":""},null,"A.","Summary statistics derived from data pasted below starting on line 45",null,null,null,null,"n",{"$f":"IF(COUNT(J53:J253)>0,COUNT(J53:J253),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Sample mean",{"$f":"IF(COUNT(J53:J253)>0,AVERAGE(J53:J253),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Sample standard deviation",{"$f":"IF(COUNT(J53:J253)>0,STDEV(J53:J253),\"\")","v":""}]
[null,null,"B.","Summary statistics typed in by user",null,null,null,null,"n",30]
[null,null,null,null,null,null,null,null,"Sample mean",30]
[null,null,null,null,null,null,null,null,"Sample standard deviation",10]
[null,null,"Summary statistics ",null,null,null,null,null,"n",{"$f":"IF(ISNUMBER(J21)=TRUE,J21,J18)","v":30}]
[null,null,null,null,null,null,null,null,"Sample mean",{"$f":"IF(ISNUMBER(J22)=TRUE,J22,J19)","v":30}]
[null,null,null,null,null,null,null,null,"Sample standard deviation",{"$f":"IF(ISNUMBER(J23)=TRUE,J23,J20)","v":10}]
[null,null,null,null,"Confidence intervals around sample mean",null,null,null,"95% C.I.",{"$f":"IF(ISNUMBER(J26)=TRUE,J26/SQRT(J24)*TINV(0.05,J24-1),\"\")","v":3.7340613675810026}]
[null,null,null,null,null,null,null,null,"FPC 95% C.I.",{"$f":"IF(ISNUMBER(J26)=TRUE,IF(J15>0,SQRT((J15-J24)/J15)*J27,J27),\"\")","v":3.1241398828801881}]
[null,null,null,null,null,null,null,null,"C.I. width as % of mean",{"$f":"IF(ISNUMBER(J26)=TRUE,J28/J25,\"\")","v":0.10413799609600627}]
[null,null,"Summary statistics calculated for a population total",null,null,null,null,null,"Total Population Size",{"$f":"IF(J15=10^10,\"\",J15*J25)","v":3000}]
[null,null,null,null,null,null,null,null,"95% C.I.",{"$f":"IF(J15=10^10,\"\",J15*J27)","v":373.40613675810027}]
[null,null,null,null,null,null,null,null,"FPC 95% C.I.",{"$f":"IF(J15=10^10,\"\",J15*J28)","v":312.4139882880188}]
[]
["Sample size to achieve the sampling objective based on pilot sampling results"]
[null,null,null,null,null,null,null,null,"Calculated absolute confidence interval width",{"$f":"IF(ISNUMBER(J9)=TRUE,J9,IF(ISNUMBER(J25)=TRUE,J8*J25,\"\"))","v":6}]
[]
[null,null,null,"Sample size (with Kupper and Hafner correction)",null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,IF((((TINV(1-J6,10000))^2)*J26^2/J35^2)>1000,(((TINV(1-J6,10000))^2)*J26^2/J35^2)+60,SQRT(((CHIINV(1-J10,J41-1))*(FINV(1-J6,1,J41-1))/(CHIINV(1-J6,1))*((((TINV(1-J6,10000))^2)*J26^2/J35^2)))+J41)),\"\")","v":13.661156131374275}]
[]
[null,null,null,"FPC Sample size (with Kupper and Hafner correction)",null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,J37/(1+J37/J15),\"\")","v":12.019195120260912}]
[]
[null,null,null,null,null,null,null,null,"Iterative cell (don't modify)",{"$f":"IF(ISNUMBER(J26)=TRUE,IF(ISERR(J37),10,ROUND(J37,0)),\"\")","v":14}]

{"sheet":"Compare to Threshold","index":2,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[17,0,22,1],[17,2,19,2],[17,3,19,5],[20,2,22,2],[20,3,22,5],[2,0,2,9],[5,1,5,8],[16,0,16,7],[9,1,9,8],[7,1,7,8],[6,1,6,8],[44,0,44,8],[42,0,42,8],[23,2,25,5],[26,4,28,5],[29,2,31,5],[36,3,36,8],[38,2,38,8]]}
[]
[]
["The user needs to enter desired power, acceptable false-change error rate,  minimum detectable difference between sample mean & threshold values and summary statistics from pilot sampling"]
[]
["Targeted power, false-change error, minimum detectable difference"]
[null,"Desired power (e.g., 0.80, 0.90)",null,null,null,null,null,null,null,0.9]
[null,"Acceptable false-change error rate (e.g., 0.10, 0.20) ",null,null,null,null,null,null,null,0.1]
[null,"Enter 1 or 2 for 1- or 2-sided test",null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"adjusted alpha based on 1-sided or 2-sided test",{"$f":"IF(J8=1,J7*2,J7)","v":0.2}]
[null,"Minimum Detectable Difference between Sample Mean & Threshold",null,null,null,null,null,null,null,5]
[]
["Additional information if sampling from a Finite Population"]
[null,null,null,null,null,null,null,null,"Specify total population area -->",5000]
[null,null,null,null,null,null,null,null,"Specify area of 1 quadrat -->",1]
[null,null,null,null,null,null,null,null,"Formula yields big N =",{"$f":"IF(J14>0,J13/J14,10^10)","v":5000}]
[]
["Summary statistics from pilot sampling "]
[{"$f":"IF(SUM(J19:J20)<>0,IF(SUM(J21:J23)<>0,warning,\"\"),\"\")","v":""},null,"A.","Summary statistics derived from data pasted below starting on line 50",null,null,null,null,"n",{"$f":"IF(COUNT(J52:J252)>0,COUNT(J52:J252),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Sample mean",{"$f":"IF(COUNT(J52:J252)>0,AVERAGE(J52:J252),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Sample standard deviation",{"$f":"IF(COUNT(J52:J252)>0,STDEV(J52:J252),\"\")","v":""}]
[null,null,null,"Summary statistics typed in by user",null,null,null,null,"n",15]
[null,null,null,null,null,null,null,null,"Sample mean",23]
[null,null,null,null,null,null,null,null,"Sample standard deviation",11]
[null,null,"Summary statistics copied from one of the above sources that is used in sample size, MDC, and Power calculations",null,null,null,null,null,"n",{"$f":"J21","v":15}]
[null,null,null,null,null,null,null,null,"Sample mean",{"$f":"J22","v":23}]
[null,null,null,null,null,null,null,null,"Sample standard deviation",{"$f":"J23","v":11}]
[null,null,null,null,"Confidence intervals around sample mean",null,null,null,"95% C.I.",{"$f":"IF(ISNUMBER(J26)=TRUE,J26/SQRT(J24)*TINV(0.05,J24-1),\"\")","v":6.0915969572135484}]
[null,null,null,null,null,null,null,null,"FPC 95% C.I.",{"$f":"IF(ISNUMBER(J26)=TRUE,IF(J15>0,SQRT((J15-J24)/J15)*J27,J27),\"\")","v":6.0824526984322667}]
[null,null,null,null,null,null,null,null,"C.I. width as % of mean",{"$f":"IF(ISNUMBER(J26)=TRUE,J28/J25,\"\")","v":0.26445446514922899}]
[null,null,"Summary statistics calculated for a population total",null,null,null,null,null,"Total Population Size",{"$f":"IF(J15=10^10,\"\",J15*J25)","v":115000}]
[null,null,null,null,null,null,null,null,"95% C.I.",{"$f":"IF(J15=10^10,\"\",J15*J27)","v":30457.984786067744}]
[null,null,null,null,null,null,null,null,"FPC 95% C.I.",{"$f":"IF(J15=10^10,\"\",J15*J28)","v":30412.263492161332}]
[]
["Sample size to achieve the sampling objective based on pilot sampling results"]
[null,null,null,null,null,null,null,null,"Targeted minimum detectable difference from above",{"$f":"J10","v":5}]
[]
[null,null,null,"Sample size to meet stated sampling objective",null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,((J26^2)*(TINV(J9,J41)+TINV(2*(1-J6),J41))^2)/((J35)^2),\"\")","v":32.485045198829305}]
[]
[null,null,"FPC-adjusted sample size to meet stated sampling objective",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,(J37)/(1+(J37/J15)),\"\")","v":32.275351945477915}]
[]
[null,null,null,null,null,null,null,null,"Iterative cell (df) (don't modify)",{"$f":"IF(ISNUMBER(J26)=TRUE,IF(ISERR(J37),100,(J37)*2-2),\"\")","v":62.970090397658609}]
[]
["Minimum detectable difference based on sample size and standard deviation from pilot sampling, at targeted power and stated false-change error rate",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,SQRT(((J26^2)*(TINV(J9,(J24-1))+TINV(2*(1-J6),(J24-1)))^2)*(1-J24/J15)/(J24)),\"\")","v":7.6288086611702983}]
[]
["Calculated power based on sample size and standard deviation from pilot sampling, targeted MDD and stated false-change error rate.",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,IF((SQRT((J24/(1-J24/J15)*(J35)^2)/((J26^2)))-TINV(J9,(J24-1)))<0,((TDIST(ABS((SQRT((J24/(1-J24/J14)*(J35)^2)/((J26^2))))-(TINV(J9,(J24-1)))),J24-1,2))/2),(1-(TDIST((SQRT((J24/(1-J24/J15)*(J35)^2)/((J26^2))))-(TINV(J9,(J24-1))),(J24-1),2))/2)),\"\")","v":0.65887875450674227}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Enter"]
[null,null,null,null,null,null,null,null,"Plot","Data below"]
[null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,12]

{"sheet":"Two means -- temporary","index":3,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[31,2,33,5],[44,0,44,8],[46,0,46,8],[19,3,21,5],[22,3,24,5],[25,2,27,5],[28,4,30,5],[38,3,38,8],[40,2,40,8],[19,0,24,1],[19,2,21,2],[22,2,24,2],[18,0,18,7],[11,2,11,8],[2,0,2,9],[5,1,5,8],[10,2,10,8],[10,0,11,0]]}
[]
[]
["The user needs to enter desired power, acceptable false-change error rate, targeted minimum detectable change and summary statistics from pilot sampling"]
[]
["Targeted power, false-change error, minimum detectable change"]
[null,"Desired power (e.g., 0.80, 0.90)",null,null,null,null,null,null,null,0.9]
[null,"Acceptable false-change error rate (e.g., 0.10, 0.20) ",null,null,null,null,null,null,null,0.1]
[null,"Enter 1 or 2 for 1- or 2-sided test",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,"adjusted alpha based on 1-sided or 2-sided test",{"$f":"IF(J8=1,J7*2,J7)","v":0.1}]
[null,"Targeted minimum detectable change -- choose one of the following:"]
[{"$f":"IF(J11<>0,IF(J12<>0,\"Warning - enter 1 choice only\",\"\"),\"\")","v":""},"A.","MDC as a percent of mean (e.g., within ± 20% of mean)",null,null,null,null,null,null,0.2]
[null,"B.","MDC in absolute measurement units"]
[]
["Additional information if sampling from a Finite Population"]
[null,null,null,null,null,null,null,null,"Specify total population area -->",50000]
[null,null,null,null,null,null,null,null,"Specify area of 1 quadrat -->",25]
[null,null,null,null,null,null,null,null,"Formula yields big N =",{"$f":"IF(J16>0,J15/J16,10^10)","v":2000}]
[]
["Summary statistics from pilot sampling"]
[{"$f":"IF(SUM(J21:J22)<>0,IF(SUM(J23:J25)<>0,warning,\"\"),\"\")","v":""},null,"A.","Summary statistics derived from data pasted below starting on line 50",null,null,null,null,"n",{"$f":"IF(COUNT(#REF!)>0,COUNT(#REF!),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Sample mean",{"$f":"IF(COUNT(#REF!)>0,AVERAGE(#REF!),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Sample standard deviation",{"$f":"IF(COUNT(#REF!)>0,STDEV(#REF!),\"\")","v":""}]
[null,null,"B.","Summary statistics typed in by user",null,null,null,null,"n",10]
[null,null,null,null,null,null,null,null,"Sample mean",25]
[null,null,null,null,null,null,null,null,"Sample standard deviation",7]
[null,null,"Summary statistics copied from one of the above sources that is used in sample size, MDC, and Power calculations",null,null,null,null,null,"n",{"$f":"IF(ISNUMBER(J23)=TRUE,J23,J20)","v":10}]
[null,null,null,null,null,null,null,null,"Sample mean",{"$f":"IF(ISNUMBER(J24)=TRUE,J24,J21)","v":25}]
[null,null,null,null,null,null,null,null,"Sample standard deviation",{"$f":"IF(ISNUMBER(J25)=TRUE,J25,J22)","v":7}]
[null,null,null,null,"Confidence intervals around sample mean",null,null,null,"95% C.I.",{"$f":"IF(ISNUMBER(J28)=TRUE,J28/SQRT(J26)*TINV(0.05,J26-1),\"\")","v":5.0074983417946539}]
[null,null,null,null,null,null,null,null,"FPC 95% C.I.",{"$f":"IF(ISNUMBER(J28)=TRUE,IF(J17>0,SQRT((J17-J26)/J17)*J29,J29),\"\")","v":4.9949639082640855}]
[null,null,null,null,null,null,null,null,"C.I. width as % of mean",{"$f":"IF(ISNUMBER(J28)=TRUE,J30/J27,\"\")","v":0.19979855633056343}]
[null,null,"Summary statistics calculated for a population total",null,null,null,null,null,"Total Population Size",{"$f":"IF(J17=10^10,\"\",J17*J27)","v":50000}]
[null,null,null,null,null,null,null,null,"95% C.I.",{"$f":"IF(J17=10^10,\"\",J17*J29)","v":10014.996683589308}]
[null,null,null,null,null,null,null,null,"FPC 95% C.I.",{"$f":"IF(J17=10^10,\"\",J17*J30)","v":9989.9278165281703}]
[]
["Sample size to achieve the sampling objective based on pilot sampling results"]
[null,null,null,null,null,null,null,null,"Targeted minimum detectable change from one of above sources",{"$f":"IF(ISNUMBER(J12)=TRUE,J12,IF(ISNUMBER(J27)=TRUE,J11*J27,\"\"))","v":5}]
[]
[null,null,null,"Sample size to meet stated sampling objective",null,null,null,null,null,{"$f":"IF(ISNUMBER(J28)=TRUE,2*((J28^2)*(TINV(J9,J43)+TINV(2*(1-J6),J43))^2)/((J37)^2),\"\")","v":34.41004122664912}]
[]
[null,null,"FPC-adjusted sample size to meet stated sampling objective",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J28)=TRUE,(J39)/(1+(J39/J17)),\"\")","v":33.82802928548422}]
[]
[null,null,null,null,null,null,null,null,"Iterative cell (df) (don't modify)",{"$f":"IF(ISNUMBER(J28)=TRUE,IF(ISERR(J39),100,(J39)*2-2),\"\")","v":66.820082453298241}]
[]
["Minimum detectable change size based on sample size and standard deviation from pilot sampling, at targeted power and stated false-change error rate",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J28)=TRUE,SQRT(2*((J28^2)*(TINV(J9,(J26*2-2))+TINV(2*(1-J6),(J26*2-2)))^2)*(1-J26/J17)/(J26)),\"\")","v":9.569246958919738}]
[]
["Calculated power based on sample size and standard deviation from pilot sampling, targeted MDC and stated false-change error rate.",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J28)=TRUE,IF((SQRT((J26/(1-J26/J17)*(J37)^2)/(2*(J28^2)))-TINV(J9,(J26*2-2)))<0,((TDIST(ABS((SQRT((J26/(1-J26/J17)*(J37)^2)/(2*(J28^2))))-(TINV(J9,(J26*2-2)))),J26*2-2,2))/2),(1-(TDIST((SQRT((J26/(1-J26/J17)*(J37)^2)/(2*(J28^2))))-(TINV(J9,(J26*2-2))),(J26*2-2),2))/2)),\"\")","v":0.44788742623960548}]

{"sheet":"Two means -- permanent","index":4,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,0,2,9],[11,2,11,8],[10,0,11,0],[25,1,26,8],[19,2,21,4],[10,2,10,8],[14,1,16,4],[5,1,5,8],[18,0,18,8],[47,0,47,8],[39,3,39,8],[41,2,41,8],[19,0,24,0],[19,1,21,1],[22,2,24,4],[32,3,34,4],[27,3,27,8],[29,1,31,4],[28,1,28,8],[45,0,45,8],[22,1,24,1]]}
[]
[]
["The user needs to enter desired power, acceptable false-change error rate, targeted minimum detectable change and summary statistics from pilot sampling"]
[]
["Targeted power, false-change error, minimum detectable change"]
[null,"Desired power (e.g., 0.80, 0.90)",null,null,null,null,null,null,null,0.9]
[null,"Acceptable false-change error rate (e.g., 0.10, 0.20) ",null,null,null,null,null,null,null,0.1]
[null,"Enter 1 or 2 for 1- or 2-sided test",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,"adjusted alpha based on 1-sided or 2-sided test",{"$f":"IF(J8=1,J7*2,J7)","v":0.1}]
[null,"Targeted minimum detectable change -- choose one of the following:"]
[{"$f":"IF(J11<>0,IF(J12<>0,\"Warning - enter 1 choice only\",\"\"),\"\")","v":""},"A.","MDC as a percent of mean (e.g., within ± 20% of mean)",null,null,null,null,null,null,0.2]
[null,"B.","MDC in absolute measurement units"]
[]
["Additional information if sampling from a Finite Population"]
[null,"If no information is specified on lines 15 & 16, an infinite or very large ratio of population size to sampling unit size is assumed.",null,null,null,null,null,null,"Specify total population area -->",100000]
[null,null,null,null,null,null,null,null,"Specify area of 1 quadrat -->",10]
[null,null,null,null,null,null,null,null,"Formula yields big N =",{"$f":"IF(J16>0,J15/J16,10^10)","v":10000}]
[]
["Summary statistics from pilot sampling "]
[{"$f":"IF(SUM(J20:J22)<>0,IF(SUM(J23:J25)<>0,warning,\"\"),\"\")","v":""},"A.","Summary statistics derived from data pasted below starting on line 50",null,null,null,null,null,"n"]
[null,null,null,null,null,null,null,null,"Sample mean or mean difference"]
[null,null,null,null,null,null,null,null,"Standard dev (or sd of difference)"]
[null,"B.","Summary statistics typed in by user",null,null,null,null,null,"n",10]
[null,null,null,null,null,null,null,null,"Sample mean or mean difference",3.6]
[null,null,null,null,null,null,null,null,"Standard dev (or sd of difference)",1.67]
[null,"If the data in A or B is based on first year of data only, enter \"1\" and then specify the estimated correlation coefficient on line 28 below.\nIf the data in A or B is based on sampling unit differences, enter \"2\".  If a \"2\" is entered and the MDC was specified as a relative change above, then enter the mean value to apply the relative change to on line 29 below.",null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J26=1,\"based on 1 year of data\",IF(J26=2,\"based on differences\",\"specify 1 or 2 years data\"))","v":"based on 1 year of data"}]
[null,null,null,"Estimated between-years correlation coefficient",null,null,null,null,null,0.5]
[null,"Mean value to use as basis for applying a relative MDC (if entered above on line 11) when data is based on between-year (or between-pair) differences",null,null,null,null,null,null,null,7.8]
[null,"Summary statistics copied from one of the above sources that is used in sample size, MDC, and Power calculations",null,null,null,null,null,null,"n",10]
[null,null,null,null,null,null,null,null,"Sample mean difference",{"$f":"IF(ISNUMBER(J24)=TRUE,J24,J21)","v":3.6}]
[null,null,null,null,null,null,null,null,"Standard deviation of differences",{"$f":"IF(J26=2,IF(ISNUMBER(J25)=TRUE,J25,J22),IF(J26=1,IF(ISNUMBER(J25)=TRUE,(J25*(SQRT(2*(1-J28)))),(J22*(SQRT(2*(1-J28)))))))","v":1.67}]
[null,null,null,"Confidence intervals around sample mean",null,null,null,null,"95% C.I.",{"$f":"IF(ISNUMBER(J32)=TRUE,J32/SQRT(J30)*TINV(0.05,J30-1),\"\")","v":1.1946460329710102}]
[null,null,null,null,null,null,null,null,"FPC 95% C.I.",{"$f":"IF(ISNUMBER(J32)=TRUE,IF(J17>0,SQRT((J17-J30)/J17)*J33,J33),\"\")","v":1.1940485605490585}]
[null,null,null,null,null,null,null,null,"C.I. width as % of mean",{"$f":"IF(ISNUMBER(J32)=TRUE,J34/J31,\"\")","v":0.3316801557080718}]
[]
["Sample size to achieve the sampling objective based on pilot sampling results"]
[null,null,null,null,null,null,null,null,"Targeted minimum detectable change ",{"$f":"IF(ISNUMBER(J12)=TRUE,J12, IF(J26=1,(IF(ISNUMBER(J31)=TRUE,J11*J31,\"FALSE1\")),IF(J26=2,(IF(ISNUMBER(J29)=TRUE,J11*J29,\"FALSE2\")))))","v":0.72000000000000008}]
[]
[null,null,null,"Sample size to meet stated sampling objective",null,null,null,null,null,{"$f":"IF(ISNUMBER(J32)=TRUE,((J32^2)*(NORMSINV(1-J7/2)+NORMSINV(J6))^2)/((J38)^2),\"\")","v":46.071978928005223}]
[]
[null,null,"FPC-adjusted sample size to meet stated sampling objective",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J32)=TRUE,(J40)/(1+(J40/J17)),\"\")","v":45.860689655263108}]
[]
[null,null,null,null,null,null,null,null,"Iterative cell (df) (don't modify)",{"$f":"IF(ISNUMBER(J32)=TRUE,IF(ISERR(J40),10,(J40)*1-1),\"\")","v":45.071978928005223}]
[]
["Minimum detectable change size based on sample size and standard deviation from pilot sampling, at targeted power and stated false-change error rate",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J32)=TRUE,SQRT(((J32^2)*(TINV(J9,(J30-1))+TINV(2*(1-J6),(J30-1)))^2)*(1-J30/J17)/(J30)),\"\")","v":1.6975961688233459}]
[]
["Calculated power based on sample size and standard deviation from pilot sampling, targeted MDC and stated false-change error rate.",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J32)=TRUE,IF((SQRT((J30/(1-J30/J17)*(J38)^2)/(J32^2))-TINV(J9,(J30-1)))<0,((TDIST(ABS((SQRT((J30/(1-J30/J17)*(J38)^2)/(J32^2)))-(TINV(J9,(J30-1)))),J30-1,2))/2),(1-(TDIST((SQRT((J30/(1-J30/J17)*(J38)^2)/(J32^2)))-(TINV(J9,(J30-1))),J30-1,2))/2)),\"\")","v":0.32509292392868022}]

{"sheet":"CI for proportion","index":5,"n_rows":26,"n_cols":31,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,0,3,9],[6,1,6,8],[8,2,8,8],[23,3,23,8],[15,0,15,8],[16,0,17,1],[16,2,17,2],[16,3,17,5],[21,3,21,8]]}
[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,"Z-alpha",{"$f":"TINV(1-J7,10000)","v":1.6450060180689643},null,"Sample size",{"$f":"((AB1/AB3)^2)*(AB2)*(1-AB2)","v":173.18686716691906}]
[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,"p1",{"$f":"$J$18","v":0.2},null,"Sample size  with FPC"]
[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,"C.I. width",{"$f":"$J$9","v":0.05},null,"using n*=n/(1+n/N)",{"$f":"(J22)/(1+(J22/$J$14))","v":173.99999697240003}]
["The user needs to enter targeted level of precision from a sampling objective and summary statistics from pilot sampling"]
[]
["Targeted precision level"]
[null,"Desired confidence level (e.g., 90%, 95%)",null,null,null,null,null,null,null,0.9]
[null,"Desired confidence interval width -- as an absolute value"]
[null,null,"Absolute confidence interval width",null,null,null,null,null,null,0.05]
[]
["Additional information if sampling from a Finite Population"]
[null,null,null,null,null,null,null,null,"Specify total population area -->"]
[null,null,null,null,null,null,null,null,"Specify area of 1 quadrat -->"]
[null,null,null,null,null,null,null,null,"Formula yields big N =",{"$f":"IF(J13>0,J12/J13,10^10)","v":10000000000}]
[]
["Summary statistics from pilot sampling"]
[null,null,null,"Summary statistics typed in by user",null,null,null,null,"n",50]
[null,null,null,null,null,null,null,null,"Sample proportion",0.2]
[]
["Sample size to achieve the sampling objective based on pilot sampling results"]
[]
[null,null,null,"Sample size",null,null,null,null,null,{"$f":"ROUNDUP(AE1,0)","v":174}]
[]
[null,null,null,"FPC Sample size",null,null,null,null,null,{"$f":"ROUNDUP(AE3,0)","v":174}]
[]
[null,null,null,null,null,null,null,null,"Iterative cell (don't modify)"]

{"sheet":"Two proportions -- temporary","index":6,"n_rows":31,"n_cols":43,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,2,28,8],[25,2,25,8],[16,0,16,7],[17,0,19,1],[17,2,19,2],[17,3,19,5],[27,1,27,8],[2,0,2,9],[5,1,5,8],[9,1,9,9],[13,14,13,17],[24,1,24,8]]}
[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,"Two-sample",null,"Z-alpha",{"$f":"TINV(J9,10000)","v":1.6450060180689643},"p1",{"$f":"$J$19","v":0.1},"Sample size","Sample size  with FPC",null,null,"Sokal and Rohlf version",null,"p - mean",{"$f":"(AF1+AF2)/2","v":0.15000000000000002},"Sample size","Sample size  with FPC"]
[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,"Snedecor and Cochran",null,"Z-beta",{"$f":"TINV(2*(1-J6),10000)","v":1.2816362297302046},"p2",{"$f":"$J$20","v":0.2},{"$f":"((AD1+AD2)^2)*((AF1*(1-AF1)+AF2*(1-AF2))/(AF2-AF1)^2)","v":214.13087116507432},"using n*=n/(1+n/N)",{"$f":"(J25)/(1+(J25/$J$15))","v":206.13614573346118},null,null,null,"A",{"$f":"(((AD1)*SQRT(2*(AN1)*(1-AN1)))+((AD2)*SQRT(((AF1)*(1-AF1))+((AF2)*(1-AF2)))))^2","v":2.1653282452970619},{"$f":"(AN2*(1+SQRT(1+(4*(AF1-AF2)/(AN2))))^2)/(4*(AF1-AF2)^2)","v":196.02267947778455},"using n*=n/(1+n/N)",{"$f":"(J28)/(1+(J28/$J$15))","v":189.532422551472}]
["The user needs to enter desired power, acceptable false-change error rate, targeted minimum detectable change and summary statistics from pilot sampling"]
[]
["Targeted power, false-change error, minimum detectable change"]
[null,"Desired power (e.g., 0.80, 0.90)",null,null,null,null,null,null,null,0.9]
[null,"Acceptable false-change error rate (e.g., 0.10, 0.20) ",null,null,null,null,null,null,null,0.1]
[null,"Enter 1 or 2 for 1- or 2-sided test",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,"adjusted alpha based on 1-sided or 2-sided test",{"$f":"IF(J8=1,J7*2,J7)","v":0.1}]
[null,"Targeted minimum detectable change -- Enter data in Cells J19 & J20"]
[]
["Additional information if sampling from a Finite Population"]
[null,null,null,null,null,null,null,null,"Specify total population area -->",5000]
[null,null,null,null,null,null,null,null,"Specify area of 1 quadrat -->",1]
[null,null,null,null,null,null,null,null,"Formula yields big N =",{"$f":"IF(J14>0,J13/J14,10^10)","v":5000}]
[]
["Summary statistics from pilot sampling (need to type in summary stats or derive from data pasted into this file starting on line 50)"]
[null,null,null,"Summary statistics typed in by user",null,null,null,null,"n",100]
[null,null,null,null,null,null,null,null,"Proportion 1",0.1]
[null,null,null,null,null,null,null,null,"Proportion 2",0.2]
[]
["Sample size to achieve the sampling objective based on pilot sampling results"]
[null,null,null,null,null,null,null,null,"Targeted minimum detectable change ",{"$f":"MAX(J19:J20)-MIN(J19:J20)","v":0.1}]
[]
[null,"2 sample Snedecor and Cochran sample size to meet stated sampling objective",null,null,null,null,null,null,null,{"$f":"ROUNDUP(AG2,0)","v":215}]
[null,null,"FPC-adjusted sample size to meet stated sampling objective",null,null,null,null,null,null,{"$f":"ROUNDUP(AI2,0)","v":207}]
[]
[null,"2 sample Sokal and Rohlf sample size to meet stated sampling objective",null,null,null,null,null,null,null,{"$f":"ROUNDUP(AO2,0)","v":197},"Propose hiding these cells"]
[null,null,"FPC-adjusted sample size to meet stated sampling objective",null,null,null,null,null,null,{"$f":"ROUNDUP(AQ2,0)","v":190}]
[]
[null,null,null,null,null,null,null,null,"Iterative cell (df) (don't modify)",{"$f":"IF(ISNUMBER(#REF!)=TRUE,IF(ISERR(#REF!),100,(#REF!)*2-2),\"\")","v":""}]

{"sheet":"Two stage hidden","index":7,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":true,"merged":[[42,0,42,8],[44,0,44,8],[23,2,25,5],[26,4,28,5],[29,2,31,5],[36,3,36,8],[38,2,38,8],[17,0,22,1],[17,2,19,2],[17,3,19,5],[20,2,22,2],[20,3,22,5],[16,0,16,7],[2,0,2,9],[5,1,5,8],[8,0,9,0],[8,2,8,8],[9,2,9,8]]}
[]
[]
["The user needs to enter desired power, acceptable false-change error rate, targeted minimum detectable change and summary statistics from pilot sampling"]
[]
["Targeted power, false-change error, minimum detectable change"]
[null,"Desired power (e.g., 0.80, 0.90)",null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Acceptable false-change error rate (e.g., 0.10, 0.20) ",null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Targeted minimum detectable change -- choose one of the following:"]
[{"$f":"IF(J9<>0,IF(J10<>0,warning,\"\"),\"\")","v":{"$error":"#REF!"}},"A.","MDC as a percent of mean (e.g., within ± 20% of mean)",null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"B.","MDC in absolute measurement units"]
[]
["Additional information if sampling from a Finite Population"]
[null,null,null,null,null,null,null,null,"Specify total population area -->",{"$f":"#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Specify area of 1 quadrat -->",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Formula yields big N =",{"$f":"IF(J14>0,J13/J14,10^10)","v":{"$error":"#REF!"}}]
[]
["Summary statistics from pilot sampling (need to type in summary stats or derive from data pasted into this file starting on line 50)"]
[{"$f":"IF(SUM(J19:J20)<>0,IF(SUM(J21:J23)<>0,warning,\"\"),\"\")","v":""},null,"A.","Summary statistics derived from data pasted below starting on line 50",null,null,null,null,"n",{"$f":"IF(COUNT(#REF!)>0,COUNT(#REF!),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Sample mean",{"$f":"IF(COUNT(#REF!)>0,AVERAGE(#REF!),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Sample standard deviation",{"$f":"IF(COUNT(#REF!)>0,STDEV(#REF!),\"\")","v":""}]
[null,null,"B.","Summary statistics typed in by user",null,null,null,null,"n",{"$f":"#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Sample mean",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Sample standard deviation",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Summary statistics copied from one of the above sources that is used in sample size, MDC, and Power calculations",null,null,null,null,null,"n",{"$f":"IF(ISNUMBER(J21)=TRUE,J21,J18)","v":""}]
[null,null,null,null,null,null,null,null,"Sample mean",{"$f":"IF(ISNUMBER(J22)=TRUE,J22,J19)","v":""}]
[null,null,null,null,null,null,null,null,"Sample standard deviation",{"$f":"IF(ISNUMBER(J23)=TRUE,J23,J20)","v":""}]
[null,null,null,null,"Confidence intervals around sample mean",null,null,null,"95% C.I.",{"$f":"IF(ISNUMBER(J26)=TRUE,J26/SQRT(J24)*TINV(0.05,J24-1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"FPC 95% C.I.",{"$f":"IF(ISNUMBER(J26)=TRUE,IF(J15>0,SQRT((J15-J24)/J15)*J27,J27),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"C.I. width as % of mean",{"$f":"IF(ISNUMBER(J26)=TRUE,J28/J25,\"\")","v":""}]
[null,null,"Summary statistics calculated for a population total",null,null,null,null,null,"Total Population Size",{"$f":"IF(J15=10^10,\"\",J15*J25)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"95% C.I.",{"$f":"IF(J15=10^10,\"\",J15*J27)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"FPC 95% C.I.",{"$f":"IF(J15=10^10,\"\",J15*J28)","v":{"$error":"#REF!"}}]
[]
["Sample size to achieve the sampling objective based on pilot sampling results"]
[null,null,null,null,null,null,null,null,"Targeted minimum detectable change from one of above sources",{"$f":"IF(ISNUMBER(J10)=TRUE,J10,IF(ISNUMBER(J25)=TRUE,J9*J25,\"\"))","v":""}]
[]
[null,null,null,"Sample size to meet stated sampling objective",null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,2*((J26^2)*(TINV(J7,J41)+TINV(2*(1-J6),J41))^2)/((J35)^2),\"\")","v":""}]
[]
[null,null,"FPC-adjusted sample size to meet stated sampling objective",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,(J37)/(1+(J37/J15)),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,"Iterative cell (df) (don't modify)",{"$f":"IF(ISNUMBER(J26)=TRUE,IF(ISERR(J37),100,(J37)*2-2),\"\")","v":""}]
[]
["Minimum detectable change size based on sample size and standard deviation from pilot sampling, at targeted power and stated false-change error rate",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,SQRT(2*((J26^2)*(TINV(J7,(J24*2-2))+TINV(2*(1-J6),(J24*2-2)))^2)*(1-J24/J15)/(J24)),\"\")","v":""}]
[]
["Calculated power based on sample size and standard deviation from pilot sampling, targeted MDC and stated false-change error rate.",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J26)=TRUE,IF((SQRT((J24/(1-J24/J15)*(J35)^2)/(2*(J26^2)))-TINV(J7,(J24*2-2)))<0,((TDIST(ABS((SQRT((J24/(1-J24/J15)*(J35)^2)/(2*(J26^2))))-(TINV(J7,(J24*2-2)))),J24*2-2,2))/2),(1-(TDIST((SQRT((J24/(1-J24/J15)*(J35)^2)/(2*(J26^2))))-(TINV(J7,(J24*2-2))),(J24*2-2),2))/2)),\"\")","v":""}]