{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["preliminaries","candidate actions","costs","participants","judgments","data entry","value judgment","ex-situ judgments","Q1","Q2","Q3","Q4","Q5","Q6","Q7","Q8","Q9","Q10","Q11","Q12","Q13","Q14","outcomes_1","outcomes_2","calc"],"not_rendered":{"charts":18,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":0,"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":"preliminaries","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Time horizon (years)",30]
[]
[null,"Briefly describe the base case for CIFF management."]
[null,"cats - status quo (i.e. attempt eradication within 4 years)\nyellow crazy ants  - status quo control effort\nforest regeneration - status quo rehabilitation plan\nstatus quo constraints on clearing of primary rainforest\nregulatory control of hunting with status quo enforcement effort\nminesite rehabilitation  - one third of sites restored (by area)"]
[]
[null,{"$f":"CONCATENATE(\"Briefly describe a scenario for factors beyond CIFF management that may affect your judgments of population change over the next \",C14,\" years.\")","v":"Briefly describe a scenario for factors beyond CIFF management that may affect your judgments of population change over the next 30 years."}]
[null,"Land use change:\n - 20 ha mining (1/3 of which will be rehabilitated at the completion of operations)\n - 50 ha new urban (any associated clearing of vegetation will be offset)\n - 50 ha new ecotourism (any associated clearing will be offset)\n - 300 ha new horticulture and aquaculture (any associated clearing of vegetation will be offset) \nThe total across the four land uses is 420 ha or 3.1% of the total 135 sq km area of the island.\n\nClimate change: 1 degree celsius warming and 10% less rainfall "]

{"sheet":"candidate actions","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Action","Description (optional)"]
[null,1,"Ex-situ","Established on Christmas Island using 20 founder individuals. The aim would be to increase the insurance population to 35 - 60 individuals within 5 years."]
[null,2,"Cat control plus","status quo + 20 % additional effort targeted to CIFF"]
[null,3,"Yellow crazy ant control plus","YCA - status quo +  additional resourcing to target baiting at CIFF roost sites"]
[null,4,"Forest regeneration plus A","an additional 1.5 ha per year, restoration with indigenous species, incl. an emphasis on indigenous food plants for CIFF"]
[null,5,"Forest regeneration plus B","an additional 7.5 ha per year, restoration with indigenous species, incl. an emphasis on indigenous food plants for CIFF"]
[null,6,"Expand conservation estate A","all high conservation value polygons identified"]
[null,7,"Expand conservation estate B"," as above plus Ethel Beach, Smith's Point, and 25% of area identified as 'rural'"]
[null,8,"Cadmium control","improved dust control prior to mined material being brought to the crusher and dryer"]
[null,9]
[null,10]
[null,11]
[null,12]

{"sheet":"costs","index":2,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Personnel costs"]
[]
[null,"Median annual salary, including on-costs ($k)",90]
[null,"Estmated cost per person-day ($k)",{"$f":"C13/230","v":0.39130434782608697}]
[]
[null,"Discount rate (optional)",0]
[]
[null,null,null,null,"UP-FRONT COSTS",null,null,null,"ANNUAL MAINTENANCE COSTS"]
[null,null,null,null,"Personnel time p.a.","Equipment p.a.",null,null,"Personnel time p.a.","Maintenance materials p.a.","TOTAL COST"]
[null,"ACTION","Start year","End year","(person days)","($k)","Start year","End year","(person days)","($k)","($k)"]
[null,{"$f":"IF('candidate actions'!C11=\"\",\"\",'candidate actions'!C11)","v":"Ex-situ"},0,5,55,180,6,30,104,75,{"$f":"IF(B21=\"\",\"\",(PV($C$16,D21,-(E21*$C$14+F21),0)-PV($C$16,(C21-1),-(E21*$C$14+F21),0))+(PV($C$16,H21,-(I21*$C$14+J21),0)-PV($C$16,(G21-1),-(I21*$C$14+J21),0)))","v":4101.521739130435}]
[null,{"$f":"IF('candidate actions'!C12=\"\",\"\",'candidate actions'!C12)","v":"Cat control plus"},0,4,120,97,5,10,5,8,{"$f":"IF(B22=\"\",\"\",(PV($C$16,D22,-(E22*$C$14+F22),0)-PV($C$16,(C22-1),-(E22*$C$14+F22),0))+(PV($C$16,H22,-(I22*$C$14+J22),0)-PV($C$16,(G22-1),-(I22*$C$14+J22),0)))","v":779.52173913043487}]
[null,{"$f":"IF('candidate actions'!C13=\"\",\"\",'candidate actions'!C13)","v":"Yellow crazy ant control plus"},null,null,null,null,0,30,38,12.2,839.15652173913043]
[null,{"$f":"IF('candidate actions'!C14=\"\",\"\",'candidate actions'!C14)","v":"Forest regeneration plus A"},null,null,null,null,0,30,144,180,7326.7826086956529]
[null,{"$f":"IF('candidate actions'!C15=\"\",\"\",'candidate actions'!C15)","v":"Forest regeneration plus B"},null,null,null,null,0,30,720,900,36633.913043478256]
[null,{"$f":"IF('candidate actions'!C16=\"\",\"\",'candidate actions'!C16)","v":"Expand conservation estate A"},null,null,null,null,0,30,200,630,21956.086956521736]
[null,{"$f":"IF('candidate actions'!C17=\"\",\"\",'candidate actions'!C17)","v":"Expand conservation estate B"},null,null,null,null,0,30,240,770,26781.304347826088]
[null,{"$f":"IF('candidate actions'!C18=\"\",\"\",'candidate actions'!C18)","v":"Cadmium control"},0,2,65,100,0,30,52,40,2247.086956521739]
[null,{"$f":"IF('candidate actions'!C19=\"\",\"\",'candidate actions'!C19)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(B29=\"\",\"\",(PV($C$16,D29,-(E29*$C$14+F29),0)-PV($C$16,(C29-1),-(E29*$C$14+F29),0))+(PV($C$16,H29,-(I29*$C$14+J29),0)-PV($C$16,(G29-1),-(I29*$C$14+J29),0)))","v":""}]
[null,{"$f":"IF('candidate actions'!C20=\"\",\"\",'candidate actions'!C20)","v":""},null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF('candidate actions'!C21=\"\",\"\",'candidate actions'!C21)","v":""},null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF('candidate actions'!C22=\"\",\"\",'candidate actions'!C22)","v":""},null,null,null,null,null,null,null,null,""]

{"sheet":"participants","index":3,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Participant","Alias","Abbreviation"]
[null,null,"Colonel Mustard","Col M"]
[null,null,"Mrs Peacock","Mrs P"]
[null,null,"Dr Black","Dr B"]
[null,null,"Reverend Green","Rev G"]
[null,null,"Miss Scarlet","Miss S"]
[null,null,"Professor Plum","Prof P"]
[null,null,"Dr Orchid","Dr O"]
[null,null,"Mrs White","Mrs W"]
[null,null,"Sargeant Gray","Sgt G"]
[null,null,"Monsieur Brunette","Mon B"]
[null,null,"Miss Peach","Miss P"]
[null,null,"Inspector Brown","Insp B"]

{"sheet":"judgments","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"lower ","best","upper","confidence (%)"]
["Q1","Under ideal conditions (e.g. prior to human occupation) what do you think is the carrying capacity of the whole island?"]
[]
["Q2",{"$f":"CONCATENATE(\"What will be the population size \", preliminaries!C14, \" years hence under the \",\"base case?\")","v":"What will be the population size 30 years hence under the base case?"}]
[]
["Q3",{"$f":"IF('candidate actions'!C11=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 1 - \",'candidate actions'!C11,\" ?\"))","v":"What will be the population size 30 years hence under Action 1 - Ex-situ ?"}]
["Q4",{"$f":"IF('candidate actions'!C12=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 2 - \",'candidate actions'!C12,\" ?\"))","v":"What will be the population size 30 years hence under Action 2 - Cat control plus ?"}]
["Q5",{"$f":"IF('candidate actions'!C13=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 3 - \",'candidate actions'!C13,\" ?\"))","v":"What will be the population size 30 years hence under Action 3 - Yellow crazy ant control plus ?"}]
["Q6",{"$f":"IF('candidate actions'!C14=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 4 - \",'candidate actions'!C14,\" ?\"))","v":"What will be the population size 30 years hence under Action 4 - Forest regeneration plus A ?"}]
["Q7",{"$f":"IF('candidate actions'!C15=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 5 - \",'candidate actions'!C15,\" ?\"))","v":"What will be the population size 30 years hence under Action 5 - Forest regeneration plus B ?"}]
["Q8",{"$f":"IF('candidate actions'!C16=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 6 - \",'candidate actions'!C16,\" ?\"))","v":"What will be the population size 30 years hence under Action 6 - Expand conservation estate A ?"}]
["Q9",{"$f":"IF('candidate actions'!C17=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 7 - \",'candidate actions'!C17,\" ?\"))","v":"What will be the population size 30 years hence under Action 7 - Expand conservation estate B ?"}]
["Q10",{"$f":"IF('candidate actions'!C18=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 8 - \",'candidate actions'!C18,\" ?\"))","v":"What will be the population size 30 years hence under Action 8 - Cadmium control ?"}]
["Q11",{"$f":"IF('candidate actions'!C19=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 9 - \",'candidate actions'!C19,\" ?\"))","v":""}]
["Q12",{"$f":"IF('candidate actions'!C20=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 10 - \",'candidate actions'!C20,\" ?\"))","v":""}]
["Q13",{"$f":"IF('candidate actions'!C21=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 11 - \",'candidate actions'!C21,\" ?\"))","v":""}]
["Q14",{"$f":"IF('candidate actions'!C22=\"\",\"\",CONCATENATE(\"What will be the population size \", preliminaries!$C$14, \" years hence under Action 12 - \",'candidate actions'!C22,\" ?\"))","v":""}]

{"sheet":"data entry","index":5,"n_rows":23,"n_cols":61,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,{"$f":"participants!D10","v":"Col M"},null,null,null,null,{"$f":"participants!D11","v":"Mrs P"},null,null,null,null,{"$f":"participants!D12","v":"Dr B"},null,null,null,null,{"$f":"participants!D13","v":"Rev G"},null,null,null,null,{"$f":"participants!D14","v":"Miss S"},null,null,null,null,{"$f":"participants!D15","v":"Prof P"},null,null,null,null,{"$f":"participants!D16","v":"Dr O"},null,null,null,null,{"$f":"participants!D17","v":"Mrs W"},null,null,null,null,{"$f":"participants!D18","v":"Sgt G"},null,null,null,null,{"$f":"participants!D19","v":"Mon B"},null,null,null,null,{"$f":"participants!D20","v":"Miss P"},null,null,null,null,{"$f":"participants!D21","v":"Insp B"}]
[null,null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)",null,"lower ","best","upper","confidence (%)"]
[{"$f":"judgments!A7","v":"Q1"},{"$f":"judgments!B7","v":"Under ideal conditions (e.g. prior to human occupation) what do you think is the carrying capacity of the whole island?"},3000,4000,5000,70,null,2000,5000,7000,80,null,4000,5500,7000,70,null,5000,5500,6000,95,null,3200,4500,5500,80,null,4000,6000,8000,70,null,2500,4000,5000,70,null,2500,3500,5500,70,null,4000,5000,6000,80,null,3600,5000,6500,80,null,3000,5000,7000,80,null,4000,5500,7500,80]
[]
[{"$f":"judgments!A9","v":"Q2"},{"$f":"judgments!B9","v":"What will be the population size 30 years hence under the base case?"},2500,3500,4500,70,null,800,3200,4800,80,null,700,2500,3500,60,null,0,3200,6000,90,null,500,2000,3000,90,null,500,2500,4000,70,null,1000,4500,5000,95,null,1000,3000,4000,70,null,500,2500,5000,80,null,2500,3800,4500,80,null,900,3846,6000,80,null,3000,3000,3500,80]
[]
[{"$f":"judgments!A11","v":"Q3"},{"$f":"judgments!B11","v":"What will be the population size 30 years hence under Action 1 - Ex-situ ?"},500,3550,5000,65,null,1000,3500,4500,70,null,1000,2500,5000,50,null,2475,3850,4702,80,null,864,3692.1600000000003,5760,75,null,3500,3700,4000,50,null,2100,3100,4100,70,null,600,2800,5000,80,null,900,3000,4000,50,null,0,2100,4000,55,null,1500,3500,5000,60,null,3000,4000,5000,65]
[{"$f":"judgments!A12","v":"Q4"},{"$f":"judgments!B12","v":"What will be the population size 30 years hence under Action 2 - Cat control plus ?"},2500,3500,4500,70,null,800,2700,4400,80,null,950,3200,4000,60,null,0,2500,4500,60,null,1000,2500,3500,65,null,1000,2750,3000,65,null,500,3550,5000,65,null,1000,3500,4500,70,null,1000,2500,5000,50,null,2475,3850,4702,80,null,864,3692.1600000000003,5760,75,null,3500,3700,4000,50]
[{"$f":"judgments!A13","v":"Q5"},{"$f":"judgments!B13","v":"What will be the population size 30 years hence under Action 3 - Yellow crazy ant control plus ?"},2050,3050,4050,70,null,500,2550,4350,80,null,910,3100,4000,60,null,0,2100,4200,60,null,800,2200,3500,60,null,1500,3000,3500,65,null,500,3650,5000,65,null,1000,3000,4500,60,null,1000,2500,5000,50,null,2250,3500,4000,80,null,756,3230.6400000000003,5040,70,null,3500,3700,4000,50]
[{"$f":"judgments!A14","v":"Q6"},{"$f":"judgments!B14","v":"What will be the population size 30 years hence under Action 4 - Forest regeneration plus A ?"},2080,3080,4080,70,null,750,2600,4600,80,null,900,3000,3500,60,null,0,2600,5000,60,null,1500,3500,4500,60,null,2000,3500,4000,65,null,600,3900,5000,70,null,1000,2500,4000,70,null,1000,2500,5000,60,null,2280,3530,4205,80,null,765,3121.8,4845,70,null,3500,3700,4000,50]
[{"$f":"judgments!A15","v":"Q7"},{"$f":"judgments!B15","v":"What will be the population size 30 years hence under Action 5 - Forest regeneration plus B ?"},2125,3125,4125,70,null,1000,3000,4800,80,null,950,3200,4000,60,null,0,3100,6000,60,null,2000,4500,5500,70,null,2500,4000,4500,65,null,750,4100,6000,70,null,1000,3000,5000,70,null,1500,3000,5000,60,null,2340,3590,4265,80,null,855,3211.8,4935,70,null,3500,3700,4000,50]
[{"$f":"judgments!A16","v":"Q8"},{"$f":"judgments!B16","v":"What will be the population size 30 years hence under Action 6 - Expand conservation estate A ?"},2200,3200,4200,70,null,1200,3300,5000,80,null,900,3400,4000,70,null,0,3500,6000,60,null,700,2500,3200,60,null,3000,4000,5000,65,null,500,3600,5000,55,null,2000,4000,5000,80,null,1500,3000,5000,70,null,2295,3570,4361,80,null,1145,3501.8,5225,70,null,3500,3700,4000,50]
[{"$f":"judgments!A17","v":"Q9"},{"$f":"judgments!B17","v":"What will be the population size 30 years hence under Action 7 - Expand conservation estate B ?"},2400,3400,4400,70,null,1500,3600,5300,80,null,1100,3700,5000,70,null,0,4000,6000,60,null,1000,3100,3600,60,null,3500,4500,6000,65,null,750,3800,5000,55,null,2000,4000,5000,80,null,1500,3000,5000,70,null,2318,3605,4403,80,null,1238.5,3595.3,5318.5,70,null,3500,3700,4000,50]
[{"$f":"judgments!A18","v":"Q10"},{"$f":"judgments!B18","v":"What will be the population size 30 years hence under Action 8 - Cadmium control ?"},2100,3100,4100,70,null,600,2800,5000,80,null,900,3000,4000,50,null,0,2100,4000,55,null,1500,3500,5000,60,null,3000,4000,5000,65,null,500,3500,5000,60,null,2000,3500,5000,75,null,1500,3000,5000,50,null,2362,3675,4489,80,null,727.2,3107.5680000000002,4848,70,null,3500,3700,4000,50]
[{"$f":"judgments!A19","v":"Q11"},{"$f":"judgments!B19","v":""}]
[{"$f":"judgments!A20","v":"Q12"},{"$f":"judgments!B20","v":""}]
[{"$f":"judgments!A21","v":"Q13"},{"$f":"judgments!B21","v":""}]
[{"$f":"judgments!A22","v":"Q14"},{"$f":"judgments!B22","v":""}]

{"sheet":"value judgment","index":6,"n_rows":134,"n_cols":6,"rows_kept":134,"cut":false,"hidden":false,"merged":[[17,1,17,5],[19,1,19,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Imagine three possible futures for Christmas Island Flying Fox at the end of \",preliminaries!C14,\" years:\")","v":"Imagine three possible futures for Christmas Island Flying Fox at the end of 30 years:"}]
[]
[null,"Future state","population size","feeling","value"]
[null,"i. Extinction",0,"terrible",0]
[null,"ii. A population size of…",600,"50/50",50]
[null,"iii. A population equivalent to the island's estimated carrying capacity",{"$f":"outcomes_1!C43","v":4875},"wonderful",100]
[]
[null,"Step 1  Assign a number in the highlighted cell C19 that leaves you with the feeling that a change from scenario i to scenario ii is just as good (but no better) as a change from scenario ii to iii."]
[]
[null,"Step 2 THEN (a) click on the 'fit curve' button, and (b) the okay button on the 'Solver Results' pop-up."]
[]
[null,"If the computer is behaving, the green cell at F50 below should be zero after Step 2.  "]
[null,"Check that the curve plotted below is a reasonable reflection of your value judgment.  If not, go back to step 1."]
[null,"Note that sometimes the computer gets stuck in the calculation it makes at step 2."]
[null,"If you think this might be happening then change the number in the blue cell D55 below with a randomly chosen number between 10 and 1000.  Then repeat step 2."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Solver"]
[null,"value","wild (%)","ρ","fit","check"]
[null,0,0,870.24238549801134,{"$f":"(1-EXP(-(C45-$C$45)/$D$45))/(1-EXP(-($C$47-$C$45)/$D$45))","v":0}]
[null,0.5,{"$f":"C15","v":600},null,{"$f":"(1-EXP(-(C46-$C$45)/$D$45))/(1-EXP(-($C$47-$C$45)/$D$45))","v":0.50000000018980251},{"$f":"ABS(B46-E46)","v":1.8980250704458967E-10}]
[null,1,{"$f":"C16","v":4875},null,{"$f":"(1-EXP(-(C47-$C$45)/$D$45))/(1-EXP(-($C$47-$C$45)/$D$45))","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"population size in the wild","value"]
[0,{"$f":"A74/60*$C$47","v":0},{"$f":"100*(1-EXP(-(B74-$C$45)/$D$45))/(1-EXP(-($C$47-$C$45)/$D$45))","v":0}]
[1,81.25,{"$f":"100*(1-EXP(-(B75-$C$45)/$D$45))/(1-EXP(-($C$47-$C$45)/$D$45))","v":8.9469056378660099}]
[2,162.5,17.096294522235105]
[3,243.75,24.519256368127444]
[4,325,31.280544036121615]
[5,406.25,37.439138392182784]
[6,487.5,43.048762816543444]
[7,568.75,48.158351849861305]
[8,650,52.812478064804459]
[9,731.25,57.051740886800097]
[10,812.5,60.913120755754491]
[11,893.74999999999989,64.430301718209478]
[12,975,67.633965264009632]
[13,1056.25,70.552057970711019]
[14,1137.5,73.210035290478842]
[15,1218.75,75.631083606104923]
[16,1300,77.836322493210233]
[17,1381.25,79.844988953030054]
[18,1462.5,81.674605222903338]
[19,1543.75,83.341131628330217]
[20,1625,84.859105809975063]
[21,1706.25,86.241769540136673]
[22,1787.4999999999998,87.501184234945839]
[23,1868.7500000000002,88.648336169940066]
[24,1950,89.693232316844586]
[25,2031.25,90.64498763757409]
[26,2112.5,91.511904596948895]
[27,2193.75,92.301545587740137]
[28,2275,93.020798899830638]
[29,2356.25,93.675938808961718]
[30,2437.5,94.272680309238993]
[31,2518.7500000000005,94.81622896684631]
[32,{"$f":"A106/60*$C$47","v":2600},95.311326329857664]
[33,2681.25,95.762291290271335]
[34,2762.5,96.173057759080521]
[35,2843.75,96.547208983031894]
[36,2925,96.888008802428416]
[37,3006.25,97.198430122647849]
[38,3087.5,97.481180847743317]
[39,3168.75,97.73872750235293]
[40,3250,97.973316747979837]
[41,3331.25,98.186994981336099]
[42,3412.5,98.381626185713102]
[43,3493.75,98.558908191101438]
[44,3574.9999999999995,98.720387484902872]
[45,3656.25,98.867472702432323]
[46,3737.5000000000005,99.001446914892597]
[47,3818.75,99.123478822013098]
[48,3900,99.234632946989791]
[49,3981.25,99.335878922660214]
[50,4062.5,99.428099949919471]
[51,4143.75,99.512100502163008]
[52,4225,99.588613342964337]
[53,4306.25,99.65830591820496]
[54,4387.5,99.721786178417517]
[55,4468.75,99.779607882131899]
[56,4550,99.832275426487229]
[57,4631.25,99.880248247248815]
[58,4712.5,99.923944826612725]
[59,4793.75,99.963746343759183]
[60,4875,100]

{"sheet":"ex-situ judgments","index":7,"n_rows":146,"n_cols":6,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Task 1 (TECHNICAL judgments): Prospects for success in captive breeding"]
[]
[null,null,null,null,"From inception of a captive breeding program, how many years later would you like to judge success?",5]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"And what do you think is the chance (%) of captive breeding success after \",F15,,\" years?\")","v":"And what do you think is the chance (%) of captive breeding success after 5 years?"},0.8]
[]
[]
[null,"Task 2 (VALUE judgment): COMBINED value of an insurance population and wild population"]
[]
[null,"The value of an insurance population held in captivity may depend on the size of the population in the wild. "]
[null,"Let's say we place a value of zero to the worst possible outcome and a value of 100 to the best possible outcome."]
[null,"Note that 100 refers to the combined value of the wild and insurance populations."]
[]
[null,"Outcome","population size in the wild","insurance population","value"]
[null,"worst",0,"no",0]
[null,"best",4875,"yes",100]
[]
[null,"Now keeping in mind a scale of 0 to 100 for these bookend  outcomes, rate the two intermediate outcomes, A and B, below:"]
[]
[null,"Outcome","population size in the wild","Insurance population","value"]
[null,"worst",{"$f":"C27","v":0},"no",0]
[null,"A",{"$f":"C28","v":4875},"no",100]
[null,"B",{"$f":"C33","v":0},"yes",20]
[null,"best",{"$f":"C34","v":4875},"yes",100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"value|insurance = no"]
[null,"marginal value function"]
[null,"value","wild (%)","ρ","fit","check"]
[null,0,0,{"$f":"'value judgment'!D45","v":870.24238549801134},{"$f":"($E$34/100)*(1-EXP(-(C73-$C$73)/$D$73))/(1-EXP(-($C$75-$C$73)/$D$73))+0","v":0},{"$f":"ABS(B73-E73)","v":0}]
[null,{"$f":"B73+(B75-B73)/2","v":0.5},{"$f":"'value judgment'!C46","v":600},null,{"$f":"($E$34/100)*(1-EXP(-(C74-$C$73)/$D$73))/(1-EXP(-($C$75-$C$73)/$D$73))+0","v":0.50000000018980251},{"$f":"ABS(B74-E74)","v":1.8980250704458967E-10}]
[null,{"$f":"(E34/100)","v":1},{"$f":"'value judgment'!C16","v":4875},null,{"$f":"($E$34/100)*(1-EXP(-(C75-$C$73)/$D$73))/(1-EXP(-($C$75-$C$73)/$D$73))+0","v":1},{"$f":"ABS(B75-E75)","v":0}]
[]
[]
[null,"value|insurance = yes"]
[null,"marginal value function"]
[null,"value","wild (%)","ρ","fit","check"]
[null,{"$f":"E35/100","v":0.2},0,{"$f":"'value judgment'!D45","v":870.24238549801134},{"$f":"(((100-$E$35)/100)*(1-EXP(-(C81-$C$81)/$D$81))/(1-EXP(-($C$83-$C$81)/$D$81))+($E$35/100))","v":0.2},{"$f":"ABS(B81-E81)","v":0}]
[null,{"$f":"B81+(B83-B81)/2","v":0.60000000000000009},{"$f":"'value judgment'!C46","v":600},null,{"$f":"(((100-$E$35)/100)*(1-EXP(-(C82-$C$81)/$D$81))/(1-EXP(-($C$83-$C$81)/$D$81))+($E$35/100))","v":0.60000000015184207},{"$f":"ABS(B82-E82)","v":1.5184198343121125E-10}]
[null,1,{"$f":"'value judgment'!C16","v":4875},null,{"$f":"(((100-$E$35)/100)*(1-EXP(-(C83-$C$81)/$D$81))/(1-EXP(-($C$83-$C$81)/$D$81))+($E$35/100))","v":1},{"$f":"ABS(B83-E83)","v":0}]
[]
[null,"population size in the wild","value|insurance = no","value|insurance = yes"]
[null,{"$f":"'value judgment'!B74","v":0},{"$f":"100*(($E$34/100)*(1-EXP(-(B86-$C$73)/$D$73))/(1-EXP(-($C$75-$C$73)/$D$73))+0)","v":0},{"$f":"100*(((100-$E$35)/100)*(1-EXP(-(B86-$C$81)/$D$81))/(1-EXP(-($C$83-$C$81)/$D$81))+($E$35/100))","v":20}]
[null,{"$f":"'value judgment'!B75","v":81.25},{"$f":"100*(($E$34/100)*(1-EXP(-(B87-$C$73)/$D$73))/(1-EXP(-($C$75-$C$73)/$D$73))+0)","v":8.9469056378660099},{"$f":"100*(((100-$E$35)/100)*(1-EXP(-(B87-$C$81)/$D$81))/(1-EXP(-($C$83-$C$81)/$D$81))+($E$35/100))","v":27.157524510292809}]
[null,{"$f":"'value judgment'!B76","v":162.5},17.096294522235105,33.677035617788086]
[null,{"$f":"'value judgment'!B77","v":243.75},24.519256368127447,{"$f":"100*(((100-$E$35)/100)*(1-EXP(-(B89-$C$81)/$D$81))/(1-EXP(-($C$83-$C$81)/$D$81))+($E$35/100))","v":39.615405094501959}]
[null,{"$f":"'value judgment'!B78","v":325},31.280544036121615,{"$f":"100*(((100-$E$35)/100)*(1-EXP(-(B90-$C$81)/$D$81))/(1-EXP(-($C$83-$C$81)/$D$81))+($E$35/100))","v":45.024435228897296}]
[null,{"$f":"'value judgment'!B79","v":406.25},37.439138392182784,49.951310713746231]
[null,{"$f":"'value judgment'!B80","v":487.5},43.048762816543444,54.439010253234763]
[null,{"$f":"'value judgment'!B81","v":568.75},48.158351849861305,58.526681479889042]
[null,{"$f":"'value judgment'!B82","v":650},52.812478064804459,62.249982451843564]
[null,{"$f":"'value judgment'!B83","v":731.25},57.051740886800097,65.641392709440069]
[null,{"$f":"'value judgment'!B84","v":812.5},60.913120755754491,68.730496604603601]
[null,{"$f":"'value judgment'!B85","v":893.74999999999989},64.430301718209478,71.544241374567591]
[null,{"$f":"'value judgment'!B86","v":975},67.633965264009632,74.107172211207711]
[null,{"$f":"'value judgment'!B87","v":1056.25},70.552057970711019,76.441646376568812]
[null,{"$f":"'value judgment'!B88","v":1137.5},73.210035290478842,78.568028232383071]
[null,{"$f":"'value judgment'!B89","v":1218.75},75.631083606104937,80.504866884883967]
[null,{"$f":"'value judgment'!B90","v":1300},77.836322493210233,82.269057994568186]
[null,{"$f":"'value judgment'!B91","v":1381.25},79.844988953030054,83.875991162424029]
[null,{"$f":"'value judgment'!B92","v":1462.5},81.674605222903352,85.339684178322671]
[null,{"$f":"'value judgment'!B93","v":1543.75},83.341131628330217,86.672905302664176]
[null,{"$f":"'value judgment'!B94","v":1625},84.859105809975048,87.887284647980053]
[null,{"$f":"'value judgment'!B95","v":1706.25},86.241769540136673,88.993415632109347]
[null,{"$f":"'value judgment'!B96","v":1787.4999999999998},87.501184234945839,90.000947387956671]
[null,{"$f":"'value judgment'!B97","v":1868.7500000000002},88.648336169940066,90.91866893595207]
[null,{"$f":"'value judgment'!B98","v":1950},89.693232316844586,91.754585853475689]
[null,{"$f":"'value judgment'!B99","v":2031.25},90.644987637574076,92.515990110059263]
[null,{"$f":"'value judgment'!B100","v":2112.5},91.511904596948895,93.209523677559119]
[null,{"$f":"'value judgment'!B101","v":2193.75},92.301545587740137,93.841236470192115]
[null,{"$f":"'value judgment'!B102","v":2275},93.020798899830638,94.416639119864513]
[null,{"$f":"'value judgment'!B103","v":2356.25},93.675938808961718,94.940751047169371]
[null,{"$f":"'value judgment'!B104","v":2437.5},94.272680309238993,95.418144247391183]
[null,{"$f":"'value judgment'!B105","v":2518.7500000000005},94.81622896684631,95.852983173477057]
[null,{"$f":"'value judgment'!B106","v":2600},95.311326329857664,96.249061063886131]
[null,{"$f":"'value judgment'!B107","v":2681.25},95.762291290271335,96.609833032217068]
[null,{"$f":"'value judgment'!B108","v":2762.5},96.173057759080521,96.93844620726442]
[null,{"$f":"'value judgment'!B109","v":2843.75},96.547208983031879,97.237767186425515]
[null,{"$f":"'value judgment'!B110","v":2925},96.888008802428416,97.510407041942742]
[null,{"$f":"'value judgment'!B111","v":3006.25},97.198430122647835,97.758744098118271]
[null,{"$f":"'value judgment'!B112","v":3087.5},97.481180847743303,97.984944678194651]
[null,{"$f":"'value judgment'!B113","v":3168.75},97.73872750235293,98.190982001882347]
[null,{"$f":"'value judgment'!B114","v":3250},97.973316747979837,98.378653398383875]
[null,{"$f":"'value judgment'!B115","v":3331.25},98.186994981336099,98.549595985068891]
[null,{"$f":"'value judgment'!B116","v":3412.5},98.381626185713088,98.705300948570482]
[null,{"$f":"'value judgment'!B117","v":3493.75},98.558908191101452,98.84712655288115]
[null,{"$f":"'value judgment'!B118","v":3574.9999999999995},98.720387484902858,98.976309987922278]
[null,{"$f":"'value judgment'!B119","v":3656.25},98.867472702432309,99.093978161945856]
[null,{"$f":"'value judgment'!B120","v":3737.5000000000005},99.001446914892597,99.201157531914077]
[null,{"$f":"'value judgment'!B121","v":3818.75},99.123478822013098,99.298783057610478]
[null,{"$f":"'value judgment'!B122","v":3900},99.234632946989791,99.387706357591838]
[null,{"$f":"'value judgment'!B123","v":3981.25},99.335878922660214,99.468703138128191]
[null,{"$f":"'value judgment'!B124","v":4062.5},99.428099949919471,99.542479959935591]
[null,{"$f":"'value judgment'!B125","v":4143.75},99.512100502163022,99.609680401730415]
[null,{"$f":"'value judgment'!B126","v":4225},99.588613342964337,99.670890674371464]
[null,{"$f":"'value judgment'!B127","v":4306.25},99.65830591820496,99.72664473456399]
[null,{"$f":"'value judgment'!B128","v":4387.5},99.721786178417531,99.777428942734019]
[null,{"$f":"'value judgment'!B129","v":4468.75},99.779607882131899,99.823686305705522]
[null,{"$f":"'value judgment'!B130","v":4550},99.832275426487229,99.865820341189789]
[null,{"$f":"'value judgment'!B131","v":4631.25},99.880248247248829,99.904198597799066]
[null,{"$f":"'value judgment'!B132","v":4712.5},99.923944826612725,99.939155861290189]
[null,{"$f":"'value judgment'!B133","v":4793.75},99.963746343759183,99.970997075007361]
[null,{"$f":"'value judgment'!B134","v":4875},100,100]

{"sheet":"Q1","index":8,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A8","v":"Q1"},{"$f":"'data entry'!B8","v":"Under ideal conditions (e.g. prior to human occupation) what do you think is the carrying capacity of the whole island?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C8=\"\",\"\",'data entry'!C8)","v":3000},{"$f":"IF('data entry'!D8=\"\",\"\",'data entry'!D8)","v":4000},{"$f":"IF('data entry'!E8=\"\",\"\",'data entry'!E8)","v":5000},{"$f":"IF('data entry'!F8=\"\",\"\",'data entry'!F8)","v":70},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":2714.2857142857142},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":5285.7142857142862},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":1285.7142857142858},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":1285.7142857142862}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H8=\"\",\"\",'data entry'!H8)","v":2000},{"$f":"IF('data entry'!I8=\"\",\"\",'data entry'!I8)","v":5000},{"$f":"IF('data entry'!J8=\"\",\"\",'data entry'!J8)","v":7000},{"$f":"IF('data entry'!K8=\"\",\"\",'data entry'!K8)","v":80},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":1625},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":7250},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":3375},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":2250}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M8=\"\",\"\",'data entry'!M8)","v":4000},{"$f":"IF('data entry'!N8=\"\",\"\",'data entry'!N8)","v":5500},{"$f":"IF('data entry'!O8=\"\",\"\",'data entry'!O8)","v":7000},{"$f":"IF('data entry'!P8=\"\",\"\",'data entry'!P8)","v":70},3571.4285714285716,7428.5714285714284,1928.5714285714284,1928.5714285714284]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R8=\"\",\"\",'data entry'!R8)","v":5000},{"$f":"IF('data entry'!S8=\"\",\"\",'data entry'!S8)","v":5500},{"$f":"IF('data entry'!T8=\"\",\"\",'data entry'!T8)","v":6000},{"$f":"IF('data entry'!U8=\"\",\"\",'data entry'!U8)","v":95},5026.3157894736842,5973.6842105263158,473.68421052631584,473.68421052631584]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W8=\"\",\"\",'data entry'!W8)","v":3200},{"$f":"IF('data entry'!X8=\"\",\"\",'data entry'!X8)","v":4500},{"$f":"IF('data entry'!Y8=\"\",\"\",'data entry'!Y8)","v":5500},{"$f":"IF('data entry'!Z8=\"\",\"\",'data entry'!Z8)","v":80},3037.5,5625,1462.5,1125]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB8=\"\",\"\",'data entry'!AB8)","v":4000},{"$f":"IF('data entry'!AC8=\"\",\"\",'data entry'!AC8)","v":6000},{"$f":"IF('data entry'!AD8=\"\",\"\",'data entry'!AD8)","v":8000},{"$f":"IF('data entry'!AE8=\"\",\"\",'data entry'!AE8)","v":70},3428.5714285714284,8571.4285714285725,2571.4285714285716,2571.4285714285725]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG8=\"\",\"\",'data entry'!AG8)","v":2500},{"$f":"IF('data entry'!AH8=\"\",\"\",'data entry'!AH8)","v":4000},{"$f":"IF('data entry'!AI8=\"\",\"\",'data entry'!AI8)","v":5000},{"$f":"IF('data entry'!AJ8=\"\",\"\",'data entry'!AJ8)","v":70},2071.4285714285716,5285.7142857142862,1928.5714285714284,1285.7142857142862]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL8=\"\",\"\",'data entry'!AL8)","v":2500},{"$f":"IF('data entry'!AM8=\"\",\"\",'data entry'!AM8)","v":3500},{"$f":"IF('data entry'!AN8=\"\",\"\",'data entry'!AN8)","v":5500},{"$f":"IF('data entry'!AO8=\"\",\"\",'data entry'!AO8)","v":70},2214.2857142857142,6071.4285714285716,1285.7142857142858,2571.4285714285716]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ8=\"\",\"\",'data entry'!AQ8)","v":4000},{"$f":"IF('data entry'!AR8=\"\",\"\",'data entry'!AR8)","v":5000},{"$f":"IF('data entry'!AS8=\"\",\"\",'data entry'!AS8)","v":6000},{"$f":"IF('data entry'!AT8=\"\",\"\",'data entry'!AT8)","v":80},3875,6125,1125,1125]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV8=\"\",\"\",'data entry'!AV8)","v":3600},{"$f":"IF('data entry'!AW8=\"\",\"\",'data entry'!AW8)","v":5000},{"$f":"IF('data entry'!AX8=\"\",\"\",'data entry'!AX8)","v":6500},{"$f":"IF('data entry'!AY8=\"\",\"\",'data entry'!AY8)","v":80},3425,6687.5,1575,1687.5]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA8=\"\",\"\",'data entry'!BA8)","v":3000},{"$f":"IF('data entry'!BB8=\"\",\"\",'data entry'!BB8)","v":5000},{"$f":"IF('data entry'!BC8=\"\",\"\",'data entry'!BC8)","v":7000},{"$f":"IF('data entry'!BD8=\"\",\"\",'data entry'!BD8)","v":80},2750,7250,2250,2250]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF8=\"\",\"\",'data entry'!BF8)","v":4000},{"$f":"IF('data entry'!BG8=\"\",\"\",'data entry'!BG8)","v":5500},{"$f":"IF('data entry'!BH8=\"\",\"\",'data entry'!BH8)","v":7500},{"$f":"IF('data entry'!BI8=\"\",\"\",'data entry'!BI8)","v":80},3812.5,7750,1687.5,2250]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":4875},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":3129.2763157894733},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":6608.6701127819542},1745.7236842105267,1733.6701127819542]

