{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Printen tarieven","Invoerblad tarieven","Moederblad","< 50% slechte bodem","50-60% slechte bodem","60-70% slechte bodem","70-80% slechte bodem","> 80% slechte bodem","Tabel Tarieven"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Printen tarieven","index":0,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,2,8]]}
[]
[null,"RICHTLIJN TARIEVEN (graaf) werkzaamheden TELECOM.",null,null,null,null,null,null,null,null,"jaar/versie:",{"$f":"'Invoerblad tarieven'!$G$3","v":"2018 v1"}]
[null,"  op basis van de bodemgesteldheid ten behoeve van de Algemene uitkering gemeentefonds.",null,null,null,null,null,null,null,null,null,"KOSTENSPECIFICATIE "]

{"sheet":"Invoerblad tarieven","index":1,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,7],[36,1,36,8],[9,1,10,2]]}
[null,"Invoerscherm:"]
[null,"Bron: Cobouw Kosteninformatie (GWWkosten.nl)",null,null,null,null,null,null,"http://www.gwwkosten.nl/"]
[null,null,null,null,null,"Betreft jaar en versienummer: ","2018 v1"]
[null,"Omschrijving volgens GWWkosten","Aanvullende informatie",null,null,"bijgewerkt dd :","2017-11-22"]
["Straatwerk","GWW Kosten, uurtarieven straatwerk  5% ziekte, loonkosten per uur (excl. Uitv.k en AKWR)",null,null,null,"uurtarieven en loonkosten*"]
[null,null,null,null,null,"actueel tarief:","in te voeren:"]
[null,"Groep D stratenmaker I, inzittende werkbus",null,null,null,{"$f":"Moederblad!F9","v":35.880000000000003},35.880000000000003,null,"11 Uurtarieven en lonen"]
[null,"Groep B, stratenmaker II, chauffeur werkbus",null,null,null,{"$f":"Moederblad!F10","v":34.1},34.1,null,"11 Uurtarieven en lonen"]
[null,"Transport, bestelauto met open laadbak en autolaadkraan","Uitgangspunt is tarief voor het jaar",2017,9.2899999999999991,null,null,null,"Indexcijfer 2e kwartaal voorafgaand aan betreffende jaar: 2016"]
[null,"Indexcijfer operationele autolease, nieuwe leasecontracten incl. brandstof, \n2e kwartaal van elk jaar, bron CBS (prijsindex 2010 = 100)",null,{"$f":"\"2e kwartaal \" &D9-1","v":"2e kwartaal 2016"},97.7,null,null,null,"CBS Indexcijfer operationele autolease (periode aanpassen)"]
[null,null,null,{"$f":"\"2e kwartaal \"&LEFT(G3,4)-1","v":"2e kwartaal 2017"},99,{"$f":"Moederblad!F11","v":9.41},{"$f":"ROUND(E9/E10*E11,2)","v":9.41},null,"Indexcijfer 2e kwartaal voorafgaand aan betreffende jaar"]
[]
["Materiaal","GWW Kosten:",null,null,null,"Funderingslagen en elementverhardingen",null,null,null,null,null,null,{"$f":"L13-1","v":-1}]
[null,null,null,null,null,"actueel tarief:","in te voeren:"]
[null,"Straatstenen, gebakken"]
[null,"Straatklinkers formaat WF tot 5000 stuks","Kwaliteit A4-12, per 1000",null,null,{"$f":"Moederblad!D33","v":350},350,null,"Leveren straatklinkers"]
[null,"Straatklinkers formaat KK 80 tot 5000 stuks","Kwaliteit A4-12, per 1000",null,null,{"$f":"Moederblad!D34","v":490},490,null,"Leveren straatklinkers"]
[]
[null,"Straatstenen, beton:"]
[null,"Betonstraatstenen keiformaat, heide, 210 x 105 x 80 mm","KF (keiformaat), volle vracht, per 1000",null,null,{"$f":"Moederblad!D35","v":225},225,null,"Leveren betonstraatstenen"]
[]
[null,"Tegels beton:"]
[null,"Trottoirtegels, grijs, 300 x 300 x 45 mm","Per m2, komo, volle vracht",null,null,{"$f":"Moederblad!H33","v":8.0299999999999994},8.0299999999999994,null,"Leveren betontegel, 300 x 300 mm"]
[null,"Trottoirtegels, grijs, 300 x 300 x 80 mm","Per m2, komo, volle vracht",null,null,{"$f":"Moederblad!H34","v":11.6},11.6,null,"Leveren betontegel, 300 x 300 mm"]
[]
[null,"Straatzand:"]
[null,"Straatzand 10 - 25 m3","Per m3",null,null,{"$f":"Moederblad!L33","v":11.1},11.1,null,"Leveren grond"]
[]
["Groen","GWW Kosten:",null,null,null,"Groenvoorzieningen"]
[null,null,null,null,null,"actueel tarief:","in te voeren:"]
[null,"Hovenier A, loongroep 4, schaal 8, chauffeur werkbus","Uurtarief Cultuurtechnisch medewerker",null,null,{"$f":"Moederblad!F20","v":30.6},30.6,null,"Uurtarieven groenwerk en kust- en oeverwerk"]
[null,"Transport, bestelauto met open laadbak en autolaadkraan","Overgenomen van Straatwerk (CBS-index)",null,null,{"$f":"Moederblad!F21","v":9.41},{"$f":"G11","v":9.41},null,"Direct gekoppeld aan tarief bij Straatwerk"]
[]
[null,"Bermmengsel","Graszaad, prijs per kg",null,null,{"$f":"Moederblad!D49","v":6.43},6.43,null,"Graszaad en groenbemesters"]
[null,"Gazonmengsel","Graszaad, prijs per kg",null,null,{"$f":"Moederblad!D50","v":7.15},7.15,null,"Graszaad en groenbemesters"]
[]
[null,"*  Bij een juiste invoer en acceptatie zijn de tarieven in de kolom:                                                 - actueel tarief en - in te voeren gelijk !!!"]

