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

{"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,2652,0.11]
["Overig Nederland","Overig Nederland",15,1073,0.32]

{"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]