{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dashboard","Pop Model - do not touch","Costs and welfare - dont touch","Rates - do not touch","Cluster analysis"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Dashboard","index":0,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[[16,6,16,9],[28,6,28,9],[29,6,29,9],[30,6,30,9],[31,6,31,9],[27,6,27,10],[37,1,37,12],[25,6,25,9],[17,6,17,9],[18,6,18,9],[19,6,19,9],[20,6,20,9],[22,6,22,9],[21,6,21,9],[23,6,23,9],[24,6,24,9]]}
[]
[null,"INPUT"]
[null,"Startpopulaties","Beginwaarden","Eigen invoer"]
[null,"Aantal inwoners ",33141,33141]
[null,"Aantal huiskatten ",6164,{"$f":"N20","v":6164}]
[null,"Aantal zwerfkatten ",1104,{"$f":"N21","v":1104}]
[null,"% vruchtbare zwerfkatten",37,{"$f":"N23","v":37}]
[null,"Aantal koloniekatten ",{"$f":"ROUND(((1704+136)/(520504+1200))*$C$4,0)","v":117},{"$f":"N22","v":117}]
[null,"Type habitat",null,"Alle"]
[null,"Ingrepen via huiskatten","Beginwaarden","Eigen invoer"]
[null,"Proportie vruchtbare huiskatten (in %)",0.12,0.12]
[null,"Proportie gedumpte huiskatten die zwerfkat worden (in %)",0.05,0.05]
[null,"Proportie verloren huiskatten weer bij eigenaar (in %)",0.05,0.05]
[null,"Ingrepen via zwerfkatten ","Beginwaarden","Eigen invoer"]
[null,"Proportie gevangen zwerfkatten van totale zwerfkattenpopulatie (in %)",0,0]
[null,"waarvan:"]
[null,"Proportie zwerfkatten teruggeplaatst na steriel maken (in %)",0,0,null,null,"Overzicht veranderingen & kostprijs",null,null,null,"na 5 jaar","na 10 jaar"]
[null,"Proportie zwerfkatten teruggeplaatst na steriel maken als koloniekat (in %)",0,0,null,null,"% verandering zwerfkat populatie t.o.v. startpopulatie",null,null,null,{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!G39-'Pop Model - do not touch'!B39)","v":90.746593457672986},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!L39-'Pop Model - do not touch'!B39)","v":443.37837667849419}]
[null,"Proportie zwerfkatten naar asiel (in %)",0,0,null,null,"% verandering koloniekat populatie t.o.v. startpopulatie",null,null,null,{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!G40-'Pop Model - do not touch'!B40)","v":-14.126597430000018},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!L40-'Pop Model - do not touch'!B40)","v":-26.257587310507176},null,"Hidden rates for macro"]
[null,"Proportie zwerfkatten geëuthanaseerd (in %)",0,0,{"$f":"IF(SUM(D17:D20)>100,\"ERROR\",SUM(D17:D20))","v":0},null,"% verandering welzijnsindex tov start",null,null,null,{"$f":"'Costs and welfare - dont touch'!G31","v":-0.59681679319466241},{"$f":"'Costs and welfare - dont touch'!L31","v":-0.96901865417964927},null,{"$f":"ROUND(0.186*$D$4,0)","v":6164}]
[null,null,null,null,null,null,"% verandering hinderindex tov start",null,null,null,{"$f":"'Costs and welfare - dont touch'!G23","v":26.194490751252999},{"$f":"'Costs and welfare - dont touch'!L23","v":129.04409193927381},null,{"$f":"SUM('Rates - do not touch'!B5:B6)","v":1104}]
[null,"Kosten voor ingrepen via zwerfkatten ","Beginwaarden","Eigen invoer","Van toepassing op",null,"Totale kost terugplaatsen na steriel maken (euro)",null,null,null,{"$f":"IF($D$33=0,SUM('Costs and welfare - dont touch'!$C$4:G$4),0)","v":0},{"$f":"IF($D$33=0,SUM('Costs and welfare - dont touch'!$C$4:L$4),0)","v":0},null,{"$f":"ROUND(((1704+136)/(520504+1200))*$D$4,0)","v":117}]
[null,"Steriel maken (per kat in euro)",{"$f":"(39.25+77.95)/2","v":58.6},0,"Alle",null,"Totale kost omzetten naar koloniekat (euro)",null,null,null,{"$f":"IF($D$33=0,SUM('Costs and welfare - dont touch'!$C$6:G$7),0)","v":0},{"$f":"IF($D$33=0,SUM('Costs and welfare - dont touch'!$C$6:L$7),0)","v":0},null,37]
[null,"Chip (per kat in euro)",23.6,0,"Alle",null,"Totale kost euthanasie (euro)",null,null,null,{"$f":"IF($D$33=0,SUM('Costs and welfare - dont touch'!$C$5:G$5),0)","v":0},{"$f":"IF($D$33=0,SUM('Costs and welfare - dont touch'!$C$5:L$5),0)","v":0}]
[null,"FIV/FELV test (per kat in euro)",27.2,0,"Alle",null,"Totale kost opname in asiel (euro)",null,null,null,{"$f":"IF($D$33=0,SUM('Costs and welfare - dont touch'!$C$8:G$8),0)","v":0},{"$f":"IF($D$33=0,SUM('Costs and welfare - dont touch'!$C$8:L$8),0)","v":0}]
[null,"Vaccinatie (per kat in euro)",13.94,0,"Alle",null,"Totale kost voor ingrepen via zwerfkatten (euro)",null,null,null,{"$f":"IF($D$33 = 0, SUM('Costs and welfare - dont touch'!$C$4:'Costs and welfare - dont touch'!G$8), SUM('Costs and welfare - dont touch'!$C$10:G$10))","v":0},{"$f":"IF($D$33 = 0, SUM('Costs and welfare - dont touch'!$C$4:'Costs and welfare - dont touch'!L$8), SUM('Costs and welfare - dont touch'!$C$10:L$10))","v":0}]
[null,"Ontwormen (per kat in euro)",10.93,0,"Alle"]
[null,"Ontvlooien (per kat in euro)",12.74,0,"Alle",null,"Overzicht eenmalige kosten per kat naargelang ingreep (in euro)"]
[null,"Ander (per kat in euro)",0,0,"Alle",null,"Kost terugplaatsen na steriel maken",null,null,null,{"$f":"SUM(SUMIFS($D$23:$D$29,$E$23:$E$29, {\"Terugplaatsen\",\"Alle\"}))","v":0}]
[null,"Opname in asiel: eenmalige plaatsingskost, excl. onderhoud (per kat in euro)",0,0,null,null,"Kost omzetten naar koloniekat (incl. steriel maken)",null,null,null,{"$f":"SUM(SUMIFS($D$23:$D$29,$E$23:$E$29, {\"Koloniekat\",\"Alle\"}))","v":0}]
[null,"Euthanasie (per kat in euro)",50,0,null,null,"Kost euthanasie",null,null,null,{"$f":"D31","v":0}]
[null,"ofwel:",null,0,null,null,"Kost opname in asiel",null,null,null,{"$f":"$D$30","v":0}]
[null,"Kosten via contract (per kat in euro)",0,0]
[]
[]
[]
[]
[null,"OUTPUT/RESULTATEN"]
[null,"Jaren","startsituatie",1,2,3,4,5,6,7,8,9,10]
[null,"Populaties"]
[null,"% zwerfkatten dat overblijft tov startpopulatie",100,{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!C39)","v":94.646755281159386},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!D39)","v":112.96872633855067},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!E39)","v":134.16864521773903},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!F39)","v":159.49857220900859},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!G39)","v":190.74659345767299},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!H39)","v":230.05640678436941},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!I39)","v":280.38089095230924},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!J39)","v":345.66386873244056},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!K39)","v":431.02180960412409},{"$f":"IF($D$6=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!L39)","v":543.37837667849419}]
[null,"% vruchtbare zwerfkatten tov startpopulatie",100,{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!C42)","v":144.11764705882354},{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!D42)","v":202.94117647058823},{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!E42)","v":281.37254901960785},{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!F42)","v":385.78431372549022},{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!G42)","v":525.49019607843138},{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!H42)","v":711.76470588235293},{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!I42)","v":960.2941176470589},{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!J42)","v":1292.1568627450981},{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!K42)","v":1734.8039215686274},{"$f":"IF((OR($D$7=0,$D$6=0)),\"nvt: geen startpop.\",'Pop Model - do not touch'!L42)","v":2325.4901960784314}]
[null,"% koloniekat tov startpopulatie",100,{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!C40)","v":97},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!D40)","v":94.089999999999989},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!E40)","v":91.267299999999977},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!F40)","v":88.529280999999983},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!G40)","v":85.873402569999982},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!H40)","v":83.297200492899975},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!I40)","v":80.79828447811299},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!J40)","v":78.374335943769609},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!K40)","v":76.023105865456515},{"$f":"IF($D$8=0,\"nvt: geen startpop.\",'Pop Model - do not touch'!L40)","v":73.742412689492824}]
[null,"Cumulatief totaal koloniekatten",{"$f":"D8","v":117},{"$f":"'Pop Model - do not touch'!C11+'Pop Model - do not touch'!C18","v":0},{"$f":"E45+D44","v":0},{"$f":"F45+E44","v":0},0,0,0,0,0,0,0]
[null,"Aantal nieuwe koloniekatten (per jaar)","nvt",{"$f":"'Pop Model - do not touch'!C18+'Pop Model - do not touch'!C11","v":0},{"$f":"'Pop Model - do not touch'!D18+'Pop Model - do not touch'!D11","v":0},{"$f":"'Pop Model - do not touch'!E18+'Pop Model - do not touch'!E11","v":0},{"$f":"'Pop Model - do not touch'!F18+'Pop Model - do not touch'!F11","v":0},{"$f":"'Pop Model - do not touch'!G18+'Pop Model - do not touch'!G11","v":0},{"$f":"'Pop Model - do not touch'!H18+'Pop Model - do not touch'!H11","v":0},{"$f":"'Pop Model - do not touch'!I18+'Pop Model - do not touch'!I11","v":0},{"$f":"'Pop Model - do not touch'!J18+'Pop Model - do not touch'!J11","v":0},{"$f":"'Pop Model - do not touch'!K18+'Pop Model - do not touch'!K11","v":0},{"$f":"'Pop Model - do not touch'!L18+'Pop Model - do not touch'!L11","v":0}]
[null,"Cumulatief totaal geëuthanaseerde zwerfkatten","nvt",{"$f":"'Pop Model - do not touch'!C30","v":0},{"$f":"'Pop Model - do not touch'!D30","v":0},{"$f":"'Pop Model - do not touch'!E30","v":0},{"$f":"'Pop Model - do not touch'!F30","v":0},{"$f":"'Pop Model - do not touch'!G30","v":0},{"$f":"'Pop Model - do not touch'!H30","v":0},{"$f":"'Pop Model - do not touch'!I30","v":0},{"$f":"'Pop Model - do not touch'!J30","v":0},{"$f":"'Pop Model - do not touch'!K30","v":0},{"$f":"'Pop Model - do not touch'!L30","v":0}]
[null,"Aantal geëuthanaseerde zwerfkatten (per jaar)","nvt",{"$f":"'Pop Model - do not touch'!C29","v":0},{"$f":"'Pop Model - do not touch'!D29","v":0},{"$f":"'Pop Model - do not touch'!E29","v":0},{"$f":"'Pop Model - do not touch'!F29","v":0},{"$f":"'Pop Model - do not touch'!G29","v":0},{"$f":"'Pop Model - do not touch'!H29","v":0},{"$f":"'Pop Model - do not touch'!I29","v":0},{"$f":"'Pop Model - do not touch'!J29","v":0},{"$f":"'Pop Model - do not touch'!K29","v":0},{"$f":"'Pop Model - do not touch'!L29","v":0}]
[null,"Cumulatief totaal aantal katten naar asiel","nvt",{"$f":"'Pop Model - do not touch'!C32","v":0},{"$f":"'Pop Model - do not touch'!D32","v":0},{"$f":"'Pop Model - do not touch'!E32","v":0},{"$f":"'Pop Model - do not touch'!F32","v":0},{"$f":"'Pop Model - do not touch'!G32","v":0},{"$f":"'Pop Model - do not touch'!H32","v":0},{"$f":"'Pop Model - do not touch'!I32","v":0},{"$f":"'Pop Model - do not touch'!J32","v":0},{"$f":"'Pop Model - do not touch'!K32","v":0},{"$f":"'Pop Model - do not touch'!L32","v":0}]
[null,"Aantal katten naar asiel (per jaar)","nvt",{"$f":"'Pop Model - do not touch'!C31","v":0},{"$f":"'Pop Model - do not touch'!D31","v":0},{"$f":"'Pop Model - do not touch'!E31","v":0},{"$f":"'Pop Model - do not touch'!F31","v":0},{"$f":"'Pop Model - do not touch'!G31","v":0},{"$f":"'Pop Model - do not touch'!H31","v":0},{"$f":"'Pop Model - do not touch'!I31","v":0},{"$f":"'Pop Model - do not touch'!J31","v":0},{"$f":"'Pop Model - do not touch'!K31","v":0},{"$f":"'Pop Model - do not touch'!L31","v":0}]
[null,"Cumulatief totaal teruggeplaatste zwerfkatten na steriel maken","nvt",{"$f":"'Pop Model - do not touch'!C23","v":0},{"$f":"'Pop Model - do not touch'!D23","v":0},{"$f":"'Pop Model - do not touch'!E23","v":0},{"$f":"'Pop Model - do not touch'!F23","v":0},{"$f":"'Pop Model - do not touch'!G23","v":0},{"$f":"'Pop Model - do not touch'!H23","v":0},{"$f":"'Pop Model - do not touch'!I23","v":0},{"$f":"'Pop Model - do not touch'!J23","v":0},{"$f":"'Pop Model - do not touch'!K23","v":0},{"$f":"'Pop Model - do not touch'!L23","v":0}]
[null,"Aantal teruggeplaatste steriele zwerfkatten (per jaar) ","nvt",{"$f":"'Pop Model - do not touch'!C22","v":0},{"$f":"'Pop Model - do not touch'!D22","v":0},{"$f":"'Pop Model - do not touch'!E22","v":0},{"$f":"'Pop Model - do not touch'!F22","v":0},{"$f":"'Pop Model - do not touch'!G22","v":0},{"$f":"'Pop Model - do not touch'!H22","v":0},{"$f":"'Pop Model - do not touch'!I22","v":0},{"$f":"'Pop Model - do not touch'!J22","v":0},{"$f":"'Pop Model - do not touch'!K22","v":0},{"$f":"'Pop Model - do not touch'!L22","v":0}]
[null,"Totale kost voor ingrepen via zwerfkatten"]
[null,"Totale kostprijs per jaar (in euro)","nvt",{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!C9,'Costs and welfare - dont touch'!C10)","v":0},{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!D9,'Costs and welfare - dont touch'!D10)","v":0},{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!E9,'Costs and welfare - dont touch'!E10)","v":0},{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!F9,'Costs and welfare - dont touch'!F10)","v":0},{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!G9,'Costs and welfare - dont touch'!G10)","v":0},{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!H9,'Costs and welfare - dont touch'!H10)","v":0},{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!I9,'Costs and welfare - dont touch'!I10)","v":0},{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!J9,'Costs and welfare - dont touch'!J10)","v":0},{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!K9,'Costs and welfare - dont touch'!K10)","v":0},{"$f":"IF($D$33=0, 'Costs and welfare - dont touch'!L9,'Costs and welfare - dont touch'!L10)","v":0}]
[null,"Cumulatieve kostprijs (in euro)","nvt",{"$f":"D53","v":0},{"$f":"D54+E53","v":0},{"$f":"E54+F53","v":0},0,0,0,0,0,0,0]
[null,"Hinder en Welzijn"]
[null,"Waarde hinderindex (per jaar)",{"$f":"'Costs and welfare - dont touch'!B21","v":113.88165716182372},{"$f":"'Costs and welfare - dont touch'!C21","v":112.01364407543525},{"$f":"'Costs and welfare - dont touch'!D21","v":118.03491079863613},{"$f":"'Costs and welfare - dont touch'!E21","v":125.01735119651907},{"$f":"'Costs and welfare - dont touch'!F21","v":133.37798027227467},{"$f":"'Costs and welfare - dont touch'!G21","v":143.71237731445129},{"$f":"'Costs and welfare - dont touch'!H21","v":156.734585877336},{"$f":"'Costs and welfare - dont touch'!I21","v":173.428207669805},{"$f":"'Costs and welfare - dont touch'!J21","v":195.1069517893097},{"$f":"'Costs and welfare - dont touch'!K21","v":223.47516384899663},{"$f":"'Costs and welfare - dont touch'!L21","v":260.83920753169616}]
[null,"% verandering in hinderindex tov start","nvt",{"$f":"'Costs and welfare - dont touch'!C23","v":-1.6403107690416476},{"$f":"'Costs and welfare - dont touch'!D23","v":3.6469908678187863},{"$f":"'Costs and welfare - dont touch'!E23","v":9.7783034706561551},{"$f":"'Costs and welfare - dont touch'!F23","v":17.119809806373837},{"$f":"'Costs and welfare - dont touch'!G23","v":26.194490751252999},{"$f":"'Costs and welfare - dont touch'!H23","v":37.62935119096403},{"$f":"'Costs and welfare - dont touch'!I23","v":52.288096250098221},{"$f":"'Costs and welfare - dont touch'!J23","v":71.324299849330743},{"$f":"'Costs and welfare - dont touch'!K23","v":96.234555606652748},{"$f":"'Costs and welfare - dont touch'!L23","v":129.04409193927381}]
[null,"% verandering in hinderindex tov voorgaande jaar","nvt",{"$f":"'Costs and welfare - dont touch'!C22","v":-1.6403107690416476},{"$f":"'Costs and welfare - dont touch'!D22","v":5.3754761510534195},{"$f":"'Costs and welfare - dont touch'!E22","v":5.9155722240471533},{"$f":"'Costs and welfare - dont touch'!F22","v":6.6875749611853763},{"$f":"'Costs and welfare - dont touch'!G22","v":7.7482032799418761},{"$f":"'Costs and welfare - dont touch'!H22","v":9.0612992466135012},{"$f":"'Costs and welfare - dont touch'!I22","v":10.650885826523208},{"$f":"'Costs and welfare - dont touch'!J22","v":12.500125793134814},{"$f":"'Costs and welfare - dont touch'!K22","v":14.539826387283682},{"$f":"'Costs and welfare - dont touch'!L22","v":16.719550861565352}]
[null,"Waarde welzijnsindex (per jaar)",{"$f":"'Costs and welfare - dont touch'!B29","v":191.6799754299754},{"$f":"'Costs and welfare - dont touch'!C29","v":191.72886687780812},{"$f":"'Costs and welfare - dont touch'!D29","v":191.34521794162271},{"$f":"'Costs and welfare - dont touch'!E29","v":191.02978611139713},{"$f":"'Costs and welfare - dont touch'!F29","v":190.76387747449937},{"$f":"'Costs and welfare - dont touch'!G29","v":190.5359971474179},{"$f":"'Costs and welfare - dont touch'!H29","v":190.34070058969874},{"$f":"'Costs and welfare - dont touch'!I29","v":190.17419731774692},{"$f":"'Costs and welfare - dont touch'!J29","v":190.03383346862998},{"$f":"'Costs and welfare - dont touch'!K29","v":189.91744716969473},{"$f":"'Costs and welfare - dont touch'!L29","v":189.82256071173197}]
[null,"% verandering in welzijnsindex tov start","nvt",{"$f":"'Costs and welfare - dont touch'!C31","v":2.550681036088065E-2},{"$f":"'Costs and welfare - dont touch'!D31","v":-0.17464395412288525},{"$f":"'Costs and welfare - dont touch'!E31","v":-0.3392056562610577},{"$f":"'Costs and welfare - dont touch'!F31","v":-0.47793096457834849},{"$f":"'Costs and welfare - dont touch'!G31","v":-0.59681679319466241},{"$f":"'Costs and welfare - dont touch'!H31","v":-0.69870357468087718},{"$f":"'Costs and welfare - dont touch'!I31","v":-0.78556881533960166},{"$f":"'Costs and welfare - dont touch'!J31","v":-0.85879704317198957},{"$f":"'Costs and welfare - dont touch'!K31","v":-0.91951611342133788},{"$f":"'Costs and welfare - dont touch'!L31","v":-0.96901865417964927}]
[null,"% verandering in welzijnsindex tov voorgaande jaar","nvt",{"$f":"'Costs and welfare - dont touch'!C32","v":2.550681036088065E-2},{"$f":"'Costs and welfare - dont touch'!D32","v":-0.20009972542628418},{"$f":"'Costs and welfare - dont touch'!E32","v":-0.16484960200145338},{"$f":"'Costs and welfare - dont touch'!F32","v":-0.13919747402255211},{"$f":"'Costs and welfare - dont touch'!G32","v":-0.1194567494110288},{"$f":"'Costs and welfare - dont touch'!H32","v":-0.10249850980549979},{"$f":"'Costs and welfare - dont touch'!I32","v":-8.7476441683762118E-2},{"$f":"'Costs and welfare - dont touch'!J32","v":-7.3808040784001605E-2},{"$f":"'Costs and welfare - dont touch'!K32","v":-6.1245040849243537E-2},{"$f":"'Costs and welfare - dont touch'!L32","v":-4.9961948929293953E-2}]

