{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Collision risk","Blade profile","Daylight and night hours","Large array correction","Migrant collision risk"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":2,"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":"Collision risk","index":0,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK MODEL",null,"Required input data is in ",null,"orange","boxes"]
[null,null,"Calculated output  is in ",null,"blue","boxes"]
[null,null,null,null,"green","boxes are for information only, to show variables used at each stage"]
[]
[null,null,"Value","Units",null,null,null,null,"Value","Units",null,null,null,null,"Value","Units"]
["Bird data",null,null,null,null,"Windfarm data",null,null,null,null,null,null,"Turbine data"]
["Species name",null,"Hen harrier",null,null,null,"Site name",null,"North Sea",null,null,null,"Model",null,"3.2MW tupe"]
["Bird length","L",0.48,"m",null,null,"Latitude",null,56.5,"degrees",null,null,"Hub height",null,90,"m"]
["Wingspan","W",1.1000000000000001,"m",null,null,"No of turbines","T",46,null,null,null,"Rotor radius","R",57,"m"]
["Bird flight speed","v",8,"m s-1",null,null,"Width of windfarm","w",3,"km",null,null,"No of blades","b",3]
["Flight type, flapping or gliding",null,"flapping",null,null,null,null,null,null,null,null,null,"Rotation speed","Ω",9.8699999999999992,"rpm"]
["% of flights upwind/downwind",null,0.5,{"$f":"1-C12","v":0.5},null,null,null,null,null,null,null,null,"Max blade width","C",4.2,"m"]
["Nocturnal activity ranking 1-5",null,1,null,null,null,null,null,null,null,null,null,"Blade pitch","λ",15,"degrees"]
["Nocturnal activity factor","fnight",{"$f":"(C13-1)*0.25","v":0},null,null,null,null,null,null,null,null,null,"Risk height range",null,{"$f":"CONCATENATE(TEXT(O8-O9,\"###\"),\"-\",TEXT(O8+O9,\"###\"))","v":"33-147"},"m"]
[]
["normal approach",null,"Set to 'normal approach' to use survey data on bird density"]
[null,null,"Set to 'birds on migration' to use 'Migrant collision risk' sheet in place of Stage A "]
["Stage A",null,null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"year avge"]
["Daytime bird density","DA",null,"birds/km2",null,1.3299999999999999E-2,1.3299999999999999E-2,3.3000000000000002E-2,5.28E-2,5.28E-2,5.28E-2,5.28E-2,5.28E-2,5.28E-2,1.3299999999999999E-2,1.3299999999999999E-2,1.3299999999999999E-2,null,{"$f":"SUM(F19:Q19)/12","v":3.4691666666666669E-2}]
["Proportion at rotor risk height","Q2R",0.14499999999999999]
[{"$f":"CONCATENATE(\"At latitude \",TEXT(I8,\"##.#\"))","v":"At latitude 56.5"},null,"Daylight hours per month",null,null,{"$f":"'Daylight and night hours'!F10","v":234.68656224158207},{"$f":"'Daylight and night hours'!G10","v":265.4835125044836},{"$f":"'Daylight and night hours'!H10","v":365.39366219647764},{"$f":"'Daylight and night hours'!I10","v":425.76595658553373},{"$f":"'Daylight and night hours'!J10","v":507.53222174008533},{"$f":"'Daylight and night hours'!K10","v":528.77633108265638},{"$f":"'Daylight and night hours'!L10","v":529.65494867638438},{"$f":"'Daylight and night hours'!M10","v":470.06398872042217},{"$f":"'Daylight and night hours'!N10","v":385.16718911090283},{"$f":"'Daylight and night hours'!O10","v":324.15730576541637},{"$f":"'Daylight and night hours'!P10","v":247.5643504614134},{"$f":"'Daylight and night hours'!Q10","v":215.97738519068344},null,{"$f":"SUM(F21:Q21)","v":4500.2234142760408}]
[null,null,"Nighttime hours per month",null,null,{"$f":"'Daylight and night hours'!F14","v":509.31343775841793},{"$f":"'Daylight and night hours'!G14","v":406.5164874955164},{"$f":"'Daylight and night hours'!H14","v":378.60633780352236},{"$f":"'Daylight and night hours'!I14","v":294.23404341446627},{"$f":"'Daylight and night hours'!J14","v":236.46777825991467},{"$f":"'Daylight and night hours'!K14","v":191.22366891734362},{"$f":"'Daylight and night hours'!L14","v":214.34505132361562},{"$f":"'Daylight and night hours'!M14","v":273.93601127957783},{"$f":"'Daylight and night hours'!N14","v":334.83281088909717},{"$f":"'Daylight and night hours'!O14","v":419.84269423458363},{"$f":"'Daylight and night hours'!P14","v":472.43564953858663},{"$f":"'Daylight and night hours'!Q14","v":528.02261480931656},null,{"$f":"SUM(F22:Q22)","v":4259.7765857239592}]
["Stage B"]
["No of turbines","T",{"$f":"I9","v":46}]
["Rotor radius","R",{"$f":"O9","v":57},"m"]
[null,null,"Total rotor frontal area m2",null,{"$f":"C24*PI()*C25*C25","v":469523.58844960894}]
["Nocturnal activity factor","fnight",{"$f":"C14","v":0}]
["Bird flight speed","v",{"$f":"C10","v":8},"m s-1",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"year total"]
[null,null,"Projected number of rotor transits",null,null,{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!F14,($C28*F19/(2*$C25))*$E26*(F21+$C27*F22)*$C20*3600/1000000)","v":53.684995208418556},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!G14,($C28*G19/(2*$C25))*$E26*(G21+$C27*G22)*$C20*3600/1000000)","v":60.729855857899892},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!H14,($C28*H19/(2*$C25))*$E26*(H21+$C27*H22)*$C20*3600/1000000)","v":207.39009208670058},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!I14,($C28*I19/(2*$C25))*$E26*(I21+$C27*I22)*$C20*3600/1000000)","v":386.64990700873608},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!J14,($C28*J19/(2*$C25))*$E26*(J21+$C27*J22)*$C20*3600/1000000)","v":460.90412656165097},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!K14,($C28*K19/(2*$C25))*$E26*(K21+$C27*K22)*$C20*3600/1000000)","v":480.19649311829551},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!L14,($C28*L19/(2*$C25))*$E26*(L21+$C27*L22)*$C20*3600/1000000)","v":480.99439019216106},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!M14,($C28*M19/(2*$C25))*$E26*(M21+$C27*M22)*$C20*3600/1000000)","v":426.87818205210203},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!N14,($C28*N19/(2*$C25))*$E26*(N21+$C27*N22)*$C20*3600/1000000)","v":349.78103709104039},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!O14,($C28*O19/(2*$C25))*$E26*(O21+$C27*O22)*$C20*3600/1000000)","v":74.151597094325965},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!P14,($C28*P19/(2*$C25))*$E26*(P21+$C27*P22)*$C20*3600/1000000)","v":56.630813632248959},{"$f":"IF($A16=\"birds on migration\",'Migrant collision risk'!Q14,($C28*Q19/(2*$C25))*$E26*(Q21+$C27*Q22)*$C20*3600/1000000)","v":49.405235554787275},null,{"$f":"SUM(F29:Q29)","v":3087.3967254583677}]
["Stage C"]
["No of blades","b",{"$f":"O10","v":3},null,null,null,"Bird length","l",{"$f":"C8","v":0.48},"m"]
["Rotation speed","Ω",{"$f":"O11","v":9.8699999999999992},"rpm",null,null,"Wingspan","w",{"$f":"C9","v":1.1000000000000001},"m"]
["Rotor radius","R",{"$f":"O9","v":57},"m",null,null,"Bird flight speed",{"$f":"B28","v":"v"},{"$f":"C10","v":8},"m s-1"]
["Max blade width","C",{"$f":"O12","v":4.2},"m",null,null,"Flight type",null,{"$f":"C11","v":"flapping"}]
["Pitch","λ",{"$f":"O13","v":15},"degrees",null,null,"% of flights upwind/downwind",null,{"$f":"C12","v":0.5},{"$f":"D12","v":0.5}]
["Blade profile",null,null,"see Blade profile sheet"]
[null,null,"Single transit risk",null,"upwind",{"$f":"pcoll_av(\"up\")","v":0.1119333878159523}]
[null,null,null,null,"downwind",{"$f":"pcoll_av(\"down\")","v":5.125817283987999E-2}]
[null,null,null,null,"weighted mean",{"$f":"I35*F37+J35*F38","v":8.1595780327916145E-2}]
["Stage D",null,null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"year avge"]
["Proportion of time operational","Qop",null,null,null,0.874,0.89300000000000002,0.874,0.84599999999999997,0.68,0.68899999999999995,0.68899999999999995,0.77300000000000002,0.85599999999999998,0.91200000000000003,0.874,0.86499999999999999,null,{"$f":"SUM(F41:Q41)/12","v":0.81875000000000009}]
[]
[null,null,null,null,null,"Collision rates before avoidance",null,null,null,null,null,null,null,null,null,null,null,null,"year total"]
[null,null,null,null,null,{"$f":"F29*F41*$F39","v":3.8285299723640014},4.4250828802889997,14.789964690185039,26.690454741175554,25.573325666945085,26.996403213467417,27.04126058214381,26.924717319626218,24.430802105540646,5.5180171738551635,4.0386101648831989,3.4870388164814292,null,{"$f":"SUM(F44:Q44)","v":193.74420732695654}]
["Stage E"]
["Allow for large array correction?",null,"No"]
["Width of windfarm","w",{"$f":"I10","v":3},"km"]
[null,null,null,"large array",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"per year"]
[null,null,null,"correction",null,"Collision rates allowing for avoidance"]
["Avoidance rates modelled",null,0.95,{"$f":"IF(C$46=\"yes\",'Large array correction'!B18,1)","v":1},null,{"$f":"$D50*F$44*(1-$C50)","v":0.19142649861820024},{"$f":"$D50*G$44*(1-$C50)","v":0.22125414401445018},0.73949823450925267,1.3345227370587789,1.2786662833472553,1.349820160673372,1.3520630291071918,1.3462358659813121,1.2215401052770334,0.27590085869275843,0.20193050824416012,0.17435194082407163,null,{"$f":"SUM(F50:Q50)","v":9.6872103663478342}]
[null,null,0.98,{"$f":"IF(C$46=\"yes\",'Large array correction'!C18,1)","v":1},null,{"$f":"$D51*F$44*(1-$C51)","v":7.6570599447280091E-2},8.8501657605780076E-2,0.29579929380370107,0.53380909482351158,0.51146651333890214,0.53992806426934881,0.54082521164287667,0.5384943463925248,0.48861604211081339,0.11036034347710337,8.0772203297664047E-2,6.9740776329628648E-2,null,3.8748841465391344]
[null,null,0.99,{"$f":"IF(C$46=\"yes\",'Large array correction'!D18,1)","v":1},null,3.8285299723640046E-2,4.4250828802890038E-2,0.14789964690185053,0.26690454741175579,0.25573325666945107,0.2699640321346744,0.27041260582143833,0.2692471731962624,0.24430802105540669,5.5180171738551685E-2,4.0386101648832023E-2,3.4870388164814324E-2,null,1.9374420732695672]
[null,null,0.995,{"$f":"IF(C$46=\"yes\",'Large array correction'!E18,1)","v":1},null,1.9142649861820023E-2,2.2125414401445019E-2,7.3949823450925267E-2,0.13345227370587789,0.12786662833472554,0.1349820160673372,0.13520630291071917,0.1346235865981312,0.12215401052770335,2.7590085869275843E-2,2.0193050824416012E-2,1.7435194082407162E-2,null,0.96872103663478359]

