{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Density (birds)","Density (marine animals)","ERM","CRM","ETPM","Avoidance","Swim depths","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":5,"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":"Density (birds)","index":0,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Diving birds - density at risk depth",null,"from previous sheets","turbine data","animal data","intermediate results","results"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"other months","Jun/July"]
["Species name",null,null,null,null,null,"eider",null,"red-throated diver",null,"gannet",null,"cormorant",null,"black guillemot",null,"european shag","european shag"]
["Observed density (per m2)",null,"DS","birds m-2",null,null,3.075437608013289E-7,null,1.0800000000000001E-8,null,3.6669999999999997E-8,null,6.6224499999999999E-8,null,5.7100000000000002E-7]
["correct for proportion underwater?",null,null,null,null,null,"yes",null,"yes",null,"yes",null,"yes",null,"yes",null,"yes","yes"]
[]
["Proportion of diving birds visible at surface"]
["choose method for calculating overall dive frequency:",null,null,null,null,null,"method 1",null,"method 1",null,"method 2",null,"method 1",null,"method 1",null,"method 2","method 2"]
[]
["method 1","proportion of time foraging","P2",null,null,null,0.6,null,0.4,null,0.55800000000000005,null,1,null,0.37333,null,0.37333,0.37333]
[null,"dive frequency foraging","F2","dives s-1",null,null,1.9120000000000002E-2,null,3.09E-2,null,null,null,6.8519999999999996E-3,null,9.1999999999999998E-3,null,9.9500000000000005E-3,9.9500000000000005E-3]
[]
["method 2","foraging trips per day","G","trips/day",null,null,3,null,3,null,null,null,3,null,3,null,1,3]
[null,"dives per foraging trip","U","dives/trip",null,null,6,null,6,null,null,null,6,null,6,null,26.6,26.6]
[]
["overall dive frequency",null,"F","dives s-1",null,"P2F2 or GU/(24*3600)",{"$f":"IF(G$8=\"method 1\",G10*G11,IF(G$8=\"method 2\",G13*G14/(24*3600),0))","v":1.1472000000000001E-2},null,{"$f":"IF(I$8=\"method 1\",I10*I11,IF(I$8=\"method 2\",I13*I14/(24*3600),0))","v":1.2360000000000001E-2},null,3.7500000000000001E-4,null,{"$f":"IF(M$8=\"method 1\",M10*M11,IF(M$8=\"method 2\",M13*M14/(24*3600),0))","v":6.8519999999999996E-3},null,{"$f":"IF(O$8=\"method 1\",O10*O11,IF(O$8=\"method 2\",O13*O14/(24*3600),0))","v":3.434636E-3},null,{"$f":"IF(Q$8=\"method 1\",Q10*Q11,IF(Q$8=\"method 2\",Q13*Q14/(24*3600),0))","v":3.078703703703704E-4},{"$f":"IF(R$8=\"method 1\",R10*R11,IF(R$8=\"method 2\",R13*R14/(24*3600),0))","v":9.2361111111111127E-4}]
["mean underwater duration of dive",null,"tu","s",null,null,25.9,null,26.1,null,10.9,null,40,null,77.099999999999994,null,41.7,41.7]
["watch period",null,"tw","s",0,null,{"$f":"$E18","v":0},null,{"$f":"$E18","v":0},null,{"$f":"$E18","v":0},null,{"$f":"E18","v":0},null,{"$f":"$E18","v":0},null,{"$f":"$E18","v":0},{"$f":"$E18","v":0}]
["proportion visible at surface",null,null,null,null,"1-F*max(0,tu-tw)",{"$f":"IF(G5=\"yes\",1-G16*MAX(0,(G17-G18)),1)","v":0.70287520000000003},null,{"$f":"IF(I5=\"yes\",1-I16*MAX(0,(I17-I18)),1)","v":0.6774039999999999},null,{"$f":"IF(K5=\"yes\",1-K10,1)","v":0.44199999999999995},null,{"$f":"IF(M5=\"yes\",1-M16*MAX(0,(M17-M18)),1)","v":0.72592000000000001},null,{"$f":"IF(O5=\"yes\",1-O16*MAX(0,(O17-O18)),1)","v":0.73518956439999994},null,{"$f":"IF(Q5=\"yes\",1-Q16*MAX(0,(Q17-Q18)),1)","v":0.98716180555555555},{"$f":"IF(R5=\"yes\",1-R16*MAX(0,(R17-R18)),1)","v":0.96148541666666665}]
["adjusted at sea density",null,"DA","birds m-2",null,null,{"$f":"G4/G19","v":4.3755102015454364E-7},null,{"$f":"I4/I19","v":1.594321852247699E-8},null,{"$f":"K4/K19","v":8.2963800904977376E-8},null,{"$f":"M4/M19","v":9.1228372272426708E-8},null,{"$f":"O4/O19","v":7.7667043664582252E-7},null,{"$f":"Q4/Q19","v":0},{"$f":"R4/R19","v":0}]
[]
["Risk depth"]
["rotor diameter",null,"2R","m",20]
["rotor minimum depth",null,null,"m",2.5]
[]
["Proportion of diving birds at risk depth",null,null,null,null,null,{"$f":"G3","v":"eider"},null,{"$f":"I3","v":"red-throated diver"},null,{"$f":"K3","v":"gannet"},null,{"$f":"M3","v":"cormorant"},null,{"$f":"O3","v":"black guillemot"},null,{"$f":"Q3","v":"european shag"},{"$f":"R3","v":"european shag"}]
["vertical swim speed",null,"u","m s-1",null,null,1.65,null,1.65,null,1.2,null,1.65,null,1.48,null,1.65,1.65]
["plunge speed",null,"u'","m s-1",null,null,null,null,null,null,4.3]
["depth distribution type",null,null,null,null,"deep, shallow or plunge-diving","shallow-diving",null,"shallow-diving",null,"plunge-diving",null,"deep-diving",null,"deep-diving",null,"deep-diving","deep-diving"]
["time per dive at risk depth",null,"H","s",null,"depends on dive type",{"$f":"IF(G29=\"shallow-diving\",MAX(0,G17-2*$E24/G27),IF(G29=\"deep-diving\",2*$E23/G27,IF(G29=\"plunge-diving\",MAX(0,G17-$E24/G27-$E24/G28),error)))","v":22.869696969696967},null,{"$f":"IF(I29=\"shallow-diving\",MAX(0,I17-2*$E24/I27),IF(I29=\"deep-diving\",2*$E23/I27,IF(I29=\"plunge-diving\",MAX(0,I17-$E24/I27-$E24/I28),error)))","v":23.06969696969697},null,{"$f":"IF(K29=\"shallow-diving\",MAX(0,K17-2*$E24/K27),IF(K29=\"deep-diving\",2*$E23/K27,IF(K29=\"plunge-diving\",MAX(0,K17-$E24/K27-$E24/K28),error)))","v":8.2352713178294579},null,{"$f":"IF(M29=\"shallow-diving\",MAX(0,M17-2*$E24/M27),IF(M29=\"deep-diving\",2*$E23/M27,IF(M29=\"plunge-diving\",MAX(0,M17-$E24/M27-$E24/M28),error)))","v":24.242424242424242},null,{"$f":"IF(O29=\"shallow-diving\",MAX(0,O17-2*$E24/O27),IF(O29=\"deep-diving\",2*$E23/O27,IF(O29=\"plunge-diving\",MAX(0,O17-$E24/O27-$E24/O28),error)))","v":27.027027027027028},null,{"$f":"IF(Q29=\"shallow-diving\",MAX(0,Q17-2*$E24/Q27),IF(Q29=\"deep-diving\",2*$E23/Q27,IF(Q29=\"plunge-diving\",MAX(0,Q17-$E24/Q27-$E24/Q28),error)))","v":24.242424242424242},{"$f":"IF(R29=\"shallow-diving\",MAX(0,R17-2*$E24/R27),IF(R29=\"deep-diving\",2*$E23/R27,IF(R29=\"plunge-diving\",MAX(0,R17-$E24/R27-$E24/R28),error)))","v":24.242424242424242}]
["proportion at risk depth",null,"Q2R",null,null,"FH",{"$f":"G16*G30","v":0.26236116363636364},null,{"$f":"I16*I30","v":0.28514145454545459},null,{"$f":"K16*K30","v":3.0882267441860469E-3},null,{"$f":"M16*M30","v":0.1661090909090909},null,{"$f":"O16*O30","v":9.2828000000000008E-2},null,{"$f":"Q16*Q30","v":7.4635241301907974E-3},{"$f":"R16*R30","v":2.2390572390572395E-2}]
[]
["Density at risk depth",null,"D","birds m-3",null,"DA    Q2R /2R",{"$f":"G20*G31/$E23","v":5.7398197399012034E-9},null,{"$f":"I20*I31/$E23","v":2.2730362598175614E-10},null,{"$f":"K20*K31/$E23","v":1.2810551437703885E-11},null,{"$f":"M20*M31/$E23","v":7.5769309916444589E-10},null,{"$f":"O20*O31/$E23","v":3.6048381646479206E-9},null,{"$f":"Q20*Q31/$E23","v":0},{"$f":"R20*R31/$E23","v":0}]
[]
["available depth distribution types:"]
[null,"deep-diving"]
[null,"shallow-diving"]
[null,"plunge-diving"]

