{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Traitement des donnees.","Text Brut","Blad3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Traitement des donnees.","index":0,"n_rows":116,"n_cols":12,"rows_kept":116,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
["Row data…",null,null,"nopol","mutcode","tarif."]
["000002-HEMMEN-SCHW.W.VAN",null,null,"000002","","",null,null,"1)","Premier pas:",null,"Faire sortir le  \"nopol\"  ( colonne D)"]
[4,null,null,"","",""]
[212,null,null,"",4,212,{"$nulls":4},"La condition: ","Si l'input  dans la colonne A a une longeur plus de 7 digit ,  faire sortir les 6 premiers ( a gaushe) dans la colonne D"]
[212,null,null,"","",212,{"$nulls":5},"si non , faire rien.."]
[212,null,null,"","",212]
[212,null,null,"","",212]
["000002-HEMMEN-SCHW.W.VAN",null,null,"000002","",""]
[34,null,null,"","","",null,null,"2)","Deuxieme pas:",null,"Faire sortir le  \"mutcode\" ( colonne E)"]
[212,null,null,"",34,212]
[212,null,null,"","",212,{"$nulls":4},"La condition: ","Si l'input  dans la colonne A a une longeur  de 1 ou 2 digits,  faire sortir les la value dans la colonne E"]
[212,null,null,"","",212,{"$nulls":5},"si non , faire rien.."]
[212,null,null,"","",212]
["000003-ROOSENDAAL",null,null,"000003","","",null,null,"3)","Troisieme pas:",null,"Faire sortir le  \"mutcode\" ( colonne E)"]
[4,null,null,"","",""]
[212,null,null,"",4,212,{"$nulls":4},"La condition: ","Si l'input  dans la colonne A a une longeur de =3 digit ,  faire sortir les la value dans la colonne F"]
[313,null,null,"","",313,{"$nulls":5},"si non , faire rien.."]
[513,null,null,"","",513]
[212,null,null,"","",212]
[313,null,null,"","",313]
[513,null,null,"","",513]
[212,null,null,"","",212,null,null,null,"J’aimerais implémenter ces 3 pas ( conditions) dans une boucle  itérative de tell forme…If --- Else"]
[313,null,null,"","",313]
[513,null,null,"","",513]
[212,null,null,"","",212]
[313,null,null,"","",313]
[513,null,null,"","",513]
["000003-ROOSENDAAL",null,null,"000003","",""]
[34,null,null,"","",""]
[212,null,null,"",34,212]
[313,null,null,"","",313]
[513,null,null,"","",513]
[212,null,null,"","",212]
[313,null,null,"","",313]
[513,null,null,"","",513]
[212,null,null,"","",212]
[313,null,null,"","",313]
[513,null,null,"","",513]
[212,null,null,"","",212]
[313,null,null,"","",313]
[513,null,null,"","",513]
["¤",null,null,"","",""]
[null,null,null,"","¤",""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
["000004-SCHEPPINK",null,null,"000004",null,""]
[4,null,null,"","",""]
[212,null,null,"",4,212]
[713,null,null,"","",713]
[513,null,null,"","",513]
[212,null,null,"","",212]
[713,null,null,"","",713]
[513,null,null,"","",513]
[212,null,null,"","",212]
[713,null,null,"","",713]
[513,null,null,"","",513]
[212,null,null,"","",212]
[713,null,null,"","",713]
[513,null,null,"","",513]
["000004-SCHEPPINK",null,null,"000004","",""]
[34,null,null,"","",""]
[212,null,null,"",34,212]
[713,null,null,"","",713]
[513,null,null,"","",513]
[212,null,null,"","",212]
[713,null,null,"","",713]
[513,null,null,"","",513]
[212,null,null,"","",212]
[713,null,null,"","",713]
[513,null,null,"","",513]
[212,null,null,"","",212]
[713,null,null,"","",713]
[513,null,null,"","",513]
["000005-LEUR,M",null,null,"000005","",""]
[4,null,null,"","",""]
[200,null,null,"",4,200]
[200,null,null,"","",200]
[200,null,null,"","",200]
[200,null,null,"","",200]
["000005-LEUR,M",null,null,"000005","",""]
[34,null,null,"","",""]
[200,null,null,"",34,200]
[200,null,null,"","",200]
[200,null,null,"","",200]
[200,null,null,"","",200]
["¤",null,null,"","",""]
[null,null,null,"","¤",""]
[null,null,null,"",0,""]
[null,null,null,"",0,""]
[null,null,null,"",0,""]
[null,null,null,"",0,""]
[null,null,null,"",0,""]
[null,null,null,"",0,""]
[null,null,null,"",0,""]
["000008-MEIJER",null,null,"000008",0,""]
[4,null,null,"","",""]
[204,null,null,"",4,204]
[313,null,null,"","",313]
[513,null,null,"","",513]
[204,null,null,"","",204]
[313,null,null,"","",313]
[513,null,null,"","",513]
[204,null,null,"","",204]
[313,null,null,"","",313]
[513,null,null,"","",513]
["000008-MEIJER",null,null,"000008","",""]
[34,null,null,"","",""]
[204,null,null,"",34,204]
[313,null,null,"","",313]
[513,null,null,"","",513]
[204,null,null,"","",204]
[313,null,null,"","",313]
[513,null,null,"","",513]
[null,null,null,"","",""]

{"sheet":"Text Brut","index":1,"n_rows":117,"n_cols":1,"rows_kept":117,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
["CCB0402A ¤ Contract: 000016-Suiker Unie              Kat: 00 Peilmaand: 01    Boekjaar: 2013 Betaalwijze: 1  03-04-2013 Blad:      1"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["Polisnr.-02                   Stdnr Tarief                     Rend.krt    Kwant.krt Net-afkw/Rest.pr  Bruto-afkw/Rest.pr"]
["         Mut.code datum   Nw.kat contr                                    VVP.mutdatum"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["Polisnr.-naam                 Stdnr  Duur-OPT  Bast/Wt  Geb.dat1  Gsl1  Pens.dat Lft   Tot.premie     Eintr.verl      Totale DKx Ctr"]
["         Mut.code Datum Lft  Vorige-mutdat/Cd Cdaop/Wt  Geb.dat2  Gsl2  Prem.dat Lft  Tot.koopsom Cdkps Toesl.pr    Totale DKx+1"]
["     Tar I/U    Ber.pres.      Prestatie     Br.premie   Br.koopsom   VVP.mutdat  Net.VVP.mut          DKx          DKx+1"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["  000005-MEIJER G.R.            007        0  012/00   14-05-1915 M   01-05-1915 00           0,0              0            1.200-"]
["         41 08-03-2013  97-10  00-01-2007/03           28-01-1923 V              00           0,0            0,0            1.119-"]
["     303  U                        341,0           0,0            0          537          529          544            505"]
["     503  U                         68,0           0,0            0            0            0            0              0"]
["     303  U                        403,0                                     649          640          656            614"]
["     503  U                         80,0                                       0            0            0              0"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["                             Ber.Oud.pens.       Overl.rente         Kapitalen       Bruto premie  Eintr.verl.prod.           DKx"]
["                            Verz.Oud.pens.       Wezen-pens.          Toesl.pr      Bruto koopsom  Eintr.verl.overig        DKx+1"]
["Totaal kategorie-00:                   0,0             744,0-              0,0                0,0              0            1.200-"]
["                                       0,0             148,0-              0,0                0,0              0            1.119-"]
["Totaal contract    :                   0,0             744,0-              0,0                0,0              0            1.200-"]
["                                       0,0             148,0-              0,0                0,0              0            1.119-"]
["CCB0402A ¤ Contract: 000039-CBRE                     Kat: 00 Peilmaand: 01    Boekjaar: 2013 Betaalwijze: 1  03-04-2013 Blad:      2"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["Polisnr.-02                   Stdnr Tarief                     Rend.krt    Kwant.krt Net-afkw/Rest.pr  Bruto-afkw/Rest.pr"]
["         Mut.code datum   Nw.kat contr                                    VVP.mutdatum"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["Polisnr.-naam                 Stdnr  Duur-OPT  Bast/Wt  Geb.dat1  Gsl1  Pens.dat Lft   Tot.premie     Eintr.verl      Totale DKx Ctr"]
["         Mut.code Datum Lft  Vorige-mutdat/Cd Cdaop/Wt  Geb.dat2  Gsl2  Prem.dat Lft  Tot.koopsom Cdkps Toesl.pr    Totale DKx+1"]
["     Tar I/U    Ber.pres.      Prestatie     Br.premie   Br.koopsom   VVP.mutdat  Net.VVP.mut          DKx          DKx+1"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["  001006-BEEK-VISSER, J. V      009        0  001/00   25-08-1946 V   01-08-1946 00           0,0              0          235.945"]
["         13 01-04-2013  66-08                                     M              00           0,0            0,0          233.615"]
["     323  I                          0,0           0,0            0            0            0            0              0"]
["     323  I                     13.602,0                                 233.657      233.657      235.945        233.615"]
["  001006-BEEK-VISSER, J. V      008        0  001/00   25-08-1946 V   01-08-1946 00           0,0              0          235.948-"]
["         43 01-04-2013  66-08  00-04-2012/13                      M              00           0,0            0,0          226.814-"]
["     323  I                          0,0           0,0            0            0            0            0              0"]
["     323  I                     13.206,0                                 233.660      233.660      235.948        226.814"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["                             Ber.Oud.pens.       Overl.rente         Kapitalen       Bruto premie  Eintr.verl.prod.           DKx"]
["                            Verz.Oud.pens.       Wezen-pens.          Toesl.pr      Bruto koopsom  Eintr.verl.overig        DKx+1"]
["Totaal kategorie-00:                   0,0             396,0               0,0                0,0              0                3-"]
["                                       0,0               0,0               0,0                0,0              0            6.801"]
["Totaal contract    :                   0,0             396,0               0,0                0,0              0                3-"]
["                                       0,0               0,0               0,0                0,0              0            6.801"]
["CCB0402A ¤ Contract: 000064-SHV                      Kat: 00 Peilmaand: 01    Boekjaar: 2013 Betaalwijze: 1  03-04-2013 Blad:      3"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["Polisnr.-02                   Stdnr Tarief                     Rend.krt    Kwant.krt Net-afkw/Rest.pr  Bruto-afkw/Rest.pr"]
["         Mut.code datum   Nw.kat contr                                    VVP.mutdatum"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["Polisnr.-naam                 Stdnr  Duur-OPT  Bast/Wt  Geb.dat1  Gsl1  Pens.dat Lft   Tot.premie     Eintr.verl      Totale DKx Ctr"]
["         Mut.code Datum Lft  Vorige-mutdat/Cd Cdaop/Wt  Geb.dat2  Gsl2  Prem.dat Lft  Tot.koopsom Cdkps Toesl.pr    Totale DKx+1"]
["     Tar I/U    Ber.pres.      Prestatie     Br.premie   Br.koopsom   VVP.mutdat  Net.VVP.mut          DKx          DKx+1"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["  000053-TOBAC, A M L.          014        0  016/00   02-04-1946 M   01-04-1946 00           0,0              3           35.642  *"]
["         01 01-04-2013  67-00                          13-08-1946 V              00           0,0            0,0           35.213"]
["     242  I       2.019,0            0,0           0,0            0            0            0            0              0"]
["     323  U                          0,0           0,0            0            0            0            0              0"]
["     242  I                      2.019,0                                  26.106       26.106       26.394         26.018"]
["     323  U                      1.522,0                                   9.239        9.087        9.248          9.195"]
["  000053-TOBAC, A M L.          013        0  016/00   02-04-1946 M   01-04-1946 00           0,0              0           35.639-"]
["         31 01-04-2013  67-00  00-04-2012/01           13-08-1946 V              00           0,0            0,0           34.453-"]
["     242  I       1.960,0            0,0           0,0            0            0            0            0              0"]
["     323  U                          0,0           0,0            0            0            0            0              0"]
["     242  I                      1.960,0                                  26.103       26.103       26.391         25.258"]
["     323  U                      1.522,0                                   9.239        9.087        9.248          9.195"]
["  000072-VERBRUGGEN,E.          007        0  016/00   14-04-1947 M   01-04-1947 00           0,0              3-          22.977  *"]
["         01 01-04-2013  66-00                                     V              00           0,0            0,0           22.692"]
["     242  I       1.517,0            0,0           0,0            0            0            0            0              0"]
["     323  U                          0,0           0,0            0            0            0            0              0"]
["     242  I                      1.517,0                                  20.481       20.481       20.702         20.426"]
["     323  U                        373,0                                   2.274        2.235        2.275          2.266"]
["  000072-VERBRUGGEN,E.          006        0  016/00   14-04-1947 M   01-04-1947 00           0,0              0           22.980-"]
["         31 01-04-2013  66-00  00-04-2012/21                      V              00           0,0            0,0           22.100-"]
["     242  I       1.473,0            0,0           0,0            0            0            0            0              0"]
["     323  U                          0,0           0,0            0            0            0            0              0"]
["     242  I                      1.473,0                                  20.484       20.484       20.705         19.834"]
["     323  U                        373,0                                   2.274        2.235        2.275          2.266"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["                             Ber.Oud.pens.       Overl.rente         Kapitalen       Bruto premie  Eintr.verl.prod.           DKx"]
["                            Verz.Oud.pens.       Wezen-pens.          Toesl.pr      Bruto koopsom  Eintr.verl.overig        DKx+1"]
["Totaal kategorie-00:                 103,0               0,0               0,0                0,0              0                0"]
["                                     103,0               0,0               0,0                0,0              0            1.352"]
["Totaal contract    :                 103,0               0,0               0,0                0,0              0                0"]
["                                     103,0               0,0               0,0                0,0              0            1.352"]
["CCB0402A ¤ Contract: 000070-AGTERHOF (1,5%)          Kat: 00 Peilmaand: 01    Boekjaar: 2013 Betaalwijze: 1  03-04-2013 Blad:      4"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["Polisnr.-02                   Stdnr Tarief                     Rend.krt    Kwant.krt Net-afkw/Rest.pr  Bruto-afkw/Rest.pr"]
["         Mut.code datum   Nw.kat contr                                    VVP.mutdatum"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["Polisnr.-naam                 Stdnr  Duur-OPT  Bast/Wt  Geb.dat1  Gsl1  Pens.dat Lft   Tot.premie     Eintr.verl      Totale DKx Ctr"]
["         Mut.code Datum Lft  Vorige-mutdat/Cd Cdaop/Wt  Geb.dat2  Gsl2  Prem.dat Lft  Tot.koopsom Cdkps Toesl.pr    Totale DKx+1"]
["     Tar I/U    Ber.pres.      Prestatie     Br.premie   Br.koopsom   VVP.mutdat  Net.VVP.mut          DKx          DKx+1"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["  000027-POTTERS J.W.L.M.       008        0  001/00   01-03-1948 M   01-03-1948 00           0,0              0            1.649-"]
["         56 01-03-2013  65-00  00-03-2013/21           09-12-1948 V              00           0,0            0,0            1.616-"]
["     204  I          95,0            0,0           0,0            0            0            0            0              0"]
["     206  U         214,0            0,0           0,0            0            0            0            0              0"]
["     303  U                          0,0           0,0            0            0            0            0              0"]
["     503  U                          0,0           0,0            0            0            0            0              0"]
["     204  I                         95,0                                   1.063        1.063        1.069          1.034"]
["     206  U                        214,0                                     257          257          257            258"]
["     303  U                         67,0                                     324          316          323            324"]
["     503  U                         13,0                                       0            0            0              0"]
["------------------------------------------------------------------------------------------------------------------------------------"]
["                             Ber.Oud.pens.       Overl.rente         Kapitalen       Bruto premie  Eintr.verl.prod.           DKx"]
["                            Verz.Oud.pens.       Wezen-pens.          Toesl.pr      Bruto koopsom  Eintr.verl.overig        DKx+1"]
["Totaal kategorie-00:                 309,0-             67,0-              0,0                0,0              0            1.649-"]
["                                     309,0-             13,0-              0,0                0,0              0            1.616-"]
["Totaal contract    :                 309,0-             67,0-              0,0                0,0              0            1.649-"]
["                                     309,0-             13,0-              0,0                0,0              0            1.616-"]
["CCB0402A ¤ Contract: 000076-A.S VAN LEEUWEN          Kat: 00 Peilmaand: 01    Boekjaar: 2013 Betaalwijze: 1  03-04-2013 Blad:      5"]
["------------------------------------------------------------------------------------------------------------------------------------"]

{"sheet":"Blad3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}