{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Rekenblad","Gemeenten met categorie","Invoerscherm","INFO"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"Rekenblad","index":0,"n_rows":82,"n_cols":15,"rows_kept":82,"cut":false,"hidden":false,"merged":[[80,1,80,11],[12,3,12,4],[9,3,9,6],[13,3,13,4],[10,3,10,4],[10,5,10,6],[55,3,55,4],[39,3,39,4],[41,0,41,2],[42,3,42,4],[54,1,54,2],[60,1,60,2],[58,1,58,2],[57,1,57,2],[68,0,69,0],[68,1,68,2],[63,0,64,0],[65,1,65,2],[69,1,69,2],[64,1,64,2],[66,1,66,2],[59,1,59,2],[45,1,45,2],[46,3,46,4],[4,11,4,12],[2,13,2,14],[4,13,4,14],[2,1,2,3],[2,5,2,10],[3,1,3,10],[4,1,4,10],[3,12,3,14],[2,11,2,12],[38,13,38,14],[39,13,39,14],[40,13,40,14],[24,10,24,11],[49,3,49,4],[45,3,45,4],[50,3,50,4],[46,1,46,2],[5,13,5,14],[5,11,5,12],[5,5,5,10],[13,8,13,12],[11,5,11,6],[9,8,9,12],[10,8,11,12],[10,13,11,14],[12,8,12,12],[28,10,28,11],[12,13,12,14],[14,13,15,14],[16,13,17,14],[13,13,13,14],[27,10,27,11],[20,8,20,11],[21,8,22,9],[21,10,22,11],[27,8,27,9],[14,8,15,12],[16,8,17,12],[18,7,18,12],[21,5,22,7],[18,5,18,6],[14,7,15,7],[16,7,17,7],[23,8,23,9],[23,10,23,11],[24,8,24,9],[26,8,26,9],[25,10,25,11],[25,8,25,9],[26,10,26,11],[18,13,18,14],[64,13,64,14],[68,13,68,14],[66,13,66,14],[71,13,71,14],[67,13,67,14],[70,13,70,14],[34,13,34,14],[36,13,36,14],[51,13,51,14],[37,13,37,14],[35,13,35,14],[46,13,46,14],[47,13,47,14],[48,13,48,14],[50,13,50,14],[41,13,41,14],[43,13,43,14],[60,13,60,14],[59,13,59,14],[63,13,63,14],[62,13,62,14],[42,13,42,14],[45,13,45,14],[78,5,78,6],[74,13,74,14],[75,13,75,14],[73,13,73,14],[76,11,76,12],[76,13,76,14],[72,13,72,14],[65,13,65,14],[69,13,69,14],[66,3,66,4],[69,3,69,4],[61,1,61,2],[44,13,44,14],[52,13,52,14],[56,13,56,14],[54,13,54,14],[55,13,55,14],[51,3,51,4],[57,3,57,4],[58,3,58,4],[53,3,53,4],[44,3,44,4],[49,13,49,14],[57,13,57,14],[58,13,58,14],[53,13,53,14],[34,3,34,4],[32,1,32,2],[31,8,31,9],[63,1,63,2],[41,3,41,4],[40,3,40,4],[39,1,39,2],[35,3,35,4],[56,1,56,2],[56,3,56,4],[54,3,54,4],[52,1,52,2],[51,1,51,2],[53,1,53,2],[55,1,55,2],[52,3,52,4],[59,3,59,4],[50,1,50,2],[31,0,31,1],[60,3,60,4],[63,3,63,4],[78,2,78,3],[75,1,75,2],[75,3,75,4],[72,3,72,4],[74,1,74,2],[74,3,74,4],[44,0,44,2],[40,1,40,2],[37,0,37,2],[43,3,43,4],[49,0,50,0],[43,0,43,2],[42,0,42,2],[71,3,71,4],[71,1,71,2],[49,1,49,2],[73,1,73,2],[73,3,73,4],[72,1,72,2],[70,1,70,2],[70,3,70,4],[68,3,68,4],[65,3,65,4],[64,3,64,4],[29,8,29,9],[28,5,28,9],[36,3,36,4],[30,8,30,9],[35,0,35,2],[36,0,36,2],[18,3,18,4],[37,3,37,4],[38,3,38,4],[34,0,34,2],[30,0,30,1],[24,0,24,1],[29,0,29,1],[27,0,27,1],[20,0,20,1],[22,0,22,1],[21,0,21,1],[23,0,23,1],[19,0,19,4],[21,2,22,4],[25,0,25,1],[38,1,38,2],[28,2,28,4],[26,0,26,1],[14,1,14,2],[17,0,17,1],[15,0,15,1],[15,5,15,6],[16,5,16,6],[17,5,17,6],[0,0,0,9],[13,1,13,2],[13,5,13,6],[14,5,14,6],[12,5,12,6],[9,0,9,2],[1,0,1,8],[10,1,10,2],[11,1,11,2],[10,7,11,7],[12,1,12,2],[15,3,15,4],[11,3,11,4],[16,3,17,4],[16,0,16,1],[14,3,14,4]]}
["Melding en berekening straatwerk,  2017",null,null,null,null,null,null,null,null,null,null,null,null,null,"                              2017_1"]
["volgens de Richtlijn Tarieven (graaf) werkzaamheden Telecom dd 12-03-2004.",null,null,null,null,null,null,null,null,null,null,null,"Datum:",{"$f":"NOW()","v":"2016-11-15T11:46:00.020"}]
["AANVRAGER:","……………………………….",null,null,"adres:","……………………………………………………………………",null,null,null,null,null,"Kontaktpersoon:",null,"………………….."]
["NAAM PROJECT:",null,null,null,null,null,null,null,null,null,null,"E-mail:","………………………………."]
["PLAATS:","…………………………………………………………………………………………………..",null,null,null,null,null,null,null,null,null,"telefoon:",null,"………………….."]
["GEMEENTE:",null,null,null,"adres:",{"$f":"IF($B$7>0.1,VLOOKUP(B7,'Gemeenten met categorie'!A3:F484,4),\"\")","v":"  Postbus 20, 6560 AA GROESBEEK"},null,null,null,null,null,"mobiel:",null,"………………….."]
[null,31,null,{"$f":"IF($B$7>0.1,VLOOKUP($B$7,'Gemeenten met categorie'!A2:D493,3),\"\")","v":1}]
["Uitvoering:"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,"  "]
["Gemeentelijke gegevens:",null,null,"Verzamelde informatie:",null,null,null,"Task:","Discipline:",null,null,null,null,"bedrag:"]
["Kontaktpersoon gem.:","……………………….",null,"Inkoopordernr.:",null,"Projektnr:",null,"A","Herstel & onderhoud uitgevoerd door de wegbeheerder:",null,null,null,null,{"$f":"SUM(N35:N47)","v":0}]
["E-mail:","………………………",null,"………………",null,"……………."]
["telefoon:","………………………",null,"Datum opbreking:",null,"………………..",null,"B1","Herstel & onderhoud aanbieder",null,null,null,null,{"$f":"IF($B$9=2,(SUM($N$50:$N$61)),0)","v":0}]
["mobiel:","………………………",null,"Datum herstel:",null,"………………..",null,"B2","Herstel aanb. & onderh. wegbeh.",null,null,null,null,{"$f":"IF(($B$9=3),(SUM($N$50:$N$61)),0)","v":0}]
["Opdrachtnummer :","………………………",null,"Deellevering:",null,"………………..",null,"C","Herstel wegbeheerder voor al- gehele herbestrating",null,null,null,null,{"$f":"SUM(N64:N67)","v":0}]
["In te vullen gegevens:",null,null,"Laatste levering:",null,"……………….."]
["= Richtlijn tarief",null,null,"Uitvoerende aannemer:",null,"………………..",null,"D","Overige tarieven, herstel en onderhoud beheerder",null,null,null,null,{"$f":"SUM(N69:N76)","v":0}]
["= Af te spreken projektprijs",null,null,null,null,"…………………"]
[null,null,null,null,null,"…………………",null,"Totaal kosten:  ",null,null,null,null,null,{"$f":"SUM(N11:N18)","v":0}]
["OMSCHRIJVING STRAATWERK / BERMEN;"]
[{"$f":"+IF(AND(D25>0,D25<0.3),(\"invoer fout breedte tegels\"),IF(AND(D26>0,D26<0.3),(\"invoer fout breedte tegels\"),IF(AND(D27>0,D27<0.3),(\"invoer fout breedte tegels\"),\"\")))","v":""},null,null,null,"          sleuf",null,null,null,"opsluiting"]
[{"$f":"+IF(AND(G25>0,G25<0.25),(\"invoer fout breedte klinkers\"),IF(AND(G26>0,G26<0.25),(\"invoer fout breedte klinkers\"),IF(AND(G27>0,G27<0.25),(\"invoer fout breedte klinkers\"),\"\")))","v":""},null,"tegels *",null,null,"klinkers *",null,null,"trottoir-banden:",null,"opsluit- / koprolband "]
[]
["adres",null,"lengte","breedte","m2","lengte","breedte","m2","m1",null,"m1"]
["………………………………….",null,null,null,{"$f":"IF($D$25>=0.3,($C$25*$D$25),\"\")","v":""},null,null,{"$f":"IF($G$25>=0.25,($F$25*$G$25),\"\")","v":""}]
["………………………………….",null,null,null,{"$f":"IF($D$26>=0.3,($C$26*$D$26),\"\")","v":""},null,null,{"$f":"IF($G$26>=0.25,($F$26*$G$26),\"\")","v":""}]
["………………………………….",null,null,null,{"$f":"IF($D$27>=0.3,($C$27*$D$27),\"\")","v":""},null,null,{"$f":"IF($G$27>=0.25,($F$27*$G$27),\"\")","v":""}]
[null,null,{"$f":"SUM(C25:C27)","v":0},null,{"$f":"SUM(E25:E27)","v":0},{"$f":"SUM(F25:F27)","v":0},null,{"$f":"SUM(H25:H27)","v":0},{"$f":"SUM(I25:J27)","v":0},null,{"$f":"SUM(K25:L27)","v":0},null,{"$f":"SUM(M25:M27)","v":0},{"$f":"SUM(N25:N27)","v":0}]
[null,null,"Bermen, gazon all in*",null,null,"Bomen en Struiken",null,null,null,null,"Asfalt, all in*",null,"Dikte","Prijs"]
["adres",null,"lengte","breedte","m2",null,"eenh.","prijs ","kosten",null,"lengte","breedte","in cm","m2/cm","kosten"]
["…………………………………",null,null,null,{"$f":"IF($C31>0,$C31*($D31+0),\"\")","v":""},"Bomen ",0,0,{"$f":"IF($G31>0,$H31*($G31+0),\"\")","v":""},null,null,null,null,null,{"$f":"IF($K31>0,($K$31*$L$31*$M$31)*($N$31),\"\")","v":""}]
["…………………………………",null,null,null,{"$f":"IF($C32>0,$C32*($D32+0),\"\")","v":""},"Struiken",0,0,{"$f":"IF($G32>0,$H32*($G32+0),\"\")","v":""},null,0,0,0,0,{"$f":"IF($K32>0,($K$32*$L$32*$M$32)*($N$32),\"\")","v":""}]
["Specificatie:",null,null,null,{"$f":"SUM(E31:E32)","v":0},{"$f":"SUM(F31:F32)","v":0},{"$f":"G31","v":0},{"$f":"SUM(H31:I32)","v":0},null,null,{"$f":"SUM(M31:M32)","v":0},null,null,{"$f":"SUM(O31:O32)","v":0}]
["Tarief: A.",null,"* de gedifinieerde sleufbreedte dient te worden aangegeven ,automatisch wordt de gatvergrotingstoeslag toegevoegd volgens de gestelde norm."]
["Uitvoering, onderhoud & beheer klinkers:",null,null,"=<15m²",null,null,{"$f":"IF(AND($B$9=1,K35>0),('Gemeenten met categorie'!K2),0)","v":0},"m²","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I2),\"\")","v":0},"per m²","=        €",{"$f":"IF(AND('Gemeenten met categorie'!K2>=0.29,K35>10),('Gemeenten met categorie'!K2*K35),\"\")","v":""}]
["Uitvoering, onderhoud & beheer klinkers:",null,null,">15m²",null,null,{"$f":"IF(AND($B$9=1,K36>0),('Gemeenten met categorie'!K3),0)","v":0},"m²","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I3),\"\")","v":0},"per m²","=        €",{"$f":"IF(AND('Gemeenten met categorie'!K3>1,K36>10),('Gemeenten met categorie'!K3*K36),\"\")","v":""}]
["Uitvoering, onderhoud & beheer klinkers:",null,null,">100m²",null,null,{"$f":"IF(AND($B$9=1,K37>0),('Gemeenten met categorie'!K4),0)","v":0},"m²","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I4),\"\")","v":0},"per m²","=        €",{"$f":"IF(AND('Gemeenten met categorie'!K4>=1,K37>10),('Gemeenten met categorie'!K4*K37),\"\")","v":""}]
["Degeneratie klinkers:",null,null,"per reparatie =<15m²",null,null,{"$f":"IF(AND($B$9=1,K38>0),('Gemeenten met categorie'!K5),0)","v":0},"eenh.","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I5),\"\")","v":0},"per eenh.","=        €",{"$f":"IF(AND('Gemeenten met categorie'!K5>=1,K38>0.11),('Gemeenten met categorie'!K5*K38),\"\")","v":""}]
[null,"Degeneratie per m1:",null,">15m²",null,null,{"$f":"IF(AND($B$9=1,K39>0),('Gemeenten met categorie'!K7),0)","v":0},"m","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I7),\"\")","v":0},"per m","=        €",{"$f":"IF(AND('Gemeenten met categorie'!K7>=1,K39>0.1),('Gemeenten met categorie'!K7*K39),\"\")","v":""}]
[null,"Degeneratie per m1:",null,">100m²",null,null,{"$f":"IF(AND($B$9=1,K40>0),('Gemeenten met categorie'!K8),0)","v":0},"m","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I8),\"\")","v":0},"per m","=        €",{"$f":"IF(AND('Gemeenten met categorie'!K8>=1,K40>0.1),('Gemeenten met categorie'!K8*K40),\"\")","v":""}]
[]
["Uitvoering, onderhoud & beheer tegels:",null,null,"=<15m²",null,null,{"$f":"IF(AND($B$9=1,K42>0),('Gemeenten met categorie'!K9),0)","v":0},"m²","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I9),\"\")","v":0},"per m²","=        €",{"$f":"IF(AND(G42>0,K42>0),(G42*K42),\"\")","v":""}]
["Uitvoering, onderhoud & beheer tegels:",null,null,">15m²",null,null,{"$f":"IF(AND($B$9=1,K43>0),('Gemeenten met categorie'!K10),0)","v":0},"m²","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I10),\"\")","v":0},"per m²","=        €",""]
["Uitvoering, onderhoud & beheer tegels:",null,null,">100m²",null,null,{"$f":"IF(AND($B$9=1,K44>0),('Gemeenten met categorie'!K11),0)","v":0},"m²","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I11),\"\")","v":0},"per m²","=        €",""]
["Degeneratie tegels:",null,null,"per reparatie =<15m²",null,null,{"$f":"IF(AND($B$9=1,K45>0),('Gemeenten met categorie'!K12),0)","v":0},"eenh.","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!I12),\"\")","v":0},"per eenh.","=        €",""]
[null,"Degeneratie per m1:",null,"=<15m²",null,null,{"$f":"IF(AND($B$9=1,K46>0),('Gemeenten met categorie'!$K$14),0)","v":0},"m","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!$I$14),\"\")","v":0},"per m","=        €",{"$f":"IF(AND(G46>0,K46>0),(G46*K46),\"\")","v":""}]
[null,"Degeneratie per m1:",null,">100m²",null,null,{"$f":"IF(AND($B$9=1,K47>0),('Gemeenten met categorie'!$K$15),0)","v":0},"m","à","€",{"$f":"IF(($B$9=1),('Gemeenten met categorie'!$I$15),\"\")","v":0},"per m","=        €",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
["Tarief: B 1 & 2.","Degeneratie klinkers:",null,"per reparatie =<15m²",null,null,{"$f":"IF(AND($B$9>1,$B$9<4,K50>0),('Gemeenten met categorie'!K18),0)","v":0},"eenh.","à","€",{"$f":"IF(AND($B$9>1,$B$9<4),('Gemeenten met categorie'!I18),\"\")","v":""},"per eenh.","=        €",{"$f":"IF(AND(G50>0,K50>0),(G50*K50),\"\")","v":""}]
[null,"Degeneratie klinkers:",null,"=>15m²",null,null,{"$f":"IF(AND($B$9>1,$B$9<4,K51>0),('Gemeenten met categorie'!K19),0)","v":0},"m","à","€",{"$f":"IF(AND($B$9>1,$B$9<4,$H$28>15),('Gemeenten met categorie'!I19),\"\")","v":""},"per m","=        €",{"$f":"IF(AND(G51>0,K51>0),(G51*K51),\"\")","v":""}]
[null,"Beheerskosten klinkers:",null,"=<15m²",null,null,{"$f":"IF(AND($B$9>1,$B$9<4,K52>0),('Gemeenten met categorie'!K22),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9>1,$B$9<4,$H$28<=15),('Gemeenten met categorie'!I22),\"\")","v":""},"per m²","=        €",""]
[null,"Beheerskosten klinkers:",null,">15m²",null,null,{"$f":"IF(AND($B$9>1,$B$9<4,K53>0),('Gemeenten met categorie'!$K$23),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9>1,$B$9<4,$H$28>15),('Gemeenten met categorie'!$I$23),\"\")","v":""},"per m²","=        €",""]
[null,"Onderhoud  klinkers:",null,"=<15m²",null,null,{"$f":"IF(AND($B$9=3,K54>0),('Gemeenten met categorie'!$K$28),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9=3),('Gemeenten met categorie'!$I$28),\"\")","v":""},"per m²","=        €",""]
[null,"Onderhoud  klinkers:",null,">15m²",null,null,{"$f":"IF(AND($B$9=3,K55>0),('Gemeenten met categorie'!$K$29),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9=3),('Gemeenten met categorie'!$I$29),\"\")","v":""},"per m²","=        €",""]
[null,"Onderhoud tegels:",null,"=<15m²",null,null,{"$f":"IF(AND($B$9=3,K56>0),('Gemeenten met categorie'!K30),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9=3),('Gemeenten met categorie'!I30),\"\")","v":""},"per m²","=        €",""]
[null,"Onderhoud tegels:",null,">15m²",null,null,{"$f":"IF(AND($B$9=3,K57>0),('Gemeenten met categorie'!K31),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9=3),('Gemeenten met categorie'!I31),\"\")","v":""},"per m²","=        €",""]
[null,"Beheerskosten tegels:",null,"=<15m²",null,null,{"$f":"IF(AND($B$9>1,$B$9<4,K58>0),('Gemeenten met categorie'!K24),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9>1,$B$9<4,$E$28<=15),('Gemeenten met categorie'!I24),\"\")","v":""},"per m²","=        €",""]
[null,"Beheerskosten tegels:",null,">15m²",null,null,{"$f":"IF(AND($B$9>1,$B$4,K59>0),('Gemeenten met categorie'!K25),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9>1,$B$9<4,$E$28>15),('Gemeenten met categorie'!I25),\"\")","v":""},"per m²","=        €",""]
[null,"Degeneratie tegels:",null,"per reparatie =<15m²",null,null,{"$f":"IF(AND($B$9>1,$B$9<4,K60>0),('Gemeenten met categorie'!K20),0)","v":0},"eenh.","à","€",{"$f":"IF(AND($B$9>1,$B$9<4,$E$28<=15),('Gemeenten met categorie'!I20),\"\")","v":""},"per eenh.","=        €",""]
[null,"Degeneratie tegels:",null,">15m²",null,null,{"$f":"IF(AND($B$9>1,$B$9<4,K61>0),('Gemeenten met categorie'!K21),0)","v":0},"m","à","€",{"$f":"IF(AND($B$9>1,$B$9<4,$E$28>15),('Gemeenten met categorie'!I21),\"\")","v":""},"per m","=        €",""]
[]
[]
["Tarief: C.","All in klinkers:",null,"=<15m²",null,null,{"$f":"IF(AND($B$9=4,K64>0),('Gemeenten met categorie'!K34),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9=4,$H$28>0,$H$28<=15),('Gemeenten met categorie'!I34),\"\")","v":""},"per m²","=        €",{"$f":"IF(AND(G64>0,K64>0),(G64*K64),\"\")","v":""}]
[null,"All in klinkers:",null,">15m²",null,null,{"$f":"IF(AND($B$9=4,K65>0),('Gemeenten met categorie'!K35),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9=4,$H$28>15),('Gemeenten met categorie'!I35),\"\")","v":""},"per m²","=        €",""]
[null,"All in tegels:",null,"=<15m²",null,null,{"$f":"IF(AND($B$9=4,K66>0),('Gemeenten met categorie'!K36),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9=4,$E$28>0,$E$28<=15),('Gemeenten met categorie'!I36),\"\")","v":""},"per m²","=        €",""]
[null,"All in tegels:",null,">15m²",null,null,{"$f":"IF(AND($B$9=4,K67>0),('Gemeenten met categorie'!K37),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9=4,$E$28>15),('Gemeenten met categorie'!I37),\"\")","v":""},"per m²","=        €",""]
[]
["Tarief: D.","All in trottoirband:",null,"per m1",null,null,{"$f":"IF(AND($B$9>0,$B$9<5,K69>0),('Gemeenten met categorie'!K40),\"\")","v":0},"m","à","€",{"$f":"IF(AND($B$9>=1,$I$28>=1),('Gemeenten met categorie'!I40),\"\")","v":""},"per m","=        €",""]
[null,"All in opsluitband/koprol:",null,"per m1",null,null,{"$f":"IF(AND($B$9>0,$B$9<5,K70>0),('Gemeenten met categorie'!K41),\"\")","v":0},"m","à","€",{"$f":"IF(AND($B$9>=1,$K$28>=1),('Gemeenten met categorie'!I41),\"\")","v":""},"per m","=        €",""]
[null,"All in berm/gazon:",null,"per reparatie =<50m²",null,null,{"$f":"IF(AND($B$9>0,$B$9<5,$E$33>0),('Gemeenten met categorie'!K42),0)","v":0},"eenh.","à","€",{"$f":"IF(AND($B$9>=1,$E$33>=1),('Gemeenten met categorie'!I42),\"\")","v":""},"per eenh.","=        €",""]
[null,"All in berm/gazon:",null,">50m²",null,null,{"$f":"IF(AND($B$9>0,$B$9<5,E33>0),('Gemeenten met categorie'!K43),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9>=1,$E$33>=1),('Gemeenten met categorie'!I43),\"\")","v":""},"per m²","=        €",""]
[null,"All in bomen:",null,"stuks",null,null,{"$f":"G31","v":0},"sts","à","€",{"$f":"IF(AND($B$9>=1,$G$31>=1),('Gemeenten met categorie'!I44),\"\")","v":""},"stuks","=        €",{"$f":"IF(AND(G73>1,K73>1),G73*K73,\"\")","v":""}]
[null,"All in struiken:",null,"stuks",null,null,{"$f":"G32","v":0},"sts","à","€",{"$f":"IF(AND($B$9>=1,$G$32>=1),('Gemeenten met categorie'!I45),\"\")","v":""},"stuks","=        €",""]
[null,"All in asfalt:",null,"per m²",null,null,{"$f":"IF(AND($B$9>=1,$B$9<=4,K75>0),('Gemeenten met categorie'!K46),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9>=1,$K$31>=1),('Gemeenten met categorie'!I46),\"\")","v":""},"per m²","=        €",{"$f":"IF(AND(G75>1,K75>0.1),(G75*K75),\"\")","v":""}]
[null,"All in asfalt:",null,"per m²",null,null,{"$f":"IF(AND($B$9>=1,$B$9<=4,K76>0),('Gemeenten met categorie'!K47),0)","v":0},"m²","à","€",{"$f":"IF(AND($B$9>=1,$K$32>=1),('Gemeenten met categorie'!I47),\"\")","v":""},"per m²","=        €",{"$f":"IF(AND(G76>1,K76>0.1),(G76*K76),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Totaal:",null,{"$f":"SUM(N35:N76)","v":0}]
[]
["Naam en paraaf budgethouder:",null,{"$f":"N3","v":"………………….."},null,"d.d.",null,null,null,"Afgewerk d.d."]
[]
["Factuuradres:","………………………………………………………………………………………………………."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($B$9>1,$B$9<4,$E$28<=15),('Gemeenten met categorie'!L41),\"\")","v":""}]

{"sheet":"Gemeenten met categorie","index":1,"n_rows":502,"n_cols":38,"rows_kept":502,"cut":false,"hidden":false,"merged":[[114,4,114,6],[106,4,106,6],[120,4,120,6],[100,4,100,6],[68,11,68,12],[75,4,75,6],[76,4,76,6],[77,4,77,6],[81,4,81,6],[88,4,88,6],[94,4,94,6],[68,13,68,16],[155,4,155,6],[205,4,205,6],[193,4,193,6],[68,9,68,10],[73,7,73,8],[73,4,73,6],[74,7,74,8],[187,4,187,6],[75,7,75,8],[76,7,76,8],[77,7,77,8],[68,4,70,8],[149,4,149,6],[199,4,199,6],[74,4,74,6],[181,4,181,6],[175,4,175,6],[167,4,167,6],[126,4,126,6],[161,4,161,6],[143,4,143,6],[137,4,137,6],[132,4,132,6]]}
[null,"De Gemeenten van Nederland per 01-01-2016",null,null,null,null,null,null,"Verrekenings-categorie:",null,"Verrekening:",null,null,"Tarief:",null,"categorie:",1,2,3,4,5,null,null,null,null,null,"RICHTLIJN TARIEVEN 2004"]
[null,"Gemeente:","Indeling:",null,null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(Q2),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(R2),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(S2),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(T2),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(U2),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$H$28>0,Rekenblad!$H$28<=15),(Rekenblad!$H$28),0)","v":0},null,null,"A.","Klinkers","<15m2",{"$f":"SUM($K82,$K83,$K86)","v":32.800000000000004},{"$f":"SUM($K82,$K89,$K92)","v":33.07},{"$f":"SUM($K82,$K95,$K98)","v":33.900000000000006},{"$f":"SUM($K82,$K101,$K104)","v":35.590000000000003},{"$f":"SUM($K82,$K107,$K110)","v":36.150000000000006}]
[1,"Aa en Hunze",1,"  Postbus 93,  9460 AB  GIETEN",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(Q3),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(R3),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(S3),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(T3),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(U3),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(Rekenblad!$H$28),0)","v":0},null,null,null,"Klinkers",">15m2",{"$f":"SUM($L82,$L83,$L86)","v":26.82},{"$f":"SUM($L82,$L89,$L92)","v":27.04},{"$f":"SUM($L82,$L95,$L98)","v":27.72},{"$f":"SUM($L82,$L101,$L104)","v":29.1},{"$f":"SUM($L82,$L107,$L110)","v":29.560000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,"KOSTENSPECIFICATIE",null,"   EURO ( € )"]
[2,"Aalburg",1,"  Postbus 40,  4260 AA  WIJK EN AALBURG",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>100),(Q4),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>100),(R4),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>100),(S4),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>100),(T4),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>100),(U4),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$H$28>100),(Rekenblad!$H$28),0)","v":0},null,null,null,"Klinkers",">100m2",{"$f":"SUM($M82,$M83,$M86)","v":23.820000000000004},{"$f":"SUM($M82,$M89,$M92)","v":24.020000000000003},{"$f":"SUM($M82,$M95,$M98)","v":24.620000000000005},{"$f":"SUM($M82,$M101,$M104)","v":25.850000000000005},{"$f":"SUM($M82,$M107,$M110)","v":26.26}]
[3,"Aalsmeer",2,"  Postbus 253, 1430 AG  AALSMEER",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(Q5),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(R5),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(S5),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(T5),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(U5),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$H$28>0,Rekenblad!$H$28<=15),(1),0)","v":0},null,null,null,"Klinkers","per reparatie",{"$f":"$K84","v":7.81},{"$f":"$K90","v":10.98},{"$f":"$K96","v":20.5},{"$f":"$K102","v":31.48},{"$f":"$K108","v":38.56},null,null,null,null,null,"1) UITVOERINGSKOSTEN"]
[4,"Aalten",1,"  Postbus 119,  7120 AC  AALTEN",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(Q6),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(R6),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(S6),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(T6),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(U6),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$H$28>0,Rekenblad!$H$28<15),(Rekenblad!$F$28),0)","v":0},null,null,null,"Degeneratie per m1","<15m2"]
[5,"Achterkarspelen",1,"  Postbus 2,  9285 ZV  BUITENPOST",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(Q7),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(R7),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(S7),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(T7),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(U7),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$H$28>15,Rekenblad!$H$28<=100),(Rekenblad!$F$28),0)","v":0},null,null,null,"Degeneratie per m1",">15m2",{"$f":"$L85","v":2.59},{"$f":"$L91","v":3.64},{"$f":"$L97","v":6.79},{"$f":"$L103","v":13.52},{"$f":"$L109","v":15.77},null,null,null,null,null,"a) Ploegkosten per 01-07-2003",null,null,null,null,"Per uur","  "]
[6,"Alblasserdam",5,"  Postbus 2,  2950 AA  ALBLASSERDAM",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>100),(Q8),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>100),(R8),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>100),(S8),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>100),(T8),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>100),(U8),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$H$28>=100),(Rekenblad!$F$28),0)","v":0},null,null,null,"Degeneratie per m1",">100m2",{"$f":"$M85","v":2.2999999999999998},{"$f":"$M91","v":3.24},{"$f":"$M97","v":6.03},{"$f":"$M103","v":12.01},{"$f":"$M109","v":14.01}]
[7,"Albrandswaard",2,"  Postbus 1000,  3160 GA  RHOON",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(Q9),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(R9),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(S9),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(T9),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(U9),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$E$28>0,Rekenblad!$E$28<=15),(Rekenblad!$E$28),0)","v":0},null,null,null,"Tegels","<15m2",{"$f":"SUM($N82,$N83,$N86)","v":25.46},{"$f":"SUM($N82,$N89,$N92)","v":25.630000000000003},{"$f":"SUM($N82,$N95,$N98)","v":26.16},{"$f":"SUM($N82,$N101,$N104)","v":27.37},{"$f":"SUM($N82,$N107,$N110)","v":27.77},null,null,null,null,null,"Straatmaker  I","groep D,  Elsevier GWW Kosten 1 juli 2003",null,null,null,{"$f":"Invoerscherm!E6","v":35.42},"(met 5% ziekteverzuim)"]
[8,"Alkmaar",1,"  Postbus 53,  1800 BC  ALKMAAR",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(Q10),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(R10),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(S10),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(T10),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(U10),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(Rekenblad!$E$28),0)","v":0},null,null,null,"Tegels",">15m2",{"$f":"SUM($O82,$O83,$O86)","v":19.61},{"$f":"SUM($O82,$O89,$O92)","v":19.739999999999998},{"$f":"SUM($O82,$O95,$O98)","v":20.149999999999999},{"$f":"SUM($O82,$O101,$O104)","v":21.08},{"$f":"SUM($O82,$O107,$O110)","v":21.39},null,null,null,null,null,"Straatmaker  II","groep B,  Idem",null,null,null,{"$f":"Invoerscherm!E7","v":33.68},"(met 5% ziekteverzuim)"]
[9,"Almelo",1,"  Postbus 5100,  7600 GC  ALMELO",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>100),(Q11),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>100),(R11),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>100),(S11),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>100),(T11),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>100),(U11),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$E$28>100),(Rekenblad!$E$28),0)","v":0},null,null,null,"Tegels",">100m2",{"$f":"SUM($P82,$P83,$P86)","v":18.419999999999998},{"$f":"SUM($P82,$P89,$P92)","v":18.549999999999997},{"$f":"SUM($P82,$P95,$P98)","v":18.929999999999996},{"$f":"SUM($P82,$P101,$P104)","v":19.809999999999999},{"$f":"SUM($P82,$P107,$P110)","v":20.099999999999998},null,null,null,null,null,"Transport","EVO-berekening  DD. 03-01-2002 + index",null,null,null,{"$f":"Invoerscherm!E8","v":9.2899999999999991},"incl.kraan","+",2.5000000000000001E-2,"ivm ontbreken EVO gegevens"]
[10,"Almere",3,"  Postbus  200,  1300 AE  ALMERE",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(Q12),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(R12),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(S12),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(T12),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(U12),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$E$28>0,Rekenblad!$E$28<=15),(1),0)","v":0},null,null,null,"Tegels","per reparatie",{"$f":"N84","v":0},{"$f":"$N90","v":0.77},{"$f":"$N96","v":3.09},{"$f":"$N102","v":8.89},{"$f":"$N108","v":10.83},null,null,null,null,null,null,null,null,null,null,"--------------------+",null,null,null,""]
[11,"Alphen aan de Rijn",5,"  Postbus 13,  2400 AA  ALPHEN AAN DE RIJN",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(Q13),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(R13),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(S13),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(T13),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(U13),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$E$28>0,Rekenblad!$E$28<=15),(Rekenblad!$C$28),0)","v":0},null,null,null,"Degeneratie per m1","<15m2",{"$f":"0*$G$18","v":0},{"$f":"0*$G18","v":0},{"$f":"0*$G18","v":0},{"$f":"0*$G18","v":0},{"$f":"0*$G18","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF9:AF11)","v":78.389999999999986}]
[12,"Alphen-Chaam",1,"  Postbus 3,  5130 AA  ALPHEN",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(Q14),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(R14),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(S14),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(T14),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(U14),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$E$28>15,Rekenblad!$E$28<=100),(Rekenblad!$C$28),0)","v":0},null,null,null,"Degeneratie per m1",">15m2",{"$f":"O85","v":0},{"$f":"$O91","v":0.15},{"$f":"$O97","v":0.6},{"$f":"$O103","v":7.29},{"$f":"$O109","v":9.5299999999999994},null,null,null,null,null,"Alg. kosten winst/risico aannemer",null,null,null,{"$f":"12/100","v":0.12},{"$f":"ROUND(AE14*AF13,2)","v":9.41}]
[13,"Ameland",1,"  Postbus 22,  9160 AA  HOLLUM",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>100),(Q15),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>100),(R15),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>100),(S15),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>100),(T15),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>100),(U15),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=1,Rekenblad!$E$28>100),(Rekenblad!$C$28),0)","v":0},null,null,null,"Degeneratie per m1",">100m2",{"$f":"0*$G$18","v":0},{"$f":"$P91","v":0.14000000000000001},{"$f":"$P97","v":0.56000000000000005},{"$f":"$P103","v":6.86},{"$f":"$P109","v":8.9499999999999993},null,null,null,null,null,null,null,null,null,null,"---------------------+"]
[14,"Amersfoort",1,"  Postbus 4000,  3800 EA  AMERSFOORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAAL per ploeguur ",null,{"$f":"SUM(AF13:AF14)","v":87.799999999999983},"  TOTAAL per manuur ",null,{"$f":"ROUND(AF16/2,2)","v":43.9},"",null,""]
[15,"Amstelveen",5,"  Postbus 4,  1180 BA  AMSTELVEEN",null,null,null,null,null,null,null,null,null,"B1."]
[16,"Amsterdam",3,"  Postbus 202,  1000 AE  AMSTERDAM",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(Q18),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(R18),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(S18),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(T18),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(U18),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9>=2,Rekenblad!$B$9<=3,Rekenblad!$H$28>0,Rekenblad!$H$28<=15),(1),0)","v":0},null,null,null,"Deg. klink. per m1","per reparatie",{"$f":"$P115","v":7.81},{"$f":"$P121","v":10.98},{"$f":"$P127","v":20.5},{"$f":"$P133","v":31.48},{"$f":"$P138","v":38.56}]
[17,"Apeldoorn",1,"  Postbus 9033,  7300 ES  APELDOORN",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>15),(Q19),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>15),(R19),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>15),(S19),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>15),(T19),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>15),(U19),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9>=2,Rekenblad!$B$9<=3,Rekenblad!$H$28>15),(Rekenblad!$F$28),0)","v":0},null,null,null,"Deg. klink. per m1",">15m2",{"$f":"$P117","v":2.59},{"$f":"$P123","v":3.64},{"$f":"$P129","v":6.79},{"$f":"$P135","v":13.52},{"$f":"$P140","v":15.77},null,null,null,null,null,"b) kosten materiaal",null,null,"kosten   ","breuk","reparatie ","KLINKERS",null,null,"TEGELS"]
[18,"Appingedam",5,"  Postbus 15,  9900 AA  APPINGEDAM",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(Q20),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(R20),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(S20),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(T20),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(U20),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9>=2,Rekenblad!$B$9<=3,Rekenblad!$E$28>0,Rekenblad!$E$28<=15),(1),0)","v":0},null,null,null,"Deg. tegels per m1","per reparatie",{"$f":"$P116","v":0},{"$f":"$P122","v":0.77},{"$f":"$P128","v":3.09},{"$f":"$P134","v":8.89},{"$f":"$P139","v":10.83},null,null,null,null,null,"Incl. Magazijntoeslag",{"$f":"15/100","v":0.15},null,"per m2","in %","per m2","materiaalverhouding per 1000",null,null,"materiaalverhouding per m2"]
[19,"Arnhem",1,"  Postbus 9029, 6800 EL  ARNHEM",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>15),(Q21),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>15),(R21),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>15),(S21),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>15),(T21),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>15),(U21),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9>=2,Rekenblad!$B$9<=3,Rekenblad!$E$28>15),(Rekenblad!$C$28),0)","v":0},null,null,null,"Deg. tegels per m1",">15m2",{"$f":"$P118","v":0},{"$f":"$P124","v":0.15},{"$f":"$P130","v":0.6},{"$f":"$P136","v":7.29},{"$f":"$P141","v":9.5299999999999994}]
[20,"Assen",1,"  Postbus 30018,  9400 RA  ASSEN",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(Q22),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(R22),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(S22),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(T22),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(U22),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9>=2,Rekenblad!$B9<=3,Rekenblad!$H$28>0,Rekenblad!$H$28<=15),(Rekenblad!$H$28),0)","v":0},null,null,null,"Beh.kost. klink m2","<15m2",{"$f":"$L115","v":1.74},{"$f":"$L121","v":1.74},{"$f":"$L127","v":1.74},{"$f":"$L133","v":1.74},{"$f":"$L138","v":1.74},null,null,null,null,null,"K-Klinkers","per m2   ",null,{"$f":"((AG22*AI22/1000*100)+(AG23*AI23/1000*50)+(AG24*AI24/1000*44))*1.15","v":21.79204},0.05,{"$f":"ROUND(AE22*AD22,2)","v":1.0900000000000001},0.2,"waal",{"$f":"Invoerscherm!E13","v":357},0.95,"Dik 45 mm",{"$f":"Invoerscherm!E20","v":8.0299999999999994}]
[21,"Asten",1,"  Postbus 290,  5720 AG  ASTEN",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>15),(Q23),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>15),(R23),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>15),(S23),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>15),(T23),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>15),(U23),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9>=2,Rekenblad!$B$9<=3,Rekenblad!$H$28>15),(Rekenblad!$H$28),0)","v":0},null,null,null,"Beh.kost. klink m2",">15m2",{"$f":"$L117","v":1.42},{"$f":"$L123","v":1.42},{"$f":"$L129","v":1.42},{"$f":"$L135","v":1.42},{"$f":"$L140","v":1.42},null,null,null,null,null,"T-Tegels ","per m2 ",null,{"$f":"((AJ22*AL22)+(AJ23*AL23))*1.15","v":9.4368999999999978},0.05,{"$f":"ROUND(AE23*AD23,2)","v":0.47},0.2,"kei",{"$f":"Invoerscherm!E14","v":550},0.05,"Dik 80 mm",{"$f":"Invoerscherm!E21","v":11.55}]
[22,"Baarle-Nassau",1,"  Postbus 105,  5110 AC  BAARLE-NASSAU",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(Q24),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(R24),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(S24),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(T24),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(U24),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$E$28>0,Rekenblad!$E$28<=15),(Rekenblad!$E$28),0)","v":0},null,null,null,"Beh.kost.tegels m2","<15m2",{"$f":"$L116","v":1.37},{"$f":"$L122","v":1.37},{"$f":"$L128","v":1.37},{"$f":"$L134","v":1.37},{"$f":"$L139","v":1.37},null,null,null,null,null,"Z-Zand ","per m3 ",null,{"$f":"AL24*(1+AB20)","v":12.362499999999999},0.05,{"$f":"ROUND(AE24*AD24,2)","v":0.62},0.6,"beton",{"$f":"Invoerscherm!E17","v":239},null,"Zand p/ m3",{"$f":"Invoerscherm!E24","v":10.75}]
[23,"Baarn",1,"  Postbus 1003,  3740 BA  BAARN",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>15),(Q25),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>15),(R25),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>15),(S25),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>15),(T25),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>15),(U25),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9>=2,Rekenblad!$B$9<=3,Rekenblad!$E$28>15),(Rekenblad!$E$28),0)","v":0},null,null,null,"Beh.kost.tegels m2",">15m2",{"$f":"$L118","v":1.06},{"$f":"$L124","v":1.06},{"$f":"$L130","v":1.06},{"$f":"$L136","v":1.06},{"$f":"$L141","v":1.06}]
[24,"Barendrecht",5,"  Postbus 501,  2990 EA  BARENDRECHT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c) kosten totaal"]
[25,"Barneveld",1,"  Postbus 63,  3770 AB  BARNEVELD",null,null,null,null,null,null,null,null,null,"B2.",null,null,null,null,null,null,null,null,null,null,null,null,"kosten herstraten",null,null,"Reparatie-","Kosten","Uitvoerings-"]
[26,"Bedum",5,"  Postbus 38,  9780 AA  BEDUM",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(Q28),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(R28),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(S28),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(T28),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(U28),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=3,Rekenblad!$H$28>0,Rekenblad!$H$28<=15),(Rekenblad!$H$28),0)","v":0},null,null,null,"Onderhoud klinkers","<15m2",{"$f":"$K83","v":2.14},{"$f":"$K89","v":2.41},{"$f":"$K95","v":3.24},{"$f":"$K101","v":4.93},{"$f":"$K107","v":5.49},null,null,null,null,null,"1e herstel",null,null,"norm p/m2","manuur:","kosten/m2",null,"Gemiddelde toeslag"]
[27,"Beek",1,"  Postbus 20,  6190 AA  BEEK",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>15),(Q29),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>15),(R29),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>15),(S29),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>15),(T29),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>15),(U29),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=3,Rekenblad!$H$28>15),(Rekenblad!$H$28),0)","v":0},null,null,null,"Onderhoud klinkers",">15m2",{"$f":"$L83","v":1.75},{"$f":"$L89","v":1.97},{"$f":"$L95","v":2.65},{"$f":"$L101","v":4.03},{"$f":"$L107","v":4.49},null,null,null,null,null,"(A+B)",null,null,"p/manuur",{"$f":"$I$16","v":0},"incl. ",null,"i.v.m. verrekening"]
[28,"Beemster",4,"  Postbus 7,  1462 ZG  MIDDENBEEMSTER",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(Q30),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(R30),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(S30),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(T30),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(U30),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=3,Rekenblad!$E$28>0,Rekenblad!$E$28<=15),(Rekenblad!$E$28),0)","v":0},null,null,null,"Onderhoud tegels","<15m2",{"$f":"$N83","v":1.18},{"$f":"$N89","v":1.35},{"$f":"$N95","v":1.88},{"$f":"$N101","v":3.09},{"$f":"$N107","v":3.49},null,null,null,null,null,null,null,null,null,"per m2:","materiaal ","  incl.","GATVERGROTING  (m.u.v.tarief D)"]
[29,"Beesel",1,"  Postbus 4750,  5953 ZK  REUVER",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>15),(Q31),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>15),(R31),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>15),(S31),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>15),(T31),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>15),(U31),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=3,Rekenblad!$E$28>15),(Rekenblad!$E$28),0)","v":0},null,null,null,"Onderhoud tegels",">15m2",{"$f":"$O83","v":0.91},{"$f":"$O89","v":1.04},{"$f":"$O95","v":1.45},{"$f":"$O101","v":2.38},{"$f":"$O107","v":2.69}]
[30,"Bellingwedde",1,"  Postbus 18,  9698 ZG  WEDDE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KLINKERS ","<15 m2 (lasgat)",null,0.51,{"$f":"ROUND(AD32*$AI$16,2)","v":22.39},{"$f":"ROUND((AE32+AF22+AF24)*(1+AH32),2)","v":28.92},null,0.2,"Prijzen materialen uit"]
[31,"Berg en Dal ",1,"  Postbus 20, 6560 AA GROESBEEK",null,null,null,null,null,null,null,null,null,"C.",null,null,null,null,null,null,null,null,null,null,null,null,"KLINKERS ",">15 m2 (geul)",null,0.41,{"$f":"ROUND(AD33*$AI$16,2)","v":18},{"$f":"ROUND((AE33+AF22+AF24)*(1+AH33),2)","v":23.65},null,0.2,"Elsevier GWW Kosten funderingslagen & "]
[32,"Bergeijk",1,"  Postbus 10000,  5570 GA  BERGEIJK",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(Q34),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(R34),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(S34),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(T34),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>0.1,Rekenblad!$H$28<=15),(U34),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=4,Rekenblad!$H$28>0,Rekenblad!$H$28<=15),(Rekenblad!$H$28),0)","v":0},null,null,null,"Klinkers","<15m2",{"$f":"$L176","v":15.930000000000001},{"$f":"$L182","v":16.2},{"$f":"$L188","v":17.03},{"$f":"$L194","v":18.72},{"$f":"$L200","v":19.279999999999998},null,null,null,null,null,"KLINKERS ",">100 m2 (geul)",null,0.36,15.8,{"$f":"ROUND((AE34+AF22+AF24)*(1+AH34),2)","v":21.01},null,0.2,"elementenverhardingen  01-05-2001"]
[33,"Bergen (L.)",1,"  Postbus 140,  5854 ZJ  BERGEN (L.)",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$H$28>15),(Q35),IF(AND(Rekenblad!$D$7=2,Rekenblad!$H$28>15),(R35),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$H$28>15),(S35),IF(AND(Rekenblad!$D$7=4,Rekenblad!$H$28>15),(T35),IF(AND(Rekenblad!$D$7=5,Rekenblad!$H$28>15),(U35),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=4,Rekenblad!$H$28>15),(Rekenblad!$H$28),0)","v":0},null,null,null,"Klinkers",">15m2",{"$f":"$L178","v":13.024166666666666},{"$f":"$L184","v":13.244166666666667},{"$f":"$L190","v":13.924166666666666},{"$f":"$L196","v":15.304166666666665},{"$f":"$L202","v":15.764166666666666},null,null,null,null,null,"TEGELS","<15 m2 (lasgat)",null,0.41,18,{"$f":"ROUND((AE35+AF23+AF24)*(1+AH35),2)","v":22.91},null,0.2]
[34,"Bergen (NH.)",1,"  Postbus 175,  1860 AD  BERGEN (NH.)",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(Q36),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(R36),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(S36),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(T36),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>0.1,Rekenblad!$E$28<=15),(U36),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=4,Rekenblad!$E$28>0,Rekenblad!$E$28<=15),(Rekenblad!$E$28),0)","v":0},null,null,null,"Tegels","<15m2",{"$f":"$L177","v":12.095833333333335},{"$f":"$L183","v":12.265833333333333},{"$f":"$L189","v":12.795833333333334},{"$f":"$L195","v":14.005833333333335},{"$f":"$L201","v":14.405833333333334},null,null,null,null,null,"TEGELS ",">15 m2 (geul)",null,0.31,13.61,{"$f":"ROUND((AE36+AF23+AF24)*(1+AH36),2)","v":17.64},null,0.2]
[35,"Bergen op Zoom",1,"  Postbus 35,  4600 AA  BERGEN OP ZOOM",null,null,null,null,{"$f":"IF(AND(Rekenblad!$D$7=1,Rekenblad!$E$28>15),(Q37),IF(AND(Rekenblad!$D$7=2,Rekenblad!$E$28>15),(R37),(IF(AND(Rekenblad!$D$7=3,Rekenblad!$E$28>15),(S37),IF(AND(Rekenblad!$D$7=4,Rekenblad!$E$28>15),(T37),IF(AND(Rekenblad!$D$7=5,Rekenblad!$E$28>15),(U37),0))))))","v":0},null,{"$f":"IF(AND(Rekenblad!$B$9=4,Rekenblad!$E$28>15),(Rekenblad!$E$28),0)","v":0},null,null,null,"Tegels",">15m2",{"$f":"$L179","v":9.32},{"$f":"$L185","v":9.4500000000000011},{"$f":"$L191","v":9.8600000000000012},{"$f":"$L197","v":10.790000000000001},{"$f":"$L202","v":15.764166666666666},null,null,null,null,null,"TEGELS ",">100 m2 (geul)",null,0.28999999999999998,12.73,{"$f":"ROUND((AE37+AF23+AF24)*(1+AH37),2)","v":16.579999999999998},null,0.2]
[36,"Berkelland",1,"  Postbus 200, 7270 HA BORCULO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TROTTOIRBAND","(tegelmat.)",null,0.22,9.66,{"$f":"(AE38+AF23+AF24)","v":10.75}]
[37,"Bernheze",1,"  Postbus 19,  5384 ZG  HEESH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OPSLUITBAND ","(tegelmat.)",null,0.17,7.46,{"$f":"AE39+AF23+AF24","v":8.5499999999999989}]
[38,"Best",1,"  Postbus 50,  5680 AB  BEST",null,null,null,null,{"$f":"IF(OR(Rekenblad!$D$7=1),(Q40),IF(OR(Rekenblad!$D$7=2),(R40),(IF(OR(Rekenblad!$D$7=3),(S40),IF(OR(Rekenblad!$D$7=4),(T40),IF(OR(Rekenblad!$D$7=5),(U40),\"\"))))))","v":11.395},null,{"$f":"Rekenblad!I28","v":0},null,null,"D.","Trottoirband","per m1",{"$f":"$L206","v":11.395},11.395,11.395,11.395,11.395,null,null,null,null,null,"ZAAI KLAAR MAKEN","100m2 berm, gazon",null,{"$f":"1.59","v":1.59},{"$f":"ROUND(AD40/100*$AF$51,2)","v":0.7},{"$f":"((AH55+AH56)/2+AE40)*1.5","v":1.17234375},null,0.5]
[39,"Beuningen",1,"  Postbus 14,  6640 AA  BEUNINGEN",null,null,null,null,{"$f":"IF(OR(Rekenblad!$D$7=1),(Q41),IF(OR(Rekenblad!$D$7=2),(R41),(IF(OR(Rekenblad!$D$7=3),(S41),IF(OR(Rekenblad!$D$7=4),(T41),IF(OR(Rekenblad!$D$7=5),(U41),\"\"))))))","v":9.0629999999999988},null,{"$f":"Rekenblad!K28","v":0},null,null,null,"Opsluitband/koprol","per m1",9.0629999999999988,9.0629999999999988,9.0629999999999988,9.0629999999999988,9.0629999999999988,null,null,null,null,null,"INZAAIEN","100m2 berm, gazon",null,{"$f":"0.945","v":0.94499999999999995},{"$f":"ROUND(AD41/100*$AF$51,2)","v":0.42},{"$f":"((AH55+AH56)/2+AE41)*1.5","v":0.75234375000000009},null,0.5]
[40,"Beverwijk",1,"  Postbus 450,  1940 AL  BEVERWIJK ",null,null,null,null,{"$f":"IF(OR(Rekenblad!$D$7=1),(Q42),IF(OR(Rekenblad!$D$7=2),(R42),(IF(OR(Rekenblad!$D$7=3),(S42),IF(OR(Rekenblad!$D$7=4),(T42),IF(OR(Rekenblad!$D$7=5),(U42),\"\"))))))","v":102.00843750000001},null,{"$f":"IF(AND(Rekenblad!$E$33>0,Rekenblad!$E$33<=50),(1),0)","v":0},null,null,null,"berm/gazon <50 m2","per reparatie",102.00843750000001,102.00843750000001,102.00843750000001,102.00843750000001,102.00843750000001]
[41,"Binnenmaas",4,"  Postbus 5455,  3299 ZH  MAASDAM",null,null,null,null,{"$f":"IF(OR(Rekenblad!$D$7=1),(Q43),IF(OR(Rekenblad!$D$7=2),(R43),(IF(OR(Rekenblad!$D$7=3),(S43),IF(OR(Rekenblad!$D$7=4),(T43),IF(OR(Rekenblad!$D$7=5),(U43),\"\"))))))","v":2.0401687500000003},null,{"$f":"IF(AND(Rekenblad!$E$33>50),(Rekenblad!$E$33),0)","v":0},null,null,null,"berm/gazon >50 m2",">50m2",2.0401687500000003,2.0401687500000003,2.0401687500000003,2.0401687500000003,2.0401687500000003,null,null,null,null,null,"kosten loon groen per 01-07-2001",null,null,null,null,"Per uur","  "]
[42,"Bladel",1,"  Postbus 11,  5530 AA BLADEL",null,null,null,null,{"$f":"Rekenblad!H31","v":0},null,null,null,null,null,"bomen en struiken","sts"]
[43,"Blaricum",1,"  Postbus 125,  1260 AC  BLARICUM",null,null,null,null,{"$f":"Rekenblad!H32","v":0},null,null,null,null,null,"bomen en struiken","sts",null,null,null,null,null,null,null,null,null,null,"cultuurtechnisch medewerker",null,"Elsevier GWW Kosten 1 juli 2003",null,null,{"$f":"Invoerscherm!E28","v":30.15},"(met 5% ziekteverzuim)"]
[44,"Bloemendaal",1,"  Postbus 201,  2050 AE  OVERVEEN",null,null,null,null,{"$f":"Rekenblad!N31","v":0},null,{"$f":"+IF(AND(Rekenblad!$K$31>0.1,Rekenblad!$L$31>0.1,Rekenblad!$M$31>1),(Rekenblad!$K$31*Rekenblad!$L$31*Rekenblad!$M$31),0)","v":0},null,null,null,"asfalt","per m2",null,null,null,null,null,null,null,null,null,null,"Transport",null,"EVO-berekening  DD. 03-01-2001",null,null,{"$f":"Invoerscherm!E29","v":9.2899999999999991},null,"+ index 2,5%"]
[45,"Bodegraven-Reeuwijk",5,"  Postbus 401,  2410 AK  BODEGRAVEN",null,null,null,null,{"$f":"Rekenblad!N32","v":0},null,{"$f":"+IF(AND(Rekenblad!$K$32>0.1,Rekenblad!$L$32>0.1,Rekenblad!$M$32>1),(Rekenblad!$K$32*Rekenblad!$L$32*Rekenblad!$M$32),0)","v":0},null,null,null,"asfalt","per m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF45:AF46)","v":39.44}]
[46,"Boekel",1,"  Postbus 99,  5427 ZH  BOEKEL"]
[47,"Borger-Odoorn",1,"  Postbus 3,  7875 ZG  EXLOO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alg. kosten winst/risico aannemer",null,null,null,{"$f":"12/100","v":0.12},{"$f":"ROUND(AE49*AF47,2)","v":4.7300000000000004}]
[48,"Borne",1,"  Postbus 200, 7620 AE  BORNE"]
[49,"Borsele",1,"  Postbus 1,  4450 AA  HEINKENSZAND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAAL per manuur ",null,{"$f":"SUM(AF47:AF49)","v":44.17}]
[50,"Boxmeer",1,"  Postbus 450,  5830 AL  BOXMEER"]
[51,"Boxtel",1,"  Postbus 10000,  5280 DA  BOXTEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kosten materiaal groen",null,null,"Zaad kosten",null,"gebruik","kosten  ","kosten ","Prijzen zaaimateriaal uit"]
[52,"Breda",1,"  Postbus 90156,  4800 RH  BREDA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per kg",null,"kg/are","per  are","per m2","Elsevier/ GWW Kosten/ Groenvoorzieningen"]
[53,"Brielle",1,"  Postbus 101,  3230 AC  BRIELLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graszaad","Bermmengsel ",null,{"$f":"Invoerscherm!E31","v":7.15},null,0.75,{"$f":"AD55*AF55","v":5.3625000000000007},{"$f":"AG55/100","v":5.3625000000000006E-2},"2002-05-01"]
[54,"Bronckhorst",1,"  Postbus 200, 7255 ZJ HENGELO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graszaad","Gazonmengsel ",null,{"$f":"Invoerscherm!E32","v":7.3},null,1.5,{"$f":"AD56*AF56","v":10.95},{"$f":"AG56/100","v":0.10949999999999999}]
[55,"Brummen",1,"  Postbus 5,  6970 BV  BRUMMEN"]
[56,"Brunssum",1,"  Postbus 250,  6440 AG  BRUNSSUM"]
[57,"Bunnik",1,"  Postbus 5,  3980 CA  BUNNINK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) ONDERHOUD",null,null,null,"Percentage slechte grond "]
[58,"Bunschoten",1,"  Postbus 200,  3750 GE  BUNSCHOTEN"]
[59,"Buren",1,"  Postbus 15,  4033 ZG  LIENDEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<50%","50-60%","60-70%","70-80%",">80%","5 categorieën van"]
[60,"Capelle aan de IJssel",5,"  Postbus 70,  2900 AB CAPELLE AAN DE IJSSEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bodemgesteldheid "]
[61,"Castircum",1,"  Postbus 1301,  1900 BH  CASTRICUM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"na herstel in % van de totale uitvoeringskosten",null,null,null,null,null,null,null,null,"minder dan 50% slechte bodem"]
[62,"Coevorden",1,"  Postbus 2, 7740 AA  COEVORDEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIJWEGEN       ","(klinkers, tegels)",null,null,0.08,0.09,0.12,0.18,0.2,"tussen 50-60% slechte bodem"]
[63,"Cranendonck",1,"  Postbus 2090,  6020 AB  BUDEL",null,null,null,null,null,null,"Verdeling werkzaamheden:",null,null,null,"KLINKERS:",null,"    TEGELS:",null,null,null,null,null,null,null,null,null,"VOET-FIETSPADEN","(tegels, klinkers)",null,null,0.05,5.7500000000000002E-2,0.08,0.13250000000000001,0.15,"tussen 60-70% slechte bodem"]
[64,"Cromstrijen",1,"  Postbus 7400,  3280 AE  NUMANSDORP",null,null,null,null,null,null,null,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},"Voetpad",{"$f":"95/100","v":0.95},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tussen 70-80 slechte bodem"]
[65,"Cuijk",1,"  Postbus 10001,  5430 DA  CUIJK",null,null,null,null,null,null,null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},"Rijweg",{"$f":"5/100","v":0.05},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"meer dan 80% slechte bodem"]
[66,"Culemborg",3,"  Postbus 136,  4100 AC  CULEMBERG"]
[67,"Dalfsen",1,"  Postbus 35, 7720 AA  DALSEN","Bodemgesteldheid:",null,null,null,null,"Rekenfactor:",null,"Onderhoud:",null,"Degeneratie:",null,null,null,"Beheer:"]
[68,"Dantumadeel",1,"  Postbus 22,  9104 BR  DAMWOUDE",null,null,null,null,null,null,null,null,null,"klinker","klinker","tegels","tegels","beheer",null,null,null,null,null,null,null,null,"3) DEGENERATIE",null,null,null,"Percentage slechte grond "]
[69,"De Bilt",1,"  Postbus 300,  3720 AH  BILTHOVEN",null,null,null,null,null,null,null,"rijweg","voetpad","< 15m2","> 15m2","< 15m2","> 15m2","kosten"]
[70,"De Fryske Marren",1,"  Postbus 101,  8500 AC JOURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<50%","50-60%","60-70%","70-80%",">80%","5 categorieën van"]
[71,"De Marne",1,"  Postbus 11, 9965 ZG  LEENS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bodemgesteldheid "]
[72,"De Ronde Venen",2,"  Postbus 250,  3640 AG MIJDRECHT","Categorie:1.",null,null,"<= 50% slechte bodem:",null,"",0,{"$f":"8/100","v":0.08},{"$f":"5/100","v":0.05},{"$f":"32/100","v":0.32},{"$f":"13/100","v":0.13},{"$f":"0/100","v":0},{"$f":"0/100","v":0},{"$f":"6/100","v":0.06},null,null,null,null,null,null,null,null,"na herstel in % van de totale uitvoeringskosten",null,null,null,null,null,null,null,null,"minder dan 50% slechte bodem"]
[73,"De Wolden",1,"  Postbus 20,  7920 AA  ZUIDWOLDE","Categorie:2.",null,null,"> 50 <60% slechte bodem:",null,"",0.25,{"$f":"(8/100)+0.25*(12/100-8/100)","v":0.09},{"$f":"(5/100)+0.25*(8/100-5/100)","v":5.7500000000000002E-2},{"$f":"(32/100)+$K$75*(84/100-32/100)","v":0.45},{"$f":"(13/100)+$K$75*(34/100-13/100)","v":0.1825},{"$f":"(0/100)+$K$75*(16/100-0/100)","v":0.04},{"$f":"(0/100)+$K$75*(4/100-0/100)","v":0.01},{"$f":"6/100","v":0.06},null,null,null,null,null,null,null,null,"KLINKERS","< 15 m2  (per lasgat)",null,null,0.32,0.45,0.84,1.29,1.58,"tussen 50-60% slechte bodem"]
[74,"Delft",4,"  Postbus 78,  2600 ME  DELFT","Categorie:3.",null,null,"> 60 <70% slechte bodem:",null,"",0.5,{"$f":"12/100","v":0.12},{"$f":"8/100","v":0.08},{"$f":"84/100","v":0.84},{"$f":"34/100","v":0.34},{"$f":"16/100","v":0.16},{"$f":"4/100","v":0.04},{"$f":"6/100","v":0.06},null,null,null,null,null,null,null,null,"KLINKERS","> 15 m2  (per m1 geul)",null,null,0.13,0.1825,0.34,0.67749999999999999,0.79,"tussen 60-70% slechte bodem"]
[75,"Delfzijl",3,"  Postbus 20000,  9930 PA  DELFZIJL","Categorie:4.",null,null,"> 70 <80% slechte bodem:",null,"",0.75,{"$f":"(12/100)+0.75*(20/100-12/100)","v":0.18},{"$f":"(8/100)+0.75*(15/100-8/100)","v":0.13250000000000001},{"$f":"(84/100)+$K$77*(144/100-84/100)","v":1.29},{"$f":"(34/100)+$K$77*(79/100-34/100)","v":0.67749999999999999},{"$f":"(16/100)+$K$77*(56/100-16/100)","v":0.46000000000000008},{"$f":"(4/100)+$K$77*(64/100-4/100)","v":0.48999999999999994},{"$f":"6/100","v":0.06},null,null,null,null,null,null,null,null,"TEGELS","< 15 m2  (per lasgat)",null,null,0,0.04,0.16,0.46,0.56000000000000005,"tussen 70-80 slechte bodem"]
[76,"Den Haag",1,"  Postbus 12600,  2500 DJ  DEN HAAG","Categorie:5.",null,null,">= 80% slechte bodem:",null,"",1,{"$f":"20/100","v":0.2},{"$f":"15/100","v":0.15},{"$f":"158/100","v":1.58},{"$f":"79/100","v":0.79},{"$f":"56/100","v":0.56000000000000005},{"$f":"64/100","v":0.64},{"$f":"6/100","v":0.06},null,null,null,null,null,null,null,null,"TEGELS","> 15 m2  (per m1 geul)",null,null,0,0.01,0.04,0.49,0.64,"meer dan 80% slechte bodem"]
[77,"Den Helder",1,"  Postbus 36,  1780 AA  DEN  HELDER"]
[78,"Deurne",1,"  Postbus 3,  5750 AA  DEURNE",null,null,null,null,null,null,"Klinkers:",null,null,"Tegels:"]
[79,"Deventer",1,"  Postbus 5000, 7400GC  DEVENTER",null,null,null,null,"Opbouw:",null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2"]
[80,"Diemen",5,"  Postbus 191,  1110 AD  DIEMEN","Tarief: A1",null,null,"1.","Uitvoering:","m2",{"$f":"$AF$32","v":28.92},{"$f":"$AF$33","v":23.65},{"$f":"$AF$34","v":21.01},{"$f":"$AF$35","v":22.91},{"$f":"$AF$36","v":17.64},{"$f":"$AF$37","v":16.579999999999998}]
[81,"Dinkelland",1,"  Postbus 11,  7590 AA  DENEKAMP",null,null,null,"2.","Onderhoud:","m2",{"$f":"ROUND($P$66*($L$74*$AF$32)+$P$67*($M$74*$AF$32),2)","v":2.14},{"$f":"ROUND($P$66*($L$74*$AF$33)+$P$67*($M$74*$AF$33),2)","v":1.75},{"$f":"ROUND($P$66*($L$74*$AF$34)+$P$67*($M$74*$AF$34),2)","v":1.55},{"$f":"ROUND($R$66*($M$74*$AF$35)+$R$67*($L$74*$N$82),2)","v":1.18},{"$f":"ROUND($R$66*($M$74*$AF$36)+$R$67*($L$74*$AF$36),2)","v":0.91},{"$f":"ROUND($R$66*($M$74*$AF$37)+$R$67*($L$74*$AF$37),2)","v":0.85}]
[82,"Doesburg",1,"  Postbus 100,  6980 AC  DOESBURG",null,null,null,"3a.","Degeneratie","pp",{"$f":"ROUND(($N$74*$AF$32)/1.185,2)","v":7.81},0,0,0,0,0]
[83,"Doetinchem",1,"  Postbus 9020,  7000 HA  DOETINCHEM",null,null,null,"3b.","Degeneratie:","m1",0,{"$f":"ROUND(($O$74*$AF$33)/1.185,2)","v":2.59},{"$f":"ROUND(($O$74*$AF$34)/1.185,2)","v":2.2999999999999998},{"$f":"ROUND(($P$74*$L$82)/1.185,2)","v":0},{"$f":"ROUND(($Q$74*$L$82)/1.185,2)","v":0},0]
[84,"Dongen",1,"  Postbus 10153,  5100 GE  DONGEN",null,null,null,"4.","Beheerskosten:","m2",{"$f":"ROUND($R$74*$AF$32,2)","v":1.74},{"$f":"ROUND($R$74*$AF$33,2)","v":1.42},{"$f":"ROUND($R$74*$AF$34,2)","v":1.26},{"$f":"ROUND($R$74*$AF$35,2)","v":1.37},{"$f":"ROUND($R$74*$AF$36,2)","v":1.06},{"$f":"ROUND($R$74*$AF$37,2)","v":0.99}]
[85,"Dongeradeel",1,"  Postbus 1,  9100 AA  DOKKUM"]
[86,"Dordrecht",1,"  Postbus 8,  3300 AA  DORDRECHT",null,null,null,null,null,null,"Klinkers:",null,null,"Tegels:"]
[87,"Drechterland",4,"  Postbus 9, 1616 ZG HOOGKARSPEL","Tarief: A2",null,null,"2.","Onderhoud:","m2",{"$f":"ROUND($P$66*($L$75*$AF$32)+$P$67*($M$75*$AF$32),2)","v":2.41},{"$f":"ROUND($P$66*($L$75*$AF$33)+$P$67*($M$75*$AF$33),2)","v":1.97},{"$f":"ROUND($P$66*($L$75*$AF$34)+$P$67*($M$75*$AF$34),2)","v":1.75},{"$f":"ROUND($R$66*($M$75*$AF$35)+$R$67*($L$75*$AF$35),2)","v":1.35},{"$f":"ROUND($R$66*($M$75*$AF$36)+$R$67*($L$75*$AF$36),2)","v":1.04},{"$f":"ROUND($R$66*($M$75*$AF$37)+$R$67*($L$75*$AF$37),2)","v":0.98}]
[88,"Drimmelen",1,"  Postbus 19, 4920 AA  MADE",null,null,null,"3a.","Degeneratie","pp",{"$f":"ROUND(($N$75*$AF$32)/1.185,2)","v":10.98},0,0,{"$f":"ROUND(($P$75*$AF$35)/1.185,2)","v":0.77},0,0]
[89,"Dronten",1,"  Postbus 100,  8250 AC  DRONTEN",null,null,null,"3b.","Degeneratie:","m1",0,{"$f":"ROUND(($O$75*$AF$33)/1.185,2)","v":3.64},{"$f":"ROUND(($O$75*$AF$34)/1.185,2)","v":3.24},0,{"$f":"ROUND(($Q$75*$AF$36)/1.185,2)","v":0.15},{"$f":"ROUND(($Q$75*$AF$37)/1.185,2)","v":0.14000000000000001}]
[90,"Druten",1,"  Postbus 1,  6650 AA  DRUTEN",null,null,null,"4.","Beheerskosten:","m2",{"$f":"ROUND($R$75*$AF$32,2)","v":1.74},{"$f":"ROUND($R$75*$AF$33,2)","v":1.42},{"$f":"ROUND($R$75*$AF$34,2)","v":1.26},{"$f":"ROUND($R$75*$AF$35,2)","v":1.37},{"$f":"ROUND($R$75*$AF$36,2)","v":1.06},{"$f":"ROUND($R$75*$AF$37,2)","v":0.99}]
[91,"Duiven",1,"  Postbus 6,  6920 AA  DUIVEN"]
[92,"Echt-Susteren",1,"  Postbus 450,  6100 AL  ECHT",null,null,null,null,null,null,"Klinkers:",null,null,"Tegels:"]
[93,"Edam-Volendam",4,"  Postbus 180, 1130 AD  VOLENDAM","Tarief: A3",null,null,"2.","Onderhoud:","m2",{"$f":"ROUND($P$66*($L$76*$AF$32)+$P$67*($M$76*$AF$32),2)","v":3.24},{"$f":"ROUND($P$66*($L$76*$AF$33)+$P$67*($M$76*$AF$33),2)","v":2.65},{"$f":"ROUND($P$66*($L$76*$AF$34)+$P$67*($M$76*$AF$34),2)","v":2.35},{"$f":"ROUND($R$66*($M$76*$AF$35)+$R$67*($L$76*$AF$35),2)","v":1.88},{"$f":"ROUND($R$66*($M$76*$AF$36)+$R$67*($L$76*$AF36),2)","v":1.45},{"$f":"ROUND($R$66*($M$76*$AF$37)+$R$67*($L$76*$AF$37),2)","v":1.36}]
[94,"Ede",1,"  Postbus 9022,  6710 HK  EDE",null,null,null,"3a.","Degeneratie","pp",{"$f":"ROUND(($N$76*$AF$32)/1.185,2)","v":20.5},0,0,{"$f":"ROUND(($P$76*$AF$35)/1.185,2)","v":3.09},0,0]
[95,"Eemnes",1,"  Postbus 71,  3755 AN  EEMNES",null,null,null,"3b.","Degeneratie:","m1",0,{"$f":"ROUND(($O$76*$AF$33)/1.185,2)","v":6.79},{"$f":"ROUND(($O$76*$AF$34)/1.185,2)","v":6.03},0,{"$f":"ROUND(($Q$76*$AF$36)/1.185,2)","v":0.6},{"$f":"ROUND(($Q$76*$AF$37)/1.185,2)","v":0.56000000000000005}]
[96,"Eemsmond",1,"  Postbus 11,  9980 AA  UITHUIZEN",null,null,null,"4.","Beheerskosten:","m2",{"$f":"ROUND($R$76*$AF$32,2)","v":1.74},{"$f":"ROUND($R$76*$AF$33,2)","v":1.42},{"$f":"ROUND($R$76*$AF$34,2)","v":1.26},{"$f":"ROUND($R$76*$AF$35,2)","v":1.37},{"$f":"ROUND($R$76*$AF$36,2)","v":1.06},{"$f":"ROUND($R$76*$AF$37,2)","v":0.99}]
[97,"Eersel",1,"  Postbus 12,  5520 AA  EERSEL"]
[98,"Eijsden-Margraten",1,"  Postbus 10, 6269 ZG MARGRATEN",null,null,null,null,null,null,"Klinkers:",null,null,"Tegels:"]
[99,"Eindhoven",1,"  Postbus 90150,  5600 RB  EINDHOVEN","Tarief: A4",null,null,"2.","Onderhoud:","m2",{"$f":"ROUND($P$66*($L$77*$AF$32)+$P$67*($M$77*$AF$32),2)","v":4.93},{"$f":"ROUND($P$66*($L$77*$AF$33)+$P$67*($M$77*$AF$33),2)","v":4.03},{"$f":"ROUND($P$66*($L$77*$AF$34)+$P$67*($M$77*$AF$34),2)","v":3.58},{"$f":"ROUND($R$66*($M$77*$AF$35)+$R$67*($L$77*$AF$35),2)","v":3.09},{"$f":"ROUND($R$66*($M$77*$AF$36)+$R$67*($L$77*$AF$36),2)","v":2.38},{"$f":"ROUND($R$66*($M$77*$AF$37)+$R$67*($L$77*$AF$37),2)","v":2.2400000000000002}]
[100,"Elburg",1,"  Postbus 70,  8080 AB  ELBURG",null,null,null,"3a.","Degeneratie","pp",{"$f":"ROUND(($N$77*$AF$32)/1.185,2)","v":31.48},0,0,{"$f":"ROUND(($P$77*$AF$35)/1.185,2)","v":8.89},0,0]
[101,"Emmen",1,"  Postbus 3001,  7800 AA  EMMEN",null,null,null,"3b.","Degeneratie:","m1",0,{"$f":"ROUND(($O$77*$AF$33)/1.185,2)","v":13.52},{"$f":"ROUND(($O$77*$AF$34)/1.185,2)","v":12.01},0,{"$f":"ROUND(($Q$77*$AF$36)/1.185,2)","v":7.29},{"$f":"ROUND(($Q$77*$AF$37)/1.185,2)","v":6.86}]
[102,"Enkhuizen",4,"  Postbus 11,  1600 AA  ENKHUIZEN",null,null,null,"4.","Beheerskosten:","m2",{"$f":"ROUND($R$77*$AF$32,2)","v":1.74},{"$f":"ROUND($R$77*$AF$33,2)","v":1.42},{"$f":"ROUND($R$77*$AF$34,2)","v":1.26},{"$f":"ROUND($R$77*$AF$35,2)","v":1.37},{"$f":"ROUND($R$77*$AF$36,2)","v":1.06},{"$f":"ROUND($R$77*$AF$37,2)","v":0.99}]
[103,"Enschede",1,"  Postbus 20, 7500 AA  ENSCHEDE"]
[104,"Epe",1,"  Postbus 600,  8160 AP  EPE",null,null,null,null,null,null,"Klinkers:",null,null,"Tegels:"]
[105,"Ermelo",1,"  Postbus 500, 3850 AM  ERMELO","Tarief: A5",null,null,"2.","Onderhoud:","m2",{"$f":"ROUND($P$66*($L$78*$AF$32)+$P$67*($M$78*$AF$32),2)","v":5.49},{"$f":"ROUND($P$66*($L$78*$AF$33)+$P$67*($M$78*$AF$33),2)","v":4.49},{"$f":"ROUND($P$66*($L$78*$AF$34)+$P$67*($M$78*$AF$34),2)","v":3.99},{"$f":"ROUND($R$66*($M$78*$AF$35)+$R$67*($L$78*$AF$35),2)","v":3.49},{"$f":"ROUND($R$66*($M$78*$AF$36)+$R$67*($L$78*$AF$36),2)","v":2.69},{"$f":"ROUND($R$66*($M$78*$AF$37)+$R$67*($L$78*$AF$37),2)","v":2.5299999999999998}]
[106,"Etten-Leur",1,"  Postbus 10100,  4870 GA  ETTEN-LEUR",null,null,null,"3a.","Degeneratie","pp",{"$f":"ROUND(($N$78*$AF$32)/1.185,2)","v":38.56},0,0,{"$f":"ROUND(($P$78*$AF$35)/1.185,2)","v":10.83},0,0]
[107,"Ferwerderadiel",1,"  Postbus 2,  9172 ZS  FERWERT",null,null,null,"3b.","Degeneratie:","m1",0,{"$f":"ROUND(($O$78*$AF$33)/1.185,2)","v":15.77},{"$f":"ROUND(($O$78*$AF$34)/1.185,2)","v":14.01},0,{"$f":"ROUND(($Q$78*$AF$36)/1.185,2)","v":9.5299999999999994},{"$f":"ROUND(($Q$78*$AF$37)/1.185,2)","v":8.9499999999999993}]
[108,"Franekeradeel",1,"  Postbus 58, 8800 AB  FRANEKER",null,null,null,"4.","Beheerskosten:","m2",{"$f":"ROUND($R$78*$AF$32,2)","v":1.74},{"$f":"ROUND($R$78*$AF$33,2)","v":1.42},{"$f":"ROUND($R$78*$AF$34,2)","v":1.26},{"$f":"ROUND($R$78*$AF$35,2)","v":1.37},{"$f":"ROUND($R$78*$AF$36,2)","v":1.06},{"$f":"ROUND($R$78*$AF$37,2)","v":0.99}]
[109,"Geertruidenberg",1,"  Postbus 10001,  4940 GA  RAAMSDONKSVEER"]
[110,"Geldermalsen",3,"  Postbus 112,  4190 CG  GELDERMALSEN"]
[111,"Geldrop-Mierlo",1,"  Postbus 10101, 5660 GA  GELDROP"]
[112,"Gemert-Bakel",1,"  Postbus 10000,  5420 DA  GEMERT"]
[113,"Gennep",1,"  Postbus 9003,  6590 HD  GENNEP","Tarief: B1,1",null,null,"B1","klinkers","< 15 m2",null,{"$f":"$K$86","v":1.74}," per m2","+ per reparatie               ",null,{"$f":"$K$84","v":7.81}]
[114,"Giessenlanden",5,"  Postbus 1,  4223 ZG  HOORNAAR",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"$N$86","v":1.37}," per m2","+ per reparatie               ",null,{"$f":"$O$96","v":0}]
[115,"Gilze en Rijen",1,"  Postbus 73, 5120 AB  RIJEN",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"$L$86","v":1.42}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$85","v":2.59}]
[116,"Goeree-Overflakkee",1,"  Postbus 1, 3240 AA MIDDELHARNIS",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"$O$86","v":1.06}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$85","v":0}]
[117,"Goes",1,"  Postbus 2118,  4460 MC  GOES"]
[118,"Goirle",1,"  Postbus 17,  5050 AA  GOIRLE"]
[119,"Gooise Meren",1,"  Postbus 6000, 1400 HA BUSSUM","Tarief: B1,2",null,null,"B1","klinkers","< 15 m2",null,{"$f":"$K$92","v":1.74}," per m2","+ per reparatie               ",null,{"$f":"$K$90","v":10.98}]
[120,"Gorichem",5,"  Postbus 108,  4200 AC  GORINCHEM",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"$N$92","v":1.37}," per m2","+ per reparatie               ",null,{"$f":"$N$90","v":0.77}]
[121,"Gouda",5,"  Postbus 1086,  2800 BB  GOUDA",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"$L$92","v":1.42}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$91","v":3.64}]
[122,"Grave",1,"  Postbus 7,  5360 AA  GRAVE",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"$O$92","v":1.06}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$91","v":0.15}]
[123,"Groningen",2,"  Postbus 2001, 9700 PB  GRONINGEN"]
[124,"Grootegast",1,"  Postbus 46,  9860 AA  GROOTEGAST"]
[125,"Gulpen-Wittem",1,"  Postbus 56,  6270 AB  GULPEN","Tarief: B1,3",null,null,"B1","klinkers","< 15 m2",null,{"$f":"$K$98","v":1.74}," per m2","+ per reparatie               ",null,{"$f":"$K$96","v":20.5}]
[126,"Haaksbergen",1,"  Postbus 102,  7480 AC  HAAKSBERGEN",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"$N$98","v":1.37}," per m2","+ per reparatie               ",null,{"$f":"$N$96","v":3.09}]
[127,"Haaren",1,"  Postbus 44,  5076 ZG  HAAREN",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"$L$98","v":1.42}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$97","v":6.79}]
[128,"Haarlem",1,"  Postbus 511,  2003 PB  HAARLEM",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"$O$98","v":1.06}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$97","v":0.6}]
[129,"Haarlemmerliede en Spaarnewoude",1,"  Postbus 83,  1160 AB  ZWANENBURG"]
[130,"Haarlemmermeer",2,"  Postbus 250,  2130 AG  HOOFDDORP"]
[131,"Halderberge",1,"  Postbus 5,  4730 AA  OUDENBOSCH","Tarief: B1,4",null,null,"B1","klinkers","< 15 m2",null,{"$f":"$K$104","v":1.74}," per m2","+ per reparatie               ",null,{"$f":"$K$102","v":31.48}]
[132,"Hardenberg",1,"  Postbus 500,  7770 BA  HARDENBERG",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"$N$104","v":1.37}," per m2","+ per reparatie               ",null,{"$f":"$N$102","v":8.89}]
[133,"Harderwijk",1,"  Postbus 149,  3840 AC  HARDERWIJK",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"$L$104","v":1.42}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$103","v":13.52}]
[134,"Hardinxveld-Giessendam",5,"  Postbus 175,  3370 AD  HARDINXVELD-GIESSENDAM",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"$O$104","v":1.06}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$103","v":7.29}]
[135,"Haren",1,"  Postbus 21,  9750 AA  HAREN"]
[136,"Harlingen",1,"  Postbus 10000,  8860 HA  HARLINGEN","Tarief: B1,5",null,null,"B1","klinkers","< 15 m2",null,{"$f":"$K$110","v":1.74}," per m2","+ per reparatie               ",null,{"$f":"$K$108","v":38.56}]
[137,"Hattem",1,"  Postbus 93,  8050 AB  HATTUM",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"$N$110","v":1.37}," per m2","+ per reparatie               ",null,{"$f":"$N$108","v":10.83}]
[138,"Heemskerk",1,"  Postbus 39,  1960 AA  HEEMSKERK",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"$L$110","v":1.42}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$109","v":15.77}]
[139,"Heemstede",1,"  Postbus 352,  2100 AJ HEEMSTEDE",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"$O$110","v":1.06}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$109","v":9.5299999999999994}]
[140,"Heerde",1,"  Postbus 175,  8180 AD  HEERDE"]
[141,"Heerenveen",1,"  Postbus 15000,  8440 GA HEERENVEEN"]
[142,"Heerhugowaard",1,"  Postbus 390,  1700 AJ  HEERHUGOWAARD","Tarief: B2,1",null,null,"B1","klinkers","< 15 m2",null,{"$f":"SUM($K$83,$K$86)","v":3.88}," per m2","+ per reparatie               ",null,{"$f":"$K$84","v":7.81}]
[143,"Heerlen",1,"  Postbus 1,  6400 AA  HEERLEN",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"SUM($N$83,$N$86)","v":2.5499999999999998}," per m2","+ per reparatie               ",null,{"$f":"$O$96","v":0}]
[144,"Heeze-Leende",1,"  Postbus 10000,  5590 GA  HEEZE",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"SUM($L$83,$L$86)","v":3.17}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$85","v":2.59}]
[145,"Heiloo",1,"  Postbus 1,  1850 AA  HEILOO ",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"SUM($O$83,$O$86)","v":1.9700000000000002}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$85","v":0}]
[146,"Hellendoorn",1,"  Postbus 200, 7440 AE  NIJVERDAL"]
[147,"Hellevoetsluis",1,"  Postbus 13,  3220 AA  HELLEVOETSLUIS"]
[148,"Helmond",1,"  Postbus 950,  5700 AZ  HELMOND","Tarief: B2,2",null,null,"B1","klinkers","< 15 m2",null,{"$f":"SUM($K$89,$K$92)","v":4.1500000000000004}," per m2","+ per reparatie               ",null,{"$f":"$K$90","v":10.98}]
[149,"Hendrik-Ido-Ambacht",4,"  Postbus 34,  3340 AA  HENDRIK-IDO-AMBACHT",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"SUM($N$89,$N$92)","v":2.72}," per m2","+ per reparatie               ",null,{"$f":"$N$90","v":0.77}]
[150,"Hengelo (O.)",1,"  Postbus 18, 7550 AA  HENGELO",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"SUM($L$89,$L$92)","v":3.3899999999999997}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$91","v":3.64}]
[151,"Het Bildt",1,"  Postbus 34,  9076 ZN  ST. ANNAPAROCHIE",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"SUM($O$89,$O$92)","v":2.1}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$91","v":0.15}]
[152,"Heumen",1,"  Postbus 200,  6800 AZ  MALDEN"]
[153,"Heusden",1,"  Postbus 31,  5250 AA  VLIJMEN"]
[154,"Hillegom",1,"  Postbus 32,  2180 AA  HILLEGOM","Tarief: B2,3",null,null,"B1","klinkers","< 15 m2",null,{"$f":"SUM($K$95,$K$98)","v":4.9800000000000004}," per m2","+ per reparatie               ",null,{"$f":"$K$96","v":20.5}]
[155,"Hilvarenbeek",1,"  Postbus 3,  5080 AA  HILVARENBEEK",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"SUM($N$95,$N$98)","v":3.25}," per m2","+ per reparatie               ",null,{"$f":"$N$96","v":3.09}]
[156,"Hilversum",1,"  Postbus 9900,  12101 GM  HILVERSUM",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"SUM($L$95,$L$98)","v":4.07}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$97","v":6.79}]
[157,"Hof van Twente",1,"  Postbus 54,  7470 AB  GOOR",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"SUM($O$95,$O$98)","v":2.5099999999999998}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$97","v":0.6}]
[158,"Hollands Kroon",1,"  Postbus 8, 1760 AA ANNA PAULOWNA"]
[159,"Hoogeveen",1,"  Postbus 20000,  7900 PA  HOOGEVEEN"]
[160,"Hoogezand -Sappemeer",1,"  Postbus 75,  9600 AB  HOOGEZAND","Tarief: B2,4",null,null,"B1","klinkers","< 15 m2",null,{"$f":"SUM($K$101,$K$104)","v":6.67}," per m2","+ per reparatie               ",null,{"$f":"$K$102","v":31.48}]
[161,"Hoorn",5,"  Postbus 603,  1620 AR  HOORN",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"SUM($N$101,$N$104)","v":4.46}," per m2","+ per reparatie               ",null,{"$f":"$N$102","v":8.89}]
[162,"Horst aan de Maas",1,"  Postbus 6005,  5960 AA  HORST",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"SUM($L$101,$L$104)","v":5.45}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$103","v":13.52}]
[163,"Houten",1,"  Postbus 30,  3990 DA  HOUTEN",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"SUM($O$101,$O$104)","v":3.44}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$103","v":7.29}]
[164,"Huizen",1,"  Postbus 5,  1270 AA  HUIZEN"]
[165,"Hulst",1,"  Postbus 49,  4560 AA  HULST"]
[166,"IJsselstein",1,"  Postbus 26, 3400 AA  IJSSELSTEIN","Tarief: B2,5",null,null,"B1","klinkers","< 15 m2",null,{"$f":"SUM($K$107,$K$110)","v":7.23}," per m2","+ per reparatie               ",null,{"$f":"$K$108","v":38.56}]
[167,"Kaag en Braassem",3,"  Postbus 1, 2370 AA ROELOFARENDSVEEN",null,null,null,"B2","tegels  ","< 15 m2",null,{"$f":"SUM($N$107,$N$110)","v":4.8600000000000003}," per m2","+ per reparatie               ",null,{"$f":"$N$108","v":10.83}]
[168,"Kampen",1,"  Postbus 5009,  8260 GA  KAMPEN",null,null,null,"B3","klinkers","> 15 m2",null,{"$f":"SUM($L$107,$L$110)","v":5.91}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$L$109","v":15.77}]
[169,"Kapelle",1,"  Postbus 79,  4420 AC  KAPELLE",null,null,null,"B4","tegels  ","> 15 m2",null,{"$f":"SUM($O$107,$O$110)","v":3.75}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$O$109","v":9.5299999999999994}]
[170,"Katwijk",1,"  Postbus 589,  2220 AN  KATWIJK"]
[171,"Kerkrade",1,"  Postbus 600, 6460 AP  KERKRADE"]
[172,"Koggenland",5,"  Postbus 21 1633 ZG AVENHORN"]
[173,"Kollumerland en Nieuwkruisland",1,"  Postbus 13,  9290 AA  KOLLUM"]
[174,"Korendijk",1,"  Postbus 3708,  3265 ZG  PIERSHIL","Tarief: C1",null,null,"C1","klinkers ","< 15 m2",null,{"$f":"($AF$32/2)/1.2+$K$83+$K$86","v":15.930000000000001}," per m2"]
[175,"Krimpen aan den IJssel",5,"  Postbus 200,  2922 AE  KRIMPEN AAN DE IJSSEL",null,null,null,"C2","tegels   ","< 15 m2",null,{"$f":"($AF$35/2)/1.2+$N$83+$N$86","v":12.095833333333335}," per m2"]
[176,"Krimpenerwaard",5,"  Postbus 51, 2820 AB STOLWIJK",null,null,null,"C3","klinkers ","> 15 m2",null,{"$f":"($AF$33/2)/1.2+$L$83+$L$86","v":13.024166666666666}," per m2"]
[177,"Laarbeek",1,"  Postbus 190,  5740 AD  BEEK EN DONK",null,null,null,"C4","tegels   ","> 15 m2",null,{"$f":"($AF$36/2)/1.2+$O$83+$O$86","v":9.32}," per m2"]
[178,"Landerd",1,"  Postbus 35, 5410 AA  ZEELAND"]
[179,"Landgraaf",1,"  Postbus 31000,  6370 AA  LANDGRAAF"]
[180,"Landsmeer",5,"  Postbus 1,  1120 AA  LANDSMEER","Tarief: C2",null,null,"C1","klinkers ","< 15 m2",null,{"$f":"($AF$32/2)/1.2+$K$89+$K$92","v":16.2}," per m2"]
[181,"Langedijk",1,"  Postbus 15,  1723 ZG  NOORD-SCHARWOUDE",null,null,null,"C2","tegels   ","< 15 m2",null,{"$f":"($AF$35/2)/1.2+$N$89+$N$92","v":12.265833333333333}," per m2"]
[182,"Lansingerland",5,"  Postbus 1,  2650 AA  BERKEL & RODENRIJS",null,null,null,"C3","klinkers ","> 15 m2",null,{"$f":"($AF$33/2)/1.2+$L$89+$L$92","v":13.244166666666667}," per m2"]
[183,"Laren",1,"  Postbus 5,  1250 AA  LAREN",null,null,null,"C4","tegels   ","> 15 m2",null,{"$f":"($AF$36/2)/1.2+$O$89+$O$92","v":9.4500000000000011}," per m2"]
[184,"Leek",1,"  Postbus 100,  9350 AC  LEEK"]
[185,"Leerdam",3,"  Postbus 15, 4140 AA  LEERDAM"]
[186,"Leeuwarden",1,"  Postbus 21000,  8900 JA  LEEUWARDEN","Tarief: C3",null,null,"C1","klinkers ","< 15 m2",null,{"$f":"($AF$32/2)/1.2+$K$95+$K$98","v":17.03}," per m2"]
[187,"Leeuwarderadeel",2,"  Postbus 24,  9050 AA  STIENS",null,null,null,"C2","tegels   ","< 15 m2",null,{"$f":"($AF$35/2)/1.2+$N$95+$N$98","v":12.795833333333334}," per m2"]
[188,"Leiden",1,"  Postbus 9100,  2300 PC  LEIDEN",null,null,null,"C3","klinkers ","> 15 m2",null,{"$f":"($AF$33/2)/1.2+$L$95+$L$98","v":13.924166666666666}," per m2"]
[189,"Leiderdorp",3,"  Postbus 35,  2353 AA  LEIDERDORP",null,null,null,"C4","tegels   ","> 15 m2",null,{"$f":"($AF$36/2)/1.2+$O$95+$O$98","v":9.8600000000000012}," per m2"]
[190,"Leidschendam-Voorburg",1,"  Postbus 905,  2270 AX  VOORBURG"]
[191,"Lelystad",1,"  Postbus 91,  8200 AB  LELYSTAD"]
[192,"Leudal",1,"  Postbus 3008, 6093 ZG HEYTHUYSEN","Tarief: C4",null,null,"C1","klinkers ","< 15 m2",null,{"$f":"($AF$32/2)/1.2+$K$101+$K$104","v":18.72}," per m2"]
[193,"Leusden",1,"  Postbus 150,  3830 AD  LEUSDEN",null,null,null,"C2","tegels   ","< 15 m2",null,{"$f":"($AF$35/2)/1.2+$N$101+$N$104","v":14.005833333333335}," per m2"]
[194,"Lingewaal",3,"  Postbus 1014,  4147 ZG  ASPEREN",null,null,null,"C3","klinkers ","> 15 m2",null,{"$f":"($AF$33/2)/1.2+$L$101+$L$104","v":15.304166666666665}," per m2"]
[195,"Lingewaard",1,"  Postbus 15,  6680 AA  BEMMEL",null,null,null,"C4","tegels   ","> 15 m2",null,{"$f":"($AF$36/2)/1.2+$O$101+$O$104","v":10.790000000000001}," per m2"]
[196,"Lisse",1,"  Postbus 200,  2160 AE  LISSE"]
[197,"Littenseradiel",1,"  Postbus 1,  8730 AA  WOMMELS"]
[198,"Lochem",1,"  Postbus 17,  7240 AA  LOCHEM","Tarief: C5",null,null,"C1","klinkers ","< 15 m2",null,{"$f":"($AF$32/2)/1.2+$K$107+$K$110","v":19.279999999999998}," per m2"]
[199,"Loon op Zand",1,"  Postbus 7,  5170 AA  KAATSHEUVEL",null,null,null,"C2","tegels   ","< 15 m2",null,{"$f":"($AF$35/2)/1.2+$N$107+$N$110","v":14.405833333333334}," per m2"]
[200,"Lopik",4,"  Postbus 50,  3410 CB  LOPIK",null,null,null,"C3","klinkers ","> 15 m2",null,{"$f":"($AF$33/2)/1.2+$L$107+$L$110","v":15.764166666666666}," per m2"]
[201,"Loppersum",3,"  Postbus 25,  9919 ZG  LOPPERSUM",null,null,null,"C4","tegels   ","> 15 m2",null,{"$f":"($AF$36/2)/1.2+$O$107+$O$110","v":11.100000000000001}," per m2"]
[202,"Losser",1,"  Postbus 90,  7580 AB  LOSSER"]
[203,"Maasdriel",1,"  Postbus 10000,  5330 GA  KERKDRIEL"]
[204,"Maasgouw",1,"  Postbus 7000,  6050 AA MAASBRACHT","Tarief: D",null,null,"D1","trottoirband",null,null,{"$f":"$AF$38+($R$78*$AF$38)","v":11.395}," per m1"]
[205,"Maassluis",3,"  Postbus 55,  3140 AB  MAASSLUIS",null,null,null,"D2","opsluitband/koprolband",null,null,{"$f":"$AF$39+($R$78*$AF$39)","v":9.0629999999999988}," per m1"]
[206,"Maastricht",1,"  Postbus 1992,  6201 BZ  MAASTRICHT",null,null,null,"D3","berm/ gazon ","<50m2",null,{"$f":"(+$L$209*100)/2","v":102.00843750000001},"per reparatie"]
[207,"Marum",1,"  Postbus 2, 9363 ZG  MARUM",null,null,null,"D4","berm/ gazon",">50m2",null,{"$f":"(+$AF$40+$AF$41)+(($AF$40+$AF$41)*$R$74)","v":2.0401687500000003}," per m2"]
[208,"Medemblik",5,"  Postbus 7,  1670 AA  MEDEMBLIK"]
[209,"Meerssen",1,"  Postbus 90,  6230 AB  MEERSSEN"]
[210,"Menameradiel",1,"  Postbus 3,  9036 ZW  MENALDUM"]
[211,"Menterwolde",1,"  Postbus 2,  9649 ZG  MUNTENDAM"]
[212,"Meppel",1,"  Postbus 501,  7940 AM  MEPPEL"]
[213,"Middelburg",1,"  Postbus 6000,  430 LA  MIDDELBURG"]
[214,"Midden-Delftland",5,"  Postbus 1, 2636 ZG SCHIPLUIDEN"]
[215,"Midden-Drenthe",1,"  Postbus 24, 9410 AA  BEILEN"]
[216,"Mill en Sint Hubert",1,"  Postbus 39,  5450 AA  MILL"]
[217,"Moerdijk",1,"  Postbus 4,  4760 AA  ZEVENBERGEN"]
[218,"Molenwaard",5,"  Postbus 5, 2970 AA BLESKENSGRAAF"]
[219,"Montferland",1,"  Postbus 47,  6940 BA  DIDAM"]
[220,"Montfoort",2,"  Postbus 41,  3417 ZG  MONTFOORT"]
[221,"Mook en Middelaar",1,"  Postbus 200,  6585 ZK  MOOK"]
[222,"Neder-Betuwe",1,"  Postbus 20,  4043 ZG  OPHEUSDEN"]
[223,"Nederweert",1,"  Postbus 2728,  6030 AA  NEDERWEERT"]
[224,"Neerijnen",2,"  Postbus 30,  4180 BA  WAARDENBURG"]
[225,"Nieuwegein",1,"  Postbus 1,  3430 AA  NIEUWEGEIN"]
[226,"Nieuwkoop",3,"  Postbus 17,  2421 EB  NIEUWKOOP"]
[227,"Nijkerk",1,"  Postbus 1000,  3860 BA  NIJKERK"]
[228,"Nijmegen",1,"  Postbus 9105,  6500 HG  NIJMEGEN"]
[229,"Nissewaard",2,"  Postbus 25, 3200 AA SPIJKENISSE"]
[230,"Noord-Beveland",1,"  Postbus 3,  4490 AA  WIISENKERKE"]
[231,"Noordenveld",1,"  Postbus 109,  9300 AC  RODEN"]
[232,"Noordoostpolder",1,"  Postbus 155,  8300 AD EMMELOORD"]
[233,"Noordwijk",1,"  Postbus 298,  2200 AG  NOORDWIJK"]
[234,"Noordwijkerhout",1,"  Postbus 13,  2210 AA  NOORDWIJKERHOUT"]
[235,"Nuenen, Gerwen en Nederwetten",1,"  Postbus 10000,  5670 GA  NUENEN"]
[236,"Nunspeet",1,"  Postbus 79,  8070 AB  NUNSPEET"]
[237,"Nuth",1,"  Postbus 22000,  6360 AA NUTH"]
[238,"Oestgeest",1,"  Postbus 1270,  2340 BG  OEGSTGEEST"]
[239,"Oirschot",1,"  Postbus 11,  5688 ZG  OIRSCHOT"]
[240,"Oisterwijk",1,"  Postbus 10101,  5060 GA  OISTERWIJK"]
[241,"Oldambt",1,"  Postbus 175,  9670 AD  WINSCHOTEN"]
[242,"Oldebroek",1,"  Postbus 2,  8096 ZG  OLDENBROEK"]
[243,"Oldenzaal",1,"  Postbus 354,  7570 AJ  OLDENZAAL"]
[244,"Olst-Wijhe",1,"  Postbus 16,  8120 AA  OLST"]
[245,"Ommen",1,"  Postbus 100,  7730 AC  OMMEN"]
[246,"Onderbanken",1,"  Postbus 1090,  6450 CB  SCHINVELD"]
[247,"Oost Gelre",1,"  Postbus 17, 7130 AA LICHTENVOORDE"]
[248,"Oosterhout",1,"  Postbus 10150,  4900 GB  OOSTERHOUT"]
[249,"Ooststellingwerf",1,"  Postbus 38,  8430 AA  OOSTERWOLDE"]
[250,"Oostzaan",4,"  Postbus 15,  1510 AA  OOSTZAAN"]
[251,"Opmeer",3,"  Postbus 199,  1715 ZK  SPANBROEK"]
[252,"Opsterland",1,"  Postbus 10000,  9244 ZP  BEESTERZWAAG"]
[253,"Oss",1,"  Postbus 5,  5340 BA  OSS"]
[254,"Oud-Beijerland",1,"  Postbus 2003,  3260 EA OUD-BEIJERLAND"]
[255,"Oude-IJsselstreek",1,"  Postbus 42,  7980 AA GENDERINGEN"]
[256,"Ouder-Amstel",5,"  Postbus 35,  1190 AA OUDERKERK AAN DE AMSTEL"]
[257,"Oudewater",5,"  Postbus 100,  3420 DC  OUDEWATER"]
[258,"Overbetuwe",1,"  Postbus 11,  6660 AA  ELST"]
[259,"Papendrecht",5,"  Postbus 11,  3350 AA  PAPENDRECHT"]
[260,"Peel en Maas",1,"  Postbus 7088, 5980 AB PANNINGEN"]
[261,"Pekela",1,"  Postbus 20000,  9665 ZM  OUDE PEKELA"]
[262,"Pijnakker-Nootdorp",5,"  Postbus 1, 2640 AA  PIJNACKER"]
[263,"Purmerend",3,"  Postbus 15,  1440 AA  PURMEREND"]
[264,"Putten",1,"  Postbus 400,  3880 AK  PUTTEN"]
[265,"Raalte",1,"  Postbus 140,  8100 AC  RAALTE"]
[266,"Reimerswaal",1,"  Postbus 70,  4416 ZH  KRUININGEN"]
[267,"Renkum",1,"  Postbus 9100,  6860 HA  OOSTERBEEK"]
[268,"Renswoude",1,"  Postbus 8,  3927 ZL  RENSWOUDE"]
[269,"Reusel-De Mierden",1,"  Postbus 11,  5540 AA REUSEL"]
[270,"Rheden",1,"  Postbus 9110,  6994 ZJ  DE STEEG"]
[271,"Rhenen",1,"  Postbus 201,  3910 AE  RHENEN"]
[272,"Ridderkerk",5,"  Postbus 271,  2980 AG  RIDDERKERK"]
[273,"Rijnwaarden",1,"  Postbus 49,  6916 ZG  TOLKAMER"]
[274,"Rijssen-Holten",1,"  Postbus 244, 7460 AE RIJSSEN"]
[275,"Rijswijk",1,"  Postbus 5305,  2280 HH  RIJSWIJK"]
[276,"Roerdalen",1,"  Postbus 6740,  6075 ZG  HERKENBOSCH"]
[277,"Roermond",1,"  Postbus900,  6040 AX  ROERMOND"]
[278,"Roosendaal",1,"  Postbus 5000,  4700 KA  ROOSENDAAL"]
[279,"Rotterdam",1,"  Postbus 70012,  3000 KP  ROTTERDAM"]
[280,"Rozendaal",1,"  Postbus 9106,  6880 HH VELP"]
[281,"Rucphen",1,"  Postbus 9,  4715 ZG  RUCPHEN"]
[282,"Schagen",2,"  Postbus 8,  1740 AA  SCHAGEN"]
[283,"Scherpenzeel",1,"  Postbus 100,  3925 ZJ  SCHERPENZEEL"]
[284,"Schiedam",5,"  Postbus 1501,  3100 EA  SCHIEDAM"]
[285,"Schiermonnikoog",1,"  Postbus 20,  9166 ZP  SCHIERMONNIKOOG"]
[286,"Schijndel",1,"  Postbus 5,  5480  AA  SCHIJNDEL"]
[287,"Schinnen",1,"  Postbus 50,  6365 ZH  SCHINNEN"]
[288,"Schouwen-Duiveland",1,"  Postbus 5555,  4300 AJ  ZIERIKZEE"]
[289,"s-Gravenhage",1,"  Postbus 12600,  2500 DJ  's-GRAVENHAGE"]
[290,"s-Hertogenbosch ",1,"  Postbus 12345,  5200 GZ  's HERTOGENBOSCH"]
[291,"Simpelveld",1,"  Postbus 21000,  6369 ZG  SIMPELVELD"]
[292,"Sint Anthonis",1,"  Postbus 40,  5845 ZG  SINT ANTHOnIS"]
[293,"Sint-Michelsgestel",1,"  Postbus 10000, 5270 GA  SINT-MICHIELSGESTEL"]
[294,"Sint-Oedenrode",1,"  Postbus 44,  5490 AA SINT-OEDENRODE"]
[295,"Sittard-Geleen",1,"  Postbus 18,  6130 AA  SITTARD"]
[296,"Sliedrecht",5,"  Postbus 16,  3360 AA  SLIEDReCHT"]
[297,"Slochteren",1,"  Postbus 13, 9620 AA  SLOCHTEREN"]
[298,"Sluis",1,"  Postbus 27,  4500 AA  OOSTBURG"]
[299,"Smallingerland",1,"  Postbus 10000,  9200 HA  DRACHTEN"]
[300,"Soest",1,"  Postbus 2000,  3760 CA  SOEST"]
[301,"Someren",1,"  Postbus 290, 5710 AG  SOMEREN"]
[302,"Son en Breugel",1,"  Postbus 8,  5690  AA  SON"]
[303,"Stadskanaal",1,"  Postbus 140, 9500 AC  STADSKANAAL"]
[304,"Staphorst",1,"  Postbus 2,  7950 AA  STAPHORST"]
[305,"Stede Broec",4,"  Postbus 20,  1610 AA  BOVENKARSPEL"]
[306,"Steenbergen",1,"  Postbus 6,  4650 AA  STEENBERGEN"]
[307,"Steenwijkerland",1,"  Postbus 162,  8330 AD  STEENWIJK"]
[308,"Stein",1,"  Postbus 15, 6170 AA  STEIN"]
[309,"Stichtse Vecht",2,"  Postbus 1212, 3600 BE MAARSSEN "]
[310,"Strijen",4,"  Postbus 5881,  3290 EA  STRIJEN"]
[311,"Sudwest Fryslan",1,"  Postbus 10000,  8600 HA  SNEEK"]
[312,"Ten Boer",3,"  Postbus 7,  9790 AA  TEN BOER"]
[313,"Terneuzen",1,"  Postbus 35,  4530 AA  TERNEUZEN"]
[314,"Terschelling",1,"  Postbus 14,  8880 AA  WEST-TERSCHELLING"]
[315,"Texel",1,"  Postbus 200, 1790 AE  DEN BURG"]
[316,"Teylingen",1,"  Postbus 149, 2215 VOORHOUT"]
[317,"Tholen",2,"  Postbus 51, 4690 AB THOLEN"]
[318,"Tiel",1,"  Postbus 6325, 4000 HH TIEL"]
[319,"Tilburg",1,"  Postbus 90155, 5000 LH TILBURG"]
[320,"Tubbergen",1,"  Postbus 30, 7650 AA TUBBERGEN"]
[321,"Twenterand",1,"  Postbus 67, 7670 AB  VRIEZENVEEN"]
[322,"Tynaarlo",1,"  Postbus 5,  9480 AA VRIES"]
[323,"Tytsjerksteradiel",1,"  Postbus 3,  9250 AA  BURGUM"]
[324,"Uden",1,"  Postbus 83,  5400 AB UDEN"]
[325,"Uitgeest",1,"  Postbus 7,  1910 AA  UITGEEST"]
[326,"Uithoorn",5,"  Postbus 8, 1420 AA  UITHOORN"]
[327,"Urk",1,"  Postbus 77,  8320 AB  URK"]
[328,"Utrecht",1,"  Postbus 16200,  3500 CE  UTRECHT"]
[329,"Utrechtse Heuvelrug",1,"  Postbus 200, 3940 AE DOORN"]
[330,"Vaals",1,"  Postbus 450,  6290 AL  VAALS"]
[331,"Valkenburg aan de Geul",1,"  Postbus 998, 6300 AZ  VALKENBURG AAN DE GEUL"]
[332,"Valkenswaard",1,"  Postbus 10100,  5550 GA  VALKENSWAARD"]
[333,"Veendam",1,"  Postbus 20004,  9640 PA  VEENDAM"]
[334,"Veenendaal",1,"  Postbus 1100,  3900 BC  VEENENDAAL"]
[335,"Veere",1,"  Postbus 1000, 4357 ZV  DOMBURG"]
[336,"Veghel",1,"  Postbus 10001,  5460 DA  VEGHEL"]
[337,"Veldhoven",1,"  Postbus 10101,  5500 GA  VELDHOVEN"]
[338,"Velsen",1,"  Postbus 465, 1970 AL  IJMUIDEN"]
[339,"Venlo",1,"  Postbus 3434,  5902 RK  VENLO"]
[340,"Venray",1,"  Postbus 500,  5800 AM  VENRAY"]
[341,"Vianen",2,"  Postbus 46,  4130 EA  VIANEN"]
[342,"Vlaardingen",5,"  Postbus 1002, 3130 EB VLAARDINGEN"]
[343,"Vlagtwedde",1,"  Dorpsstraat 1, 9551 AB SELLINGEN"]
[344,"Vlieland",1,"  Postbus 10,  8899 ZN  VLIELAND"]
[345,"Vlissingen",1,"  Postbus 3000,  4380 GV  VLISSINGEN"]
[346,"Voerendaal",1,"  Postbus 23000,  6367 ZG  VOERENDAAL"]
[347,"Voorschoten",1,"  Postbus 393,  2250 AJ  VOORSCOTEN"]
[348,"Voorst",1,"  Postbus 9000, 7390 HA  TWELLO"]
[349,"Vught",1,"  Postbus 10100,  5260 GA  VUGHT"]
[350,"Waalre",1,"  Postbus 10000,  5580 GA  WAALRE"]
[351,"Waalwijk",1,"  Postbus 10150,  5140 GB  WAALWIJK"]
[352,"Waddinxveen",5,"  Postbus 400,  2740 AK  WADDINXVEEN"]
[353,"Wageningen",1,"  Postbus 1, 6700 AA  WAGENINGEN"]
[354,"Wassenaar",1,"  Postbus 499,  2240 AL  WASSENAAR"]
[355,"Waterland",5,"  Postbus 1000,  1140 BA  MONNICKENDAM"]
[356,"Weert",1,"  Postbus 950,  6000 AZ  WEERT"]
[357,"Weesp",1,"  Postbus 5099,  1380 GB  WEESP"]
[358,"Werkendam",1,"  Postbus 16,  4250 DA  WERKENDAM"]
[359,"West Maas en Waal",1,"  Postbus 1,  6658  ZG BENEDEN-LEEUWEN"]
[360,"Westerveld",1,"  Postbus 50,  7970 AB  HAVELTE"]
[361,"Westervoort",1,"  Postbus 40, 6930 AA  WESTERVOORT"]
[362,"Westland",1,"  Postbus 150,  2670 AD  NAALDWIJK"]
[363,"Weststellingwerf",1,"  Postbus 60,  8470 AB  WOLVEGA"]
[364,"Westvoorne",1,"  Postbus 550,  3235 ZH  ROCKANJE"]
[365,"Wierden",1,"  Postbus 43,  7640 AA  WIERDEN"]
[366,"Wijchen",1,"  Postbus 9000, 6600 HA  WIJCHEN"]
[367,"Wijdemeren",1,"  Postbus 41,  1243 ZG  's Graveland"]
[368,"Wijk bij Duurstede",1,"  Postbus 83,  3960 BB  WIJK BIJ DUURSTEDE"]
[369,"Winsum",4,"  Postbus 10,  9950 AA  WINSUM"]
[370,"Winterswijk",1,"  Postbus 101,  7100 AC  WINTERSWIJK"]
[371,"Woensdrecht",1,"  Postbus 24,  4630 AA  HOOGERHEIDE"]
[372,"Woerden",4,"  Postbus 45,  3440 AA  WOERDEN"]
[373,"Wormerland",1,"  Postbus 20,  1530 AA  WORMER"]
[374,"Woudenberg",1,"  Postbus 16,  3930 EA  WOUDENBERG"]
[375,"Woudrichem",2,"  Postbus 6,  4285 ZG  WOUDRICHEM"]
[376,"Zaanstad",3,"  Postbus 2000,  1500 GA  ZAANDAM"]
[377,"Zaltbommel",1,"  Postbus 10002,  5300 DA  ZALTBOMMEL"]
[378,"Zandvoort",1,"  Postbus 2,  2040 AA  ZANDVOORT"]
[379,"Zederik",4,"  Postbus 1,  4230 BA  MEERKERK"]
[380,"Zeewolde",1,"  Postbus 1,  3890 AA  ZEEWOLDE"]
[381,"Zeist",1,"  Postbus 513,  3700 AM  ZEIST"]
[382,"Zevenaar",1,"  Postbus 10, 6900 AA  ZEVENAAR"]
[383,"Zoetermeer",3,"  Postbus 15,  2700 AA  ZOETERMEER"]
[384,"Zoeterwoude",5,"  Postbus 34,  2380 AA  ZOETERWOUDE"]
[385,"Zuidhorn",2,"  Postbus 3,  9800 AA  ZUIDHORN"]
[386,"Zuidplas",5,"  Postbus 100, 2910 AC NIEUWERKERK a/d IJSSEL"]
[387,"Zundert",1,"  Postbus 10001,  4880 GA  ZUNDERT"]
[388,"Zutphen",1,"  Postbus 41,  7200 AA  ZUTPHEN"]
[389,"Zwartewaterland",1,"  Postbus 23,  8060 AA  HASSELT"]
[390,"Zwijndrecht",4,"  Postbus 15,  3330 AA  ZWIJNDRECHT"]
[391,"Zwolle",1,"  Postbus 10007,  8000 GA  ZWOLLE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Keuze wie het werk uitvoert?"]
[null,"Herstel en onderhoud uitgevoerd door de gemeente"]
[null,"Herstel en onderhoud door de aanbieder"]
[null,"Herstel door de aanbieder en onderhoud door de gemeente"]
[null,"Herstel door de weg beheerder vooraf gaande aan algehele herbestrating"]

{"sheet":"Invoerscherm","index":2,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,3,3,4],[25,3,25,4],[1,2,1,6],[18,6,24,8]]}
[null,null,"Invoerscherm:"]
[null,null,"Gegevens uit: Uitgave Reed Business Informatie Bouw & Infra."]
[null,null,null,"bijgewerkt dd :","2016-11-11"]
[null,"Boekje: 1","GWW Kosten:","uurtarieven en loonkosten*"]
[null,null,null,"huidige tarief:","in te voeren:"]
[null,null,"Straatmaker groep D, inzittende werkbus:",{"$f":"'Gemeenten met categorie'!AF9","v":35.42},35.42]
[null,null,"Straatmaker groep B, inzittende werkbus:",{"$f":"'Gemeenten met categorie'!AF10","v":33.68},33.68]
[null,null,"Transport , EVO berekening",{"$f":"'Gemeenten met categorie'!AF11","v":9.2899999999999991},9.2899999999999991]
[]
[null,"Boekje 2:","GWW Kosten:","Funderingslagen en elementverhardingen"]
[null,null,null,"huidige tarief:","in te voeren:"]
[null,null,"Straatstenen, gebakken"]
[null,null,"Straatklinkers WF kwaliteit A4-12 tot en  met 5000 stuks",{"$f":"'Gemeenten met categorie'!AI22","v":357},357]
[null,null,"Straatklinkers KK 80 kwaliteit A4-12 tot en  met 5000 stuks",{"$f":"'Gemeenten met categorie'!AI23","v":550},550]
[]
[null,null,"Straatstenen, beton:"]
[null,null,"Betonstraatstenen KF, heide, 210 x 105 x 80 mm volle vracht",{"$f":"'Gemeenten met categorie'!AI24","v":239},239]
[]
[null,null,"Tegels beton:",null,null,"*","Bij een juiste invoer en acceptatie zijn de tarieven in de kolom: - huidige tarief en                                          - in te voeren                              gelijk !!!"]
[null,null,"Betontegels, 300 x 300 x 45mm komo, grijs",{"$f":"'Gemeenten met categorie'!AL22","v":8.0299999999999994},8.0299999999999994]
[null,null,"Betontegels, 300 x 300 x 80mm komo, grijs",{"$f":"'Gemeenten met categorie'!AL23","v":11.55},11.55]
[]
[null,null,"Straatzand:"]
[null,null,"Straatzand 10 - 25m3",{"$f":"'Gemeenten met categorie'!AL24","v":10.75},10.75]
[]
[null,"Boekje 3:","GWW Kosten:","Groenvoorzieningen"]
[null,null,null,"huidige tarief:","in te voeren:"]
[null,null,"Uurtarief Cultuurtechnisch medewerker",{"$f":"'Gemeenten met categorie'!AF45","v":30.15},30.15]
[null,null,"Transport , EVO berekening",{"$f":"Invoerscherm!D8","v":9.2899999999999991},9.2899999999999991]
[]
[null,null,"Graszaad, bermmengsel, tot 200kg",{"$f":"'Gemeenten met categorie'!AD55","v":7.15},7.15]
[null,null,"Graszaad, gazonmengsel, tot 200kg",{"$f":"'Gemeenten met categorie'!AD56","v":7.3},7.3]

