{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Hoofdmenu","Toelichting","NAW_gegevens","Voorblad","Specifieke informatie A","Controleoverzicht","Blad1","Parameters"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":65,"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":"Hoofdmenu","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["HOOFDMENU"]
[{"$f":"CONCATENATE(\"KWARTAALSTAAT ZVW \", jaar_id,\" \",kwartaal_id,\"E KW. (VERZEKERDEN JAN.-MRT.)\")","v":"KWARTAALSTAAT ZVW 2019 1E KW. (VERZEKERDEN JAN.-MRT.)"}]
["Navigatie","Afdrukken"]

{"sheet":"Toelichting","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,{"$f":"CONCATENATE(\" KWARTAALSTAAT ZVW \",jaar_id,\" \",kwartaal_id,\"E KWARTAAL (VERZEKERDEN JANUARI-MAART) - (VERSIE: \",versie_id,\")\")","v":" KWARTAALSTAAT ZVW 2019 1E KWARTAAL (VERZEKERDEN JANUARI-MAART) - (VERSIE: INF2019ZVW.1A)"}]

{"sheet":"NAW_gegevens","index":2,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2],[11,1,11,4]]}
[]
[]
[null,"NAW-GEGEVENS"]
[null,{"$f":"CONCATENATE(\"KWARTAALSTAAT ZVW \", jaar_id,\" \",kwartaal_id,\"E KW. (VERZEKERDEN JAN.-MRT.)\")","v":"KWARTAALSTAAT ZVW 2019 1E KW. (VERZEKERDEN JAN.-MRT.)"}]
[null," Selecteer uw nummer:","0000 KIES UW UZOVI-NUMMER"]
[null," Uzovi-nummer:",{"$f":"MID(keuze_uzovi_nummer,1,4)","v":"0000"}]
[null," Zorgverzekeraar:"]
[null," Plaats:"]
[null," Contactpersoon:"]
[null," E-mail:"]
[]
[null,"Let op dat u het goede UZOVI-nummer invult, zie onderstaand overzicht:"]
[]
[null,"UZOVI","NAAM",null,null,"PLAATS"]
[null,"0101","N.V. UNIVÉ ZORG",null,null,"ARNHEM"]
[null,"0104","CENTRALE ZIEKTEKOSTENVERZEKERING NZV N.V.",null,null,"TILBURG"]
[null,"0201","OHRA ZIEKTEKOSTENVERZEKERINGEN N.V. ",null,null,"TILBURG"]
[null,"0403","ASR BASIS ZIEKTEKOSTENVERZEKERINGEN N.V. ",null,null,"UTRECHT"]
[null,"0699","IZA ZORGVERZEKERAAR N.V.",null,null,"ARNHEM"]
[null,"0736","N.V. ZORGVERZEKERAAR UMC",null,null,"ARNHEM"]
[null,"3311","ZILVEREN KRUIS ZORGVERZEKERINGEN N.V.",null,null,"LEIDEN"]
[null,"3313","INTERPOLIS ZORGVERZEKERINGEN N.V.",null,null,"LEIDEN"]
[null,3329,"AVÉRO ACHMEA ZORGVERZEKERINGEN N.V.",null,null,"LEIDEN"]
[null,3332,"MENZIS ZORGVERZEKERAAR N.V.",null,null,"WAGENINGEN"]
[null,3333,"ANDERZORG N.V.",null,null,"GRONINGEN"]
[null,3343,"ONVZ ZIEKTEKOSTENVERZEKERAAR N.V.",null,null,"HOUTEN"]
[null,3351,"FBTO ZORGVERZEKERINGEN N.V.",null,null,"LEEUWARDEN"]
[null,3352,"IPTIQ LIFE S.A.",null,null,"AMSTELVEEN"]
[null,3358,"DE FRIESLAND ZORGVERZEKERAAR N.V.",null,null,"LEEUWARDEN"]
[null,3359,"EUCARE INSURANCE PCC LTD",null,null,"TA' XBIEX"]
[null,"7029","OWM ZORGVERZEKERAAR 'DSW' U.A.",null,null,"SCHIEDAM"]
[null,"7032","ENO ZORGVERZEKERAAR N.V.",null,null,"DEVENTER"]
[null,"7037","STAD HOLLAND ZORGVERZEKERAAR OWM U.A.",null,null,"SCHIEDAM"]
[null,"7053","OHRA ZORGVERZEKERINGEN  N.V.",null,null,"TILBURG"]
[null,"7085","OWM ZORGVERZEKERAAR ZORG EN ZEKERHEID U.A.",null,null,"LEIDEN"]
[null,"7095","VGZ ZORGVERZEKERAAR N.V.",null,null,"ARNHEM"]
[null,"7119","OWM CENTRALE ZORGVERZEKRAARS GROEP, ZORGVERZEKERAAR U.A.",null,null,"TILBURG"]
[null,"9015","VGZ VOOR DE ZORG N.V.",null,null,"ARNHEM"]

{"sheet":"Voorblad","index":3,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[15,3,16,11],[13,3,14,11],[19,3,20,11],[17,3,18,11]]}
[null,null,"VOORBLAD"]
[]
[]
[]
[]
["Pagina 1"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"KWARTAALSTAAT ZVW \",jaar_id)","v":"KWARTAALSTAAT ZVW 2019"}]
[]
[null,null,null,{"$f":"CONCATENATE(kwartaal_id,\"E KWARTAAL\")","v":"1E KWARTAAL"}]
[]
[null,null,null,"(VERZEKERDEN JANUARI-MAART)"]
[]
[null,null,null,"SPECIFIEKE INFORMATIE"]
[]
[]
[]
[null,null,null,"    SPECIFIEKE INFORMATIE A"]
[null,null,null,"     ● Informatie risicoverevening (pagina 1 t/m 3)"]

