{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["Cover page","Table B1- estimates and CIs","Table B2 - Post-hoc tests","Table B3 - threat estim and CIs","Table B4 - changes over time","Table B5 - Continent"],"not_rendered":{"images":4,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Cover page","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"flags":["formulas_cached_only"]}
["Statistics"]
[]
["Content of this file:"]
["Table B1 - Estimates and CIs for animal biodiversity"]
["Table B2 - Post-hoc test outcomes"]
["Table B3 - Estimates and CIs for threatened animal biodiversity"]
["Table B4 - Regression coefficients for models with time as an independent variable and a biodiversity indicator as the dependent variable"]
["Table B5 - Model comparisons with only diversity and with diversity and continent"]

{"sheet":"Table B1- estimates and CIs","index":1,"n_rows":11,"n_cols":18,"rows_kept":11,"merged":[[0,0,0,17],[2,5,10,5],[2,9,10,9],[2,13,10,13],[2,17,10,17]],"flags":["formulas_cached_only"]}
["Table B1. Biodiversity estimates and confidence intervals (CI) for intactness (IN), relative richness (SR), similarity (SI), and relative total abundance (TA) of animal species are presented, with estimates back-transformed. Significant p-values (<0.05) indicate notable differences in biodiversity impacts between various agricultural diversity classes. Cell colors correspond to the scheme used in the main paper."]
["Diversity classes","Nr. Studies","IN - estimate","IN - lower CI","IN - upper CI","p-value","SR - estimate","SR - lower CI","SR - upper CI","p-value ","SI - estimate","SI - lower CI","SI - upper CI","p-value","TA - estimate","TA - lower CI","TA - upper CI","p-value "]
["Agroforestry",35,0.61,0.48,0.71,{"v":4.93e-07,"d":"4.93E-07"},1.12,0.88,1.42,{"v":1.173e-05,"d":"1.17E-05"},0.92,0.86,0.95,"< 2.2e-16",0.98,0.69,{"v":1.4,"d":"1.40"},{"v":0.4671,"d":"0.47"}]
["Sparse trees on agricultural land",15,0.35,{"v":0.2,"d":"0.20"},0.53,null,0.78,0.54,1.14,null,0.65,0.41,0.83,null,1.11,0.63,1.95]
["Silvopasture",11,0.44,0.25,0.65,null,0.75,0.52,1.08,null,0.83,0.61,0.94,null,0.99,0.56,1.76]
["Sparse trees on pasture land",6,0.36,0.15,0.65,null,0.79,0.47,1.34,null,0.72,0.36,0.92,null,1.05,0.48,2.32]
["Monoculture annual crops",25,{"v":0.2,"d":"0.20"},0.12,0.31,null,0.71,0.53,0.94,null,0.54,0.36,0.71,null,1.07,{"v":0.7,"d":"0.70"},1.64]
["Monoculture perennial crops",37,0.32,0.23,0.44,null,0.65,0.52,{"v":0.8,"d":"0.80"},null,0.69,0.55,0.81,null,0.85,{"v":0.6,"d":"0.60"},1.17]
["Multiculture annual crops",6,0.41,0.18,0.69,null,0.69,0.39,1.23,null,0.87,{"v":0.6,"d":"0.60"},0.97,null,0.38,0.16,0.91]
["Multiculture perennial crops",14,0.44,0.27,0.63,null,0.72,0.51,1.01,null,0.77,0.55,{"v":0.9,"d":"0.90"},null,1.13,0.65,1.95]
["Pasture",38,0.33,0.24,0.45,null,0.76,0.61,0.94,null,0.72,0.59,0.83,null,0.77,0.55,1.07]

{"sheet":"Table B2 - Post-hoc tests","index":2,"n_rows":1,"n_cols":31,"rows_kept":1,"merged":[[0,0,0,7],[0,10,0,17],[0,20,0,27],[0,30,0,37]],"flags":["formulas_cached_only"]}
["Table B2a. Results from Tukey post-hoc tests with Bonferroni correction reveal differences in intactness between agricultural diversity classes (p-value < 0.05 = siginficant difference).",{"$nulls":9},"Table B2b. Results from Tukey post-hoc tests with Bonferroni correction reveal differences in relative richness between agricultural diversity classes (p-value < 0.05 = siginficant difference).",{"$nulls":9},"Table B2c. Results from Tukey post-hoc tests with Bonferroni correction reveal differences in similarity between agricultural diversity classes (p-value < 0.05 = siginficant difference).",{"$nulls":9},"Table B2d. Results from Tukey post-hoc tests with Bonferroni correction reveal differences in relative total abundance between agricultural diversity classes (p-value < 0.05 = siginficant difference)."]

{"sheet":"Table B3 - threat estim and CIs","index":3,"n_rows":5,"n_cols":14,"rows_kept":5,"merged":[[0,0,0,13],[2,5,4,5],[2,9,4,9],[2,13,4,13]],"flags":["formulas_cached_only"]}
["Table B3. Biodiversity estimates and confidence intervals (CI) for relative richness (SR), similarity (SI), and relative total abundance (TA) of animal species categorized as vulnerable to critically endangered (obtained by back-transforming the estimates). A p-value less than 0.05 indicates a significant difference in the impacts of various agricultural diversity classes on biodiversity. The cell colors correspond to the color scheme used in the main text."]
["Diversity class","Nr. Studies","SR - estimate","SR - lower CI","SR - upper CI","p-value ","SI - estimate","SI - lower CI","SI - upper CI","p-value","TA - estimate","TA - lower CI","TA - upper CI","p-value "]
["Agroforestry",7,0.94,0.62,1.43,{"v":3.882e-08,"d":"3.88E-08"},0.97,0.87,0.99,"< 2.2e-16",{"v":1.1,"d":"1.10"},0.49,2.46,{"v":0.4671,"d":"0.47"}]
["Sparse trees on agricultural land",3,0.27,0.15,0.47,null,0.78,0.43,0.94,null,0.25,0.06,{"v":1.1,"d":"1.10"}]
["Monoculture perennial crops",11,0.66,0.45,0.98,null,0.59,0.26,0.86,null,{"v":0.2,"d":"0.20"},0.11,0.37]

{"sheet":"Table B4 - changes over time","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[0,0,0,9],[2,0,3,0],[4,0,5,0],[6,0,7,0],[8,0,9,0]],"flags":["formulas_cached_only"]}
["Table B4. Regression coefficients for models where time is included as a fixed effect and the biodiversity metric is the response variable. The biodiversity metrics considered are: intactness (IN), measured as Mean Species Abundance (MSA); relative species richness (SR), represented by the relative number of species; similarity (SI), assessed using the Sørensen Similarity Index; and relative total abundance (TA), determined as the response ratio between the summed abundances of all species in agricultural versus reference sites. The columns CoefInterc and CoefInd display the coefficients for the intercept and the ecological driver, respectively. Additional details include SE (Standard Error), X² (Chi-squared test statistic), p-value (significance of the Chi-squared test), N (number of data points in the model), and df (degrees of freedom)."]
["Indicator","Diversity category","CoefInterc","CoefInd","SEinter","SEind","p-value","X2","N","df"]
["Intactness (IN)","Agroforestry",{"v":-2.53515,"d":"-2.535"},{"v":0.71415,"d":"0.714"},{"v":0.31697,"d":"0.317"},{"v":0.08132,"d":"0.081"},"< 2.2e-16",77.127,15,1]
[null,"Perennial crops ",{"v":-1.437427,"d":"-1.437"},{"v":0.003686,"d":"0.004"},{"v":0.331975,"d":"0.332"},{"v":0.002995,"d":"0.003"},0.2184,{"v":1.5149,"d":"1.51"},11,1]
["Richness (SR)","Agroforestry ",{"v":-1.0864,"d":"-1.086"},{"v":0.2775,"d":"0.278"},{"v":0.3743,"d":"0.374"},{"v":0.1298,"d":"0.130"},{"v":0.03245,"d":"0.0325"},{"v":4.5747,"d":"4.575"},15,1]
[null,"Perennial crops ",{"v":-0.902821,"d":"-0.903"},{"v":0.00387,"d":"0.004"},{"v":0.227287,"d":"0.227"},{"v":0.003961,"d":"0.004"},0.3286,0.9544,11,1]
["Similarity (SI)","Agroforestry ",{"v":-0.76032,"d":"-0.760"},{"v":0.56082,"d":"0.561"},{"v":0.34478,"d":"0.345"},{"v":0.08814,"d":"0.088"},{"v":1.984e-10,"d":"1.98E-10"},40.482,15,1]
[null,"Perennial crops ",{"v":0.160398,"d":"0.160"},{"v":-0.005202,"d":"-0.005"},{"v":0.38416,"d":"0.384"},{"v":0.002639,"d":"0.003"},{"v":0.04873,"d":"0.0487"},{"v":3.8845,"d":"3.885"},11,1]
["Abundance (TA)","Agroforestry ",{"v":-0.48187,"d":"-0.482"},{"v":0.09737,"d":"0.097"},{"v":0.59268,"d":"0.593"},{"v":0.20028,"d":"0.200"},0.6269,{"v":0.2363,"d":"0.236"},15,1]
[null,"Perennial crops ",{"v":-0.857372,"d":"-0.857"},{"v":0.008452,"d":"0.008"},{"v":0.324389,"d":"0.324"},{"v":0.005088,"d":"0.005"},{"v":0.09669,"d":"0.0967"},{"v":2.7593,"d":"2.759"},11,1]

{"sheet":"Table B5 - Continent","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[0,0,0,4],[2,0,9,0],[2,1,3,1],[4,1,5,1],[6,1,7,1],[8,1,9,1]],"flags":["formulas_cached_only"]}
["Table B5. This table shows whether models incorporating both diversity class (D) and continent (C) provided a better fit than those with only diversity class, using ANOVA. The models with the lowest BIC values were considered to have the best performance.  The p-value represents the significance of the difference between models including only diversity class and those including diversity class along with continent (C) as explanatory variables. Models that significantly outperformed others (p-value < 0.05) are highlighted in bold."]
[null,"Indicator","Fixed effects","BIC","p-value"]
["Continent","Intactness (IN)","D",-2840.9]
[null,null,"D + C",-2820,0.3392]
[null,"Richness (SR)","D",434.15]
[null,null,"D + C",455.35,0.3898]
[null,"Similarity (SI)","D",-3151.2]
[null,null,"D + C",-3135.9,0.04729]
[null,"Abundance (TA)","D",626.87]
[null,null,"D + C",643.18,0.07205]