{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Simulateur CNG","Données","Feuil3","Table échelon"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"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":"Simulateur CNG","index":0,"n_rows":175,"n_cols":16,"rows_kept":175,"cut":false,"hidden":false,"merged":[[43,8,43,9],[43,2,43,3],[45,8,45,9],[46,8,48,9],[3,0,3,14],[5,0,5,15],[6,0,6,10],[7,12,9,12],[7,13,9,13],[7,14,9,14],[7,3,9,7]]}
[]
[]
[]
["SIMULATION DE CLASSEMENT\n\nNous tenons à vous indiquer que cette simulation de classement est purement indicative et n’est donc pas opposable.\n\nSeul l’arrêté du CNG est un document officiel. \n\n Il ne peut être établi qu’une fois le PH nommé, installé sur son poste et après transmission des attestations de fonction sur la plateforme de dématérialisation des démarches sociales. \n"]
[]
["* Liste des services repris : https://www.cng.sante.fr/sites/default/files/media/2025-08/note-classement-et-annexes-primo-nommes-20242025-maj-270125.pdf"]
[]
[null,null,null,"Attention, la reprise des activités sont limitées à 100% sur une même période\n\n**Quotité : 100% = 10 demi-journées = 1ETP = Temps plein\n\n 30% = 3 demi-journées = 0,3 ETP = Activité réduite\n\n50% = 5 demi-journées = 0,5 ETP = Activité réduite ",null,null,null,null,null,null,null,null,"ECHELON ",{"$f":"VLOOKUP(K46,'Table échelon'!A5:B17,2,TRUE)","v":{"$error":"#N/A"}},"Ancienneté conservée (années, mois, jours)",{"$f":"ROUNDDOWN(K175/365,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN((K175-P8*365)/30,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K175-P8*365-P9*30","v":{"$error":"#N/A"}}]
[]
["FONCTIONS CONTRACTUELLES\nServices accomplis*","Date de début","Date de fin","Quotité en %**","Jours",null,"FONCTIONS LIBERALES\nServices accomplis*","Date de début","Date de fin","Quotité en %**","Jours"]
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5",null,"Colonne5","Colonne1","Colonne2","Colonne3","Colonne4"]
[null,null,null,null,{"$f":"IF(MOD(YEAR(B14),4)=0, DATEDIF(B14,C14,\"d\"), DATEDIF(B14,C14,\"d\")+1) * MIN(1, D14)","v":0},null,null,null,null,null,{"$f":"((DATEDIF(H14,I14,\"d\"))*J14)*IF(G14=\"Libéral ou labo - 12 premières années\",2/3,1/3)","v":0}]
[null,null,null,null,{"$f":"IF(MOD(YEAR(B15),4)=0, DATEDIF(B15,C15,\"d\"), DATEDIF(B15,C15,\"d\")+1) * MIN(1, D15)","v":0},null,null,null,null,null,{"$f":"((DATEDIF(H15,I15,\"d\"))*J15)*IF(G15=\"Libéral ou labo - 12 premières années\",2/3,1/3)","v":0}]
[null,null,null,null,{"$f":"IF(MOD(YEAR(B16),4)=0, DATEDIF(B16,C16,\"d\"), DATEDIF(B16,C16,\"d\")+1) * MIN(1, D16)","v":0},null,null,null,null,null,{"$f":"((DATEDIF(H16,I16,\"d\"))*J16)*IF(G16=\"Libéral ou labo - 12 premières années\",2/3,1/3)","v":0}]
[null,null,null,null,0,null,null,null,null,null,{"$f":"((DATEDIF(H17,I17,\"d\"))*J17)*IF(G17=\"Libéral ou labo - 12 premières années\",2/3,1/3)","v":0}]
[null,null,null,null,0,null,null,null,null,null,{"$f":"((DATEDIF(H18,I18,\"d\"))*J18)*IF(G18=\"Libéral ou labo - 12 premières années\",2/3,1/3)","v":0}]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[]
[null,null,"Total périodes contractuelles",null,{"$f":"SUM(E15:E42)","v":0},null,null,null,"Total périodes libérales",null,{"$f":"SUM(K14:K42)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL ACTIVITE\n (nombre de jours repris plafonée à 100% sur une même durée)",null,{"$f":"CUMUL_PLAFONNE_GLOBAL(B14:B42, C14:C42, D14:D42, A14:A42, H14:H42, I14:I42, J14:J42, G14:G42)","v":0}]
[null,null,null,null,null,null,null,null,"Ancienneté comptabilisée \n(années, mois, jours)",null,{"$f":"ROUNDDOWN(K46/365,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN((K46-K47*365)/30,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K46-K47*365-K48*30","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Ancienneté restante (jours)",{"$f":"K46-VLOOKUP(N8,'Table échelon'!A22:B35,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Données","index":1,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Quotité",null,"Services accomplis",null,"Fonctions Libérales"]
[0.1,null,"Administration pénitentiaire",null,"Libéral ou labo - 12 premières années"]
[0.2,null,"Assistant généraliste",null,"Libéral ou labo - 8 dernières années"]
[0.3,null,"Assistant hospitalier universitaire"]
[0.4,null,"Assistant spécialiste"]
[0.5,null,"Attaché avant 1er janvier 2003"]
[0.6,null,"Chef de clinique - CCU-AH"]
[0.7,null,"Chercheur (France et UE)"]
[0.8,null,"Clinicien hospitalier"]
[0.9,null,"Coopération (MAE)"]
[1,null,"établissement de transfusion sanguine"]
[null,null,"établissement privé participant au SPH"]
[null,null,"Hôpitaux de Nouvelle-Calédonie"]
[null,null,"laboratoire de chimie du SSA"]
[null,null,"MCU - PH"]
[null,null,"Médecin du travail (contrat)"]
[null,null,"Médecin inspecteur de la santé"]
[null,null,"Médecin ou pharmacien de la FPE ou FPT"]
[null,null,"PH plein temps"]
[null,null,"PH provisoire"]
[null,null,"PH provisoire (> 1 an, avant LAp)"]
[null,null,"PH temps partiel"]
[null,null,"PHA"]
[null,null,"Pharmacien gérant"]
[null,null,"Pharmacien inspecteur de la santé"]
[null,null,"Pharmacien résident"]
[null,null,"Polynésie française - FPT"]
[null,null,"Praticien adjoint contractuel (PAC)"]
[null,null,"Praticien attaché ou attaché associé"]
[null,null,"Praticien contractuel"]
[null,null,"Praticien de la sécurité sociale"]
[null,null,"Praticien en CECOS"]
[null,null,"PU - PH"]
[null,null,"Salarié - Privé lucratif ; labo ; pharmacie"]
[null,null,"service de santé des armées"]
[null,null,"Services européens valides"]
[null,null,"SN - services militaires ou civils"]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Table échelon","index":3,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Table des échelon"]
["Durée en jours"]
[]
["jours","échelons"]
[1,1,729]
[{"$f":"A5+C5","v":730},2,730]
[{"$f":"A6+C6","v":1460},3,730]
[{"$f":"A7+C7","v":2190},4,730]
[2920,5,730]
[3650,6,730]
[4380,7,730]
[5110,8,730]
[5840,9,1460]
[7300,10,1460]
[8760,11,1460]
[10220,12,1460]
[11680,13]
[]
[]
["Table des échelons inversés"]
["(automatiquement générée à partir de la table des échelons)"]
[{"$f":"B4","v":"échelons"},{"$f":"A4","v":"jours"}]
[{"$f":"B5","v":1},{"$f":"A5","v":1}]
[2,730]
[3,1460]
[4,2190]
[5,2920]
[6,3650]
[7,4380]
[8,5110]
[9,5840]
[10,7300]
[11,8760]
[12,10220]
[{"$f":"B17","v":13},11680]