{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[[13,0,13,2],[18,15,19,16],[1,0,1,13],[3,0,3,3],[3,7,3,10],[12,0,12,2]]}
[]
["                                             ETAT DES SERVICES ANTERIEURS A LA NOMINATION EN QUALITE DE STAGIAIRE\nSECTEUR PRIVE               SUR UN GRADE RELEVANT DE L'ECHELLE C1 OU SUR LE GRADE D'AGENT DE MAITRISE"]
[]
["NOM - PRENOM :",null,null,null,"\n",null,null,"COLLECTIVITE : \n"]
[]
[null,null,null,null,null,null,null,null,null,null,"Total en jours",null,null,{"$f":"SUM(N18:N30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total  à prendre en compte à raison de la moitié",null,null,{"$f":"ROUND(N6/2,0)","v":0},null,null,null,null,null,{"$f":"INT(N9/360)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Service national, service civique ou volontariat internationnal : durée totale (art.10 du décret n° 2016-596)",null,null,null,null,null,null,null,null,{"$f":"INT((N9/30)-(T7*12))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total de l'ancienneté",null,null,{"$f":"SUM(N7+N8)","v":0},null,null,null,null,null,{"$f":"(N9-((T7*360)+(T8*30)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"soit",null,null,{"$f":" T7&\" Ans \" &T8&\" Mois \"&ROUND(T9,0)&\" Jours\"","v":"0 Ans 0 Mois 0 Jours"}]
[]
[]
["Date, cachet et signature de l'autorité territorale  "]
["Date et signature de l'agent"]
[]
[]
["Employeur","du","au","Temps Hebdomadaire","Temps Mensuel","Status Dates","nb jours","Nature des services en tant que salarié  et contrats aidés","Durée Hebdomadaire","Durée Mensuelle","nb d'heures sur la période","Nomination C1          durée ramenée en équivalent temps plein","Colonne1","        Durée ramenée en équivalent temps plein"]
[null,null,null,{"$f":"IF(AND(B18>DATE(1982,1,31),C18<=DATE(2001,12,31)),\"39\",IF(AND(B18>=DATE(2002,1,1),C18<DATE(2050,1,31)),\"35\",IF(AND(B18>=DATE(1970,1,31),C18<=DATE(1982,1,31)),\"40\",IF(AND(B18=\"\"),\"\",IF(AND(C18=\"\"),\"\",\"Erreur\")))))","v":""},{"$f":"IF(AND(B18>DATE(1982,1,31),C18<=DATE(2001,12,31)),\"169\",IF(AND(B18>=DATE(2002,1,1),C18<DATE(2050,1,31)),\"151,67\",IF(AND(B18>DATE(1970,1,31),C18<=DATE(1982,1,31)),\"173,20\",IF(AND(B18=\"\"),\"\",IF(AND(C18=\"\"),\"\",\"Erreur\")))))","v":""},{"$f":"IF(OR(D18=\"errreur\"),Erreur,IF(OR(E18=\"erreur\"),\"Erreur\",IF(OR(D18=\"\"),\"\",IF(OR(E18=\"\"),\"\",IF(AND(B18=\"\"),\"\",IF(AND(C18=\"\"),\"\",IF(OR(C18<B18),\"Erreur\",\"OK\")))))))","v":""},{"$f":"IF(C18=\"\",\"\",DAYS360(B18,C18+1))","v":""},null,null,null,null,{"$f":"IF(I18>0,G18*I18/D18,IF(J18>0,G18*J18/E18,IF(K18>0,30*K18/E18,\"\")))","v":""},{"$f":"ROUND(L18,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(L18=\"\",\"\",IF(G18<M18,G18,M18))","v":""}]
[null,null,null,"","",{"$f":"IF(OR(D19=\"errreur\"),Erreur,IF(OR(E19=\"erreur\"),\"Erreur\",IF(OR(D19=\"\"),\"\",IF(OR(E19=\"\"),\"\",IF(AND(B19=\"\"),\"\",IF(AND(C19=\"\"),\"\",IF(OR(C19<B19),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},"",null,"Table de concordance \n100ème et minutes"]
[null,null,null,"","",{"$f":"IF(OR(D20=\"errreur\"),Erreur,IF(OR(E20=\"erreur\"),\"Erreur\",IF(OR(D20=\"\"),\"\",IF(OR(E20=\"\"),\"\",IF(AND(B20=\"\"),\"\",IF(AND(C20=\"\"),\"\",IF(OR(C20<B20),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},""]
[null,null,null,"","",{"$f":"IF(OR(D21=\"errreur\"),Erreur,IF(OR(E21=\"erreur\"),\"Erreur\",IF(OR(D21=\"\"),\"\",IF(OR(E21=\"\"),\"\",IF(AND(B21=\"\"),\"\",IF(AND(C21=\"\"),\"\",IF(OR(C21<B21),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},"",null,"Minutes"]
[null,null,null,"","",{"$f":"IF(OR(D22=\"errreur\"),Erreur,IF(OR(E22=\"erreur\"),\"Erreur\",IF(OR(D22=\"\"),\"\",IF(OR(E22=\"\"),\"\",IF(AND(B22=\"\"),\"\",IF(AND(C22=\"\"),\"\",IF(OR(C22<B22),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},"",null,"Centièmes",{"$f":"($Q$21*100)/60","v":0}]
[null,null,null,"","",{"$f":"IF(OR(D23=\"errreur\"),Erreur,IF(OR(E23=\"erreur\"),\"Erreur\",IF(OR(D23=\"\"),\"\",IF(OR(E23=\"\"),\"\",IF(AND(B23=\"\"),\"\",IF(AND(C23=\"\"),\"\",IF(OR(C23<B23),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},"",null,"Centièmes"]
[null,null,null,"","",{"$f":"IF(OR(D24=\"errreur\"),Erreur,IF(OR(E24=\"erreur\"),\"Erreur\",IF(OR(D24=\"\"),\"\",IF(OR(E24=\"\"),\"\",IF(AND(B24=\"\"),\"\",IF(AND(C24=\"\"),\"\",IF(OR(C24<B24),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},"",null,"Minutes",{"$f":"($Q$23*60)/100","v":0}]
[null,null,null,"","",{"$f":"IF(OR(D25=\"errreur\"),Erreur,IF(OR(E25=\"erreur\"),\"Erreur\",IF(OR(D25=\"\"),\"\",IF(OR(E25=\"\"),\"\",IF(AND(B25=\"\"),\"\",IF(AND(C25=\"\"),\"\",IF(OR(C25<B25),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},""]
[null,null,null,"","",{"$f":"IF(OR(D26=\"errreur\"),Erreur,IF(OR(E26=\"erreur\"),\"Erreur\",IF(OR(D26=\"\"),\"\",IF(OR(E26=\"\"),\"\",IF(AND(B26=\"\"),\"\",IF(AND(C26=\"\"),\"\",IF(OR(C26<B26),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},""]
[null,null,null,"","",{"$f":"IF(OR(D27=\"errreur\"),Erreur,IF(OR(E27=\"erreur\"),\"Erreur\",IF(OR(D27=\"\"),\"\",IF(OR(E27=\"\"),\"\",IF(AND(B27=\"\"),\"\",IF(AND(C27=\"\"),\"\",IF(OR(C27<B27),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},""]
[null,null,null,"","",{"$f":"IF(OR(D28=\"errreur\"),Erreur,IF(OR(E28=\"erreur\"),\"Erreur\",IF(OR(D28=\"\"),\"\",IF(OR(E28=\"\"),\"\",IF(AND(B28=\"\"),\"\",IF(AND(C28=\"\"),\"\",IF(OR(C28<B28),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},""]
[null,null,null,"","",{"$f":"IF(OR(D29=\"errreur\"),Erreur,IF(OR(E29=\"erreur\"),\"Erreur\",IF(OR(D29=\"\"),\"\",IF(OR(E29=\"\"),\"\",IF(AND(B29=\"\"),\"\",IF(AND(C29=\"\"),\"\",IF(OR(C29<B29),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},""]
[null,null,null,"","",{"$f":"IF(OR(D30=\"errreur\"),Erreur,IF(OR(E30=\"erreur\"),\"Erreur\",IF(OR(D30=\"\"),\"\",IF(OR(E30=\"\"),\"\",IF(AND(B30=\"\"),\"\",IF(AND(C30=\"\"),\"\",IF(OR(C30<B30),\"Erreur\",\"OK\")))))))","v":""},"",null,null,null,null,"",{"$error":"#VALUE!"},""]

{"sheet":"data","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}