{"sheet":"Specifieke informatie A","index":4,"n_rows":139,"n_cols":12,"rows_kept":139,"cut":false,"hidden":false,"merged":[[11,9,11,10],[23,3,23,8],[17,3,17,8],[28,3,28,8],[30,3,30,8],[11,3,12,8],[14,3,14,8],[15,3,15,8],[18,3,18,8],[16,3,16,8],[26,3,26,8],[21,3,21,8],[22,3,22,8],[19,3,19,8],[24,3,24,8],[37,3,37,10],[57,11,58,11],[31,3,31,8],[25,3,25,8],[20,3,20,8],[29,3,29,8],[27,3,27,8],[11,11,12,11],[13,3,13,8],[63,3,63,8],[39,3,39,10],[48,3,48,4],[61,3,61,8],[57,9,57,10],[60,3,60,8],[62,3,62,8],[59,3,59,8],[38,3,38,10],[57,3,58,8],[41,9,43,11],[40,3,40,10],[32,3,32,8],[33,3,33,8],[64,3,64,8],[65,3,65,8],[71,3,71,8],[78,3,78,8],[75,3,75,8],[69,3,69,8],[66,3,66,8],[68,3,68,8],[67,3,67,8],[72,3,72,8],[70,3,70,8],[76,3,76,8],[73,3,73,8],[74,3,74,8],[77,3,77,8],[104,3,104,8],[132,9,134,11],[128,3,128,10],[129,3,129,10],[130,3,130,10],[131,3,131,10],[107,3,107,8],[108,3,108,8],[121,3,121,8],[116,3,116,8],[105,3,105,8],[112,3,112,8],[113,3,113,8],[114,3,114,8],[109,3,109,8],[110,3,110,8],[79,3,79,8],[83,3,83,10],[84,3,84,10],[93,3,93,4],[102,9,102,10],[85,3,85,10],[86,3,86,10],[87,9,89,11],[102,3,103,8],[102,11,103,11],[106,3,106,8],[138,3,138,4],[123,3,123,8],[124,3,124,8],[122,3,122,8],[120,3,120,8],[118,3,118,8],[119,3,119,8],[117,3,117,8],[111,3,111,8],[115,3,115,8]]}
[null,null,"INVULSPECIFICATIES SPECIFIEKE INFORMATIE A"]
[]
[]
[]
[]
["Pagina 1",null,null,{"$f":"CONCATENATE(\"KWARTAALSTAAT ZVW \", jaar_id,\" \",kwartaal_id,\"E KWARTAAL (VERZEKERDEN JANUARI-MAART)\")","v":"KWARTAALSTAAT ZVW 2019 1E KWARTAAL (VERZEKERDEN JANUARI-MAART)"}]
[null,null,null,"SPECIFIEKE INFORMATIE A"]
[null,null,null,{"$f":"IF(naw_uzovi_zorgverzekeraar<>\"0000\",CONCATENATE(UPPER(naw_naam_zorgverzekeraar),\", \",UPPER(naw_plaats_zorgverzekeraar)),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"UZOVI: \",naw_uzovi_zorgverzekeraar)","v":"UZOVI: 0000"}]
[null,null,null,"SPECIFICATIES INFORMATIE RISICOVEREVENING"]
[null,null,null,"VERZEKERDENSTAND NAAR RISICOKLASSE",null,null,null,null,null,null,null,"Peildatum: datum van nominale premieprolongatie"]
[null,null,null,null,null,null,null,null,null,null,null,"voor de maand JANUARI 2019"]
[null,null,null," LEEFTIJD",null,null,null,null,null,"AANTAL NAAR GESLACHT",null,"TOTAAL \nAANTAL"]
[null,null,null,null,null,null,null,null,null,"MAN","VROUW"]
[null,null,null,"  1a.   0  t/m   1",null,null,null,null,null,null,null,{"$f":"SUM(J14:K14)","v":0}]
[null,null,null,"  1b.   2  t/m   4",null,null,null,null,null,null,null,{"$f":"SUM(J15:K15)","v":0}]
[null,null,null,"  2.     5  t/m   9",null,null,null,null,null,null,null,0]
[null,null,null,"  3.   10  t/m 14",null,null,null,null,null,null,null,0]
[null,null,null,"  4.   15  t/m 19",null,null,null,null,null,null,null,0]
[null,null,null,"  5.   20  t/m 24",null,null,null,null,null,null,null,0]
[null,null,null,"  6.   25  t/m 29",null,null,null,null,null,null,null,0]
[null,null,null,"  7.   30  t/m 34",null,null,null,null,null,null,null,0]
[null,null,null,"  8.   35  t/m 39",null,null,null,null,null,null,null,0]
[null,null,null,"  9.   40  t/m 44",null,null,null,null,null,null,null,0]
[null,null,null," 10.  45  t/m 49",null,null,null,null,null,null,null,0]
[null,null,null," 11.  50  t/m 54",null,null,null,null,null,null,null,0]
[null,null,null," 12.  55  t/m 59",null,null,null,null,null,null,null,0]
[null,null,null," 13.  60  t/m 64",null,null,null,null,null,null,null,0]
[null,null,null," 14.  65  t/m 69",null,null,null,null,null,null,null,0]
[null,null,null," 15.  70  t/m 74",null,null,null,null,null,null,null,0]
[null,null,null," 16.  75  t/m 79",null,null,null,null,null,null,null,0]
[null,null,null," 17.  80  t/m 84",null,null,null,null,null,null,null,0]
[null,null,null," 18.  85  t/m 89",null,null,null,null,null,null,null,0]
[null,null,null," 19.  90 en ouder",null,null,null,null,null,null,null,{"$f":"SUM(J33:K33)","v":0}]
[null,null,null," TOTAAL",null,null,null,null,null,{"$f":"SUM(J14:J33)","v":0},{"$f":"SUM(K14:K33)","v":0},{"$f":"SUM(J34:K34)","v":0}]
[]
[null,null,null,"VERZEKERDENSTAND NAAR NOMINALE PREMIE",null,null,null,null,null,null,null,"Peildatum: datum van nominale premieprolongatie"]
[null,null,null,null,null,null,null,null,null,null,null,"voor de maand JANUARI 2019"]
[null,null,null,null,null,null,null,null,null,null,null,"AANTAL"]
[null,null,null," Verzekerden met nominale premie Zvw"]
[null,null,null," Verzekerden zonder nominale premie Zvw"]
[null,null,null," TOTAAL",null,null,null,null,null,null,null,{"$f":"SUM(L39:L40)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(K34)=FALSE,ISBLANK(L39)=FALSE),IF(L39<SUM(L19:L33),\"ATTENTIE: is het juist dat het aantal verzekerden \nmet nominale premie kleiner is dan het totaal\naantal verzekerden van 20 jaar en ouder?\",\"\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"NOW()","v":"2018-11-19T15:05:02.820"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Specifieke informatie A, \",LOWER(A6))","v":"Specifieke informatie A, pagina 1"}]
[]
["Pagina 2",null,null,{"$f":"CONCATENATE(\"KWARTAALSTAAT ZVW \", jaar_id,\" \",kwartaal_id,\"E KWARTAAL (VERZEKERDEN JANUARI-MAART)\")","v":"KWARTAALSTAAT ZVW 2019 1E KWARTAAL (VERZEKERDEN JANUARI-MAART)"}]
[null,null,null,"SPECIFIEKE INFORMATIE A"]
[null,null,null,{"$f":"IF(naw_uzovi_zorgverzekeraar<>\"0000\",CONCATENATE(UPPER(naw_naam_zorgverzekeraar),\", \",UPPER(naw_plaats_zorgverzekeraar)),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"UZOVI: \",naw_uzovi_zorgverzekeraar)","v":"UZOVI: 0000"}]
[]
[null,null,null,"SPECIFICATIES INFORMATIE RISICOVEREVENING"]
[null,null,null,"VERZEKERDENSTAND NAAR RISICOKLASSE",null,null,null,null,null,null,null,"Peildatum: datum van nominale premieprolongatie"]
[null,null,null,null,null,null,null,null,null,null,null,"voor de maand FEBRUARI 2019"]
[null,null,null," LEEFTIJD",null,null,null,null,null,"AANTAL NAAR GESLACHT",null,"TOTAAL \nAANTAL"]
[null,null,null,null,null,null,null,null,null,"MAN","VROUW"]
[null,null,null,"  1a.   0  t/m   1",null,null,null,null,null,null,null,{"$f":"SUM(J60:K60)","v":0}]
[null,null,null,"  1b.   2  t/m   4",null,null,null,null,null,null,null,0]
[null,null,null,"  2.     5  t/m   9",null,null,null,null,null,null,null,0]
[null,null,null,"  3.   10  t/m 14",null,null,null,null,null,null,null,0]
[null,null,null,"  4.   15  t/m 19",null,null,null,null,null,null,null,0]
[null,null,null,"  5.   20  t/m 24",null,null,null,null,null,null,null,0]
[null,null,null,"  6.   25  t/m 29",null,null,null,null,null,null,null,0]
[null,null,null,"  7.   30  t/m 34",null,null,null,null,null,null,null,0]
[null,null,null,"  8.   35  t/m 39",null,null,null,null,null,null,null,0]
[null,null,null,"  9.   40  t/m 44",null,null,null,null,null,null,null,0]
[null,null,null," 10.  45  t/m 49",null,null,null,null,null,null,null,0]
[null,null,null," 11.  50  t/m 54",null,null,null,null,null,null,null,0]
[null,null,null," 12.  55  t/m 59",null,null,null,null,null,null,null,0]
[null,null,null," 13.  60  t/m 64",null,null,null,null,null,null,null,0]
[null,null,null," 14.  65  t/m 69",null,null,null,null,null,null,null,0]
[null,null,null," 15.  70  t/m 74",null,null,null,null,null,null,null,0]
[null,null,null," 16.  75  t/m 79",null,null,null,null,null,null,null,0]
[null,null,null," 17.  80  t/m 84",null,null,null,null,null,null,null,0]
[null,null,null," 18.  85  t/m 89",null,null,null,null,null,null,null,0]
[null,null,null," 19.  90 en ouder",null,null,null,null,null,null,null,0]
[null,null,null," TOTAAL",null,null,null,null,null,{"$f":"SUM(J60:J79)","v":0},{"$f":"SUM(K60:K79)","v":0},0]
[]
[null,null,null,"VERZEKERDENSTAND NAAR NOMINALE PREMIE",null,null,null,null,null,null,null,"Peildatum: datum van nominale premieprolongatie"]
[null,null,null,null,null,null,null,null,null,null,null,"voor de maand FEBRUARI 2019"]
[null,null,null,null,null,null,null,null,null,null,null,"AANTAL"]
[null,null,null," Verzekerden met nominale premie Zvw"]
[null,null,null," Verzekerden zonder nominale premie Zvw"]
[null,null,null," TOTAAL",null,null,null,null,null,null,null,{"$f":"SUM(L85:L86)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(K80)=FALSE,ISBLANK(L85)=FALSE),IF(L85<SUM(L65:L79),\"ATTENTIE: is het juist dat het aantal verzekerden \nmet nominale premie kleiner is dan het totaal\naantal verzekerden van 20 jaar en ouder?\",\"\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"NOW()","v":"2018-11-19T15:05:02.820"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Specifieke informatie A, \",LOWER(A51))","v":"Specifieke informatie A, pagina 2"}]
[]
["Pagina 3",null,null,{"$f":"CONCATENATE(\"KWARTAALSTAAT ZVW \", jaar_id,\" \",kwartaal_id,\"E KWARTAAL (VERZEKERDEN JANUARI-MAART)\")","v":"KWARTAALSTAAT ZVW 2019 1E KWARTAAL (VERZEKERDEN JANUARI-MAART)"}]
[null,null,null,"SPECIFIEKE INFORMATIE A"]
[null,null,null,{"$f":"IF(naw_uzovi_zorgverzekeraar<>\"0000\",CONCATENATE(UPPER(naw_naam_zorgverzekeraar),\", \",UPPER(naw_plaats_zorgverzekeraar)),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"UZOVI: \",naw_uzovi_zorgverzekeraar)","v":"UZOVI: 0000"}]
[]
[null,null,null,"SPECIFICATIES INFORMATIE RISICOVEREVENING"]
[null,null,null,"VERZEKERDENSTAND NAAR RISICOKLASSE",null,null,null,null,null,null,null,"Peildatum: datum van nominale premieprolongatie"]
[null,null,null,null,null,null,null,null,null,null,null,"voor de maand MAART 2019"]
[null,null,null," LEEFTIJD",null,null,null,null,null,"AANTAL NAAR GESLACHT",null,"TOTAAL \nAANTAL"]
[null,null,null,null,null,null,null,null,null,"MAN","VROUW"]
[null,null,null,"  1a.   0  t/m   1",null,null,null,null,null,null,null,{"$f":"SUM(J105:K105)","v":0}]
[null,null,null,"  1b.   2  t/m   4",null,null,null,null,null,null,null,0]
[null,null,null,"  2.     5  t/m   9",null,null,null,null,null,null,null,0]
[null,null,null,"  3.   10  t/m 14",null,null,null,null,null,null,null,0]
[null,null,null,"  4.   15  t/m 19",null,null,null,null,null,null,null,0]
[null,null,null,"  5.   20  t/m 24",null,null,null,null,null,null,null,0]
[null,null,null,"  6.   25  t/m 29",null,null,null,null,null,null,null,0]
[null,null,null,"  7.   30  t/m 34",null,null,null,null,null,null,null,0]
[null,null,null,"  8.   35  t/m 39",null,null,null,null,null,null,null,0]
[null,null,null,"  9.   40  t/m 44",null,null,null,null,null,null,null,0]
[null,null,null," 10.  45  t/m 49",null,null,null,null,null,null,null,0]
[null,null,null," 11.  50  t/m 54",null,null,null,null,null,null,null,0]
[null,null,null," 12.  55  t/m 59",null,null,null,null,null,null,null,0]
[null,null,null," 13.  60  t/m 64",null,null,null,null,null,null,null,0]
[null,null,null," 14.  65  t/m 69",null,null,null,null,null,null,null,0]
[null,null,null," 15.  70  t/m 74",null,null,null,null,null,null,null,0]
[null,null,null," 16.  75  t/m 79",null,null,null,null,null,null,null,0]
[null,null,null," 17.  80  t/m 84",null,null,null,null,null,null,null,0]
[null,null,null," 18.  85  t/m 89",null,null,null,null,null,null,null,0]
[null,null,null," 19.  90 en ouder",null,null,null,null,null,null,null,0]
[null,null,null," TOTAAL",null,null,null,null,null,{"$f":"SUM(J105:J124)","v":0},{"$f":"SUM(K105:K124)","v":0},0]
[]
[null,null,null,"VERZEKERDENSTAND NAAR NOMINALE PREMIE",null,null,null,null,null,null,null,"Peildatum: datum van nominale premieprolongatie"]
[null,null,null,null,null,null,null,null,null,null,null,"voor de maand MAART 2019"]
[null,null,null,null,null,null,null,null,null,null,null,"AANTAL"]
[null,null,null," Verzekerden met nominale premie Zvw"]
[null,null,null," Verzekerden zonder nominale premie Zvw"]
[null,null,null," TOTAAL",null,null,null,null,null,null,null,{"$f":"SUM(L130:L131)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(K125)=FALSE,ISBLANK(L130)=FALSE),IF(L130<SUM(L110:L124),\"ATTENTIE: is het juist dat het aantal verzekerden \nmet nominale premie kleiner is dan het totaal\naantal verzekerden van 20 jaar en ouder?\",\"\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"NOW()","v":"2018-11-19T15:05:02.820"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Specifieke informatie A, \",LOWER(A96))","v":"Specifieke informatie A, pagina 3"}]

