{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Masque de saisie","Recap","Données","Table délais","Macro-planning","Planning auditeurs","Macro-planning Auditeurs","Saisie budgétaire","Suivi budgétaire","staff","Code des CPAM","Table de prix_Lot1","Table de prix_Lot2"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":13,"comments":1,"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":"Masque de saisie","index":0,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,1,1,3],[45,1,47,3]]}
[]
[null,"            FICHE DE SUIVI D'AUDIT",null,null,{"$f":"TODAY()","v":"2016-05-20"}]
[]
[null,"PREVISIONNEL:"]
[null,"Libellé de l'audit:",null,"CPAM FLANDRES"]
[]
[null,"Type d'audit:",null,"Structure"]
[]
[null,"Nature de l'audit:",null,"Suivi"]
[]
[null,"Organisme:",null,"CPAM Flandres-Dunkerque-Armentières"]
[]
[null,"PNA:",null,"2016"]
[]
[null,"Période:",null,"1er semestre"]
[]
[null,"Responsable de mission:",null,"Jacqueline Perez"]
[]
[null,"Auditeurs:",null,"Alexandre LE CORRE"]
[null,null,null,"Joel MOSSARD"]
[null,null,null,"Oliviana PIAZZA"]
[null,null,null,""]
[]
[null,"Prestataire:",null,""]
[]
[null,"REALISATION DE L'AUDIT","Prévisionnel","Réalisé"]
[null,"Commande du Diagnostic préalable:",{"$f":"IF($C$32=\"\",\"\",$C$32-135*(($C$32-$C$44)/135))","v":"2016-02-01"},"",{"$f":"IF(D27=\"\",\"FAUX\",\"VRAI\")","v":"FAUX"}]
[null,"Formulation du bon de commande:",{"$f":"IF($C$32=\"\",\"\",$C$32-105*(($C$32-$C$44)/135))","v":"2016-03-02"},"",{"$f":"IF(D28=\"\",\"FAUX\",\"VRAI\")","v":"FAUX"}]
[null,"Remise du rapport provisoire:",{"$f":"IF($C$32=\"\",\"\",$C$32-45*(($C$32-$C$44)/135))","v":"2016-05-01"},"29/04/2016","VRAI"]
[null,"Validation Interne:",{"$f":"IF($C$32=\"\",\"\",$C$32-30*(($C$32-$C$44)/135))","v":"2016-05-16"},"","FAUX"]
[null,"Phase contradictoire:",{"$f":"IF($C$32=\"\",\"\",$C$32-15*(($C$32-$C$44)/135))","v":"2016-05-31"},"","FAUX"]
[null,"Rapport définitif:","15/06/2016","","FAUX"]
[null,"Diffusion à l'organisme:",{"$f":"IF(C27=\"\",\"\",C32+15)","v":"2016-06-30"},"","FAUX"]
[null,"Séminaire de restitution:",{"$f":"IF(C27=\"\",\"\",C33+15)","v":"2016-07-15"},"","FAUX"]
[null,"Projet de plan d'action:",null,"","FAUX"]
[null,"Plan d'action validé:",{"$f":"IF(C27=\"\",\"\",C35+30)","v":"1900-01-30"},"","FAUX"]
[]
[null,"SUIVI DES RECOMMANDATIONS:"]
[null,"Suivi SEM1:",{"$f":"IF(C27=\"\",\"\",C36+180)","v":"1900-07-28"},"",{"$f":"IF(D39=\"\",\"FAUX\",\"VRAI\")","v":"FAUX"}]
[null,"Suivi SEM2:",{"$f":"IF(C27=\"\",\"\",C39+180)","v":"1901-01-24"},"","FAUX"]
[null,"Suivi SEM3:",{"$f":"IF(C27=\"\",\"\",C40+180)","v":"1901-07-23"},"","FAUX"]
[null,"Suivi SEM4:",{"$f":"IF(C27=\"\",\"\",C41+180)","v":"1902-01-19"},"","FAUX"]
[]
[null,null,"01/02/2016"]
[null,"OBSERVATIONS:"]
[null,""]

