{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Handleiding","Algemene gegevens","Project HA","Project WA","Project kolk","huisaansluitingen","kolkaansluitingen","keuzelijsten"],"not_rendered":{"charts":0,"images":22,"macros":1,"external_links":1,"defined_names":7,"comments":2,"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":"Handleiding","index":0,"n_rows":339,"n_cols":19,"rows_kept":339,"cut":false,"hidden":false,"merged":[]}
["Doelstelling:"]
["1 uniforme huisaansluitingsfiche voor alle rioolbeheerders in Vlaanderen, op heden zijn volgende instanties akkoord gegaan met deze opmaak "]
[null,"Aquafin"]
[null,"Farys"]
[null,"Fluvius "]
[null,"Pidpa"]
[null,"Riopact"]
[]
["Principe:"]
["Bij de start van een nieuw weg- en rioleringsproject zal de rioolbeheerder in de gemeente/stad zorgen voor een deels ingevulde fiche zoals hier voorgesteld wordt."]
["De bouwheer zal de rioolbeheerder hiervoor tijdig contacteren."]
[]
["Alle blauwe vakken dienen door de rioolbeheerder ingevuld te worden vooraleer deze fiche wordt overgemaakt aan de aannemer."]
[]
["Alle gele vakken dienen stapsgewijs door de aannemer verder ingevuld te worden."]
[]
["Alle oranje vakken worden automatisch ingevuld al dan niet na het runnen van de macro. Hier moet dus niets manueel ingevuld worden."]
[]
["1. Tabblad \"Algemene gegevens\""]
[]
["Hierin moeten alle algemene gegevens van het project vermeld worden, dit vooraleer de nodige macro's gerund worden."]
[]
["Actie door :","rioolbeheerder en ",null,"aannemer"]
[]
[]
["2. Tabblad \"Project HA/WA /Klok\""]
[]
["Dit zijn overzichtstabbellen van de uit te voeren of geplande huisaansluitingen en klokaansluitingen."]
[]
["Na het draaien van de macro's kan men switchen tussen de verschillende tabbladen, uitleg zie verder."]
[]
[]
["2.1 Tabblad \"Project HA\""]
[]
["In deze overzichtslijst worden alle bestaande woningen/percelen opgenomen."]
[]
["Bij de start van het project zal de",null,null,"rioolbeheerder",null,"voor elk perceel  waarvoor een huisnummer gekend is/ bewoond is, een equipmentnummer aanvullen in de lijst."]
["Elk adres wordt twee maal opgenomen in de lijst, eertse maal voor RWA-huisaansluiting en tweede maal voor de DWA-huisaansluiting."]
[]
["Indien een woning een tweede DWA- of RWA-huisaansluiting heeft, dient ",null,null,null,null,null,null,"de aannemer",null,"zelf de bestaande lijnen voor DWA- of RWA-huisaansluiting te kopiëren in dezelfde lijst."]
["LET OP: bij het kopiëren van een nieuwe lijn moet er steeds bij het equipmentnr. een letter b genoteerd worden, en bij de 3de aansluiting c, … "]
["Er mogen geen symbolen gebruilt worden, anders werkt de marco niet."]
[]
["De macro voor de uitrol van de huisaansluitingsfiches pas runnen als de lijst volledig is!"]
["De gegevens van de diameter en materiaal moet ook vooraf ingevuld worden, door ",null,null,null,null,null,null,null,"de aannemer"]
[]
["NIEUW: In dit tabblad zijn extra kolommen voorzien voor de hoeveelheden op privaat domein, conform genormaliseerde posten. Deze dienen manueel ingevuld te worden op de overzichtslijst, niet op de aansluitingsfiche zelf."]
["De aannemer ","vult deze aan."]
[]
["2.2 Tabblad \"Project WA\""]
[]
["In deze overzichtslijst worden alle (wacht)aansluitingen voor wachtpercelen voorzien, zijnde onbebouwe percelen, weilanden, ..."]
[]
["Ook hier worden er per wachtaansluting twee lijnen voorzien, 1x DWA-aansluiting en 1x RWA aansluiting."]
[]
["De aannemer ","dient hier zelf de lijst vooraf volledig in te vullen vooraleer deze macro gerund wordt;"]
["Straatnaam in te vullen (en mogelijks huisnummer), alsook gebruikte diameter en materiaal."]
[]
["Deze wachtaansluitingen dienen gewoon numeriek opgesomd te worden en de aanduiding hiervan moet mee opgenomen worden op de asbuilt grondplannen."]
[]
["Verkavelingen worden ook onder deze overzichtslijst ingevuld, de aansluitingen worden dan voorzien volgens gekend lotnummer (en niet volgens een eigen volgnummer)."]
[]
[]
["2.3 Tabblad \"Project kolk\""]
[]
["In deze overzichtslijst worden alle kolkaansluitingen bijgehouden."]
[]
["Hier wordt er per kolkaansluting één lijn voorzien."]
[]
["De aannemer ","dient hier zelf de lijst vooraf volledig in te vullen vooraleer deze macro gerund wordt;"]
["Straatnaam in te vullen (en eventueel huisnummer), alsook gebruikte diameter en materiaal."]
[]
["Deze kolkaansluitingen dienen gewoon numeriek opgesomd te worden en de aanduiding hiervan moet mee opgenomen worden op de asbuilt grondplannen."]
[]
[]
["3. Tabblad \"huisaansluiting/klokaansluiting\""]
[]
["Als men de marco runt, zullen deze tabbladen opgemaakt worden per perceel of per kolk aansluiting."]
[]
["De aannemer ","dient dan de aangemaakte tabbladen in te vullen in de gele velden, de gegevens van de hoeveelheden worden dan gekopieerd naar de overzichtstabel."]
["De oranje velden worden automatisch ingevuld bij het runnen van de macro ifv de ingevulde gegevens op voorgaande tabbladen."]
[]
["Verduidelijking enkele velden:"]
["Diepte aanboring op hoofdriool tov MV (op best. riolering):",null,null,null,null,null,"bij aansluiting op een nieuwe riolering, dient hier geen diepte aangevuld te worden"]
[null,null,null,null,null,null,"bij aansluiting op een bestaande riolering, dient hier wel een diepte aangevuld te worden"]
["5. zelfde als foto 2,  met aangevulde sleuf (op best. riolering):",null,null,null,null,null,"bij aansluiting op een nieuwe riolering, dient hier geen foto aangevuld te worden"]
[null,null,null,null,null,null,"bij aansluiting op een bestaande riolering, dient hier wel een foto aangevuld te worden"]
[]
["4. Tabblad \"keuzelijst\""]
[]
["Hierin mag men geen aanpassingen doen."]
[]
[]
[]
["Het aanmaken van de fiches"]
[]
["Er wordt voorgesteld aan de aannemer om de fiches in fase aan te leveren."]
["Men behoudt het standaard document welk de aannemer bij aanvang van de werken ontvangen, en hij gaat zelf per uitvoeringsfase of per vorderingsstaat, … een aangepaste, ingevulde excel overmaken aan de bouwheer."]
[]
["NIEUW: Er zijn nu twee mogelijkheden voorzien om de fiches in te vullen"]
[]
["1. Invullen vanuit de individuele fiche met een kopie van hoeveelheden naar de overzichtslijst"]
[]
["1.1 Voorbereiding - opmaak van de overzichtslijsten"]
[]
["Men moet eerst de overzichtstabel per fase vervolledigen, alle adressen waarvoor in deze fase een fiches wordt opgemaakt moet in de lijst opgenomen worden."]
["De overige adressen mogen verwijderd worden."]
[]
["Indien een woning een tweede DWA- of RWA-huisaansluiting heeft, dient ",null,null,null,null,null,null,"de aannemer",null,"zelf de bestaande lijnen voor DWA- of RWA-huisaansluiting te kopiëren in dezelfde lijst."]
["LET OP: bij het kopiëren van een nieuwe lijn moet er steeds bij het equipmentnr. een letter b genoteerd worden voor een tweede aansluiting ( zelfde type) , en bij de 3de aansluiting c, … "]
["Er mogen geen symbolen gebruilt worden, anders werkt de marco niet"]
[]
["Dit is van toepassing voor project HA, vb. twee DWA aansluiting voor eenzelfde perceel:"]
[]
[]
[]
[]
[]
[]
["Men dient de gegevens van de diameter en het gebruikte materiaal voor de aansluiting reeds op te nemen in de tabel."]
[]
["Bij de overzichtslijst van project WA, dient men de lijnen te kopiëren indien men meerdere lijnen nodig heeft. Nieuwe lijnen bijvoegen kan niet omdat dan de formules niet gekopiëerd worden."]
[]
["Ook bij de overzichtslijst project kolk, dient met extra lijnen te kopiëren en niet bij te voegen owv zelfde reden."]
[]
["Bij deze twee overzichtslijsten dienen de gegevens van de diameter en het gebruikte materiaal voor de aansluiting aangevuld te worden in de tabel."]
[]
["NOTA: indien een aansluiting gemengd water opvangt en niet alleen afvalwater, dient met het aard van het water te vervangen van DWA naar GEM, dit wordt dan ook zo opgenomen in de totaal hoeveelheden."]
[]
["1.2. Aanmaak fiches"]
[]
["Als de overzichtslijsten volledig zijn aagevuld, kan de marco gerund worden, dit per tabblad."]
[]
["Per tabblad(HA/WA/kolk) zijn er bovenaan 3 knoppen aangemaakt voor het creëren van de fiches,men kiest hier de knop ' Kopieer HA' / Kopieer WA / Kopieer kolk'. Men kan  hierop klikken voor de individuele fiches aan te maken."]
[]
[]
[]
[]
["De macro begint te runnen en op het einde hiervan komt deze pop-up te voorschijn."]
["Kies hier \" verwijderen\":"]
[]
[]
[]
[]
[]
[]
[]
[]
["Alle fiches van de geselecteerde overzichtslijst zijn aangemaakt."]
[]
["NOTA: de macro kan maar 1x gedraaid worden per overzichtslijst ( per bestand). (Er worden onderliggend formulles en gegevens bijgemaakt per tabblad.)"]
[]
["1.3. Invullen van de fiche"]
[]
["Alle gegevens per huisaansluiting moeten ingevuld worden op de fiche zelf in de gele velden. (excl. hoeveelheden op privaat domein)"]
["De gegevens op de fiche zelf in de oranje velden zijn gekopieerd vanuit de overzichtslijst."]
[]
["Alle hoeveelheden van de gele velden in de fiche, worden automatisch overgenomen in de overzichtslijst. Hieronder wordt de totale hoeveelheid weer gegeven per RWA, DWA en GEM."]
[]
["Sommige velden zijn voorzien van voorgeprogrammeerde 'keuzevelden'."]
[]
["Situatieschets: ","afhangkelijk van de situatie van het huisaansluitingsputje moet er een afstand meegedeeld worden vanuit een bepaalde grens, zie schets."]
["Men dient de juiste letter aan te duiden zodat duidelijk is welke afstand wordt meegedeeld."]
["Velvolgens moet de afstand hierachter genoteerd worden."]
[]
["Foto's:"]
["Er dienen foto's meegeleverd te worden van de DWA of GEM aansluiting en van de RWA aansluiting."]
["Tijdens 5 verschillende fases dienen deze foto's bijgevoegd te worden, dit volgens beschrijving van het standaardbestek 250 versie 4.1"]
["Ook moet er een overzichtsfoto bijgevoegd worden zodat de situering van de aansluiting duidelijk is tov de omgeving."]
["Er wordt verwezen naar het SB250 versie 4,1 voor meer uitleg hierover."]
[]
["Foto's worden niet ingevoegd in het bestand, hierdoor wordt de excel te veel belanst waardoor het bestand vertraagt/te zwaar wordt."]
["Foto's dienen via (vb.) 'knipprogramma' van windows 10 ingevoegd te worden:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Men kan de foto's openen en een 'knipsel' nemen van deze foto door op \"nieuw\"te klikken."]
["Na het selecteren hiervan druk je op de knop kopiëren:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Vervolgens ga je op de juiste locatie staan in de fiche waar de foto moet komen en gaat u plakken door vb. de sneltoetsen \" Ctrl\" + \"v\" samen ingedrukt te houden."]
["Men kan dan vervolgens nog de grootte van de afbeelding aanpassen."]
[]
["Andere mogelijk heden zijn er ook om foto's in te voegen, maar het is van belang dat deze met een zeer beperkte grote ( enkele kb) worden ingevoegd."]
[]
["NIEUW: In het tabblad 'Project HA'  zijn extra kolommen voorzien voor de hoeveelheden op privaat domein, conform genormaliseerde posten. Deze dienen manueel ingevuld te worden op de overzichtslijst, niet op de aansluitingsfiche zelf."]
[]
["2. Invullen vanuit de overzichtslijst met een kopie van hoeveelheden naar de individuele fiche"]
[]
["2.1 Voorbereiding - opmaak van de overzichtslijsten"]
[]
["Per tabblad(HA/WA/kolk) zijn er bovenaan 3 knoppen aangemaakt voor het creëren van de fiches op deze mannier,men kiest hier de knop ' Verwijder formules'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"in het tabbblad waar men gegevens wilt aanvullen."]
[]
["Vervolgens kan men nu alle gegevens invullen in de gele velden in de overzichtslijts, maw het tabbblad 'project HA' of 'project WA' of 'project klok'."]
[]
["Men werkt best per fase/per vorderingsstaat, alle adressen waarvoor in de fase een fiches wordt opgemaakt moet in de lijst opgenomen worden."]
["De overige adressen mogen verwijderd worden."]
[]
["Indien een woning een tweede DWA- of RWA-huisaansluiting heeft, dient ",null,null,null,null,null,null,"de aannemer",null,"zelf de bestaande lijnen voor DWA- of RWA-huisaansluiting te kopiëren in dezelfde lijst."]
["LET OP: bij het kopiëren van een nieuwe lijn moet er steeds bij het equipmentnr. een letter b genoteerd worden voor een tweede aansluiting ( zelfde type) , en bij de 3de aansluiting c, … "]
["Er mogen geen symbolen gebruilt worden, anders werkt de marco niet"]
[]
["Dit is van toepassing voor project HA, vb. twee DWA aansluiting voor eenzelfde perceel:"]
[]
[]
[]
[]
[]
[]
["Bij de overzichtslijst van project WA, dient men de lijnen te kopiëren indien men meerdere lijnen nodig heeft. Nieuwe lijnen bijvoegen kan niet omdat dan de formules niet gekopiëerd worden."]
[]
["Ook bij de overzichtslijst project kolk, dient met extra lijnen te kopiëren en niet bij te voegen owv zelfde reden."]
[]
["NOTA: indien een aansluiting gemengd water opvangt en niet alleen afvalwater, dient met het aard van het water te vervangen van DWA naar GEM, dit wordt dan ook zo opgenomen in de totaal hoeveelheden."]
[]
["2.2. Aanmaak fiches"]
[]
["Als de overzichtslijsten volledig zijn aagevuld, kan de volgende marco gerund worden, dit per gewenst tabblad: Kopieer XX volledige lijst, vb. "]
["Vervolgens worden alle indivuduele fiches opgemaakt met de reeds ingegevlde gegevens."]
[]
["Na het runnen van de macro komt deze pop-up te voorschijn."]
["Kies hier \" verwijderen\":"]
[]
[]
[]
[]
[]
[]
[]
["Alle fiches van de geselecteerde overzichtslijst zijn aangemaakt."]
[]
["NOTA: de macro kan maar 1x gedraaid worden per overzichtslijst ( per bestand). (Er worden onderliggend formulles en gegevens bijgemaakt per tabblad.)"]
[]
["2.3. Invullen van de fiche"]
[]
["Alle gekende gegevens per huisaansluiting vanuit de overzichtslijst zijn nu gekopieerd naar de individuele fiche."]
["De gegevens op de fiche zelf in de oranje velden zijn gekopieerd vanuit de overzichtslijst."]
[]
["Alle niet ingevulde velden zijn gele velden, deze dienen nog aangevuld te worden per fiche."]
[]
["Sommige velden zijn voorzien van voorgeprogrammeerde 'keuzevelden'."]
[]
["Situatieschets: ","afhangkelijk van de situatie van het huisaansluitingsputje moet er een afstand meegedeeld worden vanuit een bepaalde grens, zie schets."]
["Men dient de juiste letter aan te duiden zodat duidelijk is welke afstand wordt meegedeeld."]
["Velvolgens moet de afstand hierachter genoteerd worden."]
[]
["Foto's:"]
["Er dienen foto's meegeleverd te worden van de DWA of GEM aansluiting en van de RWA aansluiting."]
["Tijdens 5 verschillende fases dienen deze foto's bijgevoegd te worden, dit volgens beschrijving van het standaardbestek 250 versie 4.1"]
["Ook moet er een overzichtsfoto bijgevoegd worden zodat de situering van de aansluiting duidelijk is tov de omgeving."]
["Er wordt verwezen naar het SB250 versie 4,1 voor meer uitleg hierover."]
[]
["Foto's worden niet ingevoegd in het bestand, hierdoor wordt de excel te veel belanst waardoor het bestand vertraagt/te zwaar wordt."]
["Foto's dienen via (vb.) 'knipprogramma' van windows 10 ingevoegd te worden:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Men kan de foto's openen en een 'knipsel' nemen van deze foto door op \"nieuw\"te klikken."]
["Na het selecteren hiervan druk je op de knop kopiëren:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Vervolgens ga je op de juiste locatie staan in de fiche waar de foto moet komen en gaat u plakken door vb. de sneltoetsen \" Ctrl\" + \"v\" samen ingedrukt te houden."]
["Men kan dan vervolgens nog de grootte van de afbeelding aanpassen."]
[]
["Andere mogelijk heden zijn er ook om foto's in te voegen, maar het is van belang dat deze met een zeer beperkte grote ( enkele kb) worden ingevoegd."]
[]
["NIEUW: In het tabblad 'Project HA'  zijn extra kolommen voorzien voor de hoeveelheden op privaat domein, conform genormaliseerde posten. Deze dienen manueel ingevuld te worden op de overzichtslijst, niet op de aansluitingsfiche zelf."]
[]
["3. Switchen tussen  overzichtslijst en fiche"]
[]
["Na het runnen van de macro is er een hyperlink gecreërd tussen de overzichtslijst en fiche zelf, door hierop te klikken kan je snel tussen de verschillende tabbladeren swichten."]
["Hyperlink in de overzichtslijst, onder \" equipmentnr\":"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hyperlink in de fiche, onder \"equipmentnr\":"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4. Van de fiches PDF bestanden maken"]
[]
["Als alle fiches klaar zijn per fase, dienen deze omgezet te worden naar 1 PDF bestand per adres/fiche."]
["Dit kan door de macro, \"print naar pdf\" aan te klikken, deze knop is bovenaan dit tabblad voorzien."]
[]
["Er wordt dan van alle nieuwe tabbladen een pdf bestand gemaakt met de juiste bestandsnaam. "]
[]
["Wanneer je de macro oproept wordt de locatie gevraagd waar je de pdf-bestanden wil plaatsen."]
[]
["5. Coördinaten van de huisaansluitingsputjes"]
[]
["Op het einde van het project dient de overzichtslijst aangevuld te worden met de x,y,z-coördinaten van het huisaansluitingsputje."]
["Indien en eenuisanasluitingsputje aanwezig is, zijn dit de coördinaten van het midden van het deksle van dit putje,"]
["indien er geen putje aanwezig is, maar vb. een rechstreekse aansluiting in een open gracht, dienen de coördianten van deze aansluiting in de gracht genoteerd te worden."]

{"sheet":"Algemene gegevens","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,7,21,7],[4,7,6,7]]}
["Project gegevens"]
[]
["Rioolbeheerder"]
["Naam rioolbeheeder:"," 'keuzelijst'"]
["Projectnummer:","xx,xxx",null,null,null,null,null,"in te vullen door rioolbeheerder,  vooralleer deze wordt overgemaakt aan aannemer"]
["Projectnaam: ","BBBBBBB"]
["Gemeente:","Leuven",null,null,"gemeentecode fiche:",{"$f":"VLOOKUP(B7,Tabel2[],7,FALSE)","v":"LEU"}]
[]
["Bouwheer"]
["Naam bouwheer:"]
["Projectnummer:"]
["Projectnaam: "]
[]
["Medeopdrachtgever"]
["Naam medeopdrachtgever:"]
["Projectnummer:"]
["Projectnaam: "]
[]
["Aannemer:"]
["Naam aannemer:",null,null,null,null,null,null,"in te vullen door aannemer, voor het runnen van macro's (zie handleiding)"]
["Projectnummer:"]
["Projectleider:"]

{"sheet":"Project HA","index":2,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[[26,26,27,26],[26,27,27,27],[28,26,29,26],[28,27,29,27],[22,26,23,26],[22,27,23,27],[24,26,25,26],[24,27,25,27],[4,27,5,27],[16,27,17,27],[2,7,2,9],[4,26,5,26],[16,26,17,26],[2,10,2,20],[2,21,2,25],[18,26,19,26],[18,27,19,27],[20,26,21,26],[20,27,21,27],[6,26,7,26],[6,27,7,27],[8,26,9,26],[8,27,9,27],[10,26,11,26],[10,27,11,27],[12,26,13,26],[12,27,13,27],[14,26,15,26],[14,27,15,27]]}
["Aansluitingen bestaande woningen",null,null,null,{"$f":"COUNTA(C:C)-1","v":26}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$20\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$20\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$20\"),\"\"))),\" \")","v":" "}]
[null,null,null,null,null,null,null,"lambert 72 coördinaten - deksel HA-putje",null,null,"HOEVEELHEDEN aansluiting - openbaar domein",null,null,null,null,null,null,null,null,null,null,"HOEVEELHEDEN aansluiting - privaat domein"]
["Straat","Huisnr","Equipmentnummer riolering","aard water (RWA/DWA/GEM)","soort\n(HA, WA)","diameter\n(mm)","materiaal\n(grès, PVC,PP)","X coördinaat","Y coördinaat","Z coördinaat","Mof\n(st)","Buis -vert.\n(m)","Buis -horiz.\n(m)","Bocht\n(st)","Y/T-stuk\n(st)","Krimpmof\n(st)","Koppelstuk\n(st)","Reductie\n(st)","Stop\n(st)","diameter HA-putje of T-stuk\n( mm)","Terugslag-klep in HA-putje\n(ja/nee)","Buis\n(m)","Bocht\n(st)","Reductie\n(st)","Afdichten verlaten aansl.\n(st)","Aankoppelen regenafvoer\n(st)","naamgeving fiche"]
["straat",1,123456789,"RWA","HA",null,null,null,null,null,{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$20\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$20\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$20\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$21\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$21\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$21\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$22\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$22\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$22\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$23\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$23\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$23\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$24\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$24\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$24\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$25\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$25\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$25\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$26\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$26\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$26\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$27\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$27\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$27\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$28\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$28\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$28\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$29\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$29\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$29\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D5=\"RWA\",INDIRECT($C5&\"!$I$30\"),IF($D5=\"DWA\",INDIRECT($C5&\"!$G$30\"),IF($D5=\"GEM\",INDIRECT($C5&\"!$G$30\"),\"\"))),\" \")","v":" "},null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A5&\" \"&'Project HA'!B5&\" eq=\"&'Project HA'!C5&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 1 eq=123456789 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",1,123456789,"DWA","HA",null,null,null,null,null,{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$20\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$20\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$20\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$21\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$21\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$21\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$22\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$22\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$22\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$23\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$23\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$23\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$24\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$24\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$24\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$25\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$25\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$25\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$26\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$26\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$26\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$27\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$27\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$27\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$28\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$28\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$28\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$29\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$29\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$29\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D6=\"RWA\",INDIRECT($C6&\"!$I$30\"),IF($D6=\"DWA\",INDIRECT($C6&\"!$G$30\"),IF($D6=\"GEM\",INDIRECT($C6&\"!$G$30\"),\"\"))),\" \")","v":" "}]
["straat",2,234567888,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A7&\" \"&'Project HA'!B7&\" eq=\"&'Project HA'!C7&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 2 eq=234567888 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",2,234567888,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",3,345678901,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A9&\" \"&'Project HA'!B9&\" eq=\"&'Project HA'!C9&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 3 eq=345678901 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",3,345678901,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",4,345678902,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A11&\" \"&'Project HA'!B11&\" eq=\"&'Project HA'!C11&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 4 eq=345678902 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",4,345678902,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",5,345678903,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A13&\" \"&'Project HA'!B13&\" eq=\"&'Project HA'!C13&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 5 eq=345678903 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",5,345678903,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",6,345678904,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A15&\" \"&'Project HA'!B15&\" eq=\"&'Project HA'!C15&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 6 eq=345678904 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",6,345678904,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",7,345678905,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A17&\" \"&'Project HA'!B17&\" eq=\"&'Project HA'!C17&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 7 eq=345678905 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",7,345678905,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",8,345678906,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A19&\" \"&'Project HA'!B19&\" eq=\"&'Project HA'!C19&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 8 eq=345678906 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",8,345678906,"DWA","HA",null,null,null,null,null,{"$f":"IFERROR(IF($D20=\"RWA\",INDIRECT($C20&\"!$I$20\"),IF($D20=\"DWA\",INDIRECT($C20&\"!$G$20\"),IF($D20=\"GEM\",INDIRECT($C20&\"!$G$20\"),\"\"))),\" \")","v":" "}," "," "," "," "," "," "," "," "," "," "]
["straat",9,345678911,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A21&\" \"&'Project HA'!B21&\" eq=\"&'Project HA'!C21&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 9 eq=345678911 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",9,345678911,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",10,345678907,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A23&\" \"&'Project HA'!B23&\" eq=\"&'Project HA'!C23&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 10 eq=345678907 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",10,345678907,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",11,345678908,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A25&\" \"&'Project HA'!B25&\" eq=\"&'Project HA'!C25&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 11 eq=345678908 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",11,345678908,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",12,345678909,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A27&\" \"&'Project HA'!B27&\" eq=\"&'Project HA'!C27&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 12 eq=345678909 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",12,345678909,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",13,345678910,"RWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project HA'!A29&\" \"&'Project HA'!B29&\" eq=\"&'Project HA'!C29&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat 13 eq=345678910 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
["straat",13,345678910,"DWA","HA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
[]
[]
["TOTAAL hoeveelheden:","RWA",null,null,null,null,null,null,null,null,{"$f":"SUMIF($D$5:$D33,$B33,K$5:K33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,L$5:L33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,M$5:M33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,N$5:N33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,O$5:O33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,P$5:P33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,Q$5:Q33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,R$5:R33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,S$5:S33)","v":0},null,null,{"$f":"SUMIF($D$5:$D33,$B33,V$5:V33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,W$5:W33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,X$5:X33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,Y$5:Y33)","v":0},{"$f":"SUMIF($D$5:$D33,$B33,Z$5:Z33)","v":0}]
[null,"DWA",null,null,null,null,null,null,null,null,{"$f":"SUMIF($D$5:$D34,$B34,K$5:K34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,L$5:L34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,M$5:M34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,N$5:N34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,O$5:O34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,P$5:P34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,Q$5:Q34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,R$5:R34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,S$5:S34)","v":0},null,null,{"$f":"SUMIF($D$5:$D34,$B34,V$5:V34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,W$5:W34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,X$5:X34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,Y$5:Y34)","v":0},{"$f":"SUMIF($D$5:$D34,$B34,Z$5:Z34)","v":0}]
[null,"GEM",null,null,null,null,null,null,null,null,{"$f":"SUMIF($D$5:$D35,$B35,K$5:K35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,L$5:L35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,M$5:M35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,N$5:N35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,O$5:O35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,P$5:P35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,Q$5:Q35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,R$5:R35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,S$5:S35)","v":0},null,null,{"$f":"SUMIF($D$5:$D35,$B35,V$5:V35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,W$5:W35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,X$5:X35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,Y$5:Y35)","v":0},{"$f":"SUMIF($D$5:$D35,$B35,Z$5:Z35)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Project WA","index":3,"n_rows":33,"n_cols":23,"rows_kept":33,"cut":false,"hidden":false,"merged":[[24,21,25,21],[24,22,25,22],[26,21,27,21],[26,22,27,22],[18,21,19,21],[18,22,19,22],[20,21,21,21],[20,22,21,22],[22,21,23,21],[22,22,23,22],[12,21,13,21],[12,22,13,22],[14,21,15,21],[14,22,15,22],[16,21,17,21],[16,22,17,22],[10,21,11,21],[10,22,11,22],[4,7,4,9],[6,22,7,22],[8,21,9,21],[8,22,9,22],[4,10,4,20],[6,21,7,21]]}
["Wachtaansluitingen voor onbebouwde percelen",null,null,null,{"$f":"COUNTA(C:C)-1","v":22}]
[]
["=> Door aannemer een plan bij te voegen waar welke wachtaansluiting voorzien is volgens 'volgnummer' ",null,null,null,null,null," ",null,null," ","  ","  ","  "]
[]
[null,null,null,null,null,null,null,"lambert coördinaten - deksel HA-putje",null,null,"HOEVEELHEDEN aansluiting - openbaar domein"]
["Straat\n( + eventueel huisnummer)","Volgnr.\nof\nLot nr.","Equipmentnummer riolering","aard water (RWA/DWA/GEM)","soort\n(HA, WA)","diameter\n(mm)","materiaal\n(grès, PVC,PP)","X coördinaat","Y coördinaat","Z coördinaat","Mof\n(st)","Buis -vert.\n(m)","Buis -horiz.\n(m)","Bocht\n(st)","Y/T-stuk\n(st)","Krimpmof\n(st)","Koppelstuk\n(st)","Reductie\n(st)","Stop\n(st)","diameter HA-putje of T-stuk\n( mm)","Terugslag-klep in HA-putje\n(ja/nee)","naamgeving fiche"]
["straat","01",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B7","v":"xx,xxx-volgnr01"},"RWA","WA",null,null,null,null,null,{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$20\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$20\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$20\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$21\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$21\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$21\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$22\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$22\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$22\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$23\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$23\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$23\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$24\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$24\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$24\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$25\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$25\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$25\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$26\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$26\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$26\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$27\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$27\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$27\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$28\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$28\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$28\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$29\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$29\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$29\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D7=\"RWA\",INDIRECT(\"'\"&$C7&\"'!$I$30\"),IF($D7=\"DWA\",INDIRECT(\"'\"&$C7&\"'!$G$30\"),IF($D7=\"GEM\",INDIRECT(\"'\"&$C7&\"'!$G$30\"),\"\"))),\" \")","v":" "},{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A7&\" \"&\"wa=\"&'Project WA'!C7&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr01 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A7","v":"straat"},"01",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B8","v":"xx,xxx-volgnr01"},"DWA","WA",null,null,null,null,null,{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$20\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$20\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$20\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$21\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$21\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$21\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$22\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$22\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$22\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$23\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$23\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$23\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$24\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$24\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$24\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$25\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$25\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$25\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$26\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$26\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$26\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$27\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$27\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$27\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$28\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$28\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$28\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$29\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$29\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$29\"),\"\"))),\" \")","v":" "},{"$f":"IFERROR(IF($D8=\"RWA\",INDIRECT(\"'\"&$C8&\"'!$I$30\"),IF($D8=\"DWA\",INDIRECT(\"'\"&$C8&\"'!$G$30\"),IF($D8=\"GEM\",INDIRECT(\"'\"&$C8&\"'!$G$30\"),\"\"))),\" \")","v":" "}]
["straat","02",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B9","v":"xx,xxx-volgnr02"},"RWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A9&\" \"&\"wa=\"&'Project WA'!C9&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr02 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A9","v":"straat"},"02",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B10","v":"xx,xxx-volgnr02"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat","03",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B11","v":"xx,xxx-volgnr03"},"RWA","WA",null,null,null,null,null," "," ",{"$f":"IFERROR(IF($D11=\"RWA\",INDIRECT(\"'\"&$C11&\"'!$I$22\"),IF($D11=\"DWA\",INDIRECT(\"'\"&$C11&\"'!$G$22\"),IF($D11=\"GEM\",INDIRECT(\"'\"&$C11&\"'!$G$22\"),\"\"))),\" \")","v":" "}," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A11&\" \"&\"wa=\"&'Project WA'!C11&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr03 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A11","v":"straat"},"03",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B12","v":"xx,xxx-volgnr03"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat","04",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B13","v":"xx,xxx-volgnr04"},"RWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A13&\" \"&\"wa=\"&'Project WA'!C13&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr04 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A13","v":"straat"},"04",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B14","v":"xx,xxx-volgnr04"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat","05",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B15","v":"xx,xxx-volgnr05"},"RWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A15&\" \"&\"wa=\"&'Project WA'!C15&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr05 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A15","v":"straat"},"05",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B16","v":"xx,xxx-volgnr05"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat","06",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B17","v":"xx,xxx-volgnr06"},"RWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A17&\" \"&\"wa=\"&'Project WA'!C17&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr06 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A17","v":"straat"},"06",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B18","v":"xx,xxx-volgnr06"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat","07",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B19","v":"xx,xxx-volgnr07"},"RWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A19&\" \"&\"wa=\"&'Project WA'!C19&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr07 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A19","v":"straat"},"07",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B20","v":"xx,xxx-volgnr07"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat","08",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B21","v":"xx,xxx-volgnr08"},"RWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A21&\" \"&\"wa=\"&'Project WA'!C21&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr08 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A21","v":"straat"},"08",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B22","v":"xx,xxx-volgnr08"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat","09",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B23","v":"xx,xxx-volgnr09"},"RWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A23&\" \"&\"wa=\"&'Project WA'!C23&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr09 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A23","v":"straat"},"09",{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B24","v":"xx,xxx-volgnr09"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",10,{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B25","v":"xx,xxx-volgnr10"},"RWA","WA",null,null," ",null,null," "," "," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A25&\" \"&\"wa=\"&'Project WA'!C25&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr10 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A25","v":"straat"},10,{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B26","v":"xx,xxx-volgnr10"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
["straat",11,{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B27","v":"xx,xxx-volgnr11"},"RWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project WA'!A27&\" \"&\"wa=\"&'Project WA'!C27&\" AB-HA-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat wa=xx,xxx-volgnr11 AB-HA-fiche"},"1 document voor RWA en DWA aansluiting"]
[{"$f":"A27","v":"straat"},11,{"$f":"'Algemene gegevens'!$B$5&\"-volgnr\"&'Project WA'!B28","v":"xx,xxx-volgnr11"},"DWA","WA",null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "]
[]
[]
["TOTAAL hoeveelheden:","RWA",null,null,null,null,null,null,null,null,{"$f":"SUMIF($D$7:$D$30,$B$31,K$7:K28)","v":0},{"$f":"SUMIF($D$7:$D$30,$B$31,L$7:L28)","v":0},{"$f":"SUMIF($D$7:$D$30,$B$31,M$7:M28)","v":0},{"$f":"SUMIF($D$7:$D$30,$B$31,N$7:N28)","v":0},{"$f":"SUMIF($D$7:$D$30,$B$31,O$7:O28)","v":0},{"$f":"SUMIF($D$7:$D$30,$B$31,P$7:P28)","v":0},{"$f":"SUMIF($D$7:$D$30,$B$31,Q$7:Q28)","v":0},{"$f":"SUMIF($D$7:$D$30,$B$31,R$7:R28)","v":0},{"$f":"SUMIF($D$7:$D$30,$B$31,S$7:S28)","v":0}]
[null,"DWA",null,null,null,null,null,null,null,null,{"$f":"SUMIF($D$7:$D$31,$B$32,K$7:K28)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$32,L$7:L28)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$32,M$7:M28)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$32,N$7:N28)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$32,O$7:O28)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$32,P$7:P28)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$32,Q$7:Q28)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$32,R$7:R28)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$32,S$7:S28)","v":0}]
[null,"GEM",null,null,null,null,null,null,null,null,{"$f":"SUMIF($D$7:$D$31,$B$52,K$7:K30)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$52,L$7:L30)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$52,M$7:M30)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$52,N$7:N30)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$52,O$7:O30)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$52,P$7:P30)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$52,Q$7:Q30)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$52,R$7:R30)","v":0},{"$f":"SUMIF($D$7:$D$31,$B$52,S$7:S30)","v":0}]

{"sheet":"Project kolk","index":4,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,7,4,15]]}
["Kolkaansluitingen",null,null,null,{"$f":"COUNTA(C:C)-1","v":24}]
[]
["=> Door aannemer een plan bij te voegen waar welke kolkaansluiting voorzien is volgens 'volgnummer' "]
[]
[null,null,null,null,null,null,null,"HOEVEELHEDEN aansluiting"]
["Straat\n( + eventueel huisnummer)","Volgnr.","Equipmentnummer riolering","aard water (RWA/DWA/GEM)","soort","diameter\n(mm)","materiaal\n(grès, PVC,PP)","Mof\n(st)","Buis -vert.\n(m)","Buis -horiz.\n(m)","Bocht\n(st)","Y/T-stuk\n(st)","Krimpmof\n(st)","Koppelstuk\n(st)","Reductie\n(st)","Stop\n(st)","naamgeving fiche"]
["straat","01",{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B7","v":"xx,xxx-kolknr01"},"RWA","kolk",null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C7&\"'!$E$20\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C7&\"'!$E$21\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C7&\"'!$E$22\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C7&\"'!$E$23\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C7&\"'!$E$24\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C7&\"'!$E$25\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C7&\"'!$E$26\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C7&\"'!$E$27\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C7&\"'!$E$28\"),\" \")","v":" "},{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A7&\" ko=\"&C7&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr01 AB-kolk-fiche"}]
["straat","02",{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B8","v":"xx,xxx-kolknr02"},"RWA","kolk",null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C8&\"'!$E$20\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C8&\"'!$E$21\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C8&\"'!$E$22\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C8&\"'!$E$23\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C8&\"'!$E$24\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C8&\"'!$E$25\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C8&\"'!$E$26\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C8&\"'!$E$27\"),\" \")","v":" "},{"$f":"IFERROR(INDIRECT(\"'\"&$C8&\"'!$E$28\"),\" \")","v":" "},{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A8&\" ko=\"&C8&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr02 AB-kolk-fiche"}]
["straat","03",{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B9","v":"xx,xxx-kolknr03"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A9&\" ko=\"&C9&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr03 AB-kolk-fiche"}]
["straat","04",{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B10","v":"xx,xxx-kolknr04"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A10&\" ko=\"&C10&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr04 AB-kolk-fiche"}]
["straat","05",{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B11","v":"xx,xxx-kolknr05"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A11&\" ko=\"&C11&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr05 AB-kolk-fiche"}]
["straat","06",{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B12","v":"xx,xxx-kolknr06"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A12&\" ko=\"&C12&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr06 AB-kolk-fiche"}]
["straat","07",{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B13","v":"xx,xxx-kolknr07"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A13&\" ko=\"&C13&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr07 AB-kolk-fiche"}]
["straat","08",{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B14","v":"xx,xxx-kolknr08"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A14&\" ko=\"&C14&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr08 AB-kolk-fiche"}]
["straat","09",{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B15","v":"xx,xxx-kolknr09"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A15&\" ko=\"&C15&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr09 AB-kolk-fiche"}]
["straat",10,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B16","v":"xx,xxx-kolknr10"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A16&\" ko=\"&C16&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr10 AB-kolk-fiche"}]
["straat",11,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B17","v":"xx,xxx-kolknr11"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A17&\" ko=\"&C17&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr11 AB-kolk-fiche"}]
["straat",12,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B18","v":"xx,xxx-kolknr12"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A18&\" ko=\"&C18&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr12 AB-kolk-fiche"}]
["straat",13,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B19","v":"xx,xxx-kolknr13"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A19&\" ko=\"&C19&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr13 AB-kolk-fiche"}]
["straat",14,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B20","v":"xx,xxx-kolknr14"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A20&\" ko=\"&C20&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr14 AB-kolk-fiche"}]
["straat",15,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B21","v":"xx,xxx-kolknr15"},"RWA","kolk",null,null," "," "," "," "," "," "," "," ",null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A21&\" ko=\"&C21&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr15 AB-kolk-fiche"}]
["straat",16,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B22","v":"xx,xxx-kolknr16"},"RWA","kolk",null,null," "," "," "," "," "," "," "," ",null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A22&\" ko=\"&C22&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr16 AB-kolk-fiche"}]
["straat",17,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B23","v":"xx,xxx-kolknr17"},"RWA","kolk",null,null," "," "," "," "," "," "," "," ",null,{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A23&\" ko=\"&C23&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr17 AB-kolk-fiche"}]
["straat",18,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B24","v":"xx,xxx-kolknr18"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A24&\" ko=\"&C24&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr18 AB-kolk-fiche"}]
["straat",19,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B25","v":"xx,xxx-kolknr19"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A25&\" ko=\"&C25&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr19 AB-kolk-fiche"}]
["straat",20,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B26","v":"xx,xxx-kolknr20"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A26&\" ko=\"&C26&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr20 AB-kolk-fiche"}]
["straat",21,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B27","v":"xx,xxx-kolknr21"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A27&\" ko=\"&C27&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr21 AB-kolk-fiche"}]
["straat",22,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B28","v":"xx,xxx-kolknr22"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A28&\" ko=\"&C28&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr22 AB-kolk-fiche"}]
["straat",23,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B29","v":"xx,xxx-kolknr23"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A29&\" ko=\"&C29&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr23 AB-kolk-fiche"}]
["straat",24,{"$f":"'Algemene gegevens'!$B$5&\"-kolknr\"&B30","v":"xx,xxx-kolknr24"},"RWA","kolk",null,null," "," "," "," "," "," "," "," "," ",{"$f":"\"GEM=\"&'Algemene gegevens'!$F$7&\" projectnr=\"&'Algemene gegevens'!$B$5&\" adres=\"&'Project kolk'!A30&\" ko=\"&C30&\" AB-kolk-fiche\"","v":"GEM=LEU projectnr=xx,xxx adres=straat ko=xx,xxx-kolknr24 AB-kolk-fiche"}]
[]
[]
["TOTAAL hoeveelheden:","KOLK",null,null,null,null,null,{"$f":"SUM(H7:H32)","v":0},{"$f":"SUM(I7:I32)","v":0},0,0,0,0,0,0,0]