{"sheet":"Moederblad","index":2,"n_rows":116,"n_cols":12,"rows_kept":116,"cut":false,"hidden":false,"merged":[[98,5,98,8],[108,1,108,8],[103,1,103,4],[104,1,104,4],[105,1,105,4],[106,1,106,8],[107,1,107,8],[102,1,102,4],[99,1,99,4],[100,1,100,4],[101,1,101,4],[98,1,98,4]]}
[]
["RICHTLIJN TARIEVEN ",null,null,null,null,null,null,null,"jaar/versie:",{"$f":"'Invoerblad tarieven'!$G$3","v":"2018 v1"}]
[null,null,null,null,null,null,null,null,"KOSTENSPECIFICATIE"]
[]
["1) UITVOERINGSKOSTEN",null,null,null,null,null,null,null,null,"wijzigt jaarlijks, zie blad Invoerblad Tarieven"]
[null,null,null,null,null,null,null,null,null,"Bedrag gebruikt voor berekening verder in dit blad"]
["a) Ploegkosten per ","1 juli voorgaand jaar",null,null,null,"Per uur","  ",null,null,"Bedrag gebruikt voor berekening in overige bladen"]
["Bron, zie Invoerblad Tarieven"]
[{"$f":"'Invoerblad tarieven'!B7","v":"Groep D stratenmaker I, inzittende werkbus"},null,null,null,null,{"$f":"'Invoerblad tarieven'!G7","v":35.880000000000003}]
[{"$f":"'Invoerblad tarieven'!B8","v":"Groep B, stratenmaker II, chauffeur werkbus"},null,null,null,null,{"$f":"'Invoerblad tarieven'!G8","v":34.1}]
[{"$f":"'Invoerblad tarieven'!B9","v":"Transport, bestelauto met open laadbak en autolaadkraan"},null,null,null,null,{"$f":"'Invoerblad tarieven'!G11","v":9.41}]
[null,null,null,null,null,"--------------------+",null,null,null,""]
[null,null,null,null,null,{"$f":"SUM(F9:F11)","v":79.39}]
["Alg. kosten winst/risico aannemer",null,null,null,{"$f":"12/100","v":0.12},{"$f":"ROUND(E14*F13,2)","v":9.5299999999999994}]
[null,null,null,null,null,"---------------------+"]
[null,null,null,"TOTAAL per ploeguur ",null,{"$f":"SUM(F13:F14)","v":88.92},"  TOTAAL per manuur ",null,{"$f":"ROUND(F16/2,2)","v":44.46},"",null,""]
[]
["kosten loon groen (Cultuurtechnisch medewerker)",null,null,null,null,"Per uur","  "]
[]
[{"$f":"'Invoerblad tarieven'!B31","v":"Hovenier A, loongroep 4, schaal 8, chauffeur werkbus"},null,null,null,null,{"$f":"'Invoerblad tarieven'!G31","v":30.6},"(met 5% ziekteverzuim)"]
[{"$f":"'Invoerblad tarieven'!B32","v":"Transport, bestelauto met open laadbak en autolaadkraan"},null,null,null,null,{"$f":"'Invoerblad tarieven'!G32","v":9.41}]
[null,null,null,null,null,"--------------------+"]
[null,null,null,null,null,{"$f":"SUM(F20:F21)","v":40.010000000000005}]
["Alg. kosten winst/risico aannemer",null,null,null,{"$f":"12/100","v":0.12},{"$f":"ROUND(E24*F23,2)","v":4.8}]
[null,null,null,null,null,"---------------------+"]
[null,null,null,"TOTAAL per manuur ",null,{"$f":"SUM(F23:F24)","v":44.81},null,null,{"$f":"ROUND(F26,2)","v":44.81}]
[]
["b) kosten materiaal"]
["Berekening materiaalprijzen, incl 15% magazijntoeslag"]
["KLINKERS",null,null,null,null,"TEGELS",null,null,null,"Zand p/ m3"]
["materiaalverhouding per 1000",null,"Aantal/m2","Bedrag",null,"materiaalverhouding per m2",null,"Bedrag",null,null,null,"per m3"]
[]
["waal",0.2,100,{"$f":"'Invoerblad tarieven'!G16","v":350},null,"Dik 45 mm",0.95,{"$f":"'Invoerblad tarieven'!G23","v":8.0299999999999994},null,"Zand",null,{"$f":"'Invoerblad tarieven'!G27","v":11.1}]
["kei",0.2,50,{"$f":"'Invoerblad tarieven'!G17","v":490},null,"Dik 80 mm",0.05,{"$f":"'Invoerblad tarieven'!G24","v":11.6}]
["beton",0.6,44,{"$f":"'Invoerblad tarieven'!G20","v":225}]
["Klinkers, per m2",{"$f":"SUM(B33:B35)","v":1},null,{"$f":"((B33*D33/1000*C33)+(B34*D34/1000*C34)+(B35*D35/1000*C35))","v":17.840000000000003},null,"Tegels, gemiddeld",{"$f":"SUM(G33:G35)","v":1},{"$f":"((G33*H33)+(G34*H34))","v":8.208499999999999},null,"Zand per m3",null,{"$f":"L33","v":11.1}]
["Magazijnopslag",0.15,null,{"$f":"D36*B37","v":2.6760000000000006},null,"Magazijnopslag",0.15,{"$f":"H36*G37","v":1.2312749999999999},null,"Magazijnopslag",0.15,{"$f":"L36*K37","v":1.6649999999999998}]
["Klinkers, incl. magaziinopslag, per m2",null,null,{"$f":"+D37+D36","v":20.516000000000005},null,"Tegels, incl. mag. opsl., p/m2",null,{"$f":"+H37+H36","v":9.4397749999999991},null,"Zand per m3 incl. mag.opsl",null,{"$f":"+L37+L36","v":12.764999999999999}]
[]
[]
["Per m2 bestating herstel",null,"Breuk %",null,null,"Materiaalkosten 5% breuk en 5 cm zand aanvullen"]
["Klinkers",null,0.05,{"$f":"ROUND(C42*D38,2)","v":1.03},null,"Klinkers","m2",{"$f":"D42+D44","v":1.67}]
["Tegels",null,0.05,{"$f":"ROUND(C43*H38,2)","v":0.47},null,"Tegels","m2",{"$f":"D43+D44","v":1.1099999999999999}]
["Zand","5 cm aanvullen",0.05,{"$f":"ROUND(C44*L38,2)","v":0.64},null,"Trottoirband","m1",{"$f":"H43","v":1.1099999999999999}]
[null,null,null,null,null,"Opsluitband","m1",{"$f":"H44","v":1.1099999999999999}]
[]
["kosten materiaal groen",null,null,"Zaad kosten",null,"gebruik","kosten  ","kosten "]
[null,null,null,"per kg",null,"kg/are","per  are","per m2"]
[{"$f":"'Invoerblad tarieven'!B34","v":"Bermmengsel"},null,null,{"$f":"'Invoerblad tarieven'!G34","v":6.43},null,0.75,{"$f":"D49*F49","v":4.8224999999999998},{"$f":"G49/100","v":4.8224999999999997E-2}]
[{"$f":"'Invoerblad tarieven'!B35","v":"Gazonmengsel"},null,null,{"$f":"'Invoerblad tarieven'!G35","v":7.15},null,1.5,{"$f":"D50*F50","v":10.725000000000001},{"$f":"G50/100","v":0.10725000000000001}]
["Gemiddelde kosten berm/gazon (elk 50%) ",null,null,null,null,null,null,{"$f":"(H50+H49)/2","v":7.7737500000000001E-2}]
["Magazijnopslag",0.15,null,null,null,null,null,{"$f":"H51*0.15","v":1.1660624999999999E-2}]
["Gemiddelde kosten berm/gazon graszaad",null,null,null,null,null,null,{"$f":"ROUND((H51+H52),2)","v":0.09}]
[]
["c) kosten totaal"]
["kosten herstraten",null,"Eenheid","Reparatie-","Kosten","materiaal ","Gemiddelde toeslag",null,null,"Uitvoeringskosten"]
["1e herstel",null,null,"norm","Uitvoering","kosten per eenheid","i.v.m. verrekening",null,null,"Incl. materiaal"]
["(A+B)",null,null,"ploeguur","Ploegkosten","(berekening ","GATVERGROTING  (m.u.v.tarief D)",null,null,"incl. gatvergroting"]
[null,null,null,"per eenheid","per eenheid","hierboven)",null,null,null,"per eenheid"]
[]
["KLINKERS ","<15 m2 (lasgat)","m2",0.51,{"$f":"ROUND(D61*$I$16,2)","v":22.67},{"$f":"H42","v":1.67},0.2,null,null,{"$f":"ROUND((E61+F61)*(1+G61),2)","v":29.21}]
["KLINKERS ",">15 m2 (geul)","m2",0.41,18.23,{"$f":"H42","v":1.67},0.2,null,null,{"$f":"ROUND((E62+F62)*(1+G62),2)","v":23.88}]
["KLINKERS ",">100 m2 (geul)","m2",0.36,16.010000000000002,{"$f":"H42","v":1.67},0.2,null,null,21.22]
["TEGELS","<15 m2 (lasgat)","m2",0.41,18.23,{"$f":"H43","v":1.1099999999999999},0.2,null,null,23.21]
["TEGELS ",">15 m2 (geul)","m2",0.31,13.78,{"$f":"H43","v":1.1099999999999999},0.2,null,null,17.87]
["TEGELS ",">100 m2 (geul)","m2",0.28999999999999998,12.89,{"$f":"H43","v":1.1099999999999999},0.2,null,null,16.8]
["TROTTOIRBAND","(tegelmat.)","m1",0.22,9.7799999999999994,{"$f":"H44","v":1.1099999999999999},null,null,null,10.89]
["OPSLUITBAND ","(tegelmat.)","m1",0.17,7.56,{"$f":"H44","v":1.1099999999999999},null,null,null,{"$f":"ROUND((E68+F68)*(1+G68),2)","v":8.67}]
["ZAAI KLAAR MAKEN","100m2 berm, gazon","100m2",{"$f":"1.59","v":1.59},{"$f":"D69*$F$26","v":71.247900000000001}]
["INZAAIEN","100m2 berm, gazon","100m2",{"$f":"0.945","v":0.94499999999999995},{"$f":"D70*$F$26","v":42.34545}]
["Gemiddeld berm/gazon zaaiklaarm+ zaaien",null,"1m2",null,{"$f":"ROUND((E70+E69)/100,2)","v":1.1399999999999999},{"$f":"H53","v":0.09},0.5,null,null,{"$f":"ROUND((E71+F71)*(1+G71),2)","v":1.85}]
[]
["Bodemgesteldheid ","5 categorieën"]
["Categorie","Omschrijving"]
[1,"minder dan 50% slechte bodem"]
[2,"vanaf 50 tot 60% slechte bodem"]
[3,"vanaf 60 tot 70% slechte bodem"]
[4,"vanaf 70 tot 80% slechte bodem"]
[5,"vanaf 80% slechte bodem"]
[]
["2) ONDERHOUD","na herstel, gedurende het 1e jaar,  in % van de totale uitvoeringskosten, per m2"]
["Categorie bodemgesteldheid:",null,null,null,1,2,3,4,5]
["Percentage slechte grond :",null,null,null,"<50%","50-60%","60-70%","70-80%",">80%"]
["Omschrijving"]
["RIJWEGEN       ","(klinkers, tegels)",null,null,0.08,0.09,0.12,0.18,0.2]
["VOET-FIETSPADEN","(tegels, klinkers)",null,null,0.05,5.7500000000000002E-2,0.08,0.13250000000000001,0.15]
[]
[]
["3) DEGENERATIE","De vergoeding voor versnelde degeneratie (levensduurverkorting) van het verhardingsoppervlak als gevolg van graafwerkzaamheden"]
[null,"na herstel in % van de totale uitvoeringskosten, per m1 sleuf"]
["Categorie bodemgesteldheid:",null,null,null,1,2,3,4,5]
["Percentage slechte grond :",null,null,null,"<50%","50-60%","60-70%","70-80%",">80%"]
["Omschrijving"]
["KLINKERS","< 15 m2  (per lasgat)",null,null,0.32,0.45,0.84,1.29,1.58]
["KLINKERS","> 15 m2  (per m1 geul)",null,null,0.13,0.1825,0.34,0.67749999999999999,0.79]
["TEGELS","< 15 m2  (per lasgat)",null,null,0,0.04,0.16,0.46,0.56000000000000005]
["TEGELS","> 15 m2  (per m1 geul)",null,null,0,0.01,0.04,0.49,0.64]
[]
["Tariefgroep","Omschrijving",null,null,null,"De gemeente berekent aan aanbieder / netbeheerder"]
["A","Herstel en onderhoud, uitgevoerd door de gemeente",null,null,null,"UK","OK","DK","BK"]
["B1","Herstel en onderhoud door aanbieder / netbeheerder",null,null,null,null,null,"DK","BK"]
["B2","Herstel door aanbieder / netbeheerder, onderhoud door gemeente",null,null,null,null,"OK","DK","BK"]
["C","Herstel door de gemeente voorafgaand aan gehele herbestrating *)",null,null,null,"UK (gereduceerd)","OK",null,"BK"]
["C1","Herstel en onderhoud door de aanbieder voorafgaand aan gehele herbestrating *)",null,null,null,null,null,null,"BK"]
["C2","Herstel door de aanbieder en onderhoud door de gemeente voorafgaand aan gehele herbestrating *)",null,null,null,null,"OK",null,"BK"]
["D","Overige tarieven (berm/gazon, asfalt, struiken)",null,null,null,"Afhankelijk tarief",null,null,"BK"]
["Onderhoudsperiode:","De onderhoudsperiode is 12 maanden, onderhoud door gemeente of aanbieder/netbeheerder."]
["Garantie:","Indien herstel door aanbieder / netbeheerder kan de gemeente een beroep doen op garantie conform de RAW garantiebepaling gedurende de onderhoudsperiode."]
["*) Tarieven C, C1, C2","De tarieven C, C1 en C2 zijn alleen van toepassing indien vooraf afgestemd en de aanbieder/netbeheerder  maximaal 1 jaar voor de geplande uitvoering van de algehele herbestrating werkt. Reductie op UK door gemeente. Geen DK."]
["Wijzigingen per 1-1-2018:"]
["- Deze tarieven kunnen ook voor netbeheerders, niet zijnde een aanbieder van \neen elektronisch communicatienet werk worden toegepast, in welk geval 'aanbieder' ook staat voor 'netbeheerder'."]
["- Tarieven voor triottoir-, oplsluit/koprolband verplaatst van tarief D naar A, B1, B2, C, C1 en C2 "]
["- Naast Tarief C (herstel vooruitlopend aan herbestrating) is toegevoegd  C1 (bij herstel en onderhoud door aanbieder) en C2 (herstel door aanbieder en onderhoud door gemeente)."]
["  Deze C-tarieven gelden alleen indien vooraf afgestemd en de aanbieder maximaal 1 jaar voor de geplande uitvoering van de algehele herbestrating werkt."]
["- Bermen/gazon berekening herzien, er zijn nu 2 varianten: herstel door de gemeente en herstel door aanbieder/netbeheerder, tarief t/m 50m2 is vervallen"]
["- De tarieven voor troitoirbanden, oplslui/koprolbanden zijn verplaatst van tarief D naar A, B1, B2, C, C1 en C2, zodat deze beter meelopen in de verrekening."]