{"sheet":"Recap","index":1,"n_rows":7,"n_cols":104,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,89,2,89],[0,0,0,10],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[0,11,0,40],[0,41,0,52],[1,41,1,43],[1,58,1,62],[1,11,1,13],[1,14,1,16],[1,20,1,22],[1,23,1,25],[1,26,1,28],[1,29,1,31],[1,32,1,34],[1,35,1,37],[1,38,1,40],[1,44,1,46],[1,47,1,49],[1,50,1,52],[1,17,1,19],[1,55,1,57]]}
["Descriptif",null,null,null,null,null,null,null,null,null,null,"Niveau d'avancement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suivi des recommandations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commentaires et Observations"]
["Dénomination de l'audit","Type d'audit","Nature de l'audit","Organisme audité","PNA","Période","Prestataire","Directeurs de Mission","Auditeurs","Date de début de mission","Date de fin de mission","Analyse préalable",null,null,"Formulation BdC",null,null,"Remise du rapport provisoire",null,null,"Validation Interne",null,null,"Contradictoire",null,null,"Rapport définitif",null,null,"Diffusion",null,null,"Seminaire de restitution",null,null,"Projet du plan d'action",null,null,"Validation du plan",null,null,"Suivi des reco - Semestre 1",null,null,"Suivi des reco - Semestre 2",null,null,"Suivi des reco - Semestre 3",null,null,"Suivi des reco - Semestre 4"]
[null,null,null,null,null,null,null,null,null,null,null,"Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart","Prévisionnel","Réel","Ecart"]
["Dénomination de l'audit","Type d'audit","Nature de l'audit","Organisme audité","PNA","Période","Prestataire","Directeurs de Mission","Auditeurs","Date de début de mission","Date de fin de mission","Prévisionnel","Réel","Ecart","Prévisionnel2","Réel2","Ecart2","Ecart23","Ecart22","Ecart3","Remise du rapport provisoire","Colonne4","Colonne3","Contradictoire","Colonne6","Colonne5","Rapport définitif","Colonne8","Colonne7","Diffusion","Colonne10","Colonne9","Seminaire de restitution","Colonne12","Colonne11","Projet du plan d'action","Colonne14","Colonne13","Validation du plan","Colonne16","Colonne15","Suivi des reco\nSemestre 1","Suivi des reco\nSemestre 13","Suivi des reco\nSemestre 12","Suivi des reco\nSemestre 2","Suivi des reco\nSemestre 23","Suivi des reco\nSemestre 22","Suivi des reco\nSemestre 3","Suivi des reco\nSemestre 33","Suivi des reco\nSemestre 32","Suivi des reco\nSemestre 4","Suivi des reco\nSemestre 42","Suivi des reco\nSemestre 5","N.SEMAINE","auditeur1","auditeur2","auditeur3","auditeur4","AP","BDC","Fin terrain","RP","C","RD","Diff","SEM","PPA","VP","Colonne1","Junior (<3)","Senior (3<5)","Manager (>5)","Nombre de défauts","M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","hebergement","nbj","nbpersonne","debut","fin","Observation","AP2","BDC3","R.PROV","VI","C6","RD7","Diff8","SEM9","PPA10","VP11","VP12","VP13","VP14","VP15"]
["a","a","a","a","a","a","a","a","a","2012-03-01","2012-07-01",{"$f":"Tableau5[Date de début de mission]","v":"2012-03-01"},"2012-03-03",{"$f":"IF(Tableau5[[#This Row],[Réel]]=\"\",\"\",Tableau5[[#This Row],[Réel]]-Tableau5[[#This Row],[Prévisionnel]])","v":2},{"$f":"ROUND(Tableau5[Rapport définitif]-105*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2012-03-28"},"2012-03-24",{"$f":"IF(Tableau5[[#This Row],[Réel2]]=\"\",\"\",Tableau5[[#This Row],[Réel2]]-Tableau5[[#This Row],[Prévisionnel2]])","v":-4},{"$f":"ROUND(Tableau5[Rapport définitif]-45*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2012-05-21"},"2012-05-23",{"$f":"IF(Tableau5[[#This Row],[Ecart22]]=\"\",\"\",Tableau5[[#This Row],[Ecart22]]-Tableau5[[#This Row],[Ecart23]])","v":2},{"$f":"ROUND(Tableau5[Rapport définitif]-30*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2012-06-04"},"2012-06-09",{"$f":"IF(Tableau5[[#This Row],[Colonne4]]=\"\",\"\",Tableau5[[#This Row],[Colonne4]]-Tableau5[[#This Row],[Remise du rapport provisoire]])","v":5},{"$f":"ROUND(Tableau5[Rapport définitif]-15*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2012-06-17"},"2012-06-14",{"$f":"IF(Tableau5[[#This Row],[Colonne6]]=\"\",\"\",Tableau5[[#This Row],[Colonne6]]-Tableau5[[#This Row],[Contradictoire]])","v":-3},{"$f":"Tableau5[Date de fin de mission]","v":"2012-07-01"},"2012-07-10",{"$f":"IF(Tableau5[[#This Row],[Colonne8]]=\"\",\"\",Tableau5[[#This Row],[Colonne8]]-Tableau5[[#This Row],[Rapport définitif]])","v":9},{"$f":"Tableau5[Rapport définitif]+15","v":"2012-07-16"},"2012-07-16",{"$f":"IF(Tableau5[[#This Row],[Colonne10]]=\"\",\"\",Tableau5[[#This Row],[Colonne10]]-Tableau5[[#This Row],[Diffusion]])","v":0},{"$f":"Tableau5[Diffusion]+15","v":"2012-07-31"},"2012-07-31",{"$f":"IF(Tableau5[[#This Row],[Colonne12]]=\"\",\"\",Tableau5[[#This Row],[Colonne12]]-Tableau5[[#This Row],[Seminaire de restitution]])","v":0},{"$f":"Tableau5[Seminaire de restitution]+60","v":"2012-09-29"},"2012-09-29",{"$f":"IF(Tableau5[[#This Row],[Colonne14]]=\"\",\"\",Tableau5[[#This Row],[Colonne14]]-Tableau5[[#This Row],[Projet du plan d''action]])","v":0},{"$f":"Tableau5[Projet du plan d''action]+30","v":"2012-10-29"},"2012-10-29",{"$f":"IF(Tableau5[[#This Row],[Colonne16]]=\"\",\"\",Tableau5[[#This Row],[Colonne16]]-Tableau5[[#This Row],[Validation du plan]])","v":0},{"$f":"Tableau5[Validation du plan]+180","v":"2013-04-27"},"2013-04-27",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 13]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 13]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 1]])","v":0},{"$f":"Tableau5[Suivi des reco\nSemestre 1]+180","v":"2013-10-24"},"2013-10-24",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 23]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 23]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 2]])","v":0},{"$f":"Tableau5[Suivi des reco\nSemestre 2]+180","v":"2014-04-22"},"2014-04-22",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 33]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 33]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 3]])","v":0},{"$f":"Tableau5[Suivi des reco\nSemestre 3]+180","v":"2014-10-19"},"2014-10-19",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 42]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 42]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 4]])","v":0},{"$f":"WEEKNUM(Tableau5[[#This Row],[Rapport définitif]])","v":27},null,null,null,null,{"$f":"WEEKNUM(Tableau5[[#This Row],[Réel]])","v":9},{"$f":"WEEKNUM(Tableau5[[#This Row],[Réel2]])","v":12},{"$f":"WEEKNUM(Tableau5[[#This Row],[Ecart22]])","v":21},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne4]])","v":23},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne6]])","v":24},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne8]])","v":28},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne10]])","v":29},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne12]])","v":31},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne14]])","v":39},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne16]])","v":44},{"$f":"IF(Tableau5[[#This Row],[Type d''audit]]=\"thématique\",CONCATENATE(Tableau5[[#This Row],[Type d''audit]],\" - \",Tableau5[[#This Row],[Dénomination de l''audit]],\" - \",Tableau5[PNA]),CONCATENATE(Tableau5[[#This Row],[Type d''audit]],\" - \",Tableau5[[#This Row],[Organisme audité]],\" - \",Tableau5[PNA]))","v":"a - a - a"},"a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a",{"$f":"Tableau5[[#This Row],[Date de début de mission]]","v":"2012-03-01"},{"$f":"Tableau5[[#This Row],[Date de fin de mission]]","v":"2012-07-01"},null,{"$f":"WEEKNUM(Tableau5[[#This Row],[Prévisionnel]])","v":9},{"$f":"WEEKNUM(Tableau5[[#This Row],[Prévisionnel2]])","v":13},{"$f":"WEEKNUM(Tableau5[[#This Row],[Ecart23]])","v":21},{"$f":"WEEKNUM(Tableau5[[#This Row],[Remise du rapport provisoire]])","v":23},{"$f":"WEEKNUM(Tableau5[[#This Row],[Contradictoire]])","v":25},{"$f":"WEEKNUM(Tableau5[[#This Row],[Rapport définitif]])","v":27},{"$f":"WEEKNUM(Tableau5[[#This Row],[Diffusion]])","v":29},{"$f":"WEEKNUM(Tableau5[[#This Row],[Seminaire de restitution]])","v":31},{"$f":"WEEKNUM(Tableau5[[#This Row],[Projet du plan d''action]])","v":39},{"$f":"WEEKNUM(Tableau5[[#This Row],[Validation du plan]])","v":44},{"$f":"IF(Tableau5[[#This Row],[auditeur1]]=\"\",\"\",Tableau5[[#This Row],[auditeur1]])","v":""},{"$f":"IF(Tableau5[[#This Row],[auditeur2]]=\"\",\"\",Tableau5[[#This Row],[auditeur2]])","v":""},{"$f":"IF(Tableau5[[#This Row],[auditeur3]]=\"\",\"\",Tableau5[[#This Row],[auditeur3]])","v":""},{"$f":"IF(Tableau5[[#This Row],[auditeur4]]=\"\",\"\",Tableau5[[#This Row],[auditeur4]])","v":""}]
["Audit Côte d'Or","Structure","Initial","CPAM Côte-d'Or","2016","1er semestre","Mazars","Externe","Corinne GALODE\nJoel MOSSARD\nOliviana PIAZZA\n","14/03/2016","27/07/2016",{"$f":"Tableau5[Date de début de mission]","v":"14/03/2016"},"14/03/2016",{"$f":"IF(Tableau5[[#This Row],[Réel]]=\"\",\"\",Tableau5[[#This Row],[Réel]]-Tableau5[[#This Row],[Prévisionnel]])","v":0},{"$f":"ROUND(Tableau5[Rapport définitif]-105*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2016-04-13"},"01/04/2016",{"$f":"IF(Tableau5[[#This Row],[Réel2]]=\"\",\"\",Tableau5[[#This Row],[Réel2]]-Tableau5[[#This Row],[Prévisionnel2]])","v":-12},{"$f":"ROUND(Tableau5[Rapport définitif]-45*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2016-06-12"},"02/05/2016",{"$f":"IF(Tableau5[[#This Row],[Ecart22]]=\"\",\"\",Tableau5[[#This Row],[Ecart22]]-Tableau5[[#This Row],[Ecart23]])","v":-41},{"$f":"ROUND(Tableau5[Rapport définitif]-30*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2016-06-27"},"11/05/2016",{"$f":"IF(Tableau5[[#This Row],[Colonne4]]=\"\",\"\",Tableau5[[#This Row],[Colonne4]]-Tableau5[[#This Row],[Remise du rapport provisoire]])","v":-47},{"$f":"ROUND(Tableau5[Rapport définitif]-15*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2016-07-12"},"13/05/2016",{"$f":"IF(Tableau5[[#This Row],[Colonne6]]=\"\",\"\",Tableau5[[#This Row],[Colonne6]]-Tableau5[[#This Row],[Contradictoire]])","v":-60},{"$f":"Tableau5[Date de fin de mission]","v":"27/07/2016"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne8]]=\"\",\"\",Tableau5[[#This Row],[Colonne8]]-Tableau5[[#This Row],[Rapport définitif]])","v":""},{"$f":"Tableau5[Rapport définitif]+15","v":"2016-08-11"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne10]]=\"\",\"\",Tableau5[[#This Row],[Colonne10]]-Tableau5[[#This Row],[Diffusion]])","v":""},{"$f":"Tableau5[Diffusion]+15","v":"2016-08-26"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne12]]=\"\",\"\",Tableau5[[#This Row],[Colonne12]]-Tableau5[[#This Row],[Seminaire de restitution]])","v":""},{"$f":"Tableau5[Seminaire de restitution]+60","v":"2016-10-25"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne14]]=\"\",\"\",Tableau5[[#This Row],[Colonne14]]-Tableau5[[#This Row],[Projet du plan d''action]])","v":""},{"$f":"Tableau5[Projet du plan d''action]+30","v":"2016-11-24"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne16]]=\"\",\"\",Tableau5[[#This Row],[Colonne16]]-Tableau5[[#This Row],[Validation du plan]])","v":""},{"$f":"Tableau5[Validation du plan]+180","v":"2017-05-23"},"",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 13]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 13]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 1]])","v":""},{"$f":"Tableau5[Suivi des reco\nSemestre 1]+180","v":"2017-11-19"},"",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 23]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 23]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 2]])","v":""},{"$f":"Tableau5[Suivi des reco\nSemestre 2]+180","v":"2018-05-18"},"",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 33]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 33]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 3]])","v":""},{"$f":"Tableau5[Suivi des reco\nSemestre 3]+180","v":"2018-11-14"},"",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 42]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 42]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 4]])","v":""},{"$f":"WEEKNUM(AA6)","v":31},"Corinne GALODE","Joel MOSSARD","Oliviana PIAZZA","",{"$f":"WEEKNUM(Tableau5[[#This Row],[Réel]])","v":12},{"$f":"WEEKNUM(Tableau5[[#This Row],[Réel2]])","v":14},{"$f":"WEEKNUM(Tableau5[[#This Row],[Ecart22]])","v":19},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne4]])","v":20},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne6]])","v":20},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne8]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne10]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne12]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne14]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne16]])","v":{"$error":"#VALUE!"}},{"$f":"IF(Tableau5[[#This Row],[Type d''audit]]=\"thématique\",CONCATENATE(Tableau5[[#This Row],[Type d''audit]],\" - \",Tableau5[[#This Row],[Dénomination de l''audit]],\" - \",Tableau5[PNA]),CONCATENATE(Tableau5[[#This Row],[Type d''audit]],\" - \",Tableau5[[#This Row],[Organisme audité]],\" - \",Tableau5[PNA]))","v":"Structure - CPAM Côte-d'Or - 2016"},"","","","",null,null,null,"","","","","","","","","","","",{"$f":"Tableau5[[#This Row],[Date de début de mission]]","v":"14/03/2016"},{"$f":"Tableau5[[#This Row],[Date de fin de mission]]","v":"27/07/2016"},"",{"$f":"WEEKNUM(Tableau5[[#This Row],[Prévisionnel]])","v":12},{"$f":"WEEKNUM(Tableau5[[#This Row],[Prévisionnel2]])","v":16},{"$f":"WEEKNUM(Tableau5[[#This Row],[Ecart23]])","v":25},{"$f":"WEEKNUM(Tableau5[[#This Row],[Remise du rapport provisoire]])","v":27},{"$f":"WEEKNUM(Tableau5[[#This Row],[Contradictoire]])","v":29},{"$f":"WEEKNUM(Tableau5[[#This Row],[Rapport définitif]])","v":31},{"$f":"WEEKNUM(Tableau5[[#This Row],[Diffusion]])","v":33},{"$f":"WEEKNUM(Tableau5[[#This Row],[Seminaire de restitution]])","v":35},{"$f":"WEEKNUM(Tableau5[[#This Row],[Projet du plan d''action]])","v":44},{"$f":"WEEKNUM(Tableau5[[#This Row],[Validation du plan]])","v":48},{"$f":"IF(Tableau5[[#This Row],[auditeur1]]=\"\",\"\",Tableau5[[#This Row],[auditeur1]])","v":"Corinne GALODE"},{"$f":"IF(Tableau5[[#This Row],[auditeur2]]=\"\",\"\",Tableau5[[#This Row],[auditeur2]])","v":"Joel MOSSARD"},{"$f":"IF(Tableau5[[#This Row],[auditeur3]]=\"\",\"\",Tableau5[[#This Row],[auditeur3]])","v":"Oliviana PIAZZA"},{"$f":"IF(Tableau5[[#This Row],[auditeur4]]=\"\",\"\",Tableau5[[#This Row],[auditeur4]])","v":""}]
["CPAM FLANDRES","Structure","Suivi","CPAM Flandres-Dunkerque-Armentières","2016","1er semestre","","Jacqueline Perez","Alexandre LE CORRE\nJoel MOSSARD\nOliviana PIAZZA\n","01/02/2016","15/06/2016",{"$f":"Tableau5[Date de début de mission]","v":"01/02/2016"},"",{"$f":"IF(Tableau5[[#This Row],[Réel]]=\"\",\"\",Tableau5[[#This Row],[Réel]]-Tableau5[[#This Row],[Prévisionnel]])","v":""},{"$f":"ROUND(Tableau5[Rapport définitif]-105*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2016-03-02"},"",{"$f":"IF(Tableau5[[#This Row],[Réel2]]=\"\",\"\",Tableau5[[#This Row],[Réel2]]-Tableau5[[#This Row],[Prévisionnel2]])","v":""},{"$f":"ROUND(Tableau5[Rapport définitif]-45*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2016-05-01"},"29/04/2016",{"$f":"IF(Tableau5[[#This Row],[Ecart22]]=\"\",\"\",Tableau5[[#This Row],[Ecart22]]-Tableau5[[#This Row],[Ecart23]])","v":-2},{"$f":"ROUND(Tableau5[Rapport définitif]-30*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2016-05-16"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne4]]=\"\",\"\",Tableau5[[#This Row],[Colonne4]]-Tableau5[[#This Row],[Remise du rapport provisoire]])","v":""},{"$f":"ROUND(Tableau5[Rapport définitif]-15*((Tableau5[Rapport définitif]-Tableau5[Prévisionnel])/135),0)","v":"2016-05-31"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne6]]=\"\",\"\",Tableau5[[#This Row],[Colonne6]]-Tableau5[[#This Row],[Contradictoire]])","v":""},{"$f":"Tableau5[Date de fin de mission]","v":"15/06/2016"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne8]]=\"\",\"\",Tableau5[[#This Row],[Colonne8]]-Tableau5[[#This Row],[Rapport définitif]])","v":""},{"$f":"Tableau5[Rapport définitif]+15","v":"2016-06-30"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne10]]=\"\",\"\",Tableau5[[#This Row],[Colonne10]]-Tableau5[[#This Row],[Diffusion]])","v":""},{"$f":"Tableau5[Diffusion]+15","v":"2016-07-15"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne12]]=\"\",\"\",Tableau5[[#This Row],[Colonne12]]-Tableau5[[#This Row],[Seminaire de restitution]])","v":""},{"$f":"Tableau5[Seminaire de restitution]+60","v":"2016-09-13"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne14]]=\"\",\"\",Tableau5[[#This Row],[Colonne14]]-Tableau5[[#This Row],[Projet du plan d''action]])","v":""},{"$f":"Tableau5[Projet du plan d''action]+30","v":"2016-10-13"},"",{"$f":"IF(Tableau5[[#This Row],[Colonne16]]=\"\",\"\",Tableau5[[#This Row],[Colonne16]]-Tableau5[[#This Row],[Validation du plan]])","v":""},{"$f":"Tableau5[Validation du plan]+180","v":"2017-04-11"},"",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 13]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 13]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 1]])","v":""},{"$f":"Tableau5[Suivi des reco\nSemestre 1]+180","v":"2017-10-08"},"",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 23]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 23]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 2]])","v":""},{"$f":"Tableau5[Suivi des reco\nSemestre 2]+180","v":"2018-04-06"},"",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 33]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 33]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 3]])","v":""},{"$f":"Tableau5[Suivi des reco\nSemestre 3]+180","v":"2018-10-03"},"",{"$f":"IF(Tableau5[[#This Row],[Suivi des reco\nSemestre 42]]=\"\",\"\",Tableau5[[#This Row],[Suivi des reco\nSemestre 42]]-Tableau5[[#This Row],[Suivi des reco\nSemestre 4]])","v":""},{"$f":"WEEKNUM(AA7)","v":25},"Alexandre LE CORRE","Joel MOSSARD","Oliviana PIAZZA","",{"$f":"WEEKNUM(Tableau5[[#This Row],[Réel]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Réel2]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Ecart22]])","v":18},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne4]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne6]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne8]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne10]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne12]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne14]])","v":{"$error":"#VALUE!"}},{"$f":"WEEKNUM(Tableau5[[#This Row],[Colonne16]])","v":{"$error":"#VALUE!"}},{"$f":"IF(Tableau5[[#This Row],[Type d''audit]]=\"thématique\",CONCATENATE(Tableau5[[#This Row],[Type d''audit]],\" - \",Tableau5[[#This Row],[Dénomination de l''audit]],\" - \",Tableau5[PNA]),CONCATENATE(Tableau5[[#This Row],[Type d''audit]],\" - \",Tableau5[[#This Row],[Organisme audité]],\" - \",Tableau5[PNA]))","v":"Structure - CPAM Flandres-Dunkerque-Armentières - 2016"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau5[[#This Row],[Date de début de mission]]","v":"01/02/2016"},{"$f":"Tableau5[[#This Row],[Date de fin de mission]]","v":"15/06/2016"},"",{"$f":"WEEKNUM(Tableau5[[#This Row],[Prévisionnel]])","v":6},{"$f":"WEEKNUM(Tableau5[[#This Row],[Prévisionnel2]])","v":10},{"$f":"WEEKNUM(Tableau5[[#This Row],[Ecart23]])","v":19},{"$f":"WEEKNUM(Tableau5[[#This Row],[Remise du rapport provisoire]])","v":21},{"$f":"WEEKNUM(Tableau5[[#This Row],[Contradictoire]])","v":23},{"$f":"WEEKNUM(Tableau5[[#This Row],[Rapport définitif]])","v":25},{"$f":"WEEKNUM(Tableau5[[#This Row],[Diffusion]])","v":27},{"$f":"WEEKNUM(Tableau5[[#This Row],[Seminaire de restitution]])","v":29},{"$f":"WEEKNUM(Tableau5[[#This Row],[Projet du plan d''action]])","v":38},{"$f":"WEEKNUM(Tableau5[[#This Row],[Validation du plan]])","v":42},{"$f":"IF(Tableau5[[#This Row],[auditeur1]]=\"\",\"\",Tableau5[[#This Row],[auditeur1]])","v":"Alexandre LE CORRE"},{"$f":"IF(Tableau5[[#This Row],[auditeur2]]=\"\",\"\",Tableau5[[#This Row],[auditeur2]])","v":"Joel MOSSARD"},{"$f":"IF(Tableau5[[#This Row],[auditeur3]]=\"\",\"\",Tableau5[[#This Row],[auditeur3]])","v":"Oliviana PIAZZA"},{"$f":"IF(Tableau5[[#This Row],[auditeur4]]=\"\",\"\",Tableau5[[#This Row],[auditeur4]])","v":""}]

{"sheet":"Données","index":2,"n_rows":165,"n_cols":5,"rows_kept":165,"cut":false,"hidden":true,"merged":[]}
["Alain PERROT",null,null,null,"Multiples organismes"]
["Alain SPAENLE",null,null,null,"CARSAT Alsace Moselle"]
["Alexandre LE CORRE",null,null,null,"CARSAT Aquitaine"]
["Arnaud MUDRY",null,null,null,"CARSAT Auvergne"]
["Corinne GALODE",null,null,null,"CARSAT Bourgogne Franche-Compté"]
["Joel MOSSARD",null,null,null,"CARSAT Bretagne"]
["Loic LE DEUNFF",null,null,null,"CARSAT Centre"]
["Mathias DIEZ",null,null,null,"CARSAT Centre-Ouest"]
["Oliviana PIAZZA",null,null,null,"CARSAT Languedoc Roussillon"]
["Patricia DAVANNE",null,null,null,"CARSAT Midi-Pyrénées"]
["Pierre Jean BONNOIT",null,null,null,"CARSAT Nord Est"]
["Said BOUNOUA",null,null,null,"CARSAT Nord Picardie"]
["Sylvie ZEILIG",null,null,null,"CARSAT Normandie"]
[null,null,null,null,"CARSAT Pays de la Loire"]
["Anne Sanchez",null,null,null,"CARSAT Rhône-Alpes"]
["Francine SCHERPEREEL",null,null,null,"CARSAT Sud-Est"]
["Jacqueline PEREZ",null,null,null,"CRAMIF"]
["Jean-Michel VALLET",null,null,null,"CCSS Lozère"]
["Externe",null,null,null,"CGSS Guadeloupe"]
[null,null,null,null,"CGSS Guyane"]
["Structure",null,null,null,"CGSS Martinique"]
["Thématique",null,null,null,"CGSS Réunion"]
[null,null,null,null,"CICOA"]
["BearingPoint",null,null,null,"CPAM  Charente-Maritime"]
["Eurogroup",null,null,null,"CPAM  Haute-Loire"]
["Grant Thornton",null,null,null,"CPAM Ain"]
["Interne",null,null,null,"CPAM Aisne"]
["Mazars",null,null,null,"CPAM Allier"]
[null,null,null,null,"CPAM Alpes-de-Haute-Provence"]
["1er semestre",null,null,null,"CPAM Alpes-Maritimes"]
["2eme semestre",null,null,null,"CPAM Ardèche"]
[null,null,null,null,"CPAM Ardennes"]
["Initial",null,null,null,"CPAM Ariège"]
["Suivi",null,null,null,"CPAM Artois"]
[null,null,null,null,"CPAM Aube"]
[null,null,null,null,"CPAM Aude"]
[null,null,null,null,"CPAM Aveyron"]
[null,null,null,null,"CPAM Bas-Rhin"]
[null,null,null,null,"CPAM Bayonne"]
[null,null,null,null,"CPAM Boûches-du-Rhône"]
[null,null,null,null,"CPAM Calvados"]
[null,null,null,null,"CPAM Cantal"]
[null,null,null,null,"CPAM Charente"]
[null,null,null,null,"CPAM Cher"]
[null,null,null,null,"CPAM Corrèze"]
[null,null,null,null,"CPAM Corse-du-sud"]
[null,null,null,null,"CPAM Côte d'Armor"]
[null,null,null,null,"CPAM Côte-d'Opale"]
[null,null,null,null,"CPAM Côte-d'Or"]
[null,null,null,null,"CPAM Creuse"]
[null,null,null,null,"CPAM Deux-Sèvres"]
[null,null,null,null,"CPAM Dordogne"]
[null,null,null,null,"CPAM Doubs"]
[null,null,null,null,"CPAM Drôme"]
[null,null,null,null,"CPAM Essonne"]
[null,null,null,null,"CPAM Eure"]
[null,null,null,null,"CPAM Eure-et-Loir"]
[null,null,null,null,"CPAM Finistère"]
[null,null,null,null,"CPAM Flandres-Dunkerque-Armentières"]
[null,null,null,null,"CPAM Gard"]
[null,null,null,null,"CPAM Gers"]
[null,null,null,null,"CPAM Gironde"]
[null,null,null,null,"CPAM Hainaut"]
[null,null,null,null,"CPAM Haute-Corse"]
[null,null,null,null,"CPAM Haute-Garonne"]
[null,null,null,null,"CPAM Haute-Marne"]
[null,null,null,null,"CPAM Hautes-Alpes"]
[null,null,null,null,"CPAM Haute-Saône"]
[null,null,null,null,"CPAM Haute-Savoie"]
[null,null,null,null,"CPAM Hautes-Pyrénées"]
[null,null,null,null,"CPAM Haute-Vienne"]
[null,null,null,null,"CPAM Haut-Rhin"]
[null,null,null,null,"CPAM Hauts-de-Seine"]
[null,null,null,null,"CPAM Hérault"]
[null,null,null,null,"CPAM Ille-et-Vilaine"]
[null,null,null,null,"CPAM Indre"]
[null,null,null,null,"CPAM Indre-et-Loire"]
[null,null,null,null,"CPAM Isère"]
[null,null,null,null,"CPAM Jura"]
[null,null,null,null,"CPAM Landes"]
[null,null,null,null,"CPAM Le Havre"]
[null,null,null,null,"CPAM Lille-Douai"]
[null,null,null,null,"CPAM Loire"]
[null,null,null,null,"CPAM Loire-Atlantique"]
[null,null,null,null,"CPAM Loiret"]
[null,null,null,null,"CPAM Loir-et-Cher"]
[null,null,null,null,"CPAM Lot"]
[null,null,null,null,"CPAM Lot-et-Garonne"]
[null,null,null,null,"CPAM Maine-et-Loir"]
[null,null,null,null,"CPAM Manche"]
[null,null,null,null,"CPAM Marne"]
[null,null,null,null,"CPAM Mayenne"]
[null,null,null,null,"CPAM Meurthe-et-Moselle"]
[null,null,null,null,"CPAM Meuse"]
[null,null,null,null,"CPAM Morbihan"]
[null,null,null,null,"CPAM Moselle"]
[null,null,null,null,"CPAM Nièvre"]
[null,null,null,null,"CPAM Oise"]
[null,null,null,null,"CPAM Orne"]
[null,null,null,null,"CPAM Paris"]
[null,null,null,null,"CPAM Pau"]
[null,null,null,null,"CPAM Puy-de-Dôme"]
[null,null,null,null,"CPAM Pyrénées-Orientales"]
[null,null,null,null,"CPAM Rhône"]
[null,null,null,null,"CPAM Roubaix-Tourcoing"]
[null,null,null,null,"CPAM Rouen-Elbeuf-Dieppe-Seine-Maritime"]
[null,null,null,null,"CPAM Saône-et-Loire"]
[null,null,null,null,"CPAM Sarthe"]
[null,null,null,null,"CPAM Savoie"]
[null,null,null,null,"CPAM Seine-et-Marne"]
[null,null,null,null,"CPAM Seine-Saint-Denis"]
[null,null,null,null,"CPAM Somme"]
[null,null,null,null,"CPAM Tarn"]
[null,null,null,null,"CPAM Tarn-et-Garonne"]
[null,null,null,null,"CPAM Territoire-de-Belfort"]
[null,null,null,null,"CPAM Val-de-Marne"]
[null,null,null,null,"CPAM Val-d'Oise"]
[null,null,null,null,"CPAM Var"]
[null,null,null,null,"CPAM Vaucluse"]
[null,null,null,null,"CPAM Vendée"]
[null,null,null,null,"CPAM Vienne"]
[null,null,null,null,"CPAM Vosges"]
[null,null,null,null,"CPAM Yonne"]
[null,null,null,null,"CPAM Yvelines"]
[null,null,null,null,"CSSM Mayotte"]
[null,null,null,null,"CTI Bretagne - Pays de Loire"]
[null,null,null,null,"CTI Grand Est"]
[null,null,null,null,"CTI PACAC"]
[null,null,null,null,"CTI Rhône Alpes Auvergne"]
[null,null,null,null,"CTI NP-NP"]
[null,null,null,null,"CTI Sud Toulouse"]
[null,null,null,null,"DRSM Alsace-Moselle"]
[null,null,null,null,"DRSM Aquitaine"]
[null,null,null,null,"DRSM Auvergne"]
[null,null,null,null,"DRSM Bourgogne-Franche-Comté"]
[null,null,null,null,"DRSM Bretagne"]
[null,null,null,null,"DRSM Centre"]
[null,null,null,null,"DRSM Centre-Ouest"]
[null,null,null,null,"DRSM Guadeloupe"]
[null,null,null,null,"DRSM Guyane"]
[null,null,null,null,"DRSM Ile de France"]
[null,null,null,null,"DRSM La Réunion"]
[null,null,null,null,"DRSM Languedoc-Rousillon"]
[null,null,null,null,"DRSM Martinique"]
[null,null,null,null,"DRSM Midi-Pyrénées"]
[null,null,null,null,"DRSM Nord-Est"]
[null,null,null,null,"DRSM Nord-Picardie"]
[null,null,null,null,"DRSM Normandie"]
[null,null,null,null,"DRSM Pays de Loire"]
[null,null,null,null,"DRSM Rhône-Alpes"]
[null,null,null,null,"DRSM Sud-Est-Corse"]
[null,null,null,null,"CESTIF"]
[null,null,null,null,"UGECAM Alsace"]
[null,null,null,null,"UGECAM Aquitaine"]
[null,null,null,null,"UGECAM Auvergne Limousin Poitou-Charente"]
[null,null,null,null,"UGECAM Bourgogne Franche-Compté"]
[null,null,null,null,"UGECAM Bretagne Pays de la Loire"]
[null,null,null,null,"UGECAM Centre"]
[null,null,null,null,"UGECAM Ile-de-France"]
[null,null,null,null,"UGECAM Languedoc-Roussillon Midi-Pyrénées"]
[null,null,null,null,"UGECAM Nord Pas-de-Calais Picardie"]
[null,null,null,null,"UGECAM Nord-Est"]
[null,null,null,null,"UGECAM Normandie"]
[null,null,null,null,"UGECAM PACA-Corse"]
[null,null,null,null,"UGECAM Rhône Alpes"]

{"sheet":"Table délais","index":3,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,12,0,14],[12,9,12,10],[0,3,0,5],[0,0,0,2],[0,6,0,8],[0,9,0,11]]}
["Audit initial de structure en externe",null,null,"Audit initial thématique en externe",null,null,"Audit initial thématique en interne",null,null,"Audit de suivi de structure en interne",null,null,"Audit de suivi thématique en interne"]
["Analyse préalable",30,4,"Analyse préalable",30,4,"Analyse préalable",30,4,"Analyse préalable",30,4,"Analyse préalable",30,4]
["Phase terrain",60,8,"Phase terrain",60,8,"Phase terrain",60,8,"Phase terrain",60,8,"Phase terrain",60,8]
["Rapport provisoire",15,2,"Rapport provisoire",15,2,"Rapport provisoire",15,2,"Rapport provisoire",15,2,"Rapport provisoire",15,2]
["Contradictoire",15,2,"Contradictoire",15,2,"Contradictoire",15,2,"Contradictoire",15,2,"Contradictoire",15,2]
["Rapport définitif",15,2,"Rapport définitif",15,2,"Rapport définitif",15,2,"Rapport définitif",15,2,"Rapport définitif",15,2]
["Diffusion",15,2,"Diffusion",15,2,"Diffusion",15,2,"Diffusion",15,2,"Diffusion",15,2]
["Seminaire de restitution",30,4,"Seminaire de restitution",30,4,"Seminaire de restitution",30,4,"Seminaire de restitution",30,4,"Seminaire de restitution",30,4]
["Projet du plan d'action",60,8,"Projet du plan d'action",60,8,"Projet du plan d'action",60,8,"Projet du plan d'action",60,8,"Projet du plan d'action",60,8]
["Validation du plan d'action",15,2,"Validation du plan d'action",15,2,"Validation du plan d'action",15,2,"Validation du plan d'action",15,2,"Validation du plan d'action",15,2]

{"sheet":"Macro-planning","index":4,"n_rows":47,"n_cols":121,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,104,1,107],[1,108,1,111],[1,112,1,116],[1,117,1,120],[0,11,2,11],[0,12,2,12],[0,14,2,14],[0,13,2,13],[0,5,2,5],[0,6,2,6],[0,8,2,8],[0,9,2,9],[0,10,2,10],[0,7,2,7],[0,93,0,95],[1,68,1,72],[1,73,1,76],[1,77,1,81],[1,82,1,85],[1,86,1,89],[1,90,1,94],[1,95,1,98],[1,99,1,103],[1,46,1,50],[0,0,3,0],[0,1,3,1],[0,2,3,2],[12,0,13,0],[8,0,9,0],[8,2,9,2],[10,0,11,0],[10,2,11,2],[8,1,9,1],[10,1,11,1],[12,1,13,1],[22,2,23,2],[4,1,5,1],[4,0,5,0],[4,2,5,2],[14,0,15,0],[14,2,15,2],[6,0,7,0],[6,2,7,2],[6,1,7,1],[12,2,13,2],[28,0,29,0],[28,2,29,2],[30,0,31,0],[30,2,31,2],[28,1,29,1],[30,1,31,1],[32,0,33,0],[32,2,33,2],[34,0,35,0],[34,2,35,2],[32,1,33,1],[34,1,35,1],[1,51,1,54],[1,55,1,58],[1,59,1,63],[1,64,1,67],[26,0,27,0],[26,2,27,2],[14,1,15,1],[26,1,27,1],[16,0,17,0],[16,1,17,1],[16,2,17,2],[18,0,19,0],[18,1,19,1],[18,2,19,2],[24,0,25,0],[24,1,25,1],[24,2,25,2],[0,4,3,4],[20,0,21,0],[20,1,21,1],[20,2,21,2],[22,0,23,0],[22,1,23,1],[0,3,3,3],[4,3,5,3],[6,3,7,3],[8,3,9,3],[10,3,11,3],[0,40,0,42],[1,15,1,19],[1,20,1,23],[1,24,1,28],[1,29,1,32],[1,33,1,36],[1,37,1,41],[1,42,1,45],[32,3,33,3],[34,3,35,3],[22,3,23,3],[24,3,25,3],[26,3,27,3],[28,3,29,3],[30,3,31,3],[12,3,13,3],[14,3,15,3],[16,3,17,3],[18,3,19,3],[20,3,21,3]]}
["Dénomination","Organisme","DM","PNA","fin mission","Analyse Préalable","BdC","Terrain","RP","Contradictoire","RD","Diff","Séminaire","plan d'action","validation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Année N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Année N+1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier",null,null,null,null,"février",null,null,null,"mars",null,null,null,null,"avril",null,null,null,"mai",null,null,null,"juin",null,null,null,null,"juillet",null,null,null,"août",null,null,null,null,"septembre",null,null,null,"octobre",null,null,null,"novembre",null,null,null,null,"décembre",null,null,null,"janvier",null,null,null,null,"février",null,null,null,"mars",null,null,null,null,"avril",null,null,null,"mai",null,null,null,"juin",null,null,null,null,"juillet",null,null,null,"août",null,null,null,null,"septembre",null,null,null,"octobre",null,null,null,"novembre",null,null,null,null,"décembre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106]
["a","a","a","a",{"$f":"Recap!BB5","v":27},{"$f":"Recap!CM5","v":9},{"$f":"Recap!CN5","v":13},{"$f":"Recap!CO5","v":21},{"$f":"Recap!CP5","v":23},{"$f":"Recap!CQ5","v":25},{"$f":"Recap!CR5","v":27},{"$f":"Recap!CS5","v":29},{"$f":"Recap!CT5","v":31},{"$f":"Recap!CU5","v":39},{"$f":"Recap!CV5","v":44}]
[null,null,null,null,null,{"$f":"Recap!BG5","v":9},{"$f":"Recap!BH5","v":12},{"$f":"Recap!BI5","v":21},{"$f":"Recap!BJ5","v":23},{"$f":"Recap!BK5","v":24},{"$f":"Recap!BL5","v":28},{"$f":"Recap!BM5","v":29},{"$f":"Recap!BN5","v":31},{"$f":"Recap!BO5","v":39},{"$f":"Recap!BP5","v":44}]
["Audit Côte d'Or","CPAM Côte-d'Or","Externe","2016",{"$f":"IF(ISNA(VLOOKUP(A7,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A7,Recap!A:BB,54,FALSE))","v":31},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CM,91,FALSE))","v":12},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CN,92,FALSE))","v":16},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CO,93,FALSE))","v":25},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CP,94,FALSE))","v":27},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CQ,95,FALSE))","v":29},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CR,96,FALSE))","v":31},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CS,97,FALSE))","v":33},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CT,98,FALSE))","v":35},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CU,99,FALSE))","v":44},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A7,Recap!$A:CV,100,FALSE))","v":48}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BG,59,FALSE))","v":12},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BH,60,FALSE))","v":14},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BI,61,FALSE))","v":19},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BJ,62,FALSE))","v":20},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BK,63,FALSE))","v":20},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BL,64,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BM,65,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BN,66,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BO,67,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A7,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A7,Recap!$A:BP,68,FALSE))","v":{"$error":"#VALUE!"}}]
["CPAM FLANDRES","CPAM Flandres-Dunkerque-Armentières","Jacqueline Perez","2016",{"$f":"IF(ISNA(VLOOKUP(A9,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A9,Recap!A:BB,54,FALSE))","v":25},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CM,91,FALSE))","v":6},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CN,92,FALSE))","v":10},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CO,93,FALSE))","v":19},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CP,94,FALSE))","v":21},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CQ,95,FALSE))","v":23},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CR,96,FALSE))","v":25},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CS,97,FALSE))","v":27},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CT,98,FALSE))","v":29},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CU,99,FALSE))","v":38},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A9,Recap!$A:CV,100,FALSE))","v":42}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BG,59,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BH,60,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BI,61,FALSE))","v":18},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BJ,62,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BK,63,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BL,64,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BM,65,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BN,66,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BO,67,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNA(VLOOKUP($A9,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A9,Recap!$A:BP,68,FALSE))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A11,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A11,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A11,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A11,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A11,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A13,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A13,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A13,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A13,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A13,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A15,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A15,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A15,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A15,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A15,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,"",null,{"$f":"IF(ISNA(VLOOKUP(A17,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A17,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A17,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A17,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A17,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,"",null,{"$f":"IF(ISNA(VLOOKUP(A19,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A19,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A19,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A19,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A19,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A21,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A21,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A21,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A21,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A21,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A23,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A23,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A23,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A23,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A23,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A25,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A25,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A25,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A25,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A25,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A27,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A27,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A27,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A27,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A27,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A29,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A29,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A29,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A29,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A29,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A31,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A31,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A31,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A31,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A31,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A33,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A33,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A33,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A33,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A33,Recap!$A:BP,68,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A35,Recap!A:BB,54,FALSE)),\"\",VLOOKUP(A35,Recap!A:BB,54,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CM,91,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CM,91,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CN,92,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CN,92,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CO,93,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CO,93,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CP,94,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CP,94,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CQ,95,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CQ,95,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CR,96,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CR,96,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CS,97,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CS,97,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CT,98,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CT,98,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CU,99,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CU,99,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:CV,100,FALSE)),\"\",VLOOKUP($A35,Recap!$A:CV,100,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BG,59,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BG,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BH,60,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BH,60,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BI,61,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BI,61,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BJ,62,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BJ,62,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BK,63,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BK,63,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BL,64,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BL,64,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BM,65,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BM,65,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BN,66,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BN,66,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BO,67,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BO,67,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($A35,Recap!$A:BP,68,FALSE)),\"\",VLOOKUP($A35,Recap!$A:BP,68,FALSE))","v":""}]
[]
[]
[null,null,"Analyse préalable"]
[null,null,"Phase terrain"]
[null,null,"Validation Interne"]
[null,null,"Contradictoire"]
[null,null,"Rapport définitif"]
[null,null,"Diffusion"]
[null,null,"Seminaire de restitution"]
[null,null,"Projet du plan d'action"]
[null,null,"Validation du plan d'action"]

{"sheet":"Planning auditeurs","index":5,"n_rows":70,"n_cols":29,"rows_kept":70,"cut":false,"hidden":true,"merged":[[64,15,64,16],[64,13,64,14],[64,11,64,12],[64,9,64,10],[64,1,64,2],[64,3,64,4],[64,5,64,6],[64,7,64,8],[64,17,64,18],[64,27,64,28],[64,25,64,26],[64,23,64,24],[64,21,64,22],[64,19,64,20],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[0,21,0,22],[0,23,0,24],[0,25,0,26],[0,27,0,28],[0,11,0,12],[0,13,0,14],[0,15,0,16],[0,17,0,18],[0,19,0,20]]}
[null,"Alain PERROT",null,"Alain SPAENLE",null,"Alexandre LE CORRE",null,"Arnaud MUDRY",null,"Corinne GALODE",null,"Joel MOSSARD",null,"Loic LE DEUNFF",null,"Mathias DIEZ",null,"Oliviana PIAZZA",null,"Patricia DAVANNE",null,"Pierre Jean BONNOIT",null,"Said BOUNOUA",null,"Sylvie ZEILIG",null,"Teddy FEUILLASTRE"]
[null,"Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin"]
["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"]
[{"$f":"IF(A68=\"\",\"\",A68)","v":"a - a - a"},{"$f":"IF(B68=\"\",\"\",WEEKNUM(B68))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(R68=\"\",\"\",WEEKNUM(R68))","v":""},"","","","","","","","","","",""]
["Structure - CPAM Côte-d'Or - 2016",{"$f":"IF(B69=\"\",\"\",WEEKNUM(B69))","v":""},"","","","","","","",12,31,12,31,"","","","",12,31,"","","","","","","","","",""]
["Structure - CPAM Flandres-Dunkerque-Armentières - 2016",{"$f":"IF(B70=\"\",\"\",WEEKNUM(B70))","v":""},"","","",6,25,"","","","",6,25,"","","","",6,25,"","","","","","","","","",""]
["",{"$f":"IF(B71=\"\",\"\",WEEKNUM(B71))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B72=\"\",\"\",WEEKNUM(B72))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B73=\"\",\"\",WEEKNUM(B73))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B74=\"\",\"\",WEEKNUM(B74))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B75=\"\",\"\",WEEKNUM(B75))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B76=\"\",\"\",WEEKNUM(B76))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B77=\"\",\"\",WEEKNUM(B77))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B78=\"\",\"\",WEEKNUM(B78))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B79=\"\",\"\",WEEKNUM(B79))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B80=\"\",\"\",WEEKNUM(B80))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B81=\"\",\"\",WEEKNUM(B81))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B82=\"\",\"\",WEEKNUM(B82))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B83=\"\",\"\",WEEKNUM(B83))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B84=\"\",\"\",WEEKNUM(B84))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B85=\"\",\"\",WEEKNUM(B85))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B86=\"\",\"\",WEEKNUM(B86))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B87=\"\",\"\",WEEKNUM(B87))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B88=\"\",\"\",WEEKNUM(B88))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B89=\"\",\"\",WEEKNUM(B89))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B90=\"\",\"\",WEEKNUM(B90))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B91=\"\",\"\",WEEKNUM(B91))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B92=\"\",\"\",WEEKNUM(B92))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B93=\"\",\"\",WEEKNUM(B93))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B94=\"\",\"\",WEEKNUM(B94))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B95=\"\",\"\",WEEKNUM(B95))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B96=\"\",\"\",WEEKNUM(B96))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B97=\"\",\"\",WEEKNUM(B97))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B98=\"\",\"\",WEEKNUM(B98))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B99=\"\",\"\",WEEKNUM(B99))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(A100=\"\",\"\",A100)","v":""},{"$f":"IF(B100=\"\",\"\",WEEKNUM(B100))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B101=\"\",\"\",WEEKNUM(B101))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B102=\"\",\"\",WEEKNUM(B102))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B103=\"\",\"\",WEEKNUM(B103))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B104=\"\",\"\",WEEKNUM(B104))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B105=\"\",\"\",WEEKNUM(B105))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B106=\"\",\"\",WEEKNUM(B106))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B107=\"\",\"\",WEEKNUM(B107))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B108=\"\",\"\",WEEKNUM(B108))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B109=\"\",\"\",WEEKNUM(B109))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B110=\"\",\"\",WEEKNUM(B110))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B111=\"\",\"\",WEEKNUM(B111))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B112=\"\",\"\",WEEKNUM(B112))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B113=\"\",\"\",WEEKNUM(B113))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B114=\"\",\"\",WEEKNUM(B114))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B115=\"\",\"\",WEEKNUM(B115))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B116=\"\",\"\",WEEKNUM(B116))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B117=\"\",\"\",WEEKNUM(B117))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B118=\"\",\"\",WEEKNUM(B118))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B119=\"\",\"\",WEEKNUM(B119))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B120=\"\",\"\",WEEKNUM(B120))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B121=\"\",\"\",WEEKNUM(B121))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B122=\"\",\"\",WEEKNUM(B122))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B123=\"\",\"\",WEEKNUM(B123))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B124=\"\",\"\",WEEKNUM(B124))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B125=\"\",\"\",WEEKNUM(B125))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B126=\"\",\"\",WEEKNUM(B126))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B127=\"\",\"\",WEEKNUM(B127))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(B128=\"\",\"\",WEEKNUM(B128))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Alain PERROT",null,"Alain SPAENLE",null,"Alexandre LE CORRE",null,"Arnaud MUDRY",null,"Corinne GALODE",null,"Joel MOSSARD",null,"Loic LE DEUNFF",null,"Mathias DIEZ",null,"Oliviana PIAZZA",null,"Patricia DAVANNE",null,"Pierre Jean BONNOIT",null,"Said BOUNOUA",null,"Sylvie ZEILIG",null,"Teddy FEUILLASTRE"]
[null,"Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin","Début","Fin"]
["Colonne29","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"]
["a - a - a",{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""}]
["Structure - CPAM Côte-d'Or - 2016",{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":"14/03/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":"27/07/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":"14/03/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":"27/07/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":"14/03/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":"27/07/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""}]
["Structure - CPAM Flandres-Dunkerque-Armentières - 2016",{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=B$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=D$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":"01/02/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=F$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":"15/06/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=H$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=J$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":"01/02/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=L$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":"15/06/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=N$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=P$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":"01/02/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=R$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":"15/06/2016"},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=T$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=V$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=X$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=Z$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,20),\"\"))))","v":""},{"$f":"IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,33)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,34)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,35)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),IF(VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,36)=AB$65,VLOOKUP(Tableau4[[#This Row],[Colonne29]],table,21),\"\"))))","v":""}]

{"sheet":"Macro-planning Auditeurs","index":6,"n_rows":17,"n_cols":54,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,50,0,53],[0,1,0,5],[0,6,0,9],[0,10,0,14],[0,15,0,18],[0,19,0,22],[0,23,0,27],[0,28,0,31],[0,32,0,36],[0,37,0,40],[0,41,0,44],[0,45,0,49]]}
[null,"janvier",null,null,null,null,"février",null,null,null,"mars",null,null,null,null,"avril",null,null,null,"mai",null,null,null,"juin",null,null,null,null,"juillet",null,null,null,"août",null,null,null,null,"septembre",null,null,null,"octobre",null,null,null,"novembre",null,null,null,null,"décembre"]
[null,"S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4","S1","S2","S3","S4","S1","S2","S3","S4","S5","S1","S2","S3","S4"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53]
["Alain PERROT"]
["Alain SPAENLE"]
["Alexandre LE CORRE"]
["Arnaud MUDRY"]
["Corinne GALODE"]
["Joel MOSSARD"]
["Loic LE DEUNFF"]
["Mathias DIEZ"]
["Oliviana PIAZZA"]
["Patricia DAVANNE"]
["Pierre Jean BONNOIT"]
["Said BOUNOUA"]
["Sylvie ZEILIG"]
["Teddy FEUILLASTRE"]

{"sheet":"Saisie budgétaire","index":7,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHE DE SUIVI BUDGETAIRE"]
[]
[null,"Audit:",null,"Structure - CPAM Côte-d'Or - 2016"]
[]
[null,"Nom de l'organisme:",null,"CPAM Côte-d'Or"]
[]
[null,"Catégorie de l'organisme:",{"$f":"IF(D8=\"\",\"\",IF(D8=\"CTI Prestations\",\"TableCTIPrestations\",IF(D8=\"CTI Missions Nationales\",\"TableCTIMissionsNationales\",IF(D8=\"CTI Centres Nationaux\",\"TableCTICentreNationaux\",CONCATENATE(\"Table\",D8)))))","v":"Table3"},{"$f":"IF(D6=\"\",\"\",IF(ISNA(VLOOKUP(D6,'Code des CPAM'!$A$1:$C$164,3,FALSE)),\"\",VLOOKUP(D6,'Code des CPAM'!$A$1:$C$164,3,FALSE)))","v":3}]
[]
[null,"Prestataire:",null,"Mazars"]
[]
["Choix des modules:",null,"Modules","Montant"]
[]
[null,"Module 1","",{"$f":"IF(C14=\"\",0,IF(C14=\"Non audité\",0,VLOOKUP(F14,INDIRECT($C$8),4,FALSE)))","v":0},null,{"$f":"CONCATENATE(B14,C14)","v":"Module 1"}]
[null,null,null,null,null,{"$f":"CONCATENATE(B15,C15)","v":""}]
[null,"Module 2","",{"$f":"IF(C16=\"\",0,IF(C16=\"Non audité\",0,VLOOKUP(F16,INDIRECT($C$8),4,FALSE)))","v":0},null,"Module 2"]
[null,null,null,null,null,""]
[null,"Module 3","",{"$f":"IF(C18=\"\",0,IF(C18=\"Non audité\",0,VLOOKUP(F18,INDIRECT($C$8),4,FALSE)))","v":0},null,"Module 3"]
[null,null,null,null,null,""]
[null,"Module 4","",{"$f":"IF(C20=\"\",0,IF(C20=\"Non audité\",0,VLOOKUP(F20,INDIRECT($C$8),4,FALSE)))","v":0},null,"Module 4"]
[null,null,null,null,null,""]
[null,null,"",{"$f":"IF(C22=\"\",0,IF(C22=\"Non audité\",0,VLOOKUP(F22,INDIRECT($C$8),4,FALSE)))","v":0},null,""]
[null,null,null,null,null,""]
[null,"Module 6","",{"$f":"IF(C24=\"\",0,IF(C24=\"Non audité\",0,VLOOKUP(F24,INDIRECT($C$8),4,FALSE)))","v":0},null,"Module 6"]
[null,null,null,null,null,""]
[null,"Module 7","",{"$f":"IF(C26=\"\",0,IF(C26=\"Non audité\",0,VLOOKUP(F26,INDIRECT($C$8),4,FALSE)))","v":0},null,"Module 7"]
[null,null,null,null,null,""]
[null,"Module 8","",{"$f":"IF(C28=\"\",0,IF(C28=\"Non audité\",0,VLOOKUP(F28,INDIRECT($C$8),4,FALSE)))","v":0},null,"Module 8"]
[null,null,null,null,null,""]
[null,"Module 9","",{"$f":"IF(C30=\"\",0,IF(C30=\"Non audité\",0,VLOOKUP(F30,INDIRECT($C$8),4,FALSE)))","v":0},null,"Module 9"]
[null,null,null,null,null,""]
[null,"Module 10","",{"$f":"IF(C32=\"\",0,IF(C32=\"Non audité\",0,VLOOKUP(F32,INDIRECT($C$8),4,FALSE)))","v":0},null,"Module 10"]
[null,null,null,null,null,""]
[null,"Module 11","",{"$f":"IF(C34=\"\",0,IF(C34=\"Non audité\",0,VLOOKUP(F34,INDIRECT($C$8),4,FALSE)))","v":0},null,"Module 11"]
[]
[null,"Total:",null,{"$f":"SUM(D14:D34)","v":0}]
[]
[null,"Frais de mission:",null,{"$f":"IF(C38=\"\",0,IF(LEFT(D8,3)=\"CTI\",IF(C39=\"Oui\",'Table de prix_Lot2'!F53*'Saisie budgétaire'!C38,'Table de prix_Lot2'!F54*'Saisie budgétaire'!C38),IF(VLOOKUP(D6,'Code des CPAM'!A1:D164,4,FALSE)=\"HM\",C38*'Table de prix_Lot1'!F119,IF(C39=\"Oui\",IF(VLOOKUP(D6,'Code des CPAM'!A1:D164,4,FALSE)=\"M\",C38*'Table de prix_Lot1'!F112),C38*'Table de prix_Lot1'!F113))))","v":0}]
[null,null,""]
[null,"Frais de transport:",null,{"$f":"IF(C40=\"\",0,IF(LEFT(D8,3)=\"CTI\",IF(VLOOKUP(D6,'Code des CPAM'!A1:D164,4,FALSE)=\"M\",C40*'Table de prix_Lot2'!F56,C40*'Table de prix_Lot2'!F55),IF(VLOOKUP(D6,'Code des CPAM'!A1:D164,4,FALSE)=\"IDF\",0,IF(VLOOKUP(D6,'Code des CPAM'!A1:D164,4,FALSE)=\"M\",'Saisie budgétaire'!C40*'Table de prix_Lot1'!F115,'Saisie budgétaire'!C40*'Table de prix_Lot1'!F120))))","v":0}]
[]
[null,"Total engagé:",null,{"$f":"D40+D38+D36","v":0}]

{"sheet":"Suivi budgétaire","index":8,"n_rows":5,"n_cols":57,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,10,0,13],[0,37,0,42],[0,14,0,18],[0,26,0,32],[0,33,0,35],[0,20,0,25]]}
[null,null,null,null,null,null,null,null,null,null,"Analyse du retard sur la phase terrain de l'audit",null,null,null,"Validation rapport provisoire",null,null,null,null,null,"Validation interne",null,null,null,null,null,"Diffusion raport",null,null,null,null,null,null,"Analyse des équipes d'audit",null,null,"Analyse de la qualité","Analyse des pénalités"]
["Audit","Organisme","Classe","Consultant","Montant BC TTC (ENGAGES)","Montant réel TTC","Date d'envoi de la lettre de mission","Envoi lettre de mission réel","Date envoi Bon de Commande","Envoi bon de commande réel","Date phase terrain","Date terrain réelle","Durée terrain théorique","Durée terrain réel","Date de réception ","Date réception réelle","Date envoi du rapport validé au prestataire","Date validation réelle interne","Date d'envoi du rapport modifié à l'organisme par le prestataire","Date réelle d'envoi aux organismes","Date de réception rapport définitif ","Date réelle de réception du RD","Date de transmission FG","Transmission réelle à FG","Retour \nFG/PF","Retour réel","Date transmission DG","Transmission DG réelle","Date de diffusion rapport définitif","Date de diffusion réelle","Date du séminaire","Date réelle du seminaire","Délai mission total","Junior (<3)","Senior (3<5)","Manager (>5)","Nombre de défauts","Pénalité sur composition des équipes d'audit","Pénalité de retard dans le commencement de l'audit","Pénalité sur la durée d'audit","Pénalité sur la qualité du rapport","synthèse","Pénalité max applicable","M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","hebergement","nbj","nbpersonne"]
[null,null,{"$f":"IF(Tableau2[Organisme]=\"\",\"\",IF(Tableau2[Organisme]=\"Multiples\",\"\",VLOOKUP(Tableau2[Organisme],'Code des CPAM'!$A$1:$C$164,3)))","v":""},null,null,{"$f":"IF(Tableau2[Pénalité max applicable]=\"\",\"\",Tableau2[Montant BC TTC (ENGAGES)]-Tableau2[Pénalité max applicable])","v":""},null,null,null,{"$f":"IF(Tableau2[Date envoi Bon de Commande]=\"\",\"\",(IF(((TODAY()-Tableau2[Date envoi Bon de Commande])>5),\"Oui\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[Date d''envoi de la lettre de mission]=\"\",\"\",IF(Tableau2[[Date de réception rapport définitif ]]=\"\",TODAY()-Tableau2[Date d''envoi de la lettre de mission],Tableau2[[Date de réception rapport définitif ]]-Tableau2[Date d''envoi de la lettre de mission]))","v":""},null,null,null,null,{"$f":"IF(AND(Tableau2[Junior (<3)]=\"\",Tableau2[Senior (3<5)]=\"\",Tableau2[Manager (>5)]=\"\"),0,(IF(OR(Tableau2[Junior (<3)]>(0.2*SUM(Tableau2[Junior (<3)]:Tableau2[Manager (>5)])),SUM(Tableau2[Senior (3<5)]:Tableau2[Manager (>5)])<3,Tableau2[Manager (>5)]<SUM(Tableau2[Junior (<3)]:Tableau2[Manager (>5)])*0.3),0.25*Tableau2[Montant BC TTC (ENGAGES)],0)))","v":0},{"$f":"IF(Tableau2[[#This Row],[Envoi bon de commande réel]]=\"\",0,IF(Tableau2[[#This Row],[Date terrain réelle]]>(Tableau2[[#This Row],[Envoi bon de commande réel]]+15),(Tableau2[[#This Row],[Date terrain réelle]]-(Tableau2[[#This Row],[Envoi bon de commande réel]]+15)*1000),0))","v":0},{"$f":"IF(Tableau2[Durée terrain théorique]=\"\",0,IF(Tableau2[Durée terrain réel]<Tableau2[Durée terrain théorique],(Tableau2[Montant BC TTC (ENGAGES)]*(Tableau2[Durée terrain théorique]-Tableau2[Durée terrain réel])/Tableau2[Durée terrain théorique]),0))","v":0},{"$f":"IF(Tableau2[Nombre de défauts]=\"\",0,Tableau2[Nombre de défauts]*350)","v":0},{"$f":"IF(AND(Tableau2[Pénalité sur composition des équipes d''audit]=\"\",Tableau2[Pénalité de retard dans le commencement de l''audit]=\"\",Tableau2[Pénalité sur la durée d''audit]=\"\",Tableau2[Pénalité sur la qualité du rapport]=\"\"),0,IF((Tableau2[Pénalité de retard dans le commencement de l''audit]+Tableau2[Pénalité sur la durée d''audit]+Tableau2[Pénalité sur composition des équipes d''audit]+Tableau2[Pénalité sur la qualité du rapport])>0.3*Tableau2[Montant BC TTC (ENGAGES)],0.3*Tableau2[Montant BC TTC (ENGAGES)],Tableau2[Pénalité de retard dans le commencement de l''audit]+Tableau2[Pénalité sur la durée d''audit]+Tableau2[Pénalité sur composition des équipes d''audit]+Tableau2[Pénalité sur la qualité du rapport]))","v":0},{"$f":"IF(Tableau2[synthèse]=0,\"\",Tableau2[synthèse])","v":""}]
[]
["","",null,"",null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","",null,null,null,null,null,null,"","","","","","","","","","","","","",""]

{"sheet":"staff","index":9,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["staff","DM","Prestataire"]
["Alain PERROT","Anne Sanchez","Interne"]
["Alain SPAENLE","Francine Scherpereel","BearingPoint"]
["Alexandre LE CORRE","Jacqueline Perez","Eurogroup"]
["Arnaud MUDRY","Jean-Michel Vallet","Grant Thornton"]
["Corinne GALODE","Externe","Mazars"]
["Joel MOSSARD"]
["Loic LE DEUNFF"]
["Mathias DIEZ"]
["Oliviana PIAZZA"]
["Patricia DAVANNE"]
["Pierre Jean BONNOIT"]
["Said BOUNOUA"]
["Sylvie ZEILIG"]
["Teddy FEUILLASTRE"]

{"sheet":"Code des CPAM","index":10,"n_rows":164,"n_cols":6,"rows_kept":164,"cut":false,"hidden":true,"merged":[]}
["CCSS Lozère","C",{"$f":"IF(B1=\"A\",1,IF(B1=\"B\",2,3))","v":3},"M"]
["CGSS Guadeloupe","B",{"$f":"IF(B2=\"A\",1,IF(B2=\"B\",2,3))","v":2},"HM"]
["CGSS Guyane","B",2,"HM"]
["CGSS Martinique","B",2,"HM"]
["CGSS Réunion","B",2,"HM"]
["CPAM Charente-Maritime","B",2,"M"]
["CPAM Haute-Loire","D",3,"M"]
["CPAM Ain","C",3,"M"]
["CPAM Aisne","C",3,"M"]
["CPAM Allier","C",3,"M"]
["CPAM Alpes-de-Haute-Provence","D",3,"M"]
["CPAM Alpes-Maritimes","B",2,"M"]
["CPAM Ardèche","D",3,"M"]
["CPAM Ardennes","D",3,"M"]
["CPAM Ariège","D",3,"M"]
["CPAM Artois","B",2,"M"]
["CPAM Aube","D",3,"M"]
["CPAM Aude","C",3,"M"]
["CPAM Aveyron","D",3,"M"]
["CPAM Bas-Rhin","B",2,"M"]
["CPAM Bayonne","C",3,"M"]
["CPAM Boûches-du-Rhône","A",1,"M"]
["CPAM Calvados","B",2,"M"]
["CPAM Cantal","D",3,"M"]
["CPAM Charente","C",3,"M"]
["CPAM Cher","D",3,"M"]
["CPAM Corrèze","D",3,"M"]
["CPAM Corse-du-sud","D",3,"HM"]
["CPAM Côte-d'Or","C",3,"M"]
["CPAM Côte-d'Opale","B",2,"M"]
["CPAM Côtes d'Armor","C",3,"M"]
["CPAM Creuse","D",3,"M"]
["CPAM Deux-Sèvres","D",3,"M"]
["CPAM Dordogne","C",3,"M"]
["CPAM Doubs","C",null,"M"]
["CPAM Drôme","C",3,"M"]
["CPAM Essonne","B",2,"IDF"]
["CPAM Eure","B",2,"M"]
["CPAM Eure-et-Loir","C",3,"M"]
["CPAM Finistère","B",2,"M"]
["CPAM Flandres-Dunkerque-Armentières","C",3,"M"]
["CPAM Gard","B",2,"M"]
["CPAM Gers","D",3,"M"]
["CPAM Gironde","A",1,"M"]
["CPAM Hainaut","B",2,"M"]
["CPAM Haute-Corse","D",3,"HM"]
["CPAM Haute-Garonne","B",2,"M"]
["CPAM Haute-Marne","D",3,"M"]
["CPAM Hautes-Alpes","D",3,"M"]
["CPAM Haute-Saône","D",3,"M"]
["CPAM Haute-Savoie","B",2,"M"]
["CPAM Hautes-Pyrénées","D",3,"M"]
["CPAM Haute-Vienne","C",3,"M"]
["CPAM Haut-Rhin","B",2,"M"]
["CPAM Hauts-de-Seine","A",1,"IDF"]
["CPAM Hérault","B",2,"M"]
["CPAM Ille-et-Vilaine","B",2,"M"]
["CPAM Indre","D",3,"M"]
["CPAM Indre-et-Loire","B",2,"M"]
["CPAM Isère","B",2,"M"]
["CPAM Jura","D",3,"M"]
["CPAM Landes","C",3,"M"]
["CPAM Le Havre","C",3,"M"]
["CPAM Lille-Douai","B",2,"M"]
["CPAM Loire","B",2,"M"]
["CPAM Loire-Atlantique","B",{"$f":"IF(B66=\"A\",1,IF(B66=\"B\",2,3))","v":2},"M"]
["CPAM Loiret","B",2,"M"]
["CPAM Loir-et-Cher","D",3,"M"]
["CPAM Lot","D",3,"M"]
["CPAM Lot-et-Garonne","D",3,"M"]
["CPAM Maine-et-Loir","B",2,"M"]
["CPAM Manche","C",3,"M"]
["CPAM Marne","C",3,"M"]
["CPAM Mayenne","D",3,"M"]
["CPAM Meurthe-et-Moselle","B",2,"M"]
["CPAM Meuse","D",3,"M"]
["CPAM Morbihan","B",2,"M"]
["CPAM Moselle","B",2,"M"]
["CPAM Nièvre","D",3,"M"]
["CPAM Oise","B",2,"M"]
["CPAM Orne","D",3,"M"]
["CPAM Paris","A",1,"IDF"]
["CPAM Pau","C",3,"M"]
["CPAM Puy-de-Dôme","B",2,"M"]
["CPAM Pyrénées-Orientales","C",3,"M"]
["CPAM Rhône","A",1,"M"]
["CPAM Roubaix-Tourcoing","B",2,"M"]
["CPAM Rouen-Elbeuf-Dieppe-Seine-Maritime","B",2,"M"]
["CPAM Saône-et-Loire","C",3,"M"]
["CPAM Sarthe","C",3,"M"]
["CPAM Savoie","C",3,"M"]
["CPAM Seine-et-Marne","B",2,"IDF"]
["CPAM Seine-Saint-Denis","A",1,"IDF"]
["CPAM Somme","B",2,"M"]
["CPAM Tarn","C",3,"M"]
["CPAM Tarn-et-Garonne","D",3,"M"]
["CPAM Territoire-de-Belfort","D",3,"M"]
["CPAM Val-de-Marne","B",2,"IDF"]
["CPAM Val-d'Oise","B",2,"IDF"]
["CPAM Var","B",2,"M"]
["CPAM Vaucluse","B",2,"M"]
["CPAM Vendée","B",2,"M"]
["CPAM Vienne","C",3,"M"]
["CPAM Vosges","C",3,"M"]
["CPAM Yonne","C",3,"M"]
["CPAM Yvelines","B",2,"IDF"]
["CSSM Mayotte","B",{"$f":"IF(B107=\"A\",1,IF(B107=\"B\",2,3))","v":2},"HM"]
["DRSM Alsace-Moselle",null,"DRSM","M"]
["DRSM Aquitaine",null,"DRSM","M"]
["DRSM Auvergne",null,"DRSM","M"]
["DRSM Bourgogne-Franche-Comté",null,"DRSM","M"]
["DRSM Bretagne",null,"DRSM","M"]
["DRSM Centre",null,"DRSM","M"]
["DRSM Centre-Ouest",null,"DRSM","M"]
["DRSM Guadeloupe",null,"DRSM","HM"]
["DRSM Guyane",null,"DRSM","HM"]
["DRSM Ile de France",null,"DRSM","IDF"]
["DRSM La Réunion",null,"DRSM","HM"]
["DRSM Languedoc-Rousillon",null,"DRSM","M"]
["DRSM Martinique",null,"DRSM","HM"]
["DRSM Midi-Pyrénées",null,"DRSM","M"]
["DRSM Nord-Est",null,"DRSM","M"]
["DRSM Nord-Picardie",null,"DRSM","M"]
["DRSM Normandie",null,"DRSM","M"]
["DRSM Pays de Loire",null,"DRSM","M"]
["DRSM Rhône-Alpes",null,"DRSM","M"]
["DRSM Sud-Est-Corse",null,"DRSM","M"]
["UGECAM Alsace",null,"UGECAM","M"]
["UGECAM Aquitaine",null,"UGECAM","M"]
["UGECAM Auvergne Limousin Poitou-Charente",null,"UGECAM","M"]
["UGECAM Bourgogne Franche-Compté",null,"UGECAM","M"]
["UGECAM Bretagne Pays de la Loire",null,"UGECAM","M"]
["UGECAM Centre",null,"UGECAM","M"]
["UGECAM Ile-de-France",null,"UGECAM","IDF"]
["UGECAM Languedoc-Roussillon Midi-Pyrénées",null,"UGECAM","M"]
["UGECAM Nord Pas-de-Calais Picardie",null,"UGECAM","M"]
["UGECAM Nord-Est",null,"UGECAM","M"]
["UGECAM Normandie",null,"UGECAM","M"]
["UGECAM PACA-Corse",null,"UGECAM","M"]
["UGECAM Rhône Alpes",null,"UGECAM","M"]
["CARSAT Alsace Moselle",null,"CARSAT","M"]
["CARSAT Aquitaine",null,"CARSAT","M"]
["CARSAT Auvergne",null,"CARSAT","M"]
["CARSAT Bourgogne Franche-Compté",null,"CARSAT","M"]
["CARSAT Bretagne",null,"CARSAT","M"]
["CARSAT Centre",null,"CARSAT","M"]
["CARSAT Centre-Ouest",null,"CARSAT","M"]
["CARSAT Languedoc Roussillon",null,"CARSAT","M"]
["CARSAT Midi-Pyrénées",null,"CARSAT","M"]
["CARSAT Nord Est",null,"CARSAT","M"]
["CARSAT Nord Picardie",null,"CARSAT","M"]
["CARSAT Normandie",null,"CARSAT","M"]
["CARSAT Pays de la Loire",null,"CARSAT","M"]
["CARSAT Rhône-Alpes",null,"CARSAT","M"]
["CARSAT Sud-Est",null,"CARSAT","M"]
["CRAMIF",null,"CARSAT","IDF"]
["CTI Bretagne - Pays de Loire",null,"CTIMissionsNationales","M","CTIMissionsNationales"]
["CTI Grand Est",null,"CTICentresNationaux","M","CTICentresNationaux","CTIPrestations"]
["CTI PACAC",null,"CTIPrestations","M","CTIPrestations"]
["CTI Rhône Alpes Auvergne",null,"CTIPrestations","M","CTIPrestations"]
["CTI NP-NP",null,"CTIMissionsNationales","M","CTIMissionsNationales"]
["CTI Sud Toulouse",null,"CTICentresNationaux","M","CTICentresNationaux","CTIPrestations"]
["CICOA",null,"CTIMissionsNationales","M","CTIMissionsNationales"]
["CESTIF",null,"CTIPrestations","M","CTIPrestations"]

{"sheet":"Table de prix_Lot1","index":11,"n_rows":120,"n_cols":10,"rows_kept":120,"cut":false,"hidden":true,"merged":[[11,1,12,1],[0,4,0,6],[3,1,4,1],[5,1,6,1],[7,1,8,1],[9,1,10,1],[42,4,42,6],[45,1,46,1],[13,1,14,1],[15,1,16,1],[21,4,21,6],[24,1,25,1],[26,1,27,1],[28,1,29,1],[57,1,58,1],[30,1,31,1],[32,1,33,1],[34,1,35,1],[36,1,37,1],[47,1,48,1],[49,1,50,1],[51,1,52,1],[53,1,54,1],[55,1,56,1],[109,2,109,5],[116,2,116,5],[64,1,65,1],[66,1,67,1],[68,1,69,1],[71,2,71,5],[84,2,84,5],[98,2,98,5]]}
[null,null,null,null,"A"]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 1","Module 1","Audité",{"$f":"CONCATENATE(B3,C3)","v":"Module 1Audité"},20444,0.2,{"$f":"E3*(1+F3)","v":24532.799999999999}]
["UO 2.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B4,C4)","v":"Module 2Niveau 1"},4114,0.2,{"$f":"E4*(1+F4)","v":4936.8}]
["UO 2.2",null,"Niveau 2",{"$f":"CONCATENATE(B4,C5)","v":"Module 2Niveau 2"},4114,0.2,4936.8]
["UO 3.1","Module 3","Niveau 1",{"$f":"CONCATENATE(B6,C6)","v":"Module 3Niveau 1"},2447,0.2,2936.4]
["UO 3.2",null,"Niveau 2",{"$f":"CONCATENATE(B6,C7)","v":"Module 3Niveau 2"},3671,0.2,4405.2]
["UO 4.1","Module 4","Niveau 1",{"$f":"CONCATENATE(B8,C8)","v":"Module 4Niveau 1"},2575,0.2,3090]
["UO 4.2",null,"Niveau 2",{"$f":"CONCATENATE(B8,C9)","v":"Module 4Niveau 2"},2575,0.2,3090]
["UO 5.1","Module 5","Niveau 1",{"$f":"CONCATENATE(B10,C10)","v":"Module 5Niveau 1"},4655,0.2,5586]
["UO 5.2",null,"Niveau 2",{"$f":"CONCATENATE(B10,C11)","v":"Module 5Niveau 2"},4655,0.2,5586]
["UO 6.1","Module 6","Niveau 1",{"$f":"CONCATENATE(B12,C12)","v":"Module 6Niveau 1"},2888,0.2,3465.6]
["UO 6.2",null,"Niveau 2",{"$f":"CONCATENATE(B12,C13)","v":"Module 6Niveau 2"},4332,0.2,5198.3999999999996]
["UO 7.1","Module 7","Niveau 1",{"$f":"CONCATENATE(B14,C14)","v":"Module 7Niveau 1"},9599,0.2,11518.8]
["UO 7.2",null,"Niveau 2",{"$f":"CONCATENATE(B14,C15)","v":"Module 7Niveau 2"},6931,0.2,8317.1999999999989]
["UO 8.1","Module 8","Niveau 1",{"$f":"CONCATENATE(B16,C16)","v":"Module 8Niveau 1"},5149,0.2,6178.8]
["UO 8.2",null,"Niveau 2",{"$f":"CONCATENATE(B16,C17)","v":"Module 8Niveau 2"},5149,0.2,6178.8]
["UO 9","Module 9","Audité",{"$f":"CONCATENATE(B18,C18)","v":"Module 9Audité"},9154,0.2,10984.8]
["UO 10","Module 10","Audité",{"$f":"CONCATENATE(B19,C19)","v":"Module 10Audité"},4577,0.2,5492.4]
["UO 11","Module 11","Audité",{"$f":"CONCATENATE(B20,C20)","v":"Module 11Audité"},4750,0.2,5700]
[]
[null,null,null,null,"B"]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 12","Module 1","Audité",{"$f":"CONCATENATE(B24,C24)","v":"Module 1Audité"},15960,0.2,{"$f":"E24*(1+F24)","v":19152},null,null,15960]
["13.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B25,C25)","v":"Module 2Niveau 1"},3667,0.2,{"$f":"E25*(1+F25)","v":4400.3999999999996},null,null,3040]
["13.2",null,"Niveau 2",{"$f":"CONCATENATE(B25,C26)","v":"Module 2Niveau 2"},3667,0.2,4400.3999999999996,null,null,3040]
["14.1","Module 3","Niveau 1",{"$f":"CONCATENATE(B27,C27)","v":"Module 3Niveau 1"},2166,0.2,2599.1999999999998,null,null,1824]
["14.2",null,"Niveau 2",{"$f":"CONCATENATE(B27,C28)","v":"Module 3Niveau 2"},3249,0.2,3898.7999999999997,null,null,2736]
["15.1","Module 4","Niveau 1",{"$f":"CONCATENATE(B29,C29)","v":"Module 4Niveau 1"},2176,0.2,2611.1999999999998,null,null,1919]
["15.2",null,"Niveau 2",{"$f":"CONCATENATE(B29,C30)","v":"Module 4Niveau 2"},2176,0.2,2611.1999999999998,null,null,1919]
["16.1","Module 5","Niveau 1",{"$f":"CONCATENATE(B31,C31)","v":"Module 5Niveau 1"},4104,0.2,4924.8,null,null,3420]
["16.2",null,"Niveau 2",{"$f":"CONCATENATE(B31,C32)","v":"Module 5Niveau 2"},4104,0.2,4924.8,null,null,3420]
["17.1","Module 6","Niveau 1",{"$f":"CONCATENATE(B33,C33)","v":"Module 6Niveau 1"},2512,0.2,3014.4,null,null,2075]
["17.2",null,"Niveau 2",{"$f":"CONCATENATE(B33,C34)","v":"Module 6Niveau 2"},3768,0.2,4521.5999999999995,null,null,3112]
["18.1","Module 7",null,{"$f":"CONCATENATE(B35,C35)","v":"Module 7"},8375,0.2,10050,null,null,7021]
["18.2",null,"Niveau 2",{"$f":"CONCATENATE(B35,C36)","v":"Module 7Niveau 2"},6036,0.2,7243.2,null,null,5072]
["19.1","Module 8","Niveau 1",{"$f":"CONCATENATE(B37,C37)","v":"Module 8Niveau 1"},4551,0.2,5461.2,null,null,3810]
["19.2",null,"Niveau 2",{"$f":"CONCATENATE(B37,C38)","v":"Module 8Niveau 2"},4551,0.2,5461.2,null,null,3810]
["UO 20","Module 9","Audité",{"$f":"CONCATENATE(B39,C39)","v":"Module 9Audité"},8531,0.2,10237.199999999999,null,null,6756]
["UO 21","Module 10","Audité",{"$f":"CONCATENATE(B40,C40)","v":"Module 10Audité"},4266,0.2,5119.2,null,null,3378]
["UO 22","Module 11","Audité",{"$f":"CONCATENATE(B41,C41)","v":"Module 11Audité"},4750,0.2,5700,null,null,4750]
[]
[null,null,null,null,"C"]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 23","Module 1","Audité",{"$f":"CONCATENATE(B45,C45)","v":"Module 1Audité"},15960,0.2,{"$f":"E45*(1+F45)","v":19152}]
["UO 24.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B46,C46)","v":"Module 2Niveau 1"},3040,0.2]
["UO 24.2",null,"Niveau 2",{"$f":"CONCATENATE(B46,C47)","v":"Module 2Niveau 2"},3040,0.2,3648]
["UO 25.1","Module 3","Niveau 1",{"$f":"CONCATENATE(B48,C48)","v":"Module 3Niveau 1"},1824,0.2,2188.7999999999997]
["UO 25.2",null,"Niveau 2",{"$f":"CONCATENATE(B48,C49)","v":"Module 3Niveau 2"},2736,0.2,3283.2]
["UO 26.1","Module 4","Niveau 1",{"$f":"CONCATENATE(B50,C50)","v":"Module 4Niveau 1"},1919,0.2,2302.7999999999997]
["UO 26.2",null,"Niveau 2",{"$f":"CONCATENATE(B50,C51)","v":"Module 4Niveau 2"},1919,0.2,2302.7999999999997]
["UO 27.1","Module 5","Niveau 1",{"$f":"CONCATENATE(B52,C52)","v":"Module 5Niveau 1"},3420,0.2,4104]
["UO 27.2",null,"Niveau 2",{"$f":"CONCATENATE(B52,C53)","v":"Module 5Niveau 2"},3420,0.2,4104]
["UO 28.1","Module 6","Niveau 1",{"$f":"CONCATENATE(B54,C54)","v":"Module 6Niveau 1"},2075,0.2,2490]
["UO 28.2",null,"Niveau 2",{"$f":"CONCATENATE(B54,C55)","v":"Module 6Niveau 2"},3112,0.2,3734.3999999999996]
["UO 29.1","Module 7","Niveau 1",{"$f":"CONCATENATE(B56,C56)","v":"Module 7Niveau 1"},7021,0.2,{"$f":"(E56*(1+F56))","v":8425.1999999999989}]
["UO 29.2",null,"Niveau 2",{"$f":"CONCATENATE(B56,C57)","v":"Module 7Niveau 2"},5072,0.2,6086.4]
["UO 30.1","Module 8","Niveau 1",{"$f":"CONCATENATE(B58,C58)","v":"Module 8Niveau 1"},3810,0.2,4572]
["UO 30.2",null,"Niveau 2",{"$f":"CONCATENATE(B58,C59)","v":"Module 8Niveau 2"},3810,0.2,4572]
["UO 32","Module 9","Audité",{"$f":"CONCATENATE(B60,C60)","v":"Module 9Audité"},6756,0.2,8107.2]
["UO 33","Module 10","Audité",{"$f":"CONCATENATE(B61,C61)","v":"Module 10Audité"},3378,0.2,4053.6]
["UO 34","Module 11","Audité",{"$f":"CONCATENATE(B62,C62)","v":"Module 11Audité"},4750,0.2,5700]
[]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 34.1","Module 7.1","Niveau 1",null,3360,0.2,{"$f":"E65*(1+F65)","v":4032}]
["UO 34.2",null,"Niveau 2",null,2310,0.2,2772]
["UO 35.1","Module 7.2","Niveau 1",null,2400,0.2,2880]
["UO 35.2",null,"Niveau 2",null,2310,0.2,2772]
["UO 36.1","Module 7.3","Niveau 1",null,3840,0.2,4608]
["UO 36.2",null,"Niveau 2",null,2310,0.2,2772]
[]
[null,null,"DRSM"]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 37","Module 1","Audité","Module 1Audité",14298,0.2,{"$f":"E74*(1+F74)","v":17157.599999999999}]
["UO 38","Module 2","Audité","Module 2Audité",2641,0.2,{"$f":"E75*(1+F75)","v":3169.2}]
["UO 39","Module 3","Audité","Module 3Audité",2033,0.2,2439.6]
["UO 40","Module 4","Audité","Module 4Audité",1710,0.2,2052]
["UO 41","Module 6","Audité","Module 6Audité",2328,0.2,2793.6]
["UO 42","Module 7","Audité","Module 7Audité",5073,0.2,6087.5999999999995]
["UO 43","Module 8","Audité","Module 8Audité",3230,0.2,3876]
["UO 44","Module 9","Audité","Module 9Audité",5654,0.2,6784.8]
["UO 45","Module 10","Audité","Module 10Audité",2827,0.2,3392.4]
["UO 46","Module 11","Audité","Module 11Audité",4750,0.2,5700]
[]
[null,null,"CARSAT"]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 47","Module 1","Audité",{"$f":"CONCATENATE(B87,C87)","v":"Module 1Audité"},9690,0.2,{"$f":"E87*(1+F87)","v":11628}]
["UO 48","Module 2","Audité","Module 2Audité",1729,0.2,2074.7999999999997]
["UO 49","Module 3","Audité","Module 3Audité",1273,0.2,1527.6]
["UO 50","Module 4","Audité","Module 4Audité",1045,0.2,1254]
["UO 51","Module 5","Audité","Module 5Audité",1957,0.2,2348.4]
["UO 52","Module 6","Audité","Module 6Audité",1501,0.2,1801.2]
["UO 53","Module 7","Audité","Module 7Audité",3553,0.2,4263.5999999999995]
["UO 54","Module 8","Audité","Module 8Audité",2413,0.2,2895.6]
["UO 55","Module 9","Audité","Module 9Audité",5366,0.2,6439.2]
["UO 56","Module 10","Audité","Module 10Audité",2683,0.2,3219.6]
["UO 57","Module 11","Audité","Module 11Audité",4750,0.2,5700]
[]
[null,null,"UGECAM"]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 58","Module 1","Audité",{"$f":"CONCATENATE(B34:B101,\"Audité\")","v":"Module 1Audité"},10545,0.2,{"$f":"E101*(1+F101)","v":12654}]
["UO 59","Module 2","Audité","Module 2Audité",4427,0.2,5312.4]
["UO 60","Module 3","Audité","Module 3Audité",3990,0.2,4788]
["UO 61","Module 4","Audité","Module 4Audité",3097,0.2,3716.3999999999996]
["UO 62","Module 5","Audité","Module 5Audité",4788,0.2,5745.5999999999995]
["UO 63","Module 9","Audité","Module 9Audité",5753,0.2,6903.5999999999995]
["UO 64","Module 10","Audité","Module 10Audité",2877,0.2,3452.4]
["UO 65","Module 11","Audité","Module 11Audité",4750,0.2,5700]
[]
[null,null,"Metropole"]
["Unités d'œuvre","Libellé","Prix forfaitaire HT",null,"TVA","Prix forfaitaire TTC"]
["UO 66","Frais de mission hors transport\n(avec hébergement)",150,null,0.2,{"$f":"C112*(1+E112)","v":180},"nb de j"]
["UO 67","Frais de mission hors transport\n(sans hébergement)",50,null,0.2,{"$f":"C113*(1+E113)","v":60},"nb de j"]
["UO 68","Frais de Transport\n(en Ile de France)",0,null,0.2,{"$f":"C114*(1+E114)","v":0}]
["UO 69","Frais de Transport\n(hors Ile de France)",50,null,0.2,{"$f":"C115*(1+E115)","v":60},"nb de p"]
[]
[null,null,"DOM et Corse"]
["Unités d'œuvre","Libellé","Prix forfaitaire HT",null,"TVA","Prix forfaitaire TTC"]
["UO 70","Frais de mission hors transport\n(avec hébergement)",150,null,0.2,{"$f":"C119*(1+E119)","v":180}]
["UO 71","Frais de Transport",2200,null,0.2,{"$f":"C120*(1+E120)","v":2640}]