{"sheet":"Density (marine animals)","index":1,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Marine animals - density at risk depth",null,"from previous sheets","turbine data","animal data","intermediate results","results"]
[]
["Species name",null,null,null,null,null,"harbour porpoise",null,"harbour seal",null,"grey seal",null,"minke whale",null,"basking shark"]
["Observed density (per m2)",null,"DS","animals m-2",null,null,3.3988961726870623E-9,null,3.5717340855408007E-9,null,1.0558807491811731E-8,null,2.1582753101492642E-10,null,1.0828993298755966E-9]
["correct for proportion underwater?",null,null,null,null,null,"yes",null,"yes",null,"yes",null,"yes",null,"no"]
[]
["Proportion of animals visible at surface"]
["mean underwater duration of dive",null,"tu","s",null,null,26.2,null,180,null,297,null,87]
["mean surface time",null,"ts","s",null,null,3.9,null,39.512,null,165,null,3.5]
["overall dive frequency",null,"F","dives s-1",null,"1/(tu+ts)",{"$f":"IF(G5=\"yes\",1/(G8+G9),0)","v":3.3222591362126248E-2},null,{"$f":"IF(I5=\"yes\",1/(I8+I9),0)","v":4.5555596049418707E-3},null,{"$f":"IF(K5=\"yes\",1/(K8+K9),0)","v":2.1645021645021645E-3},null,{"$f":"IF(M5=\"yes\",1/(M8+M9),0)","v":1.1049723756906077E-2},null,{"$f":"IF(O5=\"yes\",1/(O8+O9),0)","v":0}]
["watch period",null,"tw","s",10,null,{"$f":"$E11","v":10},null,{"$f":"$E11","v":10},null,{"$f":"$E11","v":10},null,{"$f":"$E11","v":10},null,{"$f":"$E11","v":10}]
["proportion visible at surface",null,null,null,null,"1-F*max(0,tu-tw)",{"$f":"1-G10*MAX(0,(G8-G11))","v":0.46179401993355484},null,{"$f":"1-I10*MAX(0,(I8-I11))","v":0.22555486715988193},null,{"$f":"1-K10*MAX(0,(K8-K11))","v":0.37878787878787878},null,{"$f":"1-M10*MAX(0,(M8-M11))","v":0.14917127071823211},null,{"$f":"1-O10*MAX(0,(O8-O11))","v":1}]
["adjusted at sea density",null,"DA","animals m-2",null,null,{"$f":"G4/G12","v":7.3601996257468032E-9},null,{"$f":"I4/I12","v":1.5835322600283411E-8},null,{"$f":"K4/K12","v":2.7875251778382972E-8},null,{"$f":"M4/M12","v":1.4468438190259876E-9},null,{"$f":"O4/O12","v":1.0828993298755966E-9}]
[]
["Risk depth"]
["rotor diameter",null,"2R","m",25]
["rotor minimum depth",null,null,"m",2.5]
["channel depth",null,null,"m",30]
[]
["Proportion of animals at risk depth"]
["depth distribution type",null,null,null,null,null,"harbour porpoise",null,"harbour seal",null,"deep-diving",null,"uniform",null,"uniform",null,"atlantic salmon"]
["vertical swim speed",null,"u","m s-1",null,null,null,null,null,null,1.4]
["time per dive at risk depth",null,"H","s",null,null,{"$f":"IF(G21=\"shallow-diving\",MAX(0,G8-2*$E17/G22),IF(G21=\"deep-diving\",2*$E16/G22,\"\"))","v":""},null,{"$f":"IF(I21=\"shallow-diving\",MAX(0,I8-2*$E17/I22),IF(I21=\"deep-diving\",2*$E16/I22,\"\"))","v":""},null,{"$f":"IF(K21=\"shallow-diving\",MAX(0,K8-2*$E17/K22),IF(K21=\"deep-diving\",2*$E16/K22,\"\"))","v":35.714285714285715},null,{"$f":"IF(M21=\"shallow-diving\",MAX(0,M8-2*$E17/M22),IF(M21=\"deep-diving\",2*$E16/M22,\"\"))","v":""},null,{"$f":"IF(O21=\"shallow-diving\",MAX(0,O8-2*$E17/O22),IF(O21=\"deep-diving\",2*$E16/O22,\"\"))","v":""},null,{"$f":"IF(Q21=\"shallow-diving\",MAX(0,Q8-2*$E17/Q22),IF(Q21=\"deep-diving\",2*$E16/Q22,\"\"))","v":""}]
["proportion at risk depth",null,"Q2R",null,null,"FH",{"$f":"Q2R(G21,G22,G8,G10,$E17,$E16,$E18)","v":0.71699994802474976},null,{"$f":"Q2R(I21,I22,I8,I10,$E17,$E16,$E18)","v":0.52499997615814209},null,{"$f":"Q2R(K21,K22,K8,K10,$E17,$E16,$E18)","v":7.7303647994995117E-2},null,{"$f":"Q2R(M21,M22,M8,M10,$E17,$E16,$E18)","v":0.83333331346511841},null,{"$f":"Q2R(O21,O22,O8,O10,$E17,$E16,$E18)","v":0.83333331346511841},null,{"$f":"Q2R(Q21,Q22,Q8,Q10,$E17,$E16,$E18)","v":0.1607787013053894}]
["density at risk depth (per m3)",null,"D","animals m-3",null,"DA    Q2R /2R",{"$f":"G13*G24/$E16","v":2.1109050996448964E-10},null,{"$f":"I13*I24/$E16","v":3.3254175950421121E-10},null,{"$f":"K13*K24/$E16","v":8.6194346049919164E-11},null,{"$f":"M13*M24/$E16","v":4.8228126151018095E-11},null,{"$f":"O13*O24/$E16","v":3.6096643468575487E-11}]
[]
["available depth distribution types:"]
[null,"uniform"]
[null,"shallow-diving"]
[null,"deep-diving"]
[null,"harbour porpoise"]
[null,"harbour seal"]
[null,"grey seal"]
[null,"atlantic salmon"]

{"sheet":"ERM","index":2,"n_rows":35,"n_cols":28,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,6,0,7]]}
["ERM",null,"from previous sheets","turbine data","animal data","intermediate results","results"]
[]
[null,null,"symbol","units"]
["Period of assessment",null,null,"years",1]
["time in period (secs)",null,"t","s",{"$f":"IF(D4=\"years\",E4*365*24*3600,IF(D4=\"months\",E4*30.4*24*3600,IF(D4=\"weeks\",E4*7*24*3600)))","v":31536000}]
[]
["Rotor data"]
["number of rotors",null,"B","m",1]
["rotor diameter",null,"2R","m",25]
["rotor radius",null,"R","m",{"$f":"E9/2","v":12.5}]
["number of blades",null,"b",null,3]
["rotor blade width",null,"w","m",0.75]
["rotation speed",null,"Ω","rpm",6.95]
["mean tangential blade speed",null,"vr","m s-1",{"$f":"(1/2)*$E10*$E13*2*PI()/60","v":4.5487643630102212}]
["% time not operational",null,"nop",null,0.124]
["mean current speed (m s-1)",null,"vc","m s-1",1.82]
["mean blade speed relative to water",null,"v","m s-1",{"$f":"SQRT(E14*E14+E16*E16)","v":4.8993527358409077},"√ (vr2 + vc2)"]
[]
["Animal data"]
["species",null,null,null,null,null,null,"harbour porpoise",null,"harbour seal",null,"grey seal",null,"minke whale",null,"basking shark",null,null,null,"eider",null,"red-throated diver",null,"gannet",null,"cormorant",null,"black guillemot"]
["animal density at risk depth (c/f)",null,"D","m-3",null,null,null,{"$f":"'Density (marine animals)'!G25","v":2.1109050996448964E-10},null,{"$f":"'Density (marine animals)'!I25","v":3.3254175950421121E-10},null,{"$f":"'Density (marine animals)'!K25","v":8.6194346049919164E-11},null,{"$f":"'Density (marine animals)'!M25","v":4.8228126151018095E-11},null,{"$f":"'Density (marine animals)'!O25","v":3.6096643468575487E-11},null,null,null,{"$f":"'Density (birds)'!G33","v":5.7398197399012034E-9},null,{"$f":"'Density (birds)'!I33","v":2.2730362598175614E-10},null,{"$f":"'Density (birds)'!K33","v":1.2810551437703885E-11},null,{"$f":"'Density (birds)'!M33","v":7.5769309916444589E-10},null,{"$f":"'Density (birds)'!O33","v":3.6048381646479206E-9}]
["marine animal or diving bird?",null,null,null,null,null,null,"marine animal",null,"marine animal",null,"marine animal",null,"marine animal",null,"marine animal",null,null,null,"diving bird",null,"diving bird",null,"diving bird",null,"diving bird",null,"diving bird"]
["length",null,"L","m",null,null,null,1.48,null,1.41,null,1.86,null,8.8000000000000007,null,7,null,null,null,0.6,null,0.61,null,0.94,null,0.9,null,0.31]
["bodywidth/wingspan",null,"W","m",null,null,null,0.32,null,0.34,null,0.42,null,2.2000000000000002,null,1.75,null,null,null,0.94,null,1.1100000000000001,null,1.72,null,1.45,null,0.55000000000000004]
["swim speed (marine animals only)",null,"u0","m s-1",null,null,null,1.4,null,1.8,null,1.8,null,2.1,null,1]
["vertical swim speed",null,"u","m s-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.65,null,1.65,null,2.75,null,1.65,null,1.48]
["shape factor",null,"f",null,null,"0.5 or 0.8",null,0.5,null,0.5,null,0.5,null,0.5,null,0.5,null,null,null,0.5,null,0.5,null,0.8,null,0.5,null,0.8]
[]
["ERM ENCOUNTER RATE"]
["effective animal radius",null,"r","m",null,"W/f",null,{"$f":"MAX(H23,H24)*H27/2","v":0.37},null,{"$f":"MAX(J23,J24)*J27/2","v":0.35249999999999998},null,{"$f":"MAX(L23,L24)*L27/2","v":0.46500000000000002},null,{"$f":"MAX(N23,N24)*N27/2","v":2.2000000000000002},null,{"$f":"MAX(P23,P24)*P27/2","v":1.75},null,null,null,{"$f":"MAX(T23,T24)*T27/2","v":0.23499999999999999},null,{"$f":"MAX(V23,V24)*V27/2","v":0.27750000000000002},null,{"$f":"MAX(X23,X24)*X27/2","v":0.68800000000000006},null,{"$f":"MAX(Z23,Z24)*Z27/2","v":0.36249999999999999},null,{"$f":"MAX(AB23,AB24)*AB27/2","v":0.22000000000000003}]
["effective blade area",null,"A","m2",null,"(w+2r )(R+r) bB",null,{"$f":"$E8*$E11*($E12+2*H30)*($E10+H30)","v":57.528899999999993},null,{"$f":"$E8*$E11*($E12+2*J30)*($E10+J30)","v":56.101162500000001},null,{"$f":"$E8*$E11*($E12+2*L30)*($E10+L30)","v":65.343600000000009},null,{"$f":"$E8*$E11*($E12+2*N30)*($E10+N30)","v":227.11500000000001},null,{"$f":"$E8*$E11*($E12+2*P30)*($E10+P30)","v":181.6875},null,null,null,{"$f":"$E8*$E11*($E12+2*T30)*($E10+T30)","v":46.610100000000003},null,{"$f":"$E8*$E11*($E12+2*V30)*($E10+V30)","v":50.023912500000009},null,{"$f":"$E8*$E11*($E12+2*X30)*($E10+X30)","v":84.113064000000023},null,{"$f":"$E8*$E11*($E12+2*Z30)*($E10+Z30)","v":56.916562500000012},null,{"$f":"$E8*$E11*($E12+2*AB30)*($E10+AB30)","v":45.410400000000003}]
["swim speed used",null,"u or u0",null,null,"u for birds; otherwise u0",null,{"$f":"IF(H22=\"diving bird\",H26,H25)","v":1.4},null,{"$f":"IF(J22=\"diving bird\",J26,J25)","v":1.8},null,{"$f":"IF(L22=\"diving bird\",L26,L25)","v":1.8},null,{"$f":"IF(N22=\"diving bird\",N26,N25)","v":2.1},null,{"$f":"IF(P22=\"diving bird\",P26,P25)","v":1},null,null,null,{"$f":"IF(T22=\"diving bird\",T26,T25)","v":1.65},null,{"$f":"IF(V22=\"diving bird\",V26,V25)","v":1.65},null,{"$f":"IF(X22=\"diving bird\",X26,X25)","v":2.75},null,{"$f":"IF(Z22=\"diving bird\",Z26,Z25)","v":1.65},null,{"$f":"IF(AB22=\"diving bird\",AB26,AB25)","v":1.48}]
["encounter rate (unit density)",null,null,"animals s-1",null,"A (u2+3v2)/3v",null,{"$f":"H31*(H32*H32+3*$E14*$E14)/(3*$E14)","v":269.94821408101609},null,{"$f":"J31*(J32*J32+3*$E14*$E14)/(3*$E14)","v":268.51090586983315},null,{"$f":"L31*(L32*L32+3*$E14*$E14)/(3*$E14)","v":312.74698146934179},null,{"$f":"N31*(N32*N32+3*$E14*$E14)/(3*$E14)","v":1106.4881656134487},null,{"$f":"P31*(P32*P32+3*$E14*$E14)/(3*$E14)","v":839.76768044379048},null,null,null,{"$f":"T31*(T32*T32+3*$E17*$E17)/(3*$E17)","v":236.99284216074577},null,{"$f":"V31*(V32*V32+3*$E17*$E17)/(3*$E17)","v":254.35064930938697},null,{"$f":"X31*(X32*X32+3*$E17*$E17)/(3*$E17)","v":455.3777391891042},null,{"$f":"Z31*(Z32*Z32+3*$E17*$E17)/(3*$E17)","v":289.39688850473874},null,{"$f":"AB31*(AB32*AB32+3*$E17*$E17)/(3*$E17)","v":229.24891992148508}]
["encounter rate (per sec)",null,"CERM","animals s-1",null,"A D (u2+3v2)/3v",null,{"$f":"H33*H21","v":5.6983506174364912E-8},null,{"$f":"J33*J21","v":8.9291089084023955E-8},null,{"$f":"L33*L21","v":2.6957021546836104E-8},null,{"$f":"N33*N21","v":5.3363850835814008E-8},null,{"$f":"P33*P21","v":3.0312794557412135E-8},null,null,null,{"$f":"T33*T21","v":1.3602961936495387E-6},null,{"$f":"V33*V21","v":5.7814824858837717E-8},null,{"$f":"X33*X21","v":5.8336399514673238E-9},null,{"$f":"Z33*Z21","v":2.1927402533970311E-7},null,{"$f":"AB33*AB21","v":8.2640525573728442E-7}]
["encounter rate (per period)",null,null,"animals",null,"CERM t (1-nop)",null,{"$f":"H34*$E5*(1-$E15)","v":1.5741999012261401},null,{"$f":"J34*$E5*(1-$E15)","v":2.4667141959699106},null,{"$f":"L34*$E5*(1-$E15)","v":0.7447021691948964},null,{"$f":"N34*$E5*(1-$E15)","v":1.47420498236341},null,{"$f":"P34*$E5*(1-$E15)","v":0.83740719730639301},null,null,null,{"$f":"T34*$E5*(1-$E15)","v":37.5789114683283},null,{"$f":"V34*$E5*(1-$E15)","v":1.5971655254715162},null,{"$f":"X34*$E5*(1-$E15)","v":0.16115743049029879},null,{"$f":"Z34*$E5*(1-$E15)","v":6.0575624808868804},null,{"$f":"AB34*$E5*(1-$E15)","v":22.829888142959557}]

{"sheet":"CRM","index":3,"n_rows":47,"n_cols":33,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,18,0,19]]}
["CRM",null,null,null,null,"blade profile:","r/R","c/C",null,null,"from previous sheets",null,"turbine data",null,"animal data",null,"intermediate results",null,"results"]
[null,null,null,null,null,null,0,0.69]
[null,null,"symbol","units",null,null,0.05,0.73]
["Period of assessment",null,null,"years",1,null,{"$f":"G3+0.05","v":0.1},0.79]
["time in period (secs)",null,"t","s",{"$f":"IF(D4=\"years\",E4*365*24*3600,IF(D4=\"months\",E4*30.4*24*3600,IF(D4=\"weeks\",E4*7*24*3600)))","v":31536000},null,{"$f":"G4+0.05","v":0.15000000000000002},0.88]
[null,null,null,null,null,null,{"$f":"G5+0.05","v":0.2},0.96]
["Rotor data",null,null,null,null,null,0.25,1]
["number of rotors",null,"B","m",1,null,0.3,0.98]
["rotor diameter (c/f)",null,"2R","m",25,null,0.35,0.92]
["rotor radius",null,"R","m",{"$f":"E9/2","v":12.5},null,0.39999999999999997,0.85]
["number of blades",null,"b",null,3,null,0.44999999999999996,0.8]
["maximum blade width",null,"C","m",1.5,null,0.49999999999999994,0.75]
["blade pitch at blade tip",null,"γ","degrees",5,null,0.54999999999999993,0.7]
["blade profile",null,"c/C",null,null,"<--",0.6,0.64]
["rotation speed",null,"Ω","rpm",6.95,null,0.65,0.57999999999999996]
["% time not operational",null,"nop",null,0.124,null,0.70000000000000007,0.52]
[null,null,null,null,null,null,0.75000000000000011,0.47]
[null,null,null,null,null,null,0.80000000000000016,0.41]
["Current data",null,null,null,null,null,0.8500000000000002,0.37]
["mean current speed (m s-1)",null,"vc","m s-1",1.82,null,0.90000000000000024,0.3]
[null,null,null,null,null,null,0.95000000000000029,0.24]
[null,null,null,null,null,null,1.0000000000000002,0]
["Animal data"]
["Species (c/f)",null,null,null,null,null,null,null,"harbour porpoise",null,"U-dives harbour seal",null,"grey seal",null,"minke whale",null,"basking shark",null,"eider",null,"red-throated diver",null,"gannet",null,"cormorant",null,"black guillemot",null,"salmon smolt",null,"salmon 1SW",null,"salmon MSW"]
["animal density ar risk depth (c/f)",null,"D","animals m-3",null,null,null,null,{"$f":"'Density (marine animals)'!G25","v":2.1109050996448964E-10},null,{"$f":"'Density (marine animals)'!I25","v":3.3254175950421121E-10},null,{"$f":"'Density (marine animals)'!K25","v":8.6194346049919164E-11},null,{"$f":"'Density (marine animals)'!M25","v":4.8228126151018095E-11},null,{"$f":"'Density (marine animals)'!O25","v":3.6096643468575487E-11},null,{"$f":"'Density (birds)'!G33","v":5.7398197399012034E-9},null,{"$f":"'Density (birds)'!I33","v":2.2730362598175614E-10},null,{"$f":"'Density (birds)'!K33","v":1.2810551437703885E-11},null,{"$f":"'Density (birds)'!M33","v":7.5769309916444589E-10},null,{"$f":"'Density (birds)'!O33","v":3.6048381646479206E-9},null,{"$f":"'Density (birds)'!Q33","v":0},null,{"$f":"'Density (birds)'!S33","v":0},null,{"$f":"'Density (birds)'!U33","v":0}]
["marine animal or diving bird?",null,null,null,null,null,null,null,"marine animal",null,"marine animal",null,"marine animal",null,"marine animal",null,"marine animal",null,"diving bird",null,"diving bird",null,"diving bird",null,"diving bird",null,"diving bird",null,"marine animal",null,"marine animal",null,"marine animal"]
["length",null,"L","m",null,null,null,null,1.48,null,1.41,null,1.86,null,8.8000000000000007,null,7,null,0.6,null,0.61,null,0.94,null,0.9,null,0.31,null,0.15,null,0.67,null,0.79]
["wingspan / bodywidth",null,"W","m",null,null,null,null,0.32,null,0.34,null,0.42,null,{"$f":"O27/4","v":2.2000000000000002},null,{"$f":"Q27/4","v":1.75},null,0.94,null,1.1100000000000001,null,1.72,null,1.45,null,0.55000000000000004,null,0.02,null,0.12,null,0.14000000000000001]
[]
["CRM ENCOUNTER RATE"]
["body length used perp to rotor",null,"L'",null,null,"swap length & width for diving birds",null,null,{"$f":"IF(I26=\"diving bird\",I28,I27)","v":1.48},null,{"$f":"IF(K26=\"diving bird\",K28,K27)","v":1.41},null,{"$f":"IF(M26=\"diving bird\",M28,M27)","v":1.86},null,{"$f":"IF(O26=\"diving bird\",O28,O27)","v":8.8000000000000007},null,{"$f":"IF(Q26=\"diving bird\",Q28,Q27)","v":7},null,{"$f":"IF(S26=\"diving bird\",S28,S27)","v":0.94},null,{"$f":"IF(U26=\"diving bird\",U28,U27)","v":1.1100000000000001},null,{"$f":"IF(W26=\"diving bird\",W28,W27)","v":1.72},null,{"$f":"IF(Y26=\"diving bird\",Y28,Y27)","v":1.45},null,{"$f":"IF(AA26=\"diving bird\",AA28,AA27)","v":0.55000000000000004},null,{"$f":"IF(AC26=\"diving bird\",AC28,AC27)","v":0.15},null,{"$f":"IF(AE26=\"diving bird\",AE28,AE27)","v":0.67},null,{"$f":"IF(AG26=\"diving bird\",AG28,AG27)","v":0.79}]
["body width used in rotor plane",null,"W'",null,null,"swap length & width for diving birds",null,null,{"$f":"IF(I26=\"diving bird\",I27,I28)","v":0.32},null,{"$f":"IF(K26=\"diving bird\",K27,K28)","v":0.34},null,{"$f":"IF(M26=\"diving bird\",M27,M28)","v":0.42},null,{"$f":"IF(O26=\"diving bird\",O27,O28)","v":2.2000000000000002},null,{"$f":"IF(Q26=\"diving bird\",Q27,Q28)","v":1.75},null,{"$f":"IF(S26=\"diving bird\",S27,S28)","v":0.6},null,{"$f":"IF(U26=\"diving bird\",U27,U28)","v":0.61},null,{"$f":"IF(W26=\"diving bird\",W27,W28)","v":0.94},null,{"$f":"IF(Y26=\"diving bird\",Y27,Y28)","v":0.9},null,{"$f":"IF(AA26=\"diving bird\",AA27,AA28)","v":0.31},null,{"$f":"IF(AC26=\"diving bird\",AC27,AC28)","v":0.02},null,{"$f":"IF(AE26=\"diving bird\",AE27,AE28)","v":0.12},null,{"$f":"IF(AG26=\"diving bird\",AG27,AG28)","v":0.14000000000000001}]
["speed of approach used",null,"vc","m s-1",null,"vc",null,null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82},null,{"$f":"$E20","v":1.82}]
["total frontal area",null,null,"m2",null,"Bπ(R+0.5W')2",null,null,{"$f":"$E8*PI()*($E10+0.5*I32)*($E10+0.5*I32)","v":503.52064750969623},null,{"$f":"$E8*PI()*($E10+0.5*K32)*($E10+0.5*K32)","v":504.31641292885053},null,{"$f":"$E8*PI()*($E10+0.5*M32)*($E10+0.5*M32)","v":507.50575779077491},null,{"$f":"$E8*PI()*($E10+0.5*O32)*($E10+0.5*O32)","v":581.06897720796815},null,{"$f":"$E8*PI()*($E10+0.5*Q32)*($E10+0.5*Q32)","v":562.0014732960866},null,{"$f":"$E8*PI()*($E10+0.5*S32)*($E10+0.5*S32)","v":514.71854036415175},null,{"$f":"$E8*PI()*($E10+0.5*U32)*($E10+0.5*U32)","v":515.1207427636275},null,{"$f":"$E8*PI()*($E10+0.5*W32)*($E10+0.5*W32)","v":528.48154362026321},null,{"$f":"$E8*PI()*($E10+0.5*Y32)*($E10+0.5*Y32)","v":526.85294198864221},null,{"$f":"$E8*PI()*($E10+0.5*AA32)*($E10+0.5*AA32)","v":503.12300041956809},null,{"$f":"$E8*PI()*($E10+0.5*AC32)*($E10+0.5*AC32)","v":491.65956444606792},null,{"$f":"$E8*PI()*($E10+0.5*AE32)*($E10+0.5*AE32)","v":495.59755083734285},null,{"$f":"$E8*PI()*($E10+0.5*AG32)*($E10+0.5*AG32)","v":496.38703307118988}]
["encounter probability for single transit",null,"pcoll",null,null,"pcoll",null,null,{"$f":"pcoll_diskav(\"down\",I31,I32,I33)","v":0.32102277874946594},null,{"$f":"pcoll_diskav(\"down\",K31,K32,K33)","v":0.307657390832901},null,{"$f":"pcoll_diskav(\"down\",M31,M32,M33)","v":0.3935776948928833},null,{"$f":"pcoll_diskav(\"down\",O31,O32,O33)","v":1},null,{"$f":"pcoll_diskav(\"down\",Q31,Q32,Q33)","v":1},null,{"$f":"pcoll_diskav(\"down\",S31,S32,S33)","v":0.21980985999107361},null,{"$f":"pcoll_diskav(\"down\",U31,U32,U33)","v":0.2518581748008728},null,{"$f":"pcoll_diskav(\"down\",W31,W32,W33)","v":0.36910191178321838},null,{"$f":"pcoll_diskav(\"down\",Y31,Y32,Y33)","v":0.31801745295524597},null,{"$f":"pcoll_diskav(\"down\",AA31,AA32,AA33)","v":0.14424709975719452},null,{"$f":"pcoll_diskav(\"down\",AC31,AC32,AC33)","v":6.7080460488796234E-2},null,{"$f":"pcoll_diskav(\"down\",AE31,AE32,AE33)","v":0.16636617481708527},null,{"$f":"pcoll_diskav(\"down\",AG31,AG32,AG33)","v":0.1892782598733902}]
["no of rotor transits per second",null,null,"s-1",null,"D Bπ(R+0.5W')2 vc",null,null,{"$f":"I25*I34*I33","v":1.9344494307405869E-7},null,{"$f":"K25*K34*K33","v":3.0522540649002635E-7},null,{"$f":"M25*M34*M33","v":7.9614310975007013E-8},null,{"$f":"O25*O34*O33","v":5.1003439642116686E-8},null,{"$f":"Q25*Q34*Q33","v":3.6921187594897034E-8},null,{"$f":"S25*S34*S33","v":5.376992782025033E-6},null,{"$f":"U25*U34*U33","v":2.1310163902043016E-7},null,{"$f":"W25*W34*W33","v":1.2321654797132648E-8},null,{"$f":"Y25*Y34*Y33","v":7.265309659230903E-7},null,{"$f":"AA25*AA34*AA33","v":3.3008921280328279E-6}]
["encounter rate (per sec) before avoidance",null,"CCRM",null,null,"D(Bπ(R+0.5W')2 vc pcoll",null,null,{"$f":"I36*I35","v":6.2100233160666578E-8},null,{"$f":"K36*K35","v":9.3904852176633116E-8},null,{"$f":"M36*M35","v":3.1334416994028443E-8},null,{"$f":"O36*O35","v":5.1003439642116686E-8},null,{"$f":"Q36*Q35","v":3.6921187594897034E-8},null,{"$f":"S36*S35","v":1.1819160305899358E-6},null,{"$f":"U36*U35","v":5.3671389850759998E-8},null,{"$f":"W36*W35","v":4.5479463419545244E-9},null,{"$f":"Y36*Y35","v":2.3104952727597577E-7},null,{"$f":"AA36*AA35","v":4.7614411608008943E-7}]
["no of rotor transits in period",null,null,null,null,"D Bπ(R+0.5W')2 vc(1-nop)t",null,null,{"$f":"I36*(1-$E16)*$E5","v":5.3440202389103586},null,{"$f":"K36*(1-$E16)*$E5","v":8.4320154551048567},null,{"$f":"M36*(1-$E16)*$E5","v":2.1993880139552515},null,{"$f":"O36*(1-$E16)*$E5","v":1.4089973579571218},null,{"$f":"Q36*(1-$E16)*$E5","v":1.0199675970655815},null,{"$f":"S36*(1-$E16)*$E5","v":148.5423076715727},null,{"$f":"U36*(1-$E16)*$E5","v":5.8870470004178985},null,{"$f":"W36*(1-$E16)*$E5","v":0.34039231817776067},null,{"$f":"Y36*(1-$E16)*$E5","v":20.070807354223106},null,{"$f":"AA36*(1-$E16)*$E5","v":91.188914315087501}]
["collisions in period before avoidance",null,null,"animals",null,"CCRM (1-nop) t",null,null,{"$f":"I37*$E5*(1-$E16)","v":1.7155522267883883},null,{"$f":"K37*$E5*(1-$E16)","v":2.5941718743802564},null,{"$f":"M37*$E5*(1-$E16)","v":0.86563006470754444},null,{"$f":"O37*$E5*(1-$E16)","v":1.4089973579571218},null,{"$f":"Q37*$E5*(1-$E16)","v":1.0199675970655815},null,{"$f":"S37*$E5*(1-$E16)","v":32.651063852039371},null,{"$f":"U37*$E5*(1-$E16)","v":1.482700912492205},null,{"$f":"W37*$E5*(1-$E16)","v":0.12563945539573304},null,{"$f":"Y37*$E5*(1-$E16)","v":6.3828670335454509},null,{"$f":"AA37*$E5*(1-$E16)","v":13.153736419958689}]
["ratio CRM/ERM",null,null,null,null,null,null,null,{"$f":"I39/ERM!H35","v":1.089793123130137},null,{"$f":"K39/ERM!J35","v":1.0516710361575674},null,{"$f":"M39/ERM!L35","v":1.1623842396529933},null,{"$f":"O39/ERM!N35","v":0.95576760003771732},null,{"$f":"Q39/ERM!P35","v":1.2180067240243611},null,{"$f":"S39/ERM!T35","v":0.86886667485187419},null,{"$f":"U39/ERM!V35","v":0.92833265484770655},null,{"$f":"W39/ERM!X35","v":0.77960696576938893},null,{"$f":"Y39/ERM!Z35","v":1.0537022199416},null,{"$f":"AA39/ERM!AB35","v":0.57616298150874345}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no of salmon through channel",6607314,null,244969,null,182672]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"proportion at risk depth",{"$f":"'Density (marine animals)'!Q24","v":0.1607787013053894},null,{"$f":"'Density (marine animals)'!Q24","v":0.1607787013053894},null,{"$f":"'Density (marine animals)'!Q24","v":0.1607787013053894}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no of salmon at risk depth",{"$f":"AC42*AC41","v":1062315.3640369177},null,{"$f":"AE42*AE41","v":39385.797680079937},null,{"$f":"AG42*AG41","v":29369.766924858093}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"channel width",7000,null,7000,null,7000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rotor transits in year",{"$f":"AC43*AC34/($E9*AC44)","v":2984.5571953528975},null,{"$f":"AE43*AE34/($E9*AE44)","v":111.54002781727267},null,{"$f":"AG43*AG34/($E9*AG44)","v":83.307265518986696}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rotor transits while operational",{"$f":"AC45*(1-$E16)","v":2614.4721031291383},null,{"$f":"AE45*(1-$E16)","v":97.709064367930864},null,{"$f":"AG45*(1-$E16)","v":72.977164594632342}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"collisions before avoidance",{"$f":"AC46*AC35","v":175.37999261301417},null,{"$f":"AE46*AE35","v":16.255483283849024},null,{"$f":"AG46*AG35","v":13.81299072496599}]

