{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input data","Overall collision risk","Single transit collision risk","Extended","Flightheight","Daylight and night hours","Large array correction","Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK ASSESSMENT",null,null,null,null,{"$f":"\"used in overall collision risk sheet\"","v":"used in overall collision risk sheet"}]
["Sheet 1 - Input data",null,null,null,null,"used in single transit collision risk sheet or extended model"]
[null,null,null,null,null,"used in available hours sheet"]
[null,null,null,null,null,"used in large array correction sheet"]
[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",14.9]
["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.05,0.47,1.49,1.4,0.88,1.04,0.56999999999999995,1.8,2.79,0.83,0.5,0.12]
["Proportion at rotor height","%",8.2799999999999999E-2]
["Proportion of flights upwind","%",0.5]
[]
[null,"Units","Value",null,"Data sources"]
["Windfarm data"]
["Name of windfarm site",null,"Worked example site"]
["Latitude","degrees",55.8]
["Number of turbines",null,200]
["Width of windfarm","km",7.8]
["Tidal offset","m",2.5]
[]
[null,"Units","Value",null,"Data sources"]
["Turbine data"]
["Turbine model",null,"4MW turbine"]
["No of blades",null,3]
["Rotation speed","rpm",9.9]
["Rotor radius","m",57.5]
["Hub height","m",80,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Monthly proportion of time operational","%",null,0.84599999999999997,0.84599999999999997,0.84599999999999997,0.77300000000000002,0.65500000000000003,0.63800000000000001,0.64600000000000002,0.71799999999999997,0.73599999999999999,0.79,0.81799999999999995,0.84599999999999997]
["Max blade width","m",4.21]
["Pitch","degrees",15]
[]
[]
["Avoidance rates used in presenting results",null,0.96,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'!C9","v":"Gannet"},null,null,null,null,null,"from survey data"]
[null,"Flight speed","m/sec",{"$f":"'Input data'!C12","v":14.9},null,null,null,null,null,"calculated field"]
[null,"Nocturnal activity factor (1-5)",null,{"$f":"'Input data'!C13","v":2}]
[null,"Nocturnal activity (% of daytime)",null,{"$f":"(D7-1)*0.25","v":0.25}]
["Windfarm data:"]
[null,"Latitude","degrees",{"$f":"'Input data'!C25","v":55.8}]
[null,"Number of turbines",null,{"$f":"'Input data'!C26","v":200}]
[null,"Rotor radius","m",{"$f":"'Input data'!C35","v":57.5}]
[null,"Minimum height of rotor","m",{"$f":"'Input data'!C36","v":80}]
[null,"Total rotor frontal area","sq m",{"$f":"D11*PI()*D12*D12","v":2077378.1421862508}]
[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'!D37","v":0.84599999999999997},{"$f":"'Input data'!E37","v":0.84599999999999997},{"$f":"'Input data'!F37","v":0.84599999999999997},{"$f":"'Input data'!G37","v":0.77300000000000002},{"$f":"'Input data'!H37","v":0.65500000000000003},{"$f":"'Input data'!I37","v":0.63800000000000001},{"$f":"'Input data'!J37","v":0.64600000000000002},{"$f":"'Input data'!K37","v":0.71799999999999997},{"$f":"'Input data'!L37","v":0.73599999999999999},{"$f":"'Input data'!M37","v":0.79},{"$f":"'Input data'!N37","v":0.81799999999999995},{"$f":"'Input data'!O37","v":0.84599999999999997},null,{"$f":"SUM(E16:P16)/12","v":0.76316666666666666}]
[]
["Stage A - flight activity"]
[null,"Daytime areal bird density","birds/sq km",null,{"$f":"'Input data'!D18","v":0.05},{"$f":"'Input data'!E18","v":0.47},{"$f":"'Input data'!F18","v":1.49},{"$f":"'Input data'!G18","v":1.4},{"$f":"'Input data'!H18","v":0.88},{"$f":"'Input data'!I18","v":1.04},{"$f":"'Input data'!J18","v":0.56999999999999995},{"$f":"'Input data'!K18","v":1.8},{"$f":"'Input data'!L18","v":2.79},{"$f":"'Input data'!M18","v":0.83},{"$f":"'Input data'!N18","v":0.5},{"$f":"'Input data'!O18","v":0.12}]
[null,"Proportion at rotor height","%",{"$f":"'Input data'!C19","v":8.2799999999999999E-2}]
[null,"Total daylight hours per month","hrs",null,{"$f":"'Daylight and night hours'!F10","v":238.78888198261959},{"$f":"'Daylight and night hours'!G10","v":267.45031393014273},{"$f":"'Daylight and night hours'!H10","v":365.61770672963922},{"$f":"'Daylight and night hours'!I10","v":424.04227433468935},{"$f":"'Daylight and night hours'!J10","v":503.61114467295624},{"$f":"'Daylight and night hours'!K10","v":523.48372937097724},{"$f":"'Daylight and night hours'!L10","v":524.89172337782463},{"$f":"'Daylight and night hours'!M10","v":467.39166898582283},{"$f":"'Daylight and night hours'!N10","v":384.55261523808144},{"$f":"'Daylight and night hours'!O10","v":325.48317795403966},{"$f":"'Daylight and night hours'!P10","v":250.82142903002887},{"$f":"'Daylight and night hours'!Q10","v":220.79045233583778}]
[null,"Total night hours per month","hrs",null,{"$f":"'Daylight and night hours'!F14","v":505.21111801738039},{"$f":"'Daylight and night hours'!G14","v":404.54968606985727},{"$f":"'Daylight and night hours'!H14","v":378.38229327036078},{"$f":"'Daylight and night hours'!I14","v":295.95772566531065},{"$f":"'Daylight and night hours'!J14","v":240.38885532704376},{"$f":"'Daylight and night hours'!K14","v":196.51627062902276},{"$f":"'Daylight and night hours'!L14","v":219.10827662217537},{"$f":"'Daylight and night hours'!M14","v":276.60833101417717},{"$f":"'Daylight and night hours'!N14","v":335.44738476191856},{"$f":"'Daylight and night hours'!O14","v":418.51682204596034},{"$f":"'Daylight and night hours'!P14","v":469.17857096997113},{"$f":"'Daylight and night hours'!Q14","v":523.20954766416219}]
[null,"Flux factor",null,null,{"$f":"$D6*E19/(2*$D12)*$D14*(E21+$D8*E22)*3600/1000000","v":17687.986776415542},167859.22927281811,664434.08234478789,675602.91383011302,480666.25440478692,577033.29855379125,320155.71762470005,935802.3541127455,1266312.7641327186,345912.71461550309,178345.13620987965,40881.587704571532]
[]
["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":1464.565305087207},13898.744183789338,55015.142018148435,55939.921265133358,39799.165864716357,47778.357120253917,26508.893419325163,77484.434920535321,104850.6968701891,28641.572770163657,14766.977278178036,3384.9954619385226,null,{"$f":"SUM(E26:P26)","v":469533.46647745837}]
[null,"Collision risk for single rotor transit","(from sheet 3)",{"$f":"'Single transit collision risk'!I39","v":7.5926348934317878E-2}]
[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":94.074435546910351},892.76764194754003,3533.8256436316788,3283.1737075717883,1979.2825073542072,2314.4319046729024,1300.219375585438,4224.0731542980966,5859.2449190772631,1717.9735380583315,917.14378367397694,217.43075321025586,null,{"$f":"SUM(E28:P28)","v":26333.641364628395}]
[]
["Option 2-Basic model using proportion from flight distribution",null,null,null,{"$f":"E28*$D33/$D20","v":64.49651830202842},612.07281471931572,2422.7565010157896,2250.9119708037074,1356.9768419901818,1586.7520100516494,891.41776154778461,2895.9834828819407,4017.0413456362739,1177.8259534124707,628.7848604717243,149.06841026812475,null,{"$f":"SUM(E30:P30)","v":18054.088471100993}]
[]
["Option 3-Advanced model using flight height distribution",null,null,{"$f":"Flightheight!B6","v":"Gannet"}]
[null,"Proportion at rotor height","(from sheet 4)",{"$f":"Extended!M45","v":5.6766874915183507E-2}]
[null,"Potential bird transits through rotors","Flux integral",{"$f":"Extended!M47","v":2.7188995690499766E-2},{"$f":"E23*$D34","v":480.91859623757904},4563.9238613092639,18065.295401493604,18368.964712616027,13068.832719580416,15688.955867653895,8704.7124267868294,25443.526173130973,34429.772286829328,9405.019306969989,4849.0251398320115,1111.5293119203836,null,{"$f":"SUM(E34:P34)","v":154180.47580436029}]
[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":"D35/D34","v":{"$error":"#VALUE!"}}]
[]
["Stage E - applying avoidance rates"]
[null,"Using which of above options?","Option 3",null,{"$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'!C42","v":0.96},{"$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'!C43","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'!C44","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'!C45","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'!C42","v":0.96},{"$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'!C43","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'!C44","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'!C45","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'!C33","v":3},null,null,null,null,"Upwind:",null,null,"Downwind:"]
["MaxChord",{"$f":"'Input data'!C38","v":4.21}," m","r/R","c/C","a","collide",null,null,"collide"]
["Pitch (degrees)",{"$f":"'Input data'!C39","v":15},{"$f":"B12*PI()/180","v":0.26179938779914941},"radius","chord","alpha","length","p(collision)",null,"length","p(collision)"]
[]
["Species name",{"$f":"'Input data'!C9","v":"Gannet"},null,0,null,null,null,1,null,null,1]
["BirdLength",{"$f":"'Input data'!C10","v":0.94}," m",{"$f":"D14+B$27","v":0.05},0.73,{"$f":"$B$19*$B$22/(D15*($B$20)*2*PI())","v":4.9990169213580833},{"$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":21.109263018548191},{"$f":"MIN(1,($B$10/$B$22)*G15/$B$19)","v":0.70128088551552714},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":19.518405875921033},{"$f":"MIN(1,($B$10/$B$22)*J15/$B$19)","v":0.64843026232086654}]
["Wingspan",{"$f":"'Input data'!C11","v":1.72}," m",{"$f":"D15+B$27","v":0.1},0.79,{"$f":"$B$19*$B$22/(D16*($B$20)*2*PI())","v":2.4995084606790416},{"$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":11.627585712938775},0.38628556563118749,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":9.9059731887258273},0.32909105559860968]
["F: flapping (0) or gliding (+1)",{"$f":"IF('Input data'!$C$14=\"flapping\",0,IF('Input data'!$C$14=\"gliding\",1,\"!Error in type!\"))","v":1},{"$f":"IF(B17,2/PI(),1)","v":0.63661977236758138},0.15000000000000002,0.88,1.6663389737860272,8.746587992732346,0.29057456754379268,null,6.8288423961407076,0.22686422725433894]
["Proportion of flights upwind",{"$f":"'Input data'!C20","v":0.5},"%",0.2,0.96,1.2497542303395208,7.293404266657074,0.24229765852317126,null,5.2013181612843784,0.17279546911649446]
["Bird speed",{"$f":"'Input data'!C12","v":14.9}," m/sec",0.25,1,0.99980338427161641,6.2501470783155249,0.2076391143467238,null,4.0708907185523007,0.13524100038143549]
["Rotor Radius",{"$f":"'Input data'!C35","v":57.5}," m",0.3,0.98,0.83316948689301373,5.3005055619550188,0.17609062101796874,null,3.1648343293870589,0.10514046933198617]
["Rotation Speed",{"$f":"'Input data'!C34","v":9.9},"rpm",0.35,0.92,0.71414527447972609,4.4562143854334044,0.14804202152949902,null,2.451298534451237,8.1435756681433713E-2]
["Rotation Period",{"$f":"60/B21","v":6.0606060606060606}," sec",0.39999999999999997,0.85,0.62487711516976052,3.7703443724111945,0.12525640700292223,null,1.9179764666124535,6.3718010132427144E-2]
[null,null,null,0.44999999999999996,0.8,0.5554463245953426,3.2869076895426534,0.10919592659890022,null,1.5435026017320732,5.1277435426669543E-2]
[null,null,null,0.49999999999999994,0.75,0.49990169213580832,3.2818767029486962,0.10902878979594662,null,1.6474344331262776,5.4730204321980364E-2]
["Bird aspect ratio:  b",{"$f":"B15/B16","v":0.54651162790697672},null,0.54999999999999993,0.7,0.45445608375982571,2.9963868745549957,9.9544396168102206E-2,null,1.4709074227207388,4.8865716392400387E-2]
[null,null,null,0.6,0.64,0.41658474344650687,2.7215615501731114,9.0414293109777846E-2,null,1.3268374799246474,4.4079500171993316E-2]
["Integration interval",0.05,null,0.65,0.57999999999999996,0.38453976318139099,2.4789589386510706,8.2354676149817438E-2,null,1.2149902499884004,4.0363770049950211E-2]
[null,null,null,0.70000000000000007,0.52,0.35707263723986299,2.2616741729474792,7.5136155410000141E-2,null,1.1284608658706023,3.748913614805021E-2]
[null,null,null,0.75000000000000011,0.47,0.33326779475720547,2.0890924596355744,6.9402736075141566E-2,null,1.0648419705468588,3.5375622511456047E-2]
[null,null,null,0.80000000000000016,0.41,0.31243855758488009,1.907671539497602,6.3375665238343148E-2,null,1.01417643199468,3.3692438512574939E-2]
[null,null,null,0.8500000000000002,0.37,0.29405981890341654,1.7856114933592315,5.932065028273957E-2,null,0.97928664024683865,3.2533348115582894E-2]
[null,null,null,0.90000000000000024,0.3,0.27772316229767119,1.6057008024172583,5.3343751489700858E-2,null,0.95192389448829096,3.1624317300114363E-2]
[null,null,null,0.95000000000000029,0.24,0.26310615375568847,1.4582948588410583,4.8446708397739853E-2,null,0.94472666750211554,3.1385214792855512E-2]
[null,null,null,1.0000000000000002,0,0.24995084606790408,0.94,3.1228187919463087E-2,null,0.94,3.1228187919463087E-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":9.5399193707952079E-2},null,"Downwind",{"$f":"2*(SUMPRODUCT($D15:$D33,K15:K33)+K34/2)*$B$27","v":5.6453504160683669E-2}]
[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":7.5926348934317878E-2},"(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'!C33","v":3},0,0.69]
["Radius",{"$f":"'Input data'!C35","v":57.5},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'!C34","v":9.9},{"$f":"C5+0.05","v":0.1},0.79,null,{"$f":"pcoll_rav($C6,\"up\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["MaxChord",{"$f":"'Input data'!C38","v":4.21},{"$f":"C6+0.05","v":0.15000000000000002},0.88,null,{"$f":"pcoll_rav($C7,\"up\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Pitch",{"$f":"'Input data'!C39","v":15},{"$f":"C7+0.05","v":0.2},0.96,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Hub height",{"$f":"'Input data'!C36","v":80},0.25,1,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Tidal offset",{"$f":"'Input data'!C28","v":2.5},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'!C9","v":"Gannet"},0.44999999999999996,0.8,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["BirdLength",{"$f":"'Input data'!C10","v":0.94},0.49999999999999994,0.75,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Wingspan",{"$f":"'Input data'!C11","v":1.72},0.54999999999999993,0.7,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Bird speed",{"$f":"'Input data'!C12","v":14.9},0.6,0.64,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Flight type",{"$f":"'Input data'!C14","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$20","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,"ALTERNATIVE 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.48414999153465033},{"$f":"xrisksum2(B41,I$41,\"up\")","v":{"$error":"#VALUE!"}},{"$f":"xrisksum2(B41,I$41,\"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.33853125059977174,{"$f":"xrisksum2(B42,I$41,\"up\")","v":{"$error":"#VALUE!"}},{"$f":"xrisksum2(B42,I$41,\"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.21346874884329736,{"$f":"xrisksum2(B43,I$41,\"up\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.84999999999999987,0.12477499956730753,{"$f":"xrisksum2(B44,I$41,\"up\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.79999999999999982,7.0725003024563193E-2,{"$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":5.6766874915183507E-2}]
[null,-0.74999999999999978,3.6440624680835754E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Compare with Q2R input data",null,null,null,{"$f":"'Input data'!C19","v":8.2799999999999999E-2}]
[null,-0.69999999999999973,1.7393750240444206E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Flux integral",null,null,null,{"$f":"(2/PI())*ydistsum(I41,J41,\"\",1)","v":2.7188995690499766E-2}]
[null,-0.64999999999999969,7.8343752466025762E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.59999999999999964,4.0250001075037289E-3,{"$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,1.7968750853469828E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Proportions upwind/downwind flight",null,null,{"$f":"'Input data'!C20","v":0.5},null,{"$f":"1-L50","v":0.5}]
[null,-0.49999999999999961,1.1499999709485564E-3,{"$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,5.7499998547427822E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.39999999999999963,5.7499998547427822E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.34999999999999964,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Compare with Q2R * p from Option 2",null,null,{"$f":"M45*bandup","v":{"$error":"#VALUE!"}},null,{"$f":"M45*banddown","v":{"$error":"#VALUE!"}}]
[null,-0.29999999999999966,0,{"$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,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.19999999999999968,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-0.14999999999999969,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-9.9999999999999686E-2,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,-4.9999999999999684E-2,5.7499998547427822E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,3.1918911957973251E-16,5.7499998547427822E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,5.0000000000000322E-2,1.3656250439453288E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.10000000000000032,2.2999999418971129E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.15000000000000033,3.5218750417698175E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.20000000000000034,5.7499998547427822E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.25000000000000033,9.0562503464752808E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.30000000000000032,1.1931249646295328E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.35000000000000031,1.2650000098801684E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.4000000000000003,1.1212500030524097E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.45000000000000029,7.6187502781976946E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.50000000000000033,4.8874999811232556E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.55000000000000038,2.8031250076310243E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.60000000000000042,1.1499999709485564E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.65000000000000047,5.7499998547427822E-4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.70000000000000051,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.75000000000000056,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.8000000000000006,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.85000000000000064,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.90000000000000069,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0.95000000000000073,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,1.0000000000000007,0,{"$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]
[3,7.3349999999999999E-2,null,7.3349999999999999E-2,null,6.5259999999999999E-2,null,5.4199999999999998E-2,null,0.03]
[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]
[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]
[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":"Daylight and night hours","index":5,"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'!C25","v":55.8},"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.0965417263055137},"2009-01-01",null,"Jan","Feb","March","April","May","June","July","August","Sept","Oct","Nov","Dec"]
[{"$f":"A9+1","v":2},-0.4012979990256228,7.1195989754023934,{"$f":"D9+1","v":"2009-01-02"},null,{"$f":"SUM(C9:C39)","v":238.78888198261959},{"$f":"SUM(C40:C67)","v":267.45031393014273},{"$f":"SUM(C68:C98)","v":365.61770672963922},{"$f":"SUM(C99:C128)","v":424.04227433468935},{"$f":"SUM(C129:C159)","v":503.61114467295624},{"$f":"SUM(C160:C189)","v":523.48372937097724},{"$f":"SUM(C190:C220)","v":524.89172337782463},{"$f":"SUM(C221:C251)","v":467.39166898582283},{"$f":"SUM(C252:C281)","v":384.55261523808144},{"$f":"SUM(C282:C312)","v":325.48317795403966},{"$f":"SUM(C313:C342)","v":250.82142903002887},{"$f":"SUM(C343:C373)","v":220.79045233583778}]
[3,-0.39976204406913618,7.1447576244737512,"2009-01-03"]
[4,-0.39809353943540499,7.1719822258401251,"2009-01-04"]
[5,-0.39629330457846768,7.2012349925137116,"2009-01-05",null,"Monthly available nocturnal hours"]
[6,-0.39436222344644489,7.232475990302202,"2009-01-06",null,{"$f":"F18-F10","v":505.21111801738039},404.54968606985727,378.38229327036078,295.95772566531065,240.38885532704376,196.51627062902276,219.10827662217537,276.60833101417717,335.44738476191856,418.51682204596034,469.17857096997113,523.20954766416219]
[7,-0.39230124306200953,7.2656633347553878,"2009-01-07"]
[8,-0.39011137201880836,7.3007533910629299,"2009-01-08"]
[9,-0.38779367890004862,7.3377009750880049,"2009-01-09",null,"Monthly available total hours"]
[10,-0.38534929062564854,7.3764595538219417,"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.4169814436644863,"2009-01-11"]
[12,-0.38008521760868019,7.4592180050698609,"2009-01-12"]
[13,-0.3772680626458555,7.5031198322451793,"2009-01-13",null,null,null,"these data are copied automatically to the 'overall collision risk' sheet"]
[14,-0.37432926838749264,7.5486369367415413,"2009-01-14"]
[15,-0.37127022660879272,7.5957189239355891,"2009-01-15"]
[16,-0.36809237637756381,7.64431516155663,"2009-01-16"]
[17,-0.36479720208847966,7.6943749395691796,"2009-01-17"]
[18,-0.36138623147924798,7.74584762086943,"2009-01-18"]
[19,-0.35786103363502658,7.7986827823962734,"2009-01-19"]
[20,-0.35422321698724518,7.8528303463891014,"2009-01-20"]
[21,-0.35047442731277689,7.9082407016468395,"2009-01-21"]
[22,-0.34661634573917116,7.9648648147527261,"2009-01-22"]
[23,-0.34265068676140203,8.0226543313281198,"2009-01-23"]
[24,-0.33857919627531541,8.0815616674651771,"2009-01-24"]
[25,-0.33440364963266606,8.141540091563062,"2009-01-25"]
[26,-0.3301258497223431,8.2025437968555295,"2009-01-26"]
[27,-0.32574762508206528,8.2645279649701813,"2009-01-27"]
[28,-0.32127082804451779,8.3274488209016528,"2009-01-28"]
[29,-0.3166973329215822,8.3912636798134539,"2009-01-29"]
[30,-0.31202903422998757,8.4559309861070435,"2009-01-30"]
[31,-0.30726784496139742,8.5214103452126189,"2009-01-31"]
[32,-0.30241569489962233,8.5876625485651861,"2009-02-01"]
[33,-0.29747452898734572,8.6546495922322091,"2009-02-02"]
[34,-0.2924463057444362,8.7223346896569627,"2009-02-03"]
[35,-0.28733299573963289,8.7906822789745984,"2009-02-04"]
[36,-0.28213658011709092,8.8596580253475441,"2009-02-05"]
[37,-0.27685904917901016,8.9292288187529465,"2009-02-06"]
[38,-0.27150240102529655,8.9993627676388446,"2009-02-07"]
[39,-0.26606864025095711,9.0700291888475952,"2009-02-08"]
[40,-0.26055977670168745,9.1411985941856813,"2009-02-09"]
[41,-0.2549778242878894,9.2128426739984999,"2009-02-10"]
[42,-0.24932479985713865,9.2849342780877215,"2009-02-11"]
[43,-0.24360272212492995,9.3574473942874796,"2009-02-12"]
[44,-0.2378136106633385,9.4303571249943108,"2009-02-13"]
[45,-0.23195948494707166,9.5036396619246304,"2009-02-14"]
[46,-0.22604236345622544,9.5772722593529256,"2009-02-15"]
[47,-0.22006426283491887,9.6512332060636421,"2009-02-16"]
[48,-0.21402719710485135,9.7255017962303807,"2009-02-17"]
[49,-0.20793317693271399,9.8000582994172749,"2009-02-18"]
[50,-0.20178420895027552,9.8748839298797293,"2009-02-19"]
[51,-0.19558229512587941,9.9499608153246868,"2009-02-20"]
[52,-0.18932943218600487,10.025271965274614,"2009-02-21"]
[53,-0.18302761108547294,10.100801239164353,"2009-02-22"]
[54,-0.17667881652482589,10.17653331428577,"2009-02-23"]
[55,-0.17028502651334607,10.252453653682053,"2009-02-24"]
[56,-0.1638482119761564,10.328548474080918,"2009-02-25"]
[57,-0.15737033640379361,10.404804713944888,"2009-02-26"]
[58,-0.15085335554263429,10.481210001705829,"2009-02-27"]
[59,-0.14429921712452506,10.557752624241449,"2009-02-28"]
[60,-0.13770986063396565,10.634421495642151,"2009-03-01"]
[61,-0.13108721711117857,10.71120612630858,"2009-03-02"]
[62,-0.12443320898940256,10.788096592412435,"2009-03-03"]
[63,-0.11774974996475297,10.865083505746176,"2009-03-04"]
[64,-0.11103874489699148,10.942157983981071,"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.019311621346993},"2009-03-06"]
[{"$f":"A73+1","v":66},-9.7541671497316948E-2,11.096536459742461,{"$f":"D73+1","v":"2009-03-07"}]
[67,-9.0759368210158148E-2,11.17382496027839,"2009-03-08"]
[68,-8.3957048961284669E-2,11.251169975254978,"2009-03-09"]
[69,-7.713657390819266E-2,11.328564720567199,"2009-03-10"]
[70,-7.0299794335051582E-2,11.406002748530986,"2009-03-11"]
[71,-6.3448552724877982E-2,11.483477921119063,"2009-03-12"]
[72,-5.6584682850013432E-2,11.560984383592757,"2009-03-13"]
[73,-4.9710009879434795E-2,11.638516538513622,"2009-03-14"]
[74,-4.2826350501447133E-2,11.716069020116615,"2009-03-15"]
[75,-3.5935513060334934E-2,11.793636669024746,"2009-03-16"]
[76,-2.9039297705575597E-2,11.871214507283446,"2009-03-17"]
[77,-2.213949655223783E-2,11.94879771369164,"2009-03-18"]
[78,-1.5237893851218381E-2,12.026381599405235,"2009-03-19"]
[79,-8.3362661679892199E-3,12.103961583787846,"2009-03-20"]
[80,-1.4363825685515439E-3,12.18153317048278,"2009-03-21"]
[81,5.4599951886842163E-3,12.259091923679733,"2009-03-22"]
[82,1.2351112456354419E-2,12.336633444549182,"2009-03-23"]
[83,1.9235221498175616E-2,12.414153347817168,"2009-03-24"]
[84,2.6110581286776003E-2,12.491647238453103,"2009-03-25"]
[85,3.2975457300531918E-2,12.569110688443173,"2009-03-26"]
[86,3.9828121320597591E-2,12.646539213622127,"2009-03-27"]
[87,4.6666851229297958E-2,12.723928250536472,"2009-03-28"]
[88,5.3489930811048164E-2,12.801273133312641,"2009-03-29"]
[89,6.0295649556938738E-2,12.878569070504122,"2009-03-30"]
[90,6.7082302474124111E-2,12.955811121892422,"2009-03-31"]
[91,7.384818990113233E-2,13.032994175217471,"2009-04-01"]
[92,8.0591617330206269E-2,13.110112922814155,"2009-04-02"]
[93,8.7310895237778102E-2,13.187161838132861,"2009-04-03"]
[94,9.4004338924164668E-2,13.264135152123169,"2009-04-04"]
[95,0.10067026836356739,13.341026829461462,"2009-04-05"]
[96,0.10730700806544721,13.417830544604872,"2009-04-06"]
[97,0.11391288694833986,13.494539657655862,"2009-04-07"]
[98,0.12048623822716464,13.571147190023959,"2009-04-08"]
[99,0.12702539931507509,13.647645799873436,"2009-04-09"]
[100,0.13352871174088607,13.724027757348402,"2009-04-10"]
[101,0.13999452108310592,13.8002849195696,"2009-04-11"]
[102,0.14642117692158937,13.876408705400431,"2009-04-12"]
[103,0.15280703280781616,13.952390069983164,"2009-04-13"]
[104,0.15915044625478739,14.028219479050172,"2009-04-14"]
[105,0.1654497787475169,14.10388688301914,"2009-04-15"]
[106,0.17170339577507993,14.17938169088589,"2009-04-16"]
[107,0.1779096668851618,14.254692743933338,"2009-04-17"]
[108,0.18406696576203169,14.32980828928066,"2009-04-18"]
[109,0.19017367032883992,14.404715953302572,"2009-04-19"]
[110,0.1962281628751176,14.47940271495521,"2009-04-20"]
[111,0.20222883021032267,14.553854879051871,"2009-04-21"]
[112,0.20817406384425072,14.628058049539678,"2009-04-22"]
[113,0.21406226019508906,14.701997102836193,"2009-04-23"]
[114,0.21989182082585762,14.775656161293901,"2009-04-24"]
[115,0.22566115270993467,14.84901856686996,"2009-04-25"]
[116,0.23136866852632049,14.922066855088731,"2009-04-26"]
[117,0.23701278698523823,14.994782729395409,"2009-04-27"]
[118,0.24259193318461736,15.067147036010827,"2009-04-28"]
[119,0.24810453899794307,15.139139739409636,"2009-04-29"]
[120,0.25354904349388913,15.210739898557286,"2009-04-30"]
[121,0.25892389338807958,15.281925644054898,"2009-05-01"]
[122,0.26422754352725103,15.352674156355725,"2009-05-02"]
[123,0.26945845740600016,15.422961645231974,"2009-05-03"]
[124,0.27461510771622133,15.492763330686683,"2009-05-04"]
[125,0.27969597692923909,15.562053425521542,"2009-05-05"]
[126,0.28469955791054519,15.630805119788494,"2009-05-06"]
[127,0.28962435456694874,15.698990567370013,"2009-05-07"]
[128,0.29446888252583536,15.766580874950304,"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.83354609365702},"2009-05-09"]
[{"$f":"A137+1","v":130},0.30391125776035022,15.899855213670138,{"$f":"D137+1","v":"2009-05-10"}]
[131,0.30850620144733043,15.965476162111335,"2009-05-11"]
[132,0.31301507083443186,16.03037580454297,"2009-05-12"]
[133,0.31743645142872373,16.094519950420555,"2009-05-13"]
[134,0.32176894517584037,16.157873362855572,"2009-05-14"]
[135,0.32601117134541141,16.22039977305689,"2009-05-15"]
[136,0.33016176744172082,16.282061899827379,"2009-05-16"]
[137,0.33421939013812968,16.342821474498052,"2009-05-17"]
[138,0.33818271623365037,16.402639271683967,"2009-05-18"]
[139,0.3420504436299201,16.461475146243419,"2009-05-19"]
[140,0.34582129232668085,16.51928807681486,"2009-05-20"]
[141,0.34949400543373249,16.576036216292355,"2009-05-21"]
[142,0.35306735019718966,16.63167694958101,"2009-05-22"]
[143,0.35654011903774069,16.686166958946828,"2009-05-23"]
[144,0.35991113059847635,16.739462297240554,"2009-05-24"]
[145,0.36317923079973574,16.791518469231995,"2009-05-25"]
[146,0.36634329389830056,16.842290521238677,"2009-05-26"]
[147,0.36940222354815688,16.891733139170725,"2009-05-27"]
[148,0.37235495385995226,16.939800755042068,"2009-05-28"]
[149,0.37520045045617745,16.986447661915946,"2009-05-29"]
[150,0.37793771151903094,17.031628137161057,"2009-05-30"]
[151,0.3805657688278557,17.075296573793139,"2009-05-31"]
[152,0.38308368878298299,17.117407619566492,"2009-06-01"]
[153,0.38549057341278142,17.15791632336186,"2009-06-02"]
[154,0.38778556136068282,17.196778288292087,"2009-06-03"]
[155,0.38996782884894871,17.233949830817657,"2009-06-04"]
[156,0.39203659061594703,17.269388145031751,"2009-06-05"]
[157,0.3939911008237324,17.303051471141966,"2009-06-06"]
[158,0.39583065393276545,17.334899267045973,"2009-06-07"]
[159,0.39755458554066286,17.364892381774098,"2009-06-08"]
[160,0.39916227318194486,17.392993229456579,"2009-06-09"]
[161,0.4006531370858431,17.41916596237068,"2009-06-10"]
[162,0.40202664088933854,17.44337664153614,"2009-06-11"]
[163,0.40328229230272722,17.465593403260165,"2009-06-12"]
[164,0.40441964372515909,17.48578661998889,"2009-06-13"]
[165,0.40543829280774868,17.503929053802928,"2009-06-14"]
[166,0.40633788296203932,17.519996000903799,"2009-06-15"]
[167,0.40711810381178526,17.533965425476239,"2009-06-16"]
[168,0.40777869158622421,17.545818081380467,"2009-06-17"]
[169,0.4083194294532238,17.555537620228137,"2009-06-18"]
[170,0.40874014779091672,17.563110684525199,"2009-06-19"]
[171,0.40904072439666622,17.568526984722475,"2009-06-20"]
[172,0.40922108463245721,17.571779359197983,"2009-06-21"]
[173,0.40928120150604741,17.572863816400059,"2009-06-22"]
[174,0.40922109568747611,17.571779558603165,"2009-06-23"]
[175,0.40904083546077746,17.568528986963727,"2009-06-24"]
[176,0.40874053661100912,17.563117687806304,"2009-06-25"]
[177,0.40832036224696044,17.555554400314907,"2009-06-26"]
[178,0.40778052256016339,17.545850966044942,"2009-06-27"]
[179,0.40712127452107588,17.53402226090207,"2009-06-28"]
[180,0.40634292151355761,17.520086110450531,"2009-06-29"]
[181,0.40544581290899201,17.504063189609973,"2009-06-30"]
[182,0.40443034358163826,17.485976907972901,"2009-07-01"]
[183,0.40329695336701854,17.465853282121252,"2009-07-02"]
[184,0.40204612646534715,17.443720796437855,"2009-07-03"]
[185,0.40067839079220724,17.41961025399554,"2009-07-04"]
[186,0.39919431727885635,17.393554619162842,"2009-07-05"]
[187,0.39759451912470972,17.36558885359111,"2009-07-06"]
[188,0.39587965100469674,17.33574974724463,"2009-07-07"]
[189,0.39405040823432064,17.304075746105173,"2009-07-08"]
[190,0.39210752589536413,17.270606778127664,"2009-07-09"]
[191,0.39005177792528284,17.235384078947519,"2009-07-10"]
[192,0.38788397617341153,17.198450018745898,"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":17.159847931570255},"2009-07-12"]
[{"$f":"A201+1","v":194},0.38321564241146017,17.119621948287335,{"$f":"D201+1","v":"2009-07-13"}]
[195,0.38071691476463765,17.07781683421846,"2009-07-14"]
[196,0.37810973999411812,17.03447783237435,"2009-07-15"]
[197,0.37539510441509116,16.989650513073734,"2009-07-16"]
[198,0.37257402607546131,16.943380630597584,"2009-07-17"]
[199,0.36964755367026431,16.89571398740247,"2009-07-18"]
[200,0.36661676544871036,16.846696306293634,"2009-07-19"]
[201,0.36348276811694818,16.79637311084284,"2009-07-20"]
[202,0.36024669573956797,16.744789614228811,"2009-07-21"]
[203,0.35690970864277327,16.691990616580224,"2009-07-22"]
[204,0.35347299232205509,16.638020410813088,"2009-07-23"]
[205,0.34993775635709434,16.582922696876409,"2009-07-24"]
[206,0.34630523333650337,16.526740504252121,"2009-07-25"]
[207,0.34257667779489442,16.469516122497044,"2009-07-26"]
[208,0.33875336516463711,16.411291039566251,"2009-07-27"]
[209,0.33483659074452959,16.352105887617402,"2009-07-28"]
[210,0.33082766868747659,16.292000395964404,"2009-07-29"]
[211,0.3267279310091214,16.231013350825066,"2009-07-30"]
[212,0.32253872661924066,16.169182561490693,"2009-07-31"]
[213,0.31826142037756883,16.106544832535178,"2009-08-01"]
[214,0.31389739217557133,16.043135941675921,"2009-08-02"]
[215,0.3094480360455476,15.978990622898793,"2009-08-03"]
[216,0.30491475929830186,15.914142554463082,"2009-08-04"]
[217,0.3002989816904813,15.848624351409512,"2009-08-05"]
[218,0.29560213462254409,15.782467562204641,"2009-08-06"]
[219,0.29082566036818791,15.71570266916709,"2009-08-07"]
[220,0.28597101133594005,15.648359092335385,"2009-08-08"]
[221,0.2810396493634848,15.580465196452582,"2009-08-09"]
[222,0.27603304504518411,15.512048300759393,"2009-08-10"]
[223,0.27095267709313131,15.443134691304635,"2009-08-11"]
[224,0.26580003173196848,15.373749635499378,"2009-08-12"]
[225,0.26057660212759171,15.303917398658614,"2009-08-13"]
[226,0.25528388784977002,15.233661262291911,"2009-08-14"]
[227,0.24992339436860928,15.163003543921652,"2009-08-15"]
[228,0.24449663258470497,15.091965618224252,"2009-08-16"]
[229,0.23900511839274277,15.020567939306085,"2009-08-17"]
[230,0.23345037227823162,14.948830063941477,"2009-08-18"]
[231,0.22783391894698138,14.876770675615207,"2009-08-19"]
[232,0.22215728698686779,14.804407609226159,"2009-08-20"]
[233,0.21642200856137356,14.731757876322463,"2009-08-21"]
[234,0.21062961913432926,14.658837690751183,"2009-08-22"]
[235,0.20478165722523642,14.585662494617695,"2009-08-23"]
[236,0.19887966419449887,14.512246984461257,"2009-08-24"]
[237,0.19292518405785708,14.438605137563805,"2009-08-25"]
[238,0.18691976332927199,14.364750238318869,"2009-08-26"]
[239,0.18086495089148111,14.290694904596796,"2009-08-27"]
[240,0.17476229789341144,14.216451114050763,"2009-08-28"]
[241,0.16861335767361324,14.142030230316198,"2009-08-29"]
[242,0.16241968570885257,14.06744302906335,"2009-08-30"]
[243,0.15618283958698112,13.99269972386951,"2009-08-31"]
[244,0.14990437900318379,13.917809991883546,"2009-09-01"]
[245,0.14358586577869115,13.842782999261196,"2009-09-02"]
[246,0.1372288639010279,13.767627426354615,"2009-09-03"]
[247,0.13083493958486095,13.692351492644571,"2009-09-04"]
[248,0.12440566135249861,13.616962981407998,"2009-09-05"]
[249,0.11794260013308597,13.541469264117598,"2009-09-06"]
[250,0.11144732937953419,13.465877324573826,"2009-09-07"]
[251,0.10492142520221727,13.39019378277291,"2009-09-08"]
[252,9.8366466518461981E-2,13.314424918517508,"2009-09-09"]
[253,9.1784035216854076E-2,13.238576694779429,"2009-09-10"]
[254,8.5175716335381596E-2,13.162654780826204,"2009-09-11"]
[255,7.8543098252427196E-2,13.086664575125628,"2009-09-12"]
[256,7.1887772889623558E-2,13.010611228044317,"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.934499664358205},"2009-09-14"]
[{"$f":"A265+1","v":258},5.851538701945648E-2,12.858334605594493,{"$f":"D265+1","v":"2009-09-15"}]
[259,5.1801530043465584E-2,12.782120592226043,"2009-09-16"]
[260,4.5071373323155174E-2,12.705862005740435,"2009-09-17"]
[261,3.8326529884595034E-2,12.629563090607139,"2009-09-18"]
[262,3.1568617707364653E-2,12.553227976167161,"2009-09-19"]
[263,2.4799259982336799E-2,12.476860698470441,"2009-09-20"]
[264,1.8020085373216938E-2,12.40046522208698,"2009-09-21"]
[265,1.1232728280784856E-2,12.324045461918308,"2009-09-22"]
[266,4.4388291087809626E-3,12.24760530503637,"2009-09-23"]
[267,-2.3599654696410234E-3,12.171148632577312,"2009-09-24"]
[268,-9.16200224598019E-3,12.094679341717892,"2009-09-25"]
[269,-1.5965621212080523E-2,12.018201367762348,"2009-09-26"]
[270,-2.276915529856801E-2,11.941718706367654,"2009-09-27"]
[271,-2.9570930117173759E-2,11.865235435934915,"2009-09-28"]
[272,-3.6369263708101736E-2,11.788755740194469,"2009-09-29"]
[273,-4.3162466293620916E-2,11.712283931011909,"2009-09-30"]
[274,-4.9948840039085098E-2,11.635824471441683,"2009-10-01"]
[275,-5.6726678822605625E-2,11.559381999054402,"2009-10-02"]
[276,-6.3494268014627736E-2,11.482961349562961,"2009-10-03"]
[277,-7.0249884268685808E-2,11.406567580771908,"2009-10-04"]
[278,-7.6991795324642467E-2,11.33020599687298,"2009-10-05"]
[279,-8.3718259825737829E-2,11.253882173108641,"2009-10-06"]
[280,-9.0427527150810635E-2,11.177601980823709,"2009-10-07"]
[281,-9.7117837263074755E-2,11.101371612923396,"2009-10-08"]
[282,-0.10378742057686806,11.025197609753953,"2009-10-09"]
[283,-0.11043449784381584,10.949086885419828,"2009-10-10"]
[284,-0.11705728005988271,10.87304675454846,"2009-10-11"]
[285,-0.12365396839481139,10.797084959510942,"2009-10-12"]
[286,-0.13022275414547718,10.721209698103316,"2009-10-13"]
[287,-0.13676181871471219,10.6454296516896,"2009-10-14"]
[288,-0.1432693336171742,10.569754013803369,"2009-10-15"]
[289,-0.14974346051386658,10.494192519200158,"2009-10-16"]
[290,-0.15618235127692465,10.418755473347771,"2009-10-17"]
[291,-0.16258414808631289,10.343453782335905,"2009-10-18"]
[292,-0.16894698356008389,10.268298983180314,"2009-10-19"]
[293,-0.17526898091986423,10.193303274489832,"2009-10-20"]
[294,-0.18154825419324044,10.118479547457117,"2009-10-21"]
[295,-0.1877829084547176,10.043841417125757,"2009-10-22"]
[296,-0.19397104010692148,9.9694032538774948,"2009-10-23"]
[297,-0.20011073720370579,9.895180215073573,"2009-10-24"]
[298,-0.20620007981681013,9.8211882767737677,"2009-10-25"]
[299,-0.2122371404476939,9.7474442654452353,"2009-10-26"]
[300,-0.21821998448613558,9.6739658895611527,"2009-10-27"]
[301,-0.22414667071715533,9.6007717709758804,"2009-10-28"]
[302,-0.23001525187776373,9.5278814759494335,"2009-10-29"]
[303,-0.2358237752649886,9.4553155456788627,"2009-10-30"]
[304,-0.24157028339655812,9.3830955261783764,"2009-10-31"]
[305,-0.24725281472554392,9.3112439973329533,"2009-11-01"]
[306,-0.25286940441017458,9.2397846009325164,"2009-11-02"]
[307,-0.25841808513993075,9.1687420674749873,"2009-11-03"]
[308,-0.26389688801891376,9.098142241507098,"2009-11-04"]
[309,-0.2693038435073542,9.0280121052515767,"2009-11-05"]
[310,-0.27463698242198459,8.9583798002486361,"2009-11-06"]
[311,-0.27989433699584532,8.8892746467182224,"2009-11-07"]
[312,-0.28507394199791908,8.8207271603282269,"2009-11-08"]
[313,-0.29017383591281248,8.752769066032041,"2009-11-09"]
[314,-0.29519206218049482,8.6854333086176432,"2009-11-10"]
[315,-0.30012667049590064,8.6187540595895769,"2009-11-11"]
[316,-0.30497571816797076,8.552766719985204,"2009-11-12"]
[317,-0.30973727153746222,8.4875079187083298,"2009-11-13"]
[318,-0.31440940745261264,8.4230155059463101,"2009-11-14"]
[319,-0.318990214801466,8.359328541222748,"2009-11-15"]
[320,-0.32347779609939875,8.2964872756264683,"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.2345331277499625},"2009-11-17"]
[{"$f":"A329+1","v":322},-0.33216576863783853,8.1735086528673335,{"$f":"D329+1","v":"2009-11-18"}]
[323,-0.33636244806900062,8.1134575048839093,"2009-11-19"]
[324,-0.34045848135963125,8.0544243905977311,"2009-11-20"]
[325,-0.34445206476656709,7.996455015828392,"2009-11-21"]
[326,-0.34834141873848645,7.9395960229913456,"2009-11-22"]
[327,-0.35212478982334283,7.8838949197275525,"2009-11-23"]
[328,-0.35580045260819554,7.8293999982392499,"2009-11-24"]
[329,-0.3593667116871464,7.7761602450341414,"2009-11-25"]
[330,-0.36282190365277839,7.7242252408425145,"2009-11-26"]
[331,-0.36616439910618587,7.6736450505458222,"2009-11-27"]
[332,-0.36939260468039764,7.624470103041002,"2009-11-28"]
[333,-0.3725049650717121,7.5767510610626196,"2009-11-29"]
[334,-0.37549996507320677,7.5305386810947681,"2009-11-30"]
[335,-0.37837613160444422,7.485883663625863,"2009-12-01"]
[336,-0.3811320357311801,7.4428364941313383,"2009-12-02"]
[337,-0.38376629466869333,7.4014472753107015,"2009-12-03"]
[338,-0.38627757376219352,7.3617655512544928,"2009-12-04"]
[339,-0.38866458843764068,7.3238401243715714,"2009-12-05"]
[340,-0.39092610611621337,7.287718866065191,"2009-12-06"]
[341,-0.39306094808561032,7.2534485223045522,"2009-12-07"]
[342,-0.39506799132135123,7.2210745153933686,"2009-12-08"]
[343,-0.39694617025126916,7.190640743385103,"2009-12-09"]
[344,-0.3986944784564509,7.1621893787312985,"2009-12-10"]
[345,-0.40031197030199439,7.1357606678715015,"2009-12-11"]
[346,-0.40179776249110266,7.1113927335755101,"2009-12-12"]
[347,-0.40315103553623288,7.0891213819277539,"2009-12-13"]
[348,-0.40437103514126194,7.0689799158953939,"2009-12-14"]
[349,-0.40545707348891064,7.0509989574428005,"2009-12-15"]
[350,-0.40640853042799968,7.035206280142809,"2009-12-16"]
[351,-0.40722485455547314,7.021626654187564,"2009-12-17"]
[352,-0.40790556418853269,7.010281705617853,"2009-12-18"]
[353,-0.40845024822266707,7.0011897914690806,"2009-12-19"]
[354,-0.40885856687182992,6.994365892376571,"2009-12-20"]
[355,-0.40913025228752969,6.9898215239933492,"2009-12-21"]
[356,-0.40926510905411478,6.987564668354814,"2009-12-22"]
[357,-0.40926301455809427,6.9875997260797043,"2009-12-23"]
[358,-0.40912391922989649,6.9899274900317963,"2009-12-24"]
[359,-0.40884784665705043,6.9945451407868084,"2009-12-25"]
[360,-0.40843489356836254,7.0014462639613626,"2009-12-26"]
[361,-0.40788522968924845,7.0106208891718431,"2009-12-27"]
[362,-0.40719909746897576,7.0220555501073143,"2009-12-28"]
[363,-0.40637681168115009,7.0357333649294453,"2009-12-29"]
[364,-0.40541875889935131,7.0516341359593326,"2009-12-30"]
[365,-0.40432539685038332,7.0697344673816538,"2009-12-31"]
[]
[null,null,{"$f":"SUM(C9:C373)","v":4496.9251179426565},{"$f":"SUM(C252:C373,C9:C98)","v":2053.50457720039},null,null,null,{"$f":"SUM(C99:C251)","v":2443.4205407422692}]
[null,null,"annual","winter",null,null,null,"summer"]

{"sheet":"Large array correction","index":6,"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'!C26","v":200},null,"Number of rows (optional)",null,null,null,null,null,"data from Sheet 3"]
["Rotor radius",{"$f":"'Input data'!C35","v":57.5},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'!C27","v":7.8},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.76316666666666666}]
["Collision risk from single rotor transit",{"$f":"'Single transit collision risk'!I39","v":7.5926348934317878E-2}]
["Assumed number of turbine rows",{"$f":"IF(G7=\"\",B7^0.5,G7)","v":14.142135623730951}]
[]
["Avoidance rate",{"$f":"'Input data'!C42","v":0.96},{"$f":"'Input data'!C43","v":0.98},{"$f":"'Input data'!C44","v":0.99},{"$f":"'Input data'!C45","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":5.3677838044770979E-3},{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-C14)","v":2.6838919022385489E-3},{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-D14)","v":1.3419459511192745E-3},{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-E14)","v":6.7097297555963724E-4}]
[]
["Large array correction factor",{"$f":"1-($B12-1)/(2*$B12)*B16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(B16*B16)","v":0.99750971942280797},{"$f":"1-($B12-1)/(2*$B12)*C16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(C16*C16)","v":0.9987539018342434},{"$f":"1-($B12-1)/(2*$B12)*D16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(D16*D16)","v":0.99937671144783169},{"$f":"1-($B12-1)/(2*$B12)*E16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(E16*E16)","v":0.99968829585659325}]

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