{"sheet":"Controleoverzicht","index":5,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[13,3,13,8],[14,3,14,8],[10,10,11,10],[10,11,11,11],[10,9,11,9],[10,3,11,8],[12,3,12,8]]}
[null,null,"SPECIFICATIES CONTROLEOVERZICHT"]
[]
[]
[]
[]
["Pagina 1",null,null,{"$f":"CONCATENATE(\"KWARTAALSTAAT ZVW \", jaar_id,\" \",kwartaal_id,\"E KWARTAAL (VERZEKERDEN JANUARI-MAART)\")","v":"KWARTAALSTAAT ZVW 2019 1E KWARTAAL (VERZEKERDEN JANUARI-MAART)"}]
[null,null,null,"CONTROLEOVERZICHT"]
[null,null,null,{"$f":"IF(naw_uzovi_zorgverzekeraar<>\"0000\",CONCATENATE(UPPER(naw_naam_zorgverzekeraar),\", \",UPPER(naw_plaats_zorgverzekeraar)),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"UZOVI: \",naw_uzovi_zorgverzekeraar)","v":"UZOVI: 0000"}]
[]
[null,null,null,"SPECIFIEKE INFORMATIE A"]
[null,null,null," VERZEKERDENSTANDEN",null,null,null,null,null,"JANUARI","FEBRUARI","MAART"]
[]
[null,null,null," Verzekerdenstand naar risicoklasse",null,null,null,null,null,{"$f":"'Specifieke informatie A'!L34","v":0},{"$f":"'Specifieke informatie A'!L80","v":0},{"$f":"'Specifieke informatie A'!L125","v":0}]
[null,null,null," Verzekerdenstand naar nominale premie",null,null,null,null,null,{"$f":"'Specifieke informatie A'!L41","v":0},{"$f":"'Specifieke informatie A'!L87","v":0},{"$f":"'Specifieke informatie A'!L132","v":0}]
[null,null,null," Verschil",null,null,null,null,null,{"$f":"IF(J13<>J14,J13-J14,\"\")","v":""},{"$f":"IF(K13<>K14,K13-K14,\"\")","v":""},{"$f":"IF(L13<>L14,L13-L14,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"NOW()","v":"2018-11-19T15:05:02.820"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Controle-overzicht \",LOWER(A6))","v":"Controle-overzicht pagina 1"}]

