2010_TRUS_Optimal_Allocation.xls and 2015_TRUS_Optimal_Allocation.xlsx are Excel files that were created and used by MBM-AK to to determine the survey area stratification and sample selection for the 2010 and 2015 Alaska Trumpeter Swan Surveys. The 2010 and 2015 surveys were a stratified random-sample plot design with optimal allocation of sampling effort to minimize cost for a fixed variance. Note: The Excel files contain multiple worksheets, with each worksheet being a step in the process that progressed from the left-most worksheet towards the right.