{"id":254,"date":"2020-06-03T12:26:04","date_gmt":"2020-06-03T16:26:04","guid":{"rendered":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/?page_id=254"},"modified":"2020-08-05T21:14:35","modified_gmt":"2020-08-06T01:14:35","slug":"spreadsheet-exercises-in-conservation-biology-and-landscape-ecology-chapters","status":"publish","type":"page","link":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/spreadsheet-exercises-in-conservation-biology-and-landscape-ecology-chapters\/","title":{"rendered":"Spreadsheet Exercises in Conservation Biology and Landscape Ecology Chapters"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>Each Chapter contains a .pdf with the text, a completed example spreadsheet (.xlsx), a spreadsheet shell (.xlsx). Some Chapters also include a .pdf with answers to questions in the chapter.  Some chapters require macros in Excel.  Click <a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/ecology-and-evolution-spreadsheet-macros-instructions\/\">here<\/a> to learn more about macros.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 0: Spreadsheet Tips and Tricks<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/00-Donov-intro-CB.pdf\">Download Chapter<\/a><\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 1: Mathematical Functions and Graphs<\/summary><div class=\"ab-accordion-text\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/01-Donov-pages-305-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/01_Mathematical_Functions.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/01_Mathematicical_Func_shell.xlsx\">Download Excel Shell<\/a><\/li><li>Download Answers <\/li><\/ul>\n<\/div><\/div>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 2: Spreadsheet Functions and Macros (macros)<\/summary><div class=\"ab-accordion-text\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/02-Donov-pages-324-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/02_Functions_and_Macros.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/02_Functions_Macros_shell.xlsx\">Download Excel Shell<\/a><\/li><li>Download Answers <\/li><\/ul>\n<\/div><\/div>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 3: Statistical Distributions (macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/03-Donov-pages-323-CB.pdf\">Download Chapter<\/a><\/li><li>Download Excel File<\/li><li>Download Excel Shell<\/li><li>Download Answers <\/li><li><a href=\"http:\/\/www.quantitativeskills.com\/sisa\/rojo\/distribs.htm\">Statistical Distributions helpful link<\/a><\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 4: Central Limit Theorem (macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/04-Donov-pages-201-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/04_Central_Limit.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/04_Central_Limit_shell.xlsx\">Download Excel Shell<\/a><\/li><li>Download Answers  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 5: Hypothesis Testing: Alpha, Beta, and Power (macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/05-Donov-pages-211-CB-pdf.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/05_Hypothesis_Testing.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/05_Hypothesis_Testing_shell.xlsx\">Download Excel Shell<\/a><\/li><li>Download Answers <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 6: Sampling Species Richness (macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/06-Donov-pages-210-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/06_Species_Richness.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/06_Species_Richness_shell.xlsx\">Download Excel Shell<\/a><\/li><li>Download Answers  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 7: Geometric and Exponential Population Growth<\/summary><div class=\"ab-accordion-text\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/07-Donov-pages-304-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/07_Geometric_Exponential.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/07_Geometric_and_Exponen_shell.xlsx\">Download Excel Shell<\/a><\/li><li>Download Answers  <\/li><\/ul>\n<\/div><\/div>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 8: Logistic Population Models<\/summary><div class=\"ab-accordion-text\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"wp-block-list\"><li> <a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/08-Donov-pages-312-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/08_Logistic-1.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/08_Logistic_sheel.xlsx\">Download Excel Shell<\/a><\/li><li>Download Answers  <\/li><\/ul>\n<\/div><\/div>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 9: Island Biogeography<\/summary><div class=\"ab-accordion-text\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"wp-block-list\"><li> <a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/09-Donov-pages-310-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/09_Island_Biogeography.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/09_Island_Biogeography_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb9.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/div>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 10:  Life Tables, Survivorship Curves, and Population Growth<\/summary><div class=\"ab-accordion-text\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/10-Donov-pages-311-CB.pdf\"> Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/10_Life_Tables.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/10_Life_Tables_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb10.pdf\">Download Answers  <\/a><\/li><\/ul>\n<\/div><\/div>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 11: Age-Structured Matrix Models<\/summary><div class=\"ab-accordion-text\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"wp-block-list\"><li> <a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/11-Donov-pages-101-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/11_Age_Structure.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/11_Age_Structure.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb11.pdf\">Download Answers <\/a> <\/li><\/ul>\n<\/div><\/div>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 12: Stage Structured Matrix Models<\/summary><div class=\"ab-accordion-text\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/12-Donov-pages-322-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/12_Stage_Structure.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/12_Stage_Structures_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb12.pdf\">Download Answers  <\/a><\/li><\/ul>\n<\/div><\/div>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 13:  Reproductive Value: Matrix Approach<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li> <a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/13-Donov-pages-318-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/13_Reproductive_Value_Mat.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/13_Reprod_Value_Matrix_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb13.pdf\">Download Answers  <\/a><\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 14: Reproductive Value: Life Table Approach<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li> <a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/14-Donov-pages-317-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/14_Reproductive_Value_Life.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/14_Reprod_Value_Life_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb14.pdf\">Download Answers <\/a> <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 15: Sensitivity and Elasticity Analysis<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li> <a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/15-Donov-pages-319-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/15_Sensitivity.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/15_Sensitivity_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb15.pdf\">Download Answers<\/a><\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 16: Meta-population Dynamics (Macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/16-Donov-pages-314-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/16_Metapop.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/16_Metapop_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb16.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 17: Source Sink Dynamics<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/17-Donov-pages-320-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/17_Source-Sink.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/17_Source-Sink_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb17.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 18: Population Estimation with Mark-Recapture Techniques<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/18-Donov-pages-315-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/18_Population_Estimation.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/18_Population_Estimation_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb18.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 19: Range Expansion<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/19-Donov-pages-316-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/19_Range_Expansion.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/19_Range_Expansion_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb19.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 20: Adaptation: Persistence in a Changing Environment (Macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/20-Donov-pages-301-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/20_Adaptation.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/20_Adaptation_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb20.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 21: Hardy-Weinberg Equilibrium (Macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/21-Donov-pages-308-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/21_Hardy-Weinberg.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/21_Hardy-Weinberg_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb21.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 22: Gene Flow and Population Structure<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/22-Donov-pages-306-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/22_Gene_Flow.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/22_Gene_Flow_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb22.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 23: Genetic Diversity (Macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/23-Donov-pages-313-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/23_Genetic_Diversity.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/23_Genetic_Diversity_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb23.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 24: Inbreeding, Outbreeding, and Random Mating<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/24-Donov-pages-309-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/24_Inbreeding.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/24_Inbreeding_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb24.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 25: Genetic Drift (Macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/25-Donov-pages-307-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/25_Genetic_Drift.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/25_Genetic_Drift_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb25.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 26: Effective Population Size<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/26-Donov-pages-303-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/26_Effective_Pop_Size.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/26_Effective_Pop_Size_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb26.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 27: Demographic Stochasticity (Macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/27-Donov-pages-302-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/27_Demographic_Stoch.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/27_Demog_Stochast_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb27.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 28: Population Viability Analysis<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/28-Donov-pages-207-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/28_pva.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/28_PVA_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb28.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 29: Harvest Models<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/29-Donov-pages-204-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/29_Harvest.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/29_Harvest_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb29.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 30: Quantifying Landscape Patterns<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/30-Donov-pages-205-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/30_Landscape.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/30_Landscape_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb30.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 31: Edge Effects and Ecological Traps<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/31-Donov-pages-203-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/31_Edge_Effects.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/31_Edge_Effects_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb31.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 32: Triage: Prioritizing Species and Habitats<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/32-Donov-pages-208-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/32_Triage.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/32_Triage_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb32.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 33: Reserve Design<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/33-Donov-pages-202-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/33_Reserve.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/33_Reserve_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb33.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 34: VBA Landscape Programming (Macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/34-Donov-pages-212-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/34_vba.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/34_VBA_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb34.pdf\">Download Answers <\/a> <\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/34_detail-1.docx\">Helpful Hints and Details<\/a><\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 35: Neutral Landscape Theory and Connectivity (Macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/35-Donov-pages-206-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/35_Neutral.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/35_Neutral_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb35.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div class=\"wp-block-atomic-blocks-ab-accordion ab-block-accordion\"><details><summary class=\"ab-accordion-title\">Chapter 36: Random Walks (Macros)<\/summary><div class=\"ab-accordion-text\">\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/36-Donov-pages-209-CB.pdf\">Download Chapter<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/36_Random_Walks.xlsx\">Download Excel File<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/36_Random_Walks_shell.xlsx\">Download Excel Shell<\/a><\/li><li><a href=\"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/files\/2020\/06\/cb36.pdf\">Download Answers<\/a>  <\/li><\/ul>\n<\/div><\/details><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Any Questions\/Suggestions?   Please contact tdonovan@uvm.edu. <\/p>\n\n\n\n<p>Page Last Updated: June 26, 2020<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Each Chapter contains a .pdf with the text, a completed example spreadsheet (.xlsx), a spreadsheet shell (.xlsx). Some Chapters also include a .pdf with answers to questions in the chapter. Some chapters require macros in Excel. Click here to learn more about macros. Any Questions\/Suggestions? Please contact tdonovan@uvm.edu. Page Last Updated: June 26, 2020<\/p>\n","protected":false},"author":6084,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-254","page","type-page","status-publish","hentry","entry"],"featured_image_src":null,"featured_image_src_square":null,"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/wp-json\/wp\/v2\/pages\/254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/wp-json\/wp\/v2\/users\/6084"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/wp-json\/wp\/v2\/comments?post=254"}],"version-history":[{"count":35,"href":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/wp-json\/wp\/v2\/pages\/254\/revisions"}],"predecessor-version":[{"id":849,"href":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/wp-json\/wp\/v2\/pages\/254\/revisions\/849"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/tdonovan-vtcfwru\/wp-json\/wp\/v2\/media?parent=254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}