{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":[" Bootstrap Macro"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":1,"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":" Bootstrap Macro","index":0,"n_rows":38,"n_cols":36,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,37,4],[9,1,16,11],[1,1,6,11],[36,1,36,4],[26,5,26,8]]}
[]
[null,"Enabling Macros \n\nMacros must be enabled in order the spreadsheet to work.  If you are using Excel version 2003 or lower, check the Enable Macros option that appears when the spreadsheet is first opened.  If you are using Excel 2007 or later, click on the box labeled \"Options\" that appears along the top of the spreadsheet and then select Enable this content.",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,null,null,null,null,5000,"Median","Upper 95% CI for effluent concentration"]
[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,null,null,null,null,null,null,10000,"Mean","Lower 95% CI for removal efficiency"]
[]
[]
[]
[]
[]
[]
[null,"Macro Description\n\nThe macro can calculate either the one-tailed upper 95% confidence interval around the effluent concentration, or the one-tailed lower 95% confidence interval around the pollutant removal efficiency.  To perform these calcualtions, the macro randomly resamples the original data to create 5000 or 10000 datasets with the same number of values as the original data.  The mean or median of each resampled dataset is then calculated.  The mean/medians are then sorted in ascending order.  The one-tailed upper 95% confidence interval around the effluent concentration is the value with the rank of 9500 out of 10000.  The one-tailed lower 95% confidence interval around the pollutant removal efficiency is the value with the rank of 500 out of 10000.  THIS MACRO SHOULD ONLY BE USED WHEN THERE ARE 10 OR MORE DATA POINTS FOR EFFLUENT CONCENTRATION OR POLLUTANT REMOVAL EFFICIENCY."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1.  Clear any previous effluent and remove data by clicking on the Clear Data button",null,null,null,null,null,null,null,null,"Effluent Concentration","Removal Efficiency (%)"]
[]
[null,"2. Enter effluent concentration and remove efficiency data in columns K and L"]
[]
[null,"3. Select which confidence limit to calculate (click cell to show drop down)"]
[]
[null,null,null,null,null,"Upper 95% CI for effluent concentration"]
[]
[null,"4. Select calculation method",null,null,null,"Median"]
[]
[null,"5. Select the number of iterations",null,null,null,10000]
[]
[]
[null,"5.  Click on the calculate button"]
[]
[]
[]
[null,"Upper 95% CI for effluent concentration"]