{"sheet":"INFO","index":3,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Werking \"Rekenblad\":"]
[null,"-","Door de groene posities in te vullen vindt de verrekening plaats volgens de \"Richtlijn tarieven (graaf) werkzaamheden Telecom\"."]
[null,"-","Om de bomen, struiken en het asfalt te kunnen verrekenen kan een projektprijs worden afgesproken en ingevoerd."]
[null,"-","Door scrollen kan de gemeente worden ingesteld en daarna opgeslagen. Dus een éénmalige actie!"]
[null,"-","Tevens kan door scrollen de aard van de werkzaamheden worden ingesteld."]
[null,"-","Door beide scrollbeweging uit te voeren worden de bij u gemeente  behorende tarieven ingesteld."]
[]
[null,null,"Samenvatting:"]
[]
[null,null,"Dit \"Rekenblad\" is een uitgave van de Vereniging van Nederlandse Gemeenten en is gebaseerd op:"]
[null,null,"\"RICHTLIJN tarieven (graaf) werkzaamheden Telecom\", uitgegeven: 12 maart 2004. "]
[]
[null,null,"Richtlijn voor gemeenten en aanbieders van telecom diensten ten behoeve van het berekenen van tarieven voor herstel, onderhoud, beheer- en "]
[null,null,"degeneratiekosten bij (graaf)werkzaamheden door aanbieders, in openbare gronden die in eigendom of beheer zijn van gemeenten."]
[]
[null,"-","De Richtlijn bevat: ",null,"definities, rekenmethodiek en tarieven"]
[]
[null,"-","In de tarieven wordt geen onderscheid gemaakt tussen lasgaten en sleuven. Alle werkzaamheden worden berekend per vierkante meter."]
[null,null,"De degeneratie vergoeding wordt verrekend per strekkende meter."]
[null,"-","Bij de berekening van de degeneratie vergoeding wordt gebruik gemaakt van de per 1 januari 2001 gehanteerde berekenwijze voor de"]
[null,null,"maatstaf bodemgesteldheid ten behoeve van de algemene uitkering uit het gemeentefonds. De bodempercentages t.g.v. samenvoegingen van gemeenten"]
[null,null,"zijn berekend tot 1 januari 2009"]
[null,"-","De wijze van de sleufbreedte is als volgt gedefinieerd:"]
[null,null,null,"- de werkelijke sleufbreedte, deze wordt tijdens de uitvoering gemeten"]
[null,null,null,"* de werkelijke sleufbreedte wordt ingevoerd in het rekenblad"]
[null,null,null,"* het rekenblad berekent de gatvergroting ( tegels, klinkers aan beide zijden van de sleuf )"]
[null,null,null,"* de gatvergroting wordt niet in oppervlak uitgedrukt maar is 20% van de uitvoeringskosten "]
[null,null,null,"Geen sleufbreedte gemeten  "]
[null,null,null,"- de gemiddelde breedte van het grondverzet, gemeten als breedte van de toegepaste graafbak, naar boven afgerond op 5 cm, "]
[null,null,null,"- met een minimum breedte voor tegelverharding van 30 cm en voor klinkerverharding van 20 cm."]
[null,"-","In de \"Richtlijn\" is aangegeven wanneer de sleuf door de aanbieder moet worden gedicht en onder welke voorwaarden dit is toegestaan."]
[null,"-","De werkzaamheden die de gemeente verricht en waarvoor bij het verlenen van het instemmingbesluit leges worden geheven, vallen niet"]
[null,null,"onder de berekening van de beheerskosten in deze \"Richtlijn\"."]
[null,"-","In de rekenmethodiek van de \"Richtlijn\"zijn nu ook groenvoorzieningen opgenomen."]
[null,"-","De \"Richtlijn\"bevat nu ook een degeneratievergoeding voor  tegelverharding."]
[null,"-","Voor gefundeerde verharding en voor groenvoorzieningen wordt geen degeneratievergoeding berekend."]
[null,"-","De \"Richtlijn\"is van toepassing op het herstel van opgebroken bestrating."]
[null,"-","Voor gesloten verhardingen zoals afalt, cemenbeton, grootschalige en kleinschalige verhardings elementen, plantsoenen en bomen, "]
[null,null,"dienen tussen de gemeente en de aanbieder op projektniveau, of zo mogelijk generiek, afspraken te worden gemaakt. Voor de verrekening"]
[null,null,"kan het \"rekenblad\" worden gebruikt."]
[null,"-","Op de tarieven is indexering van toepassing. Jaarlijks zal door de VNG een geïndexeerd \"Rekenblad\" tijdig ter beschikking worden gesteld."]
[]
[null,null,"Toepassing:"]
[null,"-","De VNG en een representatieve vertegenwoordiging van de Telcomsector hebben als: \"Packed deal\"overeenstemming bereikt over de rekenmethodiek"]
[null,null,"en de tarieven van de \"Richtlijn\", die integraal behoort te worden toegepast."]
[]
[null,null,"Aanvullende Informatie:"]
[null,null,"Nadere uitleg n.a.v. vragen uit het land:"]
[]
[null,null,"1. Vraag: waarom is het bermtarief van 1 m2 t/m 50 m2 altijd circa 100 € ?"]
[null,null,"Antwoord: het voorrijtarief van de cultuurtechnische medewerker is 100 €."]
[null,null,"Boven de 50 m2 wordt het bermtarief per m2 berekend. Het is ook mogelijk geen gebruik te maken van dit tarief."]
[null,null,"2.  Vraag: wat mag je bij elkaar rekenen?"]
[null,null,"Antwoord: Per project is het aantal m2 bepalend voor de toepassing van tarief <15 m2 of >15 m2."]
[null,null,"Daarbij mogen tegel- en klinkeroppervlakken niet bij elkaar opgeteld worden."]
[null,null,"Meerdere kleine opbrekingen binnen 10 m (zoals huisaansluitingen) worden aangemerkt als één reparatie."]