{"sheet":"Q2","index":9,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A10","v":"Q2"},{"$f":"'data entry'!B10","v":"What will be the population size 30 years hence under the base case?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C10=\"\",\"\",'data entry'!C10)","v":2500},{"$f":"IF('data entry'!D10=\"\",\"\",'data entry'!D10)","v":3500},{"$f":"IF('data entry'!E10=\"\",\"\",'data entry'!E10)","v":4500},{"$f":"IF('data entry'!F10=\"\",\"\",'data entry'!F10)","v":70},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":2214.2857142857142},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":4785.7142857142862},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":1285.7142857142858},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":1285.7142857142862}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H10=\"\",\"\",'data entry'!H10)","v":800},{"$f":"IF('data entry'!I10=\"\",\"\",'data entry'!I10)","v":3200},{"$f":"IF('data entry'!J10=\"\",\"\",'data entry'!J10)","v":4800},{"$f":"IF('data entry'!K10=\"\",\"\",'data entry'!K10)","v":80},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":500},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":5000},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":2700},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":1800}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M10=\"\",\"\",'data entry'!M10)","v":700},{"$f":"IF('data entry'!N10=\"\",\"\",'data entry'!N10)","v":2500},{"$f":"IF('data entry'!O10=\"\",\"\",'data entry'!O10)","v":3500},{"$f":"IF('data entry'!P10=\"\",\"\",'data entry'!P10)","v":60},0,4000,2500,1500]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R10=\"\",\"\",'data entry'!R10)","v":0},{"$f":"IF('data entry'!S10=\"\",\"\",'data entry'!S10)","v":3200},{"$f":"IF('data entry'!T10=\"\",\"\",'data entry'!T10)","v":6000},{"$f":"IF('data entry'!U10=\"\",\"\",'data entry'!U10)","v":90},0,6000,3200,2800]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W10=\"\",\"\",'data entry'!W10)","v":500},{"$f":"IF('data entry'!X10=\"\",\"\",'data entry'!X10)","v":2000},{"$f":"IF('data entry'!Y10=\"\",\"\",'data entry'!Y10)","v":3000},{"$f":"IF('data entry'!Z10=\"\",\"\",'data entry'!Z10)","v":90},500,3000,1500,1000]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB10=\"\",\"\",'data entry'!AB10)","v":500},{"$f":"IF('data entry'!AC10=\"\",\"\",'data entry'!AC10)","v":2500},{"$f":"IF('data entry'!AD10=\"\",\"\",'data entry'!AD10)","v":4000},{"$f":"IF('data entry'!AE10=\"\",\"\",'data entry'!AE10)","v":70},0,4428.5714285714284,2500,1928.5714285714284]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG10=\"\",\"\",'data entry'!AG10)","v":1000},{"$f":"IF('data entry'!AH10=\"\",\"\",'data entry'!AH10)","v":4500},{"$f":"IF('data entry'!AI10=\"\",\"\",'data entry'!AI10)","v":5000},{"$f":"IF('data entry'!AJ10=\"\",\"\",'data entry'!AJ10)","v":95},1184.2105263157891,4973.6842105263158,3315.7894736842109,473.68421052631584]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL10=\"\",\"\",'data entry'!AL10)","v":1000},{"$f":"IF('data entry'!AM10=\"\",\"\",'data entry'!AM10)","v":3000},{"$f":"IF('data entry'!AN10=\"\",\"\",'data entry'!AN10)","v":4000},{"$f":"IF('data entry'!AO10=\"\",\"\",'data entry'!AO10)","v":70},428.57142857142844,4285.7142857142862,2571.4285714285716,1285.7142857142862]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ10=\"\",\"\",'data entry'!AQ10)","v":500},{"$f":"IF('data entry'!AR10=\"\",\"\",'data entry'!AR10)","v":2500},{"$f":"IF('data entry'!AS10=\"\",\"\",'data entry'!AS10)","v":5000},{"$f":"IF('data entry'!AT10=\"\",\"\",'data entry'!AT10)","v":80},250,5312.5,2250,2812.5]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV10=\"\",\"\",'data entry'!AV10)","v":2500},{"$f":"IF('data entry'!AW10=\"\",\"\",'data entry'!AW10)","v":3800},{"$f":"IF('data entry'!AX10=\"\",\"\",'data entry'!AX10)","v":4500},{"$f":"IF('data entry'!AY10=\"\",\"\",'data entry'!AY10)","v":80},2337.5,4587.5,1462.5,787.5]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA10=\"\",\"\",'data entry'!BA10)","v":900},{"$f":"IF('data entry'!BB10=\"\",\"\",'data entry'!BB10)","v":3846},{"$f":"IF('data entry'!BC10=\"\",\"\",'data entry'!BC10)","v":6000},{"$f":"IF('data entry'!BD10=\"\",\"\",'data entry'!BD10)","v":80},531.74999999999955,6269.25,3314.2500000000005,2423.25]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF10=\"\",\"\",'data entry'!BF10)","v":3000},{"$f":"IF('data entry'!BG10=\"\",\"\",'data entry'!BG10)","v":3000},{"$f":"IF('data entry'!BH10=\"\",\"\",'data entry'!BH10)","v":3500},{"$f":"IF('data entry'!BI10=\"\",\"\",'data entry'!BI10)","v":80},3000,3562.5,0,562.5]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":3128.8333333333335},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":912.19313909774428},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":4683.7861842105267},2216.6401942355892,1554.9528508771932]

