{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inschrijfformulier KWR RO 2018","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":55,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inschrijfformulier KWR RO 2018","index":0,"n_rows":91,"n_cols":13,"rows_kept":91,"cut":false,"hidden":false,"merged":[[88,3,88,4],[77,5,77,6],[85,5,85,6],[84,3,84,4],[85,3,85,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[81,5,83,6],[78,1,78,2],[2,2,2,5],[86,3,86,4],[87,3,87,4],[20,3,20,4],[79,1,79,2],[80,1,80,2],[66,2,66,4],[69,2,69,4],[74,1,74,6],[76,1,76,6],[75,1,75,6],[82,1,82,2],[82,3,82,4],[78,5,79,6],[90,1,90,6],[91,1,93,6],[1,1,1,6],[88,1,88,2],[87,1,87,2],[86,1,86,2],[85,1,85,2],[84,1,84,2],[80,5,80,6],[73,1,73,6],[72,1,72,6],[71,1,71,6],[40,3,40,4],[62,3,62,4],[81,1,81,2],[77,1,77,2]]}
[]
[null,"Inschrijfformulier/opdrachtbevestiging Ringonderzoeken 2018"]
[null,null,"In onderstaand overzicht kunt u aangeven voor welke ringonderzoeken u zich wilt inschrijven. "]
[]
[null,null,"Ringonderzoek","Omschrijving","Matrix","Prijs"]
[null,null,null,"(zware) metalen, als opgelost","dw",1145,null,null,null,null,null,false,{"$f":"IF(L6=TRUE,F6,\"\")","v":""}]
[null,null,null,"algemene- en macroparameters","dw",1615,null,null,null,null,null,false,{"$f":"IF(L7=TRUE,F7,\"\")","v":""}]
[null,null,null,"ureum, cyanuurzuur, KMnO4-verbr., vrij chloor en totaal chloor","zw",860,null,null,null,null,null,false,""]
[null,null,null,"nutriënten","ow",1545,null,null,null,null,null,false,""]
[null,null,null,"(zware) metalen, als totaal","ow",1145,null,null,null,null,null,false,""]
[null,null,null,"arseen-3, arseen-5, chroom-3 en chroom-6","ow",480,null,null,null,null,null,false,""]
[null,null,null,"(zware) metalen, als opgelost","gw",1085,null,null,null,null,null,false,""]
[null,null,null,"algemene- en macroparameters","gw",1200,null,null,null,null,null,false,""]
[null,null,null,"algemene- en macroparameters","aw",1200,null,null,null,null,null,false,""]
[null,null,null,"(zware) metalen, als totaal","aw",915,null,null,null,null,null,false,""]
[null,null,null,"monstername zwemwater op locatie","zw",460,null,null,null,null,null,false,""]
[null,null,null,"bromide, bromaat en chloraat","dw+ow",480,null,null,null,null,null,false,""]
[null,null,null,"geur en smaak, organoleptisch","dw",465,null,null,null,null,null,false,""]
[null,null,null,"bemonstering oppervlaktewater","ow",610,null,null,null,null,null,false,{"$f":"IF(L19=TRUE,F19,\"\")","v":""}]
[]
[null,null,null,"Totale bijdrage anorganische ringonderzoeken",null,{"$f":"SUM(M6:M19)","v":0}]
[]
[]
[null,null,"Ringonderzoek","Omschrijving","Matrix","Prijs"]
[null,null,null,"extraheerbaar organohalogeen (EOX)","dw  ow  gw  aw",970,null,null,null,null,null,false,{"$f":"IF(L25=TRUE,F25,\"\")","v":""}]
[null,null,null,"adsorbeerbaar organohalogeen (AOX)","dw  ow  gw  aw",970,null,null,null,null,null,false,""]
[null,null,null,"pesticiden (OCP)","dw  ow  gw  aw",1130,null,null,null,null,null,false,""]
[null,null,null,"pesticiden (PCB)","dw  ow  gw",885,null,null,null,null,null,false,""]
[null,null,null,"polycyclische aromatische koolwaterstoffen (PAK)","dw  ow  gw  aw",1005,null,null,null,null,null,false,""]
[null,null,null,"vluchtige gehalogeneerde koolwaterstoffen (VGK)","dw  ow  gw  aw",1145,null,null,null,null,null,false,""]
[null,null,null,"vluchtige aromatische koolwaterstoffen (VAK)","dw  ow  gw  aw",1145,null,null,null,null,null,false,""]
[null,null,null,"geneesmiddelen","dw  ow  gw  ",1145,null,null,null,null,null,false,""]
[null,null,null,"herbiciden ","dw  ow  gw",1130,null,null,null,null,null,false,""]
[null,null,null,"chloorfenoxycarbonzuren/bentazon","dw  ow  gw",1145,null,null,null,null,null,false,""]
[null,null,null,"fenylureumherbiciden (FUH)","dw  ow  gw",880,null,null,null,null,null,false,""]
[null,null,null,"glyfosaat en AMPA","dw  ow  gw",970,null,null,null,null,null,false,""]
[null,null,null,"minerale olie, alleen voor de GC methode","aw",245,null,null,null,null,null,false,{"$f":"IF(L37=TRUE,F37,\"\")","v":""}]
[null,null,null,"chloridazon, dimethenamid-P en metabolieten","dw  ow  gw",880,null,null,null,null,null,false,{"$f":"IF(L38=TRUE,F38,\"\")","v":""}]
[null,null,null,"brede screening, semi-kwantitatief LC-MS","dw  ow  gw  aw",970,null,null,null,null,null,false,{"$f":"IF(L39=TRUE,F39,\"\")","v":""}]
[]
[null,null,null,"Totale bijdrage organische ringonderzoeken",null,{"$f":"SUM(M25:M39)","v":0}]
[]
[]
[null,null,"Ringonderzoek","Omschrijving","Matrix","Prijs"]
[null,null,null,"bacteriologische parameters","dw ",845,null,null,null,null,null,false,{"$f":"IF(L45=TRUE,F45,\"\")","v":""}]
[null,null,null,"bacteriologische parameters","dw ",845,null,null,null,null,null,false,{"$f":"IF(L46=TRUE,F46,\"\")","v":""}]
[null,null,null,"bacteriologische parameters","dw ",845,null,null,null,null,null,false,""]
[null,null,null,"Legionella","dw",560,null,null,null,null,null,false,""]
[null,null,null,"Legionella","dw ",560,null,null,null,null,null,false,""]
[null,null,null,"Legionella","dw ",560,null,null,null,null,null,false,""]
[null,null,null,"ATP/Koloniegetal op R2A-medium","verdund ow + dw",880,null,null,null,null,null,false,""]
[null,null,null,"Salmonella, staphylococcen en Pseudomonas aeruginosa","dw",845,null,null,null,null,null,false,""]
[null,null,null,"bacteriologische parameters","ow",845,null,null,null,null,null,false,""]
[null,null,null,"bacteriologische parameters","ow",845,null,null,null,null,null,false,""]
[null,null,null,"Legionella","kw",560,null,null,null,null,null,false,""]
[null,null,null,"Legionella","kw",560,null,null,null,null,null,false,""]
[null,null,null,"Legionella pneumophila qPCR","dw",505,null,null,null,null,null,false,{"$f":"IF(L57=TRUE,F57,\"\")","v":""}]
[null,null,null,"Legionella pneumophila qPCR","kw",505,null,null,null,null,null,false,{"$f":"IF(L58=TRUE,F58,\"\")","v":""}]
[null,null,null,"F-specifieke RNA-fagen en somatische colifagen","dw",635,null,null,null,null,null,false,{"$f":"IF(L59=TRUE,F59,\"\")","v":""}]
[null,null,null,"Totale bacteriële celtelling (inlc. fractie dood en levend), flowcytometrisch","dw",635,null,null,null,null,null,false,{"$f":"IF(L60=TRUE,F60,\"\")","v":""}]
[null,null,null,"Legionella","kw",560,null,null,null,null,null,false,{"$f":"IF(L61=TRUE,F61,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(M6:M61)","v":0}]
[null,null,null,"Totale bijdrage microbiologische ringonderzoeken",null,{"$f":"SUM(M45:M61)","v":0}]
[]
[null,null,"dw = drinkwater, ow = oppervlaktewater, gw = grondwater, aw = afvalwater, zw = zwemwater en kw = koelwater"]
[]
[null,null,"Totale bijdrage ringonderzoeken",null,null,{"$f":"SUM(F63,F41,F21)","v":0}]
[null,null,"Rapport","Hardcopy rapport à € 35 per stuk",0,{"$f":"E68*35","v":0}]
[null,null,"Korting",{"$f":"L72&L73&L74&L75","v":"Geen (deelname aantal ringonderzoek <4)"},{"$f":"M72&M73&M74&M75","v":"Geen korting"},{"$f":"IF(AND(M62>=5,M62<=9),-0.05*(F67+F68),IF(AND(M62>=10,M62<=19),-0.1*(F67+F68),IF(M62>=20,-0.15*(F67+F68),\"\")))","v":""}]
[null,null,"Totale bijdrage in euro’s",null,null,{"$f":"SUM(F67:F69)","v":0}]
[]
[null,"Het totaalbedrag van de opdracht wordt in twee gelijke delen gefactureerd, tenzij uitdrukkelijk anders met u is afgesproken. Mochten er gedurende het jaar eventuele veranderingen plaatsvinden in uw opdracht, dan worden deze in de tweede periode met u verrekend. ",null,null,null,null,null,null,null,null,null,{"$f":"IF(M62<=4,\"Geen (deelname aantal ringonderzoek <4)\",\"\")","v":"Geen (deelname aantal ringonderzoek <4)"},{"$f":"IF(L72>\"\",\"Geen korting\",\"\")","v":"Geen korting"}]
[null,"De in het jaarprogramma vermelde prijzen zijn exclusief BTW en inclusief transportkosten binnen België en Nederland. Transportkosten buiten België en Nederland worden op basis van nacalculatie in rekening gebracht.",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M62>=5,M62<=9),\"5% (deelname aantal ringonderzoek 5-9)\",\"\")","v":""},{"$f":"IF(L73>\"\",\"5% korting\",\"\")","v":""}]
[null,"Indien u een ringonderzoek wenst te annuleren, dient u dit uiterlijk vier weken voor de ontvangstdatum van het ringonderzoek schriftelijk aan ons te melden. Na deze termijn worden de kosten van het ringonderzoek bij u in rekening gebracht.",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M62>=10,M62<=19),\"10% (deelname aantal ringonderzoek 10-19)\",\"\")","v":""},{"$f":"IF(L74>\"\",\"10% korting\",\"\")","v":""}]
[null,"Middels deze opdrachtbevestiging gaat u akkoord met de leveringsvoorwaarden die van toepassing zijn en welke te downloaden zijn via www.kwrwater.nl/voorwaarden/. ",null,null,null,null,null,null,null,null,null,{"$f":"IF(M62>=20,\"15% (deelname aantal ringonderzoek >20)\",\"\")","v":""},{"$f":"IF(L75>\"\",\"15% korting\",\"\")","v":""}]
[]
[null,"Uw gegevens"]
[null,"Bedrijfsnaam",null,null,null,"Datum aanmelding:"]
[null,"Correspondentie t.a.v."]
[null,"Telefoon"]
[null,"Postbus",null,null,null,"Opdrachtgever:"]
[null,"Postcode/Plaats/Land"]
[null,"E-mail"]
[]
[null,"Monsters t.a.v."]
[null,"Telefoon",null,null,null,"Handtekening:"]
[null,"Adres"]
[null,"Postcode/Plaats/Land"]
[null,"E-mail"]
[]
[null,"Uw opmerkingen"]

{"sheet":"Sheet2","index":1,"n_rows":78,"n_cols":2,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Telefoon"]

{"sheet":"Sheet3","index":2,"n_rows":78,"n_cols":2,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Telefoon"]