{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input data","Overall collision risk","Single transit collision risk","Extended","Flightheight","Migrant collision risk","Daylight and night hours","Large array correction"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":20,"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":"Input data","index":0,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK ASSESSMENT",null,null,{"$f":"\"used in overall collision risk sheet\"","v":"used in overall collision risk sheet"},null,null,null,null,null,null,null,"used in available hours sheet"]
["Sheet 1 - Input data",null,null,"used in migrant collision risk sheet",null,null,null,null,null,null,null,"used in large array correction sheet"]
[null,null,null,"used in single transit collision risk sheet or extended model",null,null,null,null,null,null,null,"not used in calculation but stated for reference"]
[]
[null,"Units","Value",null,"Data sources"]
["Bird data"]
["Species name",null,"Gannet"]
["Bird length","m",0.94]
["Wingspan","m",1.72]
["Flight speed","m/sec",10.5]
["Nocturnal activity factor (1-5)",null,2]
["Flight type, flapping or gliding",null,"gliding"]
[null,null,null,null,"Data sources"]
["Bird survey data",null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Daytime bird density","birds/sq km",null,0,0,2.4E-2,7.7499999999999999E-2,0.15049999999999999,0.1128,8.0600000000000005E-2,6.7100000000000007E-2,0.25840000000000002,0,0,0]
["Proportion at rotor height","%",0.28100000000000003]
["Proportion of flights upwind","%",0.5]
[null,null,null,null,"Data sources"]
["Birds on migration data"]
["Migration passages","birds",null,0,0,0,4000,2000,0,0,0,2000,4000,0,0]
["Width of migration corridor","km",8]
["Proportion at rotor height","%",0.75]
["Proportion of flights upwind","%",0.5]
[null,"Units","Value",null,"Data sources"]
["Windfarm data"]
["Name of windfarm site",null,"Birdie Bank"]
["Latitude","degrees",55]
["Number of turbines",null,150]
["Width of windfarm","km",6]
["Tidal offset","m",0]
[null,"Units","Value",null,"Data sources"]
["Turbine data"]
["Turbine model",null,"5MW turbine"]
["No of blades",null,3]
["Rotation speed","rpm",20.2]
["Rotor radius","m",45]
["Hub height","m",65,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Monthly proportion of time operational","%",null,0.9,0.84,0.87,0.88,0.85,0.8,0.79,0.77,0.83,0.81,0.9,0.82]
["Max blade width","m",2.4300000000000002]
["Pitch","degrees",30]
[]
[]
["Avoidance rates used in presenting results",null,0.95,null,"Data sources (if applicable)"]
[null,null,0.98]
[null,null,0.99]
[null,null,0.995]

{"sheet":"Overall collision risk","index":1,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK ASSESSMENT"]
["Sheet 2 -  Overall collision risk",null,null,"All data input on Sheet 1:",null,null,null,null,null,"from Sheet 1 - input data"]
[null,null,null,"no data entry needed on this sheet!",null,null,null,null,null,"from Sheet 6 - available hours"]
["Bird details:",null,null,null,null,null,null,null,null,"from Sheet 3 - single transit collision risk"]
[null,"Species",null,{"$f":"'Input data'!C7","v":"Gannet"},null,null,null,null,null,"from survey data"]
[null,"Flight speed","m/sec",{"$f":"'Input data'!C10","v":10.5},null,null,null,null,null,"calculated field"]
[null,"Nocturnal activity factor (1-5)",null,{"$f":"'Input data'!C11","v":2}]
[null,"Nocturnal activity (% of daytime)",null,{"$f":"(D7-1)*0.25","v":0.25}]
["Windfarm data:"]
[null,"Latitude","degrees",{"$f":"'Input data'!C27","v":55}]
[null,"Number of turbines",null,{"$f":"'Input data'!C28","v":150}]
[null,"Rotor radius","m",{"$f":"'Input data'!C36","v":45}]
[null,"Minimum height of rotor","m",{"$f":"'Input data'!C37","v":65}]
[null,"Total rotor frontal area","sq m",{"$f":"D11*PI()*D12*D12","v":954258.76852789964}]
[null,null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"year average"]
[null,"Proportion of time operational","%",null,{"$f":"'Input data'!D38","v":0.9},{"$f":"'Input data'!E38","v":0.84},{"$f":"'Input data'!F38","v":0.87},{"$f":"'Input data'!G38","v":0.88},{"$f":"'Input data'!H38","v":0.85},{"$f":"'Input data'!I38","v":0.8},{"$f":"'Input data'!J38","v":0.79},{"$f":"'Input data'!K38","v":0.77},{"$f":"'Input data'!L38","v":0.83},{"$f":"'Input data'!M38","v":0.81},{"$f":"'Input data'!N38","v":0.9},{"$f":"'Input data'!O38","v":0.82},null,{"$f":"SUM(E16:P16)/12","v":0.83833333333333337}]
[]
["Stage A - flight activity"]
[null,"Daytime areal bird density","birds/sq km",null,{"$f":"'Input data'!D15","v":0},{"$f":"'Input data'!E15","v":0},{"$f":"'Input data'!F15","v":2.4E-2},{"$f":"'Input data'!G15","v":7.7499999999999999E-2},{"$f":"'Input data'!H15","v":0.15049999999999999},{"$f":"'Input data'!I15","v":0.1128},{"$f":"'Input data'!J15","v":8.0600000000000005E-2},{"$f":"'Input data'!K15","v":6.7100000000000007E-2},{"$f":"'Input data'!L15","v":0.25840000000000002},{"$f":"'Input data'!M15","v":0},{"$f":"'Input data'!N15","v":0},{"$f":"'Input data'!O15","v":0}]
[null,"Proportion at rotor height","%",{"$f":"'Input data'!C16","v":0.28100000000000003}]
[null,"Total daylight hours per month","hrs",null,{"$f":"'Daylight and night hours'!F10","v":243.24811012979927},{"$f":"'Daylight and night hours'!G10","v":269.60604999392496},{"$f":"'Daylight and night hours'!H10","v":365.86503389155268},{"$f":"'Daylight and night hours'!I10","v":422.15350530624903},{"$f":"'Daylight and night hours'!J10","v":499.35008716047173},{"$f":"'Daylight and night hours'!K10","v":517.78472329916804},{"$f":"'Daylight and night hours'!L10","v":519.73999209295596},{"$f":"'Daylight and night hours'!M10","v":464.47130896161394},{"$f":"'Daylight and night hours'!N10","v":383.87847966027289},{"$f":"'Daylight and night hours'!O10","v":326.93967221767957},{"$f":"'Daylight and night hours'!P10","v":254.37473852249423},{"$f":"'Daylight and night hours'!Q10","v":226.00216444504574}]
[null,"Total night hours per month","hrs",null,{"$f":"'Daylight and night hours'!F14","v":500.75188987020073},{"$f":"'Daylight and night hours'!G14","v":402.39395000607504},{"$f":"'Daylight and night hours'!H14","v":378.13496610844732},{"$f":"'Daylight and night hours'!I14","v":297.84649469375097},{"$f":"'Daylight and night hours'!J14","v":244.64991283952827},{"$f":"'Daylight and night hours'!K14","v":202.21527670083196},{"$f":"'Daylight and night hours'!L14","v":224.26000790704404},{"$f":"'Daylight and night hours'!M14","v":279.52869103838606},{"$f":"'Daylight and night hours'!N14","v":336.12152033972711},{"$f":"'Daylight and night hours'!O14","v":417.06032778232043},{"$f":"'Daylight and night hours'!P14","v":465.62526147750577},{"$f":"'Daylight and night hours'!Q14","v":517.99783555495424}]
[null,"Flux factor",null,null,{"$f":"$D6*E19/(2*$D12)*$D14*(E21+$D8*E22)*3600/1000000","v":0},0,4428.542850104699,15425.423562976222,33809.387459986523,25693.996375637198,18600.55568405434,14370.325764092091,48458.417524491117,0,0,0]
[]
["Option 1 -Basic model - Stages B, C and D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per annum"]
[null,"Potential bird transits through rotors ",null,null,{"$f":"E23*$D20","v":0},0,1244.4205408794205,4334.5440211963187,9500.4378762562137,7220.0129815540531,5226.7561472192701,4038.0615397098782,13616.815324382005,0,0,0,null,{"$f":"SUM(E26:P26)","v":45181.048431197152}]
[null,"Collision risk for single rotor transit","(from sheet 3)",{"$f":"'Single transit collision risk'!I39","v":0.15592944277227602}]
[null,"Collisions for entire windfarm, allowing for non-op time, assuming no avoidance","birds per month or year",null,{"$f":"E26*$D$27*E16","v":0},0,168.81636731692106,594.77706982939742,1259.1882865166683,900.65008081785822,643.85408709855062,484.83256804068259,1762.3078134670163,0,0,0,null,{"$f":"SUM(E28:P28)","v":5814.4262730870942}]
[]
["Option 2-Basic model using proportion from flight distribution",null,null,null,{"$f":"E28*$D33/$D20","v":0},0,64.514810911082392,227.29982171844227,481.21100754150689,344.19215733942104,246.05507951436087,185.28346479556029,673.48301091864312,0,0,0,null,{"$f":"SUM(E30:P30)","v":2222.039352739017}]
[]
["Option 3-Extended model using flight height distribution",null,null,{"$f":"Flightheight!B6","v":"Gannet"}]
[null,"Proportion at rotor height","(from sheet 4)",{"$f":"Extended!M45","v":0.10738687340653996}]
[null,"Potential bird transits through rotors","Flux integral",{"$f":"Extended!M47","v":6.0973345366423855E-2},{"$f":"E23*$D34","v":0},0,270.02307266944086,940.53967832872161,2061.4714582249981,1566.6489148553696,1134.1381057312435,876.20683584200583,2954.6718276311631,0,0,0,null,{"$f":"SUM(E34:P34)","v":9803.6998932829429}]
[null,"Collisions assuming no avoidance","Collision integral",{"$f":"Extended!M51","v":{"$error":"#VALUE!"}},{"$f":"E23*$D35*E16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(E35:P35)","v":{"$error":"#VALUE!"}}]
[null,"Average collision risk for single rotor transit",null,{"$f":"Extended!M51/Extended!M47","v":{"$error":"#VALUE!"}}]
[]
["Stage E - applying avoidance rates"]
[null,"Using which of above options?","Option 3",0,{"$f":"IF($C39=\"Option 1\",E28,IF($C39=\"Option 2\",E30,IF($C39=\"Option 3\",E35,0)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(E39:P39)","v":{"$error":"#VALUE!"}}]
[]
["Collisions assuming avoidance rate",null,"birds per month or year",{"$f":"'Input data'!C43","v":0.95},{"$f":"E$39*(1-$D41)","v":{"$error":"#VALUE!"}},{"$f":"F$39*(1-$D41)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(E41:P41)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"'Input data'!C44","v":0.98},{"$f":"E$39*(1-$D42)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(E42:P42)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"'Input data'!C45","v":0.99},{"$f":"E$39*(1-$D43)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(E43:P43)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"'Input data'!C46","v":0.995},{"$f":"E$39*(1-$D44)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(E44:P44)","v":{"$error":"#VALUE!"}}]
[]
["Collisions after applying large array correction",null,null,{"$f":"'Input data'!C43","v":0.95},{"$f":"E41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"F41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"G41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"H41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"I41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"J41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"K41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"L41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"M41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"N41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"O41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},{"$f":"P41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}},null,{"$f":"R41*'Large array correction'!$B18","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"'Input data'!C44","v":0.98},{"$f":"E42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"F42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"G42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"H42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"I42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"J42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"K42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"L42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"M42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"N42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"O42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},{"$f":"P42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}},null,{"$f":"R42*'Large array correction'!$C18","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"'Input data'!C45","v":0.99},{"$f":"E43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"F43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"G43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"H43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"I43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"J43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"K43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"L43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"M43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"N43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"O43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},{"$f":"P43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}},null,{"$f":"R43*'Large array correction'!$D18","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"'Input data'!C46","v":0.995},{"$f":"E44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"F44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"G44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"H44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"I44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"J44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"K44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"L44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"M44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"N44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"O44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},{"$f":"P44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}},null,{"$f":"R44*'Large array correction'!$E18","v":{"$error":"#VALUE!"}}]

{"sheet":"Single transit collision risk","index":2,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[9,6,9,8]]}
["COLLISION RISK ASSESSMENT"]
["Sheet 3 - probability of collision for single bird transit through rotor"]
[]
[null,"All input data must be entered on Sheet 1, not here"]
[null,"However the blade profile (orange) may be revised here to match the actual turbine blades used"]
[null,"Calculated outputs"]
[null,"Main output copied to sheet 1"]
[]
[null,null,null,"Calculation of alpha and p(collision) as a function of radius"]
["NoBlades",{"$f":"'Input data'!C34","v":3},null,null,null,null,"Upwind:",null,null,"Downwind:"]
["MaxChord",{"$f":"'Input data'!C39","v":2.4300000000000002}," m","r/R","c/C","a","collide",null,null,"collide"]
["Pitch (degrees)",{"$f":"'Input data'!C40","v":30},{"$f":"B12*PI()/180","v":0.52359877559829882},"radius","chord","alpha","length","p(collision)",null,"length","p(collision)"]
[]
["Species name",{"$f":"'Input data'!C7","v":"Gannet"},null,0,null,null,null,1,null,null,1]
["BirdLength",{"$f":"'Input data'!C8","v":0.94}," m",{"$f":"D14+B$27","v":0.05},0.73,{"$f":"$B$19*$B$22/(D15*($B$20)*2*PI())","v":2.206108122065876},{"$f":"ABS($B$11*$E15*SIN($C$12)+($F15*$B$11*$E15*COS($C$12)))+IF($F15<$B$25,$B$15,$B$16*$C$17*$F15)","v":6.6917245036316864},{"$f":"MIN(1,($B$10/$B$22)*G15/$B$19)","v":0.64368016653980986},null,{"$f":"ABS(-$B$11*$E15*SIN($C$12)+($F15*$B$11*$E15*COS($C$12)))+IF($F15<$B$25,$B$15,$B$16*$C$17*$F15)","v":4.917824503631687},{"$f":"MIN(1,($B$10/$B$22)*J15/$B$19)","v":0.47304788082552418}]
["Wingspan",{"$f":"'Input data'!C9","v":1.72}," m",{"$f":"D15+B$27","v":0.1},0.79,{"$f":"$B$19*$B$22/(D16*($B$20)*2*PI())","v":1.103054061032938},{"$f":"ABS($B$11*$E16*SIN($C$12)+($F16*$B$11*$E16*COS($C$12)))+IF($F16<$B$25,$B$15,$B$16*$C$17*$F16)","v":4.0015160316840319},0.38490773257151162,null,{"$f":"ABS(-$B$11*$E16*SIN($C$12)+($F16*$B$11*$E16*COS($C$12)))+IF($F16<$B$25,$B$15,$B$16*$C$17*$F16)","v":2.0818160316840322},0.20025087542865455]
["F: flapping (0) or gliding (+1)",{"$f":"IF('Input data'!$C$12=\"flapping\",0,IF('Input data'!$C$12=\"gliding\",1,\"!Error in type!\"))","v":1},{"$f":"IF(B17,2/PI(),1)","v":0.63661977236758138},0.15000000000000002,0.88,0.73536937402195857,3.2362561343242091,0.31129701863499537,null,1.0978561343242093,0.10560330434928107]
["Proportion of flights upwind",{"$f":"'Input data'!C17","v":0.5},"%",0.2,0.96,0.55152703051646901,2.8845446206552832,0.27746572065350822,null,0.65608414276426841,6.3109046113515338E-2]
["Bird speed",{"$f":"'Input data'!C10","v":10.5}," m/sec",0.25,1,0.4412216244131752,3.0835251991212558,0.2966057572488065,null,1.2264748008787438,0.11797519513214583]
["Rotor Radius",{"$f":"'Input data'!C36","v":45}," m",0.3,0.98,0.36768468701097934,2.8889955792823585,0.27789386048335069,null,1.3724044207176409,0.1320122347547445]
["Rotation Speed",{"$f":"'Input data'!C35","v":20.2},"rpm",0.35,0.92,0.31515830315226806,2.6679737022796823,0.25663366088595041,null,1.4476262977203174,0.13924786292357338]
["Rotation Period",{"$f":"60/B21","v":2.9702970297029703}," sec",0.39999999999999997,0.85,0.2757635152582345,2.4660290120331672,0.23720850496699988,null,1.4794709879668326,0.1423110188425239]
[null,null,null,0.44999999999999996,0.8,0.24512312467398628,2.3246778662761138,0.22361187094655954,null,1.499322133723886,0.14422051000582142]
[null,null,null,0.49999999999999994,0.75,0.22061081220658765,2.1994469496704712,0.21156584944449297,null,1.503053050329529,0.14457938865074518]
["Bird aspect ratio:  b",{"$f":"B15/B16","v":0.54651162790697672},null,0.54999999999999993,0.7,0.20055528382417057,2.085939836084036,0.2006475461376073,null,1.495060163915964,0.14381054910048796]
[null,null,null,0.6,0.64,0.18384234350548967,1.9652067197656682,0.18903417018698332,null,1.4699932802343316,0.14139935362254047]
["Integration interval",0.05,null,0.65,0.57999999999999996,0.16970062477429815,1.8518325444193569,0.17812865427271909,null,1.4375674555806428,0.13828029810823325]
[null,null,null,0.70000000000000007,0.52,0.157579151576134,1.7442403941225189,0.16777931410130895,null,1.3993596058774809,0.13460506685107199]
[null,null,null,0.75000000000000011,0.47,0.14707387480439171,1.6565189478623299,0.15934134641342412,null,1.3655810521376699,0.13135589168181397]
[null,null,null,0.80000000000000016,0.41,0.13788175762911722,1.5571172911374107,0.14977985371893188,null,1.3191827088625891,0.12689281294773477]
[null,null,null,0.8500000000000002,0.37,0.12977106600387506,1.4905953893161366,0.14338108030564742,null,1.2885046106838631,0.12394187207530492]
[null,null,null,0.90000000000000024,0.3,0.12256156233699307,1.3818770999267711,0.13292341627867035,null,1.2271229000732284,0.11803753610228197]
[null,null,null,0.95000000000000029,0.24,0.1161109537929408,1.2902436967866056,0.12410915559566396,null,1.1729563032133943,0.11282722535671696]
[null,null,null,1.0000000000000002,0,0.11030540610329378,0.94,9.0419047619047607E-2,null,0.94,9.0419047619047607E-2]
[]
[null,null,null,"Overall p(collision) integrated over disk"]
[null,null,null,null,null,null,"Upwind",{"$f":"2*(SUMPRODUCT($D15:$D33,H15:H33)+H34/2)*$B$27","v":0.18224494308696601},null,"Downwind",{"$f":"2*(SUMPRODUCT($D15:$D33,K15:K33)+K34/2)*$B$27","v":0.12961394245758603}]
[null,null,null,null,"   Proportion   upwind: downwind"]
[null,null,null,{"$f":"B18","v":0.5},{"$f":"1-B18","v":0.5},null,null,"Average",{"$f":"(D39*H37+E39*K37)","v":0.15592944277227602},"(copied to sheet 1)"]

{"sheet":"Extended","index":3,"n_rows":81,"n_cols":14,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
["INPUTS",null,"Npoints",21,null,"BASIC MODEL"]
[null,null,"r/R","c/C",null,"p(r) up","p(r) down"]
["NoBlades",{"$f":"'Input data'!C34","v":3},0,0.69]
["Radius",{"$f":"'Input data'!C36","v":45},0.05,0.73,null,{"$f":"pcoll_rav($C5,\"up\")","v":{"$error":"#VALUE!"}},{"$f":"pcoll_rav($C5,\"down\")","v":{"$error":"#VALUE!"}}]
["Rotation speed",{"$f":"'Input data'!C35","v":20.2},{"$f":"C5+0.05","v":0.1},0.79,null,{"$f":"pcoll_rav($C6,\"up\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["MaxChord",{"$f":"'Input data'!C39","v":2.4300000000000002},{"$f":"C6+0.05","v":0.15000000000000002},0.88,null,{"$f":"pcoll_rav($C7,\"up\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Pitch",{"$f":"'Input data'!C40","v":30},{"$f":"C7+0.05","v":0.2},0.96,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Hub height",{"$f":"'Input data'!C37","v":65},0.25,1,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Tidal offset",{"$f":"'Input data'!C30","v":0},0.3,0.98,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,0.35,0.92,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,0.39999999999999997,0.85,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Species name",{"$f":"'Input data'!C7","v":"Gannet"},0.44999999999999996,0.8,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["BirdLength",{"$f":"'Input data'!C8","v":0.94},0.49999999999999994,0.75,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Wingspan",{"$f":"'Input data'!C9","v":1.72},0.54999999999999993,0.7,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Bird speed",{"$f":"'Input data'!C10","v":10.5},0.6,0.64,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Flight type",{"$f":"'Input data'!C12","v":"gliding"},0.65,0.57999999999999996,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,0.70000000000000007,0.52,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,0.75000000000000011,0.47,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,0.80000000000000016,0.41,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,0.8500000000000002,0.37,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,0.90000000000000024,0.3,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,0.95000000000000029,0.24,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,1.0000000000000002,0,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,null,null,null,null,{"$f":"2*(SUMPRODUCT($C5:$C23,F5:F23)+F24/2)*0.05","v":{"$error":"#VALUE!"}},{"$f":"2*(SUMPRODUCT($C5:$C23,G5:G23)+G24/2)*0.05","v":{"$error":"#VALUE!"}},"Average collision risks for flight through disk"]
[null,null,null,null,null,{"$f":"'Input data'!C$17","v":0.5},{"$f":"1-F27","v":0.5},"Proportions upwind/downwind flight"]
[]
[null,null,null,null,null,null,"Average",{"$f":"F26*F27+G26*G27","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[null,"EXTENDED MODEL USING FLIGHT HEIGHT DISTRIBUTION"]
[]
[null,"Flight height distribution"]
[null,{"$f":"Flightheight!B6","v":"Gannet"}]
[]
[null,"y","d(y)","risk up","risk down","d(y) risk up","d(y) risk down",null,"xinc","yinc"]
[null,-1,{"$f":"interpolate(Npoints,\"flightheightdata\",hubheight+B41*radius+offset)*radius","v":0.52514999639242887},{"$f":"xrisksum(B41,0.05,\"up\")","v":{"$error":"#VALUE!"}},{"$f":"xrisksum(B41,0.05,\"down\")","v":{"$error":"#VALUE!"}},{"$f":"C41*D41","v":{"$error":"#VALUE!"}},{"$f":"C41*E41","v":{"$error":"#VALUE!"}},null,0.05,0.05,null,"x and y increments used in results below"]
[null,{"$f":"B41+0.05","v":-0.95},0.4775624955072999,{"$f":"xrisksum(B42,0.05,\"up\")","v":{"$error":"#VALUE!"}},{"$f":"xrisksum(B42,0.05,\"down\")","v":{"$error":"#VALUE!"}},{"$f":"C42*D42","v":{"$error":"#VALUE!"}},{"$f":"C42*E42","v":{"$error":"#VALUE!"}},null,null,null,null,"(though set fixed at 0.05 for diagram)"]
[null,-0.89999999999999991,0.39734998717904091,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.84999999999999987,0.30926249222829938,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.79999999999999982,0.22590000182390213,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Q'2R from flight distribution",null,null,null,{"$f":"0.05*(C41/2+C81/2+SUM(C42:C80))","v":0.10738687340653996}]
[null,-0.74999999999999978,0.15209999517537653,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Compare with Q2R input data",null,null,null,{"$f":"'Input data'!C16","v":0.28100000000000003}]
[null,-0.69999999999999973,9.9899995839223266E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Flux integral",null,null,null,{"$f":"(2/PI())*ydistsum(I41,J41,\"\",1)","v":6.0973345366423855E-2}]
[null,-0.64999999999999969,6.4800000982359052E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.59999999999999964,3.9600000309292227E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Collision integral",null,"(up)",{"$f":"(2/PI())*ydistsum(I41,J41,\"up\",0)","v":{"$error":"#VALUE!"}},"(down)",{"$f":"(2/PI())*ydistsum(I41,J41,\"down\",0)","v":{"$error":"#VALUE!"}}]
[null,-0.5499999999999996,2.2837501019239426E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Proportions upwind/downwind flight",null,null,{"$f":"'Input data'!C17","v":0.5},null,{"$f":"1-L50","v":0.5}]
[null,-0.49999999999999961,1.2824999430449679E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Collision integral (average)",null,null,null,{"$f":"L49*L50+N49*N50","v":{"$error":"#VALUE!"}}]
[null,-0.44999999999999962,6.8624998675659299E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.39999999999999963,4.0500000613974407E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.34999999999999964,2.1375000687839929E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Compare with Q'2R * p from Option 2",null,null,{"$f":"M45*bandup","v":{"$error":"#VALUE!"}},null,{"$f":"M45*banddown","v":{"$error":"#VALUE!"}}]
[null,-0.29999999999999966,1.1249999715801096E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"L49/L54","v":{"$error":"#VALUE!"}},null,{"$f":"N49/N54","v":{"$error":"#VALUE!"}}]
[null,-0.24999999999999967,8.9999997726408765E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.19999999999999968,4.4999998863204382E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.14999999999999969,4.4999998863204382E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-9.9999999999999686E-2,2.2499999431602191E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-4.9999999999999684E-2,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,3.1918911957973251E-16,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,5.0000000000000322E-2,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.10000000000000032,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.15000000000000033,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.20000000000000034,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.25000000000000033,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.30000000000000032,4.4999998863204382E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.35000000000000031,4.4999998863204382E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.4000000000000003,4.4999998863204382E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.45000000000000029,1.0125000153493602E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.50000000000000033,1.5750000420666765E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.55000000000000038,2.1375000687839929E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.60000000000000042,3.1500000841333531E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.65000000000000047,4.7249999624909833E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.70000000000000051,6.7500003206077963E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.75000000000000056,8.775000023888424E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.8000000000000006,9.9000000773230568E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.85000000000000064,9.7874998755287379E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.90000000000000069,8.775000023888424E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.95000000000000073,6.6375001188134775E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,1.0000000000000007,4.4999998863204382E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Flightheight","index":4,"n_rows":164,"n_cols":10,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
["FLIGHT HEIGHT DISTRIBUTIONS"]
["D(Y) is relative frequency per m of height"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J180)","v":1.0000000000000007}]
["Ensure birddata for current collision assessment is pasted into column B!"]
[]
["Current bird:","Gannet",null,"Gannet",null,"Kittiwake",null,"Fulmar",null,"Uniform"]
["No of points",155,null,155,null,150,null,155,null,155]
["height Y above sea (m)","D(Y)",null,"D(Y)",null,"D(Y)",null,"D(Y)",null,"D(Y)"]
[0,0.23316999999999999,null,0.23316999999999999,null,8.5709999999999995E-2,null,0.51407999999999998,null,0]
[1,0.15457000000000001,null,0.15457000000000001,null,7.85E-2,null,0.23183999999999999,null,0.03]
[2,0.10506,null,0.10506,null,7.1749999999999994E-2,null,0.11113000000000001,null,0.03]
[{"$f":"A11+1","v":3},7.3349999999999999E-2,null,7.3349999999999999E-2,null,6.5259999999999999E-2,null,5.4199999999999998E-2,null,0.03]
[{"$f":"A12+1","v":4},5.355E-2,null,5.355E-2,null,5.987E-2,null,2.7400000000000001E-2,null,0.03]
[5,3.9359999999999999E-2,null,3.9359999999999999E-2,null,5.4989999999999997E-2,null,1.4409999999999999E-2,null,0.03]
[6,2.8850000000000001E-2,null,2.8850000000000001E-2,null,5.0950000000000002E-2,null,7.8200000000000006E-3,null,0.03]
[7,2.1680000000000001E-2,null,2.1680000000000001E-2,null,4.6800000000000001E-2,null,4.3899999999999998E-3,null,0.03]
[8,1.6729999999999998E-2,null,1.6729999999999998E-2,null,4.2630000000000001E-2,null,2.5699999999999998E-3,null,0.03]
[9,1.316E-2,null,1.316E-2,null,3.9070000000000001E-2,null,1.5499999999999999E-3,null,0.03]
[10,1.077E-2,null,1.077E-2,null,3.5900000000000001E-2,null,9.7999999999999997E-4,null,0.03]
[11,9.3600000000000003E-3,null,9.3600000000000003E-3,null,3.2930000000000001E-2,null,6.4999999999999997E-4,null,5.0000000000000001E-3]
[12,8.7100000000000007E-3,null,8.7100000000000007E-3,null,2.997E-2,null,4.4999999999999999E-4,null,5.0000000000000001E-3]
[13,8.5400000000000007E-3,null,8.5400000000000007E-3,null,2.7470000000000001E-2,null,3.3E-4,null,5.0000000000000001E-3]
[14,8.77E-3,null,8.77E-3,null,2.5049999999999999E-2,null,2.5000000000000001E-4,null,5.0000000000000001E-3]
[15,9.3699999999999999E-3,null,9.3699999999999999E-3,null,2.3050000000000001E-2,null,1.9000000000000001E-4,null,5.0000000000000001E-3]
[16,1.009E-2,null,1.009E-2,null,2.1180000000000001E-2,null,1.6000000000000001E-4,null,5.0000000000000001E-3]
[17,1.0880000000000001E-2,null,1.0880000000000001E-2,null,1.9290000000000002E-2,null,1.2999999999999999E-4,null,5.0000000000000001E-3]
[18,1.1509999999999999E-2,null,1.1509999999999999E-2,null,1.7649999999999999E-2,null,1.2E-4,null,5.0000000000000001E-3]
[19,1.175E-2,null,1.175E-2,null,1.5869999999999999E-2,null,1E-4,null,5.0000000000000001E-3]
[20,1.167E-2,null,1.167E-2,null,1.3979999999999999E-2,null,9.0000000000000006E-5,null,5.0000000000000001E-3]
[21,1.137E-2,null,1.137E-2,null,1.247E-2,null,9.0000000000000006E-5,null,5.0000000000000001E-3]
[22,1.0789999999999999E-2,null,1.0789999999999999E-2,null,1.115E-2,null,9.0000000000000006E-5,null,5.0000000000000001E-3]
[23,1.008E-2,null,1.008E-2,null,9.9900000000000006E-3,null,8.0000000000000007E-5,null,5.0000000000000001E-3]
[24,9.2399999999999999E-3,null,9.2399999999999999E-3,null,8.9499999999999996E-3,null,8.0000000000000007E-5,null,5.0000000000000001E-3]
[25,8.4200000000000004E-3,null,8.4200000000000004E-3,null,8.0099999999999998E-3,null,8.0000000000000007E-5,null,5.0000000000000001E-3]
[26,7.5700000000000003E-3,null,7.5700000000000003E-3,null,7.1000000000000004E-3,null,6.9999999999999994E-5,null,5.0000000000000001E-3]
[27,6.6400000000000001E-3,null,6.6400000000000001E-3,null,6.3099999999999996E-3,null,6.9999999999999994E-5,null,5.0000000000000001E-3]
[28,5.7800000000000004E-3,null,5.7800000000000004E-3,null,5.6499999999999996E-3,null,6.9999999999999994E-5,null,5.0000000000000001E-3]
[29,5.0200000000000002E-3,null,5.0200000000000002E-3,null,4.96E-3,null,6.9999999999999994E-5,null,5.0000000000000001E-3]
[30,4.2900000000000004E-3,null,4.2900000000000004E-3,null,4.4400000000000004E-3,null,6.9999999999999994E-5,null,5.0000000000000001E-3]
[31,3.5200000000000001E-3,null,3.5200000000000001E-3,null,3.9100000000000003E-3,null,6.9999999999999994E-5,null,5.0000000000000001E-3]
[32,2.96E-3,null,2.96E-3,null,3.4499999999999999E-3,null,6.9999999999999994E-5,null,5.0000000000000001E-3]
[33,2.4199999999999998E-3,null,2.4199999999999998E-3,null,3.0500000000000002E-3,null,6.9999999999999994E-5,null,5.0000000000000001E-3]
[34,2.0200000000000001E-3,null,2.0200000000000001E-3,null,2.7100000000000002E-3,null,6.0000000000000002E-5,null,5.0000000000000001E-3]
[35,1.65E-3,null,1.65E-3,null,2.3800000000000002E-3,null,6.0000000000000002E-5,null,5.0000000000000001E-3]
[36,1.3699999999999999E-3,null,1.3699999999999999E-3,null,2.1299999999999999E-3,null,6.0000000000000002E-5,null,5.0000000000000001E-3]
[37,1.09E-3,null,1.09E-3,null,1.8500000000000001E-3,null,5.0000000000000002E-5,null,5.0000000000000001E-3]
[38,8.8000000000000003E-4,null,8.8000000000000003E-4,null,1.64E-3,null,5.0000000000000002E-5,null,5.0000000000000001E-3]
[39,6.8999999999999997E-4,null,6.8999999999999997E-4,null,1.4499999999999999E-3,null,5.0000000000000002E-5,null,5.0000000000000001E-3]
[40,5.4000000000000001E-4,null,5.4000000000000001E-4,null,1.2800000000000001E-3,null,4.0000000000000003E-5,null,5.0000000000000001E-3]
[41,4.0999999999999999E-4,null,4.0999999999999999E-4,null,1.1299999999999999E-3,null,4.0000000000000003E-5,null,5.0000000000000001E-3]
[42,3.2000000000000003E-4,null,3.2000000000000003E-4,null,1.01E-3,null,4.0000000000000003E-5,null,5.0000000000000001E-3]
[43,2.5000000000000001E-4,null,2.5000000000000001E-4,null,9.2000000000000003E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[44,1.9000000000000001E-4,null,1.9000000000000001E-4,null,8.0999999999999996E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[45,1.3999999999999999E-4,null,1.3999999999999999E-4,null,7.1000000000000002E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[46,1.1E-4,null,1.1E-4,null,6.3000000000000003E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[47,9.0000000000000006E-5,null,9.0000000000000006E-5,null,5.5000000000000003E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[48,6.9999999999999994E-5,null,6.9999999999999994E-5,null,4.8000000000000001E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[49,5.0000000000000002E-5,null,5.0000000000000002E-5,null,4.2000000000000002E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[50,4.0000000000000003E-5,null,4.0000000000000003E-5,null,3.8000000000000002E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[51,3.0000000000000001E-5,null,3.0000000000000001E-5,null,3.3E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[52,2.0000000000000002E-5,null,2.0000000000000002E-5,null,2.9999999999999997E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[53,2.0000000000000002E-5,null,2.0000000000000002E-5,null,2.5999999999999998E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[54,2.0000000000000002E-5,null,2.0000000000000002E-5,null,2.3000000000000001E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[55,1.0000000000000001E-5,null,1.0000000000000001E-5,null,2.1000000000000001E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[56,1.0000000000000001E-5,null,1.0000000000000001E-5,null,1.8000000000000001E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[57,1.0000000000000001E-5,null,1.0000000000000001E-5,null,1.6000000000000001E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[58,1.0000000000000001E-5,null,1.0000000000000001E-5,null,1.4999999999999999E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[59,1.0000000000000001E-5,null,1.0000000000000001E-5,null,1.2999999999999999E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[60,1.0000000000000001E-5,null,1.0000000000000001E-5,null,1.2E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[61,0,null,0,null,1E-4,null,3.0000000000000001E-5,null,5.0000000000000001E-3]
[62,0,null,0,null,9.0000000000000006E-5,null,2.0000000000000002E-5,null,5.0000000000000001E-3]
[63,0,null,0,null,8.0000000000000007E-5,null,2.0000000000000002E-5,null,5.0000000000000001E-3]
[64,0,null,0,null,6.9999999999999994E-5,null,2.0000000000000002E-5,null,5.0000000000000001E-3]
[65,0,null,0,null,6.9999999999999994E-5,null,2.0000000000000002E-5,null,5.0000000000000001E-3]
[66,0,null,0,null,6.0000000000000002E-5,null,1.0000000000000001E-5,null,5.0000000000000001E-3]
[67,0,null,0,null,5.0000000000000002E-5,null,1.0000000000000001E-5,null,5.0000000000000001E-3]
[{"$f":"A76+1","v":68},0,null,0,null,5.0000000000000002E-5,null,1.0000000000000001E-5,null,5.0000000000000001E-3]
[69,0,null,0,null,4.0000000000000003E-5,null,1.0000000000000001E-5,null,5.0000000000000001E-3]
[70,0,null,0,null,4.0000000000000003E-5,null,1.0000000000000001E-5,null,5.0000000000000001E-3]
[71,0,null,0,null,3.0000000000000001E-5,null,1.0000000000000001E-5,null,5.0000000000000001E-3]
[72,0,null,0,null,3.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[73,0,null,0,null,3.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[74,0,null,0,null,3.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[75,0,null,0,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[76,0,null,0,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[77,0,null,0,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[78,1.0000000000000001E-5,null,1.0000000000000001E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[79,1.0000000000000001E-5,null,1.0000000000000001E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[80,1.0000000000000001E-5,null,1.0000000000000001E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[81,1.0000000000000001E-5,null,1.0000000000000001E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[82,1.0000000000000001E-5,null,1.0000000000000001E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[83,1.0000000000000001E-5,null,1.0000000000000001E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[84,2.0000000000000002E-5,null,2.0000000000000002E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[85,2.0000000000000002E-5,null,2.0000000000000002E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[86,3.0000000000000001E-5,null,3.0000000000000001E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[87,3.0000000000000001E-5,null,3.0000000000000001E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[88,4.0000000000000003E-5,null,4.0000000000000003E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[89,4.0000000000000003E-5,null,4.0000000000000003E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[90,5.0000000000000002E-5,null,5.0000000000000002E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[91,6.0000000000000002E-5,null,6.0000000000000002E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[92,6.9999999999999994E-5,null,6.9999999999999994E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[93,9.0000000000000006E-5,null,9.0000000000000006E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[94,1E-4,null,1E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[95,1.2E-4,null,1.2E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[96,1.3999999999999999E-4,null,1.3999999999999999E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[97,1.6000000000000001E-4,null,1.6000000000000001E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[98,1.8000000000000001E-4,null,1.8000000000000001E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[99,2.0000000000000001E-4,null,2.0000000000000001E-4,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[100,2.1000000000000001E-4,null,2.1000000000000001E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[101,2.2000000000000001E-4,null,2.2000000000000001E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[102,2.2000000000000001E-4,null,2.2000000000000001E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[103,2.2000000000000001E-4,null,2.2000000000000001E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[104,2.1000000000000001E-4,null,2.1000000000000001E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[105,2.0000000000000001E-4,null,2.0000000000000001E-4,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[106,1.9000000000000001E-4,null,1.9000000000000001E-4,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[107,1.7000000000000001E-4,null,1.7000000000000001E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[108,1.3999999999999999E-4,null,1.3999999999999999E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[109,1.2E-4,null,1.2E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[110,1E-4,null,1E-4,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[111,9.0000000000000006E-5,null,9.0000000000000006E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[112,6.9999999999999994E-5,null,6.9999999999999994E-5,null,2.0000000000000002E-5,null,0,null,5.0000000000000001E-3]
[113,6.0000000000000002E-5,null,6.0000000000000002E-5,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[114,5.0000000000000002E-5,null,5.0000000000000002E-5,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[115,4.0000000000000003E-5,null,4.0000000000000003E-5,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[116,3.0000000000000001E-5,null,3.0000000000000001E-5,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[117,2.0000000000000002E-5,null,2.0000000000000002E-5,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[118,1.0000000000000001E-5,null,1.0000000000000001E-5,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[119,1.0000000000000001E-5,null,1.0000000000000001E-5,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[120,1.0000000000000001E-5,null,1.0000000000000001E-5,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[121,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[122,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[123,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[124,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[125,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[126,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[127,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[128,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[129,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[130,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[131,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[{"$f":"A140+1","v":132},0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[133,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[134,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[135,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[136,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[137,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[138,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[139,0,null,0,null,1.0000000000000001E-5,null,0,null,5.0000000000000001E-3]
[140,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[141,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[142,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[143,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[144,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[145,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[146,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[147,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[148,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[149,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[150,0,null,0,null,0,null,0,null,5.0000000000000001E-3]
[151,0,null,0,null,0,null,0,null,0]
[152,0,null,0,null,0,null,0,null,0]
[153,0,null,0,null,0,null,0,null,0]
[154,0,null,0,null,0,null,0,null,0]
[155,0,null,0,null,0,null,0,null,0]

{"sheet":"Migrant collision risk","index":5,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK ASSESSMENT (BIRDS ON MIGRATION)"]
["Sheet 2 -  Overall collision risk",null,"All data input on Sheet 1:",null,null,null,null,null,null,"from Sheet 1 - input data"]
[null,null,"no data entry needed on this sheet!",null,null,null,null,null,null,"from Sheet 6 - available hours"]
["Bird details:",null,"other than to choose option for final tables",null,null,null,null,null,null,"from Sheet 3 - single transit collision risk"]
[null,"Species",null,{"$f":"'Input data'!C7","v":"Gannet"},null,null,null,null,null,"from survey data"]
[null,"Flight speed","m/sec",{"$f":"'Input data'!C10","v":10.5},null,null,null,null,null,"calculated field"]
[null,"Flight type",null,{"$f":"'Input data'!C12","v":"gliding"}]
[]
["Windfarm data:"]
[null,"Number of turbines",null,{"$f":"'Input data'!C28","v":150}]
[null,"Rotor radius","m",{"$f":"'Input data'!C36","v":45}]
[null,"Minimum height of rotor","m",{"$f":"'Input data'!C37","v":65}]
[null,"Total rotor frontal area","sq m",{"$f":"D10*PI()*D11*D11","v":954258.76852789964}]
[null,null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"year average"]
[null,"Proportion of time operational","%",null,{"$f":"'Input data'!D38","v":0.9},{"$f":"'Input data'!E38","v":0.84},{"$f":"'Input data'!F38","v":0.87},{"$f":"'Input data'!G38","v":0.88},{"$f":"'Input data'!H38","v":0.85},{"$f":"'Input data'!I38","v":0.8},{"$f":"'Input data'!J38","v":0.79},{"$f":"'Input data'!K38","v":0.77},{"$f":"'Input data'!L38","v":0.83},{"$f":"'Input data'!M38","v":0.81},{"$f":"'Input data'!N38","v":0.9},{"$f":"'Input data'!O38","v":0.82},null,{"$f":"SUM(E15:P15)/12","v":0.83833333333333337}]
[]
["Stage A - flight activity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per annum"]
[null,"Migration passages",null,null,{"$f":"'Input data'!D20","v":0},{"$f":"'Input data'!E20","v":0},{"$f":"'Input data'!F20","v":0},{"$f":"'Input data'!G20","v":4000},{"$f":"'Input data'!H20","v":2000},{"$f":"'Input data'!I20","v":0},{"$f":"'Input data'!J20","v":0},{"$f":"'Input data'!K20","v":0},{"$f":"'Input data'!L20","v":2000},{"$f":"'Input data'!M20","v":4000},{"$f":"'Input data'!N20","v":0},{"$f":"'Input data'!O20","v":0},null,{"$f":"SUM(E18:P18)","v":12000}]
[null,"Migrant flux density","birds/ km",null,{"$f":"'Input data'!D20/'Input data'!$C$21","v":0},{"$f":"'Input data'!E20/'Input data'!$C$21","v":0},{"$f":"'Input data'!F20/'Input data'!$C$21","v":0},{"$f":"'Input data'!G20/'Input data'!$C$21","v":500},{"$f":"'Input data'!H20/'Input data'!$C$21","v":250},{"$f":"'Input data'!I20/'Input data'!$C$21","v":0},{"$f":"'Input data'!J20/'Input data'!$C$21","v":0},{"$f":"'Input data'!K20/'Input data'!$C$21","v":0},{"$f":"'Input data'!L20/'Input data'!$C$21","v":250},{"$f":"'Input data'!M20/'Input data'!$C$21","v":500},{"$f":"'Input data'!N20/'Input data'!$C$21","v":0},{"$f":"'Input data'!O20/'Input data'!$C$21","v":0}]
[null,"Proportion at rotor height","%",{"$f":"'Input data'!C22","v":0.75}]
[null,"Flux factor",null,null,{"$f":"E19/(2*$D11)*$D13/1000","v":0},{"$f":"F19/(2*$D11)*$D13/1000","v":0},0,5301.437602932775,2650.7188014663875,0,0,0,2650.7188014663875,5301.437602932775,0,0]
[]
["Option 1 -Basic model - Stages B, C and D"]
[null,"Potential bird transits through rotors ",null,null,{"$f":"E21*$D20","v":0},0,0,3976.078202199581,1988.0391010997905,0,0,0,1988.0391010997905,3976.078202199581,0,0,null,{"$f":"SUM(E24:P24)","v":11928.234606598744}]
[null,"Collision risk for single rotor transit","(from sheet 3)",{"$f":"'Single transit collision risk'!I39","v":0.15592944277227602}]
[null,"Collisions for entire windfarm, allowing for non-op time, assuming no avoidance","birds per month or year",null,{"$f":"E24*$D$25*E15","v":0},0,0,545.58913946941686,263.49475485738884,0,0,0,257.2948782725091,502.19000337525875,0,0,null,{"$f":"SUM(E26:P26)","v":1568.5687759745736}]
[]
["Option 2-Basic model using proportion from flight distribution",null,null,null,{"$f":"E26*$D31/$D20","v":0},0,0,78.118815802913801,37.727837177543599,0,0,0,36.840123361601393,71.904819091318387,0,0,null,{"$f":"SUM(E28:P28)","v":224.59159543337719}]
[]
["Option 3-Extended model using flight height distribution"]
[null,"Proportion at rotor height","(from sheet 4)",{"$f":"Extended!M45","v":0.10738687340653996}]
[null,"Potential bird transits through rotors","Flux integral",{"$f":"Extended!M47","v":6.0973345366423855E-2},{"$f":"E21*$D32","v":0},0,0,323.24638590216631,161.62319295108315,0,0,0,161.62319295108315,323.24638590216631,0,0,null,{"$f":"SUM(E32:P32)","v":969.73915770649887}]
[null,"Collisions assuming no avoidance","Collision integral",{"$f":"Extended!M51","v":{"$error":"#VALUE!"}},{"$f":"E21*$D33*E15","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(E33:P33)","v":{"$error":"#VALUE!"}}]
[null,"Average collision risk for single rotor transit",null,{"$f":"Extended!M51/Extended!M47","v":{"$error":"#VALUE!"}}]
[]
["Stage E - applying avoidance rates"]
[null,"Using which of above options?","Option 1",0,{"$f":"IF($C37=\"Option 1\",E26,IF($C37=\"Option 2\",E28,IF($C37=\"Option 3\",E33,0)))","v":0},0,0,545.58913946941686,263.49475485738884,0,0,0,257.2948782725091,502.19000337525875,0,0,null,{"$f":"SUM(E37:P37)","v":1568.5687759745736}]
[]
["Collisions assuming avoidance rate",null,"birds per month or year",{"$f":"'Input data'!C43","v":0.95},{"$f":"E$37*(1-$D39)","v":0},{"$f":"F$37*(1-$D39)","v":0},0,27.279456973470868,13.174737742869453,0,0,0,12.864743913625466,25.10950016876296,0,0,null,{"$f":"SUM(E39:P39)","v":78.428438798728749}]
[null,null,null,{"$f":"'Input data'!C44","v":0.98},{"$f":"E$37*(1-$D40)","v":0},0,0,10.911782789388347,5.2698950971477814,0,0,0,5.1458975654501868,10.043800067505185,0,0,null,{"$f":"SUM(E40:P40)","v":31.371375519491501}]
[null,null,null,{"$f":"'Input data'!C45","v":0.99},{"$f":"E$37*(1-$D41)","v":0},0,0,5.4558913946941736,2.6349475485738907,0,0,0,2.5729487827250934,5.0219000337525923,0,0,null,{"$f":"SUM(E41:P41)","v":15.68568775974575}]
[null,null,null,{"$f":"'Input data'!C46","v":0.995},{"$f":"E$37*(1-$D42)","v":0},0,0,2.7279456973470868,1.3174737742869453,0,0,0,1.2864743913625467,2.5109500168762962,0,0,null,{"$f":"SUM(E42:P42)","v":7.8428438798728752}]
[]
["Collisions after applying large array correction",null,null,{"$f":"'Input data'!C43","v":0.95},{"$f":"E39*'Large array correction'!$B18","v":0},{"$f":"F39*'Large array correction'!$B18","v":0},{"$f":"G39*'Large array correction'!$B18","v":0},{"$f":"H39*'Large array correction'!$B18","v":27.135245399887932},{"$f":"I39*'Large array correction'!$B18","v":13.105090107900422},{"$f":"J39*'Large array correction'!$B18","v":0},{"$f":"K39*'Large array correction'!$B18","v":0},{"$f":"L39*'Large array correction'!$B18","v":0},{"$f":"M39*'Large array correction'!$B18","v":12.796735046538059},{"$f":"N39*'Large array correction'!$B18","v":24.976759970351395},{"$f":"O39*'Large array correction'!$B18","v":0},{"$f":"P39*'Large array correction'!$B18","v":0},null,{"$f":"R39*'Large array correction'!$B18","v":78.013830524677815}]
[null,null,null,{"$f":"'Input data'!C44","v":0.98},{"$f":"E40*'Large array correction'!$C18","v":0},{"$f":"F40*'Large array correction'!$C18","v":0},{"$f":"G40*'Large array correction'!$C18","v":0},{"$f":"H40*'Large array correction'!$C18","v":10.888664196299461},{"$f":"I40*'Large array correction'!$C18","v":5.2587298675309899},{"$f":"J40*'Large array correction'!$C18","v":0},{"$f":"K40*'Large array correction'!$C18","v":0},{"$f":"L40*'Large array correction'!$C18","v":0},{"$f":"M40*'Large array correction'!$C18","v":5.1349950471184966},{"$f":"N40*'Large array correction'!$C18","v":10.022520453412005},{"$f":"O40*'Large array correction'!$C18","v":0},{"$f":"P40*'Large array correction'!$C18","v":0},null,{"$f":"R40*'Large array correction'!$C18","v":31.304909564360955}]
[null,null,null,{"$f":"'Input data'!C45","v":0.99},{"$f":"E41*'Large array correction'!$D18","v":0},{"$f":"F41*'Large array correction'!$D18","v":0},{"$f":"G41*'Large array correction'!$D18","v":0},{"$f":"H41*'Large array correction'!$D18","v":5.4501080179789838},{"$f":"I41*'Large array correction'!$D18","v":2.6321544405012141},{"$f":"J41*'Large array correction'!$D18","v":0},{"$f":"K41*'Large array correction'!$D18","v":0},{"$f":"L41*'Large array correction'!$D18","v":0},{"$f":"M41*'Large array correction'!$D18","v":2.570221394842362},{"$f":"N41*'Large array correction'!$D18","v":5.0165766983670199},{"$f":"O41*'Large array correction'!$D18","v":0},{"$f":"P41*'Large array correction'!$D18","v":0},null,{"$f":"R41*'Large array correction'!$D18","v":15.669060551689581}]
[null,null,null,{"$f":"'Input data'!C46","v":0.995},{"$f":"E42*'Large array correction'!$E18","v":0},{"$f":"F42*'Large array correction'!$E18","v":0},{"$f":"G42*'Large array correction'!$E18","v":0},{"$f":"H42*'Large array correction'!$E18","v":2.7264993871129182},{"$f":"I42*'Large array correction'!$E18","v":1.3167752721852162},{"$f":"J42*'Large array correction'!$E18","v":0},{"$f":"K42*'Large array correction'!$E18","v":0},{"$f":"L42*'Large array correction'!$E18","v":0},{"$f":"M42*'Large array correction'!$E18","v":1.2857923246043876},{"$f":"N42*'Large array correction'!$E18","v":2.5096187540471182},{"$f":"O42*'Large array correction'!$E18","v":0},{"$f":"P42*'Large array correction'!$E18","v":0},null,{"$f":"R42*'Large array correction'!$E18","v":7.8386857379496409}]

{"sheet":"Daylight and night hours","index":6,"n_rows":376,"n_cols":17,"rows_kept":376,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK ASSESSMENT"]
["Sheet 4 - Daylight and night hours"]
[]
["Latitude = ",{"$f":"'Input data'!C27","v":55},"central latitude of the proposal, copied from  the input data shoet: do not enter here"]
[]
["Taken from Forsythe et al.(1995) A model comparison for daylength as a function of latitude and day of year.  Ecological Modelling. 80: 87 - 95"]
[]
[null,"P","Daylength",null,null,"Monthly available daylight hours"]
[1,{"$f":"ASIN(0.39795*COS(0.2163108+2*ATAN(0.9671396*TAN(0.0086*(A9-186)))))","v":-0.40270065067443078},{"$f":"24-(24/PI())*ACOS((SIN(0.8333*PI()/180)+SIN($B$4*PI()/180)*SIN(B9))/(COS($B$4*PI()/180)*COS(B9)))","v":7.2657304049507658},"2009-01-01",null,"Jan","Feb","March","April","May","June","July","August","Sept","Oct","Nov","Dec"]
[{"$f":"A9+1","v":2},-0.4012979990256228,7.2877506863113481,{"$f":"D9+1","v":"2009-01-02"},null,{"$f":"SUM(C9:C39)","v":243.24811012979927},{"$f":"SUM(C40:C67)","v":269.60604999392496},{"$f":"SUM(C68:C98)","v":365.86503389155268},{"$f":"SUM(C99:C128)","v":422.15350530624903},{"$f":"SUM(C129:C159)","v":499.35008716047173},{"$f":"SUM(C160:C189)","v":517.78472329916804},{"$f":"SUM(C190:C220)","v":519.73999209295596},{"$f":"SUM(C221:C251)","v":464.47130896161394},{"$f":"SUM(C252:C281)","v":383.87847966027289},{"$f":"SUM(C282:C312)","v":326.93967221767957},{"$f":"SUM(C313:C342)","v":254.37473852249423},{"$f":"SUM(C343:C373)","v":226.00216444504574}]
[3,-0.39976204406913618,7.3117828262145146,"2009-01-03"]
[4,-0.39809353943540499,7.3377941869451533,"2009-01-04"]
[5,-0.39629330457846768,7.3657499390661556,"2009-01-05",null,"Monthly available nocturnal hours"]
[6,-0.39436222344644489,7.3956132319257684,"2009-01-06",null,{"$f":"F18-F10","v":500.75188987020073},402.39395000607504,378.13496610844732,297.84649469375097,244.64991283952827,202.21527670083196,224.26000790704404,279.52869103838606,336.12152033972711,417.06032778232043,465.62526147750577,517.99783555495424]
[7,-0.39230124306200953,7.4273453689729614,"2009-01-07"]
[8,-0.39011137201880836,7.46090598625198,"2009-01-08"]
[9,-0.38779367890004862,7.4962532325017754,"2009-01-09",null,"Monthly available total hours"]
[10,-0.38534929062564854,7.533343949361079,"2009-01-10",null,{"$f":"31*24","v":744},{"$f":"28*24","v":672},{"$f":"31*24","v":744},{"$f":"30*24","v":720},{"$f":"31*24","v":744},{"$f":"30*24","v":720},{"$f":"31*24","v":744},{"$f":"31*24","v":744},{"$f":"30*24","v":720},{"$f":"31*24","v":744},{"$f":"30*24","v":720},{"$f":"31*24","v":744}]
[11,-0.38277939073452405,7.5721338502720386,"2009-01-11"]
[12,-0.38008521760868019,7.6125776967817167,"2009-01-12"]
[13,-0.3772680626458555,7.6546294710577847,"2009-01-13",null,null,null,"these data are copied automatically to the 'overall collision risk' sheet"]
[14,-0.37432926838749264,7.6982425435592283,"2009-01-14"]
[15,-0.37127022660879272,7.7433698349320466,"2009-01-15"]
[16,-0.36809237637756381,7.7899639713307316,"2009-01-16"]
[17,-0.36479720208847966,7.8379774324960572,"2009-01-17"]
[18,-0.36138623147924798,7.8873626920466684,"2009-01-18"]
[19,-0.35786103363502658,7.9380723495635941,"2009-01-19"]
[20,-0.35422321698724518,7.9900592541622224,"2009-01-20"]
[21,-0.35047442731277689,8.043276619353616,"2009-01-21"]
[22,-0.34661634573917116,8.0976781290959678,"2009-01-22"]
[23,-0.34265068676140203,8.1532180350266366,"2009-01-23"]
[24,-0.33857919627531541,8.2098512449450887,"2009-01-24"]
[25,-0.33440364963266606,8.2675334026876772,"2009-01-25"]
[26,-0.3301258497223431,8.3262209595958847,"2009-01-26"]
[27,-0.32574762508206528,8.3858712378313296,"2009-01-27"]
[28,-0.32127082804451779,8.4464424858337157,"2009-01-28"]
[29,-0.3166973329215822,8.5078939262522653,"2009-01-29"]
[30,-0.31202903422998757,8.570185796708186,"2009-01-30"]
[31,-0.30726784496139742,8.6332793837652932,"2009-01-31"]
[32,-0.30241569489962233,8.6971370504995313,"2009-02-01"]
[33,-0.29747452898734572,8.7617222580656353,"2009-02-02"]
[34,-0.2924463057444362,8.8269995816621183,"2009-02-03"]
[35,-0.28733299573963289,8.8929347212939014,"2009-02-04"]
[36,-0.28213658011709092,8.9594945077267294,"2009-02-05"]
[37,-0.27685904917901016,9.0266469040188433,"2009-02-06"]
[38,-0.27150240102529655,9.0943610030043107,"2009-02-07"]
[39,-0.26606864025095711,9.1626070210891797,"2009-02-08"]
[40,-0.26055977670168745,9.2313562887067189,"2009-02-09"]
[41,-0.2549778242878894,9.300581237761838,"2009-02-10"]
[42,-0.24932479985713865,9.370255386377762,"2009-02-11"]
[43,-0.24360272212492995,9.4403533212403641,"2009-02-12"]
[44,-0.2378136106633385,9.510850677817654,"2009-02-13"]
[45,-0.23195948494707166,9.5817241187138773,"2009-02-14"]
[46,-0.22604236345622544,9.6529513103997022,"2009-02-15"]
[47,-0.22006426283491887,9.7245108985424729,"2009-02-16"]
[48,-0.21402719710485135,9.7963824821431675,"2009-02-17"]
[49,-0.20793317693271399,9.8685465866699769,"2009-02-18"]
[50,-0.20178420895027552,9.9409846363624972,"2009-02-19"]
[51,-0.19558229512587941,10.013678925864866,"2009-02-20"]
[52,-0.18932943218600487,10.08661259133163,"2009-02-21"]
[53,-0.18302761108547294,10.159769581136091,"2009-02-22"]
[54,-0.17667881652482589,10.233134626297623,"2009-02-23"]
[55,-0.17028502651334607,10.306693210732162,"2009-02-24"]
[56,-0.1638482119761564,10.380431541418165,"2009-02-25"]
[57,-0.15737033640379361,10.454336518559634,"2009-02-26"]
[58,-0.15085335554263429,10.528395705817474,"2009-02-27"]
[59,-0.14429921712452506,10.602597300671068,"2009-02-28"]
[60,-0.13770986063396565,10.676930104963072,"2009-03-01"]
[61,-0.13108721711117857,10.75138349567248,"2009-03-02"]
[62,-0.12443320898940256,10.825947395953369,"2009-03-03"]
[63,-0.11774974996475297,10.900612246469965,"2009-03-04"]
[64,-0.11103874489699148,10.975368977052341,"2009-03-05"]
[65,{"$f":"ASIN(0.39795*COS(0.2163108+2*ATAN(0.9671396*TAN(0.0086*(A73-186)))))","v":-0.10430208973957018},{"$f":"24-(24/PI())*ACOS((SIN(0.8333*PI()/180)+SIN($B$4*PI()/180)*SIN(B73))/(COS($B$4*PI()/180)*COS(B73)))","v":11.050208978691256},"2009-03-06"]
[{"$f":"A73+1","v":66},-9.7541671497316948E-2,11.125124075885463,{"$f":"D73+1","v":"2009-03-07"}]
[67,-9.0759368210158148E-2,11.200106499349962,"2009-03-08"]
[68,-8.3957048961284669E-2,11.275148859089384,"2009-03-09"]
[69,-7.713657390819266E-2,11.350244117836768,"2009-03-10"]
[70,-7.0299794335051582E-2,11.425385564854482,"2009-03-11"]
[71,-6.3448552724877982E-2,11.50056679009082,"2009-03-12"]
[72,-5.6584682850013432E-2,11.575781658683086,"2009-03-13"]
[73,-4.9710009879434795E-2,11.651024285795353,"2009-03-14"]
[74,-4.2826350501447133E-2,11.726289011776956,"2009-03-15"]
[75,-3.5935513060334934E-2,11.801570377625804,"2009-03-16"]
[76,-2.9039297705575597E-2,11.876863100738861,"2009-03-17"]
[77,-2.213949655223783E-2,11.952162050930793,"2009-03-18"]
[78,-1.5237893851218381E-2,12.027462226700445,"2009-03-19"]
[79,-8.3362661679892199E-3,12.102758731723833,"2009-03-20"]
[80,-1.4363825685515439E-3,12.178046751551511,"2009-03-21"]
[81,5.4599951886842163E-3,12.25332153048749,"2009-03-22"]
[82,1.2351112456354419E-2,12.328578348626477,"2009-03-23"]
[83,1.9235221498175616E-2,12.403812499025804,"2009-03-24"]
[84,2.6110581286776003E-2,12.479019264988358,"2009-03-25"]
[85,3.2975457300531918E-2,12.554193897432789,"2009-03-26"]
[86,3.9828121320597591E-2,12.629331592327455,"2009-03-27"]
[87,4.6666851229297958E-2,12.704427468164843,"2009-03-28"]
[88,5.3489930811048164E-2,12.779476543453724,"2009-03-29"]
[89,6.0295649556938738E-2,12.854473714206863,"2009-03-30"]
[90,6.7082302474124111E-2,12.929413731402912,"2009-03-31"]
[91,7.384818990113233E-2,13.004291178401992,"2009-04-01"]
[92,8.0591617330206269E-2,13.079100448295602,"2009-04-02"]
[93,8.7310895237778102E-2,13.15383572117274,"2009-04-03"]
[94,9.4004338924164668E-2,13.228490941285479,"2009-04-04"]
[95,0.10067026836356739,13.30305979409899,"2009-04-05"]
[96,0.10730700806544721,13.377535683212635,"2009-04-06"]
[97,0.11391288694833986,13.451911707140967,"2009-04-07"]
[98,0.12048623822716464,13.526180635945485,"2009-04-08"]
[99,0.12702539931507509,13.600334887710682,"2009-04-09"]
[100,0.13352871174088607,13.674366504860444,"2009-04-10"]
[101,0.13999452108310592,13.748267130313966,"2009-04-11"]
[102,0.14642117692158937,13.822027983483569,"2009-04-12"]
[103,0.15280703280781616,13.89563983612036,"2009-04-13"]
[104,0.15915044625478739,13.969092988017598,"2009-04-14"]
[105,0.1654497787475169,14.042377242585831,"2009-04-15"]
[106,0.17170339577507993,14.115481882318491,"2009-04-16"]
[107,0.1779096668851618,14.188395644171642,"2009-04-17"]
[108,0.18406696576203169,14.261106694886932,"2009-04-18"]
[109,0.19017367032883992,14.333602606292663,"2009-04-19"]
[110,0.1962281628751176,14.405870330624222,"2009-04-20"]
[111,0.20222883021032267,14.477896175911829,"2009-04-21"]
[112,0.20817406384425072,14.549665781490885,"2009-04-22"]
[113,0.21406226019508906,14.621164093697992,"2009-04-23"]
[114,0.21989182082585762,14.692375341824025,"2009-04-24"]
[115,0.22566115270993467,14.763283014404614,"2009-04-25"]
[116,0.23136866852632049,14.83386983593773,"2009-04-26"]
[117,0.23701278698523823,14.904117744128211,"2009-04-27"]
[118,0.24259193318461736,14.974007867769602,"2009-04-28"]
[119,0.24810453899794307,15.043520505384835,"2009-04-29"]
[120,0.25354904349388913,15.112635104759045,"2009-04-30"]
[121,0.25892389338807958,15.18133024350996,"2009-05-01"]
[122,0.26422754352725103,15.249583610854083,"2009-05-02"]
[123,0.26945845740600016,15.317371990739975,"2009-05-03"]
[124,0.27461510771622133,15.384671246533443,"2009-05-04"]
[125,0.27969597692923909,15.451456307453251,"2009-05-05"]
[126,0.28469955791054519,15.517701156969778,"2009-05-06"]
[127,0.28962435456694874,15.583378823393167,"2009-05-07"]
[128,0.29446888252583536,15.648461372891175,"2009-05-08"]
[129,{"$f":"ASIN(0.39795*COS(0.2163108+2*ATAN(0.9671396*TAN(0.0086*(A137-186)))))","v":0.2992316698461186},{"$f":"24-(24/PI())*ACOS((SIN(0.8333*PI()/180)+SIN($B$4*PI()/180)*SIN(B137))/(COS($B$4*PI()/180)*COS(B137)))","v":15.712919905190526},"2009-05-09"]
[{"$f":"A137+1","v":130},0.30391125776035022,15.776724552228549,{"$f":"D137+1","v":"2009-05-10"}]
[131,0.30850620144733043,15.839844480034021,"2009-05-11"]
[132,0.31301507083443186,15.902247894127308,"2009-05-12"]
[133,0.31743645142872373,15.963902048739621,"2009-05-13"]
[134,0.32176894517584037,16.02477326015914,"2009-05-14"]
[135,0.32601117134541141,16.084826924517667,"2009-05-15"]
[136,0.33016176744172082,16.144027540334733,"2009-05-16"]
[137,0.33421939013812968,16.202338736136188,"2009-05-17"]
[138,0.33818271623365037,16.259723303461229,"2009-05-18"]
[139,0.3420504436299201,16.316143235564187,"2009-05-19"]
[140,0.34582129232668085,16.371559772105726,"2009-05-20"]
[141,0.34949400543373249,16.425933450110843,"2009-05-21"]
[142,0.35306735019718966,16.479224161448482,"2009-05-22"]
[143,0.35654011903774069,16.531391217058658,"2009-05-23"]
[144,0.35991113059847635,16.582393418117483,"2009-05-24"]
[145,0.36317923079973574,16.632189134288012,"2009-05-25"]
[146,0.36634329389830056,16.680736389154887,"2009-05-26"]
[147,0.36940222354815688,16.72799295288327,"2009-05-27"]
[148,0.37235495385995226,16.7739164420775,"2009-05-28"]
[149,0.37520045045617745,16.818464426742143,"2009-05-29"]
[150,0.37793771151903094,16.861594544167954,"2009-05-30"]
[151,0.3805657688278557,16.903264619478676,"2009-05-31"]
[152,0.38308368878298299,16.943432792481204,"2009-06-01"]
[153,0.38549057341278142,16.982057650363828,"2009-06-02"]
[154,0.38778556136068282,17.019098365684926,"2009-06-03"]
[155,0.38996782884894871,17.054514838990094,"2009-06-04"]
[156,0.39203659061594703,17.088267845290449,"2009-06-05"]
[157,0.3939911008237324,17.120319183531134,"2009-06-06"]
[158,0.39583065393276545,17.15063182807873,"2009-06-07"]
[159,0.39755458554066286,17.179170081162212,"2009-06-08"]
[160,0.39916227318194486,17.20589972511636,"2009-06-09"]
[161,0.4006531370858431,17.23078817320209,"2009-06-10"]
[162,0.40202664088933854,17.253804617717403,"2009-06-11"]
[163,0.40328229230272722,17.274920174067965,"2009-06-12"]
[164,0.40441964372515909,17.294108019440223,"2009-06-13"]
[165,0.40543829280774868,17.311343524713987,"2009-06-14"]
[166,0.40633788296203932,17.326604378267561,"2009-06-15"]
[167,0.40711810381178526,17.339870700367381,"2009-06-16"]
[168,0.40777869158622421,17.351125146896685,"2009-06-17"]
[169,0.4083194294532238,17.36035300126326,"2009-06-18"]
[170,0.40874014779091672,17.367542253434948,"2009-06-19"]
[171,0.40904072439666622,17.372683665180524,"2009-06-20"]
[172,0.40922108463245721,17.375770820742364,"2009-06-21"]
[173,0.40928120150604741,17.376800162331588,"2009-06-22"]
[174,0.40922109568747611,17.375771010014319,"2009-06-23"]
[175,0.40904083546077746,17.37268556574459,"2009-06-24"]
[176,0.40874053661100912,17.367548901491912,"2009-06-25"]
[177,0.40832036224696044,17.360368931605027,"2009-06-26"]
[178,0.40778052256016339,17.35115636974415,"2009-06-27"]
[179,0.40712127452107588,17.339924670897062,"2009-06-28"]
[180,0.40634292151355761,17.326689959167133,"2009-06-29"]
[181,0.40544581290899201,17.311470942178914,"2009-06-30"]
[182,0.40443034358163826,17.294288813087324,"2009-07-01"]
[183,0.40329695336701854,17.27516714129667,"2009-07-02"]
[184,0.40204612646534715,17.254131753094093,"2009-07-03"]
[185,0.40067839079220724,17.231210603477493,"2009-07-04"]
[186,0.39919431727885635,17.20643364050969,"2009-07-05"]
[187,0.39759451912470972,17.179832663559345,"2009-07-06"]
[188,0.39587965100469674,17.151441176794801,"2009-07-07"]
[189,0.39405040823432064,17.121294239281816,"2009-07-08"]
[190,0.39210752589536413,17.089428313000969,"2009-07-09"]
[191,0.39005177792528284,17.055881110048105,"2009-07-10"]
[192,0.38788397617341153,17.020691440213525,"2009-07-11"]
[193,{"$f":"ASIN(0.39795*COS(0.2163108+2*ATAN(0.9671396*TAN(0.0086*(A201-186)))))","v":0.38560496942716405},{"$f":"24-(24/PI())*ACOS((SIN(0.8333*PI()/180)+SIN($B$4*PI()/180)*SIN(B201))/(COS($B$4*PI()/180)*COS(B201)))","v":16.983899060055208},"2009-07-12"]
[{"$f":"A201+1","v":194},0.38321564241146017,16.945544524491247,{"$f":"D201+1","v":"2009-07-13"}]
[195,0.38071691476463765,16.905669041838806,"2009-07-14"]
[196,0.37810973999411812,16.864314333124241,"2009-07-15"]
[197,0.37539510441509116,16.821522496383828,"2009-07-16"]
[198,0.37257402607546131,16.777335876568849,"2009-07-17"]
[199,0.36964755367026431,16.731796941564607,"2009-07-18"]
[200,0.36661676544871036,16.684948164731914,"2009-07-19"]
[201,0.36348276811694818,16.636831914283164,"2009-07-20"]
[202,0.36024669573956797,16.587490349714336,"2009-07-21"]
[203,0.35690970864277327,16.536965325429961,"2009-07-22"]
[204,0.35347299232205509,16.485298301621022,"2009-07-23"]
[205,0.34993775635709434,16.432530262386219,"2009-07-24"]
[206,0.34630523333650337,16.378701641025078,"2009-07-25"]
[207,0.34257667779489442,16.323852252377236,"2009-07-26"]
[208,0.33875336516463711,16.268021232035721,"2009-07-27"]
[209,0.33483659074452959,16.211246982222523,"2009-07-28"]
[210,0.33082766868747659,16.153567124082571,"2009-07-29"]
[211,0.3267279310091214,16.095018456126105,"2009-07-30"]
[212,0.32253872661924066,16.035636918529526,"2009-07-31"]
[213,0.31826142037756883,15.975457562990332,"2009-08-01"]
[214,0.31389739217557133,15.914514527822053,"2009-08-02"]
[215,0.3094480360455476,15.852841017969897,"2009-08-03"]
[216,0.30491475929830186,15.790469289626399,"2009-08-04"]
[217,0.3002989816904813,15.72743063912826,"2009-08-05"]
[218,0.29560213462254409,15.663755395820266,"2009-08-06"]
[219,0.29082566036818791,15.599472918579362,"2009-08-07"]
[220,0.28597101133594005,15.534611595700952,"2009-08-08"]
[221,0.2810396493634848,15.469198847860202,"2009-08-09"]
[222,0.27603304504518411,15.403261133872997,"2009-08-10"]
[223,0.27095267709313131,15.336823958993978,"2009-08-11"]
[224,0.26580003173196848,15.269911885502623,"2009-08-12"]
[225,0.26057660212759171,15.202548545342129,"2009-08-13"]
[226,0.25528388784977002,15.13475665459004,"2009-08-14"]
[227,0.24992339436860928,15.066558029553589,"2009-08-15"]
[228,0.24449663258470497,14.997973604296901,"2009-08-16"]
[229,0.23900511839274277,14.929023449420789,"2009-08-17"]
[230,0.23345037227823162,14.859726791929582,"2009-08-18"]
[231,0.22783391894698138,14.790102036032261,"2009-08-19"]
[232,0.22215728698686779,14.720166784737913,"2009-08-20"]
[233,0.21642200856137356,14.649937862117538,"2009-08-21"]
[234,0.21062961913432926,14.579431336115741,"2009-08-22"]
[235,0.20478165722523642,14.508662541806865,"2009-08-23"]
[236,0.19887966419449887,14.437646105000409,"2009-08-24"]
[237,0.19292518405785708,14.366395966110479,"2009-08-25"]
[238,0.18691976332927199,14.294925404213119,"2009-08-26"]
[239,0.18086495089148111,14.223247061224114,"2009-08-27"]
[240,0.17476229789341144,14.151372966137872,"2009-08-28"]
[241,0.16861335767361324,14.079314559275586,"2009-08-29"]
[242,0.16241968570885257,14.007082716497891,"2009-08-30"]
[243,0.15618283958698112,13.934687773343757,"2009-08-31"]
[244,0.14990437900318379,13.862139549063423,"2009-09-01"]
[245,0.14358586577869115,13.789447370518777,"2009-09-02"]
[246,0.1372288639010279,13.716620095929789,"2009-09-03"]
[247,0.13083493958486095,13.643666138450318,"2009-09-04"]
[248,0.12440566135249861,13.570593489561077,"2009-09-05"]
[249,0.11794260013308597,13.497409742271552,"2009-09-06"]
[250,0.11144732937953419,13.424122114126353,"2009-09-07"]
[251,0.10492142520221727,13.350737470014908,"2009-09-08"]
[252,9.8366466518461981E-2,13.277262344786497,"2009-09-09"]
[253,9.1784035216854076E-2,13.203702965675427,"2009-09-10"]
[254,8.5175716335381596E-2,13.13006527454381,"2009-09-11"]
[255,7.8543098252427196E-2,13.056354949951618,"2009-09-12"]
[256,7.1887772889623558E-2,12.982577429065973,"2009-09-13"]
[257,{"$f":"ASIN(0.39795*COS(0.2163108+2*ATAN(0.9671396*TAN(0.0086*(A265-186)))))","v":6.5211335925576056E-2},{"$f":"24-(24/PI())*ACOS((SIN(0.8333*PI()/180)+SIN($B$4*PI()/180)*SIN(B265))/(COS($B$4*PI()/180)*COS(B265)))","v":12.908737929423371},"2009-09-14"]
[{"$f":"A265+1","v":258},5.851538701945648E-2,12.834841470560431,{"$f":"D265+1","v":"2009-09-15"}]
[259,5.1801530043465584E-2,12.760892895530214,"2009-09-16"]
[260,4.5071373323155174E-2,12.686896892322519,"2009-09-17"]
[261,3.8326529884595034E-2,12.612858015207875,"2009-09-18"]
[262,3.1568617707364653E-2,12.538780706025928,"2009-09-19"]
[263,2.4799259982336799E-2,12.464669315439885,"2009-09-20"]
[264,1.8020085373216938E-2,12.390528124179506,"2009-09-21"]
[265,1.1232728280784856E-2,12.316361364295679,"2009-09-22"]
[266,4.4388291087809626E-3,12.242173240450281,"2009-09-23"]
[267,-2.3599654696410234E-3,12.167967951265307,"2009-09-24"]
[268,-9.16200224598019E-3,12.093749710755603,"2009-09-25"]
[269,-1.5965621212080523E-2,12.019522769869615,"2009-09-26"]
[270,-2.276915529856801E-2,11.945291438162666,"2009-09-27"]
[271,-2.9570930117173759E-2,11.871060105627034,"2009-09-28"]
[272,-3.6369263708101736E-2,11.79683326470299,"2009-09-29"]
[273,-4.3162466293620916E-2,11.722615532494418,"2009-09-30"]
[274,-4.9948840039085098E-2,11.648411673212214,"2009-10-01"]
[275,-5.6726678822605625E-2,11.574226620867854,"2009-10-02"]
[276,-6.3494268014627736E-2,11.500065502238693,"2009-10-03"]
[277,-7.0249884268685808E-2,11.425933660125507,"2009-10-04"]
[278,-7.6991795324642467E-2,11.351836676921494,"2009-10-05"]
[279,-8.3718259825737829E-2,11.277780398510545,"2009-10-06"]
[280,-9.0427527150810635E-2,11.203770958510866,"2009-10-07"]
[281,-9.7117837263074755E-2,11.129814802878125,"2009-10-08"]
[282,-0.10378742057686806,11.055918714880113,"2009-10-09"]
[283,-0.11043449784381584,10.98208984045243,"2009-10-10"]
[284,-0.11705728005988271,10.908335713941934,"2009-10-11"]
[285,-0.12365396839481139,10.834664284241583,"2009-10-12"]
[286,-0.13022275414547718,10.761083941316857,"2009-10-13"]
[287,-0.13676181871471219,10.68760354312005,"2009-10-14"]
[288,-0.1432693336171742,10.6142324428846,"2009-10-15"]
[289,-0.14974346051386658,10.540980516786741,"2009-10-16"]
[290,-0.15618235127692465,10.467858191956786,"2009-10-17"]
[291,-0.16258414808631289,10.394876474816575,"2009-10-18"]
[292,-0.16894698356008389,10.32204697971344,"2009-10-19"]
[293,-0.17526898091986423,10.249381957814292,"2009-10-20"]
[294,-0.18154825419324044,10.176894326216077,"2009-10-21"]
[295,-0.1877829084547176,10.104597697220775,"2009-10-22"]
[296,-0.19397104010692148,10.032506407714541,"2009-10-23"]
[297,-0.20011073720370579,9.9606355485811555,"2009-10-24"]
[298,-0.20620007981681013,9.8890009940699333,"2009-10-25"]
[299,-0.2122371404476939,9.8176194310273317,"2009-10-26"]
[300,-0.21821998448613558,9.7465083878900245,"2009-10-27"]
[301,-0.22414667071715533,9.6756862633247369,"2009-10-28"]
[302,-0.23001525187776373,9.6051723543870935,"2009-10-29"]
[303,-0.2358237752649886,9.5349868840577603,"2009-10-30"]
[304,-0.24157028339655812,9.4651510279994788,"2009-10-31"]
[305,-0.24725281472554392,9.3956869403632712,"2009-11-01"]
[306,-0.25286940441017458,9.3266177784558693,"2009-11-02"]
[307,-0.25841808513993075,9.2579677260637858,"2009-11-03"]
[308,-0.26389688801891376,9.189762015212164,"2009-11-04"]
[309,-0.2693038435073542,9.1220269461187744,"2009-11-05"]
[310,-0.27463698242198459,9.0547899050855438,"2009-11-06"]
[311,-0.27989433699584532,8.9880793800517527,"2009-11-07"]
[312,-0.28507394199791908,8.9219249735149724,"2009-11-08"]
[313,-0.29017383591281248,8.8563574125078404,"2009-11-09"]
[314,-0.29519206218049482,8.7914085553014854,"2009-11-10"]
[315,-0.30012667049590064,8.7271113944898797,"2009-11-11"]
[316,-0.30497571816797076,8.6635000560940618,"2009-11-12"]
[317,-0.30973727153746222,8.6006097943115698,"2009-11-13"]
[318,-0.31440940745261264,8.5384769815245871,"2009-11-14"]
[319,-0.318990214801466,8.4771390931713917,"2009-11-15"]
[320,-0.32347779609939875,8.4166346870794388,"2009-11-16"]
[321,{"$f":"ASIN(0.39795*COS(0.2163108+2*ATAN(0.9671396*TAN(0.0086*(A329-186)))))","v":-0.32787026913008305},{"$f":"24-(24/PI())*ACOS((SIN(0.8333*PI()/180)+SIN($B$4*PI()/180)*SIN(B329))/(COS($B$4*PI()/180)*COS(B329)))","v":8.3570033768563068},"2009-11-17"]
[{"$f":"A329+1","v":322},-0.33216576863783853,8.2982857989363357,{"$f":"D329+1","v":"2009-11-18"}]
[323,-0.33636244806900062,8.2405235728880708,"2009-11-19"]
[324,-0.34045848135963125,8.1837592545996873,"2009-11-20"]
[325,-0.34445206476656709,8.1280362819788685,"2009-11-21"]
[326,-0.34834141873848645,8.0733989128290986,"2009-11-22"]
[327,-0.35212478982334283,8.0198921545979669,"2009-11-23"]
[328,-0.35580045260819554,7.9675616857349993,"2009-11-24"]
[329,-0.3593667116871464,7.9164537684468748,"2009-11-25"]
[330,-0.36282190365277839,7.8666151526979995,"2009-11-26"]
[331,-0.36616439910618587,7.8180929713737584,"2009-11-27"]
[332,-0.36939260468039764,7.7709346266028412,"2009-11-28"]
[333,-0.3725049650717121,7.7251876673240574,"2009-11-29"]
[334,-0.37549996507320677,7.6808996582809215,"2009-11-30"]
[335,-0.37837613160444422,7.6381180407345717,"2009-12-01"]
[336,-0.3811320357311801,7.5968899853001837,"2009-12-02"]
[337,-0.38376629466869333,7.5572622374338358,"2009-12-03"]
[338,-0.38627757376219352,7.5192809562236675,"2009-12-04"]
[339,-0.38866458843764068,7.4829915472692043,"2009-12-05"]
[340,-0.39092610611621337,7.4484384905642997,"2009-12-06"]
[341,-0.39306094808561032,7.4156651644289653,"2009-12-07"]
[342,-0.39506799132135123,7.3847136666612379,"2009-12-08"]
[343,-0.39694617025126916,7.3556246341987404,"2009-12-09"]
[344,-0.3986944784564509,7.3284370626876658,"2009-12-10"]
[345,-0.40031197030199439,7.3031881274513921,"2009-12-11"]
[346,-0.40179776249110266,7.2799130074282061,"2009-12-12"]
[347,-0.40315103553623288,7.2586447137050136,"2009-12-13"]
[348,-0.40437103514126194,7.2394139243081526,"2009-12-14"]
[349,-0.40545707348891064,7.2222488269215148,"2009-12-15"]
[350,-0.40640853042799968,7.2071749711834698,"2009-12-16"]
[351,-0.40722485455547314,7.1942151321671197,"2009-12-17"]
[352,-0.40790556418853269,7.1833891865717341,"2009-12-18"]
[353,-0.40845024822266707,7.1747140030474661,"2009-12-19"]
[354,-0.40885856687182992,7.1682033479416134,"2009-12-20"]
[355,-0.40913025228752969,7.1638678075942863,"2009-12-21"]
[356,-0.40926510905411478,7.1617147281275315,"2009-12-22"]
[357,-0.40926301455809427,7.1617481734677639,"2009-12-23"]
[358,-0.40912391922989649,7.1639689021212014,"2009-12-24"]
[359,-0.40884784665705043,7.1683743629901961,"2009-12-25"]
[360,-0.40843489356836254,7.1749587102806807,"2009-12-26"]
[361,-0.40788522968924845,7.1837128373115817,"2009-12-27"]
[362,-0.40719909746897576,7.1946244288024346,"2009-12-28"]
[363,-0.40637681168115009,7.2076780309900563,"2009-12-29"]
[364,-0.40541875889935131,7.2228551387139888,"2009-12-30"]
[365,-0.40432539685038332,7.2401342984179493,"2009-12-31"]
[]
[null,null,{"$f":"SUM(C9:C373)","v":4493.4138656812283},{"$f":"SUM(C252:C373,C9:C98)","v":2069.914248860769},null,null,null,{"$f":"SUM(C99:C251)","v":2423.4996168204584}]
[null,null,"annual","winter",null,null,null,"summer"]

{"sheet":"Large array correction","index":7,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK ASSESSMENT"]
["Sheet 5 - Large array correction factor"]
[]
["Do not enter data on this sheet, unless to prescribe the number of turbine rows"]
["All the data below is derived from Sheets 1, 2 or 3",null,null,null,null,null,null,null,null,"data from Sheet 1"]
[null,null,null,null,null,null,null,null,null,"data from Sheet 2"]
["Number of turbines",{"$f":"'Input data'!C28","v":150},null,"Number of rows (optional)",null,null,null,null,null,"data from Sheet 3"]
["Rotor radius",{"$f":"'Input data'!C36","v":45},null,"(if this is left blank, number is assumed to be sqrt(T)",null,null,null,null,null,"data to be entered here (optional)"]
["Width of windfarm",{"$f":"'Input data'!C29","v":6},null,"Number of turbines in each row",null,null,{"$f":"IF(G7=\"\",\"\",B7/G7)","v":""},null,null,"calculated fields"]
["Average proportion of time operational",{"$f":"'Overall collision risk'!R16","v":0.83833333333333337}]
["Collision risk from single rotor transit",{"$f":"'Single transit collision risk'!I39","v":0.15592944277227602}]
["Assumed number of turbine rows",{"$f":"IF(G7=\"\",B7^0.5,G7)","v":12.24744871391589}]
[]
["Avoidance rate",{"$f":"'Input data'!C43","v":0.95},{"$f":"'Input data'!C44","v":0.98},{"$f":"'Input data'!C45","v":0.99},{"$f":"'Input data'!C46","v":0.995}]
[]
["Collision risk for single bird passage, before correction",{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-B14)","v":1.1550140452572265E-2},{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-C14)","v":4.6200561810289063E-3},{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-D14)","v":2.3100280905144531E-3},{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-E14)","v":1.1550140452572266E-3}]
[]
["Large array correction factor",{"$f":"1-($B12-1)/(2*$B12)*B16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(B16*B16)","v":0.99471354676439561},{"$f":"1-($B12-1)/(2*$B12)*C16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(C16*C16)","v":0.99788131843025973},{"$f":"1-($B12-1)/(2*$B12)*D16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(D16*D16)","v":0.99893997583588012},{"$f":"1-($B12-1)/(2*$B12)*E16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(E16*E16)","v":0.99946981707312754}]