{"sheet":"< 50% slechte bodem","index":3,"n_rows":94,"n_cols":13,"rows_kept":94,"cut":false,"hidden":false,"merged":[[93,0,93,12],[89,0,89,12],[90,0,90,12],[91,0,91,12],[92,0,92,12],[6,10,7,11],[8,10,8,11],[5,10,5,11],[6,3,7,3],[6,4,7,4],[6,5,7,5],[1,0,1,9],[40,0,41,0],[20,1,21,6],[20,0,21,0],[6,8,7,8],[6,9,7,9],[8,0,8,2],[5,0,7,2],[5,3,5,5],[5,6,5,9],[4,0,4,2],[9,0,9,2],[6,6,7,6],[6,7,7,7],[28,3,28,4],[37,3,37,4],[20,10,21,12],[49,7,50,9],[40,7,41,9],[40,10,41,12],[20,7,21,9],[31,7,32,9],[31,10,32,12],[55,3,55,4],[58,0,59,0],[58,1,59,6],[58,7,59,9],[64,3,64,4],[49,1,50,6],[49,0,50,0],[31,1,32,6],[31,0,32,0],[40,1,41,6],[46,3,46,4],[80,3,80,4],[81,3,81,4],[80,7,80,9],[81,7,81,9],[76,0,77,0],[67,0,68,0],[67,1,68,6],[67,7,68,9],[73,3,73,4],[76,1,77,7],[76,8,77,9]]}
[]
["RICHTLIJN TARIEVEN (GRAAF)WERKZAAMHEDEN TELECOM",null,null,null,null,null,null,null,null,null,"      Bijlage A1"]
[null,null,null,null,null,null,null,null,"Tarievenblad   ",null,"jaar/versie:",{"$f":"'Invoerblad tarieven'!$G$3","v":"2018 v1"}]
[]
["1. Gegevens gemeente:"]
["Bodemgesteldheid categorie: 1.",null,null,"  Onderhoud",null,null,"Degeneratie",null,null,null,"Beheerskosten:"]
[null,null,null,"factor","rijweg","voetpad","Klinker:          < 15 m2","Klinker:          > 15 m2","Tegels:          < 15 m2","Tegels:          > 15 m2","algemeen"]
[]
["minder dan 50% slechte bodem:",null,null,0,0.08,0.05,0.32,0.13,0,0,{"$f":"6/100","v":0.06}]
["2. Overzicht kostenopbouw:"]
[null,null,null,null,"Klinkers:",null,null,"Tegels:",null,null,"Trottoit-","Opsluit-","Berm en"]
[null,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95},null,"band","band","Gazon"]
[null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2","Eenheid: m1","Eenheid: m1","Eenheid: m2"]
["1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$J$61","v":29.21},{"$f":"Moederblad!$J$62","v":23.88},{"$f":"Moederblad!$J$63","v":21.22},{"$f":"Moederblad!$J$64","v":23.21},{"$f":"Moederblad!$J$65","v":17.87},{"$f":"Moederblad!$J$66","v":16.8},{"$f":"Moederblad!J67","v":10.89},{"$f":"Moederblad!J68","v":8.67},{"$f":"Moederblad!J71","v":1.85}]
["2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($F$12*($E$9*E15)+$F$13*($F$9*$E$15),2)","v":2.16},{"$f":"ROUND($F$12*($E$9*$F$15)+$F$13*($F$9*$F$15),2)","v":1.77},{"$f":"ROUND($F$12*($E$9*$G$15)+$F$13*($F$9*$G$15),2)","v":1.57},{"$f":"ROUND($I$12*($F$9*$H$15)+$I$13*($E$9*$H$15),2)","v":1.2},{"$f":"ROUND($I$12*($F$9*$I$15)+$I$13*($E$9*$I$15),2)","v":0.92},{"$f":"ROUND($I$12*($F$9*$J$15)+$I$13*($E$9*$J$15),2)","v":0.87}]
["3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$E$15)/1.185,2)","v":7.89},null,null,0]
["3b. Degeneratie:",null,"per m1 sleuflengte",null,null,{"$f":"ROUND(($H$9*$F$15)/1.185,2)","v":2.62},{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":2.33},null,{"$f":"ROUND(($J$9*$I$15)/1.185,2)","v":0},0]
["4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$E$15,2)","v":1.75},{"$f":"ROUND($K$9*$F$15,2)","v":1.43},{"$f":"ROUND($K$9*$G$15,2)","v":1.27},{"$f":"ROUND($K$9*$H$15,2)","v":1.39},{"$f":"ROUND($K$9*$I$15,2)","v":1.07},{"$f":"ROUND($K$9*$J$15,2)","v":1.01},{"$f":"ROUND($K$9*$K$15,2)","v":0.65},{"$f":"ROUND($K$9*$L$15,2)","v":0.52},{"$f":"ROUND($K$9*$M$15,2)","v":0.11}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door de gemeente inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$E$15+$E$16","v":31.37}," per m2","+ per reparatie              ",null,{"$f":"$E$17","v":7.89},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$H$15+$H$16","v":24.41}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":0},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$F$15+$F$16","v":25.65}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":2.62},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$I$15+$I$16","v":18.790000000000003}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":0},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$G$15+$G$16","v":22.79}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":2.33},"> 100 m2",{"$f":"+$G$19","v":1.27}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$J$15+$J$16","v":17.670000000000002}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0},"> 100 m2",{"$f":"+$J$19","v":1.01}," per m2"]
[null,null,"A7","trottoirband",null,{"$f":"K15","v":10.89},"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"A8","opsluit/koprolband",null,{"$f":"+L15","v":8.67},"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B1.","Herstel en onderhoud door de aanbieder ( 12 maanden garantie)",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":7.89},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":0},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":2.62},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":0},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$E$16","v":2.16}," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":7.89},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$H$16","v":1.2}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":0},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$F$16","v":1.77}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":2.62},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$I$16","v":0.92}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":0},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C.","Herstel door de gemeente voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$15/2)/1.2+$E$16","v":14.330833333333334}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"($H$15/2)/1.2+$H$16","v":10.870833333333334}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":11.719999999999999}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":8.3658333333333346}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,{"$f":"($K$15/2)/1.2","v":4.5375000000000005},"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,{"$f":"($L$15/2)/1.2","v":3.6125000000000003},"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C1","Herstel en onderhoud door de aanbieder ( 12 maanden garantie) voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",0," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",0," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",0," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",0," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C2","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$16)","v":2.16}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"$H$16","v":1.2}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"$F$16","v":1.77}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"$I$16","v":0.92}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: D.","Overige tarieven, herstel door gemeente of netbeheerder zoals aangegeven",null,null,null,null,null,null,"Beheerskosten"]
[]
[null,null,"D3","berm / gazon, herstel door gemeente",null,null,null,{"$f":"M15","v":1.85},{"$f":"M19","v":0.11}," per m2"]
[null,null,"D4","berm / gazon, herstel door aanbieder",null,null,null,0,{"$f":"M19","v":0.11}," per m2"]
[null,null,"D5","bomen en struiken",null,null,null,"werkelijke kosten"]
[null,null,"D6","asfalt",null,null,null,"werkelijke kosten"]
[]
["BTW is niet verschuldigd. Zie: Besluit van de Staatsecretaris van Financien dd 19 februari 2004, nr. CPP2003/3098M."]
["Het tarief oppervlak (m2) straatwerk of berm wordt bepaaldt door vermeningvuldiging van lengte x breedte  van de sleuf of  lasgat ( gatvergroting zit in tarief)"]
["Per project is het aantal m2  op de straatwerkbon bepalend voor de toepassing van tarief <15 m2 of > 15 m2. Klinkers en tegels mogen niet bijelkaar worden opgeteld"]
["Meerdere kleine opbrekingen binnen 10 meter, aan één wegkant, worden aangemerkt als één reparatie."]
[]
["Wijzigingen per 1-1-2018:"]
["- Deze tarieven kunnen ook voor netbeheerders, niet zijnde een aanbieder van een elektronisch communicatienet werk worden toegepast, in welk geval 'aanbieder' ook staat voor 'netbeheerder';"]
["- Tarieven voor triottoir-, oplsluit/koprolband verplaatst van tarief D naar A, B1, B2, C, C1 en C2;"]
["- Naast Tarief C (herstel vooruitlopend aan herbestrating) is toegevoegd  C1 (bij herstel en onderhoud door aanbieder) en C2 (herstel door aanbieder en onderhoud door gemeente). Deze C-tarieven gelden alleen indien vooraf afgestemd en de aanbieder maximaal 1 jaar voor de geplande uitvoering van de algehele herbestrating werkt."]
["- Toegevoegd is een richtlijn voor het hanteren van de tarieven indien 'van band tot band' bestraat wordt (tarieven A, B1 en B2 delen door 1,2 en geen degeneratiekosten berekenen). Er is afgezien van het formaliseren van aparte tarieven voor deze gevallen."]
["- Bermen/gazon: uitvoeringskosten per m2 herberekend, tarief t/m 50m2 vervallen (alleen nog per m2), 2 varianten: herstel door gemeente en herstel door netbeheerder."]