{"sheet":"Blade profile","index":1,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["BLADE PROFILE"]
[null,null,null,null,null,"SINGLE TRANSIT RISK AS A FUNCTION OF r/R"]
["This table lists the chord widths",null,"r/R","c/C",null,"p(r) up","p(r) down"]
["of the blade, relative to the maximum ",null,0,0.69]
["chord width, at intervals of 1/20 of its length.",null,0.05,0.73,null,{"$f":"pcoll_rav($C5,\"up\")","v":0.72938543558120728},{"$f":"pcoll_rav($C5,\"down\")","v":0.63148242235183716}]
[null,null,{"$f":"C5+0.05","v":0.1},0.79,null,{"$f":"pcoll_rav($C6,\"up\")","v":0.4135814905166626},0.30763190984725952]
["The table accompanying the guidance",null,{"$f":"C6+0.05","v":0.15000000000000002},0.88,null,{"$f":"pcoll_rav($C7,\"up\")","v":0.31980416178703308},0.20178419351577759]
["shows the blade profile for a",null,{"$f":"C7+0.05","v":0.2},0.96,null,0.27356332540512085,0.14481423795223236]
["large modern turbine ~ 3MW",null,0.25,1,null,0.23984500765800476,0.10573147982358932]
[null,null,0.3,0.98,null,0.20744036138057709,7.6009050011634827E-2]
["The figures in the c/C column",null,0.35,0.92,null,0.18062855303287506,5.7244069874286652E-2]
["may be revised to reflect the",null,0.39999999999999997,0.85,null,0.15882179141044617,4.4825252145528793E-2]
["blade shape of the turbine used",null,0.44999999999999996,0.8,null,0.14366935193538666,3.637850284576416E-2]
[null,null,0.49999999999999994,0.75,null,0.1308768093585968,3.0291669070720673E-2]
["The data must occupy cells d4:d24",null,0.54999999999999993,0.7,null,0.11980059742927551,3.3298857510089874E-2]
[null,null,0.6,0.64,null,0.10877466946840286,3.6277990788221359E-2]
[null,null,0.65,0.57999999999999996,null,9.8826058208942413E-2,3.8179781287908554E-2]
[null,null,0.70000000000000007,0.52,null,8.9723937213420868E-2,3.9235129952430725E-2]
[null,null,0.75000000000000011,0.47,null,8.2422599196434021E-2,3.9830785244703293E-2]
[null,null,0.80000000000000016,0.41,null,7.4519485235214233E-2,3.9687082171440125E-2]
[null,null,0.8500000000000002,0.37,null,6.9213524460792542E-2,3.9628487080335617E-2]
[null,null,0.90000000000000024,0.3,null,6.1054639518260956E-2,3.8399416953325272E-2]
[null,null,0.95000000000000029,0.24,null,5.4288759827613831E-2,3.7118490785360336E-2]
[null,null,1.0000000000000002,0,null,2.9610000550746918E-2,2.9610000550746918E-2]
[]
[null,null,null,null,null,{"$f":"2*(SUMPRODUCT($C5:$C23,F5:F23)+F24/2)*0.05","v":0.11193337488919497},{"$f":"2*(SUMPRODUCT($C5:$C23,G5:G23)+G24/2)*0.05","v":5.1258168518543236E-2},"Average collision risks for flight through disk"]
[null,null,null,null,null,{"$f":"'Collision risk'!C12","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":8.1595771703869099E-2}]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"pcoll_av(\"up\")","v":0.1119333878159523},{"$f":"pcoll_av(\"down\")","v":5.125817283987999E-2}]