{"sheet":"Blad1","index":6,"n_rows":126,"n_cols":6,"rows_kept":126,"cut":false,"hidden":true,"merged":[]}
[70122626,{"$f":"'Specifieke informatie A'!$J$14","v":0},null,null,null,"*='Specifieke informatie A'!$J$14"]
[70122627,{"$f":"'Specifieke informatie A'!$K$14","v":0},null,null,null,"*='Specifieke informatie A'!$K$14"]
[70122628,{"$f":"'Specifieke informatie A'!$J$15","v":0},null,null,null,"*='Specifieke informatie A'!$J$15"]
[70122629,{"$f":"'Specifieke informatie A'!$K$15","v":0},null,null,null,"*='Specifieke informatie A'!$K$15"]
[70122630,{"$f":"'Specifieke informatie A'!$J$16","v":0},null,null,null,"*='Specifieke informatie A'!$J$16"]
[70122631,{"$f":"'Specifieke informatie A'!$K$16","v":0},null,null,null,"*='Specifieke informatie A'!$K$16"]
[70122624,{"$f":"'Specifieke informatie A'!$J$17","v":0},null,null,null,"*='Specifieke informatie A'!$J$17"]
[70122625,{"$f":"'Specifieke informatie A'!$K$17","v":0},null,null,null,"*='Specifieke informatie A'!$K$17"]
[70122632,{"$f":"'Specifieke informatie A'!$J$18","v":0},null,null,null,"*='Specifieke informatie A'!$J$18"]
[70122633,{"$f":"'Specifieke informatie A'!$K$18","v":0},null,null,null,"*='Specifieke informatie A'!$K$18"]
[70122634,{"$f":"'Specifieke informatie A'!$J$19","v":0},null,null,null,"*='Specifieke informatie A'!$J$19"]
[70122635,{"$f":"'Specifieke informatie A'!$K$19","v":0},null,null,null,"*='Specifieke informatie A'!$K$19"]
[70122636,{"$f":"'Specifieke informatie A'!$J$20","v":0},null,null,null,"*='Specifieke informatie A'!$J$20"]
[70122637,{"$f":"'Specifieke informatie A'!$K$20","v":0},null,null,null,"*='Specifieke informatie A'!$K$20"]
[70122638,{"$f":"'Specifieke informatie A'!$J$21","v":0},null,null,null,"*='Specifieke informatie A'!$J$21"]
[70122639,{"$f":"'Specifieke informatie A'!$K$21","v":0},null,null,null,"*='Specifieke informatie A'!$K$21"]
[70122640,{"$f":"'Specifieke informatie A'!$J$22","v":0},null,null,null,"*='Specifieke informatie A'!$J$22"]
[70122641,{"$f":"'Specifieke informatie A'!$K$22","v":0},null,null,null,"*='Specifieke informatie A'!$K$22"]
[70122642,{"$f":"'Specifieke informatie A'!$J$23","v":0},null,null,null,"*='Specifieke informatie A'!$J$23"]
[70122643,{"$f":"'Specifieke informatie A'!$K$23","v":0},null,null,null,"*='Specifieke informatie A'!$K$23"]
[70122644,{"$f":"'Specifieke informatie A'!$J$24","v":0},null,null,null,"*='Specifieke informatie A'!$J$24"]
[70122645,{"$f":"'Specifieke informatie A'!$K$24","v":0},null,null,null,"*='Specifieke informatie A'!$K$24"]
[70122646,{"$f":"'Specifieke informatie A'!$J$25","v":0},null,null,null,"*='Specifieke informatie A'!$J$25"]
[70122647,{"$f":"'Specifieke informatie A'!$K$25","v":0},null,null,null,"*='Specifieke informatie A'!$K$25"]
[70122648,{"$f":"'Specifieke informatie A'!$J$26","v":0},null,null,null,"*='Specifieke informatie A'!$J$26"]
[70122649,{"$f":"'Specifieke informatie A'!$K$26","v":0},null,null,null,"*='Specifieke informatie A'!$K$26"]
[70122650,{"$f":"'Specifieke informatie A'!$J$27","v":0},null,null,null,"*='Specifieke informatie A'!$J$27"]
[70122651,{"$f":"'Specifieke informatie A'!$K$27","v":0},null,null,null,"*='Specifieke informatie A'!$K$27"]
[70122652,{"$f":"'Specifieke informatie A'!$J$28","v":0},null,null,null,"*='Specifieke informatie A'!$J$28"]
[70122653,{"$f":"'Specifieke informatie A'!$K$28","v":0},null,null,null,"*='Specifieke informatie A'!$K$28"]
[70122654,{"$f":"'Specifieke informatie A'!$J$29","v":0},null,null,null,"*='Specifieke informatie A'!$J$29"]
[70122655,{"$f":"'Specifieke informatie A'!$K$29","v":0},null,null,null,"*='Specifieke informatie A'!$K$29"]
[70122656,{"$f":"'Specifieke informatie A'!$J$30","v":0},null,null,null,"*='Specifieke informatie A'!$J$30"]
[70122657,{"$f":"'Specifieke informatie A'!$K$30","v":0},null,null,null,"*='Specifieke informatie A'!$K$30"]
[70122658,{"$f":"'Specifieke informatie A'!$J$31","v":0},null,null,null,"*='Specifieke informatie A'!$J$31"]
[70122659,{"$f":"'Specifieke informatie A'!$K$31","v":0},null,null,null,"*='Specifieke informatie A'!$K$31"]
[70122660,{"$f":"'Specifieke informatie A'!$J$32","v":0},null,null,null,"*='Specifieke informatie A'!$J$32"]
[70122661,{"$f":"'Specifieke informatie A'!$K$32","v":0},null,null,null,"*='Specifieke informatie A'!$K$32"]
[70122662,{"$f":"'Specifieke informatie A'!$J$33","v":0},null,null,null,"*='Specifieke informatie A'!$J$33"]
[70122663,{"$f":"'Specifieke informatie A'!$K$33","v":0},null,null,null,"*='Specifieke informatie A'!$K$33"]
[70122664,{"$f":"'Specifieke informatie A'!$L$39","v":0},null,null,null,"*='Specifieke informatie A'!$L$39"]
[70122665,{"$f":"'Specifieke informatie A'!$L$40","v":0},null,null,null,"*='Specifieke informatie A'!$L$40"]
[70122678,{"$f":"'Specifieke informatie A'!$J$60","v":0},null,null,null,"*='Specifieke informatie A'!$J$60"]
[70122679,{"$f":"'Specifieke informatie A'!$K$60","v":0},null,null,null,"*='Specifieke informatie A'!$K$60"]
[70122680,{"$f":"'Specifieke informatie A'!$J$61","v":0},null,null,null,"*='Specifieke informatie A'!$J$61"]
[70122681,{"$f":"'Specifieke informatie A'!$K$61","v":0},null,null,null,"*='Specifieke informatie A'!$K$61"]
[70122682,{"$f":"'Specifieke informatie A'!$J$62","v":0},null,null,null,"*='Specifieke informatie A'!$J$62"]
[70122683,{"$f":"'Specifieke informatie A'!$K$62","v":0},null,null,null,"*='Specifieke informatie A'!$K$62"]
[70122684,{"$f":"'Specifieke informatie A'!$J$63","v":0},null,null,null,"*='Specifieke informatie A'!$J$63"]
[70122685,{"$f":"'Specifieke informatie A'!$K$63","v":0},null,null,null,"*='Specifieke informatie A'!$K$63"]
[70122686,{"$f":"'Specifieke informatie A'!$J$64","v":0},null,null,null,"*='Specifieke informatie A'!$J$64"]
[70122687,{"$f":"'Specifieke informatie A'!$K$64","v":0},null,null,null,"*='Specifieke informatie A'!$K$64"]
[70122688,{"$f":"'Specifieke informatie A'!$J$65","v":0},null,null,null,"*='Specifieke informatie A'!$J$65"]
[70122689,{"$f":"'Specifieke informatie A'!$K$65","v":0},null,null,null,"*='Specifieke informatie A'!$K$65"]
[70122690,{"$f":"'Specifieke informatie A'!$J$66","v":0},null,null,null,"*='Specifieke informatie A'!$J$66"]
[70122691,{"$f":"'Specifieke informatie A'!$K$66","v":0},null,null,null,"*='Specifieke informatie A'!$K$66"]
[70122692,{"$f":"'Specifieke informatie A'!$J$67","v":0},null,null,null,"*='Specifieke informatie A'!$J$67"]
[70122693,{"$f":"'Specifieke informatie A'!$K$67","v":0},null,null,null,"*='Specifieke informatie A'!$K$67"]
[70122694,{"$f":"'Specifieke informatie A'!$J$68","v":0},null,null,null,"*='Specifieke informatie A'!$J$68"]
[70122695,{"$f":"'Specifieke informatie A'!$K$68","v":0},null,null,null,"*='Specifieke informatie A'!$K$68"]
[70122696,{"$f":"'Specifieke informatie A'!$J$69","v":0},null,null,null,"*='Specifieke informatie A'!$J$69"]
[70122697,{"$f":"'Specifieke informatie A'!$K$69","v":0},null,null,null,"*='Specifieke informatie A'!$K$69"]
[70122698,{"$f":"'Specifieke informatie A'!$J$70","v":0},null,null,null,"*='Specifieke informatie A'!$J$70"]
[70122699,{"$f":"'Specifieke informatie A'!$K$70","v":0},null,null,null,"*='Specifieke informatie A'!$K$70"]
[70122700,{"$f":"'Specifieke informatie A'!$J$71","v":0},null,null,null,"*='Specifieke informatie A'!$J$71"]
[70122701,{"$f":"'Specifieke informatie A'!$K$71","v":0},null,null,null,"*='Specifieke informatie A'!$K$71"]
[70122702,{"$f":"'Specifieke informatie A'!$J$72","v":0},null,null,null,"*='Specifieke informatie A'!$J$72"]
[70122703,{"$f":"'Specifieke informatie A'!$K$72","v":0},null,null,null,"*='Specifieke informatie A'!$K$72"]
[70122704,{"$f":"'Specifieke informatie A'!$J$73","v":0},null,null,null,"*='Specifieke informatie A'!$J$73"]
[70122705,{"$f":"'Specifieke informatie A'!$K$73","v":0},null,null,null,"*='Specifieke informatie A'!$K$73"]
[70122706,{"$f":"'Specifieke informatie A'!$J$74","v":0},null,null,null,"*='Specifieke informatie A'!$J$74"]
[70122707,{"$f":"'Specifieke informatie A'!$K$74","v":0},null,null,null,"*='Specifieke informatie A'!$K$74"]
[70122676,{"$f":"'Specifieke informatie A'!$J$75","v":0},null,null,null,"*='Specifieke informatie A'!$J$75"]
[70122677,{"$f":"'Specifieke informatie A'!$K$75","v":0},null,null,null,"*='Specifieke informatie A'!$K$75"]
[70122668,{"$f":"'Specifieke informatie A'!$J$76","v":0},null,null,null,"*='Specifieke informatie A'!$J$76"]
[70122669,{"$f":"'Specifieke informatie A'!$K$76","v":0},null,null,null,"*='Specifieke informatie A'!$K$76"]
[70122670,{"$f":"'Specifieke informatie A'!$J$77","v":0},null,null,null,"*='Specifieke informatie A'!$J$77"]
[70122671,{"$f":"'Specifieke informatie A'!$K$77","v":0},null,null,null,"*='Specifieke informatie A'!$K$77"]
[70122672,{"$f":"'Specifieke informatie A'!$J$78","v":0},null,null,null,"*='Specifieke informatie A'!$J$78"]
[70122673,{"$f":"'Specifieke informatie A'!$K$78","v":0},null,null,null,"*='Specifieke informatie A'!$K$78"]
[70122674,{"$f":"'Specifieke informatie A'!$J$79","v":0},null,null,null,"*='Specifieke informatie A'!$J$79"]
[70122675,{"$f":"'Specifieke informatie A'!$K$79","v":0},null,null,null,"*='Specifieke informatie A'!$K$79"]
[70122748,{"$f":"'Specifieke informatie A'!$L$85","v":0},null,null,null,"*='Specifieke informatie A'!$L$85"]
[70122749,{"$f":"'Specifieke informatie A'!$L$86","v":0},null,null,null,"*='Specifieke informatie A'!$L$86"]
[70122714,{"$f":"'Specifieke informatie A'!$J$105","v":0},null,null,null,"*='Specifieke informatie A'!$J$105"]
[70122715,{"$f":"'Specifieke informatie A'!$K$105","v":0},null,null,null,"*='Specifieke informatie A'!$K$105"]
[70122718,{"$f":"'Specifieke informatie A'!$J$106","v":0},null,null,null,"*='Specifieke informatie A'!$J$106"]
[70122719,{"$f":"'Specifieke informatie A'!$K$106","v":0},null,null,null,"*='Specifieke informatie A'!$K$106"]
[70122708,{"$f":"'Specifieke informatie A'!$J$107","v":0},null,null,null,"*='Specifieke informatie A'!$J$107"]
[70122709,{"$f":"'Specifieke informatie A'!$K$107","v":0},null,null,null,"*='Specifieke informatie A'!$K$107"]
[70122710,{"$f":"'Specifieke informatie A'!$J$108","v":0},null,null,null,"*='Specifieke informatie A'!$J$108"]
[70122711,{"$f":"'Specifieke informatie A'!$K$108","v":0},null,null,null,"*='Specifieke informatie A'!$K$108"]
[70122712,{"$f":"'Specifieke informatie A'!$J$109","v":0},null,null,null,"*='Specifieke informatie A'!$J$109"]
[70122713,{"$f":"'Specifieke informatie A'!$K$109","v":0},null,null,null,"*='Specifieke informatie A'!$K$109"]
[70122716,{"$f":"'Specifieke informatie A'!$J$110","v":0},null,null,null,"*='Specifieke informatie A'!$J$110"]
[70122717,{"$f":"'Specifieke informatie A'!$K$110","v":0},null,null,null,"*='Specifieke informatie A'!$K$110"]
[70122720,{"$f":"'Specifieke informatie A'!$J$111","v":0},null,null,null,"*='Specifieke informatie A'!$J$111"]
[70122721,{"$f":"'Specifieke informatie A'!$K$111","v":0},null,null,null,"*='Specifieke informatie A'!$K$111"]
[70122722,{"$f":"'Specifieke informatie A'!$J$112","v":0},null,null,null,"*='Specifieke informatie A'!$J$112"]
[70122723,{"$f":"'Specifieke informatie A'!$K$112","v":0},null,null,null,"*='Specifieke informatie A'!$K$112"]
[70122724,{"$f":"'Specifieke informatie A'!$J$113","v":0},null,null,null,"*='Specifieke informatie A'!$J$113"]
[70122725,{"$f":"'Specifieke informatie A'!$K$113","v":0},null,null,null,"*='Specifieke informatie A'!$K$113"]
[70122726,{"$f":"'Specifieke informatie A'!$J$114","v":0},null,null,null,"*='Specifieke informatie A'!$J$114"]
[70122727,{"$f":"'Specifieke informatie A'!$K$114","v":0},null,null,null,"*='Specifieke informatie A'!$K$114"]
[70122728,{"$f":"'Specifieke informatie A'!$J$115","v":0},null,null,null,"*='Specifieke informatie A'!$J$115"]
[70122729,{"$f":"'Specifieke informatie A'!$K$115","v":0},null,null,null,"*='Specifieke informatie A'!$K$115"]
[70122730,{"$f":"'Specifieke informatie A'!$J$116","v":0},null,null,null,"*='Specifieke informatie A'!$J$116"]
[70122731,{"$f":"'Specifieke informatie A'!$K$116","v":0},null,null,null,"*='Specifieke informatie A'!$K$116"]
[70122732,{"$f":"'Specifieke informatie A'!$J$117","v":0},null,null,null,"*='Specifieke informatie A'!$J$117"]
[70122733,{"$f":"'Specifieke informatie A'!$K$117","v":0},null,null,null,"*='Specifieke informatie A'!$K$117"]
[70122734,{"$f":"'Specifieke informatie A'!$J$118","v":0},null,null,null,"*='Specifieke informatie A'!$J$118"]
[70122735,{"$f":"'Specifieke informatie A'!$K$118","v":0},null,null,null,"*='Specifieke informatie A'!$K$118"]
[70122736,{"$f":"'Specifieke informatie A'!$J$119","v":0},null,null,null,"*='Specifieke informatie A'!$J$119"]
[70122737,{"$f":"'Specifieke informatie A'!$K$119","v":0},null,null,null,"*='Specifieke informatie A'!$K$119"]
[70122738,{"$f":"'Specifieke informatie A'!$J$120","v":0},null,null,null,"*='Specifieke informatie A'!$J$120"]
[70122739,{"$f":"'Specifieke informatie A'!$K$120","v":0},null,null,null,"*='Specifieke informatie A'!$K$120"]
[70122740,{"$f":"'Specifieke informatie A'!$J$121","v":0},null,null,null,"*='Specifieke informatie A'!$J$121"]
[70122741,{"$f":"'Specifieke informatie A'!$K$121","v":0},null,null,null,"*='Specifieke informatie A'!$K$121"]
[70122742,{"$f":"'Specifieke informatie A'!$J$122","v":0},null,null,null,"*='Specifieke informatie A'!$J$122"]
[70122743,{"$f":"'Specifieke informatie A'!$K$122","v":0},null,null,null,"*='Specifieke informatie A'!$K$122"]
[70122744,{"$f":"'Specifieke informatie A'!$J$123","v":0},null,null,null,"*='Specifieke informatie A'!$J$123"]
[70122745,{"$f":"'Specifieke informatie A'!$K$123","v":0},null,null,null,"*='Specifieke informatie A'!$K$123"]
[70122746,{"$f":"'Specifieke informatie A'!$J$124","v":0},null,null,null,"*='Specifieke informatie A'!$J$124"]
[70122747,{"$f":"'Specifieke informatie A'!$K$124","v":0},null,null,null,"*='Specifieke informatie A'!$K$124"]
[70122666,{"$f":"'Specifieke informatie A'!$L$130","v":0},null,null,null,"*='Specifieke informatie A'!$L$130"]
[70122667,{"$f":"'Specifieke informatie A'!$L$131","v":0},null,null,null,"*='Specifieke informatie A'!$L$131"]

