{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Masque de saisie","Recap","Données","Macro-planning"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Masque de saisie","index":0,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4]]}
[]
[null,"FICHE DE SUIVI D'AUDIT",null,{"$f":"TODAY()","v":"2016-03-29"}]
[]
[null,"PREVISIONNEL:"]
[null,"Libellé de l'audit:"]
[]
[null,"Type d'audit:"]
[]
[null,"Organisme:"]
[]
[null,"PNA:"]
[]
[null,"Semestre:"]
[]
[null,"Responsable de mission:"]
[]
[null,"Auditeurs:"]
[]
[]
[]
[]
[null,"Prestataire:"]
[]
[null,"REALISATION DE L'AUDIT",null,"Réal."]
[null,"Commande du Diagnostic préalable:",{"$f":"IF($C$29=\"\",\"\",$C$29-135*(($C$29-$C$43)/135))","v":""},false]
[null,"Formulation du bon de commande:",{"$f":"IF($C$29=\"\",\"\",$C$29-105*(($C$29-$C$43)/135))","v":""},false]
[null,"Remise du rapport provisoire:",{"$f":"IF($C$29=\"\",\"\",$C$29-45*(($C$29-$C$43)/135))","v":""},false]
[null,"Phase contradictoire:",{"$f":"IF($C$29=\"\",\"\",$C$29-30*(($C$29-$C$43)/135))","v":""},false]
[null,"Rapport définitif:",null,false]
[null,"Diffusion à l'organisme:",{"$f":"IF(C25=\"\",\"\",C29+15)","v":""},false]
[null,"Séminaire de restitution:",{"$f":"IF(C25=\"\",\"\",C30+15)","v":""},false]
[null,"Projet de plan d'action:",{"$f":"IF(C25=\"\",\"\",C31+60)","v":""},false]
[null,"Plan d'action validé:",{"$f":"IF(C25=\"\",\"\",C32+30)","v":""},false]
[]
[null,"SUIVI DES RECOMMANDATIONS:"]
[null,"Suivi SEM1:",{"$f":"IF(C25=\"\",\"\",C33+180)","v":""},false]
[null,"Suivi SEM2:",{"$f":"IF(C25=\"\",\"\",C36+180)","v":""},false]
[null,"Suivi SEM3:",{"$f":"IF(C25=\"\",\"\",C37+180)","v":""},false]
[null,"Suivi SEM4:",{"$f":"IF(C25=\"\",\"\",C38+180)","v":""},false]
[null,"Suivi SEM5:",{"$f":"IF(C25=\"\",\"\",C39+180)","v":""},false]
[null,"Suivi SEM6:",{"$f":"IF(C25=\"\",\"\",C40+180)","v":""},false]

{"sheet":"Recap","index":1,"n_rows":3,"n_cols":25,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,9],[0,10,0,18],[0,19,0,24],[0,27,0,29],[0,30,0,34]]}
["Descriptif",null,null,null,null,null,null,null,null,null,"Niveau d'avancement",null,null,null,null,null,null,null,null,"Suivi des recommandations"]
["Dénomination de l'audit","Type d'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","Formulation BdC","Remise du rapport provisoire","Contradictoire","Rapport définitif","Diffusion","Seminaire de restitution","Projet du plan d'action","Validation du plan","Suivi des reco\nSemestre 1","Suivi des reco\nSemestre 2","Suivi des reco\nSemestre 3","Suivi des reco\nSemestre 4","Suivi des reco\nSemestre 5","Suivi des reco\nSemestre 6"]
["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"},{"$f":"Tableau5[Rapport définitif]-105*((Tableau5[Rapport définitif]-Tableau5[Analyse préalable])/135)","v":"2012-03-28T02:40:00"},{"$f":"Tableau5[Rapport définitif]-45*((Tableau5[Rapport définitif]-Tableau5[Analyse préalable])/135)","v":"2012-05-21T08:00:00"},{"$f":"Tableau5[Rapport définitif]-30*((Tableau5[Rapport définitif]-Tableau5[Analyse préalable])/135)","v":"2012-06-03T21:20:00"},{"$f":"Tableau5[Date de fin de mission]","v":"2012-07-01"},{"$f":"Tableau5[Rapport définitif]+15","v":"2012-07-16"},{"$f":"Tableau5[Diffusion]+15","v":"2012-07-31"},{"$f":"Tableau5[Seminaire de restitution]+60","v":"2012-09-29"},{"$f":"Tableau5[Projet du plan d''action]+30","v":"2012-10-29"},{"$f":"Tableau5[Validation du plan]+180","v":"2013-04-27"},{"$f":"Tableau5[Suivi des reco\nSemestre 1]+180","v":"2013-10-24"},{"$f":"Tableau5[Suivi des reco\nSemestre 2]+180","v":"2014-04-22"},{"$f":"Tableau5[Suivi des reco\nSemestre 3]+180","v":"2014-10-19"},{"$f":"Tableau5[Suivi des reco\nSemestre 4]+180","v":"2015-04-17"},{"$f":"Tableau5[Suivi des reco\nSemestre 5]+180","v":"2015-10-14"}]

