{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Masque","menu general","mensuel p-compta","Model fiche individuelle","A","B","C","D","E"],"not_rendered":{"charts":6,"images":7,"macros":1,"external_links":2,"defined_names":35,"comments":2,"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","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"menu general","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[9,5,9,6],[2,4,2,11]]}
[]
[]
[null,null,null,null,"LE BOUTON AJOUTER ME PERMET DE CREER UNE FICHE DU PERSONNNEL "]
[]
[]
[null,null,null,null,null,null,null,null,null,"--"]
[]
[]
[null,null,null,null,null,2]
[null,null,null,null,"Effectif total",{"$f":"IF(F1=\"  \",\"  \",SUM(COUNTIF(F11:F44,\"spv\"),COUNTIF(F11:F44,\"saisonnier\")))","v":2}]
[null,null,null,null,"Noms_prénoms","spv/saisonnier","équipe"]
[null,null,null,null,"A","svp",1]
[null,null,null,null,"B","saisonnier",2]
[null,null,null,null,"C","svp",3]
[null,null,null,null,"D","saisonnier",4]
[null,null,null,null,"E","svp",5]

{"sheet":"mensuel p-compta","index":2,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[4,8,6,10],[9,0,10,0],[48,0,49,0],[2,2,2,5]]}
[]
[]
[null,null,"ETAT MENSUEL DES SPV DU MOIS DE",null,null,null,"JANVIER"]
[]
[null,"Mission opérationnelle",null,null,null,null,"Astreinte ou",null,"Garde"]
[null,"ou action de formation",null,null,null,null,"action de formation"]
[null,"(formateur)",null,null,null,null,"(stagiaire)"]
["tarif horaire:","taux multiplicateur",null,"taux multiplicateux sous officier"]
[null,"taux multiplicateur",null,"taux multiplicateur homme du rang",null,null,null,null,"taux multiplicateur"]
["NOM","Nbre ","Nbre ","Nbre","Nbre","Nbre de","Nbre heure","Nbre total","Nbre ","Nbre total"]
[null,"de missions","heures","Astreinte ","heure d'astr","formation","formation","heures","garde","heures"]
["A",8,1.5,4,1.8333333333333339,8,1.3333333333333333,"?",4,1.9999999999999993]
["B",null,0,null,0,null,0,"?",0,0]
["C",null,0,null,0,null,0,"?",0,0]
["D",null,0,null,0,null,0,"?",0,0]
["E",7,1.0208333333333333,3,0.5859375,7,1.4583333333333335,"?",4,0.58680555555555614]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[]
[]
[]
[null,null,"Ponérihouen,  Le  "]
[]
[]
[]
[]
[]
["Centre de secours"]
["de PONERIHOUEN"]
[]
[]
["ETAT MENSUEL DES SPP"]
[]
[null,"Mission opérationnelle",null,"Astreinte ou",null,null,null,null,"Garde"]
["Mois de:","ou action de formation",null,"action de formation"]
[null,"(formateur)",null,"(stagiaire)"]
[null,null,null,"heures d'astreinte",null,null,null,12,"heures de garde",null,12]
["tarif horaire","taux multiplicateur",1.2,"taux multiplicateur",null,null,null,0.3,"taux multiplicateur",null,0.4]
["NOM","Nbre ",null,"Nbre",null,null,"Nbre heure","Nbre total","Nbre ","Nbre total"]
[null,"heures",null,"Astreinte ",null,null,"formation","heures","garde","heures"]
["NEMIA",0,null,0,null,null,0,0,0,0]
["OYES",0,null,0,null,null,0,0,0,0]
[null,{"$f":"SUM(B51:B52)","v":0},null,{"$f":"SUM(D51:D52)","v":0},null,null,0,0,0,0,0]

