* [[en:ecovirt:roteiro:pop_str:pstr_ddexcel|{{:ecovirt:logcalc.jpg?20|}}]] * [[en:ecovirt:roteiro:pop_str:pstr_ddr|{{:ecovirt:rlogo.png?direct&20|}}]] ====== Density dependence in structured populations - Tutorial in Spreadsheets ====== The [[en:ecovirt:roteiro:pop_str:pstr_mtexcel| basic model of transition matrices]] does not include any kind of restriction on the increase of the natural population. Therefore, this model assumes that the resources are unlimited and that the population grows (or decreases) at a constant rate. We know, however, that populations are limited by many mechanisms (eg interaction with populations of other species, resource constraints, dispersion limitation). One way in which populations are limited is related to their own density. These regulatory mechanisms associated with the density of the population are denominated dense dependence: changes in the vital rates of the populations associated to the variations of its own density. ===== Density dependence in a cacti population ==== In this exercise we will relax the premise of indefinite growth including a dense-dependence effect on one of the transition probabilities: transition in the cactus seedlings //Escobaria robbinsorum// (example in chapter 5 of Gurevitch et al 2009, a matrix of 3 stages of life). Let us use the brake expression of the known [[en:ecovirt:roteiro:den_dep:den_deprcmdr| logistic growth model]], which will act on the probability of permanence of the seedlings (element $a_{2,1}$ of the matrix). For this, this probability of transiting in time $t + 1$ becomes the function $$a_{2,1}=a_{max}(1-\frac{N_t}{K})$$ ((if you have trouble viewing math expressions on this wiki, look for some plugin or extension that has ASCIIMath in the name for {a} {a} { your browser. ** // Chrome // ** the extension is named // MathML-2-CSS // Firefox recognizes the formulas by default, other browsers have not been tested.)) Where $a_{max}$ is the maximum value of the transition probability from state 1 to 2, $N_t$ the population size in time $t$, and $K$ the population carrying capacity. The closer the population size is to $K$, the younger the seedling transition probability, the higher the mortality rate. ==== Inserting dense-dependency into spreadsheet ==== * **1.** Open the DenDep spreadsheet of the {{:ecovirt:roteiro:pop_str:cactus_sem_formulas_2016.xls|file}} de dados do cactus //Escobaria robbinsorum//(Gurevitch et al 2009). of cactus data // Escobaria robbinsorum // (Gurevitch et al 2009). In cells '' B4 '' and '' B5 '' we have the dense-dependency parameters: * $a_{max} = $0,33 * $K = 50 * **2. Calculate the size of the population in time $t$: ** to do that, include in the cell '' G15 '' the formula ''=SUM(G12:G14) ''. * **3. ** In cell '' B6 '' include the formula for calculating the density dependent transition probability: ''=B4*(1-G15/B5)''. * **4.** nclude in the cell '' B7 '' a condition using the '' IF '' function so that the probability of permanence does not fall below zero: ''=SE(B6<0;0;B6)''. * **5.** Direct the result of cell '' B7 '' to the transition matrix. For this, include in the cell "C13" the formula "=B7". Your spreadsheet should look like this one: {{:ecovirt:roteiro:pop_str:densodep1.png?700|}} If you want to check, see the worksheet with the formulas {{:ecovirt:roteiro:pop_str:cactus_com_formulas2015.xls|here}}. ==== Projecting population sizes ==== Now you must perform, in ''H12:H14'' cells, the multiplication of the transition matrix (cells ''$C$12:$E$14'') by the time abundance vector $t$ (cells ''G12:G14''), following the same orientations of the script [en:ecovirt:roteiro:pop_str:pstr_mtexcel| basic model of transition matrices]]. This will result in the vector of abundances in time $t+1$. Now, just reiterate these calculations as follows: * **1.** Copy (**using "copy special" wiht only "values". Do not copy the formulas!!**) the values ​​of ''H12:H14'' on ''G12:G14''. * **2.** Copy the same values ​​that were placed in the cells ''G12:G14 '' also for the column $t2$ (cells ''C18:C20''). * **3.** Note that by replacing the numbers in the ''G12:G14 '' cells, the formulas in the ''H12:H14'' cells will update their values ​​and then you have projected the population one more step of time. Repeat steps 1 and 2 above and, with each substitution, go past the values ​​obtained in the following columns (t3, t4, t5, t6, etc) of the cells "D18:D20". Proceed until the lambda value (which is being automatically calculated on line 23) stabilizes. * **4.** Graph the number of individuals at each stage of life and in total as a function of time. ===== Exercício: Palmito sustentável ===== In our exercise[[en:ecovirt:roteiro:pop_str:pstr_mtexcel&#extracao_de_palmito_e_sustentavel|about palmito extraction without dense dependence]], we used a simple model to evaluate the sustainability of the extraction. However, the results may be unrealistic. For example, in the original model: (1) there was no limitation to the growth of the palm heart population, (2) the transition rates do not vary from year to year; (3) management has no impact on transition rates. The challenge here is to create a more realistic model, including density dependency. Use the transition matrix for a palmito population (// Euterpe edulis // Mart.) In the Santa Genebra Reserve, Campinas (Frenckleton et al., 2002), which is in the worksheet {{ecovirt:roteiro:pop_str:palmitos2011.xls|}}. Using the same procedure of the previous exercise with the cactus: * Choose one of the transition rates to model the dense-dependence in the heart of palm population and justify the choice; * Produce dense-dependency extraction scenarios for the palm heart population; * Make projections and suggestions for the sustainable management of palm heart. ===== To learn more ===== Gotelli, N. J. 2007. Ecologia. Cap.2 - Crescimento Logistico de Populações. Pp. 26-48. Ed. Planta. Gurevitch, J, Scheiner, S.M, Fox, G.A. 2009. Ecologia Vegetal. Cap. 5 - Ed. Artmed, São Paulo. Silva Matos, D.M. et al. 1999. THE ROLE OF DENSITY DEPENDENCE IN THE POPULATION DYNAMICS OF A TROPICAL PALM. Ecology, 80(8), 1999, pp. 2635–2650 {{tag>planilha uma_população população_estruturada exercício}}