{"sheet":"ETPM","index":4,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,6,0,7]]}
["ETPM",null,"from previous sheets","turbine data","animal data","intermediate results","results"]
[]
["Period data",null,null,null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"all year"]
["Period (days)",null,null,"days",null,null,31,28,31,30,31,30,31,31,30,31,30,31,null,{"$f":"SUM(G4:R4)","v":365}]
["Period (seconds)",null,"t","s",null,"days * 24*3600",{"$f":"G4*24*3600","v":2678400},2419200,2678400,2592000,2678400,2592000,2678400,2678400,2592000,2678400,2592000,2678400,null,31536000]
[]
["Rotor data"]
["area of site",null,"Asite","m2",1000000]
["number of rotors",null,"B","m",100]
["rotor diameter",null,"2R","m",20,"(c/f)"]
["rotor radius",null,"R","m",{"$f":"E10/2","v":10}]
["number of blades",null,"b",null,3]
["rotor width from front to back",null,"w","m",0.5]
["% time not operational",null,"nop",null,0]
[]
["Animal data"]
["species name",null,null,null,null,null,"European shag"]
["target population",null,"N",null,1181,null,1181,1181,1181,1181,775,775,775,1181,1181,1181,1181,1181]
["number on site",null,null,null,null,null,14,9.9,18,7.5,10,6.4,14.1,12.3,13.9,3.6,12.4,2.2000000000000002]
["proportion foraging on site",null,"P",null,null,"number on site/N",{"$f":"G19/G18","v":1.1854360711261643E-2},{"$f":"H19/H18","v":8.382726502963591E-3},1.5241320914479255E-2,6.3505503810330228E-3,1.2903225806451613E-2,8.2580645161290326E-3,1.8193548387096775E-2,1.0414902624894157E-2,1.1769686706181203E-2,3.048264182895851E-3,1.0499576629974599E-2,1.8628281117696868E-3]
["critical added mortality",null,"n",null,60]
["length",null,"L","m",0.72]
[]
[]
["EXPOSURE TIME"]
[]
["prop of time at risk depth per bird on site",null,"Q2R",null,null,"FH",{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3},{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3},{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3},{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3},{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3},{"$f":"'Density (birds)'!$R31","v":2.2390572390572395E-2},{"$f":"'Density (birds)'!$R31","v":2.2390572390572395E-2},{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3},{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3},{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3},{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3},{"$f":"'Density (birds)'!$Q31","v":7.4635241301907974E-3}]
["volume of sea at risk depth",null,null,"m3",{"$f":"($E$10+$E$22)*$E$8","v":20720000},"(2R+L)*Asite"]
["rotor swept volume",null,"Vrotor","m3",{"$f":"$E$9*PI()*($E$11+0.5*$E$22)*($E$11+0.5*$E$22)*($E$13+$E$22)","v":41136.677710473181},"B π(R+0.5L)2 (w+L)"]
["Vrotor as prop of volume at risk depth",null,"S",null,{"$f":"E29/E28","v":1.9853608933626051E-3},"B π(R+0.5L) (w+L)/(2*Asite)"]
["individual bird exposure time in Vrotor",null,"T","s",null,"Q2R P S t (1-nop)",{"$f":"G27*G20*$E$30*G5*(1-$E$14)","v":0.47047546347133168},0.30049723150749569,0.60489702446314075,0.24391009050933091,0.51210278558492417,0.95152001450618173,2.1661947830242294,0.41334630004981282,0.45204670107729333,0.12097940489262814,0.40326468297542711,7.3931858545494972E-2,null,{"$f":"SUM(G31:R31)","v":6.713166340607291}]
[]
["Collision rate"]
["annual exposure time per bird",null,"T","seconds",{"$f":"T31","v":6.713166340607291}]
["critical collision rate per bird exposed",null,"αmax","s-1",{"$f":"$E$21/($E$18*T31)","v":7.5678748999489674E-3},"n/NT"]
["needs one collision every",null,"1/αmax","seconds",{"$f":"1/E35","v":132.13749080428687}]