{"sheet":"Pop Model - do not touch","index":1,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[null,0,1,2,3,4,5,6,7,8,9,10]
["HC_Pop_start",null,{"$f":"IF('Rates - do not touch'!B4=Dashboard!D5,'Rates - do not touch'!B4,Dashboard!D5)","v":6164},{"$f":"C20","v":6164},{"$f":"D20","v":6164},6164,6164,6164,6164,6164,6164,6164,null,"HC pop is stable"]
["HC_GrowthRate",null,{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},{"$f":"'Rates - do not touch'!$B$14","v":2.9017199999999937E-2},null,"GR = Br, AB, Re, Death"]
["HC_PopChange",null,{"$f":"C3*C2","v":178.86202079999961},{"$f":"D3*D2","v":178.86202079999961},178.86202079999961,178.86202079999961,178.86202079999961,{"$f":"H3*H2","v":178.86202079999961},{"$f":"I3*I2","v":178.86202079999961},{"$f":"J3*J2","v":178.86202079999961},{"$f":"K3*K2","v":178.86202079999961},{"$f":"L3*L2","v":178.86202079999961},null,"Positive is how many HC are \"lost\", negative is how many strays are \"gained\""]
[]
["StrayCat_B_Start",null,{"$f":"IF(Dashboard!D6*'Rates - do not touch'!B16 * 0.5 = 'Rates - do not touch'!B5,'Rates - do not touch'!B5,Dashboard!D6*'Rates - do not touch'!B16*0.5)","v":204.24},{"$f":"C10","v":294},{"$f":"D10","v":414},574,787,1072,1452,1959,2636,3539,null,"Start of breeding pop",null,null,"EP (10-11-18): aangepast dat rate niet standaard 0,37 is, maar die van dashboard --> verwijzing naar tab rats B16 ipv handmatige 0,37)"]
["StrayCatGrowth",null,{"$f":"IF(C6>0,C6*'Rates - do not touch'!$B$19,0)","v":68.321927399615987},{"$f":"IF(D6>0,D6*'Rates - do not touch'!$B$19,0)","v":98.348250369599981},{"$f":"IF(E6>0,E6*'Rates - do not touch'!$B$19,0)","v":138.49039337759996},{"$f":"IF(F6>0,F6*'Rates - do not touch'!$B$19,0)","v":192.01325072159995},{"$f":"IF(G6>0,G6*'Rates - do not touch'!$B$19,0)","v":263.26555456079996},{"$f":"IF(H6>0,H6*'Rates - do not touch'!$B$19,0)","v":358.60314420479995},{"$f":"IF(I6>0,I6*'Rates - do not touch'!$B$19,0)","v":485.7199303967999},{"$f":"IF(J6>0,J6*'Rates - do not touch'!$B$19,0)","v":655.32048460559986},{"$f":"IF(K6>0,K6*'Rates - do not touch'!$B$19,0)","v":881.78907474239975},{"$f":"IF(L6>0,L6*'Rates - do not touch'!$B$19,0)","v":1183.8587008775996},null,"From breeding and if HC increase then surplus housecats also go here"]
["StrayCatLoss",null,{"$f":"IF(C6>0,(C6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(C6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(C6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(C6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},{"$f":"IF(D6>0,(D6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(D6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(D6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(D6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},{"$f":"IF(E6>0,(E6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(E6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(E6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(E6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},{"$f":"IF(F6>0,(F6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(F6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(F6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(F6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},{"$f":"IF(G6>0,(G6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(G6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(G6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(G6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},{"$f":"IF(H6>0,(H6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(H6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(H6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(H6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},{"$f":"IF(I6>0,(I6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(I6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(I6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(I6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},{"$f":"IF(J6>0,(J6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(J6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(J6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(J6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},{"$f":"IF(K6>0,(K6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(K6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(K6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(K6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},{"$f":"IF(L6>0,(L6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)+(L6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+(L6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+(L6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32),0)","v":0},null,"From death, TNR, Euth, Shel, Comm"]
["StrayCat_B_2House",null,{"$f":"IF(C3<0,C4*'Rates - do not touch'!B16, C4*'Rates - do not touch'!$B$10)","v":21.463442495999953},{"$f":"IF(D3<0,D4*'Rates - do not touch'!B16, D4*'Rates - do not touch'!$B$10)","v":21.463442495999953},{"$f":"IF(E3<0,E4*'Rates - do not touch'!B16, E4*'Rates - do not touch'!$B$10)","v":21.463442495999953},{"$f":"IF(F3<0,F4*'Rates - do not touch'!B16, F4*'Rates - do not touch'!$B$10)","v":21.463442495999953},{"$f":"IF(G3<0,G4*'Rates - do not touch'!B16, G4*'Rates - do not touch'!$B$10)","v":21.463442495999953},{"$f":"IF(H3<0,H4*'Rates - do not touch'!B16, H4*'Rates - do not touch'!$B$10)","v":21.463442495999953},{"$f":"IF(I3<0,I4*'Rates - do not touch'!B16, I4*'Rates - do not touch'!$B$10)","v":21.463442495999953},{"$f":"IF(J3<0,J4*'Rates - do not touch'!B16, J4*'Rates - do not touch'!$B$10)","v":21.463442495999953},{"$f":"IF(K3<0,K4*'Rates - do not touch'!B16, K4*'Rates - do not touch'!$B$10)","v":21.463442495999953},{"$f":"IF(L3<0,L4*'Rates - do not touch'!B16, L4*'Rates - do not touch'!$B$10)","v":21.463442495999953},null,"Negative: How many stray cats become house cats to maintain HC, Positive: How many HC become stray",null,null,"EP (10-11-18): aangepast dat rate niet standaard 0,37 is, maar die van dashboard --> verwijzing naar tab rats B16 ipv handmatige 0,37)"]
["StrayCatPop_B",{"$f":"'Rates - do not touch'!B5","v":204},{"$f":"IF(ROUND(C6+C7-C8+C9,0) >0,ROUND(C6+C7-C8+C9,0),0)","v":294},{"$f":"IF(ROUND(D6+D7-D8+D9,0) >0,ROUND(D6+D7-D8+D9,0),0)","v":414},574,787,1072,1452,1959,2636,3539,4744,null,"Final pop of breeding stray cats"]
["StrayCat_B_2CC",null,{"$f":"(C6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"(D6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"(E6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"(F6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"(G6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"(H6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"(I6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"(J6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"(K6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"(L6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0}]
[]
["StrayCat_NB_Start",null,{"$f":"IF(Dashboard!D6*(1-'Rates - do not touch'!B16)+'Pop Model - do not touch'!C6='Rates - do not touch'!B6,'Rates - do not touch'!B6,Dashboard!D6*(1-'Rates - do not touch'!B16)+'Pop Model - do not touch'!C6)","v":899.76},{"$f":"C17","v":751.24017830399953},{"$f":"D17","v":833.51473877759929},907.56184320383909,974.20423718745496,1034.1823917727093,1088.1627308994382,1136.7450361134938,1180.4691108061443,1219.8207780295297,null,"Start of non breeding pop",null,null,"EP (10-11-18): aangepast dat rate niet standaard 0,37 is, maar die van dashboard --> verwijzing naar tab rats B16 ipv handmatige 0,37)"]
["StrayCat_NB_Growth",null,{"$f":"IF(C4>0,C4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},{"$f":"IF(D4>0,D4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},{"$f":"IF(E4>0,E4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},{"$f":"IF(F4>0,F4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},{"$f":"IF(G4>0,G4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},{"$f":"IF(H4>0,H4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},{"$f":"IF(I4>0,I4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},{"$f":"IF(J4>0,J4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},{"$f":"IF(K4>0,K4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},{"$f":"IF(L4>0,L4*(1-'Rates - do not touch'!$B$10),0)","v":157.39857830399967},null,"Growth of non breeding pop only non zero when HC GR is positive and some non breeding housecats become stray"]
["StrayCat_NB_Loss",null,{"$f":"(C13*'Rates - do not touch'!$B$21)+(C13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!C13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!C13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":305.91840000000002},{"$f":"(D13*0.1)+(D13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!D13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!D13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(D16*-1)","v":75.12401783039995},{"$f":"(E13*0.1)+(E13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!E13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!E13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(E16*-1)","v":83.351473877759929},{"$f":"(F13*0.1)+(F13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!F13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!F13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(F16*-1)","v":90.756184320383909},{"$f":"(G13*0.1)+(G13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!G13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!G13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(G16*-1)","v":97.420423718745496},{"$f":"(H13*0.1)+(H13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!H13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!H13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(H16*-1)","v":103.41823917727093},{"$f":"(I13*0.1)+(I13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!I13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!I13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(I16*-1)","v":108.81627308994382},{"$f":"(J13*0.1)+(J13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!J13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!J13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(J16*-1)","v":113.67450361134939},{"$f":"(K13*0.1)+(K13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!K13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!K13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(K16*-1)","v":118.04691108061444},{"$f":"(L13*0.1)+(L13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!L13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!L13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(L16*-1)","v":121.98207780295297},null,"Loss from treatments and becoming community cats and by death"]
["StrayCat_NB_2House",null,{"$f":"IF(C4<0,C4*(1-'Rates - do not touch'!B16),0)","v":0},{"$f":"IF(D4<0,D4*(1-'Rates - do not touch'!B16),0)","v":0},{"$f":"IF(E4<0,E4*(1-'Rates - do not touch'!B16),0)","v":0},{"$f":"IF(F4<0,F4*(1-'Rates - do not touch'!B16),0)","v":0},{"$f":"IF(G4<0,G4*(1-'Rates - do not touch'!B16),0)","v":0},{"$f":"IF(H4<0,H4*(1-'Rates - do not touch'!B16),0)","v":0},{"$f":"IF(I4<0,I4*(1-'Rates - do not touch'!B16),0)","v":0},{"$f":"IF(J4<0,J4*(1-'Rates - do not touch'!B16),0)","v":0},{"$f":"IF(K4<0,K4*(1-'Rates - do not touch'!B16),0)","v":0},{"$f":"IF(L4<0,L4*(1-'Rates - do not touch'!B16),0)","v":0},null,"Go to become housecats",null,null,"EP (10-11-18): aangepast dat rate niet standaard 0,37 is, maar die van dashboard --> verwijzing naar tab rats B16 ipv handmatige 0,37)"]
["StrayCatPop_NB",{"$f":"'Rates - do not touch'!B6","v":900},{"$f":"IF(C13+C14-C15+C16>0,C13+C14-C15+C16,0)","v":751.24017830399953},{"$f":"IF(D13+D14-D15+D16>0,D13+D14-D15+D16,0)","v":833.51473877759929},907.56184320383909,974.20423718745496,1034.1823917727093,1088.1627308994382,1136.7450361134938,1180.4691108061443,1219.8207780295297,1255.2372785305765]
["StrayCat_NB_2CC",null,{"$f":"('Pop Model - do not touch'!C13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"('Pop Model - do not touch'!D13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"('Pop Model - do not touch'!E13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"('Pop Model - do not touch'!F13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"('Pop Model - do not touch'!G13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"('Pop Model - do not touch'!H13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"('Pop Model - do not touch'!I13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"('Pop Model - do not touch'!J13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"('Pop Model - do not touch'!K13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0},{"$f":"('Pop Model - do not touch'!L13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"What proportion of cats are people likely to take from strays vs shelter? At the moment all the shortfall is taken up by strays"]
["HC_EndPop",{"$f":"'Rates - do not touch'!B4","v":6164},{"$f":"IF(C3>0,C2-C4+C9+C14, C2+C4-C9-C16)","v":6164},{"$f":"IF(D3>0,D2-D4+D9+D14, D2+D4-D9-D16)","v":6164},6164,6164,6164,6164,6164,6164,6164,6164,null,"Checks that HC stays stable"]
[]
["TNR_Pop",null,{"$f":"(C6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},{"$f":"(D6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},{"$f":"(E6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},{"$f":"(F6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},{"$f":"(G6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},{"$f":"(H6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},{"$f":"(I6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},{"$f":"(J6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},{"$f":"(K6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},{"$f":"(L6*'Rates - do not touch'!$B$27*'Rates - do not touch'!$B$32)","v":0},null,"TNR pop without death"]
["Cum_TNR",null,{"$f":"C22","v":0},{"$f":"D22+C23","v":0},{"$f":"E22+D23","v":0},0,0,{"$f":"H22+G23","v":0},{"$f":"I22+H23","v":0},{"$f":"J22+I23","v":0},{"$f":"K22+J23","v":0},{"$f":"L22+K23","v":0},null,"Cumulative amount of TNR"]
["CC_Pop",{"$f":"Dashboard!D8","v":117},{"$f":"(C13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+(C6*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Rates - do not touch'!B8+('Rates - do not touch'!B8*'Rates - do not touch'!$B$23)","v":113.49},{"$f":"C24+(D13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Pop Model - do not touch'!C24*'Rates - do not touch'!$B$23","v":110.08529999999999},{"$f":"D24+(E13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Pop Model - do not touch'!D24*'Rates - do not touch'!$B$23","v":106.78274099999999},{"$f":"E24+(F13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Pop Model - do not touch'!E24*'Rates - do not touch'!$B$23","v":103.57925876999998},{"$f":"F24+(G13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Pop Model - do not touch'!F24*'Rates - do not touch'!$B$23","v":100.47188100689998},{"$f":"G24+(H13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Pop Model - do not touch'!G24*'Rates - do not touch'!$B$23","v":97.457724576692982},{"$f":"H24+(I13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Pop Model - do not touch'!H24*'Rates - do not touch'!$B$23","v":94.533992839392198},{"$f":"I24+(J13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Pop Model - do not touch'!I24*'Rates - do not touch'!$B$23","v":91.697973054210436},{"$f":"J24+(K13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Pop Model - do not touch'!J24*'Rates - do not touch'!$B$23","v":88.947033862584121},{"$f":"K24+(L13*'Rates - do not touch'!$B$30*'Rates - do not touch'!$B$32)+'Pop Model - do not touch'!K24*'Rates - do not touch'!$B$23","v":86.278622846706597},null,"CC pop with death a dn growth rate"]
["CC_New",null,{"$f":"IF(C24-'Rates - do not touch'!B8>0,C24-'Rates - do not touch'!B8,0)","v":0},{"$f":"IF(D24-C24>0,D24-C24,0)","v":0},{"$f":"IF(E24-D24>0,E24-D24,0)","v":0},0,0,0,0,0,0,0]
["Cats being managed"]
[]
["Stray_Pop",{"$f":"C6+C13","v":1104},{"$f":"((C22)*1-'Rates - do not touch'!$B$21)+C10+C17","v":1044.9001783039996},{"$f":"((D22)*1-'Rates - do not touch'!$B$21)+D10+D17","v":1247.1747387775993},{"$f":"((E22)*1-'Rates - do not touch'!$B$21)+E10+E17","v":1481.2218432038389},{"$f":"((F22)*1-'Rates - do not touch'!$B$21)+F10+F17","v":1760.8642371874548},{"$f":"((G22)*1-'Rates - do not touch'!$B$21)+G10+G17","v":2105.8423917727096},{"$f":"((H22)*1-'Rates - do not touch'!$B$21)+H10+H17","v":2539.8227308994383},{"$f":"((I22)*1-'Rates - do not touch'!$B$21)+I10+I17","v":3095.4050361134941},{"$f":"((J22)*1-'Rates - do not touch'!$B$21)+J10+J17","v":3816.1291108061441},{"$f":"((K22)*1-'Rates - do not touch'!$B$21)+K10+K17","v":4758.4807780295296},{"$f":"((L22)*1-'Rates - do not touch'!$B$21)+L10+L17","v":5998.8972785305759},null,"((TNR)*1-deathrate)+Breeding + NonBreeding strays",null,null,"EP (10-11-18): berekening B28 aangepast dat niet B10 en B17 worden opgeteld (die wijzen naar rates tab met handmatige 0,37), maar wel C6 en C13, die de startpopulaties berekenen op basis van wat in dashboard wordt ingevuld."]
["Euth_Pop",0,{"$f":"(C6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!C13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0},{"$f":"(D6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!D13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0},{"$f":"(E6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!E13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0},{"$f":"(F6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!F13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0},{"$f":"(G6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!G13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0},{"$f":"(H6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!H13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0},{"$f":"(I6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!I13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0},{"$f":"(J6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!J13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0},{"$f":"(K6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!K13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0},{"$f":"(L6*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!L13*'Rates - do not touch'!$B$29*'Rates - do not touch'!$B$32)","v":0}]
["Cum_Euth",0,{"$f":"C29","v":0},{"$f":"C30+D29","v":0},{"$f":"D30+E29","v":0},0,0,{"$f":"G30+H29","v":0},{"$f":"H30+I29","v":0},{"$f":"I30+J29","v":0},{"$f":"J30+K29","v":0},{"$f":"K30+L29","v":0}]
["Shel_Pop",0,{"$f":"(C6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!C13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0},{"$f":"(D6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!D13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0},{"$f":"(E6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!E13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0},{"$f":"(F6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!F13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0},{"$f":"(G6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!G13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0},{"$f":"(H6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!H13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0},{"$f":"(I6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!I13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0},{"$f":"(J6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!J13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0},{"$f":"(K6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!K13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0},{"$f":"(L6*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)+('Pop Model - do not touch'!L13*'Rates - do not touch'!$B$28*'Rates - do not touch'!$B$32)","v":0}]
["Cum_Shel",0,{"$f":"C31","v":0},{"$f":"C32+D31","v":0},{"$f":"D32+E31","v":0},0,0,{"$f":"G32+H31","v":0},{"$f":"H32+I31","v":0},{"$f":"I32+J31","v":0},{"$f":"J32+K31","v":0},{"$f":"K32+L31","v":0}]
[]
["%Stray Change year on year",100,{"$f":"IF(C28>0,(C28/B28)*100,0)","v":94.646755281159386},{"$f":"IF(D28>0,(D28/C28)*100,0)","v":119.35826643286786},118.76618385132124,118.87917027869084,119.59141126838217,120.6083959949824,121.87484576993705,123.28367584481195,124.69391469368595,126.06748999025481]
["%CC Change year on year",{"$f":"B24","v":117},{"$f":"IF(C24>0,(C24/B24)*100,0)","v":97},{"$f":"IF(D24>0,(D24/C24)*100,0)","v":97},97,97,97,97.000000000000014,97.000000000000014,97.000000000000014,97,97]
["%HC Change year on year",100,{"$f":"IF(C2>0,(C2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(D2>0,(D2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(E2>0,(E2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(F2>0,(F2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(G2>0,(G2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(H2>0,(H2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(I2>0,(I2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(J2>0,(J2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(K2>0,(K2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(L2>0,(L2/'Rates - do not touch'!$B$4)*100,0)","v":100}]
["%B_Stray change year on year"]
[]
["%Stray Change from first year",100,{"$f":"IF(C28>0,(C28/$B$28)*100,0)","v":94.646755281159386},{"$f":"IF(D28>0,(D28/$B$28)*100,0)","v":112.96872633855067},134.16864521773903,159.49857220900859,190.74659345767299,230.05640678436941,280.38089095230924,345.66386873244056,431.02180960412409,543.37837667849419,null,"dit is hoeveel procent van de oorspronkelijke populatie er nog over is (EP)"]
["%CC Change from first year",100,{"$f":"IF(C24>0,(C24/$B$24)*100,0)","v":97},{"$f":"IF(D24>0,(D24/$B$24)*100,0)","v":94.089999999999989},91.267299999999977,88.529280999999983,85.873402569999982,83.297200492899975,80.79828447811299,78.374335943769609,76.023105865456515,73.742412689492824]
["%HC Change from first year",100,{"$f":"IF(C2>0,(C2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(D2>0,(D2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(E2>0,(E2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(F2>0,(F2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(G2>0,(G2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(H2>0,(H2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(I2>0,(I2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(J2>0,(J2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(K2>0,(K2/'Rates - do not touch'!$B$4)*100,0)","v":100},{"$f":"IF(L2>0,(L2/'Rates - do not touch'!$B$4)*100,0)","v":100}]
["%BreedingStray Change",100,{"$f":"IF(C10>0,(C10/$B$10)*100,0)","v":144.11764705882354},{"$f":"IF(D10>0,(D10/$B$10)*100,0)","v":202.94117647058823},281.37254901960785,385.78431372549022,525.49019607843138,711.76470588235293,960.2941176470589,1292.1568627450981,1734.8039215686274,2325.4901960784314]

{"sheet":"Costs and welfare - dont touch","index":2,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
["Year",0,1,2,3,4,5,6,7,8,9,10]
["Costs"]
["CatsTNR",0,{"$f":"IF('Pop Model - do not touch'!C22>0,('Pop Model - do not touch'!C22*Dashboard!$K$29),0)","v":0},{"$f":"IF('Pop Model - do not touch'!D22>0,('Pop Model - do not touch'!D22*Dashboard!$K$29),0)","v":0},{"$f":"IF('Pop Model - do not touch'!E22>0,('Pop Model - do not touch'!E22*Dashboard!$K$29),0)","v":0},{"$f":"IF('Pop Model - do not touch'!F22>0,('Pop Model - do not touch'!F22*Dashboard!$K$29),0)","v":0},{"$f":"IF('Pop Model - do not touch'!G22>0,('Pop Model - do not touch'!G22*Dashboard!$K$29),0)","v":0},{"$f":"IF('Pop Model - do not touch'!H22>0,('Pop Model - do not touch'!H22*Dashboard!$K$29),0)","v":0},{"$f":"IF('Pop Model - do not touch'!I22>0,('Pop Model - do not touch'!I22*Dashboard!$K$29),0)","v":0},{"$f":"IF('Pop Model - do not touch'!J22>0,('Pop Model - do not touch'!J22*Dashboard!$K$29),0)","v":0},{"$f":"IF('Pop Model - do not touch'!K22>0,('Pop Model - do not touch'!K22*Dashboard!$K$29),0)","v":0},{"$f":"IF('Pop Model - do not touch'!L22>0,('Pop Model - do not touch'!L22*Dashboard!$K$29),0)","v":0}]
["CatsEuth",0,{"$f":"IF('Pop Model - do not touch'!C29>0, 'Pop Model - do not touch'!C29*Dashboard!$K$31,0)","v":0},{"$f":"IF('Pop Model - do not touch'!D29>0, 'Pop Model - do not touch'!D29*Dashboard!$K$31,0)","v":0},{"$f":"IF('Pop Model - do not touch'!E29>0, 'Pop Model - do not touch'!E29*Dashboard!$K$31,0)","v":0},{"$f":"IF('Pop Model - do not touch'!F29>0, 'Pop Model - do not touch'!F29*Dashboard!$K$31,0)","v":0},{"$f":"IF('Pop Model - do not touch'!G29>0, 'Pop Model - do not touch'!G29*Dashboard!$K$31,0)","v":0},{"$f":"IF('Pop Model - do not touch'!H29>0, 'Pop Model - do not touch'!H29*Dashboard!$K$31,0)","v":0},{"$f":"IF('Pop Model - do not touch'!I29>0, 'Pop Model - do not touch'!I29*Dashboard!$K$31,0)","v":0},{"$f":"IF('Pop Model - do not touch'!J29>0, 'Pop Model - do not touch'!J29*Dashboard!$K$31,0)","v":0},{"$f":"IF('Pop Model - do not touch'!K29>0, 'Pop Model - do not touch'!K29*Dashboard!$K$31,0)","v":0},{"$f":"IF('Pop Model - do not touch'!L29>0, 'Pop Model - do not touch'!L29*Dashboard!$K$31,0)","v":0}]
["NBCatsCC",0,{"$f":"IF('Pop Model - do not touch'!C18>0,'Pop Model - do not touch'!C18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0},{"$f":"IF('Pop Model - do not touch'!D18>0,'Pop Model - do not touch'!D18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0},{"$f":"IF('Pop Model - do not touch'!E18>0,'Pop Model - do not touch'!E18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0},{"$f":"IF('Pop Model - do not touch'!F18>0,'Pop Model - do not touch'!F18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0},{"$f":"IF('Pop Model - do not touch'!G18>0,'Pop Model - do not touch'!G18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0},{"$f":"IF('Pop Model - do not touch'!H18>0,'Pop Model - do not touch'!H18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0},{"$f":"IF('Pop Model - do not touch'!I18>0,'Pop Model - do not touch'!I18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0},{"$f":"IF('Pop Model - do not touch'!J18>0,'Pop Model - do not touch'!J18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0},{"$f":"IF('Pop Model - do not touch'!K18>0,'Pop Model - do not touch'!K18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0},{"$f":"IF('Pop Model - do not touch'!L18>0,'Pop Model - do not touch'!L18*(Dashboard!$K$30-Dashboard!$D$23),0)","v":0}]
["BCatsCC",null,{"$f":"IF('Pop Model - do not touch'!C11>0,'Pop Model - do not touch'!C11*Dashboard!$K$30,0)","v":0},{"$f":"IF('Pop Model - do not touch'!D11>0,'Pop Model - do not touch'!D11*Dashboard!$K$30,0)","v":0},{"$f":"IF('Pop Model - do not touch'!E11>0,'Pop Model - do not touch'!E11*Dashboard!$K$30,0)","v":0},{"$f":"IF('Pop Model - do not touch'!F11>0,'Pop Model - do not touch'!F11*Dashboard!$K$30,0)","v":0},{"$f":"IF('Pop Model - do not touch'!G11>0,'Pop Model - do not touch'!G11*Dashboard!$K$30,0)","v":0},{"$f":"IF('Pop Model - do not touch'!H11>0,'Pop Model - do not touch'!H11*Dashboard!$K$30,0)","v":0},{"$f":"IF('Pop Model - do not touch'!I11>0,'Pop Model - do not touch'!I11*Dashboard!$K$30,0)","v":0},{"$f":"IF('Pop Model - do not touch'!J11>0,'Pop Model - do not touch'!J11*Dashboard!$K$30,0)","v":0},{"$f":"IF('Pop Model - do not touch'!K11>0,'Pop Model - do not touch'!K11*Dashboard!$K$30,0)","v":0},{"$f":"IF('Pop Model - do not touch'!L11>0,'Pop Model - do not touch'!L11*Dashboard!$K$30,0)","v":0}]
["ShelterCost",null,{"$f":"IF('Pop Model - do not touch'!C31>0,'Pop Model - do not touch'!C31*Dashboard!$K$32,0)","v":0},{"$f":"IF('Pop Model - do not touch'!D31>0,'Pop Model - do not touch'!D31*Dashboard!$K$32,0)","v":0},{"$f":"IF('Pop Model - do not touch'!E31>0,'Pop Model - do not touch'!E31*Dashboard!$K$32,0)","v":0},{"$f":"IF('Pop Model - do not touch'!F31>0,'Pop Model - do not touch'!F31*Dashboard!$K$32,0)","v":0},{"$f":"IF('Pop Model - do not touch'!G31>0,'Pop Model - do not touch'!G31*Dashboard!$K$32,0)","v":0},{"$f":"IF('Pop Model - do not touch'!H31>0,'Pop Model - do not touch'!H31*Dashboard!$K$32,0)","v":0},{"$f":"IF('Pop Model - do not touch'!I31>0,'Pop Model - do not touch'!I31*Dashboard!$K$32,0)","v":0},{"$f":"IF('Pop Model - do not touch'!J31>0,'Pop Model - do not touch'!J31*Dashboard!$K$32,0)","v":0},{"$f":"IF('Pop Model - do not touch'!K31>0,'Pop Model - do not touch'!K31*Dashboard!$K$32,0)","v":0},{"$f":"IF('Pop Model - do not touch'!L31>0,'Pop Model - do not touch'!L31*Dashboard!$K$32,0)","v":0}]
["FullCost",null,{"$f":"SUM(C4:C8)","v":0},{"$f":"SUM(D4:D8)","v":0},{"$f":"SUM(E4:E8)","v":0},0,0,0,0,0,0,0,"EP: sheltercost included in full cost 7-11-18"]
["ContractCost",null,{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!C22,'Pop Model - do not touch'!C29,'Pop Model - do not touch'!C18,'Pop Model - do not touch'!C11,'Pop Model - do not touch'!C31)*Dashboard!$D$33,0)","v":0},{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!D22,'Pop Model - do not touch'!D29,'Pop Model - do not touch'!D18,'Pop Model - do not touch'!D11,'Pop Model - do not touch'!D31)*Dashboard!$D$33,0)","v":0},{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!E22,'Pop Model - do not touch'!E29,'Pop Model - do not touch'!E18,'Pop Model - do not touch'!E11,'Pop Model - do not touch'!E31)*Dashboard!$D$33,0)","v":0},{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!F22,'Pop Model - do not touch'!F29,'Pop Model - do not touch'!F18,'Pop Model - do not touch'!F11,'Pop Model - do not touch'!F31)*Dashboard!$D$33,0)","v":0},{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!G22,'Pop Model - do not touch'!G29,'Pop Model - do not touch'!G18,'Pop Model - do not touch'!G11,'Pop Model - do not touch'!G31)*Dashboard!$D$33,0)","v":0},{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!H22,'Pop Model - do not touch'!H29,'Pop Model - do not touch'!H18,'Pop Model - do not touch'!H11,'Pop Model - do not touch'!H31)*Dashboard!$D$33,0)","v":0},{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!I22,'Pop Model - do not touch'!I29,'Pop Model - do not touch'!I18,'Pop Model - do not touch'!I11,'Pop Model - do not touch'!I31)*Dashboard!$D$33,0)","v":0},{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!J22,'Pop Model - do not touch'!J29,'Pop Model - do not touch'!J18,'Pop Model - do not touch'!J11,'Pop Model - do not touch'!J31)*Dashboard!$D$33,0)","v":0},{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!K22,'Pop Model - do not touch'!K29,'Pop Model - do not touch'!K18,'Pop Model - do not touch'!K11,'Pop Model - do not touch'!K31)*Dashboard!$D$33,0)","v":0},{"$f":"IF(Dashboard!$D$33>0,SUM('Pop Model - do not touch'!L22,'Pop Model - do not touch'!L29,'Pop Model - do not touch'!L18,'Pop Model - do not touch'!L11,'Pop Model - do not touch'!L31)*Dashboard!$D$33,0)","v":0}]
[]
["Plot_CostContract",null,{"$f":"IF(C10=0,NA(),C10)","v":{"$error":"#N/A"}},{"$f":"IF(D10=0,NA(),D10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Plot_CostTNR",null,{"$f":"IF(C10>0,NA(),C4)","v":0},{"$f":"IF(D10>0,NA(),D4)","v":0},0,0,0,0,0,0,0,0]
["Plot_CostEuth",null,{"$f":"IF(C10>0,NA(),C5)","v":0},{"$f":"IF(D10>0,NA(),D5)","v":0},0,0,0,0,0,0,0,0]
["Plot_CC",null,{"$f":"IF(C10>0, NA(), SUM(C6:C7))","v":0},{"$f":"IF(D10>0, NA(), SUM(D6:D7))","v":0},0,0,0,0,0,0,0,0]
[]
["Habitat",{"$f":"Dashboard!$D$9","v":"Alle"}]
["Nuisance"]
["PropFreeHC",{"$f":"IF(B17=\"Halfstedelijk\",'Rates - do not touch'!$E$36*'Rates - do not touch'!$H$36,IF(B17=\"Stedelijk\",'Rates - do not touch'!$E$35*'Rates - do not touch'!$H$35,IF(B17=\"Landelijk\",'Rates - do not touch'!$E$37*'Rates - do not touch'!$H$37,IF(B17=\"Industrieel\",'Rates - do not touch'!$E$38*'Rates - do not touch'!$H$38,IF(B17=\"Alle\",'Rates - do not touch'!$E$39*'Rates - do not touch'!$H$39)))))","v":0.52249999999999996}]
["PropFreeCC",{"$f":"IF(B17=\"Halfstedelijk\",'Rates - do not touch'!$F$36*'Rates - do not touch'!$I$36,IF(B17=\"Stedelijk\",'Rates - do not touch'!$F$35*'Rates - do not touch'!$I$35,IF(B17=\"Landelijk\",'Rates - do not touch'!$F$37*'Rates - do not touch'!$I$37,IF(B17=\"Industrieel\",'Rates - do not touch'!$F$38*'Rates - do not touch'!$I$38,IF(B17=\"Alle\",'Rates - do not touch'!$F$39*'Rates - do not touch'!$I$39)))))","v":1}]
["NuisanceFactor",{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!B20)+'Pop Model - do not touch'!B24)*0.8)+'Pop Model - do not touch'!B28)/(Dashboard!$D$4/1000),0)","v":113.88165716182372},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!C20)+'Pop Model - do not touch'!C24)*0.8)+'Pop Model - do not touch'!C28)/(Dashboard!$D$4/1000),0)","v":112.01364407543525},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!D20)+'Pop Model - do not touch'!D24)*0.8)+'Pop Model - do not touch'!D28)/(Dashboard!$D$4/1000),0)","v":118.03491079863613},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!E20)+'Pop Model - do not touch'!E24)*0.8)+'Pop Model - do not touch'!E28)/(Dashboard!$D$4/1000),0)","v":125.01735119651907},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!F20)+'Pop Model - do not touch'!F24)*0.8)+'Pop Model - do not touch'!F28)/(Dashboard!$D$4/1000),0)","v":133.37798027227467},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!G20)+'Pop Model - do not touch'!G24)*0.8)+'Pop Model - do not touch'!G28)/(Dashboard!$D$4/1000),0)","v":143.71237731445129},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!H20)+'Pop Model - do not touch'!H24)*0.8)+'Pop Model - do not touch'!H28)/(Dashboard!$D$4/1000),0)","v":156.734585877336},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!I20)+'Pop Model - do not touch'!I24)*0.8)+'Pop Model - do not touch'!I28)/(Dashboard!$D$4/1000),0)","v":173.428207669805},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!J20)+'Pop Model - do not touch'!J24)*0.8)+'Pop Model - do not touch'!J28)/(Dashboard!$D$4/1000),0)","v":195.1069517893097},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!K20)+'Pop Model - do not touch'!K24)*0.8)+'Pop Model - do not touch'!K28)/(Dashboard!$D$4/1000),0)","v":223.47516384899663},{"$f":"IF(Dashboard!$D$4>0,(((($B$19*'Pop Model - do not touch'!L20)+'Pop Model - do not touch'!L24)*0.8)+'Pop Model - do not touch'!L28)/(Dashboard!$D$4/1000),0)","v":260.83920753169616},"EP: berekening voor jaar 0 (9-11-18)"]
["Year on year % change in nuisance",null,{"$f":"IF(B21>0,(100-(C21/B21)*100)*-1,0)","v":-1.6403107690416476},{"$f":"IF(C21>0,(100-(D21/C21)*100)*-1,0)","v":5.3754761510534195},{"$f":"IF(D21>0,(100-(E21/D21)*100)*-1,0)","v":5.9155722240471533},6.6875749611853763,7.7482032799418761,9.0612992466135012,10.650885826523208,12.500125793134814,14.539826387283682,16.719550861565352]
[null,null,{"$f":"IF(B21>0,(100-(C21/$B$21)*100)*-1,0)","v":-1.6403107690416476},{"$f":"IF(C21>0,(100-(D21/$B$21)*100)*-1,0)","v":3.6469908678187863},{"$f":"IF(D21>0,(100-(E21/$B$21)*100)*-1,0)","v":9.7783034706561551},17.119809806373837,26.194490751252999,37.62935119096403,52.288096250098221,71.324299849330743,96.234555606652748,129.04409193927381,"EP: aangepast: berekening tov jaar 0 ipv tov jaar 1"]
["Welfare"]
["PropFreeSC",0.25,null,null,null,null,null,null,null,null,null,null,"EP: 0,25 komt omdat we 4 habitats hebben en ervan uitgaan dat er overal evenveel SC zitten"]
["WelfareCC",{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!B24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!B24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!B24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!B24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!B24*'Rates - do not touch'!$C$39)))))","v":248.33250000000001},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!C24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!C24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!C24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!C24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!C24*'Rates - do not touch'!$C$39)))))","v":240.88252499999999},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!D24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!D24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!D24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!D24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!D24*'Rates - do not touch'!$C$39)))))","v":233.65604925},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!E24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!E24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!E24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!E24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!E24*'Rates - do not touch'!$C$39)))))","v":226.64636777249999},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!F24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!F24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!F24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!F24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!F24*'Rates - do not touch'!$C$39)))))","v":219.84697673932496},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!G24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!G24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!G24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!G24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!G24*'Rates - do not touch'!$C$39)))))","v":213.25156743714521},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!H24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!H24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!H24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!H24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!H24*'Rates - do not touch'!$C$39)))))","v":206.85402041403086},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!I24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!I24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!I24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!I24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!I24*'Rates - do not touch'!$C$39)))))","v":200.64839980160994},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!J24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!J24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!J24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!J24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!J24*'Rates - do not touch'!$C$39)))))","v":194.62894780756164},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!K24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!K24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!K24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!K24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!K24*'Rates - do not touch'!$C$39)))))","v":188.79007937333481},{"$f":"IF($B$17 = \"Stedelijk\",$B$20*'Pop Model - do not touch'!L24*'Rates - do not touch'!$C$35, IF($B$17 = \"Halfstedelijk\",$B$20*'Pop Model - do not touch'!L24*'Rates - do not touch'!$C$36, IF($B$17 = \"Landelijk\",$B$20*'Pop Model - do not touch'!L24*'Rates - do not touch'!$C$37, IF($B$17 = \"Industrieel\",$B$20*'Pop Model - do not touch'!L24*'Rates - do not touch'!$C$38, IF($B$17 = \"Alle\",$B$20*'Pop Model - do not touch'!L24*'Rates - do not touch'!$C$39)))))","v":183.12637699213477},"EP: berekening voor jaar 0 (10-11-18)"]
["WelfareSC",{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!B28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!B28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!B28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!B28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!B28*'Rates - do not touch'!$D$39)))))","v":2092.08},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!C28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!C28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!C28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!C28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!C28*'Rates - do not touch'!$D$39)))))","v":1980.0858378860794},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!D28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!D28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!D28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!D28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!D28*'Rates - do not touch'!$D$39)))))","v":2363.3961299835505},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!E28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!E28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!E28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!E28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!E28*'Rates - do not touch'!$D$39)))))","v":2806.9153928712749},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!F28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!F28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!F28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!F28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!F28*'Rates - do not touch'!$D$39)))))","v":3336.8377294702268},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!G28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!G28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!G28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!G28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!G28*'Rates - do not touch'!$D$39)))))","v":3990.5713324092849},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!H28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!H28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!H28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!H28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!H28*'Rates - do not touch'!$D$39)))))","v":4812.9640750544359},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!I28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!I28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!I28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!I28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!I28*'Rates - do not touch'!$D$39)))))","v":5865.7925434350718},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!J28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!J28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!J28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!J28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!J28*'Rates - do not touch'!$D$39)))))","v":7231.5646649776436},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!K28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!K28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!K28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!K28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!K28*'Rates - do not touch'!$D$39)))))","v":9017.3210743659583},{"$f":"IF($B$17=\"Stedelijk\",'Pop Model - do not touch'!L28*'Rates - do not touch'!$D$35,IF($B$17=\"Halfstedelijk\",'Pop Model - do not touch'!L28*'Rates - do not touch'!$D$36,IF($B$17=\"Landelijk\",'Pop Model - do not touch'!L28*'Rates - do not touch'!$D$37,IF($B$17=\"Industrieel\",'Pop Model - do not touch'!L28*'Rates - do not touch'!$D$38,IF($B$17=\"Alle\",'Pop Model - do not touch'!L28*'Rates - do not touch'!$D$39)))))","v":11367.910342815441},"EP: berekening voor jaar 0 (10-11-18)"]
[]
["WelfareScore",{"$f":"(SUM(B26:B27)/('Pop Model - do not touch'!B28+'Pop Model - do not touch'!B24))*100","v":191.6799754299754},{"$f":"(SUM(C26:C27)/('Pop Model - do not touch'!C28+'Pop Model - do not touch'!C24))*100","v":191.72886687780812},{"$f":"(SUM(D26:D27)/('Pop Model - do not touch'!D28+'Pop Model - do not touch'!D24))*100","v":191.34521794162271},{"$f":"(SUM(E26:E27)/('Pop Model - do not touch'!E28+'Pop Model - do not touch'!E24))*100","v":191.02978611139713},{"$f":"(SUM(F26:F27)/('Pop Model - do not touch'!F28+'Pop Model - do not touch'!F24))*100","v":190.76387747449937},{"$f":"(SUM(G26:G27)/('Pop Model - do not touch'!G28+'Pop Model - do not touch'!G24))*100","v":190.5359971474179},{"$f":"(SUM(H26:H27)/('Pop Model - do not touch'!H28+'Pop Model - do not touch'!H24))*100","v":190.34070058969874},{"$f":"(SUM(I26:I27)/('Pop Model - do not touch'!I28+'Pop Model - do not touch'!I24))*100","v":190.17419731774692},{"$f":"(SUM(J26:J27)/('Pop Model - do not touch'!J28+'Pop Model - do not touch'!J24))*100","v":190.03383346862998},{"$f":"(SUM(K26:K27)/('Pop Model - do not touch'!K28+'Pop Model - do not touch'!K24))*100","v":189.91744716969473},{"$f":"(SUM(L26:L27)/('Pop Model - do not touch'!L28+'Pop Model - do not touch'!L24))*100","v":189.82256071173197},"EP: in B29 stond handmatig '190' ingetypt, zonder berekening. Lijkt me dat toch toch per startpopulatie verschillend is? Daarom zelfde formule als C29 toegepast. (10-11-18)"]
["wijziging tov voorgaande jaar",1,{"$f":"(C29/B29)*100","v":100.02550681036088},{"$f":"(D29/C29)*100","v":99.799900274573716},99.835150397998547,99.860802525977448,99.880543250588971,99.8975014901945,99.912523558316238,99.926191959215998,99.938754959150756,99.950038051070706]
["% verandering in welzijnsindex tov start",null,{"$f":"((C29/$B$29)*100)-100","v":2.550681036088065E-2},{"$f":"((D29/$B$29)*100)-100","v":-0.17464395412288525},-0.3392056562610577,-0.47793096457834849,-0.59681679319466241,-0.69870357468087718,-0.78556881533960166,-0.85879704317198957,-0.91951611342133788,-0.96901865417964927]
["% verandering in welzijnsindex tov voorgaande jaar",null,{"$f":"((C29/B29)*100)-100","v":2.550681036088065E-2},{"$f":"((D29/C29)*100)-100","v":-0.20009972542628418},-0.16484960200145338,-0.13919747402255211,-0.1194567494110288,-0.10249850980549979,-8.7476441683762118E-2,-7.3808040784001605E-2,-6.1245040849243537E-2,-4.9961948929293953E-2]

