{"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,2015]
[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",1,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 (hoeve)"},2,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: 388 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",2,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,50000]
[]
[null,null,"Oude pachtprijs los land (per hectare)",false,700]
[null,null,"Oude pachtprijs agrarische bedrijfswoning (totaal)",null,0]
[null,null,"Oude pachtprijs agrarische bedrijfsgebouwen (totaal)",null,0]
[]
[null,null,"Pachtprijzenbesluit 2015"]
[]
[null,null,"Gemeente",null,"Barneveld"]
[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.025,0.01)","v":0.01}]
[null,null,null,null,null,null,null,null,{"$f":"IF(D15=1,1,0)","v":0},"Voor 1-9-07",{"$f":"IF(D15=1,1,0)","v":0},"Voor 1-9-07",{"$f":"IF(D15=2,1,0)","v":1},"Na 1-9-07",{"$f":"IF(D15=2,1,0)","v":1},"Na 1-9-07"]
[null,null,"Veranderpercentage agrarische bedrijfsgebouwen",null,8.8000000000000005E-3,null,null,null,{"$f":"IF(E34<0,1,0)","v":0},"Negatief",{"$f":"IF(E34>0,1,0)","v":1},"Positief",{"$f":"IF(E34<0,1,0)","v":0},"Negatief",{"$f":"IF(E34>0,1,0)","v":1},"Positief"]
[null,null,null,null,null,null,null,null,{"$f":"E19*(1+E34)","v":875},"Prijs x veranderpercentage",{"$f":"E19*(1+E34)","v":875},"Prijs x veranderpercentage",{"$f":"E36","v":622},"regionorm",{"$f":"E36","v":622},"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.25},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":559.80000000000007},"Grenswaarde",{"$f":"K34*E36","v":684.2},"Grenswaarde"]
[null,null,"Regionorm",null,{"$f":"IF(D19=FALSE,VLOOKUP(E25,'Pachtprijsgebieden Los Land'!A2:E439,4),IF(E26=\"Westelijk Holland\",2380,811))","v":622},null,null,null,{"$f":"IF(I33<I35,I35,I33)","v":875},null,{"$f":"IF(K33>K35,K35,K33)","v":684.2}]
[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":1000},"2% van vrije verkeerswaarde",{"$f":"2%*$E$17","v":1000},"2% van vrije verkeerswaarde",{"$f":"2%*$E$17*M32*M31","v":0},"2% van vrije verkeerswaarde",{"$f":"2%*$E$17*O31*O32","v":1000},"2% van vrije verkeerswaarde"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I37>I38,I38,I37)","v":0},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":622}]
[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":622},null,{"$f":"IF(D15=1,\"*\",\"\")","v":""}]
[null,null,{"$f":"IF($D$11=1,\"Nieuwe pachtprijs agrarische bedrijfswoning\",\"\")","v":"Nieuwe pachtprijs agrarische bedrijfswoning"},null,{"$f":"IF(D11=1,E20*(1+E30),\"\")","v":0}]
[null,null,{"$f":"IF($D$11=2,\"\",\"Nieuwe pachtprijs agrarische bedrijfsgebouwen\")","v":"Nieuwe pachtprijs agrarische bedrijfsgebouwen"},null,{"$f":"IF(D11=1,E21*(1+E32),\"\")","v":0}]
[]
[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,660,0.22]
["’s-Hertogenbosch","Rivierengebied",10,836,0.1]
["Aa en Hunze","Veenkoloniën en Oldambt",2,689,0.2]
["Aalburg","Rivierengebied",10,836,0.1]
["Aalsmeer","Westelijk Holland",7,660,0.22]
["Aalten","Oostelijk veehouderijgebied",4,634,0.2]
["Abcoude","Hollands/Utrechts weidegebied",9,819,0.16]
["Achtkarspelen","Noordelijk weidegebied",3,738,0.13]
["Alblasserdam","Hollands/Utrechts weidegebied",9,819,0.16]
["Albrandswaard","Westelijk Holland",7,660,0.22]
["Alkmaar","Westelijk Holland",7,660,0.22]
["Almelo","Oostelijk veehouderijgebied",4,634,0.2]
["Almere","Ijsselmeerpolders",6,1174,0.25]
["Alphen aan den Rijn","Hollands/Utrechts weidegebied",9,819,0.16]
["Alphen-Chaam","Zuidelijk veehouderijgebied",13,751,0.16]
["Ameland","Noordelijk weidegebied",3,738,0.13]
["Amersfoort","Hollands/Utrechts weidegebied",9,819,0.16]
["Amstelveen","Westelijk Holland",7,660,0.22]
["Amsterdam","Waterland en Droogmakerijen",8,394,0.25]
["Andijk","Westelijk Holland",7,660,0.22]
["Apeldoorn","Centraal veehouderijgebied",5,622,0.25]
["Appingedam","Veenkoloniën en Oldambt",2,689,0.2]
["Arcen en Velden","Zuidelijk veehouderijgebied",13,751,0.16]
["Arnhem","Rivierengebied",10,836,0.1]
["Assen","Veenkoloniën en Oldambt",2,689,0.2]
["Asten","Zuidelijk veehouderijgebied",13,751,0.16]
["Baarle-Nassau","Zuidelijk veehouderijgebied",13,751,0.16]
["Baarn","Hollands/Utrechts weidegebied",9,819,0.16]
["Barendrecht","Westelijk Holland",7,660,0.22]
["Barneveld","Centraal veehouderijgebied",5,622,0.25]
["Bedum","Noordelijk weidegebied",3,738,0.13]
["Beek","Zuid-Limburg",14,935,0.09]
["Beemster","Waterland en Droogmakerijen",8,394,0.25]
["Beesel","Zuidelijk veehouderijgebied",13,751,0.16]
["Bellingwedde","Veenkoloniën en Oldambt",2,689,0.2]
["Bergambacht","Hollands/Utrechts weidegebied",9,819,0.16]
["Bergeijk","Zuidelijk veehouderijgebied",13,751,0.16]
["Bergen (L)","Zuidelijk veehouderijgebied",13,751,0.16]
["Bergen (NH)","Westelijk Holland",7,660,0.22]
["Bergen op Zoom","Zuidwest Brabant",12,734,0.21]
["Berkelland","Oostelijk veehouderijgebied",4,634,0.2]
["Bernheze","Zuidelijk veehouderijgebied",13,751,0.16]
["Bernisse","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Best","Zuidelijk veehouderijgebied",13,751,0.16]
["Beuningen","Oostelijk veehouderijgebied",4,634,0.2]
["Beverwijk","Westelijk Holland",7,660,0.22]
["Binnenmaas","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Bladel","Zuidelijk veehouderijgebied",13,751,0.16]
["Blaricum","Hollands/Utrechts weidegebied",9,819,0.16]
["Bloemendaal","Westelijk Holland",7,660,0.22]
["Boarnsterhim","Noordelijk weidegebied",3,738,0.13]
["Bodegraven","Hollands/Utrechts weidegebied",9,819,0.16]
["Boekel","Zuidelijk veehouderijgebied",13,751,0.16]
["Bolsward","Noordelijk weidegebied",3,738,0.13]
["Borger-Odoorn","Veenkoloniën en Oldambt",2,689,0.2]
["Borne","Oostelijk veehouderijgebied",4,634,0.2]
["Borsele","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Boskoop","Westelijk Holland",7,660,0.22]
["Boxmeer","Zuidelijk veehouderijgebied",13,751,0.16]
["Boxtel","Zuidelijk veehouderijgebied",13,751,0.16]
["Breda","Zuidwest Brabant",12,734,0.21]
["Breukelen","Hollands/Utrechts weidegebied",9,819,0.16]
["Brielle","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Bronckhorst","Oostelijk veehouderijgebied",4,634,0.2]
["Brummen","Oostelijk veehouderijgebied",4,634,0.2]
["Brunssum","Zuid-Limburg",14,935,0.09]
["Bunnik","Rivierengebied",10,836,0.1]
["Bunschoten","Hollands/Utrechts weidegebied",9,819,0.16]
["Buren","Rivierengebied",10,836,0.1]
["Bussum","Hollands/Utrechts weidegebied",9,819,0.16]
["Capelle aan den IJssel","Westelijk Holland",7,660,0.22]
["Castricum","Westelijk Holland",7,660,0.22]
["Coevorden","Oostelijk veehouderijgebied",4,634,0.2]
["Cranendonck","Zuidelijk veehouderijgebied",13,751,0.16]
["Cromstrijen","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Cuijk","Zuidelijk veehouderijgebied",13,751,0.16]
["Culemborg","Rivierengebied",10,836,0.1]
["Dalfsen","Noordelijk weidegebied",3,738,0.13]
["Dantumadiel","Noordelijk weidegebied",3,738,0.13]
["De Bilt","Hollands/Utrechts weidegebied",9,819,0.16]
["De Marne","Bouwhoek en Hogeland",1,714,0.18]
["De Ronde Venen","Hollands/Utrechts weidegebied",9,819,0.16]
["De Wolden","Noordelijk weidegebied",3,738,0.13]
["Delft","Westelijk Holland",7,660,0.22]
["Delfzijl","Veenkoloniën en Oldambt",2,689,0.2]
["Den Helder","Westelijk Holland",7,660,0.22]
["Deurne","Zuidelijk veehouderijgebied",13,751,0.16]
["Deventer","Oostelijk veehouderijgebied",4,634,0.2]
["Diemen","Hollands/Utrechts weidegebied",9,819,0.16]
["Dinkelland","Oostelijk veehouderijgebied",4,634,0.2]
["Dirksland","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Doesburg","Oostelijk veehouderijgebied",4,634,0.2]
["Doetinchem","Oostelijk veehouderijgebied",4,634,0.2]
["Dongen","Zuidelijk veehouderijgebied",13,751,0.16]
["Dongeradeel","Bouwhoek en Hogeland",1,714,0.18]
["Dordrecht","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Drechterland","Westelijk Holland",7,660,0.22]
["Drimmelen","Zuidelijk veehouderijgebied",13,751,0.16]
["Dronten","Ijsselmeerpolders",6,1174,0.25]
["Druten","Oostelijk veehouderijgebied",4,634,0.2]
["Duiven","Oostelijk veehouderijgebied",4,634,0.2]
["Echt-Susteren","Zuidelijk veehouderijgebied",13,751,0.16]
["Edam-Volendam","Waterland en Droogmakerijen",8,394,0.25]
["Ede","Centraal veehouderijgebied",5,622,0.25]
["Eemnes","Hollands/Utrechts weidegebied",9,819,0.16]
["Eemsmond","Bouwhoek en Hogeland",1,714,0.18]
["Eersel","Zuidelijk veehouderijgebied",13,751,0.16]
["Eijsden","Zuid-Limburg",14,935,0.09]
["Eindhoven","Zuidelijk veehouderijgebied",13,751,0.16]
["Elburg","Centraal veehouderijgebied",5,622,0.25]
["Emmen","Veenkoloniën en Oldambt",2,689,0.2]
["Enkhuizen","Westelijk Holland",7,660,0.22]
["Enschede","Oostelijk veehouderijgebied",4,634,0.2]
["Epe","Centraal veehouderijgebied",5,622,0.25]
["Ermelo","Centraal veehouderijgebied",5,622,0.25]
["Etten-Leur","Zuidwest Brabant",12,734,0.21]
["Ferwerderadiel","Bouwhoek en Hogeland",1,714,0.18]
["Franekeradeel","Bouwhoek en Hogeland",1,714,0.18]
["Gaasterlân-Sleat","Noordelijk weidegebied",3,738,0.13]
["Geertruidenberg","Zuidelijk veehouderijgebied",13,751,0.16]
["Geldermalsen","Rivierengebied",10,836,0.1]
["Geldrop-Mierlo","Zuidelijk veehouderijgebied",13,751,0.16]
["Gemert-Bakel","Zuidelijk veehouderijgebied",13,751,0.16]
["Gennep","Zuidelijk veehouderijgebied",13,751,0.16]
["Giessenlanden","Hollands/Utrechts weidegebied",9,819,0.16]
["Gilze en Rijen","Zuidelijk veehouderijgebied",13,751,0.16]
["Goedereede","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Goes","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Goirle","Zuidelijk veehouderijgebied",13,751,0.16]
["Gorinchem","Hollands/Utrechts weidegebied",9,819,0.16]
["Gouda","Hollands/Utrechts weidegebied",9,819,0.16]
["Graafstroom","Hollands/Utrechts weidegebied",9,819,0.16]
["Graft-De Rijp","Waterland en Droogmakerijen",8,394,0.25]
["Grave","Zuidelijk veehouderijgebied",13,751,0.16]
["Groesbeek","Oostelijk veehouderijgebied",4,634,0.2]
["Groningen","Noordelijk weidegebied",3,738,0.13]
["Grootegast","Noordelijk weidegebied",3,738,0.13]
["Gulpen-Wittem","Zuid-Limburg",14,935,0.09]
["Haaksbergen","Oostelijk veehouderijgebied",4,634,0.2]
["Haaren","Zuidelijk veehouderijgebied",13,751,0.16]
["Haarlem","Westelijk Holland",7,660,0.22]
["Haarlemmerliede en Spaarnwoude","Waterland en Droogmakerijen",8,394,0.25]
["Haarlemmermeer","Westelijk Holland",7,660,0.22]
["Halderberge","Zuidwest Brabant",12,734,0.21]
["Hardenberg","Oostelijk veehouderijgebied",4,634,0.2]
["Harderwijk","Centraal veehouderijgebied",5,622,0.25]
["Hardinxveld-Giessendam","Hollands/Utrechts weidegebied",9,819,0.16]
["Haren","Noordelijk weidegebied",3,738,0.13]
["Harenkarspel","Westelijk Holland",7,660,0.22]
["Harlingen","Bouwhoek en Hogeland",1,714,0.18]
["Hattem","Centraal veehouderijgebied",5,622,0.25]
["Heemskerk","Westelijk Holland",7,660,0.22]
["Heemstede","Westelijk Holland",7,660,0.22]
["Heerde","Centraal veehouderijgebied",5,622,0.25]
["Heerenveen","Noordelijk weidegebied",3,738,0.13]
["Heerhugowaard","Westelijk Holland",7,660,0.22]
["Heerlen","Zuid-Limburg",14,935,0.09]
["Heeze-Leende","Zuidelijk veehouderijgebied",13,751,0.16]
["Heiloo","Westelijk Holland",7,660,0.22]
["Helden","Zuidelijk veehouderijgebied",13,751,0.16]
["Hellendoorn","Oostelijk veehouderijgebied",4,634,0.2]
["Hellevoetsluis","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Helmond","Zuidelijk veehouderijgebied",13,751,0.16]
["Hendrik-Ido-Ambacht","Westelijk Holland",7,660,0.22]
["Hengelo","Oostelijk veehouderijgebied",4,634,0.2]
["Het Bildt","Bouwhoek en Hogeland",1,714,0.18]
["Heumen","Oostelijk veehouderijgebied",4,634,0.2]
["Heusden","Rivierengebied",10,836,0.1]
["Hillegom","Westelijk Holland",7,660,0.22]
["Hilvarenbeek","Zuidelijk veehouderijgebied",13,751,0.16]
["Hilversum","Hollands/Utrechts weidegebied",9,819,0.16]
["Hof van Twente","Oostelijk veehouderijgebied",4,634,0.2]
["Hollands Kroon","Westelijk Holland",7,660,0.22]
["Hoogeveen","Oostelijk veehouderijgebied",4,634,0.2]
["Hoogezand-Sappemeer","Veenkoloniën en Oldambt",2,689,0.2]
["Hoorn","Westelijk Holland",7,660,0.22]
["Horst aan de Maas","Zuidelijk veehouderijgebied",13,751,0.16]
["Houten","Rivierengebied",10,836,0.1]
["Huizen","Hollands/Utrechts weidegebied",9,819,0.16]
["Hulst","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["IJsselstein","Hollands/Utrechts weidegebied",9,819,0.16]
["Kaag en Braassem","Westelijk Holland",7,660,0.22]
["Kampen","Noordelijk weidegebied",3,738,0.13]
["Kapelle","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Katwijk","Westelijk Holland",7,660,0.22]
["Kerkrade","Zuid-Limburg",14,935,0.09]
["Kessel","Zuidelijk veehouderijgebied",13,751,0.16]
["Koggenland","Westelijk Holland",7,660,0.22]
["Kollumerland en Nieuwkruisland","Bouwhoek en Hogeland",1,714,0.18]
["Korendijk","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Krimpen aan den IJssel","Hollands/Utrechts weidegebied",9,819,0.16]
["Laarbeek","Zuidelijk veehouderijgebied",13,751,0.16]
["Landerd","Zuidelijk veehouderijgebied",13,751,0.16]
["Landgraaf","Zuid-Limburg",14,935,0.09]
["Landsmeer","Waterland en Droogmakerijen",8,394,0.25]
["Langedijk","Westelijk Holland",7,660,0.22]
["Lansingerland","Westelijk Holland",7,660,0.22]
["Laren","Hollands/Utrechts weidegebied",9,819,0.16]
["Leek","Noordelijk weidegebied",3,738,0.13]
["Leerdam","Hollands/Utrechts weidegebied",9,819,0.16]
["Leeuwarden","Noordelijk weidegebied",3,738,0.13]
["Leeuwarderadeel","Bouwhoek en Hogeland",1,714,0.18]
["Leiden","Westelijk Holland",7,660,0.22]
["Leiderdorp","Westelijk Holland",7,660,0.22]
["Leidschendam-Voorburg","Westelijk Holland",7,660,0.22]
["Lelystad","Ijsselmeerpolders",6,1174,0.25]
["Lemsterland","Noordelijk weidegebied",3,738,0.13]
["Leudal","Zuidelijk veehouderijgebied",13,751,0.16]
["Leusden","Centraal veehouderijgebied",5,622,0.25]
["Liesveld","Hollands/Utrechts weidegebied",9,819,0.16]
["Lingewaal","Rivierengebied",10,836,0.1]
["Lingewaard","Rivierengebied",10,836,0.1]
["Lisse","Westelijk Holland",7,660,0.22]
["Lith","Zuidelijk veehouderijgebied",13,751,0.16]
["Littenseradiel","Noordelijk weidegebied",3,738,0.13]
["Lochem","Oostelijk veehouderijgebied",4,634,0.2]
["Loenen","Hollands/Utrechts weidegebied",9,819,0.16]
["Loon op Zand","Zuidelijk veehouderijgebied",13,751,0.16]
["Lopik","Hollands/Utrechts weidegebied",9,819,0.16]
["Loppersum","Bouwhoek en Hogeland",1,714,0.18]
["Losser","Oostelijk veehouderijgebied",4,634,0.2]
["Maarssen","Rivierengebied",10,836,0.1]
["Maasbree","Zuidelijk veehouderijgebied",13,751,0.16]
["Maasdonk","Zuidelijk veehouderijgebied",13,751,0.16]
["Maasdriel","Rivierengebied",10,836,0.1]
["Maasgouw","Zuidelijk veehouderijgebied",13,751,0.16]
["Maassluis","Westelijk Holland",7,660,0.22]
["Maastricht","Zuid-Limburg",14,935,0.09]
["Margraten","Zuid-Limburg",14,935,0.09]
["Marum","Noordelijk weidegebied",3,738,0.13]
["Medemblik","Westelijk Holland",7,660,0.22]
["Meerlo-Wanssum","Zuidelijk veehouderijgebied",13,751,0.16]
["Meerssen","Zuid-Limburg",14,935,0.09]
["Meijel","Zuidelijk veehouderijgebied",13,751,0.16]
["Menaldumadeel","Bouwhoek en Hogeland",1,714,0.18]
["Menterwolde","Veenkoloniën en Oldambt",2,689,0.2]
["Meppel","Noordelijk weidegebied",3,738,0.13]
["Middelburg","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Middelharnis","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Midden-Delfland","Westelijk Holland",7,660,0.22]
["Midden-Drenthe","Veenkoloniën en Oldambt",2,689,0.2]
["Mill en Sint Hubert","Zuidelijk veehouderijgebied",13,751,0.16]
["Millingen aan de Rijn","Oostelijk veehouderijgebied",4,634,0.2]
["Moerdijk","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Montferland","Oostelijk veehouderijgebied",4,634,0.2]
["Montfoort","Hollands/Utrechts weidegebied",9,819,0.16]
["Mook en Middelaar","Zuidelijk veehouderijgebied",13,751,0.16]
["Moordrecht","Hollands/Utrechts weidegebied",9,819,0.16]
["Muiden","Hollands/Utrechts weidegebied",9,819,0.16]
["Naarden","Hollands/Utrechts weidegebied",9,819,0.16]
["Neder-Betuwe","Rivierengebied",10,836,0.1]
["Nederlek","Hollands/Utrechts weidegebied",9,819,0.16]
["Nederweert","Zuidelijk veehouderijgebied",13,751,0.16]
["Neerijnen","Rivierengebied",10,836,0.1]
["Nieuwegein","Hollands/Utrechts weidegebied",9,819,0.16]
["Nieuwerkerk aan den IJssel","Westelijk Holland",7,660,0.22]
["Nieuwkoop","Hollands/Utrechts weidegebied",9,819,0.16]
["Nieuw-Lekkerland","Hollands/Utrechts weidegebied",9,819,0.16]
["Nijefurd","Noordelijk weidegebied",3,738,0.13]
["Nijkerk","Centraal veehouderijgebied",5,622,0.25]
["Nijmegen","Rivierengebied",10,836,0.1]
["Noord-Beveland","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Noordenveld","Noordelijk weidegebied",3,738,0.13]
["Noordoostpolder","Ijsselmeerpolders",6,1174,0.25]
["Noordwijk","Westelijk Holland",7,660,0.22]
["Noordwijkerhout","Westelijk Holland",7,660,0.22]
["Nuenen, Gerwen en Nederwetten","Zuidelijk veehouderijgebied",13,751,0.16]
["Nunspeet","Centraal veehouderijgebied",5,622,0.25]
["Nuth","Zuid-Limburg",14,935,0.09]
["Oegstgeest","Westelijk Holland",7,660,0.22]
["Oirschot","Zuidelijk veehouderijgebied",13,751,0.16]
["Oisterwijk","Zuidelijk veehouderijgebied",13,751,0.16]
["Oldebroek","Centraal veehouderijgebied",5,622,0.25]
["Oldenzaal","Oostelijk veehouderijgebied",4,634,0.2]
["Olst-Wijhe","Oostelijk veehouderijgebied",4,634,0.2]
["Ommen","Oostelijk veehouderijgebied",4,634,0.2]
["Onderbanken","Zuid-Limburg",14,935,0.09]
["Oost Gelre","Oostelijk veehouderijgebied",4,634,0.2]
["Oosterhout","Zuidelijk veehouderijgebied",13,751,0.16]
["Oostflakkee","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Ooststellingwerf","Noordelijk weidegebied",3,738,0.13]
["Oostzaan","Waterland en Droogmakerijen",8,394,0.25]
["Opmeer","Westelijk Holland",7,660,0.22]
["Opsterland","Noordelijk weidegebied",3,738,0.13]
["Oss","Zuidelijk veehouderijgebied",13,751,0.16]
["Oud-Beijerland","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Oude IJsselstreek","Oostelijk veehouderijgebied",4,634,0.2]
["Ouder-Amstel","Hollands/Utrechts weidegebied",9,819,0.16]
["Ouderkerk","Hollands/Utrechts weidegebied",9,819,0.16]
["Oudewater","Hollands/Utrechts weidegebied",9,819,0.16]
["Overbetuwe","Rivierengebied",10,836,0.1]
["Papendrecht","Hollands/Utrechts weidegebied",9,819,0.16]
["Pekela","Veenkoloniën en Oldambt",2,689,0.2]
["Pijnacker-Nootdorp","Westelijk Holland",7,660,0.22]
["Purmerend","Waterland en Droogmakerijen",8,394,0.25]
["Putten","Centraal veehouderijgebied",5,622,0.25]
["Raalte","Oostelijk veehouderijgebied",4,634,0.2]
["Reeuwijk","Hollands/Utrechts weidegebied",9,819,0.16]
["Reiderland","Veenkoloniën en Oldambt",2,689,0.2]
["Reimerswaal","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Renkum","Rivierengebied",10,836,0.1]
["Renswoude","Centraal veehouderijgebied",5,622,0.25]
["Reusel-De Mierden","Zuidelijk veehouderijgebied",13,751,0.16]
["Rheden","Oostelijk veehouderijgebied",4,634,0.2]
["Rhenen","Centraal veehouderijgebied",5,622,0.25]
["Ridderkerk","Westelijk Holland",7,660,0.22]
["Rijnwaarden","Oostelijk veehouderijgebied",4,634,0.2]
["Rijnwoude","Westelijk Holland",7,660,0.22]
["Rijssen-Holten","Oostelijk veehouderijgebied",4,634,0.2]
["Rijswijk","Westelijk Holland",7,660,0.22]
["Roerdalen","Zuidelijk veehouderijgebied",13,751,0.16]
["Roermond","Zuidelijk veehouderijgebied",13,751,0.16]
["Roosendaal","Zuidwest Brabant",12,734,0.21]
["Rotterdam","Westelijk Holland",7,660,0.22]
["Rozenburg","Westelijk Holland",7,660,0.22]
["Rozendaal","Rivierengebied",10,836,0.1]
["Rucphen","Zuidwest Brabant",12,734,0.21]
["Schagen","Westelijk Holland",7,660,0.22]
["Scheemda","Veenkoloniën en Oldambt",2,689,0.2]
["Schermer","Waterland en Droogmakerijen",8,394,0.25]
["Scherpenzeel","Centraal veehouderijgebied",5,622,0.25]
["Schiedam","Westelijk Holland",7,660,0.22]
["Schiermonnikoog","Noordelijk weidegebied",3,738,0.13]
["Schijndel","Zuidelijk veehouderijgebied",13,751,0.16]
["Schinnen","Zuid-Limburg",14,935,0.09]
["Schoonhoven","Hollands/Utrechts weidegebied",9,819,0.16]
["Schouwen-Duiveland","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Sevenum","Zuidelijk veehouderijgebied",13,751,0.16]
["Simpelveld","Zuid-Limburg",14,935,0.09]
["Sint Anthonis","Zuidelijk veehouderijgebied",13,751,0.16]
["Sint-Michielsgestel","Zuidelijk veehouderijgebied",13,751,0.16]
["Sint-Oedenrode","Zuidelijk veehouderijgebied",13,751,0.16]
["Sittard-Geleen","Zuid-Limburg",14,935,0.09]
["Skarsterlân","Noordelijk weidegebied",3,738,0.13]
["Sliedrecht","Hollands/Utrechts weidegebied",9,819,0.16]
["Slochteren","Veenkoloniën en Oldambt",2,689,0.2]
["Sluis","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Smallingerland","Noordelijk weidegebied",3,738,0.13]
["Sneek","Noordelijk weidegebied",3,738,0.13]
["Soest","Hollands/Utrechts weidegebied",9,819,0.16]
["Someren","Zuidelijk veehouderijgebied",13,751,0.16]
["Son en Breugel","Zuidelijk veehouderijgebied",13,751,0.16]
["Spijkenisse","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Stadskanaal","Veenkoloniën en Oldambt",2,689,0.2]
["Staphorst","Noordelijk weidegebied",3,738,0.13]
["Stede Broec","Westelijk Holland",7,660,0.22]
["Steenbergen","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Steenwijkerland","Noordelijk weidegebied",3,738,0.13]
["Stein","Zuid-Limburg",14,935,0.09]
["Strijen","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Ten Boer","Noordelijk weidegebied",3,738,0.13]
["Terneuzen","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Terschelling","Noordelijk weidegebied",3,738,0.13]
["Texel","Westelijk Holland",7,660,0.22]
["Teylingen","Westelijk Holland",7,660,0.22]
["Tholen","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Tiel","Rivierengebied",10,836,0.1]
["Tilburg","Zuidelijk veehouderijgebied",13,751,0.16]
["Tubbergen","Oostelijk veehouderijgebied",4,634,0.2]
["Twenterand","Oostelijk veehouderijgebied",4,634,0.2]
["Tynaarlo","Veenkoloniën en Oldambt",2,689,0.2]
["Tytsjerksteradiel","Noordelijk weidegebied",3,738,0.13]
["Ubbergen","Oostelijk veehouderijgebied",4,634,0.2]
["Uden","Zuidelijk veehouderijgebied",13,751,0.16]
["Uitgeest","Waterland en Droogmakerijen",8,394,0.25]
["Uithoorn","Westelijk Holland",7,660,0.22]
["Urk","Ijsselmeerpolders",6,1174,0.25]
["Utrecht","Rivierengebied",10,836,0.1]
["Utrechtse Heuvelrug","Rivierengebied",10,836,0.1]
["Vaals","Zuid-Limburg",14,935,0.09]
["Valkenburg aan de Geul","Zuid-Limburg",14,935,0.09]
["Valkenswaard","Zuidelijk veehouderijgebied",13,751,0.16]
["Veendam","Veenkoloniën en Oldambt",2,689,0.2]
["Veenendaal","Centraal veehouderijgebied",5,622,0.25]
["Veere","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Veghel","Zuidelijk veehouderijgebied",13,751,0.16]
["Veldhoven","Zuidelijk veehouderijgebied",13,751,0.16]
["Velsen","Westelijk Holland",7,660,0.22]
["Venlo","Zuidelijk veehouderijgebied",13,751,0.16]
["Venray","Zuidelijk veehouderijgebied",13,751,0.16]
["Vianen","Hollands/Utrechts weidegebied",9,819,0.16]
["Vlaardingen","Westelijk Holland",7,660,0.22]
["Vlagtwedde","Veenkoloniën en Oldambt",2,689,0.2]
["Vlieland","Noordelijk weidegebied",3,738,0.13]
["Vlissingen","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Vlist","Hollands/Utrechts weidegebied",9,819,0.16]
["Voerendaal","Zuid-Limburg",14,935,0.09]
["Voorschoten","Westelijk Holland",7,660,0.22]
["Voorst","Oostelijk veehouderijgebied",4,634,0.2]
["Vught","Rivierengebied",10,836,0.1]
["Waalre","Zuidelijk veehouderijgebied",13,751,0.16]
["Waalwijk","Zuidelijk veehouderijgebied",13,751,0.16]
["Waddinxveen","Westelijk Holland",7,660,0.22]
["Wageningen","Rivierengebied",10,836,0.1]
["Wassenaar","Westelijk Holland",7,660,0.22]
["Waterland","Waterland en Droogmakerijen",8,394,0.25]
["Weert","Zuidelijk veehouderijgebied",13,751,0.16]
["Weesp","Hollands/Utrechts weidegebied",9,819,0.16]
["Werkendam","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Wervershoof","Westelijk Holland",7,660,0.22]
["West Maas en Waal","Oostelijk veehouderijgebied",4,634,0.2]
["Westerveld","Noordelijk weidegebied",3,738,0.13]
["Westervoort","Oostelijk veehouderijgebied",4,634,0.2]
["Westland","Westelijk Holland",7,660,0.22]
["Weststellingwerf","Noordelijk weidegebied",3,738,0.13]
["Westvoorne","Zuidwestelijk akkerbouwgebied",11,708,0.11]
["Wierden","Oostelijk veehouderijgebied",4,634,0.2]
["Wijchen","Oostelijk veehouderijgebied",4,634,0.2]
["Wijdemeren","Hollands/Utrechts weidegebied",9,819,0.16]
["Wijk bij Duurstede","Rivierengebied",10,836,0.1]
["Winschoten","Veenkoloniën en Oldambt",2,689,0.2]
["Winsum","Noordelijk weidegebied",3,738,0.13]
["Winterswijk","Oostelijk veehouderijgebied",4,634,0.2]
["Woensdrecht","Zuidwest Brabant",12,734,0.21]
["Woerden","Hollands/Utrechts weidegebied",9,819,0.16]
["Wormerland","Waterland en Droogmakerijen",8,394,0.25]
["Woudenberg","Centraal veehouderijgebied",5,622,0.25]
["Woudrichem","Rivierengebied",10,836,0.1]
["Wûnseradiel","Noordelijk weidegebied",3,738,0.13]
["Wymbritseradiel","Noordelijk weidegebied",3,738,0.13]
["Zaanstad","Waterland en Droogmakerijen",8,394,0.25]
["Zaltbommel","Rivierengebied",10,836,0.1]
["Zandvoort","Westelijk Holland",7,660,0.22]
["Zederik","Hollands/Utrechts weidegebied",9,819,0.16]
["Zeevang","Waterland en Droogmakerijen",8,394,0.25]
["Zeewolde","Ijsselmeerpolders",6,1174,0.25]
["Zeist","Rivierengebied",10,836,0.1]
["Zevenaar","Oostelijk veehouderijgebied",4,634,0.2]
["Zevenhuizen-Moerkapelle","Westelijk Holland",7,660,0.22]
["Zijpe","Westelijk Holland",7,660,0.22]
["Zoetermeer","Westelijk Holland",7,660,0.22]
["Zoeterwoude","Westelijk Holland",7,660,0.22]
["Zuidhorn","Noordelijk weidegebied",3,738,0.13]
["Zundert","Zuidwest Brabant",12,734,0.21]
["Zutphen","Oostelijk veehouderijgebied",4,634,0.2]
["Zwartewaterland","Noordelijk weidegebied",3,738,0.13]
["Zwijndrecht","Westelijk Holland",7,660,0.22]
["Zwolle","Noordelijk weidegebied",3,738,0.13]

{"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,2380,0.31]
["Overig Nederland","Overig Nederland",15,811,0.12]

{"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":""},"7: 397 lid 1 BW",4]
[null,null,null,"Geliberaliseerde pacht 6 tot 12 jaar",{"$f":"IF(Berekening!$D$11=2,D7,\"\")","v":""},"7: 397 lid 2 BW",5]
[null,null,null,"Niet groter dan 1 hectare",{"$f":"IF(Berekening!$D$11=2,D8,\"\")","v":""},"7: 395 BW",6]
[null,null,null,"Teeltpacht",{"$f":"IF(Berekening!$D$11=2,D9,\"\")","v":""},"7: 396 BW",7]