{"sheet":"Q3","index":10,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A12","v":"Q3"},{"$f":"'data entry'!B12","v":"What will be the population size 30 years hence under Action 1 - Ex-situ ?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C12=\"\",\"\",'data entry'!C12)","v":500},{"$f":"IF('data entry'!D12=\"\",\"\",'data entry'!D12)","v":3550},{"$f":"IF('data entry'!E12=\"\",\"\",'data entry'!E12)","v":5000},{"$f":"IF('data entry'!F12=\"\",\"\",'data entry'!F12)","v":65},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":0},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":5557.6923076923076},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":3550},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":2007.6923076923076}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H12=\"\",\"\",'data entry'!H12)","v":1000},{"$f":"IF('data entry'!I12=\"\",\"\",'data entry'!I12)","v":3500},{"$f":"IF('data entry'!J12=\"\",\"\",'data entry'!J12)","v":4500},{"$f":"IF('data entry'!K12=\"\",\"\",'data entry'!K12)","v":70},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":285.71428571428578},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":4785.7142857142862},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":3214.2857142857142},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":1285.7142857142862}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M12=\"\",\"\",'data entry'!M12)","v":1000},{"$f":"IF('data entry'!N12=\"\",\"\",'data entry'!N12)","v":2500},{"$f":"IF('data entry'!O12=\"\",\"\",'data entry'!O12)","v":5000},{"$f":"IF('data entry'!P12=\"\",\"\",'data entry'!P12)","v":50},0,7000,2500,4500]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R12=\"\",\"\",'data entry'!R12)","v":2475},{"$f":"IF('data entry'!S12=\"\",\"\",'data entry'!S12)","v":3850},{"$f":"IF('data entry'!T12=\"\",\"\",'data entry'!T12)","v":4702},{"$f":"IF('data entry'!U12=\"\",\"\",'data entry'!U12)","v":80},2303.125,4808.5,1546.875,958.5]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W12=\"\",\"\",'data entry'!W12)","v":864},{"$f":"IF('data entry'!X12=\"\",\"\",'data entry'!X12)","v":3692.1600000000003},{"$f":"IF('data entry'!Y12=\"\",\"\",'data entry'!Y12)","v":5760},{"$f":"IF('data entry'!Z12=\"\",\"\",'data entry'!Z12)","v":75},298.36799999999994,6173.5680000000002,3393.7920000000004,2481.4079999999999]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB12=\"\",\"\",'data entry'!AB12)","v":3500},{"$f":"IF('data entry'!AC12=\"\",\"\",'data entry'!AC12)","v":3700},{"$f":"IF('data entry'!AD12=\"\",\"\",'data entry'!AD12)","v":4000},{"$f":"IF('data entry'!AE12=\"\",\"\",'data entry'!AE12)","v":50},3340,4240,360,540]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG12=\"\",\"\",'data entry'!AG12)","v":2100},{"$f":"IF('data entry'!AH12=\"\",\"\",'data entry'!AH12)","v":3100},{"$f":"IF('data entry'!AI12=\"\",\"\",'data entry'!AI12)","v":4100},{"$f":"IF('data entry'!AJ12=\"\",\"\",'data entry'!AJ12)","v":70},1814.2857142857142,4385.7142857142862,1285.7142857142858,1285.7142857142862]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL12=\"\",\"\",'data entry'!AL12)","v":600},{"$f":"IF('data entry'!AM12=\"\",\"\",'data entry'!AM12)","v":2800},{"$f":"IF('data entry'!AN12=\"\",\"\",'data entry'!AN12)","v":5000},{"$f":"IF('data entry'!AO12=\"\",\"\",'data entry'!AO12)","v":80},325,5275,2475,2475]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ12=\"\",\"\",'data entry'!AQ12)","v":900},{"$f":"IF('data entry'!AR12=\"\",\"\",'data entry'!AR12)","v":3000},{"$f":"IF('data entry'!AS12=\"\",\"\",'data entry'!AS12)","v":4000},{"$f":"IF('data entry'!AT12=\"\",\"\",'data entry'!AT12)","v":50},0,4800,3000,1800]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV12=\"\",\"\",'data entry'!AV12)","v":0},{"$f":"IF('data entry'!AW12=\"\",\"\",'data entry'!AW12)","v":2100},{"$f":"IF('data entry'!AX12=\"\",\"\",'data entry'!AX12)","v":4000},{"$f":"IF('data entry'!AY12=\"\",\"\",'data entry'!AY12)","v":55},0,5209.090909090909,2100,3109.090909090909]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA12=\"\",\"\",'data entry'!BA12)","v":1500},{"$f":"IF('data entry'!BB12=\"\",\"\",'data entry'!BB12)","v":3500},{"$f":"IF('data entry'!BC12=\"\",\"\",'data entry'!BC12)","v":5000},{"$f":"IF('data entry'!BD12=\"\",\"\",'data entry'!BD12)","v":60},500,5750,3000,2250]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF12=\"\",\"\",'data entry'!BF12)","v":3000},{"$f":"IF('data entry'!BG12=\"\",\"\",'data entry'!BG12)","v":4000},{"$f":"IF('data entry'!BH12=\"\",\"\",'data entry'!BH12)","v":5000},{"$f":"IF('data entry'!BI12=\"\",\"\",'data entry'!BI12)","v":65},2615.3846153846152,5384.6153846153848,1384.6153846153848,1384.6153846153848]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":3274.3466666666668},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":956.82313461538467},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":5280.8245977355973},2317.523532051282,2006.4779310689305]