{"sheet":"huisaansluitingen","index":5,"n_rows":71,"n_cols":10,"rows_kept":71,"cut":false,"hidden":false,"merged":[[70,0,70,4],[70,5,70,9],[71,0,71,4],[71,5,71,9],[68,0,68,4],[68,5,68,9],[69,0,69,4],[69,5,69,9],[65,0,65,9],[66,0,66,4],[66,5,66,9],[67,0,67,4],[67,5,67,9],[62,0,62,4],[62,5,62,9],[63,0,63,9],[64,0,64,4],[64,5,64,9],[60,0,60,4],[60,5,60,9],[61,0,61,4],[61,5,61,9],[58,0,58,9],[59,0,59,4],[59,5,59,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[29,8,29,9],[30,0,30,7],[31,0,31,7],[32,0,32,7],[57,0,57,4],[57,5,57,9],[53,2,53,3],[54,2,54,3],[33,3,34,5],[27,0,27,2],[28,0,28,2],[29,0,29,2],[24,3,24,5],[25,3,25,5],[56,0,56,9],[33,0,34,2],[33,6,34,7],[29,6,29,7],[31,8,31,9],[32,8,32,9],[17,0,17,2],[11,0,11,5],[14,8,14,9],[15,6,15,7],[16,6,16,7],[17,6,17,7],[33,8,34,9],[26,3,26,5],[27,3,27,5],[28,3,28,5],[29,3,29,5],[14,3,14,5],[21,3,21,5],[22,3,22,5],[23,3,23,5],[18,6,18,7],[18,8,18,9],[26,0,26,2],[15,0,15,2],[16,0,16,2],[22,0,22,2],[23,0,23,2],[6,7,6,9],[0,0,0,9],[5,7,5,9],[4,7,4,9],[2,1,2,9],[3,1,3,9],[4,1,4,5],[5,1,5,5],[6,1,6,5],[1,0,1,9],[7,8,7,9],[10,0,10,5],[10,6,10,7],[12,0,12,5],[8,6,8,7],[7,6,7,7],[9,0,9,5],[14,6,14,7],[8,8,8,9],[10,8,10,9],[14,0,14,1],[24,0,24,2],[25,0,25,2],[15,3,15,5],[16,3,16,5],[17,3,17,5],[19,3,19,5],[20,3,20,5],[18,3,18,5],[19,0,19,2],[20,0,20,2],[21,0,21,2],[18,0,18,2]]}
["\"naam fiche\""]
["Huisaansluitingsfiche"]
["Projectnummer:",{"$f":"'Algemene gegevens'!B5","v":"xx,xxx"}]
["Projectnaam:",{"$f":"'Algemene gegevens'!B6","v":"BBBBBBB"}]
["Straat:",null,null,null,null,null,"Huisnr/Volgnr:"]
["Gemeente:",{"$f":"'Algemene gegevens'!B7","v":"Leuven"},null,null,null,null,"Equipmentnr:"]
["Aannemer:",{"$f":"'Algemene gegevens'!B20","v":0},null,null,null,null,"Datum:"]
[null,null,null,null,null,null,"DWA/GEM",null,"RWA"]
["Gelegen tussen volgende toegangs- en verbindingsputten:"]
["Afstand midden stroomafwaartse put tot mof:",null,null,null,null,null,null,"m",null,"m"]
["Beschrijving liggen HA-putje:",null,null,null,null,null,"'keuzelijst'",null,"'keuzelijst'"]
["Diepte HA-putje/aansluiting tov MV:",null,null,null,null,null,null,"m",null,"m"]
["Diepte aanboring op hoofdriool tov MV (op best. riolering):",null,null,null,null,null,null,"m",null,"m"]
[]
["HOEVEELHEDEN",null,null,"opmerking",null,null,"DWA/GEM",null,"RWA"]
["Gebruik:",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($H$6&\"DWA\",'Project WA'!C:U,4,FALSE)),\nIF(ISERROR(VLOOKUP($H$6&\"GEM\",'Project WA'!C:U,4,FALSE)),\"\",(VLOOKUP($H$6&\"GEM\",'Project WA'!C:U,4,FALSE))),\n(VLOOKUP($H$6&\"DWA\",'Project WA'!C:U,4,FALSE)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($H$6&\"RWA\",'Project WA'!C:U,4,FALSE)),\"\",VLOOKUP($H$6&\"RWA\",'Project WA'!C:U,4,FALSE))","v":""}]
["Materiaal:",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($H$6&\"DWA\",'Project WA'!C:U,6,FALSE)),\nIF(ISERROR(VLOOKUP($H$6&\"GEM\",'Project WA'!C:U,6,FALSE)),\"\",(VLOOKUP($H$6&\"GEM\",'Project WA'!C:U,6,FALSE))),\n(VLOOKUP($H$6&\"DWA\",'Project WA'!C:U,6,FALSE)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($H$6&\"RWA\",'Project WA'!C:U,6,FALSE)),\"\",VLOOKUP($H$6&\"RWA\",'Project WA'!C:U,6,FALSE))","v":""}]
["Diameter buis (mm):",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($H$6&\"DWA\",'Project WA'!C:U,5,FALSE)),\nIF(ISERROR(VLOOKUP($H$6&\"GEM\",'Project WA'!C:U,5,FALSE)),\"\",(VLOOKUP($H$6&\"GEM\",'Project WA'!C:U,5,FALSE))),\n(VLOOKUP($H$6&\"DWA\",'Project WA'!C:U,5,FALSE)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($H$6&\"RWA\",'Project WA'!C:U,5,FALSE)),\"\",VLOOKUP($H$6&\"RWA\",'Project WA'!C:U,5,FALSE))","v":""}]
["Type aansluiting op hoofdriool:",null,null,null,null,null,"'keuzelijst'",null,"'keuzelijst'"]
["Mof:",null,null,null,null,null,null,"st",null,"st"]
["Buis - verticaal aangelegd:",null,null,null,null,null,null,"m",null,"m"]
["Buis - horizontaal aangelegd:",null,null,null,null,null,null,"m",null,"m"]
["Bocht:",null,null,null,null,null,null,"st",null,"st"]
["Y/T-stuk:",null,null,null,null,null,null,"st",null,"st"]
["Krimpmof:",null,null,null,null,null,null,"st",null,"st"]
["Koppelstuk:",null,null,null,null,null,null,"st",null,"st"]
["Reductie:",null,null,null,null,null,null,"st",null,"st"]
["Stop:",null,null,null,null,null,null,"st",null,"st"]
["ø HA-putje of T-stuk - 1 stuk:",null,null,null,null,null,null,"mm",null,"mm"]
["Terugslagklep in HA-putje",null,null,null,null,null," ' keuzelijst'",null," ' keuzelijst'"]
["Aansluitingen bovengrondse regenafvoer (RWA):",null,null,null,null,null,null,null,null,"st"]
["RWA - infiltratieputje:",null,null,null,null,null,null,null," ' keuzelijst'"]
["RWA aansluiting op opengracht:",null,null,null,null,null,null,null," ' keuzelijst'"]
["Plaats van de aansluiting op de riolering gezien van stroomafwaarts naar stroomopwaarts ( graden):",null,null,null,null,null,"'keuzelijst'",null,"'keuzelijst'"]
[]
["Situatieschets grondplan HA-putje tov perceel:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["indien bouwlijn = rooilijn; vertikale afstand = van gevel tot HA-putje"]
[]
["afstand DWAputje",null,null,null,null,null,"afstand RWAputje"]
["horizontaal:","letter",null,null,"m",null,"horizontaal:","letter",null,"m"]
["vertikaal:","letter",null,null,"m",null,"vertikaal:","letter",null,"m"]
[]
["\"naam fiche\""]
["Foto's: DWA/GEM",null,null,null,null,"Foto's: RWA"]
["Foto's volgens vlariobestek 250 versie 4.1"]
["1. boring of opening van aansluiting op hoofdriool",null,null,null,null,"1. boring of opening van aansluiting op hoofdriool"]
[]
["2. na plaatsing fundering, buizen, hulpstukken en HA-putje, vanaf de aansluitopening richting putje,indien niet alle hulpstukken te zien zijn, \neventueel ook foto vanuit omgekeerd standpunt",null,null,null,null,"2. na plaatsing fundering, buizen, hulpstukken en HA-putje, vanaf de aansluitopening richting putje,indien niet alle hulpstukken te zien zijn, \neventueel ook foto vanuit omgekeerd standpunt"]
[]
["\"naam fiche\""]
["Foto's: DWA/GEM",null,null,null,null,"Foto's: RWA"]
["Foto's volgens vlariobestek 250 versie 4.1"]
["2. vervolg foto 2",null,null,null,null,"2. vervolg foto 2"]
[]
["3. verbinding tss HAputje en bestaande privé-riool",null,null,null,null,"3. verbinding tss HAputje en bestaande privé-riool"]
[]
["4. zelfde als foto 2, maar met omhulling",null,null,null,null,"4. zelfde als foto 2, maar met omhulling"]

{"sheet":"kolkaansluitingen","index":6,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[39,0,39,7],[41,0,41,2],[40,0,40,7],[41,3,41,7],[44,3,44,7],[45,3,45,7],[43,0,43,7],[42,0,42,7],[44,0,44,2],[45,0,45,2],[35,0,35,2],[35,3,35,7],[18,0,18,1],[18,2,18,3],[18,4,18,5],[18,6,18,7],[33,0,33,7],[20,0,20,1],[21,0,21,1],[37,0,37,7],[1,0,1,7],[38,0,38,7],[15,6,15,7],[28,0,28,3],[28,4,28,5],[29,0,29,3],[29,4,29,5],[16,2,16,3],[16,4,16,5],[17,0,17,1],[17,2,17,3],[17,4,17,5],[27,2,27,3],[14,6,14,7],[34,0,34,7],[11,6,11,7],[15,2,15,3],[15,4,15,5],[8,4,8,5],[9,0,9,3],[10,0,10,3],[11,0,11,3],[14,2,14,3],[14,4,14,5],[0,0,0,7],[3,1,3,7],[4,1,4,3],[4,5,4,7],[32,0,32,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[30,0,31,1],[30,2,31,3],[30,4,31,5],[27,6,27,7],[28,6,28,7],[29,6,29,7],[2,1,2,7],[30,6,31,7],[16,6,16,7],[17,6,17,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[5,1,5,3],[5,5,5,7],[6,1,6,3],[6,5,6,7],[7,4,7,5],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
["\"naam fiche\""]
["Kolk-aansluitingsfiche"]
["Projectnummer:",{"$f":"'Algemene gegevens'!B5","v":"xx,xxx"}]
["Projectnaam:",{"$f":"'Algemene gegevens'!B6","v":"BBBBBBB"}]
["Straat:",null,null,null,"Volgnr.:"]
["Gemeente:",{"$f":"'Algemene gegevens'!B7","v":"Leuven"},null,null,"Equipmentnr:"]
["Aannemer:",{"$f":"'Algemene gegevens'!B20","v":0},null,null,"Datum:"]
[null,null,null,null,"RWA",null,"opmerking"]
["Gelegen tussen volgende toegangs- en verbindingsputten:"]
["Afstand midden stroomafwaartse put tot mof:",null,null,null,null,"m"]
["Diepte aansluiting tov MV:",null,null,null,null,"m"]
["Diepte aanboring op hoofdriool tov MV (op best. riolering):",null,null,null,null,"m"]
[]
[]
["HOEVEELHEDEN",null,null,null,"RWA",null,"opmerking"]
["Gebruik:",null,null,null,{"$f":"IFERROR(VLOOKUP($F$6,'Project kolk'!C:G,3,FALSE),\" \")","v":" "}]
["Materiaal:",null,null,null,{"$f":"IFERROR(VLOOKUP($F$6,'Project kolk'!C:G,5,FALSE),\" \")","v":" "}]
["Diameter buis (mm):",null,null,null,{"$f":"IFERROR(VLOOKUP($F$6,'Project kolk'!C:G,4,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "]
["Type aansluiting op hoofdriool:",null,null,null,"'keuzelijst'",null,null,null,null,null,null,null," "]
["Mof:",null,null,null,null,"st"]
["Buis - verticaal aangelegd:",null,null,null,null,"m"]
["Buis - horizontaal aangelegd:",null,null,null,null,"m"]
["Bocht:",null,null,null,null,"st"]
["Y/T-stuk:",null,null,null,null,"st"]
["Krimpmof:",null,null,null,null,"st"]
["Koppelstuk:",null,null,null,null,"st"]
["Reductie:",null,null,null,null,"st"]
["Stop:",null,null,null,null,"st"]
["RWA - infiltratieklok:",null,null,null," ' keuzelijst'"]
["KOLK aansluiting op opengracht:",null,null,null," ' keuzelijst'"]
["Plaats van de aansluiting op de riolering gezien van stroomafwaarts naar stroomopwaarts ( graden):",null,null,null,"'keuzelijst'"]
[]
["Foto's: kolk"]
["Foto's volgens vlariobestek 250 versie 4.1"]
["1. boring of opening van aansluiting op hoofdriool"]
[]
[]
["\"naam fiche\""]
["Foto's: kolk"]
["Foto's volgens vlariobestek 250 versie 4.1"]
["2. na plaatsing fundering, buizen, hulpstukken en HA-putje, vanaf de aansluitopening richting putje,indien niet alle hulpstukken te zien zijn, eventueel ook foto vanuit omgekeerd standpunt"]
[]
["3. verbinding tss HAputje en bestaande privé-riool"]
["4. zelfde als foto 2, maar met omhulling"]

{"sheet":"keuzelijsten","index":7,"n_rows":302,"n_cols":26,"rows_kept":302,"cut":false,"hidden":false,"merged":[[16,14,16,15]]}
["gegevens lijst VMM dd. maart 2022"]
["Gemeente","Postcode","Stad/gemeente","Provincie","watermaatschappij","rioolbeheerder","gemeentecode",null,"ontvangen gegevens "]
["Aalst",9300,"stad","Oost-Vlaanderen","Farys (TMVW) ","Gemeente ","Aalst ",null,"GEMNAAM","gemeentecode",null,null,null,null,"Beschrijving liggen HA-putje:",null,"Plaats van de aansluiting op de riolering gezien van stroomafwaarts naar stroomopwaarts ( graden):",null,"Type aansluiting op hoofdriool:",null,"ja/nee optie",null,"afstand DWAputje horizontaal","afstand DWAputje vertikaal","afstand RWAputje vertikaal","afstand RWAputje horizontaal"]
["Aalter",9880,"gem.","Oost-Vlaanderen","Farys (TMVW) ","Gemeente (9880- 9881) AquaRio (9910) ","Aalter ",null,"AARTSELAAR","AA",null,"pidpa"]
["Aarschot",3200,"stad","Vlaams-Brabant","De Watergroep (VMW) ","Riopact-vennoot ","ARS",null,"ARENDONK","AR"]
["Aartselaar",2630,"gem.","Antwerpen","Pidpa ","HidroRio ","AA",null,"BALEN","BA",null,null,null,null,"oprit",null,"90°",null,"T-buis",null,"ja",null,"a","g","m","u"]
["Affligem",1790,"gem.","Vlaams-Brabant","Farys (TMVW) ","AquaRio ","Affligem ",null,"BORSBEEK","BB",null,null,null,null,"voortuin",null,"135°",null,"T-stuk",null,"nee",null,"b","h","n","v"]
["Alken",3570,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","AL",null,"BERLAAR","BE",null,null,null,null,"berm",null,"180°",null,"Y-stuk",null,null,null,"c",null,null,"w"]
["Alveringem",8690,"gem.","West-Vlaanderen","Aquaduin ","Aquaduin ","Alveringem ",null,"BONHEIDEN","BH",null,null,null,null,"voetpad",null,"225°",null,"felxibele aansluiting",null,null,null,"d",null,null,"x"]
["Antwerpen",2000,"stad","Antwerpen","Water-link (AWW) ","Rio-link ","Antwerpen ",null,"BORNEM","BM",null,null,null,null,"fietspad",null,"270°",null,"aanboring",null,null,null,"e",null,null,"y"]
["Anzegem",8570,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","ANZ",null,"BAARLE-HERTOG","BN",null,null,null,null,"MANUEEL INVULLEN",null,"NVT",null,null,null,null,null,"f",null,null,"z"]
["Ardooie",8850,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","ARD",null,"BOOM","BO"]
["Arendonk",2370,"gem.","Antwerpen","Pidpa ","Gemeente ","Arendonk ",null,"BRASSCHAAT","BR"]
["As",3665,"gem.","Limburg","De Watergroep (VMW) ","Gemeente ","AS",null,"BEERSE","BS"]
["Asse",1730,"gem.","Vlaams-Brabant","Farys (TMVW) ","AquaRio ","Asse ",null,"BRECHT","BT"]
["Assenede",9960,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","ASN",null,"Boechout-Vremde","BV"]
["Avelgem",8580,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","Avelgem ",null,"DUFFEL","DF",null,null,null,null,"Naam rioolbeheeder:"]
["Baarle-Hertog",2387,"gem.","Antwerpen","Pidpa + Brabant-Water ","Gemeente ","Baarle-Hertog ",null,"DESSEL","DS",null,null,null,null,"AGSO Knokke-Heist "]
["Balen",2490,"gem.","Antwerpen","Pidpa ","HidroRio ","BA",null,"ESSEN","ES",null,null,null,null,"Aquaduin"]
["Beernem",8730,"gem.","West-Vlaanderen","Farys (TMVW) ","Gemeente ","Beernem ",null,"GROBBENDONK","GB",null,null,null,null,"Aquario"]
["Beerse",2340,"gem.","Antwerpen","Pidpa ","Fluvius West ","BS",null,"GEEL","GE",null,null,null,null,"Fluvius"]
["Beersel",1650,"gem.","Vlaams-Brabant","Farys (TMVW) ","AquaRio ","Beersel ",null,"HEIST-OP-DEN-BERG","HB",null,null,null,null,"Gemeente"]
["Begijnendijk",3130,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","BD",null,"HERENTHOUT","HH",null,null,null,null,"Pidpa"]
["Bekkevoort",3460,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","BK",null,"HEMIKSEM","HM",null,null,null,null,"Rio-link"]
["Beringen",3580,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","BE",null,"HOOGSTRATEN","HO",null,null,null,null,"Riopact"]
["Berlaar",2590,"gem.","Antwerpen","Pidpa ","HidroRio ","BE",null,"HERENTALS","HR"]
["Berlare",9290,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","BER",null,"HERSELT","HS"]
["Bertem",3060,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","BL",null,"HULSHOUT","HU"]
["Bever",1547,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","BB",null,"KALMTHOUT","KH"]
["Beveren",9120,"gem.","Oost-Vlaanderen","De Watergroep (VMW) + Water-link (AWW) ","Gemeente ","BEV",null,"KASTERLEE","KL"]
["Bierbeek",3360,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","BIE",null,"KAPELLEN","KP"]
["Bilzen",3740,"stad","Limburg","De Watergroep (VMW) ","Gemeente ","BIL",null,"Kontich-Waarloos","KT"]
["Blankenberge",8370,"stad","West-Vlaanderen","Farys (TMVW) ","AquaRio ","Blankenberge ",null,"LAAKDAL","LA"]
["Bocholt",3950,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","BT",null,"LILLE","LL"]
["Boechout",2530,"gem.","Antwerpen","Pidpa ","HidroGem ","BV",null,"LIER","LR"]
["Bonheiden",2820,"gem.","Antwerpen","Pidpa ","HidroRio ","BH",null,"LINT","LT"]
["Boom",2850,"gem.","Antwerpen","Pidpa ","HidroGem ","BO",null,"MALLE","MA"]
["Boortmeerbeek",3190,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","BM",null,"MECHELEN","ME"]
["Borgloon",3840,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","BO",null,"MEERHOUT","MH"]
["Bornem",2880,"gem.","Antwerpen","Pidpa ","Gemeente ","Bornem ",null,"MOL","MO"]
["Borsbeek",2150,"gem.","Antwerpen","Pidpa ","HidroRio ","BB",null,"MERKSPLAS","MP"]
["Boutersem",3370,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","BV",null,"NIJLEN","NI"]
["Brakel",9660,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Brakel ",null,"NIEL","NL"]
["Brasschaat",2930,"gem.","Antwerpen","Pidpa ","HidroGem ","BR",null,"OLEN","OO"]
["Brecht",2960,"gem.","Antwerpen","Pidpa ","HidroRio ","BT",null,"OUD-TURNHOUT","OT"]
["Bredene",8450,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","BRE",null,"PUURS- SINt-AMANDS","PU"]
["Bree",3960,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","BR",null,"PUTTE","PT"]
["Brugge",8000,"stad","West-Vlaanderen","Farys (TMVW) ","AquaRio ","Brugge ",null,"RANST","RA"]
["Buggenhout",9255,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Buggenhout ",null,"RETIE","RI"]
["Damme",8340,"stad","West-Vlaanderen","Farys (TMVW) ","AquaRio ","Damme ",null,"RIJKEVORSEL","RK"]
["De Haan",8420,"gem.","West-Vlaanderen","Farys (TMVW) ","AquaRio ","De Haan ",null,"RUMST","RU"]
["De Panne",8660,"gem.","West-Vlaanderen","Aquaduin ","Aquaduin ","De Panne ",null,"RAVELS","RV"]
["De Pinte",9840,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","De Pinte ",null,"SCHILDE","SI"]
["Deerlijk",8540,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","DEE",null,"SCHELLE","SL"]
["Deinze",9800,"stad","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Deinze ",null,"SCHOTEN","SO"]
["Denderleeuw",9470,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","DEN",null,"STABROEK","ST"]
["Dendermonde",9200,"stad","Oost-Vlaanderen","Farys (TMVW) ","Gemeente ","Dendermonde ",null,"SINT-KATELIJNE-WAVER","SW"]
["Dentergem",8720,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","Dentergem ",null,"TURNHOUT","TU"]
["Dessel",2480,"gem.","Antwerpen","Pidpa ","HidroSan ","DS",null,"VORSELAAR","VR"]
["Destelbergen",9070,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Destelbergen ",null,"VOSSELAAR","VS"]
["Diepenbeek",3590,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","DP",null,"WOMMELGEM","WG"]
["Diest",3290,"stad","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Diest ",null,"WILLEBROEK","WL"]
["Diksmuide",8600,"stad","West-Vlaanderen","De Watergroep (VMW) + Aquaduin ","Fluvius West ","DK",null,"WESTERLO","WO"]
["Dilbeek",1700,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","AquaRio ","Dilbeek ",null,"WUUSTWEZEL","WU"]
["Dilsen-Stokkem",3650,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","DI",null,"WIJNEGEM","WY"]
["Drogenbos",1620,"gem.","Vlaams-Brabant","Farys (TMVW) ","AquaRio ","Drogenbos ",null,"ZANDHOVEN","ZH"]
["Duffel",2570,"gem.","Antwerpen","Pidpa ","HidroSan ","DF",null,"ZOERSEL","ZS"]
["Edegem",2650,"gem.","Antwerpen","Water-link (AWW) ","Rio-link ","Edegem ",null,"Alken","AL",null,"Fluvius (+ riobra)"]
["Eeklo",9900,"stad","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","EEK",null,"Beerse","BS"]
["Erpe-Mere",9420,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Erpe-Mere ",null,"Begijnendijk","BD"]
["Essen",2910,"gem.","Antwerpen","Pidpa ","Fluvius Antwerpen ","ES",null,"Bekkevoort","BK"]
["Evergem",9940,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","EVE",null,"Beringen","BE"]
["Galmaarden",1570,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","GA",null,"Bertem","BL"]
["Gavere",9890,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Gavere ",null,"Bever","BB"]
["Geel",2440,"stad","Antwerpen","Pidpa ","Gemeente ","Geel ",null,"Bocholt","BT"]
["Geetbets",3450,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","GE",null,"Boortmeerbeek","BM"]
["Genk",3600,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","GK",null,"Borgloon","BO"]
["Gent",9000,"stad","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Gent ",null,"Boutersem","BV"]
["Geraardsbergen",9500,"stad","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","GER",null,"Bree","BR"]
["Gingelom",3890,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","GI",null,"Diepenbeek","DP"]
["Gistel",8470,"stad","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","GS",null,"Diksmuiden","DK"]
["Glabbeek",3380,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","GL",null,"Dilsen-Stokkem","DI"]
["Gooik",1755,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","GO",null,"Essen","ES"]
["Grimbergen",1850,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","GRI",null,"Galmaarden","GA"]
["Grobbendonk",2280,"gem.","Antwerpen","Pidpa ","Fluvius Antwerpen ","GR",null,"Geetbets","GE"]
["Haacht",3150,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Haacht ",null,"Genk","GK"]
["Haaltert",9450,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","HAA",null,"Gingelom","GI"]
["Halen",3545,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","HL",null,"Gistel","GS"]
["Halle",1500,"stad","Vlaams-Brabant","De Watergroep (VMW) ","AquaRio ","Halle ",null,"Glabbeek","GL"]
["Ham",3945,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","HM",null,"Gooik","GO"]
["Hamme",9220,"gem.","Oost-Vlaanderen","Farys (TMVW) ","Gemeente ","Hamme ",null,"Grobbendonk","GR"]
["Hamont-Achel",3930,"stad","Limburg","De Watergroep (VMW) ","Gemeente ","HAM",null,"Halen","HL"]
["Harelbeke",8530,"stad","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","HK",null,"Ham","HM"]
["Hasselt",3500,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","HT",null,"Harelbeke","HK"]
["Hechtel-Eksel",3940,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","HE",null,"Hasselt","HT"]
["Heers",3870,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","HS",null,"Hechtel-Eksel","HE"]
["Heist-op-den-Berg",2220,"gem.","Antwerpen","Pidpa ","HidroRio ","HB",null,"Heers","HS"]
["Hemiksem",2620,"gem.","Antwerpen","Pidpa ","Rio-link ","Hemiksem ",null,"Herk-De-Stad","HD"]
["Herent",3020,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","HER",null,"Herne","HR"]
["Herentals",2200,"stad","Antwerpen","Pidpa ","Gemeente ","Herentals ",null,"Herstappe","HP"]
["Herenthout",2270,"gem.","Antwerpen","Pidpa ","HidroRio ","HH",null,"Hoegaarden","HW"]
["Herk-de-Stad",3540,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","HD",null,"Hoeselt","HO"]
["Herne",1540,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","HR",null,"Hooglede","HG"]
["Herselt",2230,"gem.","Antwerpen","Pidpa ","HidroRio ","HS",null,"Houthalen-Helchteren","HH"]
["Herstappe",3717,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","HP",null,"Houthulst","HU"]
["Herzele",9550,"gem.","Oost-Vlaanderen","De Watergroep (VMW) + Farys (TMVW) ","Riopact-vennoot ","HRZ",null,"Huldenberg","UL"]
["Heusden-Zolder",3550,"gem.","Limburg","De Watergroep (VMW) ","Gemeente ","HZO",null,"Ichtegem","IG"]
["Heuvelland",8950,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","HEU",null,"Ingelmunster","IM"]
["Hoegaarden",3320,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","HW",null,"Izegem","IZ"]
["Hoeilaart",1560,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","HOE",null,"Kinrooi","KI"]
["Hoeselt",3730,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","HO",null,"Koekelare","KK"]
["Holsbeek",3220,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Holsbeek ",null,"Kortemark","KM"]
["Hooglede",8830,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","HG",null,"Kortenaken","KT"]
["Hoogstraten",2320,"stad","Antwerpen","Pidpa ","HidroSan ","HO",null,"Kortessem","KO"]
["Horebeke",9667,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Horebeke ",null,"Lanaken","LA"]
["Houthalen-Helchteren",3530,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","HH",null,"Landen","LN"]
["Houthulst",8650,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","HU",null,"Langemark-Poelkapelle","LP"]
["Hove",2540,"gem.","Antwerpen","Water-link (AWW) ","Rio-link ","Hove ",null,"Lendelede","LL"]
["Huldenberg",3040,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","UL",null,"Leopoldsburg","LE"]
["Hulshout",2235,"gem.","Antwerpen","Pidpa ","HidroRio ","HU",null,"Lichtervelde","LV"]
["Ichtegem",8480,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","IG",null,"Lille","IL"]
["Ieper",8902,"stad","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","Ieper ",null,"Linter","LI"]
["Ingelmunster",8770,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","IM",null,"Lubbeek","LB"]
["Izegem",8870,"stad","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","IZ",null,"Lummen","LU"]
["Jabbeke",8490,"gem.","West-Vlaanderen","De Watergroep (VMW) + Farys (TMVW) ","Gemeente ","Jabbeke ",null,"Maaseik","MA"]
["Kalmthout",2920,"gem.","Antwerpen","Pidpa ","Rio-link ","Kalmthout ",null,"Maasmechelen","MM"]
["Kampenhout",1910,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Kampenhout ",null,"Merchtem","MT"]
["Kapellen",2950,"gem.","Antwerpen","Pidpa ","Rio-link ","Kapellen ",null,"Moorslede","MO"]
["Kapelle-op-den-Bos",1880,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","KAP",null,"Nieuwerkerken","NI"]
["Kaprijke",9970,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","KPR",null,"Oudenburg","OU"]
["Kasterlee",2460,"gem.","Antwerpen","Pidpa ","Gemeente ","Kasterlee ",null,"Oud-Heverlee","OH"]
["Keerbergen",3140,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","KEE",null,"Oudsbergen","OB"]
["Kinrooi",3640,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","KI",null,"Peer","PE"]
["Kluisbergen",9690,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Kluisbergen ",null,"Pelt","PT"]
["Knokke-Heist",8300,"gem.","West-Vlaanderen","AGSO Knokke-Heist ","AGSO Knokke-Heist ","Knokke-Heist ",null,"Pepingen","PP"]
["Koekelare",8680,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","KK",null,"Riemst","RI"]
["Koksijde",8670,"gem.","West-Vlaanderen","Aquaduin ","Gemeente ","Koksijde ",null,"Rotselaar","RO"]
["Kontich",2550,"gem.","Antwerpen","Pidpa ","HidroGem ","KT",null,"Sint-Pieters-Leeuw","PL"]
["Kortemark",8610,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","KM",null,"Sint-Truiden","ST"]
["Kortenaken",3470,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","KT",null,"Staden","SD"]
["Kortenberg",3070,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Kortenberg ",null,"Steenokkerzeel","SO"]
["Kortessem",3720,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","KO",null,"Tielt-Winge","TW"]
["Kortrijk",8500,"stad","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","KOR",null,"Tienen","TI"]
["Kraainem",1950,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riopact-vennoot ","KRN",null,"Tongeren","TO"]
["Kruibeke",9150,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","KRU",null,"Torhout","TH"]
["Kruisem",9750,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Kruisem ",null,"Voeren","VR"]
["Kuurne",8520,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","KUU",null,"Vosselaar","VS"]
["Laakdal",2430,"gem.","Antwerpen","Pidpa ","HidroRio ","LA",null,"Zonhoven","ZO"]
["Laarne",9270,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","LRN",null,"Zoutleeuw","ZL"]
["Lanaken",3620,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","LA",null,"Zutendaal","ZU"]
["Landen",3400,"stad","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","LN",null,"Aarschot","ARS",null,"RIOPACT-VENNOTEN"]
["Langemark-Poelkapelle",8920,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","LP",null,"Anzegem","ANZ",null,"2022-03-24"]
["Lebbeke",9280,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Lebbeke ",null,"Assenede","ASN"]
["Lede",9340,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Lede ",null,"Deerlijk","DEE"]
["Ledegem",8880,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","Ledegem ",null,"Eeklo","EEK"]
["Lendelede",8860,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","LL",null,"Herzele","HRZ"]
["Lennik",1750,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","LEN",null,"Kaprijke","KPR"]
["Leopoldsburg",3970,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","LE",null,"Kraainem","KRN"]
["Leuven",3000,"stad","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","LEU",null,"Kruibeke","KRU"]
["Lichtervelde",8810,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","LV",null,"Laarne","LRN"]
["Liedekerke",1770,"gem.","Vlaams-Brabant","De Watergroep (VMW) + Farys (TMVW) ","AquaRio ","Liedekerke ",null,"Moerbeke-Waas","MOE"]
["Lier",2500,"stad","Antwerpen","Pidpa ","Gemeente ","Lier ",null,"Ninove","NIV"]
["Lierde",9570,"gem.","Oost-Vlaanderen","De Watergroep (VMW) + Farys (TMVW) ","AquaRio ","Lierde ",null,"Opwijk","OPW"]
["Lievegem",9920,"gem.","Oost-Vlaanderen","De Watergroep (VMW) + Farys (TMVW) ","Aquario (9920-9921) Gemeente (9950) ","LIE",null,"Scherpenheuvel - Zichem","SCR"]
["Lille",2275,"gem.","Antwerpen","Pidpa ","Fluvius Antwerpen ","IL",null,"Sint-Gillis-Waas","SGW"]
["Linkebeek",1630,"gem.","Vlaams-Brabant","Farys (TMVW) ","AquaRio ","Linkebeek ",null,"Temse","TEM"]
["Lint",2547,"gem.","Antwerpen","Pidpa ","HidroSan ","LT",null,"Tielt","TLT"]
["Linter",3350,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","LI",null,"Vleteren","VLE"]
["Lochristi",9080,"gem.","Oost-Vlaanderen","De Watergroep (VMW) + Farys (TMVW) ","Gemeente ","LOC",null,"Waasmunster","WMS"]
["Lokeren",9160,"stad","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","LOK",null,"Wachtebeke","WCB"]
["Lommel",3920,"stad","Limburg","De Watergroep (VMW) ","Gemeente ","Lommel ",null,"Wezembeek-Oppem","WZO"]
["Londerzeel",1840,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Londerzeel ",null,"Zedelgem","ZED"]
["Lo-Reninge",8647,"stad","West-Vlaanderen","De Watergroep (VMW) + Aquaduin ","Gemeente ","LOR",null,"Zonnebeke","ZON"]
["Lubbeek",3210,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","LB",null,"Ardooie","ARD",null,"RIOPACT-GEMEENTEN"]
["Lummen",3560,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","LU",null,"As","AS",null,"2022-03-24"]
["Maarkedal",9680,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Maarkedal ",null,"Berlare","BER"]
["Maaseik",3680,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","MA",null,"Beveren","BEV"]
["Maasmechelen",3630,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","MM",null,"Bierbeek","BIE"]
["Machelen",1830,"gem.","Vlaams-Brabant","Farys (TMVW) ","AquaRio ","Machelen ",null,"Bilzen","BIL"]
["Maldegem",9990,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","MAL",null,"Bredene","BRE"]
["Malle",2390,"gem.","Antwerpen","Pidpa ","HidroRio ","MA",null,"Denderleeuw","DEN"]
["Mechelen",2800,"stad","Antwerpen","Pidpa ","HidroGem ","ME",null,"Evergem ","EVE"]
["Meerhout",2450,"gem.","Antwerpen","Pidpa ","HidroRio ","MH",null,"Geraardsbergen","GER"]
["Meise",1860,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Meise ",null,"Grimbergen","GRI"]
["Melle",9090,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Melle ",null,"Haaltert","HAA"]
["Menen",8930,"stad","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","MEN",null,"Hamont-Achel","HAM"]
["Merchtem",1785,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","MT",null,"Herent","HER"]
["Merelbeke",9820,"gem.","Oost-Vlaanderen","Farys (TMVW) ","Gemeente ","Merelbeke ",null,"Heusden-Zolder","HZO"]
["Merksplas",2330,"gem.","Antwerpen","Pidpa ","Gemeente ","Merksplas ",null,"Heuvelland","HEU"]
["Mesen",8957,"stad","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","MES",null,"Hoeilaart","HOE"]
["Meulebeke",8760,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","MEU",null,"Kappele-op-den-Bos","KAP"]
["Middelkerke",8430,"gem.","West-Vlaanderen","De Watergroep (VMW) + Farys (TMVW) ","AquaRio ","Middelkerke ",null,"Keerbergen","KEE"]
["Moerbeke",9180,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","MOE",null,"Kortrijk","KOR"]
["Mol",2400,"gem.","Antwerpen","Pidpa ","HidroSan ","MO",null,"Kuurne","KUU"]
["Moorslede",8890,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","MO",null,"Lennik","LEN"]
["Mortsel",2640,"stad","Antwerpen","Water-link (AWW) ","Rio-link ","Mortsel ",null,"Leuven","LEU"]
["Nazareth",9810,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Nazareth ",null,"Lievegem","LIE"]
["Niel",2845,"gem.","Antwerpen","Pidpa ","HidroRio ","NL",null,"Lochristi","LOC"]
["Nieuwerkerken",3850,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","NI",null,"Lokeren","LOK"]
["Nieuwpoort",8620,"stad","West-Vlaanderen","Aquaduin ","Aquaduin ","Nieuwpoort ",null,"Lo-Reninge","LOR"]
["Nijlen",2560,"gem.","Antwerpen","Pidpa ","Gemeente ","Nijlen ",null,"Maldegem","MAL"]
["Ninove",9400,"stad","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","NIV",null,"Menen","MEN"]
["Olen",2250,"gem.","Antwerpen","Pidpa ","Gemeente ","Olen ",null,"Mesen","MES"]
["Oostende",8400,"stad","West-Vlaanderen","De Watergroep (VMW) + Farys (TMVW) ","AquaRio ","Oostende ",null,"Meulebeke","MEU"]
["Oosterzele",9860,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Oosterzele ",null,"Oostrozebeke","OOS"]
["Oostkamp",8020,"gem.","West-Vlaanderen","De Watergroep (VMW) + Farys (TMVW) ","Gemeente ","Oostkamp ",null,"Roeselare","ROE"]
["Oostrozebeke",8780,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","OOS",null,"Roosdaal","ROO"]
["Opwijk",1745,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riopact-vennoot ","OPW",null,"Sint-Genesius-Rode","SGR"]
["Oudenaarde",9700,"stad","Oost-Vlaanderen","Farys (TMVW) ","Gemeente ","Oudenaarde ",null,"Sint-Laureins","SLA"]
["Oudenburg",8460,"stad","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","OU",null,"Sint-Niklaas ","SNI"]
["Oud-Heverlee",3050,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","OH",null,"Spiere-Helkijn","SPI"]
["Oudsbergen",3660,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","OB",null,"Stekene","STE"]
["Oud-Turnhout",2360,"gem.","Antwerpen","Pidpa ","HidroSan ","OT",null,"Tessenderlo","TES"]
["Overijse",3090,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Overijse ",null,"Waregem","WAR"]
["Peer",3990,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","PE",null,"Wellen","WEL"]
["Pelt",3900,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","PT",null,"Wervik","WER"]
["Pepingen",1670,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","PP",null,"Wielsbeke","WIE"]
["Pittem",8740,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","Pittem",null,"Wingene","WIN"]
["Poperinge",8970,"stad","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","Poperinge ",null,"Zele","ZEL"]
["Putte",2580,"gem.","Antwerpen","Pidpa ","HidroRio ","PT",null,"Zemst","ZEM"]
["Puurs-Sint-Amands",2890,"gem.","Antwerpen","Pidpa ","HidroRio ","PU",null,"Zwevegem","ZWE"]
["Ranst",2520,"gem.","Antwerpen","Pidpa ","Rio-link ","Ranst "]
["Ravels",2380,"gem.","Antwerpen","Pidpa ","HidroRio ","RV"]
["Retie",2470,"gem.","Antwerpen","Pidpa ","Gemeente (HidrIBA) ","Retie "]
["Riemst",3770,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","RI"]
["Rijkevorsel",2310,"gem.","Antwerpen","Pidpa ","HidroRio ","RK"]
["Roeselare",8800,"stad","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","ROE"]
["Ronse",9600,"stad","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Ronse "]
["Roosdaal",1760,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","ROO"]
["Rotselaar",3110,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","RO"]
["Ruiselede",8755,"gem.","West-Vlaanderen","Farys (TMVW) ","AquaRio ","Ruiselede "]
["Rumst",2840,"gem.","Antwerpen","Pidpa ","HidroRio ","RU"]
["Schelle",2627,"gem.","Antwerpen","Pidpa ","HidroRio ","SL"]
["Scherpenheuvel-Zichem",3270,"stad","Vlaams-Brabant","De Watergroep (VMW) ","Riopact-vennoot ","SCR"]
["Schilde",2970,"gem.","Antwerpen","Pidpa ","HidroSan ","SI"]
["Schoten",2900,"gem.","Antwerpen","Pidpa ","Rio-link ","Schoten "]
["Sint-Genesius-Rode",1640,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","SGR"]
["Sint-Gillis-Waas",9170,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","SGW"]
["Sint-Katelijne-Waver",2860,"gem.","Antwerpen","Pidpa ","HidroRio ","SW"]
["Sint-Laureins",9980,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","SLA"]
["Sint-Lievens-Houtem",9520,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Sint-Lievens-Houtem "]
["Sint-Martens-Latem",9830,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Sint-Martens-Latem "]
["Sint-Niklaas",9100,"stad","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","SNI"]
["Sint-Pieters-Leeuw",1600,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","PL"]
["Sint-Truiden",3800,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","ST"]
["Spiere-Helkijn",8587,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","SPI"]
["Stabroek",2940,"gem.","Antwerpen","Pidpa ","HidroSan ","ST"]
["Staden",8840,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","SD"]
["Steenokkerzeel",1820,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","SO"]
["Stekene",9190,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","STE"]
["Temse",9140,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","TEM"]
["Ternat",1740,"gem.","Vlaams-Brabant","De Watergroep (VMW) + Farys (TMVW) ","AquaRio ","Ternat "]
["Tervuren",3080,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Tervuren "]
["Tessenderlo",3980,"gem.","Limburg","De Watergroep (VMW) ","Gemeente ","TES"]
["Tielt",8700,"stad","West-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","TLT"]
["Tielt-Winge",3390,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","TW"]
["Tienen",3300,"stad","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","TI"]
["Tongeren",3700,"stad","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","TO"]
["Torhout",8820,"stad","West-Vlaanderen","De Watergroep (VMW) ","Fluvius West ","TH"]
["Tremelo",3120,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Tremelo "]
["Turnhout",2300,"stad","Antwerpen","Pidpa ","Gemeente ","Turnhout "]
["Veurne",8630,"stad","West-Vlaanderen","Aquaduin ","Aquaduin ","Veurne "]
["Vilvoorde",1800,"stad","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","Vilvoorde "]
["Vleteren",8640,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","VLE"]
["Voeren",3790,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","VR"]
["Vorselaar",2290,"gem.","Antwerpen","Pidpa ","HidroRio ","VR"]
["Vosselaar",2350,"gem.","Antwerpen","Pidpa ","Fluvius West ","VS"]
["Waasmunster",9250,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","WMS"]
["Wachtebeke",9185,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","WCB"]
["Waregem",8790,"stad","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","WAR"]
["Wellen",3830,"gem.","Limburg","De Watergroep (VMW) ","Gemeente ","WEL"]
["Wemmel",1780,"gem.","Vlaams-Brabant","Farys (TMVW) ","AquaRio ","Wemmel "]
["Wervik",8940,"stad","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","WER"]
["Westerlo",2260,"gem.","Antwerpen","Pidpa ","HidroSan ","WO"]
["Wetteren",9230,"gem.","Oost-Vlaanderen","Farys (TMVW) ","Gemeente ","Wetteren "]
["Wevelgem",8560,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","Wevelgem "]
["Wezembeek-Oppem",1970,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Riopact-vennoot ","WZO"]
["Wichelen",9260,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Wichelen "]
["Wielsbeke",8710,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","WIE"]
["Wijnegem",2110,"gem.","Antwerpen","Pidpa ","HidroRio ","WY"]
["Willebroek",2830,"gem.","Antwerpen","Pidpa ","HidroRio ","WL"]
["Wingene",8750,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","WIN"]
["Wommelgem",2160,"gem.","Antwerpen","Pidpa ","Gemeente ","Wommelgem "]
["Wortegem-Petegem",9790,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Wortegem-Petegem "]
["Wuustwezel",2990,"gem.","Antwerpen","Pidpa ","HidroRio ","WU"]
["Zandhoven",2240,"gem.","Antwerpen","Pidpa ","HidroRio ","ZH"]
["Zaventem",1930,"gem.","Vlaams-Brabant","Farys (TMVW) ","AquaRio ","Zaventem "]
["Zedelgem",8210,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","ZED"]
["Zele",9240,"gem.","Oost-Vlaanderen","De Watergroep (VMW) ","Gemeente ","ZEL"]
["Zelzate",9060,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Zelzate "]
["Zemst",1980,"gem.","Vlaams-Brabant","De Watergroep (VMW) ","Gemeente ","ZEM"]
["Zoersel",2980,"gem.","Antwerpen","Pidpa ","HidroRio ","ZS"]
["Zonhoven",3520,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","ZO"]
["Zonnebeke",8980,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Riopact-vennoot ","ZON"]
["Zottegem",9620,"stad","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Zottegem "]
["Zoutleeuw",3440,"stad","Vlaams-Brabant","De Watergroep (VMW) ","Riobra ","ZL"]
["Zuienkerke",8377,"gem.","West-Vlaanderen","Farys (TMVW) ","AquaRio ","Zuienkerke "]
["Zulte",9870,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Zulte "]
["Zutendaal",3690,"gem.","Limburg","De Watergroep (VMW) ","Fluvius Limburg ","ZU"]
["Zwalm",9630,"gem.","Oost-Vlaanderen","Farys (TMVW) ","AquaRio ","Zwalm "]
["Zwevegem",8550,"gem.","West-Vlaanderen","De Watergroep (VMW) ","Gemeente ","ZWE"]
["Zwijndrecht",2070,"gem","Antwerpen","Water-link (AWW) ","Gemeente ","Zwijndrecht "]