{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","NOTES"],"not_rendered":{"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":69,"n_cols":20,"rows_kept":69,"merged":[[0,2,0,5],[0,6,0,13],[0,14,0,17]]}
[null,null,"Step 1 - exclude features impacted by only one project",{"$nulls":3},"Step 2 - in-combination impact exceeds change in adult survival of >0.02 percentage points",{"$nulls":7},"Step 3 - existing AESI in-combination (i.e. compensation provided)",{"$nulls":3},"Final"]
["Species","SPA","Muir Mhor connectivity","Ossian connectivity","Caledonia connectivity","Step 1","Breeding population (adults)","Muir Mhor impact","Ossian impact","Caledonia impact","All others impact","Total impact","% change in adult survival","Step 2","Muir Mhor compensation","Ossian Compensation","Caledonia Compensation","Step 3","PVA run for AA?","Notes"]
["Gannet","Fair Isle","Y","Y","Y","Include",{"v":9654,"d":"9,654"},{"v":0.532,"d":"0.5"},{"v":1,"d":"1.0"},{"v":0.73,"d":"0.7"},{"v":11.34789251,"d":"11.3"},{"$f":"SUM(H3:K3)","v":{"v":13.60989251,"d":"13.6"}},{"$f":"(L3/G3)*100","v":{"v":0.14097671959809405,"d":"0.141"}},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Gannet","Flamborough and Filey Coast","Y","Y","Y","Include",{"v":30466,"d":"30,466"},{"v":1.359,"d":"1.4"},4.4,{"v":0.35,"d":"0.4"},{"v":393.0885527,"d":"393.1"},{"v":399.19755269999996,"d":"399.2"},{"v":1.3103051030657125,"d":"1.310"},"Include","N","Y","N","Exclude","N"]
["Gannet","Forth Islands","Y","Y","Y","Include",{"v":150518,"d":"150,518"},{"v":12.222,"d":"12.2"},{"v":58,"d":"58.0"},{"v":7.86,"d":"7.9"},{"v":785.6529162,"d":"785.7"},{"v":863.7349162,"d":"863.7"},{"v":0.573841611102991,"d":"0.574"},"Include","Y*","Y","Y","Exclude","N"]
["Gannet","Hermaness, Saxa Vord and Valla Field","Y","Y","Y","Include",{"v":39606,"d":"39,606"},{"v":2.188,"d":"2.2"},3.8,{"v":1.18,"d":"1.2"},{"v":68.67171424,"d":"68.7"},{"v":75.83971424,"d":"75.8"},{"v":0.19148541695702673,"d":"0.191"},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Gannet","North Rona and Sula Sgeir","Y","Y","Y","Include",{"v":18990,"d":"18,990"},{"v":0.29,"d":"0.3"},0.8,{"v":0.44,"d":"0.4"},{"v":5.201561073,"d":"5.2"},{"v":6.731561073,"d":"6.7"},{"v":0.035447925608214845,"d":"0.035"},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Gannet","Noss","Y","Y","Y","Include",{"v":24670,"d":"24,670"},{"v":1.061,"d":"1.1"},2.1,{"v":0.88,"d":"0.9"},{"v":35.83231949,"d":"35.8"},{"v":39.87331949,"d":"39.9"},{"v":0.16162675107417918,"d":"0.162"},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Gannet","St Kilda","Y","Y","N","Include",{"v":120580,"d":"120,580"},{"v":1.113,"d":"1.1"},2.6,{"v":0,"d":"0.0"},{"v":1.160345018,"d":"1.2"},{"v":4.873345018,"d":"4.9"},{"v":0.004041586513517996,"d":"0.004"},"Exclude"]
["Gannet","Sule Skerry and Sule Stack","Y","Y","Y","Include",{"v":15648,"d":"15,648"},{"v":0.396,"d":"0.4"},0.9,{"v":0.93,"d":"0.9"},{"v":32.57188747,"d":"32.6"},{"v":34.79788747,"d":"34.8"},{"v":0.22237913771728013,"d":"0.222"},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Guillemot","Buchan Ness to Collieston Coast","Y","Y","Y","Include",{"v":39440.22,"d":"39,440"},{"v":176.981,"d":"177.0"},73.7,{"v":13.31,"d":"13.3"},{"v":254.7371566,"d":"254.7"},{"v":518.7281565999999,"d":"518.7"},{"v":1.3152263263237374,"d":"1.315"},"Include","Y","Y*","N","Exclude","N","REMOVED PVA"]
["Guillemot","Calf of Eday","N","N","Y","Exclude"]
["Guillemot","Copinsay","N","N","Y","Exclude"]
["Guillemot","East Caithness Cliffs","N","N","Y","Exclude"]
["Guillemot","Fair Isle","N","N","Y","Exclude"]
["Guillemot","Farne Islands","N","Y","N","Exclude"]
["Guillemot","Forth Islands","N","Y","N","Exclude"]
["Guillemot","Fowlsheugh","N","Y","N","Exclude"]
["Guillemot","Hoy","N","N","Y","Exclude"]
["Guillemot","Marwick Head","N","N","Y","Exclude"]
["Guillemot","North Caithness Cliffs","N","N","Y","Exclude"]
["Guillemot","Rousay","N","N","Y","Exclude"]
["Guillemot","St Abb's Head to Fast Castle","N","Y","N","Exclude"]
["Guillemot","Sule Skerry and Sule Stack","N","N","Y","Exclude"]
["Guillemot","Troup, Pennan and Lion's Heads","Y","Y","Y","Include",{"v":31893.34,"d":"31,893"},107.2,54.1,{"v":34.05,"d":"34.1"},{"v":76.42970026,"d":"76.4"},{"$f":"SUM(H25:K25)","v":{"v":271.77970026,"d":"271.8"}},{"$f":"(L25/G25)*100","v":{"v":0.8521518920878152,"d":"0.852"}},"Include","N","Y","Y*","Exclude","N"]
["Guillemot","West Westray","N","N","Y","Exclude"]
["Kittiwake","Buchan Ness to Collieston Coast","Y","Y","Y","Include",{"v":22590,"d":"22,590"},{"v":11.514,"d":"11.5"},6.5,2.8,{"v":70.82076102,"d":"70.8"},{"$f":"SUM(H27:K27)","v":{"v":91.63476102000001,"d":"91.6"}},{"$f":"(L27/G27)*100","v":{"v":0.40564303240371846,"d":"0.406"}},"Include","Y","Y","Y","Exclude","N"]
["Kittiwake","Calf of Eday","N","N","Y","Exclude"]
["Kittiwake","Cape Wrath","Y","N","Y","Include",{"v":6656,"d":"6,656"},{"v":0.173,"d":"0.2"},{"v":0,"d":"0.0"},{"v":0.19,"d":"0.2"},{"v":4.410635924,"d":"4.4"},{"$f":"SUM(H29:K29)","v":{"v":4.773635924000001,"d":"4.8"}},{"$f":"(L29/G29)*100","v":{"v":0.0717192897235577,"d":"0.072"}},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Kittiwake","Copinsay","N","Y","Y","Include",592,{"v":0.047,"d":"0.0"},0.1,{"v":0.09,"d":"0.1"},{"v":3.764512527,"d":"3.8"},{"v":4.028000832,"d":"4.0"},{"$f":"(L30/G30)*100","v":{"v":0.6804055459459459,"d":"0.680"}},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Kittiwake","East Caithness Cliffs","Y","Y","Y","Include",{"v":48958,"d":"48,958"},{"v":4.259,"d":"4.3"},4.3,{"v":17.98,"d":"18.0"},{"v":210.9312681,"d":"210.9"},{"$f":"SUM(H31:K31)","v":{"v":237.4702681,"d":"237.5"}},{"$f":"(L31/G31)*100","v":{"v":0.4850489564524695,"d":"0.485"}},"Include","Y","Y","Y","Exclude","N"]
["Kittiwake","Fair Isle","N","Y","Y","Include",896,{"v":0.057,"d":"0.1"},0.1,{"v":0.04,"d":"0.0"},{"v":4.204328015,"d":"4.2"},{"v":4.390891286,"d":"4.4"},{"$f":"(L32/G32)*100","v":{"v":0.49005483102678565,"d":"0.490"}},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Kittiwake","Farne Islands","Y","Y","Y","Include",{"v":5790,"d":"5,790"},{"v":0.56,"d":"0.6"},2.1,{"v":0.09,"d":"0.1"},{"v":21.6769389,"d":"21.7"},{"$f":"SUM(H33:K33)","v":{"v":24.4269389,"d":"24.4"}},{"$f":"(L33/G33)*100","v":{"v":0.4218815008635578,"d":"0.422"}},"Include","Y","Y*","N","Exclude","N"]
["Kittiwake","Flamborough and Filey Coast","N","Y","N","Exclude"]
["Kittiwake","Forth Islands","Y","Y","Y","Include",{"v":9084,"d":"9,084"},{"v":1.061,"d":"1.1"},1.9,{"v":0.43,"d":"0.4"},{"v":45.12795682,"d":"45.1"},{"$f":"SUM(H35:K35)","v":{"v":48.51895682,"d":"48.5"}},{"$f":"(L35/G35)*100","v":{"v":0.5341144520035227,"d":"0.534"}},"Include","Y","Y","N","Exclude","N"]
["Kittiwake","Foula","N","N","Y","Exclude"]
["Kittiwake","Fowlsheugh","Y","Y","Y","Include",{"v":30966,"d":"30,966"},{"v":7.149,"d":"7.1"},9.4,{"v":2.06,"d":"2.1"},{"v":123.7432217,"d":"123.7"},{"$f":"SUM(H37:K37)","v":{"v":142.3522217,"d":"142.4"}},{"$f":"(L37/G37)*100","v":{"v":0.4597049076406381,"d":"0.460"}},"Include","Y","Y","N","Exclude","N"]
["Kittiwake","Handa","N","N","Y","Exclude"]
["Kittiwake","Hermaness, Saxa Vord and Valla Field","N","N","Y","Exclude"]
["Kittiwake","Hoy","N","N","Y","Exclude"]
["Kittiwake","Marwick Head","N","Y","Y","Include",{"v":1812,"d":"1,812"},{"v":0.106,"d":"0.1"},0.1,{"v":0.17,"d":"0.2"},{"v":3.374279512,"d":"3.4"},{"$f":"SUM(H41:K41)","v":{"v":3.750279512,"d":"3.8"}},{"$f":"(L41/G41)*100","v":{"v":0.20696906799116999,"d":"0.207"}},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Kittiwake","North Caithness Cliffs","Y","Y","Y","Include",{"v":11142,"d":"11,142"},{"v":0.87,"d":"0.9"},0.8,{"v":2.46,"d":"2.5"},{"v":57.43954847,"d":"57.4"},{"$f":"SUM(H42:K42)","v":{"v":61.56954847,"d":"61.6"}},{"$f":"(L42/G42)*100","v":{"v":0.5525897367618022,"d":"0.553"}},"Include","Y","Y","Y","Exclude","N"]
["Kittiwake","North Rona and Sula Sgeir","N","N","Y","Exclude"]
["Kittiwake","Noss","N","N","Y","Exclude"]
["Kittiwake","Rousay","N","Y","Y","Include",660,{"v":0.072,"d":"0.1"},0.1,{"v":0.09,"d":"0.1"},{"v":9.38316378,"d":"9.4"},{"v":9.723850458,"d":"9.7"},{"$f":"(L45/G45)*100","v":{"v":1.4733106754545453,"d":"1.473"}},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Kittiwake","Shiant Isles","N","N","Y","Exclude"]
["Kittiwake","St Abb's Head to Fast Castle","Y","Y","Y","Include",{"v":9158,"d":"9,158"},{"v":0.798,"d":"0.8"},2.7,{"v":0.32,"d":"0.3"},{"v":34.32677129,"d":"34.3"},{"$f":"SUM(H47:K47)","v":{"v":38.14477129,"d":"38.1"}},{"$f":"(L47/G47)*100","v":{"v":0.41651857709106793,"d":"0.417"}},"Include","N","Y","N","Exclude","N"]
["Kittiwake","Sumburgh Head","N","N","Y","Exclude"]
["Kittiwake","Troup, Pennan and Lion's Heads","Y","Y","Y","Include",{"v":21232,"d":"21,232"},{"v":5.964,"d":"6.0"},3.5,{"v":7.86,"d":"7.9"},{"v":86.64774405,"d":"86.6"},{"$f":"SUM(H49:K49)","v":{"v":103.97174405,"d":"104.0"}},{"$f":"(L49/G49)*100","v":{"v":0.4896935948097212,"d":"0.490"}},"Include","Y","Y","Y","Exclude","N"]
["Kittiwake","West Westray","Y","N","Y","Include",{"v":4838,"d":"4,838"},{"v":0.505,"d":"0.5"},{"v":0,"d":"0.0"},{"v":0.65,"d":"0.7"},{"v":54.70055311,"d":"54.7"},{"$f":"SUM(H50:K50)","v":{"v":55.85555311,"d":"55.9"}},{"$f":"(L50/G50)*100","v":{"v":1.1545174268292684,"d":"1.15"}},"Include","Y","N","N","Exclude","N"]
["Puffin","Cape Wrath","N","N","Y","Exclude"]
["Puffin","Coquet Island","Y","Y","N","Include",{"v":50058,"d":"50,058"},{"v":4.017,"d":"4.0"},{"v":5,"d":"5.0"},{"v":0,"d":"0.0"},{"v":51.978,"d":"52.0"},{"$f":"SUM(H52:K52)","v":{"v":60.995000000000005,"d":"61.0"}},{"$f":"(L52/G52)*100","v":{"v":0.12184865555955092,"d":"0.122"}},"Include","N","N","N","Include","Y","NEW PVA"]
["Puffin","Fair Isle","Y","N","Y","Include",{"v":13332,"d":"13,332"},0.7,{"v":0,"d":"0.0"},{"v":1.86,"d":"1.9"},{"v":9.53008486,"d":"9.5"},{"$f":"SUM(H53:K53)","v":{"v":12.090084860000001,"d":"12.1"}},{"$f":"(L53/G53)*100","v":{"v":0.09068470492049205,"d":"0.091"}},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Puffin","Farne Islands","Y","Y","N","Include",{"v":87504,"d":"87,504"},{"v":10.572,"d":"10.6"},12.1,{"v":0,"d":"0.0"},{"v":161.4748284,"d":"161.5"},{"$f":"SUM(H54:K54)","v":{"v":184.1468284,"d":"184.1"}},{"$f":"(L54/G54)*100","v":{"v":0.2104438978789541,"d":"0.210"}},"Include","N","N","N","Include","Y","NEW PVA"]
["Puffin","Forth Islands","Y","Y","Y","Include",{"v":90291,"d":"90,291"},{"v":11,"d":"11.0"},11.5,{"v":19.03,"d":"19.0"},{"v":344.0816555,"d":"344.1"},{"$f":"SUM(H55:K55)","v":{"v":385.6116555,"d":"385.6"}},{"$f":"(L55/G55)*100","v":{"v":0.4270765142705253,"d":"0.427"}},"Include","Y*","Y*","N","Include","Y","UPDATED PVA"]
["Puffin","Foula","N","N","Y","Exclude"]
["Puffin","Hoy","Y","N","Y","Include",722,0.1,{"v":0,"d":"0.0"},{"v":0.32,"d":"0.3"},{"v":3.076951682,"d":"3.1"},{"$f":"SUM(H57:K57)","v":{"v":3.4969516819999997,"d":"3.5"}},{"$f":"(L57/G57)*100","v":{"v":0.48434233822714673,"d":"0.484"}},"Include","N","N","N","Include","Y","UPDATED PVA"]
["Puffin","North Caithness Cliffs","Y","N","Y","Include",{"v":5438,"d":"5,438"},0.4,{"v":0,"d":"0.0"},{"v":1.66,"d":"1.7"},{"v":51.89687418,"d":"51.9"},{"$f":"SUM(H58:K58)","v":{"v":53.95687418,"d":"54.0"}},{"$f":"(L58/G58)*100","v":{"v":0.9922190912100037,"d":"0.992"}},"Include","N","N","Y*","Include","Y","UPDATED PVA"]
["Puffin","North Rona and Sula Sgeir","N","N","Y","Exclude"]
["Puffin","Noss","N","N","Y","Exclude"]
["Puffin","Sule Skerry and Sule Stack","N","N","Y","Exclude"]
["Razorbill","East Caithness Cliffs","N","N","Y","Exclude"]
["Razorbill","Fair Isle","N","N","Y","Exclude"]
["Razorbill","Forth Islands","N","Y","N","Exclude"]
["Razorbill","Fowlsheugh","Y","Y","N","Include",{"v":18844.42,"d":"18,844"},10.4,4.5,{"v":0,"d":"0.0"},{"v":94.04539195,"d":"94.0"},{"$f":"SUM(H65:K65)","v":{"v":108.94539195,"d":"108.9"}},{"$f":"(L65/G65)*100","v":{"v":0.5781307779703488,"d":"0.578"}},"Include","Y","Y","N","Exclude","N"]
["Razorbill","North Caithness Cliffs","N","N","Y","Exclude"]
["Razorbill","St Abb's Head to Fast Castle","N","Y","N","Exclude"]
["Razorbill","Troup, Pennan and Lion's Heads","Y","Y","Y","Include",{"v":6054.120000000001,"d":"6,054"},{"v":4.365,"d":"4.4"},0.9,{"v":2.99,"d":"3.0"},{"v":14.86913849,"d":"14.9"},{"$f":"SUM(H68:K68)","v":{"v":23.12413849,"d":"23.1"}},{"$f":"(L68/G68)*100","v":{"v":0.3819570555258237,"d":"0.382"}},"Include","Y","Y","N","Exclude","N"]
["Razorbill","West Westray","N","N","Y","Exclude",{"$nulls":13},"REMOVED AT STEP 1"]

{"sheet":"NOTES","index":1,"n_rows":6,"n_cols":2,"rows_kept":6}
["Number","Description"]
[1,"Filter \"Step 1\" column = \"include\""]
[2,"Filter \"Step 2\" column = \"include\""]
[3,"Filter \"Step 3\" column = \"include\""]
[4,"Y* = compensation provided without prejudice in Addtiional Information submission"]
[null,"Values in highlighted boxes have been updated for VERSION 3"]