{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Berekening","Pachtprijsgebieden Los Land","Pachtprijsgebieden Tuinland","Pachtovereenkomsten"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Berekening","index":0,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,"Actualisatie pachtprijs*"]
[null,null,null,null,2018]
[null,null,null,null,"* dit betreft een indicatief rekenschema, "]
[null,null,null,null,"waaraan geen rechten kunnen worden ontleend."]
[]
[null,null,"Gegevens pachtovereenkomst & pachtobject"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7: 325 BW",1]
[null,null,"Pachtobject",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7: 388 BW",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7: 385 BW",3]
[null,null,{"$f":"IF(D11=1,\"Type pachtovereenkomst (hoeve)\",\"Type pachtovereenkomst (los land)\")","v":"Type pachtovereenkomst (los land)"},1,null,null,{"$f":"IF(D13=1,S10,IF(D13=2,S11,IF(D13=3,S12,IF(D13=4,S13,IF(D13=5,S14,IF(D13=6,S15,IF(D13=7,S16,\"ongeldige keuze\")))))))","v":"7: 325 BW"},null,null,null,null,null,null,null,null,null,null,null,"7: 397 lid 1 BW",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7: 397 lid 2 BW",5]
[null,null,"Pachtovereenkomst aangegaan",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7: 395 BW",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7: 396 BW",7]
[null,null,"Vrije verkeerswaarde grond (per hectare)",null,60000]
[]
[null,null,"Oude pachtprijs los land (per hectare)",false]
[null,null,"Oude pachtprijs agrarische bedrijfswoning (totaal)",null,700]
[null,null,"Oude pachtprijs agrarische bedrijfsgebouwen (totaal)"]
[]
[null,null,"Pachtnorm 2018"]
[]
[null,null,"Gemeente",null,"Rhenen"]
[null,null,"Regio tuinland",null,"Westelijk Holland"]
[]
[null,null,"Pachtprijsgebied",null,{"$f":"VLOOKUP(E25,'Pachtprijsgebieden Los Land'!A2:E439,2)","v":"Centraal veehouderijgebied"}]
[]
[null,null,"Veranderpercentage agrarische bedrijfswoning",null,{"$f":"IF(D15=1,0.039,0.014)","v":3.9E-2}]
[null,null,null,null,null,null,null,null,{"$f":"IF(D15=1,1,0)","v":1},"Voor 1-9-07",{"$f":"IF(D15=1,1,0)","v":1},"Voor 1-9-07",{"$f":"IF(D15=2,1,0)","v":0},"Na 1-9-07",{"$f":"IF(D15=2,1,0)","v":0},"Na 1-9-07"]
[null,null,"Veranderpercentage agrarische bedrijfsgebouwen",null,1.46E-2,null,null,null,{"$f":"IF(E34<0,1,0)","v":1},"Negatief",{"$f":"IF(E34>0,1,0)","v":0},"Positief",{"$f":"IF(E34<0,1,0)","v":1},"Negatief",{"$f":"IF(E34>0,1,0)","v":0},"Positief"]
[null,null,null,null,null,null,null,null,{"$f":"E19*(1+E34)","v":0},"Prijs x veranderpercentage",{"$f":"E19*(1+E34)","v":0},"Prijs x veranderpercentage",{"$f":"E36","v":467},"regionorm",{"$f":"E36","v":467},"regionorm"]
[null,null,{"$f":"IF(D19=TRUE,\"Veranderpercentage (tuinland)\",\"Veranderpercentage (los land)\")","v":"Veranderpercentage (los land)"},null,{"$f":"IF(D19=FALSE,VLOOKUP(E25,'Pachtprijsgebieden Los Land'!A2:E439,5),IF(E26=\"Westelijk Holland\",0.31,-0.025))","v":-0.26},null,null,null,0.9,"Minimale verandering t.o.v. regionorm",1.1000000000000001,"Maximal verandering t.o.v. regionorm"]
[null,null,null,null,null,null,null,null,{"$f":"E36*I34","v":420.3},"Grenswaarde",{"$f":"K34*E36","v":513.70000000000005},"Grenswaarde"]
[null,null,"Regionorm",null,{"$f":"IF(D19=FALSE,VLOOKUP(E25,'Pachtprijsgebieden Los Land'!A2:E439,4),IF(E26=\"Westelijk Holland\",2380,811))","v":467},null,null,null,{"$f":"IF(I33<I35,I35,I33)","v":420.3},null,{"$f":"IF(K33>K35,K35,K33)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E19<I36,E19,I36)*I32*I31","v":0},null,{"$f":"IF(E19>K36,E19,K36)*K32*K31","v":0}]
[null,null,"Nieuwe prijzen",null,null,null,null,null,{"$f":"2%*$E$17","v":1200},"2% van vrije verkeerswaarde",{"$f":"2%*$E$17","v":1200},"2% van vrije verkeerswaarde",{"$f":"2%*$E$17*M32*M31","v":0},"2% van vrije verkeerswaarde",{"$f":"2%*$E$17*O31*O32","v":0},"2% van vrije verkeerswaarde"]
[null,null,null,null,null,null,null,null,"Negatief",null,{"$f":"IF(K37>K38,K38,K37)","v":0},null,{"$f":"IF(M33>M38,M38,M33)","v":0},null,{"$f":"IF(O33>O38,O38,O33)","v":0}]
[null,null,"Nieuwe pachtprijs los land (per hectare)",null,{"$f":"IF(D11=1,(SUM(I39,K39,M39,O39)),IF(D13=1,(SUM(I39,K39,M39,O39)),IF(D13=2,\"onderzoeken\",IF(D13=3,\"onderzoeken\",IF(D13=4,\"volgens contract\",IF(D13=5,(SUM(I39,K39,M39,O39)),IF(D13=6,\"volgens contract\",IF(D13=7,\"volgens contract\",\"\"))))))))","v":0},null,{"$f":"IF(D15=1,\"*\",\"\")","v":"*"}]
[null,null,{"$f":"IF($D$11=1,\"Nieuwe pachtprijs agrarische bedrijfswoning\",\"\")","v":""},null,{"$f":"IF(D11=1,E20*(1+E30),\"\")","v":""}]
[null,null,{"$f":"IF($D$11=2,\"\",\"Nieuwe pachtprijs agrarische bedrijfsgebouwen\")","v":""},null,{"$f":"IF(D11=1,E21*(1+E32),\"\")","v":""}]
[]
[null,null,"NB: Indien er sprake is van gebruiksbeperkende bepalingen bij pacht van los land en de pachter hiervoor geen"]
[null,null,"vergoeding ontvangt van de overheid, heeft hij recht op een korting t.o.v. de hoogst toelaatbare pachtprijs."]
[]
[null,null,"* de pachtprijzen werken van rechtswege door. Deze gewijzigde pachtprijzen hoeven niet voorgelegd te worden"]
[null,null,"aan de Grondkamer. De verpachter kan schriftelijk geheel of gedeeltelijk afzien van een verhoging. De van"]
[null,null,"toepassing zijnde pachtprijs hoeft niet de hoogt toelaatbare pachtprijs te zijn."]
[]
[null,null,"Voor aanvullende vragen en/of opmerkingen neem contact op via info@hackrentmeesters.nl"]

{"sheet":"Pachtprijsgebieden Los Land","index":1,"n_rows":439,"n_cols":5,"rows_kept":439,"cut":false,"hidden":true,"merged":[]}
["Gemeente","Pachtprijsgebied","Regio","Regionorn","Veranderpercentage"]
["’s-Gravenhage","Westelijk Holland",7,548,-0.16]
["’s-Hertogenbosch","Rivierengebied",10,631,-0.27]
["Aa en Hunze","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Aalburg","Rivierengebied",10,631,-0.27]
["Aalsmeer","Westelijk Holland",7,548,-0.16]
["Aalten","Oostelijk veehouderijgebied",4,608,-0.19]
["Abcoude","Hollands/Utrechts weidegebied",9,706,-0.24]
["Achtkarspelen","Noordelijk weidegebied",3,586,-0.26]
["Alblasserdam","Hollands/Utrechts weidegebied",9,706,-0.24]
["Albrandswaard","Westelijk Holland",7,548,-0.16]
["Alkmaar","Westelijk Holland",7,548,-0.16]
["Almelo","Oostelijk veehouderijgebied",4,608,-0.19]
["Almere","Ijsselmeerpolders",6,1125,7.0000000000000007E-2]
["Alphen aan den Rijn","Hollands/Utrechts weidegebied",9,706,-0.24]
["Alphen-Chaam","Zuidelijk veehouderijgebied",13,550,-0.34]
["Ameland","Noordelijk weidegebied",3,586,-0.26]
["Amersfoort","Hollands/Utrechts weidegebied",9,706,-0.24]
["Amstelveen","Westelijk Holland",7,548,-0.16]
["Amsterdam","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Andijk","Westelijk Holland",7,548,-0.16]
["Apeldoorn","Centraal veehouderijgebied",5,467,-0.26]
["Appingedam","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Arcen en Velden","Zuidelijk veehouderijgebied",13,550,-0.34]
["Arnhem","Rivierengebied",10,631,-0.27]
["Assen","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Asten","Zuidelijk veehouderijgebied",13,550,-0.34]
["Baarle-Nassau","Zuidelijk veehouderijgebied",13,550,-0.34]
["Baarn","Hollands/Utrechts weidegebied",9,706,-0.24]
["Barendrecht","Westelijk Holland",7,548,-0.16]
["Barneveld","Centraal veehouderijgebied",5,467,-0.26]
["Bedum","Noordelijk weidegebied",3,586,-0.26]
["Beek","Zuid-Limburg",14,718,-0.18]
["Beemster","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Beesel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Bellingwedde","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Bergambacht","Hollands/Utrechts weidegebied",9,706,-0.24]
["Bergeijk","Zuidelijk veehouderijgebied",13,550,-0.34]
["Bergen (L)","Zuidelijk veehouderijgebied",13,550,-0.34]
["Bergen (NH)","Westelijk Holland",7,548,-0.16]
["Bergen op Zoom","Zuidwest Brabant",12,740,-0.05]
["Berkelland","Oostelijk veehouderijgebied",4,608,-0.19]
["Bernheze","Zuidelijk veehouderijgebied",13,550,-0.34]
["Bernisse","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Best","Zuidelijk veehouderijgebied",13,550,-0.34]
["Beuningen","Oostelijk veehouderijgebied",4,608,-0.19]
["Beverwijk","Westelijk Holland",7,548,-0.16]
["Binnenmaas","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Bladel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Blaricum","Hollands/Utrechts weidegebied",9,706,-0.24]
["Bloemendaal","Westelijk Holland",7,548,-0.16]
["Boarnsterhim","Noordelijk weidegebied",3,586,-0.26]
["Bodegraven","Hollands/Utrechts weidegebied",9,706,-0.24]
["Boekel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Bolsward","Noordelijk weidegebied",3,586,-0.26]
["Borger-Odoorn","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Borne","Oostelijk veehouderijgebied",4,608,-0.19]
["Borsele","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Boskoop","Westelijk Holland",7,548,-0.16]
["Boxmeer","Zuidelijk veehouderijgebied",13,550,-0.34]
["Boxtel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Breda","Zuidwest Brabant",12,740,-0.05]
["Breukelen","Hollands/Utrechts weidegebied",9,706,-0.24]
["Brielle","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Bronckhorst","Oostelijk veehouderijgebied",4,608,-0.19]
["Brummen","Oostelijk veehouderijgebied",4,608,-0.19]
["Brunssum","Zuid-Limburg",14,718,-0.18]
["Bunnik","Rivierengebied",10,631,-0.27]
["Bunschoten","Hollands/Utrechts weidegebied",9,706,-0.24]
["Buren","Rivierengebied",10,631,-0.27]
["Bussum","Hollands/Utrechts weidegebied",9,706,-0.24]
["Capelle aan den IJssel","Westelijk Holland",7,548,-0.16]
["Castricum","Westelijk Holland",7,548,-0.16]
["Coevorden","Oostelijk veehouderijgebied",4,608,-0.19]
["Cranendonck","Zuidelijk veehouderijgebied",13,550,-0.34]
["Cromstrijen","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Cuijk","Zuidelijk veehouderijgebied",13,550,-0.34]
["Culemborg","Rivierengebied",10,631,-0.27]
["Dalfsen","Noordelijk weidegebied",3,586,-0.26]
["Dantumadiel","Noordelijk weidegebied",3,586,-0.26]
["De Bilt","Hollands/Utrechts weidegebied",9,706,-0.24]
["De Marne","Bouwhoek en Hogeland",1,653,-0.04]
["De Ronde Venen","Hollands/Utrechts weidegebied",9,706,-0.24]
["De Wolden","Noordelijk weidegebied",3,586,-0.26]
["Delft","Westelijk Holland",7,548,-0.16]
["Delfzijl","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Den Helder","Westelijk Holland",7,548,-0.16]
["Deurne","Zuidelijk veehouderijgebied",13,550,-0.34]
["Deventer","Oostelijk veehouderijgebied",4,608,-0.19]
["Diemen","Hollands/Utrechts weidegebied",9,706,-0.24]
["Dinkelland","Oostelijk veehouderijgebied",4,608,-0.19]
["Dirksland","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Doesburg","Oostelijk veehouderijgebied",4,608,-0.19]
["Doetinchem","Oostelijk veehouderijgebied",4,608,-0.19]
["Dongen","Zuidelijk veehouderijgebied",13,550,-0.34]
["Dongeradeel","Bouwhoek en Hogeland",1,653,-0.04]
["Dordrecht","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Drechterland","Westelijk Holland",7,548,-0.16]
["Drimmelen","Zuidelijk veehouderijgebied",13,550,-0.34]
["Dronten","Ijsselmeerpolders",6,1125,7.0000000000000007E-2]
["Druten","Oostelijk veehouderijgebied",4,608,-0.19]
["Duiven","Oostelijk veehouderijgebied",4,608,-0.19]
["Echt-Susteren","Zuidelijk veehouderijgebied",13,550,-0.34]
["Edam-Volendam","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Ede","Centraal veehouderijgebied",5,467,-0.26]
["Eemnes","Hollands/Utrechts weidegebied",9,706,-0.24]
["Eemsmond","Bouwhoek en Hogeland",1,653,-0.04]
["Eersel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Eijsden","Zuid-Limburg",14,718,-0.18]
["Eindhoven","Zuidelijk veehouderijgebied",13,550,-0.34]
["Elburg","Centraal veehouderijgebied",5,467,-0.26]
["Emmen","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Enkhuizen","Westelijk Holland",7,548,-0.16]
["Enschede","Oostelijk veehouderijgebied",4,608,-0.19]
["Epe","Centraal veehouderijgebied",5,467,-0.26]
["Ermelo","Centraal veehouderijgebied",5,467,-0.26]
["Etten-Leur","Zuidwest Brabant",12,740,-0.05]
["Ferwerderadiel","Bouwhoek en Hogeland",1,653,-0.04]
["Franekeradeel","Bouwhoek en Hogeland",1,653,-0.04]
["Gaasterlân-Sleat","Noordelijk weidegebied",3,586,-0.26]
["Geertruidenberg","Zuidelijk veehouderijgebied",13,550,-0.34]
["Geldermalsen","Rivierengebied",10,631,-0.27]
["Geldrop-Mierlo","Zuidelijk veehouderijgebied",13,550,-0.34]
["Gemert-Bakel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Gennep","Zuidelijk veehouderijgebied",13,550,-0.34]
["Giessenlanden","Hollands/Utrechts weidegebied",9,706,-0.24]
["Gilze en Rijen","Zuidelijk veehouderijgebied",13,550,-0.34]
["Goedereede","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Goes","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Goirle","Zuidelijk veehouderijgebied",13,550,-0.34]
["Gorinchem","Hollands/Utrechts weidegebied",9,706,-0.24]
["Gouda","Hollands/Utrechts weidegebied",9,706,-0.24]
["Graafstroom","Hollands/Utrechts weidegebied",9,706,-0.24]
["Graft-De Rijp","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Grave","Zuidelijk veehouderijgebied",13,550,-0.34]
["Groesbeek","Oostelijk veehouderijgebied",4,608,-0.19]
["Groningen","Noordelijk weidegebied",3,586,-0.26]
["Grootegast","Noordelijk weidegebied",3,586,-0.26]
["Gulpen-Wittem","Zuid-Limburg",14,718,-0.18]
["Haaksbergen","Oostelijk veehouderijgebied",4,608,-0.19]
["Haaren","Zuidelijk veehouderijgebied",13,550,-0.34]
["Haarlem","Westelijk Holland",7,548,-0.16]
["Haarlemmerliede en Spaarnwoude","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Haarlemmermeer","Westelijk Holland",7,548,-0.16]
["Halderberge","Zuidwest Brabant",12,740,-0.05]
["Hardenberg","Oostelijk veehouderijgebied",4,608,-0.19]
["Harderwijk","Centraal veehouderijgebied",5,467,-0.26]
["Hardinxveld-Giessendam","Hollands/Utrechts weidegebied",9,706,-0.24]
["Haren","Noordelijk weidegebied",3,586,-0.26]
["Harenkarspel","Westelijk Holland",7,548,-0.16]
["Harlingen","Bouwhoek en Hogeland",1,653,-0.04]
["Hattem","Centraal veehouderijgebied",5,467,-0.26]
["Heemskerk","Westelijk Holland",7,548,-0.16]
["Heemstede","Westelijk Holland",7,548,-0.16]
["Heerde","Centraal veehouderijgebied",5,467,-0.26]
["Heerenveen","Noordelijk weidegebied",3,586,-0.26]
["Heerhugowaard","Westelijk Holland",7,548,-0.16]
["Heerlen","Zuid-Limburg",14,718,-0.18]
["Heeze-Leende","Zuidelijk veehouderijgebied",13,550,-0.34]
["Heiloo","Westelijk Holland",7,548,-0.16]
["Helden","Zuidelijk veehouderijgebied",13,550,-0.34]
["Hellendoorn","Oostelijk veehouderijgebied",4,608,-0.19]
["Hellevoetsluis","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Helmond","Zuidelijk veehouderijgebied",13,550,-0.34]
["Hendrik-Ido-Ambacht","Westelijk Holland",7,548,-0.16]
["Hengelo","Oostelijk veehouderijgebied",4,608,-0.19]
["Het Bildt","Bouwhoek en Hogeland",1,653,-0.04]
["Heumen","Oostelijk veehouderijgebied",4,608,-0.19]
["Heusden","Rivierengebied",10,631,-0.27]
["Hillegom","Westelijk Holland",7,548,-0.16]
["Hilvarenbeek","Zuidelijk veehouderijgebied",13,550,-0.34]
["Hilversum","Hollands/Utrechts weidegebied",9,706,-0.24]
["Hof van Twente","Oostelijk veehouderijgebied",4,608,-0.19]
["Hollands Kroon","Westelijk Holland",7,548,-0.16]
["Hoogeveen","Oostelijk veehouderijgebied",4,608,-0.19]
["Hoogezand-Sappemeer","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Hoorn","Westelijk Holland",7,548,-0.16]
["Horst aan de Maas","Zuidelijk veehouderijgebied",13,550,-0.34]
["Houten","Rivierengebied",10,631,-0.27]
["Huizen","Hollands/Utrechts weidegebied",9,706,-0.24]
["Hulst","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["IJsselstein","Hollands/Utrechts weidegebied",9,706,-0.24]
["Kaag en Braassem","Westelijk Holland",7,548,-0.16]
["Kampen","Noordelijk weidegebied",3,586,-0.26]
["Kapelle","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Katwijk","Westelijk Holland",7,548,-0.16]
["Kerkrade","Zuid-Limburg",14,718,-0.18]
["Kessel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Koggenland","Westelijk Holland",7,548,-0.16]
["Kollumerland en Nieuwkruisland","Bouwhoek en Hogeland",1,653,-0.04]
["Korendijk","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Krimpen aan den IJssel","Hollands/Utrechts weidegebied",9,706,-0.24]
["Laarbeek","Zuidelijk veehouderijgebied",13,550,-0.34]
["Landerd","Zuidelijk veehouderijgebied",13,550,-0.34]
["Landgraaf","Zuid-Limburg",14,718,-0.18]
["Landsmeer","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Langedijk","Westelijk Holland",7,548,-0.16]
["Lansingerland","Westelijk Holland",7,548,-0.16]
["Laren","Hollands/Utrechts weidegebied",9,706,-0.24]
["Leek","Noordelijk weidegebied",3,586,-0.26]
["Leerdam","Hollands/Utrechts weidegebied",9,706,-0.24]
["Leeuwarden","Noordelijk weidegebied",3,586,-0.26]
["Leeuwarderadeel","Bouwhoek en Hogeland",1,653,-0.04]
["Leiden","Westelijk Holland",7,548,-0.16]
["Leiderdorp","Westelijk Holland",7,548,-0.16]
["Leidschendam-Voorburg","Westelijk Holland",7,548,-0.16]
["Lelystad","Ijsselmeerpolders",6,1125,7.0000000000000007E-2]
["Lemsterland","Noordelijk weidegebied",3,586,-0.26]
["Leudal","Zuidelijk veehouderijgebied",13,550,-0.34]
["Leusden","Centraal veehouderijgebied",5,467,-0.26]
["Liesveld","Hollands/Utrechts weidegebied",9,706,-0.24]
["Lingewaal","Rivierengebied",10,631,-0.27]
["Lingewaard","Rivierengebied",10,631,-0.27]
["Lisse","Westelijk Holland",7,548,-0.16]
["Lith","Zuidelijk veehouderijgebied",13,550,-0.34]
["Littenseradiel","Noordelijk weidegebied",3,586,-0.26]
["Lochem","Oostelijk veehouderijgebied",4,608,-0.19]
["Loenen","Hollands/Utrechts weidegebied",9,706,-0.24]
["Loon op Zand","Zuidelijk veehouderijgebied",13,550,-0.34]
["Lopik","Hollands/Utrechts weidegebied",9,706,-0.24]
["Loppersum","Bouwhoek en Hogeland",1,653,-0.04]
["Losser","Oostelijk veehouderijgebied",4,608,-0.19]
["Maarssen","Rivierengebied",10,631,-0.27]
["Maasbree","Zuidelijk veehouderijgebied",13,550,-0.34]
["Maasdonk","Zuidelijk veehouderijgebied",13,550,-0.34]
["Maasdriel","Rivierengebied",10,631,-0.27]
["Maasgouw","Zuidelijk veehouderijgebied",13,550,-0.34]
["Maassluis","Westelijk Holland",7,548,-0.16]
["Maastricht","Zuid-Limburg",14,718,-0.18]
["Margraten","Zuid-Limburg",14,718,-0.18]
["Marum","Noordelijk weidegebied",3,586,-0.26]
["Medemblik","Westelijk Holland",7,548,-0.16]
["Meerlo-Wanssum","Zuidelijk veehouderijgebied",13,550,-0.34]
["Meerssen","Zuid-Limburg",14,718,-0.18]
["Meijel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Menaldumadeel","Bouwhoek en Hogeland",1,653,-0.04]
["Menterwolde","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Meppel","Noordelijk weidegebied",3,586,-0.26]
["Middelburg","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Middelharnis","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Midden-Delfland","Westelijk Holland",7,548,-0.16]
["Midden-Drenthe","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Mill en Sint Hubert","Zuidelijk veehouderijgebied",13,550,-0.34]
["Millingen aan de Rijn","Oostelijk veehouderijgebied",4,608,-0.19]
["Moerdijk","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Montferland","Oostelijk veehouderijgebied",4,608,-0.19]
["Montfoort","Hollands/Utrechts weidegebied",9,706,-0.24]
["Mook en Middelaar","Zuidelijk veehouderijgebied",13,550,-0.34]
["Moordrecht","Hollands/Utrechts weidegebied",9,706,-0.24]
["Muiden","Hollands/Utrechts weidegebied",9,706,-0.24]
["Naarden","Hollands/Utrechts weidegebied",9,706,-0.24]
["Neder-Betuwe","Rivierengebied",10,631,-0.27]
["Nederlek","Hollands/Utrechts weidegebied",9,706,-0.24]
["Nederweert","Zuidelijk veehouderijgebied",13,550,-0.34]
["Neerijnen","Rivierengebied",10,631,-0.27]
["Nieuwegein","Hollands/Utrechts weidegebied",9,706,-0.24]
["Nieuwerkerk aan den IJssel","Westelijk Holland",7,548,-0.16]
["Nieuwkoop","Hollands/Utrechts weidegebied",9,706,-0.24]
["Nieuw-Lekkerland","Hollands/Utrechts weidegebied",9,706,-0.24]
["Nijefurd","Noordelijk weidegebied",3,586,-0.26]
["Nijkerk","Centraal veehouderijgebied",5,467,-0.26]
["Nijmegen","Rivierengebied",10,631,-0.27]
["Noord-Beveland","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Noordenveld","Noordelijk weidegebied",3,586,-0.26]
["Noordoostpolder","Ijsselmeerpolders",6,1125,7.0000000000000007E-2]
["Noordwijk","Westelijk Holland",7,548,-0.16]
["Noordwijkerhout","Westelijk Holland",7,548,-0.16]
["Nuenen, Gerwen en Nederwetten","Zuidelijk veehouderijgebied",13,550,-0.34]
["Nunspeet","Centraal veehouderijgebied",5,467,-0.26]
["Nuth","Zuid-Limburg",14,718,-0.18]
["Oegstgeest","Westelijk Holland",7,548,-0.16]
["Oirschot","Zuidelijk veehouderijgebied",13,550,-0.34]
["Oisterwijk","Zuidelijk veehouderijgebied",13,550,-0.34]
["Oldebroek","Centraal veehouderijgebied",5,467,-0.26]
["Oldenzaal","Oostelijk veehouderijgebied",4,608,-0.19]
["Olst-Wijhe","Oostelijk veehouderijgebied",4,608,-0.19]
["Ommen","Oostelijk veehouderijgebied",4,608,-0.19]
["Onderbanken","Zuid-Limburg",14,718,-0.18]
["Oost Gelre","Oostelijk veehouderijgebied",4,608,-0.19]
["Oosterhout","Zuidelijk veehouderijgebied",13,550,-0.34]
["Oostflakkee","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Ooststellingwerf","Noordelijk weidegebied",3,586,-0.26]
["Oostzaan","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Opmeer","Westelijk Holland",7,548,-0.16]
["Opsterland","Noordelijk weidegebied",3,586,-0.26]
["Oss","Zuidelijk veehouderijgebied",13,550,-0.34]
["Oud-Beijerland","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Oude IJsselstreek","Oostelijk veehouderijgebied",4,608,-0.19]
["Ouder-Amstel","Hollands/Utrechts weidegebied",9,706,-0.24]
["Ouderkerk","Hollands/Utrechts weidegebied",9,706,-0.24]
["Oudewater","Hollands/Utrechts weidegebied",9,706,-0.24]
["Overbetuwe","Rivierengebied",10,631,-0.27]
["Papendrecht","Hollands/Utrechts weidegebied",9,706,-0.24]
["Pekela","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Pijnacker-Nootdorp","Westelijk Holland",7,548,-0.16]
["Purmerend","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Putten","Centraal veehouderijgebied",5,467,-0.26]
["Raalte","Oostelijk veehouderijgebied",4,608,-0.19]
["Reeuwijk","Hollands/Utrechts weidegebied",9,706,-0.24]
["Reiderland","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Reimerswaal","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Renkum","Rivierengebied",10,631,-0.27]
["Renswoude","Centraal veehouderijgebied",5,467,-0.26]
["Reusel-De Mierden","Zuidelijk veehouderijgebied",13,550,-0.34]
["Rheden","Oostelijk veehouderijgebied",4,608,-0.19]
["Rhenen","Centraal veehouderijgebied",5,467,-0.26]
["Ridderkerk","Westelijk Holland",7,548,-0.16]
["Rijnwaarden","Oostelijk veehouderijgebied",4,608,-0.19]
["Rijnwoude","Westelijk Holland",7,548,-0.16]
["Rijssen-Holten","Oostelijk veehouderijgebied",4,608,-0.19]
["Rijswijk","Westelijk Holland",7,548,-0.16]
["Roerdalen","Zuidelijk veehouderijgebied",13,550,-0.34]
["Roermond","Zuidelijk veehouderijgebied",13,550,-0.34]
["Roosendaal","Zuidwest Brabant",12,740,-0.05]
["Rotterdam","Westelijk Holland",7,548,-0.16]
["Rozenburg","Westelijk Holland",7,548,-0.16]
["Rozendaal","Rivierengebied",10,631,-0.27]
["Rucphen","Zuidwest Brabant",12,740,-0.05]
["Schagen","Westelijk Holland",7,548,-0.16]
["Scheemda","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Schermer","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Scherpenzeel","Centraal veehouderijgebied",5,467,-0.26]
["Schiedam","Westelijk Holland",7,548,-0.16]
["Schiermonnikoog","Noordelijk weidegebied",3,586,-0.26]
["Schijndel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Schinnen","Zuid-Limburg",14,718,-0.18]
["Schoonhoven","Hollands/Utrechts weidegebied",9,706,-0.24]
["Schouwen-Duiveland","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Sevenum","Zuidelijk veehouderijgebied",13,550,-0.34]
["Simpelveld","Zuid-Limburg",14,718,-0.18]
["Sint Anthonis","Zuidelijk veehouderijgebied",13,550,-0.34]
["Sint-Michielsgestel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Sint-Oedenrode","Zuidelijk veehouderijgebied",13,550,-0.34]
["Sittard-Geleen","Zuid-Limburg",14,718,-0.18]
["Skarsterlân","Noordelijk weidegebied",3,586,-0.26]
["Sliedrecht","Hollands/Utrechts weidegebied",9,706,-0.24]
["Slochteren","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Sluis","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Smallingerland","Noordelijk weidegebied",3,586,-0.26]
["Sneek","Noordelijk weidegebied",3,586,-0.26]
["Soest","Hollands/Utrechts weidegebied",9,706,-0.24]
["Someren","Zuidelijk veehouderijgebied",13,550,-0.34]
["Son en Breugel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Spijkenisse","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Stadskanaal","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Staphorst","Noordelijk weidegebied",3,586,-0.26]
["Stede Broec","Westelijk Holland",7,548,-0.16]
["Steenbergen","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Steenwijkerland","Noordelijk weidegebied",3,586,-0.26]
["Stein","Zuid-Limburg",14,718,-0.18]
["Strijen","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Ten Boer","Noordelijk weidegebied",3,586,-0.26]
["Terneuzen","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Terschelling","Noordelijk weidegebied",3,586,-0.26]
["Texel","Westelijk Holland",7,548,-0.16]
["Teylingen","Westelijk Holland",7,548,-0.16]
["Tholen","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Tiel","Rivierengebied",10,631,-0.27]
["Tilburg","Zuidelijk veehouderijgebied",13,550,-0.34]
["Tubbergen","Oostelijk veehouderijgebied",4,608,-0.19]
["Twenterand","Oostelijk veehouderijgebied",4,608,-0.19]
["Tynaarlo","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Tytsjerksteradiel","Noordelijk weidegebied",3,586,-0.26]
["Ubbergen","Oostelijk veehouderijgebied",4,608,-0.19]
["Uden","Zuidelijk veehouderijgebied",13,550,-0.34]
["Uitgeest","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Uithoorn","Westelijk Holland",7,548,-0.16]
["Urk","Ijsselmeerpolders",6,1125,7.0000000000000007E-2]
["Utrecht","Rivierengebied",10,631,-0.27]
["Utrechtse Heuvelrug","Rivierengebied",10,631,-0.27]
["Vaals","Zuid-Limburg",14,718,-0.18]
["Valkenburg aan de Geul","Zuid-Limburg",14,718,-0.18]
["Valkenswaard","Zuidelijk veehouderijgebied",13,550,-0.34]
["Veendam","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Veenendaal","Centraal veehouderijgebied",5,467,-0.26]
["Veere","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Veghel","Zuidelijk veehouderijgebied",13,550,-0.34]
["Veldhoven","Zuidelijk veehouderijgebied",13,550,-0.34]
["Velsen","Westelijk Holland",7,548,-0.16]
["Venlo","Zuidelijk veehouderijgebied",13,550,-0.34]
["Venray","Zuidelijk veehouderijgebied",13,550,-0.34]
["Vianen","Hollands/Utrechts weidegebied",9,706,-0.24]
["Vlaardingen","Westelijk Holland",7,548,-0.16]
["Vlagtwedde","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Vlieland","Noordelijk weidegebied",3,586,-0.26]
["Vlissingen","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Vlist","Hollands/Utrechts weidegebied",9,706,-0.24]
["Voerendaal","Zuid-Limburg",14,718,-0.18]
["Voorschoten","Westelijk Holland",7,548,-0.16]
["Voorst","Oostelijk veehouderijgebied",4,608,-0.19]
["Vught","Rivierengebied",10,631,-0.27]
["Waalre","Zuidelijk veehouderijgebied",13,550,-0.34]
["Waalwijk","Zuidelijk veehouderijgebied",13,550,-0.34]
["Waddinxveen","Westelijk Holland",7,548,-0.16]
["Wageningen","Rivierengebied",10,631,-0.27]
["Wassenaar","Westelijk Holland",7,548,-0.16]
["Waterland","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Weert","Zuidelijk veehouderijgebied",13,550,-0.34]
["Weesp","Hollands/Utrechts weidegebied",9,706,-0.24]
["Werkendam","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Wervershoof","Westelijk Holland",7,548,-0.16]
["West Maas en Waal","Oostelijk veehouderijgebied",4,608,-0.19]
["Westerveld","Noordelijk weidegebied",3,586,-0.26]
["Westervoort","Oostelijk veehouderijgebied",4,608,-0.19]
["Westland","Westelijk Holland",7,548,-0.16]
["Weststellingwerf","Noordelijk weidegebied",3,586,-0.26]
["Westvoorne","Zuidwestelijk akkerbouwgebied",11,505,-0.02]
["Wierden","Oostelijk veehouderijgebied",4,608,-0.19]
["Wijchen","Oostelijk veehouderijgebied",4,608,-0.19]
["Wijdemeren","Hollands/Utrechts weidegebied",9,706,-0.24]
["Wijk bij Duurstede","Rivierengebied",10,631,-0.27]
["Winschoten","Veenkoloniën en Oldambt",2,640,-0.14000000000000001]
["Winsum","Noordelijk weidegebied",3,586,-0.26]
["Winterswijk","Oostelijk veehouderijgebied",4,608,-0.19]
["Woensdrecht","Zuidwest Brabant",12,740,-0.05]
["Woerden","Hollands/Utrechts weidegebied",9,706,-0.24]
["Wormerland","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Woudenberg","Centraal veehouderijgebied",5,467,-0.26]
["Woudrichem","Rivierengebied",10,631,-0.27]
["Wûnseradiel","Noordelijk weidegebied",3,586,-0.26]
["Wymbritseradiel","Noordelijk weidegebied",3,586,-0.26]
["Zaanstad","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Zaltbommel","Rivierengebied",10,631,-0.27]
["Zandvoort","Westelijk Holland",7,548,-0.16]
["Zederik","Hollands/Utrechts weidegebied",9,706,-0.24]
["Zeevang","Waterland en Droogmakerijen",8,296,-0.28999999999999998]
["Zeewolde","Ijsselmeerpolders",6,1125,7.0000000000000007E-2]
["Zeist","Rivierengebied",10,631,-0.27]
["Zevenaar","Oostelijk veehouderijgebied",4,608,-0.19]
["Zevenhuizen-Moerkapelle","Westelijk Holland",7,548,-0.16]
["Zijpe","Westelijk Holland",7,548,-0.16]
["Zoetermeer","Westelijk Holland",7,548,-0.16]
["Zoeterwoude","Westelijk Holland",7,548,-0.16]
["Zuidhorn","Noordelijk weidegebied",3,586,-0.26]
["Zundert","Zuidwest Brabant",12,740,-0.05]
["Zutphen","Oostelijk veehouderijgebied",4,608,-0.19]
["Zwartewaterland","Noordelijk weidegebied",3,586,-0.26]
["Zwijndrecht","Westelijk Holland",7,548,-0.16]
["Zwolle","Noordelijk weidegebied",3,586,-0.26]

{"sheet":"Pachtprijsgebieden Tuinland","index":2,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Gemeente","Pachtprijsgebied","Regio","Regionorn","Veranderpercentage"]
["Westelijk Holland","Westelijk Holland",14,3108,0.15]
["Overig Nederland","Overig Nederland",15,2071,0.22]

{"sheet":"Pachtovereenkomsten","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Sluitingsdatum","Tuinland","Pachtobject","Pachtovereenkomst","Pachtovereenkomst","Titel"]
[]
["voor 1 september 2007","Ja","Hoeve (eventueel met los land)","Reguliere pacht",{"$f":"D3","v":"Reguliere pacht"},"7: 325 BW",1]
["na 1 september 2007","Nee","Los Land","Reservaat pacht",{"$f":"D4","v":"Reservaat pacht"},"7: 388 BW",2]
[null,null,null,"Verpachting door openbare lichamen",{"$f":"D5","v":"Verpachting door openbare lichamen"},"7: 385 BW",3]
[null,null,null,"Geliberaliseerde pacht 0 tot 6 jaar",{"$f":"IF(Berekening!$D$11=2,D6,\"\")","v":"Geliberaliseerde pacht 0 tot 6 jaar"},"7: 397 lid 1 BW",4]
[null,null,null,"Geliberaliseerde pacht 6 tot 12 jaar",{"$f":"IF(Berekening!$D$11=2,D7,\"\")","v":"Geliberaliseerde pacht 6 tot 12 jaar"},"7: 397 lid 2 BW",5]
[null,null,null,"Niet groter dan 1 hectare",{"$f":"IF(Berekening!$D$11=2,D8,\"\")","v":"Niet groter dan 1 hectare"},"7: 395 BW",6]
[null,null,null,"Teeltpacht",{"$f":"IF(Berekening!$D$11=2,D9,\"\")","v":"Teeltpacht"},"7: 396 BW",7]