{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Intro","Récup","DS Flex","Prestation","Demande de congé","Fériés","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":56,"comments":3,"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":"Intro","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[9,2,9,3],[7,2,7,3],[7,7,7,9],[0,0,0,1],[1,0,1,1],[4,2,4,5],[4,6,4,9],[6,2,6,4],[6,7,6,9],[2,1,2,8],[3,1,3,8]]}
["EM",null,null,"Cliquez sur Enable si besoin"]
[]
["08:06:00","Fichier Individuel"]
[null,"(du 1er au dernier jour du mois) sera encodé en HRM le mois x+1"]
[null,"Mois de :","Septembre"]
[]
[null,"NOM :","FRASCONE",null,null,null,"Prénom :","Olivier"]
[null,"Grade :","ADJ",null,null,null,"Matricule :",9223368]
[]
[null,"Date","2020-08-31"]
[]
[]
[]
[]
[]
[]
[null,"Comdt Det",{"$f":"VLOOKUP(A1,Sheet1!A1:E3,2,FALSE)","v":"DE KEYZER H.    "},null,null,null,"CSM",{"$f":"VLOOKUP(A1,Sheet1!A1:E3,4,FALSE)","v":"JODOCY S."}]
[null,null,{"$f":"VLOOKUP(A1,Sheet1!A1:E3,3,FALSE)","v":"Comdt    "},null,null,null,null,{"$f":"VLOOKUP(A1,Sheet1!A1:E3,5,FALSE)","v":"Adjt"}]
[]
["A remplir",null,"A Ne pas enregistrer sur le Common, < \"Save As\" è votre session"]