{"sheet":"Table de prix_Lot2","index":12,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":true,"merged":[[24,1,25,1],[0,4,0,6],[0,7,0,9],[0,10,0,12],[3,1,4,1],[5,1,6,1],[7,1,8,1],[9,1,10,1],[11,1,12,1],[17,4,17,6],[20,1,21,1],[22,1,23,1],[43,1,44,1],[45,1,46,1],[26,1,27,1],[28,1,29,1],[34,4,34,6],[37,1,38,1],[39,1,40,1],[41,1,42,1]]}
[null,null,null,null,"CTI PRESTATIONS",null,null,"CTI MISSIONS NATIONALES",null,null,"CENTRES NATIONAUX"]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC","Prix forfaitaire HT","TVA","Prix forfaitaire TTC","Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 1","Module 1","Audité",{"$f":"CONCATENATE(B3,C3)","v":"Module 1Audité"},23564.3,0.2,{"$f":"E3*(1+F3)","v":28277.16},25355.5,0.2,{"$f":"H3*(1+I3)","v":30426.6},23564.3,0.2,{"$f":"K3*(1+L3)","v":28277.16}]
["UO 2.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B4,C4)","v":"Module 2Niveau 1"},9246.6,0.2,{"$f":"E4*(1+F4)","v":11095.92},9246.6,0.2,{"$f":"H4*(1+I4)","v":11095.92}]
["UO 2.2",null,"Niveau 2",{"$f":"CONCATENATE(B4,C5)","v":"Module 2Niveau 2"},10886.55,0.2,13063.859999999999,10886.55,0.2,13063.859999999999]
["UO 3.1","Module 3","Niveau 1","Module 3Niveau 1"," ",null,null,null,null,null,8351,0.2,{"$f":"K6*(1+L6)","v":10021.199999999999}]
["UO 3.2",null,"Niveau 2",{"$f":"CONCATENATE(B6,C7)","v":"Module 3Niveau 2"}," ",null,null,null,null,null,10142.200000000001,0.2,12170.640000000001]
["UO 4.1","Module 4","Niveau 1","Module 4Niveau 1",9246.6,0.2,11095.92,9246.6,0.2,11095.92,9246.6,0.2,11095.92]
["UO 4.2",null,"Niveau 2",{"$f":"CONCATENATE(B8,C9)","v":"Module 4Niveau 2"},10886.55,0.2,13063.859999999999,10886.55,0.2,13063.859999999999,10886.55,0.2,13063.859999999999]
["UO 5.1","Module 5","Niveau 1","Module 5Niveau 1",7606.65,0.2,9127.98,7606.65,0.2,9127.98,7606.65,0.2,9127.98]
["UO 5.2",null,"Niveau 2",{"$f":"CONCATENATE(B10,C11)","v":"Module 5Niveau 2"},8351,0.2,10021.199999999999,8351,0.2,10021.199999999999,8351,0.2,10021.199999999999]
["UO 6.1","Module 6","Niveau 1","Module 6Niveau 1",10886.55,0.2,13063.859999999999,12677.75,0.2,15213.3,10886.55,0.2,13063.859999999999]
["UO 6.2",null,"Niveau 2",{"$f":"CONCATENATE(B12,C13)","v":"Module 6Niveau 2"},12526.5,0.2,15031.8,13831.45,0.2,16597.740000000002,12526.5,0.2,15031.8]
["UO 7","Module 7","Audité","Module 7Audité",3840.5,0.2,4608.5999999999995,3840.5,0.2,4608.5999999999995,3840.5,0.2,4608.5999999999995]
["UO 8","Module 8","Audité","Module 8Audité",2126.1999999999998,0.2,2551.4399999999996,2126.1999999999998,0.2,2551.4399999999996,2126.1999999999998,0.2,2551.4399999999996]
["UO 9","Module 9","Audité","Module 9Audité",9804.65,0.2,11765.58,9804.65,0.2,11765.58,9804.65,0.2,11765.58]
[]
[null,null,null,null,"CTI MISSIONS NATIONALES"]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 1","Module 1","Audité",{"$f":"CONCATENATE(B20,C20)","v":"Module 1Audité"},25355.5,0.2,{"$f":"E20*(1+F20)","v":30426.6}]
["UO 2.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B21,C21)","v":"Module 2Niveau 1"},9246.6,0.2,{"$f":"E21*(1+F21)","v":11095.92}]
["UO 2.2",null,"Niveau 2",{"$f":"CONCATENATE(B21,C22)","v":"Module 2Niveau 2"},10886.55,0.2,{"$f":"E22*(1+F22)","v":13063.859999999999}]
["UO 3.1","Module 3","Niveau 1","Module 3Niveau 1"," "]
["UO 3.2",null,"Niveau 2",{"$f":"CONCATENATE(B23,C24)","v":"Module 3Niveau 2"}," "]
["UO 4.1","Module 4","Niveau 1","Module 4Niveau 1",9246.6,0.2,{"$f":"E25*(1+F25)","v":11095.92}]
["UO 4.2",null,"Niveau 2",{"$f":"CONCATENATE(B25,C26)","v":"Module 4Niveau 2"},10886.55,0.2,13063.859999999999]
["UO 5.1","Module 5","Niveau 1","Module 5Niveau 1",7606.65,0.2,9127.98]
["UO 5.2",null,"Niveau 2",{"$f":"CONCATENATE(B27,C28)","v":"Module 5Niveau 2"},8351,0.2,10021.199999999999]
["UO 6.1","Module 6","Niveau 1","Module 6Niveau 1",12677.75,0.2,15213.3]
["UO 6.2",null,"Niveau 2",{"$f":"CONCATENATE(B29,C30)","v":"Module 6Niveau 2"},13831.45,0.2,16597.740000000002]
["UO 7","Module 7","Audité","Module 7Audité",3840.5,0.2,4608.5999999999995]
["UO 8","Module 8","Audité","Module 8Audité",2126.1999999999998,0.2,2551.4399999999996]
["UO 9","Module 9","Audité","Module 9Audité",9804.65,0.2,11765.58]
[]
[null,null,null,null,"CENTRES NATIONAUX"]
["Unités d'œuvre","Modules d'audit","Niveau de profondeur de l'audit",null,"Prix forfaitaire HT","TVA","Prix forfaitaire TTC"]
["UO 1","Module 1","Audité",{"$f":"CONCATENATE(B37,C37)","v":"Module 1Audité"},23564.3,0.2,{"$f":"E37*(1+F37)","v":28277.16}]
["UO 2.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B38,C38)","v":"Module 2Niveau 1"}," "]
["UO 2.2",null,"Niveau 2",{"$f":"CONCATENATE(B38,C39)","v":"Module 2Niveau 2"}," "]
["UO 3.1","Module 3","Niveau 1","Module 3Niveau 1",8351,0.2,{"$f":"E40*(1+F40)","v":10021.199999999999}]
["UO 3.2",null,"Niveau 2",{"$f":"CONCATENATE(B40,C41)","v":"Module 3Niveau 2"},10142.200000000001,0.2,12170.640000000001]
["UO 4.1","Module 4","Niveau 1","Module 4Niveau 1",9246.6,0.2,11095.92]
["UO 4.2",null,"Niveau 2",{"$f":"CONCATENATE(B42,C43)","v":"Module 4Niveau 2"},10886.55,0.2,13063.859999999999]
["UO 5.1","Module 5","Niveau 1","Module 5Niveau 1",7606.65,0.2,9127.98]
["UO 5.2",null,"Niveau 2",{"$f":"CONCATENATE(B44,C45)","v":"Module 5Niveau 2"},8351,0.2,10021.199999999999]
["UO 6.1","Module 6","Niveau 1","Module 6Niveau 1",10886.55,0.2]
["UO 6.2",null,"Niveau 2",{"$f":"CONCATENATE(B46,C47)","v":"Module 6Niveau 2"},12526.5,0.2,15031.8]
["UO 7","Module 7","Audité","Module 7Audité",3840.5,0.2,4608.5999999999995]
["UO 8","Module 8","Audité","Module 8Audité",2126.1999999999998,0.2,2551.4399999999996]
["UO 9","Module 9","Audité","Module 9Audité",9804.65,0.2,11765.58]
[]
["Unités d'œuvre","Libellé","Prix forfaitaire HT",null,"TVA","Prix forfaitaire TTC"]
["UO 10","Frais de mission hors transport\n(avec hébergement)",100,null,0.2,{"$f":"C53*(1+E53)","v":120}]
["UO 11","Frais de mission hors transport\n(sans hébergement)",20,null,0.2,{"$f":"C54*(1+E54)","v":24}]
["UO 12","Frais de Transport\n(en Ile de France)",20,null,0.2,{"$f":"C55*(1+E55)","v":24}]
["UO 13","Frais de Transport\n(hors Ile de France)",150,null,0.2,{"$f":"C56*(1+E56)","v":180}]