{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inschrijfformulier KWR RO 2017","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":52,"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 2017","index":0,"n_rows":88,"n_cols":13,"rows_kept":88,"cut":false,"hidden":false,"merged":[[85,3,85,4],[75,5,75,6],[82,5,82,6],[81,3,81,4],[82,3,82,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[75,1,75,2],[76,1,76,2],[2,2,2,5],[83,3,83,4],[84,3,84,4],[19,3,19,4],[77,1,77,2],[78,1,78,2],[64,2,64,4],[67,2,67,4],[72,1,72,6],[74,1,74,6],[73,1,73,6],[87,1,87,6],[88,1,90,6],[1,1,1,6],[76,5,76,6],[85,1,85,2],[84,1,84,2],[83,1,83,2],[82,1,82,2],[81,1,81,2],[78,5,78,6],[71,1,71,6],[70,1,70,6],[69,1,69,6],[39,3,39,4],[60,3,60,4],[79,1,79,2]]}
[]
[null,"Inschrijfformulier/opdrachtbevestiging Ringonderzoeken 2017 "]
[null,null,"In onderstaand overzicht kunt u aangeven voor welke ringonderzoeken u zich wilt ingeschreven. U ontvangt van ons ook nog een bevestiging van deelname."]
[]
[null,null,"Ringonderzoek","Omschrijving","Matrix","Prijs"]
[null,null,null,"(zware) metalen, als opgelost","dw",1110,null,null,null,null,null,false,{"$f":"IF(L6=TRUE,F6,\"\")","v":""}]
[null,null,null,"algemene- en macroparameters","dw",1570,null,null,null,null,null,false,{"$f":"IF(L7=TRUE,F7,\"\")","v":""}]
[null,null,null,"ureum, cyanuurzuur, KMnO4-verbr., vrij chloor en geb. chloor","zw",835,null,null,null,null,null,false,""]
[null,null,null,"nutriënten","ow",1500,null,null,null,null,null,false,""]
[null,null,null,"(zware) metalen, als totaal","ow",1110,null,null,null,null,null,false,""]
[null,null,null,"arseen-3, arseen-5, chroom-3 en chroom-6","ow",465,null,null,null,null,null,false,""]
[null,null,null,"(zware) metalen, als opgelost","gw",1055,null,null,null,null,null,false,""]
[null,null,null,"algemene- en macroparameters","gw",1165,null,null,null,null,null,false,""]
[null,null,null,"algemene- en macroparameters","aw",1165,null,null,null,null,null,false,""]
[null,null,null,"(zware) metalen, als totaal","aw",885,null,null,null,null,null,false,""]
[null,null,null,"monstername zwemwater op locatie","zw",445,null,null,null,null,null,false,""]
[null,null,null,"bromide, bromaat en chloraat","dw+ow",465,null,null,null,null,null,false,""]
[null,null,null,"geur en smaak, organoleptisch","dw",450,null,null,null,null,null,false,""]
[]
[null,null,null,"Totale bijdrage anorganische ringonderzoeken",null,{"$f":"SUM(M6:M18)","v":0}]
[]
[]
[null,null,"Ringonderzoek","Omschrijving","Matrix","Prijs"]
[null,null,null,"extraheerbaar organohalogeen (EOX)","dw  ow  gw  aw",940,null,null,null,null,null,false,{"$f":"IF(L24=TRUE,F24,\"\")","v":""}]
[null,null,null,"adsorbeerbaar organohalogeen (AOX)","dw  ow  gw  aw",940,null,null,null,null,null,false,""]
[null,null,null,"pesticiden (OCP)","dw  ow  gw  aw",1095,null,null,null,null,null,false,""]
[null,null,null,"pesticiden (PCB)","dw  ow  gw",860,null,null,null,null,null,false,""]
[null,null,null,"polycyclische aromatische koolwaterstoffen (PAK)","dw  ow  gw  aw",975,null,null,null,null,null,false,""]
[null,null,null,"vluchtige gehalogeneerde koolwaterstoffen (VGK)","dw  ow  gw  aw",1110,null,null,null,null,null,false,""]
[null,null,null,"vluchtige aromatische koolwaterstoffen (VAK)","dw  ow  gw  aw",1110,null,null,null,null,null,false,""]
[null,null,null,"geneesmiddelen","dw  ow  gw  ",1110,null,null,null,null,null,false,""]
[null,null,null,"herbiciden ","dw  ow  gw",1095,null,null,null,null,null,false,""]
[null,null,null,"chloorfenoxycarbonzuren/bentazon","dw  ow  gw",1110,null,null,null,null,null,false,""]
[null,null,null,"fenylureumherbiciden (FUH)","dw  ow  gw",855,null,null,null,null,null,false,""]
[null,null,null,"glyfosaat en AMPA","dw  ow  gw",940,null,null,null,null,null,false,""]
[null,null,null,"minerale olie, alleen voor de GC methode","aw",235,null,null,null,null,null,false,{"$f":"IF(L36=TRUE,F36,\"\")","v":""}]
[null,null,null,"chloridazon, dimethenamid-P en metabolieten","dw  ow  gw",855,null,null,null,null,null,false,{"$f":"IF(L37=TRUE,F37,\"\")","v":""}]
[null,null,null,"brede screening, semi-kwantitatief LC-MS","dw  ow  gw  aw",940,null,null,null,null,null,false,{"$f":"IF(L38=TRUE,F38,\"\")","v":""}]
[]
[null,null,null,"Totale bijdrage organische ringonderzoeken",null,{"$f":"SUM(M24:M38)","v":0}]
[]
[]
[null,null,"Ringonderzoek","Omschrijving","Matrix","Prijs"]
[null,null,null,"bacteriologische parameters","dw ",820,null,null,null,null,null,false,{"$f":"IF(L44=TRUE,F44,\"\")","v":""}]
[null,null,null,"bacteriologische parameters","dw ",820,null,null,null,null,null,false,{"$f":"IF(L45=TRUE,F45,\"\")","v":""}]
[null,null,null,"bacteriologische parameters","dw ",820,null,null,null,null,null,false,""]
[null,null,null,"Legionella","dw",545,null,null,null,null,null,false,""]
[null,null,null,"Legionella","dw ",545,null,null,null,null,null,false,""]
[null,null,null,"Legionella","dw ",545,null,null,null,null,null,false,""]
[null,null,null,"ATP/Koloniegetal op R2A-medium","verdund ow",855,null,null,null,null,null,false,""]
[null,null,null,"Salmonella, staphylococcen en Pseudomonas aeruginosa","dw",820,null,null,null,null,null,false,""]
[null,null,null,"bacteriologische parameters","ow",820,null,null,null,null,null,false,""]
[null,null,null,"bacteriologische parameters","ow",820,null,null,null,null,null,false,""]
[null,null,null,"Legionella","kw",545,null,null,null,null,null,false,""]
[null,null,null,"Legionella","kw",545,null,null,null,null,null,false,""]
[null,null,null,"Legionella pneumophila qPCR","dw",490,null,null,null,null,null,false,{"$f":"IF(L56=TRUE,F56,\"\")","v":""}]
[null,null,null,"Legionella pneumophila qPCR","kw",490,null,null,null,null,null,false,{"$f":"IF(L57=TRUE,F57,\"\")","v":""}]
[null,null,null,"F-specifieke RNA-fagen en somatische coli-fagen","dw",615,null,null,null,null,null,false,{"$f":"IF(L58=TRUE,F58,\"\")","v":""}]
[null,null,null,"Totale bacteriële celtelling (inlc. fractie dood en levend), flowcytometrisch","dw",615,null,null,null,null,null,false,{"$f":"IF(L59=TRUE,F59,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(M6:M59)","v":0}]
[null,null,null,"Totale bijdrage microbiologische ringonderzoeken",null,{"$f":"SUM(M44:M59)","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(F61,F40,F20)","v":0}]
[null,null,"Rapport","Hardcopy rapport à € 35 per stuk",0,{"$f":"E66*35","v":0}]
[null,null,"Korting",{"$f":"L70&L71&L72&L73","v":"Geen (deelname aantal ringonderzoek <4)"},{"$f":"M70&M71&M72&M73","v":"Geen korting"},{"$f":"IF(AND(M60>=5,M60<=9),-0.05*(F65+F66),IF(AND(M60>=10,M60<=19),-0.1*(F65+F66),IF(M60>=20,-0.15*(F65+F66),\"\")))","v":""}]
[null,null,"Totale bijdrage in euro’s",null,null,{"$f":"SUM(F65:F67)","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(M60<=4,\"Geen (deelname aantal ringonderzoek <4)\",\"\")","v":"Geen (deelname aantal ringonderzoek <4)"},{"$f":"IF(L70>\"\",\"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(M60>=5,M60<=9),\"5% (deelname aantal ringonderzoek 5-9)\",\"\")","v":""},{"$f":"IF(L71>\"\",\"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(M60>=10,M60<=19),\"10% (deelname aantal ringonderzoek 10-19)\",\"\")","v":""},{"$f":"IF(L72>\"\",\"10% korting\",\"\")","v":""}]
[null,"Middels deze opdrachtbevestiging gaat u akkoord met de leveringsvoorwaarden van toepassing welke te downloaden zijn via www.kwrwater.nl/voorwaarden/. ",null,null,null,null,null,null,null,null,null,{"$f":"IF(M60>=20,\"15% (deelname aantal ringonderzoek >20)\",\"\")","v":""},{"$f":"IF(L73>\"\",\"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,"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"]