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

{"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,2714,0.02]
["Overig Nederland","Overig Nederland",15,1695,0.57999999999999996]

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