{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Masque de saisie","Recap","Données","Macro-planning","Saisie budgétaire","Suivi budgétaire","staff","Code des CPAM","Table de prix_Lot1","Table de prix_Lot2"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":10,"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":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4]]}
[]
[null,"FICHE DE SUIVI D'AUDIT",null,{"$f":"TODAY()","v":"2016-04-11"}]
[]
[null,"PREVISIONNEL:"]
[null,"Libellé de l'audit:"]
[]
[null,"Type d'audit:"]
[]
[null,"Organisme:"]
[]
[null,"PNA:"]
[]
[null,"Période:"]
[]
[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]
[]
[null,null,"(jj/mm/aaa)"]

{"sheet":"Recap","index":1,"n_rows":3,"n_cols":30,"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","N.SEMAINE","auditeur1","auditeur2","auditeur3","auditeur4"]
["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"},{"$f":"WEEKNUM(O3)","v":27}]

{"sheet":"Données","index":2,"n_rows":164,"n_cols":5,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"CARSAT Alsace Moselle"]
[null,null,null,null,"CARSAT Aquitaine"]
[null,null,null,null,"CARSAT Auvergne"]
[null,null,null,null,"CARSAT Bourgogne Franche-Compté"]
[null,null,null,null,"CARSAT Bretagne"]
[null,null,null,null,"CARSAT Centre"]
[null,null,null,null,"CARSAT Centre-Ouest"]
[null,null,null,null,"CARSAT Languedoc Roussillon"]
[null,null,null,null,"CARSAT Midi-Pyrénées"]
[null,null,null,null,"CARSAT Nord Est"]
[null,null,null,null,"CARSAT Nord Picardie"]
[null,null,null,null,"CARSAT Normandie"]
[null,null,null,null,"CARSAT Pays de la Loire"]
[null,null,null,null,"CARSAT Rhône-Alpes"]
[null,null,null,null,"CARSAT Sud-Est"]
[null,null,null,null,"CRAMIF"]
[null,null,null,null,"CCSS Lozère"]
[null,null,null,null,"CGSS Guadeloupe"]
[null,null,null,null,"CGSS Guyane"]
[null,null,null,null,"CGSS Martinique"]
["Structure",null,null,null,"CGSS Réunion"]
["Thématique",null,null,null,"CICOA"]
[null,null,null,null,"CPAM  Charente-Maritime"]
[null,null,null,null,"CPAM  Haute-Loire"]
[null,null,null,null,"CPAM Ain"]
[null,null,null,null,"CPAM Aisne"]
[null,null,null,null,"CPAM Allier"]
[null,null,null,null,"CPAM Alpes-de-Haute-Provence"]
[null,null,null,null,"CPAM Alpes-Maritimes"]
["1er semestre",null,null,null,"CPAM Ardèche"]
["2eme semestre",null,null,null,"CPAM Ardennes"]
[null,null,null,null,"CPAM Ariège"]
[null,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 Rouen"]
[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,"GESTIF"]
[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":"Macro-planning","index":3,"n_rows":36,"n_cols":57,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,2,0],[3,1,4,1],[0,3,2,3],[0,2,2,2],[0,1,2,1],[21,0,22,0],[21,2,22,2],[21,3,22,3],[23,0,24,0],[23,2,24,2],[23,3,24,3],[21,1,22,1],[23,1,24,1],[17,0,18,0],[17,2,18,2],[17,3,18,3],[19,0,20,0],[19,2,20,2],[19,3,20,3],[17,1,18,1],[19,1,20,1],[13,0,14,0],[13,2,14,2],[13,3,14,3],[15,0,16,0],[15,2,16,2],[15,3,16,3],[13,1,14,1],[15,1,16,1],[1,35,1,39],[1,40,1,43],[1,44,1,47],[1,48,1,52],[1,53,1,56],[0,29,0,31],[1,4,1,8],[1,9,1,12],[1,13,1,17],[1,18,1,21],[1,22,1,25],[1,26,1,30],[1,31,1,34],[3,0,4,0],[3,2,4,2],[3,3,4,3],[5,0,6,0],[5,2,6,2],[5,3,6,3],[5,1,6,1],[11,2,12,2],[11,0,12,0],[7,0,8,0],[7,2,8,2],[9,0,10,0],[9,2,10,2],[9,3,10,3],[7,3,8,3],[11,3,12,3],[7,1,8,1],[9,1,10,1],[11,1,12,1]]}
["Dénomination","Organisme","DM","Semaine fin mission",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,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,"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"]
["a","a","a",{"$f":"Recap!Z3","v":27}]
[]
["k","","",{"$f":"IF(ISNA(VLOOKUP(A6,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A6,Recap!A:Z,26,FALSE))","v":""}]
[]
["m","","",{"$f":"IF(ISNA(VLOOKUP(A8,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A8,Recap!A:Z,26,FALSE))","v":""}]
[]
["v","","",{"$f":"IF(ISNA(VLOOKUP(A10,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A10,Recap!A:Z,26,FALSE))","v":""}]
[]
[null,null,null,{"$f":"IF(ISNA(VLOOKUP(A12,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A12,Recap!A:Z,26,FALSE))","v":""}]
[]
[null,null,null,{"$f":"IF(ISNA(VLOOKUP(A14,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A14,Recap!A:Z,26,FALSE))","v":""}]
[]
[null,null,null,{"$f":"IF(ISNA(VLOOKUP(A16,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A16,Recap!A:Z,26,FALSE))","v":""}]
[]
[null,null,null,{"$f":"IF(ISNA(VLOOKUP(A18,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A18,Recap!A:Z,26,FALSE))","v":""}]
[]
[null,null,null,{"$f":"IF(ISNA(VLOOKUP(A20,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A20,Recap!A:Z,26,FALSE))","v":""}]
[]
[null,null,null,{"$f":"IF(ISNA(VLOOKUP(A22,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A22,Recap!A:Z,26,FALSE))","v":""}]
[]
[null,null,null,{"$f":"IF(ISNA(VLOOKUP(A24,Recap!A:Z,26,FALSE)),\"\",VLOOKUP(A24,Recap!A:Z,26,FALSE))","v":""}]
[]
[]
[]
[null,null,"Analyse préalable"]
[null,null,"Phase terrain"]
[null,null,"Rapport provisoire"]
[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":"Saisie budgétaire","index":4,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHE DE SUIVI BUDGETAIRE"]
[]
[null,"Nom de l'organisme:"]
[]
[null,"Catégorie de l'organisme:",{"$f":"IF(D6=\"\",\"\",IF(D6=\"CTI Prestations\",\"TableCTIPrestations\",IF(D6=\"CTI Missions Nationales\",\"TableCTIMissionsNationales\",IF(D6=\"CTI Centres Nationaux\",\"TableCTICentreNationaux\",CONCATENATE(\"Table\",D6)))))","v":""},{"$f":"IF(D4=\"\",\"\",VLOOKUP(D4,'Code des CPAM'!$A$1:$C$164,3,FALSE))","v":""}]
[]
[null,"Prestataire:"]
[]
["Choix des modules:",null,"Niveau d'audit"]
[]
[null,"Module 1",null,{"$f":"IF(C12=\"\",0,IF(C12=\"Non audité\",0,VLOOKUP(F12,INDIRECT($C$6),4,FALSE)))","v":0},null,{"$f":"CONCATENATE(B12,C12)","v":"Module 1"}]
[null,null,null,null,null,{"$f":"CONCATENATE(B13,C13)","v":""}]
[null,"Module 2",null,{"$f":"IF(C14=\"\",0,IF(C14=\"Non audité\",0,VLOOKUP(F14,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 2"]
[null,null,null,null,null,""]
[null,"Module 3",null,{"$f":"IF(C16=\"\",0,IF(C16=\"Non audité\",0,VLOOKUP(F16,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 3"]
[null,null,null,null,null,""]
[null,"Module 4",null,{"$f":"IF(C18=\"\",0,IF(C18=\"Non audité\",0,VLOOKUP(F18,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 4"]
[null,null,null,null,null,""]
[null,"Module 5",null,{"$f":"IF(C20=\"\",0,IF(C20=\"Non audité\",0,VLOOKUP(F20,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 5"]
[null,null,null,null,null,""]
[null,"Module 6",null,{"$f":"IF(C22=\"\",0,IF(C22=\"Non audité\",0,VLOOKUP(F22,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 6"]
[null,null,null,null,null,""]
[null,"Module 7",null,{"$f":"IF(C24=\"\",0,IF(C24=\"Non audité\",0,VLOOKUP(F24,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 7"]
[null,null,null,null,null,""]
[null,"Module 8",null,{"$f":"IF(C26=\"\",0,IF(C26=\"Non audité\",0,VLOOKUP(F26,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 8"]
[null,null,null,null,null,""]
[null,"Module 9",null,{"$f":"IF(C28=\"\",0,IF(C28=\"Non audité\",0,VLOOKUP(F28,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 9"]
[null,null,null,null,null,""]
[null,"Module 10",null,{"$f":"IF(C30=\"\",0,IF(C30=\"Non audité\",0,VLOOKUP(F30,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 10"]
[null,null,null,null,null,""]
[null,"Module 11",null,{"$f":"IF(C32=\"\",0,IF(C32=\"Non audité\",0,VLOOKUP(F32,INDIRECT($C$6),4,FALSE)))","v":0},null,"Module 11"]
[]
[null,"Total:",null,{"$f":"SUM(D32,D30,D28,D26,D24,D22,D20,D18,D16)","v":0}]
[]
[null,"Frais de mission:",null,{"$f":"IF(C36=\"\",0,IF(LEFT(D6,3)=\"CTI\",IF(C37=\"Oui\",'Table de prix_Lot2'!F53*'Saisie budgétaire'!C36,'Table de prix_Lot2'!F54*'Saisie budgétaire'!C36),IF(VLOOKUP(D4,'Code des CPAM'!A1:D164,4,FALSE)=\"HM\",C36*'Table de prix_Lot1'!F119,IF(C37=\"Oui\",IF(VLOOKUP(D4,'Code des CPAM'!A1:D164,4,FALSE)=\"M\",C36*'Table de prix_Lot1'!F112),C36*'Table de prix_Lot1'!F113))))","v":0}]
[]
[null,"Frais de transport:",null,{"$f":"IF(C38=\"\",0,IF(LEFT(D6,3)=\"CTI\",IF(VLOOKUP(D4,'Code des CPAM'!A1:D164,4,FALSE)=\"M\",C38*'Table de prix_Lot2'!F56,C38*'Table de prix_Lot2'!F55),IF(VLOOKUP(D4,'Code des CPAM'!A1:D164,4,FALSE)=\"IDF\",0,IF(VLOOKUP(D4,'Code des CPAM'!A1:D164,4,FALSE)=\"M\",'Saisie budgétaire'!C38*'Table de prix_Lot1'!F115,'Saisie budgétaire'!C38*'Table de prix_Lot1'!F120))))","v":0}]
[]
[null,"Total engagé:",null,{"$f":"D38+D36+D34","v":0}]

{"sheet":"Suivi budgétaire","index":5,"n_rows":3,"n_cols":46,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,26,0,31],[0,8,0,9],[0,10,0,11],[0,12,0,14],[0,15,0,17],[0,18,0,21],[0,22,0,24]]}
[null,null,null,null,null,null,null,null,"Analyse du retard dans le commencement de l'audit",null,"Analyse de la durée d'audit",null,"Validation rapport provisoire",null,null,"Validation interne",null,null,"Diffusion raport",null,null,null,"Analyse des équipes d'audit",null,null,"Analyse de la qualité","Analyse des pénalités"]
["Organisme","Classe","Consultant","Montant BC TTC (ENGAGES)","Montant réel TTC","Date d'envoi de la lettre de mission","Date envoi Bon de Commande","Bon de Commande accepté?","Date phase terrain","Date terrain réel","Durée terrain théorique","Durée terrain réel","Date de réception ","Date envoi du rapport validé au prestataire","Date d'envoi du rapport modifié à l'organisme par le prestataire","Date de réception rapport définitif ","Date de transmission FG","Retour \nFG/PF","Date transmission DG","Date de diffusion rapport définitif","Date du séminaire","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","Colonne1","Pénalité max applicable","M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","hebergement","nbj","nbpersonne"]
[null,null,null,null,null,null,null,{"$f":"IF(G3=\"\",\"\",(IF(((TODAY()-G3)>5),\"Oui\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F3=\"\",\"\",IF(T3=\"\",TODAY()-F3,T3-F3))","v":""},null,null,null,null,{"$f":"IF(AND(W3=\"\",X3=\"\",Y3=\"\"),0,(IF(OR(W3>(0.2*SUM(W3:Y3)),SUM(X3:Y3)<3,Y3<SUM(W3:Y3)*0.3),0.25*C3,0)))","v":0},{"$f":"IF(J3=\"\",0,IF(J3=\"\",0,IF(J3>I3,((J3-I3)*1000),0)))","v":0},{"$f":"IF(L3=\"\",0,IF(L3=\"\",0,IF(L3<K3,(K3-L3)/K3*C3,0)))","v":0},{"$f":"IF(Z3=\"\",0,Z3*350)","v":0},{"$f":"IF(AND(AA3=\"\",AB3=\"\",AC3=\"\",AD3=\"\"),0,IF((AB3+AC3+AA3+AD3)>0.3*D3,0.3*D3,AB3+AC3+AA3+AD3))","v":0},{"$f":"IF(AE3=0,\"\",AE3)","v":""}]

{"sheet":"staff","index":6,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["staff","DM","Prestataire"]
["a",1,"z"]
["b",2,"y"]
["c",3,"x"]
["d",4,"w"]
["e",5,"v"]
["f"]
["a"]
["b"]
["c"]
["d"]
["e"]
["f"]
["a"]
["b"]

{"sheet":"Code des CPAM","index":7,"n_rows":164,"n_cols":5,"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",3,"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,"CTI","M","CTIPrestations"]
["CTI Grand Est",null,"CTI","M","CTIMissionsNationales"]
["CTI PACAC",null,"CTI","M","CTICentresNationaux"]
["CTI Rhône Alpes Auvergne",null,"CTI","M"]
["CTI Rouen",null,"CTI","M"]
["CTI Sud Toulouse",null,"CTI","M"]
["CICOA",null,"CTI","M"]
["GESTIF",null,"CTI","M"]

{"sheet":"Table de prix_Lot1","index":8,"n_rows":120,"n_cols":7,"rows_kept":120,"cut":false,"hidden":false,"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é"},null,0.2,{"$f":"E3*(1+F3)","v":0}]
["UO 2.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B4,C4)","v":"Module 2Niveau 1"},null,0.2,{"$f":"E4*(1+F4)","v":0}]
["UO 2.2",null,"Niveau 2",{"$f":"CONCATENATE(B4,C5)","v":"Module 2Niveau 2"},null,0.2,0]
["UO 3.1","Module 3","Niveau 1",{"$f":"CONCATENATE(B6,C6)","v":"Module 3Niveau 1"},null,0.2,0]
["UO 3.2",null,"Niveau 2",{"$f":"CONCATENATE(B6,C7)","v":"Module 3Niveau 2"},null,0.2,0]
["UO 4.1","Module 4","Niveau 1",{"$f":"CONCATENATE(B8,C8)","v":"Module 4Niveau 1"},null,0.2,0]
["UO 4.2",null,"Niveau 2",{"$f":"CONCATENATE(B8,C9)","v":"Module 4Niveau 2"},null,0.2,0]
["UO 5.1","Module 5","Niveau 1",{"$f":"CONCATENATE(B10,C10)","v":"Module 5Niveau 1"},null,0.2,0]
["UO 5.2",null,"Niveau 2",{"$f":"CONCATENATE(B10,C11)","v":"Module 5Niveau 2"},null,0.2,0]
["UO 6.1","Module 6","Niveau 1",{"$f":"CONCATENATE(B12,C12)","v":"Module 6Niveau 1"},null,0.2,0]
["UO 6.2",null,"Niveau 2",{"$f":"CONCATENATE(B12,C13)","v":"Module 6Niveau 2"},null,0.2,0]
["UO 7.1","Module 7","Niveau 1",{"$f":"CONCATENATE(B14,C14)","v":"Module 7Niveau 1"},null,0.2,0]
["UO 7.2",null,"Niveau 2",{"$f":"CONCATENATE(B14,C15)","v":"Module 7Niveau 2"},null,0.2,0]
["UO 8.1","Module 8","Niveau 1",{"$f":"CONCATENATE(B16,C16)","v":"Module 8Niveau 1"},null,0.2,0]
["UO 8.2",null,"Niveau 2",{"$f":"CONCATENATE(B16,C17)","v":"Module 8Niveau 2"},null,0.2,0]
["UO 9","Module 9","Audité",{"$f":"CONCATENATE(B18,C18)","v":"Module 9Audité"},null,0.2,0]
["UO 10","Module 10","Audité",{"$f":"CONCATENATE(B19,C19)","v":"Module 10Audité"},null,0.2,0]
["UO 11","Module 11","Audité",{"$f":"CONCATENATE(B20,C20)","v":"Module 11Audité"},null,0.2,0]
[]
[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é"},null,0.2,{"$f":"E24*(1+F24)","v":0}]
["13.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B25,C25)","v":"Module 2Niveau 1"},null,0.2,{"$f":"E25*(1+F25)","v":0}]
["13.2",null,"Niveau 2",{"$f":"CONCATENATE(B25,C26)","v":"Module 2Niveau 2"},null,0.2,0]
["14.1","Module 3","Niveau 1",{"$f":"CONCATENATE(B27,C27)","v":"Module 3Niveau 1"},null,0.2,0]
["14.2",null,"Niveau 2",{"$f":"CONCATENATE(B27,C28)","v":"Module 3Niveau 2"},null,0.2,0]
["15.1","Module 4","Niveau 1",{"$f":"CONCATENATE(B29,C29)","v":"Module 4Niveau 1"},null,0.2,0]
["15.2",null,"Niveau 2",{"$f":"CONCATENATE(B29,C30)","v":"Module 4Niveau 2"},null,0.2,0]
["16.1","Module 5","Niveau 1",{"$f":"CONCATENATE(B31,C31)","v":"Module 5Niveau 1"},null,0.2,0]
["16.2",null,"Niveau 2",{"$f":"CONCATENATE(B31,C32)","v":"Module 5Niveau 2"},null,0.2,0]
["17.1","Module 6","Niveau 1",{"$f":"CONCATENATE(B33,C33)","v":"Module 6Niveau 1"},null,0.2,0]
["17.2",null,"Niveau 2",{"$f":"CONCATENATE(B33,C34)","v":"Module 6Niveau 2"},null,0.2,0]
["18.1","Module 7","Niveau 1",{"$f":"CONCATENATE(B35,C35)","v":"Module 7Niveau 1"},null,0.2,0]
["18.2",null,"Niveau 2",{"$f":"CONCATENATE(B35,C36)","v":"Module 7Niveau 2"},null,0.2,0]
["19.1","Module 8","Niveau 1",{"$f":"CONCATENATE(B37,C37)","v":"Module 8Niveau 1"},null,0.2,0]
["19.2",null,"Niveau 2",{"$f":"CONCATENATE(B37,C38)","v":"Module 8Niveau 2"},null,0.2,0]
["UO 20","Module 9","Audité",{"$f":"CONCATENATE(B39,C39)","v":"Module 9Audité"},null,0.2,0]
["UO 21","Module 10","Audité",{"$f":"CONCATENATE(B40,C40)","v":"Module 10Audité"},null,0.2,0]
["UO 22","Module 11","Audité",{"$f":"CONCATENATE(B41,C41)","v":"Module 11Audité"},null,0.2,0]
[]
[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é"},null,0.2,{"$f":"E45*(1+F45)","v":0}]
["UO 24.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B46,C46)","v":"Module 2Niveau 1"},null,0.2,0]
["UO 24.2",null,"Niveau 2",{"$f":"CONCATENATE(B46,C47)","v":"Module 2Niveau 2"},null,0.2,0]
["UO 25.1","Module 3","Niveau 1",{"$f":"CONCATENATE(B48,C48)","v":"Module 3Niveau 1"},null,0.2,0]
["UO 25.2",null,"Niveau 2",{"$f":"CONCATENATE(B48,C49)","v":"Module 3Niveau 2"},null,0.2,0]
["UO 26.1","Module 4","Niveau 1",{"$f":"CONCATENATE(B50,C50)","v":"Module 4Niveau 1"},null,0.2,0]
["UO 26.2",null,"Niveau 2",{"$f":"CONCATENATE(B50,C51)","v":"Module 4Niveau 2"},null,0.2,0]
["UO 27.1","Module 5","Niveau 1",{"$f":"CONCATENATE(B52,C52)","v":"Module 5Niveau 1"},null,0.2,0]
["UO 27.2",null,"Niveau 2",{"$f":"CONCATENATE(B52,C53)","v":"Module 5Niveau 2"},null,0.2,0]
["UO 28.1","Module 6","Niveau 1",{"$f":"CONCATENATE(B54,C54)","v":"Module 6Niveau 1"},null,0.2,0]
["UO 28.2",null,"Niveau 2",{"$f":"CONCATENATE(B54,C55)","v":"Module 6Niveau 2"},null,0.2,0]
["UO 29.1","Module 7","Niveau 1",{"$f":"CONCATENATE(B56,C56)","v":"Module 7Niveau 1"},null,0.2,0]
["UO 29.2",null,"Niveau 2",{"$f":"CONCATENATE(B56,C57)","v":"Module 7Niveau 2"},null,0.2,0]
["UO 30.1","Module 8","Niveau 1",{"$f":"CONCATENATE(B58,C58)","v":"Module 8Niveau 1"},null,0.2,0]
["UO 30.2",null,"Niveau 2",{"$f":"CONCATENATE(B58,C59)","v":"Module 8Niveau 2"},null,0.2,0]
["UO 32","Module 9","Audité",{"$f":"CONCATENATE(B60,C60)","v":"Module 9Audité"},null,0.2,0]
["UO 33","Module 10","Audité",{"$f":"CONCATENATE(B61,C61)","v":"Module 10Audité"},null,0.2,0]
["UO 34","Module 11","Audité",{"$f":"CONCATENATE(B62,C62)","v":"Module 11Audité"},null,0.2,0]
[]
["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,null,0.2,{"$f":"E65*(1+F65)","v":0}]
["UO 34.2",null,"Niveau 2",null,null,0.2,0]
["UO 35.1","Module 7.2","Niveau 1",null,null,0.2,0]
["UO 35.2",null,"Niveau 2",null,null,0.2,0]
["UO 36.1","Module 7.3","Niveau 1",null,null,0.2,0]
["UO 36.2",null,"Niveau 2",null,null,0.2,0]
[]
[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é",null,0.2,{"$f":"E74*(1+F74)","v":0}]
["UO 38","Module 2","Audité","Module 2Audité",null,0.2,{"$f":"E75*(1+F75)","v":0}]
["UO 39","Module 3","Audité","Module 3Audité",null,0.2,0]
["UO 40","Module 4","Audité","Module 4Audité",null,0.2,0]
["UO 41","Module 6","Audité","Module 6Audité",null,0.2,0]
["UO 42","Module 7","Audité","Module 7Audité",null,0.2,0]
["UO 43","Module 8","Audité","Module 8Audité",null,0.2,0]
["UO 44","Module 9","Audité","Module 9Audité",null,0.2,0]
["UO 45","Module 10","Audité","Module 10Audité",null,0.2,0]
["UO 46","Module 11","Audité","Module 11Audité",null,0.2,0]
[]
[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é"},null,0.2,{"$f":"E87*(1+F87)","v":0}]
["UO 48","Module 2","Audité","Module 2Audité",null,0.2,0]
["UO 49","Module 3","Audité","Module 3Audité",null,0.2,0]
["UO 50","Module 4","Audité","Module 4Audité",null,0.2,0]
["UO 51","Module 5","Audité","Module 5Audité",null,0.2,0]
["UO 52","Module 6","Audité","Module 6Audité",null,0.2,0]
["UO 53","Module 7","Audité","Module 7Audité",null,0.2,0]
["UO 54","Module 8","Audité","Module 8Audité",null,0.2,0]
["UO 55","Module 9","Audité","Module 9Audité",null,0.2,0]
["UO 56","Module 10","Audité","Module 10Audité",null,0.2,0]
["UO 57","Module 11","Audité","Module 11Audité",null,0.2,0]
[]
[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é"},null,0.2,{"$f":"E101*(1+F101)","v":0}]
["UO 59","Module 2","Audité","Module 2Audité",null,0.2,0]
["UO 60","Module 3","Audité","Module 3Audité",null,0.2,0]
["UO 61","Module 4","Audité","Module 4Audité",null,0.2,0]
["UO 62","Module 5","Audité","Module 5Audité",null,0.2,0]
["UO 63","Module 9","Audité","Module 9Audité",null,0.2,0]
["UO 64","Module 10","Audité","Module 10Audité",null,0.2,0]
["UO 65","Module 11","Audité","Module 11Audité",null,0.2,0]
[]
[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)",null,null,0.2,{"$f":"C112*(1+E112)","v":0}]
["UO 67","Frais de mission hors transport\n(sans hébergement)",null,null,0.2,{"$f":"C113*(1+E113)","v":0}]
["UO 68","Frais de Transport\n(en Ile de France)",null,null,0.2,{"$f":"C114*(1+E114)","v":0}]
["UO 69","Frais de Transport\n(hors Ile de France)",null,null,0.2,{"$f":"C115*(1+E115)","v":0}]
[]
[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)",null,null,0.2,{"$f":"C119*(1+E119)","v":0}]
["UO 71","Frais de Transport",null,null,0.2,{"$f":"C120*(1+E120)","v":0}]

{"sheet":"Table de prix_Lot2","index":9,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"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é"},null,0.2,{"$f":"E3*(1+F3)","v":0},null,0.2,{"$f":"H3*(1+I3)","v":0},null,0.2,{"$f":"K3*(1+L3)","v":0}]
["UO 2.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B4,C4)","v":"Module 2Niveau 1"},null,0.2,{"$f":"E4*(1+F4)","v":0},null,0.2,{"$f":"H4*(1+I4)","v":0}]
["UO 2.2",null,"Niveau 2",{"$f":"CONCATENATE(B4,C5)","v":"Module 2Niveau 2"},null,0.2,0,null,0.2,0]
["UO 3.1","Module 3","Niveau 1","Module 3Niveau 1",null,null,null,null,null,null,null,0.2,{"$f":"K6*(1+L6)","v":0}]
["UO 3.2",null,"Niveau 2",{"$f":"CONCATENATE(B6,C7)","v":"Module 3Niveau 2"},null,null,null,null,null,null,null,0.2,0]
["UO 4.1","Module 4","Niveau 1","Module 4Niveau 1",null,0.2,0,null,0.2,0,null,0.2,0]
["UO 4.2",null,"Niveau 2",{"$f":"CONCATENATE(B8,C9)","v":"Module 4Niveau 2"},null,0.2,0,null,0.2,0,null,0.2,0]
["UO 5.1","Module 5","Niveau 1","Module 5Niveau 1",null,0.2,0,null,0.2,0,null,0.2,0]
["UO 5.2",null,"Niveau 2",{"$f":"CONCATENATE(B10,C11)","v":"Module 5Niveau 2"},null,0.2,0,null,0.2,0,null,0.2,0]
["UO 6.1","Module 6","Niveau 1","Module 6Niveau 1",null,0.2,0,null,0.2,0,null,0.2,0]
["UO 6.2",null,"Niveau 2",{"$f":"CONCATENATE(B12,C13)","v":"Module 6Niveau 2"},null,0.2,0,null,0.2,0,null,0.2,0]
["UO 7","Module 7","Audité","Module 7Audité",null,0.2,0,null,0.2,0,null,0.2,0]
["UO 8","Module 8","Audité","Module 8Audité",null,0.2,0,null,0.2,0,null,0.2,0]
["UO 9","Module 9","Audité","Module 9Audité",null,0.2,0,null,0.2,0,null,0.2,0]
[]
[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é"},null,0.2,{"$f":"E20*(1+F20)","v":0}]
["UO 2.1","Module 2","Niveau 1",{"$f":"CONCATENATE(B21,C21)","v":"Module 2Niveau 1"},null,0.2,{"$f":"E21*(1+F21)","v":0}]
["UO 2.2",null,"Niveau 2",{"$f":"CONCATENATE(B21,C22)","v":"Module 2Niveau 2"},null,0.2,0]
["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",null,0.2,{"$f":"E25*(1+F25)","v":0}]
["UO 4.2",null,"Niveau 2",{"$f":"CONCATENATE(B25,C26)","v":"Module 4Niveau 2"},null,0.2,0]
["UO 5.1","Module 5","Niveau 1","Module 5Niveau 1",null,0.2,0]
["UO 5.2",null,"Niveau 2",{"$f":"CONCATENATE(B27,C28)","v":"Module 5Niveau 2"},null,0.2,0]
["UO 6.1","Module 6","Niveau 1","Module 6Niveau 1",null,0.2,0]
["UO 6.2",null,"Niveau 2",{"$f":"CONCATENATE(B29,C30)","v":"Module 6Niveau 2"},null,0.2,0]
["UO 7","Module 7","Audité","Module 7Audité",null,0.2,0]
["UO 8","Module 8","Audité","Module 8Audité",null,0.2,0]
["UO 9","Module 9","Audité","Module 9Audité",null,0.2,0]
[]
[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é"},null,0.2,{"$f":"E37*(1+F37)","v":0}]
["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",null,0.2,{"$f":"E40*(1+F40)","v":0}]
["UO 3.2",null,"Niveau 2",{"$f":"CONCATENATE(B40,C41)","v":"Module 3Niveau 2"},null,0.2,0]
["UO 4.1","Module 4","Niveau 1","Module 4Niveau 1",null,0.2,0]
["UO 4.2",null,"Niveau 2",{"$f":"CONCATENATE(B42,C43)","v":"Module 4Niveau 2"},null,0.2,0]
["UO 5.1","Module 5","Niveau 1","Module 5Niveau 1",null,0.2,0]
["UO 5.2",null,"Niveau 2",{"$f":"CONCATENATE(B44,C45)","v":"Module 5Niveau 2"},null,0.2,0]
["UO 6.1","Module 6","Niveau 1","Module 6Niveau 1",null,0.2,0]
["UO 6.2",null,"Niveau 2",{"$f":"CONCATENATE(B46,C47)","v":"Module 6Niveau 2"},null,0.2,0]
["UO 7","Module 7","Audité","Module 7Audité",null,0.2,0]
["UO 8","Module 8","Audité","Module 8Audité",null,0.2,0]
["UO 9","Module 9","Audité","Module 9Audité",null,0.2,0]
[]
["Unités d'œuvre","Libellé","Prix forfaitaire HT",null,"TVA","Prix forfaitaire TTC"]
["UO 10","Frais de mission hors transport\n(avec hébergement)",null,null,0.2,{"$f":"C53*(1+E53)","v":0}]
["UO 11","Frais de mission hors transport\n(sans hébergement)",null,null,0.2,{"$f":"C54*(1+E54)","v":0}]
["UO 12","Frais de Transport\n(en Ile de France)",null,null,0.2,{"$f":"C55*(1+E55)","v":0}]
["UO 13","Frais de Transport\n(hors Ile de France)",null,null,0.2,{"$f":"C56*(1+E56)","v":0}]