{"sheet":"50-60% slechte bodem","index":4,"n_rows":94,"n_cols":13,"rows_kept":94,"cut":false,"hidden":false,"merged":[[89,0,89,12],[90,0,90,12],[91,0,91,12],[92,0,92,12],[93,0,93,12],[8,0,8,2],[8,10,8,11],[1,0,1,9],[4,0,4,2],[5,0,7,2],[5,3,5,5],[5,6,5,9],[5,10,5,11],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[28,3,28,4],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,11],[9,0,9,2],[20,0,21,0],[20,1,21,6],[20,7,21,9],[20,10,21,12],[31,10,32,12],[37,3,37,4],[40,0,41,0],[40,1,41,6],[40,7,41,9],[40,10,41,12],[58,0,59,0],[58,1,59,6],[58,7,59,9],[31,0,32,0],[31,1,32,6],[31,7,32,9],[46,3,46,4],[49,0,50,0],[49,1,50,6],[49,7,50,9],[55,3,55,4],[67,0,68,0],[67,1,68,6],[67,7,68,9],[73,3,73,4],[76,0,77,0],[76,1,77,7],[76,8,77,9],[80,3,80,4],[80,7,80,9],[81,3,81,4],[81,7,81,9],[64,3,64,4],[90,14,90,26],[91,14,91,26],[92,14,92,26],[93,14,93,26],[94,14,94,26]]}
[]
["RICHTLIJN TARIEVEN (GRAAF)WERKZAAMHEDEN TELECOM",null,null,null,null,null,null,null,null,null,"      Bijlage A2"]
[null,null,null,null,null,null,null,null,"Tarievenblad   ",null,"jaar/versie:",{"$f":"'Invoerblad tarieven'!$G$3","v":"2018 v1"}]
[]
["1. Gegevens gemeente:"]
["Bodemgesteldheid categorie: 2.",null,null,"  Onderhoud",null,null,"Degeneratie",null,null,null,"Beheerskosten:"]
[null,null,null,"factor","rijweg","voetpad","Klinker:          < 15 m2","Klinker:          > 15 m2","Tegels:          < 15 m2","Tegels:          > 15 m2","algemeen"]
[]
["vanaf 50% tot 60% slechte bodem",null,null,0.25,0.09,5.7500000000000002E-2,0.45,0.1825,0.04,0.01,{"$f":"6/100","v":0.06}]
["2. Overzicht kostenopbouw:"]
[null,null,null,null,"Klinkers:",null,null,"Tegels:",null,null,"Trottoit-","Opsluit-","Berm en"]
[null,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95},null,"band","band","Gazon"]
[null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2","Eenheid: m1","Eenheid: m1","Eenheid: m2"]
["1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$J$61","v":29.21},{"$f":"Moederblad!$J$62","v":23.88},{"$f":"Moederblad!$J$63","v":21.22},{"$f":"Moederblad!$J$64","v":23.21},{"$f":"Moederblad!$J$65","v":17.87},{"$f":"Moederblad!$J$66","v":16.8},{"$f":"Moederblad!J67","v":10.89},{"$f":"Moederblad!J68","v":8.67},{"$f":"Moederblad!J71","v":1.85}]
["2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($F$12*($E$9*E15)+$F$13*($F$9*$E$15),2)","v":2.44},{"$f":"ROUND($F$12*($E$9*$F$15)+$F$13*($F$9*$F$15),2)","v":1.99},{"$f":"ROUND($F$12*($E$9*$G$15)+$F$13*($F$9*$G$15),2)","v":1.77},{"$f":"ROUND($I$12*($F$9*$H$15)+$I$13*($E$9*$H$15),2)","v":1.37},{"$f":"ROUND($I$12*($F$9*$I$15)+$I$13*($E$9*$I$15),2)","v":1.06},{"$f":"ROUND($I$12*($F$9*$J$15)+$I$13*($E$9*$J$15),2)","v":0.99}]
["3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$E$15)/1.185,2)","v":11.09},null,null,{"$f":"ROUND(($I$9*$H$15)/1.185,2)","v":0.78}]
["3b. Degeneratie:",null,"per m1 sleuflengte",null,null,{"$f":"ROUND(($H$9*$F$15)/1.185,2)","v":3.68},{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":3.27},null,{"$f":"ROUND(($J$9*$I$15)/1.185,2)","v":0.15},{"$f":"ROUND(($J$9*$J$15)/1.185,2)","v":0.14000000000000001}]
["4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$E$15,2)","v":1.75},{"$f":"ROUND($K$9*$F$15,2)","v":1.43},{"$f":"ROUND($K$9*$G$15,2)","v":1.27},{"$f":"ROUND($K$9*$H$15,2)","v":1.39},{"$f":"ROUND($K$9*$I$15,2)","v":1.07},{"$f":"ROUND($K$9*$J$15,2)","v":1.01},{"$f":"ROUND($K$9*$K$15,2)","v":0.65},{"$f":"ROUND($K$9*$L$15,2)","v":0.52},{"$f":"ROUND($K$9*$M$15,2)","v":0.11}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door de gemeente inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$E$15+$E$16","v":31.650000000000002}," per m2","+ per reparatie              ",null,{"$f":"$E$17","v":11.09},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$H$15+$H$16","v":24.580000000000002}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":0.78},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$F$15+$F$16","v":25.869999999999997}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":3.68},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$I$15+$I$16","v":18.93}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":0.15},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$G$15+$G$16","v":22.99}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":3.27},"> 100 m2",{"$f":"+$G$19","v":1.27}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$J$15+$J$16","v":17.79}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0.14000000000000001},"> 100 m2",{"$f":"+$J$19","v":1.01}," per m2"]
[null,null,"A7","trottoirband",null,{"$f":"K15","v":10.89},"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"A8","opsluit/koprolband",null,{"$f":"+L15","v":8.67},"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B1.","Herstel en onderhoud door de aanbieder ( 12 maanden garantie)",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":11.09},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":0.78},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":3.68},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":0.15},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente   ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$E$16","v":2.44}," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":11.09},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$H$16","v":1.37}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":0.78},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$F$16","v":1.99}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":3.68},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$I$16","v":1.06}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":0.15},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C.","Herstel door de gemeente voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$15/2)/1.2+$E$16","v":14.610833333333334}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"($H$15/2)/1.2+$H$16","v":11.040833333333335}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":11.94}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":8.5058333333333334}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,{"$f":"($K$15/2)/1.2","v":4.5375000000000005},"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,{"$f":"($L$15/2)/1.2","v":3.6125000000000003},"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C1","Herstel en onderhoud door de aanbieder ( 12 maanden garantie) voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",0," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",0," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",0," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",0," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C2","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$16)","v":2.44}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"$H$16","v":1.37}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"$F$16","v":1.99}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"$I$16","v":1.06}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: D.","Overige tarieven, herstel door gemeente of netbeheerder zoals aangegeven",null,null,null,null,null,null,"Beheerskosten"]
[]
[null,null,"D3","berm / gazon, herstel door gemeente",null,null,null,{"$f":"M15","v":1.85},{"$f":"M19","v":0.11}," per m2"]
[null,null,"D4","berm / gazon, herstel door aanbieder",null,null,null,0,{"$f":"M19","v":0.11}," per m2"]
[null,null,"D5","bomen en struiken",null,null,null,"werkelijke kosten"]
[null,null,"D6","asfalt",null,null,null,"werkelijke kosten"]
[]
["BTW is niet verschuldigd. Zie: Besluit van de Staatsecretaris van Financien dd 19 februari 2004, nr. CPP2003/3098M."]
["Het tarief oppervlak (m2) straatwerk of berm wordt bepaaldt door vermeningvuldiging van lengte x breedte  van de sleuf of  lasgat ( gatvergroting zit in tarief)"]
["Per project is het aantal m2  op de straatwerkbon bepalend voor de toepassing van tarief <15 m2 of > 15 m2. Klinkers en tegels mogen niet bijelkaar worden opgeteld"]
["Meerdere kleine opbrekingen binnen 10 meter, aan één wegkant, worden aangemerkt als één reparatie."]
[]
["Wijzigingen per 1-1-2018:"]
["- Deze tarieven kunnen ook voor netbeheerders, niet zijnde een aanbieder van een elektronisch communicatienet werk worden toegepast, in welk geval 'aanbieder' ook staat voor 'netbeheerder';"]
["- Tarieven voor triottoir-, oplsluit/koprolband verplaatst van tarief D naar A, B1, B2, C, C1 en C2;"]
["- Naast Tarief C (herstel vooruitlopend aan herbestrating) is toegevoegd  C1 (bij herstel en onderhoud door aanbieder) en C2 (herstel door aanbieder en onderhoud door gemeente). Deze C-tarieven gelden alleen indien vooraf afgestemd en de aanbieder maximaal 1 jaar voor de geplande uitvoering van de algehele herbestrating werkt."]
["- Toegevoegd is een richtlijn voor het hanteren van de tarieven indien 'van band tot band' bestraat wordt (tarieven A, B1 en B2 delen door 1,2 en geen degeneratiekosten berekenen). Er is afgezien van het formaliseren van aparte tarieven voor deze gevallen."]
["- Bermen/gazon: uitvoeringskosten per m2 herberekend, tarief t/m 50m2 vervallen (alleen nog per m2), 2 varianten: herstel door gemeente en herstel door netbeheerder."]