{"sheet":"Model fiche individuelle","index":3,"n_rows":272,"n_cols":23,"rows_kept":272,"cut":false,"hidden":true,"merged":[[31,14,31,15],[31,16,31,17],[28,14,28,15],[28,16,28,17],[29,14,29,15],[29,16,29,17],[30,14,30,15],[30,16,30,17],[25,14,25,15],[25,16,25,17],[26,14,26,15],[26,16,26,17],[27,14,27,15],[27,16,27,17],[22,14,22,15],[22,16,22,17],[23,14,23,15],[23,16,23,17],[24,14,24,15],[24,16,24,17],[19,14,19,15],[19,16,19,17],[20,14,20,15],[20,16,20,17],[21,14,21,15],[21,16,21,17],[18,13,18,17],[0,0,0,2],[0,3,0,5],[1,13,1,23],[2,5,2,6],[2,15,2,16]]}
["Bonjour ! Aujourd'hui est le  ",null,null,{"$f":"TODAY()","v":"2022-02-01"},null,null,null,null,null,null,"menu-général",null,"tableau de bord "]
[null,null,null,"FICHE D'INDEMNITÉ",null,null,null,null,null,null,null,null,null,"RECAPITULATIF DE GARDE ET MISSIONS "]
["Date ","garde/astre","h garde/astr","type inter","n° inter","H inter",null,"formation /stage","h/formation stage",null,null,null,"Année","Mois","nbre de missions","Durée inter",null,"astreinte","heure d'astreintes","nbre de for ou stage","h stage ou formation","nbre de GARDE","T heure de garde "]
[null,null,null,null,null,null,{"$f":"IF(F4=\"\",\" \", ROUNDDOWN(4*F4*24,0)/24/4)","v":" "},null,null,null,null,null,2022,{"$f":"DATE($M$4,ROW()-3,1)","v":"2022-01-01"},null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},{"$f":"SUMIFS(F4:F4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},null,{"$f":"SUMIFS(C4:C4997,B4:B4997,\"ASTRE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0},null,{"$f":"SUMIFS($I$4:I4998,$A$4:A4998,\">=\"&$N$4,$A$4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",null,{"$f":"SUMIFS(G4:G4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMIFS(F4:F4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},null,{"$f":"SUMIFS(C5:C4998,B5:B4998,\"ASTRE\",A5:A4998,\">=\"&N$4,A5:A4998,\"<=\"&EOMONTH(N$4,0))","v":0},null,{"$f":"SUMIFS($I$4:I4999,$A$4:A4999,\">=\"&$N$5,$A$4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=2)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$5,A4:A4997,\"<=\"&EOMONTH(N$5,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,{"$f":"SUMIFS(G4:G5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMIFS(F4:F5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5000,$A$4:A5000,\">=\"&$N$6,$A$4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=M4)*--(MONTH($A$4:A4999)=3)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$6,A4:A4997,\"<=\"&EOMONTH(N$6,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,{"$f":"SUMIFS(G4:G5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMIFS(F4:F5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5001,$A$4:A5001,\">=\"&$N$7,$A$4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=4)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$7,A4:A4997,\"<=\"&EOMONTH(N$7,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,{"$f":"SUMIFS(G4:G5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMIFS(F4:F5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5002,$A$4:A5002,\">=\"&$N$8,$A$4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=$M$4)*--(MONTH($A$4:A4999)=5)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$8,A4:A4997,\"<=\"&EOMONTH(N$8,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$9,A4:A4998,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMIFS(F4:F5003,A4:A5003,\">=\"&$N$9,A4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5003,$A$4:A5003,\">=\"&$N$9,$A$4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5000)=$M$4)*--(MONTH($A$4:A5000)=6)*($B$4:B5000=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$9,A4:A4997,\"<=\"&EOMONTH(N$9,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$10,A4:A4998,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMIFS(F6:F5004,A6:A5004,\">=\"&$N$10,A6:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5004,$A$4:A5004,\">=\"&$N$10,$A$4:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5001)=$M$4)*--(MONTH($A$4:A5001)=7)*($B$4:B5001=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$10,A4:A4997,\"<=\"&EOMONTH(N$10,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$11,A4:A4998,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMIFS(F4:F5005,A4:A5005,\">=\"&$N$11,A4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5005,$A$4:A5005,\">=\"&$N$11,$A$4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5002)=$M$4)*--(MONTH($A$4:A5002)=8)*($B$4:B5002=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$11,A4:A4997,\"<=\"&EOMONTH(N$11,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$12,A4:A4998,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMIFS(F4:F5006,A4:A5006,\">=\"&$N$12,A4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5006,$A$4:A5006,\">=\"&$N$12,$A$4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5003)=$M$4)*--(MONTH($A$4:A5003)=9)*($B$4:B5003=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$12,A4:A4997,\"<=\"&EOMONTH(N$12,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$13,A4:A4998,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMIFS(F4:F5007,A4:A5007,\">=\"&$N$13,A4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5007,$A$4:A5007,\">=\"&$N$13,$A$4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5004)=$M$4)*--(MONTH($A$4:A5004)=10)*($B$4:B5004=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$13,A4:A4997,\"<=\"&EOMONTH(N$13,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$14,A4:A4998,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMIFS(F4:F5008,A4:A5008,\">=\"&$N$14,A4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5008,$A$4:A5008,\">=\"&$N$14,$A$4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5005)=$M$4)*--(MONTH($A$4:A5005)=11)*($B$4:B5005=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$14,A4:A4997,\"<=\"&EOMONTH(N$14,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$15,A4:A4998,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMIFS(F4:F5009,A4:A5009,\">=\"&$N$15,A4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5009,$A$4:A5009,\">=\"&$N$15,$A$4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=$M$4)*--(MONTH($A$4:A4997)=12)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C5008,B4:B5008,\"GARDE\",A4:A5008,\">=\"&N$15,A4:A5008,\"<=\"&EOMONTH(N$15,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"TOTAL",{"$f":"SUM(O4:O15)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"PRÉVISIONS DE GARDE "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"MOIS ","NBRE DE GARDE",null,"HEURE TOTAL"]
[null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"DATE($M$4,ROW()-20,1)","v":"2022-01-01"},null,null,{"$f":"IF(O21=\"\",\"\",O21)","v":""}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",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,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," "]
[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,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,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,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,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,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," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F68=\"\",\" \", ROUNDDOWN(4*F68*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F132=\"\",\" \", ROUNDDOWN(4*F132*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F196=\"\",\" \", ROUNDDOWN(4*F196*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F260=\"\",\" \", ROUNDDOWN(4*F260*24,0)/24/4)","v":" "}]
[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,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,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"A","index":4,"n_rows":272,"n_cols":23,"rows_kept":272,"cut":false,"hidden":false,"merged":[[31,14,31,15],[31,16,31,17],[28,14,28,15],[28,16,28,17],[29,14,29,15],[29,16,29,17],[30,14,30,15],[30,16,30,17],[25,14,25,15],[25,16,25,17],[26,14,26,15],[26,16,26,17],[27,14,27,15],[27,16,27,17],[22,14,22,15],[22,16,22,17],[23,14,23,15],[23,16,23,17],[24,14,24,15],[24,16,24,17],[19,14,19,15],[19,16,19,17],[20,14,20,15],[20,16,20,17],[21,14,21,15],[21,16,21,17],[18,13,18,17],[0,0,0,2],[0,3,0,5],[1,13,1,23],[2,5,2,6],[2,15,2,16]]}
["Bonjour ! Aujourd'hui est le  ",null,null,{"$f":"TODAY()","v":"2022-02-01"},null,null,null,null,null,null,"menu-général",null,"tableau de bord "]
[null,null,null,"FICHE D'INDEMNITÉ",null,null,null,null,null,null,null,null,null,"RECAPITULATIF DE GARDE ET MISSIONS "]
["Date ","garde/astre","h garde/astr","type inter","n° inter","H inter",null,"formation /stage","h/formation stage",null,null,null,"Année","Mois","nbre de missions","Durée inter",null,"astreinte","heure d'astreintes","nbre de for ou stage","h stage ou formation","nbre de GARDE","T heure de garde "]
["2022-01-01","Garde",0.33333333333333331,"a",1,"01:00:00",{"$f":"IF(F4=\"\",\" \", ROUNDDOWN(4*F4*24,0)/24/4)","v":"01:00:00"},1,2.0833333333333332E-2,null,null,null,2022,{"$f":"DATE($M$4,ROW()-3,1)","v":"2022-01-01"},8,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":1.5},{"$f":"SUMIFS(F4:F4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":1.5},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($B$4:B4997=\"Astre\"))","v":4},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"ASTRE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":1.8333333333333339},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($H$4:H4997<>\"\"))","v":8},{"$f":"SUMIFS($I$4:I4998,$A$4:A4998,\">=\"&$N$4,$A$4:A4998,\"<=\"&EOMONTH($N$4,0))","v":1.3333333333333333},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($B$4:B4997=\"GARDE\"))","v":4},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":1.9999999999999993}]
["2022-01-02","Astre",0.375,"b",2,"02:00:00","02:00:00",2,6.25E-2,null,null,null,null,"2022-02-01",null,{"$f":"SUMIFS(G4:G4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMIFS(F4:F4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},null,{"$f":"SUMIFS(C5:C4998,B5:B4998,\"ASTRE\",A5:A4998,\">=\"&N$4,A5:A4998,\"<=\"&EOMONTH(N$4,0))","v":1.8333333333333339},null,{"$f":"SUMIFS($I$4:I4999,$A$4:A4999,\">=\"&$N$5,$A$4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=2)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$5,A4:A4997,\"<=\"&EOMONTH(N$5,0))","v":0}]
["2022-01-03","Astre",0.41666666666666702,"a",3,"03:00:00","03:00:00",3,0.104166666666667,null,null,null,null,"2022-03-01",null,{"$f":"SUMIFS(G4:G5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMIFS(F4:F5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},null,1.4583333333333339,null,{"$f":"SUMIFS($I$4:I5000,$A$4:A5000,\">=\"&$N$6,$A$4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=M4)*--(MONTH($A$4:A4999)=3)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$6,A4:A4997,\"<=\"&EOMONTH(N$6,0))","v":0}]
["2022-01-04","Garde",0.45833333333333298,"b",4,"04:00:00","04:00:00",4,0.14583333333333301,null,null,null,null,"2022-04-01",null,{"$f":"SUMIFS(G4:G5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMIFS(F4:F5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},null,1.041666666666667,null,{"$f":"SUMIFS($I$4:I5001,$A$4:A5001,\">=\"&$N$7,$A$4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=4)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$7,A4:A4997,\"<=\"&EOMONTH(N$7,0))","v":0}]
["2022-01-05","Astre",0.5,"a",5,"05:00:00","05:00:00",5,0.1875,null,null,null,null,"2022-05-01",null,{"$f":"SUMIFS(G4:G5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMIFS(F4:F5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},null,1.041666666666667,null,{"$f":"SUMIFS($I$4:I5002,$A$4:A5002,\">=\"&$N$8,$A$4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=$M$4)*--(MONTH($A$4:A4999)=5)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$8,A4:A4997,\"<=\"&EOMONTH(N$8,0))","v":0}]
["2022-01-06","Astre",0.54166666666666696,"b",6,"06:00:00","06:00:00",6,0.22916666666666699,null,null,null,null,"2022-06-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$9,A4:A4998,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMIFS(F4:F5003,A4:A5003,\">=\"&$N$9,A4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},null,0.54166666666666696,null,{"$f":"SUMIFS($I$4:I5003,$A$4:A5003,\">=\"&$N$9,$A$4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5000)=$M$4)*--(MONTH($A$4:A5000)=6)*($B$4:B5000=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$9,A4:A4997,\"<=\"&EOMONTH(N$9,0))","v":0}]
["2022-01-07","Garde",0.58333333333333304,"a",7,"07:00:00","07:00:00",7,0.27083333333333298,null,null,null,null,"2022-07-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$10,A4:A4998,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMIFS(F6:F5004,A6:A5004,\">=\"&$N$10,A6:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5004,$A$4:A5004,\">=\"&$N$10,$A$4:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5001)=$M$4)*--(MONTH($A$4:A5001)=7)*($B$4:B5001=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$10,A4:A4997,\"<=\"&EOMONTH(N$10,0))","v":0}]
["2022-01-08","Garde",0.625,"b",8,"08:00:00","08:00:00",8,0.3125,null,null,null,null,"2022-08-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$11,A4:A4998,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMIFS(F4:F5005,A4:A5005,\">=\"&$N$11,A4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5005,$A$4:A5005,\">=\"&$N$11,$A$4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5002)=$M$4)*--(MONTH($A$4:A5002)=8)*($B$4:B5002=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$11,A4:A4997,\"<=\"&EOMONTH(N$11,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$12,A4:A4998,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMIFS(F4:F5006,A4:A5006,\">=\"&$N$12,A4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5006,$A$4:A5006,\">=\"&$N$12,$A$4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5003)=$M$4)*--(MONTH($A$4:A5003)=9)*($B$4:B5003=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$12,A4:A4997,\"<=\"&EOMONTH(N$12,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$13,A4:A4998,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMIFS(F4:F5007,A4:A5007,\">=\"&$N$13,A4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5007,$A$4:A5007,\">=\"&$N$13,$A$4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5004)=$M$4)*--(MONTH($A$4:A5004)=10)*($B$4:B5004=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$13,A4:A4997,\"<=\"&EOMONTH(N$13,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$14,A4:A4998,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMIFS(F4:F5008,A4:A5008,\">=\"&$N$14,A4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5008,$A$4:A5008,\">=\"&$N$14,$A$4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5005)=$M$4)*--(MONTH($A$4:A5005)=11)*($B$4:B5005=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$14,A4:A4997,\"<=\"&EOMONTH(N$14,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$15,A4:A4998,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMIFS(F4:F5009,A4:A5009,\">=\"&$N$15,A4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5009,$A$4:A5009,\">=\"&$N$15,$A$4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=$M$4)*--(MONTH($A$4:A4997)=12)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C5008,B4:B5008,\"GARDE\",A4:A5008,\">=\"&N$15,A4:A5008,\"<=\"&EOMONTH(N$15,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"TOTAL",{"$f":"SUM(O4:O15)","v":8},1.5,1.5,4,7.7500000000000027,8,1.3333333333333333,4,1.9999999999999993]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"PRÉVISIONS DE GARDE "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"MOIS ","NBRE DE GARDE",null,"HEURE TOTAL"]
[null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"DATE($M$4,ROW()-20,1)","v":"2022-01-01"},null,null,{"$f":"IF(O21=\"\",\"\",O21)","v":""}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",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,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," "]
[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,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,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,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,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,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," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F68=\"\",\" \", ROUNDDOWN(4*F68*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F132=\"\",\" \", ROUNDDOWN(4*F132*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F196=\"\",\" \", ROUNDDOWN(4*F196*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F260=\"\",\" \", ROUNDDOWN(4*F260*24,0)/24/4)","v":" "}]
[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,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,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"B","index":5,"n_rows":272,"n_cols":23,"rows_kept":272,"cut":false,"hidden":false,"merged":[[31,14,31,15],[31,16,31,17],[28,14,28,15],[28,16,28,17],[29,14,29,15],[29,16,29,17],[30,14,30,15],[30,16,30,17],[25,14,25,15],[25,16,25,17],[26,14,26,15],[26,16,26,17],[27,14,27,15],[27,16,27,17],[22,14,22,15],[22,16,22,17],[23,14,23,15],[23,16,23,17],[24,14,24,15],[24,16,24,17],[19,14,19,15],[19,16,19,17],[20,14,20,15],[20,16,20,17],[21,14,21,15],[21,16,21,17],[18,13,18,17],[0,0,0,2],[0,3,0,5],[1,13,1,23],[2,5,2,6],[2,15,2,16]]}
["Bonjour ! Aujourd'hui est le  ",null,null,{"$f":"TODAY()","v":"2022-02-01"},null,null,null,null,null,null,"menu-général",null,"tableau de bord "]
[null,null,null,"FICHE D'INDEMNITÉ",null,null,null,null,null,null,null,null,null,"RECAPITULATIF DE GARDE ET MISSIONS "]
["Date ","garde/astre","h garde/astr","type inter","n° inter","H inter",null,"formation /stage","h/formation stage",null,null,null,"Année","Mois","nbre de missions","Durée inter",null,"astreinte","heure d'astreintes","nbre de for ou stage","h stage ou formation","nbre de GARDE","T heure de garde "]
[null,null,null,null,null,null,{"$f":"IF(F4=\"\",\" \", ROUNDDOWN(4*F4*24,0)/24/4)","v":" "},null,null,null,null,null,2022,{"$f":"DATE($M$4,ROW()-3,1)","v":"2022-01-01"},null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},{"$f":"SUMIFS(F4:F4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},1,{"$f":"SUMIFS(C4:C4997,B4:B4997,\"ASTRE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0},1,{"$f":"SUMIFS($I$4:I4998,$A$4:A4998,\">=\"&$N$4,$A$4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",1,{"$f":"SUMIFS(G4:G4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMIFS(F4:F4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},null,{"$f":"SUMIFS(C5:C4998,B5:B4998,\"ASTRE\",A5:A4998,\">=\"&N$4,A5:A4998,\"<=\"&EOMONTH(N$4,0))","v":0},null,{"$f":"SUMIFS($I$4:I4999,$A$4:A4999,\">=\"&$N$5,$A$4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=2)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$5,A4:A4997,\"<=\"&EOMONTH(N$5,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,{"$f":"SUMIFS(G4:G5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMIFS(F4:F5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5000,$A$4:A5000,\">=\"&$N$6,$A$4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=M4)*--(MONTH($A$4:A4999)=3)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$6,A4:A4997,\"<=\"&EOMONTH(N$6,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,{"$f":"SUMIFS(G4:G5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMIFS(F4:F5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5001,$A$4:A5001,\">=\"&$N$7,$A$4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=4)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$7,A4:A4997,\"<=\"&EOMONTH(N$7,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,{"$f":"SUMIFS(G4:G5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMIFS(F4:F5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5002,$A$4:A5002,\">=\"&$N$8,$A$4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=$M$4)*--(MONTH($A$4:A4999)=5)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$8,A4:A4997,\"<=\"&EOMONTH(N$8,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$9,A4:A4998,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMIFS(F4:F5003,A4:A5003,\">=\"&$N$9,A4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5003,$A$4:A5003,\">=\"&$N$9,$A$4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5000)=$M$4)*--(MONTH($A$4:A5000)=6)*($B$4:B5000=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$9,A4:A4997,\"<=\"&EOMONTH(N$9,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$10,A4:A4998,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMIFS(F6:F5004,A6:A5004,\">=\"&$N$10,A6:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5004,$A$4:A5004,\">=\"&$N$10,$A$4:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5001)=$M$4)*--(MONTH($A$4:A5001)=7)*($B$4:B5001=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$10,A4:A4997,\"<=\"&EOMONTH(N$10,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$11,A4:A4998,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMIFS(F4:F5005,A4:A5005,\">=\"&$N$11,A4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5005,$A$4:A5005,\">=\"&$N$11,$A$4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5002)=$M$4)*--(MONTH($A$4:A5002)=8)*($B$4:B5002=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$11,A4:A4997,\"<=\"&EOMONTH(N$11,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$12,A4:A4998,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMIFS(F4:F5006,A4:A5006,\">=\"&$N$12,A4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5006,$A$4:A5006,\">=\"&$N$12,$A$4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5003)=$M$4)*--(MONTH($A$4:A5003)=9)*($B$4:B5003=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$12,A4:A4997,\"<=\"&EOMONTH(N$12,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$13,A4:A4998,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMIFS(F4:F5007,A4:A5007,\">=\"&$N$13,A4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5007,$A$4:A5007,\">=\"&$N$13,$A$4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5004)=$M$4)*--(MONTH($A$4:A5004)=10)*($B$4:B5004=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$13,A4:A4997,\"<=\"&EOMONTH(N$13,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$14,A4:A4998,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMIFS(F4:F5008,A4:A5008,\">=\"&$N$14,A4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5008,$A$4:A5008,\">=\"&$N$14,$A$4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5005)=$M$4)*--(MONTH($A$4:A5005)=11)*($B$4:B5005=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$14,A4:A4997,\"<=\"&EOMONTH(N$14,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$15,A4:A4998,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMIFS(F4:F5009,A4:A5009,\">=\"&$N$15,A4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5009,$A$4:A5009,\">=\"&$N$15,$A$4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=$M$4)*--(MONTH($A$4:A4997)=12)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C5008,B4:B5008,\"GARDE\",A4:A5008,\">=\"&N$15,A4:A5008,\"<=\"&EOMONTH(N$15,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"TOTAL",{"$f":"SUM(O4:O15)","v":1},0,0,1,0,1,0,0,0]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"PRÉVISIONS DE GARDE "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"MOIS ","NBRE DE GARDE",null,"HEURE TOTAL"]
[null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"DATE($M$4,ROW()-20,1)","v":"2022-01-01"},null,null,{"$f":"IF(O21=\"\",\"\",O21)","v":""}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",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,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," "]
[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,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,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,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,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,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," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F68=\"\",\" \", ROUNDDOWN(4*F68*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F132=\"\",\" \", ROUNDDOWN(4*F132*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F196=\"\",\" \", ROUNDDOWN(4*F196*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F260=\"\",\" \", ROUNDDOWN(4*F260*24,0)/24/4)","v":" "}]
[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,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,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"C","index":6,"n_rows":272,"n_cols":23,"rows_kept":272,"cut":false,"hidden":false,"merged":[[31,14,31,15],[31,16,31,17],[28,14,28,15],[28,16,28,17],[29,14,29,15],[29,16,29,17],[30,14,30,15],[30,16,30,17],[25,14,25,15],[25,16,25,17],[26,14,26,15],[26,16,26,17],[27,14,27,15],[27,16,27,17],[22,14,22,15],[22,16,22,17],[23,14,23,15],[23,16,23,17],[24,14,24,15],[24,16,24,17],[19,14,19,15],[19,16,19,17],[20,14,20,15],[20,16,20,17],[21,14,21,15],[21,16,21,17],[18,13,18,17],[0,0,0,2],[0,3,0,5],[1,13,1,23],[2,5,2,6],[2,15,2,16]]}
["Bonjour ! Aujourd'hui est le  ",null,null,{"$f":"TODAY()","v":"2022-02-01"},null,null,null,null,null,null,"menu-général",null,"tableau de bord "]
[null,null,null,"FICHE D'INDEMNITÉ",null,null,null,null,null,null,null,null,null,"RECAPITULATIF DE GARDE ET MISSIONS "]
["Date ","garde/astre","h garde/astr","type inter","n° inter","H inter",null,"formation /stage","h/formation stage",null,null,null,"Année","Mois","nbre de missions","Durée inter",null,"astreinte","heure d'astreintes","nbre de for ou stage","h stage ou formation","nbre de GARDE","T heure de garde "]
[null,null,null,null,null,null,{"$f":"IF(F4=\"\",\" \", ROUNDDOWN(4*F4*24,0)/24/4)","v":" "},null,null,null,null,null,2022,{"$f":"DATE($M$4,ROW()-3,1)","v":"2022-01-01"},1,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},{"$f":"SUMIFS(F4:F4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},null,{"$f":"SUMIFS(C4:C4997,B4:B4997,\"ASTRE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0},null,{"$f":"SUMIFS($I$4:I4998,$A$4:A4998,\">=\"&$N$4,$A$4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",null,{"$f":"SUMIFS(G4:G4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMIFS(F4:F4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},null,{"$f":"SUMIFS(C5:C4998,B5:B4998,\"ASTRE\",A5:A4998,\">=\"&N$4,A5:A4998,\"<=\"&EOMONTH(N$4,0))","v":0},null,{"$f":"SUMIFS($I$4:I4999,$A$4:A4999,\">=\"&$N$5,$A$4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=2)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$5,A4:A4997,\"<=\"&EOMONTH(N$5,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,{"$f":"SUMIFS(G4:G5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMIFS(F4:F5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5000,$A$4:A5000,\">=\"&$N$6,$A$4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=M4)*--(MONTH($A$4:A4999)=3)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$6,A4:A4997,\"<=\"&EOMONTH(N$6,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,{"$f":"SUMIFS(G4:G5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMIFS(F4:F5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5001,$A$4:A5001,\">=\"&$N$7,$A$4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=4)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$7,A4:A4997,\"<=\"&EOMONTH(N$7,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,{"$f":"SUMIFS(G4:G5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMIFS(F4:F5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5002,$A$4:A5002,\">=\"&$N$8,$A$4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=$M$4)*--(MONTH($A$4:A4999)=5)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$8,A4:A4997,\"<=\"&EOMONTH(N$8,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$9,A4:A4998,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMIFS(F4:F5003,A4:A5003,\">=\"&$N$9,A4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5003,$A$4:A5003,\">=\"&$N$9,$A$4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5000)=$M$4)*--(MONTH($A$4:A5000)=6)*($B$4:B5000=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$9,A4:A4997,\"<=\"&EOMONTH(N$9,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$10,A4:A4998,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMIFS(F6:F5004,A6:A5004,\">=\"&$N$10,A6:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5004,$A$4:A5004,\">=\"&$N$10,$A$4:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5001)=$M$4)*--(MONTH($A$4:A5001)=7)*($B$4:B5001=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$10,A4:A4997,\"<=\"&EOMONTH(N$10,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$11,A4:A4998,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMIFS(F4:F5005,A4:A5005,\">=\"&$N$11,A4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5005,$A$4:A5005,\">=\"&$N$11,$A$4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5002)=$M$4)*--(MONTH($A$4:A5002)=8)*($B$4:B5002=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$11,A4:A4997,\"<=\"&EOMONTH(N$11,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$12,A4:A4998,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMIFS(F4:F5006,A4:A5006,\">=\"&$N$12,A4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5006,$A$4:A5006,\">=\"&$N$12,$A$4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5003)=$M$4)*--(MONTH($A$4:A5003)=9)*($B$4:B5003=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$12,A4:A4997,\"<=\"&EOMONTH(N$12,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$13,A4:A4998,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMIFS(F4:F5007,A4:A5007,\">=\"&$N$13,A4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5007,$A$4:A5007,\">=\"&$N$13,$A$4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5004)=$M$4)*--(MONTH($A$4:A5004)=10)*($B$4:B5004=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$13,A4:A4997,\"<=\"&EOMONTH(N$13,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$14,A4:A4998,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMIFS(F4:F5008,A4:A5008,\">=\"&$N$14,A4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5008,$A$4:A5008,\">=\"&$N$14,$A$4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5005)=$M$4)*--(MONTH($A$4:A5005)=11)*($B$4:B5005=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$14,A4:A4997,\"<=\"&EOMONTH(N$14,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$15,A4:A4998,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMIFS(F4:F5009,A4:A5009,\">=\"&$N$15,A4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5009,$A$4:A5009,\">=\"&$N$15,$A$4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=$M$4)*--(MONTH($A$4:A4997)=12)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C5008,B4:B5008,\"GARDE\",A4:A5008,\">=\"&N$15,A4:A5008,\"<=\"&EOMONTH(N$15,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"TOTAL",{"$f":"SUM(O4:O15)","v":1},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"PRÉVISIONS DE GARDE "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"MOIS ","NBRE DE GARDE",null,"HEURE TOTAL"]
[null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"DATE($M$4,ROW()-20,1)","v":"2022-01-01"},null,null,{"$f":"IF(O21=\"\",\"\",O21)","v":""}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",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,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," "]
[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,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,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,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,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,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," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F68=\"\",\" \", ROUNDDOWN(4*F68*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F132=\"\",\" \", ROUNDDOWN(4*F132*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F196=\"\",\" \", ROUNDDOWN(4*F196*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F260=\"\",\" \", ROUNDDOWN(4*F260*24,0)/24/4)","v":" "}]
[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,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,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"D","index":7,"n_rows":272,"n_cols":23,"rows_kept":272,"cut":false,"hidden":false,"merged":[[31,14,31,15],[31,16,31,17],[28,14,28,15],[28,16,28,17],[29,14,29,15],[29,16,29,17],[30,14,30,15],[30,16,30,17],[25,14,25,15],[25,16,25,17],[26,14,26,15],[26,16,26,17],[27,14,27,15],[27,16,27,17],[22,14,22,15],[22,16,22,17],[23,14,23,15],[23,16,23,17],[24,14,24,15],[24,16,24,17],[19,14,19,15],[19,16,19,17],[20,14,20,15],[20,16,20,17],[21,14,21,15],[21,16,21,17],[18,13,18,17],[0,0,0,2],[0,3,0,5],[1,13,1,23],[2,5,2,6],[2,15,2,16]]}
["Bonjour ! Aujourd'hui est le  ",null,null,{"$f":"TODAY()","v":"2022-02-01"},null,null,null,null,null,null,"menu-général",null,"tableau de bord "]
[null,null,null,"FICHE D'INDEMNITÉ",null,null,null,null,null,null,null,null,null,"RECAPITULATIF DE GARDE ET MISSIONS "]
["Date ","garde/astre","h garde/astr","type inter","n° inter","H inter",null,"formation /stage","h/formation stage",null,null,null,"Année","Mois","nbre de missions","Durée inter",null,"astreinte","heure d'astreintes","nbre de for ou stage","h stage ou formation","nbre de GARDE","T heure de garde "]
[null,null,null,null,null,null,{"$f":"IF(F4=\"\",\" \", ROUNDDOWN(4*F4*24,0)/24/4)","v":" "},null,null,null,null,null,2022,{"$f":"DATE($M$4,ROW()-3,1)","v":"2022-01-01"},null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},{"$f":"SUMIFS(F4:F4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},null,{"$f":"SUMIFS(C4:C4997,B4:B4997,\"ASTRE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0},null,{"$f":"SUMIFS($I$4:I4998,$A$4:A4998,\">=\"&$N$4,$A$4:A4998,\"<=\"&EOMONTH($N$4,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",null,{"$f":"SUMIFS(G4:G4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMIFS(F4:F4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},null,{"$f":"SUMIFS(C5:C4998,B5:B4998,\"ASTRE\",A5:A4998,\">=\"&N$4,A5:A4998,\"<=\"&EOMONTH(N$4,0))","v":0},null,{"$f":"SUMIFS($I$4:I4999,$A$4:A4999,\">=\"&$N$5,$A$4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=2)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$5,A4:A4997,\"<=\"&EOMONTH(N$5,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,{"$f":"SUMIFS(G4:G5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMIFS(F4:F5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5000,$A$4:A5000,\">=\"&$N$6,$A$4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=M4)*--(MONTH($A$4:A4999)=3)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$6,A4:A4997,\"<=\"&EOMONTH(N$6,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,{"$f":"SUMIFS(G4:G5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMIFS(F4:F5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5001,$A$4:A5001,\">=\"&$N$7,$A$4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=4)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$7,A4:A4997,\"<=\"&EOMONTH(N$7,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,{"$f":"SUMIFS(G4:G5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMIFS(F4:F5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5002,$A$4:A5002,\">=\"&$N$8,$A$4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=$M$4)*--(MONTH($A$4:A4999)=5)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$8,A4:A4997,\"<=\"&EOMONTH(N$8,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$9,A4:A4998,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMIFS(F4:F5003,A4:A5003,\">=\"&$N$9,A4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5003,$A$4:A5003,\">=\"&$N$9,$A$4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5000)=$M$4)*--(MONTH($A$4:A5000)=6)*($B$4:B5000=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$9,A4:A4997,\"<=\"&EOMONTH(N$9,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$10,A4:A4998,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMIFS(F6:F5004,A6:A5004,\">=\"&$N$10,A6:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5004,$A$4:A5004,\">=\"&$N$10,$A$4:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5001)=$M$4)*--(MONTH($A$4:A5001)=7)*($B$4:B5001=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$10,A4:A4997,\"<=\"&EOMONTH(N$10,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$11,A4:A4998,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMIFS(F4:F5005,A4:A5005,\">=\"&$N$11,A4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5005,$A$4:A5005,\">=\"&$N$11,$A$4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5002)=$M$4)*--(MONTH($A$4:A5002)=8)*($B$4:B5002=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$11,A4:A4997,\"<=\"&EOMONTH(N$11,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$12,A4:A4998,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMIFS(F4:F5006,A4:A5006,\">=\"&$N$12,A4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5006,$A$4:A5006,\">=\"&$N$12,$A$4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5003)=$M$4)*--(MONTH($A$4:A5003)=9)*($B$4:B5003=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$12,A4:A4997,\"<=\"&EOMONTH(N$12,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$13,A4:A4998,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMIFS(F4:F5007,A4:A5007,\">=\"&$N$13,A4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5007,$A$4:A5007,\">=\"&$N$13,$A$4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5004)=$M$4)*--(MONTH($A$4:A5004)=10)*($B$4:B5004=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$13,A4:A4997,\"<=\"&EOMONTH(N$13,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$14,A4:A4998,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMIFS(F4:F5008,A4:A5008,\">=\"&$N$14,A4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5008,$A$4:A5008,\">=\"&$N$14,$A$4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5005)=$M$4)*--(MONTH($A$4:A5005)=11)*($B$4:B5005=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$14,A4:A4997,\"<=\"&EOMONTH(N$14,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$15,A4:A4998,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMIFS(F4:F5009,A4:A5009,\">=\"&$N$15,A4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5009,$A$4:A5009,\">=\"&$N$15,$A$4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=$M$4)*--(MONTH($A$4:A4997)=12)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C5008,B4:B5008,\"GARDE\",A4:A5008,\">=\"&N$15,A4:A5008,\"<=\"&EOMONTH(N$15,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"TOTAL",{"$f":"SUM(O4:O15)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"PRÉVISIONS DE GARDE "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"MOIS ","NBRE DE GARDE",null,"HEURE TOTAL"]
[null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"DATE($M$4,ROW()-20,1)","v":"2022-01-01"},null,null,{"$f":"IF(O21=\"\",\"\",O21)","v":""}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",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,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," "]
[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,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,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,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,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,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," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F68=\"\",\" \", ROUNDDOWN(4*F68*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F132=\"\",\" \", ROUNDDOWN(4*F132*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F196=\"\",\" \", ROUNDDOWN(4*F196*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F260=\"\",\" \", ROUNDDOWN(4*F260*24,0)/24/4)","v":" "}]
[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,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,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"E","index":8,"n_rows":272,"n_cols":23,"rows_kept":272,"cut":false,"hidden":false,"merged":[[31,14,31,15],[31,16,31,17],[28,14,28,15],[28,16,28,17],[29,14,29,15],[29,16,29,17],[30,14,30,15],[30,16,30,17],[25,14,25,15],[25,16,25,17],[26,14,26,15],[26,16,26,17],[27,14,27,15],[27,16,27,17],[22,14,22,15],[22,16,22,17],[23,14,23,15],[23,16,23,17],[24,14,24,15],[24,16,24,17],[19,14,19,15],[19,16,19,17],[20,14,20,15],[20,16,20,17],[21,14,21,15],[21,16,21,17],[18,13,18,17],[0,0,0,2],[0,3,0,5],[1,13,1,23],[2,5,2,6],[2,15,2,16]]}
["Bonjour ! Aujourd'hui est le  ",null,null,{"$f":"TODAY()","v":"2022-02-01"},null,null,null,null,null,null,"menu-général",null,"tableau de bord "]
[null,null,null,"FICHE D'INDEMNITÉ",null,null,null,null,null,null,null,null,null,"RECAPITULATIF DE GARDE ET MISSIONS "]
["Date ","garde/astre","h garde/astr","type inter","n° inter","H inter",null,"formation /stage","h/formation stage",null,null,null,"Année","Mois","nbre de missions","Durée inter",null,"astreinte","heure d'astreintes","nbre de for ou stage","h stage ou formation","nbre de GARDE","T heure de garde "]
["2022-01-01","Garde",4.2534722222222217E-2,100,1,"00:30:00",{"$f":"IF(F4=\"\",\" \", ROUNDDOWN(4*F4*24,0)/24/4)","v":"00:30:00"},8,8.3333333333333329E-2,null,null,null,2022,{"$f":"DATE($M$4,ROW()-3,1)","v":"2022-01-01"},7,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":1.0208333333333333},{"$f":"SUMIFS(F4:F4998,A4:A4998,\">=\"&$N$4,A4:A4998,\"<=\"&EOMONTH($N$4,0))","v":1.0208333333333333},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($B$4:B4997=\"Astre\"))","v":3},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"ASTRE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0.5859375},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($H$4:H4997<>\"\"))","v":7},{"$f":"SUMIFS($I$4:I4998,$A$4:A4998,\">=\"&$N$4,$A$4:A4998,\"<=\"&EOMONTH($N$4,0))","v":1.4583333333333335},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=M4)*--(MONTH($A$4:A4997)=1)*($B$4:B4997=\"GARDE\"))","v":4},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$4,A4:A4997,\"<=\"&EOMONTH(N$4,0))","v":0.58680555555555614}]
["2022-01-02","Garde",8.4201388888888895E-2,101,2,"01:30:00","01:30:00",9,0.125,null,null,null,null,"2022-02-01",null,{"$f":"SUMIFS(G4:G4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMIFS(F4:F4999,A4:A4999,\">=\"&$N$5,A4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},null,{"$f":"SUMIFS(C5:C4998,B5:B4998,\"ASTRE\",A5:A4998,\">=\"&N$4,A5:A4998,\"<=\"&EOMONTH(N$4,0))","v":0.5859375},null,{"$f":"SUMIFS($I$4:I4999,$A$4:A4999,\">=\"&$N$5,$A$4:A4999,\"<=\"&EOMONTH($N$5,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=1)*($B$4:B4998=\"GARDE\"))","v":4},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$5,A4:A4997,\"<=\"&EOMONTH(N$5,0))","v":0}]
["2022-01-03","Astre",0.125868055555556,102,3,"02:30:00","02:30:00",10,0.16666666666666699,null,null,null,null,"2022-03-01",null,{"$f":"SUMIFS(G4:G5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMIFS(F4:F5000,A4:A5000,\">=\"&$N$6,A4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},null,0.5859375,null,{"$f":"SUMIFS($I$4:I5000,$A$4:A5000,\">=\"&$N$6,$A$4:A5000,\"<=\"&EOMONTH($N$6,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=M4)*--(MONTH($A$4:A4999)=3)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$6,A4:A4997,\"<=\"&EOMONTH(N$6,0))","v":0}]
["2022-01-04","Astre",0.16753472222222199,103,4,"03:30:00","03:30:00",11,0.20833333333333301,null,null,null,null,"2022-04-01",null,{"$f":"SUMIFS(G4:G5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMIFS(F4:F5001,A4:A5001,\">=\"&$N$7,A4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},null,0.46006944444444398,null,{"$f":"SUMIFS($I$4:I5001,$A$4:A5001,\">=\"&$N$7,$A$4:A5001,\"<=\"&EOMONTH($N$7,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4998)=$M$4)*--(MONTH($A$4:A4998)=4)*($B$4:B4998=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$7,A4:A4997,\"<=\"&EOMONTH(N$7,0))","v":0}]
["2022-01-05","Garde",0.20920138888888901,104,5,"04:30:00","04:30:00",12,0.25,null,null,null,null,"2022-05-01",null,{"$f":"SUMIFS(G4:G5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMIFS(F4:F5002,A4:A5002,\">=\"&$N$8,A4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},null,0.29253472222222199,null,{"$f":"SUMIFS($I$4:I5002,$A$4:A5002,\">=\"&$N$8,$A$4:A5002,\"<=\"&EOMONTH($N$8,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4999)=$M$4)*--(MONTH($A$4:A4999)=5)*($B$4:B4999=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$8,A4:A4997,\"<=\"&EOMONTH(N$8,0))","v":0}]
["2022-01-06","Garde",0.25086805555555602,105,6,"05:30:00","05:30:00",13,0.29166666666666702,null,null,null,null,"2022-06-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$9,A4:A4998,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMIFS(F4:F5003,A4:A5003,\">=\"&$N$9,A4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},null,0.29253472222222199,null,{"$f":"SUMIFS($I$4:I5003,$A$4:A5003,\">=\"&$N$9,$A$4:A5003,\"<=\"&EOMONTH($N$9,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5000)=$M$4)*--(MONTH($A$4:A5000)=6)*($B$4:B5000=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$9,A4:A4997,\"<=\"&EOMONTH(N$9,0))","v":0}]
["2022-01-07","Astre",0.29253472222222199,106,7,"06:30:00","06:30:00",14,0.33333333333333298,null,null,null,null,"2022-07-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$10,A4:A4998,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMIFS(F6:F5004,A6:A5004,\">=\"&$N$10,A6:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},null,0.29253472222222199,null,{"$f":"SUMIFS($I$4:I5004,$A$4:A5004,\">=\"&$N$10,$A$4:A5004,\"<=\"&EOMONTH($N$10,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5001)=$M$4)*--(MONTH($A$4:A5001)=7)*($B$4:B5001=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$10,A4:A4997,\"<=\"&EOMONTH(N$10,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$11,A4:A4998,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMIFS(F4:F5005,A4:A5005,\">=\"&$N$11,A4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5005,$A$4:A5005,\">=\"&$N$11,$A$4:A5005,\"<=\"&EOMONTH($N$11,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5002)=$M$4)*--(MONTH($A$4:A5002)=8)*($B$4:B5002=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$11,A4:A4997,\"<=\"&EOMONTH(N$11,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$12,A4:A4998,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMIFS(F4:F5006,A4:A5006,\">=\"&$N$12,A4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5006,$A$4:A5006,\">=\"&$N$12,$A$4:A5006,\"<=\"&EOMONTH($N$12,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5003)=$M$4)*--(MONTH($A$4:A5003)=9)*($B$4:B5003=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$12,A4:A4997,\"<=\"&EOMONTH(N$12,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$13,A4:A4998,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMIFS(F4:F5007,A4:A5007,\">=\"&$N$13,A4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5007,$A$4:A5007,\">=\"&$N$13,$A$4:A5007,\"<=\"&EOMONTH($N$13,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5004)=$M$4)*--(MONTH($A$4:A5004)=10)*($B$4:B5004=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$13,A4:A4997,\"<=\"&EOMONTH(N$13,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$14,A4:A4998,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMIFS(F4:F5008,A4:A5008,\">=\"&$N$14,A4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5008,$A$4:A5008,\">=\"&$N$14,$A$4:A5008,\"<=\"&EOMONTH($N$14,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A5005)=$M$4)*--(MONTH($A$4:A5005)=11)*($B$4:B5005=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C4997,B4:B4997,\"GARDE\",A4:A4997,\">=\"&N$14,A4:A4997,\"<=\"&EOMONTH(N$14,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",null,{"$f":"SUMIFS(G4:G4998,A4:A4998,\">=\"&$N$15,A4:A4998,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMIFS(F4:F5009,A4:A5009,\">=\"&$N$15,A4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},null,0,null,{"$f":"SUMIFS($I$4:I5009,$A$4:A5009,\">=\"&$N$15,$A$4:A5009,\"<=\"&EOMONTH($N$15,0))","v":0},{"$f":"SUMPRODUCT(--(YEAR($A$4:A4997)=$M$4)*--(MONTH($A$4:A4997)=12)*($B$4:B4997=\"GARDE\"))","v":0},{"$f":"SUMIFS(C4:C5008,B4:B5008,\"GARDE\",A4:A5008,\">=\"&N$15,A4:A5008,\"<=\"&EOMONTH(N$15,0))","v":0}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"TOTAL",{"$f":"SUM(O4:O15)","v":7},1.0208333333333333,1.0208333333333333,3,3.0954861111111094,7,1.4583333333333335,8,0.58680555555555614]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"PRÉVISIONS DE GARDE "]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"MOIS ","NBRE DE GARDE",null,"HEURE TOTAL"]
[null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"DATE($M$4,ROW()-20,1)","v":"2022-01-01"},null,null,{"$f":"IF(O21=\"\",\"\",O21)","v":""}]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-02-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-03-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-04-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-05-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-06-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-07-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-08-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-09-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-10-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-11-01",null,null,""]
[null,null,null,null,null,null," ",null,null,null,null,null,null,"2022-12-01",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,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," "]
[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,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,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,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,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,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," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F68=\"\",\" \", ROUNDDOWN(4*F68*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F132=\"\",\" \", ROUNDDOWN(4*F132*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F196=\"\",\" \", ROUNDDOWN(4*F196*24,0)/24/4)","v":" "}]
[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,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,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,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,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,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," "]
[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,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,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,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,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,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," "]
[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,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,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,null,null,null," "]
[null,null,null,null,null,null,{"$f":"IF(F260=\"\",\" \", ROUNDDOWN(4*F260*24,0)/24/4)","v":" "}]
[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,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,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]