{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","NOM","NIA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Data","index":0,"n_rows":1,"n_cols":61,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne29","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43","Colonne44","Colonne45","Colonne46","Colonne47","Colonne48","Colonne49","Colonne50","Colonne51","Colonne52","Colonne53","Colonne54","Colonne55","Colonne56","Colonne57","Colonne58","Colonne59","Colonne60","30/06/2017"]

{"sheet":"NOM","index":1,"n_rows":134,"n_cols":6,"rows_kept":134,"cut":false,"hidden":true,"merged":[]}
["Nom_Prenom"]
["jj/mm/aaaa"]
[]
[]
[]
[1,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D11=0,C13,D11)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D13","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]
[]
[2,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D24=0,C26,D24)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D26","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]
[]
[3,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D37=0,C39,D37)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D39","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]
[]
[4,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D50=0,C52,D50)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D52","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]
[]
[5,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D63=0,C65,D63)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D65","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]
[]
[6,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D76=0,C78,D76)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D78","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]
[]
[7,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D89=0,C91,D89)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D91","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]
[]
[8,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D102=0,C104,D102)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D104","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]
[]
[9,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D115=0,C117,D115)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D117","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]
[]
[10,null,"IDCP N","IDCP M","IDCP A","Cotisation"]
["NIA"]
["Nom Prénom",null,null,null,null,"Conjoint"]
["Date naissance"]
["Âge",null,"Décès TTC","Décès TTC","Décès Acc","Éducation"]
["Adresse 1"]
["Adresse 2",null,"Invalidité","Invalidité","Infirmité","Handicap"]
["Code Postal",null,null,{"$f":"IF(D128=0,C130,D128)","v":0}]
["Ville",null,"Décès Acc","Total","Total","Hôpital"]
["Statut",null,null,{"$f":"D130","v":0}]
["Salaire",null,"Infirmité"]
["Pension"]

{"sheet":"NIA","index":2,"n_rows":147,"n_cols":6,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
[]
["NIA"]
[]
[]
[]
["NOM",null,"A","B","C","Cotisation"]
["NIA",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,34,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,60,FALSE),\"\")","v":""}]
["Identité",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,33,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,19,FALSE),\"\")","v":""},"OPT1"]
["Date naissance",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,35,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,43,FALSE),\"\")","v":""}]
["Âge",{"$f":"IFERROR(DATEDIF(B$9,TODAY(),\"y\"),\"\")","v":""},"G1","G5","G7","OPT2"]
["Adresse 1",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,42,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,44,FALSE),\"\")","v":""}]
["Adresse 2",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,10,FALSE),\"\")","v":""},"G2","G6","G8","OPT3"]
["Code Postal",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,11,FALSE),\"\")","v":""},{"$f":"IF(C11=0,VLOOKUP(B6,Data!A2:BH158530,40),C11)","v":""},{"$f":"IF(D11=0,VLOOKUP(B6,Data!A2:BH158530,40),D11)","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,45,FALSE),\"\")","v":""}]
["Ville",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,12,FALSE),\"\")","v":""},"G3","Total","Total","OPT4"]
["Statut",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,38,FALSE),\"\")","v":""},{"$f":"D13","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,46,FALSE),\"\")","v":""}]
["Salaire",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,6,FALSE),\"\")","v":""},"G4",{"$f":"IFERROR(VLOOKUP(A1,Data!A2:BH158530,2,FALSE),\"\")","v":""}]
["Pension",{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Data!A2:BH158530,37,FALSE),\"\")","v":""}]
[]
[1,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal",null,null,{"$f":"IF(D24=0,C26,D24)","v":0}]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D24","v":0}]
["Salaire",null,"G4"]
["Pension"]
[]
[2,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal",null,null,{"$f":"IF(D37=0,C39,D37)","v":0}]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D37","v":0}]
["Salaire",null,"G4"]
["Pension"]
[]
[3,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal",null,null,{"$f":"IF(D50=0,C52,D50)","v":0}]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D50","v":0}]
["Salaire",null,"G4"]
["Pension"]
[]
[4,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal",null,null,{"$f":"IF(D63=0,C65,D63)","v":0}]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D63","v":0}]
["Salaire",null,"G4"]
["Pension"]
[]
[5,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal",null,null,{"$f":"IF(D76=0,C78,D76)","v":0}]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D76","v":0}]
["Salaire",null,"G4"]
["Pension"]
[]
[6,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal"]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D89","v":0}]
["Salaire",null,"G4"]
["Pension"]
[]
[7,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal"]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D102","v":0}]
["Salaire",null,"G4"]
["Pension"]
[]
[8,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal"]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D115","v":0}]
["Salaire",null,"G4"]
["Pension"]
[]
[9,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal"]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D128","v":0}]
["Salaire",null,"G4"]
["Pension"]
[]
[10,null,"A","B","C","Cotisation"]
["Nom+Prénom"]
["Identité",null,null,null,null,"OPT1"]
["Date naissance"]
["Âge",null,"G1","G5","G7","OPT2"]
["Adresse 1"]
["Adresse 2",null,"G2","G6","G8","OPT3"]
["Code Postal"]
["Ville",null,"G3","Total","Total","OPT4"]
["Statut",null,null,{"$f":"D141","v":0}]
["Salaire",null,"G4"]
["Pension"]