{"sheet":"Daylight and night hours","index":2,"n_rows":376,"n_cols":17,"rows_kept":376,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK ASSESSMENT"]
["Daylight and night hours"]
[]
["Latitude = ",{"$f":"'Collision risk'!I8","v":56.5},"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":6.9402738650471285},"2009-01-01",null,"Jan","Feb","March","April","May","June","July","August","Sept","Oct","Nov","Dec"]
[{"$f":"A9+1","v":2},-0.4012979990256228,6.9643198260022956,{"$f":"D9+1","v":"2009-01-02"},null,{"$f":"SUM(C9:C39)","v":234.68656224158207},{"$f":"SUM(C40:C67)","v":265.4835125044836},{"$f":"SUM(C68:C98)","v":365.39366219647764},{"$f":"SUM(C99:C128)","v":425.76595658553373},{"$f":"SUM(C129:C159)","v":507.53222174008533},{"$f":"SUM(C160:C189)","v":528.77633108265638},{"$f":"SUM(C190:C220)","v":529.65494867638438},{"$f":"SUM(C221:C251)","v":470.06398872042217},{"$f":"SUM(C252:C281)","v":385.16718911090283},{"$f":"SUM(C282:C312)","v":324.15730576541637},{"$f":"SUM(C313:C342)","v":247.5643504614134},{"$f":"SUM(C343:C373)","v":215.97738519068344}]
[3,-0.39976204406913618,6.9905518976906009,"2009-01-03"]
[4,-0.39809353943540499,7.0189317987746591,"2009-01-04"]
[5,-0.39629330457846768,7.0494187657785403,"2009-01-05",null,"Monthly available nocturnal hours"]
[6,-0.39436222344644489,7.0819697678731686,"2009-01-06",null,{"$f":"F18-F10","v":509.31343775841793},406.5164874955164,378.60633780352236,294.23404341446627,236.46777825991467,191.22366891734362,214.34505132361562,273.93601127957783,334.83281088909717,419.84269423458363,472.43564953858663,528.02261480931656]
[7,-0.39230124306200953,7.1165397264340733,"2009-01-07"]
[8,-0.39011137201880836,7.1530817371970237,"2009-01-08"]
[9,-0.38779367890004862,7.1915472929404451,"2009-01-09",null,"Monthly available total hours"]
[10,-0.38534929062564854,7.2318865047535255,"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.2740483201010484,"2009-01-11"]
[12,-0.38008521760868019,7.3179807360647935,"2009-01-12"]
[13,-0.3772680626458555,7.3636310063214374,"2009-01-13",null,null,null,"these data are copied automatically to the 'collision risk' sheet"]
[14,-0.37432926838749264,7.4109458406034143,"2009-01-14"]
[15,-0.37127022660879272,7.4598715955780222,"2009-01-15"]
[16,-0.36809237637756381,7.5103544562664517,"2009-01-16"]
[17,-0.36479720208847966,7.562340607305476,"2009-01-17"]
[18,-0.36138623147924798,7.6157763935272023,"2009-01-18"]
[19,-0.35786103363502658,7.6706084694940344,"2009-01-19"]
[20,-0.35422321698724518,7.7267839377754868,"2009-01-20"]
[21,-0.35047442731277689,7.7842504758890989,"2009-01-21"]
[22,-0.34661634573917116,7.8429564519490356,"2009-01-22"]
[23,-0.34265068676140203,7.9028510291726377,"2009-01-23"]
[24,-0.33857919627531541,7.9638842594870525,"2009-01-24"]
[25,-0.33440364963266606,8.0260071665562602,"2009-01-25"]
[26,-0.3301258497223431,8.0891718186126429,"2009-01-26"]
[27,-0.32574762508206528,8.1533313915292442,"2009-01-27"]
[28,-0.32127082804451779,8.2184402226083932,"2009-01-28"]
[29,-0.3166973329215822,8.2844538555915044,"2009-01-29"]
[30,-0.31202903422998757,8.3513290774143538,"2009-01-30"]
[31,-0.30726784496139742,8.419023947242982,"2009-01-31"]
[32,-0.30241569489962233,8.4874978183288281,"2009-02-01"]
[33,-0.29747452898734572,8.5567113532187964,"2009-02-02"]
[34,-0.2924463057444362,8.6266265328475455,"2009-02-03"]
[35,-0.28733299573963289,8.6972066600264082,"2009-02-04"]
[36,-0.28213658011709092,8.7684163578269505,"2009-02-05"]
[37,-0.27685904917901016,8.8402215633375612,"2009-02-06"]
[38,-0.27150240102529655,8.9125895172500584,"2009-02-07"]
[39,-0.26606864025095711,8.9854887497099316,"2009-02-08"]
[40,-0.26055977670168745,9.058889062839631,"2009-02-09"]
[41,-0.2549778242878894,9.1327615103193693,"2009-02-10"]
[42,-0.24932479985713865,9.2070783743847322,"2009-02-11"]
[43,-0.24360272212492995,9.2818131405754087,"2009-02-12"]
[44,-0.2378136106633385,9.356940470544588,"2009-02-13"]
[45,-0.23195948494707166,9.4324361732144695,"2009-02-14"]
[46,-0.22604236345622544,9.508277174539991,"2009-02-15"]
[47,-0.22006426283491887,9.5844414861203333,"2009-02-16"]
[48,-0.21402719710485135,9.6609081728763329,"2009-02-17"]
[49,-0.20793317693271399,9.7376573199913388,"2009-02-18"]
[50,-0.20178420895027552,9.8146699992938444,"2009-02-19"]
[51,-0.19558229512587941,9.8919282352418598,"2009-02-20"]
[52,-0.18932943218600487,9.9694149706518704,"2009-02-21"]
[53,-0.18302761108547294,10.047114032299277,"2009-02-22"]
[54,-0.17667881652482589,10.125010096502177,"2009-02-23"]
[55,-0.17028502651334607,10.203088654786647,"2009-02-24"]
[56,-0.1638482119761564,10.281335979718628,"2009-02-25"]
[57,-0.15737033640379361,10.359739090975905,"2009-02-26"]
[58,-0.15085335554263429,10.438285721722581,"2009-02-27"]
[59,-0.14429921712452506,10.516964285338508,"2009-02-28"]
[60,-0.13770986063396565,10.59576384254696,"2009-03-01"]
[61,-0.13108721711117857,10.674674068975422,"2009-03-02"]
[62,-0.12443320898940256,10.753685223176738,"2009-03-03"]
[63,-0.11774974996475297,10.832788115130946,"2009-03-04"]
[64,-0.11103874489699148,10.911974075241782,"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":10.991234923836155},"2009-03-06"]
[{"$f":"A73+1","v":66},-9.7541671497316948E-2,11.070562941169811,{"$f":"D73+1","v":"2009-03-07"}]
[67,-9.0759368210158148E-2,11.149950837937659,"2009-03-08"]
[68,-8.3957048961284669E-2,11.229391726283215,"2009-03-09"]
[69,-7.713657390819266E-2,11.308879091297817,"2009-03-10"]
[70,-7.0299794335051582E-2,11.388406762997029,"2009-03-11"]
[71,-6.3448552724877982E-2,11.46796888875862,"2009-03-12"]
[72,-5.6584682850013432E-2,11.54755990620405,"2009-03-13"]
[73,-4.9710009879434795E-2,11.62717451650294,"2009-03-14"]
[74,-4.2826350501447133E-2,11.706807658078155,"2009-03-15"]
[75,-3.5935513060334934E-2,11.786454480687333,"2009-03-16"]
[76,-2.9039297705575597E-2,11.866110319855133,"2009-03-17"]
[77,-2.213949655223783E-2,11.945770671629354,"2009-03-18"]
[78,-1.5237893851218381E-2,12.025431167632846,"2009-03-19"]
[79,-8.3362661679892199E-3,12.105087550382361,"2009-03-20"]
[80,-1.4363825685515439E-3,12.184735648844736,"2009-03-21"]
[81,5.4599951886842163E-3,12.264371354200273,"2009-03-22"]
[82,1.2351112456354419E-2,12.343990595782763,"2009-03-23"]
[83,1.9235221498175616E-2,12.423589317165412,"2009-03-24"]
[84,2.6110581286776003E-2,12.503163452361713,"2009-03-25"]
[85,3.2975457300531918E-2,12.582708902110452,"2009-03-26"]
[86,3.9828121320597591E-2,12.662221510214104,"2009-03-27"]
[87,4.6666851229297958E-2,12.741697039900131,"2009-03-28"]
[88,5.3489930811048164E-2,12.821131150175232,"2009-03-29"]
[89,6.0295649556938738E-2,12.900519372142902,"2009-03-30"]
[90,6.7082302474124111E-2,12.979857085255576,"2009-03-31"]
[91,7.384818990113233E-2,13.059139493473188,"2009-04-01"]
[92,8.0591617330206269E-2,13.138361601301094,"2009-04-02"]
[93,8.7310895237778102E-2,13.217518189681268,"2009-04-03"]
[94,9.4004338924164668E-2,13.296603791711981,"2009-04-04"]
[95,0.10067026836356739,13.375612668172561,"2009-04-05"]
[96,0.10730700806544721,13.454538782831415,"2009-04-06"]
[97,0.11391288694833986,13.533375777517278,"2009-04-07"]
[98,0.12048623822716464,13.612116946935622,"2009-04-08"]
[99,0.12702539931507509,13.690755213214434,"2009-04-09"]
[100,0.13352871174088607,13.769283100165943,"2009-04-10"]
[101,0.13999452108310592,13.847692707253707,"2009-04-11"]
[102,0.14642117692158937,13.925975683257402,"2009-04-12"]
[103,0.15280703280781616,14.004123199631115,"2009-04-13"]
[104,0.15915044625478739,14.082125923554484,"2009-04-14"]
[105,0.1654497787475169,14.159973990680246,"2009-04-15"]
[106,0.17170339577507993,14.237656977586131,"2009-04-16"]
[107,0.1779096668851618,14.31516387394397,"2009-04-17"]
[108,0.18406696576203169,14.392483054424362,"2009-04-18"]
[109,0.19017367032883992,14.469602250360991,"2009-04-19"]
[110,0.1962281628751176,14.546508521205356,"2009-04-20"]
[111,0.20222883021032267,14.623188225809583,"2009-04-21"]
[112,0.20817406384425072,14.699626993582747,"2009-04-22"]
[113,0.21406226019508906,14.775809695574525,"2009-04-23"]
[114,0.21989182082585762,14.851720415549092,"2009-04-24"]
[115,0.22566115270993467,14.927342421122061,"2009-04-25"]
[116,0.23136866852632049,15.002658135043934,"2009-04-26"]
[117,0.23701278698523823,15.077649106725024,"2009-04-27"]
[118,0.24259193318461736,15.152295984109312,"2009-04-28"]
[119,0.24810453899794307,15.2265784860179,"2009-04-29"]
[120,0.25354904349388913,15.30047537509707,"2009-04-30"]
[121,0.25892389338807958,15.37396443152106,"2009-05-01"]
[122,0.26422754352725103,15.447022427615915,"2009-05-02"]
[123,0.26945845740600016,15.519625103587739,"2009-05-03"]
[124,0.27461510771622133,15.591747144556804,"2009-05-04"]
[125,0.27969597692923909,15.663362159117721,"2009-05-05"]
[126,0.28469955791054519,15.734442659665524,"2009-05-06"]
[127,0.28962435456694874,15.804960044747997,"2009-05-07"]
[128,0.29446888252583536,15.87488458372529,"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.944185404039276},"2009-05-09"]
[{"$f":"A137+1","v":130},0.30391125776035022,16.012830481416515,{"$f":"D137+1","v":"2009-05-10"}]
[131,0.30850620144733043,16.080786633350087,"2009-05-11"]
[132,0.31301507083443186,16.148019516226427,"2009-05-12"]
[133,0.31743645142872373,16.214493626483623,"2009-05-13"]
[134,0.32176894517584037,16.280172306206474,"2009-05-14"]
[135,0.32601117134541141,16.345017753580876,"2009-05-15"]
[136,0.33016176744172082,16.408991038645112,"2009-05-16"]
[137,0.33421939013812968,16.472052124787439,"2009-05-17"]
[138,0.33818271623365037,16.53415989644791,"2009-05-18"]
[139,0.3420504436299201,16.595272193486004,"2009-05-19"]
[140,0.34582129232668085,16.655345852674309,"2009-05-20"]
[141,0.34949400543373249,16.714336756770692,"2009-05-21"]
[142,0.35306735019718966,16.772199891606668,"2009-05-22"]
[143,0.35654011903774069,16.82888941160644,"2009-05-23"]
[144,0.35991113059847635,16.884358714119116,"2009-05-24"]
[145,0.36317923079973574,16.938560522904119,"2009-05-25"]
[146,0.36634329389830056,16.991446981056903,"2009-05-26"]
[147,0.36940222354815688,17.042969753596743,"2009-05-27"]
[148,0.37235495385995226,17.093080139861428,"2009-05-28"]
[149,0.37520045045617745,17.141729195763212,"2009-05-29"]
[150,0.37793771151903094,17.188867865857564,"2009-05-30"]
[151,0.3805657688278557,17.234447125060221,"2009-05-31"]
[152,0.38308368878298299,17.278418129719839,"2009-06-01"]
[153,0.38549057341278142,17.32073237761411,"2009-06-02"]
[154,0.38778556136068282,17.361341876287572,"2009-06-03"]
[155,0.38996782884894871,17.400199318991927,"2009-06-04"]
[156,0.39203659061594703,17.437258267326467,"2009-06-05"]
[157,0.3939911008237324,17.472473339510454,"2009-06-06"]
[158,0.39583065393276545,17.505800403054344,"2009-06-07"]
[159,0.39755458554066286,17.537196770436523,"2009-06-08"]
[160,0.39916227318194486,17.566621396240947,"2009-06-09"]
[161,0.4006531370858431,17.594035074073538,"2009-06-10"]
[162,0.40202664088933854,17.61940063145574,"2009-06-11"]
[163,0.40328229230272722,17.642683120797315,"2009-06-12"]
[164,0.40441964372515909,17.663850004481411,"2009-06-13"]
[165,0.40543829280774868,17.682871332057353,"2009-06-14"]
[166,0.40633788296203932,17.69971990753411,"2009-06-15"]
[167,0.40711810381178526,17.714371444802104,"2009-06-16"]
[168,0.40777869158622421,17.726804709285279,"2009-06-17"]
[169,0.4083194294532238,17.737001644039061,"2009-06-18"]
[170,0.40874014779091672,17.744947478662873,"2009-06-19"]
[171,0.40904072439666622,17.750630819585446,"2009-06-20"]
[172,0.40922108463245721,17.754043720505031,"2009-06-21"]
[173,0.40928120150604741,17.755181732019309,"2009-06-22"]
[174,0.40922109568747611,17.754043929756207,"2009-06-23"]
[175,0.40904083546077746,17.750632920610478,"2009-06-24"]
[176,0.40874053661100912,17.744954826994309,"2009-06-25"]
[177,0.40832036224696044,17.737019249316187,"2009-06-26"]
[178,0.40778052256016339,17.726839207202783,"2009-06-27"]
[179,0.40712127452107588,17.714431060266541,"2009-06-28"]
[180,0.40634292151355761,17.6998144094899,"2009-06-29"]
[181,0.40544581290899201,17.683011980539177,"2009-06-30"]
[182,0.40443034358163826,17.664049490532591,"2009-07-01"]
[183,0.40329695336701854,17.642955499962735,"2009-07-02"]
[184,0.40204612646534715,17.619761251611898,"2009-07-03"]
[185,0.40067839079220724,17.594500498397121,"2009-07-04"]
[186,0.39919431727885635,17.567209322140627,"2009-07-05"]
[187,0.39759451912470972,17.537925945281206,"2009-07-06"]
[188,0.39587965100469674,17.506690537525337,"2009-07-07"]
[189,0.39405040823432064,17.473545019386343,"2009-07-08"]
[190,0.39210752589536413,17.438532864479107,"2009-07-09"]
[191,0.39005177792528284,17.40169890233156,"2009-07-10"]
[192,0.38788397617341153,17.363089123346448,"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.322750487402537},"2009-07-12"]
[{"$f":"A201+1","v":194},0.38321564241146017,17.280730737428506,{"$f":"D201+1","v":"2009-07-13"}]
[195,0.38071691476463765,17.237078219119294,"2009-07-14"]
[196,0.37810973999411812,17.191841707798037,"2009-07-15"]
[197,0.37539510441509116,17.145070243260815,"2009-07-16"]
[198,0.37257402607546131,17.096812973279246,"2009-07-17"]
[199,0.36964755367026431,17.04711900628056,"2009-07-18"]
[200,0.36661676544871036,16.996037273578224,"2009-07-19"]
[201,0.36348276811694818,16.943616401390255,"2009-07-20"]
[202,0.36024669573956797,16.889904592758356,"2009-07-21"]
[203,0.35690970864277327,16.834949519369548,"2009-07-22"]
[204,0.35347299232205509,16.77879822318361,"2009-07-23"]
[205,0.34993775635709434,16.721497027684194,"2009-07-24"]
[206,0.34630523333650337,16.663091458498961,"2009-07-25"]
[207,0.34257667779489442,16.603626173073636,"2009-07-26"]
[208,0.33875336516463711,16.543144899035962,"2009-07-27"]
[209,0.33483659074452959,16.481690380847571,"2009-07-28"]
[210,0.33082766868747659,16.419304334313303,"2009-07-29"]
[211,0.3267279310091214,16.356027408497948,"2009-07-30"]
[212,0.32253872661924066,16.291899154588801,"2009-07-31"]
[213,0.31826142037756883,16.226958001237463,"2009-08-01"]
[214,0.31389739217557133,16.161241235915355,"2009-08-02"]
[215,0.3094480360455476,16.094784991823463,"2009-08-03"]
[216,0.30491475929830186,16.027624239907126,"2009-08-04"]
[217,0.3002989816904813,15.959792785540087,"2009-08-05"]
[218,0.29560213462254409,15.891323269458443,"2009-08-06"]
[219,0.29082566036818791,15.822247172543465,"2009-08-07"]
[220,0.28597101133594005,15.752594824072021,"2009-08-08"]
[221,0.2810396493634848,15.68239541307433,"2009-08-09"]
[222,0.27603304504518411,15.61167700246015,"2009-08-10"]
[223,0.27095267709313131,15.540466545596361,"2009-08-11"]
[224,0.26580003173196848,15.468789905040508,"2009-08-12"]
[225,0.26057660212759171,15.396671873156347,"2009-08-13"]
[226,0.25528388784977002,15.324136194358367,"2009-08-14"]
[227,0.24992339436860928,15.25120558875255,"2009-08-15"]
[228,0.24449663258470497,15.177901776960173,"2009-08-16"]
[229,0.23900511839274277,15.104245505930185,"2009-08-17"]
[230,0.23345037227823162,15.030256575563428,"2009-08-18"]
[231,0.22783391894698138,14.955953865988862,"2009-08-19"]
[232,0.22215728698686779,14.881355365347799,"2009-08-20"]
[233,0.21642200856137356,14.806478197957091,"2009-08-21"]
[234,0.21062961913432926,14.731338652736101,"2009-08-22"]
[235,0.20478165722523642,14.655952211795373,"2009-08-23"]
[236,0.19887966419449887,14.580333579096905,"2009-08-24"]
[237,0.19292518405785708,14.504496709107258,"2009-08-25"]
[238,0.18691976332927199,14.428454835374946,"2009-08-26"]
[239,0.18086495089148111,14.352220498973272,"2009-08-27"]
[240,0.17476229789341144,14.275805576758406,"2009-08-28"]
[241,0.16861335767361324,14.199221309400754,"2009-08-29"]
[242,0.16241968570885257,14.122478329154946,"2009-08-30"]
[243,0.15618283958698112,14.045586687340593,"2009-08-31"]
[244,0.14990437900318379,13.968555881512197,"2009-09-01"]
[245,0.14358586577869115,13.891394882302185,"2009-09-02"]
[246,0.1372288639010279,13.814112159926264,"2009-09-03"]
[247,0.13083493958486095,13.736715710344862,"2009-09-04"]
[248,0.12440566135249861,13.659213081078807,"2009-09-05"]
[249,0.11794260013308597,13.581611396681133,"2009-09-06"]
[250,0.11144732937953419,13.503917383870482,"2009-09-07"]
[251,0.10492142520221727,13.426137396334656,"2009-09-08"]
[252,9.8366466518461981E-2,13.34827743921581,"2009-09-09"]
[253,9.1784035216854076E-2,13.270343193291245,"2009-09-10"]
[254,8.5175716335381596E-2,13.192340038866192,"2009-09-11"]
[255,7.8543098252427196E-2,13.114273079396982,"2009-09-12"]
[256,7.1887772889623558E-2,13.036147164864891,"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.957966914922633},"2009-09-14"]
[{"$f":"A265+1","v":258},5.851538701945648E-2,12.879736741836949,{"$f":"D265+1","v":"2009-09-15"}]
[259,5.1801530043465584E-2,12.801460873252118,"2009-09-16"]
[260,4.5071373323155174E-2,12.723143374800312,"2009-09-17"]
[261,3.8326529884595034E-2,12.644788172585823,"2009-09-18"]
[262,3.1568617707364653E-2,12.566399075571089,"2009-09-19"]
[263,2.4799259982336799E-2,12.48797979789318,"2009-09-20"]
[264,1.8020085373216938E-2,12.409533981140148,"2009-09-21"]
[265,1.1232728280784856E-2,12.331065216617111,"2009-09-22"]
[266,4.4388291087809626E-3,12.25257706763248,"2009-09-23"]
[267,-2.3599654696410234E-3,12.174073091835011,"2009-09-24"]
[268,-9.16200224598019E-3,12.095556863632636,"2009-09-25"]
[269,-1.5965621212080523E-2,12.01703199672418,"2009-09-26"]
[270,-2.276915529856801E-2,11.938502166775026,"2009-09-27"]
[271,-2.9570930117173759E-2,11.859971134267814,"2009-09-28"]
[272,-3.6369263708101736E-2,11.781442767558964,"2009-09-29"]
[273,-4.3162466293620916E-2,11.702921066171573,"2009-09-30"]
[274,-4.9948840039085098E-2,11.624410184354732,"2009-10-01"]
[275,-5.6726678822605625E-2,11.545914454938769,"2009-10-02"]
[276,-6.3494268014627736E-2,11.467438413515172,"2009-10-03"]
[277,-7.0249884268685808E-2,11.388986822969049,"2009-10-04"]
[278,-7.6991795324642467E-2,11.310564698390902,"2009-10-05"]
[279,-8.3718259825737829E-2,11.232177332393288,"2009-10-06"]
[280,-9.0427527150810635E-2,11.153830320856382,"2009-10-07"]
[281,-9.7117837263074755E-2,11.075529589124793,"2009-10-08"]
[282,-0.10378742057686806,10.997281418676062,"2009-10-09"]
[283,-0.11043449784381584,10.919092474278971,"2009-10-10"]
[284,-0.11705728005988271,10.840969831657297,"2009-10-11"]
[285,-0.12365396839481139,10.762921005671762,"2009-10-12"]
[286,-0.13022275414547718,10.684953979029723,"2009-10-13"]
[287,-0.13676181871471219,10.607077231528425,"2009-10-14"]
[288,-0.1432693336171742,10.52929976983375,"2009-10-15"]
[289,-0.14974346051386658,10.451631157791658,"2009-10-16"]
[290,-0.15618235127692465,10.374081547264632,"2009-10-17"]
[291,-0.16258414808631289,10.296661709479769,"2009-10-18"]
[292,-0.16894698356008389,10.219383066868964,"2009-10-19"]
[293,-0.17526898091986423,10.142257725374828,"2009-10-20"]
[294,-0.18154825419324044,10.065298507188407,"2009-10-21"]
[295,-0.1877829084547176,9.9885189838765331,"2009-10-22"]
[296,-0.19397104010692148,9.9119335098475041,"2009-10-23"]
[297,-0.20011073720370579,9.8355572560939617,"2009-10-24"]
[298,-0.20620007981681013,9.7594062441409335,"2009-10-25"]
[299,-0.2122371404476939,9.6834973801153179,"2009-10-26"]
[300,-0.21821998448613558,9.6078484888402578,"2009-10-27"]
[301,-0.22414667071715533,9.5324783478441883,"2009-10-28"]
[302,-0.23001525187776373,9.4574067211593356,"2009-10-29"]
[303,-0.2358237752649886,9.3826543927685648,"2009-10-30"]
[304,-0.24157028339655812,9.3082431995423747,"2009-10-31"]
[305,-0.24725281472554392,9.2341960634895557,"2009-11-01"]
[306,-0.25286940441017458,9.1605370231256682,"2009-11-02"]
[307,-0.25841808513993075,9.0872912637430137,"2009-11-03"]
[308,-0.26389688801891376,9.0144851463441995,"2009-11-04"]
[309,-0.2693038435073542,8.942146234978777,"2009-11-05"]
[310,-0.27463698242198459,8.8703033221990069,"2009-11-06"]
[311,-0.27989433699584532,8.7989864523264281,"2009-11-07"]
[312,-0.28507394199791908,8.7282269421960947,"2009-11-08"]
[313,-0.29017383591281248,8.6580573990199738,"2009-11-09"]
[314,-0.29519206218049482,8.5885117349856337,"2009-11-10"]
[315,-0.30012667049590064,8.5196251781810055,"2009-11-11"]
[316,-0.30497571816797076,8.4514342794113446,"2009-11-12"]
[317,-0.30973727153746222,8.3839769144509937,"2009-11-13"]
[318,-0.31440940745261264,8.3172922812501557,"2009-11-14"]
[319,-0.318990214801466,8.2514208915971921,"2009-11-15"]
[320,-0.32347779609939875,8.1864045567196904,"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.1222863662940732},"2009-11-17"]
[{"$f":"A329+1","v":322},-0.33216576863783853,8.0591106603244054,{"$f":"D329+1","v":"2009-11-18"}]
[323,-0.33636244806900062,7.9969229933474182,"2009-11-19"]
[324,-0.34045848135963125,7.9357700904233575,"2009-11-20"]
[325,-0.34445206476656709,7.8756997943824558,"2009-11-21"]
[326,-0.34834141873848645,7.816761003815234,"2009-11-22"]
[327,-0.35212478982334283,7.7590036013232861,"2009-11-23"]
[328,-0.35580045260819554,7.7024783715859115,"2009-11-24"]
[329,-0.3593667116871464,7.647236908848825,"2009-11-25"]
[330,-0.36282190365277839,7.5933315135045554,"2009-11-26"]
[331,-0.36616439910618587,7.5408150775112937,"2009-11-27"]
[332,-0.36939260468039764,7.4897409584881771,"2009-11-28"]
[333,-0.3725049650717121,7.4401628424312065,"2009-11-29"]
[334,-0.37549996507320677,7.3921345951145163,"2009-11-30"]
[335,-0.37837613160444422,7.3457101023773141,"2009-12-01"]
[336,-0.3811320357311801,7.3009430996458065,"2009-12-02"]
[337,-0.38376629466869333,7.2578869912012784,"2009-12-03"]
[338,-0.38627757376219352,7.2165946598783073,"2009-12-04"]
[339,-0.38866458843764068,7.1771182680584253,"2009-12-05"]
[340,-0.39092610611621337,7.1395090510118067,"2009-12-06"]
[341,-0.39306094808561032,7.1038171038289022,"2009-12-07"]
[342,-0.39506799132135123,7.0700911633719166,"2009-12-08"]
[343,-0.39694617025126916,7.0383783868572323,"2009-12-09"]
[344,-0.3986944784564509,7.0087241288504956,"2009-12-10"]
[345,-0.40031197030199439,6.9811717186098505,"2009-12-11"]
[346,-0.40179776249110266,6.9557622398452139,"2009-12-12"]
[347,-0.40315103553623288,6.9325343150667251,"2009-12-13"]
[348,-0.40437103514126194,6.9115238967689585,"2009-12-14"]
[349,-0.40545707348891064,6.8927640677346567,"2009-12-15"]
[350,-0.40640853042799968,6.8762848527384683,"2009-12-16"]
[351,-0.40722485455547314,6.8621130438853406,"2009-12-17"]
[352,-0.40790556418853269,6.8502720417276173,"2009-12-18"]
[353,-0.40845024822266707,6.8407817141692568,"2009-12-19"]
[354,-0.40885856687182992,6.8336582749863197,"2009-12-20"]
[355,-0.40913025228752969,6.8289141835718219,"2009-12-21"]
[356,-0.40926510905411478,6.826558067254858,"2009-12-22"]
[357,-0.40926301455809427,6.8265946672532998,"2009-12-23"]
[358,-0.40912391922989649,6.8290248090031724,"2009-12-24"]
[359,-0.40884784665705043,6.8338453972732438,"2009-12-25"]
[360,-0.40843489356836254,6.841049436128948,"2009-12-26"]
[361,-0.40788522968924845,6.8506260734636619,"2009-12-27"]
[362,-0.40719909746897576,6.8625606694762347,"2009-12-28"]
[363,-0.40637681168115009,6.8768348881503876,"2009-12-29"]
[364,-0.40541875889935131,6.8934268104911105,"2009-12-30"]
[365,-0.40432539685038332,6.9123110680028041,"2009-12-31"]
[]
[null,null,{"$f":"SUM(C9:C373)","v":4500.2234142760371},{"$f":"SUM(C252:C373,C9:C98)","v":2038.4299674709591},null,null,null,{"$f":"SUM(C99:C251)","v":2461.7934468050803}]
[null,null,"annual","winter",null,null,null,"summer"]

{"sheet":"Large array correction","index":3,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK ASSESSMENT"]
["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 Revised Sheet",null,null,null,null,null,null,null,null,"data from Sheet 1"]
[null,null,null,null,null,null,null,null,null,"calculated fields"]
["Number of turbines",{"$f":"'Collision risk'!C24","v":46},null,"Number of rows (optional)"]
["Rotor radius",{"$f":"'Collision risk'!C25","v":57},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":"'Collision risk'!C47","v":3},null,"Number of turbines in each row",null,null,{"$f":"IF(G7=\"\",\"\",B7/G7)","v":""}]
["Average proportion of time operational",{"$f":"'Collision risk'!S41","v":0.81875000000000009}]
["Collision risk from single rotor transit",{"$f":"'Collision risk'!F39","v":8.1595780327916145E-2}]
["Assumed number of turbine rows",{"$f":"IF(G7=\"\",B7^0.5,G7)","v":6.7823299831252681}]
[]
["Avoidance rate",{"$f":"'Collision risk'!C50","v":0.95},{"$f":"'Collision risk'!C51","v":0.98},{"$f":"'Collision risk'!C52","v":0.99},{"$f":"'Collision risk'!C53","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":4.5858550888433023E-3},{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-C14)","v":1.834342035537321E-3},{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-D14)","v":9.171710177686605E-4},{"$f":"$B7*(PI()*$B8*$B8)/(2*$B8*$B9*1000)*$B11*$B10*(1-E14)","v":4.5858550888433025E-4}]
[]
["Large array correction factor",{"$f":"1-($B12-1)/(2*$B12)*B16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(B16*B16)","v":0.9980472532238871},{"$f":"1-($B12-1)/(2*$B12)*C16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(C16*C16)","v":0.99921839559855374},{"$f":"1-($B12-1)/(2*$B12)*D16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(D16*D16)","v":0.99960911351744342},{"$f":"1-($B12-1)/(2*$B12)*E16 + ($B12-1)*($B12-2)/(6*$B12*$B12)*(E16*E16)","v":0.99980453568826333}]

{"sheet":"Migrant collision risk","index":4,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["COLLISION RISK (BIRDS ON MIGRATION)"]
["This is an alternative to Stages A/B for use for migratory passage of birds",null,null,null,null,null,null,null,null,null,"imported from Collision Risk sheet"]
["To use, set button on Collision Risk sheet to 'Birds on migration'",null,null,null,null,null,null,null,null,null,"required supplementary data input for migratory birds"]
[null,null,null,null,null,null,null,null,null,null,"calculated output data copied to Collision Risk sheet"]
["Data imported from Sheet 1:"]
[null,"Species",null,{"$f":"'Collision risk'!C7","v":"Hen harrier"}]
[null,"Rotor radius",null,{"$f":"'Collision risk'!O9","v":57},"m"]
[null,"Total rotor frontal area",null,{"$f":"'Collision risk'!E26","v":469523.58844960894},"sq m"]
[]
["Migratory flight activity data:",null,null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"per annum"]
[null,"Migration passages","N",null,null,0,0,0,4000,2000,0,0,0,2000,4000,0,0,null,{"$f":"SUM(F11:Q11)","v":12000}]
[null,"Width of migration corridor","w",1,"km"]
[null,"Proportion at rotor height","Q2R-m",0.14499999999999999]
[null,"Projected number of rotor transits",null,null,null,{"$f":"(F11/($D12*1000))*$D13*$D8/(2*$D7)","v":0},{"$f":"(G11/($D12*1000))*$D13*$D8/(2*$D7)","v":0},0,2388.8042219366066,1194.4021109683033,0,0,0,1194.4021109683033,2388.8042219366066,0,0,null,{"$f":"SUM(F14:Q14)","v":7166.4126658098194}]