{"sheet":"Q4","index":11,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A13","v":"Q4"},{"$f":"'data entry'!B13","v":"What will be the population size 30 years hence under Action 2 - Cat control plus ?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C13=\"\",\"\",'data entry'!C13)","v":2500},{"$f":"IF('data entry'!D13=\"\",\"\",'data entry'!D13)","v":3500},{"$f":"IF('data entry'!E13=\"\",\"\",'data entry'!E13)","v":4500},{"$f":"IF('data entry'!F13=\"\",\"\",'data entry'!F13)","v":70},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":2214.2857142857142},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":4785.7142857142862},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":1285.7142857142858},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":1285.7142857142862}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H13=\"\",\"\",'data entry'!H13)","v":800},{"$f":"IF('data entry'!I13=\"\",\"\",'data entry'!I13)","v":2700},{"$f":"IF('data entry'!J13=\"\",\"\",'data entry'!J13)","v":4400},{"$f":"IF('data entry'!K13=\"\",\"\",'data entry'!K13)","v":80},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":562.5},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":4612.5},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":2137.5},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":1912.5}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M13=\"\",\"\",'data entry'!M13)","v":950},{"$f":"IF('data entry'!N13=\"\",\"\",'data entry'!N13)","v":3200},{"$f":"IF('data entry'!O13=\"\",\"\",'data entry'!O13)","v":4000},{"$f":"IF('data entry'!P13=\"\",\"\",'data entry'!P13)","v":60},0,4400,3200,1200]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R13=\"\",\"\",'data entry'!R13)","v":0},{"$f":"IF('data entry'!S13=\"\",\"\",'data entry'!S13)","v":2500},{"$f":"IF('data entry'!T13=\"\",\"\",'data entry'!T13)","v":4500},{"$f":"IF('data entry'!U13=\"\",\"\",'data entry'!U13)","v":60},0,5500,2500,3000]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W13=\"\",\"\",'data entry'!W13)","v":1000},{"$f":"IF('data entry'!X13=\"\",\"\",'data entry'!X13)","v":2500},{"$f":"IF('data entry'!Y13=\"\",\"\",'data entry'!Y13)","v":3500},{"$f":"IF('data entry'!Z13=\"\",\"\",'data entry'!Z13)","v":65},423.07692307692332,3884.6153846153848,2076.9230769230767,1384.6153846153848]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB13=\"\",\"\",'data entry'!AB13)","v":1000},{"$f":"IF('data entry'!AC13=\"\",\"\",'data entry'!AC13)","v":2750},{"$f":"IF('data entry'!AD13=\"\",\"\",'data entry'!AD13)","v":3000},{"$f":"IF('data entry'!AE13=\"\",\"\",'data entry'!AE13)","v":65},326.92307692307668,3096.1538461538462,2423.0769230769233,346.15384615384619]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG13=\"\",\"\",'data entry'!AG13)","v":500},{"$f":"IF('data entry'!AH13=\"\",\"\",'data entry'!AH13)","v":3550},{"$f":"IF('data entry'!AI13=\"\",\"\",'data entry'!AI13)","v":5000},{"$f":"IF('data entry'!AJ13=\"\",\"\",'data entry'!AJ13)","v":65},0,5557.6923076923076,3550,2007.6923076923076]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL13=\"\",\"\",'data entry'!AL13)","v":1000},{"$f":"IF('data entry'!AM13=\"\",\"\",'data entry'!AM13)","v":3500},{"$f":"IF('data entry'!AN13=\"\",\"\",'data entry'!AN13)","v":4500},{"$f":"IF('data entry'!AO13=\"\",\"\",'data entry'!AO13)","v":70},285.71428571428578,4785.7142857142862,3214.2857142857142,1285.7142857142862]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ13=\"\",\"\",'data entry'!AQ13)","v":1000},{"$f":"IF('data entry'!AR13=\"\",\"\",'data entry'!AR13)","v":2500},{"$f":"IF('data entry'!AS13=\"\",\"\",'data entry'!AS13)","v":5000},{"$f":"IF('data entry'!AT13=\"\",\"\",'data entry'!AT13)","v":50},0,7000,2500,4500]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV13=\"\",\"\",'data entry'!AV13)","v":2475},{"$f":"IF('data entry'!AW13=\"\",\"\",'data entry'!AW13)","v":3850},{"$f":"IF('data entry'!AX13=\"\",\"\",'data entry'!AX13)","v":4702},{"$f":"IF('data entry'!AY13=\"\",\"\",'data entry'!AY13)","v":80},2303.125,4808.5,1546.875,958.5]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA13=\"\",\"\",'data entry'!BA13)","v":864},{"$f":"IF('data entry'!BB13=\"\",\"\",'data entry'!BB13)","v":3692.1600000000003},{"$f":"IF('data entry'!BC13=\"\",\"\",'data entry'!BC13)","v":5760},{"$f":"IF('data entry'!BD13=\"\",\"\",'data entry'!BD13)","v":75},298.36799999999994,6173.5680000000002,3393.7920000000004,2481.4079999999999]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF13=\"\",\"\",'data entry'!BF13)","v":3500},{"$f":"IF('data entry'!BG13=\"\",\"\",'data entry'!BG13)","v":3700},{"$f":"IF('data entry'!BH13=\"\",\"\",'data entry'!BH13)","v":4000},{"$f":"IF('data entry'!BI13=\"\",\"\",'data entry'!BI13)","v":50},3340,4240,360,540]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":3161.8466666666668},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":812.83275000000003},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":4903.7048424908426},2349.0139166666668,1741.8581758241758]

{"sheet":"Q5","index":12,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A14","v":"Q5"},{"$f":"'data entry'!B14","v":"What will be the population size 30 years hence under Action 3 - Yellow crazy ant control plus ?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C14=\"\",\"\",'data entry'!C14)","v":2050},{"$f":"IF('data entry'!D14=\"\",\"\",'data entry'!D14)","v":3050},{"$f":"IF('data entry'!E14=\"\",\"\",'data entry'!E14)","v":4050},{"$f":"IF('data entry'!F14=\"\",\"\",'data entry'!F14)","v":70},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":1764.2857142857142},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":4335.7142857142862},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":1285.7142857142858},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":1285.7142857142862}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H14=\"\",\"\",'data entry'!H14)","v":500},{"$f":"IF('data entry'!I14=\"\",\"\",'data entry'!I14)","v":2550},{"$f":"IF('data entry'!J14=\"\",\"\",'data entry'!J14)","v":4350},{"$f":"IF('data entry'!K14=\"\",\"\",'data entry'!K14)","v":80},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":243.75},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":4575},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":2306.25},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":2025}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M14=\"\",\"\",'data entry'!M14)","v":910},{"$f":"IF('data entry'!N14=\"\",\"\",'data entry'!N14)","v":3100},{"$f":"IF('data entry'!O14=\"\",\"\",'data entry'!O14)","v":4000},{"$f":"IF('data entry'!P14=\"\",\"\",'data entry'!P14)","v":60},0,4450,3100,1350]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R14=\"\",\"\",'data entry'!R14)","v":0},{"$f":"IF('data entry'!S14=\"\",\"\",'data entry'!S14)","v":2100},{"$f":"IF('data entry'!T14=\"\",\"\",'data entry'!T14)","v":4200},{"$f":"IF('data entry'!U14=\"\",\"\",'data entry'!U14)","v":60},0,5250,2100,3150]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W14=\"\",\"\",'data entry'!W14)","v":800},{"$f":"IF('data entry'!X14=\"\",\"\",'data entry'!X14)","v":2200},{"$f":"IF('data entry'!Y14=\"\",\"\",'data entry'!Y14)","v":3500},{"$f":"IF('data entry'!Z14=\"\",\"\",'data entry'!Z14)","v":60},100,4150,2100,1950]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB14=\"\",\"\",'data entry'!AB14)","v":1500},{"$f":"IF('data entry'!AC14=\"\",\"\",'data entry'!AC14)","v":3000},{"$f":"IF('data entry'!AD14=\"\",\"\",'data entry'!AD14)","v":3500},{"$f":"IF('data entry'!AE14=\"\",\"\",'data entry'!AE14)","v":65},923.07692307692332,3692.3076923076924,2076.9230769230767,692.30769230769238]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG14=\"\",\"\",'data entry'!AG14)","v":500},{"$f":"IF('data entry'!AH14=\"\",\"\",'data entry'!AH14)","v":3650},{"$f":"IF('data entry'!AI14=\"\",\"\",'data entry'!AI14)","v":5000},{"$f":"IF('data entry'!AJ14=\"\",\"\",'data entry'!AJ14)","v":65},0,5519.2307692307695,3650,1869.2307692307695]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL14=\"\",\"\",'data entry'!AL14)","v":1000},{"$f":"IF('data entry'!AM14=\"\",\"\",'data entry'!AM14)","v":3000},{"$f":"IF('data entry'!AN14=\"\",\"\",'data entry'!AN14)","v":4500},{"$f":"IF('data entry'!AO14=\"\",\"\",'data entry'!AO14)","v":60},0,5250,3000,2250]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ14=\"\",\"\",'data entry'!AQ14)","v":1000},{"$f":"IF('data entry'!AR14=\"\",\"\",'data entry'!AR14)","v":2500},{"$f":"IF('data entry'!AS14=\"\",\"\",'data entry'!AS14)","v":5000},{"$f":"IF('data entry'!AT14=\"\",\"\",'data entry'!AT14)","v":50},0,7000,2500,4500]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV14=\"\",\"\",'data entry'!AV14)","v":2250},{"$f":"IF('data entry'!AW14=\"\",\"\",'data entry'!AW14)","v":3500},{"$f":"IF('data entry'!AX14=\"\",\"\",'data entry'!AX14)","v":4000},{"$f":"IF('data entry'!AY14=\"\",\"\",'data entry'!AY14)","v":80},2093.75,4062.5,1406.25,562.5]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA14=\"\",\"\",'data entry'!BA14)","v":756},{"$f":"IF('data entry'!BB14=\"\",\"\",'data entry'!BB14)","v":3230.6400000000003},{"$f":"IF('data entry'!BC14=\"\",\"\",'data entry'!BC14)","v":5040},{"$f":"IF('data entry'!BD14=\"\",\"\",'data entry'!BD14)","v":70},48.960000000000036,5556.96,3181.6800000000003,2326.3199999999997]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF14=\"\",\"\",'data entry'!BF14)","v":3500},{"$f":"IF('data entry'!BG14=\"\",\"\",'data entry'!BG14)","v":3700},{"$f":"IF('data entry'!BH14=\"\",\"\",'data entry'!BH14)","v":4000},{"$f":"IF('data entry'!BI14=\"\",\"\",'data entry'!BI14)","v":50},3340,4240,360,540]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":2965.0533333333333},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":709.48521978021984},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":4840.1427289377289},2255.5681135531136,1875.0893956043956]

{"sheet":"Q6","index":13,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A15","v":"Q6"},{"$f":"'data entry'!B15","v":"What will be the population size 30 years hence under Action 4 - Forest regeneration plus A ?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C15=\"\",\"\",'data entry'!C15)","v":2080},{"$f":"IF('data entry'!D15=\"\",\"\",'data entry'!D15)","v":3080},{"$f":"IF('data entry'!E15=\"\",\"\",'data entry'!E15)","v":4080},{"$f":"IF('data entry'!F15=\"\",\"\",'data entry'!F15)","v":70},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":1794.2857142857142},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":4365.7142857142862},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":1285.7142857142858},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":1285.7142857142862}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H15=\"\",\"\",'data entry'!H15)","v":750},{"$f":"IF('data entry'!I15=\"\",\"\",'data entry'!I15)","v":2600},{"$f":"IF('data entry'!J15=\"\",\"\",'data entry'!J15)","v":4600},{"$f":"IF('data entry'!K15=\"\",\"\",'data entry'!K15)","v":80},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":518.75},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":4850},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":2081.25},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":2250}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M15=\"\",\"\",'data entry'!M15)","v":900},{"$f":"IF('data entry'!N15=\"\",\"\",'data entry'!N15)","v":3000},{"$f":"IF('data entry'!O15=\"\",\"\",'data entry'!O15)","v":3500},{"$f":"IF('data entry'!P15=\"\",\"\",'data entry'!P15)","v":60},0,3750,3000,750]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R15=\"\",\"\",'data entry'!R15)","v":0},{"$f":"IF('data entry'!S15=\"\",\"\",'data entry'!S15)","v":2600},{"$f":"IF('data entry'!T15=\"\",\"\",'data entry'!T15)","v":5000},{"$f":"IF('data entry'!U15=\"\",\"\",'data entry'!U15)","v":60},0,6200,2600,3600]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W15=\"\",\"\",'data entry'!W15)","v":1500},{"$f":"IF('data entry'!X15=\"\",\"\",'data entry'!X15)","v":3500},{"$f":"IF('data entry'!Y15=\"\",\"\",'data entry'!Y15)","v":4500},{"$f":"IF('data entry'!Z15=\"\",\"\",'data entry'!Z15)","v":60},500,5000,3000,1500]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB15=\"\",\"\",'data entry'!AB15)","v":2000},{"$f":"IF('data entry'!AC15=\"\",\"\",'data entry'!AC15)","v":3500},{"$f":"IF('data entry'!AD15=\"\",\"\",'data entry'!AD15)","v":4000},{"$f":"IF('data entry'!AE15=\"\",\"\",'data entry'!AE15)","v":65},1423.0769230769233,4192.3076923076924,2076.9230769230767,692.30769230769238]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG15=\"\",\"\",'data entry'!AG15)","v":600},{"$f":"IF('data entry'!AH15=\"\",\"\",'data entry'!AH15)","v":3900},{"$f":"IF('data entry'!AI15=\"\",\"\",'data entry'!AI15)","v":5000},{"$f":"IF('data entry'!AJ15=\"\",\"\",'data entry'!AJ15)","v":70},0,5314.2857142857138,3900,1414.2857142857138]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL15=\"\",\"\",'data entry'!AL15)","v":1000},{"$f":"IF('data entry'!AM15=\"\",\"\",'data entry'!AM15)","v":2500},{"$f":"IF('data entry'!AN15=\"\",\"\",'data entry'!AN15)","v":4000},{"$f":"IF('data entry'!AO15=\"\",\"\",'data entry'!AO15)","v":70},571.42857142857156,4428.5714285714284,1928.5714285714284,1928.5714285714284]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ15=\"\",\"\",'data entry'!AQ15)","v":1000},{"$f":"IF('data entry'!AR15=\"\",\"\",'data entry'!AR15)","v":2500},{"$f":"IF('data entry'!AS15=\"\",\"\",'data entry'!AS15)","v":5000},{"$f":"IF('data entry'!AT15=\"\",\"\",'data entry'!AT15)","v":60},250,6250,2250,3750]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV15=\"\",\"\",'data entry'!AV15)","v":2280},{"$f":"IF('data entry'!AW15=\"\",\"\",'data entry'!AW15)","v":3530},{"$f":"IF('data entry'!AX15=\"\",\"\",'data entry'!AX15)","v":4205},{"$f":"IF('data entry'!AY15=\"\",\"\",'data entry'!AY15)","v":80},2123.75,4289.375,1406.25,759.375]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA15=\"\",\"\",'data entry'!BA15)","v":765},{"$f":"IF('data entry'!BB15=\"\",\"\",'data entry'!BB15)","v":3121.8},{"$f":"IF('data entry'!BC15=\"\",\"\",'data entry'!BC15)","v":4845},{"$f":"IF('data entry'!BD15=\"\",\"\",'data entry'!BD15)","v":70},91.628571428571377,5337.3428571428576,3030.1714285714288,2215.5428571428574]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF15=\"\",\"\",'data entry'!BF15)","v":3500},{"$f":"IF('data entry'!BG15=\"\",\"\",'data entry'!BG15)","v":3700},{"$f":"IF('data entry'!BH15=\"\",\"\",'data entry'!BH15)","v":4000},{"$f":"IF('data entry'!BI15=\"\",\"\",'data entry'!BI15)","v":50},3340,4240,360,540]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":3127.65},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":884.40998168498174},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":4851.4664148351649},2243.2400183150185,1723.8164148351648]