{"sheet":"60-70% slechte bodem","index":5,"n_rows":94,"n_cols":13,"rows_kept":94,"cut":false,"hidden":false,"merged":[[89,0,89,12],[90,0,90,12],[91,0,91,12],[92,0,92,12],[93,0,93,12],[8,0,8,2],[8,10,8,11],[1,0,1,9],[4,0,4,2],[5,0,7,2],[5,3,5,5],[5,6,5,9],[5,10,5,11],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[28,3,28,4],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,11],[9,0,9,2],[20,0,21,0],[20,1,21,6],[20,7,21,9],[20,10,21,12],[31,10,32,12],[37,3,37,4],[40,0,41,0],[40,1,41,6],[40,7,41,9],[40,10,41,12],[58,0,59,0],[58,1,59,6],[58,7,59,9],[31,0,32,0],[31,1,32,6],[31,7,32,9],[46,3,46,4],[49,0,50,0],[49,1,50,6],[49,7,50,9],[55,3,55,4],[67,0,68,0],[67,1,68,6],[67,7,68,9],[73,3,73,4],[76,0,77,0],[76,1,77,7],[76,8,77,9],[80,3,80,4],[80,7,80,9],[81,3,81,4],[81,7,81,9],[64,3,64,4]]}
[]
["RICHTLIJN TARIEVEN (GRAAF)WERKZAAMHEDEN TELECOM",null,null,null,null,null,null,null,null,null,"      Bijlage A3"]
[null,null,null,null,null,null,null,null,"Tarievenblad   ",null,"jaar/versie:",{"$f":"'Invoerblad tarieven'!$G$3","v":"2018 v1"}]
[]
["1. Gegevens gemeente:"]
["Bodemgesteldheid categorie: 3.",null,null,"  Onderhoud",null,null,"Degeneratie",null,null,null,"Beheerskosten:"]
[null,null,null,"factor","rijweg","voetpad","Klinker:          < 15 m2","Klinker:          > 15 m2","Tegels:          < 15 m2","Tegels:          > 15 m2","algemeen"]
[]
["vanaf 60% tot 70% slechte bodem",null,null,0.5,0.12,0.08,0.84,0.34,0.16,0.04,{"$f":"6/100","v":0.06}]
["2. Overzicht kostenopbouw:"]
[null,null,null,null,"Klinkers:",null,null,"Tegels:",null,null,"Trottoit-","Opsluit-","Berm en"]
[null,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95},null,"band","band","Gazon"]
[null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2","Eenheid: m1","Eenheid: m1","Eenheid: m2"]
["1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$J$61","v":29.21},{"$f":"Moederblad!$J$62","v":23.88},{"$f":"Moederblad!$J$63","v":21.22},{"$f":"Moederblad!$J$64","v":23.21},{"$f":"Moederblad!$J$65","v":17.87},{"$f":"Moederblad!$J$66","v":16.8},{"$f":"Moederblad!J67","v":10.89},{"$f":"Moederblad!J68","v":8.67},{"$f":"Moederblad!J71","v":1.85}]
["2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($F$12*($E$9*E15)+$F$13*($F$9*$E$15),2)","v":3.27},{"$f":"ROUND($F$12*($E$9*$F$15)+$F$13*($F$9*$F$15),2)","v":2.67},{"$f":"ROUND($F$12*($E$9*$G$15)+$F$13*($F$9*$G$15),2)","v":2.38},{"$f":"ROUND($I$12*($F$9*$H$15)+$I$13*($E$9*$H$15),2)","v":1.9},{"$f":"ROUND($I$12*($F$9*$I$15)+$I$13*($E$9*$I$15),2)","v":1.47},{"$f":"ROUND($I$12*($F$9*$J$15)+$I$13*($E$9*$J$15),2)","v":1.38}]
["3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$E$15)/1.185,2)","v":20.71},null,null,{"$f":"ROUND(($I$9*$H$15)/1.185,2)","v":3.13}]
["3b. Degeneratie:",null,"per m1 sleuflengte",null,null,{"$f":"ROUND(($H$9*$F$15)/1.185,2)","v":6.85},{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":6.09},null,{"$f":"ROUND(($J$9*$I$15)/1.185,2)","v":0.6},{"$f":"ROUND(($J$9*$J$15)/1.185,2)","v":0.56999999999999995}]
["4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$E$15,2)","v":1.75},{"$f":"ROUND($K$9*$F$15,2)","v":1.43},{"$f":"ROUND($K$9*$G$15,2)","v":1.27},{"$f":"ROUND($K$9*$H$15,2)","v":1.39},{"$f":"ROUND($K$9*$I$15,2)","v":1.07},{"$f":"ROUND($K$9*$J$15,2)","v":1.01},{"$f":"ROUND($K$9*$K$15,2)","v":0.65},{"$f":"ROUND($K$9*$L$15,2)","v":0.52},{"$f":"ROUND($K$9*$M$15,2)","v":0.11}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door de gemeente inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$E$15+$E$16","v":32.480000000000004}," per m2","+ per reparatie              ",null,{"$f":"$E$17","v":20.71},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$H$15+$H$16","v":25.11}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":3.13},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$F$15+$F$16","v":26.549999999999997}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":6.85},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$I$15+$I$16","v":19.34}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":0.6},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$G$15+$G$16","v":23.599999999999998}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":6.09},"> 100 m2",{"$f":"+$G$19","v":1.27}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$J$15+$J$16","v":18.18}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0.56999999999999995},"> 100 m2",{"$f":"+$J$19","v":1.01}," per m2"]
[null,null,"A7","trottoirband",null,{"$f":"K15","v":10.89},"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"A8","opsluit/koprolband",null,{"$f":"+L15","v":8.67},"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B1.","Herstel en onderhoud door de aanbieder ( 12 maanden garantie)",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":20.71},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":3.13},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":6.85},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":0.6},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$E$16","v":3.27}," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":20.71},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$H$16","v":1.9}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":3.13},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$F$16","v":2.67}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":6.85},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$I$16","v":1.47}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":0.6},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C.","Herstel door de gemeente voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$15/2)/1.2+$E$16","v":15.440833333333334}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"($H$15/2)/1.2+$H$16","v":11.570833333333335}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":12.62}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":8.9158333333333335}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,{"$f":"($K$15/2)/1.2","v":4.5375000000000005},"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,{"$f":"($L$15/2)/1.2","v":3.6125000000000003},"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C1","Herstel en onderhoud door de aanbieder ( 12 maanden garantie) voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",0," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",0," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",0," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",0," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C2","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$16)","v":3.27}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"$H$16","v":1.9}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"$F$16","v":2.67}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"$I$16","v":1.47}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: D.","Overige tarieven, herstel door de gemeente of netbeheerder zoals aangegeven",null,null,null,null,null,null,"Beheerskosten"]
[]
[null,null,"D3","berm / gazon, herstel door gemeente",null,null,null,{"$f":"M15","v":1.85},{"$f":"M19","v":0.11}," per m2"]
[null,null,"D4","berm / gazon, herstel door aanbieder",null,null,null,0,{"$f":"M19","v":0.11}," per m2"]
[null,null,"D5","bomen en struiken",null,null,null,"werkelijke kosten"]
[null,null,"D6","asfalt",null,null,null,"werkelijke kosten"]
[]
["BTW is niet verschuldigd. Zie: Besluit van de Staatsecretaris van Financien dd 19 februari 2004, nr. CPP2003/3098M."]
["Het tarief oppervlak (m2) straatwerk of berm wordt bepaaldt door vermeningvuldiging van lengte x breedte  van de sleuf of  lasgat ( gatvergroting zit in tarief)"]
["Per project is het aantal m2  op de straatwerkbon bepalend voor de toepassing van tarief <15 m2 of > 15 m2. Klinkers en tegels mogen niet bijelkaar worden opgeteld"]
["Meerdere kleine opbrekingen binnen 10 meter, aan één wegkant, worden aangemerkt als één reparatie."]
[]
["Wijzigingen per 1-1-2018:"]
["- Deze tarieven kunnen ook voor netbeheerders, niet zijnde een aanbieder van een elektronisch communicatienet werk worden toegepast, in welk geval 'aanbieder' ook staat voor 'netbeheerder';"]
["- Tarieven voor triottoir-, oplsluit/koprolband verplaatst van tarief D naar A, B1, B2, C, C1 en C2;"]
["- Naast Tarief C (herstel vooruitlopend aan herbestrating) is toegevoegd  C1 (bij herstel en onderhoud door aanbieder) en C2 (herstel door aanbieder en onderhoud door gemeente). Deze C-tarieven gelden alleen indien vooraf afgestemd en de aanbieder maximaal 1 jaar voor de geplande uitvoering van de algehele herbestrating werkt."]
["- Toegevoegd is een richtlijn voor het hanteren van de tarieven indien 'van band tot band' bestraat wordt (tarieven A, B1 en B2 delen door 1,2 en geen degeneratiekosten berekenen). Er is afgezien van het formaliseren van aparte tarieven voor deze gevallen."]
["- Bermen/gazon: uitvoeringskosten per m2 herberekend, tarief t/m 50m2 vervallen (alleen nog per m2), 2 varianten: herstel door gemeente en herstel door netbeheerder."]

{"sheet":"70-80% slechte bodem","index":6,"n_rows":94,"n_cols":13,"rows_kept":94,"cut":false,"hidden":false,"merged":[[89,0,89,12],[90,0,90,12],[91,0,91,12],[92,0,92,12],[93,0,93,12],[8,0,8,2],[8,10,8,11],[1,0,1,9],[4,0,4,2],[5,0,7,2],[5,3,5,5],[5,6,5,9],[5,10,5,11],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[28,3,28,4],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,11],[9,0,9,2],[20,0,21,0],[20,1,21,6],[20,7,21,9],[20,10,21,12],[31,10,32,12],[37,3,37,4],[40,0,41,0],[40,1,41,6],[40,7,41,9],[40,10,41,12],[58,0,59,0],[58,1,59,6],[58,7,59,9],[31,0,32,0],[31,1,32,6],[31,7,32,9],[46,3,46,4],[49,0,50,0],[49,1,50,6],[49,7,50,9],[55,3,55,4],[67,0,68,0],[67,1,68,6],[67,7,68,9],[73,3,73,4],[76,0,77,0],[76,1,77,7],[76,8,77,9],[80,3,80,4],[80,7,80,9],[81,3,81,4],[81,7,81,9],[64,3,64,4]]}
[]
["RICHTLIJN TARIEVEN (GRAAF)WERKZAAMHEDEN TELECOM",null,null,null,null,null,null,null,null,null,"      Bijlage A4"]
[null,null,null,null,null,null,null,null,"Tarievenblad   ",null,"jaar/versie:",{"$f":"'Invoerblad tarieven'!$G$3","v":"2018 v1"}]
[]
["1. Gegevens gemeente:"]
["Bodemgesteldheid categorie: 4.",null,null,"  Onderhoud",null,null,"Degeneratie",null,null,null,"Beheerskosten:"]
[null,null,null,"factor","rijweg","voetpad","Klinker:          < 15 m2","Klinker:          > 15 m2","Tegels:          < 15 m2","Tegels:          > 15 m2","algemeen"]
[]
["vanaf 70% tot 80% slechte bodem",null,null,0.75,0.18,0.13250000000000001,1.29,0.67749999999999999,0.46,0.49,{"$f":"6/100","v":0.06}]
["2. Overzicht kostenopbouw:"]
[null,null,null,null,"Klinkers:",null,null,"Tegels:",null,null,"Trottoit-","Opsluit-","Berm en"]
[null,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95},null,"band","band","Gazon"]
[null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2","Eenheid: m1","Eenheid: m1","Eenheid: m2"]
["1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$J$61","v":29.21},{"$f":"Moederblad!$J$62","v":23.88},{"$f":"Moederblad!$J$63","v":21.22},{"$f":"Moederblad!$J$64","v":23.21},{"$f":"Moederblad!$J$65","v":17.87},{"$f":"Moederblad!$J$66","v":16.8},{"$f":"Moederblad!J67","v":10.89},{"$f":"Moederblad!J68","v":8.67},{"$f":"Moederblad!J71","v":1.85}]
["2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($F$12*($E$9*E15)+$F$13*($F$9*$E$15),2)","v":4.9800000000000004},{"$f":"ROUND($F$12*($E$9*$F$15)+$F$13*($F$9*$F$15),2)","v":4.07},{"$f":"ROUND($F$12*($E$9*$G$15)+$F$13*($F$9*$G$15),2)","v":3.62},{"$f":"ROUND($I$12*($F$9*$H$15)+$I$13*($E$9*$H$15),2)","v":3.13},{"$f":"ROUND($I$12*($F$9*$I$15)+$I$13*($E$9*$I$15),2)","v":2.41},{"$f":"ROUND($I$12*($F$9*$J$15)+$I$13*($E$9*$J$15),2)","v":2.27}]
["3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$E$15)/1.185,2)","v":31.8},null,null,{"$f":"ROUND(($I$9*$H$15)/1.185,2)","v":9.01}]
["3b. Degeneratie:",null,"per m1 sleuflengte",null,null,{"$f":"ROUND(($H$9*$F$15)/1.185,2)","v":13.65},{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":12.13},null,{"$f":"ROUND(($J$9*$I$15)/1.185,2)","v":7.39},{"$f":"ROUND(($J$9*$J$15)/1.185,2)","v":6.95}]
["4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$E$15,2)","v":1.75},{"$f":"ROUND($K$9*$F$15,2)","v":1.43},{"$f":"ROUND($K$9*$G$15,2)","v":1.27},{"$f":"ROUND($K$9*$H$15,2)","v":1.39},{"$f":"ROUND($K$9*$I$15,2)","v":1.07},{"$f":"ROUND($K$9*$J$15,2)","v":1.01},{"$f":"ROUND($K$9*$K$15,2)","v":0.65},{"$f":"ROUND($K$9*$L$15,2)","v":0.52},{"$f":"ROUND($K$9*$M$15,2)","v":0.11}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door de gemeente inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$E$15+$E$16","v":34.19}," per m2","+ per reparatie              ",null,{"$f":"$E$17","v":31.8},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$H$15+$H$16","v":26.34}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":9.01},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$F$15+$F$16","v":27.95}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":13.65},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$I$15+$I$16","v":20.28}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":7.39},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$G$15+$G$16","v":24.84}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":12.13},"> 100 m2",{"$f":"+$G$19","v":1.27}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$J$15+$J$16","v":19.07}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":6.95},"> 100 m2",{"$f":"+$J$19","v":1.01}," per m2"]
[null,null,"A7","trottoirband",null,{"$f":"K15","v":10.89},"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"A8","opsluit/koprolband",null,{"$f":"+L15","v":8.67},"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B1.","Herstel en onderhoud door de aanbieder ( 12 maanden garantie)",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":31.8},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":9.01},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":13.65},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":7.39},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$E$16","v":4.9800000000000004}," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":31.8},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$H$16","v":3.13}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":9.01},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$F$16","v":4.07}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":13.65},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$I$16","v":2.41}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":7.39},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C.","Herstel door de gemeente voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$15/2)/1.2+$E$16","v":17.150833333333335}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"($H$15/2)/1.2+$H$16","v":12.800833333333333}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":14.02}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":9.855833333333333}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,{"$f":"($K$15/2)/1.2","v":4.5375000000000005},"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,{"$f":"($L$15/2)/1.2","v":3.6125000000000003},"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C1","Herstel en onderhoud door de aanbieder ( 12 maanden garantie) voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",0," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",0," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",0," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",0," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C2","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$16)","v":4.9800000000000004}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"$H$16","v":3.13}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"$F$16","v":4.07}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"$I$16","v":2.41}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: D.","Overige tarieven, herstel door de gemeente of netbeheerder zoals aangegeven",null,null,null,null,null,null,"Beheerskosten"]
[]
[null,null,"D3","berm / gazon, herstel door gemeente",null,null,null,{"$f":"M15","v":1.85},{"$f":"M19","v":0.11}," per m2"]
[null,null,"D4","berm / gazon, herstel door aanbieder",null,null,null,0,{"$f":"M19","v":0.11}," per m2"]
[null,null,"D5","bomen en struiken",null,null,null,"werkelijke kosten"]
[null,null,"D6","asfalt",null,null,null,"werkelijke kosten"]
[]
["BTW is niet verschuldigd. Zie: Besluit van de Staatsecretaris van Financien dd 19 februari 2004, nr. CPP2003/3098M."]
["Het tarief oppervlak (m2) straatwerk of berm wordt bepaaldt door vermeningvuldiging van lengte x breedte  van de sleuf of  lasgat ( gatvergroting zit in tarief)"]
["Per project is het aantal m2  op de straatwerkbon bepalend voor de toepassing van tarief <15 m2 of > 15 m2. Klinkers en tegels mogen niet bijelkaar worden opgeteld"]
["Meerdere kleine opbrekingen binnen 10 meter, aan één wegkant, worden aangemerkt als één reparatie."]
[]
["Wijzigingen per 1-1-2018:"]
["- Deze tarieven kunnen ook voor netbeheerders, niet zijnde een aanbieder van een elektronisch communicatienet werk worden toegepast, in welk geval 'aanbieder' ook staat voor 'netbeheerder';"]
["- Tarieven voor triottoir-, oplsluit/koprolband verplaatst van tarief D naar A, B1, B2, C, C1 en C2;"]
["- Naast Tarief C (herstel vooruitlopend aan herbestrating) is toegevoegd  C1 (bij herstel en onderhoud door aanbieder) en C2 (herstel door aanbieder en onderhoud door gemeente). Deze C-tarieven gelden alleen indien vooraf afgestemd en de aanbieder maximaal 1 jaar voor de geplande uitvoering van de algehele herbestrating werkt."]
["- Toegevoegd is een richtlijn voor het hanteren van de tarieven indien 'van band tot band' bestraat wordt (tarieven A, B1 en B2 delen door 1,2 en geen degeneratiekosten berekenen). Er is afgezien van het formaliseren van aparte tarieven voor deze gevallen."]
["- Bermen/gazon: uitvoeringskosten per m2 herberekend, tarief t/m 50m2 vervallen (alleen nog per m2), 2 varianten: herstel door gemeente en herstel door netbeheerder."]