{"sheet":"Parameters","index":7,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
["Kwartaal:",1]
["Jaar:",2019]
["Wet:","ZVW"]
["Document:",{"$f":"CONCATENATE(\"INF\",jaar_id,wet_id,\".\",kwartaal_id)","v":"INF2019ZVW.1"}]
["Revisie:","A"]
["Revisiedatum:","2019-01-01"]
["Versie:",{"$f":"CONCATENATE(document_id,revisie_id)","v":"INF2019ZVW.1A"}]
[]
[]
[]
["NUMMER_UO","NAAM_UO","FORMAT_UO1"]
["0000","KIES UW UZOVI-NUMMER",{"$f":"CONCATENATE(A13,\" \",B13)","v":"0000 KIES UW UZOVI-NUMMER"}]
["0101","UNIVÉ ZORG","0101 UNIVÉ ZORG"]
["0104","NATIONALE-NEDERLANDEN ZORG","0104 NATIONALE-NEDERLANDEN ZORG"]
["0201","OHRA ZIEKTEKOSTENVERZEKERINGEN","0201 OHRA ZIEKTEKOSTENVERZEKERINGEN"]
["0403","ASR","0403 ASR"]
["0699","IZA","0699 IZA"]
["0736","UMC","0736 UMC"]
["3311","ZILVEREN KRUIS","3311 ZILVEREN KRUIS"]
["3313","INTERPOLIS","3313 INTERPOLIS"]
["3329","AVÉRO",{"$f":"CONCATENATE(A22,\" \",B22)","v":"3329 AVÉRO"}]
["3332","MENZIS","3332 MENZIS"]
["3333","ANDERZORG","3333 ANDERZORG"]
["3343","ONVZ",{"$f":"CONCATENATE(A25,\" \",B25)","v":"3343 ONVZ"}]
["3351","FBTO",{"$f":"CONCATENATE(A26,\" \",B26)","v":"3351 FBTO"}]
["3352","IPTIQ",{"$f":"CONCATENATE(A27,\" \",B27)","v":"3352 IPTIQ"}]
["3358","DE FRIESLAND",{"$f":"CONCATENATE(A28,\" \",B28)","v":"3358 DE FRIESLAND"}]
["3359","EUCARE",{"$f":"CONCATENATE(A29,\" \",B29)","v":"3359 EUCARE"}]
["7029","DSW","7029 DSW"]
["7032","ENO","7032 ENO"]
["7037","STAD HOLLAND","7037 STAD HOLLAND"]
["7053","OHRA ZORGVERZEKERINGEN","7053 OHRA ZORGVERZEKERINGEN"]
["7085","ZORG EN ZEKERHEID","7085 ZORG EN ZEKERHEID"]
["7095","VGZ ZORGVERZEKERAAR","7095 VGZ ZORGVERZEKERAAR"]
["7119","CZ","7119 CZ"]
["9015","VGZ VOOR DE ZORG","9015 VGZ VOOR DE ZORG"]