{"sheet":"Rates - do not touch","index":3,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
["Parameters"]
["Human population",{"$f":"Dashboard!D4","v":33141},null,"Can maybe change this so that it is municipality? If there is some kind of lookup table where people select their municipality and it automatically gives the population for that municipality?"]
[]
["StartHC",{"$f":"ROUND(0.186*$B$2,0)","v":6164}]
["StartBSC_F",{"$f":"ROUND(($B$2/30)*0.37*0.5,0)","v":204}]
["StartNBSC",{"$f":"ROUND(($B$2/30)*(1-0.37)+B5,0)","v":900},null,"Non breeding cats plus males who could be breeding but don’t contribute to growth rate"]
["StartTNRS",0]
["StartCC",{"$f":"Dashboard!D8","v":117}]
[]
["Prop HC breeding",{"$f":"Dashboard!D11","v":0.12},null,"10 % of all housecats "]
["HC death rate per year",0.23,null,"From literature"]
["HC abandonment",{"$f":"Dashboard!D12","v":0.05}]
["HC recovery rate",{"$f":"Dashboard!D13","v":0.05}]
["HC growth rate",{"$f":"3.82*1.63*0.7*('Rates - do not touch'!$B$10*0.5)-'Rates - do not touch'!$B$11-($B$12*$B$13)","v":2.9017199999999937E-2}]
[]
["Proportion B_SC breeding",{"$f":"Dashboard!D7/100","v":0.37},null,"EP (10-11-18): dit nu gebruikt in formules in tab pop model ipv handmatig getypte 0,37"]
["B_SC breeding",0.5,null,"Only concerned with females, so half the individuals can breed"]
["B_SC death rate",0.34]
["B_SC growth rate",{"$f":"(3.82*1.63*0.44*$B$16*'Rates - do not touch'!$B$17)*(1-$B$18)","v":0.33451785839999992}]
[]
["NB_SC death rate",0.34]
[]
["CC growth rate",{"$f":"0.2-B24","v":-0.03},null,"proportion of new individuals which turn up according to feeder survey"]
["CC death rate",{"$f":"0.23","v":0.23},null,"from dataoverzicht sheet"]
[]
[]
["TNR rate",{"$f":"Dashboard!D17","v":0},null,"Rates of different treatments - can be changed here"]
["SHEL rate",{"$f":"Dashboard!D19","v":0}]
["EUTH rate",{"$f":"Dashboard!D20","v":0}]
["CC rate",{"$f":"Dashboard!D18","v":0}]
[]
["Proportion strays being trapped",{"$f":"Dashboard!D15","v":0}]
[]
["Habitats","WelfareHC","WelfareCC","WelfareSC","FreeRoamHC","FreeRoamCC","FreeRoamSC","PropHC","PropCC","PropSC"]
["Stedelijk",3.12,2.08,1.75,0.56000000000000005,1,1,0.24,0.39,0.25]
["Halfstedelijk",2.54,1.96,1.79,0.78,1,1,0.6,0.21,0.25]
["Landelijk",3.12,2.12,1.96,0.75,1,1,0.16,0.28000000000000003,0.25]
["Industrieel",3,2.33,2.08,0,1,1,0,0.12,0.25]
["Alle",{"$f":"AVERAGE(B35:B38)","v":2.9450000000000003},{"$f":"AVERAGE(C35:C38)","v":2.1225000000000001},1.895,0.52249999999999996,1,1,{"$f":"SUM(H35:H38)","v":1},{"$f":"SUM(I35:I38)","v":1},1]
[]
["Types of treatment"]
["Terugplaatsen"]
["Koloniekat"]
["Alle"]
["Niet"]

{"sheet":"Cluster analysis","index":4,"n_rows":226,"n_cols":3,"rows_kept":226,"cut":false,"hidden":true,"merged":[]}
["Municipality","Code","Cluster"]
["ANTWERPEN",11002,3]
["BOECHOUT",11004,3]
["BORSBEEK",11007,3]
["BRASSCHAAT",11008,3]
["BRECHT",11009,2]
["EDEGEM",11013,3]
["HEMIKSEM",11018,3]
["HOVE",11021,3]
["KALMTHOUT",11022,1]
["KAPELLEN",11023,3]
["LINT",11025,3]
["MORTSEL",11029,3]
["NIEL",11030,3]
["RANST",11035,3]
["RUMST",11037,3]
["SCHILDE",11039,3]
["SCHOTEN",11040,3]
["WIJNEGEM",11050,3]
["WOMMELGEM",11052,3]
["WUUSTWEZEL",11053,4]
["ZANDHOVEN",11054,3]
["ZOERSEL",11055,1]
["ZWIJNDRECHT",11056,3]
["MALLE",11057,1]
["BERLAAR",12002,3]
["BONHEIDEN",12005,3]
["BORNEM",12007,3]
["DUFFEL",12009,3]
["HEIST-OP-DEN-BERG",12014,1]
["LIER",12021,1]
["MECHELEN",12025,1]
["NIJLEN",12026,3]
["PUURS",12030,3]
["SINT-AMANDS",12034,3]
["SINT-KATELIJNE-WAVER",12035,3]
["WILLEBROEK",12040,3]
["ARENDONK",13001,1]
["BALEN",13003,1]
["BEERSE",13004,3]
["DESSEL",13006,3]
["GEEL",13008,2]
["GROBBENDONK",13010,3]
["HERENTHOUT",13012,3]
["HERSELT",13013,1]
["HOOGSTRATEN",13014,4]
["HULSHOUT",13016,3]
["KASTERLEE",13017,1]
["MEERHOUT",13021,3]
["MERKSPLAS",13023,1]
["OLEN",13029,3]
["RETIE",13036,1]
["RIJKEVORSEL",13037,1]
["TURNHOUT",13040,1]
["VORSELAAR",13044,3]
["VOSSELAAR",13046,3]
["WESTERLO",13049,2]
["LAAKDAL",13053,3]
["ASSE",23002,1]
["BEVER",23009,3]
["DILBEEK",23016,3]
["GALMAARDEN",23023,3]
["GOOIK",23024,1]
["GRIMBERGEN",23025,3]
["HALLE",23027,3]
["HERNE",23032,1]
["HOEILAART",23033,3]
["KAMPENHOUT",23038,3]
["KAPELLE-OP-DEN-BOS",23039,3]
["LIEDEKERKE",23044,3]
["LONDERZEEL",23045,1]
["MACHELEN",23047,3]
["MERCHTEM",23052,2]
["OVERIJSE",23062,3]
["SINT-PIETERS-LEEUW",23077,3]
["TERT",23086,3]
["VILVOORDE",23088,3]
["ZAVENTEM",23094,3]
["ZEMST",23096,1]
["ROOSDAAL",23097,3]
["LINKEBEEK",23100,3]
["WEMMEL",23102,3]
["AFFLIGEM",23105,3]
["AARSCHOT",24001,1]
["BEKKEVOORT",24008,1]
["BERTEM",24009,1]
["BIERBEEK",24011,3]
["DIEST",24020,1]
["HAACHT",24033,3]
["HOEGAARDEN",24041,2]
["HOLSBEEK",24043,3]
["KORTEKEN",24054,1]
["LANDEN",24059,2]
["OUD-HEVERLEE",24086,3]
["TERVUREN",24104,3]
["ZOUTLEEUW",24130,3]
["LINTER",24133,3]
["SCHERPENHEUVEL-ZICHEM",24134,1]
["TIELT-WINGE",24135,2]
["GLABBEEK",24137,3]
["BEERNEM",31003,2]
["BLANKENBERGE",31004,3]
["BRUGGE",31005,1]
["DAMME",31006,2]
["JABBEKE",31012,1]
["TORHOUT",31033,1]
["ZUIENKERKE",31042,1]
["KNOKKE-HEIST",31043,2]
["DIKSMUIDE",32003,4]
["KOEKELARE",32010,1]
["KORTEMARK",32011,2]
["LO-RENINGE",32030,2]
["IEPER",33011,4]
["MESEN",33016,3]
["POPERINGE",33021,4]
["ZONNEBEKE",33037,2]
["ANZEGEM",34002,1]
["AVELGEM",34003,3]
["DEERLIJK",34009,3]
["HARELBEKE",34013,3]
["KORTRIJK",34022,2]
["KUURNE",34023,3]
["LENDELEDE",34025,3]
["MENEN",34027,3]
["WAREGEM",34040,1]
["BREDENE",35002,3]
["ICHTEGEM",35006,1]
["MIDDELKERKE",35011,4]
["OOSTENDE",35013,3]
["OUDENBURG",35014,3]
["HOOGLEDE",36006,1]
["INGELMUNSTER",36007,3]
["IZEGEM",36008,3]
["MOORSLEDE",36012,1]
["ROESELARE",36015,1]
["STADEN",36019,2]
["MEULEBEKE",37007,1]
["OOSTROZEBEKE",37010,3]
["PITTEM",37011,1]
["RUISELEDE",37012,1]
["WIELSBEKE",37017,3]
["WINGENE",37018,2]
["ARDOOIE",37020,1]
["ALVERINGEM",38002,2]
["KOKSIJDE",38014,1]
["NIEUWPOORT",38016,1]
["AALST",41002,3]
["GERAARDSBERGEN",41018,2]
["HAALTERT",41024,3]
["LEDE",41034,3]
["NINOVE",41048,1]
["SINT-LIEVENS-HOUTEM",41063,3]
["ZOTTEGEM",41081,1]
["ERPE-MERE",41082,3]
["BUGGENHOUT",42004,3]
["DENDERMONDE",42006,1]
["HAMME",42008,3]
["LAARNE",42010,1]
["LEBBEKE",42011,3]
["WAASMUNSTER",42023,3]
["WAASMUNSTER",42023,3]
["WETTEREN",42025,1]
["WICHELEN",42026,3]
["ZELE",42028,1]
["ASSENEDE",43002,4]
["EEKLO",43005,1]
["KAPRIJKE",43007,1]
["MALDEGEM",43010,4]
["SINT-LAUREINS",43014,2]
["ZELZATE",43018,3]
["DESTELBERGEN",44013,3]
["EVERGEM",44019,2]
["GENT",44021,1]
["LOCHRISTI",44034,2]
["MELLE",44040,3]
["MERELBEKE",44043,3]
["ZARETH",44048,1]
["NEVELE",44049,2]
["ZOMERGEM",44080,1]
["ZULTE",44081,1]
["OUDEARDE",45035,2]
["RONSE",45041,3]
["ZINGEM",45057,3]
["BRAKEL",45059,1]
["KLUISBERGEN",45060,3]
["WORTEGEM-PETEGEM",45061,1]
["LIERDE",45063,3]
["ZWALM",45065,1]
["BEVEREN",46003,4]
["KRUIBEKE",46013,3]
["LOKEREN",46014,2]
["SINT-GILLIS-WAAS",46020,2]
["SINT-NIKLAAS",46021,2]
["TEMSE",46025,1]
["AS",71002,3]
["BERINGEN",71004,3]
["DIEPENBEEK",71011,3]
["GENK",71016,3]
["GINGELOM",71017,2]
["HALEN",71020,3]
["HASSELT",71022,1]
["HERK-DE-STAD",71024,1]
["LEOPOLDSBURG",71034,3]
["LUMMEN",71037,1]
["SINT-TRUIDEN",71053,4]
["TESSENDERLO",71057,3]
["HEUSDEN-ZOLDER",71070,3]
["BOCHOLT",72003,1]
["KINROOI",72018,1]
["LOMMEL",72020,1]
["MAASEIK",72021,1]
["NEERPELT",72025,3]
["OVERPELT",72029,3]
["PEER",72030,2]
["HAMONT-ACHEL",72037,1]
["HECHTEL-EKSEL",72038,3]
["HOUTHALEN-HELCHTEREN",72039,3]
["MEEUWEN-GRUITRODE",72040,2]
["DILSEN-STOKKEM",72041,1]
["ALKEN",73001,3]
["HOESELT",73032,1]
["RIEMST",73066,2]
["TONGEREN",73083,4]
["WELLEN",73098,3]
["MAASMECHELEN",73107,3]
["VOEREN",73109,3]