{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Variable 1","Variable 2","Variable 3","Variable 4","average"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Variable 1","index":0,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,4,3],[25,5,25,7],[27,7,37,7],[27,3,37,3],[25,1,25,3]]}
[]
[]
[]
[null,"Stratification for Variable 1"]
[]
[]
[]
[]
[null,null,null,null,null,"Stratum","Area","Mean abundance (y)","Variance (S2)","Coefficient of Variation","P","PS","PS2","Py","Var(y)"]
[null,null,null,null,null,1,null,null,null,{"$f":"SQRT(I10)/H10","v":{"$error":"#DIV/0!"}},{"$f":"G10/$G$20","v":{"$error":"#DIV/0!"}},{"$f":"K10*SQRT(I10)","v":{"$error":"#DIV/0!"}},{"$f":"K10*I10","v":{"$error":"#DIV/0!"}},{"$f":"K10*H10","v":{"$error":"#DIV/0!"}},{"$f":"((1/C29)-(1/G10))*(K10)^2*I10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,2,null,null,null,{"$f":"SQRT(I11)/H11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"((1/C30)-(1/G11))*K11^2*I11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,3,null,null,null,{"$f":"SQRT(I12)/H12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"((1/C31)-(1/G12))*K12^2*I12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,4,null,null,null,{"$f":"(SQRT(I13)/H13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"ISERROR((1/C32)-(1/G13))*K13^2*I13","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,5,null,null,null,{"$f":"SQRT(I14)/H14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"ISERROR((1/C33)-(1/G14))*K14^2*I14","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,6,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,7,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,8,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,9,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,10,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G10:G19)","v":0},null,null,null,null,{"$f":"SUM(L10:L19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M10:M19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N10:N19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O10:O19)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,"Total stratified mean abundance for stratum =",null,null,{"$f":"N20","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Investigating the expected number of sampling points required when varying the coefficient of variation",null,null,null,"Investigating the expected coefficient of variation when varying the total number of sampling points"]
[null,null,"Expected number of sampling points","Coefficient of variation",null,null,"Number of sampling points","Expected coefficient of variation"]
[null,"n",{"$f":"($L$20^2)/((I23*D28)^2+(1/$G$20)*$M$20)","v":{"$error":"#DIV/0!"}},null,null,"n",null,{"$f":"SQRT((L20^2/G28)-(M20/G20))/I23","v":{"$error":"#DIV/0!"}}]
[null,"n1",{"$f":"C$28*($L10/$L$20)","v":{"$error":"#DIV/0!"}},null,null,"n1",{"$f":"$G$28*L10/$L$20","v":{"$error":"#DIV/0!"}}]
[null,"n2",{"$f":"$C$28*L11/$L$20","v":{"$error":"#DIV/0!"}},null,null,"n2",{"$error":"#DIV/0!"}]
[null,"n3",{"$error":"#DIV/0!"},null,null,"n3",{"$error":"#DIV/0!"}]
[null,"n4",{"$error":"#DIV/0!"},null,null,"n4",{"$error":"#DIV/0!"}]
[null,"n5",{"$error":"#DIV/0!"},null,null,"n5",{"$error":"#DIV/0!"}]
[null,"n6",{"$error":"#DIV/0!"},null,null,"n6",{"$error":"#DIV/0!"}]
[null,"n7",{"$error":"#DIV/0!"},null,null,"n7",{"$error":"#DIV/0!"}]
[null,"n8",{"$error":"#DIV/0!"},null,null,"n8",{"$error":"#DIV/0!"}]
[null,"n9",{"$error":"#DIV/0!"},null,null,"n9",{"$error":"#DIV/0!"}]
[null,"n10",{"$error":"#DIV/0!"},null,null,"n10",{"$error":"#DIV/0!"}]

{"sheet":"Variable 2","index":1,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,4,3],[25,1,25,3],[25,5,25,7],[27,3,37,3],[27,7,37,7]]}
[]
[]
[]
[null,"Stratification for Variable 2"]
[]
[]
[]
[]
[null,null,null,null,null,"Stratum","Area","Mean abundance (y)","Variance (S2)","Coefficient of Variation","P","PS","PS2","Py","Var(y)"]
[null,null,null,null,null,1,{"$f":"'Variable 1'!G10","v":0},null,null,{"$f":"SQRT(I10)/H10","v":{"$error":"#DIV/0!"}},{"$f":"G10/$G$20","v":{"$error":"#DIV/0!"}},{"$f":"K10*SQRT(I10)","v":{"$error":"#DIV/0!"}},{"$f":"K10*I10","v":{"$error":"#DIV/0!"}},{"$f":"K10*H10","v":{"$error":"#DIV/0!"}},{"$f":"((1/C29)-(1/G10))*(K10)^2*I10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,2,{"$f":"'Variable 1'!G11","v":0},null,null,{"$f":"SQRT(I11)/H11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"((1/C30)-(1/G11))*K11^2*I11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,3,{"$f":"'Variable 1'!G12","v":0},null,null,{"$f":"SQRT(I12)/H12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"((1/C31)-(1/G12))*K12^2*I12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,4,{"$f":"'Variable 1'!G13","v":0},null,null,{"$f":"(SQRT(I13)/H13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"ISERROR((1/C32)-(1/G13))*K13^2*I13","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,5,{"$f":"'Variable 1'!G14","v":0},null,null,{"$f":"SQRT(I14)/H14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"ISERROR((1/C33)-(1/G14))*K14^2*I14","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,6,{"$f":"'Variable 1'!G15","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,7,{"$f":"'Variable 1'!G16","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,8,{"$f":"'Variable 1'!G17","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,9,{"$f":"'Variable 1'!G18","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,10,{"$f":"'Variable 1'!G19","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G10:G19)","v":0},null,null,null,null,{"$f":"SUM(L10:L19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M10:M19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N10:N19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O10:O19)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,"Total stratified mean abundance for stratum =",null,null,{"$f":"N20","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Investigating the expected number of sampling points required when varying the coefficient of variation",null,null,null,"Investigating the expected coefficient of variation when varying the total number of sampling points"]
[null,null,"Expected number of sampling points","Coefficient of variation",null,null,"Number of sampling points","Expected coefficient of variation"]
[null,"n",{"$f":"($L$20^2)/((I23*D28)^2+(1/$G$20)*$M$20)","v":{"$error":"#DIV/0!"}},{"$f":"'Variable 1'!D28","v":0},null,"n",{"$f":"'Variable 1'!G28","v":0},{"$f":"SQRT((L20^2/G28)-(M20/G20))/I23","v":{"$error":"#DIV/0!"}}]
[null,"n1",{"$f":"C$28*($L10/$L$20)","v":{"$error":"#DIV/0!"}},null,null,"n1",{"$f":"$G$28*L10/$L$20","v":{"$error":"#DIV/0!"}}]
[null,"n2",{"$f":"$C$28*L11/$L$20","v":{"$error":"#DIV/0!"}},null,null,"n2",{"$error":"#DIV/0!"}]
[null,"n3",{"$error":"#DIV/0!"},null,null,"n3",{"$error":"#DIV/0!"}]
[null,"n4",{"$error":"#DIV/0!"},null,null,"n4",{"$error":"#DIV/0!"}]
[null,"n5",{"$error":"#DIV/0!"},null,null,"n5",{"$error":"#DIV/0!"}]
[null,"n6",{"$error":"#DIV/0!"},null,null,"n6",{"$error":"#DIV/0!"}]
[null,"n7",{"$error":"#DIV/0!"},null,null,"n7",{"$error":"#DIV/0!"}]
[null,"n8",{"$error":"#DIV/0!"},null,null,"n8",{"$error":"#DIV/0!"}]
[null,"n9",{"$error":"#DIV/0!"},null,null,"n9",{"$error":"#DIV/0!"}]
[null,"n10",{"$error":"#DIV/0!"},null,null,"n10",{"$error":"#DIV/0!"}]

{"sheet":"Variable 3","index":2,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,4,3],[25,1,25,3],[25,5,25,7],[27,3,37,3],[27,7,37,7]]}
[]
[]
[]
[null,"Stratification for Variable 3"]
[]
[]
[]
[]
[null,null,null,null,null,"Stratum","Area","Mean abundance (y)","Variance (S2)","Coefficient of Variation","P","PS","PS2","Py","Var(y)"]
[null,null,null,null,null,1,{"$f":"'Variable 1'!G10","v":0},null,null,{"$f":"SQRT(I10)/H10","v":{"$error":"#DIV/0!"}},{"$f":"G10/$G$20","v":{"$error":"#DIV/0!"}},{"$f":"K10*SQRT(I10)","v":{"$error":"#DIV/0!"}},{"$f":"K10*I10","v":{"$error":"#DIV/0!"}},{"$f":"K10*H10","v":{"$error":"#DIV/0!"}},{"$f":"((1/C29)-(1/G10))*(K10)^2*I10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,2,{"$f":"'Variable 1'!G11","v":0},null,null,{"$f":"SQRT(I11)/H11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"((1/C30)-(1/G11))*K11^2*I11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,3,{"$f":"'Variable 1'!G12","v":0},null,null,{"$f":"SQRT(I12)/H12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"((1/C31)-(1/G12))*K12^2*I12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,4,{"$f":"'Variable 1'!G13","v":0},null,null,{"$f":"(SQRT(I13)/H13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"ISERROR((1/C32)-(1/G13))*K13^2*I13","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,5,{"$f":"'Variable 1'!G14","v":0},null,null,{"$f":"SQRT(I14)/H14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"ISERROR((1/C33)-(1/G14))*K14^2*I14","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,6,{"$f":"'Variable 1'!G15","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,7,{"$f":"'Variable 1'!G16","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,8,{"$f":"'Variable 1'!G17","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,9,{"$f":"'Variable 1'!G18","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,10,{"$f":"'Variable 1'!G19","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G10:G19)","v":0},null,null,null,null,{"$f":"SUM(L10:L19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M10:M19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N10:N19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O10:O19)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,"Total stratified mean abundance for stratum =",null,null,{"$f":"N20","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Investigating the expected number of sampling points required when varying the coefficient of variation",null,null,null,"Investigating the expected coefficient of variation when varying the total number of sampling points"]
[null,null,"Expected number of sampling points","Coefficient of variation",null,null,"Number of sampling points","Expected coefficient of variation"]
[null,"n",{"$f":"($L$20^2)/((I23*D28)^2+(1/$G$20)*$M$20)","v":{"$error":"#DIV/0!"}},{"$f":"'Variable 1'!D28","v":0},null,"n",{"$f":"'Variable 1'!G28","v":0},{"$f":"SQRT((L20^2/G28)-(M20/G20))/I23","v":{"$error":"#DIV/0!"}}]
[null,"n1",{"$f":"C$28*($L10/$L$20)","v":{"$error":"#DIV/0!"}},null,null,"n1",{"$f":"$G$28*L10/$L$20","v":{"$error":"#DIV/0!"}}]
[null,"n2",{"$f":"$C$28*L11/$L$20","v":{"$error":"#DIV/0!"}},null,null,"n2",{"$error":"#DIV/0!"}]
[null,"n3",{"$error":"#DIV/0!"},null,null,"n3",{"$error":"#DIV/0!"}]
[null,"n4",{"$error":"#DIV/0!"},null,null,"n4",{"$error":"#DIV/0!"}]
[null,"n5",{"$error":"#DIV/0!"},null,null,"n5",{"$error":"#DIV/0!"}]
[null,"n6",{"$error":"#DIV/0!"},null,null,"n6",{"$error":"#DIV/0!"}]
[null,"n7",{"$error":"#DIV/0!"},null,null,"n7",{"$error":"#DIV/0!"}]
[null,"n8",{"$error":"#DIV/0!"},null,null,"n8",{"$error":"#DIV/0!"}]
[null,"n9",{"$error":"#DIV/0!"},null,null,"n9",{"$error":"#DIV/0!"}]
[null,"n10",{"$error":"#DIV/0!"},null,null,"n10",{"$error":"#DIV/0!"}]

{"sheet":"Variable 4","index":3,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,4,3],[25,1,25,3],[25,5,25,7],[27,3,37,3],[27,7,37,7]]}
[]
[]
[]
[null,"Stratification for Variable 4"]
[]
[]
[]
[]
[null,null,null,null,null,"Stratum","Area","Mean abundance (y)","Variance (S2)","Coefficient of Variation","P","PS","PS2","Py","Var(y)"]
[null,null,null,null,null,1,{"$f":"'Variable 1'!G10","v":0},null,null,{"$f":"SQRT(I10)/H10","v":{"$error":"#DIV/0!"}},{"$f":"G10/$G$20","v":{"$error":"#DIV/0!"}},{"$f":"K10*SQRT(I10)","v":{"$error":"#DIV/0!"}},{"$f":"K10*I10","v":{"$error":"#DIV/0!"}},{"$f":"K10*H10","v":{"$error":"#DIV/0!"}},{"$f":"((1/C29)-(1/G10))*(K10)^2*I10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,2,{"$f":"'Variable 1'!G11","v":0},null,null,{"$f":"SQRT(I11)/H11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"((1/C30)-(1/G11))*K11^2*I11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,3,{"$f":"'Variable 1'!G12","v":0},null,null,{"$f":"SQRT(I12)/H12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"((1/C31)-(1/G12))*K12^2*I12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,4,{"$f":"'Variable 1'!G13","v":0},null,null,{"$f":"(SQRT(I13)/H13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"ISERROR((1/C32)-(1/G13))*K13^2*I13","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,5,{"$f":"'Variable 1'!G14","v":0},null,null,{"$f":"SQRT(I14)/H14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"ISERROR((1/C33)-(1/G14))*K14^2*I14","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,6,{"$f":"'Variable 1'!G15","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,7,{"$f":"'Variable 1'!G16","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,8,{"$f":"'Variable 1'!G17","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,9,{"$f":"'Variable 1'!G18","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,10,{"$f":"'Variable 1'!G19","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G10:G19)","v":0},null,null,null,null,{"$f":"SUM(L10:L19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M10:M19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N10:N19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O10:O19)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,"Total stratified mean abundance for stratum =",null,null,{"$f":"N20","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Investigating the expected number of sampling points required when varying the coefficient of variation",null,null,null,"Investigating the expected coefficient of variation when varying the total number of sampling points"]
[null,null,"Expected number of sampling points","Coefficient of variation",null,null,"Number of sampling points","Expected coefficient of variation"]
[null,"n",{"$f":"($L$20^2)/((I23*D28)^2+(1/$G$20)*$M$20)","v":{"$error":"#DIV/0!"}},{"$f":"'Variable 1'!D28","v":0},null,"n",{"$f":"'Variable 1'!G28","v":0},{"$f":"SQRT((L20^2/G28)-(M20/G20))/I23","v":{"$error":"#DIV/0!"}}]
[null,"n1",{"$f":"C$28*($L10/$L$20)","v":{"$error":"#DIV/0!"}},null,null,"n1",{"$f":"$G$28*L10/$L$20","v":{"$error":"#DIV/0!"}}]
[null,"n2",{"$f":"$C$28*L11/$L$20","v":{"$error":"#DIV/0!"}},null,null,"n2",{"$error":"#DIV/0!"}]
[null,"n3",{"$error":"#DIV/0!"},null,null,"n3",{"$error":"#DIV/0!"}]
[null,"n4",{"$error":"#DIV/0!"},null,null,"n4",{"$error":"#DIV/0!"}]
[null,"n5",{"$error":"#DIV/0!"},null,null,"n5",{"$error":"#DIV/0!"}]
[null,"n6",{"$error":"#DIV/0!"},null,null,"n6",{"$error":"#DIV/0!"}]
[null,"n7",{"$error":"#DIV/0!"},null,null,"n7",{"$error":"#DIV/0!"}]
[null,"n8",{"$error":"#DIV/0!"},null,null,"n8",{"$error":"#DIV/0!"}]
[null,"n9",{"$error":"#DIV/0!"},null,null,"n9",{"$error":"#DIV/0!"}]
[null,"n10",{"$error":"#DIV/0!"},null,null,"n10",{"$error":"#DIV/0!"}]

{"sheet":"average","index":4,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,2,3,6]]}
[]
[]
[null,null,"Average of All Variables"]
[]
[]
[null,null,"CV",{"$f":"'Variable 1'!D28","v":0}]
[]
[null,null,null,"Variable 1","Variable 2","Variable 3","Variable 4","Average"]
[]
[null,null,"n",{"$f":"IF(ISERROR('Variable 1'!C28),\"\",'Variable 1'!C28)","v":""},{"$f":"IF(ISERROR('Variable 2'!C28),\"\",'Variable 2'!C28)","v":""},{"$f":"IF(ISERROR('Variable 3'!C28),\"\",'Variable 3'!C28)","v":""},{"$f":"IF(ISERROR('Variable 4'!C28),\"\",'Variable 4'!C28)","v":""},{"$f":"SUM(D10:G10)/(IF(AND(D10:G10)=\"\",\"\",COUNT(D10:G10)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,"n1",{"$f":"IF(ISERROR('Variable 1'!C29),\"\",'Variable 1'!C29)","v":""},{"$f":"IF(ISERROR('Variable 2'!C29),\"\",'Variable 2'!C29)","v":""},{"$f":"IF(ISERROR('Variable 3'!C29),\"\",'Variable 3'!C29)","v":""},{"$f":"IF(ISERROR('Variable 4'!C29),\"\",'Variable 4'!C29)","v":""},{"$f":"SUM(D12:G12)/(IF(AND(D12:G12)=\"\",\"\",COUNT(D12:G12)))","v":{"$error":"#VALUE!"}}]
[null,null,"n2",{"$f":"IF(ISERROR('Variable 1'!C30),\"\",'Variable 1'!C30)","v":""},{"$f":"IF(ISERROR('Variable 2'!C30),\"\",'Variable 2'!C30)","v":""},{"$f":"IF(ISERROR('Variable 3'!C30),\"\",'Variable 3'!C30)","v":""},{"$f":"IF(ISERROR('Variable 4'!C30),\"\",'Variable 4'!C30)","v":""},{"$error":"#VALUE!"}]
[null,null,"n3",{"$f":"IF(ISERROR('Variable 1'!C31),\"\",'Variable 1'!C31)","v":""},{"$f":"IF(ISERROR('Variable 2'!C31),\"\",'Variable 2'!C31)","v":""},{"$f":"IF(ISERROR('Variable 3'!C31),\"\",'Variable 3'!C31)","v":""},{"$f":"IF(ISERROR('Variable 4'!C31),\"\",'Variable 4'!C31)","v":""},{"$error":"#VALUE!"}]
[null,null,"n4",{"$f":"IF(ISERROR('Variable 1'!C32),\"\",'Variable 1'!C32)","v":""},{"$f":"IF(ISERROR('Variable 2'!C32),\"\",'Variable 2'!C32)","v":""},{"$f":"IF(ISERROR('Variable 3'!C32),\"\",'Variable 3'!C32)","v":""},{"$f":"IF(ISERROR('Variable 4'!C32),\"\",'Variable 4'!C32)","v":""},{"$error":"#VALUE!"}]
[null,null,"n5",{"$f":"IF(ISERROR('Variable 1'!C33),\"\",'Variable 1'!C33)","v":""},{"$f":"IF(ISERROR('Variable 2'!C33),\"\",'Variable 2'!C33)","v":""},{"$f":"IF(ISERROR('Variable 3'!C33),\"\",'Variable 3'!C33)","v":""},{"$f":"IF(ISERROR('Variable 4'!C33),\"\",'Variable 4'!C33)","v":""},{"$error":"#VALUE!"}]
[null,null,"n6",{"$f":"IF(ISERROR('Variable 1'!C34),\"\",'Variable 1'!C34)","v":""},{"$f":"IF(ISERROR('Variable 2'!C34),\"\",'Variable 2'!C34)","v":""},{"$f":"IF(ISERROR('Variable 3'!C34),\"\",'Variable 3'!C34)","v":""},{"$f":"IF(ISERROR('Variable 4'!C34),\"\",'Variable 4'!C34)","v":""},{"$error":"#VALUE!"}]
[null,null,"n7",{"$f":"IF(ISERROR('Variable 1'!C35),\"\",'Variable 1'!C35)","v":""},{"$f":"IF(ISERROR('Variable 2'!C35),\"\",'Variable 2'!C35)","v":""},{"$f":"IF(ISERROR('Variable 3'!C35),\"\",'Variable 3'!C35)","v":""},{"$f":"IF(ISERROR('Variable 4'!C35),\"\",'Variable 4'!C35)","v":""},{"$error":"#VALUE!"}]
[null,null,"n8",{"$f":"IF(ISERROR('Variable 1'!C36),\"\",'Variable 1'!C36)","v":""},{"$f":"IF(ISERROR('Variable 2'!C36),\"\",'Variable 2'!C36)","v":""},{"$f":"IF(ISERROR('Variable 3'!C36),\"\",'Variable 3'!C36)","v":""},{"$f":"IF(ISERROR('Variable 4'!C36),\"\",'Variable 4'!C36)","v":""},{"$error":"#VALUE!"}]
[null,null,"n9",{"$f":"IF(ISERROR('Variable 1'!C37),\"\",'Variable 1'!C37)","v":""},{"$f":"IF(ISERROR('Variable 2'!C37),\"\",'Variable 2'!C37)","v":""},{"$f":"IF(ISERROR('Variable 3'!C37),\"\",'Variable 3'!C37)","v":""},{"$f":"IF(ISERROR('Variable 4'!C37),\"\",'Variable 4'!C37)","v":""},{"$error":"#VALUE!"}]
[null,null,"n10",{"$f":"IF(ISERROR('Variable 1'!C38),\"\",'Variable 1'!C38)","v":""},{"$f":"IF(ISERROR('Variable 2'!C38),\"\",'Variable 2'!C38)","v":""},{"$f":"IF(ISERROR('Variable 3'!C38),\"\",'Variable 3'!C38)","v":""},{"$f":"IF(ISERROR('Variable 4'!C38),\"\",'Variable 4'!C38)","v":""},{"$error":"#VALUE!"}]
[]
[null,null,"n",{"$f":"'Variable 1'!G28","v":0}]
[]
[null,null,null,"Variable 1","Variable 2","Variable 3","Variable 4","Average"]
[]
[null,null,"CV",{"$f":"IF(ISERROR('Variable 1'!H28),\"\",'Variable 1'!H28)","v":""},{"$f":"IF(ISERROR('Variable 2'!H28),\"\",'Variable 2'!H28)","v":""},{"$f":"IF(ISERROR('Variable 3'!H28),\"\",'Variable 3'!H28)","v":""},{"$f":"IF(ISERROR('Variable 4'!H28),\"\",'Variable 4'!H28)","v":""}]
[]
[null,null,"n1",{"$f":"IF(ISERROR('Variable 1'!G29),\"\",'Variable 1'!G29)","v":""},{"$f":"IF(ISERROR('Variable 2'!G29),\"\",'Variable 2'!G29)","v":""},{"$f":"IF(ISERROR('Variable 3'!G29),\"\",'Variable 3'!G29)","v":""},{"$f":"IF(ISERROR('Variable 4'!G29),\"\",'Variable 4'!G29)","v":""},{"$f":"SUM(D29:G29)/(IF(AND(D29:G29)=\"\",\"\",COUNT(D29:G29)))","v":{"$error":"#VALUE!"}}]
[null,null,"n2",{"$f":"IF(ISERROR('Variable 1'!G30),\"\",'Variable 1'!G30)","v":""},{"$f":"IF(ISERROR('Variable 2'!G30),\"\",'Variable 2'!G30)","v":""},{"$f":"IF(ISERROR('Variable 3'!G30),\"\",'Variable 3'!G30)","v":""},{"$f":"IF(ISERROR('Variable 4'!G30),\"\",'Variable 4'!G30)","v":""},{"$error":"#VALUE!"}]
[null,null,"n3",{"$f":"IF(ISERROR('Variable 1'!G31),\"\",'Variable 1'!G31)","v":""},{"$f":"IF(ISERROR('Variable 2'!G31),\"\",'Variable 2'!G31)","v":""},{"$f":"IF(ISERROR('Variable 3'!G31),\"\",'Variable 3'!G31)","v":""},{"$f":"IF(ISERROR('Variable 4'!G31),\"\",'Variable 4'!G31)","v":""},{"$error":"#VALUE!"}]
[null,null,"n4",{"$f":"IF(ISERROR('Variable 1'!G32),\"\",'Variable 1'!G32)","v":""},{"$f":"IF(ISERROR('Variable 2'!G32),\"\",'Variable 2'!G32)","v":""},{"$f":"IF(ISERROR('Variable 3'!G32),\"\",'Variable 3'!G32)","v":""},{"$f":"IF(ISERROR('Variable 4'!G32),\"\",'Variable 4'!G32)","v":""},{"$error":"#VALUE!"}]
[null,null,"n5",{"$f":"IF(ISERROR('Variable 1'!G33),\"\",'Variable 1'!G33)","v":""},{"$f":"IF(ISERROR('Variable 2'!G33),\"\",'Variable 2'!G33)","v":""},{"$f":"IF(ISERROR('Variable 3'!G33),\"\",'Variable 3'!G33)","v":""},{"$f":"IF(ISERROR('Variable 4'!G33),\"\",'Variable 4'!G33)","v":""},{"$error":"#VALUE!"}]
[null,null,"n6",{"$f":"IF(ISERROR('Variable 1'!G34),\"\",'Variable 1'!G34)","v":""},{"$f":"IF(ISERROR('Variable 2'!G34),\"\",'Variable 2'!G34)","v":""},{"$f":"IF(ISERROR('Variable 3'!G34),\"\",'Variable 3'!G34)","v":""},{"$f":"IF(ISERROR('Variable 4'!G34),\"\",'Variable 4'!G34)","v":""},{"$error":"#VALUE!"}]
[null,null,"n7",{"$f":"IF(ISERROR('Variable 1'!G35),\"\",'Variable 1'!G35)","v":""},{"$f":"IF(ISERROR('Variable 2'!G35),\"\",'Variable 2'!G35)","v":""},{"$f":"IF(ISERROR('Variable 3'!G35),\"\",'Variable 3'!G35)","v":""},{"$f":"IF(ISERROR('Variable 4'!G35),\"\",'Variable 4'!G35)","v":""},{"$error":"#VALUE!"}]
[null,null,"n8",{"$f":"IF(ISERROR('Variable 1'!G36),\"\",'Variable 1'!G36)","v":""},{"$f":"IF(ISERROR('Variable 2'!G36),\"\",'Variable 2'!G36)","v":""},{"$f":"IF(ISERROR('Variable 3'!G36),\"\",'Variable 3'!G36)","v":""},{"$f":"IF(ISERROR('Variable 4'!G36),\"\",'Variable 4'!G36)","v":""},{"$error":"#VALUE!"}]
[null,null,"n9",{"$f":"IF(ISERROR('Variable 1'!G37),\"\",'Variable 1'!G37)","v":""},{"$f":"IF(ISERROR('Variable 2'!G37),\"\",'Variable 2'!G37)","v":""},{"$f":"IF(ISERROR('Variable 3'!G37),\"\",'Variable 3'!G37)","v":""},{"$f":"IF(ISERROR('Variable 4'!G37),\"\",'Variable 4'!G37)","v":""},{"$error":"#VALUE!"}]
[null,null,"n10",{"$f":"IF(ISERROR('Variable 1'!G38),\"\",'Variable 1'!G38)","v":""},{"$f":"IF(ISERROR('Variable 2'!G38),\"\",'Variable 2'!G38)","v":""},{"$f":"IF(ISERROR('Variable 3'!G38),\"\",'Variable 3'!G38)","v":""},{"$f":"IF(ISERROR('Variable 4'!G38),\"\",'Variable 4'!G38)","v":""},{"$error":"#VALUE!"}]