{"sheet":"Données","index":2,"n_rows":165,"n_cols":5,"rows_kept":165,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,"a"]
[2,null,null,null,"b"]
[3,null,null,null,"c"]
[4,null,null,null,"a"]
[5,null,null,null,"b"]
[6,null,null,null,"c"]
[7,null,null,null,"a"]
[8,null,null,null,"b"]
[9,null,null,null,"c"]
[10,null,null,null,"a"]
[11,null,null,null,"b"]
[12,null,null,null,"c"]
[13,null,null,null,"a"]
[null,null,null,null,"b"]
[0,null,null,null,"c"]
[1,null,null,null,"a"]
[2,null,null,null,"b"]
[3,null,null,null,"c"]
[4,null,null,null,"a"]
[null,null,null,null,"b"]
[1,null,null,null,"c"]
[2,null,null,null,"a"]
[null,null,null,null,"b"]
[3,null,null,null,"c"]
[4,null,null,null,"a"]
[5,null,null,null,"b"]
[6,null,null,null,"c"]
[7,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]
[null,null,null,null,"a"]
[null,null,null,null,"b"]
[null,null,null,null,"c"]

{"sheet":"Macro-planning","index":3,"n_rows":36,"n_cols":56,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,28,0,30],[1,3,1,7],[1,8,1,11],[1,12,1,16],[1,17,1,20],[1,21,1,24],[1,25,1,29],[1,30,1,33],[1,34,1,38],[1,39,1,42],[1,43,1,46],[1,47,1,51],[1,52,1,55]]}
["Type d'audit","DM","Auditeurs",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,"CNA"]
[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,"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,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]
[null,{"$f":"Recap!H3","v":"a"}]
[null,{"$f":"IF(Recap!H4=\"\",\"\",Recap!H4)","v":""}]
[null,{"$f":"IF(Recap!H5=\"\",\"\",Recap!H5)","v":""}]
[null,{"$f":"IF(Recap!H6=\"\",\"\",Recap!H6)","v":""}]
[null,{"$f":"IF(Recap!H7=\"\",\"\",Recap!H7)","v":""}]
[null,{"$f":"IF(Recap!H8=\"\",\"\",Recap!H8)","v":""}]
[null,{"$f":"IF(Recap!H9=\"\",\"\",Recap!H9)","v":""}]
[null,{"$f":"IF(Recap!H10=\"\",\"\",Recap!H10)","v":""}]
[null,{"$f":"IF(Recap!H11=\"\",\"\",Recap!H11)","v":""}]
[null,{"$f":"IF(Recap!H12=\"\",\"\",Recap!H12)","v":""}]
[null,{"$f":"IF(Recap!H13=\"\",\"\",Recap!H13)","v":""}]
[null,{"$f":"IF(Recap!H14=\"\",\"\",Recap!H14)","v":""}]
[null,{"$f":"IF(Recap!H15=\"\",\"\",Recap!H15)","v":""}]
[null,{"$f":"IF(Recap!H16=\"\",\"\",Recap!H16)","v":""}]
[null,{"$f":"IF(Recap!H17=\"\",\"\",Recap!H17)","v":""}]
[null,{"$f":"IF(Recap!H18=\"\",\"\",Recap!H18)","v":""}]
[null,{"$f":"IF(Recap!H19=\"\",\"\",Recap!H19)","v":""}]
[null,{"$f":"IF(Recap!H20=\"\",\"\",Recap!H20)","v":""}]
[null,{"$f":"IF(Recap!H21=\"\",\"\",Recap!H21)","v":""}]
[null,{"$f":"IF(Recap!H22=\"\",\"\",Recap!H22)","v":""}]
[null,{"$f":"IF(Recap!H23=\"\",\"\",Recap!H23)","v":""}]
[null,{"$f":"IF(Recap!H24=\"\",\"\",Recap!H24)","v":""}]
[]
[]
[null,"Analyse préalable"]
[null,"Phase terrain"]
[null,"Rapport provisoire"]
[null,"Contradictoire"]
[null,"Rapport définitif"]
[null,"Diffusion"]
[null,"Seminaire de restitution"]
[null,"Projet du plan d'action"]