{"sheet":"Q7","index":14,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A16","v":"Q7"},{"$f":"'data entry'!B16","v":"What will be the population size 30 years hence under Action 5 - Forest regeneration plus B ?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C16=\"\",\"\",'data entry'!C16)","v":2125},{"$f":"IF('data entry'!D16=\"\",\"\",'data entry'!D16)","v":3125},{"$f":"IF('data entry'!E16=\"\",\"\",'data entry'!E16)","v":4125},{"$f":"IF('data entry'!F16=\"\",\"\",'data entry'!F16)","v":70},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":1839.2857142857142},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":4410.7142857142862},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":1285.7142857142858},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":1285.7142857142862}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H16=\"\",\"\",'data entry'!H16)","v":1000},{"$f":"IF('data entry'!I16=\"\",\"\",'data entry'!I16)","v":3000},{"$f":"IF('data entry'!J16=\"\",\"\",'data entry'!J16)","v":4800},{"$f":"IF('data entry'!K16=\"\",\"\",'data entry'!K16)","v":80},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":750},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":5025},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":2250},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":2025}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M16=\"\",\"\",'data entry'!M16)","v":950},{"$f":"IF('data entry'!N16=\"\",\"\",'data entry'!N16)","v":3200},{"$f":"IF('data entry'!O16=\"\",\"\",'data entry'!O16)","v":4000},{"$f":"IF('data entry'!P16=\"\",\"\",'data entry'!P16)","v":60},0,4400,3200,1200]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R16=\"\",\"\",'data entry'!R16)","v":0},{"$f":"IF('data entry'!S16=\"\",\"\",'data entry'!S16)","v":3100},{"$f":"IF('data entry'!T16=\"\",\"\",'data entry'!T16)","v":6000},{"$f":"IF('data entry'!U16=\"\",\"\",'data entry'!U16)","v":60},0,7450,3100,4350]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W16=\"\",\"\",'data entry'!W16)","v":2000},{"$f":"IF('data entry'!X16=\"\",\"\",'data entry'!X16)","v":4500},{"$f":"IF('data entry'!Y16=\"\",\"\",'data entry'!Y16)","v":5500},{"$f":"IF('data entry'!Z16=\"\",\"\",'data entry'!Z16)","v":70},1285.7142857142858,5785.7142857142862,3214.2857142857142,1285.7142857142862]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB16=\"\",\"\",'data entry'!AB16)","v":2500},{"$f":"IF('data entry'!AC16=\"\",\"\",'data entry'!AC16)","v":4000},{"$f":"IF('data entry'!AD16=\"\",\"\",'data entry'!AD16)","v":4500},{"$f":"IF('data entry'!AE16=\"\",\"\",'data entry'!AE16)","v":65},1923.0769230769233,4692.3076923076924,2076.9230769230767,692.30769230769238]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG16=\"\",\"\",'data entry'!AG16)","v":750},{"$f":"IF('data entry'!AH16=\"\",\"\",'data entry'!AH16)","v":4100},{"$f":"IF('data entry'!AI16=\"\",\"\",'data entry'!AI16)","v":6000},{"$f":"IF('data entry'!AJ16=\"\",\"\",'data entry'!AJ16)","v":70},0,6542.8571428571431,4100,2442.8571428571431]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL16=\"\",\"\",'data entry'!AL16)","v":1000},{"$f":"IF('data entry'!AM16=\"\",\"\",'data entry'!AM16)","v":3000},{"$f":"IF('data entry'!AN16=\"\",\"\",'data entry'!AN16)","v":5000},{"$f":"IF('data entry'!AO16=\"\",\"\",'data entry'!AO16)","v":70},428.57142857142844,5571.4285714285716,2571.4285714285716,2571.4285714285716]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ16=\"\",\"\",'data entry'!AQ16)","v":1500},{"$f":"IF('data entry'!AR16=\"\",\"\",'data entry'!AR16)","v":3000},{"$f":"IF('data entry'!AS16=\"\",\"\",'data entry'!AS16)","v":5000},{"$f":"IF('data entry'!AT16=\"\",\"\",'data entry'!AT16)","v":60},750,6000,2250,3000]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV16=\"\",\"\",'data entry'!AV16)","v":2340},{"$f":"IF('data entry'!AW16=\"\",\"\",'data entry'!AW16)","v":3590},{"$f":"IF('data entry'!AX16=\"\",\"\",'data entry'!AX16)","v":4265},{"$f":"IF('data entry'!AY16=\"\",\"\",'data entry'!AY16)","v":80},2183.75,4349.375,1406.25,759.375]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA16=\"\",\"\",'data entry'!BA16)","v":855},{"$f":"IF('data entry'!BB16=\"\",\"\",'data entry'!BB16)","v":3211.8},{"$f":"IF('data entry'!BC16=\"\",\"\",'data entry'!BC16)","v":4935},{"$f":"IF('data entry'!BD16=\"\",\"\",'data entry'!BD16)","v":70},181.62857142857138,5427.3428571428576,3030.1714285714288,2215.5428571428574]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF16=\"\",\"\",'data entry'!BF16)","v":3500},{"$f":"IF('data entry'!BG16=\"\",\"\",'data entry'!BG16)","v":3700},{"$f":"IF('data entry'!BH16=\"\",\"\",'data entry'!BH16)","v":4000},{"$f":"IF('data entry'!BI16=\"\",\"\",'data entry'!BI16)","v":50},3340,4240,360,540]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":3460.5666666666671},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":1056.835576923077},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":5324.5616529304034},2403.73108974359,1863.9949862637363]

{"sheet":"Q8","index":15,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A17","v":"Q8"},{"$f":"'data entry'!B17","v":"What will be the population size 30 years hence under Action 6 - Expand conservation estate A ?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C17=\"\",\"\",'data entry'!C17)","v":2200},{"$f":"IF('data entry'!D17=\"\",\"\",'data entry'!D17)","v":3200},{"$f":"IF('data entry'!E17=\"\",\"\",'data entry'!E17)","v":4200},{"$f":"IF('data entry'!F17=\"\",\"\",'data entry'!F17)","v":70},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":1914.2857142857142},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":4485.7142857142862},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":1285.7142857142858},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":1285.7142857142862}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H17=\"\",\"\",'data entry'!H17)","v":1200},{"$f":"IF('data entry'!I17=\"\",\"\",'data entry'!I17)","v":3300},{"$f":"IF('data entry'!J17=\"\",\"\",'data entry'!J17)","v":5000},{"$f":"IF('data entry'!K17=\"\",\"\",'data entry'!K17)","v":80},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":937.5},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":5212.5},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":2362.5},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":1912.5}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M17=\"\",\"\",'data entry'!M17)","v":900},{"$f":"IF('data entry'!N17=\"\",\"\",'data entry'!N17)","v":3400},{"$f":"IF('data entry'!O17=\"\",\"\",'data entry'!O17)","v":4000},{"$f":"IF('data entry'!P17=\"\",\"\",'data entry'!P17)","v":70},185.71428571428578,4171.4285714285716,3214.2857142857142,771.42857142857156]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R17=\"\",\"\",'data entry'!R17)","v":0},{"$f":"IF('data entry'!S17=\"\",\"\",'data entry'!S17)","v":3500},{"$f":"IF('data entry'!T17=\"\",\"\",'data entry'!T17)","v":6000},{"$f":"IF('data entry'!U17=\"\",\"\",'data entry'!U17)","v":60},0,7250,3500,3750]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W17=\"\",\"\",'data entry'!W17)","v":700},{"$f":"IF('data entry'!X17=\"\",\"\",'data entry'!X17)","v":2500},{"$f":"IF('data entry'!Y17=\"\",\"\",'data entry'!Y17)","v":3200},{"$f":"IF('data entry'!Z17=\"\",\"\",'data entry'!Z17)","v":60},0,3550,2500,1050]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB17=\"\",\"\",'data entry'!AB17)","v":3000},{"$f":"IF('data entry'!AC17=\"\",\"\",'data entry'!AC17)","v":4000},{"$f":"IF('data entry'!AD17=\"\",\"\",'data entry'!AD17)","v":5000},{"$f":"IF('data entry'!AE17=\"\",\"\",'data entry'!AE17)","v":65},2615.3846153846152,5384.6153846153848,1384.6153846153848,1384.6153846153848]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG17=\"\",\"\",'data entry'!AG17)","v":500},{"$f":"IF('data entry'!AH17=\"\",\"\",'data entry'!AH17)","v":3600},{"$f":"IF('data entry'!AI17=\"\",\"\",'data entry'!AI17)","v":5000},{"$f":"IF('data entry'!AJ17=\"\",\"\",'data entry'!AJ17)","v":55},0,5890.909090909091,3600,2290.909090909091]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL17=\"\",\"\",'data entry'!AL17)","v":2000},{"$f":"IF('data entry'!AM17=\"\",\"\",'data entry'!AM17)","v":4000},{"$f":"IF('data entry'!AN17=\"\",\"\",'data entry'!AN17)","v":5000},{"$f":"IF('data entry'!AO17=\"\",\"\",'data entry'!AO17)","v":80},1750,5125,2250,1125]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ17=\"\",\"\",'data entry'!AQ17)","v":1500},{"$f":"IF('data entry'!AR17=\"\",\"\",'data entry'!AR17)","v":3000},{"$f":"IF('data entry'!AS17=\"\",\"\",'data entry'!AS17)","v":5000},{"$f":"IF('data entry'!AT17=\"\",\"\",'data entry'!AT17)","v":70},1071.4285714285716,5571.4285714285716,1928.5714285714284,2571.4285714285716]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV17=\"\",\"\",'data entry'!AV17)","v":2295},{"$f":"IF('data entry'!AW17=\"\",\"\",'data entry'!AW17)","v":3570},{"$f":"IF('data entry'!AX17=\"\",\"\",'data entry'!AX17)","v":4361},{"$f":"IF('data entry'!AY17=\"\",\"\",'data entry'!AY17)","v":80},2135.625,4459.875,1434.375,889.875]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA17=\"\",\"\",'data entry'!BA17)","v":1145},{"$f":"IF('data entry'!BB17=\"\",\"\",'data entry'!BB17)","v":3501.8},{"$f":"IF('data entry'!BC17=\"\",\"\",'data entry'!BC17)","v":5225},{"$f":"IF('data entry'!BD17=\"\",\"\",'data entry'!BD17)","v":70},471.62857142857138,5717.3428571428576,3030.1714285714288,2215.5428571428574]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF17=\"\",\"\",'data entry'!BF17)","v":3500},{"$f":"IF('data entry'!BG17=\"\",\"\",'data entry'!BG17)","v":3700},{"$f":"IF('data entry'!BH17=\"\",\"\",'data entry'!BH17)","v":4000},{"$f":"IF('data entry'!BI17=\"\",\"\",'data entry'!BI17)","v":50},3340,4240,360,540]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":3439.3166666666671},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":1201.7972298534798},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":5088.2344801032305},2237.519436813187,1648.9178134365634]

{"sheet":"Q9","index":16,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A18","v":"Q9"},{"$f":"'data entry'!B18","v":"What will be the population size 30 years hence under Action 7 - Expand conservation estate B ?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C18=\"\",\"\",'data entry'!C18)","v":2400},{"$f":"IF('data entry'!D18=\"\",\"\",'data entry'!D18)","v":3400},{"$f":"IF('data entry'!E18=\"\",\"\",'data entry'!E18)","v":4400},{"$f":"IF('data entry'!F18=\"\",\"\",'data entry'!F18)","v":70},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":2114.2857142857142},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":4685.7142857142862},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":1285.7142857142858},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":1285.7142857142862}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H18=\"\",\"\",'data entry'!H18)","v":1500},{"$f":"IF('data entry'!I18=\"\",\"\",'data entry'!I18)","v":3600},{"$f":"IF('data entry'!J18=\"\",\"\",'data entry'!J18)","v":5300},{"$f":"IF('data entry'!K18=\"\",\"\",'data entry'!K18)","v":80},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":1237.5},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":5512.5},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":2362.5},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":1912.5}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M18=\"\",\"\",'data entry'!M18)","v":1100},{"$f":"IF('data entry'!N18=\"\",\"\",'data entry'!N18)","v":3700},{"$f":"IF('data entry'!O18=\"\",\"\",'data entry'!O18)","v":5000},{"$f":"IF('data entry'!P18=\"\",\"\",'data entry'!P18)","v":70},357.14285714285688,5371.4285714285716,3342.8571428571431,1671.4285714285716]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R18=\"\",\"\",'data entry'!R18)","v":0},{"$f":"IF('data entry'!S18=\"\",\"\",'data entry'!S18)","v":4000},{"$f":"IF('data entry'!T18=\"\",\"\",'data entry'!T18)","v":6000},{"$f":"IF('data entry'!U18=\"\",\"\",'data entry'!U18)","v":60},0,7000,4000,3000]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W18=\"\",\"\",'data entry'!W18)","v":1000},{"$f":"IF('data entry'!X18=\"\",\"\",'data entry'!X18)","v":3100},{"$f":"IF('data entry'!Y18=\"\",\"\",'data entry'!Y18)","v":3600},{"$f":"IF('data entry'!Z18=\"\",\"\",'data entry'!Z18)","v":60},0,3850,3100,750]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB18=\"\",\"\",'data entry'!AB18)","v":3500},{"$f":"IF('data entry'!AC18=\"\",\"\",'data entry'!AC18)","v":4500},{"$f":"IF('data entry'!AD18=\"\",\"\",'data entry'!AD18)","v":6000},{"$f":"IF('data entry'!AE18=\"\",\"\",'data entry'!AE18)","v":65},3115.3846153846152,6576.9230769230762,1384.6153846153848,2076.9230769230762]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG18=\"\",\"\",'data entry'!AG18)","v":750},{"$f":"IF('data entry'!AH18=\"\",\"\",'data entry'!AH18)","v":3800},{"$f":"IF('data entry'!AI18=\"\",\"\",'data entry'!AI18)","v":5000},{"$f":"IF('data entry'!AJ18=\"\",\"\",'data entry'!AJ18)","v":55},0,5763.636363636364,3800,1963.636363636364]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL18=\"\",\"\",'data entry'!AL18)","v":2000},{"$f":"IF('data entry'!AM18=\"\",\"\",'data entry'!AM18)","v":4000},{"$f":"IF('data entry'!AN18=\"\",\"\",'data entry'!AN18)","v":5000},{"$f":"IF('data entry'!AO18=\"\",\"\",'data entry'!AO18)","v":80},1750,5125,2250,1125]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ18=\"\",\"\",'data entry'!AQ18)","v":1500},{"$f":"IF('data entry'!AR18=\"\",\"\",'data entry'!AR18)","v":3000},{"$f":"IF('data entry'!AS18=\"\",\"\",'data entry'!AS18)","v":5000},{"$f":"IF('data entry'!AT18=\"\",\"\",'data entry'!AT18)","v":70},1071.4285714285716,5571.4285714285716,1928.5714285714284,2571.4285714285716]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV18=\"\",\"\",'data entry'!AV18)","v":2318},{"$f":"IF('data entry'!AW18=\"\",\"\",'data entry'!AW18)","v":3605},{"$f":"IF('data entry'!AX18=\"\",\"\",'data entry'!AX18)","v":4403},{"$f":"IF('data entry'!AY18=\"\",\"\",'data entry'!AY18)","v":80},2157.125,4502.75,1447.875,897.75]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA18=\"\",\"\",'data entry'!BA18)","v":1238.5},{"$f":"IF('data entry'!BB18=\"\",\"\",'data entry'!BB18)","v":3595.3},{"$f":"IF('data entry'!BC18=\"\",\"\",'data entry'!BC18)","v":5318.5},{"$f":"IF('data entry'!BD18=\"\",\"\",'data entry'!BD18)","v":70},565.12857142857138,5810.8428571428576,3030.1714285714288,2215.5428571428574]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF18=\"\",\"\",'data entry'!BF18)","v":3500},{"$f":"IF('data entry'!BG18=\"\",\"\",'data entry'!BG18)","v":3700},{"$f":"IF('data entry'!BH18=\"\",\"\",'data entry'!BH18)","v":4000},{"$f":"IF('data entry'!BI18=\"\",\"\",'data entry'!BI18)","v":50},3340,4240,360,540]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":3666.6916666666671},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":1308.9996108058608},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":5334.1853105228111},2357.6920558608062,1667.493643856144]

