{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Rekenblad","Gemeenten met categorie","INFO","Tabel Tarieven"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":10,"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":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[35,13,36,13],[32,0,32,1],[32,9,32,10],[28,5,28,7],[28,8,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[31,0,31,1],[33,2,34,13],[30,0,30,1],[29,0,29,1],[35,6,35,7],[35,4,35,5],[35,9,35,12],[0,0,0,8],[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],[12,1,12,2],[11,3,11,4],[14,3,14,4],[5,5,5,9],[11,5,11,6],[2,1,2,3],[2,5,2,9],[18,5,18,6],[20,2,20,7],[18,3,18,4],[24,0,24,1],[19,0,19,4],[20,0,20,1],[22,0,22,1],[21,0,21,1],[23,0,23,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],[15,3,15,4],[16,3,17,4],[16,0,16,1],[26,0,26,1],[21,2,22,4],[25,0,25,1],[28,2,28,4],[23,9,23,10],[25,9,25,10],[26,9,26,10],[24,9,24,10],[27,9,27,10],[21,8,22,8],[21,9,22,10],[27,0,27,1],[21,5,22,7],[5,12,5,13],[20,11,20,13],[14,7,17,11],[18,12,18,13],[16,12,17,13],[20,8,20,10],[18,7,18,11],[0,12,0,13],[9,3,9,6],[13,3,13,4],[10,3,10,4],[10,5,10,6],[4,10,4,11],[10,7,13,11],[12,3,12,4],[4,1,4,9],[3,11,3,13],[2,10,2,11],[3,8,3,9],[3,1,3,6],[2,12,2,13],[4,12,4,13],[9,12,9,13]]}
[{"$f":"\"Melding en berekening straatwerk\" & MID('Tabel Tarieven'!K1,10,5)","v":"Melding en berekening straatwerk 2020"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Versie \"&MID('Tabel Tarieven'!K1,11,8)","v":"Versie 2020 v1 "}]
["volgens de Richtlijn Tarieven (graaf) werkzaamheden Telecom dd 12-03-2004.",null,null,null,null,null,null,null,null,null,null,"Datum:",{"$f":"NOW()","v":"2020-12-08T16:36:41.700"}]
["AANVRAGER:","……………………………….",null,null,"Adres:","……………………………………………………………………",null,null,null,null,"Contactpersoon:",null,"…………………………………"]
["NAAM PROJECT:","…………………………………………………………………………………………………..",null,null,null,null,null,"Ref.nr:","…………………………………………………………………………………………………..",null,"E-mail:","…………..……………………………………."]
["PLAATS:","…………………………………………………………………………………………………..",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:D484,4),\"\")","v":"  Postbus 93,  9460 AB  GIETEN"},null,null,null,null,null,"Mobiel:","…………………………………"]
[null,1,null,{"$f":"IF($B$7>0.1,VLOOKUP($B$7,'Gemeenten met categorie'!A2:D493,3),\"\")","v":1}]
["Uitvoering:"]
[1,null,null,null,null,null,null,null,null,null,null,null,"  "]
["Gemeentelijke gegevens:",null,null,"Verzamelde informatie:",null,null,null,"Toegepast tarief",null,null,null,null,"Bedrag:"]
["Contactpersoon gem.:","………………………",null,"Inkoopordernr.:",null,"Projectnr:",null,{"$f":"INDEX('Gemeenten met categorie'!D499:D504,A9,1)","v":"Tarief A:  Herstel en onderhoud uitgevoerd door de gemeente"},null,null,null,null,"Uitv.k",{"$f":"SUM(J38:J51)","v":0}]
["E-mail:","………………………",null,"………………",null,"…………….",null,null,null,null,null,null,"Onderh.k",{"$f":"SUM(K38:K51)","v":0}]
["telefoon:","………………………",null,"Datum opbreking:",null,"………………..",null,null,null,null,null,null,"Deg.kst.",{"$f":"SUM(L38:L51)","v":0}]
["mobiel:","………………………",null,"Datum herstel:",null,"………………..",null,null,null,null,null,null,"Beheer.k",{"$f":"SUM(M38:M51)","v":0}]
["Opdrachtnummer :","………………………",null,"Deellevering:",null,"………………..",null,{"$f":"INDEX('Gemeenten met categorie'!D499:F504,A9,2)","v":0},null,null,null,null,"Bomen/str",{"$f":"N28","v":0}]
["In te vullen gegevens:",null,null,"Laatste levering:",null,"………………..",null,null,null,null,null,null,"Asfalt",{"$f":"N33","v":0}]
["= Richtlijn tarief",null,null,"Uitvoerende aannemer:",null,"……………….."]
["= Af te spreken projectprijs",null,null,null,null,"…………………"]
[null,null,null,null,null,"…………………",null,"Totaal kosten:  ",null,null,null,null,{"$f":"+SUM(N11:N17)","v":0}]
["OMSCHRIJVING STRAATWERK / BERMEN;",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND(SUM(N38:N51),2)-ROUND(M19,2)<>0,\"Fout in formulier\",\"\")","v":""}]
[{"$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,"Sleuf",null,null,null,null,null,"Opsluiting",null,null,"Bomen en Struiken"]
[{"$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:","opsluit- / koprolband "]
[]
["adres",null,"lengte","breedte","m2","lengte","breedte","m2","m1","m1",null,"eenh.","prijs ","kosten"]
["………………………………….",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,null,null,{"$f":"IF($L25>0,$M25*($L25+0),\"\")","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,null,null,{"$f":"IF($L26>0,$M26*($L26+0),\"\")","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,null,null,null,{"$f":"IF($L27>0,$M27*($L27+0),\"\")","v":""}]
[null,null,{"$f":"MAX(C25:D25)+MAX(C26:D26)+MAX(C27:D27)","v":0},null,{"$f":"SUM(E25:E27)","v":0},{"$f":"MAX(F25:G25)+MAX(F26:G26)+MAX(F27:G27)","v":0},null,{"$f":"SUM(H25:H27)","v":0},{"$f":"SUM(I25:I27)","v":0},{"$f":"SUM(J25:K27)","v":0},null,{"$f":"SUM(L25:L27)","v":0},null,{"$f":"SUM(N25:N27)","v":0}]
[null,null,"Bermen, gazon herstel door gemeente",null,null,"Bermen, gazon herstel door aanbieder",null,null,"Asfalt, all in*",null,null,"Dikte","Prijs","Asfalt"]
["adres",null,"lengte","breedte","m2","lengte","breedte","m2","lengte (m)","breedte (m)",null,"cm","m2/cm","kosten"]
["…………………………………",null,null,null,{"$f":"IF(C31>0,C31*(D31+0),\"\")","v":""},null,null,{"$f":"IF(F31>0,F31*(G31+0),\"\")","v":""},null,null,null,null,null,{"$f":"IF($I31>0,($I$31*$J$31*$L$31)*($M$31),\"\")","v":""}]
["…………………………………",null,null,null,{"$f":"IF(C32>0,C32*(D32+0),\"\")","v":""},null,null,{"$f":"IF(F32>0,F32*(G32+0),\"\")","v":""},null,null,null,null,null,{"$f":"IF($I32>0,($I$32*$J$32*$L$32)*($M$32),\"\")","v":""}]
[null,null,null,null,{"$f":"SUM(E31:E32)","v":0},null,null,{"$f":"SUM(H30:H32)","v":0},{"$f":"SUM(I30:I32)","v":0},{"$f":"SUM(J30:K32)","v":0},null,null,null,{"$f":"SUM(N31:N32)","v":0}]
["Specificatie:",null,"* de gedefinieerde sleufbreedte dient te worden aangegeven, voor netbeheerders (niet zijnde aanbieders volgens Telecommunicatiewet) geldt de (gemiddelde) breedte van de opgebroken bestrating. In de tarieven is de gatvergroting meegerekend door een toeslag van 20%."]
["Tarief:",{"$f":"A9","v":1}]
["Categorie:",{"$f":"VLOOKUP(B7,'Gemeenten met categorie'!$A$3:$C$393,3,FALSE)","v":1},null,null,"Kosten per eenheid",null,"Degeneratiekosten",null,"Beheerk.","Subtotaal",null,null,null,"Totaal regel"]
["Omschrijving","Hoeveelheid","Eenheid","Sleuf m1","Uitv.kst","Onderh.k","Per rep.","Per m1","per eenheid","Uitv.k.","Onderh.k","Deg.kst.","Beheer.k"]
["klinkers <= 15 m2",{"$f":"IF($H$28<=15,$H$28,0)","v":0},"m2",null,{"$f":"IF($B$38>0,'Tabel Tarieven'!$R6,0)","v":0},{"$f":"IF($B38>0,'Tabel Tarieven'!$R22,0)","v":0},{"$f":"IF($B38>0,'Tabel Tarieven'!$R28,0)","v":0},null,{"$f":"IF($B38>0,'Tabel Tarieven'!$R34,0)","v":0},{"$f":"E38*B38","v":0},{"$f":"F38*B38","v":0},{"$f":"G38","v":0},{"$f":"I38*B38","v":0},{"$f":"+SUM(J38:M38)","v":0}]
["klinkers >15 m2",{"$f":"IF($H$28>15,IF($B$35=1,IF($H$28<=100,$H$28,0),$H$28),0)","v":0},"m2",{"$f":"IF(B39>0,$F$28,0)","v":0},{"$f":"IF(B39>0,'Tabel Tarieven'!$R7,0)","v":0},{"$f":"IF($B39>0,'Tabel Tarieven'!$R23,0)","v":0},null,{"$f":"IF($B39>0,'Tabel Tarieven'!$R29,0)","v":0},{"$f":"IF($B39>0,'Tabel Tarieven'!$R35,0)","v":0},{"$f":"E39*B39","v":0},{"$f":"F39*B39","v":0},{"$f":"H39*D39","v":0},{"$f":"I39*B39","v":0},{"$f":"+SUM(J39:M39)","v":0}]
["klinkers  >100 m2 (alleen A)",{"$f":"IF($B$35=1,IF($H$28>100,$H$28,0),0)","v":0},"m2",{"$f":"IF(B40>0,$F$28,0)","v":0},{"$f":"IF(B40>0,'Tabel Tarieven'!$R8,0)","v":0},{"$f":"IF($B40>0,'Tabel Tarieven'!$R24,0)","v":0},null,{"$f":"IF($B40>0,'Tabel Tarieven'!$R30,0)","v":0},{"$f":"IF($B40>0,'Tabel Tarieven'!$R36,0)","v":0},0,0,{"$f":"H40*D40","v":0},0,0]
["tegels   <= 15 m2",{"$f":"IF($E$28<=15,$E$28,0)","v":0},"m2",null,{"$f":"IF(B41>0,'Tabel Tarieven'!$R9,0)","v":0},{"$f":"IF($B41>0,'Tabel Tarieven'!$R25,0)","v":0},{"$f":"IF($B41>0,'Tabel Tarieven'!$R31,0)","v":0},null,{"$f":"IF($B41>0,'Tabel Tarieven'!$R37,0)","v":0},0,0,{"$f":"G41","v":0},0,0]
["tegels   >15 m2",{"$f":"IF($E$28>15,IF($B$35=1,IF($E$28<=100,$E$28,0),$E$28),0)","v":0},"m2",{"$f":"IF(B42>0,$C$28,0)","v":0},{"$f":"IF(B42>0,'Tabel Tarieven'!$R10,0)","v":0},{"$f":"IF($B42>0,'Tabel Tarieven'!$R26,0)","v":0},null,{"$f":"IF($B42>0,'Tabel Tarieven'!$R32,0)","v":0},{"$f":"IF($B42>0,'Tabel Tarieven'!$R38,0)","v":0},0,0,{"$f":"H42*D42","v":0},0,0]
["tegels   >100 m2 (alleen A)",{"$f":"IF($B$35=1,IF($E$28>100,$E$28,0),0)","v":0},"m2",{"$f":"IF(B43>0,$C$28,0)","v":0},{"$f":"IF(B43>0,'Tabel Tarieven'!$R11,0)","v":0},{"$f":"IF($B43>0,'Tabel Tarieven'!$R27,0)","v":0},null,{"$f":"IF($B43>0,'Tabel Tarieven'!$R33,0)","v":0},{"$f":"IF($B43>0,'Tabel Tarieven'!$R39,0)","v":0},0,0,{"$f":"H43*D43","v":0},0,0]
["trottoirband",{"$f":"I28","v":0},"m1",null,{"$f":"IF($B44>0,'Tabel Tarieven'!$R12,0)","v":0},null,null,null,{"$f":"IF($B44>0,'Tabel Tarieven'!$R40,0)","v":0},0,null,null,0,0]
["opsluit/koprolband",{"$f":"J28","v":0},"m1",null,{"$f":"IF($B45>0,'Tabel Tarieven'!$R13,0)","v":0},null,null,null,{"$f":"IF($B45>0,'Tabel Tarieven'!$R41,0)","v":0},0,null,null,0,0]
["Berm/gaz, herst gem.<=15m2",{"$f":"IF(E33<=15,E33,0)","v":0},"reparatie",null,{"$f":"IF($B46>0,'Tabel Tarieven'!$R20,0)","v":0},null,null,null,{"$f":"IF($B46>0,'Tabel Tarieven'!R44,0)","v":0},{"$f":"IF(E46>0,E46,0)","v":0},null,null,{"$f":"IF(I46>0,I46,0)","v":0},0]
["Berm/gaz, herst aanb<=15m2",{"$f":"IF(H33<=15,H33,0)","v":0},"reparatie",null,null,null,null,null,{"$f":"IF($B47>0,'Tabel Tarieven'!R44,0)","v":0},null,null,null,{"$f":"IF(I47>0,I47,0)","v":0},0]
["Berm/gaz, herst gem. >15m2",{"$f":"IF(E33>15,E33,0)","v":0},"m2",null,{"$f":"IF($B48>0,'Tabel Tarieven'!$R21,0)","v":0},null,null,null,{"$f":"IF($B48>0,'Tabel Tarieven'!R45,0)","v":0},{"$f":"E48*B48","v":0},null,null,{"$f":"I48*B48","v":0},0]
["Berm/gaz, herst aanb. >15m2",{"$f":"IF(H33>15,H33,0)","v":0},"m2",null,null,null,null,null,{"$f":"IF($B49>0,'Tabel Tarieven'!R45,0)","v":0},0,null,null,0,0]
["Bomen en struiken",null,"St.",null,{"$f":"IF($B50>0,'Tabel Tarieven'!$R16,0)","v":0},null,null,null,{"$f":"IF($B50>0,'Tabel Tarieven'!R46,0)","v":0},null,null,null,{"$f":"I50*B50","v":0},{"$f":"N28","v":0}]
["Asfalt",{"$f":"(I31*J31)+I32*J32","v":0},"m2",null,{"$f":"IF($B51>0,'Tabel Tarieven'!$R17,0)","v":0},null,null,null,0,null,null,null,{"$f":"I51*B51","v":0},{"$f":"N33","v":0}]
[]
[]
["Naam en paraaf budgethouder:",null,{"$f":"M3","v":"…………………………………"},null,"d.d.",{"$f":"M2","v":"2020-12-08T16:36:41.700"},null,null,"Afgewerk d.d.","…………………………………………"]
[]
["Factuuradres:","………………………………………………………………………………………………………."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($A$9>1,$A$9<4,$E$28<=15),('Gemeenten met categorie'!#REF!),\"\")","v":""}]

{"sheet":"Gemeenten met categorie","index":1,"n_rows":504,"n_cols":6,"rows_kept":504,"cut":false,"hidden":false,"merged":[]}
[null,"De Gemeenten van Nederland per 01-01-2019"]
[null,"Gemeente:","Indeling:"]
[1,"Aa en Hunze",1,"  Postbus 93,  9460 AB  GIETEN"]
[2,"Aalsmeer",2,"  Postbus 253, 1430 AG  AALSMEER"]
[3,"Aalten",1,"  Postbus 119,  7120 AC  AALTEN"]
[4,"Achterkarspelen",1,"  Postbus 2,  9285 ZV  BUITENPOST"]
[5,"Alblasserdam",5,"  Postbus 2,  2950 AA  ALBLASSERDAM"]
[6,"Albrandswaard",2,"  Postbus 1000,  3160 GA  RHOON"]
[7,"Alkmaar",1,"  Postbus 53,  1800 BC  ALKMAAR"]
[8,"Almelo",1,"  Postbus 5100,  7600 GC  ALMELO"]
[9,"Almere",3,"  Postbus  200,  1300 AE  ALMERE"]
[10,"Alphen aan de Rijn",5,"  Postbus 13,  2400 AA  ALPHEN AAN DE RIJN"]
[11,"Alphen-Chaam",1,"  Postbus 3,  5130 AA  ALPHEN"]
[12,"Altena",1,"  Sportlaan 170,  4286 ET ALMKERK"]
[13,"Ameland",1,"  Postbus 22,  9160 AA  HOLLUM"]
[14,"Amersfoort",1,"  Postbus 4000,  3800 EA  AMERSFOORT"]
[15,"Amstelveen",5,"  Postbus 4,  1180 BA  AMSTELVEEN"]
[16,"Amsterdam",3,"  Postbus 202,  1000 AE  AMSTERDAM"]
[17,"Apeldoorn",1,"  Postbus 9033,  7300 ES  APELDOORN"]
[18,"Appingedam",5,"  Postbus 15,  9900 AA  APPINGEDAM"]
[19,"Arnhem",1,"  Postbus 9029, 6800 EL  ARNHEM"]
[20,"Assen",1,"  Postbus 30018,  9400 RA  ASSEN"]
[21,"Asten",1,"  Postbus 290,  5720 AG  ASTEN"]
[22,"Baarle-Nassau",1,"  Postbus 105,  5110 AC  BAARLE-NASSAU"]
[23,"Baarn",1,"  Postbus 1003,  3740 BA  BAARN"]
[24,"Barendrecht",5,"  Postbus 501,  2990 EA  BARENDRECHT"]
[25,"Barneveld",1,"  Postbus 63,  3770 AB  BARNEVELD"]
[26,"Beek",1,"  Postbus 20,  6190 AA  BEEK"]
[27,"Beekdaelen",1,"  Postbus 22000,  6360 AA NUTH"]
[28,"Beemster",4,"  Postbus 7,  1462 ZG  MIDDENBEEMSTER"]
[29,"Beesel",1,"  Postbus 4750,  5953 ZK  REUVER"]
[30,"Berg en Dal ",1,"  Postbus 20, 6560 AA GROESBEEK"]
[31,"Bergeijk",1,"  Postbus 10000,  5570 GA  BERGEIJK"]
[32,"Bergen (L.)",1,"  Postbus 140,  5854 ZJ  BERGEN (L.)"]
[33,"Bergen (NH.)",1,"  Postbus 175,  1860 AD  BERGEN (NH.)"]
[34,"Bergen op Zoom",1,"  Postbus 35,  4600 AA  BERGEN OP ZOOM"]
[35,"Berkelland",1,"  Postbus 200, 7270 HA BORCULO"]
[36,"Bernheze",1,"  Postbus 19,  5384 ZG  HEESH"]
[37,"Best",1,"  Postbus 50,  5680 AB  BEST"]
[38,"Beuningen",1,"  Postbus 14,  6640 AA  BEUNINGEN"]
[39,"Beverwijk",1,"  Postbus 450,  1940 AL  BEVERWIJK "]
[40,"Bladel",1,"  Postbus 11,  5530 AA BLADEL"]
[41,"Blaricum",1,"  Postbus 125,  1260 AC  BLARICUM"]
[42,"Bloemendaal",1,"  Postbus 201,  2050 AE  OVERVEEN"]
[43,"Bodegraven-Reeuwijk",5,"  Postbus 401,  2410 AK  BODEGRAVEN"]
[44,"Boekel",1,"  Postbus 99,  5427 ZH  BOEKEL"]
[45,"Borger-Odoorn",1,"  Postbus 3,  7875 ZG  EXLOO"]
[46,"Borne",1,"  Postbus 200, 7620 AE  BORNE"]
[47,"Borsele",1,"  Postbus 1,  4450 AA  HEINKENSZAND"]
[48,"Boxmeer",1,"  Postbus 450,  5830 AL  BOXMEER"]
[49,"Boxtel",1,"  Postbus 10000,  5280 DA  BOXTEL"]
[50,"Breda",1,"  Postbus 90156,  4800 RH  BREDA"]
[51,"Brielle",1,"  Postbus 101,  3230 AC  BRIELLE"]
[52,"Bronckhorst",1,"  Postbus 200, 7255 ZJ HENGELO"]
[53,"Brummen",1,"  Postbus 5,  6970 BV  BRUMMEN"]
[54,"Brunssum",1,"  Postbus 250,  6440 AG  BRUNSSUM"]
[55,"Bunnik",1,"  Postbus 5,  3980 CA  BUNNINK"]
[56,"Bunschoten",1,"  Postbus 200,  3750 GE  BUNSCHOTEN"]
[57,"Buren",1,"  Postbus 15,  4033 ZG  LIENDEN"]
[58,"Capelle aan den IJssel",5,"  Postbus 70,  2900 AB CAPELLE AAN DE IJSSEL"]
[59,"Castircum",1,"  Postbus 1301,  1900 BH  CASTRICUM"]
[60,"Coevorden",1,"  Postbus 2, 7740 AA  COEVORDEN"]
[61,"Cranendonck",1,"  Postbus 2090,  6020 AB  BUDEL"]
[62,"Cuijk",1,"  Postbus 10001,  5430 DA  CUIJK"]
[63,"Culemborg",3,"  Postbus 136,  4100 AC  CULEMBERG"]
[64,"Dalfsen",1,"  Postbus 35, 7720 AA  DALSEN"]
[65,"Dantumadeel",1,"  Postbus 22,  9104 BR  DAMWOUDE"]
[66,"De Bilt",1,"  Postbus 300,  3720 AH  BILTHOVEN"]
[67,"De Fryske Marren",1,"  Postbus 101,  8500 AC JOURE"]
[68,"De Ronde Venen",2,"  Postbus 250,  3640 AG MIJDRECHT"]
[69,"De Wolden",1,"  Postbus 20,  7920 AA  ZUIDWOLDE"]
[70,"Delft",4,"  Postbus 78,  2600 ME  DELFT"]
[71,"Delfzijl",3,"  Postbus 20000,  9930 PA  DELFZIJL"]
[72,"Den Haag",1,"  Postbus 12600,  2500 DJ  DEN HAAG"]
[73,"Den Helder",1,"  Postbus 36,  1780 AA  DEN  HELDER"]
[74,"Deurne",1,"  Postbus 3,  5750 AA  DEURNE"]
[75,"Deventer",1,"  Postbus 5000, 7400GC  DEVENTER"]
[76,"Diemen",5,"  Postbus 191,  1110 AD  DIEMEN"]
[77,"Dinkelland",1,"  Postbus 11,  7590 AA  DENEKAMP"]
[78,"Doesburg",1,"  Postbus 100,  6980 AC  DOESBURG"]
[79,"Doetinchem",1,"  Postbus 9020,  7000 HA  DOETINCHEM"]
[80,"Dongen",1,"  Postbus 10153,  5100 GE  DONGEN"]
[81,"Dordrecht",1,"  Postbus 8,  3300 AA  DORDRECHT"]
[82,"Drechterland",4,"  Postbus 9, 1616 ZG HOOGKARSPEL"]
[83,"Drimmelen",1,"  Postbus 19, 4920 AA  MADE"]
[84,"Dronten",1,"  Postbus 100,  8250 AC  DRONTEN"]
[85,"Druten",1,"  Postbus 1,  6650 AA  DRUTEN"]
[86,"Duiven",1,"  Postbus 6,  6920 AA  DUIVEN"]
[87,"Echt-Susteren",1,"  Postbus 450,  6100 AL  ECHT"]
[88,"Edam-Volendam",5,"  Postbus 180, 1130 AD  VOLENDAM"]
[89,"Ede",1,"  Postbus 9022,  6710 HK  EDE"]
[90,"Eemnes",1,"  Postbus 71,  3755 AN  EEMNES"]
[91,"Eersel",1,"  Postbus 12,  5520 AA  EERSEL"]
[92,"Eijsden-Margraten",1,"  Postbus 10, 6269 ZG MARGRATEN"]
[93,"Eindhoven",1,"  Postbus 90150,  5600 RB  EINDHOVEN"]
[94,"Elburg",1,"  Postbus 70,  8080 AB  ELBURG"]
[95,"Emmen",1,"  Postbus 3001,  7800 AA  EMMEN"]
[96,"Enkhuizen",4,"  Postbus 11,  1600 AA  ENKHUIZEN"]
[97,"Enschede",1,"  Postbus 20, 7500 AA  ENSCHEDE"]
[98,"Epe",1,"  Postbus 600,  8160 AP  EPE"]
[99,"Ermelo",1,"  Postbus 500, 3850 AM  ERMELO"]
[100,"Etten-Leur",1,"  Postbus 10100,  4870 GA  ETTEN-LEUR"]
[101,"Geertruidenberg",1,"  Postbus 10001,  4940 GA  RAAMSDONKSVEER"]
[102,"Geldrop-Mierlo",1,"  Postbus 10101, 5660 GA  GELDROP"]
[103,"Gemert-Bakel",1,"  Postbus 10000,  5420 DA  GEMERT"]
[104,"Gennep",1,"  Postbus 9003,  6590 HD  GENNEP"]
[105,"Gilze en Rijen",1,"  Postbus 73, 5120 AB  RIJEN"]
[106,"Goeree-Overflakkee",1,"  Postbus 1, 3240 AA MIDDELHARNIS"]
[107,"Goes",1,"  Postbus 2118,  4460 MC  GOES"]
[108,"Goirle",1,"  Postbus 17,  5050 AA  GOIRLE"]
[109,"Gooise Meren",1,"  Postbus 6000, 1400 HA BUSSUM"]
[110,"Gorichem",5,"  Postbus 108,  4200 AC  GORINCHEM"]
[111,"Gouda",5,"  Postbus 1086,  2800 BB  GOUDA"]
[112,"Grave",1,"  Postbus 7,  5360 AA  GRAVE"]
[113,"Groningen",1,"  Postbus 2001, 9700 PB  GRONINGEN"]
[114,"Gulpen-Wittem",1,"  Postbus 56,  6270 AB  GULPEN"]
[115,"Haaksbergen",1,"  Postbus 102,  7480 AC  HAAKSBERGEN"]
[116,"Haaren",1,"  Postbus 44,  5076 ZG  HAAREN"]
[117,"Haarlem",1,"  Postbus 511,  2003 PB  HAARLEM"]
[118,"Haarlemmermeer",2,"  Postbus 250,  2130 AG  HOOFDDORP"]
[119,"Halderberge",1,"  Postbus 5,  4730 AA  OUDENBOSCH"]
[120,"Hardenberg",1,"  Postbus 500,  7770 BA  HARDENBERG"]
[121,"Harderwijk",1,"  Postbus 149,  3840 AC  HARDERWIJK"]
[122,"Hardinxveld-Giessendam",5,"  Postbus 175,  3370 AD  HARDINXVELD-GIESSENDAM"]
[123,"Harlingen",1,"  Postbus 10000,  8860 HA  HARLINGEN"]
[124,"Hattem",1,"  Postbus 93,  8050 AB  HATTUM"]
[125,"Heemskerk",1,"  Postbus 39,  1960 AA  HEEMSKERK"]
[126,"Heemstede",1,"  Postbus 352,  2100 AJ HEEMSTEDE"]
[127,"Heerde",1,"  Postbus 175,  8180 AD  HEERDE"]
[128,"Heerenveen",1,"  Postbus 15000,  8440 GA HEERENVEEN"]
[129,"Heerhugowaard",1,"  Postbus 390,  1700 AJ  HEERHUGOWAARD"]
[130,"Heerlen",1,"  Postbus 1,  6400 AA  HEERLEN"]
[131,"Heeze-Leende",1,"  Postbus 10000,  5590 GA  HEEZE"]
[132,"Heiloo",1,"  Postbus 1,  1850 AA  HEILOO "]
[133,"Hellendoorn",1,"  Postbus 200, 7440 AE  NIJVERDAL"]
[134,"Hellevoetsluis",1,"  Postbus 13,  3220 AA  HELLEVOETSLUIS"]
[135,"Helmond",1,"  Postbus 950,  5700 AZ  HELMOND"]
[136,"Hendrik-Ido-Ambacht",4,"  Postbus 34,  3340 AA  HENDRIK-IDO-AMBACHT"]
[137,"Hengelo (O.)",1,"  Postbus 18, 7550 AA  HENGELO"]
[138,"Heumen",1,"  Postbus 200,  6800 AZ  MALDEN"]
[139,"Heusden",1,"  Postbus 31,  5250 AA  VLIJMEN"]
[140,"Hillegom",1,"  Postbus 32,  2180 AA  HILLEGOM"]
[141,"Hilvarenbeek",1,"  Postbus 3,  5080 AA  HILVARENBEEK"]
[142,"Hilversum",1,"  Postbus 9900,  12101 GM  HILVERSUM"]
[143,"Hoeksche Waard",2,"  Postbus 2003,  3260 EA OUD-BEIJERLAND"]
[144,"Hof van Twente",1,"  Postbus 54,  7470 AB  GOOR"]
[145,"Het Hogeland",1,"  Postbus 26,  9980 AA  UITHUIZEN"]
[146,"Hollands Kroon",1,"  Postbus 8, 1760 AA ANNA PAULOWNA"]
[147,"Hoogeveen",1,"  Postbus 20000,  7900 PA  HOOGEVEEN"]
[148,"Hoorn",5,"  Postbus 603,  1620 AR  HOORN"]
[149,"Horst aan de Maas",1,"  Postbus 6005,  5960 AA  HORST"]
[150,"Houten",1,"  Postbus 30,  3990 DA  HOUTEN"]
[151,"Huizen",1,"  Postbus 5,  1270 AA  HUIZEN"]
[152,"Hulst",1,"  Postbus 49,  4560 AA  HULST"]
[153,"IJsselstein",1,"  Postbus 26, 3400 AA  IJSSELSTEIN"]
[154,"Kaag en Braassem",3,"  Postbus 1, 2370 AA ROELOFARENDSVEEN"]
[155,"Kampen",1,"  Postbus 5009,  8260 GA  KAMPEN"]
[156,"Kapelle",1,"  Postbus 79,  4420 AC  KAPELLE"]
[157,"Katwijk",1,"  Postbus 589,  2220 AN  KATWIJK"]
[158,"Kerkrade",1,"  Postbus 600, 6460 AP  KERKRADE"]
[159,"Koggenland",5,"  Postbus 21 1633 ZG AVENHORN"]
[160,"Krimpen aan den IJssel",5,"  Postbus 200,  2922 AE  KRIMPEN AAN DE IJSSEL"]
[161,"Krimpenerwaard",5,"  Postbus 51, 2820 AB STOLWIJK"]
[162,"Laarbeek",1,"  Postbus 190,  5740 AD  BEEK EN DONK"]
[163,"Landerd",1,"  Postbus 35, 5410 AA  ZEELAND"]
[164,"Landgraaf",1,"  Postbus 31000,  6370 AA  LANDGRAAF"]
[165,"Landsmeer",5,"  Postbus 1,  1120 AA  LANDSMEER"]
[166,"Langedijk",1,"  Postbus 15,  1723 ZG  NOORD-SCHARWOUDE"]
[167,"Lansingerland",5,"  Postbus 1,  2650 AA  BERKEL & RODENRIJS"]
[168,"Laren",1,"  Postbus 5,  1250 AA  LAREN"]
[169,"Leeuwarden",1,"  Postbus 21000,  8900 JA  LEEUWARDEN"]
[170,"Leiden",1,"  Postbus 9100,  2300 PC  LEIDEN"]
[171,"Leiderdorp",3,"  Postbus 35,  2353 AA  LEIDERDORP"]
[172,"Leidschendam-Voorburg",1,"  Postbus 905,  2270 AX  VOORBURG"]
[173,"Lelystad",1,"  Postbus 91,  8200 AB  LELYSTAD"]
[174,"Leudal",1,"  Postbus 3008, 6093 ZG HEYTHUYSEN"]
[175,"Leusden",1,"  Postbus 150,  3830 AD  LEUSDEN"]
[176,"Lingewaard",1,"  Postbus 15,  6680 AA  BEMMEL"]
[177,"Lisse",1,"  Postbus 200,  2160 AE  LISSE"]
[178,"Lochem",1,"  Postbus 17,  7240 AA  LOCHEM"]
[179,"Loon op Zand",1,"  Postbus 7,  5170 AA  KAATSHEUVEL"]
[180,"Lopik",4,"  Postbus 50,  3410 CB  LOPIK"]
[181,"Loppersum",3,"  Postbus 25,  9919 ZG  LOPPERSUM"]
[182,"Losser",1,"  Postbus 90,  7580 AB  LOSSER"]
[183,"Maasdriel",1,"  Postbus 10000,  5330 GA  KERKDRIEL"]
[184,"Maasgouw",1,"  Postbus 7000,  6050 AA MAASBRACHT"]
[185,"Maassluis",3,"  Postbus 55,  3140 AB  MAASSLUIS"]
[186,"Maastricht",1,"  Postbus 1992,  6201 BZ  MAASTRICHT"]
[187,"Medemblik",5,"  Postbus 7,  1670 AA  MEDEMBLIK"]
[188,"Meerssen",1,"  Postbus 90,  6230 AB  MEERSSEN"]
[189,"Meierijstad",1,"  Postbus 10.001, 5460 DA VEGHEL"]
[190,"Meppel",1,"  Postbus 501,  7940 AM  MEPPEL"]
[191,"Middelburg",1,"  Postbus 6000,  4330 LA  MIDDELBURG"]
[192,"Midden-Delftland",5,"  Postbus 1, 2636 ZG SCHIPLUIDEN"]
[193,"Midden-Drenthe",1,"  Postbus 24, 9410 AA  BEILEN"]
[194,"Midden-Groningen",1,"  Postbus 75, 9600 AB HOOGEZAND"]
[195,"Mill en Sint Hubert",1,"  Postbus 39,  5450 AA  MILL"]
[196,"Moerdijk",1,"  Postbus 4,  4760 AA  ZEVENBERGEN"]
[197,"Molenlanden",5,"  Postbus 5,  2970 AA  BLESKENSGRAAF"]
[198,"Montferland",1,"  Postbus 47,  6940 BA  DIDAM"]
[199,"Montfoort",2,"  Postbus 41,  3417 ZG  MONTFOORT"]
[200,"Mook en Middelaar",1,"  Postbus 200,  6585 ZK  MOOK"]
[201,"Neder-Betuwe",1,"  Postbus 20,  4043 ZG  OPHEUSDEN"]
[202,"Nederweert",1,"  Postbus 2728,  6030 AA  NEDERWEERT"]
[203,"Nieuwegein",1,"  Postbus 1,  3430 AA  NIEUWEGEIN"]
[204,"Nieuwkoop",3,"  Postbus 17,  2421 EB  NIEUWKOOP"]
[205,"Nijkerk",1,"  Postbus 1000,  3860 BA  NIJKERK"]
[206,"Nijmegen",1,"  Postbus 9105,  6500 HG  NIJMEGEN"]
[207,"Nissewaard",3,"  Postbus 25, 3200 AA SPIJKENISSE"]
[208,"Noardeast-Fryslan",1,"  Postbus 13,  9290 AA  KOLLUM"]
[209,"Noord-Beveland",1,"  Postbus 3,  4490 AA  WIISENKERKE"]
[210,"Noordenveld",1,"  Postbus 109,  9300 AC  RODEN"]
[211,"Noordoostpolder",1,"  Postbus 155,  8300 AD EMMELOORD"]
[212,"Noordwijk",1,"  Postbus 298,  2200 AG  NOORDWIJK"]
[213,"Nuenen, Gerwen en Nederwetten",1,"  Postbus 10000,  5670 GA  NUENEN"]
[214,"Nunspeet",1,"  Postbus 79,  8070 AB  NUNSPEET"]
[215,"Oestgeest",1,"  Postbus 1270,  2340 BG  OEGSTGEEST"]
[216,"Oirschot",1,"  Postbus 11,  5688 ZG  OIRSCHOT"]
[217,"Oisterwijk",1,"  Postbus 10101,  5060 GA  OISTERWIJK"]
[218,"Oldambt",1,"  Postbus 175,  9670 AD  WINSCHOTEN"]
[219,"Oldebroek",1,"  Postbus 2,  8096 ZG  OLDENBROEK"]
[220,"Oldenzaal",1,"  Postbus 354,  7570 AJ  OLDENZAAL"]
[221,"Olst-Wijhe",1,"  Postbus 16,  8120 AA  OLST"]
[222,"Ommen",1,"  Postbus 100,  7730 AC  OMMEN"]
[223,"Oost Gelre",1,"  Postbus 17, 7130 AA LICHTENVOORDE"]
[224,"Oosterhout",1,"  Postbus 10150,  4900 GB  OOSTERHOUT"]
[225,"Ooststellingwerf",1,"  Postbus 38,  8430 AA  OOSTERWOLDE"]
[226,"Oostzaan",4,"  Postbus 15,  1510 AA  OOSTZAAN"]
[227,"Opmeer",3,"  Postbus 199,  1715 ZK  SPANBROEK"]
[228,"Opsterland",1,"  Postbus 10000,  9244 ZP  BEESTERZWAAG"]
[229,"Oss",1,"  Postbus 5,  5340 BA  OSS"]
[230,"Oude-IJsselstreek",1,"  Postbus 42,  7980 AA GENDERINGEN"]
[231,"Ouder-Amstel",5,"  Postbus 35,  1190 AA OUDERKERK AAN DE AMSTEL"]
[232,"Oudewater",5,"  Postbus 100,  3420 DC  OUDEWATER"]
[233,"Overbetuwe",1,"  Postbus 11,  6660 AA  ELST"]
[234,"Papendrecht",5,"  Postbus 11,  3350 AA  PAPENDRECHT"]
[235,"Peel en Maas",1,"  Postbus 7088, 5980 AB PANNINGEN"]
[236,"Pekela",1,"  Postbus 20000,  9665 ZM  OUDE PEKELA"]
[237,"Pijnakker-Nootdorp",5,"  Postbus 1, 2640 AA  PIJNACKER"]
[238,"Purmerend",3,"  Postbus 15,  1440 AA  PURMEREND"]
[239,"Putten",1,"  Postbus 400,  3880 AK  PUTTEN"]
[240,"Raalte",1,"  Postbus 140,  8100 AC  RAALTE"]
[241,"Reimerswaal",1,"  Postbus 70,  4416 ZH  KRUININGEN"]
[242,"Renkum",1,"  Postbus 9100,  6860 HA  OOSTERBEEK"]
[243,"Renswoude",1,"  Postbus 8,  3927 ZL  RENSWOUDE"]
[244,"Reusel-De Mierden",1,"  Postbus 11,  5540 AA REUSEL"]
[245,"Rheden",1,"  Postbus 9110,  6994 ZJ  DE STEEG"]
[246,"Rhenen",1,"  Postbus 201,  3910 AE  RHENEN"]
[247,"Ridderkerk",5,"  Postbus 271,  2980 AG  RIDDERKERK"]
[248,"Rijssen-Holten",1,"  Postbus 244, 7460 AE RIJSSEN"]
[249,"Rijswijk",1,"  Postbus 5305,  2280 HH  RIJSWIJK"]
[250,"Roerdalen",1,"  Postbus 6740,  6075 ZG  HERKENBOSCH"]
[251,"Roermond",1,"  Postbus900,  6040 AX  ROERMOND"]
[252,"Roosendaal",1,"  Postbus 5000,  4700 KA  ROOSENDAAL"]
[253,"Rotterdam",1,"  Postbus 70012,  3000 KP  ROTTERDAM"]
[254,"Rozendaal",1,"  Postbus 9106,  6880 HH VELP"]
[255,"Rucphen",1,"  Postbus 9,  4715 ZG  RUCPHEN"]
[256,"Schagen",2,"  Postbus 8,  1740 AA  SCHAGEN"]
[257,"Scherpenzeel",1,"  Postbus 100,  3925 ZJ  SCHERPENZEEL"]
[258,"Schiedam",5,"  Postbus 1501,  3100 EA  SCHIEDAM"]
[259,"Schiermonnikoog",1,"  Postbus 20,  9166 ZP  SCHIERMONNIKOOG"]
[260,"Schouwen-Duiveland",1,"  Postbus 5555,  4300 AJ  ZIERIKZEE"]
[261,"s-Gravenhage",1,"  Postbus 12600,  2500 DJ  's-GRAVENHAGE"]
[262,"s-Hertogenbosch ",1,"  Postbus 12345,  5200 GZ  's HERTOGENBOSCH"]
[263,"Simpelveld",1,"  Postbus 21000,  6369 ZG  SIMPELVELD"]
[264,"Sint Anthonis",1,"  Postbus 40,  5845 ZG  SINT ANTHOnIS"]
[265,"Sint-Michelsgestel",1,"  Postbus 10000, 5270 GA  SINT-MICHIELSGESTEL"]
[266,"Sittard-Geleen",1,"  Postbus 18,  6130 AA  SITTARD"]
[267,"Sliedrecht",5,"  Postbus 16,  3360 AA  SLIEDReCHT"]
[268,"Sluis",1,"  Postbus 27,  4500 AA  OOSTBURG"]
[269,"Smallingerland",1,"  Postbus 10000,  9200 HA  DRACHTEN"]
[270,"Soest",1,"  Postbus 2000,  3760 CA  SOEST"]
[271,"Someren",1,"  Postbus 290, 5710 AG  SOMEREN"]
[272,"Son en Breugel",1,"  Postbus 8,  5690  AA  SON"]
[273,"Stadskanaal",1,"  Postbus 140, 9500 AC  STADSKANAAL"]
[274,"Staphorst",1,"  Postbus 2,  7950 AA  STAPHORST"]
[275,"Stede Broec",4,"  Postbus 20,  1610 AA  BOVENKARSPEL"]
[276,"Steenbergen",1,"  Postbus 6,  4650 AA  STEENBERGEN"]
[277,"Steenwijkerland",1,"  Postbus 162,  8330 AD  STEENWIJK"]
[278,"Stein",1,"  Postbus 15, 6170 AA  STEIN"]
[279,"Stichtse Vecht",2,"  Postbus 1212, 3600 BE MAARSSEN "]
[280,"Sudwest Fryslan",1,"  Postbus 10000,  8600 HA  SNEEK"]
[281,"Terneuzen",1,"  Postbus 35,  4530 AA  TERNEUZEN"]
[282,"Terschelling",1,"  Postbus 14,  8880 AA  WEST-TERSCHELLING"]
[283,"Texel",1,"  Postbus 200, 1790 AE  DEN BURG"]
[284,"Teylingen",1,"  Postbus 149, 2215 VOORHOUT"]
[285,"Tholen",2,"  Postbus 51, 4690 AB THOLEN"]
[286,"Tiel",1,"  Postbus 6325, 4000 HH TIEL"]
[287,"Tilburg",1,"  Postbus 90155, 5000 LH TILBURG"]
[288,"Tubbergen",1,"  Postbus 30, 7650 AA TUBBERGEN"]
[289,"Twenterand",1,"  Postbus 67, 7670 AB  VRIEZENVEEN"]
[290,"Tynaarlo",1,"  Postbus 5,  9480 AA VRIES"]
[291,"Tytsjerksteradiel",1,"  Postbus 3,  9250 AA  BURGUM"]
[292,"Uden",1,"  Postbus 83,  5400 AB UDEN"]
[293,"Uitgeest",1,"  Postbus 7,  1910 AA  UITGEEST"]
[294,"Uithoorn",5,"  Postbus 8, 1420 AA  UITHOORN"]
[295,"Urk",1,"  Postbus 77,  8320 AB  URK"]
[296,"Utrecht",1,"  Postbus 16200,  3500 CE  UTRECHT"]
[297,"Utrechtse Heuvelrug",1,"  Postbus 200, 3940 AE DOORN"]
[298,"Vaals",1,"  Postbus 450,  6290 AL  VAALS"]
[299,"Valkenburg aan de Geul",1,"  Postbus 998, 6300 AZ  VALKENBURG AAN DE GEUL"]
[300,"Valkenswaard",1,"  Postbus 10100,  5550 GA  VALKENSWAARD"]
[301,"Veendam",1,"  Postbus 20004,  9640 PA  VEENDAM"]
[302,"Veenendaal",1,"  Postbus 1100,  3900 BC  VEENENDAAL"]
[303,"Veere",1,"  Postbus 1000, 4357 ZV  DOMBURG"]
[304,"Veldhoven",1,"  Postbus 10101,  5500 GA  VELDHOVEN"]
[305,"Velsen",1,"  Postbus 465, 1970 AL  IJMUIDEN"]
[306,"Venlo",1,"  Postbus 3434,  5902 RK  VENLO"]
[307,"Venray",1,"  Postbus 500,  5800 AM  VENRAY"]
[308,"Vijfheerenlanden",3,"  Postbus 11,  4140 AA  LEERDAM"]
[309,"Vlaardingen",5,"  Postbus 1002, 3130 EB VLAARDINGEN"]
[310,"Vlieland",1,"  Postbus 10,  8899 ZN  VLIELAND"]
[311,"Vlissingen",1,"  Postbus 3000,  4380 GV  VLISSINGEN"]
[312,"Voerendaal",1,"  Postbus 23000,  6367 ZG  VOERENDAAL"]
[313,"Voorschoten",1,"  Postbus 393,  2250 AJ  VOORSCOTEN"]
[314,"Voorst",1,"  Postbus 9000, 7390 HA  TWELLO"]
[315,"Vught",1,"  Postbus 10100,  5260 GA  VUGHT"]
[316,"Waadhoeke",1,"  Postbus 58, 8800 AB  FRANEKER"]
[317,"Waalre",1,"  Postbus 10000,  5580 GA  WAALRE"]
[318,"Waalwijk",1,"  Postbus 10150,  5140 GB  WAALWIJK"]
[319,"Waddinxveen",5,"  Postbus 400,  2740 AK  WADDINXVEEN"]
[320,"Wageningen",1,"  Postbus 1, 6700 AA  WAGENINGEN"]
[321,"Wassenaar",1,"  Postbus 499,  2240 AL  WASSENAAR"]
[322,"Waterland",5,"  Postbus 1000,  1140 BA  MONNICKENDAM"]
[323,"Weert",1,"  Postbus 950,  6000 AZ  WEERT"]
[324,"Weesp",1,"  Postbus 5099,  1380 GB  WEESP"]
[325,"West Betuwe",3,"  Postbus 112,  4190 CC  GELDERMALSEN"]
[326,"West Maas en Waal",1,"  Postbus 1,  6658  ZG BENEDEN-LEEUWEN"]
[327,"Westerveld",1,"  Postbus 50,  7970 AB  HAVELTE"]
[328,"Westervoort",1,"  Postbus 40,  6930 AA  WESTERVOORT"]
[329,"Westerwolde",1,"  Postbus 14,  9550 AA SELLINGEN"]
[330,"Westerkwartier",1,"  Postbus 100,  9350 AC  LEEK"]
[331,"Westland",1,"  Postbus 150,  2670 AD  NAALDWIJK"]
[332,"Weststellingwerf",1,"  Postbus 60,  8470 AB  WOLVEGA"]
[333,"Westvoorne",1,"  Postbus 550,  3235 ZH  ROCKANJE"]
[334,"Wierden",1,"  Postbus 43,  7640 AA  WIERDEN"]
[335,"Wijchen",1,"  Postbus 9000, 6600 HA  WIJCHEN"]
[336,"Wijdemeren",1,"  Postbus 41,  1243 ZG  's Graveland"]
[337,"Wijk bij Duurstede",1,"  Postbus 83,  3960 BB  WIJK BIJ DUURSTEDE"]
[338,"Winterswijk",1,"  Postbus 101,  7100 AC  WINTERSWIJK"]
[339,"Woensdrecht",1,"  Postbus 24,  4630 AA  HOOGERHEIDE"]
[340,"Woerden",4,"  Postbus 45,  3440 AA  WOERDEN"]
[341,"Wormerland",1,"  Postbus 20,  1530 AA  WORMER"]
[342,"Woudenberg",1,"  Postbus 16,  3930 EA  WOUDENBERG"]
[343,"Zaanstad",3,"  Postbus 2000,  1500 GA  ZAANDAM"]
[344,"Zaltbommel",1,"  Postbus 10002,  5300 DA  ZALTBOMMEL"]
[345,"Zandvoort",1,"  Postbus 2,  2040 AA  ZANDVOORT"]
[346,"Zeewolde",1,"  Postbus 1,  3890 AA  ZEEWOLDE"]
[347,"Zeist",1,"  Postbus 513,  3700 AM  ZEIST"]
[348,"Zevenaar",1,"  Postbus 10, 6900 AA  ZEVENAAR"]
[349,"Zoetermeer",3,"  Postbus 15,  2700 AA  ZOETERMEER"]
[350,"Zoeterwoude",5,"  Postbus 34,  2380 AA  ZOETERWOUDE"]
[351,"Zuidplas",5,"  Postbus 100, 2910 AC NIEUWERKERK a/d IJSSEL"]
[352,"Zundert",1,"  Postbus 10001,  4880 GA  ZUNDERT"]
[353,"Zutphen",1,"  Postbus 41,  7200 AA  ZUTPHEN"]
[354,"Zwartewaterland",1,"  Postbus 23,  8060 AA  HASSELT"]
[355,"Zwijndrecht",4,"  Postbus 15,  3330 AA  ZWIJNDRECHT"]
[356,"Zwolle",1,"  Postbus 10007,  8000 GA  ZWOLLE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Keuze wie het werk uitvoert?"]
[1,"A: Herstel en onderhoud uitgevoerd door de gemeente",null,"Tarief A:  Herstel en onderhoud uitgevoerd door de gemeente"]
[2,"B1: Herstel en onderhoud door de aanbieder",null,"Tarief B1: Herstel en onderhoud door de aanbieder",null,"Tarief > 100 is gelijk aan >15m2"]
[3,"B2: Herstel door de aanbieder en onderhoud door de gemeente",null,"Tarief B2: Herstel door de aanbieder en onderhoud door de gemeente",null,"Tarief > 100 is gelijk aan >15m2"]
[4,"C: Herstel door de gemeente vooraf gaande aan algehele herbestrating *)",null,"Tarief C:  Herstel door de gemeente vooraf gaande aan algehele herbestrating","Dit tarief alleen indien vooraf afgestemd en maximaal 1 jaar voor geplande herbestrating.","Tarief > 100 is gelijk aan >15m2"]
[5,"C1: Herstel en onderhoud door aanbieder voorafgaand aan gehele herbestrating *)",null,"Tarief C1: Herstel en onderhoud door aanbieder voorafgaand aan gehele herbestrating","Dit tarief alleen indien vooraf afgestemd en maximaal 1 jaar voor geplande herbestrating.","Tarief > 100 is gelijk aan >15m2"]
[6,"C2: Herstel door aanbieder, onderhoud door gemeente  voorafgaand aan gehele herbestrating *)",null,"Tarief C2: Herstel door aanbieder, onderhoud door gemeente voorafgaand aan gehele herbestrating","Dit tarief alleen indien vooraf afgestemd en maximaal 1 jaar voor geplande herbestrating.","Tarief > 100 is gelijk aan >15m2"]

{"sheet":"INFO","index":2,"n_rows":75,"n_cols":5,"rows_kept":75,"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 projectprijs 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 gemeente en de juiste tarieven ingesteld."]
[]
[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 van het voorafgaande jaar."]
[]
[null,null,"Gebruik van dit rekenblad"]
[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 rekent met de oppervlakte (lengte x breedte) zoals ingevuld. "]
[null,null,null,"* de gatvergroting wordt niet in oppervlak uitgedrukt maar in een toeslag van 20% op de uitvoeringskosten (en dus op alle tariefcomponenten)"]
[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,"-","De \"Richtlijn\" is van toepassing op het herstel van opgebroken bestrating."]
[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 ook groenvoorzieningen opgenomen."]
[null,"-","De \"Richtlijn\" bevat ook een degeneratievergoeding voor tegelverharding."]
[null,"-","Per project is het aantal m2 bepalend voor de toepassing van tarief <15 m2 of >15 m2, afzonderlijk voor tegels en klinkers. Dus tegel- en "]
[null,null,"klinkeroppervlakken niet bij elkaar optellen. Op het rekenblad gaat dat automatisch."]
[null,"-","Meerdere kleine opbrekingen binnen 10 m (zoals huisaansluitingen) worden aangemerkt als één reparatie."]
[null,"-","Op de tarieven is indexering van toepassing. Jaarlijks zal door de VNG een geïndexeerd \"Rekenblad\" tijdig ter beschikking worden gesteld."]
[]
[null,null,"Afwijkende tarieven"]
[null,"-","Voor gefundeerde verharding en voor groenvoorzieningen wordt geen degeneratievergoeding berekend."]
[null,"-","Wanneer er van band tot band wordt hersteld wordt er geen degeneratievergoeding berekend en geen gatvergroting van 20%. Het "]
[null,null,"rekenblad is in deze gevallen niet toepasbaar. Maak per project afspraken, bij voorkeur vooruitlopend op de uitvoering."]
[null,"-","Voor gesloten verhardingen zoals asfalt, cementbeton, grootschalige en kleinschalige verhardingselementen, plantsoenen en bomen, "]
[null,null,"dienen tussen de gemeente en de aanbieder op projectniveau, of zo mogelijk generiek, afspraken te worden gemaakt. Voor de verrekening"]
[null,null,"kan het \"rekenblad\" worden gebruikt."]
[]
[null,null,"Wijzigingen per 1-1-2018 (en per 1-1-2019 wijziging tarief bermen/gazons, als aangegeven)"]
[null,"-","De wijzigingen hebben geen invloed op de \"Richtlijn tarieven (graaf) werkzaamheden Telecom\", maar maken het rekenblad "]
[null,null,"praktischer en overzichtelijker. "]
[null,"-","Naast Tarief C (Herstel door de gemeente vooraf gaande aan algehele herbestrating) is ook toegevoegd Tarief C1 (idem, herstel en onderhoud"]
[null,null,"door aanbieder/netbeheerder) en Tarief C2 (idem, herstel door aanbieder/netbeheerder, onderhoud door gemeente)."]
[null,"-","De C-tarieven gelden alleen indien vooraf afgesproken en maximaal 1 jaar voor de geplande herbestrating."]
[null,"-","Banden (trottoirbanden, opsluit- / koprolbanden) zijn nu opgenomen in de tarieven A, B1, enz. Zo wordt automatisch het juiste tarief berekend."]
[null,"-","Het tarief voor bermen en gazons is herzien, waardoor per 1-1-2018 het minimum tarief t/m 50m2 is vervallen. De standaard 6% beheerkosten zijn toegevoegd."]
[null,null,"Ingaande 1-1-2019 zijn er 2 tarieven: tarief tot en met 15m2 per opbreking (minimum tarief 15 x m2-tarief) en het tarief per m2 boven de 15m2"]
[null,null,"Bij analyse bleek dat er onvoldoende rekening mee was gehouden dat ca. 84% van de opbrekingen tot en met 15m2 zijn met een gemiddeld oppervlakte van 4 m2."]
[null,null,"Het onderscheid tussen herstel door gemeente (uitvoeringskosten + beheerkosten) en herstel door aanbieder/netbeheerder (beheerkosten) is gebleven."]
[null,null,"De keuze voor welk tarief voor bermen/gazons staat los van Tarief A, B1, enz, voor tegels en klinkers."]
[null,"-","De tabel tarieven is toegevoegd. (Zie uitleg hieronder). Hierin staan alle tariefcomponenten per kostensoort. De herkomst is de berekening"]
[null,null,"in het bestand tariefbladen-slechte-bodem-vng waar een gelijke tabel als resultaat van de berekening van de tarieven is te vinden."]
[null,"-","Steeds meer gemeenten hanteren deze tarieven ook voor netbeheerders, niet telecombedrijven. Als te verrekenen oppervlakte wordt dan "]
[null,null,"vrijwel altijd de werkelijk opgebroken bestrating gehanteerd. Deze mogelijkheid is toegevoegd."]
[]
[null,null,"Nadere uitleg Tabel tarieven"]
[null,"-","Per kostensoort (Uitvoerings-, Onderhouds-, Degeneratie- en Beheerskosten) wordt met een kruisje aangegeven of dit van toepassing"]
[null,null,"is per tarief (A, B1, B2, C, C1 en C2)."]
[null,"-","In de kolommen daarachter staan de tarieven van die kostensoort en omschrijving per bodemcategorie."]
[null,"-","Wanneer het rekenblad gevuld wordt (keuze gemeente en soort tarief) verschijnen in de laatste kolom de tarieven die van toepassing zijn,"]
[null,null,"deze worden gebruikt voor de berekening op het rekenblad voor de specificatie."]
[]
[null,null,"Toepassing:"]
[null,null,"De VNG en een representatieve vertegenwoordiging van de Telecomsector hebben als: \"Packed deal\" overeenstemming bereikt over de"]
[null,null,"rekenmethodiek en de tarieven van de \"Richtlijn\", die integraal behoort te worden toegepast."]
[null,null,"Met de vertegenwoordigers van de netbeheerders (Netbeheer nederland en VEWIN) is een aanvullende 'handreiking' opgesteld voor het toepassen van deze tarieven."]

{"sheet":"Tabel Tarieven","index":3,"n_rows":665,"n_cols":20,"rows_kept":665,"cut":false,"hidden":false,"merged":[[3,17,4,19],[0,17,0,19],[2,15,3,15],[46,0,48,15],[0,1,0,7],[0,10,0,15],[1,8,4,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[1,1,2,7]]}
["Kostensoort","Tariefgroepen",null,null,null,null,null,null,"Omschrijving","Eenheid","Bedragen  2020 v1 per kostensoort per bodemcategorie",null,null,null,null,null,null,"Actueel tarief"]
["Uitvoeringskosten","X in kolom is van toepassing bij deze tariefgroep",null,null,null,null,null,null,"Klinkers, tegels, trottoirband, opsluit/koprolband, berm/gazon.\nEenheid: per m2, m1,\nbij degenaratie per reparatie of m1 sleuf",null,"Afh. Cat.?:","Bij  nee zijn de tarieven gelijk in elke kolom: onafhankelijk categorie",null,null,null,null,null,"Tarief",{"$f":"Rekenblad!B35","v":1}]
["Onderhoudskosten",null,null,null,null,null,null,null,null,null,"> Zie\n> tabblad >>>>","< 50% slechte bodem","50-60% slechte bodem","60-70% slechte bodem","70-80% slechte bodem","> 80% slechte bodem",null,"Categorie",{"$f":"Rekenblad!B36","v":1}]
["Degeneratiekosten",1,2,3,4,5,6,"-",null,null,null,null,null,null,null,null,null,"Toelichting: deze waarden worden gebruikt in het Rekenblad en zijn afhankelijk van de invoer op het Rekenblad"]
["Beheerkosten","A","B1","B2","C","C1","C2","D",null,null,"Afh. Cat.?",1,2,3,4,5]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"klinkers <= 15 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$E$15","v":30.94},{"$f":"'[2]< 50% slechte bodem'!$E$15","v":30.94},{"$f":"'[2]60-70% slechte bodem'!$E$15","v":30.94},{"$f":"'[2]< 50% slechte bodem'!$E$15","v":30.94},{"$f":"'[2]< 50% slechte bodem'!$E$15","v":30.94},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)+R14","v":30.94},"Uitvoeringskosten C opgeteld regel 14"]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"klinkers >15 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$F$15","v":25.28},{"$f":"'[2]50-60% slechte bodem'!$F$15","v":25.28},{"$f":"'[2]60-70% slechte bodem'!$F$15","v":25.28},{"$f":"'[2]70-80% slechte bodem'!$F$15","v":25.28},{"$f":"'[2]> 80% slechte bodem'!$F$15","v":25.28},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)+R15","v":25.28},"Uitvoeringskosten C opgeteld regel 15"]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"klinkers  >100 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$G$15","v":22.45},{"$f":"'[2]50-60% slechte bodem'!$G$15","v":22.45},{"$f":"'[2]60-70% slechte bodem'!$G$15","v":22.45},{"$f":"'[2]70-80% slechte bodem'!$G$15","v":22.45},{"$f":"'[2]> 80% slechte bodem'!$G$15","v":22.45},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)","v":22.45}]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"tegels   <= 15 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$H$15","v":24.58},{"$f":"'[2]50-60% slechte bodem'!$H$15","v":24.58},{"$f":"'[2]60-70% slechte bodem'!$H$15","v":24.58},{"$f":"'[2]70-80% slechte bodem'!$H$15","v":24.58},{"$f":"'[2]> 80% slechte bodem'!$H$15","v":24.58},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)+R16","v":24.58},"Uitvoeringskosten C opgeteld regel 16"]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"tegels   >15 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$I$15","v":18.91},{"$f":"'[2]50-60% slechte bodem'!$I$15","v":18.91},{"$f":"'[2]60-70% slechte bodem'!$I$15","v":18.91},{"$f":"'[2]70-80% slechte bodem'!$I$15","v":18.91},{"$f":"'[2]> 80% slechte bodem'!$I$15","v":18.91},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)+R17","v":18.91},"Uitvoeringskosten C opgeteld regel 17"]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"tegels   >100 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$J$15","v":17.78},{"$f":"'[2]50-60% slechte bodem'!$J$15","v":17.78},{"$f":"'[2]60-70% slechte bodem'!$J$15","v":17.78},{"$f":"'[2]70-80% slechte bodem'!$J$15","v":17.78},{"$f":"'[2]> 80% slechte bodem'!$J$15","v":17.78},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)","v":17.78}]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"trottoirband","m1","Nee",{"$f":"'[2]< 50% slechte bodem'!$K$15","v":11.52},{"$f":"'[2]50-60% slechte bodem'!$K$15","v":11.52},{"$f":"'[2]60-70% slechte bodem'!$K$15","v":11.52},{"$f":"'[2]70-80% slechte bodem'!$K$15","v":11.52},{"$f":"'[2]> 80% slechte bodem'!$K$15","v":11.52},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)+R18","v":11.52},"Uitvoeringskosten C opgeteld regel 18"]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"opsluit/koprolband","m1","Nee",{"$f":"'[2]< 50% slechte bodem'!$L$15","v":9.16},{"$f":"'[2]50-60% slechte bodem'!$L$15","v":9.16},{"$f":"'[2]60-70% slechte bodem'!$L$15","v":9.16},{"$f":"'[2]70-80% slechte bodem'!$L$15","v":9.16},{"$f":"'[2]> 80% slechte bodem'!$L$15","v":9.16},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)+R19","v":9.16},"Uitvoeringskosten C opgeteld regel 19"]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"klinkers <= 15 m2","m2","Nee",{"$f":"ROUND('[2]< 50% slechte bodem'!$E$15/2/1.2,2)","v":12.89},{"$f":"ROUND('[2]50-60% slechte bodem'!$E$15/2/1.2,2)","v":12.89},{"$f":"ROUND('[2]60-70% slechte bodem'!$E$15/2/1.2,2)","v":12.89},{"$f":"ROUND('[2]70-80% slechte bodem'!$E$15/2/1.2,2)","v":12.89},{"$f":"ROUND('[2]> 80% slechte bodem'!$E$15/2/1.2,2)","v":12.89},null,{"$f":"IF($S$2=4,INDEX($L$6:$P$45,,$S$3),0)","v":0},"Is opgeteld bij regel 6"]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"klinkers >15 m2","m2","Nee",{"$f":"ROUND('[2]< 50% slechte bodem'!$F$15/2/1.2,2)","v":10.53},{"$f":"ROUND('[2]50-60% slechte bodem'!$F$15/2/1.2,2)","v":10.53},{"$f":"ROUND('[2]60-70% slechte bodem'!$F$15/2/1.2,2)","v":10.53},{"$f":"ROUND('[2]70-80% slechte bodem'!$F$15/2/1.2,2)","v":10.53},{"$f":"ROUND('[2]> 80% slechte bodem'!$F$15/2/1.2,2)","v":10.53},null,{"$f":"IF($S$2=4,INDEX($L$6:$P$45,,$S$3),0)","v":0},"Is opgeteld bij regel 7"]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"tegels   <= 15 m2","m2","Nee",{"$f":"ROUND('[2]< 50% slechte bodem'!$H$15/2/1.2,2)","v":10.24},{"$f":"ROUND('[2]50-60% slechte bodem'!$H$15/2/1.2,2)","v":10.24},{"$f":"ROUND('[2]60-70% slechte bodem'!$H$15/2/1.2,2)","v":10.24},{"$f":"ROUND('[2]70-80% slechte bodem'!$H$15/2/1.2,2)","v":10.24},{"$f":"ROUND('[2]> 80% slechte bodem'!$H$15/2/1.2,2)","v":10.24},null,0,"Is opgeteld bij regel 9"]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"tegels   >15 m2","m2","Nee",{"$f":"ROUND('[2]< 50% slechte bodem'!$I$15/2/1.2,2)","v":7.88},{"$f":"ROUND('[2]50-60% slechte bodem'!$I$15/2/1.2,2)","v":7.88},{"$f":"ROUND('[2]60-70% slechte bodem'!$I$15/2/1.2,2)","v":7.88},{"$f":"ROUND('[2]70-80% slechte bodem'!$I$15/2/1.2,2)","v":7.88},{"$f":"ROUND('[2]> 80% slechte bodem'!$I$15/2/1.2,2)","v":7.88},null,0,"Is opgeteld bij regel 10"]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"trottoirband","m1","Nee",{"$f":"ROUND('[2]< 50% slechte bodem'!$K$15/2/1.2,2)","v":4.8},{"$f":"ROUND('[2]50-60% slechte bodem'!$K$15/2/1.2,2)","v":4.8},{"$f":"ROUND('[2]60-70% slechte bodem'!$K$15/2/1.2,2)","v":4.8},{"$f":"ROUND('[2]70-80% slechte bodem'!$K$15/2/1.2,2)","v":4.8},{"$f":"ROUND('[2]> 80% slechte bodem'!$K$15/2/1.2,2)","v":4.8},null,0,"Is opgeteld bij regel 12"]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"opsluit/koprolband","m1","Nee",{"$f":"ROUND('[2]< 50% slechte bodem'!$L$15/2/1.2,2)","v":3.82},{"$f":"ROUND('[2]50-60% slechte bodem'!$L$15/2/1.2,2)","v":3.82},{"$f":"ROUND('[2]60-70% slechte bodem'!$L$15/2/1.2,2)","v":3.82},{"$f":"ROUND('[2]70-80% slechte bodem'!$L$15/2/1.2,2)","v":3.82},{"$f":"ROUND('[2]> 80% slechte bodem'!$L$15/2/1.2,2)","v":3.82},null,0,"Is opgeteld bij regel 13"]
["Uitvoeringskosten",null,null,null,null,null,null,"X","berm / gazon <= 15 m2, herstel gemeente","opbr.","Nee",{"$f":"'[2]< 50% slechte bodem'!$M$15*15","v":32.400000000000006},{"$f":"'[2]50-60% slechte bodem'!$M$15*15","v":32.400000000000006},{"$f":"'[2]60-70% slechte bodem'!$M$15*15","v":32.400000000000006},{"$f":"'[2]70-80% slechte bodem'!$M$15*15","v":32.400000000000006},{"$f":"'[2]> 80% slechte bodem'!$M$15*15","v":32.400000000000006},null,{"$f":"INDEX($L$6:$P$45,,$S$3)","v":32.400000000000006}]
["Uitvoeringskosten",null,null,null,null,null,null,"X","berm / gazon >15 m2, herstel gemeente","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$M$15","v":2.16},{"$f":"'[2]50-60% slechte bodem'!$M$15","v":2.16},{"$f":"'[2]60-70% slechte bodem'!$M$15","v":2.16},{"$f":"'[2]70-80% slechte bodem'!$M$15","v":2.16},{"$f":"'[2]> 80% slechte bodem'!$M$15","v":2.16},null,2.16]
["Onderhoudskosten","X",null,"X",null,null,"X",null,"klinkers <= 15 m2","m2","Ja",{"$f":"'[2]< 50% slechte bodem'!$E$16","v":2.29},{"$f":"'[2]50-60% slechte bodem'!$E$16","v":2.58},{"$f":"'[2]60-70% slechte bodem'!$E$16","v":3.47},{"$f":"'[2]70-80% slechte bodem'!$E$16","v":5.28},{"$f":"'[2]> 80% slechte bodem'!$E$16","v":5.88},null,{"$f":"IF(OR($S$2=1,$S$2=3,$S$2=4,$S$2=6),INDEX($L$6:$P$45,,$S$3),0)","v":2.29}]
["Onderhoudskosten","X",null,"X",null,null,"X",null,"klinkers >15 m2","m2","Ja",{"$f":"'[2]< 50% slechte bodem'!$F$16","v":1.87},{"$f":"'[2]50-60% slechte bodem'!$F$16","v":2.11},{"$f":"'[2]60-70% slechte bodem'!$F$16","v":2.83},{"$f":"'[2]70-80% slechte bodem'!$F$16","v":4.3099999999999996},{"$f":"'[2]> 80% slechte bodem'!$F$16","v":4.8},null,{"$f":"IF(OR($S$2=1,$S$2=3,$S$2=4,$S$2=6),INDEX($L$6:$P$45,,$S$3),0)","v":1.87}]
["Onderhoudskosten","X",null,null,null,null,null,null,"klinkers  >100 m2 ","m2","Ja",{"$f":"'[2]< 50% slechte bodem'!$G$16","v":1.66},{"$f":"'[2]50-60% slechte bodem'!$G$16","v":1.87},{"$f":"'[2]60-70% slechte bodem'!$G$16","v":2.5099999999999998},{"$f":"'[2]70-80% slechte bodem'!$G$16","v":3.83},{"$f":"'[2]> 80% slechte bodem'!$G$16","v":4.2699999999999996},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)","v":1.66}]
["Onderhoudskosten","X",null,"X",null,null,"X",null,"tegels   <= 15 m2","m2","Ja",{"$f":"'[2]< 50% slechte bodem'!$H$16","v":1.27},{"$f":"'[2]50-60% slechte bodem'!$H$16","v":1.45},{"$f":"'[2]60-70% slechte bodem'!$H$16","v":2.02},{"$f":"'[2]70-80% slechte bodem'!$H$16","v":3.32},{"$f":"'[2]> 80% slechte bodem'!$H$16","v":3.75},null,{"$f":"IF(OR($S$2=1,$S$2=3,$S$2=4,$S$2=6),INDEX($L$6:$P$45,,$S$3),0)","v":1.27}]
["Onderhoudskosten","X",null,"X",null,null,"X",null,"tegels   >15 m2","m2","Ja",{"$f":"'[2]< 50% slechte bodem'!$I$16","v":0.97},{"$f":"'[2]50-60% slechte bodem'!$I$16","v":1.1200000000000001},{"$f":"'[2]60-70% slechte bodem'!$I$16","v":1.55},{"$f":"'[2]70-80% slechte bodem'!$I$16","v":2.5499999999999998},{"$f":"'[2]> 80% slechte bodem'!$I$16","v":2.88},null,{"$f":"IF(OR($S$2=1,$S$2=3,$S$2=4,$S$2=6),INDEX($L$6:$P$45,,$S$3),0)","v":0.97}]
["Onderhoudskosten","X",null,null,null,null,null,null,"tegels   >100 m2","m2","Ja",{"$f":"'[2]< 50% slechte bodem'!$J$16","v":0.92},{"$f":"'[2]50-60% slechte bodem'!$J$16","v":1.05},{"$f":"'[2]60-70% slechte bodem'!$J$16","v":1.46},{"$f":"'[2]70-80% slechte bodem'!$J$16","v":2.4},{"$f":"'[2]> 80% slechte bodem'!$J$16","v":2.71},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)","v":0.92}]
["Degeneratiekosten","X","X","X",null,null,null,null,"klinkers <= 15 m2","reparatie","Ja",{"$f":"'[2]< 50% slechte bodem'!$E$17","v":8.36},{"$f":"'[2]50-60% slechte bodem'!$E$17","v":11.75},{"$f":"'[2]60-70% slechte bodem'!$E$17","v":21.93},{"$f":"'[2]70-80% slechte bodem'!$E$17","v":33.68},{"$f":"'[2]> 80% slechte bodem'!$E$17","v":41.25},null,{"$f":"IF($S$2<4,INDEX($L$6:$P$45,,$S$3),0)","v":8.36}]
["Degeneratiekosten","X","X","X",null,null,null,null,"klinkers >15 m2","m1 sleuf","Ja",{"$f":"'[2]< 50% slechte bodem'!$F$18","v":2.77},{"$f":"'[2]50-60% slechte bodem'!$F$18","v":3.89},{"$f":"'[2]60-70% slechte bodem'!$F$18","v":7.25},{"$f":"'[2]70-80% slechte bodem'!$F$18","v":14.45},{"$f":"'[2]> 80% slechte bodem'!$F$18","v":16.850000000000001},null,{"$f":"IF($S$2<4,INDEX($L$6:$P$45,,$S$3),0)","v":2.77}]
["Degeneratiekosten","X",null,null,null,null,null,null,"klinkers  >100 m2","m1 sleuf","Ja",{"$f":"'[2]< 50% slechte bodem'!$G$18","v":2.46},{"$f":"'[2]50-60% slechte bodem'!$G$18","v":3.46},{"$f":"'[2]60-70% slechte bodem'!$G$18","v":6.44},{"$f":"'[2]70-80% slechte bodem'!$G$18","v":12.84},{"$f":"'[2]> 80% slechte bodem'!$G$18","v":14.97},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)","v":2.46}]
["Degeneratiekosten","X","X","X",null,null,null,null,"tegels   <= 15 m2","reparatie","Ja",{"$f":"'[2]< 50% slechte bodem'!$H$17","v":0},{"$f":"'[2]50-60% slechte bodem'!$H$17","v":0.83},{"$f":"'[2]60-70% slechte bodem'!$H$17","v":3.32},{"$f":"'[2]70-80% slechte bodem'!$H$17","v":9.5399999999999991},{"$f":"'[2]> 80% slechte bodem'!$H$17","v":11.62},null,{"$f":"IF($S$2<4,INDEX($L$6:$P$45,,$S$3),0)","v":0}]
["Degeneratiekosten","X","X","X",null,null,null,null,"tegels   >15 m2","m1 sleuf","Ja",{"$f":"'[2]< 50% slechte bodem'!$I$18","v":0},{"$f":"'[2]50-60% slechte bodem'!$I$18","v":0.16},{"$f":"'[2]60-70% slechte bodem'!$I$18","v":0.64},{"$f":"'[2]70-80% slechte bodem'!$I$18","v":7.82},{"$f":"'[2]> 80% slechte bodem'!$I$18","v":10.210000000000001},null,{"$f":"IF($S$2<4,INDEX($L$6:$P$45,,$S$3),0)","v":0}]
["Degeneratiekosten","X",null,null,null,null,null,null,"tegels   >100 m2","m1 sleuf","Ja",{"$f":"'[2]< 50% slechte bodem'!$J$18","v":0},{"$f":"'[2]50-60% slechte bodem'!$J$18","v":0.15},{"$f":"'[2]60-70% slechte bodem'!$J$18","v":0.6},{"$f":"'[2]70-80% slechte bodem'!$J$18","v":7.35},{"$f":"'[2]> 80% slechte bodem'!$J$18","v":9.6},null,{"$f":"IF($S$2=1,INDEX($L$6:$P$45,,$S$3),0)","v":0}]
["Beheerskosten","X","X","X","X","X","X",null,"klinkers <= 15 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$E$19","v":1.86},{"$f":"'[2]50-60% slechte bodem'!$E$19","v":1.86},{"$f":"'[2]60-70% slechte bodem'!$E$19","v":1.86},{"$f":"'[2]70-80% slechte bodem'!$E$19","v":1.86},{"$f":"'[2]> 80% slechte bodem'!$E$19","v":1.86},null,{"$f":"INDEX($L$6:$P$45,,$S$3)","v":1.86}]
["Beheerskosten","X","X","X","X","X","X",null,"klinkers >15 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$F$19","v":1.52},{"$f":"'[2]50-60% slechte bodem'!$F$19","v":1.52},{"$f":"'[2]60-70% slechte bodem'!$F$19","v":1.52},{"$f":"'[2]70-80% slechte bodem'!$F$19","v":1.52},{"$f":"'[2]> 80% slechte bodem'!$F$19","v":1.52},null,1.52]
["Beheerskosten","X",null,null,null,null,null,null,"klinkers  >100 m2 ","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$G$19","v":1.35},{"$f":"'[2]50-60% slechte bodem'!$G$19","v":1.35},{"$f":"'[2]60-70% slechte bodem'!$G$19","v":1.35},{"$f":"'[2]70-80% slechte bodem'!$G$19","v":1.35},{"$f":"'[2]> 80% slechte bodem'!$G$19","v":1.35},null,1.35]
["Beheerskosten","X","X","X","X","X","X",null,"tegels   <= 15 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$H$19","v":1.47},{"$f":"'[2]50-60% slechte bodem'!$H$19","v":1.47},{"$f":"'[2]60-70% slechte bodem'!$H$19","v":1.47},{"$f":"'[2]70-80% slechte bodem'!$H$19","v":1.47},{"$f":"'[2]> 80% slechte bodem'!$H$19","v":1.47},null,1.47]
["Beheerskosten","X","X","X","X","X","X",null,"tegels   >15 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$I$19","v":1.1299999999999999},{"$f":"'[2]50-60% slechte bodem'!$I$19","v":1.1299999999999999},{"$f":"'[2]60-70% slechte bodem'!$I$19","v":1.1299999999999999},{"$f":"'[2]70-80% slechte bodem'!$I$19","v":1.1299999999999999},{"$f":"'[2]> 80% slechte bodem'!$I$19","v":1.1299999999999999},null,1.1299999999999999]
["Beheerskosten","X",null,null,null,null,null,null,"tegels   >100 m2","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$J$19","v":1.07},{"$f":"'[2]50-60% slechte bodem'!$J$19","v":1.07},{"$f":"'[2]60-70% slechte bodem'!$J$19","v":1.07},{"$f":"'[2]70-80% slechte bodem'!$J$19","v":1.07},{"$f":"'[2]> 80% slechte bodem'!$J$19","v":1.07},null,1.07]
["Beheerskosten","X","X","X","X","X","X",null,"trottoirband","m1","Nee",{"$f":"'[2]< 50% slechte bodem'!$K$19","v":0.69},{"$f":"'[2]50-60% slechte bodem'!$K$19","v":0.69},{"$f":"'[2]60-70% slechte bodem'!$K$19","v":0.69},{"$f":"'[2]70-80% slechte bodem'!$K$19","v":0.69},{"$f":"'[2]> 80% slechte bodem'!$K$19","v":0.69},null,0.69]
["Beheerskosten","X","X","X","X","X","X",null,"opsluit/koprolband","m1","Nee",{"$f":"'[2]< 50% slechte bodem'!$L$19","v":0.55000000000000004},{"$f":"'[2]50-60% slechte bodem'!$L$19","v":0.55000000000000004},{"$f":"'[2]60-70% slechte bodem'!$L$19","v":0.55000000000000004},{"$f":"'[2]70-80% slechte bodem'!$L$19","v":0.55000000000000004},{"$f":"'[2]> 80% slechte bodem'!$L$19","v":0.55000000000000004},null,0.55000000000000004]
["Beheerskosten",null,null,null,null,null,null,"X","berm / gazon <= 15 m2, herstel gemeente","reparatie","Nee",{"$f":"'[2]< 50% slechte bodem'!$M$19*15","v":1.9500000000000002},{"$f":"'[2]50-60% slechte bodem'!$M$19*15","v":1.9500000000000002},{"$f":"'[2]60-70% slechte bodem'!$M$19*15","v":1.9500000000000002},{"$f":"'[2]70-80% slechte bodem'!$M$19*15","v":1.9500000000000002},{"$f":"'[2]> 80% slechte bodem'!$M$19*15","v":1.9500000000000002},null,{"$f":"INDEX($L$6:$P$45,,$S$3)","v":1.9500000000000002}]
["Beheerskosten",null,null,null,null,null,null,"X","berm / gazon >15 m2, herstel gemeente","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$M$19","v":0.13},{"$f":"'[2]50-60% slechte bodem'!$M$19","v":0.13},{"$f":"'[2]60-70% slechte bodem'!$M$19","v":0.13},{"$f":"'[2]70-80% slechte bodem'!$M$19","v":0.13},{"$f":"'[2]> 80% slechte bodem'!$M$19","v":0.13},null,0.13]
["Beheerskosten",null,null,null,null,null,null,"X","berm / gazon <= 15 m2, herstel aanbieder","reparatie","Nee",{"$f":"'[2]< 50% slechte bodem'!$M$19*15","v":1.9500000000000002},{"$f":"'[2]50-60% slechte bodem'!$M$19*15","v":1.9500000000000002},{"$f":"'[2]60-70% slechte bodem'!$M$19*15","v":1.9500000000000002},{"$f":"'[2]70-80% slechte bodem'!$M$19*15","v":1.9500000000000002},{"$f":"'[2]> 80% slechte bodem'!$M$19*15","v":1.9500000000000002},null,{"$f":"INDEX($L$6:$P$45,,$S$3)","v":1.9500000000000002}]
["Beheerskosten",null,null,null,null,null,null,"X","berm / gazon >15 m2, herstel aanbieder","m2","Nee",{"$f":"'[2]< 50% slechte bodem'!$M$19","v":0.13},{"$f":"'[2]50-60% slechte bodem'!$M$19","v":0.13},{"$f":"'[2]60-70% slechte bodem'!$M$19","v":0.13},{"$f":"'[2]70-80% slechte bodem'!$M$19","v":0.13},{"$f":"'[2]> 80% slechte bodem'!$M$19","v":0.13},null,0.13]
[]
["De bedragen (L6..P41) vanuit de bron: tabblad \"Tabel Tarieven\" van bestand tariefbladen-slechte-bodem-vng-JJJJ kopiëren (met plakken - waarde) naar dit tabblad (in L6..P45). Kopieer K1 naar K1 (plakken waarde)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.14,7.81,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.75,0,2.59,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.55,0,2.2999999999999998,1.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.18,0,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91,0,0,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,0,0,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.81,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2.59,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.14,7.81,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.75,0,2.59,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.18,0,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91,0,0,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.14,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.75,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.18,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.14,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.75,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.18,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.41,10.98,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.97,0,3.64,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.75,0,3.24,1.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.35,0.77,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.04,0,0.15,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98,0,0.14000000000000001,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.98,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,3.64,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.15,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.41,10.98,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.97,0,3.64,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.35,0.77,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.04,0,0.15,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.41,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.97,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.35,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.04,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.41,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.97,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.35,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.04,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.24,20.5,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.65,0,6.79,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.35,0,6.03,1.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.88,3.09,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.45,0,0.6,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.36,0,0.56000000000000005,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.5,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,6.79,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.09,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.6,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.24,20.5,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.65,0,6.79,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.88,3.09,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.45,0,0.6,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.24,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.65,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.88,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.45,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.24,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.65,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.88,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.45,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.93,31.48,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.03,0,13.52,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.58,0,12.01,1.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.09,8.89,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.38,"-,--",7.29,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2400000000000002,0,6.86,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31.48,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,13.52,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.89,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-,--",7.29,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.93,31.48,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.03,0,13.52,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.09,8.89,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.38,"-,--",7.29,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.93,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.03,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.09,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.38,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.93,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.03,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.09,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.38,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.49,38.56,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.49,0,15.77,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.99,0,14.01,1.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.49,10.83,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.69,0,9.5299999999999994,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5299999999999998,0,8.9499999999999993,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38.56,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,15.77,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.83,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,9.5299999999999994,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.49,38.56,0,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.49,0,15.77,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.49,10.83,0,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.69,0,9.5299999999999994,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.49,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.49,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.49,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.69,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.49,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.49,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.49,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.69,null,null,1.06]