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

{"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,1818,0.35]
["Overig Nederland","Overig Nederland",15,727,-0.04]

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