{"sheet":"Récup","index":1,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,2,51,6],[50,10,50,14],[51,10,51,14],[43,2,43,6],[44,2,44,6],[49,2,49,6],[43,10,43,14],[44,10,44,14],[49,10,49,14],[45,12,45,13],[32,4,32,10],[21,4,21,10],[22,4,22,10],[23,4,23,10],[24,4,24,10],[25,4,25,10],[26,4,26,10],[27,4,27,10],[28,4,28,10],[29,4,29,10],[30,4,30,10],[31,4,31,10],[36,4,36,10],[37,4,37,10],[50,2,50,6],[39,4,39,10],[40,4,40,10],[38,4,38,10],[33,4,33,10],[34,4,34,10],[35,4,35,10],[7,8,7,10],[20,4,20,10],[9,4,9,10],[10,4,10,10],[11,4,11,10],[12,4,12,10],[13,4,13,10],[14,4,14,10],[15,4,15,10],[16,4,16,10],[17,4,17,10],[18,4,18,10],[19,4,19,10],[1,16,1,26],[7,3,7,5],[0,0,0,2],[4,3,4,6],[4,7,4,10],[6,3,6,5],[6,8,6,10],[2,0,2,14],[3,0,3,14]]}
[{"$f":"Intro!A1","v":"EM"},null,null,null,null,null,null,null,null,null,"08:06:00",0.70000000000000007,1.0166666666666666,1.3333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vous remplissez pendant le mois et à remettre le premier jour du mois X+1 pour encodage en HRM au Bu CSM"]
["Feuille de compensation en temps mensuelle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calcul automatique sur base 7hr36 + 1/2 Hr de midi"]
["(du 1er au dernier jour du mois) sera encodé en HRM le mois x+1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les heures entre 22hr00 et 06hr00 sont calculées"]
[null,null,"Mois de :",{"$f":"IF(A11=\"\",\"\",A11)","v":"2020-08-31"},null,null,null,null,null,null,null,null,null,null,null,null,"Les heures sont encodées au format HH:MM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nature de la prestation → Pour les gardes, uniquement écrire Garde (Ne pas encoder d'heures)"]
[null,null,"NOM :",{"$f":"Intro!C7","v":"FRASCONE"},null,null,null,"Prénom :",{"$f":"Intro!H7","v":"Olivier"}]
[null,null,"Grade :",{"$f":"Intro!C8","v":"ADJ"},null,null,null,"Matricule :",{"$f":"Intro!H8","v":9223368}]
[]
["Jour",null,"Hr Début","Hr Fin","Nature de la mission\n+ Ref de l'exercice, N° imputation (tout renseignements utiles)",null,null,null,null,null,null,"22hr00\nà\n06hr00","Hrs normales","Total Hrs","Inscription\nCSM"]
[{"$f":"Intro!C10","v":"2020-08-31"},{"$f":"IF(WEEKDAY(A11,2)=6,\"Samedi\",IF(WEEKDAY(A11,2)=7,\"Dimanche\",IF(ISNA(VLOOKUP($A11,Fériés,2,0)=1),\"Normal\",IF(VLOOKUP($A11,Fériés,2,0)=1,\"Férié\",\" \"))))","v":"Dimanche"},null,null,null,null,null,null,null,null,null,{"$f":"IF(D11=\"\",\"\",NBHN(C11,D11))","v":""},{"$f":"IF(D11=\"\",\"\",(D11-C11+IF(C11>D11,1)-$K$1))","v":""},{"$f":"IF(AND(B11=\"Normal\",B12=\"Normal\",E11=\"Garde\"),$L$1,IF(AND(B11=\"Férié\",B12=\"Normal\",E11=\"Garde\"),$M$1,IF(AND(B11=\"Normal\",B12=\"Samedi\",E11=\"Garde\"),$M$1,IF(AND(B11=\"Férié\",B12=\"Samedi\",E11=\"Garde\"),$N$1,IF(AND(B11=\"Samedi\",B12=\"Dimanche\",E11=\"Garde\"),$N$1,IF(AND(B11=\"Dimanche\",B12=\"Férié\",E11=\"Garde\"),$N$1,IF(AND(B11=\"Dimanche\",B12=\"Normal\",E11=\"Garde\"),$M$1,IF(AND(B11=\"Normal\",B12=\"Férié\",E11=\"Garde\"),$M$1,IF(D11=\"\",\"\",(D11-C11+IF(C11>D11,1)-$K$1)+L11)))))))))","v":""}]
[{"$f":"IF($A11=\"\",\"\",$A11+1)","v":"2020-09-01"},"Normal",0.16666666666666666,0.54166666666666663,null,null,null,null,null,null,null,{"$f":"IF(D12=\"\",\"\",NBHN(C12,D12))","v":8.3333333333333343E-2},{"$f":"IF(D12=\"\",\"\",(D12-C12+IF(C12>D12,1)-$K$1))","v":3.7500000000000033E-2},{"$f":"IF(AND(B12=\"Normal\",B13=\"Normal\",E12=\"Garde\"),$L$1,IF(AND(B12=\"Férié\",B13=\"Normal\",E12=\"Garde\"),$M$1,IF(AND(B12=\"Normal\",B13=\"Samedi\",E12=\"Garde\"),$M$1,IF(AND(B12=\"Férié\",B13=\"Samedi\",E12=\"Garde\"),$N$1,IF(AND(B12=\"Samedi\",B13=\"Dimanche\",E12=\"Garde\"),$N$1,IF(AND(B12=\"Dimanche\",B13=\"Férié\",E12=\"Garde\"),$N$1,IF(AND(B12=\"Dimanche\",B13=\"Normal\",E12=\"Garde\"),$M$1,IF(AND(B12=\"Normal\",B13=\"Férié\",E12=\"Garde\"),$M$1,IF(D12=\"\",\"\",(D12-C12+IF(C12>D12,1)-$K$1)+L12)))))))))","v":0.12083333333333338}]
[{"$f":"IF($A12=\"\",\"\",$A12+1)","v":"2020-09-02"},"Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-03","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-04","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-05","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-06","Samedi",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-07","Dimanche",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-08","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-09","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-10","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-11","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-12","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-13","Samedi",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-14","Dimanche",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-15","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-16","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-17","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-18","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-19","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-20","Samedi",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-21","Dimanche",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-22","Normal",null,null,null,null,null,null,null,null,null,"","",""]
[{"$f":"IF($A33=\"\",\"\",$A33+1)","v":"2020-09-23"},"Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-24","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-25","Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-26","Normal",null,null,null,null,null,null,null,null,null,"","",""]
[{"$f":"IF($A37=\"\",\"\",$A37+1)","v":"2020-09-27"},"Samedi",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-28","Dimanche",null,null,null,null,null,null,null,null,null,"","",""]
[{"$f":"IF($A39=\"\",\"\",$A39+1)","v":"2020-09-29"},"Normal",null,null,null,null,null,null,null,null,null,"","",""]
["2020-09-30","Normal",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N11:N41)","v":0.12083333333333338}]
[]
[null,null,"Commandant d'unité",null,null,null,null,null,null,null,"Adjudant d'unité"]
[null,null,"Pour accord",null,null,null,null,null,null,null,"Pour inscription"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Décimale:",null,{"$f":"N42*24","v":2.9000000000000012}]
[]
[]
[]
[null,null,{"$f":"Intro!C17","v":"DE KEYZER H.    "},null,null,null,null,null,null,null,{"$f":"Intro!H17","v":"JODOCY S."}]
[null,null,{"$f":"Intro!C18","v":"Comdt    "},null,null,null,null,null,null,null,{"$f":"Intro!H18","v":"Adjt"}]
[null,null,"Comd d'Unité",null,null,null,null,null,null,null,"Adjudant d'Unité"]

{"sheet":"DS Flex","index":2,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[39,3,39,9],[40,3,40,9],[48,0,48,4],[48,6,48,10],[43,0,43,4],[43,6,43,10],[46,0,46,4],[46,6,46,10],[47,0,47,4],[47,6,47,10],[20,3,20,9],[21,3,21,9],[22,3,22,9],[23,3,23,9],[42,0,42,4],[42,6,42,10],[29,3,29,9],[30,3,30,9],[31,3,31,9],[32,3,32,9],[33,3,33,9],[34,3,34,9],[36,3,36,9],[35,3,35,9],[37,3,37,9],[38,3,38,9],[25,3,25,9],[26,3,26,9],[27,3,27,9],[28,3,28,9],[9,3,9,9],[10,3,10,9],[11,3,11,9],[24,3,24,9],[13,3,13,9],[14,3,14,9],[15,3,15,9],[16,3,16,9],[17,3,17,9],[18,3,18,9],[12,3,12,9],[19,3,19,9],[6,2,6,4],[6,7,6,9],[7,2,7,3],[7,7,7,9],[0,0,0,1],[1,0,1,1],[2,1,2,10],[4,2,4,5],[4,6,4,9]]}
[{"$f":"Intro!A1","v":"EM"}]
[]
["08:06:00","Feuille de dispense de service flexibles mensuelle"]
[null,null,null,"(du 1er au dernier jour du mois) sera encodé en HRM le mois x+1"]
[null,"Mois de :",{"$f":"IF(A11=\"\",\"\",A11)","v":"2020-08-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Encodage des DS Flex sous OM (Garde & Sv Intens encodé par DAES avec les prestations)"]
[null,"NOM :",{"$f":"Intro!C7","v":"FRASCONE"},null,null,null,"Prénom :",{"$f":"Intro!H7","v":"Olivier"},null,null,null,null,"2 Hr de DS Flex par nuitée A inscrire dans la Coln Hr DS"]
[null,"Grade :",{"$f":"Intro!C8","v":"ADJ"},null,null,null,"Matricule :",{"$f":"Intro!H8","v":9223368},null,null,null,null,"Fin du mois imprimez et remettez la au Srt"]
[]
["Jour","Hr début","Hr fin","Nature de la mission\n+ Ref de l'exercice, N° imputation (tout renseignements utiles)",null,null,null,null,null,null,"Hr DS","Inscription\nCSM"]
[{"$f":"Intro!C10","v":"2020-08-31"}]
[{"$f":"IF($A11=\"\",\"\",$A11+1)","v":"2020-09-01"}]
[{"$f":"IF($A12=\"\",\"\",$A12+1)","v":"2020-09-02"}]
["2020-09-03"]
["2020-09-04"]
["2020-09-05"]
["2020-09-06"]
["2020-09-07"]
["2020-09-08"]
["2020-09-09"]
["2020-09-10"]
["2020-09-11"]
["2020-09-12"]
["2020-09-13"]
["2020-09-14"]
["2020-09-15"]
["2020-09-16"]
["2020-09-17"]
["2020-09-18"]
["2020-09-19"]
["2020-09-20"]
["2020-09-21"]
["2020-09-22"]
[{"$f":"IF($A33=\"\",\"\",$A33+1)","v":"2020-09-23"}]
["2020-09-24"]
["2020-09-25"]
["2020-09-26"]
[{"$f":"IF($A37=\"\",\"\",$A37+1)","v":"2020-09-27"}]
["2020-09-28"]
[{"$f":"IF($A39=\"\",\"\",$A39+1)","v":"2020-09-29"}]
["2020-09-30"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K41)","v":0}]
["Commandant d'unité",null,null,null,null,null,"Adjudant d'unité"]
["Pour accord",null,null,null,null,null,"Pour inscription"]
[]
[]
[{"$f":"Intro!C17","v":"DE KEYZER H.    "},null,null,null,null,null,{"$f":"Intro!H17","v":"JODOCY S."}]
[{"$f":"Intro!C18","v":"Comdt    "},null,null,null,null,null,{"$f":"Intro!H18","v":"Adjt"}]
["Comd d'Unité",null,null,null,null,null,"Adjudant d'Unité"]

{"sheet":"Prestation","index":3,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[39,3,39,9],[40,3,40,9],[48,0,48,4],[48,6,48,10],[43,0,43,4],[43,6,43,10],[46,0,46,4],[46,6,46,10],[47,0,47,4],[47,6,47,10],[20,3,20,9],[21,3,21,9],[22,3,22,9],[23,3,23,9],[42,0,42,4],[42,6,42,10],[29,3,29,9],[30,3,30,9],[31,3,31,9],[32,3,32,9],[33,3,33,9],[34,3,34,9],[36,3,36,9],[35,3,35,9],[37,3,37,9],[38,3,38,9],[25,3,25,9],[26,3,26,9],[27,3,27,9],[28,3,28,9],[9,3,9,9],[10,3,10,9],[11,3,11,9],[24,3,24,9],[13,3,13,9],[14,3,14,9],[15,3,15,9],[16,3,16,9],[17,3,17,9],[18,3,18,9],[12,3,12,9],[19,3,19,9],[6,2,6,4],[6,7,6,9],[7,2,7,3],[7,7,7,9],[0,0,0,1],[1,0,1,1],[2,1,2,10],[4,2,4,5],[4,6,4,9]]}
[{"$f":"Intro!A1","v":"EM"}]
[]
["08:06:00","Feuille de prestation donnant droit à des indemnités pécuniaires"]
[null,null,null,"(du 1er au dernier jour du mois) sera encodé en HRM le mois x+1"]
[null,"Mois de :",{"$f":"IF(A11=\"\",\"\",A11)","v":"2020-08-31"},null,null,null,null,null,null,null,null,null,"Notez l'heure de début en regard du jour"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Notez l'heure de fin en regard du jour de fin"]
[null,"NOM :",{"$f":"Intro!C7","v":"FRASCONE"},null,null,null,"Prénom :",{"$f":"Intro!H7","v":"Olivier"},null,null,null,null,"Notez la nature de la prestation"]
[null,"Grade :",{"$f":"Intro!C8","v":"ADJ"},null,null,null,"Matricule :",{"$f":"Intro!H8","v":9223368},null,null,null,null,"Imprimez la fauille et faites signer le Chef de Sv"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Remettez la au Srt"]
["Jour","Hr début","Hr fin","Nature de la prestation\n+ Ref de l'exercice, N° imputation (tout renseignements utiles)",null,null,null,null,null,null,"Chef Pl/Sv","Inscription\nCSM"]
[{"$f":"Intro!C10","v":"2020-08-31"}]
[{"$f":"IF($A11=\"\",\"\",$A11+1)","v":"2020-09-01"}]
[{"$f":"IF($A12=\"\",\"\",$A12+1)","v":"2020-09-02"}]
["2020-09-03"]
["2020-09-04"]
["2020-09-05"]
["2020-09-06"]
["2020-09-07"]
["2020-09-08"]
["2020-09-09"]
["2020-09-10"]
["2020-09-11"]
["2020-09-12"]
["2020-09-13"]
["2020-09-14"]
["2020-09-15"]
["2020-09-16"]
["2020-09-17"]
["2020-09-18"]
["2020-09-19"]
["2020-09-20"]
["2020-09-21"]
["2020-09-22"]
[{"$f":"IF($A33=\"\",\"\",$A33+1)","v":"2020-09-23"}]
["2020-09-24"]
["2020-09-25"]
["2020-09-26"]
[{"$f":"IF($A37=\"\",\"\",$A37+1)","v":"2020-09-27"}]
["2020-09-28"]
[{"$f":"IF($A39=\"\",\"\",$A39+1)","v":"2020-09-29"}]
["2020-09-30"]
[]
["Commandant d'unité",null,null,null,null,null,"Adjudant d'unité"]
["Pour accord",null,null,null,null,null,"Pour inscription"]
[]
[]
[{"$f":"Intro!C17","v":"DE KEYZER H.    "},null,null,null,null,null,{"$f":"Intro!H17","v":"JODOCY S."}]
[{"$f":"Intro!C18","v":"Comdt    "},null,null,null,null,null,{"$f":"Intro!H18","v":"Adjt"}]
["Comd d'Unité",null,null,null,null,null,"Adjudant d'Unité"]

{"sheet":"Demande de congé","index":4,"n_rows":70,"n_cols":15,"rows_kept":70,"cut":false,"hidden":false,"merged":[[12,10,12,11],[4,13,4,16],[8,1,8,2],[8,4,8,8],[8,10,8,11],[10,13,10,16],[10,4,10,8],[10,10,10,11],[4,1,4,2],[12,1,12,5],[2,3,2,7],[2,9,2,10],[2,11,2,15],[8,13,8,16],[4,3,4,7],[4,9,4,12],[6,1,6,6],[62,9,62,12],[62,6,62,7],[18,6,18,16],[23,3,23,7],[20,1,20,5],[25,12,25,16],[48,1,48,4],[40,12,40,16],[44,1,44,3],[37,10,37,11],[44,4,46,16],[38,12,38,16],[39,12,39,16],[32,12,32,16],[20,14,20,15],[33,12,33,16],[35,1,35,4],[35,10,35,11],[28,1,28,4],[28,10,28,11],[14,10,14,11],[25,3,25,7],[24,3,24,8],[16,10,16,11],[18,1,18,5],[14,1,14,6],[16,1,16,2],[16,12,16,14],[24,12,24,16],[22,3,22,7],[30,10,30,11],[31,12,31,16],[26,12,26,16]]}
[null,null,null,null,null,null,null,"Demande de",{"$f":"IF(AND(K13<>\"\",K15<>\"\"),\"congé ET Recup\",IF(AND(K13=\"\",K15<>\"\"),\"Récup\",\"congé\"))","v":"congé"}]
[]
[null,"NOM",null,{"$f":"Intro!C7","v":"FRASCONE"},null,null,null,null,null,"Prénom:",null,{"$f":"Intro!H7","v":"Olivier"}]
[]
[null,"Grade",null,{"$f":"Intro!C8","v":"ADJ"},null,null,null,null,{"$f":"IF([1]Personnel!C8=\"\",\"\",VLOOKUP(D5,Grades,2,FALSE))","v":""},"Numéro de matricule:",null,null,null,{"$f":"Intro!H8","v":9223368}]
[]
[null,"Demande une période d'absence"]
[]
[null,"à partir du",null,null,null,null,null,null,null,"à",null,null,null,{"$f":"IF(E9=\"\",\"\",IF(I5<190,\"\",NETWORKDAYS.INTL(E9,E11,[1]Personnel!$N$11,Fériés)))","v":""}]
[]
[null,"jusqu'au",null,null,null,null,null,null,null,"à",null,null,null,{"$f":"IF(E9=\"\",\"\",IF(I5<190,\"\",NETWORKDAYS.INTL(E9,E11,[1]Personnel!$N$11,Fériés)*'[1]Horaire individuel'!T3/'[1]Horaire individuel'!U3))","v":""}]
[]
[null,"Nombre de jours de congé:",null,null,null,null,null,null,null,null,null,null,"jour(s)"]
[]
[null,"Nombre d'heures de compensation:",null,null,null,null,null,null,null,null,null,null,"Hr "]
[]
[null,"Autre:",null,null,null,null,null,null,null,null,null,null,"jour(s)/heure"]
[]
[null,"Remarques éventuelles:"]
[]
[null,"Je séjournerai à l'étranger",null,null,null,null,null,null,null,null,null,null,null,null,"Signature"]
[]
[null,"Pays"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D3=\"\",\"\",\"Sé\")","v":"Sé"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D3","v":"FRASCONE"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D5","v":"ADJ"}]
[]
[null,"Avis du chef de service",null,null,null,null,null,null,null,null,"Favorable"]
[null,null,null,null,null,null,null,null,null,"F",null,null,null,null,{"$f":"IF(J30=\"\",\"\",\"Sé\")","v":"Sé"}]
[null,null,null,null,null,null,null,null,null,null,"Défavorable"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Chef de Sv"]
[]
[null,"Décision de l'autorité:",null,null,null,null,null,null,null,null,"Accordé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J37=\"\",\"\",\"Sé\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Refusé"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Intro!C17","v":"DE KEYZER H.    "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Intro!C18","v":"Comdt    "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Comd d'Unité"]
[]
[]
[]
[null,"Raison du refus"]
[]
[]
[]
[null,"référence : RCU-N°",null,null,null,null,null,"du"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"D5&\" \"&D3","v":"ADJ FRASCONE"}]
[]
[]
[null,"Votre absence du",null,null,null,null,{"$f":"E9+K9","v":"00:00:00"},null,"au ",{"$f":"E11+K11","v":"00:00:00"}]
[null,null,null,null,{"$f":"E10&K10","v":""}]
[]
[null,null,"a été accordée / refusée"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Intro!H17","v":"JODOCY S."}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Intro!H18","v":"Adjt"}]
[null,null,null,null,null,null,null,null,null,null,null,"Adjt d'Unité"]

{"sheet":"Fériés","index":5,"n_rows":169,"n_cols":16,"rows_kept":169,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Jours Fériés",null,null,null,null,null,"Vacance Scolaire BELGE"]
[null,null,null,{"$f":"YEAR(Récup!A11)","v":2024}]
[null,null,null,null,null,null," "]
[null,{"$f":"ROW()-11&\" =\"","v":"-7 ="},null,{"$f":"IF(D$24=\"\",\"\",D5-1)","v":"2019-12-24"},1,{"$f":"IF(An=\"\",\"\",\"  = Noël \"&An-1)","v":"  = Noël 2023"},"= fixe"]
[null,"-6 =",null,"2019-12-25",1,{"$f":"IF(An=\"\",\"\",\"  = Deuxième jour de Noël \"&An-1)","v":"  = Deuxième jour de Noël 2023"},"= fixe"]
[null,"-5 =",null,"2019-12-26",1,{"$f":"IF(An=\"\",\"\",\"  = Fin d'année \"&An-1)","v":"  = Fin d'année 2023"},"= fixe"]
[null,"-4 =",null,"2019-12-27",1,{"$f":"IF(An=\"\",\"\",\"  = Fin d'année \"&An-1)","v":"  = Fin d'année 2023"},"= fixe"]
[null,"-3 =",null,"2019-12-28",1,{"$f":"IF(An=\"\",\"\",\"  = Fin d'année \"&An-1)","v":"  = Fin d'année 2023"},"= fixe"]
[null,"-2 =",null,"2019-12-29",1,{"$f":"IF(An=\"\",\"\",\"  = Fin d'année \"&An-1)","v":"  = Fin d'année 2023"},"= fixe"]
[null,{"$f":"ROW()-11&\" =\"","v":"-1 ="},null,"2019-12-30",1,{"$f":"IF(An=\"\",\"\",\"  = Saint Sylvestre \"&An-1)","v":"  = Saint Sylvestre 2023"},"= fixe",null,null,null,null,null,null,null,null,"SDT"]
[null,{"$f":"ROW()-10&\" =\"","v":"1 ="},null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,1,1))","v":"2019-12-31"},1,{"$f":"IF(An=\"\",\"\",\"  = Nouvelle Année \"&An)","v":"  = Nouvelle Année 2024"},"= fixe",null,null,"Carnaval",{"$f":"(cloche-48)","v":"2020-02-11"},{"$f":"K11+6","v":"2020-02-17"},null,null,null,"1SD"]
[null,{"$f":"ROW()-10&\" =\"","v":"2 ="},null,{"$f":"IF(OR(An<1904,An>2099),\"\",IF(MOD(19*MOD(An,19)+24,30)+MOD(2*MOD(An,4)+4*MOD(An,7)+6*MOD(19*MOD(An,19)+24,30)+5,7)-9<=0,DATE(An,3,22+MOD(19*MOD(An,19)+24,30)+MOD(2*MOD(An,4)+4*MOD(An,7)+6*MOD(19*MOD(An,19)+24,30)+5,7)),DATE(An,4,MOD(19*MOD(An,19)+24,30)+MOD(2*MOD(An,4)+4*MOD(An,7)+6*MOD(19*MOD(An,19)+24,30)+5,7)-9)))","v":"2020-03-30"},1,{"$f":"IF(An=\"\",\"\",\"  = Pâques \"&An)","v":"  = Pâques 2024"},"= variable",null,null,"Pâques",{"$f":"IF(MONTH(cloche)=3,cloche+1,IF(MONTH(cloche)=4,IF(DAY(cloche)>15,cloche-13,IF(MONTH(cloche)=4,DATE(An,4,1)+2-WEEKDAY(DATE(An,4,1))+(2<WEEKDAY(DATE(An,4,1)))*7))))","v":"2020-03-31"},{"$f":"K12+13","v":"2020-04-13"},null,null,null,"CPL"]
[null,"3 =",null,{"$f":"IF(OR(An<1904,An>2099),\"\",cloche+1)","v":"2020-03-31"},1,{"$f":"IF(An=\"\",\"\",\"  = Lundi de Pâques\")","v":"  = Lundi de Pâques"},"= variable",null,null,"Eté",{"$f":"DATE(An,7,1)","v":"2020-06-30"},{"$f":"DATE(An,8,31)","v":"2020-08-30"},null,null,null,"CLC"]
[null,"4 =",null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,4,15))","v":"2020-04-14"},1,{"$f":"IF(An=\"\",\"\",IF(An<1960,\"\",IF(An<2013,CONCATENATE(\"  = Philippe de Belgique\",\" ( \",DATEDIF(20559,D14,\"y\")&\" ans\",\")\"),CONCATENATE(\"  = Anniversaire du roi\",\" ( \",DATEDIF(20559,D14,\"y\")&\" ans\",\")\"))))","v":"  = Anniversaire du roi ( 64 ans)"},"= fixe",null,null,"Automne",{"$f":"DATE(An,11,1)-WEEKDAY(DATE(An,11,1))+2","v":"2020-10-27"},{"$f":"K14+6","v":"2020-11-02"},null,null,null,"1CC"]
[null,null,null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,5,1))","v":"2020-04-30"},1,{"$f":"IF(An=\"\",\"\",\"  = Fête du Travail\")","v":"  = Fête du Travail"},null,null,null,"Hiver",{"$f":"IF(WEEKDAY(DATE(An,12,25))=7,DATE(An,12,25)+2,DATE(An,12,25)-WEEKDAY(DATE(An,12,25))+2)","v":"2020-12-22"},{"$f":"K15+13","v":"2021-01-04"},null,null,null,"SGT"]
[null,null,null,{"$f":"IF(OR(An<1904,An>2099),\"\",cloche+39)","v":"2020-05-08"},1,{"$f":"IF(An=\"\",\"\",\"  = Ascension\")","v":"  = Ascension"},null,null,null,null,null,null,null,null,null,"1SG"]
[null,null,null,"=SI(OU(An<1904;An>2099);\"\";cloche+40)",null,"=SI(An=\"\";\"\";\"  = vendredi de l'Ascension\")",null,null,null,null,null,null,null,null,null,"1SC"]
[null,null,null,{"$f":"IF(OR(An<1904,An>2099),\"\",cloche+50)","v":"2020-05-19"},1,{"$f":"IF(An=\"\",\"\",\"  = Lundi de Pencôte\")","v":"  = Lundi de Pencôte"},null,null,null,null,null,null,null,null,null,"1SM"]
[null,null,null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,7,21))","v":"2020-07-20"},1,{"$f":"IF(An=\"\",\"\",CONCATENATE(\"  = Fête Nationale\",\" ( \",DATEDIF(202,D19,\"y\")+74&\" ans\",\")\"))","v":"  = Fête Nationale ( 194 ans)"},null,null,null,null,null,null,null,null,null,"ADJ"]
[null,null,null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,8,15))","v":"2020-08-14"},1,{"$f":"IF(An=\"\",\"\",\"  = Assomption\")","v":"  = Assomption"},null,null,null,null,null,null,null,null,null,"ADC"]
[null,null,null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,11,1))","v":"2020-10-31"},1,{"$f":"IF(An=\"\",\"\",\"  = Toussaint\")","v":"  = Toussaint"},null,null,null,null,null,null,null,null,null,"AJM"]
[null,null,null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,11,2))","v":"2020-11-01"},1,{"$f":"IF(An=\"\",\"\",\"  = Jour des Morts\")","v":"  = Jour des Morts"},null,null,null,null,null,null,null,null,null,"SLT"]
[null,"13 =",null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,11,11))","v":"2020-11-10"},1,{"$f":"IF(An=\"\",\"\",IF(An<1918,\"\",CONCATENATE(\"  = Armistice 14-18\",\" ( \",DATEDIF(5428,D23,\"y\")&\" ans\",\")\")))","v":"  = Armistice 14-18 ( 106 ans)"},"= variable",null,null,null,null,null,null,null,null,"1LT"]
[null,"14 =",null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,11,15))","v":"2020-11-14"},1,{"$f":"IF(An=\"\",\"\",\"  = Fête de la Dynastie\")","v":"  = Fête de la Dynastie"},"= variable",null,null,null,null,null,null,null,null,"CPN"]
[null,"15 =",null,{"$f":"IF(OR(An<1904,An>2099),\"\",DATE(An,12,25))","v":"2020-12-24"},1,{"$f":"IF(An=\"\",\"\",\"  = Noël \"&An)","v":"  = Noël 2024"},"= variable",null,null,null,null,null,null,null,null,"CDT"]
[null,"16 =",null,{"$f":"IF(D$24=\"\",\"\",D25+1)","v":"2020-12-25"},1,{"$f":"IF(An=\"\",\"\",\"  = Deuxième jour de Noël \"&An)","v":"  = Deuxième jour de Noël 2024"},"= fixe"]
[null,"17 =",null,"2020-12-26",1,{"$f":"IF(An=\"\",\"\",\"  = Fin d'année \"&An)","v":"  = Fin d'année 2024"},"= fixe"]
[null,"18 =",null,"2020-12-27",1,{"$f":"IF(An=\"\",\"\",\"  = Fin d'année \"&An)","v":"  = Fin d'année 2024"},"= fixe"]
[null,"19 =",null,"2020-12-28",1,{"$f":"IF(An=\"\",\"\",\"  = Fin d'année \"&An)","v":"  = Fin d'année 2024"},"= fixe"]
[null,"20 =",null,"2020-12-29",1,{"$f":"IF(An=\"\",\"\",\"  = Fin d'année \"&An)","v":"  = Fin d'année 2024"},"= fixe"]
[null,"21 =",null,"2020-12-30",1,{"$f":"IF(An=\"\",\"\",\"  = Saint Sylvestre \"&An)","v":"  = Saint Sylvestre 2024"},"= fixe"]
[null,"22 =",null,"2020-12-31",1,{"$f":"IF(An=\"\",\"\",\"  = Nouvelle Année \"&An+1)","v":"  = Nouvelle Année 2025"},"= fixe"]
[null,"23 =",null,{"$f":"IF(OR(An+1<1904,An+1>2099),\"\",IF(MOD(19*MOD(An+1,19)+24,30)+MOD(2*MOD(An+1,4)+4*MOD(An+1,7)+6*MOD(19*MOD(An+1,19)+24,30)+5,7)-9<=0,DATE(An+1,3,22+MOD(19*MOD(An+1,19)+24,30)+MOD(2*MOD(An+1,4)+4*MOD(An+1,7)+6*MOD(19*MOD(An+1,19)+24,30)+5,7)),DATE(An+1,4,MOD(19*MOD(An+1,19)+24,30)+MOD(2*MOD(An+1,4)+4*MOD(An+1,7)+6*MOD(19*MOD(An+1,19)+24,30)+5,7)-9)))","v":"2021-04-19"},1,{"$f":"IF(An=\"\",\"\",\"  = Pâques \"&An+1)","v":"  = Pâques 2025"},"= fixe"]
[]
[null,null,{"$f":"\"Jour de compensation pour l'année \"&An","v":"Jour de compensation pour l'année 2024"}]
[null,null,0]
[null,null,{"$f":"IF(D37=\"\",\"\",MAX(C$36:C36)+1)","v":1},{"$f":"\"15/04/\" & An","v":"15/04/2024"},1,"Anniversaire du Roi","= variable"]
[null,null,{"$f":"IF(D38=\"\",\"\",MAX(C$36:C37)+1)","v":2},{"$f":"\"15/11/\"& An","v":"15/11/2024"},1,"Fêtes de la dynastie","= variable"]
[null,null,{"$f":"IF(D39=\"\",\"\",MAX(C$36:C38)+1)","v":""},null,1,{"$f":"IF(An=\"\",\"\",IF(D39=\"\",\"\",\"  = jour de compensation pour l'année \"&An))","v":""},"= variable"]
[null,null,{"$f":"IF(D40=\"\",\"\",MAX(C$36:C39)+1)","v":""},null,1,"","= variable"]
[null,null,{"$f":"IF(D41=\"\",\"\",MAX(C$36:C40)+1)","v":""},null,1,"","= variable"]
[null,null,{"$f":"IF(D42=\"\",\"\",MAX(C$36:C41)+1)","v":""},null,1,""]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(WEEKDAY(DATE(An-1,12,25))=7,DATE(An-1,12,25)+2,DATE(An-1,12,25)-WEEKDAY(DATE(An-1,12,25))+2)","v":"2019-12-24"}]
[null,null,null,{"$f":"D50+1","v":"2019-12-25"}]
[null,null,null,"2019-12-26"]
[null,null,null,"2019-12-27"]
[null,null,null,"2019-12-28"]
[null,null,null,"2019-12-29"]
[null,null,null,"2019-12-30"]
[null,null,null,"2019-12-31"]
[null,null,null,"2020-01-01"]
[null,null,null,"2020-01-02"]
[null,null,null,"2020-01-03"]
[null,null,null,"2020-01-04"]
[null,null,null,{"$f":"(cloche-48)","v":"2020-02-11"}]
[null,null,null,{"$f":"D62+1","v":"2020-02-12"}]
[null,null,null,{"$f":"D63+1","v":"2020-02-13"}]
[null,null,null,"2020-02-14"]
[null,null,null,"2020-02-15"]
[null,null,null,"2020-02-16"]
[null,null,null,"2020-02-17"]
[null,null,null,{"$f":"IF(MONTH(cloche)=3,cloche+1,IF(MONTH(cloche)=4,IF(DAY(cloche)>15,cloche-13,IF(MONTH(cloche)=4,DATE(An,4,1)+2-WEEKDAY(DATE(An,4,1))+(2<WEEKDAY(DATE(An,4,1)))*7))))","v":"2020-03-31"}]
[null,null,null,{"$f":"D69+1","v":"2020-04-01"}]
[null,null,null,{"$f":"D70+1","v":"2020-04-02"}]
[null,null,null,"2020-04-03"]
[null,null,null,"2020-04-04"]
[null,null,null,"2020-04-05"]
[null,null,null,"2020-04-06"]
[null,null,null,"2020-04-07"]
[null,null,null,"2020-04-08"]
[null,null,null,"2020-04-09"]
[null,null,null,"2020-04-10"]
[null,null,null,"2020-04-11"]
[null,null,null,"2020-04-12"]
[null,null,null,{"$f":"D81+1","v":"2020-04-13"}]
[null,null,null,{"$f":"cloche+39","v":"2020-05-08"}]
[null,null,null,{"$f":"D83+1","v":"2020-05-09"}]
[null,null,null,{"$f":"D84+1","v":"2020-05-10"}]
[null,null,null,{"$f":"D85+1","v":"2020-05-11"}]
[null,null,null,{"$f":"DATE(An,7,1)","v":"2020-06-30"}]
[null,null,null,{"$f":"D87+1","v":"2020-07-01"}]
[null,null,null,"2020-07-02"]
[null,null,null,"2020-07-03"]
[null,null,null,"2020-07-04"]
[null,null,null,"2020-07-05"]
[null,null,null,"2020-07-06"]
[null,null,null,"2020-07-07"]
[null,null,null,"2020-07-08"]
[null,null,null,"2020-07-09"]
[null,null,null,"2020-07-10"]
[null,null,null,"2020-07-11"]
[null,null,null,"2020-07-12"]
[null,null,null,"2020-07-13"]
[null,null,null,"2020-07-14"]
[null,null,null,"2020-07-15"]
[null,null,null,"2020-07-16"]
[null,null,null,"2020-07-17"]
[null,null,null,"2020-07-18"]
[null,null,null,"2020-07-19"]
[null,null,null,"2020-07-20"]
[null,null,null,"2020-07-21"]
[null,null,null,"2020-07-22"]
[null,null,null,"2020-07-23"]
[null,null,null,"2020-07-24"]
[null,null,null,"2020-07-25"]
[null,null,null,"2020-07-26"]
[null,null,null,"2020-07-27"]
[null,null,null,"2020-07-28"]
[null,null,null,"2020-07-29"]
[null,null,null,"2020-07-30"]
[null,null,null,"2020-07-31"]
[null,null,null,"2020-08-01"]
[null,null,null,"2020-08-02"]
[null,null,null,"2020-08-03"]
[null,null,null,"2020-08-04"]
[null,null,null,"2020-08-05"]
[null,null,null,"2020-08-06"]
[null,null,null,"2020-08-07"]
[null,null,null,"2020-08-08"]
[null,null,null,"2020-08-09"]
[null,null,null,"2020-08-10"]
[null,null,null,"2020-08-11"]
[null,null,null,"2020-08-12"]
[null,null,null,"2020-08-13"]
[null,null,null,"2020-08-14"]
[null,null,null,"2020-08-15"]
[null,null,null,"2020-08-16"]
[null,null,null,"2020-08-17"]
[null,null,null,"2020-08-18"]
[null,null,null,"2020-08-19"]
[null,null,null,"2020-08-20"]
[null,null,null,"2020-08-21"]
[null,null,null,"2020-08-22"]
[null,null,null,"2020-08-23"]
[null,null,null,"2020-08-24"]
[null,null,null,"2020-08-25"]
[null,null,null,"2020-08-26"]
[null,null,null,"2020-08-27"]
[null,null,null,"2020-08-28"]
[null,null,null,"2020-08-29"]
[null,null,null,"2020-08-30"]
[null,null,null,{"$f":"DATE(An,11,1)-WEEKDAY(DATE(An,11,1))+2","v":"2020-10-27"}]
[null,null,null,"2020-10-28"]
[null,null,null,"2020-10-29"]
[null,null,null,{"$f":"D151+1","v":"2020-10-30"}]
[null,null,null,"2020-10-31"]
[null,null,null,"2020-11-01"]
[null,null,null,"2020-11-02"]
[null,null,null,{"$f":"IF(WEEKDAY(DATE(An,12,25))=7,DATE(An,12,25)+2,DATE(An,12,25)-WEEKDAY(DATE(An,12,25))+2)","v":"2020-12-22"}]
[null,null,null,"2020-12-23"]
[null,null,null,"2020-12-24"]
[null,null,null,"2020-12-25"]
[null,null,null,"2020-12-26"]
[null,null,null,"2020-12-27"]
[null,null,null,"2020-12-28"]
[null,null,null,"2020-12-29"]
[null,null,null,"2020-12-30"]
[null,null,null,"2020-12-31"]
[null,null,null,"2021-01-01"]
[null,null,null,"2021-01-02"]
[null,null,null,"2021-01-03"]
[null,null,null,"2021-01-04"]

{"sheet":"Sheet1","index":6,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Det Sp","DE KEYZER H.    ","Comdt    ","JODOCY S.","Adjt","Det Tech",{"$f":"VLOOKUP(F1,A1:E2,2,FALSE)","v":"MOAR Y SANCHEZ M,"}]
["Det Tech","MOAR Y SANCHEZ M,","Capt","ANSIAS D,","1SM"]
["EM","DE KEYZER H.    ","Comdt    ","JODOCY S.","Adjt"]