{"sheet":"Avoidance","index":5,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["ERM encounter rates allowing for avoidance"]
["Avoidance rates",{"$f":"ERM!H20","v":"harbour porpoise"},{"$f":"ERM!J20","v":"harbour seal"},{"$f":"ERM!L20","v":"grey seal"},{"$f":"ERM!N20","v":"minke whale"},{"$f":"ERM!P20","v":"basking shark"},null,{"$f":"ERM!T20","v":"eider"},{"$f":"ERM!V20","v":"red-throated diver"},{"$f":"ERM!X20","v":"gannet"},{"$f":"ERM!Z20","v":"cormorant"},{"$f":"ERM!AB20","v":"black guillemot"}]
[0,{"$f":"ERM!H35","v":1.5741999012261401},{"$f":"ERM!J35","v":2.4667141959699106},{"$f":"ERM!L35","v":0.7447021691948964},{"$f":"ERM!N35","v":1.47420498236341},{"$f":"ERM!P35","v":0.83740719730639301},null,{"$f":"ERM!T35","v":37.5789114683283},{"$f":"ERM!V35","v":1.5971655254715162},{"$f":"ERM!X35","v":0.16115743049029879},{"$f":"ERM!Z35","v":6.0575624808868804},{"$f":"ERM!AB35","v":22.829888142959557},null,"from ERM worksheet"]
[0.5,{"$f":"B$6*(1-$A7)","v":0.78709995061307003},{"$f":"C$6*(1-$A7)","v":1.2333570979849553},0.3723510845974482,0.73710249118170501,0.41870359865319651,null,{"$f":"H$6*(1-$A7)","v":18.78945573416415},0.79858276273575812,8.0578715245149396E-2,3.0287812404434402,11.414944071479779]
[0.9,{"$f":"B$6*(1-$A8)","v":0.15741999012261398},0.24667141959699102,7.4470216919489629E-2,0.14742049823634096,8.3740719730639276E-2,null,3.7578911468328293,0.15971655254715159,1.6115743049029876E-2,0.60575624808868789,2.2829888142959551]
[0.95,{"$f":"B$6*(1-$A9)","v":7.8709995061307075E-2},0.12333570979849563,3.7235108459744856E-2,7.3710249118170562E-2,4.1870359865319687E-2,null,1.8789455734164167,7.985827627357589E-2,8.0578715245149465E-3,0.30287812404434428,1.1414944071479789]
[0.98,{"$f":"B$6*(1-$A10)","v":3.1483998024522827E-2},4.9334283919398259E-2,1.4894043383897942E-2,2.9484099647268228E-2,1.6748143946127874E-2,null,0.75157822936656671,3.1943310509430355E-2,3.2231486098059786E-3,0.12115124961773771,0.45659776285919157]
[0.99,{"$f":"B$6*(1-$A11)","v":1.5741999012261414E-2},2.4667141959699129E-2,7.4470216919489711E-3,1.4742049823634114E-2,8.374071973063937E-3,null,0.37578911468328335,1.5971655254715177E-2,1.6115743049029893E-3,6.0575624808868855E-2,0.22829888142959578]
[]
[]
["CRM collision rates allowing for avoidance"]
["Avoidance rates",{"$f":"CRM!I24","v":"harbour porpoise"},{"$f":"CRM!K24","v":"U-dives harbour seal"},{"$f":"CRM!M24","v":"grey seal"},{"$f":"CRM!O24","v":"minke whale"},{"$f":"CRM!Q24","v":"basking shark"},null,{"$f":"CRM!S24","v":"eider"},{"$f":"CRM!U24","v":"red-throated diver"},{"$f":"CRM!W24","v":"gannet"},{"$f":"CRM!Y24","v":"cormorant"},{"$f":"CRM!AA24","v":"black guillemot"}]
[0,{"$f":"CRM!I39","v":1.7155522267883883},{"$f":"CRM!K39","v":2.5941718743802564},{"$f":"CRM!M39","v":0.86563006470754444},{"$f":"CRM!O39","v":1.4089973579571218},{"$f":"CRM!Q39","v":1.0199675970655815},null,{"$f":"CRM!S39","v":32.651063852039371},{"$f":"CRM!U39","v":1.482700912492205},{"$f":"CRM!W39","v":0.12563945539573304},{"$f":"CRM!Y39","v":6.3828670335454509},{"$f":"CRM!AA39","v":13.153736419958689},null,"from CRM worksheet"]
[0.5,{"$f":"B$16*(1-$A17)","v":0.85777611339419413},{"$f":"C$16*(1-$A17)","v":1.2970859371901282},0.43281503235377222,0.70449867897856089,0.50998379853279074,null,16.325531926019686,0.74135045624610252,6.281972769786652E-2,3.1914335167727255,6.5768682099793443]
[0.9,{"$f":"B$16*(1-$A18)","v":0.1715552226788388},0.25941718743802561,8.6563006470754419E-2,0.14089973579571213,0.10199675970655812,null,3.2651063852039366,0.14827009124922047,1.2563945539573301E-2,0.63828670335454496,1.3153736419958686]
[0.95,{"$f":"B$16*(1-$A19)","v":8.5777611339419482E-2},0.12970859371901294,4.3281503235377258E-2,7.044986789785615E-2,5.0998379853279117E-2,null,1.6325531926019701,7.4135045624610318E-2,6.2819727697866574E-3,0.31914335167727281,0.65768682099793496]
[0.98,{"$f":"B$16*(1-$A20)","v":3.4311044535767797E-2},5.1883437487605176E-2,1.7312601294150905E-2,2.817994715914246E-2,2.0399351941311646E-2,null,0.65302127704078805,2.9654018249844129E-2,2.512789107914663E-3,0.12765734067090914,0.26307472839917401]
[0.99,{"$f":"B$16*(1-$A21)","v":1.7155522267883899E-2},2.5941718743802588E-2,8.6563006470754527E-3,1.408997357957123E-2,1.0199675970655823E-2,null,0.32651063852039403,1.4827009124922064E-2,1.2563945539573315E-3,6.3828670335454571E-2,0.131537364199587]

{"sheet":"Swim depths","index":6,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"Data drawn from Thompson (2015)"]
[null,"harbour porpoise depths are as a proportion of max dive depth",null,null,null,null,null,null,null,null,"harbour and grey seal depths are in metres"]
[null,"harbour porpoise",null,"20-40m","40-60m","60-80m","80-100m",">100m",null,null,"harbour seal",null,"<20m","20-30m","30-40m",null,"grey seal",null,null,"<20m","20-30m","30-40m","40-50-m","50-60m",">60m"]
[null,null,"wbin",40,60,80,100,150,null,null,null,"wbin",20,30,40,null,null,null,"wbin",20,30,40,50,60,100]
["dbin","surface",0,0.14699999999999999,0.11600000000000001,0.115,0.127,0.126,null,"dbin","surface",0,0.18,0.2,0.22,null,"dbin","surface",0]
[1,"0-0.05",0.05,5.2999999999999999E-2,8.6999999999999994E-2,0.153,0.14899999999999999,0.253,null,1,"0-5",5,0.08,0.06,0.04,null,1,"0-5",5,0.2,0.2,0.2,0.2,0.2,0.2]
[{"$f":"A6+1","v":2},"0.05-0.10",0.1,3.3000000000000002E-2,0.16200000000000001,0.16700000000000001,0.14299999999999999,0.17599999999999999,null,2,"5-10",10,0.16,0.13,0.11,null,2,"5-10",10,0.12,0.05,0.04,0.1,0.09,0.09]
[{"$f":"A7+1","v":3},"0.10-0.15",0.15,3.3000000000000002E-2,0.13600000000000001,0.104,0.1,0.109,null,3,"10-15",15,0.26,0.14000000000000001,0.14000000000000001,null,3,"10-15",15,0.14000000000000001,0.01,0.05,0.1,0.16,0.11]
[4,"0.15-0.20",0.2,4.2000000000000003E-2,6.6000000000000003E-2,5.1999999999999998E-2,9.6000000000000002E-2,7.0999999999999994E-2,null,4,"15-20",20,0.32,0.11,0.09,null,4,"15-20",20,0.19,0.12,0.08,0.1,0.12,0.1]
[5,"0.20-0.25",0.25,4.3999999999999997E-2,4.4999999999999998E-2,5.0999999999999997E-2,8.2000000000000003E-2,6.4000000000000001E-2,null,5,"20-25",25,null,0.24,7.0000000000000007E-2,null,5,"20-25",25,0.34,0.27,0.09,7.0000000000000007E-2,0.11,0.11]
[6,"0.25-30",0.3,3.9E-2,5.0999999999999997E-2,5.1999999999999998E-2,8.7999999999999995E-2,4.9000000000000002E-2,null,6,"25-30",30,null,0.12,0.19,null,6,"25-30",30,null,0.22,0.1,7.0000000000000007E-2,0.05,0.08]
[7,"0.30-0.35",0.35,6.6000000000000003E-2,4.2000000000000003E-2,4.2000000000000003E-2,6.6000000000000003E-2,3.5000000000000003E-2,null,7,"30-35",35,null,null,0.12,null,7,"30-35",35,null,0.05,0.19,7.0000000000000007E-2,0.05,0.06]
[8,"0.35-0.40",0.4,6.6000000000000003E-2,4.3999999999999997E-2,3.9E-2,4.2999999999999997E-2,2.4E-2,null,8,"35-40",40,null,null,0.02,null,8,"35-40",40,null,null,0.19,7.0000000000000007E-2,0.03,0.04]
[9,"0.40-0.45",0.45,7.6999999999999999E-2,5.6000000000000001E-2,3.3000000000000002E-2,2.9000000000000001E-2,2.1000000000000001E-2,null,9,">40",100,null,null,null,null,9,"40-45",45,null,null,0.06,7.0000000000000007E-2,0.03,0.04]
[10,"0.45-0.50",0.5,7.6999999999999999E-2,0.05,2.8000000000000001E-2,1.7000000000000001E-2,0.02,null,null,"metres","totals:",1,{"$f":"SUM(N5:N12)","v":1},{"$f":"SUM(O5:O13)","v":0.99999999999999989},null,10,"45-50",50,null,null,null,7.0000000000000007E-2,0.03,0.02]
[11,"0.50-0.55",0.55000000000000004,5.5E-2,3.4000000000000002E-2,2.4E-2,1.2999999999999999E-2,1.2E-2,null,null,null,null,null,null,null,null,11,"50-55",55,null,null,null,0.06,0.03,0.02]
[12,"0.55-0.60",0.6,5.7000000000000002E-2,2.9000000000000001E-2,2.1999999999999999E-2,8.9999999999999993E-3,8.9999999999999993E-3,null,null,"Data for <20m estimated",null,null,null,null,null,12,"55-60",60,null,null,null,null,0.04,0.02]
[13,"0.60-0.65",0.65,4.5999999999999999E-2,2.3E-2,2.1999999999999999E-2,1.2999999999999999E-2,7.0000000000000001E-3,null,null,null,null,null,null,null,null,13,"60-65",65,null,null,null,null,0.05,0.03]
[14,"0.65-0.70",0.7,3.1E-2,1.6E-2,2.1000000000000001E-2,6.0000000000000001E-3,8.0000000000000002E-3,null,null,null,null,null,null,null,null,14,"65-70",70,null,null,null,null,null,0.03]
[15,"0.70-0.75",0.75,3.9E-2,6.0000000000000001E-3,1.4E-2,4.0000000000000001E-3,3.0000000000000001E-3,null,null,null,null,null,null,null,null,15,"70-75",75,null,null,null,null,null,0.03]
[16,"0.75-0.80",0.8,0.02,6.0000000000000001E-3,1.4999999999999999E-2,2E-3,3.0000000000000001E-3,null,null,null,null,null,null,null,null,16,">75",80,null,null,null,null,null,0.01]
[17,"0.80-0.85",0.85,8.9999999999999993E-3,0.01,0.01,2E-3,2E-3,null,null,null,null,null,null,null,null,null,"metres"]
[18,"0.85-0.90",0.9,2E-3,7.0000000000000001E-3,0.01,1E-3,2E-3,null,null,null,null,null,null,null,null,null,null,"totals:",{"$f":"SUM(T6:T21)","v":0.99},0.92,1,0.98000000000000043,0.99000000000000032,0.99000000000000021]
[19,"0.90-0.95",0.95,8.9999999999999993E-3,3.0000000000000001E-3,8.0000000000000002E-3,1E-3,2E-3]
[{"$f":"A24+1","v":20},"0.95-1.00",1,5.7000000000000002E-2,0.01,2.1000000000000001E-2,8.0000000000000002E-3,5.0000000000000001E-3]
[null,"prop of max depth"]
[null,null,"totals:",{"$f":"SUM(D5:D25)","v":1.002},{"$f":"SUM(E5:E25)","v":0.99900000000000033},{"$f":"SUM(F5:F25)","v":1.0030000000000003},{"$f":"SUM(G5:G25)","v":0.99900000000000011},{"$f":"SUM(H5:H25)","v":1.0010000000000001}]
[]
["Check routine:"]
[null,"Species:",null,"harbour porpoise",null,"Use this routine to explore values of Q2R:"]
[null,"Water depth",null,35,null,"the calculations in this box do not affect"]
[null,"Min depth of turbine",null,8,null,"the main calculations"]
[null,"Max depth of turbine",null,25]
[null,"Flag",null,1]
[]
[null,"Q2R",null,{"$f":"Q2R2(D30,D31,D32,D33)","v":0.54400002956390381}]
[null,null,null,"0.544, 0.344, 0.236"]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}