{"sheet":"> 80% slechte bodem","index":7,"n_rows":94,"n_cols":13,"rows_kept":94,"cut":false,"hidden":false,"merged":[[89,0,89,12],[90,0,90,12],[91,0,91,12],[92,0,92,12],[93,0,93,12],[8,0,8,2],[8,10,8,11],[1,0,1,9],[4,0,4,2],[5,0,7,2],[5,3,5,5],[5,6,5,9],[5,10,5,11],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[28,3,28,4],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,11],[9,0,9,2],[20,0,21,0],[20,1,21,6],[20,7,21,9],[20,10,21,12],[31,10,32,12],[37,3,37,4],[40,0,41,0],[40,1,41,6],[40,7,41,9],[40,10,41,12],[58,0,59,0],[58,1,59,6],[58,7,59,9],[31,0,32,0],[31,1,32,6],[31,7,32,9],[46,3,46,4],[49,0,50,0],[49,1,50,6],[49,7,50,9],[55,3,55,4],[67,0,68,0],[67,1,68,6],[67,7,68,9],[73,3,73,4],[76,0,77,0],[76,1,77,7],[76,8,77,9],[80,3,80,4],[80,7,80,9],[81,3,81,4],[81,7,81,9],[64,3,64,4]]}
[]
["RICHTLIJN TARIEVEN (GRAAF)WERKZAAMHEDEN TELECOM",null,null,null,null,null,null,null,null,null,"      Bijlage A5"]
[null,null,null,null,null,null,null,null,"Tarievenblad   ",null,"jaar/versie:",{"$f":"'Invoerblad tarieven'!$G$3","v":"2018 v1"}]
[]
["1. Gegevens gemeente:"]
["Bodemgesteldheid categorie: 5.",null,null,"  Onderhoud",null,null,"Degeneratie",null,null,null,"Beheerskosten:"]
[null,null,null,"factor","rijweg","voetpad","Klinker:          < 15 m2","Klinker:          > 15 m2","Tegels:          < 15 m2","Tegels:          > 15 m2","algemeen"]
[]
["vanaf 80% slechte bodem",null,null,1,0.2,0.15,1.58,0.79,0.56000000000000005,0.64,{"$f":"6/100","v":0.06}]
["2. Overzicht kostenopbouw:"]
[null,null,null,null,"Klinkers:",null,null,"Tegels:",null,null,"Trottoit-","Opsluit-","Berm en"]
[null,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95},null,"band","band","Gazon"]
[null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2","Eenheid: m1","Eenheid: m1","Eenheid: m2"]
["1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$J$61","v":29.21},{"$f":"Moederblad!$J$62","v":23.88},{"$f":"Moederblad!$J$63","v":21.22},{"$f":"Moederblad!$J$64","v":23.21},{"$f":"Moederblad!$J$65","v":17.87},{"$f":"Moederblad!$J$66","v":16.8},{"$f":"Moederblad!J67","v":10.89},{"$f":"Moederblad!J68","v":8.67},{"$f":"Moederblad!J71","v":1.85}]
["2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($F$12*($E$9*E15)+$F$13*($F$9*$E$15),2)","v":5.55},{"$f":"ROUND($F$12*($E$9*$F$15)+$F$13*($F$9*$F$15),2)","v":4.54},{"$f":"ROUND($F$12*($E$9*$G$15)+$F$13*($F$9*$G$15),2)","v":4.03},{"$f":"ROUND($I$12*($F$9*$H$15)+$I$13*($E$9*$H$15),2)","v":3.54},{"$f":"ROUND($I$12*($F$9*$I$15)+$I$13*($E$9*$I$15),2)","v":2.73},{"$f":"ROUND($I$12*($F$9*$J$15)+$I$13*($E$9*$J$15),2)","v":2.56}]
["3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$E$15)/1.185,2)","v":38.950000000000003},null,null,{"$f":"ROUND(($I$9*$H$15)/1.185,2)","v":10.97}]
["3b. Degeneratie:",null,"per m1 sleuflengte",null,null,{"$f":"ROUND(($H$9*$F$15)/1.185,2)","v":15.92},{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":14.15},null,{"$f":"ROUND(($J$9*$I$15)/1.185,2)","v":9.65},{"$f":"ROUND(($J$9*$J$15)/1.185,2)","v":9.07}]
["4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$E$15,2)","v":1.75},{"$f":"ROUND($K$9*$F$15,2)","v":1.43},{"$f":"ROUND($K$9*$G$15,2)","v":1.27},{"$f":"ROUND($K$9*$H$15,2)","v":1.39},{"$f":"ROUND($K$9*$I$15,2)","v":1.07},{"$f":"ROUND($K$9*$J$15,2)","v":1.01},{"$f":"ROUND($K$9*$K$15,2)","v":0.65},{"$f":"ROUND($K$9*$L$15,2)","v":0.52},{"$f":"ROUND($K$9*$M$15,2)","v":0.11}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door de gemeente inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$E$15+$E$16","v":34.76}," per m2","+ per reparatie              ",null,{"$f":"$E$17","v":38.950000000000003},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$H$15+$H$16","v":26.75}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":10.97},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$F$15+$F$16","v":28.419999999999998}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":15.92},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$I$15+$I$16","v":20.6}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":9.65},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$G$15+$G$16","v":25.25}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":14.15},"> 100 m2",{"$f":"+$G$19","v":1.27}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$J$15+$J$16","v":19.36}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":9.07},"> 100 m2",{"$f":"+$J$19","v":1.01}," per m2"]
[null,null,"A7","trottoirband",null,{"$f":"K15","v":10.89},"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"A8","opsluit/koprolband",null,{"$f":"+L15","v":8.67},"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B1.","Herstel en onderhoud door de aanbieder ( 12 maanden garantie)",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":38.950000000000003},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":10.97},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":15.92},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":9.65},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente   ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$E$16","v":5.55}," per m2","+ per reparatie               ",null,{"$f":"$E$17","v":38.950000000000003},"< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$H$16","v":3.54}," per m2","+ per reparatie               ",null,{"$f":"$H$17","v":10.97},"< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$F$16","v":4.54}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$F$18","v":15.92},"> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$I$16","v":2.73}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$I$18","v":9.65},"> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"B7","trottoirband",null,0,"per m1","n.v.t",null,0,null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"B8","opsluit/koprolband",null,0,"per m1","n.v.t.",null,0,null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C.","Herstel door de gemeente voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$15/2)/1.2+$E$16","v":17.720833333333335}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"($H$15/2)/1.2+$H$16","v":13.210833333333333}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":14.489999999999998}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":10.175833333333333}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,{"$f":"($K$15/2)/1.2","v":4.5375000000000005},"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,{"$f":"($L$15/2)/1.2","v":3.6125000000000003},"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C1","Herstel en onderhoud door de aanbieder ( 12 maanden garantie) voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",0," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",0," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",0," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",0," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: C2","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door de gemeente voorafgaand aan gehele herbestrating. ",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers","< 15 m2",{"$f":"($E$16)","v":5.55}," per m2","< 15 m2",{"$f":"+$E$19","v":1.75}," per m2"]
[null,null,"C2","tegels  ","< 15 m2",{"$f":"$H$16","v":3.54}," per m2","< 15 m2",{"$f":"+$H$19","v":1.39}," per m2"]
[null,null,"C3","klinkers","> 15 m2",{"$f":"$F$16","v":4.54}," per m2","> 15 m2",{"$f":"+$F$19","v":1.43}," per m2"]
[null,null,"C4","tegels  ","> 15 m2",{"$f":"$I$16","v":2.73}," per m2","> 15 m2",{"$f":"+$I$19","v":1.07}," per m2"]
[null,null,"C7","trottoirband",null,0,"per m1",null,{"$f":"$K$19","v":0.65}," per m1"]
[null,null,"C8","opsluit/koprolband",null,0,"per m1",null,{"$f":"$L$19","v":0.52}," per m1"]
[]
["Tarief: D.","Overige tarieven, herstel door de gemeente of netbeheerder zoals aangegeven",null,null,null,null,null,null,"Beheerskosten"]
[]
[null,null,"D3","berm / gazon, herstel door gemeente",null,null,null,{"$f":"M15","v":1.85},{"$f":"M19","v":0.11}," per m2"]
[null,null,"D4","berm / gazon, herstel door aanbieder",null,null,null,0,{"$f":"M19","v":0.11}," per m2"]
[null,null,"D5","bomen en struiken",null,null,null,"werkelijke kosten"]
[null,null,"D6","asfalt",null,null,null,"werkelijke kosten"]
[]
["BTW is niet verschuldigd. Zie: Besluit van de Staatsecretaris van Financien dd 19 februari 2004, nr. CPP2003/3098M."]
["Het tarief oppervlak (m2) straatwerk of berm wordt bepaaldt door vermeningvuldiging van lengte x breedte  van de sleuf of  lasgat ( gatvergroting zit in tarief)"]
["Per project is het aantal m2  op de straatwerkbon bepalend voor de toepassing van tarief <15 m2 of > 15 m2. Klinkers en tegels mogen niet bijelkaar worden opgeteld"]
["Meerdere kleine opbrekingen binnen 10 meter, aan één wegkant, worden aangemerkt als één reparatie."]
[]
["Wijzigingen per 1-1-2018:"]
["- Deze tarieven kunnen ook voor netbeheerders, niet zijnde een aanbieder van een elektronisch communicatienet werk worden toegepast, in welk geval 'aanbieder' ook staat voor 'netbeheerder';"]
["- Tarieven voor triottoir-, oplsluit/koprolband verplaatst van tarief D naar A, B1, B2, C, C1 en C2;"]
["- Naast Tarief C (herstel vooruitlopend aan herbestrating) is toegevoegd  C1 (bij herstel en onderhoud door aanbieder) en C2 (herstel door aanbieder en onderhoud door gemeente). Deze C-tarieven gelden alleen indien vooraf afgestemd en de aanbieder maximaal 1 jaar voor de geplande uitvoering van de algehele herbestrating werkt."]
["- Toegevoegd is een richtlijn voor het hanteren van de tarieven indien 'van band tot band' bestraat wordt (tarieven A, B1 en B2 delen door 1,2 en geen degeneratiekosten berekenen). Er is afgezien van het formaliseren van aparte tarieven voor deze gevallen."]
["- Bermen/gazon: uitvoeringskosten per m2 herberekend, tarief t/m 50m2 vervallen (alleen nog per m2), 2 varianten: herstel door gemeente en herstel door netbeheerder."]

