{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Printen tarieven","Invoerblad tarieven","Moederblad","< 50% slechte bodem","50-60% slechte bodem","60-70% slechte bodem","70-80% slechte bodem","> 80% slechte bodem"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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,2016]
[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":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,3,3,4],[18,6,24,8],[25,3,25,4],[1,2,1,6]]}
[null,null,"Invoerscherm:"]
[null,null,"Gegevens uit: Uitgave Reed Business Informatie Bouw & Infra."]
[null,null,null,"bijgewerkt dd :","2015-11-26"]
[null,"Boekje: 1","GWW Kosten:","uurtarieven en loonkosten*"]
[null,null,null,"huidige tarief:","in te voeren:"]
[null,null,"Straatmaker groep D, inzittende werkbus, 5% ziekte ",{"$f":"Moederblad!F9","v":34.68},34.68]
[null,null,"Straatmaker groep B, cauffeur werkbus, 5% ziekte   ",{"$f":"Moederblad!F10","v":33},33]
[null,null,"Transport , EVO berekening",{"$f":"Moederblad!F11","v":9.14},9.14]
[]
[null,"Boekje 2:","GWW Kosten:","Funderingslagen en elementverhardingen"]
[null,null,null,"huidige tarief:","in te voeren:"]
[null,null,"Straatstenen, gebakken"]
[null,null,"Straatklinkers WF kwaliteit A4-12 tot en  met 5000 stuks",{"$f":"Moederblad!I22","v":485},485]
[null,null,"Straatklinkers KK 80 kwaliteit A4-12 tot en  met 5000 stuks",{"$f":"Moederblad!I23","v":722},722]
[]
[null,null,"Straatstenen, beton:"]
[null,null,"Betonstraatstenen KF, heide, 210 x 105 x 80 mm volle vracht",{"$f":"Moederblad!I24","v":239},239]
[]
[null,null,"Tegels beton:",null,null,"*","Bij een juiste invoer en acceptatie zijn de tarieven in de kolom:                               - huidige tarief en                                          - in te voeren gelijk !!!"]
[null,null,"Betontegels, 300 x 300 x 45mm komo, grijs",{"$f":"Moederblad!L22","v":8.0299999999999994},8.0299999999999994]
[null,null,"Betontegels, 300 x 300 x 80mm komo, grijs",{"$f":"Moederblad!L23","v":11.55},11.55]
[]
[null,null,"Straatzand:"]
[null,null,"Straatzand 10 - 25m3",{"$f":"Moederblad!L24","v":10.6},10.6]
[]
[null,"Boekje 3:","GWW Kosten:","Groenvoorzieningen"]
[null,null,null,"huidige tarief:","in te voeren:"]
[null,null,"Uurtarief Cultuurtechnisch medewerker",{"$f":"Moederblad!F45","v":29.59},29.59]
[null,null,"Transport , EVO berekening",{"$f":"Moederblad!F46","v":9.14},9.14]
[]
[null,null,"Graszaad, bermmengsel, tot 200kg",{"$f":"Moederblad!D55","v":7.1},7.1]
[null,null,"Graszaad, gazonmengsel, tot 200kg",{"$f":"Moederblad!D56","v":7},7]

{"sheet":"Moederblad","index":2,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[]
["RICHTLIJN TARIEVEN "]
[null,null,null,null,null,null,null,null,"KOSTENSPECIFICATIE"]
[]
["1) UITVOERINGSKOSTEN",null,null,null,null,null,null,null,null,"wijzigd jaarlijks"]
[]
["a) Ploegkosten per "," juli vorig jaar",null,null,null,"Per uur","  "]
[]
["Straatmaker  I","groep D,  Elsevier GWW Kosten ",null,null,null,{"$f":"'Invoerblad tarieven'!E6","v":34.68}]
["Straatmaker  II","groep B,  Idem",null,null,null,{"$f":"'Invoerblad tarieven'!E7","v":33}]
["Transport","EVO-berekening  ",null,null,null,{"$f":"'Invoerblad tarieven'!E8","v":9.14},"incl.kraan"]
[null,null,null,null,null,"--------------------+",null,null,null,""]
[null,null,null,null,null,{"$f":"SUM(F9:F11)","v":76.820000000000007}]
["Alg. kosten winst/risico aannemer",null,null,null,{"$f":"12/100","v":0.12},{"$f":"ROUND(E14*F13,2)","v":9.2200000000000006}]
[null,null,null,null,null,"---------------------+"]
[null,null,null,"TOTAAL per ploeguur ",null,{"$f":"SUM(F13:F14)","v":86.04},"  TOTAAL per manuur ",null,{"$f":"ROUND(F16/2,2)","v":43.02},"",null,""]
[]
[]
["b) kosten materiaal"," juli vorig jaar",null,"kosten   ","breuk","reparatie ","KLINKERS",null,null,"TEGELS"]
["Incl. Magazijntoeslag",{"$f":"15/100","v":0.15},null,"per m2","in %","per m2","materiaalverhouding per 1000",null,null,"materiaalverhouding per m2"]
[]
["K-Klinkers","per m2   ",null,{"$f":"((G22*I22/1000*100)+(G23*I23/1000*50)+(G24*I24/1000*44))*1.15","v":26.714040000000004},0.05,{"$f":"ROUND(E22*D22,2)","v":1.34},0.2,"waal",{"$f":"'Invoerblad tarieven'!E13","v":485},0.95,"Dik 45 mm",{"$f":"'Invoerblad tarieven'!E20","v":8.0299999999999994}]
["T-Tegels ","per m2 ",null,{"$f":"((J22*L22)+(J23*L23))*1.15","v":9.4369000000000014},0.05,{"$f":"ROUND(E23*D23,2)","v":0.47},0.2,"kei",{"$f":"'Invoerblad tarieven'!E14","v":722},0.05,"Dik 80 mm",{"$f":"'Invoerblad tarieven'!E21","v":11.55}]
["Z-Zand ","per m3 ",null,{"$f":"L24*(1+B20)","v":12.19},0.05,{"$f":"ROUND(E24*D24,2)","v":0.61},0.6,"beton",{"$f":"'Invoerblad tarieven'!E17","v":239},null,"Zand p/ m3",{"$f":"'Invoerblad tarieven'!E24","v":10.6}]
[]
["c) kosten totaal"]
["kosten herstraten",null,null,"Reparatie-","Kosten","Uitvoerings-"]
["1e herstel",null,null,"norm p/m2","manuur:","kosten/m2",null,"Gemiddelde toeslag"]
["(A+B)",null,null,"p/manuur",{"$f":"$I$16","v":43.02},"incl. ",null,"i.v.m. verrekening"]
[null,null,null,null,"per m2:","materiaal ","  incl.","GATVERGROTING  (m.u.v.tarief D)"]
[]
["KLINKERS ","<15 m2 (lasgat)",null,0.51,{"$f":"ROUND(D32*$I$16,2)","v":21.94},{"$f":"ROUND((E32+F22+F24)*(1+H32),2)","v":28.67},null,0.2,"Prijzen materialen uit"]
["KLINKERS ",">15 m2 (geul)",null,0.41,17.64,{"$f":"ROUND((E33+F22+F24)*(1+H33),2)","v":23.51},null,0.2,"Elsevier GWW Kosten funderingslagen & "]
["KLINKERS ",">100 m2 (geul)",null,0.36,15.49,{"$f":"ROUND((E34+F22+F24)*(1+H34),2)","v":20.93},null,0.2,"elementenverhardingen  "]
["TEGELS","<15 m2 (lasgat)",null,0.41,17.64,{"$f":"ROUND((E35+F23+F24)*(1+H35),2)","v":22.46},null,0.2]
["TEGELS ",">15 m2 (geul)",null,0.31,13.34,{"$f":"ROUND((E36+F23+F24)*(1+H36),2)","v":17.3},null,0.2]
["TEGELS ",">100 m2 (geul)",null,0.28999999999999998,12.48,{"$f":"ROUND((E37+F23+F24)*(1+H37),2)","v":16.27},null,0.2]
["TROTTOIRBAND","(tegelmat.)",null,0.22,9.4600000000000009,{"$f":"(E38+F23+F24)","v":10.540000000000001}]
["OPSLUITBAND ","(tegelmat.)",null,0.17,7.31,{"$f":"E39+F23+F24","v":8.3899999999999988}]
["ZAAI KLAAR MAKEN","100m2 berm, gazon",null,{"$f":"1.59","v":1.59},{"$f":"ROUND(D40/100*$F$51,2)","v":0.69},{"$f":"((H55+H56)/2+E40)*1.5","v":1.1536875},null,0.5]
["INZAAIEN","100m2 berm, gazon",null,{"$f":"0.945","v":0.94499999999999995},{"$f":"ROUND(D41/100*$F$51,2)","v":0.41},{"$f":"((H55+H56)/2+E41)*1.5","v":0.73368749999999994},null,0.5]
[]
["kosten loon groen "," juli vorig jaar",null,null,null,"Per uur","  "]
[]
["cultuurtechnisch medewerker",null,"Elsevier GWW Kosten ",null,null,{"$f":"'Invoerblad tarieven'!E28","v":29.59},"(met 5% ziekteverzuim)"]
["Transport",null,"EVO-berekening ",null,null,{"$f":"'Invoerblad tarieven'!E29","v":9.14}]
[null,null,null,null,null,"--------------------+"]
[null,null,null,null,null,{"$f":"SUM(F45:F46)","v":38.730000000000004}]
["Alg. kosten winst/risico aannemer",null,null,null,{"$f":"12/100","v":0.12},{"$f":"ROUND(E49*F48,2)","v":4.6500000000000004}]
[null,null,null,null,null,"---------------------+"]
[null,null,null,"TOTAAL per manuur ",null,{"$f":"SUM(F48:F49)","v":43.38}]
[]
["kosten materiaal groen",null,null,"Zaad kosten",null,"gebruik","kosten  ","kosten ","Prijzen zaaimateriaal uit"]
[null,null,null,"per kg",null,"kg/are","per  are","per m2","Elsevier/ GWW Kosten/ Groenvoorzieningen"]
["Graszaad","Bermmengsel ",null,{"$f":"'Invoerblad tarieven'!E31","v":7.1},null,0.75,{"$f":"D55*F55","v":5.3249999999999993},{"$f":"G55/100","v":5.3249999999999992E-2}]
["Graszaad","Gazonmengsel ",null,{"$f":"'Invoerblad tarieven'!E32","v":7},null,1.5,{"$f":"D56*F56","v":10.5},{"$f":"G56/100","v":0.105}]
[]
[]
["2) ONDERHOUD",null,null,null,"Percentage slechte grond "]
[]
[null,null,null,null,"<50%","50-60%","60-70%","70-80%",">80%","5 categorieën van"]
[null,null,null,null,null,null,null,null,null,"bodemgesteldheid "]
["na herstel in % van de totale uitvoeringskosten",null,null,null,null,null,null,null,null,"minder dan 50% slechte bodem"]
["RIJWEGEN       ","(klinkers, tegels)",null,null,0.08,0.09,0.12,0.18,0.2,"tussen 50-60% slechte bodem"]
["VOET-FIETSPADEN","(tegels, klinkers)",null,null,0.05,5.7500000000000002E-2,0.08,0.13250000000000001,0.15,"tussen 60-70% slechte bodem"]
[null,null,null,null,null,null,null,null,null,"tussen 70-80 slechte bodem"]
[null,null,null,null,null,null,null,null,null,"meer dan 80% slechte bodem"]
[]
[]
["3) DEGENERATIE",null,null,null,"Percentage slechte grond "]
[]
[null,null,null,null,"<50%","50-60%","60-70%","70-80%",">80%","5 categorieën van"]
[null,null,null,null,null,null,null,null,null,"bodemgesteldheid "]
["na herstel in % van de totale uitvoeringskosten",null,null,null,null,null,null,null,null,"minder dan 50% slechte bodem"]
["KLINKERS","< 15 m2  (per lasgat)",null,null,0.32,0.45,0.84,1.29,1.58,"tussen 50-60% slechte bodem"]
["KLINKERS","> 15 m2  (per m1 geul)",null,null,0.13,0.1825,0.34,0.67749999999999999,0.79,"tussen 60-70% slechte bodem"]
["TEGELS","< 15 m2  (per lasgat)",null,null,0,0.04,0.16,0.46,0.56000000000000005,"tussen 70-80 slechte bodem"]
["TEGELS","> 15 m2  (per m1 geul)",null,null,0,0.01,0.04,0.49,0.64,"meer dan 80% slechte bodem"]

{"sheet":"< 50% slechte bodem","index":3,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[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],[36,0,37,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],[10,0,10,2],[6,6,7,6],[6,7,7,7],[43,1,44,6],[43,0,44,0],[29,1,30,6],[29,0,30,0],[36,1,37,6],[20,10,21,12],[43,7,44,9],[36,7,37,9],[36,10,37,12],[20,7,21,9],[29,7,30,9],[50,1,51,6],[50,0,51,0],[52,3,52,4],[53,3,53,4],[29,10,30,12],[56,5,56,6],[57,5,57,6],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4]]}
[]
["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   "]
[]
["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,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95}]
[null,null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2"]
[null,"1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$F$32","v":28.67},{"$f":"Moederblad!$F$33","v":23.51},{"$f":"Moederblad!$F$34","v":20.93},{"$f":"Moederblad!$F$35","v":22.46},{"$f":"Moederblad!$F$36","v":17.3},{"$f":"Moederblad!$F$37","v":16.27}]
[null,"2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($G$12*($E$9*F15)+$G$13*($F$9*$F$15),2)","v":2.12},{"$f":"ROUND($G$12*($E$9*$G$15)+$G$13*($F$9*$G$15),2)","v":1.74},{"$f":"ROUND($G$12*($E$9*$H$15)+$G$13*($F$9*$H$15),2)","v":1.55},{"$f":"ROUND($J$12*($F$9*$I$15)+$J$13*($E$9*$I$15),2)","v":1.1599999999999999},{"$f":"ROUND($J$12*($F$9*$J$15)+$J$13*($E$9*$J$15),2)","v":0.89},{"$f":"ROUND($J$12*($F$9*$K$15)+$J$13*($E$9*$K$15),2)","v":0.84}]
[null,"3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$F$15)/1.185,2)","v":7.74},"-,--","-,--",{"$f":"ROUND(($I$9*$I$15)/1.185,2)","v":0},"-,--","-,--"]
[null,"3b. Degeneratie:",null,"per m1 sleuflengte",null,"-,--",{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":2.58},{"$f":"ROUND(($H$9*$H$15)/1.185,2)","v":2.2999999999999998},"-,--",{"$f":"ROUND(($J$9*$J$15)/1.185,2)","v":0},{"$f":"ROUND(($J$9*$K$15)/1.185,2)","v":0}]
[null,"4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$F$15,2)","v":1.72},{"$f":"ROUND($K$9*$G$15,2)","v":1.41},{"$f":"ROUND($K$9*$H$15,2)","v":1.26},{"$f":"ROUND($K$9*$I$15,2)","v":1.35},{"$f":"ROUND($K$9*$J$15,2)","v":1.04},{"$f":"ROUND($K$9*$K$15,2)","v":0.98}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door wegbeheerder inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$F$15+$F$16","v":30.790000000000003}," per m2","+ per reparatie              ",null,{"$f":"$F$17","v":7.74},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$I$15+$I$16","v":23.62}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":0},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$G$15+$G$16","v":25.25}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":2.58},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$J$15+$J$16","v":18.190000000000001}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$H$15+$H$16","v":22.48}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$H$18","v":2.2999999999999998},"> 100 m2",{"$f":"+$H$19","v":1.26}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$K$15+$K$16","v":17.11}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$K$18","v":0},"> 100 m2",{"$f":"+$K$19","v":0.98}," per m2"]
[]
["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":"$F$17","v":7.74},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":0},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":2.58},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door wegbeheerder   ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$F$16","v":2.12}," per m2","+ per reparatie               ",null,{"$f":"$F$17","v":7.74},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$I$16","v":1.1599999999999999}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":0},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$G$16","v":1.74}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":2.58},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$J$16","v":0.89}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: C.","Herstel door de wegbeheerder voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers ","< 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":14.065833333333334}," per m2","< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"C2","tegels   ","< 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":10.518333333333334}," per m2","< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"C3","klinkers ","> 15 m2",{"$f":"($G$15/2)/1.2+$G$16","v":11.535833333333334}," per m2","> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"C4","tegels   ","> 15 m2",{"$f":"($J$15/2)/1.2+$J$16","v":8.0983333333333345}," per m2","> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: D.","Overige tarieven (herstel/onderhoud door wegbeheerder)"]
[]
[null,null,"D1","trottoirband",null,{"$f":"Moederblad!$F$38+($K$9*Moederblad!$F$38)","v":11.172400000000001}," per m1"]
[null,null,"D2","opsluit-, koprolband",null,{"$f":"Moederblad!$F$39+($K$9*Moederblad!$F$39)","v":8.893399999999998}," per m1"]
[null,null,"D3","berm / gazon < 50 m2",null,{"$f":"(+$F$56*100)/2","v":100.03087500000001},"/ reparatie"]
[null,null,"D4","berm / gazon > 50 m2",null,{"$f":"+Moederblad!$F$40+Moederblad!$F$41+($K$9*(Moederblad!$F$40+Moederblad!$F$41))","v":2.0006175000000002}," per m2"]
[null,null,"D5","bomen en struiken",null,"werkelijke kosten"]
[null,null,"D6","asfalt",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."]

{"sheet":"50-60% slechte bodem","index":4,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[57,3,57,4],[57,5,57,6],[36,0,37,0],[36,1,37,6],[50,0,51,0],[56,3,56,4],[56,5,56,6],[54,3,54,4],[55,3,55,4],[50,1,51,6],[52,3,52,4],[53,3,53,4],[29,0,30,0],[29,1,30,6],[29,7,30,9],[36,7,37,9],[1,0,1,9],[4,0,4,2],[5,0,7,2],[5,3,5,5],[5,6,5,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[5,10,5,11],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,10,7,11],[8,0,8,2],[10,0,10,2],[8,10,8,11],[43,0,44,0],[43,1,44,6],[43,7,44,9],[20,0,21,0],[20,1,21,6],[20,7,21,9],[20,10,21,12],[29,10,30,12],[36,10,37,12]]}
[]
["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    "]
[]
["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"]
[]
["50 - 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,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95}]
[null,null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2"]
[null,"1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$F$32","v":28.67},{"$f":"Moederblad!$F$33","v":23.51},{"$f":"Moederblad!$F$34","v":20.93},{"$f":"Moederblad!$F$35","v":22.46},{"$f":"Moederblad!$F$36","v":17.3},{"$f":"Moederblad!$F$37","v":16.27}]
[null,"2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($G$12*($E$9*F15)+$G$13*($F$9*$F$15),2)","v":2.39},{"$f":"ROUND($G$12*($E$9*$G$15)+$G$13*($F$9*$G$15),2)","v":1.96},{"$f":"ROUND($G$12*($E$9*$H$15)+$G$13*($F$9*$H$15),2)","v":1.75},{"$f":"ROUND($J$12*($F$9*$I$15)+$J$13*($E$9*$I$15),2)","v":1.33},{"$f":"ROUND($J$12*($F$9*$J$15)+$J$13*($E$9*$J$15),2)","v":1.02},{"$f":"ROUND($J$12*($F$9*$K$15)+$J$13*($E$9*$K$15),2)","v":0.96}]
[null,"3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$F$15)/1.185,2)","v":10.89},"-,--","-,--",{"$f":"ROUND(($I$9*$I$15)/1.185,2)","v":0.76},"-,--","-,--"]
[null,"3b. Degeneratie:",null,"per m1 sleuflengte",null,"-,--",{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":3.62},{"$f":"ROUND(($H$9*$H$15)/1.185,2)","v":3.22},"-,--",{"$f":"ROUND(($J$9*$J$15)/1.185,2)","v":0.15},{"$f":"ROUND(($J$9*$K$15)/1.185,2)","v":0.14000000000000001}]
[null,"4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$F$15,2)","v":1.72},{"$f":"ROUND($K$9*$G$15,2)","v":1.41},{"$f":"ROUND($K$9*$H$15,2)","v":1.26},{"$f":"ROUND($K$9*$I$15,2)","v":1.35},{"$f":"ROUND($K$9*$J$15,2)","v":1.04},{"$f":"ROUND($K$9*$K$15,2)","v":0.98}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door wegbeheerder inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$F$15+$F$16","v":31.060000000000002}," per m2","+ per reparatie              ",null,{"$f":"$F$17","v":10.89},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$I$15+$I$16","v":23.79}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":0.76},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$G$15+$G$16","v":25.470000000000002}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":3.62},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$J$15+$J$16","v":18.32}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0.15},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$H$15+$H$16","v":22.68}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$H$18","v":3.22},"> 100 m2",{"$f":"+$H$19","v":1.26}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$K$15+$K$16","v":17.23}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$K$18","v":0.14000000000000001},"> 100 m2",{"$f":"+$K$19","v":0.98}," per m2"]
[]
["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":"$F$17","v":10.89},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":0.76},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":3.62},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0.15},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door wegbeheerder   ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$F$16","v":2.39}," per m2","+ per reparatie               ",null,{"$f":"$F$17","v":10.89},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$I$16","v":1.33}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":0.76},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$G$16","v":1.96}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":3.62},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$J$16","v":1.02}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0.15},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: C.","Herstel door de wegbeheerder voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers ","< 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":14.335833333333335}," per m2","< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"C2","tegels   ","< 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":10.688333333333334}," per m2","< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"C3","klinkers ","> 15 m2",{"$f":"($G$15/2)/1.2+$G$16","v":11.755833333333335}," per m2","> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"C4","tegels   ","> 15 m2",{"$f":"($J$15/2)/1.2+$J$16","v":8.2283333333333335}," per m2","> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: D.","Overige tarieven (herstel/onderhoud door wegbeheerder)"]
[]
[null,null,"D1","trottoirband",null,{"$f":"Moederblad!$F$38+($K$9*Moederblad!$F$38)","v":11.172400000000001}," per m1"]
[null,null,"D2","opsluit-, koprolband",null,{"$f":"Moederblad!$F$39+($K$9*Moederblad!$F$39)","v":8.893399999999998}," per m1"]
[null,null,"D3","berm / gazon < 50 m2",null,{"$f":"(+$F$56*100)/2","v":100.03087500000001},"/ reparatie"]
[null,null,"D4","berm / gazon > 50 m2",null,{"$f":"+Moederblad!$F$40+Moederblad!$F$41+($K$9*(Moederblad!$F$40+Moederblad!$F$41))","v":2.0006175000000002}," per m2"]
[null,null,"D5","bomen en struiken",null,"werkelijke kosten"]
[null,null,"D6","asfalt",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."]

{"sheet":"60-70% slechte bodem","index":5,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[56,3,56,4],[56,5,56,6],[57,3,57,4],[57,5,57,6],[36,0,37,0],[36,1,37,6],[54,3,54,4],[55,3,55,4],[53,3,53,4],[36,10,37,12],[29,0,30,0],[29,1,30,6],[20,0,21,0],[20,1,21,6],[20,7,21,9],[20,10,21,12],[29,10,30,12],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,11],[8,10,8,11],[5,10,5,11],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[52,3,52,4],[1,0,1,9],[4,0,4,2],[5,0,7,2],[5,3,5,5],[5,6,5,9],[8,0,8,2],[29,7,30,9],[10,0,10,2],[36,7,37,9],[43,7,44,9],[50,0,51,0],[50,1,51,6],[43,0,44,0],[43,1,44,6]]}
[]
["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    "]
[]
["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"]
[]
["60 - 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,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95}]
[null,null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2"]
[null,"1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$F$32","v":28.67},{"$f":"Moederblad!$F$33","v":23.51},{"$f":"Moederblad!$F$34","v":20.93},{"$f":"Moederblad!$F$35","v":22.46},{"$f":"Moederblad!$F$36","v":17.3},{"$f":"Moederblad!$F$37","v":16.27}]
[null,"2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($G$12*($E$9*F15)+$G$13*($F$9*$F$15),2)","v":3.21},{"$f":"ROUND($G$12*($E$9*$G$15)+$G$13*($F$9*$G$15),2)","v":2.63},{"$f":"ROUND($G$12*($E$9*$H$15)+$G$13*($F$9*$H$15),2)","v":2.34},{"$f":"ROUND($J$12*($F$9*$I$15)+$J$13*($E$9*$I$15),2)","v":1.84},{"$f":"ROUND($J$12*($F$9*$J$15)+$J$13*($E$9*$J$15),2)","v":1.42},{"$f":"ROUND($J$12*($F$9*$K$15)+$J$13*($E$9*$K$15),2)","v":1.33}]
[null,"3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$F$15)/1.185,2)","v":20.32},"-,--","-,--",{"$f":"ROUND(($I$9*$I$15)/1.185,2)","v":3.03},"-,--","-,--"]
[null,"3b. Degeneratie:",null,"per m1 sleuflengte",null,"-,--",{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":6.75},{"$f":"ROUND(($H$9*$H$15)/1.185,2)","v":6.01},"-,--",{"$f":"ROUND(($J$9*$J$15)/1.185,2)","v":0.57999999999999996},{"$f":"ROUND(($J$9*$K$15)/1.185,2)","v":0.55000000000000004}]
[null,"4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$F$15,2)","v":1.72},{"$f":"ROUND($K$9*$G$15,2)","v":1.41},{"$f":"ROUND($K$9*$H$15,2)","v":1.26},{"$f":"ROUND($K$9*$I$15,2)","v":1.35},{"$f":"ROUND($K$9*$J$15,2)","v":1.04},{"$f":"ROUND($K$9*$K$15,2)","v":0.98}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door wegbeheerder inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$F$15+$F$16","v":31.880000000000003}," per m2","+ per reparatie              ",null,{"$f":"$F$17","v":20.32},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$I$15+$I$16","v":24.3}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":3.03},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$G$15+$G$16","v":26.14}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":6.75},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$J$15+$J$16","v":18.72}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0.57999999999999996},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$H$15+$H$16","v":23.27}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$H$18","v":6.01},"> 100 m2",{"$f":"+$H$19","v":1.26}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$K$15+$K$16","v":17.600000000000001}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$K$18","v":0.55000000000000004},"> 100 m2",{"$f":"+$K$19","v":0.98}," per m2"]
[]
["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":"$F$17","v":20.32},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":3.03},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":6.75},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0.57999999999999996},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door wegbeheerder   ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$F$16","v":3.21}," per m2","+ per reparatie               ",null,{"$f":"$F$17","v":20.32},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$I$16","v":1.84}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":3.03},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$G$16","v":2.63}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":6.75},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$J$16","v":1.42}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":0.57999999999999996},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: C.","Herstel door de wegbeheerder voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers ","< 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":15.155833333333334}," per m2","< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"C2","tegels   ","< 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":11.198333333333334}," per m2","< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"C3","klinkers ","> 15 m2",{"$f":"($G$15/2)/1.2+$G$16","v":12.425833333333333}," per m2","> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"C4","tegels   ","> 15 m2",{"$f":"($J$15/2)/1.2+$J$16","v":8.6283333333333339}," per m2","> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: D.","Overige tarieven (herstel/onderhoud door wegbeheerder)"]
[]
[null,null,"D1","trottoirband",null,{"$f":"Moederblad!$F$38+($K$9*Moederblad!$F$38)","v":11.172400000000001}," per m1"]
[null,null,"D2","opsluit-, koprolband",null,{"$f":"Moederblad!$F$39+($K$9*Moederblad!$F$39)","v":8.893399999999998}," per m1"]
[null,null,"D3","berm / gazon < 50 m2",null,{"$f":"(+$F$56*100)/2","v":100.03087500000001},"/ reparatie"]
[null,null,"D4","berm / gazon > 50 m2",null,{"$f":"+Moederblad!$F$40+Moederblad!$F$41+($K$9*(Moederblad!$F$40+Moederblad!$F$41))","v":2.0006175000000002}," per m2"]
[null,null,"D5","bomen en struiken",null,"werkelijke kosten"]
[null,null,"D6","asfalt",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."]

{"sheet":"70-80% slechte bodem","index":6,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[36,0,37,0],[36,1,37,6],[36,7,37,9],[36,10,37,12],[55,3,55,4],[43,0,44,0],[43,1,44,6],[43,7,44,9],[20,10,21,12],[8,0,8,2],[29,10,30,12],[8,10,8,11],[10,0,10,2],[29,0,30,0],[29,1,30,6],[29,7,30,9],[20,0,21,0],[20,1,21,6],[1,0,1,9],[4,0,4,2],[5,0,7,2],[5,3,5,5],[5,6,5,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[20,7,21,9],[5,10,5,11],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,10,7,11],[57,3,57,4],[57,5,57,6],[50,0,51,0],[50,1,51,6],[52,3,52,4],[53,3,53,4],[54,3,54,4],[56,3,56,4],[56,5,56,6]]}
[]
["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    "]
[]
["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"]
[]
["70 - 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,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95}]
[null,null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2"]
[null,"1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$F$32","v":28.67},{"$f":"Moederblad!$F$33","v":23.51},{"$f":"Moederblad!$F$34","v":20.93},{"$f":"Moederblad!$F$35","v":22.46},{"$f":"Moederblad!$F$36","v":17.3},{"$f":"Moederblad!$F$37","v":16.27}]
[null,"2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($G$12*($E$9*F15)+$G$13*($F$9*$F$15),2)","v":4.8899999999999997},{"$f":"ROUND($G$12*($E$9*$G$15)+$G$13*($F$9*$G$15),2)","v":4.01},{"$f":"ROUND($G$12*($E$9*$H$15)+$G$13*($F$9*$H$15),2)","v":3.57},{"$f":"ROUND($J$12*($F$9*$I$15)+$J$13*($E$9*$I$15),2)","v":3.03},{"$f":"ROUND($J$12*($F$9*$J$15)+$J$13*($E$9*$J$15),2)","v":2.33},{"$f":"ROUND($J$12*($F$9*$K$15)+$J$13*($E$9*$K$15),2)","v":2.19}]
[null,"3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$F$15)/1.185,2)","v":31.21},"-,--","-,--",{"$f":"ROUND(($I$9*$I$15)/1.185,2)","v":8.7200000000000006},"-,--","-,--"]
[null,"3b. Degeneratie:",null,"per m1 sleuflengte",null,"-,--",{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":13.44},{"$f":"ROUND(($H$9*$H$15)/1.185,2)","v":11.97},"-,--",{"$f":"ROUND(($J$9*$J$15)/1.185,2)","v":7.15},{"$f":"ROUND(($J$9*$K$15)/1.185,2)","v":6.73}]
[null,"4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$F$15,2)","v":1.72},{"$f":"ROUND($K$9*$G$15,2)","v":1.41},{"$f":"ROUND($K$9*$H$15,2)","v":1.26},{"$f":"ROUND($K$9*$I$15,2)","v":1.35},{"$f":"ROUND($K$9*$J$15,2)","v":1.04},{"$f":"ROUND($K$9*$K$15,2)","v":0.98}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door wegbeheerder inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$F$15+$F$16","v":33.56}," per m2","+ per reparatie              ",null,{"$f":"$F$17","v":31.21},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$I$15+$I$16","v":25.490000000000002}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":8.7200000000000006},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$G$15+$G$16","v":27.520000000000003}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":13.44},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$J$15+$J$16","v":19.630000000000003}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":7.15},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$H$15+$H$16","v":24.5}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$H$18","v":11.97},"> 100 m2",{"$f":"+$H$19","v":1.26}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$K$15+$K$16","v":18.46}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$K$18","v":6.73},"> 100 m2",{"$f":"+$K$19","v":0.98}," per m2"]
[]
["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":"$F$17","v":31.21},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":8.7200000000000006},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":13.44},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":7.15},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door wegbeheerder   ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$F$16","v":4.8899999999999997}," per m2","+ per reparatie               ",null,{"$f":"$F$17","v":31.21},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$I$16","v":3.03}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":8.7200000000000006},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$G$16","v":4.01}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":13.44},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$J$16","v":2.33}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":7.15},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: C.","Herstel door de wegbeheerder voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers ","< 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":16.835833333333333}," per m2","< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"C2","tegels   ","< 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":12.388333333333334}," per m2","< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"C3","klinkers ","> 15 m2",{"$f":"($G$15/2)/1.2+$G$16","v":13.805833333333334}," per m2","> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"C4","tegels   ","> 15 m2",{"$f":"($J$15/2)/1.2+$J$16","v":9.538333333333334}," per m2","> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: D.","Overige tarieven (herstel/onderhoud door wegbeheerder)"]
[]
[null,null,"D1","trottoirband",null,{"$f":"Moederblad!$F$38+($K$9*Moederblad!$F$38)","v":11.172400000000001}," per m1"]
[null,null,"D2","opsluit-, koprolband",null,{"$f":"Moederblad!$F$39+($K$9*Moederblad!$F$39)","v":8.893399999999998}," per m1"]
[null,null,"D3","berm / gazon < 50 m2",null,{"$f":"(+$F$56*100)/2","v":100.03087500000001},"/ reparatie"]
[null,null,"D4","berm / gazon > 50 m2",null,{"$f":"+Moederblad!$F$40+Moederblad!$F$41+($K$9*(Moederblad!$F$40+Moederblad!$F$41))","v":2.0006175000000002}," per m2"]
[null,null,"D5","bomen en struiken",null,"werkelijke kosten"]
[null,null,"D6","asfalt",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."]

{"sheet":"> 80% slechte bodem","index":7,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[57,3,57,4],[57,5,57,6],[50,0,51,0],[50,1,51,6],[52,3,52,4],[56,3,56,4],[56,5,56,6],[55,3,55,4],[53,3,53,4],[54,3,54,4],[8,10,8,11],[10,0,10,2],[20,0,21,0],[20,1,21,6],[20,7,21,9],[20,10,21,12],[8,0,8,2],[29,7,30,9],[29,10,30,12],[36,0,37,0],[36,1,37,6],[36,7,37,9],[36,10,37,12],[29,0,30,0],[5,10,5,11],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,11],[43,7,44,9],[1,0,1,9],[4,0,4,2],[5,0,7,2],[5,3,5,5],[5,6,5,9],[29,1,30,6],[43,0,44,0],[43,1,44,6]]}
[]
["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   "]
[]
["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"]
[]
["meer dan 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,null,null,null,"Rijweg",{"$f":"80/100","v":0.8},null,"Voetpad",{"$f":"95/100","v":0.95}]
[null,null,null,null,null,"Voetpad",{"$f":"20/100","v":0.2},null,"Rijweg",{"$f":"5/100","v":0.05}]
[null,null,null,null,null,"<15 m2",">15 m2",">100 m2","<15 m2",">15 m2",">100 m2"]
[null,"1.  Uitvoering:",null,"per m2",null,{"$f":"Moederblad!$F$32","v":28.67},{"$f":"Moederblad!$F$33","v":23.51},{"$f":"Moederblad!$F$34","v":20.93},{"$f":"Moederblad!$F$35","v":22.46},{"$f":"Moederblad!$F$36","v":17.3},{"$f":"Moederblad!$F$37","v":16.27}]
[null,"2.  Onderhoud:",null,"per m2",null,{"$f":"ROUND($G$12*($E$9*F15)+$G$13*($F$9*$F$15),2)","v":5.45},{"$f":"ROUND($G$12*($E$9*$G$15)+$G$13*($F$9*$G$15),2)","v":4.47},{"$f":"ROUND($G$12*($E$9*$H$15)+$G$13*($F$9*$H$15),2)","v":3.98},{"$f":"ROUND($J$12*($F$9*$I$15)+$J$13*($E$9*$I$15),2)","v":3.43},{"$f":"ROUND($J$12*($F$9*$J$15)+$J$13*($E$9*$J$15),2)","v":2.64},{"$f":"ROUND($J$12*($F$9*$K$15)+$J$13*($E$9*$K$15),2)","v":2.48}]
[null,"3a. Degeneratie:",null,"per reparatie",null,{"$f":"ROUND(($G$9*$F$15)/1.185,2)","v":38.229999999999997},"-,--","-,--",{"$f":"ROUND(($I$9*$I$15)/1.185,2)","v":10.61},"-,--","-,--"]
[null,"3b. Degeneratie:",null,"per m1 sleuflengte",null,"-,--",{"$f":"ROUND(($H$9*$G$15)/1.185,2)","v":15.67},{"$f":"ROUND(($H$9*$H$15)/1.185,2)","v":13.95},"-,--",{"$f":"ROUND(($J$9*$J$15)/1.185,2)","v":9.34},{"$f":"ROUND(($J$9*$K$15)/1.185,2)","v":8.7899999999999991}]
[null,"4.  Beheerskosten:",null,"per m2 ",null,{"$f":"ROUND($K$9*$F$15,2)","v":1.72},{"$f":"ROUND($K$9*$G$15,2)","v":1.41},{"$f":"ROUND($K$9*$H$15,2)","v":1.26},{"$f":"ROUND($K$9*$I$15,2)","v":1.35},{"$f":"ROUND($K$9*$J$15,2)","v":1.04},{"$f":"ROUND($K$9*$K$15,2)","v":0.98}]
["3. Tarieven:"]
["Tarief: A.","Herstel,  onderhoud, uitgevoerd door wegbeheerder inclusief beheerskosten        ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"A1","klinkers","< 15 m2",{"$f":"$F$15+$F$16","v":34.120000000000005}," per m2","+ per reparatie              ",null,{"$f":"$F$17","v":38.229999999999997},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"A2","tegels  ","< 15 m2",{"$f":"$I$15+$I$16","v":25.89}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":10.61},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"A3","klinkers","> 15 m2",{"$f":"$G$15+$G$16","v":27.98}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":15.67},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"A4","tegels  ","> 15 m2",{"$f":"$J$15+$J$16","v":19.940000000000001}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":9.34},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[null,null,"A5","klinkers ","> 100 m2",{"$f":"$H$15+$H$16","v":24.91}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$H$18","v":13.95},"> 100 m2",{"$f":"+$H$19","v":1.26}," per m2"]
[null,null,"A6","tegels   ","> 100 m2",{"$f":"$K$15+$K$16","v":18.75}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$K$18","v":8.7899999999999991},"> 100 m2",{"$f":"+$K$19","v":0.98}," per m2"]
[]
["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":"$F$17","v":38.229999999999997},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",0," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":10.61},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":15.67},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",0," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":9.34},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: B2.","Herstel door de aanbieder (12 mnd.garantie) en onderhoud door wegbeheerder   ",null,null,null,null,null,"Degeneratie:",null,null,"Beheerskosten:"]
[]
[null,null,"B1","klinkers","< 15 m2",{"$f":"$F$16","v":5.45}," per m2","+ per reparatie               ",null,{"$f":"$F$17","v":38.229999999999997},"< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"B2","tegels  ","< 15 m2",{"$f":"$I$16","v":3.43}," per m2","+ per reparatie               ",null,{"$f":"$I$17","v":10.61},"< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"B3","klinkers","> 15 m2",{"$f":"$G$16","v":4.47}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$G$18","v":15.67},"> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"B4","tegels  ","> 15 m2",{"$f":"$J$16","v":2.64}," per m2","+ per m1 sleuflengte   ",null,{"$f":"$J$18","v":9.34},"> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: C.","Herstel door de wegbeheerder voorafgaand aan gehele herbestrating.",null,null,null,null,null,"Beheerskosten:"]
[]
[null,null,"C1","klinkers ","< 15 m2",{"$f":"($F$15/2)/1.2+$F$16","v":17.395833333333336}," per m2","< 15 m2",{"$f":"+$F$19","v":1.72}," per m2"]
[null,null,"C2","tegels   ","< 15 m2",{"$f":"($I$15/2)/1.2+$I$16","v":12.788333333333334}," per m2","< 15 m2",{"$f":"+$I$19","v":1.35}," per m2"]
[null,null,"C3","klinkers ","> 15 m2",{"$f":"($G$15/2)/1.2+$G$16","v":14.265833333333333}," per m2","> 15 m2",{"$f":"+$G$19","v":1.41}," per m2"]
[null,null,"C4","tegels   ","> 15 m2",{"$f":"($J$15/2)/1.2+$J$16","v":9.8483333333333345}," per m2","> 15 m2",{"$f":"+$J$19","v":1.04}," per m2"]
[]
["Tarief: D.","Overige tarieven (herstel/onderhoud door wegbeheerder)"]
[]
[null,null,"D1","trottoirband",null,{"$f":"Moederblad!$F$38+($K$9*Moederblad!$F$38)","v":11.172400000000001}," per m1"]
[null,null,"D2","opsluit-, koprolband",null,{"$f":"Moederblad!$F$39+($K$9*Moederblad!$F$39)","v":8.893399999999998}," per m1"]
[null,null,"D3","berm / gazon < 50 m2",null,{"$f":"(+$F$56*100)/2","v":100.03087500000001},"/ reparatie"]
[null,null,"D4","berm / gazon > 50 m2",null,{"$f":"+Moederblad!$F$40+Moederblad!$F$41+($K$9*(Moederblad!$F$40+Moederblad!$F$41))","v":2.0006175000000002}," per m2"]
[null,null,"D5","bomen en struiken",null,"werkelijke kosten"]
[null,null,"D6","asfalt",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."]