{"sheet":"Q10","index":17,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A19","v":"Q10"},{"$f":"'data entry'!B19","v":"What will be the population size 30 years hence under Action 8 - Cadmium control ?"}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C19=\"\",\"\",'data entry'!C19)","v":2100},{"$f":"IF('data entry'!D19=\"\",\"\",'data entry'!D19)","v":3100},{"$f":"IF('data entry'!E19=\"\",\"\",'data entry'!E19)","v":4100},{"$f":"IF('data entry'!F19=\"\",\"\",'data entry'!F19)","v":70},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":1814.2857142857142},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":4385.7142857142862},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":1285.7142857142858},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":1285.7142857142862}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H19=\"\",\"\",'data entry'!H19)","v":600},{"$f":"IF('data entry'!I19=\"\",\"\",'data entry'!I19)","v":2800},{"$f":"IF('data entry'!J19=\"\",\"\",'data entry'!J19)","v":5000},{"$f":"IF('data entry'!K19=\"\",\"\",'data entry'!K19)","v":80},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":325},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":5275},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":2475},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":2475}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M19=\"\",\"\",'data entry'!M19)","v":900},{"$f":"IF('data entry'!N19=\"\",\"\",'data entry'!N19)","v":3000},{"$f":"IF('data entry'!O19=\"\",\"\",'data entry'!O19)","v":4000},{"$f":"IF('data entry'!P19=\"\",\"\",'data entry'!P19)","v":50},0,4800,3000,1800]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R19=\"\",\"\",'data entry'!R19)","v":0},{"$f":"IF('data entry'!S19=\"\",\"\",'data entry'!S19)","v":2100},{"$f":"IF('data entry'!T19=\"\",\"\",'data entry'!T19)","v":4000},{"$f":"IF('data entry'!U19=\"\",\"\",'data entry'!U19)","v":55},0,5209.090909090909,2100,3109.090909090909]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W19=\"\",\"\",'data entry'!W19)","v":1500},{"$f":"IF('data entry'!X19=\"\",\"\",'data entry'!X19)","v":3500},{"$f":"IF('data entry'!Y19=\"\",\"\",'data entry'!Y19)","v":5000},{"$f":"IF('data entry'!Z19=\"\",\"\",'data entry'!Z19)","v":60},500,5750,3000,2250]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB19=\"\",\"\",'data entry'!AB19)","v":3000},{"$f":"IF('data entry'!AC19=\"\",\"\",'data entry'!AC19)","v":4000},{"$f":"IF('data entry'!AD19=\"\",\"\",'data entry'!AD19)","v":5000},{"$f":"IF('data entry'!AE19=\"\",\"\",'data entry'!AE19)","v":65},2615.3846153846152,5384.6153846153848,1384.6153846153848,1384.6153846153848]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG19=\"\",\"\",'data entry'!AG19)","v":500},{"$f":"IF('data entry'!AH19=\"\",\"\",'data entry'!AH19)","v":3500},{"$f":"IF('data entry'!AI19=\"\",\"\",'data entry'!AI19)","v":5000},{"$f":"IF('data entry'!AJ19=\"\",\"\",'data entry'!AJ19)","v":60},0,5750,3500,2250]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL19=\"\",\"\",'data entry'!AL19)","v":2000},{"$f":"IF('data entry'!AM19=\"\",\"\",'data entry'!AM19)","v":3500},{"$f":"IF('data entry'!AN19=\"\",\"\",'data entry'!AN19)","v":5000},{"$f":"IF('data entry'!AO19=\"\",\"\",'data entry'!AO19)","v":75},1700,5300,1800,1800]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ19=\"\",\"\",'data entry'!AQ19)","v":1500},{"$f":"IF('data entry'!AR19=\"\",\"\",'data entry'!AR19)","v":3000},{"$f":"IF('data entry'!AS19=\"\",\"\",'data entry'!AS19)","v":5000},{"$f":"IF('data entry'!AT19=\"\",\"\",'data entry'!AT19)","v":50},300,6600,2700,3600]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV19=\"\",\"\",'data entry'!AV19)","v":2362},{"$f":"IF('data entry'!AW19=\"\",\"\",'data entry'!AW19)","v":3675},{"$f":"IF('data entry'!AX19=\"\",\"\",'data entry'!AX19)","v":4489},{"$f":"IF('data entry'!AY19=\"\",\"\",'data entry'!AY19)","v":80},2197.875,4590.75,1477.125,915.75]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA19=\"\",\"\",'data entry'!BA19)","v":727.2},{"$f":"IF('data entry'!BB19=\"\",\"\",'data entry'!BB19)","v":3107.5680000000002},{"$f":"IF('data entry'!BC19=\"\",\"\",'data entry'!BC19)","v":4848},{"$f":"IF('data entry'!BD19=\"\",\"\",'data entry'!BD19)","v":70},47.094857142857109,5345.2662857142859,3060.4731428571431,2237.6982857142857]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF19=\"\",\"\",'data entry'!BF19)","v":3500},{"$f":"IF('data entry'!BG19=\"\",\"\",'data entry'!BG19)","v":3700},{"$f":"IF('data entry'!BH19=\"\",\"\",'data entry'!BH19)","v":4000},{"$f":"IF('data entry'!BI19=\"\",\"\",'data entry'!BI19)","v":50},3340,4240,360,540]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":3248.5473333333334},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":1069.9700155677656},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":5219.2030720945722},2178.5773177655678,1970.6557387612388]

{"sheet":"Q11","index":18,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A20","v":"Q11"},{"$f":"'data entry'!B20","v":""}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C20=\"\",\"\",'data entry'!C20)","v":""},{"$f":"IF('data entry'!D20=\"\",\"\",'data entry'!D20)","v":""},{"$f":"IF('data entry'!E20=\"\",\"\",'data entry'!E20)","v":""},{"$f":"IF('data entry'!F20=\"\",\"\",'data entry'!F20)","v":""},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":""},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":""},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":""},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":""}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H20=\"\",\"\",'data entry'!H20)","v":""},{"$f":"IF('data entry'!I20=\"\",\"\",'data entry'!I20)","v":""},{"$f":"IF('data entry'!J20=\"\",\"\",'data entry'!J20)","v":""},{"$f":"IF('data entry'!K20=\"\",\"\",'data entry'!K20)","v":""},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":""},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":""},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":""},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":""}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M20=\"\",\"\",'data entry'!M20)","v":""},{"$f":"IF('data entry'!N20=\"\",\"\",'data entry'!N20)","v":""},{"$f":"IF('data entry'!O20=\"\",\"\",'data entry'!O20)","v":""},{"$f":"IF('data entry'!P20=\"\",\"\",'data entry'!P20)","v":""},"","","",""]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R20=\"\",\"\",'data entry'!R20)","v":""},{"$f":"IF('data entry'!S20=\"\",\"\",'data entry'!S20)","v":""},{"$f":"IF('data entry'!T20=\"\",\"\",'data entry'!T20)","v":""},{"$f":"IF('data entry'!U20=\"\",\"\",'data entry'!U20)","v":""},"","","",""]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W20=\"\",\"\",'data entry'!W20)","v":""},{"$f":"IF('data entry'!X20=\"\",\"\",'data entry'!X20)","v":""},{"$f":"IF('data entry'!Y20=\"\",\"\",'data entry'!Y20)","v":""},{"$f":"IF('data entry'!Z20=\"\",\"\",'data entry'!Z20)","v":""},"","","",""]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB20=\"\",\"\",'data entry'!AB20)","v":""},{"$f":"IF('data entry'!AC20=\"\",\"\",'data entry'!AC20)","v":""},{"$f":"IF('data entry'!AD20=\"\",\"\",'data entry'!AD20)","v":""},{"$f":"IF('data entry'!AE20=\"\",\"\",'data entry'!AE20)","v":""},"","","",""]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG20=\"\",\"\",'data entry'!AG20)","v":""},{"$f":"IF('data entry'!AH20=\"\",\"\",'data entry'!AH20)","v":""},{"$f":"IF('data entry'!AI20=\"\",\"\",'data entry'!AI20)","v":""},{"$f":"IF('data entry'!AJ20=\"\",\"\",'data entry'!AJ20)","v":""},"","","",""]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL20=\"\",\"\",'data entry'!AL20)","v":""},{"$f":"IF('data entry'!AM20=\"\",\"\",'data entry'!AM20)","v":""},{"$f":"IF('data entry'!AN20=\"\",\"\",'data entry'!AN20)","v":""},{"$f":"IF('data entry'!AO20=\"\",\"\",'data entry'!AO20)","v":""},"","","",""]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ20=\"\",\"\",'data entry'!AQ20)","v":""},{"$f":"IF('data entry'!AR20=\"\",\"\",'data entry'!AR20)","v":""},{"$f":"IF('data entry'!AS20=\"\",\"\",'data entry'!AS20)","v":""},{"$f":"IF('data entry'!AT20=\"\",\"\",'data entry'!AT20)","v":""},"","","",""]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV20=\"\",\"\",'data entry'!AV20)","v":""},{"$f":"IF('data entry'!AW20=\"\",\"\",'data entry'!AW20)","v":""},{"$f":"IF('data entry'!AX20=\"\",\"\",'data entry'!AX20)","v":""},{"$f":"IF('data entry'!AY20=\"\",\"\",'data entry'!AY20)","v":""},"","","",""]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA20=\"\",\"\",'data entry'!BA20)","v":""},{"$f":"IF('data entry'!BB20=\"\",\"\",'data entry'!BB20)","v":""},{"$f":"IF('data entry'!BC20=\"\",\"\",'data entry'!BC20)","v":""},{"$f":"IF('data entry'!BD20=\"\",\"\",'data entry'!BD20)","v":""},"","","",""]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF20=\"\",\"\",'data entry'!BF20)","v":""},{"$f":"IF('data entry'!BG20=\"\",\"\",'data entry'!BG20)","v":""},{"$f":"IF('data entry'!BH20=\"\",\"\",'data entry'!BH20)","v":""},{"$f":"IF('data entry'!BI20=\"\",\"\",'data entry'!BI20)","v":""},"","","",""]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":""},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":""},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":""},"",""]

{"sheet":"Q12","index":19,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A21","v":"Q12"},{"$f":"'data entry'!B21","v":""}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C21=\"\",\"\",'data entry'!C21)","v":""},{"$f":"IF('data entry'!D21=\"\",\"\",'data entry'!D21)","v":""},{"$f":"IF('data entry'!E21=\"\",\"\",'data entry'!E21)","v":""},{"$f":"IF('data entry'!F21=\"\",\"\",'data entry'!F21)","v":""},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":""},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":""},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":""},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":""}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H21=\"\",\"\",'data entry'!H21)","v":""},{"$f":"IF('data entry'!I21=\"\",\"\",'data entry'!I21)","v":""},{"$f":"IF('data entry'!J21=\"\",\"\",'data entry'!J21)","v":""},{"$f":"IF('data entry'!K21=\"\",\"\",'data entry'!K21)","v":""},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":""},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":""},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":""},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":""}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M21=\"\",\"\",'data entry'!M21)","v":""},{"$f":"IF('data entry'!N21=\"\",\"\",'data entry'!N21)","v":""},{"$f":"IF('data entry'!O21=\"\",\"\",'data entry'!O21)","v":""},{"$f":"IF('data entry'!P21=\"\",\"\",'data entry'!P21)","v":""},"","","",""]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R21=\"\",\"\",'data entry'!R21)","v":""},{"$f":"IF('data entry'!S21=\"\",\"\",'data entry'!S21)","v":""},{"$f":"IF('data entry'!T21=\"\",\"\",'data entry'!T21)","v":""},{"$f":"IF('data entry'!U21=\"\",\"\",'data entry'!U21)","v":""},"","","",""]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W21=\"\",\"\",'data entry'!W21)","v":""},{"$f":"IF('data entry'!X21=\"\",\"\",'data entry'!X21)","v":""},{"$f":"IF('data entry'!Y21=\"\",\"\",'data entry'!Y21)","v":""},{"$f":"IF('data entry'!Z21=\"\",\"\",'data entry'!Z21)","v":""},"","","",""]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB21=\"\",\"\",'data entry'!AB21)","v":""},{"$f":"IF('data entry'!AC21=\"\",\"\",'data entry'!AC21)","v":""},{"$f":"IF('data entry'!AD21=\"\",\"\",'data entry'!AD21)","v":""},{"$f":"IF('data entry'!AE21=\"\",\"\",'data entry'!AE21)","v":""},"","","",""]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG21=\"\",\"\",'data entry'!AG21)","v":""},{"$f":"IF('data entry'!AH21=\"\",\"\",'data entry'!AH21)","v":""},{"$f":"IF('data entry'!AI21=\"\",\"\",'data entry'!AI21)","v":""},{"$f":"IF('data entry'!AJ21=\"\",\"\",'data entry'!AJ21)","v":""},"","","",""]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL21=\"\",\"\",'data entry'!AL21)","v":""},{"$f":"IF('data entry'!AM21=\"\",\"\",'data entry'!AM21)","v":""},{"$f":"IF('data entry'!AN21=\"\",\"\",'data entry'!AN21)","v":""},{"$f":"IF('data entry'!AO21=\"\",\"\",'data entry'!AO21)","v":""},"","","",""]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ21=\"\",\"\",'data entry'!AQ21)","v":""},{"$f":"IF('data entry'!AR21=\"\",\"\",'data entry'!AR21)","v":""},{"$f":"IF('data entry'!AS21=\"\",\"\",'data entry'!AS21)","v":""},{"$f":"IF('data entry'!AT21=\"\",\"\",'data entry'!AT21)","v":""},"","","",""]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV21=\"\",\"\",'data entry'!AV21)","v":""},{"$f":"IF('data entry'!AW21=\"\",\"\",'data entry'!AW21)","v":""},{"$f":"IF('data entry'!AX21=\"\",\"\",'data entry'!AX21)","v":""},{"$f":"IF('data entry'!AY21=\"\",\"\",'data entry'!AY21)","v":""},"","","",""]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA21=\"\",\"\",'data entry'!BA21)","v":""},{"$f":"IF('data entry'!BB21=\"\",\"\",'data entry'!BB21)","v":""},{"$f":"IF('data entry'!BC21=\"\",\"\",'data entry'!BC21)","v":""},{"$f":"IF('data entry'!BD21=\"\",\"\",'data entry'!BD21)","v":""},"","","",""]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF21=\"\",\"\",'data entry'!BF21)","v":""},{"$f":"IF('data entry'!BG21=\"\",\"\",'data entry'!BG21)","v":""},{"$f":"IF('data entry'!BH21=\"\",\"\",'data entry'!BH21)","v":""},{"$f":"IF('data entry'!BI21=\"\",\"\",'data entry'!BI21)","v":""},"","","",""]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":""},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":""},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":""},"",""]

{"sheet":"Q13","index":20,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A22","v":"Q13"},{"$f":"'data entry'!B22","v":""}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C22=\"\",\"\",'data entry'!C22)","v":""},{"$f":"IF('data entry'!D22=\"\",\"\",'data entry'!D22)","v":""},{"$f":"IF('data entry'!E22=\"\",\"\",'data entry'!E22)","v":""},{"$f":"IF('data entry'!F22=\"\",\"\",'data entry'!F22)","v":""},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":""},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":""},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":""},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":""}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H22=\"\",\"\",'data entry'!H22)","v":""},{"$f":"IF('data entry'!I22=\"\",\"\",'data entry'!I22)","v":""},{"$f":"IF('data entry'!J22=\"\",\"\",'data entry'!J22)","v":""},{"$f":"IF('data entry'!K22=\"\",\"\",'data entry'!K22)","v":""},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":""},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":""},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":""},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":""}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M22=\"\",\"\",'data entry'!M22)","v":""},{"$f":"IF('data entry'!N22=\"\",\"\",'data entry'!N22)","v":""},{"$f":"IF('data entry'!O22=\"\",\"\",'data entry'!O22)","v":""},{"$f":"IF('data entry'!P22=\"\",\"\",'data entry'!P22)","v":""},"","","",""]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R22=\"\",\"\",'data entry'!R22)","v":""},{"$f":"IF('data entry'!S22=\"\",\"\",'data entry'!S22)","v":""},{"$f":"IF('data entry'!T22=\"\",\"\",'data entry'!T22)","v":""},{"$f":"IF('data entry'!U22=\"\",\"\",'data entry'!U22)","v":""},"","","",""]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W22=\"\",\"\",'data entry'!W22)","v":""},{"$f":"IF('data entry'!X22=\"\",\"\",'data entry'!X22)","v":""},{"$f":"IF('data entry'!Y22=\"\",\"\",'data entry'!Y22)","v":""},{"$f":"IF('data entry'!Z22=\"\",\"\",'data entry'!Z22)","v":""},"","","",""]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB22=\"\",\"\",'data entry'!AB22)","v":""},{"$f":"IF('data entry'!AC22=\"\",\"\",'data entry'!AC22)","v":""},{"$f":"IF('data entry'!AD22=\"\",\"\",'data entry'!AD22)","v":""},{"$f":"IF('data entry'!AE22=\"\",\"\",'data entry'!AE22)","v":""},"","","",""]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG22=\"\",\"\",'data entry'!AG22)","v":""},{"$f":"IF('data entry'!AH22=\"\",\"\",'data entry'!AH22)","v":""},{"$f":"IF('data entry'!AI22=\"\",\"\",'data entry'!AI22)","v":""},{"$f":"IF('data entry'!AJ22=\"\",\"\",'data entry'!AJ22)","v":""},"","","",""]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL22=\"\",\"\",'data entry'!AL22)","v":""},{"$f":"IF('data entry'!AM22=\"\",\"\",'data entry'!AM22)","v":""},{"$f":"IF('data entry'!AN22=\"\",\"\",'data entry'!AN22)","v":""},{"$f":"IF('data entry'!AO22=\"\",\"\",'data entry'!AO22)","v":""},"","","",""]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ22=\"\",\"\",'data entry'!AQ22)","v":""},{"$f":"IF('data entry'!AR22=\"\",\"\",'data entry'!AR22)","v":""},{"$f":"IF('data entry'!AS22=\"\",\"\",'data entry'!AS22)","v":""},{"$f":"IF('data entry'!AT22=\"\",\"\",'data entry'!AT22)","v":""},"","","",""]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV22=\"\",\"\",'data entry'!AV22)","v":""},{"$f":"IF('data entry'!AW22=\"\",\"\",'data entry'!AW22)","v":""},{"$f":"IF('data entry'!AX22=\"\",\"\",'data entry'!AX22)","v":""},{"$f":"IF('data entry'!AY22=\"\",\"\",'data entry'!AY22)","v":""},"","","",""]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA22=\"\",\"\",'data entry'!BA22)","v":""},{"$f":"IF('data entry'!BB22=\"\",\"\",'data entry'!BB22)","v":""},{"$f":"IF('data entry'!BC22=\"\",\"\",'data entry'!BC22)","v":""},{"$f":"IF('data entry'!BD22=\"\",\"\",'data entry'!BD22)","v":""},"","","",""]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF22=\"\",\"\",'data entry'!BF22)","v":""},{"$f":"IF('data entry'!BG22=\"\",\"\",'data entry'!BG22)","v":""},{"$f":"IF('data entry'!BH22=\"\",\"\",'data entry'!BH22)","v":""},{"$f":"IF('data entry'!BI22=\"\",\"\",'data entry'!BI22)","v":""},"","","",""]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":""},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":""},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":""},"",""]