{"sheet":"Tabel Tarieven","index":8,"n_rows":664,"n_cols":20,"rows_kept":664,"cut":false,"hidden":false,"merged":[[1,8,4,9],[44,0,46,15],[0,10,0,15],[0,1,0,7],[1,1,3,7],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,10,3,10]]}
["Kostensoort","Tariefgroepen",null,null,null,null,null,null,"Omschrijving","Eenheid",{"$f":"\"Bedragen  \"&'Invoerblad tarieven'!G3 & \" per kostensoort per bodemcategorie\"","v":"Bedragen  2018 v1 per kostensoort per bodemcategorie"}]
["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 degeneratie per reparatie of m1 sleuf",null,"Afh. Cat.?:","Bij  nee zijn de tarieven gelijk in elke kolom: onafhankelijk categorie"]
["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"]
["Degeneratiekosten"]
["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":"'< 50% slechte bodem'!$E$15","v":29.21},{"$f":"'< 50% slechte bodem'!$E$15","v":29.21},{"$f":"'60-70% slechte bodem'!$E$15","v":29.21},{"$f":"'< 50% slechte bodem'!$E$15","v":29.21},{"$f":"'< 50% slechte bodem'!$E$15","v":29.21}]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"klinkers >15 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$F$15","v":23.88},{"$f":"'50-60% slechte bodem'!$F$15","v":23.88},{"$f":"'60-70% slechte bodem'!$F$15","v":23.88},{"$f":"'70-80% slechte bodem'!$F$15","v":23.88},{"$f":"'> 80% slechte bodem'!$F$15","v":23.88}]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"klinkers  >100 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$G$15","v":21.22},{"$f":"'50-60% slechte bodem'!$G$15","v":21.22},{"$f":"'60-70% slechte bodem'!$G$15","v":21.22},{"$f":"'70-80% slechte bodem'!$G$15","v":21.22},{"$f":"'> 80% slechte bodem'!$G$15","v":21.22}]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"tegels   <= 15 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$H$15","v":23.21},{"$f":"'50-60% slechte bodem'!$H$15","v":23.21},{"$f":"'60-70% slechte bodem'!$H$15","v":23.21},{"$f":"'70-80% slechte bodem'!$H$15","v":23.21},{"$f":"'> 80% slechte bodem'!$H$15","v":23.21}]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"tegels   >15 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$I$15","v":17.87},{"$f":"'50-60% slechte bodem'!$I$15","v":17.87},{"$f":"'60-70% slechte bodem'!$I$15","v":17.87},{"$f":"'70-80% slechte bodem'!$I$15","v":17.87},{"$f":"'> 80% slechte bodem'!$I$15","v":17.87}]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"tegels   >100 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$J$15","v":16.8},{"$f":"'50-60% slechte bodem'!$J$15","v":16.8},{"$f":"'60-70% slechte bodem'!$J$15","v":16.8},{"$f":"'70-80% slechte bodem'!$J$15","v":16.8},{"$f":"'> 80% slechte bodem'!$J$15","v":16.8}]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"trottoirband","m1","Nee",{"$f":"'< 50% slechte bodem'!$K$15","v":10.89},{"$f":"'50-60% slechte bodem'!$K$15","v":10.89},{"$f":"'60-70% slechte bodem'!$K$15","v":10.89},{"$f":"'70-80% slechte bodem'!$K$15","v":10.89},{"$f":"'> 80% slechte bodem'!$K$15","v":10.89}]
["Uitvoeringskosten","X ",null,null,null,null,null,null,"opsluit/koprolband","m1","Nee",{"$f":"'< 50% slechte bodem'!$L$15","v":8.67},{"$f":"'50-60% slechte bodem'!$L$15","v":8.67},{"$f":"'60-70% slechte bodem'!$L$15","v":8.67},{"$f":"'70-80% slechte bodem'!$L$15","v":8.67},{"$f":"'> 80% slechte bodem'!$L$15","v":8.67}]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"klinkers <= 15 m2","m2","Nee",{"$f":"ROUND('< 50% slechte bodem'!$E$15/2/1.2,2)","v":12.17},{"$f":"ROUND('50-60% slechte bodem'!$E$15/2/1.2,2)","v":12.17},{"$f":"ROUND('60-70% slechte bodem'!$E$15/2/1.2,2)","v":12.17},{"$f":"ROUND('70-80% slechte bodem'!$E$15/2/1.2,2)","v":12.17},{"$f":"ROUND('> 80% slechte bodem'!$E$15/2/1.2,2)","v":12.17}]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"klinkers >15 m2","m2","Nee",{"$f":"ROUND('< 50% slechte bodem'!$F$15/2/1.2,2)","v":9.9499999999999993},{"$f":"ROUND('50-60% slechte bodem'!$F$15/2/1.2,2)","v":9.9499999999999993},{"$f":"ROUND('60-70% slechte bodem'!$F$15/2/1.2,2)","v":9.9499999999999993},{"$f":"ROUND('70-80% slechte bodem'!$F$15/2/1.2,2)","v":9.9499999999999993},{"$f":"ROUND('> 80% slechte bodem'!$F$15/2/1.2,2)","v":9.9499999999999993}]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"tegels   <= 15 m2","m2","Nee",{"$f":"ROUND('< 50% slechte bodem'!$H$15/2/1.2,2)","v":9.67},{"$f":"ROUND('50-60% slechte bodem'!$H$15/2/1.2,2)","v":9.67},{"$f":"ROUND('60-70% slechte bodem'!$H$15/2/1.2,2)","v":9.67},{"$f":"ROUND('70-80% slechte bodem'!$H$15/2/1.2,2)","v":9.67},{"$f":"ROUND('> 80% slechte bodem'!$H$15/2/1.2,2)","v":9.67}]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"tegels   >15 m2","m2","Nee",{"$f":"ROUND('< 50% slechte bodem'!$I$15/2/1.2,2)","v":7.45},{"$f":"ROUND('50-60% slechte bodem'!$I$15/2/1.2,2)","v":7.45},{"$f":"ROUND('60-70% slechte bodem'!$I$15/2/1.2,2)","v":7.45},{"$f":"ROUND('70-80% slechte bodem'!$I$15/2/1.2,2)","v":7.45},{"$f":"ROUND('> 80% slechte bodem'!$I$15/2/1.2,2)","v":7.45}]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"trottoirband","m1","Nee",{"$f":"ROUND('< 50% slechte bodem'!$K$15/2/1.2,2)","v":4.54},{"$f":"ROUND('50-60% slechte bodem'!$K$15/2/1.2,2)","v":4.54},{"$f":"ROUND('60-70% slechte bodem'!$K$15/2/1.2,2)","v":4.54},{"$f":"ROUND('70-80% slechte bodem'!$K$15/2/1.2,2)","v":4.54},{"$f":"ROUND('> 80% slechte bodem'!$K$15/2/1.2,2)","v":4.54}]
["Uitvoeringskosten",null,null,null,"X ",null,null,null,"opsluit/koprolband","m1","Nee",{"$f":"ROUND('< 50% slechte bodem'!$L$15/2/1.2,2)","v":3.61},{"$f":"ROUND('50-60% slechte bodem'!$L$15/2/1.2,2)","v":3.61},{"$f":"ROUND('60-70% slechte bodem'!$L$15/2/1.2,2)","v":3.61},{"$f":"ROUND('70-80% slechte bodem'!$L$15/2/1.2,2)","v":3.61},{"$f":"ROUND('> 80% slechte bodem'!$L$15/2/1.2,2)","v":3.61}]
["Uitvoeringskosten",null,null,null,null,null,null,"X","berm / gazon, herstel door gemeente","m2","Nee",{"$f":"'< 50% slechte bodem'!$M$15","v":1.85},{"$f":"'50-60% slechte bodem'!$M$15","v":1.85},{"$f":"'60-70% slechte bodem'!$M$15","v":1.85},{"$f":"'70-80% slechte bodem'!$M$15","v":1.85},{"$f":"'> 80% slechte bodem'!$M$15","v":1.85}]
["Onderhoudskosten","X",null,"X",null,null,"X",null,"klinkers <= 15 m2","m2","Ja",{"$f":"'< 50% slechte bodem'!$E$16","v":2.16},{"$f":"'50-60% slechte bodem'!$E$16","v":2.44},{"$f":"'60-70% slechte bodem'!$E$16","v":3.27},{"$f":"'70-80% slechte bodem'!$E$16","v":4.9800000000000004},{"$f":"'> 80% slechte bodem'!$E$16","v":5.55}]
["Onderhoudskosten","X",null,"X",null,null,"X",null,"klinkers >15 m2","m2","Ja",{"$f":"'< 50% slechte bodem'!$F$16","v":1.77},{"$f":"'50-60% slechte bodem'!$F$16","v":1.99},{"$f":"'60-70% slechte bodem'!$F$16","v":2.67},{"$f":"'70-80% slechte bodem'!$F$16","v":4.07},{"$f":"'> 80% slechte bodem'!$F$16","v":4.54}]
["Onderhoudskosten","X",null,null,null,null,null,null,"klinkers  >100 m2 (alleen tarief A)","m2","Ja",{"$f":"'< 50% slechte bodem'!$G$16","v":1.57},{"$f":"'50-60% slechte bodem'!$G$16","v":1.77},{"$f":"'60-70% slechte bodem'!$G$16","v":2.38},{"$f":"'70-80% slechte bodem'!$G$16","v":3.62},{"$f":"'> 80% slechte bodem'!$G$16","v":4.03}]
["Onderhoudskosten","X",null,"X",null,null,"X",null,"tegels   <= 15 m2","m2","Ja",{"$f":"'< 50% slechte bodem'!$H$16","v":1.2},{"$f":"'50-60% slechte bodem'!$H$16","v":1.37},{"$f":"'60-70% slechte bodem'!$H$16","v":1.9},{"$f":"'70-80% slechte bodem'!$H$16","v":3.13},{"$f":"'> 80% slechte bodem'!$H$16","v":3.54}]
["Onderhoudskosten","X",null,"X",null,null,"X",null,"tegels   >15 m2","m2","Ja",{"$f":"'< 50% slechte bodem'!$I$16","v":0.92},{"$f":"'50-60% slechte bodem'!$I$16","v":1.06},{"$f":"'60-70% slechte bodem'!$I$16","v":1.47},{"$f":"'70-80% slechte bodem'!$I$16","v":2.41},{"$f":"'> 80% slechte bodem'!$I$16","v":2.73}]
["Onderhoudskosten","X",null,null,null,null,null,null,"tegels   >100 m2","m2","Ja",{"$f":"'< 50% slechte bodem'!$J$16","v":0.87},{"$f":"'50-60% slechte bodem'!$J$16","v":0.99},{"$f":"'60-70% slechte bodem'!$J$16","v":1.38},{"$f":"'70-80% slechte bodem'!$J$16","v":2.27},{"$f":"'> 80% slechte bodem'!$J$16","v":2.56}]
["Degeneratiekosten","X","X","X",null,null,null,null,"klinkers <= 15 m2","reparatie","Ja",{"$f":"'< 50% slechte bodem'!$E$17","v":7.89},{"$f":"'50-60% slechte bodem'!$E$17","v":11.09},{"$f":"'60-70% slechte bodem'!$E$17","v":20.71},{"$f":"'70-80% slechte bodem'!$E$17","v":31.8},{"$f":"'> 80% slechte bodem'!$E$17","v":38.950000000000003}]
["Degeneratiekosten","X","X","X",null,null,null,null,"klinkers >15 m2","m1 sleuf","Ja",{"$f":"'< 50% slechte bodem'!$F$18","v":2.62},{"$f":"'50-60% slechte bodem'!$F$18","v":3.68},{"$f":"'60-70% slechte bodem'!$F$18","v":6.85},{"$f":"'70-80% slechte bodem'!$F$18","v":13.65},{"$f":"'> 80% slechte bodem'!$F$18","v":15.92}]
["Degeneratiekosten","X",null,null,null,null,null,null,"klinkers  >100 m2 (alleen tarief A)","m1 sleuf","Ja",{"$f":"'< 50% slechte bodem'!$G$18","v":2.33},{"$f":"'50-60% slechte bodem'!$G$18","v":3.27},{"$f":"'60-70% slechte bodem'!$G$18","v":6.09},{"$f":"'70-80% slechte bodem'!$G$18","v":12.13},{"$f":"'> 80% slechte bodem'!$G$18","v":14.15}]
["Degeneratiekosten","X","X","X",null,null,null,null,"tegels   <= 15 m2","reparatie","Ja",{"$f":"'< 50% slechte bodem'!$H$17","v":0},{"$f":"'50-60% slechte bodem'!$H$17","v":0.78},{"$f":"'60-70% slechte bodem'!$H$17","v":3.13},{"$f":"'70-80% slechte bodem'!$H$17","v":9.01},{"$f":"'> 80% slechte bodem'!$H$17","v":10.97}]
["Degeneratiekosten","X","X","X",null,null,null,null,"tegels   >15 m2","m1 sleuf","Ja",{"$f":"'< 50% slechte bodem'!$I$18","v":0},{"$f":"'50-60% slechte bodem'!$I$18","v":0.15},{"$f":"'60-70% slechte bodem'!$I$18","v":0.6},{"$f":"'70-80% slechte bodem'!$I$18","v":7.39},{"$f":"'> 80% slechte bodem'!$I$18","v":9.65}]
["Degeneratiekosten","X",null,null,null,null,null,null,"tegels   >100 m2","m1 sleuf","Ja",{"$f":"'< 50% slechte bodem'!$J$18","v":0},{"$f":"'50-60% slechte bodem'!$J$18","v":0.14000000000000001},{"$f":"'60-70% slechte bodem'!$J$18","v":0.56999999999999995},{"$f":"'70-80% slechte bodem'!$J$18","v":6.95},{"$f":"'> 80% slechte bodem'!$J$18","v":9.07}]
["Beheerskosten","X","X","X","X","X","X",null,"klinkers <= 15 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$E$19","v":1.75},{"$f":"'50-60% slechte bodem'!$E$19","v":1.75},{"$f":"'60-70% slechte bodem'!$E$19","v":1.75},{"$f":"'70-80% slechte bodem'!$E$19","v":1.75},{"$f":"'> 80% slechte bodem'!$E$19","v":1.75}]
["Beheerskosten","X","X","X","X","X","X",null,"klinkers >15 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$F$19","v":1.43},{"$f":"'50-60% slechte bodem'!$F$19","v":1.43},{"$f":"'60-70% slechte bodem'!$F$19","v":1.43},{"$f":"'70-80% slechte bodem'!$F$19","v":1.43},{"$f":"'> 80% slechte bodem'!$F$19","v":1.43}]
["Beheerskosten","X","X","X","X","X","X",null,"klinkers  >100 m2 (alleen tarief A)","m2","Nee",{"$f":"'< 50% slechte bodem'!$G$19","v":1.27},{"$f":"'50-60% slechte bodem'!$G$19","v":1.27},{"$f":"'60-70% slechte bodem'!$G$19","v":1.27},{"$f":"'70-80% slechte bodem'!$G$19","v":1.27},{"$f":"'> 80% slechte bodem'!$G$19","v":1.27}]
["Beheerskosten","X","X","X","X","X","X",null,"tegels   <= 15 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$H$19","v":1.39},{"$f":"'50-60% slechte bodem'!$H$19","v":1.39},{"$f":"'60-70% slechte bodem'!$H$19","v":1.39},{"$f":"'70-80% slechte bodem'!$H$19","v":1.39},{"$f":"'> 80% slechte bodem'!$H$19","v":1.39}]
["Beheerskosten","X","X","X","X","X","X",null,"tegels   >15 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$I$19","v":1.07},{"$f":"'50-60% slechte bodem'!$I$19","v":1.07},{"$f":"'60-70% slechte bodem'!$I$19","v":1.07},{"$f":"'70-80% slechte bodem'!$I$19","v":1.07},{"$f":"'> 80% slechte bodem'!$I$19","v":1.07}]
["Beheerskosten","X","X","X","X","X","X",null,"tegels   >100 m2","m2","Nee",{"$f":"'< 50% slechte bodem'!$J$19","v":1.01},{"$f":"'50-60% slechte bodem'!$J$19","v":1.01},{"$f":"'60-70% slechte bodem'!$J$19","v":1.01},{"$f":"'70-80% slechte bodem'!$J$19","v":1.01},{"$f":"'> 80% slechte bodem'!$J$19","v":1.01}]
["Beheerskosten","X","X","X","X","X","X",null,"trottoirband","m1","Nee",{"$f":"'< 50% slechte bodem'!$K$19","v":0.65},{"$f":"'50-60% slechte bodem'!$K$19","v":0.65},{"$f":"'60-70% slechte bodem'!$K$19","v":0.65},{"$f":"'70-80% slechte bodem'!$K$19","v":0.65},{"$f":"'> 80% slechte bodem'!$K$19","v":0.65}]
["Beheerskosten","X","X","X","X","X","X",null,"opsluit/koprolband","m1","Nee",{"$f":"'< 50% slechte bodem'!$L$19","v":0.52},{"$f":"'50-60% slechte bodem'!$L$19","v":0.52},{"$f":"'60-70% slechte bodem'!$L$19","v":0.52},{"$f":"'70-80% slechte bodem'!$L$19","v":0.52},{"$f":"'> 80% slechte bodem'!$L$19","v":0.52}]
["Beheerskosten",null,null,null,null,null,null,"X","berm / gazon, herstel door gemeente","m2","Nee",{"$f":"'< 50% slechte bodem'!$M$19","v":0.11},{"$f":"'50-60% slechte bodem'!$M$19","v":0.11},{"$f":"'60-70% slechte bodem'!$M$19","v":0.11},{"$f":"'70-80% slechte bodem'!$M$19","v":0.11},{"$f":"'> 80% slechte bodem'!$M$19","v":0.11}]
["Beheerskosten",null,null,null,null,null,null,"X","berm / gazon, herstel door gem of aanb","m2","Nee",{"$f":"'< 50% slechte bodem'!$M$19","v":0.11},{"$f":"'50-60% slechte bodem'!$M$19","v":0.11},{"$f":"'60-70% slechte bodem'!$M$19","v":0.11},{"$f":"'70-80% slechte bodem'!$M$19","v":0.11},{"$f":"'> 80% slechte bodem'!$M$19","v":0.11}]
[]
[]
["De bedragen (L6..P42) vanuit deze brontabel kopiëren (met plakken - waarde) naar het tabblad \"Tabel Tarieven\" van bestand richtlijn-tarieven-graaf-werkzaamheden xxxx      Kopieer ook 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]