{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Interventions","Récap année en cours","Données"],"not_rendered":{"charts":2,"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Interventions","index":0,"n_rows":15,"n_cols":57,"rows_kept":15,"merged":[[0,1,0,15],[0,17,0,27],[0,30,0,41],[0,43,0,54]]}
[null,"INTERVENTIONS",{"$nulls":15},"Inter par base pour stat",{"$nulls":10},"Fait pour stat",null,"nombre d'inter par mois enregistré pour stat",{"$nulls":12},"nombre d'inter par mois réalisé pour stat",{"$nulls":12},"Délais d'inter en heure pour stat"]
[null,"Payant\nCession","Code\nCLIENT","NOM","INTERLOCUTEUR","ADRESSE","TELEPHONE","MATERIEL","OBSERVATION","BASE","DEMANDEUR","DATE D'ACQUISITION","HE","RENDEZ-VOUS","FAIT","FAIT LE…",null,"AN","HE","CH","VE","FO","NA","FG","MZ","ML","CO","DA","Fait",null,"Janv","Fev","Mars","Avr","Mai","Juin","Juil","Aout","Sep","Oct","Nov","Dec",null,"Janv","Fev","Mars","Avr","Mai","Juin","Juil","Aout","Sep","Oct","Nov","Dec"]
[{"$nulls":9},"AN",null,"2015-07-22",null,null,"x","2015-07-22",null,1,{"$nulls":10},1]
[{"$nulls":9},"HE",null,"2015-07-22",{"$nulls":6},1]
[{"$nulls":9},"CH",null,"2015-07-22",null,null,"x",{"$nulls":4},1]
[{"$nulls":9},"VE",null,"2015-07-22",{"$nulls":8},1]
[{"$nulls":9},"FO",null,"2015-07-22",{"$nulls":9},1]
[{"$nulls":9},"NA",null,"2015-07-22",null,null,"x","2015-07-22",{"$nulls":6},1,{"$nulls":5},1]
[{"$nulls":9},"FG",null,"2015-07-22",null,null,"x","2015-07-22",{"$nulls":7},1,{"$nulls":4},1]
[{"$nulls":9},"MZ",null,"2015-07-22",null,null,"x","2015-07-23",{"$nulls":8},1,{"$nulls":3},1]
[{"$nulls":9},"ML",null,"2015-07-22",{"$nulls":13},1]
[{"$nulls":9},"CO",null,"2015-07-22",{"$nulls":14},1]
[{"$nulls":9},"DA",null,"2015-07-22",null,null,"x",{"$nulls":12},1]
[{"$nulls":9},"NA",null,"2015-07-22",{"$nulls":10},1]
[{"$nulls":9},"VE",null,"2015-07-23"]

{"sheet":"Récap année en cours","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"merged":[[0,1,0,7],[2,5,3,5],[2,6,3,7]]}
[null,"STATISTIQUES"]
[]
[null,"Nombre d'intervention total  sur l'année en cours",{"$f":"SUM(Interventions!R:AB)","v":12},null,null,"Délais moyen d'intervention en heures\n(Entre la demande et l'intervention)",{"$f":"SUM(Interventions!BE:BE/'Récap année en cours'!C4)","v":0}]
[null,"Nombre d'intervention réalisé sur l'année en cours",{"$f":"SUM(Interventions!AC:AC)","v":4}]
[]
[null,"Nombre d'intervention total par base"]
[null,"AN",{"$f":"SUM(Interventions!R:R)","v":1}]
[null,"HE",{"$f":"SUM(Interventions!S:S)","v":1}]
[null,"CH",{"$f":"SUM(Interventions!S:S)","v":1}]
[null,"VE",{"$f":"SUM(Interventions!T:T)","v":1}]
[null,"FO",{"$f":"SUM(Interventions!U:U)","v":1}]
[null,"NA",{"$f":"SUM(Interventions!V:V)","v":1}]
[null,"FG",{"$f":"SUM(Interventions!W:W)","v":2}]
[null,"MZ",{"$f":"SUM(Interventions!X:X)","v":1}]
[null,"ML",{"$f":"SUM(Interventions!Y:Y)","v":1}]
[null,"CO",{"$f":"SUM(Interventions!Z:Z)","v":1}]
[null,"DA",{"$f":"SUM(Interventions!AA:AA)","v":1}]
[]
[null,"Nombre d'intervention par mois","Enregistré","Réalisé"]
[null,"JANVIER",{"$f":"SUM(Interventions!AE:AE)","v":0},{"$f":"SUM(Interventions!AR:AR)","v":0}]
[null,"FEVRIER",{"$f":"SUM(Interventions!AF:AF)","v":0},{"$f":"SUM(Interventions!AS:AS)","v":0}]
[null,"MARS",{"$f":"SUM(Interventions!AG:AG)","v":0},{"$f":"SUM(Interventions!AT:AT)","v":0}]
[null,"AVRIL",{"$f":"SUM(Interventions!AH:AH)","v":0},{"$f":"SUM(Interventions!AU:AU)","v":0}]
[null,"MAI",{"$f":"SUM(Interventions!AI:AI)","v":0},{"$f":"SUM(Interventions!AV:AV)","v":0}]
[null,"JUIN",{"$f":"SUM(Interventions!AJ:AJ)","v":0},{"$f":"SUM(Interventions!AW:AW)","v":0}]
[null,"JUILLET",{"$f":"SUM(Interventions!AK:AK)","v":0},{"$f":"SUM(Interventions!AX:AX)","v":0}]
[null,"AOUT",{"$f":"SUM(Interventions!AL:AL)","v":0},{"$f":"SUM(Interventions!AY:AY)","v":0}]
[null,"SEPTEMBRE",{"$f":"SUM(Interventions!AM:AM)","v":0},{"$f":"SUM(Interventions!AZ:AZ)","v":0}]
[null,"OCTOBRE",{"$f":"SUM(Interventions!AN:AN)","v":0},{"$f":"SUM(Interventions!BA:BA)","v":0}]
[null,"NOVEMBRE",{"$f":"SUM(Interventions!AO:AO)","v":0},{"$f":"SUM(Interventions!BB:BB)","v":0}]
[null,"DECEMBRE",{"$f":"SUM(Interventions!AP:AP)","v":0},{"$f":"SUM(Interventions!BC:BC)","v":0}]

{"sheet":"Données","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,7]]}
[]
[null,"JOURS FERIERS de 2015 A 2020"]
[null,"Années",2015,{"$f":"Année+1","v":2016},{"$f":"Année+2","v":2017},{"$f":"Année+3","v":2018},{"$f":"Année+4","v":2019},{"$f":"Année+5","v":2020}]
[null,"Jour de l'An",{"$f":"DATE(Année,1,1)","v":"2015-01-01"},{"$f":"DATE(D3,1,1)","v":"2016-01-01"},{"$f":"DATE(E3,1,1)","v":"2017-01-01"},{"$f":"DATE(F3,1,1)","v":"2018-01-01"},{"$f":"DATE(G3,1,1)","v":"2019-01-01"},{"$f":"DATE(H3,1,1)","v":"2020-01-01"}]
[null,"Pâques",{"$f":"ROUND(DATE(Année,4,MOD(234-11*MOD(Année,19),30))/7,)*7-6","v":"2015-04-05"},{"$f":"ROUND(DATE(D3,4,MOD(234-11*MOD(D3,19),30))/7,)*7-6","v":"2016-03-27"},{"$f":"ROUND(DATE(E3,4,MOD(234-11*MOD(E3,19),30))/7,)*7-6","v":"2017-04-16"},{"$f":"ROUND(DATE(F3,4,MOD(234-11*MOD(F3,19),30))/7,)*7-6","v":"2018-04-01"},{"$f":"ROUND(DATE(G3,4,MOD(234-11*MOD(G3,19),30))/7,)*7-6","v":"2019-04-21"},{"$f":"ROUND(DATE(H3,4,MOD(234-11*MOD(H3,19),30))/7,)*7-6","v":"2020-04-12"}]
[null,"Lundi de Pâque",{"$f":"C5+1","v":"2015-04-06"},"2016-03-28","2017-04-17","2018-04-02","2019-04-22","2020-04-13"]
[null,"Fête du Travail  ",{"$f":"DATE(Année,5,1)","v":"2015-05-01"},{"$f":"DATE(D3,5,1)","v":"2016-05-01"},{"$f":"DATE(E3,5,1)","v":"2017-05-01"},{"$f":"DATE(F3,5,1)","v":"2018-05-01"},{"$f":"DATE(G3,5,1)","v":"2019-05-01"},{"$f":"DATE(H3,5,1)","v":"2020-05-01"}]
[null,"Victoire 1945 ",{"$f":"DATE(Année,5,8)","v":"2015-05-08"},{"$f":"DATE(D3,5,8)","v":"2016-05-08"},{"$f":"DATE(E3,5,8)","v":"2017-05-08"},{"$f":"DATE(F3,5,8)","v":"2018-05-08"},{"$f":"DATE(G3,5,8)","v":"2019-05-08"},{"$f":"DATE(H3,5,8)","v":"2020-05-08"}]
[null,"Ascension ",{"$f":"Paques+39","v":"2017-05-26"},{"$f":"D5+39","v":"2016-05-05"},{"$f":"E5+39","v":"2017-05-25"},{"$f":"F5+39","v":"2018-05-10"},{"$f":"G5+39","v":"2019-05-30"},{"$f":"H5+39","v":"2020-05-21"}]
[null,"Pentecôte ",{"$f":"Paques+49","v":"2017-06-05"},{"$f":"D5+49","v":"2016-05-15"},{"$f":"E5+49","v":"2017-06-04"},{"$f":"F5+49","v":"2018-05-20"},{"$f":"G5+49","v":"2019-06-09"},{"$f":"H5+49","v":"2020-05-31"}]
[null,"Lundi de Pentecôte ",{"$f":"Paques+50","v":"2017-06-06"},{"$f":"D5+50","v":"2016-05-16"},{"$f":"E5+50","v":"2017-06-05"},{"$f":"F5+50","v":"2018-05-21"},{"$f":"G5+50","v":"2019-06-10"},{"$f":"H5+50","v":"2020-06-01"}]
[null,"Fête Nationale ",{"$f":"DATE(Année,7,14)","v":"2015-07-14"},{"$f":"DATE(D3,7,14)","v":"2016-07-14"},{"$f":"DATE(E3,7,14)","v":"2017-07-14"},{"$f":"DATE(F3,7,14)","v":"2018-07-14"},{"$f":"DATE(G3,7,14)","v":"2019-07-14"},{"$f":"DATE(H3,7,14)","v":"2020-07-14"}]
[null,"Assomption ",{"$f":"DATE(Année,8,15)","v":"2015-08-15"},{"$f":"DATE(D3,8,15)","v":"2016-08-15"},{"$f":"DATE(E3,8,15)","v":"2017-08-15"},{"$f":"DATE(F3,8,15)","v":"2018-08-15"},{"$f":"DATE(G3,8,15)","v":"2019-08-15"},{"$f":"DATE(H3,8,15)","v":"2020-08-15"}]
[null,"Toussaint ",{"$f":"DATE(Année,11,1)","v":"2015-11-01"},{"$f":"DATE(D3,11,1)","v":"2016-11-01"},{"$f":"DATE(E3,11,1)","v":"2017-11-01"},{"$f":"DATE(F3,11,1)","v":"2018-11-01"},{"$f":"DATE(G3,11,1)","v":"2019-11-01"},{"$f":"DATE(H3,11,1)","v":"2020-11-01"}]
[null,"Armistice 1918",{"$f":"DATE(Année,11,11)","v":"2015-11-11"},{"$f":"DATE(D3,11,11)","v":"2016-11-11"},{"$f":"DATE(E3,11,11)","v":"2017-11-11"},{"$f":"DATE(F3,11,11)","v":"2018-11-11"},{"$f":"DATE(G3,11,11)","v":"2019-11-11"},{"$f":"DATE(H3,11,11)","v":"2020-11-11"}]
[null,"Noël ",{"$f":"DATE(Année,12,25)","v":"2015-12-25"},{"$f":"DATE(D3,12,25)","v":"2016-12-25"},{"$f":"DATE(E3,12,25)","v":"2017-12-25"},{"$f":"DATE(F3,12,25)","v":"2018-12-25"},{"$f":"DATE(G3,12,25)","v":"2019-12-25"},{"$f":"DATE(H3,12,25)","v":"2020-12-25"}]