{"sheet":"Q14","index":21,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[51,2,51,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'data entry'!A23","v":"Q14"},{"$f":"'data entry'!B23","v":""}]
[]
[null,null,"lower ","best","upper","confidence (%)","90% lower","90% upper","lower bound","upper bound"]
[null,{"$f":"participants!D10","v":"Col M"},{"$f":"IF('data entry'!C23=\"\",\"\",'data entry'!C23)","v":""},{"$f":"IF('data entry'!D23=\"\",\"\",'data entry'!D23)","v":""},{"$f":"IF('data entry'!E23=\"\",\"\",'data entry'!E23)","v":""},{"$f":"IF('data entry'!F23=\"\",\"\",'data entry'!F23)","v":""},{"$f":"IF(D55=\"\",\"\",MAX(0,((D55-((D55-C55)/F55)*90))))","v":""},{"$f":"IF(D55=\"\",\"\",((D55-((D55-E55)/F55)*90)))","v":""},{"$f":"IF(D55=\"\",\"\",(D55-G55))","v":""},{"$f":"IF(D55=\"\",\"\",(H55-D55))","v":""}]
[null,{"$f":"participants!D11","v":"Mrs P"},{"$f":"IF('data entry'!H23=\"\",\"\",'data entry'!H23)","v":""},{"$f":"IF('data entry'!I23=\"\",\"\",'data entry'!I23)","v":""},{"$f":"IF('data entry'!J23=\"\",\"\",'data entry'!J23)","v":""},{"$f":"IF('data entry'!K23=\"\",\"\",'data entry'!K23)","v":""},{"$f":"IF(D56=\"\",\"\",MAX(0,((D56-((D56-C56)/F56)*90))))","v":""},{"$f":"IF(D56=\"\",\"\",((D56-((D56-E56)/F56)*90)))","v":""},{"$f":"IF(D56=\"\",\"\",(D56-G56))","v":""},{"$f":"IF(D56=\"\",\"\",(H56-D56))","v":""}]
[null,{"$f":"participants!D12","v":"Dr B"},{"$f":"IF('data entry'!M23=\"\",\"\",'data entry'!M23)","v":""},{"$f":"IF('data entry'!N23=\"\",\"\",'data entry'!N23)","v":""},{"$f":"IF('data entry'!O23=\"\",\"\",'data entry'!O23)","v":""},{"$f":"IF('data entry'!P23=\"\",\"\",'data entry'!P23)","v":""},"","","",""]
[null,{"$f":"participants!D13","v":"Rev G"},{"$f":"IF('data entry'!R23=\"\",\"\",'data entry'!R23)","v":""},{"$f":"IF('data entry'!S23=\"\",\"\",'data entry'!S23)","v":""},{"$f":"IF('data entry'!T23=\"\",\"\",'data entry'!T23)","v":""},{"$f":"IF('data entry'!U23=\"\",\"\",'data entry'!U23)","v":""},"","","",""]
[null,{"$f":"participants!D14","v":"Miss S"},{"$f":"IF('data entry'!W23=\"\",\"\",'data entry'!W23)","v":""},{"$f":"IF('data entry'!X23=\"\",\"\",'data entry'!X23)","v":""},{"$f":"IF('data entry'!Y23=\"\",\"\",'data entry'!Y23)","v":""},{"$f":"IF('data entry'!Z23=\"\",\"\",'data entry'!Z23)","v":""},"","","",""]
[null,{"$f":"participants!D15","v":"Prof P"},{"$f":"IF('data entry'!AB23=\"\",\"\",'data entry'!AB23)","v":""},{"$f":"IF('data entry'!AC23=\"\",\"\",'data entry'!AC23)","v":""},{"$f":"IF('data entry'!AD23=\"\",\"\",'data entry'!AD23)","v":""},{"$f":"IF('data entry'!AE23=\"\",\"\",'data entry'!AE23)","v":""},"","","",""]
[null,{"$f":"participants!D16","v":"Dr O"},{"$f":"IF('data entry'!AG23=\"\",\"\",'data entry'!AG23)","v":""},{"$f":"IF('data entry'!AH23=\"\",\"\",'data entry'!AH23)","v":""},{"$f":"IF('data entry'!AI23=\"\",\"\",'data entry'!AI23)","v":""},{"$f":"IF('data entry'!AJ23=\"\",\"\",'data entry'!AJ23)","v":""},"","","",""]
[null,{"$f":"participants!D17","v":"Mrs W"},{"$f":"IF('data entry'!AL23=\"\",\"\",'data entry'!AL23)","v":""},{"$f":"IF('data entry'!AM23=\"\",\"\",'data entry'!AM23)","v":""},{"$f":"IF('data entry'!AN23=\"\",\"\",'data entry'!AN23)","v":""},{"$f":"IF('data entry'!AO23=\"\",\"\",'data entry'!AO23)","v":""},"","","",""]
[null,{"$f":"participants!D18","v":"Sgt G"},{"$f":"IF('data entry'!AQ23=\"\",\"\",'data entry'!AQ23)","v":""},{"$f":"IF('data entry'!AR23=\"\",\"\",'data entry'!AR23)","v":""},{"$f":"IF('data entry'!AS23=\"\",\"\",'data entry'!AS23)","v":""},{"$f":"IF('data entry'!AT23=\"\",\"\",'data entry'!AT23)","v":""},"","","",""]
[null,{"$f":"participants!D19","v":"Mon B"},{"$f":"IF('data entry'!AV23=\"\",\"\",'data entry'!AV23)","v":""},{"$f":"IF('data entry'!AW23=\"\",\"\",'data entry'!AW23)","v":""},{"$f":"IF('data entry'!AX23=\"\",\"\",'data entry'!AX23)","v":""},{"$f":"IF('data entry'!AY23=\"\",\"\",'data entry'!AY23)","v":""},"","","",""]
[null,{"$f":"participants!D20","v":"Miss P"},{"$f":"IF('data entry'!BA23=\"\",\"\",'data entry'!BA23)","v":""},{"$f":"IF('data entry'!BB23=\"\",\"\",'data entry'!BB23)","v":""},{"$f":"IF('data entry'!BC23=\"\",\"\",'data entry'!BC23)","v":""},{"$f":"IF('data entry'!BD23=\"\",\"\",'data entry'!BD23)","v":""},"","","",""]
[null,{"$f":"participants!D21","v":"Insp B"},{"$f":"IF('data entry'!BF23=\"\",\"\",'data entry'!BF23)","v":""},{"$f":"IF('data entry'!BG23=\"\",\"\",'data entry'!BG23)","v":""},{"$f":"IF('data entry'!BH23=\"\",\"\",'data entry'!BH23)","v":""},{"$f":"IF('data entry'!BI23=\"\",\"\",'data entry'!BI23)","v":""},"","","",""]
[null,"pooled",null,{"$f":"IF(COUNT(D55:D66)=0,\"\",AVERAGE(D55:D66))","v":""},null,null,{"$f":"IF(COUNT(G55:G66)=0,\"\",AVERAGE(G55:G66))","v":""},{"$f":"IF(COUNT(H55:H66)=0,\"\",AVERAGE(H55:H66))","v":""},"",""]

{"sheet":"outcomes_1","index":22,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A8","v":"Q1"},{"$f":"'data entry'!B8","v":"Under ideal conditions (e.g. prior to human occupation) what do you think is the carrying capacity of the whole island?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A10","v":"Q2"},{"$f":"'data entry'!B10","v":"What will be the population size 30 years hence under the base case?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A12","v":"Q3"},{"$f":"'data entry'!B12","v":"What will be the population size 30 years hence under Action 1 - Ex-situ ?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A13","v":"Q4"},{"$f":"'data entry'!B13","v":"What will be the population size 30 years hence under Action 2 - Cat control plus ?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A14","v":"Q5"},{"$f":"'data entry'!B14","v":"What will be the population size 30 years hence under Action 3 - Yellow crazy ant control plus ?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A15","v":"Q6"},{"$f":"'data entry'!B15","v":"What will be the population size 30 years hence under Action 4 - Forest regeneration plus A ?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A16","v":"Q7"},{"$f":"'data entry'!B16","v":"What will be the population size 30 years hence under Action 5 - Forest regeneration plus B ?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A17","v":"Q8"},{"$f":"'data entry'!B17","v":"What will be the population size 30 years hence under Action 6 - Expand conservation estate A ?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A18","v":"Q9"},{"$f":"'data entry'!B18","v":"What will be the population size 30 years hence under Action 7 - Expand conservation estate B ?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A19","v":"Q10"},{"$f":"'data entry'!B19","v":"What will be the population size 30 years hence under Action 8 - Cadmium control ?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A20","v":"Q11"},{"$f":"'data entry'!B20","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A21","v":"Q12"},{"$f":"'data entry'!B21","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A22","v":"Q13"},{"$f":"'data entry'!B22","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'data entry'!A23","v":"Q14"},{"$f":"'data entry'!B23","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"best","lower","upper","calc1","calc 2","cost ($k)"]
[null,"Q1",{"$f":"'Q1'!$D$67","v":4875},{"$f":"'Q1'!$I$67","v":1745.7236842105267},{"$f":"'Q1'!$J$67","v":1733.6701127819542},{"$f":"C43+E43","v":6608.6701127819542},{"$f":"MAX(F43:F51)+500","v":7108.6701127819542}]
[null,"Q2",{"$f":"'Q2'!$D$67","v":3128.8333333333335},{"$f":"'Q2'!$I$67","v":2216.6401942355892},{"$f":"'Q2'!$J$67","v":1554.9528508771932},{"$f":"C44+E44","v":4683.7861842105267},{"$f":"G$43","v":7108.6701127819542}]
[null,"Q3",{"$f":"'Q3'!$D$67","v":3274.3466666666668},{"$f":"'Q3'!$I$67","v":2317.523532051282},{"$f":"'Q3'!$J$67","v":2006.4779310689305},5280.8245977355973,7108.6701127819542,{"$f":"costs!K21","v":4101.521739130435}]
[null,"Q4",{"$f":"'Q4'!$D$67","v":3161.8466666666668},{"$f":"'Q4'!$I$67","v":2349.0139166666668},{"$f":"'Q4'!$J$67","v":1741.8581758241758},4903.7048424908426,7108.6701127819542,{"$f":"costs!K22","v":779.52173913043487}]
[null,"Q5",{"$f":"'Q5'!$D$67","v":2965.0533333333333},{"$f":"'Q5'!$I$67","v":2255.5681135531136},{"$f":"'Q5'!$J$67","v":1875.0893956043956},4840.1427289377289,7108.6701127819542,{"$f":"costs!K23","v":839.15652173913043}]
[null,"Q6",{"$f":"'Q6'!$D$67","v":3127.65},{"$f":"'Q6'!$I$67","v":2243.2400183150185},{"$f":"'Q6'!$J$67","v":1723.8164148351648},4851.4664148351649,7108.6701127819542,{"$f":"costs!K24","v":7326.7826086956529}]
[null,"Q7",{"$f":"'Q7'!$D$67","v":3460.5666666666671},{"$f":"'Q7'!$I$67","v":2403.73108974359},{"$f":"'Q7'!$J$67","v":1863.9949862637363},5324.5616529304034,7108.6701127819542,{"$f":"costs!K25","v":36633.913043478256}]
[null,"Q8",{"$f":"'Q8'!$D$67","v":3439.3166666666671},{"$f":"'Q8'!$I$67","v":2237.519436813187},{"$f":"'Q8'!$J$67","v":1648.9178134365634},5088.2344801032305,7108.6701127819542,{"$f":"costs!K26","v":21956.086956521736}]
[null,"Q9",{"$f":"'Q9'!$D$67","v":3666.6916666666671},{"$f":"'Q9'!$I$67","v":2357.6920558608062},{"$f":"'Q9'!$J$67","v":1667.493643856144},5334.1853105228111,7108.6701127819542,{"$f":"costs!K27","v":26781.304347826088}]
[null,"Q10",{"$f":"'Q10'!$D$67","v":3248.5473333333334},{"$f":"'Q10'!$I$67","v":2178.5773177655678},{"$f":"'Q10'!$J$67","v":1970.6557387612388},{"$f":"C52+E52","v":5219.2030720945722},7108.6701127819542,{"$f":"costs!K28","v":2247.086956521739}]
[null,"Q11",{"$f":"'Q11'!$D$67","v":""},{"$f":"'Q11'!$I$67","v":""},{"$f":"'Q11'!$J$67","v":""},{"$f":"C53+E53","v":{"$error":"#VALUE!"}},7108.6701127819542,{"$f":"costs!K29","v":""}]
[null,"Q12",{"$f":"'Q12'!$D$67","v":""},{"$f":"'Q12'!$I$67","v":""},{"$f":"'Q12'!$J$67","v":""},{"$f":"C54+E54","v":{"$error":"#VALUE!"}},7108.6701127819542,{"$f":"costs!K30","v":""}]
[null,"Q13",{"$f":"'Q13'!$D$67","v":""},{"$f":"'Q13'!$I$67","v":""},{"$f":"'Q13'!$J$67","v":""},{"$f":"C55+E55","v":{"$error":"#VALUE!"}},7108.6701127819542,{"$f":"costs!K31","v":""}]
[null,"Q14",{"$f":"'Q14'!$D$67","v":""},{"$f":"'Q14'!$I$67","v":""},{"$f":"'Q14'!$J$67","v":""},{"$f":"C56+E56","v":{"$error":"#VALUE!"}},7108.6701127819542,{"$f":"costs!K32","v":""}]

{"sheet":"outcomes_2","index":23,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Outcomes 2"]
[]
[null,"The cost-effectiveness of actions (conservation value divided by cost) is tabulated here."]
[null,"The conservation benefit comes from the curves in the ex-situ judgments tab.  ",null,"For each action, it is the difference in the value of the population size under the base case and the action."]
[null,"For the ex-situ action, there is additional value from an insurance population included in the calculation of conservation benefit."]
[null,"Costs are from the costs tab."]
[]
[null,"The cumulative conservation benefits of implementing multiple candidate actions (described in terms of population size in the wild) are graphed below the table, along with cumulative costs.  "]
[null,"The graph can be used to gauge the strength of the argument for additional funding.  Note that the graph does not include the value of an insurance population."]
[]
[null,"Before considering the graph, click on the RANK button to order the actions from best (most cost-effective) to worst (least cost-effective).  "]
[]
[]
[null,"Action",{"$f":"CONCATENATE(\"estimated population size in \",preliminaries!C14,\" years\")","v":"estimated population size in 30 years"},"conservation benefit","cost ($m)","cost-effectiveness"]
[null,{"$f":"IF('candidate actions'!C11=\"\",\"\",'candidate actions'!C11)","v":"Ex-situ"},{"$f":"IF('Q3'!D67=\"\",\"\",'Q3'!D67)","v":3274.3466666666668},{"$f":"IF(C16=\"\",\"\",100*calc!D17)","v":0.73793660450554033},{"$f":"IF(costs!K21=\"\",\"\",costs!K21/1000)","v":4.1015217391304351},{"$f":"IF(B16=\"\",-999,D16/E16)","v":0.17991776014869801}]
[null,{"$f":"IF('candidate actions'!C18=\"\",\"\",'candidate actions'!C18)","v":"Cadmium control"},{"$f":"IF('Q10'!D67=\"\",\"\",'Q10'!D67)","v":3248.5473333333334},{"$f":"IF(C17=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C17-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":0.35410903785770831},{"$f":"IF(costs!K28=\"\",\"\",costs!K28/1000)","v":2.2470869565217391},0.1575858187552443]
[null,{"$f":"IF('candidate actions'!C12=\"\",\"\",'candidate actions'!C12)","v":"Cat control plus"},{"$f":"IF('Q4'!D67=\"\",\"\",'Q4'!D67)","v":3161.8466666666668},{"$f":"IF(C18=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C18-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":0.10256497725402713},{"$f":"IF(costs!K22=\"\",\"\",costs!K22/1000)","v":0.77952173913043488},0.13157423597761303]
[null,{"$f":"IF('candidate actions'!C17=\"\",\"\",'candidate actions'!C17)","v":"Expand conservation estate B"},{"$f":"IF('Q9'!D67=\"\",\"\",'Q9'!D67)","v":3666.6916666666671},{"$f":"IF(C19=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C19-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":1.2701957004108033},{"$f":"IF(costs!K27=\"\",\"\",costs!K27/1000)","v":26.781304347826087},4.7428447991701671E-2]
[null,{"$f":"IF('candidate actions'!C16=\"\",\"\",'candidate actions'!C16)","v":"Expand conservation estate A"},{"$f":"IF('Q8'!D67=\"\",\"\",'Q8'!D67)","v":3439.3166666666671},{"$f":"IF(C20=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C20-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":0.82677477490062934},{"$f":"IF(costs!K26=\"\",\"\",costs!K26/1000)","v":21.956086956521737},3.7655834417937933E-2]
[null,{"$f":"IF('candidate actions'!C15=\"\",\"\",'candidate actions'!C15)","v":"Forest regeneration plus B"},{"$f":"IF('Q7'!D67=\"\",\"\",'Q7'!D67)","v":3460.5666666666671},{"$f":"IF(C21=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C21-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":0.87329501259628683},{"$f":"IF(costs!K25=\"\",\"\",costs!K25/1000)","v":36.633913043478259},2.3838431115994443E-2]
[null,{"$f":"IF('candidate actions'!C14=\"\",\"\",'candidate actions'!C14)","v":"Forest regeneration plus A"},{"$f":"IF('Q6'!D67=\"\",\"\",'Q6'!D67)","v":3127.65},{"$f":"IF(C22=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C22-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":-3.7490715164678612E-3},{"$f":"IF(costs!K24=\"\",\"\",costs!K24/1000)","v":7.3267826086956527},-5.1169411141233361E-4]
[null,{"$f":"IF('candidate actions'!C13=\"\",\"\",'candidate actions'!C13)","v":"Yellow crazy ant control plus"},{"$f":"IF('Q5'!D67=\"\",\"\",'Q5'!D67)","v":2965.0533333333333},{"$f":"IF(C23=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C23-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":-0.5705453123255988},{"$f":"IF(costs!K23=\"\",\"\",costs!K23/1000)","v":0.83915652173913047},-0.67990332857469571]
[null,{"$f":"IF('candidate actions'!C19=\"\",\"\",'candidate actions'!C19)","v":""},{"$f":"IF('Q11'!D67=\"\",\"\",'Q11'!D67)","v":""},{"$f":"IF(C24=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C24-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":""},{"$f":"IF(costs!K29=\"\",\"\",costs!K29/1000)","v":""},-999]
[null,{"$f":"IF('candidate actions'!C20=\"\",\"\",'candidate actions'!C20)","v":""},{"$f":"IF('Q12'!D67=\"\",\"\",'Q12'!D67)","v":""},{"$f":"IF(C25=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C25-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":""},{"$f":"IF(costs!K30=\"\",\"\",costs!K30/1000)","v":""},-999]
[null,{"$f":"IF('candidate actions'!C21=\"\",\"\",'candidate actions'!C21)","v":""},{"$f":"IF('Q13'!D67=\"\",\"\",'Q13'!D67)","v":""},{"$f":"IF(C26=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C26-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":""},{"$f":"IF(costs!K31=\"\",\"\",costs!K31/1000)","v":""},-999]
[null,{"$f":"IF('candidate actions'!C22=\"\",\"\",'candidate actions'!C22)","v":""},{"$f":"IF('Q14'!D67=\"\",\"\",'Q14'!D67)","v":""},{"$f":"IF(C27=\"\",\"\",100*((('ex-situ judgments'!$E$34/100)*(1-EXP(-(C27-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)-(('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0)))","v":""},{"$f":"IF(costs!K32=\"\",\"\",costs!K32/1000)","v":""},-999]

{"sheet":"calc","index":24,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ex-situ conservation value"]
[null,"estimated population size in the wild",{"$f":"outcomes_2!C16","v":3274.3466666666668}]
[]
[null,"state","value|insurance = no","value|insurance = yes"]
[null,"probability",{"$f":"1-'ex-situ judgments'!$F$17","v":0.19999999999999996},{"$f":"'ex-situ judgments'!$F$17","v":0.8}]
[null,"ex-situ",{"$f":"('ex-situ judgments'!$E$34/100)*(1-EXP(-(C10-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0","v":0.98039451794782118},{"$f":"((100-'ex-situ judgments'!$E$35)/100)*(1-EXP(-(C10-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+('ex-situ judgments'!$E$35/100)","v":0.98431561435825699}]
[null,"base case",{"$f":"('ex-situ judgments'!$E$34/100)*(1-EXP(-('Q2'!$D$67-0)/'value judgment'!$D$45))/(1-EXP(-('Q1'!$D$67-0)/'value judgment'!$D$45))+0","v":0.97615202903111442},{"$f":"C15","v":0.97615202903111442}]
[null,"benefit",{"$f":"C14-C15","v":4.2424889167067548E-3},{"$f":"D14-D15","v":8.163585327142564E-3}]
[null,"weighted benefit",null,{"$f":"C13*C16+D13*D16","v":7.379366045055403E-3}]
[]
[]
[]
[]
[]
[null,"Cumulative benefit"]
[]
[null,{"$f":"outcomes_2!B15","v":"Action"},{"$f":"outcomes_2!C15","v":"estimated population size in 30 years"},{"$f":"outcomes_2!D15","v":"conservation benefit"},{"$f":"outcomes_2!E15","v":"cost ($m)"},{"$f":"outcomes_2!F15","v":"cost-effectiveness"},"cumulative cost","proportional benefit","cumulative benefit"]
[null,{"$f":"outcomes_2!B16","v":"Ex-situ"},{"$f":"outcomes_2!C16","v":3274.3466666666668},{"$f":"outcomes_2!D16","v":0.73793660450554033},{"$f":"outcomes_2!E16","v":4.1015217391304351},{"$f":"outcomes_2!F16","v":0.17991776014869801},{"$f":"IF(E26=\"\",\"\",SUM(E$26:E26))","v":4.1015217391304351},{"$f":"IF(C26=\"\",\"\",(C26-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":8.3333015176100034E-2},{"$f":"IF(B26=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26)))*('Q1'!$D$67-'Q2'!$D$67))","v":3274.3466666666668}]
[null,{"$f":"outcomes_2!B17","v":"Cadmium control"},{"$f":"outcomes_2!C17","v":3248.5473333333334},{"$f":"outcomes_2!D17","v":0.35410903785770831},{"$f":"outcomes_2!E17","v":2.2470869565217391},{"$f":"outcomes_2!F17","v":0.1575858187552443},{"$f":"IF(E27=\"\",\"\",SUM(E$26:E27))","v":6.3486086956521746},{"$f":"IF(C27=\"\",\"\",(C27-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":6.8558175050109735E-2},{"$f":"IF(B27=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27)))*('Q1'!$D$67-'Q2'!$D$67))","v":3384.084538087875}]
[null,{"$f":"outcomes_2!B18","v":"Cat control plus"},{"$f":"outcomes_2!C18","v":3161.8466666666668},{"$f":"outcomes_2!D18","v":0.10256497725402713},{"$f":"outcomes_2!E18","v":0.77952173913043488},{"$f":"outcomes_2!F18","v":0.13157423597761303},{"$f":"IF(E28=\"\",\"\",SUM(E$26:E28))","v":7.1281304347826095},{"$f":"IF(C28=\"\",\"\",(C28-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":1.8906175431898438E-2},{"$f":"IF(B28=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28)))*('Q1'!$D$67-'Q2'!$D$67))","v":3412.2720473649156}]
[null,{"$f":"outcomes_2!B19","v":"Expand conservation estate B"},{"$f":"outcomes_2!C19","v":3666.6916666666671},{"$f":"outcomes_2!D19","v":1.2701957004108033},{"$f":"outcomes_2!E19","v":26.781304347826087},{"$f":"outcomes_2!F19","v":4.7428447991701671E-2},{"$f":"IF(E29=\"\",\"\",SUM(E$26:E29))","v":33.909434782608699},{"$f":"IF(C29=\"\",\"\",(C29-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":0.30802233463777817},{"$f":"IF(B29=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28),(1-H29)))*('Q1'!$D$67-'Q2'!$D$67))","v":3862.8249262755116}]
[null,{"$f":"outcomes_2!B20","v":"Expand conservation estate A"},{"$f":"outcomes_2!C20","v":3439.3166666666671},{"$f":"outcomes_2!D20","v":0.82677477490062934},{"$f":"outcomes_2!E20","v":21.956086956521737},{"$f":"outcomes_2!F20","v":3.7655834417937933E-2},{"$f":"IF(E30=\"\",\"\",SUM(E$26:E30))","v":55.865521739130436},{"$f":"IF(C30=\"\",\"\",(C30-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":0.17780853297699739},{"$f":"IF(B30=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28),(1-H29),(1-H30)))*('Q1'!$D$67-'Q2'!$D$67))","v":4042.7982912503471}]
[null,{"$f":"outcomes_2!B21","v":"Forest regeneration plus B"},{"$f":"outcomes_2!C21","v":3460.5666666666671},{"$f":"outcomes_2!D21","v":0.87329501259628683},{"$f":"outcomes_2!E21","v":36.633913043478259},{"$f":"outcomes_2!F21","v":2.3838431115994443E-2},{"$f":"IF(E31=\"\",\"\",SUM(E$26:E31))","v":92.499434782608688},{"$f":"IF(C31=\"\",\"\",(C31-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":0.18997804715090214},{"$f":"IF(B31=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28),(1-H29),(1-H30),(1-H31)))*('Q1'!$D$67-'Q2'!$D$67))","v":4200.8983467142498}]
[null,{"$f":"outcomes_2!B22","v":"Forest regeneration plus A"},{"$f":"outcomes_2!C22","v":3127.65},{"$f":"outcomes_2!D22","v":-3.7490715164678612E-3},{"$f":"outcomes_2!E22","v":7.3267826086956527},{"$f":"outcomes_2!F22","v":-5.1169411141233361E-4},{"$f":"IF(E32=\"\",\"\",SUM(E$26:E32))","v":99.82621739130434},{"$f":"IF(C32=\"\",\"\",(C32-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":-6.7767490693904401E-4},{"$f":"IF(B32=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28),(1-H29),(1-H30),(1-H31),(1-H32)))*('Q1'!$D$67-'Q2'!$D$67))","v":4200.4415249390922}]
[null,{"$f":"outcomes_2!B23","v":"Yellow crazy ant control plus"},{"$f":"outcomes_2!C23","v":2965.0533333333333},{"$f":"outcomes_2!D23","v":-0.5705453123255988},{"$f":"outcomes_2!E23","v":0.83915652173913047},{"$f":"outcomes_2!F23","v":-0.67990332857469571},{"$f":"IF(E33=\"\",\"\",SUM(E$26:E33))","v":100.66537391304347},{"$f":"IF(C33=\"\",\"\",(C33-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":-9.3794025007158666E-2},{"$f":"IF(B33=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28),(1-H29),(1-H30),(1-H31),(1-H32),(1-H33)))*('Q1'!$D$67-'Q2'!$D$67))","v":4137.1719704604384}]
[null,{"$f":"outcomes_2!B24","v":""},{"$f":"outcomes_2!C24","v":""},{"$f":"outcomes_2!D24","v":""},{"$f":"outcomes_2!E24","v":""},{"$f":"outcomes_2!F24","v":-999},{"$f":"IF(E34=\"\",\"\",SUM(E$26:E34))","v":""},{"$f":"IF(C34=\"\",\"\",(C34-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":""},{"$f":"IF(B34=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28),(1-H29),(1-H30),(1-H31),(1-H32),(1-H33),(1-H34)))*('Q1'!$D$67-'Q2'!$D$67))","v":""}]
[null,{"$f":"outcomes_2!B25","v":""},{"$f":"outcomes_2!C25","v":""},{"$f":"outcomes_2!D25","v":""},{"$f":"outcomes_2!E25","v":""},{"$f":"outcomes_2!F25","v":-999},{"$f":"IF(E35=\"\",\"\",SUM(E$26:E35))","v":""},{"$f":"IF(C35=\"\",\"\",(C35-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":""},{"$f":"IF(B35=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28),(1-H29),(1-H30),(1-H31),(1-H32),(1-H33),(1-H34),(1-H35)))*('Q1'!$D$67-'Q2'!$D$67))","v":""}]
[null,{"$f":"outcomes_2!B26","v":""},{"$f":"outcomes_2!C26","v":""},{"$f":"outcomes_2!D26","v":""},{"$f":"outcomes_2!E26","v":""},{"$f":"outcomes_2!F26","v":-999},{"$f":"IF(E36=\"\",\"\",SUM(E$26:E36))","v":""},{"$f":"IF(C36=\"\",\"\",(C36-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":""},{"$f":"IF(B36=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28),(1-H29),(1-H30),(1-H31),(1-H32),(1-H33),(1-H34),(1-H35),(1-H36)))*('Q1'!$D$67-'Q2'!$D$67))","v":""}]
[null,{"$f":"outcomes_2!B27","v":""},{"$f":"outcomes_2!C27","v":""},{"$f":"outcomes_2!D27","v":""},{"$f":"outcomes_2!E27","v":""},{"$f":"outcomes_2!F27","v":-999},{"$f":"IF(E37=\"\",\"\",SUM(E$26:E37))","v":""},{"$f":"IF(C37=\"\",\"\",(C37-'Q2'!$D$67)/('Q1'!$D$67-'Q2'!$D$67))","v":""},{"$f":"IF(B37=\"\",\"\",'Q2'!$D$67+(1-PRODUCT((1-H26),(1-H27),(1-H28),(1-H29),(1-H30),(1-H31),(1-H32),(1-H33),(1-H34),(1-H35),(1-H36),(1-H37)))*('Q1'!$D$67-'Q2'!$D$67))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cumulative graph"]
[]
[null,"Number of actions","cumulative cost (RHS)","pad cost","pad benefit","cumulative benefit (LHS)"]
[null,"base case",0,null,null,{"$f":"'Q2'!D67","v":3128.8333333333335}]
[null,1,{"$f":"IF(G26=\"\",0,G26)","v":4.1015217391304351},null,null,{"$f":"IF(I26=\"\",0,I26)","v":3274.3466666666668}]
[null,2,6.3486086956521746,null,null,3384.084538087875]
[null,3,7.1281304347826095,null,null,3412.2720473649156]
[null,4,33.909434782608699,null,null,3862.8249262755116]
[null,5,55.865521739130436,null,null,4042.7982912503471]
[null,6,92.499434782608688,null,null,4200.8983467142498]
[null,7,99.82621739130434,null,null,4200.4415249390922]
[null,8,100.66537391304347,null,null,4137.1719704604384]
[null,9,0,null,null,0]
[null,10,0,null,null,0]
[null,11,0,null,null,0]
[null,12,0,null,null,0]