{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Macro","fietspaden","haltes","duurzaam veilig"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Macro","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"fietspaden","index":1,"n_rows":92,"n_cols":15,"rows_kept":92,"cut":false,"hidden":false,"merged":[[45,6,45,7],[5,6,5,7],[5,9,5,10],[5,12,5,13],[24,9,24,10],[36,6,36,7],[36,9,36,10],[36,12,36,13],[45,12,45,13],[45,9,45,10]]}
[]
[null,"Aanvrager",null,null,null,null,null,"standaard opslag in %",null,null,null,null,0.8,{"$f":"IF(M2=80%,\"\",\"onderbouwing opslagen bijvoegen\")","v":""}]
[null,"Traject",null,null,null,null,null,"aanvullende opslagen IV97 t/m 99",null,null,null,null,"nee",{"$f":"IF(M3=\"nee\",\"\",\"onderbouwing opslagen bijvoegen\")","v":""}]
[null,"km",null,"km",null,null,null,"bijzondere kosten IV01 t/m 90",null,null,null,null,"nee",{"$f":"IF(M4=\"nee\",\"\",\"onderbouwing bijvoegen\")","v":""}]
[]
[null,"I.  Verhardingen",null,null,null,1,"Nieuwbouw/Verbreden",null,1,"Renovatie",null,1,"Slopen en afwerken",null,"subTOTAAL € "]
[null,null,null,"B=","kleurtoeslag nee","EHP [DirK]","L  m1","kosten € ","EHP [DirK]","L  m1","kosten € ","EHP [DirK]","L  m1","kosten € ",{"$f":"SUM(O8:O34)","v":0}]
[null,"I.11","tegels (7 cm)",1.5,"[m]   B < 2,00 m",58.673011111111116,null,{"$f":"ROUNDUP(+G8*$D8*F$6*IF($E$7=\"kleurtoeslag ja\",$F8+1.5,$F8),-1)","v":0},36.87316666666667,null,{"$f":"ROUNDUP(+J8*$D8*I$6*IF($E$7=\"kleurtoeslag ja\",I$8+1.5,I$8),-1)","v":0},18.91011111111111,null,{"$f":"ROUNDUP(+M8*L8*$D8*L$6,-1)","v":0},{"$f":"+N8+K8+H8","v":0}]
[null,"I.12",null,2.5,"[m]   B= 2,00 - 4,00 m",49.981455555555563,null,{"$f":"ROUNDUP(+G9*$D9*F$6*IF($E$7=\"kleurtoeslag ja\",$F9+1.5,$F9),-1)","v":0},29.17,null,{"$f":"ROUNDUP(+J9*$D9*I$6*IF($E$7=\"kleurtoeslag ja\",I$8+1.5,I$8),-1)","v":0},15.385666666666669,null,{"$f":"ROUNDUP(+M9*L9*$D9*L$6,-1)","v":0},{"$f":"+N9+K9+H9","v":0}]
[null,"I.13",null,1.5,"[m] verbreden",58.673011111111116,null,0,null,null,null,null,null,null,{"$f":"+N10+K10+H10","v":0}]
[null,"I.14",null,2.5,"[m] verwijderen tegels",null,null,null,14.15,null,{"$f":"ROUNDUP(+J11*I11*$D11*I$6,-1)","v":0},null,null,null,{"$f":"+N11+K11+H11","v":0}]
[]
[null,"I.31","asfalt zwart",1.5,"[m]   B < 2,00 m",43.943666666666672,null,{"$f":"ROUNDUP(+G13*F13*$D13*F$6,-1)","v":0},27.86,null,{"$f":"ROUNDUP(+J13*I13*$D13*I$6,-1)","v":0},16.518055555555556,null,{"$f":"ROUNDUP(+M13*L13*$D13*L$6,-1)","v":0},{"$f":"+N13+K13+H13","v":0}]
[null,"I.32",null,2.5,"[m]   B= 2,00 - 2,99 m",42.536999999999999,null,0,27.502999999999997,null,0,16.518055555555556,null,0,0]
[null,"I.33",null,3.5,"[m]   B= 3,00 - 4,00 m",39.670571428571428,null,0,25.505714285714287,null,0,16.518055555555556,null,0,0]
[null,"I.34",null,4.5,"[m]   B > 4,00 m",39.394222222222218,null,0,25.505714285714287,null,0,16.518055555555556,null,0,{"$f":"+N16+K16+H16","v":0}]
[null,"I.35",null,2,"[m] verbreden",75.789638888888888,null,0,null,null,null,null,null,null,0]
[]
[null,"I.41","asfalt rood",1.5,"B < 2,00",51.792833333333334,null,0,37.299999999999997,null,{"$f":"ROUNDUP(+J19*I19*$D19*I$6,-1)","v":0},16.518055555555556,null,{"$f":"ROUNDUP(+M19*L19*$D19*L$6,-1)","v":0},{"$f":"+N19+K19+H19","v":0}]
[null,"I.42",null,2.5,"B= 2,00 - 2,99",50.009499999999996,null,0,36.479500000000002,null,0,16.518055555555556,null,0,0]
[null,"I.43",null,3.5,"B= 3,00 - 4,00",46.336642857142863,null,0,32.743214285714288,null,0,16.518055555555556,null,0,0]
[null,"I.44",null,4.3,"B > 4,00",46.18727777777778,null,0,32.558611111111105,null,0,16.518055555555556,null,0,{"$f":"+N22+K22+H22","v":0}]
[null,"I.45",null,1.5,"[m] verbreden",97.068388888888876,null,0,null,null,null,null,null,null,0]
[]
[null,"onderhoud",null,0.15,"van het oppervlak",null,null,null,null,"Onderhoud"]
[null,null,null,"B=",null,"EHP [DirK]",null,null,"EHP [DirK]","L  m1","kosten € ","EHP [DirK]"]
[null,"I.51","klein (/7 jr)",2.5,"tegels",null,null,null,32.09180555555556,null,{"$f":"ROUNDUP(+J27*I27*$D27*I$6,-1)","v":0},null,null,null,{"$f":"+N27+K27+H27","v":0}]
[null,"I.52","onderhoud",2.5,"asfalt zwart",null,null,null,21.559374999999999,null,0,null,null,null,0]
[null,"I.53",null,2.5,"asfalt rood",null,null,null,31.324999999999999,null,0,null,null,null,0]
[]
[null,"I.61","groot (/14 jr)",2.5,"tegels",null,null,null,22.900222222222219,null,{"$f":"ROUNDUP(+J31*I31*$D31*I$6,-1)","v":0},null,null,null,{"$f":"+N31+K31+H31","v":0}]
[null,"I.62","onderhoud",2.5,"asfalt zwart",null,null,null,14.489166666666666,null,0,null,null,null,{"$f":"+N32+K32+H32","v":0}]
[null,"I.63",null,2.5,"asfalt rood",null,null,null,22.301666666666666,null,0,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,"B verharding [m]","toeslag EHP",3,"B berm [m]",null,1]
[null,"II.  Grondwerk (excl grondwerk standaard DWP)",null,null,null,null,"Aanbrengen",null,0.05,"Verbreding",null,null,"Verwijderen",null,"subTOTAAL € "]
[null,"incl afwerking",null,"H gemiddeld",null,"EHP m3/m1","L  m1","kosten € ","EHP m3/m1","L  m1","kosten € ","EHP [DirK]","L  m1","kosten € ",{"$f":"SUM(O39:O44)","v":0}]
[null,"II.11",null,0.25,"H=0,00-0,50",19.43438888888889,null,{"$f":"+ROUNDUP(($J$36+2*$M$36+2*$D39)*$D39*G39*F39,-1)","v":0},19.43438888888889,null,{"$f":"+ROUNDUP(($J$36+1*$M$36+2*$D39)*$D39*J39*I39*(1+$I$37),-1)","v":0},13.681666666666668,null,{"$f":"+ROUNDUP(($J$36+2*$M$36+2*$D39)*$D39*M39*L39,-1)","v":0},{"$f":"+N39+K39+H39","v":0}]
[null,"II.12",null,0.75,"H=0,50-1,00",13.535083333333333,null,{"$f":"+ROUNDUP(($J$36+2*$M$36+2*$D40)*$D40*G40*F40,-1)","v":0},13.535083333333333,null,{"$f":"+ROUNDUP(($J$36+1*$M$36+2*$D40)*$D40*J40*I40*(1+$I$37),-1)","v":0},23.450000000000003,null,{"$f":"+ROUNDUP(($J$36+2*$M$36+2*$D40)*$D40*M40*L40,-1)","v":0},0]
[null,"II.13",null,1.25,"H=1,00-1,50",14.289249999999999,null,0,14.289249999999999,null,0,35.75,null,0,0]
[null,"II.14",null,1.75,"H=1,50-2,00",15.348178571428571,null,0,15.348178571428571,null,0,48.050000000000004,null,0,0]
[null,null,null,null,null,null,null,null,7.81]
[]
[]
[null,"III.  Voorzieningen",null,null,null,10,"Aanbrengen",null,null,"Verplaatsen/aanpassen",null,null,"Verwijderen",null,"subTOTAAL € "]
[null,null,null,null,null,"EHP","L  m1","kosten € ","EHP","L  m1","kosten € ","EHP","L  m1","kosten € ",{"$f":"SUM(O48:O67)","v":0}]
[null,"III.11","OV langs Fp (HoH 25m)",null,"4,0m mast LED",{"$f":"+F54/25","v":49.2},null,{"$f":"ROUNDUP(+G48*F48*F$6,-1)","v":0},{"$f":"+I54/25","v":14.55},null,{"$f":"ROUNDUP(+J48*I48*I$6,-1)","v":0},{"$f":"+L54/25","v":5.7333333333333325},null,{"$f":"ROUNDUP(+M48*L48*L$6,-1)","v":0},{"$f":"+N48+K48+H48","v":0}]
[]
[null,"III.21","220V laagspanning",null,"4x2,5  grondkabel",15.75,null,{"$f":"ROUNDUP(+G50*F50*F$6,-1)","v":0},12,null,{"$f":"ROUNDUP(+J50*I50*I$6,-1)","v":0},10,null,{"$f":"ROUNDUP(+M50*L50*L$6,-1)","v":0},{"$f":"+N50+K50+H50","v":0}]
[null,"III.22","signaalkabel",null,"glasvezel",18.899999999999999,null,0,12,null,0,10,null,0,{"$f":"+N51+K51+H51","v":0}]
[]
[null,null,null,null,null,"EHP","aantal","kosten € ","EHP","aantal","kosten € ","EHP","aantal","kosten € "]
[null,"III.12","OV op kruisingsvlakken",null,"4,0m mast LED",1230,null,{"$f":"ROUNDUP(+G54*F54*F$6,-1)","v":0},363.75,null,{"$f":"ROUNDUP(+J54*I54*I$6,-1)","v":0},143.33333333333331,null,{"$f":"ROUNDUP(+M54*L54*L$6,-1)","v":0},{"$f":"+N54+K54+H54","v":0}]
[]
[null,"III.31","schakelkast",null,"hardware",28350,null,{"$f":"ROUNDUP(+G56*F56*F$6,-1)","v":0},10000,null,{"$f":"ROUNDUP(+J56*I56*I$6,-1)","v":0},5000,null,{"$f":"ROUNDUP(+M56*L56*L$6,-1)","v":0},{"$f":"+N56+K56+H56","v":0}]
[null,"III.32","VRI programeren",null,"software",5000,null,0,2000,null,0,null,null,null,{"$f":"+N57+K57+H57","v":0}]
[]
[null,"III.41","VRI fietspad (set)",null,"2 lantaarns incl drukpaal",7260,null,0,{"$f":"+F59/2","v":3630},null,0,1000,null,{"$f":"ROUNDUP(+M59*L59*L$6,-1)","v":0},0]
[null,"III.42","met voetpad",null,"4 lantaarns incl drukpaal",10360,null,0,{"$f":"+F60/2","v":5180},null,0,1500,null,0,{"$f":"+N60+K60+H60","v":0}]
[null,"III.43","met vluchtheuvel",null,"3 lantaarns incl drukpaal",10890,null,0,5445,null,0,1500,null,0,{"$f":"+N61+K61+H61","v":0}]
[null,"III.44","met voetpad en vluchtheuvel",null,"6 lantaarns incl drukpaal",15540,null,0,7770,null,0,2000,null,0,{"$f":"+N62+K62+H62","v":0}]
[]
[null,"III.51","VRI autoweg (set)",null,"1 rijstrook (mast) ",8200,null,0,{"$f":"+F64*0.8","v":6560},null,0,1500,null,0,0]
[null,"III.52","incl detectielussen",null,"2 rijstrook (zwenkmast) ",19680,null,0,{"$f":"+F65*0.7","v":13776},null,0,2000,null,0,0]
[null,"III.53",null,null,"3 rijstrook (zwenkmast) ",25080,null,0,{"$f":"+F66*0.7","v":17556},null,0,2000,null,0,{"$f":"+N66+K66+H66","v":0}]
[]
[null,null,"Directe kosten  I, II en III",null,null,null,null,{"$f":"SUM(H8:H67)","v":0},null,null,{"$f":"SUM(K8:K67)","v":0},null,null,{"$f":"SUM(N8:N67)","v":0},{"$f":"+O47+O38+O26+O7","v":0}]
[null,null,"standaard opslagen ",null,null,null,null,{"$f":"+H68*$M$2","v":0},null,null,{"$f":"+K68*$M$2","v":0},null,null,{"$f":"+N68*$M$2","v":0},{"$f":"+O68*$M$2","v":0}]
[null,null,"INV kst  I, II, III normbedragen",null,null,null,null,{"$f":"+H69+H68","v":0},null,null,{"$f":"+K69+K68","v":0},null,null,{"$f":"+N69+N68","v":0},{"$f":"+O69+O68","v":0}]
[]
[]
[null,"V.  Specials",null,"bijlage: SSK onderbouwing",null,null,"Nieuwbouw",null,null,"Renovatiie",null,null,"Slopen",null,"subTOTAAL € "]
[null,null,null,null,null,null,"ehd","kosten € ","EHP","ehd","kosten € ","EHP","ehd","kosten € ",{"$f":"SUM(O75:O89)","v":0}]
[null,"V.1","inspecties & achterstallig onderhoud",null,null,null,null,0,null,null,0,null,null,0,{"$f":"+N75+K75+H75","v":0}]
[null,"V.2","grondverbetering,  verontreiniging, overig grondwerk",null,null,null,null,0,null,null,0,null,null,0,{"$f":"+N76+K76+H76","v":0}]
[null,"V.3","kunstwerken.",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.4","kabels & leidingen",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.5","afwatering en riolering",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.6","overige verhardingen (voetpaden, rijbanen autoverkeer)",null,null,null,null,0,null,null,0,null,null,0,{"$f":"+N80+K80+H80","v":0}]
[null,"V.7","bomen en groenvoorzieningen",null,null,null,null,0,null,null,0,null,null,0,{"$f":"+N81+K81+H81","v":0}]
[null,"V.8","vastgoed",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.9","overige posten",null,null,null,null,0,null,null,0,null,null,0,0]
[]
[null,"V.90","overige opslagen",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.97","extra kosten voor NtD",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.98","bijzondere uitvoeringskosten",null,null,null,null,0,null,null,0,null,null,0,{"$f":"+N87+K87+H87","v":0}]
[null,"V.99","bijzondere risico's",null,null,null,null,0,null,null,0,null,null,0,0]
[]
[null,null,"INV kst IV specials",null,null,null,null,{"$f":"SUM(H75:H89)","v":0},null,null,{"$f":"SUM(K75:K89)","v":0},null,null,{"$f":"SUM(N75:N89)","v":0},{"$f":"SUM(O75:O89)","v":0}]
[]
[null,null,"Totale INVESTERING kosten excl BTW  (brom) fietspaden",null,null,null,null,{"$f":"+H90+H70","v":0},null,null,{"$f":"+K90+K70","v":0},null,null,{"$f":"+N90+N70","v":0},{"$f":"+O90+O70","v":0}]

{"sheet":"haltes","index":2,"n_rows":75,"n_cols":15,"rows_kept":75,"cut":false,"hidden":false,"merged":[[27,6,27,7],[27,9,27,10],[27,12,27,13],[6,6,6,7],[6,9,6,10],[6,12,6,13],[55,6,55,7],[55,9,55,10],[55,12,55,13],[36,6,36,7],[36,9,36,10],[36,12,36,13]]}
[]
[null,"Aanvrager",null,"[gemeente xxx]",null,null,null,"standaard opslag in %",null,null,null,null,0.8,{"$f":"IF(M2=80%,\"\",\"onderbouwing opslagen bijvoegen\")","v":""}]
[null,"Traject",null,"[ xxx ]",null,null,null,"aanvullende opslagen IV97 t/m 99",null,null,null,null,"nee",{"$f":"IF(M3=\"nee\",\"\",\"onderbouwing opslagen bijvoegen\")","v":""}]
[null,null,null,"1 haltepaar",null,null,null,"bijzondere kosten IV01 t/m 90",null,null,null,null,"nee",{"$f":"IF(M4=\"nee\",\"\",\"onderbouwing bijvoegen\")","v":""}]
[]
[]
["I","I.  Haltes",null,null,null,1,"Nieuwbouw",null,{"$f":"+F7","v":1},"Renovatie",null,{"$f":"+F7","v":1},"Slopen en afvoeren",null,"subTOTAAL € "]
[null,null,null,null,null,"EHP/st [DirK]","Aantal","kosten € ","EHP [DirK]",null,"kosten € ","EHP [DirK]","L  m1","kosten € ",{"$f":"SUM(O9:O25)","v":0}]
[null,"I.11","haltekom per halte",null,"asfalt",7865.9594312499985,null,{"$f":"ROUNDUP(+G9*F9*F$7,-1)","v":0},null,null,null,null,null,null,{"$f":"+N9+K9+H9","v":0}]
[null,"I.12",null,null,"beton",11209.663556249998,null,{"$f":"ROUNDUP(+G10*F10*F$7,-1)","v":0},null,null,null,null,null,null,{"$f":"+N10+K10+H10","v":0}]
[null,"I.13","perron per halte",null,"prefab",27468.809984848489,null,0,null,null,null,null,null,null,{"$f":"+N11+K11+H11","v":0}]
[null,"I.14",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N12+K12+H12","v":0}]
[]
[null,"I.31","abri per halte",null,"lengte 6,00 m",22500,null,0,null,null,null,null,null,null,{"$f":"+N14+K14+H14","v":0}]
[null,"I.32",null,null,"lengte 9,00 m",{"$f":"+F14*1.5","v":33750},null,0,null,null,null,null,null,null,0]
[null,"I.33",null,null,"lengte 12,00 m",{"$f":"+F14*2","v":45000},null,0,null,null,null,null,null,null,0]
[null,"I.34",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I.35","DRIS per halte",null,null,15000,null,0,null,null,null,null,null,null,0]
[]
[null,"I.41","haltemeubilair",null,"hekwerk per 6 m1",1000,null,0,null,null,null,null,null,null,{"$f":"+N20+K20+H20","v":0}]
[null,"I.42",null,null,"bank",2500,null,0,null,null,null,null,null,null,0]
[null,"I.43",null,null,"leunsteun",1500,null,0,null,null,null,null,null,null,0]
[null,"I.44",null,null,"afvalbak",1000,null,0,null,null,null,null,null,null,0]
[null,"I.45",null,null,"peukenzuil",800,null,0,null,null,null,null,null,null,0]
[]
[]
[]
["II","II.  Fietsenstalling",null,null,null,null,"Aanbrengen",null,null,"Verplaatsen",null,null,"Verwijderen",null,"subTOTAAL € "]
[null,null,null,null,null,"EHP/st [DK]","L  m1","kosten € ","EHP [DirK]","L  m1","kosten € ","EHP [DirK]","L  m1","kosten € ",{"$f":"SUM(O30:O35)","v":0}]
[null,"II.11",null,null,"fietsbeugel (8 fietsen)",1600,null,{"$f":"ROUNDUP(+G30*F30*F$7,-1)","v":0},null,null,null,null,null,null,{"$f":"+N30+K30+H30","v":0}]
[null,"II.12",null,null,"overkapping",10000,null,0,null,null,null,null,null,null,0]
[null,"II.13",null,null,null,null,null,{"$f":"+($J$27+2*$M$27+2*$D32)*$D32*G32*F32","v":0},null,null,null,null,null,null,0]
[null,"II.14",null,null,null,null,null,{"$f":"+($J$27+2*$M$27+2*$D33)*$D33*G33*F33","v":0},null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,7.81]
[]
[]
["III","III.   Voorbereidend werk",null,null,null,null,"Aanbrengen",null,null,"Verplaatsen",null,null,"Verwijderen",null,"subTOTAAL € "]
[null,null,null,null,null,"EHP [DK]","L  m1","kosten € ","EHP","L  m1","kosten € ","EHP","L  m1","kosten € ",{"$f":"SUM(O39:O50)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUNDUP(+G39*F39*F$7,-1)","v":0},null,null,{"$f":"ROUNDUP(+J39*I39*I$7,-1)","v":0},null,null,{"$f":"ROUNDUP(+M39*L39*L$7,-1)","v":0},{"$f":"+N39+K39+H39","v":0}]
[null,"III.11","220V laagspanning",null,"4x2,5  grondkabel",15.75,null,0,12,null,0,10,null,0,0]
[null,"III.12","signaalkabel",null,"glasvezel",18.899999999999999,null,0,12,null,0,10,null,0,0]
[null,null,null,null,null,"EHP","LS","kosten € ","EHP","LS","kosten € ","EHP","LS","kosten € "]
[null,"III.20","grondwerk per halte",null,null,3000,null,0,null,null,null,null,null,null,{"$f":"+N43+K43+H43","v":0}]
[]
[null,"III.31","abri's en meubilair",null,"naar depot",null,null,null,1500,null,{"$f":"ROUNDUP(+J45*I45*I$7,-1)","v":0},null,null,null,{"$f":"+N45+K45+H45","v":0}]
[null,null,"per halte",null,"opslag en transport"]
[]
[null,"III.41","verharding en banden",null,"slopen en afvoer",null,null,null,null,null,null,5000,null,{"$f":"ROUNDUP(+M48*L48*L$7,-1)","v":0},{"$f":"+N48+K48+H48","v":0}]
[null,null,"per halte"]
[]
[null,null,"Directe kosten  I, II en III",null,null,null,null,{"$f":"SUM(H9:H50)","v":0},null,null,{"$f":"SUM(K9:K50)","v":0},null,null,{"$f":"SUM(N9:N50)","v":0},{"$f":"+O38+O29+O8","v":0}]
[null,null,"standaard opslagen ",null,null,null,null,{"$f":"+H51*$M$2","v":0},null,null,{"$f":"+K51*$M$2","v":0},null,null,{"$f":"+N51*$M$2","v":0},{"$f":"+O51*$M$2","v":0}]
[null,null,"INV kst  I, II, III normbedragen",null,null,null,null,{"$f":"+H52+H51","v":0},null,null,{"$f":"+K52+K51","v":0},null,null,{"$f":"+N52+N51","v":0},{"$f":"+O52+O51","v":0}]
[]
[]
["IV","V.  Specials",null,"bijlage: SSK onderbouwing",null,null,"Nieuwbouw",null,null,"Renovatiie",null,null,"Slopen",null,"subTOTAAL € "]
[null,null,null,null,null,null,"ehd","kosten € ","EHP","ehd","kosten € ","EHP","ehd","kosten € ",{"$f":"SUM(O58:O72)","v":0}]
[null,"V.1","inspecties & achterstallig onderhoud",null,null,null,null,0,null,null,0,null,null,0,{"$f":"+N58+K58+H58","v":0}]
[null,"V.2","grondverbetering,  verontreiniging, overig grondwerk",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.3","kunstwerken",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.4","kabels & leidingen",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.5","afwatering en riolering",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.6","overige verhardingen (voetpaden, rijbanen autoverkeer)",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.7","bomen en groenvoorzieningen",null,null,null,null,0,null,null,0,null,null,0,{"$f":"+N64+K64+H64","v":0}]
[null,"V.8","xx",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.9","overige posten",null,null,null,null,0,null,null,0,null,null,0,0]
[]
[null,"V.90","overige posten",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.97","extra kosten voor NtD",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.98","bijzondere uitvoeringskosten",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.99","bijzondere risico's",null,null,null,null,0,null,null,0,null,null,0,0]
[]
[null,null,"INV kst IV specials",null,null,null,null,{"$f":"SUM(H58:H72)","v":0},null,null,{"$f":"SUM(K58:K72)","v":0},null,null,{"$f":"SUM(N58:N72)","v":0},{"$f":"SUM(O58:O72)","v":0}]
[]
[null,null,"Totale INVESTERING kosten excl BTW  haltes",null,null,null,null,{"$f":"+H73+H53","v":0},null,null,{"$f":"+K73+K53","v":0},null,null,{"$f":"+N73+N53","v":0},{"$f":"+O73+O53","v":0}]

{"sheet":"duurzaam veilig","index":3,"n_rows":104,"n_cols":15,"rows_kept":104,"cut":false,"hidden":false,"merged":[[84,6,84,7],[84,9,84,10],[84,12,84,13],[5,6,5,7],[5,9,5,10],[5,12,5,13],[31,6,31,7],[31,9,31,10],[31,12,31,13],[42,6,42,7],[42,9,42,10],[42,12,42,13],[61,6,61,7],[61,9,61,10],[61,12,61,13]]}
[]
[null,"Aanvrager",null,null,"[xxxx]",null,null,"standaard opslag in %",null,null,null,null,0.8,{"$f":"IF(M2=80%,\"\",\"onderbouwing opslagen bijvoegen\")","v":""}]
[null,"Traject",null,null,"[xxxx]",null,null,"aanvullende opslagen IV97 t/m 99",null,null,null,null,"nee",{"$f":"IF(M3=\"nee\",\"\",\"onderbouwing opslagen bijvoegen\")","v":""}]
[null,"km",null,"km",null,null,null,"bijzondere kosten IV01 t/m 90",null,null,null,null,"nee",{"$f":"IF(M4=\"nee\",\"\",\"onderbouwing bijvoegen\")","v":""}]
[]
["I","I. Drempels",null,null,null,1,"Aanbrengen",null,{"$f":"+F6","v":1},"Renovatie",null,{"$f":"+F6","v":1},"Verwijderen",null,"subTOTAAL € "]
[null,null,null,"B weg=",null,"EHP/m1 [DirK]","aantal","kosten € ","EHP [DirK]","L  m1","kosten € ","EHP [DirK]","L  m1","kosten € ",{"$f":"SUM(O8:O30)","v":0}]
[null,"I.11","elementverharding",7,"30 km/u [ 7,50 m]",669.25874999999996,null,{"$f":"ROUNDUP(+G8*F8*$D8*F$6,-1)","v":0},null,null,null,null,null,null,{"$f":"+N8+K8+H8","v":0}]
[null,"I.12",null,7,"50 km/u [10,80 m]",940.87545714285716,null,0,null,null,null,null,null,null,{"$f":"+N9+K9+H9","v":0}]
[null,"I.13",null,10,"70 km/u [15,00 m]",1074.0875000000001,null,0,null,null,null,null,null,null,{"$f":"+N10+K10+H10","v":0}]
[]
[null,"I.21","asfalt",7,"30 km/u [ 7,50 m]",909.0062499999998,null,0,null,null,null,null,null,null,{"$f":"+N12+K12+H12","v":0}]
[null,"I.22",null,7,"50 km/u [10,80 m]",1120.3975714285714,null,0,null,null,null,null,null,null,{"$f":"+N13+K13+H13","v":0}]
[null,"I.23",null,10,"70 km/u [15,00 m]",1199.0825,null,0,null,null,null,null,null,null,{"$f":"+N14+K14+H14","v":0}]
[]
[null,"I.31","prefab",7,"30 km/u [ 7,50 m]",1035.7434642857143,null,0,null,null,null,null,null,null,{"$f":"+N16+K16+H16","v":0}]
[null,"I.32",null,7,"50 km/u [10,80 m]",1303.5756000000001,null,0,null,null,null,null,null,null,0]
[null,"I.33",null,10,"70 km/u [15,00 m]",1478.4855,null,0,null,null,null,null,null,null,0]
[]
[]
[null,"onderhoud",null,0.15,"van het oppervlak",null,null,null,null,"Onderhoud"]
[null,null,null,"B=",null,"EHP [DirK]",null,null,"EHP [DirK]","L  m1","kosten € ","EHP [DirK]"]
[null,"I.51","klein (/7 jr)",2.5,"tegels",null,null,null,null,null,{"$f":"+J23*I23*$D23*I$6*$D$21","v":0},null,null,null,{"$f":"+N23+K23+H23","v":0}]
[null,"I.53","onderhoud",2.5,"asfalt zwart",null,null,null,null,null,{"$f":"+J24*I24*$D24*I$6*$D$21","v":0},null,null,null,0]
[null,"I.54",null,2.5,"asfalt rood",null,null,null,null,null,{"$f":"+J25*I25*$D25*I$6*$D$21","v":0},null,null,null,0]
[]
[null,"I.61","groot (/14 jr)",2.5,"tegels",null,null,null,null,null,{"$f":"+J27*I27*$D27*I$6","v":0},null,null,null,{"$f":"+N27+K27+H27","v":0}]
[null,"I.63","onderhoud",2.5,"asfalt zwart",null,null,null,null,null,{"$f":"+J28*I28*$D28*I$6","v":0},null,null,null,0]
[null,"I.64",null,2.5,"asfalt rood",null,null,null,null,null,{"$f":"+J29*I29*$D29*I$6","v":0},null,null,null,0]
[]
[null,null,null,null,null,null,null,"B verharding [m]",null,0,"B berm [m]",null,0]
["II","II.  Kruisingsvlakken",null,null,null,{"$f":"AVERAGE(F12:F14)/AVERAGE(F8:F10)","v":1.2027644038632861},"Aanbrengen",null,null,"Renovatie",null,null,"Verwijderen",null,"subTOTAAL € "]
[null,null,null,null,"elementverharding","EHP/m2 [DK]","A  m2","kosten € ","EHP [DirK]","A  m2","kosten € ","EHP [DirK]","A  m2","kosten € ",{"$f":"SUM(O34:O42)","v":0}]
[null,"II.11","< 100 m2",null,"2 takken",114.02668622197587,null,{"$f":"ROUNDUP(+G34*F$6*IF($E$33=\"asfalt\",$F34*$F$32,$F34),-1)","v":0},null,null,null,null,null,null,{"$f":"+N34+K34+H34","v":0}]
[null,"II.12","30 km/uur",null,"3 takken",110.09522547288165,null,{"$f":"ROUNDUP(+G35*F$6*IF($E$33=\"asfalt\",$F35*$F$32,$F35),-1)","v":0},null,null,null,null,null,null,0]
[null,"II.13",null,null,"4 takken",108.50582783595112,null,0,null,null,null,null,null,null,{"$f":"+N36+K36+H36","v":0}]
[]
[null,"II.21","100 - 400 m2",null,"2 takken",97.532513120839738,null,0,null,null,null,null,null,null,0]
[null,"II.22","50 km/uur",null,"3 takken",93.331216569086621,null,0,null,null,null,null,null,null,{"$f":"+N39+K39+H39","v":0}]
[null,"II.23",null,null,"4 takken",86.638577246925266,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,7.81]
[]
["III","III.  Versmalingen",null,null,null,null,"Aanbrengen",null,null,"Renovatie",null,null,"Verwijderen",null,"subTOTAAL € "]
[null,null,null,"B weg=","elementverharding","EHP/m2 [DK]","aantal","kosten € ","EHP","L  m1","kosten € ","EHP","L  m1","kosten € ",{"$f":"SUM(O45:O61)","v":0}]
[null,"III.11",null,5,"visuele versmalling",85.499318181818182,null,{"$f":"ROUNDUP(+G45*$D45*F$6*IF($E$44=\"asfalt\",$F45*$F$32,$F45),-1)","v":0},null,null,null,null,null,null,{"$f":"+N45+K45+H45","v":0}]
[null,"III.12",null,5,"met fietsstroken",658.33333333333337,null,{"$f":"ROUNDUP(+G46*$D46*F$6*IF($E$44=\"asfalt\",$F46*$F$32,$F46),-1)","v":0},null,null,null,null,null,null,0]
[null,"III.13",null,5,"met uitstulpingen",460,null,0,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"EHP","aantal","kosten € ","EHP","aantal","kosten € ","EHP","aantal","kosten € "]
[null,"III.12","OV op kruisingsvlakken",null,"4,0m mast LED",1130,null,{"$f":"+G50*F50","v":0},365,null,{"$f":"+J50*I50","v":0},150,null,{"$f":"+M50*L50","v":0},{"$f":"+N50+K50+H50","v":0}]
[]
[null,"III.31","schakelkast",null,"hardware",30000,null,{"$f":"+G52*F52","v":0},10000,null,{"$f":"+J52*I52","v":0},5000,null,{"$f":"+M52*L52","v":0},{"$f":"+N52+K52+H52","v":0}]
[null,"III.32","VRI programeren",null,"software",5000,null,0,null,null,null,null,null,null,0]
[null,"III.41","VRI fietspad (set)",null,"2 lantaarns incl drukpaal",6811,null,0,{"$f":"+F54/2","v":3405.5},null,{"$f":"+J54*I54","v":0},1000,null,{"$f":"+M54*L54","v":0},0]
[null,"III.42","met voetpad",null,"4 lantaarns incl drukpaal",9610,null,0,{"$f":"+F55/2","v":4805},null,0,1500,null,{"$f":"+M55*L55","v":0},{"$f":"+N55+K55+H55","v":0}]
[null,"III.43","met vluchtheuvel",null,"3 lantaarns incl drukpaal",10216,null,0,5108,null,0,1500,null,{"$f":"+M56*L56","v":0},{"$f":"+N56+K56+H56","v":0}]
[null,"III.44","met voetpad en vluchtheuvel",null,"6 lantaarns incl drukpaal",14415,null,0,7207.5,null,0,2000,null,{"$f":"+M57*L57","v":0},{"$f":"+N57+K57+H57","v":0}]
[null,"III.51","VRI autoweg (set)",null,"1 rijstrook (mast) ",7351,null,0,{"$f":"+F58*0.8","v":5880.8},null,0,1500,null,{"$f":"+M58*L58","v":0},0]
[null,"III.52","incl detectielussen",null,"2 rijstrook (zwenkmast) ",18072,null,0,{"$f":"+F59*0.8","v":14457.6},null,0,2000,null,0,0]
[null,"III.xx",null,null,"3 rijstrook (zwenkmast) ",22672,null,0,18137.600000000002,null,0,2000,null,0,0]
[]
["IV","IV.  Voorzieningen",null,null,null,null,"Aanbrengen",null,null,"Verplaatsen",null,null,"Verwijderen",null,"subTOTAAL € "]
[null,null,null,null,null,"EHP","L  m1","kosten € ","EHP","L  m1","kosten € ","EHP","L  m1","kosten € ",{"$f":"SUM(O64:O79)","v":0}]
[null,"III.21","220V laagspanning",null,"4x2,5  grondkabel",{"$f":"+fietspaden!F50","v":15.75},null,{"$f":"ROUNDUP(+G64*F64*F$6,-1)","v":0},{"$f":"+fietspaden!I50","v":12},null,{"$f":"ROUNDUP(+J64*I64*I$6,-1)","v":0},{"$f":"+fietspaden!L50","v":10},null,{"$f":"ROUNDUP(+M64*L64*L$6,-1)","v":0},{"$f":"+N64+K64+H64","v":0}]
[null,"III.22","signaalkabel",null,"glasvezel",{"$f":"+fietspaden!F51","v":18.899999999999999},null,0,{"$f":"+fietspaden!I51","v":12},null,0,{"$f":"+fietspaden!L51","v":10},null,0,0]
[]
[null,null,null,null,null,"EHP","aantal","kosten € ","EHP","aantal","kosten € ","EHP","aantal","kosten € "]
[null,"III.31","schakelkast",null,"hardware",{"$f":"+fietspaden!F56","v":28350},null,0,{"$f":"+fietspaden!I56","v":10000},null,{"$f":"ROUNDUP(+J68*I68*I$6,-1)","v":0},{"$f":"+fietspaden!L56","v":5000},null,{"$f":"ROUNDUP(+M68*L68*L$6,-1)","v":0},{"$f":"+N68+K68+H68","v":0}]
[null,"III.32","VRI programeren",null,"software",{"$f":"+fietspaden!F57","v":5000},null,0,{"$f":"+fietspaden!I57","v":2000},null,0,null,null,null,0]
[]
[null,"III.41","VRI fietspad (set)",null,"2 lantaarns incl drukpaal",{"$f":"+fietspaden!F59","v":7260},null,0,{"$f":"+fietspaden!I59","v":3630},null,0,{"$f":"+fietspaden!L59","v":1000},null,{"$f":"ROUNDUP(+M71*L71*L$6,-1)","v":0},{"$f":"+N71+K71+H71","v":0}]
[null,"III.42","met voetpad",null,"4 lantaarns incl drukpaal",{"$f":"+fietspaden!F60","v":10360},null,0,{"$f":"+fietspaden!I60","v":5180},null,0,{"$f":"+fietspaden!L60","v":1500},null,0,{"$f":"+N72+K72+H72","v":0}]
[null,"III.43","met vluchtheuvel",null,"3 lantaarns incl drukpaal",{"$f":"+fietspaden!F61","v":10890},null,0,{"$f":"+fietspaden!I61","v":5445},null,0,{"$f":"+fietspaden!L61","v":1500},null,0,{"$f":"+N73+K73+H73","v":0}]
[null,"III.44","met voetpad en vluchtheuvel",null,"6 lantaarns incl drukpaal",{"$f":"+fietspaden!F62","v":15540},null,0,{"$f":"+fietspaden!I62","v":7770},null,0,{"$f":"+fietspaden!L62","v":2000},null,0,{"$f":"+N74+K74+H74","v":0}]
[]
[null,"III.51","VRI autoweg (set)",null,"1 rijstrook (mast) ",{"$f":"+fietspaden!F64","v":8200},null,0,{"$f":"+fietspaden!I64","v":6560},null,0,{"$f":"+fietspaden!L64","v":1500},null,0,0]
[null,"III.52","incl detectielussen",null,"2 rijstrook (zwenkmast) ",{"$f":"+fietspaden!F65","v":19680},null,0,{"$f":"+fietspaden!I65","v":13776},null,0,{"$f":"+fietspaden!L65","v":2000},null,0,0]
[null,"III.53",null,null,"3 rijstrook (zwenkmast) ",{"$f":"+fietspaden!F66","v":25080},null,0,{"$f":"+fietspaden!I66","v":17556},null,0,{"$f":"+fietspaden!L66","v":2000},null,0,0]
[]
[null,null,"Directe kosten  I, II en III",null,null,null,null,{"$f":"SUM(H8:H79)","v":0},null,null,{"$f":"SUM(K8:K79)","v":0},null,null,{"$f":"SUM(N8:N79)","v":0},{"$f":"+O44+O33+O22+O7","v":0}]
[null,null,"standaard opslagen ",null,null,null,null,{"$f":"+H80*$M$2","v":0},null,null,{"$f":"+K80*$M$2","v":0},null,null,{"$f":"+N80*$M$2","v":0},{"$f":"+O80*$M$2","v":0}]
[null,null,"INV kst  I, II, III normbedragen",null,null,null,null,{"$f":"+H81+H80","v":0},null,null,{"$f":"+K81+K80","v":0},null,null,{"$f":"+N81+N80","v":0},{"$f":"+O81+O80","v":0}]
[]
[]
["V","V.  Specials",null,"bijlage: SSK onderbouwing",null,null,"Nieuwbouw",null,null,"Renovatiie",null,null,"Slopen",null,"subTOTAAL € "]
[null,null,null,null,null,null,"ehd","kosten € ","EHP","ehd","kosten € ","EHP","ehd","kosten € ",{"$f":"SUM(O87:O101)","v":0}]
[null,"V.1","renovatieen aanpassen bestaande voorzieningen",null,null,null,null,0,null,null,0,null,null,0,{"$f":"+N87+K87+H87","v":0}]
[null,"V.2","verwijderen bestaande voorzieningen",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.3",null,null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.4","bijzonder wegprofiel",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.5","verleggen kabels & leidingen",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.6","grote VRI instalaties",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.7",null,null,null,null,null,0,null,null,0,null,null,0,{"$f":"+N93+K93+H93","v":0}]
[null,"V.8",null,null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.9","overige posten",null,null,null,null,0,null,null,0,null,null,0,0]
[]
[null,"V.90","overige posten",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.97","extra kosten voor NtD",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.98","bijzondere uitvoeringskosten",null,null,null,null,0,null,null,0,null,null,0,0]
[null,"V.99","bijzondere risico's",null,null,null,null,0,null,null,0,null,null,0,0]
[]
[null,null,"INV kst IV specials",null,null,null,null,{"$f":"SUM(H87:H101)","v":0},null,null,{"$f":"SUM(K87:K101)","v":0},null,null,{"$f":"SUM(N87:N101)","v":0},{"$f":"SUM(O87:O101)","v":0}]
[]
[null,null,"Totale INVESTERING kosten excl BTW  snelheidsremmende maatregelen",null,null,null,null,{"$f":"+H102+H82","v":0},null,null,{"$f":"+K102+K82","v":0},null,null,{"$f":"+N102+N82","v":0},{"$f":"+O102+O82","v":0}]